There are several export formats available on ExpenseIn, including a ready-made Cascade Payroll CSV export format for importing expenses into IRIS Cascade HR.
Prerequisites
Before you add our Cascade Payroll export format to your account, you'll need to ensure your Admin area is configured. Follow the points below to ensure you have the correct references set up in ExpenseIn.
Users - Review or edit your users to ensure the User References match the Employee IDs in IRIS Cascade HR.
Categories - Upon connecting the IRIS Cascade HR integration, a Custom Field called "Cascade Pay Element ID" will automatically be created against your categories. You'll need to edit your categories to populate this field with the relevant Pay Element ID from IRIS Cascade HR.
How to add the Cascade Payroll CSV export format
Once the Admin area has been configured to match your IRIS Cascade HR account, you can add the Cascade Payroll CSV export format to your account by following the steps in our Add an export format to different areas Help Article.
Once added, you can see which areas of the system the export format is available in and adjust this as required.
How to use the Cascade Payroll export format
Note: If you're unsure how to import Pay Element Data into IRIS Cascade HR, before using the Cascade Payroll export format we suggest reviewing the IRIS Cascade HR documentation or reaching out to the IRIS Cascade Support team.
To use the Cascade Payroll export format to export your expenses, follow the steps below:
1. Navigate to the relevant section of ExpenseIn, e.g., in the Finance area, click Reimbursable (under the Approved subheading).
2. Locate the expenses you'd like to report on; you can use the Filter options available to refine your search.
3. Tick the Select All checkbox or tick the checkboxes next to the expenses you wish to export.
4. Click the Export button and select either Export All or Export Selected.
5. Populate the fields in the Export Expenses window.
Note: If you're connected to one of our accounting package integrations, you'll need to select the File option for this window to appear.
Report Name - give your export file a name.
Format - select the Cascade Payroll export format from the list of available Export Formats set up in the Admin area of your account.
File Destination - select the destination you'd like the file to be exported to; this can be a regular download to your browser or a configured outbound file delivery.
Export Actions - depending on the section of the system you're exporting from, you'll also be presented with other Export Actions, e.g., Mark as paid/reconciled/completed.
Include Receipts - tick the checkbox if you require a downloaded copy of the receipts attached to the expenses you are exporting.
6. Click Export, and your file download will begin.
Additional Information
The exported file automatically uses the names of the columns that IRIS Cascade HR requires so that the import process is as easy as possible. The CSV file will contain the following columns (the header is omitted):
Employee Id - ExpenseIn User Reference.
Pay Element Id - Cascade Pay Element ID (Custom Field against the Category).
Amount - Gross total for the user’s expenses for the selected Pay Element Id value. This value is always output as a positive value.
Earning or Deduction -
E - when the user’s total for the selected Pay Element Id is positive.
D - when the user’s total for the selected Pay Element Id is negative.