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 you are a saint! Thank you so much for this! OMG! I’ve been looking for this all my life, especially being a new business owner, I cannot afford all of the expensive software. Thanks again❤
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. 🙏
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
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?
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?
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.
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?
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.
The Expense - sales is misisng from the profit/loss sheet, how do I add it? You only showed us how to edit existing categories but not how to add new ones.
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?
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!
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
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!
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 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!!!
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.
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!
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.
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, 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).
![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)
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
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!
Gillian you are a saint! Thank you so much for this! OMG! I’ve been looking for this all my life, especially being a new business owner, I cannot afford all of the expensive software. Thanks again❤
Thanks!
Love how concise and straight to the point this video was!! Thank you SO much
Thank you! ❤️
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!
This was a very useful resource for you to create and share. Thank you so much!
Glad it was helpful!
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! ❤️
You always give so much value, Gillian
Another awesome video and excellent software tools Gillian. Love 🥰 the video and love 💞 Gillian.
Thanks so much! Glad you like it!
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!
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!
Thanks for the free template!!! This has made my life so much more easier.
Great to hear! ❤️
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!
Great video! just what I needed. Thanks!
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
Thank you for sharing. Love your stuff.
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?
great sheet! how do you enter mileage and convert that into dollar amount?
Thank you so much for this video. It was very helpful.
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?
Great Video, thank you. Would I open one sheet per month or per financial year, thank you
You are a life saver !!! 😘 Thank you !!
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.
Surprised you have no volume column. my daughter has tons of plants, just noticed your really going green. Thank you!
Thank you! So valuable!!🥰
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?
Nice video.
Thank you so much❤
Love your video !
Thank you for sharing your valuable information ;it's really helpful
Glad it was helpful!
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?
Tanks!
Thank you so much!
You're welcome! Thanks for being here!
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?
Love this!
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?
Thank you so much for the template but for some reason I can not select a category as it does not want to open.
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.
The Expense - sales is misisng from the profit/loss sheet, how do I add it? You only showed us how to edit existing categories but not how to add new ones.
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?
Good catch! I fixed it, and it will work now if you make a new copy of the Google Sheet. 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!
Thanks Gillian.
That may be an easy web app.
It is!
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
*Does this TEMPLATE exist for WINDOWS EXCELL? I have version 10*
perfect solution for my bookkeeping nightmare.
Great! Glad I could help!
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
I downloaded the spreadsheet and its very simple and straightforward. My only question would be: How do I separate Months?
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!
How do you keep track of it monthly tho since this will continue to add up every month
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?
i did not get the template. when will it be sent? or is it something else we have to do to get it.
Thanks for the content. The download link does not work. Could you please resend it to me?
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.
at 245. The catagories that the irs requires. Do these match up to the schedule c input lines?
outstanding
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!
Just curious as to why paying for web design would fall under subcontractor and not advertising?
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!
I inputed my email and I did not receive a link to your template. bummer
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!
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?
I thought that the vendor was also required to log when making purchases?
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).
i can download the spreadsheets for free please can i have the Link
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
*Its very difficult to see your screen, its so washed out!*
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. :)
Not funny :)
really you were married at this recording you are not look like
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!