Reconciliation Value Date Format

With automated Reconciliation you can check in the RaiseNow Manager for the exact moment when a donation arrived on your bank account.

The parameter rcn_value_date stands for the date when the donation was transferred to your bank account.

Though you filter for the value date in the RaiseNow Manager you will quickly see that it does not show up in a normal format (DD.MM.YYYY):

What you can observe here is that the dates are shown in the unixtimestamp format.

This format is especially convenient for computer systems since it calculates the seconds that have passed since a specific point of time (January 1, 1970 UTC) an. Therefore, it does not change with the time zones but stays the same.

If you want to know when your payment was reconciled, you can:

• either copy and paste the date into a unixtimestamp calculator service like this one: https://www.unixtimestamp.com/index.php,

• or open the specific transaction in the RaiseNow Manager, the overview of transaction details features the normal date format under the point Reconciliation:

• or you export the information as Excel/CSV file, these programmes convert the unixtimestamp format to the comprehensible version automatically.

Filter: Transactions with/without reconciliation data

In this article we show you, how you can see with one action for which transaction reconciliation data is provided and for which not. The important parameter in this context is 'rcn_reconciled_by'.

 To show all transactions without reconciliation data please use the following filter:

!rcn_reconciled_by:*

Please note, that we can only provide reconciliation data after certain days and only for the following payment methods: 

SIX Payment Services (MasterCard, VISA, TWINT): Depending on your contract with SIX, please ask our support. 

Swisscard: Depending on your contract with Swisscard

PostFinance: 1-2 working days after the donation.

SMS: 1-2 days after the payment from FairGive

PayPal: 1-2 days after the donation.

In case you have questions regarding particular reconciliation data please send us an e-mail with the respective transaction id to support@raisenow.com.