Help — FLC Multiple Warehouse

← Back

Help & Documentation

Ask a question, browse the operations checklists below, or jump into the full documentation library.

Ask the docs

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

1
Download products from Accounting Platform

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.

Products →
2
Get starting balance, shipments, returns, receipts, and ending balance from warehouses

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.

Imports →
3
Pull purchases (qty + cost) from Accounting Platform

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.

Purchases →
4
Pull sales from Accounting Platform

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.

Sales →
5
Record warehouse transfers

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.

Transfers →
6
Record shrinkage and write-offs

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.

Adjustments →
7
Spot-check inventory

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.

Inventory →
8
Calculate COGS on period sales

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.

COGS →
9
Calculate contribution margin on period sales Coming soon

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.

Coming soon

Closing a period

Once per month

1
Set the closing date Last close: Dec 31, 2025 Period starts at your entity start date Jan 1, 2026 and runs through the date you pick — used everywhere downstream.
2
Download products from Accounting Platform

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.

Products →
3
Get starting balance, shipments, returns, receipts, and ending balance from warehouses

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.

Upload →
4
Pull purchases (qty + cost) from Accounting Platform

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.

Purchases →
5
Pull sales from Accounting Platform

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.

Sales →
6
Allocate warehouse overhead

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.

Overhead →
7
Calculate COGS

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.

COGS →
8
Foot and Adjustment

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.

Foot and Adjustment →
9
Review and Sync

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.

Review & Sync →
10
Generate the period reports

COGS report, valuation, footing report, true-up. Save / export for your accountant.

Reports →
11
Lock the period

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.

Period close →

Still stuck?

The team replies within one business day. For urgent issues affecting QuickBooks Online sync or your books, call us directly.

Contact support or call (702) 518-5976
Help