• Go to Services and click on Imort Button.
• Click on the 'sample excel file' link, highlighted in blue.
• Download the Excel file.
• Open the downloaded file.
• Column A: Enter the service name.
• Column B: Select 'Yes' or 'No' to enable the service.
• Column C: For recurring services, select 'Yes'; for non-recurring services, select 'No'.
• Column D: If Checklist Completion is Required, select 'Yes'.
• Column E: Select Auto Task Creation Frequency: for recurring services, choose monthly, quarterly, or yearly; for non-recurring services, leave blank.
• Column F: For monthly recurring services, select the creation date; for non-monthly recurring services, leave blank.
• Column G: For monthly recurring services, select the due date; for non-monthly recurring services, leave blank.
• Column H: For quarterly recurring services, select the creation date; for non-quarterly recurring services, leave blank.
• Column I: For quarterly recurring services, select the creation month; for non-quarterly recurring services, leave blank.
• Column J: For quarterly recurring services, select the due date; for non-quarterly recurring services, leave blank.
• Column K: For quarterly recurring services, select due month; for non-quarterly recurring services, leave blank.
• Column L: For yearly recurring services, enter the creation date in DD-Mmm format (e.g., 24-Apr); for non-yearly recurring services, leave blank.
• Column M: For yearly recurring services, enter the due date in DD-Mmm format (e.g., 18-Oct); for non-yearly recurring services, leave blank.
• Column N: Select Task Creation Period: 'Current' means create tasks for the currently running period; 'Last' means create tasks for the recently completed period.
• Column O: Enter the SAC code, if needed.
• Column P: Enter the Default Billing Rate (Excl. of Tax).
• Column Q: Select the GST% (If you don't charge GST, please select 18%).
• Column R: If you want to assign auto tasks to users of respective clients, select 'Yes'; otherwise, select 'No'.
• Column S: Enter the username(s) to assign auto tasks (Enter username, not name. Use commas to separate the usernames).
• Column T: If you want to create a checklist, enter the checklist names (Use commas to separate the checklist names).
• Column U: To Create a Document Collection Request, select 'Yes'; otherwise, select 'No'.
• Column V: Enter your Document Collection Request Default Message (Required if the Document Collection Request option is 'Yes').
○ All mandatory columns are highlighted with an asterisk (*).