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
- 17 Oct, 05:20149 lines3 breaks
- 17 Oct, 05:10128 lines6 breaks
- 17 Oct, 05:00116 lines4 breaks
- 17 Oct, 04:50117 linesclean
- 17 Oct, 04:40114 lines2 breaks
- 17 Oct, 04:30123 lines1 break
- 17 Oct, 04:20135 lines2 breaks
- 17 Oct, 04:10110 lines4 breaks
- 17 Oct, 04:00115 lines1 break
- 17 Oct, 03:50123 lines1 break
- 17 Oct, 03:40134 linesclean
- 17 Oct, 03:30110 lines1 break
- 17 Oct, 03:20128 lines3 breaks
- 17 Oct, 03:10136 lines3 breaks
17 Oct, 04:10
Gross
€2,464.00
PSP fee
€39.46
Net to the bank
€2,424.54
Settlement journal
#45036
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14813-97d4-7d7f-a570-db59f4a422e7 is already settled by stl_EUR_2987017 line 70
- fee differencethe fee is not the contract feethe fee is 30, the contract says 26
- missing linein the books, not in the filecapture:01a1480f-f2ac-7dd1-89d1-b84e8e21f8f5 is in no file
- missing linein the books, not in the filecapture:01a14813-9d2e-7e48-9d41-f18d153d286c is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 48 | capture | 01a14810-fd86-77f1-b3be-169de2299e66 | €15.00 | €0.30 | fee difference |
| 71 | capture | 01a14813-9810-7f0b-8212-ff751cfdfa3c | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a14804-a57d-7446-b52e-9c25cfdd80ef | €9.00 | €0.19 | matched |
| 2 | refund | 01a14806-0ded-796d-a61b-4cb8f47561ae | -€32.00 | €0.00 | matched |
| 3 | capture | 01a14809-44e7-79f6-843d-ab6486176403 | €15.00 | €0.26 | matched |
| 4 | capture | 01a1480b-c84c-7432-9faf-0c418498de94 | €24.00 | €0.37 | matched |
| 5 | refund | 01a1480d-7173-734b-a2aa-e2c5c243ef56 | -€3.00 | €0.00 | matched |
| 6 | refund | 01a1480d-717b-7db5-9016-398a1f9e58a3 | -€10.00 | €0.00 | matched |
| 7 | capture | 01a1480d-7651-7e49-b117-e3971b6503fb | €15.00 | €0.26 | matched |
| 8 | capture | 01a1480d-88b0-75e8-be9a-9930adf95896 | €15.00 | €0.26 | matched |
| 9 | capture | 01a1480d-8fed-7f06-88f9-62db08e30e57 | €49.00 | €0.67 | matched |
| 10 | capture | 01a1480d-abd5-75c3-a6e6-80a2ea88fb86 | €15.00 | €0.26 | matched |
| 11 | capture | 01a1480d-a660-77f3-ac53-2bcb78ff7e86 | €15.00 | €0.26 | matched |
| 12 | capture | 01a1480d-b710-7be5-af53-370b001b6dea | €15.00 | €0.26 | matched |
| 13 | capture | 01a1480d-fcf3-7dcd-849c-88d24e08be0e | €49.00 | €0.67 | matched |
| 14 | capture | 01a1480e-14bb-7e51-825c-2e01282c532a | €9.00 | €0.19 | matched |
| 15 | capture | 01a1480e-5c5a-7c43-b767-01344a63e217 | €9.00 | €0.19 | matched |
| 16 | capture | 01a1480e-63e2-7f17-9f8e-09517c00003b | €35.00 | €0.50 | matched |
| 17 | capture | 01a1480e-8dd2-75eb-b184-5ad13127b27d | €9.00 | €0.19 | matched |
| 18 | capture | 01a1480e-a1b1-72f3-9065-1bf92dbba614 | €35.00 | €0.50 | matched |
| 19 | capture | 01a1480e-b353-70d2-86fb-a4022736cba3 | €9.00 | €0.19 | matched |
| 20 | capture | 01a1480e-c83e-72c0-b148-896a2b2d28cf | €49.00 | €0.67 | matched |
| 21 | capture | 01a1480e-da5b-73b9-9f5a-4b98ffdea27c | €49.00 | €0.67 | matched |
| 22 | capture | 01a1480e-dd99-7057-8548-a1dd1aba5619 | €15.00 | €0.26 | matched |
| 23 | capture | 01a1480e-fd84-7f3c-8c8e-967779b04977 | €49.00 | €0.67 | matched |
| 24 | capture | 01a1480f-18d3-749b-87ff-d2a0268cee41 | €9.00 | €0.19 | matched |
| 25 | capture | 01a1480f-1e86-7dfb-a15f-976d90e2edeb | €35.00 | €0.50 | matched |
| 26 | capture | 01a1480f-4706-7e0a-811f-c595d7ab808c | €24.00 | €0.37 | matched |
| 27 | capture | 01a1480f-48e9-70f2-a343-66fcec247d58 | €9.00 | €0.19 | matched |
| 28 | capture | 01a1480f-4de1-7ff8-9d15-b39689d4bcb8 | €9.00 | €0.19 | matched |
| 29 | capture | 01a1480f-822d-7077-be1e-816697fbaeac | €49.00 | €0.67 | matched |
| 30 | capture | 01a1480f-85e0-74e9-8351-0da8a4b32deb | €35.00 | €0.50 | matched |
| 31 | capture | 01a1480f-8d73-7ce4-83a7-61c18510a55d | €9.00 | €0.19 | matched |
| 32 | refund | 01a1480f-8fb0-7f0f-b698-d16fec7aa32c | -€14.00 | €0.00 | matched |
| 33 | capture | 01a1480f-c6d5-7169-b003-4f74c6bf9782 | €35.00 | €0.50 | matched |
| 34 | capture | 01a1480f-cb1e-7f93-b7e9-294a807c3a58 | €9.00 | €0.19 | matched |
| 35 | capture | 01a14810-1253-7b4a-9576-f23b3a0aa749 | €15.00 | €0.26 | matched |
| 36 | capture | 01a14810-2ed4-7803-901a-282941e6d4f2 | €24.00 | €0.37 | matched |
| 37 | capture | 01a14810-63b3-79a9-8b96-b84ce72ea8bc | €9.00 | €0.19 | matched |
| 38 | capture | 01a14810-73dd-755a-9e01-2c08895ae36d | €49.00 | €0.67 | matched |
| 39 | capture | 01a14810-8dbe-777c-967e-2f153f7328c0 | €35.00 | €0.50 | matched |
| 40 | capture | 01a14810-c1ab-7237-a0b5-4acca72d0d10 | €49.00 | €0.67 | matched |
| 41 | capture | 01a14810-cbc5-78ac-8b55-954330f9bc9c | €24.00 | €0.37 | matched |
| 42 | capture | 01a14810-cc65-7d00-8a4f-aff43d5120f0 | €35.00 | €0.50 | matched |
| 43 | capture | 01a14810-d18c-704f-b2cd-7f6a5dd255c0 | €35.00 | €0.50 | matched |
| 44 | capture | 01a14810-d429-7c1c-91d8-0a02fb0efc97 | €9.00 | €0.19 | matched |
| 45 | capture | 01a14810-da1c-770b-8bcc-d124cd01b357 | €35.00 | €0.50 | matched |
| 46 | capture | 01a14810-faa3-7882-8719-1992b9288267 | €15.00 | €0.26 | matched |
| 47 | capture | 01a14810-fd28-71b6-8870-24b55861e391 | €15.00 | €0.26 | matched |
| 49 | capture | 01a14810-ff14-7908-a653-815c053f5fa5 | €35.00 | €0.50 | matched |
| 50 | refund | 01a14811-0823-7a6d-ae46-abf83ebb917f | -€18.00 | €0.00 | matched |
| 51 | capture | 01a14811-0145-7232-9612-588f98316917 | €49.00 | €0.67 | matched |
| 52 | capture | 01a14811-3443-7136-8c2b-ecfdaa206650 | €9.00 | €0.19 | matched |
| 53 | capture | 01a14811-3790-7430-94f5-434d715cf5e9 | €49.00 | €0.67 | matched |
| 54 | capture | 01a14811-4f9f-774d-be39-1bcba4fcb9b7 | €49.00 | €0.67 | matched |
| 55 | capture | 01a14811-5e39-7146-b07f-3b94dd5be420 | €15.00 | €0.26 | matched |
| 56 | capture | 01a14811-b30c-7567-a48e-95e0e454ae62 | €15.00 | €0.26 | matched |
| 57 | capture | 01a14811-e346-7fac-bcd6-c77452cb09c1 | €15.00 | €0.26 | matched |
| 58 | capture | 01a14811-f79d-705b-ab4e-ae5e30fccbcf | €49.00 | €0.67 | matched |
| 59 | refund | 01a14812-509f-7f22-a4cd-1ed2738b506b | -€22.00 | €0.00 | matched |
| 60 | capture | 01a14812-6a04-73cb-a583-3065304000e6 | €24.00 | €0.37 | matched |
| 61 | capture | 01a14812-83fd-7a75-b366-d73c56d1cfe3 | €15.00 | €0.26 | matched |
| 62 | capture | 01a14812-88f9-79e0-97c3-d7359b16646d | €15.00 | €0.26 | matched |
| 63 | capture | 01a14812-8adc-75e7-bce4-f7e27a3c2993 | €35.00 | €0.50 | matched |
| 64 | capture | 01a14812-90fb-7c7b-aea0-853cee62f413 | €35.00 | €0.50 | matched |
| 65 | capture | 01a14812-b0b9-79c0-ab16-ac4460072fcf | €49.00 | €0.67 | matched |
| 66 | capture | 01a14813-4d9c-70b9-9419-ed358285f1d9 | €9.00 | €0.19 | matched |
| 67 | capture | 01a14813-680a-77d5-989d-3954272ed454 | €9.00 | €0.19 | matched |
| 68 | capture | 01a14813-73d1-73d7-a43c-5bbfa55c5057 | €24.00 | €0.37 | matched |
| 69 | capture | 01a14813-8776-7c64-9ddf-71a8a93f8310 | €35.00 | €0.50 | matched |
| 70 | capture | 01a14813-9810-7f0b-8212-ff751cfdfa3c | €24.00 | €0.37 | matched |
| 72 | capture | 01a14813-9d74-77fe-80df-90cdba9c2d15 | €15.00 | €0.26 | matched |
| 73 | capture | 01a14813-b135-753a-9e9f-0279fdc8e7dd | €9.00 | €0.19 | matched |
| 74 | capture | 01a14813-c3c8-7d04-96ba-4c00bdc4248f | €35.00 | €0.50 | matched |
| 75 | capture | 01a14813-c88f-73cc-b7dd-29c8b15d1f5a | €9.00 | €0.19 | matched |
| 76 | refund | 01a14813-d8a3-7d49-b69b-ed5268da5a77 | -€13.00 | €0.00 | matched |
| 77 | capture | 01a14813-e6f3-7d11-87b3-626d96ed509e | €24.00 | €0.37 | matched |
| 78 | capture | 01a14814-0add-7d28-b1d1-0ec23194de70 | €35.00 | €0.50 | matched |
| 79 | capture | 01a14814-17a1-7ca9-a66d-43fbc40f6cf7 | €35.00 | €0.50 | matched |
| 80 | capture | 01a14814-32f1-715a-9eca-e5ec05620431 | €9.00 | €0.19 | matched |
| 81 | capture | 01a14814-4156-7d60-934a-50391d62f636 | €35.00 | €0.50 | matched |
| 82 | capture | 01a14814-4274-7c2e-aa70-815e2e557fb2 | €35.00 | €0.50 | matched |
| 83 | capture | 01a14814-4d50-7bee-a64b-31d708c2dd88 | €15.00 | €0.26 | matched |
| 84 | capture | 01a14814-4dc7-7de0-89bf-3b9bd8ecc49c | €49.00 | €0.67 | matched |
| 85 | capture | 01a14814-500c-74d3-adab-23ed349b4130 | €9.00 | €0.19 | matched |
| 86 | capture | 01a14814-501b-7060-9872-349e6f072bcd | €49.00 | €0.67 | matched |
| 87 | capture | 01a14814-761e-78bc-a939-0335218eba8e | €35.00 | €0.50 | matched |
| 88 | capture | 01a14814-9233-771a-8e7c-d3dbbbc3fd6d | €35.00 | €0.50 | matched |
| 89 | capture | 01a14814-a016-77ec-90db-c7d92208e0bb | €15.00 | €0.26 | matched |
| 90 | capture | 01a14814-b540-7b32-824b-6a89fcf733da | €15.00 | €0.26 | matched |
| 91 | refund | 01a14814-b715-7eb7-b62d-575a05fe7938 | -€12.00 | €0.00 | matched |
| 92 | capture | 01a14814-b77d-738b-855e-ffd4be617c7f | €24.00 | €0.37 | matched |
| 93 | capture | 01a14814-bc9e-74f6-9964-7c1718ee659f | €9.00 | €0.19 | matched |
| 94 | capture | 01a14814-c9fd-78cc-ac5e-b37da6a3aa2a | €49.00 | €0.67 | matched |
| 95 | capture | 01a14814-d9b5-727a-bfb4-8809599dc5c0 | €35.00 | €0.50 | matched |
| 96 | capture | 01a14814-f53b-707a-99bd-4a1920e3fc1e | €49.00 | €0.67 | matched |
| 97 | capture | 01a14814-ffdb-756d-a5b2-97f626e8acc2 | €49.00 | €0.67 | matched |
| 98 | capture | 01a14815-0a93-7533-8373-7496db400db3 | €24.00 | €0.37 | matched |
| 99 | capture | 01a14815-5099-7756-97c1-d50d9650ea77 | €9.00 | €0.19 | matched |
| 100 | capture | 01a14815-54e4-7ed4-bc92-cb346e85ed89 | €24.00 | €0.37 | matched |
| 101 | capture | 01a14815-62a1-7bae-a9de-5e3af6632617 | €9.00 | €0.19 | matched |
| 102 | capture | 01a14815-b629-73bf-b0b8-01e8d9e73134 | €35.00 | €0.50 | matched |
| 103 | capture | 01a14815-cf90-7c8b-90d8-0aa449bbd571 | €9.00 | €0.19 | matched |
| 104 | capture | 01a14815-dcfc-7f78-89c6-eea7069ce7a3 | €24.00 | €0.37 | matched |
| 105 | capture | 01a14815-e20d-7bf8-93dc-d7090adcd347 | €49.00 | €0.67 | matched |
| 106 | capture | 01a14815-f849-7023-a267-21af19714be5 | €49.00 | €0.67 | matched |
| 107 | capture | 01a14816-170f-72a5-829a-4a85401a5ea6 | €15.00 | €0.26 | matched |
| 108 | refund | 01a14816-4e44-7e36-8689-2b811e424da3 | -€14.00 | €0.00 | matched |
| 109 | capture | 01a14816-7ce4-7dda-bac4-3e32447ce70f | €9.00 | €0.19 | matched |
| 110 | capture | 01a14816-7d29-7973-9d70-163b81205cec | €9.00 | €0.19 | matched |