i want to reconcile my clients VAT Return based on Sales/Purchase Day Books as they process invoices with mixed rates of VAT within the same invoice. On Sage 50 desktop there is a a detailed invoice report that I can export to excel to double check the client has posted the correct VAT code. When I try to run this report in Sage online it shows as two or more separate rows itemising the VAT rate but the report can't be sorted to show these by supplier as the rate isn't connected to the Supplier name. Can this be done any other way as it's impossible to check the entries where there are thousands of lines.
Guest
