17.1 File Export

File Export

The file export will export the calculated totals to an ASCII file, for the Third-Party system to import. The export format is created in the File Creator, which is beyond the scope of this manual.

To export the totals, first select the person or load the filter as required, then select the export format from the list on the left. Select the date range, and then click ‘Export’, this will export the file to the saved export location. The ‘Export To…’ button will display a browse window in order to select a specific location to export the file to. If ‘Email Export File’ is selected the output file will be attached to an email, ready to be sent. If you do not wish to include employees hired in the date range to be exported, tick the box for ‘Exclude employees hired in selected date range’. 

More on date ranges (equivalent to reports):

 Current Period: This will export the period, which includes today’s date (incomplete period).

Last Period: This will export the full period just before the current period. 

Period Containing: Exports the full period, which includes the date selected from the calendar. If you select ‘To Period Containing’ it will export all the full periods between, and including the dates selected. 

Custom dates: This will print using the exact ‘from’ and ‘to’ dates that you select from the calendar. However it will not use the pay group’s periodic rules! (Example: First 40 hours NT then only pays OT1.5)

It simply produces the sums and counts for all time categories and counters, unless you select ‘Apply Paygroup Rules’. This will only apply the rules to all full periods contained within the custom date selection, and includes those totals for the sum of all time categories and counters. 

• Related Articles

• 14.1 Export File Creator

  Export File Creator The File Creator is used to create an export file for Third-Party System integration. If you are not completely familiar with the import batch layout of your Third-Party system, it may be advisable to arrange to have a payroll ...

• 27.1 Export of Employees

  Export of Employees Employees can be imported and exported, from both Jarrison Time and JT Lite software. To export the employee shown in the employee list, click on ‘Export’ then ‘Employees’ from the menu bar, then select ‘To Email’ or ‘To File’ ...

• 31.1 Import and Export of Adjustments

  Import and Export of Adjustments To import adjustments from an external source, click on ‘Import’ then ‘Adjustments’. If adjustments like Annual Leave or Sick pay etc. are managed in an external program and can be exported then they can be imported ...

• 28.1 Import and Export of Employee Photos

  Import and Export of Employee Photos Employee photos can also be imported and exported. Click on ‘Import’ then ‘Employee Photos from File’ or ‘Export’, ‘Employee Photos’. The name of the file must be the employee number and the extension must be ...

• 14.2 Details

  Details The Details tab is used to configure the line items in the output file. The items are listed from top to bottom, and will be exported from left to right into the export file. The arrow buttons on the right side move a selected item up or ...