To prepare payroll data for Xero or MYOB, collate your approved timesheets for the pay period, apply the correct award rates, penalties, and overtime, then export the hours as a file mapped to each employee’s payroll record and the right pay item (earnings) codes. The cleanest method is a direct payroll integration that formats the data in the exact shape each system expects and matches employees by ID rather than name — so it imports first time, ready for you to run pay and lodge Single Touch Payroll (STP).
Exporting timesheet data to Xero or MYOB is one of the most error-prone steps in payroll processing if done manually. Incorrect employee names, mismatched pay codes, formatting issues, and calculation errors all create problems that delay payroll and frustrate staff. The solution is implementing proper payroll integration that prepares data correctly the first time, eliminating the manual work and reducing errors that come from copying information between systems.
This guide explains how the payroll export process to Xero and MYOB works, the setup each system needs before your first import, the common mistakes that cause import failures, and practical steps for ensuring your timesheet data transfers cleanly every pay period. We cover both manual CSV export approaches and automated integration methods that eliminate most of the work entirely.
Quick summary
- The format:
Xero and MYOB require specific CSV structures with employee identifiers, pay item codes, and hours/amounts
- The rates:
Award rates, penalties, and overtime must be calculated before export to ensure correct payment
- The pitfalls:
Common errors include mismatched employee names, incorrect pay codes, and formatting issues
- The fix:
Automated integration eliminates manual export work and dramatically reduces errors
What to set up before your first export
Before any timesheet data can flow into Xero or MYOB, both the employee and the payroll settings have to exist on the accounting side. A clean export is only half the job — if the receiving system isn’t configured, even a perfect file will fail. Make sure the following are in place first:
- Employee records with a Tax File Number (TFN) declaration — each employee must be set up in your payroll system with their TFN declaration lodged, so PAYG is withheld correctly. See our glossary entry on PAYG withholding for how this is calculated.
- Super fund and bank account details — needed to pay wages and meet superannuation guarantee obligations on payday.
- Pay items / pay categories — earning codes for ordinary hours, overtime, penalties, and allowances must already be configured. You can’t create new pay items through a CSV import.
- A valid pay calendar — pay period dates in your export must fall inside a pay calendar (Xero) or pay cycle (MYOB) that already exists.
- STP enabled with the ATO — your business must be registered for Single Touch Payroll so each pay run can be reported.
Get these prerequisites right once and every subsequent pay period becomes a matter of exporting approved hours.
What Xero and MYOB require for payroll imports
Both Xero and MYOB accept payroll data through CSV file imports, but each has specific requirements. Understanding these requirements helps whether you’re exporting manually or setting up automated payroll integration.
Xero’s payroll import format requires columns for employee name or ID, pay item codes for different earning types (ordinary hours, overtime, allowances), hours or amounts for each pay item, and the pay period dates. Xero matches imported employees to existing payroll records using either email addresses or employee IDs, so these must match exactly between systems.
MYOB has similar requirements but uses its own pay item structure. MYOB AccountRight and MYOB Business have slightly different import formats, so you need to ensure your export matches whichever MYOB product you’re using. MYOB typically identifies employees by card ID or employee number rather than email, and is less forgiving of format variations than Xero.
Both systems require that pay items (earning codes for ordinary hours, overtime, penalties, allowances) already exist in your payroll setup. You can’t create new pay items through CSV import — they must be configured first. This means your time and attendance system needs to map to the pay items that exist in your accounting system. For a step-by-step walkthrough of configuring pay items, pay templates, and the full timesheet-to-Xero workflow, see our Xero payroll training guide.
Common payroll export errors and how to avoid them
Most payroll import failures stem from predictable issues:
Employee name mismatches
Slight variations in names between systems (John Smith vs J. Smith) cause import failures. Use employee IDs instead of names when possible.
Incorrect pay item codes
Using pay codes that don’t exist in your payroll setup or spelling them incorrectly causes the entire import to fail.
Date formatting issues
Dates must be in the exact format your accounting system expects (DD/MM/YYYY vs MM/DD/YYYY). Wrong format equals failed import.
Missing rate calculations
Exporting raw hours without calculating penalty rates and overtime means payroll won’t be correct even if the import succeeds.
CSV formatting problems
Incorrect delimiters, missing headers, or extra columns confuse the import process, leading to rejected files or data in wrong fields.
Duplicate entries
Importing the same pay period twice or including employees multiple times creates overpayment and requires manual correction.
The four checks that catch most failed imports
Before you upload a file, verify these fast — they account for the majority of rejected imports:
- Employee identifiers match exactly — a trailing space or changed surname silently drops that employee.
- Hours are in decimal, not time format — 7 hours 30 minutes must read as
7.5, never7:30or7.30. - Every pay item code is mapped — each earnings type in the file needs a matching code already set up in Xero or MYOB.
- Dates sit inside a valid pay calendar — and use the exact format the system expects.
For the full data-quality routine that keeps these problems out of your export in the first place, see cleaning payroll data before it reaches Xero or MYOB.
Step-by-step process for manual payroll exports
If you’re currently exporting manually, following a consistent process reduces errors:
1. Ensure timesheets are approved
Don’t export until all timesheets for the period have been reviewed and approved by managers. Approved timesheets indicate hours are verified and ready for payment. Strong timesheet approval workflows make this the default rather than a scramble.
2. Calculate award rates and penalties
Apply Australian award rates including ordinary hours, penalty rates for weekends/nights, overtime multipliers, and allowances. These calculations must happen before export so totals are correct.
3. Generate the export file
Export timesheet data as CSV in the format required by your payroll system. Include employee identifiers, pay item codes, hours/amounts, and pay period dates.
4. Review the export before importing
Open the CSV file and spot-check that total hours match expectations, all employees are included, pay codes are correct, and there are no obvious formatting issues.
5. Import into Xero or MYOB
Use your payroll system’s import function to load the CSV file. Watch for error messages and address any issues before finalising the import.
6. Verify totals, run pay, and lodge STP
Compare total wages to previous pay periods to catch obvious errors. Once verified, process the payroll run, generate payments, and report the pay run to the ATO through Single Touch Payroll.
Reporting the pay run through Single Touch Payroll
Importing timesheet data and running pay is only complete once the pay run is reported to the ATO. Under Single Touch Payroll (STP), employers must lodge wages, PAYG withholding, and super information to the ATO each time they pay staff — not once a year. Both Xero and MYOB have STP built in, so once the imported data is verified and the pay run is finalised, you lodge the STP report directly from the payroll system, usually with an authorised sender confirming the submission.
The practical implication for your export is that the data reaching payroll has to be right before you lodge — STP reports what you actually paid. Getting the hours, PAYG withholding, and super correct at the export stage means the STP lodgement is accurate too. If a mistake slips through, you can usually correct it in the next pay event, but it’s far cleaner to catch it earlier — which is exactly what a validated export and a good set of automated payroll checks are designed to do.
Benefits of automated payroll integration
Moving from manual CSV exports to automated integration provides substantial benefits beyond just time savings. Integrated systems handle all the technical details — formatting, pay code mapping, rate calculations — automatically, so data flows cleanly from time tracking to payroll without manual intervention.
Award rate calculations happen automatically as employees work. When someone clocks in on a Sunday, the system knows this attracts penalty rates and calculates them correctly. Overtime thresholds are tracked in real time. All this complexity is resolved before you even think about payroll export, ensuring the data that reaches Xero or MYOB is already correct.
Employee matching happens through ID mapping rather than name matching, eliminating the single biggest cause of import failures. The integration knows which employee in your time system corresponds to which employee in your payroll system, regardless of name variations or typos. Removing this manual handling is also one of the fastest ways to clear common payroll processing bottlenecks.
Essential features for payroll integration
When evaluating a Xero or MYOB payroll export capability, look for these features:
One-click export
Export approved timesheets to payroll with a single button press, no file manipulation required.
Automatic rate calculation
Award rates, penalties, overtime, and allowances calculate automatically based on Australian awards.
Pay code mapping
Configure which time tracking earning types map to which payroll pay items once during setup.
Employee synchronisation
Link employees between systems once, then exports use these mappings automatically preventing name-matching errors.
Validation before export
System checks for issues like unapproved timesheets or missing pay rates before allowing export.
Multiple format support
Export to Xero, MYOB AccountRight, MYOB Business, and other Australian payroll systems.
Setting up payroll integration
Implementing payroll integration requires initial setup but saves significant time ongoing:
- Connect the systems: Link your time tracking system to Xero or MYOB using API credentials or authorised access. This creates the technical connection between platforms.
- Map employees: For each employee in your time tracking system, specify which payroll employee record they correspond to. This is usually done by selecting from a list rather than typing names.
- Configure pay codes: Map earning types (ordinary hours, overtime, penalties, allowances) from your time system to pay items in your payroll system. This tells the integration where each type of hour should go.
- Set award rules: Configure which Australian award applies to each employee or role, so the system knows which rates and conditions to apply when calculating wages.
- Test with a sample export: Run a test export for a single pay period and verify it imports correctly into your payroll system before using it for real payroll processing.
- Train payroll staff: Show whoever processes payroll how to export data and what to check before finalising each pay run, even though the process is now much simpler.
How RosterElf integrates with Xero and MYOB
RosterElf provides native integration with Australian payroll systems:
- Direct Xero and MYOB integration: Export approved timesheets directly to Xero Payroll, MYOB AccountRight, or MYOB Business with one click. No CSV files to download and upload manually.
- Australian award calculations: Built-in award interpretation for hospitality, retail, healthcare, and other awards automatically calculates penalty rates, overtime, and allowances before export.
- Employee and pay code mapping: Set up employee and pay item mappings once during configuration. After that, exports use these mappings automatically without manual selection.
- Pre-export validation: The system checks that all timesheets are approved, rates are configured, and employees are mapped before allowing export, preventing incomplete data.
- Multi-location support: For businesses with multiple sites, exports include location tags so you can allocate labour costs to the correct location in your accounting system through your rostering platform.
- Export history and audit trails: See exactly what was exported when, providing clear records for compliance and making it easy to reference previous pay periods managed through the HR hub.
Related RosterElf features
Send clean payroll data to Xero and MYOB every pay run. RosterElf calculates award rates, penalties, and overtime automatically, matches employees by ID, and exports approved timesheets straight to your accounting system — ready to run pay and lodge STP.
Disclaimer
This article provides general guidance only and does not constitute legal or financial advice. Award conditions and workplace laws change over time. Always verify current requirements using official Fair Work Ombudsman resources before making employment decisions.
Frequently asked questions
How do I export timesheets to Xero or MYOB?
Use a payroll integration through your time tracking system. Approved timesheets export directly with employee names, hours worked, pay rates, and earnings codes already formatted for your payroll system. This eliminates manual data entry and reduces errors using payroll integration.
What format do Xero and MYOB require for payroll imports?
Xero and MYOB accept CSV files with specific column structures including employee identifier, pay item codes, hours or amounts, and pay period dates. Hours must be in decimal format (7.5, not 7:30). Each system has slightly different requirements, but quality payroll integration software formats exports correctly for each platform automatically.
Can I automate payroll export to Xero and MYOB?
Yes, integrated systems can export approved timesheets directly to Xero or MYOB with one click. Some platforms offer scheduled automatic exports after timesheets are approved, eliminating manual export steps entirely. This automation significantly reduces payroll processing time.
How do I handle award rates in payroll exports?
Time and attendance systems with Australian award interpretation calculate penalty rates, overtime, and allowances before export. The payroll file includes separate line items for ordinary hours, overtime, penalties, and allowances, properly coded for your accounting system.
What do I need to set up in Xero or MYOB before importing payroll data?
Each employee must exist in your payroll system with a Tax File Number declaration, super fund, and bank details, and your pay items (earning codes), pay calendar, and Single Touch Payroll registration must be configured. You can’t create pay items through a CSV import, so these prerequisites need to be in place first. A direct payroll integration then maps your rostered hours to those existing records automatically.
Do I still need to report to the ATO after importing to Xero or MYOB?
Yes. Importing timesheet data and running pay does not report anything to the ATO by itself. Under Single Touch Payroll you must lodge each pay run — wages, PAYG withholding, and super — from Xero or MYOB every time you pay staff. Because STP reports what you actually paid, getting the PAYG withholding and hours right at the export stage keeps the lodgement accurate too.
What causes payroll import errors in Xero and MYOB?
Common errors include mismatched employee names between systems, incorrect pay item codes, hours in time rather than decimal format, missing or invalid dates, and formatting issues in the CSV file. Using integrated payroll integration prevents most errors by ensuring data is formatted correctly from the start.
How do I verify payroll data before importing?
Review the export file before importing to verify total hours match expectations, pay rates are correct, all employees are included, and special payments like overtime are calculated properly. Running automated payroll checks and comparing current to previous pay periods catches most issues before they reach payroll.
Can I export multiple locations separately to payroll?
Yes, multi-location businesses can export payroll data with location tags for cost allocation in your accounting system. Employees who worked at multiple locations have their hours split appropriately, allowing accurate labour cost tracking by site while maintaining single payroll records per employee.
How does clean payroll data fit with AI in accounting?
AI accounting and forecasting tools are only as accurate as the data feeding them, so clean, structured timesheet and labour-cost data is exactly the input they need. See how AI is changing accounting for Australian businesses and why data quality decides whether the clever tools help or mislead.
