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
- 6 Nov, 08:20137 lines2 breaks
- 6 Nov, 08:10158 lines4 breaks
- 6 Nov, 08:00119 lines2 breaks
- 6 Nov, 07:50110 lines3 breaks
- 6 Nov, 07:40125 lines2 breaks
- 6 Nov, 07:30125 lines1 break
- 6 Nov, 07:20117 lines3 breaks
- 6 Nov, 07:10136 lines7 breaks
- 6 Nov, 07:00146 lines1 break
- 6 Nov, 06:50118 lines2 breaks
- 6 Nov, 06:40124 lines2 breaks
- 6 Nov, 06:30128 lines2 breaks
- 6 Nov, 06:20122 lines2 breaks
- 6 Nov, 06:10136 lines2 breaks
6 Nov, 08:10
Gross
€3,019.00
PSP fee
€51.44
Net to the bank
€2,967.56
Settlement journal
#412717
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1afe9-79c7-7e70-8b38-0efd56f6c3fa is already settled by stl_EUR_2989921 line 15
- fee differencethe fee is not the contract feethe fee is 42, the contract says 37
- missing linein the books, not in the filecapture:01a1afe9-c3ed-706d-be12-593fc512221c is in no file
- missing linein the books, not in the filecapture:01a1aff0-18e5-7e50-ab08-595dd88eb9e5 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 16 | capture | 01a1afe9-79e3-7a24-8437-9bece8e9af2d | €24.00 | €0.37 | duplicate line |
| 83 | capture | 01a1afed-5e2e-747f-8821-5c6e07fe78eb | €24.00 | €0.42 | fee difference |
| 1 | capture | 01a1afe0-ff4e-7065-9022-f1fd1601ae6c | €49.00 | €0.67 | matched |
| 2 | capture | 01a1afe1-ffdd-7820-a464-45bfc8f1186a | €15.00 | €0.26 | matched |
| 3 | refund | 01a1afe2-30d8-73d9-afbc-1c1e35acd62e | -€24.00 | €0.00 | matched |
| 4 | capture | 01a1afe8-6f64-7633-8be5-4caf59316822 | €9.00 | €0.19 | matched |
| 5 | capture | 01a1afe8-7680-7d6c-9b16-2df10e69bb84 | €15.00 | €0.26 | matched |
| 6 | refund | 01a1afe8-796b-76b6-a1d7-5a164470f510 | -€10.00 | €0.00 | matched |
| 7 | capture | 01a1afe8-7ea5-73a3-8be7-9e64c8689edb | €15.00 | €0.26 | matched |
| 8 | capture | 01a1afe8-a4d1-7411-8449-a2e9822408fe | €15.00 | €0.26 | matched |
| 9 | capture | 01a1afe8-daeb-7769-a0a4-9561665d66fd | €24.00 | €0.37 | matched |
| 10 | capture | 01a1afe8-e76a-7a7c-a304-220e7d846980 | €49.00 | €0.67 | matched |
| 11 | capture | 01a1afe9-0264-7965-914f-7a67cb588e49 | €15.00 | €0.26 | matched |
| 12 | capture | 01a1afe9-078f-7ba8-9dce-7d7a30f7aa3b | €35.00 | €0.50 | matched |
| 13 | capture | 01a1afe9-5655-75d6-8a0c-15d20353bb89 | €35.00 | €0.50 | matched |
| 14 | capture | 01a1afe9-584d-70ad-9958-24450e5025b1 | €9.00 | €0.19 | matched |
| 15 | capture | 01a1afe9-79e3-7a24-8437-9bece8e9af2d | €24.00 | €0.37 | matched |
| 17 | capture | 01a1afe9-8929-7fda-a312-ab61ad36d6a2 | €35.00 | €0.50 | matched |
| 18 | capture | 01a1afe9-9147-7f6d-a163-11f3dfe9d403 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1afe9-942b-7a83-94a1-1457947463b8 | €9.00 | €0.19 | matched |
| 20 | capture | 01a1afe9-9cf4-7f66-ab34-c549dd03394b | €9.00 | €0.19 | matched |
| 21 | capture | 01a1afe9-a072-7619-9db3-a29ee7bc426f | €15.00 | €0.26 | matched |
| 22 | capture | 01a1afe9-ce61-7bf1-83b2-b520bdf77899 | €15.00 | €0.26 | matched |
| 23 | refund | 01a1afe9-f101-76bf-83fe-f732b91a7063 | -€4.00 | €0.00 | matched |
| 24 | capture | 01a1afe9-f2ea-799b-a8db-89b79543e779 | €15.00 | €0.26 | matched |
| 25 | capture | 01a1afe9-fa0c-79c0-8d22-f97f25c17db1 | €24.00 | €0.37 | matched |
| 26 | capture | 01a1afea-0169-7601-8991-2d1c20cad9bd | €49.00 | €0.67 | matched |
| 27 | capture | 01a1afea-08a0-75c8-8cbd-800e56993eb1 | €15.00 | €0.26 | matched |
| 28 | refund | 01a1afea-0923-7899-94a2-01bb1a52d144 | -€9.00 | €0.00 | matched |
| 29 | capture | 01a1afea-0d30-7f3a-b085-efe4c02a76d0 | €15.00 | €0.26 | matched |
| 30 | capture | 01a1afea-1cd7-71f1-8c6a-2e5283cb2e14 | €24.00 | €0.37 | matched |
| 31 | capture | 01a1afea-2d36-74f5-bc61-59020de2a98a | €24.00 | €0.37 | matched |
| 32 | capture | 01a1afea-4d95-79d0-a5b7-a3c827a768d7 | €35.00 | €0.50 | matched |
| 33 | capture | 01a1afea-50ee-780a-9d31-be6edd8134bd | €24.00 | €0.37 | matched |
| 34 | refund | 01a1afea-6d72-7f74-b114-44e16e35197e | -€12.00 | €0.00 | matched |
| 35 | capture | 01a1afea-7c07-709e-867b-1bba8641945e | €9.00 | €0.19 | matched |
| 36 | capture | 01a1afea-82c6-7ef2-9f68-aeba9e467d86 | €49.00 | €0.67 | matched |
| 37 | capture | 01a1afea-8d1d-7d60-a1d9-5769cbbffc09 | €24.00 | €0.37 | matched |
| 38 | capture | 01a1afea-8da7-7e5a-8aa2-d5df9ae84684 | €35.00 | €0.50 | matched |
| 39 | capture | 01a1afea-9276-7d8a-bc77-a182c95fd4c9 | €24.00 | €0.37 | matched |
| 40 | refund | 01a1afea-9af1-7e77-bd5b-c99e78f847f5 | -€6.00 | €0.00 | matched |
| 41 | capture | 01a1afea-bf40-79a0-9db5-f0407556723d | €24.00 | €0.37 | matched |
| 42 | refund | 01a1afea-bf9a-7e99-aa83-824e60ed0374 | -€16.00 | €0.00 | matched |
| 43 | capture | 01a1afea-c1fa-7b38-a01b-2121960b40fa | €15.00 | €0.26 | matched |
| 44 | capture | 01a1afea-c582-7e7e-9aa9-4101d28c56a1 | €15.00 | €0.26 | matched |
| 45 | capture | 01a1afea-de78-76dd-bad0-84a1c9b61b9d | €49.00 | €0.67 | matched |
| 46 | capture | 01a1afea-e3a0-7a26-88c8-7ed1595f774b | €9.00 | €0.19 | matched |
| 47 | capture | 01a1afea-e86b-7765-96e2-a890fb90ebec | €35.00 | €0.50 | matched |
| 48 | refund | 01a1afea-e96f-7350-b4ba-c6de3ff7b893 | -€11.00 | €0.00 | matched |
| 49 | capture | 01a1afeb-2f82-7f58-b54a-f33e1bce5046 | €49.00 | €0.67 | matched |
| 50 | capture | 01a1afeb-317b-7cb7-adec-66a7185e63de | €24.00 | €0.37 | matched |
| 51 | refund | 01a1afeb-3cec-7419-99d8-9d03ffc364e8 | -€40.00 | €0.00 | matched |
| 52 | capture | 01a1afeb-5678-77f2-b6d3-ae43586dbb30 | €9.00 | €0.19 | matched |
| 53 | capture | 01a1afeb-8cc4-77e5-a404-026f86d8871c | €35.00 | €0.50 | matched |
| 54 | capture | 01a1afeb-8da3-74c7-af09-70000c7c6c2c | €24.00 | €0.37 | matched |
| 55 | refund | 01a1afeb-9142-7784-8b9c-260261b6c7c8 | -€37.00 | €0.00 | matched |
| 56 | capture | 01a1afeb-9472-7df3-a473-32563b66b3ed | €15.00 | €0.26 | matched |
| 57 | capture | 01a1afeb-91cf-7c38-b944-2826133975f3 | €49.00 | €0.67 | matched |
| 58 | capture | 01a1afeb-9601-7c83-8023-c7e0c419bb1a | €9.00 | €0.19 | matched |
| 59 | capture | 01a1afeb-993b-7434-8ff7-1311e3ec7e06 | €15.00 | €0.26 | matched |
| 60 | capture | 01a1afeb-adf6-75dc-9060-563ecacf241a | €24.00 | €0.37 | matched |
| 61 | capture | 01a1afeb-b23d-7993-86bc-cac6efce0a4b | €49.00 | €0.67 | matched |
| 62 | capture | 01a1afeb-b303-7b24-889b-ab26a30fc628 | €15.00 | €0.26 | matched |
| 63 | refund | 01a1afeb-c82f-7564-be27-e26265eb8dd2 | -€12.00 | €0.00 | matched |
| 64 | capture | 01a1afec-0aa9-7edc-8c69-396f542d1ffb | €24.00 | €0.37 | matched |
| 65 | capture | 01a1afec-14bf-799b-8288-c164aa1e9fbe | €24.00 | €0.37 | matched |
| 66 | capture | 01a1afec-1fb8-7074-a6ac-9706ac75e3b8 | €15.00 | €0.26 | matched |
| 67 | capture | 01a1afec-2bc2-7fef-84f1-ce2eef5a3b65 | €9.00 | €0.19 | matched |
| 68 | capture | 01a1afec-3fc5-73dc-ae46-ae0c125bd8ee | €9.00 | €0.19 | matched |
| 69 | refund | 01a1afec-569f-719a-a924-d99531da8b98 | -€14.00 | €0.00 | matched |
| 70 | capture | 01a1afec-79ae-71b5-a615-ba17b6f7ba8b | €35.00 | €0.50 | matched |
| 71 | capture | 01a1afec-89cd-7e77-9620-9198ee1ecb37 | €49.00 | €0.67 | matched |
| 72 | capture | 01a1afec-9974-79c1-b8df-b56c3e53333d | €9.00 | €0.19 | matched |
| 73 | capture | 01a1afec-a147-7b96-99a4-1be246dbc753 | €24.00 | €0.37 | matched |
| 74 | capture | 01a1afec-aa14-7e9f-92d9-5fce965358d6 | €24.00 | €0.37 | matched |
| 75 | refund | 01a1afec-ace0-792d-b0aa-3bac435184e8 | -€8.00 | €0.00 | matched |
| 76 | capture | 01a1afec-dd25-76bf-888b-dc8018cb8ed0 | €24.00 | €0.37 | matched |
| 77 | capture | 01a1afec-f7e9-70d2-a54d-318ff4e9d647 | €49.00 | €0.67 | matched |
| 78 | capture | 01a1afec-f938-7d6b-942d-d2cbda897052 | €35.00 | €0.50 | matched |
| 79 | capture | 01a1afed-091d-7e39-a4f6-a4cc1d03ecd1 | €35.00 | €0.50 | matched |
| 80 | capture | 01a1afed-2490-7c1d-ac0b-e277a5f225e4 | €24.00 | €0.37 | matched |
| 81 | capture | 01a1afed-5a5a-70e2-bf11-d564f45ca934 | €9.00 | €0.19 | matched |
| 82 | capture | 01a1afed-5c0d-7247-9a44-75484d2fb162 | €35.00 | €0.50 | matched |
| 84 | capture | 01a1afed-5f82-7224-a946-cc3a018db8d2 | €35.00 | €0.50 | matched |
| 85 | refund | 01a1afed-7a06-7cd3-b572-1d6ff510451a | -€15.00 | €0.00 | matched |
| 86 | refund | 01a1afed-a0a2-77bb-9729-ed90e6b456f4 | -€7.00 | €0.00 | matched |
| 87 | capture | 01a1afed-a2b7-7e52-9a53-2a3d6c15d55e | €24.00 | €0.37 | matched |
| 88 | capture | 01a1afed-b0db-70f0-85e1-6649c34c9e8e | €49.00 | €0.67 | matched |
| 89 | capture | 01a1afed-b109-7dfc-9f00-bbeb90d450ce | €9.00 | €0.19 | matched |
| 90 | capture | 01a1afed-b713-7b7f-bce6-abba05b95891 | €35.00 | €0.50 | matched |
| 91 | capture | 01a1afed-c0df-7b20-803e-d3ef3ddbdcac | €49.00 | €0.67 | matched |
| 92 | capture | 01a1afed-cb79-7633-bec5-5da5f09ede67 | €9.00 | €0.19 | matched |
| 93 | capture | 01a1afed-ecda-7b65-8e4b-d8670a4f4ca6 | €24.00 | €0.37 | matched |
| 94 | capture | 01a1afee-0105-7701-8bf0-a83906a26543 | €35.00 | €0.50 | matched |
| 95 | capture | 01a1afee-28c9-7e64-98b4-a3fe7292dc92 | €9.00 | €0.19 | matched |
| 96 | refund | 01a1afee-2b4d-72a8-a077-34464ea30e2d | -€11.00 | €0.00 | matched |
| 97 | capture | 01a1afee-2bf2-7f5a-8aa2-47ed931f9d31 | €49.00 | €0.67 | matched |
| 98 | capture | 01a1afee-2c3a-7d67-adba-c9c43e92f24a | €15.00 | €0.26 | matched |
| 99 | capture | 01a1afee-2e5b-7c59-a267-26d319e2b714 | €9.00 | €0.19 | matched |
| 100 | capture | 01a1afee-3940-7a80-ad41-8d8f34cbe5ea | €9.00 | €0.19 | matched |
| 101 | capture | 01a1afee-6e64-79e2-8cae-e27fa9124f3e | €24.00 | €0.37 | matched |
| 102 | capture | 01a1afee-7813-798d-859d-71e18c65e92b | €15.00 | €0.26 | matched |
| 103 | refund | 01a1afee-8378-7a10-93cd-51c7f9003001 | -€38.00 | €0.00 | matched |
| 104 | capture | 01a1afee-93c0-7c32-9515-3076bc26b05d | €49.00 | €0.67 | matched |
| 105 | capture | 01a1afee-a873-7680-ae34-3a17486e4b75 | €35.00 | €0.50 | matched |
| 106 | capture | 01a1afee-b17a-75e7-a280-b2ad51330bfc | €49.00 | €0.67 | matched |
| 107 | capture | 01a1afee-c6eb-735b-9bc8-abfb77478c29 | €9.00 | €0.19 | matched |
| 108 | capture | 01a1afee-c70b-7fc9-aa0b-67a48f15c57d | €9.00 | €0.19 | matched |
| 109 | capture | 01a1afee-cc2e-70f6-a48d-b0bc12526003 | €15.00 | €0.26 | matched |
| 110 | capture | 01a1afee-f113-7070-b2e8-bd10afe4c0b3 | €35.00 | €0.50 | matched |
| 111 | capture | 01a1afee-f388-7251-a053-5c47ff961634 | €15.00 | €0.26 | matched |
| 112 | capture | 01a1afee-f446-74ce-80e2-399be96afade | €49.00 | €0.67 | matched |
| 113 | capture | 01a1afef-19a7-7e95-a704-6c695680de2b | €49.00 | €0.67 | matched |
| 114 | capture | 01a1afef-293d-7129-8c5d-2de231dc6b77 | €35.00 | €0.50 | matched |
| 115 | capture | 01a1afef-3755-7beb-812d-9d30dc926353 | €9.00 | €0.19 | matched |
| 116 | capture | 01a1afef-42dd-7ed0-a092-9a9779cf5769 | €35.00 | €0.50 | matched |
| 117 | capture | 01a1afef-46b9-7404-a0ef-19dcd077e62c | €15.00 | €0.26 | matched |
| 118 | capture | 01a1afef-4a21-7386-b457-1a86066a43e6 | €15.00 | €0.26 | matched |
| 119 | capture | 01a1afef-515c-7a57-8009-938f68b1ddb2 | €24.00 | €0.37 | matched |
| 120 | capture | 01a1afef-754c-782a-b23d-9999d56b48b7 | €49.00 | €0.67 | matched |
| 121 | capture | 01a1afef-9483-7d59-86c6-e9226d085eae | €9.00 | €0.19 | matched |
| 122 | capture | 01a1afef-98f6-713f-a771-40b2ab5c3d56 | €35.00 | €0.50 | matched |
| 123 | capture | 01a1afef-9ee8-725e-b8b9-db83a46ea43a | €9.00 | €0.19 | matched |
| 124 | capture | 01a1afef-c4ac-7ddf-8a48-536b9e09337a | €15.00 | €0.26 | matched |
| 125 | capture | 01a1afef-d0a5-7750-89e0-aec3a64488c8 | €49.00 | €0.67 | matched |
| 126 | capture | 01a1afef-d16a-752e-a868-2d995062ffba | €24.00 | €0.37 | matched |
| 127 | capture | 01a1afef-ddf3-79bc-b099-d785914539b9 | €15.00 | €0.26 | matched |
| 128 | capture | 01a1afef-e35b-77d0-a2eb-deb48a619e2d | €9.00 | €0.19 | matched |
| 129 | capture | 01a1afef-e3d0-7cd6-a33f-9fc2dce266d1 | €49.00 | €0.67 | matched |
| 130 | capture | 01a1afef-f46e-78f6-bf94-77c5745dbb52 | €24.00 | €0.37 | matched |
| 131 | refund | 01a1afef-f498-7a8b-a64b-9e1ae16bc698 | -€3.00 | €0.00 | matched |
| 132 | capture | 01a1afef-f663-7e03-a675-867b06d0d7a2 | €35.00 | €0.50 | matched |
| 133 | refund | 01a1afef-fb6c-7f04-95ac-700dabe54fc3 | -€35.00 | €0.00 | matched |
| 134 | capture | 01a1aff0-151e-7a48-b7b8-69ca80cd40f8 | €9.00 | €0.19 | matched |
| 135 | capture | 01a1aff0-152b-734f-805f-9e05faa84048 | €15.00 | €0.26 | matched |
| 136 | capture | 01a1aff0-24e5-7c5d-b3e1-cba4b301d42c | €15.00 | €0.26 | matched |
| 137 | capture | 01a1aff0-290b-7dcc-b525-26e3f2d53e73 | €9.00 | €0.19 | matched |
| 138 | capture | 01a1aff0-2fc4-78ee-9cce-0c9b430f4643 | €15.00 | €0.26 | matched |
| 139 | capture | 01a1aff0-285b-7cc3-b8fa-82ab00f4087d | €15.00 | €0.26 | matched |
| 140 | capture | 01a1aff0-673d-708d-b492-fa97d9a88a89 | €15.00 | €0.26 | matched |
| 141 | capture | 01a1aff0-6839-7c91-99e4-ceed8b8c69e5 | €24.00 | €0.37 | matched |
| 142 | capture | 01a1aff0-7482-7e95-8115-87ce7c1919b2 | €9.00 | €0.19 | matched |
| 143 | refund | 01a1aff0-7d07-774a-a8ac-c21028704316 | -€4.00 | €0.00 | matched |
| 144 | capture | 01a1aff0-8581-734e-bebf-3f7cdd2cf657 | €9.00 | €0.19 | matched |
| 145 | capture | 01a1aff0-8a2a-7665-825e-3cb68c919997 | €15.00 | €0.26 | matched |
| 146 | capture | 01a1aff0-9bb1-7b3a-9fef-2a6414cc7366 | €9.00 | €0.19 | matched |
| 147 | refund | 01a1aff0-aba3-761b-b00c-8fb7b66e838f | -€4.00 | €0.00 | matched |
| 148 | capture | 01a1aff0-aeed-74ed-b4aa-a8a9056f5fb1 | €15.00 | €0.26 | matched |
| 149 | capture | 01a1aff0-b67c-74de-bf36-2ed3476fa211 | €49.00 | €0.67 | matched |
| 150 | capture | 01a1aff0-c34b-7f26-ab86-09f22ae00b94 | €49.00 | €0.67 | matched |
| 151 | capture | 01a1aff0-ea46-7117-b08c-6543c4bdf0c0 | €49.00 | €0.67 | matched |
| 152 | capture | 01a1aff1-0672-7c97-8579-50a6417b3e5c | €15.00 | €0.26 | matched |
| 153 | capture | 01a1aff1-0bde-784d-a818-a90671f8db3a | €24.00 | €0.37 | matched |
| 154 | capture | 01a1aff1-11f7-7cbc-9784-c3b03ddfb78f | €49.00 | €0.67 | matched |
| 155 | capture | 01a1aff1-2eb4-7a0f-b846-289072946a63 | €15.00 | €0.26 | matched |
| 156 | refund | 01a1aff1-42cd-7a1c-97cf-75d70c3359c4 | -€23.00 | €0.00 | matched |
| 157 | capture | 01a1aff1-48ce-7671-abe6-7508fa57f3f8 | €9.00 | €0.19 | matched |
| 158 | capture | 01a1aff1-5980-7719-9eb6-ecb2fc255759 | €49.00 | €0.67 | matched |