Skip to main content

QuickBooks Desktop

Updated
Applies toQuickBooks AudienceAll users Last updatedOctober 04, 2025

Versions

Transaction Pro 7.0

QuickBooks Premier Edition, QuickBooks Enterprise Edition 2020

** For testing, install Wholesales and Manufacturing Edition, then open the Demo Wholesales and Manufacturing company.

Integration Overview

To minimize integration and to improve customer service in Salesforce, you should manage Inventory and AR in GoldFinch and manage AP and GL in QuickBooks.

Purchases and Summarized GL from GoldFinch are exported manually and saved as Excel files. Files are manually imported to QuickBooks Desktop using Transaction Pro.

Transaction Pro is a 3rd party application used to import data into QuickBooks Desktop.

Important
Notes:

  • ** Vendor accounts must be created manually in both GoldFinch and QuickBooks Desktop - account names MUST match exactly!

  • ** Payment Terms must be created manually in both GoldFinch and QuickBooks Desktop - payment term names MUST match exactly!

Get Started with Transaction Pro

Purchase Transaction Pro Importer for QuickBooks Desktop:

Connect Transaction Pro to QuickBooks Desktop.

  • Both Transaction Pro and QuickBooks must be running on the same computer.

  • Download and install Transaction Pro.

  • Follow these procedures to connect Transaction Pro to QuickBooks

https://support.transactionpro.com/kb/article/375-connect-transaction-pro-to-quickbooks-desktop/

GoldFinch Setup

In GoldFinch Company Setup, place a check mark in the field for Use Posting Date for Purchase Invoice Date.

Warning! Do not override this flag when posting. The posting date from GoldFinch must match the Invoice date in QuickBooks - this keeps the transactions in the same accounting period.

Navigate to Custom Settings, then System Settings. Add two more parameters to assist with GL Entries Import to QuickBooks Desktop.

  • By default, you cannot import AR or AP GL Entries to QuickBooks without a Customer or a Vendor.

  • CustomAPAccountName. Enter 9999-Offset to the Value field.

    • This GL Account must be set up in QuickBooks first.

    • 9999-Offset is used as the offset account to AP when Purchase Invoices and exported.

    • When GL Entries are exported, AP Account is replaced with 9999-Offset.

  • CustomARAccountName. Enter 1201-Accounts Receivable GF to the Value field.

    • This GL Account must not be an AR Control Account in QuickBooks Desktop.

    • When GL Entries are exported, AR Accounts will be replaced with 1201-Accounts Receivable GF.

Transaction Pro - Basic Setup

Configure Transaction Pro using the settings below.

Transaction Pro: Basic Options

  • Under "List Items", check all boxes

  • Select "Generate Transaction Log - outputs all processed and failed transactions to a log window"

Transaction Pro: e-Commerce Options

  • Enable TPI e-Commerce Features

  • Import File Structure = Separate rows (records) for each item sold

QuickBooks Desktop - Setup Items

We use Service Items in QuickBooks Desktop for integration.

Important! Inventory data is complex - we only track Inventory in GoldFinch. Attempting to maintain inventory data in both systems is complicated and prone to errors.

GL Accounts

Create a GL Account in QuickBooks Desktop named "9999-Offset".

Create a GL Account in QuickBooks Desktop named "1201-Accounts Receivable GF".

Inventory Service Items

Create a service item in QuickBooks Desktop named "Z-Inventory Purchases" - assigning the item to a GL account.

All purchase lines in GoldFinch will be converted to QuickBooks Desktop's generic Z-Inventory service items.

  • Type = Service

  • Item Name/Number = Z-Inventory Purchases

  • Tax Code = Non

  • Description = Inventory Purchases from GoldFinch

  • Account = 9999-Offset Account

File Formats

Transaction Pro accepts a text file with the .csv (tab-separated values) file type. GoldFinch will automatically generate this file for you.

Purchase Invoices and Credit Memos

Fields exported from GoldFinch to QuickBooks.

Field Name

(QuickBooks)

Field Name

(GoldFinch)

Vendor

Pay-to Vendor

Transaction Date

Invoice Date

RefNumber

Vendor Invoice No.

Bill Due

Due Date

Terms

Payment Terms

Memo

GoldFinch Purchase Invoice No.

Items Item

Item number

Items Qty

Item quantity

Items Description

Item description

Items Cost

Unit Cost

GL Entries

Fields exported from GoldFinch to QuickBooks.

Field Name

(QuickBooks)

Field Name

(GoldFinch)

RefNumber

GL Batch No.

Transaction Date

Posting Date

Account

GL Account No.

Debit

Positive Amount

Credit

Negative Amount exported as a positive number

Memo

Document No.

Export files from GoldFinch

Purchase Invoices and Purchase Credit Memos

Purchase Invoices and Purchase Credit Memos must be exported and imported into QuickBooks separately - do not combine the import files! Transaction Pro handles each import individually so that GoldFinch data can be aligned with the QuickBooks data structure.

  • In GoldFinch, navigate to Purchase Invoices. Create these two list views if they are not available.

    • Posted Invoices Not Exported, with Document Status = Posted, Credit Memo = false, and Exported Date = blank.

    • Posted Credit Memo Not Exported, with Document Status = Posted, Credit Memo = true, and Exported Date = blank.

  • Click on any one of the list views. Select all records, then click the Generate TXT button.

  • After records are exported, the Exported Date will be populated with today’s date.

  • Save the file.

GL Entries

  • In GoldFinch, navigate to GL Batch, then click the "Not Exported" list.

    • Not Exported List has all GL Batches with Closed = True and Exported Date = blank.

    • Select GL Batches, then click the Export GL Entries button.

    • After GL Batches are exported, the Exported Date will be populated with today’s date.

Import to QuickBooks Desktop with Transaction Pro

Purchase Invoices

  • Open Transaction Pro on your desktop computer where QuickBooks is running.

  • Browse and select the import file

  • Set parameters: Field = Tab, Record = CR/LF, Import Type = Bill

  • Click Next

  • The file content screen displays imported file data.

    Check to make sure the data file is correct, you can delete lines if necessary.

  • Click Next

  • Map fields (maps can be saved)
    To map fields for the first time - click "Clear Map" and "Field Match"

  • Click Next

  • Review the results of the mapping.

  • Click Next

  • Click Finish

  • The file will be imported and validated.

  • Select Service as Item Type and 9999-Offset as Account for this screen.

  • View the log.

Purchase Credit Memos

  • Same procedures as for the Purchase Invoice, but in TransactionPro select:
    Import Type = Vendor Credit

Review Bills/Credits in QuickBooks

Go to QuickBooks\Vendors\Vendor Center\Transactions\Bills to review. Add Memo to the list view.

GL Entries

  • Open Transaction Pro on your desktop computer where QuickBooks is running.

  • Browse and select the import file

  • Set parameters: Field = Tab, Record = CR/LF, Import Type = Journal Entry

  • Click Next

  • The file content screen displays imported file data.

  • Click Next

  • Map fields (maps can be saved)
    To map fields for the first time, click "Clear Map" and "Field Match"

  • Click Next

  • Review the results of the mapping.

  • Click Next

  • Click Finish. The file will be imported and validated.

  • If you receive the below errors, you must check to ensure AR Account or AP Account are not used in the GL export.

    • By default, you cannot import GL Entries with AR Account or AP Account, but without a Customer, or a Vendor.

    • Go back to GoldFinch to update Custom Setting.

    • Then, export GL Entries again.

  • View the log.

Review GL Entries in QuickBooks

Go to QuickBooks\Reports\Accountants & Taxes\Journals to review.

Article QuickBooks-Desktop  ·  Last updated October 04, 2025 · GoldFinch ERP Help Center

Comments

0 comments

Please sign in to leave a comment.