GL Tutorial-FBM091 GL, FBM090 & FBM091-SL

General Ledger Tutorial

FBM091 GL-Tieing to the SLs

Again the following report is without header, middle columns and the batch ref/date column.

When thinking about how the GL report ties to the SL reports, you might think of peeling back layers. The top layer, the GL, provides budget, revenue, expense and encumbrance summaries. You can find how much you've earned or spent in total, but you don't know how or for what.

To find out you would go to the next layer, the FBM090, the first SL report. This report summarizes budget, revenue, expense and encumbrances by object code. So now you know what makes up the summaries reported on the GL. But you still don't know exactly what kind of transaction resulted in the amount that is summarized in a particular object code.

To get more detail you would go to the final layer, the FBM091 SL. Here you would find the current month's activity listed in detail, i.e., what document initiated the transaction, for how much, who processed it, etc.

To follow an amount through the different reports, click on a yellow letter (scroll down to see the letters). Continue clicking on the letter and eventually you will return to this report, so that you can tie the next letter. The yellow continue link at the bottom will take you to the last slide of the tutorial.

The following summarizes the numbers that can be tied to the SL reports.

2100, Accounts Payable (TC 068) ties to FMB091-SL
Summaries (9xxx) ties to FBM090, FBM091-SL.
Fund Balance Change (FBM090, FBM091-SL)

As you trace the numbers through the report, consider the following. The answers will be provided at the end.

The Fund Balance Change (letters X & Z) may not always tie to the FBM090 REV LESS EXP and FBM091-SL ACCOUNT TOTAL. Why? (HINT: What is Fund Balance Change equal to?)
Check out object code 5230 on the FBM091 SL. Notice the JE OFFSET ACCOUNT is the General Ledger account (018350-2100) and that the rest of the line (DESCRIPTION, TC, REF, etc.) reads like that on the GL. Why doesn't a transaction post to the Subsidiary Ledger when the check is cut?

                                                                                                                                      
ACCT                                        PREVIOUS         CURRENT          TOTAL      
CTL   DESCRIPTION                            BALANCE          MONTH          TO DATE  
                                                                                                                                       
                                                                                                                                     
1100     TOTAL EQUITY IN POOLD CASH         54,959.92-*      5,727.38 *     49,232.54-*                
                                                                                                                                       
1140     TOTAL PETTY CASH                      100.00 *                        100.00 *             
                                                                                                                                       
2100  DEBORAH L. *LONGANEC                                      69.00                  
      DEBORAH L. *LONGANEC                                      18.57                  
      DEBORAH L. *LONGANEC                                       7.95               
      DEBORAH L. *LONGANEC                                      18.57- A               
      DEBORAH L. *LONGANEC                                       7.95-            
      DEBORAH L. *LONGANEC                                      69.00-           
2100     TOTAL ACCOUNTS PAYABLE                                                                                                        
                                                                                                                                       
3160     TOTAL FUND BAL-AUXILIARIES         54,859.92 *      5,727.38-*      49,132.54 *                
                                                                                                                                       
4210     TOTAL FEDERAL GRANTS & CON          1,500.00-*                       1,500.00-*                
                                                                                                                                      
9110     TOTAL UNR CUR.BUD.-REVENUE        197,400.00-*                     197,400.00-* B              
                                                                                                                                       
9120     TOTAL UNR CUR.BUD.-EXPENSE        192,100.00 *                     192,100.00 * C              
                                                                                                                                       
9130     TOTAL UNR CUR.BUD-SURP/DEF          5,300.00-*                       5,300.00-*              
                                                                                                                                       
9310     TOTAL REV SUMM-STATE/AUX           35,935.00-*      16,662.50-* D   52,597.50-*  E             
                                                                                                                                       
9510     TOTAL EXP SUMM-STATE/AUX           75,724.03 *      10,935.12 * F   86,659.15 *  G             
                                                                                                                                       
9610     TOTAL ENC SUMM-STATE/AUX          192,012.04 *      91,769.52-* H  100,242.52 *  I              
                                                                                                                                     
                                                                                                                                       
      FUND BALANCE CHANGE                   38,289.03        5,727.38-  X    32,561.65    Z

[continue]