Previously Match Bank Data and Account Transactions From Previous Bank Reconciliation Become Unmatched

Scenario

When Account Transactions is edited or voided, Match Group to where the edited transaction belong automatically become unmatched and these transactions will be showing on the To Be Match tab of Match Bank Data page.

Solution

Match these transactions without impact on the balances since Bank Statement Balance and GL Balances are reconciled.

1.  Check previous periods reconciliation differences
1. Edit account setting
1. Navigate to List > Accounting > Accounts
2. Search for the Account
3. Click Edit
4. Use Match Bank Data & Reconcile Account Statement Pages: Remove Checkmark
5. Click Save
2. View Reconciliation History
1. Navigate to Transactions > Bank > Reconcile Bank Statement
2. Account: Select Account
3. Click History
   Note: The difference on the Reconciliation History Page should be equal to the unmatched transactions that was previously matched.
2. Create a Reconciliation that will zero-out the difference
1. Edit account setting
1. Navigate to List > Accounting > Accounts
2. Search for the Account
3. Click Edit
4. Use Match Bank Data and Reconcile Account Statement Pages: Enter Checkmark
5. Click Save
2.  Re match transactions
1. Navigate to Transactions > Bank > Match Bank Data
2. Account: Select Account
3. Click Excluded tab
4. Imported Bank Data: Enter Checkmark
5. Click Restore
6. Click To Be Matched tab
7. On the Account Transactions, filter transaction date
8. Enter checkmark(s) for the Bank Data and Account Transactions
   Note: Match difference should be 0.00.
9. Click Match
10. Click Submit
3. Reconcile Account Statement
1. Navigate to Transactions > Bank > Reconcile Account Statement
2. Account: Select Account
3. Statement Date : Enter Date
4. Ending Statement Balance: Enter Bank Statement Balance
   Note: This amount should be the same as the Previous Reconciled Balance.
5. Click Reconcile tab
6. Match Group: Enter Checkmark
   Note: Select Match Group submitted in step# 2. Reconciled This statement should be equal to difference multiplied by negative 1 (-1) to zero-out.
7. Click Reconcile