Farm Income Tax Record - Excel by rub12667

VIEWS: 65 PAGES: 2

More Info
									     MO 2-FLP Guide 15                                                                                 Fillable FL Reconciliation
     (Rev. 2-8-2002)
                                       Family Living Reconciliation Table
                   [Obtain from Income Tax Records, Credit Report, Bank Accounts, and Loan History Records]
     [Record any and all transactions between the "beginning and ending" date of the tax year.] Do Not enter negative numbers.

 1   Total gross farm income (Schedule F)
 2   Deduct total gross farm expenses (Schedule F)                                                (-)
 3   Add any loan(s) used to refinance Schedule F cash farm expenses                              (+)
 4   Add depreciation expense (Schedule F)                                                        (+)
 5   Add interest expense (Schedule F)                                                            (+)
 6   Add Federal and State income tax refunds received                                            (+)
 7   Deduct Federal and State income tax paid                                                     (-)
 8   Add gross Non-farm income                                                                    (+)
 9   Add or Deduct difference between the beginning and ending principal balances on the annual
     operating loan. Compare to the BEGINNING balance. If unknown, assume - $0.00 -.
       Identify loan
                                    ending principal balance
                       (minus -) beginning principal balance
                   Add if ending principal balance is higher, deduct if less. ( + ) or ( - )                               $0.00
10 Deduct interest payment on annual operating loan.                                    (-)
11 Deduct principal and/or interest payments on all farm & nonfarm term debt loans.
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
12 Add any loan(s) used to pay any of the principal and/or interest term
   debt loan payments shown in # 12 above.                                             (+)
13 Add or Deduct difference between the beginning and ending principal balances on personal
     credit cards. Compare to BEGINNING balance. If unknown, assume - $0.00 -.
                                   ending principal balance
                             (minus -) beginning principal
                  Add if ending principal balance is higher, deduct if less. ( + ) or ( - )                                $0.00
14 Deduct credit card payments                                                        (-)
15 Deduct cash spent for capital expenditures                                         (-)
16 Add or Deduct difference between the beginning and ending checking/savings account
     balances. Compare to BEGINNING balance. If unknown, assume - $0.00 -.
                                  beginning account balance
                            (minus -) ending account balance
                    Add if ending account balance is less, deduct if higher. ( + ) or ( - )                                $0.00
17 Deduct ALL deductions/W-2 withholdings (federal/state taxes, social
   security, insurance, retirement, etc.) from non-farm employment.                   (-)
18 EQUALS FAMILY LIVING EXPENSES                                                                                           $0.00

Cannot use line # 18 family living expense by itself in the FSA-431-2, Cash Flow. In Table F or Table K, you must also add item
#17 nonfarm W-2 withholdings, item #14 credit card payments, and any item #11 nonfarm term debt payments to #18.




                                                                                a7dc80d1-0d86-4468-92f0-23088d50a743.xls
     MO 2-FLP Guide 15                                                                                  Blank FL Reconciliation
     (Rev. 2-8-2002)
                                       Family Living Reconciliation Table
                   [Obtain from Income Tax Records, Credit Report, Bank Accounts, and Loan History Records]
     [Record any and all transactions between the "beginning and ending" date of the tax year.] Do Not enter negative numbers.

 1   Total gross farm income (Schedule F)
 2   Deduct total gross farm expenses (Schedule F)                                                (-)
 3   Add any loan(s) used to refinance Schedule F cash farm expenses                              (+)
 4   Add depreciation expense (Schedule F)                                                        (+)
 5   Add interest expense (Schedule F)                                                            (+)
 6   Add Federal and State income tax refunds received                                            (+)
 7   Deduct Federal and State income tax paid                                                     (-)
 8   Add gross Non-farm income                                                                    (+)
 9   Add or Deduct difference between the beginning and ending principal balances on the annual
     operating loan. Compare to the BEGINNING balance. If unknown, assume - $0.00 -.
       Identify loan
                                    ending principal balance
                       (minus -) beginning principal balance
                   Add if ending principal balance is higher, deduct if less. ( + ) or ( - )
10 Deduct interest payment on annual operating loan.                                    (-)
11 Deduct principal and/or interest payments on all farm & nonfarm term debt loans.
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
    Identify loan                                                                       (-)
12 Add any loan(s) used to pay any of the principal and/or interest term
   debt loan payments shown in # 12 above.                                             (+)
13 Add or Deduct difference between the beginning and ending principal balances on personal
     credit cards. Compare to BEGINNING balance. If unknown, assume - $0.00 -.
                                   ending principal balance
                             (minus -) beginning principal
                  Add if ending principal balance is higher, deduct if less. ( + ) or ( - )
14 Deduct credit card payments                                                        (-)
15 Deduct cash spent for capital expenditures                                         (-)
16 Add or Deduct difference between the beginning and ending checking/savings account
     balances. Compare to BEGINNING balance. If unknown, assume - $0.00 -.
                                  beginning account balance
                            (minus -) ending account balance
                    Add if ending account balance is less, deduct if higher. ( + ) or ( - )
17 Deduct ALL deductions/W-2 withholdings (federal/state taxes, social
   security, insurance, retirement, etc.) from non-farm employment.                   (-)
18 EQUALS FAMILY LIVING EXPENSES

Cannot use line # 18 family living expense by itself in the FSA-431-2, Cash Flow. In Table F or Table K, you must also add item
#17 nonfarm W-2 withholdings, item #14 credit card payments, and any item #11 nonfarm term debt payments to #18.




                                                                                a7dc80d1-0d86-4468-92f0-23088d50a743.xls

								
To top