Available in Sage 50 Premium Accounting and higher.

Import Statement - Choose How You Want to Import Your Statement

How Do I...

This is the first step in the import process. Here, you tell Sage 50 whether you want to connect with your bank and import the statement automatically or select a bank statement already stored on your computer.

Automatically connect to my bank and import a statement

Choose this option to automatically import the statement.

Bank: Use the drop-down list to choose the bank or financial institution you want to import the statement from. The list includes all banks that currently support the transfer of bank statements to Sage 50. Banks/financial institutions will be added to this list on an ongoing basis.

User ID and Password: Enter the ID and password issued to you by your bank for access to electronic banking. For security reasons, the password, when you enter it, will appear as a series of asterisks (*).

Remember my user ID:If you want Sage 50 to recall your user ID each time you reconcile the currently selected account, click the check box. From now on, whenever you import a statement into this account, Sage 50 will automatically fill in your user ID.

Note: Sage 50 remembers IDs by individual user, so if you choose this option, Sage 50 will remember the ID for you only and not other users.

Once the account is chosen, its name and number will appear in the Account field.

After you've entered all needed information, click Import. You will see the Select Account window, where you can select the bank account to import from.

Note: Following the first successful import of a bank statement, an additional button will be available in the window:

Change Account:
Once you have chosen the bank and entered your ID and password, click this button to select a different bank account from which to import a statement. You will see the Select Account window.

Manually select a statement

Choose this option to find and select a statement stored on your computer.

Statement Location: If you know the path where the electronic bank statement is stored, enter it in the text box. Otherwise, use the Browse button to search for and select the statement. Once the statement is selected, its path and file name will appear in the Statement Location box.

Once the account is chosen, its name and number will appear in the Account field.

After you've entered all needed information, click Import. You will see the Select Account window, where you can select the bank account to import from.

Note: Following the successful import of a bank statement, the name and number of the last account you imported from will appear in the Account field. An additional button will be available in the window:

Change Account:
With a statement location entered, click this button to choose a different bank account from which to import a statement. You will see the Select Account window.

What do you want to do next?