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, 08:50118 lines2 breaks
- 4 Nov, 08:40117 lines3 breaks
- 4 Nov, 08:30128 lines2 breaks
- 4 Nov, 08:20121 lines2 breaks
- 4 Nov, 08:10115 lines3 breaks
- 4 Nov, 08:00136 lines4 breaks
- 4 Nov, 07:50145 lines6 breaks
- 4 Nov, 07:40118 lines2 breaks
- 4 Nov, 07:30128 lines1 break
- 4 Nov, 07:20119 lines5 breaks
- 4 Nov, 07:10118 lines2 breaks
- 4 Nov, 07:00112 lines1 break
- 4 Nov, 06:50124 lines2 breaks
- 4 Nov, 06:40108 lines3 breaks
4 Nov, 07:20
Gross
€3,028.00
PSP fee
€46.99
Net to the bank
€2,981.01
Settlement journal
#375384
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a56f-d934-7c29-a585-54a112918e1c is already settled by stl_EUR_2989628 line 32
- duplicate linethe file lists it twicerefund:01a1a572-68e6-7d0e-b071-616e35bdaebd is already settled by stl_EUR_2989628 line 67
- duplicate linethe file lists it twicecapture:01a1a572-c399-7cfe-aff1-e1b57b6ba4a8 is already settled by stl_EUR_2989628 line 70
- fee differencethe fee is not the contract feethe fee is 38, the contract says 37
- missing linein the books, not in the filecapture:01a1a56e-9356-7a9b-8e3e-2dcdcb8fc090 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 33 | capture | 01a1a56f-d961-76e3-88b8-3c6b8c32a7c5 | €24.00 | €0.37 | duplicate line |
| 63 | capture | 01a1a572-24be-757d-b404-e2118640ddb7 | €24.00 | €0.38 | fee difference |
| 68 | refund | 01a1a572-68e8-70f5-98cb-550cf3599533 | -€8.00 | €0.00 | duplicate line |
| 71 | capture | 01a1a572-c3b9-74d4-8ee4-eb4225f89162 | €9.00 | €0.19 | duplicate line |
| 1 | capture | 01a1a566-82a9-76bc-a785-0210586cb5c6 | €15.00 | €0.26 | matched |
| 2 | capture | 01a1a56a-91d2-7003-a984-24f3770d14d3 | €24.00 | €0.37 | matched |
| 3 | capture | 01a1a56a-c623-72ca-bb17-e08a3ba33366 | €15.00 | €0.26 | matched |
| 4 | capture | 01a1a56d-def8-755a-84fa-417e315921c5 | €15.00 | €0.26 | matched |
| 5 | capture | 01a1a56d-eebd-70eb-8eee-ef02c80d53d8 | €49.00 | €0.67 | matched |
| 6 | capture | 01a1a56d-fb2e-7f51-bcac-332288c5fe4b | €49.00 | €0.67 | matched |
| 7 | capture | 01a1a56e-125a-7d37-bc81-150b4fb32c4c | €35.00 | €0.50 | matched |
| 8 | capture | 01a1a56e-176f-777d-8cbf-ebc0a320f9d9 | €35.00 | €0.50 | matched |
| 9 | capture | 01a1a56e-27c0-7603-b04d-79bd3cb92eba | €15.00 | €0.26 | matched |
| 10 | capture | 01a1a56e-3e09-7207-92d7-85e471e13206 | €49.00 | €0.67 | matched |
| 11 | capture | 01a1a56e-3e4d-7f93-87e1-11005eed7879 | €9.00 | €0.19 | matched |
| 12 | capture | 01a1a56e-4673-7eda-8102-3fa5b07ead21 | €35.00 | €0.50 | matched |
| 13 | capture | 01a1a56e-6521-7a3b-a408-2068e1d2cf99 | €35.00 | €0.50 | matched |
| 14 | capture | 01a1a56e-8de9-7d5f-9529-f84643a10385 | €15.00 | €0.26 | matched |
| 15 | capture | 01a1a56e-927e-7455-aa02-905ae015d625 | €24.00 | €0.37 | matched |
| 16 | capture | 01a1a56e-c8ee-7eae-9bd9-c5f9e0cf5e0b | €9.00 | €0.19 | matched |
| 17 | capture | 01a1a56e-ca5d-7d56-9c1e-1032ed2ca714 | €35.00 | €0.50 | matched |
| 18 | capture | 01a1a56e-e414-7264-ae40-695dd20883f2 | €15.00 | €0.26 | matched |
| 19 | capture | 01a1a56f-19c4-7291-8d35-870f81e24696 | €35.00 | €0.50 | matched |
| 20 | capture | 01a1a56f-2caf-75df-85d8-b04cd74178ec | €15.00 | €0.26 | matched |
| 21 | capture | 01a1a56f-3b3a-76fa-9e19-0bae427a09b8 | €49.00 | €0.67 | matched |
| 22 | capture | 01a1a56f-3b8b-7266-b161-b0a18629a1dd | €35.00 | €0.50 | matched |
| 23 | capture | 01a1a56f-4118-7baa-b971-02c265f69b14 | €35.00 | €0.50 | matched |
| 24 | capture | 01a1a56f-743b-7fe8-8722-af3f18d697ff | €35.00 | €0.50 | matched |
| 25 | refund | 01a1a56f-a191-7d9e-b511-2cd07652d6c2 | -€22.00 | €0.00 | matched |
| 26 | capture | 01a1a56f-a446-742c-9ee7-723b923389e1 | €35.00 | €0.50 | matched |
| 27 | capture | 01a1a56f-ab43-7f70-a390-cc99552e67e2 | €49.00 | €0.67 | matched |
| 28 | capture | 01a1a56f-bcfd-7bc2-aeb6-a5a5cc367ddf | €35.00 | €0.50 | matched |
| 29 | capture | 01a1a56f-c475-79f9-bcca-f9955baebcfa | €24.00 | €0.37 | matched |
| 30 | capture | 01a1a56f-ca65-7d45-a7da-bcf0a58cf7c8 | €49.00 | €0.67 | matched |
| 31 | capture | 01a1a56f-d419-72c1-84e0-23f924416099 | €35.00 | €0.50 | matched |
| 32 | capture | 01a1a56f-d961-76e3-88b8-3c6b8c32a7c5 | €24.00 | €0.37 | matched |
| 34 | capture | 01a1a56f-da56-7c01-918d-efb16ab70175 | €49.00 | €0.67 | matched |
| 35 | capture | 01a1a56f-e235-7bf4-91c1-9b2c01ad7c95 | €35.00 | €0.50 | matched |
| 36 | capture | 01a1a56f-f94b-7bab-b98f-953df67870a3 | €9.00 | €0.19 | matched |
| 37 | capture | 01a1a570-051d-7b18-a021-6ee3c28cdb94 | €49.00 | €0.67 | matched |
| 38 | capture | 01a1a570-1269-7f98-9139-afc73bf78e51 | €35.00 | €0.50 | matched |
| 39 | capture | 01a1a570-36f1-7d64-94ef-4850513ddf34 | €15.00 | €0.26 | matched |
| 40 | refund | 01a1a570-3c47-79d0-8afe-fe03e8077ded | -€30.00 | €0.00 | matched |
| 41 | capture | 01a1a570-4404-7bc3-8729-f5719bd10114 | €24.00 | €0.37 | matched |
| 42 | capture | 01a1a570-6f79-7832-84d3-844baf400b86 | €49.00 | €0.67 | matched |
| 43 | capture | 01a1a570-7c30-7be8-8f5a-7a6656ea504d | €9.00 | €0.19 | matched |
| 44 | capture | 01a1a570-86ee-7cef-83cc-2b3d6e850fc7 | €35.00 | €0.50 | matched |
| 45 | capture | 01a1a570-9c17-70f9-ae5d-fb463f75648b | €9.00 | €0.19 | matched |
| 46 | capture | 01a1a570-bdb3-768f-ba82-a2e79dafc3da | €24.00 | €0.37 | matched |
| 47 | capture | 01a1a570-be3f-7dde-a02d-a54f59f5cf9a | €9.00 | €0.19 | matched |
| 48 | capture | 01a1a570-cbb6-7f05-8664-f8823d345cc5 | €15.00 | €0.26 | matched |
| 49 | capture | 01a1a570-eaba-7d25-8141-2a4a110bf938 | €24.00 | €0.37 | matched |
| 50 | capture | 01a1a570-e712-781b-8bb7-594685a22051 | €49.00 | €0.67 | matched |
| 51 | capture | 01a1a571-1521-75a3-ba8d-2172daca34d1 | €9.00 | €0.19 | matched |
| 52 | capture | 01a1a571-2314-7376-be92-9ca177b97d39 | €49.00 | €0.67 | matched |
| 53 | capture | 01a1a571-526f-7f87-87a9-1d8ce797e9ab | €15.00 | €0.26 | matched |
| 54 | capture | 01a1a571-6974-73f8-9046-81b7b83105f4 | €9.00 | €0.19 | matched |
| 55 | capture | 01a1a571-7474-724b-a346-b7f8012e43d5 | €15.00 | €0.26 | matched |
| 56 | capture | 01a1a571-79a8-74b9-90fb-944eaf8dfa4c | €24.00 | €0.37 | matched |
| 57 | refund | 01a1a571-864b-7df6-b99d-527f6ef151ff | -€13.00 | €0.00 | matched |
| 58 | capture | 01a1a571-8f48-7f54-a246-0d0976f84848 | €24.00 | €0.37 | matched |
| 59 | capture | 01a1a571-a55b-7204-8e16-962087075702 | €24.00 | €0.37 | matched |
| 60 | capture | 01a1a571-df2e-7046-bd09-8211bc6b0b2e | €49.00 | €0.67 | matched |
| 61 | capture | 01a1a572-02be-7927-a657-b53038fecf6b | €9.00 | €0.19 | matched |
| 62 | capture | 01a1a572-0faf-7ea0-9e7f-7bdad5f48af9 | €35.00 | €0.50 | matched |
| 64 | capture | 01a1a572-273e-79d1-8f55-7c6ac3859174 | €49.00 | €0.67 | matched |
| 65 | capture | 01a1a572-2ce2-7120-be53-f19efc5c3b07 | €9.00 | €0.19 | matched |
| 66 | capture | 01a1a572-4ae6-7524-a870-064a0560bc8e | €15.00 | €0.26 | matched |
| 67 | refund | 01a1a572-68e8-70f5-98cb-550cf3599533 | -€8.00 | €0.00 | matched |
| 69 | capture | 01a1a572-87b7-7e54-8e8a-6709837fd77f | €49.00 | €0.67 | matched |
| 70 | capture | 01a1a572-c3b9-74d4-8ee4-eb4225f89162 | €9.00 | €0.19 | matched |
| 72 | capture | 01a1a572-e3f7-733b-9192-94f259414f8f | €15.00 | €0.26 | matched |
| 73 | refund | 01a1a573-1eb5-7082-bac1-bd3c477885d9 | -€6.00 | €0.00 | matched |
| 74 | capture | 01a1a573-9036-7f47-8aa3-d0c40f3a4801 | €24.00 | €0.37 | matched |
| 75 | capture | 01a1a573-b717-7aa4-a496-8d2e9dbf3388 | €49.00 | €0.67 | matched |
| 76 | capture | 01a1a573-cb5c-7f7a-8c1d-49d1b830ce7a | €35.00 | €0.50 | matched |
| 77 | capture | 01a1a573-d949-75cf-a214-55b4156b1994 | €49.00 | €0.67 | matched |
| 78 | capture | 01a1a573-dfe8-725c-beff-b04f56cefe07 | €49.00 | €0.67 | matched |
| 79 | capture | 01a1a574-3d6a-7d27-9705-4f91906f3e09 | €35.00 | €0.50 | matched |
| 80 | capture | 01a1a574-46cd-7040-8077-a82635e9bd3a | €49.00 | €0.67 | matched |
| 81 | capture | 01a1a574-53c3-70fb-b146-72152b5a8060 | €24.00 | €0.37 | matched |
| 82 | capture | 01a1a574-79aa-78cf-857d-1c7b80e6bdc9 | €49.00 | €0.67 | matched |
| 83 | capture | 01a1a574-7c8c-7768-9763-5a4294989737 | €49.00 | €0.67 | matched |
| 84 | capture | 01a1a574-9042-7e26-97b0-26e52b9308a3 | €35.00 | €0.50 | matched |
| 85 | capture | 01a1a574-a674-767c-9ee6-02729452471a | €24.00 | €0.37 | matched |
| 86 | capture | 01a1a574-bbb4-73bd-af9f-f15af3329a10 | €49.00 | €0.67 | matched |
| 87 | capture | 01a1a574-c11c-7189-ba7d-8d19f3418e86 | €15.00 | €0.26 | matched |
| 88 | refund | 01a1a574-d12c-756f-bd20-4962ff3a4859 | -€10.00 | €0.00 | matched |
| 89 | capture | 01a1a574-d46a-7c46-bd36-e1aa6ba15091 | €9.00 | €0.19 | matched |
| 90 | capture | 01a1a574-dd12-701f-afd0-88ad832791b6 | €24.00 | €0.37 | matched |
| 91 | capture | 01a1a574-e21f-7c13-90b7-645c86b292e9 | €35.00 | €0.50 | matched |
| 92 | capture | 01a1a574-f36d-7d98-a452-fa5463805c34 | €24.00 | €0.37 | matched |
| 93 | capture | 01a1a574-f53a-73a4-a494-b1cc7fde81ee | €35.00 | €0.50 | matched |
| 94 | capture | 01a1a574-f96d-7eb9-a8b1-415cc3470ce7 | €9.00 | €0.19 | matched |
| 95 | refund | 01a1a575-0be6-79c9-8302-1d1465b832d9 | -€38.00 | €0.00 | matched |
| 96 | capture | 01a1a575-1598-7311-92e8-28e3122a2444 | €9.00 | €0.19 | matched |
| 97 | capture | 01a1a575-29f1-75af-bf08-6b2ba1b107f5 | €49.00 | €0.67 | matched |
| 98 | capture | 01a1a575-283a-7327-b1d1-2af3a7f8f6c2 | €15.00 | €0.26 | matched |
| 99 | capture | 01a1a575-33c2-7f80-97c2-c4daacf5b3f0 | €24.00 | €0.37 | matched |
| 100 | capture | 01a1a575-4545-7d75-bc2c-fd570903a627 | €9.00 | €0.19 | matched |
| 101 | capture | 01a1a575-5700-7fa3-8352-5bc068478f0a | €24.00 | €0.37 | matched |
| 102 | capture | 01a1a575-78ea-79cd-9202-cbcd22090a90 | €24.00 | €0.37 | matched |
| 103 | capture | 01a1a575-9381-7aa5-adb7-860430408412 | €9.00 | €0.19 | matched |
| 104 | capture | 01a1a575-a6ef-7e96-9197-a45db4d792c4 | €49.00 | €0.67 | matched |
| 105 | capture | 01a1a575-c118-774c-991f-537f92c42c72 | €49.00 | €0.67 | matched |
| 106 | capture | 01a1a575-f507-7d58-94c3-6127ee50c077 | €24.00 | €0.37 | matched |
| 107 | capture | 01a1a575-f965-7310-b98f-488b18ce7f77 | €49.00 | €0.67 | matched |
| 108 | capture | 01a1a576-06d2-7f0f-9d6e-40de34341726 | €24.00 | €0.37 | matched |
| 109 | capture | 01a1a576-1153-7958-ade4-7f095f24b933 | €49.00 | €0.67 | matched |
| 110 | capture | 01a1a576-1827-7637-8050-55c0351a3889 | €24.00 | €0.37 | matched |
| 111 | capture | 01a1a576-3523-79d8-8e23-e583defd5c90 | €24.00 | €0.37 | matched |
| 112 | capture | 01a1a576-3760-7023-a447-6732d925ad95 | €9.00 | €0.19 | matched |
| 113 | capture | 01a1a576-5f37-7197-91d6-e9e706981cff | €24.00 | €0.37 | matched |
| 114 | capture | 01a1a576-8765-70e8-beb8-c51324219be7 | €24.00 | €0.37 | matched |
| 115 | capture | 01a1a576-b53d-7662-b071-32ebcfa6f929 | €35.00 | €0.50 | matched |
| 116 | capture | 01a1a576-b73d-7fd2-8257-95fda7e63286 | €49.00 | €0.67 | matched |
| 117 | capture | 01a1a576-c3c0-7506-ac5f-963006742761 | €15.00 | €0.26 | matched |
| 118 | capture | 01a1a576-c692-7059-8e02-29c563db3ccf | €35.00 | €0.50 | matched |
| 119 | capture | 01a1a576-e4c2-7dd7-91fe-b4840b9e4907 | €9.00 | €0.19 | matched |