The Reconciliation Statuses in the Payment Reconciliation Journal
The status field on the Bank Account Reconciliation line keeps users informed about the status of each line, with color-coded statuses providing a quick visual guide to the state of each reconciliation. Users can easily identify and manage reconciliations, and access the Payment Application Review page through the Reconciliation Status field for a detailed review.
This article lists the possible statuses in the Payment Reconciliation Journal. If you are looking for the statuses in the Bank Account Reconciliation Journal, refer to the dedicated article.
| Status | Description | Action |
|---|---|---|
| Unsolved (Red and in bold) | No direct match found. This can be due to automatic matching not being done, not finding any payment application proposals, or the lines being unapplied by the user. | Resolving a line with status Unsolved, requires some manual work:
|
| Pending Journal (Yellow) | When a payment application proposal is generated and applied, it triggers the creation of a journal line in the Cash Receipt Journal. This serves a dual purpose: first, to post the payment and close the associated ledger entry, and second, to register the payment in the relevant bank account. Consequently, this process generates a Bank Account Ledger Entry that is automatically reconciled upon journal posting. In situations where no direct match is found, bank statement lines are presented with reconciliation suggestions based on outstanding customer, vendor, or employee payments. To streamline the reconciliation of Bank Account Ledger Entries, a dedicated Cash Receipt Journal is linked to Bank Account Reconciliation. This setup ensures that any payment application proposal not directly associated with a Bank Account Ledger Entry generates a corresponding journal line in the Cash Receipt Journal. This specialized journal configuration is specifically designed for Bank Account Reconciliation purposes. Notably, this reconciliation method supports various journal types, including General, Cash Receipt, and Payment journals. To implement this setup, users can configure it either on the bank account card or on the general Bank Import Setup page. | Resolving a line with the status Pending journal comes with proposals found by the system. To resolve a line with this status:
|
| Related Party Matched (Blue) | Transactions are partially matched but need further investigation. The system identified an account (customer, vendor, or employee) but couldn't find corresponding ledger entries. | For lines with the status Related Party Matched, the system couldn't find a matching ledger entry but did find the origin of the payment. For manually applying entries, you can open the Apply Ledger Entries page directly, or open the Payment Application Review page and use the Apply Entries action |
| Review Proposals (Yellow) | Payment application proposals were generated but couldn't be automatically applied due to discrepancies in amounts. The user needs to review and manually allocate the payments. To make the matching process more efficient, you can specify a tolerance amount for automatic matching of Payment Application Proposals. See the Importing bank statements article for more information. | For lines with the status Review Proposals, the system found a matching ledger entry, but the amount is not the same. To resolve a line with this status
|
| Completed (Green and in bold) | The processing of the lines has been completed, and a successful match has been identified, indicating that the line is ready for posting. However, the way this status operates varies based on the statement type. In Bank Account Reconciliation, a line achieves the completed status when one or more Bank Account Ledger Entries have been successfully reconciled. If a payment application proposal is discovered and applied, the corresponding journal line must be posted before automatic reconciliation occurs, transitioning the status to "completed." In Payment Reconciliation, the status switches to "completed" immediately after the payment application is successfully applied. | No action is required, the status Completed signifies the conclusion of the reconciliation process for the specific line, confirming that the records are now balanced and accurate. |
| Search Rule Invalid (Yellow) | A Search Rule matched with the Bank Account Reconciliation Line is missing an Account No. The user is notified on the Payment Application Review Page and Search Rules pages to correct this. | Open the invalid Search Rule and correct the missing information. Re-run the reconciliation process. |
| Search Rule Matched (Yellow) | A Search Rule matched with the Bank Account Reconciliation Line correctly, assigning values to the Account Type and Account No. fields. | In the Payment Reconciliation Journal No action required unless further manual review is necessary. |
| Difference (Red) | Indicates that there is an unresolved amount discrepancy in the line. | Possible actions are:
|