Services Who We Serve Work with us About Contact

Books for online sellers, matched payout by payout.

Averan Advisors keeps the books for brands that sell through Shopify, Amazon, other marketplaces and wholesale accounts. Each payout is matched to its bank deposit, each unit carries its full landed cost, and each product shows what it contributes after fees, freight and advertising. Each section below explains one part of the work with a worked example in numbers.

The deposit is the last number in the chain.

An online order passes through a channel before any money reaches the bank. The channel collects the customer's payment, takes its fees, subtracts refunds, sometimes holds a reserve, and pays the remainder on its own schedule. A seller who books the deposit as sales records a figure that already has costs taken out of it, and the fees disappear from the profit and loss statement.

Averan records each order's gross sale and each deduction on its own line, then checks that the lines add up to the deposit. Inventory is an asset until a unit sells, and its cost moves to cost of goods on the day of the sale. The worked examples on this page use round figures to show the method. The figures are an illustration.

Matching each payout to the bank

Shopify, Amazon, PayPal and Stripe each send a settlement report with every payout. The report lists orders, fees, refunds, chargebacks and adjustments for the period. Averan imports the report, posts gross sales to income, posts each fee to its own expense account, posts refunds against sales, and posts the net to a clearing account. The clearing account empties to zero when the bank deposit arrives. A balance left in clearing points to a missing deposit or a report line that needs a second look.

Worked example: one Shopify payout

A Shopify payout covers $20,000 of gross sales for the week. Payment processing fees total $620 and refunds total $1,140. The deposit in the bank is $18,240. The books show $20,000 of sales, $1,140 of refunds against sales, and $620 of processing fees, which add to $18,240 and clear the account. Booking the $18,240 as sales would have hidden $1,760 of refunds and fees. The figures are an illustration.

Contribution margin by product

Contribution margin is what one sale leaves after the costs that come with it: landed cost of the unit, channel and payment fees, outbound shipping and packaging, and the advertising spent to win the order. The books group these costs by product and by channel. A product with the highest revenue can sit at the bottom of the contribution ranking once fees and advertising are counted. Customer acquisition cost is advertising spend divided by new customers won in the period, and Averan reports it by channel next to the margin figures.

Worked example: a $39 product

A product sells for $39. Its landed cost is $9.80, channel and payment fees are $6.20, and shipping and packaging cost $7.50. Before advertising, each sale contributes $15.50. Advertising runs $9.00 per order, so the contribution after advertising is $6.50 per sale, or 16.7% of the price. A $1.00 rise in advertising per order cuts that contribution by 15.4%. The figures are an illustration.

Inventory and landed cost

Inventory sits on the balance sheet until a unit sells. Its cost includes the supplier price, inbound freight, duties and customs fees. Those amounts are added to the inventory value when they are paid, and spread across the units in the shipment. Units held in an Amazon warehouse or a third-party logistics warehouse are still the seller's inventory and are counted in the books. A count against the books each quarter catches shrinkage, damaged stock and units that have stopped selling.

Worked example: one container of 1,000 units

A seller buys 1,000 units at $8.00 each, a total of $8,000. Inbound freight costs $1,200 and duties cost $600. The landed cost is $9,800, or $9.80 a unit. Margin calculated on the $8.00 supplier price alone would overstate gross profit by $1.80 on every unit sold, or $1,800 across the shipment. The figures are an illustration.

Returns, chargebacks and sales by state

Returns and chargebacks reduce sales. The books record them in their own accounts below gross sales, so the return rate by product and by channel can be read each month. Returned units that can be resold go back into inventory at their landed cost. Units that cannot be resold are written off. Averan also keeps sales by state and by channel. A CPA uses those figures to decide where the business must register, collect and file sales tax, including states where stock sits in a marketplace warehouse.

Worked example: an 8% return rate

A brand sells $120,000 of product in a quarter and accepts $9,600 of returns. The return rate is 8.0%, and net sales are $110,400. If the returns had been left out of the books, sales would be overstated by $9,600 and gross margin would include products that came back. The figures are an illustration.

What this means for an owner

Every payout equals gross sales less fees, refunds and holds, and the books show each part. Each unit carries its full landed cost into cost of goods. Contribution margin by product counts fees, shipping and advertising, so the product ranking reflects what each sale leaves. Returns sit below gross sales on their own line. Sales by state are recorded each month, and a CPA uses them to decide where sales tax must be collected and filed.

Part of

← Inventory and retail businesses Averan works with

Sell online?

Send one month of settlement reports and bank statements, and Averan will show how the payouts break down into sales, fees and refunds.

Talk to Averan

Questions we get asked

Why does a payout differ from my sales?

A sales channel pays out gross sales less its own fees, refunds and any reserves it holds back. The books record the gross sales, each fee and each refund on their own lines, so the payout in the bank equals sales less those items to the cent.

What is landed cost?

Landed cost is everything paid to get a unit into sellable stock: the supplier price, inbound freight, duties and customs fees. It is the cost the books move from inventory to cost of goods when the unit sells, so gross margin by product reflects the full cost of each unit.

Who decides where I must collect sales tax?

A CPA decides where the business must register, collect and file sales tax. The books keep sales by state and by channel each month, so a CPA can see where the business sells and how much.