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.
Statutory presumption attached to issuance of a cheque, being one made in discharge of a legally enforceable debt or liability,…
Merely because the authority conducting auction expects higher bid than the highest bidder is no reason to discard the highest…
Provisions of the Limitation Act, 1963 not apply to quasi-judicial bodies or tribunals, unless they are specifically empowered in that…
RBI notifies the Foreign Exchange Management (Guarantees) Regulations, 2026 RBI has notified the Foreign Exchange Management (Guarantees) Regulations, 2026. The…
RBI specifies ‘Related Party’ with respect to bank RBI has issued RBI Credit Risk Management Directions, 2025 defining ‘Related Party’…
Advisory on Filing Opt-In Declaration for Specified Premises, 2025 Dear Taxpayers, The relevant declarations issued vide Notification No. 05/2025 –…
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.