Select a bank account that you want to import a statement for and import a bank statement.

Configure the import settings for the import by assigning columns in your bank statements to fields in Jaz.

You can review the imported statement lines before finishing.

Custom Bank Fields let you set up your own fields to match or assign values from your bank statements when importing.

Go to Bank Records → Bank Statements → Manage → Manage Bank Fields

During import, assign columns from your bank statement to your Custom Bank Fields.

Yes. Custom Bank Fields can be referenced in Bank Rules.

Go to Bank Records → Bank Statements → Manage → Bank Rules → + New Rule

Under the Percentage Portion, set an account by and choose to set by bank fields.

Yes. Custom Bank Fields can be edited, made inactive, and reactivated.

Note: Custom Bank Fields on controlled bank feeds cannot be edited or changed.

Yes. You can copy an existing Custom Bank Field from another bank record instead of creating one from scratch.

For example, to copy the "Opening Date" field from a Main Bank Account to a Sub-Bank Account:

Go to the Sub-Bank Account → Manage Bank Fields → Dropdown Button → Copy from Account → Choose the Main Bank Account.

You can upload your statements in a CSV file format or as a PDF.

Yes. To import a password-protected bank statement, include the password in the file name using this format:

Note: Make sure there are two underscores before and after pw and do not include the “<>” – brackets.

Yes, Jaz will extract the columns from the uploaded PDF file and let you assign them to fields in Jaz.

Jaz will extract statement lines from the uploaded PDF file and create a downloadable CSV file for reviewing discrepancies, if any.

Alternatively, you can still import the statement lines with no errors. Jaz will ignore the ones with issues and import the rest.

The final statement amounts that get recorded in Jaz will be in the currency of the bank account in Jaz, not the currency of the amounts in the bank statement.

Jaz will not do any automatic conversion between the different currencies, and will solely take the numerical amounts as is.

For example, a statement line with 50 USD as its amount will be recorded in Jaz as 50 USD when importing into a USD bank account, or 50 SGD when importing into an SGD bank account.

Yes, Jaz will let you review all the statement lines before they are imported into your bank account on Jaz.

Yes, you can upload up to 12 files at a time.

To manage your uploaded statements, utilize the Overview tab:

Yes, you can delete a bank statement line individually via the 3-dot icon on the statement line, or bulk-delete by selecting multiple statement lines at once from both reconciled and unreconciled tabs.

Yes. Under the Deleted tab for the bank account, you will find a list of deleted statement lines.

Undelete an individual statement line, or bulk undelete, to move it back to the Unreconciled tab.