Payrun conversion

  1. Home
  2. WCN Care Wiki
  3. Payroll
  4. Payrun conversion

This page outlines links to the payroll conversion scripts for WCN Care payroll processing. Any issues with these please contact payroll@wcncare.com directly.

Care Planner

Timesheet conversion

Care planner does not export easily to a data format that is useable. The bulk upload only gives a summary of hours or is in PDF format, with the PDF being slightly different for each employee, making conversion tricky.

To convert a copy of the monthly timesheets please follow these steps:.

  1. Make sure that all timesheets for the payrun period have been confirmed https://wcncare.nourishcare.com/finance/confirm
  2. Generate timesheets for the CAH staff https://wcncare.nourishcare.com/finance/payments
  3. Once generated you need to individually download each staff members timesheet in CSV format. The only way we can work out how to do that is to open each staff member individually and then click on the CSV export. You will end up with a file with the name in the format Timesheet_for_Joe Bloggs_2025-06-25_2025-07-24.csv Do this for all CAH staff. If you have done timesheets for the St Anne’s team as well, you will need to jsut make sure you pick the relevant team members from the list, cross referencing against FMS with a filter for CAH payroll may help.
  4. You should end up with a chunk of timesheets for individual staff members.
  5. Go to https://wcncarecareplannerhours-msuqdl7xyhggujrvxffsgw.streamlit.app
  6. Upload all of the individual CSV files to the page and wait for it to do its magic.
  7. You will end up downloading:
    • The combined hours
    • A list of totals to cross reference and check, and also outlines any mileage to be added
    • A list of holiday
  8. The holiday is handled strangely in Care Planner and clumps it into one day. Sometimes holiday is given across payrun dates (ie it crosses the 24th to 25th of the month).
    In order to add holiday you need to manually take the holiday CSV and check the holiday hours. Any days over 12 hours need to be split into individual days. So for example:
    • Holiday listed as 48 hours on the 07/07/25
    • Split this into 4 12 hour days and create extra rows for the 7,8,9,10 of July.
  9. Once done copy and paste the days to the end of the combined CSV list for import into Upsheets.

Brightpay

This is V1 of the Brightpay convertor that uses Findmyshift data to convert to a Brightpay standard.

You will need the findmyshift report of hours export as a summary csv file.

https://wcncarebrightpay-tepzojvdcrak4cw3wnbjmp.streamlit.app