A sales deposit that matches your bank balance can still be wrong in your books. This happens when the deposit represents several customer payments, a payment processor payout, or a daily point-of-sale batch that includes fees, refunds, and sales tax. Knowing how to reconcile sales deposits means tracing the money from the original sale through to the amount that reached the bank - not simply accepting the bank feed match.
For Alberta business owners using QuickBooks Online, getting this process right protects the usefulness of every report that follows. Your profit and loss statement, cash forecast, GST filing, and customer balances all depend on sales being recorded once, in the right period, and against the right account.
What reconciling sales deposits actually means
Reconciling a sales deposit is the process of proving that the deposit on your bank statement agrees with the payments recorded in your accounting system. The deposit may equal one invoice payment, but often it is a combined amount made up of multiple transactions.
For example, a contractor may receive three e-transfers that are deposited separately. A retail business may receive one daily deposit from its point-of-sale system. A service business that accepts card payments may receive a weekly processor payout that is lower than its customer payments because card fees were deducted before the money was sent.
The key question is not, “Did money arrive in the bank?” It is, “What sales, fees, refunds, taxes, and timing differences make up this amount?”
A proper reconciliation connects those details without duplicating income. If you record a $2,000 sales invoice, then categorize the $2,000 bank deposit as new sales income, your revenue is overstated by $2,000. The bank balance may look correct, but your financial statements are not.
Start with the source of the deposit
Before matching anything in QuickBooks Online, identify how the customer paid and how the funds reach your bank. Your workflow should reflect the way your business collects money.
For direct payments such as e-transfers, cheques, or cash deposits, the bank deposit may relate directly to a specific invoice or sales receipt. Review the amount, payer name, and date. If one payment settles an invoice, the match should be straightforward.
For card processors and online payment platforms, use the processor’s settlement report. That report should show gross customer payments, refunds, processing fees, chargebacks if any, and the net amount deposited to your bank. The net deposit alone does not tell the full accounting story.
For point-of-sale businesses, use the daily closing or batch report. Separate cash, debit, credit card, gift card, and online sales. Cash may be deposited later than the day of sale, while card payments may take one or more business days to settle. Those timing differences are normal, but they need to be documented and tracked.
Use Undeposited Funds for grouped payments
QuickBooks Online includes an account called Undeposited Funds. This is useful when you receive several payments but take them to the bank together, or when several customer payments appear as one bank deposit.
Record each customer payment against the related invoice. Rather than sending each payment directly to your operating account, select Undeposited Funds as the deposit account. When the combined deposit appears in your bank feed, create a bank deposit in QuickBooks Online and select the payments included in that deposit.
The total should match the amount shown by the bank. Once it does, match the bank-feed transaction to the bank deposit you created.
This approach keeps accounts receivable accurate because each invoice is marked paid. It also ensures the bank account reflects the actual deposit amount rather than a series of payments that never appeared individually on the bank statement.
When not to use Undeposited Funds
If customer payments always flow through a processor before reaching your bank, a clearing account is often a better option. Sending processor-related payments to Undeposited Funds can work for a simple workflow, but it can become difficult to follow when payouts, fees, refunds, and settlement delays are frequent.
The best method depends on transaction volume and payment complexity. A self-employed consultant receiving a few direct e-transfers each month may need only a clean Undeposited Funds workflow. A business processing hundreds of card transactions needs a more structured payment-clearing process.
Reconcile processor payouts with a clearing account
A clearing account is a temporary account that records money owed to you by a payment processor. It is especially useful for Square, Stripe, PayPal, Shopify Payments, and similar platforms.
Record the gross customer payment first. If you create invoices, apply the payment to the invoice and deposit it to the processor clearing account. If you use sales receipts, direct the receipt to that same account. This records the full sale, including any applicable GST, and clears the customer balance.
Next, record the processor fee as an expense against the clearing account. Refunds and chargebacks should also be posted against the clearing account using the appropriate income, refund, or expense accounts. When the processor transfers the net amount to your bank, transfer or match that net payout from the clearing account to the bank account.
Consider a simple example:
- Gross customer payments: $5,000
- Customer refunds: $200
- Processing fees: $145
- Net bank deposit: $4,655
Your bank will only show $4,655. Your books, however, should show $5,000 in sales, the $200 refund in the correct category, and $145 in processing fees. The clearing account should return to zero once the payout is fully recorded, except for normal transactions that are still waiting to settle.
This distinction matters for profitability. Recording only the net deposit understates revenue and hides payment-processing costs. It can also create problems when comparing sales reports to GST records.
Match deposits by date, amount, and composition
A match is reliable only when all three elements make sense: the amount, the timing, and the transactions included.
Bank dates and sales dates will not always be identical. A weekend card sale may be paid out on Tuesday. An e-transfer may be received on the last day of the month but not deposited until the next business day. Do not force a match just because the numbers are close.
Instead, work from supporting records. Compare the bank deposit to the invoice payment list, point-of-sale closing report, processor settlement report, or deposit slip. If the deposit differs, identify the reason before accepting it. Common reasons include processor fees, sales-tax treatment, refunds, deposits combined across days, or a payment that is still in transit.
Create a consistent review routine. Businesses with modest activity may reconcile sales deposits weekly and complete their bank reconciliation monthly. Businesses with higher sales volume or limited cash flexibility may need to review deposits every business day. The right frequency is the one that lets you spot missing sales, delayed payouts, and cash issues while they can still be investigated.
Avoid the errors that distort your reports
The most common error is recording income twice: once when an invoice or sales receipt is created and again when the bank deposit is categorized. In QuickBooks Online, bank-feed transactions should usually be matched to existing records, not added as new income.
Another frequent problem is posting the full processor payout as sales. This hides gross revenue, processing fees, refunds, and GST details. It may make bank reconciliation faster in the moment, but it weakens the records you need to manage margins and prepare filings.
Do not ignore deposits that remain unmatched for long periods. An old unmatched deposit may indicate a duplicate entry, a payment posted to the wrong account, an invoice that was never marked paid, or an incomplete processor clearing workflow. The longer it sits, the harder it is to trace.
Also watch for personal or non-sales transfers entering the operating account. Owner contributions, loan proceeds, inter-account transfers, and tax refunds are not sales deposits. Clear account naming and consistent transaction review prevent those items from inflating revenue.
Make sales-deposit reconciliation part of month-end
At month-end, reconcile your bank account to the statement and review the outstanding balance in Undeposited Funds and any processor clearing accounts. Those balances should be explainable. They may represent payments awaiting deposit or processor payouts still in transit, but they should not become permanent holding places for unresolved transactions.
Then compare sales reports to the profit and loss statement. If you use a point-of-sale system or online store, compare its reported gross sales to the revenue recorded in QuickBooks Online. Review refunds, discounts, processing fees, and GST separately. This gives you a better view of both cash received and actual operating performance.
Accurate Bookkeeping Alberta scopes this work around practical factors such as transaction count, number of accounts, sales channels, and reporting needs. That is because sales-deposit reconciliation is not one-size-fits-all. A clear process should fit the way your customers pay you, while producing records you can rely on for cash decisions, GST filings, and year-end reporting.
When a deposit does not match, treat it as a question to answer rather than a transaction to force through. A few minutes spent tracing the source can protect the accuracy of your revenue, your cash forecast, and the decisions you make from both.