Location: Employer Contribution Import Process
The Employer Contribution Import process imports a flat file of member/employer contributions, validates the individual contributions against client-specified expected amount. A check entry can be validated against the contribution totals prior to posting the contribution data to the appropriate member records. The system also provides a method to determine the next month's expected remittance.
The individual events in this process are meant to be run in sequence.
Use the following steps as a guide to run the Employer Contribution Import process online.
To perform the Import Contributions event, complete the following steps:
From the Employer Contribution Import process, click to select the Import Contributions event. The system displays the Data Import wizard.
Using the Browse button, navigate to the Contributions data file and then click Submit.
The system displays an 'Import completed' Status message. Note: Further information may be provided regarding invalid records.
Click Next to provide access to the Import Log file(s).
Click the View icon beside the Bad Records file (if any) to open and view records that could not be loaded.
Click the View icon beside the Run file to open and view the Import Log file. For a technical user, the Import Log file contains much useful information, but even for the non-technical user, this file displays the Date and Time the import was run and the names of the Control and Data file used. Example:
If you scroll down the file, you can view further information, such as the number of rows successfully loaded and read and the number of rows rejected. Notice that the time taken to run the import was approximately five seconds. Example:
The following Supporting Views are available from the Import Contributions event screen.
Imported Data
Errors
Upload History
Accounts
Totals
Invoices
Receipts
Events
From the Receive Contributions process, click to select the View Imported Data event. The system displays the import buffer.
From the Employer Contribution Import process, click to select the Validate Import event. The system displays the Batch Import wizard with the Test imported buffer task selected.
Click Finish to run the Validate data task .
From the Employer Contribution Import process, click to select the View Errors event. The system displays Errors generated via the Test imported buffer task.
From the Employer Contribution Import process, click to select the Post Invoices and Buffer event. The system displays the Batch Import wizard with the Post imported buffer task selected.
If the Summary is correct, click Finish. The system then posts the contributions to the appropriate member records.
From the Employer Contribution Import process, click to select the Cheque Entry event. The system launches the Receipt wizard.
From the Account drop-down list, select the appropriate account, in this case, Account No3510.
From the Type drop-down list, select Employer Contributions.
Click Next to advance to the next screen.
If this cheque matches an invoice, select the Invoice No. In this case, it is not selected.
Enter a Control/Reference No., if appropriate.
Using the calendar, enter the Date Received.
Select Cheque from the Pay Method list.
Enter the Amount.
Using the calendar, enter the Transaction Date.
If appropriate, type a Memo in the text field.
Click Next to display a Summary.
If the Summary is correct, click Finish. The system displays the Employer's Accounts browser. Select the appropriate Account No. in the primary browser to view the entry you just made in the secondary browser.
From the Employer Contribution Import process, click to select the Create Next Month's Remittance event. The system displays Estimate next billing batch task.
Click Finish. The system displays the invoices generated by the batch.
For more information, see About Web Administrator Processes.
Build 1128
