Keeping an eye on your money and your website does not need expensive software. These tutorials cover the simple systems I use in my own business. The first is a Google Spreadsheet I use to track my income goals and expenses, with a template you can copy. If you would like to see how visitors behave on your website, or make it smoother for new clients to join you, the two longer guides below will help as well. Each one is written for business owners who are not techy.
How do I track my income goals and expenses in a spreadsheet?
I use a Google spreadsheet to track my income goals and expenses, and it kept me and my team focused for the whole of 2023. At the start of each month I make a fresh copy of the goals sheet, and it works out what I need to earn to hit my target.
- Name your services. Decide which categories you want to track and type them into the service name boxes. Mine are marketing services, retainer packages, project work, Power Hours and audits, and affiliates and courses.
- Add your expenses first. List what you know will go out that month, such as software, memberships, an accountant or a bookkeeper. I also note quarterly and yearly costs with their dates, as a reminder. I always do expenses first, because then I know how much I need to earn.
- Keep expenses up to date. Every Monday I check what has left my bank and update the sheet. I colour an item green once it has actually come out.
- Set a revenue goal for each service. Enter what you need from each one and adjust until the total matches your target. The sheet shows your net profit and profit margin if you hit it. Zero out any service you do not use.
- Record clients and sales. Enter clients who already pay you, then add each new sale as it comes in (I do this weekly). The sheet shows how many more sales you need, and your actual profit so far.
- Close the month. Type the final figures into the income tracker. It totals each service and shows its share of your yearly income.
- Prepare the next month. Duplicate the sheet and rename it. In the old month, type over the formula figures so they do not change when you update the new one. Then clear out last month's clients and set your new goals.
Common questions
How often should I update the spreadsheet?
I go through my expenses and what has left my bank every Monday, and I add new sales weekly. Choose a rhythm you will actually keep.
Where do I start if the sheet looks confusing?
Start by naming the services you want to track, then add your expenses. It may look busy at first, but it makes sense once you begin filling it in.
How do I work out my income goal?
Work out your expenses first, so you know what you need to earn to break even. Then set your goal for each service and adjust until the total profit looks right for you.
