All Collections
Accounting
Quickbooks Desktop: Invoice Export Reference Guide
Quickbooks Desktop: Invoice Export Reference Guide

A reference guide of Invoice fields exported and how to map them correctly when importing to Quickbooks Desktop

Johnny Ji avatar
Written by Johnny Ji
Updated over a week ago

The following are fields of invoices that map to Quickbooks Desktop (*field names may differ slightly depending on which version of Quickbooks Desktop you're using)

Invoice Number (Invoice Ref Number)

Limit: 11 chars

This is the number that represents the invoice (ie. INV-0000005). This should map to Invoice Ref Number in Quickbooks Desktop

Customer (Customer Ref)

Limit: 209 chars

The name of the customer that the invoice is intended for. Maps to Customer Ref in Quickbooks Desktop

Customer Phone (Phone)

Limit: none

The phone number of the customer that the invoice is intended for. Maps to Phone in Quickbooks Desktop

Customer Email (Email)

Limit: none

The email of the customer that the invoice is intended for. Maps to Email in Quickbooks Desktop

Invoice Date (Txn Date)

Limit: none

The invoice date of the invoice is intended for. Maps to Txn Date in Quickbooks Desktop

Due Date (Due date)

Limit: None

The due date of the invoice is intended for. Maps to Due date in Quickbooks Desktop

Owner (Sales Rep)

Limit: 2 chars (only initials allowed)

The owner/sales rep in Distru that's responsible for this invoice. Maps to Sales Rep in Quickbooks Desktop. Only the initials of the owner/sales rep can be mapped to Quickbooks Desktop (ie. Johnny Depp maps to JD)

Internal Notes (Memo)

Limit: 4000 chars

Any internal notes on the invoice. Maps to Memo in Quickbooks Desktop

"Sales" (ItemRef)

Automatically generated

"Sales" is automatically the type of item that each invoice line item is imported into Quickbooks Desktop as. This is an automatically generated field, no need to input.

Product, Customer (Description)

Limit: 4095 chars

The product and customer names are imported as the description for the line item in Quickbooks

"TxnID" (TxnID)

Automatically generated

The ID of the invoice in Distru is exported to Quickbooks Desktop in the format of "INVOICE-[ID]" (ie. INVOICE-12). Maps to TxnID in Quickbooks Map.

"TxnLineID" (TxnID)

Automatically generated

The ID of the of the invoice line item in Distru is exported to Quickbooks Desktop in the format of "INVOICEITEM-[ID]" (ie. INVOICEITEM-12). Maps to TxnLineID in Quickbooks Map.

Price (Rate)

Limit: none

The price of the invoice line item. Maps to Rate in Quickbooks Desktop

Quantity (Quantity)

Limit: none

The quantity of product sold in the invoice line item. Maps to Quantity in Quickbooks Desktop

Did this answer your question?