Help — FLC Multiple Warehouse
Help & Documentation
Ask a question, browse the operations checklists below, or jump into the full documentation library.
Type a question — the AI checks the documentation and points you to the right section.
Operations checklists
Two routines keep your books and inventory tied out: a daily list for work that happens within an open accounting period, and a closing list for the steps that lock a period and push everything to QuickBooks Online.
Within the period
Daily / weekly
Pull the product list from Accounting Platform so FLC's catalog matches it — and matches what your warehouses are reporting on. Set warehouse-by-warehouse starting qty and a unit cost on any new SKU. Alert: if a warehouse upload references a SKU FLC doesn't have, the import flags it — add the product before retrying so the period foot has every line.
One upload per warehouse — the platform's movement ledger gives FLC the full set: starting balance (= prior period's ending), customer shipments, customer returns, receipts, and ending on-hand. Amazon FBA Inventory Ledger, Shopify Inventory + Orders, Walmart Inventory + Orders, plus 3PL / IMS snapshots are all parsed automatically. Within-period uploads stage as pending on the Warehouses tab; the Footing tab compares them to FLC's calculated period chain so you can Apply / Explain / Dismiss.
Pull every vendor bill the operator entered in Accounting Platform — qty per SKU and unit cost. Each line becomes a cost layer; FIFO consumes the oldest layer first when shipments are recorded. Accounting Platform stays the system of record for A/P; FLC just reads units and cost. Same flow for overhead bills (freight, duties, 3PL fees) on /overhead.
Per-SKU Invoice / Sales Receipt / Credit Memo lines from Accounting Platform for the period, aggregated and deduplicated. Feeds revenue recognition + the sales-cutoff foot. Accounting Platform stays the source of truth for invoiced activity; FLC reads units and dollars and uses them at close.
Most transfers between warehouses you also upload from will already show up in step 2 — outbound as a shipment on the source's report, inbound as a receipt on the destination's. They self-foot, no entry needed. Only record an explicit transfer when stock moved between warehouses where one side won't appear in an upload, or when you want a single audit-trail reference linking both sides.
Returns are already captured in the warehouse upload from step 2 — no separate step. This is for shrinkage / damage / write-offs that aren't on the warehouse report (e.g., a physical recount that found stock short). Writes off the cheapest available cost layer first.
Mid-period sanity check. Upload the latest warehouse report, then read off: last month's ending balance + receipts on the new upload − shipments on the new upload = current on-hand. Anything off? Flag it now — easier to catch a missing receipt mid-period than the day before close.
Recalculates the cost layers using the purchases pulled in step 3 and walks each layer through the shipments captured in step 2. FIFO by default; weighted-average available. The per-product report flags anything missing a unit cost or a cost layer before it bites you at month-end.
Per-SKU revenue minus product COGS, channel fees, fulfillment, and ad spend — the margin that actually clears for each unit sold. Surfaces SKUs that look profitable on COGS alone but lose money once channel fees and ads are layered in.
Closing a period
Once per month
Pull the product list from Accounting Platform so FLC's catalog matches it — and matches what your warehouses are reporting on. Set warehouse-by-warehouse starting qty and a unit cost on any new SKU. Alert: if a warehouse upload references a SKU FLC doesn't have, the import flags it — add the product before continuing the close.
One upload per warehouse — the platform's movement ledger gives FLC the full set: starting balance (= prior period's ending), customer shipments, customer returns, receipts, and ending on-hand. Amazon FBA Inventory Ledger, Shopify Inventory + Orders, Walmart Inventory + Orders, plus 3PL / IMS snapshots are all parsed automatically. The whole close hangs on this — every other step ties out to these uploads, not the system count.
Pull every inventory bill the operator entered in Accounting Platform for the period — qty per SKU and unit cost. Each line becomes a cost layer; FIFO consumes the oldest layer first when shipments are recorded. Receipts feed the period foot (Beg + Receipts − Ship + Returns − Write-offs = End) and they're the input that makes COGS calculate correctly in step 8 — so this step has to happen before the foot.
Per-SKU Invoice / Sales Receipt / Credit Memo totals from Accounting Platform for the closing period. Drives the sales-cutoff foot at step 9 and the revenue side of the JEs at step 10. Accounting Platform stays the system of record for invoiced activity; FLC reads units + dollars.
Layer 2 — overhead bills (storage, freight, customs, 3PL fees) absorb into cost layers. Run this BEFORE COGS — COGS consumes cost layers, so any inventoriable overhead has to be absorbed into the layers first or the COGS rate will be light.
Recalculates the cost layers using the period's Accounting Platform purchases (step 4) and walks each layer through the period's shipments (step 3). FIFO by default; per-product override with a reason. This is the adjusting JE to Accounting Platform — derived from the same shipment + cost-layer inputs the foot in step 8 reconciles against.
Per-SKU period foot: Beg + Receipts − Shipments − Adjustments + Returns + Deferred COGS Adj = Calc Ending, then foots to Whse Ending (warehouse upload) with Variance as the close gate. + In Transit = Book Ending (what posts to GL Inventory Asset). Apply / dismiss the counts here; the same data drives the COGS JE in step 7 and the cutoff JE in step 9. Warehouse uploads are the source of truth — we never adjust off the QuickBooks Online cross-foot.
First, confirm all transactions are in:
- Last platform inventory CSV uploaded (Amazon / Shopify / Walmart)
- Any direct-in-Accounting Platform sales pulled (sales receipts and invoices not from a connector)
- Last bills entered — no missing receipts
- No outstanding transfers in flight (every transfer has a destination)
- Returns and shrinkage adjustments recorded for the period
Then review and post. One page lists every JE FLC needs to write back to Accounting Platform: COGS, overhead allocations, transfers between warehouses, inventory adjustments (shrinkage / returns / write-offs), and the period reconciliation entry. Sales receipts and invoices stay in Accounting Platform untouched — we never write revenue. Post per-section or all at once; every entry is balanced (debits = credits within $0.01) before we send.
COGS report, valuation, footing report, true-up. Save / export for your accountant.
Once you lock it, no further transactions can be backdated into this month. Reopen only if absolutely necessary; every reopen is logged. The lock refuses if any (warehouse, SKU) row from step 8 has missing upload or unexplained variance.
Still stuck?
The team replies within one business day. For urgent issues affecting QuickBooks Online sync or your books, call us directly.