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
- 19 Oct, 10:30114 lines2 breaks
- 19 Oct, 10:20115 lines2 breaks
- 19 Oct, 10:10123 lines1 break
- 19 Oct, 10:00121 lines4 breaks
- 19 Oct, 09:50127 lines2 breaks
- 19 Oct, 09:40124 lines4 breaks
- 19 Oct, 09:30130 lines2 breaks
- 19 Oct, 09:20131 lines3 breaks
- 19 Oct, 09:10118 lines1 break
- 19 Oct, 09:00117 lines8 breaks
- 19 Oct, 08:50126 lines5 breaks
- 19 Oct, 08:40114 lines1 break
- 19 Oct, 08:30107 lines1 break
- 19 Oct, 08:20146 lines4 breaks
19 Oct, 09:00
Gross
€2,678.00
PSP fee
€42.15
Net to the bank
€2,635.85
Settlement journal
#84501
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a15366-ee02-7460-9c0e-0a0e83379aa2 is already settled by stl_EUR_2987334 line 47
- duplicate linethe file lists it twicecapture:01a15368-19e7-7680-801b-85e350d67081 is already settled by stl_EUR_2987334 line 60
- duplicate linethe file lists it twicecapture:01a1536c-4181-77b0-b90c-1644f005197a is already settled by stl_EUR_2987334 line 109
- fee differencethe fee is not the contract feethe fee is 41, the contract says 37
- fee differencethe fee is not the contract feethe fee is 24, the contract says 19
- fee differencethe fee is not the contract feethe fee is 53, the contract says 50
- fee differencethe fee is not the contract feethe fee is 52, the contract says 50
- missing linein the books, not in the filecapture:01a1536b-7a2d-770c-be89-2cd7484cab7d is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 48 | capture | 01a15366-ee56-7f12-8325-eacff7761027 | €9.00 | €0.19 | duplicate line |
| 61 | capture | 01a15368-1a12-7ab2-ad6b-59d336bfdb39 | €15.00 | €0.26 | duplicate line |
| 65 | capture | 01a15368-91b8-73e5-bcbf-de930074ee94 | €24.00 | €0.41 | fee difference |
| 87 | capture | 01a1536a-494b-737f-acb1-bfe58731abbd | €9.00 | €0.24 | fee difference |
| 95 | capture | 01a1536b-3ba8-7f49-a0f0-b28fa2c86139 | €35.00 | €0.53 | fee difference |
| 110 | capture | 01a1536c-5566-7a81-aff9-1a3f4d0a731d | €9.00 | €0.19 | duplicate line |
| 117 | capture | 01a1536c-c57b-725c-b4c4-c96cd4ef3c8d | €35.00 | €0.52 | fee difference |
| 1 | capture | 01a1535e-012e-7a93-9827-29f78051c26f | €15.00 | €0.26 | matched |
| 2 | capture | 01a15363-a9be-73e7-8663-b6107909298e | €35.00 | €0.50 | matched |
| 3 | capture | 01a15363-b288-7f9f-84e9-756d8e2cfd9b | €35.00 | €0.50 | matched |
| 4 | capture | 01a15363-b4b9-74cf-99db-600e3b8f8d43 | €35.00 | €0.50 | matched |
| 5 | capture | 01a15363-d7b9-7878-bf1b-bb36e57d4ae3 | €35.00 | €0.50 | matched |
| 6 | capture | 01a15363-fb11-799c-b088-f9a1c5adff33 | €49.00 | €0.67 | matched |
| 7 | capture | 01a15364-0ed0-71f3-ada4-0d9243d3fd53 | €24.00 | €0.37 | matched |
| 8 | capture | 01a15364-0f53-75c8-b973-75fcbd66d4f0 | €35.00 | €0.50 | matched |
| 9 | capture | 01a15364-11d4-7dcf-af30-33adb75d7891 | €35.00 | €0.50 | matched |
| 10 | capture | 01a15364-1f5a-794e-a4ec-083ef2a80efc | €24.00 | €0.37 | matched |
| 11 | capture | 01a15364-3d18-701e-a6ac-3c282d5d4a9b | €35.00 | €0.50 | matched |
| 12 | refund | 01a15364-42e6-718a-b588-2c0ca80a3a3b | -€8.00 | €0.00 | matched |
| 13 | refund | 01a15364-5ba0-75d5-abfb-8dcd1a61ec65 | -€8.00 | €0.00 | matched |
| 14 | capture | 01a15364-66e0-7f28-a140-2a1ef7390ad7 | €9.00 | €0.19 | matched |
| 15 | capture | 01a15364-6860-7706-9245-c228e3a05621 | €35.00 | €0.50 | matched |
| 16 | capture | 01a15364-75a3-7a09-bd9a-fcf54a746c23 | €24.00 | €0.37 | matched |
| 17 | capture | 01a15364-78a9-768a-a013-7f47d8122e8e | €9.00 | €0.19 | matched |
| 18 | capture | 01a15364-7952-77e9-94cb-ab4e0c8f5f00 | €9.00 | €0.19 | matched |
| 19 | capture | 01a15364-9823-735b-8758-3afc60d86da7 | €9.00 | €0.19 | matched |
| 20 | capture | 01a15364-9a94-7869-8e32-c1fd316decea | €9.00 | €0.19 | matched |
| 21 | capture | 01a15364-9bac-7cee-83be-1f12b880c04c | €49.00 | €0.67 | matched |
| 22 | capture | 01a15364-cf4c-7104-af39-5b7ab206cb94 | €9.00 | €0.19 | matched |
| 23 | capture | 01a15364-f8c3-7314-ad31-7682e80e5025 | €35.00 | €0.50 | matched |
| 24 | capture | 01a15365-049e-70e0-bbad-7d0f73ece84b | €49.00 | €0.67 | matched |
| 25 | capture | 01a15365-1219-7abd-b244-1d6185e0411a | €35.00 | €0.50 | matched |
| 26 | capture | 01a15365-1981-7429-8d0c-f5a4f8a14203 | €49.00 | €0.67 | matched |
| 27 | capture | 01a15365-44ce-7c51-9ac8-60c33b68cab5 | €35.00 | €0.50 | matched |
| 28 | capture | 01a15365-61cf-7512-a517-0f5b848bfcce | €49.00 | €0.67 | matched |
| 29 | capture | 01a15365-78f0-790f-ba0e-52af494cd55e | €24.00 | €0.37 | matched |
| 30 | capture | 01a15365-8ea0-7e02-a86d-864fd7ebf3a7 | €49.00 | €0.67 | matched |
| 31 | capture | 01a15365-b6e3-7d81-816a-7d3035cda34d | €9.00 | €0.19 | matched |
| 32 | capture | 01a15365-e90a-71ff-80c1-2b8741d73571 | €15.00 | €0.26 | matched |
| 33 | capture | 01a15365-f4a4-7e43-91f2-d22951193ba8 | €9.00 | €0.19 | matched |
| 34 | capture | 01a15366-0774-7c9c-b806-704d359a3d3e | €35.00 | €0.50 | matched |
| 35 | capture | 01a15366-0ac9-7a3e-87f2-6aa94ec312f9 | €9.00 | €0.19 | matched |
| 36 | capture | 01a15366-1107-7e77-b221-4d9be3b28ba7 | €24.00 | €0.37 | matched |
| 37 | capture | 01a15366-2ed7-7318-ac67-5cc9fecd3cf7 | €24.00 | €0.37 | matched |
| 38 | capture | 01a15366-3c77-768c-b3cb-338ecb18741c | €15.00 | €0.26 | matched |
| 39 | capture | 01a15366-52e4-7366-9251-8e4292e3e347 | €35.00 | €0.50 | matched |
| 40 | capture | 01a15366-5b87-7e7a-9dde-a40e367d260b | €9.00 | €0.19 | matched |
| 41 | capture | 01a15366-6307-7de0-996f-48cb39805a3e | €24.00 | €0.37 | matched |
| 42 | capture | 01a15366-8dbe-721b-a8f6-add2b322cae6 | €24.00 | €0.37 | matched |
| 43 | capture | 01a15366-920f-7363-940f-742f7ad9dc69 | €35.00 | €0.50 | matched |
| 44 | capture | 01a15366-a883-7a9f-9b6c-67f45e3159b8 | €35.00 | €0.50 | matched |
| 45 | capture | 01a15366-cfde-783e-a1da-8295e345c952 | €9.00 | €0.19 | matched |
| 46 | capture | 01a15366-d6f4-7fde-8910-d4dac898f7d5 | €24.00 | €0.37 | matched |
| 47 | capture | 01a15366-ee56-7f12-8325-eacff7761027 | €9.00 | €0.19 | matched |
| 49 | capture | 01a15367-2bd0-71ab-a661-92ba83374a10 | €15.00 | €0.26 | matched |
| 50 | capture | 01a15367-31a1-7009-8356-b3d76bfc4197 | €15.00 | €0.26 | matched |
| 51 | capture | 01a15367-3853-7662-be25-dffe0b95cc3b | €9.00 | €0.19 | matched |
| 52 | capture | 01a15367-6a01-78c5-9490-b9cddcdbc601 | €15.00 | €0.26 | matched |
| 53 | capture | 01a15367-7666-7545-afb5-4f381be648f8 | €35.00 | €0.50 | matched |
| 54 | capture | 01a15367-98f1-7e74-9549-eb1858acc2f8 | €35.00 | €0.50 | matched |
| 55 | capture | 01a15367-b70a-7583-966c-5098235d17eb | €24.00 | €0.37 | matched |
| 56 | capture | 01a15367-c4bf-74cf-b153-5b351c0302f3 | €24.00 | €0.37 | matched |
| 57 | capture | 01a15367-de46-71d3-933a-1103c67f598e | €15.00 | €0.26 | matched |
| 58 | capture | 01a15367-eb26-7a6b-84c5-4a8eb762d4f0 | €9.00 | €0.19 | matched |
| 59 | capture | 01a15368-0742-72a1-a008-c2c6d8231866 | €15.00 | €0.26 | matched |
| 60 | capture | 01a15368-1a12-7ab2-ad6b-59d336bfdb39 | €15.00 | €0.26 | matched |
| 62 | capture | 01a15368-1a6f-7e56-8357-858dd2cf6ee3 | €15.00 | €0.26 | matched |
| 63 | refund | 01a15368-23e8-72df-93bb-20eb08ec21cd | -€9.00 | €0.00 | matched |
| 64 | capture | 01a15368-811e-782e-b6ff-b7de28a55fdd | €9.00 | €0.19 | matched |
| 66 | capture | 01a15368-9231-7ebf-a75e-2501027a0509 | €15.00 | €0.26 | matched |
| 67 | capture | 01a15368-9711-7d32-83c8-b148d5e9051b | €9.00 | €0.19 | matched |
| 68 | capture | 01a15368-9ae4-79cf-ad22-e78e2255c40a | €35.00 | €0.50 | matched |
| 69 | capture | 01a15368-9c8f-78d8-a957-01a328386202 | €15.00 | €0.26 | matched |
| 70 | capture | 01a15368-ac86-709d-97f5-c71e594969e3 | €24.00 | €0.37 | matched |
| 71 | capture | 01a15368-e0c7-7a52-bb29-889825423ccc | €9.00 | €0.19 | matched |
| 72 | capture | 01a15369-42ab-7575-a987-824c63561463 | €49.00 | €0.67 | matched |
| 73 | capture | 01a15369-5d11-7982-945e-375801e51b47 | €9.00 | €0.19 | matched |
| 74 | capture | 01a15369-6555-75cc-b413-333bcddb8872 | €24.00 | €0.37 | matched |
| 75 | capture | 01a15369-8efa-7ea4-9a82-dc5be2422e22 | €35.00 | €0.50 | matched |
| 76 | capture | 01a15369-925b-7fb7-8151-191f6e9e6f20 | €35.00 | €0.50 | matched |
| 77 | capture | 01a15369-93a9-7c46-b1ca-e8be7f922748 | €24.00 | €0.37 | matched |
| 78 | capture | 01a15369-afab-7a84-a613-15732190a739 | €24.00 | €0.37 | matched |
| 79 | capture | 01a15369-b69d-7a24-926d-2333ede73179 | €24.00 | €0.37 | matched |
| 80 | capture | 01a15369-ff84-77b3-adcb-10b14af6a93e | €49.00 | €0.67 | matched |
| 81 | capture | 01a1536a-09e1-79be-84d7-88b692e42a1d | €24.00 | €0.37 | matched |
| 82 | capture | 01a1536a-1630-7df7-bec1-7ee99633e924 | €15.00 | €0.26 | matched |
| 83 | capture | 01a1536a-1df3-7476-bb1e-31d212fbaed8 | €9.00 | €0.19 | matched |
| 84 | capture | 01a1536a-2197-7fba-962e-f70ded15eef8 | €24.00 | €0.37 | matched |
| 85 | capture | 01a1536a-23ef-7928-90ae-8819a9c8c715 | €49.00 | €0.67 | matched |
| 86 | capture | 01a1536a-2c3a-7403-8cb2-ea0922ba74c8 | €49.00 | €0.67 | matched |
| 88 | capture | 01a1536a-4c6e-700a-9613-19d17919a392 | €24.00 | €0.37 | matched |
| 89 | capture | 01a1536a-60b7-7a94-8e48-fea7e5d85138 | €15.00 | €0.26 | matched |
| 90 | capture | 01a1536a-754d-7f18-9e7d-fae893f233f6 | €24.00 | €0.37 | matched |
| 91 | capture | 01a1536a-8ed5-7f8e-9ccb-ea46b33987db | €49.00 | €0.67 | matched |
| 92 | refund | 01a1536a-95aa-7cf6-94e7-745af19fe807 | -€30.00 | €0.00 | matched |
| 93 | capture | 01a1536a-9c63-7e8c-8f88-71893bbf939c | €24.00 | €0.37 | matched |
| 94 | capture | 01a1536a-ee03-77dc-8645-94cf7311c33e | €35.00 | €0.50 | matched |
| 96 | capture | 01a1536b-71f3-72f0-abc5-2bbbef0a8930 | €24.00 | €0.37 | matched |
| 97 | capture | 01a1536b-98db-788a-b417-551c454266dd | €35.00 | €0.50 | matched |
| 98 | capture | 01a1536b-b12d-7d3e-99c2-b1d97b26378b | €15.00 | €0.26 | matched |
| 99 | capture | 01a1536b-b806-7393-94f5-7c1bf9202024 | €9.00 | €0.19 | matched |
| 100 | capture | 01a1536b-bc30-7d2e-8605-04282c206146 | €49.00 | €0.67 | matched |
| 101 | capture | 01a1536b-e0f6-7564-9308-9e9ce6288f9a | €15.00 | €0.26 | matched |
| 102 | capture | 01a1536b-e86f-74a1-b952-80acfff03170 | €15.00 | €0.26 | matched |
| 103 | capture | 01a1536b-ff42-7d1c-9798-53d2257651e3 | €15.00 | €0.26 | matched |
| 104 | capture | 01a1536c-0302-739e-8588-d3e18fdb18a6 | €24.00 | €0.37 | matched |
| 105 | capture | 01a1536c-0405-73ce-8473-481eb9e01ab0 | €9.00 | €0.19 | matched |
| 106 | capture | 01a1536c-2b24-7f99-a65e-271cb7345900 | €49.00 | €0.67 | matched |
| 107 | capture | 01a1536c-2dcd-7486-9c36-6e82750e3ade | €24.00 | €0.37 | matched |
| 108 | capture | 01a1536c-4086-70bc-b077-f00392b86010 | €24.00 | €0.37 | matched |
| 109 | capture | 01a1536c-5566-7a81-aff9-1a3f4d0a731d | €9.00 | €0.19 | matched |
| 111 | capture | 01a1536c-520f-75a8-abce-5c5f1a6c58f1 | €35.00 | €0.50 | matched |
| 112 | capture | 01a1536c-63e0-7f18-9e40-d478c18c75c8 | €9.00 | €0.19 | matched |
| 113 | capture | 01a1536c-83f0-7c91-bad6-3c7b1690598e | €15.00 | €0.26 | matched |
| 114 | capture | 01a1536c-8900-7912-867a-30d4c9b79703 | €49.00 | €0.67 | matched |
| 115 | capture | 01a1536c-a776-7e9a-ae44-12442ff52825 | €24.00 | €0.37 | matched |
| 116 | refund | 01a1536c-b2de-77ca-9b8c-5ec3c7d6a290 | -€10.00 | €0.00 | matched |