CiviCRM Community Forums (archive)

I would have thought that when a contribution is received the date/time recorded would always be the time in one specified time zone.    eg. As our association is in Australian on the east coast, we want all our payments recorded in AEST which is UTC + 10 hours. 


This seems to be what happens with contributions made with Australia ( Payments from Perth which is UTC+8 hours are recorded as received in UTC + 10 hour time as required)

However those from other countries are being recorded in their local time (USA, Singapore, New Zealand and Brunei are recent examples)

So a person living in Alabama USA who joined us at 11 am on 16 August in her time zone ( ie UTC - 5 hours) has a received date of 2012-08-16 11:00:00   entered against that payment.

However our payment gateway records the time of the transaction in our time zone (UTC +10 hours) which is 2012-08-17 02:00:00

This creates problems when we need to reconcile the contributions recorded in civi against the money deposited in the bank ( somthing we do on a daily basis)

When our bookkeeper tried to reconcile the bank statements with the civi income for the 16 August she had less money deposited in the bank than civi said there should be and for 17 August she had more money deposited in the bank then civi said there should be.

Over the two days the money balances out, but this requires journal entries in our accounting program and for me to check that we did get a contribution from another country.

Has anyone else had similar problems and if so have you managed to do anything to fix it?