How to Manage General Ledger Mapper on Talenta

Article author
Learning Center Mekari
  • Updated

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.

  1. Enter the Payroll menu.
  2. Then click the “General Ledger Mapper” menu.

A. How to Create GL Mapping

  1. To create a General Ledger mapping, click the “Create GL mapping” button.
  2. Then, fill the GL mapping Code that you want.
  3. Enter the account name in the Account name column.
  4. Enter a description of the GL mapping created in the Description column.
  5. Next, you can enter JSON metadata (optional) if you have integration needs by clicking “+JSON metadata (Optional)".
  6. 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 Benefit
    Individual 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 Benefit

    Cost Center B = Basic Salary+ BPJS Benefit

  7. You can also enter data in bulk by clicking the “Export” button.
  8. 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

  9. If the data has been filled in, click the “Import” button.
  10. Then select the file by clicking  "Browse"  and click  "Import"  to start importing data.
  11. Your imported data will look like this. You can click the  "Filter"  icon to filter the data mapped to that account.
  12. 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.
  13. And click  "Save" .
  14. Then the GL Mapper that you have created will look like this.
  15. You can click the  "down arrow"  icon then select  Edit  to change and  Delete  to delete.

B. How to Run GL Mapper Report

  1. Select one of the General Ledger mappers you want to download and click  “Run report”  to export the report in .xls format.
  2. Select the report  period  you want to download then click  "Download" .
  3. Then your report has been processed, you can click  "Open Inbox"  to see the process.
  4. Next, click “  Download XLS”  report to download the data in .xls format.
  5. The report will look like this.
  6. You can also view and download the history of the reports you have created with a click "View ALI GL report" .
  7. Then, you will go to  the Report History  tab and click “Download report” .
  8. 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.