Track Expenses Spreadsheet
This is a great setting when you are adding dates as well because it will place your data into whatever date format you prefer. Formulas Do not be afraid to take advantage of the formula options in Excel. You can make them as complex or as simple as you want or need. A very simple one is the SUM feature that will add a column of numbers for you and provide the total in whichever cell you specify. As the information in the cells changes the sum in the total cell will adjust accordingly. This is a great option for presenting budgetary numbers or inventory type items. There is a formula wizard which will help you string together any number of data sequences and configurations.
The templates can be saved and used as many times as required. Starting a small business out of your home offering products or services like business consulting photography selling on the web or a MLM? You are now faced with tracking all your expenses and revenues for your business and you certainly don t have the money yet to engage a bookkeeper or accountant. If your business is a sole proprietorship whether it be a Canadian Proprietorship or a US-based Proprietorship you do not require an accountant to submit your company financials (books) to the IRS (USA) or Revenue Canada).
Most Popular This Week
Your business revenue and losses are reported as part of your annual personal income tax. For this small business start-up you won t need to buy fancy accounting software like Quick Books or AccPac to track your business. Only as part of incorporating Bizfare Enterprise Inc in 2005 was it a requirement to engage an accountant. My accountant did insist on using Quick Books software for my business accounting. Up until then using a simple spreadsheet template served my business accounting needs for over ten years. This simple spreadsheet accounting stood the test of multiple audits by Revenue Canada (CRA and Revenue Canada Goods and Services Tax.
You need to know which projects and tasks are slipping through the cracks so that you again react. You need to know when you will not have enough resources to meet demand so that you can allocate them properly or manage the demand. You need to know which issues are lurking so that you can address them now before you lose the favor of a critical customer. And you need to see how your processes are working so that you can continuously improve your processes. In today s economy competitive landscape and accountability standards you must have the data. Managers are getting blindsided because they do not know what is coming and what is going on.