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
- 23 Oct, 01:00129 lines2 breaks
- 23 Oct, 00:50121 lines2 breaks
- 23 Oct, 00:40125 lines1 break
- 23 Oct, 00:30132 lines4 breaks
- 23 Oct, 00:20113 lines4 breaks
- 23 Oct, 00:10142 lines4 breaks
- 23 Oct, 00:00140 lines2 breaks
- 22 Oct, 23:5099 lines5 breaks
- 22 Oct, 23:40112 linesclean
- 22 Oct, 23:30114 lines2 breaks
- 22 Oct, 23:20131 lines3 breaks
- 22 Oct, 23:10127 lines3 breaks
- 22 Oct, 23:00132 lines3 breaks
- 22 Oct, 22:50120 lines2 breaks
23 Oct, 00:20
Gross
€2,620.00
PSP fee
€41.12
Net to the bank
€2,578.88
Settlement journal
#150753
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a16629-37df-785a-bdb2-62f4994a936b is already settled by stl_EUR_2987858 line 101
- fee differencethe fee is not the contract feethe fee is 21, the contract says 19
- missing linein the books, not in the filecapture:01a16626-14f0-7fbc-b9ae-55268b82f7d1 is in no file
- missing linein the books, not in the filecapture:01a16628-072d-78a7-b171-d89b2b4a8d95 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 15 | capture | 01a16621-ff5d-77b2-af2e-17589ed7fb32 | €9.00 | €0.21 | fee difference |
| 102 | refund | 01a16629-37e1-77ca-a2dc-c819bd82b810 | -€8.00 | €0.00 | duplicate line |
| 1 | capture | 01a1661b-38a9-7d98-930b-698ab90f0a6d | €49.00 | €0.67 | matched |
| 2 | capture | 01a1661c-1200-726b-8682-d1ad1ba4a237 | €49.00 | €0.67 | matched |
| 3 | capture | 01a1661c-7edc-7660-b587-d92d1476724f | €15.00 | €0.26 | matched |
| 4 | capture | 01a1661c-9c38-7660-9522-a5564915cc7c | €35.00 | €0.50 | matched |
| 5 | capture | 01a16621-351e-7107-9e40-465c59f0c107 | €9.00 | €0.19 | matched |
| 6 | capture | 01a16621-5127-7c9f-bb43-452eb273bf6f | €35.00 | €0.50 | matched |
| 7 | capture | 01a16621-568f-7d34-bf10-74f55135f3c6 | €9.00 | €0.19 | matched |
| 8 | capture | 01a16621-57e1-731c-81b2-658516ed9a7a | €15.00 | €0.26 | matched |
| 9 | refund | 01a16621-6796-7ef2-b4bc-27a2a50b386c | -€8.00 | €0.00 | matched |
| 10 | capture | 01a16621-80d5-7951-84bb-7a2039396822 | €35.00 | €0.50 | matched |
| 11 | refund | 01a16621-9004-788c-b22d-31d309b4a9a5 | -€3.00 | €0.00 | matched |
| 12 | capture | 01a16621-e4a0-7643-8bba-08f49d5acd08 | €49.00 | €0.67 | matched |
| 13 | capture | 01a16621-f81e-7624-9f8c-7ca597470d97 | €24.00 | €0.37 | matched |
| 14 | capture | 01a16621-f922-7637-80e9-5a8617046e3e | €15.00 | €0.26 | matched |
| 16 | capture | 01a16622-04d9-769f-86b7-afc73a323467 | €24.00 | €0.37 | matched |
| 17 | capture | 01a16622-14a4-7c2a-8eeb-5d0eda576feb | €49.00 | €0.67 | matched |
| 18 | capture | 01a16622-3e3c-72dc-8014-52e476b86611 | €49.00 | €0.67 | matched |
| 19 | refund | 01a16622-4e7b-7c70-b657-08b742209049 | -€15.00 | €0.00 | matched |
| 20 | refund | 01a16622-7704-7615-81f1-4d75f7eb630d | -€26.00 | €0.00 | matched |
| 21 | capture | 01a16622-a87c-7047-bff2-111ff1ddb7c7 | €24.00 | €0.37 | matched |
| 22 | capture | 01a16622-b28a-7081-8912-58737434c9de | €9.00 | €0.19 | matched |
| 23 | capture | 01a16622-e756-7135-8b58-2d5dc55a296b | €9.00 | €0.19 | matched |
| 24 | refund | 01a16623-070b-718d-a0e3-2a9131c1ed77 | -€8.00 | €0.00 | matched |
| 25 | capture | 01a16623-45da-71cf-af96-8530e25aee64 | €24.00 | €0.37 | matched |
| 26 | capture | 01a16623-482d-7f44-8532-dd199e951758 | €9.00 | €0.19 | matched |
| 27 | capture | 01a16623-4c36-7162-9b59-14c3644a03da | €15.00 | €0.26 | matched |
| 28 | capture | 01a16623-5825-7f03-ad97-722cbe72db75 | €15.00 | €0.26 | matched |
| 29 | capture | 01a16623-7326-7867-8e80-bd4af242239f | €9.00 | €0.19 | matched |
| 30 | capture | 01a16623-8078-7cc5-ae32-ecafebc28129 | €24.00 | €0.37 | matched |
| 31 | capture | 01a16623-8229-7934-9ce4-791e78458db0 | €24.00 | €0.37 | matched |
| 32 | capture | 01a16623-8b75-7337-b57c-99f583d4e06c | €49.00 | €0.67 | matched |
| 33 | capture | 01a16623-8cb5-757c-a531-e0aa7f61f03f | €49.00 | €0.67 | matched |
| 34 | capture | 01a16623-8e8a-7a96-b899-f39592683667 | €15.00 | €0.26 | matched |
| 35 | capture | 01a16623-913a-7f97-ae6d-d09512c97fd5 | €35.00 | €0.50 | matched |
| 36 | capture | 01a16623-a011-7197-980c-344158d22a4f | €9.00 | €0.19 | matched |
| 37 | capture | 01a16623-a4e4-7e4c-8f17-eb6af32532ce | €35.00 | €0.50 | matched |
| 38 | capture | 01a16623-c328-7923-a3f6-9ab1bb646673 | €49.00 | €0.67 | matched |
| 39 | capture | 01a16623-d7ca-7147-a7cc-649f17be1a8d | €15.00 | €0.26 | matched |
| 40 | capture | 01a16623-fafc-7694-b76f-812c7281c5e3 | €35.00 | €0.50 | matched |
| 41 | capture | 01a16624-00c8-7c05-8e77-b754c1cbf43b | €24.00 | €0.37 | matched |
| 42 | capture | 01a16624-0df2-7721-96f5-75191ec3d39c | €35.00 | €0.50 | matched |
| 43 | capture | 01a16624-12e8-716c-98bf-40d3fe15d648 | €49.00 | €0.67 | matched |
| 44 | capture | 01a16624-5e05-7f65-ae79-d7950147e628 | €24.00 | €0.37 | matched |
| 45 | capture | 01a16624-6873-7123-bb77-ff8b52e39ffb | €35.00 | €0.50 | matched |
| 46 | capture | 01a16624-6a8b-77b4-b859-000bd781f274 | €35.00 | €0.50 | matched |
| 47 | capture | 01a16624-6fa8-763d-a52c-4eebe80b74e5 | €15.00 | €0.26 | matched |
| 48 | capture | 01a16624-7514-7d15-b209-728aefe5bdaf | €24.00 | €0.37 | matched |
| 49 | capture | 01a16624-96ee-7379-912b-ca04f15c6c43 | €35.00 | €0.50 | matched |
| 50 | capture | 01a16624-9603-71f8-924f-563098581b1a | €35.00 | €0.50 | matched |
| 51 | capture | 01a16624-9be5-7c00-b04b-91173a739415 | €15.00 | €0.26 | matched |
| 52 | capture | 01a16624-a02f-7a8e-ba99-9d0366bef9b2 | €9.00 | €0.19 | matched |
| 53 | capture | 01a16624-cc65-7e26-9f20-1bec313c5c96 | €49.00 | €0.67 | matched |
| 54 | refund | 01a16624-d301-776e-9eea-6b70eaec4b60 | -€10.00 | €0.00 | matched |
| 55 | capture | 01a16625-1e7a-7dd6-9862-75117a34a92a | €49.00 | €0.67 | matched |
| 56 | capture | 01a16625-47de-7fa3-8cef-e30b238e6665 | €49.00 | €0.67 | matched |
| 57 | capture | 01a16625-689f-7a97-ba05-14bb6a948361 | €15.00 | €0.26 | matched |
| 58 | capture | 01a16625-6cc0-79f6-85c4-0fdcc636dbcb | €24.00 | €0.37 | matched |
| 59 | capture | 01a16625-c693-7969-aae0-3bb7db039179 | €15.00 | €0.26 | matched |
| 60 | capture | 01a16625-e20d-7987-a23f-1426830a8558 | €49.00 | €0.67 | matched |
| 61 | capture | 01a16625-f7ef-7bc5-a272-ac49ba40d28f | €15.00 | €0.26 | matched |
| 62 | capture | 01a16625-f9f8-7b4a-9d56-dad6e2a370f9 | €15.00 | €0.26 | matched |
| 63 | capture | 01a16626-04c7-73ce-b8ee-76e1296840fd | €9.00 | €0.19 | matched |
| 64 | capture | 01a16626-065d-7fcf-a7b1-09a31a11bb18 | €24.00 | €0.37 | matched |
| 65 | capture | 01a16626-1d66-7b65-b334-eb6973ad20c4 | €35.00 | €0.50 | matched |
| 66 | capture | 01a16626-2db2-70fb-b285-b57af106ea8e | €15.00 | €0.26 | matched |
| 67 | capture | 01a16626-4723-7e10-8b3e-37af6dc27685 | €49.00 | €0.67 | matched |
| 68 | capture | 01a16626-54ad-73af-abc6-96b719e22c1d | €15.00 | €0.26 | matched |
| 69 | refund | 01a16626-7d33-7e31-9f40-be2f2ecc5544 | -€14.00 | €0.00 | matched |
| 70 | capture | 01a16626-9c0d-78b2-91bd-b2b373f2d32a | €35.00 | €0.50 | matched |
| 71 | capture | 01a16626-c69a-7534-a75d-2be47628b2cf | €35.00 | €0.50 | matched |
| 72 | capture | 01a16626-dd62-78bc-b810-cdd5c4392f73 | €15.00 | €0.26 | matched |
| 73 | capture | 01a16627-0f02-7803-8333-3889bea478b8 | €35.00 | €0.50 | matched |
| 74 | capture | 01a16627-197b-738e-ab34-290db7e88e09 | €15.00 | €0.26 | matched |
| 75 | capture | 01a16627-1d09-7f2f-87c3-63d4f277e878 | €24.00 | €0.37 | matched |
| 76 | capture | 01a16627-1d1e-7cb6-a174-d06da7206133 | €24.00 | €0.37 | matched |
| 77 | capture | 01a16627-318b-7ce5-b763-452ac74a85ed | €49.00 | €0.67 | matched |
| 78 | capture | 01a16627-3198-7fdc-8bb7-ca55dd79616e | €24.00 | €0.37 | matched |
| 79 | capture | 01a16627-5f76-731b-96ef-9785ebd52faf | €15.00 | €0.26 | matched |
| 80 | capture | 01a16627-65fc-76b7-aa77-f9a598788297 | €9.00 | €0.19 | matched |
| 81 | refund | 01a16627-753f-7418-9c18-9090eaa36a93 | -€9.00 | €0.00 | matched |
| 82 | capture | 01a16627-a91b-75a9-b89a-d1aeba91374c | €15.00 | €0.26 | matched |
| 83 | capture | 01a16627-d120-7c55-a3ce-49ca8cc3146a | €15.00 | €0.26 | matched |
| 84 | capture | 01a16627-d5c1-7ef7-8069-ca5db06ccdff | €49.00 | €0.67 | matched |
| 85 | capture | 01a16627-ed69-7907-b83a-54e73e8cf34a | €9.00 | €0.19 | matched |
| 86 | capture | 01a16627-ed75-71e8-a141-c5dc113b18b6 | €15.00 | €0.26 | matched |
| 87 | capture | 01a16627-f5ec-7482-801b-8f68661462b8 | €15.00 | €0.26 | matched |
| 88 | capture | 01a16627-f9cd-74ac-ac98-cd5d644864cf | €24.00 | €0.37 | matched |
| 89 | capture | 01a16628-0099-7562-ab7e-0d06a5e64f95 | €24.00 | €0.37 | matched |
| 90 | capture | 01a16628-0686-7ef1-9f87-8721ac848443 | €35.00 | €0.50 | matched |
| 91 | capture | 01a16628-2ad9-7272-bcd2-049df9a56952 | €35.00 | €0.50 | matched |
| 92 | capture | 01a16628-2b54-7915-9085-2b9814dbc712 | €15.00 | €0.26 | matched |
| 93 | capture | 01a16628-5c14-7e7e-b2ce-f223061a9de8 | €9.00 | €0.19 | matched |
| 94 | capture | 01a16628-633e-7204-82c7-aab6552a9de4 | €9.00 | €0.19 | matched |
| 95 | capture | 01a16628-785f-7ed4-9e09-3977a976f575 | €49.00 | €0.67 | matched |
| 96 | capture | 01a16628-95c3-7805-8907-445dac38e9eb | €15.00 | €0.26 | matched |
| 97 | capture | 01a16628-9c71-7e55-adff-a4e76c76c26f | €35.00 | €0.50 | matched |
| 98 | capture | 01a16628-ecec-7efa-8b0f-96db3429039e | €9.00 | €0.19 | matched |
| 99 | capture | 01a16628-fe54-7aad-b90f-3f061d03fc2b | €49.00 | €0.67 | matched |
| 100 | capture | 01a16629-0960-720c-a11b-3417b913edc8 | €24.00 | €0.37 | matched |
| 101 | refund | 01a16629-37e1-77ca-a2dc-c819bd82b810 | -€8.00 | €0.00 | matched |
| 103 | capture | 01a16629-5f83-7e7f-975d-f169f95a2a30 | €9.00 | €0.19 | matched |
| 104 | capture | 01a16629-5fbb-7c91-a1b3-f7a12829a6b2 | €35.00 | €0.50 | matched |
| 105 | capture | 01a16629-8401-7e50-add6-530f8536769a | €49.00 | €0.67 | matched |
| 106 | capture | 01a16629-afbf-76d8-9edb-519c11563402 | €24.00 | €0.37 | matched |
| 107 | capture | 01a16629-bdbe-7e40-87bb-6cd1e6a0e115 | €49.00 | €0.67 | matched |
| 108 | capture | 01a16629-c325-739b-892b-dcdf1e240661 | €35.00 | €0.50 | matched |
| 109 | capture | 01a16629-e562-7c5c-8186-06bd75441096 | €24.00 | €0.37 | matched |
| 110 | capture | 01a16629-ea2a-739c-872b-d5727911017f | €15.00 | €0.26 | matched |
| 111 | capture | 01a16629-f323-7527-ad1a-ae60e34d3091 | €15.00 | €0.26 | matched |
| 112 | capture | 01a1662a-0ea6-7d9a-b8da-bb07bc322d9e | €24.00 | €0.37 | matched |
| 113 | capture | 01a1662a-1f68-7826-9cac-ab7f001b58ad | €35.00 | €0.50 | matched |