Multipurpose excel utility - Useful for every manufacturing /trading business with statutory compliances
Today sharing one of my excel programming which has helped me to the maximum in my professional career and allowed me to work with accuracy, speedy reporting & controlling. And this also allowed to access most data within a single excel file and not to make the computer messy with thousands of useless sheets.
I have named it as operation sheet.
The time taken to design this is around 10 Years. Yes the first operation sheet was designed in the Year 2007 which was just for Purchase & Sales data with no auto error checks and gradually I included many functions which are inter linked with the basic functions of a business (i.e. Purchase & Sales)
** This sheet has been designed considering the Place of business is within Odisha and so far no effects of GST has been included.
The Usefulness about this sheets (as per me): -
1. Purchases & Sales Databases (with all relevant transaction details which we are not able to maintain or generate through tally/sap) Like Waybill, Transportation details, auto freight calculation, delivery date & weight, debit / credit notes bill wise, Quality (QC) details of each transactions , etc.
2. Taxation: - It is helpful for cenvat credits of excise duty, VAT Input.
3. Statutory Forms : - You can track which C-forms are pending / received / issued / receivable, etc
4. Statutory Payments : You can enter the statutory Payment details and it will automatically show in the Excise / VAT charts and further you can cross check the liabilities.
5. You can enter the Consumption details (party wise also) , Production, Change the valuation method (FIFO/LIFO/WAVG) and track which stocks are in your stock yard.
6. You can also enter the bill wise receipts from customers and track the outstanding. (Although for more details reports I use another sheet)
7. You can track that which bills are shown in returns and which are pending (assume you receive bills late, missed due to some reasons etc)
8. Freight Payments / Deductions : -Auto calculate the freight payable and track with accounts.
Many More functions has been added whichever and whenever I felt the importance of any thing I have tried to add that one.
Download this Excel Utility
Download this Excel Utility
I have named it as operation sheet.
The time taken to design this is around 10 Years. Yes the first operation sheet was designed in the Year 2007 which was just for Purchase & Sales data with no auto error checks and gradually I included many functions which are inter linked with the basic functions of a business (i.e. Purchase & Sales)
** This sheet has been designed considering the Place of business is within Odisha and so far no effects of GST has been included.
The Usefulness about this sheets (as per me): -
1. Purchases & Sales Databases (with all relevant transaction details which we are not able to maintain or generate through tally/sap) Like Waybill, Transportation details, auto freight calculation, delivery date & weight, debit / credit notes bill wise, Quality (QC) details of each transactions , etc.
2. Taxation: - It is helpful for cenvat credits of excise duty, VAT Input.
3. Statutory Forms : - You can track which C-forms are pending / received / issued / receivable, etc
4. Statutory Payments : You can enter the statutory Payment details and it will automatically show in the Excise / VAT charts and further you can cross check the liabilities.
5. You can enter the Consumption details (party wise also) , Production, Change the valuation method (FIFO/LIFO/WAVG) and track which stocks are in your stock yard.
6. You can also enter the bill wise receipts from customers and track the outstanding. (Although for more details reports I use another sheet)
7. You can track that which bills are shown in returns and which are pending (assume you receive bills late, missed due to some reasons etc)
8. Freight Payments / Deductions : -Auto calculate the freight payable and track with accounts.
Many More functions has been added whichever and whenever I felt the importance of any thing I have tried to add that one.
Download this Excel Utility
Download this Excel Utility
Comments
Post a Comment