cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Explorer **

On the bill payment list report, can I add the category that the bill was charged to?

 
Solved
Best answer 03-26-2019

Accepted Solutions
QuickBooks Team

Re: On the bill payment list report, can I add the category that the bill was charged to?

Thanks for getting back to us, ConnieScroggins.

 

The possible reports that you can pull up it's either Transaction Detail by Account and the Bills and Applied Payments which help you shows the bill payment report with the affected accounts. However, there isn't a way to include the item lines, so you need to open each bill transaction.  

 

For additional reference, you can check this article on how you can customize report in QuickBooks Online (QBO). 

 

I appreciate your patience. Please know that you're always welcome to post again if you have any other concerns. The Community team will always got your back. 

 

 

 

8 Comments
Intuit

Re: On the bill payment list report, can I add the category that the bill was charged to?

Hello,

 

I would say run the Bills and Applied Payments report and add the SPLIT column.

(picture attached)

Community Explorer **

Re: On the bill payment list report, can I add the category that the bill was charged to?

Thanks, this works great when the bill has only one line item. But if the bill actually is split, it just says "split."

QuickBooks Team

Re: On the bill payment list report, can I add the category that the bill was charged to?

Thank you for the quick response, @ConnieScroggins!

 

Allow me to chime in for a moment and help you pull up a bill payment report showing your affected accounts.

 

Yes, you're absolutely correct. As of the moment, the only option to show the affected accounts of your split bill transaction is through clicking -Split-.

 

From there' you'll be routed to your bill and it will show you the affected accounts.

 

In addition, I've included a couple of screenshots below for your visual reference. You can also save this customized report by clicking Save customization. Then, you can find this report in the Custom reports tab when needed.

 

 

Lastly, here's an article you may want to read for your future reference: How to Set Up a Recurring Bill?

 

Fill me in if you have any other questions about your bills and reports. It'll be always my pleasure to lend you a helping hand.

Community Explorer **

Re: On the bill payment list report, can I add the category that the bill was charged to?

Thank you, but this won't work for us either. My Treasurer wants a report that shows all of the breakdowns, printing each line item of a split transaction would be crazy. Some of our bills have 20+ line items!  I will make him halfway happy by printing it out with split so that some show and some do not. Best we can do, right?  Thanks again!

QuickBooks Team

Re: On the bill payment list report, can I add the category that the bill was charged to?

Thanks for getting back to us, ConnieScroggins.

 

The possible reports that you can pull up it's either Transaction Detail by Account and the Bills and Applied Payments which help you shows the bill payment report with the affected accounts. However, there isn't a way to include the item lines, so you need to open each bill transaction.  

 

For additional reference, you can check this article on how you can customize report in QuickBooks Online (QBO). 

 

I appreciate your patience. Please know that you're always welcome to post again if you have any other concerns. The Community team will always got your back. 

 

 

 

Intuit

Re: On the bill payment list report, can I add the category that the bill was charged to?

Hello @ConnieScroggins ,

 

Please see the attached report and let me know if this is closer to what you're looking for.  Also if you can confirm which version of QuickBooks Online you're using.

 

The report below shows the following:

ONLY the bill that have been fully paid off

It shows the breakdown of what expense accounts the bills affected.

 

Please let me know if this would be acceptable and if it is I can give the details on how to run it.

 

 

Community Explorer **

Re: On the bill payment list report, can I add the category that the bill was charged to?

Thanks. The only problem with this is it doesn't show split payments on the same bill. 

Not applicable

Re: On the bill payment list report, can I add the category that the bill was charged to?

This is an ongoing source of frustration for me as well. The desktop version of QB had a "check detail" report that showed each check, the bills that were paid, and the split detail of how the expenses were classified. The lack of split detail on the "bills & applied payments" report leads to significant manual work in excel for me monthly on several accounts for my clients. Crazy that we can't have the corresponding report in QBO.

Need to get in touch?

Contact us