How to import a list of transactions using Bank Feeds

Set up and import bank transaction data into Sage 50 Accounting using Bank Feeds, Bank Services, or the Import Statement feature.

Sage 50 offers several methods to import a list of transactions from your bank to reconcile with:

• Bank Feeds: Automatically connect and sync transactions directly from your bank
• Bank Services: Upload and import bank statements in CSV or OFX format
• Manual Import: Manually import the statement if needed

Use Bank Feeds (Recommended)

Upload a bank statement to Bank Services

1. Go to Banking on the navigation pane in the home menu.
2. Choose the Match Bank Transactions icon in the tasks pane.
3. Select Upload to Bank Services.
4. Choose a New or Existing Bank Account and fill in the details.
5. Select the CSV or OFX file type.
6. Click Select File and find the bank statement file on your computer. Choose Open to add the bank statement.
7. Select the date format used in the file. For example, Day, month, year, or Month, day, year. Use the Year, month, and day format when uploading an OFX file.
8. Enter a comment for the upload and click Upload file.
9. Begin verifying transactions either money in or money out of the account.
10. Review the transactions. Go back to the Verify screen if there are discrepancies.
11. Select Import transactions. This imports the transactions into your cloud bank account.
12. Click Get Transactions in the Match Transactions window to bring the transactions into Sage 50.

---

Import using an OFX Statement

Set Up the Linked Accounts

1. Go to Setup, Settings, General (Accounts), Linked Accounts and choose a linked account for the charges and income fields.
2. Download the bank statement from the bank website for the period you're reconciling using Sage 50, Simply, or OFX format.

Import the OFX Statement

1. Go to File, Import / Export, Import Online Statements from the main menu of Sage 50.
2. Follow the prompts on the screen to import the file downloaded from the bank. Sage 50 will attempt to match all the transactions with the same dates and amounts and then provide a list of unmatched transactions.
3. Click Find Match for unmatched transactions.
   1. Place a checkmark in the first column for anything that matches.
   2. Create a new transaction for any that don’t match.
4. Select OK.

How to create Bank Rules