Bank Rule

When you import bank accounts to Spotlight Forecasting, they are automatically assigned the default bank rule. Although each bank rule looks the same, you can edit each one individually. You can use this to define which account is your main bank account for payments and receipts, and set any overdraft rates.

Set the default bank account

When you set one of your bank accounts as the default, all cash journals and movements post to this default account.

  1. Within the forecast, open the Balance Sheet tab.
  2. Open the Current Assets section, then locate the bank account you'd like to edit.
  3. Click the Bank rule button alongside the account.

    Note: All bank accounts have a distinct Bank rule button beside the account name.

  4. To set this as the default bank account, select the 'Use this bank account as the default account for all rules’ check box.
  5. Click Next, then click Next again.  
  6. If required, add a note, then click Save Rule.

Set up an overdraft interest rate

You can set up the overdraft interest rate so that the interest expense automatically calculates on a bank account that goes into overdraft. 

  1. Within the forecast, open the Balance Sheet tab.
  2. Open the Current Assets section, then locate the bank account you'd like to edit.
  3. Click the Bank rule button alongside the account.

    Note: All bank accounts have a distinct Bank rule button beside the account name.

  4. In the Overdraft Rate (%) box, enter the interest percentage rate.

    Note: Interest expense will appear in the Profit and Loss against the Interest Expense account.  Once an interest rate is entered interest will automatically calculate if the bank account is overdrawn.  

  5. Click Next, then click Next again.  
  6. If required, add a note, then click Save Rule.

Release Notes - Terms of Use - Privacy Policy - Launch Application - Copyright © Spotlight Reporting 2017