| zeta user id | emp code | emp payout name | emp payout email | emp payout phone | emp profile name | emp profile email list (verified) | emp profile email list (non-verified) | emp profile phone | product type | program name | yearly eligibility | opening balance (INR) | total disbursed amt (INR) | revoked by corp amt (INR) | net disbursed amt (INR) | spent from card amt (INR) | refund to card amt (INR) | net spent from card amt (INR) | no. of bills submitted | no. of bills approved | no. of bills rejected | no. of bills pending | bill claimed amt (INR) | bill approved amt against trasactions on Zeta (INR) | bill approved amt against transactions off Zeta (INR) | total bill approved amount (INR) | bill rejected amt (INR) | bill pending amt (INR) | total reimbursed amt (INR) | escrow balance moved to FA amt (INR) | closing balance | card state | card closure date | card closure amt (INR) | |||
| user id on the zeta system | Employee Code provided by the corporate in the latest order file | Name mentioned on the latest order file | Email mentioned on the latest order file | Mobile number mentioned on the latest order file | Name of the user entered in his/her zeta profile | Verified email(s) of the user entered in his/her zeta profile | Unverified email(s) of the user entered in his/her zeta profile | Mobile numbers of the user entered in his/her zeta profile | Type of the benefit program | Name of the benefit program (created by the corporate) | Yearly Eligibility mentioned on the latest order file | Balance in the corresponding benefit card, as on April 1st 2017 | Total Amount paid out by the corporate to the employee towards the corresponding benefit program [Includes deposits to benefit card as well as escrow deposits] | Total Amount revoked by the corporate from the employee for the corresponding benefit program [includes revokes from benefit card as well as escrow] | Column 'N' MINUS Column 'O' | Total value of debits from the corresponding benefit card - does NOT include revokes and debits against claim reimbursement | Total value of refunds to the corresponding benefit card | Column 'Q' MINUS Column 'R' | Total no. of bills submitted on the zeta system against the corresponding benefit card | Total no. of bills approved by zeta against the corresponding benefit card | Total no. of bills rejected by zeta against the corresponding benefit card | Total no. of bills pending to be processed by zeta against the corresponding benefit card | Total value of bills submitted on the zeta system against the corresponding benefit card | Total value of bills approved (against the corresponding benefit card) against claims made when the spends happened through zeta itself | Total value of bills approved (against the corresponding benefit card) against claims made when the spends did NOT happen through zeta | Total value of bills approved on the zeta system against the corresponding benefit card [Column Y + Column Z] | Total value of bills rejected on the zeta system against the corresponding benefit card | Total value of bills pending to be processed by zeta against the corresponding benefit card | Total amount reimbursed to the employee against claims made on the corresponding benefit card | Amount moved from escrow to corporate's Funding Account as part of card closure (Year End Closure as well as Employee FnF Closure) | Balance in the corresponding benefit card, when the card was closed | There are cards in Active, Disabled (Paused), and Closed states in the zeta system. As part of Year End Closure, all the cards will be CLOSED | Date when the card closure happened | Amount moved from the benefit card (to either Funding Account or Cash Card [as applicable for the corporate]), as part of card closure | |||
| 1 | E001 | Emp 1 | emp1@test.com | Employee 1 | emp1@test.com | emp1@xyz.com | 8877665544 | Communication | Communications | 12000 | 0.00 | 4,998.00 | 0.00 | 4,998.00 | 0.00 | 0.00 | 0.00 | 5 | 4 | 1 | 0 | 5,810.00 | 0.00 | 4,571.00 | 4,571.00 | 1,239.00 | 0.00 | 3,332.00 | 1,666.00 | 0.00 | CLOSED | 20/01/18 | 0 | ||||
| 1 | E001 | Emp 1 | emp1@test.com | Employee 1 | emp1@test.com | emp1@xyz.com | 8877665544 | LTA | LTA Card | 60000 | 0.00 | 30,000.00 | 0.00 | 30,000.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 10,000.00 | 0.00 | CLOSED | 20/01/18 | 20000 | ||||
| 1 | E001 | Emp 1 | emp1@test.com | Employee 1 | emp1@test.com | emp1@xyz.com | 8877665544 | Medical | Medical Card | 15000 | 0.00 | 7,500.00 | 0.00 | 7,500.00 | 0.00 | 0.00 | 0.00 | 6 | 5 | 1 | 0 | 5,598.00 | 0.00 | 5,000.00 | 5,000.00 | 598.00 | 0.00 | 5,000.00 | 2,500.00 | 0.00 | CLOSED | 20/01/18 | 0 | ||||
| 2 | E002 | Emp 2 | 9876543210 | Employee 2 | emp2@test.com | 9876543210 | Communication | Communications | 20000 | 0.00 | 20,000.00 | 0.00 | 20,000.00 | 10,807.00 | 3,800.00 | 7,007.00 | 19 | 15 | 4 | 0 | 17,771.00 | 5,000.00 | 7,908.00 | 12,908.00 | 4,863.00 | 0.00 | 12,908.00 | 0.00 | 0.00 | CLOSED | 26/03/18 | 5085 | |||||
| 2 | E002 | Emp 2 | 9876543210 | Employee 2 | emp2@test.com | 9876543210 | DriverSalary | Driver Salary Card | 59100 | 0.00 | 59,100.00 | 0.00 | 59,100.00 | 0.00 | 0.00 | 0.00 | 5 | 4 | 1 | 0 | 60,000.00 | 0.00 | 55,000.00 | 55,000.00 | 5,000.00 | 0.00 | 55,000.00 | 0.00 | 0.00 | CLOSED | 26/03/18 | 4100 | |||||
| 2 | E002 | Emp 2 | 9876543210 | Employee 2 | emp2@test.com | 9876543210 | Fuel | Fuel Card | 1000 | 0.00 | 1,000.00 | 0.00 | 1,000.00 | 400.00 | 0.00 | 400.00 | 2 | 2 | 0 | 0 | 900.00 | 300.00 | 600.00 | 900.00 | 0.00 | 0.00 | 900.00 | 0.00 | 0.00 | CLOSED | 26/03/18 | 0 | |||||
| 2 | E002 | Emp 2 | 9876543210 | Employee 2 | emp2@test.com | 9876543210 | LTA | LTA Card | 60000 | 0.00 | 40,000.00 | 0.00 | 40,000.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | CLOSED | 26/03/18 | 40000 | |||||
| 2 | E002 | Emp 2 | 9876543210 | Employee 2 | emp2@test.com | 9876543210 | Medical | Medical Card | 15000 | 0.00 | 10,000.00 | 0.00 | 10,000.00 | 1,876.25 | 0.00 | 1,876.25 | 14 | 11 | 3 | 0 | 9,862.00 | 0.00 | 7,526.00 | 7,526.00 | 2,336.00 | 0.00 | 7,526.00 | 0.00 | 0.00 | CLOSED | 26/03/18 | 597.75 |
Overview
Content Tools
- Powered by Atlassian Confluence 6.13.4
- Printed by Atlassian Confluence 6.13.4
- Report a bug
- Atlassian News