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
- 28 Oct, 15:50136 lines4 breaks
- 28 Oct, 15:40134 lines2 breaks
- 28 Oct, 15:30118 lines2 breaks
- 28 Oct, 15:20117 lines2 breaks
- 28 Oct, 15:10111 linesclean
- 28 Oct, 15:00132 linesclean
- 28 Oct, 14:50121 lines3 breaks
- 28 Oct, 14:40125 lines3 breaks
- 28 Oct, 14:30124 linesclean
- 28 Oct, 14:2087 linesclean
- 28 Oct, 14:10127 lines4 breaks
- 28 Oct, 14:00124 lines2 breaks
- 28 Oct, 13:50117 lines2 breaks
- 28 Oct, 13:40113 lines1 break
28 Oct, 14:50
Gross
€2,771.00
PSP fee
€44.66
Net to the bank
€2,726.34
Settlement journal
#252950
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18303-31e4-7987-b40b-202d5c6f730c is already settled by stl_EUR_2988665 line 76
- duplicate linethe file lists it twicecapture:01a18305-4c2a-7c83-8697-05eb65318076 is already settled by stl_EUR_2988665 line 108
- missing linein the books, not in the filecapture:01a18300-0356-7891-a27a-4908832da84c is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 77 | capture | 01a18303-32e4-755b-8f4e-5e5be8c1fea9 | €15.00 | €0.26 | duplicate line |
| 109 | capture | 01a18305-4c57-7e84-880e-fdb7b8cf29fc | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a182fa-21da-7804-b2b6-a7b43e380589 | €49.00 | €0.67 | matched |
| 2 | capture | 01a182fd-6ef3-78e3-a300-6c40f144e0ea | €9.00 | €0.19 | matched |
| 3 | capture | 01a182fd-a2a1-7de0-9aad-3f01ac90d49c | €35.00 | €0.50 | matched |
| 4 | capture | 01a182fd-b46b-7955-b9f2-55baae756ee2 | €24.00 | €0.37 | matched |
| 5 | capture | 01a182fd-b518-7603-989a-5c495505e9d5 | €9.00 | €0.19 | matched |
| 6 | capture | 01a182fd-d121-74cc-b70a-827316e33c5e | €9.00 | €0.19 | matched |
| 7 | refund | 01a182fd-e4b6-7b92-b511-25a3ce037058 | -€33.00 | €0.00 | matched |
| 8 | capture | 01a182fd-ec12-798b-a081-b24139d263b5 | €15.00 | €0.26 | matched |
| 9 | capture | 01a182fd-f395-70e8-9a80-1c24bcb639ae | €49.00 | €0.67 | matched |
| 10 | capture | 01a182fe-0001-7fd1-864e-857268cb5899 | €49.00 | €0.67 | matched |
| 11 | capture | 01a182fe-0ae5-7c18-86da-5854cebc09c0 | €35.00 | €0.50 | matched |
| 12 | capture | 01a182fe-1559-79f0-9f93-6273d2cc9155 | €24.00 | €0.37 | matched |
| 13 | refund | 01a182fe-159c-7a07-8184-8d7f1d2db282 | -€4.00 | €0.00 | matched |
| 14 | capture | 01a182fe-16a5-7459-8e89-3669cf71a654 | €15.00 | €0.26 | matched |
| 15 | capture | 01a182fe-27be-75ae-aa48-9884e0eb352a | €9.00 | €0.19 | matched |
| 16 | refund | 01a182fe-27b0-7640-a8c5-fff6938d4bab | -€5.00 | €0.00 | matched |
| 17 | capture | 01a182fe-2d1a-7739-93c6-750f1850ae08 | €24.00 | €0.37 | matched |
| 18 | capture | 01a182fe-5493-7c9b-8edd-7ddb4a35522a | €24.00 | €0.37 | matched |
| 19 | capture | 01a182fe-6c82-7dd8-8bd0-e93611c0f696 | €24.00 | €0.37 | matched |
| 20 | capture | 01a182fe-6d94-7dc5-bdb6-669bfa318bfd | €24.00 | €0.37 | matched |
| 21 | capture | 01a182fe-74d1-7ce6-a9e9-d1bc38a8a97d | €24.00 | €0.37 | matched |
| 22 | capture | 01a182fe-911f-76fb-be24-dc4a67b89f12 | €24.00 | €0.37 | matched |
| 23 | capture | 01a182fe-c96b-7e07-bd83-f7374403551a | €24.00 | €0.37 | matched |
| 24 | capture | 01a182fe-d415-7bf9-bc70-64ace30749f1 | €9.00 | €0.19 | matched |
| 25 | capture | 01a182fe-fa71-7696-bfd4-cdfd030bb5fe | €24.00 | €0.37 | matched |
| 26 | refund | 01a182fe-fcfa-717f-b188-ce55d67f55b3 | -€6.00 | €0.00 | matched |
| 27 | capture | 01a182fe-fe9f-73ca-a351-a2875509081d | €35.00 | €0.50 | matched |
| 28 | capture | 01a182ff-1e5a-7c29-8b8f-43a2188651c9 | €24.00 | €0.37 | matched |
| 29 | capture | 01a182ff-308b-792a-97c7-20c7d50a90e5 | €24.00 | €0.37 | matched |
| 30 | capture | 01a182ff-4505-703e-95a5-28fcb721813c | €49.00 | €0.67 | matched |
| 31 | capture | 01a182ff-49d4-70d5-a913-c3d732ac2968 | €15.00 | €0.26 | matched |
| 32 | capture | 01a182ff-49dd-7a15-a089-1c0ec9938b8c | €49.00 | €0.67 | matched |
| 33 | capture | 01a182ff-650d-7d50-b6f5-503c8575bfb5 | €49.00 | €0.67 | matched |
| 34 | refund | 01a182ff-7204-7382-8fdd-33c9c47c7c1c | -€17.00 | €0.00 | matched |
| 35 | capture | 01a182ff-98a5-7584-9d67-39878fdfc93e | €9.00 | €0.19 | matched |
| 36 | capture | 01a182ff-ae82-7847-9ed1-b853e53f076c | €35.00 | €0.50 | matched |
| 37 | capture | 01a182ff-b47f-71bd-8d32-f7dc82a7c700 | €9.00 | €0.19 | matched |
| 38 | refund | 01a182ff-b6d1-7973-97db-3d87d17b4fca | -€22.00 | €0.00 | matched |
| 39 | capture | 01a182ff-fa63-7d67-ad3a-daee720e461e | €24.00 | €0.37 | matched |
| 40 | capture | 01a18300-28ff-7d63-8333-e5549a2239f8 | €9.00 | €0.19 | matched |
| 41 | capture | 01a18300-2f15-78d7-9a2b-4e15bc681a72 | €35.00 | €0.50 | matched |
| 42 | refund | 01a18300-5e27-7a22-a303-e90a52bbfabc | -€8.00 | €0.00 | matched |
| 43 | capture | 01a18300-650b-776a-bd2d-6047cc2d5164 | €15.00 | €0.26 | matched |
| 44 | capture | 01a18300-66c8-79d7-9a15-5536bb2a0657 | €49.00 | €0.67 | matched |
| 45 | capture | 01a18300-93bb-74ba-809c-38dd71607fe2 | €49.00 | €0.67 | matched |
| 46 | capture | 01a18300-be2f-7a98-b6dd-75e415b16d5f | €49.00 | €0.67 | matched |
| 47 | capture | 01a18301-0455-72b0-909e-c189e46ac2cd | €9.00 | €0.19 | matched |
| 48 | capture | 01a18301-04b0-7eed-b417-f6b5a7ebea0d | €24.00 | €0.37 | matched |
| 49 | refund | 01a18301-11f1-7431-9371-4b5f56edf77d | -€12.00 | €0.00 | matched |
| 50 | capture | 01a18301-2fab-72c1-a6ff-75cf9aaf223c | €49.00 | €0.67 | matched |
| 51 | capture | 01a18301-3486-723a-898b-39982bd56fa0 | €35.00 | €0.50 | matched |
| 52 | capture | 01a18301-3a6a-73c6-aa90-149668fe17ca | €9.00 | €0.19 | matched |
| 53 | capture | 01a18301-419e-7007-b419-c00b4cf07de9 | €35.00 | €0.50 | matched |
| 54 | capture | 01a18301-4ac7-769a-b57d-8f29e1eb9623 | €49.00 | €0.67 | matched |
| 55 | capture | 01a18301-7803-7a0c-bd66-5ed25ce93207 | €15.00 | €0.26 | matched |
| 56 | capture | 01a18301-8f56-75a5-b1bc-82a8a0fbe543 | €9.00 | €0.19 | matched |
| 57 | capture | 01a18301-9539-7cb8-b47c-e27183403fcd | €35.00 | €0.50 | matched |
| 58 | capture | 01a18301-c0ae-77ed-a9e1-de14c90527e0 | €15.00 | €0.26 | matched |
| 59 | capture | 01a18301-d715-75f3-bc73-2853b2dd1c4a | €35.00 | €0.50 | matched |
| 60 | capture | 01a18301-fa65-7dab-8b02-b62eb4f9a021 | €9.00 | €0.19 | matched |
| 61 | capture | 01a18302-14c3-71a0-a95f-3d5713f86281 | €35.00 | €0.50 | matched |
| 62 | capture | 01a18302-3cbd-730b-8f31-edef8e5eb51f | €24.00 | €0.37 | matched |
| 63 | capture | 01a18302-405b-76ae-8e7e-ca8b75e53bf1 | €15.00 | €0.26 | matched |
| 64 | capture | 01a18302-4087-7bd1-ad7a-5f8a68afc55e | €49.00 | €0.67 | matched |
| 65 | capture | 01a18302-6ea4-7d46-bcab-2dc0b49199f6 | €24.00 | €0.37 | matched |
| 66 | capture | 01a18302-72fc-7550-b83e-fdcdd0f74081 | €15.00 | €0.26 | matched |
| 67 | capture | 01a18302-8865-7a34-986f-8b8395b7182d | €9.00 | €0.19 | matched |
| 68 | capture | 01a18302-8aa6-7c21-b513-f7832b0c2142 | €9.00 | €0.19 | matched |
| 69 | capture | 01a18302-ae2b-7d64-bbc2-fcbc9673a18e | €9.00 | €0.19 | matched |
| 70 | capture | 01a18302-c36a-70a6-889e-033d6c1b1228 | €49.00 | €0.67 | matched |
| 71 | capture | 01a18302-fb69-7311-96b0-0081eda94343 | €49.00 | €0.67 | matched |
| 72 | capture | 01a18303-0a95-7274-9eee-bcb578870f4b | €15.00 | €0.26 | matched |
| 73 | capture | 01a18303-22e5-797b-b624-44e0b4034fe1 | €15.00 | €0.26 | matched |
| 74 | capture | 01a18303-27df-7c9d-b947-bb38b3d07944 | €35.00 | €0.50 | matched |
| 75 | capture | 01a18303-2696-7ecd-805f-8058990bd09e | €9.00 | €0.19 | matched |
| 76 | capture | 01a18303-32e4-755b-8f4e-5e5be8c1fea9 | €15.00 | €0.26 | matched |
| 78 | capture | 01a18303-34a7-71e5-8310-d39fea0a8831 | €49.00 | €0.67 | matched |
| 79 | capture | 01a18303-350e-792b-a0fc-7a83d6a56e03 | €9.00 | €0.19 | matched |
| 80 | capture | 01a18303-3be9-7a83-be4d-af597ede47e3 | €35.00 | €0.50 | matched |
| 81 | capture | 01a18303-3c1b-77af-a2d4-e83a31ce71a8 | €9.00 | €0.19 | matched |
| 82 | capture | 01a18303-6755-740d-84b8-36690e4bafe9 | €9.00 | €0.19 | matched |
| 83 | capture | 01a18303-809b-707e-a3a0-6536d7865aa0 | €24.00 | €0.37 | matched |
| 84 | capture | 01a18303-6aa8-7903-b97c-e40e25c0628e | €35.00 | €0.50 | matched |
| 85 | capture | 01a18303-a447-7309-86e1-2573a609a5d9 | €49.00 | €0.67 | matched |
| 86 | capture | 01a18303-a4cf-74fc-8ed9-4b5a14095cde | €35.00 | €0.50 | matched |
| 87 | capture | 01a18303-f9ba-77bd-82b7-24bfcbc6f494 | €49.00 | €0.67 | matched |
| 88 | capture | 01a18303-fa67-77e3-a06f-521b1d561b63 | €15.00 | €0.26 | matched |
| 89 | capture | 01a18304-05c7-74d7-9250-8fe66df7e0f0 | €35.00 | €0.50 | matched |
| 90 | capture | 01a18304-1875-7a95-a7d0-c783f6f149b0 | €15.00 | €0.26 | matched |
| 91 | capture | 01a18304-4f87-73fe-a61b-8910a8a0eba8 | €15.00 | €0.26 | matched |
| 92 | capture | 01a18304-52ea-72aa-aefd-6195367a0e35 | €35.00 | €0.50 | matched |
| 93 | capture | 01a18304-5d38-7892-9e83-b7dc73ebdbab | €35.00 | €0.50 | matched |
| 94 | capture | 01a18304-793c-7f70-b8c9-17bc8ebc5217 | €35.00 | €0.50 | matched |
| 95 | capture | 01a18304-81cf-7cb9-9208-fe07c10f9183 | €15.00 | €0.26 | matched |
| 96 | capture | 01a18304-b006-70ba-8e29-837c3e3210e1 | €35.00 | €0.50 | matched |
| 97 | capture | 01a18304-b8e2-755c-bd4d-578f43e315ca | €15.00 | €0.26 | matched |
| 98 | capture | 01a18304-c7ce-740d-8a5a-12dd7b4f02d2 | €49.00 | €0.67 | matched |
| 99 | capture | 01a18304-e01b-794e-9016-cdc867355e99 | €49.00 | €0.67 | matched |
| 100 | capture | 01a18304-e551-7994-af22-1c72251a8940 | €9.00 | €0.19 | matched |
| 101 | refund | 01a18304-f0c8-7e33-9fc3-09eb34c44e3b | -€44.00 | €0.00 | matched |
| 102 | capture | 01a18305-0344-7a67-a281-7970cc96fdef | €24.00 | €0.37 | matched |
| 103 | capture | 01a18305-0a5b-7d3a-8b2c-f420c5bda330 | €15.00 | €0.26 | matched |
| 104 | capture | 01a18305-25a6-7589-851a-fa1174f8ed69 | €9.00 | €0.19 | matched |
| 105 | refund | 01a18305-2630-72ce-a137-ed81c6ce9029 | -€10.00 | €0.00 | matched |
| 106 | capture | 01a18305-3658-76cf-828a-41613736a816 | €35.00 | €0.50 | matched |
| 107 | capture | 01a18305-42fd-7312-90bc-ffc82485db20 | €15.00 | €0.26 | matched |
| 108 | capture | 01a18305-4c57-7e84-880e-fdb7b8cf29fc | €49.00 | €0.67 | matched |
| 110 | capture | 01a18305-4f62-7e0f-8b19-f14c2c455b6d | €49.00 | €0.67 | matched |
| 111 | capture | 01a18305-582c-7d99-b6ad-e0fca1f7d614 | €35.00 | €0.50 | matched |
| 112 | refund | 01a18305-6900-7295-bb52-292a4f8227eb | -€10.00 | €0.00 | matched |
| 113 | capture | 01a18305-7ade-7a0d-8c69-9b9d23afccc3 | €9.00 | €0.19 | matched |
| 114 | capture | 01a18305-7e97-7838-b5a8-80b28a5152ff | €35.00 | €0.50 | matched |
| 115 | capture | 01a18305-da9b-7073-beb5-36d8533ee69d | €49.00 | €0.67 | matched |
| 116 | capture | 01a18305-eada-7783-b33d-703a1bce5165 | €49.00 | €0.67 | matched |
| 117 | capture | 01a18305-f1d4-7ec5-b672-fab444ae10ad | €24.00 | €0.37 | matched |
| 118 | capture | 01a18306-0396-7eb8-9261-6fbb74338bc9 | €15.00 | €0.26 | matched |
| 119 | capture | 01a18306-0f30-7bf2-a763-64a3fe29e589 | €49.00 | €0.67 | matched |
| 120 | refund | 01a18306-43e6-7795-a8af-d54b0b31ba34 | -€42.00 | €0.00 | matched |
| 121 | capture | 01a18306-64c2-7ec9-9ff1-5cf48af45888 | €35.00 | €0.50 | matched |