Retained Earnings - a Big Mess :(

Being new to bookkeeping (self-taught) and Sage last year, I've stumbled my way through 2014 and made some mistakes.  I would appreciate it very much if someone could give me some advice and insight as to how to fix a mess I've made.

2014 was the first year our church used Sage.  We had, at the time, four bank accounts.  The opening balances for all four totaled $19,628.11.  It was my understanding that as these were the balances as of December 31, 2013, they were the "retained earnings-previous year."

While still in historical mode, I followed the practice of the two church treasurers before me and used the amount our building is insured for as the asset value of the building.  Same thing for our furnishings.  

After leaving historical mode, I found our MPAC report and used the value listed there as the asset value for our property.  All of this made our Retained Earnings shoot into the millions.

At one point I discovered that the starting balance on a loan amount was off by $3000.  This adjustment was made against the Retained Earnings because I didn't know what else to do and it seemed as good as anything.

Since all this was done, I've learned more about assets and spoke with an accountant who advised me I had it all wrong and to remove everything relating to the assets.  He didn't tell me what to do about the building account as it had been entered as an opening balance.  So, of course, I adjusted it against the Retained Earnings.

Now I'm in a pickle because I can see our Retained Earnings are now showing as a deficit instead of the $19,628.11 I expected.  I can't go back to the accountant, or any accountant for that matter, because at the time he was able to work me sporadically on a pro bono basis, but has since entered into a partnership and is no longer allowed to do that.  Our church is scraping by on a wing, a prayer and a lot of faith at the moment and can not afford to speak to him or any accountant.  

This is bothering me intensely because I like everything to be spit spot and of course, it will throw off the Retained Earnings (oh, he told me I should rename it to "Net Assets"-- is that correct?) for 2014.

Help!!  I've included a screen shot of the transactions that took place.  Please don't judge. :)

  • 0

    Any comments from anyone?  At this point I'm seriously considering re-entering the entire year because there is no way I want to submit a balance sheet to the bank (as per our loan agreement) that is so messed up or to our congregation at our annual meeting.

  • 0 in reply to Cheryl S.

    Canadian GAAP rules, for a variety of reasons, generally require use of historical cost for most assets.  

    This more or less works, except when assets have a very low 'dollar' value, and less well in countries that are no longer on a 'gold standard' (which is pretty well all countries).

    Whether you need to use GAAP or not, may depend on who you are reporting to.  

    In your case, current value accounting (taking into account inflation) may make more sense, i.e. basing the land and building value on an appraisal or other definite record.  

  • 0 in reply to RandyW

    Even if I don't actually need to use GAAP, I'm trying to learn how to do things the right way and the "best practices" way.  It's a lot to learn on your own!  The accountant did advise that if I want to track our building and land as assets, I should find documentation for the purchase price of the land and how much it cost to build the building.  I might find the first, but I'll be hard pressed to figure out the second.  It's only 12 years old, but there's a lot of mystery regarding some loans and mortgages and the people involved then are no longer part of our church.

  • 0 in reply to Cheryl S.

    One thing that I can pass on, is that there isn't necessarily 'the right way', there's the most appropriate way for the needs of the organization.  And 'best practices' for one organization are not necessarily transferable, even where there are a lot of similarities.  

    The land may have been a donation, or donation in kind, possibly the construction was done using a mixture of purchased and volunteer materials and labour.   If it wasn't documented at the time, and there is not even a shoebox full of invoices and donation receipts that you can access, accurately determining cost forensically would be close to impossible.  

    With access the to the title, any building permit(s), insurance documents, perhaps any mortgage contracts, there would be some clues as to what that value would have been (i.e. insurance is on the building, but not on the land, but the mortgage could be on the whole works)

    But...You can't build a solid foundation of stone on top of a sea of mud.

    So... if there is no external need (CRA, bank, insurance) for the actual, historical cost to be documented in the books, then there may be no need to do it at all.  There would have to be a disclaimer on any financial report or statement that it has not been prepared according to Generally Accepted Accounting Principles.  

    Another thing to take into consideration is that most GAAP guidance is based on the 'Going concern' principle, which assumes that the organization is going to continue operating.  If it's becoming no longer viable, then current value accounting may be more appropriate.  

    The current market value of the church property may be land value minus demolition cost, and that may be an appropriate value to use on the statements.  

    This forum is primarily for peer support regarding the Sage 50 software, and anything I've stated in here is not to be considered to be an Accountant's opinion.