Consumer goods · US marketplaces · system 3 of 3
DiscoverNight · Accounting ledger
Every transaction reaches the books without manual reconciliation.
In short
Each export is checked, deduplicated, mapped and posted into QuickBooks Online under repeatable controls. SKU-level margin visibility came out of it for free.
- CONTROL
- Stack: Azure, QuickBooks Online, Power BI
- 56,000
- line items posted with zero reconciliation issues
- 1,500
- skilled labour hours automated each year
From export to ledger
Operating flow01
Bottleneck
- Payouts arrived net of commissions, refunds and adjustments, and the underlying transactions never reached the ledger. The books stayed incomplete for years.
- Reconciliation meant reading tens of thousands of rows by hand, which is slow, error-prone, and a reporting and tax risk.
02
Solution
- An Azure order database captures every revenue-related transaction from the order system into raw, canonical and reporting layers, with audit logging on each.
- Six checks run on every export, deduplication happens at database level, and channel mappings, revenue-recognition timing and accrual rules live in configuration, so finance can change a rule without a code deployment.
- Finance reviews the exceptions and maps a new transaction type once. After that, entries post to QuickBooks at SKU level on their own. Posting is idempotent, so a retried run never posts twice. Power BI reports off the same database.
03
Result
- 56,000 line items posted year to date with zero reconciliation issues.
- 1,500 skilled hours automated each year, and SKU-level margin visibility as a by-product.