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, 23:40109 lines2 breaks
- 25 Oct, 23:30114 lines1 break
- 25 Oct, 23:20116 lines5 breaks
- 25 Oct, 23:10132 lines7 breaks
- 25 Oct, 23:00121 lines2 breaks
- 25 Oct, 22:50131 lines4 breaks
- 25 Oct, 22:40126 lines2 breaks
- 25 Oct, 22:30127 lines2 breaks
- 25 Oct, 22:20128 lines1 break
- 25 Oct, 22:10122 lines2 breaks
- 25 Oct, 22:00113 lines3 breaks
- 25 Oct, 21:50114 lines2 breaks
- 25 Oct, 21:40116 lines1 break
- 25 Oct, 21:30128 lines2 breaks
25 Oct, 22:40
Gross
€2,700.00
PSP fee
€43.44
Net to the bank
€2,656.56
Settlement journal
#204366
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1753a-3b37-7829-a3fa-dd070d994d1b is already settled by stl_EUR_2988280 line 22
- missing linein the books, not in the filecapture:01a1753f-fdc8-7f25-9a57-94a6eb825ced is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 23 | capture | 01a1753a-3b56-7759-a346-b6801c8cc3ed | €15.00 | €0.26 | duplicate line |
| 1 | capture | 01a17530-8a06-7999-9b93-a2fa297685bb | €35.00 | €0.50 | matched |
| 2 | capture | 01a17534-5b59-71ee-ab6e-c6d83cf7a857 | €9.00 | €0.19 | matched |
| 3 | capture | 01a17534-ee7e-732e-8a6c-1f17892f9392 | €35.00 | €0.50 | matched |
| 4 | capture | 01a17536-f7e7-7fc2-ae4f-4db70fd1e77a | €35.00 | €0.50 | matched |
| 5 | capture | 01a17538-887b-7599-b398-b1ca7acb3733 | €9.00 | €0.19 | matched |
| 6 | capture | 01a17538-c4d0-7308-a2a5-0381e489752f | €9.00 | €0.19 | matched |
| 7 | capture | 01a17538-f065-76ff-8f0e-52d182507c14 | €9.00 | €0.19 | matched |
| 8 | capture | 01a17538-f68c-7476-ab67-2efed10fb950 | €35.00 | €0.50 | matched |
| 9 | capture | 01a17538-f7c0-7c30-821e-2872f05d6d8f | €24.00 | €0.37 | matched |
| 10 | capture | 01a17538-ff0e-7c22-ab06-b5950a4b72cc | €9.00 | €0.19 | matched |
| 11 | capture | 01a17539-231a-7220-8cb5-6990747ce2d1 | €15.00 | €0.26 | matched |
| 12 | capture | 01a17539-7d5b-7996-b349-06a578f4d240 | €49.00 | €0.67 | matched |
| 13 | capture | 01a17539-86bd-7f66-90f6-5ad48475e2ab | €9.00 | €0.19 | matched |
| 14 | capture | 01a17539-9fff-7ecd-9be3-697eb168d7cf | €35.00 | €0.50 | matched |
| 15 | capture | 01a17539-af6c-7017-b466-e116d9f088a3 | €15.00 | €0.26 | matched |
| 16 | capture | 01a17539-bca6-7190-969c-3a07e3a456e1 | €35.00 | €0.50 | matched |
| 17 | capture | 01a17539-e52e-723e-a1c0-479b18154073 | €35.00 | €0.50 | matched |
| 18 | capture | 01a1753a-0134-7326-bb94-de0fb3486661 | €49.00 | €0.67 | matched |
| 19 | capture | 01a1753a-0d23-774b-818a-904544eeac18 | €9.00 | €0.19 | matched |
| 20 | capture | 01a1753a-2224-70d2-a2b4-d59da5be41ee | €9.00 | €0.19 | matched |
| 21 | capture | 01a1753a-2fb3-71de-a27d-5adf7b51bbe3 | €49.00 | €0.67 | matched |
| 22 | capture | 01a1753a-3b56-7759-a346-b6801c8cc3ed | €15.00 | €0.26 | matched |
| 24 | capture | 01a1753a-3c1f-72ad-80cb-26b32467f824 | €15.00 | €0.26 | matched |
| 25 | capture | 01a1753a-41c8-7538-b6c2-a64ff33f1ac1 | €15.00 | €0.26 | matched |
| 26 | capture | 01a1753a-4cb2-7832-9a34-ea2edb54c960 | €15.00 | €0.26 | matched |
| 27 | capture | 01a1753a-4d9f-794d-a72a-70ee2f756c8f | €35.00 | €0.50 | matched |
| 28 | capture | 01a1753a-5d4e-7505-bd20-b532c18f682d | €35.00 | €0.50 | matched |
| 29 | capture | 01a1753a-ba28-758e-89db-f250aa5e9085 | €9.00 | €0.19 | matched |
| 30 | capture | 01a1753a-c624-74e1-8caa-4e3a6367e2e0 | €15.00 | €0.26 | matched |
| 31 | capture | 01a1753a-ca95-7864-851c-060f472a92d8 | €15.00 | €0.26 | matched |
| 32 | capture | 01a1753a-d1b4-71f2-8bab-5cd0e448279c | €9.00 | €0.19 | matched |
| 33 | capture | 01a1753a-e3db-7739-8930-fce63a30c864 | €9.00 | €0.19 | matched |
| 34 | capture | 01a1753b-0b49-72d1-9be6-7fe13445baf2 | €9.00 | €0.19 | matched |
| 35 | capture | 01a1753b-1c09-7bf7-976b-9c21e4ee9082 | €24.00 | €0.37 | matched |
| 36 | capture | 01a1753b-33ed-7c11-a901-b664080916e9 | €9.00 | €0.19 | matched |
| 37 | capture | 01a1753b-5282-7a97-ada1-0ea923a341ba | €35.00 | €0.50 | matched |
| 38 | capture | 01a1753b-6a12-70ed-a890-59fb77117ea5 | €24.00 | €0.37 | matched |
| 39 | capture | 01a1753b-8318-7558-8ba9-240321a8c808 | €35.00 | €0.50 | matched |
| 40 | capture | 01a1753b-8520-7685-98c0-c87c91b814ea | €49.00 | €0.67 | matched |
| 41 | capture | 01a1753b-924f-7d80-a74e-b8f0d31cf7d8 | €15.00 | €0.26 | matched |
| 42 | refund | 01a1753b-a670-7da0-88f5-68dde731cfaa | -€12.00 | €0.00 | matched |
| 43 | capture | 01a1753b-ac4b-7c61-b462-f4d9e2027d30 | €15.00 | €0.26 | matched |
| 44 | capture | 01a1753b-ad0b-76b5-b8a1-ccfae20f82d4 | €9.00 | €0.19 | matched |
| 45 | capture | 01a1753b-bb69-726d-963c-009f73d97d60 | €9.00 | €0.19 | matched |
| 46 | capture | 01a1753b-bc24-7806-91c1-392bc8a0d202 | €15.00 | €0.26 | matched |
| 47 | capture | 01a1753b-f89d-7bf3-b417-33abfe9c4114 | €24.00 | €0.37 | matched |
| 48 | capture | 01a1753b-fe72-7ca0-a8ef-26481ccc3783 | €9.00 | €0.19 | matched |
| 49 | capture | 01a1753c-0464-7a7c-8921-2f7b9de07a6b | €9.00 | €0.19 | matched |
| 50 | capture | 01a1753c-11b9-7dfb-8bd6-175d559e9cf9 | €35.00 | €0.50 | matched |
| 51 | capture | 01a1753c-17a8-7fef-9ae4-42533c61b8b2 | €35.00 | €0.50 | matched |
| 52 | capture | 01a1753c-1bd8-70d1-acf7-25112d606c1c | €9.00 | €0.19 | matched |
| 53 | capture | 01a1753c-3e7d-7471-9622-7c79854f79d7 | €24.00 | €0.37 | matched |
| 54 | capture | 01a1753c-5cd5-7d21-b7a3-96fab3227c9b | €24.00 | €0.37 | matched |
| 55 | capture | 01a1753c-6535-7efb-a234-62560a55b7f1 | €15.00 | €0.26 | matched |
| 56 | refund | 01a1753c-6c45-755a-b0bb-d2b034cdfe3b | -€12.00 | €0.00 | matched |
| 57 | capture | 01a1753c-6e98-788a-bef0-c7fbf39f9989 | €35.00 | €0.50 | matched |
| 58 | capture | 01a1753c-683d-7eb9-8106-4fe1b7c11f82 | €35.00 | €0.50 | matched |
| 59 | capture | 01a1753c-8bda-774b-883b-6a84e3959c3c | €49.00 | €0.67 | matched |
| 60 | capture | 01a1753c-a2b9-7398-94b8-64b556ad9f1a | €15.00 | €0.26 | matched |
| 61 | capture | 01a1753c-ab64-716f-9a57-98acd07f113a | €49.00 | €0.67 | matched |
| 62 | capture | 01a1753c-b00c-7e85-bb49-c403bc1e3c4f | €49.00 | €0.67 | matched |
| 63 | refund | 01a1753c-b407-7374-849f-0cabfab095ec | -€12.00 | €0.00 | matched |
| 64 | refund | 01a1753c-c425-7252-ba6e-4631ddfba2ef | -€18.00 | €0.00 | matched |
| 65 | capture | 01a1753c-cb9c-76b6-9824-687bc7f69fed | €35.00 | €0.50 | matched |
| 66 | capture | 01a1753c-d5c1-76f0-b6a5-11920b1fa59c | €24.00 | €0.37 | matched |
| 67 | capture | 01a1753c-de18-76b0-8a76-3ad098306860 | €24.00 | €0.37 | matched |
| 68 | capture | 01a1753c-e73d-702f-be2e-a1bf35bb6fd6 | €9.00 | €0.19 | matched |
| 69 | capture | 01a1753c-fae6-7928-9790-45ed1f41aea4 | €24.00 | €0.37 | matched |
| 70 | capture | 01a1753d-1033-7484-81c4-38cc797c119f | €35.00 | €0.50 | matched |
| 71 | capture | 01a1753d-15d4-7a52-820b-20ade3712fd1 | €35.00 | €0.50 | matched |
| 72 | refund | 01a1753d-2e90-7e48-9a2c-3591757e2d2d | -€9.00 | €0.00 | matched |
| 73 | capture | 01a1753d-5e1e-7016-ae9b-92dd5087fe0f | €35.00 | €0.50 | matched |
| 74 | capture | 01a1753d-ab67-774b-b4fd-35224405be66 | €49.00 | €0.67 | matched |
| 75 | capture | 01a1753d-b57b-76e1-a991-fced172a2b59 | €24.00 | €0.37 | matched |
| 76 | capture | 01a1753d-f46e-7341-b291-f634053d2f9d | €24.00 | €0.37 | matched |
| 77 | capture | 01a1753e-0507-7514-aeff-cb3bb498c77b | €9.00 | €0.19 | matched |
| 78 | capture | 01a1753e-111f-7819-acad-adc684f3c6b9 | €9.00 | €0.19 | matched |
| 79 | capture | 01a1753e-12ea-7a7b-b2c5-1b9fac8427f5 | €9.00 | €0.19 | matched |
| 80 | capture | 01a1753e-157b-7de7-a37e-6f023172ad74 | €35.00 | €0.50 | matched |
| 81 | capture | 01a1753e-1a13-7711-b329-5ac564c2e256 | €24.00 | €0.37 | matched |
| 82 | capture | 01a1753e-3c7b-7d27-9794-581b8ef427c6 | €15.00 | €0.26 | matched |
| 83 | capture | 01a1753e-4da6-71ff-92b8-0594fd4021f1 | €9.00 | €0.19 | matched |
| 84 | capture | 01a1753e-4e64-793b-8a1b-6e29d014270f | €24.00 | €0.37 | matched |
| 85 | capture | 01a1753e-5fa3-7f30-8517-f302ef66c6e9 | €35.00 | €0.50 | matched |
| 86 | capture | 01a1753e-5ea3-71b2-b653-21c32b1311b5 | €15.00 | €0.26 | matched |
| 87 | capture | 01a1753e-6f7e-7856-b747-d7ef7a2cde91 | €49.00 | €0.67 | matched |
| 88 | capture | 01a1753e-7c68-736a-805b-ddaa1d13751f | €24.00 | €0.37 | matched |
| 89 | capture | 01a1753e-ba0b-7291-bb72-213ab4efd64f | €49.00 | €0.67 | matched |
| 90 | capture | 01a1753e-c939-732b-b051-64a01630eba4 | €9.00 | €0.19 | matched |
| 91 | capture | 01a1753e-fecc-7032-8701-3b8880d267c9 | €49.00 | €0.67 | matched |
| 92 | capture | 01a1753f-14aa-7f2c-923d-bd7574fe02de | €49.00 | €0.67 | matched |
| 93 | capture | 01a1753f-299a-70f6-b7cb-86e96f44cc17 | €24.00 | €0.37 | matched |
| 94 | capture | 01a1753f-2b35-761e-9f82-8fbca2e60f42 | €9.00 | €0.19 | matched |
| 95 | capture | 01a1753f-2f01-7a17-8f3d-8409160ca2ee | €49.00 | €0.67 | matched |
| 96 | capture | 01a1753f-6073-729a-b09a-afac11b52b5d | €15.00 | €0.26 | matched |
| 97 | capture | 01a1753f-869f-7071-920a-9c3141637db0 | €24.00 | €0.37 | matched |
| 98 | capture | 01a1753f-a481-7550-a967-590014adf60a | €9.00 | €0.19 | matched |
| 99 | refund | 01a1753f-bea5-7fe6-9fa6-617e595cef81 | -€14.00 | €0.00 | matched |
| 100 | capture | 01a1753f-c4d8-7f21-913b-b6ed7a66b4d7 | €35.00 | €0.50 | matched |
| 101 | capture | 01a1753f-c7d4-7874-bd5f-0bf9349b4377 | €9.00 | €0.19 | matched |
| 102 | capture | 01a1753f-ce0c-787b-9971-2fa8135c2348 | €49.00 | €0.67 | matched |
| 103 | capture | 01a1753f-d6db-7336-9066-783577010c21 | €49.00 | €0.67 | matched |
| 104 | refund | 01a1753f-ec50-7199-8c20-225c6130b474 | -€32.00 | €0.00 | matched |
| 105 | capture | 01a1753f-f07e-7d96-9c5c-0f7873dba1af | €15.00 | €0.26 | matched |
| 106 | refund | 01a1753f-f95a-7864-aa92-6878588da1bd | -€7.00 | €0.00 | matched |
| 107 | capture | 01a17540-0170-7d5f-9e38-651fea0ff149 | €35.00 | €0.50 | matched |
| 108 | capture | 01a17540-3036-714f-897e-fe4deff377f2 | €9.00 | €0.19 | matched |
| 109 | capture | 01a17540-3462-7995-9de8-7ae86cfeed4d | €9.00 | €0.19 | matched |
| 110 | capture | 01a17540-5615-78e5-85c4-29dce9c3370e | €35.00 | €0.50 | matched |
| 111 | capture | 01a17540-613e-7f64-9042-ce0fd6382b9d | €9.00 | €0.19 | matched |
| 112 | capture | 01a17540-6206-7d85-b451-908db666d98d | €15.00 | €0.26 | matched |
| 113 | capture | 01a17540-7e69-7235-9c33-11bc3fab9f84 | €15.00 | €0.26 | matched |
| 114 | refund | 01a17540-8ddc-7181-89a2-837364f5d206 | -€13.00 | €0.00 | matched |
| 115 | capture | 01a17540-9066-7cb9-a178-0a177712e3c2 | €15.00 | €0.26 | matched |
| 116 | capture | 01a17540-9bd6-7dd0-ab10-b0b8e7f1fcc9 | €15.00 | €0.26 | matched |
| 117 | capture | 01a17540-abda-7eef-8dd3-bb85249d2d2c | €15.00 | €0.26 | matched |
| 118 | capture | 01a17540-c8ee-746d-86b4-110f8a802890 | €24.00 | €0.37 | matched |
| 119 | capture | 01a17540-e29f-7524-a982-1ab9e1dd07b1 | €49.00 | €0.67 | matched |
| 120 | capture | 01a17541-14e9-770c-aaf0-07efa7458315 | €15.00 | €0.26 | matched |
| 121 | capture | 01a17541-1bb8-723d-a97a-1e5acf7d0686 | €35.00 | €0.50 | matched |
| 122 | capture | 01a17541-2fe3-72ce-aa74-ee82de1aad4f | €9.00 | €0.19 | matched |
| 123 | capture | 01a17541-781b-7bb2-92b9-84092efcc604 | €24.00 | €0.37 | matched |
| 124 | capture | 01a17541-8565-7531-af75-30e19c3a163d | €49.00 | €0.67 | matched |
| 125 | capture | 01a17541-8a9a-79bf-951a-aed9b02198cf | €15.00 | €0.26 | matched |
| 126 | capture | 01a17541-a07d-7148-a0f3-2b7b328cb2d6 | €35.00 | €0.50 | matched |