You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Bank reconciliation on value date

Received Response
191
Views
4
Comments

We bank with Skandinaviska Enskilda Banken - and they transmit a daily bank statement file in the ISO20022 CAMT053 V1 format.

Quite frequently, they add lines to our bank statement with an entry date of today but a value date of tomorrow... e.g. the 31st January (entry date) bank statement informs us that we have earned interest throughout the month... but it won't actually hit our account till 1st February (the value date).

If we use the Auto reconciliation function, then the line is reconciled in the General ledger based on the ENTRY date. However the money isn't in our account until the VALUE date and therefore that's the day it should be shown in the GL.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!