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
- 2 Nov, 18:00123 lines1 break
- 2 Nov, 17:50120 lines2 breaks
- 2 Nov, 17:40130 lines1 break
- 2 Nov, 17:30121 lines4 breaks
- 2 Nov, 17:20125 lines3 breaks
- 2 Nov, 17:10148 lines2 breaks
- 2 Nov, 17:00117 lines5 breaks
- 2 Nov, 16:50138 lines6 breaks
- 2 Nov, 16:40111 lines2 breaks
- 2 Nov, 16:30123 lines3 breaks
- 2 Nov, 16:20128 lines2 breaks
- 2 Nov, 16:10106 lines2 breaks
- 2 Nov, 16:00106 lines2 breaks
- 2 Nov, 15:50138 lines3 breaks
2 Nov, 16:50
Gross
€3,378.00
PSP fee
€53.21
Net to the bank
€3,324.79
Settlement journal
#346114
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19d2c-72ee-73e1-b3f8-0dc16e6ab2ad is already settled by stl_EUR_2989397 line 24
- duplicate linethe file lists it twicecapture:01a19d2c-b467-7e99-bd76-03a96a586990 is already settled by stl_EUR_2989397 line 34
- duplicate linethe file lists it twicecapture:01a19d30-0ff5-7364-8812-ef6eec9d70ac is already settled by stl_EUR_2989397 line 83
- fee differencethe fee is not the contract feethe fee is 68, the contract says 67
- fee differencethe fee is not the contract feethe fee is 23, the contract says 19
- missing linein the books, not in the filerefund:01a19d2c-bb10-7b7a-81f4-cdca7aa9c79b is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 14 | capture | 01a19d2b-bd16-7102-955f-fc5a5951873d | €49.00 | €0.68 | fee difference |
| 25 | capture | 01a19d2c-7309-7770-b6ab-c610b4c995d6 | €24.00 | €0.37 | duplicate line |
| 35 | capture | 01a19d2c-c7f9-7019-a741-08db719e0748 | €24.00 | €0.37 | duplicate line |
| 84 | capture | 01a19d30-1018-767b-a6ca-b550e8d846ea | €9.00 | €0.19 | duplicate line |
| 100 | capture | 01a19d31-4520-73ba-8e09-3059b09b8595 | €9.00 | €0.23 | fee difference |
| 1 | capture | 01a19d27-eef8-7e32-a921-54a2bb2a3298 | €24.00 | €0.37 | matched |
| 2 | capture | 01a19d2b-0fc4-79ec-aefb-96f558dc6bcd | €9.00 | €0.19 | matched |
| 3 | capture | 01a19d2b-2b6d-7551-bcb2-4fa3fc09c30a | €35.00 | €0.50 | matched |
| 4 | capture | 01a19d2b-35b6-7964-b30c-0848211ada7b | €49.00 | €0.67 | matched |
| 5 | capture | 01a19d2b-2dc3-716d-9a7b-5f7de25acffc | €24.00 | €0.37 | matched |
| 6 | capture | 01a19d2b-622d-7275-b1b1-927e06985677 | €24.00 | €0.37 | matched |
| 7 | capture | 01a19d2b-76ad-7a88-b1b4-280137489f4a | €35.00 | €0.50 | matched |
| 8 | capture | 01a19d2b-7bd7-70f3-b00b-516025846906 | €15.00 | €0.26 | matched |
| 9 | capture | 01a19d2b-8df4-7f35-aadb-ee833ed3ae61 | €24.00 | €0.37 | matched |
| 10 | capture | 01a19d2b-ad42-7764-ad42-a48406743486 | €49.00 | €0.67 | matched |
| 11 | capture | 01a19d2b-b2d3-7ca9-935f-e8bb807bc825 | €49.00 | €0.67 | matched |
| 12 | capture | 01a19d2b-b598-755e-ae63-2ef2229d618f | €35.00 | €0.50 | matched |
| 13 | capture | 01a19d2b-b884-7def-a285-0c5fee5f2ec9 | €35.00 | €0.50 | matched |
| 15 | capture | 01a19d2b-e92a-7c0b-be6c-e706fa1b24a4 | €15.00 | €0.26 | matched |
| 16 | capture | 01a19d2b-f61d-74f0-9a08-928a2a88a9ef | €9.00 | €0.19 | matched |
| 17 | capture | 01a19d2c-3b55-73c0-a15b-0a4a211ffe67 | €35.00 | €0.50 | matched |
| 18 | capture | 01a19d2c-3a89-7ef4-b161-543567649afe | €24.00 | €0.37 | matched |
| 19 | capture | 01a19d2c-4751-7b6a-ac33-dcbc84f3b0c4 | €24.00 | €0.37 | matched |
| 20 | capture | 01a19d2c-488f-7e84-9fca-dd18735d0064 | €49.00 | €0.67 | matched |
| 21 | capture | 01a19d2c-4896-7ebf-a9d0-6731c7706eca | €49.00 | €0.67 | matched |
| 22 | capture | 01a19d2c-5c4a-747b-bbc7-e7a61e291256 | €9.00 | €0.19 | matched |
| 23 | capture | 01a19d2c-60f9-7233-9ab4-f4272adc05e9 | €9.00 | €0.19 | matched |
| 24 | capture | 01a19d2c-7309-7770-b6ab-c610b4c995d6 | €24.00 | €0.37 | matched |
| 26 | capture | 01a19d2c-7af2-791f-9e89-463ac5638769 | €49.00 | €0.67 | matched |
| 27 | capture | 01a19d2c-8c43-7bdd-b474-6b944fcd5640 | €15.00 | €0.26 | matched |
| 28 | capture | 01a19d2c-950e-7ffa-9614-f947812eb496 | €24.00 | €0.37 | matched |
| 29 | capture | 01a19d2c-aebf-77d9-bd5e-047b09cf8118 | €35.00 | €0.50 | matched |
| 30 | capture | 01a19d2c-b46d-7c12-a578-f3860724abfe | €49.00 | €0.67 | matched |
| 31 | capture | 01a19d2c-ba01-7361-9662-7460a1286eb3 | €24.00 | €0.37 | matched |
| 32 | capture | 01a19d2c-c010-7533-915f-4c7268bdca50 | €24.00 | €0.37 | matched |
| 33 | capture | 01a19d2c-c104-7a09-9321-04b6e4bc8616 | €24.00 | €0.37 | matched |
| 34 | capture | 01a19d2c-c7f9-7019-a741-08db719e0748 | €24.00 | €0.37 | matched |
| 36 | refund | 01a19d2c-db20-7005-a4e5-9f65053c93dd | -€21.00 | €0.00 | matched |
| 37 | capture | 01a19d2c-ea76-7e2c-9232-1b37484e9701 | €9.00 | €0.19 | matched |
| 38 | refund | 01a19d2c-f673-7da3-b8b6-957e037d573b | -€15.00 | €0.00 | matched |
| 39 | capture | 01a19d2d-00df-7967-8a13-e48450ce62e9 | €49.00 | €0.67 | matched |
| 40 | capture | 01a19d2d-1133-7a8e-acda-4aa91ee600db | €15.00 | €0.26 | matched |
| 41 | refund | 01a19d2d-17d2-7037-89d8-548140caf333 | -€12.00 | €0.00 | matched |
| 42 | capture | 01a19d2d-1c57-7ba9-8218-58e895b1097c | €49.00 | €0.67 | matched |
| 43 | capture | 01a19d2d-27dd-7e5c-aa54-87ea2da4acdf | €24.00 | €0.37 | matched |
| 44 | capture | 01a19d2d-38e3-76a1-aa18-dd3d04fbd1e2 | €35.00 | €0.50 | matched |
| 45 | capture | 01a19d2d-3b3b-72f4-8820-055b5b3d6be8 | €35.00 | €0.50 | matched |
| 46 | capture | 01a19d2d-5c48-71ee-96b2-b8d9c5ed4273 | €24.00 | €0.37 | matched |
| 47 | capture | 01a19d2d-773d-7ed2-b953-f2fc95d3906b | €24.00 | €0.37 | matched |
| 48 | capture | 01a19d2d-7c82-7b6d-9bf0-3d1b3e297581 | €15.00 | €0.26 | matched |
| 49 | refund | 01a19d2d-7d34-7951-89d9-7f0c3f1200a4 | -€30.00 | €0.00 | matched |
| 50 | capture | 01a19d2d-87e6-741c-8835-d8adf825de39 | €24.00 | €0.37 | matched |
| 51 | capture | 01a19d2d-9c91-751d-8f42-8f6dc4f0af91 | €35.00 | €0.50 | matched |
| 52 | capture | 01a19d2d-c70e-7674-a648-19bf960c6016 | €9.00 | €0.19 | matched |
| 53 | capture | 01a19d2d-e709-7b57-9884-303cc34b0d62 | €49.00 | €0.67 | matched |
| 54 | capture | 01a19d2d-ebde-70b4-a94d-8d1e6ba17051 | €35.00 | €0.50 | matched |
| 55 | capture | 01a19d2d-f36b-7026-9e69-3e478eddc904 | €15.00 | €0.26 | matched |
| 56 | refund | 01a19d2e-1a80-75b1-818e-bc46ffafe2ae | -€6.00 | €0.00 | matched |
| 57 | capture | 01a19d2e-20cb-767d-b652-403b56fc2960 | €15.00 | €0.26 | matched |
| 58 | capture | 01a19d2e-2b34-7474-b98c-3d9cacc8ffb7 | €24.00 | €0.37 | matched |
| 59 | refund | 01a19d2e-93b3-7c22-8b92-5f7675dd45f9 | -€17.00 | €0.00 | matched |
| 60 | capture | 01a19d2e-994b-7e5b-b6d1-deaee1bf7be9 | €15.00 | €0.26 | matched |
| 61 | capture | 01a19d2e-cf0a-78ac-a63b-0ef2ecbba173 | €49.00 | €0.67 | matched |
| 62 | capture | 01a19d2e-d064-7526-a9c1-f370e2ebcdd4 | €15.00 | €0.26 | matched |
| 63 | capture | 01a19d2e-ebdb-76fb-8828-0f82e3d45bcb | €49.00 | €0.67 | matched |
| 64 | capture | 01a19d2e-ef1d-7625-b143-db4f06bf9ce0 | €24.00 | €0.37 | matched |
| 65 | capture | 01a19d2f-3dea-7c2a-bcf8-a5e5b8be1542 | €15.00 | €0.26 | matched |
| 66 | capture | 01a19d2f-4759-7770-9344-b095dec32796 | €49.00 | €0.67 | matched |
| 67 | capture | 01a19d2f-4816-70b8-b4cd-91fea33588dc | €15.00 | €0.26 | matched |
| 68 | capture | 01a19d2f-49cb-7a46-bffb-958535eea885 | €49.00 | €0.67 | matched |
| 69 | capture | 01a19d2f-62e7-7dae-aa94-de8dce2c81cd | €9.00 | €0.19 | matched |
| 70 | capture | 01a19d2f-6392-7bf3-83e0-fd9ecdb71836 | €9.00 | €0.19 | matched |
| 71 | capture | 01a19d2f-73dd-7fd1-9871-ddc9fbb2feaf | €24.00 | €0.37 | matched |
| 72 | capture | 01a19d2f-897c-7c83-ba0d-4dcfa4862c90 | €24.00 | €0.37 | matched |
| 73 | capture | 01a19d2f-9170-7ce9-92d8-11bc15e32ae4 | €24.00 | €0.37 | matched |
| 74 | capture | 01a19d2f-9c8b-783a-8a31-8b4d34f075ce | €24.00 | €0.37 | matched |
| 75 | capture | 01a19d2f-b59b-70ef-aa91-3dad15d62250 | €15.00 | €0.26 | matched |
| 76 | capture | 01a19d2f-c012-7eef-bcf2-d222683880d2 | €35.00 | €0.50 | matched |
| 77 | capture | 01a19d2f-cf60-722a-a574-cb79926d031d | €49.00 | €0.67 | matched |
| 78 | capture | 01a19d2f-e732-7198-8722-d422fe10d1ac | €24.00 | €0.37 | matched |
| 79 | capture | 01a19d2f-f2de-7cb8-977d-a7a716c5eed3 | €35.00 | €0.50 | matched |
| 80 | capture | 01a19d2f-f9e4-7eec-87f9-e3533fbd0b91 | €24.00 | €0.37 | matched |
| 81 | capture | 01a19d30-06ec-7358-a99e-0228347c296c | €15.00 | €0.26 | matched |
| 82 | capture | 01a19d30-0ce2-7eac-a31e-b7cf006a52d5 | €35.00 | €0.50 | matched |
| 83 | capture | 01a19d30-1018-767b-a6ca-b550e8d846ea | €9.00 | €0.19 | matched |
| 85 | capture | 01a19d30-209a-708c-a115-170fec65fdc2 | €35.00 | €0.50 | matched |
| 86 | capture | 01a19d30-305c-771c-9cca-4db969034900 | €9.00 | €0.19 | matched |
| 87 | capture | 01a19d30-4c59-775f-a91d-ece8fdd2eda6 | €24.00 | €0.37 | matched |
| 88 | capture | 01a19d30-5619-7910-bddd-b4550f6a925e | €9.00 | €0.19 | matched |
| 89 | refund | 01a19d30-5974-7a24-b56a-73e67fb1b50e | -€9.00 | €0.00 | matched |
| 90 | capture | 01a19d30-6dc9-7a5d-9fca-4022d9ade9fa | €24.00 | €0.37 | matched |
| 91 | capture | 01a19d30-85dd-7158-8b5d-243dfcb1dbb2 | €49.00 | €0.67 | matched |
| 92 | refund | 01a19d30-8ec6-7786-82e2-80062b9a20be | -€34.00 | €0.00 | matched |
| 93 | capture | 01a19d30-dc8c-7990-acfb-de5f041d7fd1 | €49.00 | €0.67 | matched |
| 94 | capture | 01a19d30-dd6f-7efd-a8cf-42806faaf420 | €9.00 | €0.19 | matched |
| 95 | capture | 01a19d30-e58f-73af-b342-6bf5de13e842 | €49.00 | €0.67 | matched |
| 96 | capture | 01a19d30-f569-7721-978d-ea25863e737d | €15.00 | €0.26 | matched |
| 97 | capture | 01a19d31-0294-7ab8-96fd-f8f6769a07a1 | €9.00 | €0.19 | matched |
| 98 | capture | 01a19d31-188f-750f-8cfa-6e13892f34d6 | €35.00 | €0.50 | matched |
| 99 | capture | 01a19d31-424a-71c7-b129-9fb61ddf853e | €9.00 | €0.19 | matched |
| 101 | capture | 01a19d31-4feb-7618-8d38-e12dbf5797f6 | €15.00 | €0.26 | matched |
| 102 | capture | 01a19d31-c5dd-7388-8305-bae5eee7d0b6 | €24.00 | €0.37 | matched |
| 103 | capture | 01a19d31-d47c-772b-9719-588f65084b24 | €49.00 | €0.67 | matched |
| 104 | capture | 01a19d31-e4de-7157-8f2d-602e85eed044 | €24.00 | €0.37 | matched |
| 105 | capture | 01a19d31-f9f6-7543-b4f8-af198ed98282 | €15.00 | €0.26 | matched |
| 106 | capture | 01a19d31-fa1c-7b74-aaf0-41a710cdd65f | €49.00 | €0.67 | matched |
| 107 | capture | 01a19d32-099e-7d79-9b17-f4b7121bc479 | €9.00 | €0.19 | matched |
| 108 | capture | 01a19d32-1029-7d6d-af99-b28e9c04fcb2 | €15.00 | €0.26 | matched |
| 109 | capture | 01a19d32-37e5-75ba-b9ee-f412ca4e6cbc | €35.00 | €0.50 | matched |
| 110 | capture | 01a19d32-4096-7fa4-9a6a-9f42868e3e39 | €24.00 | €0.37 | matched |
| 111 | capture | 01a19d32-521e-734a-bf6a-2beec79e9f82 | €35.00 | €0.50 | matched |
| 112 | capture | 01a19d32-538c-768a-8fcb-eef33e27269d | €49.00 | €0.67 | matched |
| 113 | capture | 01a19d32-7414-7d91-97f6-49260cfa226d | €15.00 | €0.26 | matched |
| 114 | capture | 01a19d32-7f4c-7aba-87b7-f64071574746 | €35.00 | €0.50 | matched |
| 115 | capture | 01a19d32-8d09-72c6-9b24-6d3bf3bd6143 | €49.00 | €0.67 | matched |
| 116 | capture | 01a19d32-9173-7bcc-a3bd-de9b446ae0d0 | €35.00 | €0.50 | matched |
| 117 | capture | 01a19d32-9bfe-79d2-890e-c37928a2dcfd | €24.00 | €0.37 | matched |
| 118 | refund | 01a19d32-d544-7507-ae70-5e42f34eae56 | -€15.00 | €0.00 | matched |
| 119 | capture | 01a19d32-e2da-7c7c-9c59-f6341e2c1086 | €49.00 | €0.67 | matched |
| 120 | capture | 01a19d32-f9fd-7493-ada7-b6db8ac09c83 | €49.00 | €0.67 | matched |
| 121 | capture | 01a19d33-0bb6-7d2f-a8de-d5fc549e91f5 | €49.00 | €0.67 | matched |
| 122 | capture | 01a19d33-31f6-76b9-8d5a-eec51590f8af | €49.00 | €0.67 | matched |
| 123 | capture | 01a19d33-3f5e-7775-9ac2-a0be0e3203d2 | €35.00 | €0.50 | matched |
| 124 | capture | 01a19d33-5e2f-703b-a114-c76c1ef746dc | €24.00 | €0.37 | matched |
| 125 | capture | 01a19d33-5f80-79e4-9081-e82277107d38 | €49.00 | €0.67 | matched |
| 126 | refund | 01a19d33-7a0d-7d8e-8c00-0e9f350d0ca6 | -€28.00 | €0.00 | matched |
| 127 | capture | 01a19d33-7c5a-7786-9e85-5d9cc31adf6d | €9.00 | €0.19 | matched |
| 128 | capture | 01a19d33-891e-78b8-ab58-142a29ebe939 | €9.00 | €0.19 | matched |
| 129 | capture | 01a19d33-9774-7927-b38b-be6851d4702f | €15.00 | €0.26 | matched |
| 130 | capture | 01a19d33-9a17-7bfd-992b-2ecc0f597bc9 | €15.00 | €0.26 | matched |
| 131 | capture | 01a19d33-b80d-74d3-97dd-f4efef8bef46 | €24.00 | €0.37 | matched |
| 132 | capture | 01a19d33-be9c-74d3-8ee2-967fbb24970c | €49.00 | €0.67 | matched |
| 133 | capture | 01a19d33-d2ba-7459-8cd8-66cc8a58c6e0 | €24.00 | €0.37 | matched |
| 134 | capture | 01a19d33-daac-7474-b8b1-755f20534523 | €49.00 | €0.67 | matched |
| 135 | refund | 01a19d33-e368-78e9-bb2a-2ee1eac5d7a7 | -€4.00 | €0.00 | matched |
| 136 | capture | 01a19d33-fe95-76e1-a42c-37860a60cc9d | €49.00 | €0.67 | matched |
| 137 | capture | 01a19d33-ffc3-7ee7-913d-52602f100b97 | €15.00 | €0.26 | matched |
| 138 | capture | 01a19d34-0bff-712d-ac41-14813ed4c882 | €24.00 | €0.37 | matched |