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

Create Free Account →

⚡ Takes 30 seconds

Already a member? Log in

KimberlyJ3 (Ohio)
Posts: 12
Posted:
Hello,

I am a newly elected treasurer of a 36 unit condo association. In the past all the accounting was done manually with excel spreadsheets. Can anyone recommend a good accouting software for posting payments, sending invoices, keeping track of everything. Thanks in advance!
SheliaH (Indiana)
Posts: 6,964
Posted:
We're not allowed to name specific companies or communities on this website (see posting rules). You could set up a separate email where posters can tell you who they use. Otherwise, Google is your friend- pick a few companies, get more information along with references and check them.

You don't say how much experience you have with Excel, but there are accounting software programs that are compatible with them that could give you the automation you're looking for.

If it is not right do not do it; if it is not true do not say it. Marcus Aurelius
DouglasK1 (Florida)
Posts: 2,046
Posted:
Quote:
Posted By KimberlyJ3 on 01/03/2025 1:57 PM
Hello,

I am a newly elected treasurer of a 36 unit condo association. In the past all the accounting was done manually with excel spreadsheets. Can anyone recommend a good accouting software for posting payments, sending invoices, keeping track of everything. Thanks in advance!

Honestly, you might just want to stay with the status quo.

For the first 20 years or so, the treasurers for our self managed association did our accounting with spreadsheets. At that point a new treasurer wanted to modernize and got the board to agree to purchasing accounting software. She bought a copy of probably the most popular small business accounting software (can't name here, but synonymous with "fast tomes"). She had an accountant friend help her get it set up, and it worked well for the task. She spent two years as treasurer, and then I took over that role (for four years). My background is in computers and I have worked with/supported/administered/programmed accounting software in the past, so I had no trouble taking over and even made some improvements to her procedures, especially regarding invoicing. We didn't actually send invoices, but generated them internally so we could track payments and quickly report on delinquencies. In general, reporting was the big benefit over the spreadsheet method. Reports like budget vs. actual, balance sheets, P/L statements, etc. were easy to generate so with accounting software, we actually had comprehensive year end reporting, where past treasurers using spreadsheets for the most part didn't do much reporting at all.

Unfortunately, after I stepped down, there were no board members with experience in accounting or using accounting software. Because of this the next treasurer reverted to using spreadsheets because no matter how well procedures were documented, they couldn't handle using the software. This was in an HOA of 65 standalone homes with an annual budget of around $35k.

Escaped former treasurer and director of a self managed association.
DeanJ
Posts: 1,786
Posted:
Quote:
Posted By KimberlyJ3 on 01/03/2025 1:57 PM
Hello,

I am a newly elected treasurer of a 36 unit condo association. In the past all the accounting was done manually with excel spreadsheets. Can anyone recommend a good accouting software for posting payments, sending invoices, keeping track of everything. Thanks in advance!

Any small business software will meet your needs.
TimB4 (Tennessee)
Posts: 21,059
Posted:
I've been treasurer for a 130 unit association with monthly payments and assist the treasurer in my current association of 83 lots with one annual payment.

We use spreadsheets. Prior to that, they used pen and paper.

Some people are more computer literate than others and even going to spreadsheets can be challenging to them.
You need to keep it simple and easy enough for those who will serve after you.
JackS20 (North Carolina)
Posts: 271
Posted:
offer a discount for paying entire year's dues up front, that will reduce your workload the most. 36 units I use a software that starts with HOA and the 2nd word rhymes with passenger, but instead of a P it sounds more like the noise a cow makes.
TimB4 (Tennessee)
Posts: 21,059
Posted:
Quote:
Posted By JackS20 on 01/10/2025 4:20 PM
offer a discount for paying entire year's dues up front, that will reduce your workload the most.

Makes budgeting more difficult. Requested Assessments would have to be higher to offset the discount (which could be seen as an expense in the budget model).

I see this like stores marking their product up by 20% then offering a 20% off sale.
DavidF17 (Florida)
Posts: 11
Posted:
Quote:
Posted By JackS20 on 01/10/2025 4:20 PM
offer a discount for paying entire year's dues up front, that will reduce your workload the most.

This is illegal in some states. Check the legality if you consider this idea.
JohnC46 (South Carolina)
Posts: 14,265
Posted:
Quote:
Posted By DavidF17 on 01/13/2025 3:46 PM
Posted By JackS20 on 01/10/2025 4:20 PM
offer a discount for paying entire year's dues up front, that will reduce your workload the most.


This is illegal in some states. Check the legality if you consider this idea.

David

Show me where it it illegal and more then one state.
JackS20 (North Carolina)
Posts: 271
Posted:
Quote:
Posted By TimB4 on 01/11/2025 4:44 AM
Posted By JackS20 on 01/10/2025 4:20 PM
offer a discount for paying entire year's dues up front, that will reduce your workload the most.


Makes budgeting more difficult. Requested Assessments would have to be higher to offset the discount (which could be seen as an expense in the budget model).

I see this like stores marking their product up by 20% then offering a 20% off sale.

well you wrote above your HOA has one annual payment so they are doing it wrong? are you gonna advise him/her to switch to monthly instead to make budgeting easier?
for small HOA's with few amenities and few expenses it actually saves money because you dont' have to hire an accountant to balance the booksk every month, you just doit once a year and that is where the extra money to pay for the discount comes from.
TimB4 (Tennessee)
Posts: 21,059
Posted:
Jack,

I was talking about the discount (not the payment).

Not knowing how many might pay in full to obtain the discount, the board should budget as if everyone will pay in full.
The discounts would be considered an expense of the Association and the budget would have to be adjusted, or assessments raised, to cover that expense.

Additionally, the proper way to do this would be for everyone to pay the full amount (because most governing documents specify expenses are shared equally - or based on a percentage of ownership) and for the board to write checks to those who paid in full.
JackS20 (North Carolina)
Posts: 271
Posted:
that makes more sense. but anyone that does a discount will quickly figgure out that it is very consistent from year to year. After the first time budgeting is easy

🎯 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