Exporting pension data from QuickBooks Online
QuickBooks Online automatically generates pension contribution files when you run payroll. These files can be used to process both enrolments and contributions in the Penfold platform. The guide mentions that you can use templates like "Scottish Widows" or "The People's Pension" for this purpose. However, it's important to ensure that the exported data aligns with Penfold's requirements.
To export pension data:
Navigate to the Payroll section in QuickBooks Online.
Run the payroll for the desired period. After running payroll, QuickBooks will generate pension contribution files.
Download the appropriate pension file template (e.g., Scottish Widows or The People's Pension).
To format your contribution report:
QuickBooks has recently updated some their reports with few extra rows at the top of the file that need to be removed before uploading. Here’s what to do:
Open the file in Excel (or any spreadsheet program).
Delete the first 4 rows at the top of the file. These rows contain extra information and must be removed so the file can be processed correctly.
Make sure the column headings (like employee name, contribution amount, etc.) are now in the first row.
Save the file as a CSV.
You can now upload the file to the Penfold platform, ensuring that the EmployerID and Pay Period are correctly specified.
If you require further assistance with exporting pension data or ensuring compatibility with Penfold's platform, please let us know.