Skip to main content
R
rpm1602-gmail-co
August 29, 2024
Solved

How to export payroll data to CSV to upload to pension provider. I use Cushion for pensions, it doesn't have API, but requires CSV upload.

  • August 29, 2024
  • 1 reply
  • 0 views
Pension provider I use (Cushion) requires me to upload payroll information in PAPDIS format. I'm looking for ways to extract this information from QBO Standard Payroll.
Best answer by GeorgiaC

Hi rpm1602-gmail-co, thanks for getting back in touch

 

There's no way to change the file format in QuickBooks, but you can use a free online file converter to change this into CSV. You may still need to reformat after converting to meet the PAPDIS specifications. 

 

Thanks again for contacting Intuit support on the Community. We'll be here if you need any further support. 

1 reply

P
payment after leaving
August 29, 2024

Hi rpm1602-gmail-co It's possible to download the pension contribution report/CSV file from the Standard payroll system. Please select the reports option from the main menu > enter Workplace Pension in the 'Find a report by name' field or scroll down to the 'Payroll' section and select the report > select pension summary > save to your computer.

R
rpm1602-gmail-coAuthor
August 29, 2024

Thank you! I was able to download xls file containing latest report. Unfortunately it is not a CSV and not in PAPDIS format, so some transformation is required for me to be able to submit this to Cushion. Maybe there's an alternative way I'm missing, or is there a plan to export pension summary using standard format?

G
GeorgiaCAnswer
August 29, 2024

Hi rpm1602-gmail-co, thanks for getting back in touch

 

There's no way to change the file format in QuickBooks, but you can use a free online file converter to change this into CSV. You may still need to reformat after converting to meet the PAPDIS specifications. 

 

Thanks again for contacting Intuit support on the Community. We'll be here if you need any further support. 

Terms & ConditionsAccessibility statement