Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
S
SWyatt502
February 2, 2021
Question

Create mailing label for accounts payable

  • February 2, 2021
  • 2 replies
  • 18 views

After printing my accounts payable checks, is there a way to create address labels (or a QB file to merge) for JUST those payables? I can't figure it out. I thought maybe I could create an export file using the Bill Payment List Report, but it doesn't allow me to add the address in my columns. Any ideas? I want to do this because I don't want to use window envelopes for my payables. I want to either have a label or print the envelope without having to do it one by one.

2 replies

K
Klent
Level 8
February 2, 2021

Hi there, SWyatt502.

 

I've got some ideas on how you can attach address labels.

 

You'll want to pull up the Vendor Contact List report to get all their mailing address. Then, export it to an Excel or PDF file so you can further customize its appearance before including it in your printed checks. Here's how:
 

  1. Select Reports from the sidebar menu.
  2. Under Expenses and vendors, choose Vendor Contact List.
  3. Click the Customize button.
  4. Go to the Filters section, then select the appropriate vendor from the Vendor drop-down menu.
  5. Click Run report, then select Export icon.
  6. Choose Export to Excel or Export to PDF.

Alternatively, you can visit our QuickBooks App Center to find a third-party app the can directly attach or merge mailing labels to your checks. You also follow these steps in searching the app within your QuickBooks account:
 

  1. Login to qbo.intuit.com
  2. Select Apps from the sidebar menu.
  3. Go to the Find Apps tab.
  4. Enter a keyword in the search bar or click the Browse category button to filter the results.

Additionally, I've included some articles below that will help you fix alignment issues when printing checks in QuickBooks:

 

Do you have any other questions in mind? Feel free to leave them below and I'll get back to you as soon as I can. 

S
SWyatt502Author
February 3, 2021

@Klent   Thanks for the advice, but it doesn't really address my issue.  I understand/know how to run an entire data base list of my vendors for export. My question was is there a way I can run it JUST for the payables I just completed.  For example - if my payable run consists of 23 checks - I need labels just for those 23.  I don't need my entire 250 vendor data base.  Yes - I know I can run the entire data base - keep it on file as a merge file, then each time I run payables merge labels for the 23 vendors only.  I'm asking if there is an automated way to do that so I don't have to go check, one by one, the vendors to merge.  Seems to me a fast and easy way to do this is if they would just allow us to add the address as a field option on the Bill Payment List Report.  That report can show ONLY the payables I just ran.  Boom – problem solved.  But, alas, Quickbooks doesn’t see it from the end user’s perspective yet again. 

A
ajw2755
December 14, 2022

Did anyone ever figure out a way to Create a mailing list so that you don't have to do a complete list?

 

E
Eleanor Cleverence
October 10, 2025

You've hit a pretty commom hurdle with QuickBooks around labels for accounts payable. So, QuickBooks doesn't directly support address labels from checks or payment reports, but here's a workaround that might help ya.

Exporting the Bill Payment List Report is good, but as you’ve noted, it lacks adress detail. Let's pivot slightly and export the Vendor Contact List since it has mailing addresses. Once you got both reports, you can use spreadsheet software like Excel to match the payments from your Bill Payment List with vendors from the Vendor Contact List. Yeah, it involves some manual work, but once you create that matching list, you can generate mailing labels using Word's Mail Merge function.

If you're looking for a more automated solution, maybe check out a reporting or CRM tool that can pull and manipulate data from QuickBooks. Tools like Zapier or some crm systems can help pull it all together, often with fewer steps and less manual work.

And yeah, not a fan of those window envelopes myself. Hope this springs a useful idea for you!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement