Duplicate contribution import

Contributions, Faith Promises

Duplicate contribution import

Postby willsell » Fri Dec 28, 2018 6:16 am

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?
willsell
 
Posts: 28
Joined: Sat Oct 30, 2010 1:48 pm

Re: Duplicate contribution import

Postby Zorak » Fri Dec 28, 2018 9:27 am

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.
Zorak
Tech Support
Tech Support
 
Posts: 2471
Joined: Thu May 13, 2004 8:59 am
Location: PowerChurch Software

Re: Duplicate contribution import

Postby NeilZ » Fri Dec 28, 2018 9:27 am

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.
NeilZ
 
Posts: 8860
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA