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
- 4 Nov, 23:50141 lines2 breaks
- 4 Nov, 23:40123 lines5 breaks
- 4 Nov, 23:30133 lines3 breaks
- 4 Nov, 23:20109 lines3 breaks
- 4 Nov, 23:10117 lines3 breaks
- 4 Nov, 23:00119 linesclean
- 4 Nov, 22:50159 lines2 breaks
- 4 Nov, 22:40111 lines1 break
- 4 Nov, 22:30117 lines3 breaks
- 4 Nov, 22:20116 lines2 breaks
- 4 Nov, 22:10118 lines2 breaks
- 4 Nov, 22:00145 lines6 breaks
- 4 Nov, 21:50111 lines2 breaks
- 4 Nov, 21:40137 lines3 breaks
4 Nov, 22:00
Gross
€3,237.00
PSP fee
€51.60
Net to the bank
€3,185.40
Settlement journal
#386611
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a894-1dfb-7f46-aa6a-b7d834d94f04 is already settled by stl_EUR_2989716 line 19
- duplicate linethe file lists it twicecapture:01a1a899-ee75-7488-8c66-9f6c59bee70c is already settled by stl_EUR_2989716 line 103
- fee differencethe fee is not the contract feethe fee is 28, the contract says 26
- fee differencethe fee is not the contract feethe fee is 29, the contract says 26
- fee differencethe fee is not the contract feethe fee is 38, the contract says 37
- missing linein the books, not in the filecapture:01a1a89c-65b0-7544-9ab0-463d5aa969e3 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 9 | capture | 01a1a893-b9d4-7f9e-9888-743efeffd751 | €15.00 | €0.28 | fee difference |
| 20 | capture | 01a1a894-1e24-779d-8eb5-46dc9474a3dd | €24.00 | €0.37 | duplicate line |
| 50 | capture | 01a1a896-150d-7e1f-8190-37978280ebc3 | €15.00 | €0.29 | fee difference |
| 61 | capture | 01a1a897-0048-7001-824f-c90d472585ae | €24.00 | €0.38 | fee difference |
| 104 | capture | 01a1a899-eeb3-7137-a2f2-b46e1c0a44dd | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a1a88a-d9af-7827-8175-2baea6f39919 | €49.00 | €0.67 | matched |
| 2 | capture | 01a1a88c-c079-744d-8f24-cd8da40c1926 | €24.00 | €0.37 | matched |
| 3 | capture | 01a1a893-7279-7da3-8436-54600b5ee4aa | €35.00 | €0.50 | matched |
| 4 | capture | 01a1a893-83e9-7abe-a6d6-389abc3e4439 | €9.00 | €0.19 | matched |
| 5 | capture | 01a1a893-992d-7126-8e92-6d8c7a36f1ee | €35.00 | €0.50 | matched |
| 6 | capture | 01a1a893-b496-7cd3-9692-e8c04fabcc40 | €24.00 | €0.37 | matched |
| 7 | capture | 01a1a893-b4cd-7052-be11-780396cc2b7e | €24.00 | €0.37 | matched |
| 8 | capture | 01a1a893-b94a-7519-a973-804014c3fab6 | €24.00 | €0.37 | matched |
| 10 | capture | 01a1a893-c936-785a-82af-27fea2265236 | €49.00 | €0.67 | matched |
| 11 | capture | 01a1a893-cf72-72f5-8758-9dabcaa2c96a | €24.00 | €0.37 | matched |
| 12 | capture | 01a1a893-d750-75ab-a1a0-0a7779dc7cbb | €9.00 | €0.19 | matched |
| 13 | capture | 01a1a893-ddb4-7636-8aff-0e46ff50b3c9 | €15.00 | €0.26 | matched |
| 14 | capture | 01a1a893-f2d3-7f59-9d86-065a0f35a8f1 | €49.00 | €0.67 | matched |
| 15 | refund | 01a1a893-f78a-72a6-86ea-624ddd5d8adb | -€11.00 | €0.00 | matched |
| 16 | capture | 01a1a894-0a4c-74a2-9ae0-71d63f50de39 | €49.00 | €0.67 | matched |
| 17 | capture | 01a1a894-0e2e-7831-9dfe-166b0d6019f5 | €9.00 | €0.19 | matched |
| 18 | capture | 01a1a894-181d-7ce2-bdf7-026120ed467f | €35.00 | €0.50 | matched |
| 19 | capture | 01a1a894-1e24-779d-8eb5-46dc9474a3dd | €24.00 | €0.37 | matched |
| 21 | capture | 01a1a894-31b0-7478-bc62-ea4a9320e328 | €9.00 | €0.19 | matched |
| 22 | capture | 01a1a894-437d-7756-af81-ce7fbbcc30ac | €24.00 | €0.37 | matched |
| 23 | capture | 01a1a894-5c85-739a-97ff-70ef35e072f4 | €49.00 | €0.67 | matched |
| 24 | capture | 01a1a894-6529-7eb3-8d0c-e3a703e4e26c | €9.00 | €0.19 | matched |
| 25 | capture | 01a1a894-855e-78f1-9fb0-725ddf8bfbdf | €35.00 | €0.50 | matched |
| 26 | capture | 01a1a894-8612-7a17-994e-6712d74e68d2 | €35.00 | €0.50 | matched |
| 27 | capture | 01a1a894-92e4-7312-84b3-b794e3a0727d | €24.00 | €0.37 | matched |
| 28 | capture | 01a1a894-9d36-7431-94e6-2d33122f2e6e | €35.00 | €0.50 | matched |
| 29 | capture | 01a1a894-a147-7d1d-860d-ab956c2e6f36 | €35.00 | €0.50 | matched |
| 30 | refund | 01a1a894-a76f-731b-9432-d39ba8771036 | -€5.00 | €0.00 | matched |
| 31 | refund | 01a1a894-bdec-7a9c-ad74-fb6f369c0d93 | -€6.00 | €0.00 | matched |
| 32 | capture | 01a1a894-c5de-7e29-9c6a-eea5a3372061 | €24.00 | €0.37 | matched |
| 33 | capture | 01a1a894-e6cf-77d1-aab4-c781f3ac0e3d | €9.00 | €0.19 | matched |
| 34 | capture | 01a1a894-eab7-703c-b303-a5721e55150d | €49.00 | €0.67 | matched |
| 35 | capture | 01a1a894-f876-7365-b225-1d60263cd6ed | €35.00 | €0.50 | matched |
| 36 | capture | 01a1a895-08d0-74c0-b0b5-f9cdcb42a132 | €49.00 | €0.67 | matched |
| 37 | capture | 01a1a895-3c0d-7305-a56f-316f49eb65b5 | €9.00 | €0.19 | matched |
| 38 | refund | 01a1a895-45b8-7341-a8ed-ccb19fece784 | -€5.00 | €0.00 | matched |
| 39 | refund | 01a1a895-47bd-7ecd-8534-6dece1412a60 | -€33.00 | €0.00 | matched |
| 40 | capture | 01a1a895-5f3a-739a-9064-26014c1d0f53 | €9.00 | €0.19 | matched |
| 41 | capture | 01a1a895-64ec-74a9-a36e-aea9d5d5cc7e | €24.00 | €0.37 | matched |
| 42 | capture | 01a1a895-7d41-7426-a9b1-37dc9d915f86 | €15.00 | €0.26 | matched |
| 43 | capture | 01a1a895-8a42-7f53-b028-bbb43a957599 | €49.00 | €0.67 | matched |
| 44 | capture | 01a1a895-9303-7413-bff6-dd3188d71990 | €15.00 | €0.26 | matched |
| 45 | capture | 01a1a895-d83b-72c0-97d4-af119ac83f84 | €9.00 | €0.19 | matched |
| 46 | refund | 01a1a895-de03-7ee6-a99f-f7298abec397 | -€6.00 | €0.00 | matched |
| 47 | capture | 01a1a895-ea4c-70cf-b644-efdb3ebbd040 | €49.00 | €0.67 | matched |
| 48 | capture | 01a1a895-fc22-75f5-945f-403ef2f27222 | €15.00 | €0.26 | matched |
| 49 | capture | 01a1a896-099e-7bfd-9506-7241258b8acc | €35.00 | €0.50 | matched |
| 51 | capture | 01a1a896-394f-77a6-a36c-92bd66836e79 | €15.00 | €0.26 | matched |
| 52 | capture | 01a1a896-443a-7c51-bd51-597becc6cf8e | €24.00 | €0.37 | matched |
| 53 | capture | 01a1a896-5052-72a9-8dac-5c6eb8286846 | €9.00 | €0.19 | matched |
| 54 | refund | 01a1a896-6a29-790f-99f8-a9bbce34e29b | -€15.00 | €0.00 | matched |
| 55 | capture | 01a1a896-8901-7ed9-bd6d-4a2e521b5ec5 | €35.00 | €0.50 | matched |
| 56 | capture | 01a1a896-94bb-7912-995a-93611d1d8bc4 | €24.00 | €0.37 | matched |
| 57 | capture | 01a1a896-b24d-70bd-8c45-49a4bb8b5ba3 | €24.00 | €0.37 | matched |
| 58 | capture | 01a1a896-d9d4-74c6-9362-4fc5393e8142 | €9.00 | €0.19 | matched |
| 59 | capture | 01a1a896-e4dd-74bf-959d-59503ae2fbc8 | €24.00 | €0.37 | matched |
| 60 | capture | 01a1a896-efdd-7a0a-bbd3-5b7e59123966 | €24.00 | €0.37 | matched |
| 62 | capture | 01a1a897-0187-7709-8be4-c1fe7aecfbab | €9.00 | €0.19 | matched |
| 63 | capture | 01a1a897-24b7-7553-9745-408d8e09ed3d | €9.00 | €0.19 | matched |
| 64 | capture | 01a1a897-4913-7c98-85ba-098bb5c5ead1 | €9.00 | €0.19 | matched |
| 65 | capture | 01a1a897-55a2-7c65-a1ea-0c89d7dd6cf0 | €49.00 | €0.67 | matched |
| 66 | capture | 01a1a897-66b3-7431-9738-a0fb0e26c639 | €24.00 | €0.37 | matched |
| 67 | capture | 01a1a897-86cd-7686-b7b2-63eb8d3f02f6 | €49.00 | €0.67 | matched |
| 68 | capture | 01a1a897-9588-74e8-87e8-562edb809388 | €35.00 | €0.50 | matched |
| 69 | capture | 01a1a897-9948-71db-8458-f25d84de1dc9 | €24.00 | €0.37 | matched |
| 70 | capture | 01a1a897-abe2-700f-a395-ec3dd1aeda69 | €35.00 | €0.50 | matched |
| 71 | capture | 01a1a897-ea5b-7ceb-8c34-096dfb0e3a93 | €24.00 | €0.37 | matched |
| 72 | capture | 01a1a897-f0b5-7470-890e-f3e8346acd0f | €24.00 | €0.37 | matched |
| 73 | capture | 01a1a897-f5b3-78a0-b37f-b63d65fcea90 | €15.00 | €0.26 | matched |
| 74 | capture | 01a1a897-f5e6-7b84-a4f5-e7870466b9c4 | €9.00 | €0.19 | matched |
| 75 | capture | 01a1a898-0441-70d5-bb9c-508bd7ba8bad | €35.00 | €0.50 | matched |
| 76 | capture | 01a1a898-0df2-71b5-b8cd-9fa6ed3fbd14 | €15.00 | €0.26 | matched |
| 77 | capture | 01a1a898-27ca-7560-9e8b-891b3e390a07 | €35.00 | €0.50 | matched |
| 78 | capture | 01a1a898-59f6-71c2-a4d2-38276579f6b9 | €35.00 | €0.50 | matched |
| 79 | capture | 01a1a898-5dec-7052-b1f3-5ea885b02e72 | €9.00 | €0.19 | matched |
| 80 | capture | 01a1a898-77a1-7383-9b66-d08f7f4808e2 | €9.00 | €0.19 | matched |
| 81 | capture | 01a1a898-9025-701a-9256-2563b1243290 | €49.00 | €0.67 | matched |
| 82 | capture | 01a1a898-c11d-7388-9a96-f12a283f6314 | €9.00 | €0.19 | matched |
| 83 | capture | 01a1a898-c32f-7120-bf05-a6094385db64 | €35.00 | €0.50 | matched |
| 84 | capture | 01a1a898-c3e5-7f89-bc44-59082330c0ae | €15.00 | €0.26 | matched |
| 85 | capture | 01a1a898-e800-77fc-8d79-c8d860f3ee7b | €49.00 | €0.67 | matched |
| 86 | capture | 01a1a898-e45d-7853-b806-58691a06e1df | €15.00 | €0.26 | matched |
| 87 | capture | 01a1a898-f8e3-7564-b7fe-bc4a00aac9d1 | €15.00 | €0.26 | matched |
| 88 | capture | 01a1a899-0e73-7908-a23f-eeaa6efae68b | €49.00 | €0.67 | matched |
| 89 | capture | 01a1a899-1e2b-7281-8c37-a2796543cb11 | €15.00 | €0.26 | matched |
| 90 | capture | 01a1a899-238b-7d66-b060-da7b55f4776d | €24.00 | €0.37 | matched |
| 91 | capture | 01a1a899-2ae9-778a-9b68-e54d8d6e5d39 | €49.00 | €0.67 | matched |
| 92 | capture | 01a1a899-365a-79ba-ab78-a60f9c1cd0a8 | €15.00 | €0.26 | matched |
| 93 | capture | 01a1a899-5bb7-784c-aa98-70202a5cf649 | €24.00 | €0.37 | matched |
| 94 | refund | 01a1a899-5ee0-700b-8dc8-b4d1dfa5bac2 | -€11.00 | €0.00 | matched |
| 95 | capture | 01a1a899-6d1b-7f04-a174-36a7a4386a3a | €9.00 | €0.19 | matched |
| 96 | capture | 01a1a899-7d58-76ed-9e75-ab56dabd8ee4 | €49.00 | €0.67 | matched |
| 97 | capture | 01a1a899-8e4f-7397-9a31-f9d9f708ef80 | €35.00 | €0.50 | matched |
| 98 | capture | 01a1a899-9847-79fb-8303-c3eb5ce9714b | €15.00 | €0.26 | matched |
| 99 | capture | 01a1a899-9ea1-77af-b335-31656a10188d | €35.00 | €0.50 | matched |
| 100 | capture | 01a1a899-b3fd-7628-ba1c-dd2c78d12e75 | €15.00 | €0.26 | matched |
| 101 | capture | 01a1a899-d868-7333-8e49-8c1f43b3212d | €24.00 | €0.37 | matched |
| 102 | capture | 01a1a899-dfb6-77d2-851e-67c783df4f7e | €49.00 | €0.67 | matched |
| 103 | capture | 01a1a899-eeb3-7137-a2f2-b46e1c0a44dd | €35.00 | €0.50 | matched |
| 105 | refund | 01a1a89a-21c9-72dc-bb48-a909fc63b55f | -€7.00 | €0.00 | matched |
| 106 | capture | 01a1a89a-2af2-7e7e-88aa-3049da336b91 | €9.00 | €0.19 | matched |
| 107 | capture | 01a1a89a-3b2c-7e50-b168-0067a76e26ce | €35.00 | €0.50 | matched |
| 108 | capture | 01a1a89a-5676-70cb-a9f0-650129555f46 | €35.00 | €0.50 | matched |
| 109 | capture | 01a1a89a-5817-753d-994c-12f5930c5275 | €15.00 | €0.26 | matched |
| 110 | capture | 01a1a89a-656b-7c15-a391-5b01a7c44aed | €15.00 | €0.26 | matched |
| 111 | capture | 01a1a89a-7182-7b68-8ab7-2e8e0960abd3 | €9.00 | €0.19 | matched |
| 112 | capture | 01a1a89a-705c-7e92-8d03-fd610f0801db | €9.00 | €0.19 | matched |
| 113 | capture | 01a1a89a-7ab2-7e97-a313-d9f8ef16c014 | €35.00 | €0.50 | matched |
| 114 | capture | 01a1a89a-8494-74c6-a924-198653d2def1 | €24.00 | €0.37 | matched |
| 115 | capture | 01a1a89a-8c79-7e01-9312-e7ba601ee27c | €49.00 | €0.67 | matched |
| 116 | capture | 01a1a89a-9ac0-7d59-9756-ccf95084ec84 | €9.00 | €0.19 | matched |
| 117 | capture | 01a1a89a-9c92-74f4-a979-a22d4d1eb9c7 | €15.00 | €0.26 | matched |
| 118 | refund | 01a1a89a-af77-7b75-be21-b1b8010eb780 | -€23.00 | €0.00 | matched |
| 119 | capture | 01a1a89a-b3f7-7936-b9af-a5fa668d3842 | €15.00 | €0.26 | matched |
| 120 | capture | 01a1a89a-c0ec-71a4-970d-bf84fe658dd2 | €24.00 | €0.37 | matched |
| 121 | capture | 01a1a89a-ee37-7e1f-bec5-5a0287f7eaed | €9.00 | €0.19 | matched |
| 122 | capture | 01a1a89a-ffa6-74e7-adde-1e064f5182fd | €15.00 | €0.26 | matched |
| 123 | capture | 01a1a89b-08af-7363-b929-944e54c90741 | €24.00 | €0.37 | matched |
| 124 | capture | 01a1a89b-1e2d-70f0-8b6c-43f785d79efa | €24.00 | €0.37 | matched |
| 125 | refund | 01a1a89b-1fe7-78ae-8650-293524901bbd | -€12.00 | €0.00 | matched |
| 126 | capture | 01a1a89b-3266-7895-bf39-82f1aaf348ae | €49.00 | €0.67 | matched |
| 127 | capture | 01a1a89b-3cad-76c9-a825-d173605ab23c | €24.00 | €0.37 | matched |
| 128 | capture | 01a1a89b-4aef-73ea-a83c-6c6d3a08161d | €24.00 | €0.37 | matched |
| 129 | capture | 01a1a89b-51d0-7d3a-9eec-bec113ee3bb2 | €9.00 | €0.19 | matched |
| 130 | capture | 01a1a89b-6c53-77da-9d27-215a57445e0f | €15.00 | €0.26 | matched |
| 131 | capture | 01a1a89b-6d27-755d-ab7c-3063986f9402 | €35.00 | €0.50 | matched |
| 132 | capture | 01a1a89b-7840-7cee-af04-b72659b33ed6 | €49.00 | €0.67 | matched |
| 133 | capture | 01a1a89b-9ceb-7941-ba2f-84a892d1cffc | €9.00 | €0.19 | matched |
| 134 | capture | 01a1a89b-afac-7ced-8c6f-57b3d1d67757 | €9.00 | €0.19 | matched |
| 135 | capture | 01a1a89b-ff90-7732-b112-e84d9c727534 | €9.00 | €0.19 | matched |
| 136 | capture | 01a1a89c-1e10-757d-9f2c-3342b7835724 | €9.00 | €0.19 | matched |
| 137 | capture | 01a1a89c-4c52-7cbf-b52c-99b4b08719ad | €49.00 | €0.67 | matched |
| 138 | capture | 01a1a89c-672a-787e-84f6-3f1fa62a3940 | €24.00 | €0.37 | matched |
| 139 | capture | 01a1a89c-6c5c-72c5-8be9-0d4ab4c06ce9 | €49.00 | €0.67 | matched |
| 140 | capture | 01a1a89c-6cae-76df-908e-7c817afe00bf | €49.00 | €0.67 | matched |
| 141 | capture | 01a1a89c-6d30-7047-981a-e15124037033 | €24.00 | €0.37 | matched |
| 142 | capture | 01a1a89c-7a2d-716e-b4bc-6eb2805cd9cd | €35.00 | €0.50 | matched |
| 143 | capture | 01a1a89c-8a2c-75ef-88a6-be45413a8f31 | €9.00 | €0.19 | matched |
| 144 | refund | 01a1a89c-96d7-7603-9599-fc41a1736902 | -€23.00 | €0.00 | matched |
| 145 | capture | 01a1a89c-9e30-7ceb-8079-0abe12dbe227 | €24.00 | €0.37 | matched |