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
- 25 Oct, 14:00113 lines4 breaks
- 25 Oct, 13:50119 lines5 breaks
- 25 Oct, 13:40109 lines1 break
- 25 Oct, 13:30113 lines3 breaks
- 25 Oct, 13:20120 lines4 breaks
- 25 Oct, 13:10106 lines3 breaks
- 25 Oct, 13:00126 lines2 breaks
- 25 Oct, 12:50118 lines5 breaks
- 25 Oct, 12:40121 lines3 breaks
- 25 Oct, 12:30122 lines3 breaks
- 25 Oct, 12:20116 linesclean
- 25 Oct, 12:10112 lines2 breaks
- 25 Oct, 12:00117 lines2 breaks
- 25 Oct, 11:50145 lines3 breaks
25 Oct, 13:00
Gross
€2,814.00
PSP fee
€45.35
Net to the bank
€2,768.65
Settlement journal
#197202
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a1732e-4c14-7102-8b72-f1666121e4f0 is already settled by stl_EUR_2988222 line 122
- missing linein the books, not in the filecapture:01a17325-e9b1-7635-b05a-daa48dfde6b8 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 123 | capture | 01a1732e-5bc1-7eef-8dc4-cbb155191c4b | €35.00 | €0.50 | duplicate line |
| 1 | capture | 01a1731f-7b34-7482-b60a-aac5f90dbcd7 | €49.00 | €0.67 | matched |
| 2 | capture | 01a17322-f114-76b0-b72e-8e91b5e4d793 | €49.00 | €0.67 | matched |
| 3 | capture | 01a17325-84b3-7517-aabd-7ee337e26aea | €24.00 | €0.37 | matched |
| 4 | capture | 01a17325-9c1c-7902-86ed-96a65deb0b61 | €35.00 | €0.50 | matched |
| 5 | refund | 01a17325-b8b7-7cfa-929f-4c81d8b87c9f | -€18.00 | €0.00 | matched |
| 6 | capture | 01a17325-bd90-766f-9d96-f3cda53cc7b1 | €9.00 | €0.19 | matched |
| 7 | capture | 01a17325-c1e8-7f6c-990d-c2eea9145ba2 | €24.00 | €0.37 | matched |
| 8 | capture | 01a17325-d5cd-7476-a527-c69e064470df | €35.00 | €0.50 | matched |
| 9 | capture | 01a17325-f3b8-7428-bbd5-abf18700b3a9 | €49.00 | €0.67 | matched |
| 10 | capture | 01a17326-068c-7ece-bd65-632e70ab7bba | €15.00 | €0.26 | matched |
| 11 | capture | 01a17326-16c7-7bf7-a495-5a1cf636704a | €24.00 | €0.37 | matched |
| 12 | capture | 01a17326-30d3-7606-bd81-935d15453837 | €9.00 | €0.19 | matched |
| 13 | capture | 01a17326-4982-716e-b18e-66d58ba78575 | €49.00 | €0.67 | matched |
| 14 | capture | 01a17326-7e5c-72a9-a57a-11d1c99607ff | €24.00 | €0.37 | matched |
| 15 | capture | 01a17326-b310-7918-996d-2cabfb38d926 | €15.00 | €0.26 | matched |
| 16 | capture | 01a17326-ce61-7d9e-b873-726b22d8207f | €9.00 | €0.19 | matched |
| 17 | capture | 01a17326-d695-7e65-852c-a83ebd58f490 | €9.00 | €0.19 | matched |
| 18 | capture | 01a17326-e4af-7bb5-a644-f25b4d54ea73 | €15.00 | €0.26 | matched |
| 19 | capture | 01a17327-1052-73fb-8a20-feb6a33f643b | €24.00 | €0.37 | matched |
| 20 | capture | 01a17327-5421-765f-b27a-ac66742e02eb | €24.00 | €0.37 | matched |
| 21 | capture | 01a17327-5957-778e-b8da-824de28bea67 | €15.00 | €0.26 | matched |
| 22 | capture | 01a17327-8644-7c3d-92f9-266255b69ad9 | €24.00 | €0.37 | matched |
| 23 | capture | 01a17327-ab1a-7bc6-bcb7-8db3a86302bb | €24.00 | €0.37 | matched |
| 24 | capture | 01a17327-b0e5-7245-a4ad-1aee887ced78 | €35.00 | €0.50 | matched |
| 25 | capture | 01a17327-c345-7f57-bef3-f68813862fbb | €49.00 | €0.67 | matched |
| 26 | capture | 01a17327-c7cc-79a1-abd5-767d2efe74be | €35.00 | €0.50 | matched |
| 27 | capture | 01a17327-d183-7233-a0e9-094bac5ffde7 | €24.00 | €0.37 | matched |
| 28 | capture | 01a17327-e7ef-75df-b44b-1da5051a3775 | €9.00 | €0.19 | matched |
| 29 | capture | 01a17327-e832-7854-b059-f484cfbfd525 | €49.00 | €0.67 | matched |
| 30 | capture | 01a17327-f034-7f8d-ad5d-f1b1879956c2 | €24.00 | €0.37 | matched |
| 31 | capture | 01a17327-f12e-7944-9eac-81a9f4061d9a | €49.00 | €0.67 | matched |
| 32 | refund | 01a17327-f13d-7996-9a70-92b852ed0cab | -€24.00 | €0.00 | matched |
| 33 | capture | 01a17328-0b1f-7609-b955-7c0770ead838 | €15.00 | €0.26 | matched |
| 34 | capture | 01a17328-148b-7701-91b7-b8b520a3c02f | €9.00 | €0.19 | matched |
| 35 | refund | 01a17328-17c9-7efc-b1d9-b427ea4645ab | -€6.00 | €0.00 | matched |
| 36 | capture | 01a17328-1850-728e-8357-019b5dcf6843 | €49.00 | €0.67 | matched |
| 37 | capture | 01a17328-1dd2-7e50-9659-8ef0c903dd52 | €49.00 | €0.67 | matched |
| 38 | capture | 01a17328-3ae2-703d-a37b-556bd1324111 | €9.00 | €0.19 | matched |
| 39 | capture | 01a17328-49e5-76ce-8eb6-8d8eb751de71 | €35.00 | €0.50 | matched |
| 40 | capture | 01a17328-5690-7138-aea3-ebd72cc5a458 | €35.00 | €0.50 | matched |
| 41 | refund | 01a17328-80b5-74b5-bdab-bf3297915a7b | -€28.00 | €0.00 | matched |
| 42 | capture | 01a17328-b759-7dd1-9a59-efd2f2fc3793 | €24.00 | €0.37 | matched |
| 43 | capture | 01a17328-ba4a-70b8-b6fa-fbd9b8dad5d9 | €35.00 | €0.50 | matched |
| 44 | capture | 01a17328-c61e-79fd-8207-b60cd8d75dc3 | €49.00 | €0.67 | matched |
| 45 | capture | 01a17328-f7cf-7f85-96e4-071c966e3eab | €9.00 | €0.19 | matched |
| 46 | capture | 01a17328-f929-70b1-9d2b-4b4de1aa53c6 | €49.00 | €0.67 | matched |
| 47 | refund | 01a17329-1694-740e-a7f4-4b3e7e2058b8 | -€11.00 | €0.00 | matched |
| 48 | capture | 01a17329-69cd-7992-b783-125261076bb1 | €49.00 | €0.67 | matched |
| 49 | capture | 01a17329-7114-7224-980f-9df8b9269251 | €15.00 | €0.26 | matched |
| 50 | capture | 01a17329-7aae-7ce0-ad13-32b4e7ad18a4 | €9.00 | €0.19 | matched |
| 51 | capture | 01a17329-7e73-7250-8d26-84420d90d4c4 | €35.00 | €0.50 | matched |
| 52 | capture | 01a17329-9298-781e-806c-4b82ed4cda2b | €15.00 | €0.26 | matched |
| 53 | capture | 01a17329-9f6e-735c-a3be-00b92e0f918e | €35.00 | €0.50 | matched |
| 54 | capture | 01a17329-a884-7165-a113-180f14b9d697 | €9.00 | €0.19 | matched |
| 55 | capture | 01a17329-ae22-7235-90e2-a9188cb5aa44 | €9.00 | €0.19 | matched |
| 56 | capture | 01a17329-e36e-7265-9361-adc534a43de6 | €24.00 | €0.37 | matched |
| 57 | capture | 01a17329-ecbf-7458-8d20-fc9b41e1c09b | €49.00 | €0.67 | matched |
| 58 | capture | 01a17329-ee55-75f0-af67-80d68e578a94 | €9.00 | €0.19 | matched |
| 59 | capture | 01a17329-f00d-7224-bc6f-4bca2dd9b724 | €9.00 | €0.19 | matched |
| 60 | capture | 01a1732a-18d8-7e55-b028-c699e046ddce | €15.00 | €0.26 | matched |
| 61 | capture | 01a1732a-22b1-7038-ab74-efe6417d66dd | €15.00 | €0.26 | matched |
| 62 | refund | 01a1732a-411a-73ef-8c6b-f1b41b885afa | -€22.00 | €0.00 | matched |
| 63 | capture | 01a1732a-52ee-7e89-af3b-020ca852f958 | €15.00 | €0.26 | matched |
| 64 | capture | 01a1732a-7acd-7503-a17c-3c542397ff29 | €15.00 | €0.26 | matched |
| 65 | capture | 01a1732a-7eda-70d2-83ac-a454851c2558 | €35.00 | €0.50 | matched |
| 66 | capture | 01a1732a-97bb-7dfb-99f5-87b868a4edc0 | €24.00 | €0.37 | matched |
| 67 | capture | 01a1732a-9a85-75dd-a7d6-3db98239a8b7 | €15.00 | €0.26 | matched |
| 68 | capture | 01a1732a-a683-72bb-8d7f-b5ae24cd5f48 | €35.00 | €0.50 | matched |
| 69 | capture | 01a1732a-adce-74f8-8f39-a8bdaeb0ee6e | €24.00 | €0.37 | matched |
| 70 | capture | 01a1732a-b37e-72a1-9e99-63df6095770f | €15.00 | €0.26 | matched |
| 71 | capture | 01a1732a-c6ee-700e-aa51-1f205105dbaf | €24.00 | €0.37 | matched |
| 72 | capture | 01a1732a-ec77-7ed9-90e8-84ff785b715d | €15.00 | €0.26 | matched |
| 73 | capture | 01a1732b-1faf-749d-b7b1-f3f6a213ea69 | €15.00 | €0.26 | matched |
| 74 | capture | 01a1732b-224f-71fb-bdb4-b526f399865d | €24.00 | €0.37 | matched |
| 75 | capture | 01a1732b-256c-79aa-ab42-cc9680f25ce3 | €35.00 | €0.50 | matched |
| 76 | capture | 01a1732b-3545-7cc8-b8e5-cf94c3afc67a | €24.00 | €0.37 | matched |
| 77 | capture | 01a1732b-3c9c-760b-83b6-cbfe15055e94 | €49.00 | €0.67 | matched |
| 78 | capture | 01a1732b-3e07-7b90-8abe-33b03c0dc83f | €35.00 | €0.50 | matched |
| 79 | capture | 01a1732b-6fb9-75d1-93a8-c5169faa80e6 | €9.00 | €0.19 | matched |
| 80 | capture | 01a1732b-70f0-703b-b0c5-c8936391ad6c | €49.00 | €0.67 | matched |
| 81 | capture | 01a1732b-7c02-7c4e-ad7c-9aa4905eedfb | €24.00 | €0.37 | matched |
| 82 | capture | 01a1732b-a6e9-7ca2-8ce1-15244225977f | €24.00 | €0.37 | matched |
| 83 | capture | 01a1732b-abab-7cc5-9b18-3fccaa805941 | €49.00 | €0.67 | matched |
| 84 | capture | 01a1732b-b025-72f0-97d5-30ffcc72cbf6 | €35.00 | €0.50 | matched |
| 85 | refund | 01a1732b-e1ce-7377-805c-3bd6eb019f54 | -€8.00 | €0.00 | matched |
| 86 | refund | 01a1732c-0d75-73af-a017-54e910c19bb1 | -€19.00 | €0.00 | matched |
| 87 | capture | 01a1732c-0fe2-7e64-a112-be58c6d85e42 | €49.00 | €0.67 | matched |
| 88 | capture | 01a1732c-1cc1-734e-97d3-17f95667ffb5 | €35.00 | €0.50 | matched |
| 89 | capture | 01a1732c-214d-79ff-9024-10fec7174b69 | €15.00 | €0.26 | matched |
| 90 | capture | 01a1732c-7128-754f-9d88-3a71bb688cf5 | €35.00 | €0.50 | matched |
| 91 | capture | 01a1732c-7dd0-7da1-b56d-720fb8559f75 | €15.00 | €0.26 | matched |
| 92 | capture | 01a1732c-8347-7ca2-b5d0-1c80512feffb | €24.00 | €0.37 | matched |
| 93 | capture | 01a1732c-9612-7e02-afa9-682e4d76bebe | €15.00 | €0.26 | matched |
| 94 | capture | 01a1732c-aa03-7c88-a345-a84175ed4d74 | €35.00 | €0.50 | matched |
| 95 | capture | 01a1732c-b4ab-77bd-8939-cf6e8aabfedb | €9.00 | €0.19 | matched |
| 96 | capture | 01a1732c-dec7-7cfa-a77d-7cf367fed54e | €49.00 | €0.67 | matched |
| 97 | capture | 01a1732c-e618-7f89-82df-4dcfb91f89bc | €9.00 | €0.19 | matched |
| 98 | capture | 01a1732c-e667-7e64-ab30-11cf2400efdd | €24.00 | €0.37 | matched |
| 99 | capture | 01a1732d-0ecd-7912-b4cb-54c3288b7f90 | €15.00 | €0.26 | matched |
| 100 | capture | 01a1732d-1121-7e26-ac35-fe1290a0f769 | €24.00 | €0.37 | matched |
| 101 | capture | 01a1732d-3e03-75e9-a9c2-576b541b2242 | €24.00 | €0.37 | matched |
| 102 | capture | 01a1732d-63fc-78d3-b43c-6f28d2874178 | €9.00 | €0.19 | matched |
| 103 | refund | 01a1732d-68c4-7038-a688-12060aad0c75 | -€9.00 | €0.00 | matched |
| 104 | capture | 01a1732d-6cc3-7f11-86a8-0a24165ba267 | €24.00 | €0.37 | matched |
| 105 | capture | 01a1732d-7ae5-7aa2-9ca5-bb7f756b3daf | €9.00 | €0.19 | matched |
| 106 | capture | 01a1732d-8779-7116-a189-650662ae3f61 | €24.00 | €0.37 | matched |
| 107 | capture | 01a1732d-97c2-7c74-a3a4-e93be0f1592e | €49.00 | €0.67 | matched |
| 108 | capture | 01a1732d-aa46-7a89-a786-77e90775535d | €49.00 | €0.67 | matched |
| 109 | capture | 01a1732d-c8ed-70e6-b6d0-157ac71a58c8 | €24.00 | €0.37 | matched |
| 110 | capture | 01a1732d-d6c5-7f85-9101-1b37c8acce9b | €24.00 | €0.37 | matched |
| 111 | capture | 01a1732d-da59-7cf4-beae-3c0d21ac0b28 | €15.00 | €0.26 | matched |
| 112 | capture | 01a1732d-e178-7d20-9295-b929ebac6be4 | €35.00 | €0.50 | matched |
| 113 | capture | 01a1732d-e042-73da-b1fc-801893bc053a | €9.00 | €0.19 | matched |
| 114 | refund | 01a1732d-f455-7cd7-bd9e-9429271458c7 | -€35.00 | €0.00 | matched |
| 115 | capture | 01a1732d-f82b-7326-abf0-6d7a27c4b8cb | €15.00 | €0.26 | matched |
| 116 | capture | 01a1732d-faee-70dd-b298-f9bab97fa04e | €49.00 | €0.67 | matched |
| 117 | capture | 01a1732e-0c55-79c9-b51c-ff1e7340ecc7 | €15.00 | €0.26 | matched |
| 118 | capture | 01a1732e-3be3-750c-9268-8174ab295b87 | €35.00 | €0.50 | matched |
| 119 | capture | 01a1732e-49c3-7c6d-84d4-e64d9167fd94 | €9.00 | €0.19 | matched |
| 120 | capture | 01a1732e-513d-727c-9235-8dd4ff6fbe35 | €24.00 | €0.37 | matched |
| 121 | capture | 01a1732e-5b46-7eb4-9cf3-3756adbb3bf3 | €15.00 | €0.26 | matched |
| 122 | capture | 01a1732e-5bc1-7eef-8dc4-cbb155191c4b | €35.00 | €0.50 | matched |
| 124 | capture | 01a1732e-674e-73ef-9cc8-be1560120b36 | €15.00 | €0.26 | matched |
| 125 | capture | 01a1732e-783f-7dd7-b280-088a063f61e1 | €9.00 | €0.19 | matched |
| 126 | capture | 01a1732e-99ab-771c-92c5-6e9c3cb120c1 | €9.00 | €0.19 | matched |