Orders that book themselves
The part every seller hates. Each order flows through a FIFO cost-of-goods pipeline into double-entry books — gateway fees split out, PO buyers routed to receivables, and bank statements reconciled against what the system already knows.
What it does
Bookkeeping that keeps up with sales
- FIFO COGS posting. Orders consume inventory lots in cost order and post the matching cost of goods to your books.
- Double-entry ledger. Revenue, COGS, gateway fees, and clearing accounts are split correctly per transaction.
- Multi-channel. The same pipeline handles WooCommerce and eBay orders.
- Accounts-receivable routing. Purchase-order orders are rerouted to an A/R account instead of cash.
- Service & upgrade fees. Virtual SKUs capture service charges and upgrades cleanly.
- Bank reconciliation. Parse multiple statement PDFs and match them to the ledger in a guided UI.
- Sales tax on quotes & orders via a rooftop-accurate engine with an offline fallback table.
| Cost method | FIFO lot consumption → COGS history |
|---|---|
| Books | Double-entry (GnuCash-compatible), per-tenant book |
| Run modes | Dry-run preview → production post |
| Fee handling | Gateway-fee + clearing-account splits per order |
| A/R | PO-order detection reroutes to receivables |
| Reconciliation | Multi-PDF parse + match-to-ledger UI |
| Tax | TaxJar rooftop → static table fallback |
Integrations
| Integration | Required |
|---|---|
| WooCommerce REST | Yes |
| MariaDB | Yes |
| Double-entry book (GnuCash) | Yes |
| Payment gateway | Yes |
| Tax engine (TaxJar/native) | Yes |
| eBay | If selling on eBay |
In practice
One order, posted to the books
| Account | Debit | Credit |
|---|---|---|
| Cash clearing (Stripe) | $3,142.18 | |
| Gateway fees | $93.82 | |
| Sales income | $3,054.00 | |
| Sales tax payable | $182.00 | |
| Cost of goods sold (FIFO) | $1,987.40 | |
| Inventory asset | $1,987.40 |
FIFO cost pulled from the oldest lots consumed by this order.
What just happened
Order #10482 came in at $3,236. The pipeline split the payment into sales income and the gateway’s processing fee, posted the sales tax to its liability account, and — the part most tools skip — pulled the matching FIFO cost of goods from the exact inventory lots the order consumed, crediting the inventory asset by the same amount.
Every order does this automatically, in dry-run first so you can preview, then to the books. PO customers route to accounts receivable instead of cash, and month-end bank statements reconcile against entries the system already made.
- True margin per order, not an end-of-month guess
- Gateway fees and tax split correctly every time
- A/R kept separate from cash for PO buyers
Cost accuracy starts at receiving
COGS is only as good as your landed costs. Pair accounting with supplier & purchasing.
Supplier & purchasing → See plans