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 save to the folder you created. For the Agency version, save a separate workbook to each client folder.
  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 path of the folder where you saved then Bank Assistant workbook. Also tick the box 'Subfolders'.
  • 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".