Help Needed - Reconciling Worldpay Transaction

[kessa]

Hi all,

I'm trying to reconcile our Worldpay transactions, but it's giving me some real headaches trying to get everything to tally up.

All of our sales, Monthly Worldpay invoices, and Transaction Invoices have been entered correctly into our accounts package.

However, when I come to reconcile them, I can never get them to match.

Sometimes I wondered if the difference was due to the "deposit adjustment" that Worldpay do (which rarely seem to be consistent from Month to month)

However, I've also noticed that whilst the "TSC" & "FTC" deductions shown on the "Transfer Invoice" match deduction listed on the "Transfer Report", any "GSC" deductions shown on the "Transfer Invoice" do not seem to show on the "Transfer Report"

Trying to identify where the problem lies is a pain too as Worldpay doesn't provide a statement feature that shows the "opening balance" and "closing balance" as you would with a normal bank account.

I've been in touch with Worldpay several times and even their customer services team haven't been able to make sense of the numbers either.

Does anyone else have problems when it comes to reconciling Worldpay transactions?
Does anyone have any tips/suggestions which may help?

Thanks!

 

[jacobc]

Have you checked at which stage they are taking their fees for the transactions? Is it possible they are deducting it from the amount they are transferring to your account hence the discrepancy?

Regards,

Jacob