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
- 2 Nov, 16:50138 lines5 breaks
- 2 Nov, 16:40111 lines2 breaks
- 2 Nov, 16:30123 lines3 breaks
- 2 Nov, 16:20128 lines2 breaks
- 2 Nov, 16:10106 lines2 breaks
- 2 Nov, 16:00106 lines2 breaks
- 2 Nov, 15:50138 lines3 breaks
- 2 Nov, 15:40140 lines2 breaks
- 2 Nov, 15:30125 lines3 breaks
- 2 Nov, 15:20126 lines3 breaks
- 2 Nov, 15:10119 lines2 breaks
- 2 Nov, 15:00109 lines2 breaks
- 2 Nov, 14:50111 lines4 breaks
- 2 Nov, 14:40107 lines3 breaks
2 Nov, 15:50
Gross
€3,136.00
PSP fee
€50.04
Net to the bank
€3,085.96
Settlement journal
#345383
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a19cf6-8df8-7b98-b3a9-5d4b4f554649 is already settled by stl_EUR_2989391 line 40
- fee differencethe fee is not the contract feethe fee is 53, the contract says 50
- missing linein the books, not in the filecapture:01a19cf4-6371-7562-8c8c-7ee2f77fc091 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 41 | capture | 01a19cf6-9b3d-71f5-8f25-62838e489450 | €49.00 | €0.67 | duplicate line |
| 125 | capture | 01a19cfb-e479-7c65-b87b-af5615249233 | €35.00 | €0.53 | fee difference |
| 1 | capture | 01a19cee-dd6e-7727-9682-9fa15d17f6dc | €24.00 | €0.37 | matched |
| 2 | capture | 01a19cf4-0b53-7bb6-af63-bc265ce9faf0 | €24.00 | €0.37 | matched |
| 3 | capture | 01a19cf4-0b54-7c70-b650-bd10aac6cbb2 | €49.00 | €0.67 | matched |
| 4 | capture | 01a19cf4-175a-7b7d-9424-1f85f39a965c | €24.00 | €0.37 | matched |
| 5 | capture | 01a19cf4-2396-7418-98f5-ca7e9cb23b92 | €24.00 | €0.37 | matched |
| 6 | capture | 01a19cf4-396c-7360-9659-1b1a2d81af6f | €35.00 | €0.50 | matched |
| 7 | capture | 01a19cf4-3b1e-7ceb-adf9-58598dbf88f7 | €9.00 | €0.19 | matched |
| 8 | capture | 01a19cf4-6003-7eb9-95aa-33c48d0563dc | €24.00 | €0.37 | matched |
| 9 | capture | 01a19cf4-72e6-7360-a292-133ecfc8d94f | €9.00 | €0.19 | matched |
| 10 | capture | 01a19cf4-89b7-7104-aad1-186a98fded18 | €9.00 | €0.19 | matched |
| 11 | capture | 01a19cf4-bff2-7e75-a537-23805fa47534 | €35.00 | €0.50 | matched |
| 12 | capture | 01a19cf4-c1f0-7268-b818-531c78795035 | €9.00 | €0.19 | matched |
| 13 | capture | 01a19cf4-c369-7197-a264-4c2dfe0330e8 | €15.00 | €0.26 | matched |
| 14 | capture | 01a19cf4-e833-780c-a55b-09bd06ac1d41 | €35.00 | €0.50 | matched |
| 15 | capture | 01a19cf4-f79c-710d-9722-0f06f2e3b981 | €24.00 | €0.37 | matched |
| 16 | capture | 01a19cf4-f8dd-7ef0-a08e-6fcb0817ff1e | €49.00 | €0.67 | matched |
| 17 | capture | 01a19cf5-072e-7a51-a229-ef817931a75b | €24.00 | €0.37 | matched |
| 18 | capture | 01a19cf5-100d-7038-a816-6ba7615063e7 | €24.00 | €0.37 | matched |
| 19 | capture | 01a19cf5-426a-782d-91d5-336e0706cce6 | €35.00 | €0.50 | matched |
| 20 | refund | 01a19cf5-4346-742e-8800-10a5d50d220a | -€30.00 | €0.00 | matched |
| 21 | capture | 01a19cf5-600b-70ed-804d-7dad2fb300b7 | €49.00 | €0.67 | matched |
| 22 | capture | 01a19cf5-79ba-7e99-92d2-94abaa7b228d | €9.00 | €0.19 | matched |
| 23 | capture | 01a19cf5-82a9-7157-a814-d410daf6b82f | €9.00 | €0.19 | matched |
| 24 | capture | 01a19cf5-8808-75b6-ac5b-8f0611264fe3 | €15.00 | €0.26 | matched |
| 25 | capture | 01a19cf5-da04-72cc-9d14-e843c0d2c4c9 | €24.00 | €0.37 | matched |
| 26 | capture | 01a19cf5-e56f-7cdf-9b5f-4baba8a42467 | €24.00 | €0.37 | matched |
| 27 | capture | 01a19cf5-fdd3-728a-91dc-7c33f1166916 | €15.00 | €0.26 | matched |
| 28 | capture | 01a19cf5-fefa-7cdf-a170-f62de881e9ee | €35.00 | €0.50 | matched |
| 29 | capture | 01a19cf6-04b4-70a5-b228-5b3337f4d38a | €24.00 | €0.37 | matched |
| 30 | capture | 01a19cf6-27fe-7b1d-ad11-4d680a461423 | €9.00 | €0.19 | matched |
| 31 | capture | 01a19cf6-2bcf-715e-9ca6-355e4cb34733 | €15.00 | €0.26 | matched |
| 32 | refund | 01a19cf6-358b-73f2-be5b-0ff1b6c0652c | -€18.00 | €0.00 | matched |
| 33 | capture | 01a19cf6-5422-765b-9226-85572257cdce | €49.00 | €0.67 | matched |
| 34 | capture | 01a19cf6-649e-7b94-9e0e-609469f89ad5 | €24.00 | €0.37 | matched |
| 35 | capture | 01a19cf6-6ea4-70aa-85d1-ba3d21ee2285 | €35.00 | €0.50 | matched |
| 36 | capture | 01a19cf6-7f8c-7fd3-93be-97d1c7781a7a | €24.00 | €0.37 | matched |
| 37 | capture | 01a19cf6-8380-7d31-a94a-8fb5287961f2 | €24.00 | €0.37 | matched |
| 38 | capture | 01a19cf6-908e-7c9f-ad7e-c91013a19b5d | €15.00 | €0.26 | matched |
| 39 | capture | 01a19cf6-93c7-7ef3-9658-a6054bde61f0 | €24.00 | €0.37 | matched |
| 40 | capture | 01a19cf6-9b3d-71f5-8f25-62838e489450 | €49.00 | €0.67 | matched |
| 42 | capture | 01a19cf6-a903-7005-b0cc-f25d27744f58 | €15.00 | €0.26 | matched |
| 43 | capture | 01a19cf6-c2e1-74a8-883b-12b33468e17d | €24.00 | €0.37 | matched |
| 44 | capture | 01a19cf6-c57a-73f2-aa05-f0e62c09f9e3 | €35.00 | €0.50 | matched |
| 45 | capture | 01a19cf6-c8cb-7084-b788-ccd6c005122b | €15.00 | €0.26 | matched |
| 46 | capture | 01a19cf6-fcb3-716d-b519-a0ee466f3bca | €9.00 | €0.19 | matched |
| 47 | capture | 01a19cf7-0bdc-7fa3-9bcc-fc8e7c9ac51d | €15.00 | €0.26 | matched |
| 48 | capture | 01a19cf7-1999-77bd-bab2-1cffb440820d | €9.00 | €0.19 | matched |
| 49 | capture | 01a19cf7-38d4-794a-bdd7-5ab42813863b | €35.00 | €0.50 | matched |
| 50 | capture | 01a19cf7-3b43-751b-a89e-09b4e8a7fecd | €15.00 | €0.26 | matched |
| 51 | capture | 01a19cf7-4657-78b0-8c63-2cd8bedd0f38 | €49.00 | €0.67 | matched |
| 52 | capture | 01a19cf7-4fae-7933-a802-30936b9e5ae4 | €15.00 | €0.26 | matched |
| 53 | capture | 01a19cf7-5e3a-757a-b38e-f29b85aea553 | €15.00 | €0.26 | matched |
| 54 | capture | 01a19cf7-61a0-7bd3-8208-70d796d21877 | €9.00 | €0.19 | matched |
| 55 | capture | 01a19cf7-66a4-7092-b6dd-1183dce4cf57 | €9.00 | €0.19 | matched |
| 56 | refund | 01a19cf7-66bb-7740-9ac9-9cb2cd493f38 | -€6.00 | €0.00 | matched |
| 57 | capture | 01a19cf7-b216-7498-81ef-3d49bab1f682 | €24.00 | €0.37 | matched |
| 58 | capture | 01a19cf7-dcc1-7776-b974-6bcd41a63fb0 | €49.00 | €0.67 | matched |
| 59 | capture | 01a19cf7-fe4a-7b66-8438-38658e2fa86a | €9.00 | €0.19 | matched |
| 60 | capture | 01a19cf7-feb9-711d-94b7-cd17009c1b7b | €35.00 | €0.50 | matched |
| 61 | capture | 01a19cf8-07d3-7e2b-a48c-ff7bf0c7defc | €35.00 | €0.50 | matched |
| 62 | capture | 01a19cf8-0b27-747e-9aa7-7c2f3f27105c | €24.00 | €0.37 | matched |
| 63 | capture | 01a19cf8-107e-7f6e-9d58-645d9e5ad978 | €9.00 | €0.19 | matched |
| 64 | capture | 01a19cf8-28db-76b7-90be-9f3dc335a736 | €15.00 | €0.26 | matched |
| 65 | capture | 01a19cf8-327a-7d82-985d-b8e38b506fb5 | €35.00 | €0.50 | matched |
| 66 | capture | 01a19cf8-48c4-7ca8-bb64-8ca555971eae | €9.00 | €0.19 | matched |
| 67 | capture | 01a19cf8-5e0f-7040-9b57-f03bd793f6f4 | €24.00 | €0.37 | matched |
| 68 | refund | 01a19cf8-5f05-7017-a2e6-0ddd7f830783 | -€25.00 | €0.00 | matched |
| 69 | capture | 01a19cf8-70a1-7793-b572-75bbc8ca3c1e | €49.00 | €0.67 | matched |
| 70 | capture | 01a19cf8-7284-7720-85bb-73a406392ae4 | €49.00 | €0.67 | matched |
| 71 | capture | 01a19cf8-7664-720e-b344-85f5bdf90643 | €15.00 | €0.26 | matched |
| 72 | capture | 01a19cf8-b187-7a03-bed2-2bfb9139c5f2 | €35.00 | €0.50 | matched |
| 73 | capture | 01a19cf8-b719-7d0c-b77d-6eaff5c6eaf2 | €24.00 | €0.37 | matched |
| 74 | capture | 01a19cf8-b8f7-7eb5-84c5-f3ee140bef85 | €24.00 | €0.37 | matched |
| 75 | capture | 01a19cf8-b9a3-74b3-8cf6-d28400c2b1c1 | €35.00 | €0.50 | matched |
| 76 | capture | 01a19cf8-d623-7c06-956a-70f59fec7d28 | €49.00 | €0.67 | matched |
| 77 | capture | 01a19cf8-e0a4-7166-88fd-11c44ca6f90c | €35.00 | €0.50 | matched |
| 78 | capture | 01a19cf8-e8da-706e-aa7e-ae9f1b59d567 | €24.00 | €0.37 | matched |
| 79 | refund | 01a19cf9-1c3e-720e-b349-03152f85cb41 | -€22.00 | €0.00 | matched |
| 80 | capture | 01a19cf9-21b5-7892-bcd0-f75f689545ca | €9.00 | €0.19 | matched |
| 81 | capture | 01a19cf9-272a-7ef5-9223-7db88ff22a4a | €35.00 | €0.50 | matched |
| 82 | capture | 01a19cf9-2eb4-702d-ba89-1e5f8ba431a2 | €35.00 | €0.50 | matched |
| 83 | capture | 01a19cf9-359b-7868-b1d2-cde55b39b515 | €9.00 | €0.19 | matched |
| 84 | capture | 01a19cf9-3bcb-7867-9aa0-105dd14a3fac | €24.00 | €0.37 | matched |
| 85 | capture | 01a19cf9-5200-7e02-aff7-b06bf6aa9b9d | €9.00 | €0.19 | matched |
| 86 | capture | 01a19cf9-5893-7300-8fdd-f5b8b0c2fe78 | €49.00 | €0.67 | matched |
| 87 | refund | 01a19cf9-60d1-7d73-b6d1-4496278b9192 | -€4.00 | €0.00 | matched |
| 88 | capture | 01a19cf9-67a3-7014-8765-c3ef264e207f | €49.00 | €0.67 | matched |
| 89 | refund | 01a19cf9-6ae9-737b-84cd-d5256b18219a | -€7.00 | €0.00 | matched |
| 90 | capture | 01a19cf9-81eb-788c-96c7-58abb3e78ff9 | €49.00 | €0.67 | matched |
| 91 | capture | 01a19cf9-9303-7e6c-a2b8-e6e42b65d7f9 | €24.00 | €0.37 | matched |
| 92 | capture | 01a19cf9-b68c-72ce-9e81-4288c3529499 | €15.00 | €0.26 | matched |
| 93 | capture | 01a19cf9-d64d-7519-b69a-ae03bbf144b8 | €24.00 | €0.37 | matched |
| 94 | capture | 01a19cf9-dfde-7884-8dfb-b9eff0038feb | €15.00 | €0.26 | matched |
| 95 | capture | 01a19cf9-ed42-7ca0-aca7-d496c0ac2439 | €9.00 | €0.19 | matched |
| 96 | capture | 01a19cf9-f8b0-7150-9cca-206ebaa0fa1e | €35.00 | €0.50 | matched |
| 97 | refund | 01a19cf9-fd46-70a0-ae89-59625bf8514e | -€8.00 | €0.00 | matched |
| 98 | capture | 01a19cfa-1651-7837-856e-a030fb79a93c | €49.00 | €0.67 | matched |
| 99 | capture | 01a19cfa-2643-732c-a50f-9fa9a33f8e4b | €49.00 | €0.67 | matched |
| 100 | capture | 01a19cfa-2a34-77db-a2f4-885a724670d4 | €24.00 | €0.37 | matched |
| 101 | capture | 01a19cfa-2d36-768c-9663-36f961cc1319 | €24.00 | €0.37 | matched |
| 102 | capture | 01a19cfa-48f4-7738-b8e8-c1b3b78e1985 | €9.00 | €0.19 | matched |
| 103 | capture | 01a19cfa-52e4-77b8-b1b0-d208007d43ca | €9.00 | €0.19 | matched |
| 104 | capture | 01a19cfa-816a-7f53-80e7-ba7ae4ee148b | €15.00 | €0.26 | matched |
| 105 | capture | 01a19cfa-96f1-7cf4-831b-1c3f8cdfc8ca | €15.00 | €0.26 | matched |
| 106 | capture | 01a19cfa-aeda-70d9-ad3e-4d7fda6839e1 | €9.00 | €0.19 | matched |
| 107 | capture | 01a19cfa-bbc8-7f6e-a6a4-277d0ee75f48 | €24.00 | €0.37 | matched |
| 108 | capture | 01a19cfa-bdea-7a89-9b15-df2bb944d3aa | €9.00 | €0.19 | matched |
| 109 | capture | 01a19cfa-ca6b-772a-a88f-b469f505b8e6 | €49.00 | €0.67 | matched |
| 110 | capture | 01a19cfa-edbc-7a4d-9aac-37945724def7 | €49.00 | €0.67 | matched |
| 111 | capture | 01a19cfb-1e76-75ad-bfa3-4fda7b021a56 | €15.00 | €0.26 | matched |
| 112 | capture | 01a19cfb-6106-79da-ba34-a6e0e1e35f98 | €35.00 | €0.50 | matched |
| 113 | capture | 01a19cfb-63de-7ef3-bbc6-34e980b2afbe | €49.00 | €0.67 | matched |
| 114 | capture | 01a19cfb-6e0d-77b6-a825-3fceccddc5bb | €35.00 | €0.50 | matched |
| 115 | capture | 01a19cfb-71c4-77ca-8303-6d4db813f826 | €15.00 | €0.26 | matched |
| 116 | capture | 01a19cfb-7228-756e-a9a2-2d5f8354ae98 | €15.00 | €0.26 | matched |
| 117 | capture | 01a19cfb-6e98-78ca-a33f-e778000cc7d9 | €15.00 | €0.26 | matched |
| 118 | refund | 01a19cfb-9efe-7a24-9477-836b37b6fc7c | -€10.00 | €0.00 | matched |
| 119 | capture | 01a19cfb-a188-758f-9046-e70404423917 | €49.00 | €0.67 | matched |
| 120 | capture | 01a19cfb-c624-7369-8711-0265277aff11 | €49.00 | €0.67 | matched |
| 121 | capture | 01a19cfb-c806-7154-b0f4-c2a8984015df | €24.00 | €0.37 | matched |
| 122 | capture | 01a19cfb-d194-767a-acb1-3438dff722ff | €15.00 | €0.26 | matched |
| 123 | capture | 01a19cfb-d7d4-7893-a732-a102a85aa11e | €49.00 | €0.67 | matched |
| 124 | capture | 01a19cfb-db37-7973-a5e4-d473693ba840 | €24.00 | €0.37 | matched |
| 126 | refund | 01a19cfc-01fa-70d8-b835-6bd404ff90bf | -€13.00 | €0.00 | matched |
| 127 | capture | 01a19cfc-066e-7842-8cea-20a893a67716 | €9.00 | €0.19 | matched |
| 128 | refund | 01a19cfc-17f5-763d-ba68-82683bb55e41 | -€28.00 | €0.00 | matched |
| 129 | capture | 01a19cfc-4d06-7e76-93d5-51f208863932 | €24.00 | €0.37 | matched |
| 130 | capture | 01a19cfc-6cd6-7dd6-9c1d-54ed464f092a | €24.00 | €0.37 | matched |
| 131 | capture | 01a19cfc-7474-7817-ba34-111287bf311e | €24.00 | €0.37 | matched |
| 132 | capture | 01a19cfc-8d8d-733b-9a3a-8aae76dbd059 | €24.00 | €0.37 | matched |
| 133 | capture | 01a19cfc-9b66-714f-a222-69c5e11cbc02 | €24.00 | €0.37 | matched |
| 134 | capture | 01a19cfc-a7cc-7400-b3ca-a317d3d069f7 | €49.00 | €0.67 | matched |
| 135 | capture | 01a19cfc-c1de-727c-a542-937aed7cc9b3 | €15.00 | €0.26 | matched |
| 136 | capture | 01a19cfc-ce27-7c2c-b39a-4bdf49a30362 | €49.00 | €0.67 | matched |
| 137 | capture | 01a19cfc-f759-7f5c-88f7-6ed271b734f8 | €24.00 | €0.37 | matched |
| 138 | capture | 01a19cfd-05a9-79fd-82af-a0b47f8d58e1 | €15.00 | €0.26 | matched |