cancel
Showing results for 
Search instead for 
Did you mean: 
DavidPB
Level 1

Customer Balance Reports

Hi, my name is David Smith and I run a bookkeeping and accounting business in Oregon.  I have a question for some pro QBOers out there.

 

One of my clients (now to be referred to as the "business") receives deposits from his clients.  These items are attached to a current liability account named Customer Deposits I created specifically for holding those deposits.  Once the client terminates the contract with the "business", the deposits are to be paid back.  This is done as an expense against the liability account with the transaction assigned to the client.

 

Now, this client has a difficult time remembering to pay back deposits and record it correctly.  So, one of my trial balance tasks is to consistently audit this liability account to make sure that he doesn't owe a client a deposit, or that he needs to record that he kept the deposit for damage.

 

In QB Desktop this is a simple task, as I have multiple clients who use deposits that are Desktop users.  You simply run a "Customer Balance Summary" report, go into customize and put a filter to only look at the account in question.  Although this report defaults to A/R, you can change to any account and QB Desktop with show all debits and credits that are assigned a customer as a total.  The benefit is that if a client is attached to a credit for $100, and then a debit for $100, those clear and neither that client, nor the transactions show in the report as the balance is zero. So, I can easily audit which customers have a credit to the liability that haven't been returned, or if there is an error where a return was processed for a client but they never had the initial credit created.

 

Now for QBO.  I can not change the account (or I don't know how) for the customer balance summary.  I am left to print a transaction detail by account report and manually cross off equal debits and credits per client.  This is a nightmare.  My client holds deposits for months in some cases and I have to look at 100's of transactions.  I have a couple construction companies that I would like to move to QBO, but this is my one hang up as balancing their customer deposit account would be frustrating.

 

I would love to see in accountant reports the option to change the account filter on vendor and customer balance reports.  The inability to select anything other than AR or AP is just to simple for more complex accounting. 

 

I would love to hear someone tell me why I am an idiot and how QBO can do this.  If not, I would love to hear some ideas on a good work around.   And if not that, I would love to offer this as a suggestion for future updates.  Thank you to anyone who took the time to read this and help.

11 Comments 11
AlexV
QuickBooks Team

Customer Balance Reports

Good day, David.

 

Welcome to QuickBooks Community! Let me show you how to track prepayments in QuickBooks Online.

 

The Customer Balance Summary report is merely based on A/R, not on any prepayments that set in a liability account. Let's pull up a summary of the liability account instead and customize it by the customer.

 

You can follow these steps:

  1. Go to the Accounting tab and select Chart of Accounts.
  2. Search the liability account, then select Run report under the Action column.
  3. Select Customize and make sure that the Report period is correct.
  4. From the Filters section, select a Customer.
  5. Select Run report.

Click the Save customization button to save the customized report for future use. Then, you can access it from the Custom Reports tab. You can also check these links for more details:

Post again here if you need more help. Wishing you all the best!

DavidPB
Level 1

Customer Balance Reports

This is by far the best workaround I have seen.  Here is the issue, if a business has a 100 clients  in a period, which for some of my clients that period can be greater than 6 months, I have to go through all the zero balance customers to find the 2 or 3 that we owe.  Is there a way to not show customers with a zero balance?

BettyJaneB
QuickBooks Team

Customer Balance Reports

Glad to hear that the solution shared above was able to help you, @David - Perfect Balance.

 

Yes, there's a way wherein you can pull up the report without having the customers with zero balance to show up. I'd love to walk you through on how to achieve this.

 

You can run the report of your livability account by following the steps shared by my peer AlexV above. From there, you'll need to select Unpaid as the status of the A/R transaction from the filter section.

 

I'll guide you on how to get there:

  1. Click on Customize at the top of the report that you'll pulled up. 
  2. Press on Filter.
  3. Put a check-mark on the A/R Paid box. If you want to select the A/P to be included just tick the A/P Paid box.
  4. Choose Unpaid. This is applicable for A/P too. 
  5. Hit on Run Report.

To give you more tips about customizing your reports in QuickBoooks Online, please see this link: Learn how to get the most out of your financial reports.

 

Lastly, I'd like to share this article that contains information about the different reports that are available on your subscription: Learn which reports are available for your version of QuickBooks Online.

 

Know that my doors are always open to help if there's anything else that I can assist you with. Feel free to visit me here. Have a lovely day!

DavidPB
Level 1

Customer Balance Reports

So, I tried selecting A/P by itself, A/R by itself, and then both as unpaid.  All 3 selections resulted in a report that had no data to report.

 

I believe these filters are attached to A/P or A/R.  This account is not associated with either.  And to be clear, I feel it is inappropriate and misleading to select A/R or A/P for this function.  Even if that did work, it would be... wrong?

 

Again, I am confident that QBO needs to allow the adjustment of customer balance reports to reflect whichever account the user needs.  Fixing those accounts to A/P or A/R is too simple of reporting and doesn't supply the need for more complex accounting with clients who hold balances in different accounts other than A/R or A/P.

DavidPB
Level 1

Customer Balance Reports

So, I tried selecting A/P by itself, A/R by itself, and then both as unpaid.  All 3 selections resulted in a report that had no data to report.

 

I believe these filters are attached to A/P or A/R.  This account is not associated with either.  And to be clear, I feel it is inappropriate and misleading to select A/R or A/P for this function.  Even if that did work, it would be... wrong?

 

Again, I am confident that QBO needs to allow the adjustment of customer balance reports to reflect whichever account the user needs.  Fixing those accounts to A/P or A/R is too simple of reporting and doesn't supply the need for more complex accounting with clients who hold balances in different accounts other than A/R or A/P.

Long time user1
Level 1

Customer Balance Reports

I am also trying to NOT show customers with a zero balance on a report, but I'm using QB desktop version. Is there a way to do that?

JuliaMikkaelaQ
QuickBooks Team

Customer Balance Reports

Yes, there's a way to not show the customers with zero balance in QuickBooks Desktop, user1. You can use the Customer Balance Summary report to do that.

 

The Customer Balance Summary report is available in the desktop version and allows you to filter the data and generate a report for clients who still have outstanding transactions. Here's how:

 

  1. Go to the Reports menu and select Customers & Receivables.
  2. Choose Customer Balance Summary.
  3. From there, click the Customize Report button.
  4. In the Display tab, press the Advanced option, and pick Non-zero, then tap OK.
  5. Once done, hit OK to apply the modification.

non-zero Customer Balance Summary.png

 

Furthermore, you can memorize the reports to save the customized data settings for future use. Please refer to this article for the complete details: Create, access, and modify memorized reports.

 

In addition to that, I recommend checking out the Understand Reports article to explore the complete list of accessible reports in QBDT.

 

Let me know in the comments if you have other reporting concerns and questions about managing transactions in QBDT. I'll gladly help. Take care, and I wish you continued success!

Long time user1
Level 1

Customer Balance Reports

The non-zero option is not available if I want a detailed report, not a summary.

ZackE
Moderator

Customer Balance Reports

Thanks for getting back with the Community, Long time user1.
 

I can certainly understand how an ability to customize your Customer Balance Detail report to display rows as non-zero could be useful and have submitted a suggestion about it as of today.
 

You can also submit your own feature requests while using QuickBooks.
 

Here's how:
 

  1. In the top menu bar, go to Help, Send Feedback Online, then Product Suggestion....


     
  2. Choose a Type of Feedback and Product Area (optional) from your available drop-down menus.


     
  3. Enter any suggestions/feedback in the Here is my suggestion: field.


     
  4. If you'd like, include your name/email in the My name is: (optional) and My e-mail address is: (optional) fields.


     
  5. Select Send Feedback.

 

Your feedback's definitely valuable to Intuit. It will be reviewed by our Product Development team and considered in future updates. You can stay up-to-date with the latest news about your product by reviewing Intuit's Product Updates webpage.


You also have the option of checking our QuickBooks Marketplace for apps which may be able to help you achieve what you're looking to accomplish.


As a workaround, you can run the Customer Balance Summary report mentioned in JuliaMikkaelaQ's post. Another option I can think of is exporting your Customer Balance Detail report and customizing it further outside of QuickBooks.
 

Here's how to export reports to Excel as XLSX files:
 

  1. Pull up the report you want to export, then use its Excel ▼ drop-down list.
  2. Choose Create New Worksheet or Update Existing Worksheet.
  3. If you see a message saying your report has too many columns, click Advanced, then uncheck the Space between columns checkbox and press OK.
  4. When you're ready, select OK.

 

Reports can also be exported as CSV spreadsheets or PDFs.
 

I've also included a couple detailed resources about working with reports which may come in handy moving forward:
 

 

Please don't hesitate to send a reply if there's any questions. Have a wonderful Thursday!

Yankeetang0
Level 1

Customer Balance Reports

It has been 4 years since you posted your need for a customer balance report for QBO that shows all non-zero customer balances. I have the same need and have not been able to get this to work. 4-years later, are there any solutions?

JanbonN
QuickBooks Team

Customer Balance Reports

Hello there, @Yankeetang0. I'm here to share some details about the customer balance report you need.

 

The Customer Balance Summary report allows you to filter for customers with non-zero balances.

 

Here’s how to generate it:

 

  1. Go to Reports and select the Standard tab.
  2. Type and click the Customer Balance Summary in the Find report by name field.
  3. In the Show non-zero or active only dropdown, choose Non-zero for both Show rows and Show columns sections.
  4. Click Run report.

 

On the other hand, if you prefer using the Customer Balance Detail report, you'll need to export it and manually remove the zero balances.

 

To have the non-zero option for your Customer Balance Detail report, I suggest sending feedback again to our product engineers for them to analyze this and consider adding this in future updates.

 

  1. Go to the Gear icon and select Feedback.
  2. Enter your comments or product suggestions.
  3. Tap Next to submit.

 

Additionally, you can refer to this article for the steps on printing, emailing, and exporting your reports: Run reports in QuickBooks Online.

 

Let us know if you have other concerns with your customer reports in QBO. We're here to help you in any way we can.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us