Home » Frequently asked questions » Reconcile Payroll Payment Transactions

Reconcile Payroll Payment Transactions

April 14, 2021
Bill Kimball

how to enter wages in xero

At this time you can only attach additional documents in Training. If you’d like to pass your feedback on to our Product team, you can click the “Help” menu in Deputy, then select “Feature suggestions”.

how to enter wages in xero

Please note that if you re-sync the rates, you will also need to unapprove and re-approve your timesheets for the new rates to apply. First, please double-check that your employees’ Pay Rates are set to Automatic.

Is there a way to export the Annual Leave to Annual Leave with LL? These always fail and manual adding of Annual Leave with LL is needed. Time off in lieu can be accrued and calculated as leave inside Xero. You can set up Deputy to automatically send a notification to the manager or the whole team when it’s someone’s birthday.

How To Correctly Post Your Salary Journal

During the Xero setup process make sure to choose the correct Xero company. You likely have an additional extension added to your account that is syncing this. You can check by viewing your location, then selecting “Notifications and Integrations”. If you have the employee sync integration, you can remove this. There is a bulk importer tool for bringing in employees from Xero. You can configure Public Holidays by following this guide.

If you use our Xero On-boarding Sync, it will auto create employees who don’t exist in Xero. Regarding the HR On-boarding – can we attach additional company specific paperwork that we require our employees to also fill in? It’s a bit clunky right now as our new employees have to complete the On-boarding documents and then bridge the gap with all the missing HR paperwork from our company files. Yes, if you are using Xero Rates as the source of truth, enabling Auto-Sync will ensure the rates are kept up to date as per changes in Xero.

How To: Reconcile Wages Payments In Xero

You must also specify the weekly total hours and daily hours exclusion below. The bracket determines the days on which the rate will apply.

There will be an article outlining how to automate these allowances. If this is proving to be a challenge for you, we recommend that you reach out to Xero to share your feedback with them. Alternatively, you can reach out to your account management or to support to discuss having an award built custom into your account at a cost. Casual Loadings are to be included when entering the base rate of the employee in Deputy. Regarding the On-boarding function – can this be used for existing employees (those who started before the On-boarding feature was introduced)?

This method can be easily replicated to other accounting packages. This is a short tutorial on how to correctly record CIS Deductions in Xero cloud accounting package without a plugin. Your employee will now be set to terminated on the date you specified. Adjust the SGC calculation– annual leave payable on termination is not subject to superannuation. Delete any standard pay items from the payslip that you do not want to include.

Go into Xero and check that the ‘Payroll services’ box has been selected under subscriptions. The Xero subscription cost you pay will vary depending on how many employees are on the payroll but Xero will charge you automatically. PAYE is the income tax you’ll take from your new employee’s wages and will then pay to HMRC. As an employer, it’s your legal responsibility to collect this tax and to have your payroll configured to do this.

Aggregates such as DAILY, WEEKDAY, WEEKEND can also be used. When Deputy evaluates a Timesheet to check which rate should be paid, it will look at the bottom-most condition first, then work it’s way to the top. When it finds an applicable rate, it will check which portion of the shift applies before going on to next pay item.

  • Not many I would suggest (unless they are an accountant by trade of course!).
  • We are new to Deputy and have opening leave balances in Xero that I would like to show in Deputy.
  • Time captured on project tasks also flows into payroll timesheets.
  • Everything you need to know about paying Statutory Maternity Pay to your employees.
  • You can process the entirety of a final pay in the same pay run, but we recommend to process the unpaid wages first to accrue any final annual leave.

Please note that Xero may order the pay items back to front. To ensure that this doesn’t happen, please order your rates with a number before the rate, with 0 being the most common rate. Yes, you can use a mixture of pay rates on different employees without issue. If you pay above the award, Deputy will allow you to set a higher base rate figure than the figure that fair work recommends. At this time, there isn’t a way to set higher multiplier rates for the award.

When reconciling wages payments in Xero, you should always post wages paid to the “814 – Wages Payable” code. It should never be posted to an account starting 3xx or 4xx.

For more information about access levels please have a look at this article from our help portal. Add a new pay run and process the final days of pay like normal.

Wage Expense Account

The payment sent to Ben is at a value of £2800.00 because John has deducted £200 worth of CIS on labour. If Ben was not registered for CIS himself then John would deduct £300 on labour as that is 30% rate for subcontractors who are not registered. Once you have completed processing the final payments for your terminated employee, you can now enter the termination date.

how to enter wages in xero

In Deputy for an employee under “Pay Rates & Leave”, if it has successfully connected to Xero you should be able to see the last date and time it was synchronised to Xero and the corresponding Time Sheet Export Code. The Time Sheet Export Code is used to find the corresponding employee in Xero. Deputy has no control over what shows on the employee’s payslip in Xero. If this is proving to be a challenge for you, we recommend reaching out to Xero to share your feedback with them. For processing pay, we recommend exporting it as a Timesheet from Deputy as exporting it to a payslip won’t store the Timesheet history in Xero.

There are codes in the balance sheet also for attachment of earnings if these are to be deducted from net pay. If you are a small employer eligible to reclaim any Sick Pay, Maternity Pay or Adoption Pay in the month this can be posted to the PAYE/NI account to reduce the payment being made to HMRC. The common mistake is to allocate payments paid to staff and your HMRC payment straight into the wages costs area of your profit and loss account. In Sage50c that would be to codes in the 7000 range, and in Xero it would be a direct cost or overhead in the 300s or 400s. So in short, any payments relating to payroll should be coded to an account in starting 8xx.

One of the first things to do is set up the business up for pay-as-you-earn . Firstly, insert the expense amounts that will show up in the profit and loss report on Xero. If you really want to get things posted onto Xero correctly then the Gross Pay amounts should be split up onto different expense codes on Xero. Your accountant will show the split in the full statutory accounts that are created for HMRC purposes. Also, splitting the two provides meaningful and useful information when reviewing your interim management accounts reports on Xero. One of the major expenses incurred by most businesses is the cost of employing their workforce (i.e. wages/salaries). A couple of points, you can create an employee payment batch using Pay Run in Xero.

The manual journal is still there, but it is no longer reporting in the P&L tracking reports and therefore the reports are wrong! BTW – I have another 11 manual journals untouched, therefore if you want to witness the phenomenon, please let me know. Correct, you can’t apply tracking via Pay Run but you could achieve this via a manual journal.

$1,000 bonus inclusive of superannuation is entered as $913.24 gross wages. Total cost to the business is $913.24 of gross wages and $86.76 of superannuation ($1,000).

The Number determines the order in which the Deputy will sort the rate, with 0 being the most common rate. You can use syntax in conjunction with award interpretation in Xero AU. Should staff be requesting their leave through Xero or Deputy? Currently they are not syncing and have to be manually added. If you require any assistance setting this up, please reach out to our 24/7 Support Team.

When an employee leaves the business and you want to take them off the payroll, go to ‘Payroll’ and select ‘Employees’. If you need a little more help, this video from Xero walks you through the whole process of setting up your payroll and employees. Organisation – here’s where you tell Xero which account codes you’d like to use when posting the monthly payroll journal.