Cash Sale IIF import

Importing and exporting  IIF files is easy because QuickBooks formats them automatically. However, creating IIF files or moving data from another program can be complicated if you're not familiar with formatting delimited text files. I'm here to guide you on what to do to get the assistance you need, Chrisrex.

Currently, we're unable to offer technical support for creating or importing .IIF files, I recommend reaching out to the app's technical support for help if your file is from a third-party application. In many cases, it's quicker and easier to enter information directly into QuickBooks Desktop, unless you have a significant amount of data to import. 

Alternatively, you can download and install the .IIF import kit to make the process more efficient and improve your results. I've included a link to the article: IIF Overview: Import Kit, Sample Files, and Headers.

After successfully transferring your files and matching them with your transactions, check out this article to learn how to ensure that your financial records and be able to reduce discrepancies between your records and bank statement: Reconcile An Account in QuickBooks Desktop.

Feel free to leave your reply below if you have any questions about importing .IIF files. The Community is always here to help you. 

When importing, QuickBooks ignores the DOCNUM field for Sales Receipts. So that's out.

For the check no. field, use the PONUM field on the TRNS record in the IIF file.

I tried to include the check number in PONUM but unfortunately, that did not work.
The Cash Sale IIF does allow DOCNUM for me, but what keeps happening is that it populates both the Sale No(which I want), and Check No (which I don't want) with the DOCNUM. Using PONUM did not change the result. Thanks for the advice, though.

I have the TOPRINT set to N, would that affect it since it's the customer's check number?

@chrisrexOSU 

Like this one?

Yes! What field did you use for each of those?

You need to use TP Importer to do so. It's a one time $199 license + you can get $100 cashback to purchase via a partner.

https://get.transactionpro.com/qbd

@chrisrexOSU 

RE: I tried to include the check number in PONUM but unfortunately, that did not work...

Assuming that you are using QuickBooks 2019 or newer...

- Yes, on testing this I see that the default IIF import method will use the DOCNUM for both the Doc Number and the Payment/Check Number which is a bug (one of many).

- If you import using the alternate method, which uses the old, stable import code and is recommended for most all cases, then the DOCNUM is ignored and the PONUM becomes the Payment/Check Number.

Pick the lesser evil, I guess.

To import using the alternate method, see BRC QuickBooks 2019+ IIF Import Changes and Recommendations