CCI Online Learning
What do you want to learn today?


Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

maintaining accounts in excel

Sneha (SERVICE )     05 January 2010

 32 likes  417 points

| My Other Post

How to maintain accounts in excel?

or any other simple software to record the transactions of small unit.


Aditi Kaur (Practising CA)    06 January 2010

CCI Online Learning offers a library of courses for CA/CS/CMA Aspirants from the best faculties in India. Our top notch courses aim to make your journey from a student to a professional, a successful one. To promise a successful career as a professional CCI Online Learning also offers programs like Financial Modeling, MS Excel, IFRS/IND AS Certification Courses that will help you take your career to the next level. Check out the free demo videos here


CA.Tarun Maheshwari (CA, DISA)     05 January 2010

CA.Tarun Maheshwari
 185 likes  7145 points

View Profile | My Other Post

I think, better option is Tally. Single user version of tally will not cost you much, but it will of great use for you.



 6 likes  921 points

View Profile | My Other Post

just entred income items on one sheet and expenditure item on other sheet then sort as capital and revenue eaxpenditure and you can simple get profit or loss


Exshail (Software)     05 January 2010

 119 likes  1480 points

View Profile | My Other Post

Originally posted by : sneha
How to maintain accounts in excel?

or any other simple software to record the transactions of small unit.




Tally is ok for large units and having large transaction. If you want free version instead of tally go for Busy from Busy Infotech. You can downlaod it from below link.


Main features.

1. You can see any reports while entering voucher or in edit mode & vice versa.

2. Export report to Excel, print preview having zoom, search & other options.

3. You can print Balance sheet, Profit & Loss a/c with schedules with a single click. 

4. Reports have options for filter & search.

5. Vat Invoicing & Printing

6. Vat Computation, vat Summery, Vat Adjustment Register.

7. Inventory Register.

8. Ageing.

9. Ledgers\items having merged options for vewing as well as actual.

10. C\F Form Receivable\Issuable Reports.

11. Consolidated & transaction summery for Account & inventory items



BTW the professional version (Mini ERP) have tds, service tax, excise etc., and also much cheaper then Tally and other costly softwares.

For any further help you can post in this forum.



1 Like

Y. S. Ghodvaidya (Sr. Accounts Executive)     06 January 2010

Y. S. Ghodvaidya
Sr. Accounts Executive 
 67 points

View Profile | My Other Post

As per the PF Rules Can any one tell me the % Rate as per the Five Accounts mentioned in the Challan.  



lakhan kumar tushar (ACCOUNT ASSISTANT)     22 December 2015

lakhan kumar tushar
 58 points

View Profile | My Other Post

aap agar excel me accounts maintain karna chahte ho to mainly aap sale, puchases,sundry debtors,sundry creaditors,cash,bank. ke alag leadger banane honge but agar aap kisi software me yeh kaam karte ho to aap tally,busy me easily kar sakte ho entry pass karne ki jaroorat hai excel me log way me jakar pura record maintain karna hoga small business ke liye aap excel use kar sakte hai but jahan large transcation ho wahan aapko software use karna hoga kyun ki wahan se aapko upto date har cheej milegi just a pass entry.............

aap tally,busy ka trail version use kar sakte hai........sikhne ke liye



Pradeep Lamichhane   26 April 2017

Pradeep Lamichhane

 2 points

View Profile | My Other Post

For managing accounts  such as bookkeeping, p&l accounts, income statements for small business to medium business I would suggest you all to Download .It is easily adjustable, ease to use and work within ms excel. Such a great tool.Give it a try.

Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Bajaj Finserv

Trending Tags
GST Live Class    |    x