Getting list of Purchase Orders excluding VAT

Accounting
1

Hi team,

I am trying to extract list of Purchase Orders raised but don’t want to see the VAT amount.

Is there any report in “Quick File” (Affinity) can get me a report with list of Purchase Orders without VAT?

In other words I am looking for “Supplier” report which shows me how much we paid to each supplier (excluding VAT).

Thanks,

2

Hi @akeshani

Just wanted to check - do you mean Purchase Orders, or Purchase Invoices?

1 Like
3

Hi @QFMathew,

I believe so. Receipt numbers for each one of them begins with QF.

Thanks,

4

Purchase orders or purchase invoices?

5

@Paul_Courtier Purchase Invoices (excluding VAT)

6

Hello @QFMathew
Your response on this is much appreciated.

Thanks

7

I’m not sure if there is a single report that will show you that in the web UI, but if you have an account backup available then the information is there in the Purchase_Invoice.csv file - if you can open it in something like Excel/Numbers/Google Sheets then you should be able to sort by supplier name and then add sub-totals to the “total net” column at each change of supplier, or use a pivot table.

2 Likes
8

Thanks @ian_roberts
How can I get back up?

9

Hi @akeshani

There’s more details on how to create a back-up, here: Create a data backup schedule