Skip to main content
J
JV30
May 24, 2025
Question

Aggregated Customer Payment Presentation

  • May 24, 2025
  • 1 reply
  • 0 views

Hello,

 

We have two company instances in QBO (Company A and B). In company A, I am able to record, for example, a $1,000.00 bulk deposit into our bank by matching and selecting all the customer invoices that comprise that $1,000.00 bulk deposit. In the bank general ledger, the deposit appears as a single line item of $1,000.00.

 

In company B, however, the same situation as the above will appear as multiple customer deposits that comprise the $1,000.00 in the bank general ledger as opposed to a single "debit" to our bank balance.

 

Is there a setting in QBO that allow company B's treatment of the customer deposit to mirror company A's deposit presentation (as a single).

 

Please see the attached image as an example of what I want the genera ledger to look like.

1 reply

Bryan_M
Bryan_M
May 24, 2025

I'm thrilled to see you here, @JV30. I'm here to thoroughly explain how to display the Company B customer deposits as a single line item, just like Entity A.

 

Before anything else, I'd like to know if what you mean by the "bulk deposit" in Company A is a one-time drop. If so, this could be the cause why it shows as a single line item in your bank's general ledger.

 

The reason of Company B's deposit is presented in various transactions and not in a single entry is that it appears to have multiple customer payments.

 

Therefore, you'll need to enter the overall deposit in one transaction before linking it to the open invoices comprising that payment. Ensuring it will display as a solo entry.

 

Moreover, QuickBooks doesn't have a specific setting to show deposits as a single line item.

 

Additionally, consider reading this article to learn how to locate funds in QuickBooks: Find missing payments you want to deposit in the Bank Deposit window in QuickBooks Online.

 

If you're looking for ways to ensure that your sales transactions and deposits are in sync based on the automation in our system, feel free to reach QuickBooks Live Expert Assisted.

 

You can always return here if you have additional questions about the display of your customer deposits and invoice payment linking, @JV30. I'm always here to assist you. Have a great day!

Terms & ConditionsAccessibility statement