Duplicate Fund Listings for Account

[wms7328]

In trying to find an error in trial balance for one of my funds, I checked the chart of accounts and found that I have an account number listed twice in same fund. In this case Account 4631-003 is listed for Fund 10 twice. When I go to Maintain Chart of Accounts, it shows as two separate listings each showing 10-4631-003. Made one listing for fund 10 inactive.

However, one transaction was recorded for this account in Fund 10 and on the reports it actually shows up listed twice which doubles the income amount that it should show. When I run trial balance for Fund 10, it shows up as two separate lines which makes the fund not balanced, even after setting one of the fund 10 listings to inactive.

Finally solved this by reversing the original transaction to this account. Then I created another account number and moved the original 4631-003 to this new account and it now only shows one listing for fund 10. Reentered the transaction using the new account number and now everything is correct.

Question is: How did this happen in first place? If you try and add the same fund to an account a second time, it doesn't give you that option. Don't want to have this happen again.

[Zorak]

This is actually an old problem in the program. This is something that we can help with in Technical Support. The quickest remedy will be to make an accounting files backup, then e-mail the backup as a file attachment to data@powerchurch.com.

Don't forget to include your RN in the e-mail, so we will know who it is coming from.

Also, include in the e-mail that you have "duplicate entries in faaccts" this will let us know exactly what the data is here for. While we have your data, don't make any changes in the Accounting module, they will be lost when you restore the repaired data that we return to you!

[wms7328]

Thanks for your very quick reply. I have come up with a fix that appears to work, at least it makes the reports correct.

I made all the funds in the account inactive, except one of the duplicate enteries. Then I created another account, transferred the duplicate fund listing to the new account number. That way I end up with the fund listed only once in each account. I then make the original account number inactive. This makes my reports correct, but guess the bad data is still there.

Since we have several people that enter data into Power Church, it will probably be Friday of this week before I can send you the data set. I have not entered this fix into our production data. We maintain a separate computer with PowerChurch loaded so I can try different things before I enter into actual church data.

Thanks again and I will send data on Friday.