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
- 15 Oct, 00:00117 lines3 breaks
- 14 Oct, 23:50126 lines5 breaks
- 14 Oct, 23:40154 lines1 break
- 14 Oct, 23:30124 lines3 breaks
- 14 Oct, 23:20136 lines3 breaks
- 14 Oct, 23:10133 lines4 breaks
- 14 Oct, 23:00156 lines2 breaks
- 14 Oct, 22:50126 lines3 breaks
- 14 Oct, 22:40101 lines1 break
- 14 Oct, 22:3091 lines2 breaks
- 14 Oct, 22:20122 lines2 breaks
- 14 Oct, 22:10115 lines2 breaks
- 14 Oct, 22:00138 lines1 break
- 14 Oct, 21:50111 lines3 breaks
14 Oct, 22:30
Gross
€2,130.00
PSP fee
€33.81
Net to the bank
€2,096.19
Settlement journal
#3885
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13c8c-9ac3-7404-8a08-fb01c808a34d is already settled by stl_EUR_2986695 line 33
- missing linein the books, not in the filecapture:01a13c8d-3bdf-74c5-a97a-2b1ef2d26fd3 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 34 | capture | 01a13c8c-aa77-7e5b-a302-3fb607f86859 | €24.00 | €0.37 | duplicate line |
| 1 | capture | 01a13c80-42cf-70c7-b0d5-9388599465aa | €49.00 | €0.67 | matched |
| 2 | capture | 01a13c87-004b-7920-825f-98a3181e935e | €49.00 | €0.67 | matched |
| 3 | capture | 01a13c89-98e0-70ba-b30b-8d12e69f303a | €35.00 | €0.50 | matched |
| 4 | capture | 01a13c89-f32b-7ebb-95ab-171cd0dd9ebf | €15.00 | €0.26 | matched |
| 5 | capture | 01a13c89-f3b5-753f-a9c2-2efd3e80cf3f | €35.00 | €0.50 | matched |
| 6 | capture | 01a13c8a-7548-742f-9d13-80aa6466a40d | €15.00 | €0.26 | matched |
| 7 | capture | 01a13c8a-9899-7894-ac34-ede83ce479c3 | €35.00 | €0.50 | matched |
| 8 | capture | 01a13c8a-9d61-74a2-9dae-bd1636ac7bb1 | €15.00 | €0.26 | matched |
| 9 | capture | 01a13c8a-a07c-728b-ad42-5058496bf076 | €9.00 | €0.19 | matched |
| 10 | capture | 01a13c8a-a66a-7257-8d6e-4263d65342aa | €24.00 | €0.37 | matched |
| 11 | capture | 01a13c8a-ae5d-7950-8b7d-6928572b56f9 | €24.00 | €0.37 | matched |
| 12 | capture | 01a13c8a-da78-7bc4-95f6-c1c28d2274cb | €24.00 | €0.37 | matched |
| 13 | capture | 01a13c8a-ec0e-7f87-858d-4b2d99a62402 | €24.00 | €0.37 | matched |
| 14 | capture | 01a13c8a-ec9e-7c2b-9990-3779a1e7f5e3 | €24.00 | €0.37 | matched |
| 15 | capture | 01a13c8a-f4b3-78f3-91e8-dca729d06f91 | €35.00 | €0.50 | matched |
| 16 | capture | 01a13c8b-3b10-7ffd-8886-17b9ed4f1c0a | €49.00 | €0.67 | matched |
| 17 | capture | 01a13c8b-46f5-7318-8438-39ae907309a5 | €49.00 | €0.67 | matched |
| 18 | capture | 01a13c8b-5f18-7965-ba48-ed8ea12d96b4 | €49.00 | €0.67 | matched |
| 19 | capture | 01a13c8b-6dfd-7b50-bea3-01bd11d68d3e | €49.00 | €0.67 | matched |
| 20 | capture | 01a13c8b-6f33-7ecd-8388-5614f1095dac | €35.00 | €0.50 | matched |
| 21 | capture | 01a13c8b-9af8-749a-8db0-10e9a6b7f037 | €15.00 | €0.26 | matched |
| 22 | capture | 01a13c8b-a4b3-7ad9-95f6-5d32e3371410 | €15.00 | €0.26 | matched |
| 23 | capture | 01a13c8b-ac7b-7627-ad95-0c985119751f | €9.00 | €0.19 | matched |
| 24 | capture | 01a13c8b-cf09-7cc5-ab2a-a94ed1646f04 | €9.00 | €0.19 | matched |
| 25 | capture | 01a13c8c-21ce-7db1-9dca-2d9fee817a8e | €24.00 | €0.37 | matched |
| 26 | capture | 01a13c8c-34bc-7dfc-adbb-8d6940f026ae | €49.00 | €0.67 | matched |
| 27 | capture | 01a13c8c-39fe-77ac-b6e6-1a24fc99a8c8 | €15.00 | €0.26 | matched |
| 28 | capture | 01a13c8c-4ceb-7bf6-9f5f-976bd2d4b7b7 | €15.00 | €0.26 | matched |
| 29 | capture | 01a13c8c-5d29-70de-9c8d-04619ac55d32 | €15.00 | €0.26 | matched |
| 30 | capture | 01a13c8c-79ee-7e9e-9556-78b4af6a2f67 | €49.00 | €0.67 | matched |
| 31 | capture | 01a13c8c-8637-78c2-89d8-6471c59b8b15 | €9.00 | €0.19 | matched |
| 32 | capture | 01a13c8c-9c35-71c9-8742-da75b3d53fab | €24.00 | €0.37 | matched |
| 33 | capture | 01a13c8c-aa77-7e5b-a302-3fb607f86859 | €24.00 | €0.37 | matched |
| 35 | capture | 01a13c8c-e272-77b2-8a2e-cfb9140e199e | €9.00 | €0.19 | matched |
| 36 | capture | 01a13c8d-244d-7b6e-ac86-a0b9a5085bbd | €9.00 | €0.19 | matched |
| 37 | capture | 01a13c8d-b004-780e-880f-6abfa95f3b26 | €49.00 | €0.67 | matched |
| 38 | capture | 01a13c8d-cc39-7690-8320-954caa16f2d5 | €15.00 | €0.26 | matched |
| 39 | capture | 01a13c8e-0a2e-7def-85e1-25219bfdc0ab | €49.00 | €0.67 | matched |
| 40 | capture | 01a13c8e-12d9-7d52-b7a8-2301bc3e3ae7 | €9.00 | €0.19 | matched |
| 41 | capture | 01a13c8e-1a38-744e-bfe1-6a28d5c00fb3 | €35.00 | €0.50 | matched |
| 42 | capture | 01a13c8e-1b36-7e0d-9d98-31e6470efc63 | €9.00 | €0.19 | matched |
| 43 | refund | 01a13c8e-2b22-73b1-8e61-7f8e2f73cce9 | -€4.00 | €0.00 | matched |
| 44 | capture | 01a13c8e-3ff2-7f99-a0e7-645bd01cd1e2 | €35.00 | €0.50 | matched |
| 45 | capture | 01a13c8e-4587-7120-9db6-e7f4645bf623 | €9.00 | €0.19 | matched |
| 46 | capture | 01a13c8e-4945-71a5-bad0-d3b507d8969f | €15.00 | €0.26 | matched |
| 47 | capture | 01a13c8e-8c4f-7e8b-b5f0-9a982ae7e69d | €24.00 | €0.37 | matched |
| 48 | refund | 01a13c8e-9586-74cb-814c-4e1c41925f2d | -€8.00 | €0.00 | matched |
| 49 | capture | 01a13c8e-9627-7c4b-8193-ae1f2cf9f058 | €49.00 | €0.67 | matched |
| 50 | capture | 01a13c8e-b561-7524-a2cf-cfbe9ca68d55 | €15.00 | €0.26 | matched |
| 51 | capture | 01a13c8e-e00a-7452-bb53-eb8d17a7284f | €15.00 | €0.26 | matched |
| 52 | capture | 01a13c8e-e2b6-75af-aab8-8d3e9b9e13b7 | €49.00 | €0.67 | matched |
| 53 | capture | 01a13c8f-1a0e-7dd6-871d-389cf8ee537d | €9.00 | €0.19 | matched |
| 54 | capture | 01a13c8f-2c3e-7d24-a150-7d994c554b2e | €49.00 | €0.67 | matched |
| 55 | capture | 01a13c8f-5328-7c02-ab90-b8974e80d0ff | €15.00 | €0.26 | matched |
| 56 | refund | 01a13c8f-7d27-7aca-a41e-63bbb2ddfcd7 | -€4.00 | €0.00 | matched |
| 57 | capture | 01a13c8f-8d9a-71b9-9579-201212a71067 | €49.00 | €0.67 | matched |
| 58 | capture | 01a13c8f-8fbd-75f4-9d50-243e8b77976a | €15.00 | €0.26 | matched |
| 59 | capture | 01a13c8f-a73f-7ecb-bda8-0aa43c15330d | €35.00 | €0.50 | matched |
| 60 | capture | 01a13c8f-b79e-7548-8bdd-fe5efc143b6c | €24.00 | €0.37 | matched |
| 61 | capture | 01a13c8f-de38-7fca-80d0-860297686051 | €35.00 | €0.50 | matched |
| 62 | capture | 01a13c90-202d-7ecd-9f80-9114110e7e65 | €15.00 | €0.26 | matched |
| 63 | capture | 01a13c90-3a8a-7907-ad09-e4ffac5b98f7 | €9.00 | €0.19 | matched |
| 64 | capture | 01a13c90-4d43-79bc-ad6f-a0ab44ed6a7b | €15.00 | €0.26 | matched |
| 65 | capture | 01a13c90-76ac-7e94-bb59-5db9c94c8654 | €35.00 | €0.50 | matched |
| 66 | capture | 01a13c90-779d-74ef-9e00-9ff0f4924ac9 | €24.00 | €0.37 | matched |
| 67 | capture | 01a13c90-8c0f-7f4f-a38f-a15abc90a0cd | €35.00 | €0.50 | matched |
| 68 | capture | 01a13c90-961f-746c-a040-ef428844031c | €35.00 | €0.50 | matched |
| 69 | capture | 01a13c90-af07-7ee8-ad21-7593dbe9f752 | €49.00 | €0.67 | matched |
| 70 | capture | 01a13c90-d923-76ca-9477-184214ee3b53 | €15.00 | €0.26 | matched |
| 71 | capture | 01a13c90-da72-7520-93cc-ed9fb919f15b | €35.00 | €0.50 | matched |
| 72 | refund | 01a13c90-e7fb-7ac5-9416-d39e59d8df0c | -€20.00 | €0.00 | matched |
| 73 | capture | 01a13c91-0d07-75bd-958a-a32e5650a586 | €49.00 | €0.67 | matched |
| 74 | capture | 01a13c91-11f1-7a95-8247-657fcc9aba63 | €35.00 | €0.50 | matched |
| 75 | capture | 01a13c91-1334-7747-a54c-91ad0d5f7b99 | €35.00 | €0.50 | matched |
| 76 | capture | 01a13c91-14aa-7f67-bb32-090412ba75ab | €15.00 | €0.26 | matched |
| 77 | capture | 01a13c91-27af-776a-90c1-4bc7c21d0e12 | €24.00 | €0.37 | matched |
| 78 | capture | 01a13c91-3de5-7496-a30a-a54ecb66c35e | €9.00 | €0.19 | matched |
| 79 | capture | 01a13c91-4fdd-776b-8b12-0660e5996569 | €35.00 | €0.50 | matched |
| 80 | capture | 01a13c91-661e-7817-a6d3-5341d46980d8 | €49.00 | €0.67 | matched |
| 81 | capture | 01a13c91-6704-7253-a89c-b5a91167e051 | €24.00 | €0.37 | matched |
| 82 | capture | 01a13c91-6f04-77eb-b754-fa22f1a07f6e | €15.00 | €0.26 | matched |
| 83 | refund | 01a13c91-72c8-72c5-83ae-878d4c6bd8f9 | -€40.00 | €0.00 | matched |
| 84 | capture | 01a13c91-89d1-7dff-9b76-512e7726b239 | €24.00 | €0.37 | matched |
| 85 | capture | 01a13c91-9482-705d-9fac-b23292169b53 | €35.00 | €0.50 | matched |
| 86 | refund | 01a13c91-b8ce-7f8d-828b-4b909ae64425 | -€16.00 | €0.00 | matched |
| 87 | capture | 01a13c91-bb2e-77b1-8a72-4e6a1791f33e | €15.00 | €0.26 | matched |
| 88 | refund | 01a13c91-eda3-7aaf-ad54-3172164511ff | -€28.00 | €0.00 | matched |
| 89 | capture | 01a13c92-5663-72f9-a54d-0a0564c8e43b | €15.00 | €0.26 | matched |
| 90 | capture | 01a13c92-6970-7e25-91c1-9a1046132c66 | €15.00 | €0.26 | matched |
| 91 | capture | 01a13c92-8d48-7db3-9793-d04adbd56e9d | €24.00 | €0.37 | matched |