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
- 2 Nov, 05:20132 lines3 breaks
- 2 Nov, 05:10107 lines2 breaks
- 2 Nov, 05:00117 lines6 breaks
- 2 Nov, 04:50112 lines2 breaks
- 2 Nov, 04:40139 lines5 breaks
- 2 Nov, 04:30129 lines2 breaks
- 2 Nov, 04:20127 lines2 breaks
- 2 Nov, 04:10130 lines3 breaks
- 2 Nov, 04:00124 lines4 breaks
- 2 Nov, 03:50121 lines3 breaks
- 2 Nov, 03:40128 lines1 break
- 2 Nov, 03:30124 lines3 breaks
- 2 Nov, 03:20110 lines2 breaks
- 2 Nov, 03:10110 lines2 breaks
2 Nov, 04:10
Gross
€3,197.00
PSP fee
€49.66
Net to the bank
€3,147.34
Settlement journal
#336493
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19a79-2a72-79bb-a869-11024142c007 is already settled by stl_EUR_2989321 line 91
- missing linein the books, not in the filecapture:01a19a75-b838-7bf1-8ecf-b1a7f37a2920 is in no file
- missing linein the books, not in the filecapture:01a19a75-c66e-7dc1-ae99-2cd3cec1be92 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 92 | capture | 01a19a79-2a9f-754b-8e92-c7605224c705 | €15.00 | €0.26 | duplicate line |
| 1 | capture | 01a19a6d-36ff-700f-8dbf-96b09676bc8a | €35.00 | €0.50 | matched |
| 2 | capture | 01a19a6e-659b-7d53-8a9d-7c9711d65c96 | €24.00 | €0.37 | matched |
| 3 | capture | 01a19a6f-ec65-7335-8f3b-cd59ec21014f | €15.00 | €0.26 | matched |
| 4 | capture | 01a19a71-fa03-7fab-839b-f43c54754dc9 | €49.00 | €0.67 | matched |
| 5 | capture | 01a19a73-2632-7a4e-86c3-aae753b1eafd | €35.00 | €0.50 | matched |
| 6 | capture | 01a19a73-32fa-7110-aab4-ebd15e7ed369 | €24.00 | €0.37 | matched |
| 7 | capture | 01a19a73-6518-78a8-aa10-6bcc11feeeb8 | €15.00 | €0.26 | matched |
| 8 | capture | 01a19a73-6a9d-73d6-b6f3-17cf6e441c0c | €24.00 | €0.37 | matched |
| 9 | capture | 01a19a73-8548-7920-8d65-c19b29c907ae | €9.00 | €0.19 | matched |
| 10 | capture | 01a19a73-8647-737b-9000-99f9812c6251 | €9.00 | €0.19 | matched |
| 11 | capture | 01a19a73-8bc8-7169-89a6-d0cfed13f0d7 | €15.00 | €0.26 | matched |
| 12 | capture | 01a19a73-afbf-7d08-998f-e0950988abda | €9.00 | €0.19 | matched |
| 13 | capture | 01a19a73-d861-78d9-b6d0-3b20cefb06fe | €24.00 | €0.37 | matched |
| 14 | capture | 01a19a73-dac2-7352-8aaf-f832bd262a76 | €49.00 | €0.67 | matched |
| 15 | capture | 01a19a73-e7a1-70e8-804a-5f65da7edbf7 | €9.00 | €0.19 | matched |
| 16 | capture | 01a19a73-e8d4-7c24-9543-290d29ecf4b3 | €15.00 | €0.26 | matched |
| 17 | capture | 01a19a73-eeb9-73c6-a2cd-cc041832219a | €9.00 | €0.19 | matched |
| 18 | capture | 01a19a74-005e-7a27-9b1d-93281d82ebee | €9.00 | €0.19 | matched |
| 19 | capture | 01a19a74-278c-763e-98d4-c55098d3b983 | €24.00 | €0.37 | matched |
| 20 | capture | 01a19a74-38ff-73de-bc00-f17ae262d22e | €15.00 | €0.26 | matched |
| 21 | capture | 01a19a74-3a4b-7daa-a206-96983ecf8d1a | €24.00 | €0.37 | matched |
| 22 | capture | 01a19a74-50ed-7d2e-9dd1-6177a38057af | €9.00 | €0.19 | matched |
| 23 | capture | 01a19a74-69ab-7136-83d0-242b778280dd | €49.00 | €0.67 | matched |
| 24 | capture | 01a19a74-6f25-7f7e-b024-3bfe2afeb446 | €35.00 | €0.50 | matched |
| 25 | capture | 01a19a74-8ba7-74f0-ad00-9ceeaaef418b | €35.00 | €0.50 | matched |
| 26 | capture | 01a19a74-9451-70a1-8d4e-11c45911d77b | €49.00 | €0.67 | matched |
| 27 | capture | 01a19a74-9846-793b-b8fe-06920059e484 | €24.00 | €0.37 | matched |
| 28 | capture | 01a19a74-9d57-7933-94d3-b70e918cf5fc | €49.00 | €0.67 | matched |
| 29 | capture | 01a19a74-b5ed-7a66-bdbd-3c5bbe897027 | €35.00 | €0.50 | matched |
| 30 | capture | 01a19a74-cc40-70f7-974c-9660cad948c8 | €9.00 | €0.19 | matched |
| 31 | capture | 01a19a74-cdb6-7119-b320-32e32e3a6c1c | €49.00 | €0.67 | matched |
| 32 | capture | 01a19a75-01fc-76e0-b3f4-dbae90ff1597 | €49.00 | €0.67 | matched |
| 33 | capture | 01a19a75-2cb9-7768-a325-f17c8125ab98 | €35.00 | €0.50 | matched |
| 34 | capture | 01a19a75-320a-7cf5-af2c-917c1e1ba5a4 | €35.00 | €0.50 | matched |
| 35 | capture | 01a19a75-36f2-7de2-afef-c9cbc3e34f42 | €9.00 | €0.19 | matched |
| 36 | capture | 01a19a75-391e-71ee-a165-740259bda62e | €15.00 | €0.26 | matched |
| 37 | capture | 01a19a75-39d7-7693-aec2-90211126da82 | €24.00 | €0.37 | matched |
| 38 | capture | 01a19a75-4603-752b-b145-e1d1fb8637cb | €24.00 | €0.37 | matched |
| 39 | capture | 01a19a75-652c-797d-aacd-268f7f8b43a7 | €9.00 | €0.19 | matched |
| 40 | capture | 01a19a75-676c-7cfb-8fa9-6bbc7d33677a | €15.00 | €0.26 | matched |
| 41 | capture | 01a19a75-7850-7797-aa5e-55cdbb0b0da0 | €35.00 | €0.50 | matched |
| 42 | capture | 01a19a75-7eef-790c-92e4-c803173f560f | €9.00 | €0.19 | matched |
| 43 | capture | 01a19a75-83d8-7956-8443-de364b07273b | €49.00 | €0.67 | matched |
| 44 | capture | 01a19a75-86f3-706a-81f3-7def165513dc | €9.00 | €0.19 | matched |
| 45 | capture | 01a19a75-92b6-7951-855e-95b45dc35400 | €24.00 | €0.37 | matched |
| 46 | capture | 01a19a75-d6a5-76f4-970e-6e787e257e10 | €49.00 | €0.67 | matched |
| 47 | capture | 01a19a75-d81a-7266-a8e2-653b6fbb0882 | €35.00 | €0.50 | matched |
| 48 | capture | 01a19a75-f3bd-7f07-87ea-1ed6c912322e | €24.00 | €0.37 | matched |
| 49 | capture | 01a19a75-f5cc-7020-bf74-6fe63959ea69 | €49.00 | €0.67 | matched |
| 50 | capture | 01a19a75-fc4e-787b-a2ae-b790373b2a70 | €9.00 | €0.19 | matched |
| 51 | capture | 01a19a76-07b6-75f5-802f-2ffe676f3453 | €15.00 | €0.26 | matched |
| 52 | capture | 01a19a76-160d-7467-b205-1512605b6310 | €49.00 | €0.67 | matched |
| 53 | capture | 01a19a76-2117-7746-9339-662c0fbd5a8a | €49.00 | €0.67 | matched |
| 54 | capture | 01a19a76-2c5a-70f4-b471-32b3f1a44f65 | €49.00 | €0.67 | matched |
| 55 | capture | 01a19a76-4770-793e-bad8-6c5e2412a67d | €15.00 | €0.26 | matched |
| 56 | capture | 01a19a76-4d6a-71ba-afe8-bbfd79c4ca99 | €24.00 | €0.37 | matched |
| 57 | refund | 01a19a76-6bb3-761a-82ad-a0ae69a53c36 | -€5.00 | €0.00 | matched |
| 58 | capture | 01a19a76-7709-7a1b-9da0-f7576c73e306 | €35.00 | €0.50 | matched |
| 59 | capture | 01a19a76-7ba5-7143-950a-79ad255eac27 | €15.00 | €0.26 | matched |
| 60 | capture | 01a19a76-802a-7300-99d3-89fcf14851fd | €24.00 | €0.37 | matched |
| 61 | capture | 01a19a76-c314-732b-8ffd-8bd7ce5756cc | €15.00 | €0.26 | matched |
| 62 | capture | 01a19a76-c7e9-7411-9700-46e806d2a540 | €35.00 | €0.50 | matched |
| 63 | capture | 01a19a76-ffda-7f5b-ad95-f11b65c98f57 | €35.00 | €0.50 | matched |
| 64 | capture | 01a19a77-41e3-7e8e-8b21-91e4e5e64954 | €9.00 | €0.19 | matched |
| 65 | capture | 01a19a77-4f4d-7119-bd0a-b8c9a50b3b91 | €15.00 | €0.26 | matched |
| 66 | capture | 01a19a77-5793-7511-a5fd-3969cc158d4f | €24.00 | €0.37 | matched |
| 67 | capture | 01a19a77-613b-7a5e-abfe-1aada959afc4 | €9.00 | €0.19 | matched |
| 68 | capture | 01a19a77-6e9d-751c-abf5-afe0c50c55bd | €15.00 | €0.26 | matched |
| 69 | capture | 01a19a77-6f89-7fe4-8d5b-410ccded6f9a | €15.00 | €0.26 | matched |
| 70 | capture | 01a19a77-b98a-77a6-a67c-b43cc9860cf6 | €9.00 | €0.19 | matched |
| 71 | capture | 01a19a77-d0d4-7bde-ae04-921f5aa8130b | €24.00 | €0.37 | matched |
| 72 | capture | 01a19a77-ddb8-76ff-a324-d188ccc3a8bf | €9.00 | €0.19 | matched |
| 73 | capture | 01a19a77-e28e-7c27-a2d2-e95e2f75a8e2 | €9.00 | €0.19 | matched |
| 74 | capture | 01a19a78-04a8-7ea2-95c1-2e44d0cb4fb5 | €24.00 | €0.37 | matched |
| 75 | capture | 01a19a78-459b-79dd-845a-a6c2dc752880 | €35.00 | €0.50 | matched |
| 76 | capture | 01a19a78-7191-71ec-a280-0137f3dca628 | €9.00 | €0.19 | matched |
| 77 | capture | 01a19a78-7598-7e19-ac18-3a1c5f2431da | €24.00 | €0.37 | matched |
| 78 | capture | 01a19a78-7d18-7f1c-abcc-0a172618eb29 | €24.00 | €0.37 | matched |
| 79 | capture | 01a19a78-8375-7152-91b3-f761f6d2f7d0 | €9.00 | €0.19 | matched |
| 80 | capture | 01a19a78-a971-7528-99b5-8c62a8c4ccef | €9.00 | €0.19 | matched |
| 81 | capture | 01a19a78-b26e-7d34-b1d4-85eeb5c24dfc | €35.00 | €0.50 | matched |
| 82 | capture | 01a19a78-b9ff-70e6-870d-b4cb2f666e52 | €15.00 | €0.26 | matched |
| 83 | capture | 01a19a78-d317-795a-adf3-39249e0c1c91 | €9.00 | €0.19 | matched |
| 84 | capture | 01a19a78-dfdc-7928-9b5c-63858eacbad8 | €9.00 | €0.19 | matched |
| 85 | capture | 01a19a78-ed4d-7757-805f-979a17e64353 | €35.00 | €0.50 | matched |
| 86 | capture | 01a19a78-f140-7218-9b00-02f79c289478 | €15.00 | €0.26 | matched |
| 87 | capture | 01a19a78-f837-707d-b2aa-3fecc17db5f8 | €35.00 | €0.50 | matched |
| 88 | capture | 01a19a79-018b-76d3-9e84-ddcba18b370c | €9.00 | €0.19 | matched |
| 89 | refund | 01a19a79-16f3-7455-a014-a0a7161e7bf7 | -€28.00 | €0.00 | matched |
| 90 | refund | 01a19a79-214a-7b8b-91c0-b7aa7782e07f | -€15.00 | €0.00 | matched |
| 91 | capture | 01a19a79-2a9f-754b-8e92-c7605224c705 | €15.00 | €0.26 | matched |
| 93 | capture | 01a19a79-3dd1-708f-93ea-22a2270dd03d | €9.00 | €0.19 | matched |
| 94 | capture | 01a19a79-4e53-7120-8dbb-c0f84a6cf022 | €49.00 | €0.67 | matched |
| 95 | capture | 01a19a79-6069-71d8-a8e5-0bedee9523c5 | €49.00 | €0.67 | matched |
| 96 | capture | 01a19a79-7cf9-76e1-bddd-c236a5ab37f4 | €35.00 | €0.50 | matched |
| 97 | capture | 01a19a79-b0be-76e3-996c-d6fcc5e82480 | €15.00 | €0.26 | matched |
| 98 | capture | 01a19a79-bf48-7a23-aba2-5768fea6970c | €35.00 | €0.50 | matched |
| 99 | capture | 01a19a79-da65-7771-a84d-4599de9f5d24 | €49.00 | €0.67 | matched |
| 100 | capture | 01a19a79-de9a-703e-842d-373438331704 | €35.00 | €0.50 | matched |
| 101 | capture | 01a19a79-edbd-70c4-aa51-96e7eb8abdbb | €24.00 | €0.37 | matched |
| 102 | capture | 01a19a7a-22e7-7d0e-a77b-06c344b684dd | €35.00 | €0.50 | matched |
| 103 | capture | 01a19a7a-24e8-79eb-b07e-5ffb1560bf33 | €49.00 | €0.67 | matched |
| 104 | capture | 01a19a7a-2ed8-7d89-9bd5-18ebef0a4f7b | €49.00 | €0.67 | matched |
| 105 | capture | 01a19a7a-4399-704a-ac4e-a3b9776e0d3c | €49.00 | €0.67 | matched |
| 106 | capture | 01a19a7a-4a92-7f80-bdf3-34298f28cf73 | €9.00 | €0.19 | matched |
| 107 | capture | 01a19a7a-5254-76c0-b30e-676f79ed6078 | €9.00 | €0.19 | matched |
| 108 | capture | 01a19a7a-5320-7ba2-873e-4fb0a9acab90 | €35.00 | €0.50 | matched |
| 109 | capture | 01a19a7a-686e-7b69-b41b-559ba02e3950 | €49.00 | €0.67 | matched |
| 110 | refund | 01a19a7a-6394-7b20-af5b-fcbbeddade97 | -€24.00 | €0.00 | matched |
| 111 | capture | 01a19a7a-6de0-7ccc-930f-79ac16fe18eb | €35.00 | €0.50 | matched |
| 112 | capture | 01a19a7a-8f2e-7dad-b4d2-a992ba856973 | €24.00 | €0.37 | matched |
| 113 | refund | 01a19a7a-9bdf-72f8-be73-277ee1cc76d1 | -€3.00 | €0.00 | matched |
| 114 | capture | 01a19a7a-db05-7833-bc14-640867516269 | €24.00 | €0.37 | matched |
| 115 | capture | 01a19a7a-dd21-7117-b60d-7af3ff3d5c2e | €35.00 | €0.50 | matched |
| 116 | capture | 01a19a7a-fb35-7c7f-9a60-82a1f6d7b23b | €49.00 | €0.67 | matched |
| 117 | capture | 01a19a7b-16c7-7e61-917c-4c5034111a63 | €35.00 | €0.50 | matched |
| 118 | refund | 01a19a7b-1792-7f64-ae36-dbc8ecb13815 | -€17.00 | €0.00 | matched |
| 119 | refund | 01a19a7b-4555-7cd6-9f63-37439e5f7bc8 | -€17.00 | €0.00 | matched |
| 120 | capture | 01a19a7b-4586-7137-8e4f-5abdd6ccc82a | €24.00 | €0.37 | matched |
| 121 | capture | 01a19a7b-4c25-74ec-9245-56fcda46296a | €35.00 | €0.50 | matched |
| 122 | capture | 01a19a7b-4cd9-778d-a355-65378b8ea388 | €49.00 | €0.67 | matched |
| 123 | capture | 01a19a7b-5d81-7ef6-ab84-3da66d0188bf | €49.00 | €0.67 | matched |
| 124 | capture | 01a19a7b-625c-7cda-a6a5-14f63c026ea4 | €35.00 | €0.50 | matched |
| 125 | capture | 01a19a7b-6e45-71f5-b2c1-abfacd412de7 | €35.00 | €0.50 | matched |
| 126 | capture | 01a19a7b-8c33-7aab-ad63-39943c915641 | €24.00 | €0.37 | matched |
| 127 | capture | 01a19a7b-a0e6-7de8-a0e2-70b8b0cf05cc | €49.00 | €0.67 | matched |
| 128 | capture | 01a19a7b-acae-7dd8-b60f-abc9238f361a | €35.00 | €0.50 | matched |
| 129 | capture | 01a19a7b-ea95-746e-9db0-d31d3f434620 | €35.00 | €0.50 | matched |
| 130 | capture | 01a19a7c-2687-7dda-acdf-2925896b9fda | €35.00 | €0.50 | matched |