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.
Sahibi:
Listelemenin güncellendiği tarih:20 Ekim 2026
Şununla çalışır:
Yorum yok
2
Genel Bakış
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.
Ek bilgi
FiyatlandırmaÜcretsiz (Ücretli özellikler vardır)
Geliştirici
Destek
Gizlilik politikası
Hizmet şartları
835 Remittance Reader aşağıda gösterilen izinleri ister. Daha fazla bilgi
835 Remittance Reader uygulamasının Google hesabınıza erişmesi gerekir
Bu, 835 Remittance Reader uygulamasının şunları yapmasına olanak tanır:
Bu uygulamanın yüklendiği e-tabloları görüntüleme ve yönetme
Google uygulamaları içindeki istemlerde ve kenar çubuklarında üçüncü taraf web içeriği gösterip çalıştırın
Birincil Google Hesabı e-posta adresinizi görme
Herkese açık olarak sunduklarınız da dahil olmak üzere kişisel bilgilerinizi görme
Yorumlar
Dil:
Sıralama ölçütü:
Google, yorumları ve verilen puanları doğrulamaz. Yorumlar hakkında daha fazla bilgi
Yorum yok
Arama
Aramayı temizle
Aramayı kapat
Google uygulamaları
Ana menü