Working Out Your Annual FBA Financials Without Losing Your Mind
Most sellers I talk to wing their yearly income statements. They open Amazon's Business Report, copy-paste some numbers into a spreadsheet that hasn't been touched since 2023, and call it a day. It's enough to file taxes in most cases, but if you're trying to actually understand your profitability across the full year — accounting for returns, FBA fees, ad spend, inventory loss, everything — a proper Fba Worksheet Yearly template saves you from making decisions on incomplete data. I spent three years building and rebuilding my own version of one. The one I use now started as a Google Sheets doc with about forty columns and ended up as something leaner after I deleted half the stuff nobody ever looks at. The structure is straightforward enough that you can rebuild it in an afternoon if your existing template is garbage or doesn't exist yet.
Fba Worksheet Yearly: How to Actually Build One That Works
Start with six core rows. Revenue, Cost of Goods Sold, FBA fulfillment fees, FBA storage fees, advertising spend, and returns. Everything else gets folded under those or ignored until it matters. Don't add a column for "miscellaneous fees" and expect yourself to track it. You won't. Create separate line items only for things you log monthly and that represent more than five percent of your costs. Break each row down by month. That gives you twelve columns across, plus a total column on the right. Use raw numbers, not percentages, for the monthly data. Percentages get messy when you're summing across quarters. Calculate your margins in a separate section below the main grid. That keeps the top portion clean for quick scanning when you need to answer a question like why Q2 looked worse than Q1. Link your FBA disbursement report directly. Amazon sends these out every two weeks, so your worksheet needs a place to capture each deposit cleanly. I use a separate tab for raw disbursement data and pull from it with sumifs formulas keyed to month and year. That way when Amazon changes something in their fee structure, I only update the source data tab, not every formula in the main sheet.
For COGS, track unit cost and quantity purchased per month separately. Amazon's reports give you units sold, but they don't tell you what you paid suppliers. If you're buying from multiple vendors at different price points throughout the year, your average cost fluctuates, and a single blended COGS number will lie to you about which products are actually profitable. Here's where most templates break down. Returns. Amazon reports returned units, but the financial impact is uneven. Some returns get restocked and resold. Some go to liquidation. Some sit in stranded inventory. My workaround was to create a returns adjustment column that subtracts the estimated recovery value from the gross return amount. I set it at roughly sixty percent of the product cost for standard items and zero for anything I know goes to liquidation. It's not perfect but it's close enough that my annual net profit figured within three percent of what my accountant reported.
Get the Full Details
The Parts People Skip and Regret Later
Storage fees across the long term. January through September storage is one rate. October through December jumps to a different tier because of peak season. If you lump all storage fees into a single annual number, you'll misread whether holiday inventory buildup hurt your margins or helped them. Break storage into short-term and long-term buckets within each month. Advertising efficiency isn't just total ad spend divided by total revenue. That gives you a blended ACOS that masks which products are subsidized by others. I add a product-level ad section at the end of the sheet where I track spend and attributed sales per SKU. It takes more time to maintain but it's the only way to spot which listings are draining profit without realizing it. Taxes. Sales tax collected versus sales tax remitted is a common trap. Amazon collects and remits in most states now, but not all. If you have nexus in a state where Amazon doesn't handle it, your worksheet should show the liability separately so you're not caught off guard in April. Same with import duties. If you're sourcing internationally, include duties as a separate line in COGS rather than burying it in your product cost. It makes quarterly comparisons more accurate.
There are also limits to what any worksheet can capture. Inventory shrinkage — lost or damaged stock that Amazon never reimburses — rarely shows up cleanly in Amazon's reports. The reimbursement claims process is a separate effort entirely. If you want that number, you need a second spreadsheet tracking claims submitted, claims approved, and claims denied. Combining it into the main Fba Worksheet Yearly file bloats it and makes the core profit calculation harder to read. Free tools online will get you started. Search for "Amazon FBA annual profit calculator spreadsheet" and you'll find several shared Google Sheets with decent foundations. The problem is they tend to be built for one seller's setup and don't adapt well if your business diverges even slightly — multiple brands, private label plus wholesale, foreign supplier payments in different currencies. A generic template forces you to bend your process to fit the sheet instead of the other way around. Building your own from scratch using the six-row method above usually takes less time than spending three hours trying to make a downloaded template work for your specific situation. The sheet itself should stay simple enough that someone else could pick it up if you're unavailable. Naming conventions matter more than you think. Label columns clearly — "Revenue_Gross", "COGS_Product_Cost", "FBA_Fees_Fulfillment" — not "Money In", "Product Cost", "Fees". When you come back to it six months later, clear labels prevent misinterpretation that could cascade into bad purchasing decisions.
If you're serious about using this annually, set a recurring calendar reminder to lock the spreadsheet each January first. Copy the prior year's data into a separate archive tab, start fresh on the main sheet, and carry over any product-level ad data you've been tracking. Without that discipline, the annual comparison you're supposed to get from a yearly worksheet becomes impossible because you never had consistent data to begin with.
