Cash Book System - Features
The Cash Book System template features include:
- Allows customised income and expense items
- Sales and Purchase Ledgers - simple and easy to use
- Unlimited accounts added or inserted with a click of the button
- Simplified and clear bank reconciliations
- Summary reports for Profit & Loss and Cash Flow
- Aged Customer and Supplier Summary Reports at a glance
- Trial Balance with Monthly Movement and YTD Balance
- Cash or Accrual Based VAT
- Automated quarterly VAT returns - presented like the HMRC return itself
- VAT Return summary information
- Additional Analysis for departments, sales teams etc
- No knowledge of Excel formula needed
- Online step-by-step guide
- Easy worksheet layout with marked areas and drop-down choices
- Automatic updates and notifications
- Designed for Excel for Windows versions 2000 to 2007
- Branded for your business
Sales and Purchase Ledgers *NEW
A simple and easy way for businesses to keep records for Customers and Suppliers. The transaction processing has been kept simple for all users. Once a item type is selected such as invoice, payment or receipt, it will automatically set the account choice to be either an receipt/payment account or a payment method type.
Simplified Bank Reconciliations
This system will handle the bank reconciliation in an accurate yet simple way just mark and date transactions shown on the bank statement and entering the balance at the end of a period.
Summary Reports
Summary reports are presented within this Excel template in a familiar Profit and Loss style report. This report is displayed monthly so you can easily compare.
Trial Balance *NEW
A clear and easy to use Trial Balance report providing a list of all accounts and their debit and credit balances, as well as a single column total. This report also includes movement for all accounts in the current month, as well as the YTD balances.
Cash or Accrual Based VAT *NEW
VAT can be dealt with on a cash or accrual basis, chosen from a simple drop-down option. Error checking ensures VAT claimed on a cash basis for payments and receipts doesn't exceed those on the invoices.
VAT Returns
The Cash Book System presents clear VAT Returns, collating the data as you would expect and presenting it just as the VAT Return itself.
Unlimited Add or Insert Accounts *NEW
All payments and receipts (income and expenses), methods of payment, customers and suppliers can have additional ones added or inserted at any time. All drop-down selections and summary reports are instantly updated.
Additional Analysis
Further analysis can be applied to transactions for departments, sales teams, budget managers and so on - with a summary report filtered to show analysis for any month or the entire current year.
Minimal Excel Knowledge and with a Simple Layout
With a consistent layout and areas marked where entries can be made, this Excel template is easy for everyone to use. To protect the user - flexible formula has been locked in so you needn't worry about understanding how it works behind the scenes... just select the settings you need from lists and you are ready to go!
Online Step-By-Step Guide
Full step-by-step instructions with pop-up screenshots to guide you through the system and how it works. Available at our Online Documentations section.
Automatic Updates and Notifications
When a new version of the Cash Book System is released, your Excel template will automatically notify you and your clients that a new version is available. Updating is then easy with a 'click of a button' to update all data from the previous version.
Branded for your Business
As with most of our Excel templates, these are branded to build your business image. This makes an excellent marketing tool, a professional template you can provide to your clients, letting them maintain clear records in your Cash Book System.
Development Desk
You're not just getting a template, but an ongoing service. You might have slightly different needs to what this template does, or your needs might change in the future.
You also get ongoing development to meet your needs now, and in the future. Our Development Desk is free and easy to use for all members and template purchasers. There's no need for you to spend time on formula, or trying to add functions - let us do it for you.
So if there's something you would like, save yourself the trouble and let us know!