Skip to main content

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
Labels:

Comments

Post a Comment

Popular posts from this blog

How to Calculate Detention of Vehicles considering the complex Date & Time in excel

Some times it is difficult to calculate some cases which deals with Date & Time and calculating the Detention charges is one of them. Please download the excel file (and do remember that it has been prepared on the basis the following basis.... which can be changed with the help of formulas) https://drive.google.com/file/d/0Bw1qNoQ8YzHZY3E5VVl1SUduWm8/view?usp=sharing
2 comments
Read more

Sai Sampurna Padhi - A Sweet Bubbly Girl fighting for her life at Cuttack

Hello Everyone, Today I want to share with you all about a girl named "Sai Sampurna Padhi" Some details of this girl: - Name                   : - Sai Sampurna Padhi Age                       : - 2.5 Years Residence           : - Bidanasi, Cuttack, Odisha Father's Name    : - Linku Padhi Mother's Name   : - Chandrika Mohapatra Father's Occupation    : - Auto Driver at Badambadi Bus Stand, Cuttack This girl is admitted to SCB Medical College because she is suffering from a very dangerous disease called "Blood Cancer" and as its at Stage-I doctors has prescribed to go for Bone Marrow transplant as soon as possible so that this can be cured. But the operation cost around 20-25 Lacks which they can't arrange. For the time being, every week she has need of blood, plasma, test & medicine which is less as it is a government ho...
Post a Comment
Read more

Tally Trial Balance Consolidation Utility in excel

Hello Friends, Financial Year has ended recently and many of the accounts & finance professionals are ready for preparing the Balance Sheets. Many companies have operations at multiple locations and they prepare the accounts accordingly and at the end consolidate the data and prepare the Final Accounts. Normally the trial balances of each locations are consolidated and on that basis the Profit & Loss Accounts & Balance Sheets are prepared. Sometimes, the consolidation of Trial Balance is lengthy, tricky and difficult part for the accounts professionals although its a simple process of summarizing the transactions. So I am sharing an excel utility where upto 10 nos of Trial Balances (Tally Generated) can be consolidated within a minute. The Excel utility is self explanatory, but some basic points are mentioned here: - 1. You need to export Group Names of each locations from tally and paste in this file. 2. You need to export Trial Balance of each location from...
Post a Comment
Read more