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
- 20 Oct, 16:00132 lines3 breaks
- 20 Oct, 15:50125 lines1 break
- 20 Oct, 15:40109 linesclean
- 20 Oct, 15:3094 lines5 breaks
- 20 Oct, 15:20121 lines1 break
- 20 Oct, 15:10131 lines1 break
- 20 Oct, 15:00129 lines3 breaks
- 20 Oct, 14:50121 lines4 breaks
- 20 Oct, 14:40117 lines2 breaks
- 20 Oct, 14:30130 lines1 break
- 20 Oct, 14:20123 lines1 break
- 20 Oct, 14:10135 lines2 breaks
- 20 Oct, 14:00119 lines2 breaks
- 20 Oct, 13:50139 lines3 breaks
20 Oct, 14:50
Gross
€2,726.00
PSP fee
€43.19
Net to the bank
€2,682.81
Settlement journal
#107125
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a159ca-8f2a-701a-bedb-7e053de53327 is already settled by stl_EUR_2987513 line 4
- missing linein the books, not in the filecapture:01a159cb-76e0-7863-bf37-0b6fb63f29b1 is in no file
- missing linein the books, not in the filecapture:01a159cb-c024-7a7d-821d-46df2bfc9f18 is in no file
- missing linein the books, not in the filecapture:01a159d0-a354-7f86-aaa8-c4c009489749 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 5 | capture | 01a159ca-8f75-773b-a40d-d55105122cd7 | €49.00 | €0.67 | duplicate line |
| 1 | refund | 01a159c6-422e-7f4b-9561-75572a7e2fca | -€7.00 | €0.00 | matched |
| 2 | capture | 01a159c7-5752-72c4-a0c3-b7960a219a9b | €9.00 | €0.19 | matched |
| 3 | capture | 01a159c9-bc83-7f4b-a1e2-468763e8f36b | €35.00 | €0.50 | matched |
| 4 | capture | 01a159ca-8f75-773b-a40d-d55105122cd7 | €49.00 | €0.67 | matched |
| 6 | capture | 01a159ca-a28b-74ed-acc2-1a42455da042 | €24.00 | €0.37 | matched |
| 7 | refund | 01a159ca-a668-783c-a52a-4726526b75ef | -€7.00 | €0.00 | matched |
| 8 | capture | 01a159ca-b0b0-7828-bcc2-c1e810dec283 | €15.00 | €0.26 | matched |
| 9 | capture | 01a159ca-e697-7900-ad2d-494a002da1a2 | €35.00 | €0.50 | matched |
| 10 | capture | 01a159ca-e84b-7784-ad02-545181968aed | €9.00 | €0.19 | matched |
| 11 | capture | 01a159ca-fc4b-7c77-ac60-95e15f301fe1 | €35.00 | €0.50 | matched |
| 12 | refund | 01a159cb-07ec-72b0-8c59-74e85cb45135 | -€18.00 | €0.00 | matched |
| 13 | capture | 01a159cb-3919-7a28-970b-6d489c53fb70 | €9.00 | €0.19 | matched |
| 14 | refund | 01a159cb-51a0-73b2-b1b0-2a1cc21b6a23 | -€5.00 | €0.00 | matched |
| 15 | capture | 01a159cb-79a2-77b5-a39e-374fc72315b1 | €24.00 | €0.37 | matched |
| 16 | capture | 01a159cb-88b9-7ed9-88c5-10c6af54c78a | €15.00 | €0.26 | matched |
| 17 | capture | 01a159cb-8a22-7e31-8f96-73a904a0651f | €9.00 | €0.19 | matched |
| 18 | capture | 01a159cb-9988-73f5-b019-c3d8e0316451 | €49.00 | €0.67 | matched |
| 19 | capture | 01a159cb-9a95-73e1-ae27-06e8f06463d8 | €35.00 | €0.50 | matched |
| 20 | capture | 01a159cb-be50-7926-9b63-eb8806e06c41 | €24.00 | €0.37 | matched |
| 21 | capture | 01a159cb-d44f-7ef5-9896-a2accb5e9f02 | €49.00 | €0.67 | matched |
| 22 | capture | 01a159cb-ce90-717f-bb53-6aa5f94402a7 | €15.00 | €0.26 | matched |
| 23 | capture | 01a159cb-dadd-77e1-933d-0475abc3fb37 | €49.00 | €0.67 | matched |
| 24 | capture | 01a159cb-dbc7-75e9-991c-6990d9c054f1 | €35.00 | €0.50 | matched |
| 25 | capture | 01a159cb-ff4d-74d5-a69b-2382285e916f | €9.00 | €0.19 | matched |
| 26 | capture | 01a159cc-168f-79a3-ac5e-b8e2f894e1ba | €35.00 | €0.50 | matched |
| 27 | capture | 01a159cc-1bf2-7001-a4b2-6efe4bb967da | €24.00 | €0.37 | matched |
| 28 | capture | 01a159cc-2342-7606-b1f6-dcf93a0c50e8 | €15.00 | €0.26 | matched |
| 29 | capture | 01a159cc-2d9e-7db1-9090-3d22c69a2e92 | €35.00 | €0.50 | matched |
| 30 | capture | 01a159cc-309b-725e-8231-df29b8990fce | €49.00 | €0.67 | matched |
| 31 | capture | 01a159cc-3b24-750a-b0ac-2ff3c87fcd4c | €24.00 | €0.37 | matched |
| 32 | capture | 01a159cc-5669-73a5-9c67-e0c3827e66ca | €9.00 | €0.19 | matched |
| 33 | capture | 01a159cc-885a-7084-96fc-97512ebe90b4 | €24.00 | €0.37 | matched |
| 34 | capture | 01a159cc-ad7e-736b-81c8-1a05a5221c9d | €9.00 | €0.19 | matched |
| 35 | capture | 01a159cc-dd88-70e2-b718-2b893c1106ac | €24.00 | €0.37 | matched |
| 36 | capture | 01a159cc-e453-7b4b-8187-28b9f51c5477 | €9.00 | €0.19 | matched |
| 37 | capture | 01a159cc-ec85-7057-9d62-0f67a0d064b5 | €35.00 | €0.50 | matched |
| 38 | capture | 01a159cc-fce8-732c-b98d-b1a59e570524 | €35.00 | €0.50 | matched |
| 39 | capture | 01a159cd-03b9-7ee9-8134-7656d40f8d3b | €9.00 | €0.19 | matched |
| 40 | capture | 01a159cd-0544-7dfe-892f-b458a4332139 | €15.00 | €0.26 | matched |
| 41 | capture | 01a159cd-1c16-7451-8fe2-066c1d57879a | €15.00 | €0.26 | matched |
| 42 | capture | 01a159cd-22b5-738b-9606-ba2c4662612e | €49.00 | €0.67 | matched |
| 43 | capture | 01a159cd-3a27-77a3-b884-836ce01559aa | €9.00 | €0.19 | matched |
| 44 | capture | 01a159cd-6c30-75a7-9306-6a118b497f3d | €15.00 | €0.26 | matched |
| 45 | capture | 01a159cd-aee9-7774-8284-7d96befbaef6 | €49.00 | €0.67 | matched |
| 46 | capture | 01a159cd-dd29-705f-aba6-458ddf500173 | €24.00 | €0.37 | matched |
| 47 | capture | 01a159cd-ec32-746e-a985-ea956163575d | €35.00 | €0.50 | matched |
| 48 | capture | 01a159cd-f650-72e5-887c-95c7321022f9 | €24.00 | €0.37 | matched |
| 49 | capture | 01a159cd-fb88-737e-b2e5-7976670f37f8 | €49.00 | €0.67 | matched |
| 50 | capture | 01a159ce-0fc9-74f5-b680-c0e55c702a80 | €15.00 | €0.26 | matched |
| 51 | capture | 01a159ce-1c5d-7226-aeb8-a94a99bca77f | €9.00 | €0.19 | matched |
| 52 | capture | 01a159ce-2113-7d1a-9570-62b6b27ab0cb | €35.00 | €0.50 | matched |
| 53 | capture | 01a159ce-41f9-78a6-a7c7-b7900ba0ffb3 | €49.00 | €0.67 | matched |
| 54 | capture | 01a159ce-4290-7625-be03-df697006a48b | €9.00 | €0.19 | matched |
| 55 | capture | 01a159ce-6dfd-71c6-b694-a2e9d24d6587 | €35.00 | €0.50 | matched |
| 56 | capture | 01a159ce-7074-7dba-b182-873b3b9d58d1 | €9.00 | €0.19 | matched |
| 57 | capture | 01a159ce-73f9-7d62-a9ff-30485f0447c5 | €15.00 | €0.26 | matched |
| 58 | capture | 01a159ce-88c3-75c6-be3e-f5cbadc2e544 | €24.00 | €0.37 | matched |
| 59 | capture | 01a159ce-8a9d-7f3c-87b6-7c3166eefce6 | €49.00 | €0.67 | matched |
| 60 | capture | 01a159ce-920b-7e71-8fa3-6fe00c7f6113 | €15.00 | €0.26 | matched |
| 61 | capture | 01a159ce-b1b1-7305-9132-5f3729ce78f4 | €15.00 | €0.26 | matched |
| 62 | capture | 01a159ce-b1cf-7cc7-9f3b-4cf747230ac3 | €35.00 | €0.50 | matched |
| 63 | capture | 01a159ce-b328-7f6d-8f0f-d5a8e47e513c | €35.00 | €0.50 | matched |
| 64 | capture | 01a159ce-c0f4-741c-ac93-388400054c88 | €49.00 | €0.67 | matched |
| 65 | capture | 01a159ce-d239-74b2-9e8c-d2cd2281096d | €24.00 | €0.37 | matched |
| 66 | capture | 01a159ce-d551-7472-acc2-e639bc6c0926 | €24.00 | €0.37 | matched |
| 67 | capture | 01a159ce-fb78-7018-9a39-61a2571652f9 | €49.00 | €0.67 | matched |
| 68 | refund | 01a159cf-0270-74c9-b482-9e4f494febc7 | -€5.00 | €0.00 | matched |
| 69 | refund | 01a159cf-054a-7360-8b36-1e2e9b4e2f07 | -€40.00 | €0.00 | matched |
| 70 | capture | 01a159cf-0d1d-7976-ae58-de3500477ab4 | €35.00 | €0.50 | matched |
| 71 | capture | 01a159cf-0ece-70f9-bc1c-9c380ea15a6d | €9.00 | €0.19 | matched |
| 72 | capture | 01a159cf-1b68-7bef-ab9b-78c9aef211ea | €9.00 | €0.19 | matched |
| 73 | capture | 01a159cf-2bfa-79b7-aacb-35f6f7742358 | €35.00 | €0.50 | matched |
| 74 | capture | 01a159cf-5134-75d8-b645-ad3d257dfd76 | €24.00 | €0.37 | matched |
| 75 | capture | 01a159cf-8f98-75b0-acd1-f493e6cf43e2 | €15.00 | €0.26 | matched |
| 76 | capture | 01a159cf-b458-7b55-a3ab-2b2403a47003 | €49.00 | €0.67 | matched |
| 77 | capture | 01a159cf-b4e6-72db-932a-7d0f275f11ed | €24.00 | €0.37 | matched |
| 78 | capture | 01a159cf-bca4-769e-8b26-58f4ef39260b | €9.00 | €0.19 | matched |
| 79 | capture | 01a159cf-c95a-7382-9993-1687d42249c4 | €24.00 | €0.37 | matched |
| 80 | capture | 01a159cf-ec0c-7db6-89a0-88c5ec80ec7b | €15.00 | €0.26 | matched |
| 81 | capture | 01a159cf-f954-79d7-9cfb-5de72ce121b3 | €9.00 | €0.19 | matched |
| 82 | capture | 01a159cf-fc18-7308-afa8-45b8adb04ea2 | €15.00 | €0.26 | matched |
| 83 | capture | 01a159d0-1c56-7267-988b-7a8385852c7c | €49.00 | €0.67 | matched |
| 84 | capture | 01a159d0-1deb-79da-91ed-e6f9cc6db543 | €24.00 | €0.37 | matched |
| 85 | capture | 01a159d0-2288-71a7-ae71-1b73a03b3519 | €9.00 | €0.19 | matched |
| 86 | capture | 01a159d0-23cb-7ef3-a825-366f292023f6 | €15.00 | €0.26 | matched |
| 87 | capture | 01a159d0-3190-7e31-8428-7f7f1234960e | €49.00 | €0.67 | matched |
| 88 | capture | 01a159d0-7bae-743a-a96a-f7eccd8e3abf | €15.00 | €0.26 | matched |
| 89 | capture | 01a159d0-87ae-7a60-ad33-ba2f0615cd9c | €49.00 | €0.67 | matched |
| 90 | capture | 01a159d0-8d98-7624-af71-16f761c34ae7 | €9.00 | €0.19 | matched |
| 91 | capture | 01a159d0-920f-7e7d-ac7c-3201946c14cb | €35.00 | €0.50 | matched |
| 92 | capture | 01a159d0-a084-79ae-b524-b381d9e2a155 | €9.00 | €0.19 | matched |
| 93 | capture | 01a159d0-e748-7541-a050-e5b08f1dff28 | €49.00 | €0.67 | matched |
| 94 | capture | 01a159d0-f083-7110-9065-dbd4d913515f | €24.00 | €0.37 | matched |
| 95 | capture | 01a159d0-fe8a-7dd9-8051-bcddbc26c387 | €15.00 | €0.26 | matched |
| 96 | capture | 01a159d1-0566-7583-b387-74c3b3f1e5b0 | €15.00 | €0.26 | matched |
| 97 | capture | 01a159d1-1b06-761b-99f7-1dcf1c0394d8 | €49.00 | €0.67 | matched |
| 98 | capture | 01a159d1-2a86-7a24-985f-23429f3fa70b | €9.00 | €0.19 | matched |
| 99 | capture | 01a159d1-3c1e-74d7-a00a-48b3cc1d8bd6 | €15.00 | €0.26 | matched |
| 100 | capture | 01a159d1-4c8f-7cd5-9b12-282dcbda9981 | €9.00 | €0.19 | matched |
| 101 | refund | 01a159d1-4db9-7540-ac88-1e99e15d4f85 | -€8.00 | €0.00 | matched |
| 102 | capture | 01a159d1-53fa-7ff0-944b-cdbada70e037 | €9.00 | €0.19 | matched |
| 103 | capture | 01a159d1-5ca6-7784-b662-bbca5bbde697 | €24.00 | €0.37 | matched |
| 104 | capture | 01a159d1-7560-7673-8ccb-5af92ae5f0a6 | €15.00 | €0.26 | matched |
| 105 | capture | 01a159d1-82ac-7212-93f4-e9156629e6b2 | €9.00 | €0.19 | matched |
| 106 | refund | 01a159d1-8372-7076-932b-02ccb3239e28 | -€6.00 | €0.00 | matched |
| 107 | capture | 01a159d1-9a9c-7960-a174-09552967baee | €24.00 | €0.37 | matched |
| 108 | capture | 01a159d1-a423-722a-9916-eb638f07d639 | €49.00 | €0.67 | matched |
| 109 | capture | 01a159d1-fbd3-7bcb-883b-e2387bd31ff2 | €49.00 | €0.67 | matched |
| 110 | capture | 01a159d2-1afd-7cad-8991-5a97af8e2e21 | €24.00 | €0.37 | matched |
| 111 | capture | 01a159d2-d875-709d-b8bb-d54b92f9b335 | €35.00 | €0.50 | matched |
| 112 | capture | 01a159d2-dc84-7a4b-8547-0451ece98ac3 | €9.00 | €0.19 | matched |
| 113 | capture | 01a159d2-ded3-7913-8084-9a2292571fd4 | €35.00 | €0.50 | matched |
| 114 | capture | 01a159d2-e912-7152-93ba-41fd1f50d112 | €9.00 | €0.19 | matched |
| 115 | capture | 01a159d3-1748-78da-8aff-d264fc4a3822 | €9.00 | €0.19 | matched |
| 116 | capture | 01a159d3-175a-79f3-9fc5-beba774b3d20 | €35.00 | €0.50 | matched |
| 117 | capture | 01a159d3-1877-73bd-9f5a-85994c613e2c | €15.00 | €0.26 | matched |
| 118 | capture | 01a159d3-41a3-7993-9398-981ee52fb075 | €15.00 | €0.26 | matched |
| 119 | capture | 01a159d3-4237-73ca-9ce9-5a75ac3e2901 | €35.00 | €0.50 | matched |
| 120 | capture | 01a159d3-61ce-750a-9e75-8dc985d80239 | €24.00 | €0.37 | matched |
| 121 | refund | 01a159d3-7c5a-7efb-9147-63aac58ae0f9 | -€19.00 | €0.00 | matched |