cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Pamela C1
Level 1

Excel Template for Vendor Payment Upload

I have Quickbooks Desktop and need an excel template that will allow me to upload multiple vendor payments at once. Where would I find that template?

Thank you, 

2 Comments 2
JonpriL
Moderator

Excel Template for Vendor Payment Upload

Hi there, @Pamela C1! I'll help create the transaction template.

 

Uploading an Excel file is only allowed for your lists of data such as names, accounts, and items. With this, let's create an IIF file of your vendor payments and import them into your company in QuickBooks Desktop.

 

To begin with, here are the templates to create the IIF file depending on the payment method used:

 

 

Use this article to read and learn more about the template: IIF Overview - Import Kit, Sample Files, and Headers.

 

Once the file is created, use the import utility tool to upload the list of vendor payments created: Export, Import, and Edit IIF Files in QuickBooks Desktop.

 

I'm also including this reference with useful articles while working with the import utility tool: Import and Export Data in QuickBooks Desktop.

 

I've got you covered if you have questions about uploading a list of transactions. Use the Reply option below to leave a comment. Take care always!

Fiat Lux - ASIA
Level 15

Excel Template for Vendor Payment Upload

@Pamela C1 

If you are not familiar with IIF, prepare the Bill Payments data in the following XLS format

PayeeTransaction DateApply to Bill RefNumberPayment methodBank AccountCredit Card AccountRefNumberAmountMemoDiscount AmountDiscount AccountDiscount ClassTo Be PrintedExchange Rate
Bell Telephone01/10/2020123CheckChecking 1011500    Y 
Ajax Lumber01/10/2020400CheckChecking 1021500    Y 
Parts R Us01/10/20201200  QuickBooks Credit CardCC185    N 

 

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

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

 

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