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, 14:20122 linesclean
- 3 Nov, 14:10118 lines3 breaks
- 3 Nov, 14:00112 lines2 breaks
- 3 Nov, 13:50117 lines4 breaks
- 3 Nov, 13:40115 lines5 breaks
- 3 Nov, 13:30113 lines3 breaks
- 3 Nov, 13:20123 lines1 break
- 3 Nov, 13:10115 lines3 breaks
- 3 Nov, 13:00112 linesclean
- 3 Nov, 12:50145 lines1 break
- 3 Nov, 12:40110 lines6 breaks
- 3 Nov, 12:30122 lines1 break
- 3 Nov, 12:20146 lines3 breaks
- 3 Nov, 12:10119 lines7 breaks
3 Nov, 13:10
Gross
€2,613.00
PSP fee
€41.48
Net to the bank
€2,571.52
Settlement journal
#361630
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a18b-2ac0-7236-bd07-caac99eb17dd is already settled by stl_EUR_2989519 line 33
- missing linein the books, not in the filecapture:01a1a18b-404a-7d5e-9d68-c9e220fd0447 is in no file
- missing linein the books, not in the filecapture:01a1a18f-c3eb-7822-ae3c-39929972eb1f is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 34 | capture | 01a1a18b-2ae3-7a40-bb1f-147d494e3c2d | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a1a182-d0b7-782e-9079-32f4596ff799 | €9.00 | €0.19 | matched |
| 2 | capture | 01a1a185-fdd1-7646-844f-354e3412f1e6 | €49.00 | €0.67 | matched |
| 3 | capture | 01a1a187-f3c2-7a67-a30f-8e88abbe6fe4 | €15.00 | €0.26 | matched |
| 4 | capture | 01a1a188-0b7d-78f9-af57-16127ec3bcd2 | €24.00 | €0.37 | matched |
| 5 | refund | 01a1a188-2448-7338-aeaa-e44be356e0b7 | -€7.00 | €0.00 | matched |
| 6 | capture | 01a1a188-4197-7e80-99cf-67664cf332bc | €15.00 | €0.26 | matched |
| 7 | capture | 01a1a188-6040-7e19-ab27-29f9508f5498 | €9.00 | €0.19 | matched |
| 8 | refund | 01a1a188-726a-77ad-b3e2-3b1e9b53faaa | -€7.00 | €0.00 | matched |
| 9 | capture | 01a1a188-dd7f-788b-9522-f1a593ee582e | €24.00 | €0.37 | matched |
| 10 | capture | 01a1a188-ded7-71e5-974c-9dace87f1b47 | €24.00 | €0.37 | matched |
| 11 | capture | 01a1a188-f69a-7902-9a1e-8a9857613fac | €49.00 | €0.67 | matched |
| 12 | capture | 01a1a189-0752-7d2a-8bd5-f61f2da655e7 | €15.00 | €0.26 | matched |
| 13 | capture | 01a1a189-2fed-7168-a358-fc0ad237af68 | €24.00 | €0.37 | matched |
| 14 | capture | 01a1a189-3f27-788f-91b9-4a6014324f45 | €24.00 | €0.37 | matched |
| 15 | capture | 01a1a189-4cc2-7450-8f26-a08d7856aae4 | €24.00 | €0.37 | matched |
| 16 | capture | 01a1a189-4f7e-7687-a187-6df67dc6cbdc | €24.00 | €0.37 | matched |
| 17 | capture | 01a1a189-7cf5-70a6-8e29-805a54e3a0c6 | €9.00 | €0.19 | matched |
| 18 | capture | 01a1a189-8ef1-7f8f-bcf7-ad0360ec4447 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1a189-a8fa-754e-b7c1-da7255ce490a | €24.00 | €0.37 | matched |
| 20 | capture | 01a1a189-aded-7745-9a0a-46cdf1c9fab4 | €9.00 | €0.19 | matched |
| 21 | capture | 01a1a189-f148-7280-864b-c448707a9763 | €24.00 | €0.37 | matched |
| 22 | capture | 01a1a189-f559-760f-9ab6-c13e7b32b49a | €24.00 | €0.37 | matched |
| 23 | capture | 01a1a18a-34f7-7a5d-8482-3ddc320e6cf1 | €9.00 | €0.19 | matched |
| 24 | capture | 01a1a18a-4e55-7860-a4f1-0b6e8eb04e41 | €24.00 | €0.37 | matched |
| 25 | capture | 01a1a18a-4c03-7cd0-82fb-9eba63a68821 | €9.00 | €0.19 | matched |
| 26 | capture | 01a1a18a-7348-7f58-b9b2-ded1cba241d0 | €35.00 | €0.50 | matched |
| 27 | capture | 01a1a18a-850e-7d5f-bdcb-4d248425aeb7 | €9.00 | €0.19 | matched |
| 28 | capture | 01a1a18a-a020-7120-aff2-7722cb34b327 | €24.00 | €0.37 | matched |
| 29 | capture | 01a1a18a-a499-77d7-b272-c4c644416845 | €35.00 | €0.50 | matched |
| 30 | refund | 01a1a18a-b1ec-7ed5-a1f9-3a3bc4b01a4e | -€8.00 | €0.00 | matched |
| 31 | capture | 01a1a18a-c5c9-74b4-934e-bb60fb4b72e6 | €49.00 | €0.67 | matched |
| 32 | capture | 01a1a18a-e0eb-717c-8ddf-5097e6aad2d9 | €35.00 | €0.50 | matched |
| 33 | capture | 01a1a18b-2ae3-7a40-bb1f-147d494e3c2d | €49.00 | €0.67 | matched |
| 35 | capture | 01a1a18b-276e-7a5f-a8d9-2e46e4161ce8 | €24.00 | €0.37 | matched |
| 36 | capture | 01a1a18b-4ba6-749c-8495-ebfdab541d7e | €35.00 | €0.50 | matched |
| 37 | capture | 01a1a18b-588b-70a2-ae0c-72e955c95750 | €9.00 | €0.19 | matched |
| 38 | capture | 01a1a18b-6ac5-78fa-be04-bc9dd833312f | €49.00 | €0.67 | matched |
| 39 | capture | 01a1a18b-7147-7705-9528-5e707885f7f5 | €35.00 | €0.50 | matched |
| 40 | capture | 01a1a18b-83c0-7375-925d-c14717b7146b | €35.00 | €0.50 | matched |
| 41 | refund | 01a1a18b-9fb7-70fc-a03c-6cfdd1a8da64 | -€25.00 | €0.00 | matched |
| 42 | capture | 01a1a18b-ecc0-72f2-826c-a981af30ade2 | €24.00 | €0.37 | matched |
| 43 | capture | 01a1a18b-f1fb-7cc5-b4a4-f176be0170db | €35.00 | €0.50 | matched |
| 44 | capture | 01a1a18c-11b5-7a4b-b55e-1847e8f3487e | €15.00 | €0.26 | matched |
| 45 | capture | 01a1a18c-1bb3-7c3f-b2ef-258b9f56d6dc | €15.00 | €0.26 | matched |
| 46 | capture | 01a1a18c-23dd-7056-8029-fd896d393456 | €24.00 | €0.37 | matched |
| 47 | capture | 01a1a18c-2699-7e7e-9ebe-bf900dc3da6e | €15.00 | €0.26 | matched |
| 48 | capture | 01a1a18c-2a2b-7707-85b7-34345e5fce58 | €9.00 | €0.19 | matched |
| 49 | capture | 01a1a18c-2ba5-7dc6-adf9-17d7620d2601 | €35.00 | €0.50 | matched |
| 50 | capture | 01a1a18c-3c3f-75ee-808a-6da92a0b2ba1 | €15.00 | €0.26 | matched |
| 51 | capture | 01a1a18c-3ea2-71a0-82dd-05bca4320cd8 | €49.00 | €0.67 | matched |
| 52 | capture | 01a1a18c-76a0-76bd-92f9-963319a22c84 | €49.00 | €0.67 | matched |
| 53 | capture | 01a1a18c-848f-7eba-870b-7f3025324169 | €24.00 | €0.37 | matched |
| 54 | capture | 01a1a18c-8e86-76d9-b5fd-ea7fdd1e01fb | €24.00 | €0.37 | matched |
| 55 | capture | 01a1a18c-9f39-7e81-b0d6-f5e9a7adda6d | €9.00 | €0.19 | matched |
| 56 | refund | 01a1a18c-ba79-77b4-8fc2-7ad7d1bed350 | -€18.00 | €0.00 | matched |
| 57 | capture | 01a1a18c-c12b-70d2-b585-00efdb391812 | €35.00 | €0.50 | matched |
| 58 | capture | 01a1a18c-d156-768d-8066-3e6439a2a57f | €15.00 | €0.26 | matched |
| 59 | capture | 01a1a18c-d5e5-7985-8388-0c71cc7561fc | €24.00 | €0.37 | matched |
| 60 | capture | 01a1a18c-e0e0-73e0-bd07-82902819b357 | €15.00 | €0.26 | matched |
| 61 | capture | 01a1a18c-f72c-7744-af95-044835ca8b3e | €24.00 | €0.37 | matched |
| 62 | capture | 01a1a18c-ff28-7b32-b234-588868df0db8 | €15.00 | €0.26 | matched |
| 63 | capture | 01a1a18d-173d-758c-931c-5876b2df0284 | €15.00 | €0.26 | matched |
| 64 | capture | 01a1a18d-2203-7a6f-b159-bfa10d06e760 | €49.00 | €0.67 | matched |
| 65 | capture | 01a1a18d-4fe8-7cd4-9707-78a618c459ab | €24.00 | €0.37 | matched |
| 66 | capture | 01a1a18d-725b-73c4-8323-eb698a2f8954 | €35.00 | €0.50 | matched |
| 67 | capture | 01a1a18d-8f18-77f8-9b24-8bd43e791ca3 | €35.00 | €0.50 | matched |
| 68 | capture | 01a1a18d-9d24-7860-bbf2-18aa70754023 | €24.00 | €0.37 | matched |
| 69 | capture | 01a1a18d-a848-78a0-a752-99465717c360 | €49.00 | €0.67 | matched |
| 70 | capture | 01a1a18d-a9a3-7fc9-9987-cd8941c41b8d | €35.00 | €0.50 | matched |
| 71 | capture | 01a1a18d-f842-7dc2-af8f-ddb61d4f4281 | €24.00 | €0.37 | matched |
| 72 | refund | 01a1a18d-f9d0-7079-aa5b-40a0ce8e0146 | -€19.00 | €0.00 | matched |
| 73 | capture | 01a1a18e-00f9-738b-b113-56c3f15507d3 | €35.00 | €0.50 | matched |
| 74 | capture | 01a1a18e-197a-79ba-81f1-fc8e22b74045 | €49.00 | €0.67 | matched |
| 75 | capture | 01a1a18e-29af-7b6d-908a-d5ba8bfd0a94 | €9.00 | €0.19 | matched |
| 76 | capture | 01a1a18e-2bb3-79af-bf6b-ed16ef79a606 | €9.00 | €0.19 | matched |
| 77 | capture | 01a1a18e-432c-7505-bcc8-0f867c669ff1 | €35.00 | €0.50 | matched |
| 78 | capture | 01a1a18e-6f99-79d1-9338-34da18238faa | €49.00 | €0.67 | matched |
| 79 | capture | 01a1a18e-78ea-75a9-8ff6-f9254a1c8226 | €9.00 | €0.19 | matched |
| 80 | capture | 01a1a18e-7bbe-7ebf-8b52-468be7d94868 | €24.00 | €0.37 | matched |
| 81 | capture | 01a1a18e-93e2-7fbf-9f88-6da15d2b8963 | €35.00 | €0.50 | matched |
| 82 | capture | 01a1a18e-b25e-7b27-a56b-747440c69200 | €35.00 | €0.50 | matched |
| 83 | capture | 01a1a18e-b704-702e-95ac-26db14975a94 | €9.00 | €0.19 | matched |
| 84 | capture | 01a1a18e-d3fb-7ba4-8e86-ae3099026a62 | €9.00 | €0.19 | matched |
| 85 | refund | 01a1a18e-e370-757f-b313-1480c0aef25f | -€13.00 | €0.00 | matched |
| 86 | capture | 01a1a18f-10c5-750e-8065-995e8a8c2991 | €9.00 | €0.19 | matched |
| 87 | capture | 01a1a18f-23ac-756d-8d3d-7a5663f5225b | €15.00 | €0.26 | matched |
| 88 | capture | 01a1a18f-329f-7e84-bfc7-f0514e92c5bc | €35.00 | €0.50 | matched |
| 89 | capture | 01a1a18f-3318-73c3-bc9b-0ef212bd929e | €49.00 | €0.67 | matched |
| 90 | capture | 01a1a18f-3601-759a-822a-2fd107195c19 | €24.00 | €0.37 | matched |
| 91 | capture | 01a1a18f-3a69-7fb5-9e32-db6bc74cae39 | €49.00 | €0.67 | matched |
| 92 | refund | 01a1a18f-5a42-7896-b046-24f789e8b292 | -€6.00 | €0.00 | matched |
| 93 | capture | 01a1a18f-5f79-734a-8bf2-9f860ac56d00 | €49.00 | €0.67 | matched |
| 94 | capture | 01a1a18f-5fad-7d77-80f6-8877f2719c56 | €24.00 | €0.37 | matched |
| 95 | capture | 01a1a18f-68ce-72e2-953e-276d59830863 | €49.00 | €0.67 | matched |
| 96 | capture | 01a1a18f-820e-7d19-9544-105daf0312c7 | €24.00 | €0.37 | matched |
| 97 | refund | 01a1a18f-885c-76f1-b677-79b12dbc8391 | -€18.00 | €0.00 | matched |
| 98 | capture | 01a1a18f-77e7-7c40-8c63-3dc174169782 | €35.00 | €0.50 | matched |
| 99 | capture | 01a1a18f-8f25-71eb-879b-0717aebff944 | €49.00 | €0.67 | matched |
| 100 | capture | 01a1a18f-a358-7a2d-ab48-baa6a4b9d116 | €24.00 | €0.37 | matched |
| 101 | capture | 01a1a18f-b4a0-751f-ba05-30211d6534a9 | €24.00 | €0.37 | matched |
| 102 | refund | 01a1a18f-ce2d-796f-8d18-31a62adeb050 | -€8.00 | €0.00 | matched |
| 103 | capture | 01a1a18f-eb73-7ba8-b794-47c5f65808ed | €24.00 | €0.37 | matched |
| 104 | capture | 01a1a190-0a09-7e56-845d-8a03e0fbd87a | €9.00 | €0.19 | matched |
| 105 | capture | 01a1a190-0bcc-77a3-b5a5-a4a09644ef22 | €15.00 | €0.26 | matched |
| 106 | capture | 01a1a190-1f89-7985-8e3f-ac11ccae696f | €15.00 | €0.26 | matched |
| 107 | capture | 01a1a190-3544-76d7-b9d6-bd9b18f3c399 | €24.00 | €0.37 | matched |
| 108 | capture | 01a1a190-6434-73f2-916b-20fd7676429d | €35.00 | €0.50 | matched |
| 109 | capture | 01a1a190-a084-717f-967e-0d94b1b53acd | €49.00 | €0.67 | matched |
| 110 | capture | 01a1a190-a7c6-7ea3-abd0-0fd0911917e0 | €24.00 | €0.37 | matched |
| 111 | capture | 01a1a190-b9ac-7ff2-b13e-d258c17d6416 | €24.00 | €0.37 | matched |
| 112 | capture | 01a1a190-c6dd-7dcb-bdaf-3cad33e99563 | €35.00 | €0.50 | matched |
| 113 | capture | 01a1a190-c930-7366-9013-e882fd9c3ad7 | €15.00 | €0.26 | matched |
| 114 | refund | 01a1a190-d500-76fb-892c-53bb86f93125 | -€10.00 | €0.00 | matched |
| 115 | capture | 01a1a191-0599-7d60-ba93-89edacb2518f | €15.00 | €0.26 | matched |