The Book-keepers Forum (BKF)

Post Info TOPIC: Paying bills on Excel Debit or Credit


Newbie

Status: Offline
Posts: 2
Date:
Paying bills on Excel Debit or Credit
Permalink Closed


Hello,I have just joined.

I pay Council tax and other bill on behalf of someone else and therefore keep an Excel spreadsheet with a dr, cr  and balance columns

Should I put the bill on the debit side and the payment instalments on the credit side or the other way round?

In other words, do I treat this spreadsheet as a bank account or nominal account record of bills and payments?

Thanks in advance.

Alan

 

 

 

 

 

 



__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

Hi Alan
Welcome to the forum. The forum is for bookeepers and Accountants and the entries you mention are not business related, but given you mention bookkeeping terms, I am wondering if you are doing some training to be a bookkeeper?

The items themselves cannot represent the Bank per se as your records would be short of the remaining Bank entries so that would be pointless.

In terms of showing that someone owes you money (a debtor or receivable) then you could enter them as such - bill is a debit. But unless it is to further your knowledge as a bookkeeper, so therefore just to keep track of what is owed, then I would suggest just an excel with details of the bill, when you paid it with a another couple of columns showing when it was repaid/how much repaid - job done.

If you are training to be a bookkeeper - perhaps add on here, what course you are doing. Maybe we can suggest something to help

__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position



Newbie

Status: Offline
Posts: 2
Date:
Permalink Closed

Thank you Joanne, you have given me all I need

Best regards

Alan

__________________


Master Book-keeper

Status: Offline
Posts: 8646
Date:
Permalink Closed

right oh



__________________

 Joanne 

Winner of Bookkeeper of the Year 2015, 2016 & 2017 

Thoughts are my own/not to be regarded as official advice,which should be sought from a suitably qualified Accountant.

You should check out answers with reference to the legal position

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