If you don't like the idea of the latest nifty software for tracking your sales and rounds, and like me prefer to keep it simple and use a spreadsheet. Read on.
As the 2013 - 2014 year end looms , now is the time to make those little refinements to your spreadsheets design, that can see you increase profits with a better picture of what is coming in and what is going out.
I will share all the little refinements and important improvements I have made to mine over the years, and give some of the newbies a few ideas on how to manage there books.
Graphs!
Yep, just sticking in the sales and expenses figures doesn't really give you back any information on your progress. I like to see exactly what I have taken in year to date, and what has actually gone out year to date.
I have three graphs to display this sort of information. As you can see the first is my sales ledger. This shows the total value of all work that has been complete. Then total amount paid, and then the total amount outstanding.
The second is the Profit and Loss chart. As you can imagine. I have my sales, expenses, salary costs, and final my annual profit. The last graph displays a running total of my cash assets; cash on hand, amount in Paypal accounts, and money in the bank.
Seeing all that information at a glance can keep you focused on the main goal, which is to make money.
Group boxes. As you can see on my sales ledger. Grouping data in excel can simplify you sales sheets, ensuring your only focusing on the important info. By tracking the total value of work complete in my sales ledger, as well as tracking invoices paid. I can monitor how much is outstanding at any given time.
Now to the all important list of expenses. I track everything, money spent out of petty cash, the bank, paypal accounts. Even those pesky bank charges on the back of you monthly statements.
From one month to the next I like to know my exact profit, and what it is as a percent of my sales. By monitoring the percentage, I see how well things are running. Its the age old saying sales are for vanity and profits are for sanity.
Finally I use a nifty formula at the bottom of my sheet to track all the cash assets for the month and how my sales, expenses and salary costs have effected my bank balance. This is then fed into another bit at the top, which updates my charts, so I can review everything at a glance.
So now its up to you. If you have Microsoft excel, great. But if not, open office is free and you can do just about everything you can do in excel.
All the best to everyone in 2014 - 2015.
Written by @laddergarder
As the 2013 - 2014 year end looms , now is the time to make those little refinements to your spreadsheets design, that can see you increase profits with a better picture of what is coming in and what is going out.
I will share all the little refinements and important improvements I have made to mine over the years, and give some of the newbies a few ideas on how to manage there books.
Graphs!
Yep, just sticking in the sales and expenses figures doesn't really give you back any information on your progress. I like to see exactly what I have taken in year to date, and what has actually gone out year to date.
I have three graphs to display this sort of information. As you can see the first is my sales ledger. This shows the total value of all work that has been complete. Then total amount paid, and then the total amount outstanding.
The second is the Profit and Loss chart. As you can imagine. I have my sales, expenses, salary costs, and final my annual profit. The last graph displays a running total of my cash assets; cash on hand, amount in Paypal accounts, and money in the bank.
Seeing all that information at a glance can keep you focused on the main goal, which is to make money.
Group boxes. As you can see on my sales ledger. Grouping data in excel can simplify you sales sheets, ensuring your only focusing on the important info. By tracking the total value of work complete in my sales ledger, as well as tracking invoices paid. I can monitor how much is outstanding at any given time.
Now to the all important list of expenses. I track everything, money spent out of petty cash, the bank, paypal accounts. Even those pesky bank charges on the back of you monthly statements.
From one month to the next I like to know my exact profit, and what it is as a percent of my sales. By monitoring the percentage, I see how well things are running. Its the age old saying sales are for vanity and profits are for sanity.
Finally I use a nifty formula at the bottom of my sheet to track all the cash assets for the month and how my sales, expenses and salary costs have effected my bank balance. This is then fed into another bit at the top, which updates my charts, so I can review everything at a glance.
So now its up to you. If you have Microsoft excel, great. But if not, open office is free and you can do just about everything you can do in excel.
All the best to everyone in 2014 - 2015.
Written by @laddergarder