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!
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 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?
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.
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!
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. 🙏
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?
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.
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.
Thank you. If you downloaded the link you might have to press it several times for it to show up. Am I able to add an option for supplies or just use other? If I need to use this all year is it best to create a new download for each month or just keep adding the dates for the entire year on one spreadsheet?
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
What category would you put courses/classes/education under? Also if there's a monthly subscription I also use for education, would it go under the same category? Thanks!
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?
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?
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!
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?
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
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?
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.
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!
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!
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.
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!!!
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).
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?
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.
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!
![Make Money Selling DIGITAL PRODUCTS [Getting Started Guide]](http://i.ytimg.com/vi/yrHZsyGmzM0/mqdefault.jpg)
![Make Money Selling DIGITAL PRODUCTS [Getting Started Guide]](/img/tr.png)
![The Ultimate Guide to Marketing Your Small Business [2024]](/img/n.gif)
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!
Nice Excel sample!
i keep subscibing with two different emails and i never got the spreadsheet. can you help me get it
can't download it
LINK FOR FREE TEMPLATE SAYS NOT WORKING
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.
congrats on your first sale!! Glad this came at the right time!
@@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?
Thank you, my teacher, my relationship with his best financial options hhh
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.
So glad it was helpful!
Thanks!
Love how concise and straight to the point this video was!! Thank you SO much
Thank you! ❤️
This was a very useful resource for you to create and share. Thank you so much!
Glad it was helpful!
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!
Thank you. You are my hero. It is so difficult to find a great template online these days
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. 🙏
So glad you're here, Tina! ❤️
I love you!!! Thank you for saving my life today...what a gem to share your knowledge....Thank you!!!!!
You are so welcome! Thanks for being here!
great sheet! how do you enter mileage and convert that into dollar amount?
Thank you so much! I started a custom cookie business this year and this is perfect for my bookkeeping.
Glad it was helpful! And congrats on your new business!
You always give so much value, Gillian
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?
You’re amazing thank you will try it tomorrow at work
Thank you for those video. Perfect timing 😊
Ah, love it when that happens! Thanks for letting me know!
Thanks for the free template!!! This has made my life so much more easier.
Great to hear! ❤️
Great video! just what I needed. Thanks!
Another awesome video and excellent software tools Gillian. Love 🥰 the video and love 💞 Gillian.
Thanks so much! Glad you like it!
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.
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.
Thank you for the spreadsheet and video. I want to add an Expense category for "Depreciation" (Schedule C, Part II, item #13). How would I do that?
Great Video, thank you. Would I open one sheet per month or per financial year, thank you
Thank you for sharing. Love your stuff.
Thank you. If you downloaded the link you might have to press it several times for it to show up.
Am I able to add an option for supplies or just use other?
If I need to use this all year is it best to create a new download for each month or just keep adding the dates for the entire year on one spreadsheet?
Thank you so much for this video. It was very helpful.
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
Surprised you have no volume column. my daughter has tons of plants, just noticed your really going green. Thank you!
What category would you put courses/classes/education under? Also if there's a monthly subscription I also use for education, would it go under the same category? Thanks!
Thank you! So valuable!!🥰
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?
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?
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!
You are a life saver !!! 😘 Thank you !!
at 245. The catagories that the irs requires. Do these match up to the schedule c input lines?
Love your video !
Thank you so much for the template but for some reason I can not select a category as it does not want to open.
I downloaded the spreadsheet and its very simple and straightforward. My only question would be: How do I separate Months?
Thank you Gillian. How to change the the currency from dollars to other ? I mean the symbol , because I am not dealing with dollars.
found that one already
Thank you for sharing your valuable information ;it's really helpful
Glad it was helpful!
Thank you so much❤
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?
perfect solution for my bookkeeping nightmare.
Great! Glad I could help!
Thanks Gillian.
That may be an easy web app.
It is!
How do you keep track of it monthly tho since this will continue to add up every month
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?
Good catch! I fixed it, and it will work now if you make a new copy of the Google Sheet. Thank you!
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
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?
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?
Thank you so much!
You're welcome! Thanks for being here!
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.
You could definitely add that! Great idea!
@@gillianzperkins Too bad I don’t know how! 🤣 But yeah, good idea.
Love this!
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!
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!
Thanks for the content. The download link does not work. Could you please resend it to me?
Just curious as to why paying for web design would fall under subcontractor and not advertising?
i did not get the template. when will it be sent? or is it something else we have to do to get it.
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.
Hi Henry, please email contact@gillianperkins.com for an excel version. Sorry about that!
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!!!
Aggregate them into single transaction.
how would you categorize materials for something like a carpentry job in this spreadsheet?
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).
Tanks!
I thought that the vendor was also required to log when making purchases?
i can download the spreadsheets for free please can i have the Link
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?
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.
Nice video ❤
Glad you liked it!
I inputed my email and I did not receive a link to your template. bummer
outstanding
I dont understand how this works for a monthly statement? do we make a new sheet for every month?
Yep, you can do that and just name the new tab with the name of the month. :)
Please tell me your proble , i will solve it
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!
GILLIAN YOU TALK ABOUT FORMULAS GENERATED ON THE SHEET BUT YOU DONT DO THE STEPS TO SHOW US HOW YOU DID FORMULAS
You can download my Google sheet to get them all -- you don't need to enter the formulas yourself. :)
really you were married at this recording you are not look like
Not funny :)
Unable to open document 🫤
Please tell me your proble , i will solve it
Downloaded mine, thank you.
Just one question - can I change the $ to the £ sign instead?
Yes, definitely!