Message-ID: <1724795443.6529.1711663409417.JavaMail.tomcat@ip-10-129-228-235> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_6528_626182618.1711663409416" ------=_Part_6528_626182618.1711663409416 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Ace Payroll creates a CSV file, which= is then imported into Cash Manager.
File consists of various comma delimi= ted data lines, the first field of which is a numeric value indicating the = sort of data contained in the line.
All lines starting with ! or # are co= mments and do not contain import data.
Ace Payroll client selects a date ran= ge of transactions to export.
Based on the date range selected ther= e may be more than one transaction for some employees.
CashManager can be indentified as the= clients default export method, and will be described on the setup options = with the CashManager logo.
After confirmation, the file will be = created then read back from disk for viewing by the Ace Payroll client; hen= ce the comment lines described later on.
File name and path can be placed in c= lipboard for pasting into CashManager if this assists; please advise.
Ace Payroll creates a file named "cas= hman.csv" in the folder containing the client data files.
First line of file consists of "#5284= 3".
This in an arbitrary value, the purpo= se being to identify the file as one containing Ace Payroll data that is in= a format expected by CashManager.
CashManager could examine this value = to check the correct file is being imported.
Whether CashManager uses this value i= s up to CashManager.
All lines that start with an exclamat= ion mark "!" are comments, and should be ignored.
Comment lines can be allowed anywhere= within the file, for future unknown purposes.
All lines that start with a hash char= acter "#" are also treated as comment lines.
This is apart from the first line, wh= ich whilst starting with a hash has a defined position, purpose and value.<= /span>
The first field of every line that is= not a comment consists of a non zero numeric identifier indicating the typ= e of data contained in the line.
1 - Creator Header Line - This line contains information about the entity
that is exporting the data, and other= items pertaining to the data as a whole.
2 - Field Names Line= - this line represents the text description of the fields contained in
a line 3 data line.
3 - Data Line - this= line represents the actual data to import, with fields matching
the items described by the line 2 des= criptions.
This line contains information about = the entity that is exporting the data, and other items pertaining to the da= ta as a whole.
Field 1 - Line Identifier&nbs= p;
The creator header line starts with a= 1.
Field 2 - Ace Payroll Version=
This field contains the Ace Payroll v= ersion that created the file, such as 3.36D
Field 3 - Ace Payroll Serial = Number
This field contains the serial number= of the Ace Payroll program that created the file. It will be a maximum of = 5 digits. If the export file is created by an evaluation or unregistered ve= rsion it has a value of zero.
Field 4 - Company Name <= /strong>
This field takes a maximum of 40 char= acters and is the name of the organisation from which the data is being exp= orted.
Field 5 - IRD Number
This field represents the client IRD = number, as a raw unformatted numeric value. The field is no greater than 9 = digits, and will have a value of zero if unused.
Field 6 - Creation Date Time&= nbsp;
This is the date and time the file wa= s created in the format "3.54pm 23-Mar-2010"
Sample Line
1,"3.36D",4567,"Joe Bloggs Ltd",12345= 6789,"3.54pm 23-Mar-2010"
This line starts with a 2, and contai= ns a text description of the data line fields.
Sample Line
2,ID,"Payment Date","Employee Name","= Dept Ref","Dept Name",Gross,PAYE,"Child Support","Student Loan","Other Ded"= ,"After Tax Extras","KiwiSaver Employer","KiwiSaver Employee",Nett= p>
This line starts with a 3, and contai= ns data for every payment made for each employee in the period selected.
Field 1 - Data Line Identifie= r
All data lines start with a 3.=
Field 2 - Employee ID = strong>
Maximum 5 Characters. Probably unused= by CashManager.
Field 3 - Payment Date <= /strong>
DD/MM/YYYY
Field 4 - Employee Name =
Maximum 25 characters plus quotes.
Field 5 - Department Referenc= e
A number between 0 and 255 that Ace P= ayroll uses to identify the department. It is unlikely that CashManager wil= l use this field.
Field 6 - Department Name&nbs= p;
Maximum 10 characters plus quotes. Th= e name by which the Ace Payroll client refers to the above department.
Field 7 - Gross Pay
Field 8 - PAYE =
Field 9 - Child Support =
Field 10 - Student Loan =
Field 11 - Other Deductions&n= bsp;
Field 12 - After Tax Extras&n= bsp;
Field 13 - KiwiSaver Employee=
Field 14 - KiwiSaver Employer=
Field 15 - Nett Pay
Sample Data Line
3,JS,15/12/2009,"Bloggs, Joseph",6,"M= anagement",60800,11331,2000,2330,500,800,1200,1200,43039
Amount Fields <= /span>
Fields 7 to 15 are dollars and cents = represented as integer values with two implied decimals. Zero is represente= d by a single zero. For example $598.66 is represented as 59866.
Additional Fields
Additional fields may be added at a l= ater date. Neither party should limit themselves by assuming there are exac= tly 15 fields.