Mr.Spreadsheet’s Accounting Spreadsheets – Guide for Accountants in practice …

November 19th, 2012

Exporting your  Accounting Data  …  The Mr.Spreadsheet accounting software range allows you to export or copy a Year End Trial Balance into third party software applications. Export via CSV format   The CSV worksheet contains all of the data necessary to create a CSV file for export into your Accounts Production software. Specifically, the CSV worksheet analyses the years data into 4 separate columns. Column A is the value, Column [...]

Mr.Spreadsheet’s Accounting Software – Guide for Accountants in practice …

October 3rd, 2012

Technical Blog  This Blog is aimed at Accountants in practice and serves as a general guide on how the Mr.Spreadsheet range of accounting software works and how it links into proprietary Accounts Production software such as Iris, Sage, etc … Our Accounting Spreadsheets – an Overview    Mr.Spreadsheet’s  Excel based workbooks are designed in Monthly worksheet format  with one worksheet for each month of the year and use our SOLE [...]

Self-Employed accounting spreadsheets – The essential ingredients.

July 6th, 2012

Many self-employed individuals will start off their business bookkeeping records on an accounting spreadsheet. The popularity of spreadsheets such as Microsoft’s Excel means that it is often the first ‘financial tool’ a businessman reaches for. But, is it the right one? In a previous article  ‘Accounting Software – are bookkeeping spreadsheets the answer for small businesses’  I examined the ‘bare minimum’ bookkeeping requirements for a small business accounting spreadsheet and [...]

Accounting Software – 10 things to do before you buy it …

June 7th, 2012

OK,  so you need to buy some accounting software for your new or growing business.  But, as you are not an accountant, you don’t know exactly what you need.  Here are 10 quick points to consider before you buy your  accounting program:  1.  Make a list of all the accounting tasks you have to perform 2.  Accessability – How and when and where do I need to access my data. [...]

Simple Accounting Spreadsheets – The pro’s and con’s of using the Cash Accounting VAT Scheme

April 10th, 2012

Many practising accountants recommend the Cash Accounting VAT Scheme.  The simple bookkeeping structure and positive cash flow benefits make this an ideal accounting system for many smaller businesses. Using  conventional  VAT accounting you will pay VAT on any invoices you have issued, even if you have not received the payment, and you reclaim VAT on any invoices you have received, even if you have not yet paid your supplier. The Cash Accounting Scheme differs from this. You [...]

Mr.SpreadSheet’s Accounting Software – Who needs it ?

March 6th, 2012

Potential customers often email me for advice on the suitability of our product range for their businesses. So, in this blog I thought that some rough guidelines  might help. Our accounting spreadsheets are designed for  small businsses and  ‘Not for Profit’ Organisations. The MrSpreadSheet Accounting Software range caters for VAT, Flat Rate VAT and non VAT Registered businesses. Typically our users would have up to 100 transactions per month. Most [...]

Why choose a Bookkeeping Template for your small business?

February 21st, 2012

Bookkeeping Templates  - I am biased … Now, let’s be honest, I sell accounting spreadsheets, so, I am obviously biased! My answer will sing the praises for  ‘simple’, easy to use bookkeeping and accounting spreadsheets and at the same time pour ridicule and scorn over more expensive proprietary accounting software  packages. But, not so. My background is 100% Accountancy, and for the past 25 years 80% Accounting Software.  I am [...]

Accounting Templates for Small Businesses – Right or Wrong ?

February 8th, 2012

It is easy and inexpensive to use accounting templates but are they the correct choice for small businesses?   We all know that there is a legal requirement to maintain accurate accounting records covering your business transactions. The tax man, the VAT man and a miscellany of compliance regulations means that accurate bookkeeping records are essential. Notwithstanding the above, keeping correct information is vital if you want to run your [...]

Accounting Templates or Accounting Software …

February 2nd, 2012

Accounting Templates – A historic tale … I am very old, in fact I am old enough to remember good old fashioned Accounting Ledgers, Yes, those archaic, well-thumbed pages bound by two black leather covers and covered in pristine numeric script. Also popular at the time were large red cash books, which when opened had row after row and column after column of this same pristine numeric script. [Could the [...]

Accounting Spreadsheets and Excel 2010 Starter Version…

January 18th, 2012

Those naughty boys at Microsoft have started to ship a ‘CUT DOWN’ version of Microsoft Office on new PC’s and Laptops sold through retail outlets. This starter version has VERY limited functionality, and seems to be no more than a marketing ruse to get you to upgrade to the full version. So, BEWARE that this is NOT the full package and many of the NORMAL features will not be available. [...]