Lost login?  
Sorpaid Home

ANA/004/14 Accountant Analysis tool - Clients with cash businesses - Not VAT registered

Price : £20.00 | Product Code : ANA/004/14
No. of Licences

What it does
How you use it
What is the benefit?

This differs from product '002 Simple analysis' and '001', in that this product '004' is intended for situations where there are very few bank transactions and also does not have a payroll and PAYE control, and Key Performance indicators, which are included as standard in '002' and '001'. It does not permit VAT analysis.

Pay £20 for an unlimited licence to use for as many clients as you wish. For £30 you can buy all three templates '001', '002', and '004'  - see product 'ANA/006/14 -Bundle'

This is a fee earning opportunity for a firm of accountants. This is a bookkeeping solution for a very small trade, who cannot justify the expense of a computerised accounting system.

This is a spreadsheet for use by the accountant of such a trader as a working template to produce an electronic extended trial balance. It could also be used by a client as their prime bookkeeping system.

It is designed for those trades whose transactions are almost all in cash and who are not VAT registered, such as taxi drivers, window cleaners, market traders, and will meet all their bookkeeping needs.

It records in a simple straightforward way all the transactions of the business, because a sophisticated, more expensive, software solution would be over the top for such a trade.

An accountant can use the template in two different ways: 

1) Supply a copy of the template to the client so they can record daily transactions as the year goes on

The accountant enters in the opening trial balance at the start of the year (if it is known at the time the file is passed to the client). The license authorises the accountant to send this file to as many clients as needed.

The accountant then passes the file to the client, and, for a fee, gives the client tuition in the basic elements of bookkeeping required to take full advantage of the spreadsheet.

The trader records on a daily basis all the cash receipts and cash payments, and if a till is in use, records any discrepancies on the till at the end of the day.

At the year end, the trader then passes the file to the accountant, who then collates information such as debtors, creditors etc and enters then into an inbuilt extended trail balance in a format that will be familiar to any accountant.

This enables accounts to be produced in a cost effective way, with an electronic working paper in a standardised format. This should reduce the time required to prepare such accounts.

As the licence is for one computer only, we would expect the accountant to send us £16  for any client who installed the template on the client's computer. We rely on the honesty and integrity of the client to do this.

2) Use by an accountant as an 'in house' analysis tool

If a client brings in a plastic bag full of unordered paperwork, this spreadsheet is an analysis tool that will help turn that plastic bag into a semblance of accounting order.

The accountant enters the opening TB, and analyses the paperwork to the cash payments and receipts analysis , and then enters the closing creditors and debtors to prepare an extended trial balance.

Knowledge required and technical support.

Because it is assumed that many users of these templates not only have a good working knowledge of Excel and  also are qualified accountants, then the help and support on the technical aspects of these templates is limited.

We are very willing to offer limited telephone support on initial installation, and advice on technical difficulties with the operation of the software itself. In practice, as the templates are Excel based, we have found that very rarely has there been the necessity for any detailed support.



Submit Enquiry

Please leave this field empty.

Get in Touch
01904 781318    info@sorpaid.com

Acomb Grange, Grange Lane, York. UK. YO23 3QZ

Click for Larger Map

© 2015 Chartmain Services Ltd t/a Sorpaid | Company Reg No : 07217558 | Registered in England
About us | Legal, Copyright & Privacy | Terms & Conditions | Delivery & Returns | Home
Payments Powered by Worldpay - All Major Credit and Debit cards accepted