I have a main current account which has out and ingoings from various investors. I have entered them under each investors own nominal code. However, I've just been given a new account and all its details which shows the money has been put into this account and gone from here instead of an external place.
How can I adjust things to reflect this? If I delete historic items it will mess up my previous reconciled months.
I currently have an entry into 1200 bank going to 2301 loan from investor £6,000 which has been reconciled in the 1200 bank.
Now I need to correct this transaction to reflect that it came from 1203 bank ac and was a transfer to 1200.
Is there an easy way for me to do this? Can't see the wood for the trees. Using Sage too.
Hi Rachael, I'm a bit confused. You say the main bank account (1200) is reconciled but the transfers came from a different account, so how is 1200 reconciled. Sorry if I'm misunderstanding the question.
I'm reading it as you have done a bank payment from 1200 to 2301, but you originally posted it as coming in directly to 1200 where it should have been posted as coming into 1203, transferred to 1200 the a bank payment to 2301, so you have missed the beginning bit out where it went into 1203. If this is the case then I would make payment into 1203 of whatever the amount may have been, delete the payment into 1200 leaving a negative figure, then transfer from 1203 to 1200 and this should leave you with the correct balances. I think you may have to then re-reconcile 1200, it may warn you about reconciled bits n bobs and so forth and so on.
-- Edited by Rhianrach on Tuesday 12th of August 2014 10:42:35 AM
So, you did Dr Bank (1200) £6,000 and Cr Investor Loan (2301) £6,000. There was a receipt of £6,000 on the bank statement for the 1200 account which you reconciled against the Dr side of the double entry just mentioned.
Now, you've discovered that bank account 1203 actually received the loan from the investor but that there was a transfer of £6,000 from account 1203 to account 1200 as well. So, you should have had 2 sets of double entry:
Dr Bank (1203) £6,000 and Cr Investor Loan (2301) £6,000
Dr Bank (1200) £6,000 and Cr Bank (1203) £6,000
You've done the bits in red.
A possible solution would be to process Dr Bank (1203) £6,000 and Cr Bank (1203) £6,000 now and reconcile these entries in 1203 against the two entries on the 1203 bank statement. Keep notes about what you've done and annotate the bank reconciliations. Both bank accounts will then be properly reconciled and the accounts will have the correct balances.
If I delete the payment made to the 1200 ac and then transfer the money back from the correct account 1203 to the main account 1200. How do I then get the money from 1200 into the correct nominal i.e 2301 investors account?
so I was looking for the easiest resolution. 
