Import a Corrected Bank Statement into Sage 50

Sometimes, a statement that you import electronically into Sage 50 is in error and needs to be corrected by the bank. The error could originate either with you or with the bank itself. When this occurs, to make the necessary correction within Account Reconciliation, you will need to import the corrected statement into Sage 50.

As long as the statement is in the current period AND the bank records contained in the statement have not been matched to existing Sage 50 transactions and cleared, you can import the statement again without taking any additional steps. The records from the original bank statement will be replaced by corresponding records in the corrected statement.

For Previously Cleared Bank Records...

However, if the statement contains records that have already been matched to Sage 50 transactions and cleared (either automatically or manually), importing the corrected version of the statement will not update these records. Sage 50 will instead retain the original records and will not replace them with records from the corrected version of the bank statement. To import corrected versions of previously imported and cleared records, you'll need to unclear the records contained in the original bank statement before importing the corrected version of the statement.

Once you've uncleared the records, you can import the corrected statement. As with all imported statements, Sage 50 will try to autoclear the records contained in the statement. If any records remain uncleared, you can do this manually. Tell me how to manually matching bank records to Sage 50 transactions (including information about unclearing incorrectly matched transactions).