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
- 17 Oct, 16:0090 lines1 break
- 17 Oct, 15:50124 lines1 break
- 17 Oct, 15:40147 lines2 breaks
- 17 Oct, 15:30119 linesclean
- 17 Oct, 15:20117 linesclean
- 17 Oct, 15:10116 lines1 break
- 17 Oct, 15:00120 lines3 breaks
- 17 Oct, 14:5094 lines2 breaks
- 17 Oct, 14:40129 linesclean
- 17 Oct, 14:30110 lines2 breaks
- 17 Oct, 14:20110 lines3 breaks
- 17 Oct, 14:10112 lines1 break
- 17 Oct, 14:00136 lines1 break
- 17 Oct, 13:50120 lines2 breaks
17 Oct, 15:00
Gross
€2,919.00
PSP fee
€46.09
Net to the bank
€2,872.91
Settlement journal
#53105
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14a64-89a4-73b4-b84a-89ce61faa079 is already settled by stl_EUR_2987082 line 57
- duplicate linethe file lists it twicecapture:01a14a68-794b-7ade-9947-b6e66897cba8 is already settled by stl_EUR_2987082 line 110
- missing linein the books, not in the filecapture:01a14a64-315e-7d94-9865-4e0688a66956 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 58 | capture | 01a14a64-8a39-7314-a7c0-306abb83168b | €24.00 | €0.37 | duplicate line |
| 111 | capture | 01a14a68-902c-77ca-b625-b309655cfa55 | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a14a5c-1f66-7708-b315-edf88a9ddc0d | €15.00 | €0.26 | matched |
| 2 | capture | 01a14a5f-71c2-76b7-bbd9-43bcd092e274 | €49.00 | €0.67 | matched |
| 3 | capture | 01a14a5f-ac99-7055-ae98-25363aed7e74 | €49.00 | €0.67 | matched |
| 4 | capture | 01a14a60-834e-716d-b340-4cf239415d77 | €49.00 | €0.67 | matched |
| 5 | capture | 01a14a60-86c3-7958-845b-62db3978ce38 | €9.00 | €0.19 | matched |
| 6 | refund | 01a14a60-8a7f-74c5-9e11-c35df2f14408 | -€29.00 | €0.00 | matched |
| 7 | capture | 01a14a60-c369-725c-a3c0-7bd2b531ad7d | €35.00 | €0.50 | matched |
| 8 | capture | 01a14a60-cbf9-777a-89cb-f85837d6d14d | €15.00 | €0.26 | matched |
| 9 | capture | 01a14a60-cbf3-767e-b12e-83aec2d67b7b | €49.00 | €0.67 | matched |
| 10 | capture | 01a14a60-d14e-71a0-b24b-ed13fbb4a617 | €9.00 | €0.19 | matched |
| 11 | capture | 01a14a60-d708-7152-839b-a8bb2d424abe | €15.00 | €0.26 | matched |
| 12 | capture | 01a14a60-eba6-73d7-bde0-7df0c87a476e | €49.00 | €0.67 | matched |
| 13 | capture | 01a14a60-ec2a-7874-bcbb-6b94fa668e7e | €35.00 | €0.50 | matched |
| 14 | capture | 01a14a61-1791-77eb-8446-5dd7d226a219 | €24.00 | €0.37 | matched |
| 15 | capture | 01a14a61-326b-7666-9b17-1ce9ecbb78b2 | €24.00 | €0.37 | matched |
| 16 | capture | 01a14a61-722c-727d-8306-f6cd4f68e752 | €49.00 | €0.67 | matched |
| 17 | capture | 01a14a61-9608-7ce7-9e04-011e5025800d | €9.00 | €0.19 | matched |
| 18 | capture | 01a14a61-9a80-7b13-9583-f96110552821 | €15.00 | €0.26 | matched |
| 19 | capture | 01a14a61-8866-7f97-a7b9-ce0377836186 | €9.00 | €0.19 | matched |
| 20 | capture | 01a14a61-e23e-7250-8959-48e46c5d2cad | €35.00 | €0.50 | matched |
| 21 | capture | 01a14a61-ed68-72ef-946c-825653930161 | €35.00 | €0.50 | matched |
| 22 | refund | 01a14a61-fff4-73fa-bb1f-6334befb6c9d | -€7.00 | €0.00 | matched |
| 23 | capture | 01a14a62-097e-7b40-a7df-3638eea76ea1 | €24.00 | €0.37 | matched |
| 24 | capture | 01a14a62-18a5-73fc-8d71-ddb6e499bf21 | €49.00 | €0.67 | matched |
| 25 | capture | 01a14a62-1995-71ed-bad9-4ffe8da67387 | €49.00 | €0.67 | matched |
| 26 | capture | 01a14a62-406b-73a1-8d61-a54c013c936c | €49.00 | €0.67 | matched |
| 27 | capture | 01a14a62-4efd-78fb-9a39-59bf88bc15c2 | €15.00 | €0.26 | matched |
| 28 | capture | 01a14a62-7d9c-7797-8ef3-d440c0c72559 | €35.00 | €0.50 | matched |
| 29 | capture | 01a14a62-8f3b-727d-bcac-383d764ac0af | €24.00 | €0.37 | matched |
| 30 | capture | 01a14a62-a335-702f-9db2-e7de84323586 | €24.00 | €0.37 | matched |
| 31 | capture | 01a14a62-dd0f-718f-baec-2407195e908a | €24.00 | €0.37 | matched |
| 32 | refund | 01a14a62-efa0-71e2-aad7-c1f388c025e2 | -€35.00 | €0.00 | matched |
| 33 | capture | 01a14a62-fad2-7d95-ac99-86e236bcc835 | €49.00 | €0.67 | matched |
| 34 | capture | 01a14a63-0826-7dd1-a056-c41affff3df5 | €24.00 | €0.37 | matched |
| 35 | capture | 01a14a63-2915-7211-a964-cdc7949fdbcb | €15.00 | €0.26 | matched |
| 36 | capture | 01a14a63-3a02-7923-870b-5ffdbc8fe16c | €15.00 | €0.26 | matched |
| 37 | capture | 01a14a63-40d4-70d3-9113-3cd3282022df | €15.00 | €0.26 | matched |
| 38 | capture | 01a14a63-4bb1-7fb4-82c8-216051d16ed3 | €9.00 | €0.19 | matched |
| 39 | capture | 01a14a63-4ec2-758b-95c5-5537d4db9113 | €35.00 | €0.50 | matched |
| 40 | capture | 01a14a63-717b-7419-ab46-a251e7f262ab | €15.00 | €0.26 | matched |
| 41 | capture | 01a14a63-8a85-70a6-8a1e-97c6cbde38c4 | €15.00 | €0.26 | matched |
| 42 | capture | 01a14a63-8ab1-7b07-a4d4-624af5bacd59 | €9.00 | €0.19 | matched |
| 43 | capture | 01a14a63-a16f-7d6c-8bc0-81c912bb3728 | €35.00 | €0.50 | matched |
| 44 | capture | 01a14a63-c72b-738e-9202-93894da6861e | €24.00 | €0.37 | matched |
| 45 | capture | 01a14a63-ca2c-775a-932d-bd688b6d9ca3 | €15.00 | €0.26 | matched |
| 46 | capture | 01a14a63-d703-790e-8d1b-d4c23d78aa1d | €24.00 | €0.37 | matched |
| 47 | capture | 01a14a63-e16a-7dea-a55a-a3aae4ee17be | €15.00 | €0.26 | matched |
| 48 | capture | 01a14a63-e43b-7778-a881-655337e6c85e | €9.00 | €0.19 | matched |
| 49 | capture | 01a14a63-edae-7212-89a9-a5da963d3076 | €35.00 | €0.50 | matched |
| 50 | capture | 01a14a64-282e-7630-b36c-a12c11b88981 | €49.00 | €0.67 | matched |
| 51 | refund | 01a14a64-2aba-7846-ab04-bfb75112b2ca | -€21.00 | €0.00 | matched |
| 52 | capture | 01a14a64-3bda-7539-84a4-68fc094ea608 | €35.00 | €0.50 | matched |
| 53 | capture | 01a14a64-4d00-7157-bc73-29d66416312f | €24.00 | €0.37 | matched |
| 54 | capture | 01a14a64-52bf-708e-8bdb-212157f2a2aa | €24.00 | €0.37 | matched |
| 55 | capture | 01a14a64-5ba7-7559-9cf6-3ac2c1599c6e | €15.00 | €0.26 | matched |
| 56 | capture | 01a14a64-7aca-7737-ab62-ec0c4b89d85d | €9.00 | €0.19 | matched |
| 57 | capture | 01a14a64-8a39-7314-a7c0-306abb83168b | €24.00 | €0.37 | matched |
| 59 | capture | 01a14a64-9698-73db-81a5-f21ee7d8b5c7 | €35.00 | €0.50 | matched |
| 60 | capture | 01a14a64-97a8-7eba-861a-d9e2e38113d5 | €49.00 | €0.67 | matched |
| 61 | capture | 01a14a64-c485-7859-834c-bdf29aa7966d | €49.00 | €0.67 | matched |
| 62 | refund | 01a14a64-e14e-7af9-986d-499984d81962 | -€6.00 | €0.00 | matched |
| 63 | capture | 01a14a65-047b-73de-b6c2-3f0ae077c298 | €15.00 | €0.26 | matched |
| 64 | capture | 01a14a65-0bbf-7f3d-ab3b-f84c69bd6979 | €49.00 | €0.67 | matched |
| 65 | capture | 01a14a65-131d-7ff4-ac4f-c8c89572bd7b | €9.00 | €0.19 | matched |
| 66 | capture | 01a14a65-1aa7-7369-a96c-dff0fb38c8dd | €15.00 | €0.26 | matched |
| 67 | capture | 01a14a65-3048-7071-8330-910c8bfe9d95 | €35.00 | €0.50 | matched |
| 68 | capture | 01a14a65-3154-7d19-a1e4-8fe85cbba674 | €49.00 | €0.67 | matched |
| 69 | capture | 01a14a65-365a-7859-b338-8badbc177c4c | €9.00 | €0.19 | matched |
| 70 | capture | 01a14a65-46af-76e7-825f-38f4ec9fc86a | €9.00 | €0.19 | matched |
| 71 | capture | 01a14a65-4b2b-7018-93b0-01fab280ae9a | €49.00 | €0.67 | matched |
| 72 | capture | 01a14a65-50d9-740e-baa2-214566020c6f | €24.00 | €0.37 | matched |
| 73 | capture | 01a14a65-5624-7903-91e3-546826ac860d | €24.00 | €0.37 | matched |
| 74 | capture | 01a14a65-7485-7dd1-b8e5-3e5b5948c189 | €24.00 | €0.37 | matched |
| 75 | refund | 01a14a65-793f-7042-80e3-35919c2407e0 | -€40.00 | €0.00 | matched |
| 76 | capture | 01a14a65-8e43-72bc-8aac-42ca27686c8f | €49.00 | €0.67 | matched |
| 77 | capture | 01a14a65-a48d-77e3-a35d-ec2f8b821cc9 | €24.00 | €0.37 | matched |
| 78 | capture | 01a14a65-b863-7cb9-b696-48ecc1eae49c | €15.00 | €0.26 | matched |
| 79 | capture | 01a14a65-c3df-78b7-8994-2c110798b59e | €24.00 | €0.37 | matched |
| 80 | capture | 01a14a65-d902-744e-9a36-5b9f2da23c84 | €15.00 | €0.26 | matched |
| 81 | capture | 01a14a65-e4c9-7fcf-97cd-a61e8e38b3b9 | €35.00 | €0.50 | matched |
| 82 | capture | 01a14a65-fa0c-7768-be03-5794e99b77bb | €9.00 | €0.19 | matched |
| 83 | refund | 01a14a66-1852-7e9f-8a98-a842350b5f23 | -€13.00 | €0.00 | matched |
| 84 | capture | 01a14a66-1f43-7e1c-82d2-7113f9283cfc | €35.00 | €0.50 | matched |
| 85 | capture | 01a14a66-2a92-79ae-a351-233ffdb0f6cf | €49.00 | €0.67 | matched |
| 86 | capture | 01a14a66-45f7-724e-8194-0b836128ee58 | €24.00 | €0.37 | matched |
| 87 | capture | 01a14a66-4d59-7533-9606-87714bd1d6cd | €24.00 | €0.37 | matched |
| 88 | capture | 01a14a66-523e-74c3-b42b-7638aec83b46 | €49.00 | €0.67 | matched |
| 89 | capture | 01a14a66-68e9-74f4-8d69-3cab3006870e | €15.00 | €0.26 | matched |
| 90 | capture | 01a14a66-86ac-7962-9719-0789f39e62fd | €9.00 | €0.19 | matched |
| 91 | capture | 01a14a66-8708-75fb-8cb9-e0150978cfc5 | €49.00 | €0.67 | matched |
| 92 | capture | 01a14a66-ef61-78a3-8eeb-f46cc3ab4378 | €49.00 | €0.67 | matched |
| 93 | capture | 01a14a66-f9da-7faf-848a-c28869df9371 | €35.00 | €0.50 | matched |
| 94 | capture | 01a14a66-faab-75c0-b6d8-45d9ce459e02 | €49.00 | €0.67 | matched |
| 95 | capture | 01a14a67-5703-70f7-8a39-facbb5e5c695 | €49.00 | €0.67 | matched |
| 96 | capture | 01a14a67-69f2-75ab-9e98-23f7a132130e | €35.00 | €0.50 | matched |
| 97 | capture | 01a14a67-7e43-73ac-9d09-674cd08baaae | €24.00 | €0.37 | matched |
| 98 | capture | 01a14a67-946f-7d93-9e4a-7868f13fc959 | €49.00 | €0.67 | matched |
| 99 | capture | 01a14a67-a8e7-711e-8793-2b8e67ff6501 | €15.00 | €0.26 | matched |
| 100 | capture | 01a14a67-ccf0-76e1-9eab-84d36582eb09 | €49.00 | €0.67 | matched |
| 101 | capture | 01a14a67-ede2-7b41-a191-a1d014073162 | €9.00 | €0.19 | matched |
| 102 | capture | 01a14a68-0eb1-7cf1-a43e-d770f5f472fa | €24.00 | €0.37 | matched |
| 103 | refund | 01a14a68-16f2-70fa-bb45-84c8dfa678ea | -€12.00 | €0.00 | matched |
| 104 | capture | 01a14a68-18ed-7aba-94a4-b48aa323cd51 | €15.00 | €0.26 | matched |
| 105 | capture | 01a14a68-231a-7e00-a36a-8ff82bec82d5 | €15.00 | €0.26 | matched |
| 106 | capture | 01a14a68-27fa-7fd3-905c-b9eb8048e5b4 | €24.00 | €0.37 | matched |
| 107 | capture | 01a14a68-3ff7-7df2-a0e7-71bd291104bb | €9.00 | €0.19 | matched |
| 108 | capture | 01a14a68-41e2-744b-97fb-3b9cabf2a4f0 | €24.00 | €0.37 | matched |
| 109 | capture | 01a14a68-6277-7c95-a544-b507709a0e8d | €49.00 | €0.67 | matched |
| 110 | capture | 01a14a68-902c-77ca-b625-b309655cfa55 | €24.00 | €0.37 | matched |
| 112 | capture | 01a14a68-fb39-7900-a15d-9b24da57eb04 | €35.00 | €0.50 | matched |
| 113 | capture | 01a14a69-006d-7d5c-a4f7-5e4327808e67 | €9.00 | €0.19 | matched |
| 114 | capture | 01a14a69-2e9d-7508-acf8-908c0dd0e941 | €49.00 | €0.67 | matched |
| 115 | capture | 01a14a69-31f0-7447-a24d-82065d82fb1a | €15.00 | €0.26 | matched |
| 116 | capture | 01a14a69-4894-7e12-a997-d15b9f33ddc9 | €9.00 | €0.19 | matched |
| 117 | capture | 01a14a69-4a92-7fb7-9d15-1c4af8a71339 | €24.00 | €0.37 | matched |
| 118 | capture | 01a14a69-60f5-7823-902e-ae9aeda71a57 | €9.00 | €0.19 | matched |
| 119 | capture | 01a14a69-77d2-7633-8d4b-b0b667c2c79e | €24.00 | €0.37 | matched |
| 120 | capture | 01a14a69-8e40-7c52-94bc-15d0ac13ebe3 | €35.00 | €0.50 | matched |