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
- 14 Oct, 23:10133 lines3 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, 21:40113 lines4 breaks
- 14 Oct, 21:30122 lines2 breaks
- 14 Oct, 21:20124 linesclean
- 14 Oct, 21:10137 lines3 breaks
- 14 Oct, 21:00146 lines9 breaks
14 Oct, 22:10
Gross
€2,577.00
PSP fee
€40.63
Net to the bank
€2,536.37
Settlement journal
#3667
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13c7e-0cb4-76f3-8baa-2feb9c7bb39a is already settled by stl_EUR_2986693 line 87
- missing linein the books, not in the filerefund:01a13c7f-bec0-7194-9664-f630ddff51dc is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 88 | capture | 01a13c7e-0d40-7611-b867-9464d5cfe755 | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a13c6f-88fe-7596-91c2-06e0237e6794 | €49.00 | €0.67 | matched |
| 2 | capture | 01a13c70-a986-7ee0-9ca5-1fad9defdf67 | €24.00 | €0.37 | matched |
| 3 | capture | 01a13c71-9ff6-708a-87cd-951f4e19b64d | €24.00 | €0.37 | matched |
| 4 | capture | 01a13c77-1a97-77df-be85-124420330e23 | €49.00 | €0.67 | matched |
| 5 | capture | 01a13c77-2156-74bd-8b10-fe29125dd7a3 | €35.00 | €0.50 | matched |
| 6 | capture | 01a13c77-3880-709a-84f4-53895cff8125 | €15.00 | €0.26 | matched |
| 7 | capture | 01a13c77-56ae-78d2-aa78-1cdb3df7400f | €49.00 | €0.67 | matched |
| 8 | capture | 01a13c77-5fb2-7aec-9f20-57de52775fe6 | €24.00 | €0.37 | matched |
| 9 | capture | 01a13c77-7510-76c0-bff5-ccce196ee8dc | €24.00 | €0.37 | matched |
| 10 | capture | 01a13c77-888e-757f-8282-5a09abc98c0b | €49.00 | €0.67 | matched |
| 11 | capture | 01a13c77-b5aa-7566-a2c0-35586f1e649e | €35.00 | €0.50 | matched |
| 12 | capture | 01a13c77-bc67-7017-8a88-c7f3f21a5e2c | €15.00 | €0.26 | matched |
| 13 | capture | 01a13c77-d90c-704f-9ac5-c251f64ea415 | €35.00 | €0.50 | matched |
| 14 | capture | 01a13c77-f727-7450-8598-ec33da735789 | €15.00 | €0.26 | matched |
| 15 | refund | 01a13c78-0e6c-748d-8ec7-6f9e8a50f0c0 | -€11.00 | €0.00 | matched |
| 16 | capture | 01a13c78-218e-7fd5-a424-b4cba79bd513 | €15.00 | €0.26 | matched |
| 17 | capture | 01a13c78-3c3c-7511-9f09-c51c22b4ed41 | €15.00 | €0.26 | matched |
| 18 | capture | 01a13c78-a567-7704-bcf7-597d67b58c54 | €24.00 | €0.37 | matched |
| 19 | capture | 01a13c78-c89b-72f9-9ca1-349d1a685f68 | €24.00 | €0.37 | matched |
| 20 | capture | 01a13c78-c994-7dcf-933e-bd125aae12df | €9.00 | €0.19 | matched |
| 21 | capture | 01a13c78-e6bd-7d20-bd82-0b57d0e4a8d0 | €9.00 | €0.19 | matched |
| 22 | capture | 01a13c79-6fa5-7d0c-8176-aaf91d4f88bd | €9.00 | €0.19 | matched |
| 23 | capture | 01a13c79-7334-7ccf-b706-84fa338f6dc7 | €35.00 | €0.50 | matched |
| 24 | capture | 01a13c79-8dfd-730d-bc54-d26d72105e6a | €9.00 | €0.19 | matched |
| 25 | capture | 01a13c79-97bd-7548-b64c-f15530ab4a61 | €49.00 | €0.67 | matched |
| 26 | capture | 01a13c79-abae-7944-95c3-f355742ccfc5 | €9.00 | €0.19 | matched |
| 27 | capture | 01a13c79-ac9e-7138-804f-3ae61e478858 | €24.00 | €0.37 | matched |
| 28 | refund | 01a13c79-abdf-7c74-9a29-6b2597095dfe | -€3.00 | €0.00 | matched |
| 29 | capture | 01a13c79-d0ec-76d5-bb91-83e1fdf7308d | €15.00 | €0.26 | matched |
| 30 | capture | 01a13c79-dd2c-7b19-a701-980b30fdc8c7 | €35.00 | €0.50 | matched |
| 31 | capture | 01a13c79-e493-780f-8937-7b64a02a85d1 | €15.00 | €0.26 | matched |
| 32 | capture | 01a13c79-f783-7d11-9d49-74ab1c2facfe | €9.00 | €0.19 | matched |
| 33 | capture | 01a13c79-fbde-7880-9a83-4dd9b05f4702 | €24.00 | €0.37 | matched |
| 34 | capture | 01a13c7a-3561-73e7-b4e5-1b11df85cc0d | €24.00 | €0.37 | matched |
| 35 | capture | 01a13c7a-6d39-7028-8236-b5efb109d70f | €24.00 | €0.37 | matched |
| 36 | capture | 01a13c7a-7ca9-7188-a519-7e4f40e09550 | €9.00 | €0.19 | matched |
| 37 | capture | 01a13c7a-a37d-7dcd-98fe-a83848bc2663 | €9.00 | €0.19 | matched |
| 38 | capture | 01a13c7a-b9e8-7e6f-b47b-f1c8ab9e17b0 | €49.00 | €0.67 | matched |
| 39 | capture | 01a13c7a-bea2-7e0a-88b8-150eb3329c99 | €49.00 | €0.67 | matched |
| 40 | capture | 01a13c7a-d89a-765c-a2f2-0807aca00b8f | €24.00 | €0.37 | matched |
| 41 | capture | 01a13c7a-f1ca-75de-a3d6-998e30c85bdb | €24.00 | €0.37 | matched |
| 42 | capture | 01a13c7b-1496-7d50-8882-258c04e99811 | €15.00 | €0.26 | matched |
| 43 | refund | 01a13c7b-16cd-7ddc-bd04-e4b1e716b87d | -€10.00 | €0.00 | matched |
| 44 | refund | 01a13c7b-3cfe-7b71-90dd-4e9687b232a4 | -€9.00 | €0.00 | matched |
| 45 | capture | 01a13c7b-3ea2-73a4-9457-9b4ac71d4a0d | €9.00 | €0.19 | matched |
| 46 | capture | 01a13c7b-62f1-7470-882e-18a2157c2235 | €35.00 | €0.50 | matched |
| 47 | capture | 01a13c7b-67b8-75f4-97af-8504cecb75cb | €35.00 | €0.50 | matched |
| 48 | capture | 01a13c7b-8914-763d-ae1b-d364eaec3264 | €15.00 | €0.26 | matched |
| 49 | capture | 01a13c7b-8e13-7887-9ee6-9eaecc29552c | €9.00 | €0.19 | matched |
| 50 | capture | 01a13c7b-961c-7e6c-9223-77539a0b7271 | €49.00 | €0.67 | matched |
| 51 | capture | 01a13c7b-9661-7b2a-bddd-61292f69ec4c | €35.00 | €0.50 | matched |
| 52 | refund | 01a13c7b-a653-7064-bad0-567d2699259d | -€16.00 | €0.00 | matched |
| 53 | capture | 01a13c7b-abbf-7083-b186-bd87e7825690 | €15.00 | €0.26 | matched |
| 54 | capture | 01a13c7b-b440-7c69-8937-a956cd68b372 | €24.00 | €0.37 | matched |
| 55 | capture | 01a13c7b-df3b-78f3-a982-c1435f2aea59 | €24.00 | €0.37 | matched |
| 56 | capture | 01a13c7b-eace-724b-8ebe-52e2c5ad7421 | €24.00 | €0.37 | matched |
| 57 | capture | 01a13c7b-f215-7741-b4b6-6f84ab029230 | €35.00 | €0.50 | matched |
| 58 | capture | 01a13c7c-01cf-74a3-9ccb-3b78d886df94 | €35.00 | €0.50 | matched |
| 59 | capture | 01a13c7c-0276-7b47-9fbb-804a4826a7ca | €15.00 | €0.26 | matched |
| 60 | capture | 01a13c7c-0c81-7069-bd29-e1f4e96424df | €15.00 | €0.26 | matched |
| 61 | capture | 01a13c7c-0ec4-7d71-9672-db695c4bb3f3 | €15.00 | €0.26 | matched |
| 62 | capture | 01a13c7c-1fae-7aa0-84c7-44ddc4362aaa | €9.00 | €0.19 | matched |
| 63 | capture | 01a13c7c-410b-7f07-bf8d-74127463b069 | €24.00 | €0.37 | matched |
| 64 | refund | 01a13c7c-5d9e-7788-b089-4e4b2e824a95 | -€20.00 | €0.00 | matched |
| 65 | capture | 01a13c7c-73b5-75c3-aacf-8b2239b768cd | €9.00 | €0.19 | matched |
| 66 | capture | 01a13c7c-848f-73ba-bbb6-9469ff59d45f | €35.00 | €0.50 | matched |
| 67 | capture | 01a13c7c-8fb9-7f70-a37b-a130e14b7322 | €15.00 | €0.26 | matched |
| 68 | capture | 01a13c7c-9f41-7604-92b8-c93f5d102fd3 | €24.00 | €0.37 | matched |
| 69 | capture | 01a13c7c-a801-7e36-90ea-82182eb9e33b | €15.00 | €0.26 | matched |
| 70 | refund | 01a13c7c-b952-7694-a03b-4146d6079cb2 | -€6.00 | €0.00 | matched |
| 71 | capture | 01a13c7c-bbe4-75ac-8bab-bc2386156ef0 | €49.00 | €0.67 | matched |
| 72 | capture | 01a13c7c-c1e0-7c1c-a250-9178b0eb80ed | €15.00 | €0.26 | matched |
| 73 | capture | 01a13c7c-def7-79e9-85fc-9e8b2239616f | €9.00 | €0.19 | matched |
| 74 | capture | 01a13c7c-df5c-715e-abf8-bcc88c918f65 | €49.00 | €0.67 | matched |
| 75 | capture | 01a13c7c-e9c4-7497-8ae5-ee64289bb6e4 | €9.00 | €0.19 | matched |
| 76 | capture | 01a13c7d-09f2-7db0-b1b8-b9bceba64fb5 | €9.00 | €0.19 | matched |
| 77 | refund | 01a13c7d-2288-7813-948e-f6209d3f2cd3 | -€12.00 | €0.00 | matched |
| 78 | capture | 01a13c7d-4730-7c9a-af42-6804cb94b98a | €24.00 | €0.37 | matched |
| 79 | capture | 01a13c7d-5b18-7205-9352-3876a30fae35 | €9.00 | €0.19 | matched |
| 80 | capture | 01a13c7d-5c32-7832-83e5-1cebc14136a5 | €35.00 | €0.50 | matched |
| 81 | capture | 01a13c7d-634e-7914-ae7a-3d4bc694a3ab | €35.00 | €0.50 | matched |
| 82 | capture | 01a13c7d-8f65-79af-9ca6-749ea27f7ad2 | €35.00 | €0.50 | matched |
| 83 | capture | 01a13c7d-abb2-725c-8a73-11d87c99d202 | €15.00 | €0.26 | matched |
| 84 | refund | 01a13c7d-c075-7654-8660-ce7f6d2953cb | -€3.00 | €0.00 | matched |
| 85 | capture | 01a13c7d-fadc-7be6-8360-40a4ee873c92 | €49.00 | €0.67 | matched |
| 86 | capture | 01a13c7e-061f-7b93-b7e6-eb5e624737a4 | €9.00 | €0.19 | matched |
| 87 | capture | 01a13c7e-0d40-7611-b867-9464d5cfe755 | €49.00 | €0.67 | matched |
| 89 | capture | 01a13c7e-3fd5-7065-bced-8222cebe394e | €15.00 | €0.26 | matched |
| 90 | capture | 01a13c7e-4b40-7123-81d2-0cfa239d88d0 | €9.00 | €0.19 | matched |
| 91 | capture | 01a13c7e-4873-7200-932f-8137fbd2cf68 | €24.00 | €0.37 | matched |
| 92 | capture | 01a13c7e-686b-71ca-b93e-97a73a2d34da | €24.00 | €0.37 | matched |
| 93 | capture | 01a13c7e-8cf9-72e4-bc81-3b8eb5672176 | €9.00 | €0.19 | matched |
| 94 | capture | 01a13c7e-c6b4-737c-a33e-cea0189ae27d | €49.00 | €0.67 | matched |
| 95 | capture | 01a13c7e-d240-7ffa-ac9e-b996a768d078 | €9.00 | €0.19 | matched |
| 96 | capture | 01a13c7e-e72c-7913-b2b4-b2d14acdec5a | €9.00 | €0.19 | matched |
| 97 | capture | 01a13c7e-f30e-7846-864c-a2c50edb7619 | €49.00 | €0.67 | matched |
| 98 | capture | 01a13c7f-138f-74ff-aa10-586218fbe5fa | €49.00 | €0.67 | matched |
| 99 | capture | 01a13c7f-1d9b-7804-a973-367d633ac477 | €49.00 | €0.67 | matched |
| 100 | capture | 01a13c7f-22d3-72c9-ac62-c487a51be99e | €24.00 | €0.37 | matched |
| 101 | capture | 01a13c7f-2321-78a6-9f87-01717517ddd2 | €35.00 | €0.50 | matched |
| 102 | capture | 01a13c7f-414f-7ffe-97f8-f992f8fa436b | €9.00 | €0.19 | matched |
| 103 | capture | 01a13c7f-492b-7d81-a89c-2bc1ec25c8ac | €15.00 | €0.26 | matched |
| 104 | capture | 01a13c7f-501e-7fab-bae4-68d426e918da | €49.00 | €0.67 | matched |
| 105 | capture | 01a13c7f-6dbb-7f5f-96fe-0cc4bbbbe62c | €15.00 | €0.26 | matched |
| 106 | capture | 01a13c7f-7669-7dd0-9bf7-7f3d47349ad4 | €9.00 | €0.19 | matched |
| 107 | capture | 01a13c7f-ad80-7892-b830-3e84e7753cd2 | €24.00 | €0.37 | matched |
| 108 | capture | 01a13c7f-b800-76b5-b7b9-9a44e53c5bc5 | €35.00 | €0.50 | matched |
| 109 | refund | 01a13c7f-be80-7317-a69c-bdb51da35e47 | -€8.00 | €0.00 | matched |
| 110 | capture | 01a13c7f-bf74-7c7f-b8f0-4967c8af786a | €49.00 | €0.67 | matched |
| 111 | capture | 01a13c7f-eb2b-7cbb-b9de-44a1101c1ed8 | €15.00 | €0.26 | matched |
| 112 | capture | 01a13c7f-ebf7-700d-9725-d502528244b8 | €15.00 | €0.26 | matched |
| 113 | capture | 01a13c80-1134-74ef-94ff-93b97e291fb6 | €35.00 | €0.50 | matched |
| 114 | capture | 01a13c80-113d-786c-bbab-9ad9cec74190 | €35.00 | €0.50 | matched |
| 115 | capture | 01a13c80-1d7c-740f-8771-bb7c636c3963 | €49.00 | €0.67 | matched |