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, 02:40109 lines2 breaks
- 15 Oct, 02:30137 lines1 break
- 15 Oct, 02:20120 lines2 breaks
- 15 Oct, 02:10102 lines4 breaks
- 15 Oct, 02:00139 lines2 breaks
- 15 Oct, 01:50145 lines4 breaks
- 15 Oct, 01:40147 lines7 breaks
- 15 Oct, 01:30122 lines1 break
- 15 Oct, 01:20118 lines3 breaks
- 15 Oct, 01:10122 lines2 breaks
- 15 Oct, 01:00130 lines2 breaks
- 15 Oct, 00:50129 lines4 breaks
- 15 Oct, 00:40120 lines2 breaks
- 15 Oct, 00:30137 lines3 breaks
15 Oct, 01:10
Gross
€2,860.00
PSP fee
€46.24
Net to the bank
€2,813.76
Settlement journal
#5977
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a13d1c-98d6-76af-8c0d-3b32beff2407 is already settled by stl_EUR_2986711 line 16
- missing linein the books, not in the filecapture:01a13d20-1e25-779e-98e5-581b364f714a is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 17 | refund | 01a13d1c-98d7-7f2e-a22e-04dab8129533 | -€44.00 | €0.00 | duplicate line |
| 1 | capture | 01a13d16-0078-757a-b639-0fece0e871e1 | €15.00 | €0.26 | matched |
| 2 | capture | 01a13d17-7f33-7772-b8c1-94aadee41ee5 | €15.00 | €0.26 | matched |
| 3 | capture | 01a13d1a-b527-702d-8851-748b8b6897c8 | €15.00 | €0.26 | matched |
| 4 | refund | 01a13d1b-e944-75b4-8a94-a656f943ea43 | -€11.00 | €0.00 | matched |
| 5 | capture | 01a13d1b-f598-7155-bf34-056a56bae279 | €24.00 | €0.37 | matched |
| 6 | capture | 01a13d1b-facf-7aae-9834-fa2c754062bd | €24.00 | €0.37 | matched |
| 7 | capture | 01a13d1b-fdd4-708d-9787-808a244bc510 | €49.00 | €0.67 | matched |
| 8 | capture | 01a13d1c-2ac3-7770-946a-95d19171dd0f | €24.00 | €0.37 | matched |
| 9 | capture | 01a13d1c-33d2-7feb-8276-0ba69e716602 | €15.00 | €0.26 | matched |
| 10 | refund | 01a13d1c-47c8-7e4e-83b0-7a02c5ae30af | -€6.00 | €0.00 | matched |
| 11 | capture | 01a13d1c-5286-7bc8-9d64-0deba853119f | €35.00 | €0.50 | matched |
| 12 | capture | 01a13d1c-5642-786c-b1d8-05d6f86d22c0 | €35.00 | €0.50 | matched |
| 13 | capture | 01a13d1c-562d-7a62-99b0-3725bbab309b | €49.00 | €0.67 | matched |
| 14 | capture | 01a13d1c-67dc-77ad-bec2-4872f7824895 | €35.00 | €0.50 | matched |
| 15 | capture | 01a13d1c-7620-7942-9bfe-14b043b3e214 | €49.00 | €0.67 | matched |
| 16 | refund | 01a13d1c-98d7-7f2e-a22e-04dab8129533 | -€44.00 | €0.00 | matched |
| 18 | capture | 01a13d1c-a886-7223-b65c-632e73587661 | €49.00 | €0.67 | matched |
| 19 | capture | 01a13d1c-b3e2-7829-9d72-8425032e05c2 | €24.00 | €0.37 | matched |
| 20 | capture | 01a13d1d-1c1c-7f1a-9387-e67bc42dc8ce | €49.00 | €0.67 | matched |
| 21 | capture | 01a13d1d-20a2-7d66-9bdf-721f403ddf92 | €24.00 | €0.37 | matched |
| 22 | capture | 01a13d1d-2eb4-7c80-adb1-7e5601da19c0 | €9.00 | €0.19 | matched |
| 23 | capture | 01a13d1d-3090-7d0a-ad51-d9e9454786e2 | €35.00 | €0.50 | matched |
| 24 | capture | 01a13d1d-3924-726c-9006-466d55e6ceba | €35.00 | €0.50 | matched |
| 25 | capture | 01a13d1d-3e35-7dfb-89e4-a665c0ef8c07 | €35.00 | €0.50 | matched |
| 26 | capture | 01a13d1d-4b19-7dad-899f-4e08c8fde956 | €49.00 | €0.67 | matched |
| 27 | capture | 01a13d1d-6b91-7cce-aac6-f6d279754299 | €49.00 | €0.67 | matched |
| 28 | refund | 01a13d1d-79be-7544-90d8-aa42aae4c8d3 | -€14.00 | €0.00 | matched |
| 29 | capture | 01a13d1d-9448-79c6-8167-0daa018c3962 | €15.00 | €0.26 | matched |
| 30 | capture | 01a13d1d-a15b-7372-b70c-78c0c2944845 | €9.00 | €0.19 | matched |
| 31 | capture | 01a13d1d-a28b-7a51-a898-d3a5b8ba2c0a | €24.00 | €0.37 | matched |
| 32 | capture | 01a13d1d-ba8a-7754-89db-40dce0d779ea | €15.00 | €0.26 | matched |
| 33 | capture | 01a13d1d-c8b4-74ef-b9ae-970c899526c5 | €9.00 | €0.19 | matched |
| 34 | capture | 01a13d1d-e924-72a7-86f3-96048d3202b7 | €35.00 | €0.50 | matched |
| 35 | capture | 01a13d1d-e9de-7b22-929b-a02ecc53750e | €9.00 | €0.19 | matched |
| 36 | capture | 01a13d1d-f40f-715e-bb6e-2dfdd31e1be0 | €35.00 | €0.50 | matched |
| 37 | capture | 01a13d1e-097e-7357-8ebd-c796a335dae9 | €24.00 | €0.37 | matched |
| 38 | refund | 01a13d1e-19b1-740c-aa74-f2e7ae3fe85f | -€7.00 | €0.00 | matched |
| 39 | capture | 01a13d1e-1e20-7aa1-bdeb-2a1f7fd5093c | €9.00 | €0.19 | matched |
| 40 | capture | 01a13d1e-1e98-7e98-a494-4fbf91371c66 | €24.00 | €0.37 | matched |
| 41 | refund | 01a13d1e-47f9-765c-b081-b2a3d4c11319 | -€16.00 | €0.00 | matched |
| 42 | capture | 01a13d1e-9ae1-7877-9df6-8204540ad6a8 | €9.00 | €0.19 | matched |
| 43 | capture | 01a13d1e-c413-74fc-ae8e-5495a6bef6a5 | €35.00 | €0.50 | matched |
| 44 | capture | 01a13d1e-d535-71a7-a79c-1482249934b4 | €9.00 | €0.19 | matched |
| 45 | capture | 01a13d1e-e261-7513-9722-e8c7048b672f | €49.00 | €0.67 | matched |
| 46 | capture | 01a13d1e-f173-779d-a026-725383f7ac67 | €35.00 | €0.50 | matched |
| 47 | capture | 01a13d1f-11a0-7c02-95b9-3f5818dff7e4 | €9.00 | €0.19 | matched |
| 48 | capture | 01a13d1f-1470-798f-b8bf-47a0d290bf7e | €35.00 | €0.50 | matched |
| 49 | capture | 01a13d1f-16c0-7de0-aa33-88a331044ef7 | €24.00 | €0.37 | matched |
| 50 | capture | 01a13d1f-1db8-7642-b036-7b86781bcbd0 | €35.00 | €0.50 | matched |
| 51 | capture | 01a13d1f-477b-7230-be66-e0bf62138a49 | €49.00 | €0.67 | matched |
| 52 | capture | 01a13d1f-4857-74e3-8230-c39360d42914 | €49.00 | €0.67 | matched |
| 53 | capture | 01a13d1f-5186-77c6-b33f-e161f3c0387c | €24.00 | €0.37 | matched |
| 54 | capture | 01a13d1f-5309-7d4d-9d4b-475cbc2ef98c | €49.00 | €0.67 | matched |
| 55 | capture | 01a13d1f-5dc8-75b8-8d46-c4ea962568cd | €15.00 | €0.26 | matched |
| 56 | capture | 01a13d1f-660f-7d0a-97e0-bdf2c634f5a0 | €24.00 | €0.37 | matched |
| 57 | refund | 01a13d1f-9c9a-7e47-8a11-c0c8614a0d92 | -€46.00 | €0.00 | matched |
| 58 | capture | 01a13d1f-a241-7505-a878-0597230e8873 | €15.00 | €0.26 | matched |
| 59 | capture | 01a13d1f-a494-7863-a50d-c65222f2fab5 | €24.00 | €0.37 | matched |
| 60 | capture | 01a13d1f-ad1d-7b3c-9536-47b2ac3a09da | €15.00 | €0.26 | matched |
| 61 | capture | 01a13d1f-d629-7f1f-8640-c1fce5bb7fc0 | €49.00 | €0.67 | matched |
| 62 | capture | 01a13d1f-e707-7ed7-995f-0c21aab714f5 | €35.00 | €0.50 | matched |
| 63 | capture | 01a13d1f-d25e-72d2-b7f5-8118c3f7da7a | €49.00 | €0.67 | matched |
| 64 | capture | 01a13d1f-fb9a-7735-9fec-7896368f9d21 | €15.00 | €0.26 | matched |
| 65 | capture | 01a13d20-09a2-78b9-8332-227ea38e31a6 | €9.00 | €0.19 | matched |
| 66 | capture | 01a13d20-29b4-74b7-b180-1d000a551e6c | €9.00 | €0.19 | matched |
| 67 | capture | 01a13d20-5e54-728b-b8cc-9038c0c6344b | €49.00 | €0.67 | matched |
| 68 | capture | 01a13d20-5fe9-7b4d-8ce8-790af874eda0 | €49.00 | €0.67 | matched |
| 69 | capture | 01a13d20-9877-79dc-8850-f4c7cf79e354 | €15.00 | €0.26 | matched |
| 70 | capture | 01a13d20-cd83-722d-9713-c43d1a3f07c0 | €15.00 | €0.26 | matched |
| 71 | capture | 01a13d20-d140-7d38-a176-7ee306d8baa2 | €9.00 | €0.19 | matched |
| 72 | capture | 01a13d20-ddaa-7214-9f1e-252235e8a60b | €24.00 | €0.37 | matched |
| 73 | capture | 01a13d20-e0f7-71f9-8159-e52e170a09ee | €9.00 | €0.19 | matched |
| 74 | capture | 01a13d21-0655-7cbe-b49e-66a6c7d6cfb0 | €35.00 | €0.50 | matched |
| 75 | capture | 01a13d21-0ffc-7d27-9986-628302d7abc5 | €35.00 | €0.50 | matched |
| 76 | capture | 01a13d21-34de-773f-b317-0212aad4c06e | €35.00 | €0.50 | matched |
| 77 | capture | 01a13d21-3ef0-7bee-856f-a3b92222a500 | €24.00 | €0.37 | matched |
| 78 | capture | 01a13d21-489a-761f-a3d8-c68a82af24b9 | €35.00 | €0.50 | matched |
| 79 | capture | 01a13d21-4947-74db-a3ca-5cb0e85e7f6b | €35.00 | €0.50 | matched |
| 80 | capture | 01a13d21-529b-7753-b075-00a7d81b5f2c | €49.00 | €0.67 | matched |
| 81 | capture | 01a13d21-8d68-7ef5-b68e-917e66db16d0 | €24.00 | €0.37 | matched |
| 82 | capture | 01a13d21-ac90-7e2d-8a94-abd536290af2 | €49.00 | €0.67 | matched |
| 83 | capture | 01a13d21-cd54-7f8f-b42f-fd88d168d493 | €9.00 | €0.19 | matched |
| 84 | capture | 01a13d21-dca3-7fdf-bece-73c4be1d27b7 | €9.00 | €0.19 | matched |
| 85 | capture | 01a13d21-e6f4-7c9b-964e-bea09a417fc6 | €9.00 | €0.19 | matched |
| 86 | capture | 01a13d21-e81d-7694-ab93-e7866a489fc4 | €15.00 | €0.26 | matched |
| 87 | capture | 01a13d22-1736-7735-8a71-900d4a74aa67 | €9.00 | €0.19 | matched |
| 88 | capture | 01a13d22-6cdd-7301-9082-48fcb82ba34a | €35.00 | €0.50 | matched |
| 89 | refund | 01a13d22-763b-77cf-b27e-0511482dd318 | -€6.00 | €0.00 | matched |
| 90 | capture | 01a13d22-8647-7c49-9009-bc36fb0020cf | €49.00 | €0.67 | matched |
| 91 | capture | 01a13d22-ae06-7302-bbf7-fe11cdfa68b8 | €15.00 | €0.26 | matched |
| 92 | capture | 01a13d22-bc5b-71b5-936a-04aebc570ddc | €15.00 | €0.26 | matched |
| 93 | capture | 01a13d22-c188-70bd-a6d8-73b3ec90133c | €49.00 | €0.67 | matched |
| 94 | capture | 01a13d22-cfdf-7ea4-8ec8-9ff49393f3f3 | €24.00 | €0.37 | matched |
| 95 | capture | 01a13d22-d1ab-7278-8ede-6812acb0fa3b | €24.00 | €0.37 | matched |
| 96 | capture | 01a13d22-f860-7708-a3a1-117899a092d6 | €35.00 | €0.50 | matched |
| 97 | capture | 01a13d22-fb9e-7500-80c0-d671381b38ce | €35.00 | €0.50 | matched |
| 98 | capture | 01a13d23-0c25-7809-9c43-7e8cf17e7aff | €15.00 | €0.26 | matched |
| 99 | capture | 01a13d23-1036-7c87-8240-d8c99daf786c | €35.00 | €0.50 | matched |
| 100 | capture | 01a13d23-18c0-76f8-9ce4-8e12debf9947 | €35.00 | €0.50 | matched |
| 101 | capture | 01a13d23-2bbf-7b9e-b5d9-5fec179f0cf7 | €49.00 | €0.67 | matched |
| 102 | capture | 01a13d23-442c-7bdb-9bbb-0d331018815f | €9.00 | €0.19 | matched |
| 103 | capture | 01a13d23-53d0-7ca0-b0d8-a2fc3291e1e3 | €9.00 | €0.19 | matched |
| 104 | capture | 01a13d23-852a-7423-b493-8d80ccab5007 | €35.00 | €0.50 | matched |
| 105 | capture | 01a13d24-11ae-7315-809e-c03d2e7c4c9e | €9.00 | €0.19 | matched |
| 106 | capture | 01a13d24-1879-7052-abe8-40397d9006d7 | €49.00 | €0.67 | matched |
| 107 | capture | 01a13d24-1e83-73fe-810e-f56661bf1568 | €49.00 | €0.67 | matched |
| 108 | capture | 01a13d24-2a5b-7895-8545-34b8bcb77a9b | €49.00 | €0.67 | matched |
| 109 | capture | 01a13d24-2bc0-78dc-899e-281f24edfc01 | €15.00 | €0.26 | matched |
| 110 | capture | 01a13d24-30ca-7065-a574-a5b6b9c611c9 | €49.00 | €0.67 | matched |
| 111 | refund | 01a13d24-503a-7712-babe-26f3a468278b | -€42.00 | €0.00 | matched |
| 112 | capture | 01a13d24-521d-7f9c-9910-06697db0aced | €24.00 | €0.37 | matched |
| 113 | capture | 01a13d24-72f3-70c1-bbff-09bc7f759742 | €35.00 | €0.50 | matched |
| 114 | capture | 01a13d24-7b14-7575-aa39-b005feaf42ab | €15.00 | €0.26 | matched |
| 115 | capture | 01a13d24-96d7-7d2f-936f-32c26293a1c6 | €9.00 | €0.19 | matched |
| 116 | capture | 01a13d24-98fc-752d-92e8-002e14e3f3a2 | €15.00 | €0.26 | matched |
| 117 | capture | 01a13d24-bfc5-7e0b-8c2e-2cd978d255e4 | €35.00 | €0.50 | matched |
| 118 | capture | 01a13d24-c10e-7339-88b9-820a49653aa2 | €24.00 | €0.37 | matched |
| 119 | capture | 01a13d24-d278-73e5-bee5-bcbf75b6f394 | €15.00 | €0.26 | matched |
| 120 | capture | 01a13d24-e822-70eb-a3fc-f6924dca49af | €15.00 | €0.26 | matched |
| 121 | capture | 01a13d24-ee39-7c11-a3b4-75a6998baf94 | €35.00 | €0.50 | matched |
| 122 | capture | 01a13d24-ff29-7731-b6aa-97cfc182d295 | €24.00 | €0.37 | matched |