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
- 29 Oct, 22:2090 linesclean
- 29 Oct, 22:10127 lines4 breaks
- 29 Oct, 22:00123 lines2 breaks
- 29 Oct, 21:50129 lines2 breaks
- 29 Oct, 21:40107 lines2 breaks
- 29 Oct, 21:30143 lines3 breaks
- 29 Oct, 21:20114 lines2 breaks
- 29 Oct, 21:10102 linesclean
- 29 Oct, 21:00131 lines1 break
- 29 Oct, 20:50139 lines4 breaks
- 29 Oct, 20:40124 lines3 breaks
- 29 Oct, 20:30112 lines4 breaks
- 29 Oct, 20:2095 lines1 break
- 29 Oct, 20:10114 linesclean
29 Oct, 21:20
Gross
€2,435.00
PSP fee
€39.22
Net to the bank
€2,395.78
Settlement journal
#276348
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a1898c-fc28-7a35-b6f9-3441e3f99ff3 is already settled by stl_EUR_2988848 line 65
- missing linein the books, not in the filecapture:01a1898a-ee30-780c-b6af-92f72bb7fb13 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 66 | refund | 01a1898c-fc2b-7ee4-b762-6cbb5acf2941 | -€14.00 | €0.00 | duplicate line |
| 1 | capture | 01a1897f-dbbd-7220-85a0-7228553ede93 | €9.00 | €0.19 | matched |
| 2 | capture | 01a18981-aa3d-7e02-8a9d-ae393c4317e0 | €24.00 | €0.37 | matched |
| 3 | capture | 01a18987-6ce1-74d7-b469-73cad315440f | €49.00 | €0.67 | matched |
| 4 | capture | 01a18988-d128-713e-a6f6-47f5792bface | €9.00 | €0.19 | matched |
| 5 | capture | 01a18988-d5a7-772e-bb86-5ab3106ea607 | €35.00 | €0.50 | matched |
| 6 | capture | 01a18988-f992-7c3b-aae0-fa567c2c8c30 | €9.00 | €0.19 | matched |
| 7 | capture | 01a18989-1186-784e-b3d8-a4f1a4e77ea6 | €9.00 | €0.19 | matched |
| 8 | capture | 01a18989-1198-7001-9a0a-89d909986ce8 | €35.00 | €0.50 | matched |
| 9 | capture | 01a18989-2f8b-7090-9b79-26bb8e5ab137 | €15.00 | €0.26 | matched |
| 10 | capture | 01a18989-2e45-73c0-a900-dae41b00644c | €15.00 | €0.26 | matched |
| 11 | capture | 01a18989-473a-72aa-b563-6afcb886c132 | €24.00 | €0.37 | matched |
| 12 | capture | 01a18989-5b46-7632-a971-f6b16d610cc2 | €49.00 | €0.67 | matched |
| 13 | capture | 01a18989-6d06-7bb0-bf9f-bceb27908422 | €9.00 | €0.19 | matched |
| 14 | capture | 01a18989-964d-7d1e-afce-790e86441564 | €35.00 | €0.50 | matched |
| 15 | capture | 01a18989-adcb-7786-909b-4d630fdb97b1 | €49.00 | €0.67 | matched |
| 16 | capture | 01a18989-b0e9-7d2e-be5d-7364818c23f2 | €9.00 | €0.19 | matched |
| 17 | capture | 01a18989-b6ba-7d00-91c7-afa22e1b19c8 | €15.00 | €0.26 | matched |
| 18 | capture | 01a18989-b8dc-7d07-91f1-7743df86b436 | €9.00 | €0.19 | matched |
| 19 | capture | 01a18989-c020-730a-8fe1-9b904606351d | €35.00 | €0.50 | matched |
| 20 | capture | 01a18989-ef2d-75af-9253-cb8fb4d05cf9 | €15.00 | €0.26 | matched |
| 21 | capture | 01a1898a-14a9-7cb1-8195-8c60e96b8a2a | €15.00 | €0.26 | matched |
| 22 | capture | 01a1898a-33dc-77ce-8d61-0a8b3550d4cb | €24.00 | €0.37 | matched |
| 23 | capture | 01a1898a-5c9a-7e08-ab81-9d2c60f29f7b | €49.00 | €0.67 | matched |
| 24 | capture | 01a1898a-7484-794d-a5a5-7fc70e4a00ee | €15.00 | €0.26 | matched |
| 25 | capture | 01a1898a-99a6-7892-a875-6a39546e1eb8 | €35.00 | €0.50 | matched |
| 26 | capture | 01a1898a-9ee2-7a40-86eb-8bb73e3cc660 | €24.00 | €0.37 | matched |
| 27 | capture | 01a1898a-a8da-7596-9fc8-687a39f5f8bb | €35.00 | €0.50 | matched |
| 28 | capture | 01a1898a-c7da-7fa8-ae32-c56b8df09bce | €15.00 | €0.26 | matched |
| 29 | capture | 01a1898a-f2f8-7140-b8c6-f51b0b43d460 | €24.00 | €0.37 | matched |
| 30 | capture | 01a1898b-0ae1-7fa4-b3bd-6e02273943b4 | €49.00 | €0.67 | matched |
| 31 | capture | 01a1898b-0bca-70ad-a37a-082dcdf26220 | €49.00 | €0.67 | matched |
| 32 | capture | 01a1898b-1682-7751-b7c9-8c45bc0e6ed5 | €15.00 | €0.26 | matched |
| 33 | capture | 01a1898b-5410-7f33-986b-ee767d5c2caf | €35.00 | €0.50 | matched |
| 34 | capture | 01a1898b-6b3d-7ebd-b8f0-964f9186fa4f | €15.00 | €0.26 | matched |
| 35 | capture | 01a1898b-7e7a-701f-9d23-cea5b38965c2 | €9.00 | €0.19 | matched |
| 36 | capture | 01a1898b-8786-7c29-a1fe-17147ecd07ba | €15.00 | €0.26 | matched |
| 37 | capture | 01a1898b-889b-7a16-9ea9-f201ac332cc1 | €9.00 | €0.19 | matched |
| 38 | capture | 01a1898b-8ca3-7894-9c85-4c822eef15eb | €15.00 | €0.26 | matched |
| 39 | capture | 01a1898b-972d-7982-852b-8007548d9380 | €24.00 | €0.37 | matched |
| 40 | capture | 01a1898b-9c89-7650-91c6-9594d3ce2f42 | €15.00 | €0.26 | matched |
| 41 | capture | 01a1898b-d390-7a6e-aecc-a0d78c2a427c | €49.00 | €0.67 | matched |
| 42 | capture | 01a1898b-fa0b-7293-a832-825f0fd87d79 | €49.00 | €0.67 | matched |
| 43 | refund | 01a1898b-fa38-73ca-8f39-2d7053edbe5f | -€12.00 | €0.00 | matched |
| 44 | capture | 01a1898b-fb84-7150-a22e-8e71eab48975 | €15.00 | €0.26 | matched |
| 45 | capture | 01a1898c-04ad-7180-a8e2-4e1d07ca21e9 | €9.00 | €0.19 | matched |
| 46 | capture | 01a1898c-0cbe-7374-a32c-0d0e39f80fe9 | €9.00 | €0.19 | matched |
| 47 | capture | 01a1898c-0f56-76e5-b22c-a6ea19f335d1 | €9.00 | €0.19 | matched |
| 48 | capture | 01a1898c-2aff-7eaa-8657-ab84966f5f47 | €24.00 | €0.37 | matched |
| 49 | capture | 01a1898c-2e86-7853-b139-402831e36349 | €24.00 | €0.37 | matched |
| 50 | capture | 01a1898c-3206-7ba8-8d85-86bfa69f9a5f | €24.00 | €0.37 | matched |
| 51 | capture | 01a1898c-4581-747e-8184-e01410c88451 | €24.00 | €0.37 | matched |
| 52 | capture | 01a1898c-4a32-705d-a2c1-dc70df503b7f | €9.00 | €0.19 | matched |
| 53 | capture | 01a1898c-69e9-71de-99fa-d52ba2623323 | €15.00 | €0.26 | matched |
| 54 | refund | 01a1898c-6efa-7e52-a4fb-61c02ff18592 | -€5.00 | €0.00 | matched |
| 55 | capture | 01a1898c-770d-7ef6-8251-c17ec750fa00 | €9.00 | €0.19 | matched |
| 56 | capture | 01a1898c-8989-70ff-b6ad-cc3a4288e6be | €9.00 | €0.19 | matched |
| 57 | capture | 01a1898c-8bcd-7fe7-a80d-a5921ba26a12 | €9.00 | €0.19 | matched |
| 58 | capture | 01a1898c-9062-77ab-82a2-a51d990f38df | €35.00 | €0.50 | matched |
| 59 | capture | 01a1898c-aef8-76c0-b5ec-05957179e852 | €9.00 | €0.19 | matched |
| 60 | capture | 01a1898c-b075-7a42-987a-a8e75c5223d5 | €15.00 | €0.26 | matched |
| 61 | capture | 01a1898c-bf5a-726d-9170-efc908afe6ce | €49.00 | €0.67 | matched |
| 62 | capture | 01a1898c-e671-776a-bfd3-f4aa6532156f | €49.00 | €0.67 | matched |
| 63 | capture | 01a1898c-ec97-7f78-ae48-74935d8cd62a | €15.00 | €0.26 | matched |
| 64 | capture | 01a1898c-f3b2-79e7-9103-aac88b6985b5 | €15.00 | €0.26 | matched |
| 65 | refund | 01a1898c-fc2b-7ee4-b762-6cbb5acf2941 | -€14.00 | €0.00 | matched |
| 67 | capture | 01a1898d-04e8-7dde-b0b6-268258d599a6 | €24.00 | €0.37 | matched |
| 68 | capture | 01a1898d-17da-7606-b871-a676d2eb1f29 | €24.00 | €0.37 | matched |
| 69 | capture | 01a1898d-3912-7b41-9895-907294da3925 | €24.00 | €0.37 | matched |
| 70 | capture | 01a1898d-6610-7be9-831f-da3c36654c16 | €15.00 | €0.26 | matched |
| 71 | capture | 01a1898d-66b2-70a3-98d3-6c951ec01263 | €49.00 | €0.67 | matched |
| 72 | capture | 01a1898d-67aa-7b8e-9680-d5b148bf37a9 | €35.00 | €0.50 | matched |
| 73 | capture | 01a1898d-75b8-70c0-9408-4b7af05683bb | €49.00 | €0.67 | matched |
| 74 | refund | 01a1898d-77b9-772d-a760-1ba01f1c951a | -€10.00 | €0.00 | matched |
| 75 | capture | 01a1898d-86a7-7504-b16c-4d04449bf570 | €24.00 | €0.37 | matched |
| 76 | capture | 01a1898d-9b69-7663-9a04-909fa5a63eed | €15.00 | €0.26 | matched |
| 77 | capture | 01a1898d-b702-7240-b504-70397a30d2f5 | €9.00 | €0.19 | matched |
| 78 | capture | 01a1898d-bf84-7d16-86f3-9b05fc79736c | €24.00 | €0.37 | matched |
| 79 | capture | 01a1898d-c5c2-72a2-88a0-c25687dc1bf6 | €15.00 | €0.26 | matched |
| 80 | capture | 01a1898e-0d38-7d75-bbf6-dc47e4ffe5bc | €49.00 | €0.67 | matched |
| 81 | capture | 01a1898e-200e-7d0e-bb10-bbe0b8ce6d21 | €24.00 | €0.37 | matched |
| 82 | capture | 01a1898e-5076-7704-a9c2-65ae45ce1488 | €15.00 | €0.26 | matched |
| 83 | capture | 01a1898e-9c59-7959-b6a6-53092cbc21be | €49.00 | €0.67 | matched |
| 84 | capture | 01a1898e-b9df-7d71-aa9b-4dd795799b55 | €24.00 | €0.37 | matched |
| 85 | capture | 01a1898f-1252-781a-b934-39fe2f9ed16c | €35.00 | €0.50 | matched |
| 86 | capture | 01a1898f-202c-716e-8218-77cc0ac35b9e | €49.00 | €0.67 | matched |
| 87 | capture | 01a1898f-2bd3-72da-a69b-f847f709bbd8 | €9.00 | €0.19 | matched |
| 88 | capture | 01a1898f-34bb-70fa-9d74-f4feb38399f5 | €24.00 | €0.37 | matched |
| 89 | capture | 01a1898f-3ac4-739f-a9bf-adde54c745d5 | €49.00 | €0.67 | matched |
| 90 | capture | 01a1898f-4e64-7094-add5-1232907063ab | €15.00 | €0.26 | matched |
| 91 | capture | 01a1898f-4e63-78bc-aa58-ee47cee643d3 | €15.00 | €0.26 | matched |
| 92 | capture | 01a1898f-62af-7298-b6aa-4797b1e6b813 | €9.00 | €0.19 | matched |
| 93 | refund | 01a1898f-6385-7e0e-8de3-155329f2302d | -€21.00 | €0.00 | matched |
| 94 | capture | 01a1898f-779a-7f74-958b-3b0339c41d2a | €15.00 | €0.26 | matched |
| 95 | capture | 01a1898f-78f0-70cd-a5d3-ae665280ce12 | €15.00 | €0.26 | matched |
| 96 | capture | 01a1898f-ce79-7c14-b916-e0d4f88a2696 | €9.00 | €0.19 | matched |
| 97 | capture | 01a1898f-d1b8-77ea-9414-97e6f738bb4a | €9.00 | €0.19 | matched |
| 98 | refund | 01a18990-3276-7b27-b7ee-7fb113eef445 | -€15.00 | €0.00 | matched |
| 99 | capture | 01a18990-33c4-7f40-9d2a-4e7671ac4009 | €35.00 | €0.50 | matched |
| 100 | capture | 01a18990-56db-7492-8ac4-190d56d2ec12 | €49.00 | €0.67 | matched |
| 101 | capture | 01a18990-6b13-7453-936e-092977c996f2 | €35.00 | €0.50 | matched |
| 102 | capture | 01a18990-7262-72a4-857a-4441a00255b5 | €15.00 | €0.26 | matched |
| 103 | capture | 01a18990-7f9e-7e3f-a830-deeb4314131f | €9.00 | €0.19 | matched |
| 104 | capture | 01a18990-bcdb-7dca-b80b-d81de33935cf | €35.00 | €0.50 | matched |
| 105 | capture | 01a18990-c350-72d4-9e6e-05bbf84e6117 | €49.00 | €0.67 | matched |
| 106 | capture | 01a18990-c450-7256-8b41-a0952783ae83 | €9.00 | €0.19 | matched |
| 107 | capture | 01a18990-d616-779e-a1bc-89bba8205ee9 | €49.00 | €0.67 | matched |
| 108 | capture | 01a18990-d768-7717-ad01-ddd6bd1f576a | €15.00 | €0.26 | matched |
| 109 | capture | 01a18990-d429-71f9-972f-069d4121d30b | €15.00 | €0.26 | matched |
| 110 | capture | 01a18991-40df-7889-ad37-abc772da5239 | €49.00 | €0.67 | matched |
| 111 | capture | 01a18991-6c22-7eb6-b25f-0e04f9022845 | €9.00 | €0.19 | matched |
| 112 | capture | 01a18991-81f1-75a6-bcf0-5e042ba33071 | €15.00 | €0.26 | matched |
| 113 | refund | 01a18991-9167-7ec9-9369-a60020da3772 | -€25.00 | €0.00 | matched |
| 114 | capture | 01a18991-d2fc-7128-a688-d0d7f3a57959 | €24.00 | €0.37 | matched |