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
- 26 Oct, 13:00130 linesclean
- 26 Oct, 12:50125 lines4 breaks
- 26 Oct, 12:40105 lines1 break
- 26 Oct, 12:30140 lines3 breaks
- 26 Oct, 12:20120 lines1 break
- 26 Oct, 12:10140 lines3 breaks
- 26 Oct, 12:00122 lines6 breaks
- 26 Oct, 11:50125 lines1 break
- 26 Oct, 11:40104 lines2 breaks
- 26 Oct, 11:30112 lines3 breaks
- 26 Oct, 11:20135 lines1 break
- 26 Oct, 11:10132 lines2 breaks
- 26 Oct, 11:00108 lines4 breaks
- 26 Oct, 10:50115 lines2 breaks
26 Oct, 12:10
Gross
€3,257.00
PSP fee
€52.34
Net to the bank
€3,204.66
Settlement journal
#214659
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a17822-d89e-756c-804a-09a8f145d077 is already settled by stl_EUR_2988361 line 70
- fee differencethe fee is not the contract feethe fee is 53, the contract says 50
- missing linein the books, not in the filecapture:01a17826-6707-7dda-923a-52f9a24f7ccb is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 71 | refund | 01a17822-d90a-78ce-b1c7-c586302f572b | -€17.00 | €0.00 | duplicate line |
| 139 | capture | 01a17827-2c28-71d0-80ea-f764838cffde | €35.00 | €0.53 | fee difference |
| 1 | refund | 01a17818-4779-7a3f-8770-3575fefca919 | -€23.00 | €0.00 | matched |
| 2 | capture | 01a1781b-ac19-773d-a5a3-0ad5fde47751 | €15.00 | €0.26 | matched |
| 3 | capture | 01a1781c-b05e-7cbd-be16-758553234f6e | €15.00 | €0.26 | matched |
| 4 | capture | 01a1781d-3e6f-7e28-bb1a-ecf4ab8a76d9 | €15.00 | €0.26 | matched |
| 5 | capture | 01a1781e-266e-7836-84f8-961e9260da6c | €24.00 | €0.37 | matched |
| 6 | capture | 01a1781e-3f6c-7ddb-9cca-c946b6734002 | €35.00 | €0.50 | matched |
| 7 | capture | 01a1781e-40e7-799e-b9e8-efd5026e6347 | €15.00 | €0.26 | matched |
| 8 | capture | 01a1781e-423d-74e7-a557-1d912f0e0524 | €24.00 | €0.37 | matched |
| 9 | capture | 01a1781e-59d7-7355-aa37-b63269ab746c | €35.00 | €0.50 | matched |
| 10 | capture | 01a1781e-61ab-7bfc-aec8-cbe99eaecd43 | €49.00 | €0.67 | matched |
| 11 | capture | 01a1781e-777b-7f3f-bc18-282768265fd5 | €15.00 | €0.26 | matched |
| 12 | capture | 01a1781e-8a41-7888-ab35-a750b9a33920 | €35.00 | €0.50 | matched |
| 13 | capture | 01a1781e-b046-717e-a8c3-505b5a6356e4 | €15.00 | €0.26 | matched |
| 14 | capture | 01a1781e-be0d-7f91-b9b1-b1928b1fc19a | €35.00 | €0.50 | matched |
| 15 | capture | 01a1781e-c625-72f5-8692-ce8578683769 | €15.00 | €0.26 | matched |
| 16 | capture | 01a1781e-e7df-7193-9dfd-f1cb3ee46f7f | €9.00 | €0.19 | matched |
| 17 | capture | 01a1781f-1b21-792f-bbde-eebf8794d320 | €24.00 | €0.37 | matched |
| 18 | capture | 01a1781f-225f-7095-bc40-438b5fc1f6a8 | €15.00 | €0.26 | matched |
| 19 | capture | 01a1781f-4d99-79df-bfaa-173d1584c822 | €49.00 | €0.67 | matched |
| 20 | capture | 01a1781f-85cb-7909-b66c-328abba9fbf1 | €9.00 | €0.19 | matched |
| 21 | capture | 01a1781f-9e66-7009-8a3d-b813f2d32689 | €35.00 | €0.50 | matched |
| 22 | capture | 01a1781f-d4b5-7ec7-b991-3bf46be121bb | €35.00 | €0.50 | matched |
| 23 | capture | 01a1781f-d903-7dc6-ab0f-6c555c97234d | €49.00 | €0.67 | matched |
| 24 | capture | 01a1781f-e528-7aa0-bf2d-9f27408f6c1f | €15.00 | €0.26 | matched |
| 25 | capture | 01a17820-2da5-7d14-bfc2-6c93a812d78c | €49.00 | €0.67 | matched |
| 26 | capture | 01a17820-2dd7-7013-99f0-3d4c8a81866d | €24.00 | €0.37 | matched |
| 27 | capture | 01a17820-4f76-76a9-b0bd-fcd2cc3a30f5 | €35.00 | €0.50 | matched |
| 28 | capture | 01a17820-5009-79bd-be2e-13f0188bdaac | €24.00 | €0.37 | matched |
| 29 | capture | 01a17820-7858-762a-afcd-1572deed9bd5 | €49.00 | €0.67 | matched |
| 30 | capture | 01a17820-a508-70ea-9db2-f3307f36dd88 | €9.00 | €0.19 | matched |
| 31 | capture | 01a17820-d86a-7c5a-babe-c641a68c8e38 | €24.00 | €0.37 | matched |
| 32 | capture | 01a17820-d86f-7c16-b9dc-75f6966fb41d | €24.00 | €0.37 | matched |
| 33 | capture | 01a17820-e5c7-78cc-8377-0cf2e8077146 | €35.00 | €0.50 | matched |
| 34 | capture | 01a17820-e703-72eb-8e42-4e0602e68738 | €24.00 | €0.37 | matched |
| 35 | capture | 01a17820-e937-7517-b52e-843b360f6b5c | €9.00 | €0.19 | matched |
| 36 | capture | 01a17820-f578-705b-836d-669f590395e0 | €49.00 | €0.67 | matched |
| 37 | capture | 01a17820-f9aa-7259-a6e8-8599f802d3ea | €35.00 | €0.50 | matched |
| 38 | capture | 01a17820-fd99-70e7-a52a-dce561edd789 | €35.00 | €0.50 | matched |
| 39 | capture | 01a17820-fdc0-7e0a-86bf-fa62dff754ee | €49.00 | €0.67 | matched |
| 40 | capture | 01a17821-0c3b-7a4c-87f6-360053344b76 | €35.00 | €0.50 | matched |
| 41 | capture | 01a17821-34a6-778a-84e6-8d9411482202 | €24.00 | €0.37 | matched |
| 42 | capture | 01a17821-40b5-7993-9715-fe882d2d07da | €24.00 | €0.37 | matched |
| 43 | refund | 01a17821-4688-7390-8aa4-022d6ef9e62a | -€18.00 | €0.00 | matched |
| 44 | capture | 01a17821-4fdc-7bff-882d-9fbd7e028a1f | €49.00 | €0.67 | matched |
| 45 | refund | 01a17821-57ea-7ebb-88e7-03095fe9e69d | -€38.00 | €0.00 | matched |
| 46 | capture | 01a17821-6118-7934-b5c9-41ab2ee72bcc | €9.00 | €0.19 | matched |
| 47 | capture | 01a17821-7aa8-7c61-8c0f-c1e4a29851eb | €15.00 | €0.26 | matched |
| 48 | capture | 01a17821-90ae-78c2-b25d-3cc330310d0a | €24.00 | €0.37 | matched |
| 49 | capture | 01a17821-995d-762b-ad0d-d949b7c5633b | €24.00 | €0.37 | matched |
| 50 | capture | 01a17821-a8c3-7857-9618-eafb1c4401c1 | €24.00 | €0.37 | matched |
| 51 | capture | 01a17821-d64b-73a8-84f4-b5107a3ed419 | €49.00 | €0.67 | matched |
| 52 | capture | 01a17821-db3b-77d3-b7e1-1048497e7077 | €24.00 | €0.37 | matched |
| 53 | capture | 01a17821-ee08-7bca-9a52-616461556009 | €15.00 | €0.26 | matched |
| 54 | capture | 01a17821-f641-7d0d-b0fd-b837a9e5ac98 | €35.00 | €0.50 | matched |
| 55 | capture | 01a17822-15f7-78bd-9584-07cabbdd0de5 | €49.00 | €0.67 | matched |
| 56 | capture | 01a17822-1f28-7fc9-87af-95a466a1039a | €9.00 | €0.19 | matched |
| 57 | capture | 01a17822-21f5-71a2-98d7-87e61cdd198b | €35.00 | €0.50 | matched |
| 58 | capture | 01a17822-256e-7dfa-9a34-41d21448325e | €15.00 | €0.26 | matched |
| 59 | capture | 01a17822-2539-7df4-9ee0-71ed0d9e8e93 | €49.00 | €0.67 | matched |
| 60 | capture | 01a17822-335e-79ae-b08a-3f3978bdec2a | €24.00 | €0.37 | matched |
| 61 | capture | 01a17822-50e4-7602-a74c-af185ff0a3de | €9.00 | €0.19 | matched |
| 62 | capture | 01a17822-58fe-793d-82cb-532ccdf2e334 | €24.00 | €0.37 | matched |
| 63 | capture | 01a17822-687a-7b87-8dc3-5ea6005e8584 | €49.00 | €0.67 | matched |
| 64 | capture | 01a17822-6cbb-7494-85ca-77852565d26c | €24.00 | €0.37 | matched |
| 65 | capture | 01a17822-76c9-7f74-a94c-661a58d8ed3c | €9.00 | €0.19 | matched |
| 66 | refund | 01a17822-85ed-760b-bbff-1cd4388f4338 | -€3.00 | €0.00 | matched |
| 67 | refund | 01a17822-a0f2-706f-97e9-d015763bedfc | -€16.00 | €0.00 | matched |
| 68 | capture | 01a17822-b3db-7b52-8d92-dd237092561f | €24.00 | €0.37 | matched |
| 69 | capture | 01a17822-d42d-75a4-b278-939363909ad5 | €9.00 | €0.19 | matched |
| 70 | refund | 01a17822-d90a-78ce-b1c7-c586302f572b | -€17.00 | €0.00 | matched |
| 72 | capture | 01a17822-f27f-7a61-9f61-41b21c6ebd94 | €49.00 | €0.67 | matched |
| 73 | capture | 01a17823-174b-745b-a2ff-5d3af56b5ce7 | €15.00 | €0.26 | matched |
| 74 | capture | 01a17823-3101-72d0-a379-59725da0a416 | €15.00 | €0.26 | matched |
| 75 | capture | 01a17823-3d55-70dd-a52f-ea9ba11e5be2 | €15.00 | €0.26 | matched |
| 76 | capture | 01a17823-48ee-7eb5-b3fb-cb8882a9454d | €15.00 | €0.26 | matched |
| 77 | capture | 01a17823-5710-7fc7-b8fd-7ca3abd9653e | €24.00 | €0.37 | matched |
| 78 | capture | 01a17823-6023-7a1a-a01f-749e0c55204d | €35.00 | €0.50 | matched |
| 79 | capture | 01a17823-69f7-7242-8914-a9bba6c3874e | €24.00 | €0.37 | matched |
| 80 | capture | 01a17823-6c3e-70ef-9a19-de15ae00be44 | €24.00 | €0.37 | matched |
| 81 | refund | 01a17823-8634-7e86-81aa-13c0ea4fb97a | -€14.00 | €0.00 | matched |
| 82 | capture | 01a17823-8eac-736a-99de-d89ab083d175 | €49.00 | €0.67 | matched |
| 83 | capture | 01a17823-9079-7ee0-8238-8b0bb92c2be5 | €24.00 | €0.37 | matched |
| 84 | capture | 01a17823-c267-7101-82d0-8efea2ef3d29 | €9.00 | €0.19 | matched |
| 85 | refund | 01a17823-e011-78ee-b7a2-5cc8cf8cc99a | -€33.00 | €0.00 | matched |
| 86 | capture | 01a17823-f8a6-79b6-abeb-8c719c3767e9 | €9.00 | €0.19 | matched |
| 87 | capture | 01a17823-fc59-7fdb-8c4c-b20f57b7e999 | €49.00 | €0.67 | matched |
| 88 | capture | 01a17824-04b7-7911-9560-a0791b9f7ca0 | €35.00 | €0.50 | matched |
| 89 | capture | 01a17824-0776-7bdb-974c-eb85958f8a7d | €15.00 | €0.26 | matched |
| 90 | capture | 01a17824-3384-7294-b370-1c11b8367ee9 | €9.00 | €0.19 | matched |
| 91 | capture | 01a17824-38e4-7344-ba41-19a4879a22de | €15.00 | €0.26 | matched |
| 92 | capture | 01a17824-498d-758b-b22a-8b1ef850de79 | €49.00 | €0.67 | matched |
| 93 | capture | 01a17824-5129-7bb6-a428-2ac129f80145 | €9.00 | €0.19 | matched |
| 94 | capture | 01a17824-5b4b-701c-a8db-072b0ee017e2 | €35.00 | €0.50 | matched |
| 95 | capture | 01a17824-7369-707d-ad00-d662d2307616 | €15.00 | €0.26 | matched |
| 96 | capture | 01a17824-a62d-7301-b8d1-e7c4778a0d1e | €35.00 | €0.50 | matched |
| 97 | capture | 01a17824-c770-726a-8e83-fb488e9646e6 | €35.00 | €0.50 | matched |
| 98 | capture | 01a17825-025e-7596-9a26-d07c28742c21 | €9.00 | €0.19 | matched |
| 99 | capture | 01a17825-044f-7468-a8d6-a540aae1862f | €15.00 | €0.26 | matched |
| 100 | capture | 01a17825-081c-766c-b0fc-13776b403566 | €9.00 | €0.19 | matched |
| 101 | capture | 01a17825-316d-7615-8dec-83b790baf546 | €9.00 | €0.19 | matched |
| 102 | capture | 01a17825-318d-7c82-b173-12d8ed999b58 | €15.00 | €0.26 | matched |
| 103 | capture | 01a17825-3f65-786f-893b-ff1e970a1f4d | €24.00 | €0.37 | matched |
| 104 | capture | 01a17825-5230-74ba-8906-f8ff980f85ea | €49.00 | €0.67 | matched |
| 105 | refund | 01a17825-61a0-77be-b48e-41c70fccce9a | -€13.00 | €0.00 | matched |
| 106 | capture | 01a17825-9dfb-73f6-a715-bd08947ede05 | €35.00 | €0.50 | matched |
| 107 | refund | 01a17825-a19a-7c98-af6f-099e7cdc13d3 | -€3.00 | €0.00 | matched |
| 108 | capture | 01a17825-a2db-797a-90c6-66d8921b8719 | €49.00 | €0.67 | matched |
| 109 | capture | 01a17825-a53e-76fc-9dc6-297fc16b90bb | €9.00 | €0.19 | matched |
| 110 | capture | 01a17825-ec49-77fc-a907-b34581a0d4c8 | €9.00 | €0.19 | matched |
| 111 | capture | 01a17825-f98a-76d9-9f9f-1958181b4935 | €49.00 | €0.67 | matched |
| 112 | capture | 01a17825-fc9c-7f62-8b63-184e5c17e67d | €49.00 | €0.67 | matched |
| 113 | refund | 01a17825-ff22-7e04-a1e9-3943eb76609d | -€41.00 | €0.00 | matched |
| 114 | capture | 01a17826-100a-7cb3-8e13-09175ca3b172 | €35.00 | €0.50 | matched |
| 115 | capture | 01a17826-22e6-70cb-9bbd-63dbad085d3b | €9.00 | €0.19 | matched |
| 116 | capture | 01a17826-2996-73ef-9df5-96b2554b68a3 | €35.00 | €0.50 | matched |
| 117 | capture | 01a17826-2af8-764f-a672-5e80b6436515 | €24.00 | €0.37 | matched |
| 118 | capture | 01a17826-31cc-71b8-80ac-8fc565698a2c | €24.00 | €0.37 | matched |
| 119 | capture | 01a17826-4182-7b62-b5b8-62c9c58b3c10 | €15.00 | €0.26 | matched |
| 120 | capture | 01a17826-43d4-77aa-9821-606a3edc8c46 | €35.00 | €0.50 | matched |
| 121 | capture | 01a17826-4dfa-76d7-811c-13f8aaf49b7b | €9.00 | €0.19 | matched |
| 122 | capture | 01a17826-547f-7233-86e3-d3accb423721 | €24.00 | €0.37 | matched |
| 123 | capture | 01a17826-620c-79c2-9c8d-905cd25c71e9 | €49.00 | €0.67 | matched |
| 124 | capture | 01a17826-84b3-7c92-8e53-6c2df2f56a6b | €49.00 | €0.67 | matched |
| 125 | capture | 01a17826-864f-76b4-8cb9-a535b2263086 | €24.00 | €0.37 | matched |
| 126 | capture | 01a17826-9f83-7c36-b268-f4945c7c1cea | €49.00 | €0.67 | matched |
| 127 | capture | 01a17826-a24a-7e6c-a98f-3a0ebafad0de | €49.00 | €0.67 | matched |
| 128 | capture | 01a17826-a63f-7878-8936-ae4a47565c66 | €15.00 | €0.26 | matched |
| 129 | capture | 01a17826-b817-7759-8381-7b9438faac68 | €15.00 | €0.26 | matched |
| 130 | capture | 01a17826-c6b8-7686-a82e-2aac1db68588 | €49.00 | €0.67 | matched |
| 131 | capture | 01a17826-dd96-7303-9d18-ac2a0b286403 | €15.00 | €0.26 | matched |
| 132 | capture | 01a17826-dd8e-7795-b1ed-008a512dd279 | €49.00 | €0.67 | matched |
| 133 | capture | 01a17826-e125-7b6c-aa70-32b221119edf | €24.00 | €0.37 | matched |
| 134 | capture | 01a17826-f4e1-7a82-bdd5-0d61fe135dd2 | €24.00 | €0.37 | matched |
| 135 | capture | 01a17827-074c-72f1-8f5c-7a7b8df06675 | €9.00 | €0.19 | matched |
| 136 | capture | 01a17827-10a8-7c80-b49d-4c54aa3ba0b0 | €35.00 | €0.50 | matched |
| 137 | capture | 01a17827-1815-7417-b44e-02d4cf8f65a1 | €49.00 | €0.67 | matched |
| 138 | capture | 01a17827-26ae-7969-85d3-7c5ff473aadd | €35.00 | €0.50 | matched |
| 140 | capture | 01a17827-2d5f-713c-a52c-a86055de335d | €35.00 | €0.50 | matched |