how to import csv file into quickbooks desktop 2020

A nominal account name or code can be used for multiple items. Within Quickbooks, the user can go to Employees > Employee Centre > New Employee to do this.ģa) Nominal Ledger Mapping - for each of the payroll data items listed, enter the equivalent nominal account name (or code) that you have set up within Quickbooks as per example below. This is a Quickbooks requirement and may result in error 11283 if the names have not been set up prior to upload. Unfortunately the option to 'merge employee records for each unique date' is not supported.īefore your journal can be uploaded successfully, you must ensure that your employee names exist in your QuickBooks company file.

If using Quickbooks Online, please click here for assistance.ġ) Within Payroll, select Journal on the menu toolbar, followed by Quickbooks:Ģa) On the next screen, choose Quickbooks Desktop (IIF File) as your destinationī) set your D ate Range - the journal will include records for all payslips (across all pay frequencies) with a pay date within the selected range.Ĭ) Roll up - for successful upload into your Quickbooks software, it is important to always select the option to 'include individual records for each employee'.

Quickbooks (Desktop version) - CSV uploadīrightPay's payroll journal feature allows users to create wages journals from the finalised payslips and export to IIF file format for upload into Quickbooks accounting software (Desktop version only).

How to import csv file into quickbooks desktop 2020