Profit & Loss Statement in Google Sheets in Under 15 minutes! Tutorial & Free Template

Here's a quick tutorial on how to take some basic monthly numbers and turn it into a profit & loss statement.

[MotherSisterFriend_Doula]

Small business owner here-- THANK YOU SO MUCH! I never learned to use excel and this just made my life soooo much easier.

[arragsda]

my husband started his own business at the beginning of the year and i researched excel tutorials as an alternative for quickbooks. this was INSANELY helpful and was just what i needed. i’m not sure why people said you were too fast since you can easily adjust the speed settings. thank you thank you thank you for sharing your knowledge.

[cecesaur]

This is the best video I have ever watched for anything bookkeeping related. Thank you💗💗💗

[debbieshay]

Template setup starts at 1:08. P&L training starts at 5:00.

[YeseniaEstrellaDeAnda]

Thank you so much for the explanation & spreadsheet!

[vgrosario]

Thanks Man. You really are a spreadsheet ninja!

[louietoltolvlog]

I’m sorry 😂 I’m doing accounting at work but 😢
We are a bbq restaurant
Sep sales $500k including sales tax(10%)
Cogs (food purchase) $100k
Payroll $90k
Rent $15000
Utilities $5000
Insurance $3000
Other operating cost $30k
Paid sales tax $20k (I don’t know why our cpa paid $20k not $50k since 10% sales tax, but anyway)

If I all deduct from revenue, is it our net?

My question is should I include a tab for paid sales tax to deduct as an expense?

Thank you and sorry for no knowledge 😅

[nassirraheim-bracey]

Very Easy to follow. thank you so much for this!

[xiinomadia]

Why make the template only available in PDF? Isn't supposed to be an XLSX file for editing in excel? Love what you did here but not sure how to get it done that fast and was hoping to just input my data in the template.

[louietoltolvlog]

I’m going to make this at work tomorrow. I think this simple way is better.
So gross revenue means gross sales including sales taxes? And cogs means purchase to resale. Right?
We have a restaurant so

[shahnazfuad]

Thank you so much! I was able to get it done!

[stoviinkcreatives]

Your sheets are fantastic! I had to keep rewinding because you're so fast! LOL! BUT! I got it done. Thank you so much! Thumbs up for being so nice with it though! :)

[sandrahelenna]

Why i can not put the month on the x axis?

[mahmoudkaram]

Hi thanks for your sheet, but i have question plz. Should we put the COGS that means ( First inventory + purchases. - End of Inventory)

[Soothing_Sounds_Studios]

Hi @sheetsninja, I greatly appreciate your video, it's been incredibly helpful! I have a question: when I attempt to add the labels for the months to the graph at the very end, clicking on Tt C6:06 doesn't yield any action. Could you please provide some guidance on how to make it identify or select it correctly?

[Drup]

@sheets ninja any possibility of you making what you created a downloadable templet?? your mouse movements were way too quick to follow sadly. it would be much appreciated !

[arragsda]

@SheetsNinja would it be easy to incorporate mileage? i know i need to add it in the settings tab, but what do i do from there? is there a simple way to add mileage each month and automatically multiply that number by 65.5 cents per mile?

[kermitgriffin]

How can I apply a 30% reduction formula to each cell without doing it individually?

[uinvestinu]

🙈😂😂😂😂 speed of him is unreal. Stopped watching after he made the box🙄

[jovialthinker]

Would have been better slowed down a bit. 😢