Enter your idea

We reconcile monthly sales with an internal ordering/salesprocessing system. This is good for checking to see if invoices have been missed and also to make sure that the net sales are the same in Xero too (another fail safe check). There needs to be a sales report that is easy to run off on a monthly basis showing net figures. Currently I have to run a couple of reports off - identify prepayments and delete them in the excel version, then add another column to work out net value. The latter is not always easy as some of our goods are VAT expempt! Please can someone design this or modify an existing report, so that I don't have to faff around which takes a long time. Thanks