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.

Yes, you can create a journal transaction to reconcile against a bank statement.

Enter the details for the journal entry. The debit line will be automatically filled in for you, based on the bank statement being reconciled.

Jaz will autofill the account & amount from the statement line. You will need to add balancing entries as required.

If you choose a cross-currency account (indicated by the underlined debit/credit amounts), you must add the exchange rate.

Note that you cannot partially reconcile a statement line with a journal transaction.

Yes, you can delete a bank statement line via the 3-dot menu on the statement line.

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

Undelete it to move it back to the Unreconciled tab.

The statement balance is the sum of all unreconciled and reconciled statement lines, not taking into consideration deleted statement lines.

The Jaz balance is the sum of all the transactions that use the bank account as a payment account.

The two balances might not always be equal. For example, the balances will not match if the value of the statement lines imported is higher than the amounts of all available transactions in Jaz.

Yes, you can edit a bank account from the reconciliations tab OR from the chart of Accounts tab.

Jaz filters available records, listing transactions that are within a 30 day window of the statement date (before and after), and also matches the cashflow direction.

If you do not see any records listed upon first load, that means there are no transactions in Jaz that fall in the 30 day window of the statement date & cashflow direction. Hit reset to list all the transactions in Jaz, including those outside of the 30 day window.

To reconcile a bank statement against a new invoice/bill, create a new invoice/bill receipt.

The details for the invoice/bill receipt will be automatically filled in for you based on the bank statement line.

You can add an adjustment to fully reconcile the statement.

Adding an adjustment is similar to creating a journal entry. Adjustment entries have information like the bank account already filled in.

When you select a cross-currency transaction to reconcile with a statement line, you will be asked to add the cash received/spent in the statement line's currency.

You can have a maximum of 4 journal entry lines in an adjustment journal.

To partially reconcile with a statement line, you can change the Match Amount for a transaction that you would like to partially use for reconciliation.

Transactions, payments & adjustment entries can be combined to reconcile a statement line.

Yes, you can download a list of both unreconciled & reconciled records in Jaz.

You can export a list for all time, or choose a custom date range.

The final export will show a list of all unreconciled transaction records that has the bank account as its payment account in the Reconciliation Report Tab.

You can also view unreconciled bank statement lines under the Bank Statement Lines tab.

To see the transactions used, click on the reconciled statement line.

This will bring up the details for the reconciled statement line, including the list of transactions used to reconcile the statement line.

You can see a list of reconciled bank statement lines via the Bank Statement Lines of the Reconciliation Report.

Refer to Q18. Can I export a list of unreconciled records? for more information on using and downloading the reconciliation report.

The corresponding business transaction records previously used for matching will be unmatched.

There will be no further impact on your financial reports. However, previously created transactions such as journal entries used for adjustments will still remain recorded.

Yes, there are a couple of ways you can reset reconciliations -

Yes, you can do a bulk reconciliation.

Download your unreconciled statement lines, and fill in the details as needed on the reconciliation template.

After filling the template up, save the template and upload it. You will be able to review the reconciliations and the journal entries that will be created.

Note: You can import up to 500 new reconciliations with the template.

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.

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

Clicking on Jaz Balance will bring you to the Cashflows page, only showing cashflow transactions involving the payment account.

When loading the list of payments available for reconciliation, the amount shown will be net cash amounts. Reconciliations will be done against this net cash amount.

If you are reconciliating against a transaction instead of a payment, you will be able to indicate transaction fees when recording new payments during the reconciliation process.

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

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

If all the dates in the uploaded PDF file are in the same format, Jaz 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, Jaz will provide a date selector for you to set a date format for all the records in the 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.