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
- 16 Oct, 08:10118 lines2 breaks
- 16 Oct, 08:00129 lines2 breaks
- 16 Oct, 07:50148 lines4 breaks
- 16 Oct, 07:40115 lines2 breaks
- 16 Oct, 07:30130 lines1 break
- 16 Oct, 07:20143 lines3 breaks
- 16 Oct, 07:10129 lines2 breaks
- 16 Oct, 07:00143 lines6 breaks
- 16 Oct, 06:50122 lines4 breaks
- 16 Oct, 06:40116 linesclean
- 16 Oct, 06:30122 lines4 breaks
- 16 Oct, 06:20145 lines1 break
- 16 Oct, 06:10141 lines3 breaks
- 16 Oct, 06:00131 lines3 breaks
16 Oct, 07:00
Gross
€3,309.00
PSP fee
€52.60
Net to the bank
€3,256.40
Settlement journal
#29050
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14383-5944-77bb-9ec1-2511e64001bd is already settled by stl_EUR_2986890 line 15
- duplicate linethe file lists it twicerefund:01a14384-5859-7d0e-bc4e-b66e5ab22217 is already settled by stl_EUR_2986890 line 30
- fee differencethe fee is not the contract feethe fee is 40, the contract says 37
- missing linein the books, not in the filecapture:01a14387-3cdb-7209-99c6-05d1b6657795 is in no file
- missing linein the books, not in the filecapture:01a14389-8c7f-7632-8af3-c45273e201f0 is in no file
- missing linein the books, not in the filecapture:01a1438a-a8a2-77b5-9c71-0bb30eaafdb7 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 16 | capture | 01a14383-596d-7692-aa00-8124725addec | €49.00 | €0.67 | duplicate line |
| 31 | refund | 01a14384-585b-7c87-858c-f9da4ab62fd2 | -€3.00 | €0.00 | duplicate line |
| 107 | capture | 01a14388-6fea-7fab-b936-1c109b9a300c | €24.00 | €0.40 | fee difference |
| 1 | capture | 01a1437b-c8bc-7417-81b7-ed78c56615b5 | €15.00 | €0.26 | matched |
| 2 | capture | 01a1437b-cc4b-7fce-874b-7463d9c21c3d | €35.00 | €0.50 | matched |
| 3 | capture | 01a1437d-4960-7a64-99fb-7eaba058aa3f | €15.00 | €0.26 | matched |
| 4 | capture | 01a14380-3b65-782c-9707-975b8eb17969 | €49.00 | €0.67 | matched |
| 5 | capture | 01a14381-676c-739d-8981-3e8b905f3d7f | €9.00 | €0.19 | matched |
| 6 | capture | 01a14382-d232-7675-9829-a05cb1f9ab6b | €9.00 | €0.19 | matched |
| 7 | capture | 01a14382-d7fd-79f4-a190-7acac44d0e71 | €49.00 | €0.67 | matched |
| 8 | capture | 01a14382-fbc6-73fa-83b9-ec37f536f7fa | €15.00 | €0.26 | matched |
| 9 | refund | 01a14383-02c7-7bed-9e77-370984235c41 | -€11.00 | €0.00 | matched |
| 10 | capture | 01a14383-38b4-7bb7-95ef-b2ff92946a84 | €24.00 | €0.37 | matched |
| 11 | capture | 01a14383-4116-71d5-87ba-67b4de3639a2 | €49.00 | €0.67 | matched |
| 12 | capture | 01a14383-4ddb-711b-9a58-4e70ee0a0e40 | €35.00 | €0.50 | matched |
| 13 | capture | 01a14383-50e7-7a8c-910f-561bd7f4eee2 | €15.00 | €0.26 | matched |
| 14 | capture | 01a14383-5285-7bcc-a115-ce3eaa902c9b | €49.00 | €0.67 | matched |
| 15 | capture | 01a14383-596d-7692-aa00-8124725addec | €49.00 | €0.67 | matched |
| 17 | capture | 01a14383-68a1-7c00-84e6-52d413f8d707 | €9.00 | €0.19 | matched |
| 18 | capture | 01a14383-7950-71cc-8038-4927422e9bc9 | €9.00 | €0.19 | matched |
| 19 | capture | 01a14383-7f5a-7787-9b9d-039cdfc5a296 | €24.00 | €0.37 | matched |
| 20 | capture | 01a14383-8484-7176-bd1b-fdc15b648725 | €15.00 | €0.26 | matched |
| 21 | capture | 01a14383-a723-7c13-9fb1-c9210fe77a3d | €49.00 | €0.67 | matched |
| 22 | capture | 01a14383-b110-7beb-8202-a6801d4d17b0 | €24.00 | €0.37 | matched |
| 23 | capture | 01a14383-bf8c-7ee4-9e58-2632b2b64e7e | €35.00 | €0.50 | matched |
| 24 | capture | 01a14383-ee94-7880-b6c5-a3134f684d89 | €15.00 | €0.26 | matched |
| 25 | capture | 01a14383-f77c-7308-86c3-7f8db9478d03 | €9.00 | €0.19 | matched |
| 26 | capture | 01a14384-30a3-7999-84a4-d1382edc1d67 | €49.00 | €0.67 | matched |
| 27 | capture | 01a14384-329b-7fb8-94a2-c6ab5877e458 | €49.00 | €0.67 | matched |
| 28 | capture | 01a14384-5095-7376-85e9-8c69fb5e2eb4 | €35.00 | €0.50 | matched |
| 29 | capture | 01a14384-5217-784b-aa8d-ed92a2bbfab3 | €24.00 | €0.37 | matched |
| 30 | refund | 01a14384-585b-7c87-858c-f9da4ab62fd2 | -€3.00 | €0.00 | matched |
| 32 | capture | 01a14384-6c1b-71ef-b70a-a6622ab6b56e | €24.00 | €0.37 | matched |
| 33 | capture | 01a14384-56d1-7950-a251-f13085efe565 | €35.00 | €0.50 | matched |
| 34 | capture | 01a14384-7344-73ba-ad74-9d3a3af51788 | €15.00 | €0.26 | matched |
| 35 | refund | 01a14384-8feb-748b-ba0b-d5de97e3e9b0 | -€8.00 | €0.00 | matched |
| 36 | capture | 01a14384-9721-7fd4-9710-db4acfcd2027 | €35.00 | €0.50 | matched |
| 37 | capture | 01a14384-a3a8-78ef-87e4-b7f7e7678279 | €35.00 | €0.50 | matched |
| 38 | capture | 01a14384-c378-7163-b81f-baa1aae19ac3 | €24.00 | €0.37 | matched |
| 39 | capture | 01a14384-c4c5-759e-b28f-5453a717e5a2 | €35.00 | €0.50 | matched |
| 40 | capture | 01a14384-ce81-757a-819f-84b3c5e31c67 | €24.00 | €0.37 | matched |
| 41 | capture | 01a14384-d238-7943-be06-e3d4e2bf18a7 | €49.00 | €0.67 | matched |
| 42 | refund | 01a14384-e0fa-791a-9a79-5b05d5692a2a | -€34.00 | €0.00 | matched |
| 43 | capture | 01a14384-ff09-770f-86d3-b487a473dde4 | €35.00 | €0.50 | matched |
| 44 | capture | 01a14385-1ebf-79ad-80ff-655014aaf75d | €24.00 | €0.37 | matched |
| 45 | capture | 01a14385-2b11-75f2-9fb0-bcc61fcc8722 | €35.00 | €0.50 | matched |
| 46 | capture | 01a14385-393b-7479-8d44-0fdd44bc2d29 | €9.00 | €0.19 | matched |
| 47 | capture | 01a14385-3c62-76dd-a59d-8974aba9a003 | €15.00 | €0.26 | matched |
| 48 | capture | 01a14385-67d4-7709-a7a0-27c9c217731d | €24.00 | €0.37 | matched |
| 49 | capture | 01a14385-685d-7953-82ba-65c8c3131220 | €24.00 | €0.37 | matched |
| 50 | capture | 01a14385-7fdc-77cc-8fff-8759a23d486f | €35.00 | €0.50 | matched |
| 51 | capture | 01a14385-8913-7dc8-ad1a-d7522de16a94 | €15.00 | €0.26 | matched |
| 52 | capture | 01a14385-8950-7bc1-b9ed-97623a70974c | €49.00 | €0.67 | matched |
| 53 | capture | 01a14385-8c85-7c1f-9d41-acd9d23f6135 | €35.00 | €0.50 | matched |
| 54 | capture | 01a14385-97bd-7878-a9b7-9afb77780343 | €35.00 | €0.50 | matched |
| 55 | capture | 01a14385-989a-79c9-9b9e-0ed1c87ed626 | €9.00 | €0.19 | matched |
| 56 | capture | 01a14385-9ddd-7df6-ad15-84ef035547cb | €35.00 | €0.50 | matched |
| 57 | capture | 01a14385-a779-73cc-88fc-7b42081027f3 | €15.00 | €0.26 | matched |
| 58 | refund | 01a14385-cf47-79c4-a2b2-9797cb863a06 | -€16.00 | €0.00 | matched |
| 59 | capture | 01a14385-d02c-7195-8446-4ce5106a07f6 | €49.00 | €0.67 | matched |
| 60 | capture | 01a14385-d7be-7b73-9a0c-09a6c83d303c | €49.00 | €0.67 | matched |
| 61 | capture | 01a14385-efc4-7cd5-98f1-33607e90b656 | €24.00 | €0.37 | matched |
| 62 | capture | 01a14385-f1e8-7630-b05f-ceb1d64cd463 | €49.00 | €0.67 | matched |
| 63 | capture | 01a14386-19b6-7f36-bb09-3dde06de7689 | €15.00 | €0.26 | matched |
| 64 | capture | 01a14386-1bd2-76e8-afe5-9b959dcb723a | €24.00 | €0.37 | matched |
| 65 | capture | 01a14386-28af-726a-a5a1-564635bf127d | €9.00 | €0.19 | matched |
| 66 | refund | 01a14386-2d0b-754b-b3f2-df8d60f8ee56 | -€34.00 | €0.00 | matched |
| 67 | capture | 01a14386-35af-797f-855c-bd30af79961c | €9.00 | €0.19 | matched |
| 68 | capture | 01a14386-3fa5-7c36-ba17-975f37a1d72d | €15.00 | €0.26 | matched |
| 69 | capture | 01a14386-5461-7dca-9d75-dbc56bdc32db | €35.00 | €0.50 | matched |
| 70 | capture | 01a14386-6292-7b94-aefb-ebd22bf66f02 | €9.00 | €0.19 | matched |
| 71 | refund | 01a14386-69a6-700a-8a98-5825b4ae532d | -€6.00 | €0.00 | matched |
| 72 | capture | 01a14386-6da5-7d96-b295-3e129f5415c2 | €9.00 | €0.19 | matched |
| 73 | capture | 01a14386-9664-7aa1-a686-b653020c9676 | €9.00 | €0.19 | matched |
| 74 | capture | 01a14386-9a1e-750d-bf6f-31312883c6bb | €24.00 | €0.37 | matched |
| 75 | capture | 01a14386-a99c-78ed-afb2-966c000da85e | €15.00 | €0.26 | matched |
| 76 | capture | 01a14386-d942-799d-b258-cdf9f1c46c86 | €9.00 | €0.19 | matched |
| 77 | capture | 01a14386-fbac-75d9-8737-ed5d2778710b | €24.00 | €0.37 | matched |
| 78 | capture | 01a14386-fbb7-79ee-a0cd-24eb934f3235 | €49.00 | €0.67 | matched |
| 79 | capture | 01a14387-0d82-7d48-8f31-ddfc53cd1f4c | €15.00 | €0.26 | matched |
| 80 | capture | 01a14387-1e14-7f60-ae2f-9d001dfe300e | €9.00 | €0.19 | matched |
| 81 | capture | 01a14387-2b28-7096-a472-a7381f085d68 | €24.00 | €0.37 | matched |
| 82 | capture | 01a14387-2c72-7138-a89f-1c626bf7ab19 | €49.00 | €0.67 | matched |
| 83 | capture | 01a14387-44b4-7fd7-b0b8-738355d6df12 | €9.00 | €0.19 | matched |
| 84 | capture | 01a14387-5cce-772b-8dbe-c5a3d64d6702 | €35.00 | €0.50 | matched |
| 85 | capture | 01a14387-66fe-7f26-b31f-0c6dc708e50a | €49.00 | €0.67 | matched |
| 86 | refund | 01a14387-679c-7da6-ba2d-bb49ce04a01a | -€12.00 | €0.00 | matched |
| 87 | capture | 01a14387-7116-70ae-8131-5418e08df2a9 | €24.00 | €0.37 | matched |
| 88 | capture | 01a14387-71f7-7087-a6d6-b097493c28ea | €9.00 | €0.19 | matched |
| 89 | capture | 01a14387-7966-7393-8ba5-9a205c711eb8 | €24.00 | €0.37 | matched |
| 90 | capture | 01a14387-7a17-7b45-a891-27c5c912a483 | €49.00 | €0.67 | matched |
| 91 | capture | 01a14387-953e-75f2-ac06-e6b5aff0ec92 | €49.00 | €0.67 | matched |
| 92 | capture | 01a14387-c102-71a2-ad47-c1ba06a4d852 | €24.00 | €0.37 | matched |
| 93 | capture | 01a14387-d708-77f4-a6a3-41a48f64af4b | €49.00 | €0.67 | matched |
| 94 | capture | 01a14387-df0a-7e83-9d52-7b16795fe391 | €35.00 | €0.50 | matched |
| 95 | capture | 01a14387-e341-71c5-a6a7-433c553b71bc | €24.00 | €0.37 | matched |
| 96 | capture | 01a14387-ef6f-7ef4-80ab-ee8430db85c6 | €35.00 | €0.50 | matched |
| 97 | refund | 01a14387-f725-77af-9e5c-122527fc46e4 | -€13.00 | €0.00 | matched |
| 98 | capture | 01a14388-0bcb-7661-ae4d-09ef2c205cf4 | €24.00 | €0.37 | matched |
| 99 | capture | 01a14388-0d59-71e2-8e9f-de004d0c55c1 | €15.00 | €0.26 | matched |
| 100 | capture | 01a14388-1131-78e9-9cd0-309ae428b6c1 | €9.00 | €0.19 | matched |
| 101 | capture | 01a14388-1501-7594-8ac5-f28b5b0b4543 | €15.00 | €0.26 | matched |
| 102 | refund | 01a14388-408d-7542-9013-594063adbdcc | -€36.00 | €0.00 | matched |
| 103 | capture | 01a14388-5cc1-7b6c-8546-5cf7c407f6ec | €35.00 | €0.50 | matched |
| 104 | capture | 01a14388-5f77-78fb-9427-105636ce40c6 | €24.00 | €0.37 | matched |
| 105 | capture | 01a14388-6343-7fcf-8b89-b8695a3852c4 | €49.00 | €0.67 | matched |
| 106 | capture | 01a14388-6b8f-7804-8603-b8f2929f1d7a | €35.00 | €0.50 | matched |
| 108 | capture | 01a14388-7092-70fb-8ca0-b685e225cf36 | €24.00 | €0.37 | matched |
| 109 | capture | 01a14388-8383-7365-bb1e-052585fc665b | €24.00 | €0.37 | matched |
| 110 | capture | 01a14388-ff5b-7624-8041-90017f3dfd10 | €35.00 | €0.50 | matched |
| 111 | capture | 01a14389-165f-7879-8810-efd25406a419 | €35.00 | €0.50 | matched |
| 112 | capture | 01a14389-17b2-78dd-8f5a-0bb1f0a160ca | €9.00 | €0.19 | matched |
| 113 | capture | 01a14389-2cd8-726b-8ae6-bd398b130d08 | €9.00 | €0.19 | matched |
| 114 | capture | 01a14389-3043-7895-8b26-013cecf48d6c | €15.00 | €0.26 | matched |
| 115 | capture | 01a14389-5256-7246-9281-85a0a0bf1678 | €35.00 | €0.50 | matched |
| 116 | capture | 01a14389-5b0e-7d13-889a-fd5feb934746 | €9.00 | €0.19 | matched |
| 117 | capture | 01a14389-5d8b-79b9-a850-2ce3929b3140 | €49.00 | €0.67 | matched |
| 118 | capture | 01a14389-9029-74f8-be7c-ef3cff20a7c0 | €9.00 | €0.19 | matched |
| 119 | capture | 01a14389-a493-76f3-a74d-216c1079c63d | €9.00 | €0.19 | matched |
| 120 | capture | 01a14389-a728-7eda-b49b-dbcf99317996 | €35.00 | €0.50 | matched |
| 121 | capture | 01a14389-dad0-7904-b1eb-4789db4c8e5e | €49.00 | €0.67 | matched |
| 122 | capture | 01a14389-ea5f-70d1-97f9-6e3db6479802 | €35.00 | €0.50 | matched |
| 123 | capture | 01a14389-ebfd-714e-af4a-bbbef7e962a4 | €15.00 | €0.26 | matched |
| 124 | capture | 01a1438a-23fc-72b7-a289-fde958487470 | €35.00 | €0.50 | matched |
| 125 | capture | 01a1438a-2944-7b63-9282-a18ac6ac844c | €15.00 | €0.26 | matched |
| 126 | capture | 01a1438a-3e16-7403-965d-6dc3807d8693 | €24.00 | €0.37 | matched |
| 127 | capture | 01a1438a-402b-7df7-98e0-c94d707b9adb | €49.00 | €0.67 | matched |
| 128 | refund | 01a1438a-4612-7347-929d-976a90ec8d74 | -€9.00 | €0.00 | matched |
| 129 | capture | 01a1438a-6710-720e-82ba-200108fad949 | €49.00 | €0.67 | matched |
| 130 | capture | 01a1438a-6d5a-7416-ae2a-72124538a0b7 | €9.00 | €0.19 | matched |
| 131 | capture | 01a1438a-8ab7-7214-81c6-95712c953f60 | €35.00 | €0.50 | matched |
| 132 | capture | 01a1438a-8eb9-7465-ba84-de48e66c8523 | €35.00 | €0.50 | matched |
| 133 | capture | 01a1438a-a0ba-70e6-a4d8-958fbd07de51 | €9.00 | €0.19 | matched |
| 134 | capture | 01a1438a-a2af-7bd1-b855-730f9e39270a | €15.00 | €0.26 | matched |
| 135 | capture | 01a1438a-be74-75a1-b323-426920a263e1 | €15.00 | €0.26 | matched |
| 136 | capture | 01a1438a-cbb5-760f-a70c-673e29b130df | €9.00 | €0.19 | matched |
| 137 | capture | 01a1438a-ef17-7fd3-a4f5-3e6fb082ee28 | €35.00 | €0.50 | matched |
| 138 | refund | 01a1438b-00c2-77c0-a398-bb6cda36a5c2 | -€7.00 | €0.00 | matched |
| 139 | capture | 01a1438b-1faf-7350-94a7-5328048dd073 | €24.00 | €0.37 | matched |
| 140 | capture | 01a1438b-308c-7713-a21e-f096b470f980 | €9.00 | €0.19 | matched |
| 141 | capture | 01a1438b-41e7-71c4-87ec-0589bba7700b | €49.00 | €0.67 | matched |
| 142 | capture | 01a1438b-4e1e-763e-a5f7-3cd71558859e | €15.00 | €0.26 | matched |
| 143 | capture | 01a1438b-56e1-723d-a4aa-ffb14d007c62 | €24.00 | €0.37 | matched |