Page 1 of 1

Wrong Year/Month posting - Version 10

Posted: Mon Nov 29, 2010 7:35 pm
by trees
In reviewing the files, I realized that Jan 2010 transactions including contributions was posted to December 2009. This has caused 2009 to be overstated and 2010 is now understated. Of course, January month has been closed. How do we fix this problem? Help!!

Re: Wrong Year/Month posting - Version 10

Posted: Mon Nov 29, 2010 10:01 pm
by JohnDMeyers
If you really want 2009 to read correctly, it will take two things:

1) a good backup of 2009 near the end of the year
2) a lot of time - you will have to re-enter everything that happened since the backup.

The second best way (that I can think of) is to make a correction entry dated 1/1/10 to get 2010 starting balance correct. 2009 will "always" be incorrect, and you will have to so note it on your annual report.

Maybe there are other ideas out there.

Re: Wrong Year/Month posting - Version 10

Posted: Tue Nov 30, 2010 8:59 am
by trees
John,
Would we need to re-enter all contributions as well? That will be certainly a lot of work.

Re: Wrong Year/Month posting - Version 10

Posted: Tue Nov 30, 2010 10:07 am
by NeilZ
trees wrote:John,
Would we need to re-enter all contributions as well? That will be certainly a lot of work.
I'm not John, but no, you won't have to do Contributions since there is no direct link between the two. The transactions created when posting to Contributions are the only interface.

As long as the Contributions were entered under the correct date in 2010, they're fine.

Re: Wrong Year/Month posting - Version 10

Posted: Tue Nov 30, 2010 3:21 pm
by JohnDMeyers
What Neilz says is accurate. Make sure that when you restore from your 2009, you choose "accounting" as opposed to "all data files" or you will overwrite your contributions.

You will have to make a correction entry in fund accounting to "catch up" the contributions that are not overwritten during the restore.

Neil, please make sure I am getting this right.

Re: Wrong Year/Month posting - Version 10

Posted: Tue Nov 30, 2010 3:28 pm
by NeilZ
JohnDMeyers wrote:What Neilz says is accurate. Make sure that when you restore from your 2009, you choose "accounting" as opposed to "all data files" or you will overwrite your contributions.

You will have to make a correction entry in fund accounting to "catch up" the contributions that are not overwritten during the restore.

Neil, please make sure I am getting this right.
John,

you are correct, however its not only the Contributions data she'd be overwriting, but everything including Membership, Attendance, Activities, etc.

Re: Wrong Year/Month posting - Version 10

Posted: Tue Nov 30, 2010 3:58 pm
by JohnDMeyers
Thanks, Neil.

Then the correction entry would be as follows for contributions:

If the backup did not include all of 2009, make a correction entry for 2009:
DB checking $amount of contributions (total)
--CR general income $general contributions (partial)
--CR other income accounts $according to the contribution funds (partial)

So that all the CR to the various income accounts equals the DB to the checking account.

Post in Fund Accounting
-------------------

When you have all the 2009 entries correct, close December 2009.

Close December 2009

----------------

Then proceed to make the same correction for contributions in 2010:

DB checking $amount of contributions (total)
--CR general income $general contributions (partial)
--CR other income accounts $according to the contribution funds (partial)

So that all the CR to the various income accounts equals the DB to the checking account.

Re: Wrong Year/Month posting - Version 10

Posted: Tue Nov 30, 2010 7:11 pm
by trees
Thank you both for your assistance. Let's hope I don't make any additional errors.