How do I correct negative or positive additional fees in AppFolio?

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

How do I correct negative or positive additional fees in AppFolio?

AppFolio User Question:

How do I correct negative or positive additional fees in AppFolio?

APM Help Answer:

The first step is to diagnose the issue as either negative or positive additional fees.  

Troubleshooting and correcting a negative balance  

       1.       Go to Accounting > Diagnostics > Negative Balance on Additional Fee GL Accounts

       2.       Click the Balance on the property you are troubleshooting to pull up a General Ledger

       3.       Locate a non-zero balance to identify the incorrect payment

                a.       You may also select Customize > Check box to “Show reversed transactions” to find the overcollection

You must now create a new receipt equal to the overcharged funds.

       1.       Go to Accounting > Receivables > Other Receipt

       2.       Make the receipt out from the property management company to the overcharged property for the amount that has been over-collected

       3.       Check the box labeled “Exclude from pay management fees calculation.” If this box is left unchecked, the system will view the receipt as new income and reverse the transaction once again.

       4.       Note that the receipt is a correction of overcharged funds

       5.       Save the receipt and deposit it once the money has been transferred

Tip: Create receipts for all negative fees first and then make a single bank transfer for the total amount. This minimizes your total number of transactions and makes for a cleaner ledger!

 

Troubleshooting and correcting a positive balance

For the current month:

       1.       Go to Accounting > Diagnostics > Positive Balance on Additional Fee GL Accounts

        2.      Verify that the property is zeroed out for the last month

       3.       Ensure that all management fees are collected

                a.       Go to Accounting > Payables > Pay Management Fees

               b.       Select the property

               c.       Run as of End of Last Month

Tip: Collect management fees at least three times a month: Once in the beginning, once in the middle, and once more at the end once you are closing out the month.

 

If you are correcting positive additional fees from a prior month, you need to manually create a bill.

       1.       Payables > Enter Bill

       2.       Make the bill payable to the property management company for the amount owed

Correcting additional fees for a prior tax year

First, check if the General Ledger account is exempt from 1099.

       1.       Chart of Accounts > Double click “Options” column to reveal which accounts are excluded from 1099

If the account is exempt, treat the issue as if it were the current year as previously described.

If the account is not exempt, the taxes paid on the over/under-collection must be written off by creating a journal entry.

       1.        Accounting > Journal Entries > New Journal Entry

       2.       Date the entry for the year where the error occurred

       3.       Create a debit for under-collected funds and a credit for over-collected funds

       4.       Offset the GL account against another income account that is not exempt from 1099 or suppressed or subsidized, such as Miscellaneous or General Income

                a.       This ensures that your net operating income remains consistent

Unfortunately, even after these corrections, the current owner statement will likely still appear wrong since the occurred in a prior owner statement. There are a few ways to correct the current owner statement:

       1.      Run the owner statement all the way back to the previous period, creating a larger statement.  This is the recommended method, as it gives the owner an updated, accurate report of both periods.

       2.     Run the owner statement for the current period and unsuppress the GL account on the property

                a.       Go to the property page > Management Fees > Edit > Uncheck “Suppress”

                b.       After you run the statement for the current period, go back into the property and suppress it once again.   

 

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