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
- 3 Nov, 09:30142 lines4 breaks
- 3 Nov, 09:20130 linesclean
- 3 Nov, 09:10118 lines1 break
- 3 Nov, 09:00137 lines5 breaks
- 3 Nov, 08:50125 lines3 breaks
- 3 Nov, 08:40116 lines4 breaks
- 3 Nov, 08:30118 lines4 breaks
- 3 Nov, 08:20124 lines2 breaks
- 3 Nov, 08:10121 lines1 break
- 3 Nov, 08:00114 lines2 breaks
- 3 Nov, 07:50128 lines3 breaks
- 3 Nov, 07:40100 lines1 break
- 3 Nov, 07:30122 lines3 breaks
- 3 Nov, 07:20116 lines1 break
3 Nov, 08:20
Gross
€2,644.00
PSP fee
€41.91
Net to the bank
€2,602.09
Settlement journal
#357981
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1a07f-7301-701d-8c6c-34bfec47c704 is already settled by stl_EUR_2989490 line 16
- missing linein the books, not in the filecapture:01a1a07e-7cab-76e8-a996-4cd683a20639 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 17 | capture | 01a1a07f-7339-7efc-a598-afee562b53b8 | €9.00 | €0.19 | duplicate line |
| 1 | capture | 01a1a076-50e0-7e16-a4eb-8837f791ecbc | €9.00 | €0.19 | matched |
| 2 | capture | 01a1a077-3996-7a80-9356-bc1b94fcddc4 | €15.00 | €0.26 | matched |
| 3 | capture | 01a1a07d-5897-7ab3-82e2-cc1a01a6c767 | €49.00 | €0.67 | matched |
| 4 | capture | 01a1a07e-7ecc-75e0-a681-dcdeed85bd51 | €15.00 | €0.26 | matched |
| 5 | capture | 01a1a07e-9266-72d3-b0a6-28080f8129f5 | €24.00 | €0.37 | matched |
| 6 | capture | 01a1a07e-99db-7550-bd10-de054b69a6d9 | €15.00 | €0.26 | matched |
| 7 | capture | 01a1a07e-9b5f-779d-ab63-157407e22fd8 | €35.00 | €0.50 | matched |
| 8 | capture | 01a1a07e-a595-7bcd-9ce8-2700782a777d | €35.00 | €0.50 | matched |
| 9 | capture | 01a1a07e-c42b-7405-a726-cd6721d4e0f8 | €49.00 | €0.67 | matched |
| 10 | capture | 01a1a07e-d23c-70fa-9432-f0d293018312 | €9.00 | €0.19 | matched |
| 11 | refund | 01a1a07e-d4b0-7243-b6cb-dfc6f24002ec | -€11.00 | €0.00 | matched |
| 12 | capture | 01a1a07e-f245-7683-8d95-d1d96bee1976 | €24.00 | €0.37 | matched |
| 13 | capture | 01a1a07f-0dd9-7a81-8ef7-eb023efb7798 | €35.00 | €0.50 | matched |
| 14 | capture | 01a1a07f-2de2-793e-a7d9-6019a7007d56 | €49.00 | €0.67 | matched |
| 15 | capture | 01a1a07f-70b7-7348-aa2b-a339f364074f | €35.00 | €0.50 | matched |
| 16 | capture | 01a1a07f-7339-7efc-a598-afee562b53b8 | €9.00 | €0.19 | matched |
| 18 | capture | 01a1a07f-7ec2-74bf-b835-fb5e6aefed02 | €9.00 | €0.19 | matched |
| 19 | capture | 01a1a07f-cf57-79a0-b263-612f3708c89f | €49.00 | €0.67 | matched |
| 20 | capture | 01a1a07f-d20f-7490-8eab-48721920a797 | €49.00 | €0.67 | matched |
| 21 | capture | 01a1a07f-f760-7ec7-9f06-7683f2373198 | €15.00 | €0.26 | matched |
| 22 | capture | 01a1a080-3e0a-7231-8807-590ded4f9fa6 | €9.00 | €0.19 | matched |
| 23 | capture | 01a1a080-462f-7f8f-8fc5-fdd51759bd98 | €49.00 | €0.67 | matched |
| 24 | capture | 01a1a080-6c01-7296-ae48-26d227dc4303 | €9.00 | €0.19 | matched |
| 25 | capture | 01a1a080-6d45-71c7-aaae-cf0fcdbca032 | €35.00 | €0.50 | matched |
| 26 | refund | 01a1a080-7729-782b-9f4a-a3b0bb3ef19a | -€7.00 | €0.00 | matched |
| 27 | capture | 01a1a080-79a9-7066-b378-5433a67fafd9 | €15.00 | €0.26 | matched |
| 28 | capture | 01a1a080-8a40-7cbb-9266-64a5d5305c38 | €49.00 | €0.67 | matched |
| 29 | capture | 01a1a080-8bad-7c32-99ad-a6c0fd72cd3d | €15.00 | €0.26 | matched |
| 30 | capture | 01a1a080-940a-7c6b-8cbd-333ed8ced163 | €49.00 | €0.67 | matched |
| 31 | capture | 01a1a080-9705-72da-b1a8-e5335258201f | €15.00 | €0.26 | matched |
| 32 | capture | 01a1a080-99a9-74b8-8ad3-e4b836c18838 | €35.00 | €0.50 | matched |
| 33 | capture | 01a1a080-9be0-710b-95cd-79e2fac7fe9d | €9.00 | €0.19 | matched |
| 34 | capture | 01a1a080-b322-76bc-9476-5f8e4954892b | €24.00 | €0.37 | matched |
| 35 | capture | 01a1a080-af68-79da-bd4c-7158b09205f5 | €49.00 | €0.67 | matched |
| 36 | refund | 01a1a080-c672-7633-a43d-31e02a378c24 | -€11.00 | €0.00 | matched |
| 37 | capture | 01a1a080-ca45-714e-9845-8e099d4090f9 | €35.00 | €0.50 | matched |
| 38 | capture | 01a1a080-d0c5-7183-adab-35b24b5ec7da | €24.00 | €0.37 | matched |
| 39 | capture | 01a1a080-d383-73ef-918f-af741bfc2fd3 | €24.00 | €0.37 | matched |
| 40 | capture | 01a1a080-dd11-7720-a1c3-e89605f38734 | €9.00 | €0.19 | matched |
| 41 | capture | 01a1a080-e4f9-780a-b784-4e496b18109e | €9.00 | €0.19 | matched |
| 42 | capture | 01a1a080-e7ad-70ae-961b-ee19ba016cdc | €15.00 | €0.26 | matched |
| 43 | refund | 01a1a080-ebfc-796e-a2a8-c03376d217f3 | -€14.00 | €0.00 | matched |
| 44 | refund | 01a1a080-fcfc-78ec-a75e-280980ffa9b1 | -€7.00 | €0.00 | matched |
| 45 | capture | 01a1a081-249b-7ff3-9881-4425b5184786 | €15.00 | €0.26 | matched |
| 46 | capture | 01a1a081-5b19-75f2-bfb2-6efce42aa266 | €15.00 | €0.26 | matched |
| 47 | capture | 01a1a081-5f98-79ab-a62a-d9cafa6dfbf2 | €49.00 | €0.67 | matched |
| 48 | capture | 01a1a081-67cd-7a12-bc98-13ba8e66166d | €9.00 | €0.19 | matched |
| 49 | capture | 01a1a081-69ea-73c7-a2b2-cef56a8a7465 | €15.00 | €0.26 | matched |
| 50 | capture | 01a1a081-6b83-7e03-913e-72c7e6b6497a | €24.00 | €0.37 | matched |
| 51 | capture | 01a1a081-79a2-7e39-960d-dd4ebc312a50 | €35.00 | €0.50 | matched |
| 52 | capture | 01a1a081-7e65-733d-ab84-57bcdb60712b | €15.00 | €0.26 | matched |
| 53 | capture | 01a1a081-bbf3-768d-826a-c8e146ea813c | €24.00 | €0.37 | matched |
| 54 | capture | 01a1a081-c0bc-7224-996e-45be398228a8 | €24.00 | €0.37 | matched |
| 55 | capture | 01a1a081-d61c-717d-9237-185d9e77ee68 | €15.00 | €0.26 | matched |
| 56 | capture | 01a1a081-e9b9-7731-845e-04e3efc3ef9b | €24.00 | €0.37 | matched |
| 57 | capture | 01a1a082-1bfc-7994-8da9-c2b39fa0cff5 | €49.00 | €0.67 | matched |
| 58 | capture | 01a1a082-2a3a-7d87-9bde-7bfe91d97ad2 | €9.00 | €0.19 | matched |
| 59 | capture | 01a1a082-33dc-7a03-a565-ec10511a62e4 | €35.00 | €0.50 | matched |
| 60 | capture | 01a1a082-357a-760b-984b-1a620c8355f1 | €35.00 | €0.50 | matched |
| 61 | capture | 01a1a082-3633-709c-a21e-88f32b752fc9 | €49.00 | €0.67 | matched |
| 62 | capture | 01a1a082-52bc-71f4-9e41-e95fe1aa4ba0 | €9.00 | €0.19 | matched |
| 63 | capture | 01a1a082-5eb7-72b9-a752-e2d68a15efd7 | €15.00 | €0.26 | matched |
| 64 | capture | 01a1a082-8dec-79c1-995b-7fe5073b28b3 | €9.00 | €0.19 | matched |
| 65 | capture | 01a1a082-ac27-79da-a8b1-6cabb57ed839 | €35.00 | €0.50 | matched |
| 66 | refund | 01a1a082-ac6b-7d8d-9621-98f09d069ee3 | -€3.00 | €0.00 | matched |
| 67 | capture | 01a1a082-b4a5-72c3-a0b0-b8fc4a3963cb | €49.00 | €0.67 | matched |
| 68 | capture | 01a1a083-183b-77ed-b341-d890201a3b1d | €49.00 | €0.67 | matched |
| 69 | capture | 01a1a083-1869-7c82-94f6-c7eedbbb84c5 | €9.00 | €0.19 | matched |
| 70 | capture | 01a1a083-1e4f-72db-8fef-1048ee3e63a3 | €24.00 | €0.37 | matched |
| 71 | capture | 01a1a083-8dd2-7b7c-bc0d-27f856b3d7b4 | €35.00 | €0.50 | matched |
| 72 | capture | 01a1a083-abd6-7092-ac44-28adf16a6e32 | €9.00 | €0.19 | matched |
| 73 | capture | 01a1a083-b7ac-7ea0-af9e-6a82e9ef5994 | €9.00 | €0.19 | matched |
| 74 | capture | 01a1a083-bf49-7704-b3b9-be2847f38693 | €15.00 | €0.26 | matched |
| 75 | capture | 01a1a083-e48d-7cf6-b0cd-8c5274a5ec0e | €15.00 | €0.26 | matched |
| 76 | capture | 01a1a083-e4af-77b7-8ddc-069e2ee79a4d | €9.00 | €0.19 | matched |
| 77 | capture | 01a1a083-edb0-7713-afa9-96493af1d314 | €24.00 | €0.37 | matched |
| 78 | capture | 01a1a084-0575-796c-8891-d89906040eb6 | €24.00 | €0.37 | matched |
| 79 | capture | 01a1a084-142c-75fc-9585-84f374f63923 | €9.00 | €0.19 | matched |
| 80 | capture | 01a1a084-15dc-78e0-bca1-ebdbd5b0aefb | €15.00 | €0.26 | matched |
| 81 | capture | 01a1a084-1fae-7cf6-bb9b-0350f2ee81be | €35.00 | €0.50 | matched |
| 82 | capture | 01a1a084-2ba4-79c7-9720-e46820d90289 | €24.00 | €0.37 | matched |
| 83 | refund | 01a1a084-33a8-753e-907d-10da2cc8f391 | -€4.00 | €0.00 | matched |
| 84 | capture | 01a1a084-4328-702f-9bfd-375cfb1185af | €9.00 | €0.19 | matched |
| 85 | capture | 01a1a084-4da3-7cb8-965d-c6502780bda9 | €9.00 | €0.19 | matched |
| 86 | capture | 01a1a084-5ce4-7a7c-b0aa-4f8e057b44ad | €9.00 | €0.19 | matched |
| 87 | capture | 01a1a084-6706-7dfe-a3f5-b4b8b026ef67 | €49.00 | €0.67 | matched |
| 88 | capture | 01a1a084-9fa0-7f25-bb06-38b071fccc76 | €24.00 | €0.37 | matched |
| 89 | capture | 01a1a084-acc8-70f6-ab5e-da65ed77a8d3 | €24.00 | €0.37 | matched |
| 90 | capture | 01a1a084-e469-7cab-b45d-3dfb09ee59ea | €35.00 | €0.50 | matched |
| 91 | capture | 01a1a084-f72f-7235-9d0a-a1ee8023b764 | €49.00 | €0.67 | matched |
| 92 | capture | 01a1a084-fcf1-7928-9f50-c0eb8b4b281c | €9.00 | €0.19 | matched |
| 93 | capture | 01a1a085-111a-7dd7-a690-94a61a0b7cf4 | €24.00 | €0.37 | matched |
| 94 | capture | 01a1a085-1642-7f35-a5f3-56a03951192d | €15.00 | €0.26 | matched |
| 95 | capture | 01a1a085-3d3d-77f2-96ee-c5f9c75c7850 | €9.00 | €0.19 | matched |
| 96 | capture | 01a1a085-6041-7368-8264-d11adeffc70e | €15.00 | €0.26 | matched |
| 97 | refund | 01a1a085-66e3-756c-b565-d94c48288f35 | -€13.00 | €0.00 | matched |
| 98 | refund | 01a1a085-7220-7a15-b45d-bad399a2d097 | -€4.00 | €0.00 | matched |
| 99 | capture | 01a1a085-8cb1-7c66-897f-c5f763e0c94a | €35.00 | €0.50 | matched |
| 100 | capture | 01a1a085-aaa8-7489-af44-765b838433f1 | €15.00 | €0.26 | matched |
| 101 | capture | 01a1a085-ea8b-73fb-8d98-6dcfd294b93d | €15.00 | €0.26 | matched |
| 102 | capture | 01a1a085-fe7c-7223-a850-ae5aeecd6d3c | €35.00 | €0.50 | matched |
| 103 | capture | 01a1a086-0a20-7a45-a44c-bc2b0fa578bb | €24.00 | €0.37 | matched |
| 104 | capture | 01a1a086-1213-7469-bcb9-73692f783d1c | €15.00 | €0.26 | matched |
| 105 | capture | 01a1a086-1425-7d71-b38d-bafa7c011829 | €35.00 | €0.50 | matched |
| 106 | capture | 01a1a086-1491-72c6-b1ca-4ede45a03ef4 | €9.00 | €0.19 | matched |
| 107 | capture | 01a1a086-1bc6-70a2-b94f-d42692a90953 | €49.00 | €0.67 | matched |
| 108 | refund | 01a1a086-36cd-75a9-bc4f-7dc8da8d2e5f | -€6.00 | €0.00 | matched |
| 109 | capture | 01a1a086-3b1d-74e9-86a5-03ccdd59eecc | €15.00 | €0.26 | matched |
| 110 | refund | 01a1a086-3f24-72c3-a58c-b802c3112e06 | -€4.00 | €0.00 | matched |
| 111 | capture | 01a1a086-486d-7366-9855-ac8b25924448 | €35.00 | €0.50 | matched |
| 112 | capture | 01a1a086-4e41-7d0b-af86-b28967d95d2a | €9.00 | €0.19 | matched |
| 113 | capture | 01a1a086-a6aa-7925-9397-810732d630b3 | €24.00 | €0.37 | matched |
| 114 | capture | 01a1a086-a9df-7565-984c-d53edcd8b7ae | €15.00 | €0.26 | matched |
| 115 | capture | 01a1a086-aa91-71b5-9fbf-2dbd6933e3f6 | €9.00 | €0.19 | matched |
| 116 | capture | 01a1a086-d30c-7f6f-9f2e-bd8f90dc35a3 | €15.00 | €0.26 | matched |
| 117 | capture | 01a1a086-ec0d-7f21-9f79-bf3f6fb32d9e | €35.00 | €0.50 | matched |
| 118 | capture | 01a1a087-0232-730a-bbfb-dbbc28f2c6ad | €24.00 | €0.37 | matched |
| 119 | capture | 01a1a087-2070-7b8a-9e36-7c0731c3b63a | €49.00 | €0.67 | matched |
| 120 | capture | 01a1a087-26d1-7171-80e7-ce0162b3f9b0 | €35.00 | €0.50 | matched |
| 121 | capture | 01a1a087-2ff5-7c37-829e-20e9ce95481f | €9.00 | €0.19 | matched |
| 122 | capture | 01a1a087-4cf1-71b3-8ff7-591b5e42fdf2 | €15.00 | €0.26 | matched |
| 123 | capture | 01a1a087-552c-7a36-b97c-fdd9872844ae | €24.00 | €0.37 | matched |
| 124 | capture | 01a1a087-7496-71cd-b2c2-8545ba28282c | €24.00 | €0.37 | matched |