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
- 27 Oct, 23:30135 lines2 breaks
- 27 Oct, 23:20141 lines4 breaks
- 27 Oct, 23:10143 lines4 breaks
- 27 Oct, 23:00131 lines2 breaks
- 27 Oct, 22:50134 lines3 breaks
- 27 Oct, 22:40118 lines4 breaks
- 27 Oct, 22:30134 lines6 breaks
- 27 Oct, 22:20108 lines3 breaks
- 27 Oct, 22:10143 lines4 breaks
- 27 Oct, 22:00124 lines3 breaks
- 27 Oct, 21:50115 linesclean
- 27 Oct, 21:40117 lines1 break
- 27 Oct, 21:30131 lines2 breaks
- 27 Oct, 21:20114 lines2 breaks
27 Oct, 22:40
Gross
€2,891.00
PSP fee
€45.13
Net to the bank
€2,845.87
Settlement journal
#240627
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a17f8a-eee3-7e3f-9f85-64373868a288 is already settled by stl_EUR_2988568 line 72
- missing linein the books, not in the filecapture:01a17f8b-f253-7773-b5bc-f470ebef31a8 is in no file
- missing linein the books, not in the filecapture:01a17f8b-a510-756c-a5ff-f6be0d204b84 is in no file
- missing linein the books, not in the filecapture:01a17f88-22b3-7f56-92aa-e1b88d111c3c is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 73 | capture | 01a17f8a-ef12-7bb5-b65b-9962a1b50fd1 | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a17f7d-9737-7f72-83fa-3ebe229d5765 | €24.00 | €0.37 | matched |
| 2 | capture | 01a17f7e-81eb-7440-a27b-67f97c361116 | €15.00 | €0.26 | matched |
| 3 | capture | 01a17f7f-fe1b-7f10-abc3-591966117621 | €15.00 | €0.26 | matched |
| 4 | capture | 01a17f82-6506-75f5-98a8-d48d175e682e | €24.00 | €0.37 | matched |
| 5 | capture | 01a17f84-9282-79aa-865b-11b175c16a2e | €24.00 | €0.37 | matched |
| 6 | capture | 01a17f85-3af2-7479-9de6-048fa1e85982 | €49.00 | €0.67 | matched |
| 7 | capture | 01a17f85-47fa-74c5-933a-1353a4b707c6 | €15.00 | €0.26 | matched |
| 8 | capture | 01a17f85-525c-72f1-a6bb-6e8bda2f493f | €9.00 | €0.19 | matched |
| 9 | capture | 01a17f85-575e-7cbc-879c-dd5617ed2fdc | €35.00 | €0.50 | matched |
| 10 | capture | 01a17f85-59fa-7213-a3f7-0e95aee3f437 | €35.00 | €0.50 | matched |
| 11 | capture | 01a17f85-5bd4-74c4-8255-10c9a2515c89 | €35.00 | €0.50 | matched |
| 12 | capture | 01a17f85-626a-7907-84b7-685a438388da | €24.00 | €0.37 | matched |
| 13 | capture | 01a17f85-7a50-7d7a-af39-5b4156b7e8f0 | €24.00 | €0.37 | matched |
| 14 | capture | 01a17f85-7ccd-7336-8164-5b5fff85cb76 | €49.00 | €0.67 | matched |
| 15 | capture | 01a17f85-857d-7518-aa12-7b48deb6cb16 | €49.00 | €0.67 | matched |
| 16 | capture | 01a17f85-8b91-7fb8-b068-ea12073ca17b | €35.00 | €0.50 | matched |
| 17 | capture | 01a17f85-9488-7a99-8b85-60435dcae63b | €35.00 | €0.50 | matched |
| 18 | capture | 01a17f85-9d6d-7216-a31b-a61bf3203ebb | €35.00 | €0.50 | matched |
| 19 | capture | 01a17f85-aa61-7dce-ac20-0e411b8d301c | €35.00 | €0.50 | matched |
| 20 | capture | 01a17f85-c28f-7c7c-8437-071a26d46341 | €24.00 | €0.37 | matched |
| 21 | capture | 01a17f85-cc59-7f61-9f04-fba26719b7a7 | €24.00 | €0.37 | matched |
| 22 | capture | 01a17f85-d718-70da-8f42-63464b1928ac | €24.00 | €0.37 | matched |
| 23 | capture | 01a17f85-de6f-772c-b599-dc73669444c1 | €24.00 | €0.37 | matched |
| 24 | capture | 01a17f86-02fe-75a7-b1e9-be077429a06a | €49.00 | €0.67 | matched |
| 25 | capture | 01a17f86-18b9-7749-a0d9-e0a567313952 | €15.00 | €0.26 | matched |
| 26 | capture | 01a17f86-5415-707f-9faf-dc0779abfb01 | €9.00 | €0.19 | matched |
| 27 | capture | 01a17f86-57f9-7309-9d00-5d93c45e315b | €49.00 | €0.67 | matched |
| 28 | capture | 01a17f86-780b-7b12-a350-c248bb37f91f | €9.00 | €0.19 | matched |
| 29 | capture | 01a17f86-8b73-7cdb-933c-cc92978a85b9 | €35.00 | €0.50 | matched |
| 30 | capture | 01a17f86-a6f7-7dcb-ad88-a9a4ce356f2b | €24.00 | €0.37 | matched |
| 31 | capture | 01a17f86-c3a1-773a-8f09-5c91ad9e3f11 | €9.00 | €0.19 | matched |
| 32 | capture | 01a17f86-da79-79e0-ab78-92ab46aeed8c | €15.00 | €0.26 | matched |
| 33 | capture | 01a17f86-daee-7339-b1b1-7e96d1e3d3d3 | €9.00 | €0.19 | matched |
| 34 | capture | 01a17f86-df78-78e6-93d7-0339b9a4ce76 | €15.00 | €0.26 | matched |
| 35 | capture | 01a17f86-f200-71e9-a609-5eb828769d2c | €9.00 | €0.19 | matched |
| 36 | capture | 01a17f87-05cf-7c8b-a6c7-ee4c5aab5434 | €24.00 | €0.37 | matched |
| 37 | refund | 01a17f87-34d6-7224-8975-b3bb239a9479 | -€3.00 | €0.00 | matched |
| 38 | capture | 01a17f87-571d-7281-967e-c92b9e50aea7 | €35.00 | €0.50 | matched |
| 39 | capture | 01a17f87-5fe1-7f0b-8bdd-ca23f020fe5c | €35.00 | €0.50 | matched |
| 40 | refund | 01a17f87-6410-7f4e-907e-3d666140d1db | -€16.00 | €0.00 | matched |
| 41 | capture | 01a17f87-7d54-776e-916b-77b414291fee | €24.00 | €0.37 | matched |
| 42 | capture | 01a17f87-7e14-79a2-81eb-8865f870cfb8 | €49.00 | €0.67 | matched |
| 43 | capture | 01a17f87-991a-7eb1-855c-8ccc249d7d89 | €35.00 | €0.50 | matched |
| 44 | capture | 01a17f87-a5b8-709f-bdae-baead7050aa8 | €49.00 | €0.67 | matched |
| 45 | capture | 01a17f88-08fe-7785-9ecf-c7d06da07915 | €15.00 | €0.26 | matched |
| 46 | capture | 01a17f88-25bb-77cc-ad69-3542c47a402c | €24.00 | €0.37 | matched |
| 47 | capture | 01a17f88-37a5-7906-809b-8c64f160a700 | €49.00 | €0.67 | matched |
| 48 | capture | 01a17f88-5c47-7f02-968e-ff165f812ada | €9.00 | €0.19 | matched |
| 49 | capture | 01a17f88-6a2f-767b-89cf-ba1139314b86 | €35.00 | €0.50 | matched |
| 50 | capture | 01a17f88-7421-78a6-9883-888a4417bcee | €9.00 | €0.19 | matched |
| 51 | capture | 01a17f88-a801-7547-a2f6-616437886a79 | €49.00 | €0.67 | matched |
| 52 | capture | 01a17f88-afe1-75b6-b12e-be87cc65344c | €24.00 | €0.37 | matched |
| 53 | capture | 01a17f88-b76f-772a-984e-f6c596621152 | €15.00 | €0.26 | matched |
| 54 | capture | 01a17f88-e37a-7fdf-9968-9693219ef177 | €35.00 | €0.50 | matched |
| 55 | capture | 01a17f89-2e97-79d7-8a50-1d6a0d9d3040 | €49.00 | €0.67 | matched |
| 56 | capture | 01a17f89-3037-705e-b412-0f5dc10cfe81 | €49.00 | €0.67 | matched |
| 57 | capture | 01a17f89-37e2-7b0d-9665-f1e65b000b41 | €35.00 | €0.50 | matched |
| 58 | capture | 01a17f89-46e3-7174-90fb-742e8dab3552 | €35.00 | €0.50 | matched |
| 59 | capture | 01a17f89-5e66-7f1f-8b31-08799d3c1583 | €15.00 | €0.26 | matched |
| 60 | capture | 01a17f89-6ade-75a1-a9d9-815275a90ad4 | €49.00 | €0.67 | matched |
| 61 | capture | 01a17f89-e89a-7562-973b-d03cac3ceee5 | €24.00 | €0.37 | matched |
| 62 | capture | 01a17f89-f7ea-707b-8afd-08d7ff5ded24 | €9.00 | €0.19 | matched |
| 63 | capture | 01a17f8a-18a7-782a-a775-2e0d3794df0c | €35.00 | €0.50 | matched |
| 64 | capture | 01a17f8a-376e-7ef2-aced-69938ed06181 | €9.00 | €0.19 | matched |
| 65 | capture | 01a17f8a-7224-7066-add2-7f33249d1e56 | €35.00 | €0.50 | matched |
| 66 | capture | 01a17f8a-7d04-72d9-baf9-de6cdf924fa5 | €15.00 | €0.26 | matched |
| 67 | capture | 01a17f8a-9305-797c-ba37-33e32650a790 | €15.00 | €0.26 | matched |
| 68 | capture | 01a17f8a-b77b-7b3a-8ac4-0b3dfd87a485 | €35.00 | €0.50 | matched |
| 69 | capture | 01a17f8a-c570-7c11-838f-4533d52dacf3 | €35.00 | €0.50 | matched |
| 70 | capture | 01a17f8a-c713-7f4b-879c-ee733c04639c | €9.00 | €0.19 | matched |
| 71 | capture | 01a17f8a-cdbb-73c0-a291-4f8a432121f9 | €9.00 | €0.19 | matched |
| 72 | capture | 01a17f8a-ef12-7bb5-b65b-9962a1b50fd1 | €24.00 | €0.37 | matched |
| 74 | capture | 01a17f8a-fca8-7670-ad0f-44e3d03de92e | €49.00 | €0.67 | matched |
| 75 | capture | 01a17f8b-053a-73af-b64a-b097ba9afc22 | €15.00 | €0.26 | matched |
| 76 | capture | 01a17f8b-2668-74a9-b205-c681e088a49d | €35.00 | €0.50 | matched |
| 77 | capture | 01a17f8b-3581-71ba-9acd-1a07ebcf1d70 | €35.00 | €0.50 | matched |
| 78 | capture | 01a17f8b-3c8c-7714-8098-edb3652f29bd | €35.00 | €0.50 | matched |
| 79 | capture | 01a17f8b-4c60-7152-ae28-61a61bdd63ba | €35.00 | €0.50 | matched |
| 80 | capture | 01a17f8b-7c88-7dc5-a798-c3ac96637392 | €15.00 | €0.26 | matched |
| 81 | capture | 01a17f8b-842d-7c1d-8373-3d891de2e2dc | €35.00 | €0.50 | matched |
| 82 | capture | 01a17f8b-8716-70ba-8f0e-6c6b6ed4683b | €24.00 | €0.37 | matched |
| 83 | capture | 01a17f8b-9cc0-76f5-9071-d4a0e1e48eed | €35.00 | €0.50 | matched |
| 84 | capture | 01a17f8b-b59a-7137-bd64-45b5999d2400 | €24.00 | €0.37 | matched |
| 85 | capture | 01a17f8b-be7c-70a4-a848-75c8500b36ad | €24.00 | €0.37 | matched |
| 86 | capture | 01a17f8b-bec2-726b-90e0-e9ef612b63e6 | €35.00 | €0.50 | matched |
| 87 | capture | 01a17f8b-cc2f-7c61-9afb-fc61c1fe39bc | €9.00 | €0.19 | matched |
| 88 | capture | 01a17f8b-d32c-7a3e-8247-0f29c58f1be2 | €15.00 | €0.26 | matched |
| 89 | capture | 01a17f8b-e159-7ed0-afb9-aafcdb850fc5 | €24.00 | €0.37 | matched |
| 90 | refund | 01a17f8b-e3ea-7f00-8002-015528765398 | -€20.00 | €0.00 | matched |
| 91 | capture | 01a17f8b-e439-7c06-ba94-e9ff374f6fc6 | €24.00 | €0.37 | matched |
| 92 | capture | 01a17f8c-118d-74b1-894b-ece6cb311d8d | €15.00 | €0.26 | matched |
| 93 | capture | 01a17f8c-3dd2-7a3f-be2d-96b5d4ab6cc8 | €15.00 | €0.26 | matched |
| 94 | capture | 01a17f8c-3de7-72cb-b0e7-5f4990255d9d | €15.00 | €0.26 | matched |
| 95 | capture | 01a17f8c-3e1f-7d01-8f00-4630f2d1444d | €24.00 | €0.37 | matched |
| 96 | capture | 01a17f8c-5833-72e5-adc0-fbd280e0ca3d | €35.00 | €0.50 | matched |
| 97 | capture | 01a17f8c-648e-700d-b3f8-799617407819 | €15.00 | €0.26 | matched |
| 98 | refund | 01a17f8c-6c65-7163-8aba-7aeda08542fe | -€14.00 | €0.00 | matched |
| 99 | capture | 01a17f8c-70f4-740a-92af-39cf7ea7b8c7 | €49.00 | €0.67 | matched |
| 100 | capture | 01a17f8c-a51d-7402-8bf6-63e22b9b3fd5 | €49.00 | €0.67 | matched |
| 101 | capture | 01a17f8c-c371-7e48-a4e5-a98f6332712a | €24.00 | €0.37 | matched |
| 102 | capture | 01a17f8c-db3b-7aa9-8cf9-0f628cdd41b7 | €35.00 | €0.50 | matched |
| 103 | capture | 01a17f8c-e075-7e83-b0fc-54f6c6d1a295 | €9.00 | €0.19 | matched |
| 104 | refund | 01a17f8c-f84f-7efc-8c1f-44002938e264 | -€15.00 | €0.00 | matched |
| 105 | capture | 01a17f8d-a560-7ed5-959d-95fa335bb4f6 | €9.00 | €0.19 | matched |
| 106 | capture | 01a17f8d-bca5-7324-b58e-b76a5412cd22 | €24.00 | €0.37 | matched |
| 107 | capture | 01a17f8d-c015-74e1-b402-dc7f882a829a | €49.00 | €0.67 | matched |
| 108 | capture | 01a17f8d-c994-7d0d-8efc-a4c041e20d0d | €9.00 | €0.19 | matched |
| 109 | capture | 01a17f8d-d2ab-786f-b26f-661c5f35f2a3 | €49.00 | €0.67 | matched |
| 110 | capture | 01a17f8d-ddd7-7f1b-99b4-6be5a0b1a420 | €35.00 | €0.50 | matched |
| 111 | capture | 01a17f8d-ef9e-799d-98a4-d84bf1eec336 | €9.00 | €0.19 | matched |
| 112 | capture | 01a17f8d-f361-700e-9547-f4ebe7a71300 | €35.00 | €0.50 | matched |
| 113 | capture | 01a17f8d-ff96-7cdf-b7b5-a7d4f1799708 | €15.00 | €0.26 | matched |
| 114 | capture | 01a17f8e-286a-76a5-be60-1493abd07c46 | €9.00 | €0.19 | matched |
| 115 | refund | 01a17f8e-38ed-7369-a54f-58a8495fa40f | -€45.00 | €0.00 | matched |
| 116 | capture | 01a17f8e-48c3-7d69-899b-af3c1ae538cc | €35.00 | €0.50 | matched |
| 117 | capture | 01a17f8e-5bf2-738c-b92c-a241ad51ec37 | €24.00 | €0.37 | matched |
| 118 | capture | 01a17f8e-6056-792b-9f4b-a6ee70b35ea6 | €15.00 | €0.26 | matched |