cancel
Showing results for 
Search instead for 
Did you mean: 
SWyatt502
Level 4

Create mailing label for accounts payable

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.

3 Comments 3
KlentB
Moderator

Create mailing label for accounts payable

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. 

SWyatt502
Level 4

Create mailing label for accounts payable

@KlentB   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. 

ajw2755
Level 1

Create mailing label for accounts payable

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

 

Need to get in touch?

Contact us