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
- 5 Nov, 16:40124 lines2 breaks
- 5 Nov, 16:30144 lines2 breaks
- 5 Nov, 16:20114 lines2 breaks
- 5 Nov, 16:10137 lines4 breaks
- 5 Nov, 16:00111 linesclean
- 5 Nov, 15:50120 lines2 breaks
- 5 Nov, 15:40138 lines4 breaks
- 5 Nov, 15:30128 lines1 break
- 5 Nov, 15:20119 lines3 breaks
- 5 Nov, 15:10115 lines2 breaks
- 5 Nov, 15:00122 lines1 break
- 5 Nov, 14:50134 lines7 breaks
- 5 Nov, 14:40125 lines2 breaks
- 5 Nov, 14:30121 lines3 breaks
5 Nov, 15:40
Gross
€3,617.00
PSP fee
€56.05
Net to the bank
€3,560.95
Settlement journal
#400070
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1ac63-db62-7527-be9a-435463146330 is already settled by stl_EUR_2989822 line 90
- fee differencethe fee is not the contract feethe fee is 28, the contract says 26
- missing linein the books, not in the filecapture:01a1ac64-defb-7f2c-b12e-3c62794159d8 is in no file
- missing linein the books, not in the filecapture:01a1ac5e-a8c2-75b1-afd3-59632070be21 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 91 | capture | 01a1ac63-db93-7a78-992c-073a81d6f886 | €9.00 | €0.19 | duplicate line |
| 98 | capture | 01a1ac64-4f4c-70df-9288-2c7df5c6d5e1 | €15.00 | €0.28 | fee difference |
| 1 | capture | 01a1ac56-2a16-74e5-82e3-d0aa1b621f16 | €35.00 | €0.50 | matched |
| 2 | capture | 01a1ac59-cd79-7b78-9dec-6c59e28953a7 | €35.00 | €0.50 | matched |
| 3 | capture | 01a1ac5b-f9cc-767e-b1bc-f28df0e21634 | €24.00 | €0.37 | matched |
| 4 | capture | 01a1ac5d-f2aa-793f-9df8-31a333c6ae6a | €24.00 | €0.37 | matched |
| 5 | refund | 01a1ac5d-fabf-794b-9ea9-398b0f24e3d0 | -€18.00 | €0.00 | matched |
| 6 | capture | 01a1ac5e-0764-7ab1-ab21-45ca90c1fd80 | €24.00 | €0.37 | matched |
| 7 | refund | 01a1ac5e-0d5d-790a-98ac-46f6f5686a1a | -€7.00 | €0.00 | matched |
| 8 | capture | 01a1ac5e-135d-79da-8eb7-a121bbd52b8f | €24.00 | €0.37 | matched |
| 9 | capture | 01a1ac5e-1a53-7d56-a6ae-520488f64f2e | €49.00 | €0.67 | matched |
| 10 | capture | 01a1ac5e-1c03-7661-8890-63646533bc73 | €35.00 | €0.50 | matched |
| 11 | capture | 01a1ac5e-2043-705b-a3a0-242d490f7afe | €24.00 | €0.37 | matched |
| 12 | capture | 01a1ac5e-2568-7b0d-a811-78e903c7ff45 | €49.00 | €0.67 | matched |
| 13 | capture | 01a1ac5e-36fa-7ed4-8315-3fe03c8caf83 | €49.00 | €0.67 | matched |
| 14 | capture | 01a1ac5e-4169-7741-855c-98325cfa0f89 | €49.00 | €0.67 | matched |
| 15 | capture | 01a1ac5e-4c48-709f-8090-707ae309eb0b | €15.00 | €0.26 | matched |
| 16 | capture | 01a1ac5e-59b2-78b4-82f4-11ccfc44d042 | €15.00 | €0.26 | matched |
| 17 | capture | 01a1ac5e-64a5-7bc7-87c7-2887a342da75 | €49.00 | €0.67 | matched |
| 18 | capture | 01a1ac5e-7016-7ce1-ad70-86e38404cef6 | €9.00 | €0.19 | matched |
| 19 | refund | 01a1ac5e-7632-7293-bead-8eb120f65a57 | -€35.00 | €0.00 | matched |
| 20 | capture | 01a1ac5e-9803-713a-b276-335a7240ee75 | €35.00 | €0.50 | matched |
| 21 | capture | 01a1ac5e-b22d-7c62-a6b4-2b9ca5117887 | €35.00 | €0.50 | matched |
| 22 | capture | 01a1ac5e-ca88-7f12-85b4-349184a0b4d8 | €24.00 | €0.37 | matched |
| 23 | capture | 01a1ac5e-dcea-7756-9338-18a043f4ba99 | €24.00 | €0.37 | matched |
| 24 | capture | 01a1ac5e-e362-76ba-a88e-ad1aa7696487 | €15.00 | €0.26 | matched |
| 25 | capture | 01a1ac5e-e415-7d6a-a0e2-ad4947541f92 | €9.00 | €0.19 | matched |
| 26 | capture | 01a1ac5e-eacd-71e0-9798-0b48aabe0864 | €9.00 | €0.19 | matched |
| 27 | capture | 01a1ac5e-f212-7083-9350-229ed83fd606 | €9.00 | €0.19 | matched |
| 28 | capture | 01a1ac5f-06da-7d10-933c-e484937b0e3e | €49.00 | €0.67 | matched |
| 29 | refund | 01a1ac5f-10d9-74bc-ac31-8e8b99b2fff2 | -€26.00 | €0.00 | matched |
| 30 | capture | 01a1ac5f-1cf8-7491-9ff5-dcb49c0b4d82 | €24.00 | €0.37 | matched |
| 31 | capture | 01a1ac5f-3163-7511-a860-57913f74e24e | €49.00 | €0.67 | matched |
| 32 | capture | 01a1ac5f-32cc-73a3-be25-7ec0e7cc028c | €49.00 | €0.67 | matched |
| 33 | capture | 01a1ac5f-57c9-7d19-aeb7-8e5668a2ceee | €35.00 | €0.50 | matched |
| 34 | capture | 01a1ac5f-7053-7ede-ad2d-01dfe913272b | €49.00 | €0.67 | matched |
| 35 | capture | 01a1ac5f-77c2-7779-ac3e-63a5aeff97e7 | €49.00 | €0.67 | matched |
| 36 | capture | 01a1ac5f-9f0b-7dab-a449-9c3256d9fad1 | €49.00 | €0.67 | matched |
| 37 | capture | 01a1ac5f-ea45-7e4c-92df-4348bc4df2bf | €24.00 | €0.37 | matched |
| 38 | capture | 01a1ac5f-f228-78a8-b117-cb49d825cca5 | €24.00 | €0.37 | matched |
| 39 | capture | 01a1ac60-0a53-7a52-afd9-2a92ccf254a0 | €35.00 | €0.50 | matched |
| 40 | capture | 01a1ac60-0cc9-7d51-a2bd-d75a2332c093 | €9.00 | €0.19 | matched |
| 41 | capture | 01a1ac60-1066-71bf-8b17-379f411b848c | €24.00 | €0.37 | matched |
| 42 | capture | 01a1ac60-24a8-7650-886d-ca04e3a5a72d | €24.00 | €0.37 | matched |
| 43 | capture | 01a1ac60-2a07-71c4-b491-005c165b7481 | €24.00 | €0.37 | matched |
| 44 | capture | 01a1ac60-3029-756b-b5cc-300061895bef | €9.00 | €0.19 | matched |
| 45 | refund | 01a1ac60-34f6-7ef5-b173-157d461da3c9 | -€17.00 | €0.00 | matched |
| 46 | capture | 01a1ac60-4572-7007-b75a-d5e4bb576db8 | €35.00 | €0.50 | matched |
| 47 | capture | 01a1ac60-6cfa-759b-8eed-ca428fe809ff | €24.00 | €0.37 | matched |
| 48 | capture | 01a1ac60-7c94-772e-988e-0e1eddca6963 | €9.00 | €0.19 | matched |
| 49 | capture | 01a1ac60-7f51-71b8-8af9-64acff26bf78 | €15.00 | €0.26 | matched |
| 50 | capture | 01a1ac60-9eeb-7496-81a2-450b1da32cb5 | €24.00 | €0.37 | matched |
| 51 | capture | 01a1ac60-cb11-72da-a572-f6b0e743d934 | €49.00 | €0.67 | matched |
| 52 | capture | 01a1ac60-e534-7d3b-8bbb-fc04856afe52 | €49.00 | €0.67 | matched |
| 53 | capture | 01a1ac61-15c5-76be-9e70-31cbc637b9bb | €35.00 | €0.50 | matched |
| 54 | capture | 01a1ac61-2f29-721c-803e-5c276a671c68 | €35.00 | €0.50 | matched |
| 55 | capture | 01a1ac61-5d39-7019-b917-0d06aaf23372 | €35.00 | €0.50 | matched |
| 56 | capture | 01a1ac61-5e6d-7945-b6f4-691ebe4a2726 | €24.00 | €0.37 | matched |
| 57 | capture | 01a1ac61-7171-7f75-a84e-9eab6a1c7b89 | €15.00 | €0.26 | matched |
| 58 | capture | 01a1ac61-768d-788b-9383-0dfe80ab2585 | €35.00 | €0.50 | matched |
| 59 | capture | 01a1ac61-87d2-7985-95f1-4c92993b281d | €24.00 | €0.37 | matched |
| 60 | capture | 01a1ac61-8a8a-74ef-824b-0ceaff5f377e | €35.00 | €0.50 | matched |
| 61 | capture | 01a1ac61-8d0b-7aa8-99a4-3590756c63d0 | €15.00 | €0.26 | matched |
| 62 | capture | 01a1ac61-9269-7f44-b5db-91d77da443f8 | €24.00 | €0.37 | matched |
| 63 | capture | 01a1ac61-a669-7689-ab6b-b5ccf68a74f7 | €49.00 | €0.67 | matched |
| 64 | capture | 01a1ac61-b3c6-703e-bf4b-bb77c389187c | €35.00 | €0.50 | matched |
| 65 | capture | 01a1ac62-0142-7e7b-bacc-b148b3a6c3f4 | €15.00 | €0.26 | matched |
| 66 | capture | 01a1ac62-0af3-7705-8f4e-92419d239434 | €49.00 | €0.67 | matched |
| 67 | capture | 01a1ac62-0c57-79fc-850f-8611ea492f5e | €49.00 | €0.67 | matched |
| 68 | capture | 01a1ac62-2243-783d-a860-5cadf92dd3eb | €24.00 | €0.37 | matched |
| 69 | capture | 01a1ac62-3d74-7920-ad73-ba6971667f76 | €49.00 | €0.67 | matched |
| 70 | refund | 01a1ac62-6536-7345-9705-f5404a4b4f18 | -€12.00 | €0.00 | matched |
| 71 | capture | 01a1ac62-7955-76a8-944d-2c75ab831cdf | €35.00 | €0.50 | matched |
| 72 | capture | 01a1ac62-7ce1-7882-9d50-4677cc4e4e80 | €35.00 | €0.50 | matched |
| 73 | capture | 01a1ac62-7f2f-7718-8450-f2a706182b92 | €49.00 | €0.67 | matched |
| 74 | capture | 01a1ac62-8d95-725d-be7e-07d1dd4f11af | €49.00 | €0.67 | matched |
| 75 | capture | 01a1ac62-99e7-76a3-8501-a5428fc28f5b | €9.00 | €0.19 | matched |
| 76 | capture | 01a1ac62-9db9-7270-a6e9-bf5f4aeb1c78 | €35.00 | €0.50 | matched |
| 77 | capture | 01a1ac62-a809-7bf4-8a6e-763efb69ec15 | €35.00 | €0.50 | matched |
| 78 | capture | 01a1ac62-c843-7548-9aa7-4019f7cdffdf | €24.00 | €0.37 | matched |
| 79 | capture | 01a1ac62-de90-7eab-8232-3698a6a91907 | €9.00 | €0.19 | matched |
| 80 | capture | 01a1ac62-e75d-7fd4-a68e-9e17e387e9df | €15.00 | €0.26 | matched |
| 81 | capture | 01a1ac63-0f36-73d7-bf21-1430822b20c2 | €35.00 | €0.50 | matched |
| 82 | capture | 01a1ac63-2468-72c2-b60c-ec76683bc9df | €24.00 | €0.37 | matched |
| 83 | refund | 01a1ac63-4e40-71a2-963a-124de912e04b | -€22.00 | €0.00 | matched |
| 84 | capture | 01a1ac63-5058-7914-933f-b0d80d0b108c | €24.00 | €0.37 | matched |
| 85 | capture | 01a1ac63-6c0e-72e3-984c-c4e003b53db9 | €24.00 | €0.37 | matched |
| 86 | capture | 01a1ac63-6e17-7757-afce-7f3cc062ef77 | €15.00 | €0.26 | matched |
| 87 | capture | 01a1ac63-7255-7578-9632-098d495489bf | €24.00 | €0.37 | matched |
| 88 | capture | 01a1ac63-c023-7855-bfb7-11570133dd3e | €24.00 | €0.37 | matched |
| 89 | capture | 01a1ac63-d3d8-751f-9cb5-4f3981baf721 | €49.00 | €0.67 | matched |
| 90 | capture | 01a1ac63-db93-7a78-992c-073a81d6f886 | €9.00 | €0.19 | matched |
| 92 | capture | 01a1ac63-e863-7a68-bd06-32043529f30f | €49.00 | €0.67 | matched |
| 93 | capture | 01a1ac63-f3e0-7c9c-8831-cfeb1a2ab94f | €24.00 | €0.37 | matched |
| 94 | capture | 01a1ac63-f5c4-7825-8ed0-bbf8f5a04c31 | €49.00 | €0.67 | matched |
| 95 | capture | 01a1ac63-f879-7eaf-92c3-97168c5b3d54 | €49.00 | €0.67 | matched |
| 96 | refund | 01a1ac64-13b7-751f-931a-f55e778da416 | -€9.00 | €0.00 | matched |
| 97 | capture | 01a1ac64-2de1-72ae-8476-e1380fda763b | €35.00 | €0.50 | matched |
| 99 | capture | 01a1ac64-63ac-7f5d-abda-9ed7e0daf2d2 | €49.00 | €0.67 | matched |
| 100 | capture | 01a1ac64-7008-79bd-a476-c13b8e50fb6a | €24.00 | €0.37 | matched |
| 101 | capture | 01a1ac64-774c-75ac-94bf-796c45e78317 | €35.00 | €0.50 | matched |
| 102 | capture | 01a1ac64-805d-7622-adf4-0f82f2a33801 | €49.00 | €0.67 | matched |
| 103 | capture | 01a1ac64-8d87-7117-aa38-5a061d6e855f | €15.00 | €0.26 | matched |
| 104 | capture | 01a1ac64-7a73-73e2-bcc5-f40d6ec0ba12 | €15.00 | €0.26 | matched |
| 105 | capture | 01a1ac64-9fd7-7a64-b4fb-167fdf0455d1 | €9.00 | €0.19 | matched |
| 106 | capture | 01a1ac64-a98c-743c-94c3-940e560e368e | €15.00 | €0.26 | matched |
| 107 | capture | 01a1ac64-aee4-7cd3-9957-2fe0b7929d86 | €49.00 | €0.67 | matched |
| 108 | capture | 01a1ac64-ceb2-73a6-bf8d-78e5ab62c5d8 | €35.00 | €0.50 | matched |
| 109 | capture | 01a1ac64-d95f-7f3c-93d4-7855a45f5cf7 | €15.00 | €0.26 | matched |
| 110 | capture | 01a1ac64-e2c2-78ec-b020-6cfec47aee8f | €35.00 | €0.50 | matched |
| 111 | capture | 01a1ac64-ecd5-7d2b-9bfa-46a887bc5d7e | €24.00 | €0.37 | matched |
| 112 | refund | 01a1ac65-077b-7151-89b8-bb087e2cc81d | -€33.00 | €0.00 | matched |
| 113 | capture | 01a1ac65-1bb7-74be-8eea-9fadbe1bd17e | €35.00 | €0.50 | matched |
| 114 | capture | 01a1ac65-2ec8-76cd-92ce-559f9a75ab0e | €35.00 | €0.50 | matched |
| 115 | capture | 01a1ac65-42d9-75cf-85ed-8a6c1596baa5 | €15.00 | €0.26 | matched |
| 116 | capture | 01a1ac65-5247-7c8a-a893-bc380985c0da | €24.00 | €0.37 | matched |
| 117 | capture | 01a1ac65-5e7f-70ca-958e-95ab36d71849 | €35.00 | €0.50 | matched |
| 118 | capture | 01a1ac65-5fd7-7737-960d-a403c259278a | €24.00 | €0.37 | matched |
| 119 | capture | 01a1ac65-660d-73ed-965f-286d59f8fdce | €24.00 | €0.37 | matched |
| 120 | capture | 01a1ac65-6d04-71e9-9d92-77364ff4347f | €24.00 | €0.37 | matched |
| 121 | capture | 01a1ac65-80c2-78f5-ba0a-917c2f799854 | €15.00 | €0.26 | matched |
| 122 | capture | 01a1ac65-b08f-791a-bc58-49bd5624dc09 | €24.00 | €0.37 | matched |
| 123 | capture | 01a1ac65-c830-7e2c-92ba-486d047a34ff | €24.00 | €0.37 | matched |
| 124 | capture | 01a1ac65-cb10-7459-862d-85149638f607 | €35.00 | €0.50 | matched |
| 125 | capture | 01a1ac65-c710-7ef0-8318-59ac0f64f7e4 | €15.00 | €0.26 | matched |
| 126 | capture | 01a1ac65-e4df-78ee-bc42-3e6ca7300c1d | €35.00 | €0.50 | matched |
| 127 | capture | 01a1ac66-460c-768c-831d-637db55ede4e | €15.00 | €0.26 | matched |
| 128 | capture | 01a1ac66-59fd-7275-b14f-61df2156f244 | €49.00 | €0.67 | matched |
| 129 | capture | 01a1ac66-7772-7b1e-9742-0c8f2e37d130 | €35.00 | €0.50 | matched |
| 130 | capture | 01a1ac66-7dba-7242-89f8-1a35a6d955d8 | €24.00 | €0.37 | matched |
| 131 | capture | 01a1ac66-82e0-74f7-a07d-a40206110be8 | €24.00 | €0.37 | matched |
| 132 | capture | 01a1ac66-9440-7101-9991-a0251c43b67a | €49.00 | €0.67 | matched |
| 133 | capture | 01a1ac66-c36e-7172-86f6-914f47b7ec38 | €15.00 | €0.26 | matched |
| 134 | capture | 01a1ac66-d039-718e-8b3e-ccd3d741d9d9 | €15.00 | €0.26 | matched |
| 135 | capture | 01a1ac66-e24c-7924-badc-ec2650b26ebc | €49.00 | €0.67 | matched |
| 136 | capture | 01a1ac66-e9f9-76be-b947-7a7ae3085603 | €24.00 | €0.37 | matched |
| 137 | capture | 01a1ac67-1065-7beb-a677-eac1a5133f01 | €49.00 | €0.67 | matched |
| 138 | capture | 01a1ac67-15d3-79f0-9171-ae6fc667af45 | €15.00 | €0.26 | matched |