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
- 26 Oct, 17:30119 lines3 breaks
- 26 Oct, 17:20119 lines4 breaks
- 26 Oct, 17:10126 lines3 breaks
- 26 Oct, 17:00119 lines2 breaks
- 26 Oct, 16:50116 lines3 breaks
- 26 Oct, 16:40133 lines3 breaks
- 26 Oct, 16:30115 lines2 breaks
- 26 Oct, 16:20105 lines2 breaks
- 26 Oct, 16:10127 lines4 breaks
- 26 Oct, 16:00115 lines3 breaks
- 26 Oct, 15:50120 lines4 breaks
- 26 Oct, 15:40133 lines2 breaks
- 26 Oct, 15:30131 lines2 breaks
- 26 Oct, 15:20117 lines4 breaks
26 Oct, 16:40
Gross
€3,061.00
PSP fee
€49.36
Net to the bank
€3,011.64
Settlement journal
#218061
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1791c-0e13-7c86-9883-8107d30bfe0a is already settled by stl_EUR_2988388 line 90
- fee differencethe fee is not the contract feethe fee is 41, the contract says 37
- missing linein the books, not in the filecapture:01a1791a-4cd8-72d8-8b08-ffbab93fd988 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 36 | capture | 01a17917-7fca-71cc-a7f5-8d030d16969e | €24.00 | €0.41 | fee difference |
| 91 | capture | 01a1791c-0e66-76df-926d-7e667bea6b3c | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a1790d-6784-768d-8d08-3926857a1496 | €9.00 | €0.19 | matched |
| 2 | capture | 01a1790d-76fe-7a8f-8761-825bfe3f4c9b | €24.00 | €0.37 | matched |
| 3 | capture | 01a17911-477e-7b9f-84c0-16085a7d4a8e | €9.00 | €0.19 | matched |
| 4 | capture | 01a17915-29b3-7a48-9ee1-1788c1fa3db9 | €15.00 | €0.26 | matched |
| 5 | refund | 01a17915-5839-702f-8520-6c1ea5ddaea1 | -€7.00 | €0.00 | matched |
| 6 | capture | 01a17915-5d73-70e1-879b-fd0a359bbbd2 | €49.00 | €0.67 | matched |
| 7 | capture | 01a17915-753e-7cb8-bd02-ab06b75704b2 | €15.00 | €0.26 | matched |
| 8 | capture | 01a17915-8aae-7d2b-8103-80c02ea0e6ca | €35.00 | €0.50 | matched |
| 9 | capture | 01a17915-9a36-7ba2-ac84-59fe54a911f0 | €24.00 | €0.37 | matched |
| 10 | capture | 01a17915-aa5c-7299-9eaa-b68eac4a93a2 | €24.00 | €0.37 | matched |
| 11 | capture | 01a17915-c23b-7581-ab4c-a12f1a660339 | €24.00 | €0.37 | matched |
| 12 | capture | 01a17915-c6ae-784b-b2fd-ecce46c3fa71 | €15.00 | €0.26 | matched |
| 13 | capture | 01a17915-d260-76a1-872a-571858cad8b3 | €35.00 | €0.50 | matched |
| 14 | capture | 01a17915-e3c2-758b-a06c-16a59f750fcb | €9.00 | €0.19 | matched |
| 15 | capture | 01a17915-f1a3-75ae-bda1-bd8e42374c6f | €15.00 | €0.26 | matched |
| 16 | capture | 01a17916-16cd-749d-89bf-b442c8ad2732 | €15.00 | €0.26 | matched |
| 17 | capture | 01a17916-1f2a-7244-8153-f785381abcda | €24.00 | €0.37 | matched |
| 18 | capture | 01a17916-3d60-7387-ad20-74fbcee7deca | €49.00 | €0.67 | matched |
| 19 | capture | 01a17916-46b5-767f-8225-12eaa790e34c | €35.00 | €0.50 | matched |
| 20 | capture | 01a17916-4e8d-792b-b8b6-7ca418ed12df | €9.00 | €0.19 | matched |
| 21 | capture | 01a17916-7ade-76a4-93a3-181cf4daea34 | €49.00 | €0.67 | matched |
| 22 | capture | 01a17916-958e-707d-8294-69e0147323a2 | €49.00 | €0.67 | matched |
| 23 | capture | 01a17916-bb89-7987-946a-84fee5246dd9 | €15.00 | €0.26 | matched |
| 24 | capture | 01a17916-bfc6-71a6-83e6-ad445a20cc1f | €49.00 | €0.67 | matched |
| 25 | capture | 01a17916-e171-7d4b-9c99-06862e8ff7fc | €24.00 | €0.37 | matched |
| 26 | capture | 01a17916-e282-7367-903e-5761101b6b48 | €49.00 | €0.67 | matched |
| 27 | refund | 01a17917-13e3-7e1d-97b9-e07ae8f78360 | -€48.00 | €0.00 | matched |
| 28 | refund | 01a17917-3066-7112-9f17-67d46fd0317b | -€17.00 | €0.00 | matched |
| 29 | capture | 01a17917-35ce-729c-a6c1-90132742e755 | €35.00 | €0.50 | matched |
| 30 | capture | 01a17917-388c-7f87-b031-03a709155d3d | €9.00 | €0.19 | matched |
| 31 | capture | 01a17917-3c03-757b-a799-8bf17b71a926 | €15.00 | €0.26 | matched |
| 32 | capture | 01a17917-4469-78ec-8e12-57605d7d8dd1 | €9.00 | €0.19 | matched |
| 33 | capture | 01a17917-644b-7eca-9636-f44bdd3883d2 | €9.00 | €0.19 | matched |
| 34 | capture | 01a17917-7497-72be-8916-ad8c327ab7fe | €9.00 | €0.19 | matched |
| 35 | capture | 01a17917-79d8-72a0-b8ca-3d1740ed7b3d | €24.00 | €0.37 | matched |
| 37 | capture | 01a17917-ac25-72f4-95a6-0fb6714ffa1a | €15.00 | €0.26 | matched |
| 38 | capture | 01a17917-bfab-7e09-8974-7b74c50a6f89 | €49.00 | €0.67 | matched |
| 39 | capture | 01a17917-c1dc-7b82-97d8-57f1a02d2f74 | €15.00 | €0.26 | matched |
| 40 | capture | 01a17917-b947-7b62-a81c-78ca8839118e | €24.00 | €0.37 | matched |
| 41 | capture | 01a17917-c5e2-76a0-911a-589a37e81b07 | €24.00 | €0.37 | matched |
| 42 | capture | 01a17918-15e6-7520-9761-1f36a2358e38 | €9.00 | €0.19 | matched |
| 43 | capture | 01a17918-55ca-782e-87e7-348a94526618 | €49.00 | €0.67 | matched |
| 44 | capture | 01a17918-7ac0-7ffd-8ad9-51dd50425568 | €49.00 | €0.67 | matched |
| 45 | capture | 01a17918-e15d-76ce-8134-e28ed9b78278 | €24.00 | €0.37 | matched |
| 46 | capture | 01a17918-f2e0-7a0d-9835-ac44bdb0f7ca | €9.00 | €0.19 | matched |
| 47 | capture | 01a17919-0bea-78fd-b72c-3e05bd7b42a3 | €24.00 | €0.37 | matched |
| 48 | capture | 01a17919-0f7f-72b0-9f90-b315029e1e59 | €35.00 | €0.50 | matched |
| 49 | capture | 01a17919-28a9-77c4-b694-4395c44f96af | €24.00 | €0.37 | matched |
| 50 | capture | 01a17919-7a92-7978-8058-59591f929178 | €9.00 | €0.19 | matched |
| 51 | capture | 01a17919-9d7e-7246-9932-d282d3397871 | €15.00 | €0.26 | matched |
| 52 | capture | 01a17919-a077-7651-af9e-d89bbf350604 | €24.00 | €0.37 | matched |
| 53 | capture | 01a17919-a0ee-7c16-af3f-d003ce46bc23 | €49.00 | €0.67 | matched |
| 54 | capture | 01a17919-b91d-70e8-8d1e-ae8eaa08878a | €49.00 | €0.67 | matched |
| 55 | capture | 01a17919-ce25-73b6-b21a-4ce72cde0a39 | €49.00 | €0.67 | matched |
| 56 | capture | 01a17919-d958-7f67-a585-0f1923f86572 | €49.00 | €0.67 | matched |
| 57 | refund | 01a17919-e733-7568-9fec-6cd508807f24 | -€29.00 | €0.00 | matched |
| 58 | capture | 01a17919-e7a9-7941-82a6-6fee9a2b37d8 | €9.00 | €0.19 | matched |
| 59 | capture | 01a1791a-0198-786c-a084-6375555ab5a8 | €49.00 | €0.67 | matched |
| 60 | capture | 01a1791a-18bc-7de5-870d-21cfaa17142f | €9.00 | €0.19 | matched |
| 61 | capture | 01a1791a-21c6-78ca-8a37-38d9178d54c5 | €49.00 | €0.67 | matched |
| 62 | capture | 01a1791a-4152-7f7b-9516-1ba101298d9c | €24.00 | €0.37 | matched |
| 63 | capture | 01a1791a-5125-7b9d-8fba-c4e22b0ce592 | €9.00 | €0.19 | matched |
| 64 | capture | 01a1791a-7c5a-7978-9c33-41413fb2fc4a | €9.00 | €0.19 | matched |
| 65 | refund | 01a1791a-825b-7d91-a54a-ae60316257e1 | -€20.00 | €0.00 | matched |
| 66 | capture | 01a1791a-9de2-714f-9d8a-586ce58d97b9 | €15.00 | €0.26 | matched |
| 67 | capture | 01a1791a-a330-75ff-baec-8c2bb4384b20 | €9.00 | €0.19 | matched |
| 68 | capture | 01a1791a-be50-76b3-964a-d88c427aa7b7 | €9.00 | €0.19 | matched |
| 69 | capture | 01a1791a-cccc-7ec4-941a-9c78083062f3 | €9.00 | €0.19 | matched |
| 70 | capture | 01a1791a-d10d-77cd-b670-61bfb9bdd9d2 | €35.00 | €0.50 | matched |
| 71 | capture | 01a1791a-ed11-77ed-89cb-1568e8f51ac2 | €15.00 | €0.26 | matched |
| 72 | capture | 01a1791a-ffe7-7283-9eb5-202540364a3e | €49.00 | €0.67 | matched |
| 73 | capture | 01a1791b-0274-7866-8c7d-4743fd066bc9 | €49.00 | €0.67 | matched |
| 74 | refund | 01a1791b-0340-74c5-898f-77c6750cdd53 | -€9.00 | €0.00 | matched |
| 75 | capture | 01a1791b-193a-7f51-9fd3-dbde6e0decf2 | €49.00 | €0.67 | matched |
| 76 | capture | 01a1791b-208d-7957-b351-ec65d9ca840e | €15.00 | €0.26 | matched |
| 77 | capture | 01a1791b-20b2-737e-b196-fd5992e57f7c | €15.00 | €0.26 | matched |
| 78 | refund | 01a1791b-33e7-7ece-b5c5-cdd1bf47e290 | -€7.00 | €0.00 | matched |
| 79 | capture | 01a1791b-435f-7b64-b701-692cb5dcd567 | €15.00 | €0.26 | matched |
| 80 | capture | 01a1791b-559c-7389-bf1d-71d0d5b00958 | €49.00 | €0.67 | matched |
| 81 | capture | 01a1791b-60c0-7859-bf3d-955e44e34f1e | €35.00 | €0.50 | matched |
| 82 | capture | 01a1791b-675f-75cd-9ad1-534cd59df191 | €24.00 | €0.37 | matched |
| 83 | capture | 01a1791b-7713-7467-8989-070bb9a95937 | €15.00 | €0.26 | matched |
| 84 | capture | 01a1791b-884a-7e6a-b33b-ebeee6bbe3d9 | €49.00 | €0.67 | matched |
| 85 | capture | 01a1791b-8d5d-7d6a-b247-95e72bddedc4 | €49.00 | €0.67 | matched |
| 86 | capture | 01a1791b-99b4-7d93-9863-d4eca4575725 | €24.00 | €0.37 | matched |
| 87 | capture | 01a1791b-ba56-75fd-a767-4ba06c8ea97a | €15.00 | €0.26 | matched |
| 88 | capture | 01a1791b-c494-7908-8923-d3aefaed936a | €49.00 | €0.67 | matched |
| 89 | capture | 01a1791b-fb8c-7d5a-8e05-6b60d4d2cd50 | €15.00 | €0.26 | matched |
| 90 | capture | 01a1791c-0e66-76df-926d-7e667bea6b3c | €49.00 | €0.67 | matched |
| 92 | capture | 01a1791c-1ef9-7399-995e-e534fb53a7f7 | €49.00 | €0.67 | matched |
| 93 | capture | 01a1791c-54c1-7678-8d64-fd9adb91b83c | €35.00 | €0.50 | matched |
| 94 | capture | 01a1791c-596a-7274-b265-f96dd846483f | €35.00 | €0.50 | matched |
| 95 | capture | 01a1791c-672c-715c-b5cc-840e626265b2 | €15.00 | €0.26 | matched |
| 96 | capture | 01a1791c-68f8-7421-a146-b93617ce4bb5 | €24.00 | €0.37 | matched |
| 97 | capture | 01a1791c-7321-7dd6-a942-78438e8365a8 | €35.00 | €0.50 | matched |
| 98 | capture | 01a1791c-913f-7c85-9a8a-d2da3c36f534 | €24.00 | €0.37 | matched |
| 99 | capture | 01a1791c-b54d-7fd2-9cbc-b1733881cac1 | €49.00 | €0.67 | matched |
| 100 | capture | 01a1791d-023d-7fb3-bada-cd6a7cb37ebe | €15.00 | €0.26 | matched |
| 101 | capture | 01a1791d-05d3-7a1e-9200-dbc549a2726c | €24.00 | €0.37 | matched |
| 102 | capture | 01a1791d-2bad-7e91-86bd-407a9b934fef | €35.00 | €0.50 | matched |
| 103 | capture | 01a1791d-489a-7e85-98a4-4e2996bcc854 | €49.00 | €0.67 | matched |
| 104 | capture | 01a1791d-4bad-7021-aa80-e309d5eb8392 | €9.00 | €0.19 | matched |
| 105 | capture | 01a1791d-52a3-7dc9-a037-af097fcc7664 | €35.00 | €0.50 | matched |
| 106 | capture | 01a1791d-5cb4-74bd-b570-a9599c67cf83 | €15.00 | €0.26 | matched |
| 107 | capture | 01a1791d-6f8e-7eb4-a711-81d58a948b5f | €15.00 | €0.26 | matched |
| 108 | capture | 01a1791d-7a4b-7016-b5bd-e936199075d4 | €35.00 | €0.50 | matched |
| 109 | capture | 01a1791d-7cc0-7c4a-9d25-6916d99a4b43 | €49.00 | €0.67 | matched |
| 110 | refund | 01a1791d-9002-7fdf-bf84-a5f46b47c290 | -€26.00 | €0.00 | matched |
| 111 | refund | 01a1791d-9cb5-7660-bf6e-6007f424c41c | -€20.00 | €0.00 | matched |
| 112 | capture | 01a1791d-a4c0-7567-9efc-d9d1feda3da6 | €9.00 | €0.19 | matched |
| 113 | capture | 01a1791d-af46-75b4-b912-86952cf82f3f | €15.00 | €0.26 | matched |
| 114 | capture | 01a1791d-b43f-7831-99b0-4d2217f8ac60 | €35.00 | €0.50 | matched |
| 115 | capture | 01a1791d-bb62-7f34-8e3e-49cafc284fa9 | €24.00 | €0.37 | matched |
| 116 | refund | 01a1791d-cb5a-755f-8e22-57028436f011 | -€14.00 | €0.00 | matched |
| 117 | capture | 01a1791d-d043-7390-ad75-2c230fa02e93 | €24.00 | €0.37 | matched |
| 118 | refund | 01a1791d-d482-78a5-883d-55f4c3c6e129 | -€26.00 | €0.00 | matched |
| 119 | capture | 01a1791d-d8e3-7211-b75a-a4f2e72cb0bc | €15.00 | €0.26 | matched |
| 120 | capture | 01a1791d-e59d-7e39-9847-e5c2ca9b4ad3 | €35.00 | €0.50 | matched |
| 121 | capture | 01a1791d-eda3-7a9b-b601-8a1576296985 | €24.00 | €0.37 | matched |
| 122 | capture | 01a1791d-f096-794b-a433-400cc975be6c | €24.00 | €0.37 | matched |
| 123 | capture | 01a1791d-f78b-74d5-97e7-bd2412f81f33 | €15.00 | €0.26 | matched |
| 124 | capture | 01a1791d-f9e2-7631-8f6a-15e4730ed49c | €15.00 | €0.26 | matched |
| 125 | capture | 01a1791d-fc53-7d49-bc6b-87e61e174cfd | €35.00 | €0.50 | matched |
| 126 | capture | 01a1791d-fe8c-7123-9f58-299de2b74431 | €24.00 | €0.37 | matched |
| 127 | capture | 01a1791e-13f5-7796-8dd9-7938edae095a | €24.00 | €0.37 | matched |
| 128 | capture | 01a1791e-1828-7590-9d9b-354223322ae8 | €15.00 | €0.26 | matched |
| 129 | capture | 01a1791e-264b-7808-9ea8-df6385cef170 | €49.00 | €0.67 | matched |
| 130 | capture | 01a1791e-283e-7be7-be85-a41f5ad5b814 | €35.00 | €0.50 | matched |
| 131 | capture | 01a1791e-2977-72bc-b5aa-e0cb4bdb58f7 | €15.00 | €0.26 | matched |
| 132 | capture | 01a1791e-32a3-770d-9bc1-ecc95a847c71 | €9.00 | €0.19 | matched |
| 133 | capture | 01a1791e-50ae-7519-bd1a-8bdcdcd7f8c8 | €35.00 | €0.50 | matched |