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.
CIT Revision notice u/s 263 quashed as the Assessing Officer rightly taken DVO value of property sold as actual sale…
Extension of timeline for implementation of mandatory "Ship To GSTIN" and Voluntary Closure of E-Way Bill functionalities GSTN Advisory dated…
No protective addition required in the hand of a third party when additions have been confirmed in the hands of…
Limitation for filing application u/s 34 of Arbitration Act commence from date on which application u/s 33 is disposed of…
Case remanded as no finding was given whether cash payments disallowed u/s 40A(3) were covered by Rule 6DD under Income…
In case of investment in share capital, the source of investment may remain outside the control of the investee company.…
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.