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
- 15 Oct, 02:40109 lines2 breaks
- 15 Oct, 02:30137 lines1 break
- 15 Oct, 02:20120 lines2 breaks
- 15 Oct, 02:10102 lines4 breaks
- 15 Oct, 02:00139 lines2 breaks
- 15 Oct, 01:50145 lines4 breaks
- 15 Oct, 01:40147 lines7 breaks
- 15 Oct, 01:30122 lines1 break
- 15 Oct, 01:20118 lines3 breaks
- 15 Oct, 01:10122 lines2 breaks
- 15 Oct, 01:00130 lines2 breaks
- 15 Oct, 00:50129 lines4 breaks
- 15 Oct, 00:40120 lines2 breaks
- 15 Oct, 00:30137 lines3 breaks
15 Oct, 01:20
Gross
€2,745.00
PSP fee
€42.75
Net to the bank
€2,702.25
Settlement journal
#6098
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13d29-de02-7f6a-b536-918c61f4d4e0 is already settled by stl_EUR_2986712 line 61
- fee differencethe fee is not the contract feethe fee is 31, the contract says 26
- missing linein the books, not in the filecapture:01a13d29-aa03-70f2-bb52-4042d5e676f8 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 62 | capture | 01a13d29-de67-73f2-bef5-804345feb8ec | €24.00 | €0.37 | duplicate line |
| 111 | capture | 01a13d2d-9b28-71d2-be0f-22c7e9eb134d | €15.00 | €0.31 | fee difference |
| 1 | capture | 01a13d1b-e795-7a6e-9851-360f0b8d0b85 | €24.00 | €0.37 | matched |
| 2 | capture | 01a13d1e-7144-7adf-9060-c78393886827 | €24.00 | €0.37 | matched |
| 3 | capture | 01a13d1f-c582-7474-a5af-ec92b478f0a8 | €9.00 | €0.19 | matched |
| 4 | capture | 01a13d20-943c-7cd0-9ae8-7fcde132d83e | €35.00 | €0.50 | matched |
| 5 | capture | 01a13d25-1eed-7574-b227-9acc8905cad1 | €35.00 | €0.50 | matched |
| 6 | capture | 01a13d25-3f5e-77ac-8c68-d8e2a2fefc66 | €35.00 | €0.50 | matched |
| 7 | capture | 01a13d25-701b-76ba-b5ff-647f14be703a | €49.00 | €0.67 | matched |
| 8 | capture | 01a13d25-8205-7e75-8b93-9ff7cc7ca511 | €15.00 | €0.26 | matched |
| 9 | capture | 01a13d25-8673-77b6-91d8-604b61bd27e4 | €24.00 | €0.37 | matched |
| 10 | capture | 01a13d25-8719-72fc-a3c5-a24e4d2eef3b | €35.00 | €0.50 | matched |
| 11 | capture | 01a13d25-8cba-78c7-b50d-98dd2f06c42d | €15.00 | €0.26 | matched |
| 12 | capture | 01a13d25-9de4-7614-a5a5-20c4050d8421 | €35.00 | €0.50 | matched |
| 13 | refund | 01a13d25-b43e-7087-9d7d-64d8e18894ff | -€5.00 | €0.00 | matched |
| 14 | refund | 01a13d25-c345-7b48-bf4b-c9f577c784b1 | -€10.00 | €0.00 | matched |
| 15 | capture | 01a13d25-f878-77b1-835c-2a685019f20f | €24.00 | €0.37 | matched |
| 16 | capture | 01a13d25-fec8-7667-bf7d-c6bad1b77b68 | €24.00 | €0.37 | matched |
| 17 | capture | 01a13d26-2325-736f-a6d3-f02e62ae217d | €24.00 | €0.37 | matched |
| 18 | capture | 01a13d26-2f8c-71c1-9ca0-fff9d24d18b4 | €24.00 | €0.37 | matched |
| 19 | capture | 01a13d26-31be-7cef-8b29-47d193654e52 | €9.00 | €0.19 | matched |
| 20 | capture | 01a13d26-4544-76fa-9bbf-cd7d504cde1f | €9.00 | €0.19 | matched |
| 21 | capture | 01a13d26-6da4-7760-a6da-f54f80d45287 | €49.00 | €0.67 | matched |
| 22 | capture | 01a13d26-de5c-72b0-b237-afa2804942b3 | €15.00 | €0.26 | matched |
| 23 | capture | 01a13d27-1c20-72d5-9aae-700c7547161e | €35.00 | €0.50 | matched |
| 24 | capture | 01a13d27-22a0-75b9-8031-13113b7f15ea | €49.00 | €0.67 | matched |
| 25 | capture | 01a13d27-461d-7396-8107-10f092a71593 | €35.00 | €0.50 | matched |
| 26 | capture | 01a13d27-490d-74b3-b35c-0c8e494c8020 | €35.00 | €0.50 | matched |
| 27 | capture | 01a13d27-5ef2-7085-9159-d892d2973f2b | €9.00 | €0.19 | matched |
| 28 | capture | 01a13d27-91b0-700f-b3f1-a0b5b459df23 | €49.00 | €0.67 | matched |
| 29 | capture | 01a13d27-998f-7c28-8e34-ca46f3df2d85 | €35.00 | €0.50 | matched |
| 30 | capture | 01a13d27-9a6b-7cb3-bb3d-c9253ea2df04 | €49.00 | €0.67 | matched |
| 31 | capture | 01a13d27-b107-76db-8d4c-f3721c2ba945 | €15.00 | €0.26 | matched |
| 32 | capture | 01a13d27-b1c2-7ef5-85d8-191674e4faa5 | €9.00 | €0.19 | matched |
| 33 | capture | 01a13d27-c712-72fc-82cb-a00766408654 | €49.00 | €0.67 | matched |
| 34 | capture | 01a13d27-c732-76c2-bdfa-2ddfe12a259c | €15.00 | €0.26 | matched |
| 35 | refund | 01a13d27-ebb4-76fc-aa6f-28639e0c5b29 | -€7.00 | €0.00 | matched |
| 36 | capture | 01a13d27-ef4e-7008-ac88-e6e065111872 | €24.00 | €0.37 | matched |
| 37 | capture | 01a13d28-0673-70b8-96fb-9291dba88fbe | €35.00 | €0.50 | matched |
| 38 | refund | 01a13d28-5d1b-7406-97a7-dd5de3a284d1 | -€14.00 | €0.00 | matched |
| 39 | capture | 01a13d28-615a-7208-939a-55e605845d97 | €35.00 | €0.50 | matched |
| 40 | capture | 01a13d28-5cc3-713e-889e-6e6e151c2873 | €35.00 | €0.50 | matched |
| 41 | capture | 01a13d28-7894-7454-a4b9-1731234650f6 | €9.00 | €0.19 | matched |
| 42 | capture | 01a13d28-79a7-7172-a6cc-efa8ac1b7eca | €9.00 | €0.19 | matched |
| 43 | capture | 01a13d28-8ee0-79af-813f-63e1b4fd3aab | €9.00 | €0.19 | matched |
| 44 | capture | 01a13d28-90f7-7963-96cf-b6a05f5302ac | €15.00 | €0.26 | matched |
| 45 | capture | 01a13d28-d982-7f5c-b64f-f5e92e446e4f | €35.00 | €0.50 | matched |
| 46 | capture | 01a13d28-f14c-7db3-a8ef-6108bbc9cb41 | €9.00 | €0.19 | matched |
| 47 | capture | 01a13d28-f3fa-7552-9541-f5df0c871801 | €9.00 | €0.19 | matched |
| 48 | capture | 01a13d29-10ff-78d4-8764-5ba99e2cc283 | €35.00 | €0.50 | matched |
| 49 | capture | 01a13d29-172a-74a3-bc16-1870016756d9 | €49.00 | €0.67 | matched |
| 50 | capture | 01a13d29-1efb-7244-aba0-75570de58f8c | €35.00 | €0.50 | matched |
| 51 | capture | 01a13d29-2301-7001-af50-93a5b50eb21b | €49.00 | €0.67 | matched |
| 52 | capture | 01a13d29-389a-792a-b7bc-45fac122d775 | €24.00 | €0.37 | matched |
| 53 | capture | 01a13d29-4ea1-7992-8433-fe2a3f6ca383 | €15.00 | €0.26 | matched |
| 54 | capture | 01a13d29-598d-764a-be48-3eb2a058fe85 | €24.00 | €0.37 | matched |
| 55 | capture | 01a13d29-6f32-712d-937f-6ee5d5ff6454 | €9.00 | €0.19 | matched |
| 56 | capture | 01a13d29-780f-74ef-ba50-4d718d41cc69 | €15.00 | €0.26 | matched |
| 57 | capture | 01a13d29-7aeb-7da4-ad07-68fa310cb923 | €35.00 | €0.50 | matched |
| 58 | capture | 01a13d29-a653-79b4-ae85-89d9bc573737 | €15.00 | €0.26 | matched |
| 59 | capture | 01a13d29-abd3-7f1c-9423-1e51056f0bef | €49.00 | €0.67 | matched |
| 60 | capture | 01a13d29-c1f9-7765-a366-72b098dba4d9 | €24.00 | €0.37 | matched |
| 61 | capture | 01a13d29-de67-73f2-bef5-804345feb8ec | €24.00 | €0.37 | matched |
| 63 | capture | 01a13d29-e738-7b4a-bea0-4e49206fbba1 | €35.00 | €0.50 | matched |
| 64 | refund | 01a13d29-f7d9-797c-9eb9-184e96032235 | -€8.00 | €0.00 | matched |
| 65 | capture | 01a13d29-fa83-7a71-91d7-5d9b580772cf | €35.00 | €0.50 | matched |
| 66 | capture | 01a13d29-fdb4-7078-a4d5-7702943d2f6f | €35.00 | €0.50 | matched |
| 67 | capture | 01a13d29-ffca-7845-84c8-c9675013d623 | €15.00 | €0.26 | matched |
| 68 | capture | 01a13d2a-086c-7581-9f03-f9b344e0b8fc | €9.00 | €0.19 | matched |
| 69 | capture | 01a13d2a-2c87-7606-86a4-8fcb76017861 | €35.00 | €0.50 | matched |
| 70 | capture | 01a13d2a-3fc6-734a-a70f-304374415fa3 | €24.00 | €0.37 | matched |
| 71 | capture | 01a13d2a-4e20-719c-9b25-c0072f84d9ae | €9.00 | €0.19 | matched |
| 72 | capture | 01a13d2a-8918-791e-8fd2-fffcc6bdb955 | €24.00 | €0.37 | matched |
| 73 | capture | 01a13d2a-9cc2-7130-8893-28741f929124 | €15.00 | €0.26 | matched |
| 74 | capture | 01a13d2a-da0c-7f78-9260-8ed3925ec1e9 | €49.00 | €0.67 | matched |
| 75 | capture | 01a13d2a-dc1d-7207-bad5-52e85eb88c93 | €35.00 | €0.50 | matched |
| 76 | capture | 01a13d2a-fa70-7030-9f31-ef0b85fc098b | €49.00 | €0.67 | matched |
| 77 | capture | 01a13d2a-fb0e-7279-acc4-d7cbb886f333 | €15.00 | €0.26 | matched |
| 78 | capture | 01a13d2b-1192-788e-995d-a00239183c32 | €9.00 | €0.19 | matched |
| 79 | capture | 01a13d2b-2098-781d-8282-55f14bba9744 | €15.00 | €0.26 | matched |
| 80 | capture | 01a13d2b-22ec-7057-bcd9-60e34bdb05aa | €15.00 | €0.26 | matched |
| 81 | capture | 01a13d2b-6f95-7296-89b9-e50e8e2d6922 | €9.00 | €0.19 | matched |
| 82 | capture | 01a13d2b-7e87-72b0-90d2-8f1a0467a453 | €49.00 | €0.67 | matched |
| 83 | capture | 01a13d2b-8fe5-7f86-a8a4-da0f9a5be32f | €24.00 | €0.37 | matched |
| 84 | capture | 01a13d2b-cfec-785d-9b8a-f7156a7f0790 | €35.00 | €0.50 | matched |
| 85 | capture | 01a13d2b-f342-7618-aae6-475c1f5e2348 | €9.00 | €0.19 | matched |
| 86 | capture | 01a13d2b-fab2-7df8-8533-e5019a330dcb | €35.00 | €0.50 | matched |
| 87 | capture | 01a13d2c-0c4e-76fc-80ab-dc85b4ce31d3 | €24.00 | €0.37 | matched |
| 88 | capture | 01a13d2c-1858-7098-9db6-49a025d3014f | €9.00 | €0.19 | matched |
| 89 | capture | 01a13d2c-1f31-7ad1-be78-ee50fb1efea4 | €24.00 | €0.37 | matched |
| 90 | capture | 01a13d2c-2ea0-769e-90c4-f8a81311fb0d | €24.00 | €0.37 | matched |
| 91 | capture | 01a13d2c-435f-7317-9f24-d8ba0e50570f | €35.00 | €0.50 | matched |
| 92 | capture | 01a13d2c-4d50-7344-bd50-4e92222fd9d1 | €9.00 | €0.19 | matched |
| 93 | capture | 01a13d2c-590d-77ac-8a3a-1ee713ed89c0 | €9.00 | €0.19 | matched |
| 94 | capture | 01a13d2c-6583-7dc6-a96c-cce7abfa7ce6 | €15.00 | €0.26 | matched |
| 95 | capture | 01a13d2c-7c73-7723-989e-a3490eb86921 | €49.00 | €0.67 | matched |
| 96 | capture | 01a13d2c-85ab-70ce-94ce-c7e80350692f | €9.00 | €0.19 | matched |
| 97 | capture | 01a13d2c-95d3-7fe9-a004-93a07d84744c | €24.00 | €0.37 | matched |
| 98 | capture | 01a13d2c-aa2e-7be0-92b9-32f333bebe56 | €49.00 | €0.67 | matched |
| 99 | capture | 01a13d2c-bb86-7f45-876d-f3f1351348de | €9.00 | €0.19 | matched |
| 100 | capture | 01a13d2c-c14a-7378-9303-c81a4303cb11 | €35.00 | €0.50 | matched |
| 101 | refund | 01a13d2c-eb2d-7227-be0a-0985d24d0ee0 | -€14.00 | €0.00 | matched |
| 102 | capture | 01a13d2c-fde0-7f0f-a9e8-ff90963be5c3 | €15.00 | €0.26 | matched |
| 103 | capture | 01a13d2d-0fb0-78f1-b6cf-5324a7df3c79 | €24.00 | €0.37 | matched |
| 104 | capture | 01a13d2d-33cf-741d-b747-14c8df9fa42f | €35.00 | €0.50 | matched |
| 105 | capture | 01a13d2d-40ae-7584-a100-297780cdcbea | €24.00 | €0.37 | matched |
| 106 | capture | 01a13d2d-67d9-7ae8-912f-4a4901314d15 | €35.00 | €0.50 | matched |
| 107 | capture | 01a13d2d-6c0e-75d4-8793-a40f8f4f91c3 | €24.00 | €0.37 | matched |
| 108 | capture | 01a13d2d-7a9c-70f8-abb8-671fcad7839e | €15.00 | €0.26 | matched |
| 109 | capture | 01a13d2d-8d74-79ed-a13f-7e3a3d22cf46 | €15.00 | €0.26 | matched |
| 110 | capture | 01a13d2d-9955-778d-9d64-4e3a7d2db64b | €24.00 | €0.37 | matched |
| 112 | capture | 01a13d2d-c678-70f6-8b24-3b116e22ecfb | €9.00 | €0.19 | matched |
| 113 | capture | 01a13d2d-d897-7473-90f5-da6ab66da495 | €35.00 | €0.50 | matched |
| 114 | capture | 01a13d2d-e539-7f5c-af81-62f29cfadcdc | €9.00 | €0.19 | matched |
| 115 | capture | 01a13d2e-0610-77e2-aee4-65013560ea62 | €35.00 | €0.50 | matched |
| 116 | capture | 01a13d2e-06e3-7c69-a41c-4c8f2e46da20 | €24.00 | €0.37 | matched |
| 117 | capture | 01a13d2e-21f6-7f42-97b2-e8d7b67ee83e | €15.00 | €0.26 | matched |
| 118 | refund | 01a13d2e-2a2f-7ac4-bea6-346ca8df0120 | -€5.00 | €0.00 | matched |