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
- 5 Nov, 13:10145 lines2 breaks
- 5 Nov, 13:00126 lines1 break
- 5 Nov, 12:50111 lines4 breaks
- 5 Nov, 12:40133 lines1 break
- 5 Nov, 12:30143 linesclean
- 5 Nov, 12:20138 lines1 break
- 5 Nov, 12:10132 lines2 breaks
- 5 Nov, 12:00122 lines3 breaks
- 5 Nov, 11:50114 lines2 breaks
- 5 Nov, 11:40102 linesclean
- 5 Nov, 11:30108 lines2 breaks
- 5 Nov, 11:20126 linesclean
- 5 Nov, 11:10112 lines6 breaks
- 5 Nov, 11:00113 lines2 breaks
5 Nov, 12:00
Gross
€2,992.00
PSP fee
€46.60
Net to the bank
€2,945.40
Settlement journal
#397195
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1ab99-99bd-7c97-9e90-1e60786ce420 is already settled by stl_EUR_2989800 line 76
- fee differencethe fee is not the contract feethe fee is 40, the contract says 37
- missing linein the books, not in the filecapture:01a1ab99-84e7-7885-8cb6-954167b8884b is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 77 | capture | 01a1ab99-99e8-79df-98e9-416b74c105dc | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a1ab94-8a5f-70d3-a122-c41790154bc5 | €9.00 | €0.19 | matched |
| 2 | capture | 01a1ab94-995b-7b36-8169-408f9e223b99 | €49.00 | €0.67 | matched |
| 3 | capture | 01a1ab94-f77a-773d-b1e2-a2f59a24f77f | €15.00 | €0.26 | matched |
| 4 | capture | 01a1ab95-0890-7f8d-bf4d-c51fbc6c0e1c | €15.00 | €0.26 | matched |
| 5 | capture | 01a1ab95-11d9-7612-aa95-2fe7c5674fc1 | €35.00 | €0.50 | matched |
| 6 | capture | 01a1ab95-1aac-7d0f-b20c-a3d386a3b5c0 | €24.00 | €0.37 | matched |
| 7 | capture | 01a1ab95-1e29-7dec-97a9-ccfcb3f9b695 | €35.00 | €0.50 | matched |
| 8 | capture | 01a1ab95-2868-7f7a-813d-0288e798146c | €49.00 | €0.67 | matched |
| 9 | capture | 01a1ab95-2b83-7d73-b124-170f5f7490a8 | €35.00 | €0.50 | matched |
| 10 | capture | 01a1ab95-3a4b-710c-9e8e-8005dc4659d7 | €24.00 | €0.37 | matched |
| 11 | capture | 01a1ab95-490a-71e8-844a-318d705e73fe | €9.00 | €0.19 | matched |
| 12 | capture | 01a1ab95-7848-7046-92e4-0da1a5a0adfb | €9.00 | €0.19 | matched |
| 13 | capture | 01a1ab95-ad40-746e-b6d1-5f336bead578 | €15.00 | €0.26 | matched |
| 14 | capture | 01a1ab95-c30a-70b1-823e-63e31280e18e | €15.00 | €0.26 | matched |
| 15 | capture | 01a1ab95-d24e-73a2-b4e5-cea449f36cb0 | €9.00 | €0.19 | matched |
| 16 | capture | 01a1ab95-e60a-75a4-a857-a7254f2084a7 | €35.00 | €0.50 | matched |
| 17 | capture | 01a1ab95-e6d3-7aab-88e7-73bf2e5ff150 | €9.00 | €0.19 | matched |
| 18 | capture | 01a1ab95-f037-7625-a8f0-6bbe7a33e673 | €35.00 | €0.50 | matched |
| 19 | capture | 01a1ab95-f8e3-772d-a9dd-88854dba5fe6 | €15.00 | €0.26 | matched |
| 20 | capture | 01a1ab96-03bf-7a75-a319-a036c517c2e4 | €15.00 | €0.26 | matched |
| 21 | capture | 01a1ab96-0c21-785f-bf1e-1da670b82119 | €35.00 | €0.50 | matched |
| 22 | capture | 01a1ab96-195c-70ac-9e3f-a42f49c8112c | €49.00 | €0.67 | matched |
| 23 | refund | 01a1ab96-1c46-74c9-a3c3-10c48e8386b5 | -€15.00 | €0.00 | matched |
| 24 | capture | 01a1ab96-2cfe-77a2-b1dd-1c2112514c46 | €15.00 | €0.26 | matched |
| 25 | capture | 01a1ab96-35ff-7843-afb6-00db4ac8ea80 | €35.00 | €0.50 | matched |
| 26 | capture | 01a1ab96-6b13-79ad-a6aa-8e4c4ab72dfa | €15.00 | €0.26 | matched |
| 27 | capture | 01a1ab96-7332-7777-a330-9e200429410d | €9.00 | €0.19 | matched |
| 28 | capture | 01a1ab96-73a0-79a8-9259-8e7075fd4629 | €24.00 | €0.37 | matched |
| 29 | capture | 01a1ab96-78c7-7ddb-96b5-018994d320d4 | €24.00 | €0.37 | matched |
| 30 | refund | 01a1ab96-7ac6-716e-8143-b5e384568556 | -€19.00 | €0.00 | matched |
| 31 | capture | 01a1ab96-9675-7ce8-8665-3c01aff5472f | €24.00 | €0.37 | matched |
| 32 | capture | 01a1ab96-d74d-7671-bd52-31dde53765c2 | €9.00 | €0.19 | matched |
| 33 | capture | 01a1ab96-da5c-72a3-b241-6973ad24b154 | €49.00 | €0.67 | matched |
| 34 | capture | 01a1ab96-da64-7d5e-8b8e-bc4f0d003054 | €24.00 | €0.37 | matched |
| 35 | capture | 01a1ab97-0402-761a-9c6f-06a378710004 | €24.00 | €0.37 | matched |
| 36 | capture | 01a1ab97-15db-7f5f-99cf-6630bcfc2e0e | €15.00 | €0.26 | matched |
| 37 | capture | 01a1ab97-22a7-74aa-84a3-cc7b126ca147 | €49.00 | €0.67 | matched |
| 38 | capture | 01a1ab97-2c4f-78da-be16-22ebf0a343d8 | €15.00 | €0.26 | matched |
| 39 | capture | 01a1ab97-3027-78f3-8609-da883a904874 | €35.00 | €0.50 | matched |
| 40 | capture | 01a1ab97-42fe-78c9-bde8-a6b373e31e45 | €15.00 | €0.26 | matched |
| 41 | capture | 01a1ab97-5c42-783a-a57d-e993b7f62c47 | €49.00 | €0.67 | matched |
| 42 | capture | 01a1ab97-5eb1-7868-a1fc-f9b09618485a | €35.00 | €0.50 | matched |
| 43 | capture | 01a1ab97-80e2-768c-9f71-e5aefeb48f46 | €15.00 | €0.26 | matched |
| 44 | capture | 01a1ab97-8a12-7e23-b095-d09941480418 | €49.00 | €0.67 | matched |
| 45 | capture | 01a1ab97-962d-769f-b7ab-586968b21136 | €49.00 | €0.67 | matched |
| 46 | capture | 01a1ab97-a8d4-79f2-a52c-80db51301d38 | €35.00 | €0.50 | matched |
| 47 | capture | 01a1ab97-ccd6-777b-a861-599f6c872dc9 | €15.00 | €0.26 | matched |
| 48 | capture | 01a1ab97-d57c-7c46-9322-e1269ce8d754 | €49.00 | €0.67 | matched |
| 49 | capture | 01a1ab97-e678-7dea-b405-8d8c2f52923f | €15.00 | €0.26 | matched |
| 50 | capture | 01a1ab97-eade-7abb-9563-f69f7a0df454 | €9.00 | €0.19 | matched |
| 51 | capture | 01a1ab97-ee6f-76e5-8897-e3c30cc63678 | €9.00 | €0.19 | matched |
| 52 | capture | 01a1ab98-0afb-760c-bf43-a38135b129b6 | €49.00 | €0.67 | matched |
| 53 | capture | 01a1ab98-6520-7c63-bbae-964f123d3730 | €35.00 | €0.50 | matched |
| 54 | capture | 01a1ab98-6dbb-7448-b347-1982cd62bd6d | €15.00 | €0.26 | matched |
| 55 | capture | 01a1ab98-93ab-7e62-9736-d94dd73dd7c4 | €49.00 | €0.67 | matched |
| 56 | capture | 01a1ab98-a38a-7334-aa1f-c241ec597f80 | €15.00 | €0.26 | matched |
| 57 | capture | 01a1ab98-ac8b-73e2-9b3f-fea342e8fb2f | €24.00 | €0.37 | matched |
| 58 | capture | 01a1ab98-b37c-7c2e-9fd2-9233b4621f25 | €24.00 | €0.37 | matched |
| 59 | capture | 01a1ab98-c232-7046-8288-9489b42a3707 | €24.00 | €0.37 | matched |
| 60 | capture | 01a1ab98-c7c9-768d-9b43-b50320b1c64d | €9.00 | €0.19 | matched |
| 61 | capture | 01a1ab98-f15e-7f45-bd8f-f188e3264d7a | €9.00 | €0.19 | matched |
| 62 | capture | 01a1ab99-00ed-74e4-96bb-ca7d367693de | €15.00 | €0.26 | matched |
| 63 | capture | 01a1ab99-2b65-7776-8cb3-7e8ce774bd7a | €35.00 | €0.50 | matched |
| 64 | capture | 01a1ab99-3bee-7dc4-8c4e-511b506dd442 | €35.00 | €0.50 | matched |
| 65 | capture | 01a1ab99-40e4-746d-a9de-00e0099f6cbe | €15.00 | €0.26 | matched |
| 66 | capture | 01a1ab99-50c6-7499-b591-fb2402213ba2 | €35.00 | €0.50 | matched |
| 67 | capture | 01a1ab99-50f6-7f6a-bf56-38dd7821aeea | €24.00 | €0.37 | matched |
| 68 | capture | 01a1ab99-53fb-7e1e-b819-c6142a4bcc22 | €49.00 | €0.67 | matched |
| 69 | refund | 01a1ab99-5916-7977-9132-a743d2666cd6 | -€34.00 | €0.00 | matched |
| 70 | capture | 01a1ab99-59f1-7e6e-be94-062c975dd40d | €9.00 | €0.19 | matched |
| 71 | capture | 01a1ab99-5e66-7596-957f-cd833ccf6805 | €35.00 | €0.50 | matched |
| 72 | capture | 01a1ab99-6ec9-7bdf-bce3-2fca61f66b09 | €15.00 | €0.26 | matched |
| 73 | capture | 01a1ab99-749b-70a9-9361-2f59ab6dc460 | €15.00 | €0.26 | matched |
| 74 | capture | 01a1ab99-758b-708b-8b20-01b3fb80a1c1 | €24.00 | €0.37 | matched |
| 75 | refund | 01a1ab99-8fbc-7890-9e4b-4555ff5b177e | -€5.00 | €0.00 | matched |
| 76 | capture | 01a1ab99-99e8-79df-98e9-416b74c105dc | €49.00 | €0.67 | matched |
| 78 | refund | 01a1ab99-a1d1-72c8-aa5c-d538c7a09725 | -€8.00 | €0.00 | matched |
| 79 | refund | 01a1ab99-c420-7792-a017-5058378b51ae | -€10.00 | €0.00 | matched |
| 80 | capture | 01a1ab99-d1bb-74dc-8cd3-60df6aede00d | €9.00 | €0.19 | matched |
| 81 | capture | 01a1ab99-ef84-7c3a-9c89-b8b6f6edb115 | €49.00 | €0.67 | matched |
| 82 | capture | 01a1ab9a-021c-7d32-aece-1d117381786d | €35.00 | €0.50 | matched |
| 83 | capture | 01a1ab9a-21f6-7f80-9c5d-9ba3907c4bc0 | €15.00 | €0.26 | matched |
| 84 | capture | 01a1ab9a-233d-7fc9-8c8f-7193ccbc7752 | €24.00 | €0.37 | matched |
| 85 | capture | 01a1ab9a-4f12-7db5-a68f-decf149436f3 | €15.00 | €0.26 | matched |
| 86 | capture | 01a1ab9a-7205-718f-9ca3-c17aa5586c34 | €49.00 | €0.67 | matched |
| 87 | capture | 01a1ab9a-7730-78bf-8c16-8ecdaf23f563 | €49.00 | €0.67 | matched |
| 88 | capture | 01a1ab9a-7c9d-789f-a2c2-1563aa4781e9 | €24.00 | €0.37 | matched |
| 89 | capture | 01a1ab9a-8dbe-769e-89a2-3ca7ee5ad2a1 | €9.00 | €0.19 | matched |
| 90 | capture | 01a1ab9a-98f0-7433-959a-6e72cff882d7 | €15.00 | €0.26 | matched |
| 91 | capture | 01a1ab9a-a3a6-7e08-ba70-c239b45694d8 | €15.00 | €0.26 | matched |
| 92 | capture | 01a1ab9a-c45c-7f77-b572-2592ae9ee021 | €35.00 | €0.50 | matched |
| 93 | capture | 01a1ab9a-c84b-78f1-af10-a6fe05bfa66f | €49.00 | €0.67 | matched |
| 94 | capture | 01a1ab9a-d0e9-79c7-9018-50f0ee847b49 | €24.00 | €0.37 | matched |
| 95 | capture | 01a1ab9a-e16b-7bd2-a638-48008cabcfec | €35.00 | €0.50 | matched |
| 96 | refund | 01a1ab9a-fced-7343-9d65-78320b8108fa | -€7.00 | €0.00 | matched |
| 97 | capture | 01a1ab9b-04fa-7475-9a21-bbd108f4740c | €49.00 | €0.67 | matched |
| 98 | capture | 01a1ab9b-13f2-7986-845d-219cffc5bd44 | €24.00 | €0.37 | matched |
| 99 | capture | 01a1ab9b-31ab-7c69-b03f-c1922887363c | €35.00 | €0.50 | matched |
| 100 | capture | 01a1ab9b-4cf2-7039-8e5a-29ac229ea342 | €9.00 | €0.19 | matched |
| 101 | capture | 01a1ab9b-9f09-794b-84ae-d85f7a6794f1 | €24.00 | €0.37 | matched |
| 102 | capture | 01a1ab9b-cffd-7e3e-9c57-8a1b2886539b | €24.00 | €0.37 | matched |
| 103 | capture | 01a1ab9b-d5da-735b-8390-dafea5f2049e | €35.00 | €0.50 | matched |
| 104 | capture | 01a1ab9b-f0bf-7ab9-bcfa-8b19208f1a32 | €24.00 | €0.37 | matched |
| 105 | capture | 01a1ab9c-09c3-7cb3-86c1-f124229358b9 | €15.00 | €0.26 | matched |
| 106 | capture | 01a1ab9c-1743-7075-a6da-ebfe1eec9d52 | €15.00 | €0.26 | matched |
| 107 | capture | 01a1ab9c-1750-7404-9452-7e42e8a75429 | €49.00 | €0.67 | matched |
| 108 | capture | 01a1ab9c-24c9-70eb-b033-4a28ed92d1f5 | €15.00 | €0.26 | matched |
| 109 | capture | 01a1ab9c-253d-7481-8a23-cdb3de46993b | €49.00 | €0.67 | matched |
| 110 | capture | 01a1ab9c-3b54-7286-a1a6-94ce8816cca3 | €24.00 | €0.37 | matched |
| 111 | capture | 01a1ab9c-47cd-71cc-bba1-1ab209e564f3 | €49.00 | €0.67 | matched |
| 112 | refund | 01a1ab9c-514c-7f10-bea0-62b1b2bb6bad | -€23.00 | €0.00 | matched |
| 113 | capture | 01a1ab9c-79a7-71b2-b279-5915372377ba | €49.00 | €0.67 | matched |
| 114 | capture | 01a1ab9c-7c1f-7b4a-bec6-9f8a5171b2ad | €15.00 | €0.26 | matched |
| 115 | capture | 01a1ab9c-917f-74da-8b55-acb478dd1760 | €35.00 | €0.50 | matched |
| 116 | capture | 01a1ab9c-e45d-76c3-9fbf-4532b8ff5c6e | €35.00 | €0.50 | matched |
| 117 | capture | 01a1ab9d-067b-75df-a3f4-ca1c657749f8 | €24.00 | €0.37 | matched |
| 118 | capture | 01a1ab9d-3de9-7970-8aed-9d9b9084d56b | €49.00 | €0.67 | matched |
| 119 | capture | 01a1ab9d-4215-70df-943d-a35f820351da | €15.00 | €0.26 | matched |
| 120 | capture | 01a1ab9d-8132-7cbc-b292-289baf24b387 | €35.00 | €0.50 | matched |
| 121 | capture | 01a1ab9d-8eff-73db-b787-f19c6fb5e252 | €9.00 | €0.19 | matched |
| 122 | capture | 01a1ab9d-acce-7bcc-9d02-59bab1a7def8 | €49.00 | €0.67 | matched |