Cash Book Excel Template

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.

In message , x writes

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.,

(I'm not connected with them!)

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.

don't tell the troll, let it do its own homework or more importantly make it up as it goes along.

In article , x writes

Email me privately. I will send you my template.