FTE report by status/month

Email from customer:

On a monthly basis, I essentially want to reconcile our Sales Commissions for the company (we have 4 modules! (Little Sprouts, Building Blocks, Heartworks, STEAMworks & Loveworks, and Child’s World Academy). But this custom report can potentially be used for many other purposes. Some sample questions would be:

How many FTEs did we register/have waitlisted at {School Name} during the month of {December 2022}?

How many children does that include?

How many / much of registration fees (or waitlist fees) did we collect?

Below are the columns I’m looking for I think:

School Name

Full Name (or Last Name + First Name)

Date of Birth

Age

Primary Classroom

Enrollment Status

Status Start Date

Status End Date

Ledger Card

Description

GL Account

Comment

Amount

Ledger Post Date

FTE

Or Days Enrolled Mon-Friday AM and/or PM so we can calculate FTE???

Attached are the 2 reports I was able to compile, but it does not provide FTE data. And I believe the Deposit Payment Information (TEST – Registration & Waitlist Fees) Report does not provide the name of the child, just the payer.

· Corporate Data Viewer > Family Data > Child All Enrollment Status ((Pre-Registered & Waiting List : Enrollment Status))

· Corporate Data Viewer > Deposit Payment Information ((TEST – Registration & Waitlist Fees))

Is it possible to get this custom report for all of our modules? Or is there a way to pull this data from all of our modules at once? I’m not sure why we have 4 different modules. If so, is there a cost?