Mapping Codes to the General Ledger in TRAXPayroll

How do I map ledger codes in TRAXPayroll for a custom report?

Purpose: This guide will walk payroll admin users (with access to TRAXPayroll) through the process of mapping codes for a custom General Ledger report. 

Table of Contents

Mapping the General Ledger

Did you know you can map General Ledger codes for non-custom reports directly in BambooHR? Click here to learn more! 

Custom General Ledger reports are commonly built so that ledger codes and ledger names are mapped in BambooHR Payroll (TRAXPayroll). This report can be built to include deductions, departments, divisions, branches, and classes. For data to be pulled through on the General Ledger report, there needs to be data in the Ledger Code and/or Ledger Name field within each of these sections when applicable. The exact fields being used are specific to your custom General Ledger report. Please reach out to [email protected] with questions regarding which fields your report uses.

If you want to request a custom General Ledger report, click here. 

Mapping Deductions

To map deductions, log in to TRAXPayroll > click Company > click Deductions > click View next to the deduction name. A modal will appear for you to add information in the Ledger Code and/or Ledger Name fields within the Employee Cost and Employer Cost sections. Click Save and then repeat with the other deductions. 

The Employee Cost section is generally used for the employee portion of the deduction, while the Employer Cost section is used for the employer portion. This varies on how your General Ledger report is set up.

Mapping Departments

BambooHR Payroll can utilize the following fields when mapping your departments: Department Code, Department Name, Ledger Code, and Ledger Name. All are customizable except for the Department Name field, as this is the name entered in BambooHR.

To map departments, log in to TRAXPayroll > click Company > click Department > click Edit next to the department name. A new page will appear for you to add information for the Department Code, Ledger Code, and Ledger Name fields as applicable. Click Save and then repeat with the other departments.

Mapping Divisions

BambooHR Payroll can utilize the following fields when mapping your divisions: Division Code, Division Name, Ledger Code, and Ledger Name. All are customizable except for the Division Name field, as this is the name that is entered in BambooHR.

To map divisions, log in to TRAXPayroll > click Company > click Division > click Edit next to the division name. A new page will appear for you to add the information for the Division Code, Ledger Code, and Ledger Name fields as applicable. Click Save and then repeat with the other divisions.

Mapping Branches

BambooHR can utilize the following fields when mapping your divisions: Branch Code, Branch Name, Ledger Code, and Ledger Name. All are customizable except for the Branch Name field, as this is the name that is entered in BambooHR.

To map branches, log in to TRAXPayroll > click Company > click Branch > click Edit next to the branch name. A new page will appear for you to add the information for the Branch Code, Ledger Code, and Ledger Name fields as applicable. Click Save and then repeat with the other divisions.

Mapping Classes

BambooHR can utilize the following fields when mapping your divisions: Class Code, Class Name, Ledger Code, and Ledger Name. All are customizable except for the Class Name field, as this is the name entered in BambooHR.

To map classes, log in to TRAXPayroll > click Company > click Class > click Edit next to the class name. A new page will appear for you to add the information for the Class Code, Ledger Code, and Ledger Name fields as applicable. Click Save and then repeat with the other classes.