Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Enterprise Edition Forum

Thread Tools Rate Thread Display Modes
Old 04-18-2017, 08:44 AM
saxahoya saxahoya is offline
Registered User
Join Date: Apr 2015
Posts: 30
Payees over $50k

I need to know all payees who were paid over $50k for our last fiscal year. I can do it searching for checks > $50k, but how do I do it so I capture payees that may have gotten several smaller checks over the year that total more than $50k?
Reply With Quote
Old 04-18-2017, 05:06 PM
Froid Froid is offline
Registered User
Join Date: Feb 2017
Location: Southern California
Posts: 136
I created a memorized "Check Register" report. My display settings include type, date, num, name, account, original amount, paid amount. Then under the filters tab, select 'multiple transaction types and tick items like check, payment (and any other payment methods used). Export the produced report to Excel and sort & group by vendor.

We use as a weekly check register to summarize both check and ACH payments, when you select the report to cover only a single day. By using a range like 1/1/16-12/31/16 you can generate the data for an entire year.
Reply With Quote

Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump

All times are GMT -5. The time now is 06:34 PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.