Donate SIGN UP

Setting Up Xl

Avatar Image
Ch49 | 12:21 Tue 23rd Nov 2021 | Adverts
10 Answers
I have just taken on the job as Treasurer for my club. I would like somebody to tell me in simple language how to set up an old fashioned page of debit and credit. Do I use XL or is there something else ?
Grateful for any help
Gravatar

Answers

1 to 10 of 10rss feed

Best Answer

No best answer has yet been selected by Ch49. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Excel is more than adequate.
In Excel if you go to File -> New there are many built in templates available and one of those will likely give you a good starting point for what you need.
You shuld have Excel pre installed if you are using Windows. There are at least half a dozen "accounts" templates available to you if you open Excel. I would have a look through them and choose the one that suits your needs best.

https://www.wordstemplatespro.com/debit-credit-excel-template.html
These are templates designed for treasurers. Again have a look through them. If you read through the details given for each template you may spot the one that fits your requirements.

https://www.how-use-excel.com/treasurer-excel-spreadsheet-template/
You will probably need two templates - one for a Cashbook to record transactions and a second for your Balance Sheet.
It is a bit of a devil to get at the templates but this may help.

https://www.creativetemplate.net/treasurer-report-templates/
A mare Edmund. I'm glad that my "commitee" days are over. P.S. never let yourself be elected as vice chairman of anything. It usually means that you are automatically chairman next time round and the job of treasurer is the position with the most responsibility with least appreciation.
Question Author
Many thanks to you all - hope I haven't made a huge mistake !!!
"A mare Edmund"

Togo - I appreciate that it can be - easier for me than most - I qualified as an accountant in 1979.....it can be a bit of a headache though when trying to explain accruals and the like.....
Easy peasy for you then Edmund. It wasn't the figures or arithmetic that were any problem, back in the day, it was just the setting them all down and making them "audit ready" that most of us disliked. It was all longhand in an accounts ledger back then ... piece of watsit these days if you have the programmes. :))

Good luck with it all Ch49.

1 to 10 of 10rss feed

Do you know the answer?

Setting Up Xl

Answer Question >>