A hospital practice you work for has switched the clearinghouse the PM software uses for claim submissions and responses.

835 Analytical Assignment
Payer Response Assignment Guidelines


A hospital practice you work for has switched the clearinghouse the PM software uses for claim submissions and responses. Management wants to make sure that patient accounts reflect claim processing appropriately so that auto-posting may be implemented. All blanks should be completed with numerical data. Must submit your response in Excel (XLS, XLSX) format.Purpose: Electronic data is transmitted from healthcare organizations to payers using 837 and 835 file formats to submit claim information and receive payment responses. If you completed the readings and lecture video for this module, you should have an understanding of how communication occurs and how data may sometimes be incomplete. This assignment will allow you to use the analytical skills that are necessary to be successful in healthcare to review received data when received data is missing.Background: Total billed charges increase when labs, radiology, or other tests, imaging, or procedures are performed. These items can be applied to deductible(s) and/or co-insurance. Review the chart below and complete the missing information so that you can have complete data to compare for the EDI 835 file processing review. A base level 3 (99283) charge is $1900.If you do not know how to use Excel, consider the BATC courses. Schedule time to discuss how to do this during my office hours so that you get the help you need to be successful.Learning Intentions:

  • How to analyze payer responses with missing data.
  • Use basic Excel functions to confirm math equations and data.
  • Understand types of charges and relevancy of processing.
  • Confirm accuracy of provided information.
  • Understanding how to read an 835

Success Criteria:Your submission must be in Excel format. Appropriate formulas should be used when warranted. Understanding types of charges, what they mean, and how patient responsibility works will allow you to complete this successfully. Use concepts learned in Week 1 and Week 2 to complete this assignment.Excel:

  • Create a formula that will allow you to confirm totals. (For your understanding and to complete questions regarding patients)
  • Complete Patient 1 missing data (20 points)
  • Complete Patient 2 missing data (20 points)
  • Complete Patient 3 missing data (20 points)
  • Complete Patient 4 missing data (20 points)
  • Complete Patient 5 missing data (20 points)

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Open chat
Hello. Can we help you?