Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
B
Bethany RC
July 6, 2022
Question

Batch Deposits

  • July 6, 2022
  • 1 reply
  • 0 views

Hello!  When I record my deposits, they go into my register as a lump sum.  However, when I go to reconcile, some of that lump sum is on 2 different bank statements.  How do I separate the lump sum so I can reconcile correctly?  I have been re-adding the deposits alone to make the reconciliation work, but now my register balance is higher than it should be.  I am afraid to delete the recorded lump sum deposit.  Any suggestions?

    1 reply

    C
    CharleneMaeFQuickBooks Team
    QuickBooks Team
    July 6, 2022

    There's nothing to be afraid of, Bethany RC. I've got you covered.

     

    When reconciling, you'll have to make sure your QuickBooks accounts match your real-life bank and credit card statements. 

     

    Since some lump sum deposits are separated in your bank statements, I'd recommend deleting them. Then, enter the transactions individually to ensure the reporting is correct.

     

    Here's how to delete the deposits:

     

    1. Go to the List menu.
    2. Click Chart of Accounts.
    3. Double-click the bank account.
    4. Search for the deposit on the register.
    5. Right-click the deposit.
    6. Select Delete Deposit.
    7. Click OK.

     

    Also, please delete all the deposits you've re-added to avoid duplicates. Once done, you can now enter them one at a time. I'll show you how:

     

    1. Go to Banking and then select Make Deposits.
    2. Close the Payments to Deposit window.
    3. Add the correct details of the transaction.
    4. Click Save & New.
    5. Add the deposit.

     

    If you're unsure, you can reach out to an accountant to guide you with the correct tracking. If you don't have one, you can use our Find-an-Accountant tool to look for an expert near you.

     

    Once the deposits are accurately added, you can start reconciling the account. This keeps your books balanced.

     

    After reconciling, you can click Display to view the Reconciliation report or select Print to have a handy copy of the data. 

     

    You can rely on me if you have additional questions about the process. It's my responsibility to ensure your accounts are reconciled. Keep safe always!

    Y
    YusK
    February 7, 2025

    Hi,

    I dida batch deposit from a payer for many customers, the deposits were successful for each customer, but the amount appeared in the individual invoices as amount due instead

    of payment to off set the amount due. How to off set this amount due since the amount has

    been resolved as batch deposits?

    D
    Dandie_AQuickBooks Team
    QuickBooks Team
    February 7, 2025

    To effectively assign these batch deposit amounts to the matching invoices and settle the outstanding balances, please navigate to the Receive Payments section. YusK. Let's work together to ensure these payments are applied properly to the correct customer invoices.

     

    When you receive a batch deposit, it will include payments for multiple customer invoices. By going to the Receive Payments section, you can individually select each customer and apply the payment to their specific outstanding invoices. To do this, please follow the steps below:

     

    1. Open QuickBooks Desktop.
    2. Navigate to the Customers menu and select Receive Payments. 
    3. In the Receive from dropdown, ensure the correct customer's name is selected.
    4. Locate the invoices that have mistakenly been tagged with the amounts as amount due.
    5. Once done, enter the amount in the Payment column that corresponds to what should have been applied from the batch deposit. Ensure that the total payment amount at the top matches the total intended for the batch deposit, confirming that all entered figures are correct.
    6. Click Save & Close to update the records.

     

    Let's repeat this process for each customer affected by these changes. After making the corrections, review the customers' accounts to confirm that the payments are now reflected correctly and the amounts due are offset appropriately.

     

    Additionally, here's a an article you can check if you need guidance in combining multiple transactions into a single record to ensure your real-life bank deposit matches with QuickBook: Record and make bank deposits in QuickBooks Desktop

     

    If you have any questions or need further assistance while managing these payments, don't hesitate to reach out. Our team is here to help you make sure everything is accurate and up-to-date.

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement