Reports

Lot Valuation

Click Load to view lot valuations.

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 TypeDebit AccountCredit Account
Inventory ReceiptInventory AssetAccounts Payable
CBP Duty / FeesInventory AssetAccounts Payable (US Customs)
COGSCost of Goods SoldInventory Asset
FX GainAccounts PayableFX Gain Income
FX LossFX Loss ExpenseAccounts Payable

Note: Account names must match exactly what you have in QuickBooks. Edit the export if needed.

🛒 Sales by Channel

Total orders, units sold, and revenue broken down by sales channel (Shopify, Amazon, Chewy, etc.).

Select a date range and click Load, or click All Time.

📅 Monthly Inventory & COGS Export

Matches the Anna / Dana monthly template — Beginning Inventory, Receipts by Supplier, Sales & COGS by Channel (Shopify / Amazon / Chewy), Ending Inventory.

Select a month and click Preview to generate the report, or Download CSV to get the file directly.

🔍 Duplicate Import Check

Check whether any sales file was uploaded more than once. Detects: duplicate order references across imports, and imports whose date ranges overlap.

Select a source and click Run Audit to check for duplicate uploads.

📊 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.