Excel Resource Centre :: Purpose built spreadsheets
 Business Income and Expenses  
  This sheet facilitates the allocation of income and expense transactions. A range of transaction types, freeform descriptions, general ledger codes, GST and private use percentages are catered for. The transactions are summarised by type and description.  
    Features:    
   
  • Produces totals by account type (capital, income, expense)
  • Variable number of transaction headings
  • Variable number of transactions per heading
  • Optional capture of GL account posting code
  • Continuous alphabetical sorting of data entry columns
  • Allows for private use and GST apportionments
  • Transactions can be entered, viewed and summarised on a monthly, quarterly or annual basis
  • One click summarisation of totals for further input as necessary
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