cancel
Showing results for 
Search instead for 
Did you mean: 
IntegrityLandscapeLLC
Level 1

Where do i find the payments report to sub contractors for an audit

For my insurance audit I need a report showing payment totals to each sub contractor for a period of time. My old payroll with intuit had this option, but do not see it in this updated one.
23 Comments 23
LieraMarie_A
QuickBooks Team

Where do i find the payments report to sub contractors for an audit

QuickBooks will have your back for any future audits that might occur, @IntegrityLandscapeLLC.

 

You can utilize the Expenses by Vendor Summary report to show the total payments to each subcontractor for a specific period.

 

Here's how:

  1. Go to Reports on the left panel.
  2. On the field box, enter Expenses by Vendor Summary.
  3. Click the Customize button.
  4. Select the date range that you want the report to show.
  5. Go to the Filter section.
  6. From the Vendor dropdown list, select the names of your subcontractors.
  7. Click Run Report.

 

You can also pull up the Vendor Contact List to see which vendors are set to track 1099s.

  1. Go to Reports.
  2. Search for Vendor Contact List and open the report.
  3. Select Customize.
  4. In the Rows/Columns section, select Change columns.
  5. Select the Track 1099 checkbox.
  6. Click Run Report.
  7. Click the Sort button.
  8. Select the Sort by drop-down and choose Track 1099.

 

For more details, you can check out this article: Fix missing contractors or wrong amounts on 1099s.

 

I'll be right here should you need further assistance in getting your desired reports. Have a good one.

Ggreene
Level 2

Where do i find the payments report to sub contractors for an audit

There is no “Expenses by Vendor” option. 

Rea_M
Moderator

Where do i find the payments report to sub contractors for an audit

Thanks for joining the thread, @Ggreene. I've got some helpful details about the Expenses by Vendor report in QuickBooks Online (QBO).

 

The Expenses by Vendor Summary report is available for certain subscription levels (Essentials and Plus). You're maybe currently subscribed to the Simple Start plan that's why the report isn't an option for you. You can refer to this article to know more about this: Reports included in your QuickBooks Online subscription.

 

To get the information you need, you can either opt to upgrade your plan or pull up the report that's included on your subscription (Transaction List by Vendor) as an alternative.

 

If you choose to upgrade, you can visit the Billing & Subscription menu on the Account and Settings page. Then, select the Upgrade your plan option. After that, go back to the Reports menu to pull up the Expenses by Vendor Summary report.

 

Upgrade QBO.PNG

 

If you want to utilize the Transaction List by Vendor report, here's how to pull it up:

  1. Go to the Reports menu.
  2. Type in Transactions in the search box, and select Transaction List by Vendor.
  3. Select the Customize button to filter the info that matters the most (Report period, Account, Vendor).
  4. Click Run Report.

 

To learn more on how to get the most of your transaction and financial reports in QBO, you can refer to this article: Customize reports in QuickBooks Online.

 

Also, you're able to export your reports in QBO. This way, you can easily download the data and save it for future use. I encourage you to check out this article for the step-by-step guide: Export reports, lists, and other data from QuickBooks Online.

 

Keep me posted on how it goes. Let me know in the comments if you have other reporting concerns. I'm just around to help. Take care always.

Ggreene
Level 2

Where do i find the payments report to sub contractors for an audit

I think there is a miscommunication concerning the product we are using. Last month, we were moved from Intuit Full Service Payroll (discontinued) to QuickBooks Online Payroll Premium. In our previous plan, we had the ability to compile a Contractor's Payment Report. 

The article you referred me to says:

 

   1. Select the Settings ⚙ and then Export Data.

 

When I go to Settings as instructed Export Data does not appear (see attached).

 

AlexV
QuickBooks Team

Where do i find the payments report to sub contractors for an audit

Hi Ggreene!

 

I understand that you need a report showing the contractor's payments. Allow me to join this thread so I can assist you, too.

 

I'd like to reiterate Rea_M's suggestion to pull up the Transaction List by Vendor report. Then, customize it to show only the transactions related to your contractors. You can follow these steps:

  1. Search and select the said report on the Reports menu.
  2. Click the Customize button. From the Filter section, select the contractors under the Vendor dropdown.
  3. Tap Run report.

 

Check this link on how to personalize the reports: Customize reports in QuickBooks Online.

 

If you created checks to record the contractor payments, you can pull up the Check Detail report. You can still find it on the Reports menu.

 

Also, I'd like to share this article: Create and file 1099s using QuickBooks Online. You'll need this when it's time to prepare and file your 1099s.

 

Need more help? Keep on posting here and we'll respond as soon we can. Thanks!

andyr
Level 2

Where do i find the payments report to sub contractors for an audit

Hello, I just switched from IOP to QBOP.  I can no longer see a report of contractor payments. 
Please tell me how to display all the payments this year to one contractor or to export that sort of data. 

Thanks

-a

 

andyr
Level 2

Where do i find the payments report to sub contractors for an audit

regarding, "Transaction List by Vendor report. Then, customize it to show only the transactions related to your contractors."

 

When I click Reports and then type "Transaction" into the search field, nothing shows up.  I'm using the Quickbooks Payroll that took over for IOP.   How do I see contractor payment data?

 

 

MadelynC
Moderator

Where do i find the payments report to sub contractors for an audit

I’m here to help you locate your contractors’ payments in QuickBooks, @andyr.


In QuickBooks Online, the contractors’ payments data is accessible under the Contractors menu. QuickBooks keep the contractors' details, payments, and documents in one place so users can easily view the information in just a few clicks. I’m glad to show you the steps.

 

  1. Go to the Payroll menu, then choose Contractors.
    Capture.PNG
  2. Select the contractor’s name, then click the Payments tab.
  3. Filter the date, type, and payment method.
    Capture.PNG


In case you need to add independent contractors in QuickBooks and set up a direct deposit for them, you can check the resources below for complete instructions:

 


Also, you can visit our Support page anytime. This site contains articles, tips, and video tutorials to help you manage your payroll more efficiently.


Need more help with contractors’ data? Add them to your reply below. I want to ensure everything is covered. Have a great day and always take care!

Ggreene
Level 2

Where do i find the payments report to sub contractors for an audit

This provides a list, not a report. Looking for a report that can be printed to satisfy insurance audit requirements.

MariaSoledadG
QuickBooks Team

Where do i find the payments report to sub contractors for an audit

Allow me to provide you a few information and guide you on what report to choose, Ggreene.

 

The Transaction List by Vendor report shows all the transactions made by vendors. To know the payments made by different vendors, you can run this report and customize it to show the payment made. To do this, follow the steps below. 

  1. Select Reports on the left menu.
  2. Search for the report.
  3. Make sure to choose the correct Report period, then click Run report
  4. Click Customize.
  5. Under Rows/Columns, click Change Columns
  6. Tick the AP/Paid, Due Date, Terms, Vendor, Open Balance, Tax Amount, and Taxable Amount.
  7. Tap Run report.
  8. Click the printer icon on the left side to print.
    payment report.PNG

For more information, I've added this article so you'll know the available reports in QuickBooks Online. Reports Included in your QuickBooks Online Subscription.

 

Keep in touch if you need further assistance with vendor payments. I'll be here to help.

andyr
Level 2

Where do i find the payments report to sub contractors for an audit

This is super frustrating.  There is no "Transaction List by Vendor" report available in QB Online Payroll. 

We were happy with Intuit Online Payroll.  Now we've been forced off that platform and into QB Online Payroll.  I have few employees and 30+ contractors. 

Now I can't see what I've paid them.  This is really a bad situation.  Please allow us to use IOP again. 

 

 

 

andyr
Level 2

Where do i find the payments report to sub contractors for an audit

Intuit Online Payroll had the reports we need.  Quickbooks Online Payroll does not.  This is a HUGE step backward.  There is no " Transaction List by Vendor" report available in QB Online Payroll.  

 

This is terrible.  We need our DATA so we know how much we paid contractors.  Please help. 

 

DebSheenD
QuickBooks Team

Where do i find the payments report to sub contractors for an audit

Hi there, andyr.

I appreciate you for letting us know the results of the steps you've done. Let me help provide another way to view the vendors' payment.

Here's how:
 

  1. Click the Payroll menu, then select Contractors.
  2. Select the contractor’s name, then click the Payments tab.
  3. Filter the date, type, and payment method.


I've added these articles that'll help you add independent contractors in QuickBooks and how to set up direct deposit:
 


Additionally, I've attached this article that'll help you on how to keep your customization set on the report: Memorize reports in QuickBooks Online.

Feel welcome to get back on this thread if you'll need assistance in dealing with payroll tasks. We're always here to help you.

alexa0250
Level 1

Where do i find the payments report to sub contractors for an audit

Im having the same issue and this 'solution' DOES NOT HELP, we need paystubs for contractors paid thru direct deposit, when i had intuit payroll i've never had this issue, and now with this service WHICH IS MORE EXPENSIVE BTW, im not able to get this, if this doesnt get resolved in the next month i will be switching payroll companies. get your act together, you made us make the switch and now are offering a inferior service for MORE MONEY? absurd

deployeddata
Level 1

Where do i find the payments report to sub contractors for an audit

Hi - I was as fed up with all of this as you all!  Here's what they've come up with as a fix to access the transaction list by vendor and vendor summary reports - if you get online to chat with them, they will send you a link to those reports that you can then save as custom reports.  Ridiculous - yes.  A work around - somewhat. 

I agree that this is ridiculous that they do not give us access to our own information and this is something we pay them for.  I'll be looking for another payroll vendor for the upcoming year. Anyone have any suggestions on that?

 

jhallinc
Level 1

Where do i find the payments report to sub contractors for an audit

I do not want all of the vendors on this report!! I only can have the list of subcontractor only!! This is for an audit!!

JasroV
QuickBooks Team

Where do i find the payments report to sub contractors for an audit

I hear your sentiments, @jhallinc.

 

Generating a report to show your subcontractors' payments isn't possible in QuickBooks Online (QBO). As a way around, you can look for a third-party app that lets you run a report for your subcontractors' payments. I'll show you how.

 

  1. Go to the Apps menu.
  2. Click Browse and look for an app that has the feature you need.
  3. Select it and click Get app now to link to your account.

 

I recognized having a report to show your subcontractors' payments is beneficial in running your business. I suggest sending your feedback to our product development team. This way, they can review your suggestion and might consider adding it in the future updates.

 

In case you want to learn how to access your reports anytime outside your QBO account, you can utilize this article for the detailed steps: Export your reports to Excel from QuickBooks Online.

 

Need more help managing your contractors and reports? Please don't hesitate to add them in your response. I'll be here to assist you anytime. Keep safe!

KChartier0903
Level 1

Where do i find the payments report to sub contractors for an audit

So frustrating, So you're telling me that We are not able to print out a report showing what we paid our subcontractors for a certain time frame for our audit

Adrian_A
Moderator

Where do i find the payments report to sub contractors for an audit

It isn't the kind of experience we want you to come across, KChartier0903.

 

I know a way how you can review the payments you made for your contractors. You can run the Bills and Applied Payments report. 

 

Here's how:

 

  1. Click the Reports tab.
  2. Select Bills and Applied Payments.
  3. Filter the Report period.
  4. Click Customize to select your contractor's name.
  5. Hit Run report.

 

If you want to access the report on an Excel file, you can export it. Here's an article as your guide:  Export your reports to Excel from QuickBooks Online.

 

You can always get back to this thread whenever you have questions.

KChartier0903
Level 1

Where do i find the payments report to sub contractors for an audit

Hi there apparently after I hit the reports tab I don't have one that says select bills?

Thank you

MorganB
Content Leader

Where do i find the payments report to sub contractors for an audit

Thanks for following up this thread, KChartier0903.

 

I double checked my QuickBooks Online test account and located the Bills and Applied Payments Report. You can find it by typing "bills" in the search field and the system will generate Bills and Applied Payments in the results. You can also locate this report by scrolling down the page to the "What you owe" section. Here's a screenshot of what it will look like for you:

 

 

Please feel free to follow up in the comments below if you're unable to locate the report or if you have any other questions. I'll be here to help.

 

Mac83
Level 1

Where do i find the payments report to sub contractors for an audit

This does not work as the report needs to be filtered by distribution account.can a report be ran that shows all transactions of a specific distribution account (such as subcontractors) within a specific time period?

Rubielyn_J
QuickBooks Team

Where do i find the payments report to sub contractors for an audit

Let me provide another report to run in your QuickBooks Online, @Mac83.

 

We can generate a Quick report from a specific account to show all transactions. Let me show you how:

 

  1. Go to the Accounting menu.
  2. Select the Chart of Accounts.
  3. Choose the account, then click the Run report option.
  4. Select the Customize button. 
  5. Choose the date under the Report period.
  6. Under Filter, click the box next to Vendor and choose the subcontractors.
  7. Lastly, select Run report

 

You can refer to this article to further personalize and learn more on how to get the most out of your transaction and financial reports in QBO: Customize reports in QuickBooks Online.

 

Additionally, you can also consider checking out these references to manage your reports in QuickBooks:

 

 

I encourage you to get back to this thread if you have further questions regarding running transaction reports in QuickBooks. I'm always around to help.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us