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, 13:20124 lines2 breaks
- 2 Nov, 13:10126 lines1 break
- 2 Nov, 13:00146 lines1 break
- 2 Nov, 12:50118 linesclean
- 2 Nov, 12:40112 lines3 breaks
- 2 Nov, 12:30127 lines4 breaks
- 2 Nov, 12:20137 lines6 breaks
- 2 Nov, 12:10114 lines3 breaks
- 2 Nov, 12:00128 lines3 breaks
- 2 Nov, 11:50125 linesclean
- 2 Nov, 11:40105 lines5 breaks
- 2 Nov, 11:30136 lines2 breaks
- 2 Nov, 11:20137 lines1 break
- 2 Nov, 11:10127 lines1 break
2 Nov, 12:30
Gross
€3,074.00
PSP fee
€48.39
Net to the bank
€3,025.61
Settlement journal
#342851
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19c41-4cb6-72a2-9416-8105f54b3a7a is already settled by stl_EUR_2989371 line 60
- fee differencethe fee is not the contract feethe fee is 40, the contract says 37
- fee differencethe fee is not the contract feethe fee is 71, the contract says 67
- missing linein the books, not in the filecapture:01a19c41-8fd1-7bd3-b41f-acf5b64eabc2 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 2 | capture | 01a19c3a-659c-7f34-a72c-7b9606a32176 | €9.00 | €0.21 | fee difference |
| 5 | capture | 01a19c3c-3cd7-73d9-abf0-9e7fabf6891c | €49.00 | €0.67 | duplicate line |
| 10 | capture | 01a19c3d-1992-7763-9a9d-8e062e621c6e | €24.00 | €0.40 | fee difference |
| 61 | capture | 01a19c41-4d04-7ce7-996f-403dd700186d | €35.00 | €0.50 | duplicate line |
| 124 | capture | 01a19c45-ec91-78ce-8d1e-cd97341e4e0b | €49.00 | €0.71 | fee difference |
| 1 | capture | 01a19c37-33cb-738f-8966-f68aca0d8e4d | €35.00 | €0.50 | matched |
| 3 | capture | 01a19c3a-973e-7723-a301-d183dc9684a1 | €9.00 | €0.19 | matched |
| 4 | capture | 01a19c3c-3cd7-73d9-abf0-9e7fabf6891c | €49.00 | €0.67 | matched |
| 6 | capture | 01a19c3c-ebdf-77ec-81b6-91eae8d2d16f | €15.00 | €0.26 | matched |
| 7 | capture | 01a19c3c-feeb-78e6-a6bb-797f6840cf4b | €35.00 | €0.50 | matched |
| 8 | capture | 01a19c3d-18b7-7a0c-90f5-f1592055160d | €24.00 | €0.37 | matched |
| 9 | capture | 01a19c3d-1b63-7631-893e-fbb02c555761 | €9.00 | €0.19 | matched |
| 11 | capture | 01a19c3d-1fd8-7fd1-aa69-da923fb40097 | €49.00 | €0.67 | matched |
| 12 | capture | 01a19c3d-7266-7cb8-803a-adc05303484b | €49.00 | €0.67 | matched |
| 13 | capture | 01a19c3d-7a25-7d07-b3a9-175efd6bd853 | €49.00 | €0.67 | matched |
| 14 | capture | 01a19c3d-9e4b-773c-9b16-9e403a736e74 | €35.00 | €0.50 | matched |
| 15 | capture | 01a19c3d-ae87-7f4a-bb6c-abb04a0e19bd | €15.00 | €0.26 | matched |
| 16 | capture | 01a19c3d-c250-7a60-b7e3-9d536c5cf85d | €35.00 | €0.50 | matched |
| 17 | capture | 01a19c3d-e012-76e8-87fe-ed29e2b4529f | €49.00 | €0.67 | matched |
| 18 | refund | 01a19c3e-0997-7627-9fa6-1555dcf4c373 | -€4.00 | €0.00 | matched |
| 19 | capture | 01a19c3e-164a-740e-ae3c-dd05c0bb0990 | €24.00 | €0.37 | matched |
| 20 | capture | 01a19c3e-1d4e-768b-85b2-36ae9220d180 | €9.00 | €0.19 | matched |
| 21 | capture | 01a19c3e-7463-76a0-8f97-c0207ae99151 | €35.00 | €0.50 | matched |
| 22 | capture | 01a19c3e-9603-70c3-9bce-d768cd33153d | €49.00 | €0.67 | matched |
| 23 | capture | 01a19c3e-97f4-7f19-90bf-1f47db787e1b | €24.00 | €0.37 | matched |
| 24 | capture | 01a19c3e-9cff-7fbb-b16f-5c83043a32c5 | €49.00 | €0.67 | matched |
| 25 | capture | 01a19c3e-b3fc-728a-b74b-d74fef710502 | €49.00 | €0.67 | matched |
| 26 | capture | 01a19c3e-c705-77a7-b34b-667b4a13b4fd | €49.00 | €0.67 | matched |
| 27 | capture | 01a19c3e-c9d9-7fcf-80ed-3bb8a127ce18 | €15.00 | €0.26 | matched |
| 28 | capture | 01a19c3e-dfd2-711f-afff-3b026271251d | €35.00 | €0.50 | matched |
| 29 | capture | 01a19c3e-f704-755e-a17e-b4f8b4d07180 | €9.00 | €0.19 | matched |
| 30 | capture | 01a19c3e-fda6-7797-8365-96bc44261b16 | €49.00 | €0.67 | matched |
| 31 | refund | 01a19c3f-17ab-7629-92bb-52cc94cdc61b | -€32.00 | €0.00 | matched |
| 32 | refund | 01a19c3f-2c13-70e3-a49f-f3b8ddcc4955 | -€48.00 | €0.00 | matched |
| 33 | capture | 01a19c3f-7360-7f8b-aa74-d60a5cbc223d | €35.00 | €0.50 | matched |
| 34 | capture | 01a19c3f-8f87-760d-9009-e299c5219308 | €9.00 | €0.19 | matched |
| 35 | capture | 01a19c3f-bda1-7c8f-a385-4209a6680678 | €24.00 | €0.37 | matched |
| 36 | capture | 01a19c3f-d2b6-7be8-8d15-380eaeeee70d | €9.00 | €0.19 | matched |
| 37 | capture | 01a19c40-1ddb-7254-a42c-b8be040ce5db | €15.00 | €0.26 | matched |
| 38 | capture | 01a19c40-1f78-7f8f-9269-27a9ee3b84d5 | €9.00 | €0.19 | matched |
| 39 | capture | 01a19c40-2548-7e06-ac80-9774fdbcd06c | €15.00 | €0.26 | matched |
| 40 | capture | 01a19c40-26e2-799c-9259-73465322a4b8 | €15.00 | €0.26 | matched |
| 41 | capture | 01a19c40-4e21-706c-9e2c-61767e04f13b | €15.00 | €0.26 | matched |
| 42 | capture | 01a19c40-72ca-7499-94ba-560cc03d6119 | €24.00 | €0.37 | matched |
| 43 | capture | 01a19c40-5dd8-7b2f-be7e-4e337f0026be | €15.00 | €0.26 | matched |
| 44 | capture | 01a19c40-78d5-7891-a2e1-ba2359fd5d66 | €9.00 | €0.19 | matched |
| 45 | capture | 01a19c40-c18d-7457-a89c-7d1d60b5085f | €49.00 | €0.67 | matched |
| 46 | capture | 01a19c40-cb4f-7982-92b2-02ca0f7026dc | €24.00 | €0.37 | matched |
| 47 | capture | 01a19c40-d556-788e-89e9-1eebab9fab28 | €24.00 | €0.37 | matched |
| 48 | capture | 01a19c40-d5b9-70a6-b77c-d1857ab4d8c2 | €15.00 | €0.26 | matched |
| 49 | capture | 01a19c40-d5db-71b7-8605-09629cc4b0ca | €35.00 | €0.50 | matched |
| 50 | capture | 01a19c40-dac1-7694-9efb-34bbc408f9ee | €15.00 | €0.26 | matched |
| 51 | capture | 01a19c40-dad6-76d3-9cf7-6300507cf09a | €35.00 | €0.50 | matched |
| 52 | capture | 01a19c40-e23f-7557-a163-7cd676f8c1b8 | €24.00 | €0.37 | matched |
| 53 | refund | 01a19c40-eb21-7d08-a1fe-46cdfe440eb6 | -€20.00 | €0.00 | matched |
| 54 | capture | 01a19c40-e297-7215-9bb6-6f2d651d255a | €35.00 | €0.50 | matched |
| 55 | capture | 01a19c40-f5cd-7aaf-9200-b41f015526f5 | €24.00 | €0.37 | matched |
| 56 | capture | 01a19c40-fb9d-7cd6-b005-7a4172c6ba9f | €15.00 | €0.26 | matched |
| 57 | capture | 01a19c41-28d6-71e2-a14e-aec19f912bc5 | €49.00 | €0.67 | matched |
| 58 | capture | 01a19c41-3208-71fc-9f25-527c6d74629b | €24.00 | €0.37 | matched |
| 59 | refund | 01a19c41-4755-7e5f-924a-531411e2911c | -€11.00 | €0.00 | matched |
| 60 | capture | 01a19c41-4d04-7ce7-996f-403dd700186d | €35.00 | €0.50 | matched |
| 62 | capture | 01a19c41-60e7-781f-a5e0-92d89328b975 | €49.00 | €0.67 | matched |
| 63 | capture | 01a19c41-9a46-733c-aab8-795bcedce3a8 | €15.00 | €0.26 | matched |
| 64 | capture | 01a19c41-a73f-72ae-967f-d4910b7ae75c | €35.00 | €0.50 | matched |
| 65 | capture | 01a19c41-c63b-76fa-bede-261fd0b9493f | €24.00 | €0.37 | matched |
| 66 | capture | 01a19c41-d17d-70fe-b8bb-9f2e548afbba | €15.00 | €0.26 | matched |
| 67 | capture | 01a19c41-d88b-70a5-9883-badba735abbc | €9.00 | €0.19 | matched |
| 68 | capture | 01a19c41-db51-7e80-87bd-69ff80aebed7 | €24.00 | €0.37 | matched |
| 69 | capture | 01a19c41-e33d-76aa-9cbf-f3b2b46a2cdc | €24.00 | €0.37 | matched |
| 70 | capture | 01a19c41-e85c-7196-9440-a8b0c0df22ee | €9.00 | €0.19 | matched |
| 71 | capture | 01a19c41-f7bd-772a-bdfd-5dc213b89fbb | €49.00 | €0.67 | matched |
| 72 | refund | 01a19c42-0b34-7089-8577-62decc953dea | -€6.00 | €0.00 | matched |
| 73 | capture | 01a19c42-14c6-7973-b08a-846a751e3c9a | €9.00 | €0.19 | matched |
| 74 | capture | 01a19c42-16ea-7b80-a8af-433a95b767a1 | €35.00 | €0.50 | matched |
| 75 | capture | 01a19c42-191c-7582-a472-6adfb0cb4d9b | €49.00 | €0.67 | matched |
| 76 | capture | 01a19c42-21cd-71c9-9d64-3d2686de62d2 | €35.00 | €0.50 | matched |
| 77 | capture | 01a19c42-240a-777b-9b3b-7a44139ec4d6 | €9.00 | €0.19 | matched |
| 78 | refund | 01a19c42-43ee-7088-a23b-b9dd7d894135 | -€5.00 | €0.00 | matched |
| 79 | capture | 01a19c42-589e-74e4-a05d-cfad4a1eabd2 | €9.00 | €0.19 | matched |
| 80 | capture | 01a19c42-5df0-7ce1-9f74-457e29c79a76 | €35.00 | €0.50 | matched |
| 81 | capture | 01a19c42-7222-72b6-ba79-b79301ddbd13 | €35.00 | €0.50 | matched |
| 82 | refund | 01a19c42-728f-71ec-bdc5-46348bca18ec | -€17.00 | €0.00 | matched |
| 83 | capture | 01a19c42-9500-729e-ad1b-aec82a1549a0 | €35.00 | €0.50 | matched |
| 84 | capture | 01a19c42-a795-7945-9fb3-76aeef1e83a2 | €35.00 | €0.50 | matched |
| 85 | capture | 01a19c42-b307-7298-8067-b1684bfbf9ac | €9.00 | €0.19 | matched |
| 86 | capture | 01a19c42-c249-745f-b388-57a5220cf207 | €24.00 | €0.37 | matched |
| 87 | capture | 01a19c42-cc13-7438-b8d5-14c852df0b08 | €49.00 | €0.67 | matched |
| 88 | capture | 01a19c42-e160-7130-8098-8095c1c4b2f3 | €49.00 | €0.67 | matched |
| 89 | capture | 01a19c42-e1ac-7b98-adf4-dd0eb6e5ad48 | €15.00 | €0.26 | matched |
| 90 | capture | 01a19c42-eefc-73e6-a3a8-b65dbc5f92bf | €15.00 | €0.26 | matched |
| 91 | capture | 01a19c43-0908-7a8c-b6cd-f1a4c7404692 | €49.00 | €0.67 | matched |
| 92 | capture | 01a19c43-32b6-7c47-a82f-609c983565e8 | €15.00 | €0.26 | matched |
| 93 | capture | 01a19c43-377e-740c-b84c-5fc7df81a411 | €49.00 | €0.67 | matched |
| 94 | capture | 01a19c43-3c62-7e75-93c2-013324eef7d9 | €24.00 | €0.37 | matched |
| 95 | capture | 01a19c43-4162-7f5f-828c-1882b169d914 | €9.00 | €0.19 | matched |
| 96 | capture | 01a19c43-5f15-77cd-9d6a-dcbd4d836357 | €35.00 | €0.50 | matched |
| 97 | capture | 01a19c43-761b-7715-aec8-0b8a1ffd47c3 | €49.00 | €0.67 | matched |
| 98 | capture | 01a19c43-7af2-7ff1-917e-cdd538ffe7a6 | €9.00 | €0.19 | matched |
| 99 | capture | 01a19c43-7ba6-7dff-9f70-7e0e73a84c71 | €49.00 | €0.67 | matched |
| 100 | refund | 01a19c43-8267-7b89-bb46-c1211e485d50 | -€6.00 | €0.00 | matched |
| 101 | capture | 01a19c44-1f33-734a-b1c4-b983e8619bba | €15.00 | €0.26 | matched |
| 102 | capture | 01a19c44-5c05-7a1f-aa28-81ac66867ee5 | €35.00 | €0.50 | matched |
| 103 | capture | 01a19c44-6b24-7dad-8152-64ca38a35716 | €15.00 | €0.26 | matched |
| 104 | capture | 01a19c44-8704-7f14-9197-7f2f7caae19a | €15.00 | €0.26 | matched |
| 105 | capture | 01a19c44-8770-7393-a775-16c09bf7e414 | €15.00 | €0.26 | matched |
| 106 | capture | 01a19c44-a337-7781-8d22-a304ddd3c4a9 | €15.00 | €0.26 | matched |
| 107 | capture | 01a19c44-9b87-7515-86f3-7520a813d5f3 | €9.00 | €0.19 | matched |
| 108 | capture | 01a19c44-ccde-7311-808a-342a616d1842 | €9.00 | €0.19 | matched |
| 109 | capture | 01a19c44-e2f0-727c-97f8-52ed1706ce41 | €49.00 | €0.67 | matched |
| 110 | refund | 01a19c44-eb52-773d-9835-5165c097adc0 | -€10.00 | €0.00 | matched |
| 111 | capture | 01a19c44-ef73-769d-8534-332872a27286 | €24.00 | €0.37 | matched |
| 112 | capture | 01a19c45-15d8-77ed-812d-96c0190221a1 | €35.00 | €0.50 | matched |
| 113 | capture | 01a19c45-285e-79fb-a4b6-9ced1e89ac50 | €24.00 | €0.37 | matched |
| 114 | capture | 01a19c45-3371-71b8-a0b0-cb51a1c62b58 | €15.00 | €0.26 | matched |
| 115 | refund | 01a19c45-37da-7d9c-b9f8-2da571c14ee7 | -€7.00 | €0.00 | matched |
| 116 | capture | 01a19c45-5407-7372-a2b8-1cae8edf3918 | €49.00 | €0.67 | matched |
| 117 | capture | 01a19c45-61ef-74a0-976e-6594064b3207 | €15.00 | €0.26 | matched |
| 118 | capture | 01a19c45-7b05-73c9-bc0f-373359b60c95 | €9.00 | €0.19 | matched |
| 119 | capture | 01a19c45-7f44-70c1-8319-2eddc78610ed | €35.00 | €0.50 | matched |
| 120 | capture | 01a19c45-85ed-7707-99ad-23c35c5d51db | €49.00 | €0.67 | matched |
| 121 | capture | 01a19c45-86d5-71ee-af54-3f0b62c7d144 | €49.00 | €0.67 | matched |
| 122 | capture | 01a19c45-ab5b-7ea7-8d8e-de5d10aeb6c6 | €9.00 | €0.19 | matched |
| 123 | capture | 01a19c45-bee5-7fc6-acdf-ce3370eaa553 | €49.00 | €0.67 | matched |
| 125 | capture | 01a19c45-f5d0-77e0-9d89-33cd0db3f4d7 | €49.00 | €0.67 | matched |
| 126 | capture | 01a19c45-f17c-7ec4-a0d3-32f98cb38ef4 | €24.00 | €0.37 | matched |
| 127 | capture | 01a19c46-0da9-77e6-a5f6-778892e7d7c6 | €24.00 | €0.37 | matched |