Available in Sage 50 Premium Accounting and higher.

Manually Match an Imported Bank Record to a Sage 50 Transaction

When you import an electronic bank statement into Sage 50, the records making up the statement are matched to existing Sage 50 transactions. If any matches are made, the matching transactions are listed as autocleared in the list at the middle of the Account Reconciliation window. Any records that cannot be matched are listed as new bank record. Before you can reconcile the account, you will need to manually match these bank records to existing Sage 50 records and clear them. Follow these steps:

From the Tasks menu, select Account Reconciliation.

The Account Reconciliation window appears.

In the Account to Reconcile field, select the appropriate GL account. To display a list of existing accounts, type ? in the field, or select the Lookup button.

Sage 50 tries to match and autoclear any imported bank records; any unmatched records appear as new bank records in the list at the middle of the window.

To clear these new records, select the first one in the list, and then click the right mouse button to see the right-click menu. Alternatively, you can select the Banking button in the toolbar or use the Quick Action buttons.
From the menu, select Manual Match.

The Manual Matching window appears. It lists all existing Sage 50 transactions that have the same dollar amount as the bank record. (If noSage 50 transactions are found with a matching amount, you'll see a message to that effect.)

In the list at the center of the window, find the Sage 50 transaction, if any, that corresponds to the bank record, and click the Select option button in the appropriate row. If none of the transactions seems to be a match, click the Skip this record option.
To match the next unmatched record in the Account Reconciliation window, click the OK/Next button. A new unmatched record appears in the Manual Matching window along with existing Sage 50 transactions that might correspond to it.
Repeat steps 5 and 6 for each remaining unmatched bank record. Sage 50 will tell you when there are no more records to match.
When finished matching, click OK to close the window and return to the Account Reconciliation window.

Important! If an imported bank record is incorrectly matched to an existing Sage 50 transaction, you can "unclear" it and then manually match it to the correct transaction. (Unclearing bank records will be necessary, for example, before importing a corrected bank statement into Sage 50.) Just select it in the list, and click the right mouse button. Notice that the right-click menu offers Clear and Manual Match options.

To remove the match made between these two transactions, select the Clear option. Then, to match the bank record to its actual corresponding Sage 50 transaction, select the Manual Match option. The Manual Matching window will appear, and you can make the correct match as described in steps 5 through 8 above.

Manually Match an Imported Bank Record to a Sage 50 Transaction

What do you want to do next?