Recording deposits and reconciling them against your bank feed is two-thirds of closing out an accounting period. The other third — applying customer payments against invoices — is the easy half. The deposit reconciliation half is the one that eats hours of bookkeeper time every month. This article explains what's actually happening when you record a deposit, why it matters even if you're not using Biller Genie, and how Biller Genie's Automatic Batch Reconciliation (ABR) collapses the most tedious part of the work into nothing.
Part 1 — How recording deposits works (the accounting fundamentals)
In accrual accounting, every customer payment touches your books in two distinct steps, and each step has its own reconciliation requirement:
- Payment recorded against the invoice or sales receipt. When a customer pays, you mark their invoice paid (or create a sales receipt for immediate payment). This is the payment → invoice reconciliation. It tells your books "this customer owes less because they just paid."
- Deposit recorded against the bank feed. When the bank actually receives the money (which usually happens later — overnight for ACH, 1-2 days for credit cards), the deposit lands on your bank statement and needs to be matched to one or more recorded payments. This is the deposit → bank reconciliation. It tells your books "the cash physically moved from the customer's bank to ours."
Both reconciliations have to happen to close out a period accurately. Skip the first and you have customers showing balances they don't actually owe. Skip the second and your books say the bank should have more (or less) cash than it actually does.
The Undeposited Funds account — the holding register between the two steps
Between recording the payment and recording the deposit, the money sits in a special account called Undeposited Funds (sometimes called a "clearing account," "holding account," or "till"). It's a temporary parking spot for collected payments that haven't yet cleared the bank.
A typical day for a business that takes a mix of payment types looks like this in your accounting software:
- Customer A pays a $500 credit-card invoice. Payment is recorded; $500 moves into Undeposited Funds.
- Customer B pays a $1,200 ACH invoice. Payment is recorded; $1,200 moves into Undeposited Funds.
- Customer C writes a $300 check. Payment is recorded; $300 moves into Undeposited Funds.
- Your day-end Undeposited Funds balance: $2,000 across three different transaction types.
At some point, the bank feed shows actual deposits arriving. But the deposits don't come in as one $2,000 lump. They come in as separate batches by payment type, on different days, with processor fees deducted. That's where the reconciliation work begins.
Intuit's overview: What is the Undeposited Funds account in QuickBooks? For Xero merchants, see Xero Central: About bank reconciliation.
How bank feeds work
Bank feeds are the live (or near-live) connection between your bank and your accounting software. Your bank pushes (or your accounting software pulls) every transaction from your bank account — deposits, withdrawals, fees — and lists them in a "to review" inbox inside your books.
When a deposit shows up in the bank feed, you have to match it to a recorded payment or batch in Undeposited Funds so the system knows the cash on the bank statement and the cash in your books refer to the same transaction. QuickBooks and Xero both have AI/rules that auto-suggest matches, but the suggestions are only as good as the data underneath them. For more on the bank-feed workflow, see Intuit's Manage bank feeds and Set up bank rules guides; Xero's flow is described in About bank reconciliation.
Why this matters even if you have a small business
- Tax accuracy. If your books don't agree with your bank, tax filings drift from reality. The IRS doesn't care about your Undeposited Funds; it cares about what the bank says.
- Cash position visibility. Unreconciled deposits hide your real cash. You think you have $50K; the bank says $42K; the $8K is stuck in unmatched batches.
- Fraud and error detection. Reconciliation is the discipline that catches a missed payment, a duplicate deposit, a chargeback that wasn't recorded. Skip it and a $400 error compounds over months.
- Audit readiness. Lenders, investors, and auditors all want clean monthly reconciliations. "We're behind" is not an answer that lands well.
Part 2 — How deposit reconciliation works WITHOUT ABR
Without an automated reconciliation tool, your bookkeeper (or you) does the matching by hand. The workflow is the same whether you're on QuickBooks Desktop, QuickBooks Online, Xero, or anything else — only the screens differ.
The manual deposit workflow in QuickBooks Desktop
- Open Banking > Record Deposits (or Make Deposits, depending on your QBD version).
- QBD shows the Payments to Deposit screen — a list of every payment currently sitting in Undeposited Funds, mixed across credit cards, ACH, checks, and any other payment types you've recorded.
- You manually identify which subset of those payments belongs to the deposit you're recording. This is the hard part. Your bank feed shows "ACH deposit $1,847.23" — you have to scan the list, find the ACH payments from that day, add them up, factor in the processor fee, and pick the right ones until they sum to $1,847.23.
- Check the payments you're including. Click OK.
- On the Make Deposits screen, pick your bank account and the deposit date.
- Save the deposit. The matched payments leave Undeposited Funds; the deposit appears in the bank register.
- Repeat for every batch of every payment type, every day.
The manual deposit workflow in QuickBooks Online
- Go to + New > Bank deposit.
- Pick the destination bank account and date.
- Under Select the payments included in this deposit, check off the payments from Undeposited Funds that match the actual bank deposit.
- Save.
The manual workflow in Xero
Xero's model is a little different — there's no dedicated Undeposited Funds account by default. Payments are matched directly against bank statement lines in the bank-feed reconciliation screen, one transaction at a time. For batched deposits (multiple payments combining into a single bank deposit), Xero offers Find & Match on a statement line to select multiple recorded payments that sum to the bank amount. The reconciliation work is still manual — selecting the right combination from a list — just split across a different UI.
Why this is painful
- Volume. A merchant with 50 transactions per day generates a couple hundred Undeposited Funds entries per week. Manually picking the right subset for each daily deposit is tedious sorting work.
- Processor fees. Credit card processors often deduct fees before depositing the net amount. So a $1,000 gross batch shows as $971.50 on the bank feed. You have to know the fee, recreate the math, and record the fee deduction separately. Get the fee wrong and the reconciliation fails.
- Mixed payment types on the same day. Credit cards, ACH, and checks settle on different schedules. A single business day's payments might hit the bank across three to five separate deposits over multiple days, each needing its own match.
- Errors compound. Misclassify one payment and the next day's reconciliation is off too. Bookkeepers eventually spend more time finding mistakes than recording new transactions.
- It's expensive. Most small businesses pay a bookkeeper $30-50/hour for this work. A few hours a week adds up to thousands of dollars a year just to keep the books aligned with reality.
Part 3 — How deposit reconciliation works WITH Biller Genie's Automatic Batch Reconciliation (ABR)
Automatic Batch Reconciliation is Biller Genie's add-on that does the deposit-matching work automatically. The core insight is that Biller Genie knows exactly which transactions are in each batch and what the expected deposit amount will be — because Biller Genie is the system that processed them in the first place. We can hand your accounting software a pre-matched journal entry that exactly mirrors the bank deposit, so when the deposit hits the bank feed, your accounting software's AI matches the two automatically.
How ABR sets up your chart of accounts
When you install ABR, Biller Genie creates segregated sweep and deposit accounts in your accounting software for each payment type — so credit card, ACH, check, and alternative-payment-method (APM, like PayPal) batches never mix in the same holding account. By default you'll see eight accounts created in your chart of accounts:
- Credit Card Sweep + Credit Card Deposit
- ACH Sweep + ACH Deposit
- Check Sweep + Check Deposit
- APM Sweep + APM Deposit
The Sweep accounts are where Biller Genie posts each individual payment as it processes. The Deposit accounts are where the matching journal entry lands — these are what reconcile against the bank feed. Sweep accounts are bank-type accounts so QuickBooks treats them as part of your liquidity. You can rename them or remap them in the Chart of Accounts mapping tool if your bookkeeper prefers different names.
The daily ABR workflow
- Throughout the day, as customers pay. Biller Genie processes each payment and posts it to the appropriate sweep account in your accounting software — credit card payments go to Credit Card Sweep, ACH payments to ACH Sweep, and so on. Each payment is still linked to its invoice or sales receipt as normal.
- At the end of each business day. Biller Genie tallies the day's batches by payment type and creates a single journal entry per payment type for the net deposit amount expected to hit your bank: debit the Deposit account, credit the Sweep account, in the exact amount your processor will deposit.
- When the actual bank deposit shows up in your bank feed. QuickBooks' built-in AI sees the deposit, scans for matching transactions, finds Biller Genie's journal entry (same amount, same date, same description), and auto-suggests the match. You click "Match" — or it auto-matches via bank rules — and the reconciliation is done.
- At the end of the period. Your Sweep accounts should be at $0 (or very close). Anything left in a Sweep account is an exception that needs investigation: a chargeback, a refund Biller Genie couldn't sync, a duplicate payment. A non-zero Sweep balance is a focused investigation list, not an open-ended hunt through Undeposited Funds.
What you no longer have to do
- Sort through Undeposited Funds picking the right subset of payments for each deposit.
- Reconstruct processor-fee math.
- Track which payment types settle on which days.
- Manually create deposit entries.
- Hunt across mixed-type lists trying to figure out what makes up each bank line.
The exception-spotting superpower
Because ABR's day-end journal entries always match the expected deposit exactly, anything left in a sweep account at the end of a period is by definition an exception. A merchant who runs ABR can answer "what's unreconciled?" in five seconds — they just look at the sweep account balances. A merchant without ABR has to scroll through hundreds of Undeposited Funds entries to find the same answer.
Daily discounting — one extra journal entry
If your payment processor takes its fees as a "daily discount" (deducting fees from each day's gross deposit rather than billing monthly), the bank deposit comes in net of fees, but ABR's journal entry was for the gross batch — so they don't match. The fix is a small daily journal entry for the fee amount. See Automatic Batch Reconciliation with Daily Discounting for the entries. If your processor offers monthly discounting instead (recommended for ABR users), this extra step disappears entirely.
What ABR doesn't do
- ABR is available on QuickBooks Online and QuickBooks Desktop via MagicCarpet. It is not available on the legacy QBDv3 integration or on Xero — see Using Xero in Biller Genie for the Xero feature parity details.
- ABR doesn't reconcile payments to invoices. That happens at payment time, the moment a customer pays. ABR specifically addresses the deposit → bank-feed reconciliation, which is the second of the two reconciliation steps from Part 1 above.
- ABR doesn't replace your bookkeeper. It replaces the tedious portion of their work. They still review exceptions, classify uncommon transactions, and own the close. They just stop spending hours on rote matching.
Choosing the right path for your business
If you're processing more than a handful of transactions per day, ABR pays for itself in time saved on reconciliation. If you're a low-volume business with five transactions a month, the manual workflow described in Part 2 is fine and probably doesn't need automation. The break-even point is usually somewhere around 30-50 transactions per month — at that volume, the manual sorting time starts to hurt.
Frequently asked questions
Do I have to use ABR, or can I still record deposits manually in Biller Genie?
You can keep recording deposits manually if you prefer. With ABR off, Biller Genie still syncs each payment to your accounting software's Undeposited Funds account; you'd then use the manual workflow in Part 2 to record the deposits. ABR is an add-on you install when you want the segregated-sweep-account + journal-entry pattern.
What happens to my existing Undeposited Funds entries when I turn on ABR?
Existing entries stay where they are. ABR only affects payments processed after the feature is enabled and a full sync is completed. Reconcile any backlog using the manual workflow, then let ABR take over going forward.
My sweep account balance is not zero at the end of the day. What does that mean?
It means something happened that wasn't a normal batch deposit. The most common causes are chargebacks (a customer disputed a charge — your processor pulled the money back), refunds that weren't synced cleanly, or a payment that processed but didn't settle. Investigate the non-zero amount — that's a real exception, not a phantom.
Does ABR work with bank rules in QuickBooks?
Yes. ABR's journal entries have consistent descriptions and amounts that pair well with QuickBooks' bank rules. Many merchants set up an auto-confirm rule that matches ABR journal entries on sight, reducing the manual click-to-match to zero.
Can I customize which accounts ABR uses?
Yes. In the Chart of Accounts mapping tool, you can override the seeded Sweep and Deposit accounts with accounts of your own choosing. Many bookkeepers prefer to fold the sweep accounts into their existing chart of accounts numbering scheme.
Is ABR available for Xero merchants?
Not currently. ABR is built around QuickBooks-specific bank-feed and journal-entry matching behavior. Xero merchants reconcile manually through Xero's Find & Match bank-reconciliation screen. See Using Xero in Biller Genie for the full Xero feature parity picture.