Skip to main content
C
chrisrexOSU
November 20, 2024
Question

Cash Sale IIF import

  • November 20, 2024
  • 2 replies
  • 0 views

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?

2 replies

MariaSoledadG
MariaSoledadG
November 20, 2024

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
BigRedConsulting
November 20, 2024

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.

C
chrisrexOSUAuthor
November 21, 2024

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?

D
Deity Alpha
November 21, 2024

@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
Terms & ConditionsAccessibility statement