Have you checked the main website?
The answers to many questions are there!


Pavingexpert
The Brew Cabin
Paving, Drainage and
Hard-landscaping in
Britain and Ireland

Search Members Help

Welcome Guest [ Log In :: Register ]

ruler

 

[ Track this topic :: Email this topic :: Print this topic ]

reply to topic start new topic
Topic: Spreadsheet< Next Oldest | Next Newest >
Forestboy1978
Offline

Ganger




Group: Members
Posts: 992
Joined: Oct. 2011
Posted: 25 Feb. 2017,10:43 QUOTE

Hi guys,

I want to pay someone to compile a spreadsheet format for me.

Basically it's quite simple. I just x2 spreadsheets on the same page that are interlinked

One for expenses with and without VAT
And another that I input price  charged and calculates cost minus vat and then deducts expenses minus VAT to give me gross profit after VAT paid out and reimbursed on materials

Then I'd like another aspect of the spreadsheet where I can amend duration of the project so it gives me net profit after wages dependent on duration.

Ta
Back to top
Profile Personal Message 
jwill
Offline

Ganger




Group: Members
Posts: 133
Joined: Feb. 2016
Posted: 25 Feb. 2017,13:09 QUOTE

To be honest you'd be better off familiarising yourself with how to make one. This is because sometimes they need tweaking. Ie vat is different rates. If you know someone who can give u a little tutorial it is good time spent.
Back to top
Profile Personal Message 
Forestboy1978
Offline

Ganger




Group: Members
Posts: 992
Joined: Oct. 2011
Posted: 25 Feb. 2017,14:00 QUOTE

Time is a commodity I just don't have. I do know how to do basic spreadsheets and input formula but this is out of my knowledge area.
Back to top
Profile Personal Message 
rxbren
Offline

Ganger




Group: Members
Posts: 395
Joined: Jan. 2012
Posted: 25 Feb. 2017,17:03 QUOTE

Sounds like more hassle than its worth
For the second spreadsheet are you going to have to input prices into a database so it can work out what you need it to with regards to deducting costs and expenses?
As for the last one can't you simply work out what you originally priced the job at labour and profit wise then divide by the actual time worked
The database idea just seem a way to really complicate things
Back to top
Profile Personal Message 
Forestboy1978
Offline

Ganger




Group: Members
Posts: 992
Joined: Oct. 2011
Posted: 25 Feb. 2017,18:21 QUOTE

it's easy once it's set up. I have main expenses worked out and just add the odd sundry to it if need be.

I could just work this shit out each time but I figured if I had the template then I can just whack the figures straight into it rather than using the calculator and then it's there to be printed or whatever. Or amended etc
Back to top
Profile Personal Message 
jwill
Offline

Ganger




Group: Members
Posts: 133
Joined: Feb. 2016
Posted: 25 Feb. 2017,18:29 QUOTE

Mine is dead basic but your better off working the labour out manually. I.e. Knowing what you and blokes cost per day. Easier with subbies. Every thing is ex vat but With a vat column to help with returns. I could send you a copy of mine but it would definitely need altering as its not what u need. If u can do the basics you could prob make your own. I just link sums to cells in different pages. But all in one file.
Back to top
Profile Personal Message 
Forestboy1978
Offline

Ganger




Group: Members
Posts: 992
Joined: Oct. 2011
Posted: 25 Feb. 2017,20:47 QUOTE

Quote (jwill @ 25 Feb. 2017,17:29)
Mine is dead basic but your better off working the labour out manually. I.e. Knowing what you and blokes cost per day. Easier with subbies. Every thing is ex vat but With a vat column to help with returns. I could send you a copy of mine but it would definitely need altering as its not what u need. If u can do the basics you could prob make your own. I just link sums to cells in different pages. But all in one file.

That would be most appreciated. I think I just about know enough to adjust the equations if I need to. I'll probably learn what I need from your spreadsheet too to enable me to adapt it to mine.

Thanks very much mate :-)
Back to top
Profile Personal Message 
jwill
Offline

Ganger




Group: Members
Posts: 133
Joined: Feb. 2016
Posted: 26 Feb. 2017,08:40 QUOTE

Pm your email to me
Back to top
Profile Personal Message 
Forestboy1978
Offline

Ganger




Group: Members
Posts: 992
Joined: Oct. 2011
Posted: 26 Feb. 2017,12:32 QUOTE

Hi Jwill. I've done it myself mate but thanks a lot
Back to top
Profile Personal Message 
Forestboy1978
Offline

Ganger




Group: Members
Posts: 992
Joined: Oct. 2011
Posted: 27 Feb. 2017,23:19 QUOTE

OK so I thought I'd got this right but in checking it today I definitely haven't

I've got the equations right but the calculations wrong.

Basically it's late or I'm just thick as ***t but correct me if I'm wrong but

If you have a 10,000 job and it's 5000 expenses and 5000 labour and all your expenses included VAT and you billed 10,000 then what you'd lose in vat on your labour you'd gain back in VAT on your expenses. Input and output vat. Expenses are the input and labour being the output.

So, the more materials/ expenses go above 50% of the total cost charged of the job the more you'll benefit as you'll have more input VAT than output VAT right?

I think I'm right this far but it's at this point where my brain goes $%^^%$...

To calculate positive or negative VAT you need to do what???

VAT paid on labour OUTPUT + VAT INPUT on expenses - all expenses before VAT = total profit after VAT is balanced??
Back to top
Profile Personal Message 
Forestboy1978
Offline

Ganger




Group: Members
Posts: 992
Joined: Oct. 2011
Posted: 27 Feb. 2017,23:44 QUOTE

OK I think I have it...

Gross profit =

Total charged inc VAT - Expenses inc VAT + (input VAT - output VAT)

that look right to you?
Back to top
Profile Personal Message 
rxbren
Offline

Ganger




Group: Members
Posts: 395
Joined: Jan. 2012
Posted: 28 Feb. 2017,09:36 QUOTE

Why don't you just start a quickfile account its free for under 1000 inputs or about 50 (cant remember how much i paid but sounds right) if your over that for the year.

You just enter your receipts with totals paid (net and vat) enter your sales (total job prices) you can email your invoices direct from quickfile and even setup online payments/card payments and it will work everything out for you even do your end of year and vat returns

You can even photo receipts and upload them to your account not tried it but will do when change phone as camera bit shit on this one

Stop making things complicated for yourself when there are free/cheap accounting software to do the job for you
Back to top
Profile Personal Message 
lemoncurd1702
Offline

Ganger




Group: Members
Posts: 713
Joined: Oct. 2013
Posted: 28 Feb. 2017,22:00 QUOTE

Vat has nothing to do with your profit. Just add everything up excluding the Vat you pay which you get back anyway and the Vat charged which isn't yours.
Don't pass on the Vat that you retrieve on materials to customers, it doesn't work.


--------------
Cheers
Lemoncurd
Back to top
Profile Personal Message 
lutonlagerlout
Offline

Chief tea boy




Group: Moderator
Posts: 15151
Joined: Aug. 2006
Posted: 01 Mar. 2017,18:49 QUOTE

correct! the VAT you lose on labour plus the costs  associated with VAT mean that  the VAT that is returned just about covers these incidentals
I had a tree surgeon ring up the other day asking would I buy him a stump grinder and he would give me the money

I thought it was a bit odd till he suggested he would not be giving me the VAT portion

doh!

good bye and good luck to him :-)

LLL


--------------
"what,you want paying today??"

YOUR TEXT GOES HERE
Back to top
Profile Personal Message MSN 
dig dug dan
Offline

The Crusher Man




Group: Contractor
Posts: 2441
Joined: July 2003
Posted: 01 Mar. 2017,20:12 QUOTE

People are always trying to avoid vat.  Its one area not worth fiddling under any circumstances.

--------------
Dan the Crusher Man
01442 212315
www.crusherhire.co.uk
"a satisfied customer? we should have them stuffed!"
Back to top
Profile Personal Message 
Tony McC
Offline

Site Agent




Group: Moderator
Posts: 11079
Joined: July 2004
Posted: 02 Mar. 2017,10:49 QUOTE

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
Back to top
Profile Personal Message WEB 
lutonlagerlout
Offline

Chief tea boy




Group: Moderator
Posts: 15151
Joined: Aug. 2006
Posted: 02 Mar. 2017,18:31 QUOTE

i agree 100% with Dan on this, as soon as punters want to avoid VAT you know they will want to cut other corners,including maybe the price
best tip I ever heard was from Steve from London Stone,and that was never be worried to talk numbers to people
I.E. to most of us on here 100k +VAT may seem a lot of money,but to our target audience its kinda what they are expecting
interested in the quick books that Tony MC  mentioned,I use a spreadsheet for general stuff  but find with Building stuff there are so many factors that it is hard to just use a spreadsheet,so always end up checking prices manually :-)

LLL


--------------
"what,you want paying today??"

YOUR TEXT GOES HERE
Back to top
Profile Personal Message MSN 
jwill
Offline

Ganger




Group: Members
Posts: 133
Joined: Feb. 2016
Posted: 02 Mar. 2017,21:23 QUOTE

I would also avoid bringing the vat calculation into your profit. You should of be working on a net basis with regards to your profits and losses

I include gross figures in my spreadsheet but also a column with the seperate vat amount to make sums easier.

Gave up trying to analyse profit on each individual job long time ago. Although contracting not my main bread and butter. Too many combined overheads
Back to top
Profile Personal Message 
rxbren
Offline

Ganger




Group: Members
Posts: 395
Joined: Jan. 2012
Posted: 02 Mar. 2017,22:34 QUOTE

just use quickfile

no need for spreadsheets or possible equation errors at the end of the day this will cost you if you make a mistake

just put in your purchases and your sales it will work the rest out
Back to top
Profile Personal Message 
Forestboy1978
Offline

Ganger




Group: Members
Posts: 992
Joined: Oct. 2011
Posted: 03 Mar. 2017,18:56 QUOTE

I have taken in everything you have all said. It his being processed, along with an infinity of other stuff, by the finely tuned instrument that is my brain.......

Thanks
Back to top
Profile Personal Message 
19 replies since 25 Feb. 2017,10:43 < Next Oldest | Next Newest >

[ Track this topic :: Email this topic :: Print this topic ]

 
reply to topic start new topic
Quick Reply: Spreadsheet

Do you wish to enable your signature for this post?
Do you wish to enable emoticons for this post?
Track this topic
View All Emoticons
View iB Code


ruler

ruler