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.
Agreement validly terminated prior to initiation of CIRP did not constitute “assets” or “property” of the corporate debtor u/s 14…
Supreme Court explains jurisdiction of courts under NI Act for dishonour of account payee or bearer cheques In a recent…
Advances received in normal course of business and adjusted against sale bills cannot be added u/s 68 of the Income…
Faceless mechanism for income escaping assessment would not exclude the Central charges and International Taxation charges from its application -…
Ground not adjudicated by first appellate authority or ground not originating from first appellate order cannot be decided in second…
High Court directed ITD to consider condonation of delay in filing ITR for four years as the COVID-19 pandemic constituted…
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.