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

by with No Comment Tally

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☑️

by with No Comment TDL for Tally

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☑️

by with No Comment Excel

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 ☑️

by with No Comment Excel VBA
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 :