B.C. deadline: November 1, 2026

Turn your payroll register into B.C.'s pay transparency upload CSV.

Drop in your year-to-date payroll register as a CSV or Excel file. Then sort each pay code into the province's seven columns, following the rules in the government's guidance, and download a file that passes the Reporting Tool's checks. It all runs in your browser, so no payroll data is uploaded.

Try it free with your file C$149 / year

The problem

~8,500 first-time filers

From November 1, 2026, every provincially regulated B.C. employer with 50 or more employees must post a pay transparency report. In 2025 the rule applied to about 700 employers.

Your payroll system doesn't export it

The province's tool needs a 7-column CSV. A payroll register has dozens of pay codes: regular, stat, vacation, 4% vacation pay, OT 1.5, shift premium, car allowance, retro, severance…

The rules are easy to get wrong

Vacation taken counts as ordinary pay, but vacation paid out is excluded. Stat pay is never overtime. Overtime hours don't count as hours worked. Special Salary is only for lump sums with no set hours.

Every rejected row means another trip to Excel

The province's tool rejects a file row by row, for example when a row has hours but no ordinary pay, or overtime pay without overtime hours. This page runs the same checks as you map, and tells you how to fix each one.

The converter

Start with a payroll register covering one 12-month period: either the most recently completed calendar year or your fiscal year, ending no later than October 31 of the reporting year. You can export it one row per employee per pay code, or one row per employee with a column for each code. Use the YTD earnings or payroll register report.

Drop payroll register here or click to choose
.csv, .txt or .xlsx. The file is read locally and never uploaded.

1 · Columns

Header row Layout Employee ID column Pay code column Description column (optional) Hours column Amount column

2 · Gender

Use the marker each employee gave you: M, W or F, X, or U. Anyone who didn't provide one is reported as U.

Source Gender column

3 · Map each pay code

Suggestions follow the province's Guidance for Preparing Pay Transparency Reports. Rows highlighted orange are judgement calls, so read the note. Rows in red need a decision before you can download. Your choices are saved in this browser for next year.

Show only codes that need review

Pay code	Employees	Hours	Amount	Goes to	Why

4 · Options

Salaried staff with no recorded hours: use this many hours a year (leave blank to flag them instead) Leave out employees whose row the province would reject (record this under "Data Constraints")

5 · Result

Free preview: first 5 rows

Privacy

Nothing is uploaded. The page reads your file with your browser's own file reader. The page's Content-Security-Policy blocks all network requests (connect-src 'none'), so it couldn't send your data anywhere even if it tried.
You can check this. Open your browser's developer tools, go to the Network tab, and load a file: no requests appear. Or save this page and use it offline.
The output has no names or IDs. It has only the seven columns the province asks for. The only thing kept in your browser is how you mapped your pay codes, such as "REG → Ordinary"; no pay figures are stored.

Price

C$149 / employer / year

Free preview of the first 5 rows, plus the full validation report, before you pay
Full upload CSV and a mapping record to keep with your filing
Also covers next year's report: your mappings are remembered

Buy (C$149)

Checkout opens in a new tab, so your file stays loaded here. Once payment is done, this tab unlocks the download.

Bookkeeper or payroll provider?

If you file for several client employers, email CONTACT_EMAIL about a firm licence.

Is it accurate?

It applies the guidance's definitions, and it flags any code where the guidance depends on facts it can't see, such as whether a leave was paid at 100%. You decide those, and you're responsible for the final report.