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
- 19 Oct, 23:50148 lines3 breaks
- 19 Oct, 23:40121 lines3 breaks
- 19 Oct, 23:30112 lines2 breaks
- 19 Oct, 23:20109 lines4 breaks
- 19 Oct, 23:10121 lines1 break
- 19 Oct, 23:00107 lines2 breaks
- 19 Oct, 22:50127 lines3 breaks
- 19 Oct, 22:40121 lines3 breaks
- 19 Oct, 22:30135 lines2 breaks
- 19 Oct, 22:20112 lines5 breaks
- 19 Oct, 22:10125 lines2 breaks
- 19 Oct, 22:00115 lines1 break
- 19 Oct, 21:50115 lines1 break
- 19 Oct, 21:40143 linesclean
19 Oct, 23:00
Gross
€2,580.00
PSP fee
€39.76
Net to the bank
€2,540.24
Settlement journal
#95120
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a15667-36f5-70a8-b866-4dcbe945d549 is already settled by stl_EUR_2987418 line 33
- missing linein the books, not in the filerefund:01a15667-6c1c-7696-9457-766aeec5d50f is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 34 | capture | 01a15667-3724-7d14-9521-f5e6d3dfdfab | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a1565b-d2c5-7ee8-8dec-c5a30b2dad90 | €35.00 | €0.50 | matched |
| 2 | capture | 01a1565e-0ab9-7f52-9706-c84cd6d2f1e2 | €15.00 | €0.26 | matched |
| 3 | refund | 01a15664-b5fd-7523-8e74-3208162364da | -€14.00 | €0.00 | matched |
| 4 | capture | 01a15664-b5ee-79d6-a062-54dd1ae43bb8 | €15.00 | €0.26 | matched |
| 5 | capture | 01a15664-b6ba-79ba-95a1-4348a2ef1339 | €24.00 | €0.37 | matched |
| 6 | capture | 01a15664-d032-72c1-b897-95e864618861 | €24.00 | €0.37 | matched |
| 7 | capture | 01a15664-d6db-72bc-ac5e-c61cc7c69a57 | €15.00 | €0.26 | matched |
| 8 | capture | 01a15665-09bc-7c1d-ab37-ebe21b421c26 | €35.00 | €0.50 | matched |
| 9 | capture | 01a15665-19d2-796d-84a2-c665bb8cffc7 | €15.00 | €0.26 | matched |
| 10 | capture | 01a15665-2023-72ca-a57d-9bb6db99c0a3 | €24.00 | €0.37 | matched |
| 11 | capture | 01a15665-2988-719a-afb5-98d8f436adcb | €49.00 | €0.67 | matched |
| 12 | capture | 01a15665-4372-7daa-9980-09097818cdd4 | €15.00 | €0.26 | matched |
| 13 | capture | 01a15665-5803-7c52-8ead-345c94bd84eb | €49.00 | €0.67 | matched |
| 14 | capture | 01a15665-5f72-7a10-a8e6-50bce190deb6 | €9.00 | €0.19 | matched |
| 15 | capture | 01a15665-9b98-7e16-9707-5fac75c62203 | €24.00 | €0.37 | matched |
| 16 | capture | 01a15665-c930-70cf-ba80-e69a8b52ea30 | €15.00 | €0.26 | matched |
| 17 | capture | 01a15665-ee42-709d-b4e4-d3b0a17bbe0d | €9.00 | €0.19 | matched |
| 18 | capture | 01a15665-fbd0-7081-81a6-b8b82d1bdfed | €15.00 | €0.26 | matched |
| 19 | capture | 01a15665-fdc6-76f4-b25e-4a8a5f157c79 | €15.00 | €0.26 | matched |
| 20 | capture | 01a15666-1e29-7627-b393-addf98865335 | €9.00 | €0.19 | matched |
| 21 | capture | 01a15666-23b8-72d2-9289-92f2bb22d9a0 | €49.00 | €0.67 | matched |
| 22 | capture | 01a15666-2a7d-7814-acad-bf7769d24b27 | €9.00 | €0.19 | matched |
| 23 | capture | 01a15666-54f8-7b8b-a905-288158e5130d | €49.00 | €0.67 | matched |
| 24 | capture | 01a15666-58fb-766a-9225-0870d462628b | €15.00 | €0.26 | matched |
| 25 | capture | 01a15666-8aec-7766-ae63-28edadc72b67 | €9.00 | €0.19 | matched |
| 26 | capture | 01a15666-9bc2-7222-bd3c-bcc6c0843442 | €35.00 | €0.50 | matched |
| 27 | capture | 01a15666-c09e-7635-ba45-48fb08176c46 | €9.00 | €0.19 | matched |
| 28 | capture | 01a15667-0d60-798d-90ab-737d41d1c658 | €15.00 | €0.26 | matched |
| 29 | capture | 01a15667-0f82-7eb0-adc8-80dd6de3edc7 | €24.00 | €0.37 | matched |
| 30 | capture | 01a15667-19f9-7c7c-8099-3d139dcac5bd | €15.00 | €0.26 | matched |
| 31 | capture | 01a15667-1a9d-7ed9-a1c0-9fa9ca5151e5 | €24.00 | €0.37 | matched |
| 32 | capture | 01a15667-2897-7a24-87d1-fc844efcf833 | €24.00 | €0.37 | matched |
| 33 | capture | 01a15667-3724-7d14-9521-f5e6d3dfdfab | €35.00 | €0.50 | matched |
| 35 | capture | 01a15667-4875-7dbb-aaa5-747395372169 | €15.00 | €0.26 | matched |
| 36 | capture | 01a15667-577a-768e-9fe6-d816f4c222cb | €49.00 | €0.67 | matched |
| 37 | refund | 01a15667-622a-759d-966f-e96f1e343fc0 | -€9.00 | €0.00 | matched |
| 38 | capture | 01a15667-81f2-7043-822c-fb0bcfe85096 | €49.00 | €0.67 | matched |
| 39 | capture | 01a15667-ac0d-7335-8b77-bdfe2f599061 | €49.00 | €0.67 | matched |
| 40 | refund | 01a15667-ad3a-7cf3-ac25-c1511eb17bc4 | -€9.00 | €0.00 | matched |
| 41 | capture | 01a15667-d561-7102-850c-d6ad424fb181 | €24.00 | €0.37 | matched |
| 42 | capture | 01a15667-f016-770d-83f5-bba705bb2af2 | €15.00 | €0.26 | matched |
| 43 | capture | 01a15667-f5e7-78c7-8108-f5034acfa72e | €49.00 | €0.67 | matched |
| 44 | capture | 01a15668-1184-720b-ae43-01f53059cbf2 | €24.00 | €0.37 | matched |
| 45 | capture | 01a15668-1991-7e67-9ceb-7701cd429d73 | €49.00 | €0.67 | matched |
| 46 | capture | 01a15668-221c-74f4-af0c-e12c9e64aa7e | €9.00 | €0.19 | matched |
| 47 | capture | 01a15668-36b6-74f6-aac9-44ef96fd4a98 | €15.00 | €0.26 | matched |
| 48 | capture | 01a15668-490b-7ce9-955d-280e43430c8f | €24.00 | €0.37 | matched |
| 49 | capture | 01a15668-4d65-77ad-b651-78a54028555d | €9.00 | €0.19 | matched |
| 50 | capture | 01a15668-5c15-75be-8619-26c0eeb1d427 | €9.00 | €0.19 | matched |
| 51 | capture | 01a15668-8e4c-74a4-ad43-ca6f1cf99189 | €9.00 | €0.19 | matched |
| 52 | capture | 01a15668-9a66-7be1-88e0-45b126019136 | €24.00 | €0.37 | matched |
| 53 | capture | 01a15668-a4b1-7722-852a-fcb834ef652d | €24.00 | €0.37 | matched |
| 54 | capture | 01a15668-c1e3-7f11-b9f0-7c4b4427afd4 | €35.00 | €0.50 | matched |
| 55 | capture | 01a15668-cc59-7c55-a10f-272d578f5106 | €9.00 | €0.19 | matched |
| 56 | capture | 01a15668-edf3-7e67-8192-72154dd11b0d | €24.00 | €0.37 | matched |
| 57 | capture | 01a15669-1500-78e5-9d55-bafea5161291 | €15.00 | €0.26 | matched |
| 58 | capture | 01a15669-2c07-77ab-b284-32b510310688 | €49.00 | €0.67 | matched |
| 59 | capture | 01a15669-3b07-741a-ab53-5cfbf58f89eb | €9.00 | €0.19 | matched |
| 60 | capture | 01a15669-409f-74dd-8cb6-8600cad8081d | €35.00 | €0.50 | matched |
| 61 | capture | 01a15669-54f8-7ce9-9754-9f5697e87068 | €35.00 | €0.50 | matched |
| 62 | capture | 01a15669-67c9-7c77-953d-88b3bd310bf7 | €15.00 | €0.26 | matched |
| 63 | refund | 01a15669-7858-73c5-a1ef-11aae7bb3c42 | -€4.00 | €0.00 | matched |
| 64 | capture | 01a15669-7c2b-7e03-a708-1136e5a84c52 | €9.00 | €0.19 | matched |
| 65 | capture | 01a15669-83b9-7e1d-a5e7-56a320d41527 | €24.00 | €0.37 | matched |
| 66 | capture | 01a15669-a0c0-71e1-a994-a388f7774a34 | €49.00 | €0.67 | matched |
| 67 | capture | 01a15669-a5ed-7e2b-a97f-b2c173936922 | €9.00 | €0.19 | matched |
| 68 | capture | 01a15669-b999-7b27-b56b-eb61d2db9a6c | €9.00 | €0.19 | matched |
| 69 | capture | 01a1566a-010a-73c3-a6f1-ad03c5129812 | €9.00 | €0.19 | matched |
| 70 | capture | 01a1566a-0e24-7549-87f8-d0c42cb1eb8c | €9.00 | €0.19 | matched |
| 71 | capture | 01a1566a-1e3b-752e-b9b7-996e2aee87fe | €9.00 | €0.19 | matched |
| 72 | capture | 01a1566a-5439-7b6a-b49b-6b6ce479a210 | €35.00 | €0.50 | matched |
| 73 | capture | 01a1566a-6cf5-7031-9088-b3d5d2e2c52a | €24.00 | €0.37 | matched |
| 74 | capture | 01a1566a-797b-7e38-b834-a46f5ddc8968 | €24.00 | €0.37 | matched |
| 75 | capture | 01a1566a-a9ad-78dc-8b2d-8c412ecdd22c | €15.00 | €0.26 | matched |
| 76 | capture | 01a1566a-cd57-7e65-b9e8-b63b054aa811 | €49.00 | €0.67 | matched |
| 77 | capture | 01a1566a-e1fa-7b83-a2e2-a8d3d61561e0 | €49.00 | €0.67 | matched |
| 78 | capture | 01a1566a-f0ba-79a4-9663-ba518bc47ce7 | €35.00 | €0.50 | matched |
| 79 | capture | 01a1566a-f1df-713a-8fe6-463f6b44aa24 | €49.00 | €0.67 | matched |
| 80 | capture | 01a1566a-f484-7319-82f3-90c77f3bdfff | €9.00 | €0.19 | matched |
| 81 | capture | 01a1566b-1250-7fa1-bf9f-cb23b8d71c3c | €9.00 | €0.19 | matched |
| 82 | capture | 01a1566b-3942-727c-a0b3-63b1f9b4b933 | €9.00 | €0.19 | matched |
| 83 | capture | 01a1566b-5ebb-7dfe-b969-568e1df3db49 | €9.00 | €0.19 | matched |
| 84 | capture | 01a1566b-6c55-7dce-a7e0-39a297e48fa8 | €49.00 | €0.67 | matched |
| 85 | capture | 01a1566b-8b16-7b9b-ae1f-b7b21257f5ca | €49.00 | €0.67 | matched |
| 86 | capture | 01a1566b-8ea4-758f-bc36-39a270772fa3 | €15.00 | €0.26 | matched |
| 87 | capture | 01a1566b-c24a-7587-bded-28cb8beb214e | €24.00 | €0.37 | matched |
| 88 | refund | 01a1566b-efa2-7490-b013-b63dc26b880a | -€6.00 | €0.00 | matched |
| 89 | capture | 01a1566b-f7f3-761e-b048-db409f5c5e12 | €9.00 | €0.19 | matched |
| 90 | capture | 01a1566b-fe37-7516-9b59-9dbfe30900c9 | €49.00 | €0.67 | matched |
| 91 | capture | 01a1566c-3d65-7ef0-b934-75f61b0bb1d0 | €49.00 | €0.67 | matched |
| 92 | capture | 01a1566c-5559-722e-815a-5bf098e2426d | €35.00 | €0.50 | matched |
| 93 | capture | 01a1566c-5a29-722e-92e9-94f8c05e77b5 | €15.00 | €0.26 | matched |
| 94 | capture | 01a1566c-b585-7a8f-902b-60badba99a79 | €49.00 | €0.67 | matched |
| 95 | capture | 01a1566c-b6e7-7bf6-b18f-4cc4fa0f8336 | €24.00 | €0.37 | matched |
| 96 | capture | 01a1566c-c8e9-7a93-b1c3-2a941bf753ea | €35.00 | €0.50 | matched |
| 97 | capture | 01a1566c-f401-784d-9fc4-29c3514d829e | €49.00 | €0.67 | matched |
| 98 | capture | 01a1566c-f89f-7ecf-bc1f-60f4576ec33e | €35.00 | €0.50 | matched |
| 99 | capture | 01a1566d-2f31-769c-83ad-cb1c1ffd0791 | €9.00 | €0.19 | matched |
| 100 | capture | 01a1566d-39a7-7eeb-b4f9-72c8e71f6249 | €35.00 | €0.50 | matched |
| 101 | capture | 01a1566d-4d72-7c7c-bea2-7b15fed52601 | €24.00 | €0.37 | matched |
| 102 | capture | 01a1566d-7bf3-7830-9f57-82d2cf38e0e3 | €15.00 | €0.26 | matched |
| 103 | capture | 01a1566d-8457-76df-903a-2686b11f3722 | €49.00 | €0.67 | matched |
| 104 | capture | 01a1566d-8f85-711c-ad2b-3712d6c0409f | €49.00 | €0.67 | matched |
| 105 | capture | 01a1566d-a90e-7e1c-a0a0-213689469750 | €9.00 | €0.19 | matched |
| 106 | capture | 01a1566d-b516-7e3a-b8e7-e437c2abe364 | €24.00 | €0.37 | matched |
| 107 | capture | 01a1566d-ba59-7879-b181-b119f0c5bc8a | €49.00 | €0.67 | matched |