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
- 4 Nov, 09:50122 linesclean
- 4 Nov, 09:40117 linesclean
- 4 Nov, 09:30118 lines1 break
- 4 Nov, 09:20120 lines4 breaks
- 4 Nov, 09:10113 lines2 breaks
- 4 Nov, 09:00113 lines2 breaks
- 4 Nov, 08:50118 lines4 breaks
- 4 Nov, 08:40117 lines3 breaks
- 4 Nov, 08:30128 lines2 breaks
- 4 Nov, 08:20121 lines2 breaks
- 4 Nov, 08:10115 lines3 breaks
- 4 Nov, 08:00136 lines4 breaks
- 4 Nov, 07:50145 lines6 breaks
- 4 Nov, 07:40118 lines2 breaks
4 Nov, 08:20
Gross
€2,681.00
PSP fee
€43.81
Net to the bank
€2,637.19
Settlement journal
#376162
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a1a5a5-3dda-78b0-9be2-1aa438baf6fb is already settled by stl_EUR_2989634 line 9
- missing linein the books, not in the filecapture:01a1a5ac-c4b3-770f-aeaa-9a90defb9074 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 10 | refund | 01a1a5a5-3ddf-72fe-87a6-a023a1494398 | -€12.00 | €0.00 | duplicate line |
| 1 | capture | 01a1a59c-bde7-7709-a95f-480ea73f9470 | €9.00 | €0.19 | matched |
| 2 | capture | 01a1a59f-3f45-7694-a8eb-44ba75171d21 | €35.00 | €0.50 | matched |
| 3 | capture | 01a1a5a4-7446-725c-ae64-286ae8c8cae1 | €35.00 | €0.50 | matched |
| 4 | capture | 01a1a5a4-ce5d-7e35-8d4f-6cdb831e8230 | €15.00 | €0.26 | matched |
| 5 | capture | 01a1a5a4-e8fb-779c-b038-5a73f3a8d57e | €49.00 | €0.67 | matched |
| 6 | capture | 01a1a5a5-05ed-7bd1-855e-1c4bf39eea0a | €24.00 | €0.37 | matched |
| 7 | capture | 01a1a5a5-0c5d-76f8-872d-da3540d2b9ca | €35.00 | €0.50 | matched |
| 8 | capture | 01a1a5a5-1e89-7071-b6e7-8b0d4aef7656 | €49.00 | €0.67 | matched |
| 9 | refund | 01a1a5a5-3ddf-72fe-87a6-a023a1494398 | -€12.00 | €0.00 | matched |
| 11 | capture | 01a1a5a5-50ce-700d-8db2-007bd3ccff21 | €15.00 | €0.26 | matched |
| 12 | capture | 01a1a5a5-59cb-799e-b561-de9adaeb3693 | €15.00 | €0.26 | matched |
| 13 | capture | 01a1a5a5-61eb-7910-aba7-c097d51445cc | €9.00 | €0.19 | matched |
| 14 | capture | 01a1a5a5-6ad4-7dbc-bc43-3624e6656435 | €15.00 | €0.26 | matched |
| 15 | capture | 01a1a5a5-6fe5-79ce-a505-1541b16a8105 | €24.00 | €0.37 | matched |
| 16 | capture | 01a1a5a5-8135-7262-b2b0-ec687fdf6c77 | €9.00 | €0.19 | matched |
| 17 | capture | 01a1a5a5-8ad9-7ddc-85a3-4675cbb9c2e3 | €9.00 | €0.19 | matched |
| 18 | capture | 01a1a5a5-8e30-7dea-a0cf-83d184b080f4 | €49.00 | €0.67 | matched |
| 19 | capture | 01a1a5a5-a4d4-7727-af6c-6fe08caf8676 | €9.00 | €0.19 | matched |
| 20 | refund | 01a1a5a5-b3e3-7cf1-93b4-0f94ba50cdd0 | -€5.00 | €0.00 | matched |
| 21 | capture | 01a1a5a5-c222-7bbd-bdcd-6e251ca40e1a | €35.00 | €0.50 | matched |
| 22 | capture | 01a1a5a5-da4b-7f39-95a4-1616767116ca | €9.00 | €0.19 | matched |
| 23 | capture | 01a1a5a5-e2c4-785f-9495-ccd59ca2179f | €49.00 | €0.67 | matched |
| 24 | capture | 01a1a5a5-f1de-70c3-ab4c-45814bd772dd | €35.00 | €0.50 | matched |
| 25 | capture | 01a1a5a5-fe81-74e1-9b4f-2433c2d588da | €24.00 | €0.37 | matched |
| 26 | capture | 01a1a5a6-20b8-7ff9-880d-8e7628ed3dfa | €49.00 | €0.67 | matched |
| 27 | refund | 01a1a5a6-2afc-75e2-a1fb-2cee3f81edc9 | -€10.00 | €0.00 | matched |
| 28 | capture | 01a1a5a6-4584-7eca-b3f4-523121793fcc | €9.00 | €0.19 | matched |
| 29 | refund | 01a1a5a6-54c1-7068-acad-2245251cb90f | -€45.00 | €0.00 | matched |
| 30 | capture | 01a1a5a6-cb5a-7dfb-abc8-d4fb40df25e0 | €35.00 | €0.50 | matched |
| 31 | capture | 01a1a5a6-cec8-78d3-b1e2-86ea527c341a | €9.00 | €0.19 | matched |
| 32 | capture | 01a1a5a6-d5b0-765a-8d8a-34ec094fa5c0 | €9.00 | €0.19 | matched |
| 33 | capture | 01a1a5a6-f271-7319-9a08-f86ec66b0c1f | €15.00 | €0.26 | matched |
| 34 | capture | 01a1a5a7-0d2b-7a2f-a88d-87f75a7f0e49 | €15.00 | €0.26 | matched |
| 35 | capture | 01a1a5a7-4adc-7586-88cb-95d71a231d28 | €9.00 | €0.19 | matched |
| 36 | capture | 01a1a5a7-4e10-747f-b2e7-59ebaf6dab14 | €15.00 | €0.26 | matched |
| 37 | capture | 01a1a5a7-5796-79d9-bb2e-e5e9d1fe3df4 | €24.00 | €0.37 | matched |
| 38 | capture | 01a1a5a7-5896-74a1-96d0-41648f59ae8b | €49.00 | €0.67 | matched |
| 39 | capture | 01a1a5a7-58cc-723a-8db9-af7107b92ddd | €35.00 | €0.50 | matched |
| 40 | capture | 01a1a5a7-5d1c-7317-bd01-3d8f6c31eef7 | €35.00 | €0.50 | matched |
| 41 | capture | 01a1a5a7-897c-786b-99d7-20c910ef3c50 | €24.00 | €0.37 | matched |
| 42 | capture | 01a1a5a7-89d0-7ea3-95eb-a1fbcffa56e0 | €9.00 | €0.19 | matched |
| 43 | capture | 01a1a5a7-8be8-7439-894c-d04e32f96489 | €15.00 | €0.26 | matched |
| 44 | capture | 01a1a5a7-939b-7623-aed4-dd886df6684b | €15.00 | €0.26 | matched |
| 45 | capture | 01a1a5a7-a931-7203-8c86-548a0637eeb8 | €49.00 | €0.67 | matched |
| 46 | capture | 01a1a5a7-b727-73b6-830d-40ad3be67463 | €24.00 | €0.37 | matched |
| 47 | capture | 01a1a5a7-d8b2-7ee9-bd43-07d5970a0aae | €49.00 | €0.67 | matched |
| 48 | capture | 01a1a5a7-ec7f-7c14-81d6-c36e4927e27f | €49.00 | €0.67 | matched |
| 49 | capture | 01a1a5a8-01eb-7874-a048-8a334ffd9798 | €24.00 | €0.37 | matched |
| 50 | refund | 01a1a5a8-1712-78ac-a9ee-0b2b127d8909 | -€31.00 | €0.00 | matched |
| 51 | refund | 01a1a5a8-1787-7a78-91b1-a179e835ed20 | -€24.00 | €0.00 | matched |
| 52 | capture | 01a1a5a8-268a-710a-bda6-c57c7296a63f | €35.00 | €0.50 | matched |
| 53 | capture | 01a1a5a8-2e77-7beb-a0e2-87f077189d5a | €24.00 | €0.37 | matched |
| 54 | capture | 01a1a5a8-3022-7983-9dfa-0ccd8dbfb4e9 | €15.00 | €0.26 | matched |
| 55 | capture | 01a1a5a8-9729-7f2b-b776-5e3f90675729 | €35.00 | €0.50 | matched |
| 56 | capture | 01a1a5a8-a4ee-7ee1-a0c2-00e9d07d4b21 | €9.00 | €0.19 | matched |
| 57 | capture | 01a1a5a8-a6a7-706c-bcf7-f09684e852bc | €9.00 | €0.19 | matched |
| 58 | capture | 01a1a5a8-bd8f-7487-9f2c-65dd2cd8a720 | €9.00 | €0.19 | matched |
| 59 | capture | 01a1a5a8-dc35-76bb-a48c-a54b6774deb9 | €49.00 | €0.67 | matched |
| 60 | capture | 01a1a5a9-2822-701e-97ca-c337ff2081cb | €49.00 | €0.67 | matched |
| 61 | capture | 01a1a5a9-4350-75de-8cca-d6486c148334 | €49.00 | €0.67 | matched |
| 62 | capture | 01a1a5a9-4ca4-7bdc-8a20-a03da1b27457 | €9.00 | €0.19 | matched |
| 63 | capture | 01a1a5a9-6d35-75e7-839a-f4b023197ae5 | €9.00 | €0.19 | matched |
| 64 | capture | 01a1a5a9-6d43-79ef-ab05-8931f89e18c9 | €24.00 | €0.37 | matched |
| 65 | capture | 01a1a5a9-7887-7736-bc96-404f97bb13e8 | €15.00 | €0.26 | matched |
| 66 | capture | 01a1a5a9-8772-75af-8060-b66edc47e862 | €49.00 | €0.67 | matched |
| 67 | capture | 01a1a5a9-8b63-726d-899f-931dfd2e89a6 | €15.00 | €0.26 | matched |
| 68 | capture | 01a1a5a9-955d-7c4c-b62a-5204ad1e25a3 | €24.00 | €0.37 | matched |
| 69 | capture | 01a1a5a9-96c5-7720-a070-0e989a527e86 | €35.00 | €0.50 | matched |
| 70 | capture | 01a1a5a9-a48b-7dc0-b41e-a19aaf8d4f53 | €49.00 | €0.67 | matched |
| 71 | capture | 01a1a5a9-b0f1-7deb-b30b-032cf51a1bb1 | €9.00 | €0.19 | matched |
| 72 | capture | 01a1a5a9-b98e-7a61-b52f-6b59c462b8a3 | €9.00 | €0.19 | matched |
| 73 | capture | 01a1a5a9-babd-7020-860e-73bd9e10822d | €49.00 | €0.67 | matched |
| 74 | capture | 01a1a5a9-bd4b-7842-a4a8-3f6a284f73b3 | €35.00 | €0.50 | matched |
| 75 | capture | 01a1a5a9-f029-7ce4-897c-5b45546dbf51 | €35.00 | €0.50 | matched |
| 76 | refund | 01a1a5a9-f546-7e2e-8bec-ea156e28e75f | -€16.00 | €0.00 | matched |
| 77 | capture | 01a1a5aa-04eb-7b3c-964e-060ea29194e3 | €15.00 | €0.26 | matched |
| 78 | capture | 01a1a5aa-1ac9-7a60-adb8-9193d12b0a83 | €49.00 | €0.67 | matched |
| 79 | capture | 01a1a5aa-5dbb-7d88-9ff0-57fe97bdb7f0 | €35.00 | €0.50 | matched |
| 80 | capture | 01a1a5aa-9a75-7ab7-98e2-68148e45102c | €15.00 | €0.26 | matched |
| 81 | capture | 01a1a5aa-9bfb-78bf-bf62-ab571af36f13 | €49.00 | €0.67 | matched |
| 82 | capture | 01a1a5aa-aff8-715e-8a2e-112e1bf7eeb3 | €24.00 | €0.37 | matched |
| 83 | capture | 01a1a5aa-b407-7192-a6b3-198d44c07a38 | €35.00 | €0.50 | matched |
| 84 | capture | 01a1a5aa-b442-736b-a392-c2b73e34c7b7 | €49.00 | €0.67 | matched |
| 85 | capture | 01a1a5aa-d4f2-76ae-9305-39443a25b8bc | €35.00 | €0.50 | matched |
| 86 | capture | 01a1a5aa-d8f6-7cfc-ab0b-1f0538300c90 | €35.00 | €0.50 | matched |
| 87 | capture | 01a1a5ab-3cfa-7097-83d0-486cd633b2f4 | €9.00 | €0.19 | matched |
| 88 | capture | 01a1a5ab-90c9-74d1-9e44-ff1b8c0c4955 | €24.00 | €0.37 | matched |
| 89 | capture | 01a1a5ab-ad71-74bc-9922-624c05016eb9 | €49.00 | €0.67 | matched |
| 90 | capture | 01a1a5ab-be7d-7aaa-9291-a57ef4724d70 | €35.00 | €0.50 | matched |
| 91 | capture | 01a1a5ab-bebe-7f06-87a7-2c8a844739b5 | €35.00 | €0.50 | matched |
| 92 | capture | 01a1a5ab-c5af-735e-a4a2-2260ff6a896f | €35.00 | €0.50 | matched |
| 93 | capture | 01a1a5ab-ea19-72c4-adda-913f5e910f2c | €49.00 | €0.67 | matched |
| 94 | refund | 01a1a5ab-faf5-76e5-9dfe-0a2875245ea9 | -€22.00 | €0.00 | matched |
| 95 | capture | 01a1a5ab-fd2e-79e5-8051-2ff4e0e6307b | €49.00 | €0.67 | matched |
| 96 | capture | 01a1a5ac-50cb-7d20-ae0c-a77e4ce3cd23 | €35.00 | €0.50 | matched |
| 97 | capture | 01a1a5ac-5445-7ca5-a151-4b2fd0ef65dd | €24.00 | €0.37 | matched |
| 98 | capture | 01a1a5ac-5d83-7e5a-9683-0cf2ae719181 | €35.00 | €0.50 | matched |
| 99 | capture | 01a1a5ac-6b49-7764-a582-4e55355b5b56 | €15.00 | €0.26 | matched |
| 100 | refund | 01a1a5ac-71ef-719b-8134-b5bc719a2d8d | -€26.00 | €0.00 | matched |
| 101 | capture | 01a1a5ac-8dc1-7dcf-b00b-658376396450 | €15.00 | €0.26 | matched |
| 102 | capture | 01a1a5ac-9e00-7dfe-8df1-a6675785377c | €15.00 | €0.26 | matched |
| 103 | refund | 01a1a5ac-a8a7-7d76-8535-e98eab7a50ba | -€18.00 | €0.00 | matched |
| 104 | capture | 01a1a5ac-ac43-7890-8f4e-82e35a810e4c | €49.00 | €0.67 | matched |
| 105 | capture | 01a1a5ac-ae1e-78f7-bd31-35e257f714af | €9.00 | €0.19 | matched |
| 106 | capture | 01a1a5ac-bce5-772c-a6fa-026c2cc00da5 | €49.00 | €0.67 | matched |
| 107 | refund | 01a1a5ac-cad2-739a-a502-af5d09203642 | -€4.00 | €0.00 | matched |
| 108 | refund | 01a1a5ac-db70-7d90-9109-0e3e4abd9974 | -€14.00 | €0.00 | matched |
| 109 | capture | 01a1a5ac-f20c-77dc-9e6d-f132f8104084 | €24.00 | €0.37 | matched |
| 110 | capture | 01a1a5ad-05fc-7663-9800-6a61fc033619 | €15.00 | €0.26 | matched |
| 111 | capture | 01a1a5ad-1ece-774f-b77e-31f4498644e9 | €15.00 | €0.26 | matched |
| 112 | capture | 01a1a5ad-2433-791a-8c6d-d56430e19246 | €24.00 | €0.37 | matched |
| 113 | capture | 01a1a5ad-34f0-74be-a6e6-411f5d481cff | €9.00 | €0.19 | matched |
| 114 | capture | 01a1a5ad-4675-7ce1-8e90-02c11c60e805 | €24.00 | €0.37 | matched |
| 115 | capture | 01a1a5ad-4ce6-76bd-8b49-64be11a8e81b | €24.00 | €0.37 | matched |
| 116 | capture | 01a1a5ad-66d5-7dc4-89e9-cadc8ba5eef8 | €49.00 | €0.67 | matched |
| 117 | capture | 01a1a5ad-6836-7c0c-8fd4-27bc033711eb | €35.00 | €0.50 | matched |
| 118 | capture | 01a1a5ad-5d84-7a12-8080-da8ca07d9833 | €9.00 | €0.19 | matched |
| 119 | capture | 01a1a5ad-89a5-7251-a933-e8e6cc963077 | €24.00 | €0.37 | matched |
| 120 | capture | 01a1a5ad-993a-73c4-b05a-b3ea73aeec68 | €9.00 | €0.19 | matched |
| 121 | capture | 01a1a5ad-dcde-7ef7-bdc9-b69692238e60 | €15.00 | €0.26 | matched |