Your software includes a powerful utility that allows users to enter large numbers of purchase transactions – i.e. invoices and credit notes – by automatically importing selected data from an external CSV (Comma Separated Value) file. This can be very useful, for example, if your supplier invoices and credit notes are produced and sent electronically, as the alternative would be to post each transaction individually, which can be time consuming and can introduce errors.
You may need to create a listing of the transaction details in a CSV format file. Transactions can be imported whenever needed, even many times per day, if required.
Preparation: The following list of possible preparation steps will help you decide if you need to do anything before processing and if you need help.
Select a company – see Change Companies.
Obtain an up-to-date supplier list – see List Suppliers.
Obtain an up-to-date nominal code list – see List Chart of Accounts.
Ensure supplier details are up to date – see Create & Edit Supplier Accounts.
Ensure you have details of goods received.
Set the default transaction date as required – see Change Accounting Date.
Create the transaction listing CSV file – see Purchase Ledger Invoice CSV Import form below.
On the main menu, click Daybooks > Sales Daybook > CSV Import to open the Purchase Ledger Invoice CSV Import Form
Select the relevant source fields and map each to its appropriate target system data field – see below.
Select the relevant import criteria including the CSV file path.
Click Preview to test the import and save to save the configuration for future use.
Click OK to accept and update records or click Cancel.
Write the entered/system generated document number on the invoice. File in document number order. File copy of daybook listing for today’s input with documents.
2 blocks of 10 possible entries – Left to Right
Left column, first cell – enter Account code column name from CSV file e.g. ‘A’. Thereafter continue to select column name of cell – ‘B’ etc and in the right cell select the appropriate field.
The fields don’t have to be in order but the cell must match the selected field – this process is called ‘Mapping‘
When complete, find the import CSV file by clicking on the search…. button.
Click on the ‘Preview‘ button to check – you can always clear and correct until happy.
‘Save‘ saves the format of the file for future imports.
Create New Accounts: Check to create new customer accounts where not found – you will need to complete details on these accounts in account maintenance.
Click on ‘OK’ to import the data and ‘Close’ to close without saving.