Docstoc

Cat Mask Template - Excel

Document Sample
Cat Mask Template - Excel Powered By Docstoc
					University of South Florida                                                                                              Journal Entry Spreadsheet
Journal      Business       Jrnl ID       Journal       Journal       Ledger            Reversal           Reversal     Journal       Currency
Header         Unit          Mask           ID           Date         Group              Code                Date       Source         Code      Journal Header Description

H          USF01             TAS           NEXT       07012003       ACTUALS                 N                            ONL           USD      Interdepartment charges for TAS
                                                                   N – Do not reverse
Journal Mask                                                       B – Reverse first day of the following period             ADDITIONAL FIELDS REQUIRED FOR CHARGING GRANTS OR CONSTRUCTION PROJECTS ONLY
    Insert your 3 letter department code here                      E – in the end (last day) of Do not
                                                            Only type Reverse white boxes.the following period         leave blank     GRT01     (GRANTS 10 digit)     BUDGET         leave blank     leave blank    leave blank      GLE
                                                            type over data in the grey boxes.
                                                                   D – Reverse on date specified                      from customer    USF01     (CONSTR 14 digit)   from customer   from customer   from customer   leave blank   leave blank
Col1   Col2             Col3           Col4          Col5          Col6              Col7               Col8          Col9       Col10       Col11                   Col12        Col13     Col14     Col15    Col16   Col17      Col18                                             Col19
Record                   Operating                                                                                       Budget  PC Business                                       Resource Resource Resource Analysis     Jrnl                                                                 1
  Type   Ledger              Unit       Account         Fund          Dept             Product           Initiative    Reference     Unit        Project *            Activity ID     Type   Category  Sub-Cat    Type  Reference Description                                           Amount
L      ACTUALS          TPA            75000         20000         120100            000000             0000000                  GRT01       1201003500              BUDGET                                    GLE                UCD #23442 Service                                       100.00
L      ACTUALS          TPA            74000         03406         034800            000000             0000000                                                                                                                                                                           -100.00

                                                                                                                       *Customer charges to GRANTS or CAPITAL CONSTRUCTION PROJECTS require additional values in this
                                                                                                                       section. See lines above for default values used by GRANTS (line 7 above). CONSTRUCTION values vary
                                                                                                                       and will be provided by your customer as noted on line 8.

                         Each line on the spreadsheet used to record data must begin with a Record
                         Type of L and a Ledger of ACTUALS

                                                                                                                                                                        Charges to customer expenses should be entered as positive numbers, credits to revenue should be entered
                                                                                                                                                                        as negative numbers. Debits & Credits must net to zero for the entry to be in balance.
                                If additional lines are needed be sure to insert them above the blue line below by right clicking on the line
                                number and selecting insert. NEVER insert or delete any columns on this spreadsheet or it will not load.




Insert Additional Lines Above This Line
                                                                                                                                                                                                                                                 Debits & Credits must equal zero            0.00




               c623e503-a921-4006-a0cf-657976f78abb.xls                                                                                                  Page 1                                                                                                                11/14/2010
University of South Florida                                                                                           Journal Entry Spreadsheet
Journal    Business      Jrnl ID     Journal   Journal Date      Ledger            Reversal           Reversal       Journal       Currency
Header       Unit         Mask         ID       MMDDYYYY         Group              Code                Date         Source         Code      Journal Header Description

H         USF01                       NEXT                     ACTUALS                  N                              ONL           USD      August 2003 AR Balance
                                                              N – Do not reverse
Journal Mask                                                  B – Reverse first day of the following period               ADDITIONAL FIELDS REQUIRED FOR CHARGING GRANTS OR CONSTRUCTION PROJECTS ONLY
                                                              E – Reverse end (last day) of the following period    leave blank     GRT01     (GRANTS 10 digit)     BUDGET         leave blank     leave blank    leave blank   GLE
                                                              D – Reverse on date specified                        from customer    USF01     (CONSTR 14 digit)   from customer   from customer   from customer   leave blank   GLE
Col1   Col2           Col3         Col4        Col5           Col6              Col7               Col8            Col9       Col10       Col11                   Col12       Col13     Col14     Col15    Col16   Col17      Col18                                       Col19
Record                 Operating                                                                                      Budget  PC Business                                      Resource Resource Resource Analysis     Jrnl                                                           1
  Type   Ledger            Unit     Account       Fund            Dept             Product           Initiative     Reference     Unit        Project *           Activity ID     Type   Category  Sub-Cat    Type  Reference Description                                    Amount
L      ACTUALS        TPA                                                                                                                                                                                                                                                    -75,534.28
L      ACTUALS        TPA                                                                                                                                                                                                                                                     75,534.28




Insert Additional Lines Above This Line
                                                                                                                                                                                                                                       Debits & Credits must equal zero            0.00




               Prepared by:____________________ Date: ________                                                       Approved by: ___________________ Date: ___________                                                               Posted by:_____________ Date:___________

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:79
posted:11/14/2010
language:English
pages:2
Description: Cat Mask Template document sample