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
- 15 Oct, 14:30108 lines4 breaks
- 15 Oct, 14:20130 lines3 breaks
- 15 Oct, 14:10137 lines3 breaks
- 15 Oct, 14:00125 lines4 breaks
- 15 Oct, 13:50128 lines1 break
- 15 Oct, 13:40122 lines4 breaks
- 15 Oct, 13:30132 lines4 breaks
- 15 Oct, 13:20133 lines4 breaks
- 15 Oct, 13:10130 lines5 breaks
- 15 Oct, 13:00141 lines2 breaks
- 15 Oct, 12:50108 lines1 break
- 15 Oct, 12:40116 lines2 breaks
- 15 Oct, 12:30121 lines3 breaks
- 15 Oct, 12:20123 lines2 breaks
15 Oct, 13:10
Gross
€3,051.00
PSP fee
€47.90
Net to the bank
€3,003.10
Settlement journal
#15217
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13fb1-d47f-74e8-b7ac-b5c5f5d864c6 is already settled by stl_EUR_2986783 line 45
- duplicate linethe file lists it twicecapture:01a13fb6-de2e-73ac-bd94-4da23fb1bb69 is already settled by stl_EUR_2986783 line 114
- fee differencethe fee is not the contract feethe fee is 51, the contract says 50
- fee differencethe fee is not the contract feethe fee is 40, the contract says 37
- missing linein the books, not in the filecapture:01a13fb3-babe-7870-8b96-4f0b8824c1eb is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 46 | capture | 01a13fb1-d60e-7361-821b-4106fb9ca294 | €49.00 | €0.67 | duplicate line |
| 95 | capture | 01a13fb5-8b04-763d-93f7-cfc9dd53ab36 | €35.00 | €0.51 | fee difference |
| 115 | capture | 01a13fb6-de92-7809-9e85-3044758d64d5 | €24.00 | €0.37 | duplicate line |
| 130 | capture | 01a13fb8-2ff2-723f-8d22-71d675680271 | €24.00 | €0.40 | fee difference |
| 1 | capture | 01a13fa6-81ef-794d-8138-19caa7b1b442 | €9.00 | €0.19 | matched |
| 2 | capture | 01a13fa8-36e5-7d62-971f-089b32d9fa17 | €49.00 | €0.67 | matched |
| 3 | capture | 01a13faf-2bd9-759a-acb8-00f8643e9640 | €49.00 | €0.67 | matched |
| 4 | capture | 01a13faf-3abd-7998-836b-c4c5235b7c6d | €35.00 | €0.50 | matched |
| 5 | capture | 01a13faf-3eba-7355-a1df-0be4b7ff68b4 | €9.00 | €0.19 | matched |
| 6 | capture | 01a13faf-4187-758d-950a-56e43cb71c6a | €49.00 | €0.67 | matched |
| 7 | capture | 01a13faf-60c5-7e16-bd7f-fa22833f7daf | €35.00 | €0.50 | matched |
| 8 | capture | 01a13faf-6cca-77e7-97fb-eaa1c0cd171b | €9.00 | €0.19 | matched |
| 9 | capture | 01a13faf-72be-7ce0-beaf-9517714d0577 | €15.00 | €0.26 | matched |
| 10 | capture | 01a13faf-746b-7989-aaa9-69c8b62d2200 | €9.00 | €0.19 | matched |
| 11 | capture | 01a13faf-8503-77d9-ad78-a7140249a578 | €15.00 | €0.26 | matched |
| 12 | capture | 01a13faf-b96a-7927-9a1f-10859c1d986e | €35.00 | €0.50 | matched |
| 13 | capture | 01a13faf-c366-74a1-9bed-12a22ac54e3d | €24.00 | €0.37 | matched |
| 14 | capture | 01a13faf-cdb4-703c-9079-0436ac492da4 | €49.00 | €0.67 | matched |
| 15 | refund | 01a13faf-eb74-7266-ab7c-e0cf6488141a | -€4.00 | €0.00 | matched |
| 16 | capture | 01a13fb0-042f-77b5-9008-117cf1e3d149 | €15.00 | €0.26 | matched |
| 17 | capture | 01a13fb0-0d0d-7e8e-acb6-76d40c13ae24 | €49.00 | €0.67 | matched |
| 18 | capture | 01a13fb0-1409-75ff-aee7-2dcaa7339db1 | €15.00 | €0.26 | matched |
| 19 | refund | 01a13fb0-148b-7c6b-9492-be962dda8fff | -€22.00 | €0.00 | matched |
| 20 | capture | 01a13fb0-1ab6-7e39-b7f8-ca925e628023 | €24.00 | €0.37 | matched |
| 21 | capture | 01a13fb0-5797-7983-beb9-c8a1a594acfa | €35.00 | €0.50 | matched |
| 22 | capture | 01a13fb0-7d54-7d06-9b21-759ab50d6ef9 | €49.00 | €0.67 | matched |
| 23 | capture | 01a13fb0-7d9c-7cad-b0ff-fd610ca87a62 | €9.00 | €0.19 | matched |
| 24 | capture | 01a13fb0-8366-79c1-b147-c6a5e61e0c47 | €24.00 | €0.37 | matched |
| 25 | capture | 01a13fb0-89e7-7fa4-b4e7-3a7430377aaa | €15.00 | €0.26 | matched |
| 26 | capture | 01a13fb0-8bef-74b1-b017-933e046170e7 | €35.00 | €0.50 | matched |
| 27 | capture | 01a13fb0-8cdd-72cc-b617-6866bcfd0bcf | €35.00 | €0.50 | matched |
| 28 | capture | 01a13fb0-b634-78a9-a30f-946a3082e359 | €9.00 | €0.19 | matched |
| 29 | capture | 01a13fb0-d348-788b-97f1-25210d50503c | €49.00 | €0.67 | matched |
| 30 | capture | 01a13fb0-da66-7ce4-b412-f9bcc50b0686 | €15.00 | €0.26 | matched |
| 31 | capture | 01a13fb0-db7f-7669-aad3-ad0d26869f64 | €24.00 | €0.37 | matched |
| 32 | refund | 01a13fb0-e9a9-7141-bcc2-fe5938fbfe60 | -€3.00 | €0.00 | matched |
| 33 | capture | 01a13fb0-ebaa-7cfc-951b-4da84158ed59 | €24.00 | €0.37 | matched |
| 34 | capture | 01a13fb0-f6a9-7476-967b-c2d9a1da381b | €24.00 | €0.37 | matched |
| 35 | refund | 01a13fb0-f7b4-7aef-b629-f13b38cd3129 | -€17.00 | €0.00 | matched |
| 36 | capture | 01a13fb1-01cc-7f47-9c32-b48ff8d40765 | €15.00 | €0.26 | matched |
| 37 | capture | 01a13fb1-0691-71cf-84e2-ed71f115a1dc | €15.00 | €0.26 | matched |
| 38 | capture | 01a13fb1-08fc-781a-be6c-f46de74b0ed7 | €24.00 | €0.37 | matched |
| 39 | capture | 01a13fb1-09d4-7261-a74d-4fbde34c7d5d | €9.00 | €0.19 | matched |
| 40 | capture | 01a13fb1-150d-7fd1-82b4-8541665a719c | €15.00 | €0.26 | matched |
| 41 | capture | 01a13fb1-3da2-7b25-9a91-f7b99f7120f0 | €24.00 | €0.37 | matched |
| 42 | capture | 01a13fb1-6ad3-710d-a9e8-12331b48ec03 | €15.00 | €0.26 | matched |
| 43 | capture | 01a13fb1-b3db-7aad-85b9-3fbb13b2ea7b | €24.00 | €0.37 | matched |
| 44 | capture | 01a13fb1-cecd-7057-971c-d1d7522e7542 | €9.00 | €0.19 | matched |
| 45 | capture | 01a13fb1-d60e-7361-821b-4106fb9ca294 | €49.00 | €0.67 | matched |
| 47 | capture | 01a13fb1-d68b-750a-9fb8-d6712f448ea5 | €49.00 | €0.67 | matched |
| 48 | capture | 01a13fb1-f3d3-713e-b0cf-eab197550ac9 | €49.00 | €0.67 | matched |
| 49 | capture | 01a13fb2-0195-7c95-98f4-f6b852f0b0b9 | €15.00 | €0.26 | matched |
| 50 | capture | 01a13fb2-182d-7623-a7e8-bfa5ce135faf | €49.00 | €0.67 | matched |
| 51 | capture | 01a13fb2-2a00-717c-801a-ad8a76c048c4 | €24.00 | €0.37 | matched |
| 52 | capture | 01a13fb2-2d66-7fc6-bab6-0bbe8dabb676 | €9.00 | €0.19 | matched |
| 53 | capture | 01a13fb2-3c83-7f22-a583-f5b90ade51cb | €49.00 | €0.67 | matched |
| 54 | capture | 01a13fb2-4440-7889-8955-be9f6eecefd6 | €15.00 | €0.26 | matched |
| 55 | capture | 01a13fb2-5437-7ae0-96f1-455c7da26d5c | €9.00 | €0.19 | matched |
| 56 | capture | 01a13fb2-6eb2-7ed2-88c6-004975270480 | €15.00 | €0.26 | matched |
| 57 | capture | 01a13fb2-856f-7573-9781-fda691f694d5 | €9.00 | €0.19 | matched |
| 58 | capture | 01a13fb2-8c90-72e8-ab32-10b57c8bb236 | €49.00 | €0.67 | matched |
| 59 | capture | 01a13fb2-b16b-7bd5-b66b-92fc11cbd846 | €15.00 | €0.26 | matched |
| 60 | capture | 01a13fb2-d4cd-7e0b-bbfe-c51cd7926ba5 | €9.00 | €0.19 | matched |
| 61 | capture | 01a13fb2-dfbc-732f-951a-04054c7084cc | €49.00 | €0.67 | matched |
| 62 | capture | 01a13fb2-fdce-7822-a23e-8cfa26cd1e87 | €49.00 | €0.67 | matched |
| 63 | capture | 01a13fb3-15d5-79a9-a0e8-170d77acb01f | €35.00 | €0.50 | matched |
| 64 | capture | 01a13fb3-477c-72c0-b2fd-50809c8ee1b3 | €49.00 | €0.67 | matched |
| 65 | capture | 01a13fb3-4b86-731f-9ec3-0b9bf11e4572 | €9.00 | €0.19 | matched |
| 66 | capture | 01a13fb3-695f-7c61-8624-53fe6abde064 | €24.00 | €0.37 | matched |
| 67 | capture | 01a13fb3-6d18-74b1-841c-337aeff18448 | €24.00 | €0.37 | matched |
| 68 | capture | 01a13fb3-8ffc-75bc-b08f-5409ca7af79f | €24.00 | €0.37 | matched |
| 69 | capture | 01a13fb3-9984-7970-82d6-a6b5ded896e8 | €35.00 | €0.50 | matched |
| 70 | capture | 01a13fb3-ca39-7499-af69-c873adc07971 | €49.00 | €0.67 | matched |
| 71 | capture | 01a13fb3-c5ec-7f38-a050-78b87dd8f81f | €35.00 | €0.50 | matched |
| 72 | capture | 01a13fb3-d080-70a5-8776-f571f4c04bf6 | €35.00 | €0.50 | matched |
| 73 | capture | 01a13fb3-c58d-7355-9c31-d2807c96d4b7 | €35.00 | €0.50 | matched |
| 74 | capture | 01a13fb3-d6a0-739d-b7a3-a89fc0c1bf63 | €15.00 | €0.26 | matched |
| 75 | capture | 01a13fb3-f196-7c47-9b8e-e431b0ee9f4e | €24.00 | €0.37 | matched |
| 76 | capture | 01a13fb4-2b2a-749e-812b-f7c88e05ccb3 | €15.00 | €0.26 | matched |
| 77 | capture | 01a13fb4-2dfd-7257-b97c-b364c4e85517 | €49.00 | €0.67 | matched |
| 78 | capture | 01a13fb4-3d2a-7147-bb81-6219b8c8ccc0 | €9.00 | €0.19 | matched |
| 79 | capture | 01a13fb4-4d24-74a6-87ed-a0b9d38d9b01 | €24.00 | €0.37 | matched |
| 80 | capture | 01a13fb4-63c8-7ae6-a309-35419ad0aedf | €35.00 | €0.50 | matched |
| 81 | capture | 01a13fb4-6d48-764b-aa53-662fe35e3cb9 | €15.00 | €0.26 | matched |
| 82 | capture | 01a13fb4-8fc0-7f1b-985f-ff9f988f93b2 | €24.00 | €0.37 | matched |
| 83 | capture | 01a13fb4-93c8-720e-b2d4-bb60440b4472 | €15.00 | €0.26 | matched |
| 84 | capture | 01a13fb4-cf08-757b-9310-e5c44e67a8aa | €15.00 | €0.26 | matched |
| 85 | capture | 01a13fb4-d9d2-793d-8011-2a9caf89aa35 | €9.00 | €0.19 | matched |
| 86 | capture | 01a13fb4-e14b-7df2-9a60-6e5cfee6705c | €9.00 | €0.19 | matched |
| 87 | capture | 01a13fb4-e454-78ac-aae9-525ceaecb462 | €35.00 | €0.50 | matched |
| 88 | capture | 01a13fb4-f5ae-7da5-ac1a-844d65e73076 | €15.00 | €0.26 | matched |
| 89 | capture | 01a13fb5-2d5d-7902-8ab0-a3661eed82b0 | €35.00 | €0.50 | matched |
| 90 | capture | 01a13fb5-2d91-7154-be43-a50610dbbda8 | €15.00 | €0.26 | matched |
| 91 | capture | 01a13fb5-3228-7458-8efd-d5ae2e55ce8a | €9.00 | €0.19 | matched |
| 92 | capture | 01a13fb5-4888-793f-b947-9a1466b98df3 | €24.00 | €0.37 | matched |
| 93 | refund | 01a13fb5-67c8-7721-b435-423366392ce9 | -€8.00 | €0.00 | matched |
| 94 | capture | 01a13fb5-73cc-7776-b479-d34661216d7d | €15.00 | €0.26 | matched |
| 96 | capture | 01a13fb5-b88d-716f-a3e4-a241a29ea19d | €24.00 | €0.37 | matched |
| 97 | capture | 01a13fb5-c9a8-73b9-9ab4-77a80bd99c59 | €35.00 | €0.50 | matched |
| 98 | capture | 01a13fb5-ff67-734f-9e55-c2e44e692a3e | €15.00 | €0.26 | matched |
| 99 | capture | 01a13fb6-115a-7199-905a-45bc52207353 | €35.00 | €0.50 | matched |
| 100 | capture | 01a13fb6-19b7-707e-bf65-d65f5d849a65 | €35.00 | €0.50 | matched |
| 101 | capture | 01a13fb6-28b6-732d-8972-c47144ed1205 | €9.00 | €0.19 | matched |
| 102 | capture | 01a13fb6-2b01-73e3-8fc2-d375623a3b60 | €15.00 | €0.26 | matched |
| 103 | capture | 01a13fb6-474f-7b8c-86f3-6e08fbb71745 | €9.00 | €0.19 | matched |
| 104 | capture | 01a13fb6-5407-7915-94a3-b970d647b403 | €35.00 | €0.50 | matched |
| 105 | capture | 01a13fb6-66d2-787e-a091-6f5286e88e40 | €49.00 | €0.67 | matched |
| 106 | capture | 01a13fb6-6dd5-750b-a9f7-2eeac1a8e206 | €49.00 | €0.67 | matched |
| 107 | capture | 01a13fb6-72e4-7800-877b-5c8696d32359 | €15.00 | €0.26 | matched |
| 108 | refund | 01a13fb6-7b0c-7dd4-aaa9-19386aeeaefd | -€14.00 | €0.00 | matched |
| 109 | capture | 01a13fb6-8937-727f-bcfa-2d2b83b0a8f1 | €9.00 | €0.19 | matched |
| 110 | capture | 01a13fb6-942a-7e79-bab7-a5dda0cf7145 | €9.00 | €0.19 | matched |
| 111 | capture | 01a13fb6-bebb-7bae-ba8f-4965fa6f21ec | €35.00 | €0.50 | matched |
| 112 | capture | 01a13fb6-d76f-75f8-bec3-c25b5375a2a5 | €24.00 | €0.37 | matched |
| 113 | capture | 01a13fb6-dde8-74fd-8508-2d6fd737a5de | €24.00 | €0.37 | matched |
| 114 | capture | 01a13fb6-de92-7809-9e85-3044758d64d5 | €24.00 | €0.37 | matched |
| 116 | capture | 01a13fb6-ec4f-7f2d-9416-a638903d0aff | €15.00 | €0.26 | matched |
| 117 | capture | 01a13fb6-f54e-76b4-9cdd-424e9cb2eb89 | €24.00 | €0.37 | matched |
| 118 | capture | 01a13fb7-0849-745a-b5d6-23aa2addea44 | €15.00 | €0.26 | matched |
| 119 | capture | 01a13fb7-46ca-70a2-afe0-198aa82f2452 | €24.00 | €0.37 | matched |
| 120 | capture | 01a13fb7-5650-7ec3-b336-5841e87d5b0f | €24.00 | €0.37 | matched |
| 121 | capture | 01a13fb7-6309-7cd9-93af-ec256cea1c65 | €15.00 | €0.26 | matched |
| 122 | capture | 01a13fb7-8e97-79d9-ab83-08b4e3a2c27f | €49.00 | €0.67 | matched |
| 123 | capture | 01a13fb7-8ee4-7ff7-840b-a05c3675c6a4 | €24.00 | €0.37 | matched |
| 124 | capture | 01a13fb7-cdfe-70a3-9ec7-911fd0257f8e | €49.00 | €0.67 | matched |
| 125 | capture | 01a13fb7-d2ca-7487-af06-8a05d5d80a7b | €15.00 | €0.26 | matched |
| 126 | capture | 01a13fb7-ecdd-7304-8e30-67d0f93a4dd9 | €9.00 | €0.19 | matched |
| 127 | capture | 01a13fb7-fb0b-7047-8cbc-dd57da79f2a1 | €24.00 | €0.37 | matched |
| 128 | capture | 01a13fb8-0fb5-7668-a388-67b47c29e79a | €24.00 | €0.37 | matched |
| 129 | refund | 01a13fb8-2bd8-7eea-8e35-8fd521a3f6fa | -€37.00 | €0.00 | matched |