Item Income Report

This selection from the Program Menu produces an Item Income Report.  You will be asked to enter the month and year to report.  The Item Income Report shows income generated by each inventory item for the selected month, selected year, and lifetime.  If your income accounting selected in the program parameters is cash or open accrual basis, the reported income on this report is open accrual and is independent of any monies paid.  In other words, whenever an item is rented or sold on a contract the item income figure is updated at that time.  The one exception to this is reservation contracts, they do not post until the contract is changed from a reservation to an open contract.  If on Closed Accrual income accounting, the report will only reflect revenue when the item is returned. 

Category – this button allows you to select only a certain item category to be reported.

Rental Items – check this box if you want your rental items on the report.

Sale Items – check this box if you want your sales items on the report.

Parts Items – check this box if you want your parts items on the report.

Month – select the desired month to report.

Year – select the desired year to report.

Purchase Price – This option allows you to have the ROI% be based off the purchase price of the item.

Replacement Cost – This option allows you to have the ROI% be based off the replacement cost of the item.

Print Details/Print Summary – this option allows you to print a detailed report or just a summary.  With Print Summary checked, only the totals for each category will be displayed.  With Print Details checked, each item’s information will be displayed.

Sort – the report is sorted by item category.  Within each category, you can choose whether it is sorted by item key, name, or number.  If you have Print Summary checked, then the sort options will not make any difference.

Store to report – for multi-store system you can choose to only report a certain store or all stores.

Select Printer – this button defines the printer that the report will print to.

Cancel – this button will cancel your previous selections and return you to the Program Menu.

Generate – this button will generate the report and display the report on your screen.  To print the report, click on the printer icon at the top of the screen.

The report will look like this sample report:

ROI % - The return-on-investment will be printed as the ratio of income to purchase price.  For example, if the income is $150 and the purchase price is $100 the ROI would be 150%.  If the purchase price is not specified in the item record, the ROI will be shown as “0%”. 

T/O - For rental items, the number of times rented out.  For sales items, the quantity sold.

Income- The income generated for each item.

Repairs- The lifetime repair cost for this item.