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
- 18 Oct, 12:00119 lines1 break
- 18 Oct, 11:50146 lines2 breaks
- 18 Oct, 11:40136 lines4 breaks
- 18 Oct, 11:30155 lines2 breaks
- 18 Oct, 11:20122 lines5 breaks
- 18 Oct, 11:10131 lines2 breaks
- 18 Oct, 11:00121 lines2 breaks
- 18 Oct, 10:50115 lines1 break
- 18 Oct, 10:40129 lines4 breaks
- 18 Oct, 10:30111 linesclean
- 18 Oct, 10:20131 lines2 breaks
- 18 Oct, 10:10120 linesclean
- 18 Oct, 10:0097 lines1 break
- 18 Oct, 09:50125 lines4 breaks
18 Oct, 10:40
Gross
€2,833.00
PSP fee
€45.92
Net to the bank
€2,787.08
Settlement journal
#67988
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14e9c-fd5a-7de9-ad3f-3036ac0f01dd is already settled by stl_EUR_2987200 line 58
- duplicate linethe file lists it twicecapture:01a14ea1-6e80-7e28-8549-3efb228402d1 is already settled by stl_EUR_2987200 line 121
- fee differencethe fee is not the contract feethe fee is 5, the contract says 0
- missing linein the books, not in the filecapture:01a14ea0-bcb6-7e83-8e54-309e1b59c3d2 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 59 | capture | 01a14e9d-194f-7321-a9d3-163d57289ce5 | €35.00 | €0.50 | duplicate line |
| 69 | refund | 01a14e9d-645f-7340-899f-adef6523201d | -€28.00 | €0.05 | fee difference |
| 122 | capture | 01a14ea1-6ec2-7ea0-b67b-d60e46bfd123 | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a14e91-d330-72aa-a919-781fb03fc58e | €35.00 | €0.50 | matched |
| 2 | capture | 01a14e92-5d56-742a-867b-0f43e65566b5 | €9.00 | €0.19 | matched |
| 3 | capture | 01a14e97-cc8b-79d4-90eb-3e1e59dfd305 | €49.00 | €0.67 | matched |
| 4 | capture | 01a14e98-f53d-7440-9e14-e059880674d6 | €49.00 | €0.67 | matched |
| 5 | refund | 01a14e99-0555-7da3-984e-b97c13febdef | -€27.00 | €0.00 | matched |
| 6 | capture | 01a14e99-05c7-72d0-bf5a-91c82c281dc9 | €9.00 | €0.19 | matched |
| 7 | capture | 01a14e99-155e-779e-b76c-6c5fb3e44491 | €24.00 | €0.37 | matched |
| 8 | capture | 01a14e99-16fc-7cbf-b797-e1fb37a6543e | €15.00 | €0.26 | matched |
| 9 | capture | 01a14e99-2cd9-7ada-af87-fa15eaefc029 | €15.00 | €0.26 | matched |
| 10 | capture | 01a14e99-50b4-722e-aa16-2408259cb8e2 | €49.00 | €0.67 | matched |
| 11 | capture | 01a14e99-5ebf-769e-bbd7-72d31e7a4da0 | €35.00 | €0.50 | matched |
| 12 | capture | 01a14e99-6853-70aa-b096-6b65351bc34a | €24.00 | €0.37 | matched |
| 13 | capture | 01a14e99-8166-7722-b24e-498ae0dfc1f9 | €9.00 | €0.19 | matched |
| 14 | capture | 01a14e99-8ccf-7e2b-87fa-b53e4d73947e | €15.00 | €0.26 | matched |
| 15 | capture | 01a14e99-920f-727f-8285-58625473d347 | €35.00 | €0.50 | matched |
| 16 | capture | 01a14e99-e64a-77ab-a8c8-761f67d85ab6 | €49.00 | €0.67 | matched |
| 17 | capture | 01a14e99-fa93-7573-950b-0e409ddcf060 | €49.00 | €0.67 | matched |
| 18 | capture | 01a14e9a-0bef-76ee-8268-da9bf789fa9f | €15.00 | €0.26 | matched |
| 19 | capture | 01a14e9a-16be-745f-bbb5-9c7faa9069ad | €24.00 | €0.37 | matched |
| 20 | capture | 01a14e9a-22da-726a-ba5c-8821c3957a42 | €49.00 | €0.67 | matched |
| 21 | capture | 01a14e9a-28e4-775c-9148-dbf7c6d041ab | €24.00 | €0.37 | matched |
| 22 | refund | 01a14e9a-2aeb-7140-a473-fd05a7724af9 | -€28.00 | €0.00 | matched |
| 23 | capture | 01a14e9a-2d30-7453-93a1-f036a5a1f8a3 | €9.00 | €0.19 | matched |
| 24 | capture | 01a14e9a-4714-7d4f-83fa-08f857a22632 | €24.00 | €0.37 | matched |
| 25 | capture | 01a14e9a-57de-7d92-b37c-a321a0d22cbb | €15.00 | €0.26 | matched |
| 26 | capture | 01a14e9a-856b-730d-8c82-b7721badacb6 | €49.00 | €0.67 | matched |
| 27 | capture | 01a14e9a-8dae-7230-9d95-938ee9e9aa8a | €15.00 | €0.26 | matched |
| 28 | capture | 01a14e9a-defe-7572-8cc0-512fe4c950d0 | €49.00 | €0.67 | matched |
| 29 | capture | 01a14e9b-24b3-77f0-892f-c1b43d54e073 | €24.00 | €0.37 | matched |
| 30 | capture | 01a14e9b-26e9-7583-b850-f02e367dd93d | €35.00 | €0.50 | matched |
| 31 | capture | 01a14e9b-2c62-7372-8e20-d42743c2692c | €15.00 | €0.26 | matched |
| 32 | capture | 01a14e9b-3b54-746d-9f6d-6f03dbfaffe1 | €15.00 | €0.26 | matched |
| 33 | capture | 01a14e9b-4120-777b-a06b-b772c2506b68 | €24.00 | €0.37 | matched |
| 34 | capture | 01a14e9b-4218-797e-93ed-bbfe9acfebf0 | €49.00 | €0.67 | matched |
| 35 | capture | 01a14e9b-4305-7032-a77a-b4b80fef8aa8 | €49.00 | €0.67 | matched |
| 36 | capture | 01a14e9b-5db9-7258-bf11-cc8a27b68e3c | €15.00 | €0.26 | matched |
| 37 | capture | 01a14e9b-682c-77af-bb84-e4674386d325 | €9.00 | €0.19 | matched |
| 38 | refund | 01a14e9b-6af4-7292-8877-0f27e9bf16c5 | -€20.00 | €0.00 | matched |
| 39 | capture | 01a14e9b-701f-7815-8488-f141b0c9f44d | €49.00 | €0.67 | matched |
| 40 | capture | 01a14e9b-7347-729c-8813-0aea8f66cf98 | €9.00 | €0.19 | matched |
| 41 | capture | 01a14e9b-af33-7c7c-a5e7-273f7ba11d90 | €24.00 | €0.37 | matched |
| 42 | capture | 01a14e9b-b541-7ccc-a8af-7ab5e09eae0d | €9.00 | €0.19 | matched |
| 43 | capture | 01a14e9b-d503-748d-ab81-281f9ac93f45 | €35.00 | €0.50 | matched |
| 44 | capture | 01a14e9b-e321-7dc8-afb9-55b9b503428e | €9.00 | €0.19 | matched |
| 45 | refund | 01a14e9b-ffaf-7b76-8e0a-6bb2257237ca | -€16.00 | €0.00 | matched |
| 46 | capture | 01a14e9c-3997-788d-a8cd-ac77a906d2ab | €35.00 | €0.50 | matched |
| 47 | capture | 01a14e9c-4027-7909-af63-3e69cc585a1f | €35.00 | €0.50 | matched |
| 48 | capture | 01a14e9c-486c-77f5-967d-b5750c4a6f43 | €24.00 | €0.37 | matched |
| 49 | capture | 01a14e9c-4ec1-77fd-90f0-736d7ec5f473 | €15.00 | €0.26 | matched |
| 50 | capture | 01a14e9c-5975-73bc-8c17-f551ce204825 | €49.00 | €0.67 | matched |
| 51 | capture | 01a14e9c-6830-76d4-803b-fd7094f294cb | €35.00 | €0.50 | matched |
| 52 | capture | 01a14e9c-9214-7775-bfab-e3a073a3cf12 | €35.00 | €0.50 | matched |
| 53 | capture | 01a14e9c-be6e-7755-b3c2-605afcf486d3 | €35.00 | €0.50 | matched |
| 54 | capture | 01a14e9c-d295-7c26-862a-2b9e882c9bd3 | €15.00 | €0.26 | matched |
| 55 | capture | 01a14e9c-e06e-7250-a4c7-171ee82510b8 | €15.00 | €0.26 | matched |
| 56 | capture | 01a14e9c-e3bf-7db1-8168-85fb043d11e9 | €9.00 | €0.19 | matched |
| 57 | capture | 01a14e9c-e3c5-7119-b251-cf32c575bfa8 | €49.00 | €0.67 | matched |
| 58 | capture | 01a14e9d-194f-7321-a9d3-163d57289ce5 | €35.00 | €0.50 | matched |
| 60 | capture | 01a14e9d-1d86-76ab-bfe0-e34f28c4e2ff | €9.00 | €0.19 | matched |
| 61 | capture | 01a14e9d-2042-761b-88ac-3f4d092db81f | €35.00 | €0.50 | matched |
| 62 | capture | 01a14e9d-2a57-7ee9-975d-05300d0a8a46 | €15.00 | €0.26 | matched |
| 63 | capture | 01a14e9d-42ab-7e00-abfa-87d9eb6aeff7 | €49.00 | €0.67 | matched |
| 64 | refund | 01a14e9d-4d2b-76b9-9e80-9da42c84f72a | -€12.00 | €0.00 | matched |
| 65 | refund | 01a14e9d-54a9-7873-8b19-35bb4f515f9c | -€29.00 | €0.00 | matched |
| 66 | capture | 01a14e9d-56e0-70f7-ac27-5b9a2190d5e5 | €15.00 | €0.26 | matched |
| 67 | capture | 01a14e9d-5789-7e4f-b014-39dd919895ef | €9.00 | €0.19 | matched |
| 68 | capture | 01a14e9d-582c-7e27-8d80-196afe61da8d | €24.00 | €0.37 | matched |
| 70 | capture | 01a14e9d-64f0-7afb-98bc-89df730f748b | €9.00 | €0.19 | matched |
| 71 | capture | 01a14e9d-70bb-74b9-a2eb-a8b984f05193 | €15.00 | €0.26 | matched |
| 72 | capture | 01a14e9d-8909-7de4-ac4d-66be1fa24dfe | €15.00 | €0.26 | matched |
| 73 | capture | 01a14e9d-a488-7fe4-bc14-25d3c677036e | €35.00 | €0.50 | matched |
| 74 | capture | 01a14e9d-b379-7e1e-89df-f8b830403c45 | €35.00 | €0.50 | matched |
| 75 | capture | 01a14e9d-b84d-7144-81f1-080043df4309 | €49.00 | €0.67 | matched |
| 76 | capture | 01a14e9d-bc1b-794a-8713-ab012ec6dcdd | €9.00 | €0.19 | matched |
| 77 | capture | 01a14e9d-bf29-7836-87d6-fe177a372af0 | €15.00 | €0.26 | matched |
| 78 | capture | 01a14e9e-0b90-7307-8dfa-49e363bf7662 | €49.00 | €0.67 | matched |
| 79 | capture | 01a14e9e-0d07-7795-9b1a-8727499088d1 | €15.00 | €0.26 | matched |
| 80 | capture | 01a14e9e-10e1-799d-8b83-12f405462f78 | €24.00 | €0.37 | matched |
| 81 | capture | 01a14e9e-1d12-725e-a641-7c340d5134bc | €9.00 | €0.19 | matched |
| 82 | capture | 01a14e9e-20a3-7500-bf6a-f57af5d80fb6 | €9.00 | €0.19 | matched |
| 83 | capture | 01a14e9e-2434-77d9-84b2-0dc8623f27c9 | €35.00 | €0.50 | matched |
| 84 | capture | 01a14e9e-425e-7b42-b633-15cbaa856d81 | €9.00 | €0.19 | matched |
| 85 | capture | 01a14e9e-4827-7bc9-ab29-43c8db94a3ef | €35.00 | €0.50 | matched |
| 86 | capture | 01a14e9e-6bd9-7c05-8c06-612ce2869f4f | €9.00 | €0.19 | matched |
| 87 | capture | 01a14e9e-6d7e-7900-9036-eb5922cdcc28 | €15.00 | €0.26 | matched |
| 88 | capture | 01a14e9e-98e9-7dbb-9e6c-6b2cd3b2919b | €9.00 | €0.19 | matched |
| 89 | capture | 01a14e9e-ac85-7444-a284-b4abb88876c2 | €15.00 | €0.26 | matched |
| 90 | capture | 01a14e9e-af80-70e2-bb26-ff04989878d1 | €15.00 | €0.26 | matched |
| 91 | capture | 01a14e9e-c80c-74a4-bda0-35b2746fcee0 | €24.00 | €0.37 | matched |
| 92 | capture | 01a14e9e-ca7f-75d4-93c0-f6c25e5f2aad | €24.00 | €0.37 | matched |
| 93 | capture | 01a14e9e-e616-7a48-b2f8-64c1ba9eba86 | €15.00 | €0.26 | matched |
| 94 | capture | 01a14e9f-0ce8-73bc-88a2-c5b5076e0ef5 | €15.00 | €0.26 | matched |
| 95 | capture | 01a14e9f-11bd-7213-88da-f82f60e88bfb | €9.00 | €0.19 | matched |
| 96 | capture | 01a14e9f-3d3f-7e6e-bfb1-5021cfc7bcd9 | €9.00 | €0.19 | matched |
| 97 | capture | 01a14e9f-6e61-76ad-86fe-c3862c2f3aaf | €15.00 | €0.26 | matched |
| 98 | capture | 01a14e9f-82f2-7fd1-9430-96d0a0608231 | €35.00 | €0.50 | matched |
| 99 | capture | 01a14e9f-990d-7cd6-a93d-74f23884de5e | €9.00 | €0.19 | matched |
| 100 | refund | 01a14e9f-c48a-7270-b2de-3abfcbe015d0 | -€15.00 | €0.00 | matched |
| 101 | capture | 01a14e9f-ca27-7f50-a513-a5cb54cce29d | €49.00 | €0.67 | matched |
| 102 | capture | 01a14e9f-cb6a-7dea-8367-c4b5ab50a6f9 | €24.00 | €0.37 | matched |
| 103 | capture | 01a14e9f-db4a-7584-8cd9-e08563185f1a | €35.00 | €0.50 | matched |
| 104 | capture | 01a14e9f-e473-7585-aff7-426310bceb9e | €35.00 | €0.50 | matched |
| 105 | capture | 01a14e9f-f316-7d1b-a4a8-f8ed78e6e035 | €9.00 | €0.19 | matched |
| 106 | capture | 01a14ea0-0433-786d-b197-335f965733f5 | €24.00 | €0.37 | matched |
| 107 | capture | 01a14ea0-164d-7626-99f0-dc5047241dda | €24.00 | €0.37 | matched |
| 108 | capture | 01a14ea0-2862-76e7-b768-34037c5e1aa0 | €24.00 | €0.37 | matched |
| 109 | capture | 01a14ea0-2a05-7a6d-bd2f-03305c83b9b3 | €35.00 | €0.50 | matched |
| 110 | capture | 01a14ea0-2e90-7a6b-b7da-10fec0cec86d | €35.00 | €0.50 | matched |
| 111 | capture | 01a14ea0-30a7-7ef4-a46d-10b0f79d0730 | €15.00 | €0.26 | matched |
| 112 | capture | 01a14ea0-4261-7f04-aca9-c109f5f112d7 | €9.00 | €0.19 | matched |
| 113 | capture | 01a14ea0-a747-7e9d-8a9a-7d151b9e3667 | €9.00 | €0.19 | matched |
| 114 | capture | 01a14ea0-b103-735f-a7e9-c4de6b0bcade | €49.00 | €0.67 | matched |
| 115 | capture | 01a14ea0-cd0c-78cd-ae35-587fd3c69e67 | €24.00 | €0.37 | matched |
| 116 | capture | 01a14ea0-e17c-7953-9e0d-26920a5cf6db | €35.00 | €0.50 | matched |
| 117 | capture | 01a14ea1-0b25-7d39-bd15-e38749016255 | €49.00 | €0.67 | matched |
| 118 | refund | 01a14ea1-1698-73ec-946b-d22d1c14caae | -€2.00 | €0.00 | matched |
| 119 | capture | 01a14ea1-1bb5-72a7-8ced-359cdc759bc1 | €35.00 | €0.50 | matched |
| 120 | capture | 01a14ea1-26f7-701d-b545-37aa0c7dbdb8 | €24.00 | €0.37 | matched |
| 121 | capture | 01a14ea1-6ec2-7ea0-b67b-d60e46bfd123 | €24.00 | €0.37 | matched |
| 123 | capture | 01a14ea1-6f80-7fa3-989b-c64b2d6a3ec7 | €49.00 | €0.67 | matched |
| 124 | capture | 01a14ea1-8592-7943-b9db-661d223fa881 | €35.00 | €0.50 | matched |
| 125 | refund | 01a14ea1-8b01-7018-b69a-f8950793607e | -€8.00 | €0.00 | matched |
| 126 | capture | 01a14ea1-b63a-715f-97fa-b6c2712f31cc | €15.00 | €0.26 | matched |
| 127 | capture | 01a14ea1-b65d-77b7-8430-ef4c41eea410 | €9.00 | €0.19 | matched |
| 128 | capture | 01a14ea1-b1b2-7d6f-9190-7176a94c145e | €9.00 | €0.19 | matched |
| 129 | capture | 01a14ea1-ce97-7844-bb39-1d7a78ac0036 | €35.00 | €0.50 | matched |