7 Red Flags in an Ecommerce Balance Sheet

An ecommerce balance sheet hides trouble better than a profit and loss statement does, because the P&L only covers one period while the balance sheet carries every unresolved mistake forward forever. Seven items on it tell you something is wrong: inventory that never moves in step with sales, an undeposited funds account that keeps growing, negative inventory quantities, a sales tax liability that only goes up, shareholder loans doing the work of a credit line, accounts receivable on a business that takes payment at checkout, and a suspense or ask-my-accountant account with a balance in it.

Each of these has a specific cause, and each points at a different part of the bookkeeping.

1. Inventory value that does not track sales volume

Pull twelve months of closing inventory next to twelve months of revenue. The two lines should move with some relationship to each other. If revenue doubled in Q4 and the inventory asset barely moved, cost of goods sold is not being recorded against the right periods.

For scale, the US Census Bureau’s Monthly Retail Trade Survey put the retail trade inventories to sales ratio at 1.25 for June 2026 on a seasonally adjusted basis, meaning retailers held roughly 1.25 months of inventory against one month of sales. That figure varies enormously by category in the same data: clothing and clothing accessories sat at 2.14, while food and beverage sat at 0.76. Your own ratio does not need to match the national number. It needs to be stable and explainable.

2. Undeposited funds growing month over month

Undeposited funds is a holding account. Money sits there between the moment a sale is recorded and the moment a real bank deposit is matched against it. The balance should rise and fall. It should not climb in a straight line.

A permanently growing undeposited funds balance almost always means deposits are being recorded twice: once as a lump settlement from the bank feed, once as individual sales that never got cleared out. Revenue is overstated by exactly that amount.

3. Negative inventory quantities

A negative quantity on hand is not a small formatting problem. It means the system recorded a sale of a unit it did not know existed, which forces the accounting software to guess at the cost. Most systems guess using the last known cost or zero, and both answers are wrong.

The usual cause is ordinary and fixable: purchase orders and receipts entered after the sales that consumed them. A single negative quantity is a data entry lag. A standing list of them means gross margin is fiction, because a meaningful slice of your units are being expensed at an invented cost.

4. A sales tax liability that only increases

Marketplace facilitator laws shifted collection duty onto the marketplaces for most seller transactions, which means a lot of the tax showing up in your books was never yours to remit. If the liability account grows every month and never gets drawn down by a payment, one of two things is happening. Either tax is being collected and not filed, which is a real problem, or marketplace collected tax is being booked as your liability when the marketplace already remitted it, which overstates what you owe on paper.

Sorting this out requires knowing which states treat which marketplaces as the collecting party, and the rules and nexus thresholds change. The state’s own department of revenue is the authority, and this is a question for a tax professional rather than a bookkeeping cleanup.

5. Shareholder loans used as working capital

A due-to-owner or shareholder loan account with a climbing balance is a cash flow signal wearing an accounting costume. The business is not funding its own inventory cycle, and the owner is covering the gap personally.

This is more common than founders assume. In the 2026 Report on Employer Firms from the Federal Reserve Banks, drawn from the 2025 Small Business Credit Survey, 54 percent of employer firms that faced financial challenges said they used personal funds in response, and 50 percent of all firms reported uneven cash flow as a challenge. Among retail firms specifically, 55 percent used personal funds. Owner capital filling an inventory gap is not automatically a crisis. It becomes one when nobody is tracking how large the gap has grown or what the business would do without it.

6. Accounts receivable on a business that collects at checkout

A direct to consumer seller charges the card before the box ships. There should be almost no accounts receivable. Wholesale and retail distribution create real receivables, and so do some B2B arrangements. Nothing else should.

When AR appears on a pure marketplace seller’s balance sheet, it is usually the byproduct of invoices created to record marketplace sales that were then paid by settlement deposit and never matched. The invoices sit open forever. Revenue gets counted once when the invoice is raised and again when the deposit is booked as income.

7. Anything sitting in a suspense or ask-my-accountant account

Every accounting system has a parking space for transactions nobody could classify. A balance in it at month end means the books are not finished. A balance in it at year end means the tax return is built on transactions nobody understood.

The size matters less than the age. A $400 balance from last week is a question waiting to be answered. A $400 balance from fourteen months ago is a question nobody is ever going to answer, and it will be silently absorbed into an adjusting entry that makes the balance sheet tie without making it true.

What causes most of this

Six of these seven red flags trace back to the same structural problem: marketplace settlements arrive as net lump sums, and someone has to decompose them into gross sales, fees, refunds, reserves, and tax. Do it by hand and the errors compound in the balance sheet accounts rather than the income statement, which is exactly why they go unnoticed.

This is the job that settlement reconciliation tools exist to do. Platforms in this category include A2X, Link My Books, Synder, Entriwise, Taxomate, and ConnectBooks, which syncs Amazon, Shopify, Walmart, TikTok Shop, and eBay into QuickBooks Online, QuickBooks Desktop Enterprise, or Xero. They differ in whether they post summarized or per transaction entries and whether they own inventory or expect a separate system to. None of them fixes a balance sheet that is already wrong, though. Automation applied on top of a broken opening balance just produces wrong numbers faster.

The order to fix them in

Work backward from the accounts that corrupt everything downstream.

Start with inventory, because negative quantities and bad cost layers poison gross margin in every future period. Clear undeposited funds next, since it drives double counted revenue. Then reconcile the sales tax liability against what was actually remitted and by whom. Shareholder loans, stale receivables, and the suspense account are cleanup rather than contamination, so they can wait.

One practical note: resist the urge to write off an unexplained balance just to make the statement look clean. A forced adjusting entry moves the error, it does not remove it, and the next person who reads these books will have no way to find what happened.