Importing Bank Transactions in CSV format

Screen: Import Bank Transactions

Bank transactions can be imported to a bank account defined in Bookkeeping so that they can be used as part of the bank reconciliation process.

Select the CSV file from Dropbox by pressing the "Select File" button and selecting the CSV file.

Select the bank account that the transactions relate to.

Select the predefined format if you have previously saved a mapping for this type of CSV file.

Otherwise touch the row in the bottom section of the screen and then tap the corresponding field in the top section of the screen.

For example: tap the row containing the transaction date, and then tap the date column field.

Make sure that you set the date format to match the format used in the CSV file.

Once you have mapped all the fields that are necessary, and set the other fields as appropriate, you can save the mapping as a predefined format by pressing the predefined format button and selecting "Save Current Format".

Normally money deposited is a positive value, and money withdrawn is a negative value. If the file has these the other way around then set the "Negate Values" switch ON.

Then press the "Start Import" button to import the transactions from the BAI2 file into Bookkeeping.

On the completion of the import a status message will be displayed informing you of the number of transactions imported and the date of the reconciliation that was created.

An option button will appear at the top right of the screen. From the option menu you can open the bank reconciliation that was created.

The files are imported from Dropbox if you have specified that Dropbox is used for importing on the Dropbox screen. The folder where the files are imported from is the folder specified as the import folder on the Dropbox screen.