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.
I'll be right here if you need additional help with this.
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.
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:
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!
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..