Prepare payroll data after converting from QuickBooks

After converting from QuickBooks, you’ll need to print payroll details from QuickBooks paid in the current quarter, then remove and re-enter the related converted data in Xero. This ensures your payroll data is accurate.

Before you start

  • In QuickBooks, print the details of each employee's pay check paid in the current quarter. You'll enter these details in Xero later.

Remove converted payroll transactions for the current quarter

  1. Go to Settings, then click General Settings.
  2. Under Organization, click Chart of Accounts.
  3. Click the Assets tab.
  4. Find the YTD column of the Bank Clearing Account and click the YTD amount.

    The Bank Clearing Account is created during conversion for any transactions Xero can't duplicate.

    Image of Bank Clearing Account YTD column.

  5. Find the converted payroll transactions paid in the current quarter. Look for credit transactions for employees and corresponding debit transactions for No Contact.

    Image of Bank Clearing Account and corresponding debit and credit transactions for converted payroll data.

    Make sure you only look for transactions that have a pay date in the current quarter. There may be others that relate to payroll but were paid in a previous quarter, or that don't relate to payroll.
  6. Click the first manual journal credit transaction paid in the current quarter.
  7. From the Journal Options list, select Void to remove it from the Bank Clearing Account.

    Image of payroll journal, Journal Options list and Void option.

  8. Open up the corresponding spend money debit transaction paid in the current quarter.

    Image of the debit transaction being opened.

  9. From the Options list, select Remove & Redo, and then click Yes to remove it from the Bank Clearing Account.
  10. Remove the remaining converted credit transactions and corresponding payroll debit transactions paid in the current quarter.

Once you've finished removing the transactions, you can set up payroll in Xero and add your employees' pay history for the current quarter.

Add your employees' pay history

  1. Set up payroll for your organization and add employees.
  2. Add your employees' pay history for the current quarter, using the pay check information you printed from QuickBooks.