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
- 29 Oct, 07:40128 lines1 break
- 29 Oct, 07:30119 lines3 breaks
- 29 Oct, 07:20127 lines4 breaks
- 29 Oct, 07:10141 linesclean
- 29 Oct, 07:00109 lines2 breaks
- 29 Oct, 06:50124 lines3 breaks
- 29 Oct, 06:40127 lines4 breaks
- 29 Oct, 06:30130 lines2 breaks
- 29 Oct, 06:20119 lines1 break
- 29 Oct, 06:10118 lines4 breaks
- 29 Oct, 06:00112 lines3 breaks
- 29 Oct, 05:50122 lines4 breaks
- 29 Oct, 05:40129 lines2 breaks
- 29 Oct, 05:30132 lines3 breaks
29 Oct, 07:00
Gross
€2,417.00
PSP fee
€38.38
Net to the bank
€2,378.62
Settlement journal
#265536
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1867b-c1b4-7844-825c-925672fc8681 is already settled by stl_EUR_2988762 line 75
- missing linein the books, not in the filecapture:01a1867c-79a8-72ca-8fa3-a3bbb392b18c is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 76 | capture | 01a1867b-c330-7d92-bfad-732578a5ac9c | €15.00 | €0.26 | duplicate line |
| 1 | capture | 01a1866e-5d6d-7abf-9797-b864d80d8fb9 | €35.00 | €0.50 | matched |
| 2 | capture | 01a18672-0baa-7599-8fba-6d973587287a | €9.00 | €0.19 | matched |
| 3 | capture | 01a18673-5517-7abb-b237-ab95923ccf81 | €35.00 | €0.50 | matched |
| 4 | capture | 01a18674-0236-75b2-8634-a962b272c9da | €9.00 | €0.19 | matched |
| 5 | capture | 01a18675-7b6a-76a2-9d92-e2249046b315 | €49.00 | €0.67 | matched |
| 6 | capture | 01a18675-857b-79c1-97c1-2c1d4ac38d85 | €9.00 | €0.19 | matched |
| 7 | refund | 01a18675-8a3a-7d84-a1c5-c7206fffb47c | -€16.00 | €0.00 | matched |
| 8 | capture | 01a18675-bdad-79d0-9b1b-ed0294b5620f | €49.00 | €0.67 | matched |
| 9 | capture | 01a18675-c98d-7459-917a-d3a1bbdd4262 | €49.00 | €0.67 | matched |
| 10 | capture | 01a18675-ce3f-7a3e-8c74-040ac2b51dfe | €49.00 | €0.67 | matched |
| 11 | refund | 01a18675-f41d-78d7-b9a0-35aa7546edd1 | -€8.00 | €0.00 | matched |
| 12 | capture | 01a18675-f703-7e61-8de2-9a3052d21998 | €9.00 | €0.19 | matched |
| 13 | capture | 01a18676-2600-7a32-b509-d97027583335 | €15.00 | €0.26 | matched |
| 14 | capture | 01a18676-2c25-72e6-b59d-d157475d1261 | €9.00 | €0.19 | matched |
| 15 | capture | 01a18676-3e2b-7b65-89cd-5b03513989f6 | €15.00 | €0.26 | matched |
| 16 | capture | 01a18676-41e8-7db4-94dd-7b98cff63654 | €35.00 | €0.50 | matched |
| 17 | capture | 01a18676-54b6-7e58-945e-40d2b1f37bc8 | €24.00 | €0.37 | matched |
| 18 | refund | 01a18676-7aed-76b0-8cc5-93d8acba16b6 | -€6.00 | €0.00 | matched |
| 19 | capture | 01a18676-84ae-7e7b-9d59-e14528a8c154 | €24.00 | €0.37 | matched |
| 20 | capture | 01a18676-87e0-714b-adc0-be561706b49c | €9.00 | €0.19 | matched |
| 21 | capture | 01a18676-c81a-706b-b858-fa818ea5c6cd | €24.00 | €0.37 | matched |
| 22 | capture | 01a18676-d52d-7a7a-95a8-dd466a2b504c | €15.00 | €0.26 | matched |
| 23 | capture | 01a18676-ea5d-7a7e-91fe-4cc6943edebf | €24.00 | €0.37 | matched |
| 24 | capture | 01a18676-ef1c-7977-af31-0b861a221b82 | €24.00 | €0.37 | matched |
| 25 | capture | 01a18676-f16e-78ea-8278-31aefc65c0fd | €15.00 | €0.26 | matched |
| 26 | refund | 01a18677-31bc-7342-9251-6baaed472763 | -€8.00 | €0.00 | matched |
| 27 | capture | 01a18677-4375-7520-a11e-a3afd01a583a | €15.00 | €0.26 | matched |
| 28 | capture | 01a18677-63a0-7952-8280-4675d47a0a40 | €9.00 | €0.19 | matched |
| 29 | capture | 01a18677-707f-7b84-ac5b-51d8ab527581 | €24.00 | €0.37 | matched |
| 30 | capture | 01a18677-a225-75f0-b13c-aa1cf54fa49c | €9.00 | €0.19 | matched |
| 31 | capture | 01a18677-ca51-71c5-b343-38ae95263c73 | €35.00 | €0.50 | matched |
| 32 | capture | 01a18677-f649-7282-b416-38401a1a24b3 | €15.00 | €0.26 | matched |
| 33 | capture | 01a18678-0339-7348-9eb3-d666344c1cd2 | €35.00 | €0.50 | matched |
| 34 | capture | 01a18678-05a7-776a-9586-cb8ca81bc678 | €35.00 | €0.50 | matched |
| 35 | capture | 01a18678-33c2-7d35-af1d-107f25dc5c61 | €9.00 | €0.19 | matched |
| 36 | capture | 01a18678-4876-7061-9280-de34e4d0017d | €49.00 | €0.67 | matched |
| 37 | capture | 01a18678-63c7-76f8-9958-118c10d974f6 | €9.00 | €0.19 | matched |
| 38 | capture | 01a18678-6414-762a-948a-46b04e1f9fd1 | €35.00 | €0.50 | matched |
| 39 | capture | 01a18678-8c41-7899-ad32-994a5ad8cbf1 | €49.00 | €0.67 | matched |
| 40 | capture | 01a18678-900a-7028-a2e7-110d882f8374 | €24.00 | €0.37 | matched |
| 41 | capture | 01a18678-c0ce-768b-829f-a129a384f165 | €9.00 | €0.19 | matched |
| 42 | refund | 01a18678-e9c4-7770-99f8-bdffee8fb024 | -€22.00 | €0.00 | matched |
| 43 | capture | 01a18678-fc23-7737-b8fc-db3b9bd78110 | €24.00 | €0.37 | matched |
| 44 | capture | 01a18679-1afb-7208-83ba-009e39b2df2b | €35.00 | €0.50 | matched |
| 45 | capture | 01a18679-1be2-7ebe-a996-18c50f109ab7 | €49.00 | €0.67 | matched |
| 46 | capture | 01a18679-3213-7067-b787-20907a2aedd6 | €15.00 | €0.26 | matched |
| 47 | capture | 01a18679-49cf-79ff-9eb5-1371634c024a | €24.00 | €0.37 | matched |
| 48 | capture | 01a18679-55a4-754f-be11-d05729a76706 | €35.00 | €0.50 | matched |
| 49 | capture | 01a18679-56f9-7476-995d-afa6fc5e9340 | €35.00 | €0.50 | matched |
| 50 | capture | 01a18679-5f7c-7c1b-979c-83a3596f496e | €35.00 | €0.50 | matched |
| 51 | capture | 01a18679-6354-7cc5-833d-dca0c11604ae | €35.00 | €0.50 | matched |
| 52 | capture | 01a18679-9507-76f1-a2bb-1658ece68ca0 | €15.00 | €0.26 | matched |
| 53 | capture | 01a18679-98f6-7402-9b49-43750b1dcc02 | €15.00 | €0.26 | matched |
| 54 | refund | 01a18679-a47a-7ab7-b872-a17e348e5d75 | -€19.00 | €0.00 | matched |
| 55 | capture | 01a18679-b285-728d-8325-61dd2e48233b | €9.00 | €0.19 | matched |
| 56 | capture | 01a18679-c8df-7d1a-bb15-8433b3d22c2a | €9.00 | €0.19 | matched |
| 57 | refund | 01a18679-dcb7-7d0d-9081-966849efffed | -€7.00 | €0.00 | matched |
| 58 | capture | 01a18679-df0f-75a5-b173-050b862ec8f4 | €35.00 | €0.50 | matched |
| 59 | capture | 01a18679-f62c-77a6-9acb-f838343335dc | €35.00 | €0.50 | matched |
| 60 | capture | 01a1867a-008c-7f2e-829c-d3ca515680e0 | €49.00 | €0.67 | matched |
| 61 | capture | 01a1867a-2190-73b8-9736-27738b166846 | €9.00 | €0.19 | matched |
| 62 | capture | 01a1867a-2add-7f30-951b-028e8294fda8 | €49.00 | €0.67 | matched |
| 63 | capture | 01a1867a-33ed-7db6-9535-4c43dbd3a1b1 | €9.00 | €0.19 | matched |
| 64 | capture | 01a1867a-4ce9-7908-b38f-b417e1347fc3 | €35.00 | €0.50 | matched |
| 65 | capture | 01a1867a-4f65-7df6-8dbe-c570c68804b9 | €15.00 | €0.26 | matched |
| 66 | capture | 01a1867a-5568-71a4-90f6-882fd5e15870 | €24.00 | €0.37 | matched |
| 67 | capture | 01a1867a-68a1-7c97-85b3-c6d7d96b831b | €24.00 | €0.37 | matched |
| 68 | refund | 01a1867a-6e8e-75cf-bc4e-8c6b3b7b8770 | -€9.00 | €0.00 | matched |
| 69 | capture | 01a1867a-7dce-749b-8ec2-13c8fb418459 | €24.00 | €0.37 | matched |
| 70 | capture | 01a1867a-9885-7167-b116-21e1581b804a | €49.00 | €0.67 | matched |
| 71 | capture | 01a1867b-12a3-7f7b-868c-6581d5948fed | €24.00 | €0.37 | matched |
| 72 | capture | 01a1867b-33d7-7c25-825d-2fb593aaf67a | €15.00 | €0.26 | matched |
| 73 | refund | 01a1867b-5f8d-7463-8079-1115090f2f56 | -€11.00 | €0.00 | matched |
| 74 | capture | 01a1867b-7314-7382-bb0d-2e1669d8bae1 | €9.00 | €0.19 | matched |
| 75 | capture | 01a1867b-c330-7d92-bfad-732578a5ac9c | €15.00 | €0.26 | matched |
| 77 | capture | 01a1867b-e05e-7a95-896d-490cf33acd60 | €49.00 | €0.67 | matched |
| 78 | capture | 01a1867c-0b8a-7fd6-b821-a561675bdbb2 | €15.00 | €0.26 | matched |
| 79 | capture | 01a1867c-111b-73f0-b9c3-0c2aa327d85f | €35.00 | €0.50 | matched |
| 80 | capture | 01a1867c-1237-7ea0-9767-4c74edcccc17 | €24.00 | €0.37 | matched |
| 81 | capture | 01a1867c-1a29-777f-bacd-2d0eba86729d | €9.00 | €0.19 | matched |
| 82 | capture | 01a1867c-1c8c-7fbc-a03d-b8023150f0ca | €35.00 | €0.50 | matched |
| 83 | capture | 01a1867c-45b8-78d7-bf08-67521ecd2eac | €35.00 | €0.50 | matched |
| 84 | capture | 01a1867c-46a9-746b-b6a3-b1da180df661 | €15.00 | €0.26 | matched |
| 85 | refund | 01a1867c-5263-7f9e-8ed2-2b4b2a0d1b9d | -€9.00 | €0.00 | matched |
| 86 | capture | 01a1867c-88b9-7051-846e-c7bd724d1745 | €49.00 | €0.67 | matched |
| 87 | capture | 01a1867c-88e5-7717-8597-47750ca14197 | €35.00 | €0.50 | matched |
| 88 | capture | 01a1867c-be3c-730e-9971-92dd54e01a20 | €35.00 | €0.50 | matched |
| 89 | capture | 01a1867c-e990-7ef4-8e50-b2a011aa7866 | €35.00 | €0.50 | matched |
| 90 | capture | 01a1867d-116b-7f66-8822-435f7a3f5ffa | €9.00 | €0.19 | matched |
| 91 | capture | 01a1867d-124a-74dd-8976-429dbccc8ecb | €24.00 | €0.37 | matched |
| 92 | capture | 01a1867d-4034-77ec-9154-88affa654acd | €49.00 | €0.67 | matched |
| 93 | capture | 01a1867d-4646-7e5f-a422-4becaf8cc798 | €24.00 | €0.37 | matched |
| 94 | capture | 01a1867d-4f7d-790f-8268-dff201531317 | €9.00 | €0.19 | matched |
| 95 | refund | 01a1867d-5db7-7eba-a26b-dcb6b258777b | -€6.00 | €0.00 | matched |
| 96 | capture | 01a1867d-5fda-78ba-8dbf-bcc5b13714ed | €49.00 | €0.67 | matched |
| 97 | capture | 01a1867d-7060-7d9c-b202-ab448d55831a | €9.00 | €0.19 | matched |
| 98 | capture | 01a1867d-8ec5-7aab-bb94-6ca9f8981ded | €9.00 | €0.19 | matched |
| 99 | capture | 01a1867d-bd3d-7503-bb61-8fa230e64042 | €9.00 | €0.19 | matched |
| 100 | capture | 01a1867d-cdf3-70c1-bfec-1be689375a3f | €15.00 | €0.26 | matched |
| 101 | capture | 01a1867d-e0d8-7c86-8eed-919889921f39 | €35.00 | €0.50 | matched |
| 102 | refund | 01a1867d-ed72-7167-b6bb-45257da4c2f4 | -€4.00 | €0.00 | matched |
| 103 | capture | 01a1867d-eea6-7a3a-9647-3db1d10efb0d | €49.00 | €0.67 | matched |
| 104 | capture | 01a1867e-0343-72f9-b7e1-a7c7cab6f2bc | €49.00 | €0.67 | matched |
| 105 | capture | 01a1867e-1970-7dba-92b5-7ef76ad0a674 | €9.00 | €0.19 | matched |
| 106 | capture | 01a1867e-3762-70df-ac59-96739b55f986 | €35.00 | €0.50 | matched |
| 107 | capture | 01a1867e-3888-7c39-9948-a09df4135f80 | €49.00 | €0.67 | matched |
| 108 | capture | 01a1867e-38a5-7ed1-a362-0f78eed38ed3 | €24.00 | €0.37 | matched |
| 109 | capture | 01a1867e-7213-7f76-aece-4893039ed66e | €49.00 | €0.67 | matched |