cancel
Showing results for 
Search instead for 
Did you mean: 
chrisrexOSU
Active Member

Cash Sale IIF import

Trying to import cash sales into my company file but i can't figure out how to have a separate sale no. and check no. I can only get them to match on import and then have to change after upload. What header do I use to get unique values for each?

7 Comments 7
MariaSoledadG
QuickBooks Team

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. 

BigRedConsulting
Community Champion

Cash Sale IIF import

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.

BigRedConsulting
Community Champion

Cash Sale IIF import

@MariaSoledadG  RE: Please know that Intuit doesn't offer assisted technical support for creating or importing .IIF files.

 

Nobody asked about or for "assisted technical support", whatever that is.  You could just answer the question instead of punting.

 

Punt HEKKER-PROMO-SUB-jumbo.gif

chrisrexOSU
Active Member

Cash Sale IIF import

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?

Deity Alpha
Level 6

Cash Sale IIF import

@chrisrexOSU 

Like this one?

 

CustomerTransaction DateRefNumberPayment MethodCheck NumberClassTemplate NameTo Be PrintedShip DateBillTo Line1BillTo Line2BillTo Line3BillTo Line4BillTo CityBillTo StateBillTo PostalCodeBillTo CountryShipTo Line1ShipTo Line2ShipTo Line3ShipTo Line4ShipTo CityShipTo StateShipTo PostalCodeShipTo CountryPhoneFaxEmailContact NameFirst NameLast NameRepDue DateShip MethodCustomer MessageMemoCust. Tax CodeItemQuantityDescriptionPriceDeposit ToIs PendingItem Line ClassService DateFOBCustomer Acct NoSales Tax ItemTo Be E-MailedOtherOther1Other2Unit of MeasureCurrencyExchange RateSales Tax Code
Anne's Bakery01/09/2020100Check123  Y#########Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonCabinets10Cabinets1000Checking             Non
Anne's Bakery01/09/2020100Check123  Y#########Anne's BakeryOne Harbor Street  AnytownNY12345USAAnne's BakeryOne Harbor Street  AnytownNY12345USA(123) 456-7890          NonHardware10Hardware50Checking             Non
John's Barber Shope02/09/2020101Check89  Y#########John's Barber Shope1 Main Street  AnytownNY12345USAJohn's Barber Shope1 Main Street  AnytownNY12345USA(999) 888-8888          NonBlueprints1Blueprints500Checking             Non
Main St Bank03/09/2020102Check18  N#########Main St Bank1 State Street  AnytownNY12345USAMain St Bank1 State Street  AnytownNY12345USA(888) 888-8888          NonDoor1Door300Checking             Non
Main St Bank03/09/2020102Check18  N#########Main St Bank1 State Street  AnytownNY12345USAMain St Bank1 State Street  AnytownNY12345USA(888) 888-8888          NonHandles1Handle10Checking             Non
chrisrexOSU
Active Member

Cash Sale IIF import

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

Deity Alpha
Level 6

Cash Sale IIF import

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

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us