Bank Statement Import

This screen allows you to import transactions from a file you have downloaded from your bank. This may be for a day or month, which ever works for you. Transactions imported this way are imported into infoodle, but don’t appear in a batch until you have reconciled the transactions.

1. On the Navigation Menu, select Finance, then on the Transaction Processing screen, select Banking then Statement Import.

   

2. You have the option to:

   1. Choose an open batch to add the bulk transactions to,
   2. Create a New Batch or
   3. Rename a Batch.

   Creating a new batch for each import is probably helpful.

3. Select the batch that you wish to import the statement to and select CHOOSE.

   

4. With the file saved on your computer, select Choose File to choose the bank file for importing.

   

5. Select the relevant format based on what you are importing. For example, select Give a little if you are importing transactions from Give a Little.

   

6. Pushpay, Give a little, Paypal and CSV options will present you with more information to complete to ensure that it matches with infoodle requirements.

7. Select the bank account that you wish to import this to. If you don't have one you can create a bank account by selecting Add new bank account.

   

8. Depending on the format you chose you may be presented with different choices or options. If you have alternative settings for your field separator, or in the amount field - the thousand and decimal separators, specify these during the import. By default they are: comma for the field, comma for the thousand, and full stop (period) for the decimal place separator.

   

9. Check the fields and columns you have setup.

   

10. Select Upload & validate file.

11. Infoodle will load the file and show you the first few records to give you the chance to verify that the import looks OK.

12. If OK select Import data.

13. Once a successful import occurs, you are presented with the first page of transactions that need reconciling. Reconciling is the process of checking that the data is OK and matches the contact records loaded with existing contacts. You can select Quick add to add the contact.

    1. You can close this screen if you are not able to complete the reconcile of these transactions at this time. To return here at any point to select this batch and reconcile, or to continue with the reconciliation process. See Reconciling Transactions.