It’s formatted with columns for the current year and past years so you can track the percentage of change from one year to the next. These are a great way to hold each department accountable and compare forecasted expenses and revenue to actual numbers. It’s great to have a general overview of how your business is doing, but to have a sense of your strengths and weaknesses, it’s essential to have a department-by-department small business budget template. This simple small business spreadsheet for income and expenses will be a major building block for the accounting side of your business. It will help you track your expenses and income on a monthly basis, and all income your company receives and all expenses it incurs can be broken into categories like labor and materials. This is perhaps the most basic – yet most crucial – business budget template you can use.

No matter what type of business you own, you will need a general ledger spreadsheet. Here are five of the must-have spreadsheets for small business income and expenses. You will want something that’ll be easy to use and understand. Such a spreadsheet for income and expenses can help you prepare for expected slowdowns in your business, project costs needed to start and/or grow your business, as well as track items such as revenue, cash flow, and monthly expenses.Ī small business budget template is something you’ll be referring to quite often. What you may not know is that there are many helpful examples of a small business budget template to make your job easier.Ī business expense tracker template can help you not only with this organizational aspect, but also let you focus on your bottom line. Savings: emergency fund, RRSPs, RESPs, TFSAs, seasonal expenses (e.g.As a small business owner, you know that staying organized is key to being successful. Personal: tobacco, alcohol, books, music, clothing and shoes, donations, subscriptionsĮating Out: meals, snacks, take-out, beverages (coffee, tea, juice, soft drinks)Įntertainment: recreation, sports equipment and fees, movies, concerts, hobbies, gamingĬhild: daycare, lessons and activities, allowance, school supplies and fees, babysitting, programs, tutorsĭebt Payments: credit cards, loans, leases, support payments, government debts, personal debt Health Care: medical premiums, life insurance, medication, eye care, dental, supplements, wellness costs Transportation: fuel, auto insurance, transit, parking, taxi, rentals, car sharing, tolls Living: personal care, bank fees, salon and spa services, dry cleaning, pet costs, memberships (fitness, clubs, associations) Groceries: food, baby needs, household supplies, toiletries Household: furnace, water tank, roof and gutters, decor, upgrades, storage locker, gardening, cleaning services, outdoor equipment and maintenance Utilities: phone/cell, cable/internet, gas, hydro, security Housing: mortgage, rent, strata fees, house insurance, property taxes View a sample of a completed tracker (from the previous version of our Monthly Expenses Tracker).Įxpense Categories – Know Where Your Money is Going This becomes the cash balance for the next week. If there’s a surplus, you should have money in your wallet or bank account.

Total all columns and subtract actual expenses from actual income.

On these pages, keep track of seasonal expenses rather than recording on your weekly pages.

You also need to record weekly savings amounts on pages 14 – 15 of the Expense Tracker.

You may want to track coffees, dining out, or fuel separately. You can then use the blank columns to create your own categories.

List the dates down the left side and record actual money spent each day.

You should also list any income you may expect to receive during each week.

Record cash balances on hand or in your bank account.

For example, a 7 day tracking period would be March 30th to April 5th. For each week, record dates you are tracking.The expense categories listed further below and on page 1 of the Expense Tracker will help you decide which expenses to record where.Open a copy of our Monthly Expense Tracker.

Free business expense tracker excel