Add and edit a Profit and Loss rule

Spotlight Forecasting lets you add payment timing rules to your Forecast's Profit and Loss accounts either on a group or an individual basis.

Elsewhere in Help Centre:

About the Profit and Loss
Edit the Wages rule
Edit the Income Tax expense rule
Edit and delete a rule
Reassign a rule to a different account

Add a Profit and Loss rule

To apply customised payment terms for an individual account, or a group of accounts add a Profit and Loss rule to selected accounts within your Forecasts, follow these steps:

  1. From the Customise Data tab click the Profit and Loss tab and expand the applicable account category.
  2. Click Profit & Loss Rules.
  3. Click on Profit and Loss rules in blue and then select Add New Rule in green 
  4. Name your rule.
  5. Select the type of rule you want from the Rule Type dropdown menu.
    Revenue: Add a Revenue rule.
    Cost of Sales: Add a Expense or Direct Wages rule.
    Expense: Add an Expense or Wages rule.
    Net Profit and Tax Expense: Add an Expense or Wages rule.
  6. Select the account(s) to apply your rule to from the Select Accounts dropdown menu.
  7. Payment schedule: Enter the timing of payments profile that best reflects when the Revenue or expenses will touch your bank account for the accounts you have selected. Enter up to 100% in the fields, for example, 60% ‘Current’ and 40% ‘+ 30 Days’.
  8. Click Next.
  9. If required, add a note.
  10. Save Rule.

Edit a Profit and Loss default rule

Spotlight Forecasting provides default rules for your Forecast's Profit and Loss (default rules are coloured blue). Default rules contain a payment profile for applicable accounts. View and edit these default rules at any time.

  1. From the Customise Data tab click the Profit and Loss tab and expand the required account category, for example, Revenue.
  2. Click the default rule button in your account category header, for example REV.TRA where you can see what accounts this rule is being applied to.
  3. Payment profile: Enter the timing of payments that best reflects the accounts selected. Enter up to 100% in the fields, for example, 60% ‘Current’ and 40% ‘+ 30 Days’.
  4. Click Next.
  5. If required, add a note.
  6. Save Rule.
Still need help?
Get in touch!