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
- 20 Oct, 00:40137 lines3 breaks
- 20 Oct, 00:30113 lines3 breaks
- 20 Oct, 00:20122 linesclean
- 20 Oct, 00:10124 linesclean
- 20 Oct, 00:00121 lines4 breaks
- 19 Oct, 23:50148 lines4 breaks
- 19 Oct, 23:40121 lines3 breaks
- 19 Oct, 23:30112 lines2 breaks
- 19 Oct, 23:20109 lines4 breaks
- 19 Oct, 23:10121 lines1 break
- 19 Oct, 23:00107 lines2 breaks
- 19 Oct, 22:50127 lines3 breaks
- 19 Oct, 22:40121 lines3 breaks
- 19 Oct, 22:30135 lines2 breaks
19 Oct, 23:50
Gross
€3,426.00
PSP fee
€54.25
Net to the bank
€3,371.75
Settlement journal
#95738
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a15694-5fc8-7a04-b234-72363f3d69db is already settled by stl_EUR_2987423 line 41
- fee differencethe fee is not the contract feethe fee is 53, the contract says 50
- fee differencethe fee is not the contract feethe fee is 70, the contract says 67
- missing linein the books, not in the filecapture:01a15698-b3a4-777a-8868-884e42b74c0f is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 2 | capture | 01a1568a-e457-7f91-a9dc-823f3713d08b | €15.00 | €0.26 | duplicate line |
| 42 | refund | 01a15694-5fca-71f0-b3b8-a5701e9902ec | -€3.00 | €0.00 | duplicate line |
| 99 | capture | 01a15697-ddf3-710e-af85-f174281a179c | €35.00 | €0.53 | fee difference |
| 139 | capture | 01a1569a-e282-7591-a2a8-8c8fe17194b6 | €49.00 | €0.70 | fee difference |
| 1 | capture | 01a1568a-e457-7f91-a9dc-823f3713d08b | €15.00 | €0.26 | matched |
| 3 | capture | 01a1568c-1ed9-71a2-a7b7-a86b18413f99 | €49.00 | €0.67 | matched |
| 4 | capture | 01a1568f-201a-793c-b7d5-9aaf2787a3b6 | €9.00 | €0.19 | matched |
| 5 | capture | 01a1568f-ba19-7094-9c47-2c45511633e1 | €24.00 | €0.37 | matched |
| 6 | capture | 01a1568f-c492-7cdf-b4c5-eaa3db1dbfcb | €9.00 | €0.19 | matched |
| 7 | refund | 01a15690-1bbe-724c-8791-421d479c967b | -€3.00 | €0.00 | matched |
| 8 | capture | 01a15690-862f-7e5a-88d5-8c4ab9c8490b | €9.00 | €0.19 | matched |
| 9 | capture | 01a15692-2e87-738b-9dcb-41cc99d14903 | €49.00 | €0.67 | matched |
| 10 | capture | 01a15692-73b2-7f05-ba05-656ce7693f4e | €24.00 | €0.37 | matched |
| 11 | capture | 01a15692-84b7-71e0-a4a9-dd1c1a666d0a | €49.00 | €0.67 | matched |
| 12 | capture | 01a15692-8b57-7d9f-9c80-b2e3ad5e350f | €15.00 | €0.26 | matched |
| 13 | capture | 01a15692-97dc-7a46-b33c-8f285e4bea29 | €35.00 | €0.50 | matched |
| 14 | capture | 01a15692-a35f-7d1b-a947-6087b991ebe9 | €9.00 | €0.19 | matched |
| 15 | capture | 01a15692-bfe6-74eb-af2a-89d1db45bcf4 | €15.00 | €0.26 | matched |
| 16 | capture | 01a15692-deac-7ab6-a5a2-2d9ae784af5b | €35.00 | €0.50 | matched |
| 17 | capture | 01a15692-ef54-758a-b301-04a8a6d1b967 | €49.00 | €0.67 | matched |
| 18 | capture | 01a15692-f32a-7079-8270-baf380bdd91c | €35.00 | €0.50 | matched |
| 19 | capture | 01a15692-f3a4-753d-8fa8-b5fd84d9b6ce | €35.00 | €0.50 | matched |
| 20 | capture | 01a15693-0fa4-7577-ac9c-3a706b8715c0 | €15.00 | €0.26 | matched |
| 21 | capture | 01a15693-1244-785a-8769-3839e0b4dda1 | €15.00 | €0.26 | matched |
| 22 | capture | 01a15693-14eb-7691-9fd6-686eb6e1dc11 | €24.00 | €0.37 | matched |
| 23 | capture | 01a15693-3177-7f1b-8033-d757335f6dcd | €35.00 | €0.50 | matched |
| 24 | capture | 01a15693-49cc-7615-b61d-70b3055433b7 | €35.00 | €0.50 | matched |
| 25 | capture | 01a15693-4e03-776e-a450-b63360899c92 | €24.00 | €0.37 | matched |
| 26 | capture | 01a15693-5120-7414-a6a6-05689dc21964 | €15.00 | €0.26 | matched |
| 27 | capture | 01a15693-5351-7fd5-954b-f24b3d2e9e6b | €35.00 | €0.50 | matched |
| 28 | capture | 01a15693-5472-715f-825e-07bed4507e44 | €35.00 | €0.50 | matched |
| 29 | capture | 01a15693-54c7-72c7-b2a2-c8116f1ae88c | €9.00 | €0.19 | matched |
| 30 | capture | 01a15693-5ed4-7f51-b33d-e4ae6edc0c39 | €15.00 | €0.26 | matched |
| 31 | capture | 01a15693-6a4f-77ab-9012-303eea3c29ec | €49.00 | €0.67 | matched |
| 32 | capture | 01a15693-7fc2-789a-9c65-3270d6e9a60d | €24.00 | €0.37 | matched |
| 33 | refund | 01a15693-9b8e-7a89-ac1e-28f7075770cd | -€23.00 | €0.00 | matched |
| 34 | capture | 01a15693-a4c6-743a-9c00-cb318f1d2233 | €35.00 | €0.50 | matched |
| 35 | refund | 01a15693-aafc-752b-8ae3-4d55a75dff3f | -€33.00 | €0.00 | matched |
| 36 | capture | 01a15693-b26c-7ccb-8a11-e4b4f988eb89 | €15.00 | €0.26 | matched |
| 37 | capture | 01a15693-b52f-76d7-be82-01428bdf01af | €15.00 | €0.26 | matched |
| 38 | capture | 01a15693-e604-72c3-999d-0ab1bb5d368a | €24.00 | €0.37 | matched |
| 39 | capture | 01a15694-089d-7f3d-94d8-c0a24397338c | €24.00 | €0.37 | matched |
| 40 | capture | 01a15694-4d33-7f16-be3d-ca0a18359392 | €49.00 | €0.67 | matched |
| 41 | refund | 01a15694-5fca-71f0-b3b8-a5701e9902ec | -€3.00 | €0.00 | matched |
| 43 | capture | 01a15694-5ffd-75d4-a08f-a4032c202ecf | €15.00 | €0.26 | matched |
| 44 | capture | 01a15694-781c-7932-a554-b58f0a1738ba | €35.00 | €0.50 | matched |
| 45 | capture | 01a15694-84e7-7e61-8de2-6ce202bf0d4a | €24.00 | €0.37 | matched |
| 46 | capture | 01a15694-8758-7b93-951e-08ff09c32873 | €24.00 | €0.37 | matched |
| 47 | capture | 01a15694-8762-78dc-9271-4a70b3ed5092 | €15.00 | €0.26 | matched |
| 48 | capture | 01a15694-9389-753a-92c7-c043e844b401 | €35.00 | €0.50 | matched |
| 49 | refund | 01a15694-a19c-72f3-9981-88a238f7d000 | -€35.00 | €0.00 | matched |
| 50 | capture | 01a15694-c611-786c-acb9-9177192064fe | €24.00 | €0.37 | matched |
| 51 | capture | 01a15694-d0ff-7aa2-b637-dbfcc4ae164a | €15.00 | €0.26 | matched |
| 52 | capture | 01a15694-dc88-72c8-a931-26a26e1849e4 | €49.00 | €0.67 | matched |
| 53 | refund | 01a15694-e212-7dc1-83a6-728ae83d8bbe | -€29.00 | €0.00 | matched |
| 54 | capture | 01a15694-e880-7c8e-ae6b-fbd7b4dc6b35 | €24.00 | €0.37 | matched |
| 55 | capture | 01a15694-efa3-733c-848e-408f8b1f2de2 | €9.00 | €0.19 | matched |
| 56 | capture | 01a15695-1749-756d-a803-57f69ab87a12 | €24.00 | €0.37 | matched |
| 57 | capture | 01a15695-1b02-782a-9d74-88d9df38990f | €35.00 | €0.50 | matched |
| 58 | capture | 01a15695-2c48-7394-b1c9-9e31a68c4251 | €9.00 | €0.19 | matched |
| 59 | capture | 01a15695-32db-7d64-9b55-69ef3933e760 | €24.00 | €0.37 | matched |
| 60 | capture | 01a15695-3a41-7437-8fad-c842b9571a89 | €24.00 | €0.37 | matched |
| 61 | capture | 01a15695-65f5-708e-bb8b-cad32e61e8a7 | €24.00 | €0.37 | matched |
| 62 | capture | 01a15695-6ea7-7266-a78f-890a4e4dbf73 | €35.00 | €0.50 | matched |
| 63 | capture | 01a15695-7836-723c-afec-d4804bfde783 | €24.00 | €0.37 | matched |
| 64 | capture | 01a15695-8e37-79bc-a718-85962398b62d | €35.00 | €0.50 | matched |
| 65 | capture | 01a15695-9389-7eea-8d78-f02018bfd6b9 | €24.00 | €0.37 | matched |
| 66 | capture | 01a15695-99a4-75d6-9e89-b0ca2ca52a94 | €24.00 | €0.37 | matched |
| 67 | capture | 01a15695-b5ca-73c3-b2ea-67af431ab869 | €9.00 | €0.19 | matched |
| 68 | capture | 01a15695-d3ed-791b-8f74-b842d1801f71 | €35.00 | €0.50 | matched |
| 69 | capture | 01a15695-de95-7e30-ab28-5634ab72dab9 | €15.00 | €0.26 | matched |
| 70 | capture | 01a15696-0e93-7f80-b23c-83819058f61f | €35.00 | €0.50 | matched |
| 71 | capture | 01a15696-1083-78ae-ab1d-1bb559d57210 | €15.00 | €0.26 | matched |
| 72 | capture | 01a15696-2015-78e4-80b6-b24dda14f7be | €35.00 | €0.50 | matched |
| 73 | capture | 01a15696-42e0-78e4-98fb-c9bdec4eb22b | €24.00 | €0.37 | matched |
| 74 | capture | 01a15696-6705-7655-92c3-dbc22be5e132 | €15.00 | €0.26 | matched |
| 75 | capture | 01a15696-6a92-7524-8d65-046bd3841c2f | €35.00 | €0.50 | matched |
| 76 | capture | 01a15696-7fca-72f9-8a7a-2f51eca5459e | €49.00 | €0.67 | matched |
| 77 | capture | 01a15696-9219-7e7d-b745-c6244435a0f4 | €15.00 | €0.26 | matched |
| 78 | capture | 01a15696-92b5-7893-ab13-f3da6008ba81 | €9.00 | €0.19 | matched |
| 79 | capture | 01a15696-9d35-79a2-a3c0-a49a841c8893 | €35.00 | €0.50 | matched |
| 80 | capture | 01a15696-b44e-728b-a64a-433eb906422f | €15.00 | €0.26 | matched |
| 81 | refund | 01a15696-c331-7181-8208-1da2335aceaf | -€15.00 | €0.00 | matched |
| 82 | capture | 01a15696-cbf1-7470-b465-163bdc368d47 | €9.00 | €0.19 | matched |
| 83 | refund | 01a15696-cf9c-7a98-b016-48e2e4722183 | -€2.00 | €0.00 | matched |
| 84 | capture | 01a15696-d03e-7e12-a55d-1571f463f607 | €9.00 | €0.19 | matched |
| 85 | capture | 01a15696-d2ac-7158-8c16-3ad368174fe6 | €24.00 | €0.37 | matched |
| 86 | capture | 01a15696-dad2-7083-b172-75309f2026f6 | €49.00 | €0.67 | matched |
| 87 | capture | 01a15696-e1cd-73ad-8e55-419b6fdff954 | €24.00 | €0.37 | matched |
| 88 | capture | 01a15697-16f5-7c91-8942-cdf8d0706aa6 | €9.00 | €0.19 | matched |
| 89 | capture | 01a15697-2c46-7aae-997a-dc0a2134b5cd | €15.00 | €0.26 | matched |
| 90 | capture | 01a15697-3fc2-725e-9491-01922f55e423 | €15.00 | €0.26 | matched |
| 91 | capture | 01a15697-52db-7bbf-bcd0-3480a5cb1893 | €35.00 | €0.50 | matched |
| 92 | capture | 01a15697-5587-7215-843b-0d7a25cf5279 | €15.00 | €0.26 | matched |
| 93 | capture | 01a15697-5a73-7e2f-bf41-b87dc0999fc4 | €9.00 | €0.19 | matched |
| 94 | capture | 01a15697-7259-7e1a-9cec-4b63f3c50764 | €35.00 | €0.50 | matched |
| 95 | capture | 01a15697-75f5-7948-916b-2c1b7049c9a3 | €49.00 | €0.67 | matched |
| 96 | capture | 01a15697-923e-79ba-90b4-0e08345e15b8 | €49.00 | €0.67 | matched |
| 97 | capture | 01a15697-b2f5-7107-baef-51467b2cbc49 | €35.00 | €0.50 | matched |
| 98 | capture | 01a15697-b6f8-7eee-bfb4-eb0503665f56 | €9.00 | €0.19 | matched |
| 100 | capture | 01a15697-e850-7064-827d-a73b080fce2c | €35.00 | €0.50 | matched |
| 101 | capture | 01a15697-f473-7993-bc99-76f26a8a680d | €24.00 | €0.37 | matched |
| 102 | capture | 01a15697-f48d-75e7-9abd-f126ee1ef49f | €35.00 | €0.50 | matched |
| 103 | capture | 01a15698-1e4b-70d4-86b1-974cc11190b4 | €9.00 | €0.19 | matched |
| 104 | capture | 01a15698-4a98-70fb-ae37-518540d3e36e | €49.00 | €0.67 | matched |
| 105 | capture | 01a15698-5258-741e-b6aa-7405ee6d1eb5 | €9.00 | €0.19 | matched |
| 106 | capture | 01a15698-5ab1-70a4-aa68-73a03e80e51d | €24.00 | €0.37 | matched |
| 107 | capture | 01a15698-8011-75ad-bf74-65636625f106 | €24.00 | €0.37 | matched |
| 108 | capture | 01a15698-9ee4-7ee0-8510-4caea736053a | €9.00 | €0.19 | matched |
| 109 | capture | 01a15698-a1d1-74fb-baf3-ea63de825040 | €35.00 | €0.50 | matched |
| 110 | capture | 01a15698-a688-7a02-b2b3-8433209ddd1f | €49.00 | €0.67 | matched |
| 111 | capture | 01a15698-b7f9-7eba-98c4-5ab5b4accc3f | €24.00 | €0.37 | matched |
| 112 | capture | 01a15698-c35d-7b97-964a-5238d2416031 | €9.00 | €0.19 | matched |
| 113 | capture | 01a15698-d349-7c70-ae00-f3e63ea73048 | €15.00 | €0.26 | matched |
| 114 | capture | 01a15698-ebbf-7d96-8d60-f38c101a6215 | €24.00 | €0.37 | matched |
| 115 | capture | 01a15698-f3c4-729c-b411-eda4ecd1770b | €24.00 | €0.37 | matched |
| 116 | refund | 01a15698-f83c-7eb8-b412-79edbf6ce69a | -€5.00 | €0.00 | matched |
| 117 | capture | 01a15699-009a-754a-882c-af06566d113c | €15.00 | €0.26 | matched |
| 118 | capture | 01a15699-2d4a-77a1-9872-5537b1afc03e | €35.00 | €0.50 | matched |
| 119 | capture | 01a15699-349d-70c1-8f0d-2eab58cd5ada | €15.00 | €0.26 | matched |
| 120 | capture | 01a15699-3591-7a6d-af97-d055c8f52923 | €49.00 | €0.67 | matched |
| 121 | capture | 01a15699-758e-77dc-8828-e4628bf9045e | €49.00 | €0.67 | matched |
| 122 | capture | 01a15699-76a8-7b5a-89a5-573b8e871a3a | €49.00 | €0.67 | matched |
| 123 | capture | 01a15699-7f0e-7986-b80c-872bc221d6c8 | €35.00 | €0.50 | matched |
| 124 | capture | 01a15699-9247-758a-a6ad-f5cc8439e3b1 | €35.00 | €0.50 | matched |
| 125 | capture | 01a15699-9bf9-7d5a-a8d7-3cd676fd6ad0 | €35.00 | €0.50 | matched |
| 126 | capture | 01a15699-c241-7d5b-b175-82939368d46f | €15.00 | €0.26 | matched |
| 127 | capture | 01a1569a-0396-7495-a260-4405c5ecd108 | €9.00 | €0.19 | matched |
| 128 | capture | 01a1569a-0749-7a1e-80f9-2cec5e612f46 | €35.00 | €0.50 | matched |
| 129 | capture | 01a1569a-1c18-7a06-96dd-a1399df0182c | €35.00 | €0.50 | matched |
| 130 | capture | 01a1569a-4eff-7344-8bec-43f603d23533 | €49.00 | €0.67 | matched |
| 131 | capture | 01a1569a-58cd-772f-9836-e2792631bfe4 | €15.00 | €0.26 | matched |
| 132 | capture | 01a1569a-6258-7ca4-bcf3-38f799a38dea | €24.00 | €0.37 | matched |
| 133 | capture | 01a1569a-6f6d-7a7b-ad0c-d4e99a22e742 | €9.00 | €0.19 | matched |
| 134 | refund | 01a1569a-92c0-7161-9570-da0c81320864 | -€13.00 | €0.00 | matched |
| 135 | capture | 01a1569a-ac5e-744e-bdd6-3a98532bfcec | €15.00 | €0.26 | matched |
| 136 | capture | 01a1569a-b73b-732e-8eac-7667b0784348 | €24.00 | €0.37 | matched |
| 137 | capture | 01a1569a-bb48-7c0f-a385-04765fc8382f | €15.00 | €0.26 | matched |
| 138 | capture | 01a1569a-d4fe-710c-9fc6-21b1098c4367 | €9.00 | €0.19 | matched |
| 140 | capture | 01a1569b-1b9b-7ef4-85be-5ff0d26a1e87 | €49.00 | €0.67 | matched |
| 141 | capture | 01a1569b-204a-771a-9481-9e38a2376231 | €24.00 | €0.37 | matched |
| 142 | capture | 01a1569b-2212-7811-acfa-cabf8dfa28e3 | €24.00 | €0.37 | matched |
| 143 | capture | 01a1569b-31ab-739d-b24f-02d36e423533 | €9.00 | €0.19 | matched |
| 144 | capture | 01a1569b-3707-71b2-90b6-7730a1665914 | €9.00 | €0.19 | matched |
| 145 | capture | 01a1569b-3f81-74bd-b6d7-353afcd694a0 | €49.00 | €0.67 | matched |
| 146 | capture | 01a1569b-4b7f-706e-9653-8f09f6e3bbde | €35.00 | €0.50 | matched |
| 147 | capture | 01a1569b-5457-74be-a9d4-b7319a89eec9 | €49.00 | €0.67 | matched |
| 148 | capture | 01a1569b-63e6-7f73-956d-1b7b631101d6 | €35.00 | €0.50 | matched |