Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
tgbwc
Level 1

I need a report for my insurance auditor, that lists each subcontractor I paid and the total paid to them in 2020. Prior years had to look at each account separately :-(

I have the total I paid to all, but need a breakdown of each subcontractor I paid and how much.
4 Comments 4
MaryLurleenM
Moderator

I need a report for my insurance auditor, that lists each subcontractor I paid and the total paid to them in 2020. Prior years had to look at each account separately :-(

I got you covered, tgbwc.

 

When running this report, make sure the rows/columns is group by name. Here's how:

  1. Select Reports on the left pane.
  2. Enter the report name as Transaction List by Date.
  3. Select Transaction List by Date.
  4. Select a Report period to the year.
  5. For Group By, select Vendor.
  6. Select Customize.
  7. Filter by the following Transaction Types:
    • Bill Payment (Check)
    • Bill Payment (Credit Card)
    • Cash Expense
    • Check
    • Credit Card Expense
    • Credit Card Credit
    • Vendor Credit
  8. (Optional) If you want to report on a particular vendor or group, select the Name ▼ drop-down menu, then select the appropriate vendor(s).
  9. Select Run Report.
  10. Select Save customization, then select Save.

Note: You can create a new name for the report.

 

Check out these articles for reports customization:

Let me know if you have other questions.

anitadtowers
Level 1

I need a report for my insurance auditor, that lists each subcontractor I paid and the total paid to them in 2020. Prior years had to look at each account separately :-(

Can you please tell me how to get this report on Quickbooks Desktop Enterprise Solutions Contractor version?

anitadtowers
Level 1

I need a report for my insurance auditor, that lists each subcontractor I paid and the total paid to them in 2020. Prior years had to look at each account separately :-(

Can you tell me how to do this report on Quickbooks Desktop Enterprise Contractor version?

Kurt_M
Moderator

I need a report for my insurance auditor, that lists each subcontractor I paid and the total paid to them in 2020. Prior years had to look at each account separately :-(

Hi there, @anitadtowers. We'll share details to help you generate a report that shows the data you need inside QuickBooks Desktop (QBDT).

 

Before anything else, know that you can customize a report and have specific data added to it. You can also control the columns you'd like to see inside the report. We'll write down the steps to get you going:

 

  1. Access your QuickBooks Desktop company.
  2. Go to the Reports menu.
  3. Select Reports Center and then in the Search bar, enter Transaction List by Date.
  4. Click the Customize Report button.
  5. Enter the report period.
  6. In the Display section, add the column you want to show in your report.
  7. In the Filter section, add the data you want to show in your report.
  8. Select Run Report.
  9. Once done, click Save customization and select Save.

 

For more details, please see this page: Customize reports in QuickBooks Desktop.

 

Additionally, you can visit this article to help you keep your current report settings: Create, access and modify memorized reports.

 

It's been a pleasure to have you here today, @anitadtowers. You can visit the Community space anytime if you need further assistance generating reports or have any additional questions related to QuickBooks. Keep safe.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us