The export's five cards

1. Which hours and people: worked hours, leave, allowances (each on or off), also submitted hours if you want; everyone, or people by tag and field (Pay frequency is Weekly, Worker type is not Contractor).
2. Columns, in the file's order, each with its header exactly as your payroll wants it and Take it from:
   • person (name, first and last name, email, any field), when (date, start, finish, week start, pay period start and end), hours, the kind's name or code, work (project, code, client, site, work type, leave type, notes, their fields), fixed text ({period_end} works), blank;
   • First filled of…: several sources tried in order, such as work type's Cost code → site's Cost centre → person's Home cost centre;
   • shape the value: Change values (New South Wales → NSW, Yes → Y), upper case, pad with zeros (000104), cut to a length, several picks joined or Yes if it includes First aid;
   • When it's empty: leave it blank, write text (*None), or Must be filled (a problem in the check).
3. Rows and kinds: one row per shift, day, week or pay period per person (rows combine only when every column is the same, so a cost-centre column gives a row per cost centre). Kinds go a row per kind (with a Kind code column), a column per kind (Hours of Overtime 1.5), or code-and-hours pairs (ADP). Codes: each kind's code in this payroll, or Leave out.
4. Values: date and time styles, hours as 7.5, 7:30 or minutes, decimals, decimal comma, Yes / No words.
5. File: CSV or another separator, Excel or fixed width (each column's width); encoding (UTF-8, UTF-8 for Excel, Windows-1252 for older desktop payrolls); header row; a line before it (MYOB's {}); quotes; line endings; the file name; one file per value of a person field (Employer).