Managing Bank Statements

Managing bank statement

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

    • 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 Juan let me configure the columns from the statement PDF file?

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

Q4. How do I set the date format for records imported from the PDF?

  • If all the dates in the uploaded PDF file are in the same format, Juan will detect it and you will not have to manually set it.

  • However, if there is more than 1 date format detected in the uploaded PDF file, Juan will provide a date selector for you to set a date format for all the records in the file.

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

  • Juan 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. Juan will ignore the ones with issues and import the rest.

Q6. 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 Juan will be in the currency of the bank account in Juan not the currency of the amounts in the bank statement.

  • Juan 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 Juan as 50 USD, when importing to a USD bank account, or 50 SGD if importing into a SGD bank account.

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

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

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

Q9. 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?
😞
😐
😁