Importing Payroll Items
To export Time Tracks to QuickBooks you’ll first need to import your organization's Payroll Items from QuickBooks. You can import your Payroll Items via the Payroll Item Listing (Settings -> List -> Payroll Item) or the QuickBooks Import screen (Settings -> QuickBooks -> Imports).
Note: If you don’t integrate with QuickBooks but still want Arborgold to Determine Payroll Items for your Time Tracks and export to another Payroll Generation software, then you can manually create the Payroll Items, shown in the next section.
Importing from QuickBooks Imports:
Importing from Payroll Item:
Once imported, Payroll Items can be accessed from the Settings menu under List -> Payroll Item.
Payroll Items in Arborgold (Listing, Adding, Updating, Deactivating and Restoring)
From the Payroll Item listing, you can Add, Update, Deactivate, and Restore Payroll Items.
To create a new Payroll Item from Arborgold, without importing one from QuickBooks, you can select Add New. Give the Payroll Item a Name, Wage Type, and Expense Account.
Right-click or double-click on an entry to Edit or Deactivate that item. Items can also be Deactivated from the Edit menu.
To restore deactivated items, click Restore at the top-left to bring up the Deactivated Payroll Items listing. Here you can select one or more previously deactivated items to restore.
Payroll Settings can be accessed via the settings menu under Company -> Payroll.
This page contains all the Company information and settings related to Payroll. In the first section, you can select which Payroll Items to enable/disable. If applicable, this is where you enter the number of hours it takes to associate that payroll item, i.e. Daily Overtime after 8 hrs/day.
All of the selected Payroll Items will appear in the next section, Default Payroll Items. Here, you can select the type of pay to associate with each item.
Finally, in the bottom section, you can set date information such as the starting day of the work week, the length of the payroll period, and a recent closing date for payroll.
Determining Payroll Items
To export Time Tracks to QuickBooks Desktop, each track must have an associated Payroll Item. Time Tracks can be assigned a Payroll Item using the Determine Payroll Item tool under Time->Exporting.
Arborgold will automatically determine the Payroll Items for employee Time Tracks based on the time tracked by the employee and your company payroll settings.
The Pay Period and Payroll Weeks will automatically be determined for you based on your company pay period settings.
You can check all time tracks within a given Pay Period for any tracks that have undetermined Payroll Items. Click Determine, and Arborgold will automatically add or update the Payroll Item for every Time Track within the chosen Payroll Weeks.
The selected date range must be increments of 7 days to be considered valid payroll weeks.
In the above example, the first payroll week is Monday 1/4 to Sunday 1/10. 1/5 to 1/11 would also be valid. However, 1/4 to 1/7 would not be a valid payroll week.
Each time you determine payroll, the recent closing date for payroll (in Company Pay Period Settings) will be automatically updated. In this example, after determining payroll the recent closing date would be updated to 02/21/2021
You can access the QuickBooks Exporting page via Time -> Exporting.
The Exporting list will show all Time Tracks that
Are Completed, AND
Have not already been Exported to QB or Marked Exported, AND
Have an associated Payroll Item.
You can select one or more tracks from this list and Action -> Export to QB.
When exporting a track, the Customer Reference will be associated, and the notes will include the job name.
If you do not use QuickBooks and are manually exporting for Payroll, you can also select Mark Exported to update the Time Tracks.
Update Time Tracks from the Export Listing
You can edit/update time tracks from the Exporting screen as well. You can update a single track by double- or right-clicking it, or use Action -> Update and Action -> Update Tags to update tracks in batch.