Finding a missing/mistaken payment against credit card report

Hi all,

This is probably a basic question! We have a payment we need to investigate, and need to look at all our credit card payments (not web) . Ideally I would run off a report listing all credit card payments for a day so we can line-by-line match against our credit card provider report. We can see each sale on the posting report but they are grouped in batches rather than by time of day, I've tried other reports on the system but so far haven't found a helpful one.

Can anyone advise how they would go about this check and what reports they use?

Thanks,

Kat

Parents
  • I don't have access to the Payment Gateway Activity report, so I don't know what that provides you, but when I need to do this type of research I use the Transactions by Posting Report.  Since we set up a different cash account code for each type of payment (i.e. Cash, Visa, MC, Discover, American Express) I can filter if I happen to know what I'm looking for.  If I'm just off and searching for what the difference is, then I can exclude Cash and Check payments, and have a report listing all the daily transactions paid with credit cards. I then go through line by line looking for what's different.  I do find it useful to export the data into excel and sort by amount to make the line by line checking slightly faster since this report also is not in order by time of transaction.

Reply
  • I don't have access to the Payment Gateway Activity report, so I don't know what that provides you, but when I need to do this type of research I use the Transactions by Posting Report.  Since we set up a different cash account code for each type of payment (i.e. Cash, Visa, MC, Discover, American Express) I can filter if I happen to know what I'm looking for.  If I'm just off and searching for what the difference is, then I can exclude Cash and Check payments, and have a report listing all the daily transactions paid with credit cards. I then go through line by line looking for what's different.  I do find it useful to export the data into excel and sort by amount to make the line by line checking slightly faster since this report also is not in order by time of transaction.

Children
No Data