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
- 17 Oct, 02:40106 linesclean
- 17 Oct, 02:30137 lines2 breaks
- 17 Oct, 02:20140 lines1 break
- 17 Oct, 02:10130 lines3 breaks
- 17 Oct, 02:00101 lines1 break
- 17 Oct, 01:5093 lines2 breaks
- 17 Oct, 01:40122 linesclean
- 17 Oct, 01:30131 lines2 breaks
- 17 Oct, 01:20130 lines3 breaks
- 17 Oct, 01:10116 lines4 breaks
- 17 Oct, 01:00130 lines3 breaks
- 17 Oct, 00:50130 lines4 breaks
- 17 Oct, 00:40138 lines4 breaks
- 17 Oct, 00:30131 linesclean
17 Oct, 01:20
Gross
€2,614.00
PSP fee
€43.49
Net to the bank
€2,570.51
Settlement journal
#42902
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14776-edc1-7b40-8415-034b636d24cd is already settled by stl_EUR_2987000 line 87
- missing linein the books, not in the filecapture:01a14775-87bd-7517-a2b4-66ce2a690b75 is in no file
- missing linein the books, not in the filecapture:01a14776-0e67-7c85-a220-0291e2ee993e is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 88 | capture | 01a14776-ee20-7d6d-8e7a-46e117e2d2e2 | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a14769-0c41-7b45-88f6-35a1c1048c7b | €9.00 | €0.19 | matched |
| 2 | refund | 01a14769-b57f-711e-aafe-f9fb5572fdaf | -€21.00 | €0.00 | matched |
| 3 | capture | 01a1476c-8c5a-750c-85cc-2fe60dc38119 | €49.00 | €0.67 | matched |
| 4 | capture | 01a14771-cc59-74eb-968e-df75f6cc48e6 | €24.00 | €0.37 | matched |
| 5 | capture | 01a14771-d075-7875-84b6-3e907fff3f82 | €24.00 | €0.37 | matched |
| 6 | capture | 01a14771-d612-72db-9e69-ba5213486eda | €35.00 | €0.50 | matched |
| 7 | capture | 01a14771-e5a7-729e-834b-fc437605cdc0 | €9.00 | €0.19 | matched |
| 8 | capture | 01a14771-f225-7ab2-96a3-ebce360aa6f0 | €9.00 | €0.19 | matched |
| 9 | capture | 01a14772-0b5b-768a-94d0-ee2c256eb795 | €35.00 | €0.50 | matched |
| 10 | capture | 01a14772-0df5-7d07-a025-07eb0828d382 | €15.00 | €0.26 | matched |
| 11 | capture | 01a14772-1f21-71e9-95b4-1c5d4d3ac6c9 | €9.00 | €0.19 | matched |
| 12 | capture | 01a14772-2c3b-7be7-bea5-fbf7fcf7572b | €24.00 | €0.37 | matched |
| 13 | capture | 01a14772-2ee8-73f7-a908-7a7f793f083a | €15.00 | €0.26 | matched |
| 14 | capture | 01a14772-4a57-7b63-9ad7-6106eb4393ef | €49.00 | €0.67 | matched |
| 15 | capture | 01a14772-5ee2-7ffa-ab32-acb1b37bed26 | €35.00 | €0.50 | matched |
| 16 | refund | 01a14772-8320-7f39-acd9-41aa9d530f3d | -€7.00 | €0.00 | matched |
| 17 | capture | 01a14772-92e2-7276-8536-92cce8cd623e | €24.00 | €0.37 | matched |
| 18 | capture | 01a14772-b6af-7e47-a369-2aea26aa75a3 | €15.00 | €0.26 | matched |
| 19 | capture | 01a14772-cf9d-7d4a-8df4-3981d780e8c8 | €15.00 | €0.26 | matched |
| 20 | capture | 01a14772-e7fe-7c97-b4c2-42bc4b653b6b | €15.00 | €0.26 | matched |
| 21 | capture | 01a14772-ebed-7c22-81c9-5777ab990404 | €49.00 | €0.67 | matched |
| 22 | capture | 01a14772-f09c-7315-8083-b1d27c9d0d3e | €35.00 | €0.50 | matched |
| 23 | capture | 01a14772-f54b-7bf2-bbf2-c38bfc248076 | €24.00 | €0.37 | matched |
| 24 | capture | 01a14772-faef-7225-bc4d-df892f4ec78e | €15.00 | €0.26 | matched |
| 25 | capture | 01a14773-0124-7019-a7cb-edab2b677dce | €35.00 | €0.50 | matched |
| 26 | capture | 01a14773-0bfd-7c91-bc21-13fb079d9442 | €35.00 | €0.50 | matched |
| 27 | refund | 01a14773-1331-7cef-bfec-dfa4a8f87cac | -€3.00 | €0.00 | matched |
| 28 | capture | 01a14773-2021-796e-88d8-f1e21e13b2d9 | €15.00 | €0.26 | matched |
| 29 | refund | 01a14773-3db3-70a5-86aa-4eeb88a06b05 | -€9.00 | €0.00 | matched |
| 30 | capture | 01a14773-43bf-71fa-8ea9-9d99b5535454 | €9.00 | €0.19 | matched |
| 31 | capture | 01a14773-7632-7302-9d3d-f44f35ab27a1 | €35.00 | €0.50 | matched |
| 32 | capture | 01a14773-845b-7e4a-82a2-f73fc5dfa7bd | €9.00 | €0.19 | matched |
| 33 | capture | 01a14773-8dc7-780a-9f56-f80f39b3ad1d | €15.00 | €0.26 | matched |
| 34 | capture | 01a14773-a696-7521-b6bd-b155bab58203 | €15.00 | €0.26 | matched |
| 35 | capture | 01a14773-b17a-7e44-9073-4e75e96e3e85 | €9.00 | €0.19 | matched |
| 36 | capture | 01a14773-c281-78dc-a0db-380c4d63c003 | €9.00 | €0.19 | matched |
| 37 | capture | 01a14773-cf69-77c2-9d98-2323a076b030 | €49.00 | €0.67 | matched |
| 38 | refund | 01a14773-cf9c-762b-aa62-ff50b3cd330e | -€4.00 | €0.00 | matched |
| 39 | capture | 01a14773-c458-70c3-9c36-b5dad3d3d036 | €49.00 | €0.67 | matched |
| 40 | capture | 01a14773-decd-7789-a1ec-8315e465884c | €24.00 | €0.37 | matched |
| 41 | capture | 01a14773-f4b5-7bd7-bd7f-71b98e0c076f | €9.00 | €0.19 | matched |
| 42 | capture | 01a14773-f5be-7ed2-8aa0-ff02c9365b6d | €24.00 | €0.37 | matched |
| 43 | capture | 01a14774-02d1-79ed-8930-f2fc4c60d0c9 | €49.00 | €0.67 | matched |
| 44 | capture | 01a14774-36ab-76c6-a06e-db1ade152c49 | €24.00 | €0.37 | matched |
| 45 | capture | 01a14774-54e9-7db9-84aa-989c25f6ad99 | €15.00 | €0.26 | matched |
| 46 | refund | 01a14774-614a-7ecc-81ff-f9f5f9065615 | -€6.00 | €0.00 | matched |
| 47 | capture | 01a14774-6645-7d78-a427-976a40ff4840 | €49.00 | €0.67 | matched |
| 48 | capture | 01a14774-7169-7392-b857-05da1a29e1b1 | €35.00 | €0.50 | matched |
| 49 | capture | 01a14774-80fc-7965-b044-06a22080757e | €15.00 | €0.26 | matched |
| 50 | capture | 01a14774-85d4-7468-8c88-28ef74052751 | €15.00 | €0.26 | matched |
| 51 | refund | 01a14774-8d31-7f47-af20-fcfdc2c73763 | -€20.00 | €0.00 | matched |
| 52 | capture | 01a14774-8da5-7ab4-ae9d-a684c96f3e6a | €24.00 | €0.37 | matched |
| 53 | capture | 01a14774-97ec-7098-b411-3dc6f0cdadb0 | €15.00 | €0.26 | matched |
| 54 | refund | 01a14774-c331-76dd-935d-80c165bc5101 | -€4.00 | €0.00 | matched |
| 55 | capture | 01a14774-c38f-78f3-829f-90ec7063fccd | €9.00 | €0.19 | matched |
| 56 | capture | 01a14774-cbfe-7954-ad2c-cbe59ab30c0c | €15.00 | €0.26 | matched |
| 57 | refund | 01a14774-cfbc-71aa-9023-3a1301325b0d | -€14.00 | €0.00 | matched |
| 58 | capture | 01a14774-d075-7036-8c71-7822862b950e | €24.00 | €0.37 | matched |
| 59 | capture | 01a14774-dd6b-7806-a9ca-9b18e7714f8b | €49.00 | €0.67 | matched |
| 60 | capture | 01a14774-ddcf-700b-a3dc-4cd2832fc37b | €9.00 | €0.19 | matched |
| 61 | capture | 01a14774-e1b7-7852-b11a-cf1e3b9ea250 | €35.00 | €0.50 | matched |
| 62 | capture | 01a14774-eac7-7e7d-b3cd-2bea13ecb196 | €49.00 | €0.67 | matched |
| 63 | capture | 01a14775-094b-7bb4-9fdb-ff9f224f374e | €49.00 | €0.67 | matched |
| 64 | capture | 01a14775-0fdf-7b7e-9601-008046e8cb33 | €35.00 | €0.50 | matched |
| 65 | capture | 01a14775-3005-7fc4-b25f-d91b0cf786d1 | €49.00 | €0.67 | matched |
| 66 | refund | 01a14775-32ae-7892-9c1e-fb475ce574f0 | -€10.00 | €0.00 | matched |
| 67 | capture | 01a14775-3db0-7bc4-b67b-49012b23c491 | €35.00 | €0.50 | matched |
| 68 | capture | 01a14775-4cdc-7cf7-bf5c-fbb5c4dc88af | €9.00 | €0.19 | matched |
| 69 | refund | 01a14775-999b-7415-8d11-c4004782a00e | -€27.00 | €0.00 | matched |
| 70 | capture | 01a14775-a998-7488-998c-aecb6729c5ba | €24.00 | €0.37 | matched |
| 71 | capture | 01a14775-b977-79b2-b170-ca7f14b5fbd6 | €9.00 | €0.19 | matched |
| 72 | capture | 01a14775-c015-7233-9aaf-be919a85e156 | €15.00 | €0.26 | matched |
| 73 | capture | 01a14775-e4d4-7693-a261-512ed2ca93f7 | €9.00 | €0.19 | matched |
| 74 | capture | 01a14775-f9a3-7f01-b77d-d87d67777fef | €49.00 | €0.67 | matched |
| 75 | capture | 01a14776-08b6-7ee0-9a70-89cec5de5cb8 | €15.00 | €0.26 | matched |
| 76 | capture | 01a14776-2404-7c03-8f13-c75b98f42d3c | €9.00 | €0.19 | matched |
| 77 | capture | 01a14776-37f7-7655-8c49-d9281e63f631 | €35.00 | €0.50 | matched |
| 78 | capture | 01a14776-4cd3-7729-9041-a86a3fb2289d | €35.00 | €0.50 | matched |
| 79 | capture | 01a14776-534d-7212-9b95-faa3645124c6 | €15.00 | €0.26 | matched |
| 80 | capture | 01a14776-5c9b-72f9-9eb4-654ca7288e63 | €15.00 | €0.26 | matched |
| 81 | refund | 01a14776-6e28-7d74-9270-f18de1f8ab86 | -€19.00 | €0.00 | matched |
| 82 | capture | 01a14776-6e2d-7645-ba9a-f4e66d3b371b | €49.00 | €0.67 | matched |
| 83 | capture | 01a14776-79a4-7109-a22e-87dfcf9158d5 | €49.00 | €0.67 | matched |
| 84 | refund | 01a14776-7e83-7b9a-a8da-707835cf72f0 | -€24.00 | €0.00 | matched |
| 85 | capture | 01a14776-98e3-764e-9778-23bf0411c605 | €35.00 | €0.50 | matched |
| 86 | capture | 01a14776-bcaa-7683-8318-2a94fdcb1b8f | €35.00 | €0.50 | matched |
| 87 | capture | 01a14776-ee20-7d6d-8e7a-46e117e2d2e2 | €24.00 | €0.37 | matched |
| 89 | refund | 01a14776-ef8a-735e-ac43-ddd8c3c3819c | -€15.00 | €0.00 | matched |
| 90 | capture | 01a14777-1ba4-730f-b43f-1780e37287e2 | €15.00 | €0.26 | matched |
| 91 | capture | 01a14777-4f99-7802-8f41-6765499e5b08 | €49.00 | €0.67 | matched |
| 92 | capture | 01a14777-9a8e-7931-9650-af17c387bc2a | €49.00 | €0.67 | matched |
| 93 | capture | 01a14777-b8ce-799d-9f56-609bdd99d062 | €9.00 | €0.19 | matched |
| 94 | capture | 01a14777-c0db-796c-b266-67327be9faed | €35.00 | €0.50 | matched |
| 95 | refund | 01a14777-d2ac-78b9-b010-cfdde8089a20 | -€45.00 | €0.00 | matched |
| 96 | capture | 01a14777-e3a2-734c-b9b0-a7df05428a67 | €9.00 | €0.19 | matched |
| 97 | capture | 01a14778-0af7-7daa-b622-2631e2d40acb | €15.00 | €0.26 | matched |
| 98 | capture | 01a14778-0ba1-7f09-8e81-c883672a2358 | €24.00 | €0.37 | matched |
| 99 | capture | 01a14778-167d-7ed5-9155-90a702dfbe7c | €49.00 | €0.67 | matched |
| 100 | capture | 01a14778-3a8b-7301-bf93-4fe6d2a46ab9 | €15.00 | €0.26 | matched |
| 101 | capture | 01a14778-58a5-78e3-9fc7-6ef6da5092c2 | €15.00 | €0.26 | matched |
| 102 | capture | 01a14778-6c8b-729a-8b3d-842e5f60cea5 | €24.00 | €0.37 | matched |
| 103 | capture | 01a14778-6cc5-782a-8fe5-707aff5c2937 | €15.00 | €0.26 | matched |
| 104 | capture | 01a14778-765c-7bf1-b814-58e26e6cb989 | €15.00 | €0.26 | matched |
| 105 | capture | 01a14778-7978-770c-a755-fa4506e7cc50 | €49.00 | €0.67 | matched |
| 106 | capture | 01a14778-842a-76c5-95e9-e6c5080b0028 | €49.00 | €0.67 | matched |
| 107 | capture | 01a14778-8b59-772a-b879-88a4ac9bffe3 | €9.00 | €0.19 | matched |
| 108 | capture | 01a14778-95c2-75ca-9bb9-09a66f913b5e | €15.00 | €0.26 | matched |
| 109 | refund | 01a14778-aaa2-79ad-92c4-57da6318abce | -€8.00 | €0.00 | matched |
| 110 | capture | 01a14778-b6b0-7749-917a-ae4aba279d6e | €24.00 | €0.37 | matched |
| 111 | capture | 01a14778-da87-799e-bf4a-a60a9ac7dd26 | €9.00 | €0.19 | matched |
| 112 | refund | 01a14778-fb8a-74ee-94ec-9d010ecb601b | -€9.00 | €0.00 | matched |
| 113 | capture | 01a14779-8054-7306-8e23-5f87310e355c | €35.00 | €0.50 | matched |
| 114 | capture | 01a14779-820d-7bd0-97fc-8ab980fb70be | €35.00 | €0.50 | matched |
| 115 | capture | 01a14779-91f2-7871-a45d-743bca1a72cb | €15.00 | €0.26 | matched |
| 116 | capture | 01a14779-cbd4-7717-86f8-08b2a9ec11fc | €24.00 | €0.37 | matched |
| 117 | capture | 01a14779-ce20-7b44-a736-4503a688f78d | €49.00 | €0.67 | matched |
| 118 | capture | 01a14779-d492-71d4-b756-94a6f551c423 | €15.00 | €0.26 | matched |
| 119 | capture | 01a14779-ea45-72ff-80d4-3a8bebdf4a83 | €15.00 | €0.26 | matched |
| 120 | capture | 01a14779-ef08-7150-84b0-afe6d9e866e0 | €24.00 | €0.37 | matched |
| 121 | capture | 01a14779-f5e8-7b7f-9bb1-001ae87c3ca5 | €35.00 | €0.50 | matched |
| 122 | capture | 01a1477a-105b-760b-ad92-c1b058336236 | €35.00 | €0.50 | matched |
| 123 | capture | 01a1477a-1a87-7ade-b10f-61afd759b2f1 | €49.00 | €0.67 | matched |
| 124 | capture | 01a1477a-67ad-71bb-90a2-efea75b39779 | €15.00 | €0.26 | matched |
| 125 | capture | 01a1477a-72df-768a-819f-541801cd1a45 | €24.00 | €0.37 | matched |
| 126 | capture | 01a1477a-a8aa-7073-8f64-8205c85dbac5 | €9.00 | €0.19 | matched |
| 127 | refund | 01a1477a-cb13-7d24-a10d-f746ec4429e0 | -€8.00 | €0.00 | matched |
| 128 | capture | 01a1477a-d723-7ad3-88a6-6ae70b5d8b6a | €49.00 | €0.67 | matched |
| 129 | capture | 01a1477a-e5d1-7577-a849-51fd48a70ac3 | €9.00 | €0.19 | matched |
| 130 | capture | 01a1477a-e92a-759e-b681-a7fc9ffaee5c | €9.00 | €0.19 | matched |