Excel2Tally-Automation_Payroll

Import Payroll entries direct into Tally

This is Excel to Tally Automation to Import your Payroll/Salary Data into Tally with Easy and quick way. With this software we can import Employee Masters, Attendance and Payroll Vouchers with every detail. With this payroll import sheet we can also do Payment and Journal entries related to Employees. It work perfectly with Tally ERP9 and Tally Prime. It holds below features that make it best Excel to Tally Payroll Data Import software :

  • Real time connection with Tally
  • Direct One Click entry.
  • Auto Calculation columns of Cell address, with Validate Button
  • Every time 25000 Entries with one click
  • Small and supportive file, work with every version of Excel
  • Support multi employee and multi deduction and collection ledger for each voucher.
  • Most simple import process make it best in this segment.
How to use Excel to Tally Payroll Utility

Master and Voucher Import Facilities:

Master Import:

This Excel to Tally – Payroll Data import software have below master creation sheet.

Employee Masters:

  1. OWN GROUP AND CATEGORY
  2. ALIAS AND EMPLOYEE CODE
  3. FULL ADDRESS, DESIGNATION, JOINING DATE, RESIGNING DATE, WITH FULL CONTACT DETAILS.
  4. FULL BANK DETAILS INFORMATION
  5. FULL STATUTORY DETAILS INFORMATION
  6. ALL GENERAL INFORMATION
  7. MULTI PAY HEAD OPTIONS WITH AMOUNT TO GENERATE PERFECT PAYSLIP

Voucher Import:

  • Vouchers with multi expense/deduction and income/addition (payhead ledgers) in single voucher.
  • Vouchers with multi employee in single voucher
  • Use your own voucher type.
  • Supportive for Payable Accounts, bank and cash transaction

Import Vouchers with below facilities :

ATTENDANCE VOUCHER:

  1. ATTENDANCE WITH UNLIMITED EMPLOYEES
  2. WITH ALL DETAILS – WORKING DAYS, WORKING HOURS OR ANY OTHER FORM OF WORK.
  3. WITH AUTO CELL ADDRESS FOR MULTIPLE VOUCHERS WITH MULTIPLE EMPLOYEES.
  4. DO ALL MONTHS ENTRY WITH SINGLE SHEET AT A TIME.
  5. POST ENTRIES WITH OWN VOUCHER TYPE
  6. DIRECT ENTRY POSTING (NO XML REQUIRED)
  7. WITH VALIDATE AND POST IN TALLY BUTTON
  8. UP TO 25000 ENTRY AT A TIME

PAYROLL VOUCHER:

  1. VOUCHER WITH UNLIMITED EMPLOYEE.
  2. VOUCHER WITH MULTI PAY HEADS AND MULTI DEDUCTION HEADS.
  3. VOUCHER WITH MULTI COST CATEGORY.
  4. PAYSLIPS WILL BE GENERATED AUTOMATICALLY.
  5. WITH AUTO CELL ADDRESS FOR MULTIPLE VOUCHERS WITH MULTIPLE EMPLOYEES.
  6. VOUCHER CAN USE FOR BANK, CASH WITH PAYABLE ACCOUNTS
  7. ALSO CAN USE IT FOR PAYMENT OR JOURNAL OR OTHER VOUCHERS THAT NEED TO FILL COST CENTER/EMPLOYEE NAME
  8. YOUR OWN VOUCHER TYPE
  9. WITH VALIDATE AND POST IN TALLY BUTTON
  10. UPTO 25000 ENTRIES AT A TIME

Leave a Reply

Your email address will not be published. Required fields are marked *