ELRC Invoice Generator - Revision history

Serenity152102: update

2023-10-26T15:59:37Z

update

← Older revision		Revision as of 15:59, 26 October 2023
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

Serenity152102 at 14:27, 6 August 2023

2023-08-06T14:27:33Z

← Older revision		Revision as of 14:27, 6 August 2023
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 do that month		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

Serenity152102 at 21:08, 5 August 2023

2023-08-05T21:08:30Z

← Older revision		Revision as of 21:08, 5 August 2023
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:

Serenity152102: 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..."

2023-08-05T21:04:47Z

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..."

New page

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 do that month

Column H: Check the box if the child will receive a registration fee

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

-------------

The rates in Column E can be edited by editing cells T7 - T12