Payroll import IIF file - from payroll software to Reckon Premier

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.

 

Hi Rosie

Sorry, I just noticed your reply whilst referring someone else to it.

here is a sample import file



Order of columns is unimportant except column 1
the COMPANYNAME and COMPANYCREATEDATE can be found by creating a timer export file from your Reckon file (File > Timer > Export Lists for Timer)

The Reckon items must already be set up, with the exception of Job (Reckon Customer or Customer:Job - it can create these on the fly)

I can consult to you or software developers with this if you have any issues/problems that you can' resolve.

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