What Makes eBay Reconciliation Different From a Normal Bank Account?

eBay moved all sellers to Managed Payments by 2021, fundamentally changing how eBay accounting works. Before Managed Payments, sellers collected through PayPal — which meant PayPal was the clearing account. Today, eBay itself acts as the payment processor, collects from buyers across every payment method (Visa, Mastercard, Apple Pay, Google Pay, PayPal, Klarna, eBay Gift Cards), and deposits a single net payout directly into your bank account.

That single net payout is the source of all reconciliation complexity. It is not gross sales. It is gross sales minus final value fees, payment processing fees, promoted listing fees, shipping label costs, refunds, payment dispute deductions, and any adjustments — all netted together and deposited as one lump sum. If you click "Add" on that bank deposit and call it "Sales Revenue," you have overstated income, hidden fees, buried refunds, and made your P&L meaningless.

A real eBay payout of, say, $3,200 might actually represent:

Additionally, eBay Managed Payments has several mechanics that make reconciliation harder than most gateways:

• Payout schedule flexibility: Sellers choose daily, weekly, fortnightly, or monthly payouts. eBay makes funds available within 2 business days of confirming the buyer's payment, but the actual payout arrives on your chosen schedule. A daily-payout seller can receive 20+ deposits per month; a monthly seller receives one — but that one deposit covers 30 days of activity with dozens of fee types inside it.

• Final value fees include payment processing: Unlike Stripe or PayPal, eBay does not charge a separate processing fee line. The payment processing cost (~2.9% + $0.30) is bundled into the final value fee. This means you cannot separate "processing fees" from "selling fees" in the payout report — they are one combined number. The FVF rate ranges from approximately 12% to 15% depending on product category plus $0.30 per order.

• Promoted Listings fees (two models): Promoted Listings Standard charges a percentage only when a buyer clicks and purchases within 30 days. Promoted Listings Advanced/Priority charges per click regardless of sale. Both deduction types appear separately in the payout report and must be mapped to an advertising expense account — not to the main fee account.

• eBay shipping labels deducted from payout: If you purchase shipping labels through eBay (USPS, UPS, FedEx via eBay's discounted rates), the cost is deducted directly from your Managed Payments balance — not charged to a credit card. This creates a shipping expense that must be tracked via the payout, not via credit card statement.

• Marketplace Facilitator Tax: eBay collects and remits sales tax to US state governments on behalf of all sellers in all US states under Marketplace Facilitator laws. This tax passes through your eBay balance but is not your liability to remit. If mapped to your own Sales Tax Payable, you will dramatically overstate your tax obligation.

• Payment disputes (chargebacks): eBay handles payment disputes internally. When a buyer opens a dispute, eBay places a hold on the disputed funds within your Managed Payments balance. The hold reduces your available balance immediately. If the dispute is resolved in the buyer's favor, the deduction becomes permanent. If resolved in your favor, the funds are released back into your balance. eBay does not charge a separate dispute fee (unlike Stripe's $15 charge) — the only cost is losing the sale amount if the dispute goes against you.

• The double-counting trap with the native eBay Connector: The built-in eBay Connector by Intuit creates Sales Receipts for each eBay order AND imports the bank deposit from the bank feed. If you "Add" the bank deposit to income instead of matching it to the Sales Receipts via a clearing account, QBO records income twice. This is the most-reported eBay + QBO problem in the Intuit community forums.

Understanding eBay Managed Payments Transaction Types

eBay's Finances API and Transaction Reports categorize activity into these types, all of which PayTraQer maps to QBO:

eBay Transaction Types

How PayTraQer Syncs eBay to QBO

PayTraQer connects to eBay via API and downloads all Managed Payments transactions. The clearing account model works as follows:

1. All sales, fees, refunds, and adjustments are posted into your eBay Bank Account (the clearing account you create in QBO).

2. When eBay initiates a payout, PayTraQer detects it and creates a Bank Transfer from eBay Bank Account → Checking Account for the exact net payout amount.

3. This Bank Transfer appears in QBO's bank feed and can be matched in one click to the eBay deposit.

4. The eBay Bank Account clearing balance approaches $0 after each payout (or holds the in-transit balance if a payout has been initiated but not yet received).

Official PayTraQer documentation confirms: "Choose eBay Bank Account to deposit your Sales and Fees. This will be your clearing account in QuickBooks Online."

Sync Mode Decision for eBay

Consolidated (Summary) Sync: Creates one summarized Sales Receipt per payout period or per day. Best for sellers with more than 20 orders per payout period. The summary matches each payout amount exactly — bank feed matching is automatic and requires no manual per-order review.

Itemized (Individual) Sync: Creates one QBO Sales Receipt per eBay order. Best for low-volume sellers (under 20–30 orders per period) or sellers who need per-customer or per-item records in QBO for warranty, warranty, or warranty purposes. At higher volumes, itemized sync creates hundreds of QBO transactions that slow performance.

Warning: Do not switch between Consolidated and Itemized mode after your first sync. Mixing modes for overlapping date ranges creates duplicate entries. Choose your sync mode before the first sync and keep it consistent.

Step 1 — Prerequisites and QBO Chart of Accounts Setup

Complete this entire step before opening PayTraQer. A correct chart of accounts makes every downstream step automatic and every reconciliation clean.

Create the eBay Clearing Account

1. QBO → Accounting → Chart of Accounts → New

2. Account Type: Bank

3. Detail Type: Checking

4. Name: eBay Bank Account (this is the exact name used in PayTraQer's official documentation)

5. Save and Close.

Why Bank type and not Other Current Asset? Bank type enables QBO's Reconcile function against the clearing account and allows the Banking tab to create Transfers (the mechanism PayTraQer uses for payouts). Using Other Current Asset disables both features.

Create eBay-Specific Expense Accounts

Set these up in QBO Chart of Accounts before mapping them in PayTraQer:

Download Your eBay Source of Truth Reports

Before reconciling, pull these three reports from eBay Seller Hub → Payments tab → Reports:

1. Transaction Report (CSV): Go to Payments tab → Reports → Financial Documents → Create report next to "Transaction reports" → Set date range → Select report type (by Transaction date or Payout date) → Create. This CSV is the line-item detail of every sale, fee, refund, and payout in the period. It includes gross transaction amount, net amount, payout date, order number, and fee breakdown.

2. Financial Statement (PDF): Available under Payments tab → Reports → Financial Documents → Financial Statements. This PDF summarizes orders, refunds, claims, payment disputes, payouts, and fees for the month. The closing balance in this statement is what you enter as the Ending Balance when reconciling eBay Bank Account in QBO.

3. Payouts Report: Payments tab → Payouts section. Shows each individual payout amount, initiation date, receiving account, and payout ID. Use this to confirm that every PayTraQer Bank Transfer in QBO matches a real eBay payout.

Tip: The Transaction Report can be generated by "Transaction date" (when the activity occurred) or "Payout date" (when eBay paid you). For QBO reconciliation purposes, generate it by Payout date — this aligns the report with the PayTraQer Bank Transfers, which are also payout-based.

Step 2 — Product Mapping and Income Classification in PayTraQer

This is the step most users skip, and it is the reason their P&L becomes unreliable after the first auto-sync.

Auto-Create vs. Common Item for eBay

Use a Common Item (Recommended for most eBay sellers):

In PayTraQer → Products & Services Settings:

• Turn OFF Auto-Creation of Products/Services

• Turn ON Common Product/Service

• Item Name: eBay Sales

• Income Account: eBay Sales (the Income account you created above)

PayTraQer will ignore individual eBay item titles and SKUs, posting all product revenue to this one clean income line. This prevents "product bloat" — hundreds of QBO product items created from eBay listing titles that will never be used for invoicing or reporting.

Use Auto-Create only if: You sell a small, consistent catalog (fewer than 30 distinct SKUs) and want product-level revenue reporting inside QBO. In that case:

• Set Type for auto-created items: Non-Inventory Part (for physical goods) or Service (for digital items)

• Set default Income Account: eBay Sales

• Set Match Product by: SKU (more reliable than item title, which changes frequently on eBay listings)

Mapping Special eBay Item Types

In PayTraQer Products & Services Settings, map these separately from the default Common Item:

Step 3 — Configuring PayTraQer Settings for eBay

In PayTraQer → Settings → eBay. Work through each settings block in order before running any sync.

Sales Settings

• Bank Account to Deposit: eBay Bank Account (your clearing account)

• Payment Method: eBay Managed Payments

• Customer: Common Customer (eBay Customer) for Consolidated mode; match by buyer username or email for Itemized mode

• Skip the sales and process the associated fees only: Leave as No — only enable this if another system already records your eBay sales in QBO and you want PayTraQer to handle only the fee side

Tax Settings

• Marketplace-Facilitated Tax: Map eBay's collected sales tax to Marketplace-Facilitated Tax (Other Current Liability) — NOT your regular Sales Tax Payable

• eBay collects and remits this tax to all US states on your behalf. It is not your obligation. Mapping it to Sales Tax Payable will make your tax liability appear dramatically overstated on the Balance Sheet.

• For states where you self-collect (rare for eBay — eBay is the facilitator in all US states as of 2023): map to Sales Tax Payable for those jurisdictions specifically.

• For international sellers (VAT-registered): map VAT separately per jurisdiction in PayTraQer's Tax Accounts Mapping section.

Fees Settings

Map each eBay fee type individually. This is the most critical configuration block:

Critical Rule: The Bank Account for ALL fee types must be set to eBay Bank Account — the same clearing account used in Sales Settings. If any single fee type points to a different account, that fee will not appear in the eBay Bank Account register, the clearing account will not balance, and reconciliation will always show a discrepancy.

Payout Settings

• Enable "Process the Payout": Toggle ON

• Transfer Account: Your real Business Checking Account

• Negative Balance Account: Business Checking Account (handles rare cases where refunds and fees exceed gross sales in a payout period, meaning eBay would attempt to withdraw funds from your bank account to cover the deficit)

This toggle is the most important setting in PayTraQer for eBay. When ON, PayTraQer automatically creates a Bank Transfer from eBay Bank Account → Checking Account every time it detects an eBay payout. This is the entry that enables one-click bank feed matching in QBO. When OFF, no Bank Transfer is created, the bank deposit sits unmatched in "For Review," and reconciliation requires manual intervention every single payout.

Step 4 — Syncing eBay Transactions and Verifying in QBO

Initial Sync

After configuring all settings:

1. In PayTraQer → Connectors → eBay → Transactions Dashboard

2. PayTraQer automatically downloads the last 60 days of eBay data on first connection. For older periods, use Download Historical Transactions with custom date filters.

3. Set the date range for your target period.

4. Click Download Transactions — PayTraQer pulls all orders, fees, refunds, and payouts from eBay Managed Payments.

5. In the Review Tab, verify before syncing:

   • Sales entries show eBay Bank Account as the deposit account — not your Checking Account

   • Fee entries show correct expense accounts with eBay Bank Account as Bank Account

   • Tax column shows Marketplace-Facilitated Tax — not Sales Tax Payable

   • Promoted Listings fees are separate from Final Value Fees

   • Shipping label costs appear as Shipping Expense

   • Payout entries show a Bank Transfer from eBay Bank Account → Checking Account

6. Click Sync to QuickBooks

Before syncing: confirm that the eBay Connector by Intuit (if previously installed) is disconnected or has its bank feed import disabled. Running both simultaneously is the primary cause of double-counting in eBay + QBO setups.

Verify in QBO

Open QBO → Accounting → Chart of Accounts → eBay Bank Account → View Register. You should see:

• Sales Receipts or Journal Entries (gross sales)

• Expense entries for each fee type

• A Bank Transfer for each eBay payout to Checking

• The running balance approaching $0 after each payout Transfer (or the in-transit balance if a payout has been initiated but not yet deposited to your bank)

If any balance remains in eBay Bank Account beyond what is explained by in-transit payouts, a fee, refund, or adjustment was not synced. Cross-reference the eBay Transaction Report CSV.

Enable Auto-Sync

After verifying the initial sync: PayTraQer → Automation Settings → Enable Auto-Sync. Set the sync frequency (daily or every few hours). PayTraQer will pull new eBay orders, fees, and payouts automatically and post them to QBO without manual action.

Step 5 — The QBO Bank Feed Matching Process

When eBay Managed Payments deposits a payout into your bank account (per your chosen payout schedule):

1. Go to QBO Banking → Banking → For Review (your Checking Account)

2. Find the eBay deposit — it appears as "eBay" or "EBAY INC" or "EBAY MANAGED PAYMENTS" in the payee column

3. Because PayTraQer created a Bank Transfer from eBay Bank Account → Checking for this exact net amount, QBO will highlight it in green and suggest a Match

4. Click Match

Never click "Add." Clicking Add records the eBay payout as new income in your Checking Account — completely duplicating the revenue, fees, and refunds that PayTraQer already posted to eBay Bank Account. This is the exact double-counting problem documented in the Intuit QuickBooks community forums for eBay Managed Payments.

What If QBO Doesn't Suggest a Match Automatically?

If the eBay deposit sits in "For Review" without a green Match suggestion, check:

• Amount mismatch: A payment dispute hold or a promotional fee credit altered the final payout amount compared to what PayTraQer calculated. Open the eBay Payouts section in Seller Hub, click on the specific payout, and compare its components to what PayTraQer posted.

• Date mismatch: eBay initiates the payout on one date; your bank receives it 1–2 business days later. Expand the date range in the QBO Match window to look further back.

• Payout toggle OFF: If PayTraQer's "Enable Process the Payout" toggle was OFF when the sync ran, no Bank Transfer was created. See the troubleshooting section.

• Payout ID mismatch: For daily payout sellers, multiple eBay deposits may arrive on the same day from different payout cycles. Match each deposit to its corresponding Bank Transfer individually.

Creating a QBO Bank Rule for eBay Deposits

For ongoing efficiency, create an automatic bank rule:

1. QBO Banking → Rules → New Rule

2. Condition: Bank text contains "eBay" or "EBAY"

3. Action: Transfer from eBay Bank Account

QBO will then automatically pre-categorize future eBay deposits as Transfers, reducing each month-end matching task to a batch confirmation click.

Step 6 — Reconciling the Accounts in QBO

Reconcile the eBay Bank Account (Clearing Account)

This is the reconciliation that matters most for accuracy — and the one most bookkeepers forget to do.

1. QBO → Accounting → Reconcile

2. Select account: eBay Bank Account

3. Ending Balance: Enter the closing balance from your eBay Financial Statement PDF (available in Seller Hub → Payments → Reports → Financial Statements). If all payouts for the month have been received, this figure is $0. If a payout was initiated near month-end and is still in transit to your bank, it will be the in-transit payout amount.

4. Ending Date: Last day of the month

5. Click Start Reconciling

6. Check off:

   • All Sales Receipts or Journal Entries (gross sales, shipping income)

   • All Fee Expense entries (FVF, listing fees, advertising, shipping labels, store subscription)

   • All Refund entries

   • All Bank Transfers to Checking (payouts)

7. Difference must read $0.00

8. Click Finish Now and save the reconciliation report PDF for your client folder

If the Difference is not $0.00: The most common causes are: a Promoted Listings fee not mapped in PayTraQer Fees Settings; a payment dispute hold not yet resolved (leave it as an open item — it will clear when eBay resolves the dispute); a shipping label cost not synced; or a eBay Store subscription fee charged but not mapped. Cross-reference the eBay Transaction Report CSV to identify the missing line.

Reconcile the Main Checking Account

After completing the eBay Bank Account reconciliation, proceed with your standard bank account reconciliation. All matched eBay Bank Transfers will already appear as cleared items.

Fixing the Double-Counting Problem: The #1 eBay + QBO Error

Double-counting eBay income is the most commonly reported eBay reconciliation problem in Intuit community forums, and it has one specific cause: using the eBay Connector by Intuit (or the eBay Managed Payments app) alongside PayTraQer, or clicking "Add" on bank deposits instead of "Match."

How It Happens

Scenario A — Two connectors active simultaneously:
The native eBay Managed Payments app in QBO creates Sales Receipts for each eBay order. PayTraQer also creates its own Sales Receipts (or Journal Entries) for the same orders. Both post to the same income account. QBO now shows twice the income.

Scenario B — "Add" instead of "Match" on bank deposits:
The bookkeeper clicks "Add" on the eBay deposit in QBO Banking, recording it as income in the Checking Account. PayTraQer has already posted the same income to eBay Bank Account. The P&L now reflects income from both the clearing account entries AND the bank deposit entry.

The Fix (Step by Step)

1. Disconnect the native eBay Connector/App if it is active alongside PayTraQer. In QBO → Apps → My Apps → Find "eBay Managed Payments" or "eBay Connector" → Disconnect. This stops new duplicate entries from being created.

2. Identify the period affected. Run a QBO Profit & Loss for the period and compare to your eBay Financial Statement. If QBO income is roughly double the eBay statement total, the full period is affected.

3. Undo the "Added" bank deposits. QBO Banking → Categorized → Filter by Checking Account → Search for "eBay" → Find all entries that were Added (not Matched) → Click Undo on each. These return to For Review.

4. Delete any manually created Sales Receipts or Journal Entries for eBay income that were not created by PayTraQer. Search QBO Transactions for eBay income entries outside the PayTraQer-created records and delete them.

5. Confirm PayTraQer has correctly synced the period. In PayTraQer Transactions Dashboard → verify all transactions show "Synced" status for the affected date range. Re-sync any that failed.

6. Return to QBO Banking → For Review. Each eBay deposit should now have a green Match suggestion pointing to the PayTraQer Bank Transfer. Click Match on each.

7. Re-run P&L. Compare to eBay Financial Statement — income should now match.

Common eBay-Specific Scenarios and Fixes

Final Month-End Checklist for eBay + QBO Reconciliation

•  eBay Transaction Report CSV downloaded (by Payout date) from Seller Hub for the period

•  eBay Financial Statement PDF downloaded — closing balance noted for reconciliation

•  eBay Payouts Report downloaded — each payout ID and amount confirmed

•  Native eBay Connector by Intuit confirmed as disconnected (to prevent double-counting)

•  All eBay payouts confirmed as "Synced" in PayTraQer Transactions Dashboard — no red errors

•  Marketplace-Facilitated Tax mapped to Marketplace-Facilitated Tax pass-through — NOT Sales Tax Payable

•  Promoted Listings fees (Standard and Advanced) mapped separately to eBay Advertising expense

•  Shipping label costs mapped to Shipping Expense account

•  eBay Store subscription fee mapped (or found on credit card statement and categorized manually)

•  Any open payment dispute holds documented — left as open items in eBay Bank Account

•  Each eBay bank deposit Matched (not Added) in QBO Banking For Review

•  QBO Bank Rule for "eBay" deposits confirmed — set to Transfer from eBay Bank Account

•  eBay Bank Account clearing reconciled to Financial Statement closing balance — Difference $0.00

•  P&L reviewed: eBay Sales correct; FVF, Advertising, Shipping separate expense lines; Marketplace Tax zero-net on Balance Sheet

•  Any negative payout (reverse Transfer) documented and matched to the bank debit

•  Reconciliation PDF saved to client folder