Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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:
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here