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
- 30 Oct, 21:20123 lines3 breaks
- 30 Oct, 21:10130 lines4 breaks
- 30 Oct, 21:00131 lines2 breaks
- 30 Oct, 20:50139 lines4 breaks
- 30 Oct, 20:40128 lines1 break
- 30 Oct, 20:30135 lines1 break
- 30 Oct, 20:20123 lines3 breaks
- 30 Oct, 20:10138 lines3 breaks
- 30 Oct, 20:00138 lines3 breaks
- 30 Oct, 19:50130 lines7 breaks
- 30 Oct, 19:40105 lines3 breaks
- 30 Oct, 19:30125 lines4 breaks
- 30 Oct, 19:20126 lines4 breaks
- 30 Oct, 19:10118 lines3 breaks
30 Oct, 20:20
Gross
€2,518.00
PSP fee
€41.36
Net to the bank
€2,476.64
Settlement journal
#293899
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a18e7e-d1cf-77f3-872b-73d163d36872 is already settled by stl_EUR_2988986 line 84
- duplicate linethe file lists it twicecapture:01a18e80-0829-700d-a5c7-1f9f6bee2e51 is already settled by stl_EUR_2988986 line 97
- duplicate linethe file lists it twicecapture:01a18e81-0537-7a52-98a8-80a25db584c8 is already settled by stl_EUR_2988986 line 119
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 85 | refund | 01a18e7e-d1d1-7dec-8c36-26257e5f6dcd | -€31.00 | €0.00 | duplicate line |
| 98 | capture | 01a18e80-087b-789c-80a3-dd9f25b652db | €9.00 | €0.19 | duplicate line |
| 120 | capture | 01a18e81-07b1-7a28-a6fc-6331dca9e6fa | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a18e70-4543-7977-8bf0-a5d23e867d42 | €15.00 | €0.26 | matched |
| 2 | refund | 01a18e71-e13e-75ae-a0e3-7581374158fc | -€8.00 | €0.00 | matched |
| 3 | capture | 01a18e72-3e4f-7f9f-b278-874299e03839 | €15.00 | €0.26 | matched |
| 4 | capture | 01a18e73-070b-78f7-9f7a-7c6c58b0c3c2 | €35.00 | €0.50 | matched |
| 5 | capture | 01a18e75-50a6-7296-a695-b4cd4b696c05 | €35.00 | €0.50 | matched |
| 6 | refund | 01a18e78-3b4d-745e-900b-a298059811f0 | -€3.00 | €0.00 | matched |
| 7 | refund | 01a18e78-4243-76fd-abf8-62837b5b05d6 | -€7.00 | €0.00 | matched |
| 8 | capture | 01a18e78-4500-73c6-a7c3-453644b21bad | €35.00 | €0.50 | matched |
| 9 | capture | 01a18e78-46c8-716d-bc67-894e00a59877 | €35.00 | €0.50 | matched |
| 10 | capture | 01a18e78-499d-7e84-9aac-23918cceb9f7 | €35.00 | €0.50 | matched |
| 11 | capture | 01a18e78-6204-78ad-b9e2-9169c16617f6 | €9.00 | €0.19 | matched |
| 12 | refund | 01a18e78-7045-79fb-8de7-ffa44ba46e3e | -€3.00 | €0.00 | matched |
| 13 | capture | 01a18e78-851e-7579-9a90-b4adcaad8775 | €9.00 | €0.19 | matched |
| 14 | capture | 01a18e78-8db4-73dc-ac58-e881d41bb18a | €15.00 | €0.26 | matched |
| 15 | capture | 01a18e78-a101-71ef-be84-b736cc9fd7e9 | €49.00 | €0.67 | matched |
| 16 | capture | 01a18e78-b1e1-7fa6-9d53-e338397ab30c | €24.00 | €0.37 | matched |
| 17 | capture | 01a18e78-c592-7640-8149-f3e85d37e117 | €49.00 | €0.67 | matched |
| 18 | capture | 01a18e78-e22a-72a2-812b-d9653e2488f8 | €35.00 | €0.50 | matched |
| 19 | capture | 01a18e78-e50e-7f50-9e47-b138d3b2b010 | €35.00 | €0.50 | matched |
| 20 | capture | 01a18e78-e858-774c-a3ff-9b797fd6ab7e | €24.00 | €0.37 | matched |
| 21 | capture | 01a18e78-f64d-7ee2-aa6a-272c9760fd66 | €9.00 | €0.19 | matched |
| 22 | refund | 01a18e79-0133-783d-881f-dc282364f1a0 | -€28.00 | €0.00 | matched |
| 23 | capture | 01a18e79-2f85-7b0e-ad29-ccae8d925a85 | €15.00 | €0.26 | matched |
| 24 | refund | 01a18e79-36e2-70f8-8131-e039c48c7c7a | -€24.00 | €0.00 | matched |
| 25 | capture | 01a18e79-59c4-72ce-96ba-7ddaa8fef066 | €49.00 | €0.67 | matched |
| 26 | capture | 01a18e79-7b5e-755d-884a-c4403228d48d | €9.00 | €0.19 | matched |
| 27 | capture | 01a18e79-7b97-7125-a53d-f8c5ff7ef6c3 | €15.00 | €0.26 | matched |
| 28 | capture | 01a18e79-87e0-741d-8ffb-62c81c6c175f | €35.00 | €0.50 | matched |
| 29 | capture | 01a18e79-8cf7-70bf-82a7-cda11b7d2139 | €9.00 | €0.19 | matched |
| 30 | refund | 01a18e79-8e05-7be2-b865-88c89b6c7bde | -€12.00 | €0.00 | matched |
| 31 | capture | 01a18e79-a359-73de-b431-0ebcb61cffa3 | €35.00 | €0.50 | matched |
| 32 | capture | 01a18e79-df16-7863-839b-9d6f17ebf5b2 | €9.00 | €0.19 | matched |
| 33 | capture | 01a18e7a-080e-7192-b8eb-6785c0bf6a7f | €24.00 | €0.37 | matched |
| 34 | capture | 01a18e7a-0bb4-7f3f-befb-6414bfe5e9b3 | €9.00 | €0.19 | matched |
| 35 | capture | 01a18e7a-1ed2-7f63-96da-580db40e145e | €15.00 | €0.26 | matched |
| 36 | capture | 01a18e7a-3ab1-7774-892d-cf3c8d0d5dab | €49.00 | €0.67 | matched |
| 37 | capture | 01a18e7a-502e-798d-9417-3e0def28dbb3 | €49.00 | €0.67 | matched |
| 38 | capture | 01a18e7a-6472-74e5-b8d5-c501a908c255 | €49.00 | €0.67 | matched |
| 39 | capture | 01a18e7a-89bd-7dbf-ba45-cdf1bddb6d56 | €9.00 | €0.19 | matched |
| 40 | capture | 01a18e7a-8b9a-7a7a-8de1-c578eb9c9b1d | €35.00 | €0.50 | matched |
| 41 | capture | 01a18e7a-a32e-794b-8ef9-010dbe88caaf | €15.00 | €0.26 | matched |
| 42 | capture | 01a18e7a-ae9d-7e86-961c-ff08884ea3be | €49.00 | €0.67 | matched |
| 43 | capture | 01a18e7a-d50c-7d3e-9823-60b8a4871f9c | €9.00 | €0.19 | matched |
| 44 | capture | 01a18e7a-dc4f-7130-b8b3-745815f94939 | €9.00 | €0.19 | matched |
| 45 | capture | 01a18e7b-08b5-7fd0-b5ec-8b106ab08523 | €15.00 | €0.26 | matched |
| 46 | capture | 01a18e7b-1285-7a78-8077-2b0b0e3d48e6 | €9.00 | €0.19 | matched |
| 47 | capture | 01a18e7b-4262-7258-b29f-da472c63db58 | €35.00 | €0.50 | matched |
| 48 | capture | 01a18e7b-48c2-734d-b5ba-629a816fef98 | €35.00 | €0.50 | matched |
| 49 | capture | 01a18e7b-7f77-7ee8-a84a-844d67ac4664 | €9.00 | €0.19 | matched |
| 50 | capture | 01a18e7b-9f48-70cd-bbb8-9f6f784becd7 | €24.00 | €0.37 | matched |
| 51 | refund | 01a18e7b-b25e-75da-a634-ce3c044fa6d8 | -€10.00 | €0.00 | matched |
| 52 | capture | 01a18e7b-b384-7b27-9678-753159b18956 | €15.00 | €0.26 | matched |
| 53 | capture | 01a18e7b-e0b0-703b-a767-f95316a4f855 | €15.00 | €0.26 | matched |
| 54 | capture | 01a18e7c-29ac-740f-8926-f93ab5e215ec | €24.00 | €0.37 | matched |
| 55 | capture | 01a18e7c-2a54-7c2d-a412-a02f764b85a2 | €9.00 | €0.19 | matched |
| 56 | capture | 01a18e7c-2dfb-70a6-ba30-b255ca993b57 | €24.00 | €0.37 | matched |
| 57 | capture | 01a18e7c-3bc8-798a-a19c-ae127c6d8fbe | €35.00 | €0.50 | matched |
| 58 | capture | 01a18e7c-463d-72eb-a6dc-2deb028add16 | €9.00 | €0.19 | matched |
| 59 | capture | 01a18e7c-4e0a-7f80-af83-c0217669220f | €9.00 | €0.19 | matched |
| 60 | capture | 01a18e7c-ba1c-74f7-a313-d8d1366c6aa4 | €49.00 | €0.67 | matched |
| 61 | capture | 01a18e7c-db63-7891-b08e-374dacb33767 | €35.00 | €0.50 | matched |
| 62 | capture | 01a18e7c-e9ac-7985-9002-62f418e98777 | €49.00 | €0.67 | matched |
| 63 | capture | 01a18e7c-eedb-73d6-88f8-047f182c1113 | €9.00 | €0.19 | matched |
| 64 | capture | 01a18e7d-1304-788e-81f2-c9e47608c535 | €15.00 | €0.26 | matched |
| 65 | capture | 01a18e7d-405b-754c-8b39-4fd931f9dcb6 | €35.00 | €0.50 | matched |
| 66 | capture | 01a18e7d-4b1b-7915-a880-ff707656212d | €35.00 | €0.50 | matched |
| 67 | capture | 01a18e7d-6121-7d70-9cd4-679c08505055 | €24.00 | €0.37 | matched |
| 68 | capture | 01a18e7d-89cb-729c-be13-b26ca2ca5aca | €9.00 | €0.19 | matched |
| 69 | capture | 01a18e7d-97b4-7bb1-b927-f93f808de05a | €9.00 | €0.19 | matched |
| 70 | refund | 01a18e7d-a3f1-7136-81e9-de4cf427fb2f | -€9.00 | €0.00 | matched |
| 71 | capture | 01a18e7d-b9d9-7e45-8169-b841bd2e6d79 | €9.00 | €0.19 | matched |
| 72 | capture | 01a18e7d-e9af-7091-9ae1-b886bd0012b4 | €9.00 | €0.19 | matched |
| 73 | capture | 01a18e7e-0333-7d1b-81cf-4e23579d2070 | €9.00 | €0.19 | matched |
| 74 | capture | 01a18e7e-09a4-71e2-b4e1-728d3f6548e0 | €9.00 | €0.19 | matched |
| 75 | capture | 01a18e7e-2e9b-71a4-b9d6-3cf10e3fe22e | €35.00 | €0.50 | matched |
| 76 | capture | 01a18e7e-37b8-7543-9a24-c2e944dffa2c | €24.00 | €0.37 | matched |
| 77 | capture | 01a18e7e-44cb-7bab-82f1-f097accc29ab | €24.00 | €0.37 | matched |
| 78 | capture | 01a18e7e-839e-763c-a47b-cbb0b3505699 | €15.00 | €0.26 | matched |
| 79 | capture | 01a18e7e-8dc3-7dcd-8515-341ee5494eb4 | €49.00 | €0.67 | matched |
| 80 | capture | 01a18e7e-9fe9-75ae-85cb-fc00be2d6150 | €15.00 | €0.26 | matched |
| 81 | capture | 01a18e7e-c3b7-7021-b22b-51d9f88ba002 | €49.00 | €0.67 | matched |
| 82 | capture | 01a18e7e-c960-7a35-9f26-87cd2f71f044 | €49.00 | €0.67 | matched |
| 83 | capture | 01a18e7e-c988-7260-a221-e315606e2630 | €15.00 | €0.26 | matched |
| 84 | refund | 01a18e7e-d1d1-7dec-8c36-26257e5f6dcd | -€31.00 | €0.00 | matched |
| 86 | capture | 01a18e7e-e1bb-7361-a7b3-3551f72bbe7d | €15.00 | €0.26 | matched |
| 87 | capture | 01a18e7e-f940-7a1b-9276-ae33a7fb1e89 | €15.00 | €0.26 | matched |
| 88 | capture | 01a18e7f-11fb-79b5-8ea1-a5b8fab1a578 | €15.00 | €0.26 | matched |
| 89 | capture | 01a18e7f-1244-7d2b-ad43-057f777ae517 | €15.00 | €0.26 | matched |
| 90 | refund | 01a18e7f-21f3-714c-8d66-fd0aadebd77b | -€5.00 | €0.00 | matched |
| 91 | capture | 01a18e7f-8581-7471-8587-08ea7b456956 | €9.00 | €0.19 | matched |
| 92 | capture | 01a18e7f-88c6-787a-ae16-720266c3cc51 | €24.00 | €0.37 | matched |
| 93 | capture | 01a18e7f-a54a-7935-b974-038380ae5d0e | €35.00 | €0.50 | matched |
| 94 | capture | 01a18e7f-e190-7ce0-99e3-9c80659cbf16 | €49.00 | €0.67 | matched |
| 95 | capture | 01a18e7f-f5bb-77dc-b19a-aabf7202698f | €35.00 | €0.50 | matched |
| 96 | capture | 01a18e7f-ff3e-7d99-9f7b-ceb7924f79ea | €35.00 | €0.50 | matched |
| 97 | capture | 01a18e80-087b-789c-80a3-dd9f25b652db | €9.00 | €0.19 | matched |
| 99 | capture | 01a18e80-0c89-7847-98e6-e3a81339cea7 | €49.00 | €0.67 | matched |
| 100 | capture | 01a18e80-0ec4-7abc-906a-25d71ac44ddb | €15.00 | €0.26 | matched |
| 101 | capture | 01a18e80-4d77-710d-834f-d260a973ac53 | €49.00 | €0.67 | matched |
| 102 | capture | 01a18e80-6866-707e-8f40-9dd9f696fcfa | €9.00 | €0.19 | matched |
| 103 | capture | 01a18e80-7781-7ec5-8201-a321aaa17342 | €35.00 | €0.50 | matched |
| 104 | capture | 01a18e80-7bce-78c9-a3eb-3a973250bd9a | €9.00 | €0.19 | matched |
| 105 | capture | 01a18e80-97d3-7384-8a5d-560fd25925ec | €9.00 | €0.19 | matched |
| 106 | capture | 01a18e80-9ee7-7f87-a060-e97afd6b3fe5 | €35.00 | €0.50 | matched |
| 107 | capture | 01a18e80-b264-7d93-92b3-2b179a646609 | €35.00 | €0.50 | matched |
| 108 | capture | 01a18e80-b3d1-70ea-ab14-f57b663ebc5e | €24.00 | €0.37 | matched |
| 109 | capture | 01a18e80-b6cc-7b88-9369-60dde2fe790b | €24.00 | €0.37 | matched |
| 110 | capture | 01a18e80-c036-7c85-af83-25c9bfaa095d | €35.00 | €0.50 | matched |
| 111 | refund | 01a18e80-d040-750f-94bf-5ef08ab67abe | -€6.00 | €0.00 | matched |
| 112 | capture | 01a18e80-d652-7be6-afcd-ee85e0edf763 | €15.00 | €0.26 | matched |
| 113 | capture | 01a18e80-f188-7a41-9043-272901996398 | €35.00 | €0.50 | matched |
| 114 | capture | 01a18e80-f2a7-7c62-975c-c91c1a6b0cdb | €35.00 | €0.50 | matched |
| 115 | capture | 01a18e80-fcfe-7c9b-ba24-9f3924dda66e | €49.00 | €0.67 | matched |
| 116 | refund | 01a18e80-fe8a-7a40-9e68-381f268b3663 | -€15.00 | €0.00 | matched |
| 117 | capture | 01a18e81-0181-7a39-a08b-d538dec1991d | €15.00 | €0.26 | matched |
| 118 | capture | 01a18e81-060b-7478-a484-93d585356f41 | €24.00 | €0.37 | matched |
| 119 | capture | 01a18e81-07b1-7a28-a6fc-6331dca9e6fa | €49.00 | €0.67 | matched |
| 121 | capture | 01a18e81-1041-7c82-8406-4091397d3559 | €9.00 | €0.19 | matched |
| 122 | capture | 01a18e81-10ee-77bb-9db8-b3b853ef66e1 | €15.00 | €0.26 | matched |
| 123 | capture | 01a18e81-19cd-7aab-aa32-ae168c74e8f7 | €15.00 | €0.26 | matched |