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, 00:30138 lines1 break
- 19 Oct, 00:2088 lines3 breaks
- 19 Oct, 00:10122 linesclean
- 19 Oct, 00:00120 lines2 breaks
- 18 Oct, 23:50135 lines3 breaks
- 18 Oct, 23:40118 lines2 breaks
- 18 Oct, 23:30140 lines2 breaks
- 18 Oct, 23:20135 lines3 breaks
- 18 Oct, 23:10114 lines2 breaks
- 18 Oct, 23:00114 lines1 break
- 18 Oct, 22:50145 lines3 breaks
- 18 Oct, 22:40125 lines2 breaks
- 18 Oct, 22:30115 lines3 breaks
- 18 Oct, 22:20134 lines3 breaks
18 Oct, 23:30
Gross
€3,195.00
PSP fee
€51.44
Net to the bank
€3,143.56
Settlement journal
#77425
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1515d-0264-7649-86ee-d50f863520cc is already settled by stl_EUR_2987277 line 59
- missing linein the books, not in the filecapture:01a1515c-643b-7a05-bba9-1227dbdfaf3a is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 60 | capture | 01a1515d-02af-7360-94c7-757c10061c5f | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a15155-7521-7ceb-815d-d9ad5b0b8d5b | €24.00 | €0.37 | matched |
| 2 | capture | 01a15159-c98e-79b1-b2b6-7d9b7cd8f3c6 | €15.00 | €0.26 | matched |
| 3 | capture | 01a15159-ca66-776c-9f01-ef203a5f0481 | €35.00 | €0.50 | matched |
| 4 | capture | 01a15159-cfc0-7cd3-9adb-55b11ddd6f4e | €49.00 | €0.67 | matched |
| 5 | capture | 01a15159-e0d6-7433-a9f5-71bf570f2f66 | €35.00 | €0.50 | matched |
| 6 | capture | 01a1515a-0e21-77dd-bb81-a43606d5b59d | €49.00 | €0.67 | matched |
| 7 | refund | 01a1515a-17d0-78e0-9080-c2402460d6b4 | -€41.00 | €0.00 | matched |
| 8 | capture | 01a1515a-283d-7461-83ad-ae272e41eac9 | €15.00 | €0.26 | matched |
| 9 | capture | 01a1515a-3455-7b77-acc3-a7b2e3571a34 | €49.00 | €0.67 | matched |
| 10 | capture | 01a1515a-3656-7965-85b1-cc944b129898 | €15.00 | €0.26 | matched |
| 11 | capture | 01a1515a-3d50-7235-9100-32365da39180 | €49.00 | €0.67 | matched |
| 12 | refund | 01a1515a-3e4a-76aa-a62e-dd67d5b7a9d3 | -€6.00 | €0.00 | matched |
| 13 | capture | 01a1515a-567c-7cf7-9dbf-60ae0f1c9b38 | €24.00 | €0.37 | matched |
| 14 | capture | 01a1515a-6036-712d-8d30-cd2cddbc01bc | €9.00 | €0.19 | matched |
| 15 | capture | 01a1515a-8fea-78dc-aa33-b5c65a739cfb | €9.00 | €0.19 | matched |
| 16 | refund | 01a1515a-90df-76b1-9f1d-395ea1e54409 | -€46.00 | €0.00 | matched |
| 17 | capture | 01a1515a-99e0-747c-aab2-80164e1b6c67 | €15.00 | €0.26 | matched |
| 18 | capture | 01a1515a-9d7e-7724-99d1-e4e725f101cb | €49.00 | €0.67 | matched |
| 19 | capture | 01a1515a-a776-74ff-817f-d0efc08a2d99 | €35.00 | €0.50 | matched |
| 20 | capture | 01a1515a-db27-7c5d-966f-b899ac3a6368 | €35.00 | €0.50 | matched |
| 21 | capture | 01a1515a-dd5b-79a3-a211-5e8546681cc2 | €9.00 | €0.19 | matched |
| 22 | capture | 01a1515a-e2b8-7cae-9609-1ef51e353571 | €24.00 | €0.37 | matched |
| 23 | capture | 01a1515a-e61e-7df4-a676-11ee956822c1 | €49.00 | €0.67 | matched |
| 24 | capture | 01a1515b-018f-7640-be79-b392da3080f6 | €15.00 | €0.26 | matched |
| 25 | capture | 01a1515b-0485-7389-9226-337ba0be1e64 | €35.00 | €0.50 | matched |
| 26 | capture | 01a1515b-5012-73e0-a555-261ddec6316d | €15.00 | €0.26 | matched |
| 27 | capture | 01a1515b-52c4-7831-b013-825daed0a9c3 | €35.00 | €0.50 | matched |
| 28 | capture | 01a1515b-574b-755f-8420-f505ed9ded31 | €15.00 | €0.26 | matched |
| 29 | capture | 01a1515b-7067-7766-8d69-54de39de710d | €35.00 | €0.50 | matched |
| 30 | capture | 01a1515b-7eb7-7ff7-a936-fac4fe31c600 | €35.00 | €0.50 | matched |
| 31 | capture | 01a1515b-80b4-771b-aa60-73d3c1dfef4a | €15.00 | €0.26 | matched |
| 32 | capture | 01a1515b-9819-7b65-bb50-ebe231d0fc45 | €9.00 | €0.19 | matched |
| 33 | capture | 01a1515b-a76a-7a4d-be84-8e0b9ef867fb | €49.00 | €0.67 | matched |
| 34 | capture | 01a1515b-a99b-75d5-99d2-02239d9d1271 | €15.00 | €0.26 | matched |
| 35 | capture | 01a1515b-ad1a-7be6-8855-9187e93570a8 | €15.00 | €0.26 | matched |
| 36 | capture | 01a1515b-ae62-7b13-a9e1-9022825fc181 | €15.00 | €0.26 | matched |
| 37 | capture | 01a1515b-d5f9-7dc5-9eaf-878354badec9 | €49.00 | €0.67 | matched |
| 38 | capture | 01a1515b-d876-7763-868a-f186aca0874e | €49.00 | €0.67 | matched |
| 39 | capture | 01a1515b-e4b2-763a-b3e8-1d9a84cff004 | €35.00 | €0.50 | matched |
| 40 | capture | 01a1515b-f0ff-7c88-9a1c-2c7d26ab62ba | €24.00 | €0.37 | matched |
| 41 | capture | 01a1515c-10b7-7300-abf3-9e179c35f691 | €9.00 | €0.19 | matched |
| 42 | capture | 01a1515c-1d55-7edc-9dc9-6eff9bd4a33f | €9.00 | €0.19 | matched |
| 43 | capture | 01a1515c-302e-7647-bcfa-11227ba03422 | €24.00 | €0.37 | matched |
| 44 | capture | 01a1515c-31bd-787e-b94f-44a28f3a3772 | €15.00 | €0.26 | matched |
| 45 | capture | 01a1515c-3b52-73c6-a05e-92184be05cd9 | €15.00 | €0.26 | matched |
| 46 | refund | 01a1515c-3ff0-7198-bdd1-e82b95a2bd9d | -€13.00 | €0.00 | matched |
| 47 | capture | 01a1515c-45e2-76ad-aede-523ea1f93bf4 | €9.00 | €0.19 | matched |
| 48 | capture | 01a1515c-67d7-716a-a03b-a9d841b80419 | €35.00 | €0.50 | matched |
| 49 | capture | 01a1515c-69f7-7ce7-bd4e-673c57596401 | €24.00 | €0.37 | matched |
| 50 | capture | 01a1515c-7bb6-7c3c-aa88-5093f4d5857d | €24.00 | €0.37 | matched |
| 51 | capture | 01a1515c-8d8f-7402-8431-ce0147cc643e | €49.00 | €0.67 | matched |
| 52 | capture | 01a1515c-a212-745f-be1d-30e1b84e6264 | €15.00 | €0.26 | matched |
| 53 | capture | 01a1515c-d24e-786b-8376-f66db457b779 | €35.00 | €0.50 | matched |
| 54 | refund | 01a1515c-dd4d-7b98-a929-6bfa05cb71c3 | -€32.00 | €0.00 | matched |
| 55 | capture | 01a1515c-e35d-7874-bcfb-2f4dfc840ca7 | €15.00 | €0.26 | matched |
| 56 | capture | 01a1515c-dc47-79ae-abb6-b87b4352aa7f | €35.00 | €0.50 | matched |
| 57 | capture | 01a1515c-f1ed-738b-9e12-baf37af33acc | €15.00 | €0.26 | matched |
| 58 | capture | 01a1515c-f256-7435-8bf3-9fb21c36662e | €15.00 | €0.26 | matched |
| 59 | capture | 01a1515d-02af-7360-94c7-757c10061c5f | €49.00 | €0.67 | matched |
| 61 | capture | 01a1515d-02fe-7554-87aa-f066cdbb7059 | €49.00 | €0.67 | matched |
| 62 | capture | 01a1515d-1404-7556-a21b-2659e25cd8b4 | €35.00 | €0.50 | matched |
| 63 | capture | 01a1515d-2232-76e9-a660-ec1a15dce51d | €15.00 | €0.26 | matched |
| 64 | capture | 01a1515d-2ba5-761d-acff-a9f9b2bccd8e | €35.00 | €0.50 | matched |
| 65 | capture | 01a1515d-3bc9-794f-8237-477901394163 | €49.00 | €0.67 | matched |
| 66 | capture | 01a1515d-429d-704e-9967-a2e44347492a | €24.00 | €0.37 | matched |
| 67 | capture | 01a1515d-5e69-725c-96c3-bb2a3b2caecc | €15.00 | €0.26 | matched |
| 68 | capture | 01a1515d-6392-70c1-bc28-37ec3b188f06 | €35.00 | €0.50 | matched |
| 69 | capture | 01a1515d-d542-7458-ae75-7ca9e6303bfa | €9.00 | €0.19 | matched |
| 70 | capture | 01a1515d-d69a-7cfe-998f-a5555794cb47 | €15.00 | €0.26 | matched |
| 71 | capture | 01a1515d-e03b-7f33-9b08-d29b6f389bcb | €15.00 | €0.26 | matched |
| 72 | capture | 01a1515d-ee09-79f6-b3da-9ea75853b471 | €15.00 | €0.26 | matched |
| 73 | capture | 01a1515e-065c-79f8-a98d-ee037dc1fe24 | €9.00 | €0.19 | matched |
| 74 | capture | 01a1515e-19e3-7091-bdb8-3b22a7d2c6dc | €15.00 | €0.26 | matched |
| 75 | capture | 01a1515e-1a98-7858-96e9-a35643c17139 | €24.00 | €0.37 | matched |
| 76 | capture | 01a1515e-2f35-76cf-accf-ade2567da787 | €35.00 | €0.50 | matched |
| 77 | capture | 01a1515e-3a0f-7f38-8396-6ecd5adb5269 | €9.00 | €0.19 | matched |
| 78 | capture | 01a1515e-473e-7ecb-babd-8922f2e2b3e8 | €24.00 | €0.37 | matched |
| 79 | capture | 01a1515e-4955-7e03-a10b-cc22171968e2 | €35.00 | €0.50 | matched |
| 80 | capture | 01a1515e-9fe4-7fc9-b4fe-c1401c12882e | €35.00 | €0.50 | matched |
| 81 | capture | 01a1515e-c831-79c9-83f3-9800accc407e | €49.00 | €0.67 | matched |
| 82 | capture | 01a1515e-fac9-7948-9960-378811602765 | €9.00 | €0.19 | matched |
| 83 | capture | 01a1515f-08b3-7134-8b6b-cbc4a136c4a4 | €24.00 | €0.37 | matched |
| 84 | capture | 01a1515f-13d6-7398-9bc9-afc772d1701a | €24.00 | €0.37 | matched |
| 85 | capture | 01a1515f-2169-7cd9-943c-69fe1e2cf7c7 | €9.00 | €0.19 | matched |
| 86 | capture | 01a1515f-2a93-70e7-89a9-f312df2fbb6f | €24.00 | €0.37 | matched |
| 87 | capture | 01a1515f-35ce-7d2d-bb5c-cb1c9c647d97 | €15.00 | €0.26 | matched |
| 88 | capture | 01a1515f-38da-7a08-b393-f389cc0b919e | €49.00 | €0.67 | matched |
| 89 | capture | 01a1515f-5a95-7f6a-be26-076515df7696 | €15.00 | €0.26 | matched |
| 90 | capture | 01a1515f-931e-798a-acba-4d94357b82f1 | €35.00 | €0.50 | matched |
| 91 | capture | 01a1515f-94fc-7392-bbb4-b81910442c7d | €9.00 | €0.19 | matched |
| 92 | capture | 01a1515f-b696-715f-92a5-47a444d14d50 | €49.00 | €0.67 | matched |
| 93 | capture | 01a1515f-b723-7a0c-a741-e51eb1ed4af1 | €49.00 | €0.67 | matched |
| 94 | capture | 01a1515f-d5c4-7a9b-833e-c8141dc05d4f | €49.00 | €0.67 | matched |
| 95 | capture | 01a1515f-e938-7113-974f-d73ae81bf9e3 | €35.00 | €0.50 | matched |
| 96 | capture | 01a15160-1610-7770-b91e-036e990e5b89 | €15.00 | €0.26 | matched |
| 97 | capture | 01a15160-47d4-7f9d-9add-cd33f5cb57ae | €9.00 | €0.19 | matched |
| 98 | capture | 01a15160-4c55-73a5-a26b-631cd5312a7d | €9.00 | €0.19 | matched |
| 99 | refund | 01a15160-54b4-752b-989a-5b82fae0009b | -€8.00 | €0.00 | matched |
| 100 | capture | 01a15160-5eb3-7814-bd72-474c4e7b81d6 | €35.00 | €0.50 | matched |
| 101 | capture | 01a15160-80ca-7f40-badc-3278c945065e | €15.00 | €0.26 | matched |
| 102 | capture | 01a15160-a49e-7a92-8346-81708568bc55 | €49.00 | €0.67 | matched |
| 103 | capture | 01a15160-c3ad-714f-bd41-531e74a34649 | €35.00 | €0.50 | matched |
| 104 | capture | 01a15160-c4a4-7051-9b40-831b30d7f22d | €49.00 | €0.67 | matched |
| 105 | capture | 01a15160-cb12-7da8-9d3f-786e2f8965ce | €15.00 | €0.26 | matched |
| 106 | capture | 01a15160-eec6-7e2d-9f9e-e2470b9410ce | €24.00 | €0.37 | matched |
| 107 | capture | 01a15161-015c-7d63-a3f3-acbb49da2dde | €24.00 | €0.37 | matched |
| 108 | capture | 01a15161-07d1-7821-a3cb-7c32b32e6788 | €9.00 | €0.19 | matched |
| 109 | capture | 01a15161-0ffd-76b7-b90a-38c828b9dad1 | €9.00 | €0.19 | matched |
| 110 | capture | 01a15161-3b3b-78e0-bfe2-e6b5d3e863bf | €35.00 | €0.50 | matched |
| 111 | capture | 01a15161-772a-7dd0-aa81-daace50f428a | €49.00 | €0.67 | matched |
| 112 | capture | 01a15161-7994-71ce-8a11-c5391be10156 | €49.00 | €0.67 | matched |
| 113 | capture | 01a15161-7a89-7cbf-b065-67dea0d773d2 | €9.00 | €0.19 | matched |
| 114 | capture | 01a15161-813c-741c-9870-fbc93abe24d7 | €24.00 | €0.37 | matched |
| 115 | capture | 01a15161-a51c-7675-b4af-6b284c961139 | €24.00 | €0.37 | matched |
| 116 | capture | 01a15161-c6cf-779c-ba23-72b8cc45f240 | €9.00 | €0.19 | matched |
| 117 | capture | 01a15161-c88a-7b44-b7bc-577f014ea661 | €24.00 | €0.37 | matched |
| 118 | capture | 01a15161-d938-7a38-af7b-218c2661234b | €9.00 | €0.19 | matched |
| 119 | capture | 01a15161-e519-791a-9362-2d522e80e5fb | €15.00 | €0.26 | matched |
| 120 | capture | 01a15161-ea5e-7d02-82b9-331eee82254f | €9.00 | €0.19 | matched |
| 121 | capture | 01a15161-f660-73d0-a7b4-288e7cc8509e | €24.00 | €0.37 | matched |
| 122 | capture | 01a15161-f838-7e6b-8a2d-042075e79e6d | €49.00 | €0.67 | matched |
| 123 | capture | 01a15161-fbdc-770a-a7dd-7284714e8311 | €24.00 | €0.37 | matched |
| 124 | capture | 01a15162-015d-70d8-8f35-d7d77314907a | €15.00 | €0.26 | matched |
| 125 | capture | 01a15162-1b16-7133-ba45-e99f31ebc6c4 | €24.00 | €0.37 | matched |
| 126 | capture | 01a15162-23c7-7844-923d-d1cb95fb466d | €35.00 | €0.50 | matched |
| 127 | capture | 01a15162-2857-7f7c-a6ac-c1170d871d7b | €9.00 | €0.19 | matched |
| 128 | capture | 01a15162-3cb7-71a3-aa22-26c6c0dbbf2e | €24.00 | €0.37 | matched |
| 129 | capture | 01a15162-4496-7cf1-986a-e5fb5c843ea2 | €49.00 | €0.67 | matched |
| 130 | capture | 01a15162-503a-7f13-b6fd-24932a681e2a | €49.00 | €0.67 | matched |
| 131 | capture | 01a15162-5048-7477-9454-b0c88df5c428 | €9.00 | €0.19 | matched |
| 132 | refund | 01a15162-51d0-75c7-a239-8bc3e5d83501 | -€46.00 | €0.00 | matched |
| 133 | capture | 01a15162-5817-70fd-aa68-9433e4553ac4 | €9.00 | €0.19 | matched |
| 134 | refund | 01a15162-666a-7431-a583-abff5ea16488 | -€7.00 | €0.00 | matched |
| 135 | capture | 01a15162-7463-76b7-a23b-75aba44e7a95 | €9.00 | €0.19 | matched |
| 136 | capture | 01a15162-8dec-7a5d-9c94-cb78b0642305 | €9.00 | €0.19 | matched |
| 137 | capture | 01a15162-a788-7eb5-9a9d-8a3735c30829 | €9.00 | €0.19 | matched |
| 138 | capture | 01a15162-a944-74b1-895f-72039b5661ab | €9.00 | €0.19 | matched |
| 139 | capture | 01a15162-ac47-79f4-81ff-cf5b462dbab5 | €35.00 | €0.50 | matched |
| 140 | capture | 01a15162-bd26-7553-ba94-d6dd70e94d9a | €15.00 | €0.26 | matched |