Payroll Ledger configuration and reporting for MYOB
Your payroll data can be mapped to General Ledger (GL) account codes based on the rules that you set. With your GL account codes mapped, you can export your Payroll Ledger quickly and have it ready for the MYOB journal import.
If you use Xero as your accounting software, we have you covered with our Xero guide to Payroll Ledger Mapping!
In this article, we will cover:
- Importing your Chart of Accounts
- Mapping expenses and liabilities
- Exporting the Payroll Ledger report for import into MYOB
- FAQs
Please note: Due to MYOB limitations, the Journal Import feature is only available on specific MYOB accounting packages. Before mapping your payroll ledger, please consult with your bookkeeper about the MYOB account you are using.
Before mapping your payroll data, we would like you to consider a few items. Please read the following, as they could significantly impact the amount of work you need to do going forward.
- Depending on your role and business, more than one person may be required to complete this task. You will need your Chart of Accounts and a good understanding of your business' accounting setup.
- MYOB and XERO are currently the only accounting software supported by the Payroll Ledger Mapping tool. In the future, more accounting software solutions will be supported.
- Payroll ledger mapping is completed per paying entity.
- Payroll ledger mapping can be redone or edited as required.
- If your Chart of Accounts changes, it can be re-imported and re-mapped.
- Adding new accounts will not affect the mapping you have set up already.
- Removing mapped accounts will give you a warning, letting you know that the account is mapped but allowing you to continue if you choose. Any mapped payroll items will then become unmapped.
Contact us: While we are not accounting experts, our Support team are still on hand to assist you with troubleshooting any issues that may arise while mapping your Chart of Accounts or exporting your ledger.
The first step to setting up your Payroll Ledger export is to import your Chart of Accounts. You don't need to edit or review your Chart of Accounts before you import it.
To import your Chart of Accounts:
- From the main menu, navigate to Payroll Settings > Payroll Ledger Mapping.
- Select Create Map to the right of the paying entity you want to configure.
- Select your accounting software and then Begin Mapping.
- Download the chart of accounts template and input the following data from MYOB.
- Code - The account number that will be used in your mapping.
- Description - The name associated with the account that will be used in your mapping.
- Account Group - The type of account. This is used to pre-select where the account will be used in your mapping (i.e. expenses, liabilities, non-payroll).
- GST Type - The tax type of the account. This will affect your payroll ledger export.
- Opening Balance (Optional) - Has no impact on the mapping process or export.
- Opening Balance Date (Optional) - Has no impact on the mapping process or export.
- Select browse, locate the completed template and select open. This will import your Chart of Accounts.
- Please check the codes thoroughly and make sure that they are marked correctly. You can change how a code is marked if required.
- The mapping tool will have pre-selected the codes that are marked as Expenses or Liabilities. Everything else will be marked as Non-payroll.
- Non-payroll codes won't be included in the mapping process.
- The Chart of Accounts can be reimported if necessary.
- Selecting only the expenses and liabilities you intend to map will make the next 2 steps easier.
Please note: If you need to change what the account type a code is marked as after you have completed your mapping, any items already mapped to that code will be removed.
- Select Start mapping.
After importing your Chart of Accounts, the next step is to map your expenses. Expenses are any items that could contribute to the overall costs of running a business.
Before mapping your expenses, please note the following:
- All the GL accounts you specified as expenses in your Chart of Accounts will be visible on the left of the screen.
- The expense mapping can be set up so that all payroll items from foundU are mapped to a single GL code. Alternatively, you can set up rules to divide the payroll items into multiple codes.
- Single GL code - For example, all OTE hours could be mapped into '477 Wages & Salary'.
-
Multiple GL codes - For example, all OTE hours could be divided into '477 Wages & Salary-Management' or '478 Wages & Salary Support'.
- To the right, you will see all available expenses within foundU. As you map your foundU expenses to the codes, the list on the right will reduce, leaving only the unmapped ones. This lets you easily confirm when all your costs have been mapped.
- You may complete the mapping process without mapping all expenses.
Mapping for a single code
To map an expense to a single GL code:
- Select + Map expense to the right of the code.
- All of the available expenses in foundU will be presented for selection. You can select the expenses that map to your chosen code individually or by selecting a group heading to select all within.
- Select Save map.
- Repeat these steps until all single codes have been mapped.
In this example, we allocate all Superannuation payroll expenses to the Superannuation account.
Please note: The above is an example only and may differ for your business mapping.
Mapping for multiple codes
When mapping multiple GL codes simultaneously, it is important to note that not all payroll items can be split by the same conditions.
The following items will have limited options available:
- ETP/Terminations
- On costs (Workcover, payroll tax)
- Superannuation (except super guarantee)
- Deductions
To map an expense to multiple GL codes:
- Select Divide expense between codes in the top right.
- From the drop-down menu, select at minimum two codes.
- Choose the expenses that will be divided into these codes, then select Map rules.
- On the left, select your conditions. You can divide expenses by up to 2 conditions.
The following items can be used to split your expenses: - On the right, add the conditions to be met to map the expenses.
- Optionally select Include fallback code. This will act as a catch-all code. If an expense doesn't trigger any of the rules you have set up, it will fall into the code you have selected here.
- Save, name your rule and confirm.
- Repeat these steps until all expenses are mapped.
In the below example, we split the wage payroll expenses among several wage accounts based on the cost code.
Please note: The above is an example only and may differ for your business mapping.
After mapping expenses, the next step is to map your liabilities. Liabilities are obligations that businesses owe.
Before mapping your liabilities, please note the following:
- All of the codes you specified as liabilities in your Chart of Accounts will be visible on the left of the screen.
- The mapping of liabilities can be set up so that all payroll items from foundU are mapped to a single GL code. Alternatively, you can set up rules to divide the payroll items into multiple codes.
- Single GL code - For example, all OTE hours could be mapped into '477 Wages & Salary'.
- Multiple GL codes - For example, all OTE hours could be divided into '477 Wages & Salary-Management' or '478 Wages & Salary Support'.
- To the right, you will see all available liabilities within foundU. As you map your foundU liabilities to the codes, the list of liabilities on the right will reduce, leaving only the unmapped ones. This feature lets you quickly verify that all your obligations have been identified and recorded accurately.
- You may complete the mapping process without mapping all liabilities.
Mapping for a single code
To map a liability to a single GL code:
- Select + Map liability to the right of the code.
- All of the available liabilities in foundU will be presented for selection. You can select a liability to map to your chosen code individually or by selecting a group heading to select all within.
- Select Save map.
- Repeat these steps until all single codes have been mapped.
In this example, we allocate all Superannuation payroll liabilities to the Superannuation account.
Please note: The above is an example only and may differ for your business mapping.
Mapping between multiple codes
When mapping multiple GL codes simultaneously, it is important to note that not all payroll items can be split by the same conditions.
The following items will have limited options available:
- ETP/Terminations
- On costs (Workcover, payroll tax)
- Superannuation (except super guarantee)
- Deductions
To map for multiple codes:
- Select Divide liability between codes in the top right.
- From the drop-down menu, select at minimum two codes.
- Choose the liabilities that will be divided into these codes.
- Select Map rules.
- On the left, select your conditions. You can divide expenses by up to 2 conditions.
The following items can be used to split your liabilities: - On the right, add the conditions to be met to map the liabilities to the codes.
- Optionally select Include fallback code. This will act as a catch-all code. If a liability doesn't trigger any rules you set up, it will fall into the selected code.
- Save, name your rule and confirm.
- Repeat these steps until all liabilities are mapped.
- Finish set up to save.
In the below example, we split the net payable liabilities into two wages payable accounts based on employment type.
Please note: The above is an example only and may differ for your business mapping.
With all your mapping done, you can now export your payroll ledger, ready for import into MYOB.
Please note: Your data is not locked to the Payroll ledger mapping. If something is wrong with how your data is exporting or with your mapping, you can edit your Payroll ledger mapping & re-run your report.
To run your Payroll ledger report:
- Navigate to Reports > Financial and select Payroll Ledger Export.
- Select Create report to the right of the paying entity you'd like the export for.
- Select your date range and optionally filter to specific employees.
- Select to run your report either by:
- Accrual Basis - Reports based on your period end dates.
- Cash Basis - Reports based on your payment dates.
- Create Report.
- The Payroll Ledger report will display the following fields:
- Narration - The name of the admin user generating the report.
- Date - The period ends or payment dates, depending on your selections.
- Description - The name of the accounts you mapped your payroll data into during the mapping process.
- Code - The codes you mapped your payroll data into during the mapping process.
- Tax Rate - This is imported with the Chart of Accounts and exported with the same detail.
- Debit - The value of expenses per your mapping.
- Credit - The value of your liabilities per your mapping.
- Tracking Option - The name of your tracking options, as seen in MYOB and set up during the mapping process.
- Select Export TXT.
- Your file will be ready to import directly into MYOB.
Hot tip: If there are any new or unmapped payroll items, a warning will appear at the top of your report. Allowing you to navigate back to your Mapping and review those items seamlessly.
What do we do if we change our Accounting structure?
You can reimport your Chart of Accounts and re-map anything that needs to be. If you are adding new accounts, none of your existing mapping will be affected. If you are removing accounts, only the mapped items will be affected.
I need assistance in importing my file into MYOB, and there are a few other issues from the MYOB end. Who do I go to get assistance on this?
That's understandable! Our foundU team members are experts in foundU but not MYOB, but the team at MYOB have a dedicated Support Centre with guides on all things MYOB and Support!
Access the MYOB Support Centre here!
What do I need to do if I add a cost code to the system and I'm dividing Journal Accounts by cost code?
If you are adding anything to the system that will impact your Journal Export (cost codes, operations, or office codes) you will need to edit your mapping to account for this.Having a fallback account is a good way to catch any values that have no rules assigned to them when diving payroll items. You should also be reconciling your Journal Export to ensure the values line up.
If you do notice that something has been missed, you can edit your mapping and re-run the report without issue.
A lot of our paying entities are set up similarly. Can we copy the mapping between them?
No. Payroll ledger mapping must be done per paying entity.Although your paying entities may be configured similarly, from a system-side there are differences between them. This includes which cost codes, Operations, and office codes are available to select within the paying entity.