The Inventory Genius Podcast
The Inventory Genius Podcast
#244: Can I Do My Own Bookkeeping, Interview with Megan Schmitke
Use Left/Right to seek, Home/End to jump to start or end. Hold shift to jump forward or backward.
Megan Schmitke is a bookkeeping expert who works specifically with inventory-based businesses. Today, Megan and I are talking about what you should do if your business is a mess and you know you need a bookkeeper. How do you clean things up so you can move forward?
Get a FREE MONTH with the Inventory Genius Calculator - https://www.ciarastockeland.com/inventory-genius-calculator
Work with Me - https://www.ciarastockeland.com/work-with-me
Visit the Bookstore - https://www.ciarastockeland.com/bookstore
Sign Up for Free Weekly Tips and Trainings - https://www.ciarastockeland.com/subscribe
Connect with Megan:
Take Megan's Bookkeeping Basics Course (https://www.findingfreedomfinancial.com/bookkeeping-basics-course/)
Book a consultation: https://www.findingfreedomfinancial.com/work-with-me/
Instagram: @findingfreedomfinancial
Free Training: https://www.findingfreedomfinancial.com/masterclass/
If your sales are growing but your cash isn't, let's find out why.
Get the Inventory Genius Operating System: https://ciarastockeland.com/program
Shop the Bookstore: https://www.ciarastockeland.com/bookstore
Sign Up for Free Weekly Tips and Trainings: https://www.ciarastockeland.com/subscribe
Hey friend, do I have something exciting for you? Oh my goodness, you guys, I am so excited because the Inventory Genius Open to Buy calculator is lost. That is right. Easy. At your fingertips, throw a couple numbers in and calculate your monthly open to buy. Or you can do your weekly open to buy, or you can do your annual open to buy. This calculator makes buying so easy. It also includes a calculator so that you can measure and track your inventory turn. So I want to give you a free month to the Inventory Genius calculator. You'll find the link in the show notes. Hey friend, welcome to the Inventory Genius podcast, where we work together here to make you an inventory genius. We talk about profit, we talk about cash flow, and we definitely talk about your paycheck. Because at the end of the day, it's all related to your inventory. Let's go. Well, hello everyone. Welcome to the Inventory Genius podcast. I have Megan here. She is coming back as a second-time guest and she's joined us in the past. I refer a lot of people to her when they come to me and start with me and are looking for a bookkeeper. Um, she works with inventory-based businesses specifically, which is phenomenal. And last time I had her on the show, we were just talking about this. We talked more about like why you need a bookkeeper and what is a good bookkeeper and stuff. But today we're going to talk about what do you do if your business is a mess and you know you need a bookkeeper or you need one and you can't afford one. How do you clean up your mess? So that is what we're talking about. Welcome to the show, Megan. Thank you. It's so good to be back. All right. So you just came off of maternity leave. I know I was flooding your inbox for a couple months with potential clients. Um, so welcome back to the world of small business. Thank you. Yeah. It's all it's like coming back from a vacation. The vacation was amazing, but then your desk is full of projects and your inbox is full.
SPEAKER_00Yes, for sure. I'm finally seeing the light at the end of my tunnel of my inbox. So it that feels like a huge weight off my shoulders already.
SPEAKER_01Oh, I know for sure. Yeah, when your inbox gets cleaned up, I use my inbox as my to-do list. So yeah, just to have it cleaned out of all the junk mail and prioritized is great. I know.
SPEAKER_00It's a goal of mine this year to get down to that inbox zero. I have never been that person, but that is my goal for this year.
SPEAKER_01That is I that's what I do typically on Mondays. It's like clean out because I don't check my email over the weekend. Um, just a tidbit of because I used to like live in my business all the time and never to end on like, nope, not doing that anymore. So I don't check my inbox on the on the weekend. So then Monday I just go through and first clean out all the junk. So then I'm left with relevant and then organize and oh, it's so great. And then I try to have it cleaned up, ready, going into the weekend. Because you know, you get so much stuff, so many emails. I know. I know it's great. Okay, so let's talk about bookkeeping first. Um, for those of you listening that haven't met Megan before, Megan, can you tell us like how did you get into this world of small business bookkeeping?
SPEAKER_00Yes. So I started my journey in the corporate world. I got my bachelor's in accounting, jumped right into being a corporate accountant, which is essentially just being a glorified bookkeeper. Um, but after I started growing my family, after my second kid, um, I was just kind of ready to be done. So I left that position, but I still wanted to use my skills. Um, and honestly, I thought I might go crazy if I just stayed at home and didn't have any adult interactions. So uh decided to start my business and use, you know, my education and my experience to help the smaller business owners. And that's kind of how I started.
SPEAKER_01Okay, I love that. And how did you come into the segment of the industry, small business industry that works with like boutique owners, inventory-based business?
SPEAKER_00Yeah. So when I first started my business, I just kind of helped anybody that needed it because I didn't really know what I liked, what I didn't like. And my second client ever was a uh retail boutique and home decor store. Um and honestly, I just loved it. And I actually took over her books from a different bookkeeper who, I mean, I don't want to say anything bad, but like there's definitely specific nuances in the retail industry that not all bookkeepers understand. So, like, I was even having to clean up some things that were in her books that was done by a bookkeeper. So just kind of like unraveling that puzzle and trying to figure out how it all works, because retail is definitely a puzzle sometimes. Like there's a lot of moving pieces, and that was so much fun for me. So after about a year of working with her, I'm like, I want to pursue more clients that are like this intricate and this detailed and all of that, because it was so much fun for me.
SPEAKER_01That's exciting. I love that. Okay, so yeah, so that's a good point you made, though. You had to unravel and undo some things from a previous bookkeeper. And I want you guys that are listening to know that that is so normal and that is so common. Um, you know, I will get on a consult call with a four million dollar business and look at their books and say, oh, okay, so we are expensing out all the inventory, we're not, you know, amortizing anything, we aren't doing prepaid expenses, we don't know margin, and they have, you know, books that look very beautiful on paper, but are not giving them the results they need. So if you, I just think it's good for people to know that because sometimes we feel guilty as business owners, like, oh, I didn't do the right thing, I didn't ask right questions. But sometimes our service providers don't do a great job for us. Yes, it's unfortunate. But we are here to fix that. So, Megan, a lot of times, the majority of the time someone comes to me, they either have a massive mess that they've never recorded. So they've never had books. Maybe they've been in business for five years, three years, and they've been recording it on spreadsheets at that, right? Never put a sales system, that's it. Um, or they have a bookkeeper they're not happy with. I just talked to someone like two weeks ago. She has not received financials from her bookkeeper since last June. And she is paying monthly. Okay. That's bad. That's yeah. So we come with a lot of things. What should someone think about when they go to someone like you and say, hey, I have a bit of a mess. What do you need first? Like what should I gather? Can this even be fixed? Give us some hope and give us some practical tips. Sure.
SPEAKER_00So one of the first things I always ask is, are your taxes current? Because if you have already filed taxes for, let's say, 2024, we don't necessarily want to go back and clean up any bookkeeping for years that are already filed because unless you plan on amending your taxes. Because we don't want to be changing numbers that tax returns were based off of because then you're kind of losing the data that you made the tax return on. Sure. So if taxes are filed, you don't need to change anything unless you plan on amending your taxes. Okay. If you know they want to amend their taxes because they know they're wrong and they know they're way off, then we might want to clean up a prior year. But typically, if taxes are filed, we just want to start fresh with January 1st that following year and move forward and forget about it.
SPEAKER_01Okay. So that's interesting. So you can look at someone's tax return and that becomes the basis for the file that you're going to build in, let's say, QuickBooks. Exactly. Yep. Okay. And then um, what other things should they start to gather um besides their tax return? Maybe it's already October, you know, so tax return is almost a year old. We've been running for a whole nother month or a year, months and months and a year. What are some other things they could gather for you?
SPEAKER_00Yeah, a lot of the different softwares and banks, they make it really easy because you can actually grant access. It's like read-only, share only access. So we can pull anything, or like a bookkeeper would be able to pull anything that they need. So typically things that are needed are access to your point of sale system. So Shopify, um, Amazon, Fair, whatever you're selling on. Um, that way we can go in there, we can look at all of your sales number, how all of the payments were processed, and we can get all that information we need. And then it would just be like statements or activity from any bank accounts, credit cards, um, any of that type of things that we need. Um most often we don't need receipts. I know that a lot of, you know, business owners, you know, maybe they have a shoebox of receipts, which isn't the greatest way to keep them, but it's a popular option. Yeah. Um, you know, we don't necessarily need to see receipts as long as, you know, you guys have a method of saving them yourself because it is important that you keep them. Oftentimes a bookkeeper just doesn't need to see them.
SPEAKER_01Yeah. Okay. So you can get what you need then off of bank statements. So tax return first, bank statements, credit card statements, and then just getting into the back end of wherever they're selling. And you can put that, so you pull that information and you create a what we call a file for them. And then do you typically start with, okay, so now here's your January financials, here's your February, and you just get them caught up and then stay current, or what does that look like?
SPEAKER_00So we can do things in bulk. So I actually um just started working with a new client probably about a month ago, and we actually did cleanup from January 1st of 2024 to date. So it was about 16 months. And I mean, we caught up everything in the bulk of it was done in two weeks, and then the last week and a half or so was kind of like fine-tuning things, so changing how the reports looked and things like that. So I mean, we don't we don't necessarily go month by month because it's faster to do things in bulk. Um, but yeah, that's just kind of our process, I guess. Other bookkeepers might do it differently, but that's how we do it.
SPEAKER_01Well, and that's what I like about you. You're not trying to draw this out so that you can charge a bunch of money. You're trying to get them to a spot where now we we have a good file and we can keep it clean and simple moving forward. Exactly. Yes. Yeah. I love that. Um, okay, so what about the clients who wish they could just maybe do it themselves? Maybe, maybe either they like that part of their business or they just don't feel like they have the budget. Can someone do their own QuickBooks and do it well? And if so, what are some of those tips to make sure that they stay on top of it?
SPEAKER_00Yes. Um, so yeah, definitely. A lot of people I know maybe don't have the budget to hire a bookkeeper right away. And that's I totally understand that. Like, I mean, when I first started my business, I was doing everything myself just because the budget wasn't there to hire help at all. So I totally get that. But um, I do have just a couple tips to share or like common mistakes I see when people do their own bookkeeping.
SPEAKER_01Yeah.
SPEAKER_00Um, yeah, that as long as you guys avoid these, you're good. Um, so yeah, one that I always see is, you know, you get the deposits into your bank account from Shopify or PayPal or whatever. Um despite what you know, instinct says, that shouldn't be categorized as just like sales revenue. Because really that number is made up of your gross sales, your discounts, any returns, sales tax, shipping income, and the processing fees. So you might have received, you know, a hundred dollar deposit, but really that was $200 in gross sales and a hundred dollar discount. Granted, that's a huge discount, but you know, you kind of get what I'm saying. Um, so really to have the best insights in your financials, you want to break out those deposits into those six different pieces, that how many pieces it was, yeah, to get truly the best insights into your business. And honestly, so you're not overstating or understating your income at tax time.
SPEAKER_01Okay.
SPEAKER_00So that's one of the biggest ones I see. Um, one I know that you mentioned earlier is expensing all of your inventory when you buy it. You know, the true most accurate accounting flow is to, you know, book it as an inventory asset. And then when you sell it, it gets expensed through your cogs. So I know you you're all about that. You teach that. Yeah. Um let's see, what's a third one? Um, probably, I mean, obviously, I understand the importance of like staying on top of your bookkeeping. But so many business owners, like, you know, they say, like, okay, I'm gonna do it, but then it gets to be a month, two months, six months, and they haven't touched it. And then it's this huge project that they keep dreading. So, you know, schedule time. I'm a fan of like money Mondays. So, like every Monday morning, you know, you clean out your inbox and then you focus on your financials for the week, just clearing out all the transactions from the prior week, just so it doesn't become this huge pile of dread that you have sitting in front of you.
SPEAKER_01Yeah. And you know, I used to do that too. I don't do my own books anymore, but when I did a long time for this business and my subscription box business, I did all of them. Um, I did it on Fridays, which I know if you have a retail store, maybe that doesn't work. But I I just found that day. And so when bills would come in or any invoices, even an email, I print them off. I didn't even worry about them, just put them in my pile. And then Friday, and so then it was only like an hour once a week. And then at the end of the month, just quick reconcile. It was so easy. I'd always turn out people make fun, or you know, my clients that follow me and like Emily makes fun of me because I always listen to country music. It was just like my brain had to, you know, get myself a yummy drink, country music, pound through my expenses, and then it's just done. And so I think, yeah, like you said, just find a routine with it, don't put it off because once you're behind by a couple months, you're just gonna push it off even farther. Yeah. Exactly. And that's when mistakes happen and all of the stuff because we're in a hurry. Yeah. Yeah. So you have a course that you offer if people want to learn how to do their own books. What does that course look like? How does it work? Yeah.
SPEAKER_00Um, so it's called Shopify Bookkeeping, made simple. So it's built around uh the Shopify platform. So like I even navigate in Shopify, but I mean the same concepts apply to Square or you know, any other type of point of sale system. Um, but really it's structured to help somebody who has zero bookkeeping, zero QuickBooks experience be able to use QuickBooks online to stay on top of their own bookkeeping. And it's built out so like the very first module is just getting a QuickBooks file set up. Okay. So it's configuring all the settings, it's uploading a retail-specific chart of accounts. Um, because anyone that's used QuickBooks knows that the default one that comes in there, it has like a million different categories that you will never ever use. Yeah. Um so I actually teach my students to like delete that out of there. You don't need it, upload this one, it's way cleaner. Um, and because just you know, a clean and simple chart of accounts is gonna make your reporting that much easier. It's gonna make the whole process so much simpler. Um, so yeah, the whole first module is just building your QuickBooks. And then each of the other modules focuses on a specific aspect. So one of the modules is all about recording your income. So it, you know, throughout the course, it teaches Shopify. So like I navigate in Shopify to find the right reports. So you can get the gross sales, discounts, returns, shipping income, all of those pieces that I broke out, how to actually record all of those in a very quick way. It's not time-intensive at all. It takes me like five minutes for each client a month to do this. Yeah. Um, so one of the modules is all about recording the income. Next module is all about recording the expenses or all of the money that flows out of your business. There's a module all about reconciling. Um, so comparing what's in QuickBooks to your bank statements, your credit card statements, the payment processor statements, which is something that a lot of people miss even when they do their own bookkeeping. We want to make sure that any type of account that has money flowing through it, we're reconciling it. Um, and then the last module is all about actually reading and understanding the financial reports. So balance sheet, profit and loss statement, statement of cash flows, um, reading the numbers and yeah, understanding what they're actually telling you, not just looking at it and being like, okay, that's cool. Next.
SPEAKER_01I'll just give it to my tax guy at the end of the year. Exactly. Buying all the pretty stuff. Yeah, we don't want to do that. Um, I love that. I think something that you mentioned um that I just want to dig into a little bit is um reconciling those extra accounts. So we think about reconciling a credit card and checking accounts, but like for my business, I used to process through Stripe and PayPal. I now I just do Stripe, but those are accounts too. And so if you don't, and they take fees. And so if you reconcile those, you can look your business um statements can look really wonky. And so if people are doing like afterpay, CESL, they have all these things set up. Those are things they all need to be reconciling, right?
SPEAKER_00So that the numbers match. Exactly. And one of the things that I've noticed too, I don't know if anyone sells on FAIR. Um, and I'm not entirely sure how the back end is set up, but I know I have some clients that take like 60 days for fare to pay up. Yes, yeah, and it's like, okay, we want to make sure that the sales are recorded because you know, legally that money, like you have a right to that money, but you might not see it in your bank account for 60 days. So it's almost like you offer terms to fare, is how you exactly cost receivable. Yeah. That has been something fun that I've had to learn how to do the last couple of months because I didn't have any clients on Fair before. So yes. Um, do you have clients that sell on Etsy?
SPEAKER_01Uh currently I do not. Okay. Well, this is a fun puzzle for you.
unknownOkay.
SPEAKER_01I've been getting a lot more Etsy sellers, and I know a lot of you guys already been listening today. So listen up here. Um, because Megan's gonna give us some words of wisdom. Oh boy. So Etsy is interesting because a lot of Etsy sellers do not have a traditional point of sale. So Etsy is their point of sale. So they have no way to track cost of goods sold. So they just put the item in with the sale price. But because Etsy isn't a point of traditional point of sale, you don't put the cost in with it. And then a lot of Etsy sellers have raw materials plus finished goods. So they're buying like the paint and the bows and the stickers and the wood, and then they're making something. And so, what is our true cost of goods sold? So riddle me this, Meg. Okay. Let's talk about. So, if you guys are Etsy sellers and you want to take Megan's course and set up your own books, what would be a good way that those business owners could account for their cost of goods sold, knowing that they can't just pull it out of their point of sale?
SPEAKER_00Yes. Um, so question for you first. Yeah. Does Etsy have a good report that you can see what products have sold and how many?
unknownYeah.
SPEAKER_00Which one can they do? They do. Do they can you add like SKUs or any like ID number for each product?
SPEAKER_01Yeah, you can do you can pull the product and then the sales price with it.
SPEAKER_00Okay. So do most of your clients, when they calculate the cost of a product, do they do it just like in a spreadsheet or is there any other calculated at all?
SPEAKER_01So I've been having them start to do that in a spreadsheet where we're taking like an Excel doc and saying we have 10 yards of ribbon, each right yard is X amount. So here's how much we have in inventory so that they can get that on their balance sheet. Because they know the inventory. And then what I've been telling them to do is just to look at like whatever you sold and then Excel let it do the heavy lifting to say one yard of ribbon, one thing of buttons, and one of this equals that for cost of goods. Is that how you do it?
SPEAKER_00Yeah, yeah. So for the actual production piece, I mean, there's probably some softwares out there that can help with that, but I mean a spreadsheet is probably gonna be the lowest barrier entry. You know, you don't have to learn any fancy piece of tech. Um so yeah, some kind of a custom-built spreadsheet or something that you can custom build would probably be best for that. Um when it comes to, you know, so that would help account for the flow from inventory to the raw materials to like finished inventory.
SPEAKER_01Yeah.
SPEAKER_00Um, and then if you are able to pull a report from Etsy that shows the numbers sold, um, you would just transfer the cost of however many products you sold. So I'm let's use actual numbers here because I'm confusing myself. So let's just say, you know, you have two different products. Um, let's see. I'll just use I have a client as an example. Uh they sell candle, like jarred candles that they make and car diffusers.
SPEAKER_01Okay.
SPEAKER_00Um, so this is a process I actually just kind of had to learn to build up with her. So she has calculated her cost of product. Um, and then every month she has a spreadsheet that she updates with how many candles and diffusers she's made. So I every at the end of every month, I look at that spreadsheet and be like, okay, she made a hundred candles and a hundred car diffusers. Since I have her cost per product, I can calculate, okay, the cost of goods from raw materials to finished inventory is a hundred times the cost per product. And then you move that. And then I move that from the raw materials to the finished inventory.
SPEAKER_01Yeah.
SPEAKER_00And then I can run her, she sells on fair and Shopify, but I would be able to run an Etsy report and see, okay, how many has she sold?
SPEAKER_01Yep.
SPEAKER_00And then I can calculate, okay, let's say that she sold all hundred that she made. Then I can take that hundred quantity times the cost per product again, move it from her finished inventory to her cost of goods.
SPEAKER_01Okay.
SPEAKER_00So unfortunately, with handmade products, there is some manual work involved, just calculating the cost of products. And if a spreadsheet is the best option or the simplest, yeah, it works. But yeah, I'm not sure if there's another software out there that would help with that.
SPEAKER_01I think the the cost benefit wouldn't be there. Yeah. You know, if you if you're looking at doing your own books because you're small still, we don't need to add a big tech stack cost. And most of the time, entrepreneurs aren't going to lean into a tech stack and figure that all out. And so that's going to be useless. And so I just love Excel because it's a free tool, Google Sheets, like just something that'll do the auto-calculating for you. And then you just have to make those journal entries, which I'm assuming in your course too, you talk about how they can move their inventory over and stuff. So yeah, you would just show them that. Okay. That's awesome. I love it. Anything else we need to think about even if we're either in the bucket of I'm a mess and I need an accountant, or if I'm in the bucket of I can't afford an accountant, but I need books. Anything we should think about?
SPEAKER_00Um, something that I've learned is, you know, a lot of business owners, they think that like their books are a mess and they're embarrassed by it. When honestly, like if I dig into it, it's like, okay, it's either not as bad as you think, or like, you know, I feel like we get so in our heads as business owners, we're ashamed and embarrassed of, you know, areas that we're we've been neglecting or something. And in almost every case, it's not as bad as like the business owner has made it out to think. So if you are in that area where you think your books are a mess, it's probably not as bad as you think. So there's hopefully that encourages you guys a little bit.
SPEAKER_01Yeah, I love that. I think that's a great way to end today, just to encourage you because we do. It's like we feel like our store is beautiful or our website is beautiful, our warehouse is clean, but then we've neglected this because we don't really understand it and we still feel so bad about that. Um, but that's why there's people like you and people like me. We love messes. Like give them help clean them up, help sort it out. Um, and we just want to give you that confidence. Um, and so yeah, you never, I like that. You never need to feel ashamed or embarrassed. Let's just get you what you need today so you can make good decisions. Exactly. Yeah, awesome. Okay, so where can people reach out to you either if they're interested in hiring you to do their books for them or if they're be interested in looking at that course?
SPEAKER_00Yeah, so you can find me. I hang out on Instagram mostly. It's just at Finding Freedom Financial. Um, otherwise, my website is finding freedomfinancial.com and you can find all the relevant information about the course on there. Um, or if you want to work with me as a bookkeeper, there's a little button to apply now. And I actually think it's still linked to my wait list right now, which reminds me I need to change it because I am back. Um, but that's where you can find me.
SPEAKER_01Okay, that's amazing. Yeah, and Megan's happy to hop on a call with you and just see if you might be a right fit for one another. So I will put those links in the show notes for you guys. Thanks for joining us today, Megan, and thanks for taking such a good, taking such good care of the people I send to you. I really appreciate that. Of course. Thank you for sending them to me. Yeah, we'll keep it going. All right, our goal is to have every single entrepreneur have a good set of books. It's a lost goal, but we're marching towards it. All right, you guys, we'll see you all later. Thanks for listening. Bye for now. Hey, friend, thank you so much for tuning in today to the Inventory Genius podcast.