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
- 20 Oct, 12:00123 linesclean
- 20 Oct, 11:50115 lines2 breaks
- 20 Oct, 11:40127 lines3 breaks
- 20 Oct, 11:30133 lines4 breaks
- 20 Oct, 11:20115 lines1 break
- 20 Oct, 11:10150 lines4 breaks
- 20 Oct, 11:00130 lines4 breaks
- 20 Oct, 10:50106 lines3 breaks
- 20 Oct, 10:40109 lines4 breaks
- 20 Oct, 10:30113 lines3 breaks
- 20 Oct, 10:20138 lines1 break
- 20 Oct, 10:10134 lines1 break
- 20 Oct, 10:00100 lines3 breaks
- 20 Oct, 09:50111 lines1 break
20 Oct, 10:50
Gross
€2,699.00
PSP fee
€41.79
Net to the bank
€2,657.21
Settlement journal
#104015
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a158f4-10e9-78fb-a30e-11d070c72455 is already settled by stl_EUR_2987489 line 68
- fee differencethe fee is not the contract feethe fee is 5, the contract says 0
- missing linein the books, not in the filecapture:01a158f5-40f1-77ab-a1c5-bdce868b0229 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 12 | refund | 01a158ef-4043-7d90-af97-0158d528acb6 | -€15.00 | €0.05 | fee difference |
| 69 | capture | 01a158f4-1122-7914-914a-acf7b023451f | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a158e9-363a-73b5-a180-c94c7693d7bb | €49.00 | €0.67 | matched |
| 2 | capture | 01a158ee-c25f-7e87-96fa-47e44d69ed94 | €35.00 | €0.50 | matched |
| 3 | capture | 01a158ee-c2d8-7804-aca3-b8d4bdc88e00 | €9.00 | €0.19 | matched |
| 4 | capture | 01a158ee-cb16-73cc-9e3e-a3cb084203c7 | €35.00 | €0.50 | matched |
| 5 | capture | 01a158ee-cd96-7d17-bded-68fb51eebb74 | €49.00 | €0.67 | matched |
| 6 | capture | 01a158ee-d26d-7825-99ee-7096d760668d | €15.00 | €0.26 | matched |
| 7 | capture | 01a158ef-0d81-7d56-b09a-0eedfae89f9a | €15.00 | €0.26 | matched |
| 8 | capture | 01a158ef-0e0f-7794-94ac-b27cd2a9a251 | €35.00 | €0.50 | matched |
| 9 | capture | 01a158ef-17a0-7666-b695-661b7ff11729 | €35.00 | €0.50 | matched |
| 10 | refund | 01a158ef-1b03-77eb-82f8-0c65c23dce80 | -€3.00 | €0.00 | matched |
| 11 | capture | 01a158ef-1b26-7a6d-8b62-613f6ca5dff6 | €9.00 | €0.19 | matched |
| 13 | capture | 01a158ef-48ea-7996-a547-489c34a37c4a | €35.00 | €0.50 | matched |
| 14 | capture | 01a158ef-4e85-75ad-abed-6bd3e4923e04 | €9.00 | €0.19 | matched |
| 15 | capture | 01a158ef-517f-7e4a-98e8-54b8719137de | €24.00 | €0.37 | matched |
| 16 | refund | 01a158ef-6a16-7725-9713-f93237525254 | -€17.00 | €0.00 | matched |
| 17 | capture | 01a158ef-9bcc-7c0a-b1c3-19d5294fd784 | €9.00 | €0.19 | matched |
| 18 | capture | 01a158ef-c430-7347-92b0-cdcdea540e8f | €49.00 | €0.67 | matched |
| 19 | capture | 01a158ef-ce9f-7255-9467-fc617330852f | €49.00 | €0.67 | matched |
| 20 | capture | 01a158ef-d9a0-76ae-8017-1557d7161158 | €35.00 | €0.50 | matched |
| 21 | capture | 01a158ef-db42-76e3-98ff-69b4e8a994e2 | €35.00 | €0.50 | matched |
| 22 | capture | 01a158ef-dd4b-7bc0-982d-8161594f218d | €15.00 | €0.26 | matched |
| 23 | capture | 01a158ef-e0c2-7a0b-8bb1-650653205292 | €9.00 | €0.19 | matched |
| 24 | refund | 01a158f0-0cff-7d55-a05d-47ff40ed0f1e | -€12.00 | €0.00 | matched |
| 25 | capture | 01a158f0-14d5-7022-85dc-34f9785c17c1 | €35.00 | €0.50 | matched |
| 26 | capture | 01a158f0-1aa9-73fd-aec8-3c4b08c2dfe1 | €15.00 | €0.26 | matched |
| 27 | capture | 01a158f0-1bbc-7745-87d4-0d9f4f313bd3 | €24.00 | €0.37 | matched |
| 28 | capture | 01a158f0-1cbf-7d99-935c-4e990e357933 | €9.00 | €0.19 | matched |
| 29 | capture | 01a158f0-4c42-7d04-9979-76eca3c9773e | €15.00 | €0.26 | matched |
| 30 | capture | 01a158f0-7aad-7619-8660-510b15be4e29 | €24.00 | €0.37 | matched |
| 31 | capture | 01a158f0-b5fe-781a-b0ef-a032441dcc1a | €35.00 | €0.50 | matched |
| 32 | capture | 01a158f0-bc66-7c00-a9d7-a7be09104640 | €24.00 | €0.37 | matched |
| 33 | capture | 01a158f0-c51c-7e5c-a1a7-dfa46cf49896 | €24.00 | €0.37 | matched |
| 34 | capture | 01a158f0-c67f-792e-b3f8-76de10f86dc0 | €49.00 | €0.67 | matched |
| 35 | capture | 01a158f0-bc5f-71d4-a26a-9d6c9fa2cb36 | €9.00 | €0.19 | matched |
| 36 | capture | 01a158f0-d3fb-75df-beb2-ac889bd082ca | €35.00 | €0.50 | matched |
| 37 | capture | 01a158f0-df5b-7b88-a55a-d8b291912657 | €35.00 | €0.50 | matched |
| 38 | refund | 01a158f0-e169-7f7d-b361-094eb77e5d17 | -€14.00 | €0.00 | matched |
| 39 | capture | 01a158f0-e577-7d38-9a62-9bcc5eac6aca | €49.00 | €0.67 | matched |
| 40 | refund | 01a158f1-1da5-7f90-9d8f-5eb9d855464c | -€5.00 | €0.00 | matched |
| 41 | capture | 01a158f1-5f04-7daf-ad80-cbc956efebcd | €24.00 | €0.37 | matched |
| 42 | capture | 01a158f1-86b2-79d9-a38a-842cc0de8ede | €49.00 | €0.67 | matched |
| 43 | capture | 01a158f1-a681-7154-a6c5-8f112502807b | €9.00 | €0.19 | matched |
| 44 | capture | 01a158f2-108c-72ab-b313-686d31ceb087 | €9.00 | €0.19 | matched |
| 45 | capture | 01a158f2-288d-7895-98e1-e73c8b972018 | €9.00 | €0.19 | matched |
| 46 | capture | 01a158f2-3d16-7f06-a59c-f0bc99928683 | €49.00 | €0.67 | matched |
| 47 | capture | 01a158f2-4220-7218-8100-81ee6aabdd91 | €49.00 | €0.67 | matched |
| 48 | capture | 01a158f2-588d-79d2-9a3c-5cb1d005cf89 | €24.00 | €0.37 | matched |
| 49 | capture | 01a158f2-7fec-7cf6-996f-f2dcaa2b618a | €49.00 | €0.67 | matched |
| 50 | refund | 01a158f2-9847-780c-a7d6-2dd567b8ef45 | -€15.00 | €0.00 | matched |
| 51 | capture | 01a158f2-bbfe-76ea-9d3d-5a270b188512 | €49.00 | €0.67 | matched |
| 52 | capture | 01a158f2-c810-7de7-b23b-1309afcae72b | €9.00 | €0.19 | matched |
| 53 | capture | 01a158f2-ed38-7fec-b676-770eb10d52f9 | €24.00 | €0.37 | matched |
| 54 | capture | 01a158f3-0627-70f8-af23-646938e5289d | €9.00 | €0.19 | matched |
| 55 | capture | 01a158f3-0918-7a64-bea8-09e0ba4441de | €9.00 | €0.19 | matched |
| 56 | capture | 01a158f3-2fad-7472-86e7-91c15196b4b4 | €35.00 | €0.50 | matched |
| 57 | capture | 01a158f3-42c3-7b6f-957f-3ddd172a2be1 | €35.00 | €0.50 | matched |
| 58 | capture | 01a158f3-55e3-7fa8-a166-49c84091bf2f | €24.00 | €0.37 | matched |
| 59 | capture | 01a158f3-8ff3-7475-9516-375af4a0f748 | €35.00 | €0.50 | matched |
| 60 | capture | 01a158f3-9578-7705-9319-602f84f517df | €35.00 | €0.50 | matched |
| 61 | capture | 01a158f3-9620-74d3-b9f4-fdbef75c35bd | €24.00 | €0.37 | matched |
| 62 | capture | 01a158f3-a4bb-75ac-ae6c-d7100d809acc | €49.00 | €0.67 | matched |
| 63 | capture | 01a158f3-a924-7415-9910-b97085c8d75b | €35.00 | €0.50 | matched |
| 64 | capture | 01a158f3-ad68-782e-9982-b83f0040d12c | €15.00 | €0.26 | matched |
| 65 | capture | 01a158f3-ad75-7d87-9588-877bcf622b5c | €15.00 | €0.26 | matched |
| 66 | refund | 01a158f3-ef46-7e4a-aaf8-1fcde2879205 | -€14.00 | €0.00 | matched |
| 67 | capture | 01a158f4-0cf4-7109-86b4-c00f699a3c0d | €9.00 | €0.19 | matched |
| 68 | capture | 01a158f4-1122-7914-914a-acf7b023451f | €49.00 | €0.67 | matched |
| 70 | capture | 01a158f4-38be-72eb-935a-24ec98c3b928 | €49.00 | €0.67 | matched |
| 71 | capture | 01a158f4-44ef-755d-906e-9228057454ec | €15.00 | €0.26 | matched |
| 72 | capture | 01a158f4-50ce-70ff-9eed-60d85c3699b2 | €35.00 | €0.50 | matched |
| 73 | capture | 01a158f4-57ac-700a-b63a-7a602fa9e693 | €24.00 | €0.37 | matched |
| 74 | capture | 01a158f4-7929-7fe3-b6ea-46046f0f96bf | €49.00 | €0.67 | matched |
| 75 | capture | 01a158f4-8e64-7943-b248-a15e6e1661e3 | €24.00 | €0.37 | matched |
| 76 | capture | 01a158f4-9177-702e-9a38-8b72e92ce0c8 | €49.00 | €0.67 | matched |
| 77 | capture | 01a158f4-b408-7247-b2bb-9211d5cfa725 | €49.00 | €0.67 | matched |
| 78 | capture | 01a158f4-efad-7236-8956-6cbf8cec3d7f | €35.00 | €0.50 | matched |
| 79 | capture | 01a158f5-198f-74b2-a581-5077fa1ba829 | €35.00 | €0.50 | matched |
| 80 | capture | 01a158f5-2e26-79dc-927a-6bb2b6066752 | €9.00 | €0.19 | matched |
| 81 | capture | 01a158f5-3304-7809-8e07-c7eb8090e52e | €24.00 | €0.37 | matched |
| 82 | capture | 01a158f5-54d4-79ec-9091-0b8627500a56 | €35.00 | €0.50 | matched |
| 83 | capture | 01a158f5-9004-7aa9-8513-47bbae44ebb4 | €35.00 | €0.50 | matched |
| 84 | capture | 01a158f5-9cbb-7363-abe6-5f11d8bae4a8 | €35.00 | €0.50 | matched |
| 85 | capture | 01a158f5-b460-7f67-953c-a69868a29751 | €15.00 | €0.26 | matched |
| 86 | capture | 01a158f5-c382-72b8-a945-f4e1a74d5e41 | €9.00 | €0.19 | matched |
| 87 | capture | 01a158f5-c80f-7e31-babe-ff196eb43161 | €35.00 | €0.50 | matched |
| 88 | capture | 01a158f5-d20c-7839-8981-1342f0af096a | €24.00 | €0.37 | matched |
| 89 | capture | 01a158f6-08c6-7135-80eb-6e1ab257fec1 | €35.00 | €0.50 | matched |
| 90 | capture | 01a158f6-104e-7f69-9983-435f30faf817 | €35.00 | €0.50 | matched |
| 91 | capture | 01a158f6-1515-7fb9-98f1-da650f08a42f | €24.00 | €0.37 | matched |
| 92 | capture | 01a158f6-2f30-7401-ab1e-80a02acd39a7 | €9.00 | €0.19 | matched |
| 93 | capture | 01a158f6-3da9-7f37-96d1-7edea96273ac | €9.00 | €0.19 | matched |
| 94 | capture | 01a158f6-4769-7c81-8250-e511d6b9167b | €35.00 | €0.50 | matched |
| 95 | capture | 01a158f6-d8f4-7d24-bfbd-15da0ac557a7 | €49.00 | €0.67 | matched |
| 96 | capture | 01a158f7-0128-763f-9a76-f03fd5c81b59 | €49.00 | €0.67 | matched |
| 97 | capture | 01a158f7-028d-7fae-87cc-d84ae5912cf3 | €35.00 | €0.50 | matched |
| 98 | capture | 01a158f7-08da-79ce-ac60-e0dc303675f4 | €49.00 | €0.67 | matched |
| 99 | capture | 01a158f7-100d-74b4-9474-1be00f8a5e2d | €49.00 | €0.67 | matched |
| 100 | capture | 01a158f7-3ebe-71ce-b454-c60c3afb0c2f | €24.00 | €0.37 | matched |
| 101 | capture | 01a158f7-3d48-7467-9678-145e4abf9c35 | €24.00 | €0.37 | matched |
| 102 | refund | 01a158f7-4a57-7a66-a056-ef0cb7de3155 | -€28.00 | €0.00 | matched |
| 103 | capture | 01a158f7-58c3-7944-88a8-c7912a9348eb | €35.00 | €0.50 | matched |
| 104 | capture | 01a158f7-bd62-71df-80e3-8e3567ade19f | €15.00 | €0.26 | matched |
| 105 | capture | 01a158f7-c611-741f-8689-4309fc0d874f | €35.00 | €0.50 | matched |
| 106 | capture | 01a158f7-cc81-75d9-88c7-4e59c353c49d | €9.00 | €0.19 | matched |