Audit Reports on Sales by kwb16500

VIEWS: 44 PAGES: 14

More Info
									Audit Reports




OfficeMate suggests that you print the following audit reports on a daily or monthly
basis to help you effectively manage your practice’s finances:
•      Accounts Receivable Variance, 2
•      Adjustment Register, 2
•      Applied Payment Register by Date, 3
•      Daily Production Summary, 4
•      Day Sheet Details, 5
•      Deposit Ticket, 7
•      Discount Register, 7
•      Fee Slip Detail, 8
•      Insurance Aging by Patient Detail, 9
•      Monthly Production Summary, 10
•      Patient Aging - Detail, 12
•      Production, 13
•      Returns And Refunds, 14
•      Unapplied Amounts, 14

    Note     To view a complete list of all of the financial and other reports that you
             can print from OfficeMate, see chapter 14 in the OfficeMate User’s Guide.




                     Audit Reports                                                        1
    Audit Reports



                    Accounts Receivable Variance
                    The Accounts Receivable Variance report lists backdated payments and adjustments
                    by a given date range. This information is needed to reconcile aging reports from
                    month to month. OfficeMate suggests creating this report on a monthly basis.
                         To create the Accounts Receivable Variance report, set the date parameters.




                    Adjustment Register
                    The Adjustment Register report lists adjustments to transactions in ascending date
                    order and includes fee slip numbers, patient names, adjustment dates, amounts,
                    recorded by names, adjustment types, and adjustment reasons. OfficeMate suggests
                    creating this report on a weekly basis.
                         To create the Adjustment Register report, set the date parameters and then select
                         a sort order type from the Type drop-down menu.




2                                      Audit Reports
Audit Reports



                Applied Payment Register by Date
                The Applied Payment Register by Date report lists money received by each provider
                or combined providers and the dates money was received. This report includes the
                total amount received for each service or product for the selected period. It also lists
                the total revenue percentage for the period and year-to-date totals. OfficeMate
                suggests creating this report on a monthly basis.
                     To create the Applied Payment Register by Date report, set the date parameters.




                                   Audit Reports                                                       3
    Audit Reports



                    Daily Production Summary
                    The Daily Production Summary lists a daily production summary organized by
                    production category, discounts and adjustments, and collections and refunds. This
                    report also includes today's fees and percentage total and month-to-date fees and
                    percentage total. OfficeMate suggests creating this report on a daily basis.
                         To create the Daily Production Summary report, set the date parameters, select
                         the By Provider check box if you want to sort the report by providers, and
                         select a provider from the Provider drop-down menu.




                     Notes     • The Gross Fees Invoiced amount matches the Fee Slip Detail and
                                 Production reports.
                               • The Adjustments amount matches the Adjustment Register and
                                 Production reports and the Day Sheet report’s Total Adjustments
                                 amount.
                               • The Discount amount matches the Discount Register report.
                               • The Returns amount matches the Product Return column on the
                                 Returns and Refunds report and the Sales Tax on Return amount
                                 minus the Discount on Return amount on the Daily Production
                                 report.
                               • The Sales Tax amount matches the Fee Slip Detail and Production
                                 reports.
                               • The Sales Tax on Return amount is also available on the Production
                                 report.
                               • The Net Fees Invoiced amount matches the Production Summary
                                 and Fee Slip Detail reports.
                               • The Deposits amount matches the Day Sheet, Deposit Ticket, and
                                 Production reports.
                               • The Refunds amount matches the Returns and Refunds and
                                 Production reports.


4                                      Audit Reports
Audit Reports



                Day Sheet Details
                The Day Sheet Details report lists each patient or insurance transaction made on the
                selected posting date. Use this report to view money collected, fee slip charges made
                to patients and insurance, returns, refunds, and adjustments. This report is based on
                providers on fee slip line items. OfficeMate suggests creating this report on a daily
                basis.
                     To create the Day Sheet Details report, set the date parameters, select the By
                     Provider check box if you want to sort the report by providers, and select a
                     provider from the Provider drop-down menu. Also, choose the appropriate
                     Insurance Co / Patient Name sort order.




                                   Audit Reports                                                      5
    Audit Reports




                    Notes   • The Applied Receipts column lists the deposit amounts during the
                              day. This column matches the Deposit Ticket, Product, and Daily
                              Production Summary reports.
                            • The Insurance Charge column lists fee slip charge amounts that were
                              incurred by insurance companies.
                            • The Patient Charge column lists fee slip charge amounts that were
                              incurred by patients.
                            • The Applied Insurance Payment column lists insurance check
                              amounts that were applied to fee slips.
                            • The Applied Patient Payment column lists patient payment amounts
                              that were applied to fee slips.
                            • The Insur. Adjust. column lists insurance adjustment amounts
                              including product returns.
                            • The Patient Return & Adjust. column lists patient adjustment
                              amounts including product returns.
                            • The Patient Refund column lists amounts that were refunded to
                              patients.
                            • The Total Charges amount matches the Fee Slip Detail report.
                            • The Total Applied Ins. & Pat. Payments amount matches the Applied
                              Payment report.
                            • The Total Patient Returns amount matches the Returns And Refunds
                              report’s Product Return total.
                            • The Total Adjustments amount matches the Adjustment Register and
                              Daily Production Summary reports.




6                                  Audit Reports
Audit Reports



                Deposit Ticket
                The Deposit Ticket report lists all deposits made on a particular day. This report
                includes payments made by cash, check, or other methods and lists them by patient or
                insurance company name. OfficeMate suggests creating this report on a daily basis.
                     To create the Deposit Ticket report, set the date parameters.




                 Notes      • The Total Deposit amount matches the Daily Production and
                              Production reports.
                            • The Total Credit Card Refunds amount matches the Credit Card
                              Return amount on the Day Sheet report.


                Discount Register
                The Discount Register report lists fee slip numbers, patient names, transaction dates,
                fee totals, discount amounts, who recorded the transactions, and the type of discount
                that was recorded. OfficeMate suggests creating this report on a weekly basis.
                     To create the Discount Register report, set the date parameters and select a sort
                     order type from the Type drop-down menu.




                 Note       The Total Discounts amount matches the Daily Production Summary
                            and Fee Slip Detail reports.



                                   Audit Reports                                                     7
    Audit Reports



                    Fee Slip Detail
                    The Fee Slip Detail report lists fee slips, patients, products, posting dates, fees,
                    discounts, sales tax, totals, and recorded by names. OfficeMate suggests creating this
                    report on a weekly basis.
                         To create the Fee Slip Detail report, set the posting date parameters and select a
                         sort order type from the Type drop-down menu.




                     Notes      • The Gross Fees Invoiced column matches the Production and Daily
                                  Production Summary reports. This column does not include discounts
                                  or sales tax.
                                • The Discount column matches the Discount Register report and the
                                  discount amount on the Daily Production Summary report.
                                • The Sales Tax column matches the sales tax amount on the Daily
                                  Production Summary and Production reports.
                                • The Total Charges column matches the total charges amount on the
                                  Day Sheet report.




8                                       Audit Reports
Audit Reports



                Insurance Aging by Patient Detail
                The Insurance Aging by Patient Detail report lists patient insurance balances. This
                report is organized by insurance company or patient name. OfficeMate suggests
                creating this report on a monthly basis.
                     To create the Insurance Aging by Patient Detail report, set the period end date
                     parameter, select an insurance carrier from the Insurance Co. drop-down
                     menu, and select the Provider check box if you want to sort the report by
                     providers.




                                   Audit Reports                                                      9
 Audit Reports



                 Monthly Production Summary
                 The Monthly Production Summary report lists each item sold with the total quantity,
                 amount, and percentage of total revenue for the period. This report includes
                 year-to-date totals and totals for discounts, adjustments, returns, taxes collected and
                 returned, and deposits. OfficeMate suggests creating this report on a monthly basis.
                      To create the Monthly Production Summary report, set the date parameters,
                      select a production type from the Type drop-down menu, select a group from
                      the Group drop-down menu, and select the By Provider check box if you want
                      to sort the report by providers.




10                                    Audit Reports
Audit Reports




                Note   The Net Change to A/R amounts can be used to balance your account
                       receivables.




                             Audit Reports                                             11
 Audit Reports



                 Patient Aging - Detail
                 The Patient Aging - Detail report lists all patients with an outstanding balance aged
                 30, 60, 90, and 120 days. This report includes patient names, guarantor names, home
                 phone numbers, amounts owed, providers, and aged percentages outstanding.
                 OfficeMate suggests creating this report on a monthly basis.
                      To create the Patient Aging - Detail report, set the period end date parameters,
                      select a provider from the Provider drop-down menu, and choose appropriate
                      Gender Name and Patient Name sort order options.




12                                    Audit Reports
Audit Reports



                Production
                The Production report lists each item sold with the total quantity, amount, and
                percentage of total revenue for the period. This report includes year-to-date totals and
                totals for discounts, adjustments, returns, taxes collected and returned, and deposits.
                OfficeMate suggests creating this report on demand.
                     To create the Production report, set the date parameters, select a provider from
                     the Provider drop-down menu, select a sort order type from the Type
                     drop-down menu, and select a group from the Group drop-down menu.




                 Notes      • The Gross Fee Invoiced amount matches the Daily Production and
                              Fee Slip Detail reports.
                            • The Total Discounts, Adjustments & Returns amount matches the
                              Daily Production Summary.
                            • The Sales Tax amount matches the Daily Production Summary and
                              Fee Slip Detail reports.
                            • The Sales Tax on Return amount matches the Daily Production
                              Summary.
                            • The Net Fees Invoiced amount matches the Daily Production
                              Summary and Fee Slip Detail reports.
                            • The Deposits amount matches the Day Sheet, Deposit Ticket, and
                              Daily Production Summary reports.
                            • The Refunds amount matches the Returns and Refunds report.


                                   Audit Reports                                                     13
 Audit Reports



                 Returns And Refunds
                 The Returns And Refunds report lists all returns and refunds by product type, fee slip
                 date, or provider. OfficeMate suggests creating this report on demand.
                      To create the Returns And Refunds report, set the return date parameters, select
                      the By Provider check box if you want to sort the report by providers, select a
                      provider from the Provider drop-down menu, and select a product type from
                      the Product Type drop-down menu.




                  Notes      • The Product Return column total matches the Total Patient Return
                               amount on the Day Sheet report and the Returns amount on the Fee
                               Slip Detail report.
                             • The Refund Total amount matches the Refund Total amount on the
                               Daily Production Summary and Production reports.


                 Unapplied Amounts
                 The Unapplied Amounts report lists patients and insurance companies that have an
                 unapplied credit amount on their account. OfficeMate suggests creating this report on
                 demand.




14                                    Audit Reports

								
To top