Skip to main content
Jan 12, 2021 10:43 AM UTC
Question

Reports

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.

9 replies

Jan 12, 2021 11:21 AM UTC

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
Jan 12, 2021 1:18 PM UTC

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?

Jan 12, 2021 4:55 PM UTC

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