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
- 4 Nov, 23:50141 lines2 breaks
- 4 Nov, 23:40123 lines5 breaks
- 4 Nov, 23:30133 lines3 breaks
- 4 Nov, 23:20109 lines3 breaks
- 4 Nov, 23:10117 lines3 breaks
- 4 Nov, 23:00119 linesclean
- 4 Nov, 22:50159 lines2 breaks
- 4 Nov, 22:40111 lines1 break
- 4 Nov, 22:30117 lines3 breaks
- 4 Nov, 22:20116 lines2 breaks
- 4 Nov, 22:10118 lines2 breaks
- 4 Nov, 22:00145 lines6 breaks
- 4 Nov, 21:50111 lines2 breaks
- 4 Nov, 21:40137 lines3 breaks
4 Nov, 21:40
Gross
€3,208.00
PSP fee
€50.42
Net to the bank
€3,157.58
Settlement journal
#386350
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a881-5722-7f08-a19e-dac63d9886de is already settled by stl_EUR_2989714 line 5
- duplicate linethe file lists it twicecapture:01a1a889-c972-7ce9-884a-a2ba3925ff20 is already settled by stl_EUR_2989714 line 127
- missing linein the books, not in the filecapture:01a1a881-47e4-7b37-837a-91b6222e0f89 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 6 | capture | 01a1a881-5751-763a-970e-4846f1bcf93e | €35.00 | €0.50 | duplicate line |
| 128 | capture | 01a1a889-c98b-7c27-a4d1-822dfbfbfade | €15.00 | €0.26 | duplicate line |
| 1 | capture | 01a1a87d-944c-75f6-99cc-625646b7df71 | €15.00 | €0.26 | matched |
| 2 | capture | 01a1a87e-27c5-7f39-9c3d-cdb9e03ce72e | €24.00 | €0.37 | matched |
| 3 | capture | 01a1a881-4e7c-703c-8146-23657a97974f | €49.00 | €0.67 | matched |
| 4 | capture | 01a1a881-5655-7691-a336-6fb4c583e47b | €49.00 | €0.67 | matched |
| 5 | capture | 01a1a881-5751-763a-970e-4846f1bcf93e | €35.00 | €0.50 | matched |
| 7 | capture | 01a1a881-5d32-7423-96f6-10b71344d101 | €15.00 | €0.26 | matched |
| 8 | capture | 01a1a881-75f4-7dd2-9b08-2eb10a8854e4 | €49.00 | €0.67 | matched |
| 9 | capture | 01a1a881-7e9e-7f36-9303-3027585ff46b | €24.00 | €0.37 | matched |
| 10 | capture | 01a1a881-88eb-7b1d-9a9c-9c8ca264d119 | €35.00 | €0.50 | matched |
| 11 | capture | 01a1a881-d079-7ff3-bb2b-d71e313c7026 | €49.00 | €0.67 | matched |
| 12 | capture | 01a1a881-d42e-7a49-801e-64164fc8d780 | €24.00 | €0.37 | matched |
| 13 | capture | 01a1a881-d5a8-7e8b-b0d7-c2f884a18314 | €35.00 | €0.50 | matched |
| 14 | capture | 01a1a882-13f1-7a9b-a85c-0cf63799a33a | €49.00 | €0.67 | matched |
| 15 | capture | 01a1a882-31b6-7a08-93eb-8648259b10df | €9.00 | €0.19 | matched |
| 16 | capture | 01a1a882-4980-7fcb-be84-f9bc9f4019b0 | €49.00 | €0.67 | matched |
| 17 | capture | 01a1a882-7d42-7bd7-997b-6a89301ebefd | €9.00 | €0.19 | matched |
| 18 | capture | 01a1a882-9f4b-7fa2-b3fa-aeff8f01f814 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1a883-0b5a-7eef-bfad-bcc3b3a99e54 | €15.00 | €0.26 | matched |
| 20 | capture | 01a1a883-2087-74fc-a542-790f7d9502ba | €15.00 | €0.26 | matched |
| 21 | capture | 01a1a883-2389-7750-a7f2-ff715938d4c1 | €9.00 | €0.19 | matched |
| 22 | capture | 01a1a883-2515-77f9-abe6-a7043e883a51 | €35.00 | €0.50 | matched |
| 23 | capture | 01a1a883-2b77-7f3b-a4bb-abe13b2b9f08 | €15.00 | €0.26 | matched |
| 24 | capture | 01a1a883-2c13-7ea7-ab63-aba2bdef1fc2 | €24.00 | €0.37 | matched |
| 25 | capture | 01a1a883-3585-79e6-aa0c-9fb79cc7eb8e | €9.00 | €0.19 | matched |
| 26 | capture | 01a1a883-45fa-7811-a40f-d5f6ec189bf7 | €24.00 | €0.37 | matched |
| 27 | capture | 01a1a883-5089-797e-bdcb-3ae4a6a08bb6 | €15.00 | €0.26 | matched |
| 28 | capture | 01a1a883-66f5-71ba-8556-b8b0a4f5ad3d | €9.00 | €0.19 | matched |
| 29 | capture | 01a1a883-77f7-7b37-87ab-2bcf24fa60a6 | €49.00 | €0.67 | matched |
| 30 | capture | 01a1a883-7d90-725e-ae24-1de695a1f765 | €49.00 | €0.67 | matched |
| 31 | capture | 01a1a883-7d9e-709c-b0b7-dd87196c3a2e | €15.00 | €0.26 | matched |
| 32 | capture | 01a1a883-8dba-7f7c-917c-31521125a4b2 | €24.00 | €0.37 | matched |
| 33 | capture | 01a1a883-9b67-73d5-a8bd-e764a4e9bbbd | €24.00 | €0.37 | matched |
| 34 | capture | 01a1a883-9bd3-7526-8f2d-f6fcee510985 | €35.00 | €0.50 | matched |
| 35 | capture | 01a1a883-9c3b-799c-976a-041b381fdf0a | €35.00 | €0.50 | matched |
| 36 | capture | 01a1a883-a0cc-7d1e-a774-d298199ec4a5 | €24.00 | €0.37 | matched |
| 37 | capture | 01a1a883-abd8-755b-801b-9524555a3d37 | €9.00 | €0.19 | matched |
| 38 | capture | 01a1a883-ba35-7595-b35a-8dd180b287e4 | €35.00 | €0.50 | matched |
| 39 | capture | 01a1a883-bf37-769c-a74b-e6998df3123f | €24.00 | €0.37 | matched |
| 40 | capture | 01a1a883-c6f7-73aa-9a48-4108a0cca598 | €15.00 | €0.26 | matched |
| 41 | refund | 01a1a883-c95a-7bed-b907-224574f5552b | -€17.00 | €0.00 | matched |
| 42 | capture | 01a1a883-de98-701a-82f2-208a7e52ed6c | €35.00 | €0.50 | matched |
| 43 | capture | 01a1a883-e603-7398-8932-3545964cac85 | €49.00 | €0.67 | matched |
| 44 | capture | 01a1a883-ed2e-7549-8a83-24578633bf15 | €9.00 | €0.19 | matched |
| 45 | capture | 01a1a883-eddc-7537-8805-66735e1c1e3e | €49.00 | €0.67 | matched |
| 46 | capture | 01a1a884-0a8e-7c7b-9415-d297e252099b | €15.00 | €0.26 | matched |
| 47 | capture | 01a1a884-085f-7969-be94-ca35bd8c6891 | €49.00 | €0.67 | matched |
| 48 | refund | 01a1a884-1e36-7983-8dbf-a10682738feb | -€27.00 | €0.00 | matched |
| 49 | capture | 01a1a884-2cf8-788f-81fc-2b8b17363696 | €24.00 | €0.37 | matched |
| 50 | capture | 01a1a884-3938-711f-9b35-80cce01d9f66 | €9.00 | €0.19 | matched |
| 51 | capture | 01a1a884-39e9-7259-a1b6-71f93e5c513e | €15.00 | €0.26 | matched |
| 52 | capture | 01a1a884-68a3-762e-818c-c6bce1a523c8 | €35.00 | €0.50 | matched |
| 53 | capture | 01a1a884-80a9-74fe-a828-074e03a37e82 | €9.00 | €0.19 | matched |
| 54 | capture | 01a1a884-9ddb-7d47-8d68-c9780eee96ef | €15.00 | €0.26 | matched |
| 55 | capture | 01a1a884-af8e-73c1-a7da-3a81878a3968 | €35.00 | €0.50 | matched |
| 56 | capture | 01a1a884-b055-750e-bb20-90b0c52d42cc | €24.00 | €0.37 | matched |
| 57 | capture | 01a1a884-b088-7739-869c-5e97049bd8bc | €24.00 | €0.37 | matched |
| 58 | capture | 01a1a884-bc33-723c-8169-1af381e3a581 | €35.00 | €0.50 | matched |
| 59 | capture | 01a1a884-f474-7b32-828f-0eb7d0d2d757 | €35.00 | €0.50 | matched |
| 60 | capture | 01a1a884-f5db-73f3-8653-49959e67baf6 | €9.00 | €0.19 | matched |
| 61 | capture | 01a1a884-f644-79d2-a0e5-c7f631ae6509 | €15.00 | €0.26 | matched |
| 62 | capture | 01a1a885-158b-7cf2-9a42-56d208773a6a | €9.00 | €0.19 | matched |
| 63 | capture | 01a1a885-21d7-71f6-b101-6b778f41073e | €9.00 | €0.19 | matched |
| 64 | capture | 01a1a885-7556-78b3-b19f-7386a13d7286 | €24.00 | €0.37 | matched |
| 65 | capture | 01a1a885-8ef1-7e26-9f1b-36c0a2d1e201 | €24.00 | €0.37 | matched |
| 66 | capture | 01a1a885-ba4c-7e40-a1e5-2932c24d6f14 | €9.00 | €0.19 | matched |
| 67 | capture | 01a1a885-ce45-7963-b318-b61df4c572da | €49.00 | €0.67 | matched |
| 68 | refund | 01a1a885-f6eb-7911-ba01-c303548d21c0 | -€27.00 | €0.00 | matched |
| 69 | capture | 01a1a885-faae-74f6-8462-debb801d840f | €15.00 | €0.26 | matched |
| 70 | capture | 01a1a886-1acf-7117-ab78-38d9016d8d48 | €9.00 | €0.19 | matched |
| 71 | capture | 01a1a886-1bdb-7d67-b743-367871ee0a28 | €49.00 | €0.67 | matched |
| 72 | capture | 01a1a886-1d18-7145-b255-3d77341c4fde | €9.00 | €0.19 | matched |
| 73 | capture | 01a1a886-3393-7763-b012-a92373191332 | €49.00 | €0.67 | matched |
| 74 | capture | 01a1a886-3a03-76c9-aca1-865ebb38706b | €49.00 | €0.67 | matched |
| 75 | capture | 01a1a886-534c-7038-9fc6-4a1f6a729b97 | €24.00 | €0.37 | matched |
| 76 | capture | 01a1a886-5639-74c2-acfb-e9678c6d4a28 | €9.00 | €0.19 | matched |
| 77 | capture | 01a1a886-68c9-754d-917b-67fe8a2ebf55 | €9.00 | €0.19 | matched |
| 78 | capture | 01a1a886-7208-7f17-8af8-618d4a538a77 | €9.00 | €0.19 | matched |
| 79 | capture | 01a1a886-8b6e-74d2-a127-bf8a30f70c5a | €49.00 | €0.67 | matched |
| 80 | capture | 01a1a886-948b-79c2-a572-6ec9a4b80024 | €9.00 | €0.19 | matched |
| 81 | capture | 01a1a886-99a6-7da2-9788-71080eb5695b | €35.00 | €0.50 | matched |
| 82 | capture | 01a1a886-a510-71c9-8437-fb04909c997f | €9.00 | €0.19 | matched |
| 83 | capture | 01a1a886-abde-777c-bdd0-3a12aafca1d5 | €35.00 | €0.50 | matched |
| 84 | capture | 01a1a886-b3e1-76aa-8a76-ff72c242039a | €15.00 | €0.26 | matched |
| 85 | capture | 01a1a886-c289-7ce7-805a-7f535830afeb | €24.00 | €0.37 | matched |
| 86 | capture | 01a1a886-d88c-7cce-8997-41037f676f20 | €15.00 | €0.26 | matched |
| 87 | capture | 01a1a886-fbd3-70d8-a099-36d585c59ec6 | €24.00 | €0.37 | matched |
| 88 | refund | 01a1a886-ff74-7704-867f-6559fb9a7aef | -€12.00 | €0.00 | matched |
| 89 | capture | 01a1a887-0299-76e1-bb61-2b557844a195 | €49.00 | €0.67 | matched |
| 90 | capture | 01a1a887-0d8a-7c95-834a-3431a5de3e89 | €24.00 | €0.37 | matched |
| 91 | capture | 01a1a887-51a1-7a0a-a60c-5b6aabeee8df | €49.00 | €0.67 | matched |
| 92 | capture | 01a1a887-5b47-72ae-b909-49b83d0e647d | €9.00 | €0.19 | matched |
| 93 | capture | 01a1a887-7ffb-74db-ab56-4ec560bd469f | €9.00 | €0.19 | matched |
| 94 | capture | 01a1a887-86bf-7613-8f8b-5a6d683b097f | €15.00 | €0.26 | matched |
| 95 | capture | 01a1a887-964a-7dc6-a53a-c33eaa2e5c91 | €15.00 | €0.26 | matched |
| 96 | capture | 01a1a887-e454-70de-ae1a-928857cfe9b8 | €24.00 | €0.37 | matched |
| 97 | capture | 01a1a887-edb6-746d-9798-1b96e36e19d9 | €24.00 | €0.37 | matched |
| 98 | capture | 01a1a887-ede5-7a69-9f86-5d1c33bf27be | €24.00 | €0.37 | matched |
| 99 | capture | 01a1a887-edf2-762d-864e-e151f64ce1de | €15.00 | €0.26 | matched |
| 100 | capture | 01a1a887-f1db-7ab7-9d50-8f0715a2c4e8 | €35.00 | €0.50 | matched |
| 101 | capture | 01a1a888-0e7e-7339-b0e8-c9b7a515068a | €35.00 | €0.50 | matched |
| 102 | capture | 01a1a888-18b6-75c3-91d4-926cadbc9c96 | €35.00 | €0.50 | matched |
| 103 | capture | 01a1a888-2755-7941-ba0f-a95807dc702a | €24.00 | €0.37 | matched |
| 104 | capture | 01a1a888-45eb-726a-b80f-169d4ee2a4b5 | €15.00 | €0.26 | matched |
| 105 | capture | 01a1a888-68a1-79b4-be58-12d5fff65c95 | €15.00 | €0.26 | matched |
| 106 | capture | 01a1a888-7c3d-755b-9977-1ad7904f4572 | €49.00 | €0.67 | matched |
| 107 | capture | 01a1a888-86c3-792e-a155-273961c4d523 | €9.00 | €0.19 | matched |
| 108 | capture | 01a1a888-88dc-70b9-a8e3-13ed1b7e91ab | €15.00 | €0.26 | matched |
| 109 | capture | 01a1a888-ac5d-792c-a1ae-64d752cac122 | €15.00 | €0.26 | matched |
| 110 | capture | 01a1a888-d069-7c1a-93e2-1aa9ab4d838a | €24.00 | €0.37 | matched |
| 111 | capture | 01a1a888-cc6d-7e1a-9c23-7a81822c0ee8 | €24.00 | €0.37 | matched |
| 112 | capture | 01a1a888-d81a-7550-9fa0-fa3bec0613a9 | €9.00 | €0.19 | matched |
| 113 | capture | 01a1a888-de8c-7d70-8b3d-6d3b0d08ffa5 | €49.00 | €0.67 | matched |
| 114 | capture | 01a1a888-e6c2-7305-979b-68dac7ae9a92 | €15.00 | €0.26 | matched |
| 115 | capture | 01a1a888-ea75-7365-9b28-06542dec4587 | €49.00 | €0.67 | matched |
| 116 | capture | 01a1a888-faca-7f9c-8981-cf0377711dc8 | €24.00 | €0.37 | matched |
| 117 | capture | 01a1a889-21a0-7c52-876e-0cc4d267ddc8 | €9.00 | €0.19 | matched |
| 118 | refund | 01a1a889-253b-743d-9b0e-34c5bebebd7e | -€7.00 | €0.00 | matched |
| 119 | capture | 01a1a889-1158-7c3a-aeec-a9c44c91b28c | €49.00 | €0.67 | matched |
| 120 | capture | 01a1a889-3b33-72b7-af17-38c9330687be | €35.00 | €0.50 | matched |
| 121 | capture | 01a1a889-3c8a-7f41-a2c0-cdc6f45845ad | €49.00 | €0.67 | matched |
| 122 | capture | 01a1a889-583d-7e12-929f-108d6bc36641 | €35.00 | €0.50 | matched |
| 123 | capture | 01a1a889-6811-7a35-804a-a414a7febb16 | €24.00 | €0.37 | matched |
| 124 | capture | 01a1a889-6925-7f21-9476-2f56afd84c75 | €24.00 | €0.37 | matched |
| 125 | capture | 01a1a889-9543-7eee-addb-e7ad0edd73dc | €15.00 | €0.26 | matched |
| 126 | capture | 01a1a889-a07b-7924-8dd7-0bff032163ff | €15.00 | €0.26 | matched |
| 127 | capture | 01a1a889-c98b-7c27-a4d1-822dfbfbfade | €15.00 | €0.26 | matched |
| 129 | capture | 01a1a889-d4b9-73e5-bd90-1215abbbb500 | €35.00 | €0.50 | matched |
| 130 | capture | 01a1a889-fd60-7877-87e7-5f1f41aa15c8 | €9.00 | €0.19 | matched |
| 131 | capture | 01a1a88a-07c1-749f-ae51-7936f6b77b1b | €35.00 | €0.50 | matched |
| 132 | capture | 01a1a88a-356b-791c-a909-e9dd5bc6365e | €24.00 | €0.37 | matched |
| 133 | capture | 01a1a88a-3933-7423-986c-87ab5a055e14 | €24.00 | €0.37 | matched |
| 134 | capture | 01a1a88a-3950-7a64-8a84-7a7f0822e587 | €15.00 | €0.26 | matched |
| 135 | capture | 01a1a88a-39d1-717b-ad18-616d2f6deb37 | €24.00 | €0.37 | matched |
| 136 | refund | 01a1a88a-43c2-7e47-bbdb-25d77389ef15 | -€17.00 | €0.00 | matched |
| 137 | capture | 01a1a88a-48a7-7538-b59d-0f7545bcd1a4 | €35.00 | €0.50 | matched |