Joined: July 2004
||Posted: 02 Mar. 2017,10:49
I know I'm not calculating prices or tenders any longer, but when I did, I used a series of linked spreadsheets which relied on a 'master' spredsheet in which all the latest prices were held and kept up-to-date. The pricing spreadsheets were pretty similar to those I make available on the main website, except they gave a lot more detail about labour requirements (tradesman/labourer/driver/etc).
However, the basic concept was that, f'rinstance, for a block paved driveway I'd only need to input type of block, total area, total perimeter and the pattern, and it would churn out a detailed cost plus a 'quotation' which could be printed off for the client.
For day-to-day accounting, then, as now, I relied on Quickbooks. I know my accountant isn't a big fan but I understand it, I'm familiar with it, I find it almost impossible to balls-up, and it gives me the feedback I deperately need on where I'm making and losing money. I let it do all the brane-ake about profits, losses, margins, VAT and everything else so that I can focus on what I do best - gawping at paving!
Site Agent - Pavingexpert