Skip to main content
I
Intercc
September 15, 2020
Question

Reports - specifically Job Costs by Job and Vendor Detail

  • September 15, 2020
  • 1 reply
  • 0 views

How can i get a column added to this report, do i call QB or do we need to hire someone.  Tried to do it myself and just not working,  Need to add check number and date paid, then this report would be perfect.

1 reply

Jen_D
Jen_D
September 15, 2020

I can share a few insights about this report and its columns, @Intercc,

 

QuickBooks follows the Sources and Targets concept to build company and financial reports. This means that, the data you see on every report is derived from the details of its source transaction.

 

If you're referring to the columns Check # and Paid Date having blank data, consider that this report you're pulling up involves transactions without these fields. Therefore, the system is unable to pull the information in there.

 

As a workaround, you may pull up another report that shows bill payments and checks. Then export it to Excel and combine the information manually there.

 

Here's how: 

 

  1. From the Reports menu select Vendors & Payables.
  2. Select Transaction List by Vendor from the result.
  3. Click the Customize Report button at the top and update the Report Date Range.
  4. Once done, go to the Filters tab.
  5. In the Filter search box, enter and select Transaction Type.
  6. Choose Multiple Transaction Types and pick the bill payment and checks or other transactions you need.
  7. Hit OK when you're done.

Once you have the data ready, export both reports to Excel using the Excel button at the top of the report. From there, fill in manually or copy the columns to get the desired reporting format.

 

Another option is using the Memo field. Double-click the transactions on the report and add the check number and paid date one at a time in that field. That way, you're on the same report and you no longer need to export anything outside the program.

 

I'm also adding this article to learn more about the reports in QuickBooks: Understand reports 

 

Please know that your insights about our reports is important for us to improve our products. If you have any questions feel free to reach out back again, and I'll be right here to help. Have a nice day!

I
InterccAuthor
September 15, 2020

We do that now, takes too much time, I need the report revised to show those additional columns, how can i have that done, will QB do it or do i have to hire an outside person to do it?

Rubielyn_J
Rubielyn_J
September 15, 2020

Thanks for getting back in here, @Intercc.

 

Let me add some details to run a report showing the Check # and Paid Date. You can run the Transaction Detail Report for QuickBooks to generate the data you want in your report. You may also hire somebody to do the task. 

 

Here's how: 

  1. Open your QuickBooks Desktop.
  2. Go to the Reports menu.
  3. Select the Transaction Detail Report.
  4. Choose Customize to filter your report.
  5. In the Filter name, select Customer/Job.
  6. Under Transaction Type, choose Check.
  7. Once done, click OK.

You'll want to save your current customization. Feel free to read this article for the details: Memorize a report.

 

Fill me in if you need further assistance in managing your reports in QuickBooks Desktop. I'm always here to help you. Have a great day.

Terms & ConditionsAccessibility statement