cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Join our Small Business Relief Initiative. Support a GoFundMe today.
Level 1

In search of an Unpaid Bills Report that includes Class

I need to create a report that shows unpaid bills and includes the Class field. The Unpaid Bills report doesn't offer Class an optional output. I've seen reference to a report titled Unpaid Bills Detail, but I don't see that in qbo. There must be some report that I can customize. It's for review of checks to be cut prior to cutting them, and I'm looking for vendor, amount, memo/description and class (at minimum.)

 

Solved
Best answer 04-04-2019

Best Answers
Highlighted
Anonymous
Not applicable

In search of an Unpaid Bills Report that includes Class

Thanks for responding back, bcolumbus.

 
Upon checking all possible reports and customization, only the Transaction detailed by Account can cater all the information you’re looking for. Since you’re a bit confuse with this report, I’d recommend exporting this to Excel (click the export icon next to gear icon to export the report to Excel) and delete the duplicate bills from there. 


I’ll make sure to take note of your ideal report and share this to our engineers for future updates. 


You’re always welcome to drop by again if you have other questions concerning QuickBooks. 
 

View solution in original post

18 Comments
Highlighted
Moderator

In search of an Unpaid Bills Report that includes Class

Hello bcolumbus,

 

Welcome to the Community. I'm here to lend a hand with the report you need for your unpaid bills in QuickBooks Online.

 

You can try running the Transaction Detail by Account report to show what you need. However, if you're using multiple classes on a transaction, it'll show the bill separately.

 

Here's how you can run the report:

 

  1. On the left panel, click Reports.
  2. Type-in Transaction and click Transaction Detail by Account.
  3. Choose a date range.
  4. Click the small gear icon within the report.
  5. Put a check mark beside Class.
  6. Click Customize.
  7. Put a check mark beside Transaction Type, and add Bill.
  8. Put a check mark beside A/P Paid, and select Unpaid.
  9. Click Run report.

For your visual reference, I'm adding some screenshots below:

 

 

 

Please don't hesitate to come here if you have additional questions or concerns about the report. The Community is here to ensure your success.

Highlighted
Level 1

In search of an Unpaid Bills Report that includes Class

Thank you! This is very close to what I need. The only confusing part is that each bill is listed twice, once as part of the A/P Account and once as part of the sub-account. And oddly, the memo/description field (which is really helpful) only appears on the sub-account line, not the A/P Account line. I've tried further filtering (only A/P, ALL A/P, everything except A/P) but I'm not getting the right results.

Highlighted
Anonymous
Not applicable

In search of an Unpaid Bills Report that includes Class

Hi, @bcolumbus.

 

Thanks for getting back on this thread and sharing additional details about pulling up the Transaction Detail by Account. Allow me to join in and help share some insights about the bill that's listed as twice.

 

You may need to check the transaction journal for the bill transaction to verify the accounts affected for that bill. I've attached a screenshot of the sample report I pulled up with unpaid bill transaction.

 

unpaid bills.PNG

 

If this is not what you're referring to, can you please provide a screenshot or any details about the report you pulled up? I'll be here to further help generate a specific report for unpaid bills that you need.

 

For more references you might need in the future, you can always visit our site: Help articles for QuickBooks Online.

 

Best regards.

 

 

Highlighted
Level 1

In search of an Unpaid Bills Report that includes Class

Yes, that's just what my transaction looks like. Is there a way I can only have the debit line listed? It seems that's the one that shows the description. 

Highlighted
QuickBooks Team

In search of an Unpaid Bills Report that includes Class

Thanks for getting back to us, @bcolumbus.

 

There's no way to only have the debit line in the journal entry.

 

The journal entry can consist of several recordings, each of which is either a debit or a credit. The total of the debits must equal the total of the credits or the journal entry is considered unbalanced.

 

On the other hand, the description will only show in the journal entry based on the account you use in a transaction with description. I've attached a screenshot below for your visual reference.

 

 

Fill me in if you have any other questions with QuickBooks Online. I'll be around if you need any help.

Highlighted
Level 1

In search of an Unpaid Bills Report that includes Class

That's great, but my question isn't about the journal entry - it's about getting a report out of QuickBooks. So I'm guessing the answer is No, I can't pull a report that ONLY shows the debit line from a journal entry? 

Highlighted
QuickBooks Team

In search of an Unpaid Bills Report that includes Class

Hello @bcolumbus,

 

You can pull up and customize your Journal report. Allow me to guide you through the steps.

 

It is possible to only show the debit line of your journal entries on a report. Here's how you can pull up and customize the report:

  1. On the left panel, click on Reports.
  2. Look for Journal on the search bar.
  3. Adjust the Report period.
  4. Click on Customize.
  5. Under the Rows/Columns drop-down, tick the rows you want t show on the report.
  6. Scroll down to the Filter drop-down.
  7. Under the Transaction Type drop-down, select Journal Entry.
  8. Click on Run Report.

 

 

 

Once done, you can click on Save Customization to save the report under your Custom Reports tab for easy viewing.

 

Feel free to leave a comment below if you have any other questions about your reports. I'd be glad to assist you.

Highlighted
Level 1

In search of an Unpaid Bills Report that includes Class

Thanks. I tried this, and looked for transaction type = Bill instead (because that's what I'm trying to get to) but I am not able to filter for A/P Unpaid, and choosing "check to be printed" as a filter results in nothing (when I know there should be 2 items.) 

Highlighted
QuickBooks Team

In search of an Unpaid Bills Report that includes Class

Hello there, @bcolumbus.

 

I appreciate you getting back to us and providing more information about your concern today. Let's customize your Journal report further to show the A/P Unpaid on the report.

 

Before we proceed, the "to be printed" note will only show if the transaction is a check, not a bill. Also, you can check the box beside A/P Paid to show the A/P Paid and A/P Unpaid transactions.

 

Here's how to customize the report:

 

  1. On the Journal report page, click the Gear icon.
  2. Check the boxes for A/P Paid and Check Printed.
  3. Then click Customize.
  4. Go to the Filter section.
  5. Select Bill in the Transaction Type drop-down.
  6. Click Run report.

Once done, I'm confident you'll be able to run the report with the data you wanted to show. Also, you can save the customized report by clicking the Save Customization.

 

In addition, here's a screenshot for your visual reference.

 

2.PNG

Please keep me posted on how things go with this. I'm here anytime you need further help customizing your reports.

Highlighted
Level 1

In search of an Unpaid Bills Report that includes Class

Thanks @Mark_R but that's not at all what I'm looking for. As my subject line and initial post indicate, I'm looking for a report that will show unpaid bills and has the following fields in the output: Date, Number, Vendor, Description, Account, Amount and Class. The Class field is the tricky one because it's not available in other reports that might otherwise show me unpaid bills.  The purpose of this report is for someone to review the QB info before another person goes through the check-cutting process.

Highlighted
Moderator

In search of an Unpaid Bills Report that includes Class

Thank you for the quick response, @bcolumbus!

 

Allow me to join into this thread and help pull up and customize your Purchases by Vendor Detail report. Let me show you how.

  1. Go to Reports.
  2. Under Expenses and Vendors, select Purchase by Vendor Detail.
  3. Hit Customize and then, select a Report Period.
  4. Choose Vendor under Group by below Rows/Columns.
  5. Click Change columns.
  6. Select Date, Transaction Type, Num, Product/Service, Memo/Description, Amount, ClassAccount, and A/P Paid.
  7. Hit Filter and then, select Transaction Type, Vendor, Products/Service, and A/P Paid.
  8. Choose Bill in the Transaction Type drop-down menu.
  9. From the A/P Paid drop-down menu, select Unpaid.
  10. Click Run report.

Once completed, I'm confident you'll be able to pull up a report with unpaid bills and the filters of your choice.

 

In addition, here's a couple of screenshots for your visual reference. Also, I've included our detailed guide in customizing your report.

 

 

Lastly, you can save this customized report by clicking Save customization. Then, go to the Custom reports tab when you need to pull up this report in the future.

 

Please let me know if you have any other questions about reports in QuickBooks Online. It'll be always my pleasure to help.

Highlighted
Level 1

In search of an Unpaid Bills Report that includes Class

Thanks @JonpriL! Strangely, I think this is exactly what I did when I first attempted to make such a customized report....and did it again, just now, but I'm getting zero results, and I know there are two bills in the system to be paid. (I've tested it - if I go to Pay Bills, two show up.) What would be a reason why a vendor (in this case two separate ones) would not appear in this report?

 

 

Highlighted
QuickBooks Team

In search of an Unpaid Bills Report that includes Class

Hi there, @bcolumbus.

 

I appreciate you coming back to us for additional support and providing more details. I can share the reason why the unpaid bills are not showing on the Purchases by Vendor Detail report.

 

Only bills with items associated with them will show on the Purchases by Vendor Detail report. Most likely the two bills for separate vendors have accounts and that's why they're not showing.

 

If you like a report that shows unpaid bills regardless if it's for accounts or items, try pulling up the Accounts Payable Aging Detail report.

  1. On the left menu, click Reports.
  2. On the search field, enter Accounts Payable Aging Detail.
  3. Customize the report to your desired report period, aging period and many more.
  4. Click Run Report to refresh the information.

1.PNG 2.PNG

That's it. I'm still here to help you further if you have other report concerns. Just drop a comment or mention my name. Have a wonderful day!

Highlighted
Level 1

In search of an Unpaid Bills Report that includes Class

@HoneyLynn_G  - the bills that are open look no different than other bills, both using a service in the Category field. And, the Aging AP doesn't have Class as an optional output field.

Highlighted
Anonymous
Not applicable

In search of an Unpaid Bills Report that includes Class

Thanks for responding back, bcolumbus.

 
Upon checking all possible reports and customization, only the Transaction detailed by Account can cater all the information you’re looking for. Since you’re a bit confuse with this report, I’d recommend exporting this to Excel (click the export icon next to gear icon to export the report to Excel) and delete the duplicate bills from there. 


I’ll make sure to take note of your ideal report and share this to our engineers for future updates. 


You’re always welcome to drop by again if you have other questions concerning QuickBooks. 
 

View solution in original post

Highlighted
Level 1

In search of an Unpaid Bills Report that includes Class

Thank you @Anonymous . That's the solution I've sort of come to as well. Filtering the column that houses the account field, filtering for A/P and deleting those rows, seems to work. Hopefully someday Class will be added to more report outputs.

 

I appreciate all the help folks!

Highlighted
Level 1

In search of an Unpaid Bills Report that includes Class

Hi -- 

I am trying to run the same report and have tried these instructions a number of times, but am having trouble. It is cooperating up until the point that I mark the box for A/P Paid - Unpaid. As soon as I mark that box, the report says that it does not contain any data. Some of these bills were only entered this morning and there is absolutely no payment recorded, but when I mark that box - it eliminates all of the transactions entirely. Please help!

Highlighted
QuickBooks Team

In search of an Unpaid Bills Report that includes Class

Hi @mjarvisbm,

 

Thank you for joining the thread and reporting your issue is such a detailed manner. That is much appreciated.

 

With how you described it, I suggest checking the date range of your open report to see if it includes the date when those new bills were recorded.

 

If there's still no open bills that appear, let's try to only use 2 filters which are Transaction Type - Bill and A/P Paid - Unpaid. Then work your way to enabling other filters you need, one at a time. This should allow you to isolate the filter causing your report to show nothing.

 

You can open this article that shows you how to customize vendor reports. This includes bills, purchase orders, vendor payments and more.

 

I'd be glad to answer any other questions you might have. Feel free to leave a comment below and I'll get back to you as soon as I can.

Need to get in touch?

Contact us