Budget Report - V6

 

This article is intended for clients on Decision Logic’s V6 web and mobile application.

Reports > Cost and Variance > Budget Report

Budget Report Overview

Budget Reporting is used to compare the Actual amounts to Budgeted amounts and percentages.

The difference between the Actual amount and the Budgeted amount will report as the Budget Variance. Clients can configure the budget report to include all expenses from Cost of Goods, Labor, rent, equipment, payroll, maintenance, or supplies.

Additionally, clients can configure any field, calculation, or group of fields from the DSR, POS Admin, PPC Account, IUT, or Weekly Budget Field.

Store Level Users

The Budget Report can be used to track Actual vs. Budgeted Sales, Purchase Costs, and Labor. The report helps to identify:

  • When cuts should be made to increase profitability

  • Which controllable costs are most impactful

  • Where entry errors might exist to improve accuracy

Above Store Level Users

Group, Area, Region, and Territory management commonly uses the Budget Report to determine:

  • Bonuses for store managers

  • Group, Region, and Company trajectories

  • Which cost areas are over/under budget to address

    • menu structure and pricing

    • future budget values

    • resource allocation


 

Getting Started

Below is a quick step-by-step guide on how to run a Budget Report inside Decision Logic’s platform from your web browser.

Run Budget Report

To run a budget report, you will need to select the parameters.

  1. Select the Company, Region, Area, or Store for which you wish to view the Budget Report

  2. Choose the Calendar that applies to the desired store(s) for the desired date range
    a. The Calendar that is selected by default is the most recent Calendar applicable for the selected store(s)
    b. The alternative Calendar options available are those where at least one selected store is currently or previously assigned.
    This allows viewing historical budget reporting for date ranges before a store changed to a new calendar.
    c. The Basic Fiscal Calendar is always available as a baseline option when selecting a Company, Area, or Region with stores with differing Calendars.

  3. Choose the Budget Report you want to view
    If a Company, Area, or Region is selected, the results will be only for the stores assigned to the selected Report through Budget Maintenance. For example, if there are 5 stores in the region and only 4 stores are assigned to the chosen budget report, only four stores are displayed.

  4. Choose the Selected Calendar based on the Year, Period, and Week you wish to view the Budget Report.

  5. Select Apply!

 



Viewing the Report

After changing any of the parameters, you must click Apply again. Selecting 'apply' will refresh the report using the updated store(s), calendar, report, and/or date selections.


Column Definitions

Name

Definition

PTD

Period-To-Date

Period

Refers to the currently selected and displayed date range.

P# W#

The individual Period-Weeks follow these in the PTD selection.
The percentages shown below the PW Actual values are using the section divisor established in Budget Maintenance.

Period Budget

Sum of budgeted values for the selected date range.

Weekly Budget

Average of budgeted values for the selected date range.
For example: (P1W2 + P1W3 + P1W4) / 3 weeks

$ Var

PTD Total minus Period Budget (PTD Total - Period Budget)

% Var

$ Var divided by Period Budget ($ Var / Period Budget)

Process Budget

 

The Budget Report will auto-update/aggregate daily to account for any new or changed data within the past 3 days.

Selecting the Process Budget checkbox before selecting Apply will re-aggregate the data and calculations for the Budget Report and ensure that it displays the most up-to-date information for the selected date range.

This will account for any changes made regarding new or changed:

  • POS Data and POS Admin mapping
    ex. sales, labor, payments, discounts, etc

  • Orders, Invoices, Inventories
    ex. COGS, dates, quantities/counts, costs, etc

  • Budget Maintenance
    ex. structure, sections, fields, calculations

  • Budget Entry values

 


 

 

 

Unable to access this feature in the Decision Logic platform?

  • Contact your Decision Logic Administrator to make Scope and Security adjustments to your user profile and/or add new features.

  • Some features are client-specific.