| Cash Book Excel Template [message #380196] |
So, 16 April 2006 10:44 |
|
Hi,
I was just reading a book about book keeping.
I would like to run a cashbook, an analysed one with all the colums.
Can anyone let me know where I can see a list of the colums I need to use.
Also, is there an excel spreadsheet cashbook that can download from
somewhere?
If it makes a difference, it is for a VAT Registered LTD company. (the book
I was reading was for a sole trader)
Thanks
D
|
|
|
| Re: Cash Book Excel Template [message #380202 ] |
So, 16 April 2006 11:40 |
|
x wrote:
> Hi,
>
> I was just reading a book about book keeping.
>
> I would like to run a cashbook, an analysed one with all the colums.
>
> Can anyone let me know where I can see a list of the colums I need to use.
>
> Also, is there an excel spreadsheet cashbook that can download from
> somewhere?
>
> If it makes a difference, it is for a VAT Registered LTD company. (the book
> I was reading was for a sole trader)
>
> Thanks
>
> D
The traditional cash book format is in two parts. Assuming you are cash
Accounting for VAT:
RECEIPTS
Column headings:
Total, VAT, Sales, Other
PAYMENTS
Column headings:
Total, VAT, Purchases, Motor Expenses, Heat and Light, Telephone,
Insurance, Repairs and Renewals...dah-di-dah-di-dah...Sundry Expenses.
You tailor the headings to fit your business and the CT600 Corporation
Tax Return you will need to fill in using the summarised figures.
You have one Cash Book per Bank Account, and a separate Petty Cash book
for each Cash Tin. The Cash Books are accompanied by (usually monthly)
Bank Reconciliations, reconciling Bank Statement balances at the top to
Cash Book balances at the bottom.
|
|
|
| Re: Cash Book Excel Template [message #380211 ] |
So, 16 April 2006 13:43 |
|
In message <Btn0g.51081$g76.26282 [at] newsfe2-gui.ntli.net>, x <x [at] x.tv>
writes
>Hi,
>
>I was just reading a book about book keeping.
>
>I would like to run a cashbook, an analysed one with all the colums.
>
>Can anyone let me know where I can see a list of the colums I need to use.
>
>Also, is there an excel spreadsheet cashbook that can download from
>somewhere?
>
>If it makes a difference, it is for a VAT Registered LTD company. (the book
>I was reading was for a sole trader)
>
>Thanks
I know this doesnt answer your question but Money Manager by moneysoft
is a very good little accounts program that works in a 'cashbook' style
without the complications of sage etc.,
http://www.moneysoft.co.uk/
Ive used it for years for sole trader, Ltd Cos, charities & clubs.
(I'm not connected with them!)
--
John Boyle
|
|
|
| Re: Cash Book Excel Template [message #380213 ] |
So, 16 April 2006 14:39 |
|
Troy Steadman wrote:
> You tailor the headings to fit your business and the CT600 Corporation
> Tax Return you will need to fill in using the summarised figures.
The CT600 starts with trading profits adjusted for tax purposes.
What is more important is the information required for the detailed profit &
loss account at the back of the accounts and the tax computation.
|
|
|
| Re: Cash Book Excel Template [message #380228 ] |
So, 16 April 2006 19:55 |
|
"Jonathan Bryce" <jonathan [at] localhost.localdomain> wrote in message
news:hgq9h3-76i.ln1 [at] michelle.jbryce...
> Troy Steadman wrote:
>
>> You tailor the headings to fit your business and the CT600 Corporation
>> Tax Return you will need to fill in using the summarised figures.
>
> The CT600 starts with trading profits adjusted for tax purposes.
don't tell the troll, let it do its own homework or more importantly make it
up as it goes along.
|
|
|
| Re: Cash Book Excel Template [message #380244 ] |
Mo, 17 April 2006 10:32 |
|
In article <Btn0g.51081$g76.26282 [at] newsfe2-gui.ntli.net>, x <x [at] x.tv>
writes
>Hi,
>
>I was just reading a book about book keeping.
>
>I would like to run a cashbook, an analysed one with all the colums.
>
>Can anyone let me know where I can see a list of the colums I need to use.
>
>Also, is there an excel spreadsheet cashbook that can download from
>somewhere?
>
>If it makes a difference, it is for a VAT Registered LTD company. (the book
>I was reading was for a sole trader)
>
>Thanks
>
>D
>
>
Email me privately. I will send you my template.
<not allowed to post it here>
--
Jon Griffey FCCA CTA
Hackett Griffey
Chartered Certified Accountants & Registered Auditors
2 Mill Road, Haverhill, Suffolk, CB9 8BD
Tel (01440) 762024
www.hackettgriffey.com
See website for disclaimers
|
|
|
