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
- 23 Oct, 04:20111 linesclean
- 23 Oct, 04:10131 lines2 breaks
- 23 Oct, 04:00126 lines2 breaks
- 23 Oct, 03:50118 lines7 breaks
- 23 Oct, 03:40138 lines2 breaks
- 23 Oct, 03:30134 lines3 breaks
- 23 Oct, 03:20109 lines1 break
- 23 Oct, 03:10123 lines1 break
- 23 Oct, 03:00127 lines3 breaks
- 23 Oct, 02:50117 lines1 break
- 23 Oct, 02:40110 linesclean
- 23 Oct, 02:30156 lines3 breaks
- 23 Oct, 02:20129 lines2 breaks
- 23 Oct, 02:10129 lines2 breaks
23 Oct, 02:20
Gross
€3,141.00
PSP fee
€49.91
Net to the bank
€3,091.09
Settlement journal
#152347
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1668f-155c-7088-a937-2ace8418196d is already settled by stl_EUR_2987870 line 5
- missing linein the books, not in the filecapture:01a1668f-dfe3-7107-ba7e-1e29d45a8c13 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 6 | capture | 01a1668f-1589-72ec-8793-1463f8e1e230 | €9.00 | €0.19 | duplicate line |
| 1 | capture | 01a16687-e470-725f-9466-bfb97d23befa | €35.00 | €0.50 | matched |
| 2 | capture | 01a1668e-e786-712d-8545-b2d46323d427 | €35.00 | €0.50 | matched |
| 3 | capture | 01a1668e-f4a2-754a-90ad-648d812f466d | €24.00 | €0.37 | matched |
| 4 | capture | 01a1668e-f849-77da-8e7b-23f52d98050b | €24.00 | €0.37 | matched |
| 5 | capture | 01a1668f-1589-72ec-8793-1463f8e1e230 | €9.00 | €0.19 | matched |
| 7 | capture | 01a1668f-24cf-7c2a-ba6f-1958a165fa15 | €24.00 | €0.37 | matched |
| 8 | capture | 01a1668f-2e10-7743-921b-6d86c82464e6 | €15.00 | €0.26 | matched |
| 9 | capture | 01a1668f-311e-7a97-a85f-2b40265a5402 | €49.00 | €0.67 | matched |
| 10 | capture | 01a1668f-46fd-7d4b-b249-4fb549b3a92e | €15.00 | €0.26 | matched |
| 11 | capture | 01a1668f-56fc-7598-a4b8-0c4502fcfa32 | €49.00 | €0.67 | matched |
| 12 | capture | 01a1668f-8365-7e9b-936d-bd2d00d7f118 | €9.00 | €0.19 | matched |
| 13 | capture | 01a1668f-840a-7072-ab33-498457029544 | €35.00 | €0.50 | matched |
| 14 | capture | 01a1668f-8500-7599-8ed2-4f0aa5c6e197 | €35.00 | €0.50 | matched |
| 15 | capture | 01a1668f-8868-7381-bb9c-1834692fc15d | €49.00 | €0.67 | matched |
| 16 | capture | 01a1668f-9979-71bf-b60c-bb282717c9b0 | €24.00 | €0.37 | matched |
| 17 | capture | 01a1668f-c790-7eca-8b33-43260bb3b19a | €24.00 | €0.37 | matched |
| 18 | capture | 01a1668f-e682-7a9f-89d8-15732c2912c2 | €9.00 | €0.19 | matched |
| 19 | capture | 01a16690-0a4a-7dac-aea9-67e830d70221 | €49.00 | €0.67 | matched |
| 20 | capture | 01a16690-0b66-75ee-a1bb-14ad69b12b6b | €49.00 | €0.67 | matched |
| 21 | capture | 01a16690-0eb3-7799-932f-b3757e9e2205 | €15.00 | €0.26 | matched |
| 22 | capture | 01a16690-4cba-76a4-91cf-1bf0940da54a | €24.00 | €0.37 | matched |
| 23 | capture | 01a16690-696e-7609-805c-e9ba18ad7123 | €9.00 | €0.19 | matched |
| 24 | capture | 01a16690-8615-77f1-a12a-6ad26d368176 | €9.00 | €0.19 | matched |
| 25 | capture | 01a16690-9756-74ac-b41b-b1b39c5deb06 | €15.00 | €0.26 | matched |
| 26 | capture | 01a16690-99b0-7cf4-997c-58471b4b815d | €9.00 | €0.19 | matched |
| 27 | refund | 01a16690-c256-75eb-b3e7-b8e0cfdaeaa1 | -€2.00 | €0.00 | matched |
| 28 | refund | 01a16690-ce14-7733-938e-690fb6126f2c | -€23.00 | €0.00 | matched |
| 29 | capture | 01a16690-d8b2-7c1b-a6dd-ae321259dbe5 | €9.00 | €0.19 | matched |
| 30 | capture | 01a16690-d91b-7350-a597-48cb596b30c4 | €15.00 | €0.26 | matched |
| 31 | capture | 01a16691-0a90-7fef-b408-c7301406f1cf | €9.00 | €0.19 | matched |
| 32 | capture | 01a16691-0aa6-7897-a984-4b96d6ed1bff | €15.00 | €0.26 | matched |
| 33 | capture | 01a16691-1d56-71d3-b7f5-cc8f4640a83a | €9.00 | €0.19 | matched |
| 34 | capture | 01a16691-2d50-76b8-a984-93b2e9323697 | €35.00 | €0.50 | matched |
| 35 | capture | 01a16691-4066-7d0d-a565-78fe9a25282c | €9.00 | €0.19 | matched |
| 36 | capture | 01a16691-5045-7700-b005-e7760ce72c47 | €49.00 | €0.67 | matched |
| 37 | capture | 01a16691-7983-7e88-a842-d6674bd9939a | €49.00 | €0.67 | matched |
| 38 | refund | 01a16691-9b02-758d-a085-b81485029b85 | -€25.00 | €0.00 | matched |
| 39 | capture | 01a16691-b2a5-7613-95c6-791669459cdb | €35.00 | €0.50 | matched |
| 40 | capture | 01a16691-cce2-7485-b78b-6a6c87921da5 | €35.00 | €0.50 | matched |
| 41 | capture | 01a16692-0dd5-7778-a29e-095b82fd6afd | €15.00 | €0.26 | matched |
| 42 | capture | 01a16692-1cb6-71ef-8662-b1432f3f1c3a | €24.00 | €0.37 | matched |
| 43 | capture | 01a16692-3b83-78d1-8afa-ad9ffb90a62d | €49.00 | €0.67 | matched |
| 44 | capture | 01a16692-4956-7a25-86ac-4cf4a250518f | €49.00 | €0.67 | matched |
| 45 | capture | 01a16692-6a0a-7575-8e4f-e96a82d60d18 | €9.00 | €0.19 | matched |
| 46 | capture | 01a16692-726c-75c7-bc41-b9d7563d9d5c | €9.00 | €0.19 | matched |
| 47 | capture | 01a16692-889c-7a55-b29e-6a2a156b58f0 | €9.00 | €0.19 | matched |
| 48 | capture | 01a16692-9dbc-78ca-aca4-7867fa6f68b3 | €35.00 | €0.50 | matched |
| 49 | capture | 01a16692-a671-7a2b-a058-4f0304fb50c2 | €35.00 | €0.50 | matched |
| 50 | capture | 01a16692-ab75-707e-a28e-506312419b7d | €35.00 | €0.50 | matched |
| 51 | capture | 01a16692-b43c-7693-912d-84e952e3547e | €15.00 | €0.26 | matched |
| 52 | capture | 01a16692-be01-7cf0-a0a5-50309284d785 | €9.00 | €0.19 | matched |
| 53 | capture | 01a16692-d495-7285-965e-89b581ebd869 | €49.00 | €0.67 | matched |
| 54 | refund | 01a16692-e7d2-7325-a820-6ce2c09cd074 | -€18.00 | €0.00 | matched |
| 55 | capture | 01a16692-e885-797d-87a4-8dda6b4ec5db | €35.00 | €0.50 | matched |
| 56 | capture | 01a16693-16f9-7ec5-b9e9-ba75982df5bb | €24.00 | €0.37 | matched |
| 57 | capture | 01a16693-1ff0-76ce-aff0-286c636dad14 | €9.00 | €0.19 | matched |
| 58 | capture | 01a16693-4904-784b-95c3-8e844e5c2bff | €49.00 | €0.67 | matched |
| 59 | capture | 01a16693-52cb-7336-9351-4774917008dd | €24.00 | €0.37 | matched |
| 60 | capture | 01a16693-5657-7223-b0b6-81434a736cc4 | €49.00 | €0.67 | matched |
| 61 | capture | 01a16693-71a5-7085-ab21-1d6cecd2a9d9 | €9.00 | €0.19 | matched |
| 62 | capture | 01a16693-77bf-719d-9ae9-0208b128ce6e | €49.00 | €0.67 | matched |
| 63 | capture | 01a16693-85a5-7c2c-a1db-39a358d58d64 | €35.00 | €0.50 | matched |
| 64 | capture | 01a16693-8dba-7b32-ac15-13ae92e0dfd0 | €24.00 | €0.37 | matched |
| 65 | capture | 01a16693-b161-744b-b433-5b98e0c88048 | €9.00 | €0.19 | matched |
| 66 | capture | 01a16694-2027-723a-aa9d-2ab05c2cd1e7 | €9.00 | €0.19 | matched |
| 67 | capture | 01a16694-21cd-7148-8f9f-c0257a8f76c0 | €15.00 | €0.26 | matched |
| 68 | capture | 01a16694-27ab-7d17-ab1a-0d76e0306a6f | €24.00 | €0.37 | matched |
| 69 | capture | 01a16694-4cf5-7be5-a4fc-88784345d464 | €49.00 | €0.67 | matched |
| 70 | capture | 01a16694-5940-7723-bac3-5fe589b2acff | €49.00 | €0.67 | matched |
| 71 | capture | 01a16694-655d-7eeb-a999-6a03ca9f256b | €24.00 | €0.37 | matched |
| 72 | capture | 01a16694-8172-7e6a-bf73-cadc61a57c7c | €24.00 | €0.37 | matched |
| 73 | capture | 01a16694-8a8a-7823-850f-1e6be2b270b4 | €49.00 | €0.67 | matched |
| 74 | capture | 01a16694-8dfd-7a94-b515-48d5007cf249 | €49.00 | €0.67 | matched |
| 75 | capture | 01a16694-a1f4-7102-bab0-8e34a027a981 | €35.00 | €0.50 | matched |
| 76 | refund | 01a16694-ad3e-7d9f-b82d-ba060bfebd91 | -€9.00 | €0.00 | matched |
| 77 | capture | 01a16694-ad85-7927-b87e-13a273130098 | €15.00 | €0.26 | matched |
| 78 | capture | 01a16694-af1f-731b-9b9f-4681eaf0f4e4 | €9.00 | €0.19 | matched |
| 79 | capture | 01a16694-c085-7e2e-80e8-da5899fa206f | €15.00 | €0.26 | matched |
| 80 | capture | 01a16694-c704-7543-9b45-637fddec3eb2 | €24.00 | €0.37 | matched |
| 81 | capture | 01a16694-dad9-70bb-8516-4354625e80ad | €24.00 | €0.37 | matched |
| 82 | capture | 01a16694-e9aa-70fd-8706-c2b85b9b6a26 | €15.00 | €0.26 | matched |
| 83 | capture | 01a16694-f358-7635-ab20-08ca20a4d8c0 | €49.00 | €0.67 | matched |
| 84 | capture | 01a16694-fad3-7306-aaf3-ededaa66b7a5 | €15.00 | €0.26 | matched |
| 85 | capture | 01a16694-ff71-7389-90c1-eb6aec09ff20 | €15.00 | €0.26 | matched |
| 86 | capture | 01a16695-09e9-7b7a-a9b0-e9125a296eed | €49.00 | €0.67 | matched |
| 87 | capture | 01a16695-129d-7d69-8dba-7696a781ccb9 | €9.00 | €0.19 | matched |
| 88 | capture | 01a16695-1599-79af-9782-d8211f85b6f1 | €24.00 | €0.37 | matched |
| 89 | capture | 01a16695-2858-710e-b654-0e160b8fd7f9 | €15.00 | €0.26 | matched |
| 90 | capture | 01a16695-41a4-7d60-b54c-49a6d0d87d8c | €49.00 | €0.67 | matched |
| 91 | capture | 01a16695-4aa1-7b92-900e-788d826ed83e | €35.00 | €0.50 | matched |
| 92 | refund | 01a16695-54b1-76d5-8b63-c6c714462937 | -€29.00 | €0.00 | matched |
| 93 | capture | 01a16695-5939-7953-909c-62aa45b7308b | €49.00 | €0.67 | matched |
| 94 | capture | 01a16695-5db7-7fc9-ade8-2bdebec61561 | €24.00 | €0.37 | matched |
| 95 | capture | 01a16695-6ce5-7cc1-8514-902bc2ef29ef | €35.00 | €0.50 | matched |
| 96 | refund | 01a16695-6d24-7894-98a8-d2a86d3d4070 | -€44.00 | €0.00 | matched |
| 97 | capture | 01a16695-809b-7d36-b97d-ef161dce6565 | €35.00 | €0.50 | matched |
| 98 | capture | 01a16695-8749-71c1-b976-bb003ae717ad | €24.00 | €0.37 | matched |
| 99 | capture | 01a16695-9d02-784e-8fc9-5fd75c71a751 | €49.00 | €0.67 | matched |
| 100 | capture | 01a16695-b82a-7ea5-9df1-5a04bace68a2 | €9.00 | €0.19 | matched |
| 101 | capture | 01a16695-eabc-7ccf-9518-aab96005852a | €35.00 | €0.50 | matched |
| 102 | capture | 01a16695-fc41-70a4-a47f-76a9ae883425 | €49.00 | €0.67 | matched |
| 103 | capture | 01a16696-161b-7de0-95f7-db72133fc214 | €49.00 | €0.67 | matched |
| 104 | capture | 01a16696-1d81-7903-90ae-6b8a64137773 | €24.00 | €0.37 | matched |
| 105 | capture | 01a16696-38c0-7112-90f5-c79cc9336ca5 | €49.00 | €0.67 | matched |
| 106 | capture | 01a16696-66ec-7846-8abb-0d537957c3de | €49.00 | €0.67 | matched |
| 107 | capture | 01a16696-812f-7f97-afba-8c81ed0f62a7 | €35.00 | €0.50 | matched |
| 108 | capture | 01a16696-88a6-7d34-838a-1c0d9b2b2118 | €49.00 | €0.67 | matched |
| 109 | capture | 01a16696-d38f-72c8-9803-7ef4bacaabf5 | €15.00 | €0.26 | matched |
| 110 | capture | 01a16696-f3be-7fa7-a20c-e5da52577b31 | €24.00 | €0.37 | matched |
| 111 | capture | 01a16697-0193-7bf8-952a-430b9f23df69 | €24.00 | €0.37 | matched |
| 112 | capture | 01a16697-0357-72dc-a75d-33ca05441d87 | €15.00 | €0.26 | matched |
| 113 | capture | 01a16697-054c-7a38-8a4a-834a647d477d | €49.00 | €0.67 | matched |
| 114 | capture | 01a16697-1209-74fb-b285-11cced5d2ba5 | €49.00 | €0.67 | matched |
| 115 | capture | 01a16697-41b9-72cd-b3a7-0d0a6c0166b6 | €15.00 | €0.26 | matched |
| 116 | capture | 01a16697-476c-743e-9161-0c8a28cdbbe6 | €49.00 | €0.67 | matched |
| 117 | capture | 01a16697-5f3b-7642-8786-89f1f8f26f94 | €15.00 | €0.26 | matched |
| 118 | capture | 01a16697-5fd1-7e94-bb4e-d56583f0ab78 | €35.00 | €0.50 | matched |
| 119 | refund | 01a16697-631f-7539-8182-27d7b041087b | -€7.00 | €0.00 | matched |
| 120 | capture | 01a16697-7be2-7516-8997-42f636196337 | €49.00 | €0.67 | matched |
| 121 | capture | 01a16697-91e6-7a7a-b079-7791f4351be3 | €15.00 | €0.26 | matched |
| 122 | capture | 01a16697-951b-7ddf-8143-6b038caaf0d7 | €49.00 | €0.67 | matched |
| 123 | capture | 01a16697-96cc-7b9e-b102-74b97d3f9f02 | €24.00 | €0.37 | matched |
| 124 | capture | 01a16697-afd1-7313-80c2-b475925b536a | €24.00 | €0.37 | matched |
| 125 | capture | 01a16697-b2a9-7e7d-ac4f-819378bce0c4 | €15.00 | €0.26 | matched |
| 126 | refund | 01a16697-d727-752e-9fef-19d7deedbce7 | -€48.00 | €0.00 | matched |
| 127 | capture | 01a16697-d86f-763d-90c0-1565e16d73fd | €9.00 | €0.19 | matched |
| 128 | capture | 01a16697-fac9-7131-a51f-7c226e84d57e | €15.00 | €0.26 | matched |
| 129 | capture | 01a16697-ff9e-7c5c-a2a1-82ed27377ea3 | €24.00 | €0.37 | matched |