How to Install the Bank Assistant

How to install
  1. For a single Bank Account use, Create a folder on your computer, for example, "C:\My Bank Assistant". For multiple Bank Accounts, create a folder on your computer, for example, "C:\My Bank Assistants", then create a sub folder for each Business/Bank Account, for example, "C:\My Bank Assistants\ABC Ltd - Account 12345678" etc.
  2. Download the Bank Assistant 'Trial Evaluation' workbook and (move or save) it to the folder you created above. If you have multiple Bank Accounts, save a separate workbook to each 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 a single Bank Account: It is recommended that the Bank Assistant workbook is stored in a specific folder. For example, "C:\My Bank Assistant".
    For multiple Businesses / Bank Accounts: It is recommended that each copy of the Bank Assistant workbook is stored in a separate folder. For example: 'C:\My Bank Assistants\ABC Ltd - Account 12345678', 'C:\My Bank Assistants\XYZ Ltd - Account 12345679' 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".