Advanced Budgeting Page
  • 03 Jul 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Advanced Budgeting Page

  • Dark
    Light
  • PDF

Article summary

This article describes controls and columns on the Advanced Budgeting page of R365’s Budgets feature. The Advanced Budgeting page is used to view and edit budgets. Users with the required permissions enabled can perform a variety of budget-related tasks from this page, including locking and unlocking budgets, entering sales data, and reviewing profits by period. Budget Parameters can be adjusted here as needed.


Fields on the Advanced Budgeting page

Field

Description

1

Save

Saves changes to the budget. Options include:

  • Save - Saves changes and remains on the current page.

  • Save and Close - Saves changes and closes the page.

2

Action

Allows the user to delete or export the budget.

3

Locations

One or more locations to which the budget applies.

If the selected locations belong to different legal entities, the budget uses periods or weeks from the legal entity of the location that was selected first.

4

Account Type

Determines whether the budget is set by period or by week.

5

Calendar Type

Determines whether the budget uses the operational calendar or the fiscal calendar.

The budget can only be used to run the Profit and Loss statement if the budget uses the same calendar type as the report.

6

Reporting Budget

If selected, the budget becomes the default budget used in My Reports for the selected location(s).

7

Lock Budget

If the toggle is set to on, the budget is locked and cannot be edited until it is unlocked by a user with the appropriate permissions.

Only users with the Lock/Unlock Budgets permission can change the locked status of a budget. To all other users, this toggle is read-only

8

Budget By

Determines whether the budget is set by period or by week.

9

Budget Year

Year to which the budget applies.

10

Name

Name of the budget. Budgets need a unique and descriptive name so that users can easily select or view the correct budget when working in Accounting.

11

Import a list

Allows the user to import values from a spreadsheet file.
To export a budget to Excel, hover over the Action menu and select Budget Template / Excel Export. This produces a pop-up where the user selects the location to export. Once the template is complete, it can be imported using this Import button. Values from the imported template then populate the budget.

12

Sum / Avg

When working with a budget that represents multiple locations, the user can elect to view the values in each cell by Sum or by Average. For budgets with only one location, the Sum and Avg buttons produce the same value.

13

Whole / Decimal

Elect to view the values in each cell as whole numbers (rounded) or with decimals (not rounded).

14

Net Sales

Expand to show (or collapse to hide) actual net sales from the previous two years. If data is only available for one year, only one row appears.

15

Budget Sum

Displays totals of all values entered for each period or week for the entire budget.

16

Table

Displays budget amounts by period or by week for each account included in the budget.


Was this article helpful?