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
- 20 Oct, 16:00132 lines3 breaks
- 20 Oct, 15:50125 lines1 break
- 20 Oct, 15:40109 linesclean
- 20 Oct, 15:3094 lines5 breaks
- 20 Oct, 15:20121 lines1 break
- 20 Oct, 15:10131 lines1 break
- 20 Oct, 15:00129 lines3 breaks
- 20 Oct, 14:50121 lines4 breaks
- 20 Oct, 14:40117 lines2 breaks
- 20 Oct, 14:30130 lines1 break
- 20 Oct, 14:20123 lines1 break
- 20 Oct, 14:10135 lines2 breaks
- 20 Oct, 14:00119 lines2 breaks
- 20 Oct, 13:50139 lines3 breaks
20 Oct, 14:40
Gross
€2,635.00
PSP fee
€42.32
Net to the bank
€2,592.68
Settlement journal
#106999
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a159c6-2efc-7e24-aaeb-264de175a1ec is already settled by stl_EUR_2987512 line 59
- missing linein the books, not in the filecapture:01a159c5-afec-781a-a1d3-13fc725d1456 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 60 | capture | 01a159c6-2f23-7710-9e99-359ab7f4d3b5 | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a159bb-0571-7076-ad02-cddc673b97f6 | €15.00 | €0.26 | matched |
| 2 | capture | 01a159bf-e8bc-77f7-a816-3e2ee997ec6e | €15.00 | €0.26 | matched |
| 3 | capture | 01a159c0-8a1c-715c-94ea-c7a5521ecbc1 | €9.00 | €0.19 | matched |
| 4 | capture | 01a159c0-99cf-7c53-857b-093087ec02a8 | €9.00 | €0.19 | matched |
| 5 | capture | 01a159c1-7101-78da-a22b-7d8a29a3ed23 | €49.00 | €0.67 | matched |
| 6 | capture | 01a159c1-7de6-79c2-8cf2-70716406a92b | €15.00 | €0.26 | matched |
| 7 | capture | 01a159c1-9741-76e9-b900-01e829c290b5 | €15.00 | €0.26 | matched |
| 8 | refund | 01a159c1-9a51-77f6-9174-5743d290443e | -€27.00 | €0.00 | matched |
| 9 | capture | 01a159c1-c099-70f9-9d11-b014e62df049 | €15.00 | €0.26 | matched |
| 10 | capture | 01a159c1-c265-7a0e-ab61-946b356b405c | €49.00 | €0.67 | matched |
| 11 | capture | 01a159c2-0a1d-79b6-9b7f-3e9f4e7c4fb8 | €24.00 | €0.37 | matched |
| 12 | capture | 01a159c2-2767-7a6e-9423-bfcffef12f1f | €9.00 | €0.19 | matched |
| 13 | capture | 01a159c2-3851-78d9-ae4c-0c4c46b6feaf | €49.00 | €0.67 | matched |
| 14 | capture | 01a159c2-4a62-76e5-b70c-3e0a9a63eb56 | €15.00 | €0.26 | matched |
| 15 | capture | 01a159c2-57b1-7104-8b56-bfc985a6887e | €35.00 | €0.50 | matched |
| 16 | capture | 01a159c2-5feb-7a72-be3f-97ea0b042a2f | €35.00 | €0.50 | matched |
| 17 | capture | 01a159c2-659a-7208-91bd-ab2ccae70343 | €49.00 | €0.67 | matched |
| 18 | capture | 01a159c2-6fd5-7a6a-ba4a-8b3950752361 | €9.00 | €0.19 | matched |
| 19 | capture | 01a159c2-80c6-7b67-8131-cb6bca626091 | €49.00 | €0.67 | matched |
| 20 | capture | 01a159c2-7dac-7c41-b4de-08a7ba30b2f8 | €35.00 | €0.50 | matched |
| 21 | capture | 01a159c2-a3e5-724d-8698-d3c9fc9e2b07 | €9.00 | €0.19 | matched |
| 22 | capture | 01a159c2-b30b-78e3-92e9-3954379f9301 | €15.00 | €0.26 | matched |
| 23 | capture | 01a159c2-c1cc-7d67-9be5-32f01cad02f5 | €15.00 | €0.26 | matched |
| 24 | capture | 01a159c2-d7cf-7a76-abf8-bdb5ac867fc2 | €24.00 | €0.37 | matched |
| 25 | refund | 01a159c2-cf6d-7f3a-8314-da04c66fa865 | -€34.00 | €0.00 | matched |
| 26 | capture | 01a159c2-fb1d-7299-b3a5-602d37c49404 | €35.00 | €0.50 | matched |
| 27 | capture | 01a159c3-2369-77e5-8537-24040263a53a | €35.00 | €0.50 | matched |
| 28 | capture | 01a159c3-3c58-7cf8-bcb4-3cad266b7672 | €9.00 | €0.19 | matched |
| 29 | capture | 01a159c3-55c8-70c4-b168-f652eac4be45 | €15.00 | €0.26 | matched |
| 30 | capture | 01a159c3-631d-7f80-a950-7da4d443c3d3 | €49.00 | €0.67 | matched |
| 31 | capture | 01a159c3-a3b7-7055-a04d-293c248cff79 | €15.00 | €0.26 | matched |
| 32 | capture | 01a159c4-04bd-7ce6-8b95-d05e529b2c3d | €9.00 | €0.19 | matched |
| 33 | capture | 01a159c4-066f-7806-9799-bf7f4159723a | €24.00 | €0.37 | matched |
| 34 | capture | 01a159c4-4dfd-7e9c-86af-2184a7c4083e | €24.00 | €0.37 | matched |
| 35 | capture | 01a159c4-5539-7446-af05-46e7aa478b93 | €15.00 | €0.26 | matched |
| 36 | capture | 01a159c4-5c43-7ff0-ab8b-931ffcf1a2e1 | €35.00 | €0.50 | matched |
| 37 | capture | 01a159c4-60ac-70b4-aabe-820f6cfbb6fb | €49.00 | €0.67 | matched |
| 38 | capture | 01a159c4-8c90-704b-8b95-4aa426228733 | €35.00 | €0.50 | matched |
| 39 | capture | 01a159c4-b4a8-7361-8f2d-aabc7c986ac2 | €9.00 | €0.19 | matched |
| 40 | capture | 01a159c4-ba64-7a75-8698-af7963a45dc6 | €9.00 | €0.19 | matched |
| 41 | capture | 01a159c4-bcb0-7786-a2d7-1b2ab234926a | €24.00 | €0.37 | matched |
| 42 | capture | 01a159c4-c072-7828-b2da-c0f8c6a9e832 | €9.00 | €0.19 | matched |
| 43 | capture | 01a159c4-e51e-79b1-b1e0-58157586d025 | €49.00 | €0.67 | matched |
| 44 | capture | 01a159c4-e940-7401-a9b5-79a037e55786 | €9.00 | €0.19 | matched |
| 45 | capture | 01a159c5-0a03-78bc-bd03-25edaa6827d4 | €15.00 | €0.26 | matched |
| 46 | capture | 01a159c5-0bda-756b-89e3-c72da829177c | €9.00 | €0.19 | matched |
| 47 | capture | 01a159c5-1785-73fd-93a8-c0eb0dcb79c3 | €49.00 | €0.67 | matched |
| 48 | capture | 01a159c5-20ac-73f4-a43a-c9093bb31053 | €15.00 | €0.26 | matched |
| 49 | capture | 01a159c5-48c5-71a4-a9a2-12fe3df0c239 | €9.00 | €0.19 | matched |
| 50 | capture | 01a159c5-5294-71cf-b8f2-410c8b7acb6a | €24.00 | €0.37 | matched |
| 51 | capture | 01a159c5-5654-70e1-9f88-9049e5c5ef58 | €24.00 | €0.37 | matched |
| 52 | capture | 01a159c5-59be-70ff-8358-aef31f579231 | €49.00 | €0.67 | matched |
| 53 | capture | 01a159c5-7b8e-72fa-9fd2-be8e21d72341 | €35.00 | €0.50 | matched |
| 54 | capture | 01a159c5-92ea-7508-a3f1-d3e55df1e21b | €35.00 | €0.50 | matched |
| 55 | capture | 01a159c5-99e5-712c-bb2f-18868d0980cd | €9.00 | €0.19 | matched |
| 56 | capture | 01a159c5-bd86-7bf8-bfa6-f9165f3ba9ca | €49.00 | €0.67 | matched |
| 57 | refund | 01a159c5-ec64-7127-ab7b-e335c550332b | -€6.00 | €0.00 | matched |
| 58 | capture | 01a159c5-f01e-793d-b0ec-8d08496808a9 | €9.00 | €0.19 | matched |
| 59 | capture | 01a159c6-2f23-7710-9e99-359ab7f4d3b5 | €49.00 | €0.67 | matched |
| 61 | capture | 01a159c6-5079-7bb3-85d2-b7e2dd633325 | €15.00 | €0.26 | matched |
| 62 | capture | 01a159c6-8e84-70c4-98b1-bfe0ca7f16a2 | €24.00 | €0.37 | matched |
| 63 | capture | 01a159c6-d2fd-746a-a517-c426474caa6b | €9.00 | €0.19 | matched |
| 64 | capture | 01a159c6-d4e5-7180-b662-406294cb9c7e | €15.00 | €0.26 | matched |
| 65 | capture | 01a159c6-dec0-7750-8884-534e370f50ef | €24.00 | €0.37 | matched |
| 66 | capture | 01a159c6-e9c9-7600-ba65-ba89a0a17237 | €24.00 | €0.37 | matched |
| 67 | refund | 01a159c7-07db-731c-b584-d8fa335e4b5c | -€10.00 | €0.00 | matched |
| 68 | capture | 01a159c7-1230-7d44-a707-f61d2f5452f9 | €35.00 | €0.50 | matched |
| 69 | capture | 01a159c7-2275-7315-8ee5-bbbcccd73560 | €15.00 | €0.26 | matched |
| 70 | capture | 01a159c7-30d2-70a5-b4de-15678cc4de1d | €35.00 | €0.50 | matched |
| 71 | refund | 01a159c7-37f3-7a51-a573-ce16b6dac313 | -€23.00 | €0.00 | matched |
| 72 | capture | 01a159c7-4361-785d-a3ae-61ce06b76bfa | €49.00 | €0.67 | matched |
| 73 | capture | 01a159c7-62fb-7578-b52d-75308e07b5bd | €35.00 | €0.50 | matched |
| 74 | refund | 01a159c7-7544-78fc-b85a-da9f8d06956a | -€43.00 | €0.00 | matched |
| 75 | capture | 01a159c7-b6d7-7cbf-ba37-087d794490f5 | €35.00 | €0.50 | matched |
| 76 | capture | 01a159c7-e032-70ec-b326-36fe89c21261 | €24.00 | €0.37 | matched |
| 77 | capture | 01a159c7-fc1a-7742-9b78-a478efeb47d9 | €15.00 | €0.26 | matched |
| 78 | capture | 01a159c8-09a1-7331-8636-85959c1302bd | €15.00 | €0.26 | matched |
| 79 | capture | 01a159c8-3408-7e53-941f-da69d2e2bd6f | €24.00 | €0.37 | matched |
| 80 | capture | 01a159c8-34d5-71a5-8f86-4bf08acdcf10 | €15.00 | €0.26 | matched |
| 81 | capture | 01a159c8-88c7-7c4b-b54c-831a659b8b27 | €35.00 | €0.50 | matched |
| 82 | capture | 01a159c8-9c62-76cd-8f7e-fa9b713662c3 | €24.00 | €0.37 | matched |
| 83 | capture | 01a159c8-a260-7a38-92bb-53c1265a1328 | €9.00 | €0.19 | matched |
| 84 | capture | 01a159c8-b8f2-709e-8867-cc676995063b | €9.00 | €0.19 | matched |
| 85 | capture | 01a159c8-ca98-7dbc-891c-3cadc90d5011 | €9.00 | €0.19 | matched |
| 86 | capture | 01a159c8-e95c-7553-82fb-bd7b4d3134e9 | €24.00 | €0.37 | matched |
| 87 | capture | 01a159c8-eac2-76ff-9006-c0a5631e0e32 | €35.00 | €0.50 | matched |
| 88 | capture | 01a159c8-eda4-78b8-a836-3581cfffac88 | €49.00 | €0.67 | matched |
| 89 | capture | 01a159c8-ef71-7520-a280-687a74250ec0 | €24.00 | €0.37 | matched |
| 90 | capture | 01a159c8-f524-7dad-946c-8d6735654792 | €49.00 | €0.67 | matched |
| 91 | capture | 01a159c9-0710-75ae-be97-0d266fb9e192 | €15.00 | €0.26 | matched |
| 92 | refund | 01a159c9-0db5-7324-b119-231561933d3d | -€5.00 | €0.00 | matched |
| 93 | capture | 01a159c9-1b3e-7bd1-96c8-5bc2e5594bad | €35.00 | €0.50 | matched |
| 94 | capture | 01a159c9-22ba-76b7-bd29-ba58f93de5b8 | €24.00 | €0.37 | matched |
| 95 | capture | 01a159c9-2726-7d7c-af52-7c95fcf4c293 | €15.00 | €0.26 | matched |
| 96 | capture | 01a159c9-38de-79d6-b4b9-5ad8a429bf06 | €24.00 | €0.37 | matched |
| 97 | capture | 01a159c9-5a33-740c-a00c-ff090ed28c17 | €49.00 | €0.67 | matched |
| 98 | capture | 01a159c9-671f-7334-b3a9-a744d38c5146 | €15.00 | €0.26 | matched |
| 99 | capture | 01a159c9-6ac2-7545-b4c6-408527bca512 | €24.00 | €0.37 | matched |
| 100 | capture | 01a159c9-6b5f-7e9f-9af5-a02c277233d6 | €24.00 | €0.37 | matched |
| 101 | capture | 01a159c9-77fd-75be-a59c-f4506244d086 | €15.00 | €0.26 | matched |
| 102 | capture | 01a159c9-8581-7e88-9f24-32090c74bff8 | €24.00 | €0.37 | matched |
| 103 | capture | 01a159c9-9335-7ab1-a912-03887b90d72c | €24.00 | €0.37 | matched |
| 104 | capture | 01a159c9-9f35-7d5d-b7bb-d1ce463ff9de | €15.00 | €0.26 | matched |
| 105 | capture | 01a159c9-a5ca-7158-99ab-01ac33a7d8fa | €15.00 | €0.26 | matched |
| 106 | capture | 01a159c9-af12-7f09-9bf8-a83d5f6b554f | €35.00 | €0.50 | matched |
| 107 | capture | 01a159c9-de43-7128-9ed1-3ddd47cf773a | €35.00 | €0.50 | matched |
| 108 | capture | 01a159c9-dfa1-7eda-9225-d1132b4654dd | €9.00 | €0.19 | matched |
| 109 | capture | 01a159c9-de2d-71db-bff4-f4dd5749dbaf | €49.00 | €0.67 | matched |
| 110 | capture | 01a159c9-f138-70a9-9c21-12c56592df56 | €35.00 | €0.50 | matched |
| 111 | capture | 01a159c9-f9c7-78d6-9a07-c21d20d5dd34 | €35.00 | €0.50 | matched |
| 112 | capture | 01a159ca-0c52-75a6-8ff2-f2787fd47926 | €35.00 | €0.50 | matched |
| 113 | capture | 01a159ca-1aae-735e-ac5f-a337757b7b37 | €9.00 | €0.19 | matched |
| 114 | capture | 01a159ca-1ecd-77e8-9de6-2de80a67032d | €24.00 | €0.37 | matched |
| 115 | capture | 01a159ca-3a61-7dca-ac12-f69332d69bed | €15.00 | €0.26 | matched |
| 116 | capture | 01a159ca-3ee3-7bab-a6cf-1c3dabca736d | €24.00 | €0.37 | matched |
| 117 | capture | 01a159ca-6938-7eac-be0d-792893ede35e | €35.00 | €0.50 | matched |