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
- 3 Nov, 15:00120 lines1 break
- 3 Nov, 14:50127 lines5 breaks
- 3 Nov, 14:40123 lines2 breaks
- 3 Nov, 14:30125 lines2 breaks
- 3 Nov, 14:20122 lines1 break
- 3 Nov, 14:10118 lines3 breaks
- 3 Nov, 14:00112 lines2 breaks
- 3 Nov, 13:50117 lines4 breaks
- 3 Nov, 13:40115 lines5 breaks
- 3 Nov, 13:30113 lines3 breaks
- 3 Nov, 13:20123 lines1 break
- 3 Nov, 13:10115 lines3 breaks
- 3 Nov, 13:00112 linesclean
- 3 Nov, 12:50145 lines1 break
3 Nov, 13:50
Gross
€2,795.00
PSP fee
€43.08
Net to the bank
€2,751.92
Settlement journal
#362110
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a1ae-0059-7697-a550-0bd9cdc8954f is already settled by stl_EUR_2989523 line 23
- duplicate linethe file lists it twicecapture:01a1a1b2-8052-7d78-ab00-75fdef5db154 is already settled by stl_EUR_2989523 line 73
- missing linein the books, not in the filecapture:01a1a1af-f206-72f6-a38b-d6775735b0c0 is in no file
- missing linein the books, not in the filecapture:01a1a1b0-f8a3-75c1-aca9-afdff3263b3d is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 24 | capture | 01a1a1ae-008c-766d-a802-978534ce83ca | €24.00 | €0.37 | duplicate line |
| 74 | capture | 01a1a1b2-80a0-7493-839c-1258833a17da | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a1a1a6-c658-7de6-af90-1a627aa75886 | €15.00 | €0.26 | matched |
| 2 | capture | 01a1a1ac-c7de-7fc8-80ce-df5e6015b8f4 | €24.00 | €0.37 | matched |
| 3 | capture | 01a1a1ac-d45c-797f-8d70-9a4780bf6d77 | €15.00 | €0.26 | matched |
| 4 | capture | 01a1a1ac-eb7f-79fb-9a0a-dbc1911fd05c | €35.00 | €0.50 | matched |
| 5 | capture | 01a1a1ad-0af2-7db6-98a9-144a9c796eac | €15.00 | €0.26 | matched |
| 6 | capture | 01a1a1ad-221d-70e4-93ce-b2f82caa6598 | €49.00 | €0.67 | matched |
| 7 | capture | 01a1a1ad-2509-7d71-82ff-60214a5be8b3 | €9.00 | €0.19 | matched |
| 8 | capture | 01a1a1ad-2557-7f2f-b0cd-cdd7bc03dd3c | €35.00 | €0.50 | matched |
| 9 | capture | 01a1a1ad-3131-744b-9139-3432908a238b | €15.00 | €0.26 | matched |
| 10 | capture | 01a1a1ad-40d9-7444-a9ca-10cb743bbbf6 | €49.00 | €0.67 | matched |
| 11 | capture | 01a1a1ad-4118-79e7-83d0-98ee845a77a6 | €49.00 | €0.67 | matched |
| 12 | capture | 01a1a1ad-4c92-7c9c-ba25-8433dc292206 | €9.00 | €0.19 | matched |
| 13 | capture | 01a1a1ad-6224-76a7-a0cd-73d93a525fe4 | €49.00 | €0.67 | matched |
| 14 | capture | 01a1a1ad-643e-733a-bf33-1d33a8e2abb6 | €49.00 | €0.67 | matched |
| 15 | capture | 01a1a1ad-9450-7847-9c2d-e91162fbd6b7 | €35.00 | €0.50 | matched |
| 16 | capture | 01a1a1ad-a401-7686-a4bf-5fc4a07f3191 | €35.00 | €0.50 | matched |
| 17 | capture | 01a1a1ad-a59c-72ba-a8bf-271cacd8eb9c | €9.00 | €0.19 | matched |
| 18 | capture | 01a1a1ad-af58-7193-94c0-ef4db2ddfdd6 | €49.00 | €0.67 | matched |
| 19 | capture | 01a1a1ad-af8d-7793-9d05-1f05547bcf2e | €15.00 | €0.26 | matched |
| 20 | capture | 01a1a1ad-c716-71bf-bf73-3e769ace120f | €9.00 | €0.19 | matched |
| 21 | capture | 01a1a1ad-d19d-741a-8ff8-30ecdf609d20 | €49.00 | €0.67 | matched |
| 22 | capture | 01a1a1ad-eef1-7f35-9733-be1f5d40fba8 | €15.00 | €0.26 | matched |
| 23 | capture | 01a1a1ae-008c-766d-a802-978534ce83ca | €24.00 | €0.37 | matched |
| 25 | capture | 01a1a1ae-03b6-72dd-8574-f239a6ff5983 | €35.00 | €0.50 | matched |
| 26 | capture | 01a1a1ae-0853-701a-b4f4-2a566c51dab9 | €49.00 | €0.67 | matched |
| 27 | capture | 01a1a1ae-263a-7dd7-a26e-db6a69c75619 | €35.00 | €0.50 | matched |
| 28 | capture | 01a1a1ae-29c0-70de-94a5-e157c230607d | €35.00 | €0.50 | matched |
| 29 | capture | 01a1a1ae-2a5b-7b60-8922-f028575a70a1 | €15.00 | €0.26 | matched |
| 30 | capture | 01a1a1ae-40d3-7ec6-8208-2e79a4cd5ec3 | €15.00 | €0.26 | matched |
| 31 | capture | 01a1a1ae-4b0b-72b0-b55f-48d73f5497a9 | €35.00 | €0.50 | matched |
| 32 | capture | 01a1a1ae-6ec2-73ef-985e-b1227805a29b | €15.00 | €0.26 | matched |
| 33 | capture | 01a1a1ae-97b4-7324-a272-e0c2889b131b | €9.00 | €0.19 | matched |
| 34 | capture | 01a1a1ae-a9a2-7eee-9b5c-2baad43eb3c2 | €24.00 | €0.37 | matched |
| 35 | capture | 01a1a1ae-ad02-79f3-ac0a-3c246944aa76 | €24.00 | €0.37 | matched |
| 36 | capture | 01a1a1ae-b231-76e7-8d46-f57d155573b4 | €9.00 | €0.19 | matched |
| 37 | capture | 01a1a1ae-ee48-734c-a6b0-fcd475f07aef | €9.00 | €0.19 | matched |
| 38 | capture | 01a1a1af-1728-75e8-9e70-eacf0618612a | €35.00 | €0.50 | matched |
| 39 | capture | 01a1a1af-41d1-77e6-98a2-38e800fec274 | €15.00 | €0.26 | matched |
| 40 | capture | 01a1a1af-5ff3-7d5f-97c9-1bf642efcc60 | €35.00 | €0.50 | matched |
| 41 | capture | 01a1a1af-a243-7c53-b6d3-eb68e435dcbc | €9.00 | €0.19 | matched |
| 42 | refund | 01a1a1af-ce68-789a-b38b-9b8f9814fa5c | -€7.00 | €0.00 | matched |
| 43 | capture | 01a1a1af-dc0a-7c3b-aec6-16ebf8a7740b | €35.00 | €0.50 | matched |
| 44 | capture | 01a1a1af-f38e-7f3b-b5de-2b843b9f6162 | €35.00 | €0.50 | matched |
| 45 | capture | 01a1a1b0-008b-7264-b897-72ca95b0eb3d | €9.00 | €0.19 | matched |
| 46 | capture | 01a1a1b0-023b-7a82-81fa-dded75d2e695 | €15.00 | €0.26 | matched |
| 47 | capture | 01a1a1b0-0575-7e4d-b14f-b807f3936bf8 | €49.00 | €0.67 | matched |
| 48 | capture | 01a1a1b0-0626-7457-8c25-6d095ffb6b52 | €35.00 | €0.50 | matched |
| 49 | capture | 01a1a1b0-201c-7008-862c-974f56e3a6e3 | €9.00 | €0.19 | matched |
| 50 | capture | 01a1a1b0-2298-7a7c-be42-d950a27ad16a | €15.00 | €0.26 | matched |
| 51 | capture | 01a1a1b0-256c-7a9b-b2dc-c09d17a33187 | €15.00 | €0.26 | matched |
| 52 | refund | 01a1a1b0-36ca-7c16-81ce-71349e103b0a | -€15.00 | €0.00 | matched |
| 53 | capture | 01a1a1b0-5d18-71f9-8848-657f6af2998e | €9.00 | €0.19 | matched |
| 54 | capture | 01a1a1b0-92cb-7f46-8810-a5ba062ac6a5 | €35.00 | €0.50 | matched |
| 55 | capture | 01a1a1b0-a118-7cf8-a561-7209e8809e0d | €49.00 | €0.67 | matched |
| 56 | capture | 01a1a1b0-d2de-7587-b232-b84da54d0ac9 | €24.00 | €0.37 | matched |
| 57 | capture | 01a1a1b0-e41e-7321-9ef0-886bb2ab3122 | €9.00 | €0.19 | matched |
| 58 | capture | 01a1a1b1-1017-795f-b152-0e5230eccc56 | €35.00 | €0.50 | matched |
| 59 | capture | 01a1a1b1-293a-73be-a64c-2e801bee3d81 | €35.00 | €0.50 | matched |
| 60 | capture | 01a1a1b1-4dda-74c7-9134-912751acd6a6 | €9.00 | €0.19 | matched |
| 61 | capture | 01a1a1b1-50c5-7163-9239-ce067c172130 | €49.00 | €0.67 | matched |
| 62 | capture | 01a1a1b1-5df0-7a39-ac4f-347699b0b85e | €24.00 | €0.37 | matched |
| 63 | capture | 01a1a1b1-6ddc-7f07-abec-532a809ac118 | €15.00 | €0.26 | matched |
| 64 | capture | 01a1a1b1-72ec-765d-812b-b50d316290fe | €35.00 | €0.50 | matched |
| 65 | capture | 01a1a1b1-b50b-79b3-8e44-81756bbcd0aa | €15.00 | €0.26 | matched |
| 66 | capture | 01a1a1b1-c527-713a-9c54-61d21e0e5098 | €24.00 | €0.37 | matched |
| 67 | refund | 01a1a1b1-e464-7e66-9d70-fa5aab36225d | -€9.00 | €0.00 | matched |
| 68 | refund | 01a1a1b1-f88a-7ab8-86ac-8180ed5ec431 | -€4.00 | €0.00 | matched |
| 69 | capture | 01a1a1b1-fe7d-75c7-bea4-bc961e6d2c53 | €35.00 | €0.50 | matched |
| 70 | capture | 01a1a1b2-0035-74d6-873c-e4f898fccd5d | €49.00 | €0.67 | matched |
| 71 | capture | 01a1a1b2-0eb9-74c6-83e0-4eef3e80ecbb | €49.00 | €0.67 | matched |
| 72 | capture | 01a1a1b2-1521-7563-a6ea-cea07c459882 | €15.00 | €0.26 | matched |
| 73 | capture | 01a1a1b2-80a0-7493-839c-1258833a17da | €35.00 | €0.50 | matched |
| 75 | capture | 01a1a1b2-8eca-702e-a105-744c5759361d | €24.00 | €0.37 | matched |
| 76 | capture | 01a1a1b2-e043-78fe-a5f5-ff91d0b0b7e6 | €15.00 | €0.26 | matched |
| 77 | capture | 01a1a1b2-f474-77e6-b210-58e760a7c353 | €9.00 | €0.19 | matched |
| 78 | capture | 01a1a1b3-1cdd-78f7-b5a7-ad9043c020ac | €35.00 | €0.50 | matched |
| 79 | capture | 01a1a1b3-2adb-713e-9d46-7718708ff465 | €15.00 | €0.26 | matched |
| 80 | capture | 01a1a1b3-44e9-720d-a61d-2b212d20c98c | €9.00 | €0.19 | matched |
| 81 | capture | 01a1a1b3-72f1-7b48-b030-416909555583 | €24.00 | €0.37 | matched |
| 82 | capture | 01a1a1b3-7d19-7369-847f-92287aba39ba | €24.00 | €0.37 | matched |
| 83 | capture | 01a1a1b3-7f84-78fa-9778-3ea5d50922e9 | €24.00 | €0.37 | matched |
| 84 | capture | 01a1a1b3-9328-7896-8b06-ed9f7fe6848b | €15.00 | €0.26 | matched |
| 85 | capture | 01a1a1b3-b0f0-7c63-aea1-766676310924 | €15.00 | €0.26 | matched |
| 86 | capture | 01a1a1b3-b81a-72f6-8b2e-350d97e7df84 | €24.00 | €0.37 | matched |
| 87 | capture | 01a1a1b3-bfe8-745b-bc83-fce3d20657aa | €24.00 | €0.37 | matched |
| 88 | capture | 01a1a1b3-c5bd-7a95-9399-648d093293c5 | €15.00 | €0.26 | matched |
| 89 | capture | 01a1a1b3-ccb0-70af-a96e-4db6d01b7d72 | €24.00 | €0.37 | matched |
| 90 | refund | 01a1a1b3-cde6-7995-af77-b1d3d1e5f3fe | -€6.00 | €0.00 | matched |
| 91 | capture | 01a1a1b3-d661-72af-a48d-33969101d836 | €49.00 | €0.67 | matched |
| 92 | capture | 01a1a1b3-ddce-78f0-93a0-37f675dfe206 | €49.00 | €0.67 | matched |
| 93 | capture | 01a1a1b3-e14a-7713-be98-3376da66f42f | €15.00 | €0.26 | matched |
| 94 | capture | 01a1a1b3-fd09-7387-bf25-1b8519dd813d | €35.00 | €0.50 | matched |
| 95 | capture | 01a1a1b4-072f-7330-b528-5c41c8ca8998 | €15.00 | €0.26 | matched |
| 96 | capture | 01a1a1b4-0d61-7f85-93e0-2a06260f3de0 | €15.00 | €0.26 | matched |
| 97 | capture | 01a1a1b4-0e8c-7932-ba71-eb78d84a8efb | €9.00 | €0.19 | matched |
| 98 | capture | 01a1a1b4-35af-7675-a36c-ada63eaa41a1 | €35.00 | €0.50 | matched |
| 99 | capture | 01a1a1b4-3cc7-747b-b9e8-143166ad4fed | €15.00 | €0.26 | matched |
| 100 | capture | 01a1a1b4-6913-730d-88bb-7db83ea098c1 | €35.00 | €0.50 | matched |
| 101 | capture | 01a1a1b4-75ba-7589-a23a-417d126f10de | €15.00 | €0.26 | matched |
| 102 | capture | 01a1a1b4-91cd-73e0-8e33-429cb727d4fc | €15.00 | €0.26 | matched |
| 103 | capture | 01a1a1b4-9bc8-7fc6-bea8-f6ba3b9f32bb | €35.00 | €0.50 | matched |
| 104 | capture | 01a1a1b4-b040-7e93-a7de-c13cf15b0360 | €24.00 | €0.37 | matched |
| 105 | refund | 01a1a1b4-d57b-79c0-8d54-818f324dbc97 | -€5.00 | €0.00 | matched |
| 106 | capture | 01a1a1b4-d901-778c-b648-ce5037bd9e62 | €15.00 | €0.26 | matched |
| 107 | capture | 01a1a1b4-fac2-77bc-af8a-a320de4a403d | €15.00 | €0.26 | matched |
| 108 | capture | 01a1a1b5-01c6-762a-9e64-5b0e9712c4ce | €24.00 | €0.37 | matched |
| 109 | capture | 01a1a1b5-22d0-7a2e-9cea-8589533d6bd4 | €24.00 | €0.37 | matched |
| 110 | capture | 01a1a1b5-45be-71c2-b1c7-3a1220a46bc3 | €35.00 | €0.50 | matched |
| 111 | capture | 01a1a1b5-4d09-755a-bd29-2fe6ddbd2215 | €49.00 | €0.67 | matched |
| 112 | capture | 01a1a1b5-550b-7939-8085-b2c0473202c6 | €24.00 | €0.37 | matched |
| 113 | capture | 01a1a1b5-6016-7403-b526-f2a8cd525c75 | €24.00 | €0.37 | matched |
| 114 | capture | 01a1a1b5-7e7a-775c-bfb5-b22ab212e775 | €9.00 | €0.19 | matched |
| 115 | capture | 01a1a1b5-8fcb-7596-af9c-0ddf2b921924 | €15.00 | €0.26 | matched |
| 116 | capture | 01a1a1b5-9096-717a-b187-9c7ed46299a3 | €49.00 | €0.67 | matched |
| 117 | capture | 01a1a1b5-a782-7fbc-a908-5e0505d05282 | €15.00 | €0.26 | matched |