Skip to main content

Managing Bank Statements

Updated today

Q1. How can I import a bank statement?

  • 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.

    • Note: The statement date and amount fields must be assigned to a column in your statement.

  • You can review the imported statement lines before finishing.

Q2. What file formats are compatible with statement uploads?

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

Q3. Will Jaz let me configure the columns from the statement PDF file?

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

Q4. What if there are errors in the uploaded PDF statement file?

  • 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.

Q5. Can I import a statement in one currency into a bank account that uses a different currency?

  • 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 that has 50 USD as its amount will be automatically recorded in Jaz as 50 USD, when importing to a USD bank account, or 50 SGD if importing into a SGD bank account.

Q6. Can I review the statement lines before they are imported into the system?

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

Q7. Can I upload multiple bank statements?

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

Q8. Can I manage my uploaded statements?

  • To manage your uploaded statements, utilize the Overview tab:

    • Pending – configure and review imported statements

    • Imported – view, download, delete statements

    • Empty – uploaded files with no statements

    • Deleted – view and restore deleted files

      • Note: Reconciled files cannot be deleted.

Q9. Can I delete a bank statement line?

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

Q10. Is it possible to retrieve a deleted statement line?

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

  • Undelete individual statement line OR bulk undelete to move it back to the Unreconciled tab.

Did this answer your question?