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
- 3 Nov, 20:50128 lines3 breaks
- 3 Nov, 20:40104 lines2 breaks
- 3 Nov, 20:30146 lines4 breaks
- 3 Nov, 20:20143 lines4 breaks
- 3 Nov, 20:10123 lines1 break
- 3 Nov, 20:00129 lines7 breaks
- 3 Nov, 19:50125 lines4 breaks
- 3 Nov, 19:40121 lines4 breaks
- 3 Nov, 19:30117 linesclean
- 3 Nov, 19:20121 lines5 breaks
- 3 Nov, 19:10120 lines1 break
- 3 Nov, 19:00115 lines3 breaks
- 3 Nov, 18:50135 lines4 breaks
- 3 Nov, 18:40107 lines4 breaks
2 Nov, 18:10
Gross
€3,474.00
PSP fee
€53.26
Net to the bank
€3,420.74
Settlement journal
#347153
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19d7b-f201-717b-bd6d-7583d5c15eca is already settled by stl_EUR_2989405 line 105
- fee differencethe fee is not the contract feethe fee is 69, the contract says 67
- fee differencethe fee is not the contract feethe fee is 29, the contract says 26
- fee differencethe fee is not the contract feethe fee is 52, the contract says 50
- fee differencethe fee is not the contract feethe fee is 70, the contract says 67
- missing linein the books, not in the filecapture:01a19d7b-2fda-71a5-adb2-4dfa6ad578d0 is in no file
- missing linein the books, not in the filecapture:01a19d75-c24d-7e4f-b318-1020face7a09 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 59 | capture | 01a19d78-0678-7f48-bb29-db1910ae8dff | €49.00 | €0.69 | fee difference |
| 61 | capture | 01a19d78-0eeb-76f8-91da-bf91fdfcca13 | €15.00 | €0.29 | fee difference |
| 105 | capture | 01a19d7b-f2db-748b-bf5c-ff574dbe1288 | €35.00 | €0.52 | fee difference |
| 106 | capture | 01a19d7b-f2db-748b-bf5c-ff574dbe1288 | €35.00 | €0.52 | duplicate line |
| 116 | capture | 01a19d7c-4752-7754-89f9-4f5abd2bb651 | €49.00 | €0.70 | fee difference |
| 1 | capture | 01a19d6e-9ea7-7316-ad0e-24d6b0ef2b60 | €35.00 | €0.50 | matched |
| 2 | capture | 01a19d74-3701-75b2-88a5-b60483df26ee | €49.00 | €0.67 | matched |
| 3 | capture | 01a19d74-460f-7439-911f-46e58f212460 | €15.00 | €0.26 | matched |
| 4 | capture | 01a19d74-4d89-7427-a779-e587ea8ee174 | €49.00 | €0.67 | matched |
| 5 | capture | 01a19d74-51b7-7a67-871b-34baed247b1a | €15.00 | €0.26 | matched |
| 6 | capture | 01a19d74-6131-7752-a7d4-c0dd9d39f49e | €49.00 | €0.67 | matched |
| 7 | capture | 01a19d74-6845-735b-9809-7544aa33f8e6 | €15.00 | €0.26 | matched |
| 8 | capture | 01a19d74-69ec-743e-8868-170fd10039a7 | €15.00 | €0.26 | matched |
| 9 | capture | 01a19d74-70ae-716c-ac68-8c1b6b2a0de7 | €35.00 | €0.50 | matched |
| 10 | capture | 01a19d74-7533-799c-9fcd-a883a23a92c7 | €35.00 | €0.50 | matched |
| 11 | capture | 01a19d74-75d8-7f9a-a0ae-f138294a2f5d | €49.00 | €0.67 | matched |
| 12 | capture | 01a19d74-e2ea-710b-94f8-f08e855ad131 | €35.00 | €0.50 | matched |
| 13 | capture | 01a19d74-e481-7c1d-965f-27f1a6f59e05 | €15.00 | €0.26 | matched |
| 14 | capture | 01a19d74-ecbd-7845-8ee6-a984f2dbb6dd | €24.00 | €0.37 | matched |
| 15 | capture | 01a19d74-f4b4-7259-8afd-702c2b77fd37 | €49.00 | €0.67 | matched |
| 16 | capture | 01a19d75-4a0c-775e-b525-e75de39ca7b7 | €35.00 | €0.50 | matched |
| 17 | capture | 01a19d75-5cc9-75c1-933d-c8791a91a83f | €9.00 | €0.19 | matched |
| 18 | capture | 01a19d75-6ab8-730d-bca8-b4222121fb8d | €49.00 | €0.67 | matched |
| 19 | capture | 01a19d75-6bf9-7ec3-9c25-1b72fdb90e2d | €24.00 | €0.37 | matched |
| 20 | capture | 01a19d75-7265-7743-873b-1a18584dfd68 | €35.00 | €0.50 | matched |
| 21 | capture | 01a19d75-92df-7e77-b475-4a3551f2b138 | €49.00 | €0.67 | matched |
| 22 | capture | 01a19d75-9988-7d5c-aa31-00dc8a50f397 | €15.00 | €0.26 | matched |
| 23 | capture | 01a19d75-ac95-70be-a041-4a1701a25fc5 | €24.00 | €0.37 | matched |
| 24 | capture | 01a19d75-b3bf-722e-8b58-3c11551ca193 | €49.00 | €0.67 | matched |
| 25 | capture | 01a19d75-d32a-7482-9b04-141f39479119 | €49.00 | €0.67 | matched |
| 26 | capture | 01a19d75-df47-7b70-9484-63c512c83146 | €15.00 | €0.26 | matched |
| 27 | capture | 01a19d75-e288-759f-a7eb-5043c4cad23b | €35.00 | €0.50 | matched |
| 28 | capture | 01a19d75-f923-7f4d-8a55-4872ff7668bb | €15.00 | €0.26 | matched |
| 29 | capture | 01a19d76-103d-7bae-bee6-99896337426c | €35.00 | €0.50 | matched |
| 30 | capture | 01a19d76-1244-7222-ad4c-43342624beb7 | €49.00 | €0.67 | matched |
| 31 | capture | 01a19d76-1743-7521-af0f-ac07d0455f92 | €35.00 | €0.50 | matched |
| 32 | capture | 01a19d76-1028-7032-9452-6f09d6c427e9 | €49.00 | €0.67 | matched |
| 33 | capture | 01a19d76-2c35-7d00-8fd1-b1244cd9dedc | €24.00 | €0.37 | matched |
| 34 | capture | 01a19d76-31d2-7398-986e-8c41eb980247 | €49.00 | €0.67 | matched |
| 35 | capture | 01a19d76-3aef-741b-9fe2-c23937e062c1 | €9.00 | €0.19 | matched |
| 36 | capture | 01a19d76-3e6b-7324-af91-638494b38e50 | €49.00 | €0.67 | matched |
| 37 | capture | 01a19d76-4ae9-7185-8978-652860b32e04 | €15.00 | €0.26 | matched |
| 38 | capture | 01a19d76-6916-7ea3-9fdc-d4bfd3d6d8c1 | €9.00 | €0.19 | matched |
| 39 | capture | 01a19d76-9dc5-7028-8a67-cc69e8263618 | €15.00 | €0.26 | matched |
| 40 | capture | 01a19d76-a360-7337-9479-faa90cb0753b | €9.00 | €0.19 | matched |
| 41 | capture | 01a19d76-aa9e-7c11-9c43-d4359499cf6e | €15.00 | €0.26 | matched |
| 42 | capture | 01a19d76-ae70-7514-9db9-4636287d8274 | €49.00 | €0.67 | matched |
| 43 | refund | 01a19d76-b8f6-761b-aa11-8b9f07eee79d | -€13.00 | €0.00 | matched |
| 44 | capture | 01a19d76-cbff-7902-b008-eeea9dacc95f | €24.00 | €0.37 | matched |
| 45 | capture | 01a19d76-e3fa-77b3-9e13-1232700b146c | €35.00 | €0.50 | matched |
| 46 | capture | 01a19d76-f9fd-7ffd-bf6d-234db075def8 | €15.00 | €0.26 | matched |
| 47 | capture | 01a19d76-fc1a-769b-93fd-4b0407b0ce3a | €9.00 | €0.19 | matched |
| 48 | capture | 01a19d76-fe62-7e9d-aad6-ef027ecaf913 | €49.00 | €0.67 | matched |
| 49 | capture | 01a19d77-3fb4-791a-9fcf-7ff3daea4127 | €15.00 | €0.26 | matched |
| 50 | capture | 01a19d77-42d7-7532-a472-e5bb67a3ddab | €49.00 | €0.67 | matched |
| 51 | capture | 01a19d77-7e6b-751d-a89c-94ef0460e766 | €24.00 | €0.37 | matched |
| 52 | capture | 01a19d77-8310-7051-8b64-c99b8ab52cfd | €24.00 | €0.37 | matched |
| 53 | capture | 01a19d77-90db-78e0-bacf-09793d3d62c9 | €15.00 | €0.26 | matched |
| 54 | capture | 01a19d77-a022-77f0-b8f1-abea21d680f4 | €49.00 | €0.67 | matched |
| 55 | capture | 01a19d77-a477-7578-8f78-47fd5b5deaa4 | €49.00 | €0.67 | matched |
| 56 | capture | 01a19d77-b274-7e70-83bb-71ebf34a1f43 | €24.00 | €0.37 | matched |
| 57 | capture | 01a19d77-d8c4-79b3-882f-f5f20494c0c3 | €9.00 | €0.19 | matched |
| 58 | capture | 01a19d77-e0bc-7224-80dd-cf2b17525d57 | €9.00 | €0.19 | matched |
| 60 | capture | 01a19d78-0a91-7b6e-90da-2ce7bbb56feb | €24.00 | €0.37 | matched |
| 62 | capture | 01a19d78-1603-7e94-82d4-960c38ebdad7 | €49.00 | €0.67 | matched |
| 63 | capture | 01a19d78-2a8c-718e-921c-d87649a5c091 | €49.00 | €0.67 | matched |
| 64 | capture | 01a19d78-3807-7c2a-b4cb-8275c39aee6d | €35.00 | €0.50 | matched |
| 65 | capture | 01a19d78-49c9-70ff-842d-41752710b18b | €9.00 | €0.19 | matched |
| 66 | capture | 01a19d78-63a4-7324-a32b-58ea13ff63e7 | €49.00 | €0.67 | matched |
| 67 | capture | 01a19d78-7643-7075-8f5d-ebb45b66b323 | €24.00 | €0.37 | matched |
| 68 | capture | 01a19d78-8d6e-7da5-975e-e813ef3ddb7a | €35.00 | €0.50 | matched |
| 69 | capture | 01a19d78-9108-754d-a3d5-b18de15ad72a | €35.00 | €0.50 | matched |
| 70 | refund | 01a19d78-a93a-75ad-85af-690a3a6a4d62 | -€7.00 | €0.00 | matched |
| 71 | capture | 01a19d78-ca6e-76cb-bc22-ef35a34cf01b | €9.00 | €0.19 | matched |
| 72 | capture | 01a19d78-d0d5-7c12-a4cf-7b84557a9b16 | €24.00 | €0.37 | matched |
| 73 | capture | 01a19d78-eb3f-7b46-b214-29050437cdea | €24.00 | €0.37 | matched |
| 74 | capture | 01a19d79-08b3-7dfe-b007-92f6d55d77df | €15.00 | €0.26 | matched |
| 75 | capture | 01a19d79-1daf-7229-801d-4a60533f123b | €49.00 | €0.67 | matched |
| 76 | capture | 01a19d79-5386-7763-a24f-ca06664fd6d2 | €35.00 | €0.50 | matched |
| 77 | capture | 01a19d79-53f0-75ee-9910-b74fc721bb99 | €15.00 | €0.26 | matched |
| 78 | capture | 01a19d79-5caa-7664-a370-e869a2dcc922 | €15.00 | €0.26 | matched |
| 79 | capture | 01a19d79-7e13-7482-9960-d4261be52c43 | €24.00 | €0.37 | matched |
| 80 | refund | 01a19d79-7eb8-7de4-be7a-84b1b380e459 | -€18.00 | €0.00 | matched |
| 81 | capture | 01a19d79-867c-72d8-8cb7-1ba9830fe183 | €9.00 | €0.19 | matched |
| 82 | capture | 01a19d79-a485-7e06-a5ce-4998b828308b | €9.00 | €0.19 | matched |
| 83 | capture | 01a19d79-b538-7904-a4ea-c9043de2eda1 | €9.00 | €0.19 | matched |
| 84 | capture | 01a19d79-fdef-7d2b-81a1-0ac3b6cd2ed6 | €24.00 | €0.37 | matched |
| 85 | capture | 01a19d7a-1150-728e-b8d4-c9036424ff93 | €35.00 | €0.50 | matched |
| 86 | capture | 01a19d7a-1b62-7074-a431-9254d6137444 | €35.00 | €0.50 | matched |
| 87 | capture | 01a19d7a-2972-74ee-99a9-9d245b55f781 | €24.00 | €0.37 | matched |
| 88 | capture | 01a19d7a-2fa8-70d6-af06-3f423a46fd57 | €35.00 | €0.50 | matched |
| 89 | capture | 01a19d7a-4f89-7691-89ed-013d590a9472 | €15.00 | €0.26 | matched |
| 90 | capture | 01a19d7a-6440-74e6-94be-4a55cc361d92 | €35.00 | €0.50 | matched |
| 91 | capture | 01a19d7a-afaa-74fe-b9e2-b40fe405f8a3 | €49.00 | €0.67 | matched |
| 92 | capture | 01a19d7a-c2a9-78f9-b405-dd09d74a3821 | €49.00 | €0.67 | matched |
| 93 | capture | 01a19d7a-c46a-721b-a2b3-6ca7ab343d21 | €15.00 | €0.26 | matched |
| 94 | capture | 01a19d7a-d4b5-7f4c-ba80-34c612ad7252 | €15.00 | €0.26 | matched |
| 95 | capture | 01a19d7a-da56-730a-b230-c4d4abfe83ee | €15.00 | €0.26 | matched |
| 96 | capture | 01a19d7b-05ac-71ec-8052-10f41967e858 | €49.00 | €0.67 | matched |
| 97 | capture | 01a19d7b-076f-7ea2-9600-d4178f0992f5 | €35.00 | €0.50 | matched |
| 98 | capture | 01a19d7b-0ccf-75f0-8ef6-3ffebf460175 | €49.00 | €0.67 | matched |
| 99 | capture | 01a19d7b-0f05-79ce-985c-4b3ad7db57bf | €9.00 | €0.19 | matched |
| 100 | capture | 01a19d7b-1ee9-7767-bc5e-527e8501ae99 | €9.00 | €0.19 | matched |
| 101 | capture | 01a19d7b-1e6b-7f23-8758-a0ad932f5dec | €49.00 | €0.67 | matched |
| 102 | capture | 01a19d7b-2998-7f66-97cf-74d0faf21b8a | €49.00 | €0.67 | matched |
| 103 | capture | 01a19d7b-5e75-71a7-ba5f-d500af1bc808 | €9.00 | €0.19 | matched |
| 104 | capture | 01a19d7b-c712-70fc-bece-bd3da364b3fd | €49.00 | €0.67 | matched |
| 107 | refund | 01a19d7c-0878-7efd-86db-48af86867fcc | -€46.00 | €0.00 | matched |
| 108 | capture | 01a19d7c-1375-7306-98c8-9785d275c7af | €15.00 | €0.26 | matched |
| 109 | capture | 01a19d7c-19ac-7b46-98cc-6133cf351b8b | €9.00 | €0.19 | matched |
| 110 | capture | 01a19d7c-1c99-76e9-bad2-57e80b34933d | €15.00 | €0.26 | matched |
| 111 | capture | 01a19d7c-1dca-772c-8195-9c014e0a70df | €35.00 | €0.50 | matched |
| 112 | capture | 01a19d7c-2018-7476-904e-86587513b53f | €9.00 | €0.19 | matched |
| 113 | capture | 01a19d7c-278f-772e-a876-18864e08ba81 | €35.00 | €0.50 | matched |
| 114 | capture | 01a19d7c-3282-7914-a6be-9c7b15c9ede3 | €9.00 | €0.19 | matched |
| 115 | capture | 01a19d7c-39e2-74b3-a7af-33365833b7c6 | €24.00 | €0.37 | matched |
| 117 | capture | 01a19d7c-619e-7000-8ba8-15b00d5db181 | €9.00 | €0.19 | matched |
| 118 | refund | 01a19d7c-6db7-7d5d-9fb5-8d615281d30f | -€11.00 | €0.00 | matched |
| 119 | capture | 01a19d7c-6e03-7950-838a-d8a6d27e31b7 | €24.00 | €0.37 | matched |
| 120 | capture | 01a19d7c-880a-7599-82b3-c907bef2ac71 | €9.00 | €0.19 | matched |
| 121 | capture | 01a19d7c-a73a-714d-b719-d25dd2f75ff5 | €49.00 | €0.67 | matched |
| 122 | capture | 01a19d7c-a935-78ea-8bf8-c95c58417968 | €24.00 | €0.37 | matched |
| 123 | capture | 01a19d7c-bd03-74ac-a07e-204de09b34f8 | €24.00 | €0.37 | matched |
| 124 | capture | 01a19d7c-be24-7195-8b1e-73e6f75758f5 | €9.00 | €0.19 | matched |
| 125 | capture | 01a19d7c-c63f-759e-931f-9587c3283029 | €9.00 | €0.19 | matched |
| 126 | capture | 01a19d7c-f34f-78bc-9b04-0b737658a8de | €15.00 | €0.26 | matched |
| 127 | capture | 01a19d7c-f941-70ff-b0de-9e725aeab148 | €15.00 | €0.26 | matched |
| 128 | capture | 01a19d7d-0d20-7258-8c80-b3ed3f3ca7c3 | €49.00 | €0.67 | matched |
| 129 | capture | 01a19d7d-25c9-7651-9298-4811611ca008 | €24.00 | €0.37 | matched |
| 130 | capture | 01a19d7d-3059-7255-8bf9-10a86ca8bdc0 | €49.00 | €0.67 | matched |
| 131 | capture | 01a19d7d-3948-7a96-84c0-bb7f67158d1f | €15.00 | €0.26 | matched |
| 132 | capture | 01a19d7d-492c-7d45-9a01-bef70a957f9e | €15.00 | €0.26 | matched |