Financial Diagnostics in AppFolio
Financial Diagnostics in AppFolio
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.
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?
- 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.
- 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).
- Check the Diagnostics page once you complete 1 or more move-outs to ensure there are no outlying issues.
- 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.
- 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.
Financial Diagnostics in AppFolio
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.
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?
- 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.
- 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).
- Check the Diagnostics page once you complete 1 or more move-outs to ensure there are no outlying issues.
- 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.
- 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.
Fill out the form below to get in touch with our team.
Services Tailored for the best Property Managers.
Whether it's rental property management, bookkeeping support, training, bank reconciliations, or emergencies - we're here to help.
Financial & Books Cleanup
Get your books and financials cleaned up to be 100% audit proof.
Trust Bookkeeping
We keep your trust books clean, tidy, and up to date.
Corporate Bookkeeping
Don't worry, we also keep your corporate books clean as well!
And so much more...
We provide a large array of services to help power the best PMs out there.
