Skip to main content
January 12, 2021
Question

Reports

  • January 12, 2021
  • 1 reply
  • 0 views

Hi, Does anybody know of a report please that shows the outstanding (unpaid) amount of customer invoices net of Vat (sales tax). I can only find reports with amounts that include sales tax. Thanks.

1 reply

January 12, 2021

Hello Richard91, 

 

Welcome to the Community page, 

 

Have a look at this report sales by customer 

 

So reports> scroll down to sales and customers>click on sales by customer detail report> select small cogwheel>tick net value>select customise>filter>tick 'A/R paid' and select it to 'unpaid' on the dropdown> run report 

 

This should then show you what you are wanting to see and find out. 

richard91Author
January 12, 2021

Hi Ashleigh,

 

Thank you for your reply. This gives the net amount but it repeats for each line of the invoice. What I am hoping to find is the net amount outstanding per invoice.

 

Is there a report which gives this information please?

January 12, 2021

Hello Richard91, You could also try the transaction list by customer report adding in the net amount and ar paid columns.