DailyTransactionReportsDetailandSummary.ppt

VIPSDaily Transaction Reports Daily Cash Report – Detail RV903C Daily Fee Transaction Summary RV904C Daily Report for Returned Checks RV924C PrintingCounty Functions Menu #9 Printing (option 1)Daily Cash Detail Summary #4 Printing (option 1)Returned Check Report #17 Printing (option 2)End of Day #9 Daily Cash Report – DetailRV903C Changes Returned Checks (RCZZZZ) / Refunds Paid by County (RFCZZZ) / Registration Credit Calculated into detail of report: Total Fees Collected (reflecting negative amount) Less County Processing Total to State (reflecting negative amount) Sub-Total (reflecting negative amount) Grand-Total Final Total Summary Summary listing to reflect detail of report: (these amounts should be the same on the report) Total Fees Collected = Total Fees Collected Fees Retained by County = Less County Processing Total Fee to Remit to State = Total to State Refunds Paid by County Removed from calculation Listed below Total Fee to Remit to State for reference only Returned Checks Removed from calculation Listed on separate report (RV924C) for reference only Calculation of Summary – Total Fee to Remit to State Total Fees Collected – Fees Retained by County = Total Fee to Remit to State Rows Transactions are listed alphabetically by Trans Type Transactions are listed numerically after listed alphabetically All rows are grouped by Transaction Type and Vehicle Type Rows are then sub-totaled after each Trans Type/Vehicle Type Calculation Total Fees Collected/Total To State Add first 10 columns on row = Total Fee Collected Title Fees Title Penalties Registration Fees Penalties Quarterly Payments Modernization Fee Replacement Plate Reflectorized Plate Decal Lienholder Fee Other County Service Fee Subtract Less County Processing from Total Fees Collected = Total To State County Misc. Column is used to track sales and property tax for each transaction **This is not included in the total fee breakdown at end of Detail Report** Lienholder fee is add