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
- 30 Oct, 04:30123 lines3 breaks
- 30 Oct, 04:20121 lines3 breaks
- 30 Oct, 04:10123 lines1 break
- 30 Oct, 04:00121 lines2 breaks
- 30 Oct, 03:50111 lines1 break
- 30 Oct, 03:40133 lines3 breaks
- 30 Oct, 03:30136 lines5 breaks
- 30 Oct, 03:20130 lines2 breaks
- 30 Oct, 03:10122 lines3 breaks
- 30 Oct, 03:00108 lines3 breaks
- 30 Oct, 02:50125 lines4 breaks
- 30 Oct, 02:40112 lines3 breaks
- 30 Oct, 02:30111 lines2 breaks
- 30 Oct, 02:20143 lines6 breaks
30 Oct, 03:30
Gross
€2,951.00
PSP fee
€46.74
Net to the bank
€2,904.26
Settlement journal
#280968
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a18adc-7e81-7bfb-bc89-1cf229ba2135 is already settled by stl_EUR_2988885 line 20
- duplicate linethe file lists it twicerefund:01a18ae2-537c-7ecb-a88e-6641000b84a1 is already settled by stl_EUR_2988885 line 92
- fee differencethe fee is not the contract feethe fee is 68, the contract says 67
- fee differencethe fee is not the contract feethe fee is 21, the contract says 19
- missing linein the books, not in the filecapture:01a18adb-9b6d-77e9-8e96-da58941a1b5f is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 21 | capture | 01a18adc-7eab-7914-a7f2-892b00ee5ba7 | €15.00 | €0.26 | duplicate line |
| 65 | capture | 01a18ae0-0ae0-768b-904b-f2a00a5156e3 | €49.00 | €0.68 | fee difference |
| 87 | capture | 01a18ae1-fe1a-7553-b518-34004eaae699 | €9.00 | €0.21 | fee difference |
| 93 | refund | 01a18ae2-537e-74f0-aaed-130e6135f72d | -€12.00 | €0.00 | duplicate line |
| 1 | capture | 01a18ad2-4d8c-7ec9-afcb-82cc168bd72a | €49.00 | €0.67 | matched |
| 2 | capture | 01a18ad4-8118-7bca-ad95-83bced6d7bfe | €9.00 | €0.19 | matched |
| 3 | capture | 01a18ad5-f857-7f0f-ab04-7bfda8807ade | €24.00 | €0.37 | matched |
| 4 | capture | 01a18ad7-7632-7aa7-93f4-7e306d5e9106 | €15.00 | €0.26 | matched |
| 5 | capture | 01a18ad9-8e7e-7879-9fe4-3314369e738e | €9.00 | €0.19 | matched |
| 6 | capture | 01a18adb-8606-7a1a-ac09-2967059857e4 | €9.00 | €0.19 | matched |
| 7 | capture | 01a18adb-95d2-7f73-b1ab-1401b013fe0a | €24.00 | €0.37 | matched |
| 8 | capture | 01a18adb-95ff-7f6d-b8a8-bafd6db5860c | €9.00 | €0.19 | matched |
| 9 | capture | 01a18adb-a04c-7430-ae5a-2eb25dc74079 | €9.00 | €0.19 | matched |
| 10 | capture | 01a18adb-a961-7d19-89e9-f3f8d2781ac8 | €49.00 | €0.67 | matched |
| 11 | capture | 01a18adb-c7a5-7ec8-ba5b-8198d68fa8f4 | €15.00 | €0.26 | matched |
| 12 | refund | 01a18adb-d20b-7eab-a07a-e690961ab6a7 | -€6.00 | €0.00 | matched |
| 13 | capture | 01a18adb-efbe-7f66-882f-bcdf9d0a73a4 | €24.00 | €0.37 | matched |
| 14 | capture | 01a18adb-f0b3-7c81-9f88-f27bcadb3b86 | €35.00 | €0.50 | matched |
| 15 | capture | 01a18adb-f92c-7fab-9884-21fdf007ed44 | €9.00 | €0.19 | matched |
| 16 | capture | 01a18adc-227b-78f4-bc63-9c60ca9c0404 | €49.00 | €0.67 | matched |
| 17 | capture | 01a18adc-2fad-7efb-bb23-60262570a0e2 | €35.00 | €0.50 | matched |
| 18 | capture | 01a18adc-3fb3-7fd9-a3f6-a61b211f723b | €15.00 | €0.26 | matched |
| 19 | capture | 01a18adc-7c38-7cb5-8954-d1c8caa4be7f | €24.00 | €0.37 | matched |
| 20 | capture | 01a18adc-7eab-7914-a7f2-892b00ee5ba7 | €15.00 | €0.26 | matched |
| 22 | capture | 01a18adc-959a-7873-bd38-36daa8b732cf | €49.00 | €0.67 | matched |
| 23 | capture | 01a18adc-9dc0-703b-bf6f-8f47fbc3178d | €15.00 | €0.26 | matched |
| 24 | capture | 01a18adc-9e12-76e2-843a-fce5f12e41cc | €24.00 | €0.37 | matched |
| 25 | capture | 01a18adc-c06c-76e0-bbae-a6e9ef9b7e40 | €35.00 | €0.50 | matched |
| 26 | capture | 01a18adc-c818-742f-b6b2-6b98d937678d | €24.00 | €0.37 | matched |
| 27 | capture | 01a18adc-e387-7235-999c-4ba6312274df | €15.00 | €0.26 | matched |
| 28 | capture | 01a18adc-fd6d-750e-acf3-7ea05a108914 | €15.00 | €0.26 | matched |
| 29 | capture | 01a18add-3260-74ef-9fc1-1aba720e06df | €35.00 | €0.50 | matched |
| 30 | capture | 01a18add-42f0-757e-85d7-53229b8d93ef | €24.00 | €0.37 | matched |
| 31 | capture | 01a18add-5f0d-78f4-a2aa-758e4237a503 | €24.00 | €0.37 | matched |
| 32 | capture | 01a18add-63c1-76fb-a8d8-4cb448fd2bc0 | €24.00 | €0.37 | matched |
| 33 | refund | 01a18add-6564-7bc0-b233-3386e627061f | -€10.00 | €0.00 | matched |
| 34 | capture | 01a18add-8442-795d-9332-7624cd4daabb | €15.00 | €0.26 | matched |
| 35 | capture | 01a18add-9834-7379-9c9f-9cc40fb2334e | €15.00 | €0.26 | matched |
| 36 | capture | 01a18add-c983-7e63-b7c5-99d4572edb86 | €24.00 | €0.37 | matched |
| 37 | capture | 01a18ade-0822-7ccb-806f-348fbcafe662 | €49.00 | €0.67 | matched |
| 38 | capture | 01a18ade-22ef-77c1-8028-c88067269e89 | €9.00 | €0.19 | matched |
| 39 | capture | 01a18ade-4ad1-7740-9048-704631555a89 | €9.00 | €0.19 | matched |
| 40 | capture | 01a18ade-589e-77a9-b13a-70178299ab98 | €49.00 | €0.67 | matched |
| 41 | capture | 01a18ade-932f-7576-9374-83619f3fd8ad | €9.00 | €0.19 | matched |
| 42 | capture | 01a18ade-9bb2-7c5a-8987-60b65daea59f | €49.00 | €0.67 | matched |
| 43 | capture | 01a18ade-b10f-717b-91b0-d5baceea900d | €9.00 | €0.19 | matched |
| 44 | capture | 01a18ade-c253-72ba-bf17-0be12c48c39b | €9.00 | €0.19 | matched |
| 45 | capture | 01a18adf-0403-72c9-98c0-c1497dfffde2 | €15.00 | €0.26 | matched |
| 46 | refund | 01a18adf-055a-7eeb-8e9c-a81d3e0d7741 | -€5.00 | €0.00 | matched |
| 47 | capture | 01a18adf-0a41-7247-9c67-39d970355af2 | €35.00 | €0.50 | matched |
| 48 | capture | 01a18adf-0b0f-7408-b49c-32c5062e155c | €9.00 | €0.19 | matched |
| 49 | capture | 01a18adf-0e0d-7e15-a6ba-e8c06e2d09f5 | €9.00 | €0.19 | matched |
| 50 | capture | 01a18adf-18ee-7440-bcb1-5c06ff407258 | €15.00 | €0.26 | matched |
| 51 | capture | 01a18adf-2eb5-722f-84a8-c8b816470217 | €35.00 | €0.50 | matched |
| 52 | capture | 01a18adf-3c07-7c00-9543-1ac010bd4ea1 | €24.00 | €0.37 | matched |
| 53 | capture | 01a18adf-58a9-7eb5-8cdd-d625d852a90b | €24.00 | €0.37 | matched |
| 54 | capture | 01a18adf-60a1-765e-97d6-6baf611b3dee | €35.00 | €0.50 | matched |
| 55 | capture | 01a18adf-6add-79c5-9643-51de6b5d54d4 | €9.00 | €0.19 | matched |
| 56 | capture | 01a18adf-6d2d-7ca6-ac22-4d0c0d152f7d | €49.00 | €0.67 | matched |
| 57 | capture | 01a18adf-72e7-710b-96b3-fd4d1dd51501 | €9.00 | €0.19 | matched |
| 58 | capture | 01a18adf-9e78-745e-8984-81c772d35075 | €49.00 | €0.67 | matched |
| 59 | capture | 01a18adf-aa15-7fe1-b154-11cdb265769a | €9.00 | €0.19 | matched |
| 60 | capture | 01a18adf-ade9-7e56-9f59-87d8e3ab0243 | €49.00 | €0.67 | matched |
| 61 | refund | 01a18adf-b0a2-704a-8a13-0292ce774656 | -€3.00 | €0.00 | matched |
| 62 | capture | 01a18adf-d6af-7673-b43b-6975a4fc48f2 | €9.00 | €0.19 | matched |
| 63 | capture | 01a18adf-ff95-7673-bb89-291323f35687 | €9.00 | €0.19 | matched |
| 64 | capture | 01a18ae0-0148-7126-b134-800574354674 | €35.00 | €0.50 | matched |
| 66 | capture | 01a18ae0-20b7-7030-bb77-bf527cd814fc | €9.00 | €0.19 | matched |
| 67 | capture | 01a18ae0-40d6-7597-be2e-7e1df66d168f | €15.00 | €0.26 | matched |
| 68 | capture | 01a18ae0-4d7c-7c94-94c5-6204beacbb7b | €9.00 | €0.19 | matched |
| 69 | capture | 01a18ae0-5924-7392-97e4-4f49f7612a3c | €15.00 | €0.26 | matched |
| 70 | capture | 01a18ae0-74d4-7f78-977f-370ee583cdab | €49.00 | €0.67 | matched |
| 71 | capture | 01a18ae0-79d0-7115-bb92-436114bc7ef3 | €35.00 | €0.50 | matched |
| 72 | capture | 01a18ae0-d326-7454-8b51-ded566f1d7c0 | €15.00 | €0.26 | matched |
| 73 | capture | 01a18ae0-fc96-7968-8705-c7866d136d82 | €35.00 | €0.50 | matched |
| 74 | capture | 01a18ae1-00c5-730c-9927-898d5d79bdcd | €15.00 | €0.26 | matched |
| 75 | capture | 01a18ae1-02c0-7556-8399-d8818954b6b0 | €9.00 | €0.19 | matched |
| 76 | capture | 01a18ae1-34e4-77a0-af96-7dc508d1cde7 | €24.00 | €0.37 | matched |
| 77 | capture | 01a18ae1-5434-783c-aeff-830fd7991146 | €24.00 | €0.37 | matched |
| 78 | capture | 01a18ae1-5711-783a-9f9e-b4984127dc86 | €15.00 | €0.26 | matched |
| 79 | capture | 01a18ae1-5f57-702b-b950-3cf2bdae8308 | €24.00 | €0.37 | matched |
| 80 | capture | 01a18ae1-6842-79ac-8457-6ce2e0a1d879 | €35.00 | €0.50 | matched |
| 81 | capture | 01a18ae1-73ff-703b-99c4-79af964d8e9d | €9.00 | €0.19 | matched |
| 82 | capture | 01a18ae1-9c3d-7702-8bcb-8ac603aa102e | €49.00 | €0.67 | matched |
| 83 | capture | 01a18ae1-c318-78db-befa-763dba0a81d2 | €15.00 | €0.26 | matched |
| 84 | capture | 01a18ae1-cd9e-721f-bacf-ab0cb8e3b7ef | €35.00 | €0.50 | matched |
| 85 | capture | 01a18ae1-d1c3-752d-bbd2-390e68332d2d | €24.00 | €0.37 | matched |
| 86 | capture | 01a18ae1-f560-7686-bef4-20658331a51d | €24.00 | €0.37 | matched |
| 88 | refund | 01a18ae1-ffff-7436-8994-351c6ed9a2cd | -€22.00 | €0.00 | matched |
| 89 | refund | 01a18ae2-0ff8-76be-8941-89dd9f3ce33f | -€7.00 | €0.00 | matched |
| 90 | capture | 01a18ae2-1f32-7932-9215-191f58a4b381 | €15.00 | €0.26 | matched |
| 91 | capture | 01a18ae2-4c42-7442-84ca-e32aa8db1579 | €24.00 | €0.37 | matched |
| 92 | refund | 01a18ae2-537e-74f0-aaed-130e6135f72d | -€12.00 | €0.00 | matched |
| 94 | capture | 01a18ae2-63be-7c32-8c96-c8354ae37e3d | €9.00 | €0.19 | matched |
| 95 | capture | 01a18ae2-699e-76a2-8b14-6f826a4255a6 | €15.00 | €0.26 | matched |
| 96 | refund | 01a18ae2-824d-72e1-9177-5e2649e9b97a | -€6.00 | €0.00 | matched |
| 97 | capture | 01a18ae2-8fd6-7dac-abad-a1de961c1c52 | €24.00 | €0.37 | matched |
| 98 | capture | 01a18ae2-9751-771f-bcc1-1c94771349e2 | €15.00 | €0.26 | matched |
| 99 | capture | 01a18ae2-a6d1-73f0-8ab0-74ee10481617 | €9.00 | €0.19 | matched |
| 100 | capture | 01a18ae2-a89c-7a81-ab02-bd3ddf055329 | €9.00 | €0.19 | matched |
| 101 | capture | 01a18ae2-ab3d-7023-865d-8f4c30a7efc6 | €49.00 | €0.67 | matched |
| 102 | capture | 01a18ae2-b42e-7342-bb0e-be01520d008c | €9.00 | €0.19 | matched |
| 103 | capture | 01a18ae2-b53e-7049-ac34-6d068392ebc0 | €24.00 | €0.37 | matched |
| 104 | capture | 01a18ae2-b5ba-7488-95fd-96a220a015e9 | €24.00 | €0.37 | matched |
| 105 | capture | 01a18ae2-bfa0-76ab-b66a-cc5d0b8b6c91 | €24.00 | €0.37 | matched |
| 106 | capture | 01a18ae2-c7f8-7bd0-8cbc-d31256ac5fd6 | €49.00 | €0.67 | matched |
| 107 | capture | 01a18ae2-ca09-71f1-88f1-861fd4ee4f9c | €9.00 | €0.19 | matched |
| 108 | capture | 01a18ae2-cb7b-75eb-b0f4-6ec6dfcd9320 | €35.00 | €0.50 | matched |
| 109 | capture | 01a18ae2-d0cc-7293-8183-8ff477e50a1c | €15.00 | €0.26 | matched |
| 110 | refund | 01a18ae2-ef61-7ec0-958b-23ba1e1dd387 | -€7.00 | €0.00 | matched |
| 111 | capture | 01a18ae2-f311-7c9d-b758-485b504ab3fa | €24.00 | €0.37 | matched |
| 112 | capture | 01a18ae3-0998-773d-94e7-5e61211245f3 | €49.00 | €0.67 | matched |
| 113 | capture | 01a18ae3-1296-7619-850c-e3f4bfaf1eba | €49.00 | €0.67 | matched |
| 114 | capture | 01a18ae3-1e76-78f1-a291-0a0afbcd8a02 | €49.00 | €0.67 | matched |
| 115 | capture | 01a18ae3-2fcf-7fd6-86e1-7a1e3591aaaa | €49.00 | €0.67 | matched |
| 116 | capture | 01a18ae3-3c2b-739b-8210-12e988262209 | €9.00 | €0.19 | matched |
| 117 | capture | 01a18ae3-6d39-7098-a9fe-8a734bd913ab | €9.00 | €0.19 | matched |
| 118 | capture | 01a18ae3-7a02-7ab8-ad64-c9adc30d211c | €15.00 | €0.26 | matched |
| 119 | capture | 01a18ae3-8256-723f-aa04-bc7be5449a42 | €35.00 | €0.50 | matched |
| 120 | capture | 01a18ae3-842e-705e-ab9d-699a6a57484a | €35.00 | €0.50 | matched |
| 121 | capture | 01a18ae3-898c-759b-acec-5532ba398109 | €24.00 | €0.37 | matched |
| 122 | capture | 01a18ae3-af44-7203-83dc-3b2156d4de10 | €15.00 | €0.26 | matched |
| 123 | capture | 01a18ae3-bbad-73c1-a4d3-26a8b251f248 | €15.00 | €0.26 | matched |
| 124 | capture | 01a18ae3-bedf-7080-99b6-3a59fdf09062 | €24.00 | €0.37 | matched |
| 125 | capture | 01a18ae3-c145-7012-903f-7c30c09b063f | €35.00 | €0.50 | matched |
| 126 | capture | 01a18ae3-d8b6-7ce6-ab69-e183fd663a96 | €49.00 | €0.67 | matched |
| 127 | capture | 01a18ae3-db5a-7475-b19d-9f4cde055d1e | €15.00 | €0.26 | matched |
| 128 | capture | 01a18ae3-f36f-7e22-817d-ff0d7e31f8e1 | €49.00 | €0.67 | matched |
| 129 | refund | 01a18ae4-2c62-7ed8-992e-76fd39d64365 | -€5.00 | €0.00 | matched |
| 130 | capture | 01a18ae4-3be5-7d33-aa2b-8c06ee475d8a | €24.00 | €0.37 | matched |
| 131 | capture | 01a18ae4-5a16-721f-9a53-838695507da6 | €49.00 | €0.67 | matched |
| 132 | capture | 01a18ae4-6394-74dc-a2ed-380460cb63a4 | €15.00 | €0.26 | matched |
| 133 | capture | 01a18ae4-6a3b-7b2d-aa82-87165b8d5a95 | €24.00 | €0.37 | matched |
| 134 | capture | 01a18ae4-6eb5-7709-a054-c50203704f1a | €15.00 | €0.26 | matched |
| 135 | capture | 01a18ae4-7baf-71c3-85c1-9550a6bf8891 | €35.00 | €0.50 | matched |
| 136 | capture | 01a18ae4-7c12-7537-97ff-b02b809c067f | €35.00 | €0.50 | matched |