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
- 2 Nov, 02:30136 lines3 breaks
- 2 Nov, 02:20137 lines5 breaks
- 2 Nov, 02:10129 lines1 break
- 2 Nov, 02:00100 lines2 breaks
- 2 Nov, 01:50133 lines6 breaks
- 2 Nov, 01:40121 lines2 breaks
- 2 Nov, 01:30140 lines3 breaks
- 2 Nov, 01:20119 lines1 break
- 2 Nov, 01:10113 lines1 break
- 2 Nov, 01:00122 lines1 break
- 2 Nov, 00:50136 lines6 breaks
- 2 Nov, 00:40125 lines3 breaks
- 2 Nov, 00:30124 lines5 breaks
- 2 Nov, 00:20110 linesclean
2 Nov, 01:30
Gross
€3,094.00
PSP fee
€51.50
Net to the bank
€3,042.50
Settlement journal
#334505
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a199e6-4f40-70e1-9872-b845c97e7c20 is already settled by stl_EUR_2989305 line 92
- duplicate linethe file lists it twicecapture:01a199e7-d049-77fd-9cae-c2ab5bccc9d6 is already settled by stl_EUR_2989305 line 108
- missing linein the books, not in the filecapture:01a199e0-fd30-7464-9881-681c6f857460 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 93 | capture | 01a199e6-62c0-74e0-ab41-9b51cf845bb0 | €35.00 | €0.50 | duplicate line |
| 109 | capture | 01a199e7-d075-7184-b1b0-ebae52f8f659 | €49.00 | €0.67 | duplicate line |
| 1 | capture | 01a199d8-c69e-7641-9a44-549ce922dd8b | €9.00 | €0.19 | matched |
| 2 | capture | 01a199e0-bf98-7eed-8df0-a7af34fb97d6 | €15.00 | €0.26 | matched |
| 3 | capture | 01a199e0-d923-7823-af11-9a47d3f92e7d | €49.00 | €0.67 | matched |
| 4 | capture | 01a199e0-da7d-7757-9cbd-937f906499e3 | €15.00 | €0.26 | matched |
| 5 | capture | 01a199e0-defe-7c6d-94cb-253a0681e94f | €24.00 | €0.37 | matched |
| 6 | capture | 01a199e1-0bfc-7f26-a022-cd1d2e9139e0 | €15.00 | €0.26 | matched |
| 7 | capture | 01a199e1-0f7a-774a-8a2e-57d5d8c5fa34 | €35.00 | €0.50 | matched |
| 8 | capture | 01a199e1-18ee-70e7-aaf2-967f10577ada | €35.00 | €0.50 | matched |
| 9 | refund | 01a199e1-1b85-7055-905b-25afa5ebb00d | -€14.00 | €0.00 | matched |
| 10 | capture | 01a199e1-1d98-75b8-b889-8702b0aa9077 | €49.00 | €0.67 | matched |
| 11 | capture | 01a199e1-4bc4-7703-8c71-25b704dab6ab | €49.00 | €0.67 | matched |
| 12 | capture | 01a199e1-5fb1-713a-8b8c-684c4426b151 | €49.00 | €0.67 | matched |
| 13 | capture | 01a199e1-625d-70d2-b15b-d6b24493c322 | €15.00 | €0.26 | matched |
| 14 | refund | 01a199e1-72c2-778e-bb04-fb2f77364358 | -€8.00 | €0.00 | matched |
| 15 | capture | 01a199e1-7f96-7190-9669-296618c73089 | €49.00 | €0.67 | matched |
| 16 | capture | 01a199e1-89b6-79d4-a025-bc0cd036faec | €35.00 | €0.50 | matched |
| 17 | capture | 01a199e1-90d4-7aab-af2f-8106fc527e2f | €24.00 | €0.37 | matched |
| 18 | capture | 01a199e1-9840-71ec-bf5d-7a07b50884a0 | €9.00 | €0.19 | matched |
| 19 | capture | 01a199e1-9c6c-7d94-aaee-e5aeb93d7b2c | €49.00 | €0.67 | matched |
| 20 | capture | 01a199e1-9e31-704d-9742-0f6356d2ed31 | €49.00 | €0.67 | matched |
| 21 | capture | 01a199e1-a554-738b-b486-4d387a373b79 | €49.00 | €0.67 | matched |
| 22 | capture | 01a199e1-c1ef-7a8b-9d29-a13802527cd6 | €15.00 | €0.26 | matched |
| 23 | capture | 01a199e1-c294-7968-827c-effa9227d3a2 | €24.00 | €0.37 | matched |
| 24 | capture | 01a199e1-c52e-76b4-a2b7-056bc738a6b7 | €35.00 | €0.50 | matched |
| 25 | capture | 01a199e1-df6b-775e-a3f9-d9b20ef45c4a | €24.00 | €0.37 | matched |
| 26 | capture | 01a199e1-e054-7a61-b6b3-20157fcb5e92 | €15.00 | €0.26 | matched |
| 27 | capture | 01a199e1-eb6f-7a1d-91e0-1466dd960435 | €15.00 | €0.26 | matched |
| 28 | refund | 01a199e1-ef23-7243-8549-576fe0f5dcd6 | -€33.00 | €0.00 | matched |
| 29 | refund | 01a199e2-0ab6-7ab3-b015-14b70e46a8e7 | -€7.00 | €0.00 | matched |
| 30 | refund | 01a199e2-297d-7ed8-a67f-d0064bf88b1d | -€11.00 | €0.00 | matched |
| 31 | capture | 01a199e2-3c3d-7934-bc23-997e7301e70d | €49.00 | €0.67 | matched |
| 32 | capture | 01a199e2-3e94-7381-b6f4-cb4285be4774 | €9.00 | €0.19 | matched |
| 33 | capture | 01a199e2-54c9-7170-90a5-f56859f16e23 | €15.00 | €0.26 | matched |
| 34 | capture | 01a199e2-855e-7828-ab7e-2d7555bc2e82 | €9.00 | €0.19 | matched |
| 35 | capture | 01a199e2-8c9b-7326-b5cf-c0e47ba53521 | €24.00 | €0.37 | matched |
| 36 | capture | 01a199e2-92bc-7a36-991c-5574e3505d5e | €35.00 | €0.50 | matched |
| 37 | capture | 01a199e2-aa86-7f9e-8a27-594ab5bac42f | €15.00 | €0.26 | matched |
| 38 | capture | 01a199e2-b21a-769a-a462-66af14c213d2 | €49.00 | €0.67 | matched |
| 39 | capture | 01a199e2-b280-7cb2-a0f8-6eff1c59084e | €9.00 | €0.19 | matched |
| 40 | capture | 01a199e3-0822-7f5d-91d1-14a8738c85d5 | €15.00 | €0.26 | matched |
| 41 | capture | 01a199e3-309b-7ab3-83e4-36eea4b92b2b | €15.00 | €0.26 | matched |
| 42 | capture | 01a199e3-3d6e-7b9b-a51a-1a77e64de1e8 | €49.00 | €0.67 | matched |
| 43 | capture | 01a199e3-3f3a-7080-85f6-bd86b7c44b0f | €35.00 | €0.50 | matched |
| 44 | capture | 01a199e3-482c-7c5e-aa0e-6be889335fbf | €15.00 | €0.26 | matched |
| 45 | capture | 01a199e3-4b1d-7877-80cd-88854e6e7213 | €9.00 | €0.19 | matched |
| 46 | capture | 01a199e3-5eca-766a-837a-ab6f9c23eacd | €9.00 | €0.19 | matched |
| 47 | capture | 01a199e3-631a-7901-80eb-8dcd5a52270c | €49.00 | €0.67 | matched |
| 48 | capture | 01a199e3-732c-770a-8f06-8015d0633f3e | €35.00 | €0.50 | matched |
| 49 | capture | 01a199e3-746b-7df1-8844-781605e79328 | €35.00 | €0.50 | matched |
| 50 | capture | 01a199e3-736c-77bb-9176-4f2b1a77abbf | €15.00 | €0.26 | matched |
| 51 | capture | 01a199e3-88ba-7650-97e5-bf2ff78d9795 | €35.00 | €0.50 | matched |
| 52 | capture | 01a199e3-938b-724a-a773-c530467071f8 | €15.00 | €0.26 | matched |
| 53 | capture | 01a199e3-b58c-7f6f-aaa8-54869ad1ad9b | €9.00 | €0.19 | matched |
| 54 | capture | 01a199e3-b615-7254-8bb6-9a4efd20b9dc | €15.00 | €0.26 | matched |
| 55 | capture | 01a199e3-cba9-7924-ac93-f541bf3ae5ce | €35.00 | €0.50 | matched |
| 56 | capture | 01a199e3-ce61-7ed7-a198-38be1fe78a7f | €9.00 | €0.19 | matched |
| 57 | capture | 01a199e3-e2d3-7ff0-9287-2155ea8193ca | €24.00 | €0.37 | matched |
| 58 | capture | 01a199e3-f307-73b6-b078-bcf0673b7ecb | €49.00 | €0.67 | matched |
| 59 | capture | 01a199e4-16bb-72ae-b3bc-e7e9abf4a216 | €49.00 | €0.67 | matched |
| 60 | capture | 01a199e4-11c8-78c2-9dc0-9c2514ee5ddc | €15.00 | €0.26 | matched |
| 61 | capture | 01a199e4-1c54-7000-b22d-aeb303ec6cd0 | €35.00 | €0.50 | matched |
| 62 | capture | 01a199e4-20e7-7e63-a702-35e26d7ab4fe | €49.00 | €0.67 | matched |
| 63 | capture | 01a199e4-26b5-7123-8345-e020fb58c6ed | €15.00 | €0.26 | matched |
| 64 | capture | 01a199e4-3eae-7dba-a82f-656d3d57a400 | €9.00 | €0.19 | matched |
| 65 | refund | 01a199e4-4ba8-7430-881c-c32e87f430f1 | -€6.00 | €0.00 | matched |
| 66 | capture | 01a199e4-5484-7ca0-bb7d-f1ba62f7a59a | €35.00 | €0.50 | matched |
| 67 | refund | 01a199e4-57c2-72cf-ac54-d2bfdb9ea6ea | -€32.00 | €0.00 | matched |
| 68 | refund | 01a199e4-5b25-72f8-9823-cbf706d3c4aa | -€12.00 | €0.00 | matched |
| 69 | capture | 01a199e4-5b7f-79b8-8143-eae128904c56 | €24.00 | €0.37 | matched |
| 70 | capture | 01a199e4-8b96-78a1-ba14-9d0e2d032bfa | €9.00 | €0.19 | matched |
| 71 | capture | 01a199e4-92ba-7961-98d2-5897afa96c7d | €9.00 | €0.19 | matched |
| 72 | refund | 01a199e4-b677-7db2-b69d-1436847f0e9d | -€22.00 | €0.00 | matched |
| 73 | capture | 01a199e4-db74-79b2-8c77-96e836b3947d | €9.00 | €0.19 | matched |
| 74 | capture | 01a199e5-0c88-7941-b5ab-2e8ed9a6f57a | €9.00 | €0.19 | matched |
| 75 | capture | 01a199e5-0e1f-75cf-a6ae-af9bd8598a14 | €9.00 | €0.19 | matched |
| 76 | capture | 01a199e5-12c9-79ef-83ee-692400721b2b | €35.00 | €0.50 | matched |
| 77 | capture | 01a199e5-2e2f-7fd7-b476-ae10b37524e4 | €9.00 | €0.19 | matched |
| 78 | capture | 01a199e5-3465-7ffc-8425-ca86b1160bdb | €24.00 | €0.37 | matched |
| 79 | capture | 01a199e5-6245-7336-a85b-814c0288b9cb | €35.00 | €0.50 | matched |
| 80 | capture | 01a199e5-86e0-7d55-899e-5917444e335c | €35.00 | €0.50 | matched |
| 81 | capture | 01a199e5-9d41-7ee5-94ae-da5079a74568 | €15.00 | €0.26 | matched |
| 82 | capture | 01a199e5-b19d-72d3-9f8b-57ca667241e1 | €24.00 | €0.37 | matched |
| 83 | capture | 01a199e5-be82-7314-bc77-dea7f0952604 | €49.00 | €0.67 | matched |
| 84 | capture | 01a199e5-cfe5-7c67-b294-1a01f684076d | €24.00 | €0.37 | matched |
| 85 | capture | 01a199e5-cfec-75cb-bc5d-cf0ab447935e | €35.00 | €0.50 | matched |
| 86 | capture | 01a199e5-e5d1-75e0-9790-4633c160eb52 | €49.00 | €0.67 | matched |
| 87 | capture | 01a199e5-eabc-7d05-ba2c-3de9dde77ee2 | €49.00 | €0.67 | matched |
| 88 | refund | 01a199e5-f399-7dce-b965-392cb1e4ee22 | -€30.00 | €0.00 | matched |
| 89 | capture | 01a199e6-111a-7d03-b51e-bf2256ef574b | €24.00 | €0.37 | matched |
| 90 | refund | 01a199e6-1dca-7fbf-bbdb-b3fcb4ee47d7 | -€45.00 | €0.00 | matched |
| 91 | capture | 01a199e6-248a-7d12-a887-fa021645f9c6 | €35.00 | €0.50 | matched |
| 92 | capture | 01a199e6-62c0-74e0-ab41-9b51cf845bb0 | €35.00 | €0.50 | matched |
| 94 | capture | 01a199e6-9da8-7ecd-aae9-96d85fb427c3 | €24.00 | €0.37 | matched |
| 95 | capture | 01a199e6-a642-71a2-a7d2-f5ebf7a74ae8 | €49.00 | €0.67 | matched |
| 96 | capture | 01a199e6-b6fa-7498-9047-82bd3b9e0489 | €15.00 | €0.26 | matched |
| 97 | refund | 01a199e6-bc4b-7e3d-8a55-4db95366985c | -€19.00 | €0.00 | matched |
| 98 | capture | 01a199e6-be0f-7472-988b-780caa15c724 | €49.00 | €0.67 | matched |
| 99 | capture | 01a199e6-cab3-7da9-b644-036eefea6c69 | €9.00 | €0.19 | matched |
| 100 | capture | 01a199e6-d0ba-7489-bb41-c57f86285b50 | €24.00 | €0.37 | matched |
| 101 | capture | 01a199e6-d2bc-766b-9fcc-43db2e667e97 | €15.00 | €0.26 | matched |
| 102 | capture | 01a199e6-edb8-765c-90be-1e7031e6be6f | €9.00 | €0.19 | matched |
| 103 | capture | 01a199e6-f2dc-7947-a235-655a8be48881 | €49.00 | €0.67 | matched |
| 104 | refund | 01a199e6-faa7-7147-9aed-3c4a5514bfd1 | -€24.00 | €0.00 | matched |
| 105 | capture | 01a199e7-0a3d-76ae-a69f-90f772be951c | €49.00 | €0.67 | matched |
| 106 | capture | 01a199e7-19df-75a3-befc-096b78e0c88b | €15.00 | €0.26 | matched |
| 107 | capture | 01a199e7-5fd8-76cf-bff4-64b390d83fcb | €15.00 | €0.26 | matched |
| 108 | capture | 01a199e7-d075-7184-b1b0-ebae52f8f659 | €49.00 | €0.67 | matched |
| 110 | capture | 01a199e7-d6e0-7eb4-b1c4-7ac6e9c74fd2 | €24.00 | €0.37 | matched |
| 111 | capture | 01a199e7-d87d-7333-846c-ee49ab66da3e | €9.00 | €0.19 | matched |
| 112 | capture | 01a199e7-dfc9-7935-92d8-9709e528cf4b | €15.00 | €0.26 | matched |
| 113 | capture | 01a199e7-e0dd-766f-a226-5985d570432b | €15.00 | €0.26 | matched |
| 114 | capture | 01a199e7-ee87-7aa3-9ea4-1d8b8140fc69 | €49.00 | €0.67 | matched |
| 115 | capture | 01a199e8-0bf8-7dd1-87e5-f3a55db175c3 | €35.00 | €0.50 | matched |
| 116 | capture | 01a199e8-1096-71f4-b81f-6a0e46f385b2 | €24.00 | €0.37 | matched |
| 117 | refund | 01a199e8-1911-70c9-8c08-ae3a1e96b25f | -€49.00 | €0.00 | matched |
| 118 | refund | 01a199e8-3c7d-7563-badb-23f3210d7e4b | -€12.00 | €0.00 | matched |
| 119 | capture | 01a199e8-6a39-7844-83c1-2a056185c534 | €35.00 | €0.50 | matched |
| 120 | capture | 01a199e8-80ca-7348-83f7-6c4373deb6c6 | €49.00 | €0.67 | matched |
| 121 | capture | 01a199e8-9cd8-7716-9a7b-83dbf0a17959 | €35.00 | €0.50 | matched |
| 122 | capture | 01a199e8-a976-741b-89e7-45cc61ade234 | €49.00 | €0.67 | matched |
| 123 | capture | 01a199e8-af84-7097-81b8-1d5801e1cc81 | €24.00 | €0.37 | matched |
| 124 | capture | 01a199e8-b8b2-7483-ae93-60c5ef67a8f7 | €15.00 | €0.26 | matched |
| 125 | capture | 01a199e8-bd47-73ae-af67-fb8e5c32a9ed | €35.00 | €0.50 | matched |
| 126 | capture | 01a199e8-bd5a-7e09-b2c2-5761979bd77d | €49.00 | €0.67 | matched |
| 127 | capture | 01a199e8-cc50-7fd6-a2be-ced11805f618 | €49.00 | €0.67 | matched |
| 128 | capture | 01a199e8-ce97-7e7b-8dad-bce533dbb2e5 | €49.00 | €0.67 | matched |
| 129 | capture | 01a199e8-dce9-755e-964f-7e89e175cb21 | €35.00 | €0.50 | matched |
| 130 | capture | 01a199e9-030f-7d10-8b6d-9d97fd99acb5 | €15.00 | €0.26 | matched |
| 131 | capture | 01a199e9-17c9-7cce-b4f1-82eb9750b1de | €15.00 | €0.26 | matched |
| 132 | capture | 01a199e9-236a-7d59-909c-d91c89bf150a | €49.00 | €0.67 | matched |
| 133 | capture | 01a199e9-25bd-7dcd-8ac6-6d92ee987d57 | €15.00 | €0.26 | matched |
| 134 | capture | 01a199e9-31e1-7d9e-9bf3-804ff1da1758 | €49.00 | €0.67 | matched |
| 135 | capture | 01a199e9-4c25-7171-adca-8b9d34067b75 | €9.00 | €0.19 | matched |
| 136 | refund | 01a199e9-6783-79b7-8799-121f2d8b1e16 | -€36.00 | €0.00 | matched |
| 137 | capture | 01a199e9-6f1e-73af-a0bd-01b1e4c8e31e | €9.00 | €0.19 | matched |
| 138 | capture | 01a199e9-71ef-7732-a61f-868688acf18a | €35.00 | €0.50 | matched |
| 139 | capture | 01a199e9-bc89-7468-960e-0301475e893d | €24.00 | €0.37 | matched |
| 140 | refund | 01a199e9-c227-79e8-8077-1b1c7fa88008 | -€6.00 | €0.00 | matched |