Importing a task list

Modified on Tue, Jan 3, 2023 at 12:20 PM

Anyone can import a list of tasks by clicking on the icon below in Task Viewer.


Here are instructions for the import template:


 

FieldInput OptionDefinitionExampleNext Steps
Task List NameFree Text
Monthly Standard Jes
Task Sublist NameFree Text
Accrual Entries
Task NameFree Text
Payroll Accrual
Custom Field 1Free Text
JE Number
Custom Field 2Free Text
Invoice Number
DescriptionFree Text (Optional)
Calculate payroll accrual from ADP weekly report
Assigned ToEmail address of assigneeThis is the person who is responsible for completing the task.  Multiple individuals can be assigned.jane.doe@acme.comIf Assigned to is populated, you must complete Task Due Days Basis and Task Due Days fields.
ReviewerEmail address of reviewer (Optional)This is the person who is performing the first level review of the task. Multiple individuals can be assigned.dale.white@acme.comIf Reviewer is populated, you must complete Assignee Due Days Basis and Assignee Due Days fields.
ApproverEmail address of approver (Optional)This is the person who si performing the second level review of the task. Multiple individuals can be assigned.bob.smith@acme.comIf Approver is populated, you must complete Reviewer Due Days Basis and Reviewer Due Days fields
NotifyEmail address (Optional)Besides the Assignee(s), Reviewer(s), Approver(s), Task Creator and System Admin, anyone else who needs to see/access this task needs to be set up as a notifier.  Multiple individuals can be assigned.kathy.jones@acme.com
Recurrence TypeEvery Rec PeriodEvery monthGet statement each month from corresponding bankPOPULATE -- Assignee Due Days, Task Due Days
 LEAVE BLANK -- Recurrence Frequency, Period #, Task Due Date, Assign Due Date

QuarterlyFour times a year (does not have to be following quarter-end date).Call reporting that's due 30 days after quarter endPOPULATE -- Period#, Assignee Due Days, Task Due Days
 LEAVE BLANK -- Recurrence Frequency, Task Due Date, Assignee Due Date

AnnuallyOnce a yearPrepare 1099sPOPULATE -- Period#, Assignee Due Days, Task Due Days
 LEAVE BLANK -- Recurrence Frequency, Task Due Date, Assignee Due Date

Multiple Rec PeriodMultiple times a yearAn activity that happens 3 times a yearPOPULATE -- Period#, Assignee Due Days, Task Due Days
 LEAVE BLANK -- Recurrence Frequency, Task Due Date, Assignee Due Date

No RecurrenceNo frequencyA one-time activityPOPULATE -- Recurrence Frequency, Assignee Due Days, Task Due Days
 LEAVE BLANK -- Period #, Task Due Date, Assignee Due Date

CustomAd hoc frequencyActivities that will be performed twice this year with different dates
Recurrence FrequencyDateWhen Recurrence Type is Custom, this will be the period end date(s) that this task should be due.09/30/2025
Period #NumberWhen Recurrence Type is Quarterly, Annually or Multiple Rec Period, this will be the period numbers separated by commas1,3,8
Task Due DateDateThis is the task due date when the Recurrence Type is No Recurrence08/31/2026
Reviewer Due Date (populate only if there are Approvers assigned)DateThis is the task due date when the Recurrence Type is No Recurrence and an Approver is assigned08/31/2026
Assignee Due Date (populated only if there are Reviewers assigned)DateThis is the task due date when the Recurrence Type is No Recurrence and a Reviewer is assigned08/25/2026
Task Due DaysNumberThis is the day the task is due each month.25 (meaning 25 calendar or business days after month-end)
Task Due Days BasisSelect Period End Date of Month-End DateIf task due days are calculated based on period-end date, then selecte Period End Date.

 If task due days are calculated based on month-end date, then select Month End Date.


Task Due Days Skip NumberNumberNumber of months skipped.  This field is relevant if there is a task that is due on the last day of the month/quarter (day 30 or day 31)"0"--Don't skip any months
 "1"--Skip 1 month.  So a task that has due day of +1 with a +1 skip means that the task is due on the last day of the following month.

Assignee Due Days (populated only if there are Reviewers assigned)NumberThe day the task is due each month.    Assignee due day must come before Task Due Day and Reviewer Due Day.5 (meaning 5 calendar or business days after month-end)
Assignee Due Days Basis (populated only if there are Reviewers assigned)Select Period End Date of Month-End DateIf task due days are calculated based on period-end date, then selecte Period End Date.

 If task due days are calculated based on month-end date, then select Month End Date.


Assignee Due Days Skip Number (populated only if there are Reviewers assigned)NumberNumber of months skipped.  This field is relevant if there is a task that is due on the last day of the month/quarter (day 30 or day 31)"0"--Don't skip any months
 "1"--Skip 1 month.  So a task that has due day of +1 with a +1 skip means that the task is due on the last day of the following month.

Reviewer Due Days (populated only if there are Approvers assigned)NumberThe day the task is due each month.    Reviewer Due Day must come after Assignee Due Day and before Task Due Day.15 (meaning 15 calendar or business days after month-end)
Reviewer Due Days Basis (populated only if there are Approvers assigned)Select Period End Date of Month-End DateIf task due days are calculated based on period-end date, then selecte Period End Date.

 If task due days are calculated based on month-end date, then select Month End Date.


Reviewer Due Days Skip Number (populated only if there are Approvers assigned)NumberNumber of months skipped.  This field is relevant if there is a task that is due on the last day of the month/quarter (day 30 or day 31)"0"--Don't skip any months
 "1"--Skip 1 month.  So a task that has due day of +1 with a +1 skip means that the task is due on the last day of the following month.

Day TypeSelect Calendar Days or Business DaysTell ART whether to calculate task due days based on calendar or business days.  Business day calculation will also take into account any holidays that are loaded into ART.Business Days
Rec GroupFree TextLeave blank if not applicable.  Otherwise, enter the Rec Group exactly as is named in ART.Acme Company


 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article