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
- 6 Nov, 00:30112 lines2 breaks
- 6 Nov, 00:20147 lines3 breaks
- 6 Nov, 00:10118 lines4 breaks
- 6 Nov, 00:00158 lines3 breaks
- 5 Nov, 23:50126 lines4 breaks
- 5 Nov, 23:4097 lines3 breaks
- 5 Nov, 23:30109 lines3 breaks
- 5 Nov, 23:20106 lines3 breaks
- 5 Nov, 23:10122 lines4 breaks
- 5 Nov, 23:00100 lines2 breaks
- 5 Nov, 22:50122 lines6 breaks
- 5 Nov, 22:40121 lines5 breaks
- 5 Nov, 22:30130 lines3 breaks
- 5 Nov, 22:20120 lines2 breaks
5 Nov, 22:40
Gross
€2,554.00
PSP fee
€42.18
Net to the bank
€2,511.82
Settlement journal
#405390
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a1ade2-5ff2-7eaa-9dfa-8f98e5d08cbf is already settled by stl_EUR_2989864 line 49
- duplicate linethe file lists it twicecapture:01a1ade1-5793-71ff-81d5-3fb37e924a74 is already settled by stl_EUR_2989865 line 1
- duplicate linethe file lists it twicecapture:01a1ade7-037e-71aa-bc85-30adc64f8185 is already settled by stl_EUR_2989865 line 5
- fee differencethe fee is not the contract feethe fee is 40, the contract says 37
- missing linein the books, not in the filecapture:01a1ade2-5702-70d9-8b4d-fbd1d3dfe9d0 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 10 | capture | 01a1adde-cedf-7097-86c6-a770c4b7478c | €24.00 | €0.40 | fee difference |
| 50 | refund | 01a1ade2-5ff5-7ece-bec0-adbb89fc9479 | -€30.00 | €0.00 | duplicate line |
| 1 | capture | 01a1add5-5b28-7c87-85b4-0491bca286d3 | €15.00 | €0.26 | matched |
| 2 | capture | 01a1adda-4ecb-7431-a457-904388f87371 | €24.00 | €0.37 | matched |
| 3 | capture | 01a1adde-7a97-79bb-ab93-a25ad57515f2 | €49.00 | €0.67 | matched |
| 4 | capture | 01a1adde-8771-72c9-8128-52adb786abec | €15.00 | €0.26 | matched |
| 5 | capture | 01a1adde-986e-74bb-a058-83763ed1fc84 | €9.00 | €0.19 | matched |
| 6 | capture | 01a1adde-9940-7fc9-8a1b-894401ca6e8f | €35.00 | €0.50 | matched |
| 7 | capture | 01a1adde-a06e-78f0-8886-9e3cc11b5b5e | €24.00 | €0.37 | matched |
| 8 | capture | 01a1adde-ab0d-744a-832c-c827e7072879 | €49.00 | €0.67 | matched |
| 9 | capture | 01a1adde-ca8c-76ac-99e2-78b243ddb04e | €9.00 | €0.19 | matched |
| 11 | capture | 01a1adde-d059-7173-8cdf-598904224411 | €35.00 | €0.50 | matched |
| 12 | capture | 01a1adde-f06e-7b09-ae16-993e8ed00594 | €49.00 | €0.67 | matched |
| 13 | capture | 01a1addf-00d9-733a-ad3d-951fdce50402 | €15.00 | €0.26 | matched |
| 14 | capture | 01a1addf-4831-7fcd-b4a2-77cdf0825995 | €9.00 | €0.19 | matched |
| 15 | capture | 01a1addf-4afc-7717-8b42-d7750bef2ddd | €35.00 | €0.50 | matched |
| 16 | capture | 01a1addf-6373-706c-80ff-b5ddd5ff1dd9 | €24.00 | €0.37 | matched |
| 17 | capture | 01a1addf-7dc8-7513-a92f-28a114ef0601 | €15.00 | €0.26 | matched |
| 18 | capture | 01a1addf-bee6-7cf3-af74-7a0223673cc8 | €49.00 | €0.67 | matched |
| 19 | capture | 01a1addf-c22f-75a2-a2ba-b9c33effe2da | €9.00 | €0.19 | matched |
| 20 | capture | 01a1addf-d57b-7005-9456-be8255babb80 | €9.00 | €0.19 | matched |
| 21 | refund | 01a1addf-f533-7e28-b12a-bade2c3b4bdf | -€29.00 | €0.00 | matched |
| 22 | capture | 01a1addf-f68e-72a9-96e0-245121c2eff6 | €49.00 | €0.67 | matched |
| 23 | capture | 01a1addf-fdde-7f21-b052-797c707ad0c7 | €15.00 | €0.26 | matched |
| 24 | capture | 01a1ade0-0939-7397-951f-4520edce2147 | €15.00 | €0.26 | matched |
| 25 | capture | 01a1ade0-3102-7d93-8214-3a0a9aeaa30e | €35.00 | €0.50 | matched |
| 26 | capture | 01a1ade0-3dee-79ca-b36f-c17c51e23ce3 | €9.00 | €0.19 | matched |
| 27 | capture | 01a1ade0-4ddf-7b4a-906a-17765ac199f9 | €15.00 | €0.26 | matched |
| 28 | capture | 01a1ade0-632a-7969-a87c-b0ac68cb41fe | €9.00 | €0.19 | matched |
| 29 | capture | 01a1ade0-8675-74b0-b8dc-eacdae4802c3 | €49.00 | €0.67 | matched |
| 30 | capture | 01a1ade0-c26d-7948-81e5-3e953ea80d74 | €9.00 | €0.19 | matched |
| 31 | capture | 01a1ade0-e34f-760d-bab2-0b1399431b89 | €49.00 | €0.67 | matched |
| 32 | capture | 01a1ade0-f644-7eed-8a37-6b99a53a27fb | €35.00 | €0.50 | matched |
| 33 | capture | 01a1ade0-f8fa-79b9-801b-617bd4edc5f7 | €49.00 | €0.67 | matched |
| 34 | capture | 01a1ade1-2d78-746f-b83d-bf6e5333dd40 | €15.00 | €0.26 | matched |
| 35 | capture | 01a1ade1-382a-751a-be83-e14b4baf6f1f | €24.00 | €0.37 | matched |
| 36 | refund | 01a1ade1-3b75-74af-bc24-3e667d849b3b | -€13.00 | €0.00 | matched |
| 37 | refund | 01a1ade1-67a6-7ecc-bc10-21a227320ccf | -€14.00 | €0.00 | matched |
| 38 | capture | 01a1ade1-6b29-7ce4-b7f7-b50044fcd009 | €24.00 | €0.37 | matched |
| 39 | capture | 01a1ade1-9034-7f76-b3b8-3d2fe33cba58 | €49.00 | €0.67 | matched |
| 40 | capture | 01a1ade1-94ad-7498-801e-f789b3cdadc2 | €9.00 | €0.19 | matched |
| 41 | capture | 01a1ade1-b5b5-7741-8dab-46d3763c8e8b | €15.00 | €0.26 | matched |
| 42 | capture | 01a1ade1-e55a-7cbd-aeed-f9938d772f19 | €9.00 | €0.19 | matched |
| 43 | capture | 01a1ade1-e5a2-710b-9889-9cb3e90451c4 | €15.00 | €0.26 | matched |
| 44 | capture | 01a1ade2-2b65-75eb-ba24-2748e4be8ef2 | €35.00 | €0.50 | matched |
| 45 | capture | 01a1ade2-2bcb-76cc-b613-ad537ac4e6a7 | €24.00 | €0.37 | matched |
| 46 | capture | 01a1ade2-2fae-7f74-851e-463d2b6db01a | €35.00 | €0.50 | matched |
| 47 | capture | 01a1ade2-474c-7a35-8221-a9aa386a4742 | €15.00 | €0.26 | matched |
| 48 | capture | 01a1ade2-5670-7325-a4ba-cb5d684b16fd | €24.00 | €0.37 | matched |
| 49 | refund | 01a1ade2-5ff5-7ece-bec0-adbb89fc9479 | -€30.00 | €0.00 | matched |
| 51 | capture | 01a1ade2-72fd-77a1-8b5d-77d9d54ebab7 | €35.00 | €0.50 | matched |
| 52 | capture | 01a1ade2-8014-7d9f-bd7b-051f8a99e5b4 | €35.00 | €0.50 | matched |
| 53 | capture | 01a1ade2-bc32-7988-be3d-b3344100a3c5 | €15.00 | €0.26 | matched |
| 54 | capture | 01a1ade2-d74a-703c-a1db-d58258f21da6 | €9.00 | €0.19 | matched |
| 55 | capture | 01a1ade2-e423-7f05-b137-38fa141f0805 | €15.00 | €0.26 | matched |
| 56 | capture | 01a1ade2-f3c1-769f-a3e5-7b5ce8ad4da9 | €49.00 | €0.67 | matched |
| 57 | capture | 01a1ade3-03c8-7dea-9968-92315dda5ebe | €15.00 | €0.26 | matched |
| 58 | capture | 01a1ade3-1bd3-79f5-b3ce-eb32ea274a6a | €24.00 | €0.37 | matched |
| 59 | capture | 01a1ade3-0c8e-7fd9-8b22-f3f111f0a2a1 | €49.00 | €0.67 | matched |
| 60 | refund | 01a1ade3-3b9d-7eee-a85f-999b729ff7aa | -€7.00 | €0.00 | matched |
| 61 | capture | 01a1ade3-4cf9-7742-bc9f-317acc4694a9 | €35.00 | €0.50 | matched |
| 62 | capture | 01a1ade3-502a-72cc-b2ea-b0a3e80864ca | €24.00 | €0.37 | matched |
| 63 | capture | 01a1ade3-69e4-72ce-bbcd-0114daa0deef | €35.00 | €0.50 | matched |
| 64 | capture | 01a1ade3-6ddf-7503-8bfb-0f36228bfee2 | €15.00 | €0.26 | matched |
| 65 | capture | 01a1ade3-97c2-74e2-af5c-802c475b3c0f | €35.00 | €0.50 | matched |
| 66 | capture | 01a1ade3-9f81-79ca-883b-462d39beefa3 | €24.00 | €0.37 | matched |
| 67 | capture | 01a1ade3-a4f7-7e19-a3ba-7ced16e19cfb | €49.00 | €0.67 | matched |
| 68 | capture | 01a1ade3-b676-7344-b6b8-b9565216a2ab | €35.00 | €0.50 | matched |
| 69 | capture | 01a1ade3-c07d-7b2f-99a0-b02f3c01cd13 | €24.00 | €0.37 | matched |
| 70 | capture | 01a1ade3-c8d6-79e2-bc7e-c8338c641904 | €9.00 | €0.19 | matched |
| 71 | capture | 01a1ade3-cd57-7d2f-8cc7-6166d66ee641 | €49.00 | €0.67 | matched |
| 72 | refund | 01a1ade3-eb40-7689-9864-fc574156cc78 | -€21.00 | €0.00 | matched |
| 73 | capture | 01a1ade3-f419-7685-84cb-5c3871884c44 | €15.00 | €0.26 | matched |
| 74 | capture | 01a1ade3-f53a-7d43-a822-c179a8806152 | €24.00 | €0.37 | matched |
| 75 | refund | 01a1ade3-f732-7f54-931b-b478ca833b06 | -€31.00 | €0.00 | matched |
| 76 | capture | 01a1ade3-ff16-785f-95f7-a73dafab8090 | €49.00 | €0.67 | matched |
| 77 | capture | 01a1ade4-198a-738a-bb81-f90b2b992b25 | €9.00 | €0.19 | matched |
| 78 | capture | 01a1ade4-2840-7829-9e56-9b7e8406fecc | €15.00 | €0.26 | matched |
| 79 | capture | 01a1ade4-2962-73fd-b37b-57c0517ccb85 | €35.00 | €0.50 | matched |
| 80 | capture | 01a1ade4-2b66-734a-ab63-ba8eca8d611a | €9.00 | €0.19 | matched |
| 81 | capture | 01a1ade4-3923-7c17-905a-a588f72ee355 | €15.00 | €0.26 | matched |
| 82 | refund | 01a1ade4-7062-743c-a918-944caf04d8d3 | -€6.00 | €0.00 | matched |
| 83 | capture | 01a1ade4-9e43-7ce0-8728-142802af959b | €9.00 | €0.19 | matched |
| 84 | capture | 01a1ade4-ec04-73c2-9f37-fcf0f0a577f3 | €24.00 | €0.37 | matched |
| 85 | capture | 01a1ade4-f026-779b-99e4-dddcd10e4dd0 | €9.00 | €0.19 | matched |
| 86 | capture | 01a1ade5-094d-78f7-9647-2d355bd1cd3c | €15.00 | €0.26 | matched |
| 87 | capture | 01a1ade5-235c-7fee-8284-0f8485ae6b75 | €49.00 | €0.67 | matched |
| 88 | capture | 01a1ade5-3053-7a71-b020-4c4cce8830cf | €24.00 | €0.37 | matched |
| 89 | capture | 01a1ade5-34a0-70bb-abbf-cac5eb4b44a2 | €49.00 | €0.67 | matched |
| 90 | capture | 01a1ade5-3ffc-7f9a-ba64-877eb644b67d | €35.00 | €0.50 | matched |
| 91 | capture | 01a1ade5-4001-7854-ad10-d8ca744f377e | €9.00 | €0.19 | matched |
| 92 | capture | 01a1ade5-5fc8-782e-a82c-dc3a8d8c15f3 | €9.00 | €0.19 | matched |
| 93 | capture | 01a1ade5-776a-7f8e-901e-bc7e87522a53 | €49.00 | €0.67 | matched |
| 94 | capture | 01a1ade5-8756-7c2a-b469-fe7b6d4137be | €9.00 | €0.19 | matched |
| 95 | capture | 01a1ade5-8aee-7974-acc7-80fafffd7228 | €24.00 | €0.37 | matched |
| 96 | capture | 01a1ade5-956f-7f8d-8a2c-388ff3a9bb6c | €9.00 | €0.19 | matched |
| 97 | refund | 01a1ade5-9797-709b-a5f5-24fe7f18746b | -€18.00 | €0.00 | matched |
| 98 | capture | 01a1ade5-a142-7878-aac2-e077d2676c8d | €15.00 | €0.26 | matched |
| 99 | capture | 01a1ade5-a31e-7583-9086-6bd8247a290f | €35.00 | €0.50 | matched |
| 100 | capture | 01a1ade5-fabc-7a8b-8432-673b8c18d9fc | €49.00 | €0.67 | matched |
| 101 | capture | 01a1ade6-0ddd-7a6e-b697-00939cb856a3 | €24.00 | €0.37 | matched |
| 102 | capture | 01a1ade6-13b1-77d7-b482-d73a8c7cbaed | €9.00 | €0.19 | matched |
| 103 | capture | 01a1ade6-2bb1-7e9e-a64a-e33ee5dffed7 | €24.00 | €0.37 | matched |
| 104 | capture | 01a1ade6-53fc-72b8-bb72-51a627bbf657 | €35.00 | €0.50 | matched |
| 105 | capture | 01a1ade6-5e2b-7c47-92b1-d40b1fb74027 | €15.00 | €0.26 | matched |
| 106 | refund | 01a1ade6-61d9-70d3-8683-30faca295316 | -€14.00 | €0.00 | matched |
| 107 | capture | 01a1ade6-75bb-7d36-b85a-d177efa45a0c | €9.00 | €0.19 | matched |
| 108 | capture | 01a1ade6-847d-720d-bf5e-e738735c797d | €9.00 | €0.19 | matched |
| 109 | capture | 01a1ade6-aea7-79cf-82a8-7ca81218125b | €24.00 | €0.37 | matched |
| 110 | refund | 01a1ade6-c834-7d9e-962f-5d54d0a085c3 | -€8.00 | €0.00 | matched |
| 111 | capture | 01a1ade6-f903-7385-9b48-2418799ab85b | €49.00 | €0.67 | matched |
| 112 | capture | 01a1ade7-2cfe-74f8-af5a-6ccccff158a5 | €24.00 | €0.37 | matched |
| 113 | capture | 01a1ade7-3f68-7501-9c81-4cccbacd4776 | €24.00 | €0.37 | matched |
| 114 | capture | 01a1ade7-549e-7200-b5a3-50721f5c19ba | €49.00 | €0.67 | matched |
| 115 | capture | 01a1ade7-558b-739f-b2d2-d35fdda4a481 | €35.00 | €0.50 | matched |
| 116 | capture | 01a1ade7-7909-7fe5-b820-d049ca1bcb00 | €15.00 | €0.26 | matched |
| 117 | capture | 01a1ade7-8552-78b5-87e7-b79a58dc744d | €35.00 | €0.50 | matched |
| 118 | capture | 01a1ade7-8d1d-7ff8-a6ac-96c36c4f2fce | €35.00 | €0.50 | matched |
| 119 | capture | 01a1ade7-9421-7fb3-888e-00655e9d5370 | €24.00 | €0.37 | matched |
| 120 | capture | 01a1ade7-9a48-70b0-9403-f504284d3417 | €15.00 | €0.26 | matched |
| 121 | capture | 01a1ade7-9ce6-7a1f-b145-a74ca478e5cd | €15.00 | €0.26 | matched |