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, 16:10137 lines3 breaks
- 5 Nov, 16:00111 linesclean
- 5 Nov, 15:50120 lines2 breaks
- 5 Nov, 15:40138 lines4 breaks
- 5 Nov, 15:30128 lines1 break
- 5 Nov, 15:20119 lines3 breaks
- 5 Nov, 15:10115 lines2 breaks
- 5 Nov, 15:00122 lines1 break
- 5 Nov, 14:50134 lines7 breaks
- 5 Nov, 14:40125 lines2 breaks
- 5 Nov, 14:30121 lines3 breaks
- 5 Nov, 14:20118 lines3 breaks
- 5 Nov, 14:10113 lines4 breaks
- 5 Nov, 14:00138 lines2 breaks
5 Nov, 15:20
Gross
€2,798.00
PSP fee
€44.04
Net to the bank
€2,753.96
Settlement journal
#399798
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a1ac54-4de4-72a4-b3d7-302140b5c5cf is already settled by stl_EUR_2989820 line 110
- fee differencethe fee is not the contract feethe fee is 69, the contract says 67
- missing linein the books, not in the filecapture:01a1ac53-36ac-71d3-a1fc-fa34d8034006 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 65 | capture | 01a1ac51-694a-740f-991e-e0ae5a5e9aa9 | €49.00 | €0.69 | fee difference |
| 111 | refund | 01a1ac54-4de4-7fd0-8ca7-283af1501d6f | -€13.00 | €0.00 | duplicate line |
| 1 | refund | 01a1ac42-8bf6-72eb-b96c-b13ff5928328 | -€11.00 | €0.00 | matched |
| 2 | capture | 01a1ac44-53bb-74d5-983e-f2169ef68a2c | €24.00 | €0.37 | matched |
| 3 | capture | 01a1ac44-d3ca-7c80-bb88-ad8625ad44f1 | €35.00 | €0.50 | matched |
| 4 | capture | 01a1ac48-863f-76fc-bef1-3c597096570d | €49.00 | €0.67 | matched |
| 5 | capture | 01a1ac4a-c4a9-79b8-b73b-ff60aa69213f | €15.00 | €0.26 | matched |
| 6 | capture | 01a1ac4b-dcce-75c2-a72c-57eb21df3f58 | €15.00 | €0.26 | matched |
| 7 | capture | 01a1ac4b-ef84-780e-bebc-c5c153a4f2f8 | €49.00 | €0.67 | matched |
| 8 | capture | 01a1ac4b-f1dd-7925-a059-710040335b71 | €15.00 | €0.26 | matched |
| 9 | capture | 01a1ac4c-0f1d-78b9-96aa-ac5993edd11c | €24.00 | €0.37 | matched |
| 10 | capture | 01a1ac4c-4227-7a97-9aaa-ae41639bc21f | €15.00 | €0.26 | matched |
| 11 | capture | 01a1ac4c-6f76-72ff-8af8-b2e7da200e86 | €49.00 | €0.67 | matched |
| 12 | capture | 01a1ac4c-7e75-76d3-acc2-b29a9c434896 | €24.00 | €0.37 | matched |
| 13 | capture | 01a1ac4c-8b32-7449-92a4-9898cf3553c9 | €35.00 | €0.50 | matched |
| 14 | capture | 01a1ac4c-98d1-7ff3-b344-0625775b1bde | €15.00 | €0.26 | matched |
| 15 | capture | 01a1ac4c-9be6-7dcb-b404-bd0ada411fcf | €35.00 | €0.50 | matched |
| 16 | capture | 01a1ac4c-9c29-739f-8507-f998fd435e8d | €24.00 | €0.37 | matched |
| 17 | capture | 01a1ac4c-c8c0-7a75-9530-7429b65f2bf3 | €15.00 | €0.26 | matched |
| 18 | capture | 01a1ac4c-f01a-797c-b80e-f83a70312c83 | €35.00 | €0.50 | matched |
| 19 | capture | 01a1ac4d-0aa7-7f15-9953-232684e55d73 | €9.00 | €0.19 | matched |
| 20 | capture | 01a1ac4d-0c1c-73d1-94ff-1be6d05a5ac5 | €15.00 | €0.26 | matched |
| 21 | capture | 01a1ac4d-0fce-767d-8f71-2ac83d00a487 | €49.00 | €0.67 | matched |
| 22 | capture | 01a1ac4d-11fb-7bbe-b6a3-7170d9bc4eda | €35.00 | €0.50 | matched |
| 23 | capture | 01a1ac4d-2a37-7a7e-ac74-632ae1dbfc52 | €9.00 | €0.19 | matched |
| 24 | capture | 01a1ac4d-266f-7dd7-9eb5-2c139823ee8b | €24.00 | €0.37 | matched |
| 25 | capture | 01a1ac4d-36fd-73bc-8c86-de5c293b1c20 | €24.00 | €0.37 | matched |
| 26 | capture | 01a1ac4d-5c27-715d-9e94-7620e66d745e | €35.00 | €0.50 | matched |
| 27 | capture | 01a1ac4d-70c1-7704-865f-7c516bd13094 | €15.00 | €0.26 | matched |
| 28 | capture | 01a1ac4d-76fe-717e-8c58-88c70ba54cb6 | €24.00 | €0.37 | matched |
| 29 | capture | 01a1ac4d-87f2-7fb3-bf03-505d55be7021 | €49.00 | €0.67 | matched |
| 30 | capture | 01a1ac4d-aa1e-70b5-9841-f343db08ef8a | €9.00 | €0.19 | matched |
| 31 | capture | 01a1ac4d-97cc-766f-9f18-11501d790380 | €15.00 | €0.26 | matched |
| 32 | capture | 01a1ac4d-c396-7759-9e35-6b1757a33009 | €24.00 | €0.37 | matched |
| 33 | capture | 01a1ac4d-c3bf-7c5c-917c-ac39a14202d6 | €49.00 | €0.67 | matched |
| 34 | capture | 01a1ac4d-c8c9-7e3c-8a77-48cd08ea3678 | €15.00 | €0.26 | matched |
| 35 | capture | 01a1ac4d-cd8f-7d33-b316-dc8172b927d9 | €9.00 | €0.19 | matched |
| 36 | capture | 01a1ac4e-bee2-78f8-8336-14adc050aa5b | €9.00 | €0.19 | matched |
| 37 | capture | 01a1ac4e-d97e-7c2b-89b4-a94ecd22990a | €35.00 | €0.50 | matched |
| 38 | capture | 01a1ac4f-0a7b-7f4f-90f8-d0fb45f0a52c | €49.00 | €0.67 | matched |
| 39 | capture | 01a1ac4f-64d9-7ac0-aab6-e2f1f029962d | €35.00 | €0.50 | matched |
| 40 | capture | 01a1ac4f-6cf7-7bb2-899f-cff0a50a949d | €24.00 | €0.37 | matched |
| 41 | capture | 01a1ac4f-9163-7d62-9fd2-639337baf17b | €15.00 | €0.26 | matched |
| 42 | capture | 01a1ac4f-ae2c-7a59-88e3-f2cd32df939b | €35.00 | €0.50 | matched |
| 43 | capture | 01a1ac4f-aeba-7e95-a44c-f235faafb8ae | €9.00 | €0.19 | matched |
| 44 | capture | 01a1ac4f-b175-7bde-9249-ccf70ed73efb | €35.00 | €0.50 | matched |
| 45 | capture | 01a1ac4f-bdf9-7ec4-89c5-c40b99db87a4 | €35.00 | €0.50 | matched |
| 46 | capture | 01a1ac4f-c36a-72f7-a9e3-9827018ca901 | €15.00 | €0.26 | matched |
| 47 | capture | 01a1ac4f-c386-7e49-b7e9-7ab1d458382d | €49.00 | €0.67 | matched |
| 48 | capture | 01a1ac4f-cad9-7de7-86e9-211383b45c0d | €9.00 | €0.19 | matched |
| 49 | capture | 01a1ac4f-d7c5-7e0c-8b7f-45c6651b83f3 | €15.00 | €0.26 | matched |
| 50 | capture | 01a1ac4f-e47d-7be9-a35e-32e0e57c45a2 | €9.00 | €0.19 | matched |
| 51 | refund | 01a1ac50-1cbe-7206-87a6-6bdff642288a | -€8.00 | €0.00 | matched |
| 52 | capture | 01a1ac50-44c7-76e8-a0de-f4e718966177 | €49.00 | €0.67 | matched |
| 53 | capture | 01a1ac50-48ba-7107-951a-c5fe30a36fe5 | €9.00 | €0.19 | matched |
| 54 | capture | 01a1ac50-51fc-739c-899e-a7e0138b09d0 | €15.00 | €0.26 | matched |
| 55 | capture | 01a1ac50-601d-7587-8bd2-933830817c26 | €24.00 | €0.37 | matched |
| 56 | capture | 01a1ac50-8c72-75ba-9f06-17a6c6e130f1 | €35.00 | €0.50 | matched |
| 57 | capture | 01a1ac50-9b37-7899-9c30-628425a83b3d | €15.00 | €0.26 | matched |
| 58 | capture | 01a1ac50-b915-70d8-84f4-f79988ae5593 | €49.00 | €0.67 | matched |
| 59 | capture | 01a1ac50-e2ec-7e52-aa49-068c1cfa1114 | €49.00 | €0.67 | matched |
| 60 | capture | 01a1ac50-f3dd-70be-a5f7-7e9ea20d037f | €15.00 | €0.26 | matched |
| 61 | capture | 01a1ac50-fcb6-76c6-8af7-42f7b9547e5c | €35.00 | €0.50 | matched |
| 62 | capture | 01a1ac51-04b9-7d27-8afc-12e5ac4ea5c7 | €35.00 | €0.50 | matched |
| 63 | capture | 01a1ac51-3e07-7236-b966-5d33272e5802 | €15.00 | €0.26 | matched |
| 64 | refund | 01a1ac51-586a-7654-b575-e5f3fad35eaf | -€31.00 | €0.00 | matched |
| 66 | refund | 01a1ac51-7040-7d4b-b933-eb84555aeca1 | -€14.00 | €0.00 | matched |
| 67 | capture | 01a1ac51-80c9-7dbb-9136-718f0ae737f7 | €49.00 | €0.67 | matched |
| 68 | capture | 01a1ac51-8112-7316-aaa8-59c635a6d56c | €35.00 | €0.50 | matched |
| 69 | capture | 01a1ac51-86dc-7609-adca-1d1258dbe238 | €35.00 | €0.50 | matched |
| 70 | capture | 01a1ac51-8a7f-762e-83d6-dd64e8c27b02 | €35.00 | €0.50 | matched |
| 71 | capture | 01a1ac51-97bf-76d3-838a-2d47a09d9231 | €9.00 | €0.19 | matched |
| 72 | refund | 01a1ac51-b207-7743-91f4-10b30d23c752 | -€8.00 | €0.00 | matched |
| 73 | capture | 01a1ac51-d9f4-7561-a20d-9771cea48323 | €24.00 | €0.37 | matched |
| 74 | capture | 01a1ac51-f9ff-7d48-8def-6f0420e06f5c | €49.00 | €0.67 | matched |
| 75 | capture | 01a1ac51-faa4-7d59-bbc8-ebffc7a98472 | €35.00 | €0.50 | matched |
| 76 | capture | 01a1ac52-13d5-7060-8744-03e9efc54841 | €15.00 | €0.26 | matched |
| 77 | capture | 01a1ac52-3892-7fac-9e33-61c75b9ddf2c | €15.00 | €0.26 | matched |
| 78 | capture | 01a1ac52-3af3-7cb9-a4a5-ec52c44f85fb | €49.00 | €0.67 | matched |
| 79 | capture | 01a1ac52-505f-71ea-9fbc-ddb6f1b3bcba | €24.00 | €0.37 | matched |
| 80 | capture | 01a1ac52-5653-7199-9389-5606da431cab | €9.00 | €0.19 | matched |
| 81 | capture | 01a1ac52-59aa-7e49-99f5-38de47a397a2 | €24.00 | €0.37 | matched |
| 82 | capture | 01a1ac52-5b86-74cd-a137-5f339ca4eecd | €35.00 | €0.50 | matched |
| 83 | capture | 01a1ac52-686d-716e-bbdd-124a11b2de12 | €35.00 | €0.50 | matched |
| 84 | capture | 01a1ac52-78a4-71eb-8a90-c33994c08561 | €15.00 | €0.26 | matched |
| 85 | capture | 01a1ac52-8618-71ba-8dbf-41f23f8a2d70 | €15.00 | €0.26 | matched |
| 86 | capture | 01a1ac52-bdde-7245-9d70-eae433c19552 | €35.00 | €0.50 | matched |
| 87 | capture | 01a1ac52-be98-7507-b0d4-1deee0c4488f | €49.00 | €0.67 | matched |
| 88 | capture | 01a1ac52-ca55-794f-baac-b418a47df28f | €9.00 | €0.19 | matched |
| 89 | capture | 01a1ac52-e542-7431-b26e-cd09b7609a56 | €9.00 | €0.19 | matched |
| 90 | capture | 01a1ac52-eed6-7e4d-b1ca-83a9811e0be3 | €49.00 | €0.67 | matched |
| 91 | capture | 01a1ac53-018e-7122-9f8a-27e95b8552b8 | €24.00 | €0.37 | matched |
| 92 | capture | 01a1ac53-0cb8-72d2-934e-0dfed5d25815 | €35.00 | €0.50 | matched |
| 93 | capture | 01a1ac53-154a-765a-85e3-1938420b1418 | €9.00 | €0.19 | matched |
| 94 | capture | 01a1ac53-21e6-7444-bb0b-bae424c81704 | €9.00 | €0.19 | matched |
| 95 | capture | 01a1ac53-2623-7a8f-b319-ea938a418869 | €24.00 | €0.37 | matched |
| 96 | capture | 01a1ac53-2a26-7e09-a4f9-1361fa8ac049 | €35.00 | €0.50 | matched |
| 97 | refund | 01a1ac53-77fc-79cb-b701-b34b43b7e223 | -€12.00 | €0.00 | matched |
| 98 | capture | 01a1ac53-801e-71f0-b226-876ad76432d4 | €24.00 | €0.37 | matched |
| 99 | capture | 01a1ac53-9a43-76f6-a81c-7931290d4e50 | €9.00 | €0.19 | matched |
| 100 | capture | 01a1ac53-a2f2-7ec6-bc7c-a170ed092756 | €24.00 | €0.37 | matched |
| 101 | capture | 01a1ac53-a74f-7f9d-9358-1a946bcacec1 | €9.00 | €0.19 | matched |
| 102 | capture | 01a1ac53-aa0e-7ee7-92c3-7b151634414f | €35.00 | €0.50 | matched |
| 103 | capture | 01a1ac53-b409-73c8-9c35-b3edf56ede32 | €15.00 | €0.26 | matched |
| 104 | capture | 01a1ac53-d504-7399-bf6e-22110e6de7f9 | €24.00 | €0.37 | matched |
| 105 | capture | 01a1ac53-e495-714e-b688-140d5f20dc0a | €24.00 | €0.37 | matched |
| 106 | capture | 01a1ac54-01fa-7a63-b5cf-1bb55a869158 | €24.00 | €0.37 | matched |
| 107 | capture | 01a1ac54-083d-7cd5-a7a8-fa49080d1fa3 | €35.00 | €0.50 | matched |
| 108 | capture | 01a1ac54-14e9-7814-abd3-1c0854865050 | €24.00 | €0.37 | matched |
| 109 | refund | 01a1ac54-1ce9-7204-9dae-9635d5978b77 | -€17.00 | €0.00 | matched |
| 110 | refund | 01a1ac54-4de4-7fd0-8ca7-283af1501d6f | -€13.00 | €0.00 | matched |
| 112 | capture | 01a1ac54-4f70-710d-96ed-62ac7c8ddd40 | €49.00 | €0.67 | matched |
| 113 | capture | 01a1ac54-560d-7b62-afee-de0276af8ca8 | €35.00 | €0.50 | matched |
| 114 | capture | 01a1ac54-7492-7db8-a814-4889bbdff269 | €49.00 | €0.67 | matched |
| 115 | capture | 01a1ac54-772f-7740-85b7-6375c2f3964c | €9.00 | €0.19 | matched |
| 116 | capture | 01a1ac54-942e-7db3-b6ff-49b462716ed3 | €15.00 | €0.26 | matched |
| 117 | capture | 01a1ac54-ba1e-7b0c-8143-64625fa34c8d | €15.00 | €0.26 | matched |
| 118 | capture | 01a1ac54-bb50-768a-90c7-aefd5d9e2073 | €49.00 | €0.67 | matched |
| 119 | capture | 01a1ac54-c569-7a38-abdc-7440a0b07448 | €9.00 | €0.19 | matched |