The Custom Payroll Export feature provides enhanced flexibility for exporting payroll data, particularly when using third-party payroll providers with specific formatting requirements. This feature extends beyond the standard Advanced Export, offering over 20 additional data columns and the ability to create custom columns.
Additionally, this feature facilitates seamless integration with other payroll systems by allowing users to export data in formats compatible with their specific requirements.
The Free version of AlignOps (busybusy) does not support exporting pay period details to a CSV file. However, users can print Time Cards for the selected period as an alternative.
Exporting payroll data is essential for integrating AlignOps (busybusy) with other payroll systems. This process allows users to create custom CSV formats to match the requirements of their payroll system and import the data seamlessly.
Creating a Custom Payroll Export Format
Navigate to Payroll from the main menu.
Select Export Payroll.
Ensure Advanced is selected in the Select Type dropdown.
In the Format dropdown, select Create Custom Format.
Building the Custom Payroll Format
Enter a name for the custom format in the upper left corner. This is required to save and reuse the format.
Select the desired payroll data by checking the boxes in the left panel.
As selections are made, corresponding columns will appear in the middle window.
Remove unwanted columns by clicking the three dots next to the column name and selecting Remove Row.
Modify the column name by entering a new name under the Column Name field. The updated name will appear in the exported CSV file.
Reorder columns by clicking and holding the double-line handle on the right side, then dragging it to the desired position.
Modifying the Hours Column Format
Add Hours as a column in the custom report.
Click the three dots to the left of the Hours row and select Change Format.
Choose the desired format:
Decimal
HH:MM
Hours Minutes
Minutes
Seconds
Click Save to apply the format.
Adding a Custom Column
Click the three dots in the upper right corner and select Add Custom Column.
A custom column will be added to the bottom of the report.
Enter a column name and assign a default value if needed.
The default value will appear in every row under the custom column. If left blank, the rows will remain empty.
Saving and Exporting the Custom Payroll Format
Once the report is configured, click Submit to save the custom format.
Saved formats will be available in the Format dropdown.
To export payroll using a saved format, select the custom format name from the Format dropdown.
Click Export. The payroll data will be downloaded as a CSV file.
After exporting, the payroll data can be imported into other payroll systems, such as Gusto, which often provide smart import features to map hours to employees automatically.
