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
- 16 Oct, 15:00128 lines2 breaks
- 16 Oct, 14:50112 lines2 breaks
- 16 Oct, 14:40112 lines2 breaks
- 16 Oct, 14:30118 lines2 breaks
- 16 Oct, 14:20112 lines2 breaks
- 16 Oct, 14:1094 lines2 breaks
- 16 Oct, 14:00124 lines1 break
- 16 Oct, 13:50125 lines3 breaks
- 16 Oct, 13:40116 lines1 break
- 16 Oct, 13:30125 lines3 breaks
- 16 Oct, 13:20112 lines2 breaks
- 16 Oct, 13:1096 lines2 breaks
- 16 Oct, 13:00118 lines4 breaks
- 16 Oct, 12:50118 lines5 breaks
16 Oct, 13:50
Gross
€3,200.00
PSP fee
€49.35
Net to the bank
€3,150.65
Settlement journal
#34233
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a144fc-29e5-7367-8b4f-cc10d9508f4a is already settled by stl_EUR_2986931 line 25
- fee differencethe fee is not the contract feethe fee is 41, the contract says 37
- missing linein the books, not in the filecapture:01a144fb-c8bd-70ca-abef-f008856740d0 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 26 | capture | 01a144fc-2a45-7117-a2f5-29e5a98f2ef6 | €24.00 | €0.37 | duplicate line |
| 76 | capture | 01a14500-248c-7ee0-abf5-7b34155f49b2 | €24.00 | €0.41 | fee difference |
| 1 | capture | 01a144f1-bb30-713e-9f67-cec71ccac040 | €35.00 | €0.50 | matched |
| 2 | capture | 01a144f6-3c14-7e89-9611-2607141c169d | €24.00 | €0.37 | matched |
| 3 | capture | 01a144f8-efce-7e51-a85a-4c2f6247f865 | €49.00 | €0.67 | matched |
| 4 | capture | 01a144f9-7f52-71f7-b48f-b0c1dba6e213 | €49.00 | €0.67 | matched |
| 5 | capture | 01a144fa-1368-7960-8ea7-32e6bf018664 | €35.00 | €0.50 | matched |
| 6 | capture | 01a144fa-177d-7985-984c-c3edc6134734 | €35.00 | €0.50 | matched |
| 7 | capture | 01a144fa-303d-7934-8f8b-571fb5591f59 | €9.00 | €0.19 | matched |
| 8 | capture | 01a144fa-3f92-720f-94d0-bf710421d1e5 | €49.00 | €0.67 | matched |
| 9 | capture | 01a144fa-49c4-7329-819d-0287c86315c7 | €15.00 | €0.26 | matched |
| 10 | capture | 01a144fa-4eb7-73b5-99d1-071024c5cca8 | €15.00 | €0.26 | matched |
| 11 | capture | 01a144fa-ad1b-7bab-b065-39a14830c354 | €9.00 | €0.19 | matched |
| 12 | capture | 01a144fa-e84e-75ef-87dc-94a2048df039 | €24.00 | €0.37 | matched |
| 13 | capture | 01a144fa-efee-7fc8-8e7d-91f59a0ae007 | €35.00 | €0.50 | matched |
| 14 | capture | 01a144fb-1185-7260-b863-02fe1ec2e30c | €9.00 | €0.19 | matched |
| 15 | capture | 01a144fb-207c-7364-a8e3-549f18c7d9f6 | €24.00 | €0.37 | matched |
| 16 | capture | 01a144fb-21ee-7f88-97b5-a58f9713c762 | €24.00 | €0.37 | matched |
| 17 | refund | 01a144fb-4d6c-7648-9cea-7dc5cedf6d67 | -€7.00 | €0.00 | matched |
| 18 | capture | 01a144fb-789b-7d38-b632-45269f9dd4d9 | €15.00 | €0.26 | matched |
| 19 | capture | 01a144fb-8c02-7172-b676-0df2bad4a896 | €49.00 | €0.67 | matched |
| 20 | capture | 01a144fb-94a9-772c-90d2-c59369750e61 | €49.00 | €0.67 | matched |
| 21 | capture | 01a144fb-b0af-70c4-986a-836449819e44 | €49.00 | €0.67 | matched |
| 22 | refund | 01a144fb-d8af-7d62-a953-46d182315bf3 | -€10.00 | €0.00 | matched |
| 23 | capture | 01a144fc-0806-7cb4-8fa4-4754ae15c1a2 | €24.00 | €0.37 | matched |
| 24 | capture | 01a144fc-1dc9-773d-92bf-dc1efd0863a9 | €15.00 | €0.26 | matched |
| 25 | capture | 01a144fc-2a45-7117-a2f5-29e5a98f2ef6 | €24.00 | €0.37 | matched |
| 27 | capture | 01a144fc-2ea6-736d-b2d1-3dde09a3fa98 | €49.00 | €0.67 | matched |
| 28 | capture | 01a144fc-418c-7e9e-9821-7368863df8dc | €49.00 | €0.67 | matched |
| 29 | capture | 01a144fc-4379-7903-afb4-9d066d335340 | €15.00 | €0.26 | matched |
| 30 | capture | 01a144fc-4a03-7f69-92c9-56c32074f322 | €49.00 | €0.67 | matched |
| 31 | capture | 01a144fc-5f23-7697-b3a1-3bdb24660c87 | €35.00 | €0.50 | matched |
| 32 | capture | 01a144fc-7316-7b65-9acd-0e4efbd7807e | €35.00 | €0.50 | matched |
| 33 | capture | 01a144fc-87b3-7f23-b51e-ea76ff7f35c2 | €15.00 | €0.26 | matched |
| 34 | capture | 01a144fc-88aa-7a8e-aa01-4a778e3e541e | €24.00 | €0.37 | matched |
| 35 | capture | 01a144fc-e875-7b35-a10a-8f0f344c257b | €49.00 | €0.67 | matched |
| 36 | capture | 01a144fc-f182-7cb7-8a86-8bce8992de4d | €35.00 | €0.50 | matched |
| 37 | capture | 01a144fc-f80f-7444-986a-84d423eefa4a | €24.00 | €0.37 | matched |
| 38 | capture | 01a144fc-f883-7973-8a4c-6c13a2e5a486 | €15.00 | €0.26 | matched |
| 39 | capture | 01a144fd-041b-7e9f-9bfa-74c12476e115 | €24.00 | €0.37 | matched |
| 40 | capture | 01a144fd-1552-7b83-8f4b-25962cbcb0c0 | €35.00 | €0.50 | matched |
| 41 | capture | 01a144fd-2326-70ac-b2ea-64812ea2f396 | €9.00 | €0.19 | matched |
| 42 | capture | 01a144fd-3d6a-72a3-b09e-166b7ea26a7d | €24.00 | €0.37 | matched |
| 43 | capture | 01a144fd-4e62-7b8b-808f-3348da26ba6e | €24.00 | €0.37 | matched |
| 44 | capture | 01a144fd-4fe6-7176-bba5-37c41c707bde | €15.00 | €0.26 | matched |
| 45 | refund | 01a144fd-5a85-7238-8825-e31aa70eb607 | -€18.00 | €0.00 | matched |
| 46 | capture | 01a144fd-6239-7c93-8ffa-d0a178264428 | €35.00 | €0.50 | matched |
| 47 | refund | 01a144fd-65be-7f98-9fde-573a9b24bb5c | -€23.00 | €0.00 | matched |
| 48 | capture | 01a144fd-726c-7173-b512-9a0a8084d9b1 | €15.00 | €0.26 | matched |
| 49 | capture | 01a144fd-7bc0-7dee-877f-c4434d373ecb | €49.00 | €0.67 | matched |
| 50 | capture | 01a144fd-babf-70ae-b72b-aa5d35214eeb | €49.00 | €0.67 | matched |
| 51 | capture | 01a144fd-c0b9-7b1c-9874-f372fba78716 | €24.00 | €0.37 | matched |
| 52 | capture | 01a144fd-d342-7771-a1ca-48000d63a27f | €49.00 | €0.67 | matched |
| 53 | capture | 01a144fd-f995-7407-8843-8bd52649f805 | €9.00 | €0.19 | matched |
| 54 | capture | 01a144fe-293d-7002-860b-51b2d4c4365b | €15.00 | €0.26 | matched |
| 55 | capture | 01a144fe-2d92-702a-90fe-3d144e533f9c | €9.00 | €0.19 | matched |
| 56 | capture | 01a144fe-3282-7974-bfdb-836d3f13dfd8 | €35.00 | €0.50 | matched |
| 57 | capture | 01a144fe-591d-7377-a1c8-5fbf00dc5eca | €15.00 | €0.26 | matched |
| 58 | capture | 01a144fe-6f1d-7d00-8eb1-8c1febe97848 | €49.00 | €0.67 | matched |
| 59 | refund | 01a144fe-7c60-70c3-a306-cfebe1e66480 | -€7.00 | €0.00 | matched |
| 60 | capture | 01a144fe-8990-7656-b609-4128a6197438 | €24.00 | €0.37 | matched |
| 61 | capture | 01a144fe-ba46-771b-a618-f7001c641152 | €15.00 | €0.26 | matched |
| 62 | capture | 01a144fe-bfd9-775d-b733-64c3a25a6a42 | €49.00 | €0.67 | matched |
| 63 | capture | 01a144ff-09bd-7d63-a7bb-796c07595e67 | €35.00 | €0.50 | matched |
| 64 | capture | 01a144ff-13c7-78f0-ada6-1478c59272be | €35.00 | €0.50 | matched |
| 65 | capture | 01a144ff-16c6-7e62-8acb-07992966a7ed | €49.00 | €0.67 | matched |
| 66 | capture | 01a144ff-351b-7841-8dfb-893b63d60169 | €49.00 | €0.67 | matched |
| 67 | capture | 01a144ff-48f5-7df9-ae78-02781f47e10a | €35.00 | €0.50 | matched |
| 68 | capture | 01a144ff-49a2-7d38-ac7f-3f1c0f959dba | €9.00 | €0.19 | matched |
| 69 | capture | 01a144ff-704f-7fd0-b281-2644423d5f80 | €9.00 | €0.19 | matched |
| 70 | capture | 01a144ff-74be-7cda-8dd1-0197bdb3c429 | €49.00 | €0.67 | matched |
| 71 | capture | 01a144ff-83ec-7cfc-8f17-a8aa719b0ee2 | €35.00 | €0.50 | matched |
| 72 | capture | 01a144ff-956b-7242-98fb-9c59bf0ca174 | €49.00 | €0.67 | matched |
| 73 | capture | 01a144ff-b9e0-7c01-9d82-6fffb6540f0e | €15.00 | €0.26 | matched |
| 74 | capture | 01a144ff-f8db-7400-a4df-c246f21ed19e | €15.00 | €0.26 | matched |
| 75 | capture | 01a14500-0a4a-79dc-889b-eb1318750372 | €9.00 | €0.19 | matched |
| 77 | capture | 01a14500-56c6-74db-aac3-a745fe044fd2 | €9.00 | €0.19 | matched |
| 78 | capture | 01a14500-a7af-7abe-b109-f744727ac3c3 | €15.00 | €0.26 | matched |
| 79 | capture | 01a14500-c198-776f-a9ac-1b87637ad31a | €15.00 | €0.26 | matched |
| 80 | capture | 01a14500-ced3-703e-8721-4517e5c34633 | €49.00 | €0.67 | matched |
| 81 | capture | 01a14500-e881-79f0-b2ad-2b64a6e75f6b | €15.00 | €0.26 | matched |
| 82 | capture | 01a14501-06e1-794b-b637-1595cbde3c0d | €24.00 | €0.37 | matched |
| 83 | capture | 01a14501-0dbd-72ee-af78-1fb0c89d04d1 | €35.00 | €0.50 | matched |
| 84 | capture | 01a14501-0f86-7990-8744-03462f0e5bf7 | €15.00 | €0.26 | matched |
| 85 | capture | 01a14501-33d7-758f-a6fb-ae7e6dbd4888 | €49.00 | €0.67 | matched |
| 86 | capture | 01a14501-3bc5-7d66-86af-941593b5bb01 | €9.00 | €0.19 | matched |
| 87 | capture | 01a14501-3dbe-71b9-ac7e-707c9f6b12cb | €15.00 | €0.26 | matched |
| 88 | capture | 01a14501-44bf-736c-be42-50f90be97555 | €35.00 | €0.50 | matched |
| 89 | capture | 01a14501-48f1-7a87-820f-9bc5cd21b9f6 | €49.00 | €0.67 | matched |
| 90 | capture | 01a14501-4f15-7116-936f-ebf6cc09d9e2 | €35.00 | €0.50 | matched |
| 91 | capture | 01a14501-5f02-788f-9316-3f46b0574513 | €35.00 | €0.50 | matched |
| 92 | capture | 01a14501-6421-7f65-8265-fd6914a8a988 | €49.00 | €0.67 | matched |
| 93 | capture | 01a14501-64b3-76b7-aa27-c2134a1038bc | €9.00 | €0.19 | matched |
| 94 | capture | 01a14501-656a-7ed7-8905-fa1791beefa0 | €49.00 | €0.67 | matched |
| 95 | refund | 01a14501-745d-75b8-9c66-a3cf6238d24e | -€26.00 | €0.00 | matched |
| 96 | capture | 01a14501-85dc-7bd5-9476-f3864da8fd2f | €24.00 | €0.37 | matched |
| 97 | capture | 01a14501-8971-7dcf-9f6f-a280e91f0154 | €49.00 | €0.67 | matched |
| 98 | capture | 01a14501-a2b3-7795-b26d-e5e645e34622 | €35.00 | €0.50 | matched |
| 99 | capture | 01a14501-bb67-7046-b1ff-47078703334c | €49.00 | €0.67 | matched |
| 100 | capture | 01a14501-c544-7f84-98d5-96305012a49c | €9.00 | €0.19 | matched |
| 101 | capture | 01a14501-ca0e-7f90-85c4-e880e7c3c712 | €49.00 | €0.67 | matched |
| 102 | capture | 01a14501-cc99-75b7-8c83-ecad3ae981f4 | €35.00 | €0.50 | matched |
| 103 | capture | 01a14502-052c-7fb6-bb00-529d861f69b8 | €35.00 | €0.50 | matched |
| 104 | capture | 01a14502-1490-7b6a-8fc0-d2fb679a1e1e | €24.00 | €0.37 | matched |
| 105 | capture | 01a14502-1fd8-7d9c-9e2b-7629a379ef59 | €49.00 | €0.67 | matched |
| 106 | capture | 01a14502-292e-7ca2-bf2a-7a7dbba55023 | €15.00 | €0.26 | matched |
| 107 | capture | 01a14502-2b1f-73eb-9d41-aab3e93a1fdf | €15.00 | €0.26 | matched |
| 108 | capture | 01a14502-37c4-7ebc-8abb-b9a8cdd77bb6 | €15.00 | €0.26 | matched |
| 109 | capture | 01a14502-3fe7-7eba-b367-465f187294d6 | €15.00 | €0.26 | matched |
| 110 | capture | 01a14502-7333-7d39-8c6d-e4005f48be9a | €15.00 | €0.26 | matched |
| 111 | refund | 01a14502-750a-76b4-9c7d-b438ed0a74d2 | -€23.00 | €0.00 | matched |
| 112 | capture | 01a14502-7676-71e8-81d6-93c595cfe058 | €9.00 | €0.19 | matched |
| 113 | capture | 01a14502-8ac1-78a8-883b-623e688753b8 | €35.00 | €0.50 | matched |
| 114 | capture | 01a14502-8d77-7484-9bbc-fc0fb91f9c75 | €15.00 | €0.26 | matched |
| 115 | capture | 01a14502-913d-798c-958a-3f5ad11a30de | €9.00 | €0.19 | matched |
| 116 | capture | 01a14502-a54c-73a5-aee6-b584f93686b5 | €35.00 | €0.50 | matched |
| 117 | capture | 01a14502-b883-74d3-87cb-04a02f8cb8fd | €9.00 | €0.19 | matched |
| 118 | capture | 01a14502-bdad-7754-84ef-c0c9d65c4ca9 | €49.00 | €0.67 | matched |
| 119 | capture | 01a14502-cae7-7803-9db3-06dff73f4bd9 | €9.00 | €0.19 | matched |
| 120 | capture | 01a14502-dc1e-7512-bf2d-a19d75774869 | €35.00 | €0.50 | matched |
| 121 | capture | 01a14502-e50c-7e77-8a7d-e1a73c17da23 | €9.00 | €0.19 | matched |
| 122 | capture | 01a14502-e67d-759e-af7b-957822f1f274 | €15.00 | €0.26 | matched |
| 123 | capture | 01a14502-e93d-7726-a259-58877fc9f4be | €24.00 | €0.37 | matched |
| 124 | refund | 01a14503-0f87-7128-9b15-5077e9046497 | -€4.00 | €0.00 | matched |
| 125 | capture | 01a14503-1a1f-78a8-91c6-03523fb783c3 | €49.00 | €0.67 | matched |