HomeHome SearchSearch MenuMenu Our productsOur products

Use this simple tip to ensure your company's budget always balances

by , 03 October 2014
Your company budget should show the amount of money you have for your expenses and the amount of income you have after you deduct those expenses.

If you struggle to get your budget to balance, it means your income and expenses don't work out the way they should.

This could cause major problems if it leads you to think you have more money than you actually do. When this happens, you could end up over spending.

You can avoid this through by using this simple tip...

 

Ensure your budget balances by using this simple tip

 
Tip: Use Excel to create your budget and use its easy formulas to work out all your totals and deductions.
 
This is a really easy process. And because your computer does it all, it removes the possibility of human error. 
 
Here's how to use it… First enter your various income amounts. Let's say you put these in cells A1 to A11. To total them just put this formula in cell A12: =sum(A1:A11).
 
This correctly totals your income amount.
 
Repeat this process with your expenses but ensure you change the cell names for the cells you put your expenses in. Let's say, you do this in cell C15 and you enter =sum(C1:C14) to total everything.
 
Now you have correct totals for your income and expenses.
 
Next you need to use this formula to deduct them.
 
*********** Advertisement ************
 
Run into an Excel problem you can't figure out? Run to your Practical Guide to Excel CD.

It gives you step-by-step solutions, with examples and easy to understand explanations. Click here for more.
 
***********************************
 

Use this formula to correctly deduct your expenses from your income

 
Below your expenses and income totals enter this formula: =sum(A12-C15).
 
This deducts the amount in C15 from the amount in A12 and gives you the correct amount of income you have after all your expenses.
 
Using this simple tip is the easiest way to ensure your budget balances every time. 
 


Related articles




Related articles



Related Products



Comments
0 comments


Recommended for You 

  Quick Tax Solutions for Busy Taxpayers – 35 tax answers at a glance



Here are all the most interesting, thought-provoking and common tax questions
asked by our subscribers over the last tax year – everything from A to Z!

To download Quick Tax Solutions for Busy Taxpayers – 35 tax answers at a glance click here now >>>
  Employees always sick? How to stop it today



Make sure you develop a leave policy to regulate sick leave in your company.

BONUS! You'll find an example of the leave policy and procedure in this report.

To download Employees always sick? How to stop it today click here now >>>
  Absenteeism: Little known ways to reduce absenteeism



This FREE e-report will tell you how you can reduce absenteeism in your workplace while avoiding the CCMA and without infringing your employees' labour rights.

To download Absenteeism: Little known ways to reduce absenteeism click here now >>>
  7 Health & safety strategies to save you thousands



Don't let a health and safety incident cost you one more cent. Implement these seven
strategies in your company today.

To download 7 Health & safety strategies to save you thousands click here now >>>