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
- 15 Oct, 00:50129 lines2 breaks
- 15 Oct, 00:40120 lines2 breaks
- 15 Oct, 00:30137 lines3 breaks
- 15 Oct, 00:20123 lines7 breaks
- 15 Oct, 00:10109 lines2 breaks
- 15 Oct, 00:00117 lines4 breaks
- 14 Oct, 23:50126 lines5 breaks
- 14 Oct, 23:40154 lines1 break
- 14 Oct, 23:30124 lines3 breaks
- 14 Oct, 23:20136 lines3 breaks
- 14 Oct, 23:10133 lines4 breaks
- 14 Oct, 23:00156 lines2 breaks
- 14 Oct, 22:50126 lines3 breaks
- 14 Oct, 22:40101 lines1 break
14 Oct, 23:50
Gross
€2,747.00
PSP fee
€44.80
Net to the bank
€2,702.20
Settlement journal
#4967
Breaks for a person to look at
- duplicate linethe file lists it twicerefund:01a13cd4-70c9-7471-88be-1d75a837cbc1 is already settled by stl_EUR_2986703 line 29
- duplicate linethe file lists it twicecapture:01a13cd5-4e5a-7c64-b876-72b89b14a3e3 is already settled by stl_EUR_2986703 line 42
- fee differencethe fee is not the contract feethe fee is 31, the contract says 26
- fee differencethe fee is not the contract feethe fee is 51, the contract says 50
- missing linein the books, not in the filecapture:01a13cd4-348d-7344-88a1-dcba63ff05f9 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 30 | refund | 01a13cd4-70ca-7c81-aec7-01a902eb5b4c | -€15.00 | €0.00 | duplicate line |
| 43 | capture | 01a13cd5-6776-7647-a7a5-82139c2763b1 | €35.00 | €0.50 | duplicate line |
| 87 | capture | 01a13cd8-ad6f-70b7-b040-5f27948da78e | €15.00 | €0.31 | fee difference |
| 100 | capture | 01a13cd9-c4fb-77ee-a47c-6dbd677660a2 | €35.00 | €0.51 | fee difference |
| 1 | refund | 01a13cd2-baf8-786f-9975-51bde400e26f | -€20.00 | €0.00 | matched |
| 2 | capture | 01a13cd2-c565-7d03-b11c-dc22883e8ce6 | €49.00 | €0.67 | matched |
| 3 | capture | 01a13cd2-c97c-73d7-94e1-ca743ea79894 | €15.00 | €0.26 | matched |
| 4 | capture | 01a13cd2-f252-7f36-97c3-0b545132dd12 | €15.00 | €0.26 | matched |
| 5 | capture | 01a13cd3-01d0-72cd-a57e-d030510cbdf1 | €49.00 | €0.67 | matched |
| 6 | refund | 01a13cd3-02de-786f-9f1d-827126b15ed0 | -€26.00 | €0.00 | matched |
| 7 | refund | 01a13cd3-0432-7009-9a52-e52bf811952b | -€13.00 | €0.00 | matched |
| 8 | capture | 01a13cd3-18db-7602-b3b7-bfe48009790d | €49.00 | €0.67 | matched |
| 9 | capture | 01a13cd3-24d7-7456-add9-3ff428e4e115 | €35.00 | €0.50 | matched |
| 10 | capture | 01a13cd3-30af-7749-91aa-12d46fed0e32 | €9.00 | €0.19 | matched |
| 11 | capture | 01a13cd3-4c61-72ad-ad2e-46e858effca2 | €35.00 | €0.50 | matched |
| 12 | capture | 01a13cd3-51fb-7f57-8bb5-77ff59ac55d2 | €15.00 | €0.26 | matched |
| 13 | capture | 01a13cd3-5833-77ab-b069-9fb5a2ae53d8 | €35.00 | €0.50 | matched |
| 14 | capture | 01a13cd3-599a-709c-9e6e-952d4aeea052 | €49.00 | €0.67 | matched |
| 15 | capture | 01a13cd3-6bd0-755d-8a71-2d703b40549f | €24.00 | €0.37 | matched |
| 16 | capture | 01a13cd3-7493-79a0-8017-7d3dd0755bd6 | €24.00 | €0.37 | matched |
| 17 | capture | 01a13cd3-85d4-73d4-b9c9-bacc10af5ecb | €15.00 | €0.26 | matched |
| 18 | capture | 01a13cd3-9c08-7632-a20b-fae3de2e83cd | €24.00 | €0.37 | matched |
| 19 | capture | 01a13cd3-a04c-78b4-a419-00cd9b2bcc44 | €49.00 | €0.67 | matched |
| 20 | capture | 01a13cd3-ae4d-7e87-82c2-9400862f4e66 | €49.00 | €0.67 | matched |
| 21 | capture | 01a13cd3-c414-7d95-adb8-566b83904e27 | €35.00 | €0.50 | matched |
| 22 | refund | 01a13cd3-e043-705f-b61b-3850b59bf04b | -€8.00 | €0.00 | matched |
| 23 | capture | 01a13cd4-128e-7feb-a585-91985c06346d | €49.00 | €0.67 | matched |
| 24 | capture | 01a13cd4-14cc-7905-ab08-09e8da925096 | €24.00 | €0.37 | matched |
| 25 | capture | 01a13cd4-49d8-71df-9770-f4ecc1445614 | €49.00 | €0.67 | matched |
| 26 | capture | 01a13cd4-5828-7587-bfbd-13463d47f56b | €9.00 | €0.19 | matched |
| 27 | capture | 01a13cd4-5cfc-7993-8816-36bdce2b64ff | €9.00 | €0.19 | matched |
| 28 | capture | 01a13cd4-61a2-7e89-a743-1bdf09eb93c0 | €9.00 | €0.19 | matched |
| 29 | refund | 01a13cd4-70ca-7c81-aec7-01a902eb5b4c | -€15.00 | €0.00 | matched |
| 31 | capture | 01a13cd4-96ac-7002-99f0-7544fd9d0550 | €35.00 | €0.50 | matched |
| 32 | capture | 01a13cd4-abef-7d2f-af5c-5f7af5760eed | €9.00 | €0.19 | matched |
| 33 | capture | 01a13cd4-b1b4-762a-818f-e7a1ee447181 | €24.00 | €0.37 | matched |
| 34 | capture | 01a13cd4-dc13-7419-a844-154da50ade49 | €15.00 | €0.26 | matched |
| 35 | capture | 01a13cd5-24d4-7616-ab39-dade9892d70f | €24.00 | €0.37 | matched |
| 36 | capture | 01a13cd5-2927-709a-9a27-1c111ac1ca2b | €9.00 | €0.19 | matched |
| 37 | capture | 01a13cd5-293a-7911-afcf-dfe0396adb68 | €24.00 | €0.37 | matched |
| 38 | capture | 01a13cd5-3ddf-7215-9dba-9c6c302823a4 | €24.00 | €0.37 | matched |
| 39 | capture | 01a13cd5-3e32-78ac-883d-7c82e2ec8cab | €24.00 | €0.37 | matched |
| 40 | capture | 01a13cd5-3b77-7c99-825a-380dffd2bcae | €35.00 | €0.50 | matched |
| 41 | capture | 01a13cd5-5146-7d82-ac6e-0e337d95d667 | €9.00 | €0.19 | matched |
| 42 | capture | 01a13cd5-6776-7647-a7a5-82139c2763b1 | €35.00 | €0.50 | matched |
| 44 | capture | 01a13cd5-68f9-7166-9aa7-015758fcea74 | €35.00 | €0.50 | matched |
| 45 | capture | 01a13cd5-7088-7135-8db2-ef5e8d54c103 | €49.00 | €0.67 | matched |
| 46 | capture | 01a13cd5-6dbe-7d50-9ca6-842c9c0b350d | €24.00 | €0.37 | matched |
| 47 | capture | 01a13cd5-8ff8-7f37-a038-8cc8468cc998 | €9.00 | €0.19 | matched |
| 48 | capture | 01a13cd5-a2bf-7244-9175-15bd490747db | €24.00 | €0.37 | matched |
| 49 | refund | 01a13cd5-a8fe-7c9e-8b62-f922f5d3568c | -€21.00 | €0.00 | matched |
| 50 | refund | 01a13cd5-b7e1-75f6-8973-7a00e9352bd8 | -€16.00 | €0.00 | matched |
| 51 | capture | 01a13cd5-bac3-7c8e-ac7c-68c55b6c8c3d | €24.00 | €0.37 | matched |
| 52 | capture | 01a13cd5-ce19-71bb-ac3e-29d910159769 | €35.00 | €0.50 | matched |
| 53 | capture | 01a13cd5-dfba-7303-bf00-a3bf53fe61de | €15.00 | €0.26 | matched |
| 54 | capture | 01a13cd5-f3ab-767e-a3d8-75ed812a57aa | €49.00 | €0.67 | matched |
| 55 | refund | 01a13cd6-15ab-7f4e-9705-9e3b613f780a | -€5.00 | €0.00 | matched |
| 56 | capture | 01a13cd6-1bef-7dc1-9b87-cb34c934953f | €24.00 | €0.37 | matched |
| 57 | capture | 01a13cd6-2784-7365-8997-01dabf51d2fc | €35.00 | €0.50 | matched |
| 58 | refund | 01a13cd6-402d-7049-9332-e89960272dc2 | -€18.00 | €0.00 | matched |
| 59 | capture | 01a13cd6-52f5-7c7b-aa1b-054f11d8e052 | €24.00 | €0.37 | matched |
| 60 | capture | 01a13cd6-5b93-7824-860b-143492da5da0 | €9.00 | €0.19 | matched |
| 61 | capture | 01a13cd6-6f2c-7372-bb92-8fe81c0269c2 | €49.00 | €0.67 | matched |
| 62 | capture | 01a13cd6-723c-78ac-85cb-06853a510b20 | €24.00 | €0.37 | matched |
| 63 | capture | 01a13cd6-a28f-7930-a0b7-f9a89bd7928b | €35.00 | €0.50 | matched |
| 64 | capture | 01a13cd6-b2ff-7ede-be61-d96e82ad3953 | €9.00 | €0.19 | matched |
| 65 | capture | 01a13cd6-fbc9-74b0-98a2-d1151229b6dd | €49.00 | €0.67 | matched |
| 66 | capture | 01a13cd7-0376-7ce8-8691-3fc6236c22fb | €15.00 | €0.26 | matched |
| 67 | capture | 01a13cd7-0d1a-7c23-868d-616d8db41723 | €15.00 | €0.26 | matched |
| 68 | capture | 01a13cd7-1cf9-74e6-8d30-430a5dcd0300 | €24.00 | €0.37 | matched |
| 69 | capture | 01a13cd7-2b25-7271-a403-2bda55b03568 | €35.00 | €0.50 | matched |
| 70 | capture | 01a13cd7-3277-743d-a749-4204443a7101 | €49.00 | €0.67 | matched |
| 71 | capture | 01a13cd7-4c1e-76a8-941f-19543f151d99 | €9.00 | €0.19 | matched |
| 72 | capture | 01a13cd7-5853-78cc-b11e-fb675ab79ef8 | €15.00 | €0.26 | matched |
| 73 | capture | 01a13cd7-5de9-75ad-8fa2-c3d83b734b2c | €49.00 | €0.67 | matched |
| 74 | capture | 01a13cd7-6e66-7c51-acfa-8bde66ef8d74 | €15.00 | €0.26 | matched |
| 75 | capture | 01a13cd7-7686-7074-b6e2-8a33cee15bc6 | €24.00 | €0.37 | matched |
| 76 | capture | 01a13cd7-9261-784f-9f09-738356481208 | €15.00 | €0.26 | matched |
| 77 | capture | 01a13cd7-99a4-7dc8-a0d4-d33c576a0a73 | €9.00 | €0.19 | matched |
| 78 | capture | 01a13cd7-a4b4-78a2-bb2e-d9dbce9deba0 | €24.00 | €0.37 | matched |
| 79 | capture | 01a13cd7-c4a4-7cf1-a6a0-0d5396ee14b5 | €35.00 | €0.50 | matched |
| 80 | refund | 01a13cd8-0233-7225-b21e-0876eed01732 | -€13.00 | €0.00 | matched |
| 81 | capture | 01a13cd8-0ba7-77bb-985a-45349c8ee9ca | €49.00 | €0.67 | matched |
| 82 | capture | 01a13cd8-27bb-7e8a-a4e0-69b327f9bb59 | €15.00 | €0.26 | matched |
| 83 | capture | 01a13cd8-2bc3-72b9-8fb7-e1696c840c97 | €15.00 | €0.26 | matched |
| 84 | refund | 01a13cd8-90a5-72b8-b257-98954605edec | -€16.00 | €0.00 | matched |
| 85 | capture | 01a13cd8-a16c-786a-9cf3-fdcd904f4247 | €9.00 | €0.19 | matched |
| 86 | capture | 01a13cd8-ac4e-7c60-b12a-4a3634452f7b | €15.00 | €0.26 | matched |
| 88 | capture | 01a13cd8-b03f-76f7-9f74-2bddd023fd68 | €9.00 | €0.19 | matched |
| 89 | capture | 01a13cd8-d45d-7d74-b560-dc3c5e63b790 | €24.00 | €0.37 | matched |
| 90 | capture | 01a13cd8-de21-7081-9bc5-c46627708df7 | €24.00 | €0.37 | matched |
| 91 | capture | 01a13cd9-004c-72a6-a0a2-a59465150a8e | €49.00 | €0.67 | matched |
| 92 | capture | 01a13cd9-528b-7836-b666-ca5732330433 | €9.00 | €0.19 | matched |
| 93 | capture | 01a13cd9-52f2-75b3-afb4-caf68eea1296 | €9.00 | €0.19 | matched |
| 94 | capture | 01a13cd9-5b7f-7295-a668-d2bac451f4a8 | €9.00 | €0.19 | matched |
| 95 | capture | 01a13cd9-63d4-7ee8-8cd9-b026bc089e12 | €9.00 | €0.19 | matched |
| 96 | capture | 01a13cd9-70f0-769a-a53b-67e8bf5659dd | €15.00 | €0.26 | matched |
| 97 | capture | 01a13cd9-7f6c-786c-8ae9-2d71c305167c | €15.00 | €0.26 | matched |
| 98 | capture | 01a13cd9-a97e-7a67-b651-3f78bd0e22d8 | €49.00 | €0.67 | matched |
| 99 | capture | 01a13cd9-b269-7ab5-b53f-2be1942ec5ff | €49.00 | €0.67 | matched |
| 101 | capture | 01a13cd9-c811-714a-a392-906ac2c04c66 | €49.00 | €0.67 | matched |
| 102 | capture | 01a13cd9-cab2-733f-a5b0-33e2453bed00 | €15.00 | €0.26 | matched |
| 103 | capture | 01a13cd9-e889-777f-8e90-b740aa0b9a35 | €15.00 | €0.26 | matched |
| 104 | capture | 01a13cd9-eeac-75c3-a49b-d952817c9101 | €24.00 | €0.37 | matched |
| 105 | capture | 01a13cda-0099-7d9f-9373-da6ef81c5182 | €35.00 | €0.50 | matched |
| 106 | capture | 01a13cda-2924-7790-bf7f-5bb9c219abce | €24.00 | €0.37 | matched |
| 107 | capture | 01a13cda-2cfa-76dc-8bc4-919f0d9a8bc2 | €15.00 | €0.26 | matched |
| 108 | refund | 01a13cda-3811-7dee-af99-68d2a672eb9f | -€14.00 | €0.00 | matched |
| 109 | capture | 01a13cda-4a54-7fd0-9caa-9cd046f6da20 | €24.00 | €0.37 | matched |
| 110 | capture | 01a13cda-914e-75c4-b234-027b38e0e4e1 | €15.00 | €0.26 | matched |
| 111 | capture | 01a13cda-ad23-7e75-aba1-862289f8ea0a | €49.00 | €0.67 | matched |
| 112 | capture | 01a13cda-b1f5-79bd-9d2d-c7bfb99ac19b | €9.00 | €0.19 | matched |
| 113 | capture | 01a13cda-bb87-75bd-88d9-97697318db2d | €9.00 | €0.19 | matched |
| 114 | capture | 01a13cda-c4a5-7104-9eb8-3a68d19bce26 | €35.00 | €0.50 | matched |
| 115 | capture | 01a13cda-d21f-76bb-bc95-e4bf3d91ab7a | €35.00 | €0.50 | matched |
| 116 | refund | 01a13cdb-2207-7969-a39c-5f488383cb8e | -€23.00 | €0.00 | matched |
| 117 | capture | 01a13cdb-279f-71ce-b6d2-53fbd86c19d5 | €15.00 | €0.26 | matched |
| 118 | capture | 01a13cdb-2a9d-73c8-881d-9d3d3a9c5820 | €49.00 | €0.67 | matched |
| 119 | capture | 01a13cdb-69a3-7720-a7f4-8a58d1ecc265 | €24.00 | €0.37 | matched |
| 120 | capture | 01a13cdb-6d46-7467-9fae-187a97152868 | €35.00 | €0.50 | matched |
| 121 | capture | 01a13cdb-6ddb-7124-a3ce-61e31353349d | €49.00 | €0.67 | matched |
| 122 | capture | 01a13cdb-6de7-7beb-a638-2ebab2117c62 | €9.00 | €0.19 | matched |
| 123 | capture | 01a13cdb-9e8f-7865-9cfb-77c995682d68 | €24.00 | €0.37 | matched |
| 124 | capture | 01a13cdb-b474-73a7-9123-db6940123fb4 | €35.00 | €0.50 | matched |
| 125 | capture | 01a13cdb-b5c4-7132-8f7f-7f1ddcae72f9 | €24.00 | €0.37 | matched |
| 126 | capture | 01a13cdb-ba31-7ed3-8cf4-4fd939877158 | €49.00 | €0.67 | matched |