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
- 27 Oct, 13:00134 lines3 breaks
- 27 Oct, 12:50128 lines1 break
- 27 Oct, 12:40123 lines4 breaks
- 27 Oct, 12:30152 lines1 break
- 27 Oct, 12:20122 lines1 break
- 27 Oct, 12:10140 lines1 break
- 27 Oct, 12:00122 lines1 break
- 27 Oct, 11:50114 lines2 breaks
- 27 Oct, 11:40124 lines1 break
- 27 Oct, 11:30131 linesclean
- 27 Oct, 11:20120 lines5 breaks
- 27 Oct, 11:10125 lines3 breaks
- 27 Oct, 11:00108 lines1 break
- 27 Oct, 10:50138 lines1 break
27 Oct, 11:50
Gross
€2,526.00
PSP fee
€40.44
Net to the bank
€2,485.56
Settlement journal
#232478
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a17d38-295a-7e32-8550-4cf3f169a3cc is already settled by stl_EUR_2988503 line 78
- missing linein the books, not in the filecapture:01a17d39-6443-7c10-b14c-817ad100e042 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 79 | capture | 01a17d38-2a33-7623-afa6-4b04370407b0 | €15.00 | €0.26 | duplicate line |
| 1 | capture | 01a17d2d-e9a9-7055-a584-557fdb76d33b | €15.00 | €0.26 | matched |
| 2 | capture | 01a17d32-5061-70b3-a704-48b664fea5ff | €35.00 | €0.50 | matched |
| 3 | capture | 01a17d32-58ce-7102-b1d4-915ebcdb2ab8 | €35.00 | €0.50 | matched |
| 4 | capture | 01a17d32-5ab6-7e2a-95a6-79f87780f774 | €24.00 | €0.37 | matched |
| 5 | capture | 01a17d32-8540-70e6-a458-1e2a75efc3dc | €24.00 | €0.37 | matched |
| 6 | capture | 01a17d32-aed9-7670-a4fa-c22b16a2fea2 | €24.00 | €0.37 | matched |
| 7 | capture | 01a17d32-dec1-736f-8d3b-e1f77d3b0a50 | €9.00 | €0.19 | matched |
| 8 | capture | 01a17d33-0953-7e5d-aa96-732b8a9ad42a | €49.00 | €0.67 | matched |
| 9 | capture | 01a17d33-1c16-7929-a355-6cd8ddedde14 | €15.00 | €0.26 | matched |
| 10 | capture | 01a17d33-25b4-72c8-837a-5036ececd514 | €15.00 | €0.26 | matched |
| 11 | capture | 01a17d33-3110-7e6c-8683-d5ffdd805fb7 | €15.00 | €0.26 | matched |
| 12 | capture | 01a17d33-8b90-739f-b5ce-6915aea128c8 | €9.00 | €0.19 | matched |
| 13 | capture | 01a17d33-a083-7713-b6b7-15eb6909a063 | €24.00 | €0.37 | matched |
| 14 | capture | 01a17d33-b3f6-7f35-a9e1-70373a19624d | €9.00 | €0.19 | matched |
| 15 | capture | 01a17d33-bb17-7aa0-99a3-105617013474 | €9.00 | €0.19 | matched |
| 16 | capture | 01a17d33-b3e6-71c1-b1b2-fcdebfa32eca | €49.00 | €0.67 | matched |
| 17 | capture | 01a17d33-d9fd-7c32-adc1-232cce2b20a1 | €35.00 | €0.50 | matched |
| 18 | capture | 01a17d33-e782-72e7-aa3a-6c328044b394 | €35.00 | €0.50 | matched |
| 19 | capture | 01a17d33-e801-7226-99f4-71ed32413847 | €9.00 | €0.19 | matched |
| 20 | capture | 01a17d33-f36d-761a-ab5d-460f2a934a35 | €24.00 | €0.37 | matched |
| 21 | capture | 01a17d33-f79d-7057-a1ef-6a381be0fa81 | €35.00 | €0.50 | matched |
| 22 | capture | 01a17d33-e9a8-7822-9f06-75b1d43c6e92 | €49.00 | €0.67 | matched |
| 23 | capture | 01a17d34-00b6-75c2-b6e0-cb69ccf9cc43 | €49.00 | €0.67 | matched |
| 24 | capture | 01a17d34-101b-784f-a3b4-27b642ddd726 | €35.00 | €0.50 | matched |
| 25 | refund | 01a17d34-1c34-7c94-a518-a065bd545c62 | -€27.00 | €0.00 | matched |
| 26 | capture | 01a17d34-2cc9-71cf-8c3b-03f67e56b60f | €49.00 | €0.67 | matched |
| 27 | capture | 01a17d34-2ef2-7d8c-9f21-48cbfd295c0c | €9.00 | €0.19 | matched |
| 28 | capture | 01a17d34-3621-7184-8a17-8563e70a0500 | €15.00 | €0.26 | matched |
| 29 | capture | 01a17d34-3917-7d85-8037-1e14931f15c8 | €9.00 | €0.19 | matched |
| 30 | capture | 01a17d34-6190-7820-9ce9-30f242e184fa | €35.00 | €0.50 | matched |
| 31 | capture | 01a17d34-6494-7765-8b9d-89b7367b2a2c | €35.00 | €0.50 | matched |
| 32 | refund | 01a17d34-655b-7f41-8ea9-99ad602e9014 | -€7.00 | €0.00 | matched |
| 33 | refund | 01a17d34-7ca2-7299-b449-208b10f20497 | -€8.00 | €0.00 | matched |
| 34 | capture | 01a17d34-9c66-727d-96ed-335fe605edf6 | €49.00 | €0.67 | matched |
| 35 | capture | 01a17d34-b31d-7752-a11c-d2b345715137 | €9.00 | €0.19 | matched |
| 36 | capture | 01a17d34-ba35-7f05-85cd-41d9c2940879 | €24.00 | €0.37 | matched |
| 37 | capture | 01a17d34-d516-7a29-aa00-b581f6da9121 | €35.00 | €0.50 | matched |
| 38 | capture | 01a17d34-eae2-7961-9eda-a83642c2b4fe | €15.00 | €0.26 | matched |
| 39 | capture | 01a17d34-ec2c-76ba-832b-4b24824302f3 | €35.00 | €0.50 | matched |
| 40 | capture | 01a17d34-f4cf-76ff-bfee-d6c662a6208d | €24.00 | €0.37 | matched |
| 41 | capture | 01a17d34-f879-724c-90ad-0d67c66d9ce4 | €9.00 | €0.19 | matched |
| 42 | capture | 01a17d35-1647-78fa-bd23-7be51ae94f59 | €35.00 | €0.50 | matched |
| 43 | capture | 01a17d35-22f6-762d-963b-c476f7a2d80b | €9.00 | €0.19 | matched |
| 44 | capture | 01a17d35-5a20-7f86-ae83-e70b2ab60072 | €15.00 | €0.26 | matched |
| 45 | capture | 01a17d35-5c29-7112-9d45-367eb5c2666c | €15.00 | €0.26 | matched |
| 46 | refund | 01a17d35-6256-75fe-a3f1-4ea6f14d0eb9 | -€5.00 | €0.00 | matched |
| 47 | capture | 01a17d35-76fe-75d4-94d8-2be087571de9 | €24.00 | €0.37 | matched |
| 48 | capture | 01a17d35-bcf6-7554-8d25-02aac080178d | €15.00 | €0.26 | matched |
| 49 | refund | 01a17d35-c0cc-7b5f-b694-dab7071a9cc4 | -€10.00 | €0.00 | matched |
| 50 | capture | 01a17d35-fda9-7f63-9d83-254e79d46a51 | €9.00 | €0.19 | matched |
| 51 | capture | 01a17d36-1e0a-7e8d-a607-0a88d2205804 | €35.00 | €0.50 | matched |
| 52 | capture | 01a17d36-2c4a-7ba8-a810-4f7f3c0d8224 | €15.00 | €0.26 | matched |
| 53 | capture | 01a17d36-3063-7bbe-b385-36b9ac8a6250 | €24.00 | €0.37 | matched |
| 54 | capture | 01a17d36-67bb-7226-99c6-d44e3ba4baf7 | €15.00 | €0.26 | matched |
| 55 | capture | 01a17d36-6a88-7a67-bbfb-3f177a509a9b | €49.00 | €0.67 | matched |
| 56 | capture | 01a17d36-7f15-77e6-9636-ec401be024d9 | €9.00 | €0.19 | matched |
| 57 | refund | 01a17d36-8de2-733d-bb07-304fd498b900 | -€8.00 | €0.00 | matched |
| 58 | capture | 01a17d36-ad4d-7fe4-9b8f-fcb5df05fd57 | €9.00 | €0.19 | matched |
| 59 | capture | 01a17d36-b2ef-7bc9-8383-1bf516fb6910 | €15.00 | €0.26 | matched |
| 60 | capture | 01a17d36-b616-78e1-a301-7967a81d27da | €9.00 | €0.19 | matched |
| 61 | capture | 01a17d37-0c3a-7177-8288-c9ee4df4e587 | €24.00 | €0.37 | matched |
| 62 | capture | 01a17d37-2192-75ff-92f2-f1a54984507a | €9.00 | €0.19 | matched |
| 63 | capture | 01a17d37-2ad2-7283-bcdf-67fb9db28260 | €9.00 | €0.19 | matched |
| 64 | capture | 01a17d37-2e0c-7b5a-b22f-d3d2ceb26fb5 | €9.00 | €0.19 | matched |
| 65 | capture | 01a17d37-452f-7cf9-be85-0e93719caf55 | €49.00 | €0.67 | matched |
| 66 | capture | 01a17d37-62a5-7cb4-9a48-d1dcf3dd66cd | €35.00 | €0.50 | matched |
| 67 | capture | 01a17d37-7efd-7590-a027-bd1263d568a2 | €15.00 | €0.26 | matched |
| 68 | refund | 01a17d37-8999-7f44-87db-ce90d1e05c44 | -€12.00 | €0.00 | matched |
| 69 | capture | 01a17d37-8a7d-7fc2-9303-0933f61f774d | €49.00 | €0.67 | matched |
| 70 | capture | 01a17d37-9cdb-75ae-9049-8d446b1c0dc4 | €49.00 | €0.67 | matched |
| 71 | capture | 01a17d37-e3d0-76f1-8fba-a7cf3e39dd11 | €15.00 | €0.26 | matched |
| 72 | capture | 01a17d38-150b-7a5b-9faa-24c6723bf6d5 | €15.00 | €0.26 | matched |
| 73 | capture | 01a17d38-18e1-7619-86b6-d100193a7310 | €9.00 | €0.19 | matched |
| 74 | capture | 01a17d38-196d-785f-a570-2b57160032ef | €24.00 | €0.37 | matched |
| 75 | refund | 01a17d38-21ff-71c8-9b6f-cdd49e4e85ad | -€10.00 | €0.00 | matched |
| 76 | capture | 01a17d38-26f5-72a5-acbf-c467d1deb16b | €35.00 | €0.50 | matched |
| 77 | capture | 01a17d38-28ef-7791-8f3e-6f1b8668ec7d | €35.00 | €0.50 | matched |
| 78 | capture | 01a17d38-2a33-7623-afa6-4b04370407b0 | €15.00 | €0.26 | matched |
| 80 | capture | 01a17d38-2f9a-7c3c-a3e0-8678157e4974 | €24.00 | €0.37 | matched |
| 81 | capture | 01a17d38-3e88-70eb-88f5-bccef9425351 | €24.00 | €0.37 | matched |
| 82 | capture | 01a17d38-b7d7-7409-9789-4ca218db8ddb | €24.00 | €0.37 | matched |
| 83 | capture | 01a17d38-c66c-740f-bb84-eb7e2ad85782 | €35.00 | €0.50 | matched |
| 84 | capture | 01a17d38-cbbe-7f4d-9aac-3755285e3494 | €35.00 | €0.50 | matched |
| 85 | capture | 01a17d38-dc99-7bb7-bbda-bdb35db12612 | €49.00 | €0.67 | matched |
| 86 | capture | 01a17d39-0a39-7b39-8287-d591b40349c6 | €49.00 | €0.67 | matched |
| 87 | capture | 01a17d39-242b-7029-bf06-1c021c879430 | €49.00 | €0.67 | matched |
| 88 | capture | 01a17d39-32e9-772f-8f47-9a93ff61fd05 | €9.00 | €0.19 | matched |
| 89 | capture | 01a17d39-4164-7dfd-90e1-b5f57ed49ffb | €49.00 | €0.67 | matched |
| 90 | refund | 01a17d39-456e-787a-8bc5-eb67dbe14462 | -€31.00 | €0.00 | matched |
| 91 | capture | 01a17d39-49f8-7dfa-ba73-03667de14fc5 | €15.00 | €0.26 | matched |
| 92 | capture | 01a17d39-5f6d-74dd-9226-10723bbc027e | €15.00 | €0.26 | matched |
| 93 | capture | 01a17d39-636f-7854-9be5-b1e437dd8498 | €49.00 | €0.67 | matched |
| 94 | capture | 01a17d39-6768-71d5-b922-c1ed99b8a462 | €9.00 | €0.19 | matched |
| 95 | refund | 01a17d39-94c7-7d7f-853c-e302dafb1f55 | -€4.00 | €0.00 | matched |
| 96 | capture | 01a17d39-9830-7dee-a00d-fd3645bf635b | €24.00 | €0.37 | matched |
| 97 | refund | 01a17d39-9e68-74b9-be34-4d231b835163 | -€11.00 | €0.00 | matched |
| 98 | capture | 01a17d39-dd52-74b0-8262-f2e282efbcdc | €35.00 | €0.50 | matched |
| 99 | capture | 01a17d39-e0ed-7bd8-8ae6-f7a9d686dce5 | €15.00 | €0.26 | matched |
| 100 | capture | 01a17d39-ef1c-7c83-8aab-02300426658d | €24.00 | €0.37 | matched |
| 101 | capture | 01a17d39-ff0c-7dd0-863c-c539d095b768 | €35.00 | €0.50 | matched |
| 102 | capture | 01a17d3a-0cb3-738d-b71f-69e75ef09683 | €24.00 | €0.37 | matched |
| 103 | capture | 01a17d3a-15ea-7299-97a0-9c4c52541d47 | €9.00 | €0.19 | matched |
| 104 | capture | 01a17d3a-491a-7f33-9acb-e3aaaebaf64f | €49.00 | €0.67 | matched |
| 105 | refund | 01a17d3a-4f90-73ba-a0a6-122db0c2507d | -€21.00 | €0.00 | matched |
| 106 | capture | 01a17d3a-7088-7227-b313-df583bf570ac | €24.00 | €0.37 | matched |
| 107 | capture | 01a17d3a-8bd6-7d80-89d8-0d923743a2c0 | €49.00 | €0.67 | matched |
| 108 | capture | 01a17d3a-a59b-7455-894e-b19e27ec157f | €49.00 | €0.67 | matched |
| 109 | capture | 01a17d3a-b44d-79ef-9778-2f6019f81eee | €49.00 | €0.67 | matched |
| 110 | capture | 01a17d3a-ee93-70c8-80bb-263719570ecc | €35.00 | €0.50 | matched |
| 111 | capture | 01a17d3b-119d-720e-99b5-b8335b36497f | €35.00 | €0.50 | matched |
| 112 | capture | 01a17d3b-22ca-7f75-b317-6b221072cd40 | €49.00 | €0.67 | matched |
| 113 | capture | 01a17d3b-3ac1-7a87-9712-2b68867810c7 | €9.00 | €0.19 | matched |
| 114 | capture | 01a17d3b-40fa-7342-bc56-10a8c9204f44 | €35.00 | €0.50 | matched |