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.
By:
Listing updated:20 octombrie 2026
Works with:
No reviews
2
Prezentare generală
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.
Additional information
PricingFree of charge with paid features
Developer
Asistență
Politica de confidențialitate
Condiții de furnizare a serviciilor
835 Remittance Reader will ask for the permissions shown below. Learn more
835 Remittance Reader will need access to your Google account
This will allow 835 Remittance Reader to :
să vizualizeze și să gestioneze foile de calcul în care a fost instalată această aplicație
să afișeze și să execute conținut web terță parte în solicitările și barele laterale din aplicațiile Google
să vadă adresa de e-mail principală din Contul Google
să vadă informațiile tale cu caracter personal, inclusiv pe cele pe care le-ai făcut disponibile public
Recenzii
Language:
Sortează după:
Google nu verifică recenziile sau evaluările. Află mai multe despre recenzii
No comments
Căutare
Șterge căutarea
Închide căutarea
Aplicații Google
Meniu principal