Skip to content
logo Knowledgebase
Page Language

How to import a list of transactions using Bank Feeds

Created on  | Last modified on 

Summary

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

Description

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

Resolution

Use Bank Feeds (Recommended)

Set up Bank Feeds
  1. Choose Banking in the navigation pane on the home page.
  2. Right-click the Match Bank Transactions icon and select Match Transactions.
  3. Select Connect to Sage Bank Feeds.
  4. Provide a primary email address for Sage Bank Feeds.
  5. Agree to the Terms and Conditions and click Get Started.
  6. Select or search for the bank.
  7. Enter the banking credentials and choose the account.
  8. Choose a Start date for historical transactions. The system will attempt to download historical transactions as of that date.
  9. Click Process.
Get transactions from the Bank
  1. Choose Banking in the navigation pane on the home page.
  2. Right-click the Match Bank Transactions icon and select Match Transactions.
  3. Click Get Transactions.

NOTE:

Getting transactions is a manual process and won’t occur automatically.

Upload a bank statement to Bank Services

NOTE:

For an existing imported account, Sage 50 prefixes the current bank account with "ARCHIVE". If there are any remaining transactions to match and reconcile with the ARCHIVE account, process them so you can tidy up your accounts.

  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

NOTE:

You can't use Bank Rules with this option. To use Bank Rules, use the Upload to Bank Services option instead.

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.

Related Solutions

How to create Bank Rules

Need more help?

Chat now

 

 

 

 

View More...