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
- 5 Nov, 21:00112 lines3 breaks
- 5 Nov, 20:50117 lines2 breaks
- 5 Nov, 20:40107 lines2 breaks
- 5 Nov, 20:30135 lines1 break
- 5 Nov, 20:20130 lines1 break
- 5 Nov, 20:10105 lines5 breaks
- 5 Nov, 20:00148 lines1 break
- 5 Nov, 19:50132 lines5 breaks
- 5 Nov, 19:40112 lines1 break
- 5 Nov, 19:30137 lines3 breaks
- 5 Nov, 19:20142 lines2 breaks
- 5 Nov, 19:10106 lines3 breaks
- 5 Nov, 19:00134 lines4 breaks
- 5 Nov, 18:50151 lines3 breaks
5 Nov, 19:00
Gross
€3,543.00
PSP fee
€53.48
Net to the bank
€3,489.52
Settlement journal
#402631
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1ad17-351b-74f7-91ab-1c51eb9ceb78 is already settled by stl_EUR_2989842 line 41
- fee differencethe fee is not the contract feethe fee is 30, the contract says 26
- fee differencethe fee is not the contract feethe fee is 21, the contract says 19
- missing linein the books, not in the filecapture:01a1ad18-f5c5-7803-ac41-87d6589142ee is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 24 | capture | 01a1ad16-2178-7198-b3c5-a02dcdb9cb3a | €15.00 | €0.30 | fee difference |
| 42 | capture | 01a1ad17-3543-7202-8f66-f1afb4f83b10 | €35.00 | €0.50 | duplicate line |
| 57 | capture | 01a1ad18-03c1-774c-949d-ba6fef3de459 | €9.00 | €0.21 | fee difference |
| 1 | capture | 01a1ad10-a2c0-7d9a-a33c-9131093e259a | €9.00 | €0.19 | matched |
| 2 | capture | 01a1ad11-3963-7043-bde8-ee8ef3cbfd1d | €9.00 | €0.19 | matched |
| 3 | capture | 01a1ad12-eb74-7f0f-9bdf-10b564bb01f5 | €35.00 | €0.50 | matched |
| 4 | capture | 01a1ad14-c418-7eaf-9fe9-0019a541a05e | €15.00 | €0.26 | matched |
| 5 | capture | 01a1ad15-2936-7508-8916-4a4161c71d23 | €9.00 | €0.19 | matched |
| 6 | capture | 01a1ad15-468c-75d1-b43d-ae3a22aebedb | €24.00 | €0.37 | matched |
| 7 | capture | 01a1ad15-501e-7ff3-85be-1b83ca0b8ce8 | €9.00 | €0.19 | matched |
| 8 | capture | 01a1ad15-580f-7fda-8e60-67713757d1b9 | €9.00 | €0.19 | matched |
| 9 | capture | 01a1ad15-6a39-73c2-a6f2-98a66e71709f | €15.00 | €0.26 | matched |
| 10 | capture | 01a1ad15-6e5a-70dc-8ffa-0bf97bc2d71b | €24.00 | €0.37 | matched |
| 11 | capture | 01a1ad15-7675-7b77-914f-e544052b564e | €15.00 | €0.26 | matched |
| 12 | capture | 01a1ad15-8803-7f39-8c46-37a371725866 | €24.00 | €0.37 | matched |
| 13 | capture | 01a1ad15-886b-72a8-abf0-a05a2df2fb3b | €49.00 | €0.67 | matched |
| 14 | capture | 01a1ad15-8d24-7215-a821-c59df6c6b332 | €9.00 | €0.19 | matched |
| 15 | capture | 01a1ad15-bba7-7f94-a444-c18d1b0a5f73 | €35.00 | €0.50 | matched |
| 16 | capture | 01a1ad15-bc85-70b2-8d01-34d66a7e835d | €49.00 | €0.67 | matched |
| 17 | capture | 01a1ad15-ce85-76a2-9929-5268b62c8240 | €49.00 | €0.67 | matched |
| 18 | capture | 01a1ad15-d50b-7876-9541-28a343585650 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1ad15-e2db-7c39-802e-4e0dc1a3a98c | €24.00 | €0.37 | matched |
| 20 | capture | 01a1ad15-f600-73b7-ac3d-0fceddf2a292 | €15.00 | €0.26 | matched |
| 21 | capture | 01a1ad16-026c-7399-a292-89c29bd665ba | €49.00 | €0.67 | matched |
| 22 | capture | 01a1ad16-1ce0-7330-8f66-876af568b327 | €35.00 | €0.50 | matched |
| 23 | capture | 01a1ad16-1f76-7322-9bd1-1ca541c3a1e9 | €9.00 | €0.19 | matched |
| 25 | capture | 01a1ad16-2b98-70bb-badf-41869b7d81a9 | €49.00 | €0.67 | matched |
| 26 | capture | 01a1ad16-34e7-72fa-a7da-e2b6a2bfae0a | €9.00 | €0.19 | matched |
| 27 | capture | 01a1ad16-5558-7dcd-b748-04ab98b9b479 | €49.00 | €0.67 | matched |
| 28 | capture | 01a1ad16-5620-799f-9c79-e6c5af627d69 | €35.00 | €0.50 | matched |
| 29 | capture | 01a1ad16-6020-70d6-8185-c3b2ca9dc568 | €15.00 | €0.26 | matched |
| 30 | capture | 01a1ad16-63f9-7f02-b0f9-86871d54ae9b | €24.00 | €0.37 | matched |
| 31 | capture | 01a1ad16-7bb0-7400-a117-84127de74e3f | €49.00 | €0.67 | matched |
| 32 | capture | 01a1ad16-6c9d-748e-9119-54dd4a79186a | €24.00 | €0.37 | matched |
| 33 | capture | 01a1ad16-957c-758d-95b3-c542052b040c | €24.00 | €0.37 | matched |
| 34 | capture | 01a1ad16-b333-7501-9ffe-c7b218832fb5 | €15.00 | €0.26 | matched |
| 35 | capture | 01a1ad16-caac-7420-b471-611d670a8ffe | €49.00 | €0.67 | matched |
| 36 | capture | 01a1ad16-e8d5-7358-8d5b-bd697f2aeb5e | €49.00 | €0.67 | matched |
| 37 | capture | 01a1ad16-f2b7-7ca8-a2cd-62b245fda2ca | €15.00 | €0.26 | matched |
| 38 | capture | 01a1ad17-1832-721f-8274-0e1339f76545 | €9.00 | €0.19 | matched |
| 39 | capture | 01a1ad17-1ef4-749d-b4b9-51c967b76332 | €49.00 | €0.67 | matched |
| 40 | capture | 01a1ad17-269d-7213-9aee-19157cf3fac9 | €9.00 | €0.19 | matched |
| 41 | capture | 01a1ad17-3543-7202-8f66-f1afb4f83b10 | €35.00 | €0.50 | matched |
| 43 | capture | 01a1ad17-6e30-7cfd-808f-fea192a991a9 | €35.00 | €0.50 | matched |
| 44 | capture | 01a1ad17-734c-7c45-87b6-b285c3aab406 | €35.00 | €0.50 | matched |
| 45 | capture | 01a1ad17-7368-7eb0-9f3b-9e43dbe7886a | €49.00 | €0.67 | matched |
| 46 | capture | 01a1ad17-785f-76e6-917f-e269bef0dd57 | €15.00 | €0.26 | matched |
| 47 | capture | 01a1ad17-8a5c-7b1e-9c62-40740d6516ca | €49.00 | €0.67 | matched |
| 48 | refund | 01a1ad17-8dbc-796d-b107-c48857ad3c1e | -€8.00 | €0.00 | matched |
| 49 | capture | 01a1ad17-ad71-7264-b67f-5eaf87d1753a | €15.00 | €0.26 | matched |
| 50 | capture | 01a1ad17-af0d-7fd9-97cd-a8c601b9e9aa | €49.00 | €0.67 | matched |
| 51 | capture | 01a1ad17-c61c-767f-8ab4-e43477880575 | €15.00 | €0.26 | matched |
| 52 | capture | 01a1ad17-cd22-74dc-9a2a-69127fa6368f | €24.00 | €0.37 | matched |
| 53 | capture | 01a1ad17-d5fa-7a4d-bae7-fcb79d445619 | €35.00 | €0.50 | matched |
| 54 | refund | 01a1ad17-e1e2-7232-ac3e-24d1713173a9 | -€7.00 | €0.00 | matched |
| 55 | capture | 01a1ad17-f4f8-733e-93ab-f8751769eb57 | €15.00 | €0.26 | matched |
| 56 | capture | 01a1ad17-fa8d-710b-8090-063e1017bd58 | €9.00 | €0.19 | matched |
| 58 | capture | 01a1ad18-184e-7ab3-96d0-e554eda9a7ad | €35.00 | €0.50 | matched |
| 59 | capture | 01a1ad18-1d36-70c7-bd1e-2178139efe80 | €15.00 | €0.26 | matched |
| 60 | capture | 01a1ad18-2304-7a65-a1de-286d22ea7d6f | €24.00 | €0.37 | matched |
| 61 | capture | 01a1ad18-2617-7ef5-af5a-deb5e03e2f0f | €35.00 | €0.50 | matched |
| 62 | capture | 01a1ad18-4aa7-7f64-88bf-a67368ba7eba | €49.00 | €0.67 | matched |
| 63 | capture | 01a1ad18-527f-76e8-b304-924de5e475d8 | €24.00 | €0.37 | matched |
| 64 | capture | 01a1ad18-881b-7996-aefb-38cdcfbf7f17 | €49.00 | €0.67 | matched |
| 65 | capture | 01a1ad18-8b6a-70e8-a74d-1da67457e821 | €35.00 | €0.50 | matched |
| 66 | capture | 01a1ad18-92bf-7690-b290-339c28732517 | €35.00 | €0.50 | matched |
| 67 | capture | 01a1ad18-953b-7a00-a9d1-59cf29e0315f | €35.00 | €0.50 | matched |
| 68 | capture | 01a1ad18-9b8d-7289-a9a2-a266f7bf9d19 | €24.00 | €0.37 | matched |
| 69 | capture | 01a1ad18-b5c1-7756-af3e-2f5cb21f9d7b | €49.00 | €0.67 | matched |
| 70 | capture | 01a1ad18-b78c-78b8-87c0-606935b9d80b | €24.00 | €0.37 | matched |
| 71 | capture | 01a1ad18-ccfa-742a-8634-9c9f8de4da19 | €9.00 | €0.19 | matched |
| 72 | capture | 01a1ad18-d80c-7e78-9d39-0bf0502a4c43 | €49.00 | €0.67 | matched |
| 73 | capture | 01a1ad18-df33-71d8-a652-48257e60715d | €49.00 | €0.67 | matched |
| 74 | capture | 01a1ad18-e64b-797a-9c1c-519ed6125207 | €15.00 | €0.26 | matched |
| 75 | capture | 01a1ad19-00f1-750c-8c56-234bf7715296 | €24.00 | €0.37 | matched |
| 76 | capture | 01a1ad19-15c0-72d0-9732-3a6d982b9ec6 | €15.00 | €0.26 | matched |
| 77 | capture | 01a1ad19-1d91-7dc4-ae3d-af7d653f7c99 | €49.00 | €0.67 | matched |
| 78 | capture | 01a1ad19-3340-7077-bbb2-451d3888f726 | €24.00 | €0.37 | matched |
| 79 | capture | 01a1ad19-4679-752a-bb45-b60a21a96964 | €9.00 | €0.19 | matched |
| 80 | capture | 01a1ad19-728d-7efe-a9bd-e19b6552a635 | €15.00 | €0.26 | matched |
| 81 | capture | 01a1ad19-a4eb-709f-b2c0-3004b50d243f | €49.00 | €0.67 | matched |
| 82 | capture | 01a1ad19-c9dc-7304-9358-906e481bb23c | €15.00 | €0.26 | matched |
| 83 | capture | 01a1ad19-caf5-71ff-84c0-8312e4060321 | €9.00 | €0.19 | matched |
| 84 | capture | 01a1ad19-cc0a-7ba5-85dd-7e1499af060b | €9.00 | €0.19 | matched |
| 85 | capture | 01a1ad19-ee68-7097-9884-6dbf4c21aa5f | €24.00 | €0.37 | matched |
| 86 | capture | 01a1ad19-f68e-7dc4-9a95-96101e0ca169 | €49.00 | €0.67 | matched |
| 87 | capture | 01a1ad1a-282c-73cf-a1e2-b5efe7013294 | €15.00 | €0.26 | matched |
| 88 | capture | 01a1ad1a-31d0-763e-bce2-eb0d2024deb4 | €35.00 | €0.50 | matched |
| 89 | capture | 01a1ad1a-45f0-7084-8a85-253a9c12e48a | €49.00 | €0.67 | matched |
| 90 | capture | 01a1ad1a-b688-7242-8f06-f83b9869bc25 | €24.00 | €0.37 | matched |
| 91 | capture | 01a1ad1a-cee3-78b1-a302-730194a81cb4 | €9.00 | €0.19 | matched |
| 92 | capture | 01a1ad1a-d905-70f8-8e46-54e366650b19 | €24.00 | €0.37 | matched |
| 93 | capture | 01a1ad1a-f9b2-774e-992c-f742777091d6 | €15.00 | €0.26 | matched |
| 94 | capture | 01a1ad1b-01d5-742a-a235-3c9d78245f25 | €35.00 | €0.50 | matched |
| 95 | capture | 01a1ad1b-08cf-7969-8242-44bf8bea54c4 | €24.00 | €0.37 | matched |
| 96 | capture | 01a1ad1b-13cc-7b57-8231-5129761da160 | €35.00 | €0.50 | matched |
| 97 | capture | 01a1ad1b-14d8-7453-9499-1aaecbc36ad1 | €15.00 | €0.26 | matched |
| 98 | capture | 01a1ad1b-22b7-7147-8250-59be8a350687 | €35.00 | €0.50 | matched |
| 99 | capture | 01a1ad1b-2da6-7c31-b1a5-b458f406673a | €15.00 | €0.26 | matched |
| 100 | capture | 01a1ad1b-3dcc-7820-9fb8-af8e7de01881 | €49.00 | €0.67 | matched |
| 101 | capture | 01a1ad1b-64d6-75c0-b2f3-1da336d5d478 | €35.00 | €0.50 | matched |
| 102 | capture | 01a1ad1b-79b4-78bb-bd18-9713c7b254ce | €49.00 | €0.67 | matched |
| 103 | capture | 01a1ad1b-855a-7814-853f-439d7f284eb8 | €35.00 | €0.50 | matched |
| 104 | capture | 01a1ad1b-ab67-7f9e-a2d2-1374c1e22bdc | €49.00 | €0.67 | matched |
| 105 | capture | 01a1ad1b-b13d-724e-bf81-38075b0bc582 | €24.00 | €0.37 | matched |
| 106 | capture | 01a1ad1b-e7e8-73d7-9a76-add4dcd88575 | €35.00 | €0.50 | matched |
| 107 | capture | 01a1ad1b-f586-7b7b-a145-d82602f2293e | €9.00 | €0.19 | matched |
| 108 | capture | 01a1ad1b-f9e8-77d3-a237-08da9b8d25fb | €49.00 | €0.67 | matched |
| 109 | capture | 01a1ad1b-fe1b-7a2c-9395-718ed1bf3e5f | €35.00 | €0.50 | matched |
| 110 | capture | 01a1ad1c-1138-75a6-8102-9bc8541058e5 | €15.00 | €0.26 | matched |
| 111 | capture | 01a1ad1c-1ce9-7dab-bbdc-adeb3ce6250e | €35.00 | €0.50 | matched |
| 112 | capture | 01a1ad1c-51a2-76ad-a98a-2f0bf2a5616b | €24.00 | €0.37 | matched |
| 113 | capture | 01a1ad1c-6d22-7347-bfbb-6080b20cb6be | €15.00 | €0.26 | matched |
| 114 | capture | 01a1ad1c-9595-73bf-9634-99f184f83e3e | €49.00 | €0.67 | matched |
| 115 | capture | 01a1ad1c-a168-7e60-bde2-8fcdf8fa8cc6 | €24.00 | €0.37 | matched |
| 116 | capture | 01a1ad1c-a5ee-7a47-95d5-5193976e1b51 | €49.00 | €0.67 | matched |
| 117 | capture | 01a1ad1c-ab3e-765f-ade4-60c65ba93681 | €9.00 | €0.19 | matched |
| 118 | capture | 01a1ad1c-d78c-7754-ac63-9a7ea1215118 | €15.00 | €0.26 | matched |
| 119 | capture | 01a1ad1c-dfe9-7faf-8941-d8926299afbc | €24.00 | €0.37 | matched |
| 120 | capture | 01a1ad1d-0a28-7445-a12b-5628ce689487 | €9.00 | €0.19 | matched |
| 121 | capture | 01a1ad1d-16c1-7006-ae8b-6b19cb5253cd | €24.00 | €0.37 | matched |
| 122 | capture | 01a1ad1d-1a89-7268-a33c-a31278dbe46a | €24.00 | €0.37 | matched |
| 123 | capture | 01a1ad1d-1eb9-7dd9-b82f-ab4550723006 | €9.00 | €0.19 | matched |
| 124 | capture | 01a1ad1d-3784-76c3-844e-fc1cab06cbcb | €15.00 | €0.26 | matched |
| 125 | capture | 01a1ad1d-5ff5-7d0b-bbdc-b4102737083a | €49.00 | €0.67 | matched |
| 126 | capture | 01a1ad1d-9f50-7ff8-98ea-0869d4ffdf1a | €35.00 | €0.50 | matched |
| 127 | capture | 01a1ad1d-ad6b-71cc-8be4-7909acae5106 | €15.00 | €0.26 | matched |
| 128 | capture | 01a1ad1d-badd-7213-bfec-59022dd13577 | €9.00 | €0.19 | matched |
| 129 | capture | 01a1ad1d-e78d-7034-9449-d06366d494a6 | €24.00 | €0.37 | matched |
| 130 | capture | 01a1ad1d-f132-743a-8c41-b8a1640f1b62 | €49.00 | €0.67 | matched |
| 131 | capture | 01a1ad1d-f1b5-7f7c-8337-d415f1742119 | €9.00 | €0.19 | matched |
| 132 | capture | 01a1ad1d-fe92-7927-a298-697d38c64387 | €9.00 | €0.19 | matched |
| 133 | capture | 01a1ad1e-0e83-7862-80d7-9e334c68dea6 | €9.00 | €0.19 | matched |
| 134 | capture | 01a1ad1e-3153-78f1-8d31-308a32027a16 | €24.00 | €0.37 | matched |