Report of monthly expenses not including payments made?
6/21/09 10:16 PM, Viewed by asker 8/11/09 6:51 PM
Total Views: 541
Greetings,
I have an apartment that I'm renting out short term. There are expenses that occur every month for the place (maintenance, mortgage, utilities, internet, phone,etc.) some of which are charged to tenants, and some of which are charged to a partner.
What I want to do is generate a report of just the monthly expenses (as noted above), but not including payments made toward them. In other words, I just want to see what the actual monthly expenses are, not caring about profit or loss. Is there a way to do this? Every report I've looked at shows not only the expenses, but also the payments made toward the expenses, and I just want to see the expenses.
Thanks in advance!
Whenever I try to call up a report of
Solved!
Helpful Answer
You don't have to enter bills to use vendors. If you prefer, you can just write checks to vendors. I would have set all of these parties up as vendors myself. For one thing, it's possible you should be issuing 1099-MISC forms for some of these entities, and you can set up vendors as "1099" vendors. (Talk to your tax advisor about that.)
However, for now, perhaps using a Custom Transaction Detail Report filtered as shown in this screenshot will work. After applying the filters, choose "Payee" from the "Total By:" drop-down menu.
Long-time QuickBooks for Mac user
Former business owner
NOTE: This is a user-to-user forum and not official Technical Support.
Answer
Here's one way:
1. Generate a Job Profitability Summary report.
2. Double-click on the TOTAL for the applicable customer/job in the "Act. Cost" (actual cost) column.
That will generate a detail of the expenses that compose that total.
Debi Calvet
AdvantGroup LLC
Long-time QuickBooks for Mac user
Former business owner
NOTE: This is a user-to-user forum and not official Technical Support.
Answer
Have you tried the Expenses by Vendor Detail report (Company & Financial > Expenses by Vendor Detail)? When I generate one of those, it shows all bills, credit card charges (and credits, but not payments), checks, and the rare bank-account deposit from a vendor. It does not show bill-payment checks. The expenses are group by vendor name.
Long-time QuickBooks for Mac user
Former business owner
NOTE: This is a user-to-user forum and not official Technical Support.
Comment
Hi again and thanks again!
Actually, I didn't setup any vendors; all of the expenses go to people I set up on the Other list. The expenses are mainly like for the mortgage payment, utilities, maintenance, internet, etc., and I'm not billed by any of them -- it's all just directly paid from my checking account. If I set up vendors, then I guess I'd have to create a bill and then pay it, rather than just tracking the amounts in the checking register.
Any other ideas? Should I have set this up differently do you think? I'm trying to keep the setup as simple as possible (meaning, requiring the least amount of bookkeeping time on my part). And thanks again for your input!
Solved!
You don't have to enter bills to use vendors. If you prefer, you can just write checks to vendors. I would have set all of these parties up as vendors myself. For one thing, it's possible you should be issuing 1099-MISC forms for some of these entities, and you can set up vendors as "1099" vendors. (Talk to your tax advisor about that.)
However, for now, perhaps using a Custom Transaction Detail Report filtered as shown in this screenshot will work. After applying the filters, choose "Payee" from the "Total By:" drop-down menu.
Long-time QuickBooks for Mac user
Former business owner
NOTE: This is a user-to-user forum and not official Technical Support.
Comment
Thanks so much for the info! I've switched some of the payees over to be Vendors (I for some reason thought I had to do bills for Vendors), and this is making everything clear. Thanks so much for hanging in there on this question! I appreciate it.
Comment
Hi and thanks for the tip! The problem is that most of the expenses I have aren't charged to a job at all. To be more clear, I should have said above, "There are expenses that occur every month for the place (maintenance, mortgage, utilities, internet, phone,etc.) some of which are charged to tenants, and some of which are charged to a partner, BUT MOST NOT CHARGED TO ANY JOB."
Any ideas? And thanks so much for your response!