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. The Budget Report gives end users a live P&L based on budgeted and actual amounts by accounts set up in DL.
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 Service Center.
Creating Sections
To configure and customize the Budget Report, navigate to Maintenance > Active Budget Control > Budget Maintenance.
The Sections tab is used to create the headers that will be 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 for the Section.
Select Save.
Use Edit or Delete to change or delete the section name.
Sections used in Budget Template with Formulas cannot be deleted.
First, remove it from the template before deleting it.
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 the calculation is correct.
All calculations must follow the proper mathematical formula.
Defining Fields for Cost of Goods Sold
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 Costs 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 (Inter Unit Transfers).
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 Sold calculations, select Type: Cost of Goods
The secondary dropdown will list the available Cost of Goods data points to reference from the COGS Maintenance Page in Decision Logic.
Continued steps:
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 the 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 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 dropdown.
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 Actuals 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 is currently under construction. For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.
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 > Active Budget Control > Budget Entry.
Select a Store to bring up the list of available Budget Reports that the store is assigned to under the Report: dropdown.
Select the Report to enter budgets for.
Select the Year.
Select the Period.
Select the Week.
Click Apply.
Enter the Budget Amount $ and press enter or tab.
Select Save to finalize the budget.
Budget Template Export in Excel
Creating Multiple Reports:
A user guide is currently under construction. For additional questions or assistance, please submit a support ticket by visiting the Decision Logic Service Center.
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 by visiting the Decision Logic Service Center.
Budget Aggregator
If you'd like to receive news on software releases and product updates, please sign up for our email list.