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

Unpaid Bills in reporting

Is there any way, workaround, or similar that you could get an unpaid, but entered, bill to show in a report such as a report detailing everything of a certain CLASS?

Solved
Best answer October 14, 2020

Best Answers
SashaMC
Moderator

Unpaid Bills in reporting

Welcome to the QuickBooks Community, kevinhtre. There is a workaround you can do to get that report by running the Transaction Detail by Account report. I will be happy to show you how.

 

  1. Go to the Reports menu.
  2. Use the search back and type Transaction Detail by Account.
  3. Enter the date range.
  4. Click the small gear icon within the report.and checkmark Class.
  5. Click Customize.
  6. Add a checkmark beside Transaction Type, and search and add Bill.
  7. Scroll down and add a checkmark beside A/P Paid, and click Unpaid.
  8. Click Run report.

Once that report runs, you should have your Unpaid Bill report with Class. Please let me know if you need any additional assistance. You’re always welcome to drop by again if you have other questions concerning QuickBooks.Take care and be safe.

View solution in original post

13 Comments 13
john-pero
Community Champion

Unpaid Bills in reporting

Accrual P&L By Class

SashaMC
Moderator

Unpaid Bills in reporting

Welcome to the QuickBooks Community, kevinhtre. There is a workaround you can do to get that report by running the Transaction Detail by Account report. I will be happy to show you how.

 

  1. Go to the Reports menu.
  2. Use the search back and type Transaction Detail by Account.
  3. Enter the date range.
  4. Click the small gear icon within the report.and checkmark Class.
  5. Click Customize.
  6. Add a checkmark beside Transaction Type, and search and add Bill.
  7. Scroll down and add a checkmark beside A/P Paid, and click Unpaid.
  8. Click Run report.

Once that report runs, you should have your Unpaid Bill report with Class. Please let me know if you need any additional assistance. You’re always welcome to drop by again if you have other questions concerning QuickBooks.Take care and be safe.

kevinhtre
Level 1

Unpaid Bills in reporting

hi. thanks for this. unfortunately this groups things by account. i'm trying to get a read out of everything in a class, INCLUDING unpaid bills. so, i took the additional step of choosing to group by class. when i choose 'all' for a/p the unpaid bill does not show. when i choose unpaid, the bill still does not show.

kevinhtre
Level 1

Unpaid Bills in reporting

hi thanks for replying. so i ran a p&l and changed it to 'accrual', but unpaid bills do not show no matter what i do. did you do anything else?


@john-pero wrote:

Accrual P&L By Class


 

Mark_R
Moderator

Unpaid Bills in reporting

I'm here to ensure you'll be able to see your unpaid bills in the Transaction Detail by Account report, @kevinhtre.

 

It's possible that the date range of the report doesn't have bill transactions. Let's make sure that you select the date when the bills are made.

 

Here's how:

 

  1. Open the Transaction Detail by Account report.
  2. In the Report period drop-down, select the date when the transactions are made.
  3. Then, make sure you selected Class in the Group by drop-down.1.PNG
  4. Follow the steps 5-7 shared by my colleague SashaMC above to customize.
  5. Click Run report.

Here's an article you can read to learn more about customizing reports: Customize reports in QuickBooks Online.

 

Just in case you want to memorize this report, feel free to check out this article for the detailed steps and information: Memorize reports in QuickBooks Online.

 

Please touch base with me here for all of your QuickBooks needs, I'm always happy to help. Have a good day.

kevinhtre
Level 1

Unpaid Bills in reporting


@Mark_R wrote:

I'm here to ensure you'll be able to see your unpaid bills in the Transaction Detail by Account report, @kevinhtre.

 

It's possible that the date range of the report doesn't have bill transactions. Let's make sure that you select the date when the bills are made.

 

Here's how:

 

  1. Open the Transaction Detail by Account report.
  2. In the Report period drop-down, select the date when the transactions are made.
  3. Then, make sure you selected Class in the Group by drop-down.
  4. Follow the steps 5-7 shared by my colleague SashaMC above to customize.
  5. Click Run report.

Here's an article you can read to learn more about customizing reports: Customize reports in QuickBooks Online.

 

Just in case you want to memorize this report, feel free to check out this article for the detailed steps and information: Memorize reports in QuickBooks Online.

 

Please touch base with me here for all of your QuickBooks needs, I'm always happy to help. Have a good day.


thank you. should this be ACCRUAL? i think that's the difference. seems like when i change the report to be accrual, it shows up? (including all the steps you and sasha mention.ed)

Rubielyn_J
QuickBooks Team

Unpaid Bills in reporting

There's no need for you to toggle it into accrual basis, @kevinhtre,

 

You can run the AP aging report. This organizes your business's accounts payable (AP) balances. Accounts payable aging report also helps you visualize the amounts you owe.

 

Here's how: 

  1. Sign in to your QuickBooks Online account. 
  2. Go to the Reports menu.
  3. Look for Accounts Payable Aging report.
  4. Choose the date under Report period.
  5. Click Customize button to add some filter to your report.
  6. Once done, click Run report.

For additional information, you can check this article on how to add filter to your report: Customize reports in QuickBooks Online.

 

You'll want to save your current customization. Feel free to read this resource for the details: Memorize reports in QuickBooks Online. 

 

Don't hesitate to comment below if you have further concerns. I'm more than happy to help. Have a great day.

crcurry
Level 1

Unpaid Bills in reporting

This worked for the report I am trying to create. Basically, I am looking to create a report that shows all unpaid bill line-item detail grouped by vendor, which also shows account, class, and description. I was able to do this except I am trying to make one small adjustment... the report I generated is showing an Accounts Payable line for the total bill amount in addition to the line item expense accounts on the bill. I just want to see the line items. Is there any way to remove this Accounts Payable line from the report? Attached is an example of what I am referring to.

Kurt_M
QuickBooks Team

Unpaid Bills in reporting

It's great to see you here in the thread, @crcurry.

 

I appreciate you for providing details about the situation you're in. You're on the right track, and we'll only have to tweak some things inside the report you're trying to generate to get around this and get rid of the Accounts Payable.

 

You'll want to customize the report and head to the Filter section. I'll input the steps below to get you going.

 

  1. Access your QuickBooks Online company.
  2. Go to the Reports tab, and then access the report that you need.
  3. Click the Customize button, and then head to the Filter section.
  4. Check the box beside the Distribution Account and Transaction Type.
  5. In the Distribution Account, uncheck the box beside Accounts Payable (A/P). Also, if you have bill payment transactions, you'll want to uncheck it in the Transaction Type.
  6. Once done, click the Run report button.

 

For visual reference, see the attached screenshot below.

 

You can visit this article to learn more about customizing reports inside QBO: Customize reports in QuickBooks Online.

In addition, if you wish to keep your report's current company settings, you can check this article: Memorize reports in QuickBooks Online.

@crcurry, it's been a pleasure to have you here today. You can post here again if you have any additional QuickBooks-related queries. I'll be here, ready to assist you. Take care!

crcurry
Level 1

Unpaid Bills in reporting

This worked, thanks!

MichelleBh
Moderator

Unpaid Bills in reporting

It's our pleasure to help with your QuickBooks concern anytime. That's our goal for every customer we have, @crcurry

I'm happy that my colleague gave you the help you needed to run the unpaid bills report.  If you have other questions about your account, don't hesitate to post here or create a new thread. We are always here. Keep safe.

 

crcurry
Level 1

Unpaid Bills in reporting

One more question... is there a good way to add a total on the bottom of this report that totals up all outstanding unpaid bills?

LeizylM
QuickBooks Team

Unpaid Bills in reporting

Hi there, crcurry.

 

I'll make sure you'll be able to add the total of the outstanding paid in QuickBooks Online (QBO). 

 

In your Transaction Detail by Account report, we can customize the fields to show the total outstanding unpaid bills in QBO. 

 

Here's how: 

 

  1. Go to Reports and search for Transaction Detail by Account report.
  2. Select the Customize tab and pick the appropriate Report period in the field. 
  3. Click Customize.
  4. Go to Filter and Select  A/P paid and Unpaid.
  5. Click  Run report. 
  6. Go to the small Gear icon and put a checkmark on A/P paid.

 

 

Furthermore, we can also memorize the report to save the settings. This allows us to run the same customized report in the future.

 

Should you need more help with generating a report in QuickBooks Online, please let me know. Have a wonderful day.

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

Need to get in touch?

Contact us