monthly business excel spreadsheet expense invoice

You many have bills and or other expenses. Tab through this entry and input the date sold, the platform ( Etsy is an option), the sale price and any shipping cost you wish to enter.Go to this month’s tab on the bottom and paste it into a blank item distribution on this sheet.Go to your Master Inventory tab, highlight your sold item and cut it from the list.Next, we can add this sale into your monthly income.Īll the Etsy fees will automatically be calculated for you to show your true profits, that’s how good this spreadsheet is! Enter amount Step 3: Record The Sale of Your ItemĬhaChing! Alrighty! You have sold your item, and now it’s time to take it out of inventory on your spreadsheet and add the item to your profits.įirst things first, let’s take your sold item out of your inventory from your spreadsheet.Enter the expense description ( IE: yarn, bubble wrap, any material cost).To input your expense simply GO TO THE EXPENSES TAB and enter: What more could a reseller ask for? Take the stress out of record keeping and record these expenses as they arrive and your golden.

If you track each expense of your business this program will automatically be added to a summary table report, so you can track your expenses fully and view a graph at a glance. Why scramble as many resellers do at tax time to show deductions. Tracking business expenses help you get ready for taxes. How much did it cost you for your listed item?ĭid you purchase some yarn at Michel’s Crafts to create your item, or maybe you purchased your antiques at auction to resell? All of these out-of-pocket expense listed above need to be documented. The product category ( clothing, mug, t-shirt etc).You simply GO TO THE INVENTORY TAB and enter: To keep track of your items with the Flippd spreadsheet simply add your item to the Excel Master Inventory Sheet as show below. Once an item is listed into your shop you are ready to add it into your physical inventory. To me purchasing this spreadsheet was money well spent. This Spreadsheet tracks your inventory, your income, expenses and even car mileage. Each step below can be tracked on your new Flippd spreadsheet to keep your records in great order and ready for tax season. What Will The Flippd Spreadsheet Track?Ĭome along with me as we step thought the day of an Etsy Seller. Imagine seeing a report with a clear summary of exactly how much was spent and how much income was received for your business annually? I’m happy to say this spreadsheet does all of this and more. Oh the reports! One of my favorite parts of this spreadsheet is the reports feature. Another great feature of this spreadsheet is the automated reports. If you travel at all for your business, even if it’s to a local shop, keeping track of your mileage for easy tax deductions is at your fingertips. This spreadsheet will help you calculate your mileage with a mileage calculator. This spreadsheet will help you track several key components of your business such as your inventory, daily expenses and daily income. Cost $50.00Īny reseller of any size will benefit from using this spreadsheet. Flippd Spreadsheet 2022 By Hustlin Hooks. This product is created by a husband and wife team that have made reselling their full-time job. The cost of this spreadsheet at the time of this article is $50.00 US. “Resellers’ Spreadsheet” a try, and I’m so glad that I did. The name of the spreadsheet is THE FLIPPD SPREADSHEET. I discovered that one of my favorite YouTubers Husslin’ Hooks has created a spreadsheet for resellers just like us. Excel: An Easier WayĪs I am always on the computer, using Excel to track my income seemed like the next logical step. It worked well for the first few months however it took a lot of time to manually record each line item. A handwritten ledger to record all my daily income and expenses did the trick. I started my Etsy journey with just a simple hard cover expense ledger. I’ve been selling antiques on Etsy for many years and I have always struggled with my finances. This product keeps my Etsy shop finances in order and is simple to use.

The Flippd Spreadsheet (outlined below) is a tool I use daily. Note: I am not an affiliate marketer for the Excel Spreadsheet Flippd. Now that I’m selling on Etsy and making income how do I track this income for my tax records? There must be an easy way to track my Etsy outgoing expenses and daily income but how? Using Excel To Track Your Etsy Expenses and Income

Monthly business excel spreadsheet expense invoice