Financial- General Ledger Account Example

Prev Next

An couple of examples for how to setup a general ledger.


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.

image.png

Then select GL builder-

image.png

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.

image.png

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.

image.png

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.

image.png

(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.)
image.png

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.
image.png

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.

image.png

To update this field I would go to the setup > room page and click on the category name

image.png

Then update the GL code field on the category with the related account number-

image.png

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-

image.png

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.

image.png

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-

image.png

Enter the GL short code in the GL Code field and press save-

image.png

Financial reporting might look like this-

Account # GL Code Description Create Date Post Date Member ID # Name Description Valid Value Code Debit Credit
01.100 Tuition 04/10/2018 04/10/2018 317246 Frozen Family School Year Care TUIT 10.00
01.1000 Tuition 04/10/2018 4/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