Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I am setting up a new home owners community as of Feb 28th. I will continue March with my own entries.
They have provided me with a basic excel with the Feb. 28th checking account balance, a couple of Reserve fund savings bank accounts, and various paid expenses from January and February. No retained earnings or equity etc. or outstanding AR or AP.
I believe this should be simple but I can't remember how this opening JE is supposed to balance out when I enter these beginning balances. There will also need to be a reserve equity account somewhere in there.
Thanks!
Solved! Go to Solution.
Agreed. It would be nice to backtrack to Jan. 1 but that may be a lot of work. If you want to start as of Feb. 28, here is my thought on the J/E: Let me know if you think I'm missing anything.
Debit | Credit | |
Checking | XXX | |
Savings1 | XXX | |
Savings2 | XXX | |
Prepaid Owners Dues | XXX | |
Reserve Equity | XXX | |
YTD Operating Income (Debit if loss) - to balance | XXX |
I have some experience as a treasurer for a couple of HOAs but am by no means an expert. A few questions:
Since there's no A/R or A/P and no retained earnings, I think if you have that information, you can set up the opening balances.
Thank you for your reply. Here are my answers. I was thinking it would be nice to add in the Jan & Feb. expenses so they can see the budget with those included as well as the first two months assessment income.
Did the HOA give you a balance for the reserve equity account (replacement reserve balance)? Is it the same balance as the reserve fund savings accounts? I think it is just what is in the savings accounts.
Is the checking account balance just operating assets or is it a combination of operating assets and amounts to contribute to the replacement reserves? All deposits go into it and then monthly transfers are made to the reserves. The current balance is after the Feb. transfer.
How about YTD income/(loss)? They supplied income and expense totals for the year.
Any prepaids or accruals? Yes there are a few owner prepaids.
I think what is getting in the way is me is trying to include all of the January and February expenses and assessment income so they have it in the new system. If I just start with Feb 28th it balances out with the checking account balance equalling the retained earning as of March 1st. It would be nice to have it all in there though.
Agreed. It would be nice to backtrack to Jan. 1 but that may be a lot of work. If you want to start as of Feb. 28, here is my thought on the J/E: Let me know if you think I'm missing anything.
Debit | Credit | |
Checking | XXX | |
Savings1 | XXX | |
Savings2 | XXX | |
Prepaid Owners Dues | XXX | |
Reserve Equity | XXX | |
YTD Operating Income (Debit if loss) - to balance | XXX |
This is perfect and will work with what I have, thank you! It seemed like it should be pretty straight forward. Now I can feel confident I am not missing anything (or adding anything in error). I appreciate your help.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here