The Book-keepers Forum (BKF)

Post Info TOPIC: Just learning - cash to bank query


Member

Status: Offline
Posts: 8
Date:
Just learning - cash to bank query
Permalink Closed


Hello
I'm just learning bookkeeping with an online course and after having finally got to grips with the credits and debits, I'm a bit confused in dealing with cash going into the bank.

My spreadsheet exercise requires that the cash from the sales that day is paid into the bank, so I have £300 to pay into the bank.

The spreadsheet has two columns in debit (cash and bank) and two columns in credit (cash and bank).  And there is a "bank deposit" entry of either side required.

But if I have £300 in the cash debit column surely I just put -300 in that and +300 in the bank debit column?  The balance of money available is still the same, but as I'm paying in £300 to the bank, then it remains on the debit side.

That is what my confused logic suggests is correct. But then why is there a bank deposit section on the credit side?

I've attached a spreadsheet - would be grateful for some explanation - I'm very confused!

regards

Denise


Attachments
example.xls (18.5 kb)
__________________


Guru

Status: Offline
Posts: 1470
Date:
Permalink Closed

Hi there,

It's asking you to deposit £300 cash into the bank, so I think only two entries are required, a credit of £300 in the cash column where it says Bank deposit and a debit of £300 in the bank column where it says Bank deposit. In other words you're taking the money out of the cash account and putting it into the bank.

Hope this helps.

Pauline

Attachments
example.xls (18.5 kb)
__________________

Pauline



Member

Status: Offline
Posts: 8
Date:
Permalink Closed

Hello

Thanks for your reply. The problem I see with the example you have is that the total of the cash/bank debits column is increased by £300, and on the credits side it implies that the £300 has been paid out. (paid out of the bank goes in the credit side, payments received on the debits side).

On the debits side, there is a total of £9600 income, so by just putting -300 in C9 and +300 in D9 still gives the total as £9600 income, it's just that £300 has been moved from cash to bank.

So what goes into G11?


Denise

__________________


Guru

Status: Offline
Posts: 595
Date:
Permalink Closed

Hi Denise,

That's it. There is no extra income, your over all balance(cash&bank together) should not change. You only have to move money from one a/c to the other...
You DON'T use negative numbers (no -300) in duble entry. So yes CR cash £300 and Dr bank £300.

HTH

__________________

Attila



Guru

Status: Offline
Posts: 1470
Date:
Permalink Closed

Hi Denise,

As Attila said, there is no -300. A "minus" debit is a credit. So the £300 goes out of cash (credit side) and into the bank (debit side). That's it smile.gif

Pauline

__________________

Pauline



Member

Status: Offline
Posts: 8
Date:
Permalink Closed

Hello

Thank you for your replies.

After staring at this for a while and doing some maths the long way round (x - y + z), I finally understand!

Thank you for your help in this.

regards

Denise





__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About