After the payroll process is complete, the company will enter the bookkeeping stage. Currently you can carry out General Ledger mapping according to company regulations. Here are the steps.
- Enter the Payroll menu.
- Then click the “General Ledger Mapper” menu.
A. How to Create GL Mapping
- To create a General Ledger mapping, click the “Create GL mapping” button.
- Then, fill the GL mapping Code that you want.
- Enter the account name in the Account name column.
- Enter a description of the GL mapping created in the Description column.
- Next, you can enter JSON metadata (optional) if you have integration needs by clicking “+JSON metadata (Optional)".
- Next, you can fill in the required data individually in the Account mapping section.
You can have 3 account names consisting of:Type Definition Eligible Component Example Calculation Aggregate The data will be aggregate (sum) for all component that assigned Payroll Component, Reimbursement Request, Loan Request Components Assigned: Basic Salary, BPJS Benefit
Result: Basic Salary+ BPJS BenefitIndividual The data will be aggregate (sum) by individual employee for all component that assigned Reimbursement Request, Loan Request Components Assigned: Reimbursement outpatient
Result: Employee A - {Total Value}, Employee B - {Total Value}Request The data output will be individual request for each component assigned Reimbursement Request, Loan Request Components Assigned: Reimbursement outpatient
Result: Transaction ID 1 - {Total Value}, Transaction ID 2 {Total Value}Aggregate by Cost Center The data will be aggregate (sum) by Cost Center for all component that assigned Payroll Component, Reimbursement Request, Loan Request Components Assigned: Basic Salary, BPJS Benefit
Result:
Cost Center A = Basic Salary+ BPJS BenefitCost Center B = Basic Salary+ BPJS Benefit
- You can also enter data in bulk by clicking the “Export” button.
- Then, you can fill in the template as below.
- Column (F) Components and (H) Filter must be left blank.
- Individual and Request types can only use ID components with IDs that have the first letters R and L.
- You can see the Component ID on the Component List sheet - If the data has been filled in, click the “Import” button.
- Then select the file by clicking "Browse" and click "Import" to start importing data.
- Your imported data will look like this. You can click the "Filter" icon to filter the data mapped to that account.
- You can also click the “table” icon to add JSON metadata at the Account level. You can fill it with the data required for integration.
- And click "Save" .
- Then the GL Mapper that you have created will look like this.
- You can click the "down arrow" icon then select Edit to change and Delete to delete.
B. How to Run GL Mapper Report
- Select one of the General Ledger mappers you want to download and click “Run report” to export the report in .xls format.
- Select the report period you want to download then click "Download" .
- Then your report has been processed, you can click "Open Inbox" to see the process.
- Next, click “ Download XLS” report to download the data in .xls format.
- The report will look like this.
- You can also view and download the history of the reports you have created with a click "View ALI GL report" .
- Then, you will go to the Report History tab and click “Download report” .
- Then the downloaded file will look like this.
That's an explanation of how to manage the General Ledger Mapper, then you can learn how to manage the General Ledger Mapper access role in Talenta.