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, 16:40123 lines4 breaks
- 1 Nov, 16:3091 lines1 break
- 1 Nov, 16:20116 lines3 breaks
- 1 Nov, 16:10118 linesclean
- 1 Nov, 16:00128 lines1 break
- 1 Nov, 15:50158 lines3 breaks
- 1 Nov, 15:40128 lines3 breaks
- 1 Nov, 15:30140 lines5 breaks
- 1 Nov, 15:20135 lines2 breaks
- 1 Nov, 15:10128 lines4 breaks
- 1 Nov, 15:00102 lines1 break
- 1 Nov, 14:50118 lines2 breaks
- 1 Nov, 14:40116 lines2 breaks
- 1 Nov, 14:30145 lines4 breaks
1 Nov, 15:40
Gross
€2,857.00
PSP fee
€45.86
Net to the bank
€2,811.14
Settlement journal
#327068
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a197c8-124d-748b-807d-11637d08959c is already settled by stl_EUR_2989246 line 49
- fee differencethe fee is not the contract feethe fee is 55, the contract says 50
- missing linein the books, not in the filecapture:01a197cc-659a-7574-bde2-099931358e35 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 50 | capture | 01a197c8-2cfc-7e5d-9b86-63c5d278eb0c | €9.00 | €0.19 | duplicate line |
| 107 | capture | 01a197cc-1689-7702-be32-e8363f071575 | €35.00 | €0.55 | fee difference |
| 1 | capture | 01a197bb-7b21-7ce1-b8ab-051b67e55a15 | €15.00 | €0.26 | matched |
| 2 | capture | 01a197bd-62b1-76a0-94c6-b3f6ce1ad300 | €9.00 | €0.19 | matched |
| 3 | capture | 01a197bd-73ee-7c5b-a5e9-70ccad5ad449 | €49.00 | €0.67 | matched |
| 4 | capture | 01a197be-4963-7abd-a795-23304b8c0b41 | €49.00 | €0.67 | matched |
| 5 | capture | 01a197be-534c-7869-92f5-a125115c6396 | €9.00 | €0.19 | matched |
| 6 | capture | 01a197c0-70df-7738-a2c8-d6662131817e | €35.00 | €0.50 | matched |
| 7 | capture | 01a197c1-0313-7be8-8807-24dfeefc285b | €35.00 | €0.50 | matched |
| 8 | capture | 01a197c2-ca39-7ed7-bdfb-0998ae3cb335 | €49.00 | €0.67 | matched |
| 9 | capture | 01a197c4-92f6-76fd-9471-996d1205e4bc | €9.00 | €0.19 | matched |
| 10 | capture | 01a197c4-a4d5-778a-b58c-65f77983a96d | €24.00 | €0.37 | matched |
| 11 | capture | 01a197c4-b0e9-7752-9516-eb36d058e35b | €35.00 | €0.50 | matched |
| 12 | refund | 01a197c4-d21c-77b9-a093-558e02549958 | -€11.00 | €0.00 | matched |
| 13 | capture | 01a197c4-f429-76d5-a08a-21307e279dd4 | €49.00 | €0.67 | matched |
| 14 | capture | 01a197c4-fbfe-79c3-b044-38381b7997cd | €9.00 | €0.19 | matched |
| 15 | capture | 01a197c5-0d2b-75c3-b8f3-2baa02ebe050 | €9.00 | €0.19 | matched |
| 16 | capture | 01a197c5-3471-7fa3-929c-1c40b8346dde | €24.00 | €0.37 | matched |
| 17 | capture | 01a197c5-3a2d-79fe-96ce-2405c66f915c | €24.00 | €0.37 | matched |
| 18 | capture | 01a197c5-47e6-76d9-ab84-3d826f83403f | €9.00 | €0.19 | matched |
| 19 | capture | 01a197c5-4a26-705a-a1c3-e832daaeb698 | €9.00 | €0.19 | matched |
| 20 | capture | 01a197c5-4a82-74ab-b7af-10e7f06cae45 | €49.00 | €0.67 | matched |
| 21 | capture | 01a197c5-65fe-7a3d-9a10-184d056dc732 | €24.00 | €0.37 | matched |
| 22 | capture | 01a197c5-75d4-75b3-8a1f-edded4476102 | €9.00 | €0.19 | matched |
| 23 | refund | 01a197c5-a2f5-75f4-9dcf-1e9008d6f36f | -€5.00 | €0.00 | matched |
| 24 | capture | 01a197c5-eb07-74ae-8f99-971454e5b2bc | €49.00 | €0.67 | matched |
| 25 | capture | 01a197c5-f5cf-7a09-b3fe-1501b175a73b | €24.00 | €0.37 | matched |
| 26 | capture | 01a197c5-fcf0-7be3-8fb4-6b3dbf5c99a9 | €15.00 | €0.26 | matched |
| 27 | capture | 01a197c6-0808-7890-ab8e-f224e8402173 | €35.00 | €0.50 | matched |
| 28 | capture | 01a197c6-2d9c-779f-b06f-4d912f3af4d0 | €9.00 | €0.19 | matched |
| 29 | capture | 01a197c6-587b-720d-9b29-d1da0b466704 | €24.00 | €0.37 | matched |
| 30 | refund | 01a197c6-7ccd-7d66-95a6-2cf95a6c371d | -€20.00 | €0.00 | matched |
| 31 | capture | 01a197c6-816d-7e75-b9ca-0a44b4392c1f | €15.00 | €0.26 | matched |
| 32 | capture | 01a197c6-8ee1-7b75-8fec-3579924582fc | €24.00 | €0.37 | matched |
| 33 | capture | 01a197c6-9728-77cd-a99d-a98c631d38a5 | €24.00 | €0.37 | matched |
| 34 | capture | 01a197c6-9c7d-7d8b-b55f-abba27c8a34d | €35.00 | €0.50 | matched |
| 35 | capture | 01a197c6-b69e-71f6-95b6-c29194f75551 | €35.00 | €0.50 | matched |
| 36 | capture | 01a197c6-db27-7584-8210-a3fa82d53510 | €9.00 | €0.19 | matched |
| 37 | capture | 01a197c6-e5f5-7290-a22b-7c006e3accaa | €9.00 | €0.19 | matched |
| 38 | capture | 01a197c7-41c5-737d-adb3-944185e974be | €15.00 | €0.26 | matched |
| 39 | capture | 01a197c7-49fd-7a89-bd40-ffe8689a6a80 | €9.00 | €0.19 | matched |
| 40 | capture | 01a197c7-4dcd-7a49-8bfa-853b99a3caa4 | €35.00 | €0.50 | matched |
| 41 | capture | 01a197c7-7615-706d-a4aa-beac6ae385a7 | €24.00 | €0.37 | matched |
| 42 | capture | 01a197c7-b46a-77a6-8ca4-10d3ae4d6a08 | €15.00 | €0.26 | matched |
| 43 | capture | 01a197c7-ab0a-7dfa-a0f0-4bb8d75b7ba1 | €9.00 | €0.19 | matched |
| 44 | capture | 01a197c7-ce49-7bc8-93ee-329a507f4ee4 | €24.00 | €0.37 | matched |
| 45 | capture | 01a197c7-fd5f-7a13-9c05-09d15f5a0bd0 | €9.00 | €0.19 | matched |
| 46 | capture | 01a197c8-06af-7fa9-9c77-cadc7762a769 | €49.00 | €0.67 | matched |
| 47 | capture | 01a197c8-06dc-7980-82d9-e2fe26c54ef7 | €35.00 | €0.50 | matched |
| 48 | capture | 01a197c8-2752-77a0-8f00-76caecd4a880 | €24.00 | €0.37 | matched |
| 49 | capture | 01a197c8-2cfc-7e5d-9b86-63c5d278eb0c | €9.00 | €0.19 | matched |
| 51 | capture | 01a197c8-2ecd-792b-8673-2dead4dde4c1 | €49.00 | €0.67 | matched |
| 52 | capture | 01a197c8-6714-7f32-953f-920da5373443 | €15.00 | €0.26 | matched |
| 53 | capture | 01a197c8-79d3-71b1-9be3-80cb1a221dd8 | €15.00 | €0.26 | matched |
| 54 | capture | 01a197c8-81d6-7ba6-8f07-58a9d6e03f0f | €15.00 | €0.26 | matched |
| 55 | capture | 01a197c8-90e7-7fe1-9e85-539b50b0abbc | €49.00 | €0.67 | matched |
| 56 | capture | 01a197c8-946d-70c7-8f8c-cd83b537db5d | €24.00 | €0.37 | matched |
| 57 | capture | 01a197c8-9844-72e9-807a-58bc15ee71aa | €9.00 | €0.19 | matched |
| 58 | capture | 01a197c8-ace1-7e2d-82fd-321d13ee1abe | €35.00 | €0.50 | matched |
| 59 | capture | 01a197c8-aeb3-73b9-b985-cf13a8332b51 | €9.00 | €0.19 | matched |
| 60 | capture | 01a197c8-b04c-790c-956e-ca466ec3963f | €35.00 | €0.50 | matched |
| 61 | capture | 01a197c8-b1ec-7436-8f08-c5aa1aa0bd6b | €49.00 | €0.67 | matched |
| 62 | capture | 01a197c8-b327-78c9-898d-a0dcc4f16577 | €9.00 | €0.19 | matched |
| 63 | refund | 01a197c9-043e-70c4-ac91-c9c81408e8ac | -€8.00 | €0.00 | matched |
| 64 | capture | 01a197c9-1006-779c-a0a2-e404285cab92 | €49.00 | €0.67 | matched |
| 65 | capture | 01a197c9-2ab6-70d1-9196-2abfcfe05e6e | €35.00 | €0.50 | matched |
| 66 | capture | 01a197c9-2c00-7004-afae-6571e6db89c6 | €24.00 | €0.37 | matched |
| 67 | capture | 01a197c9-30e1-70fb-bbc5-97fb2ebde038 | €24.00 | €0.37 | matched |
| 68 | capture | 01a197c9-467c-7e82-90e2-0c4bd1b3b206 | €49.00 | €0.67 | matched |
| 69 | capture | 01a197c9-6ab8-7987-9695-eba0513df596 | €35.00 | €0.50 | matched |
| 70 | capture | 01a197c9-6dea-746c-8bf2-3eff9d502487 | €9.00 | €0.19 | matched |
| 71 | capture | 01a197c9-96c6-7654-80c6-f819c6bde06c | €15.00 | €0.26 | matched |
| 72 | capture | 01a197c9-9bf5-7e2f-989c-35da799af4ad | €35.00 | €0.50 | matched |
| 73 | refund | 01a197c9-d19f-7987-b52c-d8ea4ca91e04 | -€7.00 | €0.00 | matched |
| 74 | capture | 01a197c9-d7db-7db8-baf9-9ff671e11bbf | €24.00 | €0.37 | matched |
| 75 | refund | 01a197c9-da06-7e04-a32f-258412c472c6 | -€4.00 | €0.00 | matched |
| 76 | capture | 01a197ca-0a4a-70a3-ba03-ad7d02ffecc7 | €49.00 | €0.67 | matched |
| 77 | capture | 01a197ca-1b4b-7106-907c-2a91f611c7d3 | €35.00 | €0.50 | matched |
| 78 | capture | 01a197ca-1c13-76bf-8f7d-ef9e62017cd0 | €49.00 | €0.67 | matched |
| 79 | capture | 01a197ca-2984-71f6-b689-7ec6af37f616 | €9.00 | €0.19 | matched |
| 80 | capture | 01a197ca-257a-7bfe-834c-7e50f93eccde | €35.00 | €0.50 | matched |
| 81 | capture | 01a197ca-43a2-71f7-8a4f-157bf24a5063 | €15.00 | €0.26 | matched |
| 82 | capture | 01a197ca-46f0-79b5-932e-7a675068a88f | €9.00 | €0.19 | matched |
| 83 | refund | 01a197ca-8c37-7757-8908-f982d264e2b5 | -€14.00 | €0.00 | matched |
| 84 | refund | 01a197ca-8e40-76fd-8da1-a9c4bca70543 | -€27.00 | €0.00 | matched |
| 85 | capture | 01a197ca-76d3-7d9c-9aa6-1abeee3eeaf2 | €35.00 | €0.50 | matched |
| 86 | capture | 01a197ca-a0d9-76d1-a30c-7a063ae68f23 | €24.00 | €0.37 | matched |
| 87 | capture | 01a197ca-a35f-7e36-be53-468cf6c95255 | €9.00 | €0.19 | matched |
| 88 | capture | 01a197ca-ae46-7a14-b2c4-687a838280ac | €15.00 | €0.26 | matched |
| 89 | capture | 01a197ca-b2e5-7322-b43d-084f8e46e886 | €24.00 | €0.37 | matched |
| 90 | capture | 01a197ca-c5b8-7657-9f1a-2f3a039b72b8 | €35.00 | €0.50 | matched |
| 91 | capture | 01a197ca-d5db-70ad-80d2-b362bba32a70 | €49.00 | €0.67 | matched |
| 92 | capture | 01a197ca-d6fe-700a-9368-4b62e750ff97 | €24.00 | €0.37 | matched |
| 93 | capture | 01a197cb-2e37-79de-9552-3bd6c5f81601 | €9.00 | €0.19 | matched |
| 94 | capture | 01a197cb-49f3-7d6d-b520-42380a81a236 | €15.00 | €0.26 | matched |
| 95 | capture | 01a197cb-95d4-71dd-ad39-e361626b3223 | €15.00 | €0.26 | matched |
| 96 | capture | 01a197cb-9a1a-7d4e-bf71-00f066d8880c | €49.00 | €0.67 | matched |
| 97 | capture | 01a197cb-c2cf-778c-91d2-8e8a838b6fab | €35.00 | €0.50 | matched |
| 98 | capture | 01a197cb-c5c0-710c-8836-f39ec33de93e | €24.00 | €0.37 | matched |
| 99 | capture | 01a197cb-c6a2-7fdd-912f-9831d14211dc | €49.00 | €0.67 | matched |
| 100 | capture | 01a197cb-d38a-7ff2-a680-c1fc9f63de10 | €15.00 | €0.26 | matched |
| 101 | capture | 01a197cb-d754-7b47-8584-4078946b60ae | €9.00 | €0.19 | matched |
| 102 | capture | 01a197cb-d8b5-713d-b64c-54af4cf4efcb | €24.00 | €0.37 | matched |
| 103 | capture | 01a197cb-db8d-7630-b05e-de06d1e8f1f9 | €9.00 | €0.19 | matched |
| 104 | capture | 01a197cb-e77d-7d7e-ae75-416fea8335da | €49.00 | €0.67 | matched |
| 105 | capture | 01a197cb-f0e3-72cb-b1eb-11eafdba8934 | €24.00 | €0.37 | matched |
| 106 | capture | 01a197cb-f77f-777d-b18a-208ee1f256e5 | €49.00 | €0.67 | matched |
| 108 | capture | 01a197cc-3468-7930-9b57-83dfc7ca3a93 | €49.00 | €0.67 | matched |
| 109 | capture | 01a197cc-35da-75a6-8925-0d6999ce5861 | €49.00 | €0.67 | matched |
| 110 | capture | 01a197cc-4059-7f4e-81eb-116f477392f2 | €15.00 | €0.26 | matched |
| 111 | capture | 01a197cc-5e6c-73b5-b301-27652b7ac0f7 | €15.00 | €0.26 | matched |
| 112 | refund | 01a197cc-62a7-7cf0-8b7f-67d549b9e250 | -€27.00 | €0.00 | matched |
| 113 | capture | 01a197cc-6e8d-7c10-bb0c-e60758a3ef1c | €9.00 | €0.19 | matched |
| 114 | capture | 01a197cc-88a1-7eb9-875b-b1b530d6df19 | €15.00 | €0.26 | matched |
| 115 | capture | 01a197cc-8c46-7575-b963-16a0da6f031e | €24.00 | €0.37 | matched |
| 116 | capture | 01a197cc-8d70-7261-a1bb-02251dc85f27 | €49.00 | €0.67 | matched |
| 117 | capture | 01a197cc-8f50-7c09-b00a-9b30d541ab53 | €35.00 | €0.50 | matched |
| 118 | capture | 01a197cc-a2c3-7abb-8179-b6232338a507 | €49.00 | €0.67 | matched |
| 119 | capture | 01a197cc-adf5-737a-84fd-20f982d1530b | €35.00 | €0.50 | matched |
| 120 | capture | 01a197cc-d3e4-7c88-80d0-fe9464bf72d0 | €24.00 | €0.37 | matched |
| 121 | capture | 01a197cc-dc06-702c-a054-0f0b9bd27056 | €24.00 | €0.37 | matched |
| 122 | refund | 01a197cd-0717-7203-8ae9-395bdd2b79ce | -€19.00 | €0.00 | matched |
| 123 | capture | 01a197cd-16e5-7956-b82e-d85cbd7985b8 | €15.00 | €0.26 | matched |
| 124 | refund | 01a197cd-180f-74a3-b165-754760c9b329 | -€26.00 | €0.00 | matched |
| 125 | capture | 01a197cd-2877-74df-8206-b4d36c448699 | €15.00 | €0.26 | matched |
| 126 | capture | 01a197cd-6a4d-7015-9333-055bd88c02b9 | €15.00 | €0.26 | matched |
| 127 | capture | 01a197cd-95d4-7456-bed7-3523eb83ee18 | €9.00 | €0.19 | matched |
| 128 | capture | 01a197cd-9c4d-7464-ad19-baa81f5137ef | €35.00 | €0.50 | matched |