HomeHome SearchSearch MenuMenu Our productsOur products

Accounting got you stumped? This simple trick will help make things clearer

by , 01 October 2014
Do you find your company's accounting overwhelming and complicated? Do you struggle to keep track of the endless columns of numbers?

You're not alone! And if you don't have an eye for numbers, it can be confusing.

There's an easy way to resolve this though.

All you have to do is use this simple Excel function and it'll make everything clearer...


Introducing the one Excel function you can use to make your accounting data clearer

The problem most people have with their accounting is they struggle to track all the different kinds of amounts in their books. 
You need a way to quickly identify the different amounts without squinting at the computer screen to see what the description is. 
The easiest way to do this is to use the Excel format cell function. This gives you the ability to change cells so each one looks different.
The best way to make cells look different is to colour code them. 
Here's an easy way to use this function correctly.
*********** Advertisement ************
Are you an accountant or bookkeeper? Don't let an Excel problem interrupt your workflow
Over 5 920 Excel questions are searched on Google in South Africa every month...
If you're adding to that statistic, you'll know how hard it is to find a solution that specifically relates to your Excel problem.
But not anymore!

Here's an easy way to colour code the amounts in your accounting spreadsheet

The first thing you must do is create a colour code key at the top of your accounting spreadsheet. Here you should take a column and make each cell a different colour that you want to use in your coding. 
Next to each colour, write what the colour means. For example, red means monthly fixed expenses, yellow means important once-off expenses and green means regular income. 
Then, as you enter amounts into your spreadsheet, colour them depending on what they are.
This way, when you need to check your accounting records and find a particular piece of information, you can spot it quickly. 
Check out the Practical Guide to Excel for more ways you can use Excel formatting to improve your accounting. 

Related articles

Related articles

Watch And Learn

Related Products


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 >>>