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

Statement charges and Payments for those charges in one report

Currently I am using Quickbooks Pro 2015 desktop.  I run a property management company. each tenant is set up as a customer.  The county bills every 3 months for water which the customer is responsible.  We currently place a statement charge of 1/3 the expected future water bill on each monthly statement charge. The charge is attached to a Water Budget Account, which I have set up as an income account. I realize it should be a short term current liability.

When a customer makes a payment it is usually combined with rent. I apply the payment to the appropriate statement charges.

Then I receive the quarterly water bill which I then put it on the statement as a charge.

Then I apply the money I collected in the Water Budget Account as a credit on their statement.

I need a single report that shows the charges, the payments and any withdrawals from the account with a balance column.

Is there any way to make such a report? I have spent about 20 hours trying on my own.

3 Comments
Highlighted
QuickBooks Team

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.

Highlighted
Level 15

Statement charges and Payments for those charges in one report

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?

Highlighted
Level 1

Statement charges and Payments for those charges in one report

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.

Need to get in touch?

Contact us