Data Wizard
Last updated
Was this helpful?
Last updated
Was this helpful?
To download a salary data or payroll data you first need to create a salary register first and then proceed to download it. Step for the same are given below.
A. Create Salary Register
B. Download Salary Register
Step 1: Log into the cloud portal, go to the ‘Analytics’ and select the ‘Data Wizard’ submenu.
Step 2: To create a new salary register click on the ‘+’ icon, enter the ‘Setting Name’ and click on the ‘Add’ button. Select ‘Report Type’, click on the ‘Add Fields’ button and the ‘Data Wizard’ pop-up will open.
Step 3: Click on the various tabs such as category, master fields, earning fields, deduction fields, user-defined fields and separation fields to select the respective fields to be included in the salary register and click on the ‘Save’ button.
Step 4: Select the ‘Report Type’, ‘Employee Status’, ‘From Month Year’ and click on the ‘Save’ button. The salary register will be created accordingly.
Step 1: Log into the cloud portal, go to the ‘Analytics’ and select the ‘Data Wizard’ submenu.
Step 2: From the ‘Select Settings’ field select the salary register you created. Select the required fields such as report type, employee status, from month - year and other fields as required and click on the ‘Download’ button.
The salary register with salary data will be downloaded.
Path: Cloud portal > Analytics > Data Wizard > ‘+ Icon’ > Settings Name > Add > Report Type > Add Fields > select fields > Save > Report Type > Employee Status > From Month-Year > Save
>> Select Setting > Report Type > Employee Status > From Month-Year > Download
Step 1: Log into the cloud portal, go to the ‘Analytics’ menu and click on the ‘Data Wizard’ submenu.
Step 2: From the respective field ‘Select Settings’ or add new if required and click on the ‘Add Fields’ button and a Data Wizard pop-up will open.
Step 3: Click on the ‘Earning Fields’ tab and select the checkboxes of the respective arrear field such as Arrear Basic & Arrear Bonus. Similarly, you can select other fields like Supplementary, Over Time and more, to be included in the salary report and click on the ‘Save’ button.
Step 4: Select the ‘Report Type’, ‘Employee Status’ and ‘From Month-Year’ values in the respective fields as required and click on the ‘Download’ button. The salary report will be downloaded accordingly.
Path: Cloud>Analytics>Data Wizard>Select Setting/create settings-Salary register> Add Fields >Earning Details> add the required fields>Save>select required details>Download
Step 1: Log into the cloud portal, go to the ‘Analytics’ and select the ‘Data Wizard’ submenu.
Step 2: From the ‘Select Settings’ dropdown, select the salary register and click on the ‘Add Fields’ button.
Step 3: Click on the various tabs such as category, master fields, earning fields, deduction fields, user-defined fields and separation fields to select the respective fields to be included in the salary register and click on the ‘Save’ button.
Step 4: Select the ‘Report Type’, ‘Employee Status’, ‘From Month Year’ and click on the ‘Save’ button. The fields will be added to salary register accordingly.
Path: Cloud portal>Analytics>Data Wizard>Select Settings>Report Type>Add Fields> select fields>Save
Step 1: Log into the cloud portal, go to the ‘Analytics’ and select the ‘Data Wizard’ submenu.
Step 2: ‘Select Setting’ and check various fields added in the report from the section below the ‘Add Fields’ button. If you want to add any other salary components in the report click on the ‘Add Fields’ button.
Step 3: Click on the ‘Earning Fields’ and ‘Deduction Fields’ tab to select respective components in the report and click on the ‘Save’ button.
Step 4: In the section under the ‘Add Fields’ button select the checkboxes for the freshly added components.
Step 5: Select the ‘From Month-Year’ and other details as required and click on the ‘Download’ button and the salary component report will be added accordingly.
Path: Cloud portal>Analytics>Data Wizard>Select Settings>Add Fields>Earning>Deduction>Save>select ‘From Month-Year’ and other fields as required >Save
You need to follow following steps
a. Check if the component is added in the salary register
b. Add that component in the salary register
Step 1: Log into the cloud portal, go to the ‘Analytics’ and select the ‘Data Wizard’ submenu.
Step 2: ‘Select Setting’ and check various fields added in the report from the section below the ‘Add Fields’ button.
Path: Cloud portal>Analytics>Data Wizard>Select Settings>check the components added in the list below the ‘Add Fields’ button.
For any queries, connect with our agent on chat.
Step 1: Log into the cloud portal, go to the ‘Analytics’ and select the ‘Data Wizard’ submenu.
Step 2: If you want to add any other salary components in the report click on the ‘Add Fields’ button.
Step 3: Click on the various tabs such as category, master fields, earning fields, separation fields and deduction fields to select respective components and click on the ‘Save’ button.
Step 4: In the section under the ‘Add Fields’ button select the checkboxes for the freshly added components.
Step 5: Select the ‘From Month-Year’ and other details as required and click on the ‘Save’ and them ‘Download’ button and the salary components will be added accordingly.
Path: Cloud portal>Analytics>Data Wizard>Select Settings>Add Fields>Earning>Deduction>Save>select ‘From Month-Year’ and other fields as required >Save > Download
For any queries, connect with our agent on chat.
Step 1: Log into the cloud portal, go to the ‘Analytics’ and select the ‘Data Wizard’ submenu.
Step 2: ‘Select Setting’ or create a new one for salary, select ‘Report Type’ and to add new fields click on the ‘Add Fields’ button and the ‘Data Wizard’ pop-up will open.
Step 3: Click on the various tabs such as Category, Master Fields, Earning Fields, Deduction Fields, User-defined Fields and Separation fields to select the respective fields to be included in the salary register and click on the ‘Save’ button.
Step 4: Select the ‘Report Type’, ‘Employee Status’, and ‘From Month Year’ from the respective fields. Click on the ‘Download’ button and salary register will be downloaded accordingly.
Path: Cloud Portal>Analytics>Data Wizard>Select Settings>Report Type>Add Fields>Select Category/Master/Earning/Deduction/User-Defined Fields>Save>Select Employee Status>From Month-Year>Save>Download
Step 1: Log into the cloud portal, go to the ‘Analytics’ and select the ‘Data Wizard’ submenu.
Step 2: 'Select Settings' as ‘Salary Register’ from dropdown or create new settings as required. Click on the ‘Add Custom Formula’ button.
Step 3: Enter a ‘Display Name’ and add the custom new ‘Formula’ as required and click on the ‘Save’ button.
Step 4: Once you save the formula you will get back to the Data Wizard Report page. Click the ‘Save’ button to save the new formula in the salary register.
Path: Cloud Portal>Analytics>Data Wizard>Select Settings/add new setting>Add Custom Formula>enter formula & details as required-Save>click ‘Save’ on Data Wizard page
Step 1: Log into the cloud portal, go to the ‘Analytics’ menu and click on the ‘Data Wizard’ submenu.
Step 2: ‘Select Settings’ as ‘Bank Sheet’/’Bank File’ or add settings as required. Continue to select and add details as per your requirements and bank format and click on the ’Save’ button.
Step 3: ‘Select Settings’ that you added, select Month and Year as required and click on the ‘Download’ button. The bank details or bank sheet will be downloaded accordingly.
Path: Cloud Portal>Analytics>Data Wizard>Select Settings/Add Settings>add details as required>Download
Step 1: Log into the cloud portal, go to the ‘Analytics’ and select the ‘Data Wizard’ submenu.
Step 2: From the ‘Select Settings’ or add new. Select the ‘Employee Status’ as ‘Separated and other required details. Click on the ‘Download’ button and the salary register for left employees will be downloaded accordingly.
Path: Cloud portal>Analytics>Data Wizard>Select Setting>Employee Status-Separate >other required details>Download
Step 1: Log into the cloud portal, go to the ‘Analytics’ and select the ‘Data Wizard’ submenu.
Step 2: ‘Select Setting’ or click on the ‘+’ icon to create new.
Step 3: Enter ‘Setting Name’ and click on the ‘Add’ button. Select the ‘Report Type’ and click on the ‘Add Fields’ button under the ‘Custom Fields section.
Step 3: Click on the ‘Confirmation’ export under the Custom Entities from the left side of the pop-op. Select required fields and click on the ‘Save’ button.
Step 4: Select other require details such as Report Type, Employee Status, From Month-Year. Click on the ‘Save’ button to save the settings and then click on the ‘Download’ button. The confirmation report will be downloaded accordingly.
Path: Cloud portal>Analytics>Data Wizard>Select Settings/+ Icon>Add Fields>select required components>Save>select other fields as required >Save > Download
Step 1: Log into the cloud portal, go to the ‘Analytics’ and select the ‘Data Wizard’ submenu.
Step 2: ‘Select Setting’ or click on the ‘+’ icon to create new.
Step 3: Enter ‘Setting Name’ and click on the ‘Add’ button. Select the ‘Report Type’ and click on the ‘Add Fields’ button.
Step 3: Click on the various tabs such as Category, Earning Fields, Separation Fields and Deduction Fields to select respective components and click on the ‘Save’ button.
Step 4: Click on the various ‘Master fields’ tab and search ‘Bank’ using the search fields from the upper right corner of the screen. Select bank components and click on the ‘Save’ button.
Step 4: Select other require details such as Report Type, Employee Status, From Month-Year. Click on the ‘Save’ button to save the settings and then click on the ‘Download’ button. The bank statement or the salary register with bank statement will be downloaded accordingly.
Path: Cloud portal>Analytics>Data Wizard>Select Settings/+ Icon>Add Fields>Category, Earning, Deduction>Save>select other fields as required >Save > Download
Step 1: Log into the cloud portal, go to the ‘Analytics’ and select the ‘Data Wizard’ submenu.
Step 2: From the ‘Select Settings’ field create the salary register you created. Select the required fields such as report type, employee status, from month - year and other fields as required and click on the ‘Download’ button.
The salary register with salary data will be downloaded.
Path: Cloud portal > Analytics > Data Wizard > Select Setting > Report Type > Employee Status > From Month-Year > Download
Step 1: Log into the cloud portal, go to the ‘Analytics’ menu and select the ‘Data Wizard’ submenu.
Step 2: ‘Select Setting’ or create a new one for salary. Select ‘Report Type’ and to add new fields click on the ‘Add Fields’ button.
Step 3: Click on the various tabs such as Category, Master Fields, Earning Fields, Deduction Fields, User-defined Fields and Separation fields to select the respective fields to be included in the salary register and click on the ‘Save’ button.
Step 4: Select the ‘Report Type’, ‘Employee Status’, and ‘From Month Year’ in the respective fields. Click on the ‘Download’ button and salary details will be downloaded accordingly.
Path: Cloud Portal>Analytics>Data Wizard>Select Settings>Report Type>Add Fields>Select Category/Master/Earning/Deduction/User-Defined Fields>Save>Select Employee Status>From Month-Year>Save>Download
Path: Cloud Portal>Analytics>Data Wizard> click ‘+’ icon>Setting Name>Add>Add Fields> Category>Master Fields-tick Department and Designation>Save>under the Selected Fields section - tick checkboxes for Designation & Department>Save>Select Setting (you just created)>select other details >Download
Step 1: Log into the cloud portal, go to the ‘Analytics’ menu and click on the ‘Data Wizard’ submenu.
Step 2: ‘Select Setting’ or click on the ‘+’ icon, enter ‘Setting Name’ and click on the ‘Add’ button. Then click on the ‘Add Fields’ button.
Step 4: Select Category and under the ‘Master Fields’ tab tick checkboxes for ‘Department’ and ‘Designation’ and click on the ‘Save’ button.
Step 5: Under the ‘Selected Fields’ section and tick checkboxes for Designation and Department and then click on the ‘Save’ button. The setting for the report will be saved accordingly.
Step 6: ‘Select Setting’ you just created and other details such as Report Type, Employee Type, From Month year from the respective fields as required and click on the ‘Download’ button. The report will be downloaded accordingly.
Path: Cloud Portal>Analytics>Data Wizard> click ‘+’ icon>Setting Name>Add>Add Fields> Category>Separation Fields-tick required>Save>under the Selected Fields section - tick checkboxes for added fields>Save>Select Setting (you just created)>Employee Status-Separated>select other details >Download
Step 1: Log into the cloud portal, go to the ‘Analytics’ menu and click on the ‘Data Wizard’ submenu.
Step 2: ‘Select Setting’ or click on the ‘+’ icon, enter ‘Setting Name’ and click on the ‘Add’ button. Select ‘Report Type’ and click on the ‘Add Fields’ button.
Step 4: Select required ‘Category’ and under the ‘Master Fields’ tab tick checkboxes for required options such as Separation Date, Resignation Date etc and click on the ‘Save’ button.
Step 5: Under the ‘Selected Fields’ section and tick checkboxes for the fields just added then click on the ‘Save’ button. The setting for the report will be saved accordingly.
Step 6: ‘Select Setting’ you just created and other details such as Report Type, Employee Status, From Month-Year from the respective fields as required and click on the ‘Download’ button. The report will be downloaded accordingly.
Path: Cloud portal>Analytics>Data Wizard>Select Settings/+ Icon>Add Fields>Select Category, Earning, Deduction, Department>Save>select other fields as required >Save > Download
Step 1: Log into the cloud portal, go to the ‘Analytics’ menu and click on the ‘Data Wizard’ submenu.
Step 2: In the Data Wizard pop-up click on the various tabs such as Category, Master Fields, Earning Fields, Deductions fields tab, tick checkboxes for required fields and click on the ‘Save’ button.
Step 3: Select other details such as, Report Type, Employee Status, From Month-year and click on the ‘Download’ button. The payroll report downloaded accordingly.
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
Link:
For any queries, contact
