The ACCA Learning Community
Home
193 online now

Using excel as an accounting software....any add-on available

+4 Votes
Using excel as an accounting software....any add-on available

There are various accounting software available in the market. During my work placement I realize that its better to custom design these software as per organisations requirement and when there are difficulties the best way is to analyze data by exporting it to excel and drill down to discover these issues. Excel is most commonly used to manipulated data. However, excel can be used in many different ways. We can input data in a format, store it, extract customized reports and manipulate the data as well. So, I like to know if there is any add-ons available for excel by which we can use it as a basic accounting program as well. To my knowledge creating this like program is not hard as Microsoft access is one which is designed to use as an accounting program and many other different ways by simply customizing organisations requirements and developing queries as needed. Therefore I just like to know if there is any readily available solution (any add-ons) so I need not to go through step by step process in excel.

January 31st 2015 AN ACCA USER 8,730 Points 1 Flag

18 Replies

+4 Votes

I don't think if there is an add-in for excel to do basic accounting program, but you can use some formulas to do it.
I have just created my own template which generates a general ledger, and then it is linked automatically to produce a Trial balance, Income statement, Statement of Changes in Equity, Statement of Financial position as well as Cash flow statement.

The only task you do is to input (post) daily transactions in a general ledger and then the other reports will be produced automatically on daily basis as you post your transactions in Microsoft excel.

I have also designed a template which can be used to track inventory movement as you purchase or sell your inventories. The template shows the remaining balance of the inventory and if the inventory is below your desired re-order point, the remaining balance is highlighted red colour and bold, it also has a column to alert you once the red colour occurs, the column shows words like " Order more inventory".

So it is just your creativity that can allow you making excel working like an accounting program. These useful templates are very useful for small and medium sized entities in keeping their accounting records..

February 6th 2015 AN ACCA USER 390 Points
0 Votes
It seems like a brilliant idea. I wish I could do it.
February 10th 2015 AN ACCA USER 300 Points
0 Votes
How would possible to learn to design a template as you mentioned above? it is possible to get a material or training on this please?
February 12th 2015 AN ACCA USER 140 Points
0 Votes
I offer such training but it is currently offered only in Tanzania (East Africa). If you are interested, you can give me your email so that i can send you the template as well as the notes I prepared on this issue..

There are so many things you can do with excel, another interesting thing is a template for tracking inventory movement. you just put two excel sheets, one showing the items sold and bought while other sheet tracks the remaining items, you can just set your re-order point (level) so that once the remaining items are at or below your re-order level, the number of items remaining turns automatically to bold and red colour, and then it alerts you in the next column that " order more items".
February 13th 2015 AN ACCA USER 390 Points 1 Flag
0 Votes
@ Yustino Gaudiano Nyendeza, please can you send me the template and notes to: ceemeonjob@gmail.com . I am interested in it. Thanks in advance.
February 20th 2015 AN ACCA USER 230 Points 1 Flag
0 Votes
At Yustino Gaudiano Nyendeza, please can you send me the template and notes to: ceemeonjob@gmail.com . I am interested in it. Thanks in advance.
February 20th 2015 AN ACCA USER 230 Points 1 Flag
0 Votes
@Yustino Guadiano Nyendeza, please can you send me the templates and notes to: jentsietwumasi@yahoo.com.  Thanks in advance.
February 21st 2015 AN ACCA USER 260 Points 2 Flags
0 Votes
I WILL ALSO  WILL   LIKE TO HAVE  THIS  TEMPLATE  CAN  YOU  SHARE   AT  quameatu@yahoo.com  
or  any guidance   on  how to  build   my  excel  skills
February 21st 2015 AN ACCA USER 180 Points
0 Votes
WILL ALSO  WILL   LIKE TO HAVE  THIS  TEMPLATE  CAN  YOU  SHARE   AT  quameatu@yahoo.com  
or  any guidance   on  how to  build   my  excel  skills
February 21st 2015 AN ACCA USER 180 Points 1 Flag
0 Votes

walihamzacca@gmail.com

February 25th 2015 AN ACCA USER 140 Points 1 Flag
0 Votes
Vizuri sana @Yustino Gaudiano Nyendeza. Naomba unitumie na mimi pia at emilypettit@hotmail.com. Where exactly (in TZ) do you offer your training? Ahsante sana.
February 25th 2015 AN ACCA USER 150 Points 1 Flag
0 Votes
Hi Emily,
I offer trainings at Makumbusho, near the new Minibus stand in Dar es Salaam at Kitega Uchumi House. I am planning to conduct a training in Mid March this year, you are warmly welcome if you are interested. I will communicate with you for more information via your email.. My telephone number is +255713388317
February 26th 2015 AN ACCA USER 390 Points
0 Votes
please am also very intrested on working with excell. please do e-mail me the templates and notes to janvion2007@yahoo.com. thanks in advance
February 27th 2015 AN ACCA USER 140 Points
0 Votes
kindly send me bonolomokgowe@gmail.com
March 19th 2015 AN ACCA USER 160 Points
0 Votes

Kindly share with me also.
nazim8982003@yahoo.com

March 21st 2015 AN ACCA USER 400 Points
0 Votes
i will also like to have this template papadest@yahoo.com is my e-mail
March 26th 2015 AN ACCA USER 360 Points
0 Votes
Hi! Yustino,
It would be great if you could share with me the templates at accadeepanshu@yahoo.com.
March 27th 2015 AN ACCA USER 140 Points
0 Votes
could you send me please the templates of excel accounting software at muhammadzaheerabbas@gmail.com
March 30th 2015 AN ACCA USER 210 Points
...