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
- 30 Oct, 10:30140 lines3 breaks
- 30 Oct, 10:20117 lines2 breaks
- 30 Oct, 10:10115 lines2 breaks
- 30 Oct, 10:00120 lines1 break
- 30 Oct, 09:50112 lines2 breaks
- 30 Oct, 09:40119 lines2 breaks
- 30 Oct, 09:30139 lines3 breaks
- 30 Oct, 09:20144 linesclean
- 30 Oct, 09:10118 lines5 breaks
- 30 Oct, 09:00116 lines1 break
- 30 Oct, 08:50153 lines3 breaks
- 30 Oct, 08:40136 lines2 breaks
- 30 Oct, 08:30102 lines4 breaks
- 30 Oct, 08:20136 lines2 breaks
30 Oct, 09:30
Gross
€3,329.00
PSP fee
€51.53
Net to the bank
€3,277.47
Settlement journal
#285692
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18c28-c804-75ba-8cbb-259981136c87 is already settled by stl_EUR_2988921 line 54
- missing linein the books, not in the filecapture:01a18c25-224c-73e7-ac46-6bc277c97d43 is in no file
- missing linein the books, not in the filecapture:01a18c27-7ee6-701e-a852-314147ec6060 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 55 | capture | 01a18c28-cb63-7e73-bed5-9b651c8e1ddd | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a18c21-ab47-73b5-a087-7a156e6ed439 | €49.00 | €0.67 | matched |
| 2 | capture | 01a18c25-0ed3-7548-8e4e-cd546098b61e | €49.00 | €0.67 | matched |
| 3 | capture | 01a18c25-1779-77a4-a877-80ba10284956 | €15.00 | €0.26 | matched |
| 4 | capture | 01a18c25-1bad-79d1-b0b5-5f84f6083e02 | €9.00 | €0.19 | matched |
| 5 | refund | 01a18c25-3240-7dc2-a7e3-308073e03741 | -€16.00 | €0.00 | matched |
| 6 | capture | 01a18c25-3e77-7d07-ade5-20f33239c0e4 | €35.00 | €0.50 | matched |
| 7 | capture | 01a18c25-555c-71ab-9b71-0f2c250a3a1e | €15.00 | €0.26 | matched |
| 8 | capture | 01a18c25-5d99-72b8-a8f0-15cb803a3a7d | €15.00 | €0.26 | matched |
| 9 | capture | 01a18c25-6637-78b1-a5dc-72643c361709 | €24.00 | €0.37 | matched |
| 10 | capture | 01a18c25-6ad0-74be-af64-aeb43e752339 | €15.00 | €0.26 | matched |
| 11 | capture | 01a18c25-dcf3-76ed-b752-db192458d3ff | €35.00 | €0.50 | matched |
| 12 | capture | 01a18c26-097f-7355-b828-53c950589a19 | €15.00 | €0.26 | matched |
| 13 | capture | 01a18c26-1548-7651-91b9-95d5c25b32d0 | €24.00 | €0.37 | matched |
| 14 | capture | 01a18c26-25b0-7bf6-adb0-38d11f43bcb8 | €15.00 | €0.26 | matched |
| 15 | capture | 01a18c26-2614-7f73-8659-9ad940d8ceb1 | €15.00 | €0.26 | matched |
| 16 | capture | 01a18c26-349f-789d-9482-1e94a5994291 | €9.00 | €0.19 | matched |
| 17 | capture | 01a18c26-6ae7-7ed2-a6fa-cd78cae862fd | €49.00 | €0.67 | matched |
| 18 | capture | 01a18c26-73e9-74df-b09b-ecc5d8854cf7 | €15.00 | €0.26 | matched |
| 19 | capture | 01a18c26-7c02-7caa-9516-58b0b1de1db3 | €49.00 | €0.67 | matched |
| 20 | capture | 01a18c26-7a39-739c-b0b1-f2dd14ccdddc | €35.00 | €0.50 | matched |
| 21 | refund | 01a18c26-80b3-70e0-a13a-5434ec94ca02 | -€9.00 | €0.00 | matched |
| 22 | refund | 01a18c26-82d5-7540-929d-5425ef4cd532 | -€8.00 | €0.00 | matched |
| 23 | capture | 01a18c26-86cf-7fa0-8ce5-9c43a309f62e | €35.00 | €0.50 | matched |
| 24 | capture | 01a18c26-9f22-7df5-864f-7f4b64755e5f | €24.00 | €0.37 | matched |
| 25 | capture | 01a18c26-c3e5-7f3f-be85-218bc26afecc | €35.00 | €0.50 | matched |
| 26 | capture | 01a18c26-cdee-7fab-bcf5-188836e67691 | €24.00 | €0.37 | matched |
| 27 | capture | 01a18c26-d1c2-7891-b287-a791c6642883 | €35.00 | €0.50 | matched |
| 28 | capture | 01a18c26-f0c4-7db4-b76e-49b99d104f94 | €35.00 | €0.50 | matched |
| 29 | capture | 01a18c26-f47c-7a12-a023-12a12cec39c8 | €9.00 | €0.19 | matched |
| 30 | capture | 01a18c27-0a6e-7474-b064-4d63208bccbd | €24.00 | €0.37 | matched |
| 31 | capture | 01a18c27-1366-7ecf-992a-862e8c6e32d8 | €49.00 | €0.67 | matched |
| 32 | capture | 01a18c27-1880-703e-a870-79c18e09f655 | €49.00 | €0.67 | matched |
| 33 | capture | 01a18c27-2a10-750d-bde5-6b9edfb7bc67 | €49.00 | €0.67 | matched |
| 34 | capture | 01a18c27-3402-7104-abaa-bcf55effbf1c | €24.00 | €0.37 | matched |
| 35 | capture | 01a18c27-3e83-7f45-b855-05b89a6e50e1 | €9.00 | €0.19 | matched |
| 36 | capture | 01a18c27-3ea1-750f-8e7c-cd53904a686e | €24.00 | €0.37 | matched |
| 37 | capture | 01a18c27-7327-74bd-9eb5-0cab1508eb5c | €49.00 | €0.67 | matched |
| 38 | capture | 01a18c27-a3d3-7cd3-9b11-c2d5456d6f34 | €9.00 | €0.19 | matched |
| 39 | capture | 01a18c27-aef6-73fa-a674-22eb5bb32740 | €15.00 | €0.26 | matched |
| 40 | capture | 01a18c27-b471-738a-954b-4d0a31e97d78 | €49.00 | €0.67 | matched |
| 41 | capture | 01a18c27-be9d-7853-a9a1-756c7199fdcb | €24.00 | €0.37 | matched |
| 42 | capture | 01a18c27-c29a-7028-b681-45dfe4166a66 | €24.00 | €0.37 | matched |
| 43 | capture | 01a18c27-c7e3-7d36-8005-1da045870d83 | €35.00 | €0.50 | matched |
| 44 | capture | 01a18c27-dc83-7538-85c2-6338b32a1de7 | €9.00 | €0.19 | matched |
| 45 | capture | 01a18c28-3085-7185-a3bc-d92acba21097 | €49.00 | €0.67 | matched |
| 46 | capture | 01a18c28-4b32-79e2-8bc0-47cf15128c08 | €9.00 | €0.19 | matched |
| 47 | capture | 01a18c28-5085-7c8a-83d0-1133912dc70a | €9.00 | €0.19 | matched |
| 48 | capture | 01a18c28-5b89-7ef6-ae1e-249c18252671 | €24.00 | €0.37 | matched |
| 49 | capture | 01a18c28-5da2-7d8a-841d-96340fe725dd | €15.00 | €0.26 | matched |
| 50 | capture | 01a18c28-5fa6-7fac-8c3a-4cf6ac5a413d | €35.00 | €0.50 | matched |
| 51 | capture | 01a18c28-9d06-7826-8980-354882010aea | €49.00 | €0.67 | matched |
| 52 | capture | 01a18c28-a505-70ea-8c89-443cd4109ea8 | €49.00 | €0.67 | matched |
| 53 | capture | 01a18c28-a550-7fc2-96c9-5aec2747de2e | €49.00 | €0.67 | matched |
| 54 | capture | 01a18c28-cb63-7e73-bed5-9b651c8e1ddd | €49.00 | €0.67 | matched |
| 56 | refund | 01a18c28-d0a2-7038-acf7-4211b5ee6237 | -€5.00 | €0.00 | matched |
| 57 | capture | 01a18c28-e34b-7065-8370-b5cf64577a7f | €49.00 | €0.67 | matched |
| 58 | capture | 01a18c28-e3de-79a5-b024-c24f2e9b054d | €35.00 | €0.50 | matched |
| 59 | capture | 01a18c28-ffc1-7dd5-ad75-5f49c4b36b47 | €9.00 | €0.19 | matched |
| 60 | capture | 01a18c29-0c37-7228-a19f-1e19c9fced5c | €15.00 | €0.26 | matched |
| 61 | capture | 01a18c29-1310-770b-a5fe-e31069b35b62 | €35.00 | €0.50 | matched |
| 62 | capture | 01a18c29-1726-74f2-be9d-43d35674e32c | €9.00 | €0.19 | matched |
| 63 | capture | 01a18c29-1b77-771d-833d-0fc696c63199 | €9.00 | €0.19 | matched |
| 64 | capture | 01a18c29-3a92-72c0-b9ee-1131e19e7548 | €24.00 | €0.37 | matched |
| 65 | capture | 01a18c29-4e43-7199-a2e3-a23da8bc9762 | €15.00 | €0.26 | matched |
| 66 | refund | 01a18c29-5512-7ea2-9ebe-7decd8d17cdd | -€5.00 | €0.00 | matched |
| 67 | capture | 01a18c29-68cc-759a-b136-70486f265aaf | €15.00 | €0.26 | matched |
| 68 | capture | 01a18c29-776d-706e-affe-f5775e21a57b | €15.00 | €0.26 | matched |
| 69 | capture | 01a18c29-83f8-7500-82f5-e67b24957733 | €15.00 | €0.26 | matched |
| 70 | capture | 01a18c29-844a-77d9-bff8-29245bee4d0e | €24.00 | €0.37 | matched |
| 71 | capture | 01a18c29-8d76-72ff-80d2-9178b96c128f | €35.00 | €0.50 | matched |
| 72 | capture | 01a18c29-a708-70d1-a69e-24afff1bda1f | €35.00 | €0.50 | matched |
| 73 | capture | 01a18c29-ab7d-7f8a-8ae4-2ef315d9da85 | €9.00 | €0.19 | matched |
| 74 | capture | 01a18c29-cec7-7182-94ff-d2f8959fb430 | €35.00 | €0.50 | matched |
| 75 | refund | 01a18c29-e228-7587-ae3c-f708cc9da166 | -€13.00 | €0.00 | matched |
| 76 | capture | 01a18c29-ef7b-729c-a4d7-7f7d92f33761 | €15.00 | €0.26 | matched |
| 77 | capture | 01a18c29-f2a2-7d26-a607-d294f8a2901f | €15.00 | €0.26 | matched |
| 78 | capture | 01a18c2a-08f9-7262-ac11-b9a3d0122ff9 | €9.00 | €0.19 | matched |
| 79 | capture | 01a18c2a-0d10-7973-8b90-f46b79e2e343 | €49.00 | €0.67 | matched |
| 80 | capture | 01a18c2a-2afa-715b-ac7d-4f73dfa3aa9f | €9.00 | €0.19 | matched |
| 81 | capture | 01a18c2a-3dec-7f4a-a2a3-61ddbb290a83 | €15.00 | €0.26 | matched |
| 82 | capture | 01a18c2a-41b1-7a3d-a933-4268170b3747 | €15.00 | €0.26 | matched |
| 83 | refund | 01a18c2a-4a88-72af-b765-4255c3e768dd | -€11.00 | €0.00 | matched |
| 84 | capture | 01a18c2a-5df9-7de2-a6bf-b9cf89a79867 | €49.00 | €0.67 | matched |
| 85 | capture | 01a18c2a-5b82-7c9e-a6c0-2735693939b4 | €49.00 | €0.67 | matched |
| 86 | capture | 01a18c2a-7b03-7e08-8c7b-343c3b520884 | €9.00 | €0.19 | matched |
| 87 | refund | 01a18c2a-83d0-7bda-a08d-60960f12a088 | -€4.00 | €0.00 | matched |
| 88 | capture | 01a18c2a-969b-712a-83c2-5ac285e002da | €35.00 | €0.50 | matched |
| 89 | capture | 01a18c2a-97e7-7788-9fea-9239aad4cce9 | €35.00 | €0.50 | matched |
| 90 | capture | 01a18c2a-c39f-7e61-a890-3b8e1d90cf9d | €35.00 | €0.50 | matched |
| 91 | capture | 01a18c2a-d4e7-79dc-a6bd-37167f4e9810 | €24.00 | €0.37 | matched |
| 92 | capture | 01a18c2a-de9f-7b97-bd20-dc7b5adc9d03 | €15.00 | €0.26 | matched |
| 93 | capture | 01a18c2a-efb1-701a-b8c3-2e0f2a3fa490 | €9.00 | €0.19 | matched |
| 94 | capture | 01a18c2b-0030-73bc-959e-314f45b16514 | €24.00 | €0.37 | matched |
| 95 | capture | 01a18c2b-1653-75d8-a4f1-c916ae0d0b2e | €9.00 | €0.19 | matched |
| 96 | capture | 01a18c2b-5c01-7114-abcd-644c32dcf3e0 | €35.00 | €0.50 | matched |
| 97 | capture | 01a18c2b-763e-7773-a9a5-b4beb82f8682 | €24.00 | €0.37 | matched |
| 98 | capture | 01a18c2b-79e7-79ed-bc34-2199d98c25b1 | €9.00 | €0.19 | matched |
| 99 | capture | 01a18c2b-84a0-7c04-82c5-0f0758560a75 | €49.00 | €0.67 | matched |
| 100 | capture | 01a18c2b-8ebe-72b0-aae3-a3b0e9aa6f77 | €49.00 | €0.67 | matched |
| 101 | capture | 01a18c2b-90ce-734c-b581-464a9d56c6f0 | €49.00 | €0.67 | matched |
| 102 | capture | 01a18c2b-92de-7c5f-8525-9dca1921a3c1 | €35.00 | €0.50 | matched |
| 103 | capture | 01a18c2b-aa22-7057-b883-b7a0054121f4 | €9.00 | €0.19 | matched |
| 104 | capture | 01a18c2b-c25d-754e-811f-77ad5d392ff8 | €9.00 | €0.19 | matched |
| 105 | capture | 01a18c2b-d5a2-7fd1-8144-c662e83c84c5 | €35.00 | €0.50 | matched |
| 106 | capture | 01a18c2b-d889-72d4-a650-58e36f429399 | €9.00 | €0.19 | matched |
| 107 | capture | 01a18c2b-e5e5-7d35-af58-ec69f59c54bd | €9.00 | €0.19 | matched |
| 108 | capture | 01a18c2b-e7fb-770e-8bee-a8362bfa8de0 | €35.00 | €0.50 | matched |
| 109 | capture | 01a18c2b-f8eb-7285-8e63-68b373f1a338 | €35.00 | €0.50 | matched |
| 110 | capture | 01a18c2c-0148-74c2-988d-eaaa08f5f0d0 | €24.00 | €0.37 | matched |
| 111 | capture | 01a18c2c-01f6-76b3-b058-1141fb551bce | €35.00 | €0.50 | matched |
| 112 | refund | 01a18c2c-3aaa-7268-a8f0-87e63943094f | -€20.00 | €0.00 | matched |
| 113 | capture | 01a18c2c-45a8-7255-a7ef-14d49344b397 | €9.00 | €0.19 | matched |
| 114 | capture | 01a18c2c-4672-793d-b0ed-8377ea61a9eb | €15.00 | €0.26 | matched |
| 115 | capture | 01a18c2c-47e7-7eee-b9f2-d29327e29f70 | €9.00 | €0.19 | matched |
| 116 | capture | 01a18c2c-556f-71fd-9ee2-bc2ab2ee8907 | €15.00 | €0.26 | matched |
| 117 | capture | 01a18c2c-57c1-7520-b1d2-8a4d14f58cb7 | €15.00 | €0.26 | matched |
| 118 | capture | 01a18c2c-59f9-71bb-95b4-47c248bc1cd2 | €49.00 | €0.67 | matched |
| 119 | capture | 01a18c2c-6e96-7c16-9904-29961a779775 | €15.00 | €0.26 | matched |
| 120 | capture | 01a18c2c-71ba-7b75-b6c2-055104179d87 | €35.00 | €0.50 | matched |
| 121 | capture | 01a18c2c-7ef7-71c9-b27a-ecf3af69a406 | €15.00 | €0.26 | matched |
| 122 | capture | 01a18c2c-afee-756e-8d1e-340b45ced9de | €49.00 | €0.67 | matched |
| 123 | capture | 01a18c2c-d4b6-7cb2-bbbb-656e5a4d5b48 | €49.00 | €0.67 | matched |
| 124 | capture | 01a18c2d-1674-7018-95d5-b67de583230b | €35.00 | €0.50 | matched |
| 125 | capture | 01a18c2d-252e-75a2-9ef0-70d7d0e0a7c0 | €35.00 | €0.50 | matched |
| 126 | capture | 01a18c2d-3465-72db-95f4-f7c6cdff374c | €15.00 | €0.26 | matched |
| 127 | capture | 01a18c2d-6100-7e88-a1a9-889c833c3965 | €24.00 | €0.37 | matched |
| 128 | capture | 01a18c2d-94f8-76f2-a65a-af29ee38349b | €24.00 | €0.37 | matched |
| 129 | capture | 01a18c2d-9654-75ed-8315-0e91197e2e59 | €49.00 | €0.67 | matched |
| 130 | capture | 01a18c2d-a1b9-7490-85ff-8c21e1844e1b | €9.00 | €0.19 | matched |
| 131 | capture | 01a18c2d-b8f3-7f74-a7db-9144ee490387 | €15.00 | €0.26 | matched |
| 132 | capture | 01a18c2d-cb24-71b5-a365-8ab286c9a37c | €24.00 | €0.37 | matched |
| 133 | capture | 01a18c2d-ce2c-793d-ae53-b5090d1987fe | €9.00 | €0.19 | matched |
| 134 | capture | 01a18c2d-d3bc-753c-adcd-7fa59ae77169 | €9.00 | €0.19 | matched |
| 135 | capture | 01a18c2d-dfb9-7f7b-9e60-112ebbe4c0f0 | €35.00 | €0.50 | matched |
| 136 | refund | 01a18c2d-ebc0-7a36-a7cf-4d96d29fa9dc | -€2.00 | €0.00 | matched |
| 137 | capture | 01a18c2e-06f3-7279-adb7-fe4872d40b16 | €15.00 | €0.26 | matched |
| 138 | capture | 01a18c2e-0bd6-7f9a-869e-7e6f496eed17 | €35.00 | €0.50 | matched |
| 139 | capture | 01a18c2e-0e17-762e-a3cc-5ecfc1b297cd | €49.00 | €0.67 | matched |