How to Install the Bank Assistant

How to install
  1. For the 'Trader' version, Create a folder on your computer, for example, "C:\My Bank Assistant". For the 'Agency version, create a folder on your computer, for example, "C:\My Bank Assistants", then create a sub folder for each client, for example, "C:\My Bank Assistants\Client 1" etc.
  2. Download the Bank Assistant 'Trial Evaluation' workbook and (move or save) it to the folder you created above. For the Agency version, save a separate workbook to each client folder.
    Note 1: The download process may vary depending upon which Interent browser you use and the browser's configuration.
    Note 2: It is recommended that you store the workbooks within their own folder as certain sub folders are automatically created when each workbook is opened.
  3. Open a blank workbook in Excel then change the Options as described in the 'Excel Configuration' section below. Then exit Excel.
  4. Finally, Open the Bank Assistant workbook and follow the on-screen instructions.

Excel Configuration
Microsoft has taken a much tighter approach to software security. As a result of this, some Excel features are disabled during initial installation. In order for the Bank Assistant to function correctly, a few changes are required within the Excel Options.
Open a blank workbook. (For recent versions of Excel, Click on 'File' menu, then 'Options', then 'Trust Centre' then click on 'Trust Centre Settings').
Note: For Office 2007, Click on the 'Office' button as the 'File' menu does not exist.
  • Trusted Locations: Add the 'Location' of the folder where you saved then Bank Assistant workbook. Also tick the box 'Subfolders'. For example, "C:\My Bank Assistant".
  • Macro Settings: Tick the box 'Trust Access to the VBA project model'.
  • Finally, click on the 'OK' button.

  • Organising Your Files

    Files used and created by this product are organised using a pre-set folder structure. Sub folders are created automatically within the folder where the workbook resides.
    For the Single Trader version: It is recommended that the Bank Assistant workbook is stored in a specific folder. For example, "C:\My Bank Assistant".
    For the Agency version: It is recommended that each 'Client' copy of the Bank Assistant workbook is stored in a separate folder. For example: 'C:\My Bank Assistants\Client 1', 'C:\My Bank Assistants\Client 2' etc

    New Statements Folder: After a new bank statement has been downloaded, move the file to the sub folder "New Statements". The 'Import Statement' routine will inspect this folder.

    Processed Statements Folder: After a new bank statement has been imported, the file will be moved automatically to the sub folder "Processed Statements".

    New Deposit Lists Folder: After a new deposit list has been populated and the money deposited into the bank, move the workbook to the sub folder "New Deposit Lists". The 'Deposit Lists' routine will inspect this folder

    Processed Deposits Lists Folder: After the deposit list has been processed, the workbook will be moved automatically to the sub folder "Processed Deposit Lists".

    Data Backup Folder: Each backup created by the 'Backup Data Tables' routine will be stored in the sub folder "Backup".