💬 Join us to post & get advice from 50,000 HOA & Condo leaders.

Create Free Account →

⚡ Takes 30 seconds

Already a member? Log in

AllisonD (Florida)
Posts: 449
Posted:
For those who use Quickbooks, do you create separate invoices for each homeowner, memorize them and make them recur quarterly, or do you create batch invoices once per quarter? Also, depending on the method, how do you put in a $25 late fee and 4% interest? Does the late fee get put in as a separate invoice or can it be done with the interest in the terms? I found tutorials on YouTube for both methods but I do not know which method works best. I did not find anything on how to add both a late fee and interest in terms. Thanks in advance for your help!
BillH10 (Texas)
Posts: 1,217
Posted:
Allison, which version of QB are you using? It makes a difference in terms of the response.
DouglasK1 (Florida)
Posts: 2,046
Posted:
We charge quarterly but encourage annual or bi-annual payments if owners can manage it. We end up with about 40% paying quarterly, 20% bi-annually, and 40% annually. Our prior treasurer created the invoices using the batch function, with 3 invoicing groups defined (quarterly, bi, and annually). I thought this was hard to manage, as some owners might pay the first half of the year, and quarterly after, etc. It was a fairly manual process to make sure every lot fell into one of the three categories so we didn't miss payments from any owners.

I took a different tack this year that seems to be working well.
1) create a batch group of all lots.
2) At the beginning of the year, create 4 sets of batch invoices, dated 1/1, 4/1, 7/1, and 10/1. If owners pay annually, when I receive the payment, I just apply it against all 4 quarterly invoices. If they pay less than annually, apply accordingly. For AR reports, I set the report date range so it doesn't show the future invoices.

I do late fees manually since we usually only have one or two. On the 15th, I see who hasn't paid (if any), and create late fee invoices. At the end of each month, I use the built in "assess finance charge" function to assess finance charges on any outstanding balances, this creates separate finance charge invoices. These don't have to be in "real time", I often don't do any of this for a couple of months and then I'll do two or three months worth at a time, just make sure to set the dates correctly on the late fee and finance charge invoices.

Hope this helps and isn't too confusing.

Escaped former treasurer and director of a self managed association.
AllisonD (Florida)
Posts: 449
Posted:
Quote:
Posted By BillH10 on 08/11/2015 7:57 PM
Allison, which version of QB are you using? It makes a difference in terms of the response.

I am using Pro 2012, I used it for our family business a few years ago and its still on my computer. If I can figure out how to make this work, I will upgrade to the latest version of Pro.
AllisonD (Florida)
Posts: 449
Posted:
Quote:
Posted By DouglasK1 on 08/11/2015 8:17 PM
We charge quarterly but encourage annual or bi-annual payments if owners can manage it. We end up with about 40% paying quarterly, 20% bi-annually, and 40% annually. Our prior treasurer created the invoices using the batch function, with 3 invoicing groups defined (quarterly, bi, and annually). I thought this was hard to manage, as some owners might pay the first half of the year, and quarterly after, etc. It was a fairly manual process to make sure every lot fell into one of the three categories so we didn't miss payments from any owners.

I took a different tack this year that seems to be working well.
1) create a batch group of all lots.
2) At the beginning of the year, create 4 sets of batch invoices, dated 1/1, 4/1, 7/1, and 10/1. If owners pay annually, when I receive the payment, I just apply it against all 4 quarterly invoices. If they pay less than annually, apply accordingly. For AR reports, I set the report date range so it doesn't show the future invoices.

I do late fees manually since we usually only have one or two. On the 15th, I see who hasn't paid (if any), and create late fee invoices. At the end of each month, I use the built in "assess finance charge" function to assess finance charges on any outstanding balances, this creates separate finance charge invoices. These don't have to be in "real time", I often don't do any of this for a couple of months and then I'll do two or three months worth at a time, just make sure to set the dates correctly on the late fee and finance charge invoices.

Hope this helps and isn't too confusing.

Not confusing, great answer. This approach makes sense. Thank you!!

🎯 You've read this entire discussion

Join the conversation with 50,000 HOA & Condo Leaders:

  • ✓ Ask follow-up questions
  • ✓ Share your experience
  • ✓ Get expert advice
  • ✓ Access 350,000 discussions
Create Free Account →

⚡ Takes 30 seconds

Already a member? Log in here