Skip to content
Balance sheet

The third financial statement
most ecom tools skip.

Live Balance Sheet for your Shopify business — inventory valuation auto-derived from your Catalog, retained earnings calculated from cumulative profit, pending Shopify Payouts as receivables, and an as-of-date picker so you can pull a snapshot for any specific day. The statement your accountant, lender, or acquirer always asks for.

The gap

Most operators don't have one until they need it.

You're growing fine on a P&L. Then someone asks for a Balance Sheet — your accountant for tax season, a lender deciding whether to give you a $50K line of credit, an acquirer running diligence on your business. Suddenly you're spending a weekend reconstructing inventory values from invoices, calculating retained earnings from 18 months of P&Ls, and chasing what your bank balance was on December 31st.

The Balance Sheet you should have had all along would have made all of those conversations 30 minutes instead of 30 hours. And it would have surfaced things you didn't know about your business — like that 22% of your assets are tied up in slow-moving inventory.

The pattern: ecom analytics tools focus on P&L because that's what operators ask for. But the Balance Sheet is what investors, lenders, accountants, and acquirers ask for — and you don't get to control when those conversations happen.

How it works

Auto-derived from your real data.

Most lines populate themselves. The ones that need manual entry have a one-form-field UI, not a 12-tab spreadsheet.

01

Inventory value, computed live

Sum of every product's `inventory × cogs_tier_1` across every store. Updates whenever the catalog auto-syncs from Shopify (nightly + on-demand). Excludes products marked as no-stock-tracking and dropshipping items so you're not double-counting things you don't own.

  • Tier-based COGS support — high-volume tier-3 prices apply at scale
  • Per-store breakdown so you can see which inventory location drives the bulk
  • Updates same-day when you adjust a product's COGS in the Catalog
02

Retained earnings, computed live

Cumulative net profit from inception to your selected as-of date. Pulled from your daily entries + operating expenses + business expenses with proper recurring-expense expansion. The number that tells investors whether your business has actually built equity over time.

  • Covers up to a 5-year history — virtually every Shopify operator's range
  • Reflects every manual P&L correction you've made — no double-accounting
  • Per-store profit aggregates correctly across multi-store portfolios
03

Pending Shopify Payouts as assets

Money that's sold but not yet deposited counts as a current asset. The nightly Shopify Payments sync pulls every payout in scheduled or in-transit status into your Balance Sheet automatically — so the gap between sale and bank deposit doesn't create a phantom hole in your asset base.

  • Refreshed daily from Shopify's payouts endpoint
  • Settles into Cash the moment Shopify marks a payout paid
  • Stores not on Shopify Payments fall back to manual entry
04

As-of-date picker

Default is today, but type any date and the entire Balance Sheet recomputes for that snapshot. Need year-end for taxes? Pick December 31. Need a moment-in-time for a board meeting? Pick that date. Cash, inventory, retained earnings — all filtered to entries on or before.

  • All four auto-derivations respect the as-of-date
  • Manual entries also filter — your December 31 inventory adjustment shows when you pick year-end
  • Not persisted across sessions so it's safe to experiment
When it matters

Three conversations this saves you from.

Tax season

Your accountant emails on January 5: "Send me a Balance Sheet as of December 31." Without one, you spend a weekend rebuilding inventory and reconciling cash from receipts. With one, you set the as-of date, screenshot the page, and reply in 30 seconds.

Line of credit

A lender wants to extend a $50K working-capital line. They need 12 months of P&L plus a current Balance Sheet that shows inventory as an asset, payables as a liability, and retained earnings as equity. You either have it, or you spend a week building it from scratch — and the lender goes elsewhere meanwhile.

Acquisition diligence

A buyer is interested. Their first ask: monthly Balance Sheets for the last 24 months. Without a tool, you're spending two weeks digging through bank statements, supplier invoices, and Shopify exports. With one, you export 24 monthly snapshots in 24 minutes — and the diligence call happens this week instead of next quarter.

The wedge

What about the other Shopify analytics tools?

Almost none ship a Balance Sheet. BeProfit, Lifetimely, TrueProfit, Polar Analytics, TripleWhale — all P&L-and-attribution focused, no Balance Sheet surface. Operators who need one route through QuickBooks or Xero, which means dual data entry and a constant reconciliation problem.

Ecom Forward includes the full Balance Sheet at every tier including Captain at $99/mo. Same data source as your P&L, no double-entry.

Ready?

Have a Balance Sheet ready
before someone asks for one.

7-day free trial, every feature at every tier, cancel anytime. The Balance Sheet populates from your historical Shopify data the moment you connect — no spreadsheet imports, no double-entry.

7-day free trial · cancel anytime · live in 10 min