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
- 1 Nov, 22:20132 lines2 breaks
- 1 Nov, 22:10135 lines3 breaks
- 1 Nov, 22:00134 linesclean
- 1 Nov, 21:50120 linesclean
- 1 Nov, 21:40106 lines2 breaks
- 1 Nov, 21:30124 lines7 breaks
- 1 Nov, 21:20106 lines3 breaks
- 1 Nov, 21:10140 lines3 breaks
- 1 Nov, 21:00106 lines4 breaks
- 1 Nov, 20:50127 lines3 breaks
- 1 Nov, 20:40126 lines2 breaks
- 1 Nov, 20:30125 lines1 break
- 1 Nov, 20:20141 lines3 breaks
- 1 Nov, 20:10133 lines2 breaks
1 Nov, 21:30
Gross
€3,038.00
PSP fee
€47.27
Net to the bank
€2,990.73
Settlement journal
#331499
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19907-733f-7396-8167-02cd98559072 is already settled by stl_EUR_2989281 line 37
- duplicate linethe file lists it twicecapture:01a1990a-65ef-7f36-9114-dfdfbf854f29 is already settled by stl_EUR_2989281 line 78
- duplicate linethe file lists it twicecapture:01a1990c-64d7-789a-a2cd-8987a339609d is already settled by stl_EUR_2989281 line 103
- fee differencethe fee is not the contract feethe fee is 53, the contract says 50
- missing linein the books, not in the filerefund:01a19908-a3aa-72ac-8242-e9715562338a is in no file
- missing linein the books, not in the filecapture:01a1990b-9cfc-72d3-b161-fe989207d94c is in no file
- missing linein the books, not in the filecapture:01a1990d-28a6-739b-b89a-6dadaaf2dd6b is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 38 | capture | 01a19907-73e4-7363-8764-102a2bad36e7 | €9.00 | €0.19 | duplicate line |
| 79 | capture | 01a1990a-777d-785e-a8fb-83bcbe78dccf | €9.00 | €0.19 | duplicate line |
| 104 | capture | 01a1990c-650f-772e-90a5-2ea309b2bed1 | €9.00 | €0.19 | duplicate line |
| 120 | capture | 01a1990d-dc2b-79e4-862f-78875db65dd7 | €35.00 | €0.53 | fee difference |
| 1 | capture | 01a198fe-ee89-794b-a7f7-f6203b51f4bf | €9.00 | €0.19 | matched |
| 2 | capture | 01a19900-4bf9-7874-bd97-125d5a474cab | €24.00 | €0.37 | matched |
| 3 | capture | 01a19901-5cac-7e69-841a-5fbbc22fabed | €35.00 | €0.50 | matched |
| 4 | capture | 01a19904-f805-786a-9c75-943cba5895f3 | €49.00 | €0.67 | matched |
| 5 | capture | 01a19905-0df6-7677-aad5-2df5d748cdd8 | €24.00 | €0.37 | matched |
| 6 | capture | 01a19905-0e72-7707-8747-d8ffb50bdd0f | €49.00 | €0.67 | matched |
| 7 | capture | 01a19905-3c98-71d8-ac82-ce43445b541b | €49.00 | €0.67 | matched |
| 8 | capture | 01a19905-44c2-78a3-a17b-6423d1a92e81 | €15.00 | €0.26 | matched |
| 9 | capture | 01a19905-4c65-7d49-8335-bd11ef7d3e12 | €9.00 | €0.19 | matched |
| 10 | capture | 01a19905-7e0b-71c8-8221-11530046e006 | €9.00 | €0.19 | matched |
| 11 | capture | 01a19905-8b9b-7bb5-a598-4cda1543a64f | €24.00 | €0.37 | matched |
| 12 | capture | 01a19905-8f7c-7977-9623-5cf61ccbb718 | €35.00 | €0.50 | matched |
| 13 | capture | 01a19905-9962-76ef-91fa-836ebb38e27c | €49.00 | €0.67 | matched |
| 14 | capture | 01a19905-b1a4-7904-9a9a-8f40d56dd945 | €24.00 | €0.37 | matched |
| 15 | refund | 01a19905-b993-703d-b0a6-81f91b490ef3 | -€8.00 | €0.00 | matched |
| 16 | capture | 01a19905-d458-77fe-8048-92a045c5a679 | €35.00 | €0.50 | matched |
| 17 | refund | 01a19905-efa8-7ebf-89c2-da84a0064db4 | -€6.00 | €0.00 | matched |
| 18 | capture | 01a19905-f3b6-7dbe-b116-3f16ab4e8fb7 | €15.00 | €0.26 | matched |
| 19 | capture | 01a19905-ffba-77f2-9737-9cef839d3202 | €35.00 | €0.50 | matched |
| 20 | capture | 01a19906-1223-71bc-bfdf-257aefba7516 | €15.00 | €0.26 | matched |
| 21 | capture | 01a19906-2b8f-79fa-b8fe-65667639b95c | €49.00 | €0.67 | matched |
| 22 | capture | 01a19906-3a3f-7505-a16b-90bb69c95fc4 | €24.00 | €0.37 | matched |
| 23 | capture | 01a19906-53de-7064-9f43-ac224bac5a43 | €49.00 | €0.67 | matched |
| 24 | capture | 01a19906-5544-7864-b939-cfe36d72da49 | €35.00 | €0.50 | matched |
| 25 | capture | 01a19906-5568-759b-b3c9-42915c3f5f56 | €9.00 | €0.19 | matched |
| 26 | capture | 01a19906-6bbb-7648-882e-2bd2daa88543 | €9.00 | €0.19 | matched |
| 27 | capture | 01a19906-7c29-7e1d-a666-2b9ca816f877 | €24.00 | €0.37 | matched |
| 28 | capture | 01a19906-9eb9-7bb9-b935-8467bb5dce15 | €24.00 | €0.37 | matched |
| 29 | capture | 01a19906-b40b-7080-b787-a8d051e87ae4 | €24.00 | €0.37 | matched |
| 30 | refund | 01a19906-b7ae-73ad-9f88-81da46cdef4f | -€32.00 | €0.00 | matched |
| 31 | capture | 01a19906-d4e1-7e7d-b0cd-17973350df89 | €35.00 | €0.50 | matched |
| 32 | capture | 01a19906-f1ee-71cf-9dd8-52f17213969f | €49.00 | €0.67 | matched |
| 33 | capture | 01a19907-009a-7d95-946e-5f4d73d1e2ea | €9.00 | €0.19 | matched |
| 34 | capture | 01a19907-290c-7179-a318-874d00bc33ab | €49.00 | €0.67 | matched |
| 35 | capture | 01a19907-3e7a-705f-8dc5-5ead17451cc6 | €35.00 | €0.50 | matched |
| 36 | capture | 01a19907-6aeb-716d-800c-3eebf769c487 | €35.00 | €0.50 | matched |
| 37 | capture | 01a19907-73e4-7363-8764-102a2bad36e7 | €9.00 | €0.19 | matched |
| 39 | capture | 01a19907-933f-71de-9a46-f88291a6e2f5 | €49.00 | €0.67 | matched |
| 40 | capture | 01a19907-b92e-7abe-a816-f1e31a1ca78d | €9.00 | €0.19 | matched |
| 41 | capture | 01a19907-c61d-7c3d-a1b7-f5ecb0449d1d | €49.00 | €0.67 | matched |
| 42 | capture | 01a19907-d7bf-70ae-9d47-0259c50099a2 | €35.00 | €0.50 | matched |
| 43 | capture | 01a19908-18a8-73a8-b82f-a703b5a27619 | €49.00 | €0.67 | matched |
| 44 | capture | 01a19908-20b0-743c-99c8-7e149c2b9225 | €9.00 | €0.19 | matched |
| 45 | capture | 01a19908-3581-75d6-830a-1695b8a35421 | €24.00 | €0.37 | matched |
| 46 | capture | 01a19908-4e29-7e75-aec7-fb820ea79d66 | €9.00 | €0.19 | matched |
| 47 | capture | 01a19908-5fd9-7333-b5f5-b490f5b1a5ce | €9.00 | €0.19 | matched |
| 48 | capture | 01a19908-65d8-78fb-b343-79656fd736e2 | €35.00 | €0.50 | matched |
| 49 | capture | 01a19908-6970-7dfe-8c64-324df468bc9c | €49.00 | €0.67 | matched |
| 50 | capture | 01a19908-866e-705b-81de-61e3895c4ced | €15.00 | €0.26 | matched |
| 51 | capture | 01a19908-8de1-73da-a0ae-8da3aa6b7a0c | €15.00 | €0.26 | matched |
| 52 | capture | 01a19908-91ea-7b1f-a328-ed9448d1b555 | €35.00 | €0.50 | matched |
| 53 | capture | 01a19908-a355-7877-be75-3a628dbf01bf | €49.00 | €0.67 | matched |
| 54 | capture | 01a19908-cae2-7659-9208-d32743be80a0 | €24.00 | €0.37 | matched |
| 55 | capture | 01a19908-e01a-76e8-bf9e-d9b1868ef7b7 | €9.00 | €0.19 | matched |
| 56 | capture | 01a19909-1737-7716-850d-0382eedecbb9 | €15.00 | €0.26 | matched |
| 57 | capture | 01a19909-2cda-7f5f-b4a9-dca887f20804 | €24.00 | €0.37 | matched |
| 58 | capture | 01a19909-3408-7ca7-9301-583bbacd0ede | €35.00 | €0.50 | matched |
| 59 | capture | 01a19909-3686-704f-8381-86813c9bfa3a | €49.00 | €0.67 | matched |
| 60 | capture | 01a19909-5958-72ba-a52a-04db4f6fad45 | €49.00 | €0.67 | matched |
| 61 | capture | 01a19909-76a0-7c66-9ba7-e3c0bf87ba93 | €24.00 | €0.37 | matched |
| 62 | capture | 01a19909-739e-7627-97fb-b7d03ac79880 | €49.00 | €0.67 | matched |
| 63 | capture | 01a19909-920b-7a16-a138-855c31add9bb | €49.00 | €0.67 | matched |
| 64 | capture | 01a19909-923d-7ff7-825a-f033c93aa410 | €49.00 | €0.67 | matched |
| 65 | capture | 01a19909-a01e-752d-9fb4-f965f5786d91 | €24.00 | €0.37 | matched |
| 66 | capture | 01a19909-b458-75d8-bffc-e43ea41b45c1 | €24.00 | €0.37 | matched |
| 67 | capture | 01a19909-c6b0-792e-b4f6-a3a0b1ca51a7 | €15.00 | €0.26 | matched |
| 68 | capture | 01a19909-e7ad-7a5a-a31b-2efac1305c79 | €15.00 | €0.26 | matched |
| 69 | refund | 01a19909-e7dd-7f7c-95f9-1e85627871ff | -€21.00 | €0.00 | matched |
| 70 | capture | 01a19909-f573-7d8a-b370-1a9f6a4fa19a | €9.00 | €0.19 | matched |
| 71 | capture | 01a1990a-006a-7cf8-aa02-450205e003ed | €9.00 | €0.19 | matched |
| 72 | capture | 01a1990a-1a08-7f7b-9135-010de52b2ad0 | €49.00 | €0.67 | matched |
| 73 | capture | 01a1990a-2033-73c7-8839-1aa1e1e92ef3 | €15.00 | €0.26 | matched |
| 74 | capture | 01a1990a-418b-7ab6-a375-ac980243d61c | €15.00 | €0.26 | matched |
| 75 | capture | 01a1990a-510a-7481-9027-60ed0343f77a | €15.00 | €0.26 | matched |
| 76 | capture | 01a1990a-6b8c-7ca5-954a-da5e0ef2cf88 | €49.00 | €0.67 | matched |
| 77 | capture | 01a1990a-71f2-76b2-90c8-5e67884ce319 | €24.00 | €0.37 | matched |
| 78 | capture | 01a1990a-777d-785e-a8fb-83bcbe78dccf | €9.00 | €0.19 | matched |
| 80 | capture | 01a1990a-7c2d-7567-b939-9d9893a160b6 | €9.00 | €0.19 | matched |
| 81 | capture | 01a1990a-8fbc-7d7c-b309-e027bb6913ad | €49.00 | €0.67 | matched |
| 82 | capture | 01a1990a-9a97-7347-8443-39664260b392 | €24.00 | €0.37 | matched |
| 83 | capture | 01a1990a-a48c-77ea-84e8-d30de0d6ced0 | €35.00 | €0.50 | matched |
| 84 | capture | 01a1990a-b33d-7fd7-8cbc-15ececec8fec | €35.00 | €0.50 | matched |
| 85 | refund | 01a1990a-e1ea-75b3-83eb-ce09de6cb435 | -€7.00 | €0.00 | matched |
| 86 | capture | 01a1990a-f137-7255-8841-6d83d39a1959 | €15.00 | €0.26 | matched |
| 87 | capture | 01a1990b-01dd-7679-a626-49aba932f96e | €15.00 | €0.26 | matched |
| 88 | capture | 01a1990b-13b8-729e-937a-bac02de33878 | €15.00 | €0.26 | matched |
| 89 | capture | 01a1990b-1944-7985-af6f-0751b3a5f92b | €9.00 | €0.19 | matched |
| 90 | capture | 01a1990b-19ac-79a2-a924-0d16a057edcb | €9.00 | €0.19 | matched |
| 91 | capture | 01a1990b-1f9e-731e-a2cb-d6fd326b7ec5 | €24.00 | €0.37 | matched |
| 92 | capture | 01a1990b-342b-79e3-97cb-a1a89ab07b96 | €49.00 | €0.67 | matched |
| 93 | capture | 01a1990b-5580-710d-90f3-7da9dc87bd89 | €24.00 | €0.37 | matched |
| 94 | capture | 01a1990b-75f9-7088-b97d-ff81dbe59a00 | €24.00 | €0.37 | matched |
| 95 | capture | 01a1990b-76a4-75eb-8672-943003284640 | €35.00 | €0.50 | matched |
| 96 | capture | 01a1990b-a29a-745a-8b90-97df51471adb | €15.00 | €0.26 | matched |
| 97 | capture | 01a1990b-bf2f-7d10-9597-9de8fea144f3 | €9.00 | €0.19 | matched |
| 98 | capture | 01a1990b-c5d9-7f76-a64a-4ec3eedd89d7 | €9.00 | €0.19 | matched |
| 99 | capture | 01a1990b-d8b9-7f7d-a7f9-b7ab86ffb724 | €24.00 | €0.37 | matched |
| 100 | capture | 01a1990c-2270-74ef-9e13-8bdfe0af38f8 | €49.00 | €0.67 | matched |
| 101 | capture | 01a1990c-31b1-787a-9a62-f9be1aa7b450 | €49.00 | €0.67 | matched |
| 102 | capture | 01a1990c-5cf2-7427-8da0-35090a7e29f6 | €35.00 | €0.50 | matched |
| 103 | capture | 01a1990c-650f-772e-90a5-2ea309b2bed1 | €9.00 | €0.19 | matched |
| 105 | capture | 01a1990c-662c-7374-bb3e-439aa0ec323c | €15.00 | €0.26 | matched |
| 106 | capture | 01a1990c-663c-7f88-8363-b772929e71bb | €24.00 | €0.37 | matched |
| 107 | capture | 01a1990c-8586-7fdc-a2d6-b4bfae30d941 | €15.00 | €0.26 | matched |
| 108 | capture | 01a1990c-90e9-7975-a850-01a244edd211 | €24.00 | €0.37 | matched |
| 109 | capture | 01a1990c-9309-768a-ad8e-5bcd05b8448c | €15.00 | €0.26 | matched |
| 110 | capture | 01a1990c-afa0-7593-adb3-6f3489ec2522 | €24.00 | €0.37 | matched |
| 111 | capture | 01a1990c-b730-72ba-8133-8084e1ce9fbd | €9.00 | €0.19 | matched |
| 112 | capture | 01a1990c-bd48-7fe9-8c2f-5e03cafd5eaf | €24.00 | €0.37 | matched |
| 113 | capture | 01a1990c-f2ac-71b6-bfe0-9d0318093700 | €49.00 | €0.67 | matched |
| 114 | capture | 01a1990d-2e09-7868-953c-505864da5a07 | €9.00 | €0.19 | matched |
| 115 | capture | 01a1990d-56f0-7f94-a2cf-7a4619a2bdd1 | €24.00 | €0.37 | matched |
| 116 | capture | 01a1990d-6480-7520-bdf7-4567a23d25e5 | €35.00 | €0.50 | matched |
| 117 | capture | 01a1990d-7da0-7a11-9aa8-1a9828b2fa5a | €15.00 | €0.26 | matched |
| 118 | capture | 01a1990d-94b5-7d41-a328-ad9fcb1e15f9 | €35.00 | €0.50 | matched |
| 119 | capture | 01a1990d-a147-7b38-a011-b513bd85be29 | €15.00 | €0.26 | matched |
| 121 | capture | 01a1990d-dfed-78dc-8c58-b481526fdcd0 | €49.00 | €0.67 | matched |
| 122 | capture | 01a1990d-dfec-71c3-a95b-687fd3db5a47 | €15.00 | €0.26 | matched |
| 123 | refund | 01a1990d-ea5b-7222-ac25-580fb3aed9e1 | -€25.00 | €0.00 | matched |
| 124 | capture | 01a1990e-0512-7b58-a173-3bf75c7b2697 | €49.00 | €0.67 | matched |