Exporting a finished pay run as payment ready files
Download four files from Payroll View, each ready for where it needs to go.
Once a pay run is finished, the figures still have to reach several different places. The bank needs to know what to pay each worker, HMRC needs the tax and National Insurance, and the pension provider needs the contributions. Rekeying all of that by hand is slow, and every retyped number is a chance to get one wrong.
Payroll View produces four files straight from the pay run, each formatted for its own purpose.
Before you begin
- Payroll is available on Agency Accelerator Pro.
- You need access to Payroll in Agency Accelerator.
- The run is the source of truth. Hours or shifts are multiplied by the rate to give gross pay, then PAYE tax, National Insurance and pension are deducted to give net pay. Every file below is drawn from that.
- Worker bank details and National Insurance numbers need to be on the worker's record, as they are carried into the files.
Draft files and final files
The same four files can be downloaded at two points:
- Before export, for checking. While the payroll is still a draft, select the download icon beside Hide zero rates. These files show the figures as they stand, and will change if you edit the payroll.
- After export, for paying and reporting. Once you have selected GENERATE EXPORT, the payroll is locked and a DOWNLOAD button appears in place of GENERATE EXPORT. These are the files to upload to your bank, HMRC and pension provider.
Please note: Only upload files downloaded after the export. A file downloaded from a draft may not match the final figures if anything was changed before the payroll was locked.
Downloading the files
- In the left hand menu, select Payroll, then Manage Payroll.
- Find the pay run under Exported Payrolls and select VIEW PAYROLL.
- Check the Exported on badge at the top, which shows the date the run was exported.
- Select DOWNLOAD.
- Choose the file you need: Download Payroll, NI Contribution Breakdown, Pension Contribution Breakdown or Bank Payment Breakdown.
- Repeat for the other files, as each one goes to a different place.
If you have not exported the run yet, see How to run and export a payroll first.
The payroll file
Chosen from Download Payroll. This is the full payroll for the period, with each worker's figures as they appear in Payroll View. Use it for your own records, for checking the run, or to pass to an accountant or payroll bureau.
The bank payment file
Chosen from Bank Payment Breakdown. This is the file you upload to your banking portal as a bulk payment, so every worker is paid in one go rather than one transfer at a time.
- One row per worker.
- Carries the worker's name and ID, their sort code and account number, and the amount to pay.
- The amount is net pay. Tax, National Insurance and pension have already been deducted, so the figure in the file is what lands in the worker's account.
The HMRC tax summary
Chosen from NI Contribution Breakdown. This is what you reconcile against your HMRC payment for the period.
- One row per worker, with their name and National Insurance number.
- The period start and end dates.
- PAYE tax and employee National Insurance for that worker for the period.
- Zero rated workers stay in the file, so the number of rows matches the pay run rather than quietly dropping people.
The pension contribution file
Chosen from Pension Contribution Breakdown. This is formatted for upload to your pension provider's portal, so the provider knows how much to collect and add. Providers such as NEST and The People's Pension then collect by Direct Debit.
- Only workers enrolled in the scheme are included, so the file is usually shorter than the others.
- Carries each worker's name, National Insurance number and date of birth.
- Shows pensionable earnings, and both the employee and the employer side of the contribution.
Points worth knowing
- The exact columns depend on your providers. Banks and pension providers each expect their own layout, so the precise columns in your files reflect the bank and the pension provider you use.
- The upload itself stays with you. The platform produces the files. Sending them to the bank, the pension provider or HMRC is still done by you from those files, in each of those portals.
- An exported run cannot be changed. Exporting locks the payroll, so the files you download after export will always match the locked run. If something needs correcting after export, download the files and edit them outside the platform, or contact our Support Team.
- Payslips are separate. These files are for paying and reporting on the run as a whole. Individual payslips and payment advices come from each worker's row in Payroll View. See Sending payslips to your workers from the pay run.
If something looks wrong
- There is no DOWNLOAD button. The run has not been exported yet. Use the download icon beside Hide zero rates to check the draft files, or select GENERATE EXPORT when the run is ready.
- A worker is missing from the bank file. Check they are in the pay run, and that their sort code and account number are held on their record, as the file is built from what is on the worker's record.
- A worker is missing from the pension file. The pension file only includes workers enrolled in the scheme, so a worker who is not enrolled will not appear.
- The bank has rejected the file. Check the file matches the format your banking portal expects, and check for a worker whose bank details are incomplete or have been entered with spaces or extra characters.
- The row count does not match your payroll. The HMRC summary keeps zero rated workers, while the pension file only carries enrolled workers, so the files will not all have the same number of rows.
- The figures do not match what you uploaded. Check whether the file was downloaded from a draft before export. Download it again from the DOWNLOAD button on the exported run.
If something still does not look right, get in touch with the Care Hires Support Team with the payroll reference, the pay period and the file you were working from.