You can perform account reconciliation in Modern Treasury to resolve the variance between a balance in your ledger and a balance reported by a bank or vendor. Generally, performing account reconciliation is a good way to confirm that you have tracked and attributed all funds within an account.

In Modern Treasury, account reconciliation is performed between an Internal Account (which represents a bank or vendor reported account) and a Ledger Account (which is your internal representation of that account).

Setting Up

If you have Reconciliation and Ledgers enabled, you can connect an Internal Account to a Ledger Account to enable the feature.

To keep your internal ledger in sync with money movement, you should ledger every money movement that passes through the account. You can link Ledger Transactions to Payment Orders that you originate, and you can link Ledger Transactions to Expected Payments in order to reconcile and ledger unoriginated transactions.

Viewing Account Variance

In the Reconciliation Overview page, you can view the variance between the Internal Account Balance and Ledger Account balance.

Clicking on the variance amount shows you the variance calculated for each day that a Balance Report was received for the Internal Account.

Resolving Account Variance

If you want to perform Account Reconciliation for a given reporting day, you can click the table row for that day to navigate to the Reconcile page. On this page, you can view reported transactions for the time period that have not been added to the ledger. Selecting a transaction and clicking on the Reconcile button will allow you to create a Ledger Transaction and Expected Payment corresponding to this transaction, allowing you to bring variance for the reporting period closer to zero.