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
- 22 Oct, 14:00114 lines1 break
- 22 Oct, 13:50120 lines2 breaks
- 22 Oct, 13:40107 lines1 break
- 22 Oct, 13:30129 lines3 breaks
- 22 Oct, 13:20111 lines5 breaks
- 22 Oct, 13:10135 lines1 break
- 22 Oct, 13:00118 lines1 break
- 22 Oct, 12:50140 lines8 breaks
- 22 Oct, 12:40116 lines6 breaks
- 22 Oct, 12:30125 lines2 breaks
- 22 Oct, 12:20128 lines4 breaks
- 22 Oct, 12:10107 lines1 break
- 22 Oct, 12:00146 lines3 breaks
- 22 Oct, 11:50138 lines4 breaks
22 Oct, 12:50
Gross
€3,228.00
PSP fee
€51.60
Net to the bank
€3,176.40
Settlement journal
#142035
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a163af-7a0e-7141-9945-af52b76ac30f is already settled by stl_EUR_2987789 line 85
- duplicate linethe file lists it twicecapture:01a163b0-cfeb-7d94-8f74-708b244a0697 is already settled by stl_EUR_2987789 line 116
- fee differencethe fee is not the contract feethe fee is 51, the contract says 50
- fee differencethe fee is not the contract feethe fee is 55, the contract says 50
- fee differencethe fee is not the contract feethe fee is 70, the contract says 67
- missing linein the books, not in the filecapture:01a163af-7d55-78e7-a641-31a1e5917b88 is in no file
- missing linein the books, not in the filecapture:01a163aa-2efc-74d6-b68c-16e75fbb4d9f is in no file
- missing linein the books, not in the filecapture:01a163aa-d310-73e8-931a-4d0fdb176ccb is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 2 | capture | 01a163a7-01e3-784b-aaf7-c964b07aee50 | €24.00 | €0.38 | fee difference |
| 7 | capture | 01a163a9-817d-7130-b646-b57ca350bf8c | €35.00 | €0.51 | fee difference |
| 55 | capture | 01a163ad-f7a4-76b9-a93b-da0e4b1ce6fd | €35.00 | €0.55 | fee difference |
| 86 | refund | 01a163af-7a12-77d9-9bd0-f0e6f7f2300c | -€24.00 | €0.00 | duplicate line |
| 104 | capture | 01a163b0-51cf-783f-9628-6c52d9e8ddb3 | €49.00 | €0.70 | fee difference |
| 117 | capture | 01a163b0-d05c-74ef-a6eb-2b99f31421a9 | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a163a1-2f00-7ce6-9abc-6c6478da3a42 | €24.00 | €0.37 | matched |
| 3 | capture | 01a163a9-52cc-737a-a622-52f0fc9c3a52 | €15.00 | €0.26 | matched |
| 4 | capture | 01a163a9-5f0e-7024-9106-d86a4ad341b1 | €24.00 | €0.37 | matched |
| 5 | refund | 01a163a9-5fbd-735d-a13c-6cd9dec4b031 | -€9.00 | €0.00 | matched |
| 6 | capture | 01a163a9-7dbf-7464-a20f-6b90116b7625 | €24.00 | €0.37 | matched |
| 8 | capture | 01a163a9-9289-76e3-bb34-10e52e5d7894 | €24.00 | €0.37 | matched |
| 9 | capture | 01a163a9-990d-78b2-a4a2-d5aba3d4cbd7 | €15.00 | €0.26 | matched |
| 10 | capture | 01a163a9-aab6-7c35-85c1-e543294844b7 | €35.00 | €0.50 | matched |
| 11 | capture | 01a163a9-b89f-7528-a33e-b191fb9c6ecb | €24.00 | €0.37 | matched |
| 12 | capture | 01a163a9-dea7-777d-a57c-b1223f3d351c | €49.00 | €0.67 | matched |
| 13 | capture | 01a163a9-fc93-7a6e-a05e-3d81dcddbdb8 | €49.00 | €0.67 | matched |
| 14 | capture | 01a163aa-15df-75fc-835e-cb1c23950a51 | €15.00 | €0.26 | matched |
| 15 | capture | 01a163aa-2a84-7ff1-9c38-ba20924ee8d4 | €49.00 | €0.67 | matched |
| 16 | capture | 01a163aa-3d2d-776e-a66c-027803310b2a | €49.00 | €0.67 | matched |
| 17 | capture | 01a163aa-664c-775c-85a4-162a346a34e5 | €35.00 | €0.50 | matched |
| 18 | capture | 01a163aa-82f9-7438-a4bc-a817285c845a | €15.00 | €0.26 | matched |
| 19 | capture | 01a163aa-a5de-7c92-aba9-c8ce308ba0fd | €35.00 | €0.50 | matched |
| 20 | capture | 01a163aa-b8f2-74f7-add9-3c887b1b4601 | €15.00 | €0.26 | matched |
| 21 | capture | 01a163aa-ecde-739e-b0ac-707632967050 | €35.00 | €0.50 | matched |
| 22 | capture | 01a163ab-038a-7197-ad93-4434289e1a02 | €49.00 | €0.67 | matched |
| 23 | refund | 01a163ab-17aa-7fcb-a536-f74088ad810d | -€24.00 | €0.00 | matched |
| 24 | capture | 01a163ab-36d3-752a-8eaf-52f00fa9090f | €49.00 | €0.67 | matched |
| 25 | capture | 01a163ab-5d22-721b-bcd7-9a667a51d8c5 | €49.00 | €0.67 | matched |
| 26 | capture | 01a163ab-953b-7b80-9408-115c6eecda1a | €24.00 | €0.37 | matched |
| 27 | capture | 01a163ab-9977-79cc-8e13-b4a932009995 | €49.00 | €0.67 | matched |
| 28 | capture | 01a163ab-a0c5-798e-871f-fd7fa53182ac | €49.00 | €0.67 | matched |
| 29 | capture | 01a163ab-a470-7398-9322-ea3fe0558714 | €35.00 | €0.50 | matched |
| 30 | capture | 01a163ab-c0eb-7bb8-935a-f8c2cf17eeb0 | €24.00 | €0.37 | matched |
| 31 | capture | 01a163ab-d4a6-7f81-9f83-dcadb7ba6409 | €9.00 | €0.19 | matched |
| 32 | capture | 01a163ab-e0f4-7708-a832-0e4027e02c5b | €35.00 | €0.50 | matched |
| 33 | capture | 01a163ab-e429-710a-9bed-e0a1907e202d | €35.00 | €0.50 | matched |
| 34 | capture | 01a163ab-e7f1-70f4-aa39-da1e3d678ff9 | €49.00 | €0.67 | matched |
| 35 | capture | 01a163ab-f64c-7665-9e12-66db709b458a | €9.00 | €0.19 | matched |
| 36 | refund | 01a163ac-0058-776e-82eb-505e5b067c0d | -€3.00 | €0.00 | matched |
| 37 | refund | 01a163ac-0f6d-7064-af28-ed89cb17d321 | -€22.00 | €0.00 | matched |
| 38 | capture | 01a163ac-2895-76d1-b661-5f3f37207ab5 | €49.00 | €0.67 | matched |
| 39 | capture | 01a163ac-55be-70fa-8e50-1d702aa40815 | €35.00 | €0.50 | matched |
| 40 | capture | 01a163ac-67cd-7411-b237-a8c65b925b84 | €9.00 | €0.19 | matched |
| 41 | capture | 01a163ac-a20e-76e5-8d73-2b14e59b57b3 | €49.00 | €0.67 | matched |
| 42 | capture | 01a163ac-a5ba-7b2f-b01e-f2537e3b1120 | €49.00 | €0.67 | matched |
| 43 | capture | 01a163ac-ad09-75f5-b90c-0ce669bcbfa5 | €49.00 | €0.67 | matched |
| 44 | capture | 01a163ac-ee11-74fb-badc-927fd0d639b3 | €9.00 | €0.19 | matched |
| 45 | capture | 01a163ad-0b79-702d-bdd8-b6306e8b6904 | €9.00 | €0.19 | matched |
| 46 | capture | 01a163ad-2fa2-7f71-b8a9-7d5d1925a98f | €24.00 | €0.37 | matched |
| 47 | capture | 01a163ad-5597-7e33-86b4-1fdeedb3e075 | €24.00 | €0.37 | matched |
| 48 | capture | 01a163ad-68d9-78f4-ab60-03c5cde33560 | €49.00 | €0.67 | matched |
| 49 | capture | 01a163ad-780a-7e29-80ab-ac489ad96a11 | €35.00 | €0.50 | matched |
| 50 | capture | 01a163ad-8016-7fa3-a1e2-1d7ff339f1e9 | €35.00 | €0.50 | matched |
| 51 | capture | 01a163ad-a6fa-74ab-a38c-d6a4e89dc446 | €9.00 | €0.19 | matched |
| 52 | capture | 01a163ad-d4d7-7741-863a-f01251d1769a | €35.00 | €0.50 | matched |
| 53 | capture | 01a163ad-d27a-71c1-8a59-57a5ab5d49e4 | €24.00 | €0.37 | matched |
| 54 | capture | 01a163ad-e04c-7613-97eb-32bafb6450d9 | €15.00 | €0.26 | matched |
| 56 | capture | 01a163ad-fc22-7a67-a076-3e41f56599c6 | €9.00 | €0.19 | matched |
| 57 | capture | 01a163ae-29c4-79e0-b5c2-ed51bc1ebb3d | €24.00 | €0.37 | matched |
| 58 | capture | 01a163ae-4144-78e8-964e-3f1e213496f2 | €35.00 | €0.50 | matched |
| 59 | capture | 01a163ae-5391-736c-a235-92c46b2d0d55 | €24.00 | €0.37 | matched |
| 60 | capture | 01a163ae-564e-7343-8216-a3be282d2e0c | €9.00 | €0.19 | matched |
| 61 | capture | 01a163ae-58d0-7fd0-a6d3-7524761d40dc | €15.00 | €0.26 | matched |
| 62 | capture | 01a163ae-5e79-7d60-b8e0-8892d06f288c | €9.00 | €0.19 | matched |
| 63 | capture | 01a163ae-8b02-7a16-823a-3c580a6463c8 | €24.00 | €0.37 | matched |
| 64 | capture | 01a163ae-9306-7706-8ec2-4b7f84a752a5 | €15.00 | €0.26 | matched |
| 65 | capture | 01a163ae-9cdb-7530-8d65-f8299931e90f | €24.00 | €0.37 | matched |
| 66 | capture | 01a163ae-9f90-7492-8073-336d2154f6b7 | €49.00 | €0.67 | matched |
| 67 | capture | 01a163ae-aff6-7dea-a6d6-3abd7344ee01 | €9.00 | €0.19 | matched |
| 68 | capture | 01a163ae-d7e6-71ad-ad5e-617c598ab885 | €15.00 | €0.26 | matched |
| 69 | capture | 01a163ae-e07e-7c52-9d57-d2f8f690ca03 | €24.00 | €0.37 | matched |
| 70 | capture | 01a163ae-e1f6-77c5-88c6-19b5466f4583 | €49.00 | €0.67 | matched |
| 71 | capture | 01a163ae-ea81-701f-a128-61e79a7cead0 | €9.00 | €0.19 | matched |
| 72 | capture | 01a163ae-eabd-78e7-b466-1c415c5472e0 | €35.00 | €0.50 | matched |
| 73 | capture | 01a163ae-f5e4-7a22-9b31-5552b3605c59 | €35.00 | €0.50 | matched |
| 74 | capture | 01a163af-0428-7c30-ac12-8265e490c0dd | €24.00 | €0.37 | matched |
| 75 | capture | 01a163af-20a9-7b84-b737-74e479765a35 | €15.00 | €0.26 | matched |
| 76 | capture | 01a163af-2e2e-7f85-a7c4-abd5c9d2d1d6 | €15.00 | €0.26 | matched |
| 77 | capture | 01a163af-38fd-7f85-a911-8c6ef95b6d49 | €24.00 | €0.37 | matched |
| 78 | capture | 01a163af-3aa3-79d1-8bc7-69f22d0053bf | €24.00 | €0.37 | matched |
| 79 | capture | 01a163af-3eb2-7ec7-b68c-9d85bf0d3910 | €35.00 | €0.50 | matched |
| 80 | capture | 01a163af-465a-72b2-95a2-252f9ec1b3cc | €9.00 | €0.19 | matched |
| 81 | refund | 01a163af-51af-7687-bcbf-7829f2c1cf52 | -€7.00 | €0.00 | matched |
| 82 | capture | 01a163af-55da-76cb-848c-1986c45da344 | €15.00 | €0.26 | matched |
| 83 | capture | 01a163af-688e-7377-a17a-0aabb476a8f3 | €24.00 | €0.37 | matched |
| 84 | capture | 01a163af-73fd-7481-90ec-f8f63d066750 | €9.00 | €0.19 | matched |
| 85 | refund | 01a163af-7a12-77d9-9bd0-f0e6f7f2300c | -€24.00 | €0.00 | matched |
| 87 | capture | 01a163af-8546-706a-84eb-13bb5b0bd392 | €49.00 | €0.67 | matched |
| 88 | capture | 01a163af-8944-7706-8fae-e3b57384dde9 | €35.00 | €0.50 | matched |
| 89 | capture | 01a163af-9393-78c6-bea2-728530a179fc | €15.00 | €0.26 | matched |
| 90 | capture | 01a163af-94cd-7f91-ac1c-e13962556133 | €15.00 | €0.26 | matched |
| 91 | capture | 01a163af-9c9e-7dee-b57e-46cc4b4d3d37 | €9.00 | €0.19 | matched |
| 92 | refund | 01a163af-a769-73a3-a2e9-b7e113e64284 | -€4.00 | €0.00 | matched |
| 93 | capture | 01a163af-ac26-73b7-8fba-ac7b87a55791 | €49.00 | €0.67 | matched |
| 94 | capture | 01a163af-b8ec-7a4a-9371-b03a3c6cbc3d | €15.00 | €0.26 | matched |
| 95 | capture | 01a163af-c2a7-7ba6-9850-3f5ebd4fda16 | €15.00 | €0.26 | matched |
| 96 | capture | 01a163af-d918-71f6-9659-3afedaa3e4eb | €9.00 | €0.19 | matched |
| 97 | capture | 01a163af-e263-7d34-9db9-24e66dc0015f | €15.00 | €0.26 | matched |
| 98 | capture | 01a163af-ed79-74e7-a88a-1417d7e9d970 | €9.00 | €0.19 | matched |
| 99 | refund | 01a163af-f637-7d56-b304-121683041174 | -€4.00 | €0.00 | matched |
| 100 | capture | 01a163b0-0761-7ec3-b514-94adde5069b4 | €49.00 | €0.67 | matched |
| 101 | capture | 01a163b0-28fb-77a2-812a-9a1969b00130 | €24.00 | €0.37 | matched |
| 102 | capture | 01a163b0-3229-7774-8320-171906583ce3 | €35.00 | €0.50 | matched |
| 103 | capture | 01a163b0-4ed6-74de-b87e-62bee4cd5927 | €15.00 | €0.26 | matched |
| 105 | capture | 01a163b0-56c6-7004-b01d-9ed444b41fc4 | €35.00 | €0.50 | matched |
| 106 | capture | 01a163b0-60c2-7b14-a232-8ef858df45de | €24.00 | €0.37 | matched |
| 107 | capture | 01a163b0-617b-774c-bd77-a920e8bf1066 | €9.00 | €0.19 | matched |
| 108 | capture | 01a163b0-6f6d-7f9d-894c-b3690c78f770 | €49.00 | €0.67 | matched |
| 109 | refund | 01a163b0-8dbd-7f7a-8c87-6b8ef8f21df5 | -€14.00 | €0.00 | matched |
| 110 | refund | 01a163b0-8f3c-76ff-abe4-9ab1e86b937c | -€15.00 | €0.00 | matched |
| 111 | refund | 01a163b0-a4cd-7049-920c-fee889b88369 | -€16.00 | €0.00 | matched |
| 112 | capture | 01a163b0-ad3e-7f64-91a3-8fc0e3ee07b9 | €35.00 | €0.50 | matched |
| 113 | capture | 01a163b0-aeba-7b4b-aa28-cffde938d31a | €15.00 | €0.26 | matched |
| 114 | refund | 01a163b0-c2cc-7ee6-984f-6c670a8c79fd | -€23.00 | €0.00 | matched |
| 115 | refund | 01a163b0-c7f5-76a2-8afe-9f5e8357221d | -€22.00 | €0.00 | matched |
| 116 | capture | 01a163b0-d05c-74ef-a6eb-2b99f31421a9 | €24.00 | €0.37 | matched |
| 118 | capture | 01a163b0-e98c-79ec-b1b2-f612c26b64b7 | €49.00 | €0.67 | matched |
| 119 | capture | 01a163b0-ee3c-70ae-9095-1e86a8b36da5 | €35.00 | €0.50 | matched |
| 120 | capture | 01a163b0-f17d-79df-9fb5-5bc48f011b16 | €9.00 | €0.19 | matched |
| 121 | capture | 01a163b0-f73e-79c6-9ab1-dd5903c9bca7 | €49.00 | €0.67 | matched |
| 122 | capture | 01a163b1-135b-7f8a-bd35-ef2640420d7d | €9.00 | €0.19 | matched |
| 123 | capture | 01a163b1-1d44-74b6-89f2-c9cee78bebd9 | €9.00 | €0.19 | matched |
| 124 | capture | 01a163b1-2176-7879-92bc-aef36d0ed1da | €24.00 | €0.37 | matched |
| 125 | capture | 01a163b1-43df-7dbb-a24f-636f0854b976 | €35.00 | €0.50 | matched |
| 126 | capture | 01a163b1-455c-7576-9f21-465a21334076 | €35.00 | €0.50 | matched |
| 127 | capture | 01a163b1-461e-7636-aa1c-3e3948c16cf0 | €15.00 | €0.26 | matched |
| 128 | capture | 01a163b1-8ae4-75d8-be2a-65cb89bc6e5a | €15.00 | €0.26 | matched |
| 129 | capture | 01a163b1-addf-70d0-9f8e-63807805d391 | €9.00 | €0.19 | matched |
| 130 | capture | 01a163b1-ba41-7809-993f-005c97285943 | €15.00 | €0.26 | matched |
| 131 | capture | 01a163b1-ca46-75bd-a39e-991aab339cd0 | €49.00 | €0.67 | matched |
| 132 | capture | 01a163b1-ddeb-7731-b753-3384aa325e62 | €15.00 | €0.26 | matched |
| 133 | capture | 01a163b1-dfca-7494-bed5-27b126dc0752 | €49.00 | €0.67 | matched |
| 134 | capture | 01a163b1-f1d9-7cc9-8585-ef58e5444d70 | €24.00 | €0.37 | matched |
| 135 | capture | 01a163b2-0fbd-7a45-ba3b-4c8f6ccc7447 | €15.00 | €0.26 | matched |
| 136 | capture | 01a163b2-2489-73c1-8f11-c72f35d06216 | €9.00 | €0.19 | matched |
| 137 | capture | 01a163b2-29ca-7ddf-b26e-dde3d57039ce | €24.00 | €0.37 | matched |
| 138 | capture | 01a163b2-2c23-7700-9336-1c1b3e713a35 | €35.00 | €0.50 | matched |
| 139 | capture | 01a163b2-3a26-76d3-825d-5731077b2d07 | €49.00 | €0.67 | matched |
| 140 | capture | 01a163b2-615c-75b3-a3a9-4595b32df133 | €35.00 | €0.50 | matched |