AIStatements

Ecommerce Financial Statements Generator for Shopify and Amazon Sellers

AIStatements generates ecommerce financial statements from a ledger export. You upload the trial balance or general ledger from your store books, and it returns an income statement with returns, discounts and cost of goods sold separated, a balance sheet that carries inventory, sales tax payable and unredeemed gift cards, and a cash flow that ties to the bank, plus written commentary on gross margin and ad spend. Plans start at $24 a month billed yearly.

Turn a QuickBooks, Xero or CSV export from your store into a P&L, balance sheet and cash flow that carry inventory, cost of goods sold and platform fees correctly, with written analysis, from $24 a month billed yearly.

From $24/mo · cancel anytime
Sample company

Generate statements from your own books · sample CSV

Software, not advice · Files parse in your browser, nothing is uploaded

Why online store books mislead the people who read them

Most small online stores run their books off the payout. Shopify, Amazon or another marketplace deposits the sales minus fees and refunds, and the bookkeeper records the deposit as revenue. That is convenient and it is wrong in three ways a lender, an investor or a buyer will find within an hour. Platform fees disappear from the expense lines, so net sales look lower than they were and the fee burden is invisible. Inventory purchases are expensed when paid rather than carried as an asset until sold. And money that belongs to someone else, sales tax collected and unredeemed gift cards, shows up as income.

A quarter for a mid-sized store shows the size of the gap. Gross sales are $240,000, returns and discounts are $21,000, so net sales are $219,000. Cost of goods sold is $98,550, or 45 percent of net sales, which leaves gross profit of $120,450. Payment processing fees are $7,300, outbound shipping $14,200, advertising $38,000 and software and other overhead $12,500. Net income is $48,450. The same quarter on a payout-and-payments basis reports revenue of $211,700 (the deposits), expenses the full $130,000 of inventory bought for the holiday season, and lands at a profit of $17,000. Nothing happened differently in the business. The books just described it differently, and the second version would get a loan declined.

What the generated ecommerce statements contain

The income statement starts with gross sales, then shows returns and discounts as a deduction so net sales are the figure margins are measured against. Cost of goods sold comes next, built from beginning inventory plus purchases minus ending inventory, so the $130,000 of stock bought in the quarter lands on the balance sheet and only the $98,550 that sold reaches the P&L. Processing fees, marketplace fees, shipping and advertising sit below gross profit, each on its own line, because ad spend as a share of net sales is the ratio an ecommerce reader checks right after gross margin.

The balance sheet shows inventory as a current asset, which in the example grows by $31,450 over the quarter (purchases of $130,000 less COGS of $98,550). It shows sales tax collected and not yet remitted as a current liability, and gift cards sold but not redeemed as deferred revenue. If the store sold $4,000 of gift cards in December and $1,100 were redeemed, $2,900 stays a liability and only $1,100 is revenue. Where the books never separated these accounts, the commentary flags the balance rather than guessing, so your accountant can confirm it before the pack leaves the building.

The cash flow statement then explains why a profitable quarter used cash. Net income of $48,450 is reduced by the $31,450 increase in inventory, which is the sentence every ecommerce owner needs to hear when the bank balance is lower than the P&L suggests. The inventory method itself is a tax and accounting choice, and the IRS explains the options in Publication 334. For the cash versus accrual question behind all of this, see GAAP versus cash basis accounting.

Who sends an online store pack, and where it goes

Store owners use the pack for an inventory line of credit, an SBA or bank loan, a seller-financing conversation or a sale on a broker marketplace, where the buyer wants three years of statements that tie to the tax return. Fractional CFOs and bookkeepers who run a roster of ecommerce clients use it to produce the same format every month, which fits the monthly financial reporting package. A seller with two or three channels can also send the same pack to the people who ask for numbers in different formats, rather than rebuilding it for each request.

The input is whatever your books already produce. A QuickBooks Online or Xero export works, as does a CSV trial balance from a spreadsheet. If your store books live in QuickBooks, QuickBooks financial statements explains what the export needs. For owners who want the plain small-business version first, small business financial statements covers the basics. Marketplace sellers can read the dedicated worked example in the Amazon FBA profit and loss statement article.

What it does not do

AIStatements produces historical statements from your ledger. It does not connect to Shopify or Amazon and pull orders, so the quality of the output depends on how the sales, fees and inventory were booked. Many sellers use a connector that posts marketplace settlements into QuickBooks or Xero, then run the export through the generator. It is also not an inventory costing system and does not replace a physical count. If a lender requires a review or audit, the generated pack is the clean starting point your CPA works from, which is where the fee savings come from.

Payout-basis books versus ecommerce statements for the same quarter
Line Payout and cash basis Generated ecommerce statements
Revenue $211,700 (deposits) $219,000 net sales ($240,000 gross less $21,000)
Platform and payment fees Netted out, not visible $7,300 shown as an expense
Inventory bought, $130,000 Expensed when paid $98,550 in COGS, $31,450 added to inventory
Gift cards sold and not redeemed Counted as income $2,900 liability
Net income $17,000 $48,450

Common questions

What financial statements does an ecommerce business need?

An ecommerce business needs an income statement with returns and cost of goods sold separated, a balance sheet showing inventory, sales tax payable and deferred gift card revenue, and a cash flow statement. Lenders and buyers expect accrual basis. AIStatements generates all three from a ledger export, from $24 a month billed yearly.

How do you record Shopify payouts in the books?

Record the sale gross, record fees and refunds as separate lines, and treat the payout as a transfer from a clearing account to the bank. Booking the deposit as revenue hides fees and makes net sales too low. The statements are only as good as that clearing entry, and the generator flags missing fee accounts.

Can I generate ecommerce financial statements from QuickBooks or a CSV?

Yes. Upload a QuickBooks Online or Xero export, or a CSV of the trial balance, and the pack comes back with returns, cost of goods sold, inventory and a tied cash flow. Where inventory or sales tax accounts are missing, the commentary says so for your accountant to fix before the statements go to a lender.

More from the statement pack

Walk into your next board meeting with the pack already done

Upload your bookkeeping export. Get the P&L, balance sheet, cash flow and the written analysis in about 60 seconds.

Encrypted in transit · We never sell your data