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, 13:30132 lines2 breaks
- 15 Oct, 13:20133 lines4 breaks
- 15 Oct, 13:10130 lines5 breaks
- 15 Oct, 13:00141 lines2 breaks
- 15 Oct, 12:50108 lines1 break
- 15 Oct, 12:40116 lines2 breaks
- 15 Oct, 12:30121 lines3 breaks
- 15 Oct, 12:20123 lines2 breaks
- 15 Oct, 12:10126 lines3 breaks
- 15 Oct, 12:00143 lines3 breaks
- 15 Oct, 11:50137 lines3 breaks
- 15 Oct, 11:40129 linesclean
- 15 Oct, 11:30132 lines4 breaks
- 15 Oct, 11:20136 lines4 breaks
15 Oct, 12:20
Gross
€2,718.00
PSP fee
€43.26
Net to the bank
€2,674.74
Settlement journal
#14589
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13f82-30a1-7d7b-9405-f9558b949d5f is already settled by stl_EUR_2986778 line 21
- missing linein the books, not in the filecapture:01a13f86-b61b-7ef6-8bb1-c9d87fd14a6f is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 2 | capture | 01a13f7e-625f-7173-b0eb-13ad8a273ca0 | €49.00 | €0.71 | fee difference |
| 22 | capture | 01a13f82-30ce-74e5-9199-feb61db27695 | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a13f7c-adec-78d9-9179-cbd349924f06 | €35.00 | €0.50 | matched |
| 3 | capture | 01a13f80-43ee-7b1b-ac12-4455b3b59176 | €35.00 | €0.50 | matched |
| 4 | capture | 01a13f81-5579-7429-9ddb-de8acb6516d7 | €35.00 | €0.50 | matched |
| 5 | refund | 01a13f81-5b31-7b75-8691-c6cff6cce0e7 | -€24.00 | €0.00 | matched |
| 6 | capture | 01a13f81-6a16-70d2-abda-f49e0788d203 | €15.00 | €0.26 | matched |
| 7 | capture | 01a13f81-8900-7ffe-bfb1-b041249026c0 | €15.00 | €0.26 | matched |
| 8 | capture | 01a13f81-8d1b-79aa-bead-ecb70f1f9f20 | €24.00 | €0.37 | matched |
| 9 | capture | 01a13f81-a49f-702d-aeb5-5501df7f205f | €9.00 | €0.19 | matched |
| 10 | capture | 01a13f81-a895-748e-b071-131c1389d032 | €15.00 | €0.26 | matched |
| 11 | capture | 01a13f81-b0e1-798e-950a-89e53f32e0bb | €35.00 | €0.50 | matched |
| 12 | capture | 01a13f81-cc1f-721f-9146-33acc9f0daec | €35.00 | €0.50 | matched |
| 13 | capture | 01a13f81-e3e2-77ee-a445-95911ae0320b | €49.00 | €0.67 | matched |
| 14 | capture | 01a13f81-f001-7329-b538-77e02588598d | €49.00 | €0.67 | matched |
| 15 | capture | 01a13f81-fddd-7f34-b689-dfa506548dd3 | €9.00 | €0.19 | matched |
| 16 | capture | 01a13f82-0bfe-78b4-851c-f71135eec0a6 | €35.00 | €0.50 | matched |
| 17 | capture | 01a13f82-0e3e-7d5a-9f43-a114216659b8 | €49.00 | €0.67 | matched |
| 18 | capture | 01a13f82-17d6-7460-83b0-661f5d91cc53 | €15.00 | €0.26 | matched |
| 19 | capture | 01a13f82-2273-7d14-9182-37ebedaa2568 | €24.00 | €0.37 | matched |
| 20 | refund | 01a13f82-2eb3-78f6-979a-e7d39c0aa946 | -€3.00 | €0.00 | matched |
| 21 | capture | 01a13f82-30ce-74e5-9199-feb61db27695 | €35.00 | €0.50 | matched |
| 23 | capture | 01a13f82-3793-7a6e-b560-aba19e88520a | €9.00 | €0.19 | matched |
| 24 | capture | 01a13f82-3806-701b-9ab6-bfd8e6dec10f | €35.00 | €0.50 | matched |
| 25 | capture | 01a13f82-3f98-705d-bb18-1ba169ee7095 | €15.00 | €0.26 | matched |
| 26 | capture | 01a13f82-5dff-707b-a2e4-2a14c43e69e8 | €35.00 | €0.50 | matched |
| 27 | capture | 01a13f82-6853-742c-ac55-6ba43ed5c9b5 | €35.00 | €0.50 | matched |
| 28 | capture | 01a13f82-81a1-7bf2-ba75-498435685dce | €24.00 | €0.37 | matched |
| 29 | capture | 01a13f82-85c9-78b2-97b6-e5e9ce46c66d | €35.00 | €0.50 | matched |
| 30 | capture | 01a13f82-be40-7726-a77a-6d91e1eab945 | €15.00 | €0.26 | matched |
| 31 | capture | 01a13f82-d1e7-7d2b-be14-ca0c268d01e4 | €35.00 | €0.50 | matched |
| 32 | capture | 01a13f82-f842-7020-8605-81b125ac0ac8 | €35.00 | €0.50 | matched |
| 33 | capture | 01a13f82-fdde-79cd-8535-e232cfaae2e3 | €35.00 | €0.50 | matched |
| 34 | capture | 01a13f83-099d-7084-8ad6-a6af23d117e7 | €35.00 | €0.50 | matched |
| 35 | capture | 01a13f83-1a5e-7ea3-ab32-9b4852de8e85 | €49.00 | €0.67 | matched |
| 36 | capture | 01a13f83-2f50-7832-9865-4ec5025bc5d1 | €9.00 | €0.19 | matched |
| 37 | capture | 01a13f83-4cd9-70c6-8b59-67fa994877fc | €24.00 | €0.37 | matched |
| 38 | capture | 01a13f83-6d08-725a-9d02-3f0475269ed2 | €35.00 | €0.50 | matched |
| 39 | capture | 01a13f83-75e5-74cf-be01-ebafdc26612f | €15.00 | €0.26 | matched |
| 40 | capture | 01a13f83-7b12-7df8-955b-1c70c455b9df | €49.00 | €0.67 | matched |
| 41 | capture | 01a13f83-8b9e-7af3-be62-bc7bca8edeb0 | €9.00 | €0.19 | matched |
| 42 | capture | 01a13f83-8d9e-7dc5-ab25-e5ee4a3e3071 | €49.00 | €0.67 | matched |
| 43 | capture | 01a13f83-9210-7cfd-9515-aa437ef70fe2 | €9.00 | €0.19 | matched |
| 44 | capture | 01a13f83-a211-7475-8132-8449acb4e7fc | €49.00 | €0.67 | matched |
| 45 | capture | 01a13f83-a9a7-7e2b-8f45-2cd9a580cee1 | €15.00 | €0.26 | matched |
| 46 | capture | 01a13f83-ab6a-7593-929a-d210ec3edc57 | €9.00 | €0.19 | matched |
| 47 | capture | 01a13f83-d5bd-7810-9bdd-7cfc2738b2b6 | €35.00 | €0.50 | matched |
| 48 | capture | 01a13f83-d8f8-7c72-a758-551b790696d8 | €15.00 | €0.26 | matched |
| 49 | capture | 01a13f83-e6c4-7334-9c4e-16bdc7793f22 | €9.00 | €0.19 | matched |
| 50 | capture | 01a13f83-eed7-762e-8833-15c7291e656d | €15.00 | €0.26 | matched |
| 51 | capture | 01a13f83-efb8-7518-a20f-6971499c9535 | €49.00 | €0.67 | matched |
| 52 | capture | 01a13f84-04a5-7c7d-b131-c3cd8e6f5818 | €15.00 | €0.26 | matched |
| 53 | capture | 01a13f84-322a-7c46-96d9-b6d45d24e83b | €24.00 | €0.37 | matched |
| 54 | capture | 01a13f84-43b8-7000-9224-852d594fe5d0 | €49.00 | €0.67 | matched |
| 55 | capture | 01a13f84-6053-715f-9b8d-3b1bbd205618 | €9.00 | €0.19 | matched |
| 56 | refund | 01a13f84-7a65-70a2-b5cb-856086ec250a | -€13.00 | €0.00 | matched |
| 57 | refund | 01a13f84-93a4-7d08-b988-aff88b7169ed | -€32.00 | €0.00 | matched |
| 58 | capture | 01a13f84-9978-7c00-b038-2453ff9ce9d5 | €49.00 | €0.67 | matched |
| 59 | capture | 01a13f84-acc2-7f71-94a9-6576ad62065a | €15.00 | €0.26 | matched |
| 60 | capture | 01a13f85-06b2-7290-8b7b-5b5c3312e82b | €49.00 | €0.67 | matched |
| 61 | capture | 01a13f85-185a-796d-8fea-7ed0c952105f | €24.00 | €0.37 | matched |
| 62 | capture | 01a13f85-2207-7ed0-8f65-563f84504530 | €15.00 | €0.26 | matched |
| 63 | capture | 01a13f85-3d00-73f1-8570-3303e7a8c515 | €15.00 | €0.26 | matched |
| 64 | capture | 01a13f85-6d9a-7ab6-b517-8d0edce4cd86 | €9.00 | €0.19 | matched |
| 65 | capture | 01a13f85-9f1a-70e6-a793-94e659a2e9ca | €35.00 | €0.50 | matched |
| 66 | refund | 01a13f85-a898-7a62-b618-9a33672b691f | -€4.00 | €0.00 | matched |
| 67 | capture | 01a13f85-bb43-7ff1-b754-c8cb95352b58 | €15.00 | €0.26 | matched |
| 68 | capture | 01a13f85-cf79-7796-af28-098efd038788 | €24.00 | €0.37 | matched |
| 69 | capture | 01a13f85-d681-7176-83d5-5e3f7f574c41 | €15.00 | €0.26 | matched |
| 70 | capture | 01a13f85-fd4c-781e-be9c-5f636d0a458f | €9.00 | €0.19 | matched |
| 71 | capture | 01a13f86-000a-7228-b036-c599e7dbde5c | €35.00 | €0.50 | matched |
| 72 | refund | 01a13f86-124e-7834-a390-5cd83d5f7468 | -€15.00 | €0.00 | matched |
| 73 | capture | 01a13f86-34ca-735d-afe5-e5e44657d2d9 | €35.00 | €0.50 | matched |
| 74 | refund | 01a13f86-46b0-777e-ba85-b33049647cfb | -€8.00 | €0.00 | matched |
| 75 | capture | 01a13f86-6982-74d1-be32-14eda08921d3 | €9.00 | €0.19 | matched |
| 76 | capture | 01a13f86-7416-75be-81eb-c47e630d533d | €35.00 | €0.50 | matched |
| 77 | capture | 01a13f86-762d-70a6-995e-47b412345e79 | €9.00 | €0.19 | matched |
| 78 | capture | 01a13f86-a19b-7654-aa25-65da24803f73 | €9.00 | €0.19 | matched |
| 79 | capture | 01a13f86-a240-736f-b274-8f1bd2e73782 | €15.00 | €0.26 | matched |
| 80 | refund | 01a13f86-b032-7310-b1e6-60b2cc6408fe | -€3.00 | €0.00 | matched |
| 81 | refund | 01a13f86-b2ef-7fb5-9d76-bce16d100f88 | -€9.00 | €0.00 | matched |
| 82 | capture | 01a13f86-c05d-72ac-a7e6-22c63a11699b | €15.00 | €0.26 | matched |
| 83 | capture | 01a13f86-c6ae-7367-ae94-7690d06ed2df | €9.00 | €0.19 | matched |
| 84 | capture | 01a13f86-c9f1-7084-8e4b-3bb63a3eea00 | €24.00 | €0.37 | matched |
| 85 | capture | 01a13f86-b461-72c5-aa49-8d227809318f | €15.00 | €0.26 | matched |
| 86 | capture | 01a13f86-d987-746a-901c-9a0915c2a73c | €35.00 | €0.50 | matched |
| 87 | capture | 01a13f86-eb6e-7f6b-8f79-7531096e2f71 | €15.00 | €0.26 | matched |
| 88 | capture | 01a13f87-10b4-7984-b903-2576ac569e9d | €35.00 | €0.50 | matched |
| 89 | capture | 01a13f87-2823-765a-a3f9-00dfca11ba23 | €49.00 | €0.67 | matched |
| 90 | capture | 01a13f87-2a03-7055-81ab-35c6f02060dd | €15.00 | €0.26 | matched |
| 91 | capture | 01a13f87-637e-7436-83cc-826badae3570 | €35.00 | €0.50 | matched |
| 92 | capture | 01a13f87-65e7-73ed-96df-568948eb0ad8 | €15.00 | €0.26 | matched |
| 93 | capture | 01a13f87-6b03-737b-8376-51488f7f862c | €49.00 | €0.67 | matched |
| 94 | capture | 01a13f87-729a-7229-8fbd-f43b10c1b900 | €24.00 | €0.37 | matched |
| 95 | capture | 01a13f87-b414-7569-aa68-7170bd9a9e32 | €35.00 | €0.50 | matched |
| 96 | refund | 01a13f87-b5ab-747f-b9b0-354ae22b4503 | -€12.00 | €0.00 | matched |
| 97 | capture | 01a13f88-0a88-754b-a2c6-c692abeb12b8 | €9.00 | €0.19 | matched |
| 98 | capture | 01a13f88-0443-7580-85ab-c6441b516592 | €15.00 | €0.26 | matched |
| 99 | capture | 01a13f88-4a9e-7fb2-ba2f-4341e33e8b04 | €49.00 | €0.67 | matched |
| 100 | capture | 01a13f88-7187-7150-b8f8-27e1d24c1029 | €24.00 | €0.37 | matched |
| 101 | capture | 01a13f88-7207-76d3-83f5-4b6a4d74b291 | €9.00 | €0.19 | matched |
| 102 | capture | 01a13f88-8c88-7918-8b12-10fc67f6223c | €15.00 | €0.26 | matched |
| 103 | capture | 01a13f88-b537-7287-8d69-a7f662b43f4a | €35.00 | €0.50 | matched |
| 104 | capture | 01a13f88-cf1d-7382-b6f0-7ad3149f350b | €24.00 | €0.37 | matched |
| 105 | capture | 01a13f88-eef4-7792-b33f-dfc5abf97cf4 | €35.00 | €0.50 | matched |
| 106 | capture | 01a13f88-f081-7023-9277-a5f0834ea04e | €9.00 | €0.19 | matched |
| 107 | capture | 01a13f88-f810-7180-9a08-98216f29c151 | €24.00 | €0.37 | matched |
| 108 | capture | 01a13f88-fce5-7458-9124-b27084df7838 | €24.00 | €0.37 | matched |
| 109 | capture | 01a13f89-04b3-70f4-acb5-1ed6be343afe | €9.00 | €0.19 | matched |
| 110 | capture | 01a13f89-4396-728f-a9c7-f0ee25e6a191 | €9.00 | €0.19 | matched |
| 111 | capture | 01a13f89-6363-7093-bd7a-45e3d3b52b0c | €49.00 | €0.67 | matched |
| 112 | capture | 01a13f89-7f62-70a6-b89c-ef6222a74f0c | €49.00 | €0.67 | matched |
| 113 | capture | 01a13f89-9516-7660-b902-ea72e8dd63e2 | €15.00 | €0.26 | matched |
| 114 | capture | 01a13f89-9ed5-7369-be92-c3405f7e86f1 | €9.00 | €0.19 | matched |
| 115 | capture | 01a13f89-9eed-7e45-8a8a-f8d9e6f728bf | €9.00 | €0.19 | matched |
| 116 | capture | 01a13f89-a244-7bc3-b013-5f54377b7caf | €9.00 | €0.19 | matched |
| 117 | capture | 01a13f89-aa48-795e-bb5c-fcb59022246a | €35.00 | €0.50 | matched |
| 118 | capture | 01a13f89-b735-79c0-b53e-230c732e20a6 | €15.00 | €0.26 | matched |
| 119 | refund | 01a13f8a-0e47-72c1-895b-6693e2cfdaff | -€5.00 | €0.00 | matched |
| 120 | capture | 01a13f8a-254b-7576-a484-13ca75521b9c | €15.00 | €0.26 | matched |
| 121 | capture | 01a13f8a-40e7-780d-ab0e-192123e1451c | €15.00 | €0.26 | matched |
| 122 | capture | 01a13f8a-6e4c-7b45-b2f3-8b4bb2278a00 | €35.00 | €0.50 | matched |
| 123 | capture | 01a13f8a-7120-7ae3-893d-efae6c07b37e | €24.00 | €0.37 | matched |