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
- 1 Nov, 13:50132 lines2 breaks
- 1 Nov, 13:40119 lines4 breaks
- 1 Nov, 13:30114 lines3 breaks
- 1 Nov, 13:20127 lines3 breaks
- 1 Nov, 13:10124 linesclean
- 1 Nov, 13:00118 lines2 breaks
- 1 Nov, 12:50132 linesclean
- 1 Nov, 12:40129 lines1 break
- 1 Nov, 12:30146 lines2 breaks
- 1 Nov, 12:20148 lines3 breaks
- 1 Nov, 12:10143 lines2 breaks
- 1 Nov, 12:00113 lines4 breaks
- 1 Nov, 11:50139 lines2 breaks
- 1 Nov, 11:40130 lines5 breaks
1 Nov, 13:00
Gross
€2,814.00
PSP fee
€43.58
Net to the bank
€2,770.42
Settlement journal
#325011
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19736-30a0-7186-94e9-815bb13109aa is already settled by stl_EUR_2989230 line 58
- missing linein the books, not in the filecapture:01a19737-e32c-7778-ab89-b14c9b79d355 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 59 | capture | 01a19736-3149-710c-87b5-75c4b2da0cce | €24.00 | €0.37 | duplicate line |
| 1 | refund | 01a19732-055d-7aa4-ba88-3ec04e98defc | -€3.00 | €0.00 | matched |
| 2 | capture | 01a19732-20bc-7f26-913e-01723d4f78ce | €15.00 | €0.26 | matched |
| 3 | capture | 01a19732-2d66-79a9-85ce-04c309a34f1d | €9.00 | €0.19 | matched |
| 4 | capture | 01a19732-3922-7a8a-a911-f834ed283692 | €49.00 | €0.67 | matched |
| 5 | capture | 01a19732-491d-7591-9aff-ef7531f427d3 | €24.00 | €0.37 | matched |
| 6 | capture | 01a19732-53fa-7ffd-a33b-fd902151d43d | €24.00 | €0.37 | matched |
| 7 | capture | 01a19732-5c35-70f5-9cae-4696a59a00e6 | €9.00 | €0.19 | matched |
| 8 | capture | 01a19732-6227-7a49-a395-b57d9525d893 | €24.00 | €0.37 | matched |
| 9 | capture | 01a19732-6739-7b2f-aa92-69f1971e1d95 | €15.00 | €0.26 | matched |
| 10 | capture | 01a19732-74d9-7430-a28d-ce26c52db4e4 | €35.00 | €0.50 | matched |
| 11 | capture | 01a19732-7791-733a-bdeb-ea4a4d82bc18 | €9.00 | €0.19 | matched |
| 12 | capture | 01a19732-7878-7855-8b8b-3f1a322ae744 | €49.00 | €0.67 | matched |
| 13 | capture | 01a19732-8f92-776f-b3d3-776cc5316728 | €24.00 | €0.37 | matched |
| 14 | refund | 01a19732-b4a1-76a6-b3ec-92a3f7417f05 | -€12.00 | €0.00 | matched |
| 15 | refund | 01a19732-b5e8-73f4-9937-f43e330751ff | -€7.00 | €0.00 | matched |
| 16 | capture | 01a19732-b8c1-7001-a6b3-62f9c17200bc | €9.00 | €0.19 | matched |
| 17 | capture | 01a19732-e9ca-7cdb-941b-60f5c372caa0 | €9.00 | €0.19 | matched |
| 18 | capture | 01a19733-2891-792c-990b-ac8beec4a2fc | €49.00 | €0.67 | matched |
| 19 | capture | 01a19733-3086-78ba-92bf-aeb7197545de | €24.00 | €0.37 | matched |
| 20 | capture | 01a19733-3730-7872-8858-8fab3f1f40a8 | €35.00 | €0.50 | matched |
| 21 | capture | 01a19733-50fc-708f-95fb-4f6937c42f56 | €24.00 | €0.37 | matched |
| 22 | capture | 01a19733-534e-77bd-902c-153d3245146f | €15.00 | €0.26 | matched |
| 23 | capture | 01a19733-6967-7fd5-981e-736c98b37dbf | €15.00 | €0.26 | matched |
| 24 | refund | 01a19733-9697-75d7-a88c-a243730b9326 | -€7.00 | €0.00 | matched |
| 25 | capture | 01a19733-9d98-716e-b600-6dce2de3cad3 | €35.00 | €0.50 | matched |
| 26 | capture | 01a19733-b7d9-7e46-872c-ba3f5d23d74a | €9.00 | €0.19 | matched |
| 27 | capture | 01a19733-c681-7505-9471-f4fbd6303195 | €35.00 | €0.50 | matched |
| 28 | capture | 01a19733-cccb-72a1-97a9-c92952389e0d | €35.00 | €0.50 | matched |
| 29 | capture | 01a19733-f199-7e0b-93c0-fdc6aad15059 | €9.00 | €0.19 | matched |
| 30 | capture | 01a19733-f473-7d07-82d2-b74791a6adfc | €49.00 | €0.67 | matched |
| 31 | capture | 01a19734-0a2c-7d8e-b8bc-ef521ce999cf | €49.00 | €0.67 | matched |
| 32 | capture | 01a19734-2e15-7ca5-92fe-45e4f254b146 | €9.00 | €0.19 | matched |
| 33 | capture | 01a19734-3f8c-7c44-b245-7771a56a18ce | €24.00 | €0.37 | matched |
| 34 | capture | 01a19734-5049-7060-84d3-18f8dc571bd8 | €49.00 | €0.67 | matched |
| 35 | capture | 01a19734-65cb-76e3-9d5f-ec33df0918e8 | €49.00 | €0.67 | matched |
| 36 | capture | 01a19734-71fb-7112-9bad-81ab7cfa40ee | €49.00 | €0.67 | matched |
| 37 | capture | 01a19734-748f-7a02-b4fb-3975dba0e209 | €15.00 | €0.26 | matched |
| 38 | capture | 01a19734-caba-749f-9596-289128b6d906 | €35.00 | €0.50 | matched |
| 39 | capture | 01a19734-cee5-7277-8135-5d5dccd06e68 | €24.00 | €0.37 | matched |
| 40 | capture | 01a19734-eb7b-791a-84f9-3a2458e8426e | €35.00 | €0.50 | matched |
| 41 | capture | 01a19734-fde3-7de1-b485-d3e0e5e95ea2 | €24.00 | €0.37 | matched |
| 42 | capture | 01a19735-0037-7c29-8932-0ba8af07dc66 | €24.00 | €0.37 | matched |
| 43 | capture | 01a19735-048d-70b6-90e5-3b6e2f305350 | €9.00 | €0.19 | matched |
| 44 | capture | 01a19735-0d36-7933-99e3-0cd0283b7054 | €9.00 | €0.19 | matched |
| 45 | capture | 01a19735-4061-7ee2-9bd8-6652d2a1f39d | €9.00 | €0.19 | matched |
| 46 | refund | 01a19735-4825-797d-abb7-a3777f228cad | -€6.00 | €0.00 | matched |
| 47 | capture | 01a19735-6ab3-7d5d-8721-e6f87ab195b2 | €24.00 | €0.37 | matched |
| 48 | capture | 01a19735-8593-79f9-b026-298f12d31143 | €49.00 | €0.67 | matched |
| 49 | capture | 01a19735-9680-79ac-a0e1-b8f4252167a1 | €35.00 | €0.50 | matched |
| 50 | capture | 01a19735-a7d6-7347-9b62-144d7e5f1729 | €24.00 | €0.37 | matched |
| 51 | capture | 01a19735-b286-7530-9ec1-14d6f0ca17e1 | €49.00 | €0.67 | matched |
| 52 | capture | 01a19735-b983-7900-8839-feadc0075c95 | €9.00 | €0.19 | matched |
| 53 | capture | 01a19735-c3eb-77ac-918a-aed35cfb62bc | €35.00 | €0.50 | matched |
| 54 | capture | 01a19735-cdc5-7e25-8f25-731fec91fa73 | €49.00 | €0.67 | matched |
| 55 | capture | 01a19735-b7a2-7fa1-ad1a-47db8d07c697 | €9.00 | €0.19 | matched |
| 56 | capture | 01a19736-0ef1-78f1-a03e-775c79214199 | €49.00 | €0.67 | matched |
| 57 | refund | 01a19736-3049-7eea-a6e7-23feb8abe65b | -€8.00 | €0.00 | matched |
| 58 | capture | 01a19736-3149-710c-87b5-75c4b2da0cce | €24.00 | €0.37 | matched |
| 60 | capture | 01a19736-43ff-7894-a9d4-153e92764621 | €49.00 | €0.67 | matched |
| 61 | capture | 01a19736-48d9-7a91-acaa-b01ba3501fa7 | €9.00 | €0.19 | matched |
| 62 | capture | 01a19736-4d7f-7e88-a577-af13ec6f7bd5 | €9.00 | €0.19 | matched |
| 63 | capture | 01a19736-5907-7e84-b607-3a1bff3c7037 | €9.00 | €0.19 | matched |
| 64 | capture | 01a19736-6abe-7cb8-85f8-93578b613930 | €24.00 | €0.37 | matched |
| 65 | capture | 01a19736-6fc2-7917-ad6f-96979678b2d0 | €49.00 | €0.67 | matched |
| 66 | capture | 01a19736-711e-7188-9832-746455357959 | €9.00 | €0.19 | matched |
| 67 | capture | 01a19736-7bea-7ca4-bb2f-6a9c642b8591 | €9.00 | €0.19 | matched |
| 68 | capture | 01a19736-9345-797a-889f-56b05065c64b | €24.00 | €0.37 | matched |
| 69 | capture | 01a19736-a760-7e52-a83f-3f71dd123f00 | €24.00 | €0.37 | matched |
| 70 | capture | 01a19736-ab3e-70fa-9bb1-297bcb9b3776 | €24.00 | €0.37 | matched |
| 71 | capture | 01a19736-c2b5-7dc4-8c7e-00312f6b3ebc | €9.00 | €0.19 | matched |
| 72 | refund | 01a19736-c30b-7910-82da-90a01aa51d04 | -€3.00 | €0.00 | matched |
| 73 | capture | 01a19736-d2ad-7910-9ba7-38e00e4b2738 | €9.00 | €0.19 | matched |
| 74 | capture | 01a19736-d7fe-7b3b-9abf-dc105be9177e | €24.00 | €0.37 | matched |
| 75 | capture | 01a19736-e1a5-7f2e-83e9-994a0fa828a4 | €35.00 | €0.50 | matched |
| 76 | capture | 01a19737-1b5d-751c-bcee-ba7b1f8d2ea8 | €49.00 | €0.67 | matched |
| 77 | capture | 01a19737-2dad-72c8-ab06-590f3638a162 | €9.00 | €0.19 | matched |
| 78 | capture | 01a19737-453f-749e-ba15-3fe4da5a456d | €15.00 | €0.26 | matched |
| 79 | capture | 01a19737-53f3-72e9-8801-d91eed62a893 | €35.00 | €0.50 | matched |
| 80 | refund | 01a19737-7de3-73ae-859f-225bb43bbd84 | -€5.00 | €0.00 | matched |
| 81 | capture | 01a19737-897d-7e7f-8b28-8e7a60a05d94 | €9.00 | €0.19 | matched |
| 82 | capture | 01a19737-a151-75c8-bafb-ae266a148b94 | €49.00 | €0.67 | matched |
| 83 | capture | 01a19737-d9fe-7622-979a-4fa77ae63670 | €24.00 | €0.37 | matched |
| 84 | capture | 01a19737-df0f-7e3f-bca1-5d65dccc6ac2 | €35.00 | €0.50 | matched |
| 85 | capture | 01a19737-ec4b-74fb-a8ae-d75ad5e70cbb | €9.00 | €0.19 | matched |
| 86 | capture | 01a19737-ede9-7a96-a057-692367746614 | €24.00 | €0.37 | matched |
| 87 | capture | 01a19737-f10b-752d-abdf-45ac34e3256a | €15.00 | €0.26 | matched |
| 88 | capture | 01a19738-19c4-7f47-8166-ca7ac1d5141f | €9.00 | €0.19 | matched |
| 89 | capture | 01a19738-1f9b-7a31-b903-6d70f907be1c | €35.00 | €0.50 | matched |
| 90 | capture | 01a19738-26f2-73cb-ab93-4c0cf54a3fac | €15.00 | €0.26 | matched |
| 91 | capture | 01a19738-c919-73a6-ad03-6262964b94eb | €15.00 | €0.26 | matched |
| 92 | capture | 01a19738-e82d-7a2d-a8fe-8f942b0189cc | €35.00 | €0.50 | matched |
| 93 | capture | 01a19739-2ea6-736e-af73-cb480ff899c8 | €49.00 | €0.67 | matched |
| 94 | capture | 01a19739-630d-7295-8ed1-7543094d4a3c | €9.00 | €0.19 | matched |
| 95 | capture | 01a19739-6ad1-78fc-89c0-11793c717b87 | €35.00 | €0.50 | matched |
| 96 | capture | 01a19739-6b46-728c-90ab-3c906833332c | €49.00 | €0.67 | matched |
| 97 | capture | 01a19739-7b91-7d25-a00b-f8b94c9f814b | €24.00 | €0.37 | matched |
| 98 | capture | 01a19739-96eb-7045-82a5-55afd5b92f2c | €15.00 | €0.26 | matched |
| 99 | capture | 01a19739-aa39-766c-962d-70e14233970b | €35.00 | €0.50 | matched |
| 100 | capture | 01a19739-b439-703f-bbe4-fa5dddf43988 | €15.00 | €0.26 | matched |
| 101 | capture | 01a19739-f9bb-7a8b-a9e3-918385d869e5 | €15.00 | €0.26 | matched |
| 102 | capture | 01a1973a-290b-7583-9a11-f279a3232832 | €24.00 | €0.37 | matched |
| 103 | capture | 01a1973a-3814-7716-a203-3f8a3aa6001f | €49.00 | €0.67 | matched |
| 104 | capture | 01a1973a-3e15-7e62-8f5b-cb28be83a86f | €49.00 | €0.67 | matched |
| 105 | capture | 01a1973a-444f-7e1b-a191-b9966f68e5ff | €35.00 | €0.50 | matched |
| 106 | capture | 01a1973a-5dcf-7851-a248-79ab52b42e85 | €35.00 | €0.50 | matched |
| 107 | capture | 01a1973a-74d3-77d1-b1e1-56f0443171b3 | €49.00 | €0.67 | matched |
| 108 | capture | 01a1973a-7aac-7707-8d51-e5b5dbba9661 | €24.00 | €0.37 | matched |
| 109 | capture | 01a1973a-7bce-7f26-993a-13a6c4537b1f | €15.00 | €0.26 | matched |
| 110 | capture | 01a1973a-8c3e-7476-92df-154451f3caf7 | €24.00 | €0.37 | matched |
| 111 | capture | 01a1973a-93f7-7622-a4fb-9f21ddf5c104 | €24.00 | €0.37 | matched |
| 112 | capture | 01a1973a-c40a-70f1-bda8-308a5e31a2e7 | €9.00 | €0.19 | matched |
| 113 | capture | 01a1973a-db4e-7c85-908d-8251ce638436 | €49.00 | €0.67 | matched |
| 114 | refund | 01a1973a-ea3f-7665-a0c9-7abe2c1cf131 | -€27.00 | €0.00 | matched |
| 115 | capture | 01a1973a-fe33-742e-a723-4dec1390769c | €49.00 | €0.67 | matched |
| 116 | capture | 01a1973b-09ea-7981-a6c5-be384b3ed968 | €9.00 | €0.19 | matched |
| 117 | capture | 01a1973b-15f9-7aa4-9514-c9c480609e95 | €49.00 | €0.67 | matched |
| 118 | capture | 01a1973b-1ecc-75f3-bbf7-9cbd6b4aa6b4 | €24.00 | €0.37 | matched |