Hi Ramadhan 

Can you please paste a screenshot on this chat on what you observe?

Is it your expectation/requirement here that you should view it as per the following example?

Transaction Date        Amount       Reference

12/11/2022                 500.00         Ref001

12/11/2022                 500.00         Ref005

Or exactly how, by using the above example?

Kind regards

Bennie .

Hi Ramadhan 

Can you please paste a screenshot on this chat on what you observe?

Is it your expectation/requirement here that you should view it as per the following example?

Transaction Date        Amount       Reference

12/11/2022                 500.00         Ref001

12/11/2022                 500.00         Ref005

Or exactly how, by using the above example?

Kind regards

Bennie .

As per your request

Bank statement file shows entries in red color are on the same date, same amount but different reference

The rest have different amount each of them

Sage Response on automatic reconciliation

All transaction with different amount have been ticked as reconcilled

Those two transaction with same amount 500 on the same date even though have different reference sage take them as duplicated

I think this is a bug

Thanks for the detailed feedback, Ramadhan

No, I disagree with you: This is not a software bug at all. 

If there are are two transaction with the same date and same amount, but different reference numbers, they must display separately.

Even though they appear as duplicated, they are not because the the different reference numbers clearly separate them

So, Evolution works perfectly as per design.

Do you agree? Or am I missing something obvious here?

Kindly refer to images attached on my response above. Two transactions with the same amount, same date but different reference sage term them as duplicate. As you can see Ref001 and Ref005 terms as duplicate on sage reconciliation.

Hi Ramadhan

They may appear to be duplicated but they are not duplicate records at all.

Evolution MUST separate them as they are in fact two different transactions, with different reference numbers. 

Do you actually expect to have only one transaction for 1000 (500 + 500)?

No what I expect is system to reconcile transaction by reference, date and amount. I wonder why when more than one transaction on the same date with same amount system treat them as duplicated. As it shown on example above. Kindly try to have more than one transaction on same date with same amount on your side and make automatic reconciliation then observe it. You will get a picture of it

Thanks for the detailed explanation, Ramadhan. I understand a bit better now. 

The best way forward here is to log this query with Evolution Support using the link below so that a detailed investigation on this matter can be done

https://app.smartsheet.com/b/form/4c5023eeaff24b05839f55753b05c465

You're welcome to request that this query be addressed for my attention. 

I wish I can give you a simple, easy answer but i suspect there may be either company data or a software issue involved here as the cause of your query.