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, 02:00112 lines2 breaks
- 19 Oct, 01:50119 lines1 break
- 19 Oct, 01:40109 lines8 breaks
- 19 Oct, 01:30115 lines1 break
- 19 Oct, 01:20108 lines2 breaks
- 19 Oct, 01:10128 lines2 breaks
- 19 Oct, 01:00128 lines4 breaks
- 19 Oct, 00:50108 lines3 breaks
- 19 Oct, 00:40142 lines4 breaks
- 19 Oct, 00:30138 lines1 break
- 19 Oct, 00:2088 lines3 breaks
- 19 Oct, 00:10122 linesclean
- 19 Oct, 00:00120 lines2 breaks
- 18 Oct, 23:50135 lines3 breaks
19 Oct, 00:40
Gross
€3,359.00
PSP fee
€53.52
Net to the bank
€3,305.48
Settlement journal
#78314
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1519a-8bcc-74a5-a94a-1c0246d7bca7 is already settled by stl_EUR_2987284 line 17
- duplicate linethe file lists it twicecapture:01a151a0-1b50-75d0-98f1-e60acd3c6974 is already settled by stl_EUR_2987284 line 91
- fee differencethe fee is not the contract feethe fee is 54, the contract says 50
- missing linein the books, not in the filerefund:01a1519f-14cf-7aba-97bb-e30f4cdf033d is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 18 | capture | 01a1519a-8c0a-7f73-91e0-ff6a52379362 | €24.00 | €0.37 | duplicate line |
| 92 | capture | 01a151a0-1b83-717f-98a5-a724c95fba43 | €15.00 | €0.26 | duplicate line |
| 104 | capture | 01a151a0-dece-7bf4-a969-9bc87e6a948c | €35.00 | €0.54 | fee difference |
| 1 | capture | 01a15196-f199-78b4-8160-39310fc886c2 | €35.00 | €0.50 | matched |
| 2 | capture | 01a15198-0fbb-77dc-a3bb-7b2e5bdfbc72 | €9.00 | €0.19 | matched |
| 3 | capture | 01a15198-5f2b-73a4-adbb-e9540c6992b6 | €35.00 | €0.50 | matched |
| 4 | capture | 01a15198-6ab9-716c-a72b-f3fbbc65df6e | €24.00 | €0.37 | matched |
| 5 | capture | 01a15198-d2ce-7748-bd0d-4c831bb374e2 | €49.00 | €0.67 | matched |
| 6 | capture | 01a15199-e383-7a6c-8190-77488052055e | €24.00 | €0.37 | matched |
| 7 | capture | 01a1519a-0a9b-7350-9ddf-21d03a8237e8 | €24.00 | €0.37 | matched |
| 8 | capture | 01a1519a-1114-79a0-a6a2-dcb0285e249a | €15.00 | €0.26 | matched |
| 9 | refund | 01a1519a-239f-70d4-9d8c-8a66852783d7 | -€17.00 | €0.00 | matched |
| 10 | capture | 01a1519a-33f3-7e31-b961-c6c7d7b86396 | €35.00 | €0.50 | matched |
| 11 | capture | 01a1519a-3fb6-7c06-b865-fcf770774049 | €24.00 | €0.37 | matched |
| 12 | capture | 01a1519a-4b03-78fa-a32e-607ddacbb616 | €9.00 | €0.19 | matched |
| 13 | capture | 01a1519a-5545-715e-8e4e-81b3b6311283 | €49.00 | €0.67 | matched |
| 14 | capture | 01a1519a-5c81-77d5-803b-385132f26081 | €9.00 | €0.19 | matched |
| 15 | capture | 01a1519a-7dd5-74ed-aa30-5f576800db96 | €15.00 | €0.26 | matched |
| 16 | capture | 01a1519a-7e0f-7a4a-ae6e-353459c5f4d9 | €9.00 | €0.19 | matched |
| 17 | capture | 01a1519a-8c0a-7f73-91e0-ff6a52379362 | €24.00 | €0.37 | matched |
| 19 | capture | 01a1519a-8f42-71db-8221-08fbb0b88ca9 | €15.00 | €0.26 | matched |
| 20 | capture | 01a1519a-93dc-7ff0-b0fd-02dde7fe2524 | €9.00 | €0.19 | matched |
| 21 | capture | 01a1519a-aec8-737f-8f72-f5dd77da8017 | €9.00 | €0.19 | matched |
| 22 | capture | 01a1519a-b5d5-70cc-a902-261dc9b76a80 | €24.00 | €0.37 | matched |
| 23 | capture | 01a1519a-c415-76cb-9033-f87f300923e4 | €24.00 | €0.37 | matched |
| 24 | capture | 01a1519a-fa37-75f6-855b-403d6a52f8ac | €35.00 | €0.50 | matched |
| 25 | capture | 01a1519b-05c7-7eaa-ad32-3656ae5c5677 | €49.00 | €0.67 | matched |
| 26 | capture | 01a1519b-421a-738c-aa77-ac6580fa5ae4 | €24.00 | €0.37 | matched |
| 27 | capture | 01a1519b-4dac-788d-870d-62490b2ea4d4 | €24.00 | €0.37 | matched |
| 28 | capture | 01a1519b-5c64-726d-8da2-92f3db837fb0 | €35.00 | €0.50 | matched |
| 29 | capture | 01a1519b-5ea3-7964-8229-a32cdb663b0c | €49.00 | €0.67 | matched |
| 30 | capture | 01a1519b-6436-7c03-bccc-61f53148a38a | €49.00 | €0.67 | matched |
| 31 | capture | 01a1519b-6a93-73c7-af13-0e6e6a213b9f | €24.00 | €0.37 | matched |
| 32 | capture | 01a1519b-7ce7-7ffa-81f1-96b68ad92ba9 | €9.00 | €0.19 | matched |
| 33 | capture | 01a1519b-80c6-7d34-bc2e-5c308d357e2b | €9.00 | €0.19 | matched |
| 34 | capture | 01a1519b-9f11-7638-9963-6038d3757b76 | €9.00 | €0.19 | matched |
| 35 | capture | 01a1519b-ad43-7f0a-a2a4-722abd606879 | €9.00 | €0.19 | matched |
| 36 | capture | 01a1519b-affc-7717-8467-38f7b6f90eaf | €24.00 | €0.37 | matched |
| 37 | capture | 01a1519b-b8a3-7231-b026-8523c71677fd | €35.00 | €0.50 | matched |
| 38 | capture | 01a1519b-c16a-7f25-b446-08b8b259ed42 | €24.00 | €0.37 | matched |
| 39 | capture | 01a1519b-cbfb-7cc5-8fad-e271db6b4e49 | €35.00 | €0.50 | matched |
| 40 | capture | 01a1519b-e617-7d71-b285-769ba1f470b2 | €9.00 | €0.19 | matched |
| 41 | capture | 01a1519c-11a6-7ce5-91f3-ac9bc2137ba6 | €24.00 | €0.37 | matched |
| 42 | capture | 01a1519c-2de7-7157-b81a-c0a8658369b1 | €35.00 | €0.50 | matched |
| 43 | capture | 01a1519c-2e34-7e9d-b2df-9ed313eda127 | €9.00 | €0.19 | matched |
| 44 | capture | 01a1519c-4051-760c-8848-18eb492d3561 | €9.00 | €0.19 | matched |
| 45 | capture | 01a1519c-4228-77df-907c-b62a3f961c7e | €49.00 | €0.67 | matched |
| 46 | capture | 01a1519c-4ef4-7aa8-9238-198e2666cdb1 | €15.00 | €0.26 | matched |
| 47 | capture | 01a1519c-527a-7e58-befd-111f587b1a83 | €24.00 | €0.37 | matched |
| 48 | capture | 01a1519c-6a2b-7ccf-95f8-839ecc35a605 | €15.00 | €0.26 | matched |
| 49 | capture | 01a1519c-6ace-706b-bad7-d111f899a5d7 | €49.00 | €0.67 | matched |
| 50 | capture | 01a1519c-7f7f-762b-8068-c43bbab40353 | €9.00 | €0.19 | matched |
| 51 | capture | 01a1519c-8fcf-7a0f-8da1-64e130a8b5a4 | €35.00 | €0.50 | matched |
| 52 | capture | 01a1519c-917c-7c80-ae8b-91d3312ac29b | €15.00 | €0.26 | matched |
| 53 | capture | 01a1519c-9efb-73e1-9779-fd3433cf64b1 | €15.00 | €0.26 | matched |
| 54 | capture | 01a1519c-adac-7f4e-88b2-66ce81e44e17 | €15.00 | €0.26 | matched |
| 55 | capture | 01a1519c-b053-79b0-9eca-dd69c30b91fb | €35.00 | €0.50 | matched |
| 56 | capture | 01a1519c-b889-7ea2-81ef-6c459eec448e | €35.00 | €0.50 | matched |
| 57 | capture | 01a1519c-d3cf-7232-94e8-3fe26bcac7e1 | €24.00 | €0.37 | matched |
| 58 | capture | 01a1519c-f6c7-7ffe-ba01-a5f0e35df150 | €15.00 | €0.26 | matched |
| 59 | capture | 01a1519d-21e3-70e5-96e3-54851bdc0cbd | €24.00 | €0.37 | matched |
| 60 | capture | 01a1519d-8d6e-785b-8715-6a340f1ebb7c | €49.00 | €0.67 | matched |
| 61 | capture | 01a1519d-df84-759f-8a5d-66786c6e7260 | €15.00 | €0.26 | matched |
| 62 | capture | 01a1519d-f1ce-79e0-a9f3-b0ba3f94afdf | €15.00 | €0.26 | matched |
| 63 | capture | 01a1519e-09ce-7681-9818-456190ac77c7 | €24.00 | €0.37 | matched |
| 64 | capture | 01a1519e-24bd-791e-a559-891dd5aacd64 | €49.00 | €0.67 | matched |
| 65 | capture | 01a1519e-38ee-75ff-af3e-11ece33853b0 | €35.00 | €0.50 | matched |
| 66 | capture | 01a1519e-4108-7f88-817b-9d59b6df6b49 | €35.00 | €0.50 | matched |
| 67 | refund | 01a1519e-4f47-7887-9734-960c11fb0c85 | -€5.00 | €0.00 | matched |
| 68 | capture | 01a1519e-5143-79eb-a5c4-8e0bb6b543e8 | €35.00 | €0.50 | matched |
| 69 | capture | 01a1519e-714c-7125-85f7-d2ab87e4302e | €9.00 | €0.19 | matched |
| 70 | capture | 01a1519e-b0da-7dde-a188-fec184134960 | €24.00 | €0.37 | matched |
| 71 | capture | 01a1519e-bce9-7963-9139-cd52d33e2b27 | €49.00 | €0.67 | matched |
| 72 | capture | 01a1519e-c32e-7fb7-889f-f60019321b56 | €24.00 | €0.37 | matched |
| 73 | capture | 01a1519e-e077-7fb0-b719-a0d676b16d47 | €35.00 | €0.50 | matched |
| 74 | capture | 01a1519e-e377-7985-8986-f2550e028549 | €15.00 | €0.26 | matched |
| 75 | capture | 01a1519e-eab2-77e0-81c7-53ff1d12a4f3 | €35.00 | €0.50 | matched |
| 76 | capture | 01a1519f-11a1-7bb7-bf50-76b08ace25a2 | €24.00 | €0.37 | matched |
| 77 | capture | 01a1519f-1b85-7427-920f-337fff1b824d | €24.00 | €0.37 | matched |
| 78 | refund | 01a1519f-33cd-751e-b6de-8cd21d306f36 | -€33.00 | €0.00 | matched |
| 79 | capture | 01a1519f-3fc1-7226-9a60-1b6869d72189 | €49.00 | €0.67 | matched |
| 80 | capture | 01a1519f-48bb-79fe-a305-1fa1fbaeca10 | €49.00 | €0.67 | matched |
| 81 | capture | 01a1519f-4950-75ba-b96c-a30c15b86dcf | €15.00 | €0.26 | matched |
| 82 | capture | 01a1519f-60c4-7436-8282-9f44bcca67c2 | €35.00 | €0.50 | matched |
| 83 | capture | 01a1519f-6213-728d-b4c4-a891311192ed | €15.00 | €0.26 | matched |
| 84 | capture | 01a1519f-877a-7256-8ebe-9b1b3a6ffa70 | €15.00 | €0.26 | matched |
| 85 | capture | 01a1519f-a7b2-7a17-8593-0f3856defbfe | €35.00 | €0.50 | matched |
| 86 | capture | 01a1519f-b0c5-7ef1-9597-c8651ba5ab2d | €15.00 | €0.26 | matched |
| 87 | capture | 01a1519f-d788-7458-96dc-1c5c53645e42 | €49.00 | €0.67 | matched |
| 88 | capture | 01a1519f-f0ce-73dd-b1ac-8ebb52035fd2 | €9.00 | €0.19 | matched |
| 89 | capture | 01a1519f-f343-7a1b-906b-3e0feae3ec12 | €35.00 | €0.50 | matched |
| 90 | capture | 01a151a0-0019-792d-819c-4552eb39ee15 | €24.00 | €0.37 | matched |
| 91 | capture | 01a151a0-1b83-717f-98a5-a724c95fba43 | €15.00 | €0.26 | matched |
| 93 | capture | 01a151a0-217a-71a2-9424-c2fc18dd8fb6 | €15.00 | €0.26 | matched |
| 94 | capture | 01a151a0-4469-771d-90b5-510563ad2858 | €49.00 | €0.67 | matched |
| 95 | capture | 01a151a0-6058-7dfc-b401-a3ecb6bb5750 | €49.00 | €0.67 | matched |
| 96 | capture | 01a151a0-6230-7ed4-8f95-e91c6a00f24a | €24.00 | €0.37 | matched |
| 97 | capture | 01a151a0-696d-7114-9b74-37783122ed19 | €35.00 | €0.50 | matched |
| 98 | capture | 01a151a0-8a9d-73cd-80eb-466738f1cafa | €9.00 | €0.19 | matched |
| 99 | capture | 01a151a0-8c33-797e-9c3e-bd3c63bea644 | €24.00 | €0.37 | matched |
| 100 | capture | 01a151a0-8fba-728c-a4dc-d8046b6ccaa9 | €9.00 | €0.19 | matched |
| 101 | capture | 01a151a0-97d5-789b-8e28-8c62e025aae3 | €9.00 | €0.19 | matched |
| 102 | capture | 01a151a0-9b60-7ee9-bab9-4612bf31184b | €35.00 | €0.50 | matched |
| 103 | capture | 01a151a0-d186-747c-974a-5ee62fe93d42 | €9.00 | €0.19 | matched |
| 105 | capture | 01a151a0-e1c1-769e-8171-0fe8c268754f | €15.00 | €0.26 | matched |
| 106 | capture | 01a151a1-0dc2-7604-ad29-9985c824deca | €49.00 | €0.67 | matched |
| 107 | capture | 01a151a1-0dec-7269-83ff-0301f09bf587 | €9.00 | €0.19 | matched |
| 108 | capture | 01a151a1-134d-70c1-8f9b-af7dbb7e06cd | €24.00 | €0.37 | matched |
| 109 | capture | 01a151a1-22b1-7e6d-a28e-2cdb99fdfff5 | €49.00 | €0.67 | matched |
| 110 | capture | 01a151a1-356c-76bc-be29-67ed4b8d595c | €9.00 | €0.19 | matched |
| 111 | capture | 01a151a1-3ebd-74a5-8a38-f2c9889565d2 | €49.00 | €0.67 | matched |
| 112 | capture | 01a151a1-416b-7ca9-aa70-c5e9e212e1a6 | €49.00 | €0.67 | matched |
| 113 | refund | 01a151a1-4e78-7852-9251-8c0976abddca | -€34.00 | €0.00 | matched |
| 114 | capture | 01a151a1-51df-7442-8ff5-b05691c76c2c | €35.00 | €0.50 | matched |
| 115 | capture | 01a151a1-625f-76ea-8430-c97b27f9d113 | €35.00 | €0.50 | matched |
| 116 | refund | 01a151a1-6bad-7d87-8b56-75d0fdce8cc9 | -€24.00 | €0.00 | matched |
| 117 | capture | 01a151a1-90ba-73cc-bb33-d50955ad7b6b | €49.00 | €0.67 | matched |
| 118 | refund | 01a151a1-9a7f-780c-8428-5d13dec2427c | -€12.00 | €0.00 | matched |
| 119 | capture | 01a151a1-a328-79ec-92d7-ae422c8aaebf | €35.00 | €0.50 | matched |
| 120 | refund | 01a151a1-a5e2-726e-bbc4-28812570f53a | -€18.00 | €0.00 | matched |
| 121 | capture | 01a151a1-b444-77b2-a677-4390a09c6d73 | €9.00 | €0.19 | matched |
| 122 | capture | 01a151a1-bbcf-7890-841f-bb9ff0534cb9 | €15.00 | €0.26 | matched |
| 123 | capture | 01a151a1-dcb4-781d-98a5-5d727d118f11 | €15.00 | €0.26 | matched |
| 124 | refund | 01a151a1-e1f6-76b6-99a5-358e7d59df37 | -€48.00 | €0.00 | matched |
| 125 | capture | 01a151a2-0fbd-7513-a50f-8f0b11b38afa | €24.00 | €0.37 | matched |
| 126 | capture | 01a151a2-1137-7246-9b5f-a9a6fb21a29f | €24.00 | €0.37 | matched |
| 127 | capture | 01a151a2-1ed1-75af-abc4-214e45c1f5af | €49.00 | €0.67 | matched |
| 128 | capture | 01a151a2-5784-757e-8b43-a9943de49552 | €49.00 | €0.67 | matched |
| 129 | capture | 01a151a2-5d0a-7f13-b88d-bc48f793f06b | €24.00 | €0.37 | matched |
| 130 | capture | 01a151a2-7873-7aae-9323-2cf8095fdbf6 | €35.00 | €0.50 | matched |
| 131 | capture | 01a151a2-78d4-7509-bb02-1ef8fa3a2c64 | €15.00 | €0.26 | matched |
| 132 | capture | 01a151a2-9672-7b64-8522-02f03d3befe4 | €35.00 | €0.50 | matched |
| 133 | capture | 01a151a2-98f0-7364-ba26-364c58492fd7 | €9.00 | €0.19 | matched |
| 134 | capture | 01a151a2-9b4f-73b1-9d29-f6d5c1d45749 | €35.00 | €0.50 | matched |
| 135 | capture | 01a151a2-aec0-7734-b4f8-df2f579ef5da | €15.00 | €0.26 | matched |
| 136 | capture | 01a151a2-af5d-72b6-b068-113e1fda3d00 | €35.00 | €0.50 | matched |
| 137 | capture | 01a151a2-b160-741e-9204-8e748938f7b7 | €15.00 | €0.26 | matched |
| 138 | capture | 01a151a2-bdfc-72ef-82d5-c14056b831fb | €24.00 | €0.37 | matched |
| 139 | capture | 01a151a2-d361-7b56-aa38-8c59af3af840 | €24.00 | €0.37 | matched |
| 140 | capture | 01a151a2-e9b2-74e5-97f7-56e0cbf448ee | €24.00 | €0.37 | matched |
| 141 | capture | 01a151a2-eb41-72b0-aa8a-50bb1fcf30f0 | €49.00 | €0.67 | matched |
| 142 | capture | 01a151a2-fb3f-703f-bc80-f2cf0bc05528 | €49.00 | €0.67 | matched |