Unpaid Bills in reporting

Accrual P&L By Class

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.

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

---

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.

---

@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)

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.

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.

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!

This worked, thanks!

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.

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?

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.