I've never had this happen before. I have matched the transactions in the bank reconciliation and it balances with the paper bank statment. The problem is the bank account code 1200 says it has 265.49 more in it. This figure/transaction isn't outstanding in the bank rec though. I have even tried setting the bank rec date to the year 2099 in case i'd entered the wrong date but nothing appears. I have discovered that that amount is a deleted purchase payment. Trouble is what do I do to make the bank correct? Surely it's some kind of error with the program isn't it?the fact it's cancelled in the supplier account, doesn't appear in the bank rec but is in the bank?
Just had a look in the 1200 nominal code and it says in red that the type is PA details Deleted PP amount 265.49 and credit 265.49
I am using Sage Instant v16 and windows 7 Many thanks in advance
-- Edited by Pickle on Monday 27th of August 2012 02:29:15 PM
In summary, you'd entered a payment on account for £265.49, and reconciled it to the bank. You then deleted the payment on account, resulting in your bank reconciliation now being out by that amount.
If the payment really happened (and therefore appears on the bank statement) then you should not have deleted it - and the fix is to enter it again, exactly as before, and mark it as reconciled.
Before doing that, however, you should perhaps look at why you deleted it in the first place. I'm guessing (because I've seen it often enough) that it was to "tidy up the purchase ledger" (ie clear any odd balances) - in which case, just deleting transactions to clear/tidy it is the wrong approach. What you should do depends on the precise reason any given account needs to be 'tidied' in the first place.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Thanks Vince, I'm so silly! I was convinced I hadn't reconciled the deleted payment but I had. Couldn't match it to the bank statement so thats why I deleted it but now realise it was from a previous quarter. Thanks for the nudge :)
