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
- 15 Oct, 16:30106 linesclean
- 15 Oct, 16:20130 lines3 breaks
- 15 Oct, 16:10132 lines3 breaks
- 15 Oct, 16:00114 lines2 breaks
- 15 Oct, 15:50116 lines1 break
- 15 Oct, 15:40135 lines1 break
- 15 Oct, 15:30124 lines1 break
- 15 Oct, 15:20132 lines5 breaks
- 15 Oct, 15:10143 lines8 breaks
- 15 Oct, 15:00121 lines2 breaks
- 15 Oct, 14:50107 lines4 breaks
- 15 Oct, 14:40105 lines1 break
- 15 Oct, 14:30108 lines4 breaks
- 15 Oct, 14:20130 lines3 breaks
15 Oct, 14:50
Gross
€2,333.00
PSP fee
€38.02
Net to the bank
€2,294.98
Settlement journal
#16474
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1400c-aa34-7b93-88f4-a03efa6806ef is already settled by stl_EUR_2986793 line 21
- duplicate linethe file lists it twicecapture:01a14011-b6fb-7979-87f0-3aee94bc9cfc is already settled by stl_EUR_2986793 line 86
- missing linein the books, not in the filecapture:01a1400b-25d5-7019-914f-119fb6b6f510 is in no file
- missing linein the books, not in the filerefund:01a1400b-a53a-738e-a907-f21203015223 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 22 | capture | 01a1400c-aa7f-700a-93bf-325da2dda798 | €9.00 | €0.19 | duplicate line |
| 87 | capture | 01a14011-b788-79e7-854f-e08303758180 | €9.00 | €0.19 | duplicate line |
| 1 | capture | 01a14001-7f73-77d1-8fc8-2b485291fa22 | €49.00 | €0.67 | matched |
| 2 | capture | 01a1400a-b7fd-7008-b836-4ef15deefb82 | €49.00 | €0.67 | matched |
| 3 | capture | 01a1400a-d505-7d75-acd0-e75cc84ed16a | €49.00 | €0.67 | matched |
| 4 | capture | 01a1400a-e830-7214-88e4-55e045774a49 | €49.00 | €0.67 | matched |
| 5 | capture | 01a1400a-f59b-7997-abce-8c0f472e80a2 | €24.00 | €0.37 | matched |
| 6 | capture | 01a1400b-063a-7443-9f8d-f3bb8c21b0f2 | €24.00 | €0.37 | matched |
| 7 | capture | 01a1400b-2bb9-76dc-9471-4abab87c50ef | €15.00 | €0.26 | matched |
| 8 | capture | 01a1400b-43f2-7898-a570-83b0c1ca1918 | €24.00 | €0.37 | matched |
| 9 | capture | 01a1400b-51de-7783-85a1-ba3a0f3f7103 | €9.00 | €0.19 | matched |
| 10 | refund | 01a1400b-5f51-757f-8235-6e4aa4c43bb3 | -€21.00 | €0.00 | matched |
| 11 | capture | 01a1400b-b494-7584-acfc-429dd10681b5 | €15.00 | €0.26 | matched |
| 12 | capture | 01a1400b-db73-7348-aa30-909ddd57b400 | €49.00 | €0.67 | matched |
| 13 | capture | 01a1400c-075e-7e89-ad06-37a48cb155d5 | €24.00 | €0.37 | matched |
| 14 | capture | 01a1400c-0b51-7610-bd32-45070e82e7da | €35.00 | €0.50 | matched |
| 15 | capture | 01a1400c-3389-7784-8668-288d0fd7e065 | €15.00 | €0.26 | matched |
| 16 | capture | 01a1400c-3743-7aa5-b03c-be136f23eae5 | €15.00 | €0.26 | matched |
| 17 | capture | 01a1400c-699d-7b4b-9882-4b3eb2b4f307 | €35.00 | €0.50 | matched |
| 18 | capture | 01a1400c-71f8-741e-96ab-7e5caf7a8ec5 | €15.00 | €0.26 | matched |
| 19 | capture | 01a1400c-726d-72fd-96b8-2950baf1fa36 | €35.00 | €0.50 | matched |
| 20 | capture | 01a1400c-81df-740c-b22f-7f515b293e16 | €24.00 | €0.37 | matched |
| 21 | capture | 01a1400c-aa7f-700a-93bf-325da2dda798 | €9.00 | €0.19 | matched |
| 23 | capture | 01a1400c-b29c-7172-ae3a-7a9a7928259b | €24.00 | €0.37 | matched |
| 24 | capture | 01a1400c-edc7-71f5-a65b-a167fede35dd | €49.00 | €0.67 | matched |
| 25 | capture | 01a1400c-fd3d-72bf-8d57-3b3d25246dc7 | €9.00 | €0.19 | matched |
| 26 | capture | 01a1400d-134a-7c03-b090-eacb8191b22d | €49.00 | €0.67 | matched |
| 27 | refund | 01a1400d-1632-7bb4-bd6d-e6ef946a0760 | -€3.00 | €0.00 | matched |
| 28 | capture | 01a1400d-2270-7348-9bee-9958d0778658 | €24.00 | €0.37 | matched |
| 29 | capture | 01a1400d-2a79-7ec2-bb5b-eef66f3d8577 | €9.00 | €0.19 | matched |
| 30 | capture | 01a1400d-36a8-7536-b35b-24ec1e890b49 | €9.00 | €0.19 | matched |
| 31 | refund | 01a1400d-5e03-71a1-9aee-67b437191df1 | -€18.00 | €0.00 | matched |
| 32 | capture | 01a1400d-7008-7d32-9a38-0524a1468a7f | €9.00 | €0.19 | matched |
| 33 | capture | 01a1400d-7f1a-7716-88e5-4b4b902b2e5f | €15.00 | €0.26 | matched |
| 34 | capture | 01a1400d-82a9-79ca-89f3-5910c0530c0e | €49.00 | €0.67 | matched |
| 35 | capture | 01a1400d-8bf8-7f9a-915b-16105fcc0724 | €24.00 | €0.37 | matched |
| 36 | capture | 01a1400d-a034-70f0-b38d-553077c8f99d | €35.00 | €0.50 | matched |
| 37 | capture | 01a1400d-b134-76ca-bb5d-1e1008e1af29 | €15.00 | €0.26 | matched |
| 38 | capture | 01a1400d-b6c3-7ccf-ac42-7c752d12a8cd | €15.00 | €0.26 | matched |
| 39 | capture | 01a1400d-c952-73e6-9f8c-c50599dd0f58 | €9.00 | €0.19 | matched |
| 40 | capture | 01a1400d-d15b-7364-ab40-eb8757ffa0b8 | €35.00 | €0.50 | matched |
| 41 | capture | 01a1400d-d459-7ee2-b726-1e45f1671c2b | €24.00 | €0.37 | matched |
| 42 | capture | 01a1400d-fc03-7932-bab2-84fd5e17acb0 | €24.00 | €0.37 | matched |
| 43 | capture | 01a1400e-08a5-763c-9f75-ece0297ca1b8 | €15.00 | €0.26 | matched |
| 44 | capture | 01a1400e-25d4-7920-804b-d85a859d208a | €35.00 | €0.50 | matched |
| 45 | refund | 01a1400e-2fe5-7b54-92cc-a0b905424c1c | -€5.00 | €0.00 | matched |
| 46 | capture | 01a1400e-300f-7418-b922-14753dcdab4f | €24.00 | €0.37 | matched |
| 47 | refund | 01a1400e-3c9b-7f9d-9b55-83fb0e014687 | -€17.00 | €0.00 | matched |
| 48 | refund | 01a1400e-64df-7ce0-b6b0-6a3c4769ca75 | -€8.00 | €0.00 | matched |
| 49 | capture | 01a1400e-b3ff-7363-92bf-1dce8a1bfa8d | €35.00 | €0.50 | matched |
| 50 | capture | 01a1400e-dc10-7d0e-b608-4348fef8466e | €49.00 | €0.67 | matched |
| 51 | capture | 01a1400e-e6a7-7c42-814a-cf922abc30db | €9.00 | €0.19 | matched |
| 52 | capture | 01a1400e-e733-73c8-8ae7-ed4bcb13382a | €49.00 | €0.67 | matched |
| 53 | capture | 01a1400e-e882-7d40-9715-8fc5b817de57 | €24.00 | €0.37 | matched |
| 54 | capture | 01a1400f-060e-7734-9676-d1c1f56ecc51 | €15.00 | €0.26 | matched |
| 55 | capture | 01a1400f-27cf-7b54-824c-cf4f0340ed17 | €24.00 | €0.37 | matched |
| 56 | capture | 01a1400f-4383-7c07-9646-d8fe825bc8b0 | €35.00 | €0.50 | matched |
| 57 | capture | 01a1400f-59c2-75ff-bb3a-50c9265086cc | €35.00 | €0.50 | matched |
| 58 | capture | 01a1400f-637e-7ea2-be39-cc130b532d38 | €35.00 | €0.50 | matched |
| 59 | capture | 01a1400f-6ba7-75e2-9065-e96845baf3d6 | €15.00 | €0.26 | matched |
| 60 | capture | 01a1400f-82b7-7758-bd2a-ebf74638a659 | €35.00 | €0.50 | matched |
| 61 | capture | 01a1400f-8e55-7de0-9df6-952c0d5c33d6 | €35.00 | €0.50 | matched |
| 62 | capture | 01a1400f-c696-723e-8d89-5c07452460d8 | €49.00 | €0.67 | matched |
| 63 | capture | 01a1400f-d3d4-7ceb-a7a1-d481587c8bc1 | €49.00 | €0.67 | matched |
| 64 | capture | 01a1400f-dc77-7fdf-bbd0-6f58db5c07de | €9.00 | €0.19 | matched |
| 65 | capture | 01a1400f-dcd5-73ca-9b2a-abde3eb25f83 | €15.00 | €0.26 | matched |
| 66 | refund | 01a1400f-e6fe-7e92-9d31-5f93df3fda61 | -€21.00 | €0.00 | matched |
| 67 | capture | 01a1400f-f999-7faa-aeaf-56a32e973268 | €24.00 | €0.37 | matched |
| 68 | capture | 01a14010-759a-775d-a30b-a8982b208345 | €35.00 | €0.50 | matched |
| 69 | capture | 01a14010-88b8-7cef-8e97-f596e9052dbc | €24.00 | €0.37 | matched |
| 70 | capture | 01a14010-9464-7f25-a71e-ca9551301677 | €35.00 | €0.50 | matched |
| 71 | capture | 01a14010-9bed-7613-ada4-391e76f80bc2 | €9.00 | €0.19 | matched |
| 72 | capture | 01a14010-b7a1-7663-9f24-ec3bd000615c | €49.00 | €0.67 | matched |
| 73 | capture | 01a14010-bfd2-7cf6-a750-9d95621b0308 | €24.00 | €0.37 | matched |
| 74 | capture | 01a14010-f0cc-7608-ba4e-e21df2e7b58d | €24.00 | €0.37 | matched |
| 75 | capture | 01a14010-f314-7029-9553-4e5ac8112e98 | €9.00 | €0.19 | matched |
| 76 | refund | 01a14010-f4e5-7154-96a8-72986cb76b99 | -€11.00 | €0.00 | matched |
| 77 | refund | 01a14010-f5e1-70d8-8438-8943b50d268a | -€12.00 | €0.00 | matched |
| 78 | capture | 01a14011-05a0-7330-89df-9bd8e805d6d9 | €24.00 | €0.37 | matched |
| 79 | refund | 01a14011-2232-7324-8c18-2dc09932156d | -€20.00 | €0.00 | matched |
| 80 | capture | 01a14011-2c2b-7dd7-9d5f-5d80ba5426b8 | €9.00 | €0.19 | matched |
| 81 | capture | 01a14011-522b-70a4-8ba8-b18578252668 | €49.00 | €0.67 | matched |
| 82 | capture | 01a14011-5d82-7eca-81f3-2aec9cb1622c | €35.00 | €0.50 | matched |
| 83 | capture | 01a14011-6221-7430-874c-94f0b0ffe325 | €15.00 | €0.26 | matched |
| 84 | capture | 01a14011-6e06-7791-b47b-3579e458eaed | €9.00 | €0.19 | matched |
| 85 | capture | 01a14011-b073-7c7d-ba6e-ab7d047650f6 | €15.00 | €0.26 | matched |
| 86 | capture | 01a14011-b788-79e7-854f-e08303758180 | €9.00 | €0.19 | matched |
| 88 | refund | 01a14011-c4be-726a-acb6-50160d06e939 | -€33.00 | €0.00 | matched |
| 89 | capture | 01a14011-ed04-7305-9616-08b5f1e50c9b | €49.00 | €0.67 | matched |
| 90 | capture | 01a14012-5396-7158-8440-b6c0c6b18cdb | €24.00 | €0.37 | matched |
| 91 | capture | 01a14012-62a1-7b67-aef4-d53629dc1758 | €49.00 | €0.67 | matched |
| 92 | capture | 01a14012-bdf3-749d-8399-342767403a4a | €35.00 | €0.50 | matched |
| 93 | capture | 01a14012-cff1-7601-b9a3-87fd7f0d4ce2 | €35.00 | €0.50 | matched |
| 94 | capture | 01a14012-e49e-720b-91de-fd3155652c85 | €15.00 | €0.26 | matched |
| 95 | capture | 01a14012-f490-7edb-bd3c-3e3c69bc278e | €35.00 | €0.50 | matched |
| 96 | capture | 01a14012-f866-788a-b0fa-bfa4c98a58de | €35.00 | €0.50 | matched |
| 97 | capture | 01a14013-068c-752b-9593-47fc79ba7bc4 | €35.00 | €0.50 | matched |
| 98 | capture | 01a14013-18d0-7e9c-b256-82a143b2731a | €49.00 | €0.67 | matched |
| 99 | capture | 01a14013-1923-7635-a59b-69422fe15615 | €35.00 | €0.50 | matched |
| 100 | capture | 01a14013-2807-780b-bae2-450715a8acfd | €15.00 | €0.26 | matched |
| 101 | refund | 01a14013-280e-7b2d-bc65-37da94d15caf | -€24.00 | €0.00 | matched |
| 102 | capture | 01a14013-2893-760e-a039-9f212f9fc89e | €35.00 | €0.50 | matched |
| 103 | capture | 01a14013-50c2-71bd-9c61-9719069b0e6e | €9.00 | €0.19 | matched |
| 104 | capture | 01a14013-6252-7d7f-ac9f-6efd1da23a40 | €9.00 | €0.19 | matched |
| 105 | capture | 01a14013-a07f-7843-8703-f0251c715ab0 | €35.00 | €0.50 | matched |
| 106 | capture | 01a14013-b161-792f-ac21-b360bb9ed8e4 | €15.00 | €0.26 | matched |
| 107 | capture | 01a14013-c4fa-72a1-9bb1-65ed25a0a9f4 | €15.00 | €0.26 | matched |