Once you have connected a journal service and imported your chart of accounts, you can map those accounts to different payroll transaction types, or to an employing entity. To view our YouTube video on Chart of Accounts, click here. The chart of accounts page consists of two sections:
- Primary accounts: These accounts are required and are the accounts that will be used if no location-specific accounts are mapped.
- Location-specific accounts: These accounts are used to override the primary accounts for transactions at a given location.
Mapping accounts to transaction types
Journals are produced based on the GL account that is mapped to the transaction type. The transactions are created based on a transaction hierarchy. The hierarchy is defined as follows:
Top Level:
Default Account Mappings
Second Level:
Pay Category Mappings, Deduction Category Mappings, Expense Category Mappings, Employer Liability Mappings
Third Level:
Location specific default account mappings
Fourth Level:
Location specific Pay Category Mappings, Deduction Category Mappings, Expense Category Mappings, Employer Liability Mappings
Transactions are matched to the GL account from the lowest level to the highest level.
Default transaction types
The following transaction types are mapped at the default level:
Payment Account:
This account is often called the "payroll clearing" account and is used to reconcile the net payment amount of the payroll to the transaction from your bank account.
Wages Expense Account:
This account is used to record the gross wages expense for the pay run.
Default Payroll Liability Account:
The account specified here will be where all the deductions get journalled if there is no specific liability account set up.
PCB Liability Account:
This account will track your tax liability transactions.
EPF Employer Expense Account:
This account is used to track your EPF expense transactions.
EPF Employer Liability Account:
This account will track your EPF liability transactions.
EPF Employee Liability Account:
This account will track your employees EPF liability transactions.
EIS Employer Liability Account:
This account will track your EIS liability transactions.
EIS Employee Liability Account:
This account will track your employees EIS liability transactions.
SOCSO Employer Expense Account:
This account will track your SOCSO expenses
SOCSO Employer Liability Account
This account will track your SOCSO liability transactions.
SOCSO Employee Liability Account
This account will track your employees SOCSO liability transactions.
HRDF Employer Expense Account
This account will track your HRDF expenses
HRDF Employer Liability Account
This account will track your HRDF liability transactions.
PCB Borne By Employer Expense Account
This account will track your employer PCB expenses
PCB Borne By Employer Liability Account
This account will track your employer PCB liability transactions.
CP38 Expense Account
This account will track your CP38 expenses
CP38 Liability Account
This account will track your CP38 liability transactions.
Benefits In Kind Expense Account
This account will track your benefits in kind expenses
Benefits In Kind Liability Account
This account will track your benefits in kind liability transactions.
Employee Expenses Account
This account is used to record any employee expenses processed within the pay run. Expenses are not deemed part of employee wages.
his account will track your employer expense liability transactions.
Employer Liability Account
his account will track your employer liability transactions.
Pay category transaction accounts
Pay category transaction accounts are used to allocate specific wage expenses to different GL accounts. For example, you may want to track bonuses, leave paid or allowances paid to different GL accounts. To do this, you would map a different GL account for the specific pay category.
If you don't specify a pay category transaction account, the default Wages Expense Account will be used.
Deduction category transaction accounts
Deduction category transaction accounts are used to allocate specific deductions to different GL accounts. If you don't specify a deduction account, the Default Payroll Liability Account will be used by default.
Assigning a GL account to the Expense Account is not compulsory and should only be done if you want the deduction amount to be posted as a debit entry against the allocated GL (which, in turn, reduces the wages GL account by the same amount).
Expense category transaction accounts
Expense category transaction accounts are used to allocate specific expenses to different GL accounts. If you don't specify an expense account, the transactions will be posted to the Employee Expenses Account by default.
Splitting by employing entity
Chart of accounts can now be split by employing entities for file export and detailed file export journal types, allowing for more granular and relevant financial data. This can be helpful if you have set up multiple employing entities, which can now translate the split of earnings into your chart of accounts accordingly.
Note: You will need a working integration into File Export or Detailed File Export to be able to publish multi-entity chart of accounts.
Your journal export will display the earnings split as specified in the chart of accounts, under the Entity column.
Splitting by location
When you map your default GL accounts, you'll notice that there is an option to "Split by location". This allows you to write a transaction line per location to the journal for the same account. This is particularly useful if you're using locations, classes or tracking categories in your specified accounting package.
Location Specific Accounts
If you want to split your GL by location and allocate the transactions to a different GL account, you can define location specific accounts. These accounts will work in exactly the same way as the primary accounts, however they will only apply to the location they are specified for.
Exporting the Chart of Accounts
Additionally, you can export your Chart of Accounts configuration via Payroll Settings > Data Extracts:
Explore related content
- Restore Deleted Items Learn how to get back items you previously deleted.
- Advanced Settings Learn about the more advanced setting that can be used on your platform. that apply.
If you have any questions or feedback please let us know via support@yourpayroll.io
Comments
Article is closed for comments.