How to import statements step by step?
Boonzi has an groundbreaking solution for importing statements which is safe, fast and comfortable, being also compatible with most of the banks.5 minutes a week is all it takes to import and organize all of your different bank accounts statements.
The following workflow works with checkings account statements, terms accounts statements or other kind of statements and also with Excel tables if organized like statements.
Despite being a very simple workflow, the first import can always cause some doubt for it being an unusual process.
1. Logging in to your online banking and selecting the statements to import
- Login to your online banking, like you do usually, using a web-browser.
- Go to your statements webpage and, with your mouse/trackpad select all the statements you wish to import. To select, simply press and hold the left button of your mouse and drag the mouse until you have all the desired statements.
- Right click over the selected area and select Copy. You can also just press Ctrl+C to copy to the clipboard.
2. Getting the statements into Boonzi
In Boonzi go to the Transactions screen and click Import on the top right corner (Ctrl+I for the keyboard shortcut). Click “Next” to go to the next step and then click on Import.
Done, the statements have been imported.
3. Columns validation (only required on the first import)
You just need to complete this step once. Check if Boonzi has detected the statements columns correctly. Different banks have different number of columns and formats so you may need to fix a column or two. After this Boonzi will always remember your configuration and skip this step.
The last step will show you a table with all of the imported statements. In the beginning Boonzi won’t be able to categorize them automaticallybecause he doesn’t know your profile (the payees and categories used in your transactions), but after categorizing some transactions manually, Boonzi will be able to automatically start filling those for you – saving you time and effort on the next imports.
“Teaching” Boonzi to auto-categorize
You should carefully and correctly insert the transactions payees and categories on the first imports. Just click on the table cell you wish to edit.
When writting the category name, you can use the following format, “Household:Electricity”. This will create a parent category named “Household” with a child category named “Electricity”. If the parent category already exists, only the child category will be created.
Everytime you specify a transaction payee or category, Boonzi will look for similar transactions and ask you if you want to apply the same payee/category across all the other transactions. This way, dozens of transactions are categorized in a flash.
After a few imports Boonzi will be able to automatically categorize most of your statements saving you time and effort.
This technique is completely safe, as you never have to insert your online banking credentials into Boonzi, nor do we ever ask for them, unlike many other personal finance softwares. Boonzi will only have access to the data you have selected and copied before you click “Import”.
Importing from CSV files
Importing from CSV files is also possible, however there are some disadvantages:
- It takes a bit more effort since it requires the additional step of exporting the file from your online banking to your hard-drive.
- Not all banks use the same standards for CSV files therefore not all the CSV files will work unless you edit them previously (in any text editor).
I completed every step but when I click “Import” I get a warning…
Confirm that when you copied from the online banking, you have only selected the statements table and nothing more.
If you still get the same warning please contact us or send us your feedback through Boonzi.