What to do before generating the Payroll transactions export file

Create the necessary accounts in your accounting software if you don’t have them
Don’t select Accounts Payable or Accounts Receivable accounts when mapping in Sage Payroll
Account numbers must be a minimum of 3 digits
Match account names and numbers to your Chart of Accounts exactly, including letter case

Select an option below:

QuickBooks Online

When mapping accounts, check the account type, account name, and account number settings.

For the easiest account mapping, select Parent accounts.
Enter the Parent account name in the mapping window.
Example:
If you’re selecting nested subaccounts under Parent accounts,

enter the full account hierarchy using a colon in the Sage Payroll account mapping window.

Example:
Remove spaces before or after the colon.
Compare the account names to your Chart of Accounts. Correct any capitalization, spelling, or spacing differences.

Rename and link accounts so account names don’t contain a slash (/).

Before importing Journal Entries into QuickBooks Desktop, confirm each subaccount uses the full account hierarchy.

For the easiest account mapping, select Parent accounts.
Enter the Parent account name in the mapping window.
If you’re selecting subaccounts nested under Parent accounts,

enter the full account hierarchy using a colon in the Sage Payroll account mapping window.
Remove spaces before or after the colon.
Compare the account names to your Chart of Accounts. Correct any capitalization, spelling, or spacing differences.

Set up linked payroll accounts correctly before you import journal entries into Sage 50 Accounting.

Go to Setup, Settings, Payroll, Linked Accounts, Incomes.
Locate and highlight the Vac. Owed account. Press Backspace, then select OK.
Clear the Advances & Loans and Payroll Advances as well before importing.
Relink these accounts if you’re processing payroll in Sage 50.