cancel
Showing results for 
Search instead for 
Did you mean: 
Centzun88
Level 1

Is it possible to import an excel file to write a check payment to various Vendors?

 
5 Comments 5
BigRedConsulting
Community Champion

Is it possible to import an excel file to write a check payment to various Vendors?

It's possible indirectly, by first converting the Excel file to an IIF file.  Use our BRC IIF Transaction Creator  excel add-in to convert your banking transactions to an IIF file for import directly into your QB bank register (other types of transactions and registers, too!)

Centzun88
Level 1

Is it possible to import an excel file to write a check payment to various Vendors?

Hello---- WE have around 200 Vendors to pay on a monthly basis and currently doing it as manual input for each of these 200 Vendors.   I would like to know if I can import directly all of it in QB enterprise &  to be printed afterwards as an individual checks.  This will avoid manual process.

As stated in your replay, the Excel file needs to be converted to an IIF file... this is the process I am not sure how to do & need assistance/help. Thanks

Centzun88
Level 1

Is it possible to import an excel file to write a check payment to various Vendors?

Hello, my issue is we are currently processing manual input of around 200checks to our various Vendors within QB and I would like to do a monthly import instead..  It appears that my excel file has to be converted to IIF..and it is the part that I need an assistance. Thanks

Jovychris_A
QuickBooks Team

Is it possible to import an excel file to write a check payment to various Vendors?

Thanks for your prompt response, @Centzun88.

 

You can download and install the .IIF import kit to isolate this when converting Excel files to IIF. For the detailed steps, you can reference this article to learn more in converting it to IIF files: IIF Overview: import kit, sample files, and headers.

 

Tip: Once done converting the file, if you wanted to include check numbers to get automatically detected in QuickBooks, ensure that there's a letter on the "To Print" column before you import them.

 

This way, you'll get the 200 checks imported seamlessly when you include the check numbers to QuickBooks. Also, you can check out our Community Help Articles for some "How do I" steps in QuickBooks Desktop.

 

Feel free to drop a comment below if you need more help with the importing process in QuickBooks. I'd be more than happy to help. Have a great day!

Fiat Lux - ASIA
Level 15

Is it possible to import an excel file to write a check payment to various Vendors?

@Centzun88 

If you are not familiar with IIF feature, utilize a 3rd party importer tool. Once you are familiar with the process, you can automate it by using the Windows Scheduler.

https:// transactionpro.grsm.io/qbd

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

 

You should prepare the template like this

Bank AccountPayeeTransaction DateRefNumberMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerUnit of MeasureItems BillableCurrencyExchange Rate
CheckingSunoco01/10/2020100Monthly GasSunoco1 Main Street  NewtownNJ12345USA Fuel25John's Car             
CheckingSunoco01/10/2020100Monthly GasSunoco1 Main Street  NewtownNJ12345USA Fuel50Karen's Car             
CheckingMichael's Fine Cabinetry30/09/2020101 Unitel12 Smith Ave  AnywhereNH22222USA       Cabinets10Cabinets150 Baker, Chris:Family Room Y  

 

 

 

Need to get in touch?

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