Import timesheet into Reckon Accounts Premier

jenny_9151212

is it possible to import a excel spreasheet of weekly timesheet including employee names, and total normal hours and overtime hours, holiday hours ect. for the week into Reckon Accounts Premier for payroll process?

	Name		Normal Time	Travel Time	Overtime 1.5x	Overtime 2.0x	RDO	Annual Leave: EBA	Annual Leave:	Absent: Public Holiday	Personal Leave
0		Notes	0	0	0	0	0	0	0	0	0
1	john		20	0	0	0	10	0	10	0	0
2	Mark		40	0	1	2.5	0	0	0	0	0
8	Sarah		40	0	0	0	0	0	0	0	0
10	Cam		38	0	0	0	0	0	0	0	2

i can see that i can export spreadsheet in Employee center but no import.

we donot use Reckon for jobs or time activity.

thanks for your time

Rav

Hi @jenny_9151212

This related post from a colleague of mine might help 👇

https://community.reckon.com/discussion/comment/20649401#Comment_20649401

I'd also recommend taking a look at the importing data article within the help menu in Reckon Accounts itself. It has detailed information on the format and data required in an IIF file for importing.

Datarec

QBi_Timesheet_Example_2.iif.txt

QBi_Timesheet_Example_1.iif.txt

The example files have had a ".txt" extension added to allow for upload to the Community.

It is a tab-delimited text file.

You can open it Excel.

When creating your own timesheet file, in Excel, you will need save it as a tab-delimited text file and give it a file extension of ".iif" in order for the Reckon Accounts application to recognise it during the import process.

Refer to the in-product Help as per the post by @Rav above, regarding how to import.

Datarec

Hi @jenny_9151212

This Community Post below has relevant info about a timesheet import format compatible with the Reckon Accounts Hosted and desktop applications.

Payroll import IIF file - from payroll software to Reckon Premier — Reckon Community

If you are familiar with Excel and working with CSV/Tab-delimited text files then that may be an option for you.

There are also tools available from the Reckon Add-on Marketplace related to data import for other functions you may be interested in.

@cosmic and @PhuongDo have other automation tools available that can help you.

Cosmic Bills | Marketplace (reckon.com)

Beanwiz Free Version | Marketplace (reckon.com)

cosmic

Yes Cosmic has done time sheet import

call me on 0407068942

jenny_9151212

hi All

thanks for a such quick respond

i did read through the post both of you referenced to before i asked the question, i thought that import spreasheet is job based, as we donot use reckon for jobs, i am not sure if we can use it for payroll items based spreasheet. but i will read the help in Reckon and maybe give it try

thanks again 😀

cosmic

Cosmic did this for Aged care Business 7 years ago

https://www.youtube.com/watch?v=AD9oN-EfU3s

Datarec

Hi @jenny_9151212

Take a look at the example QBi_TimeSheet_Example files.

Use that example, to create one that reflects your setup.

Make your own a sample file, that you can import it into.

Do not import the example into your live data file.

If you do not want to do all of that, then going with the solution that is provided by @cosmic would be easier.

jenny_9151212

@Datarec

thanks again for your detailed information, i will give this a try first 😀

Cheers
jenny