---
title: Year-to-Date (YTD) Import Fields Guide
description: Below is some useful guidance on the expected input for each field of the YTD import template.
---

[Skip to content](https://support.ocerli.com/en/ocerli-knowledge-base/year-to-date-ytd-fields-guide#main-content)

English

Show submenu for translations

[![1073 Ocerli Logos RGB\_Ocerli-Logo-ClearSkyBlue](https://support.ocerli.com/hs-fs/hubfs/1073%20Ocerli%20Logos%20RGB_Ocerli-Logo-ClearSkyBlue.png?width=200&height=82&name=1073%20Ocerli%20Logos%20RGB_Ocerli-Logo-ClearSkyBlue.png)](https://144147338.hs-sites-eu1.com/ocerli-knowledge-base?hsLang=en)

- [Back to App](https://app.ocerli.com)
- [What's New](https://app-eu1.hubspot.com/knowledge-article/144147338/editor/353284586703/preview)

Open main navigation

Close main navigation

- [Back to App](https://app.ocerli.com)
- [What's New](https://app-eu1.hubspot.com/knowledge-article/144147338/editor/353284586703/preview)
- English
  
  Show submenu for translations
- [Contact us](https://share-eu1.hsforms.com/1HogeT6kKQWyiH9o4PZAqtA2dtksq)

[Contact us](https://share-eu1.hsforms.com/1HogeT6kKQWyiH9o4PZAqtA2dtksq)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Ocerli](https://support.ocerli.com/en/ocerli-knowledge-base?hsLang=en)
2. [Getting started](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en)
3. [Organisation Imports](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#organisation-imports-1)

# Year-to-Date (YTD) Import Fields Guide

## Below is some useful guidance on the expected input for each field of the YTD import template:

| **Field** | **Description** |
| --- | --- |
| Pay Date | Final pay date of the period being imported (DD/MM/YYYY) |
| Pay Start | Start of the pay period being imported (DD/MM/YYYY) |
| Pay End | End of the pay period being imported (DD/MM/YYYY) |
| Total Allowances | Total of all allowances for the period |
| Total Taxable Allowances | Total of all taxable allowances for the period |
| Total Deductions | Total of all deductions for the period (including but not limited to tax, social contributions, pension and savings) |
| Total Employer | Total of all employer contributions for the period (including but not limited to social, pension and savings) |
| Tax Paid Employee | Total of all taxes deducted for the period |
| Total Social Insurance Employee | Total employee social contributions for the period |
| Total Social Insurance Employer | Total employer social contributions for the period |
| Pension Paid Employee Unapproved | Total of all employee pension contributions to unapproved (private) pension scheme(s) |
| Pension Paid Employee Approved | Total of all employee pension contributions to Government-approved pension scheme(s) |
| Pension Paid Employer | Total of all employer pension contributions |
| Net Pay | Total employee net pay received for the period |
| Savings Employee | Total of all employee contributions to a savings scheme |
| Savings Employer | Total of all employer contributions to a savings scheme |
| Total Taxable Net | Total Taxable NET for all payslips is calculated as taxable allowances - taxable deductions |
| Gsy Taxable Gross | Gsy Taxable Gross is calculated as Taxable Net + Employee Approved Pension contribution(s) |

 

- [Getting started](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#main-content)

    - [Your Account Details](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#your-account-details)
    - [Navigating the App](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#navigating-the-app)
    - [Users](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#users)
    - [Organisation Imports](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#organisation-imports-1)
    - [Jersey Organisation Imports](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#jersey-organisation-imports)
    - [Organisation Set Up](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#organisation-set-up)
    - [Add New Organisation](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#add-new-organisation)
    - [Add New Employees](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#add-new-employees)
    - [Jersey Employees](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#jersey-employees)
    - [Workflows](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#workflows)
    - [Pay Elements](https://support.ocerli.com/en/ocerli-knowledge-base/getting-started?hsLang=en#pay-elements)
- [Submissions](https://support.ocerli.com/en/ocerli-knowledge-base/submissions?hsLang=en#main-content)

    - [Jersey](https://support.ocerli.com/en/ocerli-knowledge-base/submissions?hsLang=en#jersey)
    - [Guernsey](https://support.ocerli.com/en/ocerli-knowledge-base/submissions?hsLang=en#guernsey)
    - [Submission Module](https://support.ocerli.com/en/ocerli-knowledge-base/submissions?hsLang=en#submission-module)
- [Pensions](https://support.ocerli.com/en/ocerli-knowledge-base/pensions?hsLang=en#main-content)

    - [Guernsey](https://support.ocerli.com/en/ocerli-knowledge-base/pensions?hsLang=en#guernsey)
    - [Guernsey Pay Element Settings](https://support.ocerli.com/en/ocerli-knowledge-base/pensions?hsLang=en#guernsey-pay-element-settings)
- [App & Integrations](https://support.ocerli.com/en/ocerli-knowledge-base/app-integrations?hsLang=en#main-content)

    - [Xero](https://support.ocerli.com/en/ocerli-knowledge-base/app-integrations?hsLang=en#xero)
    - [PeopleHR](https://support.ocerli.com/en/ocerli-knowledge-base/app-integrations?hsLang=en#peoplehr)
    - [QuickBooks](https://support.ocerli.com/en/ocerli-knowledge-base/app-integrations?hsLang=en#quickbooks)
- [More Resources](https://support.ocerli.com/en/ocerli-knowledge-base/more-resources?hsLang=en#main-content)

    - [App Updates](https://support.ocerli.com/en/ocerli-knowledge-base/more-resources?hsLang=en#app-updates)
- [Troubleshooting](https://support.ocerli.com/en/ocerli-knowledge-base/troubleshooting?hsLang=en#main-content)

    - [Isle of Man](https://support.ocerli.com/en/ocerli-knowledge-base/troubleshooting?hsLang=en#isle-of-man)
- [Payroll](https://support.ocerli.com/en/ocerli-knowledge-base/payroll?hsLang=en#main-content)

    - [Bulk Actions](https://support.ocerli.com/en/ocerli-knowledge-base/payroll?hsLang=en#bulk-actions)
    - [Run Payroll](https://support.ocerli.com/en/ocerli-knowledge-base/payroll?hsLang=en#run-payroll)
    - [Banking](https://support.ocerli.com/en/ocerli-knowledge-base/payroll?hsLang=en#banking)
- [Reporting](https://support.ocerli.com/en/ocerli-knowledge-base/reporting?hsLang=en)

[![1073 Ocerli Logos RGB\_Ocerli-Logo-ClearSkyBlue](https://support.ocerli.com/hs-fs/hubfs/1073%20Ocerli%20Logos%20RGB_Ocerli-Logo-ClearSkyBlue.png?width=180&height=74&name=1073%20Ocerli%20Logos%20RGB_Ocerli-Logo-ClearSkyBlue.png "1073 Ocerli Logos RGB_Ocerli-Logo-ClearSkyBlue")](http://offshorepayroll.com)

<https://www.facebook.com/ocerli> [mailto:support@ocerli.com](mailto:support@ocerli.com) <https://je.linkedin.com/company/ocerli>

Copyright © 2026, Ocerli