Docstoc

Expense Tracker (Excel download)

Document Sample
Expense Tracker (Excel download) Powered By Docstoc
					 Date   ! Payee/Description                        Cat.    Spend ($)  Receive ($) Acct       TOTAL       CODE
   01/01 AVERAGE Car Insurance (per month)         CarI       $106.00                          $106.00   Recd
   01/02 AVERAGE income tax (per month)            Tax                                   $     106.00    Church
   01/02 AVERAGE Car tax (per month)               Tax         $44.00                    $     150.00    Tax
   01/03 AVERAGE Life Insurance (per month)        Life        $46.88                    $     196.88    Life
          Phone                                   Phone                                  $     196.88    CarI
          Offering                                church                                 $     196.88    Util
   04/18 MUD utilities                             Util        $82.59             CC1    $     279.47    Phone
          OPPD Electricity                         Util                                  $     279.47    Food
               SAMPLE TRANSACTIONS                                                       $     279.47    Goods
   04/18 HyVee                                    food         $48.64             cc1    $     328.11    Cl
   04/18 Gas                                       gas         $31.35             cc2    $     359.46    Gas
   04/19 McDonalds                                 rest        $15.47             CA     $     374.93    CarM
   04/19 Bought couch - Craigslist                equip        $89.00             CH     $     463.93    Serv
   04/19 House of Mufflers - Replace brake pads   CarM        $156.50             cc1    $     620.43    Gift
   04/23 Gas                                       gas         $24.58             cc1    $     645.01    Mail
                                                                                         $     645.01    Med
                                                                                         $     645.01    School
                                                                                         $     645.01    Equip
                                                                                         $     645.01    Ent
                                                                                         $     645.01    Ed
                                                                                         $     645.01    rest
                                                                                         $     645.01    Misc
                                                                                         $     645.01
                                                                                         $     645.01
                                                                                         $     645.01
                                                                                         $     645.01
                                                                                         $     645.01
                                                                                         $     645.01
                                                                                         $     645.01
                                                                                         $     645.01
                                                                                         $     645.01
                                                                                         $     645.01
                                                                                         $     645.01
                                                                                         $     645.01    CODE
                                                                                         $     645.01    CC1
                                                                                         $     645.01    CC2
                                                                                         $     645.01    SC1
                                                                                         $     645.01    SC2
Register Report                                                Page 1                   File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 Date     ! Payee/Description   Cat.   Spend ($)    Receive ($) Acct       TOTAL      CODE
                                                                       $     645.01   CA
                                                                       $     645.01   CH
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01   Date
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01   Date
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
Register Report                            Page 2                  File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 Date     ! Payee/Description   Cat.   Spend ($)    Receive ($) Acct       TOTAL      CODE
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01
                                                                       $     645.01




Register Report                            Page 3                  File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 Date     ! Payee/Description   Cat.   Spend ($)    Receive ($) Acct   TOTAL     CODE




Register Report                            Page 4                  File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 Date     ! Payee/Description   Cat.   Spend ($)    Receive ($) Acct   TOTAL     CODE




Register Report                            Page 5                  File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 Date     ! Payee/Description   Cat.   Spend ($)    Receive ($) Acct   TOTAL     CODE




Register Report                            Page 6                  File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 Date     ! Payee/Description   Cat.   Spend ($)    Receive ($) Acct   TOTAL     CODE




Register Report                            Page 7                  File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 Date     ! Payee/Description   Cat.   Spend ($)    Receive ($) Acct   TOTAL     CODE




Register Report                            Page 8                  File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 CATEGORIES                          USD ($)                             DIRECTIONS
 Money in                        $         -    DIRECTIONS
 Offerings and help              $         -    ALL expenses are entered in the spreadsheet on the left
 Taxes                           $      44.00   (columns A through G). Sample transactions are included.
 Life Insurance                  $      46.88   The lines in purple are annual or semi-annual expenses. We
 Car Insurance                   $     106.00   turn the figure into a monthly amount so we don't
 Utilities                       $      82.59   "accidentally" spend that money. Those numbers are usually
 Phone and internet              $         -    carried forward without changes month to month. Lines in
 Food                            $      48.64   blue are monthly, recurring expenses. I enter the amount
 Household Items                 $         -    when it is paid. Total expenses for the month are
 Clothing                        $         -    automatically updated in Column H.
 Gas                             $      55.93
 Maintenance for car             $     156.50   DIRECTIONS - Categories - Columns J - L
 Services                        $         -    The Categories listed in columns J - L are fully
 Gifts                           $         -    customizable. Change them to whatever you want!
 Mail                            $         -    Whatever you enter for "Code" in Column J becomes
 Medical and dental expenses     $         -    allowable text in Column D… and then is
 School                          $         -    automatically tracked and added in the Categories
 Equipment and Furniture         $      89.00   section.
 Entertainment                   $         -
 Education (Michael and Jenny)   $         -    NOTE: Start a NEW sheet each month and clear
 Restaurant                      $      15.47   your expenses! Then you can compare months to
 Miscellaneous                   $         -    see and evaluate fluxuations.
 Blank / Uncategorized!          $         -




 TOTAL                           $     645.01

          PAYMENT TYPE
 Credit Card 1                   $     312.31   DIRECTIONS - Payment Type
 Credit Card 2                   $      31.35   OPTIONAL: If you want to track how much has been charged
 Store Card 1                    $        -     to a credit card, spent in cash, spent from checking, etc., then
 Store Card 2                    $        -     see the section below "Categories." Again, this section is fully
Register Report                                                                                       allowable
                                                customizable. Whatever you enter in "Code" is thenFile name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
                                                                         Page 9
                                                text for Column G. Amounts are tracked and added so you
                                                always know how much you charged to any given card.
                                        OPTIONAL: If you want to track how much has been charged
                                        to a credit card, spent in cash, spent from checking, etc., then
 CATEGORIES                  USD ($)                              DIRECTIONS
                                        see the section below "Categories." Again, this section is fully
 Cash                    $      15.47   customizable. Whatever you enter in "Code" is then allowable
 Check                   $      89.00   text for Column G. Amounts are tracked and added so you
 Blank / Uncategorized   $     196.88   always know how much you charged to any given card.


 Non-routine expenses
                                        OPTIONAL: Did you have non-routine expenses
                                        or income, and want to make a note of it? This
                                        would be the place to do it.




 TOTAL                   $        -

 Irregular income




Register Report                                               Page 10                        File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 CATEGORIES           USD ($)    DIRECTIONS




 TOTAL            $         -




Register Report                 Page 11       File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 CATEGORIES       USD ($)    DIRECTIONS




Register Report             Page 12       File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 CATEGORIES       USD ($)    DIRECTIONS




Register Report             Page 13       File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 CATEGORIES       USD ($)    DIRECTIONS




Register Report             Page 14       File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 CATEGORIES       USD ($)    DIRECTIONS




Register Report             Page 15       File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
 CATEGORIES       USD ($)    DIRECTIONS




Register Report             Page 16       File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
Register Report   Page 17   File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
Register Report   Page 18   File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
Register Report   Page 19   File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
Register Report   Page 20   File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
Register Report   Page 21   File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
Register Report   Page 22   File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
Register Report   Page 23   File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls
Register Report   Page 24   File name: 3434d5fa-8a55-435e-90a1-54d040ac40f5.xls

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:25
posted:4/9/2012
language:English
pages:24