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
- 30 Oct, 19:40105 lines3 breaks
- 30 Oct, 19:30125 lines4 breaks
- 30 Oct, 19:20126 lines4 breaks
- 30 Oct, 19:10118 lines3 breaks
- 30 Oct, 19:00114 lines2 breaks
- 30 Oct, 18:50120 lines2 breaks
- 30 Oct, 18:40126 lines3 breaks
- 30 Oct, 18:30124 lines6 breaks
- 30 Oct, 18:20159 linesclean
- 30 Oct, 18:10123 lines8 breaks
- 30 Oct, 18:00102 lines2 breaks
- 30 Oct, 17:5097 lines2 breaks
- 30 Oct, 17:40139 lines1 break
- 30 Oct, 17:30113 lines2 breaks
30 Oct, 18:30
Gross
€2,598.00
PSP fee
€42.32
Net to the bank
€2,555.68
Settlement journal
#292502
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18e16-7eb3-7309-b98a-c88259596915 is already settled by stl_EUR_2988975 line 41
- duplicate linethe file lists it twicecapture:01a18e19-ffb6-77f7-83cd-60a37dd0fd75 is already settled by stl_EUR_2988975 line 85
- fee differencethe fee is not the contract feethe fee is 42, the contract says 37
- fee differencethe fee is not the contract feethe fee is 55, the contract says 50
- missing linein the books, not in the filecapture:01a18e16-9dcd-70a8-935a-0c3a15966117 is in no file
- missing linein the books, not in the filecapture:01a18e1c-1b34-72f1-a319-a51bd2febd78 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 42 | capture | 01a18e16-7ed8-70f8-9164-b95c1b2b2fef | €15.00 | €0.26 | duplicate line |
| 86 | capture | 01a18e1a-00ea-7e17-a880-0226b647b9fe | €15.00 | €0.26 | duplicate line |
| 89 | capture | 01a18e1a-5a56-75d2-be09-93261993387c | €24.00 | €0.42 | fee difference |
| 92 | capture | 01a18e1a-9ab1-7a59-bb87-d55c4fed6513 | €35.00 | €0.55 | fee difference |
| 1 | capture | 01a18e13-920b-7fa0-8771-3352257318b8 | €9.00 | €0.19 | matched |
| 2 | refund | 01a18e13-ae33-767d-83b9-3c2d7061bb0a | -€9.00 | €0.00 | matched |
| 3 | capture | 01a18e13-b4da-7967-8573-f5f6c64a9415 | €49.00 | €0.67 | matched |
| 4 | capture | 01a18e13-c31d-7923-be6a-8a51f0affcb9 | €15.00 | €0.26 | matched |
| 5 | capture | 01a18e13-c0bd-7290-ab7c-a997f3168839 | €15.00 | €0.26 | matched |
| 6 | capture | 01a18e13-e03e-7561-b23b-26cf6ad18f3c | €9.00 | €0.19 | matched |
| 7 | capture | 01a18e13-e3b0-7ced-a166-94e7362b3ece | €24.00 | €0.37 | matched |
| 8 | capture | 01a18e13-f036-7826-9084-4414cd9f86fc | €15.00 | €0.26 | matched |
| 9 | capture | 01a18e13-f7c6-7c4d-a07c-6d74e43b557f | €49.00 | €0.67 | matched |
| 10 | capture | 01a18e14-02e4-7e20-b909-72fafdb8f09c | €9.00 | €0.19 | matched |
| 11 | capture | 01a18e14-213f-7442-b3c6-34d90daeb613 | €49.00 | €0.67 | matched |
| 12 | capture | 01a18e14-539d-7a8a-95ad-90f3a6271a5c | €49.00 | €0.67 | matched |
| 13 | refund | 01a18e14-61c4-7ddf-be8f-fe1dfaad2aac | -€4.00 | €0.00 | matched |
| 14 | capture | 01a18e14-79d3-73eb-a77c-599166d07d9d | €15.00 | €0.26 | matched |
| 15 | capture | 01a18e14-a094-7458-8211-511fe1f032ce | €49.00 | €0.67 | matched |
| 16 | capture | 01a18e14-a646-74e7-bde1-2a56f8e094d0 | €15.00 | €0.26 | matched |
| 17 | capture | 01a18e14-acd8-7057-b2af-fce68acc86ad | €24.00 | €0.37 | matched |
| 18 | capture | 01a18e14-d5b8-78ac-b490-45e70a328ec9 | €9.00 | €0.19 | matched |
| 19 | capture | 01a18e14-e6f5-7c03-8254-d23bd3e1de99 | €24.00 | €0.37 | matched |
| 20 | refund | 01a18e14-eeb3-728e-95c8-6f69e37a4737 | -€5.00 | €0.00 | matched |
| 21 | refund | 01a18e15-0b7d-710e-aef7-bcb87bebf222 | -€13.00 | €0.00 | matched |
| 22 | capture | 01a18e15-0f62-7b59-bfdc-df884157906b | €49.00 | €0.67 | matched |
| 23 | refund | 01a18e15-16a4-7f14-b1df-b7503c91dbac | -€6.00 | €0.00 | matched |
| 24 | capture | 01a18e15-1f2f-7796-9fb8-881f528bf8a3 | €15.00 | €0.26 | matched |
| 25 | capture | 01a18e15-4043-72c0-9257-45d8eeab258a | €9.00 | €0.19 | matched |
| 26 | capture | 01a18e15-51dc-782e-ad26-25750d979466 | €49.00 | €0.67 | matched |
| 27 | capture | 01a18e15-5f65-7b82-9283-ef838a06e744 | €24.00 | €0.37 | matched |
| 28 | capture | 01a18e15-846a-7074-9708-f448f0c52f34 | €24.00 | €0.37 | matched |
| 29 | capture | 01a18e15-91c9-7564-bcbe-3a7dae1d2e18 | €15.00 | €0.26 | matched |
| 30 | capture | 01a18e15-9257-750e-8540-329fc7927bf4 | €9.00 | €0.19 | matched |
| 31 | capture | 01a18e15-a304-7a4f-bdf7-07cdd8b25f5b | €35.00 | €0.50 | matched |
| 32 | capture | 01a18e15-fc6f-70c4-a3a0-193a4260dc3f | €49.00 | €0.67 | matched |
| 33 | capture | 01a18e16-08d2-789c-a58c-5060dc9a1af8 | €9.00 | €0.19 | matched |
| 34 | capture | 01a18e16-0a76-774b-a493-3b890e352ec1 | €9.00 | €0.19 | matched |
| 35 | capture | 01a18e16-293b-7037-8a35-cd1303026aa9 | €35.00 | €0.50 | matched |
| 36 | capture | 01a18e16-3cbd-70e2-9d5c-c3361c6bc0e3 | €49.00 | €0.67 | matched |
| 37 | capture | 01a18e16-3d69-7171-b1c1-965af743a6c5 | €15.00 | €0.26 | matched |
| 38 | capture | 01a18e16-47f5-794f-a994-b59237cf9084 | €15.00 | €0.26 | matched |
| 39 | capture | 01a18e16-47f7-7811-abf7-1d041b2632b7 | €49.00 | €0.67 | matched |
| 40 | capture | 01a18e16-62b5-714c-86e1-6683f9aa135a | €15.00 | €0.26 | matched |
| 41 | capture | 01a18e16-7ed8-70f8-9164-b95c1b2b2fef | €15.00 | €0.26 | matched |
| 43 | refund | 01a18e16-7f24-7c51-88e3-a77d91f196ff | -€20.00 | €0.00 | matched |
| 44 | capture | 01a18e16-83f3-7c7e-b314-28d45ccd2bfe | €49.00 | €0.67 | matched |
| 45 | capture | 01a18e16-86a8-7d35-ab1d-00540b906c75 | €24.00 | €0.37 | matched |
| 46 | capture | 01a18e16-a51f-7fa7-8bf9-7ca63270ac82 | €35.00 | €0.50 | matched |
| 47 | refund | 01a18e16-acb6-7d7d-b028-5427c5043b02 | -€8.00 | €0.00 | matched |
| 48 | capture | 01a18e16-c4db-726e-be05-e959e5d9fb0c | €15.00 | €0.26 | matched |
| 49 | capture | 01a18e16-fd51-7725-a9d4-758e7c90b43d | €15.00 | €0.26 | matched |
| 50 | capture | 01a18e17-00c3-7f56-a2db-8d2efc924c31 | €24.00 | €0.37 | matched |
| 51 | capture | 01a18e17-0671-73fc-bc75-e7d4560b228b | €9.00 | €0.19 | matched |
| 52 | capture | 01a18e17-1e80-763f-b307-d7e8a93982b2 | €9.00 | €0.19 | matched |
| 53 | capture | 01a18e17-2336-7391-995e-9a7e8ed1409e | €35.00 | €0.50 | matched |
| 54 | refund | 01a18e17-4359-7ce7-92bd-d6144367e7ae | -€6.00 | €0.00 | matched |
| 55 | capture | 01a18e17-45b0-770f-94fe-aba37475133f | €24.00 | €0.37 | matched |
| 56 | capture | 01a18e17-5165-73c3-8b08-75b37f3ec7cc | €9.00 | €0.19 | matched |
| 57 | capture | 01a18e17-5405-79fc-a521-4c5d870fcb6d | €9.00 | €0.19 | matched |
| 58 | capture | 01a18e17-5d07-7c73-8645-7728c2e51e00 | €15.00 | €0.26 | matched |
| 59 | capture | 01a18e17-66aa-7886-9cb5-7bce8cfaf00f | €15.00 | €0.26 | matched |
| 60 | capture | 01a18e17-6da2-7545-a9ec-77a1d9613529 | €49.00 | €0.67 | matched |
| 61 | capture | 01a18e17-6f7c-70a5-acb2-49732cd9aad8 | €49.00 | €0.67 | matched |
| 62 | refund | 01a18e17-7640-754e-8c7f-9bda40646048 | -€18.00 | €0.00 | matched |
| 63 | capture | 01a18e17-c763-7204-956b-27a10129f886 | €15.00 | €0.26 | matched |
| 64 | capture | 01a18e17-c8c1-7b80-9d01-d4f808ecdbbc | €35.00 | €0.50 | matched |
| 65 | capture | 01a18e17-d991-7a39-b44e-58105268c96f | €24.00 | €0.37 | matched |
| 66 | capture | 01a18e17-e04b-728b-abc7-8e7278c39f43 | €24.00 | €0.37 | matched |
| 67 | capture | 01a18e17-eb10-7a46-9be7-d9f75b1ce6b8 | €35.00 | €0.50 | matched |
| 68 | capture | 01a18e17-efe4-78b2-a60b-048c3fc2af33 | €49.00 | €0.67 | matched |
| 69 | capture | 01a18e17-fc07-7bd6-ae22-48706af35a57 | €35.00 | €0.50 | matched |
| 70 | capture | 01a18e18-33d0-7b2b-be62-63ea26639447 | €24.00 | €0.37 | matched |
| 71 | capture | 01a18e18-3741-754b-8db0-5248e909f38a | €9.00 | €0.19 | matched |
| 72 | capture | 01a18e18-9ae1-7a2d-836a-bd81306a279f | €35.00 | €0.50 | matched |
| 73 | capture | 01a18e18-a1a5-7881-bbbe-310446b75e02 | €35.00 | €0.50 | matched |
| 74 | capture | 01a18e18-c989-7985-9fac-3739ef4f57ed | €35.00 | €0.50 | matched |
| 75 | capture | 01a18e18-dc3c-7c6a-ac6d-34a26b4bbc4f | €9.00 | €0.19 | matched |
| 76 | capture | 01a18e18-f9d7-7047-80a6-1e7cc739ff5b | €15.00 | €0.26 | matched |
| 77 | capture | 01a18e19-259c-77a4-a981-267d6f35e718 | €24.00 | €0.37 | matched |
| 78 | capture | 01a18e19-2d94-7d47-958f-e6b033d033d1 | €35.00 | €0.50 | matched |
| 79 | capture | 01a18e19-2f9d-7aad-9b9c-5eee0f3bcb1d | €9.00 | €0.19 | matched |
| 80 | capture | 01a18e19-4b12-7971-9861-d8009355873a | €9.00 | €0.19 | matched |
| 81 | capture | 01a18e19-53b7-7ca0-9deb-b4d7d0d70d12 | €24.00 | €0.37 | matched |
| 82 | capture | 01a18e19-88d6-7304-b10d-d9b1b70c424a | €15.00 | €0.26 | matched |
| 83 | capture | 01a18e19-9959-76e6-be47-c664c996f680 | €24.00 | €0.37 | matched |
| 84 | capture | 01a18e19-da29-7337-b632-561512247357 | €24.00 | €0.37 | matched |
| 85 | capture | 01a18e1a-00ea-7e17-a880-0226b647b9fe | €15.00 | €0.26 | matched |
| 87 | capture | 01a18e1a-1e3a-7959-87e1-cbeb6ecfdde2 | €35.00 | €0.50 | matched |
| 88 | refund | 01a18e1a-591f-7231-94a9-ffc3b99a20ba | -€6.00 | €0.00 | matched |
| 90 | capture | 01a18e1a-66af-74fb-943d-4d4890f9e38d | €15.00 | €0.26 | matched |
| 91 | capture | 01a18e1a-7aae-7195-a2b6-a0cddef24de8 | €49.00 | €0.67 | matched |
| 93 | capture | 01a18e1a-9c9c-7527-afd9-6343aac02870 | €35.00 | €0.50 | matched |
| 94 | capture | 01a18e1a-c5fc-70b1-a764-4cdbb86afb32 | €24.00 | €0.37 | matched |
| 95 | capture | 01a18e1a-d443-7eac-b4f7-c08a81b230bf | €9.00 | €0.19 | matched |
| 96 | capture | 01a18e1a-d5c8-7633-8739-781e6ccb9e23 | €49.00 | €0.67 | matched |
| 97 | capture | 01a18e1a-e226-7e98-85ca-f4fd05250efc | €15.00 | €0.26 | matched |
| 98 | refund | 01a18e1b-04d0-7c5c-8f0e-945176df535b | -€32.00 | €0.00 | matched |
| 99 | capture | 01a18e1b-1077-7086-8276-784292ef9580 | €9.00 | €0.19 | matched |
| 100 | capture | 01a18e1b-1752-702d-9409-e694fbc92a79 | €24.00 | €0.37 | matched |
| 101 | capture | 01a18e1b-49be-7b8c-a40b-7656e95662ef | €24.00 | €0.37 | matched |
| 102 | capture | 01a18e1b-4f8d-784e-9972-35461ec17c17 | €35.00 | €0.50 | matched |
| 103 | capture | 01a18e1b-5975-751d-b59f-c80cef0a0f39 | €15.00 | €0.26 | matched |
| 104 | capture | 01a18e1b-7d16-744c-bd30-18bde438e574 | €9.00 | €0.19 | matched |
| 105 | capture | 01a18e1b-97bd-7811-a79f-afe97523b390 | €35.00 | €0.50 | matched |
| 106 | capture | 01a18e1b-b3ce-706a-b5be-73902973d400 | €35.00 | €0.50 | matched |
| 107 | capture | 01a18e1b-bb7b-7fb3-81da-dadf238172df | €15.00 | €0.26 | matched |
| 108 | capture | 01a18e1b-dc67-7a5e-a56e-65687d9eb781 | €24.00 | €0.37 | matched |
| 109 | capture | 01a18e1b-e11e-7500-ad3a-c8b362754001 | €35.00 | €0.50 | matched |
| 110 | capture | 01a18e1b-e77c-707a-8724-c891ceecb73e | €15.00 | €0.26 | matched |
| 111 | capture | 01a18e1b-fab1-773f-a9c7-2a547865dd11 | €35.00 | €0.50 | matched |
| 112 | refund | 01a18e1c-082f-7f41-9112-063d28d0fc75 | -€30.00 | €0.00 | matched |
| 113 | capture | 01a18e1c-138d-70a9-a7b0-d444769fd3a2 | €49.00 | €0.67 | matched |
| 114 | capture | 01a18e1c-1406-724b-a51d-e578d3d94e3a | €24.00 | €0.37 | matched |
| 115 | capture | 01a18e1c-1631-741a-bcaf-2c5aed4ba051 | €15.00 | €0.26 | matched |
| 116 | capture | 01a18e1c-1e5b-7d74-b63e-b1183b2cfca5 | €24.00 | €0.37 | matched |
| 117 | capture | 01a18e1c-2f35-7b4e-a07d-49dba848b656 | €15.00 | €0.26 | matched |
| 118 | capture | 01a18e1c-2e2c-784d-8b9c-1ec82ee3be13 | €35.00 | €0.50 | matched |
| 119 | capture | 01a18e1c-38ec-74a4-9773-ef80585c54f4 | €24.00 | €0.37 | matched |
| 120 | capture | 01a18e1c-4b40-703d-82b8-fd9d3bd8cf82 | €9.00 | €0.19 | matched |
| 121 | capture | 01a18e1c-5ca0-723d-8226-d2c3eca0b344 | €24.00 | €0.37 | matched |
| 122 | refund | 01a18e1c-81fa-7a34-962e-e833f20c89a9 | -€13.00 | €0.00 | matched |
| 123 | capture | 01a18e1c-8389-726c-bdde-fe3d96ce9af1 | €24.00 | €0.37 | matched |
| 124 | capture | 01a18e1c-8927-77e0-812c-9e3fc33b4c06 | €35.00 | €0.50 | matched |