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
- 24 Oct, 23:40114 lines5 breaks
- 24 Oct, 23:30149 lines2 breaks
- 24 Oct, 23:20139 lines5 breaks
- 24 Oct, 23:10114 lines2 breaks
- 24 Oct, 23:00135 lines5 breaks
- 24 Oct, 22:50126 lines4 breaks
- 24 Oct, 22:40122 lines1 break
- 24 Oct, 22:30128 lines3 breaks
- 24 Oct, 22:20140 lines4 breaks
- 24 Oct, 22:10127 lines2 breaks
- 24 Oct, 22:00119 lines5 breaks
- 24 Oct, 21:50111 lines1 break
- 24 Oct, 21:40104 lines2 breaks
- 24 Oct, 21:30122 lines2 breaks
24 Oct, 22:50
Gross
€2,985.00
PSP fee
€47.03
Net to the bank
€2,937.97
Settlement journal
#186294
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a17020-0bc7-7a9b-99d1-7a2519d82614 is already settled by stl_EUR_2988137 line 56
- duplicate linethe file lists it twicerefund:01a17024-5487-7989-93e6-a73daa5983cf is already settled by stl_EUR_2988137 line 125
- fee differencethe fee is not the contract feethe fee is 55, the contract says 50
- missing linein the books, not in the filecapture:01a17022-5660-7983-91df-16b3fa3b0654 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 35 | capture | 01a1701d-e84b-7205-9b8a-3ef41aa939a9 | €35.00 | €0.55 | fee difference |
| 57 | capture | 01a17020-0be9-793c-92c2-4781762307b0 | €24.00 | €0.37 | duplicate line |
| 126 | refund | 01a17024-5489-7457-ae8b-58c9ba0eb1ef | -€34.00 | €0.00 | duplicate line |
| 1 | capture | 01a17012-3a0c-7ca9-b4cd-c1d2beb73de0 | €35.00 | €0.50 | matched |
| 2 | capture | 01a17019-bb2f-715d-b736-9e832e17f661 | €35.00 | €0.50 | matched |
| 3 | capture | 01a1701b-1425-77b2-9404-ddee45af42bf | €15.00 | €0.26 | matched |
| 4 | capture | 01a1701b-7caa-7995-bb88-fd86c909f8b2 | €15.00 | €0.26 | matched |
| 5 | capture | 01a1701b-9b34-7a95-8dc7-4086e0c66f92 | €24.00 | €0.37 | matched |
| 6 | capture | 01a1701b-a68f-74d4-ae3b-8f1a71ffeab9 | €24.00 | €0.37 | matched |
| 7 | capture | 01a1701b-b691-7f47-83db-1fa7c1c7e24d | €49.00 | €0.67 | matched |
| 8 | capture | 01a1701b-b6b5-7216-8fed-ac14bea8f85e | €49.00 | €0.67 | matched |
| 9 | capture | 01a1701b-c5e0-7c98-87ba-c9376bfe4e6b | €15.00 | €0.26 | matched |
| 10 | capture | 01a1701b-c6c0-7a9c-a538-1b3b331ee99b | €35.00 | €0.50 | matched |
| 11 | capture | 01a1701b-e16b-768e-931d-756308a5927a | €24.00 | €0.37 | matched |
| 12 | capture | 01a1701c-0c5b-71a4-a2a6-50198e1e7533 | €49.00 | €0.67 | matched |
| 13 | capture | 01a1701c-1d02-782c-8c45-d4b1a0455241 | €9.00 | €0.19 | matched |
| 14 | capture | 01a1701c-2387-7b5a-9cb6-624b6a25ae8c | €24.00 | €0.37 | matched |
| 15 | capture | 01a1701c-2edf-7980-a626-39e0fa169e42 | €49.00 | €0.67 | matched |
| 16 | capture | 01a1701c-2c15-76e7-a78d-7540cd471f68 | €49.00 | €0.67 | matched |
| 17 | capture | 01a1701c-3e89-7ded-88d8-79d4a61ab59d | €15.00 | €0.26 | matched |
| 18 | capture | 01a1701c-48da-7bfc-a13c-19f651ca3523 | €24.00 | €0.37 | matched |
| 19 | capture | 01a1701c-58da-7475-addc-5602103e61f9 | €24.00 | €0.37 | matched |
| 20 | capture | 01a1701c-7556-7607-ae8a-cd306853fd80 | €35.00 | €0.50 | matched |
| 21 | capture | 01a1701c-b026-7c37-a2e1-fdb3406f235b | €49.00 | €0.67 | matched |
| 22 | capture | 01a1701c-a9cb-70bd-acda-9d4dfc409a9b | €49.00 | €0.67 | matched |
| 23 | capture | 01a1701c-c17d-70d6-8434-9cd968fe6cd7 | €15.00 | €0.26 | matched |
| 24 | capture | 01a1701c-ceee-74ef-8cf2-4b870098a955 | €9.00 | €0.19 | matched |
| 25 | capture | 01a1701c-d3b8-770b-b4f1-28bc936b66c9 | €35.00 | €0.50 | matched |
| 26 | capture | 01a1701d-3071-776d-be14-6efe17127581 | €9.00 | €0.19 | matched |
| 27 | capture | 01a1701d-5a11-73b0-b2ba-25f1565cca67 | €49.00 | €0.67 | matched |
| 28 | capture | 01a1701d-6659-74f5-85c6-11dcd47e26f5 | €24.00 | €0.37 | matched |
| 29 | capture | 01a1701d-7472-7eae-8e09-4c72689bd9b4 | €9.00 | €0.19 | matched |
| 30 | capture | 01a1701d-981f-7230-a7b8-b771440fc8bb | €15.00 | €0.26 | matched |
| 31 | capture | 01a1701d-bbdf-71a0-b69c-defc08b8ccbb | €9.00 | €0.19 | matched |
| 32 | capture | 01a1701d-bd48-7dae-af4a-34813d4161d5 | €49.00 | €0.67 | matched |
| 33 | refund | 01a1701d-c621-7895-8053-13693c04054b | -€10.00 | €0.00 | matched |
| 34 | capture | 01a1701d-cbdd-7b94-96aa-ee67231144e5 | €49.00 | €0.67 | matched |
| 36 | capture | 01a1701e-1b85-7a69-b72d-9c57b940d545 | €15.00 | €0.26 | matched |
| 37 | capture | 01a1701e-3f99-708a-b440-15197ff7b6c0 | €15.00 | €0.26 | matched |
| 38 | capture | 01a1701e-4c4d-7ca2-85f8-448320ac9bfb | €15.00 | €0.26 | matched |
| 39 | capture | 01a1701e-6255-7ebb-bb27-b8108d5b283b | €49.00 | €0.67 | matched |
| 40 | capture | 01a1701e-93fb-7d52-bdbb-7a707a20a50c | €35.00 | €0.50 | matched |
| 41 | refund | 01a1701e-9ccc-7291-a0d8-a1830b78ee21 | -€7.00 | €0.00 | matched |
| 42 | capture | 01a1701e-c763-73fe-a84f-59562ef758a6 | €49.00 | €0.67 | matched |
| 43 | capture | 01a1701e-c955-728f-8e27-ca3b5358819e | €24.00 | €0.37 | matched |
| 44 | capture | 01a1701e-f02e-7544-b7e3-d0212b7e7ccd | €15.00 | €0.26 | matched |
| 45 | capture | 01a1701f-018d-7078-b12d-09b3d880cbde | €24.00 | €0.37 | matched |
| 46 | capture | 01a1701f-01f9-74c4-9993-7bd14a90d2cc | €15.00 | €0.26 | matched |
| 47 | capture | 01a1701f-12d0-7a10-ab9c-651ca034138c | €49.00 | €0.67 | matched |
| 48 | capture | 01a1701f-2d8c-7318-b3d8-988d6ad3ea6d | €15.00 | €0.26 | matched |
| 49 | capture | 01a1701f-43da-71b8-ae82-1c360a2a6d5e | €9.00 | €0.19 | matched |
| 50 | refund | 01a1701f-441b-76e7-be69-92524c31cf0c | -€4.00 | €0.00 | matched |
| 51 | capture | 01a1701f-5b58-7733-9809-a0e79bc92a3a | €9.00 | €0.19 | matched |
| 52 | capture | 01a1701f-8a0d-7a74-8ad3-3e9815ff3921 | €35.00 | €0.50 | matched |
| 53 | capture | 01a1701f-dcbb-7e7a-9891-f0f1c103621a | €24.00 | €0.37 | matched |
| 54 | capture | 01a1701f-e367-7681-b53c-6116fffc25f7 | €9.00 | €0.19 | matched |
| 55 | capture | 01a1701f-f917-741c-ace5-e6ef32b24b14 | €24.00 | €0.37 | matched |
| 56 | capture | 01a17020-0be9-793c-92c2-4781762307b0 | €24.00 | €0.37 | matched |
| 58 | capture | 01a17020-12a0-7f41-b39e-315fc9bc60a8 | €24.00 | €0.37 | matched |
| 59 | capture | 01a17020-1624-73bb-8dea-61f0b229a640 | €9.00 | €0.19 | matched |
| 60 | capture | 01a17020-2da5-7832-8fc4-7804effc1017 | €15.00 | €0.26 | matched |
| 61 | capture | 01a17020-43c9-78be-bd04-809022ec7d89 | €49.00 | €0.67 | matched |
| 62 | capture | 01a17020-5dba-71f2-9fd0-578981cec16c | €9.00 | €0.19 | matched |
| 63 | capture | 01a17020-5e2c-717a-9a6b-268246299b4e | €15.00 | €0.26 | matched |
| 64 | refund | 01a17020-650e-7040-9a89-4a3e15699a28 | -€6.00 | €0.00 | matched |
| 65 | capture | 01a17020-6802-7154-b8c3-f51b6805534c | €24.00 | €0.37 | matched |
| 66 | capture | 01a17020-b0f0-79b0-a6ab-3f8b22263b91 | €9.00 | €0.19 | matched |
| 67 | capture | 01a17020-b25e-732d-ae31-2a00f7f0f2b4 | €24.00 | €0.37 | matched |
| 68 | capture | 01a17020-b60d-7565-9e99-082904040ba2 | €24.00 | €0.37 | matched |
| 69 | capture | 01a17020-bebe-7fd2-a96c-53689f5cd37f | €35.00 | €0.50 | matched |
| 70 | capture | 01a17020-c0be-72b0-8534-c54110ccffeb | €35.00 | €0.50 | matched |
| 71 | capture | 01a17020-d0ca-7d90-aba2-4f5529232a15 | €24.00 | €0.37 | matched |
| 72 | capture | 01a17020-d4d4-7c46-9342-52e3ff11ca64 | €15.00 | €0.26 | matched |
| 73 | capture | 01a17020-eace-73aa-9c80-48ec0b8ca9fe | €49.00 | €0.67 | matched |
| 74 | capture | 01a17021-15f4-77b1-abca-66ec02f84b9e | €49.00 | €0.67 | matched |
| 75 | capture | 01a17021-247e-7611-abc4-69f8b59f9515 | €35.00 | €0.50 | matched |
| 76 | capture | 01a17021-35ff-768c-9221-1177f4eae887 | €49.00 | €0.67 | matched |
| 77 | capture | 01a17021-3b16-745d-98ac-fffeecf9b280 | €49.00 | €0.67 | matched |
| 78 | capture | 01a17021-4223-7bb7-b1b6-5014b2253a88 | €24.00 | €0.37 | matched |
| 79 | capture | 01a17021-49d3-7dc7-8268-83dbcaece720 | €35.00 | €0.50 | matched |
| 80 | capture | 01a17021-5bef-7ced-a652-10f9336b5a4f | €9.00 | €0.19 | matched |
| 81 | capture | 01a17021-6030-7de7-9ee7-d3842b1af4c9 | €49.00 | €0.67 | matched |
| 82 | capture | 01a17021-725f-7065-80ea-6e70d7dc1188 | €49.00 | €0.67 | matched |
| 83 | capture | 01a17021-7907-716a-979a-19da865c4463 | €24.00 | €0.37 | matched |
| 84 | capture | 01a17021-8481-7657-91d8-2bc8b4af8928 | €9.00 | €0.19 | matched |
| 85 | capture | 01a17021-8e67-7596-86bc-fef68ed202f1 | €9.00 | €0.19 | matched |
| 86 | capture | 01a17021-a157-7489-91cc-cb5761c23c40 | €15.00 | €0.26 | matched |
| 87 | capture | 01a17021-a18d-70fd-8b2b-6dd65058c434 | €35.00 | €0.50 | matched |
| 88 | refund | 01a17021-b7a7-7a25-8d70-fd46f4825492 | -€5.00 | €0.00 | matched |
| 89 | capture | 01a17021-c132-7c2e-846e-34953b9dd55d | €24.00 | €0.37 | matched |
| 90 | capture | 01a17021-c90a-769b-b284-35bc8cc144d0 | €15.00 | €0.26 | matched |
| 91 | capture | 01a17021-d977-72e4-abe0-d66fc1254ff7 | €35.00 | €0.50 | matched |
| 92 | capture | 01a17021-f3a7-72d1-a4ae-2b80071efd87 | €49.00 | €0.67 | matched |
| 93 | capture | 01a17021-f544-7535-b989-4e6f0746874c | €35.00 | €0.50 | matched |
| 94 | capture | 01a17021-f7af-7f24-a1eb-f92c5e5a9c23 | €9.00 | €0.19 | matched |
| 95 | refund | 01a17022-0765-7df6-bf27-3f9aaca2c0e1 | -€7.00 | €0.00 | matched |
| 96 | capture | 01a17022-0b18-76ca-a683-a7a3b38caf76 | €24.00 | €0.37 | matched |
| 97 | capture | 01a17022-134c-762f-84bb-016b30495f4c | €24.00 | €0.37 | matched |
| 98 | capture | 01a17022-2d2c-7e71-a7d1-7dc5bd4b4d1f | €35.00 | €0.50 | matched |
| 99 | capture | 01a17022-818c-760f-821d-4487a5d43f5a | €15.00 | €0.26 | matched |
| 100 | capture | 01a17022-9e47-7f69-b8a6-b26d81f000a8 | €24.00 | €0.37 | matched |
| 101 | capture | 01a17022-c09d-7679-81d5-ac92836d20d7 | €9.00 | €0.19 | matched |
| 102 | capture | 01a17022-cd5c-7207-9e25-ffd14645fa1b | €9.00 | €0.19 | matched |
| 103 | capture | 01a17022-d1ce-7331-817e-05eea05a8dee | €9.00 | €0.19 | matched |
| 104 | capture | 01a17022-dd3a-7696-ac3e-8d8f1b9dffda | €9.00 | €0.19 | matched |
| 105 | capture | 01a17023-0bbf-7ba6-94c6-1fecc64fd3e5 | €49.00 | €0.67 | matched |
| 106 | capture | 01a17023-13a4-7aad-be34-3c5c268d4912 | €35.00 | €0.50 | matched |
| 107 | capture | 01a17023-26ec-740e-add4-55cf69ba482f | €24.00 | €0.37 | matched |
| 108 | capture | 01a17023-340a-7d81-9bd8-250b93c98540 | €15.00 | €0.26 | matched |
| 109 | capture | 01a17023-46b2-77a5-ba1f-5af0e80823e3 | €15.00 | €0.26 | matched |
| 110 | capture | 01a17023-6f33-76e2-9eac-63be81476afc | €9.00 | €0.19 | matched |
| 111 | capture | 01a17023-75c5-73bf-b6e0-e3aa79063512 | €15.00 | €0.26 | matched |
| 112 | capture | 01a17023-ab75-7db7-b62d-ea997c486f56 | €24.00 | €0.37 | matched |
| 113 | capture | 01a17023-ae64-7a81-9178-df132f8c8370 | €35.00 | €0.50 | matched |
| 114 | capture | 01a17023-d302-7919-99ab-cf0f283b1251 | €15.00 | €0.26 | matched |
| 115 | capture | 01a17023-da77-7a75-9403-00104fd6e85b | €24.00 | €0.37 | matched |
| 116 | capture | 01a17023-df9a-75a1-8447-b7897ac07ddc | €49.00 | €0.67 | matched |
| 117 | capture | 01a17023-ecbd-7c64-b66e-de6ef7080d1a | €15.00 | €0.26 | matched |
| 118 | capture | 01a17024-1623-7fb1-9c1d-515101234c44 | €24.00 | €0.37 | matched |
| 119 | refund | 01a17024-1808-7779-bf0c-5e8a697d163a | -€31.00 | €0.00 | matched |
| 120 | capture | 01a17024-1eef-7a4a-8adf-6e7933f5209a | €35.00 | €0.50 | matched |
| 121 | capture | 01a17024-265a-7ef2-9c45-1ec3b3aa0544 | €35.00 | €0.50 | matched |
| 122 | capture | 01a17024-2676-716d-a9f6-81b260045a3e | €49.00 | €0.67 | matched |
| 123 | capture | 01a17024-2e15-7dbf-82c5-b6201d3bca71 | €35.00 | €0.50 | matched |
| 124 | capture | 01a17024-396e-78da-97aa-6b917f53b3d2 | €15.00 | €0.26 | matched |
| 125 | refund | 01a17024-5489-7457-ae8b-58c9ba0eb1ef | -€34.00 | €0.00 | matched |