Wednesday, March 28, 2012

Tracking Data to Create a Business Plan

Most Mondays find me paying last week's bills, invoicing the work I did the previous week and generally inputting financial data into Quickbooks Pro. A few weeks ago I added another step to my weekly finance session: filling in a spreadsheet with the money earned during the previous week. For this purpose, any work submitted during the week counts as a project for which the money was earned that week. The spreadsheet is divided by currency (US$, Euros, Swiss Francs), with formulas to create US$ totals (using approximate average conversion rates) for the week and month, and a running US$ total.


This spreadsheet, along with a daily planner divided by half hour increments where I try to track how long I spend on various projects (including administrative chores, marketing, etc.) is an attempt to get enough data for an actual business plan. I can (usually) estimate reasonably accurately how long a given project might take and I know what money I have (or don't have) in the bank. But since payments for projects arrive a long time after the work has been completed and since I regularly transfer money from my business account to the family account, I don't have a good sense of how much I actually earn for the time I spend.


Hopefully this system will eventually give me enough data to figure out what I'm actually making per hour, both on average and from specific clients. That should help me create a realistic business plan. Let's see how it goes ...


How do you approach business planning?


9 comments:

  1. Thanks for sharing your experiences here on your blog I enjoyed this post, and I'm looking forward to more.

    ReplyDelete
  2. Requirements for becoming a professional translator.

    german english translator

    ReplyDelete
  3. For me, an entrepreneur who wants to start a business, I plan every step. Even before the business plan creation stage. I like your approach here, though, how’d you think of that? You should keep those data to have your basis for your future business. Do you have one now? I think the idea will work.

    ReplyDelete
  4. You should track your time always in order completing your work in a proper time. Because without giving importance for your time you won't think about your success in your life. So, you can use free timesheet template and don't need to think that free products are not so good. But you are wrong this is the best software from many paid time tracking software.

    ReplyDelete
  5. This is a fantastic website , thanks for sharing. Currently

    ReplyDelete
  6. The internet provides a good source of information and you can also use it to compare prices, features, and other aspects that will put one brand ahead of another. Click here to know about liteblue

    ReplyDelete
  7. You have done a amazing job with you website Business

    ReplyDelete
  8. This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post. 蘇洛支付

    ReplyDelete
  9. become so competitive and fast that it is just impossible to survive in any business that any one starts. Scott Dylan

    ReplyDelete

Thanks for your comment. I will review comments weekly, so please be patient if you are expecting a reply. - Barbara