Yes, you can edit a bank account from the reconciliations tab OR the chart of Accounts 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.

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

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.

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.

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.

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.

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.

Jaz filters available records, listing transactions that match the cash flow direction.

If you do not see any records listed upon the first load, that means there are no transactions in Jaz that have the same cash flow direction.

Yes, Jaz supports bulk reconciliations in 2 ways -

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.

Select desired unreconciled records and use the quick reconcile feature to create individual journal entries in the background for each record.

Just enter the Journal reference & journal account which will be used to create a balancing entry.

To reconcile a bank statement against a new invoice/bill, you can 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.

Cash-in / Cash-out journal template allows for quick journal creation & statement reconciliation.

The 1st line entry in the journal is always extracted from the statement line to be reconciled.

You can add 1 or more balancing journal entry lines in the template.

If the statement line bank account is in foreign currency, you can set a custom rate for the journal / Jaz will set the org rate if available on the statement line date/fetch from 3rd party.

Cash Transfer Journal is a quick way to capture money movement between the statement line bank account & other bank accounts added to your organization.

For Cash-in statement line -

For Cash-out statement line -

If the cash transfer is between 2 bank accounts of different currencies, Jaz will calculate the transaction rate on the fly based on the amount entered by you and the statement line amount.

Yes, you can create a journal transaction from the reconciliation screen.

This templated journal is less rigid compared to cash-in/cash-out journals OR cash-transfer journals.

In this Journal you can add debit/credit entries irrespective of whether the entry in question is cash-in / cash-out.

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

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.

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

Adjustment journals are created in the statement line's currency.

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

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.

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 reconciling against a transaction instead of a payment, you will be able to indicate transaction fees when recording new payments during the reconciliation process.

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 remain recorded.

You can reset the reconciled statement lines individually using the 3-dot menu or you can bulk reset by multi-selecting desired records.

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

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 have the bank account as its payment account in the Unreconciled Records Tab.

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

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

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