We have Netsolutions and use IATS for Credit Card processing.  I generally download transactions from NetSolutions just once a week.  I recently saw how the IATS transactions are posted on our bank statement, (not much information), I also noticed that these transactions did not easily correspond with our RE batches.  Does anyone else have this problem or do you receive other information from IATS that helps you balance these transactions?  Any information will be helpful.

Thanks,

Margaret Wagstaff

We use NetCommunity, but the principles are still the same. For us IATS take 3% off the amount they give you as a transaction charge, which may be why the amounts don't correspond.

We recently added Netsolutions and use IATS and I agree that reconciling is a challenge.  I have used the Method of Payment report with best results.  The MC and Visa charges post to our bank account usually the next day with a description of "merchant bnkcd" and for the full amount of the charge.  The AMEX and DISC charges post after about 5 days with a description of "iats"and post to our account net of fees.  So I run a report from Raisers Edge to identify the credit card donations by date and have been successful in reconciling that way.

 I wonder if there is a way to get a report on IATS that provides names and the cc type used by each online donor.  That would be very helpful.

Josette Bulnes

 We use Journal report from IATS. (Printer friendly version)

In our case money donated online from Sun to Sat the previous week is placed into our account on Thursday.  We run the IATS Sales Report, Bank Rec report for the Sun to Sat timeframe.   This shows total donated, total banked by IATS, number of gifts, and gift detail.   We check that the total banked by IATS is in line with what we see on our bank statement on Thursday.

We run a report in RE that shows online donations for the same time period and check that IATS total donated and number of gifts matches.