How to Reconcile Faire Payouts in QuickBooks Online
Faire payouts often look like ordinary bank deposits, but each amount may combine product sales, shipping charges, marketplace fees, refunds, and other adjustments. If you've searched for "reconcile Faire payouts QuickBooks," you're probably trying to connect one net deposit to the activity behind it.
The clean approach is to record the gross activity first, use a Faire clearing account, and then match the net payout to your bank. That keeps sales income, expenses, refunds, and cash deposits in the right places.
Start with Faire payout details, not the bank feed
Before opening QuickBooks Online, download the Faire payout report for the period you're reviewing. Use the payout date, payout reference, and transaction details shown in the report. A bank feed usually shows only the final amount, so it can't explain the deposit by itself.
Review each payout for these categories:
| Faire activity | Typical QuickBooks treatment | What to verify |
|---|---|---|
| Product sales | Sales income | Record the gross amount before deductions |
| Shipping-related amounts | Shipping income, shipping expense, or another approved account | Follow the report and your accounting policy |
| Faire fees | Marketplace or selling expense | Record fees separately from sales |
| Refunds and returns | Refunds and allowances or a reduction of income | Confirm when the refund affected the payout |
| Net payout | Transfer from Faire clearing to the bank | Match the exact amount deposited |
Shipping needs special attention. A retailer's shipping payment might be income to your business, while postage or fulfillment costs belong in an expense account. In other cases, the report may show shipping as an adjustment rather than a separate amount. Don't automatically post every shipping line to sales income.
Faire reports can also contain activity from orders placed earlier. Therefore, compare the payout report to the payout date and included transaction dates, not only the date of the original order.
"Reconcile Faire payouts QuickBooks": build a clean workflow
A clearing account gives Faire activity a temporary home before the money reaches your bank. In QuickBooks Online, many businesses create an account called "Faire Clearing" under Other Current Assets. Some businesses use a different account type based on their existing chart of accounts, tax method, or integration.
Your accountant or bookkeeper should confirm the setup before you begin posting historical payouts. One chart of accounts doesn't fit every wholesale business.
At a minimum, review whether you need separate accounts for:
- Faire product sales income
- Shipping income or shipping reimbursements
- Faire fees and commissions
- Refunds, returns, and allowances
- Bank fees or currency conversion charges
- Faire clearing
- Sales tax payable, when your business collects sales tax
Keep the gross sales visible. If a retailer's order totals $2,000 and Faire deducts $160 in fees, recording only the $1,840 deposit hides both revenue and the selling expense. That can distort sales reports and make tax preparation harder.
A properly structured workflow follows this path:
Gross activity in Faire -> Faire clearing account -> net deposit in the bank
The clearing account should not become a permanent dumping ground. After you post a payout and match its bank deposit, the related balance should clear. A remaining balance may be normal when a payout is still in transit, but an unexplained balance needs review.
Record each Faire payout in QuickBooks Online
QuickBooks Online offers several ways to record marketplace activity. Your best method depends on whether you use an integration, how many orders you process, and whether you need order-level detail in QuickBooks.
For a manual batch workflow, use the payout report to create one summarized transaction for each payout. A journal entry often works well for this method, although some businesses use sales receipts or another sales workflow. Keep the report attached to the transaction or saved with your monthly records.
Follow these steps:
- Select one Faire payout and confirm its payout date, reference number, and net amount.
- Record gross product sales as income.
- Record shipping-related amounts in the account your bookkeeping policy uses.
- Record Faire fees as an expense, even when Faire withholds them before payment.
- Record refunds and returns separately when the report identifies them.
- Debit the net amount to Faire clearing.
- When the bank deposit arrives, record a transfer from Faire clearing to the bank account.
Illustrative payout entry
The following is a sample calculation, not a universal posting method:
| Sample Faire activity | Amount |
|---|---|
| Product sales | $2,000 |
| Shipping-related income | $120 |
| Faire fees | ($160) |
| Refunds | ($80) |
| Net bank payout | $1,880 |
The summary entry would credit product sales for $2,000 and shipping income for $120. It would debit Faire fees for $160, refunds and returns for $80, and Faire clearing for $1,880. The debits and credits both total $2,120.
When the $1,880 reaches the bank, record a transfer from Faire clearing to the bank. Don't categorize the bank feed deposit directly to sales income, because that would record only the net amount and could duplicate the income entry.
If sales tax appears on the Faire report, post it to the correct tax liability account rather than including it in sales income. The proper treatment depends on your registration, collection responsibilities, and tax setup.
Match the net deposit during bank reconciliation
When QuickBooks Online downloads the bank transaction, search for the matching transfer or deposit by amount and date. If the payout appears as a transfer from Faire clearing, use Match rather than adding a new income transaction.
Bank dates may differ from Faire payout dates. Weekends, holidays, bank processing, and payout schedules can shift the arrival date. Use the bank statement to confirm the actual deposit date, then keep the Faire payout report as support for the amount.
A reliable "reconcile Faire payouts QuickBooks" process also checks the bank statement ending balance. Use the statement date and ending balance in the reconciliation screen, then investigate differences instead of forcing the reconciliation to finish.
This QuickBooks Online bank reconciliation checklist can help you document statement dates, cleared transactions, and unusual items.
Never treat a net Faire deposit as gross sales unless your accounting records contain no separate sales and fee entries. The bank amount is cash received, not the full sale.
If one bank deposit combines several Faire payouts, you can either record one combined clearing transfer or match each payout to the deposit, depending on the detail available in your records. Choose one method and apply it consistently.
Troubleshoot unmatched deposits and differences
An unmatched deposit doesn't always mean the original entry is wrong. Start by comparing the Faire payout reference, payout date, net amount, and bank transaction. Then review the following common causes.
The bank deposit is larger than one payout
Faire may have included multiple payouts in one bank transaction, or the bank feed may have imported an older payout during the same period. Search for nearby payout dates and compare the combined net amounts.
If several payout reports make up one deposit, don't edit the sales totals to force a match. Combine the clearing transfers only when your saved reports show exactly what the bank received.
The bank deposit is smaller than the Faire report
Look for a bank fee, foreign exchange charge, reserve, refund, chargeback, or other adjustment. A $15 difference, for example, should remain unexplained until the source report or bank statement identifies it.
If the bank confirms a $15 fee and your records support that treatment, debit bank fees for $15 and credit Faire clearing for $15. If you can't identify the difference, leave it in a review account or clearing balance temporarily. Ask your bookkeeper before posting an unsupported expense.
The bank feed shows no matching deposit
Check whether the payout is still pending, went to a different bank account, or posted under a different date. Also confirm that the bank feed has imported the correct account and that the transaction wasn't excluded.
A missing deposit shouldn't be entered again simply because it isn't visible in the feed. First confirm that Faire released the payout and that the bank received it.
QuickBooks shows duplicate income
Duplicates often occur when an integration posts order-level sales and you also enter a manual payout summary. Compare the sales detail, clearing balance, and payout report before deleting anything.
If a bank transaction is a duplicate download and the correct transaction already exists, exclude the duplicate. Avoid deleting reconciled entries without reviewing the audit trail and asking your accountant.
Keep Faire records ready for month-end and taxes
Reconcile Faire payouts at least monthly. Higher-volume brands may need a weekly review so errors don't accumulate across multiple payout cycles.
Save each payout report with its reference number and period. Attach supporting reports to QuickBooks transactions when practical. Keep notes for refunds, unusual deductions, currency conversions, and deposits that combine several payouts.
During month-end close, review:
- The Faire clearing balance and any old unreconciled amounts
- Gross Faire sales on the profit and loss statement
- Faire fees and other marketplace expenses
- Refunds and returns
- Shipping income and shipping-related costs
- The bank account reconciliation
- Sales tax balances, when applicable
This monthly bookkeeping close process provides a useful structure for reviewing bank, card, payroll, and other account activity.
Tax reporting may require gross revenue and separate deductions for eligible fees, but the correct treatment depends on your business structure and tax situation. Your tax preparer should review the chart of accounts and reports before you rely on them for a return.
Conclusion
The most reliable way to reconcile Faire payouts in QuickBooks Online is to separate the activity before it reaches the bank. Record gross sales, shipping-related amounts, fees, and refunds according to your policy, then move the net amount through a Faire clearing account.
When the bank feed imports the deposit, match it to the clearing transfer instead of categorizing it as new income. With payout reports attached and differences investigated promptly, your QuickBooks records can show both the cash you received and the business activity that produced it.
