Did we actually make money?
Net sales after refunds and fees, per branch and per channel — not gross, not before the marketplace takes its cut.
Read this first · no call, no form
One month, reconciled.
Three marketplaces, one POS, one bank statement — arriving as one number, every morning, without anyone opening a reconciliation sheet.
This is the report I build for a small retailer. Filter it, read it, forward it to whoever needs it. Everything here is sample data, generated from the same shape as a real Shopee / Tokopedia / POS / bank month — the numbers are invented, the questions it answers are not.
What it answers
Three questions, every morning
Why is the bank different?
Every rupiah that arrived at the bank but is not matched to an order, with the likely reason attached. This is the argument that happens on the 3rd of every month.
What should we reorder, and when?
Months of cover per product against what is actually selling. A spreadsheet sorted by alphabetical order is not a reorder list.
The report
Last month, as it would have arrived
Period
Branch
Channel
| Category | Orders | Net sales | Refunds |
|---|
The part that takes the time
Why the bank says something else
Every month this is the sheet someone rebuilds from scratch. Here is one month of it, with each difference given a cause instead of a shrug.
May 2026 · BCA · account •••• 4471
Reconciled 29 May, 07:14
| Date | Reference | Expected | Bank | Diff | Cause |
|---|---|---|---|---|---|
| 28 May | SS-88214 | Rp 4.250.000 | Rp 4.250.000 | 0 | Matched |
| 28 May | TK-11907 | Rp 1.875.000 | Rp 1.875.000 | 0 | Matched |
| 29 May | SS-88231 | Rp 2.100.000 | — | Rp 2.100.000 | Settlement T+1. Lands 30 May. |
| 29 May | SS-88240 | Rp 3.400.000 | Rp 3.318.600 | Rp 81.400 | Marketplace fee 2.4%. Net settlement is post-fee. |
| 29 May | TK-11922 | Rp 940.000 | Rp 916.800 | Rp 23.200 | Marketplace fee 2.5%. |
| 29 May | SS-88251 | Rp 560.000 | Rp 280.000 | Rp 280.000 | Refund issued 27 May, funds still in transit. |
| 29 May | — | — | Rp 640.000 | Rp 640.000 | Unexplained. No matching order. Needs a human. |
| Net variance to explain | Rp 3.124.600 | 6 of 7 explained | |||
What it costs
Most common
If your exports are clean
The report that builds itself
Rp 10.000.000 Rp 7.500.000
One build, fixed scope and price. Your three exports land every morning and the report above arrives on its own. You own the code, the data and the server.
- Delivered in 2–3 weeks
- Fixed price, agreed before work starts
- You keep everything, including the source
Your data person, on call
from Rp 4.000.000 / month
The build, then I keep it running. New products, new marketplaces, a new branch — the report keeps up without a new project.
- Cancel with 30 days' notice
- Same person who built it
- Priority when something breaks
If you have nothing exportable yet, this is not the right engagement and I will say so on the call. The first thing I check is whether your data already exists somewhere.
Next
Send me three exports
Shopee, Tokopedia, your POS, a bank statement. Any three. I reply with a sample of your numbers — not this page, yours — and two paragraphs on what I would do first.
The paid audit is this exact report, on your real exports, in five working days. Rp 2.500.000, credited in full against a build.
I reply within one business day (Jakarta, UTC+7).