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 应用
主菜单