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, 22:20109 linesclean
- 15 Oct, 22:10139 lines2 breaks
- 15 Oct, 22:00130 lines3 breaks
- 15 Oct, 21:50134 lines1 break
- 15 Oct, 21:40132 lines2 breaks
- 15 Oct, 21:30125 lines2 breaks
- 15 Oct, 21:20129 lines2 breaks
- 15 Oct, 21:10118 lines2 breaks
- 15 Oct, 21:00138 lines2 breaks
- 15 Oct, 20:50128 lines1 break
- 15 Oct, 20:40107 lines4 breaks
- 15 Oct, 20:30142 lines1 break
- 15 Oct, 20:20134 lines3 breaks
- 15 Oct, 20:10122 lines5 breaks
15 Oct, 21:00
Gross
€3,156.00
PSP fee
€49.90
Net to the bank
€3,106.10
Settlement journal
#21247
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1415d-7c5a-7544-95eb-1a59b81b357b is already settled by stl_EUR_2986830 line 8
- missing linein the books, not in the filecapture:01a14164-fe28-79f4-9ccb-a5304f2ba36f is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 9 | capture | 01a1415d-7cdc-768c-99c6-e633a10f5d4c | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a14154-e793-7b34-bdfc-98e14d60373c | €49.00 | €0.67 | matched |
| 2 | capture | 01a14156-b213-7cc2-9302-3cc04db374f0 | €9.00 | €0.19 | matched |
| 3 | capture | 01a14156-ff62-7e85-a36f-bf45c5421308 | €9.00 | €0.19 | matched |
| 4 | capture | 01a14158-dbc0-76d5-b950-af3eec4f158d | €15.00 | €0.26 | matched |
| 5 | capture | 01a1415d-5eed-7d07-b951-12a66e9a6d44 | €15.00 | €0.26 | matched |
| 6 | capture | 01a1415d-6e8b-7edf-ad92-a4ceeba5f6bd | €15.00 | €0.26 | matched |
| 7 | capture | 01a1415d-732f-74b2-9508-910e4f9ff62b | €35.00 | €0.50 | matched |
| 8 | capture | 01a1415d-7cdc-768c-99c6-e633a10f5d4c | €24.00 | €0.37 | matched |
| 10 | capture | 01a1415d-8f11-7e14-9119-79a3bd0e8825 | €15.00 | €0.26 | matched |
| 11 | capture | 01a1415d-a3d0-78c3-af2e-59db83d4fffc | €15.00 | €0.26 | matched |
| 12 | capture | 01a1415d-a6a9-7dbb-9911-1f47a22292fa | €15.00 | €0.26 | matched |
| 13 | capture | 01a1415d-ba23-7f44-84e1-cae846946bc9 | €49.00 | €0.67 | matched |
| 14 | refund | 01a1415d-bb3a-7c49-9484-6f43a00090eb | -€21.00 | €0.00 | matched |
| 15 | refund | 01a1415d-c1c9-7485-b2b8-1c92325f6fd4 | -€5.00 | €0.00 | matched |
| 16 | capture | 01a1415d-c2f3-76eb-8ff7-a1a64f213562 | €35.00 | €0.50 | matched |
| 17 | capture | 01a1415d-c50d-726b-8b26-3ebe2875a794 | €35.00 | €0.50 | matched |
| 18 | capture | 01a1415d-c88e-78fe-a365-dcdc770abf5a | €49.00 | €0.67 | matched |
| 19 | refund | 01a1415d-c88a-7e20-b5f2-795630defd44 | -€14.00 | €0.00 | matched |
| 20 | capture | 01a1415e-2d3d-707d-8e9e-399b14d4a872 | €9.00 | €0.19 | matched |
| 21 | capture | 01a1415e-2c24-75d7-92ff-e3665aa558a3 | €35.00 | €0.50 | matched |
| 22 | capture | 01a1415e-5213-7948-a73d-92e32f416d7b | €49.00 | €0.67 | matched |
| 23 | capture | 01a1415e-612c-7cbe-9ba8-6e0e58e92493 | €49.00 | €0.67 | matched |
| 24 | capture | 01a1415e-6ff3-7483-a327-05925d322bc4 | €15.00 | €0.26 | matched |
| 25 | capture | 01a1415e-9d9d-7d77-9906-315484b75cbc | €15.00 | €0.26 | matched |
| 26 | capture | 01a1415e-9e88-7426-85a2-4364d0fbae18 | €49.00 | €0.67 | matched |
| 27 | capture | 01a1415e-aab9-7bec-afcf-0d48155e976c | €9.00 | €0.19 | matched |
| 28 | capture | 01a1415e-b074-72c4-8780-a11ba08f7e83 | €15.00 | €0.26 | matched |
| 29 | capture | 01a1415e-ddc2-7c76-9a73-c60871dba779 | €49.00 | €0.67 | matched |
| 30 | capture | 01a1415e-e3b5-70f6-82b7-f81bec2f4b3a | €24.00 | €0.37 | matched |
| 31 | capture | 01a1415e-e541-79c8-952b-c44338074a13 | €35.00 | €0.50 | matched |
| 32 | capture | 01a1415e-ed38-7ee8-a7a0-e831dc61b6bb | €9.00 | €0.19 | matched |
| 33 | capture | 01a1415e-f9df-7584-b7b7-9246f5cccbc1 | €35.00 | €0.50 | matched |
| 34 | capture | 01a1415f-10c9-79c8-81d8-aea789682e42 | €15.00 | €0.26 | matched |
| 35 | capture | 01a1415f-1487-7220-aa0e-4b279ceba057 | €49.00 | €0.67 | matched |
| 36 | capture | 01a1415f-1e5e-794d-9256-3079f092d2ac | €15.00 | €0.26 | matched |
| 37 | refund | 01a1415f-2def-7022-a76d-ae0bbfbb7800 | -€2.00 | €0.00 | matched |
| 38 | capture | 01a1415f-3c04-7c62-9470-dc6c39421691 | €9.00 | €0.19 | matched |
| 39 | capture | 01a1415f-45d7-7e62-a670-1711f7c6486d | €9.00 | €0.19 | matched |
| 40 | capture | 01a1415f-5770-74b6-af4e-4d5515761af3 | €9.00 | €0.19 | matched |
| 41 | capture | 01a1415f-5991-7389-8915-381aaa7c1f9f | €35.00 | €0.50 | matched |
| 42 | capture | 01a1415f-6870-7d87-8338-5ecc77c2a286 | €9.00 | €0.19 | matched |
| 43 | capture | 01a1415f-877a-71b4-9277-b34b98e11e7a | €49.00 | €0.67 | matched |
| 44 | capture | 01a1415f-89fc-73eb-83a8-b808d7799942 | €24.00 | €0.37 | matched |
| 45 | refund | 01a1415f-9381-7b45-8ea7-6a590a4d33c0 | -€4.00 | €0.00 | matched |
| 46 | capture | 01a1415f-962e-759e-80cc-93b1e689238d | €15.00 | €0.26 | matched |
| 47 | capture | 01a1415f-a87d-7daf-8cf5-62d6d53a1bb6 | €9.00 | €0.19 | matched |
| 48 | capture | 01a1415f-bd84-7e7b-89f6-8885af8b5bc9 | €9.00 | €0.19 | matched |
| 49 | capture | 01a1415f-c51f-753b-9748-86312397347f | €24.00 | €0.37 | matched |
| 50 | capture | 01a1415f-e2c8-73fc-a430-17bc55ac7ca2 | €24.00 | €0.37 | matched |
| 51 | capture | 01a1415f-e855-74e6-ae49-871060bcfe88 | €35.00 | €0.50 | matched |
| 52 | capture | 01a1415f-e8ab-7c93-8826-2cbe669dabc3 | €9.00 | €0.19 | matched |
| 53 | capture | 01a1415f-f41e-7492-8d66-f0daf18a4ed5 | €35.00 | €0.50 | matched |
| 54 | refund | 01a14160-34d3-79b2-9d3b-d3dab5ddc0ea | -€7.00 | €0.00 | matched |
| 55 | capture | 01a14160-3a40-78c7-ae0c-f7f275475554 | €24.00 | €0.37 | matched |
| 56 | capture | 01a14160-523b-7234-9ee1-3e7d6a9b0166 | €24.00 | €0.37 | matched |
| 57 | capture | 01a14160-6d25-7848-956d-26565e7223a4 | €49.00 | €0.67 | matched |
| 58 | capture | 01a14160-73a4-7989-9c44-a8c8a2139c2e | €9.00 | €0.19 | matched |
| 59 | capture | 01a14160-d9e8-7f11-ae54-4c765bdcd1c4 | €9.00 | €0.19 | matched |
| 60 | capture | 01a14160-da60-7e1f-ac98-d5b6d3d175b8 | €15.00 | €0.26 | matched |
| 61 | capture | 01a14160-ea68-7bb4-b33b-4b656a268905 | €15.00 | €0.26 | matched |
| 62 | capture | 01a14160-eaf0-74d6-96a2-a59eb9153d04 | €49.00 | €0.67 | matched |
| 63 | capture | 01a14160-edce-730f-90d6-dba54336d877 | €49.00 | €0.67 | matched |
| 64 | capture | 01a14160-f5cd-7c0c-8fcc-a5839daec59f | €35.00 | €0.50 | matched |
| 65 | capture | 01a14161-00d5-7e42-9f96-453e17ff55c3 | €35.00 | €0.50 | matched |
| 66 | capture | 01a14161-0638-74fb-b408-74d75600a014 | €49.00 | €0.67 | matched |
| 67 | capture | 01a14161-33a9-70cf-9e87-c75a140886f0 | €15.00 | €0.26 | matched |
| 68 | capture | 01a14161-37d8-76bc-946c-1a0fb08d1f82 | €35.00 | €0.50 | matched |
| 69 | capture | 01a14161-39cf-7177-b52c-4c893bec662a | €49.00 | €0.67 | matched |
| 70 | capture | 01a14161-3d89-7358-a85b-03226e192b63 | €24.00 | €0.37 | matched |
| 71 | refund | 01a14161-3ed9-7e7a-b563-496bc7bd7a0a | -€42.00 | €0.00 | matched |
| 72 | capture | 01a14161-4dda-718c-adfb-876c3987b6ca | €35.00 | €0.50 | matched |
| 73 | capture | 01a14161-5a19-7928-8d26-a03190cceb6e | €49.00 | €0.67 | matched |
| 74 | capture | 01a14161-7521-79c6-a2db-7fb5d7af4f95 | €24.00 | €0.37 | matched |
| 75 | capture | 01a14161-878c-7542-b410-ea96161a77fb | €24.00 | €0.37 | matched |
| 76 | capture | 01a14161-8b0e-7cf5-a17f-8c67216a163e | €15.00 | €0.26 | matched |
| 77 | refund | 01a14161-9198-792f-a45a-9fe3ffff7af0 | -€7.00 | €0.00 | matched |
| 78 | capture | 01a14161-9739-7fb5-bb74-1086825a80f9 | €49.00 | €0.67 | matched |
| 79 | capture | 01a14161-ae14-7c27-a386-cd3aa2f42068 | €9.00 | €0.19 | matched |
| 80 | capture | 01a14161-befe-7db5-809d-bb08414a2feb | €35.00 | €0.50 | matched |
| 81 | capture | 01a14161-c194-77ad-8651-758b99057b44 | €35.00 | €0.50 | matched |
| 82 | capture | 01a14161-e7e5-72d8-a84e-e43fc02712d5 | €24.00 | €0.37 | matched |
| 83 | capture | 01a14161-eef5-7e43-86f0-87cf720f715c | €9.00 | €0.19 | matched |
| 84 | capture | 01a14161-fe0a-7c36-8480-93864212fb54 | €15.00 | €0.26 | matched |
| 85 | capture | 01a14162-0d3c-7e47-a193-4176eed7f2fa | €24.00 | €0.37 | matched |
| 86 | capture | 01a14162-1dc4-733b-a94c-ed92a268112d | €15.00 | €0.26 | matched |
| 87 | refund | 01a14162-32f2-74ed-ba63-82d915997d02 | -€13.00 | €0.00 | matched |
| 88 | capture | 01a14162-5619-7b1b-ac7c-4b76ecdd7b62 | €24.00 | €0.37 | matched |
| 89 | refund | 01a14162-67fb-731a-be05-95b956a365f2 | -€7.00 | €0.00 | matched |
| 90 | capture | 01a14162-7ffb-7e5d-ab74-51106a156337 | €49.00 | €0.67 | matched |
| 91 | capture | 01a14162-921e-767d-bcdc-6de28b43f2ab | €35.00 | €0.50 | matched |
| 92 | capture | 01a14162-9b2b-70aa-afd7-872f1cf4ca9c | €24.00 | €0.37 | matched |
| 93 | capture | 01a14162-a294-7b32-95b4-ec670c5be9ce | €35.00 | €0.50 | matched |
| 94 | capture | 01a14162-a48c-73bd-bf1f-ad10c8831763 | €15.00 | €0.26 | matched |
| 95 | capture | 01a14162-bc5e-7d51-acac-09fb44b54548 | €49.00 | €0.67 | matched |
| 96 | capture | 01a14162-cbb4-708a-bddb-150ba5c4479e | €9.00 | €0.19 | matched |
| 97 | capture | 01a14162-e0a5-7032-ac86-82fe1d301bcf | €9.00 | €0.19 | matched |
| 98 | capture | 01a14162-e928-7d2f-9b3e-5d852f363fc1 | €15.00 | €0.26 | matched |
| 99 | capture | 01a14163-096d-7cbf-93f2-7f5e26bf0151 | €35.00 | €0.50 | matched |
| 100 | capture | 01a14163-44ed-7dda-8aa6-431e3484f36d | €49.00 | €0.67 | matched |
| 101 | capture | 01a14163-597f-7dd8-b9f5-70646919caac | €24.00 | €0.37 | matched |
| 102 | capture | 01a14163-6c40-7d9b-a700-9ef9f4d2763f | €49.00 | €0.67 | matched |
| 103 | capture | 01a14163-81bd-7ebc-965d-36fa9e19728c | €49.00 | €0.67 | matched |
| 104 | capture | 01a14163-8474-7baf-80ab-f980170d91f8 | €35.00 | €0.50 | matched |
| 105 | capture | 01a14163-8859-7688-a9f3-c045cc777c51 | €35.00 | €0.50 | matched |
| 106 | capture | 01a14163-9ee6-708b-8946-d17d4db87da4 | €15.00 | €0.26 | matched |
| 107 | capture | 01a14163-b7c3-71aa-a12d-e7ed95e75f58 | €24.00 | €0.37 | matched |
| 108 | refund | 01a14163-b930-7e96-b923-e3759b953f61 | -€11.00 | €0.00 | matched |
| 109 | capture | 01a14163-bf6e-7e97-b7ec-c82891ecec02 | €24.00 | €0.37 | matched |
| 110 | capture | 01a14163-e706-7fbc-9468-cf22e9a0d9c7 | €15.00 | €0.26 | matched |
| 111 | capture | 01a14164-333c-79d2-bf98-8c813a2f42b3 | €9.00 | €0.19 | matched |
| 112 | capture | 01a14164-34eb-79e3-b232-eb5e5b1f8541 | €49.00 | €0.67 | matched |
| 113 | capture | 01a14164-3754-7617-9b8c-558106c22214 | €15.00 | €0.26 | matched |
| 114 | capture | 01a14164-50a0-7fcf-a2ef-52b60c3770e3 | €9.00 | €0.19 | matched |
| 115 | capture | 01a14164-65dc-7b95-9093-bf8336ea8e8c | €24.00 | €0.37 | matched |
| 116 | refund | 01a14164-7721-7746-8bc7-b005f8a52159 | -€7.00 | €0.00 | matched |
| 117 | capture | 01a14164-79a5-7a94-9e7e-95b65f5fab2a | €9.00 | €0.19 | matched |
| 118 | capture | 01a14164-837c-753b-bda2-c800d16e569c | €35.00 | €0.50 | matched |
| 119 | capture | 01a14164-dcd2-7dd0-aa7b-6cc43d9cf58a | €49.00 | €0.67 | matched |
| 120 | capture | 01a14165-5cdf-782a-88ec-75e9e97361e8 | €35.00 | €0.50 | matched |
| 121 | capture | 01a14165-8162-7258-855a-cde80e2eec92 | €9.00 | €0.19 | matched |
| 122 | capture | 01a14165-98d7-716f-b74a-7ae155281368 | €9.00 | €0.19 | matched |
| 123 | capture | 01a14165-9b85-7b2e-bf93-da8a678ccee7 | €49.00 | €0.67 | matched |
| 124 | capture | 01a14165-a933-717b-b048-9b397131ba99 | €24.00 | €0.37 | matched |
| 125 | capture | 01a14165-c01c-7be1-9bd5-a4f6ee47071d | €49.00 | €0.67 | matched |
| 126 | capture | 01a14165-c0ce-7aae-a157-c4734bcb07b2 | €15.00 | €0.26 | matched |
| 127 | refund | 01a14165-c10e-7871-a67a-f9047f27a230 | -€14.00 | €0.00 | matched |
| 128 | capture | 01a14165-cd1a-792d-8cbb-27840c707597 | €15.00 | €0.26 | matched |
| 129 | capture | 01a14165-e9ad-7924-a50e-e138de6baa3b | €15.00 | €0.26 | matched |
| 130 | capture | 01a14166-151c-7940-b086-3e726d944e1f | €49.00 | €0.67 | matched |
| 131 | refund | 01a14166-177e-7b64-a5f6-ec42e246465c | -€10.00 | €0.00 | matched |
| 132 | capture | 01a14166-1938-7aa5-be37-4db75bd7a2fa | €35.00 | €0.50 | matched |
| 133 | capture | 01a14166-3920-7cfd-b2d2-58a0e42b018d | €35.00 | €0.50 | matched |
| 134 | capture | 01a14166-4f16-7c86-8f26-b51042441400 | €9.00 | €0.19 | matched |
| 135 | capture | 01a14166-5697-70a0-a3b9-03c46d8a364c | €35.00 | €0.50 | matched |
| 136 | capture | 01a14166-5ce7-7982-9050-bcc3e70d1441 | €35.00 | €0.50 | matched |
| 137 | capture | 01a14166-6e7f-72d5-a585-ee6feec9fe1e | €15.00 | €0.26 | matched |
| 138 | capture | 01a14166-7c90-76a7-ae2c-f2ba8830e2fb | €35.00 | €0.50 | matched |