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 BS412S01-1
In this section
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 BS421S01-1 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. Screenshot BS421S01-1 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.
The Go 999997/Go Last button This is a toggle
button. The caption on the button changes when clicked See Screenshot BS412S01-3
- When the caption says Go 999997
Click this button to select Statement Number 999997 for
your imported transactions.
- When the caption says Go Last
Click this button to allow Bank Genie to find and use the
last UNRECONCILED Statement for your imported transactions (this is the default and recommended setting)
More info: When you select a Bank Name, Bank Genie automatically finds the last unreconciled statement
number You can override this selection if you prefer to have your transactions imported to the 999997 statement.
Statement Number 999997 is an imaginary
statement which is required by Bank Genie. It is always the very last statement number in any account in Bank Genie, and is used for keeping transactions which
are not to be included in the latest REAL statement which you are reconciling.
Default text for SPENT ON You can modify this text. Screenshot BS412S01-4 Click the
Clear button if you'd like the field to be blank after import. Or, you can enter any text you'd like for the default Spent On entry.
More
info: When you add or edit a transaction manually using the program BS421, you will be familiar with the Spent on field. Thats where you enter a brief
description of the expenditure.
When you process a downloaded file, Bank Genie looks at the Payee (Paid to/Received from) details of each transaction being
imported. If it finds a KNOWN Payee in your previous transactions, and youve categoried that previous spending, then Bank Genie can automatically code the Category
for you when importing downloaded data (see the Help for Autocode). The Spent on field is automatically filled with the details form your previous
records.
If a new Payee is found in the imported data (the Payee name must compare exactly to be a match - slightly different spelling will cause a
mismatch) then the program will fill the Spent on field with default text.
The default text is: To be defined. Auto Entry
About Downloading Bank Statements To go
online with your Bank, set up the URL and click on a link in screen BS412S01 Screenshot BS412S01-1 Download an OFX or a
QIF format file if your bank offers this option. The OFX and QIF file formats are a universal standard, so either of these two download options are preferred. If
OFX or QIF file formats are 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.
Paypal:- Instructions for downloading a statement from your PAYPAL account are explained in the help page for screen BS412S03.
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
- OFX Files:
Save downloaded OFX files in any folder
-
QIF Files:
Save downloaded QIF files in any folder
- csv files
By default, all the buttons for csv file import are disabled. Bank Genie enables the appropriate button
when a known name is found in the folder path. Thus, csv files MUST be saved in a folder Path which includes one of the names on the
Processing Buttons, anywhere in the path. Screenshot BS412S01-2 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. Bank Genie does a test to find the embedded name (Barclay in this case). This is NOT case sensitive.
- Paypal files
This section explains how to download a file from your Paypal account and specifies the type of file expected by Bank Genie. Option 1:- Save your downloaded Paypal files in a folder path which includes the word Paypal. Example:- c:\downloads\paypal\download.csv Option 2:- Save your
downloaded Paypal file in any folder. In this case, when you click Get downloaded file (next section)
Bank Genie will show a warning message:- File name does not contain a folder name to match the name on any buttons. To
eliminate this message, use Option 1.
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 BS412-Select Select the required
downloaded file and click OK Bank Genie scans the file path and file name of the selected file.
OFX Files
If you have selected an OFX file in Get Downloaded File above, simply click the OFX button Screen BS412S02 will appear. Screenshot BS412S02-1 This
is a staging screen. You can view the transactions and make sure everything is correct before proceeding with the import. To finish the import, click the
Process button as shown in this screenshot Screenshot BS412S02-1
QIF Files
If you have selected a QIF file in Get Downloaded File above, simply click the QIF button Screen BS412S02 will appear Screenshot BS412S02-1 This
is a staging screen. You can view the transactions and make sure everything is correct before proceeding with the import. To finish the import, click the
Process button as shown in this screenshot Screenshot BS412S02-1
CSV files
If you have selected a csv file in Get Downloaded File
above, Bank Genie scans the file path looking for text to match one (or more) of the captions in the bank of processing buttons (at the bottom of the screen). If a match is found then the appropriate Processing button is Enabled.
In the case of Barclay (an unusual case) three Barclay buttons will be enabled. Screenshot BS412S01-2 (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 Screenshot BS412S02-1 This is a staging screen. You can view the transactions and make sure everything is correct before
proceeding with the import. To finish the import, click the Process button as shown in this screenshot Screenshot BS412S02-1
Paypal transaction files Refer to the help for screen BS421S03 for importing data from Paypal Unlike the other import procedures described above, Bank Genie allows you to link transactions to Categories before processing Paypal files.
Manually entering the name of a downloaded file
As an alternative to using the Get Downloaded File
method above, you can manually enter a file name for processing. Refer to Screenshot BS412S01-5
Screens (leading to screenshots) for program BS412
|