Excel Double Entry Accounting Template / Software download free for small professional firms of CA/CS/CMA/Lawyers etc. following cash basis
ABCAUS Excel Accounting Template has been designed to assist small professional firms of Chartered Accountants, Certified Public Accountants, Lawyers etc. to have a excel based simple invoicing and book keeping / accounting template / software that works on double entry basis accounting.
It has a built in mechanism for issuing of Invoices and Receipts and auto populating them into accounting records like client registers and daybook. Users can define their accounting heads which shall be used to record the transactions. It has built in Accounting vouchers like payment voucher, journal voucher and receipt voucher which can also be used to post transactions based on double entries.
Though it has been designed for cash basis of accounting, client register has been provided to keep a track of unrealised bills. Unpaid VAT/GST/Service Tax liability as on date is also displayed.
ABCAUS Accounting instantaneously generates various financial records , ledgers and statements like, Client registers, daybook, expenses /income ledgers , trial balance, income statement and balance sheet.
It is completely menu driven, very user friendly with pop up help sections to alert users for any wrong or undesired entry. ABCAUS Accounting is a full fledged small business or office accounting software and is absolutely free for use.
Macros must be enabled for this utility to work with.
Please note that before you should make any entry, database must be created. Go to database from the main menu and create basic database like name , address of the firm, opening Trial Balance Entries and heads of Income and Expenditures
It can be used either for just Billing / Invoice purpose or full fledged book keeping in the most simple way.
Those who intend to use this template at places other than India should download the global version where they can choose different Accounting periods and Currency.
ITAT allowed increased exemption of Rs. 25 lakhs u/s 10(10A) to non-government employees in view of CBDT retrospective notification. In…
PCIT has revisionary jurisdiction u/s 263 over the cases irrespective of the fact that the relevant assessment was completed physical…
Appellate court interfering with Motor Accidents Claims Tribunal findings on assessment of disability and loss of earning capacity must undertake…
When period of delay is not very huge and involve huge monetary liability on the assessee, a lenient approach should…
Ratification by EoGM of the company can not give legality of the diversion of the fund raised by preferential issue.…
CBIC prescribes procedures for return of export cargo from international waters due to closure of the Strait of Hormuz where…
View Comments
Can you provide this sheet for the F Y 2023-24
its now available for download
How can add more lines & categories to database
Please instruct me
I NEED TO EDIT PERIOD DATE AND ALSO HAVE TO HAVE MORE HEADS IN DATABASE , LIKE EXPENSES ACCOUNT.
THIS SHEET IS PROTECTED KINDLY HELP M E OUT
PLEASE UPDATE IT WITH NEW ACCOUNTING YEARS
Hello,
Is there a way to edit this, so that I can include some more fields and have GST % included. I need this kind of accounting software for selling on e-commerce websites.
Thank you.
I am afraid, no.
need to add more heads, pls share the password to unprotect the sheet.
I NEED TO EDIT PERIOD DATE AND ALSO HAVE TO HAVE MORE HEADS IN DATABASE , LIKE EXPENSES ACCOUNT.
THIS SHEET IS PROTECTED KINDLY HELP M E OUT
Hello,
Is there a way to edit this, so that I can include some more fields and have GST % included. I need this kind of accounting software for selling on e-commerce websites.
Thank you.