Discover the budget friendly alternative to managing your company's finances
If your company uses 'professional' accounting systems, you could easily pay R5 000 a month. That's R75 000 a year on an accounting system!
In hard times, that accounting system may be the reason you don't make a profit each month. So ask yourself: What good is an accounting system that costs your business all the money it's meant to manage?
The answer is, there is none. Especially when there's a programme you probably already have on your computer that can you can use to manage finances just as effectively.
So what is this powerful and inexpensive accounting tool?
It's Microsoft Excel.
*********** Best seller *************
Simple Excel solutions to do your complex calculations in minutes!
Want to fix Excel problems in the shortest amount of time? Don't have time to devote to Excel? Click here for more
Discover the Excel functions and formulas you need right now to reduce stressful and tiring work within minutes of data processing. The Practical Guide to Excel gives you everything you need to work quickly, efficiently and without stress.
Here's why you should switch your company's accounting to Excel today
Just about everyone with a computer has Windows and that means they have Excel. Now you may think Excel can't compare to a R5 000 a month accounting system, but if this were true, why would top international companies such as the GFI group and eSilicon opt for Excel over these other systems.
The reason is simple, once you master Excel and its tools and functions, you can make it do just about anything a professional system can do.
To get you started on your journey to converting your accounting to Excel, we have two easy Excel tips for you.
Get started with Excel accounting with these two tips
Tip 1: Use the absolute reference to avoid constantly adjusting your Excel formulas
The absolute reference is very useful when you do your company's accounting, especially if you have to copy formulas to multiple rows or columns. If you want your formula to always reference a specific cell or a specific row of data, use the absolute reference. To create an absolute reference in a formula, use the '$' sign in your formulas.
Examples of absolute references:
$H$1 = Locks in the column and row (=sum($H$1/B7)). The formula will only use the data found in this cell. But if you enter $H1, it locks the column and H$1 locks in the row.
Pivot Tables enable you to pull certain data in to separate tables to easily organise and analyse it. This is a tool even professional public accountants rely on because of the way it lays out the information.
You can use these tables to;
1. Draft your management accountings;
2. Itemise your inventory; and
3. Draft your fixed asset register.
These are just two of the many easy functions you can use to manage your company's accounting in Excel without going bankrupt.
So make the more to Excel today and start saving money every month.