How to Reconcile Marketplace Facilitator Settlements in QuickBooks Online

October 6, 2026

Bottom line: A marketplace payout is a settlement, not a sales total. Reconcile gross order activity to refunds, discounts, facilitator-collected tax, platform fees, reserves, chargebacks, and the cash transferred. Keep the platform’s tax role visible and let a tax professional determine filing treatment. Posting only the net deposit can understate sales, hide costs, and make customer or tax reports impossible to support.

Map the platform’s money flow

Document each marketplace separately. Identify the selling entity, storefront, settlement currency, payout bank, order system, payment processor, statement timezone, cutoff time, payout frequency, and accounting integration. Record whether the platform says it collects and remits tax as a marketplace facilitator and in which jurisdictions. Do not apply one platform’s setup to another channel.

Obtain the marketplace agreement, current tax settings, transaction export, settlement statement, fee schedule, reserve report, and bank deposit. Keep the report filters and download time. Platform dashboards can revise pending transactions after the first export, so the final settlement file should be distinguishable from a preliminary activity view.

Build a data dictionary before importing anything. Clarify whether “sales” includes tax, whether discounts are merchant-funded or platform-funded, how refunds are dated, and whether fees include tax. Identify unique keys for orders, refunds, adjustments, and payouts. A filename called “transactions” is not enough to establish what each column represents.

Construct a settlement bridge

Start with gross supported order value for the settlement population. Show product sales, shipping, merchant-funded discounts, platform-funded promotions, customer tax, refunds, chargebacks, commissions, processing fees, advertising fees, reserve movements, other adjustments, and payout cash as separate lines. Use signs consistently and prove the bridge mathematically.

For example, a settlement contains 18,000 of product and shipping charges, 1,260 of customer tax collected by the marketplace, 600 of refunds, 2,100 of fees, and 300 newly withheld in reserve. If the platform remits the tax itself, the cash payout may be 16,260: 19,260 charged, less 1,260 tax retained, 600 refunds, 2,100 fees, and 300 reserve. Recording 16,260 as sales would omit gross activity and the fee and reserve components. The example explains the bridge; it does not prescribe tax accounts for every marketplace.

Tie the order population to the settlement’s stated count and amount. Then tie the settlement to the exact bank deposit using payout ID, date, currency, and amount. If one payout covers several storefronts or settlements, preserve a composition schedule. If one settlement is paid in several transfers, mark each part without closing the item early.

Maintain a separate reserve roll-forward when the platform withholds or releases cash. Begin with the prior reserve balance, add new holds, subtract supported releases and chargeback uses, and reconcile the result to the platform report. Age each hold by originating settlement and expected release date. A reserve release is not new sales, and a reserve balance should not disappear merely because the related customer order is old. Escalate amounts held beyond contractual terms with the settlement IDs and correspondence attached.

Keep facilitator tax visible

Marketplace-facilitator rules can require a platform to collect and remit certain sales tax, but seller responsibilities depend on jurisdiction and facts. The operational file should distinguish facilitator-collected tax, tax collected directly by the seller, exempt sales, and sales outside the platform. Never infer the filing return from the bank payout alone.

Retain jurisdiction-level reports where available. Compare them with the orders and with any sales-tax liability recorded in QuickBooks. If the accounting integration posts marketplace-collected tax to a liability account, confirm the approved clearing process; do not leave the amount accumulating indefinitely or erase it without support. If the integration excludes it entirely, preserve the gross transaction report so tax reporting can still be reconciled.

The IRS offers general recordkeeping guidance for businesses, while state revenue authorities publish the controlling marketplace rules for their jurisdictions. Use current first-party state guidance and professional advice for filing decisions rather than a platform marketing summary.

Investigate timing and exceptions

Orders, refunds, and payouts can cross month-end. Define whether reconciliation follows order date, fulfillment date, settlement date, or another accountant-approved basis. Maintain a roll-forward for unsettled activity: beginning open amount, new eligible activity, settlements paid, adjustments, and ending open amount. That prevents a clean bank match from concealing cutoff differences.

Review negative settlements, reserve releases, chargebacks, returned merchandise, currency conversion, withheld balances, platform-funded discounts, and deposits that differ from the final statement. For each exception, record the platform case number, evidence requested, owner, due date, and accounting impact. Do not plug the settlement bridge to fees merely because fees are common.

Duplicate-income risk deserves its own test. Search whether an integration already created sales entries before adding a downloaded bank transaction. The correct action may be matching the payout to a clearing entry rather than categorizing it as new revenue. Also search refund IDs and chargebacks so the same reversal is not recorded from both the marketplace and bank feed.

Close with a reproducible packet

The monthly packet should contain the channel map, final activity export, settlement statements, bridge, bank matches, reserve roll-forward, fee detail, facilitator-tax report, unresolved exceptions, and reviewer signoff. Hash or otherwise lock key exports when the company’s retention process supports it. A later reviewer should be able to select an order and trace it through the settlement to cash, or select a bank deposit and trace back to its population.

A virtual assistant can download approved reports, normalize identifiers, prepare bridges, match deposits, and maintain exceptions. The assistant should escalate tax nexus, filing treatment, revenue recognition, foreign exchange, reserves, and disputed chargebacks. QBOAssistant can support the operational reconciliation through accounts payable and receivable services or a scoped consultation.

Sources

• IRS: Recordkeeping
• Streamlined Sales Tax: Marketplace facilitator resources