Summary Recap

The Summary Recap report is a summary of all the income and inventory activity for your store. This is an excellent report to use to compare one store to another, by seeing only a summary of the activity and a comparison to last month all on one report it is

There is "Today's" information listed on this report that is as of the open day in the system. Keep this in mind when processing this report.

Report Parameters - SUMMARY RECAP The report parameters screen allows you to specify which data you want to see on the report.
Ending Date	Enter the last day of the month for which you wish to print the recap, or the last closed day for which to print the recap through. A drop-down box reveals a calendar where you can select the appropriate date, or input the date manually using the MM/DD/YYYY format.
	When the information on the parameter screen is correct, choose the output method from the Report Toolbar at the bottom of the screen.

Report Parameters - SUMMARY RECAP

The report parameters screen allows you to specify which data you want to see on the report.

Ending Date

Enter the last day of the month for which you wish to print the recap, or the last closed day for which to print the recap through. A drop-down box reveals a calendar where you can select the appropriate date, or input the date manually using the MM/DD/YYYY format.

When the information on the parameter screen is correct, choose the output method from the Report Toolbar at the bottom of the screen.

This report can be generated using a Performance Calendar view.

Click here to learn more about Performance Reporting.

Roll over icons to view definition of each.

Only income and inventory transactions within the date range you selected are displayed on the report.

REPORT DETAIL FIELDS - SUMMARY RECAP - INCOME INFORMATION p. 1 The income and expense fields are listed and calculated for each period.
Run for MM/DD/YYYY	The ending date you selected is displayed at the beginning of this report. The periods being reported are defined as well. WTD = Week-to-Date MTD = Month-to-Date YTD = Year-to-Date MTDLY = Month-to-Date Last Year
Income/Expense	This column contains the income or expense description tracked by The RAM System Corporate Edition.
Today	This column contains the dollar amount for each income or expense for the open day. This information is based on the open day and not the date you are running the report.
Week to Date	This column contains the total dollar amount for each income or expense for the week to date period.
Month to Date	This column contains the total dollar amount for each income or expense for the month to date period.
% Change	This column contains the percentage of change between the month-to-date figure and the month-to-date a year ago.
MTD 1Yr Ago	This column contains the total dollar amount for each income or expense for the month-to-date period last year.
Year to Date	This column contains the total dollar amount for each income or expense for the year to date period.
RENT	This row contains the income calculations in each column for rental income.
EPO Revenue	This row contains the income calculations in each column for the early payout option income. This is money collected during an early payout option and is tracked separately from cash sales.
LATE FEES	This row contains the income calculations in each column for late fees.
CUSTOMER CHARGES	The next (8) eight rows contain the income calculations in each column for each of the eight customer charges you defined in Company Setup.
WAIVER FEES	This row contains the income calculations in each column for waiver fees.
Membership Fees	This row contains the income calculations in each column for club membership fees collected.
Member Process Fees	This row contains the income calculations in each column for club membership processing fees collected.
Total Rental Revenue	This row contains the total of the above income calculations. (Rent, waiver, late, customers charges and club fees.)
Cash Sales	This row contains the income calculations in each column for the items sold as cash sale.
Miscellaneous Income	This row contains the income calculations in each column for transactions processed as income type under the Misc. Income/Expense option.
Gross Income	This row contains the total income calculations in each column. The above income categories are added to arrive at this total for gross income.
Bad Check Fees	This row contains the income calculations in each column for the bad check fees that were collected.
Miscellaneous Expenses (-)	This row contains the expense calculations in each column for transactions processed as expenses in the Misc. Income/Expense option.
Customer Deposits	This row contains the income calculations in each column for the Customer Deposits paid by customers through the Payment Screen or the Customer Deposit option(s).
Customer Deposits Applied	This row contains the expense calculations in each column for the Customer Deposit money used by customers through the Payment Screen or the Customer Deposit option(s).
Prepayments	This row contains the income calculations in each column for the Prepayments paid by customers through the Payment Screen or the Prepayment option(s).
Prepayments Applied	This row contains the expense calculations in each column for the Prepayments used by customers through the Payment Screen or the Prepayment option(s).
Adjusted Income	This row contains the difference between Gross Income and the above expense categories to arrive at the adjusted amount of income for each column.
Bad Checks Paid	This row contains the income calculations in each column for the bad checks that were paid. These checks are not included in the adjusted income as the income from these bad checks was realized on a previous transaction.
SALES TAXES	This row contains the income calculations in each column for sales tax.
Monies Collected	This row contains the income calculations in each column. The Sales Taxes are added to the Adjusted Income to arrive at this figure.
Less Remote Payments	This row contains the expense calculations in each column for the remote payments taken at this store but credited to another store's income.
Deposit Amount	This row contains for each column the input deposit amount for each period.
Credit Cards	This row contains the credit card amounts collected for each period.
Cash Over/Short	This row contains for each column the amount over or short of the total calculated income the deposit was for each period.

REPORT DETAIL FIELDS - SUMMARY RECAP - BOR/APU INFORMATION - p. 2 The inventory activity is listed for each of the (3) three groups, Items, Agreements, and Customers.
WEEK TO DATE	These (3) three columns contain the inventory calculations for the week-to-date period.
MONTH TO DATE	These (3) three columns contain the inventory calculations for the month-to-date period.
YEAR TO DATE	These (3) three columns contain the inventory calculations for the year-to-date period.
Begin BOR	This row contains the beginning BOR (or on rent) number for each column.
Rented	This row contains the number for each column that was rented for each period.
Turn-Ins	This row contains the number for each column that was terminated (or turned in) for each period.
Reinstates	This row contains the number for each column that was reinstated for each period.
Paid Out	This row contains the number for each column that was paid out for each period.
Skips/Stolen	This row contains the number for each column that was a skip/stolen for each period. An item/agreement/customer is considered skip/stolen if the termination date and disposal date is the same date. If you check the Dispose of Item checkbox during the termination process, or subsequently dispose of the item on the same day, it is counted here. (This number excludes payouts.)
End BOR	This row contains the ending BOR (or on rent) number for each column, by adding and subtracting the activity to arrive at this ending number for each period.
APU	This row contains the average potential per unit calculation for each column, the average default monthly rental rate for all active items, active items with both flags in the Inventory file APU and BOR set to "Y".
ARU	This row contains the actual revenue per unit, the total rental revenue (divided by ) the average BOR for each column.
NON APU	This row contains the total NON-APU active items, agreements or customers for each period.
NON BOR	This row contains the total NON-BOR active items, agreements or customers for each period.
INVENTORY INFORMATION The inventory breakdown count and cost figures are listed in this section.
Month to Date	These (2) two columns contain the inventory activity calculations for the month-to-date period.
Year to Date	These (2) two columns contain the inventory activity calculations for the year-to-date period.
Beginning Inventory	This row contains the beginning idle inventory calculations for each column.
Items Purchased	This row contains the calculations for items purchases for each column.
Items Transferred In	This row contains the calculations for items transferred in for each column.
Items Transferred Out	This row contains the calculations for items transferred out for each column.
Items Written Off	This row contains the calculations for items disposed of that were not paid out for each column.
Items Recovered	This row contains the calculations for items recovered for each column. An item is counted as a recovered item if it was disposed in a different month than it was recovered.
Items Paid Out	This row contains the calculations for items paid out for each column.
Items Sold	This row contains the calculations for items sold for each column.
Ending Inventory	This row contains the ending inventory calculation by adding and subtracting the activity to arrive at this ending inventory number for each period.

Note: Current Information is based on the date the Summary Recap report is printed, and NOT the Run As Of date.

REPORT DETAIL FIELDS - SUMMARY RECAP - CURRENT INFORMATION - p. 3
ITEMS	This column contains the number of items for each category listed.
COST/TOTAL	This column contains the dollar amount representing the cost of the inventory items for each category listed.
AVERAGE	This column contains the average calculations for each applicable category listed.
PERCENT	This column contains the percentage calculations for each applicable category listed.
PREVIOUS EOM	These (2) two columns (items and cost) contain the previous end of month figures for each category listed.
MTD +/-	This column contains the change positive or negative for each of the categories listed, for the month-to-date period.
YTD +/-	This column contains the change positive or negative for each of the categories listed, for the year-to-date period.
Active Items	This row contains the calculations for all active inventory.
Outstanding Balance	This row contains the calculations for the remaining balances for rented items.
Customer Deposit Balance	This row contains the calculations for the customer deposits received and applied. This is the net balance for those accounts.
PrePayments Balance	This row contains the calculations for the customer prepayments received and applied. This is the net balance for those accounts.
Idle Items/Available	This row contains the calculations for the total (new and used) idle or available inventory items.
New Items Available	This row contains the calculations for the NEW inventory items.
Used Items Available	This row contains the calculations for the pre-leased or USED inventory items that are currently idle.
Idle Items - Unavailable	This row contains the calculations for the idle inventory items that are tagged as unavailable.
Items On Loan	This row contains the calculations for the inventory which is loaned to customers.
Ultimate Dollars	This section contains the calculations for the potential monthly income.
This Month	This section contains the total monthly rental rate for all active items. (This field adds the monthly rental rate for all active items, whether they are rented monthly or not to arrive at the ultimate dollars for this month.)
Ultimate Late $	This section contains the total monthly rental rate for all late items. (This field adds the monthly rental for late items, late as of the date of this report, regardless of whether the items are rented monthly or not.)
STATUS BREAKDOWN
Count	This column contains the number of inventory items in each status listed.
Status	This column contains the status code. If a status is not assigned to any inventory item it is not displayed on this report.
Description	This column contains the status code description associated with each status code listed.
Type	This column contains the status type associated with each status code listed.
THIS MONTH'S WRITE OFF BREAKDOWN
Count	This column contains the number of inventory items in each status listed.
Status	This column contains the status code. If a status is not assigned to a disposed inventory item within the month it is not displayed.
Description	This column contains the status code description associated with each status code listed.
Cost	This column contains the cost of the items written off (or disposed) in each status code listed.
RBV	This column contains the remaining book value of the items written off (or disposed) in each status code listed.

REPORT DETAIL FIELDS - SUMMARY RECAP - EXPIRED ACCOUNT INFORMATION p. 4 Each late range you have assigned in Company Setup is listed with the expired account calculations for each column along with the total expired account information for all late ranges.
Items	This column contains the expired information for inventory items.
Agreements	This column contains the expired information for agreements.
Customers	This column contains the expired information for customers.
Count	This column contains the number of expired items, agreements or customers.
Percent	This column contains the percentage of the total number of each group which is late.
SUMMARY TYPE BREAKDOWN The breakdown of the rental types you have added in the Rental Type file, that are being tracked in the Summary Type file.
BOR	This section counts the number of Items, Agreements and Customers for each rental type that are counted in BOR.
NON-BOR	This section counts the number of Items, Agreements and Customers for each rental type that are not counted in BOR.

Some frequently asked questions: (click each question for answer)

•	When I calculate my APU it doesn't match the Summary Recap report?

The Summary Recap report uses the records and calculations made every day during the daily close to arrive at the summary numbers for this report. The week-to-date numbers use the summary records for each day closed during the week-to-date period to arrive at an average APU number for this report.

Although, the APU calculation shows $37.39, the week-to-date calculation is slightly higher on this example. Each day the APU may be slightly different depending on the total monthly rental rate and the number of items rented on that day. These daily APU calculations are added and divided by the number of days in this week-to-date period to arrive at the average APU calculation listed on this report.