--- title: How to Upload Payroll Hours with a Custom CSV Template & Map DOL Classifications description: Article on how to use CSV Configuration tool in Reunion --- [Skip to content](https://help.reunioninfra.com/how-to-upload-payroll-hours-with-a-custom-csv-configuration-0#main-content) [![Reunion\_Logo\_White (1)](https://help.reunioninfra.com/hs-fs/hubfs/Reunion_Logo_White%20(1).png?width=250&height=92&name=Reunion_Logo_White%20(1).png)](https://help.reunioninfra.com/?hsLang=en) - [Go to reunioninfra.com](https://www.reunioninfra.com/) - [Submit a support ticket](https://help.reunioninfra.com/kb-tickets/new) Open main navigation Close main navigation - [Go to reunioninfra.com](https://www.reunioninfra.com/) - [Submit a support ticket](https://help.reunioninfra.com/kb-tickets/new) - Hi there, how can we help? - There are no suggestions because the search field is empty. 1. [Reunion Help Center](https://help.reunioninfra.com/?hsLang=en) 2. [Importing Data](https://help.reunioninfra.com/importing-data?hsLang=en) # How to Upload Payroll Hours with a Custom CSV Template & Map DOL Classifications ## Learn how to upload payroll hours to a contract in Reunion using your custom CSV template, then complete work classification mapping to ensure your compliance calculations are accurate. ### Before you start: - You successfully created a payroll template using the **[Custom CSV Configuration](https://help.reunioninfra.com/how-to-upload-payroll-hours-with-a-custom-csv-configuration?hsLang=en)** tool located in the "CSV Upload" tab. - You have a CSV export from your payroll system that contains each employee’s **work classification** and level (apprentice, journeyworker). - If any employees included in the payroll data are apprentices, set up the **[apprenticeship program](https://help.reunioninfra.com/how-to-add-an-apprentice-program-in-reunion?hsLang=en)** in advance for efficiency. - You know which project **contract** and **contractor** the hours should be uploaded to. --- #### 1. Go to the **CSV Upload** page in Reunion. #### 2. Under the Custom CSV Template you created, click on the green **"Upload CSV"** button. ![Screenshot 2026-05-28 at 6.11.21 PM](https://help.reunioninfra.com/hs-fs/hubfs/Screenshot%202026-05-28%20at%206.11.21%20PM.png?width=670&height=159&name=Screenshot%202026-05-28%20at%206.11.21%20PM.png) #### 3. You will be prompted to select the applicable **Contract** and **Contractor** to add data to. Once selected, click the "Upload CSV" button to continue adding the file. NOTE: it is important that your CSV columns with dates are formatted as "dates" in your CSV before you upload. ![Screenshot 2026-05-28 at 6.07.20 PM](https://help.reunioninfra.com/hs-fs/hubfs/Screenshot%202026-05-28%20at%206.07.20%20PM.png?width=419&height=268&name=Screenshot%202026-05-28%20at%206.07.20%20PM.png) #### 4. Once the CSV file begins to process, a progress panel will appear on the right side of the screen with the upload status. Once you see the green "Success" badge next to the contractor's name, you can exit out of the side panel. #### ![Screenshot 2026-05-28 at 8.03.00 PM-1](https://help.reunioninfra.com/hs-fs/hubfs/Screenshot%202026-05-28%20at%208.03.00%20PM-1.png?width=670&height=448&name=Screenshot%202026-05-28%20at%208.03.00%20PM-1.png) ### Last step for proper data ingestion: [Work Classification Mapping](https://help.reunioninfra.com/integrations-page-mapping-work-classifications?hsLang=en) **What is work classification mapping?** Work classification mapping connects the craft and classification names from your payroll data to their corresponding Department of Labor (DOL) classifications. This step is required for accurate prevailing wage and apprenticeship compliance calculations. When you upload payroll data via CSV or sync it through an LCP integration, Reunion pulls in the classifications exactly as they appeared in your payroll system's CSV. Because those names often differ from the official DOL classification names, you need to confirm the correct match for each one. A few things to know before you start: - Mapping is done per classification, not per employee. Once a classification is mapped, it applies automatically to every employee under that classification. - Mapping is required each time a new contract is created, and when an employee appears on a payroll report for that contract for the first time. - Selecting the wrong DOL classification will affect compliance calculations, so take care to confirm the correct match. #### 1. Navigate to the "Integrations" page- "Work Classification Mapping" tab Map your employee's craft/classification to the DOL classification/Reunion Work Classification where indicated "Mapping required" ![Screenshot 2026-05-29 at 3.51.40 PM](https://help.reunioninfra.com/hs-fs/hubfs/Screenshot%202026-05-29%20at%203.51.40%20PM.png?width=670&height=246&name=Screenshot%202026-05-29%20at%203.51.40%20PM.png) #### 2. Click the three ellipses to the right of the "Mapping required" to "Edit" The "Craft" and "Classification" shown are what came from your CSV of data. You need to map the Reunion work classification/DOL classification that matches it below. #### 3. Click into "Construction Type" to select from the drop down options ![Screenshot 2026-05-29 at 3.57.29 PM](https://help.reunioninfra.com/hs-fs/hubfs/Screenshot%202026-05-29%20at%203.57.29%20PM.png?width=670&height=613&name=Screenshot%202026-05-29%20at%203.57.29%20PM.png) #### 4. Scroll through the applicable DOL classifications that associate to that project/contract and select the appropriate one and "save" ![Screenshot 2026-05-29 at 3.59.02 PM](https://help.reunioninfra.com/hs-fs/hubfs/Screenshot%202026-05-29%20at%203.59.02%20PM.png?width=670&height=615&name=Screenshot%202026-05-29%20at%203.59.02%20PM.png) #### 5. Click "Confirm & Save" ![Screenshot 2026-05-29 at 4.00.52 PM](https://help.reunioninfra.com/hs-fs/hubfs/Screenshot%202026-05-29%20at%204.00.52%20PM.png?width=670&height=354&name=Screenshot%202026-05-29%20at%204.00.52%20PM.png) This mapping for that specific classification will then apply to all employees associated to that craft/classification in your data #### You can also follow our article on these steps here: [Integrations page: Work Classification Mapping](https://help.reunioninfra.com/integrations-page-mapping-work-classifications?hsLang=en) ### Other tips: Filter the Work Classification Mapping table to simplify your viewing experience (ex: showing only "Unmapped" classifications needing to be done ![Screenshot 2026-05-29 at 4.02.47 PM](https://help.reunioninfra.com/hs-fs/hubfs/Screenshot%202026-05-29%20at%204.02.47%20PM.png?width=670&height=589&name=Screenshot%202026-05-29%20at%204.02.47%20PM.png) - [Getting Started](https://help.reunioninfra.com/getting-started?hsLang=en) - [Importing Data](https://help.reunioninfra.com/importing-data?hsLang=en) - [Contractors, Contracts, and Employees](https://help.reunioninfra.com/contractors-contracts-and-employees?hsLang=en) - [Apprenticeship Programs & Good Faith Efforts](https://help.reunioninfra.com/apprenticeship-programs-good-faith-efforts?hsLang=en) - [Penalties & Cure Payments](https://help.reunioninfra.com/penalties-cure-payments?hsLang=en) - [Regulations](https://help.reunioninfra.com/regulations?hsLang=en) - [Account Management](https://help.reunioninfra.com/account-management?hsLang=en) - [Settings Page](https://help.reunioninfra.com/settings-page?hsLang=en) - [Go to reunioninfra.com](https://www.reunioninfra.com/) - [Submit a support ticket](https://help.reunioninfra.com/kb-tickets/new) [![Logo green mark](https://help.reunioninfra.com/hs-fs/hubfs/Logo%20green%20mark.png?width=200&height=33&name=Logo%20green%20mark.png "Logo green mark")](https://help.reunioninfra.com/?hsLang=en) Not investment or legal advice. This content is for informational purposes only; you should not construe any such information or other material as legal, tax, investment, financial, or other advice. All content on this site is information of a general nature and does not address the circumstances of any particular individual or entity. Copyright © 2026, Reunion Infrastructure