ELRC Invoice Generator: Difference between revisions
Created page with "To generate the monthly ELRC invoice, open the ELRC Invoice Generator. When you have finished editing the form the: B1 = total amount of the invoice to be allocated to Preschool B2 = total amount of the invoice to be allocated to School Age B3 = total amount of the invoice to be allocated to After School B4 = total amount of the invoice DO NOT EDIT THE GREY CELLS Column A: Enter or verify the care level for which the child is approved. Column B: Enter the child's la..." |
update |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
To generate the monthly ELRC invoice, open the ELRC Invoice Generator. | To generate the monthly ELRC invoice, open the [https://docs.google.com/spreadsheets/d/17WWblDCFYnIu9DO4cEczgKU9wDO-J-PhyDAAPgkqGwc/edit#gid=502472481 ELRC Invoice Generator]. | ||
When you have finished editing the form the: | When you have finished editing the form the: | ||
| Line 21: | Line 21: | ||
Column F: Enter the child's co-pay amount | Column F: Enter the child's co-pay amount | ||
Column G: Enter the number of copayments | Column G: Enter the number of copayments due that month | ||
Column H: Check the box if the child will receive a registration fee | Column H: Check the box if the child will receive a registration fee (When it is the child's first month) | ||
Column I: DO NOT EDIT - This cell column will auto-populate | Column I: DO NOT EDIT - This cell column will auto-populate | ||
| Line 38: | Line 38: | ||
Column M: DO NOT EDIT - This cell column will auto-populate | Column M: DO NOT EDIT - This cell column will auto-populate | ||
Once an invoice is generated it should be saved in the shared Google drive under Sprouts -> ELRC Invoices | |||
------------- | ------------- | ||
The rates in Column E can be edited by editing cells T7 - T12 | The rates in Column E can be edited by editing cells T7 - T12 | ||
Latest revision as of 15:59, 26 October 2023
To generate the monthly ELRC invoice, open the ELRC Invoice Generator.
When you have finished editing the form the: B1 = total amount of the invoice to be allocated to Preschool B2 = total amount of the invoice to be allocated to School Age B3 = total amount of the invoice to be allocated to After School B4 = total amount of the invoice
DO NOT EDIT THE GREY CELLS
Column A: Enter or verify the care level for which the child is approved.
Column B: Enter the child's last name
Column C: Enter the child's last name
Column D: Enter the number of days the child was in care
Column E: DO NOT EDIT - This column will auto-populate
Column F: Enter the child's co-pay amount
Column G: Enter the number of copayments due that month
Column H: Check the box if the child will receive a registration fee (When it is the child's first month)
Column I: DO NOT EDIT - This cell column will auto-populate
Column J: Enter the department in which the child is enrolled
"p" = Preschool
"s" = School Age
"a" = After School
Column K: DO NOT EDIT - This cell column will auto-populate
Column L: DO NOT EDIT - This cell column will auto-populate
Column M: DO NOT EDIT - This cell column will auto-populate
Once an invoice is generated it should be saved in the shared Google drive under Sprouts -> ELRC Invoices
The rates in Column E can be edited by editing cells T7 - T12