Payroll Budgeting Training Documentation

Modified on 11/07/2024 09:56 AM by Jason Greenleaf — Categorized as: Documentation, Needs Review, Procedures, Public, Support

Payroll Budgeting Training Documentation¶

Table of Contents [Hide/Show]

Payroll Budgeting Training Documentation
   Introduction
   Preparation
      Module Activation
      Security
      Data Preparation
         Territory Setup
         Store Territories
         Employee Territories
         Employee HR Info
         Store Hours
         Holidays
         Payroll Budget Master
         Sales Summary
   District Manager
      Approval
      Reporting
   Store Manager
      Budget Maintenance
      Approval
      Reporting

Introduction¶

Payroll Budgeting is the process of measuring estimated and actual payroll expense against projected and realized sales. It is an activity that keeps managers informed of profitability and allows them to proactively manage payroll costs.

This documentation outlines the proper use of the ComCept Payroll budgeting module. Documentation is segmented by audience type, and covers all aspects of Payroll Budgeting, from preparation to reporting.

Preparation¶

Module Activation¶

Payroll Budgeting cannot be used until a ComCept employee activates the module. If no Payroll Budgeting menu items appear for you in the Human Resources menu, then you should contact sales to verify the activation of your Payroll Budgeting module. Menu items include Holidays, Store Hours, Payroll Budgeting, Payroll Budget master, et al.

Security¶

You must carefully assign Payroll Budgeting permissions to users by way of Security Groups, in order for them to access the new functionality. The following permissions have been added to ComCept .Net:

Permission	Enables	Recommended Assigned To
PayrollBudget_Add	Create new budget for an upcoming pay period	Store manager
PayrollBudget_Delete	Delete an existing budget	Store manager, DM
PayrollBudget_Edit	Edit time on an existing weekly budget	Store manager
PayrollBudget_Master	Edit the master percentages allowed by month	Accounting, DM
PayrollBudget_View	View contents of an existing weekly budget	Store manager
PayrollBudget_Sales	Edit the sales figures against which payroll budgets are measured	Accounting
Employee_HR	View and edit Hourly Type and Hourly Rate in Employee Maintenance	Accounting

In order to grant Payroll Budgeting permissions to users, you must first assign permissions to the appropriate security groups, and then assign these groups to the appropriate users. The functions associated with these permissions will be denied to users who do not have the permissions, and related fields may even be hidden. For example, without the Employee_HR permission, users will not see sensitive HR fields, such as Hourly Rate on the Employee Maintenance screen, even if they are allowed to visit and make changes on this screen.

Data Preparation¶

Territory Setup¶

Before using Payroll Budgeting, you must review your Territory setup. Territories are maintained in the Regions / Territories menu item on the Company menu. You should have a top-most territory for your organization. Underneath the top territory, each district should be represented by a child territory. Underneath each district, any required sub-districts should be represented by their own territories. Underneath each bottom-most district, each store location should have its presence represented by a territory.

Store Territories¶

Each Store should be assigned its proper territory, generally a one-to-one between store and territory. This links the store to its place in the company hierarchy, allowing district managers to govern activities in the stores over which they have influence.

Employee Territories¶

The Employee records for each of your Payroll budgeting users must be assigned properly in order for the users to have influence over the correct number of stores. Store managers should be assigned to the bottom-most territory that matches their store, whereas District managers should be assigned the territory that resides above the store grouping for which the managers have responsibility.

Employee HR Info¶

You must inform the system of the pay rate for each hourly employee whose payroll cost will be analyzed in Payroll Budgeting. This is accomplished by viewing the Employee record in Employee Maintenance while logged in as a user with the Employee_HR permission. The Hourly Type and Hourly Rate must be set for each employee that will be tracked in Payroll Budgeting.

Store Hours¶

Payroll Budgeting needs the standard hours of operation for stores in order to anticipate payroll expenses. You must indicate the store hours by day, as seen here:

Holidays¶

Holidays must also be specified in ComCept .Net before Payroll Budgeting can anticipate payroll expense. You must indicate all company holidays, as seen here:

Payroll Budget Master¶

You must indicate the allowable percentage of sales a store manager can schedule in payroll by month. Each store can be assigned a different sales percentage by month, to account for regional differences and special circumstances. The percentages listed here will dictate how much payroll time a manager may schedule, as well as trigger overage approval requirements.

Sales Summary¶

ComCept .Net stores very detailed history about sales for every invoice, which can take time to calculate summaries. To speed summarization, Payroll Budgeting uses pre-calculated sales figures by store, by month, and recalculates the summaries nightly.

If you use ComCept .Net for sales, then sales summary can be automatically calculated for you, by setting the “Calculate Sales Summary” option under Preferences > Misc.

Payroll Budgeting users who do not use ComCept. Net for sales can upload sales figures that were calculated elsewhere. This feature is available when the “Calculate Sales Summary” option under Preferences is unchecked. An action on the Payroll Budget Master screen, labeled Sales Maintenance becomes visible, and takes you to the Sales Maintenance page.

The sales figures are used in to determine what percentage of allowed sales has been scheduled in payroll for a given week. For this reason, sales figures must be present before budgets can be created, and before any reports can be run.

District Manager¶

Approval¶

District manager activities in Payroll Budgeting are reactive. Budget records are automatically approved when store managers submit their budgets, provided the estimated payroll cost is within budget. Only those budgets that exceed their allowed percentage of sales will appear in an approval queue for district managers to approve. When a budget requires approval, all parties that indicated in the Alert Subscription Screen will be notified by email, reminding them to check the approval queue for their district. District managers will only see budget approval requests from those stores under their area of influence (see Territory setup in previous section).

When approving a payroll budget for a store manager, the district manager will see summary information about the budget in question, and must supply a comment.

Reporting¶

There are several payroll budgeting reports available to analyze actual time clock entries for employees against the budgeted payroll schedule in real-time. Reports have a variety of configurable input parameters, allowing flexible totaling and filtering of the results. The list of reports includes:

Store Manager¶

Budget Maintenance¶

Store managers can create Payroll Budgets for their stores every week. The budgets can be created for pay periods as far as two weeks in advance, but may not be created further in the future and cannot be created for past weeks. Only the stores to which the managers belong are available when creating budgets, although a district manager would have access to all stores within the territory to which they belong, and therefore could create budgets for any of their stores.

Managers create new budgets from the Payroll Budget screen.

A Payroll Budget is made up of a header and payroll hourly details. The header contains a store location and pay period start date, as well as summary information on the hours budgeted. The payroll hour details contain information about employees and their expected time periods, including regular time, overtime and paid time off (vacation, holidays, etc.). As time periods are added to the budget, a summary of the total scheduled hours, associated payroll costs and percentage of allowance is updated at the top of the page.

The store manager will see the following screen while editing a Payroll Budget:

Each employee at the store for a budget is listed vertically. Each day in the week is listed horizontally. As time periods are added for a given employee, the day to which the time period applies will dictate where the time period appears. For example, an 8-hour time period was entered for Jeff Withers in the screen shot above, on Friday, and therefore appears in the third column under Withers’ time block.

Managers can add time periods by pressing the Add Period button next to the desired employee. A time entry window will appear, allowing the specification of the day and start / stop times for the time period.

If there are any time periods where an employee works more than 5 contiguous hours, a red alert warning appears next to the employee’s name. If the sum of hours scheduled exceeds the standard work week (as defined in Time Clock Settings), a red indicator for Overtime will appear next to the employee name. The warning indicators appear as follows:

Managers may copy an entire schedule into a new pay period, lessening the time it takes to create new schedules. This is accomplished by reviewing any existing payroll budget for their store, and pressing the “Copy Schedule” button on the Payroll Budget page. A new pay period begin date must be supplied, and any paid time off (vacation, holiday) records will not be copied with the new schedule.

Approval¶

When the store manager is satisfied with the scheduled payroll hours, the schedule is submitted by pressing the Submit button at the bottom of the page. If the budget is less than the allowed payroll percentage then no further action is required. If the schedule exceeds allowed budget then a district manage above the store manager must approve the budget.

Reporting¶

Some of the reports utilize an attribute to automatically exclude sales from Payroll Budgeting. This attribute is called SalesSummaryAttributesExclude and will need to be assigned to customers that should not count towards Payroll Budgeting.