Exporting payroll to Xero, Sage, or BrightPay

Three export formats

Blankitt HR ships with CSV exports for three external systems. All three become available once the pay run is finalised (not draft).

Xero — manual journal

Format: balanced double-entry manual journal ready to import via Xero > Accounting > Manual journals > Import.

Default account codes used (override in Settings > Payroll > Export > Account codes):

• 477 Wages and salaries
• 478 Employer NI
• 479 Pension employer contributions
• 814 Wages payable
• 815 PAYE/NI payable to HMRC
• 816 Pension payable

The export creates one balanced journal per pay run, dated as the payment date.

Sage 50 Payroll

Per-employee CSV in Sage's import format: National Insurance number, surname, forename(s), tax code, hours, gross, etc.

BrightPay

Per-employee CSV in BrightPay's variable-pay import format. Note: BrightPay requires Surname and Forename split (not "Full name"), which the export handles for you.

How to download

1. Open the finalised pay run.
2. Click Export in the top-right.
3. Pick the format.
4. The CSV downloads — open in Excel or import directly into your accounting / payroll software.

What's NOT included

These CSVs are convenience exports for accounting. They are not HMRC RTI submissions — RTI (FPS / EPS) is coming in a future update. For now you'll need to file RTI through your existing payroll system (e.g. BrightPay) using the exported data.