The system provides the ability to export data to a CSV file format. To do this the scheduling is set up at the backend to generate the files based on the “Frequency” defined for each of the Data File to be exported.
A sample file format is shown below;
C:ErsBillingExportsTenantNameInvoiceFeedIndexInvoiceFeedIndex-2018-09-12.csv
Each part of the link shown above is detailed below.
C:ErsBillingExports\ |
This is the only configurable part of the link that shows the default download location but can be changed to where the user downloads the CSV file. |
TenantName\ |
The Client name |
InvoiceFeedIndex\ |
The File name |
InvoiceFeedIndex-2018-09-12.csv* |
The Name of the file downloaded with the date it was generated, included. |
The list of files that can be exported with the details of the data in them are described below.
File Name |
ParticipantPlanDebitFees |
Frequency |
Daily |
Description |
Provides a list of the total Plan Debit Fees charged to participants. |
Fields Generated |
|
File Name |
GLAccrualFile |
Frequency |
On the 25th of each Month |
Description |
Provides a summary rolled up by the GL Account / Cost Center Branch Field. It is a Monthly Accrual file based on the most recent Market Value and counts. |
Fields Generated |
|
File Name |
GLReceivableFile |
Frequency |
|
Description |
This report is a Summary rolled up by the GL Account / Cost Center Branch Field. It is a Receivable Report based on the actual Calculated Fees and the Ad Hoc Fees |
Fields Generated |
|
File Name |
GLPlanDebitCashReceipts |
Frequency |
After each Fee is generated and includes the Scheduled Plan Debit Fees |
Description |
This report is a Summary rolled up by the GL Account / Cost Center Branch Field. It is a Plan Debit (Cash Receipts) posting file for Plan Debit. |
Fields Generated |
|
File Name |
GLInvoiced&AdHocCashReceipts |
Frequency |
Daily: To include Invoice payments, Ad Hoc Plan Debit fees. |
Description |
This report is a summary rolled up by the GL Account / Cost Center Branch Field. It is a Posting file for payments for Invoiced Fees and Ad Hoc fee payments. |
Fields Generated |
|
File Name |
MemoPostFile |
Frequency |
Daily |
Description |
This is a Memo Post file for receipt of billed fees if Addvantage requires them to show on the Plan Statement. |
Fields Generated |
|
File Name |
InvoiceFeedIndex |
Frequency |
As and when the Invoice is generated |
Description |
This is a batch output of Invoices that is a batch file of individual Invoices with the index file. |
Fields Generated |
|
File Name |
PlanFundEqualization |
Frequency |
Monthly |
Description |
Shows the monthly amount based on the allocation to the Participants. |
Fields Generated |
|
File Name |
RevenueOffset |
Frequency |
Monthly |
Description |
Shows the monthly amount based on the allocation to the Recordkeeper, Sponsor or Other |
Fields Generated |
|
File Name |
CashReceiptEqualization |
Frequency |
Monthly |
Description |
This is a Cash Receipt posting file for Fee equalization that shows monthly amount based on the allocation to the Participants only. |
Fields Generated |
|
File Name |
ForfeituresUsedForOffset |
Frequency |
Monthly on the 1st business day |
Description |
This shows Forfeitures used during the previous month to offset Fees / Monthly Forfeitures used per Plan. |
Fields Generated |
|