Does anyone know what the standard (and not too expensive) accounting software is for management companies? And, how do you review your invoices, payments, reports? What kind of access to the system do you have? I.e. it seems like there should be a system where an offsite user/treasurer could see the accounts, current balances, run reports, click for details, etc online--rather than receiving paper or pdf reports. Does anyone know if a system like that is available or widely used? Thanks.
is on the wrong trail, I suspect.
Ann, are you thinking of self-managing?
Are you trying to pick the brains of managing agents for the right software to let you do that?
; )
We seem to have a problem with how items are coded by our agent. They 'move around' within the accounts month to month or large unusual items are put in a regular, usually steady, account. This lack of consistency makes it difficult to see how much we are spending on a regular basis and how much for emergencies and other 'one offs'. I was thinking that it might be common practice to have online access to view reports (as is standard in business) and be able to click on an account to see what expenses have been put in it--rather than having to ask about each oddity every time.
Alternatively, I was thinking we need to approve account codes for invoices before they are booked. The purpose is not to micromanage, but to get a decent grip on our finances: what's 'regular' expense and what's unusual--so that we can plan and budget.
I'm trying to find out what other people are doing if they are having these kinds of problems, and what the best solution would be.
Anne:
Many treasurers and Boards unfortunately do not take the time to thoroughly review and classify, etc. They just go by what management says, read and take the reports as provided, and pop a question here and there when something looks odd. What your asking for is good and in many buildings is needed. You do have the right and ability to customize the reports to fit your needs and requirements.
Who’s GL coding system is management going by? Yours or theirs? Perhaps sitting with the accounting department and PM for an hour will solve it. Make a list of your current coding and desired coding. Have management implement the new codes or sub-codes and have the agent when signing off label it - such as capital/hallway project/engineering or repair/reimbursable/apt7B - etc...
It makes it very easy for you to glean over the list and trace or see exactly what expenses come from where and are allocated to where. The only follow up on your part may be asking if 7B ever reimbursed us for that sink trap repair.
Then, in your monthly reports, have management separate anything that is capital from the operating expenses and emergency repairs from maintenance repairs and itemize what needs to be for the purposes of your next budget.
This is a pain in the a$$ for management, but much better and easier to read and forecast from. We do it for 2 of our buildings and they like it very much.
But providing access to the system would be a definite no-no for us or any other management company (We only provide it to the PM's, the accountant firm and L&T attorneys)
Did I adaquately address/answer your concern?
~AR
Thanks. That's helpful.
They are using their own GL accounts which do not match well to the accountant's GL accounts and which do not segregate capital from regular expenses. And, they have a tendency to open up new accounts for very small amounts, like $15, while putting large, $11,000, 'one off' expenses in regular accounts--so all is rather confusing.
I had already requested on the next round of reports that they 'code' the invoice copies so I can see where the expenses went, and was thinking I just need to go down there and talk it through so we can agree on some basic principles of where things go and what amounts (large ones!) justify a new account or separation from regular accounts.
What's the 'pain' for management? The coding of invoices or the segregation of capital expenses? I'm not trying to be unreasonable, just trying to get a handle on what's happening and where the money's going so we can budget and plan.
Great..
You should definitely spend some time at the management office, relay exactly what you wish to happen and why. They will be able to do it (but may gripe a little). If a new type of expenditure comes up (which should not because you would have worked all that out with them), then they should call you to say "what do you want me to do with the $2,000 Goldfingers bill.."
The software ledger will need to be modified by management and the new system implemented. this may take a month or two to get the kinks out, but it should work out in the long term.
I may have exaggerated in that it is a pain, it is more of an inconvenience, but they will get over it...
~AR
The problem with codes is the codes are not or rarely put on the actual purchase order. So when the invoice comes in accounting takes a guess where it goes. The super/managing agent need to apply the codes upon ordering material or repairs. Problem solved. Of course you have to make sure the codes are applied to the right line item on the budget.
Its also a good idea that every 4 months or so someone sits with the super and showers him/her exactly where the building is on budget. Most of the times, supers - Resident managers do not know, no one tells them or teaches them.
This will help stay on budget.
Pgrech
That is real good.... I never thought of informing the super as to where we are in the budget. I think that is a great idea for various reasons. (gonna steal that idea and implement it!)thanks
The use of PO numbers (which include the GL code acronym)can help to pre-clasify items.
~AR
Naaa, your not stealing it. Your very welcome to it.
Be well
Pgrech
Whether you go by the management office system or the horoscope system, your treasurer and your board should have a copy of the charts of accounts. The treasurer may define each chart of accounts for types of invoice entries he/she wishes to see. (Note: try not to use miscellaneous categories - you end with the kitchen sink if you have such a line item!).
There is nothing that prevents a board member, specially a treasurer to ask for re-classificaiton of an invoice for budget tracking purposes. On a six month basis, i.e., in July, you should ask for expenses year-to-date broken by GL's, and ask for reclassification of those invoices that are out of line with the GL's. It happens often, but not really something to lose sleep over it.
In our case, we ask management to pay anything that the coop is committed to pay under contract or recurrent, i.e., mortgage, taxes, con-ed, water, elevator service, telephones, salaries, etc. However, any other repairs, i.e., plumbing, supplies, electrical, engineering, legal, other professionals, the treasurer goes over them.
My recommendation to any treasurer is to sit with the super and clear the invoices initiated by him/her to ensure that the services were received and that the work was up to standards. Similarly, check supplies carefully with the super as there may be backorders, credits and returns that all should match. Good organizations ask that shipping slips are matched with the invoices. The super should check the received items on the shipping slip, then attached to the invoice for payment.
As PGretch and AR state, the super should be briefed (depending on his status within the co-op) about the financial position of the co-op at any given point in time. Making him aware of the present financial circumstances makes the super a team player. A super who deals with a large department of poters and other service men to supervise and whose skills are more demanding by way of supervision and budget, may be told more detail about the operational items that he/she oversees, i.e., utilities, repairs and salaries, i.e., OT, vacations, etc. than a superintendent of a small builidng where he/she may be a solo performer.
AdC
Introduce yourself to other members of Board Talk! Log in below or register here.
Board Talk members who registered prior to March 9th, 2016 will need to reset their password.
OK, unless I misinterpreted the question Ann, here is my view;'
If you are the treasurer and you have the need to do this, I think the better or more logical question is, why?
First, to answer your question, yes, there are many programs that permit access. (MRI, Yardi, even the old BJ Murray does)this is possible, though maybe not permissible.
Second, your management should be paying all bills on a timely basis, approving any that may need your approval (I PDF them and use email), and providing you a full accounting report at the months end with copies of all the bank statements and bills paid.
If a treasurer has access to my system, I would have to charge a lot more to manage that building. It is the equivalent of hiring a contractor to do a job, them getting underneath him with a level and plumb line. Let him work, he's there so you don't have to be. All you need do is oversee and ensure the proper job is being done. in your case, it is via the monthly financial statement you receive.
~AR
Thank you for rating!
You have already rated this page, you can only rate it once!
Your rating has been changed, thanks for rating!
Board Talk members who registered prior to March 9th, 2016 will need to reset their password.