[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Transactions Displaying Incorrectly at Reconciliation
- Subject: Re: Transactions Displaying Incorrectly at Reconciliation
- From: "Nick Prater" <..hidden..>
- Date: Mon, 16 Jul 2012 14:10:44 +0100 (BST)
-- 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.