Great video and explanation

Thank you, Rachael, for this video! Really, as a senior citizen it was one I could follow, it gives me what I need, simply enough, and although I had to figure it out on Excel, I’m still grateful for the setup. You are a great teacher. Wish you’d carried on with these, but I know how hard it is as I’m trying to keep up with my own channel. Thanks again.

For anyone wanting to follow this but convert to Excel, here’s what worked for this newbie. When I saw this video was 2 yrs old, I wondered if it would still work for me… esp as I converted her free Google sheets file to Excel, as that is my preference. (I am new to this, can’t afford a bookkeeper, Quickbooks etc, and am trying a new online income source just to survive.) The Excel set up is already different at the first stage is … data validation. After an hour of struggling, and looking at the formula in the free converted sheet from Google Sheets, I realised I needed the cell range of the categories that she cut and paste into her data validation step. I went to the P & L sheet and first typed those and set it up, in the way I wanted them. Then on the Transactions sheet the data validation setting in Excel takes those cell numbers. Bingo. First hurdle conquered. The next hurdle was the sumif formula. I tried for a l o o o n g time, but all I got was error messages. Tried reading MS help pages, it’s all Greek to me. Then I realized that Excel actually walks you through that formula, by highlighting the part you’re working on. And it LOOKS the same, so I was really confused! But by pure good fortune, I happened to notice that (because I clicked on it while typing the formula) it put the name of the Transactions sheet into SINGLE INVERTED (‘sheetname’) commas! Bang, it worked. I typed =sumif into each cell and copied the code each time, changing the name of the category in the string. Donkey work, but hey, it was working, and I was not about to try something different at that stage. 😅 Later, I realised I’d omitted a category… when I inserted a row into the range on the P & L sheet and added the category, Excel auto fixed the validation data on the Transactions sheet.

Finally, someone said it The real truth about business.

All I’ll say is thank you for this video! I’m new to learning bookkeeping and I’d like to step into it and run my own business doing it. But I won’t lie, I often feel like it’ll be too difficult for me, but because you made this video showing what quickbooks does, my worries are a lot lesser now.

Great. Thank you so much for sharing. This is exactly I was looking for. Just wanted to check one thing, if we record any transaction in 'Your Account ' option for practice, Can these transactions be deleted later if I want?

Great video suggested coding change that picks up the profit and loss name automatically =sumif(Transactions!D$2:D$100,A10,Transactions!C$2:C$100)

This is really good, I am currently studying to be a bookkeeper + Payroll advisor and surprisingly enjoying it, but its this type of content I needed to find, bc how do we enjoy it all, but then need to take testing and what to know before you get there, right? BC Intuit has a way of asking you questions in a different way, but applies to the topic in several different ways, so if you misstep you could get it wrong even thought you know the answer on HOW you learned it the the training. We all need a hands-on approach to learning QBO, there are tons of lessons on how to do it, but ACTUALLY doing it with no clients can be a bit of a tricky thing. So this video is great to put us in the mindset of what to expect - at the very least... YOu can usually take to clients very intelligently, but putting the skills into ACTION is the next step we need to fail and learn from so we get it right.

Thank you! This was easy to follow and helped simplify bookkeeping. Other videos made the process feel super complicated and confusing, and you were so clear. Thank you, again. I appreciate you!

Thanks!

Perfect and so simple! Thank You so much for the info

Remember the only time you failed is when you stop

Great video! Clear and to the point. I just did a Skill Success class and your video was extremely better. Thanks! Can't wait to watch your other videos.

This was so helpful!! Thank you!

F.A.I.L = First Attempt In Learning

Thanks i learn lot of thing

I like to put my P/L chart beside my Transactions chart on the same sheet.. Great tutorial

Thank you

so helpful! thank you

Really struggled doing this in excel as it is dirrerent to google sheets. Especially when pulling the totals to the expenses sumary. When i got the formula right i struggled to copy it to the next line as the column range changes.What am i doing wrong ?

thanks it is the best informative vid for bookkeepers kep it it up plz ❤

wow really the help i vet is un speacklable ❤❤❤❤

Hi, while creating a free accountant account ( you were right about being repetitive) , I can not get past firm post code, it keeps rejecting. Please tell me how do isolve this issue as I am from Pakistan?

Typical woman

Starting out a small business I can't affort bookkeeping services but I needed to understand what to do. Rachel Brown is a natural at teaching. I'm disappointed she isn't posting video any more but forever grateful for what she did.

ask anyone who works OUTSIDE in Summertime, about what "exhausting" REALLY means! :-) heyyy...it gets BETTER!! buona fortuna...

wonderful tutorial, and thank you so much, but seriously, an accountant should know the difference between 1,400 (fourteen hundred) and 14,000 (fourteen thousand) LOL But I totally think this is a GREAT tool for someone without an MBA to keep simple books!!!

I finally sat through my first excel video tutorial. This was done very nicely.

Thank you Sister, This lesson was useful, and I loved your way of teaching. You really amazing.❤❤❤

thank you, this was great

You charge clients by the hour- what are your thoughts about a flat monthly fee

Here's what starting up new is like: 1) you're at the Grand Canyon - on solid ground. Everything is familiar: what you're doing, why, and what the next day looks like 2) there is a walkway across the canyon; you step onto it. You walk halfway across (don't look down) 3) the park workers start working on the step-on point of the walkway, and the step-off point 4) you are now on 100% unfamiliar ground: - what does tomorrow look like? - why on earth did I step onto the platform? - I'm in a situation that is 100% not familiar What you learn is something everyone has: "creature of habit" of daily behaviors on autopilot. Turn off the autopilot and attain the 'stranded' feeling out in the middle of the canyon, on the 'no-longer-connected' walkway and very much of life is new. Most of us, if we're going to introduce new stuff, do it incrementally. Too much change is a PITA (this is why moving has the sort of 'unhappy' or 'unappreciated' vibe). So, there is something called 'grit' where you're out on the walkway, and you say "fine, I have faith the workers will finish and re-connect the walkway to solid ground again at both ends and until then, I'm staying busy with new stuff" The magnitude of 'grit' you need probably varies depending on how big an effort. I just read the story of Tito Beveridge, founder of "Tito's Vodka". In 1997 with no business degree, and a background as geophysicist and mortgage broker jobs, and zero distillery know-how, he taught himself how to make vodka. His networth in 2024 is *_six billion dollars_* I know what kind of suffering and wondering and anxiety about the future this dude went through. Talk about a bunch of shortcomings. "I don't know how to make vodka, I don't know anything about business, let me teach myself to make vodka and sell it" I don't know about you, but I have an endless tape recording "is my income consistent to pay for everything" that puts a check on 'grit.' But I still did it. I haven't had a corporate job in over 20 years, and have done well. But wow, not easy. The 'grit' part can be learned. The article I read is "Bert Beveridge" in Forbes, and the date at the top of the article says Bert Beveridge $6.2B Real Time Net Worth as of 6/6/24 #489 in the world today I think you just have to do it and have faith the workers will re-attach the walkway. .

🎉❤

Soooo, you failed because you you were no longer beat?

Always learning something new.the drop down is a wonderful idea 💡 and summation of the items in a different sheet

Thank you so much for posting this. As a farmer I need something simple to use and can't afford a full Bookkeeper until things are in full swing at our farm. We have spent thousands of dollars on expensive bookkeeping when we were barely making a penny. This system has helped us immensely. Thank you again for posting this. Looking forward to watching the rest of your videos.

wonderful class.

I know this is an old video but I have a question that I hope doesn't sound too dumb lol. When you were looking at the receipts, how are you able to tell what everything is?? I've looked at my own personal receipts and still couldn't figure out what some of the abbreviations meant 😂 obviously if it's from a grocery store or some place specific like that, you have a better idea. But if it's some place like Walmart, it could be anything.

Thank you so much for this!! Can’t wait to watch more! Great info!

TLDR: Using free tools like Google Sheets and Excel, business owners can create visually pleasing and easy-to-read bookkeeping templates to accurately categorize and track expenses, ensuring proper deduction and efficient bookkeeping. 00:00 🌿 Use free tools like Google Sheets for simple and effective bookkeeping, with separate sheets for each month or one sheet with categorized transactions. 03:24 🌿 Create a visually pleasing and easy-to-read bookkeeping template with columns for transaction description, date, amount, and transaction type, using data validation in Google Sheets to categorize transactions according to IRS regulations. 05:43 🌿 Create a list of tax categories for transactions, paste it into a cell, and save it to use as a drop-down list for categorizing transactions, ensuring accurate receipt categorization for proper expense deduction in bookkeeping. 08:44 🌿 The speaker shows how to use Excel and Google Sheets for bookkeeping, including inputting transactions and using basic formulas, with a tip on tax-deductible expenses for business owners. 12:32 🌿 Use a simple bookkeeping template to categorize and track business expenses and profits without going back and forth between different sheets. 14:37 🌿 Bookkeeping involves using the "sum if" function to add numbers together only if certain conditions are met, by looking for specific words in cells and then adding together the corresponding values in another sheet. 16:53 🌿 Use a simple formula to track expenses by category in a profit and loss statement, including bank charges, interest, and insurance, and create a template to automate bookkeeping tasks. 20:24 🌿 Use the free template to quickly categorize transactions and make changes without going back to the original sheet.

Hoping to escape from QB and simplify - great video - short and to the point - thank you so much

THANK YOU FOR THE TEMPLATE I TRULY APPRECIATE IT 💗💗💗

Thank you so much for this video. Super helpful and well-presented. Your time and effort is most appreciated!

super helpful! i learned something new AND cleaned up my companys books!

Thank you realistic book keeping For including excel worksheet

Be cautious when using rules. Some say don't use.

Random question: By chance, did your husband have his business back in 2020 and 2021 when you was doing his books?

Rachel, are you still a bookkeeper ?

Hi Rachel, Will you be making more videos for bookkeepers???

Thank you