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, 11:20
Gross
€3,250.00
PSP fee
€51.46
Net to the bank
€3,198.54
Settlement journal
#13782
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13f4d-80ab-78fd-8f7e-cfa785ee863f is already settled by stl_EUR_2986772 line 58
- duplicate linethe file lists it twicecapture:01a13f4d-dd1e-7247-a7d0-2552935f618e is already settled by stl_EUR_2986772 line 66
- fee differencethe fee is not the contract feethe fee is 70, the contract says 67
- missing linein the books, not in the filerefund:01a13f4a-7276-792a-a70e-ea87c4c92dff is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 2 | capture | 01a13f44-ee87-7f26-9140-9b0326b7b5b5 | €49.00 | €0.67 | duplicate line |
| 45 | capture | 01a13f4c-a104-78d2-b7c7-5cecef4ce45a | €49.00 | €0.70 | fee difference |
| 59 | capture | 01a13f4d-8106-7584-9d1e-098da2a2a4ef | €9.00 | €0.19 | duplicate line |
| 67 | capture | 01a13f4d-dd6d-7f20-86d4-80daba0939d3 | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a13f44-ee87-7f26-9140-9b0326b7b5b5 | €49.00 | €0.67 | matched |
| 3 | capture | 01a13f45-3683-7ca1-8d67-47fe0d4ebd08 | €49.00 | €0.67 | matched |
| 4 | capture | 01a13f4a-5bf6-7386-b8e3-314ba6a986c4 | €49.00 | €0.67 | matched |
| 5 | capture | 01a13f4a-800d-7593-a09a-7da082bbe05a | €15.00 | €0.26 | matched |
| 6 | capture | 01a13f4a-8312-7bb1-909e-c93b742ce3c1 | €24.00 | €0.37 | matched |
| 7 | capture | 01a13f4a-8283-78b6-89ac-46e4b653df0f | €24.00 | €0.37 | matched |
| 8 | capture | 01a13f4a-aa4c-76be-96c4-1c9cb681e1c9 | €15.00 | €0.26 | matched |
| 9 | capture | 01a13f4a-b786-78c5-aac2-1143e6e9e1db | €35.00 | €0.50 | matched |
| 10 | capture | 01a13f4a-c0e5-7a7d-9d11-9d004c9a016a | €24.00 | €0.37 | matched |
| 11 | capture | 01a13f4a-c119-7ba2-8079-bd5dd7acbe90 | €35.00 | €0.50 | matched |
| 12 | capture | 01a13f4a-df37-741f-bc0a-d8d3876d2f70 | €24.00 | €0.37 | matched |
| 13 | capture | 01a13f4a-ee00-73a3-9fe8-073aeb4912e7 | €35.00 | €0.50 | matched |
| 14 | capture | 01a13f4b-048f-7b84-941c-14a0495ba6c6 | €15.00 | €0.26 | matched |
| 15 | capture | 01a13f4b-0917-7778-8699-ca20e4f11d12 | €15.00 | €0.26 | matched |
| 16 | capture | 01a13f4b-0b47-7abf-9351-9ef476706d4c | €49.00 | €0.67 | matched |
| 17 | capture | 01a13f4b-15e5-7c3f-ba05-80c6e067e56d | €24.00 | €0.37 | matched |
| 18 | capture | 01a13f4b-30bd-7881-8368-29f4971820b7 | €35.00 | €0.50 | matched |
| 19 | capture | 01a13f4b-3303-708b-9288-beb42807123c | €24.00 | €0.37 | matched |
| 20 | capture | 01a13f4b-510f-76c5-a932-41b5d85b19e1 | €24.00 | €0.37 | matched |
| 21 | capture | 01a13f4b-77ef-7d77-b088-d9c79f9dd40d | €9.00 | €0.19 | matched |
| 22 | capture | 01a13f4b-80bd-710f-ac96-e126469cc280 | €9.00 | €0.19 | matched |
| 23 | capture | 01a13f4b-887e-7bef-a8dd-4985fd17e01b | €24.00 | €0.37 | matched |
| 24 | capture | 01a13f4b-a231-7697-8365-464ea2010d49 | €35.00 | €0.50 | matched |
| 25 | capture | 01a13f4b-afae-701a-b224-dad7eb67674a | €35.00 | €0.50 | matched |
| 26 | capture | 01a13f4b-b3af-716b-b8ae-ed279b6377fc | €9.00 | €0.19 | matched |
| 27 | capture | 01a13f4b-b5bc-7983-a80e-6667fc1a6db5 | €15.00 | €0.26 | matched |
| 28 | refund | 01a13f4b-b7b8-75e5-9911-bdfdb4a02657 | -€7.00 | €0.00 | matched |
| 29 | capture | 01a13f4b-bd17-7bc1-b7aa-697f669366dd | €35.00 | €0.50 | matched |
| 30 | capture | 01a13f4b-d6f7-7e92-ae7c-a481abe3f5ad | €49.00 | €0.67 | matched |
| 31 | capture | 01a13f4b-d8b2-7b69-bf8e-3b65872a4034 | €49.00 | €0.67 | matched |
| 32 | capture | 01a13f4b-f2a6-7f12-8728-0ee07b64b521 | €35.00 | €0.50 | matched |
| 33 | capture | 01a13f4c-04b4-73c1-8f82-40eb4f401692 | €15.00 | €0.26 | matched |
| 34 | refund | 01a13f4c-12aa-7310-a583-768e8c2d197f | -€45.00 | €0.00 | matched |
| 35 | capture | 01a13f4c-157b-738b-8085-9d436de73fdc | €35.00 | €0.50 | matched |
| 36 | capture | 01a13f4c-1854-7a94-b783-52db181a7cbb | €9.00 | €0.19 | matched |
| 37 | capture | 01a13f4c-2295-7eea-9d14-5ec4cd965c5e | €24.00 | €0.37 | matched |
| 38 | capture | 01a13f4c-3a41-7248-8d4e-ff3a9224ed11 | €49.00 | €0.67 | matched |
| 39 | capture | 01a13f4c-489f-71f8-aeff-6cceffd27599 | €24.00 | €0.37 | matched |
| 40 | capture | 01a13f4c-5ea4-7ed3-a3ab-1ca4ba2a7d2f | €49.00 | €0.67 | matched |
| 41 | capture | 01a13f4c-6565-725c-a875-cede0b2c30b4 | €35.00 | €0.50 | matched |
| 42 | capture | 01a13f4c-762e-739f-83a9-72d64f921487 | €9.00 | €0.19 | matched |
| 43 | capture | 01a13f4c-77b1-71cf-bea7-a47e28a0526e | €35.00 | €0.50 | matched |
| 44 | capture | 01a13f4c-9cf3-7ab5-92f5-0b30c5735602 | €49.00 | €0.67 | matched |
| 46 | capture | 01a13f4c-b1c7-7f83-95ec-74ec56556468 | €15.00 | €0.26 | matched |
| 47 | refund | 01a13f4c-b45a-7f69-89bf-c080718ac2a3 | -€18.00 | €0.00 | matched |
| 48 | capture | 01a13f4d-0416-7da8-93a6-a682b1bbcc3f | €15.00 | €0.26 | matched |
| 49 | capture | 01a13f4d-1cf9-7217-b0f0-fde7d86c13a8 | €24.00 | €0.37 | matched |
| 50 | capture | 01a13f4d-282f-74ec-80f5-6d54c467e1db | €24.00 | €0.37 | matched |
| 51 | capture | 01a13f4d-31b4-7e85-931d-904ca447da00 | €35.00 | €0.50 | matched |
| 52 | capture | 01a13f4d-3c1e-7bb4-86ce-a8bb6b1bb6b2 | €15.00 | €0.26 | matched |
| 53 | capture | 01a13f4d-3e1b-78a6-bbad-b80cf46ba3ce | €24.00 | €0.37 | matched |
| 54 | capture | 01a13f4d-2c4e-792a-8cc4-0b8d8b214239 | €9.00 | €0.19 | matched |
| 55 | capture | 01a13f4d-4cc7-7e04-8319-e12ed8a873ab | €35.00 | €0.50 | matched |
| 56 | capture | 01a13f4d-5411-71e9-86bf-cbdeb86ea85f | €35.00 | €0.50 | matched |
| 57 | capture | 01a13f4d-7573-79b9-a1c9-72aee0b5ab33 | €15.00 | €0.26 | matched |
| 58 | capture | 01a13f4d-8106-7584-9d1e-098da2a2a4ef | €9.00 | €0.19 | matched |
| 60 | capture | 01a13f4d-8c77-7f76-a334-83611de5b6db | €15.00 | €0.26 | matched |
| 61 | capture | 01a13f4d-95ba-7124-ae16-a1afc0c9e707 | €24.00 | €0.37 | matched |
| 62 | capture | 01a13f4d-9b10-7634-bab6-ee9c7107c532 | €9.00 | €0.19 | matched |
| 63 | capture | 01a13f4d-b8ef-7995-8b0f-260cc3e39e68 | €24.00 | €0.37 | matched |
| 64 | capture | 01a13f4d-cbe9-764a-9f05-51ccda84996f | €9.00 | €0.19 | matched |
| 65 | capture | 01a13f4d-d65d-75a6-88e4-e04cc5e010af | €24.00 | €0.37 | matched |
| 66 | capture | 01a13f4d-dd6d-7f20-86d4-80daba0939d3 | €35.00 | €0.50 | matched |
| 68 | capture | 01a13f4d-e87e-7a8f-85f9-4b16416e2b8b | €9.00 | €0.19 | matched |
| 69 | refund | 01a13f4d-fefc-77eb-a27c-868a270a03b2 | -€7.00 | €0.00 | matched |
| 70 | capture | 01a13f4e-02cc-749e-9c4c-6403ef5d3a71 | €35.00 | €0.50 | matched |
| 71 | capture | 01a13f4e-0313-773a-bc16-160b9f38fd78 | €49.00 | €0.67 | matched |
| 72 | refund | 01a13f4e-0c41-78d7-8192-4c5a94fafa9f | -€16.00 | €0.00 | matched |
| 73 | capture | 01a13f4e-4b65-7582-998d-ba4655b5df0e | €24.00 | €0.37 | matched |
| 74 | capture | 01a13f4e-50ad-70ad-b4cf-6a4ec6f9b9dd | €9.00 | €0.19 | matched |
| 75 | capture | 01a13f4e-6428-73bf-b015-6e0427b085c9 | €35.00 | €0.50 | matched |
| 76 | capture | 01a13f4e-7a8e-7360-a69b-7d7f35c31cf8 | €24.00 | €0.37 | matched |
| 77 | capture | 01a13f4e-a055-7e2a-9676-3cc4c4663484 | €24.00 | €0.37 | matched |
| 78 | capture | 01a13f4e-a79e-774c-b735-9f4db35320ca | €9.00 | €0.19 | matched |
| 79 | capture | 01a13f4e-a8c9-7781-a307-b3f8f0ee3708 | €15.00 | €0.26 | matched |
| 80 | capture | 01a13f4e-ac9b-729f-ba61-5a80eef888ac | €24.00 | €0.37 | matched |
| 81 | refund | 01a13f4e-b125-72e0-8384-17e7815d2579 | -€6.00 | €0.00 | matched |
| 82 | capture | 01a13f4e-c817-730f-b74c-50b0fc5644e5 | €24.00 | €0.37 | matched |
| 83 | capture | 01a13f4e-d784-7f2c-8788-dc6c3eda2666 | €24.00 | €0.37 | matched |
| 84 | capture | 01a13f4e-e196-759e-9b92-9ef593fd8279 | €35.00 | €0.50 | matched |
| 85 | capture | 01a13f4f-0bcc-770a-b8bd-b959e05baf19 | €9.00 | €0.19 | matched |
| 86 | capture | 01a13f4f-17a5-780c-b126-0eca6d90def5 | €49.00 | €0.67 | matched |
| 87 | capture | 01a13f4f-2b3f-7f64-a752-d859e55845fd | €15.00 | €0.26 | matched |
| 88 | capture | 01a13f4f-4301-7567-9028-742ef277d54f | €49.00 | €0.67 | matched |
| 89 | capture | 01a13f4f-4812-7b4a-9ef9-d7e3b2fcabfb | €9.00 | €0.19 | matched |
| 90 | capture | 01a13f4f-5d24-7349-9729-6f6688f88711 | €24.00 | €0.37 | matched |
| 91 | capture | 01a13f4f-76e9-7a7c-94a3-86091ff8a3a3 | €15.00 | €0.26 | matched |
| 92 | capture | 01a13f4f-8899-798c-ac36-68fbfc3995c3 | €24.00 | €0.37 | matched |
| 93 | capture | 01a13f4f-9198-7202-bbf8-a5bb0d5d7c30 | €15.00 | €0.26 | matched |
| 94 | capture | 01a13f4f-a10b-7d91-83e2-dc5e053a35b6 | €15.00 | €0.26 | matched |
| 95 | capture | 01a13f4f-bdc2-79b3-b4cc-fabcb3239798 | €49.00 | €0.67 | matched |
| 96 | capture | 01a13f4f-c26b-72d8-88c0-ac4aa242755b | €35.00 | €0.50 | matched |
| 97 | capture | 01a13f4f-d51b-78d2-8f9f-52eff9e31a0a | €35.00 | €0.50 | matched |
| 98 | capture | 01a13f4f-f50e-7495-b822-bd2cabe81b04 | €35.00 | €0.50 | matched |
| 99 | refund | 01a13f50-2022-73d4-9bd4-69e04e6dbb52 | -€28.00 | €0.00 | matched |
| 100 | capture | 01a13f50-2e5a-7510-a93b-95aea4388b40 | €9.00 | €0.19 | matched |
| 101 | capture | 01a13f50-6038-723f-8269-b8c5732b3a62 | €24.00 | €0.37 | matched |
| 102 | capture | 01a13f50-6721-7556-99db-eb2a7a6e550b | €15.00 | €0.26 | matched |
| 103 | capture | 01a13f50-7bf4-731a-8f64-db5d06f3c423 | €35.00 | €0.50 | matched |
| 104 | capture | 01a13f50-9b26-757f-8d01-084cd48d0ca4 | €49.00 | €0.67 | matched |
| 105 | capture | 01a13f50-c918-78a1-8bf9-7157ffe32849 | €49.00 | €0.67 | matched |
| 106 | capture | 01a13f50-c90c-7f88-92c5-9800726c703a | €9.00 | €0.19 | matched |
| 107 | capture | 01a13f50-d6d4-7013-abb7-e945bec33772 | €24.00 | €0.37 | matched |
| 108 | capture | 01a13f50-df65-7184-ba68-306bbb009154 | €15.00 | €0.26 | matched |
| 109 | capture | 01a13f50-e07c-7674-8779-8df52c5abf74 | €49.00 | €0.67 | matched |
| 110 | capture | 01a13f50-e840-7984-b823-61673826dcf1 | €9.00 | €0.19 | matched |
| 111 | capture | 01a13f50-fa1f-71fc-bea6-4951a7fdbd88 | €35.00 | €0.50 | matched |
| 112 | capture | 01a13f51-25c3-7fbf-90cf-4adc4b86162c | €49.00 | €0.67 | matched |
| 113 | capture | 01a13f51-3428-7cf6-b5bc-f69b5af8b1b9 | €9.00 | €0.19 | matched |
| 114 | capture | 01a13f51-7765-7e99-a290-002cdca17951 | €24.00 | €0.37 | matched |
| 115 | capture | 01a13f51-a967-7f17-b3be-1ddcf3f041d4 | €35.00 | €0.50 | matched |
| 116 | capture | 01a13f51-efad-779d-ae79-94a537d796d2 | €24.00 | €0.37 | matched |
| 117 | capture | 01a13f51-ffbe-7489-aad1-1441443e380d | €49.00 | €0.67 | matched |
| 118 | capture | 01a13f52-147e-7f66-9a4f-4eba4877de4b | €24.00 | €0.37 | matched |
| 119 | capture | 01a13f52-15aa-7343-8079-d5d3370b9d55 | €9.00 | €0.19 | matched |
| 120 | capture | 01a13f52-173b-7225-9376-ce570edaeaef | €24.00 | €0.37 | matched |
| 121 | capture | 01a13f52-17a9-7522-b86e-4754b54c27db | €35.00 | €0.50 | matched |
| 122 | capture | 01a13f52-35d8-7409-8b32-740e7b59b054 | €35.00 | €0.50 | matched |
| 123 | capture | 01a13f52-5b3c-7409-b1e2-5591627f5ca6 | €9.00 | €0.19 | matched |
| 124 | capture | 01a13f52-61d5-784b-a3d8-85dbf5c2e6b0 | €9.00 | €0.19 | matched |
| 125 | capture | 01a13f52-b223-7b0e-9bc7-ed64b842d1a9 | €49.00 | €0.67 | matched |
| 126 | capture | 01a13f52-cb2e-7fab-bf0f-31c14bae5b0b | €15.00 | €0.26 | matched |
| 127 | capture | 01a13f52-cb97-7977-83fe-ac982a037591 | €9.00 | €0.19 | matched |
| 128 | capture | 01a13f52-ce6c-763a-97e1-a2faba5a8261 | €9.00 | €0.19 | matched |
| 129 | refund | 01a13f52-e279-79aa-bd45-3010ebc43fb2 | -€42.00 | €0.00 | matched |
| 130 | capture | 01a13f53-11d7-7cf7-916b-4234c9f56d7f | €9.00 | €0.19 | matched |
| 131 | capture | 01a13f53-225e-75f5-a6c3-03d7b080541d | €35.00 | €0.50 | matched |
| 132 | capture | 01a13f53-277b-7e71-b498-c0748bcdc123 | €9.00 | €0.19 | matched |
| 133 | capture | 01a13f53-2c6d-77c9-89aa-ff758c1a13d0 | €49.00 | €0.67 | matched |
| 134 | capture | 01a13f53-35bb-7b95-a0e3-7a3775f3f3c0 | €49.00 | €0.67 | matched |
| 135 | capture | 01a13f53-5a36-74a6-9691-e28d302508c5 | €49.00 | €0.67 | matched |
| 136 | capture | 01a13f53-626c-7f7e-9588-1eb28371c205 | €24.00 | €0.37 | matched |