QuickBooks Bookkeeping VAs

Reconciling a QuickBooks Online Merchant Payout That Arrives in Two Deposits Against a Single Sales Day

A practical reconciliation for a bookkeeping VA when a card processor splits one sales day into two bank deposits, covering gross sales, fee allocation, clearing-account matching, and close-file evidence.

Reconciling a QuickBooks Online Merchant Payout That Arrives in Two Deposits Against a Single Sales Day blog thumbnail
QuickBooks Onlinemerchant payoutsbank reconciliationbookkeeping VA
On this page Jump to section

A merchant processor does not always deposit a sales day in one clean transfer. A Friday batch can arrive as the card portion on Friday and the fee-adjusted remainder on Monday, or a single day can split because the processor settles debit and credit transactions on different schedules. A bookkeeping VA who matches only the total eventually records revenue twice or leaves the clearing account with a balance nobody can explain. The fix is to reconcile the sales day and the deposits as two linked records, not as one combined number.

Why a split payout breaks the single-day match

The bank feed shows deposits, while QuickBooks Online shows the sales forms that created the receivable. When one sales day produces two deposits, the automatic match may attach the first deposit to an invoice and leave the second sitting in the clearing account. The second deposit then looks like unapplied cash even though it belongs to a sale that is already recorded. A reviewer who trusts the suggested match will usually accept the first link and never inspect the leftover balance.

The opposite mistake is just as common. A VA sees two deposits and creates two sales receipts because two bank lines appear to need two income entries. That treatment inflates gross sales and understates the processor fee, and it can also distort sales tax if the receipts carry tax codes. The correct question is not how many deposits arrived, but how many sales batches the deposits are settling.

Establish the gross sales batch before touching the deposits

Start with the processor settlement report for the sales date, not with the bank feed. Record the gross card sales, refunds, chargebacks, and total fees for that batch, then compare the net settlement figure with the sum of the deposits you expect. This step produces the number the deposits should add up to before any QuickBooks entry is touched. Save the settlement report as a PDF and note its report date in the working paper.

Next, export the day's sales summary from QuickBooks Online and reconcile it to the settlement report. Differences usually come from tips, gift card redemptions, or transactions that were authorized on one day and captured on another. Investigate each difference instead of forcing the batch to balance. If the two reports cannot be tied, the reconciliation is not ready and the deposits should wait.

Allocate the processor fee across the entire batch

Processors often deduct the fee from only one of the two deposits, which makes that deposit look short against the sale. The fee is still a cost of the whole batch, so record it once as a merchant or processing expense and keep the gross revenue intact. Do not reduce the sales receipt by the fee, because that hides the expense and understates the revenue line that the client may need for reporting. Keep the fee amount and the processor reference number in the memo field.

If the processor charges a separate monthly fee, a chargeback fee, or a terminal rental, those belong in their own expense lines rather than in the batch reconciliation. Mixing them into the deposit match makes the next month harder to explain. A simple rule is that only fees shown on the settlement report for that batch belong in this reconciliation. Everything else follows its own statement and its own review.

Match both deposits through the clearing account

Use a clearing account as the temporary home for the batch's gross amount. Record the gross sale or transfer into the clearing account, record the fee as an expense from the same account, and match each net deposit against the remaining balance. The first deposit clears part of the balance and the second clears the rest, so neither one is treated as new revenue. This approach also gives the reviewer a single account to inspect when the batch does not close.

If the automatic match attaches a deposit directly to an invoice, break the link and rematch it to the clearing transfer. Intuit's guide to reviewing and adding payouts describes how payout records connect to the books, and the account flow matters more than the label on the bank line. Keep the sales receipt as the revenue record and use the clearing account only for the movement of cash. Note the original bank line and the replacement match in the working paper so the change is visible to a reviewer.

Document the split in the close file

Write a short note that names the sales date, gross amount, fee, each deposit date, and each deposit amount. Include the processor settlement reference and the QuickBooks transaction numbers for the transfer, fee, and both matches. The note should let a second reviewer rebuild the reconciliation without reopening the bank feed. Attach the settlement report and the sales summary beside the note.

If one deposit is still missing at the close cutoff, leave the clearing balance open and list it as an exception. State the expected amount, the date it was expected, and the processor contact or portal used to check. Do not create a plug entry to make the account zero, because a plug hides the missing cash and changes the month's reported position. The exception should carry into the next reconciliation with the same reference.

Set a rule for future split payouts

Define what counts as a split for this client, such as two deposits within three business days that together equal one settlement report. Give the VA a first-pass rule: if the sum of the deposits equals the net batch, match them together through the clearing account. If the sum does not equal the batch, stop and compare the settlement report before posting anything. Put the rule in the client's close checklist so a new team member follows the same path.

Pair the rule with the merchant payout reconciliation workflow and the merchant fee reconciliation notes so fees and deposits share one standard. Review the clearing account at every close and escalate any batch older than the client's cutoff. A split payout is ordinary processor behavior, and a written rule keeps it from becoming an unexplained balance. Update the rule whenever the client changes processor or adds a new sales channel.

Related resources

Compare the service fit on the QuickBooks VA services page, then use the free consultation form to map the first handoff. For platform context, review QuickBooks Online.

FAQ

Should a bookkeeping VA record each merchant deposit as its own sale?

No. The sales forms for the day already record the revenue, so a second entry per deposit double counts income. Both deposits should be matched to the same sales batch through the clearing account, with the processor fee recorded once against that batch.

Where should the processor fee appear when only one deposit is reduced?

The fee belongs to the sales batch, not to whichever deposit happened to absorb it. Record the full gross amount in the clearing account, post the fee as a merchant expense, and let both net deposits clear the remaining balance.

How long should an unmatched second deposit stay open?

Treat it as an open item until the next statement cycle or the client's close cutoff, whichever comes first. If the processor statement does not show a matching settlement by that date, escalate the item with the batch date, amount, and the last four digits of the account.

Keep reading

Related QuickBooks VA guides

Browse blog