Sunday, November 23, 2014

Cash Book System - Excel Template

Cash Book System - Overview

Need an easy to use accounts solution for clients to use?

Something to keep their records in order?

Our Cash Book System is an Excel based template designed for business that need to record the basics of incomings and outgoings, without the expense of over-powered or complicated software.

This makes light work for your clients that keep their own records. Something any of your clients would be able to use and you can relax knowing accurate accounts can be kept and reconciled easily.

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

 

 

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.

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

imageVAT 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!

 

Cash Book System - Trial Download

Members (free) can download a trial of the Cash Book System.

This is a full featured trial of the current template and you will be able to see how it works, and how easily your clients can maintain records and perform bank reconciliations.

The demonstration has been branded for ourselves and won't allow you to save. When purchased, or for business members it is branded for you.

Join Now!

First Name:   Username:
Last Name:   Type:
Email Address:   Password:
  Register  

Cash Book System - Purchase

Order today

This complete template, along with 12 months of updates and support is available for just $299 for the first year. This includes access to our development desk, and future years are only $149.

Our Guarantee

We're confident in our templates so if for any reason you are not fully satisfied within 30 days, we will give you a full refund!

 

    About Us     Testimonials     FAQs     Contact Us    


Privacy StatementTerms Of Use • Copyright 2007-2010 The Accountants Circle LLC. All Rights Reserved.