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.
The prima facie satisfaction u/s 148 cannot be stretched to a non-existing information or incorrect information - ITAT In a…
Mutual Funds to value physical Gold and Silver by using the polled spot prices published by the recognized stock exchanges…
Supreme Court allows simultaneous CIRP proceedings against principal debtor and its corporate guarantor, declines to frame any guidelines In a…
Merely because assessee had declared sales for only one month, the same cannot be treated as bogus on the basis…
ITAT deleted addition as the method of accounting had been accepted by the department in earlier years and the entire…
Orders passed under Benami Act cannot be challenged under Insolvency and Bankruptcy Code, 2016 - SC In a recent judgment,…
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.