Order pipeline
Each Amazon order becomes a sales receipt in QuickBooks, with its fees broken out.
Clients · Consumer goods · Retail and Amazon
Amazon and wholesale accounting, connected to QuickBooks.
A consumer-goods brand sells by the case to grocery chains and by the unit on Amazon. We connected Amazon to QuickBooks so every order, fee and refund is recorded, and the books can be explained down to the order.
- Industry
- Consumer goods
- Channels
- Grocery retail and Amazon
- Engagement
- Fixed-scope project, then hourly
- Live since
- February 2026
- Tools
Amazon
QuickBooks
n8n
PostgreSQL
Telegram
BeforeOrders, fees and refundsAmazonPurchases bought in casesQuickBooksOrders from grocery chainsRetail
Orders, fees and refundsAmazonPurchases bought in casesQuickBooksOrders from grocery chainsRetail
Built by Alma IntelIntegration + database- Order pipeline
- Case-to-unit conversion
- Refund and fee reconciliation
- Daily exception check
NowEvery order recordedQuickBooksA daily summary of anything that does not matchTelegram and emailRetailer invoices by EDI (in progress)EDI
Every order recordedQuickBooksA daily summary of anything that does not matchTelegram and emailRetailer invoices by EDI (in progress)EDIThe situation
Where they started.
Amazon sales, fees and refunds were keyed into QuickBooks by hand. Stock was bought in cases and sold in units, so inventory never quite matched, and the books rarely agreed with what Amazon actually paid out.
At month-end the accountant spent days trying to explain the difference.
What we built
The pieces.
Case-to-unit conversion
Purchases arrive in cases and are converted, so stock is always counted in units.
Refund and fee reconciliation
Reads Amazon’s event feed and matches every refund and fee to its order.
Daily exception check
Flags unmatched sales, refunds without an order and unmapped products. The target is zero.
A normal day
How it works now.
- Overnight, new orders, fees and refunds are pulled from Amazon.
- They are recorded in QuickBooks and matched to the payout.
- In the morning the team gets a short summary of anything that does not match.
- The accountant starts the month from books that already tie to Amazon.
In numbers
What it handles.
577historical orders replayed to test the books
5automated workflows running every day
Feb 2026in production since
Figures from the live systems, October 2026. Client name withheld.
What’s next
Where it goes from here.
A line-by-line inventory reconciliation surfaced damaged stock and logistics problems. Now: EDI with a national grocery chain and an app that reads purchase orders from PDF and email.