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
- 5 Nov, 14:50134 lines4 breaks
- 5 Nov, 14:40125 lines2 breaks
- 5 Nov, 14:30121 lines3 breaks
- 5 Nov, 14:20118 lines3 breaks
- 5 Nov, 14:10113 lines4 breaks
- 5 Nov, 14:00138 lines2 breaks
- 5 Nov, 13:50122 lines2 breaks
- 5 Nov, 13:40114 lines2 breaks
- 5 Nov, 13:30141 lines1 break
- 5 Nov, 13:20134 lines3 breaks
- 5 Nov, 13:10145 lines3 breaks
- 5 Nov, 13:00126 lines1 break
- 5 Nov, 12:50111 lines4 breaks
- 5 Nov, 12:40133 lines1 break
5 Nov, 14:00
Gross
€3,022.00
PSP fee
€48.49
Net to the bank
€2,973.51
Settlement journal
#398807
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1ac0a-6598-747e-92fa-491448b291ae is already settled by stl_EUR_2989812 line 118
- missing linein the books, not in the filecapture:01a1ac0a-5a66-7ffc-8ee6-ad192bcb3c29 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 119 | capture | 01a1ac0a-65cf-7fe0-8273-67915689b494 | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a1abfb-ff8a-7049-b5df-bb052c19e559 | €49.00 | €0.67 | matched |
| 2 | capture | 01a1ac02-abc6-7f78-84ee-7ed2cbab3b30 | €49.00 | €0.67 | matched |
| 3 | capture | 01a1ac02-ac1f-7e5b-bbb5-3961cb63dc2c | €35.00 | €0.50 | matched |
| 4 | capture | 01a1ac02-c880-762b-8896-0f3e084ee641 | €49.00 | €0.67 | matched |
| 5 | capture | 01a1ac02-e7f4-74b6-b025-ee04990be997 | €24.00 | €0.37 | matched |
| 6 | capture | 01a1ac02-eca8-7845-af45-98e96043b716 | €9.00 | €0.19 | matched |
| 7 | capture | 01a1ac02-eb84-7148-9675-e703445e9967 | €15.00 | €0.26 | matched |
| 8 | capture | 01a1ac02-f9da-78b7-b160-979cc3d78c4c | €35.00 | €0.50 | matched |
| 9 | capture | 01a1ac03-0a7f-77a6-92c7-b92e6238f7be | €35.00 | €0.50 | matched |
| 10 | refund | 01a1ac03-3e3f-7e89-8489-26e227e0a3cf | -€14.00 | €0.00 | matched |
| 11 | capture | 01a1ac03-6618-78d8-a0cf-4cbda9811b23 | €9.00 | €0.19 | matched |
| 12 | capture | 01a1ac03-6efd-7fe4-9550-3eaea0ba9a38 | €49.00 | €0.67 | matched |
| 13 | capture | 01a1ac03-7707-7530-8c74-edcc23f6eb76 | €35.00 | €0.50 | matched |
| 14 | capture | 01a1ac03-7b25-76bf-b3cb-e821e954bdfc | €9.00 | €0.19 | matched |
| 15 | capture | 01a1ac03-afc4-7d84-8473-6c49e1d8c57a | €49.00 | €0.67 | matched |
| 16 | capture | 01a1ac03-b589-762d-9d8d-19e58218dda4 | €15.00 | €0.26 | matched |
| 17 | capture | 01a1ac03-d153-7c8c-8fb9-053f0179c862 | €15.00 | €0.26 | matched |
| 18 | capture | 01a1ac03-dc13-7f20-b184-f8a7395cbd85 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1ac03-f5d2-7e11-8372-234281230151 | €49.00 | €0.67 | matched |
| 20 | refund | 01a1ac03-f8e8-7852-981f-a2471c7fa0a7 | -€43.00 | €0.00 | matched |
| 21 | capture | 01a1ac04-0333-7389-9db9-b788ffe9be69 | €9.00 | €0.19 | matched |
| 22 | refund | 01a1ac04-05a1-76dd-87c1-fac54de3aa9f | -€5.00 | €0.00 | matched |
| 23 | capture | 01a1ac04-08ca-72a3-a092-522c183b42ce | €49.00 | €0.67 | matched |
| 24 | capture | 01a1ac04-1966-7de5-9268-97324adb083e | €24.00 | €0.37 | matched |
| 25 | capture | 01a1ac04-3301-7b9d-97d8-6da8bb8402ae | €9.00 | €0.19 | matched |
| 26 | capture | 01a1ac04-44dc-70c8-b1f9-7a835bfec872 | €24.00 | €0.37 | matched |
| 27 | capture | 01a1ac04-7351-75ec-84cd-3c523dfb912b | €9.00 | €0.19 | matched |
| 28 | capture | 01a1ac04-833f-7cda-9e5d-c3ee5a336896 | €24.00 | €0.37 | matched |
| 29 | capture | 01a1ac04-8c35-7def-9ee7-e72e66d5df53 | €35.00 | €0.50 | matched |
| 30 | capture | 01a1ac04-9902-7dc7-8f72-7808d6eb4643 | €15.00 | €0.26 | matched |
| 31 | capture | 01a1ac04-be8a-7f84-a41f-3104bc59b1e1 | €49.00 | €0.67 | matched |
| 32 | capture | 01a1ac04-cd50-76ad-8822-b081528d7799 | €15.00 | €0.26 | matched |
| 33 | capture | 01a1ac04-cf55-7d55-b76a-798779b28a94 | €15.00 | €0.26 | matched |
| 34 | refund | 01a1ac05-00dd-7f9a-82fc-16ab0c9b14fe | -€35.00 | €0.00 | matched |
| 35 | refund | 01a1ac05-2096-7774-ab26-b26b6bb9579b | -€9.00 | €0.00 | matched |
| 36 | capture | 01a1ac05-3000-78a5-8927-b5ffccae46d5 | €9.00 | €0.19 | matched |
| 37 | capture | 01a1ac05-45c0-78de-9d4d-171f5e2c3f01 | €24.00 | €0.37 | matched |
| 38 | capture | 01a1ac05-5419-7ccc-a705-8b86a288db6e | €24.00 | €0.37 | matched |
| 39 | capture | 01a1ac05-592d-79ee-b162-1f71e0ce6931 | €15.00 | €0.26 | matched |
| 40 | capture | 01a1ac05-84d2-77d7-9181-0de35e5473e6 | €35.00 | €0.50 | matched |
| 41 | capture | 01a1ac05-a9ee-774c-abe0-a9f751db60af | €15.00 | €0.26 | matched |
| 42 | capture | 01a1ac05-b0e2-75ea-a6c7-ba80d9cc755c | €24.00 | €0.37 | matched |
| 43 | capture | 01a1ac05-b2ab-78f0-befd-51219af8fdf3 | €9.00 | €0.19 | matched |
| 44 | capture | 01a1ac05-c06f-78d0-8da6-64380fb80484 | €15.00 | €0.26 | matched |
| 45 | capture | 01a1ac05-d2a7-7ccf-8c8d-61ba940db9ee | €9.00 | €0.19 | matched |
| 46 | capture | 01a1ac05-db5a-7711-a0bc-4c5aa557d01a | €9.00 | €0.19 | matched |
| 47 | capture | 01a1ac05-e1cc-7338-883e-fd5f7190b654 | €35.00 | €0.50 | matched |
| 48 | capture | 01a1ac05-e8b1-79f8-98be-3072405f0b7d | €9.00 | €0.19 | matched |
| 49 | capture | 01a1ac05-f087-7c9a-940b-d7e4182c9605 | €49.00 | €0.67 | matched |
| 50 | capture | 01a1ac05-f2d3-7a00-b389-2f814597988b | €24.00 | €0.37 | matched |
| 51 | refund | 01a1ac06-2049-7362-acb4-4576b110d774 | -€5.00 | €0.00 | matched |
| 52 | capture | 01a1ac06-35e8-79f4-b73a-0520c50874ee | €49.00 | €0.67 | matched |
| 53 | refund | 01a1ac06-45c0-766c-bf5e-d03af78b4814 | -€6.00 | €0.00 | matched |
| 54 | capture | 01a1ac06-5283-7d5d-962a-62ccb0c5bf78 | €9.00 | €0.19 | matched |
| 55 | capture | 01a1ac06-5dfb-7363-be19-31f48535d409 | €35.00 | €0.50 | matched |
| 56 | capture | 01a1ac06-72f8-70b1-bf15-eb4eee689559 | €15.00 | €0.26 | matched |
| 57 | capture | 01a1ac06-790e-7e83-a26f-8a8ff64d5f27 | €35.00 | €0.50 | matched |
| 58 | capture | 01a1ac06-8a33-77f7-b0e6-0dad5a620f58 | €9.00 | €0.19 | matched |
| 59 | capture | 01a1ac06-8ddc-72d2-9b8e-88e052094406 | €24.00 | €0.37 | matched |
| 60 | capture | 01a1ac06-9cd3-7fda-a031-5b99755a07b5 | €9.00 | €0.19 | matched |
| 61 | capture | 01a1ac06-aab6-75bc-87f9-110c5ebf862e | €24.00 | €0.37 | matched |
| 62 | capture | 01a1ac06-ea81-7669-a676-1b3edac3e2e7 | €9.00 | €0.19 | matched |
| 63 | capture | 01a1ac06-f6a0-7d29-ab64-54c2f3d6a43e | €35.00 | €0.50 | matched |
| 64 | capture | 01a1ac07-2ec1-7713-91eb-3df86fb91de4 | €49.00 | €0.67 | matched |
| 65 | capture | 01a1ac07-3fa7-7f36-80a7-6d4a2ff8b276 | €15.00 | €0.26 | matched |
| 66 | capture | 01a1ac07-42fb-78cc-a3b1-8012b5948d40 | €35.00 | €0.50 | matched |
| 67 | capture | 01a1ac07-7909-7d33-8b49-cc01d1767c1d | €24.00 | €0.37 | matched |
| 68 | capture | 01a1ac07-8720-7e92-a44a-40896e82b9aa | €35.00 | €0.50 | matched |
| 69 | capture | 01a1ac07-a11b-72ed-927e-61d07c928835 | €35.00 | €0.50 | matched |
| 70 | capture | 01a1ac07-ba77-7769-b0e5-6b810f46b481 | €15.00 | €0.26 | matched |
| 71 | capture | 01a1ac07-d823-7277-87b1-e3155cc71320 | €35.00 | €0.50 | matched |
| 72 | capture | 01a1ac07-ee9a-7e97-b8f6-f812fe1da780 | €9.00 | €0.19 | matched |
| 73 | refund | 01a1ac07-ee9d-76fa-b749-5ab860dde563 | -€11.00 | €0.00 | matched |
| 74 | capture | 01a1ac08-189f-738b-8e3e-622b0ee18660 | €9.00 | €0.19 | matched |
| 75 | capture | 01a1ac08-24eb-710d-b7bf-82d15bfcbbc4 | €9.00 | €0.19 | matched |
| 76 | capture | 01a1ac08-25e8-7886-9f93-de5e67cd37fa | €15.00 | €0.26 | matched |
| 77 | capture | 01a1ac08-32a0-73c7-bc26-78b0c9230569 | €49.00 | €0.67 | matched |
| 78 | capture | 01a1ac08-3587-7c7c-b516-24a84f8631de | €15.00 | €0.26 | matched |
| 79 | capture | 01a1ac08-461a-7675-b968-489459116376 | €9.00 | €0.19 | matched |
| 80 | capture | 01a1ac08-47fe-7104-b056-cb10f5a3d29e | €15.00 | €0.26 | matched |
| 81 | refund | 01a1ac08-48c2-769d-95df-787b0799b74b | -€3.00 | €0.00 | matched |
| 82 | capture | 01a1ac08-5d83-7821-8c93-5935db1d8a2b | €35.00 | €0.50 | matched |
| 83 | capture | 01a1ac08-6816-762c-9ed8-f0015ffd14e0 | €9.00 | €0.19 | matched |
| 84 | capture | 01a1ac08-7084-7dfd-9b17-24bf3120de1d | €15.00 | €0.26 | matched |
| 85 | capture | 01a1ac08-7c52-7351-83d0-f3d8aa5e78c1 | €49.00 | €0.67 | matched |
| 86 | capture | 01a1ac08-7cb9-73c3-b8f4-ee9beaeb892a | €15.00 | €0.26 | matched |
| 87 | capture | 01a1ac08-94bf-7a94-8c31-2cdcb6a611de | €24.00 | €0.37 | matched |
| 88 | capture | 01a1ac08-a7ac-749c-a18b-f059d408780f | €24.00 | €0.37 | matched |
| 89 | capture | 01a1ac08-af5b-7085-a8b8-ce99287059e0 | €49.00 | €0.67 | matched |
| 90 | capture | 01a1ac08-d6a1-7296-a13e-74f619c94802 | €9.00 | €0.19 | matched |
| 91 | capture | 01a1ac08-e6e0-7a2d-88da-b2a1c4d83a01 | €35.00 | €0.50 | matched |
| 92 | capture | 01a1ac08-ea3e-7a00-9a8a-92b8d0a80d1f | €24.00 | €0.37 | matched |
| 93 | capture | 01a1ac09-07f7-7e15-b219-f004dc9bf23d | €24.00 | €0.37 | matched |
| 94 | capture | 01a1ac09-1833-7e58-b363-a5f486bd7a1c | €9.00 | €0.19 | matched |
| 95 | capture | 01a1ac09-296a-79d6-a024-8c55da864f90 | €49.00 | €0.67 | matched |
| 96 | capture | 01a1ac09-2ea4-75e7-9531-931b03ae21bb | €35.00 | €0.50 | matched |
| 97 | capture | 01a1ac09-34e7-7ed0-976c-899ae7573645 | €35.00 | €0.50 | matched |
| 98 | capture | 01a1ac09-3c8f-735b-9acd-2c050ce78cb0 | €35.00 | €0.50 | matched |
| 99 | capture | 01a1ac09-48c0-7cc7-9799-a18bb88dadee | €35.00 | €0.50 | matched |
| 100 | capture | 01a1ac09-5c06-790a-8d77-bdc5c2f89ba4 | €49.00 | €0.67 | matched |
| 101 | capture | 01a1ac09-784e-7f45-8db6-6c8613c6da48 | €15.00 | €0.26 | matched |
| 102 | capture | 01a1ac09-7c6d-7e89-86c5-c267c591c4ff | €49.00 | €0.67 | matched |
| 103 | refund | 01a1ac09-7d50-7da0-add4-2ac9b22f06c2 | -€17.00 | €0.00 | matched |
| 104 | capture | 01a1ac09-805e-7e01-bec2-6ea4db3de8f2 | €24.00 | €0.37 | matched |
| 105 | capture | 01a1ac09-8750-7b7b-8fa5-acbcde84bb00 | €9.00 | €0.19 | matched |
| 106 | capture | 01a1ac09-926c-7dc1-9da8-5de8e6c186d8 | €49.00 | €0.67 | matched |
| 107 | capture | 01a1ac09-ae4f-72c8-9875-96c0b7ea3e88 | €9.00 | €0.19 | matched |
| 108 | capture | 01a1ac09-c0a9-71e6-9bf4-4ebef19d08a2 | €9.00 | €0.19 | matched |
| 109 | capture | 01a1ac09-eea4-7986-b433-93e26b2e258c | €9.00 | €0.19 | matched |
| 110 | capture | 01a1ac09-f0f5-7904-a46d-4eb88da5eb21 | €15.00 | €0.26 | matched |
| 111 | capture | 01a1ac09-f8e9-7329-a931-664165e77b6e | €9.00 | €0.19 | matched |
| 112 | capture | 01a1ac0a-03d3-7454-ae50-bcf0627b513a | €49.00 | €0.67 | matched |
| 113 | capture | 01a1ac0a-1020-73cd-a820-692e44a54522 | €24.00 | €0.37 | matched |
| 114 | capture | 01a1ac0a-11e3-7bfc-9b5d-edb2efd8c0e6 | €35.00 | €0.50 | matched |
| 115 | capture | 01a1ac0a-393b-7c3f-997c-212f8f5ff7df | €15.00 | €0.26 | matched |
| 116 | refund | 01a1ac0a-59a0-7760-8d11-b34905c7fe75 | -€5.00 | €0.00 | matched |
| 117 | capture | 01a1ac0a-5f6c-7951-be34-0075ac7bab43 | €15.00 | €0.26 | matched |
| 118 | capture | 01a1ac0a-65cf-7fe0-8273-67915689b494 | €24.00 | €0.37 | matched |
| 120 | capture | 01a1ac0a-6a6b-703e-9e7e-270bc6210172 | €49.00 | €0.67 | matched |
| 121 | capture | 01a1ac0a-8b09-7722-9539-cfb8f01dc0cb | €9.00 | €0.19 | matched |
| 122 | capture | 01a1ac0a-8bba-7f31-9a9e-729320df3469 | €15.00 | €0.26 | matched |
| 123 | capture | 01a1ac0a-9e04-7f07-8dd9-dfa0b9e161eb | €24.00 | €0.37 | matched |
| 124 | capture | 01a1ac0a-a03c-72c0-b4d3-f17f7e7d1c9a | €49.00 | €0.67 | matched |
| 125 | capture | 01a1ac0a-b591-7f40-ac59-6ea86dc0b96d | €35.00 | €0.50 | matched |
| 126 | capture | 01a1ac0a-c030-71fc-97cb-41729742f7dc | €35.00 | €0.50 | matched |
| 127 | capture | 01a1ac0a-cafb-79d4-a795-7db3213dac2a | €24.00 | €0.37 | matched |
| 128 | capture | 01a1ac0a-de7e-7a78-aed4-f0ddc60e9223 | €49.00 | €0.67 | matched |
| 129 | capture | 01a1ac0a-e274-7e7b-86e6-b65cf548bd2a | €15.00 | €0.26 | matched |
| 130 | capture | 01a1ac0a-e48d-725a-ac48-0c2627cf0025 | €24.00 | €0.37 | matched |
| 131 | refund | 01a1ac0b-0816-788f-afda-b181983c0408 | -€13.00 | €0.00 | matched |
| 132 | capture | 01a1ac0b-1718-7f70-874e-6909f806034b | €24.00 | €0.37 | matched |
| 133 | capture | 01a1ac0b-1c55-73fb-a389-92b6931a7617 | €24.00 | €0.37 | matched |
| 134 | capture | 01a1ac0b-502f-7421-9550-5f83ac305a3a | €35.00 | €0.50 | matched |
| 135 | capture | 01a1ac0b-6a9d-71c6-8644-cb389ba0c7ef | €15.00 | €0.26 | matched |
| 136 | capture | 01a1ac0b-6bf6-7ee8-a2c4-2da60f97252c | €15.00 | €0.26 | matched |
| 137 | capture | 01a1ac0b-7b95-76b4-88fd-ff3f8ba3d9f6 | €9.00 | €0.19 | matched |
| 138 | capture | 01a1ac0b-8692-71e3-a547-c33b5ad27b53 | €49.00 | €0.67 | matched |