Video Transcript

0:00
questions we had some live right here on
0:01
Facebook got another User submitted
0:03
question here in uh one of our Facebook
0:05
groups Dan wants to know uh we pay a
0:09
percentage to our subcontract as the job
0:11
is performed is there a way of
0:12
generating reports showing the work a
0:15
subcontractor is done the problem is a
0:17
lot of our jobs are uh part of our
0:21
installment plans offers so basically
0:23
they’re doing an installment plan
0:25
payment uh fixed monthly payments
0:27
customers and service autopilot
0:30
generates the course based on invoices I
0:32
need an input a dollar amount inserted
0:34
for those installment customers uh tired
0:37
of using Google Sheets to come up with a
0:39
subcontractor’s payment so Dan uh the
0:43
solution here to your problems of paying
0:45
your subcontractors as a percentage of
0:47
the work that’s been completed as well
0:49
as the ones for installment plans can
0:51
actually really be easily tackled here
0:53
so I’m going to open up the screen and
0:55
talk about how do we pay our uh
0:57
contractors as a percentage of an
0:59
invoice a percentage of an installment
1:01
for the jobs completed
1:03
and there’s two different ways or three
1:05
different ways we can tackle this dance
1:07
questions as a percentage of invoice we
1:09
can do it as a fixed amount or we can do
1:11
it as a dollarly amount based on the
1:14
budgeted time uh predominantly it’s
1:16
going to be based on a percentage of the
1:20
invoice amount so if you have multiple
1:22
subcontractors and you have your more
1:24
veteran subcontractors and getting paid
1:26
at different rates or percentages uh
1:28
good news is I got a solution for you
1:30
here so typical fashion I’m going to
1:31
open up the screen and show you how to
1:33
actually tackle this in-service
1:34
autopilot and Dan wants to know how do
1:36
we pay that percentage
1:38
um of the invoice as a commission
1:41
um and especially if it’s on an
1:43
installment plan so we’ve got the
1:45
question here from Dan and I’m going to
1:46
hop into service autopilot what I’m
1:49
going to do here is there’s two things
1:50
Dan that you really need to tackle up
1:52
front
1:53
um the first part of the question is
1:54
he’s using an installment plan to
1:57
actually pay the uh these billing
2:00
decline in installment plan and he’s
2:01
paying the subcontractor percentage of
2:04
each individual service or part of the
2:06
services inside the installment plan so
2:07
Dan the first thing you want to do is go
2:09
in the service autopilot at a contract
2:11
this can be done in V2 and V3 where I do
2:14
recommend V3 is going in to be able to
2:17
apply the chart of accountancy income so
2:20
if we’ve got our test client here this
2:23
is going to be our test uh installment
2:27
and then I’m going to actually open up
2:28
the record and see how this is in we’re
2:30
gonna have a start and end dates of gen
2:32
1 to let’s say
2:35
December 31st and we are going to have
2:39
lawn mowing
2:42
and our spring cleanup
2:47
and our fall cleanup now there could be
2:49
some other ones in here but if you were
2:51
like myself at Callahan’s lawn care a
2:53
lot of our
2:56
Services we did were actually
2:58
subcontracted out based on
3:01
um different services so the the fall
3:04
cleanup we subcontracted most of those
3:06
out to take the risk out of it because
3:08
we would actually go in and do a high
3:09
low pricing or a fixed price the
3:11
contractor was okay with that so we did
3:14
the lawn mowing the fertilization
3:15
in-house but we do we de-risk some of
3:18
those services that had open-ended uh
3:20
things this is a great opportunity to
3:22
talk about some some methodology behind
3:24
this uh in addition the default Service
3:25
uh we’re gonna have to go in and
3:27
actually create one service so
3:30
um
3:31
you may just have a maintenance service
3:35
um but the Deep the the downfall of V2
3:38
installments is you can only set a
3:40
default service so all the income is
3:42
going to be applied to that default
3:44
service so if you want your chart of
3:46
accounts which I’m going to recommend
3:47
using go into V3 and set up each service
3:50
that adds up into the installment and
3:52
that’s going to give you a cleaner chart
3:53
of accounts for accounting and when you
3:55
add that to QuickBooks manually or
3:57
through the sync let’s say we go in and
3:59
this is a thousand dollar a month
4:00
contract we’re going to auto fill that
4:02
in we’re going to fill on the first day
4:03
of the month and I’m going to suggest
4:05
maybe we Bill one day in a month and
4:07
payment type is going to be credit card
4:08
we’re going to Auto generate activate
4:10
and include any sub properties so the
4:12
part here Dan that you’re missing before
4:14
we get to your report so we’re going to
4:15
go in and add our contract items here
4:18
and I’m going to add in our lawn mowing
4:23
and we can put the number of visits in
4:25
here if we want so my market that’s 28
4:27
and if it’s part of an installment plan
4:29
if the it’s greater than or equal to
4:33
or actually greater than 28 visits that
4:35
contract may actually allow us to
4:39
charge extra so those are the things we
4:41
want to put in there so we’re going to
4:42
list all our services then hit save so
4:45
Dan I think the piece you may be missing
4:46
is when we go in to add that lawn mowing
4:49
we should be driving it through a price
4:50
Matrix we have budget time and cost off
4:53
the Facebook live I’m just going to put
4:54
this in as a one-time or a reoccurring
4:56
job
4:58
um but hopefully we’re going through a
4:59
process through production rate based
5:00
estimating so our schedule here is I’m
5:02
going to do a weekly Monday and we’ve
5:05
got our lawn mowing
5:08
service
5:10
and automatically the rate of say 50
5:12
bucks and one hour should load if we’re
5:15
using a price Matrix now the idea here
5:18
Dan is I’m guessing based on your
5:20
question is in my market we’re going to
5:22
be probably starting the second week of
5:24
April and we’d start recurring
5:27
on the second week of April so that’s
5:28
how we would set this up and why I’m
5:30
looking at this part here is I want to
5:32
set the foundations up for the report
5:34
because if this isn’t set up the data in
5:36
the report is not going to be there so
5:39
good data in good data out essay a lot
5:42
of these softwares no data in no data
5:44
out so this is the foundation the report
5:45
Dan before we jump in there so we need
5:47
to do is go in and set the contract of
5:49
the test installment and once we hit
5:52
save that rate and budgeted hours in a
5:55
time
5:56
um and you also obviously need to select
5:58
a resource so we’ll go in and put uh
6:00
moku number six in here
6:03
and once we hit save that job now will
6:06
be dispatched with the dollar amount the
6:07
budgeted time but it will not build
6:09
because it’s Associated to this
6:11
installment contract that’s the key that
6:13
I’m assuming Dan is probably missing now
6:15
once that’s is set up and we’ve done
6:17
that
6:18
we need to go in and we go to the report
6:21
Center under reports report Center this
6:23
is a pre-built report that uh we’ve
6:25
built out for simple growth this is a
6:27
piece rate report or it can also double
6:29
as a subcontractor payment report so if
6:33
Chris here was one of our subcontractors
6:36
these are all the jobs the start and
6:37
stop times he had we’ve built some logic
6:40
in it we need to check the dollar amount
6:43
because there wasn’t one in this test
6:44
account or clock in a clock out time uh
6:47
and what we can do is go in and we can
6:49
see the assigned resource or the
6:50
assigned
6:51
subcontractor we can filter Down based
6:54
on job status so that is exactly what
6:57
Dan was talking about we want to pay
6:58
upon completed so is there a status of
7:01
completed who’s the assigned resource in
7:04
the assigned resource we have gone in
7:06
and aggregated and grouped them together
7:07
and what we’ve got now is different pay
7:10
rates hourly or percentages of the
7:14
invoice that we would be paying on there
7:16
now you can see that some of these paid
7:18
percentage of billable pay hours is 50
7:20
percent
7:22
um that is when we have two employees
7:24
that are splitting that time or two
7:26
subcontractors so if you have two
7:27
subcontractors that may be working
7:29
together on a project the ability to
7:31
separate those out is available inside
7:33
that report Center when you build this
7:34
custom level So based on a hourly rate
7:37
based on budgeted time we have up to
7:40
eight pay levels you put in or
7:41
percentages of the dollar
7:43
and this is the actual pay output for
7:47
that that subcontractor employee for
7:49
that week based on the work we’ve done
7:51
and their payout or of dollar dollar
7:53
amount per hour or the um percentage of
7:57
the invoice and this question Dan this
7:58
would be the payout based on the level
8:00
of percentage payout which would be
8:02
updated here so uh this is something you
8:04
can definitely build out yourself if
8:05
you’re interested simple growth does
8:07
have uh this solution already TurnKey
8:09
for you uh but the idea here is to go in
8:11
and actually hit the basis and show you
8:13
what to do if you’re building this
8:14
yourself main thing is we got to set up
8:16
the installment and inside the
8:17
particular job we assign it to the
8:19
installment package and the contract so
8:22
it does not double bill and when we do
8:23
that that dollar value of the job amount
8:26
here will come in and based on the
8:28
assigned resource that we’ve grouped
8:29
together we know that it’s assigned to
8:31
the subcontract or accrue and once the
8:34
status is done so we’d go in and
8:36
automatically set a filter on this to
8:38
run
8:40
on a date range or in this instance a
8:44
sliding date last week start last
8:46
weekend and we’d pay that subcontracted
8:48
weekly or monthly basis so comments
8:50
questions drop below Callahan’s corner
8:51
you ask the questions we answer them
8:53
live right here on Facebook how to pay
8:54
your subcontractors is it percentage of
8:56
the invoice or potentially set up a
8:58
piece rate pay system or pay for
9:00
performance as they call it now uh for
9:02
your team Dan great question please drop
9:04
your questions uh in the chat or in the
9:06
Facebook groups and
9:08
um we will definitely get these on here
9:09
live and update them inside the Facebook
9:11
group to help you go out and out learn
9:13
your competition for this upcoming
9:15
season Mike Callahan with Callahan’s
9:16
corner