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
- 2 Nov, 20:30131 linesclean
- 2 Nov, 20:20124 lines3 breaks
- 2 Nov, 20:10105 lines3 breaks
- 2 Nov, 20:00128 lines1 break
- 2 Nov, 19:50117 lines1 break
- 2 Nov, 19:40126 lines2 breaks
- 2 Nov, 19:30114 lines2 breaks
- 2 Nov, 19:20123 lines3 breaks
- 2 Nov, 19:10149 lines1 break
- 2 Nov, 19:00112 lines4 breaks
- 2 Nov, 18:50111 lines1 break
- 2 Nov, 18:40148 lines3 breaks
- 2 Nov, 18:30123 lines2 breaks
- 2 Nov, 18:20139 lines1 break
2 Nov, 19:00
Gross
€2,616.00
PSP fee
€41.44
Net to the bank
€2,574.56
Settlement journal
#347801
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19da5-b849-73bf-b6f6-96cfa996c479 is already settled by stl_EUR_2989410 line 55
- duplicate linethe file lists it twicecapture:01a19da8-dd64-732c-b75f-efbd051ebd04 is already settled by stl_EUR_2989410 line 88
- fee differencethe fee is not the contract feethe fee is 40, the contract says 37
- missing linein the books, not in the filecapture:01a19da3-4a91-7105-a981-8183b630cd90 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 26 | capture | 01a19da3-816b-7203-bbbf-8ac9a516c0ae | €24.00 | €0.40 | fee difference |
| 56 | capture | 01a19da5-b88b-7bb3-b5b7-4bac627d1861 | €49.00 | €0.67 | duplicate line |
| 89 | capture | 01a19da8-dd93-78f1-98fb-765570c079ff | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a19da1-f94e-7ef9-b31b-b1752e6afe28 | €15.00 | €0.26 | matched |
| 2 | capture | 01a19da2-0da7-7b76-99cf-d272cf5afdd3 | €49.00 | €0.67 | matched |
| 3 | capture | 01a19da2-12ab-7202-9994-706889ba9f16 | €49.00 | €0.67 | matched |
| 4 | capture | 01a19da2-41a1-76ea-b720-1feb8a1fd6ef | €35.00 | €0.50 | matched |
| 5 | capture | 01a19da2-4654-7be2-a2b6-8dc103dab215 | €49.00 | €0.67 | matched |
| 6 | capture | 01a19da2-4eb4-73a7-9967-a1836e898acd | €9.00 | €0.19 | matched |
| 7 | capture | 01a19da2-5dc9-70ee-9983-c13d756a6bbc | €24.00 | €0.37 | matched |
| 8 | capture | 01a19da2-67d4-79cf-b641-39384c791888 | €9.00 | €0.19 | matched |
| 9 | capture | 01a19da2-827e-742c-81ac-8992f8681f0a | €24.00 | €0.37 | matched |
| 10 | capture | 01a19da2-aa93-73f3-b188-33a23c93f30f | €15.00 | €0.26 | matched |
| 11 | capture | 01a19da2-b55e-7266-aacd-47b3ecdb12db | €49.00 | €0.67 | matched |
| 12 | capture | 01a19da2-b83d-7891-8918-68137172abdb | €49.00 | €0.67 | matched |
| 13 | capture | 01a19da2-cf49-7a80-b7a2-4ef34b3fdac9 | €15.00 | €0.26 | matched |
| 14 | capture | 01a19da2-d12c-7dca-9c5e-da08ad51190f | €15.00 | €0.26 | matched |
| 15 | capture | 01a19da2-fb32-75c8-b39f-a55c6c0bc195 | €15.00 | €0.26 | matched |
| 16 | capture | 01a19da3-297f-7826-9f45-a3cf8a77e90f | €24.00 | €0.37 | matched |
| 17 | capture | 01a19da3-39a0-70b0-a36a-7d3a222d79f9 | €24.00 | €0.37 | matched |
| 18 | capture | 01a19da3-3ff7-7452-b2d8-e2c19fb5fda2 | €9.00 | €0.19 | matched |
| 19 | capture | 01a19da3-5107-7f10-942c-43b00bd4b441 | €49.00 | €0.67 | matched |
| 20 | capture | 01a19da3-5b53-7c89-b0e1-339c4c2eed32 | €15.00 | €0.26 | matched |
| 21 | capture | 01a19da3-5d81-7622-9959-c566703f0ee0 | €24.00 | €0.37 | matched |
| 22 | capture | 01a19da3-6292-7d86-9859-8fd832781019 | €9.00 | €0.19 | matched |
| 23 | capture | 01a19da3-653b-70b9-a7ee-9c26bde62a9e | €35.00 | €0.50 | matched |
| 24 | capture | 01a19da3-6672-7e13-8e7d-d726b8518ee3 | €35.00 | €0.50 | matched |
| 25 | capture | 01a19da3-80c9-7e35-a892-518f5bb2b14d | €9.00 | €0.19 | matched |
| 27 | refund | 01a19da3-8bef-7083-b80a-df5c1e531221 | -€4.00 | €0.00 | matched |
| 28 | capture | 01a19da3-98cb-7465-b0d2-eca07c4683c5 | €35.00 | €0.50 | matched |
| 29 | capture | 01a19da3-9e63-7295-a554-ae061529c73c | €15.00 | €0.26 | matched |
| 30 | capture | 01a19da3-a9d7-7e26-bfdc-957e73720483 | €49.00 | €0.67 | matched |
| 31 | capture | 01a19da3-adae-719a-ba24-68606ce1c0db | €15.00 | €0.26 | matched |
| 32 | capture | 01a19da3-be41-7579-830d-d9b80838a6b6 | €35.00 | €0.50 | matched |
| 33 | refund | 01a19da3-c23f-738f-a086-1b0b9705f1cb | -€28.00 | €0.00 | matched |
| 34 | capture | 01a19da3-d665-7f5d-9e9a-36e33405ecda | €49.00 | €0.67 | matched |
| 35 | capture | 01a19da3-f09d-7717-a7c8-82292548aa5c | €15.00 | €0.26 | matched |
| 36 | capture | 01a19da3-f7ae-7f8e-ade5-7edc85b0d434 | €49.00 | €0.67 | matched |
| 37 | capture | 01a19da3-f9df-77f0-aac7-79e247b7f992 | €49.00 | €0.67 | matched |
| 38 | capture | 01a19da4-068b-77a4-810a-4d56c1a0d127 | €24.00 | €0.37 | matched |
| 39 | capture | 01a19da4-158a-79d7-bf35-84ffc24d6af7 | €49.00 | €0.67 | matched |
| 40 | refund | 01a19da4-552c-7ed7-a1d5-173a14fb574b | -€23.00 | €0.00 | matched |
| 41 | capture | 01a19da4-7880-7f2b-86bd-4e32b3ed4947 | €49.00 | €0.67 | matched |
| 42 | capture | 01a19da4-7aad-7844-ac31-2a5eab759226 | €49.00 | €0.67 | matched |
| 43 | capture | 01a19da4-8b2f-7366-aa92-be137b815112 | €24.00 | €0.37 | matched |
| 44 | capture | 01a19da4-a972-7696-91da-bdf6495e314d | €49.00 | €0.67 | matched |
| 45 | capture | 01a19da4-c162-7d89-9b35-cd453f34189c | €35.00 | €0.50 | matched |
| 46 | capture | 01a19da4-e588-7072-ac16-51f004731e88 | €9.00 | €0.19 | matched |
| 47 | capture | 01a19da4-ea13-7727-ab6c-620d2cedc588 | €9.00 | €0.19 | matched |
| 48 | capture | 01a19da4-fe45-7c78-92c2-4459abe5907e | €9.00 | €0.19 | matched |
| 49 | capture | 01a19da5-1686-761c-9890-08c1425bde24 | €9.00 | €0.19 | matched |
| 50 | capture | 01a19da5-2bc1-7c4b-9401-17efc148aa11 | €15.00 | €0.26 | matched |
| 51 | refund | 01a19da5-4e1c-77a0-ae2b-ceb749ce5484 | -€9.00 | €0.00 | matched |
| 52 | capture | 01a19da5-65a7-738f-8a35-036917524557 | €49.00 | €0.67 | matched |
| 53 | capture | 01a19da5-a85e-75ed-afa5-f88ac6a60dae | €35.00 | €0.50 | matched |
| 54 | capture | 01a19da5-af88-7e16-b015-943fe5880802 | €9.00 | €0.19 | matched |
| 55 | capture | 01a19da5-b88b-7bb3-b5b7-4bac627d1861 | €49.00 | €0.67 | matched |
| 57 | capture | 01a19da6-1d9a-7d8e-b5ef-c890f285e250 | €24.00 | €0.37 | matched |
| 58 | capture | 01a19da6-52f4-77d3-ac71-e66fb2dbf4d6 | €35.00 | €0.50 | matched |
| 59 | capture | 01a19da6-7dcb-7ff6-b962-bcea60406362 | €24.00 | €0.37 | matched |
| 60 | capture | 01a19da6-7e3d-739a-b119-9e9f25c76f96 | €9.00 | €0.19 | matched |
| 61 | capture | 01a19da6-843d-7384-904e-769d4089501d | €15.00 | €0.26 | matched |
| 62 | capture | 01a19da6-d684-776d-bb1c-40f7282b0cee | €35.00 | €0.50 | matched |
| 63 | capture | 01a19da6-e326-7383-85ed-e4e47eb1144f | €24.00 | €0.37 | matched |
| 64 | capture | 01a19da6-f67f-7cb9-bac9-24c1ea0c26de | €24.00 | €0.37 | matched |
| 65 | refund | 01a19da7-0017-753b-8060-0c95a3644009 | -€23.00 | €0.00 | matched |
| 66 | capture | 01a19da7-0166-72c1-aa5a-7d836dd93c0b | €15.00 | €0.26 | matched |
| 67 | capture | 01a19da7-18d6-7c8d-b0be-0001f745fdd4 | €35.00 | €0.50 | matched |
| 68 | capture | 01a19da7-1cfe-7c68-9bdd-6bd0627013c6 | €49.00 | €0.67 | matched |
| 69 | capture | 01a19da7-53af-7db1-b4a9-7cfd5c5153c3 | €49.00 | €0.67 | matched |
| 70 | capture | 01a19da7-6940-714c-b6d0-57ba1898671a | €24.00 | €0.37 | matched |
| 71 | capture | 01a19da7-6c4c-7a46-aaec-bb036395fe19 | €24.00 | €0.37 | matched |
| 72 | capture | 01a19da7-75ba-7460-b040-4ced1870b2a4 | €15.00 | €0.26 | matched |
| 73 | capture | 01a19da7-7f31-7918-aa90-63fe57abbf16 | €24.00 | €0.37 | matched |
| 74 | capture | 01a19da7-8bb0-700b-9d9f-e4a02423f244 | €15.00 | €0.26 | matched |
| 75 | capture | 01a19da7-ae9e-735a-bc11-cfa092dcd617 | €35.00 | €0.50 | matched |
| 76 | capture | 01a19da7-b2d4-7b34-b831-2f32cd095c87 | €15.00 | €0.26 | matched |
| 77 | capture | 01a19da7-ba2c-7f8c-8afc-d23858783cd9 | €35.00 | €0.50 | matched |
| 78 | refund | 01a19da7-d8b9-7fcc-aff1-d9849d0a701f | -€13.00 | €0.00 | matched |
| 79 | refund | 01a19da7-df34-7cb6-932a-0773c41b63b8 | -€22.00 | €0.00 | matched |
| 80 | capture | 01a19da7-e1a6-73ed-8909-9644f9fd6453 | €9.00 | €0.19 | matched |
| 81 | capture | 01a19da8-2acd-74e4-a24b-fcd6bbd0fc50 | €49.00 | €0.67 | matched |
| 82 | capture | 01a19da8-4bc3-73dc-af1f-d9679897e45e | €35.00 | €0.50 | matched |
| 83 | capture | 01a19da8-5e13-7248-9acf-9d5c6bf0b002 | €9.00 | €0.19 | matched |
| 84 | capture | 01a19da8-6f81-7716-a0b4-095535268df4 | €15.00 | €0.26 | matched |
| 85 | capture | 01a19da8-8254-7a4e-9a5a-e5bbd481fd4d | €9.00 | €0.19 | matched |
| 86 | capture | 01a19da8-aba7-7f95-8125-148a330798c0 | €9.00 | €0.19 | matched |
| 87 | capture | 01a19da8-c149-7428-bc1f-c079a46257e0 | €24.00 | €0.37 | matched |
| 88 | capture | 01a19da8-dd93-78f1-98fb-765570c079ff | €24.00 | €0.37 | matched |
| 90 | capture | 01a19da8-f264-7289-84ee-beaf3aad4c0b | €24.00 | €0.37 | matched |
| 91 | capture | 01a19da8-f2c3-77f2-9bcc-755ef975b97c | €15.00 | €0.26 | matched |
| 92 | capture | 01a19da8-f9d8-7ba8-89a3-d4dc4a11ec6d | €15.00 | €0.26 | matched |
| 93 | capture | 01a19da8-fc95-7e5e-9b0c-0c0f9607c6f9 | €9.00 | €0.19 | matched |
| 94 | capture | 01a19da9-42be-761c-b858-8ab90a552c54 | €24.00 | €0.37 | matched |
| 95 | capture | 01a19da9-6299-7832-b116-5fa12acd72cf | €35.00 | €0.50 | matched |
| 96 | capture | 01a19da9-9d21-74f4-ae02-c9b58d099fa2 | €49.00 | €0.67 | matched |
| 97 | capture | 01a19da9-ad92-7a04-bb71-e44ac235e3a5 | €24.00 | €0.37 | matched |
| 98 | capture | 01a19da9-c08e-7763-8bb0-dd291ac84473 | €9.00 | €0.19 | matched |
| 99 | capture | 01a19da9-cd40-7e82-80e0-518548d0ffc1 | €24.00 | €0.37 | matched |
| 100 | capture | 01a19da9-e590-7783-b64c-60023e971301 | €24.00 | €0.37 | matched |
| 101 | refund | 01a19da9-fa1a-7792-a32d-082debc6fc6e | -€8.00 | €0.00 | matched |
| 102 | capture | 01a19daa-0bac-7152-829b-7ed036eb8f4f | €9.00 | €0.19 | matched |
| 103 | capture | 01a19daa-3ac8-772e-8895-730bc96bdbc4 | €35.00 | €0.50 | matched |
| 104 | capture | 01a19daa-7839-7bba-b653-667e379a5a3b | €15.00 | €0.26 | matched |
| 105 | capture | 01a19daa-8948-79bb-9dc1-ef54b5597ec1 | €24.00 | €0.37 | matched |
| 106 | capture | 01a19daa-a4ca-75fc-9f8a-ae3b9eec9cb6 | €49.00 | €0.67 | matched |
| 107 | refund | 01a19daa-c478-795d-b87e-51c7cab412bb | -€7.00 | €0.00 | matched |
| 108 | capture | 01a19daa-c7f2-738e-8f8a-a2f8d967132b | €35.00 | €0.50 | matched |
| 109 | capture | 01a19daa-e3ee-7892-b751-d1bcb5f153b4 | €35.00 | €0.50 | matched |
| 110 | capture | 01a19daa-fe3b-7a1c-b4ef-d116f393112b | €24.00 | €0.37 | matched |
| 111 | capture | 01a19dab-0e2d-7258-9698-a3aeb2a6c4d2 | €24.00 | €0.37 | matched |
| 112 | capture | 01a19dab-17a1-73ef-8439-39af2837d6c4 | €9.00 | €0.19 | matched |