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
- 25 Oct, 00:20107 lines3 breaks
- 25 Oct, 00:10126 lines1 break
- 25 Oct, 00:00126 lines4 breaks
- 24 Oct, 23:50125 lines3 breaks
- 24 Oct, 23:40114 lines7 breaks
- 24 Oct, 23:30149 lines2 breaks
- 24 Oct, 23:20139 lines5 breaks
- 24 Oct, 23:10114 lines2 breaks
- 24 Oct, 23:00135 lines5 breaks
- 24 Oct, 22:50126 lines4 breaks
- 24 Oct, 22:40122 lines1 break
- 24 Oct, 22:30128 lines3 breaks
- 24 Oct, 22:20140 lines4 breaks
- 24 Oct, 22:10127 lines2 breaks
24 Oct, 23:30
Gross
€3,133.00
PSP fee
€50.05
Net to the bank
€3,082.95
Settlement journal
#186845
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a17045-ce02-7165-adda-fd9b8363ee7b is already settled by stl_EUR_2988141 line 96
- fee differencethe fee is not the contract feethe fee is 4, the contract says 0
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 73 | refund | 01a17044-4e70-7458-97bf-ba9f26ea2948 | -€9.00 | €0.04 | fee difference |
| 97 | capture | 01a17045-ce2f-781a-ada6-a7c597501d12 | €15.00 | €0.26 | duplicate line |
| 1 | capture | 01a1703d-44c6-7c77-b85a-531c4d6e2941 | €9.00 | €0.19 | matched |
| 2 | capture | 01a1703f-f6f2-7e93-aad2-fcafbaebf3de | €49.00 | €0.67 | matched |
| 3 | capture | 01a17040-10f2-798a-9b22-3cf6153f3f7b | €49.00 | €0.67 | matched |
| 4 | capture | 01a17040-118c-74dc-9d61-36790b19e663 | €15.00 | €0.26 | matched |
| 5 | capture | 01a17040-18a1-7cae-86c9-92480fffa73b | €15.00 | €0.26 | matched |
| 6 | refund | 01a17040-5e5f-7614-9eab-b27719fe1b8b | -€15.00 | €0.00 | matched |
| 7 | capture | 01a17040-6142-7496-8c4c-3612725f194f | €9.00 | €0.19 | matched |
| 8 | capture | 01a17040-819f-70c3-b5f4-50e80d6b8a39 | €9.00 | €0.19 | matched |
| 9 | capture | 01a17040-909a-7523-b3ff-732e2dc3eaa7 | €49.00 | €0.67 | matched |
| 10 | capture | 01a17040-9af2-7590-9d44-7634ff1955cb | €9.00 | €0.19 | matched |
| 11 | capture | 01a17040-a794-7a71-adf3-db6ae47d33d2 | €15.00 | €0.26 | matched |
| 12 | capture | 01a17040-adc4-7dac-8711-2913825efbca | €15.00 | €0.26 | matched |
| 13 | capture | 01a17040-b7fc-7798-92cc-602533c3d8d7 | €15.00 | €0.26 | matched |
| 14 | capture | 01a17040-bd08-73ff-ba88-9c40f4c60f8d | €9.00 | €0.19 | matched |
| 15 | capture | 01a17040-c69d-7977-b2d7-d3ef1019e903 | €9.00 | €0.19 | matched |
| 16 | capture | 01a17040-d63d-7e85-b1e5-d81b592bb444 | €24.00 | €0.37 | matched |
| 17 | capture | 01a17040-dc7f-74d4-abce-7d89784b0557 | €9.00 | €0.19 | matched |
| 18 | capture | 01a17040-ebec-7e10-9d42-c5ccb96e4cd6 | €15.00 | €0.26 | matched |
| 19 | capture | 01a17041-1b58-7872-bbad-d8c27a1c1e2b | €9.00 | €0.19 | matched |
| 20 | capture | 01a17041-2a15-7625-9fd2-4c8cc924eebc | €15.00 | €0.26 | matched |
| 21 | capture | 01a17041-2b1e-7337-976a-36563332c676 | €9.00 | €0.19 | matched |
| 22 | capture | 01a17041-30fb-7a7e-aae6-4ba8b8766121 | €15.00 | €0.26 | matched |
| 23 | capture | 01a17041-3347-7ed9-aa3c-e36aaeaa813b | €24.00 | €0.37 | matched |
| 24 | capture | 01a17041-40af-7f6f-b0e6-2ebdc64549d2 | €24.00 | €0.37 | matched |
| 25 | capture | 01a17041-49d7-7c8d-93ba-f381fe749c15 | €35.00 | €0.50 | matched |
| 26 | capture | 01a17041-63ff-76e5-ba49-8ebae5dc36aa | €24.00 | €0.37 | matched |
| 27 | capture | 01a17041-75de-7242-a94d-a4325e8ab687 | €9.00 | €0.19 | matched |
| 28 | capture | 01a17041-8415-78bd-8ec0-bb1c65bc78bb | €49.00 | €0.67 | matched |
| 29 | capture | 01a17041-9345-77e4-844b-d2dff01dc0d0 | €49.00 | €0.67 | matched |
| 30 | capture | 01a17041-b363-7496-9998-01f19cd14446 | €35.00 | €0.50 | matched |
| 31 | capture | 01a17041-bcfe-7024-9d62-01a918f48eeb | €9.00 | €0.19 | matched |
| 32 | capture | 01a17041-c8a6-7963-aa55-da9cb20fe69e | €9.00 | €0.19 | matched |
| 33 | capture | 01a17041-ca78-7c33-a218-8fbcd6569d99 | €24.00 | €0.37 | matched |
| 34 | capture | 01a17041-d569-7c5e-bd5a-09102ccc89c4 | €49.00 | €0.67 | matched |
| 35 | capture | 01a17041-d953-72e6-806f-1352468dfe06 | €15.00 | €0.26 | matched |
| 36 | capture | 01a17041-e06c-762e-a27f-5e6ee56e5e6f | €35.00 | €0.50 | matched |
| 37 | capture | 01a17041-e1d5-7283-b6fc-3f0a5352ebfa | €15.00 | €0.26 | matched |
| 38 | capture | 01a17041-e43d-7987-99a5-56e022090938 | €24.00 | €0.37 | matched |
| 39 | capture | 01a17041-e9d9-7700-b44f-303a18cab412 | €35.00 | €0.50 | matched |
| 40 | refund | 01a17042-09db-7959-8aa8-dd730431046a | -€5.00 | €0.00 | matched |
| 41 | capture | 01a17042-18ae-79c9-830a-ec2fa0f2ce3f | €35.00 | €0.50 | matched |
| 42 | capture | 01a17042-1adc-768b-a500-70685bf2e404 | €35.00 | €0.50 | matched |
| 43 | capture | 01a17042-31fb-794b-931c-76aeb8b4fa6a | €15.00 | €0.26 | matched |
| 44 | capture | 01a17042-377c-74cf-af51-07f0f187f74c | €15.00 | €0.26 | matched |
| 45 | capture | 01a17042-4051-7388-b1cf-d1d71157afdb | €35.00 | €0.50 | matched |
| 46 | capture | 01a17042-5162-74cf-a8e8-03c5bf448c92 | €49.00 | €0.67 | matched |
| 47 | capture | 01a17042-5fdf-72d9-9b7c-9feab9c36734 | €15.00 | €0.26 | matched |
| 48 | capture | 01a17042-71c1-7da1-bdcb-38411ae5dc36 | €24.00 | €0.37 | matched |
| 49 | capture | 01a17042-7288-7ffc-8bb2-c64b533f6669 | €9.00 | €0.19 | matched |
| 50 | capture | 01a17042-7297-7065-ac45-9715de7d0e87 | €9.00 | €0.19 | matched |
| 51 | capture | 01a17042-798c-7db5-98e3-ab1255ae6e10 | €9.00 | €0.19 | matched |
| 52 | refund | 01a17042-8eac-766a-865f-e5ad6b441949 | -€5.00 | €0.00 | matched |
| 53 | capture | 01a17042-924f-75b5-a8f0-5d9a998fd3c7 | €49.00 | €0.67 | matched |
| 54 | capture | 01a17042-92f6-76c6-829b-b49b095fd5ac | €9.00 | €0.19 | matched |
| 55 | capture | 01a17042-b052-705f-a68b-a66facb0805f | €9.00 | €0.19 | matched |
| 56 | capture | 01a17042-b6cf-739a-9408-1554c924211a | €24.00 | €0.37 | matched |
| 57 | capture | 01a17043-1f28-795a-9056-a96111330ebd | €15.00 | €0.26 | matched |
| 58 | capture | 01a17043-2382-7161-a224-542e637071e3 | €24.00 | €0.37 | matched |
| 59 | capture | 01a17043-23a3-7ca7-947c-0b2c59eda53e | €15.00 | €0.26 | matched |
| 60 | capture | 01a17043-3aa3-7040-8ad5-fa106a67f477 | €24.00 | €0.37 | matched |
| 61 | capture | 01a17043-5106-7517-87ce-687cd27d8f65 | €15.00 | €0.26 | matched |
| 62 | capture | 01a17043-69d8-7fbf-9f49-ac6aaaffd660 | €9.00 | €0.19 | matched |
| 63 | refund | 01a17043-8723-7201-9cce-7c2451b95fd6 | -€17.00 | €0.00 | matched |
| 64 | refund | 01a17043-8822-7a02-9336-e3c7f00f0c06 | -€6.00 | €0.00 | matched |
| 65 | capture | 01a17043-9c2c-7c5c-934d-c1ae06cc4250 | €15.00 | €0.26 | matched |
| 66 | capture | 01a17043-b2be-7e98-a205-ea397c58fc94 | €15.00 | €0.26 | matched |
| 67 | capture | 01a17043-d702-73c3-a41b-3e40174758c0 | €35.00 | €0.50 | matched |
| 68 | capture | 01a17043-d795-74ef-9f01-e4086ad40f0e | €9.00 | €0.19 | matched |
| 69 | capture | 01a17043-fa5d-73d6-b77e-a2aa22b4952c | €35.00 | €0.50 | matched |
| 70 | capture | 01a17044-020b-7d23-af53-8ced242bd966 | €15.00 | €0.26 | matched |
| 71 | capture | 01a17044-0c7d-700c-9edb-a1b80ec5b345 | €15.00 | €0.26 | matched |
| 72 | capture | 01a17044-3402-7a4b-98ed-dad3e3a76fe5 | €35.00 | €0.50 | matched |
| 74 | capture | 01a17044-5165-74ef-b343-745237365788 | €15.00 | €0.26 | matched |
| 75 | capture | 01a17044-98f2-7f9f-9736-20936ca7946b | €35.00 | €0.50 | matched |
| 76 | capture | 01a17044-a619-7b79-ac7f-400a1440bba6 | €15.00 | €0.26 | matched |
| 77 | refund | 01a17044-b1e8-7c98-9c7d-7e27c262662a | -€6.00 | €0.00 | matched |
| 78 | capture | 01a17044-bfff-7356-a50b-3419e5cd1a98 | €35.00 | €0.50 | matched |
| 79 | capture | 01a17044-c1bb-7a82-bd00-029fded0687c | €9.00 | €0.19 | matched |
| 80 | capture | 01a17044-c25c-7643-a73f-7f150914e9de | €9.00 | €0.19 | matched |
| 81 | capture | 01a17044-de20-7e3c-bc1d-8a4b65b50a26 | €15.00 | €0.26 | matched |
| 82 | capture | 01a17044-f94f-7f7c-add2-efe49ad8487d | €24.00 | €0.37 | matched |
| 83 | capture | 01a17045-0378-7bc9-b529-13ff71415375 | €35.00 | €0.50 | matched |
| 84 | capture | 01a17045-0e63-74ed-9b32-2c303d3c1765 | €35.00 | €0.50 | matched |
| 85 | capture | 01a17045-0f91-7c96-8973-af893d548007 | €15.00 | €0.26 | matched |
| 86 | capture | 01a17045-183d-7e0e-9666-e5da33ace469 | €9.00 | €0.19 | matched |
| 87 | capture | 01a17045-2354-718a-bed5-256378139ad0 | €15.00 | €0.26 | matched |
| 88 | capture | 01a17045-28ce-7192-b086-8b6be8704d38 | €24.00 | €0.37 | matched |
| 89 | refund | 01a17045-2f8a-70c1-a910-b84fb9aba572 | -€8.00 | €0.00 | matched |
| 90 | capture | 01a17045-3a22-7b7d-a301-ba0db086bdf6 | €49.00 | €0.67 | matched |
| 91 | capture | 01a17045-3bc4-7065-8794-a5671e425b16 | €24.00 | €0.37 | matched |
| 92 | capture | 01a17045-3d58-7595-bef0-1286eb63b9af | €24.00 | €0.37 | matched |
| 93 | capture | 01a17045-83f6-7196-8010-4636b2a73e21 | €49.00 | €0.67 | matched |
| 94 | capture | 01a17045-ac79-7248-a82b-72d7973085d9 | €15.00 | €0.26 | matched |
| 95 | capture | 01a17045-b9a8-7554-a65a-d77853a81e3e | €15.00 | €0.26 | matched |
| 96 | capture | 01a17045-ce2f-781a-ada6-a7c597501d12 | €15.00 | €0.26 | matched |
| 98 | capture | 01a17045-cf79-741a-a08c-88858d070642 | €9.00 | €0.19 | matched |
| 99 | capture | 01a17046-0fc6-73cd-9f2e-562d5c059c48 | €24.00 | €0.37 | matched |
| 100 | capture | 01a17046-374b-73f7-9a51-f59f28b2bd81 | €35.00 | €0.50 | matched |
| 101 | capture | 01a17046-3be1-7138-a62c-534ef8378e94 | €49.00 | €0.67 | matched |
| 102 | refund | 01a17046-3dbe-710c-ac76-8faba122923f | -€8.00 | €0.00 | matched |
| 103 | capture | 01a17046-4dc5-7cbc-9159-0b301fa0c4ec | €49.00 | €0.67 | matched |
| 104 | capture | 01a17046-61e9-7cf6-a8cd-a283ca10a2f9 | €15.00 | €0.26 | matched |
| 105 | capture | 01a17046-78ad-718b-b87a-607a1d4077e9 | €9.00 | €0.19 | matched |
| 106 | capture | 01a17046-7a68-7aa0-a7a4-114a704b2118 | €24.00 | €0.37 | matched |
| 107 | capture | 01a17046-88f2-78f7-87bc-1e5c2a470d95 | €9.00 | €0.19 | matched |
| 108 | capture | 01a17046-a0b6-72a0-970e-d2a159c59abb | €24.00 | €0.37 | matched |
| 109 | capture | 01a17046-a7a5-7147-a177-78d2fb022d11 | €9.00 | €0.19 | matched |
| 110 | capture | 01a17046-b667-708c-9d44-8f463b5c3c5f | €35.00 | €0.50 | matched |
| 111 | capture | 01a17046-e61a-75e5-8aa4-031ec286108f | €9.00 | €0.19 | matched |
| 112 | capture | 01a17046-f43b-7a77-ad34-4af300825fd5 | €35.00 | €0.50 | matched |
| 113 | capture | 01a17047-09f3-7e01-af9f-0f9442f83a8b | €49.00 | €0.67 | matched |
| 114 | capture | 01a17047-1e25-7859-b1fa-57eba771ef87 | €9.00 | €0.19 | matched |
| 115 | capture | 01a17047-3936-7b4e-99f7-8623f137c327 | €49.00 | €0.67 | matched |
| 116 | capture | 01a17047-3bfc-7660-b8ed-a44f65dcd53b | €9.00 | €0.19 | matched |
| 117 | capture | 01a17047-3dd7-75fb-966c-fa1c60915896 | €15.00 | €0.26 | matched |
| 118 | capture | 01a17047-4d13-7d6f-9975-657d81885421 | €35.00 | €0.50 | matched |
| 119 | refund | 01a17047-4ebe-730c-8c91-073838eaa137 | -€2.00 | €0.00 | matched |
| 120 | capture | 01a17047-4f0f-7fda-b38b-fddb4621fbb5 | €24.00 | €0.37 | matched |
| 121 | capture | 01a17047-51d1-79ca-b3ed-530f4326d223 | €15.00 | €0.26 | matched |
| 122 | capture | 01a17047-61d5-76a6-8f66-fdaed6cc7c57 | €24.00 | €0.37 | matched |
| 123 | capture | 01a17047-6b58-7cdc-9555-4a9660dc7015 | €35.00 | €0.50 | matched |
| 124 | capture | 01a17047-77d7-79b9-84b9-31f643bb1f59 | €15.00 | €0.26 | matched |
| 125 | capture | 01a17047-85a8-7835-9e53-193814578685 | €15.00 | €0.26 | matched |
| 126 | capture | 01a17047-86aa-7989-97ad-b91f04b2ae65 | €35.00 | €0.50 | matched |
| 127 | capture | 01a17047-8cc7-7547-814a-531bdafca56d | €15.00 | €0.26 | matched |
| 128 | capture | 01a17047-8cc9-7a9a-b395-1fe6d834718b | €49.00 | €0.67 | matched |
| 129 | capture | 01a17047-9505-7998-908b-9f268df58e7b | €35.00 | €0.50 | matched |
| 130 | capture | 01a17047-99ad-7082-bb32-2867ba76375a | €49.00 | €0.67 | matched |
| 131 | capture | 01a17047-9aa3-7e52-9865-49bdf3342bfd | €15.00 | €0.26 | matched |
| 132 | capture | 01a17047-a268-7234-a9af-577152cf099c | €24.00 | €0.37 | matched |
| 133 | capture | 01a17047-aa34-72fa-9948-33e2bd6ac3a9 | €49.00 | €0.67 | matched |
| 134 | capture | 01a17047-c78c-7f34-91cf-9f82fa2a8b69 | €35.00 | €0.50 | matched |
| 135 | capture | 01a17047-cce5-76bf-b72e-42eff8cd3ca9 | €15.00 | €0.26 | matched |
| 136 | refund | 01a17047-ff19-75a4-a1ff-47ded0bcb64e | -€22.00 | €0.00 | matched |
| 137 | capture | 01a17048-09f5-709c-86c0-e49f9534c66f | €15.00 | €0.26 | matched |
| 138 | capture | 01a17048-0b03-791e-84c8-d18782a7570f | €15.00 | €0.26 | matched |
| 139 | capture | 01a17048-42fe-78e1-ac12-23fb26114e90 | €15.00 | €0.26 | matched |
| 140 | capture | 01a17048-5a65-7a8f-8305-607206cd4ca3 | €35.00 | €0.50 | matched |
| 141 | capture | 01a17048-698e-78c9-99e5-30561c9741b4 | €9.00 | €0.19 | matched |
| 142 | capture | 01a17048-852b-7f49-b3df-b995bc16533c | €49.00 | €0.67 | matched |
| 143 | capture | 01a17048-8994-705e-a685-9f2f19dc83e3 | €35.00 | €0.50 | matched |
| 144 | capture | 01a17048-99c1-736f-82af-3ba4612e4685 | €49.00 | €0.67 | matched |
| 145 | capture | 01a17048-b222-7152-a11a-a165ea558565 | €15.00 | €0.26 | matched |
| 146 | capture | 01a17048-b996-715e-82d4-9aaf9e773836 | €35.00 | €0.50 | matched |
| 147 | capture | 01a17048-be68-71e6-9b35-98f599eaec5c | €35.00 | €0.50 | matched |
| 148 | capture | 01a17048-e1f2-788e-a9f6-3a11b3e56049 | €15.00 | €0.26 | matched |
| 149 | capture | 01a17048-e6e8-7e95-822b-e605e42b37ca | €15.00 | €0.26 | matched |