Available for the following Payroll plan: Premium, Core Payroll, Unlimited+Payroll
Dimensional accounting facilitates the use of detailed financial tracking in real time without requiring a complex chart of accounts that call for numerous General Ledger entries. As employee wages form a considerable expense in a business, this feature can help enhance the efficiency of your accounting methods.
Using dimensions also helps:
- Avoid the need to create multiple locations or sub-locations for each job, project, department, and so on, as well as the need to manage the locations in the chart of accounts
- Assign dimension values against an employee's earnings and expense claims in the pay run
- Include dimension details in the payroll journal, helping to prevent any manual transactions
For a short video on the setup, see: Dimensions | Video
Important
Currently, the only journal services that cater for including dimension details in the payroll journal are File export, Detailed file export, and Microsoft Dynamics Business Central.
However, businesses that are currently connected to another accounting service can export the dimension data from the Download journal button in a finalised pay run.
What is the difference between a dimension and a dimension value?
A dimension is used to group or categorise data for the purpose of analysis. A dimension value is a sub-category or a tag attached to the data to conduct meaningful analysis - this can be done because the data at this level is more detailed. There is no limit to the number of dimension values that can be set up under a dimension.
Helpful Hint
All dimensions/dimension values will be made available to all employees in the pay run.
- Dimension A
- Dimension value 1
- Dimension value 2
- Dimension value 3
- Dimension B
- Dimension value 4
- Dimension value 5
- Dimension value 6
- Area
- NSW
- VIC
- SA
- QLD
- Venue
- Europa Hotel
- Golden Sheaf
- Ship Inn
- Gladesville Hotel
- Department
- Kitchen
- Bar
- Gaming
- Restaurant
Getting started
- Log in to your payroll platform.
- Click the Business menu.
- Click the Payroll Settings submenu.
- Under Pay Run Settings, click Dimensions.
- Click Add.
- Write the name of the new dimension.
Important
You cannot set up a dimension with the exact same name as an existing dimension.
- Click Save.
Helpful Hint
If this is the first time you are setting up dimensions, you will see a banner where you can click Add a dimension now to start adding a dimension.
Important
A dimension must always be added first before its associated dimension value can be added.
- Click the Business menu.
- Click the Payroll Settings submenu.
- Under Pay Run Settings, click Dimensions.
- Select the dimension to add a dimension value to.
- Click Add.
-
Write the name of the new dimension value.
Important
You cannot set up a value with the exact same name as an existing value for the same dimension.
-
Put the External Id, if required.
Helpful Hint
Dimension value external Ids must be unique.
This field is not compulsory and would only be required if the accounting service required this information as part of the journal integration.
-
Select which employees the dimension value will be enabled for. By default, the dimension value will automatically be assigned to all employees. Otherwise, you can apply different criteria by selecting an employee or employees or by defining coverage based on one or more of these items:
- primary location
- location
- tags
- employee group
Important
This affects what dimension values are made available for an employee's record to configure % earnings split, primary dimensions, and dimensions that can be assigned to the employee’s pay run earnings and expenses.
- Click Save.
Important
A dimension must always be added first before its associated dimension value can be added.
- Click the Business menu.
- Click the Payroll Settings submenu.
- Under Pay Run Settings, click Dimensions.
- Click the Import Dynamics 365 Business Central dimension button.
Helpful Hint
This will automatically import all dimensions data created from within the Business Central account connected to the payroll account (via the Integrations screen), including the code and external id.
Any changes or updates to these details cannot be amended within payroll. Rather, it will need to be done in Business Central and then re-imported into payroll.
- Click the Business menu.
- Click the Payroll Settings submenu.
- Under Pay Run Settings, click Dimensions.
- Click Export.
- Choose file format.
-
Click Download.
Helpful Hint
You can download the file containing all existing dimension settings or a blank template if no dimension settings have been configured yet.
-
In the downloaded file, manually add dimensions or values or update any existing settings (i.e. update the name or external id of a dimension/dimension value).
Helpful Hint
See Further information at the end of this article to see what columns are included in the file.
- Save changes to your drive.
- Click Import to upload the file and update dimension settings.
Daily activities
Helpful Hint
You can assign default dimension values to an employee similar to how you can assign a default primary location to them, but this is optional. Any earnings and expenses created within the pay run will automatically assign those dimension values.
- Click the Employee menu.
- Click the List submenu.
- Select the employee you want to assign default dimension values to.
- Under Pay Run Settings, click Pay Run Defaults.
- Click the Primary Dimensions field to display a list of all dimension values.
-
Select dimension values.
Helpful Hint
You can select multiple dimension values, but only one dimension value per dimension.
- Click Save.
- Click the Employee menu.
- Click the List submenu.
- Select the employee you want to assign default dimension values to.
- Under Pay Run Settings, click Pay Run Defaults.
- Click the Split earnings button.
- Click Split by dimension.
- Input the dimension and split earnings % values.
- Click the green plus icon.
- Click Save.
- Click the Pay Runs menu.
- Click the pay run you want to assign dimension values to.
- Click the employee you want to assign default dimension values to.
- Under Earnings, click the Dimensions field to reveal a list of dimension values.
-
Select the dimension values you want to assign to the employee earnings.
Helpful Hint
You can select multiple dimension values, but you can only select a maximum of one value per dimension.
- Click Save.
- Click the Pay Runs menu.
- Click the pay run you want to assign dimension values to.
- Click the employee you want to assign default dimension values to.
- Under Expenses, click the Dimensions field to reveal a list of dimension values.
-
Select the dimension values you want to assign to the employee earnings.
Helpful Hint
You can select multiple dimension values, but you can only select a maximum of one value per dimension.
- Click Save.
- Click the Pay Runs menu.
- Click the pay run you want to assign dimension values to.
- Click Pay Run Actions.
-
Click Export Pay Run.
Helpful Hint
The Earnings Lines and Employee Expenses worksheets in the export template will include a column for each dimension set up in the business. Enter the dimension value you want to add in the applicable cells.
- Save the changes to your drive.
- Go back to the pay run you want to assign dimension values tp.
- Click Pay Run Actions.
- Click Import Pay Run.
- Select the export file you edited.
- Click Confirm upload.
- Go to the Dashboard.
- Click Employees.
- Click Manage Employees.
- Click Create Timesheets.
- Select the employee you want to assign dimension values to.
- Click the dropdown in each dimension column.
- Select the dimension value to assign to the employee.
- Click Save.
Helpful Hint
No more than one dimension value from the same dimension can be assigned per timesheet line.
- Go to the Dashboard.
- Click Employees.
- Click Manage Employees.
- Click Approve Timesheets.
- Under Status, click Approved.
- Click the approved employee timesheet you want to modify.
- Click Undo 1 timesheet to revert it to a submitted status.
- Click OK to confirm undo.
- Under Status, click Submitted.
- Click the icon of the timesheet you reverted to submitted.
- Under Dimensions, click the dimension value you want to add to the timesheet.
- Click Save.
- Click the timesheet again.
- Click Approve 1 timesheet.
- Click OK.
Data Management
Important
You cannot restore a dimension that has the following:
- the same name as an active dimension; and
- an external id that matches that of an active dimension.
- Click the Business menu.
- Click the Payroll Settings submenu.
- Under Advanced, click Restore Deleted Items.
- Click the Deleted category dropdown.
- Click Dimension.
- Click Restore beside the dimension you want to restore.
- Click Restore in the confirmation popup.
Important
You cannot restore a dimension value that has the following:
- the same name as an active dimension value; and
- an external id that matches that of an active dimension value.
If you want to restore a dimension value that was deleted as a result of the dimension being deleted, you must restore the dimension. This will automatically restore that dimension's associated values.
- Click the Business menu.
- Click the Payroll Settings submenu.
- Under Advanced, click Restore Deleted Items.
- Click the Deleted category dropdown.
- Click Dimension value.
- Click Restore beside the dimension value you want to restore.
- Click Restore in the confirmation popup.
Removing data
Important
Deleting dimensions will not remove them from historic pay run data or payroll journals. However, the deleted dimension and its associated dimension values will not be available anymore to assign in pay runs moving forward.
- Click the Business Menu.
- Click the Payroll Settings submenu.
- Under Pay Run Settings, click Dimensions.
- Select the dimension you want to delete.
- Click the icon beside the dimension.
- Click the OK button.
Warning
Deleting a dimension will also delete its associated dimension values.
Important
Deleting dimension values will not remove them from historic pay run data or payroll journals. However, the deleted dimension values will not be available anymore to assign in pay runs moving forward.
- Click the Business Menu.
- Click the Payroll Settings submenu.
- Under Pay Run Settings, click Dimensions.
- Select the dimension with values you want to delete.
- Click the icon beside the dimension value.
- Click the OK button.
Important
Dimensions and dimension values cannot be deleted in the payroll account for Dynamics 365 Business Central users. You can manage any deletion directly within Business Central.
Further information
The table below describes each column in the file exported from Dimensions on Payroll classic.
| ReportingDimensionId |
This is the system generated id pertaining to the dimension. An id will be displayed for existing dimensions. If you are adding new dimensions via the import functionality, keep this cell clear. If you are updating an existing setting, ensure to not remove the Id so that the system knows exactly what setting to update. |
| ReportingDimensionName | This pertains to the name of the dimension. |
| Id |
This is the system generated id pertaining to the dimension value. An id will be displayed for existing dimension values. If you are adding a new dimension value via the import functionality, keep this cell clear. If you are updating an existing dimension value, ensure to not remove the Id so that the system knows exactly what setting to update. |
| Name | This pertains to the name of the dimension value. |
| ExternalId |
Enter value in this cell if the business has connected to a specific accounting service that requires an external id to be added to dimension settings. In this case, that value should come from the accounting platform. Otherwise, this can be kept blank. |
The payroll journal will now reflect any dimension values assigned in the pay run when you post or download it. But this functionality only applies to businesses using File export, Detailed file export, or Dynamics 365 Business Central journal service.
Businesses that are currently connected to another accounting/journal service can export the dimension data from the Download journal button in a finalised pay run.
The Details worksheet of the journal file includes a column for each dimension set up in the business. Any dimension values that have been assigned will be displayed in the applicable cell.