|
Starting the program
On the Main Menu, click the Transactions tab then click:
On-line Banking Transactions - BS412
The initial screen BS412S01 shows your Main Bank selected in the Bank Name pop-up.
Screenshot
In this section
- About the program
- Creating a link to your Bank (optional)
- About Downloading Statements
- About Downloads and Date formats
- Saving your downloaded Bank Statements
- Importing transactions from your Downloaded Statements
- Screens (leading to screenshots) for program BS412
About the program
This program allows you to import transactions from downloaded statements
The program does not connect to your Bank directly.
Instead, you enter a link (URL) to your Bank and click the link to visit.
A data region allows you to store information, like Username and Password (or password reminder)
Screenshot
When on-line, download your statement(s) and save the file in a folder on your computer.
The program allows you to import transactions from any QIF file or from a range of known csv file formats.
The imported transactions can then be viewed elsewhere in Bank Genie.
e.g. you can view and edit (if necessary) using the Manage Transactions program.
Creating a link to your Bank (Optional)
For your convenience, enter information as required in the Notes about this Bank field and in the Web Address for this Bank field.
A Save Changes button becomes visible when you start to type (otherwise this button is hidden).
Use the fields to enter web addresses and reminders of passwords.
The data fields are linked to whichever Bank account is selected.
About Downloading Bank Statements
To go online with your Bank, set up the URL and click on a link in screen BS412S01
Screenshot
Download a QIF format file if your bank offers this option.
The QIF file format is a universal standard, so this download option is preferred.
If QIF file format is not offered, choose a csv file format.
csv files are not standard - every Bank appears to set their own standards.
Bank Genie offers a number of options to deal with Banks used by our users.
If your Bank is not listed, please get in touch and we will work with you to add to the list.
About Downloads and Date formats
Banks may offer alternative formats for downloading.
e.g. dd/mm/yy, dd/mm/ccyy, mm/dd/yy, mm/dd/ccyy
Bank Genie can cope with any option you choose, in one single button.
However, in some cases, the Bank Genie decision making is based on the Date Format you have configured in your preferences (i.e. in Preferences BS498).
Thus, if you have set your Date Format to a dd/mm/yy style in Preferences choose a dd/mm/ type download.
In US, you should set your Date Format to a mm/dd/yy style in
Preferences and choose a mm/dd type download.
Saving your Downloaded Statement
- QIF Files:
Save downloaded QIF files in any folder
- csv files
The files MUST be saved in a Path which includes one of the name on the Processing Buttons, anywhere in the path.
Screenshot
Example:
The following is a valid path for all “flavours” of Barclay csv imports to work
c:\downloads\barclay\2004\statement_may.csv
because it contains the name barclay in the path.
The test to find the embedded name (Barclay in this case) is NOT case sensitive.
Make sure you know how to find the file again.
Importing transactions from your Downloaded Statements
Click the Get Downloaded File Button
A windows dialog box appears allowing you to select a file
Screenshot
Select the required downloaded file and click OK
Bank Genie scans the file path and file name of the selected file.
QIF Files
To Import a QIF file simply click the QIF button
Screen BS412S02 will appear
To continue, please see the User Guide for screen BS412S02.
CSV files
If Bank Genie finds the name of one of
the Processing Buttons (at the bottom of the screen) within the string then the matching Processing button is Enabled.
In the case of Barclay, three Barclay buttons will be enabled.
Screenshot (for Barclay)
For your first import, try each one to determine which one works for the type of
Barclay csv file which you have downloaded
Click the appropriate button.
Screen BS412S02 will appear
To continue, please see the User Guide for screen BS412S02.
Screens (leading to screenshots) for program BS412
- BS412S01 - The initial screen - This page
- Screen BS412S02
|
