Payroll Hub
Extension for Zoho Books

Payroll Hub Extension for Zoho Books

The Payroll Hub Extension for Zoho Books uses Keypay Payroll, a powerful cloud payroll system that is well regarded by the industry and has single touch payroll and an employee self-service portal. This is fully integrated into the Zoho environment including Zoho CRM, Zoho Books and Zoho People.

Key Features

  • Effortlessly sync various Zoho People modules with Keypay, like Employees, Location, Leaves, Time-sheet, and Expenses. You can also sync your Journal data from Keypay software with Zoho Books by selecting the organization and journal account.
  • The security features look ensure your data is secure and encrypts your organization’s sensitive information to the highest degree.
  • Easily customize the field mapping of Employees, Leaves, Time-sheet, and Expenses Modules.
  • View all records, along with explanations for sync failures and other errors.

Model Fields of Australian Region

1. Employee

Name Type Description
Afs Debt boolean Nullable
Anniversary Date date-time Nullable
Australian Resident boolean Nullable
Automatically Pay Employee string Required
Bank Account1 - Account Name string Required
Bank Account1 - Account Number string Required
Bank Account1 - Allocated Percentage double Nullable
Bank Account1 - BSB string Required
Bank Account1 - Fixed Amount double Nullable
Bank Account2 - Account Name string Required
Bank Account2 - Account Number string Required
Bank Account2 - Allocated Percentage double Nullable
Bank Account2 - BSB string Required
Bank Account2 - Fixed Amount double Nullable
Bank Account3 - Account Name string Required
Bank Account3 - Account Number string Required
Bank Account3 - Allocated Percentage double Nullable
Bank Account3 - BSB string Required
Bank Account3 - Fixed Amount double Nullable
Claim Tax Free Threshold boolean Nullable
Closely Held Employee boolean Nullable
Date Created date-time Required
Date of Birth date-time Nullable
Date Tax File Declaration Reported date-time Nullable
Date Tax File Declaration Signed date-time Nullable
Email Address string Required
Emergency Contact1 - Address string Required
Emergency Contact1 - Alternate Contact Number string Required
Emergency Contact1 - Contact Number string Required
Emergency Contact1 - Name string Required
Emergency Contact1 - Relationship string Required
Emergency Contact2 - Address string Required
Emergency Contact2 - Alternate Contact Number string Required
Emergency Contact2 - Contact Number string Required
Emergency Contact2 - Name string Required
Emergency Contact2 - Relationship string Required
Employing Entity ABN string Required
Employing Entity Id string Required
Employment Agreement string Required
Employment Type string Required
Note: Value should match ‘Employment Type’ in keypay
End Date date-time Nullable
First Name string Required
Gender string Required
Has Approved Working Holiday Visa boolean Nullable
Has Withholding Variation boolean Nullable
Help Debt boolean Nullable
Home Phone string Required
Hours Per Day double Nullable
Hours Per Week double Nullable
Is Enabled For Times-heets string Required
Is Exempt From Flood Levy boolean Nullable
Is Exempt From Payroll Tax boolean Nullable
Job Title string Required
Leave Accrual Start Date Type string Nullable

Possible values are:

  • EmployeeStartDate
  • SpecifiedDate
Leave Template string Required
Leave Year Start date-time Nullable
Locations string Required
Maximum Quarterly Super Contributions Base double Nullable
Medicare Levy Exemption string Required
Middle Name string Required
Mobile Phone string Required
Other Tax Offset boolean Nullable
Override Template Rate string Required
Pay Condition Rule Set string Required
Pay Rate Template string Required
Pay Schedule string Required
Pay Slip Notification Type string Required
Postal Address Line2 string Required
Postal Country string Required
Postal PostCode string Required
Postal State string Required
Postal Street Address string Required
Postal Suburb string Required
Preferred Name string Required
Previous Surname string Required
Primary Location string Required
Primary Pay Category string Required
Rate double Nullable
Rate Unit string Required
Residential Address Line2 string Required
Residential Country string Required
Residential Post Code string Required
Residential State string Required
Residential Street Address string Required
Residential Suburb string Required
Rostering Notification Choices string Required
Seniors Tax Offset boolean Nullable
Start Date date-time Nullable
Status string EmployeeStatusEnum

Possible values are:

  • Active
  • Terminated
  • Incomplete
Super Fund1 - Allocated Percentage double Nullable
Super Fund1 - Employer Nominated Fund boolean Nullable
Super Fund1 - Fixed Amount double Nullable
Super Fund1 - Fund Name string Required
Super Fund1 - Member Number string Required
Super Fund1 - Product Code string Required
Super Fund2 - Allocated Percentage double Nullable
Super Fund2 - Employer Nominated Fund boolean Nullable
Super Fund2 - Fixed Amount double Nullable
Super Fund2 - Fund Name string Required
Super Fund2 - Member Number string Required
Super Fund2 - Product Code string Required
Super Fund3 - Allocated Percentage double Nullable
Super Fund3 - Employer Nominated Fund boolean Nullable
Super Fund3 - Fixed Amount double Nullable
Super Fund3 - Fund Name string Required
Super Fund3 - Member Number string Required
Super Fund3 - Product Code string Required
Super Threshold Amount double Nullable
Surname string Required
Tags string Required
Tax File Number string Required
Tax Variation double Nullable
Title string Required
Work Phone string Required
Work Types string Required

2. Leave

Name Type Description
From Date date-time

Required
Hours double

Required
Leave Type string

Required
Note: Value should match ‘Leave Category’ in Keypay

Notes string String
To Date date-time

Required

3. Timesheets

Name Type Description
Comments string Required
End Time date-time Required
Leave Category string Nullable
Note: Value should match ‘Leave Category’ in Keypay
Location string Nullable
Note: It should be the lookup of Location module.
Pay Category string Nullable
Note: Value should match 'Pay Category’ in Keypay
Rate double Required
Start Time date-time Required
Status string Required
Units double Nullable
Work Type string Required

4. Expense

Name Type Description
Description string Required
Expenses array Required
Expenses - Amount double Required
Expenses - Date Incurred date-time Required
Expenses - Expense Category string Required
Note: Value should match Expenses Category’ in Keypay.
Expenses - Location string Nullable
Note: It should be the lookup of Location module.
Expenses - Notes string Required
Expenses - Tax Code string Required
Expenses - Tax Rate double Nullable
Expense form should be like below:

Model Fields of United Kingdom Region

1. Employee

Name Type Description
Anniversary Date date-time Nullable
Appointment End Date date-time Nullable
Appointment Start Date date-time Nullable
Assessment Date date-time Nullable
Assessment Status string Required
Automatically Pay Employee string Required
Bank Account1 - Account Name string Required
Bank Account1 - Account Number string Required
Bank Account1 - Allocated Percentage double Nullable
Bank Account1 - Fixed Amount double Nullable
Bank Account1 - Roll Number string Required
Bank Account1 - Sort Code string Required
Bank Account2 - Account Name string Required
Bank Account2 - Account Number string Required
Bank Account2 - Allocated Percentage double Nullable
Bank Account2 - Fixed Amount double Nullable
Bank Account2 - Roll Number string Required
Bank Account2 - Sort Code string Required
Bank Account3 - Account Name string Required
Bank Account3 - Account Number string Required
Bank Account3 - Allocated Percentage double Nullable
Bank Account3 - Fixed Amount double Nullable
Bank Account3 - Roll Number string Required
Bank Account3 - Sort Code string Required
Date Created date-time Required
Date Of Birth date-time Nullable
Email Address string Required
Emergency Contact1 - Address string Required
Emergency Contact1 - Alternate Contact Number string Required
Emergency Contact1 - Contact Number string Required
Emergency Contact1 - Name string Required
Emergency Contact1 - Relationship string Required
Emergency Contact2 - Address string Required
Emergency Contact2 - Alternate Contact Number string Required
Emergency Contact2 - Contact Number string Required
Emergency Contact2 - Name string Required
Emergency Contact2 - Relationship string Required
Employee Paid Irregularly string Required
Employee Starter Type string Required
Employee Statement string Required
Employment Type string Required
Note: Value should match ‘Employment Type’ in keypay
End Date date-time Nullable
First Name string Required
Gender string Required
Has Post Grad Loan boolean Boolean
Has Student Loan boolean Boolean
Home Phone string Required
Hours Per Week double Nullable
Is Apprentice string Required
Is Company Director string Required
Is Enabled For Time-sheets string Required
Is Exempt From Minimum Wage string Required
Job Title string Required
Leave Accrual Start Date Type string Nullable

Possible values are:

  • EmployeeStartDate
  • SpecifiedDate
Leave Template string Required
Leave Year Start date-time Nullable
Locations string Required
Middle Name string Required
Mobile Phone string Required
National Insurance Calculation Method string Required
National Insurance Category string Required
National Insurance Number string Required
Opt-In Date date-time Nullable
Override Template Rate string Required
Pay Condition Rule Set string Required
Pay Rate Template string Required
Pay Schedule string Required
Pay Slip Notification Type string Required
Pay Roll Id string Required
Pension Assessment Option string Required
Pension Contribution Group string Required
Postal Address-Line2 string Required
Postal City string Required
Postal Country string Required
Postal County string Required
Postal Post Code string Required
Postal Street Address string Required
Preferred Name string Required
Previous Employer Continue Student Loan Deductions boolean Nullable
Previous Employer Leaving Date date-time Nullable
Previous Employer Office Number string Required
Previous Employer Reference Number string Required
Previous Employer Tax Code string Required
Previous Employer Tax Period Frequency string Required
Previous Employer Tax Period Number int32 Nullable
Previous Employer Tax With held double Nullable
Previous Employer Taxable Pay double Nullable
Previous Employer W1 M1 boolean Nullable
Primary Location string Required
Primary Pay Category string Required
Rate double Nullable
Rate Unit string Required
Residential Address-Line2 string Required
Residential City string Required
Residential Country string Required
Residential County string Required
Residential Post Code string Required
Residential Street Address string Required
Rostering Notification Choices string Required
Start Date date-time Nullable
Status string EmployeeStatusEnum

Possible values are:

  • Active
  • Terminated
  • Incomplete
Student Loan Type string Required
Surname string Required
Tags string Required
Tax Calculation Method string Required
Tax Code string Required
Title string Required
Work Phone string Required
Work Types string Required

2. Leave

Name Type Description
From Date date-time

Required
Leave Type string

Required
Note: Value should match ‘Leave Category’ in Keypay

Notes string String
To Date date-time

Required
Units double

Required

3. Timesheets

Name Type Description
Comments string Required
End Time date-time Required
Leave Category string Nullable
Note: Value should match ‘Leave Category’ in Keypay
Location string Nullable
Note: It should be the lookup of Location module.
Pay Category string Nullable
Note: Value should match 'Pay Category’ in Keypay
Rate double Required
Start Time date-time Required
Status string Required
Units double Nullable
Work Type string Required

4. Expense

Name Type Description
Description string Required
Expenses array Required
Expenses - Amount double Required
Expenses - Date Incurred date-time Required
Expenses - Expense Category string Required
Note: Value should match Expenses Category’ in Keypay.
Expenses - Location string Nullable
Note: It should be the lookup of Location module.
Expenses - Notes string Required
Expenses - Tax Code string Required
Expenses - Tax Rate double Nullable
Expense form should be like below:

Model Fields of New Zealand Region

1. Employee

Name Type Description
Anniversary Date date-time Nullable
Automatically Pay Employee string Required
Bank Account1 - Account Name string Required
Bank Account1 - Account Number string Required
Bank Account1 - Allocated Percentage double Nullable
Bank Account1 - Bank Code string Required
Bank Account1 - Fixed Amount double Nullable
Bank Account2 - Account Name string Required
Bank Account2 - Account Number string Required
Bank Account2 - Allocated Percentage double Nullable
Bank Account2 - Bank Code string Required
Bank Account2 - Fixed Amount double Nullable
Bank Account3 - Account Name string Required
Bank Account3 - Account Number string Required
Bank Account3 - Allocated Percentage double Nullable
Bank Account3 - Bank Code string Required
Bank Account3 - Fixed Amount double Nullable
Date Created date-time DateTime
Date Of Birth date-time Nullable
Email Address string Required
Emergency Contact1 - Address string Required
Emergency Contact1 - Alternate Contact Number string Required
Emergency Contact1 - Contact Number string Required
Emergency Contact1 - Name string Required
Emergency Contact1 - Relationship string Required
Emergency Contact2 - Address string Required
Emergency Contact2 - Alternate Contact Number string Required
Emergency Contact2 - Contact Number string Required
Emergency Contact2 - Name string Required
Emergency Contact2 - Relationship string Required
Employing Entity Id string Required
Employing Entity NZBN string Required
Employment Type string Required
Note: Value should match ‘Employment Type’ in keypay
End Date date-time Nullable
First Name string Required
Gender string Required
Home Phone string Required
Hours Per Day double Nullable
Hours Per Week double Nullable
Is Enabled For Time-sheets string Required
Job Title string Required
Kiwi Saver - Employee Contribution int32 Nullable
Kiwi Saver - Employer Contribution int32 Nullable
Kiwi Saver - Enrollment Status string Required
Kiwi Saver - Ineligibility Reason string Required
Kiwi Saver - Opt-Out Date date-time Nullable
Kiwi Saver - Savings Suspension From Date date-time Nullable
Kiwi Saver - Savings Suspension To Date date-time Nullable
Leave Accrual Start Date Type string Nullable

Possible values are:

  • EmployeeStartDate
  • SpecifiedDate
Leave Template string Required
Leave Year Start date-time Nullable
Locations string Required
Middle Name string Required
Mobile Phone string Required
Override Template Rate string Required
Pay Condition Rule Set string Required
Pay Rate Template string Required
Pay Schedule string Required
Pay Slip Notification Type string Required
Postal Address Line2 string Required
Postal Country string Required
Postal Post Code string Required
Postal State string Required
Postal Street Address string Required
Postal Suburb string Required
Preferred Name string Required
Previous Surname string Required
Primary Location string Required
Primary Pay Category string Required
Rate double Nullable
Rate Unit string Required
Residential Address Line2 string Required
Residential Country string Required
Residential Post Code string Required
Residential State string Required
Residential Street Address string Required
Residential Suburb string Required
Rostering Notification Choices string Required
Start Date date-time Nullable
Status string EmployeeStatusEnum

Possible values are:

  • Active
  • Terminated
  • Incomplete
Surname string Required
Tags string Required
Tax Code Declaration - Date Signed date-time Nullable
Tax Code Declaration - Elected Extra Pay Rate double Nullable
Tax Code Declaration - ESCT Rate double Nullable
Tax Code Declaration - FTC Overseas Super Or Pension boolean Nullable
Tax Code Declaration - Income Applied To Tested Benefit boolean Nullable
Tax Code Declaration - Income Band int32 Nullable
Tax Code Declaration - IRD Number string Required
Tax Code Declaration - Irregular Employment boolean Nullable
Tax Code Declaration - Is Non-Disclosed boolean Nullable
Tax Code Declaration - Is Primary Income boolean Nullable
Tax Code Declaration - Meets Main Income Means Test boolean Nullable
Tax Code Declaration - New Zealand Resident boolean Nullable
Tax Code Declaration - Special Tax Code string Required
Tax Code Declaration - Special Tax Code Rate double Nullable
Tax Code Declaration - Special Tax Code Rate End-Date date-time Nullable
Tax Code Declaration - Student Loan boolean Nullable
Tax Code Declaration - Student Loan Rate double Nullable
Tax Code Declaration - Student Loan Rate End-Date date-time Nullable
Title string Required
Work Phone string Required
Work Types string Required

2. Leave

Name Type Description
From Date date-time

Required
Leave Type string

Required
Note: Value should match ‘Leave Category’ in Keypay

Notes string String
To Date date-time

Required
Units double

Required

3. Timesheets

Name Type Description
Comments string Required
End Time date-time Required
Leave Category string Nullable
Note: Value should match ‘Leave Category’ in Keypay
Location string Nullable
Note: It should be the lookup of Location module.
Pay Category string Nullable
Note: Value should match 'Pay Category’ in Keypay
Rate double Required
Start Time date-time Required
Status string Required
Units double Nullable
Work Type string Required

4. Expense

Name Type Description
Description string Required
Expenses array Required
Expenses - Amount double Required
Expenses - Date Incurred date-time Required
Expenses - Expense Category string Required
Note: Value should match Expenses Category’ in Keypay.
Expenses - Location string Nullable
Note: It should be the lookup of Location module.
Expenses - Notes string Required
Expenses - Tax Code string Required
Expenses - Tax Rate double Nullable
Expense form should be like below:

Model Fields of Singapore Region

1. Employee

Name Type Description
Anniversary Date date-time Nullable
Apply Full CPF Rate boolean Nullable
Automatically Pay Employee string Required
Bank Account1 - Account Name string Required
Bank Account1 - Account Number string Required
Bank Account1 - Allocated Percentage double Nullable
Bank Account1 - Bank Swift string Required
Bank Account1 - Branch Code string Required
Bank Account1 - Fixed Amount double Nullable
Bank Account2 - AccountName string Required
Bank Account2 - Account Number string Required
Bank Account2 - Allocated Percentage double Nullable
Bank Account2 - Bank Swift string Required
Bank Account2 - Branch Code string Required
Bank Account2 - Fixed Amount double Nullable
Bank Account3 - Account Name string Required
Bank Account3 - Account Number string Required
Bank Account3 - Allocated Percentage double Nullable
Bank Account3 - Bank Swift string Required
Bank Account3 - Branch Code string Required
Bank Account3 - Fixed Amount double Nullable
Covered By Employment Act string Required
Cpf Exempt boolean Nullable
Date Created date-time Required
Date Of Birth date-time Nullable
Email Address string Required
Emergency Contact1 - Address string Required
Emergency Contact1 - Alternate Contact Number string Required
Emergency Contact1 - Contact Number string Required
Emergency Contact1 - Name string Required
Emergency Contact1 - Relationship string Required
Emergency Contact2 - Address string Required
Emergency Contact2 - Alternate Contact Number string Required
Emergency Contact2 - Contact Number string Required
Emergency Contact2 - Name string Required
Emergency Contact2\ - Relationship string Required
Employee Group string Required
Employing Entity Id string Required
Employing Entity UEN string Required
Employment Type string Required
Note: Value should match ‘Employment Type’ in keypay
End Date date-time Nullable
Ethnicity string Required
External Id string Required
First Name string Required
Gender string Required
Home Phone string Required
Hours Per Day double Nullable
Hours Per Week double Nullable
Is Enabled For Timesheets string Required
Job Title string Required
Leave Accrual Start Date Type string Nullable

Possible values are:

  • EmployeeStartDate
  • SpecifiedDate
Leave Template string Required
Leave Year Start date-time Nullable
Legal Status string Required
Locations string Required
Middle Name string Required
Mobile Phone string Required
National Registration Identity Expiry Date date-time Nullable
National Registration Identity Number string Required
Nationality string Required
Obtained Residency Date date-time Nullable
Override Template Rate string Required
Pay Condition Rule Set string Required
Pay Rate Template string Required
Pay Schedule string Required
PaySlip Notification Type string Required
Postal Address Line2 string Required
Postal Address Line3 string Required
Postal Address Type string Nullable

Possible values are:

  • LocalAddress
  • ForeignAddress
  • LocalCareOfAddress
Postal Block Number string Required
Postal Country string Required
Postal Level Number string Required
Postal PostCode string Required
Postal State string Required
Postal Street Address string Required
Postal Street Name string Required
Postal Suburb string Required
Postal Unit Number string Required
Preferred Name string Required
Primary Location string Required
Primary Pay Category string Required
Rate double Nullable
Rate Unit string Required
Religion string Required
Residential Address Line2 string Required
Residential Address Line3 string Required
Residential Address Type string Address Type Enum

Possible values are:

  • LocalAddress
  • ForeignAddress
  • LocalCareOfAddress
Residential Block Number string Required
Residential Country string Required
Residential Level Number string Required
Residential PostCode string Required
Residential State string Required
Residential Street Address string Required
Residential Street Name string Required
Residential Suburb string Required
Residential Unit Number string Required
Rostering Notification Choices string Required
SDL Exempt boolean Nullable
Start Date date-time Nullable
Status string EmployeeStatusEnum

Possible values are:

  • Active
  • Terminated
  • Incomplete
Surname string Required
Tags string Required
Tiered Leave Template string Required
Title string Required
Work Phone string Required
Work Types string Required

2. Leave

Name Type Description
From Date date-time

Required
Hours double

Required
Leave Type string

Required
Note: Value should match ‘Leave Category’ in Keypay

Notes string String
To Date date-time

Required

3. Timesheets

Name Type Description
Comments string Required
End Time date-time Required
Leave Category string Nullable
Note: Value should match ‘Leave Category’ in Keypay
Location string Nullable
Note: It should be the lookup of Location module.
Pay Category string Nullable
Note: Value should match 'Pay Category’ in Keypay
Rate double Required
Start Time date-time Required
Status string Required
Units double Nullable
Work Type string Required

4. Expense

Name Type Description
Description string Required
Expenses array Required
Expenses - Amount double Required
Expenses - Date Incurred date-time Required
Expenses - Expense Category string Required
Note: Value should match Expenses Category’ in Keypay.
Expenses - Location string Nullable
Note: It should be the lookup of Location module.
Expenses - Notes string Required
Expenses - Tax Code string Required
Expenses - Tax Rate double Nullable
Expense form should be like below: