| | How the reconciliation and statement dates affect the bank reconciliation |
| Resolution | | Reconciliation Date: The G/L cash account balance and C/M transactions included in the reconciliation are based on the Reconciliation date Statement Date: The Statement date is used as the 'cleared' date for transactions. It does two things: - When a check is marked as "cleared", the statement date is posted to the record as the 'cleared' date
- Only those transactions marked as "cleared" in the calendar month of the statement date are included in the reconciliation screen. For example: If the statement date is 12/30/2020, only those transactions that cleared during the month of December 2020 are included in the reconciliation screen
- To find out what date a transactions was cleared with select CM, Transfer, Custom Export and export the transaction number, date and reconciliation date. Once the reconciliation date is found enter the reconciliation with that date and deselect the desired transactions. This will make them available to reconcile on the correct date
- To correct the reconciliation date of the transaction:
- Select CM, Transactions, Reconcile Checking Account. Enter the desired statement and reconciliation date. NOTE: Both the statement date and reconciliation date entered should be the same
- Proceed with the bank reconciliation
[BCB:163:Chat BusinessWorks US:ECB]
|
|