Integrate with Xero
Xero is an online double entry accounting software for businesses with 0-100 employees. Features of their service include invoice management, bank reconciliation, bookkeeping, and more.
Xero integrates with Gusto through the company's Gusto account. Each time you run payroll, the details of the transaction can be synced automatically or manually and will push the accounting Bill (taxes, wage expenses, liabilities) to your Xero account.
There are also options for additional levels of granularity within the entry based on earnings types, Gusto departments, and Xero Tracking Categories.
Click on the headers below to learn more.
- Click the Settings tab.
- Under Software Integrations, click Add New Integration.
- Next to Xero, click Connect to Xero.
- Enter your Xero credentials to get connected.
- Click Authorize to allow Xero and Gusto to sync.
- Map your chart of accounts.
- Select if the payroll sync will run automatically or manually.
- Elect whether you would like to automatically or manually approve the Bill in Xero.
- Note: Gusto will default to approving the Bill automatically.
- Choose the specific date you'd like to have appear on the entries Gusto sends to Xero.
- Debit date, end of pay period, or check date.
- Off-cycle payrolls and contractor payments without a defined pay period will default to the check date.
- Click Save.
Total wages, taxes, benefit deductions/contributions, reimbursements and contractor payments will now sync to your Xero account each time you run payroll.
Sync your payroll
- Navigate to the Reports tab.
- Navigate to the Payroll History tab.
- Click on the payroll you would like to sync.
- Click Sync at the top of the payroll detail page.
- Note: If you have autosync enabled the data will automatically push over when you process payroll.
- A timestamp will populate confirming the data was pushed over to Xero.
- Sign in to your Xero account.
- The Bill will post to Accounts > Purchases.
- If you chose to manually approve: Bills will sync over as “Awaiting Approval.”
- If you chose to automatically approve: Bills will sync over as “Awaiting Payment.”
When setting up your mappings you will be prompted to add:
- Earnings Types (Regular, Bonus, Commission etc.)
- Employer Taxes
- Benefit Expenses
- Benefit Liabilities
- Deduction/Garnishment Liabilities
- Owner's Draw
Once all payroll items are matched with the corresponding accounts, the building blocks are in place for the Bill that Gusto will sync over into Xero.
The more accounts you choose when setting up your integration, the more detail there will be in the line entries on your Bills. More detail in the Bill results in more detailed reports in Xero (expense reports, outstanding liability reports, etc.)
For example, if you'd like all wages from all employees to go to the same expense account, regardless of what type of earnings they are, you would select the exact same expense account for all earnings items. For reporting purposes you would have one expense account item measuring all earnings.
If you'd like to break out different types of earnings into different expense accounts you can make different account selections for each earnings type. For example, you could have one expense account for vacation pay and a different expense account for overtime.
Splitting payments to reconcile expenses
Because there are two bank debits for each payroll (taxes and net pay), admins will need to use a tool called "Split Payments" to reconcile them to one invoice. Gusto can help with how to split payments in Xero.
Q: What does the timestamp indicate?
A: The exact time Gusto successfully synced a payroll into the accounting software.
Q: Is there a way to retroactively sync all payrolls once I enable auto-sync?
A: Auto-sync will only work for the payrolls moving forward from the time it is set up. Any payrolls run before auto-sync was enabled will need to be manually synced.
Q: Can I re-sync an entry that has already been reconciled?
A: You will need to un-reconcile an entry in Xero before you can re-sync it. If you re-sync a payroll prior to un-reconciling, a duplicate Bill will come over.
Q: If I update my mappings, can I re-sync a payroll to update the Bill?
Q: Do you book the wage expense as gross wages or net wages?
A: Gross wages, meaning the wage expense will include employee pay, employee taxes, and employee deductions. Employer taxes and employer contributions will have their own expense line item.
Q: Do you break out individual taxes?
A: We do not break out individual taxes. By transitioning to Gusto you will no longer have tax payments coming over to your balance sheet as a liability. Taxes are handled on a cash basis instead of an accrual basis, our tax debits for each payroll are considered a closed transaction.
Q: Can I post over individual employee payroll information?
A: Gusto does not currently support mapping for individual employees. Payroll information is pushed over at the company level.
However you can accomplish this by using Departments. Add one employee to each team, which can then map to specific accounts. Post this over to see the individual employee payroll details.
Q: Will transactions automatically reconcile?
A: No. Your Bill must be approved before you can reconcile the debits in your bank account with the Bill line entries. Do this by matching your bank transactions to the Bill Gusto created using “Match” under Accounts > Bank Accounts.
Q: Do you support Xero Tracking Categories?
Q: How do I handle checks?
A: We recommend printing checks from your Gusto account or handwriting them. You can then reconcile the Bill from Gusto when the checks are cashed by your employees. We do incorporate the amount of each check in our Bill.