LCPtracker upload and template errors: what fails and how to fix it

What the help site says about upload failures

The limits and rules on this page come from LCPtracker's own articles. The LCPcertified Plus guide is cited only for craft match, the LCPcertified QuickBooks article only in its own section, and this page did not check LCPcertified's limits.

The Upload Records article says the system gives a pop-up for rows it does not accept. The help text does not quote the wording, and this page does not guess at it.

Searches of kb.lcptracker.com on November 4, 2026 for sage and adp returned no articles, and bad request returned one release brief for a different product, VantagePoint. The vendor's payroll providers page, as read that day, lists ADP Workforce Now but not Sage or QuickBooks, and the Quick Start Guide calls the provider list inside the product partial. For Sage or QuickBooks, build the file to the template from your payroll export.

Template rules that trip up a file

The template guide has a color legend this page cannot show, and the Upload Records article says your download carries its own instructions and legend, so follow the legend in your file. The guide's video file path is dated July 2024, so check its column letters against your download. The vendor says the most current file is in any contractor account, under Upload Records, and that you fill in Sheet 1. Rules below are from the guide unless noted.

The 200 record limit and how to split a file

The Excel template upload is limited to 200 payroll records (splitting guide). That guide counts lines, so count the rows in your template. Its Excel macro copies row 1 into each new workbook as the header and writes 199 data rows per file, and it says to upload the files one after another.

Craft match: why a craft shows Not Available

The template guide says your class_code must be mapped in LCPtracker to a prevailing wage craft code, and a blank one defaults to Not Available. The vendor says to craft match the first time you upload and whenever you upload a new employee (Upload Records): open Edit Uncertified Payroll Records, click Craft Match, choose the craft and classification, and save. Later uploads should then fill it in.

The match is per project. The Add/Remove Craft Match article says a match must be made for each project, and one contractor craft name can match only one LCPtracker craft name per project and county.

The LCPcertified Plus guide also calls for a craft match the first time and for new employees, but scopes it to anyone in California using the California State rates, or anyone who entered their own Rate Sheet. For others it says editing each uploaded record is optional.

Address prompts after an upload

If the address in your file does not exactly match the validated address, including a different format of the same address, LCPtracker treats it as new and prompts you to validate it (vendor article). The vendor's tip is to validate the address, then remove the address information from the file and upload without it. The article does not limit the tip to unchanged addresses. Our own caution: blank the columns only where the address has not changed, and ask Support first for a new employee, since the template guide marks address 1, city and state Required.

The prompt can also be a genuine move. The Employee Address History article says an upload with a different address is added to the employee's profile with an estimated move-out date, and a validation flag asks you to review it before you certify. If the file's week-end date is under 30 days from the upload, the file's address becomes current. Over 30 days, the current address stays and the file's address goes to history. The article advises uploading your oldest payroll first.

Validation notices tied to SSN and address

The Validation Settings article says checks 31 through 42 exist mainly to stop uploaded payrolls from being certified without proper information, and it shows no message for them.

Checks 32 to 45 and 59 default to off, and a Notice with Enforce means you cannot certify until it is cleared (Address Validation for VAL_59). VAL_31, the Not Available craft check, defaults to Warning/Alert, which still lets a contractor certify; the vendor recommends Notice/Enforce, which blocks certification until it is cleared. Our rejected payroll guide covers the wage checks.

PDF reports and payroll software exports

You cannot upload a PDF payroll report directly. The vendor says you must purchase DPI, a fee-based service. For DPI you send four sample reports, and LCPtracker says building a model of your file can take anywhere from three to four business weeks. It quotes pricing on request.

QuickBooks: two articles, two products

If you are unsure which product you have, ask Support. See also our QuickBooks guide.

Who to call

LCPtracker Support: (714) 669-0052, option 4, support@lcptracker.com or live chat, Monday through Friday, 5:00am to 5:30pm PST (Quick Start Guide). For signing trouble, see eSignature problems.

What we do

WellStanding prepares the payroll documents your LCPtracker job needs from the payroll export you already run, and a person reviews them. You review and sign; the certification is always yours and we never sign for you.

Questions