Forecast Schedules

With the Forecast Schedules option, you can select and set up schedules to accurately reflect when sales tax, payroll deductions and other employer taxes are paid. 

To set up a new schedule

  1. From the main Spotlight screen, open the Practice Settings drop-down list, then click Forecast Schedules.

    schedules practice settings2
  2. Choose the region for which you want to create a new schedule.

    schedules regions
  3. Click Create New Schedule, then enter a name for your new schedule.
  4. From the Payment Month column, choose the month in which each activity month should be paid.
  5. To save the schedule, click Create New Schedule.

To apply a schedule to your forecast

Note: The schedules available depend on the currency settings for the organisation. 

For a new organisation

You can select the required schedules within the settings available when you create your forecast.  Once you've done this, the payment automatically calculates based on your schedule.  You can view the calculated payments, and make adjustments if required, using the relevant balance sheet rule.

For an existing organisation

If your organisation already exists in Spotlight, to apply the new schedules there are several steps.

Select the required schedules

  1. Open the forecast, then click Show Settings.
  2. In the Forecast Settings area, from each drop-down list choose the relevant schedule.
  3. To save the changes, click Save and Continue.

Apply the new wages rule

  1. Within the forecast, open the Profit and Loss tab and locate your wages account.
  2. Click Add Rule then enter a name for the new rule, for example 'Wages - New'.
  3. From the Rule Type drop-down list, choose Wages.
  4. From the Select Accounts to Apply Rule To drop-down list, choose your wages account.
  5. Enter the required settings and save the new rule.  For information about the options available, please refer to our separate article.

Apply the new PAYE, PAYG or employee payroll taxes rule

  1. Within the forecast, open the Balance Sheet tab and then open the Current Liabilities section.
  2. Click Add Rule then enter a name for the new rule.
  3. From the Rule Type drop-down list choose the relevant rule.

    Note: The name of this rule depends on the currency set for your organisation.

  4. From the Select Accounts to Apply Rule To drop-down list, choose your payroll taxes account (for example PAYE or PAYG).
  5. Click Next, then click Save Rule.

Apply the new Superannuation, Kiwisaver Employer, NI or employer payroll taxes rule

  1. Within the forecast, open the Balance Sheet tab and then open the Current Liabilities section.
  2. Click Add Rule then enter a name for the new rule.
  3. From the Rule Type drop-down list choose the relevant rule.

    Note: The name of this rule depends on the currency set for your organisation.

  4. From the Select Accounts to Apply Rule To drop-down list, choose your employer payroll taxes account (for example Superannuation or KiwiSaver Employer, NI).
  5. Click Next, then click Save Rule.

The default schedules available

There are several regions available in the Forecast Schedules area. When you create an organisation in Spotlight Forecasting, the schedules available are dependent on the currency setting for that organisation. There are four regions available.

Note: The default schedules are based on the most common options for each region. If you don't see the schedule you need, you can create your own.

New Zealand

Type Schedule name Description
GST 1 Month GST due on a monthly basis. Payment is recorded in the month after the activity, with the exception of March (due in May) and November (due in January).
GST 2 Month GST due on a two monthly basis. Payment is recorded in the month after the second of the two months, with the exception of February-March (due in May) and October-November (due in January).
GST 6 Month GST due on a six monthly basis. Payment is recorded for months April-September in October, and months October-March in May.
PAYE Monthly PAYE due on a monthly basis. Payment is recorded in the month after the activity.
KiwiSaver Employer Monthly Kiwisaver Employer payments due on a monthly basis. Payment is recorded in the month after the activity.

Australia

Type Schedule name Description
GST 1 Month GST due on a monthly basis. Payment is recorded in the month after the activity.
GST Quarterly - Business GST due on a calendar quarterly basis. Payment is recorded in the month after the quarter closes, with the exception of October-December (due in February).
GST Quarterly - Agent GST due on a calendar quarterly basis. Payment is recorded in the second month after the quarter closes.
PAYG Monthly (Paid alongside Monthly GST) PAYG due on a monthly basis. Payment is recorded in the month after the activity.
PAYG Monthly (Paid alongside Quarterly GST) PAYG due monthly, but with payments aligned to quarterly GST. Payment is recorded in the month after activity, with the exception of March (due in May), May (due in July) and September (due in November).
PAYG Quarterly - Business PAYG due on a calendar quarterly basis. Payment is recorded in the month after the quarter closes, with the exception of October-December (due in February).
PAYG Quarterly - Agent PAYG due on a calendar quarterly basis. Payment is recorded in the second month after the quarter closes.
Superannuation Quarterly Superannuation due on a calendar quarterly basis. Payment is recorded in the month after the quarter closes.

United Kingdom

Type Schedule name Description
VAT Monthly VAT due on a monthly basis. Payment is recorded in the second month after the activity.
VAT Quarterly VAT due on a calendar quarterly basis. Payment is recorded in the second month after the quarter closes.
PAYE Monthly PAYE due on a monthly basis. Payment is recorded in the month after the activity.
National Insurance Monthly NI due on a monthly basis. Payment is recorded in the month after the activity.

Other

Note: The settings in this area are used for any region not specified above. While the schedule names are generic, you can set up specific schedules for your region and apply them as appropriate.

Type Schedule name Description
Sales Tax 1 Month Sales tax due on a monthly basis. Payment is recorded in the month after the activity.
Sales Tax 2 Month Sales tax due on a two monthly basis. Payment is recorded in the month after the second of the two months.
Sales Tax 6 Month Sales tax due on a six monthly basis. Payment is recorded for months April-September in October, and months October-March in May.
Payroll Taxes Monthly Payroll taxes due on a monthly basis. Payment is recorded in the month after the activity.
Employer Taxes Monthly Employer tax payments due on a monthly basis. Payment is recorded in the month after the activity.

 

Back to top

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