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
- 17 Oct, 11:30114 lines2 breaks
- 17 Oct, 11:20124 lines3 breaks
- 17 Oct, 11:10150 lines3 breaks
- 17 Oct, 11:00125 lines4 breaks
- 17 Oct, 10:50128 lines1 break
- 17 Oct, 10:40137 lines2 breaks
- 17 Oct, 10:30124 lines7 breaks
- 17 Oct, 10:20109 lines1 break
- 17 Oct, 10:10120 lines1 break
- 17 Oct, 10:00117 lines1 break
- 17 Oct, 09:50110 lines6 breaks
- 17 Oct, 09:40142 lines6 breaks
- 17 Oct, 09:30112 linesclean
- 17 Oct, 09:20127 lines5 breaks
17 Oct, 10:30
Gross
€2,629.00
PSP fee
€43.14
Net to the bank
€2,585.86
Settlement journal
#49781
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1496d-23d5-764a-bdb0-f1752d6b7ed5 is already settled by stl_EUR_2987055 line 54
- duplicate linethe file lists it twicecapture:01a14971-fde3-79e3-ac81-d497f3cceaba is already settled by stl_EUR_2987055 line 118
- fee differencethe fee is not the contract feethe fee is 23, the contract says 19
- fee differencethe fee is not the contract feethe fee is 71, the contract says 67
- fee differencethe fee is not the contract feethe fee is 41, the contract says 37
- fee differencethe fee is not the contract feethe fee is 20, the contract says 19
- missing linein the books, not in the filecapture:01a14970-11e2-7535-9940-d9b74506dee0 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 13 | capture | 01a1496a-a2d8-7e02-9014-a0d809af1254 | €9.00 | €0.23 | fee difference |
| 45 | capture | 01a1496c-79df-790e-9b16-0fd79dd92294 | €49.00 | €0.71 | fee difference |
| 55 | capture | 01a1496d-245a-710c-989b-189117047d6b | €24.00 | €0.37 | duplicate line |
| 59 | capture | 01a1496d-6302-7037-b80b-f17460f81c59 | €24.00 | €0.41 | fee difference |
| 119 | capture | 01a14971-fe42-7e71-a537-17c58f6e0071 | €35.00 | €0.50 | duplicate line |
| 123 | capture | 01a14972-34f3-734c-92ca-094c60a8e6db | €9.00 | €0.20 | fee difference |
| 1 | capture | 01a14961-6020-7037-8b73-11be3fc88db6 | €9.00 | €0.19 | matched |
| 2 | capture | 01a14969-80df-7dd8-bf80-00e471a62002 | €9.00 | €0.19 | matched |
| 3 | capture | 01a14969-912d-7387-947a-d8a8b0daf17c | €9.00 | €0.19 | matched |
| 4 | refund | 01a14969-d185-7125-98b0-87803d383b1c | -€8.00 | €0.00 | matched |
| 5 | capture | 01a14969-d731-74a0-a9f3-f715e6d80b09 | €24.00 | €0.37 | matched |
| 6 | capture | 01a14969-e614-7bf6-91d9-c4433444d206 | €15.00 | €0.26 | matched |
| 7 | capture | 01a1496a-51b4-73c9-9c0b-7aef62ee7fc6 | €9.00 | €0.19 | matched |
| 8 | capture | 01a1496a-5947-7c73-86c2-ca887355def3 | €9.00 | €0.19 | matched |
| 9 | capture | 01a1496a-79bd-771c-a62b-3dd2d920e805 | €49.00 | €0.67 | matched |
| 10 | capture | 01a1496a-7f16-736c-8b29-0e86877f660f | €9.00 | €0.19 | matched |
| 11 | capture | 01a1496a-805f-7463-a498-27759745d490 | €9.00 | €0.19 | matched |
| 12 | capture | 01a1496a-8dcf-7fc7-9068-61eecd05be6a | €35.00 | €0.50 | matched |
| 14 | capture | 01a1496a-a605-7aba-b058-8812ef674a0d | €9.00 | €0.19 | matched |
| 15 | capture | 01a1496a-b94f-7622-92ce-17f10a2c2fd4 | €35.00 | €0.50 | matched |
| 16 | capture | 01a1496a-c625-72b7-ab8b-86f33d5a6fc5 | €35.00 | €0.50 | matched |
| 17 | capture | 01a1496a-d088-7386-869f-9adfefeac99b | €15.00 | €0.26 | matched |
| 18 | capture | 01a1496a-d525-7534-9c5f-e223ac0b8b5b | €24.00 | €0.37 | matched |
| 19 | capture | 01a1496a-d69e-7c75-811f-5b2d8d333381 | €49.00 | €0.67 | matched |
| 20 | refund | 01a1496a-da95-7edf-8766-e851f03fd31c | -€32.00 | €0.00 | matched |
| 21 | refund | 01a1496a-eba7-71d9-8255-f9102dd78132 | -€9.00 | €0.00 | matched |
| 22 | capture | 01a1496b-00af-70b0-b6da-e6cdc57ba6a4 | €9.00 | €0.19 | matched |
| 23 | capture | 01a1496b-0716-75f0-a9b0-f96b80d154c9 | €35.00 | €0.50 | matched |
| 24 | capture | 01a1496b-0719-7201-bc31-28183b4fdc49 | €15.00 | €0.26 | matched |
| 25 | refund | 01a1496b-0d6b-7fe5-8d6e-1980b35696b7 | -€3.00 | €0.00 | matched |
| 26 | capture | 01a1496b-1300-7764-8430-e14d68433714 | €9.00 | €0.19 | matched |
| 27 | capture | 01a1496b-34a3-778b-9aef-d8cb73c5a52b | €49.00 | €0.67 | matched |
| 28 | capture | 01a1496b-3c1f-73cb-93da-8f435354ba9f | €49.00 | €0.67 | matched |
| 29 | capture | 01a1496b-4e81-7482-83cb-0369e8672b87 | €24.00 | €0.37 | matched |
| 30 | capture | 01a1496b-53d4-7dcb-bd27-aaef7fb76835 | €24.00 | €0.37 | matched |
| 31 | capture | 01a1496b-5823-75f8-b5b9-5dee402d7dc6 | €24.00 | €0.37 | matched |
| 32 | capture | 01a1496b-9cff-75a5-b478-2f509b625437 | €24.00 | €0.37 | matched |
| 33 | capture | 01a1496b-b0b0-7f4d-9f1d-d3045c4ab103 | €15.00 | €0.26 | matched |
| 34 | capture | 01a1496b-cb8b-74d7-b02e-6080e305e44f | €49.00 | €0.67 | matched |
| 35 | capture | 01a1496b-e470-796a-8af9-c54daa3c80a9 | €9.00 | €0.19 | matched |
| 36 | capture | 01a1496b-e633-7a57-af06-23e887075fce | €9.00 | €0.19 | matched |
| 37 | capture | 01a1496b-f65a-774a-8df2-3561c50d7360 | €49.00 | €0.67 | matched |
| 38 | capture | 01a1496c-034c-7e21-b7b1-bd6043b6e8bf | €15.00 | €0.26 | matched |
| 39 | refund | 01a1496c-042c-790e-a199-32f33a9b4ecb | -€47.00 | €0.00 | matched |
| 40 | capture | 01a1496c-0650-71b0-b72e-c9eaaa75ecd8 | €15.00 | €0.26 | matched |
| 41 | capture | 01a1496c-139c-7217-b06b-88327f8152ad | €24.00 | €0.37 | matched |
| 42 | capture | 01a1496c-2279-75c9-9a40-da955f76fee4 | €49.00 | €0.67 | matched |
| 43 | capture | 01a1496c-58c2-72de-839a-ef45a492871f | €24.00 | €0.37 | matched |
| 44 | capture | 01a1496c-6ff8-7f4c-95e2-ca538fe6ebba | €15.00 | €0.26 | matched |
| 46 | capture | 01a1496c-7dab-7913-8fb5-e13818d124fe | €9.00 | €0.19 | matched |
| 47 | capture | 01a1496c-95cf-77ee-a5ee-5af1d1fb000f | €49.00 | €0.67 | matched |
| 48 | capture | 01a1496c-9e14-7042-8016-590336c81f7e | €15.00 | €0.26 | matched |
| 49 | capture | 01a1496c-a248-71bc-8830-e3c94465df45 | €24.00 | €0.37 | matched |
| 50 | capture | 01a1496c-a439-7d56-ba43-91e2e793ec1d | €15.00 | €0.26 | matched |
| 51 | capture | 01a1496c-d3af-71cd-b721-fc3c194aa0ef | €9.00 | €0.19 | matched |
| 52 | refund | 01a1496c-d7f1-73bb-8d40-cedfcc7f47e7 | -€8.00 | €0.00 | matched |
| 53 | capture | 01a1496c-ef28-7d8e-951b-1c9e2acf2f66 | €24.00 | €0.37 | matched |
| 54 | capture | 01a1496d-245a-710c-989b-189117047d6b | €24.00 | €0.37 | matched |
| 56 | capture | 01a1496d-2b99-7c39-abfe-2cedcb688c95 | €24.00 | €0.37 | matched |
| 57 | capture | 01a1496d-4100-7cd7-b801-d738101ec73d | €49.00 | €0.67 | matched |
| 58 | capture | 01a1496d-5fcd-730b-9179-86687311bf37 | €24.00 | €0.37 | matched |
| 60 | capture | 01a1496d-7742-76e4-9287-17d429032588 | €49.00 | €0.67 | matched |
| 61 | capture | 01a1496d-bcac-7d2b-8d02-8f52c67e3b4a | €9.00 | €0.19 | matched |
| 62 | capture | 01a1496d-be17-7652-9e7e-bf7f6e752a5e | €35.00 | €0.50 | matched |
| 63 | capture | 01a1496d-d16c-7095-be97-1467abff1764 | €24.00 | €0.37 | matched |
| 64 | capture | 01a1496d-ffaa-7d9c-80b3-734fbb29da7d | €15.00 | €0.26 | matched |
| 65 | capture | 01a1496e-03b5-74f6-afad-231c88a36288 | €15.00 | €0.26 | matched |
| 66 | capture | 01a1496e-1fe8-763a-a8b0-0870dde58bc4 | €35.00 | €0.50 | matched |
| 67 | capture | 01a1496e-24de-7746-a928-40c2d191afda | €9.00 | €0.19 | matched |
| 68 | capture | 01a1496e-2bdb-76ca-bdae-054c5b74a0ab | €15.00 | €0.26 | matched |
| 69 | capture | 01a1496e-2ee5-7e6c-8e6a-9ead49dcfe02 | €24.00 | €0.37 | matched |
| 70 | capture | 01a1496e-6373-7baa-b56a-87ef367b4747 | €9.00 | €0.19 | matched |
| 71 | capture | 01a1496e-6958-734e-a6d1-d3e4f372ea91 | €35.00 | €0.50 | matched |
| 72 | refund | 01a1496e-89d0-78bd-9efc-ebd94300de1a | -€2.00 | €0.00 | matched |
| 73 | capture | 01a1496e-95bc-7d87-bbf6-a8003d831d4f | €9.00 | €0.19 | matched |
| 74 | capture | 01a1496e-a1da-7a53-a48c-2dc82990748b | €15.00 | €0.26 | matched |
| 75 | capture | 01a1496e-a0f4-7495-88de-9d61345fe8aa | €24.00 | €0.37 | matched |
| 76 | capture | 01a1496e-d9ef-78f1-ab80-09cd8de94f4f | €15.00 | €0.26 | matched |
| 77 | capture | 01a1496e-e735-7e9e-ae3c-86e7299a8969 | €49.00 | €0.67 | matched |
| 78 | capture | 01a1496e-f923-704f-83ad-69e480c86c3d | €24.00 | €0.37 | matched |
| 79 | capture | 01a1496e-fb42-76a5-83e5-41643217348a | €9.00 | €0.19 | matched |
| 80 | refund | 01a1496f-0600-70ef-95cb-f088c7abf1c6 | -€9.00 | €0.00 | matched |
| 81 | capture | 01a1496f-0f40-70f3-af71-77befcf983cd | €35.00 | €0.50 | matched |
| 82 | capture | 01a1496f-14b1-7529-bba9-b6f1a9c88e48 | €49.00 | €0.67 | matched |
| 83 | capture | 01a1496f-3043-7c83-9089-99dea225c522 | €35.00 | €0.50 | matched |
| 84 | capture | 01a1496f-3059-710c-b6fa-a193d8b6440d | €24.00 | €0.37 | matched |
| 85 | capture | 01a1496f-444e-7cdc-9cb3-7419d26b9c6f | €35.00 | €0.50 | matched |
| 86 | capture | 01a1496f-7092-77c4-952e-33c27289ecbe | €49.00 | €0.67 | matched |
| 87 | capture | 01a1496f-782e-7244-8da2-2a5e6037c98f | €24.00 | €0.37 | matched |
| 88 | capture | 01a1496f-8a54-7f10-9590-16a4924879c7 | €49.00 | €0.67 | matched |
| 89 | refund | 01a1496f-c022-7e50-9b3b-f16f8ae4f134 | -€40.00 | €0.00 | matched |
| 90 | capture | 01a1496f-c782-75d0-94c8-2953cc0611dc | €24.00 | €0.37 | matched |
| 91 | capture | 01a1496f-cb47-7225-8b71-a6bc4e98e879 | €24.00 | €0.37 | matched |
| 92 | capture | 01a1496f-ee7c-7f64-946e-f40efa9527a7 | €24.00 | €0.37 | matched |
| 93 | capture | 01a14970-85e1-7ace-b738-1b609f7a2f32 | €9.00 | €0.19 | matched |
| 94 | capture | 01a14970-8bc9-7c44-90c9-3374e47da8dd | €49.00 | €0.67 | matched |
| 95 | capture | 01a14970-9bf9-7853-99a7-2d688bfed4f8 | €24.00 | €0.37 | matched |
| 96 | capture | 01a14970-a24a-7ba8-a857-addbb5d74cf4 | €35.00 | €0.50 | matched |
| 97 | capture | 01a14970-ab1d-7ef8-a449-f62cd06455d8 | €24.00 | €0.37 | matched |
| 98 | capture | 01a14970-b63c-77d8-868b-8e8e4501409a | €9.00 | €0.19 | matched |
| 99 | capture | 01a14970-b817-7819-baaa-fc7f7a5d2bc7 | €15.00 | €0.26 | matched |
| 100 | capture | 01a14970-d459-75a0-bb5f-a0befad0d02a | €9.00 | €0.19 | matched |
| 101 | capture | 01a14970-dc00-7902-9786-fd2fa4a220e5 | €35.00 | €0.50 | matched |
| 102 | capture | 01a14970-e4ab-7c29-ad24-27889a9dcf77 | €49.00 | €0.67 | matched |
| 103 | capture | 01a14970-e680-7513-99eb-233ca3b9502f | €24.00 | €0.37 | matched |
| 104 | capture | 01a14970-f171-71db-ac80-c1e3ea092870 | €9.00 | €0.19 | matched |
| 105 | capture | 01a14971-002d-7794-8326-91764c3c87e8 | €24.00 | €0.37 | matched |
| 106 | capture | 01a14971-2544-7fd0-968c-518df272fe57 | €24.00 | €0.37 | matched |
| 107 | capture | 01a14971-5637-7530-8574-401878fec9fa | €15.00 | €0.26 | matched |
| 108 | capture | 01a14971-5aff-7653-b274-ebe83cc054e6 | €9.00 | €0.19 | matched |
| 109 | capture | 01a14971-5d4f-71e7-bf05-be926e7f538d | €9.00 | €0.19 | matched |
| 110 | capture | 01a14971-6627-77b4-9f6a-7bb25a73c06b | €35.00 | €0.50 | matched |
| 111 | capture | 01a14971-66de-7277-9a61-0471710d5a4b | €9.00 | €0.19 | matched |
| 112 | capture | 01a14971-7a58-7a30-a889-8313b25668e9 | €35.00 | €0.50 | matched |
| 113 | capture | 01a14971-b3cb-7eea-b10d-b96e6eebd077 | €24.00 | €0.37 | matched |
| 114 | capture | 01a14971-c723-78cb-be98-aa4260984c65 | €49.00 | €0.67 | matched |
| 115 | capture | 01a14971-e4a7-7f73-8fd9-0c37c56c4350 | €35.00 | €0.50 | matched |
| 116 | capture | 01a14971-efe8-7962-9d61-14f20acd1250 | €24.00 | €0.37 | matched |
| 117 | capture | 01a14971-f8e1-7817-a0b1-1b31344da70e | €35.00 | €0.50 | matched |
| 118 | capture | 01a14971-fe42-7e71-a537-17c58f6e0071 | €35.00 | €0.50 | matched |
| 120 | capture | 01a14972-1b7b-75ff-8268-749793c3c69a | €15.00 | €0.26 | matched |
| 121 | refund | 01a14972-1f70-7c78-8b15-e51f2c7b210c | -€24.00 | €0.00 | matched |
| 122 | capture | 01a14972-1fec-7718-9ee5-cb5dc2a2e654 | €24.00 | €0.37 | matched |
| 124 | capture | 01a14972-6045-77f6-8470-802aa48d2f23 | €24.00 | €0.37 | matched |