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
- 31 Oct, 04:00128 lines4 breaks
- 31 Oct, 03:50141 lines2 breaks
- 31 Oct, 03:40108 lines1 break
- 31 Oct, 03:30130 linesclean
- 31 Oct, 03:20115 lines1 break
- 31 Oct, 03:10122 lines5 breaks
- 31 Oct, 03:00120 lines4 breaks
- 31 Oct, 02:50132 lines5 breaks
- 31 Oct, 02:40127 lines3 breaks
- 31 Oct, 02:30136 lines6 breaks
- 31 Oct, 02:20111 lines2 breaks
- 31 Oct, 02:10121 lines3 breaks
- 31 Oct, 02:00130 lines4 breaks
- 31 Oct, 01:50136 lines1 break
31 Oct, 02:30
Gross
€3,217.00
PSP fee
€50.34
Net to the bank
€3,166.66
Settlement journal
#298743
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18fcb-ac7f-713f-ace0-961e88849800 is already settled by stl_EUR_2989023 line 11
- duplicate linethe file lists it twicecapture:01a18fcd-903b-7b39-a8a6-113d42f52433 is already settled by stl_EUR_2989023 line 44
- fee differencethe fee is not the contract feethe fee is 69, the contract says 67
- fee differencethe fee is not the contract feethe fee is 31, the contract says 26
- fee differencethe fee is not the contract feethe fee is 30, the contract says 26
- missing linein the books, not in the filecapture:01a18fcb-e160-7ce6-94fc-7dea12f2d4f6 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 12 | capture | 01a18fcb-acb5-7540-8a00-8e7481f5db84 | €35.00 | €0.50 | duplicate line |
| 17 | capture | 01a18fcb-dc3c-754d-ae61-1b4d58352b0e | €49.00 | €0.69 | fee difference |
| 25 | capture | 01a18fcc-af84-7f14-8e68-8c3c4c9a0172 | €15.00 | €0.31 | fee difference |
| 40 | capture | 01a18fcd-6120-796a-9526-e090ca2d3bb8 | €15.00 | €0.30 | fee difference |
| 45 | capture | 01a18fcd-9071-7723-b48e-fd11a23cbc54 | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a18fc5-06f1-78d4-9d6e-2c65f9f76f5b | €15.00 | €0.26 | matched |
| 2 | capture | 01a18fca-f572-7c06-b7f7-3a20e1d9531a | €35.00 | €0.50 | matched |
| 3 | capture | 01a18fca-f5a0-7a33-9629-acfc31a0965b | €15.00 | €0.26 | matched |
| 4 | capture | 01a18fcb-052f-7a54-817d-43b5140d9588 | €24.00 | €0.37 | matched |
| 5 | capture | 01a18fcb-1303-7927-b475-8b451281dc1a | €15.00 | €0.26 | matched |
| 6 | capture | 01a18fcb-1f66-7661-bc88-23e313487f9a | €9.00 | €0.19 | matched |
| 7 | capture | 01a18fcb-5060-72e9-af5e-3a935559e918 | €49.00 | €0.67 | matched |
| 8 | capture | 01a18fcb-5263-7638-98e7-5eabf6ee9858 | €9.00 | €0.19 | matched |
| 9 | capture | 01a18fcb-706e-7548-babe-2f47ea527189 | €35.00 | €0.50 | matched |
| 10 | capture | 01a18fcb-7f97-797d-9f57-94cedfccbbda | €49.00 | €0.67 | matched |
| 11 | capture | 01a18fcb-acb5-7540-8a00-8e7481f5db84 | €35.00 | €0.50 | matched |
| 13 | capture | 01a18fcb-b4f0-758e-ac6d-8ff25419fcd4 | €35.00 | €0.50 | matched |
| 14 | capture | 01a18fcb-b620-7ab5-b4db-b4a027f112d6 | €15.00 | €0.26 | matched |
| 15 | capture | 01a18fcb-bb9c-7b87-a621-5ce8ff54bbf3 | €15.00 | €0.26 | matched |
| 16 | capture | 01a18fcb-dbe4-73b4-95c1-af38f448343c | €35.00 | €0.50 | matched |
| 18 | capture | 01a18fcc-020f-7cc9-af76-d7e3410dd9f4 | €9.00 | €0.19 | matched |
| 19 | capture | 01a18fcc-16f5-7cbd-9cf1-69528eca4c5d | €15.00 | €0.26 | matched |
| 20 | capture | 01a18fcc-4245-77cc-9264-0ab772ce87d5 | €35.00 | €0.50 | matched |
| 21 | refund | 01a18fcc-4e41-7f11-b33f-7cdba79c8564 | -€23.00 | €0.00 | matched |
| 22 | capture | 01a18fcc-87b3-7830-8c1c-1d328dbb1b6c | €35.00 | €0.50 | matched |
| 23 | capture | 01a18fcc-8f0f-7f2d-ab5d-9aad4990f69c | €15.00 | €0.26 | matched |
| 24 | capture | 01a18fcc-9be1-709e-a348-c846bffcae8f | €24.00 | €0.37 | matched |
| 26 | capture | 01a18fcc-b9b9-7339-896e-749355d587fb | €35.00 | €0.50 | matched |
| 27 | capture | 01a18fcc-c088-747b-b9de-dd8019cb940f | €15.00 | €0.26 | matched |
| 28 | capture | 01a18fcc-c600-7f59-90c3-24f54c4d375a | €9.00 | €0.19 | matched |
| 29 | capture | 01a18fcc-de0f-78ed-9e36-4c64662b80df | €15.00 | €0.26 | matched |
| 30 | capture | 01a18fcc-e5bb-788f-a8c9-c89f80ce5e53 | €9.00 | €0.19 | matched |
| 31 | capture | 01a18fcc-f423-70be-abf0-37bbead6e269 | €9.00 | €0.19 | matched |
| 32 | capture | 01a18fcc-f714-7a04-b816-acf0748d64fb | €35.00 | €0.50 | matched |
| 33 | capture | 01a18fcc-ffb0-7734-87f4-155f35ab553c | €49.00 | €0.67 | matched |
| 34 | capture | 01a18fcd-02d1-740f-b7bf-d6ad6cc80357 | €24.00 | €0.37 | matched |
| 35 | capture | 01a18fcd-4282-7878-aa5d-fc0da19c4470 | €49.00 | €0.67 | matched |
| 36 | capture | 01a18fcd-467a-7f07-ab0d-183fb0d11c3a | €49.00 | €0.67 | matched |
| 37 | capture | 01a18fcd-45f9-7e30-8d8e-d523795074e9 | €9.00 | €0.19 | matched |
| 38 | capture | 01a18fcd-4a11-7a8d-a785-6583f1144ebd | €15.00 | €0.26 | matched |
| 39 | refund | 01a18fcd-4b46-7a2f-a8b9-b0c52a33e145 | -€15.00 | €0.00 | matched |
| 41 | capture | 01a18fcd-645a-7d20-bc63-f679a15a88e9 | €24.00 | €0.37 | matched |
| 42 | capture | 01a18fcd-6da5-779a-afb0-06480a049e9a | €15.00 | €0.26 | matched |
| 43 | capture | 01a18fcd-70fb-7e7e-aa23-14aefa84325d | €24.00 | €0.37 | matched |
| 44 | capture | 01a18fcd-9071-7723-b48e-fd11a23cbc54 | €49.00 | €0.67 | matched |
| 46 | capture | 01a18fcd-95e1-78e9-bf21-39cd27db6996 | €24.00 | €0.37 | matched |
| 47 | capture | 01a18fcd-c13e-78e5-b4d7-16325c5a999d | €49.00 | €0.67 | matched |
| 48 | refund | 01a18fcd-cbd3-7972-81da-d75261721f9c | -€20.00 | €0.00 | matched |
| 49 | capture | 01a18fcd-d106-7665-8716-6543260e69f7 | €24.00 | €0.37 | matched |
| 50 | capture | 01a18fcd-e311-7bd7-8f30-56278eb33e44 | €24.00 | €0.37 | matched |
| 51 | capture | 01a18fce-6de0-7462-8944-afe93869d8b1 | €9.00 | €0.19 | matched |
| 52 | capture | 01a18fce-73f3-7df1-9825-231eca866a49 | €24.00 | €0.37 | matched |
| 53 | capture | 01a18fce-76ed-7768-bc81-028140b49d4e | €15.00 | €0.26 | matched |
| 54 | capture | 01a18fce-8aa5-7867-a436-72bf8567b35a | €35.00 | €0.50 | matched |
| 55 | capture | 01a18fce-8d22-7a39-9592-2765a02b5800 | €15.00 | €0.26 | matched |
| 56 | capture | 01a18fce-b5ce-7a42-a04f-057aa5e45633 | €9.00 | €0.19 | matched |
| 57 | capture | 01a18fcf-0558-7581-a400-fcffa3d29113 | €35.00 | €0.50 | matched |
| 58 | capture | 01a18fcf-0dde-7cf6-ae86-90055c17e253 | €24.00 | €0.37 | matched |
| 59 | capture | 01a18fcf-155a-71af-8607-c1b611efc4ff | €35.00 | €0.50 | matched |
| 60 | capture | 01a18fcf-1b61-7e2f-ad8f-3b44f5ddb4e4 | €9.00 | €0.19 | matched |
| 61 | capture | 01a18fcf-1bda-7cd5-8f39-256685c8c4ca | €24.00 | €0.37 | matched |
| 62 | capture | 01a18fcf-1cba-70a9-9368-dcd2346fe1c8 | €9.00 | €0.19 | matched |
| 63 | capture | 01a18fcf-366b-7254-af86-8939969edaf3 | €49.00 | €0.67 | matched |
| 64 | capture | 01a18fcf-4467-7a6b-9ecc-47cd8706e91e | €35.00 | €0.50 | matched |
| 65 | capture | 01a18fcf-608f-7d1a-acbc-2cc1882f15d1 | €9.00 | €0.19 | matched |
| 66 | capture | 01a18fcf-790b-7a08-bf7e-a405d9d1e77d | €24.00 | €0.37 | matched |
| 67 | capture | 01a18fcf-7d4c-7f57-84be-2d2a3fa41663 | €15.00 | €0.26 | matched |
| 68 | capture | 01a18fcf-926b-7a0c-b1ae-320e41962a3a | €15.00 | €0.26 | matched |
| 69 | capture | 01a18fcf-b947-75d0-a4b3-2a5afb6b3fd4 | €49.00 | €0.67 | matched |
| 70 | capture | 01a18fcf-ca24-77eb-9195-a811c13fcaa6 | €9.00 | €0.19 | matched |
| 71 | capture | 01a18fcf-d8ec-7db9-be69-b06c7d2ff167 | €24.00 | €0.37 | matched |
| 72 | capture | 01a18fcf-e5ad-7cbe-9c0b-6dce1c0b5056 | €49.00 | €0.67 | matched |
| 73 | refund | 01a18fcf-ec41-7fa4-8859-59f8cfaa0107 | -€16.00 | €0.00 | matched |
| 74 | capture | 01a18fd0-0326-76c8-8433-286beb1b4146 | €35.00 | €0.50 | matched |
| 75 | capture | 01a18fd0-1a89-73f2-8fac-8782c6ee3d58 | €24.00 | €0.37 | matched |
| 76 | capture | 01a18fd0-39ee-72bc-a8af-296d7b026f39 | €35.00 | €0.50 | matched |
| 77 | capture | 01a18fd0-3dcd-7c0d-aeed-35e178df0d6c | €49.00 | €0.67 | matched |
| 78 | capture | 01a18fd0-4b99-7154-a44a-2bc9d73bd8ce | €49.00 | €0.67 | matched |
| 79 | capture | 01a18fd0-5dc4-736e-b8d2-b203ce0f2a1f | €15.00 | €0.26 | matched |
| 80 | capture | 01a18fd0-60d5-7741-83eb-882eb94da166 | €35.00 | €0.50 | matched |
| 81 | capture | 01a18fd0-6c80-7a64-a01e-5625932bd23b | €9.00 | €0.19 | matched |
| 82 | capture | 01a18fd0-71fb-73a7-aebf-c4dda810603e | €49.00 | €0.67 | matched |
| 83 | capture | 01a18fd0-77b9-79f6-911f-9e313bc8d3db | €9.00 | €0.19 | matched |
| 84 | capture | 01a18fd0-7d0a-7aa5-9324-8ef5295d4dd6 | €24.00 | €0.37 | matched |
| 85 | capture | 01a18fd0-8237-7e81-895f-e01cdf367eb4 | €9.00 | €0.19 | matched |
| 86 | refund | 01a18fd0-8b77-7830-95e2-7f419cc8f082 | -€5.00 | €0.00 | matched |
| 87 | capture | 01a18fd0-a924-7ef7-b8be-7f09d2c5c937 | €9.00 | €0.19 | matched |
| 88 | refund | 01a18fd0-dfa6-73e6-aa9f-1d8d734cc6b8 | -€8.00 | €0.00 | matched |
| 89 | capture | 01a18fd0-f7be-7a51-ba4a-44d47de2fd84 | €49.00 | €0.67 | matched |
| 90 | capture | 01a18fd1-0f6b-7bfe-a4a9-b3790da28042 | €35.00 | €0.50 | matched |
| 91 | capture | 01a18fd1-2482-7d7f-917e-1f66ff599aec | €9.00 | €0.19 | matched |
| 92 | capture | 01a18fd1-2d2f-7055-b372-559bfdfb5c14 | €35.00 | €0.50 | matched |
| 93 | capture | 01a18fd1-374e-7a33-b299-c712f30a9509 | €24.00 | €0.37 | matched |
| 94 | capture | 01a18fd1-4a42-7076-9753-6cb46f7230cf | €24.00 | €0.37 | matched |
| 95 | capture | 01a18fd1-7695-7f7d-9f7b-3ca101000092 | €15.00 | €0.26 | matched |
| 96 | refund | 01a18fd1-76cf-75a1-8cc5-b25b10c210da | -€6.00 | €0.00 | matched |
| 97 | capture | 01a18fd1-813a-71ad-8938-78c77f45d269 | €24.00 | €0.37 | matched |
| 98 | capture | 01a18fd1-9378-7de1-b41e-a7bbf254fd3d | €49.00 | €0.67 | matched |
| 99 | capture | 01a18fd1-98d0-7c84-a5e2-fb6ecb07b4cc | €49.00 | €0.67 | matched |
| 100 | capture | 01a18fd1-9e60-781f-b2c8-d6556dbef558 | €49.00 | €0.67 | matched |
| 101 | capture | 01a18fd1-ccc7-7bad-9b2d-bc9a35885356 | €35.00 | €0.50 | matched |
| 102 | capture | 01a18fd1-d27f-7e9b-8e9a-2d21a07dbe37 | €49.00 | €0.67 | matched |
| 103 | capture | 01a18fd1-f1d1-76c5-a29f-75d5ce92070e | €24.00 | €0.37 | matched |
| 104 | capture | 01a18fd1-f33c-7516-a8e7-4ad65bb1df09 | €24.00 | €0.37 | matched |
| 105 | capture | 01a18fd1-f848-70ce-85d0-dccd0f987ff6 | €15.00 | €0.26 | matched |
| 106 | capture | 01a18fd2-2fc6-707c-9705-52d203a0cec6 | €9.00 | €0.19 | matched |
| 107 | capture | 01a18fd2-6357-70ad-bfb8-91320f0d1164 | €24.00 | €0.37 | matched |
| 108 | capture | 01a18fd2-6cb5-798b-be3b-c4a7287cb4e0 | €49.00 | €0.67 | matched |
| 109 | capture | 01a18fd2-6e14-78ed-aef5-b88d9edd8029 | €24.00 | €0.37 | matched |
| 110 | capture | 01a18fd2-8715-707e-b593-58b78403c711 | €49.00 | €0.67 | matched |
| 111 | capture | 01a18fd2-94a9-74b1-a986-883a3b900a25 | €49.00 | €0.67 | matched |
| 112 | capture | 01a18fd2-9b26-76f9-8b5b-6fe1bcb14cb8 | €24.00 | €0.37 | matched |
| 113 | capture | 01a18fd2-ac7d-7719-ac76-b01acdf416c2 | €49.00 | €0.67 | matched |
| 114 | capture | 01a18fd2-be6a-74f4-a7c9-c9973ed57a8e | €9.00 | €0.19 | matched |
| 115 | capture | 01a18fd2-e502-7a84-87ae-9c05b633554f | €24.00 | €0.37 | matched |
| 116 | refund | 01a18fd2-f269-7b6d-9120-8b67237abbaa | -€5.00 | €0.00 | matched |
| 117 | refund | 01a18fd3-0a48-7d60-9f01-7b68fe211d37 | -€11.00 | €0.00 | matched |
| 118 | capture | 01a18fd3-0e7a-7d46-88e0-ad54dd54a115 | €9.00 | €0.19 | matched |
| 119 | capture | 01a18fd3-304a-7f10-abdf-167fe30371a3 | €24.00 | €0.37 | matched |
| 120 | capture | 01a18fd3-36b3-799a-9a45-a8efb93ba01b | €35.00 | €0.50 | matched |
| 121 | capture | 01a18fd3-3885-7edd-990b-3a32ab76986c | €15.00 | €0.26 | matched |
| 122 | capture | 01a18fd3-45e1-750c-a6fa-3d00d0a8e31a | €9.00 | €0.19 | matched |
| 123 | capture | 01a18fd3-5ab0-7466-bbbc-75482ffbf758 | €35.00 | €0.50 | matched |
| 124 | capture | 01a18fd3-5ca2-76ab-9631-e41a07973bcd | €24.00 | €0.37 | matched |
| 125 | capture | 01a18fd3-5d69-787a-b800-6ff3ec2d1847 | €24.00 | €0.37 | matched |
| 126 | capture | 01a18fd3-5e89-7415-894e-3963b0a85b53 | €9.00 | €0.19 | matched |
| 127 | capture | 01a18fd3-6d6f-7326-8288-2c2ef62c8945 | €9.00 | €0.19 | matched |
| 128 | capture | 01a18fd3-91c7-7891-8f8c-e37a27bbe807 | €24.00 | €0.37 | matched |
| 129 | capture | 01a18fd3-9560-7844-b613-682bd0728103 | €35.00 | €0.50 | matched |
| 130 | capture | 01a18fd3-a2d7-702a-9aff-f719767d4780 | €24.00 | €0.37 | matched |
| 131 | capture | 01a18fd3-9bf5-73ac-b420-0e5a8bd164be | €15.00 | €0.26 | matched |
| 132 | capture | 01a18fd3-a58a-7bf9-914a-68b191b56fb8 | €15.00 | €0.26 | matched |
| 133 | capture | 01a18fd3-a59b-766a-8ae3-9df13b241552 | €9.00 | €0.19 | matched |
| 134 | capture | 01a18fd3-aef7-74ff-806f-7025f9c22ce2 | €15.00 | €0.26 | matched |
| 135 | capture | 01a18fd3-ee1f-7425-955a-b1a022d65c66 | €15.00 | €0.26 | matched |
| 136 | capture | 01a18fd3-fef9-7777-8cac-bd245f553c5a | €49.00 | €0.67 | matched |