Brightwheel Invoice Creation
Appearance
| Step 1 | |||||
| Log in to Brightwheel | |||||
| Reporting | |||||
| Reports | |||||
| Deposits Report | |||||
| Input the dates of the month | |||||
| Export the file | |||||
| Download the deposit report as a google sheet | |||||
| Step 2 | |||||
| Open the Brightwheel Invoice Generator Template | |||||
| Select all of the downloaded deposit from the google sheet | |||||
| Copy the selected information | |||||
| Paste it into the template starting at Cell A5 | |||||
| Step 3 | |||||
| Use Column G to map the payment to the appropriate department | |||||
| p = Preschool | |||||
| s = School Age | |||||
| a = After School | |||||
| * don't forget to also map the refunds | |||||
| (scroll right to find parent names for refunds) | |||||
| These will sum the department totals in cells G1, G2 and G3 | |||||
| Verify that G4 matches Cell E2 | |||||
| Reference | |||||
| Column E is the amount that was paid for the student in Column F | |||||
| Column E sums in Cell E2 | |||||