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
- 3 Nov, 09:30142 lines4 breaks
- 3 Nov, 09:20130 linesclean
- 3 Nov, 09:10118 lines1 break
- 3 Nov, 09:00137 lines5 breaks
- 3 Nov, 08:50125 lines3 breaks
- 3 Nov, 08:40116 lines4 breaks
- 3 Nov, 08:30118 lines4 breaks
- 3 Nov, 08:20124 lines2 breaks
- 3 Nov, 08:10121 lines1 break
- 3 Nov, 08:00114 lines2 breaks
- 3 Nov, 07:50128 lines3 breaks
- 3 Nov, 07:40100 lines1 break
- 3 Nov, 07:30122 lines3 breaks
- 3 Nov, 07:20116 lines1 break
3 Nov, 08:30
Gross
€2,678.00
PSP fee
€43.35
Net to the bank
€2,634.65
Settlement journal
#358102
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a1a08d-0564-75a1-9751-0335bd9c8191 is already settled by stl_EUR_2989491 line 65
- duplicate linethe file lists it twicecapture:01a1a08d-74af-7c4a-9629-b2fee5c23ec7 is already settled by stl_EUR_2989491 line 75
- fee differencethe fee is not the contract feethe fee is 69, the contract says 67
- missing linein the books, not in the filecapture:01a1a08e-d4c7-7516-8255-f919492e1fc0 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 66 | refund | 01a1a08d-0564-7ca6-a4cd-fcedda9679a4 | -€11.00 | €0.00 | duplicate line |
| 76 | capture | 01a1a08d-861c-7c4d-949b-13f0e56b9821 | €24.00 | €0.37 | duplicate line |
| 98 | capture | 01a1a08f-9226-7781-8dba-3071d6a25981 | €49.00 | €0.69 | fee difference |
| 1 | refund | 01a1a080-4eb9-783a-96d3-2b77e2a44205 | -€5.00 | €0.00 | matched |
| 2 | capture | 01a1a085-dffc-778f-bb60-c40e7802b66e | €35.00 | €0.50 | matched |
| 3 | capture | 01a1a087-9a9f-70ff-b2c4-b0a9b5531804 | €9.00 | €0.19 | matched |
| 4 | capture | 01a1a087-aa6f-7ff5-8b9c-da7993a38763 | €35.00 | €0.50 | matched |
| 5 | capture | 01a1a087-af9f-7d08-965d-ab399c98cd77 | €35.00 | €0.50 | matched |
| 6 | capture | 01a1a087-b079-7a0a-bbb3-eb324ea29d86 | €49.00 | €0.67 | matched |
| 7 | capture | 01a1a087-bfd4-7c4a-983a-6f4b483d515e | €35.00 | €0.50 | matched |
| 8 | capture | 01a1a087-c9fe-7192-be9c-af6098a981b3 | €24.00 | €0.37 | matched |
| 9 | capture | 01a1a087-ce5e-7e52-b70c-78a11a1c10e6 | €9.00 | €0.19 | matched |
| 10 | capture | 01a1a087-d6e0-7dfe-8707-c919e090d9e6 | €49.00 | €0.67 | matched |
| 11 | capture | 01a1a087-e00c-7bbb-9a3f-bb2fcc8f9697 | €35.00 | €0.50 | matched |
| 12 | capture | 01a1a088-1587-7a2e-b50c-222de84bc1a6 | €35.00 | €0.50 | matched |
| 13 | capture | 01a1a088-2087-7099-88a1-9b6705e92563 | €35.00 | €0.50 | matched |
| 14 | capture | 01a1a088-352c-7c58-886e-c17f132fa566 | €49.00 | €0.67 | matched |
| 15 | capture | 01a1a088-4913-75ef-9202-54751a069ca6 | €35.00 | €0.50 | matched |
| 16 | capture | 01a1a088-5168-7e8b-8f65-b4fa7d7ff647 | €24.00 | €0.37 | matched |
| 17 | capture | 01a1a088-817c-79f1-900d-9881cf77cd84 | €49.00 | €0.67 | matched |
| 18 | capture | 01a1a088-8454-75ca-af31-fee881ae72da | €49.00 | €0.67 | matched |
| 19 | capture | 01a1a088-a969-735f-a29e-993d73ed8496 | €49.00 | €0.67 | matched |
| 20 | capture | 01a1a088-ba64-7068-8b18-3a72e72f5def | €15.00 | €0.26 | matched |
| 21 | capture | 01a1a088-cf56-7a97-a5fa-c7678a1aa4b5 | €24.00 | €0.37 | matched |
| 22 | capture | 01a1a088-d250-7247-9447-77c190b67abb | €9.00 | €0.19 | matched |
| 23 | capture | 01a1a088-f7d3-71ac-a094-f1d160e7b816 | €24.00 | €0.37 | matched |
| 24 | capture | 01a1a089-0253-72e9-b9db-248a8a96e00f | €49.00 | €0.67 | matched |
| 25 | capture | 01a1a089-05d4-73f9-b896-3a0742deb1e7 | €24.00 | €0.37 | matched |
| 26 | capture | 01a1a089-0ffe-79d2-869a-a503619027cb | €15.00 | €0.26 | matched |
| 27 | refund | 01a1a089-3ca3-73cd-bff4-e3802e790a86 | -€14.00 | €0.00 | matched |
| 28 | capture | 01a1a089-5b3f-7c90-af6d-814d8d55de1c | €49.00 | €0.67 | matched |
| 29 | capture | 01a1a089-8419-7ea9-9f0c-f5fccaa6134c | €35.00 | €0.50 | matched |
| 30 | capture | 01a1a089-8678-7952-8bc5-e71d309a9311 | €15.00 | €0.26 | matched |
| 31 | capture | 01a1a089-a3cd-7628-b183-f002964fb72b | €15.00 | €0.26 | matched |
| 32 | capture | 01a1a089-d953-7baf-a391-573832389ef7 | €49.00 | €0.67 | matched |
| 33 | capture | 01a1a089-dec6-7299-b44b-c1ca0348982c | €9.00 | €0.19 | matched |
| 34 | capture | 01a1a089-df59-70f2-a2dd-e1e7d3bf4cb5 | €9.00 | €0.19 | matched |
| 35 | capture | 01a1a089-ea6e-723a-9492-a80109ded7f2 | €24.00 | €0.37 | matched |
| 36 | capture | 01a1a089-ec19-7de9-a0bb-5aba2198d6a2 | €15.00 | €0.26 | matched |
| 37 | capture | 01a1a08a-080e-767f-aebe-fc0cf125ec9b | €35.00 | €0.50 | matched |
| 38 | capture | 01a1a08a-11e7-76ed-be3b-a7bf33d29f51 | €9.00 | €0.19 | matched |
| 39 | capture | 01a1a08a-32cc-79de-a584-6530ca45bb4a | €15.00 | €0.26 | matched |
| 40 | refund | 01a1a08a-4a90-7f3a-a736-8d483ff987c6 | -€15.00 | €0.00 | matched |
| 41 | capture | 01a1a08a-6e53-776d-b272-060f9ba30766 | €24.00 | €0.37 | matched |
| 42 | capture | 01a1a08a-8437-7d73-8e8f-1e5ce32f1396 | €49.00 | €0.67 | matched |
| 43 | capture | 01a1a08a-9b4e-7d97-96b7-45a538bf2ba6 | €49.00 | €0.67 | matched |
| 44 | refund | 01a1a08a-9ce8-7849-bff6-a7ad85b1338b | -€17.00 | €0.00 | matched |
| 45 | capture | 01a1a08a-d539-7db5-9e15-4d9efa12b1b6 | €9.00 | €0.19 | matched |
| 46 | capture | 01a1a08a-e08e-7f06-9cdc-8f2892f79284 | €15.00 | €0.26 | matched |
| 47 | capture | 01a1a08b-1ccd-7ead-8163-52fa96c4988b | €15.00 | €0.26 | matched |
| 48 | capture | 01a1a08b-2b04-765f-99d0-686ca0871758 | €49.00 | €0.67 | matched |
| 49 | capture | 01a1a08b-9438-78c0-a6d3-403f90ddd573 | €35.00 | €0.50 | matched |
| 50 | capture | 01a1a08c-12fb-7a1b-a79b-5c3de746b9ce | €35.00 | €0.50 | matched |
| 51 | capture | 01a1a08c-1dc7-75eb-af8e-c1b452d4c8e0 | €49.00 | €0.67 | matched |
| 52 | capture | 01a1a08c-2987-75ab-9928-f0fa45deff41 | €49.00 | €0.67 | matched |
| 53 | capture | 01a1a08c-4bab-7540-9f2c-e13c56572243 | €9.00 | €0.19 | matched |
| 54 | refund | 01a1a08c-54f3-7a6c-b510-0d9e1dce455b | -€29.00 | €0.00 | matched |
| 55 | capture | 01a1a08c-5779-7662-8864-96223c7c52f8 | €9.00 | €0.19 | matched |
| 56 | refund | 01a1a08c-592c-7d11-b3e2-b5f2174c1c63 | -€26.00 | €0.00 | matched |
| 57 | capture | 01a1a08c-8be0-7689-921e-c3c3239f4af8 | €15.00 | €0.26 | matched |
| 58 | capture | 01a1a08c-a20e-79a0-86ba-ab0e44873869 | €15.00 | €0.26 | matched |
| 59 | capture | 01a1a08c-a614-7f0e-8b8a-a6aa1138e92f | €49.00 | €0.67 | matched |
| 60 | capture | 01a1a08c-ac51-77fd-8c7c-0d5e9c11147c | €15.00 | €0.26 | matched |
| 61 | capture | 01a1a08c-c733-7df0-a8d0-a693ca0b951d | €35.00 | €0.50 | matched |
| 62 | capture | 01a1a08c-caa4-7101-91f6-ac2cf4383758 | €24.00 | €0.37 | matched |
| 63 | capture | 01a1a08c-fa06-7561-889d-890922f8ac9a | €24.00 | €0.37 | matched |
| 64 | refund | 01a1a08d-0140-790c-a144-0aafcad12e72 | -€32.00 | €0.00 | matched |
| 65 | refund | 01a1a08d-0564-7ca6-a4cd-fcedda9679a4 | -€11.00 | €0.00 | matched |
| 67 | refund | 01a1a08d-0ce6-73f0-94a3-475ed8dfecdd | -€7.00 | €0.00 | matched |
| 68 | capture | 01a1a08d-1c05-7cf7-9908-9894a094dfc3 | €9.00 | €0.19 | matched |
| 69 | capture | 01a1a08d-3e95-78b5-970a-c60fad41a003 | €49.00 | €0.67 | matched |
| 70 | capture | 01a1a08d-4d20-7661-b623-0bd9535af8ce | €15.00 | €0.26 | matched |
| 71 | capture | 01a1a08d-4ea0-778a-b7df-f2acda4da22c | €15.00 | €0.26 | matched |
| 72 | refund | 01a1a08d-589b-7ab3-89cf-089b08e4aac6 | -€4.00 | €0.00 | matched |
| 73 | capture | 01a1a08d-5e6f-7022-bf76-81028cdd35e2 | €15.00 | €0.26 | matched |
| 74 | capture | 01a1a08d-62de-7e3c-ba07-9eac05d5c24a | €24.00 | €0.37 | matched |
| 75 | capture | 01a1a08d-861c-7c4d-949b-13f0e56b9821 | €24.00 | €0.37 | matched |
| 77 | capture | 01a1a08d-9610-7046-91ac-965be3de280f | €9.00 | €0.19 | matched |
| 78 | capture | 01a1a08d-aecf-7728-a46c-0ddcdcca74c7 | €35.00 | €0.50 | matched |
| 79 | capture | 01a1a08d-b8f0-78f5-ba4f-2e443b04b632 | €49.00 | €0.67 | matched |
| 80 | refund | 01a1a08d-d64e-7e04-aafe-e0b5a79bb05d | -€22.00 | €0.00 | matched |
| 81 | capture | 01a1a08e-27bd-7ce4-9960-5154db46cce8 | €49.00 | €0.67 | matched |
| 82 | capture | 01a1a08e-28f5-7f3f-b13c-185d94d6c49c | €24.00 | €0.37 | matched |
| 83 | capture | 01a1a08e-41b6-709b-b8df-abf942d988ea | €9.00 | €0.19 | matched |
| 84 | capture | 01a1a08e-6199-7c0b-b4f0-bcb7d0a63628 | €15.00 | €0.26 | matched |
| 85 | capture | 01a1a08e-7629-7893-aac7-26e7a5d8e0f3 | €35.00 | €0.50 | matched |
| 86 | capture | 01a1a08e-83ae-7a7e-a17b-d8e4d51f5b09 | €24.00 | €0.37 | matched |
| 87 | capture | 01a1a08e-8675-741e-bd0c-4fe55011ce11 | €24.00 | €0.37 | matched |
| 88 | capture | 01a1a08e-a35a-7944-acfb-9894a0d1eca6 | €15.00 | €0.26 | matched |
| 89 | capture | 01a1a08e-be93-762e-a58c-2c2a30421be2 | €35.00 | €0.50 | matched |
| 90 | capture | 01a1a08e-c2b1-761c-9f61-11cf7f513a75 | €15.00 | €0.26 | matched |
| 91 | capture | 01a1a08e-cb81-7a86-9cd1-2deb1f5282f2 | €15.00 | €0.26 | matched |
| 92 | capture | 01a1a08f-036a-7e55-87b2-6e87e222bb8b | €49.00 | €0.67 | matched |
| 93 | capture | 01a1a08f-19a1-72c9-9c40-ca1ec11eabb5 | €49.00 | €0.67 | matched |
| 94 | capture | 01a1a08f-23fc-72ae-a672-19d166e35788 | €35.00 | €0.50 | matched |
| 95 | capture | 01a1a08f-2b4f-74c8-afb5-2b3dcc37727c | €9.00 | €0.19 | matched |
| 96 | refund | 01a1a08f-5d0c-7b5e-96af-cd43683da8d5 | -€33.00 | €0.00 | matched |
| 97 | capture | 01a1a08f-6cbf-7b0d-ab3b-ef02d1bf90a0 | €9.00 | €0.19 | matched |
| 99 | capture | 01a1a08f-9702-7d70-adee-e741f24c85fa | €9.00 | €0.19 | matched |
| 100 | capture | 01a1a08f-ab17-749e-9a0c-f6809ddc7885 | €9.00 | €0.19 | matched |
| 101 | capture | 01a1a08f-c538-75ff-8c59-f58cd96e7f22 | €35.00 | €0.50 | matched |
| 102 | capture | 01a1a08f-cf37-7933-823d-1085d044f65d | €24.00 | €0.37 | matched |
| 103 | capture | 01a1a08f-d890-7e6f-a899-f87d56330640 | €15.00 | €0.26 | matched |
| 104 | capture | 01a1a08f-d90d-7fe9-8127-a0c84fdee673 | €15.00 | €0.26 | matched |
| 105 | capture | 01a1a08f-e540-74d3-aefc-bf1d423c2abe | €9.00 | €0.19 | matched |
| 106 | capture | 01a1a08f-eed7-75af-94f5-9e2a73093ce0 | €49.00 | €0.67 | matched |
| 107 | capture | 01a1a08f-fd6e-7be5-8001-597d8aed123d | €24.00 | €0.37 | matched |
| 108 | capture | 01a1a090-24fc-72be-adbb-56dd1a5cd348 | €24.00 | €0.37 | matched |
| 109 | refund | 01a1a090-2a37-7d10-987a-1567631c95ee | -€3.00 | €0.00 | matched |
| 110 | capture | 01a1a090-2a9a-7df0-a19e-82b2ac9b4dd4 | €49.00 | €0.67 | matched |
| 111 | capture | 01a1a090-3781-765a-96f4-887c883c4391 | €9.00 | €0.19 | matched |
| 112 | capture | 01a1a090-3e32-77e2-bae3-e4254d65c188 | €35.00 | €0.50 | matched |
| 113 | capture | 01a1a090-6dc8-744a-9bc5-c9d510893332 | €49.00 | €0.67 | matched |
| 114 | capture | 01a1a090-7935-755b-9a0e-49796f8cfded | €15.00 | €0.26 | matched |
| 115 | capture | 01a1a090-8d35-7954-b1b9-575dc92c76bc | €24.00 | €0.37 | matched |
| 116 | capture | 01a1a090-a7a8-7a23-885d-55e389e58bcc | €35.00 | €0.50 | matched |
| 117 | capture | 01a1a090-b17b-710b-91b9-30b630dabaeb | €49.00 | €0.67 | matched |
| 118 | capture | 01a1a090-b2a4-782b-8369-d64b2b92a069 | €49.00 | €0.67 | matched |