CSV or XLSX exports · explicit mapping · review only

Pay application and retainage review

For subcontractors and their bookkeepers: check the current pay application's schedule of values (continuation sheet) against the prior period. Line arithmetic, percent, balance to finish, retainage at the rate you state, certificate totals from the figures you enter, "from previous" against the prior export, scheduled values or descriptions changed without a change order, lines added or removed, retainage that went down, billing over 100 percent, and prior certificates matched to bank receipts, each cited to its source rows. One workbook and JSON ZIP use one existing file unlock or credit; the free PDF allowance does not apply.

A review aid for your own records: not a certified payment application, lien waiver, legal or accounting advice. Nothing is filed, sent, signed or posted. Upload exports as UTF-8 comma CSV or .xlsx, 4 MB and 2,000 lines per schedule (5,000 receipt rows). PDF pay applications are not read: export the schedule of values instead. Lines match on the exact line id you map; ids that differ only by case, separators or leading zeros are listed, never matched. A row without a line id that carries a number (a subtotal) keeps every total from being computed: remove subtotals or give each line an id. Retainage rates are never assumed. Blank money cells read as zero only if you say so. Receipts match by amount (your tolerance, default exact) and date window; partial or combined payments are listed, not split. Exact decimal arithmetic; anything the files cannot settle is an exception, never a result.

Upload only files you may process. Originals are discarded; results expire after 1 hour. Keep your own copies.

1. Inspect your exports