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
- 1 Nov, 14:50118 lines2 breaks
- 1 Nov, 14:40116 lines2 breaks
- 1 Nov, 14:30145 lines4 breaks
- 1 Nov, 14:20117 lines3 breaks
- 1 Nov, 14:10128 lines3 breaks
- 1 Nov, 14:00125 lines3 breaks
- 1 Nov, 13:50132 lines4 breaks
- 1 Nov, 13:40119 lines4 breaks
- 1 Nov, 13:30114 lines3 breaks
- 1 Nov, 13:20127 lines3 breaks
- 1 Nov, 13:10124 linesclean
- 1 Nov, 13:00118 lines2 breaks
- 1 Nov, 12:50132 linesclean
- 1 Nov, 12:40129 lines1 break
1 Nov, 13:50
Gross
€3,065.00
PSP fee
€48.50
Net to the bank
€3,016.50
Settlement journal
#325640
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19760-f397-792e-b29d-2a1b95ef49db is already settled by stl_EUR_2989235 line 16
- fee differencethe fee is not the contract feethe fee is 5, the contract says 0
- missing linein the books, not in the filerefund:01a19761-ff8f-7645-a654-b9ea6b7f27f6 is in no file
- missing linein the books, not in the filecapture:01a19767-9c3d-75fd-bd8e-59d464b0d74f is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 17 | capture | 01a19760-f3fb-76a9-b0f8-4ade98d7764f | €35.00 | €0.50 | duplicate line |
| 63 | refund | 01a19764-58d5-7c90-bfa1-e1e37fcd665e | -€9.00 | €0.05 | fee difference |
| 1 | refund | 01a19758-1003-799a-8f0a-f4e0fbf57c1a | -€13.00 | €0.00 | matched |
| 2 | capture | 01a1975f-e22f-712e-a213-b7fe9caf7c79 | €9.00 | €0.19 | matched |
| 3 | capture | 01a1975f-e754-79fd-a726-1f2300bd2917 | €49.00 | €0.67 | matched |
| 4 | capture | 01a1975f-f634-7cde-924d-c3d3caf679a2 | €24.00 | €0.37 | matched |
| 5 | capture | 01a19760-0fdc-7dba-a690-dfe3e649a71a | €49.00 | €0.67 | matched |
| 6 | capture | 01a19760-1544-7bcf-8ad1-06aa1b613155 | €35.00 | €0.50 | matched |
| 7 | capture | 01a19760-1bb7-7a3e-b33d-8f12b1291760 | €35.00 | €0.50 | matched |
| 8 | capture | 01a19760-2b49-733d-861b-402c872ff4c3 | €49.00 | €0.67 | matched |
| 9 | capture | 01a19760-304e-71bf-93ef-ae263fdb569d | €35.00 | €0.50 | matched |
| 10 | capture | 01a19760-4849-76db-9650-a12f7a9e34be | €24.00 | €0.37 | matched |
| 11 | capture | 01a19760-4ee1-7b8f-88d2-1282a9da9d28 | €9.00 | €0.19 | matched |
| 12 | capture | 01a19760-8e16-72ff-a4c1-72080fb0f071 | €49.00 | €0.67 | matched |
| 13 | capture | 01a19760-9d42-717c-b3f1-3e2d73044aa5 | €15.00 | €0.26 | matched |
| 14 | capture | 01a19760-cd44-7164-9b03-f635ce1538d2 | €15.00 | €0.26 | matched |
| 15 | capture | 01a19760-edf6-74e9-b88b-e69c572a64b3 | €49.00 | €0.67 | matched |
| 16 | capture | 01a19760-f3fb-76a9-b0f8-4ade98d7764f | €35.00 | €0.50 | matched |
| 18 | capture | 01a19761-0593-7866-91ab-f1d8818f0d33 | €24.00 | €0.37 | matched |
| 19 | refund | 01a19761-0f22-73e4-bd4d-d3be012dabe6 | -€8.00 | €0.00 | matched |
| 20 | capture | 01a19761-19a1-7079-aef7-c9557aa214b3 | €35.00 | €0.50 | matched |
| 21 | capture | 01a19761-1f95-7e79-b937-68449034e3a9 | €15.00 | €0.26 | matched |
| 22 | capture | 01a19761-2ee0-76b1-a448-090f99fdc2a1 | €9.00 | €0.19 | matched |
| 23 | refund | 01a19761-3908-78b3-bb5f-8f7908937eed | -€10.00 | €0.00 | matched |
| 24 | capture | 01a19761-6334-710c-8ee4-d4ffb60d0acf | €9.00 | €0.19 | matched |
| 25 | capture | 01a19761-8fad-7151-ac25-dff51bd16106 | €9.00 | €0.19 | matched |
| 26 | capture | 01a19761-93dc-7bd4-bd63-05f0eb47e7e4 | €49.00 | €0.67 | matched |
| 27 | capture | 01a19761-947a-70c6-b213-9a63f8832727 | €35.00 | €0.50 | matched |
| 28 | capture | 01a19761-b661-7fb2-af4d-7dae004e60ba | €24.00 | €0.37 | matched |
| 29 | capture | 01a19761-e8cf-7146-8df8-6d23de77fa65 | €24.00 | €0.37 | matched |
| 30 | capture | 01a19762-469b-703c-b146-36016e064f0f | €15.00 | €0.26 | matched |
| 31 | capture | 01a19762-69ee-7fc2-8dbf-5494d4e9f83c | €9.00 | €0.19 | matched |
| 32 | capture | 01a19762-7182-792b-9ce6-adc2e1ce89c6 | €24.00 | €0.37 | matched |
| 33 | capture | 01a19762-7f1d-7c67-af2f-2cf57ca559c1 | €15.00 | €0.26 | matched |
| 34 | capture | 01a19762-82a4-748d-8ac1-5794debcd3f4 | €24.00 | €0.37 | matched |
| 35 | capture | 01a19762-9022-7d9c-97db-d0b3f79050f7 | €24.00 | €0.37 | matched |
| 36 | capture | 01a19762-b257-7342-a666-366eba3cca53 | €49.00 | €0.67 | matched |
| 37 | refund | 01a19762-c7cb-7fa9-a5a1-52c6ff32b096 | -€23.00 | €0.00 | matched |
| 38 | capture | 01a19762-d927-74a1-9bee-0e04e3ffdb5e | €35.00 | €0.50 | matched |
| 39 | capture | 01a19762-f5f4-7d61-a67a-1a95ede86a60 | €35.00 | €0.50 | matched |
| 40 | capture | 01a19762-f790-7f17-9412-08cd4a2fa7a5 | €15.00 | €0.26 | matched |
| 41 | capture | 01a19762-f87c-7932-9942-02b68840fd48 | €35.00 | €0.50 | matched |
| 42 | capture | 01a19763-0d9b-7d0e-9b67-abdeca62014a | €15.00 | €0.26 | matched |
| 43 | capture | 01a19763-27d2-7e2d-9bba-4fc462bd7383 | €24.00 | €0.37 | matched |
| 44 | capture | 01a19763-3bf5-702c-b287-8dcd23d59a46 | €35.00 | €0.50 | matched |
| 45 | capture | 01a19763-4ce1-7c54-8a5e-954556aac3af | €24.00 | €0.37 | matched |
| 46 | capture | 01a19763-50a4-7a22-a398-b9dca430c945 | €15.00 | €0.26 | matched |
| 47 | capture | 01a19763-5d59-7d31-9a7d-c14c68e0845e | €24.00 | €0.37 | matched |
| 48 | capture | 01a19763-853f-7dcc-a670-c7db698fac3b | €15.00 | €0.26 | matched |
| 49 | capture | 01a19763-9564-7615-9fc9-47b0bb4619a6 | €24.00 | €0.37 | matched |
| 50 | capture | 01a19763-b92c-7e22-8788-6957d7da31c1 | €49.00 | €0.67 | matched |
| 51 | capture | 01a19763-d920-7d24-b214-29727d104040 | €35.00 | €0.50 | matched |
| 52 | capture | 01a19763-e495-734e-9fd5-3d3badc6beb3 | €15.00 | €0.26 | matched |
| 53 | capture | 01a19763-ebf3-7c89-a432-3d1455173c08 | €24.00 | €0.37 | matched |
| 54 | capture | 01a19764-0046-7fd2-9701-63253d075840 | €49.00 | €0.67 | matched |
| 55 | capture | 01a19764-071a-70f9-aa69-ed44bc7261f9 | €9.00 | €0.19 | matched |
| 56 | capture | 01a19764-104c-7066-8ae6-7851bae00cb3 | €24.00 | €0.37 | matched |
| 57 | refund | 01a19764-1325-726f-b9b2-cfd62bd87d20 | -€33.00 | €0.00 | matched |
| 58 | capture | 01a19764-1c1b-7d54-a970-3970ea358120 | €15.00 | €0.26 | matched |
| 59 | capture | 01a19764-33e5-7fd0-b357-4ec00b2d7a96 | €49.00 | €0.67 | matched |
| 60 | capture | 01a19764-358b-790a-a286-45c747733fbf | €49.00 | €0.67 | matched |
| 61 | capture | 01a19764-4e11-7913-8142-f3cffca6dafb | €15.00 | €0.26 | matched |
| 62 | capture | 01a19764-53cf-7731-8846-7691863693cd | €35.00 | €0.50 | matched |
| 64 | capture | 01a19764-5a66-7317-8fc0-bf3fa68e7525 | €15.00 | €0.26 | matched |
| 65 | capture | 01a19764-5c89-767c-b3ac-20ec21f4bbd6 | €15.00 | €0.26 | matched |
| 66 | capture | 01a19764-6da6-78b7-90e4-7a9c9d789d3e | €15.00 | €0.26 | matched |
| 67 | capture | 01a19764-88bf-7a2e-9c9c-96868bc596f6 | €49.00 | €0.67 | matched |
| 68 | capture | 01a19764-89ec-7ed2-b394-77cffc3a51b3 | €35.00 | €0.50 | matched |
| 69 | refund | 01a19764-8e72-7c50-a3be-0c8be2f50490 | -€11.00 | €0.00 | matched |
| 70 | capture | 01a19764-ba8e-7813-a706-cc3c2ecf4394 | €24.00 | €0.37 | matched |
| 71 | capture | 01a19764-befe-7d6c-ae16-224a666fd8ae | €35.00 | €0.50 | matched |
| 72 | capture | 01a19764-e0bc-7846-8275-1046b0dfecbc | €35.00 | €0.50 | matched |
| 73 | capture | 01a19765-0d5d-7071-abc0-2a20bf5a88b8 | €15.00 | €0.26 | matched |
| 74 | capture | 01a19765-0e79-71bf-bf61-02a9888b6078 | €24.00 | €0.37 | matched |
| 75 | capture | 01a19765-2156-7876-9136-4854fe28ab50 | €49.00 | €0.67 | matched |
| 76 | capture | 01a19765-5454-7119-8779-43ac79ddae7c | €15.00 | €0.26 | matched |
| 77 | capture | 01a19765-6888-7bbf-a25b-905e9bd48cea | €35.00 | €0.50 | matched |
| 78 | capture | 01a19765-73fb-71ed-a786-119323609c8f | €9.00 | €0.19 | matched |
| 79 | capture | 01a19765-9a66-7c00-bf47-df029a728e41 | €49.00 | €0.67 | matched |
| 80 | capture | 01a19765-a2d2-7b9d-91c1-a4f0ae1f157d | €35.00 | €0.50 | matched |
| 81 | capture | 01a19765-a326-74bc-b782-41b764eb5b58 | €35.00 | €0.50 | matched |
| 82 | capture | 01a19765-c487-7077-a4db-67592304566c | €24.00 | €0.37 | matched |
| 83 | capture | 01a19765-cb47-7a62-bb52-2f255f57e0f4 | €35.00 | €0.50 | matched |
| 84 | capture | 01a19765-ee0b-7d6c-9085-79c6923c45a8 | €9.00 | €0.19 | matched |
| 85 | capture | 01a19766-0429-7d00-a9c9-27c4a8b0f605 | €15.00 | €0.26 | matched |
| 86 | capture | 01a19766-1084-7732-9c60-b3ea652e3db3 | €9.00 | €0.19 | matched |
| 87 | capture | 01a19766-4841-72a2-b63e-70c6fa85974f | €35.00 | €0.50 | matched |
| 88 | capture | 01a19766-467f-7df4-b9ea-9b3447f92bf6 | €15.00 | €0.26 | matched |
| 89 | capture | 01a19766-5aaf-72c9-9277-fbd89ac14563 | €24.00 | €0.37 | matched |
| 90 | refund | 01a19766-5ce5-7117-b146-6cb1bb191409 | -€11.00 | €0.00 | matched |
| 91 | capture | 01a19766-6a6f-744c-8760-841f8c62f880 | €49.00 | €0.67 | matched |
| 92 | capture | 01a19766-7e32-7bf3-af3e-2a52c0210c62 | €9.00 | €0.19 | matched |
| 93 | capture | 01a19766-7e36-7e04-9060-655db198b5b1 | €9.00 | €0.19 | matched |
| 94 | capture | 01a19766-894f-7bc3-addf-9acb12fb7f3e | €15.00 | €0.26 | matched |
| 95 | capture | 01a19766-99ad-723c-8f80-6408c320fb2e | €15.00 | €0.26 | matched |
| 96 | refund | 01a19766-a300-7cef-8a16-0c688f4b8f48 | -€23.00 | €0.00 | matched |
| 97 | refund | 01a19766-af4c-7e02-b027-3e6b60636751 | -€9.00 | €0.00 | matched |
| 98 | capture | 01a19766-b2fc-7c16-bb49-c6e6352b08b8 | €49.00 | €0.67 | matched |
| 99 | refund | 01a19766-ba3d-7b91-a187-5f9c773d8b74 | -€4.00 | €0.00 | matched |
| 100 | capture | 01a19766-df9e-794d-81a5-c9b9451a7a6e | €9.00 | €0.19 | matched |
| 101 | capture | 01a19766-e8b2-745e-9589-b57abfbbd9ee | €15.00 | €0.26 | matched |
| 102 | capture | 01a19766-e95f-7862-a714-94663206c62c | €24.00 | €0.37 | matched |
| 103 | capture | 01a19766-f7c2-795a-b973-902c73042d2b | €9.00 | €0.19 | matched |
| 104 | capture | 01a19767-31d8-7350-aba5-501a71e69847 | €49.00 | €0.67 | matched |
| 105 | capture | 01a19767-4471-7849-b6e4-613776a13e84 | €9.00 | €0.19 | matched |
| 106 | refund | 01a19767-45d0-75f9-a99f-9db21a09507e | -€7.00 | €0.00 | matched |
| 107 | capture | 01a19767-529e-7910-b942-213363149d2a | €15.00 | €0.26 | matched |
| 108 | capture | 01a19767-59d2-7f89-a293-61bb8027f495 | €9.00 | €0.19 | matched |
| 109 | capture | 01a19767-8d27-7a75-b8d4-1c3d86176fc4 | €9.00 | €0.19 | matched |
| 110 | capture | 01a19767-a127-7d09-8efa-00bb9335eb99 | €9.00 | €0.19 | matched |
| 111 | capture | 01a19767-b78c-725d-b13c-34af23e5df24 | €15.00 | €0.26 | matched |
| 112 | capture | 01a19767-d2db-778e-a6be-8b2da8daf08b | €49.00 | €0.67 | matched |
| 113 | capture | 01a19767-d846-704e-8844-5b0c2290e17e | €9.00 | €0.19 | matched |
| 114 | capture | 01a19767-e31f-7007-9a4d-b010db76532d | €24.00 | €0.37 | matched |
| 115 | capture | 01a19767-e3f8-7d2c-8303-747d90ba6e2d | €49.00 | €0.67 | matched |
| 116 | capture | 01a19768-05ad-7cea-8fb0-61497e27ca4d | €49.00 | €0.67 | matched |
| 117 | capture | 01a19768-086f-702a-a304-5e02237dfc11 | €15.00 | €0.26 | matched |
| 118 | capture | 01a19768-5d94-72ab-b51d-08e88f20b589 | €35.00 | €0.50 | matched |
| 119 | capture | 01a19768-6111-72fe-adb3-b4b6342c2f48 | €49.00 | €0.67 | matched |
| 120 | capture | 01a19768-6580-7f84-8463-faef2bdc7915 | €49.00 | €0.67 | matched |
| 121 | capture | 01a19768-6298-71c7-983f-41b31a807aa9 | €24.00 | €0.37 | matched |
| 122 | capture | 01a19768-6d0e-765b-981c-78fed0fb4004 | €49.00 | €0.67 | matched |
| 123 | capture | 01a19768-79e7-75a2-ac4f-6fe366f80fa5 | €35.00 | €0.50 | matched |
| 124 | capture | 01a19768-7a3b-78ae-ab23-15ca674c300b | €15.00 | €0.26 | matched |
| 125 | capture | 01a19768-8a17-7c68-94cc-ec78b117c66c | €24.00 | €0.37 | matched |
| 126 | capture | 01a19768-905a-7e5c-ab3f-0487ef4a6205 | €24.00 | €0.37 | matched |
| 127 | capture | 01a19768-91ff-7812-991b-9fa8965340e2 | €35.00 | €0.50 | matched |
| 128 | capture | 01a19768-bd65-7563-a2af-486d85a5d8b3 | €49.00 | €0.67 | matched |
| 129 | capture | 01a19768-c8c2-7f65-a144-d17bc5feb726 | €15.00 | €0.26 | matched |
| 130 | capture | 01a19768-d841-71ef-8d0c-d72bf2031b7d | €9.00 | €0.19 | matched |
| 131 | capture | 01a19768-e3ea-7562-9c85-a8b0ca05df46 | €49.00 | €0.67 | matched |
| 132 | capture | 01a19768-eda2-79b5-821e-c1de1f980b55 | €24.00 | €0.37 | matched |