Moneysoft to Xero Payroll Journals: Complete Guide

Moneysoft Payroll Manager is widely used by UK accountants and payroll bureaux. Recent BrightPay price increases have also led some firms to review alternative payroll software.

The payroll processing itself is usually straightforward. The challenge often comes afterwards: creating a payroll journal that can be posted into Xero accurately and consistently every month.

Many firms still rely on spreadsheets and manual journal preparation. Others are increasingly looking for ways to automate Moneysoft payroll journals without uploading sensitive payroll data to external servers.

A common challenge for Moneysoft payroll users

A recent AccountingWEB discussion highlighted a common question for firms using Moneysoft Payroll Manager: how to create payroll journals for accounting software such as Xero.

The approaches discussed included:

• Exporting payroll reports to CSV
• Updating the previous month's journal
• Re-ordering spreadsheet data
• Re-keying payroll totals
• Posting a consolidated payroll journal

All of these methods can work.

For smaller payroll volumes, preparing payroll journals manually may only take a few minutes each month.

The challenge often appears as payrolls become more complex or practices manage multiple payroll clients.

Common changes include:

• New starters and leavers
• Pension contribution changes
• Employment Allowance adjustments
• Department or cost centre reallocations
• Weekly and monthly payroll frequencies
• Bonus runs and irregular payments

The payroll calculations themselves are usually straightforward. The time is often spent reviewing changes, updating journals, and ensuring postings remain accurate and consistent from period to period.

For firms processing multiple payrolls each month, maintaining a reliable journal process can become more time-consuming than creating the original journal template.

The AccountingWEB discussion provides an interesting snapshot of how practices currently prepare Moneysoft payroll journals.

What a Xero payroll journal should include

A typical Moneysoft to Xero payroll journal may include:

• Gross wages
• PAYE liability
• Employee NIC
• Employer NIC
• Pension deductions
• Net pay
• Employment Allowance adjustments
• Department or tracking category splits

The exact structure depends on how the firm wants payroll costs and liabilities to appear in Xero.

Some firms prefer detailed journals split by department or cost centre.

Others prefer one consolidated journal for the entire payroll.

Either approach can work provided the journal remains balanced and easy to reconcile.

Manual method

A common manual process is:

1. Finalise the pay run in Moneysoft

2. Export the Employee Pay Totals report

3. Export the Employer's NIC Allowance report if Employment Allowance applies

4. Map the figures to Xero nominal codes

5. Create or update the payroll journal

6. Check that debits and credits balance

7. Import or post the journal into Xero

8. Reconcile the payroll control accounts

This works, but it relies heavily on spreadsheets and manual checks.

A more repeatable approach

For firms handling multiple payroll clients, consistency is often more important than the journal template itself.

A typical payroll journal process includes:

• Extracting payroll figures
• Mapping figures to accounting codes
• Reviewing payroll changes
• Checking the journal balances
• Posting the journal
• Reconciling payroll control accounts

A structured process can reduce manual effort and make payroll journals easier to review each period.

Using MS Payroll Bridge

MS Payroll Bridge converts Moneysoft payroll reports into balanced payroll journal CSV files for Xero.

The process takes three steps:

1. Drag your Moneysoft payroll CSV reports into the browser

2. Review mappings and settings

3. Download a Xero-ready payroll journal CSV

All processing takes place in your browser.

Payroll data is not uploaded to external servers, stored in cloud databases, or retained after conversion.

Once loaded, payroll journals can even be generated with your internet connection disabled.

This allows firms to prepare payroll journals directly from Moneysoft reports without manually updating spreadsheet templates.

The aim is not to replace payroll review procedures, but to reduce repetitive journal preparation work.

For more information, visit our Security page or try the Interactive Demo.

Conclusion

Moneysoft is strong payroll software, but creating Xero-ready payroll journals is still a manual process for many firms.

For a small number of payrolls, re-keying or updating a previous journal may be perfectly reasonable.

For practices handling multiple payroll clients, the bigger issue is maintaining a process that is:

• Fast
• Accurate
• Consistent
• Easy to reconcile

If you currently export payroll reports, update spreadsheets and manually prepare journals each month, standardising the process can save significant review time and reduce posting errors.

That is where a repeatable Moneysoft to Xero payroll journal workflow becomes valuable.

Related payroll journal guides

• How to Export Payroll Journals from Moneysoft
• How to Post Employment Allowance in Xero Payroll Journals
• Payroll Journal Automation for UK Accountants