Smart Bookkeeping for Smart Sellers
Configure QuickBooks Online the right way for Amazon FBA, Amazon FBM, multi-channel ecommerce, inventory, sales tax, settlement payouts, refunds, fees, advertising, and monthly tax-ready reports. This guide gives online sellers a practical setup path from first login to clean month-end close.
QuickBooks Online setup for Amazon sellers is not the same as setting up books for a local service business. An Amazon seller may have thousands of orders, dozens of fee types, FBA inventory movement, refunds, reimbursements, storage fees, advertising charges, tax withheld by marketplaces, reserve balances, and payout timing differences. If QuickBooks Online is configured like a simple cash register, the reports can become inaccurate very quickly.
The most common Amazon bookkeeping mistake is recording the bank deposit from Amazon as income. That deposit is only the net amount that reached the bank. It may include gross sales, referral fees, fulfillment fees, FBA storage fees, shipping charges, refunds, chargebacks, reimbursements, sales tax collected or withheld, subscription fees, advertising deductions, reserve adjustments, and other settlement activity. Recording the net deposit as sales hides the true revenue and hides the fees that control profitability.
QuickBooks Online can work well for Amazon seller bookkeeping when the setup is intentional. The system needs seller-specific accounts, clearing workflows, bank feed rules, sales tax handling, inventory decisions, COGS review, and monthly reporting. The goal is not to import everything blindly. The goal is to create financial statements that show what happened in the business and support tax preparation at year end.
This complete configuration guide walks through the setup from a practical seller bookkeeping perspective. It covers company settings, accounting method, chart of accounts, Amazon settlement mapping, FBA and FBM fee categories, inventory tracking, sales tax, bank connections, app integrations, reporting, cleanup checks, and monthly close workflow.
Main keyword used naturally: QuickBooks Online setup for Amazon sellers. Related keywords include Amazon seller QuickBooks setup, Amazon FBA bookkeeping, Amazon settlement reconciliation, QuickBooks chart of accounts, inventory accounting, COGS tracking, and ecommerce bookkeeping cleanup.
Bank feeds are helpful, but they are not a complete Amazon accounting system. If you connect the bank first and begin accepting rules without a seller-specific chart of accounts, the books may fill with vague income, duplicate deposits, missing fees, incorrect inventory expenses, and unclear sales tax activity. Amazon seller accounting should start with the structure, then the data flow, then the monthly review.
Use this working checklist before going live with QuickBooks Online. The more carefully you complete these steps, the easier it becomes to close the month, answer tax questions, and understand true profit. The checklist is designed for Amazon FBA, Amazon FBM, and sellers using Amazon alongside Shopify, Walmart, eBay, Etsy, or wholesale channels.
The right QuickBooks Online plan depends on what the Amazon seller actually needs. A small FBM seller with few SKUs may need a different setup than an FBA seller with hundreds of SKUs, multiple marketplaces, employees, wholesale orders, Shopify sales, loans, and inventory financing. Before choosing a plan, list the workflows that must be supported.
The most important decision for inventory sellers is whether inventory will be tracked directly in QuickBooks Online or summarized from another system. QuickBooks can support product and service items, bank feeds, sales tax features, reporting, and financial statements, but Amazon sellers often use specialized connectors or inventory tools when SKU volume, landed cost, purchase orders, bundles, kits, multi-channel sales, and warehouse movement become too complex.
May only need simple bank feeds, settlement summaries, expense categories, owner draws, and monthly reports.
Needs inventory, COGS, landed cost, supplier bills, freight, prep costs, storage fees, and margin reporting.
Needs Amazon, Shopify, Walmart, eBay, Etsy, PayPal, Stripe, wholesale invoices, and channel-level reporting.
May need users, approval workflows, payroll, contractors, departments, class tracking, and stronger reporting.
Needs cleaner balance sheet review, inventory aging, debt tracking, cash flow reports, and tax-ready close packages.
Needs accountant access, organized source documents, closing procedures, and reporting that matches tax preparation needs.
Plan choice should follow workflow needs. Do not choose a cheaper plan if it cannot support the seller’s inventory, tracking, reporting, or user access requirements.
Before importing activity, review the core company settings. Incorrect settings can create reporting issues later. Confirm the legal business name, DBA, address, tax ID, accounting method, fiscal year, currency, sales tax status, product and service settings, inventory settings, invoice terms, and accountant access. These settings are boring, but they affect the accuracy of reports.
Amazon sellers should also decide how detailed customer and product data should be inside QuickBooks. In most cases, importing every Amazon customer and every order into QuickBooks creates clutter. Many sellers use summarized entries for settlement periods or daily totals, then keep detailed order-level data in Amazon reports or a connector. The right level of detail depends on reporting goals and volume.
The chart of accounts is the foundation of QuickBooks Online setup for Amazon sellers. A default chart often does not have enough detail for FBA fees, referral fees, storage fees, reimbursements, chargebacks, advertising, inventory, COGS, and clearing accounts. If accounts are too broad, the seller cannot see true profit drivers. If accounts are too detailed, the books become hard to maintain.
A good Amazon chart of accounts should be detailed enough to support decisions but simple enough to close every month. The goal is not to create hundreds of accounts for every fee label. The goal is to separate major financial categories so gross sales, refunds, fees, advertising, fulfillment, inventory, and owner activity are not mixed.
| Account Area | Suggested Accounts | Why It Matters |
|---|---|---|
| Income | Amazon Product Sales, Shipping Income, Promotions/Discounts, Reimbursements, Other Marketplace Income | Separates true product revenue from reimbursements, shipping income, discounts, and unusual credits. |
| Contra Income | Refunds, Returns, Chargebacks, Promotional Rebates, Sales Discounts | Shows how much revenue is reduced by customer returns, refunds, coupons, and concessions. |
| Amazon Fees | Referral Fees, FBA Fulfillment Fees, Monthly Subscription, Storage Fees, Removal Fees, Other Amazon Fees | Helps sellers understand platform cost, fulfillment cost, and margin leakage. |
| Advertising | Amazon Ads, Sponsored Products, Sponsored Brands, Sponsored Display, External Advertising | Separates advertising spend from marketplace fees so ACOS/TACOS conversations are easier. |
| Inventory & COGS | Inventory Asset, Inventory in Transit, Freight In, Duties, Prep Fees, Packaging, Cost of Goods Sold | Protects gross margin reporting and prevents inventory purchases from being expensed incorrectly. |
| Clearing | Amazon Clearing, Payment Processor Clearing, Sales Tax Clearing, Inventory Clearing | Allows settlements, deposits, and timing differences to reconcile without distorting income. |
| Liabilities | Sales Tax Payable, Loan Payable, Credit Card Payable, Payroll Liabilities, Gift Card Liability if applicable | Keeps taxes, debt, payroll, and other obligations visible on the balance sheet. |
| Owner & Equity | Owner Contributions, Owner Draws, Shareholder Distributions, Retained Earnings, Member Equity | Separates business expenses from owner withdrawals and equity activity. |
Amazon settlement reconciliation is the heart of Amazon seller bookkeeping. A settlement period shows activity that explains a payout. The bank deposit is only the final net result. QuickBooks should reflect the full story: gross sales, refunds, fees, taxes, reimbursements, reserves, and net deposit. Without this step, the profit and loss statement can be wrong even when the bank account is reconciled.
A common workflow is to post settlement activity to the proper income, expense, liability, and clearing accounts, then match the net payout to the bank deposit. The clearing account should end near zero after the settlement is posted and matched. If it does not, there may be timing differences, reserve changes, missing fees, duplicate entries, or incorrect mapping.
Get the Amazon settlement report or payment activity for the period being reconciled.
Break out sales, refunds, fees, tax, reimbursements, advertising, reserve activity, and other adjustments.
Record the settlement summary to the correct QuickBooks accounts, using Amazon Clearing as needed.
Match the net payout from Amazon Clearing to the bank deposit in the bank feed.
Investigate differences caused by reserves, timing, duplicate postings, missing settlements, or incorrect mapping.
Save the settlement report, journal entry, bank match, and review notes in the monthly close folder.
The bank account can reconcile while Amazon income is still wrong. Settlement reconciliation makes the financial reports useful, not just balanced.
Amazon sellers should not put every deduction into one account called “Amazon fees.” Some fee grouping is fine, but the books should still show enough detail to explain profitability. Referral fees, FBA fulfillment fees, storage fees, removal fees, monthly subscription charges, advertising, refunds, and shipping costs affect the business in different ways.
For FBA sellers, fulfillment fees and storage fees are central to margin. For FBM sellers, shipping supplies, postage, carrier charges, packaging, and warehouse costs may be more important. For private label sellers, advertising and inventory costs often control profit. For wholesale or arbitrage sellers, product cost and reimbursement tracking may matter more.
Inventory is where many Amazon seller QuickBooks setups break. Buying inventory is not the same as selling inventory. If a seller buys $50,000 of product in March but sells only part of it in April, the March purchase should not automatically become March cost of goods sold. Inventory is usually an asset until the products are sold, then the related cost moves to COGS.
Some sellers track inventory directly inside QuickBooks Online. Others use an inventory system, Amazon reports, spreadsheets, or a connector and post monthly summary entries. The best method depends on SKU count, product bundles, landed cost complexity, purchase order workflow, warehouse movement, multi-channel sales, and the level of reporting needed.
| Inventory Method | Best For | Watch Out For |
|---|---|---|
| QuickBooks item tracking | Smaller catalogs with simple products, stable costs, and manageable SKU volume. | Can become difficult with high SKU counts, bundles, landed cost complexity, FBA transfers, and multi-channel inventory. |
| Monthly summary entries | Sellers using Amazon reports, spreadsheets, or outside inventory systems for detailed SKU tracking. | Needs disciplined month-end review so inventory asset and COGS stay accurate. |
| Third-party inventory system | Multi-channel brands with purchase orders, bundles, warehouses, landed cost, and detailed SKU reporting. | Requires clean mapping between inventory system, Amazon, QuickBooks, and bank activity. |
| CPA year-end adjustment only | Very small sellers with simple activity and professional tax review at year end. | Monthly profit may be misleading during the year if purchases and COGS are not reviewed regularly. |
Sales tax is another area where Amazon seller books can become confusing. Amazon may collect and remit tax on many marketplace orders under marketplace facilitator rules, but the seller may still have sales tax obligations for other channels, states, or direct website sales. QuickBooks should not treat every tax amount as business income or expense without review.
The setup depends on where the seller sells, whether Amazon is the only channel, whether Shopify or wholesale sales exist, and whether the seller has registrations outside Amazon. Marketplace-collected tax, seller-collected tax, tax remitted, tax withheld, and tax liability should be separated so the balance sheet and reports are clear.
Tax collected and remitted by Amazon should be reviewed separately from true product revenue.
Shopify, WooCommerce, or wholesale sales may create seller-collected tax that needs liability tracking.
Payments to states should reduce the liability account, not become random tax expense.
Sales tax setup should be reviewed with a sales tax professional, especially for multi-state, multi-channel, wholesale, or international sellers.
After the chart of accounts and settlement workflow are planned, connect business bank accounts and credit cards. The goal is to import real cash activity without creating duplicate income. For Amazon deposits, bank feed rules should usually match deposits to clearing or already-posted settlement entries, not create new sales every time money arrives.
Credit cards should be reconciled monthly because Amazon sellers often have recurring subscriptions, software, advertising, supplies, samples, contractor payments, 3PL charges, storage costs, and travel expenses. Personal charges should be removed or classified correctly as owner activity. Business expenses paid personally should be reimbursed through a clean process instead of being hidden.
Amazon sellers can enter settlement summaries manually, import CSV files, use journal entries, or connect an ecommerce accounting app. A connector can save time, but it is not magic. If the mapping is wrong, a connector can create thousands of incorrect transactions faster than a human could. Before connecting any app, define the chart of accounts and decide how detailed the data should be.
Some sellers prefer settlement-level summaries because they keep QuickBooks clean and still support tax-ready books. Other sellers need order-level detail because of channel analytics, product profitability, sales tax, multi-currency, or high-volume operations. The right setup depends on how the seller uses reports and how much detail is already available outside QuickBooks.
| Data Method | Good For | Main Risk |
|---|---|---|
| Manual settlement entry | Small sellers, low order volume, simple channels, or monthly bookkeeping service workflows. | Can be slow if volume grows or if fee mapping becomes complex. |
| CSV import | Sellers who want more control and can standardize monthly import files. | Template errors, duplicate imports, and inconsistent Amazon report formatting. |
| Connector app | Higher-volume sellers, multi-channel sellers, or brands needing automated summarized postings. | Incorrect mapping can create duplicate sales, wrong taxes, cluttered customers, and hard cleanup. |
| Order-level sync | Special cases needing detailed transaction-level reporting inside QuickBooks. | Can overload QuickBooks with too many customers, products, and transactions. |
Setup is not finished until the reports are useful. Amazon sellers need more than a basic profit and loss statement. They need reports that show gross sales, refunds, Amazon fees, fulfillment costs, advertising, inventory, gross margin, owner activity, cash, sales tax, and open questions. A report package helps the seller and CPA review the business faster.
Review revenue, refunds, fees, ads, COGS, operating expenses, and net profit.
Review cash, inventory, credit cards, loans, sales tax, equity, and clearing accounts.
Review referral fees, FBA fees, storage fees, advertising, and fulfillment costs.
Review inventory purchases, inventory asset balance, COGS, and gross margin reasonableness.
The most important monthly report for Amazon sellers is often not a single report. It is the combination of P&L, balance sheet, settlement reconciliation, inventory summary, fee review, and open-items list. Together, those reports show whether the books are truly closed or only partially reconciled.
Once QuickBooks is configured, use the same close process every month. Monthly closing prevents small mapping errors from becoming expensive cleanup projects. It also gives the seller better data for pricing, restocking, advertising, cash flow, tax estimates, and business decisions.
Download Amazon settlement reports, bank statements, credit card statements, ad reports, supplier invoices, and payroll reports.
Record Amazon settlements to sales, refunds, fees, advertising, sales tax, reimbursements, and clearing accounts.
Reconcile bank accounts, credit cards, PayPal, Stripe, loans, and Amazon clearing balances.
Update inventory, landed costs, purchases, adjustments, and COGS based on the chosen inventory method.
Review P&L, balance sheet, gross margin, fee detail, sales tax, cash flow, and open items.
Save monthly reports and source documents in a clean folder for CPA review and future questions.
Most QuickBooks problems for Amazon sellers come from starting too fast. The seller connects Amazon, connects the bank, accepts transactions, creates broad rules, and later realizes that sales, fees, refunds, inventory, sales tax, and owner draws are all mixed together. Cleanup can take much longer than proper setup.
Consider an Amazon FBA seller with private label inventory. The seller buys products from a supplier, pays freight and prep costs, sends inventory to Amazon, runs Sponsored Products ads, receives Amazon settlement deposits every two weeks, and sells through Shopify as a secondary channel. A basic QuickBooks setup would not be enough.
In this example, QuickBooks should separate Amazon sales, Shopify sales, refunds, Amazon referral fees, FBA fulfillment fees, storage fees, advertising, inventory asset, freight-in, prep fees, packaging, COGS, sales tax, bank accounts, credit cards, loans, owner draws, and income tax payments. Settlement entries should clear to the Amazon bank deposits, and inventory should be reviewed monthly so gross margin is not distorted by large supplier purchases.
Amazon settlement reports feed summarized sales, refunds, reimbursements, fees, and tax activity.
Supplier bills, freight, duties, prep, packaging, and ending inventory support the monthly COGS entry.
Net settlements match to bank deposits, while credit cards and loans are reconciled separately.
A seller can set up QuickBooks alone when volume is low and the workflow is simple. Professional setup becomes more valuable when the seller has many SKUs, several years of messy books, multiple channels, inventory loans, sales tax concerns, high ad spend, employees, contractors, or an upcoming tax deadline. Setup help can also be useful before switching accountants, applying for financing, preparing for sale, or considering S-Corp treatment.
Old Amazon deposits were recorded as sales and inventory was expensed incorrectly.
Order volume, SKU count, and settlement complexity are too large for manual review.
The CPA needs clean reports, settlement support, and inventory numbers before filing.
The seller needs reliable profit, cash flow, fee, and margin data to make decisions.
Continue your setup with official QuickBooks resources and related Seller Bookkeeping pages. Official software instructions can help with product settings, bank feeds, sales tax, inventory, and account setup. Seller-specific bookkeeping resources help translate those features into Amazon FBA and ecommerce workflows.
Review QuickBooks Online products, features, pricing, bank feeds, reporting, payroll, inventory, and accounting tools.
Search official QuickBooks support articles for chart of accounts, bank feeds, inventory, sales tax, and reports.
Review Amazon selling tools, marketplace basics, seller programs, fulfillment options, and seller education resources.
Use Seller Central to access payments, settlements, reports, advertising, inventory, and order activity for bookkeeping support.
Build a stronger bookkeeping system with related Seller Bookkeeping pages. These internal resources support Amazon accounting, monthly close, tax preparation, profitability review, templates, and clean reporting for online sellers.
Learn how Amazon sellers should track settlements, fees, refunds, FBA costs, FBM expenses, inventory, and SKU profitability.
Prepare better year-end records with clean reports, organized documents, and bookkeeping support your CPA can use.
Use a practical month-end close workflow for sales, payouts, bank reconciliation, inventory, COGS, and reports.
Download free Excel and Google Sheets templates for ecommerce bookkeeping, profitability tracking, and seller records.
Seller Bookkeeping helps Amazon sellers configure QuickBooks Online, clean up old records, reconcile settlements, review inventory and COGS, organize sales tax activity, and prepare monthly tax-ready reports. A cleaner setup gives you better profit visibility and fewer year-end surprises.
Schedule Free ConsultationYes. QuickBooks Online can support Amazon seller bookkeeping when it is configured correctly. The setup should include a seller-specific chart of accounts, Amazon clearing accounts, settlement reconciliation, bank feeds, inventory and COGS workflow, sales tax handling, and monthly reporting procedures.
It depends on volume and workflow. Some sellers use manual settlement summaries, some use CSV imports, and some use connector apps. The safest approach is to define the chart of accounts and mapping first, then test one settlement before importing large amounts of data.
No. A net Amazon bank deposit should not be treated as gross sales. The settlement may include sales, refunds, fees, FBA charges, advertising, tax activity, reserves, reimbursements, and timing differences. The settlement should be reconciled before the deposit is matched.
Amazon sellers usually need accounts for product sales, shipping income, refunds, discounts, reimbursements, referral fees, FBA fees, storage fees, advertising, inventory, COGS, sales tax liability, clearing accounts, shipping costs, software, contractors, and owner activity.
Not always. Some sellers track inventory in QuickBooks, while others use Amazon reports, spreadsheets, or third-party inventory software and post monthly summary entries. The right method depends on SKU count, landed cost complexity, bundles, warehouses, and reporting needs.
Major FBA fee categories should usually be separated enough to support margin review. Common accounts include referral fees, FBA fulfillment fees, monthly storage fees, removal fees, subscription charges, and other Amazon fees. Advertising should usually be tracked separately from FBA fees.
Sellers should separate marketplace-collected tax from seller-collected tax. Amazon may collect and remit tax on many marketplace orders, while direct website or wholesale sales may create separate obligations. Multi-state sellers should review sales tax setup with a qualified sales tax professional.
Amazon settlements should be reviewed at least monthly. Many sellers reconcile by settlement period, then close the month after all bank accounts, credit cards, clearing accounts, inventory, COGS, and reports are reviewed.
Use bank rules carefully. A rule that categorizes every Amazon deposit as sales can create inaccurate income. It is usually better to post settlement details first and then match the bank deposit to Amazon Clearing or the related settlement entry.
Yes. Seller Bookkeeping can help with QuickBooks Online setup, chart of accounts, Amazon settlement reconciliation, bank feed cleanup, inventory and COGS review, sales tax organization, monthly close workflow, and tax-ready reports.