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, 12:10119 lines5 breaks
- 3 Nov, 12:00122 lines1 break
- 3 Nov, 11:50136 lines5 breaks
- 3 Nov, 11:40144 lines4 breaks
- 3 Nov, 11:30110 lines1 break
- 3 Nov, 11:20109 lines1 break
- 3 Nov, 11:10110 lines1 break
- 3 Nov, 11:00120 lines4 breaks
- 3 Nov, 10:5095 lines1 break
- 3 Nov, 10:40126 lines2 breaks
- 3 Nov, 10:30111 lines2 breaks
- 3 Nov, 10:20133 lines2 breaks
- 3 Nov, 10:10106 linesclean
- 3 Nov, 10:00123 lines1 break
3 Nov, 11:00
Gross
€2,935.00
PSP fee
€45.57
Net to the bank
€2,889.43
Settlement journal
#359994
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a114-3e36-77f3-af30-1d941c44c591 is already settled by stl_EUR_2989506 line 56
- missing linein the books, not in the filecapture:01a1a111-7a0d-7a18-b745-194daa43ea3b is in no file
- missing linein the books, not in the filecapture:01a1a112-d610-7dd7-b9e2-0a0622aee748 is in no file
- missing linein the books, not in the filecapture:01a1a113-5d80-7b5f-a7c4-27dc0361dde0 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 57 | capture | 01a1a114-3e76-7178-ba00-0ef520a62ca0 | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a1a10b-33ee-72da-8521-4911f6a56374 | €9.00 | €0.19 | matched |
| 2 | capture | 01a1a10b-e38b-76f2-b11e-26d032e601cd | €15.00 | €0.26 | matched |
| 3 | refund | 01a1a10c-c046-7ed3-ac34-1b063f1febf9 | -€7.00 | €0.00 | matched |
| 4 | capture | 01a1a10c-ea26-7410-9844-657c059d1f76 | €49.00 | €0.67 | matched |
| 5 | capture | 01a1a10d-87c4-7738-92a4-60d98b99b243 | €9.00 | €0.19 | matched |
| 6 | capture | 01a1a110-2e5e-7752-9668-4a947701ad88 | €35.00 | €0.50 | matched |
| 7 | capture | 01a1a111-0533-73d9-82f2-64731b437853 | €15.00 | €0.26 | matched |
| 8 | capture | 01a1a111-0a8c-7033-9d5a-e96b809ae8ee | €35.00 | €0.50 | matched |
| 9 | capture | 01a1a111-2f46-714a-8e89-34166b023f93 | €35.00 | €0.50 | matched |
| 10 | capture | 01a1a111-3534-707b-98c9-313aba3f8ccd | €49.00 | €0.67 | matched |
| 11 | capture | 01a1a111-6aaa-7aaf-a545-d813da9e0c74 | €35.00 | €0.50 | matched |
| 12 | capture | 01a1a111-7807-7c32-b74c-3798298ad6e7 | €9.00 | €0.19 | matched |
| 13 | refund | 01a1a111-82cb-7eea-a2d7-6a69092a3528 | -€19.00 | €0.00 | matched |
| 14 | capture | 01a1a111-ab06-76a4-b8c9-b3f312bda0ba | €49.00 | €0.67 | matched |
| 15 | capture | 01a1a111-b412-78e6-9b52-5a51a8deb768 | €15.00 | €0.26 | matched |
| 16 | capture | 01a1a111-b5ce-769c-84f2-4bc49eafb13d | €15.00 | €0.26 | matched |
| 17 | capture | 01a1a111-c96f-73db-b47a-c10cf816ac9b | €49.00 | €0.67 | matched |
| 18 | capture | 01a1a111-c9c9-7854-a1eb-2f3097ce438c | €9.00 | €0.19 | matched |
| 19 | capture | 01a1a111-d625-797b-8a1e-f1987e2de6cf | €24.00 | €0.37 | matched |
| 20 | refund | 01a1a111-dc92-7a98-8a98-a9c244e8b3e4 | -€35.00 | €0.00 | matched |
| 21 | capture | 01a1a111-e9b6-762f-9156-9c6d7c36bf36 | €49.00 | €0.67 | matched |
| 22 | capture | 01a1a111-f24c-7c48-95d3-edbb8a71ca80 | €35.00 | €0.50 | matched |
| 23 | capture | 01a1a112-07a9-7437-a001-a4c96420448d | €24.00 | €0.37 | matched |
| 24 | capture | 01a1a112-0970-7436-9c1a-089bceb791ea | €49.00 | €0.67 | matched |
| 25 | capture | 01a1a112-1d42-7dc7-b3c8-c2e51788c6d7 | €35.00 | €0.50 | matched |
| 26 | capture | 01a1a112-311f-73af-a7de-315fb79b0323 | €24.00 | €0.37 | matched |
| 27 | capture | 01a1a112-6572-7ffa-8fa1-5c94c265a989 | €24.00 | €0.37 | matched |
| 28 | capture | 01a1a112-6684-7926-a083-6461e86f6a97 | €49.00 | €0.67 | matched |
| 29 | capture | 01a1a112-6843-72e2-aeb1-cacb243f928f | €35.00 | €0.50 | matched |
| 30 | capture | 01a1a112-6ec6-70b3-a2ee-2db738835f4f | €9.00 | €0.19 | matched |
| 31 | capture | 01a1a112-8ac8-70c1-9ac5-4c0695d7807b | €24.00 | €0.37 | matched |
| 32 | capture | 01a1a112-9372-7e52-b2c9-19441e9ee2ce | €15.00 | €0.26 | matched |
| 33 | capture | 01a1a112-9380-7659-be90-ad31a6e70d5c | €9.00 | €0.19 | matched |
| 34 | capture | 01a1a112-b668-71fc-b600-f9eb10277226 | €35.00 | €0.50 | matched |
| 35 | capture | 01a1a112-c2e6-73c4-a01a-42125799304b | €35.00 | €0.50 | matched |
| 36 | capture | 01a1a112-c3e7-71e2-818f-47888e3eff3c | €9.00 | €0.19 | matched |
| 37 | capture | 01a1a112-d93b-7db1-8692-b2e3b225e35b | €24.00 | €0.37 | matched |
| 38 | capture | 01a1a112-e063-7443-a30e-b001c94234bb | €15.00 | €0.26 | matched |
| 39 | capture | 01a1a112-e588-77b5-b6e1-10dac440dfa1 | €49.00 | €0.67 | matched |
| 40 | capture | 01a1a112-e99f-73ef-b502-c5bb4cb82ccf | €15.00 | €0.26 | matched |
| 41 | capture | 01a1a112-f228-7059-bcd1-91db31e9cdd8 | €35.00 | €0.50 | matched |
| 42 | capture | 01a1a112-f486-75fd-b6d4-2912bcbf8087 | €15.00 | €0.26 | matched |
| 43 | capture | 01a1a112-f689-764a-bd05-2d7cd3670265 | €9.00 | €0.19 | matched |
| 44 | capture | 01a1a113-2358-740f-9905-329b0c77afe8 | €35.00 | €0.50 | matched |
| 45 | capture | 01a1a113-2c84-7f85-91f1-c8cd55160556 | €24.00 | €0.37 | matched |
| 46 | capture | 01a1a113-33d2-727d-be81-2b11cd6d804b | €15.00 | €0.26 | matched |
| 47 | capture | 01a1a113-3650-76cb-b16d-2829aa03dfee | €35.00 | €0.50 | matched |
| 48 | capture | 01a1a113-7264-779f-8c20-42115b9ea46b | €24.00 | €0.37 | matched |
| 49 | capture | 01a1a113-7bd0-7f73-b398-32ba7ee3b79e | €24.00 | €0.37 | matched |
| 50 | capture | 01a1a113-8954-7c75-9396-f576cad17acd | €15.00 | €0.26 | matched |
| 51 | capture | 01a1a113-c260-79e2-91c5-7a7a686aaee0 | €24.00 | €0.37 | matched |
| 52 | capture | 01a1a113-b9d4-7632-9bda-149f8765ede1 | €35.00 | €0.50 | matched |
| 53 | refund | 01a1a113-f0bc-7613-a237-2b0f15be206d | -€11.00 | €0.00 | matched |
| 54 | capture | 01a1a114-053d-7047-adf8-88d319a67597 | €35.00 | €0.50 | matched |
| 55 | capture | 01a1a114-266c-7605-8e52-39e10d240c69 | €9.00 | €0.19 | matched |
| 56 | capture | 01a1a114-3e76-7178-ba00-0ef520a62ca0 | €24.00 | €0.37 | matched |
| 58 | capture | 01a1a114-4ec0-77cb-8d05-81228c4a846f | €49.00 | €0.67 | matched |
| 59 | capture | 01a1a114-6388-7941-b2db-1098f5a7fd25 | €35.00 | €0.50 | matched |
| 60 | capture | 01a1a114-7b75-701f-a920-1e6b2656b6b9 | €9.00 | €0.19 | matched |
| 61 | capture | 01a1a114-8837-7c64-a0c1-390df06f644d | €15.00 | €0.26 | matched |
| 62 | capture | 01a1a114-9446-7161-b775-93c0c430dada | €9.00 | €0.19 | matched |
| 63 | capture | 01a1a114-aadc-7617-a44e-d41ebec79582 | €24.00 | €0.37 | matched |
| 64 | capture | 01a1a114-bee8-763b-adc3-6905b05ad0ac | €24.00 | €0.37 | matched |
| 65 | capture | 01a1a114-c100-71ed-8970-b3c65e92cdf8 | €49.00 | €0.67 | matched |
| 66 | capture | 01a1a114-c166-7a88-846d-132b091cda09 | €15.00 | €0.26 | matched |
| 67 | capture | 01a1a114-c1bb-73e5-b5dc-a6b8c3de7d12 | €35.00 | €0.50 | matched |
| 68 | refund | 01a1a114-f1dc-7dd9-bd51-1cfa3092fa66 | -€8.00 | €0.00 | matched |
| 69 | capture | 01a1a114-ffff-76b3-b872-ea5ed4bd7093 | €49.00 | €0.67 | matched |
| 70 | capture | 01a1a115-0224-78c5-8612-7291ff123aa2 | €15.00 | €0.26 | matched |
| 71 | capture | 01a1a115-3985-7a03-968e-2e44dffac76e | €49.00 | €0.67 | matched |
| 72 | capture | 01a1a115-5800-7e90-b7b7-c8f7adfd9999 | €15.00 | €0.26 | matched |
| 73 | capture | 01a1a115-588b-7217-8b1e-b495bf4adc32 | €15.00 | €0.26 | matched |
| 74 | capture | 01a1a115-81ee-7935-bdf9-dce6ac36d08a | €9.00 | €0.19 | matched |
| 75 | capture | 01a1a115-b64d-7479-84bd-e34bd35ffe08 | €35.00 | €0.50 | matched |
| 76 | capture | 01a1a115-f693-7d35-a5af-b3cf58559792 | €24.00 | €0.37 | matched |
| 77 | capture | 01a1a116-4dba-747b-bc33-880e74cc0421 | €49.00 | €0.67 | matched |
| 78 | capture | 01a1a116-fc27-75b8-8c33-42c985d08179 | €35.00 | €0.50 | matched |
| 79 | capture | 01a1a117-0376-7101-9a1f-ff25de4e6c6a | €24.00 | €0.37 | matched |
| 80 | capture | 01a1a117-21c3-7b95-8b93-e21778fd367d | €15.00 | €0.26 | matched |
| 81 | capture | 01a1a117-31fe-7e75-b85e-8e94a24d9aa5 | €35.00 | €0.50 | matched |
| 82 | capture | 01a1a117-41e2-78bc-b71a-45709e3b245a | €35.00 | €0.50 | matched |
| 83 | capture | 01a1a117-5483-7fd1-b873-b467e82c4de7 | €9.00 | €0.19 | matched |
| 84 | capture | 01a1a117-55f1-74b3-b3c4-61e983723222 | €49.00 | €0.67 | matched |
| 85 | capture | 01a1a117-59a3-7fa7-9bad-ce2b78bc329a | €9.00 | €0.19 | matched |
| 86 | capture | 01a1a117-6f2a-7e9d-8e04-4bc9a45b1381 | €9.00 | €0.19 | matched |
| 87 | capture | 01a1a117-709e-7832-8928-c3c8d7d9be77 | €9.00 | €0.19 | matched |
| 88 | capture | 01a1a117-861d-73c2-8347-b7bc9339305d | €9.00 | €0.19 | matched |
| 89 | capture | 01a1a117-9edb-7dd3-a944-31f29355d363 | €49.00 | €0.67 | matched |
| 90 | capture | 01a1a117-a5b6-7517-93ff-c8ed47967135 | €35.00 | €0.50 | matched |
| 91 | refund | 01a1a117-ac82-7180-8fdb-8d05bc96e40b | -€5.00 | €0.00 | matched |
| 92 | capture | 01a1a117-cee0-7d54-ab14-a6f92aa09192 | €15.00 | €0.26 | matched |
| 93 | capture | 01a1a117-d876-7e69-ab0f-0f54981bd682 | €35.00 | €0.50 | matched |
| 94 | capture | 01a1a117-dbda-7661-9b67-12d4f2f23199 | €9.00 | €0.19 | matched |
| 95 | capture | 01a1a117-dd2b-77d9-8336-9aba4c2d6cae | €9.00 | €0.19 | matched |
| 96 | capture | 01a1a118-1a71-7574-aef8-ee7cd7162a22 | €24.00 | €0.37 | matched |
| 97 | capture | 01a1a118-1f84-7e15-8a5c-2768c9e72acc | €35.00 | €0.50 | matched |
| 98 | capture | 01a1a118-2c06-7834-8fb5-681b90a47816 | €35.00 | €0.50 | matched |
| 99 | capture | 01a1a118-56a5-72b9-ab2b-a06c9f1bb1a4 | €35.00 | €0.50 | matched |
| 100 | capture | 01a1a118-7d07-797c-bd08-ae3ed988e525 | €49.00 | €0.67 | matched |
| 101 | capture | 01a1a118-7380-7961-8864-0753f95ea060 | €35.00 | €0.50 | matched |
| 102 | capture | 01a1a118-8775-78fc-87fe-0c876c72b35c | €49.00 | €0.67 | matched |
| 103 | capture | 01a1a118-9539-752b-a1a0-f2d3489a2305 | €49.00 | €0.67 | matched |
| 104 | capture | 01a1a118-9855-7db7-ace9-d4d4b7978ba9 | €35.00 | €0.50 | matched |
| 105 | capture | 01a1a118-9b1e-7fbd-88af-a4e60f72af75 | €15.00 | €0.26 | matched |
| 106 | capture | 01a1a118-beed-7cac-838d-9571cead7a7d | €9.00 | €0.19 | matched |
| 107 | capture | 01a1a119-32b6-754b-8b3c-e4b8b29839de | €15.00 | €0.26 | matched |
| 108 | capture | 01a1a119-3996-75bf-a4c9-a6c7e13a24d3 | €49.00 | €0.67 | matched |
| 109 | capture | 01a1a119-46f5-7326-8b10-7d76917cd888 | €35.00 | €0.50 | matched |
| 110 | capture | 01a1a119-4704-7e0f-87d2-24f01557154b | €9.00 | €0.19 | matched |
| 111 | capture | 01a1a119-9744-7575-9c7d-e9b41cac0085 | €24.00 | €0.37 | matched |
| 112 | capture | 01a1a119-a994-76bf-899b-2f7b5d6139f5 | €15.00 | €0.26 | matched |
| 113 | capture | 01a1a119-b406-78e1-b798-c2c669be1f60 | €35.00 | €0.50 | matched |
| 114 | capture | 01a1a119-caf9-7d3e-9beb-1287a305a8c0 | €49.00 | €0.67 | matched |
| 115 | refund | 01a1a119-d724-74fb-adcf-abce2d966f19 | -€14.00 | €0.00 | matched |
| 116 | capture | 01a1a119-d7d1-746e-8010-c1773bc1c22d | €35.00 | €0.50 | matched |
| 117 | capture | 01a1a119-dd66-7943-89b9-fb265819a9bf | €35.00 | €0.50 | matched |
| 118 | capture | 01a1a119-e597-769f-a012-4bdf572929e6 | €9.00 | €0.19 | matched |
| 119 | capture | 01a1a119-e7f3-7a19-acfa-66d982498061 | €15.00 | €0.26 | matched |
| 120 | capture | 01a1a119-fdc5-7ef4-9d00-b43490c471d5 | €24.00 | €0.37 | matched |