Payroll import IIF file - from payroll software to Reckon Premier

Rosie

Hi, My payroll software provider has asked me to determine the timesheet import specifications for the IIF file so that they can write a script for pays to be imported into Reckon. I have found a few fact sheets but nothing that actually lists what is required in the file and in what order. I need to know what fields are required in the file and what types of data can be imported. Any help would really be appreciated. 

Graham Boast

Hi Rosie

I have posted below information from the Reckon Accounts Help File that outlines the specifications for the timer import.

Reckon will happily import timesheets for you to assist you in creating Pays via Reckon, but it cannot import a "Paycheque" that has been calculated by another program.  As you are talking about a "Payroll Software Provider", I gather the payroll is done in their program and you are trying to record the transactions in Reckon. If this is the case then it won't work.

Scenarios like this are often done via journal entries at a total payroll level, with the details of the individual pay remaining in the stand alone payroll program.

If you want to send me details of exactly what you are trying to achieve, I can advise on what is achievable.

Graham Boast
Reckon Accredited Consultant
graham@reckonhelp.com.au

---------------------------------------------------------------

RECKON ACCOUNTS TIMER ACTIVITY IMPORT
You can import data about the activities you time with the Timer to Reckon Accounts. The keyword for activity data is TIMEACT. Timer activity data must begin with the Timer header block (TIMERHDR). Column headings

The following table shows the column headings for activity data:

DATE

The date the activity was performed. Enter the date in a MM/DD/YY format. For example, you would enter June 21, 1997 as 06/21/97.

JOB

The name of the customer (or job) for whom the activity was performed. If you're entering the name of a job, enter the customer's name followed by a colon followed by the name of the job. Both the customer and the job names must also be on your Customers & Jobs list (CUST).

EMP

The name of the employee who performed the activity. The employee's name must also be on your Employee list (EMP).

ITEM

The name of the service item assigned to the activity (a service item indicates the type of work performed). The service item must also be on your Item list (INVITEM).

PITEM

Leave blank. This field is not used in Reckon Accounts.

UPDATE FROM GRAHAM: This is incorrect, It should be the Reckon Accounts Payroll Item which must be already on the Payroll Item List

DURATION

The duration of the activity in hours and minutes. Enter the duration in an HH:MM format. For example, if the activity lasted 4 hours and 15 minutes, you would enter 4:15. The duration cannot be greater than 23:59.

PROJ

The Reckon Accounts class assigned to the activity (classes give you a way to group activities in meaningful ways in time reports). The Class must also be on your Class list (CLASS).

NOTE

Your notes about the activity. You may enter up to 1000 characters, but the characters must be on a single line within the field. To indicate a line break in the note, type /n.

BILLINGSTATUS

Indicates the billing status of the activity. Enter one of these values:

 0 - The activity is not billable to the customer or job specified in the Job field. Enter this value if the activity is part of your company overhead.

 1 - The activity is billable but has not yet been billed to the customer or job specified in the Job field.

 2 - The activity has already been billed to the customer or job specified in the Job field.