Financial Diagnostics in AppFolio

December 13, 2022
70+
Lorem Ipsum dolor sit amet.
Lorem Ipsum dolor sit amet.

Updated: 12/5/2022

The Financial Diagnostics report is one of the most useful tools in AppFolio, however, most people don't know that it exists. For those of you who do know what it is, do you know how to make the corrections properly? Some of you do, but most people make "bandaid entries" like non-cash Journal Entries or receipts that never clear the reconciliation. Today, we are going to briefly go over the Financial Diagnostics sections related to tenant security deposit liability and how to avoid future issues.

What do the sections indicate?

AppFolio does a good job of dropping little tips and tricks throughout the software. For instance, you can review details about any of the Diagnostics sections by hovering over the "i" to the right of each section title. Today, we will summarize the meaning of the sections in this blog to save you the time.

Security Deposit Funds Mismatch

This section focuses on discrepancies on the Property Level versus the Tenant Level. It compares the two by running a General Ledger for all key security deposit accounts. You can check what those are by going to your name in the upper right corner > General Settings > Manage Accounting Settings > Under "Other Key Accounts" > "Security Deposit Account" and "Additional Deposit Accounts".

Escrow Cash Account Balance Mismatch

In this section, you will find discrepancies between your Security Deposit/Escrow Cash balance and the Security Deposit liability accounts offset to that cash account. These two amounts should always be the same, and if they are not, they show here.

Non-Zero Security Clearing Account Balances

The Clearing account is a pass-through account in AppFolio that should always have a balance of $0.00. A common way to explain this is like a parking spot: It's a temporary holding spot, but whatever goes in must eventually come out. That holds true for the Clearing account in AppFolio as well. When you move out a tenant, all refunds will go through Clearing and all transfers between two bank accounts will also be offset to the clearing GL account. As long as you are following the move-out flow process, you shouldn't have any issues here.

<blog-cta>Have questions about your diagnostics page? Click here to get help from an AppFolio expert!<blog-cta>

How to avoid diagnostics issues

Ideally, your diagnostics should be clean when you close out your books each month, and before you send any owner or management fee payments. The reasoning for this is you may have errors in a move-out, funds that need to be transferred, or security deposits that are unapplied or applied to the wrong GL account.

So, how would you avoid issues in these sections on your diagnostics?

  1. Complete move-outs within the Move Out Tenants (or Move Out One Tenant) flow and complete each step. Do not manually enter a tenant Notice or Move Out date under "Status", start a move out to enter any of that information, and save it for later if you're not ready to enter any additional information.
  2. Make it a habit to record transfers in AppFolio first and then write it down, put it in a note, whatever works for you. After you complete your move-outs for the day, take that list and make the transfers in the bank (one-by-one if possible so everything lines up with AppFolio).
  3. Check the Diagnostics page once you complete 1 or more move-outs to ensure there are no outlying issues.
  4. Make sure your Security Deposit Interest account is offset to the Security Deposit/Escrow account and is set as a key security deposit account. You can change your GL account setting under Accounting > GL accounts > select Interest account > Edit > change offset if needed. You can change your key account settings by going to your name in the upper right corner > General Settings > Manage Accounting Settings > Other Key Accounts > Scroll to the bottom > Add your interest account > Save.
  5. Consolidate duplicate liability GL accounts to eliminate confusion. For example, if you have a "Security Deposits" and a "Management Held Security Deposits" GL account both offset to the Security Cash then you should merge them. If one should be pet deposits or last month's rent, then be sure it is named accordingly. To merge GL accounts, you would need to submit a support request to GL account. Be sure to include what GL account you would like to keep as the main account and which one you would like to merge.

<blog-cta>Need help submitting a support request to AppFolio? We can help with that!<blog-cta>

Additional Diagnostics Help

In this blog, we went over the three main sections on the diagnostics that deal with security deposit liability and how to avoid issues in those sections. If you have questions on additional sections in the diagnostics, or how to research outstanding issues, please reach us on our website or by calling or texting 281-949-8755.

Our Services

On-Demand Consulting

On-Demand Consulting

Consulting with AppFolio, Buildium, Propertyware, & Rent Manager experts to answer any and all software related questions in less than an hour. No long-term contracts and easy to get started.

lEARN MORE
On-Demand Consulting

Trust Bookkeeping Services

Bookkeeping services provided by expert accountants for AppFolio, Buildium, Propertyware, & Rent Manager. For less than the cost of a full-time bookkeeper you can have a whole team of experts.

lEARN MORE
On-Demand Consulting

Corporate Bookkeeping

Let us take care of your corporate payables, receivables, reporting, and payroll with Quickbooks and Gusto. With us you can focus less on accounting and more on growth!

lEARN MORE
On-Demand Consulting

Daily Bank Reconciliations

Get your bank reconciliations done every single day! Keep your books accurate by making sure that everything is  accounted for. Available for AppFolio, Buildium, Propertyware, & Rent Manager.

lEARN MORE
On-Demand Consulting

Daily Audits

Curious just how clean your books are? Find out with Triple Tied Out! It's our daily auditing service that checks your bank recs, liabilities, and property balances. For AppFolio, Buildium, & Propertyware.

lEARN MORE

Why Choose APM Help

Expertise

Our consultants are well-versed in the software solutions commonly used in property management. Whether you're using AppFolio, Buildium, Propertyware, or Rent Manager, we have the expertise to clean up your books and maintain their accuracy.

Scalable Solutions

As your business grows, so do your accounting needs. Our U.S.-based account managers with industry experience are dedicated to managing your books, giving you the time and confidence to focus on expansion.

Audit Support

Going through an audit can be a daunting task. We offer daily audits and audit preparation services to ensure your books are always audit-ready, providing you with peace of mind.

Back-Office Services

Beyond bookkeeping, we offer a range of back-office services to streamline your operations, including maintenance coordination, property improvement loans, and corporate bookkeeping.
Your Success, Our Priority
APM Help is not just a service provider; we are your partners in success. We understand thatproperty management demands a holistic approach, which is why we offer a suite of services tailoredto address the diverse needs of your business. Our goal is to empower property managers to excel intheir markets by providing them with clean books, efficient processes, and the time they need tofocus on building strong client relationships and achieving their growth ambitions.

Ready to work with the experts in rental property management?

We typically respond in under 10 minutes!

Get Started Today
Property Management Accounting Expert