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
- 21 Oct, 14:10133 lines3 breaks
- 21 Oct, 14:00122 lines1 break
- 21 Oct, 13:50139 lines2 breaks
- 21 Oct, 13:40110 lines1 break
- 21 Oct, 13:30130 lines4 breaks
- 21 Oct, 13:20127 lines3 breaks
- 21 Oct, 13:10125 linesclean
- 21 Oct, 13:00130 linesclean
- 21 Oct, 12:50114 lines1 break
- 21 Oct, 12:40130 lines2 breaks
- 21 Oct, 12:30123 linesclean
- 21 Oct, 12:20117 lines6 breaks
- 21 Oct, 12:10117 lines1 break
- 21 Oct, 12:00131 lines1 break
21 Oct, 12:20
Gross
€3,037.00
PSP fee
€46.70
Net to the bank
€2,990.30
Settlement journal
#123467
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a15e69-5a8d-7d86-9aec-c588e044549c is already settled by stl_EUR_2987642 line 21
- duplicate linethe file lists it twicecapture:01a15e6d-6995-79ef-b24a-41a87c93f6e1 is already settled by stl_EUR_2987642 line 84
- fee differencethe fee is not the contract feethe fee is 30, the contract says 26
- missing linein the books, not in the filecapture:01a15e6a-4e55-7dcc-bc79-b234f670d088 is in no file
- missing linein the books, not in the filecapture:01a15e6d-8d3b-7ce3-9006-66da9e910c35 is in no file
- missing linein the books, not in the filecapture:01a15e6e-3fae-70c9-ab42-b7836f4db061 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 22 | capture | 01a15e69-5af0-7d2b-9218-8669c88e01fe | €15.00 | €0.26 | duplicate line |
| 34 | capture | 01a15e6a-869d-7543-b835-0a0deacbaa71 | €15.00 | €0.30 | fee difference |
| 85 | capture | 01a15e6d-69d7-76ee-9a2f-cfd5ac217d7e | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a15e60-5906-7471-a2a4-6be721abb1f9 | €49.00 | €0.67 | matched |
| 2 | capture | 01a15e64-b545-70c0-9243-e4e404d98867 | €9.00 | €0.19 | matched |
| 3 | capture | 01a15e67-7720-70db-89db-605fae2d4eaa | €9.00 | €0.19 | matched |
| 4 | refund | 01a15e67-8c35-7209-acea-70275f4b3a1b | -€9.00 | €0.00 | matched |
| 5 | capture | 01a15e67-b570-7d8b-a67f-43452e1c5097 | €24.00 | €0.37 | matched |
| 6 | capture | 01a15e67-cd92-7251-90ea-0f51db5734d4 | €49.00 | €0.67 | matched |
| 7 | capture | 01a15e67-d881-7392-8335-b30154b7761b | €24.00 | €0.37 | matched |
| 8 | capture | 01a15e67-e97b-7f87-9081-497f877dabb0 | €35.00 | €0.50 | matched |
| 9 | capture | 01a15e68-16f4-7dcb-9586-6c9db886b491 | €35.00 | €0.50 | matched |
| 10 | refund | 01a15e68-22c6-7f45-beaf-422cd9f442c8 | -€14.00 | €0.00 | matched |
| 11 | capture | 01a15e68-6434-71ca-9cb5-c978fd157af3 | €9.00 | €0.19 | matched |
| 12 | capture | 01a15e68-bbe9-7c10-ae5b-b849959d2246 | €24.00 | €0.37 | matched |
| 13 | capture | 01a15e68-d671-7441-a902-acb58d13aa0e | €49.00 | €0.67 | matched |
| 14 | capture | 01a15e68-e4fc-7be0-b3a8-709fac381d73 | €9.00 | €0.19 | matched |
| 15 | capture | 01a15e69-0696-7dd5-8ee9-bef8c10705ac | €49.00 | €0.67 | matched |
| 16 | capture | 01a15e69-1aa2-717b-a582-3bb0b176f7e4 | €49.00 | €0.67 | matched |
| 17 | capture | 01a15e69-1c45-76ea-b19c-785963ebd021 | €49.00 | €0.67 | matched |
| 18 | capture | 01a15e69-315c-7545-bd17-3ce4fdb69f25 | €35.00 | €0.50 | matched |
| 19 | capture | 01a15e69-4dc0-7563-873f-bfcdbc3ecb18 | €49.00 | €0.67 | matched |
| 20 | capture | 01a15e69-5086-7eb2-aa85-f21813a1d9fb | €49.00 | €0.67 | matched |
| 21 | capture | 01a15e69-5af0-7d2b-9218-8669c88e01fe | €15.00 | €0.26 | matched |
| 23 | capture | 01a15e69-5c5a-79cf-8405-4f051a81c663 | €24.00 | €0.37 | matched |
| 24 | capture | 01a15e69-6b74-77ae-999b-681c77abf2a4 | €35.00 | €0.50 | matched |
| 25 | capture | 01a15e69-70ab-7575-b6fd-399ad3700712 | €15.00 | €0.26 | matched |
| 26 | capture | 01a15e69-81bd-761d-a750-9528b538bd7d | €35.00 | €0.50 | matched |
| 27 | capture | 01a15e69-aa8d-7deb-9604-2d1d38aa1fac | €35.00 | €0.50 | matched |
| 28 | capture | 01a15e69-af1d-7deb-8549-904ddc26a942 | €49.00 | €0.67 | matched |
| 29 | capture | 01a15e69-c3ff-72fc-86ef-0e808a278888 | €35.00 | €0.50 | matched |
| 30 | capture | 01a15e69-e3be-7e40-9b24-d852d8c6a905 | €24.00 | €0.37 | matched |
| 31 | capture | 01a15e6a-24e7-795d-b766-9ff1d9819c25 | €24.00 | €0.37 | matched |
| 32 | capture | 01a15e6a-29f7-7cd5-a2e2-870339c2556c | €35.00 | €0.50 | matched |
| 33 | capture | 01a15e6a-77f8-7e47-a546-448464f1147e | €35.00 | €0.50 | matched |
| 35 | capture | 01a15e6a-8f46-78ad-a2f1-5330b5c7aaf3 | €35.00 | €0.50 | matched |
| 36 | capture | 01a15e6a-9e81-7fff-b197-9bf6fa3e9835 | €9.00 | €0.19 | matched |
| 37 | capture | 01a15e6a-9e87-7fc2-9b53-e5ef248afc0f | €49.00 | €0.67 | matched |
| 38 | capture | 01a15e6a-bb9b-74df-8c40-1005ed7f2dca | €35.00 | €0.50 | matched |
| 39 | capture | 01a15e6b-275e-7f3d-9df6-b55ebbf69f2b | €15.00 | €0.26 | matched |
| 40 | capture | 01a15e6b-2f96-78a7-bf92-cfdff2608643 | €49.00 | €0.67 | matched |
| 41 | capture | 01a15e6b-39a4-7f9c-a029-20e0eb4f1466 | €24.00 | €0.37 | matched |
| 42 | capture | 01a15e6b-40c8-776d-ac99-0f0a90c72cce | €9.00 | €0.19 | matched |
| 43 | capture | 01a15e6b-4747-78e7-8862-c13f93496fb3 | €9.00 | €0.19 | matched |
| 44 | capture | 01a15e6b-5505-704c-8a0f-934bdbfe729a | €15.00 | €0.26 | matched |
| 45 | capture | 01a15e6b-6100-768e-a4ca-ff12512c1b97 | €15.00 | €0.26 | matched |
| 46 | capture | 01a15e6b-729d-7155-a161-37a06ce3a804 | €15.00 | €0.26 | matched |
| 47 | capture | 01a15e6b-8170-7570-ad29-c7af1723636b | €9.00 | €0.19 | matched |
| 48 | capture | 01a15e6b-86b5-7bd2-8686-2e4840517d4c | €35.00 | €0.50 | matched |
| 49 | capture | 01a15e6b-8c9e-7885-95dd-1b8d6a6de5a9 | €9.00 | €0.19 | matched |
| 50 | capture | 01a15e6b-93ec-77ff-9ac1-d280dc525377 | €15.00 | €0.26 | matched |
| 51 | capture | 01a15e6b-9adf-7cee-87c3-56a9796eedcf | €24.00 | €0.37 | matched |
| 52 | capture | 01a15e6b-a58c-7005-b8a2-5563cde45f08 | €9.00 | €0.19 | matched |
| 53 | capture | 01a15e6b-abc3-76d7-974c-d1149b2f4643 | €35.00 | €0.50 | matched |
| 54 | capture | 01a15e6b-b0d0-753b-9e29-d8e3f6ba3e0b | €9.00 | €0.19 | matched |
| 55 | capture | 01a15e6b-c846-75c1-9ac6-528dbb8eb71a | €15.00 | €0.26 | matched |
| 56 | capture | 01a15e6b-cd9b-75f6-bf6d-38fd09ed2d42 | €9.00 | €0.19 | matched |
| 57 | capture | 01a15e6b-db6c-79ed-a227-ff100b409812 | €35.00 | €0.50 | matched |
| 58 | capture | 01a15e6b-ed84-7dcd-931a-36ea06e6ce04 | €35.00 | €0.50 | matched |
| 59 | capture | 01a15e6b-f38e-7e17-a76a-b00674a483bb | €49.00 | €0.67 | matched |
| 60 | capture | 01a15e6b-f53a-7f46-ab15-d0a62db0d776 | €35.00 | €0.50 | matched |
| 61 | capture | 01a15e6c-236a-7feb-8867-e65ca788617f | €24.00 | €0.37 | matched |
| 62 | capture | 01a15e6c-26cf-7534-9379-e8676d6b593e | €15.00 | €0.26 | matched |
| 63 | capture | 01a15e6c-28a5-7a0e-a6ec-e74b34362937 | €35.00 | €0.50 | matched |
| 64 | capture | 01a15e6c-34ad-747a-bd10-631e4b5403b3 | €35.00 | €0.50 | matched |
| 65 | capture | 01a15e6c-3547-7e9e-beff-264c06fc3ab6 | €15.00 | €0.26 | matched |
| 66 | capture | 01a15e6c-3934-76b6-8ae7-93879d2b6fb4 | €49.00 | €0.67 | matched |
| 67 | capture | 01a15e6c-397d-7869-9c7c-b31b03ad58b1 | €35.00 | €0.50 | matched |
| 68 | capture | 01a15e6c-3c5c-77c3-9745-c7e810af9df3 | €24.00 | €0.37 | matched |
| 69 | capture | 01a15e6c-46a4-77cf-bc93-af3e52e4c9e7 | €15.00 | €0.26 | matched |
| 70 | capture | 01a15e6c-7e26-7d32-9b3c-3f02b6417689 | €49.00 | €0.67 | matched |
| 71 | capture | 01a15e6c-860e-743a-a52f-d4cbcbd3ef7e | €49.00 | €0.67 | matched |
| 72 | refund | 01a15e6c-9648-7ef9-a0c9-8adfa55f5851 | -€5.00 | €0.00 | matched |
| 73 | capture | 01a15e6c-9fca-7df0-a08a-f72fb41ab4d0 | €9.00 | €0.19 | matched |
| 74 | capture | 01a15e6c-a103-7e89-9ce7-0393e2d8aa97 | €49.00 | €0.67 | matched |
| 75 | refund | 01a15e6c-a8c6-7dff-81fb-8858ce001766 | -€5.00 | €0.00 | matched |
| 76 | capture | 01a15e6c-c6ef-7134-ad9d-ab530b27dbc2 | €49.00 | €0.67 | matched |
| 77 | capture | 01a15e6c-caf2-74f0-acd7-3a14b83b928f | €15.00 | €0.26 | matched |
| 78 | capture | 01a15e6c-d450-740f-a670-f739d13e0208 | €9.00 | €0.19 | matched |
| 79 | capture | 01a15e6c-edd9-73f3-ae41-289114c15003 | €35.00 | €0.50 | matched |
| 80 | capture | 01a15e6d-0cdc-71e7-a5a8-4de3dc5a7790 | €9.00 | €0.19 | matched |
| 81 | capture | 01a15e6d-12e1-7161-887e-6d453f80cf21 | €9.00 | €0.19 | matched |
| 82 | capture | 01a15e6d-62ea-7260-af38-e4813dc1b1c6 | €15.00 | €0.26 | matched |
| 83 | capture | 01a15e6d-6392-7e9e-a97f-5d21b4bc62dc | €24.00 | €0.37 | matched |
| 84 | capture | 01a15e6d-69d7-76ee-9a2f-cfd5ac217d7e | €35.00 | €0.50 | matched |
| 86 | capture | 01a15e6d-6e3b-7f6f-950d-95594fdde3f4 | €24.00 | €0.37 | matched |
| 87 | capture | 01a15e6d-aad7-7be2-8f88-9aa3c1d3043f | €49.00 | €0.67 | matched |
| 88 | capture | 01a15e6d-b93c-7ee6-bbf5-c224b8036750 | €24.00 | €0.37 | matched |
| 89 | capture | 01a15e6d-cd34-71eb-bf16-0c37b21a5768 | €9.00 | €0.19 | matched |
| 90 | capture | 01a15e6d-d324-713f-9256-f9a2e44bfd3a | €24.00 | €0.37 | matched |
| 91 | capture | 01a15e6d-f7aa-7405-960f-14532c867119 | €15.00 | €0.26 | matched |
| 92 | capture | 01a15e6e-304a-740a-939c-bbe1ea17b74b | €35.00 | €0.50 | matched |
| 93 | capture | 01a15e6e-4dda-74e1-876e-423fecc612e1 | €15.00 | €0.26 | matched |
| 94 | capture | 01a15e6e-518e-72d9-8a8f-ff04c2c6a4f2 | €24.00 | €0.37 | matched |
| 95 | capture | 01a15e6e-827f-7502-8bb5-0067b21318c6 | €15.00 | €0.26 | matched |
| 96 | capture | 01a15e6e-a3d9-7b4a-9634-b864b42f6ae4 | €15.00 | €0.26 | matched |
| 97 | capture | 01a15e6e-a84d-7ec4-9bb8-75509ed07b9e | €49.00 | €0.67 | matched |
| 98 | capture | 01a15e6e-a9c0-74f3-92ef-362b3f9c2264 | €35.00 | €0.50 | matched |
| 99 | capture | 01a15e6e-c63f-7c55-974c-a2f0bb1e8b6f | €35.00 | €0.50 | matched |
| 100 | capture | 01a15e6e-d09f-72dd-b388-b635247229fa | €35.00 | €0.50 | matched |
| 101 | capture | 01a15e6e-d267-712b-b9c0-880e6fba1bdc | €49.00 | €0.67 | matched |
| 102 | capture | 01a15e6e-e157-7d6a-bd57-0600f439eded | €49.00 | €0.67 | matched |
| 103 | refund | 01a15e6e-fd9e-78ed-b20b-cef5901c3311 | -€21.00 | €0.00 | matched |
| 104 | refund | 01a15e6f-1d9a-7e3c-8d95-6d64db4f883f | -€22.00 | €0.00 | matched |
| 105 | capture | 01a15e6f-3334-7525-8176-04630b231cea | €49.00 | €0.67 | matched |
| 106 | capture | 01a15e6f-7f49-7efc-bbc2-c82a99f68322 | €49.00 | €0.67 | matched |
| 107 | capture | 01a15e6f-8f9d-7dff-acca-65194ee770ff | €35.00 | €0.50 | matched |
| 108 | capture | 01a15e6f-b7b3-79b0-a72d-e534cf9e3eda | €24.00 | €0.37 | matched |
| 109 | capture | 01a15e6f-bffa-7c8f-bc1e-ef59b0aa543c | €49.00 | €0.67 | matched |
| 110 | capture | 01a15e6f-d71e-7353-8bd2-175d5d622f6c | €24.00 | €0.37 | matched |
| 111 | capture | 01a15e6f-d9c9-7dba-af29-6187b0166973 | €9.00 | €0.19 | matched |
| 112 | capture | 01a15e6f-fe65-7295-908e-9d1c233d6439 | €35.00 | €0.50 | matched |
| 113 | refund | 01a15e70-0302-70c1-9f7d-9b7551cffd5a | -€32.00 | €0.00 | matched |
| 114 | capture | 01a15e70-0481-7b6c-ac02-705ae6984a19 | €15.00 | €0.26 | matched |
| 115 | capture | 01a15e70-478b-7b40-8f0c-85e37029794f | €35.00 | €0.50 | matched |
| 116 | capture | 01a15e70-6010-7059-b751-1bf48b4703ef | €49.00 | €0.67 | matched |
| 117 | capture | 01a15e70-91a4-72dd-802a-32050d1d55ec | €35.00 | €0.50 | matched |