GSTIN TRACKER – Make your own ☑️

NOW GST IN INDIA, TRACK CORRECT GSTIN

In VAT time we were search for TIN number, and there  also available lots of websites to search correct TIN number with address. But now we use GST. And we track GSTIN in gst.gov.in.
 In GST website you must have PAN or GST number to track it correctly. 
But now we can track GST details with our Excel sheet. Just make your parties GST List, It will show you the State and GST type instantly. To make this GST tracker sheet you need to put some simple formula with your GST list.

FORMULAS:

We can use below formulas : 
1. As we know the GST total characters are 15, so we can calculate number of characters with this formula : =IF(B3=””,””,LEN(B3))
There B3 is Cell address of your GST number.  
2. We can create GST State and there codes in second sheet  and put this formula to calculate GST state : =IF(B3=””,””,IFERROR(VLOOKUP(MID(B3,1,2),STATE!$A$2:$B$38,2,FALSE),FALSE))
There B3 is GST Cell address. It search in State sheet with range from A2 to B38.
3. Also we can create a list of GST Type in State sheet  Like :
      
A — Association of Persons (AOP)
B — Body of Individuals (BOI)
C — Company
F — Firm
G — Government
H — HUF(Hindu Undivided Family)
J — Artificial Juridical Person
L — Local Authority
P — Person
T — AOP (Trust)

And we use =IF(B3=””,””,IFERROR(VLOOKUP(MID(B3,6,1),STATE!$C$1:$D$38,2,FALSE),FALSE)) formula to track GST type.

You can see above video for more details.

Also can download GST tracker with below download Link :

Tally ERP 9 – How to See User Wise Entry

IF YOU HAVE TWO OR MORE WORKER, THIS IS FOR YOU

Tally have many interesting features. In this segment today we see user wise entries. With this feature we can see, which user work more or take more entries. It is very interesting and must use feature of Tally.

How to see Tally User Wise Voucher Entry : 

If you have two or more workers and created there separate User Id, you can use this feature.
How to use this feature, please follow these  instructions : 
1. First we need to crate users : 
    To create Users goto Tally – Press Alt+F3 – Security Control – Users and password
    Create here user type  and there User Id and Password.
    You can also decide users security type and password policy.
2.  To display report : 
     To see user wise entry report goto Tally – Display – Statements of Accounts – Tally Audit – Users
     You will find user wise report. When you enter in users, can see there vouchers entered by them.
You need to enable Tally Audit feature to showing this report.
For More detail watch the above video.
      
 

Tally ERP 9 – How to See Two or More Companies Balances in One Place☑️

IF YOU MAINTAIN MULTIPLE BRANCHES OR SISTER CONCERN, THIS IS FOR YOU

Sometime when our business increased and we create more branches or sister concerns and maintain different companies in Tally, we need to merge in one company to create balances sheet and profit loss account.
To merge two or more companies in one we can do two things : 
1 . Import other companies data into One.
2 . Display all company data in one place through balance sheet.
In first method we need  time and accuracy to set two or more companies in one, because of its opening, voucher quantity, duplicate ledgers , groups etc.
For this we can use third party software Like Excel2Tally  Data converter etc.
In second method we need to open all companies in one one tally and can follow the above video instructions. 
But in this method you can see balances only through balance sheet.
If you really want to merge two or more companies data into one the method will work perfectly.
(Take Tally data backup always before do any new things.)

Tally ERP 9 – Item Purchase History – Sale Time☑️

ITEM PURCHASE HISTORY AT VOUCHER ENTRY TIME

Tally is most amazing and easy to use Accounting Software. In Asia most countries use Tally for there business. And in India after GST coming it’s users increased more. 
Tally is very simple software and lass with great features. We can make it more simple and more useful by adding some TDL (Tally Definition Language) files. And today I have something special for your Tally.
By this TDL we can see Item purchase history at sale time or at entry time of vouchers.
It will help us to see it’s purchase cost along with discount and quantity etc.
For how it will work please watch the above video.

How to set TDL file in Tally : 

1. Download the TDL file with provided link
2. Select TDL file and right click on it – goto security – Copy the path
3. Open Tally – Press F12 – Press F4
4. Paste the path in blank cell (to paste use Alt+Ctrl+V) and press enter to save.
Now your TDL file is ready to use.
How to use this TDL file in voucher, Please watch the above video.
To download Item purchase history TDL go through below download link :

ADVANCE CHEQUE REGISTER☑️

IT IS VERY HELPFUL TO TRACK YOUR CHEQUES

In every business most of our transactions we do with cheques. And need to maintain a cheque register manually or computerised. If you use computer to maintain to follow cheques clearing etc, this for you. 
By this you can also maintain your payable  with payment priority. It will show you high priority, low priority for your vendor payments.
You can also use it to track your bank deposits, clearing etc.
It has all columns that you want to use. If you need more columns with this sheet you can add your own. By this cheque register you can do your work smoothly.
It is very simple to use. Just write your cheque details and click on small boxes, to track it’s clearing.
It also show you priority of cheques. It will be very helpful to track payments and receipts.
You can download it with below download button : 
ADVANCE CHEQUE REGISTER WILL BE VERY HELPFUL FOR YOUR BANKING

Salary Sheet and Payslip – Auto Generator ☑️

In every business we appoints workers or employees to do all things smoothly. After appointing an employee we need to pay salary to him monthly or hourly. For this also we need to take calculation for there working days or hours. For it we prepare there attendances and salary sheets. After these workings we pay to our employees.
Sometime we need to give all these details to our employee and collect also for our our records.
Because Salary is important part of a company.
For your records I have something special for you.
It is Salary – Auto Generator with VBA Codings.
You can maintain your employees salary and Salary slips with this excel worksheet like a pro.
A Salary slip is a document issued by an employer to an employee. It contains a detailed description of the employee’s salary components like, basic , HRA, or other additions and deductions.
And salary slip is very important paper for an employee.
By this you can generate Lots of Salary slips and print them all with one click.
It has two sheets :
Payroll : In this sheet you can maintain salary of employees or workers
Salary Slip : In this sheet you can generate salary slips and print it on paper or can save in pdf

It is very useful for H.R. and Accountants also for firms who made salary in big companies.

YOU CAN DOWNLOAD SALARY SHEET WITH AUTO SLIP GENERATOR WITH THE BELOW LINK :