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, 16:50114 lines3 breaks
- 20 Oct, 16:40117 lines5 breaks
- 20 Oct, 16:30105 lines1 break
- 20 Oct, 16:20136 lines7 breaks
- 20 Oct, 16:10112 lines3 breaks
- 20 Oct, 16:00132 lines4 breaks
- 20 Oct, 15:50125 lines1 break
- 20 Oct, 15:40109 linesclean
- 20 Oct, 15:3094 lines5 breaks
- 20 Oct, 15:20121 lines1 break
- 20 Oct, 15:10131 lines1 break
- 20 Oct, 15:00129 lines3 breaks
- 20 Oct, 14:50121 lines4 breaks
- 20 Oct, 14:40117 lines2 breaks
20 Oct, 15:30
Gross
€2,299.00
PSP fee
€36.10
Net to the bank
€2,262.90
Settlement journal
#107610
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a159ef-1ebc-788f-acba-3cb175fa92a5 is already settled by stl_EUR_2987517 line 8
- duplicate linethe file lists it twicecapture:01a159f5-2b78-7d68-ae46-6cdc1983bcd8 is already settled by stl_EUR_2987517 line 59
- duplicate linethe file lists it twicecapture:01a159f8-2c97-7b6f-affa-85f6743febf1 is already settled by stl_EUR_2987517 line 93
- missing linein the books, not in the filecapture:01a159f4-adb2-710e-be90-c7a1fbc36208 is in no file
- missing linein the books, not in the filecapture:01a159f5-34a1-73e9-bfc0-6e7c46383cbe is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 9 | capture | 01a159ef-3971-7177-8703-9bce93b35b1c | €9.00 | €0.19 | duplicate line |
| 60 | capture | 01a159f5-2be8-718c-81c5-60009c5480ae | €49.00 | €0.67 | duplicate line |
| 94 | capture | 01a159f8-2cea-75df-a241-26562c3debe1 | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a159e9-872b-7078-a46f-34a861757985 | €35.00 | €0.50 | matched |
| 2 | capture | 01a159ef-1460-7b97-89cb-eebd9a261096 | €35.00 | €0.50 | matched |
| 3 | capture | 01a159ef-2356-7595-823f-d1445d09a751 | €35.00 | €0.50 | matched |
| 4 | capture | 01a159ef-231a-713a-9536-917e7ae5bbf0 | €49.00 | €0.67 | matched |
| 5 | capture | 01a159ef-1386-7918-b9d6-24a9ff542743 | €15.00 | €0.26 | matched |
| 6 | capture | 01a159ef-3447-7465-bb0e-7ae71836fe73 | €24.00 | €0.37 | matched |
| 7 | capture | 01a159ef-3765-7d6c-abf8-450de264cb3f | €15.00 | €0.26 | matched |
| 8 | capture | 01a159ef-3971-7177-8703-9bce93b35b1c | €9.00 | €0.19 | matched |
| 10 | capture | 01a159ef-69b2-72ea-b8e9-c02f0501169a | €35.00 | €0.50 | matched |
| 11 | capture | 01a159ef-8bb8-7662-a188-e531da0f114a | €9.00 | €0.19 | matched |
| 12 | capture | 01a159ef-b50c-7dc9-8cb0-dbbd3b80d75d | €35.00 | €0.50 | matched |
| 13 | capture | 01a159ef-b8d6-765d-8011-7d12a0bee7e5 | €9.00 | €0.19 | matched |
| 14 | capture | 01a159ef-e409-7c69-8136-a3bd66fba63c | €49.00 | €0.67 | matched |
| 15 | capture | 01a159ef-fc40-77a5-82b1-6abc928e9185 | €24.00 | €0.37 | matched |
| 16 | capture | 01a159f0-096c-7d69-afc1-705bc9bcb325 | €24.00 | €0.37 | matched |
| 17 | capture | 01a159f0-1b4e-7c44-ba17-784b5c08ecca | €35.00 | €0.50 | matched |
| 18 | capture | 01a159f0-4d52-7fa6-ba43-eb403c51d965 | €49.00 | €0.67 | matched |
| 19 | refund | 01a159f0-552d-7818-baec-759461df7b8a | -€21.00 | €0.00 | matched |
| 20 | capture | 01a159f0-60c3-737a-8d83-344f313b9df9 | €35.00 | €0.50 | matched |
| 21 | capture | 01a159f0-69bd-7c57-bedb-9717d3ca7d8b | €35.00 | €0.50 | matched |
| 22 | capture | 01a159f0-7765-7183-9a08-48626aaa369d | €24.00 | €0.37 | matched |
| 23 | capture | 01a159f0-ca08-7e5b-9de9-a8d3e64d74f6 | €9.00 | €0.19 | matched |
| 24 | capture | 01a159f0-ce9f-775f-9d84-ddc731427c43 | €49.00 | €0.67 | matched |
| 25 | capture | 01a159f0-ec42-7023-9c90-f0fd4fea1909 | €24.00 | €0.37 | matched |
| 26 | capture | 01a159f1-02cb-7263-808b-f56d479e6eab | €35.00 | €0.50 | matched |
| 27 | capture | 01a159f1-0b1e-792d-a9d7-69448a9d7cfe | €9.00 | €0.19 | matched |
| 28 | capture | 01a159f1-1e97-7443-8101-d2e219f91e9b | €24.00 | €0.37 | matched |
| 29 | capture | 01a159f1-950b-7494-92b0-b1f3cc2eddef | €9.00 | €0.19 | matched |
| 30 | capture | 01a159f1-c43a-7635-842e-181b2f56e7d7 | €24.00 | €0.37 | matched |
| 31 | capture | 01a159f1-c76c-7a0a-b78f-1094ef38ff14 | €49.00 | €0.67 | matched |
| 32 | capture | 01a159f2-055f-7bce-9bc2-88f6d79413ca | €35.00 | €0.50 | matched |
| 33 | capture | 01a159f2-20aa-76dc-b7f3-7d35d4f43d1c | €35.00 | €0.50 | matched |
| 34 | capture | 01a159f2-5825-7cb2-9629-b15e03939406 | €15.00 | €0.26 | matched |
| 35 | refund | 01a159f2-5fb9-7f63-95b4-957ad5049cd4 | -€8.00 | €0.00 | matched |
| 36 | capture | 01a159f2-70c4-79d5-a703-64b43cdc1b90 | €24.00 | €0.37 | matched |
| 37 | capture | 01a159f2-8667-724e-a925-0cb006b74bc5 | €15.00 | €0.26 | matched |
| 38 | capture | 01a159f2-c610-716a-9dab-b3e57b092eee | €15.00 | €0.26 | matched |
| 39 | capture | 01a159f3-6765-71eb-96ab-2685475327ba | €24.00 | €0.37 | matched |
| 40 | capture | 01a159f3-7447-7973-baad-e825412c97ed | €35.00 | €0.50 | matched |
| 41 | capture | 01a159f3-8c9f-70b6-a3c6-e1d7d542ca2e | €49.00 | €0.67 | matched |
| 42 | capture | 01a159f3-a009-777d-942c-de2f3bc23c06 | €49.00 | €0.67 | matched |
| 43 | capture | 01a159f3-ad1d-7716-8c8c-62ac0ba5ef96 | €49.00 | €0.67 | matched |
| 44 | capture | 01a159f3-d938-7098-966a-2b16f0838d29 | €35.00 | €0.50 | matched |
| 45 | capture | 01a159f3-ec05-7638-9e3b-060d774db961 | €15.00 | €0.26 | matched |
| 46 | refund | 01a159f4-2fc4-7a71-999a-5f110320f777 | -€11.00 | €0.00 | matched |
| 47 | capture | 01a159f4-3fc5-7bd1-90c7-e6238ff2817a | €35.00 | €0.50 | matched |
| 48 | capture | 01a159f4-6a01-7f2f-8b38-b900e6ef8bd3 | €49.00 | €0.67 | matched |
| 49 | capture | 01a159f4-81c5-79e6-8610-46dab5a57493 | €24.00 | €0.37 | matched |
| 50 | capture | 01a159f4-9f77-719d-abf1-b6e696ad05ce | €9.00 | €0.19 | matched |
| 51 | capture | 01a159f4-9bea-7140-9161-3ffc0b41d3ee | €49.00 | €0.67 | matched |
| 52 | capture | 01a159f4-a3cd-736a-8f4a-68b17e25f619 | €15.00 | €0.26 | matched |
| 53 | capture | 01a159f4-a41f-7f30-bc64-3ca3c0800ff3 | €9.00 | €0.19 | matched |
| 54 | capture | 01a159f4-cd1d-726e-926e-1fbd74c11710 | €49.00 | €0.67 | matched |
| 55 | capture | 01a159f4-d0f4-7146-9c92-be1e1db3b292 | €24.00 | €0.37 | matched |
| 56 | refund | 01a159f4-dcdc-721a-b94b-ed336677ff9f | -€5.00 | €0.00 | matched |
| 57 | capture | 01a159f4-e6ea-7f0b-851f-7e0491e6ca78 | €49.00 | €0.67 | matched |
| 58 | capture | 01a159f4-fa14-71dd-ae81-2684d36b9049 | €15.00 | €0.26 | matched |
| 59 | capture | 01a159f5-2be8-718c-81c5-60009c5480ae | €49.00 | €0.67 | matched |
| 61 | capture | 01a159f5-2f0d-7f9f-ba01-f297ac583a10 | €35.00 | €0.50 | matched |
| 62 | capture | 01a159f5-3b56-74bd-bd49-3e8372ddeb1b | €35.00 | €0.50 | matched |
| 63 | capture | 01a159f5-3ee8-7a6e-a8a7-0ac598f62ed0 | €9.00 | €0.19 | matched |
| 64 | capture | 01a159f5-4b99-7131-8022-00960eb17fe9 | €35.00 | €0.50 | matched |
| 65 | capture | 01a159f5-529a-7935-bb2a-da27538085b7 | €24.00 | €0.37 | matched |
| 66 | capture | 01a159f5-6f0a-7fa9-94a9-bf23b87eb123 | €35.00 | €0.50 | matched |
| 67 | refund | 01a159f5-7606-7d13-bb54-1412d22677e5 | -€22.00 | €0.00 | matched |
| 68 | capture | 01a159f5-82d7-7217-b41a-d92ab4e62082 | €15.00 | €0.26 | matched |
| 69 | capture | 01a159f5-c1c2-79d9-a4d9-135bdffe90f3 | €49.00 | €0.67 | matched |
| 70 | capture | 01a159f6-0a3f-761c-8a3e-90fcd7f04289 | €49.00 | €0.67 | matched |
| 71 | capture | 01a159f6-6a37-7caf-b86b-2fb89c304b94 | €9.00 | €0.19 | matched |
| 72 | capture | 01a159f6-6d61-7efd-aa08-b640904dd9f0 | €9.00 | €0.19 | matched |
| 73 | capture | 01a159f6-895b-75c1-818f-49b8caa54f58 | €9.00 | €0.19 | matched |
| 74 | capture | 01a159f6-ab01-7c4d-8554-65e67bbb0235 | €15.00 | €0.26 | matched |
| 75 | capture | 01a159f6-b463-760c-bd41-39c6d23ceda1 | €15.00 | €0.26 | matched |
| 76 | capture | 01a159f6-d26a-76f7-97d7-078fbf037c50 | €15.00 | €0.26 | matched |
| 77 | capture | 01a159f6-f6af-7499-8915-f781112127c6 | €15.00 | €0.26 | matched |
| 78 | capture | 01a159f7-040f-7649-8e45-77c36b485ccb | €9.00 | €0.19 | matched |
| 79 | refund | 01a159f7-34b2-7d7a-829d-dee2539569c4 | -€12.00 | €0.00 | matched |
| 80 | capture | 01a159f7-378c-7ccd-b75f-a0025e03ffe3 | €35.00 | €0.50 | matched |
| 81 | refund | 01a159f7-52dd-7c53-9aac-e8a204bd598f | -€7.00 | €0.00 | matched |
| 82 | capture | 01a159f7-a221-7041-ace7-16a4cbac6a95 | €35.00 | €0.50 | matched |
| 83 | capture | 01a159f7-ab91-72c3-a427-1a7295cfc470 | €49.00 | €0.67 | matched |
| 84 | capture | 01a159f7-d909-7454-8799-79e53b30e74e | €24.00 | €0.37 | matched |
| 85 | refund | 01a159f7-e5bb-7f6e-b492-76dbb6b4f1c1 | -€42.00 | €0.00 | matched |
| 86 | capture | 01a159f7-e94f-7fe4-b8c5-af01dd8674b5 | €24.00 | €0.37 | matched |
| 87 | capture | 01a159f7-ff94-7903-b3a7-4f76447ff878 | €9.00 | €0.19 | matched |
| 88 | capture | 01a159f8-112e-7e01-8a05-80f374642bfe | €24.00 | €0.37 | matched |
| 89 | capture | 01a159f8-12ff-7e8f-8096-b118a1181adc | €15.00 | €0.26 | matched |
| 90 | capture | 01a159f8-2154-760b-b57a-ef2cdeca1d91 | €35.00 | €0.50 | matched |
| 91 | capture | 01a159f8-29c5-7bc7-9c60-1a58414631eb | €35.00 | €0.50 | matched |
| 92 | capture | 01a159f8-2b50-7810-817c-07d635a5a9d9 | €49.00 | €0.67 | matched |
| 93 | capture | 01a159f8-2cea-75df-a241-26562c3debe1 | €35.00 | €0.50 | matched |