View Full Version : Simple Profit and Loss spreadsheet
PC Doctor
23rd July 2010, 11:28
Looking for some help finding a simple P&L spresdsheet wich I can use on a weekly basis. I'm no good with formulae.
My new business is in the service industry PC Doctor - servicing PC's
Incomings: Income from work done
Outgoings: Travel at 40p per mile
Advertising costs
Mobile Broadband costs
Mobile phone costs
Stationary costs
Equipment costs
I can pay with Virtual Tea and Biscuits
Thanks Patrick
Dawn Lane
23rd July 2010, 11:49
Try this link (small fee to purchase) http://www.simpleplanning.net/profit-loss-planner.html?gclid=CKfizLK8gaMCFYKX2AodX3yhYA or search under Microsoft Office templates - there is usually something there that you can customise.
Dawn
Philip Hoyle
23rd July 2010, 11:59
For a very simple in & out tracking program, try VT cash book which is free - can be downloaded from:-
http://www.vtsoftware.co.uk/cashbook/index.htm
Far better than a spreadsheet - will keep your bank account reconciled and also produce simple P&L and balance sheet as well as VAT returns.
If you need to track monies owed and oweing as well, you're definitely out of the scope of a simple spreadsheet - VT do an excellent full book-keeping system with sales & purchase ledgers (cash book's big brother) for around £100 one off payment - again downloadable from their website.
If you aren't good at writing and editing the formulae etc in a spreadsheet, and of course knowing the fundamentals of book-keeping, control accounts, please don't go there - you'll waste a lot of time and risk getting things wrong with a cobbled together home made spreadsheet.
VT is very simple, quick to input, and produces everything a small business needs.
MyAccountantOnline
23rd July 2010, 12:00
Hi Patrick
If you are looking after your own bookkeeping and want something which produces a P&L which is free and really easy to use this might be better than a spreadsheet -
http://www.vtsoftware.co.uk/cashbook/index.htm
Philip Hoyle
23rd July 2010, 12:01
Nicola, great minds think alike!!!
MyAccountantOnline
23rd July 2010, 12:04
Philip - I think we must have been typing at the same time!:)