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
- 25 Oct, 09:30137 lines3 breaks
- 25 Oct, 09:20124 lines5 breaks
- 25 Oct, 09:10128 lines3 breaks
- 25 Oct, 09:00135 lines5 breaks
- 25 Oct, 08:50135 lines6 breaks
- 25 Oct, 08:40126 lines3 breaks
- 25 Oct, 08:30128 lines3 breaks
- 25 Oct, 08:20133 lines2 breaks
- 25 Oct, 08:10110 lines1 break
- 25 Oct, 08:00153 lines4 breaks
- 25 Oct, 07:50141 lines4 breaks
- 25 Oct, 07:40129 lines3 breaks
- 25 Oct, 07:30115 lines3 breaks
- 25 Oct, 07:20123 lines4 breaks
25 Oct, 08:40
Gross
€2,918.00
PSP fee
€46.34
Net to the bank
€2,871.66
Settlement journal
#193869
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1723c-9008-7d0a-877a-15e1ef951f13 is already settled by stl_EUR_2988196 line 79
- fee differencethe fee is not the contract feethe fee is 22, the contract says 19
- missing linein the books, not in the filecapture:01a17237-ef8e-75b0-832a-77a1a6bf86ae is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 26 | capture | 01a17239-034f-766c-8f99-dc2e2caceac0 | €9.00 | €0.22 | fee difference |
| 80 | capture | 01a1723c-903d-7315-a39a-cbbe2021da25 | €9.00 | €0.19 | duplicate line |
| 1 | refund | 01a1722e-8b0b-7ff7-ae0c-decdf71b150e | -€28.00 | €0.00 | matched |
| 2 | capture | 01a1722f-8df8-7d86-8a46-d385af627c97 | €24.00 | €0.37 | matched |
| 3 | capture | 01a17233-1d40-70ae-8528-a5be4dd658ff | €15.00 | €0.26 | matched |
| 4 | capture | 01a17234-64d9-7a54-96b6-a662eed21179 | €35.00 | €0.50 | matched |
| 5 | capture | 01a17237-86fd-7033-bf72-d88ef4cb6dfe | €24.00 | €0.37 | matched |
| 6 | capture | 01a17237-98bb-7a8d-a549-b6cd13317449 | €35.00 | €0.50 | matched |
| 7 | capture | 01a17237-9e1c-7bda-9c0f-809e6caa1f4d | €35.00 | €0.50 | matched |
| 8 | capture | 01a17238-35ca-74df-a9d7-c7870b5ad633 | €24.00 | €0.37 | matched |
| 9 | capture | 01a17238-3f17-7793-9034-e0544b1aa251 | €35.00 | €0.50 | matched |
| 10 | capture | 01a17238-40b6-78eb-9d09-7043d3779ead | €24.00 | €0.37 | matched |
| 11 | capture | 01a17238-40f3-7e52-9745-015212ebe204 | €24.00 | €0.37 | matched |
| 12 | capture | 01a17238-446b-716e-b0ce-95468dc9d9ec | €24.00 | €0.37 | matched |
| 13 | capture | 01a17238-4fd4-785e-b2c3-f65b83ffaf32 | €9.00 | €0.19 | matched |
| 14 | capture | 01a17238-52c3-7c6c-a525-afdf61f83bae | €24.00 | €0.37 | matched |
| 15 | capture | 01a17238-53d6-7405-ac60-7b94c740ab59 | €35.00 | €0.50 | matched |
| 16 | capture | 01a17238-5c2c-7939-a9f2-b0c799c998dd | €15.00 | €0.26 | matched |
| 17 | capture | 01a17238-7311-7589-94dc-5010f45b31be | €9.00 | €0.19 | matched |
| 18 | capture | 01a17238-8aed-7560-bc21-04ff892612a5 | €35.00 | €0.50 | matched |
| 19 | capture | 01a17238-8cdb-76d1-82de-cfe26a861ab6 | €9.00 | €0.19 | matched |
| 20 | capture | 01a17238-8db7-72ac-8193-86d34aca646f | €49.00 | €0.67 | matched |
| 21 | capture | 01a17238-a495-70cb-82e2-5a8c6babfcb8 | €35.00 | €0.50 | matched |
| 22 | capture | 01a17238-af9f-75f1-811f-31af8974733b | €15.00 | €0.26 | matched |
| 23 | capture | 01a17238-e3a4-7a1b-90bb-6328f8113cf5 | €9.00 | €0.19 | matched |
| 24 | capture | 01a17238-f9f8-7f12-bd3a-e00c6273761c | €49.00 | €0.67 | matched |
| 25 | refund | 01a17239-0282-784f-91dc-51c2fc48c8f8 | -€10.00 | €0.00 | matched |
| 27 | capture | 01a17239-04b3-740a-bdf7-69e2b1c5ef2b | €35.00 | €0.50 | matched |
| 28 | capture | 01a17239-0889-79bc-8ef8-186936596e3c | €15.00 | €0.26 | matched |
| 29 | capture | 01a17239-099f-7124-838c-ac1b4e830cc9 | €49.00 | €0.67 | matched |
| 30 | capture | 01a17239-19b6-73ea-914c-4dcf0e652705 | €24.00 | €0.37 | matched |
| 31 | capture | 01a17239-1a5b-704f-b6b4-8b1d033fd279 | €49.00 | €0.67 | matched |
| 32 | capture | 01a17239-214b-7588-829c-ebdf43049607 | €15.00 | €0.26 | matched |
| 33 | capture | 01a17239-2f01-780e-9615-9dfbb76d64fa | €15.00 | €0.26 | matched |
| 34 | capture | 01a17239-3438-7dcd-8f9d-3f8aa25c9684 | €9.00 | €0.19 | matched |
| 35 | capture | 01a17239-3c80-78da-a715-b6713366e9ea | €49.00 | €0.67 | matched |
| 36 | capture | 01a17239-4240-73cc-9bb8-a9cbf513eb12 | €15.00 | €0.26 | matched |
| 37 | capture | 01a17239-59f8-74e4-917a-411f07d2baf4 | €24.00 | €0.37 | matched |
| 38 | refund | 01a17239-7b2b-7757-b33c-dfa4e62184ae | -€12.00 | €0.00 | matched |
| 39 | capture | 01a17239-84a8-717a-ac98-db396f3bdefd | €49.00 | €0.67 | matched |
| 40 | capture | 01a17239-8b3d-73d7-8990-a1d0cfe0472f | €49.00 | €0.67 | matched |
| 41 | capture | 01a17239-8cc8-70b6-8c26-d477d9e1f945 | €49.00 | €0.67 | matched |
| 42 | capture | 01a17239-c22c-7f1a-aa9a-cd9948f8f135 | €49.00 | €0.67 | matched |
| 43 | capture | 01a17239-d64f-773a-8493-d32bed51853b | €15.00 | €0.26 | matched |
| 44 | capture | 01a17239-f6bc-7eb1-b8c1-d94693150cab | €49.00 | €0.67 | matched |
| 45 | capture | 01a17239-fbdf-7863-825d-31cda7b516cf | €24.00 | €0.37 | matched |
| 46 | capture | 01a1723a-1a38-7e64-8fba-b48bf4d4ff60 | €15.00 | €0.26 | matched |
| 47 | capture | 01a1723a-25d8-733c-878e-22ffa4f6c014 | €49.00 | €0.67 | matched |
| 48 | capture | 01a1723a-26e9-7320-bb62-0390bfad5bc8 | €9.00 | €0.19 | matched |
| 49 | capture | 01a1723a-36e1-72cb-acc1-c67e9b8c1fd7 | €24.00 | €0.37 | matched |
| 50 | capture | 01a1723a-4d19-72b7-9f93-d6f8fbb84484 | €35.00 | €0.50 | matched |
| 51 | capture | 01a1723a-586c-745a-8e6c-2be99a7d1993 | €24.00 | €0.37 | matched |
| 52 | capture | 01a1723a-59c6-7ec5-80a8-8d134678ca70 | €24.00 | €0.37 | matched |
| 53 | capture | 01a1723a-7adc-7f67-a220-35857abd0e18 | €15.00 | €0.26 | matched |
| 54 | capture | 01a1723a-859b-7697-9a16-9110f1ed45bd | €9.00 | €0.19 | matched |
| 55 | capture | 01a1723a-b7c2-7fcc-b9e9-17685c172238 | €9.00 | €0.19 | matched |
| 56 | capture | 01a1723a-be43-7486-9016-44a871e5f264 | €9.00 | €0.19 | matched |
| 57 | capture | 01a1723a-bfe4-700d-ad05-f9d7f49c720d | €35.00 | €0.50 | matched |
| 58 | capture | 01a1723a-e819-7b52-b85f-be736cf88e65 | €24.00 | €0.37 | matched |
| 59 | capture | 01a1723a-f80b-792f-ac25-eebc48204c37 | €9.00 | €0.19 | matched |
| 60 | capture | 01a1723b-1049-7076-93e8-117dfb5ab16e | €24.00 | €0.37 | matched |
| 61 | capture | 01a1723b-2620-7999-b2e3-20752a5b0b96 | €24.00 | €0.37 | matched |
| 62 | capture | 01a1723b-3fed-7274-b085-bfe36bcbd125 | €49.00 | €0.67 | matched |
| 63 | capture | 01a1723b-485b-70a6-ad04-db0d39027569 | €15.00 | €0.26 | matched |
| 64 | capture | 01a1723b-6272-7db0-a5a1-ea59c80704ff | €9.00 | €0.19 | matched |
| 65 | capture | 01a1723b-b53c-704f-83ee-3ca8d6a1bda9 | €49.00 | €0.67 | matched |
| 66 | capture | 01a1723b-c404-7d8c-a942-c27fd06c8864 | €9.00 | €0.19 | matched |
| 67 | refund | 01a1723b-fa85-741f-b181-2c1927e2f4af | -€47.00 | €0.00 | matched |
| 68 | capture | 01a1723c-02fa-768c-9874-626a6db8f07e | €9.00 | €0.19 | matched |
| 69 | capture | 01a1723c-20cc-70e9-8a31-99780bd30460 | €49.00 | €0.67 | matched |
| 70 | capture | 01a1723c-26ce-751c-9f09-fef8e35d2132 | €24.00 | €0.37 | matched |
| 71 | capture | 01a1723c-3d6b-70cc-8413-5d7d41f87a67 | €9.00 | €0.19 | matched |
| 72 | capture | 01a1723c-4371-7f01-8b56-b4ef341e3f7c | €49.00 | €0.67 | matched |
| 73 | capture | 01a1723c-4d74-7c6c-848e-4184ad95d46a | €9.00 | €0.19 | matched |
| 74 | capture | 01a1723c-5785-75a4-a854-eee459328367 | €15.00 | €0.26 | matched |
| 75 | capture | 01a1723c-5c6a-7804-a6c2-b25f8f223c87 | €49.00 | €0.67 | matched |
| 76 | capture | 01a1723c-5ec9-76fe-8dd5-a991a27f8007 | €9.00 | €0.19 | matched |
| 77 | capture | 01a1723c-685d-7d6e-87cd-f399506c65bb | €24.00 | €0.37 | matched |
| 78 | capture | 01a1723c-801b-732f-b4e5-d478a55c45ab | €49.00 | €0.67 | matched |
| 79 | capture | 01a1723c-903d-7315-a39a-cbbe2021da25 | €9.00 | €0.19 | matched |
| 81 | capture | 01a1723c-a5f9-798b-be28-4ea4965b498e | €49.00 | €0.67 | matched |
| 82 | refund | 01a1723c-adf1-73cf-b7cd-5b0999f4b1eb | -€8.00 | €0.00 | matched |
| 83 | capture | 01a1723c-c298-7589-a001-f2ff7febb29b | €24.00 | €0.37 | matched |
| 84 | capture | 01a1723c-f3a1-79e6-b432-c0b4629a0307 | €15.00 | €0.26 | matched |
| 85 | capture | 01a1723d-289f-7333-8b22-60df7368ec90 | €24.00 | €0.37 | matched |
| 86 | capture | 01a1723d-2bd8-770c-bd0a-c0e15ddb1fb8 | €9.00 | €0.19 | matched |
| 87 | capture | 01a1723d-3286-702c-b3d3-bfc6432e87e2 | €9.00 | €0.19 | matched |
| 88 | refund | 01a1723d-826d-76b3-a96f-e6aba9b47675 | -€9.00 | €0.00 | matched |
| 89 | capture | 01a1723d-972f-78ec-976b-71290b87656a | €15.00 | €0.26 | matched |
| 90 | capture | 01a1723d-dcde-749d-ad01-6b4417686a1f | €24.00 | €0.37 | matched |
| 91 | capture | 01a1723d-e632-73a1-b31f-0e2942879d46 | €24.00 | €0.37 | matched |
| 92 | capture | 01a1723d-ebd6-7b59-b60b-416c50ab167e | €9.00 | €0.19 | matched |
| 93 | capture | 01a1723d-f7fa-70a8-a7c5-32a667a76a75 | €49.00 | €0.67 | matched |
| 94 | capture | 01a1723d-ff99-7299-a0fc-ff8530c92182 | €15.00 | €0.26 | matched |
| 95 | capture | 01a1723e-26e8-7084-b1ef-d71eb6b5d202 | €15.00 | €0.26 | matched |
| 96 | capture | 01a1723e-3e57-7236-ae52-7ae8e7c30a56 | €15.00 | €0.26 | matched |
| 97 | refund | 01a1723e-4ba6-7437-8204-6cc67b291eec | -€20.00 | €0.00 | matched |
| 98 | capture | 01a1723e-5841-7198-8a79-78ca492db1ed | €49.00 | €0.67 | matched |
| 99 | capture | 01a1723e-6cc8-75ad-b739-eca57b7b7a38 | €9.00 | €0.19 | matched |
| 100 | capture | 01a1723e-8243-74a8-939b-5618e047a772 | €24.00 | €0.37 | matched |
| 101 | capture | 01a1723e-8c6f-7e4b-a1ca-87c8c327962c | €15.00 | €0.26 | matched |
| 102 | capture | 01a1723e-b05f-78de-8d64-5d3766c9439b | €35.00 | €0.50 | matched |
| 103 | capture | 01a1723e-da1e-7ef7-9fe6-eb5ab13e0c8d | €35.00 | €0.50 | matched |
| 104 | capture | 01a1723e-f0bc-7eb7-aec0-a189509ad36e | €9.00 | €0.19 | matched |
| 105 | capture | 01a1723f-01fe-7d94-aca7-a2f34499139d | €9.00 | €0.19 | matched |
| 106 | capture | 01a1723f-0620-7a0a-a34d-d4e90604580d | €15.00 | €0.26 | matched |
| 107 | capture | 01a1723f-1405-7c9a-aa03-92127191a881 | €35.00 | €0.50 | matched |
| 108 | capture | 01a1723f-1cbd-7ebe-8787-449c2947dac5 | €49.00 | €0.67 | matched |
| 109 | capture | 01a1723f-25c5-77e0-bef1-08ebe73a24df | €9.00 | €0.19 | matched |
| 110 | capture | 01a1723f-2d9f-738c-8bb6-573f02a73b95 | €24.00 | €0.37 | matched |
| 111 | capture | 01a1723f-5d0e-704a-aa6b-4abe1b3826d6 | €49.00 | €0.67 | matched |
| 112 | capture | 01a1723f-8b8e-7f9f-8364-1856b3e03a1a | €49.00 | €0.67 | matched |
| 113 | capture | 01a1723f-9a36-72bd-ac99-73f00ac6dc60 | €49.00 | €0.67 | matched |
| 114 | capture | 01a1723f-cdc5-73a6-bdb7-cc4ca16016a5 | €35.00 | €0.50 | matched |
| 115 | capture | 01a1723f-fa6b-71d5-bc7c-8fd5a88fe8cd | €35.00 | €0.50 | matched |
| 116 | capture | 01a1723f-fae5-78ba-806f-824cdcba7c9e | €49.00 | €0.67 | matched |
| 117 | capture | 01a17240-0564-7401-84ec-c230d72fb4f4 | €35.00 | €0.50 | matched |
| 118 | capture | 01a17240-057c-7a80-a9f7-3b5d91c32140 | €9.00 | €0.19 | matched |
| 119 | capture | 01a17240-157a-7cfd-937c-4d988217aba2 | €9.00 | €0.19 | matched |
| 120 | capture | 01a17240-3b23-7cdb-a707-788150818afd | €15.00 | €0.26 | matched |
| 121 | capture | 01a17240-4195-7210-a102-39ff1e725592 | €9.00 | €0.19 | matched |
| 122 | capture | 01a17240-46b8-7bbd-8ef7-321d25362742 | €9.00 | €0.19 | matched |
| 123 | capture | 01a17240-524f-78bd-936b-896bcc3eaef3 | €24.00 | €0.37 | matched |
| 124 | capture | 01a17240-6df4-70dc-8c9d-b17fa532dcda | €24.00 | €0.37 | matched |
| 125 | capture | 01a17240-8145-7793-9526-b04b8122ee51 | €49.00 | €0.67 | matched |
| 126 | capture | 01a17240-8464-74bf-8722-e72a625b5a3f | €24.00 | €0.37 | matched |