Missing Contributions

[TimD]

When looking at the contributions reports for contributions entered from 1/1/2010 t0 3/31/2010 only the March contributions are showing. I have entered and posted all the contributions given since the first of the year and this is the first time to send out statements. When I emailed the statements only March contributions were listed. I have doubled checked the dates several times and I have asked for 01/01/2010 - 03/31/2010 so I don't know why only March contributions are showing. Everything has been entered and posted. Can anyone help me to figure this out?

[NeilZ]

When looking at the contributions reports for contributions entered from 1/1/2010 t0 3/31/2010 only the March contributions are showing. I have entered and posted all the contributions given since the first of the year and this is the first time to send out statements. When I emailed the statements only March contributions were listed. I have doubled checked the dates several times and I have asked for 01/01/2010 - 03/31/2010 so I don't know why only March contributions are showing. Everything has been entered and posted. Can anyone help me to figure this out?

Which version of Powerchurch are you running ?? The following advice should be good for v10 & 11:

I'm assuming that you're running the All Contribution Statements report.

There are a few dates you should be checking:
1. The Include totals for dates: area
2 The print details for dates: area. In this case you want to have the box checked for Print details for the same dates as totals


Did you run an 'Unposted Contributions' report to check that all have been posted?? Did you run a 'Posted Contributions' report to make sure they're in the system?? Did anyone happen to do a database restore prior to March contributions being entered ?? Were the previous month's contributions entered as a 'batch' or normally each week after receiving the contributions ??

[TimD]

I'm running 10.4 version

Yes I did an "unposted contribution" report. There was none unposted.

On the "View Posted Contributions" report only March is showing.

No one has done a database restore prior to March. I enter the contributions each week and post them each week. Unfortunately, I don't think I had even looked at any of the reports since the first of 2010 to see if they were there before today when I tried to email all the quarterly statements.

[NeilZ]

I'm running 10.4 version

Yes I did an "unposted contribution" report. There was none unposted.

On the "View Posted Contributions" report only March is showing.

No one has done a database restore prior to March. I enter the contributions each week and post them each week. Unfortunately, I don't think I had even looked at any of the reports since the first of 2010 to see if they were there before today when I tried to email all the quarterly statements.

OK ...

The fact that you only show posted contributions for March, and that there are NO unposted contributions tells me that two things may have happened.

1. The contributions you entered for January & February may have been entered under a different year date (IE: Jan 2009 not 2010) .. improbable, as you would have noticed this.
2. Someone restored the program database prior to your entering data in March with a version that was done prior to January 1st .. probable !!

If you have access to the System Audit Log under Utilities, I'd take a look to see if any restores were done. If so, you can check to see the type of restore by highlighting that entry. The details will show up in a block at the bottom of the screen dialog. I suspect that it will say: Backup Type All FIles W/Pictures.

OH .. I just thought of something. If there's another version or stand alone installation of Powerchurch somewhere, you may have entered those contributions on that system, therefore no data would appear in the shared database, or vice versa. You're on a standalone system, and the data was entered on a shared database.

[TimD]

I'm running 10.4 version

Yes I did an "unposted contribution" report. There was none unposted.

On the "View Posted Contributions" report only March is showing.

No one has done a database restore prior to March. I enter the contributions each week and post them each week. Unfortunately, I don't think I had even looked at any of the reports since the first of 2010 to see if they were there before today when I tried to email all the quarterly statements.

OK ...

The fact that you only show posted contributions for March, and that there are NO unposted contributions tells me that two things may have happened.

1. The contributions you entered for January & February may have been entered under a different year date (IE: Jan 2009 not 2010) .. improbable, as you would have noticed this.
2. Someone restored the program database prior to your entering data in March with a version that was done prior to January 1st .. probable !!

If you have access to the System Audit Log under Utilities, I'd take a look to see if any restores were done. If so, you can check to see the type of restore by highlighting that entry. The details will show up in a block at the bottom of the screen dialog. I suspect that it will say: Backup Type All FIles W/Pictures.

OH .. I just thought of something. If there's another version or stand alone installation of Powerchurch somewhere, you may have entered those contributions on that system, therefore no data would appear in the shared database, or vice versa. You're on a standalone system, and the data was entered on a shared database.

I'm pretty sure there is no way that I posted to 2009, your right about that.
I looked in my System Audit Log and there has been nothing done as far as a restore. Actually, there has been nothing done in the audit log sine 4/22/2009. I'm not sure what all shows on this audit log since I am not familiar with it.
I am the only person running the program and it is on my computer so that could not be a cause.
I tried running a statement for 01/01/2009 through 4/5/2010 and it still only shows the March contributions. This seems really strange. Any other thoughts???

[JohnDMeyers]

We had something a little different happen to us this year.

Our main contribution fund is 10000 and it is supposed to do this:
DB 01-1110-000 checking
CR 01-4010-000 general tithes

Somehow (I think I was the culprit), it got changed to this:
DB 02-1110-000 missions tithes
CR 02-4756-000 Dominican Republic

So, all of our tithes and offerings were posted to a trip to the Dominican Republic in the MISSIONS FUND. I might add "ughhhh". I caught the error in mid-March. We had an usually large balance in our MISSIONS FUND.

Since the title on Contirbution Fund was still labeled "General Tithes", I didn't have to re-enter all the contributions. (all the contribution statements "looked" correct). I only had to correct it in Fund Accounting.

Check where you contribution fund is pointing (or if you made a correction to it in March, check out other funds or whatever is applicable to your circumstance).

In my case, the Contribution Reports didn't show the problem, the fund accounting reports did. You might want to check the account activity in your General tithes income account and see if that gives you any clues.

[NeilZ]

I'm pretty sure there is no way that I posted to 2009, your right about that.
I looked in my System Audit Log and there has been nothing done as far as a restore. Actually, there has been nothing done in the audit log sine 4/22/2009. I'm not sure what all shows on this audit log since I am not familiar with it.
I am the only person running the program and it is on my computer so that could not be a cause.
I tried running a statement for 01/01/2009 through 4/5/2010 and it still only shows the March contributions. This seems really strange. Any other thoughts???

OK ... so I'm assuming here that you're only tracking contributions and membership on this system, not using any other functions of the program ??

The only other thing I can think of within the program is that somehow someone selected "Delete Old Data" and it wiped out your database.

I'm assuming that it should have data going back a few years, since you're required by the IRS to maintain data for 3 years or more.

Finally, has ANYONE done anything to this computer?? Where is it located, in the church ?? Has it been moved, or anything ???

[Tracy]

Have a look at the Contribution Audit Log. It should show that you have posted in the months you are searching for. It does not show what date the contributions were though. If this does show you have posted in those months, one of two things have happened. You deleted old data, which will show in the Contribution Audit Log and the date range you deleted. Or, the contributions have gone to the wrong year. Goto a known contributor which you've recorded a giving for in the date range using the "View Posted Contributions". You might find some contributions to the year 201 at the bottom of the list. If you do not see any contributions that appear to be out of place the Technical Support staff can assist looking at the data entry order of the data to give you more possible reasons.

Just a side note, Version 11 has introduced a warnings to help guide the lost keystroke victims to an earlier recovery. Both in data entry and posting.