Getting Your Amazon FBA Business Actually Organized For The Year
Most sellers don't really have a system until Q3 hits and they realize they have no idea where their profit went. I've watched it happen dozens of times. The problem isn't that people are lazy about records. It's that most FBA accounting tools are either way too complex or too simple to be useful. There's a middle ground, and it's basically a structured journal you update weekly. I've used probably six different spreadsheet templates over the years before settling on something that actually works. The core columns are straightforward: date, ASIN, order type (FBM or FBA), units sold, revenue, Amazon fees, shipping cost to inbound, COGS, and the resulting net margin per unit. That's it. Everything else is noise. The column people always skip is the return rate per ASIN per month. Returns destroy margins on low-ticket items and nobody tracks them until tax season. I learned that the hard way with a product I sold at $12.99. Returned 18% of units in October alone. My gross margin looked fine. Net margin was negative. The journal would have shown this if I'd been recording returns the way I record sales.
There's also a column for advertising spend that gets tied back to specific ASINs. Not total ad spend for the month. I used to just put one number at the bottom and wonder why my margins fluctuated wildly. Once I started attributing ad spend per ASIN, the picture got a lot clearer. Some products were barely profitable once you include the actual CAC, not just the Amazon fees.
How I Set It Up Without Losing My Mind
I keep it as a Google Sheet because it syncs across devices and I can pull reports directly from Seller Central. Every Sunday I download the Report by Date from the Payments dashboard and the Child ASIN Sales Report from the Business Reports section. That gives me everything I need for the previous week. I don't do this daily. Daily data entry is a trap. Most sellers burn out on it within two months and then abandon the whole thing. The weekly update takes me about 40 minutes. I have a script that matches the sales data to ASINs and pulls the fee breakdown automatically. I don't know Python but I found a template that uses AppScript and modified it to match my column structure. That cut the process down from about 2 hours to 40 minutes. The first time I ran it, it matched 94% of transactions on the first try. The other 6% were refunds that hadn't fully processed yet, so I just flagged those manually. If you don't want to code, there are pre-built templates floating around. The problem with most free ones is that they don't account for things like restock fees, long-term storage fees, or removal order costs. Those small line items add up. I built my own because I couldn't find one that tracked everything without being overly complicated.
Get the Full Details
The Edge Case That Broke Me For A While
Here's the thing nobody warns you about: Amazon's fee structure changes mid-year sometimes. They adjusted fulfillment fees in early 2024 and my previous journal didn't flag it. I was still calculating margins using the old fee schedule for three months. The workaround was adding a separate column for the fee version date so I could see exactly when a margin shift happened and which ASINs were affected most. Once I had that column, I could immediately see that my smaller items got hit harder by the change than my larger items. That directly influenced my decision to move two products to FBM shortly after. Another edge case is when you have bundles or variants. Amazon reports variant data at the parent level sometimes, not always the child level. If you're selling multiple sizes or colors of the same product and only track at the parent ASIN level, your journal becomes useless for individual profitability analysis. I solve this by making sure every child ASIN gets its own row. It makes the sheet wider, not longer, which is fine for how I structure it.
What This System Misses Completely
I'm not going to pretend this solves everything. A simple journal won't help with cash flow forecasting. It won't tell you whether you have enough capital to restock before the next quarter. It won't catch inventory issues like stranded SKUs or capacity limits. For those problems you need additional tools or a dedicated bookkeeper. The journal also doesn't handle international marketplaces well. If you sell on multiple regions, the fee structures, tax rates, and currency conversions make a single spreadsheet messy fast. I started keeping separate sheets per marketplace and linking them with a summary tab. It's not elegant but it works. And if your business scales past a certain point, this approach becomes a bottleneck. I'm talking maybe $500K to $1M in annual revenue and above. At that level you're spending more time maintaining the spreadsheet than you're saving. That's when I'd recommend moving to something like Aircart, QuickBooks with a FBA connector, or hiring a CPA who specializes in e-commerce.
A Few Practical Things To Get Right From Day One
Don't try to backfill historical data. I tried this once and spent three weeks manually entering data from the previous year. Nobody has that kind of time and honestly the accuracy isn't worth it. Start fresh and accept that you're missing the past. The future data matters more. Set a reminder for the first Monday of every month to reconcile your journal against your bank statement. Amazon deposits aren't always clean. Sometimes there are pending fees, sometimes adjustments. The monthly reconciliation catches those discrepancies before they compound into a much larger problem. Keep a notes column. Not for essays. Just a single line per anomaly. "Promo fee not shown in report." "Return missing from weekly data." "Storage fee applied to old inventory." These notes become incredibly valuable when you're doing your annual review or sitting down with an accountant. I have entries from 18 months ago that I still reference during tax prep because they explain exactly where certain charges came from.
The whole system costs me about 40 minutes a week. In return, I know exactly which products are making money and which ones I should drop. That's more useful than most people realize until they're stuck with dead inventory and no idea why.
