Journal Entry Accounting Workbook - Excel by gdy65554

VIEWS: 199 PAGES: 9

Journal Entry Accounting Workbook document sample

More Info
									                                                                                                                          23d4324c-7357-46bc-b6ea-d381c926a5ef.xls
                                                                                                                                          Participants as of 3/7/2011



COLUMBIA SKI CLUB                Trip Name               Dates
TRIP LEADERS                     TL Name                 ATL Name
         Name for Air Ticket       $0.00       $0.00                       Phone Numbers           E-mail   Emergency Contact                Birth    Roommate          Ski
#                                                        Mbr-ship
     First  Middle        Last     Paid      Still Due              Home        Cell       Work   Address   Name       Phone #   Smoker?     Date     Preference    Level
1                                  $0.00       $0.00
2                                  $0.00       $0.00
3                                  $0.00       $0.00
4                                  $0.00       $0.00
5                                  $0.00       $0.00
6                                  $0.00       $0.00
7                                  $0.00       $0.00
8                                  $0.00       $0.00
9                                  $0.00       $0.00
10                                 $0.00       $0.00
11                                 $0.00       $0.00
12                                 $0.00       $0.00
13                                 $0.00       $0.00
14                                 $0.00       $0.00
15                                 $0.00       $0.00
16                                 $0.00       $0.00
17                                 $0.00       $0.00
18                                 $0.00       $0.00
19                                 $0.00       $0.00
20                                 $0.00       $0.00
21                                 $0.00       $0.00
22                                 $0.00       $0.00
23                                 $0.00       $0.00
24                                 $0.00       $0.00
25                                 $0.00       $0.00
26                                 $0.00       $0.00
27                                 $0.00       $0.00
28                                 $0.00       $0.00
29                                 $0.00       $0.00
30                                 $0.00       $0.00
31                                 $0.00       $0.00
32                                 $0.00       $0.00
33                                 $0.00       $0.00
34                                 $0.00       $0.00
35                                 $0.00       $0.00
36                                 $0.00       $0.00
37                                 $0.00       $0.00
38                                 $0.00       $0.00
39                                 $0.00       $0.00
40                                 $0.00       $0.00
41                                 $0.00       $0.00
42                                 $0.00       $0.00
43                                 $0.00       $0.00
44                                 $0.00       $0.00
45                                 $0.00       $0.00
46                                 $0.00       $0.00
47                                 $0.00       $0.00
48                                 $0.00       $0.00
49                                 $0.00       $0.00
50                                 $0.00       $0.00
51                                 $0.00       $0.00
52                                 $0.00       $0.00
53                                 $0.00       $0.00
                                                                                                                                       23d4324c-7357-46bc-b6ea-d381c926a5ef.xls
                                                                                                                                                       Participants as of 3/7/2011



COLUMBIA SKI CLUB                Trip Name                                                                  Each Column below should match a "Deposit of Funds to Treasury" form
TRIP LEADERS                     TL Name                                                     Transfer In       Trip Pmt #1      Trip Pmt #2       Trip Pmt #3        Trip Pmt #4
         Name for Air Ticket       $0.00       $0.00             Notes             Trip    $0.00    From          $0.00             $0.00             $0.00              $0.00
#
     First  Middle        Last     Paid      Still Due   (special package info?)   Price     $       Trip      $       Chk.     $        Chk.     $        Chk.       $       Chk.
1                                  $0.00       $0.00
2                                  $0.00       $0.00
3                                  $0.00       $0.00
4                                  $0.00       $0.00
5                                  $0.00       $0.00
6                                  $0.00       $0.00
7                                  $0.00       $0.00
8                                  $0.00       $0.00
9                                  $0.00       $0.00
10                                 $0.00       $0.00
11                                 $0.00       $0.00
12                                 $0.00       $0.00
13                                 $0.00       $0.00
14                                 $0.00       $0.00
15                                 $0.00       $0.00
16                                 $0.00       $0.00
17                                 $0.00       $0.00
18                                 $0.00       $0.00
19                                 $0.00       $0.00
20                                 $0.00       $0.00
21                                 $0.00       $0.00
22                                 $0.00       $0.00
23                                 $0.00       $0.00
24                                 $0.00       $0.00
25                                 $0.00       $0.00
26                                 $0.00       $0.00
27                                 $0.00       $0.00
28                                 $0.00       $0.00
29                                 $0.00       $0.00
30                                 $0.00       $0.00
31                                 $0.00       $0.00
32                                 $0.00       $0.00
33                                 $0.00       $0.00
34                                 $0.00       $0.00
35                                 $0.00       $0.00
36                                 $0.00       $0.00
37                                 $0.00       $0.00
38                                 $0.00       $0.00
39                                 $0.00       $0.00
40                                 $0.00       $0.00
41                                 $0.00       $0.00
42                                 $0.00       $0.00
43                                 $0.00       $0.00
44                                 $0.00       $0.00
45                                 $0.00       $0.00
46                                 $0.00       $0.00
47                                 $0.00       $0.00
48                                 $0.00       $0.00
49                                 $0.00       $0.00
50                                 $0.00       $0.00
51                                 $0.00       $0.00
52                                 $0.00       $0.00
53                                 $0.00       $0.00
                                                                                                                                              23d4324c-7357-46bc-b6ea-d381c926a5ef.xls
                                                                                                                                                              Participants as of 3/7/2011



COLUMBIA SKI CLUB                Trip Name                               Each Column below should match a "Deposit of Funds to Treasury" form
TRIP LEADERS                     TL Name                 Trip Pmt #5        Trip Pmt #6      Trip Pmt #7       Trip Pmt #8        Trip Pmt #9       Trip Pmt #10       Trip Pmt #11
         Name for Air Ticket       $0.00       $0.00         $0.00              $0.00            $0.00             $0.00              $0.00             $0.00              $0.00
#
     First  Middle        Last     Paid      Still Due   $        Chk.      $        Chk.    $        Chk.     $        Chk.       $       Chk.      $       Chk.       $       Chk.
1                                  $0.00       $0.00
2                                  $0.00       $0.00
3                                  $0.00       $0.00
4                                  $0.00       $0.00
5                                  $0.00       $0.00
6                                  $0.00       $0.00
7                                  $0.00       $0.00
8                                  $0.00       $0.00
9                                  $0.00       $0.00
10                                 $0.00       $0.00
11                                 $0.00       $0.00
12                                 $0.00       $0.00
13                                 $0.00       $0.00
14                                 $0.00       $0.00
15                                 $0.00       $0.00
16                                 $0.00       $0.00
17                                 $0.00       $0.00
18                                 $0.00       $0.00
19                                 $0.00       $0.00
20                                 $0.00       $0.00
21                                 $0.00       $0.00
22                                 $0.00       $0.00
23                                 $0.00       $0.00
24                                 $0.00       $0.00
25                                 $0.00       $0.00
26                                 $0.00       $0.00
27                                 $0.00       $0.00
28                                 $0.00       $0.00
29                                 $0.00       $0.00
30                                 $0.00       $0.00
31                                 $0.00       $0.00
32                                 $0.00       $0.00
33                                 $0.00       $0.00
34                                 $0.00       $0.00
35                                 $0.00       $0.00
36                                 $0.00       $0.00
37                                 $0.00       $0.00
38                                 $0.00       $0.00
39                                 $0.00       $0.00
40                                 $0.00       $0.00
41                                 $0.00       $0.00
42                                 $0.00       $0.00
43                                 $0.00       $0.00
44                                 $0.00       $0.00
45                                 $0.00       $0.00
46                                 $0.00       $0.00
47                                 $0.00       $0.00
48                                 $0.00       $0.00
49                                 $0.00       $0.00
50                                 $0.00       $0.00
51                                 $0.00       $0.00
52                                 $0.00       $0.00
53                                 $0.00       $0.00
                                                                                                                                            23d4324c-7357-46bc-b6ea-d381c926a5ef.xls
                                                                                                                                                            Participants as of 3/7/2011



COLUMBIA SKI CLUB                Trip Name                                               Each Column below should match a "Deposit of Funds to Treasury" form
TRIP LEADERS                     TL Name                 Trip Pmt #12    Trip Pmt #13      Trip Pmt #14     Trip Pmt #15      Trip Pmt #16        Trip Pmt #17       Trip Pmt #18
         Name for Air Ticket       $0.00       $0.00         $0.00           $0.00             $0.00            $0.00              $0.00              $0.00              $0.00
#
     First  Middle        Last     Paid      Still Due    $       Chk.    $       Chk.      $       Chk.     $       Chk.      $        Chk.       $       Chk.       $       Chk.
1                                  $0.00       $0.00
2                                  $0.00       $0.00
3                                  $0.00       $0.00
4                                  $0.00       $0.00
5                                  $0.00       $0.00
6                                  $0.00       $0.00
7                                  $0.00       $0.00
8                                  $0.00       $0.00
9                                  $0.00       $0.00
10                                 $0.00       $0.00
11                                 $0.00       $0.00
12                                 $0.00       $0.00
13                                 $0.00       $0.00
14                                 $0.00       $0.00
15                                 $0.00       $0.00
16                                 $0.00       $0.00
17                                 $0.00       $0.00
18                                 $0.00       $0.00
19                                 $0.00       $0.00
20                                 $0.00       $0.00
21                                 $0.00       $0.00
22                                 $0.00       $0.00
23                                 $0.00       $0.00
24                                 $0.00       $0.00
25                                 $0.00       $0.00
26                                 $0.00       $0.00
27                                 $0.00       $0.00
28                                 $0.00       $0.00
29                                 $0.00       $0.00
30                                 $0.00       $0.00
31                                 $0.00       $0.00
32                                 $0.00       $0.00
33                                 $0.00       $0.00
34                                 $0.00       $0.00
35                                 $0.00       $0.00
36                                 $0.00       $0.00
37                                 $0.00       $0.00
38                                 $0.00       $0.00
39                                 $0.00       $0.00
40                                 $0.00       $0.00
41                                 $0.00       $0.00
42                                 $0.00       $0.00
43                                 $0.00       $0.00
44                                 $0.00       $0.00
45                                 $0.00       $0.00
46                                 $0.00       $0.00
47                                 $0.00       $0.00
48                                 $0.00       $0.00
49                                 $0.00       $0.00
50                                 $0.00       $0.00
51                                 $0.00       $0.00
52                                 $0.00       $0.00
53                                 $0.00       $0.00
                                                                                                                               23d4324c-7357-46bc-b6ea-d381c926a5ef.xls
COLUMBIA SKI CLUB          Trip Name                      Dates                                                                               SUMMARY as of 3/7/2011
TRIP LEADERS               TL Name                        ATL Name
          SECTION 1 - Payments from Participants                             SECTION 4 - CHECKS TO VENDOR                                           Trip Summary
   Date      Accepted by         Memo            Amount     Date     Chk #         Payee            Memo              Amount              Include TL & ATL's in this Count
                          Trip Pmt #1            $0.00                                                                                Published Trip Price
                          Trip Pmt #2            $0.00                                                                                  # of Participants
                          Trip Pmt #3            $0.00                                                                                1st Comp fr Vendor
                          Trip Pmt #4            $0.00                                                                                2nd Comp fr Vendor
                          Trip Pmt #5            $0.00                                                                                3rd Comp fr Vendor
                          Trip Pmt #6            $0.00                                                                                  Side Trip Comp
                          Trip Pmt #7            $0.00                                                                                 Minimum Discount
                                                                                                                                                                    $0.00
                          Trip Pmt #8            $0.00                                                                                Guaranteed to ATL
                          Trip Pmt #9            $0.00                                                    TOTAL:      $0.00            1/2 of 2nd vendor
                                                                                                                                                                    $0.00
                          Trip Pmt #10           $0.00                                                                                comp, going to ATL
                          Trip Pmt #11           $0.00                 SECTION 5 - Checks for Slush Expenditures                     ATL Discount still due
                                                                                                                                                                    $0.00
                          Trip Pmt #12           $0.00      Date     Chk #       Payee               Memo             Amount              from Club
                          Trip Pmt #13           $0.00
                          Trip Pmt #14           $0.00                                                                                       Slush And Admin Fees
                          Trip Pmt #15           $0.00                                                                                     Do Not Charge TL or ATL's
                          Trip Pmt #16           $0.00
                                                                                                                                         Slush / Person            $15.00
                          Trip Pmt #17           $0.00
                          Trip Pmt #18           $0.00
                                                                                                                                      Admin Fee / Person            $5.00
                                       TOTAL:     $0.00                                                   TOTAL:      $0.00

      SECTION 1a - Membership Fees & Bad Checks                          SECTION 6 - Other Checks (Refunds, etc)                          Accounting Summary
   Date    Journal Entry       Memo          Amount         Date     Chk #        Payee              Memo             Amount
                                                                                                                                         Total Income              $0.00

                                                                                                                                        Total Expenses             $0.00
                                                                                                                                      Balance Before Final
                                                                                                                                          Transfer (s)
                                                                                                                                                                   $0.00
                Total From Extra Sections Sheet   $0.00
                            Negative TOTAL:       $0.00                                                                                     For CSC Treasury use only

                                                                                                                                       Income Transfer             $0.00
                 SECTION 2 - Transfers In
                  Total From Participants Sheet   $0.00                             Total From Extra Sections Sheet   $0.00                  Date
                                                                                                                                                               Fill in Date and
                                      TOTAL:      $0.00                                                    TOTAL:     $0.00
                                                                                                                                                               Journal Entry if
                                                                                                                                         Journal Entry        Trip made money
      SECT.3 - Other Income ( Vendor Refunds, Etc.)                     SECTION 7 - NSF Fees,Transfers Out, Etc.
   Date     Check# / JE         Memo            Amount      Date      JE         Payee                Memo            Amount                For CSC Treasury use only
                                                                                  CSC         Admin Fees              $0.00
                                                                                                                                        LOSS Transfer              $0.00
                                                                                  CSC         1/4 of 2nd Comp         $0.00
                                                                                                                                             Date
                                                                                                                                                               Fill in Date and
                                                                                                                                                               Journal Entry if
                Total From Extra Sections Sheet   $0.00                             Total From Extra Sections Sheet   $0.00              Journal Entry
                                                                                                                                                               Trip lost money
                                       TOTAL:     $0.00                                                   TOTAL:      $0.00

 TOTAL INCOME:                          $0.00                 TOTAL EXPENSES:                               $0.00                      FINAL BALANCE               $0.00
                                                                                                              23d4324c-7357-46bc-b6ea-d381c926a5ef.xls
COLUMBIA SKI CLUB         Trip Name                       Dates                                                       Extra Section Boxes as of 3/7/2011
TRIP LEADERS              TL Name                         ATL Name
       SECTION 1a - Membership Fees & Bad Checks                             SECTION 6 - Other Checks (Refunds, etc)
   Date     Journal Entry       Memo          Amount        Date     Chk #          Payee                 Memo              Amount




             TOTAL to Main Accounting Sheet:    $0.00

                SECTION 2 - Transfers In
   Date     Journal Entry       Memo            Amount




             TOTAL to Main Accounting Sheet:    $0.00
                                                                                        TOTAL to Main Accounting Sheet:      $0.00

       SECT.3 - Other Income ( Vendor Refunds, Etc.)                         SECTION 7 - NSF Fees,Transfers Out, Etc.
   Date      Check# / JE         Memo            Amount     Date      JE             Payee                Memo              Amount




             TOTAL to Main Accounting Sheet:    $0.00                                   TOTAL to Main Accounting Sheet:      $0.00
                                                                                                                                 23d4324c-7357-46bc-b6ea-d381c926a5ef.xls
COLUMBIA SKI CLUB                      Trip Name                   Dates                                                                        Explanations as of 3/7/2011
TRIP LEADERS                           TL Name                     ATL Name

Things that add to
 vendor invoice
                   Vendor Price           #          $$$                                      Explanations for Unusual Circumstances
contract trip cost                                         $0.00
                                                           $0.00
Extra Air Fees                                             $0.00       Use this space to explain why some things were done.
Extra Lifts                                                $0.00
Single Supp                                                $0.00       For example, you can show why some cancellation were charged $25 and some were charged $50,
Insurance                                                  $0.00       why vendor penalties were assessed, how ATL trip discounts (Comps) were calculated, etc.
Insurance                                                  $0.00
Side Trips                                                 $0.00
Grocery stop                                               $0.00
                                                           $0.00
                                                           $0.00
                                                           $0.00
other                                                      $0.00
other                                                      $0.00
Penalties                                                  $0.00
Unsold Beds                                                $0.00
Unsold AirFare                                             $0.00
Late Fees                                                  $0.00
                                                           $0.00
       Total for things that add to vendor cost            $0.00


Things that reduce          Price
  vendor invoice         Difference
                                          #          $$$

No Airfare                                                 $0.00
No Van/Bus                                                 $0.00
No Lifts                                                   $0.00
No lodging                                                 $0.00
Senior Discount                                            $0.00
                                                           $0.00
                                                           $0.00
                                                           $0.00
                                                           $0.00
                                                           $0.00
                                                           $0.00
1st Comp                                                   $0.00
2nd Comp                                                   $0.00
3rd Comp                                                   $0.00
Side Trip Comp                                             $0.00
                                                           $0.00
     Total for things that reduce vendor cost              $0.00


      Total to Vendor                             $0.00
                                                                                                                           23d4324c-7357-46bc-b6ea-d381c926a5ef.xls
                                                                                                                                         Slush Budget as of 3/7/2011
COLUMBIA SKI CLUB                   Trip Name                     Dates
TRIP LEADERS                        TL Name                       ATL Name
           SLUSH SOURCE A - DESIGNATED $$ PER PERSON                                                     Estimated and Actual Expenses
   # of Paying Participants                                                                                                       $$ Provided      Estimated      Actual
                                      Slush per Person   Amount                                Description
    Don't Count TL or ATL                                                                                                                By        Expenses      Expenses
                                          $15.00         $0.00        Advertising
                                                TOTAL:   $0.00        Postage
                                                                      Trip Skit
                            Slush Source B - Comps
           1/4 of Second Comp from Vendor                $0.00
                            other
                                                TOTAL:   $0.00        Pre-Trip Party


                  SLUSH SOURCE C - CANCELLATION FEES
       # of Cancellations             Cancellation Fee   Amount
                                          $25.00         $0.00
                                          $50.00         $0.00        On-Trip Welcome Breakfast
                                                         $0.00
                                                TOTAL:   $0.00


                SLUSH SOURCE D - SPECIAL PACKAGE FEES
       Option               # Per      Option Markup     Amount       On-Trip Dinner & Party
      No Bus                                             $0.00
     No Airfare                                          $0.00
   No Lift Tickets                                       $0.00
  3rd/4th in Room                                        $0.00
                                                         $0.00        Post-Trip Party
                                                         $0.00
                                                         $0.00
                                                TOTAL:   $0.00



                  TOTAL SLUSH:                           $0.00
                                                                      Taxi Driver Tips


                              PROJECTED                                                                                      Estimated Total: >>    $0.00
                                                                                                                                              Actual Total: >>
                               BALANCE                                                                                                                            $0.00



                                    $0.00                                                TOTAL EXPENSES:                                                 $0.00
                                                                         23d4324c-7357-46bc-b6ea-d381c926a5ef.xls
COLUMBIA SKI CLUB             Trip Name             Dates                                  Wait List as of 3/7/2011
TRIP LEADERS                  TL Name               ATL Name


                Name                Phone Number                E-mail     Wait List Deposit
 #
        First          Last        Home      Work              Address    Date    $$    Check

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20

								
To top