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
- 20 Oct, 23:10123 lines1 break
- 20 Oct, 23:00124 lines1 break
- 20 Oct, 22:50113 lines2 breaks
- 20 Oct, 22:40124 lines3 breaks
- 20 Oct, 22:30126 lines2 breaks
- 20 Oct, 22:20129 lines2 breaks
- 20 Oct, 22:10133 lines2 breaks
- 20 Oct, 22:00124 lines3 breaks
- 20 Oct, 21:50144 lines2 breaks
- 20 Oct, 21:40122 lines4 breaks
- 20 Oct, 21:30123 lines2 breaks
- 20 Oct, 21:20129 lines2 breaks
- 20 Oct, 21:10140 lines3 breaks
- 20 Oct, 21:00116 lines1 break
20 Oct, 21:40
Gross
€2,575.00
PSP fee
€43.29
Net to the bank
€2,531.71
Settlement journal
#112330
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a15b49-8c8c-72a0-849a-5588e21e57bf is already settled by stl_EUR_2987554 line 110
- fee differencethe fee is not the contract feethe fee is 3, the contract says 0
- missing linein the books, not in the filecapture:01a15b42-ca52-76f7-87df-248c78ac85b3 is in no file
- missing linein the books, not in the filecapture:01a15b48-0cf2-71fb-b5dc-28a2167cb77d is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 89 | refund | 01a15b48-6e9e-79cf-9e2d-4c4ccb926a22 | -€46.00 | €0.03 | fee difference |
| 111 | capture | 01a15b49-8cb3-70a8-b2d9-26b41f73c378 | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a15b3a-1953-71f6-8ba9-a40a1577c54e | €49.00 | €0.67 | matched |
| 2 | capture | 01a15b41-d7e1-7ab7-92dd-c8ee5a48c350 | €35.00 | €0.50 | matched |
| 3 | capture | 01a15b41-df63-7e8c-a49d-a20b7fe08a82 | €24.00 | €0.37 | matched |
| 4 | capture | 01a15b41-eac1-7f3a-bec3-5a39b34997aa | €49.00 | €0.67 | matched |
| 5 | capture | 01a15b41-ee40-78f5-b7a5-31e00579db65 | €15.00 | €0.26 | matched |
| 6 | capture | 01a15b42-0814-7c32-b3fa-5efdc6f7e49a | €15.00 | €0.26 | matched |
| 7 | capture | 01a15b42-35a1-7d50-ae53-4a47fcdb44cc | €49.00 | €0.67 | matched |
| 8 | capture | 01a15b42-3ebb-7d5b-a7e5-db76d62b7622 | €15.00 | €0.26 | matched |
| 9 | capture | 01a15b42-604f-7694-8d85-0dacd2fd67a3 | €24.00 | €0.37 | matched |
| 10 | refund | 01a15b42-62a4-7fd7-8852-d7287d011b07 | -€7.00 | €0.00 | matched |
| 11 | capture | 01a15b42-6ee7-7974-a8f7-e0d7bca4b856 | €35.00 | €0.50 | matched |
| 12 | capture | 01a15b42-6f09-7be7-b47c-4014d149f733 | €15.00 | €0.26 | matched |
| 13 | refund | 01a15b42-6b60-7dc1-88b4-83499e1bd788 | -€9.00 | €0.00 | matched |
| 14 | capture | 01a15b42-7522-79a7-ab4a-b3e16b690417 | €9.00 | €0.19 | matched |
| 15 | capture | 01a15b42-a191-7a30-96fe-f0cdafc64ee2 | €35.00 | €0.50 | matched |
| 16 | capture | 01a15b42-c3f4-7e86-8fa1-b65ebe221378 | €24.00 | €0.37 | matched |
| 17 | capture | 01a15b43-193c-70c4-87cb-7f4f70ea5887 | €9.00 | €0.19 | matched |
| 18 | capture | 01a15b43-20b2-7276-9219-d460164dbc1b | €15.00 | €0.26 | matched |
| 19 | capture | 01a15b43-260b-78fc-9f19-ab011be0ffe1 | €9.00 | €0.19 | matched |
| 20 | capture | 01a15b43-2c11-776e-91aa-5e369e8f00f0 | €15.00 | €0.26 | matched |
| 21 | capture | 01a15b43-42bf-7da5-a672-0e3a95394c29 | €15.00 | €0.26 | matched |
| 22 | capture | 01a15b43-46a2-75b2-86e4-5bc62f73f5aa | €35.00 | €0.50 | matched |
| 23 | capture | 01a15b43-4981-7358-81e9-807399d46f31 | €9.00 | €0.19 | matched |
| 24 | capture | 01a15b43-5aa4-7f46-999f-b16b7d22b05a | €24.00 | €0.37 | matched |
| 25 | capture | 01a15b43-5aa9-71d5-97d0-9a0dc39c980e | €9.00 | €0.19 | matched |
| 26 | capture | 01a15b43-624a-70bd-959d-1c6b4258aab8 | €35.00 | €0.50 | matched |
| 27 | capture | 01a15b43-8757-750d-a996-c86f24daf392 | €24.00 | €0.37 | matched |
| 28 | capture | 01a15b43-9c95-7ec8-8df4-78d52f33d78c | €35.00 | €0.50 | matched |
| 29 | capture | 01a15b43-a00c-7084-a4c1-f8090e0b4a01 | €35.00 | €0.50 | matched |
| 30 | capture | 01a15b43-a6f4-77cd-b550-b31bd14d5a02 | €35.00 | €0.50 | matched |
| 31 | capture | 01a15b43-d068-704e-8968-15bfb006d0b2 | €24.00 | €0.37 | matched |
| 32 | capture | 01a15b43-db1c-7fa3-8424-1b5e286e87c5 | €35.00 | €0.50 | matched |
| 33 | capture | 01a15b43-f509-7958-82ab-6876e16a4da4 | €24.00 | €0.37 | matched |
| 34 | capture | 01a15b44-42dd-7517-913b-09734cb032dd | €35.00 | €0.50 | matched |
| 35 | capture | 01a15b44-54c0-7446-acaf-b7279c756ce1 | €15.00 | €0.26 | matched |
| 36 | capture | 01a15b44-558d-7994-82cb-59b5cd7df074 | €9.00 | €0.19 | matched |
| 37 | capture | 01a15b44-7bf3-7264-a620-964cae155bef | €49.00 | €0.67 | matched |
| 38 | refund | 01a15b44-906e-7dde-984e-21dde1a11228 | -€12.00 | €0.00 | matched |
| 39 | capture | 01a15b44-94e8-7969-a961-0f68486ef688 | €9.00 | €0.19 | matched |
| 40 | capture | 01a15b44-9b0b-7eb5-b32a-cc68e43cae8a | €15.00 | €0.26 | matched |
| 41 | refund | 01a15b44-c5d0-7cb2-95d8-85ad38e241af | -€45.00 | €0.00 | matched |
| 42 | capture | 01a15b44-d8fd-7c00-bd7e-bfe88622daa1 | €35.00 | €0.50 | matched |
| 43 | capture | 01a15b44-e0e6-7f50-bc0f-c443079412d9 | €24.00 | €0.37 | matched |
| 44 | capture | 01a15b44-f79e-762f-9275-74b8d3e9ade5 | €35.00 | €0.50 | matched |
| 45 | refund | 01a15b44-fad0-7a5f-b863-221e84ad720b | -€4.00 | €0.00 | matched |
| 46 | capture | 01a15b44-fb8b-7293-a66e-0c22d6bfcd3f | €24.00 | €0.37 | matched |
| 47 | capture | 01a15b45-39da-7ab9-9bb5-d421c57538e5 | €35.00 | €0.50 | matched |
| 48 | capture | 01a15b45-439a-726d-8f5d-5bddbf2f4bfa | €24.00 | €0.37 | matched |
| 49 | capture | 01a15b45-6de9-7e58-9362-801b33a05917 | €24.00 | €0.37 | matched |
| 50 | capture | 01a15b45-6fe8-768a-92ae-50564050a480 | €24.00 | €0.37 | matched |
| 51 | capture | 01a15b45-79ec-72ce-80ac-30e886124dbb | €35.00 | €0.50 | matched |
| 52 | capture | 01a15b45-8309-732e-b864-2e96fafc050d | €24.00 | €0.37 | matched |
| 53 | capture | 01a15b45-8bac-7dbd-a5d6-793c4ff44cc5 | €24.00 | €0.37 | matched |
| 54 | capture | 01a15b45-9e35-7383-94d0-b4548e41d4f0 | €35.00 | €0.50 | matched |
| 55 | capture | 01a15b45-a16d-77d1-9a7e-bcf5ef21c085 | €24.00 | €0.37 | matched |
| 56 | capture | 01a15b45-a55f-71bd-a998-5d390d9b3a40 | €15.00 | €0.26 | matched |
| 57 | refund | 01a15b45-c9e2-734c-868a-f1feac48e68d | -€28.00 | €0.00 | matched |
| 58 | capture | 01a15b45-e175-70be-ba6d-80191aecb043 | €24.00 | €0.37 | matched |
| 59 | capture | 01a15b45-e360-7075-9791-37a5516650e4 | €35.00 | €0.50 | matched |
| 60 | capture | 01a15b45-f038-7e78-8981-0d9193d9870c | €15.00 | €0.26 | matched |
| 61 | capture | 01a15b45-f840-733d-9264-3b9bdb64d5fb | €15.00 | €0.26 | matched |
| 62 | capture | 01a15b45-f8a3-70af-8e0a-f694d75a9771 | €24.00 | €0.37 | matched |
| 63 | capture | 01a15b46-15f7-7f8e-813a-3ab233f7c3b7 | €49.00 | €0.67 | matched |
| 64 | capture | 01a15b46-2e5f-7368-afd0-82a4fd93607b | €49.00 | €0.67 | matched |
| 65 | refund | 01a15b46-4094-71d4-b379-ad900719481b | -€27.00 | €0.00 | matched |
| 66 | refund | 01a15b46-406d-749c-ac6f-11c1e53ceea2 | -€43.00 | €0.00 | matched |
| 67 | capture | 01a15b46-95b0-7110-9e91-624844679137 | €24.00 | €0.37 | matched |
| 68 | capture | 01a15b46-bd26-7dcd-85ca-4457ec4cb05d | €15.00 | €0.26 | matched |
| 69 | capture | 01a15b46-c0ce-7668-8a4d-a47caf41f683 | €49.00 | €0.67 | matched |
| 70 | capture | 01a15b46-ebde-7e68-98d7-4bfe8a62b260 | €49.00 | €0.67 | matched |
| 71 | capture | 01a15b46-f35b-77b9-b4fd-be4217875a3f | €24.00 | €0.37 | matched |
| 72 | capture | 01a15b47-10cb-71a2-999f-1187e3d61318 | €15.00 | €0.26 | matched |
| 73 | capture | 01a15b47-2ca5-7037-8207-e949a567f499 | €15.00 | €0.26 | matched |
| 74 | capture | 01a15b47-340d-7c9f-a686-70b77605fb54 | €24.00 | €0.37 | matched |
| 75 | refund | 01a15b47-3652-735e-8c9c-af68a6fd618c | -€40.00 | €0.00 | matched |
| 76 | capture | 01a15b47-394b-7382-9c65-884da6f47a27 | €15.00 | €0.26 | matched |
| 77 | capture | 01a15b47-4121-7d14-b2a0-1df623370007 | €15.00 | €0.26 | matched |
| 78 | capture | 01a15b47-79db-71c0-8871-c4173d17b20e | €35.00 | €0.50 | matched |
| 79 | capture | 01a15b47-7bb0-702f-bb77-17c5ad946ab2 | €35.00 | €0.50 | matched |
| 80 | capture | 01a15b47-a338-79f9-a56b-abcefae4eda9 | €24.00 | €0.37 | matched |
| 81 | capture | 01a15b47-a5c9-759b-ae1a-eb5b6a6e9fa8 | €24.00 | €0.37 | matched |
| 82 | capture | 01a15b47-a229-702e-b491-ace74cde22bb | €15.00 | €0.26 | matched |
| 83 | capture | 01a15b47-d0bb-792f-8705-8c45d7c9d13d | €24.00 | €0.37 | matched |
| 84 | capture | 01a15b47-d8b0-70f0-a303-456962ce7b9f | €35.00 | €0.50 | matched |
| 85 | capture | 01a15b47-fee9-71fd-9cc4-4c04fe89487d | €9.00 | €0.19 | matched |
| 86 | capture | 01a15b48-26b3-713f-8e88-14dfbc8ae907 | €49.00 | €0.67 | matched |
| 87 | capture | 01a15b48-2bdd-7c84-8d05-eef78caba446 | €49.00 | €0.67 | matched |
| 88 | capture | 01a15b48-5326-7cec-a788-8e170bf7c009 | €9.00 | €0.19 | matched |
| 90 | capture | 01a15b48-8a5f-7974-a3eb-45c8d60381b3 | €9.00 | €0.19 | matched |
| 91 | capture | 01a15b48-8dd9-79df-8b37-a265e4714f0f | €49.00 | €0.67 | matched |
| 92 | capture | 01a15b48-95f7-700d-9fd0-28e472110d7e | €35.00 | €0.50 | matched |
| 93 | capture | 01a15b48-a4d9-7468-9f0e-0e82a42e2f8d | €9.00 | €0.19 | matched |
| 94 | capture | 01a15b48-ae5e-71b0-aed7-6c751c48c4b7 | €35.00 | €0.50 | matched |
| 95 | capture | 01a15b48-af9f-7049-998c-95ec36695fc3 | €15.00 | €0.26 | matched |
| 96 | capture | 01a15b48-b80f-78af-8b68-6eb16d012937 | €24.00 | €0.37 | matched |
| 97 | capture | 01a15b48-c8c7-7234-b358-99b1d5df1503 | €35.00 | €0.50 | matched |
| 98 | capture | 01a15b48-c92c-702f-93f0-f3d6fff0209d | €35.00 | €0.50 | matched |
| 99 | capture | 01a15b48-e9fb-7777-8e42-2a351a8942fb | €49.00 | €0.67 | matched |
| 100 | capture | 01a15b49-2f44-7d23-9f56-6bbf1c7e69bc | €15.00 | €0.26 | matched |
| 101 | capture | 01a15b49-3a87-77ad-89cd-0b8fd9a9044f | €15.00 | €0.26 | matched |
| 102 | capture | 01a15b49-4b4b-7434-b0fc-a888d25256dc | €24.00 | €0.37 | matched |
| 103 | capture | 01a15b49-5630-7baf-8f46-afacc5d1bd45 | €24.00 | €0.37 | matched |
| 104 | capture | 01a15b49-596a-7bf0-9929-42b46cc92b9a | €9.00 | €0.19 | matched |
| 105 | capture | 01a15b49-70ae-75da-bc6a-1bbd85cfcd28 | €9.00 | €0.19 | matched |
| 106 | capture | 01a15b49-77b7-7a61-aa0e-f0805fb60153 | €15.00 | €0.26 | matched |
| 107 | capture | 01a15b49-7a02-707f-bdbf-59c5d12c7fb1 | €49.00 | €0.67 | matched |
| 108 | capture | 01a15b49-8196-7829-8cb4-ca23d6f94b79 | €35.00 | €0.50 | matched |
| 109 | capture | 01a15b49-8517-7ab7-87ee-0404d099a19e | €49.00 | €0.67 | matched |
| 110 | capture | 01a15b49-8cb3-70a8-b2d9-26b41f73c378 | €24.00 | €0.37 | matched |
| 112 | capture | 01a15b49-9025-7d2b-91be-a84858c6af11 | €35.00 | €0.50 | matched |
| 113 | refund | 01a15b49-cafd-7b77-8621-71d5b861235c | -€19.00 | €0.00 | matched |
| 114 | capture | 01a15b49-dcfb-7442-a26b-cb9f3cb14fc5 | €15.00 | €0.26 | matched |
| 115 | capture | 01a15b49-ee0b-7229-bf99-2cc7a6e083c6 | €9.00 | €0.19 | matched |
| 116 | capture | 01a15b49-fad3-7332-90cc-8f251470dfb4 | €24.00 | €0.37 | matched |
| 117 | capture | 01a15b4a-2584-73c5-9010-ee02c424cdad | €49.00 | €0.67 | matched |
| 118 | capture | 01a15b4a-3515-74b4-8d05-26440f03627e | €15.00 | €0.26 | matched |
| 119 | capture | 01a15b4a-a0bc-7a14-a954-58a96b29a1af | €24.00 | €0.37 | matched |
| 120 | capture | 01a15b4a-a41c-7092-a05c-7efdccd73888 | €9.00 | €0.19 | matched |
| 121 | capture | 01a15b4a-b2e2-7f3b-a372-1630f57467fc | €15.00 | €0.26 | matched |
| 122 | capture | 01a15b4a-ccbc-7f8b-b987-bdd1d7599b7b | €15.00 | €0.26 | matched |