Setting up your mapping within Thesaurus Payroll Manager


Please note: the following guidance is for users wishing to post journals to Quickbooks, Sage Line 50 or Xero. A separate journal utility is available for Surf Accounts. Please click here for Surf Accounts journal guidance.


Utilities > Accounts Export > Mapping of Nominal Ledger:



Mapping tells the payroll where things get posted to in the accounts software.


For example, you may have a nominal ledger account in your accounts program called "Wages and Salaries" and this is where you may want to post the wages and salaries costs from the payroll. If there are directors, you may want to see their costs separated out into another account, possibly called "Directors Pay".


The taxes deducted will usually be posted to a liability account, possibly called "Payroll Taxes".


The actual employee payments will be posted either directly to the relevant bank account or to a liability control account, sometimes called the "Salary Control Account" or "Wages Control". The advantage of the former is that cheques/debits may not need to be separately posted within your accounts software as they will already have been posted in the payroll journal. The advantage of the latter is that it provides a useful way of reconciling both sets of entries. In the case of the latter, cheques/debits would also be posted to this control account within your accounts software.


Other payroll items may also require mapping e.g. employer pension costs, pension liabilities outstanding etc.


In some accounts packages, a numerical code is needed to accurately identify the nominal account


e.g. 7000 - Employee Costs (Sage), 477 - Wages and Salaries (Xero)


In such cases, you should enter the numerical code within Thesaurus Payroll Manager. Optionally you can follow the code with a hyphen and a description

e.g. 477

or 

477 - Wages and Salaries


Entering the description is preferable as the journal printout, from within the payroll software, will make more sense with descriptions.

 

Thesaurus Payroll Manager will ask you 5 questions and this may be all of the information required to generate accurate payroll journals.


If the answer to 2 of these questions (directors and pensions) are affirmative, then some more input may be required. Ask your accountant if you are not sure of anything.


You can also provide the software with some optional nominal account details you might want to use for the detailed mapping e.g. you may want to map one of your "Non tax allowable deductions" to "Staff Loans".


The second screen allows you to specify the detailed mapping, although in the majority of cases you can accept the mapping as proposed by Thesaurus Payroll Manager, which it will have populated from the answers you supplied on the first screen.

In relation to departments or cost centres, there is no mapping of these and if you want to benefit from departmental details being included in the accounts journals, it will be necessary that the departments/cost centres have the same name in both software packages.

 

 

Once your mapping is complete, simply access Utilities > Accounts Export > Create Export File to generate your CSV file for upload. 






Accounting software providers currently catered for within this functionality are:

  • Quickbooks

  • Sage Line 50

  • Xero Online Accounts

 

Please note: a separate journal utility is available for Surf Accounts. Please click here for guidance.

 

Need help? Support is available at 01 8352074 or thesauruspayrollsupport@brightsg.com.

HelpYear End 20232024 Thesaurus Payroll Manager - System RequirementsSigning into Connect for 20242024 Budget - Employer Summary2024 Payroll Manager - AvailabilityStarting the New Tax YearImporting from the previous yearMoving to Thesaurus Payroll Manager from another softwareGetting started - First Time UsersCompany SetupDigital CertificatesAdd/ Amend EmployeesRevenue Payroll Notifications (RPNs)Payroll CalendarProcessing PayrollPayroll DeductionsPayroll Submission Requests (PSRs)Distributing PayslipsPaying EmployeesCorrectionsRevenue PaymentsRevenue - Contact Telephone NumbersReportsProcessing StartersProcessing LeaversBenefit in KindStatutory Sick Pay (SSP)Illness BenefitParenting BenefitsPensionsChanging an Employee's Pay FrequencyPayroll JournalsBackup and RestoreTransferring Payroll Manager from one PC to anotherCSOHolidaysLeave EntitlementsEmployment LawGeneralGlossary of Terms (Pre 2019)Thesaurus ConnectGDPRLicence Agreement for Thesaurus Payroll ManagerBright IDEnhanced Reporting Requirements (ERR)