A balance sheet is a snapshot of what your business owns (assets), owes (liabilities), and has built up (equity). Most small operators never create one because it requires manual accounting. Ecom Forward auto-derives every line.
As-of-date picker
At the top of the tab: a date picker. The balance sheet is rendered as if it's the end of that date. Useful for:
- Year-end snapshots.
- Investor due diligence.
- Tracking how equity has grown over time.
Assets (auto-derived)
- Cash balance — opening cash + cash entries + Shopify payouts.
- Inventory value — sum of
product_settings.inventory × cogs_tier_1per store (filters outno_stock_trackingproducts). - Pending Shopify payouts — payouts with status in
('scheduled', 'in_transit'). Sitting at Shopify, not yet in your bank. - Custom asset entries — any manually entered asset (equipment, AR, receivables).
Liabilities (manual)
- Loans, credit card balances, accounts payable — entered manually via + Add entry.
- Categorize by custom category for reporting.
Equity
- Owner contributions — manual entries for capital you've injected.
- Retained earnings — auto-derived: cumulative net profit from inception to as-of-date (capped at 5 years for perf).
Working capital
At the bottom of the tab: Current Assets − Current Liabilities. Positive = healthy operating runway. Negative = you're funding today's ops with tomorrow's revenue.
Custom balance categories
Extend the built-in categories for specialized line items — vehicle, intellectual property, goodwill, etc. Same pattern as Cash Flow categories.