Skip to main content
November 27, 2022
Question

If I run my transaction list by customer, it show the payments as a positive figure and adds it to the total due along with all the invoices. Can I change this somehow?

  • November 27, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

LieraMarie_A
November 27, 2022

We're pleased to have you here in the Community, @jkabassonia. 

 

I can see how it would be helpful to change the way payments show on the Transaction List by Customer report. Being able to list them as negative numbers would be great. This way, you'll come up with the customer's actual balance.

 

I suggest running the Customer Balance Detail report. You can customise it to display all the transactions for each customer. Payments are listed as negative figures giving you the customers' ending balances.

 

Here's how:

 

  1. Go to the Reports menu.
  2. In the search field, look for "Customer Balance Detail."
  3. Click on the Customise button.
  4. Head to the Filter section.
  5. In the Receivables Paid drop-down, select All.
  6. Click Run report.

 

Additionally, you may export this to Excel to save, store, and transfer it digitally if needed.


Please let me know if there's anything else that I can help with reports. I'm always here to assist. Have a wonderful day!