Advanced search

Recommendations for book keeping / record keeping templates please!

(8 Posts)
MadameGazelle Wed 31-Aug-11 20:21:28

Hi, DH and I have just set up our own business and are trying to get to grips with record keeping. I have been on the business link website and tried to download the cashflow, sales and purchase ledger spreadsheets but it won't let me. I wondered if anyone knew of any other templates or spreadsheets I could download and use. I am familiar with excel so anything excel based would be great! TIA

mranchovy Thu 01-Sep-11 11:21:10

The 'spreadsheets' on the Business Link site are a joke - they are just a set of column headings - no totals, not even any formatting so you get columns like:


Excel is not really the best tool for the job for a number of reasons I won't go into now, if you must have something free try VT Cash Book or TAS Basics. For a low cost solution, look at on line systems - my favourite is Accounts Portal.

Tee2072 Thu 01-Sep-11 11:28:44

Curious as to why Excel isn't the best thing to use? My old company uses it (along with Sage). And I use it for my own accounts.

mranchovy Thu 01-Sep-11 15:29:09

Principally because it is too easy to introduce errors of omission (adding a new entry at the bottom of a list which is not included in the SUM range).

It is possible to introduce controls that mitigate this risk, and then you end up with something like this, but by the time you have done that you have lost most of the advantages of going with Excel in the first place.

Using some other system (such as the ones I linked to or even [barf] $age if you must) for prime entry and exporting to Excel for reporting is a different matter, and is the optimum solution for most organisations.

covkimbo Fri 02-Sep-11 17:29:54

Message deleted

TalkinPeace2 Fri 02-Sep-11 20:34:49

YUCK to quickbooks

Tas any day

or for a spreadsheet, Towatessa on ebay sells a sheet that is macro /
password / ICAEW level that does basic SA accounts - for around £15

Sage instant basic is around £90 and so long as you do not pay for support - read the forums - is cheap and reliable

BlueCat2010 Fri 30-Sep-11 22:35:57

Towatessa doesn't hang out on ebay at the moment Talkin, but she picks up her emails from time to time if you message her through them. thanks

TalkinPeace2 Sun 02-Oct-11 20:45:39

I am Linkedin to Towatessa at her firm.
And she's beating me at FB Scrabble!
I can send her a link to this thread any time if people want!

Join the discussion

Join the discussion

Registering is free, easy, and means you can join in the discussion, get discounts, win prizes and lots more.

Register now