Amazon Seller Bookkeeping

Amazon deposited $5,195.18. The settlement math says $5,258.36. Where did the $63.18 go? Amazon doesn't pay per order — it closes a settlement every 14 days, collapsing your sales together with referral fees, FBA fees, storage charges, refunds, ad spend and reserve holds into one deposit that never seems to match. This spreadsheet decodes it. Enter each settlement's lines on the Settlement Log and the file rebuilds what Amazon should have paid: product sales plus shipping credits, minus referral, FBA, monthly and long-term storage fees, refunds, refund admin fees and ad spend, adjusted for reserve held and released. A bank check then compares the rebuilt figure to the deposit that actually landed and flags any difference to the cent. A Fee Breakdown shows every fee as a share of gross sales, and a SKU Profit tab lands landed cost, fees and ad dollars per ASIN for a true net and margin.

The sample data is a fictional store, Harbor & Vine Home Goods — four settlements and five SKUs. Three settlements tie out to the cent; the fourth flags a −$63.18 variance, an aged-inventory surcharge on the real settlement that never made it into the entered lines. The reserve story runs alongside: $805.50 held across two settlements, then released in full, ending at $0.00. This is an organization and calculation tool, not tax or accounting advice.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

What you receive is the finished spreadsheet file, delivered instantly at checkout as a PDF containing your Google Sheets copy link. Open it, choose "Make a copy," and the file is yours. It runs in Google Sheets on a free Google account — nothing to install — and the sample data is included so you can see the formulas work. If a file ever breaks, you receive a corrected copy of the file free. This is a digital product — no physical item will be shipped.