cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover the updated GST rates in QuickBooks Online Singapore Find out more
wiryonob
Level 2

Can Customer Balance Detail Report show cumulative running balance of outstanding A/R or unpaid invoice? Currently it only shows the balance based on specific invoices.

On the filter, I have ticked Receivable and change it from Unpaid to Paid. The report did not show a cumulative running balance from beginning of transaction with certain customer until now. Rather, some paid invoices become zero while unpaid will have some balance amount. While the total amount of A/R or unpaid invoice from customer is correct, I am not able to check historically the cumulative running balance over time. Appreciate if any can help. Thank you.
5 Comments 5
JamesDuanT
Moderator

Can Customer Balance Detail Report show cumulative running balance of outstanding A/R or unpaid invoice? Currently it only shows the balance based on specific invoices.

Customising the report is one way to get the data we need on the report, wiryonob.

 

When you pull up the Customer Balance Detail report, the Receivables Paid filter will always default to Unpaid.

 

I'd recommend selecting All in the Receivables Paid filter instead of Paid. Afterwards, you can click Run report.

This will show the cumulative running balance overtime. 

 

Also, let's not forget to set the correct Report period and click Run report.

 

You might also want to customise the columns, memorise report, or export it to Excel if necessary.

 

I'll be right here if you need additional help with this.

wiryonob
Level 2

Can Customer Balance Detail Report show cumulative running balance of outstanding A/R or unpaid invoice? Currently it only shows the balance based on specific invoices.

QB.jpg

wiryonob
Level 2

Can Customer Balance Detail Report show cumulative running balance of outstanding A/R or unpaid invoice? Currently it only shows the balance based on specific invoices.

Hi JamesDuanT,

 

I have set the filter to All in Receivable Paid. However, my main issue of displaying cumulative balance is not solved. Looking at the image that I uploaded, on the 29/01 I posted invoice to customer amounting to 115.700.000. But on that day, my customer has yet paid anything, yet the Open Balance shows 25.700.000 and the Balance shows 25.700.000. This 25.700.000 is actually the balance from the payment made by customer on 07/02, 10/02 and 18/02 minus the balance from earlier in mid 2019 which is not settled yet.

What I am looking for is, the Balance on 29/01 should be 115.700.000, while the balance on 07/02 should be 115.700.000 - 30.000.000 = 85.700.000 (from the total invoice, customer paid 30.000.000). The balance on 10/02 should shows 85.700.000 - 15.000.000 = 70.700.000 and the balance on 18/02 should be 70.700.000 - 10.000.000 = 60.700.000. The figures should be declining as the customer make payments. Instead, the Balance reflect 25.700.000 for all dates.

 

Thank you and Look forward to hearing from you.

Catherine_B
QuickBooks Team

Can Customer Balance Detail Report show cumulative running balance of outstanding A/R or unpaid invoice? Currently it only shows the balance based on specific invoices.

I appreciate that you've clarified the data that we need to display and run, wiryonob. 

 

While the option to itemize the balance of each cumulative payments we recorded, we can click the amount of the payment to show the original amount, open balance and payment. We can also export the report to Excel and manually calculate it from there. 

 

Here's how to export it to Excel:

  1. Once you've customized the report, click the Export icon at the upper-right. 
  2. Select Export to Excel
  3. Open the downloaded file and under the Open Balance column, we can enter the difference. 

Here's an article that we can check out to know more financial reports and what data we can pull up from it. 

 

If you need anything else, please let me know. Thanks!

wiryonob
Level 2

Can Customer Balance Detail Report show cumulative running balance of outstanding A/R or unpaid invoice? Currently it only shows the balance based on specific invoices.

Thank you for you input.

 

Exporting to excel to do manual counting solve the issue. But I m not comfortable with the face that we have to do manual counting since it potentially create room for errors.

 

On the other hand, I have to use excel as well to sort my Balance Sheet, because my Current Assets appear on top of my Cash and Cash Equivalent headings (and hence its individual accounts under respective account groups).

 

As such, I have to spend extra effort on Excel to solve these issues.

 

Anyway, appreciate your explanation and have a great day..