Google Workspace Marketplace
For Google Sheets™. Open an 835 remittance file and get payments, claims, service lines, and adjustments as sheets, with every claim and payment balanced on a certificate sheet.
개발자:
정보 업데이트:2026년 10월 20일
호환 기기:
리뷰 없음
2
개요
An add-on for Google Sheets™ that reads an 835 electronic remittance file into the spreadsheet you have open.

How it works
1. Open Extensions → 835 Remittance Reader → Open an 835 file.
2. Pick one 835 file from your computer.
3. The add-on writes new sheets: payments, claims, service lines, adjustments, provider-level adjustments when the file has them, and a Certificate.

To try it without a file of your own, a made-up sample (no real names or numbers) is at https://mathproven.com/samples/synthetic-835.txt
No account or sign-in is needed to try it: the free plan works as soon as the add-on is installed.

What gets checked
- The file's envelope and segment counts are consistent.
- For every service line and every claim: charge minus adjustments equals the payment.
- For every payment: claim payments minus provider-level adjustments equals the payment total.
- The tables written to the sheets are totalled again and compared with the file.
- Line charges against the claim charge, and patient responsibility against its adjustments, are reported as warnings when they differ.

If any balancing check fails, every sheet written is named and headed UNVERIFIED, and the Certificate sheet shows which claim or payment is off and by how much.

Where your data goes
The file is read and parsed in the add-on's sidebar, in your browser. Everything read from the file, including patient names and claim numbers, is written into the spreadsheet you have open, and Google stores that spreadsheet. Payer and payee IDs and every amount are written too. The tables go from the sidebar to the spreadsheet through Google's script service. Nothing is sent to Mathproven. Whether that spreadsheet is the right place for remittance data is for your organization to decide. The add-on asks only for access to the spreadsheet it is opened in, and has no permission to make outside requests.

What it does not include
Adjustment reason and remark codes are shown as codes; published code description text is not bundled. Group codes and claim status codes carry short labels in our own words.

Plans
Free: 3 runs a day, one file per run, with no account. Paid plans remove the daily limit: paste the add-in key from your Mathproven account page into the sidebar. The key is checked in the sidebar; no sign-in happens inside the add-on. Plans and prices: https://mathproven.com/pricing/

This add-on converts and balances a file. It does not interpret payer decisions.

Google Sheets™ is a trademark of Google LLC.
추가정보
가격유료 기능을 포함한 무료
개발자
지원
개인정보처리방침
서비스 약관
835 Remittance Reader에서 아래에 표시된 권한을 요청합니다. 자세히 알아보기
835 Remittance Reader에서 Google 계정에 액세스해야 함
이렇게 하면 835 Remittance Reader에서 다음 작업을 할 수 있습니다.
애플리케이션 설치 시 사용한 스프레드시트 조회 및 관리
Google 애플리케이션 내 메시지 및 사이드바에 외부 웹 콘텐츠를 표시하고 실행합니다.
기본 Google 계정의 이메일 주소 확인
개인정보(공개로 설정한 개인정보 포함) 보기
리뷰
언어:
정렬 기준:
Google에서는 리뷰나 평점을 확인하지 않습니다. 리뷰에 대해 자세히 알아보기
댓글 없음
검색
검색어 지우기
검색 닫기
Google 앱
기본 메뉴