Dashboard
Real-time cash application performance
Total payments
$0.00
0 payment lines
Matched
$0.00
0 invoices cleared
Unmatched / COA
$0.00
0 exceptions
Match rate
—
Run matching to calculate
Status breakdown
No data yet
Import invoices and remittance, then click Run Matching.
How to use
1
Import invoice aging from SAP
Export FBL5N · paste CSV or load sample data
2
Import remittance / payment data
Bank lockbox, email remittance, portal download
3
Click Run Matching
Invoice # → PO # → SO # → Delivery # → Tracking # → Amount
4
Export SAP F-28 posting file
Hand to cash app team · also supports NetSuite, QB, CSV
Invoice data
Open AR aging · columns A–K match SAP FBL5N output exactly
0 rows
| Customer name | Account # | Invoice # | PO # | Sales order # | Doc type | Document # | Amount | Invoice date | Status |
|---|---|---|---|---|---|---|---|---|---|
No invoice data Click Import CSV or Load Sample to get started. | |||||||||
Remittance data
Payment and remittance lines · COA rows auto-detected
0 rows
| Account # | Customer | Amount | PO # ref | Invoice # ref | SO # ref | Method | COA | Notes | Status |
|---|---|---|---|---|---|---|---|---|---|
No remittance data Click Import CSV or Load Sample to get started. | |||||||||
Match engine
Hand this to your SAP cash app team · Invoice # and Document # are the key F-28 posting fields
0 results
| Customer | Account # | Invoice # | PO # | Document # | Open amt | Amt paid | Variance | Status | Method | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
No results yet Import data then click Run Matching. | ||||||||||
Exceptions
COA and unmatched payments requiring manual review before SAP posting
0 exceptions
| ID | Account # | Customer | Amount | Ref | Type | Detail | Suggested action | Decision | Status |
|---|---|---|---|---|---|---|---|---|---|
No exceptions Run matching to detect COA, short pays, and unmatched payments. | |||||||||
Posting export
SAP F-28 reference · Invoice # and Document # required for cash application posting
Export format
Generic CSV
SAP F-28 ref
NetSuite journal
QuickBooks IIF
Dynamics AX
0 rows
| Account # | Customer | Payment date | Invoice # | Document # | Post amount | Short pay | Match method | Approved |
|---|---|---|---|---|---|---|---|---|
No posting data Run matching first, then return here to export. | ||||||||
Settings
Matching rules, tolerances, and allocation behavior
Matching configuration
Dollar tolerance ($)
Max variance to still auto-match
Enable Invoice # match
Primary matching rule
Enable PO # match
Primary SAP method
Enable Sales Order # match
SO reference matching
Enable Delivery # match
Delivery reference matching
Enable Tracking # match
Tracking reference matching
Flag COA rows
Auto-detect Cash on Account
Oldest invoice fallback
When no exact subset found
Default allocation method
When PO has multiple invoices