cancel
Showing results for 
Search instead for 
Did you mean: 
bradstreet14
Level 3

Write a check with IIF import

I was wondering if someone could help me setup an IIF file with a simple example of how to write a check.  I downloaded the IIF toolkit but didn't find exactly what I'm looking for. 

 

The IIF file contents are below

 

!TRNSTRNSIDTRNSTYPEDATEACCNTNAMEAMOUNT
!SPLSPLIDTRNSTYPEDATEACCNTNAMEAMOUNT
!ENDTRNS      
TRNS CHECK 3/26/2017KeyBank -215
SPL CHECK 3/26/2017Contractor Labor:Contractor Jon DoeJon Doe215
ENDTRNS      

 

When I try to run that file in QB 2020 desktop I get the following error.  I'm not really sure what it's talking about with the error.  I did a similar example where I wrote to accounts payable and it seemed to work.  Thanks.

 

 

!TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT
!SPL SPLID TRNSTYPE DATE ACCNT NAME AMOUNT
!ENDTRNS
; [ERROR] [Jon Doe] There is already another entity in Quickbooks by this Name [10143]
;[Jon Doe] Invalid Customer Name on the distribution line [11114]
TRNS CHECK 3/26/2017 KeyBank -215
SPL CHECK 3/26/2017 Contractor Labor:Contractor Jon Doe Jon Doe 215
ENDTRNS

 

Solved
Best answer February 28, 2020

Best Answers
bradstreet14
Level 3

Write a check with IIF import

I finally figured it out.  The proper format is shown below.

 

!TRNSTRNSIDTRNSTYPEDATEACCNTNAMEAMOUNTDOCNUMMEMOCLEARTOPRINT
!SPLSPLIDTRNSTYPEDATEACCNTNAMEAMOUNTDOCNUMMEMOCLEARQNTY
!ENDTRNS          
TRNS CHECK3/26/2017KeyBankJon Doe-215  MemoNY
SPL CHECK3/26/2017Contractor Labor:Contractor Jon Doe 215  N 
ENDTRNS          

View solution in original post

6 Comments 6
RenjolynC
QuickBooks Team

Write a check with IIF import

It's possible that Jon Doe is already added as a contractor, bradstreet14.

 

You can open the Vendor List and look for Jon Doe. If the name exists, you can modify it and put some characters like a middle initial. This is to avoid the error message when importing the file again.

 

Here are the steps:

 

  1. Go to Vendors > Vendor Center.
  2. In the search field, type Jon Doe and click the Magnifying Glass icon.
  3. Double-click on the name so you can edit the vendor.
  4. Click OK once done.

After the steps above, try importing your IIF file again. Here's an article for reference: IIF Overview: import kit, sample files, and headers.

 

Please let me know how it goes. I'm just a few clicks away to help you some more. Thanks.

bradstreet14
Level 3

Write a check with IIF import

I don't quite understand the problem.  Yes, Jon Doe is a vendor and he exists in the vendor list.  I'm trying to write a check to pay him.  The overall goal is to write a check to Jon Doe for $215 for contractor labor.  Thanks.

Ryan_M
QuickBooks Team

Write a check with IIF import

Hi @bradstreet14,

 

Thank you for your prompt reply, as well as sharing additional details on what you need to do in QuickBooks Desktop (QBDT).

 

The IIF import kit is used to upload lists or transactions. Since you're trying to record a check addressed to Jon Doe, which is already on your list of vendors, you can do that directly from within QBDT.

 

Here's how:

 

  1. Go to the Banking menu.
  2. Select Write Checks
  3. Choose the correct bank from the Bank Account drop-down menu. 
  4. Look for the correct vendor under the Pay To The Order Of drop-down menu.
  5. Assign an expense account under the Expenses tab since this is a payment for labor.
  6. If you need to print this check, tick the Print Later check box. 
  7. Tap Save & Close when you're done.

You can refer to this article for additional details concerning checks: Create, modify, and print checks. You can search for the Common issues and unexpected results section for troubleshooting steps on common issues you can encounter. 

 

Place your questions below if you have anything else in mind. I'll be sure to get back to you. 

Fiat Lux - ASIA
Level 15

Write a check with IIF import

@bradstreet14 

As another option, consider using a 3rd party tool to import your Checks data.

https://transactionpro.grsm.io/qbo

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

The template should be like this

RefNumberBankAccountVendorPrintOnCheckNameTxnDateLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteToBePrintedCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101CheckingJoe's Coffee 01/10/2020 12 Main StreetSuite 102  AlbanyNY12345  N  General SuppliesGeneral Supplies85.21           
102CheckingCostco 01/10/2020 PO Box 1000   DallasTX28456  N  General SuppliesGeneral Supplies125           
103CheckingProperty Mgmt Assoc 01/10/2020 PO Box 1800   AlbanyNY12345 Mar 2011 RentN  RentRent1000           

 

bradstreet14
Level 3

Write a check with IIF import

I'm aware that I can type in a check payment manually through Banking>Write Checks.  I'm trying to automate a routine so I'm trying to get the IIF file to work but I don't understand why it's complaining about the vendor already existing.

 

I'd rather avoid paying for a third party tool, this is something I can do myself if I can get the IIF file to work.  Thanks.

 

 

bradstreet14
Level 3

Write a check with IIF import

I finally figured it out.  The proper format is shown below.

 

!TRNSTRNSIDTRNSTYPEDATEACCNTNAMEAMOUNTDOCNUMMEMOCLEARTOPRINT
!SPLSPLIDTRNSTYPEDATEACCNTNAMEAMOUNTDOCNUMMEMOCLEARQNTY
!ENDTRNS          
TRNS CHECK3/26/2017KeyBankJon Doe-215  MemoNY
SPL CHECK3/26/2017Contractor Labor:Contractor Jon Doe 215  N 
ENDTRNS          

View solution in original post

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us