Step-by-Step: AppFolio Security Deposit Funds Mismatch

When running your diagnostics, one of the biggest red flags is AppFolio Security Deposit Funds Mismatch. Here is a breakdown of how to troubleshoot and fix the problem.

Understanding the Issue

What it means: This error indicates a discrepancy between the amount of security deposits you should have on hand (according to AppFolio's records) and the actual balance in your designated bank account(s).

Why it's important: It's crucial to address this as it signals potential accounting errors, misallocated funds, or even missing money.

Troubleshooting Steps

1. Review the Report Details

Access the Financial Diagnostics report within AppFolio to pinpoint the exact properties or tenants associated with the mismatch.

Analyze transactions related to those specific security deposits, checking for: - Incorrect entries: Typos, duplicate entries, or entries posted to the wrong accounts - Missing entries: Deposits not recorded, refunds not accounted for, or transfers between accounts not properly tracked

2. Reconcile Bank Accounts

Compare your bank statements with AppFolio's records for the relevant period. Identify any deposits or withdrawals on your bank statement that aren't reflected in AppFolio, or vice-versa.

3. Investigate Potential Causes

• Tenant ledger errors: Review individual tenant ledgers to ensure security deposit transactions are accurately recorded
• Bank reconciliation errors: Check if bank reconciliations were performed correctly
• Data entry mistakes: Double-check all data entry related to security deposits for accuracy

4. Correcting the Issue

• Adjust entries in AppFolio: Make necessary corrections to transactions or tenant ledgers to align with your bank statements
• Contact your bank: If you find errors on your bank statement, contact your bank to investigate
• Seek assistance if needed: If unable to resolve the issue, reach out to AppFolio support or a qualified accountant

Important Considerations

• Backup your data before making any changes in AppFolio
• Document everything — keep a detailed record of all steps taken
• Prevent future issues — implement internal controls to minimize the risk of mismatches going forward

Pro Tips

• Regular reconciliation: Reconcile bank accounts with AppFolio's records monthly to catch discrepancies early
• Utilize AppFolio's resources: Take advantage of AppFolio's help center, webinars, and training resources

If the issue persists or becomes complex, don't hesitate to seek professional help from an accountant or AppFolio specialist — or reach out to our team directly.