Bookkeeping Basics for Small Business Owners (free template!)

[@gillianzperkins]

Here's the link to download the spreadsheet for free ❤ gillianperkins.com/ssbs/ and the link to give Melio a try: go.melio.com/gillian. Hope you find these resources helpful!

[@Roberto4ever]

Nice Excel sample!

[@xi500]

i keep subscibing with two different emails and i never got the spreadsheet. can you help me get it

[@gentlemove]

can't download it

[@angelinaflores1071]

LINK FOR FREE TEMPLATE SAYS NOT WORKING

[@accountsbalance]

Thank you for the free template! You make bookkeeping easier to follow and understand. I agree that new business owners should be hands on with their books to really understand and keep of their finances.

[@gillianzperkins]

So glad it was helpful!

[@Race1986]

Thanks!

[@JointerMark]

Thank you Gillian. I made my first sale the other day and have been thinking of a way to keep track of my business transactions. Thank you for the template.

[@gillianzperkins]

congrats on your first sale!! Glad this came at the right time!

[@JointerMark]

@@gillianzperkins I used the link you provided but it doesn't seem to actually provide the template. Once I get your response email I am not able to open the sheet? I must not be doing it properly?

[@عبداللهاليافعي-خ6خ1ح]

Thank you, my teacher, my relationship with his best financial options hhh

[@thyalyssatran]

Love how concise and straight to the point this video was!! Thank you SO much

[@gillianzperkins]

Thank you! ❤️

[@Divergentpaths]

This was a very useful resource for you to create and share. Thank you so much!

[@gillianzperkins]

Glad it was helpful!

[@louismenjivar5171]

You’re amazing thank you will try it tomorrow at work

[@louiseyvette2261]

You always give so much value, Gillian

[@IndependentElectric]

Thank you. You are my hero. It is so difficult to find a great template online these days

[@Spedhomeschoolcoach]

I love you!!! Thank you for saving my life today...what a gem to share your knowledge....Thank you!!!!!

[@gillianzperkins]

You are so welcome! Thanks for being here!

[@ayniletourneau]

Great video! just what I needed. Thanks!

[@federalwayhomebuyer2676]

Thank you for sharing. Love your stuff.

[@awriterscorner1986]

Gillian, could you make a video on tax preparation/expectations for small businesses? As well as ways in which small businesses can earn their keep rather than lose it all to the IRS? Many youtubers don't talk about this aspect, and I'm curious about what to expect once my business picks up. (Plus, I just watched a video on the new IRS $600 rule that is to affect the 2023 tax year.) Thanks!

[@ThatMomWithALaser]

This was super helpful! Is there a way to share the expense page and not the income page? For example, let’s say you have an employee purchasing supplies for the company. Can that employee input the expenses and not have access to the income earned sheet?

[@overbeefineart2974]

Thank you so much! I started a custom cookie business this year and this is perfect for my bookkeeping.

[@gillianzperkins]

Glad it was helpful! And congrats on your new business!

[@RegalT.Cameron]

Thanks for the free template!!! This has made my life so much more easier.

[@gillianzperkins]

Great to hear! ❤️

[@davidthescottishvegan]

Another awesome video and excellent software tools Gillian. Love 🥰 the video and love 💞 Gillian.

[@gillianzperkins]

Thanks so much! Glad you like it!

[@Hidetannerslife]

Thank you for those video. Perfect timing 😊

[@gillianzperkins]

Ah, love it when that happens! Thanks for letting me know!

[@desTINAsyonPH]

I'm literally, watching every video and listening to free podcast as I start my business about work opportunities for mothers. I know that I'm in the right place knowing that you are a fellow Christian. :) Thanks for this Gillian and may God bless you more. 🙏

[@gillianzperkins]

So glad you're here, Tina! ❤️

[@dedysetiadi2851]

great sheet! how do you enter mileage and convert that into dollar amount?

[@RafatMarufDM]

Thank you so much Gillian for keeping this video precise to the point and also giving us a freebie template. I've just recently discovered your channel, and as a Digital Marketer myself who is more on the SEO side than SMM, I am learning a lot from you. You're an excellent mentor. Take Care Rafat

[@mademesmile0950]

Thank you so much for this video. It was very helpful.

[@tumentoraivonluna]

Great Video, thank you. Would I open one sheet per month or per financial year, thank you

[@CreationsByShubha]

You are a life saver !!! 😘 Thank you !!

[@cornelyaekberg9107]

Thank you! So valuable!!🥰

[@wonderfulwinnie]

Love your video !

[@brandonweir7082]

Hi thank you for this it really helps. I just want to ask though, when I add my own categories in the Transactions section, how do I get them to appear on the Income Statement? Thank you.

[@lindseyloo6619]

Thank you so much❤

[@jayb1182]

Thank your for the spreadsheet. However, I am unable to update the spreadsheet as demonstrated in the video (9 minutes 30 seconds into the video). I click on the down arrow as mentioned but there is no edit pencil and no drop down criteria window opening up on the side. Can you clarify as to what may be happening? thank you.

[@liedobacelar6685]

Tanks!

[@andredobbs5390]

Love this!

[@LEARN_WORLD7280]

Thank you for sharing your valuable information ;it's really helpful

[@gillianzperkins]

Glad it was helpful!

[@horse_chick]

Thank you so much!

[@gillianzperkins]

You're welcome! Thanks for being here!

[@frang8750]

Surprised you have no volume column. my daughter has tons of plants, just noticed your really going green. Thank you!

[@TheJoyfilledCreative]

This is great! How would I track sales tax for things I've sold? IS there a separate template for that? I work as an artist who both licenses her work (royalties) and sells direct to customers. HOw can I use this sheet properly to account for these things?

[@DryBonesandCompany]

Hi, I really love this spreadsheet but I haven't been able to learn how to add a new category and have it appear on the balances sheet. I Would you be able to tell me how to do that or drop a video to someone who has taught that concept?

[@rubys_trinkets]

Same here, I find just adding a new category doesn't seem to work like the pre-made categories. Hoping this question gets answered, I love this spreadsheet!

[@TimArmstrongmarketing]

perfect solution for my bookkeeping nightmare.

[@gillianzperkins]

Great! Glad I could help!

[@scotttovey]

Thanks Gillian. That may be an easy web app.

[@gillianzperkins]

It is!

[@mohammedmahmood143]

outstanding

[@Mady300]

Nice one. Do we have to keep all the receipts and invoices for IRS in case we get in audit.? Or just bookkeeping is enough?

[@walleyehunter888]

Thank you so much for the template but for some reason I can not select a category as it does not want to open.

[@brendatomlinson]

Great, simple, straightforward presentation. You’re a great communicator. I’m so glad I found you. QUICK QUESTION! Can you enter mileage on this sheet? I’m guessing I’d have to add a formula to calculate cost per mile? Appreciate your input.

[@gillianzperkins]

You could definitely add that! Great idea!

[@brendatomlinson]

@@gillianzperkins Too bad I don’t know how! 🤣 But yeah, good idea.

[@InnaCosmos]

Hi Gillian, I run a marketing agency, and my packages really differ. Do you recommend my income categories to be by name of the client (since I do a mix of services for all so far) or by actual service/package? Thanks!

[@gillianzperkins]

Great question! I'd organize your categories just by the different types of services you offer. Or, if most of your packages are a blend of different marketing services, then you could just have one product category that's "marketing services" or "marketing consulting." Hope that helps!

[@AvinashSingh-vj3rk]

Nice video ❤

[@gillianzperkins]

Glad you liked it!

[@TiaCSmith-cb4ot]

i did not get the template. when will it be sent? or is it something else we have to do to get it.

[@Hairextensionsbydenise]

at 245. The catagories that the irs requires. Do these match up to the schedule c input lines?

[@CassondraWeverka]

How do you keep track of it monthly tho since this will continue to add up every month

[@itstiaunique9378]

Hello just downloaded your template love it so far but for some reason in the income statement, the profit and loss is only adding the totals is not showing the accurate number even though I’m putting a negative sign in front of expenses… am I doing something wrong?

[@gillianzperkins]

Good catch! I fixed it, and it will work now if you make a new copy of the Google Sheet. Thank you!

[@SpringfieldLARealtor]

This form is being shared with google and then they store all your private financial information. Do you have a form that is not shared with google?

[@shaunherring8609]

I’m in construction. I need to track specific jobs profit/loss. Some expenses are split between different jobs. Example; materials purchased in bulk but utilized for different jobs. Can I use your spreadsheet to use in my situation?

[@AudreyGlover-to9zo]

I received you program but my categories transaction and income statement are not talking with each other. There is nothing that comes up on the drop down box. Thank you for your help

[@tomvega4287]

I downloaded the spreadsheet and its very simple and straightforward. My only question would be: How do I separate Months?

[@touceo]

Thanks for the content. The download link does not work. Could you please resend it to me?

[@yeseniaherrera7763]

Thank you for the video! very helpful. As a general contractor I buy a lot of material every other day. Anywhere from paint, drywall, lumber and so on.. ect.. How would you recommend track this in the "transactions" tab it would take hours to track all material I buy on a daily basis. PLEASE HELP!!!

[@amaaan9847]

Aggregate them into single transaction.

[@kimfelix2434]

Just curious as to why paying for web design would fall under subcontractor and not advertising?

[@Learning_to_Excel]

Great video Gillian! Particularly like the Profit/Loss instructional segment. We provide Microsoft Excel Tutorial videos that help improves peoples' efficiency and professionalism across the board!

[@nannysclan]

You didn't actually cover all the steps required to change an Expense Category Name. That would be helpful. There are several options that pop up after changing the text to complete the action so all the money gets tabulated and carried over to the Income Statement. Would you please do another video with all the steps required?

[@henrybraun4688]

Thank you for the video. Great information. Just one question. I received the google sheets document and I downloaded the excel version from it but there seems to be a problem with the transactions section. The categories for income and expense don't show up. The other two pages are fine. The google document works fine, but not the excel version. I don't know if anyone else is experiencing this issue? Any suggestions? Thanks.

[@gillianzperkins]

Hi Henry, please email [e-mail] for an excel version. Sorry about that!

[@cherylalmstrom7301]

Hi, This looks easy and interesting. I have sent my email so you can send me the spreadsheet. I am wondering too, if this spreadsheet can be converted to Excel...? I am using Excel, and trying to set up my own bookkeeping system with it, and finding that I need better formulas in order to make things more automated. Hoping your sheet can be converted and if your formulas will still work within that conversion. Thank you.

[@whitney7112]

how would you categorize materials for something like a carpentry job in this spreadsheet?

[@amaaan9847]

Hi, Hope you are doing well. For the materials that are directly attributable to that specific job would be characterized as Cost of Goods Sold (COGS).

[@pandakat915]

I thought that the vendor was also required to log when making purchases?

[@Pennylover2020]

I inputed my email and I did not receive a link to your template. bummer

[@HeatherJoFlores]

I dont understand how this works for a monthly statement? do we make a new sheet for every month?

[@gillianzperkins]

Yep, you can do that and just name the new tab with the name of the month. :)

[@alhasibtarun3425]

Please tell me your proble , i will solve it

[@alickjimmy2505]

i can download the spreadsheets for free please can i have the Link

[@angelinaflores1071]

GILLIAN YOU TALK ABOUT FORMULAS GENERATED ON THE SHEET BUT YOU DONT DO THE STEPS TO SHOW US HOW YOU DID FORMULAS

[@gillianzperkins]

You can download my Google sheet to get them all -- you don't need to enter the formulas yourself. :)

[@AzherSiddiquiwithQuran]

really you were married at this recording you are not look like

[@theredkingvlog2]

Not funny :)

[@autumncameron8798]

Unable to open document 🫤

[@alhasibtarun3425]

Please tell me your proble , i will solve it

[@Harrietswan]

Downloaded mine, thank you. Just one question - can I change the $ to the £ sign instead?

[@gillianzperkins]

Yes, definitely!