Importing Sales ,EU Sales, Expenses , EU Expenses and General Journals
1(a) , Before you start, confirm that your App has already been configured with the Customers, prices, and VAT(Sales tax) rates that are to be included in your import transactions, if not go back and deal with this first.
1(b), To format the transaction data for import , please use an excel worksheet.
2, Column Headers
Sales and EU Sales Headers: Required headers(All mandatory) are : id , invoicedate, invoiceno , clientname, description, salestaxrate, units, price and uniquepostingidentifier.
Expenses and EU Expenses:Required headers(All mandatory) are : id , invoicedate, invoiceno , clientname, description, vatrate, amount, account and uniquepostingidentifier.
General Journals: Required headers(All mandatory) are : id , invoicedate, invoiceno , clientname, description, debit, credit, account and uniquepostingidentifier.
Account(General ledger code taken from the App),
uniquepostingidentifier(this must be a unique code, unique for every line, chosen by your self. App will not import any line with a code that has been used already)
3,Do not import more than 1000 lines per type.
4, Each line must have all columns filled in, where there are no figures put a zero .
5, You can import multiple invoices on the same worksheet, but each must have a unique invoice number.
6, You must save the worksheet as a Tab delimited text file.
7, The txt file must be accessible to the “Files” App on iphone. Up load the file to your Icloud account or Microsoft Onedrive account that is linked to your iphone.
8(a) Open the App and click on the Admin link on the first screen.
8(b) Look down the list on the admin screen till you see “Add Sales” then click on it;
8(c) On the new screen tap on the browse button and locate your text file.
8(d) Tap once, firmly , on the file and it should begin to process the upload. Please note that your phone may become unresponsive for a few minutes if you are uploading up to 1000 lines of data.