The bank's file against the books.
At the end of each day the payment provider sends a settlement file: every capture and refund it settled, with its fee. The matcher pairs each line with the ledger by reference. Whatever doesn't pair is a break, and a person looks at it. In the demo a day is compressed to a few minutes.
Settled days
- 21 Oct, 21:50133 lines2 breaks
- 21 Oct, 21:40111 lines1 break
- 21 Oct, 21:30137 lines4 breaks
- 21 Oct, 21:20135 lines1 break
- 21 Oct, 21:10130 lines2 breaks
- 21 Oct, 21:00119 lines2 breaks
- 21 Oct, 20:50114 lines5 breaks
- 21 Oct, 20:40121 lines4 breaks
- 21 Oct, 20:30122 lines7 breaks
- 21 Oct, 20:20124 lines2 breaks
- 21 Oct, 20:10136 lines1 break
- 21 Oct, 20:00117 linesclean
- 21 Oct, 19:50116 lines3 breaks
- 21 Oct, 19:40116 lines3 breaks
21 Oct, 20:40
Gross
€2,879.00
PSP fee
€45.07
Net to the bank
€2,833.93
Settlement journal
#129704
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a16035-e8b5-7a68-ae34-162af7e8e675 is already settled by stl_EUR_2987692 line 72
- duplicate linethe file lists it twicerefund:01a16039-88fa-793b-a9c1-34ee8a7fb8a0 is already settled by stl_EUR_2987692 line 110
- fee differencethe fee is not the contract feethe fee is 2, the contract says 0
- missing linein the books, not in the filecapture:01a16033-cf71-744a-ae48-d14dc2dc0475 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 39 | refund | 01a16033-d16a-7aae-a060-bfc8ff6d41bf | -€2.00 | €0.02 | fee difference |
| 73 | capture | 01a16035-e988-7475-91ad-225a2e8f7a2c | €24.00 | €0.37 | duplicate line |
| 111 | refund | 01a16039-88fd-796b-aabc-0ac9a2c2b2b1 | -€7.00 | €0.00 | duplicate line |
| 1 | capture | 01a16028-dfc8-7ab4-8979-ef1b340dc306 | €49.00 | €0.67 | matched |
| 2 | capture | 01a16031-565c-7959-8e18-9b390850ba6e | €49.00 | €0.67 | matched |
| 3 | capture | 01a16031-6484-79ea-bfb8-c82f17323dcb | €35.00 | €0.50 | matched |
| 4 | capture | 01a16031-69e0-7951-af56-85e3b14aad54 | €35.00 | €0.50 | matched |
| 5 | capture | 01a16031-785f-74ec-98ce-0da461820c03 | €35.00 | €0.50 | matched |
| 6 | capture | 01a16031-b3ca-7174-a6e6-882d77e9e9ff | €24.00 | €0.37 | matched |
| 7 | capture | 01a16031-b633-7f6f-95d0-a2371b4a4ff9 | €35.00 | €0.50 | matched |
| 8 | capture | 01a16031-bfdf-7a8f-a4a0-50e99934e997 | €35.00 | €0.50 | matched |
| 9 | refund | 01a16032-0b72-762b-8918-2991ce732450 | -€22.00 | €0.00 | matched |
| 10 | capture | 01a16032-23d2-7feb-9eee-c4ce96c33af6 | €9.00 | €0.19 | matched |
| 11 | capture | 01a16032-2ecd-7ed6-95c5-72768bbb03c3 | €49.00 | €0.67 | matched |
| 12 | refund | 01a16032-3608-724b-99aa-dd8f86e127b7 | -€9.00 | €0.00 | matched |
| 13 | capture | 01a16032-5d2e-7a8b-9869-a704f99bde54 | €15.00 | €0.26 | matched |
| 14 | capture | 01a16032-60df-7d23-89b9-7e55635c08c8 | €24.00 | €0.37 | matched |
| 15 | capture | 01a16032-62b3-7c6f-a917-5358826974e9 | €9.00 | €0.19 | matched |
| 16 | capture | 01a16032-6333-7df9-8f49-d82a7d126ca4 | €35.00 | €0.50 | matched |
| 17 | capture | 01a16032-685b-7717-b102-21cb3e9d9db1 | €35.00 | €0.50 | matched |
| 18 | capture | 01a16032-842c-73a9-807a-5565ca5ee946 | €49.00 | €0.67 | matched |
| 19 | capture | 01a16032-8b63-7d6b-af78-075e9ffa16a2 | €49.00 | €0.67 | matched |
| 20 | capture | 01a16032-a76d-7e6e-8618-9acdb360faf0 | €9.00 | €0.19 | matched |
| 21 | capture | 01a16032-b19a-718c-851b-d7ebb09cdae6 | €35.00 | €0.50 | matched |
| 22 | refund | 01a16032-c077-743e-bab1-8787ab811c74 | -€9.00 | €0.00 | matched |
| 23 | capture | 01a16032-d923-79b5-a5ac-c840c6d223ca | €35.00 | €0.50 | matched |
| 24 | capture | 01a16033-0251-70bf-a1c3-f40a0dacd8d5 | €49.00 | €0.67 | matched |
| 25 | capture | 01a16033-08a4-7164-ab61-e04866447b53 | €35.00 | €0.50 | matched |
| 26 | capture | 01a16033-0c68-7550-970b-dffe49cb80a1 | €9.00 | €0.19 | matched |
| 27 | capture | 01a16033-1103-725b-92ff-bc804bb23ffa | €24.00 | €0.37 | matched |
| 28 | refund | 01a16033-1b10-761a-9a53-830f3ab8c0e4 | -€19.00 | €0.00 | matched |
| 29 | capture | 01a16033-1db3-707c-b20a-915ed993efb7 | €49.00 | €0.67 | matched |
| 30 | capture | 01a16033-1e23-702d-95fc-d60c9f41b694 | €49.00 | €0.67 | matched |
| 31 | capture | 01a16033-2755-7870-868d-8ddc7f615e33 | €9.00 | €0.19 | matched |
| 32 | capture | 01a16033-5cf9-79da-9366-b8bc0bf2b779 | €15.00 | €0.26 | matched |
| 33 | capture | 01a16033-670c-72c3-a374-e5637cf6c84c | €35.00 | €0.50 | matched |
| 34 | capture | 01a16033-7070-74f0-aa29-cc14eb795bf3 | €35.00 | €0.50 | matched |
| 35 | capture | 01a16033-70f3-7fa9-85b0-9262f8110c82 | €49.00 | €0.67 | matched |
| 36 | capture | 01a16033-80d3-7039-a0a1-850be13328e3 | €15.00 | €0.26 | matched |
| 37 | capture | 01a16033-8edc-7ab4-80eb-fab854077ab6 | €9.00 | €0.19 | matched |
| 38 | capture | 01a16033-c853-7078-b9c4-207bf6bc35eb | €9.00 | €0.19 | matched |
| 40 | capture | 01a16033-d2b3-7766-97b6-4d14f3c2b0e3 | €15.00 | €0.26 | matched |
| 41 | capture | 01a16033-d874-7a46-88f8-17ad42741554 | €9.00 | €0.19 | matched |
| 42 | capture | 01a16033-e205-7266-bb03-0c491d50b684 | €49.00 | €0.67 | matched |
| 43 | capture | 01a16033-ef09-733c-8b87-1c882a25730f | €9.00 | €0.19 | matched |
| 44 | capture | 01a16033-f717-77eb-be8c-b5a83b0d5f30 | €9.00 | €0.19 | matched |
| 45 | capture | 01a16033-fa4a-7d82-bbc3-810f77d79f82 | €49.00 | €0.67 | matched |
| 46 | capture | 01a16034-1171-76e2-a0b5-36082e50b47b | €9.00 | €0.19 | matched |
| 47 | capture | 01a16034-12aa-726b-8e08-e0c867c7cf02 | €15.00 | €0.26 | matched |
| 48 | capture | 01a16034-1613-708a-adb9-e76f84b7bb41 | €24.00 | €0.37 | matched |
| 49 | capture | 01a16034-475e-72f7-8e55-301c1b5dd502 | €9.00 | €0.19 | matched |
| 50 | capture | 01a16034-4ebe-78de-addd-b7746e2b4a18 | €24.00 | €0.37 | matched |
| 51 | capture | 01a16034-8c06-7433-b1ce-80d2984c7835 | €49.00 | €0.67 | matched |
| 52 | capture | 01a16034-adb9-7c62-817f-c5d14950b95b | €49.00 | €0.67 | matched |
| 53 | capture | 01a16034-b227-708a-bc74-d555e424b35a | €35.00 | €0.50 | matched |
| 54 | capture | 01a16034-be2f-7b78-a593-e8e8c6c78635 | €15.00 | €0.26 | matched |
| 55 | capture | 01a16034-c9ef-7bdf-842e-894f202f0d22 | €24.00 | €0.37 | matched |
| 56 | capture | 01a16034-d801-71da-98db-6bd69572fbff | €24.00 | €0.37 | matched |
| 57 | capture | 01a16034-f446-7fad-96d8-d765f8430dba | €15.00 | €0.26 | matched |
| 58 | capture | 01a16034-f5db-72b2-8b8c-e20e1c2ae2a0 | €49.00 | €0.67 | matched |
| 59 | capture | 01a16035-0c26-75fb-95bd-ba6084f41d79 | €35.00 | €0.50 | matched |
| 60 | capture | 01a16035-1265-7597-82e6-91f4d7c9882a | €9.00 | €0.19 | matched |
| 61 | capture | 01a16035-26c2-7d12-86e8-b807b5754db7 | €24.00 | €0.37 | matched |
| 62 | capture | 01a16035-2809-7783-b7f7-9676371718b5 | €35.00 | €0.50 | matched |
| 63 | capture | 01a16035-2e54-7b59-8f9e-e7131bd06b2a | €15.00 | €0.26 | matched |
| 64 | capture | 01a16035-38bc-7618-bcdb-80693a8d8099 | €49.00 | €0.67 | matched |
| 65 | capture | 01a16035-4894-7e40-8254-cf8cd15df961 | €49.00 | €0.67 | matched |
| 66 | capture | 01a16035-6470-7270-8e5d-1d0ef1a8dc0c | €24.00 | €0.37 | matched |
| 67 | capture | 01a16035-8ce2-7bd1-978a-74a8f2e5655c | €24.00 | €0.37 | matched |
| 68 | capture | 01a16035-8f08-7c13-aa8d-9dd033cea0e8 | €15.00 | €0.26 | matched |
| 69 | refund | 01a16035-a241-77e5-8281-954f0ee02f55 | -€22.00 | €0.00 | matched |
| 70 | capture | 01a16035-bbc0-73c3-83c9-709594aba5df | €35.00 | €0.50 | matched |
| 71 | capture | 01a16035-e682-76ca-b95e-72df2273675a | €15.00 | €0.26 | matched |
| 72 | capture | 01a16035-e988-7475-91ad-225a2e8f7a2c | €24.00 | €0.37 | matched |
| 74 | capture | 01a16035-f5b5-7568-b6f4-a382bdfe4579 | €24.00 | €0.37 | matched |
| 75 | capture | 01a16036-05c6-7c35-8410-9680168a4087 | €15.00 | €0.26 | matched |
| 76 | refund | 01a16036-1e7b-734f-9e17-b8017bd3c74a | -€14.00 | €0.00 | matched |
| 77 | capture | 01a16036-215d-7bf8-8d38-5ede0e1a2bbc | €15.00 | €0.26 | matched |
| 78 | capture | 01a16036-3cf4-775c-9b37-01d8bf60e6b2 | €9.00 | €0.19 | matched |
| 79 | capture | 01a16036-5f13-7b88-8957-2651171adc56 | €35.00 | €0.50 | matched |
| 80 | refund | 01a16036-6337-781f-920d-6eeb6dc2bca5 | -€4.00 | €0.00 | matched |
| 81 | refund | 01a16036-653d-7c81-a403-09f0abe875c2 | -€14.00 | €0.00 | matched |
| 82 | capture | 01a16036-7af0-7a46-a920-beb12f067aa6 | €35.00 | €0.50 | matched |
| 83 | capture | 01a16036-9abd-764a-822f-6100e3ea2141 | €49.00 | €0.67 | matched |
| 84 | capture | 01a16036-a543-75ee-87aa-5663609155d8 | €15.00 | €0.26 | matched |
| 85 | capture | 01a16036-a82c-77d0-bde1-d6ea9677727e | €24.00 | €0.37 | matched |
| 86 | capture | 01a16036-a9f0-7b4e-a41d-e3ebe0384d7d | €35.00 | €0.50 | matched |
| 87 | capture | 01a16036-bf71-7a0a-86c5-495bb702ed23 | €49.00 | €0.67 | matched |
| 88 | capture | 01a16036-c828-75dc-b9ca-b1bb1682b22c | €49.00 | €0.67 | matched |
| 89 | capture | 01a16036-d263-7efd-a663-4947f9098f4b | €15.00 | €0.26 | matched |
| 90 | capture | 01a16036-d561-775e-a456-dc99aeaa99b6 | €9.00 | €0.19 | matched |
| 91 | capture | 01a16037-0c0d-7a73-900b-87ea7f55a8ee | €35.00 | €0.50 | matched |
| 92 | capture | 01a16037-3e8f-79ae-8a96-fc7a09493e1f | €24.00 | €0.37 | matched |
| 93 | capture | 01a16037-3f12-7355-9521-1ee1682f5635 | €9.00 | €0.19 | matched |
| 94 | refund | 01a16037-430c-7942-b437-79dfa6818770 | -€8.00 | €0.00 | matched |
| 95 | capture | 01a16037-441f-783b-bde1-72948ee219f4 | €49.00 | €0.67 | matched |
| 96 | capture | 01a16037-5fd5-7175-b8e0-ea43cd71060c | €24.00 | €0.37 | matched |
| 97 | capture | 01a16037-6a79-7bd4-a94a-9e2992c9157f | €24.00 | €0.37 | matched |
| 98 | capture | 01a16037-794e-774b-ab18-0d53fc62f01b | €49.00 | €0.67 | matched |
| 99 | capture | 01a16037-7ec7-7fcd-b7f0-8172ae843d98 | €9.00 | €0.19 | matched |
| 100 | capture | 01a16037-a165-7ed2-861b-93cf3c0b237f | €9.00 | €0.19 | matched |
| 101 | capture | 01a16037-adb1-7812-b240-779ea4924665 | €49.00 | €0.67 | matched |
| 102 | capture | 01a16038-020d-712d-be2a-892050616674 | €15.00 | €0.26 | matched |
| 103 | capture | 01a16038-2842-7eb5-815e-30b30564b794 | €49.00 | €0.67 | matched |
| 104 | capture | 01a16038-4031-7f2b-a629-bdd11bcb6a4f | €24.00 | €0.37 | matched |
| 105 | capture | 01a16038-896f-7864-8f18-414efd7f17dd | €24.00 | €0.37 | matched |
| 106 | capture | 01a16038-b356-799b-acca-6bacad5ecaad | €49.00 | €0.67 | matched |
| 107 | capture | 01a16039-2dcb-72a9-8ba6-3c4bedb8dd04 | €35.00 | €0.50 | matched |
| 108 | capture | 01a16039-41c9-786e-bdae-dc675b9a960e | €9.00 | €0.19 | matched |
| 109 | capture | 01a16039-4ae3-7ff9-9441-3c6a344809c7 | €15.00 | €0.26 | matched |
| 110 | refund | 01a16039-88fd-796b-aabc-0ac9a2c2b2b1 | -€7.00 | €0.00 | matched |
| 112 | capture | 01a16039-a6ed-701e-8ea6-ce6c2d9c77d8 | €15.00 | €0.26 | matched |
| 113 | capture | 01a16039-c1dd-7d48-b9f3-0160063214d2 | €49.00 | €0.67 | matched |
| 114 | capture | 01a16039-d25c-74c0-be66-cc4e650a230c | €9.00 | €0.19 | matched |
| 115 | capture | 01a16039-e5f9-770e-8236-d4d632999d62 | €9.00 | €0.19 | matched |
| 116 | capture | 01a1603a-19ba-79a1-ad4c-6789ac6854ed | €35.00 | €0.50 | matched |
| 117 | capture | 01a1603a-1b7e-7441-87a5-63505cfb48a5 | €49.00 | €0.67 | matched |
| 118 | capture | 01a1603a-1d48-7fcd-b1ef-187c0c655752 | €24.00 | €0.37 | matched |
| 119 | capture | 01a1603a-4d61-782c-98e4-88b88545b04b | €24.00 | €0.37 | matched |
| 120 | capture | 01a1603a-57c5-70f5-bcd1-00d59ab24ada | €15.00 | €0.26 | matched |
| 121 | capture | 01a1603a-5c7f-756f-b287-3199467dee4b | €9.00 | €0.19 | matched |