cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
jbaxter-uvacswim
Level 1

I am exporting a Contact List from Vendors and only want to export vendors paid this calendar year....does using the last Modified Date filter return that result?

 
4 Comments 4
Candice C
QuickBooks Team

I am exporting a Contact List from Vendors and only want to export vendors paid this calendar year....does using the last Modified Date filter return that result?

Good evening, @jbaxter-uvacswim

 

It's great to see you back in the Community. I hope your day is going well so far. 

 

The "Last Modified Date" doesn't return the result you'd want. At this time, there isn't a filter/setting on the Vendor Contact List report that would show these details.

 

I'll send feedback to our Product Developers so they can consider this as an option in the future. They'll take the time to review every request and try to add them to the next update. 

 

You can check out our Blog site to keep up with what's new in the system. 

 

Keep us updated if you have any other concerns. We're only a post away. Have a wonderful day!

Fiat Lux - ASIA
Level 15

I am exporting a Contact List from Vendors and only want to export vendors paid this calendar year....does using the last Modified Date filter return that result?

@jbaxter-uvacswim 

How about using the exporter tool to export Billing Payment data with the following result? You can filter by transaction date

RefNumberAPAccountVendorTxnDateBank or CC AccountPrivateNoteCurrencyExchangeRateToBePrintedBillApplyToLineAmount
2001 Staples01/11/2020CheckingBill Payment  N101375.53
3454 Green's Taxi Service01/11/2020CheckingBill Payment  N185125.13
321901 Federal Express01/11/2020CheckingBill Payment  N201264.07

 

Use this tool

https://transactionpro.grsm.io/qbo

 

lspafford
Level 1

I am exporting a Contact List from Vendors and only want to export vendors paid this calendar year....does using the last Modified Date filter return that result?

has there been any update to this answer since 2021? I face this issue regularly and would like to pull a vendor list with contact info for vendors I've paid in the last calendar year. is there a report that exists with these parameters?

AnneMariee
QuickBooks Team

I am exporting a Contact List from Vendors and only want to export vendors paid this calendar year....does using the last Modified Date filter return that result?

Welcome to the Community, lspafford.

 

The option to run one report with the contact info of the vendors you paid last year is unavailable. As a workaround, you can run two reports to get the needed information. I'll guide you on how.

 

First, run a Bills and Applied Payments report to get the vendors you paid last year. Then, filter it by choosing Last year on the Report period dropdown. This way, it will only show who you paid in the past year

 

Afterwards, create a Vendor Contact List report. Here, you'll find your vendors' contact info. Just customize the report, so only the vendors you paid last year will show.

 

Here's how:

  1. On the Vendor Contact List report, click the Filter icon.
  2. On the first dropdown, select Full name.
  3. Then, choose equals under Operation.
  4. Enter a vendor's name in the Value field.
  5. Click Add filter for every vendor you wish to be in the report.

 

You may also use other operations when filtering a report to better suit your workflow. Once done, you'll get a report with the contact information of the vendors you paid last year.

 

For more info on customizing reports, please check this article out:   Customize reports in QuickBooks Online.

 

You may want to save your report's customization settings. Here's a guide on how: Memorize reports in QuickBooks Online.

 

If you have any other concerns or clarifications about creating a report with specific information, please leave a reply. I'm happy to assist you further.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us