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
- 19 Oct, 10:30114 lines2 breaks
- 19 Oct, 10:20115 lines2 breaks
- 19 Oct, 10:10123 lines1 break
- 19 Oct, 10:00121 lines4 breaks
- 19 Oct, 09:50127 lines2 breaks
- 19 Oct, 09:40124 lines4 breaks
- 19 Oct, 09:30130 lines2 breaks
- 19 Oct, 09:20131 lines3 breaks
- 19 Oct, 09:10118 lines1 break
- 19 Oct, 09:00117 lines8 breaks
- 19 Oct, 08:50126 lines5 breaks
- 19 Oct, 08:40114 lines1 break
- 19 Oct, 08:30107 lines1 break
- 19 Oct, 08:20146 lines4 breaks
19 Oct, 08:50
Gross
€2,895.00
PSP fee
€46.14
Net to the bank
€2,848.86
Settlement journal
#84389
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1535a-abc9-7512-967d-0bea42e76e7a is already settled by stl_EUR_2987333 line 7
- duplicate linethe file lists it twicecapture:01a15360-51f6-78cf-ac6d-57196d78ba9c is already settled by stl_EUR_2987333 line 83
- duplicate linethe file lists it twicecapture:01a15361-efd4-7eac-9b6d-f6f1fe3bda49 is already settled by stl_EUR_2987333 line 106
- fee differencethe fee is not the contract feethe fee is 2, the contract says 0
- missing linein the books, not in the filecapture:01a1535d-00b1-7fbc-8393-92e52a8c219d is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 8 | capture | 01a1535a-abe6-734f-bb65-e3f3e7f725fb | €24.00 | €0.37 | duplicate line |
| 84 | capture | 01a15360-521d-70ec-bb46-21f873bc6d3e | €15.00 | €0.26 | duplicate line |
| 94 | refund | 01a15360-c06f-74b9-8176-6cf0f44191be | -€3.00 | €0.02 | fee difference |
| 107 | capture | 01a15361-f00a-7760-a69f-8a4aeb6b3dd9 | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a15352-80ae-7c92-8c44-336e087c5e8b | €35.00 | €0.50 | matched |
| 2 | capture | 01a1535a-385a-7443-8146-cfc03a189517 | €9.00 | €0.19 | matched |
| 3 | capture | 01a1535a-826f-769e-936f-b70c3a01aa0b | €15.00 | €0.26 | matched |
| 4 | capture | 01a1535a-8956-73bf-9442-1daf5ad238e6 | €49.00 | €0.67 | matched |
| 5 | capture | 01a1535a-8e29-781a-8f84-3328d865e2f3 | €35.00 | €0.50 | matched |
| 6 | refund | 01a1535a-9c9b-7d7d-b5f1-1d53cb5d2b83 | -€12.00 | €0.00 | matched |
| 7 | capture | 01a1535a-abe6-734f-bb65-e3f3e7f725fb | €24.00 | €0.37 | matched |
| 9 | capture | 01a1535a-bd7c-7349-8c57-df4caef9462d | €9.00 | €0.19 | matched |
| 10 | capture | 01a1535a-c7eb-737b-bdf1-a0589eab35ea | €35.00 | €0.50 | matched |
| 11 | capture | 01a1535a-dd1c-7a0f-b97d-3bf6c5b775e5 | €24.00 | €0.37 | matched |
| 12 | capture | 01a1535a-e26e-723b-898b-9d80a49e1853 | €15.00 | €0.26 | matched |
| 13 | capture | 01a1535a-e5e6-7f23-994e-e4b50aa7867a | €24.00 | €0.37 | matched |
| 14 | capture | 01a1535b-1e3d-7b7b-96b0-d789ba4df2fa | €9.00 | €0.19 | matched |
| 15 | refund | 01a1535b-3403-7549-b56e-896055d7d2d4 | -€29.00 | €0.00 | matched |
| 16 | capture | 01a1535b-4fbb-722e-8847-31722783d2d6 | €49.00 | €0.67 | matched |
| 17 | capture | 01a1535b-644f-7f76-9a4e-2fd3ed3354d3 | €35.00 | €0.50 | matched |
| 18 | capture | 01a1535b-658c-7fcb-8c4b-1dc488b53759 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1535b-6fca-758d-93be-07c9c858cb27 | €24.00 | €0.37 | matched |
| 20 | capture | 01a1535b-896c-745d-a591-601616f294fb | €15.00 | €0.26 | matched |
| 21 | capture | 01a1535b-8bce-750a-a12c-ca2a4be7a4ca | €9.00 | €0.19 | matched |
| 22 | capture | 01a1535b-a806-79fc-bdf9-cf13ee294eb0 | €49.00 | €0.67 | matched |
| 23 | capture | 01a1535b-a999-7ffa-93ea-c7284bb49152 | €9.00 | €0.19 | matched |
| 24 | capture | 01a1535b-b9e6-7542-94de-cc122b12860e | €15.00 | €0.26 | matched |
| 25 | capture | 01a1535b-c068-77a7-88be-f7588c30138e | €15.00 | €0.26 | matched |
| 26 | capture | 01a1535b-c970-72fb-ab89-2f081c2d4131 | €15.00 | €0.26 | matched |
| 27 | capture | 01a1535b-d77b-794a-a029-4b23213d09c1 | €49.00 | €0.67 | matched |
| 28 | capture | 01a1535b-f2a4-7234-9db6-724519a5a262 | €24.00 | €0.37 | matched |
| 29 | capture | 01a1535c-05c9-71a3-b80e-30619f3bd326 | €49.00 | €0.67 | matched |
| 30 | capture | 01a1535c-09c3-7a65-a9a7-0149e9026e47 | €35.00 | €0.50 | matched |
| 31 | capture | 01a1535c-0c0f-722b-a1eb-10a32365d8a5 | €35.00 | €0.50 | matched |
| 32 | capture | 01a1535c-233d-7068-a6e0-a333a6d4b3e8 | €49.00 | €0.67 | matched |
| 33 | refund | 01a1535c-4b28-7027-8958-c3ca6acc287c | -€13.00 | €0.00 | matched |
| 34 | capture | 01a1535c-5ab6-7e35-be45-666e657ae174 | €9.00 | €0.19 | matched |
| 35 | capture | 01a1535c-6151-7006-87c5-a5518b1c568a | €24.00 | €0.37 | matched |
| 36 | capture | 01a1535c-6502-7de5-b962-f6ea8895f8a8 | €15.00 | €0.26 | matched |
| 37 | capture | 01a1535c-6c47-776f-9866-37e7c71cd327 | €49.00 | €0.67 | matched |
| 38 | capture | 01a1535c-9eba-73e2-b651-546c1d45cd73 | €24.00 | €0.37 | matched |
| 39 | capture | 01a1535c-dc97-7eb2-86ed-5f1738046a9a | €49.00 | €0.67 | matched |
| 40 | capture | 01a1535c-f06b-77d4-9608-5d7ac4783b23 | €49.00 | €0.67 | matched |
| 41 | capture | 01a1535d-0f86-7e6c-80ad-ec917e7b6d74 | €9.00 | €0.19 | matched |
| 42 | capture | 01a1535d-3fb1-7fd0-a9a0-72c1bf28ed15 | €15.00 | €0.26 | matched |
| 43 | capture | 01a1535d-506e-77b8-9b11-d2fc02253306 | €35.00 | €0.50 | matched |
| 44 | capture | 01a1535d-56c9-7226-a3a4-0e0706df4fc5 | €49.00 | €0.67 | matched |
| 45 | capture | 01a1535d-5b33-7255-a9ef-c08e74147718 | €9.00 | €0.19 | matched |
| 46 | capture | 01a1535d-628f-78b7-855c-f65f9077a75c | €9.00 | €0.19 | matched |
| 47 | capture | 01a1535d-7235-7f31-991e-36f90521de87 | €49.00 | €0.67 | matched |
| 48 | capture | 01a1535d-9482-7942-8d13-d719dec4d633 | €49.00 | €0.67 | matched |
| 49 | capture | 01a1535d-9fd2-76c4-b9ee-b8e1fb8da6c9 | €9.00 | €0.19 | matched |
| 50 | capture | 01a1535d-b6e4-7e49-8a03-ab2df2ed7da0 | €35.00 | €0.50 | matched |
| 51 | capture | 01a1535d-dd2c-7d3b-8ed9-222861d35d41 | €24.00 | €0.37 | matched |
| 52 | capture | 01a1535d-eefb-782b-b443-1283262523d9 | €49.00 | €0.67 | matched |
| 53 | capture | 01a1535d-f2d9-7fec-b9e8-8322b808c396 | €24.00 | €0.37 | matched |
| 54 | capture | 01a1535d-f461-792d-a590-29ae6db14469 | €49.00 | €0.67 | matched |
| 55 | capture | 01a1535e-02eb-795b-94ee-07e98e9047f6 | €24.00 | €0.37 | matched |
| 56 | capture | 01a1535e-05b5-7838-af58-5b277dd12463 | €9.00 | €0.19 | matched |
| 57 | capture | 01a1535e-06d7-76ba-b485-d55f1e3043ca | €9.00 | €0.19 | matched |
| 58 | capture | 01a1535e-0a3b-788f-b2c5-a88eb0e6f2c8 | €49.00 | €0.67 | matched |
| 59 | capture | 01a1535e-1c8a-74fa-a305-57733ae045e9 | €35.00 | €0.50 | matched |
| 60 | capture | 01a1535e-3b3e-73a5-8984-d96fd89fc17c | €15.00 | €0.26 | matched |
| 61 | capture | 01a1535e-3ced-71c8-8098-e91a97dc21c3 | €9.00 | €0.19 | matched |
| 62 | capture | 01a1535e-46b6-7c8c-9a61-921d38ff7ca9 | €24.00 | €0.37 | matched |
| 63 | capture | 01a1535e-6fd2-776e-aea7-024b7539fa19 | €49.00 | €0.67 | matched |
| 64 | capture | 01a1535e-a24b-7e38-929f-5948cf384da3 | €49.00 | €0.67 | matched |
| 65 | capture | 01a1535e-a8ed-7309-9385-c107ccd65080 | €9.00 | €0.19 | matched |
| 66 | capture | 01a1535e-c640-7704-ab14-9f31dc4de8bd | €35.00 | €0.50 | matched |
| 67 | capture | 01a1535e-db22-7196-9239-0fb1411c6968 | €15.00 | €0.26 | matched |
| 68 | refund | 01a1535f-168d-786a-896a-fa86b3e91d17 | -€34.00 | €0.00 | matched |
| 69 | capture | 01a1535f-2d86-71d0-9b74-70ff9a2f6106 | €35.00 | €0.50 | matched |
| 70 | capture | 01a1535f-4589-7ef6-9312-7231087bfe32 | €35.00 | €0.50 | matched |
| 71 | capture | 01a1535f-5fd5-7c1f-bd16-9892dbb776e9 | €24.00 | €0.37 | matched |
| 72 | capture | 01a1535f-6030-7b53-8a2b-ff21d372568d | €49.00 | €0.67 | matched |
| 73 | capture | 01a1535f-71e2-7466-a3e1-b8aa11a3ac29 | €24.00 | €0.37 | matched |
| 74 | capture | 01a1535f-8832-7eed-97c1-598dc6a7b9f6 | €9.00 | €0.19 | matched |
| 75 | capture | 01a1535f-8aae-7562-afe7-da2cc2824598 | €49.00 | €0.67 | matched |
| 76 | capture | 01a1535f-9fbe-732a-9d69-107ca6863096 | €9.00 | €0.19 | matched |
| 77 | capture | 01a1535f-a1e2-7bdb-8eae-35bcc133426d | €49.00 | €0.67 | matched |
| 78 | capture | 01a1535f-c5e4-7191-a81b-fc60c1092014 | €9.00 | €0.19 | matched |
| 79 | capture | 01a1535f-cdae-72be-8d3a-9114fdad728c | €49.00 | €0.67 | matched |
| 80 | capture | 01a1535f-d8f2-7a50-8ce7-8e29cf7955fd | €24.00 | €0.37 | matched |
| 81 | capture | 01a1535f-f3c5-79b0-930b-038a32a0b7c6 | €15.00 | €0.26 | matched |
| 82 | refund | 01a1535f-fdc5-74ea-ae67-9d88dadd268e | -€6.00 | €0.00 | matched |
| 83 | capture | 01a15360-521d-70ec-bb46-21f873bc6d3e | €15.00 | €0.26 | matched |
| 85 | capture | 01a15360-5976-79ae-957c-a21a167df6c5 | €24.00 | €0.37 | matched |
| 86 | capture | 01a15360-59b0-756a-9336-eef515200940 | €15.00 | €0.26 | matched |
| 87 | capture | 01a15360-6889-7aac-9cb3-9cd81fce000e | €15.00 | €0.26 | matched |
| 88 | capture | 01a15360-750b-7440-9df4-f4639f153cfc | €35.00 | €0.50 | matched |
| 89 | capture | 01a15360-817d-7c52-9491-ebcb00f5b5a1 | €35.00 | €0.50 | matched |
| 90 | refund | 01a15360-86e8-7dbf-8406-ff52b07e9ebf | -€19.00 | €0.00 | matched |
| 91 | capture | 01a15360-8bfa-7919-8d8f-82be773071d5 | €24.00 | €0.37 | matched |
| 92 | capture | 01a15360-913c-7ab7-a097-05d5b0063e7b | €15.00 | €0.26 | matched |
| 93 | capture | 01a15360-b770-7e3e-9080-8a17b949c235 | €9.00 | €0.19 | matched |
| 95 | capture | 01a15360-c3f6-7bdf-a644-e73dcce3589c | €9.00 | €0.19 | matched |
| 96 | capture | 01a15360-c61f-7a8e-8795-aa56af71a08b | €35.00 | €0.50 | matched |
| 97 | capture | 01a15360-ce87-721c-b753-94d02cd684d8 | €35.00 | €0.50 | matched |
| 98 | capture | 01a15361-1aab-7fb4-8948-cf641ed6aa48 | €15.00 | €0.26 | matched |
| 99 | capture | 01a15361-3c97-7016-84e5-610868fb9cd3 | €24.00 | €0.37 | matched |
| 100 | capture | 01a15361-8242-705d-a588-2bc804803d16 | €49.00 | €0.67 | matched |
| 101 | capture | 01a15361-8f4a-72b7-ba03-25495a0d1158 | €35.00 | €0.50 | matched |
| 102 | capture | 01a15361-a997-7634-9586-1b3fd7f777e8 | €24.00 | €0.37 | matched |
| 103 | capture | 01a15361-ae1e-743f-9259-056cb67585ca | €24.00 | €0.37 | matched |
| 104 | capture | 01a15361-b2ba-7d6b-811b-f99e99d8671d | €35.00 | €0.50 | matched |
| 105 | refund | 01a15361-d45b-71be-a923-a46801be4ed3 | -€34.00 | €0.00 | matched |
| 106 | capture | 01a15361-f00a-7760-a69f-8a4aeb6b3dd9 | €35.00 | €0.50 | matched |
| 108 | capture | 01a15361-f95a-7db5-9bdd-c297aa74005a | €35.00 | €0.50 | matched |
| 109 | capture | 01a15362-16c8-7fc4-8b55-041331839cd8 | €15.00 | €0.26 | matched |
| 110 | refund | 01a15362-1e0b-7602-aa7d-7fd085cb61c6 | -€9.00 | €0.00 | matched |
| 111 | capture | 01a15362-22aa-7a36-8931-58e9cf1b3385 | €24.00 | €0.37 | matched |
| 112 | capture | 01a15362-26ac-7670-98c4-a12f655cafe1 | €15.00 | €0.26 | matched |
| 113 | capture | 01a15362-4779-7c8e-8d7d-297d5a2da202 | €49.00 | €0.67 | matched |
| 114 | capture | 01a15362-60bf-7bcf-aee3-89da3ee191cc | €24.00 | €0.37 | matched |
| 115 | capture | 01a15362-64d1-75b9-be82-06e90f4e7028 | €24.00 | €0.37 | matched |
| 116 | capture | 01a15362-72ce-7513-bc05-d3caa6853182 | €35.00 | €0.50 | matched |
| 117 | capture | 01a15362-8133-7d48-8eab-101e2ed11644 | €24.00 | €0.37 | matched |
| 118 | capture | 01a15362-9d8d-79d3-97ba-efa3a7c77a4a | €24.00 | €0.37 | matched |
| 119 | capture | 01a15362-d215-7bd5-8519-8dc0e5ad0aff | €15.00 | €0.26 | matched |
| 120 | capture | 01a15362-d912-7ccd-a127-15753a7cfa9b | €24.00 | €0.37 | matched |
| 121 | capture | 01a15362-dd75-7ddd-87ca-de6b59775674 | €9.00 | €0.19 | matched |
| 122 | capture | 01a15363-068d-7043-91bf-a50a4012089f | €15.00 | €0.26 | matched |
| 123 | capture | 01a15363-0b55-726f-8985-29eef2a6afcc | €9.00 | €0.19 | matched |
| 124 | refund | 01a15363-0f07-7b77-a2ca-4bbfa48a6193 | -€4.00 | €0.00 | matched |
| 125 | capture | 01a15363-2118-72ca-aa9d-dfb012ac151f | €15.00 | €0.26 | matched |
| 126 | capture | 01a15363-3f37-704a-92ea-61f4aa23af39 | €9.00 | €0.19 | matched |