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
- 18 Oct, 14:00120 lines2 breaks
- 18 Oct, 13:50139 lines2 breaks
- 18 Oct, 13:40123 lines7 breaks
- 18 Oct, 13:30117 lines6 breaks
- 18 Oct, 13:20105 lines1 break
- 18 Oct, 13:10129 lines2 breaks
- 18 Oct, 13:00117 lines4 breaks
- 18 Oct, 12:50127 lines1 break
- 18 Oct, 12:40114 lines5 breaks
- 18 Oct, 12:30139 lines1 break
- 18 Oct, 12:20133 lines1 break
- 18 Oct, 12:10139 lines4 breaks
- 18 Oct, 12:00119 lines1 break
- 18 Oct, 11:50146 lines2 breaks
18 Oct, 12:40
Gross
€2,796.00
PSP fee
€43.48
Net to the bank
€2,752.52
Settlement journal
#69590
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a14f07-dc63-7bd1-9fe6-6143de9bd7df is already settled by stl_EUR_2987212 line 20
- duplicate linethe file lists it twicecapture:01a14f0f-7bb2-7ed4-8900-38b6e251f918 is already settled by stl_EUR_2987212 line 107
- fee differencethe fee is not the contract feethe fee is 40, the contract says 37
- fee differencethe fee is not the contract feethe fee is 24, the contract says 19
- missing linein the books, not in the filecapture:01a14f09-8e5d-7a80-9d2b-5cb5d37e5de2 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 21 | refund | 01a14f07-dc92-733f-b156-c9d1b2eb7424 | -€7.00 | €0.00 | duplicate line |
| 70 | capture | 01a14f0c-689c-7f78-a325-08c085850f2b | €24.00 | €0.40 | fee difference |
| 98 | capture | 01a14f0e-cbcd-76eb-9a8b-6fa6e3623289 | €9.00 | €0.24 | fee difference |
| 108 | capture | 01a14f0f-7bf8-7688-b11d-8ad9659f1f4a | €15.00 | €0.26 | duplicate line |
| 1 | capture | 01a14f01-cd64-70b4-a3df-3afb942c059c | €24.00 | €0.37 | matched |
| 2 | capture | 01a14f04-2e89-775e-918b-168ddb0a12e4 | €24.00 | €0.37 | matched |
| 3 | capture | 01a14f04-4ff2-78b6-a1ca-139bfaf93139 | €24.00 | €0.37 | matched |
| 4 | capture | 01a14f05-73ed-7299-8194-44d9c8e27431 | €9.00 | €0.19 | matched |
| 5 | capture | 01a14f06-be68-7471-853b-396faec036cb | €35.00 | €0.50 | matched |
| 6 | capture | 01a14f06-de15-764f-8179-54a064189b50 | €15.00 | €0.26 | matched |
| 7 | capture | 01a14f06-ef6f-75d5-acf4-9d25c6c9e2d7 | €49.00 | €0.67 | matched |
| 8 | capture | 01a14f06-fa9e-724a-a1b6-12ebbbad2bbc | €35.00 | €0.50 | matched |
| 9 | capture | 01a14f07-39b4-7816-8220-d51a54b86c97 | €9.00 | €0.19 | matched |
| 10 | capture | 01a14f07-4f61-7f83-bf2b-09134fe02be2 | €24.00 | €0.37 | matched |
| 11 | capture | 01a14f07-606e-73e4-aac5-451c871e41a6 | €15.00 | €0.26 | matched |
| 12 | capture | 01a14f07-6def-7165-821a-403b37b9990c | €9.00 | €0.19 | matched |
| 13 | capture | 01a14f07-7c81-78d9-9952-3054bfe66a23 | €35.00 | €0.50 | matched |
| 14 | capture | 01a14f07-8a93-7edb-ad8c-5d48915115dd | €49.00 | €0.67 | matched |
| 15 | capture | 01a14f07-970e-7246-8b54-efae09a6f6fa | €35.00 | €0.50 | matched |
| 16 | capture | 01a14f07-9f0d-7586-9701-93b7cc1f686f | €24.00 | €0.37 | matched |
| 17 | capture | 01a14f07-a67a-723c-9f05-5b39444f0c19 | €24.00 | €0.37 | matched |
| 18 | capture | 01a14f07-a6c7-7ed7-ab8d-fb08e01f1fbb | €49.00 | €0.67 | matched |
| 19 | capture | 01a14f07-d1b0-7053-82ba-6ca552a98928 | €9.00 | €0.19 | matched |
| 20 | refund | 01a14f07-dc92-733f-b156-c9d1b2eb7424 | -€7.00 | €0.00 | matched |
| 22 | refund | 01a14f07-ec8e-7f0a-802a-621165d76571 | -€17.00 | €0.00 | matched |
| 23 | capture | 01a14f07-efb6-7121-ae00-b239e1160bc9 | €15.00 | €0.26 | matched |
| 24 | refund | 01a14f07-f4af-7f4a-943d-e0d0508c1d2c | -€23.00 | €0.00 | matched |
| 25 | capture | 01a14f07-fdf4-7f06-af1c-4a410e1526f4 | €9.00 | €0.19 | matched |
| 26 | capture | 01a14f08-5b34-7007-af9e-f4df5ee5d160 | €15.00 | €0.26 | matched |
| 27 | capture | 01a14f08-64ef-70ab-b603-58a5887b9e84 | €35.00 | €0.50 | matched |
| 28 | capture | 01a14f08-ac0c-7904-afa9-3644122e31a2 | €24.00 | €0.37 | matched |
| 29 | capture | 01a14f08-d039-76ea-9e22-b2080ba03c3c | €15.00 | €0.26 | matched |
| 30 | capture | 01a14f08-dfab-7fba-973b-c097a117ea62 | €35.00 | €0.50 | matched |
| 31 | capture | 01a14f08-e20c-725b-886d-ad2e47962079 | €15.00 | €0.26 | matched |
| 32 | capture | 01a14f09-09e1-74e5-a316-005e79407fcb | €24.00 | €0.37 | matched |
| 33 | capture | 01a14f09-14c4-7962-b334-517e9e0382b1 | €35.00 | €0.50 | matched |
| 34 | capture | 01a14f09-2c56-7886-a784-790ada0b9a3e | €35.00 | €0.50 | matched |
| 35 | capture | 01a14f09-550a-7014-b8e2-c740ebeb5e4c | €15.00 | €0.26 | matched |
| 36 | capture | 01a14f09-5a90-7522-9644-cfc5983f1125 | €15.00 | €0.26 | matched |
| 37 | capture | 01a14f09-7c8c-7187-8e52-c4bd146b8b41 | €49.00 | €0.67 | matched |
| 38 | capture | 01a14f09-c731-7f0d-816b-2c9d01b12606 | €49.00 | €0.67 | matched |
| 39 | capture | 01a14f09-e1a0-7bd3-9492-fe0c01eededa | €15.00 | €0.26 | matched |
| 40 | capture | 01a14f09-e865-77cd-abc2-4a0fff5d491b | €49.00 | €0.67 | matched |
| 41 | capture | 01a14f09-ee7c-7e28-b9a1-319e4966c59e | €9.00 | €0.19 | matched |
| 42 | capture | 01a14f09-f5a3-7c27-a326-a21bcf6beb26 | €24.00 | €0.37 | matched |
| 43 | capture | 01a14f0a-09d5-77d0-971b-f32456063507 | €9.00 | €0.19 | matched |
| 44 | capture | 01a14f0a-22a2-7d28-9564-1c602d244a68 | €9.00 | €0.19 | matched |
| 45 | refund | 01a14f0a-269a-76f1-ab6a-3e353bf1ee37 | -€19.00 | €0.00 | matched |
| 46 | capture | 01a14f0a-30b1-7d70-9e0d-4ab60e10b3dd | €35.00 | €0.50 | matched |
| 47 | capture | 01a14f0a-51c8-728f-b6f3-812e4a80d305 | €9.00 | €0.19 | matched |
| 48 | capture | 01a14f0a-6a07-736b-b60d-8be5276af515 | €35.00 | €0.50 | matched |
| 49 | capture | 01a14f0a-7038-70b4-9c6b-5806308abe8a | €24.00 | €0.37 | matched |
| 50 | capture | 01a14f0a-bb55-7c2d-b764-3e049b943977 | €49.00 | €0.67 | matched |
| 51 | capture | 01a14f0a-bf56-7b48-bbe4-505a267ac950 | €24.00 | €0.37 | matched |
| 52 | capture | 01a14f0a-f1d1-760e-8c01-9675b2d24c79 | €15.00 | €0.26 | matched |
| 53 | capture | 01a14f0a-f401-74da-887b-203d7bfbbd52 | €9.00 | €0.19 | matched |
| 54 | capture | 01a14f0a-fb2f-77fc-a5f7-1f9c544c8fcc | €9.00 | €0.19 | matched |
| 55 | capture | 01a14f0b-18ec-7c6b-92d4-c075bbedb887 | €9.00 | €0.19 | matched |
| 56 | capture | 01a14f0b-21ea-72b9-acd3-dcd532ceba67 | €15.00 | €0.26 | matched |
| 57 | capture | 01a14f0b-2278-7790-bba5-87cc070c6973 | €24.00 | €0.37 | matched |
| 58 | capture | 01a14f0b-362b-75b1-9393-c590983b447b | €9.00 | €0.19 | matched |
| 59 | refund | 01a14f0b-5af2-74f4-bdf9-15e0da15d1e9 | -€14.00 | €0.00 | matched |
| 60 | capture | 01a14f0b-5fcd-731c-a84b-b72b9d0ede75 | €49.00 | €0.67 | matched |
| 61 | capture | 01a14f0b-989e-782a-b8f5-797b3a4614b6 | €35.00 | €0.50 | matched |
| 62 | capture | 01a14f0b-b089-7510-b0b2-84b0ee8506f0 | €49.00 | €0.67 | matched |
| 63 | capture | 01a14f0b-b747-7783-8b7b-4b2a75606947 | €35.00 | €0.50 | matched |
| 64 | capture | 01a14f0b-c56e-7178-8051-47845af249f7 | €9.00 | €0.19 | matched |
| 65 | capture | 01a14f0b-d584-7704-a6df-2d4f1e96592b | €9.00 | €0.19 | matched |
| 66 | capture | 01a14f0b-e4ca-7435-8929-59fa1bd28ff2 | €35.00 | €0.50 | matched |
| 67 | capture | 01a14f0b-ee91-781e-8cd7-0d0cad8f9626 | €49.00 | €0.67 | matched |
| 68 | refund | 01a14f0c-2a04-7f78-acbf-e34d88f3b1b7 | -€9.00 | €0.00 | matched |
| 69 | capture | 01a14f0c-47e0-75a9-a793-aa43e79db25f | €49.00 | €0.67 | matched |
| 71 | capture | 01a14f0c-7b5e-710c-bace-46153bc783f0 | €35.00 | €0.50 | matched |
| 72 | capture | 01a14f0c-938b-7205-b46c-18fdd45e4b8f | €24.00 | €0.37 | matched |
| 73 | capture | 01a14f0c-9cb2-7a67-bfd7-453276eac81f | €35.00 | €0.50 | matched |
| 74 | capture | 01a14f0c-a12d-749a-933a-644bef45e239 | €35.00 | €0.50 | matched |
| 75 | capture | 01a14f0c-a1ed-7f41-9374-f601158573f6 | €15.00 | €0.26 | matched |
| 76 | capture | 01a14f0c-c615-7089-b04d-283f93d6d4af | €24.00 | €0.37 | matched |
| 77 | capture | 01a14f0c-d1cb-725f-bbd1-ff28f9c3490f | €35.00 | €0.50 | matched |
| 78 | capture | 01a14f0c-d4d0-74b7-81d8-61dfa66e4207 | €24.00 | €0.37 | matched |
| 79 | capture | 01a14f0c-d5df-7982-a6b9-8a3f38575746 | €15.00 | €0.26 | matched |
| 80 | capture | 01a14f0d-21fb-7f8e-b00e-7dfceffe0113 | €49.00 | €0.67 | matched |
| 81 | capture | 01a14f0d-6b12-7f40-9644-e65203583b21 | €15.00 | €0.26 | matched |
| 82 | capture | 01a14f0d-7b4c-7f1a-bf02-23b7ee14a190 | €15.00 | €0.26 | matched |
| 83 | capture | 01a14f0d-a119-745a-9f71-6647032418ba | €49.00 | €0.67 | matched |
| 84 | refund | 01a14f0d-ab89-7fd1-9bf4-0dded231ad11 | -€8.00 | €0.00 | matched |
| 85 | capture | 01a14f0d-a4c9-7b80-9103-945bbfd92322 | €35.00 | €0.50 | matched |
| 86 | capture | 01a14f0d-b24a-7748-9abf-59a16fd62f84 | €15.00 | €0.26 | matched |
| 87 | capture | 01a14f0d-f376-7e29-bd0e-a3a06346dd37 | €49.00 | €0.67 | matched |
| 88 | capture | 01a14f0e-0972-787a-9288-15c521bb9710 | €35.00 | €0.50 | matched |
| 89 | capture | 01a14f0e-1500-7fac-bec8-50f25d23a3b9 | €15.00 | €0.26 | matched |
| 90 | capture | 01a14f0e-212e-757d-b749-2a943864971a | €35.00 | €0.50 | matched |
| 91 | capture | 01a14f0e-25f6-7c97-bb26-2fb96eeae24d | €15.00 | €0.26 | matched |
| 92 | capture | 01a14f0e-3577-7111-9b92-c69b97387c84 | €49.00 | €0.67 | matched |
| 93 | capture | 01a14f0e-4684-79ee-96d4-f3466d048dab | €15.00 | €0.26 | matched |
| 94 | capture | 01a14f0e-5c3b-7da1-8c70-fec1cbd76307 | €49.00 | €0.67 | matched |
| 95 | capture | 01a14f0e-5d0c-72f6-aae2-3df6827c429d | €15.00 | €0.26 | matched |
| 96 | capture | 01a14f0e-7edc-76d0-99b4-29998b365dcf | €24.00 | €0.37 | matched |
| 97 | capture | 01a14f0e-771a-7cab-a301-703932ad8a1d | €49.00 | €0.67 | matched |
| 99 | capture | 01a14f0e-fba9-72d4-be28-44b09bbab0b2 | €49.00 | €0.67 | matched |
| 100 | capture | 01a14f0f-22b6-704c-8a6c-dc401ae2d8af | €35.00 | €0.50 | matched |
| 101 | capture | 01a14f0f-3ae2-7599-a73c-a7814d73b0b9 | €49.00 | €0.67 | matched |
| 102 | capture | 01a14f0f-31af-71d1-9ff9-e1c500e6e1fc | €15.00 | €0.26 | matched |
| 103 | capture | 01a14f0f-4d1d-7df3-8fff-695c21539f8f | €15.00 | €0.26 | matched |
| 104 | capture | 01a14f0f-586a-7210-bc45-60e9fb152144 | €49.00 | €0.67 | matched |
| 105 | capture | 01a14f0f-7129-7c04-9959-b9c1ed7028cf | €49.00 | €0.67 | matched |
| 106 | capture | 01a14f0f-78af-74bb-99a0-322365888cec | €9.00 | €0.19 | matched |
| 107 | capture | 01a14f0f-7bf8-7688-b11d-8ad9659f1f4a | €15.00 | €0.26 | matched |
| 109 | capture | 01a14f0f-7f89-7a4f-954d-1f9a615c383f | €49.00 | €0.67 | matched |
| 110 | capture | 01a14f0f-826d-783f-afe6-a4a965ffe3f7 | €49.00 | €0.67 | matched |
| 111 | capture | 01a14f0f-aba9-76bf-92f4-04d59fad7c33 | €24.00 | €0.37 | matched |
| 112 | capture | 01a14f0f-b251-7929-9a3e-a081d5c153f8 | €9.00 | €0.19 | matched |
| 113 | capture | 01a14f0f-bdf7-7839-810b-7cc183f169ec | €49.00 | €0.67 | matched |
| 114 | capture | 01a14f0f-d3b3-74ba-ae46-d448354a4d40 | €35.00 | €0.50 | matched |