California DIR Certified Payroll - Import File (Sage 300 CRE)

We have to submit certified payroll for several projects on the California DIR portal and are wondering if anyone is able to download a file from Sage to import into the portal to avoid manual entry. If you are, will you please provide where and what report you download and import. Thank you.

Parents
  • 0

    Hi Dusty,

    Sage 300 CRE doesn't have a built-in export for this, but the DIR portal does accept an XML file upload, so manual entry isn't the only option. DIR publishes the file format in their CPR XML Upload guide.

    The certified payroll data you already keep in Sage (certified jobs, employees, classes, hours, rates, fringes and deductions) covers what that file needs. I'm a consultant and I build exports like this. It pulls straight from Sage for the job and week you pick and creates the XML file ready to upload. No retyping, and no third-party service to send your time to.

    The same approach works for other state portals too, like the Illinois one Jason mentioned.

    If you're still entering these by hand, send me a message and I can tell you what it would take for your setup.

Reply
  • 0

    Hi Dusty,

    Sage 300 CRE doesn't have a built-in export for this, but the DIR portal does accept an XML file upload, so manual entry isn't the only option. DIR publishes the file format in their CPR XML Upload guide.

    The certified payroll data you already keep in Sage (certified jobs, employees, classes, hours, rates, fringes and deductions) covers what that file needs. I'm a consultant and I build exports like this. It pulls straight from Sage for the job and week you pick and creates the XML file ready to upload. No retyping, and no third-party service to send your time to.

    The same approach works for other state portals too, like the Illinois one Jason mentioned.

    If you're still entering these by hand, send me a message and I can tell you what it would take for your setup.

Children
No Data