Managing Expense Budgets by Category

Managing Expense Budgets by Category

This tool lets you define, track, and compare your expense budgets against actual costs on a weekly basis. The Expense Categories Budget Report integrates revenue and expense data to provide a clear view of your financial performance.

Image

1. Report Overview

The report screen is a single page with a weekly view. A "Week Ending" filter is available with all relevant dates.

The weekly view displays the following data:

  • Week Ending: The Friday date that marks the end of the settlement week.

  • Expense Category: The name of the expense category.

  • Budget Amount: The budgeted value you defined for the week.

  • Actual Amount: The total actual expenses for the category during the week, pulled from the Expenses Registry.

  • Percentage Comparisons:

    • Budget vs Top-Line Revenue %: Weekly Top−Line RevenueBudget Amount​×100.

    • Actual vs Top-Line Revenue %: Weekly Top−Line RevenueActual Amount​×100.

    • Actual vs Budget %: Budget AmountActual Amount​×100.

The Actual vs Budget % also uses a color indicator to show if the actual amount is over or under budget. The value is green if the Actual Amount is less than or equal to the Budget Amount (on or under budget). The value is red if the Actual Amount is greater than the Budget Amount (exceeded the budget).

2. Configuring and Editing Budgets

You can flexibly define budgets through a user interface.

  • Budget Methods: You can define budgets as either a fixed dollar amount or as a percentage of your top-line revenue.

  • Categories: Each budget entry must be tied to an active expense category. The report will only display active categories.

3. Logic and Data Sources

  • Top-Line Revenue:

    • For P&D Companies: The Weekly Net Amount Due is sourced from the Charge Statement.

    • For Linehaul Companies: The Weekly Revenue Settlement Amount is sourced from the Settlement Statement.

  • Actual Expenses: The total expenses for each category are summed from the Expenses Registry on a weekly basis (Saturday to Friday).

  • Data Synchronization: All calculations and data update in real-time as new revenue or expense information becomes available.


    • Related Articles

    • Expenses Category

      The Expenses Categories feature allows users to create new categories of business expenses to help users organize their data. mygroundforce presents users with default expense categories, but users can also create their own or edit the default ...

    • Managing Expense Categories for Dashboard and Report Calculations

      myGroundForce provides granular control over how your expense categories contribute to key dashboard metrics and reports, particularly those related to fuel and DEF analysis. This feature ensures that your financial reporting accurately reflects the ...

    • Expenses Registry

      On the Expenses Registry screen you can register other business expenses not registered on the FedEx Linehaul Settlement, so you will be able to register, track, and manage all business expenses. You can filter records by date, vehicle number, or ...

    • Employee Categories

      On this page, you will be able to see all categories of your employees and view if their Status. You can create, edit, and inactivate categories. Use the button to create a new employee category for your company.   You can edit by clicking on ...

    • Import Expenses Using Spreadhseets

      This help article and the video below will explain how to import expenses using a spreadsheet. This allows mygroundforce users to create multiple expenses at a time. On mygroundforce, use the left-side menu to access Finances >Expenses Registry. At ...