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, 23:20136 lines2 breaks
- 15 Oct, 23:10130 lines8 breaks
- 15 Oct, 23:00110 lines4 breaks
- 15 Oct, 22:50128 linesclean
- 15 Oct, 22:40134 lines5 breaks
- 15 Oct, 22:30111 lines2 breaks
- 15 Oct, 22:20109 linesclean
- 15 Oct, 22:10139 lines2 breaks
- 15 Oct, 22:00130 lines3 breaks
- 15 Oct, 21:50134 lines1 break
- 15 Oct, 21:40132 lines2 breaks
- 15 Oct, 21:30125 lines2 breaks
- 15 Oct, 21:20129 lines2 breaks
- 15 Oct, 21:10118 lines2 breaks
15 Oct, 22:30
Gross
€2,442.00
PSP fee
€39.24
Net to the bank
€2,402.76
Settlement journal
#22402
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a141b4-b7a8-7321-843e-dbbeb99fe82d is already settled by stl_EUR_2986839 line 52
- missing linein the books, not in the filerefund:01a141b6-a0a7-7aaf-875e-42547f299dc0 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 53 | capture | 01a141b4-b7ea-70ab-a898-20ca39067780 | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a141ab-1246-7306-ac7a-4081368925d5 | €35.00 | €0.50 | matched |
| 2 | capture | 01a141af-dc17-715f-bb45-9c45f985dc0e | €9.00 | €0.19 | matched |
| 3 | capture | 01a141af-f22e-7779-8a69-7e6e79ea3756 | €24.00 | €0.37 | matched |
| 4 | refund | 01a141b0-0422-72a7-9c1a-392cc0b595e6 | -€10.00 | €0.00 | matched |
| 5 | capture | 01a141b0-09bb-7ae5-8d4d-61e67949e69f | €24.00 | €0.37 | matched |
| 6 | capture | 01a141b0-3232-7667-9df9-b6baa0b404d6 | €24.00 | €0.37 | matched |
| 7 | capture | 01a141b0-4564-739f-8225-356e519cc88d | €15.00 | €0.26 | matched |
| 8 | capture | 01a141b0-5bf3-7228-a3ba-25707fecbf45 | €35.00 | €0.50 | matched |
| 9 | capture | 01a141b0-84af-7352-af0a-6ab306d266aa | €15.00 | €0.26 | matched |
| 10 | capture | 01a141b0-a914-7502-a116-beb54c9cda4b | €9.00 | €0.19 | matched |
| 11 | capture | 01a141b0-c5c7-77d2-8545-49d032179adc | €24.00 | €0.37 | matched |
| 12 | capture | 01a141b0-f85a-79df-8ba7-106c201f3bd4 | €9.00 | €0.19 | matched |
| 13 | capture | 01a141b1-0ad8-7bd5-8a03-1aec1cd59900 | €24.00 | €0.37 | matched |
| 14 | capture | 01a141b1-16c8-7084-8a52-48b4c84274de | €15.00 | €0.26 | matched |
| 15 | capture | 01a141b1-1bc5-7007-8257-9a45f4fc8801 | €35.00 | €0.50 | matched |
| 16 | capture | 01a141b1-26a7-7df2-8ff2-65ab3602e008 | €49.00 | €0.67 | matched |
| 17 | capture | 01a141b1-4523-7439-9ecf-1259befb98cd | €35.00 | €0.50 | matched |
| 18 | capture | 01a141b1-4ade-7763-b51c-d13af2cd66a3 | €35.00 | €0.50 | matched |
| 19 | capture | 01a141b1-52e0-7494-9a2c-20dff3d5d75d | €9.00 | €0.19 | matched |
| 20 | capture | 01a141b1-7f02-7fc8-9b08-4da4f4adcb98 | €9.00 | €0.19 | matched |
| 21 | capture | 01a141b1-b447-747f-8754-58d13d787415 | €9.00 | €0.19 | matched |
| 22 | capture | 01a141b1-b5e1-71fe-8cb1-6556acf25475 | €49.00 | €0.67 | matched |
| 23 | capture | 01a141b1-c3da-7ef7-b10b-161139f5fc84 | €15.00 | €0.26 | matched |
| 24 | capture | 01a141b1-c541-761e-bce3-8818749696fa | €49.00 | €0.67 | matched |
| 25 | capture | 01a141b1-e040-777f-92d7-57ffc3ab1a9b | €49.00 | €0.67 | matched |
| 26 | capture | 01a141b2-1eba-7ecb-9f52-7eb5dcb32320 | €49.00 | €0.67 | matched |
| 27 | capture | 01a141b2-2bad-70b0-a943-cd247cb54bf9 | €49.00 | €0.67 | matched |
| 28 | capture | 01a141b2-3de3-7c6c-8d1d-ca51e71485cc | €15.00 | €0.26 | matched |
| 29 | capture | 01a141b2-6305-72a0-a8ae-a877c699e286 | €15.00 | €0.26 | matched |
| 30 | capture | 01a141b2-6c9b-7e54-99fa-b2aeccf33bae | €9.00 | €0.19 | matched |
| 31 | capture | 01a141b2-6fce-7069-bbb1-4be6823163c3 | €15.00 | €0.26 | matched |
| 32 | capture | 01a141b2-7447-7e89-86e9-a06f7f22e1c1 | €9.00 | €0.19 | matched |
| 33 | capture | 01a141b2-7863-7499-aec4-c81921194a2a | €24.00 | €0.37 | matched |
| 34 | capture | 01a141b2-853f-78e7-babe-5b24bae5ca3e | €49.00 | €0.67 | matched |
| 35 | capture | 01a141b2-9650-7700-9c93-754ec9e23588 | €35.00 | €0.50 | matched |
| 36 | capture | 01a141b2-a65a-7d56-9c93-ac270c4cedc6 | €15.00 | €0.26 | matched |
| 37 | capture | 01a141b2-c3d7-75a5-8748-2d2c60f411fc | €35.00 | €0.50 | matched |
| 38 | capture | 01a141b2-c7ad-7e4a-a2f8-d374d0f8a12b | €15.00 | €0.26 | matched |
| 39 | capture | 01a141b2-e3db-7ab6-abde-85bd165e3ea2 | €24.00 | €0.37 | matched |
| 40 | capture | 01a141b2-e868-7d33-a29d-14fd939d002a | €49.00 | €0.67 | matched |
| 41 | capture | 01a141b3-342f-7f38-8f01-68d27d10d2fd | €9.00 | €0.19 | matched |
| 42 | capture | 01a141b3-36ad-7967-9cab-dd804addded1 | €15.00 | €0.26 | matched |
| 43 | capture | 01a141b3-37c8-752b-8144-8d505b8f8c04 | €15.00 | €0.26 | matched |
| 44 | capture | 01a141b3-4339-7da6-8c37-2455e4b4953e | €9.00 | €0.19 | matched |
| 45 | capture | 01a141b3-d99c-703a-ac83-dc68bafb0869 | €15.00 | €0.26 | matched |
| 46 | capture | 01a141b3-fcf4-75a0-b3a3-4f4be9636070 | €15.00 | €0.26 | matched |
| 47 | capture | 01a141b4-0c47-773d-8db3-995f18a30094 | €15.00 | €0.26 | matched |
| 48 | refund | 01a141b4-3f36-7383-8bad-7475eb0b28d2 | -€14.00 | €0.00 | matched |
| 49 | capture | 01a141b4-a75f-7604-b6a3-71874e0e411f | €24.00 | €0.37 | matched |
| 50 | capture | 01a141b4-aa1d-758c-9169-8034f667014f | €24.00 | €0.37 | matched |
| 51 | capture | 01a141b4-ad05-7ad0-b342-b23516d3df57 | €24.00 | €0.37 | matched |
| 52 | capture | 01a141b4-b7ea-70ab-a898-20ca39067780 | €24.00 | €0.37 | matched |
| 54 | capture | 01a141b4-bfeb-75a0-acef-eab664806ddc | €15.00 | €0.26 | matched |
| 55 | capture | 01a141b4-d11a-7237-a4a8-b3a17fc134cc | €24.00 | €0.37 | matched |
| 56 | capture | 01a141b4-daeb-7667-b9ca-a5eda1055d4c | €9.00 | €0.19 | matched |
| 57 | refund | 01a141b4-ea44-749d-a03b-953eed6052d5 | -€18.00 | €0.00 | matched |
| 58 | capture | 01a141b5-0005-7e63-a1a6-55fdceadd5b5 | €49.00 | €0.67 | matched |
| 59 | capture | 01a141b5-3931-7eb7-bcd7-daeaabccb206 | €49.00 | €0.67 | matched |
| 60 | capture | 01a141b5-480f-7d46-9ceb-e0e5e822b6d1 | €35.00 | €0.50 | matched |
| 61 | capture | 01a141b5-5284-7853-909f-eb7c50cfe7dc | €24.00 | €0.37 | matched |
| 62 | capture | 01a141b5-68d7-7b56-8a56-03820fffaafd | €9.00 | €0.19 | matched |
| 63 | refund | 01a141b5-7814-7328-9181-4763ae09f638 | -€31.00 | €0.00 | matched |
| 64 | capture | 01a141b5-80a5-7c11-8db1-d13c85cb4102 | €9.00 | €0.19 | matched |
| 65 | capture | 01a141b5-88b0-7d35-aac8-b60d661f4191 | €49.00 | €0.67 | matched |
| 66 | capture | 01a141b5-8ebc-75ea-b07e-e18b20361a5d | €49.00 | €0.67 | matched |
| 67 | capture | 01a141b5-9cd5-7cfe-923d-7ff3d3b18bdf | €15.00 | €0.26 | matched |
| 68 | capture | 01a141b5-ad20-716c-ac2e-603164690360 | €15.00 | €0.26 | matched |
| 69 | capture | 01a141b5-bf9c-7b83-8f58-6e26aee68cef | €9.00 | €0.19 | matched |
| 70 | capture | 01a141b5-c70b-7462-bb58-fb487ebb9bc7 | €49.00 | €0.67 | matched |
| 71 | refund | 01a141b5-eaca-7222-880a-745437c2d110 | -€7.00 | €0.00 | matched |
| 72 | capture | 01a141b6-02b7-77fd-8c97-f7d5f6d1161c | €49.00 | €0.67 | matched |
| 73 | capture | 01a141b6-0bf8-70ba-845e-c709e454b8d1 | €15.00 | €0.26 | matched |
| 74 | capture | 01a141b6-3bcb-76c2-a36c-2057095ce79c | €15.00 | €0.26 | matched |
| 75 | capture | 01a141b6-41aa-75c4-a234-02c972597f9c | €49.00 | €0.67 | matched |
| 76 | capture | 01a141b6-5214-7d8d-98fb-0a2b293eb464 | €9.00 | €0.19 | matched |
| 77 | capture | 01a141b6-591f-76e8-b1cb-57a2088bd042 | €24.00 | €0.37 | matched |
| 78 | capture | 01a141b6-6917-7302-bbb6-13d984da1546 | €9.00 | €0.19 | matched |
| 79 | capture | 01a141b6-6e86-7d9a-99e7-2e0491ebb7a3 | €24.00 | €0.37 | matched |
| 80 | capture | 01a141b6-787f-73b9-8333-965c29c2e725 | €15.00 | €0.26 | matched |
| 81 | capture | 01a141b6-803a-73d1-90b5-b87fda87ee50 | €15.00 | €0.26 | matched |
| 82 | capture | 01a141b6-8f4e-73bb-b5cd-20a19c4d8406 | €35.00 | €0.50 | matched |
| 83 | capture | 01a141b6-b347-7c95-b37c-4ebb3817033c | €15.00 | €0.26 | matched |
| 84 | capture | 01a141b6-b7e9-764b-8b9c-0afd601046a5 | €9.00 | €0.19 | matched |
| 85 | capture | 01a141b6-bce3-7fab-a566-eea184e77b20 | €49.00 | €0.67 | matched |
| 86 | capture | 01a141b6-c8ae-7554-8c0b-6b1bdc9fd609 | €49.00 | €0.67 | matched |
| 87 | capture | 01a141b6-e4be-7904-9af2-eb73399e8027 | €9.00 | €0.19 | matched |
| 88 | capture | 01a141b7-36e6-75d8-86bd-90fcd7013c93 | €9.00 | €0.19 | matched |
| 89 | capture | 01a141b7-3a12-7ee6-8e84-e5da652e7f18 | €9.00 | €0.19 | matched |
| 90 | capture | 01a141b7-3d73-79e2-996b-968624118112 | €49.00 | €0.67 | matched |
| 91 | capture | 01a141b7-4260-76dc-9dc9-c7666e85ee50 | €24.00 | €0.37 | matched |
| 92 | capture | 01a141b7-44bc-7f12-a114-2eda94161ea6 | €15.00 | €0.26 | matched |
| 93 | capture | 01a141b7-63c7-7173-80f8-a5244b86998c | €9.00 | €0.19 | matched |
| 94 | capture | 01a141b7-6831-7fea-a80a-1d4c3cb976aa | €24.00 | €0.37 | matched |
| 95 | capture | 01a141b7-6cab-717c-bca3-fc848c48e6f8 | €15.00 | €0.26 | matched |
| 96 | capture | 01a141b7-75c2-7040-badb-efd5d4e74817 | €49.00 | €0.67 | matched |
| 97 | refund | 01a141b7-9f19-75ec-8a83-6c04553efc62 | -€37.00 | €0.00 | matched |
| 98 | capture | 01a141b7-b4b2-7872-a725-93ee23a98351 | €24.00 | €0.37 | matched |
| 99 | capture | 01a141b7-c76c-76b2-bbb1-f6ac9e0a9d62 | €24.00 | €0.37 | matched |
| 100 | capture | 01a141b7-cb54-746e-8a6c-911c5a2294a6 | €35.00 | €0.50 | matched |
| 101 | capture | 01a141b7-db65-78c0-aa19-8b00560675ec | €35.00 | €0.50 | matched |
| 102 | capture | 01a141b7-e7fe-7030-b225-534dc1c54d95 | €24.00 | €0.37 | matched |
| 103 | refund | 01a141b8-016f-7c72-b662-fd2f65a0d4a9 | -€7.00 | €0.00 | matched |
| 104 | capture | 01a141b8-3356-7fd7-9d47-e9c196d44fca | €9.00 | €0.19 | matched |
| 105 | capture | 01a141b8-3f2c-772a-9998-b89e9b63b23d | €35.00 | €0.50 | matched |
| 106 | capture | 01a141b8-4e1d-7820-b9dd-ece1382729a8 | €15.00 | €0.26 | matched |
| 107 | capture | 01a141b8-4e51-7680-b79f-84459302aa28 | €9.00 | €0.19 | matched |
| 108 | capture | 01a141b8-5429-74bb-a5a5-75999e420fa2 | €35.00 | €0.50 | matched |
| 109 | capture | 01a141b8-8c00-7387-a64a-bda9c4d02419 | €35.00 | €0.50 | matched |
| 110 | capture | 01a141b8-d8d9-736d-9c3b-0c941ce786f9 | €35.00 | €0.50 | matched |
| 111 | capture | 01a141b8-dcd4-75b1-aa05-9c985b91e686 | €24.00 | €0.37 | matched |