Skip to content
logo Knowledgebase

How to process imported bank statements

Created on  | Last modified on 

Resolution

  • Imported transactions that could not be matched to an existing Sage 50 transaction in the selected account are added to the reconciliation list and red-flagged as new bank records.
  • Records may not be matched because the transaction date or reference are different, because the transaction is part of a deposit ticket in Sage 50 but listed individually on the bank statement, or because the transaction does not exist in Sage 50.
  • Most banks only record cash deposits as deposit ticket totals; checks, credit card transactions, transfers, etc. should not be included on deposit tickets.
  • Before proceeding with reconciliation, you should manually match or add the red-flagged transactions.
  1. Go to Tasks, Account Reconciliation
  2. Select the appropriate GL Account
  3. To manually match a red-flagged transaction to an existing Sage 50 transaction, right-click the red-flagged transaction and select Manual Match
  4. Select the corresponding Sage 50 record, then click OK/Next
  5. To add a new transaction, right-click the red-flagged transaction and select Create New, then Account Register, Write Checks, Beginning Transactions or General Journal Entry (as a rule of thumb, receipts and payments should be done as Account Register entries; transfers and bank adjustments/fees should be done as general journal entries)
  6. Repeat Steps 3-5 until all records are matched or added
  7. Manually clear, by checking Status next to the transaction, any uncleared transactions that are on the bank statement
  8. Click OK when done