Multi-retailer reporting for wholesale suppliers

Every retailer you sell through, reconciled in one view.

Your retailers each send sales in their own shape. DataOZ maps every feed once, then reports gross, commission, GST and net payout the same way across all of them. You see which retailer pays what, which store is growing, and which product still earns after deductions.

Built for suppliers selling through several retailers at once. Running on Harris Farm Markets consignment data today.
3+formats & APIs, in
1payout figure, every retailer
50k+rows processed
0reconciliations by hand
The reconciliation problem

Nine retailers. Nine different answers.

One retailer emails a twelve-tab workbook. Another sends a CSV with totals in the wrong row. A third shares a Drive folder that never stops filling up. Each takes a different commission on a different basis, so the one number you need, what you actually earned per retailer, is the one number nobody sends you.

Different columns every timeEach retailer names things their own way, so nothing adds up across them.
Footer rows that break your sumsTotals, blanks and notes at the bottom poison every formula above them.
No margin view across retailersYou can see one retailer, or one week. Never which of them is actually worth supplying.
How it works

Three steps from inbox to insight.

Set a source up once. After that, new files flow straight into the same clean numbers.

01 / Connect

Point it at any source

Upload Excel or CSV, link a Google Sheet or Drive folder, or connect a REST API. The source side is dynamic, so new connectors slot into the same pipeline.

drop file
02 / Map once

The classifier reads the columns

DataOZ tags each column on its own: date, product, revenue, store. You confirm the mapping once, and it remembers the shape of that file forever.

Desc $ Amt Store product revenue location
03 / See everything

Dashboards build themselves

Revenue over time, top products, store by store, all live and filterable by date and location. Export any of it to a clean spreadsheet.

REVENUE $142k UNITS 41k
Connect anything

Any source. Any shape. One schema.

Files are only the start. If it outputs rows, DataOZ can read it, and because the schema is built per source, no two feeds ever have to look alike.

Excel CSV Google Sheets Google Drive REST API Plain text / TSV POS exports Custom connector pluggable

A source that isn't listed yet? The connector framework is pluggable. New sources slot into the same mapping, cleanup, and dashboards, without touching the ones you already run.

What's inside

Built for the way vendor data actually arrives.

Messy, inconsistent, and split across every retailer you sell to. DataOZ handles each part of that.

Smart column mapping

Merged cells, cryptic headers, supplier code prefixes. The classifier works out what each column means, so you don't remap every file by hand.

Every source, one view

Excel, CSV, Google Drive, a REST API, or a custom connector. Every retailer's feed lands in one set of numbers you can trust.

One clean product list

"SRD Sourdough" and "Sourdough Loaf" become one product. Fuzzy matching catches the duplicates and merges them for you.

Consignment accounting

Set your own commission, GST, and deduction rules for each retailer. DataOZ works out gross, GST, commission, and net payout on every line, so your accounts team gets reconciliation-ready numbers instead of a shoebox of PDFs.

Google Drive sync

Drop this week's file in the shared folder. It flows in on its own, on a schedule, with no upload step for you.

Build-your-own reports

Pick your dimensions and metrics, get a table, export a clean .xlsx. Formula-safe, so nothing breaks when it opens.

The payoff

The view you've been rebuilding by hand.

One dashboard, drawn from every source you've connected. Filter by date, store, or product and it moves together, right down to the payout figures your accounts team needs.

app.dataoz.com.au / dashboards / sales-overview

Sales Overview

Export .xlsx
Date Last 12 weeks Source All sources Store All stores
Gross sales
$0
+11.4% vs prev 12 wk
Units sold
0
+6.2%
Active products
0
across 4 retailers
Stores
0
NSW · ACT

Revenue, last 12 weeks

weekly · AUD

Top products

by revenue
Sourdough$31.2k
Baguette$23.1k
Sourdough Rye$18.0k
Ciabatta$12.9k
Rye Loaf$9.1k

Consignment reconciliation

this period
Gross sales$142,700
− GST (10%)−$12,973
− Commission (15%)−$19,460
Net payout$110,267

Revenue by retailer

share
Harris Farm 62% IGA 24% Independents 14%
ProductStoreRetailerUnitsNet payout
SourdoughBondiHarris Farm1,240$7,192
BaguettePotts PointHarris Farm980$4,018
CiabattaMosmanHarris Farm610$2,904
Sourdough RyeManukaIGA545$3,461

Sample data shown for illustration.

Fits your stack

Your cleaned data, out via API.

DataOZ isn't a dead end. Pull mapped, deduplicated, GST-reconciled rows back out through a REST API or a scheduled Excel drop, straight into the tools you already run. The same API that reads your sources hands the clean version back.

Xero MYOB Power BI Google Sheets Your own BI
Your data stays yours

Isolated by default. Encrypted where it counts.

Your sales figures are commercially sensitive. DataOZ is built so they never touch another vendor's, and so you can walk away with them any time.

Per-vendor isolation

PostgreSQL row-level security walls your numbers off from every other vendor. It's enforced at the database, not just trusted to the app layer.

Encrypted connections

Your Google Drive tokens are encrypted at rest. DataOZ requests the narrowest access that works, and nothing more.

No lock-in

Export any report to a clean spreadsheet whenever you like. Your data is yours to take, in a format that opens anywhere.

Built and run in Australia

Made in Canberra for Australian vendors, with GST handled the way the ATO expects it.

Pricing

Priced per supplier, not per retailer.

Connect every retailer you sell through for one price. No per-file fees, no per-source charge, no extra cost for the dashboards your team builds.

Starter

A pilot on one retailer, before you connect the rest.

$49/ mo
  • 1 data source
  • File upload (Excel & CSV)
  • Core dashboards
  • Product catalog
Start a pilot
Most popular
Growth

Every retailer in one view, synced and reconciled.

$149/ mo
  • Unlimited data sources
  • Google Drive auto-sync
  • Build-your-own reports + Excel export
  • Consignment accounting
Book a demo
Pro

For suppliers with high volume and hands-on setup.

Let's talk
  • Everything in Growth
  • Priority onboarding
  • Custom cleanup rules
  • Extra storage & history
Contact us

Prices in AUD, exclusive of GST · Placeholder pricing pending launch · Running a pilot? Ask about the free tier.

Get started

Find out what each retailer really pays you.

Send one file from each retailer. We map them and show you the reconciled view in fifteen minutes, with nothing to set up on your end.

No credit card. We'll reply within a business day.