Overview

In QuickBooks desktop a Payroll Item list is used to record the type of payment or deductions made to employees like Salary, Hourly wages, commissions, bonuses, deductions etc used on payslips. Zed Axis is able to import Payroll item lists directly into QuickBooks desktop from Excel or text files in batch,

Steps to import payroll item lists into QuickBooks desktop

Follow these steps:

Open Zed Axis and connect to the QuickBooks desktop company you want to import into.
Click on the Import tab and then browse to the Excel or text file that contains the payroll item list
In the mapping section select the option to create a new mapping and then using the drop down list selections map the column in your import file to the corresponding fields in QuickBooks desktop.
Click the import button and Axis will import the payroll item list into QuickBooks desktop.

More help?

Download a sample template file Payroll Item list.txt

Where the fields appear

Detailed description of the fields you can map

QuickBooks field	Type	Description
Name	Str 31	MANDATORY - The name of the payroll item, as appears in QuickBooks
Is Active	Bool	Whether the payroll item name is active or not (true or false).
Wage Type	Enum	Mandatory - The type of pay - (values - Bonus, Commission, HourlyOvertime, HourlyRegular, HourlySick, HourlyVacation, SalaryRegular, SalarySick, SalaryVacation
Expense Account Full Name	Str	Mandatory - The full name of the expense account

Article ID: 354, Created: 10/18/2021 at 5:38 AM, Modified: 3/10/2022 at 6:29 AM

Feedback

Why not have a Payroll item type
Dan Clemson (9/26/2024 at 12:02 AM)

Import Payroll Item lists into QuickBooks desktop