7 Replies Latest reply: Apr 11, 2016 11:30 AM by Jennifer Gann RSS

    Trying to capture last Date of Service

    Jennifer Gann

      I am very new to Monarch, we have the V9 version.

       

      I am trying to capture the patien info and guarantor info;m which I have done successfully. Where I am running into problems is I also need to capture each Ticket Number (7777 and 33333 in example) and The last date of service along with that tickets total(Total for Ticket:), then the Total charges and payments for that Location (Total for Location:).

       

      Can anyone help me?

      Everything is better lined up in my original file.

       

      This is a sample of what one account would look like:

      Ticket No                Date CPT Code                                Transaction Description                 Charges        Payment        Chg.Adj        Pymt Adj.      Balance

                                                Patient Information                                                                                                     Responsible Party Information

      Name:                             JORDAN, DOE A                                                                                                         JORDAN, DOE A

      Patient Number:                                                   9999

      Address:                      1111 RUMPLE LANE                                                                                                    1111 RUMPLE LANE  

                                             RENOCITY, LL 99999                                                                                                   RENOCITY, LL 99999

      Home Phone:                (999)999-9999                                                                                                                (999)999-9999     

      Work Phone:

      Sex:                                F

      Birth Date:                   99/99/9999                                                                                                                           99/99/9999

      SSN:                            999-99-9999                                                                                                                         999-99-9999

      7777

                          99/99/9999                                   22222EMERGENCY DEPARTMENT           $485.00          $0.00          $0.00          $0.00             $485.00

                                                                            VISIT MODERATE SEVERITY

                          99/99/9999                                   22222RADIOLOGIC EXAM CHEST             $36.00          $0.00          $0.00          $0.00              $36.00

                                                                            2 VIEWS FRONTAL&

                                                                            LATERAL

                          99/99/9999                                        PRIMARY INSURANCE                             $0.00          $0.00          $0.00          $0.00               $0.00

                                                                            PAYMENT EFT

                          99/99/9999                                        Charge Adjustment (CO-                           $0.00          $0.00        $450.64          $0.00            -$450.64

                                                                            Contractual Obligation)

                          99/99/9999                                        PRIMARY INSURANCE                              $0.00         $56.29          $0.00          $0.00             -$56.29

                                                                            PAYMENT EFT

                          99/99/9999                                        Patient payment Check                             $0.00         $14.07          $0.00          $0.00             -$14.07

                                                                            Total for Ticket:                                                  $521.00         $70.36        $450.64          $0.00               $0.00

      33333

                          99/99/9999                                   22222EMERGENCY DEPARTMENT       $485.00          $0.00          $0.00          $0.00             $485.00

                                                                            VISIT MODERATE SEVERITY

                          99/99/9999                                        Charge Adjustment (CO-                        $0.00          $0.00        $427.01          $0.00            -$427.01

                                                                            Contractual Obligation)

                          99/99/9999                                        PRIMARY INSURANCE                          $0.00         $46.39          $0.00          $0.00             -$46.39

                                                                            PAYMENT EFT

                                                                            Total for Ticket:                                             $485.00         $46.39        $427.01          $0.00              $11.60

                                                                            Total for Location:                                     $24281.00       $2935.22      $18891.13          $0.00            $2454.65