We are able to download bank statements from our bank, as a CSV file, and iKnow will allow us to import the CSV file to the system. This means that donations, that have been paid directly to our bank account, can also be recorded in iKnow.
To import a Bank Statement, we will need to go to Transactions, and click the Import Bank Statements tab. This will show a list of any previous imports, which we can view by clicking the eye icon, to the right of the import.
To import a new statement, we will need to click the Add Statement button.
We will need to enter an Import Reference, then click the Upload button, and select the CSV file from our hard drive. We can then click the Import button.
On the next screen, we will need to let iKnow know which columns, from our statement, need to be imported. iKnow only needs the date, reference, and amount, so we can use the drop downs, at the top of the relevant columns, to make our selections. Once we have selected the relevant columns, click the Assign Data button.
iKnow will ask us to confirm the Date Format. Different banks will format the dates in different ways, on their statements. We will need to select the format that matches our bank statement, in the drop down, and click Assign.
On the Assign Transactions page, we will see all the transactions that have been imported. Any transactions that are greyed out, didn’t match the column types, or the Date Format, that we selected, so won’t be imported to iKnow.
If we see any transactions that have been included, but shouldn’t be, we can untick the tick box, on the left of the transaction, to stop it being imported.
For each transaction, we will need to select a Source and a Campaign, from the relevant drop down lists. We will also need to assign a Giving ID. If we type the name of the Donor in the search box, we will see a list of matches appear, and we can select the correct Donor, by clicking them in the list. If Automatic Gift Aid has been selected, on the Donor’s profile, the Is Gift Aidable toggle will be switched on automatically, for us. This can still be switched manually, if needed.
We should only need to make these selections, the first time we import a statement. For subsequent statements, iKnow will recognise the Donors, so the Giving ID and the Campaign, will be completed automatically.
Once the details are completed, we can click the Import Selected button, and the donations will be added to iKnow.