Reports
Accounting Equation
Beginning Inventory + Purchases − COGS = Ending Inventory
Save Period Snapshot
Set Opening Balance
Use this to anchor the January 2026 bookkeeper figure ($1,053,946.56 end-of-month).
Lot Valuation
Click Load to view lot valuations.
COGS by SKU
Select a period and click Load.
Expiry Watchlist
Uncosted Lots
These lots have no unit cost assigned. COGS will record $0 when they are depleted. Go to Costs or Inventory to link them to a PO.
PO vs invoiced quantities
Each row is one PO line: ordered quantity on the PO vs total qty shipped on all supplier invoices linked to that PO. Invoiced qty is matched by SKU and ship-to warehouse (invoice line warehouse must match the PO line warehouse, or both blank).
Optionally filter by PO date, then click Load.
QuickBooks Journal Entry Export
Exports a General Journal CSV you can import directly into QuickBooks. Includes: inventory receipts (DR Inventory / CR AP), CBP duty, COGS (DR COGS / CR Inventory), and FX gain/loss.
QuickBooks Account Mapping
| Transaction Type | Debit Account | Credit Account |
|---|---|---|
| Inventory Receipt | Inventory Asset | Accounts Payable |
| CBP Duty / Fees | Inventory Asset | Accounts Payable (US Customs) |
| COGS | Cost of Goods Sold | Inventory Asset |
| FX Gain | Accounts Payable | FX Gain Income |
| FX Loss | FX Loss Expense | Accounts Payable |
Note: Account names must match exactly what you have in QuickBooks. Edit the export if needed.
Saved Period Snapshots
📊 Monthly Bookkeeper Report
COGS by SKU, ending inventory valuation, and FX gain/loss — formatted for Dana Nichols CPA.
Select a period and click Generate Report.