If you want to generate job cost reports or link payroll data to accounting, start by importing a Payroll GL file — also known as a general ledger export — from your payroll provider.
Step 1: Export the File from Your Payroll System
Most payroll systems offer a general ledger export that summarizes wages, taxes, and deductions by GL account and employee. You might find it labeled as:
- Payroll GL
- Journal Entry Export
- General Ledger Posting
- Wage Expense Report
This file should include employee-level detail, not job-level allocation. That’s important — TradeSeal handles the job costing after import.
Step 2: Use Our Standard Format (If Needed)
If your payroll system doesn’t provide a usable export, or if you need to build the file manually, we support a simple format with the following key fields:
- GL Account Number
- Employee Name or ID
- Earning Type (e.g. Net Pay, 401k, Health)
- Debit and Credit Amounts
- Pay Date
Optional fields include:
- Hours
- Pay Rate
- Job number or phase (only if your payroll system includes it — not required)
Step 3: Import the File into TradeSeal
- Open the Payroll GL Import screen
- Upload your file and preview the data
- Once uploaded, TradeSeal will use this as the source of truth for payroll costs
- Our system will then apply job-level allocation based on your configured rules
✅ Pro Tips
- If you’re unsure where to find the report, your payroll rep can usually help
- GL files should show actual wages and deductions — not estimated or allocated values
- Don’t worry if job fields are blank — that’s expected. TradeSeal applies job costing afterward
Need help reviewing your file? We’re here to assist. Just send us a copy or ask your implementation specialist.