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
- 6 Nov, 13:00104 lines3 breaks
- 6 Nov, 12:50116 lines1 break
- 6 Nov, 12:40124 lines1 break
- 6 Nov, 12:30116 lines1 break
- 6 Nov, 12:20127 lines5 breaks
- 6 Nov, 12:10129 lines1 break
- 6 Nov, 12:00111 lines2 breaks
- 6 Nov, 11:50128 lines2 breaks
- 6 Nov, 11:40132 lines2 breaks
- 6 Nov, 11:30134 lines1 break
- 6 Nov, 11:20130 lines1 break
- 6 Nov, 11:10129 lines7 breaks
- 6 Nov, 11:00129 lines4 breaks
- 6 Nov, 10:50130 lines3 breaks
6 Nov, 12:20
Gross
€3,169.00
PSP fee
€48.92
Net to the bank
€3,120.08
Settlement journal
#415975
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1b0ce-b6f6-7dd5-aabc-d9e9fe4904fb is already settled by stl_EUR_2989946 line 24
- duplicate linethe file lists it twicecapture:01a1b0d4-a601-7d4b-a28e-e732eb1e03d2 is already settled by stl_EUR_2989946 line 103
- duplicate linethe file lists it twicecapture:01a1b0d5-ade5-79c9-ba8f-428f8d3374c1 is already settled by stl_EUR_2989946 line 123
- missing linein the books, not in the filerefund:01a1b0ce-250c-7ce9-803d-e732699a5eec is in no file
- missing linein the books, not in the filecapture:01a1b0d5-2f57-7110-a841-b24892a0357c is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 25 | capture | 01a1b0ce-b718-7746-8e3a-dff9dea5960d | €24.00 | €0.37 | duplicate line |
| 104 | capture | 01a1b0d4-a620-71c2-a25f-afb03908de43 | €49.00 | €0.67 | duplicate line |
| 124 | capture | 01a1b0d5-cee3-779e-88d7-0cc07eb151ea | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a1b0c4-7a50-7eb1-b984-cbc186748d47 | €24.00 | €0.37 | matched |
| 2 | capture | 01a1b0c8-5920-7195-9aab-9145e2826b5f | €9.00 | €0.19 | matched |
| 3 | capture | 01a1b0ca-0453-73ce-882d-792038b01fdc | €35.00 | €0.50 | matched |
| 4 | capture | 01a1b0cb-83e0-7d4a-86d6-fd77dbcc23df | €15.00 | €0.26 | matched |
| 5 | refund | 01a1b0cb-b8a2-7ce9-8117-bf835bc124fe | -€20.00 | €0.00 | matched |
| 6 | capture | 01a1b0cd-43d5-7fff-9119-e3594ccb1dd6 | €15.00 | €0.26 | matched |
| 7 | capture | 01a1b0cd-58e1-7601-a35d-7e8f64273b9a | €9.00 | €0.19 | matched |
| 8 | capture | 01a1b0cd-7f61-7f81-b492-d7c5a537cdd1 | €35.00 | €0.50 | matched |
| 9 | capture | 01a1b0cd-814b-713e-8773-4e53c62e5c70 | €35.00 | €0.50 | matched |
| 10 | capture | 01a1b0cd-9ba7-71e8-b85d-96926023e5ba | €15.00 | €0.26 | matched |
| 11 | refund | 01a1b0cd-b0cd-7dd1-a7ac-ffc211cda0ec | -€5.00 | €0.00 | matched |
| 12 | capture | 01a1b0cd-b895-7ca1-bff4-619848c17222 | €24.00 | €0.37 | matched |
| 13 | capture | 01a1b0cd-c8a3-791f-ba63-c17d79084e5e | €24.00 | €0.37 | matched |
| 14 | capture | 01a1b0cd-ca5b-7461-bfcc-83c9dd423bfa | €49.00 | €0.67 | matched |
| 15 | capture | 01a1b0cd-d47c-7e1f-b6b5-6273de1a57cb | €35.00 | €0.50 | matched |
| 16 | capture | 01a1b0cd-f633-78e9-8748-c28695611b26 | €35.00 | €0.50 | matched |
| 17 | capture | 01a1b0ce-22f3-7148-a31e-23058b502680 | €24.00 | €0.37 | matched |
| 18 | capture | 01a1b0ce-2cd1-7459-8e8e-e2c895461542 | €49.00 | €0.67 | matched |
| 19 | capture | 01a1b0ce-3952-7fd3-9352-3f835caf9e4c | €15.00 | €0.26 | matched |
| 20 | capture | 01a1b0ce-7b06-79c8-b1c2-732544c4541f | €24.00 | €0.37 | matched |
| 21 | capture | 01a1b0ce-8b98-792a-acc6-e37a728b703c | €24.00 | €0.37 | matched |
| 22 | capture | 01a1b0ce-93e1-7998-b73e-52eb260ed1cb | €35.00 | €0.50 | matched |
| 23 | capture | 01a1b0ce-abe9-71d1-a031-d4327c0b6c6b | €24.00 | €0.37 | matched |
| 24 | capture | 01a1b0ce-b718-7746-8e3a-dff9dea5960d | €24.00 | €0.37 | matched |
| 26 | capture | 01a1b0ce-c807-7a98-9128-f706915b8bc4 | €35.00 | €0.50 | matched |
| 27 | capture | 01a1b0ce-c88f-7272-b5db-a4bf2692d08c | €15.00 | €0.26 | matched |
| 28 | capture | 01a1b0ce-e806-7b77-824f-333b469b0782 | €35.00 | €0.50 | matched |
| 29 | capture | 01a1b0ce-f3ff-747e-a73a-2cd152aa5a44 | €24.00 | €0.37 | matched |
| 30 | capture | 01a1b0cf-08fd-758a-8415-975e275d3348 | €15.00 | €0.26 | matched |
| 31 | capture | 01a1b0cf-1c22-7d1b-b7b9-fcc96a464785 | €35.00 | €0.50 | matched |
| 32 | capture | 01a1b0cf-3572-7519-a2c8-4506d703c7b2 | €35.00 | €0.50 | matched |
| 33 | capture | 01a1b0cf-46a2-7fa1-81bf-14cbaba22c70 | €49.00 | €0.67 | matched |
| 34 | capture | 01a1b0cf-5a6d-7eac-85c2-c33179cb1fcc | €24.00 | €0.37 | matched |
| 35 | capture | 01a1b0cf-5a73-71c5-b577-4b943720cfb7 | €49.00 | €0.67 | matched |
| 36 | capture | 01a1b0cf-68d1-75f0-a463-290a65b94538 | €9.00 | €0.19 | matched |
| 37 | capture | 01a1b0cf-8c13-7840-bcec-7166ae12658c | €35.00 | €0.50 | matched |
| 38 | capture | 01a1b0cf-dd42-7932-bfc6-77b4e383a216 | €15.00 | €0.26 | matched |
| 39 | capture | 01a1b0cf-e092-74a8-bedb-45b4fa56a77d | €49.00 | €0.67 | matched |
| 40 | capture | 01a1b0d0-04f0-709e-a69b-f20f428d6f1e | €35.00 | €0.50 | matched |
| 41 | capture | 01a1b0d0-1bbc-7b28-9e2c-51952eafc9e1 | €9.00 | €0.19 | matched |
| 42 | capture | 01a1b0d0-1cf9-7e23-82ce-c94cf6583a02 | €15.00 | €0.26 | matched |
| 43 | capture | 01a1b0d0-2577-73f1-81e7-044ff32e3522 | €9.00 | €0.19 | matched |
| 44 | capture | 01a1b0d0-2f40-7710-bed1-c6692194f193 | €15.00 | €0.26 | matched |
| 45 | capture | 01a1b0d0-3569-79e9-97ef-0c54c8385610 | €49.00 | €0.67 | matched |
| 46 | capture | 01a1b0d0-415f-71e2-8ee1-a6dd2c516197 | €15.00 | €0.26 | matched |
| 47 | capture | 01a1b0d0-41bd-7a04-9ab7-127fe37f9a53 | €49.00 | €0.67 | matched |
| 48 | capture | 01a1b0d0-59a7-745b-959c-58aa12e78c5e | €49.00 | €0.67 | matched |
| 49 | capture | 01a1b0d0-7b58-796a-9bbf-99f990860079 | €35.00 | €0.50 | matched |
| 50 | capture | 01a1b0d0-7dc1-7260-b2a3-44ced00db7a0 | €49.00 | €0.67 | matched |
| 51 | capture | 01a1b0d0-8be9-7412-a1b0-1a7fc6e9fbac | €49.00 | €0.67 | matched |
| 52 | capture | 01a1b0d0-8e4c-7be6-a454-737b70c39071 | €24.00 | €0.37 | matched |
| 53 | refund | 01a1b0d0-92f0-7cda-9be3-01d185d777ad | -€3.00 | €0.00 | matched |
| 54 | capture | 01a1b0d0-9742-7721-8f0a-140548db5693 | €24.00 | €0.37 | matched |
| 55 | capture | 01a1b0d0-a2a2-7802-87af-42811d933d70 | €35.00 | €0.50 | matched |
| 56 | capture | 01a1b0d0-cee8-7b74-a560-e476b338531b | €15.00 | €0.26 | matched |
| 57 | capture | 01a1b0d0-de76-7168-87b7-08a5bcc46031 | €15.00 | €0.26 | matched |
| 58 | capture | 01a1b0d0-f209-770b-976a-7392556cee87 | €49.00 | €0.67 | matched |
| 59 | capture | 01a1b0d1-1774-7a72-96cf-237227f8d02b | €9.00 | €0.19 | matched |
| 60 | capture | 01a1b0d1-1d7c-7004-9392-7b74d3259079 | €15.00 | €0.26 | matched |
| 61 | capture | 01a1b0d1-1a42-7a8c-ab2e-8c673ad13e47 | €24.00 | €0.37 | matched |
| 62 | capture | 01a1b0d1-2e0b-7f78-b328-d0c924ac3bc4 | €24.00 | €0.37 | matched |
| 63 | capture | 01a1b0d1-3c1d-7a88-805a-c75ab412bece | €24.00 | €0.37 | matched |
| 64 | capture | 01a1b0d1-54e4-77b3-8bcc-a33ea43a09d0 | €49.00 | €0.67 | matched |
| 65 | capture | 01a1b0d1-5a59-7c67-b909-2be2d8f620dc | €49.00 | €0.67 | matched |
| 66 | capture | 01a1b0d1-7d27-752a-b81a-64250b118d6c | €49.00 | €0.67 | matched |
| 67 | capture | 01a1b0d1-7fe9-7158-923a-f317ebe69b9b | €15.00 | €0.26 | matched |
| 68 | capture | 01a1b0d1-917b-7ef4-8ab6-4b9ca6748a99 | €49.00 | €0.67 | matched |
| 69 | capture | 01a1b0d1-9acf-7825-a80c-f12697eae3c1 | €49.00 | €0.67 | matched |
| 70 | capture | 01a1b0d1-9ed5-7b87-b98b-3d3856b36f2b | €24.00 | €0.37 | matched |
| 71 | capture | 01a1b0d1-b7d0-705c-87c5-9501fcb089e4 | €9.00 | €0.19 | matched |
| 72 | capture | 01a1b0d1-e53c-7daa-8ffa-54a3bdc34034 | €35.00 | €0.50 | matched |
| 73 | capture | 01a1b0d1-f611-71d3-bc91-160ed6736faf | €9.00 | €0.19 | matched |
| 74 | capture | 01a1b0d2-0d27-7fe9-b850-c1c275bf7070 | €24.00 | €0.37 | matched |
| 75 | capture | 01a1b0d2-1201-7f02-aa98-b6d2bea9f59f | €49.00 | €0.67 | matched |
| 76 | capture | 01a1b0d2-2057-7db9-a619-f1ae44fb0b61 | €15.00 | €0.26 | matched |
| 77 | capture | 01a1b0d2-617f-74af-975c-9aa82b5a51f1 | €24.00 | €0.37 | matched |
| 78 | refund | 01a1b0d2-8578-7968-a30d-3056638d6f1c | -€13.00 | €0.00 | matched |
| 79 | capture | 01a1b0d2-8fa0-737d-a5eb-35e4ff56b3b0 | €15.00 | €0.26 | matched |
| 80 | capture | 01a1b0d2-a3e6-71cb-a6b6-d0953558bccf | €35.00 | €0.50 | matched |
| 81 | capture | 01a1b0d2-bb23-7b46-9bee-70f741957b93 | €24.00 | €0.37 | matched |
| 82 | capture | 01a1b0d3-48ac-7837-ab19-c57aab2fd82a | €35.00 | €0.50 | matched |
| 83 | capture | 01a1b0d3-6cdb-7e9f-8c52-59ccf1cb6704 | €35.00 | €0.50 | matched |
| 84 | capture | 01a1b0d3-6d36-7802-bfed-d9ab3ed56a4b | €9.00 | €0.19 | matched |
| 85 | capture | 01a1b0d3-7e15-781f-8989-07407f91b598 | €49.00 | €0.67 | matched |
| 86 | capture | 01a1b0d3-9565-70e9-9934-e13e2f8aca5d | €24.00 | €0.37 | matched |
| 87 | capture | 01a1b0d3-9ed3-743f-b07a-b5c9855e26ea | €35.00 | €0.50 | matched |
| 88 | capture | 01a1b0d3-9f2f-769f-8d81-68bdd1333b93 | €35.00 | €0.50 | matched |
| 89 | refund | 01a1b0d3-becf-70a1-bc25-7a86bc2ff6ad | -€13.00 | €0.00 | matched |
| 90 | refund | 01a1b0d3-d411-714f-8f0a-4d6efe99f9a9 | -€11.00 | €0.00 | matched |
| 91 | capture | 01a1b0d3-ec3b-7f1c-a842-04428025f6f6 | €9.00 | €0.19 | matched |
| 92 | capture | 01a1b0d3-fb66-76ef-aac7-fa2db01120ee | €15.00 | €0.26 | matched |
| 93 | capture | 01a1b0d4-0b95-7287-b4c3-d60ec8cd4368 | €24.00 | €0.37 | matched |
| 94 | capture | 01a1b0d4-0ce2-765b-957e-ce38c4bb7641 | €9.00 | €0.19 | matched |
| 95 | refund | 01a1b0d4-3e8b-7ccf-8413-5e65f52c9234 | -€21.00 | €0.00 | matched |
| 96 | capture | 01a1b0d4-4fd7-7490-ad15-3f4fc85ed1ea | €15.00 | €0.26 | matched |
| 97 | capture | 01a1b0d4-5585-7721-9e37-1fd0645aee87 | €24.00 | €0.37 | matched |
| 98 | capture | 01a1b0d4-7618-74ff-b577-e9287a15da3c | €35.00 | €0.50 | matched |
| 99 | capture | 01a1b0d4-777c-74d8-871c-b6ad8bfc9b83 | €24.00 | €0.37 | matched |
| 100 | capture | 01a1b0d4-9543-7113-aa9a-a0d68144b03b | €9.00 | €0.19 | matched |
| 101 | capture | 01a1b0d4-9bf0-7833-bac6-363d6be64d05 | €15.00 | €0.26 | matched |
| 102 | capture | 01a1b0d4-a558-745a-a326-23c97fc8f45e | €15.00 | €0.26 | matched |
| 103 | capture | 01a1b0d4-a620-71c2-a25f-afb03908de43 | €49.00 | €0.67 | matched |
| 105 | capture | 01a1b0d4-c03a-7057-afef-34b53481f6e7 | €24.00 | €0.37 | matched |
| 106 | refund | 01a1b0d4-c926-7220-bbf1-2d5f1ade458f | -€13.00 | €0.00 | matched |
| 107 | capture | 01a1b0d4-d96c-7c1f-baa3-e38d1a9d973e | €24.00 | €0.37 | matched |
| 108 | capture | 01a1b0d4-db55-7c22-b162-b08139e72b53 | €9.00 | €0.19 | matched |
| 109 | capture | 01a1b0d4-ea81-7080-a7c1-050903191b31 | €15.00 | €0.26 | matched |
| 110 | capture | 01a1b0d4-f3d7-74d1-9382-2860b42d7e03 | €9.00 | €0.19 | matched |
| 111 | capture | 01a1b0d4-ff27-7768-be0c-5dac88fd0949 | €15.00 | €0.26 | matched |
| 112 | capture | 01a1b0d5-22af-750b-b924-b1be7ba7cd5c | €49.00 | €0.67 | matched |
| 113 | capture | 01a1b0d5-3704-7f98-b59b-8fbf82e447e3 | €35.00 | €0.50 | matched |
| 114 | capture | 01a1b0d5-452a-7762-99dd-8d587d357dd0 | €49.00 | €0.67 | matched |
| 115 | capture | 01a1b0d5-7aef-77cd-8de7-1180d605a26d | €15.00 | €0.26 | matched |
| 116 | capture | 01a1b0d5-7bfe-7799-9b55-deb60264e966 | €15.00 | €0.26 | matched |
| 117 | capture | 01a1b0d5-7fbf-7512-8ade-05b160095ef8 | €9.00 | €0.19 | matched |
| 118 | capture | 01a1b0d5-8f0b-7e5d-abea-b1c7fd83248e | €35.00 | €0.50 | matched |
| 119 | capture | 01a1b0d5-9be3-7f2e-a623-3db14e6626b7 | €15.00 | €0.26 | matched |
| 120 | capture | 01a1b0d5-c5ad-70c5-a848-3b507160287e | €35.00 | €0.50 | matched |
| 121 | refund | 01a1b0d5-c70c-7039-ab79-1e404fd2b851 | -€11.00 | €0.00 | matched |
| 122 | capture | 01a1b0d5-ca16-72c1-90b4-7db3786701fb | €24.00 | €0.37 | matched |
| 123 | capture | 01a1b0d5-cee3-779e-88d7-0cc07eb151ea | €49.00 | €0.67 | matched |
| 125 | capture | 01a1b0d5-d97c-7326-96b0-f0a40e1acefc | €35.00 | €0.50 | matched |
| 126 | capture | 01a1b0d5-d7db-7da1-9870-f800c70d09fb | €35.00 | €0.50 | matched |
| 127 | capture | 01a1b0d6-1ded-7999-ac10-f621c7aba580 | €35.00 | €0.50 | matched |