An couple of examples for how to setup a general ledger. Scroll to the bottom of the page for a video example!
If my ledger was setup so that I wanted to pull center ID and type of program being offered, my segments might look like this-
Center | Center Identifer |
Smith Elementary | 01 |
Early Learning Center | 02 |
John Doe Middle School | 03 |
Account Name | Account Number |
School Year Tuition | 1000 |
Summer Tuition | 1001 |
Special Programs | 1002 |
When I pull financial reports I want to see strings that look like this, which is the pairing of site where the program is being held and the type of program being charged out.
GL String |
01.1000 |
02.1000 |
03.1000 |
01.1001 |
02.1001 |
03.1001 |
01.1002 |
02.1002 |
03.1003 |
To set this up in the system I would go to the GL builder- setup > system config, GL builder.
Then select GL builder-
Lets say I wanted to build out a GL string so that the system would look at the room category that is being billed in order to build the string in reporting. So this would be a VARIABLE code.
I might make my GL Code segment- or the shortcut code 100 so that I know it is variable.
Once the segment is saved, I would go to the detail icon in order to build out what the code actually means- or structure for how the system would associate billing to a code.
For segment 1, I want the system to tell me which site the revenue is being created at. So I am going to create the first segment as a variable field calling for the internal center ID.
(The internal center ID is found on the Home > General page- you would then want to go to each center level and add the center identifier.)
Once I press save detail the first segment of the string will display in the GL Code Segment Details box.
If I left the code like this, whichever type-fee or type- payment I associated with the short code of 100, ONLY the center ID would display on financial reports.
In the next segment I want to pull in the type of room/program I am billing out. Lets say that my categories were setup as Summer, School Year and Special days. I would want to pull segement 2 from the Room Category's GL code field.
To update this field I would go to the setup > room page and click on the category name
Then update the GL code field on the category with the related account number-
This would mean that whatever code I had on the room category would pull when I create a financial report.
I've created my structure for code 100-
I would place my short code of 100 on a specific valid value. In this case I want this string to pull whenever I bill out tuition in the system.
To add this short code to a valid value I would go to setup > system config, valid value.
On the valid value screen, I would scroll to the tuition option under type- fee and select the edit icon next to the valid value name-
Enter the GL short code in the GL Code field and press save-
Financial reporting might look like this-
Account # | GL Code Description | Create Date | Post Date | Member ID # | Name | Description | Valid Value Code | Debit | Credit |
01.1000 | Tuition | 04/10/2018 | 04/10/2018 | 317246 | Frozen Family | School Year Care | TUIT | 10.00 | |
01.1000 | Tuition | 04/10/2018 | 04/10/2018 | 317246 | Frozen Family | School Year Care | TUIT | 10.00 | |
01.1000 | Tuition | 04/11/2018 | 04/11/2018 | 317246 | Frozen Family | School Year Care | TUIT | 10.00 | |
01.1000 | Tuition | 04/11/2018 | 04/11/2018 | 317246 | Frozen Family | School Year Care | TUIT | 10.00 |
Another example: