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
- 15 Oct, 19:00111 lines3 breaks
- 15 Oct, 18:50121 lines2 breaks
- 15 Oct, 18:40127 lines3 breaks
- 15 Oct, 18:30122 linesclean
- 15 Oct, 18:20115 lines4 breaks
- 15 Oct, 18:10146 lines3 breaks
- 15 Oct, 18:00131 lines3 breaks
- 15 Oct, 17:50126 lines4 breaks
- 15 Oct, 17:40115 lines6 breaks
- 15 Oct, 17:30104 linesclean
- 15 Oct, 17:20139 lines5 breaks
- 15 Oct, 17:10107 linesclean
- 15 Oct, 17:00109 lines1 break
- 15 Oct, 16:50152 lines1 break
15 Oct, 17:40
Gross
€2,321.00
PSP fee
€39.00
Net to the bank
€2,282.00
Settlement journal
#18633
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a140a6-5af2-76ca-9586-3595fca3ed3b is already settled by stl_EUR_2986810 line 3
- fee differencethe fee is not the contract feethe fee is 51, the contract says 50
- missing linein the books, not in the filecapture:01a140a9-4c5a-73f1-83ed-5905a5be0758 is in no file
- missing linein the books, not in the filecapture:01a140ab-c8fb-733b-94d5-0b3ef97020e0 is in no file
- missing linein the books, not in the filerefund:01a140ac-f6fa-77a1-96bc-8c8a2b85cb8f is in no file
- missing linein the books, not in the filecapture:01a140ac-5ee8-7fb1-9e4b-c15184b65793 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 4 | refund | 01a140a6-5b07-76d7-9ec5-e27315a9b853 | -€35.00 | €0.00 | duplicate line |
| 91 | capture | 01a140ad-a25f-7645-9410-8a0558f445ea | €35.00 | €0.51 | fee difference |
| 1 | capture | 01a140a0-45b4-7049-9429-f73c54714909 | €24.00 | €0.37 | matched |
| 2 | capture | 01a140a3-688d-78d2-87f3-d77b3f40ac35 | €9.00 | €0.19 | matched |
| 3 | refund | 01a140a6-5b07-76d7-9ec5-e27315a9b853 | -€35.00 | €0.00 | matched |
| 5 | capture | 01a140a6-5b4c-788c-8e2d-c4fc17835b8d | €24.00 | €0.37 | matched |
| 6 | capture | 01a140a6-8902-787e-a404-cdb7869caa02 | €15.00 | €0.26 | matched |
| 7 | capture | 01a140a6-8b97-7caf-b3d9-9a862d0c06d7 | €49.00 | €0.67 | matched |
| 8 | capture | 01a140a6-8f6e-7f5b-9dc1-a5d5909cfc9d | €49.00 | €0.67 | matched |
| 9 | capture | 01a140a6-b285-7820-aeb1-55f092ee0afa | €24.00 | €0.37 | matched |
| 10 | capture | 01a140a6-bda8-751f-933d-b3f6daad2a46 | €24.00 | €0.37 | matched |
| 11 | capture | 01a140a6-be7a-76da-9151-2138799adb68 | €15.00 | €0.26 | matched |
| 12 | capture | 01a140a6-e30d-7c03-b4d4-c99fe35ab023 | €9.00 | €0.19 | matched |
| 13 | capture | 01a140a6-f3bc-7c5c-b9ec-061facd6b805 | €24.00 | €0.37 | matched |
| 14 | capture | 01a140a6-fd97-70e9-8203-2a129a3c0501 | €35.00 | €0.50 | matched |
| 15 | capture | 01a140a7-04ca-766b-9fc3-73c0573bcbaa | €24.00 | €0.37 | matched |
| 16 | capture | 01a140a7-1acd-7670-915a-ee9d99d5b857 | €24.00 | €0.37 | matched |
| 17 | capture | 01a140a7-28a3-7662-be42-c304a20443d2 | €24.00 | €0.37 | matched |
| 18 | capture | 01a140a7-4199-7eb6-959a-5495300a246d | €24.00 | €0.37 | matched |
| 19 | capture | 01a140a7-51ed-74c5-b14e-ca6f34987537 | €35.00 | €0.50 | matched |
| 20 | capture | 01a140a7-5d68-7cb4-82af-fb7326421c06 | €15.00 | €0.26 | matched |
| 21 | capture | 01a140a7-8ea5-7e03-aadc-482a3824aa8a | €24.00 | €0.37 | matched |
| 22 | capture | 01a140a7-a97f-71f9-934a-81e45ec38243 | €24.00 | €0.37 | matched |
| 23 | capture | 01a140a7-d8c3-78cc-be64-3a367d376a8e | €9.00 | €0.19 | matched |
| 24 | capture | 01a140a7-f1b6-7817-8b14-27df8b792c9e | €24.00 | €0.37 | matched |
| 25 | capture | 01a140a8-0319-7f01-ac5c-7e8e7e09ec78 | €24.00 | €0.37 | matched |
| 26 | capture | 01a140a8-501a-7e32-95e3-738a3238de47 | €24.00 | €0.37 | matched |
| 27 | capture | 01a140a8-565b-7db5-a18f-e166021c5c9c | €49.00 | €0.67 | matched |
| 28 | refund | 01a140a8-5cac-7714-8d8c-85cc07a687b6 | -€19.00 | €0.00 | matched |
| 29 | capture | 01a140a8-61fd-71c3-aec1-e001352bef4a | €9.00 | €0.19 | matched |
| 30 | capture | 01a140a8-8feb-7434-9292-b0d24ce04749 | €9.00 | €0.19 | matched |
| 31 | capture | 01a140a8-95b6-7e7e-824a-0060288813be | €24.00 | €0.37 | matched |
| 32 | capture | 01a140a8-9d5e-7288-9cfe-8aded827e3c5 | €35.00 | €0.50 | matched |
| 33 | capture | 01a140a8-aa96-7afc-ae1e-5e75b0ec01c2 | €49.00 | €0.67 | matched |
| 34 | capture | 01a140a8-c1ea-797c-a8f6-dfe167d2c545 | €24.00 | €0.37 | matched |
| 35 | capture | 01a140a8-ca4f-7688-8f19-238965697310 | €24.00 | €0.37 | matched |
| 36 | capture | 01a140a8-d9ca-7cff-94c5-9fe821835bc0 | €9.00 | €0.19 | matched |
| 37 | capture | 01a140a8-e15f-7567-be86-4295e968b4d3 | €15.00 | €0.26 | matched |
| 38 | refund | 01a140a9-1f93-745f-a378-14eb32fe7bee | -€6.00 | €0.00 | matched |
| 39 | capture | 01a140a9-1eef-77e5-b8a2-a1cd73da842a | €24.00 | €0.37 | matched |
| 40 | capture | 01a140a9-2f0f-79c2-95ce-cdb250df36f9 | €49.00 | €0.67 | matched |
| 41 | capture | 01a140a9-3acc-765e-b4df-3e0fe2571e58 | €24.00 | €0.37 | matched |
| 42 | capture | 01a140a9-3e05-7217-96ee-c0a353dd8977 | €24.00 | €0.37 | matched |
| 43 | capture | 01a140a9-6cc7-735a-9d65-2c42ecfd8e17 | €24.00 | €0.37 | matched |
| 44 | capture | 01a140a9-7223-73ef-8b1a-3ce073697934 | €24.00 | €0.37 | matched |
| 45 | refund | 01a140a9-8b13-7286-bd81-4343cc5cbbd5 | -€19.00 | €0.00 | matched |
| 46 | capture | 01a140a9-9e0b-7683-81cc-213ddd364411 | €15.00 | €0.26 | matched |
| 47 | capture | 01a140a9-ac32-74f4-9163-a53e07ef32d2 | €24.00 | €0.37 | matched |
| 48 | capture | 01a140a9-c4e9-7952-8c71-0b7636205023 | €15.00 | €0.26 | matched |
| 49 | capture | 01a140a9-cfcb-75b7-83b3-0afb32a63d1a | €35.00 | €0.50 | matched |
| 50 | capture | 01a140a9-f9ee-7c3d-968d-dc7e2b835c2a | €35.00 | €0.50 | matched |
| 51 | capture | 01a140a9-fe4f-7588-8aa1-b7368c4dad0b | €24.00 | €0.37 | matched |
| 52 | capture | 01a140aa-014c-7366-9648-95d82b6e9620 | €9.00 | €0.19 | matched |
| 53 | capture | 01a140aa-11f5-7498-a6c9-058ae107db26 | €24.00 | €0.37 | matched |
| 54 | capture | 01a140aa-1d3c-7574-b632-13c497fc6977 | €9.00 | €0.19 | matched |
| 55 | capture | 01a140aa-2902-7488-9fa8-9ebc57b08217 | €49.00 | €0.67 | matched |
| 56 | refund | 01a140aa-39f2-70f0-8e50-b6489cee2d81 | -€25.00 | €0.00 | matched |
| 57 | capture | 01a140aa-5522-7e2b-a4ab-d72b3b7a00b4 | €9.00 | €0.19 | matched |
| 58 | capture | 01a140aa-769b-796e-b42a-4cfa1507cbdc | €9.00 | €0.19 | matched |
| 59 | capture | 01a140aa-d54e-7b71-9120-8e9926d7d9d5 | €35.00 | €0.50 | matched |
| 60 | capture | 01a140ab-039d-791e-98cb-b9bdd862142f | €9.00 | €0.19 | matched |
| 61 | capture | 01a140ab-501e-7ad3-bb53-e7b41adc562d | €24.00 | €0.37 | matched |
| 62 | capture | 01a140ab-774e-76e1-9989-1ffbebebe7a0 | €15.00 | €0.26 | matched |
| 63 | capture | 01a140ab-82e6-761a-9c8c-0a65dde8014c | €9.00 | €0.19 | matched |
| 64 | capture | 01a140ab-9d7f-7d08-8806-43d3df8fab6c | €15.00 | €0.26 | matched |
| 65 | capture | 01a140ab-b6f9-767a-9459-cac3f0ea0a7f | €15.00 | €0.26 | matched |
| 66 | capture | 01a140ab-d739-7afa-89ee-dc61bbaf5380 | €49.00 | €0.67 | matched |
| 67 | capture | 01a140ac-0534-7147-a9cd-5cc6ddeaeebb | €9.00 | €0.19 | matched |
| 68 | capture | 01a140ac-0a49-7564-a1be-757d12a6ef5b | €24.00 | €0.37 | matched |
| 69 | capture | 01a140ac-2302-70ca-a3b3-08c128c3085d | €24.00 | €0.37 | matched |
| 70 | capture | 01a140ac-2350-7040-945d-a08a06fb5c78 | €9.00 | €0.19 | matched |
| 71 | capture | 01a140ac-2c59-791c-b259-81292d56a6a4 | €9.00 | €0.19 | matched |
| 72 | capture | 01a140ac-4162-781a-bb9f-579252c6a0da | €35.00 | €0.50 | matched |
| 73 | refund | 01a140ac-54ae-79b0-a33d-ec0270af2c66 | -€19.00 | €0.00 | matched |
| 74 | capture | 01a140ac-65a9-7cc4-9ca6-e12104b13d59 | €9.00 | €0.19 | matched |
| 75 | capture | 01a140ac-85d6-7401-9d6b-106fafb69d47 | €24.00 | €0.37 | matched |
| 76 | capture | 01a140ac-89de-7e6b-b2b4-d3695a11bbaa | €24.00 | €0.37 | matched |
| 77 | capture | 01a140ac-94b1-7301-a167-b15914118154 | €15.00 | €0.26 | matched |
| 78 | capture | 01a140ac-9dfc-700b-aac7-eb2a4c0069d5 | €15.00 | €0.26 | matched |
| 79 | capture | 01a140ac-9f61-705a-a3e7-be35529e32d7 | €24.00 | €0.37 | matched |
| 80 | capture | 01a140ac-bc64-7866-8958-55bdc2d3ac64 | €15.00 | €0.26 | matched |
| 81 | capture | 01a140ac-c8a2-77b0-9077-56fc776872e2 | €15.00 | €0.26 | matched |
| 82 | capture | 01a140ac-f158-7713-9d2f-bc9c6b5c3f49 | €35.00 | €0.50 | matched |
| 83 | capture | 01a140ac-f5c7-7596-b1c0-cb78654a78a2 | €49.00 | €0.67 | matched |
| 84 | capture | 01a140ad-049d-7c19-8847-9d4f5afe65c0 | €9.00 | €0.19 | matched |
| 85 | capture | 01a140ad-1d2d-70e5-bf35-89cf7b215b80 | €15.00 | €0.26 | matched |
| 86 | capture | 01a140ad-2bab-78fc-a456-07aca06bb3c9 | €15.00 | €0.26 | matched |
| 87 | capture | 01a140ad-40b5-794f-8efb-d1b1a3088c67 | €35.00 | €0.50 | matched |
| 88 | capture | 01a140ad-5c6a-72fe-9379-65603b3cb7cc | €49.00 | €0.67 | matched |
| 89 | refund | 01a140ad-60c5-7612-b4a9-f579dac9a7bb | -€18.00 | €0.00 | matched |
| 90 | capture | 01a140ad-77b0-78d7-8a5a-b080a46a7a12 | €49.00 | €0.67 | matched |
| 92 | capture | 01a140ad-b8f0-75a2-ba07-fdd4696f6fce | €15.00 | €0.26 | matched |
| 93 | capture | 01a140ad-da89-7011-9079-ffda674c6cf0 | €24.00 | €0.37 | matched |
| 94 | capture | 01a140ad-e968-7709-848e-4a033c90c6ab | €49.00 | €0.67 | matched |
| 95 | refund | 01a140ad-fc41-75a6-bbf8-7c504b1627a7 | -€3.00 | €0.00 | matched |
| 96 | refund | 01a140ae-1108-7054-ba9d-ea75c2fa7550 | -€24.00 | €0.00 | matched |
| 97 | capture | 01a140ae-2c2d-7905-b880-18a4f4ad0fff | €24.00 | €0.37 | matched |
| 98 | capture | 01a140ae-35b4-7de4-87a5-899437b1a254 | €15.00 | €0.26 | matched |
| 99 | capture | 01a140ae-55ab-72ac-bc21-40b50f6e1b03 | €35.00 | €0.50 | matched |
| 100 | capture | 01a140ae-69dd-7f75-9b78-a874b3f5126f | €35.00 | €0.50 | matched |
| 101 | capture | 01a140ae-6bbc-750c-b7c5-a850346c6d9c | €15.00 | €0.26 | matched |
| 102 | capture | 01a140ae-8596-7a77-9753-16811a22f3ec | €15.00 | €0.26 | matched |
| 103 | refund | 01a140ae-9a4b-743f-afbd-634310bf9290 | -€19.00 | €0.00 | matched |
| 104 | capture | 01a140ae-b1bb-7627-a36b-9b60c39946cd | €15.00 | €0.26 | matched |
| 105 | capture | 01a140ae-c164-718c-af83-a23e9a87608f | €35.00 | €0.50 | matched |
| 106 | capture | 01a140ae-c364-73c7-83eb-6df8de27990f | €49.00 | €0.67 | matched |
| 107 | capture | 01a140ae-cea7-77b2-bc73-062544fb3e70 | €35.00 | €0.50 | matched |
| 108 | capture | 01a140ae-e5ae-73df-a4d1-d7a95eaa886b | €9.00 | €0.19 | matched |
| 109 | refund | 01a140af-018a-7681-a9bb-32faf7d1ce63 | -€8.00 | €0.00 | matched |
| 110 | capture | 01a140af-2148-799d-840d-8a1251b1818e | €49.00 | €0.67 | matched |
| 111 | capture | 01a140af-310a-73ef-aa7c-0cbdabcdd9c8 | €49.00 | €0.67 | matched |
| 112 | capture | 01a140af-3874-79c5-9b60-ff24a0f9efaf | €24.00 | €0.37 | matched |
| 113 | capture | 01a140af-4316-700b-9bf0-06eadce2a436 | €24.00 | €0.37 | matched |
| 114 | capture | 01a140af-486b-7878-a709-fd755c1da1c5 | €24.00 | €0.37 | matched |
| 115 | capture | 01a140af-6191-7157-bd3d-36a1e0e9b23d | €49.00 | €0.67 | matched |