Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowIt'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!)
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
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
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 N 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!
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 Account | Payee | Transaction Date | RefNumber | Memo | Address Line1 | Address Line2 | Address Line3 | Address Line4 | Address City | Address State | Address PostalCode | Address Country | Vendor Acct No | Expenses Account | Expenses Amount | Expenses Memo | Expenses Class | Expenses Customer | Expenses Billable | Items Item | Items Qty | Items Description | Items Cost | Items Class | Items Customer | Unit of Measure | Items Billable | Currency | Exchange Rate |
Checking | Sunoco | 01/10/2020 | 100 | Monthly Gas | Sunoco | 1 Main Street | Newtown | NJ | 12345 | USA | Fuel | 25 | John's Car | ||||||||||||||||
Checking | Sunoco | 01/10/2020 | 100 | Monthly Gas | Sunoco | 1 Main Street | Newtown | NJ | 12345 | USA | Fuel | 50 | Karen's Car | ||||||||||||||||
Checking | Michael's Fine Cabinetry | 30/09/2020 | 101 | Unitel | 12 Smith Ave | Anywhere | NH | 22222 | USA | Cabinets | 10 | Cabinets | 150 | Baker, Chris:Family Room | Y |
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.