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
- 15 Oct, 01:00130 lines2 breaks
- 15 Oct, 00:50129 lines4 breaks
- 15 Oct, 00:40120 lines2 breaks
- 15 Oct, 00:30137 lines3 breaks
- 15 Oct, 00:20123 lines7 breaks
- 15 Oct, 00:10109 lines2 breaks
- 15 Oct, 00:00117 lines4 breaks
- 14 Oct, 23:50126 lines5 breaks
- 14 Oct, 23:40154 lines1 break
- 14 Oct, 23:30124 lines3 breaks
- 14 Oct, 23:20136 lines3 breaks
- 14 Oct, 23:10133 lines4 breaks
- 14 Oct, 23:00156 lines2 breaks
- 14 Oct, 22:50126 lines3 breaks
15 Oct, 00:00
Gross
€2,512.00
PSP fee
€40.37
Net to the bank
€2,471.63
Settlement journal
#5084
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13ce1-36fd-767f-b1bb-2c02df53aa10 is already settled by stl_EUR_2986704 line 69
- duplicate linethe file lists it twicecapture:01a13ce3-4053-7673-afce-9e6c02ef4d87 is already settled by stl_EUR_2986704 line 94
- fee differencethe fee is not the contract feethe fee is 69, the contract says 67
- missing linein the books, not in the filecapture:01a13cdf-552b-7f7f-af83-5a1ab4ac9286 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 70 | capture | 01a13ce1-3746-7222-b9e4-216225752373 | €9.00 | €0.19 | duplicate line |
| 82 | capture | 01a13ce2-1265-74dc-ab56-2bee21e079b6 | €49.00 | €0.69 | fee difference |
| 95 | capture | 01a13ce3-42e3-7e4c-835d-ecf96eb72620 | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a13cd7-ac44-706f-8cae-9ff8cacfe77d | €15.00 | €0.26 | matched |
| 2 | capture | 01a13cd8-261f-7c46-8495-2e0896f47bcc | €35.00 | €0.50 | matched |
| 3 | capture | 01a13cdb-6ec3-70f1-865f-00ad3489d16f | €35.00 | €0.50 | matched |
| 4 | capture | 01a13cdb-d588-7e91-94a9-75a48d901f79 | €15.00 | €0.26 | matched |
| 5 | capture | 01a13cdc-0c43-74bd-9555-6b488c949526 | €9.00 | €0.19 | matched |
| 6 | capture | 01a13cdc-0d34-7bb9-acaa-810f46a1677d | €49.00 | €0.67 | matched |
| 7 | capture | 01a13cdc-0f2d-732b-880d-598f92acbb03 | €15.00 | €0.26 | matched |
| 8 | capture | 01a13cdc-195e-7173-af3d-2faeea7e2913 | €49.00 | €0.67 | matched |
| 9 | capture | 01a13cdc-0d26-7597-94c0-8fe07022064f | €49.00 | €0.67 | matched |
| 10 | capture | 01a13cdc-243c-7b1f-8749-4d304db54a31 | €24.00 | €0.37 | matched |
| 11 | capture | 01a13cdc-2552-79d9-b3fe-8b4dbdfe9512 | €9.00 | €0.19 | matched |
| 12 | capture | 01a13cdc-2f6c-7e8f-b461-e660eb1afee5 | €49.00 | €0.67 | matched |
| 13 | capture | 01a13cdc-2c0a-7e19-9bff-d702316d8da5 | €49.00 | €0.67 | matched |
| 14 | capture | 01a13cdc-5693-7071-8b2f-3ae7f1fed4d4 | €9.00 | €0.19 | matched |
| 15 | capture | 01a13cdc-716b-791f-87e6-98c796493cc0 | €9.00 | €0.19 | matched |
| 16 | refund | 01a13cdc-7e50-7244-a576-40e0ea526c3a | -€3.00 | €0.00 | matched |
| 17 | capture | 01a13cdc-8151-7969-90a2-212b24488fed | €35.00 | €0.50 | matched |
| 18 | capture | 01a13cdc-84d1-7f0c-a9bc-b1502abdd87b | €15.00 | €0.26 | matched |
| 19 | capture | 01a13cdc-bad1-7a51-8715-26208fa2422a | €9.00 | €0.19 | matched |
| 20 | capture | 01a13cdc-c1c4-79e1-bc1f-c11758297b76 | €24.00 | €0.37 | matched |
| 21 | capture | 01a13cdc-c3fc-739f-9cb8-1cd9eeaeb327 | €49.00 | €0.67 | matched |
| 22 | capture | 01a13cdc-d718-7f77-b964-23e7aa7a9270 | €35.00 | €0.50 | matched |
| 23 | capture | 01a13cdc-e97f-771d-926a-d24a1e9e2919 | €49.00 | €0.67 | matched |
| 24 | capture | 01a13cdc-f527-7db2-b012-b23bc3e27a3d | €24.00 | €0.37 | matched |
| 25 | capture | 01a13cdd-09af-7b82-b435-1475f5b7c057 | €49.00 | €0.67 | matched |
| 26 | capture | 01a13cdd-26e1-7f14-a90f-b265143ae5c8 | €15.00 | €0.26 | matched |
| 27 | capture | 01a13cdd-3389-7174-a57c-ae0a698cdc54 | €35.00 | €0.50 | matched |
| 28 | capture | 01a13cdd-383c-7edc-8737-ff4a94d09c9d | €9.00 | €0.19 | matched |
| 29 | capture | 01a13cdd-6d25-712e-95eb-5dd05f742abc | €49.00 | €0.67 | matched |
| 30 | capture | 01a13cdd-84a6-781a-9c8a-36192dd5bca1 | €9.00 | €0.19 | matched |
| 31 | capture | 01a13cdd-99e3-78b8-8a3b-af78265a8bbd | €35.00 | €0.50 | matched |
| 32 | capture | 01a13cdd-c1dc-7e4a-a184-6f5934943f17 | €15.00 | €0.26 | matched |
| 33 | capture | 01a13cdd-c8b5-7806-94eb-4e7f3df3a7c6 | €35.00 | €0.50 | matched |
| 34 | capture | 01a13cdd-f6d8-7b16-8633-c4e90f9bb2c0 | €35.00 | €0.50 | matched |
| 35 | capture | 01a13cde-383a-749d-bd19-e0dd74d840d1 | €9.00 | €0.19 | matched |
| 36 | capture | 01a13cde-3bf4-78c3-a86f-5f9eae8ad9df | €35.00 | €0.50 | matched |
| 37 | capture | 01a13cde-45a5-795a-903f-e2c3a65e232e | €35.00 | €0.50 | matched |
| 38 | capture | 01a13cde-6d44-7f27-8c20-dcf1d0e1c155 | €15.00 | €0.26 | matched |
| 39 | capture | 01a13cde-8cdb-7629-93b7-a7a10da34068 | €49.00 | €0.67 | matched |
| 40 | capture | 01a13cdf-0928-71e2-abf9-b65d8968f1a7 | €49.00 | €0.67 | matched |
| 41 | capture | 01a13cdf-1128-7621-943f-cc4ffc1f6739 | €35.00 | €0.50 | matched |
| 42 | capture | 01a13cdf-2408-732e-b297-d1fdb324e3cd | €35.00 | €0.50 | matched |
| 43 | capture | 01a13cdf-2d3e-7b4b-af31-2184a43d9268 | €15.00 | €0.26 | matched |
| 44 | capture | 01a13cdf-4246-734b-9dbe-c0148ef32c36 | €9.00 | €0.19 | matched |
| 45 | capture | 01a13cdf-5037-7302-84e0-cb5c15b3867f | €9.00 | €0.19 | matched |
| 46 | capture | 01a13cdf-59a9-7861-8f41-73cb9b2356a7 | €9.00 | €0.19 | matched |
| 47 | capture | 01a13cdf-5abe-725b-9bfc-445b2a50be61 | €49.00 | €0.67 | matched |
| 48 | capture | 01a13cdf-7091-7b92-ad72-2840e95bebd3 | €35.00 | €0.50 | matched |
| 49 | capture | 01a13cdf-791c-7df1-a8bf-cb3e8a6f6fe0 | €9.00 | €0.19 | matched |
| 50 | capture | 01a13cdf-8a6f-76bc-a18f-e8e9895bb139 | €15.00 | €0.26 | matched |
| 51 | capture | 01a13cdf-9705-793b-8315-2f437c4f2806 | €24.00 | €0.37 | matched |
| 52 | capture | 01a13cdf-a475-748d-bb05-dcb470ea2aff | €15.00 | €0.26 | matched |
| 53 | capture | 01a13cdf-f748-7aad-a96c-348d1bbfd751 | €15.00 | €0.26 | matched |
| 54 | refund | 01a13ce0-09ae-72a5-8434-dfd548423f9c | -€11.00 | €0.00 | matched |
| 55 | capture | 01a13ce0-0c4a-7689-87de-07477cb86b74 | €35.00 | €0.50 | matched |
| 56 | capture | 01a13ce0-329c-7894-8a44-d8b28cc66723 | €9.00 | €0.19 | matched |
| 57 | capture | 01a13ce0-34b3-7747-8ecc-b183f65b2e98 | €15.00 | €0.26 | matched |
| 58 | capture | 01a13ce0-4ccb-74c8-ac21-92e89b6e81a1 | €24.00 | €0.37 | matched |
| 59 | capture | 01a13ce0-5b36-7093-b1d4-757072a280fd | €35.00 | €0.50 | matched |
| 60 | capture | 01a13ce0-5cec-7876-889e-7ab7ffc387aa | €24.00 | €0.37 | matched |
| 61 | capture | 01a13ce0-8ea3-78a1-a308-8b925cedcbdf | €35.00 | €0.50 | matched |
| 62 | capture | 01a13ce0-9010-7e76-84b0-90824b1e0e1a | €24.00 | €0.37 | matched |
| 63 | capture | 01a13ce0-9f2d-726d-bc33-4af0360d5b9e | €24.00 | €0.37 | matched |
| 64 | capture | 01a13ce0-b653-7623-9701-5a52b670e1d8 | €35.00 | €0.50 | matched |
| 65 | capture | 01a13ce0-c1cb-7b9d-8a25-fc66931cbd38 | €15.00 | €0.26 | matched |
| 66 | capture | 01a13ce0-d63b-7fab-8a0a-9a10e193726b | €35.00 | €0.50 | matched |
| 67 | capture | 01a13ce1-257b-7bb0-8f0b-66b392fde19e | €9.00 | €0.19 | matched |
| 68 | refund | 01a13ce1-21a0-7d98-a64c-395f94e9cb84 | -€31.00 | €0.00 | matched |
| 69 | capture | 01a13ce1-3746-7222-b9e4-216225752373 | €9.00 | €0.19 | matched |
| 71 | capture | 01a13ce1-408d-7f49-a77c-4934bd4eb023 | €24.00 | €0.37 | matched |
| 72 | capture | 01a13ce1-5299-7e5f-bbe7-99b6fc4114bd | €9.00 | €0.19 | matched |
| 73 | capture | 01a13ce1-637d-7cd7-aab4-f34e0eb018e8 | €24.00 | €0.37 | matched |
| 74 | refund | 01a13ce1-70e2-76ee-9add-d887b51b61b0 | -€7.00 | €0.00 | matched |
| 75 | capture | 01a13ce1-7a9b-7b23-9e16-dc00c19c467c | €9.00 | €0.19 | matched |
| 76 | capture | 01a13ce1-89b8-76d2-a01c-44f56fc0bed4 | €9.00 | €0.19 | matched |
| 77 | capture | 01a13ce1-8ca8-7095-8f9e-9b225d25b893 | €9.00 | €0.19 | matched |
| 78 | capture | 01a13ce1-8e83-7ce4-8933-cc2e9bbfdf51 | €24.00 | €0.37 | matched |
| 79 | capture | 01a13ce1-c057-7ac3-8a2c-d709bdf78cb7 | €9.00 | €0.19 | matched |
| 80 | capture | 01a13ce1-d8c5-79f7-8e2f-70735c83592a | €9.00 | €0.19 | matched |
| 81 | capture | 01a13ce1-df8e-7300-b94e-cbb0b235a17c | €49.00 | €0.67 | matched |
| 83 | capture | 01a13ce2-14b3-7e02-a7af-ddb3df6f157c | €35.00 | €0.50 | matched |
| 84 | capture | 01a13ce2-3a84-721a-b51b-4cbaa4e78489 | €15.00 | €0.26 | matched |
| 85 | capture | 01a13ce2-54e6-746f-a145-f4a040a7a722 | €24.00 | €0.37 | matched |
| 86 | capture | 01a13ce2-6e14-7f48-93a1-94e12a2f6ce6 | €35.00 | €0.50 | matched |
| 87 | refund | 01a13ce2-89e9-7c56-b097-24d6131a674d | -€6.00 | €0.00 | matched |
| 88 | capture | 01a13ce2-90be-7425-b8d1-1c4c2b606a1c | €15.00 | €0.26 | matched |
| 89 | capture | 01a13ce2-d021-742e-9e66-ef0831c6badf | €15.00 | €0.26 | matched |
| 90 | refund | 01a13ce2-f716-7b6c-9c57-3bc079c7ea54 | -€11.00 | €0.00 | matched |
| 91 | capture | 01a13ce2-fde7-7c69-b5df-baecd92e200c | €24.00 | €0.37 | matched |
| 92 | capture | 01a13ce3-10ca-705a-8979-80c36568a350 | €9.00 | €0.19 | matched |
| 93 | capture | 01a13ce3-1e60-760f-8644-c6cce2e4cecc | €35.00 | €0.50 | matched |
| 94 | capture | 01a13ce3-42e3-7e4c-835d-ecf96eb72620 | €49.00 | €0.67 | matched |
| 96 | capture | 01a13ce3-4a80-72d1-a90c-bfd8bf9526a9 | €15.00 | €0.26 | matched |
| 97 | capture | 01a13ce3-4ab4-7bb4-b6c5-2333d2a509a3 | €35.00 | €0.50 | matched |
| 98 | capture | 01a13ce3-51bd-72ec-a55a-8c34f1262375 | €15.00 | €0.26 | matched |
| 99 | capture | 01a13ce3-5d23-78a4-9d75-ea730ed072c0 | €15.00 | €0.26 | matched |
| 100 | capture | 01a13ce3-72cf-7622-8653-0099f5d8742d | €15.00 | €0.26 | matched |
| 101 | capture | 01a13ce3-a488-7805-8165-0dab36241140 | €15.00 | €0.26 | matched |
| 102 | capture | 01a13ce3-e3fb-74fa-ad06-9a4096ec3d2e | €15.00 | €0.26 | matched |
| 103 | capture | 01a13ce3-e934-72ab-a9c6-45affa1dba52 | €15.00 | €0.26 | matched |
| 104 | capture | 01a13ce4-0c9b-759d-8247-aacd5fac17d8 | €49.00 | €0.67 | matched |
| 105 | capture | 01a13ce4-10fe-7753-99cf-b76f2d007a1e | €49.00 | €0.67 | matched |
| 106 | refund | 01a13ce4-3776-70ba-83ff-77d3bdb2e306 | -€11.00 | €0.00 | matched |
| 107 | capture | 01a13ce4-440d-71d1-b2f7-0c782609a343 | €24.00 | €0.37 | matched |
| 108 | capture | 01a13ce4-487e-73c5-a44c-c22e14595328 | €24.00 | €0.37 | matched |
| 109 | capture | 01a13ce4-5d04-7965-92bc-8fc42be9ee33 | €9.00 | €0.19 | matched |
| 110 | capture | 01a13ce4-775d-77e6-b32d-ade05cf895dd | €24.00 | €0.37 | matched |
| 111 | refund | 01a13ce4-7dc9-7ec7-a438-7aa2b715a6ae | -€23.00 | €0.00 | matched |
| 112 | refund | 01a13ce4-7fad-7da6-af7a-31da7af694b2 | -€19.00 | €0.00 | matched |
| 113 | refund | 01a13ce4-9007-7e26-a19c-065b38f9b5b5 | -€5.00 | €0.00 | matched |
| 114 | capture | 01a13ce4-9c8a-70ef-a75f-659584e16833 | €9.00 | €0.19 | matched |
| 115 | capture | 01a13ce4-a3ec-7bb5-8b6d-99dc03a36f4c | €15.00 | €0.26 | matched |
| 116 | capture | 01a13ce4-a980-753a-b688-3dd418d78005 | €9.00 | €0.19 | matched |
| 117 | capture | 01a13ce4-d5a0-7d5d-a455-4f7b2fd07d7e | €9.00 | €0.19 | matched |