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
- 7 Nov, 14:10124 linesclean
- 7 Nov, 14:00120 lines3 breaks
- 7 Nov, 13:50118 lines2 breaks
- 7 Nov, 13:40133 lines3 breaks
- 7 Nov, 13:30129 lines6 breaks
- 7 Nov, 13:20127 lines1 break
- 7 Nov, 13:10110 lines2 breaks
- 7 Nov, 13:00133 lines3 breaks
- 7 Nov, 12:50136 lines2 breaks
- 7 Nov, 12:40142 lines7 breaks
- 7 Nov, 12:30115 lines2 breaks
- 7 Nov, 12:20130 lines3 breaks
- 7 Nov, 12:10116 lines4 breaks
- 7 Nov, 12:00138 lines3 breaks
7 Nov, 12:40
Gross
€3,634.00
PSP fee
€56.43
Net to the bank
€3,577.57
Settlement journal
#434624
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1b608-78e4-7a10-b11d-8b86dc42b9b1 is already settled by stl_EUR_2990092 line 33
- duplicate linethe file lists it twicecapture:01a1b60b-4677-706c-b4d2-57011c0a138d is already settled by stl_EUR_2990092 line 92
- fee differencethe fee is not the contract feethe fee is 24, the contract says 19
- fee differencethe fee is not the contract feethe fee is 54, the contract says 50
- missing linein the books, not in the filecapture:01a1b606-e0d6-7b7a-9fd0-3f9231765d90 is in no file
- missing linein the books, not in the filecapture:01a1b60d-9c7c-7110-adaf-40af935cf7fe is in no file
- missing linein the books, not in the filecapture:01a1b609-ddee-7995-ba78-2131f812d29f is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 22 | capture | 01a1b607-c68a-7e2c-aee3-eb9c8b783763 | €9.00 | €0.24 | fee difference |
| 34 | capture | 01a1b608-78fd-7f9f-9d6d-83779d816482 | €15.00 | €0.26 | duplicate line |
| 43 | capture | 01a1b608-cba9-702b-b6f6-1c210b1e6bdc | €35.00 | €0.54 | fee difference |
| 93 | capture | 01a1b60b-4694-72aa-8f9d-8e3b7d6ff203 | €9.00 | €0.19 | duplicate line |
| 1 | capture | 01a1b601-c006-717a-b067-73390927c4d3 | €49.00 | €0.67 | matched |
| 2 | capture | 01a1b606-056e-716c-9b1a-eda2179b0f4b | €15.00 | €0.26 | matched |
| 3 | capture | 01a1b606-2baf-7dcd-9b0f-39e21ae8b1a3 | €9.00 | €0.19 | matched |
| 4 | capture | 01a1b606-4fc2-7c5b-8c5e-61e43f87e1e2 | €24.00 | €0.37 | matched |
| 5 | capture | 01a1b606-8098-7b3e-af44-dfc8aa2065e7 | €24.00 | €0.37 | matched |
| 6 | capture | 01a1b606-988f-794f-90c8-d864dfa520d4 | €24.00 | €0.37 | matched |
| 7 | capture | 01a1b606-ba64-79bd-b84a-68a99ad9cbb0 | €35.00 | €0.50 | matched |
| 8 | capture | 01a1b606-cfbf-753f-b488-033df7f6a6ce | €35.00 | €0.50 | matched |
| 9 | capture | 01a1b606-cf25-7d78-ac24-ef286917544a | €35.00 | €0.50 | matched |
| 10 | capture | 01a1b606-dbbc-712b-8be8-6d6ac1324b83 | €15.00 | €0.26 | matched |
| 11 | capture | 01a1b606-fa95-7f1e-a8aa-1655ec95ca35 | €35.00 | €0.50 | matched |
| 12 | capture | 01a1b607-06a1-7d59-9198-c236a0e05392 | €15.00 | €0.26 | matched |
| 13 | capture | 01a1b607-222a-7e2d-bed3-fa9366927506 | €49.00 | €0.67 | matched |
| 14 | capture | 01a1b607-2fb2-7efc-b2cf-cc91c01686df | €9.00 | €0.19 | matched |
| 15 | capture | 01a1b607-38ef-708f-a03f-94e230858fb9 | €9.00 | €0.19 | matched |
| 16 | capture | 01a1b607-5fee-7d4b-9baf-1961cd162a17 | €35.00 | €0.50 | matched |
| 17 | capture | 01a1b607-7ae4-7b5e-99a4-b226566a1f72 | €24.00 | €0.37 | matched |
| 18 | capture | 01a1b607-83ba-74d5-b2e3-932b8bdc0c55 | €15.00 | €0.26 | matched |
| 19 | capture | 01a1b607-955a-7255-a525-3076f211c21c | €49.00 | €0.67 | matched |
| 20 | capture | 01a1b607-a14a-7648-b151-da91f0d9b495 | €24.00 | €0.37 | matched |
| 21 | capture | 01a1b607-b00c-7db8-9093-b787804d212b | €24.00 | €0.37 | matched |
| 23 | capture | 01a1b607-cf46-7cf9-9cca-c2e3169578b0 | €35.00 | €0.50 | matched |
| 24 | capture | 01a1b607-d982-7de8-b6c6-02b4681c9765 | €15.00 | €0.26 | matched |
| 25 | capture | 01a1b607-eac1-7981-b8bb-e48ecbad5f8f | €9.00 | €0.19 | matched |
| 26 | capture | 01a1b607-ea74-77ad-b11d-ec9618a0e8c4 | €35.00 | €0.50 | matched |
| 27 | capture | 01a1b607-f85f-70f6-86e6-c62dc0f35093 | €35.00 | €0.50 | matched |
| 28 | refund | 01a1b608-01dd-7cdd-962c-54370c9c4f97 | -€9.00 | €0.00 | matched |
| 29 | capture | 01a1b608-4452-7c56-a932-04bb3af62130 | €35.00 | €0.50 | matched |
| 30 | capture | 01a1b608-515c-758f-b0f8-d264d3a796be | €9.00 | €0.19 | matched |
| 31 | capture | 01a1b608-5ad1-7864-a1bf-807a12af1240 | €9.00 | €0.19 | matched |
| 32 | capture | 01a1b608-5d35-7b4d-b5e9-b6b11979a296 | €35.00 | €0.50 | matched |
| 33 | capture | 01a1b608-78fd-7f9f-9d6d-83779d816482 | €15.00 | €0.26 | matched |
| 35 | capture | 01a1b608-7ad3-7ff2-8ccd-790889535691 | €35.00 | €0.50 | matched |
| 36 | capture | 01a1b608-83cf-7921-8638-88109b646dfd | €35.00 | €0.50 | matched |
| 37 | capture | 01a1b608-8bc4-7b85-9159-bccc66c1a34a | €35.00 | €0.50 | matched |
| 38 | capture | 01a1b608-8777-79ca-afe8-0e2bf9e47842 | €49.00 | €0.67 | matched |
| 39 | capture | 01a1b608-9417-71e3-a012-acd059c415ef | €49.00 | €0.67 | matched |
| 40 | capture | 01a1b608-a6ea-781d-99fc-6931acac2d43 | €49.00 | €0.67 | matched |
| 41 | capture | 01a1b608-afb4-7202-a687-25ab97f03236 | €15.00 | €0.26 | matched |
| 42 | refund | 01a1b608-ca07-72fa-9fbd-df1be62a61a8 | -€30.00 | €0.00 | matched |
| 44 | capture | 01a1b608-cdad-7f24-9378-ab3f544ff527 | €49.00 | €0.67 | matched |
| 45 | capture | 01a1b608-dff7-723d-b477-190e2e7846fb | €15.00 | €0.26 | matched |
| 46 | capture | 01a1b608-e377-7945-96ed-4a876483968b | €35.00 | €0.50 | matched |
| 47 | capture | 01a1b609-1181-7a0e-905e-fe3f74d6c760 | €24.00 | €0.37 | matched |
| 48 | capture | 01a1b609-0fa0-73be-801d-3ec8b8ff5508 | €24.00 | €0.37 | matched |
| 49 | capture | 01a1b609-16a6-72b7-939f-e248f977aaf4 | €35.00 | €0.50 | matched |
| 50 | capture | 01a1b609-2805-7fd3-977e-30c6a7ea224b | €9.00 | €0.19 | matched |
| 51 | capture | 01a1b609-377e-7ddc-80b0-f42cf2b38bcd | €15.00 | €0.26 | matched |
| 52 | capture | 01a1b609-367b-7d93-8c43-a50b0330e0f7 | €9.00 | €0.19 | matched |
| 53 | capture | 01a1b609-401d-758a-b057-ece66ae9ef76 | €15.00 | €0.26 | matched |
| 54 | capture | 01a1b609-4666-737a-9eda-cb49daba3fce | €49.00 | €0.67 | matched |
| 55 | capture | 01a1b609-5644-7d26-82bc-cbf4ef5ad305 | €15.00 | €0.26 | matched |
| 56 | capture | 01a1b609-7845-765b-af00-f3af15908acb | €24.00 | €0.37 | matched |
| 57 | capture | 01a1b609-7b6a-7958-bf11-c9eba61c1431 | €35.00 | €0.50 | matched |
| 58 | capture | 01a1b609-8771-7590-b883-34eca500d58b | €35.00 | €0.50 | matched |
| 59 | capture | 01a1b609-91a1-7e3b-ac84-f9139de0f120 | €24.00 | €0.37 | matched |
| 60 | capture | 01a1b609-9221-79fd-a8cb-42da9e83212a | €35.00 | €0.50 | matched |
| 61 | capture | 01a1b609-a4e7-70dc-a431-e0386200fd5f | €49.00 | €0.67 | matched |
| 62 | capture | 01a1b609-9146-78f8-92c6-2508103d62a5 | €24.00 | €0.37 | matched |
| 63 | refund | 01a1b609-b554-73a8-98b0-e8d1071c211c | -€26.00 | €0.00 | matched |
| 64 | capture | 01a1b609-c525-7b31-a5ff-8a451df308df | €35.00 | €0.50 | matched |
| 65 | refund | 01a1b609-cf5a-74b6-9872-a20f464ff293 | -€5.00 | €0.00 | matched |
| 66 | capture | 01a1b609-de82-7b99-938c-bfbd3089946b | €49.00 | €0.67 | matched |
| 67 | capture | 01a1b609-f4a9-7574-9a2d-bc5988cfe8b8 | €24.00 | €0.37 | matched |
| 68 | refund | 01a1b609-f4f5-7fdb-9c8b-6b59d8dc9bd2 | -€36.00 | €0.00 | matched |
| 69 | refund | 01a1b60a-0432-725a-99f3-7181ca7fcc77 | -€11.00 | €0.00 | matched |
| 70 | capture | 01a1b60a-27f4-75b5-8fd9-92e75580f32f | €15.00 | €0.26 | matched |
| 71 | capture | 01a1b60a-292b-75cb-bde6-fb439f3c8019 | €35.00 | €0.50 | matched |
| 72 | capture | 01a1b60a-3282-7f2f-869a-7d2fbddc1b86 | €35.00 | €0.50 | matched |
| 73 | capture | 01a1b60a-3b22-7617-a274-7f4ee97ed73a | €35.00 | €0.50 | matched |
| 74 | capture | 01a1b60a-5aa4-7c7f-84b9-bc1316316b97 | €49.00 | €0.67 | matched |
| 75 | capture | 01a1b60a-67d8-7fd5-82b4-dffe0e6dcd8e | €24.00 | €0.37 | matched |
| 76 | capture | 01a1b60a-6856-7565-9ec4-b64d156d0e63 | €24.00 | €0.37 | matched |
| 77 | capture | 01a1b60a-7e82-7dbb-9e19-5734213e7070 | €49.00 | €0.67 | matched |
| 78 | capture | 01a1b60a-85dd-7150-b277-7a64796d070d | €49.00 | €0.67 | matched |
| 79 | capture | 01a1b60a-8cbf-7dac-b9ef-5395f25d4ccb | €49.00 | €0.67 | matched |
| 80 | capture | 01a1b60a-9438-74ed-8ed7-75cd69fcf97d | €35.00 | €0.50 | matched |
| 81 | capture | 01a1b60a-988e-780c-8e0a-3009e2b8ca0c | €35.00 | €0.50 | matched |
| 82 | capture | 01a1b60a-9d82-7010-aac9-ebc714e1ce49 | €49.00 | €0.67 | matched |
| 83 | capture | 01a1b60a-a517-7915-baff-ea0ba93a0b44 | €35.00 | €0.50 | matched |
| 84 | capture | 01a1b60a-aebf-70ef-a140-dfdba50af57d | €24.00 | €0.37 | matched |
| 85 | capture | 01a1b60a-d01a-7c49-a850-456e94a19365 | €49.00 | €0.67 | matched |
| 86 | capture | 01a1b60a-f409-7df3-98f6-b9c671c8c28e | €9.00 | €0.19 | matched |
| 87 | capture | 01a1b60a-fe55-713c-817a-e48200156ac9 | €9.00 | €0.19 | matched |
| 88 | capture | 01a1b60b-00b4-737c-a783-7e0858258d79 | €49.00 | €0.67 | matched |
| 89 | capture | 01a1b60b-1218-77d7-a1a1-07a6d77f715e | €24.00 | €0.37 | matched |
| 90 | capture | 01a1b60b-2077-7325-a400-fbc1898bc109 | €35.00 | €0.50 | matched |
| 91 | capture | 01a1b60b-3319-73c3-bb92-68d882fc62c4 | €9.00 | €0.19 | matched |
| 92 | capture | 01a1b60b-4694-72aa-8f9d-8e3b7d6ff203 | €9.00 | €0.19 | matched |
| 94 | capture | 01a1b60b-672b-7c3f-8884-3fa04ee0b008 | €49.00 | €0.67 | matched |
| 95 | capture | 01a1b60b-74b2-72d4-8cd6-8995b88c6599 | €24.00 | €0.37 | matched |
| 96 | capture | 01a1b60b-7d69-77f7-b840-77d29557cb64 | €49.00 | €0.67 | matched |
| 97 | capture | 01a1b60b-9724-7661-a2f9-d1b48d88b3a0 | €35.00 | €0.50 | matched |
| 98 | capture | 01a1b60b-a007-7301-a988-1b08dee7a991 | €24.00 | €0.37 | matched |
| 99 | capture | 01a1b60b-a9d2-77e8-93b1-fc9a0c2850dc | €35.00 | €0.50 | matched |
| 100 | capture | 01a1b60b-b97f-7899-b03a-bcc56a02ca5d | €24.00 | €0.37 | matched |
| 101 | capture | 01a1b60b-c9d4-71be-b9cd-1add5036329b | €15.00 | €0.26 | matched |
| 102 | capture | 01a1b60b-e270-7034-b6ec-15a51195c38e | €35.00 | €0.50 | matched |
| 103 | capture | 01a1b60b-ef63-7406-a01b-78c8fd3105a8 | €9.00 | €0.19 | matched |
| 104 | capture | 01a1b60c-0676-7f27-b547-cb187fdb1b3f | €49.00 | €0.67 | matched |
| 105 | capture | 01a1b60c-18c5-7e49-87e7-0065f1c4e5a4 | €9.00 | €0.19 | matched |
| 106 | capture | 01a1b60c-2ceb-7580-82a6-20ad602c46ed | €49.00 | €0.67 | matched |
| 107 | capture | 01a1b60c-5347-72b5-8fbf-f2822575df95 | €15.00 | €0.26 | matched |
| 108 | capture | 01a1b60c-629b-74ef-8638-58df50de71ad | €15.00 | €0.26 | matched |
| 109 | capture | 01a1b60c-6608-7bef-b6f4-a64a524dd23a | €35.00 | €0.50 | matched |
| 110 | capture | 01a1b60c-6ed3-7cbf-aa01-461ce35bd451 | €49.00 | €0.67 | matched |
| 111 | capture | 01a1b60c-76fe-72df-9de7-28807bce61fe | €24.00 | €0.37 | matched |
| 112 | capture | 01a1b60c-8b55-7a0f-8c5a-902d8d92303d | €49.00 | €0.67 | matched |
| 113 | capture | 01a1b60c-c7d0-742d-9830-641828891d02 | €9.00 | €0.19 | matched |
| 114 | capture | 01a1b60c-ce7c-7c6e-8a77-35ae6421a855 | €49.00 | €0.67 | matched |
| 115 | capture | 01a1b60c-e450-7a4c-a718-78309da39168 | €15.00 | €0.26 | matched |
| 116 | capture | 01a1b60c-e55c-7d8f-b8c7-558ad8169dce | €49.00 | €0.67 | matched |
| 117 | capture | 01a1b60c-f031-7773-a356-57ffe08fee84 | €24.00 | €0.37 | matched |
| 118 | capture | 01a1b60c-f65c-7a35-9cf4-4b137088ff28 | €15.00 | €0.26 | matched |
| 119 | capture | 01a1b60c-fbc4-7073-a39f-5471f7e07ad9 | €15.00 | €0.26 | matched |
| 120 | capture | 01a1b60c-fcd5-7d14-a658-b12ebcd4fd80 | €49.00 | €0.67 | matched |
| 121 | capture | 01a1b60d-00c4-7dc8-8f5a-25aece707d69 | €15.00 | €0.26 | matched |
| 122 | capture | 01a1b60d-5c44-7baf-865a-e87a5aee10f3 | €49.00 | €0.67 | matched |
| 123 | capture | 01a1b60d-7c85-7335-8ec0-9c0c4c43fc09 | €49.00 | €0.67 | matched |
| 124 | capture | 01a1b60d-93b7-7727-9dc5-431c0583dcaa | €24.00 | €0.37 | matched |
| 125 | capture | 01a1b60d-9957-7610-affc-3a5eb9cc1af2 | €9.00 | €0.19 | matched |
| 126 | capture | 01a1b60d-aba3-7c87-8f41-7aeeb9417dd6 | €9.00 | €0.19 | matched |
| 127 | capture | 01a1b60d-c4da-7593-bbcc-60a88508ad92 | €24.00 | €0.37 | matched |
| 128 | capture | 01a1b60d-d205-7ef2-8f78-a4d5a6f48eb6 | €9.00 | €0.19 | matched |
| 129 | capture | 01a1b60d-e28c-70ee-b643-27e3ad6f2b38 | €9.00 | €0.19 | matched |
| 130 | capture | 01a1b60e-0811-75d8-9b77-87e39b46a7f8 | €49.00 | €0.67 | matched |
| 131 | capture | 01a1b60e-4390-7c54-9469-a194d35ae0e3 | €35.00 | €0.50 | matched |
| 132 | capture | 01a1b60e-5b34-74d7-90de-e0b2a87aa7e4 | €24.00 | €0.37 | matched |
| 133 | capture | 01a1b60e-84b2-73f1-8bc0-0755a6be04e0 | €35.00 | €0.50 | matched |
| 134 | capture | 01a1b60e-8d4a-7763-833e-b1c91aae4f5f | €9.00 | €0.19 | matched |
| 135 | refund | 01a1b60e-9524-7263-99f7-e0775d950b93 | -€16.00 | €0.00 | matched |
| 136 | refund | 01a1b60e-9bed-75f2-89b9-c50506382f72 | -€22.00 | €0.00 | matched |
| 137 | capture | 01a1b60e-a950-7c8e-aad9-816a8b84fd09 | €15.00 | €0.26 | matched |
| 138 | capture | 01a1b60e-ba75-7602-a570-673a04d3296b | €35.00 | €0.50 | matched |
| 139 | capture | 01a1b60e-bcdd-7cce-b874-9658e4971975 | €24.00 | €0.37 | matched |
| 140 | capture | 01a1b60e-be7a-75c2-9c5e-c06dd148dacc | €15.00 | €0.26 | matched |
| 141 | capture | 01a1b60e-d5cc-798c-97d7-443cedb0fede | €15.00 | €0.26 | matched |
| 142 | capture | 01a1b60e-dd72-75ae-8c64-3a419c8eefb2 | €35.00 | €0.50 | matched |