Manage Exceptions

If auto-matching is still processing, when you click on the Manage Exceptions tab, the screen will be locked and you will see the following message.

Filters

When you select an bank transaction exception, all ledger transactions that are available to match to the bank transaction will be displayed at the bottom of the screen. Finlee will search the ledger transactions for suggested matches and, if suggested transactions are identified, they will be displayed first in the list. If you need to search for ledger transactions, you can use the filter options and select Apply Filters. Three dots on the filters indicate that no filter value has been chosen for that column. A check mark indicates that a filter value has been chosen for that column. Turning on Retain Filters before clicking Apply Filters will retain the current filters after the transaction is matched. Click Clear Filters to remove all filters.

There are several options to handle bank statement exceptions:

Match Transaction

If the bank transactions matches one or more ledger transactions for the same bank account, use this option.

Choose the bank transaction then select the matching transaction(s) from the available ledger transactions listed below. You can narrow down the ledger transactions shown by using the filter options and selecting Apply Filters. Three dots on the filters indicate that no filter value has been chosen for that column. A check mark indicates that a filter value has been chosen for that column.

Once you select one or more matching transactions, as long as the dollar amount of the bank transaction matches the total of the ledger transaction(s) selected, you can then click Match in the bottom right corner of the screen to associate the transactions.

Add Transaction

If the bank transaction is not posted to the ledger, use this option. Choose the bank transaction, then click Add Transaction. Based on the information in the bank transaction, some fields will be populated. You can populate the remaining applicable fields prior to adding the transaction to the ledger. If you would like a card added to the kanban board to be managed in the workflow management process, check the Reconciling Item?" box. From there you will be prompted to choose a Reconciling Item type. These types are customizable to your service bureau. If you would like to add or change your Reconciling Item type list, please contact support@rakedigital.com.

Once you have filled in the applicable fields, click Save. The transactions will then be auto-matched.

Split Transaction

If the bank transaction is a partial match to an existing ledger transaction, use this option.

Choose the bank transaction then select the matching transaction from the available ledger transactions listed below. You can narrow down the ledger transactions shown using the filter options. When you check the box to the left of the ledger transaction, a "Split" option will appear on the row to the right of the Details column.

When you click on Split, a screen will pop up that contains two transactions. Some fields will auto-populate based on the information in the bank transaction. The transaction on the left will have the amount of the bank statement exception that you are working on. The transaction on the right will have an amount equal to the difference between the bank transaction and the original ledger transaction. You can populate or change the remaining applicable fields prior to adding the transaction to the ledger. For example, if a check cleared for an incorrect amount, the new transaction will have a Transaction Type of Check Paid. You may want to update that so that the split transaction isn't included in a subsequent positive pay file.

If you would like to add either transaction as a card on the kanban board to be managed in the workflow management process, check the "Reconciling Item?" box. From there you will be prompted to choose a Reconciling Item type. These types are customizable to your service bureau. If you would like to add or change your Reconciling Item type list, please contact support@rakedigital.com.

Once you have filled in the applicable fields, click Save. The single ledger transaction will now show as two individual transactions in the ledger. You can then click Match in the bottom right corner of the screen to associate the transactions.

Once all of your bank file exceptions are matched, you are ready to move to the Reconcile tab.

Auto-Match

You can manually start the Auto-Match process by clicking the Auto-Match button on the Manage Exceptions tab.