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
- 19 Oct, 08:00119 lines3 breaks
- 19 Oct, 07:50104 lines3 breaks
- 19 Oct, 07:40127 lines3 breaks
- 19 Oct, 07:30103 lines1 break
- 19 Oct, 07:20129 lines1 break
- 19 Oct, 07:10128 lines2 breaks
- 19 Oct, 07:00128 lines3 breaks
- 19 Oct, 06:50120 linesclean
- 19 Oct, 06:40119 lines4 breaks
- 19 Oct, 06:30124 lines3 breaks
- 19 Oct, 06:20124 lines3 breaks
- 19 Oct, 06:10115 lines4 breaks
- 19 Oct, 06:00120 lines5 breaks
- 19 Oct, 05:50135 lines2 breaks
19 Oct, 06:40
Gross
€2,600.00
PSP fee
€43.31
Net to the bank
€2,556.69
Settlement journal
#82786
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a152e6-4da8-7a36-972e-c835f8151b49 is already settled by stl_EUR_2987320 line 32
- fee differencethe fee is not the contract feethe fee is 20, the contract says 19
- missing linein the books, not in the filecapture:01a152e4-4a7a-78ac-a17f-591370b436f9 is in no file
- missing linein the books, not in the filecapture:01a152eb-ce00-7f57-b846-831c0ca1c61d is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 33 | capture | 01a152e6-577f-73da-ba19-d28365c50bf0 | €24.00 | €0.37 | duplicate line |
| 43 | capture | 01a152e7-0fe6-7db9-ae9c-27e09e9242a7 | €9.00 | €0.20 | fee difference |
| 1 | capture | 01a152dc-59f4-7dc9-9721-3b390b26b16c | €35.00 | €0.50 | matched |
| 2 | capture | 01a152df-3b5a-7248-980c-fbdad213cbf2 | €15.00 | €0.26 | matched |
| 3 | capture | 01a152e3-b9f3-7a24-a812-078c0a3e3356 | €35.00 | €0.50 | matched |
| 4 | capture | 01a152e3-be0f-7c98-9238-6dd7acd7c39b | €49.00 | €0.67 | matched |
| 5 | capture | 01a152e3-c19f-794e-b1d0-8c4bc0595ac6 | €15.00 | €0.26 | matched |
| 6 | capture | 01a152e3-f747-7c2a-b29b-c89e16ad7f3e | €9.00 | €0.19 | matched |
| 7 | capture | 01a152e4-0a47-7675-bdbd-c3c934ef306d | €35.00 | €0.50 | matched |
| 8 | capture | 01a152e4-13f0-7c10-8a59-7a494de0b356 | €49.00 | €0.67 | matched |
| 9 | capture | 01a152e4-1f05-7b87-ba24-d22b63d6a8fb | €49.00 | €0.67 | matched |
| 10 | capture | 01a152e4-20a1-77cf-845e-471375ddd14b | €35.00 | €0.50 | matched |
| 11 | capture | 01a152e4-4920-752c-bf06-57c1a48a8f9f | €15.00 | €0.26 | matched |
| 12 | capture | 01a152e4-5b46-7270-9456-9f6ca275d283 | €49.00 | €0.67 | matched |
| 13 | capture | 01a152e4-a629-7ea2-94ad-18b62b49a6c3 | €15.00 | €0.26 | matched |
| 14 | refund | 01a152e4-ae5e-7592-9c41-981cc2788f75 | -€14.00 | €0.00 | matched |
| 15 | capture | 01a152e4-de54-70ff-9c63-a3c6cefaf642 | €9.00 | €0.19 | matched |
| 16 | capture | 01a152e4-f624-7aa8-9fb3-5b83cc0e56a3 | €9.00 | €0.19 | matched |
| 17 | capture | 01a152e5-2dab-7947-83ae-a5f6d4fcda30 | €9.00 | €0.19 | matched |
| 18 | capture | 01a152e5-2e6c-76a7-b551-1eef115b1578 | €9.00 | €0.19 | matched |
| 19 | capture | 01a152e5-4aeb-7be3-8f90-c87d53fa7b6e | €9.00 | €0.19 | matched |
| 20 | capture | 01a152e5-5597-739f-bef3-e12352687ab9 | €49.00 | €0.67 | matched |
| 21 | capture | 01a152e5-561f-7245-a4be-141c655ca623 | €49.00 | €0.67 | matched |
| 22 | capture | 01a152e5-597d-7b72-aa7d-1284a45373df | €24.00 | €0.37 | matched |
| 23 | capture | 01a152e5-5c7d-779a-9f60-d35e310e76c7 | €49.00 | €0.67 | matched |
| 24 | capture | 01a152e5-7a8e-723b-a064-ece1c3d087e7 | €15.00 | €0.26 | matched |
| 25 | refund | 01a152e5-91c1-7c7c-844f-14259a730e4f | -€8.00 | €0.00 | matched |
| 26 | capture | 01a152e5-94ba-75eb-a0a2-9fd942e2516b | €9.00 | €0.19 | matched |
| 27 | refund | 01a152e5-ad48-745c-85bf-ce7f7e479ee2 | -€13.00 | €0.00 | matched |
| 28 | capture | 01a152e5-c0d6-702f-989f-1e9ce9c80c97 | €49.00 | €0.67 | matched |
| 29 | refund | 01a152e5-ee9e-7bef-961e-cf62602cf545 | -€44.00 | €0.00 | matched |
| 30 | capture | 01a152e6-3c2f-7dc6-82ac-48be69d2359c | €49.00 | €0.67 | matched |
| 31 | capture | 01a152e6-54bf-77ca-bfd4-772ecf5f0dd5 | €9.00 | €0.19 | matched |
| 32 | capture | 01a152e6-577f-73da-ba19-d28365c50bf0 | €24.00 | €0.37 | matched |
| 34 | capture | 01a152e6-5a33-7abf-b2b3-3617d7cc14d9 | €49.00 | €0.67 | matched |
| 35 | capture | 01a152e6-5c79-7c2c-a14c-ead50ff738fb | €24.00 | €0.37 | matched |
| 36 | capture | 01a152e6-9ec8-7e17-bc77-107c734d0f0c | €24.00 | €0.37 | matched |
| 37 | capture | 01a152e6-9f0f-7cf7-9892-fc35abd4adf5 | €24.00 | €0.37 | matched |
| 38 | refund | 01a152e6-ad08-7c5c-879d-598f1754e33d | -€16.00 | €0.00 | matched |
| 39 | capture | 01a152e6-c90a-7b9d-bc22-ddb034c90488 | €9.00 | €0.19 | matched |
| 40 | capture | 01a152e6-d391-790c-b11a-aec5fcf3cf0b | €35.00 | €0.50 | matched |
| 41 | capture | 01a152e6-d6f4-7fbc-824c-b223d0ec7687 | €49.00 | €0.67 | matched |
| 42 | capture | 01a152e7-0057-7fb3-a638-d1b220399dca | €15.00 | €0.26 | matched |
| 44 | capture | 01a152e7-2668-717c-9c33-1ed9bbb9c812 | €9.00 | €0.19 | matched |
| 45 | capture | 01a152e7-47f2-7c76-85ab-d7509c7fef5d | €49.00 | €0.67 | matched |
| 46 | capture | 01a152e7-5546-7b44-827f-0f972248f351 | €15.00 | €0.26 | matched |
| 47 | capture | 01a152e7-7897-7220-88a0-cb32cea9a4d5 | €24.00 | €0.37 | matched |
| 48 | capture | 01a152e7-8c47-7bb1-a3d1-998bc823e9da | €15.00 | €0.26 | matched |
| 49 | capture | 01a152e7-9b39-7a10-b652-8fd5a2255f9b | €49.00 | €0.67 | matched |
| 50 | capture | 01a152e7-b53c-7ef3-8a44-7465cda7362c | €9.00 | €0.19 | matched |
| 51 | capture | 01a152e7-c9b2-7a03-9596-69761116c79f | €49.00 | €0.67 | matched |
| 52 | capture | 01a152e7-ed01-733f-99f9-6fa9f0d831ad | €9.00 | €0.19 | matched |
| 53 | capture | 01a152e8-3f34-7aa2-abc8-f1b0d5d22171 | €24.00 | €0.37 | matched |
| 54 | capture | 01a152e8-47a4-7153-b945-669acb4c91cf | €35.00 | €0.50 | matched |
| 55 | capture | 01a152e8-48a4-75d2-bae6-a585984ebea4 | €15.00 | €0.26 | matched |
| 56 | capture | 01a152e8-4de2-74c5-b2c9-1ab9390c1e1b | €49.00 | €0.67 | matched |
| 57 | capture | 01a152e8-5bb2-73ce-9b52-532b6ffd68ba | €35.00 | €0.50 | matched |
| 58 | capture | 01a152e8-775a-7c05-8fa7-c41a9a5928d2 | €35.00 | €0.50 | matched |
| 59 | capture | 01a152e8-9656-7941-b0be-617ab3d5ed48 | €24.00 | €0.37 | matched |
| 60 | refund | 01a152e8-9edf-7c9e-939d-a362ac99c229 | -€23.00 | €0.00 | matched |
| 61 | capture | 01a152e8-d2b3-74a7-89d2-7700de1b87c5 | €15.00 | €0.26 | matched |
| 62 | capture | 01a152e8-e592-758b-82b2-befb09bf5b2e | €35.00 | €0.50 | matched |
| 63 | capture | 01a152e8-e5b4-7c95-8593-58f368e42219 | €9.00 | €0.19 | matched |
| 64 | capture | 01a152e8-ef83-7ea3-af38-817daac59e8b | €35.00 | €0.50 | matched |
| 65 | capture | 01a152e8-f49d-7c91-b87e-9cd05d3cbc41 | €35.00 | €0.50 | matched |
| 66 | capture | 01a152e9-0c41-7f31-9103-a8cf3a58f129 | €9.00 | €0.19 | matched |
| 67 | capture | 01a152e9-18cc-713f-8dc6-cea8a485d57c | €49.00 | €0.67 | matched |
| 68 | refund | 01a152e9-1a2b-7775-8e35-23a4d17db65b | -€17.00 | €0.00 | matched |
| 69 | capture | 01a152e9-2079-79db-8275-46422484fcff | €24.00 | €0.37 | matched |
| 70 | capture | 01a152e9-3055-7a9c-b59e-3a4af58937dc | €9.00 | €0.19 | matched |
| 71 | capture | 01a152e9-5ec3-7a4e-a70f-8408fe7e4807 | €35.00 | €0.50 | matched |
| 72 | capture | 01a152e9-7219-7f71-bd5d-24abbd961e2d | €24.00 | €0.37 | matched |
| 73 | refund | 01a152e9-8fc2-7cdf-97bb-81e85b5da083 | -€20.00 | €0.00 | matched |
| 74 | capture | 01a152e9-9e3f-7f0e-9edd-9369e743bbb6 | €49.00 | €0.67 | matched |
| 75 | capture | 01a152e9-a82d-7606-963e-39bc230d7fee | €35.00 | €0.50 | matched |
| 76 | capture | 01a152e9-aec4-73c1-bf3b-84a4301ef92b | €15.00 | €0.26 | matched |
| 77 | capture | 01a152e9-c90b-7746-a453-278366ed7b59 | €35.00 | €0.50 | matched |
| 78 | capture | 01a152e9-cd83-7219-96c7-767e081bd159 | €15.00 | €0.26 | matched |
| 79 | capture | 01a152ea-320d-77a4-9260-a58519903dbc | €24.00 | €0.37 | matched |
| 80 | capture | 01a152ea-3dd8-7726-ab4e-49e26a8e3268 | €35.00 | €0.50 | matched |
| 81 | capture | 01a152ea-4a3b-7e06-8429-2eb02e2ed23b | €9.00 | €0.19 | matched |
| 82 | capture | 01a152ea-5891-772e-8c64-8d4bd8c5e9d9 | €15.00 | €0.26 | matched |
| 83 | capture | 01a152ea-73e3-766d-8b29-231183734278 | €15.00 | €0.26 | matched |
| 84 | capture | 01a152ea-767b-7f35-b600-1d013d03dc26 | €35.00 | €0.50 | matched |
| 85 | capture | 01a152ea-6c23-7886-a0ab-75f13682e612 | €49.00 | €0.67 | matched |
| 86 | capture | 01a152ea-9849-74fd-89a5-b2c33f79f97b | €15.00 | €0.26 | matched |
| 87 | refund | 01a152ea-98d2-7f8a-9b09-cb6c7350e317 | -€32.00 | €0.00 | matched |
| 88 | capture | 01a152ea-a25c-750b-95c8-418f46b55ef9 | €49.00 | €0.67 | matched |
| 89 | capture | 01a152ea-a761-7507-bddb-c09009759bd3 | €9.00 | €0.19 | matched |
| 90 | capture | 01a152ea-d74f-7205-b505-71def4f429a9 | €9.00 | €0.19 | matched |
| 91 | capture | 01a152ea-d7b2-7821-b97a-e09b1e050b82 | €15.00 | €0.26 | matched |
| 92 | refund | 01a152ea-dcb9-7a32-af63-1c676304beed | -€33.00 | €0.00 | matched |
| 93 | capture | 01a152ea-f122-75dd-846b-dce692377dbb | €49.00 | €0.67 | matched |
| 94 | capture | 01a152ea-fe39-7d90-b1ce-8ed2a5bf1024 | €35.00 | €0.50 | matched |
| 95 | capture | 01a152ea-f9b8-7e6f-9f55-7e05c78eefb2 | €35.00 | €0.50 | matched |
| 96 | capture | 01a152eb-2f86-79cb-8b5d-f865f14f5882 | €35.00 | €0.50 | matched |
| 97 | capture | 01a152eb-335b-7865-b84c-a7a948fc9f0a | €35.00 | €0.50 | matched |
| 98 | capture | 01a152eb-409d-7efd-aa8f-bbe60f25095f | €35.00 | €0.50 | matched |
| 99 | refund | 01a152eb-77f1-74eb-9da9-fe7bd62bcc90 | -€27.00 | €0.00 | matched |
| 100 | capture | 01a152eb-a977-7ce9-b75e-30b14316a31b | €24.00 | €0.37 | matched |
| 101 | capture | 01a152eb-ae85-781b-b5a8-048b0f6bd458 | €15.00 | €0.26 | matched |
| 102 | capture | 01a152eb-c86c-7ef7-babe-7cfcf99b15c4 | €15.00 | €0.26 | matched |
| 103 | capture | 01a152eb-cf2d-72e2-869d-b854f9854cc2 | €24.00 | €0.37 | matched |
| 104 | capture | 01a152eb-d261-722a-b94d-4e6d1923802d | €15.00 | €0.26 | matched |
| 105 | capture | 01a152eb-d32b-78f1-a56a-a8b93b3f4e20 | €24.00 | €0.37 | matched |
| 106 | capture | 01a152eb-e4d6-7cb4-b993-d98467df0e6d | €49.00 | €0.67 | matched |
| 107 | capture | 01a152eb-f922-7165-bada-6e01e896416e | €24.00 | €0.37 | matched |
| 108 | capture | 01a152ec-08fe-75c3-911a-1f3f2adf16ef | €49.00 | €0.67 | matched |
| 109 | capture | 01a152ec-0c3d-77b9-a886-a0d5b9e399a5 | €24.00 | €0.37 | matched |
| 110 | capture | 01a152ec-1fe8-79b1-86e6-b198f142d8d5 | €49.00 | €0.67 | matched |
| 111 | capture | 01a152ec-3088-73c9-9102-a2cb8cf329b7 | €15.00 | €0.26 | matched |
| 112 | capture | 01a152ec-31f3-7904-98ac-2bc0c6e245bf | €24.00 | €0.37 | matched |
| 113 | refund | 01a152ec-54ce-7092-a21e-025cbf7bf539 | -€21.00 | €0.00 | matched |
| 114 | capture | 01a152ec-5857-7a9e-8a76-b682f1a33060 | €9.00 | €0.19 | matched |
| 115 | capture | 01a152ec-58f7-796e-9696-16a30d53e5ab | €9.00 | €0.19 | matched |
| 116 | capture | 01a152ec-5be0-7faa-a6b8-e81d48947802 | €49.00 | €0.67 | matched |
| 117 | refund | 01a152ec-6d03-70c2-99fc-344c76a97eaf | -€23.00 | €0.00 | matched |
| 118 | capture | 01a152ec-7e55-79e8-8063-56f6acf4f936 | €35.00 | €0.50 | matched |
| 119 | capture | 01a152ec-93a9-7a05-887e-1a32665e48a4 | €24.00 | €0.37 | matched |