cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Bethany RC
Level 1

Batch Deposits

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?

6 Comments 6
CharleneMaeF
QuickBooks Team

Batch Deposits

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!

Bethany RC
Level 1

Batch Deposits

Thanks! So to avoid this is in the future I should only check one box at a time in Record Deposits so that they are not batched correct?

kshire-nwc
Level 1

Batch Deposits

My searches on reconciling batch deposits keep returning to this one question. I am stumped.  I work for a trucking company that utilizes batch deposits for payments from customers.  In Desktop those batch invoices could be check marked to total together so that bank statements could be reconciled.  Is this feature unavailable and the batching of payments discouraged in QuickBooks Online?  Please advise how to proceed.  Thank you!

Adrian_A
Moderator

Batch Deposits

Hi there, kshire-nwc.

 

This feature is also available in QuickBooks Online. I'm here to guide you through the process.

 

When recording multiple payments, you can deposit them into an Undeposited funds account. From there, make deposits one at a time for each deposit slips. Here's how:

 

  1. From the + New tab, select Bank Deposit.
  2. On the Account drop-down, choose the account you want to put the money into.
  3. Tick the transactions you want to combine.
  4. Ensure the total of the selected transactions matches your deposit slip.
  5. Click Save and close or Save and new.

 

Once done, you can review the bank deposits. Here's an article for the detailed steps: Manage bank deposits.

 

I've also added this link as your guide in reconciling transactions: Reconcile an account in QuickBooks Online.

 

Feel free to mention my name if you need help about the reconciliation process.

YusK
Level 1

Batch Deposits

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?

Dandie_A
QuickBooks Team

Batch Deposits

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.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us