Skip to main content
W
wiryonob
March 5, 2020
Question

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.

  • March 5, 2020
  • 1 reply
  • 0 views
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.

    1 reply

    J
    JamesDuanT
    March 5, 2020

    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.

    W
    wiryonobAuthor
    March 5, 2020

    Terms & ConditionsAccessibility statement