Budgets

Importing your budget

You can import your budget from your accounting software at the same time as you import your actual data. For details of how to complete the import, please refer to our Import section.

Note: To import into Spotlight, the budget values must be held in the overall or main budget.  Additional or tracking budget information currently doesn't import.

If you prefer, you can also edit or enter the budget directly into Spotlight.  For information about how to do this, please refer to the following section.

View and amend budget values

Note: When you amend an imported budget in Spotlight, the new figure is considered to be a revised budget. For information about how this appears on reports, please refer to the next section.

  1. Open the Customise Data tab, then open the tab for the data you want to amend, for example Revenue.
  2. In the data grid, scroll to the right to view the future months.  Cells that contain budgets appear in yellow.

    Note: A future month is any month beyond the current report date. If required, you can change this in the Customise Layout tab.

  3. Enter or amend the required budget figures.

Original and revised budgets

Occasionally, you may need to amend a budget you've imported into Spotlight, but still report on both budgets. To ensure you can do this, if you amend a budget figure that you've imported, Spotlight holds both values:

  • Original budget - This is the budget that you imported into Spotlight. Unless you make manual amendments to the budget values, your budget is the 'original' budget.
  • Revised budget - This is the budget as it currently appears in Spotlight. This includes any manual amendments you made to the budget values.

While the majority of reports and charts show the revised budget as this is the current one, the profit and loss report can show both budgets, depending on the columns you select.

Actual vs Orig Budget

Budget type: Original

comparison of the actual figures for the year to date, against the original imported budget figures. If you've made manual amendments to the budgets, they are not included in this comparison.

Comparisons

Budget type: Original

comparison of the actual figures for the month, two month period or quarter, against the original imported budget figures for the same period. If you've made manual amendments to the budgets, they are not included in this comparison.

Forward Projection Full Year

Budget type: Revised

Projected figures as at the end of the year, based on actual figures to the current month and the revised budget figures for the remaining months of the year. If you've made manual amendments to the budgets, they are included in this area.

Projections Analysis

Budget type: Both

The current projected figures for the end of the year, compared to the original projected figures.

  • <Year> Proj - The total forward projection for the full year, taking into account actuals to the current month and revised budget for the rest of the year.
  • Orig Budget - The original imported budget for the full year.

 

Back to top

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