Uploading a Bank Statement
Plannr offers the option to add a Bank Statement manually or upload via CSV. This article covers uploading via CSV, but information on how to add a Bank Statement manually can be found here.
Go to the Income Reconciliation section under the Business tab.
Select Bank Statements from the options on the left. You can also go in via a specific month.
Here you can see all your Bank Statements.
Press the Actions button in the top right.
Select Upload Bank Statement.
Please note you should exclude any bank lines that should not be recording in Plannr such as outgoing and non Revenue related
After selecting, you'll be brought to the following page. This is Step 1 in the process of uploading a bank statement.
Select the payment period from the dropdown menu that appears. If you go in via a month, this will be pre-populated.
Enter the date of the bank statement.
If you wish, enter a reference and title for the for the statement.
Once you have inputted the required information, Step 2 of the process appears below.
Select if your csv has headers.
Choose the relevant csv to upload.
Press Continue when ready.
Match the fields in your bank statement with those in Plannr. You can select ignore for any fields that you cannot match.
You'll then be brought to Step 3, the review of your data.
Once you've checked over the data to make sure it all looks okay, select Everything looks good.
Finally, you'll be taken to Step 4, importing the data.
Press Start Import when ready.
Once imported, you'll be taken to the new Bank Statement. You can go into any of the individual transactions by selecting the eye icon next to the relevant transaction. You can also see the total at the top of the statement reflecting the total of all the transactions.
Plannr will remember previous Bank Statement mapping
When you upload a new Bank statement and complete the mapping, the system will remember these mappings for future uploads
Go to the Income Reconciliation section under the Business tab.
Select Bank Statements from the options on the left. You can also go in via a specific month.
Here you can see all your Bank Statements.
Press the Actions button in the top right.
Select Upload Bank Statement.
Please note you should exclude any bank lines that should not be recording in Plannr such as outgoing and non Revenue related
After selecting, you'll be brought to the following page. This is Step 1 in the process of uploading a bank statement.
Select the payment period from the dropdown menu that appears. If you go in via a month, this will be pre-populated.
Enter the date of the bank statement.
If you wish, enter a reference and title for the for the statement.
Once you have inputted the required information, Step 2 of the process appears below.
Select if your csv has headers.
Choose the relevant csv to upload.
Press Continue when ready.
Match the fields in your bank statement with those in Plannr. You can select ignore for any fields that you cannot match.
You'll then be brought to Step 3, the review of your data.
Once you've checked over the data to make sure it all looks okay, select Everything looks good.
Finally, you'll be taken to Step 4, importing the data.
Press Start Import when ready.
Once imported, you'll be taken to the new Bank Statement. You can go into any of the individual transactions by selecting the eye icon next to the relevant transaction. You can also see the total at the top of the statement reflecting the total of all the transactions.
Plannr will remember previous Bank Statement mapping
When you upload a new Bank statement and complete the mapping, the system will remember these mappings for future uploads
Updated on: 13/09/2024
Thank you!