The “Time Sheets” tab allows you to import spreadsheets that you’ve either electronically gathered via a time keeping vendor, or manually entered payroll information onto a spreadsheet, both methods needing to use our import templates. Each tab has a separate focus on what it’s importing and how the information is formatted, with the payroll and vendor web entries gathering time punches via our online time keeping portal vs a file. The documentation for importing web entries can be found on the Arborsoft Online Portal portion of the wiki.
| Table of Contents |
|---|
Though we have multiple import formats to accommodate various vendors, the information for our default format and example files can be downloaded below.
...
The header of the import file can remain or be removed
The relationships of the Consumer/Employee/Service Codes must be established within Arborsoft if they exist in the import file
As the file is saved in CSV comma delimited, commas within the import file (such as service codes) must be removed
Though not required, we typically suggest users mirror the pay type with the import code i.e. REG as the pay type and REG as the import code as it makes the import file easier to review before importing.
...
Importing a Payroll file
...
If for any reason you wish to remove the imported file and the information has NOT been processed, clicking the delete button will remove all of the displayed information.
...
Processing the file
This will display both required and optional fields, and shows totals on the bottom. Once readyOnce you’ve reviewed the imported entries, clicking “Process” will then move the valid entries to the payroll batch, which can be viewed on the Payroll > Payroll Entry tab. Processed entries will have the “Processed” field change from N to Y, and will change from black to red. Entries that are missing required fields or that are otherwise invalid, will remain unprocessed and in black.
On the Payroll Entry tab, the entry type will display manual for manually entered time, and “IMPORT” for imported entries as shown below. From this point on you’re free to review totals and process as usual.
...
Common Import Issues
Failing to import some/all of a time sheet can occur for a variety of reasons, such as the import codes on the file not existing for the related consumer/employee, entries being made in the wrong format, etc. If the correction can be made in Arborsoft (such as entering an a missing import code to an employees profile) you can right click and select “refresh” for the imported information to attempt to match the information again.
If you have any issues importing the file and can’t find the reason, feel free to reach out to the support team and be sure to include the file you’re attempting to import for review. Some common failure points are:
Importing the file not in CSV comma delimited format.
Commas in any fields. As the file is imported in CSV format, a comma in the service code or any other field will separate the field into two causing an error.
Missing/mismatched import id within Arborsoft and import file
Incorrect format for the field (see the file specs document for details)