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: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, 19:00114 lines2 breaks
- 30 Oct, 18:50120 lines2 breaks
30 Oct, 20:10
Gross
€3,242.00
PSP fee
€51.17
Net to the bank
€3,190.83
Settlement journal
#293774
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18e6f-4e4d-79fa-a92c-3cd3596744e4 is already settled by stl_EUR_2988985 line 13
- duplicate linethe file lists it twicecapture:01a18e6f-6a82-7edd-b780-d0b13f90f578 is already settled by stl_EUR_2988985 line 16
- missing linein the books, not in the filecapture:01a18e75-9e68-7606-9c4a-e47784e76438 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 14 | capture | 01a18e6f-4e9c-750f-89d4-e0f9a8f83cb4 | €24.00 | €0.37 | duplicate line |
| 17 | capture | 01a18e6f-6afb-7c0b-848a-d710182541f9 | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a18e65-fcc6-79c2-ba0d-6289b5a584e6 | €9.00 | €0.19 | matched |
| 2 | capture | 01a18e66-36eb-71d9-a0c5-bde51965c9d0 | €49.00 | €0.67 | matched |
| 3 | capture | 01a18e67-0683-735a-8db3-31783b4b0e8a | €15.00 | €0.26 | matched |
| 4 | capture | 01a18e67-8399-78a0-b3d3-c8fcaf1477a6 | €24.00 | €0.37 | matched |
| 5 | capture | 01a18e6a-b206-7b51-b710-e6bdda18813d | €49.00 | €0.67 | matched |
| 6 | capture | 01a18e6b-7e23-7375-97d4-b519471b8b9f | €24.00 | €0.37 | matched |
| 7 | capture | 01a18e6b-9e08-7101-8821-39c0c5faaf47 | €35.00 | €0.50 | matched |
| 8 | capture | 01a18e6f-084e-7d0b-a99a-023ac4bda8ed | €49.00 | €0.67 | matched |
| 9 | capture | 01a18e6f-0878-726c-9077-681e7d8838d4 | €15.00 | €0.26 | matched |
| 10 | capture | 01a18e6f-2df0-76f8-95aa-a2e414b371fe | €15.00 | €0.26 | matched |
| 11 | capture | 01a18e6f-34c6-774e-9130-90f98b29d07b | €24.00 | €0.37 | matched |
| 12 | capture | 01a18e6f-47e0-70b8-b61e-380c0bad7570 | €35.00 | €0.50 | matched |
| 13 | capture | 01a18e6f-4e9c-750f-89d4-e0f9a8f83cb4 | €24.00 | €0.37 | matched |
| 15 | capture | 01a18e6f-67aa-79ee-8235-bd02b5f6793e | €49.00 | €0.67 | matched |
| 16 | capture | 01a18e6f-6afb-7c0b-848a-d710182541f9 | €35.00 | €0.50 | matched |
| 18 | capture | 01a18e6f-7624-716f-982a-aa24b71c212f | €9.00 | €0.19 | matched |
| 19 | capture | 01a18e6f-7847-7095-aa8d-a89675271723 | €49.00 | €0.67 | matched |
| 20 | capture | 01a18e6f-7969-74d3-89c7-a180cfdb95d1 | €24.00 | €0.37 | matched |
| 21 | capture | 01a18e6f-aa03-79d3-a7bf-65bfb6a39870 | €35.00 | €0.50 | matched |
| 22 | capture | 01a18e6f-d3bd-73e1-8e32-db6766401fbb | €35.00 | €0.50 | matched |
| 23 | capture | 01a18e6f-da97-74a3-9f2d-ce9527292dda | €35.00 | €0.50 | matched |
| 24 | capture | 01a18e6f-eb80-732c-8720-0d20b1035a32 | €24.00 | €0.37 | matched |
| 25 | capture | 01a18e6f-ed90-7be4-87b8-b098a9913cac | €35.00 | €0.50 | matched |
| 26 | capture | 01a18e6f-f6e6-7e1d-b321-2fa9d0cb4b7e | €35.00 | €0.50 | matched |
| 27 | capture | 01a18e6f-fa32-719c-9a38-6bd1f709db05 | €9.00 | €0.19 | matched |
| 28 | capture | 01a18e70-358d-7b6c-99a4-b6860046e10a | €24.00 | €0.37 | matched |
| 29 | capture | 01a18e70-4297-7073-b436-2246c6929029 | €9.00 | €0.19 | matched |
| 30 | refund | 01a18e70-4b19-711a-a218-45cbb1460e01 | -€7.00 | €0.00 | matched |
| 31 | capture | 01a18e70-61e4-756b-9166-16af33e48fdb | €35.00 | €0.50 | matched |
| 32 | capture | 01a18e70-74b4-7096-9666-861c5adc72b4 | €49.00 | €0.67 | matched |
| 33 | capture | 01a18e70-89be-7a94-9a2a-214ada291dcd | €24.00 | €0.37 | matched |
| 34 | refund | 01a18e70-a71d-720a-ab3c-cae82b3d7080 | -€20.00 | €0.00 | matched |
| 35 | capture | 01a18e70-acff-7435-9522-8805acd28b78 | €35.00 | €0.50 | matched |
| 36 | capture | 01a18e70-afe8-77d3-9bb4-5b7c836f3d0d | €49.00 | €0.67 | matched |
| 37 | capture | 01a18e70-e664-759d-a6fd-13b96a6ff2e8 | €35.00 | €0.50 | matched |
| 38 | capture | 01a18e71-22bc-7c7f-a304-2df207518e62 | €24.00 | €0.37 | matched |
| 39 | capture | 01a18e71-7d5b-78d2-b4f7-7fa8ff8a267e | €24.00 | €0.37 | matched |
| 40 | capture | 01a18e71-8f44-74a7-9677-143d395a166b | €15.00 | €0.26 | matched |
| 41 | capture | 01a18e71-90b5-7872-882d-e074f632197b | €9.00 | €0.19 | matched |
| 42 | capture | 01a18e71-9b77-7a21-8fcb-75501540eb3a | €9.00 | €0.19 | matched |
| 43 | capture | 01a18e71-bb52-74f1-9eb0-eb2f0b97b610 | €15.00 | €0.26 | matched |
| 44 | capture | 01a18e71-d418-7a85-99d9-5995ea0284b8 | €35.00 | €0.50 | matched |
| 45 | capture | 01a18e71-d463-7199-9a6e-06477de691b9 | €35.00 | €0.50 | matched |
| 46 | capture | 01a18e71-e1d0-704d-88aa-568ccc60717e | €15.00 | €0.26 | matched |
| 47 | capture | 01a18e71-e4f2-72ae-800b-24118cdbf205 | €15.00 | €0.26 | matched |
| 48 | refund | 01a18e71-eadf-7a15-927e-a025d11ff032 | -€3.00 | €0.00 | matched |
| 49 | capture | 01a18e72-0f22-778c-ac62-14e46204a07f | €24.00 | €0.37 | matched |
| 50 | capture | 01a18e72-1fa1-75b4-a2aa-87e3f4645c11 | €35.00 | €0.50 | matched |
| 51 | capture | 01a18e72-2219-7d76-8a17-47d360c13bac | €24.00 | €0.37 | matched |
| 52 | capture | 01a18e72-3738-7108-bc7a-f7db8aff37ab | €49.00 | €0.67 | matched |
| 53 | capture | 01a18e72-3778-7bfb-bddc-684e7b3dcddb | €15.00 | €0.26 | matched |
| 54 | capture | 01a18e72-3298-7a5b-a876-eb7cc6e3eecb | €9.00 | €0.19 | matched |
| 55 | capture | 01a18e72-3d33-774f-a1c4-341748ffa2e9 | €15.00 | €0.26 | matched |
| 56 | refund | 01a18e72-4500-7fc9-bff3-eafc8c64f289 | -€10.00 | €0.00 | matched |
| 57 | capture | 01a18e72-5438-7174-84a0-a1f41e52f462 | €49.00 | €0.67 | matched |
| 58 | capture | 01a18e72-6141-729d-83b7-61e8b193e650 | €15.00 | €0.26 | matched |
| 59 | capture | 01a18e72-75b6-7fdc-93b4-6e2f3578c77d | €49.00 | €0.67 | matched |
| 60 | refund | 01a18e72-7db4-7e98-9eb0-d4a110274bb0 | -€2.00 | €0.00 | matched |
| 61 | capture | 01a18e72-88be-77b7-82a9-409c61187511 | €35.00 | €0.50 | matched |
| 62 | capture | 01a18e72-88e4-7673-a642-434202759ad0 | €15.00 | €0.26 | matched |
| 63 | capture | 01a18e72-c9f2-73be-9838-27dc136e4d13 | €35.00 | €0.50 | matched |
| 64 | capture | 01a18e72-f49e-74dd-9a67-17d14ef1df1f | €9.00 | €0.19 | matched |
| 65 | capture | 01a18e72-fbc7-73cb-a607-f54f15298103 | €9.00 | €0.19 | matched |
| 66 | capture | 01a18e73-0435-7786-bbc6-fcb8a3aa5a76 | €35.00 | €0.50 | matched |
| 67 | capture | 01a18e73-29e5-79e0-a479-b243302b607b | €15.00 | €0.26 | matched |
| 68 | capture | 01a18e73-36a9-7a55-9a3b-22fed11dfb8a | €35.00 | €0.50 | matched |
| 69 | capture | 01a18e73-3775-781d-a1a0-0a5ad4d2029e | €24.00 | €0.37 | matched |
| 70 | capture | 01a18e73-4317-7f22-85fc-e564023faf90 | €24.00 | €0.37 | matched |
| 71 | capture | 01a18e73-63a0-7512-a206-0eef1db42c48 | €49.00 | €0.67 | matched |
| 72 | capture | 01a18e73-7173-791d-81d1-4ed0fef78bea | €15.00 | €0.26 | matched |
| 73 | capture | 01a18e73-99bc-7653-af87-f588229b5f77 | €49.00 | €0.67 | matched |
| 74 | capture | 01a18e73-a2ec-72a8-8a1c-8e6ac6e086ef | €15.00 | €0.26 | matched |
| 75 | refund | 01a18e73-a790-787f-84d6-fe0df4d3e4da | -€17.00 | €0.00 | matched |
| 76 | capture | 01a18e73-bc7f-752d-aa8b-e76780662333 | €24.00 | €0.37 | matched |
| 77 | capture | 01a18e73-bf6e-7f90-a599-8815f637bd6d | €35.00 | €0.50 | matched |
| 78 | capture | 01a18e73-cd1b-7022-8699-930796e05436 | €49.00 | €0.67 | matched |
| 79 | refund | 01a18e73-eb36-7231-8314-03399a375940 | -€15.00 | €0.00 | matched |
| 80 | capture | 01a18e73-f66c-7c5b-b233-b6cf70ad3081 | €15.00 | €0.26 | matched |
| 81 | capture | 01a18e74-0243-74a0-ac04-d21aec7bef18 | €49.00 | €0.67 | matched |
| 82 | capture | 01a18e74-1835-7c36-b726-e862a852690f | €15.00 | €0.26 | matched |
| 83 | capture | 01a18e74-2dc6-7fc9-bc83-bc903348e45f | €24.00 | €0.37 | matched |
| 84 | refund | 01a18e74-3375-75b6-b06b-24b037c61e71 | -€22.00 | €0.00 | matched |
| 85 | capture | 01a18e74-40f0-794a-9ea7-8ab232484760 | €9.00 | €0.19 | matched |
| 86 | capture | 01a18e74-4e4d-75af-9702-79b8e5de4f03 | €35.00 | €0.50 | matched |
| 87 | capture | 01a18e74-4f7f-71ef-9582-f64a6456c307 | €9.00 | €0.19 | matched |
| 88 | capture | 01a18e74-73ee-705b-a294-5669f86fb16c | €24.00 | €0.37 | matched |
| 89 | capture | 01a18e74-748c-7c2b-a31f-ea8f3fc86d1f | €24.00 | €0.37 | matched |
| 90 | capture | 01a18e74-790f-7eb8-a424-00f076648e7a | €35.00 | €0.50 | matched |
| 91 | capture | 01a18e74-7ff9-7642-bb6d-de4b5c2488e9 | €35.00 | €0.50 | matched |
| 92 | refund | 01a18e74-8c2c-7df8-b8dd-eb426d068a48 | -€18.00 | €0.00 | matched |
| 93 | capture | 01a18e74-a71d-7050-b9ff-6520987977a2 | €35.00 | €0.50 | matched |
| 94 | refund | 01a18e74-ae7a-76c6-b200-c91b9baf1412 | -€26.00 | €0.00 | matched |
| 95 | capture | 01a18e74-c6bf-7c2c-9cf9-29f4f7334681 | €35.00 | €0.50 | matched |
| 96 | capture | 01a18e74-c8c3-74bd-9e92-f25d08db0070 | €35.00 | €0.50 | matched |
| 97 | capture | 01a18e74-d63e-7b5f-93d5-eea19a675bfd | €35.00 | €0.50 | matched |
| 98 | capture | 01a18e74-e2b1-702a-8357-3fadc8fe3605 | €24.00 | €0.37 | matched |
| 99 | refund | 01a18e74-f3cb-7a2b-bc9f-454395475478 | -€24.00 | €0.00 | matched |
| 100 | capture | 01a18e75-0e69-73f7-a36d-8fa34a34d66c | €15.00 | €0.26 | matched |
| 101 | capture | 01a18e75-a4e3-7ff2-98a7-416e2c1c3e14 | €24.00 | €0.37 | matched |
| 102 | capture | 01a18e75-bcc8-7f00-a121-b6a94dbadc1a | €24.00 | €0.37 | matched |
| 103 | capture | 01a18e75-d11a-7db8-b559-5e2641a2c213 | €49.00 | €0.67 | matched |
| 104 | capture | 01a18e75-d4f0-7d02-9a58-2bfa65353acf | €9.00 | €0.19 | matched |
| 105 | capture | 01a18e75-d8ea-7e29-b4c8-fa3056b0a201 | €49.00 | €0.67 | matched |
| 106 | capture | 01a18e75-d969-7e26-b7c8-d6c8f2ed56d6 | €15.00 | €0.26 | matched |
| 107 | capture | 01a18e75-fc9b-74a5-8710-78ad68082fc2 | €15.00 | €0.26 | matched |
| 108 | capture | 01a18e76-004d-7704-a28e-db35b291b2eb | €49.00 | €0.67 | matched |
| 109 | capture | 01a18e76-20cb-7aa6-9e0b-45cc0f695a0d | €9.00 | €0.19 | matched |
| 110 | capture | 01a18e76-6cc1-7566-add7-38f3705a6d47 | €49.00 | €0.67 | matched |
| 111 | capture | 01a18e76-8199-732c-b370-514408e4a236 | €15.00 | €0.26 | matched |
| 112 | capture | 01a18e76-99f2-7774-9985-44723d018c01 | €35.00 | €0.50 | matched |
| 113 | capture | 01a18e76-a1f8-7658-9bd1-57ca899d7426 | €49.00 | €0.67 | matched |
| 114 | capture | 01a18e76-aebc-7d7f-9e54-3c61c8e4b5b6 | €35.00 | €0.50 | matched |
| 115 | capture | 01a18e76-caae-78a5-b3b2-16d08e223fe2 | €24.00 | €0.37 | matched |
| 116 | capture | 01a18e76-d1d8-77aa-af1a-2444409d04f0 | €9.00 | €0.19 | matched |
| 117 | capture | 01a18e76-ec22-7616-ab5e-cde0df861178 | €15.00 | €0.26 | matched |
| 118 | capture | 01a18e76-f1f3-7b7b-964e-05ed063b764f | €35.00 | €0.50 | matched |
| 119 | capture | 01a18e77-1823-7876-a6c6-43310a742727 | €35.00 | €0.50 | matched |
| 120 | capture | 01a18e77-20f9-7847-a44b-b4a71fc50961 | €24.00 | €0.37 | matched |
| 121 | capture | 01a18e77-2691-7f73-bcdb-048d15ac3c34 | €9.00 | €0.19 | matched |
| 122 | capture | 01a18e77-4f9c-7660-9d45-5df66766b580 | €24.00 | €0.37 | matched |
| 123 | capture | 01a18e77-5fcf-791b-8d89-0cb6d9c96d98 | €49.00 | €0.67 | matched |
| 124 | capture | 01a18e77-70cd-7f05-af9c-d75adfb43688 | €15.00 | €0.26 | matched |
| 125 | capture | 01a18e77-835b-7047-bd7e-69d6e821eee7 | €35.00 | €0.50 | matched |
| 126 | capture | 01a18e77-a011-7133-b936-584a4339c62e | €24.00 | €0.37 | matched |
| 127 | capture | 01a18e77-b18e-73d5-977a-5399d79eee86 | €24.00 | €0.37 | matched |
| 128 | capture | 01a18e77-c7cb-7cc0-9d7c-743567384455 | €9.00 | €0.19 | matched |
| 129 | capture | 01a18e77-c85c-70a6-80ad-535c877866ef | €35.00 | €0.50 | matched |
| 130 | capture | 01a18e77-c193-7e68-a752-2ea73a2e3111 | €35.00 | €0.50 | matched |
| 131 | capture | 01a18e77-d893-7981-ad7e-5de30b99456d | €9.00 | €0.19 | matched |
| 132 | capture | 01a18e77-f7a5-7c46-8f0b-06de277d31ef | €15.00 | €0.26 | matched |
| 133 | capture | 01a18e77-f8e3-707c-8f5d-6ff09f7f5211 | €9.00 | €0.19 | matched |
| 134 | capture | 01a18e77-fafa-7132-8887-6d9fd350e7ae | €9.00 | €0.19 | matched |
| 135 | capture | 01a18e78-037f-7152-bcd2-89df78222791 | €15.00 | €0.26 | matched |
| 136 | capture | 01a18e78-04af-7736-a3ed-16a158f0e93c | €24.00 | €0.37 | matched |
| 137 | capture | 01a18e78-0ff0-72da-a047-89547a7ed847 | €24.00 | €0.37 | matched |
| 138 | capture | 01a18e78-1689-7a6c-a182-ef51ba0acf3e | €9.00 | €0.19 | matched |