Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. Cancel anytime.
Already a Pro Member? Sign in here
Pick markets, find deals, analyze and manage properties. Try BiggerPockets PRO.
x
All Forum Categories
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

All Forum Posts by: David M.

David M. has started 11 posts and replied 61 times.

Post: Appfolio Expense Transaction Report

David M.Posted
  • Investor
  • Cincinnati, OH
  • Posts 61
  • Votes 35
Quote from @Michael Smythe:

Your PMC should be able to auto-email you a monthly P&L report in CSV format.


 Thanks for the response. I see an "income statement" report, but that doesn't have individual transactions. I need to know each transaction by property, not a sum of all transactions for a period of time. 

Post: Appfolio Expense Transaction Report

David M.Posted
  • Investor
  • Cincinnati, OH
  • Posts 61
  • Votes 35

Hi, all.

For those of you who use Appfolio, I'm looking for a report on the property manager portal that can be exported to CSV and includes all expense transactions for a property, similar to the Income Register report. Does one exist?

I'm technically an owner with access to a property manager account for my portfolio that's managed by a PM, so I don't have access to the general ledger itself. I'd like to combine the CSV files for both the income register & the expense transactions into a customizable dashboard for the portfolio (similar to what I do in my W-2 job).

Thanks!

Post: Appfolio Expense Transaction Report

David M.Posted
  • Investor
  • Cincinnati, OH
  • Posts 61
  • Votes 35

Hi, all.

For those of you who use Appfolio, I'm looking for a report on the property manager portal that can be exported to CSV and includes all expense transactions for a property, similar to the Income Register report. Does one exist?

I'm technically an owner w/ access to a property manager account for my portfolio, so I don't have access to the general ledger itself. I'd like to combine the CSV files for both the income register & the expense transactions into a customizable dashboard for the portfolio (similar to what I do in my W-2 job).

Thanks!

Post: Owner Statement on Appfolio

David M.Posted
  • Investor
  • Cincinnati, OH
  • Posts 61
  • Votes 35

Thanks so much for the feedback! You said:

" When expense exceeds rent, the monthly owner statement will show that you and you should be able to log into your portal and make a contribution."

If multiple units for one owner have expenses that exceed rent, do they make individual contributions, or a lump sum contribution to cover all properties that owe a balance at the end of the month? I'd rather itemize for tracking purposes, but want to make sure.

Post: Owner Statement on Appfolio

David M.Posted
  • Investor
  • Cincinnati, OH
  • Posts 61
  • Votes 35

Hi, all.

I hired a PM for my portfolio (10 SFH) and the portfolio inside a family trust (50+ SFH). I really enjoy the PM - he's responsive, has a good team of handymen and a couple full-time rehab teams on staff (necessary given the state of the properties we inherited in the trust), and keeps me in the loop on what's going on with the properties. However...I'm really struggling with their accounting. I came from Buildium, on which I did my own accounting, and I can't tell if the lack of clarity on these owner statements that are posted to the owner portal is a result of me being used to the ledgers looking different, their accounting practice being sloppy, or Appfolio's presentation of the ledgers on this report.

So a couple of questions:

1) How does your PM handle bills that exceed the monthly rent? Ours doesn't require that we leave a balance in escrow for each property, and instead charges against the rent on another property in the portfolio on the ledger. This has led to the charge occasionally being double-booked - once against the original property that had the repair, and again against the rent on the second. That is...frustrating. Is there a way to collect all of the amounts that exceed that month's rent into one itemized report and pay it via an owner contribution?

2) Is there a more useful report than the owner statement I can request from the PM on Appfolio? I'm flying blind here because I don't have/can't get access to the reporting functions of Appfolio, and I don't think the accounting team with this PM has done much research/investigation into the features of Appfolio. I have experience with Buildium, a business degree (with several accounting classes), and work with data/admin pages of corporate websites for my day job. I would kill for a demo account w/ dummy data just to see what it looks like back there to give them specific requests, but I can't find it anywhere.

Post: Appfolio Experience as Property Owner?

David M.Posted
  • Investor
  • Cincinnati, OH
  • Posts 61
  • Votes 35
Quote from @Richard F.:
Quote from @David M.:.

 I'd be fine with those if I could get them more frequent - say, twice a month. Is that an option on the reporting pages of Appfolio?

Aloha,

I doubt twice a month reporting would be of any use, at least from any PM that handles more than hundred units. The PM is not going to disrupt their entire work flow to give you up to the minute info. Any competent PM Co has a staff that processes routine financial items in large batches. For example, rents are due on the first...but tenants make their payments over a number of days (which varies based on the grace period different owners might have). If the PM is processing hundreds or thousands of rent (or maintenance fee) payments, they will be inputting payments for an entire week or 10 days. By the end of that period, they need to generate and send late notices. Then they switch to processing vendor payments, which again takes a certain amount of time to process. They need to first ensure the invoice is correct and identified for the right job address, and each invoice needs to be charged against the correct property, including coding the proper sub account, so this is a slower process at times, and is generally performed twice...once by the PM that ordered the job, and then re-checked by accounting staff for accuracy. Billing errors, insufficient info on the invoice with regard to what was done, and for new vendors, confirming they are properly licensed and/or insured prior to payment, all take time. Again, depending on the PM, and their staffing level, Owner reports are often generated mid month of the current month, if you are lucky, and mid month of the month AFTER the reporting month is more typical. Often when reports are current month, an "amended" report will be sent near or after end of current month if a particularly late payment comes in, or a vendor payment invoice comes in late and needs to be paid prior to the next month's batch. Before starting to process the new month payments, the prior month is checked again for any glaring errors, and then the month is ""locked", preventing any changes to that month, at any time in the future, by anyone.

I do not know of Appfolio's capabilities, but any competent PM should be providing copies of all PAID invoices with the monthly reports, in the month they are paid.
Great info, thanks. I'm used to doing all of my own accounting and getting it done immediately to have visibility, but that's definitely an unrealistic expectation. You don't happen to post on Bogleheads, do you?

Post: Appfolio Experience as Property Owner?

David M.Posted
  • Investor
  • Cincinnati, OH
  • Posts 61
  • Votes 35
Quote from @Simon W.:
Quote from @David M.:

Hi, all.

I've been managing my own properties for more than a decade using Buildium. I'm now hiring a PM who uses Appfolio for my portfolio, and my family's portfolio. There are about 60 units total between the two portfolios. 

It looks like Appfolio doesn't have a way for owners to see ledgers in real time - instead owners can only see reports that are generated at specific moments in time. Is that true? Is there a way for me to see the lease ledger and accounting ledgers in real time, without waiting for a monthly report? I want to be more informed than that, but don't want to be constantly bothering PM staff. Buildium's owner portal let's owners see the ledgers at any time, which is really nice. 

Thanks!


 Typically, PM companies aren't going to show the General Ledgers to their owners. Not sure why you would want to.  The owner statement, income statement or cash flow statement should be enough for you to quick anything. 

The whole letting owner see extra thing is a role permission. 

I oversee a PM company with 1500+ units using AppFolio, non of the owners see the ledgers. my 2cents.


 I'd be fine with those if I could get them more frequent - say, twice a month. Is that an option on the reporting pages of Appfolio?

Also, do they send copies of all itemized invoices through those reports as well?

Post: Appfolio Experience as Property Owner?

David M.Posted
  • Investor
  • Cincinnati, OH
  • Posts 61
  • Votes 35
Quote from @Chris Davidson:

@David M. I am not sure on the appfolio question, but do want to push back on is checking the ledger really what you need to be doing. If you hire a PM let them manage. Are you paying out multiple times a month, or just checking it for feel good.

Keep crushing it on rentals!


 I'm a bit of a control freak, especially having managed my own for so long. Now I'm managing the family trust's portfolio too and want to have a close eye on what's going on the first few months. There's a lot of deferred maintenance on the properties, rents are 30% below market and mostly month-to-month, and we just generally need to know what's happening to make decisions on what tenants are staying, what properties will be sold, etc. 

I'm nervous that a monthly report will be too hands-off when the portfolio is in flux, but I know most PMs don't want me looking over their shoulder forever.

Post: Appfolio Experience as Property Owner?

David M.Posted
  • Investor
  • Cincinnati, OH
  • Posts 61
  • Votes 35

Hi, all.

I've been managing my own properties for more than a decade using Buildium. I'm now hiring a PM who uses Appfolio for my portfolio, and my family's portfolio. There are about 60 units total between the two portfolios. 

It looks like Appfolio doesn't have a way for owners to see ledgers in real time - instead owners can only see reports that are generated at specific moments in time. Is that true? Is there a way for me to see the lease ledger and accounting ledgers in real time, without waiting for a monthly report? I want to be more informed than that, but don't want to be constantly bothering PM staff. Buildium's owner portal let's owners see the ledgers at any time, which is really nice. 

Thanks!

This is a...new one for me.  A tenant reached out to tell me that she and her husband were divorcing, he had already moved out (and she was pursuing a restraining order, but does not have one yet), and she wants to stay.  I told her that I needed confirmation from the husband that he had moved out, a new application with updated proof of income from her, and I could draw up a new lease.

The husband refuses to return my calls or her calls, so I'm at a crossroads in terms of how to proceed.  The tenants are on a month-to-month lease (they've been there for years), so I can deliver a 30 day notice to vacate (Ohio) to the house and draw up a new lease to start the following month with just her on the lease.

Thoughts?