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
- 17 Oct, 22:10121 lines3 breaks
- 17 Oct, 22:00136 lines2 breaks
- 17 Oct, 21:50127 lines7 breaks
- 17 Oct, 21:40110 lines2 breaks
- 17 Oct, 21:30113 lines5 breaks
- 17 Oct, 21:20136 lines3 breaks
- 17 Oct, 21:10109 lines3 breaks
- 17 Oct, 21:00135 lines7 breaks
- 17 Oct, 20:50134 lines2 breaks
- 17 Oct, 20:40125 lines1 break
- 17 Oct, 20:30127 lines1 break
- 17 Oct, 20:20122 lines1 break
- 17 Oct, 20:10121 linesclean
- 17 Oct, 20:00123 lines3 breaks
17 Oct, 21:00
Gross
€3,070.00
PSP fee
€48.96
Net to the bank
€3,021.04
Settlement journal
#57651
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14baa-f3f1-76bd-9d54-1eacfd716d0e is already settled by stl_EUR_2987118 line 16
- duplicate linethe file lists it twicecapture:01a14bad-3abc-7a7a-b14a-de13eed5b2a0 is already settled by stl_EUR_2987118 line 50
- fee differencethe fee is not the contract feethe fee is 53, the contract says 50
- fee differencethe fee is not the contract feethe fee is 31, the contract says 26
- fee differencethe fee is not the contract feethe fee is 23, the contract says 19
- fee differencethe fee is not the contract feethe fee is 53, the contract says 50
- missing linein the books, not in the filerefund:01a14bb1-c5d4-798f-928e-0b7d18e03c2e is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 17 | capture | 01a14baa-f472-72fd-b21a-eb19dd9fc0b5 | €24.00 | €0.37 | duplicate line |
| 34 | capture | 01a14bac-0806-7ba8-aaf6-cdbb0ac59ccb | €35.00 | €0.53 | fee difference |
| 41 | capture | 01a14bac-ab96-7ce9-950f-04819d7201a7 | €15.00 | €0.31 | fee difference |
| 51 | capture | 01a14bad-3bc1-7756-81c6-c53a60c8d2f8 | €15.00 | €0.26 | duplicate line |
| 55 | capture | 01a14bad-7b06-73f2-bfff-7796cda118ff | €9.00 | €0.23 | fee difference |
| 107 | capture | 01a14bb1-7498-7f64-8148-a8d91db17fcc | €35.00 | €0.53 | fee difference |
| 1 | capture | 01a14ba1-06ed-7bfb-badb-647f73e35331 | €9.00 | €0.19 | matched |
| 2 | capture | 01a14ba1-5ac0-7844-9524-7c19c1353aba | €35.00 | €0.50 | matched |
| 3 | capture | 01a14ba7-a54e-74e8-bd95-05f98ade8ad2 | €24.00 | €0.37 | matched |
| 4 | capture | 01a14baa-1c35-7adb-bc7c-365a29f7671b | €9.00 | €0.19 | matched |
| 5 | capture | 01a14baa-27a6-7866-b85f-7be903233940 | €35.00 | €0.50 | matched |
| 6 | capture | 01a14baa-3bb9-76ca-be47-859715cb95c9 | €9.00 | €0.19 | matched |
| 7 | capture | 01a14baa-41b8-76db-9819-4f8235df6fc4 | €24.00 | €0.37 | matched |
| 8 | capture | 01a14baa-4f6d-72f0-bb2d-878fc2e74802 | €49.00 | €0.67 | matched |
| 9 | refund | 01a14baa-74e6-77ef-a6d4-09aae9370ac7 | -€3.00 | €0.00 | matched |
| 10 | capture | 01a14baa-8719-71c8-97c4-2282fdd4ff4e | €9.00 | €0.19 | matched |
| 11 | capture | 01a14baa-8f09-7dcf-ab8a-93c7b2fa3cfd | €24.00 | €0.37 | matched |
| 12 | capture | 01a14baa-b3d6-794a-a3f3-7aa38aff5473 | €24.00 | €0.37 | matched |
| 13 | capture | 01a14baa-be14-7424-ae10-0bac4856f138 | €15.00 | €0.26 | matched |
| 14 | capture | 01a14baa-ca0a-75b5-aa5d-24bbcf4a7809 | €24.00 | €0.37 | matched |
| 15 | capture | 01a14baa-e377-776b-88c1-bed94c8aca5b | €24.00 | €0.37 | matched |
| 16 | capture | 01a14baa-f472-72fd-b21a-eb19dd9fc0b5 | €24.00 | €0.37 | matched |
| 18 | capture | 01a14baa-f7a2-7553-8825-2cb93f6b9be3 | €9.00 | €0.19 | matched |
| 19 | capture | 01a14bab-0efc-7df8-ba37-b382ba5ef833 | €9.00 | €0.19 | matched |
| 20 | capture | 01a14bab-2c4b-77a2-bfb1-dd200692381d | €35.00 | €0.50 | matched |
| 21 | capture | 01a14bab-4cb6-7c51-82c6-0baa1ba79772 | €15.00 | €0.26 | matched |
| 22 | capture | 01a14bab-66db-7a6a-a0f3-63fb38addb30 | €9.00 | €0.19 | matched |
| 23 | capture | 01a14bab-75c4-754e-b844-01bf225a578f | €49.00 | €0.67 | matched |
| 24 | capture | 01a14bab-7c7d-7bf1-85fb-1513cd17f46c | €9.00 | €0.19 | matched |
| 25 | capture | 01a14bab-83c9-74a4-a522-087cebcb7975 | €35.00 | €0.50 | matched |
| 26 | capture | 01a14bab-98c9-7db6-a6a8-8636d7ed7613 | €9.00 | €0.19 | matched |
| 27 | capture | 01a14bab-aaf9-778d-9a09-b672ecdcf6ce | €15.00 | €0.26 | matched |
| 28 | capture | 01a14bab-adb7-716e-9f9c-513affcdd0ba | €49.00 | €0.67 | matched |
| 29 | capture | 01a14bab-afeb-7fba-a82b-e6f1aec07792 | €15.00 | €0.26 | matched |
| 30 | capture | 01a14bab-ca1e-7a8d-b15a-e0d598d59491 | €49.00 | €0.67 | matched |
| 31 | capture | 01a14bab-caca-7f0c-a991-4bca50b5967e | €24.00 | €0.37 | matched |
| 32 | refund | 01a14bab-cfba-7e1a-af66-002695bc37c3 | -€26.00 | €0.00 | matched |
| 33 | capture | 01a14bac-00a0-7f63-bd12-4a69f58ba43e | €49.00 | €0.67 | matched |
| 35 | capture | 01a14bac-0d9e-797b-a8d9-aefe02ec3f32 | €35.00 | €0.50 | matched |
| 36 | capture | 01a14bac-4668-73ac-afbb-f44130819276 | €24.00 | €0.37 | matched |
| 37 | refund | 01a14bac-6124-73be-9bd3-a53eabcc7ada | -€13.00 | €0.00 | matched |
| 38 | capture | 01a14bac-7312-75cb-9ec0-b12ff3d32c53 | €24.00 | €0.37 | matched |
| 39 | capture | 01a14bac-a6b2-7d70-9a29-62d56258caf7 | €9.00 | €0.19 | matched |
| 40 | capture | 01a14bac-a801-7626-aa95-f40ad00967e6 | €24.00 | €0.37 | matched |
| 42 | capture | 01a14bac-ad19-7e4d-b6bb-ebeb2d1eebe3 | €15.00 | €0.26 | matched |
| 43 | capture | 01a14bac-ba8f-7e13-ade0-59e07e630b42 | €15.00 | €0.26 | matched |
| 44 | capture | 01a14bac-be49-7315-9929-4a1b4dff0c21 | €35.00 | €0.50 | matched |
| 45 | capture | 01a14bac-d579-778e-a66e-8f2e2619591e | €24.00 | €0.37 | matched |
| 46 | capture | 01a14bac-f622-708a-b97f-449772773a9d | €49.00 | €0.67 | matched |
| 47 | capture | 01a14bad-09aa-7b04-8a43-682fd1230ab6 | €9.00 | €0.19 | matched |
| 48 | capture | 01a14bad-144c-73f2-91c5-79f1b57045dd | €49.00 | €0.67 | matched |
| 49 | capture | 01a14bad-3934-7b51-8165-df3416e74702 | €35.00 | €0.50 | matched |
| 50 | capture | 01a14bad-3bc1-7756-81c6-c53a60c8d2f8 | €15.00 | €0.26 | matched |
| 52 | capture | 01a14bad-5011-7df5-bb6e-2e30622a39ea | €35.00 | €0.50 | matched |
| 53 | capture | 01a14bad-562f-744e-8c7c-e1aeaa5d9958 | €9.00 | €0.19 | matched |
| 54 | capture | 01a14bad-751a-7399-bcd2-20ca80b3e289 | €49.00 | €0.67 | matched |
| 56 | capture | 01a14bad-93e9-75c1-9e6e-f4db801c833c | €24.00 | €0.37 | matched |
| 57 | capture | 01a14bad-a91a-7e3d-99dd-0285fd98a216 | €49.00 | €0.67 | matched |
| 58 | refund | 01a14bad-b937-7edd-b29e-5e04482633d5 | -€3.00 | €0.00 | matched |
| 59 | capture | 01a14bad-bad0-7a9c-86a9-1b4e58f84711 | €49.00 | €0.67 | matched |
| 60 | capture | 01a14bad-c32d-702b-bd15-f9ff4a85ed18 | €24.00 | €0.37 | matched |
| 61 | capture | 01a14bad-dae3-7461-bca4-11f5a6a11edc | €49.00 | €0.67 | matched |
| 62 | capture | 01a14bae-15d7-7812-885e-8931da435455 | €24.00 | €0.37 | matched |
| 63 | capture | 01a14bae-1fe9-7de5-9950-143561b5c6ed | €24.00 | €0.37 | matched |
| 64 | capture | 01a14bae-2195-778b-8e0b-57e3de6bf645 | €49.00 | €0.67 | matched |
| 65 | capture | 01a14bae-5b50-7d07-ba47-b2571a777404 | €9.00 | €0.19 | matched |
| 66 | capture | 01a14bae-7df2-73df-8fdd-68aa7c5937f6 | €9.00 | €0.19 | matched |
| 67 | capture | 01a14bae-881f-723f-b387-3c5f58511242 | €24.00 | €0.37 | matched |
| 68 | capture | 01a14bae-8de9-714d-a028-334c9779e310 | €49.00 | €0.67 | matched |
| 69 | capture | 01a14bae-bc26-77f3-be89-e64a2dc9b62c | €35.00 | €0.50 | matched |
| 70 | capture | 01a14bae-cd4f-7ef2-82bd-2cdd560c9d01 | €35.00 | €0.50 | matched |
| 71 | capture | 01a14bae-cef8-77de-a16d-67654b10a587 | €49.00 | €0.67 | matched |
| 72 | capture | 01a14bae-d9e4-77d5-852f-699312250fd1 | €9.00 | €0.19 | matched |
| 73 | capture | 01a14bae-dc9a-727e-8986-a5d59ff66abb | €15.00 | €0.26 | matched |
| 74 | refund | 01a14bae-f026-751d-827f-cdea0ac837c0 | -€4.00 | €0.00 | matched |
| 75 | capture | 01a14baf-0766-7e96-a88e-76333d70279b | €9.00 | €0.19 | matched |
| 76 | capture | 01a14baf-15a7-7cec-a0b2-3b0a9934c1cd | €24.00 | €0.37 | matched |
| 77 | capture | 01a14baf-22dd-74b6-a292-f536099776cf | €9.00 | €0.19 | matched |
| 78 | capture | 01a14baf-22dd-7979-b26d-d0f7400d8120 | €9.00 | €0.19 | matched |
| 79 | capture | 01a14baf-62cb-72c8-bb0f-63c1a7da69fb | €9.00 | €0.19 | matched |
| 80 | capture | 01a14baf-74b2-777b-aede-67dd2cccdde2 | €24.00 | €0.37 | matched |
| 81 | capture | 01a14baf-7991-7fbe-82fc-859881c73b02 | €35.00 | €0.50 | matched |
| 82 | capture | 01a14baf-a451-7be5-8e50-ea4c24f816c0 | €35.00 | €0.50 | matched |
| 83 | capture | 01a14baf-b2fc-7d8a-8d2b-f735d5fd26a0 | €15.00 | €0.26 | matched |
| 84 | capture | 01a14baf-fa55-7d6a-91a8-1dd45aabfec5 | €9.00 | €0.19 | matched |
| 85 | capture | 01a14bb0-0e73-7ebb-b20e-ffc58e6de1ed | €15.00 | €0.26 | matched |
| 86 | capture | 01a14bb0-0f37-7462-b176-a61c905fb432 | €35.00 | €0.50 | matched |
| 87 | capture | 01a14bb0-17f7-7f3e-aa84-2208c64706c4 | €15.00 | €0.26 | matched |
| 88 | capture | 01a14bb0-693d-7c79-8b82-58bc64d57b6f | €49.00 | €0.67 | matched |
| 89 | capture | 01a14bb0-873c-7925-8c7a-29c080767fe5 | €49.00 | €0.67 | matched |
| 90 | capture | 01a14bb0-8c35-7311-b32e-9d25cbbe782b | €9.00 | €0.19 | matched |
| 91 | capture | 01a14bb0-9630-7bc1-82de-2758961225da | €9.00 | €0.19 | matched |
| 92 | capture | 01a14bb0-98e3-7cfe-97ad-f84863f80e46 | €24.00 | €0.37 | matched |
| 93 | capture | 01a14bb0-9c85-78df-a5b8-5e2a19e3e3a8 | €15.00 | €0.26 | matched |
| 94 | capture | 01a14bb0-aaaf-7e68-a43d-316d0250e3d3 | €15.00 | €0.26 | matched |
| 95 | capture | 01a14bb0-b504-7557-bbd3-a48334d70cfe | €24.00 | €0.37 | matched |
| 96 | capture | 01a14bb0-bc95-7f3c-bbf5-71024aec72a8 | €49.00 | €0.67 | matched |
| 97 | refund | 01a14bb0-c349-7167-a9ba-51a2660a55cd | -€35.00 | €0.00 | matched |
| 98 | capture | 01a14bb0-cf12-7646-8c06-9f7947b1e69d | €15.00 | €0.26 | matched |
| 99 | capture | 01a14bb0-da79-79ba-abdd-cc0ab7dc0ab1 | €9.00 | €0.19 | matched |
| 100 | capture | 01a14bb0-de59-7b9c-b796-80240c80466d | €35.00 | €0.50 | matched |
| 101 | capture | 01a14bb1-29bb-751b-a5ca-a89778a5c850 | €15.00 | €0.26 | matched |
| 102 | capture | 01a14bb1-2e94-7644-8bd6-95d32ebbdafb | €9.00 | €0.19 | matched |
| 103 | capture | 01a14bb1-4096-7d57-8337-28a782fc57bb | €9.00 | €0.19 | matched |
| 104 | capture | 01a14bb1-5511-7567-9192-cd01475f9a5c | €49.00 | €0.67 | matched |
| 105 | capture | 01a14bb1-594a-7b38-992c-d06605597d0c | €24.00 | €0.37 | matched |
| 106 | capture | 01a14bb1-598b-7be8-b305-14045ab9876f | €9.00 | €0.19 | matched |
| 108 | capture | 01a14bb1-8bba-7719-9f60-e9c4de6c21af | €49.00 | €0.67 | matched |
| 109 | capture | 01a14bb1-90ff-78d4-ba77-9b83116378a5 | €9.00 | €0.19 | matched |
| 110 | capture | 01a14bb1-ab6b-7998-ad22-dcf5ff840fdb | €35.00 | €0.50 | matched |
| 111 | capture | 01a14bb1-b7aa-7b20-bc3c-8c38b059fce7 | €15.00 | €0.26 | matched |
| 112 | refund | 01a14bb1-b95a-7b29-9a5d-0135869f7a09 | -€47.00 | €0.00 | matched |
| 113 | capture | 01a14bb1-c3a0-7f3e-a944-9df34b3445cf | €35.00 | €0.50 | matched |
| 114 | capture | 01a14bb1-c3fb-7011-b886-e7fc040bdb27 | €15.00 | €0.26 | matched |
| 115 | capture | 01a14bb1-d1e5-7c70-8cda-6c5728ba9526 | €9.00 | €0.19 | matched |
| 116 | capture | 01a14bb1-d963-7542-ac5c-ec384515a192 | €49.00 | €0.67 | matched |
| 117 | capture | 01a14bb1-da5e-75e3-9ada-35e15ac02955 | €9.00 | €0.19 | matched |
| 118 | capture | 01a14bb1-ede1-719e-83c6-c7ec44dd9d72 | €49.00 | €0.67 | matched |
| 119 | capture | 01a14bb1-eec7-7d1a-8536-4d4830fbacaa | €15.00 | €0.26 | matched |
| 120 | capture | 01a14bb1-f17a-7ede-89d4-6cb058ea9153 | €35.00 | €0.50 | matched |
| 121 | capture | 01a14bb1-fe05-72d5-9c3c-5b44694542be | €24.00 | €0.37 | matched |
| 122 | capture | 01a14bb2-1f1f-771f-9c5d-6b06f7c4bbe7 | €24.00 | €0.37 | matched |
| 123 | capture | 01a14bb2-2af8-75c2-bf9e-17cf4129e437 | €49.00 | €0.67 | matched |
| 124 | capture | 01a14bb2-328b-7ebe-aa79-2d6587b42299 | €15.00 | €0.26 | matched |
| 125 | capture | 01a14bb2-41f4-7ff6-a5e6-9ac67676da76 | €35.00 | €0.50 | matched |
| 126 | capture | 01a14bb2-4e52-7267-91b3-c02d464f187b | €35.00 | €0.50 | matched |
| 127 | capture | 01a14bb2-92b3-752e-83fb-62b00de85039 | €49.00 | €0.67 | matched |
| 128 | capture | 01a14bb2-9692-7db8-9315-ac00bf88caa6 | €35.00 | €0.50 | matched |
| 129 | capture | 01a14bb2-a944-709c-9000-efcba2af9809 | €15.00 | €0.26 | matched |
| 130 | capture | 01a14bb2-fa4b-768b-89e7-55209a982eea | €15.00 | €0.26 | matched |
| 131 | capture | 01a14bb3-0f76-7aee-8540-dc8cdd47c88c | €9.00 | €0.19 | matched |
| 132 | capture | 01a14bb3-10a0-7739-92f6-60d8b47d4986 | €15.00 | €0.26 | matched |
| 133 | capture | 01a14bb3-150c-700a-9a5a-544daa9d35bc | €15.00 | €0.26 | matched |
| 134 | capture | 01a14bb3-2086-721a-853e-f6aeb12b7748 | €35.00 | €0.50 | matched |
| 135 | capture | 01a14bb3-3811-7d36-bb87-55663f6edb2e | €15.00 | €0.26 | matched |