Intuit QuickBooks® (IIF) Post Format

Intuit QuickBooks® (IIF) post format is an example of a tab delimited post file format typically imported into Intuit QuickBooks®. For information about import limitations, refer to the Intuit QuickBooks® user guide.

Field Name	Description
Transaction Type	The keyword that identifies the type of transaction. This will always be General Journal.
Date	Post date of the transaction.
Account	The name of the account assigned to the transaction.
Amount	Amount of the transaction credited or debited to the general ledger account number. Debit amounts are always positive and credit amounts are always negative.

In Intuit QuickBooks®, you can track customer balances when you use an account with the account type “Accounts Receivable.” You can post in detail format only, not in summary.

Intuit QuickBooks® requires a customer name in the journal entry Name column for journal entry rows that debit or credit an account with the account type “Accounts Receivable.” The Altru post to Intuit QuickBooks® does not send customer-specific information to the Intuit QuickBooks® post file since balances for Altru constituents are maintained and tracked in Altru, with no need for additional tracking in Intuit QuickBooks®. In Altru, if you currently use an Intuit QuickBooks® account with the account type “Accounts Receivable,” the Intuit QuickBooks® post file that Altru creates does not work with the Intuit QuickBooks® import process because the Name column is not included in the post file.

To successfully post entries to Intuit QuickBooks® for charges and payments that affect constituent balances, you must create a new account in Intuit QuickBooks® and map the new account in Altru. When you create the new account, select an account type other than “Accounts Receivable,” such as “Other Assets.” After you create the new account and update the account mapping in Altru, Intuit QuickBooks® can then successfully import the post file from Altru without additional customer information.

When you change the transaction mapping in Altru, only new transactions are affected. We recommend you review existing entries to manually update the mapping. You can also manually update the account number in post files that contain the previous accounts receivable account number.