How To Start Bookkeeping (FREE Template) - YouTube

Channel: Accounting Stuff

[0]
in this video you'll find out how to
[2]
organize your business's finances using
[4]
an ancient technique it's simple it's
[6]
free and you can have it up and running
[8]
in a matter of minutes hey there welcome
[14]
back to the channel I'm James this is
[16]
accounting stuff and in today's video
[18]
we're going to head back in time why
[21]
because I want to show you a quick and
[23]
dirty method that you can use to start
[25]
bookkeeping your small business today
[27]
have you ever struggled with keeping a
[29]
record of all of your sales and expenses
[31]
can you tell me what your profit or loss
[33]
the last month was maybe you've been
[35]
stashing receipts in the shoe box under
[37]
the bed but it's all good
[38]
you'll sort them out when you find the
[39]
time don't worry we've all been there
[41]
and seriously if any of that resonates
[44]
then congratulations you're watching a
[46]
video about accounting which means
[47]
you've taken the first step towards
[49]
grabbing your business's finances by
[51]
there and you can take that second step
[53]
by subscribing to this channel for more
[55]
weekly accounting videos the biggest
[57]
reason that small businesses fail is
[59]
because of poor cash flow management so
[62]
we're going to make it dressing that on
[64]
number one priority on accounting stuff
[66]
we've talked a lot about double entry
[68]
accounting even when we haven't
[69]
mentioned it by name the accounting
[71]
equation debits and credits pretty much
[73]
everything we've covered in the
[75]
accounting basics playlist is a direct
[77]
consequence of one beautifully simple
[80]
idea that there are two equal and
[82]
opposite sides to every business
[84]
transaction because in the world of
[86]
finance money can't magically appear or
[88]
disappear but in this video we're going
[91]
to take all of that stuff and throw it
[93]
out the window double entry accounting
[94]
might be one of the greatest discoveries
[96]
of the past six hundred years but it was
[98]
invented for merchants in Venice who
[100]
were doing complex trades with loads of
[103]
different groups of people not all
[104]
modern businesses are as complicated as
[106]
that so not all businesses need to use
[108]
double entry accounting the alternative
[111]
predates double entry accounting by
[113]
literally thousands of years and it
[115]
still has its place today especially
[117]
when we're talking small businesses with
[119]
minimal financial transactions
[121]
can you guess what it's called single
[123]
entry accounting I'm going to show you
[125]
how you can use single entry accounting
[127]
to manage your business's cash flow
[129]
right now don't forget to watch this
[131]
video through to the
[132]
because I have a free template to share
[134]
with you and I also want to make it
[136]
clear that this quick and dirty template
[138]
isn't for everyone it has its flaws so
[140]
hear me out and we'll see if it fits in
[142]
with your business let's go we'll kick
[145]
things off with a definition the single
[148]
entry system single entry bookkeeping or
[151]
single entry accounting whatever you
[153]
like to call it is a method of
[155]
bookkeeping that only recognizes one
[157]
side of a business transaction as an
[160]
accounting entry bookkeeping is what we
[162]
call the process of recording all of
[164]
your business's financial transactions
[166]
and that one side that we're going to
[168]
recognize is an accounting entry to the
[171]
cash account I said earlier that the
[173]
biggest reason that small businesses
[175]
fail is because of poor cash flow
[177]
management single entry accounting is
[179]
about taking control of your cash
[181]
account so you've got a record of all of
[183]
the cash flowing in and out of your
[186]
business and what's great about this
[187]
system is that anyone can do it it's
[190]
simple and practical all you need to get
[192]
started is Excel or Google sheets let me
[194]
show you here we are in Google sheets I
[198]
like to use sheets because it's free
[200]
everything safely stored in the cloud
[202]
and all you need to do to get started is
[204]
have a gmail account and this is what a
[207]
single entry system looks like in its
[209]
simplest form we have a table that
[210]
summarizes all of your business's
[213]
transactions in a cash ledger which is
[215]
basically another name for your cash
[217]
account this is called a three column
[219]
ledger because we have three columns for
[221]
date description and amount for this
[224]
example let's imagine that you're
[225]
starting an e-commerce business from
[227]
scratch you're a keen writer a dog lover
[230]
and a massive Harry Potter fan so you
[233]
decide to combine all of these passions
[235]
together to create and sell Harry Potter
[237]
fan fiction under the pseudonym JK
[239]
growling let's do the bookkeeping for
[242]
your first month in business imagine
[244]
we've gone back in time is January 2000
[246]
the new millennium the Prisoner of
[248]
Azkaban came out six months ago and
[250]
you're desperate to get started on your
[251]
fanfiction the first thing we need to do
[253]
is identify the accounting period so we
[255]
can go and write January 2000 in the top
[258]
corner of your empty cash ledger we now
[260]
return to all of the transactions that
[262]
happened in
[263]
January at the start of the month your
[265]
opening balance was zero this is a brand
[268]
new business so there's no cash to begin
[270]
with you decide to head down to the bank
[272]
and open up a new checking account
[273]
that's a good call because you don't
[276]
want to get all of your business and
[277]
personal expenses mixed up in your
[279]
personal account on the fifth you decide
[281]
to transfer five thousand dollars into
[284]
your new checking account this is your
[286]
initial investment if we would double
[288]
entry accounting you call this owner's
[290]
equity but we aren't so we won't a few
[293]
days later you decide to buy a laptop
[295]
from the Apple Store this is what you're
[297]
going to write all of your fanfiction on
[299]
you cough up a whole two thousand
[301]
dollars on the spot and enter it into
[303]
your cash ledger next you want to set up
[305]
a website so you pay thirty five dollars
[308]
to register a domain online and a
[310]
further one hundred dollars in hosting
[312]
fees you complete your ebook in record
[314]
time and within a couple of days you put
[317]
up your first ad the ad clearly works
[319]
because two days later you make your
[321]
first sales over the next two weeks you
[324]
incur some bank fees make some more
[326]
sales and decide to buy a swish new
[328]
office chair so you can write a home in
[330]
comfort
[331]
JK growling closes out the month with
[333]
two thousand eight hundred and forty
[336]
three dollars in the bank and has made a
[338]
loss of two thousand one hundred and
[340]
fifty seven dollars we can find that by
[342]
taking the total of all of your income
[345]
and expenses for the month ignoring the
[347]
initial investment because that doesn't
[349]
fit into either category great so we can
[351]
easily calculate your business's profit
[353]
and cash is being closely monitored but
[356]
on closer inspection this template just
[358]
looks like a copy of your bank statement
[360]
if only there was a way to get some more
[362]
detail then this will become really
[364]
valuable to us and that is where the
[366]
multi column approach comes in the multi
[369]
column ledger works in a very similar
[371]
way to the three column ledger we still
[373]
have the three columns for date
[375]
description and amount but in the middle
[378]
we packed in some extra detail the first
[381]
thing to note is that we now have a
[382]
reference column this is essential for
[384]
any organized bookkeeping system in this
[387]
column we give each transaction a unique
[390]
reference number to help us identify it
[392]
and if you're really savvy you can say
[394]
back
[395]
support each transaction in your Google
[398]
Drive with a naming system that
[399]
corresponds with these unique reference
[401]
numbers that way you can easily find and
[404]
pull out the invoice for your office
[406]
chair if you need it
[406]
because everything is cross-referenced
[409]
moving on to the right we have grouped
[411]
the columns into two main categories
[413]
cash in and cash out this allows us to
[416]
categorize all of our income and
[419]
expenses into their own distinct columns
[421]
this will be a big help when tax time
[423]
comes around because it makes it easy to
[425]
identify all of JK Rowling's taxable
[428]
income and deductible expenses now we're
[431]
talking
[432]
you can set up one of these templates
[433]
for yourself by copying this layout or
[436]
if you'd like to save some time you can
[437]
use this one for free and get started
[439]
right away I'll drop a link to it down
[441]
in the description below just delete the
[443]
sample data and you can get cracking one
[446]
important thing to note you will need to
[448]
check the transactions in this template
[450]
against the ones in your bank statement
[451]
each month to make sure that none are
[453]
missing this is called doing a bank rec
[455]
and it's critical because an incomplete
[457]
cash ledger isn't much used to anyone
[460]
I've made a video explaining how to do a
[461]
bank reconciliation and you can find up
[463]
here in the corner so that's how to
[466]
start bookkeeping for your small
[468]
business the quick and dirty way this
[470]
works great if you have minimal
[472]
transactions because it's fast and easy
[474]
to maintain
[474]
very little accounting knowledge is
[476]
required so you might be able to get
[478]
away without having to hire a qualified
[479]
accountant or bookkeeper hold up that
[482]
been said this system does have its
[484]
flaws it's the quick and dirty method
[486]
after all it's not for everyone
[487]
the double-entry accounting system is
[489]
one of the greatest discoveries of the
[491]
past 600 years because there are two
[493]
sides to every financial transaction
[495]
this single entry accounting system only
[497]
recognizes one of these sides so it
[499]
gives you an incomplete picture of your
[501]
business's books you're also cash
[503]
accounting so you'll be exposed to all
[505]
of the disadvantages of that method
[506]
things like fluctuating profits caused
[509]
by recognizing related income and
[511]
expenses in separate accounting periods
[513]
more on that in this video
[515]
another problem with cash accounting is
[517]
that you have no idea what your
[519]
business's financial position is which
[521]
is not ideal if your business buys or
[523]
sells on account with credit times
[525]
because you won't be tracking your
[527]
counts receivable and accounts payable
[529]
so if that's the case then what's the
[531]
point
[531]
this single entry accounting method is a
[534]
great place to start for anyone who runs
[536]
a small business with few transactions
[539]
and little to no assets or liabilities
[541]
especially if you don't have a
[543]
bookkeeping system in place yet this
[545]
technique will help you get your books
[547]
in order many small businesses are using
[549]
a variation of this right now
[551]
however double entry accounting is the
[553]
king of all accounting systems it's a
[556]
much tighter method with built-in checks
[558]
that leave less space for errors it also
[560]
gives you a complete record of your
[562]
financial transactions there's a reason
[564]
why all large businesses use double
[566]
entry accounting so I would seriously
[568]
consider upgrading to it at some point
[570]
the good news is that a single entry
[572]
accounting record can be transferred
[574]
into a double entry accounting system at
[576]
any time and if you've got things
[578]
organized using a templates like the one
[579]
I've linked below then it will make the
[581]
whole process a lot less stressful these
[584]
days double entry accounting is becoming
[586]
more and more accessible to everyone
[588]
there are a whole bunch of cloud
[589]
accounting software packages out there
[591]
that do all of the double entries for
[593]
you so you don't even have to think
[594]
about them a couple of the biggest names
[596]
are QuickBooks Online and zero I'll link
[599]
to a free trial of QuickBooks Online
[601]
down in the description and here's a
[603]
video that I made that will give you a
[604]
general overview of how it works if
[606]
you'd like to learn more about
[607]
double-entry accounting I made a whole
[609]
playlist covering accounting basics for
[611]
beginners that you can find here any
[613]
questions let me know down below in the
[614]
comments and you can subscribe to
[615]
accounting start by clicking on this
[617]
circle for more weekly videos