Duplicate contribution import

Contributions, Faith Promises

Moderators: Moderators, Tech Support

Post Reply
willsell
Posts: 36
Joined: Sat Oct 30, 2010 2:48 pm

Duplicate contribution import

Post by willsell »

We import our contributions once a month via a csv file. Has been working like a charm for 4 years. Then our new assistant treasurer created a nightmare by doing the import several times.
Is there a way to do a mass reversal or should we bite the bullet and Reverse each record for the month and re-import the month?

Zorak
Tech Support
Tech Support
Posts: 3006
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Duplicate contribution import

Post by Zorak »

You can use the Delete Old Data utility found under Contributions > Setup to delete the whole month and then re-enter the month and re-import the CSV file.

It is a good idea to make a backup from under Utilities > Backup & Restore before doing this, in case there is a typo in the date range entered or something like that, deleting more history than you wanted.

Also, if you Post Contributions using the Update Fund Accounting method, this Delete Old Data won't fix the Fund Accounting side of the software. Those transactions would have to be manually reversed on the View Posted Transactions screen in Fund Accounting.

NeilZ
Posts: 10209
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Duplicate contribution import

Post by NeilZ »

willsell wrote:We import our contributions once a month via a csv file. Has been working like a charm for 4 years. Then our new assistant treasurer created a nightmare by doing the import several times.
Is there a way to do a mass reversal or should we bite the bullet and Reverse each record for the month and re-import the month?
Ouch ... unless you had a backup of Contributions (which is always a good idea before you do something like an import) you may have to use the Contributions -> Setup -> DELETE OLD DATA function. The function has a range where you can setup the period you want to delete. NOTE: this only works with POSTED contributions. If these contributions have not yet been posted, I would post them to Contributions Only not to Funds Accounting.

Image

This will clear out these contributions for that time frame.

Again do a backup of Contributions first before proceeding. Then in future, do a backup of Contributions before importing this way you can revert easily.
Neil Zampella

Using PC+ since 1999.

Post Reply