Statement charges and Payments for those charges in one report

Hi there, @SteveIBrown.

Good to see you here in QuickBooks Community. Allow me to help and ensure you'll be able to pull up the report you need.

You can run the Transaction Detail by Account report to show the charges, payments, and withdrawals from each account. You can also customize it to add the balance column.

Let me walk you through the steps:

1. At the  top menu bar,click Report.
2. Select Accountant & Taxes.
3. Go to Transaction Detail by Account. 
4. Click Customize Report.
5. On the Search Column bar, type-in Balance.
6. Make sure to put a check mark on it. 
7. Once done, OK. 

For additional reference, you can check this article to learn more on how to customize reports in QuickBooks Desktop. 

if you need further assistance with the steps, I encourage you to contact our QuickBooks Desktop Support Team. They have additional tools to pull up your account and do a remote session. 

Here's how to contact our phone support:

1. Click this link:https://help.quickbooks.intuit.com/en_US/contact.
2. Select US version of QuickBooks Desktop, and click Contact Us.
3. Type-in Customer Care on the search bar.
4. Click Get the phone number below. 

This will get you on the right track! Don't hesitate to leave a comment if you have any other concerns about the reports in QuickBooks. Have a good one.

This part seems wrong: "Then I apply the money I collected in the Water Budget Account as a credit on their statement."

You apply their Payment. The Statement Charge for water, then gets Paid. You don't also give them Credit; that would reverse that you first charged them.

Here's how to do this:

You set up a Single-sided Other Charge type item and link it to Water income or Water Liability, to meet your accounting requirements.

You list this for the Statement Charge. That is how you collect the funds.

You list that same item on the Items tab of the Payment. That's how you show you Reduced the funds prepaid to you.

There is nothing to Credit Back to the owners. You are confusing either Income-Expense, or Liability-Cleared Liability, with a process that would turn this into "Liability prepaid, actual owed, prepaid applied." Those are Three Different Concepts.

Which do you want to be doing?

Thank You. I think your answer is closest to what I need. I will need to wrestle around with that this week. I think I have misstated some steps. So I will probably give you a better response next week.