249

cojBBOxUSr3PKzacfA8pyY

RSS

strudel

New Member

06/21/09 10:16pm PDT
Viewed by asker 08/11/09 6:51pm PDT

Report of monthly expenses not including payments made?

US QuickBooks for Macintosh

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!

Report Abuse

This post is closed to new replies

6 Replies

Debi Calvet

Allstar

06/22/09 5:12pm PDT

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

http://www.advantgroup.biz

Debi Calvet, former business owner & long-time QuickBooks for Mac user
Please remember: This is a user-to-user forum—not QuickBooks Technical Support.

Report Abuse

strudel

New Member

06/22/09 9:09pm PDT

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!

Report Abuse

Debi Calvet

Allstar

06/23/09 8:58am PDT

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.

Debi Calvet, former business owner & long-time QuickBooks for Mac user
Please remember: This is a user-to-user forum—not QuickBooks Technical Support.

Report Abuse

strudel

New Member

06/23/09 11:19am PDT

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!

Report Abuse

Debi Calvet

Allstar

06/23/09 12:18pm PDT

The solution

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.

http://screencast.com/t/gQsw8v...

Debi Calvet, former business owner & long-time QuickBooks for Mac user
Please remember: This is a user-to-user forum—not QuickBooks Technical Support.

Report Abuse

strudel

New Member

06/23/09 5:59pm PDT