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
- 3 Nov, 16:40140 lines2 breaks
- 3 Nov, 16:30108 lines2 breaks
- 3 Nov, 16:20117 lines3 breaks
- 3 Nov, 16:10138 lines2 breaks
- 3 Nov, 16:00109 lines1 break
- 3 Nov, 15:50147 lines5 breaks
- 3 Nov, 15:40140 lines2 breaks
- 3 Nov, 15:30144 lines6 breaks
- 3 Nov, 15:20114 linesclean
- 3 Nov, 15:10130 lines6 breaks
- 3 Nov, 15:00120 lines1 break
- 3 Nov, 14:50127 lines5 breaks
- 3 Nov, 14:40123 lines2 breaks
- 3 Nov, 14:30125 lines2 breaks
3 Nov, 15:30
Gross
€3,032.00
PSP fee
€49.28
Net to the bank
€2,982.72
Settlement journal
#363382
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a20d-a09e-7317-bd6c-f45246096cba is already settled by stl_EUR_2989533 line 78
- fee differencethe fee is not the contract feethe fee is 22, the contract says 19
- fee differencethe fee is not the contract feethe fee is 23, the contract says 19
- missing linein the books, not in the filecapture:01a1a208-1dae-7283-9f59-9310a63387c7 is in no file
- missing linein the books, not in the filerefund:01a1a20b-f6ad-7ec1-9155-c0d9719f2b2a is in no file
- missing linein the books, not in the filecapture:01a1a20a-8ea0-7528-899a-551cfe3e78ba is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 72 | capture | 01a1a20d-052a-7072-99a0-d111f55cb148 | €9.00 | €0.22 | fee difference |
| 79 | capture | 01a1a20d-a52d-7ea0-bd9f-487154c30a21 | €15.00 | €0.26 | duplicate line |
| 84 | capture | 01a1a20d-e734-77f5-bb8b-6b32241664a2 | €9.00 | €0.23 | fee difference |
| 1 | capture | 01a1a1ff-794e-70b4-8a97-765a62807821 | €49.00 | €0.67 | matched |
| 2 | capture | 01a1a200-db82-7c03-ae22-aba5624c8d9e | €35.00 | €0.50 | matched |
| 3 | capture | 01a1a202-598f-765e-ad30-ce23ecc8e274 | €24.00 | €0.37 | matched |
| 4 | refund | 01a1a202-5996-7f85-acb0-004781e5f8cb | -€15.00 | €0.00 | matched |
| 5 | capture | 01a1a208-18cd-72eb-acb1-f358679b7617 | €35.00 | €0.50 | matched |
| 6 | capture | 01a1a208-37a4-73e4-8614-b954288abf62 | €9.00 | €0.19 | matched |
| 7 | capture | 01a1a208-3c3f-719d-aebd-3ae4f4d69c72 | €24.00 | €0.37 | matched |
| 8 | capture | 01a1a208-4f5e-70e4-a3af-95af3c275ba0 | €15.00 | €0.26 | matched |
| 9 | capture | 01a1a208-73b9-7123-acf0-c2a75b901be3 | €49.00 | €0.67 | matched |
| 10 | capture | 01a1a208-7874-7fde-8a2f-feac769ab966 | €24.00 | €0.37 | matched |
| 11 | capture | 01a1a208-8a08-7101-964e-0ed190e79a86 | €9.00 | €0.19 | matched |
| 12 | capture | 01a1a208-93c0-7b7d-b4b7-267b4db389b9 | €24.00 | €0.37 | matched |
| 13 | capture | 01a1a208-a03d-79f6-bd01-130fb031af16 | €35.00 | €0.50 | matched |
| 14 | refund | 01a1a208-a220-76e8-b270-19f1189cb726 | -€37.00 | €0.00 | matched |
| 15 | capture | 01a1a208-b7f5-7f34-b083-9ff17969ea7c | €15.00 | €0.26 | matched |
| 16 | capture | 01a1a208-b697-78e1-b3cc-7171c9c6e99c | €35.00 | €0.50 | matched |
| 17 | capture | 01a1a208-bd26-7e8f-9a43-80894451f35e | €35.00 | €0.50 | matched |
| 18 | refund | 01a1a209-0751-7785-9b1d-bc079e56aa6b | -€11.00 | €0.00 | matched |
| 19 | capture | 01a1a209-1891-7d85-a42d-2f34e7ebe6bf | €35.00 | €0.50 | matched |
| 20 | capture | 01a1a209-3f8a-796a-9650-e8733abae6dd | €35.00 | €0.50 | matched |
| 21 | capture | 01a1a209-4486-7411-bf54-ed1fb6ac962a | €24.00 | €0.37 | matched |
| 22 | capture | 01a1a209-7507-7f1f-81b3-b1e71e13f98f | €9.00 | €0.19 | matched |
| 23 | capture | 01a1a209-847f-781e-b09a-f0b997f587da | €15.00 | €0.26 | matched |
| 24 | capture | 01a1a209-93a8-7feb-be0e-9dbff35d8332 | €49.00 | €0.67 | matched |
| 25 | capture | 01a1a209-a1a9-7948-9796-a305e62ba5d5 | €24.00 | €0.37 | matched |
| 26 | capture | 01a1a209-b2d2-7e58-af1c-2bf3b12d6fb9 | €24.00 | €0.37 | matched |
| 27 | capture | 01a1a209-ca8a-7a1b-82fb-83d43a717c79 | €35.00 | €0.50 | matched |
| 28 | capture | 01a1a209-d030-7d40-9199-9d4ec3a57e00 | €24.00 | €0.37 | matched |
| 29 | refund | 01a1a209-d0fd-78ff-aca6-9ec8c2246b37 | -€24.00 | €0.00 | matched |
| 30 | capture | 01a1a209-dba3-7ec3-8036-6701fb74f01b | €35.00 | €0.50 | matched |
| 31 | capture | 01a1a209-e21d-7057-b6e1-f0ca96d37f55 | €49.00 | €0.67 | matched |
| 32 | capture | 01a1a209-e8a9-779a-97af-cae6bafb7f03 | €15.00 | €0.26 | matched |
| 33 | capture | 01a1a20a-0501-77e8-85ec-062459c6e728 | €49.00 | €0.67 | matched |
| 34 | capture | 01a1a20a-069f-796c-a314-f357bf9fe930 | €15.00 | €0.26 | matched |
| 35 | capture | 01a1a20a-1842-7d8f-acdc-f0feaf354bd3 | €9.00 | €0.19 | matched |
| 36 | capture | 01a1a20a-2be2-7129-bbc2-ccc872b4132f | €24.00 | €0.37 | matched |
| 37 | capture | 01a1a20a-2c1f-7db3-967f-f9cb0d92102f | €15.00 | €0.26 | matched |
| 38 | capture | 01a1a20a-3f1c-7044-9293-93be2f3cbe24 | €15.00 | €0.26 | matched |
| 39 | refund | 01a1a20a-5c57-76ac-bc16-9673291f2380 | -€9.00 | €0.00 | matched |
| 40 | capture | 01a1a20a-5e32-7f4a-bd26-89ecdd537db0 | €35.00 | €0.50 | matched |
| 41 | capture | 01a1a20a-6e02-7c05-922e-14e640dbaafe | €9.00 | €0.19 | matched |
| 42 | capture | 01a1a20a-7a0b-76a8-9fbc-4b636bc07bd0 | €15.00 | €0.26 | matched |
| 43 | capture | 01a1a20a-adaf-7866-95f2-ee9404e90bae | €35.00 | €0.50 | matched |
| 44 | capture | 01a1a20a-b91d-7110-90fd-0fc22436f0ba | €15.00 | €0.26 | matched |
| 45 | capture | 01a1a20b-025a-784a-bc3e-d39e24738884 | €9.00 | €0.19 | matched |
| 46 | capture | 01a1a20b-0ba9-7c94-aca9-2bd06d147357 | €15.00 | €0.26 | matched |
| 47 | capture | 01a1a20b-1588-75dd-8342-ffb378ddc83e | €9.00 | €0.19 | matched |
| 48 | capture | 01a1a20b-424c-7d81-ac2c-fb493f031446 | €49.00 | €0.67 | matched |
| 49 | capture | 01a1a20b-7f0d-77d9-ad03-656f7714d6cd | €24.00 | €0.37 | matched |
| 50 | capture | 01a1a20b-8727-7e0d-ae2a-8548de846065 | €24.00 | €0.37 | matched |
| 51 | capture | 01a1a20b-8ccf-7282-ac9f-31f3d284947d | €9.00 | €0.19 | matched |
| 52 | capture | 01a1a20b-96bb-7478-b445-710f96047a25 | €9.00 | €0.19 | matched |
| 53 | capture | 01a1a20b-9a79-72cc-b0cc-3502a9c2de11 | €49.00 | €0.67 | matched |
| 54 | capture | 01a1a20b-9e77-7e41-b12f-4f3cb5c9b9f6 | €15.00 | €0.26 | matched |
| 55 | capture | 01a1a20b-af9d-7c9d-be39-8b0cca4631bd | €49.00 | €0.67 | matched |
| 56 | capture | 01a1a20b-d4af-7ca0-af93-cf3eb39c57e7 | €9.00 | €0.19 | matched |
| 57 | capture | 01a1a20b-d172-75a4-8442-19db29f5eafc | €15.00 | €0.26 | matched |
| 58 | capture | 01a1a20b-f031-7f06-a4b7-904df3f76d8c | €24.00 | €0.37 | matched |
| 59 | capture | 01a1a20c-2e39-7c0b-ba0c-af37218dea66 | €15.00 | €0.26 | matched |
| 60 | capture | 01a1a20c-426c-719f-b79d-647eacf46636 | €24.00 | €0.37 | matched |
| 61 | capture | 01a1a20c-5898-7f42-b314-3dd96dc03fc8 | €49.00 | €0.67 | matched |
| 62 | capture | 01a1a20c-6af4-7d9c-bf6a-93ebc369f0bd | €49.00 | €0.67 | matched |
| 63 | capture | 01a1a20c-791f-7679-b5ce-22a5325e5822 | €24.00 | €0.37 | matched |
| 64 | capture | 01a1a20c-8595-7de3-b256-523e2a937f58 | €9.00 | €0.19 | matched |
| 65 | capture | 01a1a20c-b3bb-7e31-b5c2-1664f2ecbdcf | €35.00 | €0.50 | matched |
| 66 | capture | 01a1a20c-b9a5-7ee0-87ee-7853adbc94d5 | €9.00 | €0.19 | matched |
| 67 | capture | 01a1a20c-bfdc-7f2c-a5bc-b891215ab294 | €15.00 | €0.26 | matched |
| 68 | capture | 01a1a20c-eb10-7614-b1f8-1563e7736d6c | €24.00 | €0.37 | matched |
| 69 | capture | 01a1a20c-ecca-790a-bfd5-561722cc144e | €24.00 | €0.37 | matched |
| 70 | capture | 01a1a20c-ee1e-7a00-84ea-2722f07de487 | €24.00 | €0.37 | matched |
| 71 | capture | 01a1a20c-f877-7547-9e7c-e38bc36aaf0d | €24.00 | €0.37 | matched |
| 73 | capture | 01a1a20d-0882-74c4-9c98-3f367ed03fc0 | €24.00 | €0.37 | matched |
| 74 | capture | 01a1a20d-1df8-7a06-9048-c4cb21c89b85 | €9.00 | €0.19 | matched |
| 75 | capture | 01a1a20d-5126-73ad-beb9-20736574a645 | €49.00 | €0.67 | matched |
| 76 | capture | 01a1a20d-60e0-7149-a86e-7c907b3fd4d7 | €35.00 | €0.50 | matched |
| 77 | refund | 01a1a20d-92ae-74c2-927d-6a5ba0523dc0 | -€18.00 | €0.00 | matched |
| 78 | capture | 01a1a20d-a52d-7ea0-bd9f-487154c30a21 | €15.00 | €0.26 | matched |
| 80 | capture | 01a1a20d-c688-704e-a2b3-b6ec297400cc | €9.00 | €0.19 | matched |
| 81 | capture | 01a1a20d-c9fa-79f1-90d2-28c2b77151a1 | €35.00 | €0.50 | matched |
| 82 | capture | 01a1a20d-d5f5-7712-a69c-04461cddd96d | €9.00 | €0.19 | matched |
| 83 | capture | 01a1a20d-d778-75dd-bd35-2f12dc3a16d9 | €9.00 | €0.19 | matched |
| 85 | capture | 01a1a20d-fdd3-7da7-80c1-80370f8ef01c | €9.00 | €0.19 | matched |
| 86 | capture | 01a1a20e-0a5a-77a0-bef0-4dc4d6bf7d7e | €24.00 | €0.37 | matched |
| 87 | capture | 01a1a20e-4087-7f89-8d57-317a83ee16cf | €24.00 | €0.37 | matched |
| 88 | capture | 01a1a20e-4580-7362-b510-40de94da3b15 | €49.00 | €0.67 | matched |
| 89 | capture | 01a1a20e-54a2-79be-a24e-1e269fc5294a | €15.00 | €0.26 | matched |
| 90 | capture | 01a1a20e-56d7-7fd3-8606-27b173929f3c | €15.00 | €0.26 | matched |
| 91 | refund | 01a1a20e-6228-726d-a33e-b628cf0955cb | -€5.00 | €0.00 | matched |
| 92 | capture | 01a1a20e-6519-7d3a-b212-5ce4e74a4d45 | €15.00 | €0.26 | matched |
| 93 | capture | 01a1a20e-78a6-74de-b160-d90bbf51b75e | €9.00 | €0.19 | matched |
| 94 | capture | 01a1a20e-79f4-7e66-be5a-e4dec555b3d1 | €15.00 | €0.26 | matched |
| 95 | capture | 01a1a20e-8153-759d-b2e4-262e45f26429 | €24.00 | €0.37 | matched |
| 96 | capture | 01a1a20e-9174-7845-a3b3-217e55b453a8 | €24.00 | €0.37 | matched |
| 97 | capture | 01a1a20e-a7e2-70d6-9adc-23ffd4f6a701 | €15.00 | €0.26 | matched |
| 98 | capture | 01a1a20e-af9d-7c13-8bb5-4804e42c7b2c | €24.00 | €0.37 | matched |
| 99 | capture | 01a1a20e-b2ce-73b0-bf15-2f8773594495 | €15.00 | €0.26 | matched |
| 100 | capture | 01a1a20e-d1dd-7f66-9d0a-f2106e297211 | €49.00 | €0.67 | matched |
| 101 | capture | 01a1a20e-d1f2-7713-87af-3aeab9328f44 | €35.00 | €0.50 | matched |
| 102 | refund | 01a1a20e-de88-73b4-b05c-1ec63fc6cf3a | -€12.00 | €0.00 | matched |
| 103 | capture | 01a1a20e-e6a4-78e0-b9cc-3ed148167745 | €15.00 | €0.26 | matched |
| 104 | capture | 01a1a20e-ecfd-7d4e-914c-edab95d5f892 | €35.00 | €0.50 | matched |
| 105 | capture | 01a1a20e-ef1e-764b-b581-8c6ed03ff6f2 | €15.00 | €0.26 | matched |
| 106 | capture | 01a1a20e-f308-7fa6-89ca-1abb5ec321b3 | €15.00 | €0.26 | matched |
| 107 | capture | 01a1a20f-0652-7b3b-8ef8-c93ad78586c4 | €49.00 | €0.67 | matched |
| 108 | capture | 01a1a20f-1167-710c-a6da-8a12c645fab8 | €49.00 | €0.67 | matched |
| 109 | capture | 01a1a20f-1f01-74ef-b16f-0f6857eb53f1 | €35.00 | €0.50 | matched |
| 110 | capture | 01a1a20f-2476-76a8-8c1d-5a45c15ecf8d | €24.00 | €0.37 | matched |
| 111 | capture | 01a1a20f-2e70-74a7-86b9-e1d3a83915d4 | €49.00 | €0.67 | matched |
| 112 | capture | 01a1a20f-3cd0-7dfb-bfd4-1caab180814a | €49.00 | €0.67 | matched |
| 113 | capture | 01a1a20f-7313-78f0-aea9-516fa1e64b41 | €15.00 | €0.26 | matched |
| 114 | capture | 01a1a20f-7860-7788-adfd-b42a23b4ce1c | €24.00 | €0.37 | matched |
| 115 | capture | 01a1a20f-87e1-752a-ba9a-e8b2b564b76d | €15.00 | €0.26 | matched |
| 116 | capture | 01a1a20f-8a2d-7d6e-ab27-c561a40e8630 | €9.00 | €0.19 | matched |
| 117 | capture | 01a1a20f-9081-7cd9-b503-1a1aeb8e74be | €15.00 | €0.26 | matched |
| 118 | capture | 01a1a20f-9474-7c47-80f6-2ba90cf26bef | €15.00 | €0.26 | matched |
| 119 | capture | 01a1a20f-a7cd-7f4c-91f0-cbae3907e810 | €9.00 | €0.19 | matched |
| 120 | capture | 01a1a20f-be6c-7a0b-b087-fca64dc78be2 | €35.00 | €0.50 | matched |
| 121 | capture | 01a1a20f-d5ab-7fc8-87ca-c20088062f33 | €15.00 | €0.26 | matched |
| 122 | refund | 01a1a20f-e962-725b-8bec-e3169028d875 | -€24.00 | €0.00 | matched |
| 123 | capture | 01a1a210-041a-75e5-868d-7a23ba8ee1cd | €24.00 | €0.37 | matched |
| 124 | capture | 01a1a210-37de-7462-baaa-40e6ccf59791 | €35.00 | €0.50 | matched |
| 125 | capture | 01a1a210-388f-7dab-8669-6052a0f49612 | €15.00 | €0.26 | matched |
| 126 | capture | 01a1a210-608c-7ce1-8434-e438815ab252 | €9.00 | €0.19 | matched |
| 127 | capture | 01a1a210-6c2f-76e9-a77f-60baf4bcd8ef | €35.00 | €0.50 | matched |
| 128 | capture | 01a1a210-6fa7-72df-8cf9-24aabdc36d11 | €15.00 | €0.26 | matched |
| 129 | capture | 01a1a210-7da9-76a9-a338-a43daafe396f | €15.00 | €0.26 | matched |
| 130 | capture | 01a1a210-7e23-7c7c-931f-2ab1051fa600 | €24.00 | €0.37 | matched |
| 131 | capture | 01a1a210-843d-7b4b-9ea6-4f199fa4c6a2 | €15.00 | €0.26 | matched |
| 132 | capture | 01a1a210-8bd7-7e0c-ae62-25fb331c5b44 | €49.00 | €0.67 | matched |
| 133 | capture | 01a1a210-a29a-74de-96a8-c7ba84fc40eb | €9.00 | €0.19 | matched |
| 134 | capture | 01a1a210-acb0-7583-8db8-ed235e980403 | €15.00 | €0.26 | matched |
| 135 | refund | 01a1a210-b22a-7cf3-a5a5-ad7cf2acca27 | -€9.00 | €0.00 | matched |
| 136 | capture | 01a1a210-b275-7415-85c5-fa8e6015f62b | €9.00 | €0.19 | matched |
| 137 | capture | 01a1a210-b6df-77eb-b7d5-73572e177ef1 | €9.00 | €0.19 | matched |
| 138 | refund | 01a1a210-c6c7-7d2b-8b92-73a2562623f2 | -€6.00 | €0.00 | matched |
| 139 | refund | 01a1a210-ec51-7d7f-a6c4-d2e8012d6527 | -€6.00 | €0.00 | matched |
| 140 | capture | 01a1a211-0cca-7c88-b19d-0542093e7579 | €49.00 | €0.67 | matched |
| 141 | capture | 01a1a211-1f38-7317-96b8-412557de2c69 | €49.00 | €0.67 | matched |
| 142 | capture | 01a1a211-2b43-7147-a24c-c633a17fc3f1 | €24.00 | €0.37 | matched |
| 143 | capture | 01a1a211-3195-755b-991d-f510fb509402 | €49.00 | €0.67 | matched |
| 144 | capture | 01a1a211-3500-781b-a05b-db3d5f49d997 | €24.00 | €0.37 | matched |