[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Transactions Displaying Incorrectly at Reconciliation



-- snip lots of previous info --

There are two separate transactions, which relate to two separate entries
on my bank statement (albeit with the same date).

I am expecting to see two separate lines in the reconciliation, one a
debit of £6.00, the other a credit of £6.00, both with the same date of
2012-06-02.

Instead I am seeing just a single reconciliation entry for that date, with
a zero amount, under "Mismatched Transactions".

Is it possible that the two transactions are being merged together in the
reconciliation screen, which is why I'm seeing a single reconciliation
entry for £0.00?

You are correct that I am trying to reconcile account 1200.


The first transaction is as follows:

Reference : 3002
Date	   Ref  Desc Source Debit Credit Account
2012-05-11 3002 HSBC        6.00         7901 Bank Charges
2012-05-11 3002 HSBC              6.00   2100 Creditors Control
2012-06-02 3002 HSBC other        6.00   1200 HSBC Current
2012-06-02 3002 HSBC other  6.00         2100 Creditors Control

This is an 'invoice' for bank charges entered via Purchases->Add
Transaction, dated 2012-05-11, later paid via Cash->Payment on 2012-06-02.


The second transaction is as follows:

Date       Ref  Desc Source Debit Credit Account
2012-06-02 3003 HSBC              6.00   7901 Bank Charges
2012-06-02 3003 HSBC        6.00         2100 Creditors Control
2012-06-02 3003 HSBC other  6.00         1200 HSBC Current
2012-06-02 3003 HSBC other        6.00   2100 Creditors Control

This is a 'credit note' issued by the bank for erroneous charges, entered
via Purchases->Debit Note, dated 2012-06-02. The refunded charges were
received on the same day, entered via Cash->Payment, with the payment
amount being negative.


> For future reference, it might be better to search on reference (3002 and
> 3003) because that way we have a better idea of what we have.

Thank you. Tip noted. This is what I have done above.