Excel Resource Centre :: Purpose built spreadsheets
 Prepayments Calculator  
  This sheet records transactions that are incurred in one year but for which a tax deduction is only partly allowed in that year with the balance of the deduction claimable in future periods. An ongoing record of annual claims and the unexpired balance is maintained.  
    Features:    
   
  • Allows recording of expense description, payee, date, cost and term of claim
  • Calculates annual claim
  • Maintains ongoing record of the unexpired balance
  • Manages claim periods up to five years
  • Variable number of columns
  • First and final year claims are calculated on relevant days in the year
Click to view SpeedSheet
 
  Click to view a list of all SpeedSheets  
Home SpeedSheets Templates...
 » About SpeedSheets
 » Recent Updates
 » Accountants
 » Businesses
 » Financial Planners
 » Individuals
 » Investors
 » All SpeedSheets
 » Planned SpeedSheets
Free Spreadsheets Trial Purchase Excel Worksheets...
 » Price List
 » How to Purchase
Support...
 » Recent Updates
 » FAQ
 » Comments/Questions
 » Downloads
 » Resources
Contact Us...
 » Comments/Questions
 » Contact Details