Juan 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 Juan that have the same cash flow direction.
Hit reset to list all the transactions in Juan , including those that do not match the cash flow direction.
Transaction Type | Description |
Quick Reconciliations |
|
Invoice/Bill Receipt |
|
Cash-in/Cash-out Journal |
|
Cash Transfer Journal |
|
Journal Entry |
|
Transactions created in Juan |
|
Add adjustment entry |
|
Yes, use Quick Reconcile to bulk reconcile records by using the same journal entry account for all the journal entries created for every selected unreconciled record.
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.
Every single journal created from this flow will have the same journal reference & journal account. The journal amount will be based on the unreconciled record amount.
The journals created will match the bank account's currency.
If its created in FX currency, you can set the exchange rate of all the journals getting created from the quick reconcile flow or Juan will fetch the organization rate if available OR fetch it from 3rd party.
Include the desired placeholders (e.g., {{bankReference}}) while reconciling.
If an attribute is missing (e.g., no payee name is provided), the system will omit that dynamic string from the reference instead of leaving it blank.
Dynamic strings rely on the data available in the bank statement. If a bank does not provide a certain attribute, that specific dynamic string will not populate.
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.
If it's a Cash-in journal, the statement line bank account is debited.
If it's a Cash-out journal, the statement line bank account is credited.
You can add 1 or more balancing journal entry lines in the template.
If it's a Cash-in journal, the balancing entries will be credited.
If it's a Cash-out journal, the balancing entries will be debited.
If the statement line bank account is in foreign currency, you can set a custom rate for the journal / Juan 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 -
You only need to select the account from which the money is transferred to the statement line's bank account. (i.e. add credit entry)
Juan will get the debit/credit amount & date from the statement line.
For Cash-out statement line -
You only need to select the account to which the money is transferred from the statement line's bank account. (i.e. add debit entry)
Juan will get the credit/debit amount & date from the statement line.
If the cash transfer is between 2 bank accounts of different currencies, Juan 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.
In the 1st line, the debit/credit amount will be automatically added for you, based on the cash-flow direction of the bank statement being reconciled.
Juan will also autofill the account & amount from the statement line. You will need to add balancing entries as required.
Journal currency is also set the same as the statement line currency.
If the statement line is in base currency -
you can add balancing journal entries by selecting any of the base currency accounts.
You can also use non-base currency accounts. To learn how to set exchange rates for a non-base currency account, refer to: Manual Journal Guide
If the statement line is in non-base currency -
You can either create a balanced non-base currency Journal OR change the currency to the base currency & then create. For more details on handling non-base currency journals, refer to: Manual Journal Guide
Note that you cannot partially reconcile a statement line with a journal transaction.
Transactions, payments & adjustment entries can be combined to reconcile a statement line.
However, journal entries & receipts cannot be used in any combinations. They must be reconciled in full.
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.
If the statement line is in base currency, simply add the balancing entries.
If the statement line is in non-base currency, You can modify the exchange rate of the adjustment journal by clicking on the currency ISO in the debit/credit header.
You can have 3 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.
For invoice payments & customer credit refunds, the net amount excludes the fee amount.
For bill payments and supplier credit refunds, the net amount includes the fee 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.
