HughParsonage / grattan

Common quantitative tasks for Australian policy analysts
25 stars 8 forks source link

Presence of other variables in .dots.ATO can cause problems in income_tax #158

Closed HughParsonage closed 5 years ago

HughParsonage commented 5 years ago

Is the calculation of rebate income correct for non-SAPTO years? For example, does Net_rent_amt affect the rebate income in 2003-04? This has significant bearing on the calculation of SAPTO.

> print_transpose_data.table(s0304[Ind == 102682])
                    Ind : 102682
                 Gender :      -
             Birth_year :      1
               Occ_code :      1
         Marital_status :      1
                 Region :     28
        Lodgment_method :      -
         HECS_accum_ind :      -
                PHI_Ind :      1
                 Sw_amt :   4194
           Alow_ben_amt :      -
            Grs_int_amt :   1174
Aust_govt_pnsn_allw_amt :      -
            Frk_Div_amt :      -
           Net_rent_amt :  -6817
         Gross_rent_amt :   5157
     Other_rent_ded_amt :   9191
       Rent_int_ded_amt :      -
       Rent_cap_wks_amt :   2783
          Net_PP_BI_amt :      -
         Net_NPP_BI_amt :      -
        Total_PP_BI_amt :      -
       Total_NPP_BI_amt :      -
        Total_PP_BE_amt :      -
       Total_NPP_BE_amt :      -
             Net_CG_amt :      -
          Tot_CY_CG_amt :      -
          Net_PT_PP_dsn :      -
         Net_PT_NPP_dsn :      -
          Othr_pnsn_amt :  16963
  Other_foreign_inc_amt :  13211
          Other_inc_amt :      -
            Tot_inc_amt :  28725
            WRE_car_amt :      -
           WRE_trvl_amt :      -
        WRE_uniform_amt :      -
           WRE_self_amt :      -
          WRE_other_amt :    635
        Int_Div_ded_amt :     57
               Gift_amt :      -
        Non_emp_spr_amt :      -
   Cost_tax_affairs_amt :    827
          Other_Ded_amt :   4939
            Tot_ded_amt :   6458
        PP_loss_claimed :      -
       NPP_loss_claimed :      -
       Rep_frng_ben_amt :      -
         Med_Exp_TO_amt :      -
         Taxable_Income :  22267
                    tax : 968.66
> print_transpose_data.table(sfa200304[Ind == 102682])
                        Ind :   102682
                     Gender :        -
                  age_range :        1
                   Occ_code :        1
             Partner_status :        1
                     Region :       28
            Lodgment_method :        0
                  Help_debt :        -
                    PHI_Ind :        1
                     Sw_amt :     4194
               Alow_ben_amt :        -
                Grs_int_amt :     1174
    Aust_govt_pnsn_allw_amt :        -
                Frk_Div_amt :        -
               Net_rent_amt :    -6817
             Gross_rent_amt :     5157
         Other_rent_ded_amt :     9191
           Rent_int_ded_amt :        -
           Rent_cap_wks_amt :     2783
              Net_PP_BI_amt :        -
             Net_NPP_BI_amt :        -
            Total_PP_BI_amt :        -
           Total_NPP_BI_amt :        -
            Total_PP_BE_amt :        -
           Total_NPP_BE_amt :        -
                 Net_CG_amt :        -
              Tot_CY_CG_amt :        -
              Net_PT_PP_dsn :        -
             Net_PT_NPP_dsn :        -
              Othr_pnsn_amt :    16963
      Other_foreign_inc_amt :    13211
              Other_inc_amt :        -
                Tot_inc_amt :    28725
                WRE_car_amt :        -
               WRE_trvl_amt :        -
            WRE_uniform_amt :        -
               WRE_self_amt :        -
              WRE_other_amt :      635
            Int_Div_ded_amt :       57
                   Gift_amt :        -
            Non_emp_spr_amt :        -
       Cost_tax_affairs_amt :      827
              Other_Ded_amt :     4939
                Tot_ded_amt :     6458
            PP_loss_claimed :        -
           NPP_loss_claimed :        -
           Rep_frng_ben_amt :        -
             Med_Exp_TO_amt :        -
             Taxable_Income :    22267
                    fy_year :  2003-04
                     WEIGHT :      100
        Taxed_othr_pnsn_amt :        .
      Untaxed_othr_pnsn_amt :        .
                Div_Ded_amt :        .
             Intrst_Ded_amt :        .
               ETP_txbl_amt :        .
          Unfranked_Div_amt :        .
  Dividends_franking_cr_amt :        .
    Net_farm_management_amt :        .
 Asbl_forgn_source_incm_amt :        .
Spouse_adjusted_taxable_inc :        .
  Net_fincl_invstmt_lss_amt :        .
    Rptbl_Empr_spr_cont_amt :        .
            Cr_PAYG_ITI_amt :        .
TFN_amts_wheld_gr_intst_amt :        .
    TFN_amts_wheld_divs_amt :        .
     Hrs_to_prepare_BPI_cnt :        .
            MCS_Emplr_Contr :        .
            MCS_Prsnl_Contr :        .
             MCS_Othr_Contr :        .
           MCS_Ttl_Acnt_Bal :        .
                        tax : 1820.785