![]() You can print the PDF template for income and expenses if you wish to have a paper log for your small business transactions and fill it out manually. You can copy the sheet for each month, or continue adding rows for expenses throughout the quarter or year. Simply delete the examples in area B10:G14 and start adding in your transactions. The formula in the Balance column is set to calculate the balance after each indicated transaction. The Google Sheets and Excel spreadsheet versions of the small business income and expenses template contain a few examples of income and expenses. It is also helpful for your own benefit, for a simple overview of your business’ financial situation.ĭon’t forget to keep receipts and invoices of all business expenses, in order to claim them and lower your taxable income at tax time. It will come in handy at tax time when you can easily look over your money in and out for the year back. Prefer the analogue way? Print your template and you can keep it on your person, or fill it out at home each day.Īn income and expense sheet is a monthly or yearly record of your business-related expenses that you will need in order to keep track of your small business expenses and income. If you use an Excel spreadsheet or a Google Sheet, you will be able to log your small business income and expenses on the go, from your phone or computer. Get the free small business spreadsheet for income and expenses Making this process easier will save you time and headaches, and the simplest way to do that is by using an already set-up template. But remembering to do so on a daily when you have multiple other things to take care of and run your business may be hard. Recording your business income and expenses is vital for every small business. How to fill out the spreadsheet for income and expenses How to use the income and expenses small business spreadsheet Savings: emergency fund, RRSPs, RESPs, TFSAs, seasonal expenses (e.g.Get the free small business spreadsheet for income and expenses 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |