Bank Genie
Software for Managing Bank Accounts

by Ideas for Gardens.com
User Guide - Applies to Bank Genie 4 and Bank Genie Pro 4
Last updated: 28th February 2018

Click this link to
BUY Bank Genie

Sponsor 1

Sponsor 2

Sponsor 3

Sponsor 4

Sponsor 5

Sponsor 6

Sponsor 7

Sponsor 8

Sponsor 9

Sponsor 10

Index

Introduction

Getting Started

Setting Up

Preferences

User Guide Options

Bank Accounts

Bank Groups

Categories

Category Groups

Tags

Manage Transactions

Standing Orders

Process Standing Orders

Online & Downloads

Transaction Analyser

Net Worth

P&L Years and Groups

P&L Reports

Invoices

Password Protection

Database Protection

Quick Backups

Backups (with history)

Create a New Database

Open another database

Restore

Pack

Importing Data

Broken Transfers

Where is everything?

FAQ

Glossary

Common Controls

Index by Program Name

Acknowledgements

About us

Product support

Sponsored Links

Gardening Software
Ideasforgardens.com

 

 

User Guide
Online Banking (Import Transactions) - Program BS412
Downloading Bank Statements

 

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

  1. When the caption says Go 999997
    Click this button to select Statement Number 999997 for your imported transactions.
  2. 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

Bank Genie User Guide Index            Index by Program Name           BUY Bank Genie