Episode 04 · Settle GL Reconciliation
Reconcile Settle, multi-channel revenue, and bank into one balanced GL.
Built for accounting firms with CPG/DTC clients on Settle. The workflow ingests Settle vendor payments + Shopify + Amazon FBA + bank, surfaces discrepancies, and outputs QBO-ready journal entries with a built-in balance check.
Accounting firms serving CPG/DTC
Use this as a per-client install. Saves your bookkeepers 4–8 hours/month per client on Settle reconciliation.
In-house finance at $3–15M CPG brands
If you're running finance for a brand on Settle + Shopify + Amazon, this is your monthly close in one workflow.
What it does
Settle ↔ Bank reconciliation
Matches Settle vendor payments to bank withdrawals with timing + amount tolerance. Flags amount mismatches.
Unmatched outflow detection
Surfaces manual ACH or wire payments that bypassed Settle, so they don't slip through the AP process.
Multi-channel revenue ties
Reconciles Shopify and Amazon FBA payouts against bank deposits. Captures Amazon fees as a separate expense line.
Balanced QBO-ready journal entries
12 JE lines covering AP, financing, interest, revenue, COGS. Built-in balance check row catches errors before they reach QBO.
What you get
The n8n JSON
18 nodes, fully wired. 5 input streams, Merge barrier, 2 Code nodes, parallel outputs.
6 sample CSVs
Realistic data for a $3.85M ARR CPG brand. Test against it before pointing at a real client.
Setup guide (PDF)
1-page quick start. Where to put files, how to swap in your client's real data.
Reconciliation + JE logic
Two Code nodes you can read, fork, and adapt. Constants at the top, clean detection rules below.
Know when the next workflow drops
One email per new episode. Built for accounting firms and finance teams.
No spam. One email per new episode. Unsubscribe in one click.
Want this installed for your CPG clients?
For accounting firms: I install and customize this workflow per-client as a white-label service. Fixed scope, 2 weeks, your bookkeepers stay in the relationship. Typical brand pays for the install inside 60 days of operating time savings.
Book a 20-min call →