We have two guides on how to handle CIS within QuickFile for contractors and subcontractors, but this wouldn’t be reflected in any invoice values in the CSV file, as they’re just methods of payment.
That said, the file Sales_Receipt.csv contains a list of payments, the amount, date, client and details (including invoice numbers) which you could drill down on in spreadsheet software like Excel. If you have a bank account like the one in the links above, “CIS Deductions” then you can filter the data by the bank account name.
With the net value, this is shown in the Sales_Invoice.csv file. There are 5 monetary columns:
- TOTAL NET
- TOTAL VAT
- TOTAL GROSS
- PAID TO DATE
- BALANCE
Hope that helps