1 / 22

Briefing: How to Use Management Reports Part 2 - MSA Date: 22 March 2007

Briefing: How to Use Management Reports Part 2 - MSA Date: 22 March 2007 Time: 0800 - 0850. Objectives. MSA Daily Reports. Select Office Functions Menu Option: CFM Cashier Functions Menu OFM Office Functions Menu MSR Cashier/MSA Reports Menu

kaiya
Download Presentation

Briefing: How to Use Management Reports Part 2 - MSA Date: 22 March 2007

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Briefing: How to Use Management Reports Part 2 - MSA Date: 22 March 2007 Time: 0800 - 0850

  2. Objectives

  3. MSA Daily Reports Select Office Functions Menu Option: CFM Cashier Functions Menu OFM Office Functions Menu MSR Cashier/MSA Reports Menu C7A USCG DD7A Billing Menu MRM Monthly Reports Menu NPM Nightly Processing Menu RSM Reprint Reports Menu IFM Insurance Processing Menu OIB Outpatient Itemized Billing Menu Select MSA System Menu Option: MSR Cashier/MSA Reports Menu

  4. MSA Daily Reports 139 Produce DD139 AAR Active Accounts Receivable Report CCR Cash Collection Detail Report CRA Clinical Records Pending DRG Billing Report FCV Final Cash Collection Voucher IRR Invoice and Receipt NRR Notify Roster PCT Patient Category Billing Table RCC Copying Charges Roster REC DRG Billing Report of Current/Recalculated Charges SDS DRG-Eligible Indicated Same Day Surgery Report STM Consent Statement TWO Accts Subject to Transfer/Write-off VCL Voucher Control Listing WRT Accounts Written-Off

  5. MSA Daily Reports CCR Cash Collection Detail Report Identifies all collections made in the MSA Office by Cashier. The MSA Officer uses this report to balance the collections received by each cashier NRR Notify Roster Identifies changes made by the Patient Admin Dept that may potential affect the billing of the patient. Also identifies potential refunds created by overpayments posted that day. Billers should be required to work this report at least weekly, depending on the size of the MTF

  6. MSA Daily Reports TWO Accts Subject to Transfer/Write-off Identifies accounts that have met the time parameters / requirements set by the MTF WRT Accounts Written-Off Accounts written off by the billers. MSA Officer should review this report to ensure that only authorized write-off are being performed

  7. MSA Monthly Reports CFM Cashier Functions Menu OFM Office Functions Menu MSR Cashier/MSA Reports Menu C7A USCG DD7A Billing Menu MRM Monthly Reports Menu NPM Nightly Processing Menu RSM Reprint Reports Menu IFM Insurance Processing Menu OIB Outpatient Itemized Billing Menu Select MSA System Menu Option: MRM Monthly Reports Menu

  8. Monthly Reports CBR Central Billing/Local Collection MMD Monthly Medical Services Activity Detail Report MMR Monthly Medical Services Activity Report Select Monthly Reports Menu Option: MMR Monthly Medical Services Activity Report

  9. MSA Monthly Reports Monthly Medical Services Activity Report (MMSAR) Reflects the monthly billing and collections activities for each Fiscal Year, identifying the beginning A/R balance, amount of sales, amount written-off or transferred, amount of collections posted, the ending A/R balance, amount deposited to the DOs account, and any amount that has been collected by not deposited This is the accountability report for the Collection Agent / Treasurer. The amounts reflected on this report for the accounts written-off/transferred, collected, and ending A/R must balance with the individual accounts also generated in MSA MMD Monthly Medical Services Activity Detail Report A detailed report of all transactions

  10. MSA Monthly Reports MSA MEDICAL SERVICES ACCOUNTS REPORT MONTHLY MEDICAL SERVICES ACTIVITY FISCAL YEAR 2005 01 Jul 2005 - 31 Jul 2005 BALANCE ACCOUNTS OUTSTANDING FUNDS TOTAL FUNDS SALES ACCT REC CURRENT TRANS/OUT TOT FUNDS BALANCE COLL BUT DEPOSITED CODE PRIOR MONTH MONTH SALES WRT OFF COLLECTED ACCT REC UNDEPOSITED W/DO  OPERATIONS & MAINTENANCE, NAVY (9750130) CC 0.00 558.90 0.00 558.90 0.00 0.00 0.00 FMR 75,018.92 31,233.30 19,553.50 11,871.10 74,827.62 0.00 0.00 FOR -3,975.19 -23,482.28 -39.00 969.74 -28,388.21 0.00 0.00 FRR 139,928.42 14,456.76 985.19 49,457.24 103,942.75 0.00 0.00 MS 0.00 42,563.15 0.00 42,563.15 0.00 0.00 0.00 TPC 0.00 178,540.77 0.00 178,540.77 0.00 0.00 0.00 V1 0.00 10,450.97 0.00 10,450.97 0.00 0.00 0.00 V11 0.00 165,429.69 0.00 165,429.69 0.00 0.00 0.00 V2 0.00 78.27 0.00 78.27 0.00 0.00 0.00 V24 63,531.29 77,958.24 0.00 51,765.80 89,723.73 0.00 0.00 MISCELLANEOUS RECEIPTS (17R3210 )INT 160.35 -15.00 0.00 25.00 120.35 0.00 0.00 GRAND TOTAL 274,663.79 497,772.77 20,499.69 511,710.63 240,226.24 0.00 0.00

  11. MSA Monthly Reports Select MSA system menu option: ofm Office Functions Menu AAS Schedule of Accounts by Age TRP TPC Reimbursement Percentages BCP Balance Check DAR Detail Schedule of Accounts by Age ERS Rate Schedule Enter/Edit FDF Fund Description Edit EXC Outpatient Charge Exclusion Enter/Edit MPF MSA Parameters Definition NMR Notify Messages Review/Clear RDS Rate Detail Summary RSS Rate Schedule Summary SRC Statement of Receivables and Collections VRS View Rate Schedule Detail Select Office Functions Menu Option: DAR Detail Schedule of Accounts by Age

  12. MSA Monthly Reports Select Detail Aging Report Segment(s) for Printing: Current status 1 to 30 days 31 to 60 days 61 to 90 days 91 to 120 days 121 days or greater ALL segments Select by placing “*” next to segment to be selected (“*” generated by “delete” key)

  13. MSA Monthly Reports Detail Schedule of Accounts by Age Reflects ALL outstanding MSA accounts. It is important to ensure that this report is “worked” by the billers At the end of each month the biller(s) should be required to research accounts over 120 days and provide an explanation EX: Patient is making monthly payments on multiple accounts, OHI provided by pay patient now awaiting payment from insurance company, awaiting payment from foreign military patient/embassy

  14. MSA Monthly Reports 139 Produce DD139 AAR Active Accounts Receivable Report CCR Cash Collection Detail Report CRA Clinical Records Pending DRG Billing Report FCV Final Cash Collection Voucher IRR Invoice and Receipt NRR Notify Roster PCT Patient Category Billing Table RCC Copying Charges Roster REC DRG Billing Report of Current/Recalculated Charges SDS DRG-Eligible Indicated Same Day Surgery Report STM Consent Statement TWO Accts Subject to Transfer/Write-off VCL Voucher Control Listing WRT Accounts Written-Off Select Monthly Reports Menu Option: VCL Voucher Control Listing

  15. MSA Monthly Reports VCL Voucher Control Listing Control Number Log Select desired control number series Series: --------- I INVOICE AND RECEIPT V DD1131 D DD139 T TRANSFERRED TO FINANCE C SF1080 S DD7 A DD7A N SF1049 E TRANSFER SUMMARY REPORT Select by placing “*” next to series to be selected ( “*” generated by “delete” key)

  16. MSA Monthly Reports VCL Voucher Control Listing Each report provides a detailed listing of all transactions processed and all vouchers / documents generated during the month Each of these reports should be generated the first working day of the following month and retained for audit purposes

  17. INPATIENT TPC REPORTS CFM Cashier Functions Menu OFM Office Functions Menu MSR Cashier/MSA Reports Menu C7A USCG DD7A Billing Menu MRM Monthly Reports Menu NPM Nightly Processing Menu RSM Reprint Reports Menu IFM Insurance Processing Menu OIB Outpatient Itemized Billing Menu Select MSA System Menu Option: IFM Insurance Processing Menu

  18. INPATIENT TPC REPORTS IAP Insurance Account Processing OPM Output Products Menu QRP TPC Quarterly Output Products Menu IOR Insurance and OHI Report Menu TRI TPC Batch Post Closing of Transferred Accounts XDL Clear Delinquent Letter Print Queue CPQ Clear UB92 Print Queue 25R Identify UB92 for Reprint VAP APV Prior Authorization Menu Select Insurance Processing Menu Option: OPM Output Products Menu

  19. DAILY INPATIENT TPC REPORTS AAR TPC Accounts Receivable Report BIL Form UB92 CRA Clinical Records Pending DRG Billing Report CSD Insurance Claim Summary by Date Range DLP Print Delinquent Letters IOP TPC Negative Balance Report LOG Insurance Payment Log MMR TPC Monthly Activity Report NOT Insurance Notify Roster OFF TPC Writeoff Report PCT Patient Category Billing Table QRS Print Queue/ Preview Roster REC TPC M M S A Reconciliation Report SDS DRG-Eligible Indicated Same Day Surgery Report TRF Outstanding Insurance Transfer List UNK Report of Policies with Unknown Companies URR Insurance Precert/UR Roster WRK TPC Insurance Worksheet

  20. MONTHLY INPATIENT TPC REPORTS AAR TPC Accounts Receivable Report BIL Form UB92 CRA Clinical Records Pending DRG Billing Report CSD Insurance Claim Summary by Date Range DLP Print Delinquent Letters IOP TPC Negative Balance Report LOG Insurance Payment Log MMR TPC Monthly Activity Report NOT Insurance Notify Roster OFF TPC Write-off Report PCT Patient Category Billing Table QRS Print Queue/ Preview Roster REC TPC M M S A Reconciliation Report SDS DRG-Eligible Indicated Same Day Surgery Report TRF Outstanding Insurance Transfer List UNK Report of Policies with Unknown Companies URR Insurance Precert/UR Roster WRK TPC Insurance Worksheet

  21. QUARTERLY INPATIENT TPC REPORTS IAP Insurance Account Processing OPM Output Products Menu QRP TPC Quarterly Output Products Menu IOR Insurance and OHI Report Menu TRI TPC Batch Post Closing of Transferred Accounts XDL Clear Delinquent Letter Print Queue CPQ Clear UB92 Print Queue 25R Identify UB92 for Reprint VAP APV Prior Authorization Menu Select Insurance Processing Menu Option: QRPTPC Quarterly Output Products Menu

  22. QUARTERLY INPATIENT TPC REPORTS DSA DRG Billing Analysis ASCII Format DSL DRG Billing Analysis Report EPR TPC Report of Program Results Detail GSC TPC Aging Schedule Report HAG TPC Aging Schedule Detail Report PRR TPC Report of Program Results SAR TPC Collection Source Analysis TYR TPC Insurance Type Report

More Related