Import timesheet into Reckon Accounts Premier
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
Best Answers
-
This related post from a colleague of mine might help 👇
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.
0 -
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.
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
0
Reckon Staff Answers
-
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.
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
1 -
Yes Cosmic has done time sheet import
call me on 0407068942
Cosmic Accounting Group
Accountants and Tax Agents 22397009
0 -
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 😀
0 -
Cosmic did this for Aged care Business 7 years ago
Cosmic Accounting Group
Accountants and Tax Agents 22397009
0 -
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.
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
1 -
1
