Budget Report Maintenance

Decision Logic’s Active Budget Control or Declining Budget allows you to design multiple customized budgets that automatically update as a result of the daily procedures performed for each store in Decision Logic. 

Budget Features:

  • Import different Budgets by Store
  • Adjust Weekly Budgeted Amounts
  • Create Multiple Budgets with different calculations 
  • PDF View
  • Export to Excel
  • Track Performance as data is entered into Decision Logic
  • View Store, Area, or Company Actuals compared to Budget
  • Display Variance in $ or %
  • Customize all Fields and Calculations 

Table of Contents

For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Help Center.

All training videos are located in the /wiki/spaces/CKB/pages/1121779733

Sample Reports

Budget Report V5

  • Once a budget template is configured in Budget Maintenance navigate to Reports > Cost and Variance > Budget Report 

Period Budget V5

(info) Clients on Decision Logic V5 will have access to a Period Budget once a report is built in Budget Maintenance 

  • This view reports the actuals in columns for each week in the period 
  • PTD Total as the total actuals for the period selected 
  • Period Budget 
  • Weekly Budget 
  • $ Var a
  • % Var

 Budget Report V6

(info) Similar to Period Budget V5 this version is accessible to clients who have updated to Decision Logic V6. see Budget Report - V6 for more information. 



To configure and customize the Budget Report, navigate to Maintenance > Active Budget Control > Budget Maintenance.


Creating Sections

The Sections tab is used to create the headers that will be used in your budget template and will be displayed on the Declining Budget Report.

Start by building sections that will be used to build out the template.

  • Select Sections

  • Select New

  • Enter a Name of the Section

  • Select Save

  • Use Edit or Delete to change the section name or delete. 

  • Sections used in Budget Template with Formulas cannot be deleted.

  • First remove from the template before deleting. 


  • To get started, download the list of commonly used sections to enter into the Budget Maintenance. 


Creating Fields & Calculations  

  • The Fields tab houses all of the line items that will be used for calculations within the declining budget module and displayed on the declining budget report  
  • Each Field is assigned a Type from the variables listed in the Type: drop-down menu 
  • Each Field needs to have a calculation defined by using the Field: data types  
  • After you have created a calculation, the Test Math button can be used to verify if calculation is correct

 

(star) Note: All calculations must follow the proper mathematical formula


Defining Fields for your Cost of Goods

In this example, we will show how to set up a common field for calculating Food Cost to see the variance between actual Food Cost and Budgeted Food Cost. The same process should be replicated to calculate all Food Cost as line items for any Cost of Goods account you wish to see on the budget.

Cost of Goods Formula

The Budget Report is helpful in calculating the true Cost of Goods by always using invoice-based purchases.

Depending on your companies configuration, the Cost of Goods report can use Order Based Purchases* which pull price from Orders using Bid File pricing OR Invoice Based Purchases which pull cost directly from Invoices.

(Beginning Inventory $ + Purchases $) - Ending Inventory $

(BI + P- EI)/Sales

  • Purchases (P) = Sum of PPC based purchases + IUTs
  • Consider adding + Paid Outs + Paid Ins to the Cost of Goods Field when building the calculation
  • The Budget will always use the same values for calculating beginning inventory and ending inventory as the Cost of Goods report does
  • When BI or EI do not exist P will be displayed in the budget until BI and EI are posted in Decision Logic

*If your Cost of Goods uses Order Based Purchases use the COGS Reconciliation page to resolve cost discrepancies between Orders and Invoices to see a balance between reports or consider moving to Invoice Based Cost of Goods.

To get started building Cost of Goods fields:

  • Start by selecting the Fields tab under Budget Maintenance
  • Select New
  • Enter Name: Meat Cost
  • Account #
    • can be left blank or enter the account number  used for accounting systems
  • Type
    • for Cost of Goods calculations select Type: Cost of Goods
    • the secondary drop-down will list the available Cost of Goods data points to reference from the COGS Maintenance Page in Decision Logic.



  • Select Add to add the data point to the calculation
  • In this example, the calculation will be inserted as 'Cost Of Goods.1-Cos-Meat'[T^8] 
  • To add additional data points to the calculation use the mathematical symbols or hand key them into the calculation box
  • When finished with the calculation select Save
  • Select Test Math to review results returned by the calculation. 


Testing Field Calculations 

You can Verify the Calculation by using Test Math. 

After you have created a calculation, use the Test Math button to verify the calculation is correct.

Then, validate the amount by referencing the value in the corresponding Decision Logic Report.

Depending on the data points used in the calculation, frequently referenced reports to validate against include:

  • DSR
  • Cost of Goods Sold
  • Invoice Summary by Account
  • IUT History
  • Paid Outs Reports 


Building a Budget Template

Once you have Sections and Fields created you can begin to build a template for the Budget Report. Navigate to Maintenance > Budget  Maintenance > Template

Select NEW and start by selecting the first section you want to see at the top of your budget report. Most companies start with Sales.

Define Section Type:

 there are 3 types of sections you can choose from Section Type: drop-down when deciding how you want the information displayed on the report. 

  • In-Line will return a bold line on the report for each SECTION FIELDS you add to the section. This type should typically only be used for reporting a single SECTION FIELD. When adding more than one SECTION FIELD to an In-Line section type you will see the Section Name repeated on multiple rows with different values displayed for each SECTION FIELD you added. If you want to see the detail of the Field Name instead, choose Section Type: Detail and add your fields. 

  • Detail will allow you to define specific fields that will then report as individual rows within the Section.

  • The summary will allow you to add or subtract previously created sections. 

Define Divisor Type

  • Field Actual

  • Field Budget

  • Self 

  • Section 

Define Divisor

  • Divisors that appear for selection will vary depending on the Divisor Type previously selected 

Display Totals

  • check the box to add a total row for the section to the report.

  • this may be redundant depending on the data you are building. enable or disable this check box as needed.

Var % Format:

select an option for how you want to see the Variance between Actual and Budgeted amounts on the report. 

  • Actual % - Budget &

  • (Actual $ - Budget $) / Divisor

Display (Variance)  As:

define how you want the variance between Actual and Budget to appear on the report.

  • Positive

  • Negative 

Adding Section Fields

  • For section types: In-Line and Detail select what fields should be included in the section from the Section Fields drop-down.

Define a Format

  • Currency 

  • Percent

Select a Value Override Option

  • None - this option will not override the budget column. Instead, the report will always look at the budget entry to return a value

  • Use Actual - this option will use Actual as the Budget amount 

  • Zero Budget - this option will use Budget Amount as Actual if there are no Actual's entered, or until an actual gets entered. 

in this example enter 20,000 on Budget Entry

Populates the Actual with 20,000 Budget amount until Actuals are entered into Decision Logic

Example of Section Type: In-Line 

Reporting example of Section Type: In-Line 


Example of a Section Type: Detail 

Report example of a Section Type: Detail 


Example of Section Type: Summary

  • Summarize the Section by adding other sections

  • Select the Action based on the function the report should do with each section

    • Add

    • Subtract 



Entering Budget

A user guide currently under construction email helpdesk@decisoinlogic.co for questions 

Decision Logic allows for the entry of budgets for multiple reports. First, start by creating the budget report and its template. Once those are created go to Budget Entry or Budget Template Export to download an excel spreadsheet that can be filled out and uploaded into the Decision Logic system. 

Budget Entry

the Budget Entry page is designed to allow for adjustments to pre-loaded budgets by Store by Week OR to manually enter budgets for each line item by week. 

To begin to enter a budget into Decision Logic navigate to Maintenance > Budget Maintenance > Budget Entry  

  • Select a store to bring up the list of available Budget Reports that store is assigned too under the Report: drop-down

  • Select the Report to enter budgets for

  • Select the weekFil

  • Select Next to view the budget fields

  • Enter the budgeted amount by field 

  • Select Save to finalize the budget

Budget Template Export 

To bulk import, a budget for one or multiple stores navigate to Budget Template Export

  • Select Company or individual group or store to bring up the list of available Budget Reports that store is assigned too under the Report: drop-down

  • Select the Report to enter budgets for

  • Select the week or date range

    • For bulk import select Company or Group and dates from the start of the fiscal year to the end. this way the template will populate all the weeks and stores needed to upload the budget for the fiscal year

  • Fill out the column I for the budgeted amount

  • To load a bulk import submit a support ticket with the help desk by visiting our Customer Support Portal 

Navigate to Maintenance > Budget Maintenance > Budget Entry  

Budget Template Export in Excel

(warning)Please note, that if you do not upload a budget into Decision Logic, but have the store assigned to a budget, you can get Actual Reporting but you will not get Budget reporting until the Budget has been uploaded for each location assigned to the budget. 


Creating Multiple Reports: 

A user guide currently under construction but if you have any questions, please submit a support ticket with the help desk by visiting our Customer Support Portal 


Updating the Budget Report

The Process Budget checkbox on the initial landing page of each budget was put in place to provide a faster budget report when running for multiple periods.

For Store Use:

When running the budget for the first time after the week’s end, the budget will auto aggregate.  There is no need to select the process budget. 

When running for past weeks, if any invoices have been added you will need to select the “Process Budget” checkbox to re-aggregate the previous weeks. 

If the Process checkbox is not selected, the budget report will not aggregate past weeks but instead, will pull the last updated budget values.

Store Level Process Budget:

For Administration Use:

The Process Budget checkbox is not available when selecting all stores or multiple stores. 

When needing to aggregate multiple stores budget report please utilize the Budget Aggregator Page under Maintenance > Budget Aggregator. 

This is only necessary when changes to your data have been made.

Most Decision Logic clients are on an automatic system that processes the budget aggregator every night for the current week. 

If your selected Process Budget and your data did not aggregate for the last 7 days, please submit a support ticket with the help desk by visiting our Customer Support Portal.

Budget Aggregator

(warning)Please note, you can request that the Budget Auto Aggregate daily by submitting a support ticket with the help desk by visiting our Customer Support Portal