Skip to main content

QuickBooks Bookkeeping for Amazon FBA & Shopify | Thelonex

  • June 4, 2026
  • 15 min read
  • No Comments
How to Set Up QuickBooks for Amazon FBA Sellers

QuickBooks Setup for Amazon FBA Sellers: A Guide

Most Amazon FBA sellers start with a spreadsheet. Then the business grows, the transactions multiply, and the spreadsheet stops working. By the time tax season arrives, the books are a mess and a bookkeeper is billing extra hours to sort it out.

The fix is straightforward: set up QuickBooks Online correctly from the start, configured specifically for how Amazon FBA businesses work. A properly built QuickBooks file gives you accurate profit and loss reports, clean bank reconciliations, and books that are ready for your accountant the moment they need them.

This guide walks you through the complete QuickBooks setup for Amazon FBA sellers — from choosing the right plan to building your chart of accounts, connecting A2X, and running your first bank reconciliation. Follow these steps and you will have an accounting system that works from day one.

QuickBooks Online dashboard for Amazon FBA setup

What Is QuickBooks Setup for Amazon FBA?

QuickBooks Online (QBO) is cloud-based accounting software used to record, organize, and report on every financial transaction in your business. Setting it up for Amazon FBA means configuring it to handle the specific income categories, expense types, inventory accounts, and tax codes that FBA sellers deal with.A generic QuickBooks setup — the kind you get if you just click through the default options — does not work well for Amazon sellers. Amazon pays you net settlements, not gross revenue. Your income has multiple components: product sales, refunds, and reimbursements. Your costs include FBA fees, inbound freight, advertising, and COGS. None of these maps to the default QuickBooks chart of accounts correctly without intentional configuration.A proper QuickBooks setup for Amazon FBA means building a chart of accounts from scratch that matches how Amazon’s financial data is structured, so every transaction lands in the right place from the moment it enters your books.

Who Is This For?

This setup guide is for Amazon FBA sellers in the US and Canada who are:
  • Starting with QuickBooks Online for the first time
  • Switching from spreadsheets or another accounting tool to QBO
  • Rebuilding a poorly configured QBO file to work correctly for FBA
It is also the foundational step before connecting A2X for automated settlement imports and before setting up TaxCloud for sales tax compliance. If those tools are not built on a correctly configured QBO file, their outputs will be inaccurate.For the complete Amazon accounting system context, read first: Amazon Seller Accounting: The Complete Guide for US and Canada

Why Proper QuickBooks Setup Matters for Amazon FBA Sellers

Your P&L Is Only as Good as Your Chart of Accounts

The chart of accounts is the backbone of your QuickBooks file. It defines every category that transactions can be assigned to. If your chart of accounts does not have a separate account for Amazon FBA fees, those fees will end up in a catch-all expense category. If your COGS accounts are missing, inventory costs will be expensed immediately instead of being tracked correctly against units sold.A poorly built chart of accounts produces a P&L that looks clean on the surface but misrepresents your actual profitability. The gross margin is wrong. The expense breakdown is inaccurate. The tax figures are unreliable.

A2X Cannot Post Correctly to an Unconfigured File

A2X — the data connector between Amazon Seller Central and QuickBooks — maps your settlement data to specific QBO accounts. If those accounts do not exist or are incorrectly named, A2X will post to wrong or catch-all accounts. The automation that makes A2X valuable depends entirely on the QuickBooks setup being correct first.Getting QBO configured before connecting A2X means your automation works correctly from the first settlement. Getting it wrong means spending hours remapping and reposting historical data.

Clean Setup Prevents Expensive Cleanup Later

Bookkeepers and accountants charge significantly more to clean up a poorly configured QuickBooks file than to maintain a correctly set-up one. Every month of messy books is another month of cleanup fees. A correct setup from the start eliminates that cost entirely.If your books are already behind or incorrectly set up, read: Amazon Catch-Up Bookkeeping: How to Fix Months of Messy Records before proceeding with a new setup.

Step-by-Step: How to Set Up QuickBooks Online for Amazon FBA

Step 1: Choose the Right QuickBooks Online Plan

QuickBooks Online has three main plans for small businesses. Here is how they compare for Amazon FBA sellers:
FeatureSimple StartEssentialsPlus
Income & expense trackingYesYesYes
Bank & credit card syncYesYesYes
Financial reports (P&L, Balance Sheet)YesYesYes
Max users135+
Accounts payableNoYesYes
Inventory trackingNoNoYes
Class & location trackingNoNoYes
Price~$38/mo~$75/mo~$115/mo
Best for Amazon FBALow volume, simple booksMost FBA sellersHigh-volume or multi-channel sellers
The recommendation for most Amazon FBA sellers is QuickBooks Online Essentials. It supports multiple users, handles accounts payable (for supplier invoices), and gives you the financial reporting you need. Upgrade to Plus only if you need QuickBooks to manage inventory item quantities natively — which is optional if you use A2X and a separate inventory spreadsheet.Pricing is approximate and subject to change. Check QuickBooks.com for current plan pricing. Discounts are often available in the first few months.

Step 2: Set Up Your Company Profile

When you first sign in to QuickBooks Online, it will ask you to create your company profile. Enter:
  • Legal business name — exactly as it appears on your tax filings
  • Business address — your registered business address, not Amazon’s
  • Business type — choose Sole Proprietor, LLC, S-Corp, or Corporation depending on your entity type
  • Industry — select Retail or E-commerce
  • Fiscal year start — January for most US sellers; confirm with your accountant
  • Tax form — choose based on your entity: Schedule C (sole prop), 1120-S (S-Corp), 1065 (partnership), or 1120 (C-Corp)
If you sell into Canada, also set up a second currency (Canadian Dollar / CAD) under Company Settings > Advanced > Currency. QuickBooks Online Plus and Essentials both support multi-currency.

Step 3: Delete the Default Chart of Accounts and Build a Custom One

QuickBooks Online populates a default chart of accounts when you create a new company file. Most of these accounts are designed for general service businesses — they are not suitable for an Amazon FBA seller.The best approach is to deactivate the accounts you will not use and add the specific accounts your Amazon business needs. Do not leave unused default accounts active — they create clutter and make categorization harder.Here is the complete recommended chart of accounts for Amazon FBA sellers:
#Account NameAccount TypePurpose for Amazon FBA Sellers
1000Checking AccountBankPrimary business bank account — receives Amazon payouts
1400Inventory AssetOther Current AssetValue of all unsold FBA inventory on hand
2000Accounts PayableAccounts PayableSupplier invoices owed but not yet paid
2100Sales Tax Payable (US)Other Current LiabilityUS state sales tax collected and owed
2110GST/HST Payable (Canada)Other Current LiabilityCanadian GST/HST collected and owed (if applicable)
4000Amazon Sales — FBAIncomeGross product sales revenue from Amazon FBA
4100Amazon RefundsIncomeCustomer refund amounts (negative income)
4200Amazon ReimbursementsOther IncomeAmazon payouts for lost or damaged FBA stock
5000COGS: Product CostCost of Goods SoldPurchase price of units sold
5010COGS: Inbound ShippingCost of Goods SoldFreight cost to ship inventory to Amazon warehouses
5020COGS: Prep and PackagingCost of Goods SoldPoly bags, labels, inserts, and bundling costs
5030COGS: Inventory AdjustmentsCost of Goods SoldWrite-downs for lost, damaged, or expired stock
6000Amazon FBA FeesExpenseFulfillment fees, referral fees, storage charges
6010Amazon Advertising (PPC)ExpenseSponsored Product, Sponsored Brand, DSP ad spend
6020Software and ToolsExpenseA2X, TaxCloud, repricing, analytics subscriptions
6030Professional FeesExpenseBookkeeping, accounting, legal, and tax preparation
6040Bank and Payment FeesExpenseWire transfer fees, currency conversion charges
Account numbers are suggestions — QuickBooks Online does not require specific numbers. Use a consistent numbering convention (1000s for assets, 2000s for liabilities, 4000s for income, 5000s for COGS, 6000s for expenses) to keep your chart organized and easy to navigate.To add each account in QuickBooks Online: go to Accounting > Chart of Accounts > New. Select the Account Type and Detail Type from the dropdowns, enter the name and number, and save.For a deeper explanation of how COGS accounts work in QuickBooks: How to Track Amazon FBA Cost of Goods Sold in QuickBooks

Step 4: Connect Your Business Bank Account

Bank feeds are one of QuickBooks Online’s most valuable features. Once connected, your bank automatically imports every transaction into QuickBooks daily, eliminating manual data entry for most non-Amazon expenses.To connect your bank:
  1. Go to Banking > Add Account in QuickBooks
  2. Search for your bank by name
  3. Log in with your online banking credentials
  4. Select the account(s) to connect — typically your business checking account
  5. Choose the date range for the initial transaction import — 90 days is a good starting point for new setups
After the import, QuickBooks will begin suggesting categories for each transaction based on the payee name and amount. Review and accept these suggestions, or override them with the correct account from your chart of accounts.Also connect any business credit cards you use for Amazon-related expenses. Each card should be connected as a separate account in QuickBooks.
Important: Do not record Amazon settlements from the bank feed as income.When Amazon’s settlement deposit appears in your bank feed, do not categorize it directly as revenue. The deposit is a net amount that already has fees deducted. Categorizing it as income will understate your gross revenue and hide your fee structure. Instead, mark it as a transfer to your Amazon Clearing account and let A2X handle the proper breakdown. More on this in Step 6.

Step 5: Configure Tax Settings

Go to Company Settings > Taxes in QuickBooks Online and configure your tax settings:
  • US sellers: set up your sales tax agency for each state where you have nexus. QuickBooks can track sales tax collected by state, which feeds into your TaxCloud filing process.
  • Canadian sellers: enable GST/HST under Tax Agencies. Add the CRA as your tax agency and set the rate for your business (5% GST, or the applicable HST rate for your province).
  • Sellers in both markets: set up US and Canadian tax codes separately. Use the correct tax code when categorizing transactions from each market.
If you use TaxCloud for US sales tax automation, you do not need QuickBooks to calculate your sales tax — TaxCloud handles that. But keeping a sales tax payable account in QBO ensures your balance sheet correctly shows your sales tax liability before it is remitted.For the full Canadian GST/HST setup: Canada GST/HST for Amazon Sellers: What You Need to Register

Step 6: Connect A2X to QuickBooks

Once your chart of accounts is built and your bank is connected, it is time to connect A2X. A2X is the data connector that pulls your Amazon settlement data and posts it as clean journal entries in QuickBooks.The A2X connection process:
  1. Create an A2X account at a2xaccounting.com
  2. Connect A2X to your Amazon Seller Central account — A2X will import your settlement history
  3. Connect A2X to QuickBooks Online — A2X will read your chart of accounts
  4. Map each Amazon settlement line item to the correct QBO account from your chart
  5. Review your first settlement and post it to QuickBooks
The mapping step is critical. Use the chart of accounts you built in Step 3 to guide every mapping decision. For example:
  • Amazon product sales ->  4000: Amazon Sales — FBA
  • Customer refunds ->  4100: Amazon Refunds
  • FBA fulfillment fees ->  6000: Amazon FBA Fees
  • Reimbursements ->  4200: Amazon Reimbursements
  • FBA storage fees ->  6000: Amazon FBA Fees (or create a separate 6005 Storage Fees account)
Once mapping is confirmed, enable auto-posting. A2X will post every new settlement to QuickBooks automatically without manual intervention.For a detailed walkthrough of A2X setup and mapping: A2X vs Manual Entry: Which Is Better for Amazon Bookkeeping?

Step 7: Run Your First Bank Reconciliation

After A2X has posted your first settlement and your bank feed is active, run your first bank reconciliation in QuickBooks to confirm everything is matching correctly.Go to Accounting > Reconcile. Select your business checking account. Enter the closing balance from your most recent bank statement. QuickBooks will show you the transactions in its register against the statement. Match them up until the difference is zero.A clean first reconciliation confirms that:
  • A2X settlement entries are posting correctly and matching the Amazon deposits in your bank
  • Your bank feed is importing all non-Amazon transactions
  • There are no duplicate entries or missing transactions
If the reconciliation does not balance on the first attempt, the most common cause is the Amazon settlement deposit being double-recorded — once through A2X and once through the bank feed. Fix this by excluding the bank feed import of the Amazon deposit and relying on A2X as the authoritative source.Build this into a monthly habit using the Amazon FBA Bookkeeping Checklist: Month-End Tasks Every Seller Needs

Practical Tips for a Correct QuickBooks Setup

Complete the Chart of Accounts Before Connecting Any Integrations

Do not connect A2X or your bank account until your chart of accounts is fully built. If you connect A2X to a default QuickBooks chart of accounts, every mapping will be wrong. Remapping and reposting historical data is far more time-consuming than building the chart of accounts correctly before you start.

Use a Clearing Account for Amazon Settlements

Some accountants recommend creating a dedicated clearing account — for example, 1410: Amazon Clearing — to act as a holding account for Amazon settlement deposits before A2X categorizes them. When the bank feed imports the Amazon deposit, you code it to the clearing account. When A2X posts the settlement, it also hits the clearing account. The net balance of the clearing account should always be zero, confirming that every settlement has been correctly accounted for.This approach makes reconciliation cleaner and prevents the double-recording problem described in Step 7.

Set Up Separate Accounts for US and Canadian Revenue

If you sell on both Amazon.com and Amazon.ca, create separate income accounts for US and Canadian sales. For example: 4000 Amazon Sales — US FBA and 4010 Amazon Sales — Canada FBA. This makes it easy to see your revenue split by market and simplifies the process of separating US sales tax data from Canadian GST/HST data.

Save Your Chart of Accounts as a Template

Once your QuickBooks chart of accounts is correctly built and confirmed as accurate after the first reconciliation, export it. Go to Accounting > Chart of Accounts > Export. Save the file as your Amazon FBA QuickBooks template. If you ever need to set up a second entity or advise a fellow seller, you have a verified starting point.

Common Mistakes to Avoid

  • Using the default QuickBooks chart of accounts without customizing it — this is the most common setup error and the hardest to correct retroactively
  • Recording Amazon settlement deposits directly as gross revenue — the deposit is net; you lose all visibility into your fee structure
  • Connecting A2X before the chart of accounts is finalized — every mapping will be wrong and will need to be redone
  • Failing to connect a business bank account — without bank feeds, expense tracking is entirely manual
  • Not setting up separate income accounts for refunds and reimbursements — these are not the same as product sales revenue
  • Skipping the first bank reconciliation — the first reconciliation is your quality check that the whole setup is working correctly
QuickBooks Online vs QuickBooks Desktop for Amazon FBA:This guide covers QuickBooks Online. QuickBooks Desktop is a locally-installed version that some accountants still use. For Amazon FBA sellers, QuickBooks Online is almost always the better choice: it supports real-time bank feeds, cloud access for remote bookkeepers, and direct integration with A2X. QuickBooks Desktop does not have a native A2X integration and requires more manual data management. If your accountant specifically requires Desktop, that is a valid reason to use it — otherwise, QBO is the standard for e-commerce.

Conclusion

A correct QuickBooks setup is the foundation that everything else in your Amazon FBA accounting system depends on. The right plan, a custom chart of accounts built for FBA, connected bank feeds, correct tax settings, and A2X integration — done in order — give you an accounting system that produces accurate reports from the first month.The sellers who invest two to three hours in setting this up correctly at the beginning save hundreds of dollars annually in bookkeeping cleanup costs, file more accurate tax returns, and make better financial decisions because their numbers are trustworthy.Once the setup is complete, maintain it with a consistent monthly bookkeeping process. A two to three hour month-end close keeps your books clean, your bank accounts reconciled, and your P&L accurate all year long.

Want QuickBooks Online set up correctly for Amazon FBA?

Thelonex builds and manages QuickBooks for Amazon FBA sellers in the US and Canada. Fixed-price setup + ongoing bookkeeping from $199/month.

Leave a Reply

Your email address will not be published. Required fields are marked *

Need bookkeeping help? Chat with us! ×