Excel Timesheets
From: http://www.stdtime.com. Compares an Excel timesheet to our professional timesheet: Standard Time®. It's pretty easy to roll your own timesheet in Excel from a template. Just name the projects and employees, and then slap in some totals. You'll have something working within hours! But what's not readily evident is the money you'll lose by trying to use that Excel timesheet in your business. You'll "lose" hours every month, have pesky sharing issues, bookkeeping mistakes, retyping errors, manual reentry mistakes, and programming challenges to get the reports you need. Professional timesheets have been around long enough to overcome those common complaints. You can download a free trial and see how.
See more at: http://www.stdtime.com
LET'S CONNECT!
Standard Time ► http://www.stdtime.com
Twitter ► http://twitter.com/ScoutwestInc
Facebook ► http://www.facebook.com/timesheetsoft...
Google+ ► http://plus.google.com/11440974193538...
Linkedin ► http://www.linkedin.com/company/scout...
Pinterest ► http://www.pinterest.com/scoutwestinc
Android App ► http://play.google.com/store/apps/det...
iOS App ► http://itunes.apple.com/us/app/standa...
YouTube Subscribe ► http://www.youtube.com/subscription_c...
Closed Caption:
this video we're going to compare
a timesheet that you could create on
your own in a spreadsheet
against our time she which is
Center time I've seen a lot of these
kinda templates
arm they all typically look the same on
not always arrange the same but
typically you do have
a-list Project somewhere and then you
have a list 'em
employees are or you'll have one of the
spreadsheets for each employee
on a typical you want term you know one
that consolidates all of them
and you'll have templates like this harm
in in the middle here you'll have areas
where the employees would presumably
take their hours in
and housing total somewhere again they
don't always look the same
are and it's pretty easy to put these
tolls and you just type in a formula
something like this
and with that then we get to see the
tolls their
on so these are pretty quick n easy to
create
initially but you soon run into a series
of problems
and I talk to enough people that I
started to hear the same kinds of
problems
on wanna the issues is
ok for sharing let's say Ashley opens
this up to
type in some hours and if she happens to
leave it open
bill can't get to it she have to go and
can work out the sharing issues on
another issue that I've heard
years some the issue love lost hours
you think will happen especially dozen
you know change their numbers
on it happens a number of different ways
but
here's one home let's say actually goes
in
types in hours into the time she but the
bookkeeper has already taken those hours
where this time period and build them to
the client so
the new hours they actually typed in
we'll never get built
because the bookkeeper doesn't know
about them and Ashley doesn't know that
this
time period has already been built yet
to work all that communication
out and often that does not happen see
lose a few hours here and there
and no one notices so those few hours
that you lose on a spreadsheet solution
like this
you can make up easily by just using
a professional time she likes tenor time
soon I'm gonna switch over to Standard
Time
give you look at that Mon it also has
the same kinda
for spreadsheet look go to projects and
left inside
Monday through Sunday along the top in
this case were logged in as a user
on Sat each user logs and they certainly
see their own
own time course administrators managers
can see
everyone's time which you see the hours
are listed here
his daily tolls weekly total the
overtime
other kinds of tools down here via pay
periods
home you will see them listed there as
well so different kinda tolls that just
automatically come with the product
on but switch back to the time she
another thing about term these kinda
roll your own time sheets
is that that's all you get I mean it's
really all this is just a
kinda summary are I'll
the hours the people worked home going
back to Standard Time
if you look at the tabs along the top
here you see that there's six different
areas
so what if you wanna have some tasks
break a project down into some tasks
what if you wanted expense tracking
or integrated billing so that your
timesheet is integrated directly with
the billing
we talked about losing hours ways around
a
we've been in the business long enough
that we work through these issues
on what if you want a time of accrual
for vacation sick personal zone
maybe wanna go over here and look at
things like project revenue see how much
your projects are going to make
in the coming months on that something
you don't get with the spreadsheet
war let's say you wanna see a employees
availability
look down through looking at October
we've see that this person is not
allocated needs some work
on when you're dealing with a
spreadsheet
really you just have a simple home
you know totals for your hours and it's
so easy to
not lose track of things that on you end
up actually losing money
and not really realizing on there's a
lotta program that goes into trying to
get
the kinda numbers that you want let's
say you wanted to know what your
affective billing rate swaps
you could use utilization re
report here I'm gonna just look at
last month this person you see that
the effective billing rate his 132
dollars an hour
now you can get that with the
spreadsheet but you have to go through
certain formulas to get so these are
some the advantages
using a professional time she like
Standard Time
so one on the web look us up in and
download a copy and you'll see that term
love this just
these issues just come naturally and
easily and
salat actually simpler solution using an
Excel spreadsheet
Video Length: 05:34
Uploaded By: ScoutwestInc
View Count: 989