Tools

We have included a range of practical tools and examples to help record, plan and manage your finances. All the materials are free to download for your organisation's own use. If you think there are specific tools we should develop, please let us know!

Accounting records

Cashbook with year end reporting - excel format

A spreadsheet for recording income and expenditure transactions each month, it will also produce a year end report. Instructions are on the first page. Download  (NB If using a version of Excel prior to 2003 be aware that the formulae may not work.  Contact WYCAS for an older version).

Extended Cashbook with 25 funds - excel format

A spreadsheet for recording income and expenditure transactions each month, it will also produce a year end report. Please note this version has been extended with up to 25 funds. Instructions are on the first page. Download  (NB If using a version of Excel prior to 2003 be aware that the formulae may not work.  Contact WYCAS for an older version).

Extended Cashbook with 8 bank / cash / credit card accounts - excel format

A spreadsheet for recording income and expenditure transactions each month, it will also produce a year end report. Please note this version includes up to 8 bank / cash / credit card accounts. Instructions are on the first page. Download  (NB If using a version of Excel prior to 2003 be aware that the formulae may not work.  Contact WYCAS for an older version).

Extended Cashbook with 20 receipt categories - excel format

A spreadsheet for recording income and expenditure transactions each month, it will also produce a year end report. Please note this version includes 20 receipt categories. Instructions are on the first page. Download  (NB If using a version of Excel prior to 2003 be aware that the formulae may not work.  Contact WYCAS for an older version).

Payment Authorisation Slip - excel format

A simple authorisation slip that you can fill in and attach to your invoices to make the authorisation process transparent. Each page contains 4 slips.  Download

Payment authorisation slip - word format

A more detailed authorisation slip including sections for checking of the goods, entry on the accounting system, authorisation and payment. This slip takes up a full page.  Download

Financial records map - note this is the current diagram tool

A diagram showing how all your financial documentation fits together; demonstrating the importance of your cashbbook.  Download

Financial procedures - template document

A Microsoft Word version of our Good Practice Guide (No. 2) to allow for easier editing.  Download

Planning

Budget template - excel format

An excel document giving a layout for your financial plans. The headings can be altered/extended to suit your organisation's needs.  Download

Salary cost budget template (hourly rate) - excel format

An excel document to help calculate salary costs. The job titles can be amended to suit your organisation's needs.  Download

Salary cost budget template (annual pay) - excel format

An excel document to help calculate salary costs. This version also includes payroll costs. The job titles can be amended to suit your organisation's needs.  Download

Costing and pricing

Full cost recovery - organisational budget template

A document designed to help you work out the budget for your whole organisation using FCR techniques. It allocates all your 'shared' or 'support' or 'overhead' costs in proportion to staff time.  Download

Full cost recovery - project budget template

A document designed to help you work out the budget for a specific 3 year project. It also uses staff time as the allocation method although you can change this as you wish. This template is designed for people who do not know excel, and are fairly new to budgeting.  Download.

Full cost recovery - enterprise template

The enterprise template is like the project template but it includes a whole section to work out your income from sales and fees for your enterprise.  Download

Costing & pricing a service - allocation of overheads (step 1)

It is crucial for organisations selling services to individuals with a personalised budget to cost out services accurately. These tools (courtesy of CA Plus) help you see what your costs are, and whether the price and quantity you deliver are sufficient to be vable. There are the two steps to the templates: Step 1 is the allocation of overheads Download

Costing & pricing a service - step 1 - worked example

A worked example for step 1 - allocation of overheads Download

Costing & pricing a service - step 2 - worked example

A worked example of step 2 - details of products Download

Powered by WordPress. Designed by Electroville

Stringer House, 34 Lupton Street, Hunslet, Leeds, LS10 2QW | Charity Number 1076962 | Company number 3721361