spreadsheets Archives - The YarnyBookkeeper

Post feature image - crochet doily, text overlay "Tracking the costs of your handmade items got you frazzled?

Courses & Freebies Pricing, COGS & Inventory

Pricing Your Handmade Items for Profit … or Pricing on Vibes?

Pricing your handmade items for profit and tracking the cost to make them doesn’t have to feel like a math-induced meltdown. In this post, I’m sharing the upgraded Handmade Product Pricing & COGS Calculator — a simple, maker-friendly tool that helps you track materials, remove the guesswork, and finally price your products with confidence. If you’ve ever juggled yarn scraps, sticky notes, and “I’ll figure it out later”… this instantly makes your life easier.

Bookkeeping for Makers (Without the Overwhelm)

Tracking Pattern Sales in Excel or Google Sheets (How To)

In this post I talked about the importance of “owning your sales information” so you can focus your pattern design and marketing efforts on patterns and platforms that generate the most revenue for you by tracking your pattern sales in spreadsheets.

When you create an overall budget for your business, your Revenue and Expense budgets get “married” – so to speak.

Creative Biz Foundations

My Creative Biz-Let’s Create a Budget

When you create an overall budget for your business, your Revenue and Expense budgets get “married” – so to speak. Together they can tell you all kinds of wonderful financial things about your business including: All this month we talked about budgets (exciting stuff I know :-D) Are you ready? Let’s create a budget! You’ll want …

My Handmade/Creative Biz-Creating an Expense Budget. An expense budget helps you to keep track of your monthly fixed costs - the money you need to pay out EVEN if you have NO income.

Creative Biz Foundations

My Creative Biz-Creating an Expense Budget

Creating an expense budget for your creative or handmade business helps you not only make the dollars you spend work for you, but also prevents your dollars from flying out the door! It also provides you with the amount of your fixed costs that you need to pay each month or year – even IF …

Behind the Scenes Mindset, Motivation & Productivity

7 things I use spreadsheets for

Spreadsheets – I really do love them and I use them for a LOT of behind the scenes things in both my handmade business and here on yarnybookkeeper.com. Spreadsheets are versatile and there are lot of different ways that they can be used without the huge learning curve of creating mathematical formulas, macro’s, pivot tables, …