Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
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:
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:
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!
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?
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!
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:
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.
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?
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here