Auditing PayPal payments

To reconcile transactions in your iMIS database with the PayPal Express entries, use the transactions report to obtain the Transaction IDs, Gross and Net amounts, dates, and PayerIDs. On the PayPal site, you can look up a PayerID to identify the purchaser.

To reconcile transactions in your iMIS database with the reports in PayPal, look at the Transaction ID that appears in the Details for an entry on the Overview page.

Note: Tip: Keep in mind that it is possible for addresses and even names to differ between iMIS and PayPal for a single Transaction ID. The Transaction ID in the merchant account listing is what pairs the two.

To retrieve audit details from PayPal

  1. Log on to paypal.com using your seller account.
  2. Select your account and enter the site.
  3. Locate the most recent transaction, verifying that the amount matches the order.
  4. Click the Details link for that line.
  5. View Unique Transaction ID # that appears next to the text Express Checkout Payment Received.
  6. In iMIS Desktop, look up the values as appropriate:
    • Orders > Open an order > Payments tab, Gateway Ref#
    • Events > Register a customer > Open a registration > Payments tab, Gateway Ref#
    • AR/Cash > Credit card reporting > Search CC Info, any combination of iMIS ID, iMIS Trans ID, and Gateway Ref#
    • (for future release) AR/Cash > Generate Reports > Credit Card > Credit Card Post Authorization Report (Crystal) returns the results for CC Auth Acct of PayPal (which is tied to cash accounts with a type of Service).