It’s been a while I posted anything. It was all about Tally ERP 9. Was’t it? Here is something a little different, quite innovative technology and tools. I liked it, ‘coz I am able to do a lot out of it. Even more than I thought. I hope you are familiar with softwares like Smart-Sheet which offers task management. Last year I was looking for a tool through which I could co-ordinate with my team and also monitor the tasks that are being carried out by each assignee. Also I could know their work status without asking them. Similarly I do not have to mail every assignee the task or work assigned to them. While working with a team after assigning work to the team members, it is difficult to track their work progress and performance. I was searching for a team collaboration software in which day-to-day as [Read more…] about Smartsheet review :team collaboration
Blog
VAT Mismatch Handling – During Quarter Endings
VAT/CST – filing returns During Quarter endings
There is a common problem which customers face during VAT/CST returns especially during quarter ends.
The issue faced is:-
Suppose a customer’s supplier party A issues a bill on the 30th of June (invoice issued). The material is received on 9th July.
Now the mismatch arises if the customer shows the purchase in the second quarter (JAS) while the supplier has shown the sales in the AMJ quarter.
Actually, this can be handled easily in tally using receipt notes and purchase bills.
Even in case of interstate transfers, this can be handled as follows:-
Case 1:- When you get to know the purchase invoice date (same as the sales invoice date of supplier). This can be known from the website too as the way bill has to be given before they can release the material.
Entry is made as:-
www.tallynine.com [Read more…] about VAT Mismatch Handling – During Quarter Endings
accounting in garment industry using Tally.ERP 9
Tally.ERP 9 supports perfect accounting and business solution for almost every industry, trade and business. Here we will learn how to use Tally.ERP 9 in garment Industries where garments are rented and how to do accounting for garment in Tally.ERP 9
accounting in garment industry : problems
Case:- Customer wants to maintain his accounts/inventory of suits that he gives on rent. So, how the accounting in garment industry will be maintained in Tally.ERP 9 with inventory?
The customer would want to keep track of the suits given on rent, and their collection.
Let us see an example :-
We create ledgers
(our customer) – Mr Abc.
The sales ledger:-
The items that we have for renting out are :-
and the second item is 
We have created two items in the case. We [Read more…] about accounting in garment industry using Tally.ERP 9
CST entry in Tally.Erp 9| A practical approach with case study
CST entry in Tally ERP 9 helps to manage interstate transactions in a business because generally interstate sales and purchase require issue/receives various kind of statutory forms which is difficult to manage if we do not pass CSTentry in Tally.ERP 9 properly!
You should also read tutorials on VAT
How to create VAT Master Ledger in Tally.ERP 9
I also write about concept of Vat and if you pass a correct Sales Entry in Tally.ERP 9, then the software will give you perfect error free vat payable amount within few clicks!
CST refers to Interstate sales and purchase transactions. The article will describe the detailed procedure how to record CST in Tally.ERP 9.
Earlier we have discussed how to create VAT and cst purchase ledger in Tally.ERP 9 p
CST Entry in Tally ERP 9
An Engineering company has a limited number of clients, but has a few complex processes.
We will [Read more…] about CST entry in Tally.Erp 9| A practical approach with case study
Auto Distributorship Management
There is a segment of Car Distributors that purchase cars and then sell directly or resell to the outlets. Today in this tutorial we will learn how to manage Auto Distributorship Management in Tally.ERP 9.
Most of these car distributors have outlets and they are maintaining data branch wise. There is a need for maintaining even at branches,
Let us say the purchase of 10 cars is done by the branch 1, 5 by Branch 2 and 3 by Branch 3 and 20 By HO.
the entry for this is shown as :-
( The purchasing price of each automobile has been taken as 3,00,000) and the entry is made as :-
In case you are wondering why this purchase has been done in voucher mode, please recall this has been done because we have to use cost centres and cost centres can be used for purchase entries [Read more…] about Auto Distributorship Management
Construction Sector using cost centres
The construction sector involves a lot of complexity; however they can be well managed in tally.
The two most important requirements are that of managing a project wise expense and earnings and the other important thing is to be able to maintain a no- inventory Balance sheet and at the same time to be able to selectively manage inventory for some items/transactions.
Tally enables you to manage this beautifully, you only need to know a small trick in Tally.
First of all you need to be able to maintain cost centers ( not cost category) that should be used when you want a much more detailed report. For the time being most of the functions can be obtained by using the cost centers itself.
Here in the construction business we will take the example of purchasing bricks say at the rate of Rs. 8/ pc.
Now there can be two [Read more…] about Construction Sector using cost centres
Hospital Management – Tally.ERP 9
This tutorial Hospital Accounts in Tally.ERP 9, is a series of the Practical Case Studies Tutorials. This is the case of Hospital Management – Tally.ERP 9 wherein bulk purchases are made and then sales made to either Big hospitals or retail sales are made over the counter.
We will take the case where we will consider both the cases of managing specific customers and local over the counter customers.
Also, we have a case where in certain cases we have to mention the Purchase order against which the purchase is made. We will see how that is obtained from Tally.ERP 9.
Here we will use the concept of Price lists to cater to the different types of customers.
We create the regular sales/purchase vouchers and the surgical supplier Ledger is created as :-
Now, in this case, we have created only one item “Instrument A” and set its [Read more…] about Hospital Management – Tally.ERP 9
Payroll Management for a Bidi Manufacturer
The case study here is that of a local manufacturer of bidis. Let us say I am the owner, and I have a Admin Manager and an admin staff as employees.
I hire contractual workers and pay them as per their production. In this case study we will be focusing only on this payment pattern for such employees. For both regular and contractual employees.
Here we have created Group ledgers as admin and contractual workers. Under Admin, we will have the two employees and contractual workers group where we can keep adding the workers who would work under contract and pay them as per their productivity.
Let us first create an Employee Group Admin as,:-
www.tallynine.com
then the second step being :-
www.tallynine.comOnce the Define salary details is set to Yes , we will add the salary structure of the admin group as:-
www.tallynine.com
This is created by [Read more…] about Payroll Management for a Bidi Manufacturer
Tour and Travels Management in Tally.ERP 9
Today, we will study the case study of how to maintain Tour and Travels Management in Tally.ERP 9 along with practical examples. This is a pure service industry and there is no inventory as such, they have specific billing requirements and have a rebate of 60% to 75% even this is changeable.
We will take a case where a booking is done by a customer for traveling, food and other expense.
We will charge all of that and in addition to that charge a service tax. Now there is a rebate of 60% in this department. If you have a greater rebate, you can mention that with the SL/Notification number and can avail that abatement.
We have taken the customer by the name of Traveller.
Now when the customer comes to us, we do the booking of this – this is a sales order for us.
We create the ledgers [Read more…] about Tour and Travels Management in Tally.ERP 9
JOB Work For Gold Processing a case studt
In this business case study we have considered the business process of Gold jewellery making/polishing etc. This work is outsourced and in Tally’s language ( a Job Work Out ) is issued.
Let us say we are into the gold business and we need to convert the raw gold into a processed- one- Jewellery.
We will see the steps as:-
This raw gold is transferred to the job worker 1.
This Job worker works and processes it and sends it back to us.
The payment to the job worker is based on the no of gms he converts from Raw Gold into Jewellery. The general trend is 50 Rs /gm. ( Although most jewellery shops might tell you it is much higher and may charge the end user rates as high as 300 /gm- also known as making charge)
At this time, we should also be able to see our [Read more…] about JOB Work For Gold Processing a case studt