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
- 15 Oct, 01:50145 lines4 breaks
- 15 Oct, 01:40147 lines7 breaks
- 15 Oct, 01:30122 lines1 break
- 15 Oct, 01:20118 lines3 breaks
- 15 Oct, 01:10122 lines2 breaks
- 15 Oct, 01:00130 lines2 breaks
- 15 Oct, 00:50129 lines4 breaks
- 15 Oct, 00:40120 lines2 breaks
- 15 Oct, 00:30137 lines3 breaks
- 15 Oct, 00:20123 lines7 breaks
- 15 Oct, 00:10109 lines2 breaks
- 15 Oct, 00:00117 lines4 breaks
- 14 Oct, 23:50126 lines5 breaks
- 14 Oct, 23:40154 lines1 break
15 Oct, 00:20
Gross
€3,061.00
PSP fee
€46.99
Net to the bank
€3,014.01
Settlement journal
#5323
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13cef-5715-7427-a4be-bf91a20abe46 is already settled by stl_EUR_2986706 line 24
- duplicate linethe file lists it twicecapture:01a13cf2-2081-7bd2-a25c-563bb95d3834 is already settled by stl_EUR_2986706 line 58
- fee differencethe fee is not the contract feethe fee is 24, the contract says 19
- fee differencethe fee is not the contract feethe fee is 23, the contract says 19
- fee differencethe fee is not the contract feethe fee is 29, the contract says 26
- fee differencethe fee is not the contract feethe fee is 2, the contract says 0
- missing linein the books, not in the filecapture:01a13cf6-76be-7fe0-819e-4b3be240ea0d is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 3 | capture | 01a13cee-1cf4-70e2-8c46-4353972e36ee | €9.00 | €0.24 | fee difference |
| 25 | capture | 01a13cef-57ae-79b3-8a10-3f0f7ad39ef8 | €24.00 | €0.37 | duplicate line |
| 59 | capture | 01a13cf2-20b3-7778-96a5-d4a8907ca7f8 | €35.00 | €0.50 | duplicate line |
| 62 | capture | 01a13cf2-68e3-751f-a2e7-d0a13c9faf65 | €9.00 | €0.23 | fee difference |
| 93 | capture | 01a13cf5-4eb4-7071-b7b7-08af303f7ee5 | €15.00 | €0.29 | fee difference |
| 101 | refund | 01a13cf5-b7bf-7e1c-9b5c-3b49168c4a06 | -€15.00 | €0.02 | fee difference |
| 1 | capture | 01a13cec-5619-7e8b-b520-e7fd05207171 | €49.00 | €0.67 | matched |
| 2 | capture | 01a13ced-64d8-769f-84ae-fd085b9426b9 | €49.00 | €0.67 | matched |
| 4 | capture | 01a13cee-36fa-73ef-8e45-d3103c2a6b89 | €9.00 | €0.19 | matched |
| 5 | capture | 01a13cee-37e5-70fc-b0f2-8361abd786af | €49.00 | €0.67 | matched |
| 6 | capture | 01a13cee-42b3-7e1f-8340-cb01a515fde6 | €49.00 | €0.67 | matched |
| 7 | capture | 01a13cee-61fe-7ded-8581-7c33ba2581a7 | €24.00 | €0.37 | matched |
| 8 | capture | 01a13cee-708d-7f03-b99d-ef770ba3335d | €15.00 | €0.26 | matched |
| 9 | capture | 01a13cee-7221-73c4-8595-6d4191d15216 | €9.00 | €0.19 | matched |
| 10 | capture | 01a13cee-8701-70cd-8cba-a9e0f4590e02 | €9.00 | €0.19 | matched |
| 11 | capture | 01a13cee-8b5b-766e-b2c8-eec9e85b23b4 | €24.00 | €0.37 | matched |
| 12 | capture | 01a13cee-8e10-75a1-98a0-0551e721b400 | €35.00 | €0.50 | matched |
| 13 | capture | 01a13cee-a02f-7c41-bb95-b44d6fe0ab60 | €35.00 | €0.50 | matched |
| 14 | capture | 01a13cee-cf0a-74c4-9196-302ddd9544b2 | €49.00 | €0.67 | matched |
| 15 | capture | 01a13cee-d158-7352-9b1e-71c22dd792fc | €9.00 | €0.19 | matched |
| 16 | capture | 01a13cee-f294-74a7-b7c9-39fc988c91b0 | €15.00 | €0.26 | matched |
| 17 | capture | 01a13cef-0326-7516-8519-d4b194d4c69f | €9.00 | €0.19 | matched |
| 18 | capture | 01a13cef-1403-74bb-89ff-97035e247f69 | €49.00 | €0.67 | matched |
| 19 | capture | 01a13cef-1662-7cf0-9039-6e472cbb20a2 | €15.00 | €0.26 | matched |
| 20 | capture | 01a13cef-1d53-7efd-acec-1b480e6d1a16 | €15.00 | €0.26 | matched |
| 21 | capture | 01a13cef-211c-7fd3-91c7-51b7b985c4d7 | €9.00 | €0.19 | matched |
| 22 | capture | 01a13cef-416a-7691-95d2-5df895439875 | €9.00 | €0.19 | matched |
| 23 | capture | 01a13cef-5452-76aa-bb69-1ff921289dc1 | €35.00 | €0.50 | matched |
| 24 | capture | 01a13cef-57ae-79b3-8a10-3f0f7ad39ef8 | €24.00 | €0.37 | matched |
| 26 | capture | 01a13cef-57e2-78e3-8abd-e97c469f1beb | €24.00 | €0.37 | matched |
| 27 | capture | 01a13cef-627a-78ed-9ac6-8791075c084e | €24.00 | €0.37 | matched |
| 28 | capture | 01a13cef-796f-7f04-83c0-2b98c77470e6 | €49.00 | €0.67 | matched |
| 29 | capture | 01a13cef-7d06-7d1a-991c-9946d9b524f8 | €49.00 | €0.67 | matched |
| 30 | capture | 01a13cef-84f9-713d-b88f-5e9216ac3999 | €35.00 | €0.50 | matched |
| 31 | capture | 01a13cef-9d0d-7340-b580-a77b092d0feb | €49.00 | €0.67 | matched |
| 32 | capture | 01a13cef-c088-748f-b769-db134f0890d3 | €35.00 | €0.50 | matched |
| 33 | capture | 01a13cef-f7bd-7fff-98a6-8c83e9cba645 | €15.00 | €0.26 | matched |
| 34 | capture | 01a13cf0-0efb-77d9-8b31-23903d563886 | €24.00 | €0.37 | matched |
| 35 | capture | 01a13cf0-1e64-737a-9322-322d71c4f419 | €9.00 | €0.19 | matched |
| 36 | capture | 01a13cf0-3158-7cc9-a50d-bfccdedebf8e | €24.00 | €0.37 | matched |
| 37 | capture | 01a13cf0-57d3-792e-8070-e3c1c88a74c1 | €49.00 | €0.67 | matched |
| 38 | capture | 01a13cf0-780e-74cb-afb1-1115ddba1a99 | €24.00 | €0.37 | matched |
| 39 | capture | 01a13cf0-81a2-7786-aa8f-0d49e40b9cba | €15.00 | €0.26 | matched |
| 40 | capture | 01a13cf0-82c4-7142-a3c4-720989ab7a5b | €9.00 | €0.19 | matched |
| 41 | refund | 01a13cf0-8af3-7526-a8e9-d91c7cdbcbb3 | -€3.00 | €0.00 | matched |
| 42 | capture | 01a13cf0-9175-7b90-9047-a6e9989e1887 | €9.00 | €0.19 | matched |
| 43 | capture | 01a13cf0-a0fa-715e-897e-103aabec0fb3 | €15.00 | €0.26 | matched |
| 44 | capture | 01a13cf0-db5d-76c9-bf26-d66fc8ee1806 | €15.00 | €0.26 | matched |
| 45 | capture | 01a13cf0-e51f-7c00-98dd-ec2c124dabb4 | €9.00 | €0.19 | matched |
| 46 | capture | 01a13cf0-fa4a-701c-b106-f41bc1158aa5 | €15.00 | €0.26 | matched |
| 47 | capture | 01a13cf1-0e82-7717-9443-b113eaeabd72 | €49.00 | €0.67 | matched |
| 48 | capture | 01a13cf1-3cef-709f-bff2-af70a259d754 | €9.00 | €0.19 | matched |
| 49 | capture | 01a13cf1-408f-7aea-873f-889f496c252a | €15.00 | €0.26 | matched |
| 50 | capture | 01a13cf1-4299-769f-b3b3-bbd291accca5 | €35.00 | €0.50 | matched |
| 51 | capture | 01a13cf1-4432-7487-a111-5ff13c5a6bc4 | €9.00 | €0.19 | matched |
| 52 | capture | 01a13cf1-543b-7f49-861d-94631b376517 | €9.00 | €0.19 | matched |
| 53 | refund | 01a13cf1-69cc-700e-a01c-9bff8329a14a | -€8.00 | €0.00 | matched |
| 54 | capture | 01a13cf1-a7ff-7f41-8369-0537452aa91d | €9.00 | €0.19 | matched |
| 55 | capture | 01a13cf1-c381-7f60-8848-882651ecc394 | €35.00 | €0.50 | matched |
| 56 | capture | 01a13cf1-e4e5-7f17-81f1-5b9c0e2ee25c | €49.00 | €0.67 | matched |
| 57 | capture | 01a13cf2-1a2c-7ffc-883d-a5ccd618f52d | €15.00 | €0.26 | matched |
| 58 | capture | 01a13cf2-20b3-7778-96a5-d4a8907ca7f8 | €35.00 | €0.50 | matched |
| 60 | capture | 01a13cf2-32e4-70f5-bed1-5a0d7a0c72d2 | €24.00 | €0.37 | matched |
| 61 | capture | 01a13cf2-4483-7028-bac6-e82e500d489e | €49.00 | €0.67 | matched |
| 63 | capture | 01a13cf2-87ec-7f5f-a684-3dfae5bf03df | €49.00 | €0.67 | matched |
| 64 | capture | 01a13cf2-9ab7-7144-8336-6ea61b5510d0 | €15.00 | €0.26 | matched |
| 65 | capture | 01a13cf2-b5e5-7abb-b56b-d86ed2761288 | €49.00 | €0.67 | matched |
| 66 | capture | 01a13cf2-cee9-7086-854f-594343355229 | €9.00 | €0.19 | matched |
| 67 | capture | 01a13cf2-e6da-7275-9705-67cb9c9d7074 | €49.00 | €0.67 | matched |
| 68 | capture | 01a13cf2-e70f-7816-8209-62ffeb91706e | €9.00 | €0.19 | matched |
| 69 | capture | 01a13cf3-0768-7b02-b964-b3b34c0e43d1 | €24.00 | €0.37 | matched |
| 70 | capture | 01a13cf3-0a4f-70ad-bc2f-3ed80025f5b2 | €35.00 | €0.50 | matched |
| 71 | capture | 01a13cf3-24a9-747c-ae56-9c35f950c335 | €24.00 | €0.37 | matched |
| 72 | capture | 01a13cf3-3312-79a1-a3aa-e88afc8b94b0 | €24.00 | €0.37 | matched |
| 73 | capture | 01a13cf3-39ab-70e4-9ec1-343a52f43084 | €15.00 | €0.26 | matched |
| 74 | capture | 01a13cf3-3b00-7ce9-86dd-660eabd8433a | €35.00 | €0.50 | matched |
| 75 | capture | 01a13cf3-6183-7bf6-8c4f-69bef4840d99 | €49.00 | €0.67 | matched |
| 76 | capture | 01a13cf3-b8cf-70f0-906b-88192e0a9b47 | €15.00 | €0.26 | matched |
| 77 | capture | 01a13cf3-c681-72bb-ad30-b27b42a15e72 | €49.00 | €0.67 | matched |
| 78 | capture | 01a13cf3-c675-74cb-9bd2-6cb9a3797463 | €24.00 | €0.37 | matched |
| 79 | capture | 01a13cf3-ee50-739f-8019-cbd04a1dc177 | €49.00 | €0.67 | matched |
| 80 | capture | 01a13cf4-2ac1-7178-bb5e-c27a2bdb3187 | €35.00 | €0.50 | matched |
| 81 | capture | 01a13cf4-4860-72dd-9799-12ba4116f67e | €35.00 | €0.50 | matched |
| 82 | capture | 01a13cf4-56dd-7ee1-be92-229ad7857402 | €24.00 | €0.37 | matched |
| 83 | capture | 01a13cf4-9a94-7592-a37a-e210f6667400 | €35.00 | €0.50 | matched |
| 84 | capture | 01a13cf4-cf13-75ec-876c-18cc1a39dd68 | €9.00 | €0.19 | matched |
| 85 | capture | 01a13cf4-d722-739f-a740-ce6f9c5d0f9a | €35.00 | €0.50 | matched |
| 86 | capture | 01a13cf4-e34e-74f4-aa7e-e919d57db014 | €35.00 | €0.50 | matched |
| 87 | capture | 01a13cf4-d0df-7985-842f-33a5d2bc10ed | €15.00 | €0.26 | matched |
| 88 | capture | 01a13cf5-0a87-713d-9efc-6a64918822e9 | €9.00 | €0.19 | matched |
| 89 | capture | 01a13cf5-11c0-7fb8-8bd3-fe6c1f9ca19f | €49.00 | €0.67 | matched |
| 90 | capture | 01a13cf5-38a8-7402-b6d0-f468bd8972d7 | €24.00 | €0.37 | matched |
| 91 | capture | 01a13cf5-3b24-71eb-85a3-b1b715a9ca5c | €24.00 | €0.37 | matched |
| 92 | capture | 01a13cf5-431b-74e8-9a09-e4d3b7310935 | €15.00 | €0.26 | matched |
| 94 | capture | 01a13cf5-5307-7695-a364-8610ed7c532d | €15.00 | €0.26 | matched |
| 95 | capture | 01a13cf5-85f2-7f2c-ab4c-68cc1a6edf66 | €35.00 | €0.50 | matched |
| 96 | capture | 01a13cf5-8663-7431-8d13-3db1f0d57e49 | €24.00 | €0.37 | matched |
| 97 | capture | 01a13cf5-8977-7e7a-928f-46f88bf2a978 | €49.00 | €0.67 | matched |
| 98 | capture | 01a13cf5-8c93-7610-bb91-2e7147707f5b | €35.00 | €0.50 | matched |
| 99 | capture | 01a13cf5-8f59-7443-a337-bac5aae92214 | €49.00 | €0.67 | matched |
| 100 | capture | 01a13cf5-a6d4-77fc-9062-13a8e17dbf8a | €15.00 | €0.26 | matched |
| 102 | capture | 01a13cf5-c298-72be-9c7e-c57ae36f5850 | €9.00 | €0.19 | matched |
| 103 | capture | 01a13cf5-e185-7c21-9079-9a74183de904 | €49.00 | €0.67 | matched |
| 104 | capture | 01a13cf5-f456-7781-82a0-ca1c7c476cc0 | €49.00 | €0.67 | matched |
| 105 | capture | 01a13cf6-16d4-73dc-a216-f9e7c3b1c7aa | €9.00 | €0.19 | matched |
| 106 | capture | 01a13cf6-2a15-7691-952d-3267f7ecd249 | €9.00 | €0.19 | matched |
| 107 | capture | 01a13cf6-3376-73ec-a0f5-8e910122ff30 | €35.00 | €0.50 | matched |
| 108 | capture | 01a13cf6-343c-7be8-9eae-1eb101673d0c | €49.00 | €0.67 | matched |
| 109 | capture | 01a13cf6-66e9-7690-b1a9-7194c04de404 | €15.00 | €0.26 | matched |
| 110 | capture | 01a13cf6-6e6e-7e12-b33c-626a88deb99d | €24.00 | €0.37 | matched |
| 111 | refund | 01a13cf6-7a8f-7b4e-8690-8d9cd872b170 | -€4.00 | €0.00 | matched |
| 112 | capture | 01a13cf6-7e76-7c4a-b3f9-4f742908968e | €9.00 | €0.19 | matched |
| 113 | capture | 01a13cf6-a483-70af-bda6-86369ec9c800 | €15.00 | €0.26 | matched |
| 114 | capture | 01a13cf6-ae91-7c2d-a619-d0bc6c33dfe4 | €15.00 | €0.26 | matched |
| 115 | capture | 01a13cf6-bda8-7de0-8075-e24bfdd3996a | €49.00 | €0.67 | matched |
| 116 | capture | 01a13cf6-c83b-757a-9628-d56bee339727 | €9.00 | €0.19 | matched |
| 117 | capture | 01a13cf6-caf4-7f06-ad85-b30801f2f7a8 | €15.00 | €0.26 | matched |
| 118 | capture | 01a13cf6-cd2a-7745-aaad-4d55f0df8763 | €9.00 | €0.19 | matched |
| 119 | refund | 01a13cf6-de44-79b8-af9f-2e3d8e4afc7e | -€14.00 | €0.00 | matched |
| 120 | capture | 01a13cf7-0422-76b8-8100-8d950b8ff5b3 | €49.00 | €0.67 | matched |
| 121 | capture | 01a13cf7-0bef-79ca-9a73-1c616b3c6cfe | €9.00 | €0.19 | matched |
| 122 | capture | 01a13cf7-1823-70fc-b892-889b147d4afd | €49.00 | €0.67 | matched |
| 123 | capture | 01a13cf7-26aa-7003-808c-4b1bfe843622 | €15.00 | €0.26 | matched |