A2X vs. Manual Journal Entries for Amazon Sellers: An Honest Comparison

By John Adams | Palo Alto Bookkeeping

You sell on Amazon. Every two weeks, a deposit lands in your bank account. It is a single number: $23,841.67.

Inside that number are 312 product sales, $3,744 in referral fees, $1,872 in FBA fulfillment fees, $640 in advertising costs, 14 refunds, 3 chargebacks, $215 in storage fees, one inventory-reimbursement credit, and sales tax collected in 17 states.

Your job, whether you use A2X or a spreadsheet, is to take that single deposit and split it into its true components. Only then will your Profit and Loss (P&L) statement show real revenue, real expenses, and real margins.

The question every Amazon seller eventually faces is whether to do that splitting manually or pay for A2X. This post walks through what each approach actually involves, bypassing the marketing claims to focus on the lived experience of producing accurate books under both methods.

First, Understand What You Are Actually Reconciling

Amazon issues a settlement report every two weeks. It is not an invoice; it is a dense, multi-tab CSV file containing every financial event from the settlement period. This includes product charges, promotional rebates, referral fees, FBA per-unit fees, storage fees, advertising charges, refunds, chargebacks, shipping credits, gift wrap, and adjustments.

The settlement report is your single source of truth. It contains the only complete accounting of what Amazon collected on your behalf and what it deducted before sending you the remainder.

The business report in Seller Central will show different numbers. The order report will show different numbers. None of them agree perfectly with the settlement report, and none of them can be used for bookkeeping.

Both A2X and the manual method begin from the same starting point: this settlement report. The difference lies in everything that happens after you download it.

The Manual Method: What It Actually Entails

When someone says they do their Amazon books “manually,” here is what they are describing step by step, for every single settlement period.

Step 1: Download and parse the settlement report Log in to Seller Central. Navigate to Reports > Payments > Settlement. Download the CSV for the settlement period. The file typically contains anywhere from 200 to 2,000 rows, depending on your sales volume, refund activity, and advertising complexity.

Step 2: Group transactions by category Every row has a transaction type. Product charges go in one bucket, refunds in another, referral fees in another, and so on. The number of categories ranges from 8 to 20, depending on your activity. Grouping these manually means filtering the CSV by type and summing each column. A single mis-click, dragging the filter one row short or one row long, produces a wrong total that cascades through the entire entry.

Step 3: Build the journal entry For each category, you must assign the correct general ledger account. Gross sales go to revenue. Refunds to contra-revenue. Referral fees to a selling-fees expense account. Every mapping must be consistent period over period.

Then, you construct the journal entry:

Account	Debit	Credit
Bank (net deposit)	$23,841.67
Referral Fees (expense)	$3,744.00
FBA Fees (expense)	$1,872.00
Advertising (expense)	$640.00
Storage Fees (expense)	$215.00
Sales Refunds (contra-revenue)	$1,120.00
Chargeback Fees (expense)	$45.00
Sales Revenue (income)		$31,477.67

The entry must balance. If it does not, the error is somewhere in your category sums, and finding it means retracing all of your CSV filters.

Step 4: Post and match the bank deposit Post the journal entry in QuickBooks or Xero. Then, match the bank feed deposit to the entry. If the net amounts differ ( even by a penny ) something was summed wrong or a category was missed.

Step 5: Repeat twice per month. Forever. Amazon settles every two weeks, meaning two settlement reports per month at minimum. For a seller with moderate volume in the US only, the full cycle takes roughly 60 to 90 minutes per settlement. That is two to three hours per month, permanently.

For multi-marketplace sellers (US plus Canada, UK, EU, Australia), the time multiplies linearly. A seller in four marketplaces faces eight settlement reports per month and 8 to 12 hours of manual reconciliation.

Where Manual Reconciliation Goes Wrong

The errors I see when cleaning up Amazon sellers’ books cluster around a few predictable failure points:

• The net-deposit-as-revenue error. If the $23,841.67 net deposit is booked as a single sales line, revenue is understated by roughly $7,600. Every fee category is invisible. The P&L shows a business with a fictional 100% gross margin and zero selling costs, which survives in the books for months because the bank deposit technically matches.
• Fee categorization errors. Referral fees get lumped into Cost of Goods Sold (COGS), distorting gross margin and making Amazon’s unit economics impossible to compare against other channels. FBA fees get dumped into a catch-all “Amazon Fees” account that no one can audit.
• Refunds that vanish. A refund reduces the next settlement’s net payout but is never recorded as a separate transaction. The revenue for the prior period still shows the original sale, and the clearing account drifts.
• Date boundary crossing. A settlement period often straddles month-end (e.g., charges from Sept 27 through Oct 10, settled Oct 14). If posted entirely to October, September revenue is understated and October’s is inflated.
• Formula errors in spreadsheets. A summing range accidentally excludes the last 20 rows, or a VLOOKUP returns the wrong fee rate. These errors are silent. The journal entry balances because the sums are internally consistent — they are just the wrong sums.

A2X: What It Actually Does

A2X connects to your Amazon Seller Central account and your QuickBooks Online or Xero file. It pulls each settlement report automatically when Amazon generates it, reads every row, groups transactions by category, applies your configured mapping rules, and builds one summarized journal entry per settlement period.

The journal entry it produces is structurally identical to the manual one described above. The difference is not in the output, but in the automated process that generates it.

What A2X does NOT do:

• It does not set itself up correctly on its own. The initial mapping requires human configuration. If referral fees are mapped to “Sales” instead of “Selling Fees,” the output will be systematically wrong every period.
• It does not match the bank deposit for you. It posts the journal entry. You still need to click “Match” in your bank feed (which takes about 30 seconds when configured correctly).
• It does not handle multi-currency complexities automatically. A seller receiving settlements in GBP, EUR, and CAD needs to configure each marketplace separately and handle currency conversions in their accounting file.
• It does not replace judgment. A human still needs to review entries, verify mappings, investigate outliers, and handle edge cases like multi-period refunds or FBA inventory adjustments.

Head-to-Head Comparison

Factor	Manual Journal Entries	A2X
Time per settlement	60-90 minutes	5-10 minutes (review + match)
Monthly time (US only)	2-3 hours	20-30 minutes
Monthly time (4 markets)	8-12 hours	1-2 hours
Monthly cost	Your time (or bookkeeper’s hourly rate)	$29/month (Amazon only) to $100+/month (multi-channel)
Error risk	Moderate to high. Spreadsheet errors are silent.	Low for data entry. Mapping errors require human review.
Fee categorization	Manual grouping. Consistency relies on the human doing it.	Automatic once mapped. Consistent every period.
Audit trail	Manual spreadsheet workbook.	Automatic. Every JE is traceable to the source report.
Scalability	Worsens linearly with more orders and marketplaces.	Highly scalable. 500 orders takes the same time to review as 50.
Learning curve	Requires deep understanding of Amazon fees and JEs.	Requires one-time mapping configuration and periodic review.

The Cost Comparison (With Real Numbers)

Assume a bookkeeper charges $75 per hour a reasonable rate for someone who understands ecommerce accounting.

Manual method, US-only seller: Two settlements per month at ~1.25 hours each = 2.5 hours monthly. Cost: $187.50 per month in bookkeeping labor.

A2X, US-only seller: 20-30 minutes of bookkeeper review time monthly (0.5 hours). Cost: $29 (software) + $37.50 (labor) = $66.50 per month.

Manual method, 4-marketplace seller: Eight settlements per month. Roughly 10 hours monthly. Cost: $750 per month in bookkeeping labor.

A2X, 4-marketplace seller: Multi-channel A2X plan ($99/month). 1-2 hours of bookkeeper review time (1.5 hours). Cost: $99 (software) + $112.50 (labor) = $211.50 per month.

The crossover point where A2X becomes cheaper than paying someone to do it manually is roughly one settlement report per month. Past that, manual reconciliation costs more in labor than the software costs in subscription fees. Labor costs compound as you grow; software costs generally do not.

When Manual Reconciliation Is the Right Choice

Manual journal entries make sense in exactly one scenario: a very small Amazon operation with minimal complexity.

Specifically: fewer than 50 orders per settlement period, US marketplace only, no advertising, and a simple fee structure with no FBA. In this scenario, the settlement CSV is 80 rows, not 800. A competent bookkeeper can parse it in 20 minutes. Saving $29 a month makes sense here because the error risk is low and the time investment is minimal.

As soon as volume crosses roughly 100 orders per settlement period, or advertising becomes material, or a second marketplace enters, manual reconciliation becomes a false economy.

When A2X Is the Right Choice

A2X is the correct choice when any of the following applies:

• More than 100 orders per settlement period.
• Multi-marketplace selling (US plus any other region).
• Material advertising spend through Amazon Ads.
• You use FBA (introducing fee complexity like fulfillment, storage, and disposal fees).
• Your hourly bookkeeper takes more than 45 minutes per settlement.

The One Scenario Where A2X Is Not Enough

If you are a high-volume, multi-marketplace seller with FBA, heavy advertising, frequent reimbursements, and cross-border inventory accounting, A2X is necessary but insufficient on its own.

A2X handles the data pipeline, but the human review layer becomes the bottleneck. An ecommerce-specialist bookkeeper still needs to interpret reimbursements, verify multi-currency treatment, and reconcile inventory adjustments. A2X reduces the mechanical work; it does not eliminate the need for accounting judgment.

The Most Common A2X Error I See

Ironically, the most frequent A2X-related problem I encounter is not that the software failed. It is that someone set it up, never checked the mappings, and assumed it was producing perfect books.

The most damaging mapping error is sending Amazon fees to Cost of Goods Sold. This collapses referral, FBA, and storage fees into the same account that holds inventory costs. Gross margin becomes meaningless, and Amazon’s contribution margin cannot be compared against your Shopify store or wholesale channels. When the business goes to sell or raise funding, the financials require expensive forensic reconstruction.

The fix: Spend one hour during initial setup mapping each settlement category to the correct general ledger account. Then spot-check one settlement per quarter to confirm nothing has drifted.

The Bottom Line

Your Situation	Recommendation
<50 orders/settlement, US only, no FBA, no ads	Manual is fine. Save the $29/month.
50-100 orders, some complexity	A2X. The time savings alone justify it.
100+ orders, any marketplace complexity	A2X. Manual is costing more in labor than the software costs.
Multiple marketplaces, FBA, material ad spend	A2X + an ecommerce bookkeeper. Software handles mechanics; human handles judgment.

The question is not really “A2X versus manual.” It is whether you want to pay for software or pay for hours — and whether those paid hours are spent on manual data entry or on high-value review and analysis. Software does data entry more accurately. Humans do analysis better. The right setup uses each for what it is best at.

A Free 20-Minute Call

If your Amazon books are a source of low-grade anxiety — or if you are unsure whether your A2X mappings are correct, or whether manual reconciliation has been producing accurate P&Ls — I can tell you in 20 minutes whether the fix is small or the cleanup is large, what it will cost, and how long it will take.

I will need read-only access to your QuickBooks Online file to give you a real estimate. You can revoke access with one click. I cannot withdraw money, pay bills, or change anything.

[Book a Free 20-Minute Call →]

Palo Alto Bookkeeping is a solo practice by John Adams, specializing in QuickBooks Online cleanup, ecommerce bookkeeping (Amazon, Shopify, Stripe), and ongoing monthly bookkeeping for Silicon Valley small businesses. This post provides general information and does not constitute tax or accounting advice. A2X is a third-party product; I have no affiliation with A2X and receive no compensation for discussing it.