Exporting Invoice data to the Excel Sample VAT Spreadsheet
 
First,  follow the steps outlined in Exporting Data on the previous page.
Double click the exported file to open it;  without making any changes to it, select and "copy" the contents.

Next, open the Excel Sample VAT Spreadsheet.xls* (located in the "Extras" file in your Aceedo folder, you can also open this file from the Data Export Files* page of this manual) and click the "Receipts"  tab at the base of the window.  

Now select a "cell" in column "A" to initiate the import (eg. A10) and "paste" the data in.

Your exported Invoice data will now be aligned under the following headings, reading L to R:
"Date of Issue, Type, Date Paid, Client, Product/Brand, Invoice No, Payment ref, Total, VAT, Net Sales and Other".
The "Bank Giro Credit No." column will be left blank for you to fill in the details.  Check that your invoice data is in the correct columns and that there are no "Errors" showing (to the right of the figures).

If you experience any difficulty importing the data from the exported file into an accounts application, you can use the Receipts Export.xls* file as described on the next page (the file is located in the "Extras" file in your Aceedo folder, you can also open this file from the Data Export Files* page of this manual). This file acts as a bridge between the exported data file and your accounts application.
Please see the Illustration; Sample VAT Spreadsheet

* Requires Microsoft Excel to operate.
Illustration; Sample VAT Spreadsheet