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, 06:40122 lines2 breaks
- 20 Oct, 06:30123 lines2 breaks
- 20 Oct, 06:20130 lines1 break
- 20 Oct, 06:10122 lines4 breaks
- 20 Oct, 06:00119 lines1 break
- 20 Oct, 05:50143 lines4 breaks
- 20 Oct, 05:40132 lines3 breaks
- 20 Oct, 05:30133 lines4 breaks
- 20 Oct, 05:20118 lines3 breaks
- 20 Oct, 05:10113 lines1 break
- 20 Oct, 05:00129 linesclean
- 20 Oct, 04:50122 lines1 break
- 20 Oct, 04:40136 lines2 breaks
- 20 Oct, 04:30116 linesclean
20 Oct, 05:30
Gross
€3,068.00
PSP fee
€48.75
Net to the bank
€3,019.25
Settlement journal
#99977
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a157cd-2d6f-7732-80c0-ea1e55eb68f9 is already settled by stl_EUR_2987457 line 62
- fee differencethe fee is not the contract feethe fee is 55, the contract says 50
- missing linein the books, not in the filecapture:01a157ca-0eb2-79a8-8f5b-86fc02e01604 is in no file
- missing linein the books, not in the filecapture:01a157cd-0a10-704a-a6d5-8b09e703a3a8 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 63 | capture | 01a157cd-2d8e-7c60-882d-88a232ff4de5 | €24.00 | €0.37 | duplicate line |
| 72 | capture | 01a157cd-afa9-7770-87de-4c6bfa745ae6 | €35.00 | €0.55 | fee difference |
| 1 | refund | 01a157c9-1d7a-7efb-baee-5c59d1e66ffd | -€21.00 | €0.00 | matched |
| 2 | capture | 01a157c9-b912-797d-88db-0590a817695e | €15.00 | €0.26 | matched |
| 3 | capture | 01a157c9-baa5-7f43-b70f-7e5052329e63 | €9.00 | €0.19 | matched |
| 4 | capture | 01a157c9-ce3f-7ffc-929d-dd4648a32612 | €35.00 | €0.50 | matched |
| 5 | refund | 01a157c9-f7fc-780e-af52-ea49e8f0cf7f | -€3.00 | €0.00 | matched |
| 6 | capture | 01a157ca-0273-7d2f-99c7-d7cedd6c7870 | €24.00 | €0.37 | matched |
| 7 | capture | 01a157ca-08e7-713f-946a-80280c15ccba | €15.00 | €0.26 | matched |
| 8 | capture | 01a157ca-122b-7809-bd12-5673081d5f61 | €24.00 | €0.37 | matched |
| 9 | capture | 01a157ca-1637-7718-8a93-33292456938e | €24.00 | €0.37 | matched |
| 10 | capture | 01a157ca-2089-7fad-ba2e-584eae3c2278 | €35.00 | €0.50 | matched |
| 11 | capture | 01a157ca-309b-7dd9-8d62-b7c8c784f950 | €9.00 | €0.19 | matched |
| 12 | capture | 01a157ca-3972-79ab-b25e-ce3a2dcca2dd | €24.00 | €0.37 | matched |
| 13 | capture | 01a157ca-521a-7e83-9c73-87fec90addf2 | €35.00 | €0.50 | matched |
| 14 | capture | 01a157ca-5a4a-7eef-8d1c-d24226b5bfbf | €49.00 | €0.67 | matched |
| 15 | capture | 01a157ca-67cc-7049-a7ca-241082b2f2ea | €9.00 | €0.19 | matched |
| 16 | capture | 01a157ca-67ec-7f95-b760-2ad4358a5617 | €24.00 | €0.37 | matched |
| 17 | capture | 01a157ca-7b53-7352-86cd-da11f1bb70bb | €24.00 | €0.37 | matched |
| 18 | capture | 01a157ca-7e73-79cf-bb1e-14ac0d1f5681 | €9.00 | €0.19 | matched |
| 19 | capture | 01a157ca-7fa7-7ce8-9a2c-bf52bb6931f8 | €35.00 | €0.50 | matched |
| 20 | capture | 01a157ca-98b3-766e-aaa1-2582ab2263c1 | €35.00 | €0.50 | matched |
| 21 | capture | 01a157ca-9ca0-7824-ba9d-d7edec551fbd | €9.00 | €0.19 | matched |
| 22 | capture | 01a157ca-bd35-7600-9405-d7562ba29eaa | €35.00 | €0.50 | matched |
| 23 | capture | 01a157ca-e940-7378-8eaa-126cf672e8fb | €24.00 | €0.37 | matched |
| 24 | capture | 01a157cb-0e19-7818-82d2-efbc42b410c1 | €24.00 | €0.37 | matched |
| 25 | capture | 01a157cb-0ea6-7994-b74e-7270033028d3 | €9.00 | €0.19 | matched |
| 26 | capture | 01a157cb-10c8-7507-ac52-04e00ba621a8 | €49.00 | €0.67 | matched |
| 27 | capture | 01a157cb-37c8-7490-8af4-423e945fd6ec | €49.00 | €0.67 | matched |
| 28 | capture | 01a157cb-5c4a-74c4-accd-4d961d4d471d | €49.00 | €0.67 | matched |
| 29 | capture | 01a157cb-7c5b-798b-a0d1-81c54ee71ac2 | €9.00 | €0.19 | matched |
| 30 | capture | 01a157cb-830d-7df9-9402-026d5506679a | €35.00 | €0.50 | matched |
| 31 | capture | 01a157cb-9dbc-7384-8087-0f1a4af8d4fb | €24.00 | €0.37 | matched |
| 32 | capture | 01a157cb-a6f6-7cd9-a886-b5c2afd3edec | €9.00 | €0.19 | matched |
| 33 | capture | 01a157cb-c94b-7773-a746-ff17ff89e829 | €9.00 | €0.19 | matched |
| 34 | capture | 01a157cb-d7d2-78d2-b958-0e9fad7c9790 | €9.00 | €0.19 | matched |
| 35 | capture | 01a157cb-da60-7fcd-8a2e-42b53d33048a | €35.00 | €0.50 | matched |
| 36 | capture | 01a157cb-ee96-7038-8c68-42ef5c3b31ae | €49.00 | €0.67 | matched |
| 37 | refund | 01a157cb-f05d-7780-ba5a-fec293536787 | -€7.00 | €0.00 | matched |
| 38 | refund | 01a157cb-f74b-73f7-a6bb-bcb80504506a | -€5.00 | €0.00 | matched |
| 39 | capture | 01a157cc-1183-764a-a673-55b72b49f8b4 | €15.00 | €0.26 | matched |
| 40 | capture | 01a157cc-2111-7016-a8a5-2da2e186a300 | €49.00 | €0.67 | matched |
| 41 | refund | 01a157cc-2bd3-7934-9f55-58a86c9d886c | -€27.00 | €0.00 | matched |
| 42 | capture | 01a157cc-2f46-7e66-9f73-562fcd432866 | €24.00 | €0.37 | matched |
| 43 | capture | 01a157cc-32d3-75bc-b62f-189aac4473a8 | €9.00 | €0.19 | matched |
| 44 | capture | 01a157cc-393b-71c4-92a6-d585996375e7 | €49.00 | €0.67 | matched |
| 45 | capture | 01a157cc-41dd-74ac-9b14-a1e5086b2d9e | €49.00 | €0.67 | matched |
| 46 | capture | 01a157cc-5656-7dee-822a-c367e9ab45a4 | €35.00 | €0.50 | matched |
| 47 | capture | 01a157cc-5f23-7677-9212-15172456d2ed | €9.00 | €0.19 | matched |
| 48 | refund | 01a157cc-78de-785c-8a49-c39349705178 | -€26.00 | €0.00 | matched |
| 49 | capture | 01a157cc-8611-7858-b413-d5e2f61e64e3 | €35.00 | €0.50 | matched |
| 50 | capture | 01a157cc-962a-7c47-9ce2-56b39a64ed4a | €35.00 | €0.50 | matched |
| 51 | capture | 01a157cc-9794-7290-9a1a-873d8e572f88 | €49.00 | €0.67 | matched |
| 52 | capture | 01a157cc-b332-7743-bb9b-5c132a255eab | €24.00 | €0.37 | matched |
| 53 | capture | 01a157cc-bd2d-75a5-883e-51dc4b5a2cef | €35.00 | €0.50 | matched |
| 54 | capture | 01a157cc-da40-763a-ae5d-52e67e04ceb8 | €24.00 | €0.37 | matched |
| 55 | capture | 01a157cc-ebe8-7142-88ae-e8234b0084a5 | €49.00 | €0.67 | matched |
| 56 | capture | 01a157cc-f058-7160-a9b5-c6ed1b0c5025 | €24.00 | €0.37 | matched |
| 57 | capture | 01a157cc-f264-7fbe-8dc4-0eb6f14d5170 | €49.00 | €0.67 | matched |
| 58 | capture | 01a157cd-04cd-7724-b420-767ea07ebe0f | €15.00 | €0.26 | matched |
| 59 | capture | 01a157cd-0c1a-75e2-9d8c-29302d65fd73 | €9.00 | €0.19 | matched |
| 60 | capture | 01a157cd-2ca1-7c0f-ba14-8a0ca76651c6 | €49.00 | €0.67 | matched |
| 61 | capture | 01a157cd-2cdd-7e9a-9d3d-3d21b883b0d1 | €24.00 | €0.37 | matched |
| 62 | capture | 01a157cd-2d8e-7c60-882d-88a232ff4de5 | €24.00 | €0.37 | matched |
| 64 | capture | 01a157cd-33f1-7e93-b699-a697a86db58e | €9.00 | €0.19 | matched |
| 65 | refund | 01a157cd-4652-705b-b0f3-8efc78c0d2fb | -€15.00 | €0.00 | matched |
| 66 | capture | 01a157cd-468d-7f71-8d2b-3f7fa7087312 | €9.00 | €0.19 | matched |
| 67 | capture | 01a157cd-44c5-75da-a9a5-3214b5df98d0 | €24.00 | €0.37 | matched |
| 68 | capture | 01a157cd-4ca0-70fe-a513-8aeb1d3ad69f | €24.00 | €0.37 | matched |
| 69 | capture | 01a157cd-5708-7567-9f2b-f6c61a878ed7 | €35.00 | €0.50 | matched |
| 70 | capture | 01a157cd-87c5-726b-ae02-58eeea5a64a8 | €35.00 | €0.50 | matched |
| 71 | capture | 01a157cd-8c1c-7ea4-be7e-9f1aa8177931 | €24.00 | €0.37 | matched |
| 73 | capture | 01a157cd-b6dd-795c-9e5c-6b6f2508967f | €35.00 | €0.50 | matched |
| 74 | capture | 01a157cd-c712-7502-8956-b7cc899223d2 | €49.00 | €0.67 | matched |
| 75 | capture | 01a157cd-ca9a-7648-ac33-2beb0cdf5465 | €49.00 | €0.67 | matched |
| 76 | refund | 01a157cd-e3a5-703e-bb10-48a5e431c191 | -€9.00 | €0.00 | matched |
| 77 | capture | 01a157cd-eb05-7372-96fa-a568c87eadd3 | €35.00 | €0.50 | matched |
| 78 | capture | 01a157ce-1b00-7444-8c8a-0fe3b47379d0 | €9.00 | €0.19 | matched |
| 79 | capture | 01a157ce-2bfa-7105-8ee2-407bf9b2fed3 | €35.00 | €0.50 | matched |
| 80 | capture | 01a157ce-2f1c-7516-adbe-6f3829ad8a95 | €49.00 | €0.67 | matched |
| 81 | capture | 01a157ce-4f6c-788a-8865-2d1f8c79e055 | €35.00 | €0.50 | matched |
| 82 | capture | 01a157ce-55f5-7717-8ee4-47a2d3f8e589 | €49.00 | €0.67 | matched |
| 83 | capture | 01a157ce-6953-7d9f-8ec1-e80af69a6c44 | €9.00 | €0.19 | matched |
| 84 | refund | 01a157ce-7177-7d59-9849-30b28e6eede2 | -€13.00 | €0.00 | matched |
| 85 | capture | 01a157ce-957c-7e8f-9fc5-dc55a8b4f14b | €24.00 | €0.37 | matched |
| 86 | capture | 01a157ce-9727-705f-993b-4d9e734e6d6b | €15.00 | €0.26 | matched |
| 87 | capture | 01a157ce-b484-704b-987e-66c65be0e4ac | €24.00 | €0.37 | matched |
| 88 | capture | 01a157ce-c299-7d21-ac47-a48b5adec7ec | €9.00 | €0.19 | matched |
| 89 | capture | 01a157ce-d46c-7212-ac17-a30e5f10b9a3 | €15.00 | €0.26 | matched |
| 90 | capture | 01a157ce-f186-797d-8c80-3098ed4c3c80 | €35.00 | €0.50 | matched |
| 91 | capture | 01a157cf-1d9b-75c5-b2dd-a7e5519f4902 | €35.00 | €0.50 | matched |
| 92 | capture | 01a157cf-3888-72ac-be9d-0fe8f60d2ba7 | €15.00 | €0.26 | matched |
| 93 | capture | 01a157cf-387d-7f1d-a0cf-19f4b0c12fb6 | €9.00 | €0.19 | matched |
| 94 | capture | 01a157cf-7723-7d12-b7b8-e48cddd1bdaf | €15.00 | €0.26 | matched |
| 95 | capture | 01a157cf-9e4c-7d14-af71-d2421a3197fb | €9.00 | €0.19 | matched |
| 96 | capture | 01a157cf-afa4-7e05-a703-c7179db94314 | €49.00 | €0.67 | matched |
| 97 | capture | 01a157cf-c029-7655-803c-018fd6f056ff | €35.00 | €0.50 | matched |
| 98 | capture | 01a157cf-bc50-77de-925f-4226445479bd | €49.00 | €0.67 | matched |
| 99 | capture | 01a157cf-d675-7a29-820c-a8b2d524befa | €15.00 | €0.26 | matched |
| 100 | refund | 01a157cf-d91c-7083-b31e-7bc76c7f525e | -€7.00 | €0.00 | matched |
| 101 | capture | 01a157cf-fc57-739c-96b3-7139b0630909 | €35.00 | €0.50 | matched |
| 102 | capture | 01a157d0-0137-7532-bc65-cc478f2ecf08 | €35.00 | €0.50 | matched |
| 103 | capture | 01a157d0-0f0b-79de-b6d6-ce5bee43a737 | €49.00 | €0.67 | matched |
| 104 | capture | 01a157d0-9cd0-7f8f-8738-ad35e44e8c14 | €24.00 | €0.37 | matched |
| 105 | capture | 01a157d0-cb9c-79dd-9b5b-23ffc8a2be2a | €15.00 | €0.26 | matched |
| 106 | capture | 01a157d0-e663-7bfc-9f88-34f48b04f671 | €9.00 | €0.19 | matched |
| 107 | capture | 01a157d1-14b7-7a95-8bc5-1dc39f359063 | €24.00 | €0.37 | matched |
| 108 | capture | 01a157d1-3161-7219-94f6-eda340b588b7 | €9.00 | €0.19 | matched |
| 109 | capture | 01a157d1-35c4-76db-97ed-16d5ff7a67ab | €15.00 | €0.26 | matched |
| 110 | capture | 01a157d1-447d-784b-88ce-aaaa5d3e8bcd | €35.00 | €0.50 | matched |
| 111 | capture | 01a157d1-5b7f-731a-a252-8bf0bad49047 | €49.00 | €0.67 | matched |
| 112 | capture | 01a157d1-717a-7266-8085-4f33af1a3419 | €9.00 | €0.19 | matched |
| 113 | refund | 01a157d1-9639-7e91-a4a8-1034956cec51 | -€5.00 | €0.00 | matched |
| 114 | capture | 01a157d1-ae90-79d0-81f8-72ad3a356060 | €15.00 | €0.26 | matched |
| 115 | capture | 01a157d1-c480-799f-adb6-7bb0253b245f | €24.00 | €0.37 | matched |
| 116 | refund | 01a157d1-e028-76e6-a493-3a67e0bb3678 | -€2.00 | €0.00 | matched |
| 117 | capture | 01a157d2-0fce-742a-adea-7ef9f69611b1 | €49.00 | €0.67 | matched |
| 118 | capture | 01a157d2-131d-7d1d-a7b1-fd97ce72ce9e | €49.00 | €0.67 | matched |
| 119 | capture | 01a157d2-14b1-7d9c-b01a-611ad84f8f84 | €9.00 | €0.19 | matched |
| 120 | capture | 01a157d2-18fa-73d3-934d-2f488c821f00 | €49.00 | €0.67 | matched |
| 121 | capture | 01a157d2-2f9e-71c7-be49-7a52eaf14353 | €24.00 | €0.37 | matched |
| 122 | capture | 01a157d2-31f7-7d17-92c2-01325d585445 | €9.00 | €0.19 | matched |
| 123 | capture | 01a157d2-3f2b-7d18-986f-1893faa52f13 | €49.00 | €0.67 | matched |
| 124 | refund | 01a157d2-699f-753a-af9e-698af6bfa1e5 | -€37.00 | €0.00 | matched |
| 125 | capture | 01a157d2-8aa0-727f-9e3b-4af2f5bcda5c | €35.00 | €0.50 | matched |
| 126 | capture | 01a157d2-8e7c-7055-ace4-34917368d466 | €24.00 | €0.37 | matched |
| 127 | capture | 01a157d2-93f4-731f-86ab-0fc7fdc5eff2 | €9.00 | €0.19 | matched |
| 128 | capture | 01a157d2-9eef-7770-abbd-f74fe26048d0 | €49.00 | €0.67 | matched |
| 129 | capture | 01a157d2-a91f-7322-b967-8af2fa8cae1f | €24.00 | €0.37 | matched |
| 130 | capture | 01a157d2-b1a2-73c8-9969-b716820ccbb2 | €15.00 | €0.26 | matched |
| 131 | capture | 01a157d2-cbae-79a2-8024-1ad00f15a746 | €15.00 | €0.26 | matched |
| 132 | capture | 01a157d2-d676-7911-ac70-4396195f3169 | €9.00 | €0.19 | matched |
| 133 | capture | 01a157d2-deed-7009-9c16-59cb199164db | €9.00 | €0.19 | matched |