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
- 16 Oct, 21:50118 lines2 breaks
- 16 Oct, 21:40111 linesclean
- 16 Oct, 21:30107 lines3 breaks
- 16 Oct, 21:20119 linesclean
- 16 Oct, 21:10103 linesclean
- 16 Oct, 21:00121 lines6 breaks
- 16 Oct, 20:50106 lines6 breaks
- 16 Oct, 20:40107 lines4 breaks
- 16 Oct, 20:30127 lines3 breaks
- 16 Oct, 20:20132 lines1 break
- 16 Oct, 20:10129 lines2 breaks
- 16 Oct, 20:00145 lines1 break
- 16 Oct, 19:50129 lines2 breaks
- 16 Oct, 19:40128 lines4 breaks
16 Oct, 21:00
Gross
€2,876.00
PSP fee
€45.45
Net to the bank
€2,830.55
Settlement journal
#39678
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14685-8d67-73f8-9106-9a521c3e44bc is already settled by stl_EUR_2986974 line 24
- fee differencethe fee is not the contract feethe fee is 70, the contract says 67
- missing linein the books, not in the filecapture:01a14685-552a-74ad-9df6-956e534737ee is in no file
- missing linein the books, not in the filecapture:01a14686-1592-7484-9726-da84027ee05c is in no file
- missing linein the books, not in the filecapture:01a14688-cd34-7ed3-8c81-cf92ac8a911b is in no file
- missing linein the books, not in the filecapture:01a1468a-48c5-7025-9973-cb54ee1a97b9 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 25 | capture | 01a14685-8dc1-791b-98b2-a004aca1fd74 | €35.00 | €0.50 | duplicate line |
| 92 | capture | 01a14689-e6a8-764e-85c8-3baef7227da5 | €49.00 | €0.70 | fee difference |
| 1 | capture | 01a1467c-f737-7b9a-ad57-b176e7490750 | €9.00 | €0.19 | matched |
| 2 | capture | 01a1467f-27bb-7218-9305-10b2e0f4347d | €15.00 | €0.26 | matched |
| 3 | capture | 01a1467f-7f74-75d2-9e95-dc4b7e820225 | €15.00 | €0.26 | matched |
| 4 | capture | 01a14681-e25d-74e2-b07c-2eb017d7b0d0 | €49.00 | €0.67 | matched |
| 5 | capture | 01a14684-3c7b-76dc-8ac3-40a66879ce0e | €9.00 | €0.19 | matched |
| 6 | capture | 01a14684-4005-75df-9c39-eec678cda753 | €49.00 | €0.67 | matched |
| 7 | capture | 01a14684-4927-7d13-96f7-b6164b9f788e | €35.00 | €0.50 | matched |
| 8 | capture | 01a14684-6938-72ca-a693-e1789426583f | €15.00 | €0.26 | matched |
| 9 | capture | 01a14684-716c-71da-a93d-2f25a21c9f0e | €49.00 | €0.67 | matched |
| 10 | capture | 01a14684-87d1-785c-aefc-12b944bfbcc6 | €49.00 | €0.67 | matched |
| 11 | capture | 01a14684-9351-78b5-bac5-a59823184830 | €9.00 | €0.19 | matched |
| 12 | capture | 01a14684-9369-7354-a7d3-f01d996f89a8 | €49.00 | €0.67 | matched |
| 13 | capture | 01a14684-9b77-7378-969c-53d3ccd7b595 | €49.00 | €0.67 | matched |
| 14 | capture | 01a14684-cb7c-73d1-aca9-92f2b0d2b5cf | €35.00 | €0.50 | matched |
| 15 | capture | 01a14684-d522-7ac0-ac7b-62e2c97ca671 | €35.00 | €0.50 | matched |
| 16 | capture | 01a14684-f637-7546-a0cf-b086287ec275 | €24.00 | €0.37 | matched |
| 17 | capture | 01a14684-f7b7-7f3d-93fa-eea0b1144600 | €35.00 | €0.50 | matched |
| 18 | capture | 01a14685-3450-722c-a19e-6851c14ef5be | €15.00 | €0.26 | matched |
| 19 | capture | 01a14685-3dda-77d7-bbf8-5eb5f63d61ae | €24.00 | €0.37 | matched |
| 20 | capture | 01a14685-3ed2-7f3c-baea-e7c7e6d73848 | €9.00 | €0.19 | matched |
| 21 | capture | 01a14685-5b7c-74a4-b36e-9b41e4ae8646 | €49.00 | €0.67 | matched |
| 22 | capture | 01a14685-6538-70a3-bbe1-56729076f481 | €35.00 | €0.50 | matched |
| 23 | capture | 01a14685-87d8-703b-9c49-38062e14e5e8 | €24.00 | €0.37 | matched |
| 24 | capture | 01a14685-8dc1-791b-98b2-a004aca1fd74 | €35.00 | €0.50 | matched |
| 26 | capture | 01a14685-a895-7169-a155-72370874433b | €35.00 | €0.50 | matched |
| 27 | capture | 01a14685-aa7f-7bc2-82a2-7810e864f7f4 | €35.00 | €0.50 | matched |
| 28 | capture | 01a14685-aeb2-71bf-9dbc-48937f578a21 | €9.00 | €0.19 | matched |
| 29 | capture | 01a14685-b753-7174-a085-972d8a7c4c5d | €9.00 | €0.19 | matched |
| 30 | capture | 01a14685-ec91-712d-8ad0-41ef6af6e9b6 | €9.00 | €0.19 | matched |
| 31 | capture | 01a14685-fbd7-7f25-afab-60260b68d74e | €49.00 | €0.67 | matched |
| 32 | capture | 01a14686-0898-77fd-9efb-71e75a560410 | €15.00 | €0.26 | matched |
| 33 | capture | 01a14686-2166-7511-94e2-8cdb2913e895 | €35.00 | €0.50 | matched |
| 34 | capture | 01a14686-36e7-7937-9814-7b62c222ce91 | €15.00 | €0.26 | matched |
| 35 | capture | 01a14686-3806-78c8-86c2-14bc1ef0af43 | €35.00 | €0.50 | matched |
| 36 | capture | 01a14686-3f2b-72a6-ace3-7a24f2c2597a | €49.00 | €0.67 | matched |
| 37 | capture | 01a14686-417c-7bd8-826a-51754ac87d07 | €35.00 | €0.50 | matched |
| 38 | capture | 01a14686-49a7-791c-98c0-dc4aa7fbf895 | €49.00 | €0.67 | matched |
| 39 | capture | 01a14686-4fe1-7fb4-b99d-e968c2b444e3 | €35.00 | €0.50 | matched |
| 40 | capture | 01a14686-71f6-7b8d-aba3-45856b677fe3 | €35.00 | €0.50 | matched |
| 41 | capture | 01a14686-8aa1-72c5-85a1-5581588e05ba | €49.00 | €0.67 | matched |
| 42 | capture | 01a14686-8ffa-7d00-8600-ed09f88a9402 | €9.00 | €0.19 | matched |
| 43 | capture | 01a14686-9e1e-75dd-80da-34ef4e7c1fdf | €9.00 | €0.19 | matched |
| 44 | capture | 01a14686-c4ce-7208-b332-c7f4dccb4fb0 | €35.00 | €0.50 | matched |
| 45 | capture | 01a14686-f3be-7f94-ad7e-0d6238eaf92b | €15.00 | €0.26 | matched |
| 46 | refund | 01a14687-05ad-7314-b5f7-8e5157a1e204 | -€4.00 | €0.00 | matched |
| 47 | capture | 01a14687-06e5-78a3-8554-c545b9a7584a | €35.00 | €0.50 | matched |
| 48 | capture | 01a14687-0cad-7876-b32c-003a53d9b20b | €9.00 | €0.19 | matched |
| 49 | capture | 01a14687-0e0c-774b-be6f-8c11e5a06fee | €9.00 | €0.19 | matched |
| 50 | capture | 01a14687-1c00-7473-be05-f9771d8f75c1 | €49.00 | €0.67 | matched |
| 51 | capture | 01a14687-41a4-7182-af29-cd74564ec56e | €24.00 | €0.37 | matched |
| 52 | capture | 01a14687-4891-7140-907c-a25e805b9ef1 | €24.00 | €0.37 | matched |
| 53 | capture | 01a14687-5109-7e21-9b79-dc0839f3c32b | €35.00 | €0.50 | matched |
| 54 | capture | 01a14687-7306-7315-a358-f9859b105b00 | €9.00 | €0.19 | matched |
| 55 | capture | 01a14687-7662-7f5d-a446-279a77520c86 | €49.00 | €0.67 | matched |
| 56 | capture | 01a14687-766c-7998-984c-c40d1c48e51b | €24.00 | €0.37 | matched |
| 57 | refund | 01a14687-9674-7b21-bd9c-edb62bfa6294 | -€13.00 | €0.00 | matched |
| 58 | refund | 01a14687-af1e-7ab6-b84a-ed1aefb55676 | -€38.00 | €0.00 | matched |
| 59 | capture | 01a14687-b843-7e7d-b075-ec61b41caadb | €35.00 | €0.50 | matched |
| 60 | capture | 01a14687-b923-726d-9871-410076e932d5 | €35.00 | €0.50 | matched |
| 61 | capture | 01a14687-bba8-7dc9-9a0e-bbaa61a4ac6d | €9.00 | €0.19 | matched |
| 62 | capture | 01a14687-bffe-7b1d-9b81-40fcb03de332 | €35.00 | €0.50 | matched |
| 63 | capture | 01a14687-c211-7ed6-9d1d-78bd2ca059fa | €24.00 | €0.37 | matched |
| 64 | capture | 01a14687-cfde-7110-aa1c-9b7a973ec0c7 | €24.00 | €0.37 | matched |
| 65 | capture | 01a14687-d0df-784b-bf26-b8545d155665 | €49.00 | €0.67 | matched |
| 66 | capture | 01a14687-d6ac-78fa-baba-65d230b16f53 | €15.00 | €0.26 | matched |
| 67 | capture | 01a14687-e75e-7420-9880-6dd4ae392acd | €35.00 | €0.50 | matched |
| 68 | refund | 01a14687-f8a7-7f46-af7b-4d11437f291b | -€4.00 | €0.00 | matched |
| 69 | refund | 01a14687-fa94-7718-bbaf-e2e49e7d36cf | -€33.00 | €0.00 | matched |
| 70 | refund | 01a14688-159e-748d-9854-c8d82e3f664a | -€14.00 | €0.00 | matched |
| 71 | capture | 01a14688-3218-762e-b432-cbb174828f09 | €9.00 | €0.19 | matched |
| 72 | refund | 01a14688-35d7-78e0-929a-176ad3d480db | -€28.00 | €0.00 | matched |
| 73 | capture | 01a14688-4359-7e47-8e7c-893b6150ca89 | €49.00 | €0.67 | matched |
| 74 | capture | 01a14688-467b-75a6-b623-ea853228e83a | €9.00 | €0.19 | matched |
| 75 | capture | 01a14688-4a93-7dbe-9c4d-c561d99573b1 | €9.00 | €0.19 | matched |
| 76 | capture | 01a14688-4b45-7e38-ac9f-49d0d4f53ae9 | €9.00 | €0.19 | matched |
| 77 | capture | 01a14688-63fb-728f-8087-d394fafb4ca7 | €15.00 | €0.26 | matched |
| 78 | capture | 01a14688-7627-7d07-8c43-b48e86985138 | €24.00 | €0.37 | matched |
| 79 | capture | 01a14688-a1b6-71d4-8677-ccc24e5f8b13 | €9.00 | €0.19 | matched |
| 80 | refund | 01a14688-b2c2-70fd-9661-0c71d6372a2b | -€8.00 | €0.00 | matched |
| 81 | capture | 01a14688-de4d-7314-94fc-d5e7328ebee6 | €9.00 | €0.19 | matched |
| 82 | capture | 01a14689-236f-76b2-acf7-a5f5427ae448 | €35.00 | €0.50 | matched |
| 83 | capture | 01a14689-33f6-77b4-b628-153d6afef55d | €35.00 | €0.50 | matched |
| 84 | capture | 01a14689-3911-7822-ac42-46955cab3216 | €15.00 | €0.26 | matched |
| 85 | capture | 01a14689-626f-77e8-977f-e95f77a5b147 | €9.00 | €0.19 | matched |
| 86 | capture | 01a14689-6692-76da-981d-6a32713922a9 | €49.00 | €0.67 | matched |
| 87 | capture | 01a14689-8272-7390-9ce8-fd929d9d4315 | €49.00 | €0.67 | matched |
| 88 | capture | 01a14689-8fc1-7d9e-9540-6634fe8cc63f | €35.00 | €0.50 | matched |
| 89 | capture | 01a14689-9423-7227-bf5e-e820d4012e7b | €15.00 | €0.26 | matched |
| 90 | capture | 01a14689-c9f5-7924-b74b-130ad7b61939 | €49.00 | €0.67 | matched |
| 91 | capture | 01a14689-c9ae-7afb-98bf-5bc11188b2c1 | €9.00 | €0.19 | matched |
| 93 | capture | 01a14689-eb46-7bde-a243-07c980038091 | €35.00 | €0.50 | matched |
| 94 | capture | 01a14689-fde9-72b1-a8c5-612b873a78a0 | €24.00 | €0.37 | matched |
| 95 | capture | 01a1468a-2073-747e-8c5c-60c9379c2f90 | €15.00 | €0.26 | matched |
| 96 | capture | 01a1468a-35f4-701d-90e6-b050774b2014 | €9.00 | €0.19 | matched |
| 97 | capture | 01a1468a-55b2-747e-ab2f-ba39e69e942e | €24.00 | €0.37 | matched |
| 98 | capture | 01a1468a-9349-7af1-bd34-6ce366c0bb38 | €9.00 | €0.19 | matched |
| 99 | capture | 01a1468a-952f-7c1f-a688-afbdf72bcd70 | €9.00 | €0.19 | matched |
| 100 | capture | 01a1468a-b08c-7c64-9d7f-9552a5e9ad5d | €35.00 | €0.50 | matched |
| 101 | capture | 01a1468a-c53e-750d-aaea-9e61335b0cba | €35.00 | €0.50 | matched |
| 102 | capture | 01a1468a-de4d-7823-a26d-8559ab0c5c78 | €49.00 | €0.67 | matched |
| 103 | capture | 01a1468b-242c-7e1d-97ad-77efdf0db5cf | €24.00 | €0.37 | matched |
| 104 | capture | 01a1468b-40b2-7362-9c65-20d4bf5e74c5 | €15.00 | €0.26 | matched |
| 105 | refund | 01a1468b-6d4a-7bd2-997e-a1a331b36ed0 | -€8.00 | €0.00 | matched |
| 106 | capture | 01a1468b-8456-7f48-a793-2da41dde7ae6 | €9.00 | €0.19 | matched |
| 107 | capture | 01a1468b-8ee6-769b-8974-3e15cb811a4d | €49.00 | €0.67 | matched |
| 108 | capture | 01a1468b-9aaf-7ef1-a208-a4deaefbbbc6 | €24.00 | €0.37 | matched |
| 109 | capture | 01a1468b-d61e-7432-a7dc-0b63385f423f | €15.00 | €0.26 | matched |
| 110 | capture | 01a1468c-0838-73e1-a4c4-19b585fee4b6 | €49.00 | €0.67 | matched |
| 111 | capture | 01a1468c-3272-7c20-b4ea-d43a03408192 | €15.00 | €0.26 | matched |
| 112 | capture | 01a1468c-35d7-78a9-8b07-f082e9c9a6e4 | €35.00 | €0.50 | matched |
| 113 | capture | 01a1468c-483a-75e3-a82e-27ca3042c638 | €9.00 | €0.19 | matched |
| 114 | capture | 01a1468c-50a8-729b-9482-4aa4eaa3a6df | €24.00 | €0.37 | matched |
| 115 | capture | 01a1468c-8eac-72a9-8d3a-22f335a0530c | €49.00 | €0.67 | matched |
| 116 | refund | 01a1468c-9bc1-7110-ae95-fbd6f1869273 | -€8.00 | €0.00 | matched |
| 117 | capture | 01a1468c-931b-765c-806a-2c9b8d71805a | €49.00 | €0.67 | matched |
| 118 | capture | 01a1468c-bce7-7f01-ba8e-1e082a702846 | €35.00 | €0.50 | matched |
| 119 | capture | 01a1468c-ca1b-7e55-982a-faabab04de1d | €15.00 | €0.26 | matched |
| 120 | capture | 01a1468c-d22a-7eb3-8bab-9b376d22dbd6 | €24.00 | €0.37 | matched |
| 121 | capture | 01a1468c-d60d-7eab-a7f9-9959a1f20f77 | €9.00 | €0.19 | matched |