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, 16:30118 lines2 breaks
- 30 Oct, 16:20133 lines1 break
- 30 Oct, 16:10127 lines1 break
- 30 Oct, 16:00124 lines2 breaks
- 30 Oct, 15:50124 lines3 breaks
- 30 Oct, 15:40111 lines1 break
- 30 Oct, 15:30126 linesclean
- 30 Oct, 15:20140 lines6 breaks
- 30 Oct, 15:10127 lines4 breaks
- 30 Oct, 15:00123 lines4 breaks
- 30 Oct, 14:50119 lines1 break
- 30 Oct, 14:40135 lines1 break
- 30 Oct, 14:30112 lines2 breaks
- 30 Oct, 14:20131 lines2 breaks
30 Oct, 15:50
Gross
€2,831.00
PSP fee
€45.52
Net to the bank
€2,785.48
Settlement journal
#290455
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18d83-8678-79b3-9a48-9ebc76417c7c is already settled by stl_EUR_2988959 line 39
- missing linein the books, not in the filecapture:01a18d84-0eee-7579-8083-f03b42407d95 is in no file
- missing linein the books, not in the filecapture:01a18d81-980f-7521-bf70-e85693241423 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 40 | capture | 01a18d83-86f9-7ed8-900e-baf720cb0f89 | €15.00 | €0.26 | duplicate line |
| 1 | capture | 01a18d7a-26c3-7ff0-90c5-26c58d4bb09e | €24.00 | €0.37 | matched |
| 2 | capture | 01a18d7b-35bd-7887-8a3c-6c79156954c0 | €15.00 | €0.26 | matched |
| 3 | capture | 01a18d7c-e5ba-7bd3-a44a-4c33e02b345d | €35.00 | €0.50 | matched |
| 4 | capture | 01a18d81-229f-71a9-9f14-b03fb60648da | €24.00 | €0.37 | matched |
| 5 | capture | 01a18d81-372b-7229-ad5d-d92a563dd285 | €9.00 | €0.19 | matched |
| 6 | capture | 01a18d81-68ef-724f-8195-0f21c02cf394 | €24.00 | €0.37 | matched |
| 7 | capture | 01a18d81-70a0-7bbb-927b-43c00c7a81ea | €15.00 | €0.26 | matched |
| 8 | capture | 01a18d81-7216-72ee-88f6-b9cbf189ce31 | €15.00 | €0.26 | matched |
| 9 | capture | 01a18d81-6f71-74e1-bc96-078661abe25f | €9.00 | €0.19 | matched |
| 10 | capture | 01a18d81-8cdd-7e4f-b907-8f50095bcaaf | €49.00 | €0.67 | matched |
| 11 | capture | 01a18d81-cac8-7623-9fff-2ace6d4e62d4 | €15.00 | €0.26 | matched |
| 12 | capture | 01a18d81-d267-766b-b8a1-f9ac98f16f47 | €49.00 | €0.67 | matched |
| 13 | capture | 01a18d81-df5f-7810-aa24-fc1806737e4e | €15.00 | €0.26 | matched |
| 14 | refund | 01a18d81-dd9c-7031-9c9b-c687231461e8 | -€31.00 | €0.00 | matched |
| 15 | capture | 01a18d82-0c5e-720b-9f50-3a685c94bc56 | €49.00 | €0.67 | matched |
| 16 | capture | 01a18d82-0d07-7872-b02f-51b884a457bf | €15.00 | €0.26 | matched |
| 17 | capture | 01a18d82-1814-7400-9b5a-0603c28063a6 | €24.00 | €0.37 | matched |
| 18 | capture | 01a18d82-1afa-74cd-bf2b-e0b042df8c57 | €9.00 | €0.19 | matched |
| 19 | capture | 01a18d82-3e74-7859-89fd-1696154b2cec | €35.00 | €0.50 | matched |
| 20 | capture | 01a18d82-61f7-78fd-8b26-2a04b08950b2 | €24.00 | €0.37 | matched |
| 21 | capture | 01a18d82-63e5-74bf-bac1-26b5e37c8b5a | €15.00 | €0.26 | matched |
| 22 | capture | 01a18d82-71c0-7daf-9f0d-3a174205206e | €15.00 | €0.26 | matched |
| 23 | capture | 01a18d82-7924-7a2b-aaa8-c62d1a18dbb9 | €24.00 | €0.37 | matched |
| 24 | refund | 01a18d82-8342-7a1c-83b5-1bb5bc5dc303 | -€2.00 | €0.00 | matched |
| 25 | capture | 01a18d82-8cd5-7586-a04d-f686b94da857 | €15.00 | €0.26 | matched |
| 26 | capture | 01a18d82-be28-783b-996c-2a87eb150651 | €49.00 | €0.67 | matched |
| 27 | capture | 01a18d82-c1ef-784c-b9df-1c2606260771 | €24.00 | €0.37 | matched |
| 28 | capture | 01a18d82-e992-778e-80e8-dd65edf68bdd | €15.00 | €0.26 | matched |
| 29 | capture | 01a18d82-fdbd-7b78-a89a-ce93b92c5b0d | €24.00 | €0.37 | matched |
| 30 | capture | 01a18d83-1acb-7ea5-a577-b89afc549e83 | €49.00 | €0.67 | matched |
| 31 | capture | 01a18d83-2017-7a34-a74f-b0d7761ff5c9 | €35.00 | €0.50 | matched |
| 32 | capture | 01a18d83-27b6-75fe-af26-482729720985 | €9.00 | €0.19 | matched |
| 33 | capture | 01a18d83-39d9-792c-92c1-f9fa70e51b43 | €15.00 | €0.26 | matched |
| 34 | capture | 01a18d83-3a32-7d5c-8c49-8c0430ddcf71 | €15.00 | €0.26 | matched |
| 35 | capture | 01a18d83-5ac3-7c39-99c2-0fbc672921e8 | €15.00 | €0.26 | matched |
| 36 | capture | 01a18d83-6c88-7c31-8edd-233722291fa2 | €24.00 | €0.37 | matched |
| 37 | capture | 01a18d83-85e1-74e2-994b-cbd007989dd1 | €49.00 | €0.67 | matched |
| 38 | capture | 01a18d83-8659-77e7-a6af-b57029472afb | €15.00 | €0.26 | matched |
| 39 | capture | 01a18d83-86f9-7ed8-900e-baf720cb0f89 | €15.00 | €0.26 | matched |
| 41 | capture | 01a18d83-98bb-7f5c-bea0-5153d991a33c | €49.00 | €0.67 | matched |
| 42 | capture | 01a18d83-b4a3-7f46-9593-04026215774a | €35.00 | €0.50 | matched |
| 43 | refund | 01a18d83-c1ec-753e-aba6-f97361ff1944 | -€13.00 | €0.00 | matched |
| 44 | capture | 01a18d83-cfa4-7896-9d24-4fe00db29406 | €35.00 | €0.50 | matched |
| 45 | capture | 01a18d83-ddd1-7639-97d0-c6cf808e10c5 | €9.00 | €0.19 | matched |
| 46 | capture | 01a18d83-e7bd-7596-8ccf-de4c774e69cf | €9.00 | €0.19 | matched |
| 47 | capture | 01a18d83-f083-7f25-a82f-4901e36c6642 | €24.00 | €0.37 | matched |
| 48 | capture | 01a18d84-00fa-7046-a81d-a98628d1289e | €35.00 | €0.50 | matched |
| 49 | capture | 01a18d84-0f60-74e3-b362-793025719639 | €9.00 | €0.19 | matched |
| 50 | capture | 01a18d84-1121-79aa-ad30-46328738da83 | €35.00 | €0.50 | matched |
| 51 | capture | 01a18d84-20cc-7446-9106-1f5932fdab0a | €15.00 | €0.26 | matched |
| 52 | capture | 01a18d84-216b-70c8-af3f-b500a5d5eeea | €49.00 | €0.67 | matched |
| 53 | capture | 01a18d84-3a4b-760a-9a3f-7a3dcfa0a242 | €49.00 | €0.67 | matched |
| 54 | capture | 01a18d84-3eac-79e8-b51f-f6b12ce79a31 | €49.00 | €0.67 | matched |
| 55 | refund | 01a18d84-5c0f-7439-af09-c34542637a8b | -€15.00 | €0.00 | matched |
| 56 | capture | 01a18d84-6525-7605-9d5c-0658782f08db | €24.00 | €0.37 | matched |
| 57 | refund | 01a18d84-7cbc-7b96-ac41-937e24d809e6 | -€37.00 | €0.00 | matched |
| 58 | capture | 01a18d84-ae2f-73d6-b0b5-5832242efc09 | €24.00 | €0.37 | matched |
| 59 | capture | 01a18d84-affc-739f-9413-8b85d0cd612b | €49.00 | €0.67 | matched |
| 60 | capture | 01a18d84-d8fe-77ca-9baf-03c1522e2b38 | €35.00 | €0.50 | matched |
| 61 | capture | 01a18d85-41da-731a-809c-7279d5aa7b44 | €24.00 | €0.37 | matched |
| 62 | capture | 01a18d85-53e1-749a-8bb0-ee02b2ea5aba | €24.00 | €0.37 | matched |
| 63 | capture | 01a18d85-7c1f-7113-a5bb-35d0397d113d | €49.00 | €0.67 | matched |
| 64 | capture | 01a18d85-88eb-7215-9240-ebad1eba79ab | €49.00 | €0.67 | matched |
| 65 | refund | 01a18d85-a431-7f2d-84c6-341666075769 | -€21.00 | €0.00 | matched |
| 66 | capture | 01a18d85-aca5-7b71-8c91-487321898a7b | €9.00 | €0.19 | matched |
| 67 | capture | 01a18d85-ad49-73aa-9fe3-f52d3d6a9c4f | €15.00 | €0.26 | matched |
| 68 | capture | 01a18d85-ad3f-7f5d-a991-211d8c072d28 | €35.00 | €0.50 | matched |
| 69 | capture | 01a18d85-c501-7cda-96e5-ebf018ec5c4c | €15.00 | €0.26 | matched |
| 70 | capture | 01a18d85-ce76-785a-9156-39cfb01b860b | €15.00 | €0.26 | matched |
| 71 | refund | 01a18d85-d039-713a-a7ec-4d1c3a3db40c | -€13.00 | €0.00 | matched |
| 72 | capture | 01a18d86-1ef4-71f3-b8f2-684f1170739f | €24.00 | €0.37 | matched |
| 73 | capture | 01a18d86-222a-7e3e-b7bd-c6de42019cfe | €49.00 | €0.67 | matched |
| 74 | capture | 01a18d86-299c-733f-8fc5-40af4682b63f | €49.00 | €0.67 | matched |
| 75 | capture | 01a18d86-296e-7cb2-a3e6-96705d1d0d7e | €49.00 | €0.67 | matched |
| 76 | capture | 01a18d86-4f4c-7bab-a8d7-cfef5fe6fd4b | €35.00 | €0.50 | matched |
| 77 | capture | 01a18d86-56f1-76ae-b103-95394100a39a | €9.00 | €0.19 | matched |
| 78 | capture | 01a18d86-5b4e-71a2-ab8b-fd17e8d67106 | €15.00 | €0.26 | matched |
| 79 | capture | 01a18d86-815c-7781-8a89-6728e6c290ee | €35.00 | €0.50 | matched |
| 80 | capture | 01a18d86-9d7b-7b54-8ed5-2145265bfc52 | €15.00 | €0.26 | matched |
| 81 | capture | 01a18d86-b3eb-703b-8752-1f12d8bbc975 | €35.00 | €0.50 | matched |
| 82 | capture | 01a18d86-cd90-7526-a059-d3942f412e0e | €9.00 | €0.19 | matched |
| 83 | capture | 01a18d86-dbc7-75eb-995b-c679e3219ee3 | €49.00 | €0.67 | matched |
| 84 | capture | 01a18d86-e31a-7793-b670-baae0cf3c86d | €35.00 | €0.50 | matched |
| 85 | capture | 01a18d87-23f6-755c-8488-9ecf301ab64f | €49.00 | €0.67 | matched |
| 86 | refund | 01a18d87-2d71-7972-a1c1-267775d2bd53 | -€44.00 | €0.00 | matched |
| 87 | capture | 01a18d87-34da-7a66-a411-ef4b0abc2c8f | €9.00 | €0.19 | matched |
| 88 | capture | 01a18d87-3696-7daa-9179-8b86a0202b5e | €9.00 | €0.19 | matched |
| 89 | capture | 01a18d87-4c05-77f3-80aa-3846e784eda5 | €15.00 | €0.26 | matched |
| 90 | capture | 01a18d87-5b6b-7feb-86a2-27d8da8f834a | €9.00 | €0.19 | matched |
| 91 | capture | 01a18d87-5c07-7d50-abbf-4e248dd640b0 | €35.00 | €0.50 | matched |
| 92 | capture | 01a18d87-8c82-7167-bcac-7ccc97a57549 | €49.00 | €0.67 | matched |
| 93 | refund | 01a18d87-989f-725e-975a-0e687a9b00d5 | -€7.00 | €0.00 | matched |
| 94 | capture | 01a18d87-c6e7-747e-8859-f6913fe4f888 | €24.00 | €0.37 | matched |
| 95 | capture | 01a18d87-e758-790c-b836-a00df6400cca | €35.00 | €0.50 | matched |
| 96 | capture | 01a18d88-03d7-7e82-b8cb-d102c8721f81 | €35.00 | €0.50 | matched |
| 97 | capture | 01a18d88-1510-7a63-b87f-aae0dc33ff1f | €15.00 | €0.26 | matched |
| 98 | capture | 01a18d88-1d63-7ee1-a49a-b0f9b552fd1f | €24.00 | €0.37 | matched |
| 99 | capture | 01a18d88-1cd4-7ce4-bfb4-d2db3e3abb53 | €9.00 | €0.19 | matched |
| 100 | capture | 01a18d88-25b3-7922-98dc-e216bcb169ef | €9.00 | €0.19 | matched |
| 101 | capture | 01a18d88-4a9d-77b1-a9e4-10f6ad84d886 | €35.00 | €0.50 | matched |
| 102 | capture | 01a18d88-6722-74ca-8857-0ac5db91b783 | €24.00 | €0.37 | matched |
| 103 | capture | 01a18d88-810b-7217-bb25-c5addaf08e8a | €24.00 | €0.37 | matched |
| 104 | capture | 01a18d88-82a8-7684-8d46-6dabf5cb675a | €15.00 | €0.26 | matched |
| 105 | capture | 01a18d88-99bc-70e1-8de9-4f6cd209c4a5 | €15.00 | €0.26 | matched |
| 106 | capture | 01a18d88-b7ce-7170-8976-460530a6ac36 | €49.00 | €0.67 | matched |
| 107 | capture | 01a18d88-b9f2-7b1c-886b-baaf515274e1 | €24.00 | €0.37 | matched |
| 108 | capture | 01a18d88-de49-7553-972e-7f274ced152e | €9.00 | €0.19 | matched |
| 109 | capture | 01a18d88-f061-7e5e-a601-4bcb07c14c47 | €49.00 | €0.67 | matched |
| 110 | capture | 01a18d89-101c-7571-a429-a51b8c0695cf | €35.00 | €0.50 | matched |
| 111 | capture | 01a18d89-1603-7839-ac2e-e2991904b162 | €15.00 | €0.26 | matched |
| 112 | capture | 01a18d89-331c-78c2-9b5b-605548f8df07 | €49.00 | €0.67 | matched |
| 113 | capture | 01a18d89-5cab-7c9a-9a47-35cde8f79278 | €49.00 | €0.67 | matched |
| 114 | refund | 01a18d89-61ca-74a3-8767-bf484e94d901 | -€9.00 | €0.00 | matched |
| 115 | capture | 01a18d89-7ca1-7e56-869f-790abad8fe1b | €24.00 | €0.37 | matched |
| 116 | capture | 01a18d89-80f8-788b-9325-d1c5a752d986 | €35.00 | €0.50 | matched |
| 117 | capture | 01a18d89-8c03-7584-b6c0-a4843d12a486 | €35.00 | €0.50 | matched |
| 118 | capture | 01a18d89-8d1c-7a56-b95f-5840640c5827 | €15.00 | €0.26 | matched |
| 119 | capture | 01a18d89-9313-7087-8923-db855fbdbc18 | €15.00 | €0.26 | matched |
| 120 | capture | 01a18d89-c9e4-7efc-bccb-b7a8bb525672 | €15.00 | €0.26 | matched |
| 121 | capture | 01a18d89-cba7-7905-ad80-bdaf974df8c8 | €24.00 | €0.37 | matched |
| 122 | capture | 01a18d89-f87c-79a5-86ad-5fc5afe25b10 | €24.00 | €0.37 | matched |
| 123 | capture | 01a18d89-fb2a-784d-bde3-060a2d662dbb | €35.00 | €0.50 | matched |
| 124 | capture | 01a18d89-fb67-759e-bc7a-35925bd5631c | €15.00 | €0.26 | matched |