MOST Amazon Sellers Make This Bookkeeping Mistake

The bookkeeping mistake highlighted in this video is spending hours manually downloading Amazon reports, rebuilding settlement spreadsheets, checking formulas, and reconciling payouts when the work can be structured and automated.

Link My Books connects Amazon and other ecommerce channels with Xero or QuickBooks Online and breaks payouts into sales, refunds, fees, taxes, and adjustments before matching the summary with the bank deposit.

The more serious accounting mistake that often sits behind the manual process is recording only Amazon's net bank deposit as revenue.

An Amazon payout is normally the result of many transactions rather than one sale.

The deposit can contain gross product sales, shipping income, refunds, FBA fees, referral fees, advertising charges, storage costs, tax amounts, reserves, reimbursements, and other adjustments.

When the seller records only the net deposit, revenue and expenses can disappear into one number even when the bank balance appears correct.

This guide explains how Amazon settlement bookkeeping should work, why manual methods fail at scale, what Link My Books automates, and which checks still require the seller, bookkeeper, or accountant.

What Is The Most Common Amazon Bookkeeping Mistake?

The mistake discussed in the video is continuing to perform repeatable Amazon bookkeeping manually every month.

The seller downloads reports, copies figures into spreadsheets, checks totals, creates entries, and tries to match the result with the bank deposit.

A careful manual process can still work at low volume, but it becomes slower and more fragile as marketplaces, currencies, tax treatments, products, and payout adjustments increase.

• The seller spends valuable operating time on repeatable data preparation.

• Spreadsheet formulas and copy-and-paste steps create opportunities for human error.

• The process depends on one person's memory and file structure.

• Month-end bookkeeping can be delayed because the work feels too large.

• Different reports can be used inconsistently from one month to the next.

• The accountant may receive unclear totals without the underlying settlement evidence.

Automation is useful because it makes the same structured process repeatable.

Automation is not permission to stop reviewing the output.

The More Dangerous Mistake: Recording Net Payouts As Sales

Amazon does not usually deposit the full customer sales amount into the seller's bank account.

Amazon deducts or adds marketplace transactions before sending the settlement.

The bank deposit is therefore a net cash movement rather than the complete revenue figure.

Recording the deposit as sales can understate gross revenue and hide marketplace expenses.

It can also make tax returns, profit analysis, lending records, and a future business sale harder to support.

Worked Amazon Settlement Example

Assume an Amazon settlement contains $20,000 of customer sales and several deductions.

The bank receives $13,000, but the business did not make only $13,000 in gross sales.

A complete bookkeeping entry preserves the $20,000 sales figure and records the refunds and Amazon costs in their correct categories.

The entry then reconciles to the $13,000 deposit.

The example excludes tax treatment and is provided only to explain the gross-to-net settlement structure.

Why Amazon Settlement Reports Are Difficult

Amazon settlements combine many transaction types across a date range.

• Orders can be placed, shipped, refunded, or adjusted in different periods.

• Fees can be charged at the order, product, fulfillment, storage, advertising, or account level.

• Marketplace-facilitator tax and seller tax obligations can follow different rules.

• Multi-country sellers can have several currencies and tax registrations.

• Reserves can move cash into a later settlement.

• Reimbursements and corrections can relate to older transactions.

• The payout date can differ from the transaction dates inside the settlement.

The bank statement proves the cash movement, but it does not explain the economic activity that created it.

The settlement detail provides the bridge between marketplace activity and the bank deposit.

Why Manual Bookkeeping Takes So Long

The manual process usually contains more steps than the seller remembers.

• Download the correct Amazon settlement report.

• Confirm the marketplace, merchant account, date range, and currency.

• Separate sales, refunds, fees, taxes, reimbursements, and adjustments.

• Map each group to the correct general-ledger account.

• Apply the correct tax code.

• Create the entry in Xero or QuickBooks.

• Match the entry with the bank deposit.

• Investigate any difference.

• Store the source reports and working papers.

Repeating these steps across several merchant accounts and sales channels can consume hours every month.

The work also becomes difficult to delegate when the procedure exists only in the owner's spreadsheet.

What Link My Books Automates

Link My Books imports payout data from supported ecommerce channels and prepares structured settlement summaries for Xero or QuickBooks Online.

The automation reduces manual data preparation while preserving the gross-to-net breakdown.

The seller or accountant should review the setup before allowing unattended posting.

Link My Books Does Not Replace Xero Or QuickBooks

Link My Books is an ecommerce data and reconciliation layer rather than a complete replacement for the general ledger.

Xero or QuickBooks remains the bookkeeping system where the wider business accounts are maintained.

The accounting platform can still contain bank accounts, supplier bills, payroll, loans, fixed assets, taxes, and other non-marketplace transactions.

Link My Books focuses on converting complicated marketplace and sales-channel payouts into cleaner accounting entries.

My Amazon to QuickBooks and Xero integration guide explains this relationship in more detail.

How Amazon To Xero Bookkeeping Works

The Amazon-to-Xero workflow creates a settlement summary and then matches it with the deposit imported into the Xero bank feed.

• Connect the correct Amazon merchant account.

• Connect the correct Xero organization.

• Complete the account and tax mapping.

• Review an Amazon payout inside Link My Books.

• Send the payout summary to Xero.

• Open the Xero bank reconciliation screen.

• Match the Link My Books entry with the Amazon deposit

• Investigate any amount or currency difference.

Link My Books provides a dedicated Amazon to Xero integration for supported sellers.

Test several settlements manually before switching on automatic posting.

How Amazon To QuickBooks Online Bookkeeping Works

The QuickBooks Online workflow follows the same principle but posts the prepared Amazon settlement into the connected QuickBooks company.

• Connect the Amazon merchant account.

• Connect the correct QuickBooks Online company.

• Map sales, refunds, fees, taxes, and clearing accounts.

• Review the settlement breakdown.

• Send or automatically post the summary.

• Match the entry with the Amazon bank deposit.

• Review the profit-and-loss and balance-sheet effect.

The official Amazon to QuickBooks integration explains the supported workflow.

Link My Books supports QuickBooks Online rather than every desktop or regional accounting product.

Why Bank Reconciliation Still Matters

Automation is incomplete until the accounting entry agrees with the actual cash received.

Bank reconciliation confirms that the settlement summary and deposit belong together and that the amount is correct.

• Match the exact payout amount.

• Confirm the deposit currency and bank account.

• Check whether currency conversion or bank fees changed the received amount.

• Confirm the payout was not split or combined.

• Investigate settlement reserves and delayed transactions.

• Do not force a match by creating an unexplained adjustment.

Xero describes bank reconciliation as matching bank statement lines with transactions in the accounting records.

The same control applies when using QuickBooks Online.

Do Not Post Every Amazon Order Individually

Posting every individual Amazon order into the general ledger can create unnecessary volume and slow the accounting system.

A settlement-summary approach can preserve the important categories while keeping the ledger manageable.

The appropriate level of detail should be agreed with the accountant and matched to reporting, tax, audit, and management needs.

Gross Revenue Is Not Profit

Amazon sellers often discuss top-line sales while the real decision should be based on profit and cash flow.

Correct settlement bookkeeping records gross sales and marketplace expenses, but it still does not calculate complete product profit by itself.

• Deduct cost of goods sold.

• Deduct inbound freight and duties.

• Deduct Amazon fees and advertising.

• Deduct returns and inventory losses.

• Deduct software, payroll, insurance, and professional costs.

• Account for taxes according to professional advice.

• Review working-capital and inventory cash requirements.

Revenue shows the scale of customer purchases.

Profit shows what remains after the business costs are recognized.

Cost Of Goods Sold Must Be Recorded Separately

Amazon settlement reports do not know the complete landed cost of each unit unless a separate inventory and COGS process supplies it.

COGS usually includes the inventory cost recognized when the related product is sold.

• Maintain accurate SKU-level product costs.

• Include appropriate inbound freight, duty, inspection, prep, and landed-cost components.

• Update costs when supplier or freight prices change.

• Record damaged, destroyed, donated, or written-off inventory correctly.

• Reconcile inventory records with actual stock and Amazon reports.

Link My Books currently advertises COGS tracking, but the result depends on accurate product costs and inventory information.

Ask the accountant how inventory should be valued under the business's accounting framework.

VAT, GST, And Sales Tax Need Different Treatment

Ecommerce taxes cannot be handled safely with one universal tax rate.

The correct treatment depends on the seller entity, customer location, marketplace, inventory location, registration status, product tax category, and local law.

Link My Books advertises built-in support for VAT, GST, and sales tax, but software settings must match professional advice.

My Link My Books UK VAT automation guide covers the UK-focused workflow.

Wrong Product Tax Codes Can Create Large Errors

A product tax-code mistake can cause the wrong VAT or sales-tax treatment to be applied repeatedly across many orders.

• Review the tax category assigned to every important SKU.

• Separate standard-rated, reduced-rated, zero-rated, exempt, and out-of-scope products correctly.

• Check bundles containing products with different tax treatment.

• Review new products before the first settlement is posted.

• Audit historical periods when a tax-code problem is discovered.

• Keep evidence supporting the chosen treatment.

The software can automate a tax rule only after the rule has been configured correctly.

A consistent wrong setting can create a larger error faster than manual bookkeeping.

Marketplace Facilitator Tax Is Not Free Revenue

Amazon can calculate, collect, or remit certain taxes under marketplace-facilitator rules, but the accounting presentation still needs to be correct.

The seller should not automatically treat every tax amount visible in a marketplace report as business revenue or an expense.

The treatment depends on whether the amount belongs to the seller, Amazon, or a tax authority under the applicable rules.

Use the Link My Books setup wizard and review the result with a qualified accountant who understands ecommerce and the seller's jurisdictions.

Refunds Need More Than One Accounting Line

An Amazon refund can affect revenue, tax, fees, inventory, and cash in different ways.

• Reverse or reduce the relevant sales amount.

• Apply the correct tax reversal.

• Record any refund administration or retained fees.

• Determine whether the returned item is sellable, damaged, lost, or disposed of.

• Adjust inventory and COGS when required.

• Track reimbursements separately from the original refund.

A net payout-only method hides these connected effects.

A structured settlement workflow makes refunds visible but does not replace inventory-condition decisions.

Amazon Fees Need Useful Categories

Recording all Amazon deductions in one generic fee account can limit management reporting.

The chart of accounts should be detailed enough to support decisions without becoming impossible to maintain.

Agree on the account structure before enabling automatic posting.

Reimbursements Are Not Normal Product Sales

Amazon reimbursements can relate to lost inventory, damaged inventory, fee corrections, customer returns, or other operational events.

They should be mapped according to their economic meaning rather than automatically added to ordinary product sales.

• Identify why the reimbursement was paid.

• Check whether the related inventory or expense was already recorded.

• Avoid recognizing the same recovery twice.

• Keep the Amazon case or settlement evidence.

• Review material or unusual reimbursements with the accountant.

A reimbursement can improve cash for the period without representing new customer demand.

Use A Clearing Account For Amazon Payouts

Many settlement workflows use a clearing account to connect the marketplace activity with the bank deposit.

The settlement summary moves sales, refunds, fees, taxes, and adjustments through the clearing balance.

The bank deposit then clears the amount when the payout is received.

• The opening clearing balance should be understood.

• Each settlement should create a traceable movement.

• The deposit should match the related settlement.

• Uncleared balances should be investigated.

• Old differences should not be hidden with unexplained journals.

The exact account names and posting structure should be designed with the bookkeeper or accountant.

Why Month-End Close Should Not Wait Until Tax Season

Waiting until the tax deadline makes errors harder to find and business decisions less useful.

• Post and reconcile every completed marketplace payout.

• Review uncleared Amazon balances.

• Check missing or duplicated settlements.

• Review refunds, reimbursements, reserves, and large adjustments.

• Update inventory and COGS.

• Review sales-tax, VAT, or GST accounts.

• Review the profit-and-loss statement and balance sheet.

• Compare performance by marketplace and channel.

A monthly close turns bookkeeping into an operating tool rather than an annual compliance emergency.

A Practical Monthly Amazon Bookkeeping Workflow

Document who owns each stage so no one assumes another person completed it.

How To Set Up Link My Books Safely

• Create the Link My Books account.

• Connect the correct Amazon merchant account or ecommerce channel.

• Connect the correct Xero organization or QuickBooks Online company.

• Complete the guided setup with the bookkeeper or accountant.

• Review chart-of-accounts mappings.

• Review VAT, GST, sales-tax, and product tax settings.

• Process one or two settlements manually.

• Confirm that the bank deposits reconcile.

• Review the financial-statement result.

• Enable automatic posting only after the workflow is approved.

Do not connect a production accounting file and immediately auto-post several years of data without reviewing the setup.

Use a controlled start date that follows the last completed manual period.

What To Check Before Turning On Autopost

• The correct Amazon account is connected.

• The correct accounting company is connected.

• The chart-of-accounts mappings are approved.

• Tax settings are approved.

• Historical opening balances are understood.

• Several manual postings reconcile correctly.

• Duplicate posting controls have been tested.

• The accountant approves the start date.

• The team knows how to pause and investigate an error.

Automation should repeat a proven process rather than automate uncertainty.

How To Test The Free Trial

Link My Books currently advertises a 14-day free trial without a credit card.

• Connect one main sales channel.

• Connect the bookkeeping platform.

• Review the guided setup.

• Open several real settlements.

• Check the breakdown of sales, refunds, fees, and taxes.

• Send one entry to a test or controlled accounting period.

• Match the deposit in the bank feed.

• Ask the accountant to review the result.

• Estimate monthly time saved.

The trial is most useful when the necessary account access and accountant availability are prepared before it begins.

Review the latest plan rules through the official Link My Books pricing page.

How To Use Coupon Code VOVA20

The supplied Link My Books coupon code is VOVA20.

The offer provides 50% off for the first three paid months when the code is eligible and accepted at checkout.

• Start through the supplied free-trial link.

• Complete the trial and confirm that the workflow fits the business.

• Choose the appropriate paid plan.

• Enter VOVA20 during checkout.

• Confirm that the first three paid months show the expected 50% discount.

• Review the full renewal price before subscribing.

Coupon eligibility, plan availability, currency, and checkout terms can change.

Use the final checkout total as the source of truth.

What To Ask During The Free Demo Call

• How will my Amazon merchant accounts and marketplaces count toward the plan?

• How are gross sales, refunds, fees, taxes, reserves, and reimbursements separated?

• How should my chart of accounts be mapped?

• How are mixed VAT or product tax rates configured?

• How does the Xero or QuickBooks reconciliation work?

• How should historical bookkeeping be migrated?

• What happens when a settlement is corrected after posting?

• Which tasks still need my accountant?

• How should Autopost be tested and controlled?

Use a real anonymized settlement example during the call when practical.

A personalized walkthrough is more useful than a general feature demonstration.

Who Benefits Most From Link My Books?

• Amazon sellers using Xero or QuickBooks Online.

• Sellers operating across several Amazon regions.

• Ecommerce businesses with several sales channels.

• UK sellers handling VAT and mixed product tax rates.

• Accountants and bookkeepers managing ecommerce clients.

• Sellers spending hours rebuilding settlement reports.

• Businesses preparing for lending, investment, due diligence, or sale.

The software is less useful when the business does not use a supported bookkeeping system or has almost no settlement volume.

The value should be measured against time saved, error reduction, reporting quality, and the current subscription cost.

Who Still Needs An Ecommerce Accountant?

Bookkeeping automation organizes data, but a qualified professional may still be needed for accounting judgments and compliance.

• Entity structure and accounting framework.

• VAT, GST, sales-tax, income-tax, and corporate-tax advice.

• Inventory valuation and COGS policy.

• Foreign currency and cross-border treatment.

• Loans, payroll, fixed assets, and owner transactions.

• Year-end accounts and tax returns.

• Historical corrections, audits, and tax-authority questions.

Choose an accountant or bookkeeper who understands ecommerce settlements rather than assuming every general practitioner knows Amazon reporting.

Bookkeeping Records To Keep

Tax authorities and financial reporting rules can require businesses to maintain supporting records for income and expenses.

• Amazon settlement and transaction reports.

• Bank and payment-account statements.

• Supplier invoices and inventory purchases.

• Freight, duty, inspection, and prep invoices.

• Amazon fee and advertising records.

• Refund, reimbursement, and claim evidence.

• VAT, GST, sales-tax, and tax-return working papers.

• Link My Books summaries and accounting entries.

• Inventory counts and valuation support.

The IRS recordkeeping guidance explains that business records should support income, expenses, and tax-return items.

Retention requirements differ by country and situation, so follow professional advice.

Common Amazon Bookkeeping Mistakes

• Recording the net Amazon deposit as sales.

• Using the wrong Amazon report.

• Downloading incomplete date ranges.

• Combining several marketplaces or currencies incorrectly.

• Ignoring refunds, reimbursements, reserves, or adjustments.

• Mapping every Amazon fee into one unclear account.

• Applying one tax rate to every product and country.

• Failing to record COGS and inventory changes.

• Posting settlements but not reconciling the bank.

• Using spreadsheets with undocumented formulas.

• Turning on automation before testing the setup.

• Waiting until the tax deadline to update the books.

How To Fix Historical Amazon Bookkeeping

• Stop adding new entries through the incorrect method.

• Identify the first affected accounting period.

• Download the related settlement and bank records.

• Compare recorded net deposits with the full gross-to-net breakdown.

• Identify missing sales, fees, refunds, taxes, and adjustments.

• Review filed tax returns and financial statements with the accountant.

• Prepare controlled correcting entries.

• Reconcile the clearing and bank accounts.

• Document the correction and new monthly procedure.

Do not delete or rewrite filed-period data without professional review.

A historical correction can affect tax, profit, inventory, loans, and prior financial statements.

Bookkeeping Automation Controls

Good automation makes errors visible and traceable.

Poor automation can repeat the same mistake across every settlement.

Use Bookkeeping Data To Make Better Decisions

Once Amazon settlement data is structured correctly, the seller can ask better questions.

• Which marketplace produces the most profit rather than only revenue?

• Which fees are increasing fastest?

• How much revenue is lost to refunds?

• Which channel creates the strongest contribution margin?

• How much cash is tied up in inventory?

• Can the business afford the next order and advertising plan?

• Are tax and reserve balances reducing available cash?

Accurate books cannot guarantee a good decision, but inaccurate books can make a bad decision look profitable.

My three common ecommerce bookkeeping mistakes guide explains the related problems discussed with Daniel Little.

Frequently Asked Questions

What Is The Amazon Bookkeeping Mistake In The Video?

The video focuses on sellers spending too much time manually downloading reports, working in spreadsheets, checking figures, and reconciling settlements instead of automating the repeatable process.

Why Is Recording The Amazon Payout As Sales Wrong?

The payout is usually a net amount after sales, refunds, fees, taxes, reserves, and adjustments have been combined.

Recording only the deposit can hide gross revenue and expenses.

Should Amazon Sales Be Recorded Gross Or Net?

The books generally need to preserve the relevant gross sales and separate marketplace costs rather than showing only the net deposit.

The exact accounting and tax presentation should be confirmed with the accountant.

What Does Link My Books Do?

Link My Books imports supported ecommerce payout data, groups sales, refunds, fees, taxes, and adjustments, and sends a structured summary to Xero or QuickBooks Online for reconciliation.

Does Link My Books Replace Xero Or QuickBooks?

No, it connects ecommerce channels with Xero or QuickBooks Online and prepares the settlement data for the bookkeeping system.

Does Link My Books Replace An Accountant?

No, software automates data preparation and posting, while an accountant may still be needed for tax, compliance, inventory, financial statements, and accounting judgments.

How Long Is The Link My Books Free Trial?

Link My Books currently advertises a 14-day free trial without a credit card.

What Does Coupon Code VOVA20 Provide?

The supplied code provides 50% off the first three paid months when accepted for an eligible Link My Books subscription.

Can I Book A Link My Books Demo?

Yes, the supplied demo link allows sellers and accountants to book a personalized call with the onboarding team.

Can Link My Books Handle VAT?

Link My Books advertises VAT support, including product grouping and settlement tax calculations, but the configuration must match the seller's actual registrations and professional advice.

Can Link My Books Handle US Sales Tax?

Link My Books advertises sales-tax support, but marketplace-facilitator and seller obligations must be configured and reviewed for the relevant states and business.

Can Link My Books Track COGS?

The current pricing page lists COGS tracking, but accurate output requires correct product costs and inventory information.

Should I Turn On Autopost Immediately?

No, post and reconcile several settlements manually before enabling automatic posting from an approved date.

What If The Payout Does Not Match The Bank Deposit?

Check currency conversion, bank fees, split deposits, reserves, timing, duplicated entries, and the exact settlement account before creating an adjustment.

How Often Should Amazon Books Be Updated?

Process and reconcile settlements regularly and complete a structured month-end close rather than waiting until the tax deadline.

Final Thoughts

The bookkeeping mistake highlighted in the video is wasting hours on repeatable manual work.

The accounting mistake that often accompanies it is treating Amazon's net bank payout as the complete sales figure.

A reliable process preserves gross sales, refunds, fees, taxes, reimbursements, reserves, and other adjustments before reconciling the result with the deposit.

Link My Books can automate much of that workflow by connecting Amazon and other ecommerce channels with Xero or QuickBooks Online.

The software still needs correct mappings, tax settings, product costs, review controls, and professional accounting advice.

Test the process during the free trial, reconcile real settlements, involve the accountant, and enable automatic posting only after the result is approved.

Use VOVA20 for 50% off the first three paid months when the offer is accepted at checkout, or book the free demo call for a personalized walkthrough.