How to import a bank statement

What this is for

Instead of typing every line by hand, you can upload the statement file your bank gives you. IzzyTap reads the transactions, you confirm the columns, and the lines are ready for you to reconcile. Nothing is posted to your books during the import. That only happens when you reconcile.

Get the file from your bank

1. Log in to your bank's online or business portal.
2. Open the account statement for the period you want.
3. Download or export it as CSV or Excel. PDF is not supported for now.

Open the import screen

1. Log in to your workspace.
2. In the left menu, under Finance, click Your Accounts.
3. In the accounts side menu, under Banking, click Bank accounts.
4. In the Your accounts list, click the name of the account you want to import into.
5. On that account's page, click Import statement.

Upload the file

1. On the Import a statement screen, under Statement file (CSV or Excel), click the file button and choose the file you downloaded. It must be a .csv, .xls or .xlsx file.
2. Click Upload & map columns.

Confirm which column is which

You now land on the Which column is which? screen. IzzyTap makes its best guess at your columns and shows a preview of the first few transactions.

1. Check each dropdown under Columns. Match each field to the matching column from your file:
   • Date
   • Description
   • Money out (Debit) and Money in (Credit) if your statement has two separate amount columns.
   • Amount (one signed column) if your statement instead uses a single amount column where money out is a negative number.
   • Running balance, which is optional but helps IzzyTap avoid importing the same line twice.
2. If a field is not in your file, leave that dropdown on not in file.
3. Look at the Preview table. Check that the dates, descriptions and amounts look right, and that money out shows as a minus figure.
4. When the preview looks correct, click Import these transactions.

After the import

IzzyTap takes you back to the account page and confirms how many transactions it imported. If any lines were already imported before, it skips them and tells you how many it skipped.

The file now appears in the Statement imports list, showing the file name, the period it covers, the number of rows and the date you imported it.

What to do next

Your imported lines are now waiting to be ticked off. Follow How to reconcile your bank to match them to your books and lock the month.