What This Tool Actually Is
Fba Journal Easy is a bookkeeping workflow for Amazon FBA sellers who need to reconcile their account statements without manually staring at spreadsheets for hours. It's not magic software that does everything automatically. What it does is take the messy CSV reports Amazon gives you and organize them into something a regular accounting system can actually read. You export from Seller Central, run the data through the template or script, and you get back categorized transactions ready for your accountant. The basic setup takes about twenty minutes if you've never done this before. First, log into Seller Central and go to your Reports section. You'll need two files: the Payments report and the Transactions report for the date range you're reconciling. Export both as CSV. Most sellers only need to pull one month at a time because the file size balloons past about six months and the processing becomes unreliable. Once you have the files, open the Fba Journal Easy template. It maps Amazon's transaction codes to standard chart-of-accounts categories. The template has columns for date, transaction type, gross amount, Amazon fees, refunds, and the resulting net amount. You drag your exported data into the corresponding columns and let the formulas handle the rest. Don't skip the reconciliation step at the end. The template gives you a "balance check" field that should equal zero when everything lines up. If it doesn't, something is misread or a transaction type isn't mapped yet.
The Process in Practice
Here's what the workflow looks like week to week. Export your Amazon reports. Run them through Fba Journal Easy. Review the output for anything flagged as unclassified. Reconcile against your bank statement. Hand the final journal entries to your bookkeeper or upload them to QuickBooks/Xero. That's it. A typical month for a seller moving around $15,000 in revenue takes about 45 minutes from export to clean journal entries. The tricky part is the unclassified transactions. Amazon generates over sixty transaction types and not all of them map cleanly to a standard revenue or expense category. Fba Journal Easy covers the common ones by default: sales, refunds, FBA fees, reimbursement payments, advertising charges. But you'll run into edge cases that the template doesn't anticipate. I spent three weeks dealing with a recurring "adjustment" line that showed up under the wrong transaction code every month. It turned out to be a fulfillment center transfer fee being lumped into an adjustment bucket instead of a separate logistics fee line. The workaround was to filter for that specific code in the raw export, move those rows to a dedicated manual review queue, and reclassify them before running the template. Takes about ten minutes once you know what to look for.
What Beginners Miss
The biggest mistake I see people make is treating the balance check as a final answer instead of a checkpoint. A zero balance doesn't mean your books are correct. It only means the debits equal the credits within the template. Your categories could still be wrong. Amazon could have mischarged you and the numbers would still balance. You need to compare the totals against your actual bank deposits and your Amazon disbursement reports separately, not just trust the template. Another thing nobody warns you about: promotional adjustments. When you run coupons or lightning deals, Amazon deducts the discount amount in a separate transaction line from the actual sale. If you don't separate these, your revenue gets understated and your fee expense gets overstated. The template has a field for promotional deductions but it's easy to leave blank and not notice until your P&L looks weird.
Get the Full Details
Limitations You Need to Know
Fba Journal Easy works well for single-marketplace sellers. If you're doing North America plus Europe, the transaction code mapping breaks down because Amazon uses different codes in different regions. You'd need to maintain separate templates or adjust the mappings manually, which adds time and introduces error risk. For multi-marketplace operations, this tool becomes a liability rather than a help. It also assumes you're on the professional selling plan with full access to both payment and transaction reports. Individual sellers with limited report access won't be able to pull the data this tool requires. And if your business model includes arbitrage or wholesale alongside private label, the revenue categorization gets messier because the template treats all inbound payments as the same bucket. You'll need to add manual sub-categories yourself. The alternative for sellers who hit these limits is to use a dedicated FBA accounting platform like A2X or Helium 10's accounting module. Those cost money monthly but they handle multi-marketplace data, automatic categorization, and direct integration with QuickBooks and Xero. Fba Journal Easy is free or low-cost and that matters, but it has a ceiling. Know where yours is before you hit it.
Download and Access
The template is hosted on the original GitHub repository and various Amazon seller forums. The most current version includes updated transaction code mappings as of early 2025. I recommend downloading it and comparing the release notes against your own transaction data before committing to it as your primary workflow. The spreadsheet format is Google Sheets compatible, which means you can duplicate it and fork your own version if you need custom categories. Keep that fork documented somewhere so you don't lose track of your modifications when a new version drops.
