Jones has asked you to create a monthly Claim Status Summary report.

Dr. Jones has asked you to create a monthly Claim Status Summary report. He wantsyou to include the insurance company number, the patient number and name, theprocedure date, the procedure code and description, the fee, the date the claim wasfiled, the amount of the claim, the amount of reimbursement, and the amountremaining unpaid. He wants you to group the data by insurance company number,with subtotals by company and grand totals for each numeric field. When you designthe report, make sure to include a mock-up report and a report analysis form.