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
- 5 Nov, 15:40138 lines2 breaks
- 5 Nov, 15:30128 lines1 break
- 5 Nov, 15:20119 lines3 breaks
- 5 Nov, 15:10115 lines2 breaks
- 5 Nov, 15:00122 lines1 break
- 5 Nov, 14:50134 lines7 breaks
- 5 Nov, 14:40125 lines2 breaks
- 5 Nov, 14:30121 lines3 breaks
- 5 Nov, 14:20118 lines3 breaks
- 5 Nov, 14:10113 lines4 breaks
- 5 Nov, 14:00138 lines2 breaks
- 5 Nov, 13:50122 lines2 breaks
- 5 Nov, 13:40114 lines2 breaks
- 5 Nov, 13:30141 lines1 break
5 Nov, 14:50
Gross
€2,858.00
PSP fee
€46.76
Net to the bank
€2,811.24
Settlement journal
#399434
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a1ac31-caef-7a77-80b6-9a699525a669 is already settled by stl_EUR_2989817 line 27
- duplicate linethe file lists it twicecapture:01a1ac38-14ef-784d-83fc-3d6aad524078 is already settled by stl_EUR_2989817 line 119
- fee differencethe fee is not the contract feethe fee is 40, the contract says 37
- fee differencethe fee is not the contract feethe fee is 4, the contract says 0
- missing linein the books, not in the filecapture:01a1ac35-8aef-7824-b91c-cb8ed41ab246 is in no file
- missing linein the books, not in the filecapture:01a1ac36-3b75-734c-9f2b-8bc494f15f90 is in no file
- missing linein the books, not in the filecapture:01a1ac37-cfdc-7e54-9591-c4c407c1087b is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 28 | refund | 01a1ac31-caf1-7d40-adff-8264ecd16a57 | -€11.00 | €0.00 | duplicate line |
| 40 | capture | 01a1ac32-4c59-7361-95c1-56e1aa91e54f | €24.00 | €0.40 | fee difference |
| 103 | refund | 01a1ac37-2771-7a98-abb8-a9640b2caeeb | -€6.00 | €0.04 | fee difference |
| 120 | capture | 01a1ac38-236a-7738-84f3-fa193f87005d | €15.00 | €0.26 | duplicate line |
| 1 | capture | 01a1ac2a-0e9b-7bc3-88f6-ac0dadc78b03 | €35.00 | €0.50 | matched |
| 2 | capture | 01a1ac2a-66cd-714d-81e6-16270086daad | €24.00 | €0.37 | matched |
| 3 | capture | 01a1ac2b-cf42-7e19-987a-cab8d7e81fae | €9.00 | €0.19 | matched |
| 4 | capture | 01a1ac2e-1711-737d-ae20-178e11608bba | €15.00 | €0.26 | matched |
| 5 | capture | 01a1ac30-4b19-7c2f-8ce3-2d423fcbe1b6 | €24.00 | €0.37 | matched |
| 6 | capture | 01a1ac30-60be-7819-8cc9-1a37b29f7590 | €35.00 | €0.50 | matched |
| 7 | capture | 01a1ac30-610d-759e-b17e-2f52c87c0598 | €9.00 | €0.19 | matched |
| 8 | capture | 01a1ac30-7ea8-73dd-a9ef-791d6f05f1b3 | €49.00 | €0.67 | matched |
| 9 | capture | 01a1ac30-806c-70c5-87ae-5e4342153b69 | €49.00 | €0.67 | matched |
| 10 | capture | 01a1ac30-a011-7361-840d-6533c4378cb8 | €9.00 | €0.19 | matched |
| 11 | capture | 01a1ac30-a456-7e91-9f09-3d7d3d708515 | €24.00 | €0.37 | matched |
| 12 | capture | 01a1ac30-b1d5-7dba-bf94-a89c1125f761 | €49.00 | €0.67 | matched |
| 13 | capture | 01a1ac30-c630-7434-bd22-afcf10e607fa | €15.00 | €0.26 | matched |
| 14 | capture | 01a1ac30-cfa9-71a5-82ad-fa5a9372ac96 | €49.00 | €0.67 | matched |
| 15 | refund | 01a1ac30-d530-789b-ac67-01d2522ed0e8 | -€31.00 | €0.00 | matched |
| 16 | capture | 01a1ac31-2b44-79f5-9dda-c8983169294e | €35.00 | €0.50 | matched |
| 17 | capture | 01a1ac31-2ee0-7616-b40f-b2f5c45cd81c | €9.00 | €0.19 | matched |
| 18 | capture | 01a1ac31-32f1-7147-b842-cc3da6b755e0 | €24.00 | €0.37 | matched |
| 19 | capture | 01a1ac31-4af6-7eb8-bf95-bc9fb6864e47 | €35.00 | €0.50 | matched |
| 20 | capture | 01a1ac31-55d5-7a67-8c92-90be95c70799 | €15.00 | €0.26 | matched |
| 21 | capture | 01a1ac31-5c45-75f6-bc5a-e6609f21e65e | €49.00 | €0.67 | matched |
| 22 | capture | 01a1ac31-6ef7-79ce-854a-5cb4a30895dc | €15.00 | €0.26 | matched |
| 23 | capture | 01a1ac31-73eb-74cb-8d9c-151a2e21dda9 | €24.00 | €0.37 | matched |
| 24 | capture | 01a1ac31-84e6-7659-a754-e4ada70b1652 | €15.00 | €0.26 | matched |
| 25 | capture | 01a1ac31-a789-7676-8afb-6ca43e8f1936 | €24.00 | €0.37 | matched |
| 26 | capture | 01a1ac31-bbb4-70e0-9b5e-638cadd23305 | €24.00 | €0.37 | matched |
| 27 | refund | 01a1ac31-caf1-7d40-adff-8264ecd16a57 | -€11.00 | €0.00 | matched |
| 29 | refund | 01a1ac31-e11e-7bbe-9dd7-b0628fa40880 | -€20.00 | €0.00 | matched |
| 30 | capture | 01a1ac31-e141-7e98-a251-26c650d134b4 | €24.00 | €0.37 | matched |
| 31 | capture | 01a1ac31-f7b6-7012-8cce-ee015962477b | €24.00 | €0.37 | matched |
| 32 | capture | 01a1ac31-fd7b-7351-a221-91fd216eb911 | €15.00 | €0.26 | matched |
| 33 | capture | 01a1ac32-0a27-7dec-b26a-c7369ec407a9 | €35.00 | €0.50 | matched |
| 34 | capture | 01a1ac32-0c26-7180-994a-b411a44974f7 | €9.00 | €0.19 | matched |
| 35 | capture | 01a1ac32-196a-7abc-bc38-b95e44572dcd | €24.00 | €0.37 | matched |
| 36 | capture | 01a1ac32-2cf9-7925-aa80-cf320e1c2d1e | €9.00 | €0.19 | matched |
| 37 | refund | 01a1ac32-3785-7095-ba56-3b69da229741 | -€6.00 | €0.00 | matched |
| 38 | capture | 01a1ac32-41d8-7088-9964-975e4950b7bd | €49.00 | €0.67 | matched |
| 39 | capture | 01a1ac32-488c-7d35-87d9-f30d98a74515 | €49.00 | €0.67 | matched |
| 41 | capture | 01a1ac32-4fd7-780b-ae1b-85854193c205 | €49.00 | €0.67 | matched |
| 42 | refund | 01a1ac32-568a-7a45-b937-a5039390ff7b | -€7.00 | €0.00 | matched |
| 43 | capture | 01a1ac32-6d93-7eb6-971f-97e0b9c6e150 | €49.00 | €0.67 | matched |
| 44 | capture | 01a1ac32-82b9-76e4-8226-7b35fc7bc20f | €24.00 | €0.37 | matched |
| 45 | capture | 01a1ac32-8dbb-7842-b941-20efbc960207 | €15.00 | €0.26 | matched |
| 46 | refund | 01a1ac32-954e-7535-9b0f-034694816f6c | -€7.00 | €0.00 | matched |
| 47 | capture | 01a1ac32-c756-729a-a579-a0dbbf8da246 | €35.00 | €0.50 | matched |
| 48 | capture | 01a1ac32-db7e-768f-b9c2-e7b5c0525ab0 | €9.00 | €0.19 | matched |
| 49 | capture | 01a1ac32-e29b-7d90-98ab-7752f2f17e6f | €15.00 | €0.26 | matched |
| 50 | capture | 01a1ac32-e81a-7ebc-a41a-ccc431296914 | €24.00 | €0.37 | matched |
| 51 | capture | 01a1ac32-f335-7301-8d27-2efc5607f903 | €35.00 | €0.50 | matched |
| 52 | capture | 01a1ac32-faf4-7be3-ae79-4b87cd2dd75e | €49.00 | €0.67 | matched |
| 53 | capture | 01a1ac33-17e6-7b27-8f1c-40300cf64298 | €15.00 | €0.26 | matched |
| 54 | capture | 01a1ac33-1ba6-7c00-9af2-e5a2d590a1ab | €15.00 | €0.26 | matched |
| 55 | capture | 01a1ac33-3915-7483-8f99-efaa7967ab0d | €15.00 | €0.26 | matched |
| 56 | capture | 01a1ac33-441d-7ef1-a937-9aade094967a | €24.00 | €0.37 | matched |
| 57 | refund | 01a1ac33-4d4b-7d6d-9845-dd2ce41e8b52 | -€9.00 | €0.00 | matched |
| 58 | capture | 01a1ac33-5f6b-78b4-b48d-67aced75347d | €35.00 | €0.50 | matched |
| 59 | capture | 01a1ac33-67c2-7a2a-bc8d-7c8fe3dd13e4 | €15.00 | €0.26 | matched |
| 60 | capture | 01a1ac33-6fb5-73d4-a31f-313e2ceddbd5 | €24.00 | €0.37 | matched |
| 61 | capture | 01a1ac33-85b0-7848-b884-1750a0bd21d8 | €49.00 | €0.67 | matched |
| 62 | capture | 01a1ac33-9bf8-7de0-a4b5-d4268b9ddeed | €9.00 | €0.19 | matched |
| 63 | capture | 01a1ac33-a302-76ae-9fc5-425136030bd7 | €35.00 | €0.50 | matched |
| 64 | refund | 01a1ac33-d2fc-7302-9808-a28a0d4b8d7f | -€32.00 | €0.00 | matched |
| 65 | capture | 01a1ac33-d7e2-74f6-aa18-52b24d8a5e8a | €49.00 | €0.67 | matched |
| 66 | refund | 01a1ac33-df7f-7609-8eff-beb236e42972 | -€7.00 | €0.00 | matched |
| 67 | capture | 01a1ac33-ea60-73b5-afec-b8454292585e | €15.00 | €0.26 | matched |
| 68 | capture | 01a1ac33-f302-7bff-8d58-8bdd2ec5e558 | €9.00 | €0.19 | matched |
| 69 | capture | 01a1ac34-163a-7258-bb38-f56f1af16881 | €49.00 | €0.67 | matched |
| 70 | refund | 01a1ac34-3d9b-7a35-a53b-c1cff262b8c9 | -€8.00 | €0.00 | matched |
| 71 | capture | 01a1ac34-4fd1-7db3-9522-131be7e41edf | €35.00 | €0.50 | matched |
| 72 | capture | 01a1ac34-999e-785e-b011-babdb8914676 | €24.00 | €0.37 | matched |
| 73 | refund | 01a1ac34-ae09-7548-970d-e20fa69b239a | -€13.00 | €0.00 | matched |
| 74 | capture | 01a1ac34-ba09-78c9-a853-eda81346853b | €49.00 | €0.67 | matched |
| 75 | capture | 01a1ac34-c98f-7cc7-98a4-19fcff9cb92c | €49.00 | €0.67 | matched |
| 76 | refund | 01a1ac34-df7d-7627-be53-ce848372b107 | -€10.00 | €0.00 | matched |
| 77 | capture | 01a1ac34-e84f-7dbc-9906-dc60a3d4e102 | €35.00 | €0.50 | matched |
| 78 | capture | 01a1ac34-ecbf-740f-80c9-e6ef1ead6779 | €9.00 | €0.19 | matched |
| 79 | refund | 01a1ac35-2e89-722f-a723-5f15a09fc7d9 | -€22.00 | €0.00 | matched |
| 80 | capture | 01a1ac35-49b3-7df6-892c-318a76e6a001 | €24.00 | €0.37 | matched |
| 81 | capture | 01a1ac35-4ab4-7851-ac80-13daf9d8070c | €49.00 | €0.67 | matched |
| 82 | refund | 01a1ac35-5051-740b-8757-0d38f455f69c | -€22.00 | €0.00 | matched |
| 83 | capture | 01a1ac35-5288-701f-91e3-b914ce78ac66 | €35.00 | €0.50 | matched |
| 84 | capture | 01a1ac35-59eb-7543-8fac-926750b11ed5 | €35.00 | €0.50 | matched |
| 85 | capture | 01a1ac35-62b3-7702-9221-c7799e5cf2c7 | €49.00 | €0.67 | matched |
| 86 | capture | 01a1ac35-7900-759e-84f4-b9110893c0c4 | €49.00 | €0.67 | matched |
| 87 | capture | 01a1ac35-d277-75f0-b32c-452831aed904 | €15.00 | €0.26 | matched |
| 88 | capture | 01a1ac35-dfff-7a71-b094-34a998430f14 | €9.00 | €0.19 | matched |
| 89 | capture | 01a1ac35-e0cb-779e-a3dd-254659da6f98 | €35.00 | €0.50 | matched |
| 90 | capture | 01a1ac36-3130-75d8-9059-fd2b4b5382d9 | €24.00 | €0.37 | matched |
| 91 | capture | 01a1ac36-3293-7591-b89e-90e40c76c90b | €35.00 | €0.50 | matched |
| 92 | capture | 01a1ac36-396b-7dce-b1c6-a52af0c11952 | €15.00 | €0.26 | matched |
| 93 | capture | 01a1ac36-4e5b-7e5f-a10a-a565fa7ae3bd | €24.00 | €0.37 | matched |
| 94 | capture | 01a1ac36-5caa-7c93-a8c8-3f43e876d11c | €35.00 | €0.50 | matched |
| 95 | capture | 01a1ac36-78ef-7318-b161-6c8eb8270da0 | €24.00 | €0.37 | matched |
| 96 | capture | 01a1ac36-80aa-7147-80af-1ac444a2c797 | €35.00 | €0.50 | matched |
| 97 | capture | 01a1ac36-8a0c-77a8-ae58-4aecb35513ce | €15.00 | €0.26 | matched |
| 98 | capture | 01a1ac36-a4aa-7b77-bd8c-488bcedf7e77 | €35.00 | €0.50 | matched |
| 99 | capture | 01a1ac36-ab1f-7e2c-94e4-1fb518ac690d | €9.00 | €0.19 | matched |
| 100 | capture | 01a1ac36-c611-7871-a514-d527924afbeb | €15.00 | €0.26 | matched |
| 101 | capture | 01a1ac36-f202-7335-9602-87c4d4c550b2 | €24.00 | €0.37 | matched |
| 102 | capture | 01a1ac36-f12f-7754-b1e0-338accb5f7e1 | €49.00 | €0.67 | matched |
| 104 | capture | 01a1ac37-3e5f-716f-b37a-063ebcda5511 | €49.00 | €0.67 | matched |
| 105 | capture | 01a1ac37-422e-7e83-97b0-7522dc867b4c | €35.00 | €0.50 | matched |
| 106 | capture | 01a1ac37-434a-7e6a-9933-f5542a959b67 | €49.00 | €0.67 | matched |
| 107 | capture | 01a1ac37-4360-7cf7-b206-71df17a3f4c8 | €9.00 | €0.19 | matched |
| 108 | capture | 01a1ac37-6918-71e4-8436-a94ee727f967 | €49.00 | €0.67 | matched |
| 109 | capture | 01a1ac37-9a40-76b8-b3cd-b7fb1b6f9ca0 | €24.00 | €0.37 | matched |
| 110 | capture | 01a1ac37-a688-7047-add6-ac7be13058ba | €9.00 | €0.19 | matched |
| 111 | capture | 01a1ac37-b145-7deb-8a68-9ed856355650 | €9.00 | €0.19 | matched |
| 112 | capture | 01a1ac37-b6fb-7270-99a0-074386ff8ba8 | €24.00 | €0.37 | matched |
| 113 | capture | 01a1ac37-b934-735c-860c-2e84fbcaf12f | €24.00 | €0.37 | matched |
| 114 | capture | 01a1ac37-bec9-7b88-9347-54dab4fa1f76 | €15.00 | €0.26 | matched |
| 115 | capture | 01a1ac38-010e-77df-afc9-47018b291152 | €15.00 | €0.26 | matched |
| 116 | capture | 01a1ac38-0299-78a6-8ad0-4a35ca8afb74 | €24.00 | €0.37 | matched |
| 117 | capture | 01a1ac38-17ab-7734-98f4-64e80f2fdadc | €9.00 | €0.19 | matched |
| 118 | capture | 01a1ac38-1f91-7766-bc75-2899183d32a9 | €35.00 | €0.50 | matched |
| 119 | capture | 01a1ac38-236a-7738-84f3-fa193f87005d | €15.00 | €0.26 | matched |
| 121 | capture | 01a1ac38-38bb-745a-943d-2edbb37b170c | €9.00 | €0.19 | matched |
| 122 | capture | 01a1ac38-60b2-7d7e-a8ce-86445f17484e | €15.00 | €0.26 | matched |
| 123 | refund | 01a1ac38-7239-777a-bee3-1b7064ddf64a | -€17.00 | €0.00 | matched |
| 124 | capture | 01a1ac38-782a-7a44-aca4-eb0c4f3dbedd | €24.00 | €0.37 | matched |
| 125 | capture | 01a1ac38-7d26-795f-a60f-6102ec09ef02 | €35.00 | €0.50 | matched |
| 126 | capture | 01a1ac38-8558-7de9-b75f-f585e43aa1a9 | €15.00 | €0.26 | matched |
| 127 | capture | 01a1ac38-ae3a-734a-a5c4-f09c65a096f1 | €24.00 | €0.37 | matched |
| 128 | capture | 01a1ac38-b54d-7207-9c9b-84e8fbce803c | €9.00 | €0.19 | matched |
| 129 | capture | 01a1ac38-c03b-72a2-8e41-6d621d31c7b1 | €24.00 | €0.37 | matched |
| 130 | refund | 01a1ac38-eb35-7b76-a1c3-d69d32ee38e1 | -€9.00 | €0.00 | matched |
| 131 | capture | 01a1ac38-eebb-758c-9f10-4d4c9d5fcbe2 | €35.00 | €0.50 | matched |
| 132 | capture | 01a1ac39-1854-7b68-9924-9ddc4cd97c12 | €15.00 | €0.26 | matched |
| 133 | capture | 01a1ac39-19ea-7192-b0c2-91c8c9ab42b3 | €15.00 | €0.26 | matched |
| 134 | capture | 01a1ac39-4f70-7ca8-a468-813bd6bd3475 | €49.00 | €0.67 | matched |