Recording and Combining Bank Deposits in QuickBooks Desktop
QuickBooks Desktop users who receive multiple payments need to group them into single deposits so their books match actual bank records.
QuickBooks Desktop users frequently encounter a mismatch between their software register and their actual bank statements when multiple payments are deposited together at the bank. When a business receives several checks or cash payments and deposits them in a single trip, the bank records one lump-sum deposit. If those same payments are left as separate entries inside the accounting software, reconciling the account becomes a frustrating exercise in tracking down discrepancies. The solution is to group those payments together using the built-in deposit features.
Combining Payments Into a Single Deposit
To resolve the mismatch, users need to combine received payments into a single record that mirrors the physical deposit slip. From the main Homepage, selecting the option to record deposits opens the payments queue. A window appears displaying all received payments currently sitting in the undeposited funds holding account. Users select the specific payments included in the physical bank run and confirm the selection.
Once the payments move into the main deposit window, the user selects the appropriate bank destination from the dropdown menu at the top of the form. The generated deposit total should be checked against the physical deposit slip to ensure the selected payments and the bank records match exactly. After entering the correct date and adding any necessary memo details, saving the transaction finalizes the record. This single entry now matches the single deposit shown on the bank statement.
Splitting a Deposit Across Multiple Accounts
A common complication arises when a business wants to route a single deposit into two distinct accounts — for instance, placing some funds into checking and moving others into savings. QuickBooks handles this through a specific negative-entry method.
In the deposit window, users add a new line directly beneath the grouped payments. By selecting the secondary account from the dropdown on this new line and entering the desired amount as a negative value, the total deposit shrinks by that exact figure. The negative entry effectively routes that portion of the cash into the secondary account, leaving the remaining balance to post to the primary checking account.
Alternatively, users can utilize the cash-back feature built into the deposit window. By selecting the secondary account in the designated cash-back dropdown and entering the amount to redirect, the software calculates the remainder automatically. The leftover funds post to the primary account selected at the top of the form.
Reviewing and Deleting Recorded Deposits
Occasionally, deposits are recorded with the wrong combination of payments or routed to the incorrect account. To review the underlying details of a recorded deposit, users can generate the Deposit Detail report by accessing the Report Center, navigating to the Banking section, and running the specific report. This provides a clear breakdown of what is tied to the deposit.
If the deposit needs to be completely removed, users can locate and open the specific transaction from the bank register. Opening the deposit brings up the full window, displaying all the individual payments originally grouped within it. Right-clicking inside the window presents the option to delete the deposit entirely. Confirming the deletion removes the grouped record, though the individual payments remain in the system and return to the undeposited funds queue, ready to be grouped into a new deposit.
Setting Up Recurring Deposits
For businesses receiving regular payments of the same amount, manually recording the same deposit repeatedly is an unnecessary administrative burden. QuickBooks allows users to memorize a deposit transaction for recurring use. By opening an existing deposit from the bank register, right-clicking, and selecting the option to memorize the transaction, users can set up an automated schedule.
During setup, users choose whether the software should record the deposit automatically on a set schedule or simply add a reminder to a task list. The configuration requires selecting the frequency, setting the start date, and defining exactly how many times the software should create the recurring entry. Setting the advance-entry preference dictates whether the transaction posts days ahead of the scheduled date or strictly on the day it is due. You can find more guidance on managing QuickBooks Desktop banking and deposits through our knowledge base.
Properly grouping payments ensures the bank reconciliation process runs smoothly, preventing the time-consuming task of hunting down missing or duplicated figures at the end of the month.