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 アプリ
メインメニュー