Trust Account Balance Reports in AppFolio

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

Trust Account Balance reports protect you from commingling

Property balances are extremely important to track but are often overlooked or put on the back burner. This can lead to unhappy owners, trust account commingling, and over-drafting your bank account. Get ahead of the curve and check your owner balances regularly using the Trust Account Balance report in AppFolio. Continue reading to learn more about this important report and how to track your owner balances.

Filtering the Trust Account Balance report

The AppFolio Trust Account Balance (TAB) report is vital to keeping your books in check. You can use this report for a number of things, but today we will focus on Owner Balance Auditing. To customize the TAB report to review owner balances please set your customization settings as follows: 

  1. Select today’s date 
  2. Select “All Properties” from the drop-down menu
  3. Under "Grouping" select "Group Rows By Category" > "Owner"
  4. Go to "Columns" and add the following: Unused Prepayments, Unpaid Bills, Work Order Estimates (if you use that feature), and Reserve Amount
  5. Update

Once you have your report customized scroll through and check for any negative balances, both on the individual property level and the owner group as a whole. If your bank account is positive overall, but you have negative owner balances, you are commingling funds. But don't worry, we will walk you through correcting these!

With your customizations, you should be able to easily see if there are owners who have negative properties but enough funds in their portfolio to still be in the positive. In that case, the best practice is to use the "Transfer Owner Funds" function under "Payables" to even out the properties to clear up the negative balances. This is especially helpful to avoid overpaying an owner through their distribution since distributions are based on the property balance rather than the overall owner balance.

If you do not have any properties with negative balances, congrats! Keep up the great work. Make sure to recheck the Trust Account Balance report periodically to make sure you’re never commingling!

How to Handle Negative Balances

If you do have properties with negative balances, you’ll want to address those issues as soon as possible. There are several ways to resolve negative property balances. Depending on the situation you may need to: 

  1. Ask the owner for a contribution
  2. Transfer funds between owner properties (if the owner has other properties with excess funds not covering reserves, prepayments, or unpaid bills)
  3. The PM company can deposit funds into the trust account to cover the negative until the property receives income, then the funds can be reimbursed
  4. If you are unable to retrieve the funds from the owner (this often happens when a closed/hidden property that is no longer being managed is carrying a negative balance) then ultimately, the property management company is responsible for contributing the funds to bring the property back up to zero. Record this via Other Receipt under Accounting > Receivables towards the income GL of your choosing.

We recommend that you run the Trust Account Balance report at the month-end as a part of your routine. This will help you stay on top of owner funds before the property sells, or before the balances get too far into the negative.

If you would like further assistance from one of our AppFolio Experts, or if you have additional questions, please reach out to us at info@apmhelp.com or call 281-949-8755. You can also visit our website at apmhelp.com to learn more about our services.

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