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
- 24 Oct, 17:40145 lines4 breaks
- 24 Oct, 17:30118 lines4 breaks
- 24 Oct, 17:20113 lines3 breaks
- 24 Oct, 17:1099 lines2 breaks
- 24 Oct, 17:00122 lines1 break
- 24 Oct, 16:50126 lines3 breaks
- 24 Oct, 16:40136 linesclean
- 24 Oct, 16:30120 lines6 breaks
- 24 Oct, 16:20129 lines2 breaks
- 24 Oct, 16:10113 lines1 break
- 24 Oct, 16:00105 lines2 breaks
- 24 Oct, 15:50114 lines4 breaks
- 24 Oct, 15:40139 lines4 breaks
- 24 Oct, 15:30151 lines4 breaks
24 Oct, 17:10
Gross
€2,192.00
PSP fee
€36.55
Net to the bank
€2,155.45
Settlement journal
#181984
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a16ee9-b19e-78bd-9b37-4a42dfd5952a is already settled by stl_EUR_2988103 line 58
- missing linein the books, not in the filecapture:01a16eea-b4a3-7313-a9ee-d326e0c50cdf is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 59 | refund | 01a16ee9-b1a2-72fa-a321-10e2468c1719 | -€33.00 | €0.00 | duplicate line |
| 1 | capture | 01a16ee4-12fe-7def-bd8a-7069aa1a11cc | €15.00 | €0.26 | matched |
| 2 | capture | 01a16ee4-18bc-739a-ad02-b15965d7619c | €15.00 | €0.26 | matched |
| 3 | capture | 01a16ee4-1ce6-7ccf-9b55-607ef99857a3 | €15.00 | €0.26 | matched |
| 4 | capture | 01a16ee4-3f6a-73aa-9015-66dfc9ea448e | €24.00 | €0.37 | matched |
| 5 | refund | 01a16ee4-519b-7a05-9917-0e9888ee57d3 | -€14.00 | €0.00 | matched |
| 6 | capture | 01a16ee4-5d84-7fc8-be6a-ea041d32e56c | €15.00 | €0.26 | matched |
| 7 | capture | 01a16ee4-5dee-768b-a756-58981aaf4f4e | €35.00 | €0.50 | matched |
| 8 | capture | 01a16ee4-7576-7e3b-bbd0-d9c452dab755 | €9.00 | €0.19 | matched |
| 9 | capture | 01a16ee4-9243-78c1-acd1-3f6475b401e2 | €15.00 | €0.26 | matched |
| 10 | capture | 01a16ee4-9c9a-7ec2-88ef-630b61158c62 | €35.00 | €0.50 | matched |
| 11 | capture | 01a16ee4-c066-7829-8093-9582d11b6c98 | €35.00 | €0.50 | matched |
| 12 | capture | 01a16ee4-c53c-7165-81ba-bc6c2b59a9a6 | €35.00 | €0.50 | matched |
| 13 | capture | 01a16ee4-cc09-7ea3-a735-438ffe669b42 | €15.00 | €0.26 | matched |
| 14 | capture | 01a16ee4-ccad-7d32-9b90-f16b54eb1459 | €9.00 | €0.19 | matched |
| 15 | capture | 01a16ee4-e457-7cdb-9d27-07b0f2ad8270 | €24.00 | €0.37 | matched |
| 16 | refund | 01a16ee5-05e6-74d3-8c11-eba45413f9c0 | -€15.00 | €0.00 | matched |
| 17 | capture | 01a16ee5-7f71-7e26-a391-f04da270107e | €35.00 | €0.50 | matched |
| 18 | capture | 01a16ee5-97d7-73f7-8def-217842ff6bab | €9.00 | €0.19 | matched |
| 19 | capture | 01a16ee6-0041-787b-abf9-3bb6bed364d7 | €49.00 | €0.67 | matched |
| 20 | capture | 01a16ee6-1dbc-71e6-8f75-4707d06e6124 | €9.00 | €0.19 | matched |
| 21 | capture | 01a16ee6-44cc-7a46-8d0c-5f87c8be38dc | €49.00 | €0.67 | matched |
| 22 | capture | 01a16ee6-4647-73e3-9241-3c6f0fa86689 | €9.00 | €0.19 | matched |
| 23 | capture | 01a16ee6-4c60-7e74-b973-b5ad41b6181a | €9.00 | €0.19 | matched |
| 24 | capture | 01a16ee6-5bf7-7346-957c-202eae3b91e7 | €15.00 | €0.26 | matched |
| 25 | capture | 01a16ee6-5bf4-7294-bb6d-7fb1ea35b698 | €9.00 | €0.19 | matched |
| 26 | capture | 01a16ee6-5dea-72bd-a9ac-9c6f20b5a02c | €9.00 | €0.19 | matched |
| 27 | capture | 01a16ee6-7d04-7795-86c3-d2b7015093fa | €49.00 | €0.67 | matched |
| 28 | capture | 01a16ee6-83f7-7219-ad9a-8e1062392439 | €15.00 | €0.26 | matched |
| 29 | capture | 01a16ee6-a024-72cf-887f-ec168ae6148a | €49.00 | €0.67 | matched |
| 30 | capture | 01a16ee6-abbd-7ea4-94db-0207c951bb99 | €49.00 | €0.67 | matched |
| 31 | capture | 01a16ee7-0f1f-707a-8ca6-b1eaa86166be | €49.00 | €0.67 | matched |
| 32 | capture | 01a16ee7-1860-7560-b043-dee64a6e3d37 | €35.00 | €0.50 | matched |
| 33 | capture | 01a16ee7-42ca-7998-b8cb-a2dee2234887 | €9.00 | €0.19 | matched |
| 34 | capture | 01a16ee7-4aa2-7365-ab67-68a1691dfc5a | €9.00 | €0.19 | matched |
| 35 | capture | 01a16ee7-4d62-7b40-a940-bbb429fa6273 | €49.00 | €0.67 | matched |
| 36 | capture | 01a16ee7-5141-7c73-a4df-e67d5ddbe9fe | €24.00 | €0.37 | matched |
| 37 | capture | 01a16ee7-6614-74ea-9adc-044d93819986 | €49.00 | €0.67 | matched |
| 38 | capture | 01a16ee7-9c42-705b-8b69-14aafd4bc2c6 | €24.00 | €0.37 | matched |
| 39 | capture | 01a16ee7-abf9-7f00-bda3-79da8508d24e | €9.00 | €0.19 | matched |
| 40 | capture | 01a16ee7-e47f-7487-8400-24e048c4bbe4 | €15.00 | €0.26 | matched |
| 41 | capture | 01a16ee8-2111-781f-ae97-d0f4f2d980b2 | €9.00 | €0.19 | matched |
| 42 | capture | 01a16ee8-25b8-71b6-a8e3-baa8b6fe2501 | €9.00 | €0.19 | matched |
| 43 | refund | 01a16ee8-2a76-7eed-9cdc-2c00fb794194 | -€12.00 | €0.00 | matched |
| 44 | capture | 01a16ee8-5c6c-7fde-a7a9-ee4f98032e29 | €9.00 | €0.19 | matched |
| 45 | capture | 01a16ee8-b4eb-74bb-987b-0c503a12b91c | €15.00 | €0.26 | matched |
| 46 | capture | 01a16ee8-b544-7f52-bd27-377538ab9f7e | €9.00 | €0.19 | matched |
| 47 | capture | 01a16ee8-be72-7bc3-9959-58b0feeefc41 | €49.00 | €0.67 | matched |
| 48 | capture | 01a16ee8-d33d-759a-85c3-ece2de6737a8 | €35.00 | €0.50 | matched |
| 49 | capture | 01a16ee8-e2f6-71a8-9212-2eae1711bcd3 | €9.00 | €0.19 | matched |
| 50 | capture | 01a16ee8-e527-76bf-b958-585bff1c5e38 | €49.00 | €0.67 | matched |
| 51 | capture | 01a16ee9-15b0-7641-95ca-17274dcd60bb | €9.00 | €0.19 | matched |
| 52 | capture | 01a16ee9-375b-7dec-93b3-a443d5a5e25a | €49.00 | €0.67 | matched |
| 53 | capture | 01a16ee9-3eb0-7969-8023-8174e74054d5 | €24.00 | €0.37 | matched |
| 54 | capture | 01a16ee9-42cf-7258-925a-b9da5da67e89 | €15.00 | €0.26 | matched |
| 55 | capture | 01a16ee9-50c3-7432-9496-666492ce7937 | €35.00 | €0.50 | matched |
| 56 | capture | 01a16ee9-6545-73cd-9162-19f683f1e103 | €15.00 | €0.26 | matched |
| 57 | capture | 01a16ee9-83fb-705d-acec-786429315b40 | €49.00 | €0.67 | matched |
| 58 | refund | 01a16ee9-b1a2-72fa-a321-10e2468c1719 | -€33.00 | €0.00 | matched |
| 60 | capture | 01a16ee9-ee5f-7463-83a9-588b6788ed4f | €49.00 | €0.67 | matched |
| 61 | capture | 01a16eea-0ea7-72e2-b639-595c2c2df446 | €49.00 | €0.67 | matched |
| 62 | capture | 01a16eea-128c-7524-b87c-325e70e4fe92 | €15.00 | €0.26 | matched |
| 63 | capture | 01a16eea-4c00-7136-8ebc-2f3622b7a0c6 | €9.00 | €0.19 | matched |
| 64 | capture | 01a16eea-3b27-70bb-977d-e68e1fa843ae | €49.00 | €0.67 | matched |
| 65 | capture | 01a16eea-55c6-70be-aa3f-9fbe7f997f80 | €15.00 | €0.26 | matched |
| 66 | capture | 01a16eea-9016-77db-afa2-03aeaefeb270 | €15.00 | €0.26 | matched |
| 67 | capture | 01a16eea-981b-7ccb-970b-119080365dae | €24.00 | €0.37 | matched |
| 68 | capture | 01a16eea-d2e2-7860-8549-517cbf5cd78b | €24.00 | €0.37 | matched |
| 69 | capture | 01a16eea-f485-793b-941e-e3db7703e42a | €15.00 | €0.26 | matched |
| 70 | capture | 01a16eeb-0f93-7f2e-86ac-aacb2fe40856 | €35.00 | €0.50 | matched |
| 71 | capture | 01a16eeb-2e57-7f75-a152-c78cec493a13 | €24.00 | €0.37 | matched |
| 72 | capture | 01a16eeb-3add-7388-a536-f16f1eb2e0bd | €49.00 | €0.67 | matched |
| 73 | refund | 01a16eeb-6470-7982-9231-9854623ac4e6 | -€12.00 | €0.00 | matched |
| 74 | capture | 01a16eeb-7194-704f-a582-60defc2ac30d | €24.00 | €0.37 | matched |
| 75 | capture | 01a16eeb-7265-7c03-8c47-0de37fbd27e7 | €49.00 | €0.67 | matched |
| 76 | capture | 01a16eeb-8a1a-7c48-80ca-af5f0084c61a | €35.00 | €0.50 | matched |
| 77 | refund | 01a16eeb-8b7f-7f76-8e1a-666b98dfbe43 | -€49.00 | €0.00 | matched |
| 78 | capture | 01a16eeb-9f66-79c4-92d2-fdd7772df079 | €49.00 | €0.67 | matched |
| 79 | capture | 01a16eeb-af17-7f79-af35-c1393c7d73d0 | €35.00 | €0.50 | matched |
| 80 | capture | 01a16eeb-b1ad-7607-ae42-1baebcf086b2 | €49.00 | €0.67 | matched |
| 81 | capture | 01a16eeb-cc4c-7468-8c13-06a55952c260 | €35.00 | €0.50 | matched |
| 82 | capture | 01a16eeb-d7ef-70dd-ba2c-b64d9b80af1f | €49.00 | €0.67 | matched |
| 83 | capture | 01a16eeb-da5d-7736-a47f-958acc287e30 | €35.00 | €0.50 | matched |
| 84 | refund | 01a16eeb-dc48-7285-abf0-4ba8c0459d59 | -€47.00 | €0.00 | matched |
| 85 | capture | 01a16eeb-e268-7e06-96af-0a53a0c9650f | €24.00 | €0.37 | matched |
| 86 | capture | 01a16eeb-e707-748e-baeb-540a4e0b9454 | €35.00 | €0.50 | matched |
| 87 | capture | 01a16eeb-e9fc-72c7-8e1b-5de67f60623c | €24.00 | €0.37 | matched |
| 88 | capture | 01a16eec-0434-7fd0-a804-dbc3e547e3a4 | €49.00 | €0.67 | matched |
| 89 | capture | 01a16eec-16f7-7992-9690-73846417850c | €49.00 | €0.67 | matched |
| 90 | refund | 01a16eec-3796-728a-bd3d-1e828373ee0f | -€31.00 | €0.00 | matched |
| 91 | capture | 01a16eec-387c-718b-9873-6b36a6198c73 | €49.00 | €0.67 | matched |
| 92 | capture | 01a16eec-6a77-77a1-934b-45a55d8479d5 | €15.00 | €0.26 | matched |
| 93 | capture | 01a16eec-af03-7e87-82a5-bb118c8451f9 | €49.00 | €0.67 | matched |
| 94 | capture | 01a16eec-b7cf-75b1-aa6a-0242f2ed7635 | €15.00 | €0.26 | matched |
| 95 | capture | 01a16eec-cbbc-716b-a15e-4ce9f2ea94c1 | €15.00 | €0.26 | matched |
| 96 | capture | 01a16eec-e2b5-7201-ac80-fe6b48deae2c | €24.00 | €0.37 | matched |
| 97 | refund | 01a16eec-f86c-7ab9-9ecc-bab3efc29d6e | -€9.00 | €0.00 | matched |
| 98 | capture | 01a16eed-112f-7e76-b209-1035be773c78 | €49.00 | €0.67 | matched |
| 99 | refund | 01a16eed-173a-7798-9ebd-915c89adb20a | -€3.00 | €0.00 | matched |