What the free workbook tracks
One row represents one fictional or real order record entered by the workbook owner. Keep a private backup and use codes instead of contact details wherever possible.
- Order IDA unique reference used to catch blanks and duplicates.
- Due DateThe date used for the overdue check.
- Customer CodeA local code rather than a customer name or contact detail.
- Order AmountThe order value entered by the workbook owner.
- Paid AmountThe amount manually confirmed from an authorized source.
- Collection StatusPaid, Pending, or Cancelled as assigned by the workbook owner.
- Outstanding AmountA formula result based on valid order and paid amounts.
- Data CheckA row-level warning when a required value or rule fails.
- Overdue StatusA formula result for valid pending rows past their due date.
Free 100 rows vs paid 500 rows
This is a scope comparison, not a promise of results. Both files depend on correct source rows and manual review.
| Decision area | Lite · free | Standard · US$29 |
|---|---|---|
| Order-row capacity | 100 rows | 500 rows |
| Primary KPIs | 5 | Expanded dashboard and summary views |
| Monthly summary | Not included | Included |
| Charts | Not included | Included |
| Item and channel analysis | Not included | Included |
| Example data | 12 fictional rows | 120 fictional rows |
| Buyer documentation | Quick start, free-sample license, checksums | Quick start, field guide, license, support, refund terms, changelog, manifest |
| License | Free sample; review the included license before sharing | Standard: one named person or one internal organization |
Inspect three fictional rows before downloading
The values below demonstrate the field logic only. They are not customer, transaction, collection, or revenue records.
| Order ID | Customer code | Order | Paid | Status | Data check | Overdue |
|---|---|---|---|---|---|---|
| DEMO-001 | FICT-101 | US$240 | US$240 | Paid | Valid | Not overdue |
| DEMO-002 | FICT-102 | US$480 | US$120 | Pending | Valid | Overdue |
| DEMO-002 | FICT-103 | US$300 | US$0 | Pending | Duplicate Order ID | Review data |
Payment-Risk-Check-Lite-v1.0.0.zip · SHA-256 32ec51d62675d087b5b557342b84b3706fdac4a173dbdc1673b99f198aa1aff5
Boundaries to check before using either workbook
- Microsoft Excel XLSX is the primary verified environment.
- Google Sheets import is not guaranteed; recheck formulas, dates, validation, conditional formatting, and layout.
- The workbooks do not issue invoices, collect money, connect to banks, reconcile transactions, or maintain formal accounting records.
- No multi-user permissions, audit trail, platform API, inventory, tax, or legal workflow is included.
- A formula result cannot prove that an entered payment status or source amount is true.
Frequently asked questions
Does the workbook upload my spreadsheet?
No. The downloaded XLSX runs locally in your spreadsheet application. It does not ask for an account, connect to a bank, or upload your workbook to this site.
Can it issue invoices or reconcile a bank account?
No. It does not issue invoices, collect payments, connect to a bank, match transactions, maintain formal books, or provide accounting records.
When should I use the paid version?
Choose the paid Standard version when the 100-row limit or five Lite KPIs are not enough and you specifically need the listed 500-row monthly, chart, item, and channel analysis. Review every boundary before paying.