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
- 14 Oct, 20:10122 linesclean
- 14 Oct, 20:00119 lines1 break
- 14 Oct, 19:50128 lines2 breaks
- 14 Oct, 19:40134 linesclean
- 14 Oct, 19:30133 lines1 break
- 14 Oct, 19:20107 lines1 break
- 14 Oct, 19:10124 lines6 breaks
- 14 Oct, 19:00124 lines3 breaks
- 14 Oct, 18:50115 lines1 break
- 14 Oct, 18:40117 lines5 breaks
- 14 Oct, 18:30125 lines3 breaks
- 14 Oct, 18:20125 lines4 breaks
- 14 Oct, 18:10124 lines2 breaks
- 14 Oct, 18:00140 lines3 breaks
14 Oct, 18:00
Gross
€3,124.00
PSP fee
€49.81
Net to the bank
€3,074.19
Settlement journal
#536
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a13b92-4005-7367-a5cd-b4496b31892b is already settled by stl_EUR_2986668 line 1
- fee differencethe fee is not the contract feethe fee is 27, the contract says 26
- missing linein the books, not in the filecapture:01a13b93-6b46-7469-8fc9-dd1c6b05244d is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 2 | capture | 01a13b92-41ec-7f65-8b29-9c665818f37a | €49.00 | €0.67 | duplicate line |
| 15 | capture | 01a13b92-fa03-7cdb-9441-0842519c457f | €15.00 | €0.27 | fee difference |
| 1 | capture | 01a13b92-41ec-7f65-8b29-9c665818f37a | €49.00 | €0.67 | matched |
| 3 | capture | 01a13b92-4991-7d60-916a-4a7a9102c79e | €35.00 | €0.50 | matched |
| 4 | capture | 01a13b92-59ba-729b-867e-2417f94abb71 | €24.00 | €0.37 | matched |
| 5 | capture | 01a13b92-6252-7e1c-8629-b5f957799584 | €9.00 | €0.19 | matched |
| 6 | capture | 01a13b92-6371-7fed-ae94-198c96002c99 | €15.00 | €0.26 | matched |
| 7 | refund | 01a13b92-8744-73a2-aae4-d84edd0039fb | -€32.00 | €0.00 | matched |
| 8 | capture | 01a13b92-889a-777d-a581-0c0c54a193f8 | €24.00 | €0.37 | matched |
| 9 | capture | 01a13b92-a1ce-74e9-819a-97a8b52a294a | €9.00 | €0.19 | matched |
| 10 | capture | 01a13b92-a852-7d52-af17-8a8ac77583db | €9.00 | €0.19 | matched |
| 11 | capture | 01a13b92-ccc7-7ea2-ad7e-1e68733679ca | €49.00 | €0.67 | matched |
| 12 | capture | 01a13b92-d461-71a9-bf86-695cc4c7d7b8 | €15.00 | €0.26 | matched |
| 13 | capture | 01a13b92-ded4-71b9-877c-c3455c4a441b | €49.00 | €0.67 | matched |
| 14 | capture | 01a13b92-e1d0-739c-bcaa-0ecd5c5594ba | €24.00 | €0.37 | matched |
| 16 | capture | 01a13b93-050f-7211-9a24-171e6769a0b1 | €24.00 | €0.37 | matched |
| 17 | capture | 01a13b93-051c-7a37-b7c7-4745a59acded | €24.00 | €0.37 | matched |
| 18 | capture | 01a13b93-0cb6-7992-91b6-608eb2b0b8ca | €9.00 | €0.19 | matched |
| 19 | refund | 01a13b93-1ddf-7857-92dd-e89eb98c9aa7 | -€18.00 | €0.00 | matched |
| 20 | capture | 01a13b93-2171-7769-9abe-40275ddf1898 | €15.00 | €0.26 | matched |
| 21 | capture | 01a13b93-22fa-76ce-a29b-0ca91c470135 | €49.00 | €0.67 | matched |
| 22 | refund | 01a13b93-3162-7448-849a-bde70d48e57b | -€12.00 | €0.00 | matched |
| 23 | capture | 01a13b93-4918-750b-8460-6adcd426d972 | €15.00 | €0.26 | matched |
| 24 | capture | 01a13b93-504f-726e-a7d3-85234528e897 | €49.00 | €0.67 | matched |
| 25 | capture | 01a13b93-5064-70dc-9d05-1a74ec88f440 | €35.00 | €0.50 | matched |
| 26 | capture | 01a13b93-7073-7a9b-bc5c-181f0e230185 | €9.00 | €0.19 | matched |
| 27 | refund | 01a13b93-7184-71b7-af28-0ac83ea68877 | -€9.00 | €0.00 | matched |
| 28 | refund | 01a13b93-7c9e-7211-b739-98fa5351a9fa | -€8.00 | €0.00 | matched |
| 29 | capture | 01a13b93-8735-7bbc-a66c-fbd77de8d333 | €24.00 | €0.37 | matched |
| 30 | capture | 01a13b93-af86-7df2-b461-3511634ba159 | €15.00 | €0.26 | matched |
| 31 | capture | 01a13b93-b1c3-7bf5-9bdc-484f10301a44 | €35.00 | €0.50 | matched |
| 32 | capture | 01a13b93-e77a-7263-beb1-b97702ecc6c7 | €49.00 | €0.67 | matched |
| 33 | capture | 01a13b94-06aa-7e79-b5c7-58aa0e8c759d | €35.00 | €0.50 | matched |
| 34 | capture | 01a13b94-0a8c-7970-8a41-bdb26727df97 | €35.00 | €0.50 | matched |
| 35 | capture | 01a13b94-10dc-720a-8b94-e11056e9495c | €15.00 | €0.26 | matched |
| 36 | capture | 01a13b94-477b-70a3-a8d4-912a7aaa91fc | €35.00 | €0.50 | matched |
| 37 | capture | 01a13b94-61a1-7ae0-9c43-2bbe6a23ddf7 | €15.00 | €0.26 | matched |
| 38 | capture | 01a13b94-6cfe-7483-9339-b292a5e288e0 | €9.00 | €0.19 | matched |
| 39 | capture | 01a13b94-6d27-7555-be7d-68c8f9e1cb5a | €49.00 | €0.67 | matched |
| 40 | capture | 01a13b94-701d-7deb-8601-07fab022c1d6 | €9.00 | €0.19 | matched |
| 41 | capture | 01a13b94-72f3-715e-b96c-6602e30936da | €35.00 | €0.50 | matched |
| 42 | capture | 01a13b94-7e0c-730f-8cfc-0d0d631eb728 | €24.00 | €0.37 | matched |
| 43 | capture | 01a13b94-88cc-77a6-a888-2fb63b88ff52 | €15.00 | €0.26 | matched |
| 44 | capture | 01a13b94-adbe-731d-b205-a3e4eaef4252 | €9.00 | €0.19 | matched |
| 45 | capture | 01a13b94-b3d2-720f-91e8-fa76a21f6d76 | €15.00 | €0.26 | matched |
| 46 | refund | 01a13b94-bdc6-7550-9d43-25403e055da7 | -€5.00 | €0.00 | matched |
| 47 | capture | 01a13b94-c261-7c4b-92e2-110603c69f7c | €35.00 | €0.50 | matched |
| 48 | capture | 01a13b94-c636-7fac-bfeb-d79364d08e27 | €9.00 | €0.19 | matched |
| 49 | capture | 01a13b94-d94b-798e-ba71-f9de5af69eb7 | €15.00 | €0.26 | matched |
| 50 | refund | 01a13b94-dad9-7918-9220-c747371d6dff | -€5.00 | €0.00 | matched |
| 51 | capture | 01a13b94-e1b5-7208-86bd-d374705f1e7c | €49.00 | €0.67 | matched |
| 52 | capture | 01a13b95-0566-7e7a-930f-bb65c1f35ef9 | €24.00 | €0.37 | matched |
| 53 | capture | 01a13b95-0d66-7aaf-b2fb-c91fb968ee2f | €15.00 | €0.26 | matched |
| 54 | capture | 01a13b95-36cc-7477-ba1d-8e7e142ecff6 | €35.00 | €0.50 | matched |
| 55 | capture | 01a13b95-52e0-7187-b2b9-dcdd60b04181 | €15.00 | €0.26 | matched |
| 56 | capture | 01a13b95-59bb-73a2-afc8-5b4a05260735 | €15.00 | €0.26 | matched |
| 57 | capture | 01a13b95-83e4-7aa2-8742-ad3b2e8e63f9 | €15.00 | €0.26 | matched |
| 58 | capture | 01a13b95-9c59-7d57-af40-11c59d84f49e | €24.00 | €0.37 | matched |
| 59 | capture | 01a13b95-cc01-76f8-81dc-09d4227d84e8 | €49.00 | €0.67 | matched |
| 60 | capture | 01a13b95-cd5f-7809-8325-8ce58c4c2c53 | €15.00 | €0.26 | matched |
| 61 | capture | 01a13b95-d25c-7c78-90d5-6a9f094cefcb | €24.00 | €0.37 | matched |
| 62 | capture | 01a13b95-dd9d-74ce-a3c1-aabe80b12bb3 | €9.00 | €0.19 | matched |
| 63 | capture | 01a13b95-e61e-7af0-aa2d-0824957bd34f | €24.00 | €0.37 | matched |
| 64 | refund | 01a13b96-0e91-7ddb-9b05-a2fe359fed3c | -€4.00 | €0.00 | matched |
| 65 | capture | 01a13b96-52ba-7579-a975-2e87689a413a | €9.00 | €0.19 | matched |
| 66 | capture | 01a13b96-7752-724b-a6b3-20dc452aa8fc | €49.00 | €0.67 | matched |
| 67 | capture | 01a13b96-7b59-72fb-8470-5adb5c556cbe | €24.00 | €0.37 | matched |
| 68 | capture | 01a13b96-9858-7c42-b529-fe45523dfc54 | €35.00 | €0.50 | matched |
| 69 | capture | 01a13b96-c933-7e10-8fb3-a7bf2e405b20 | €35.00 | €0.50 | matched |
| 70 | capture | 01a13b96-cd14-7f85-9fb0-0cf8392df034 | €9.00 | €0.19 | matched |
| 71 | capture | 01a13b97-04f8-7764-b8cd-246713deb603 | €9.00 | €0.19 | matched |
| 72 | capture | 01a13b97-1685-7e9d-b1f3-9ad636714b72 | €49.00 | €0.67 | matched |
| 73 | refund | 01a13b97-292f-72d8-a994-454bf7aed436 | -€29.00 | €0.00 | matched |
| 74 | capture | 01a13b97-3766-7eda-adaf-fd31417dc14e | €35.00 | €0.50 | matched |
| 75 | capture | 01a13b97-5b6f-75f6-9798-786755660227 | €49.00 | €0.67 | matched |
| 76 | capture | 01a13b97-7588-79b5-bd57-5c4696323103 | €9.00 | €0.19 | matched |
| 77 | capture | 01a13b97-7bc6-76c2-b4a5-a040fbb36892 | €35.00 | €0.50 | matched |
| 78 | capture | 01a13b97-88ec-7423-b046-d51faec109dc | €15.00 | €0.26 | matched |
| 79 | capture | 01a13b97-9d89-7f2f-a083-6fe0376a4208 | €24.00 | €0.37 | matched |
| 80 | refund | 01a13b97-a784-7bcc-91ea-d17c1b6e4fc6 | -€22.00 | €0.00 | matched |
| 81 | capture | 01a13b97-b271-7da0-9618-a26fb5e11e9d | €49.00 | €0.67 | matched |
| 82 | capture | 01a13b97-b6f0-7aa8-bbf7-32cf752d51a3 | €49.00 | €0.67 | matched |
| 83 | capture | 01a13b97-c75f-7be4-800f-e5d31f0c5bfb | €9.00 | €0.19 | matched |
| 84 | capture | 01a13b97-c9ba-7fcd-891f-e8a870a89a70 | €9.00 | €0.19 | matched |
| 85 | capture | 01a13b97-e52f-7a8f-bbd8-f3aa19bee31e | €49.00 | €0.67 | matched |
| 86 | capture | 01a13b97-e52f-7f58-bcf9-c4c8990b83a7 | €49.00 | €0.67 | matched |
| 87 | capture | 01a13b97-e5ea-7904-9c07-b56b12c52ca5 | €35.00 | €0.50 | matched |
| 88 | capture | 01a13b98-068e-7b3d-a47b-83e22f6c27c2 | €49.00 | €0.67 | matched |
| 89 | capture | 01a13b98-28ab-71b6-b17b-1af61e3e757a | €15.00 | €0.26 | matched |
| 90 | capture | 01a13b98-362c-7773-b8f9-978b689e4109 | €9.00 | €0.19 | matched |
| 91 | capture | 01a13b98-5044-7c46-9a07-59ab3fe2a07f | €15.00 | €0.26 | matched |
| 92 | capture | 01a13b98-7dec-7dce-b423-91c5084db68b | €35.00 | €0.50 | matched |
| 93 | capture | 01a13b98-a29e-70a5-a95b-eb43756a0a42 | €49.00 | €0.67 | matched |
| 94 | capture | 01a13b98-d09d-73fb-8dab-6dfa64d2a125 | €49.00 | €0.67 | matched |
| 95 | capture | 01a13b98-d860-7660-bcda-e22698be581a | €24.00 | €0.37 | matched |
| 96 | capture | 01a13b98-da68-7ecb-856d-7f36ed2d6859 | €9.00 | €0.19 | matched |
| 97 | capture | 01a13b98-db5f-79d3-a757-351c071b9085 | €24.00 | €0.37 | matched |
| 98 | capture | 01a13b98-dd5a-7ce0-aa57-5dc72e97cabc | €24.00 | €0.37 | matched |
| 99 | capture | 01a13b98-f1f6-7b87-8e89-1d120f3fddee | €24.00 | €0.37 | matched |
| 100 | capture | 01a13b98-f6f8-7daa-9b09-9053707bbc80 | €15.00 | €0.26 | matched |
| 101 | capture | 01a13b98-f9a6-72e9-ae5a-8e8f5baeae29 | €24.00 | €0.37 | matched |
| 102 | capture | 01a13b99-47ed-742b-ac2f-44ccb329e5fb | €15.00 | €0.26 | matched |
| 103 | capture | 01a13b99-47f5-78ed-bf57-5701b68fe20e | €15.00 | €0.26 | matched |
| 104 | capture | 01a13b99-5f64-740f-a1aa-f604d804a6dc | €24.00 | €0.37 | matched |
| 105 | capture | 01a13b99-6173-7628-b222-fbe85ab1c183 | €24.00 | €0.37 | matched |
| 106 | capture | 01a13b99-683d-7515-bb23-cf5a2c0fd137 | €24.00 | €0.37 | matched |
| 107 | capture | 01a13b99-74f8-7abe-a9a1-958edfe763cf | €35.00 | €0.50 | matched |
| 108 | capture | 01a13b99-88ef-7ea3-af65-d282feaecdad | €24.00 | €0.37 | matched |
| 109 | capture | 01a13b99-8b7a-734c-aa8c-a84ddf510d9f | €49.00 | €0.67 | matched |
| 110 | capture | 01a13b99-b64e-7ee2-987a-e24052ccf849 | €49.00 | €0.67 | matched |
| 111 | capture | 01a13b99-ca12-7b56-bf73-84808a4edb07 | €9.00 | €0.19 | matched |
| 112 | capture | 01a13b99-d962-76a4-8ca2-ca4867f8196b | €9.00 | €0.19 | matched |
| 113 | capture | 01a13b99-e064-70b3-b3ad-fe17774df1c2 | €24.00 | €0.37 | matched |
| 114 | capture | 01a13b99-f895-74e3-830f-d8cbcc2616e0 | €35.00 | €0.50 | matched |
| 115 | capture | 01a13b9a-0830-783c-9821-c42ebbb480af | €9.00 | €0.19 | matched |
| 116 | capture | 01a13b9a-237d-72aa-affa-9222233db410 | €35.00 | €0.50 | matched |
| 117 | capture | 01a13b9a-3b91-77b0-8bb3-bab3e2125a5c | €24.00 | €0.37 | matched |
| 118 | capture | 01a13b9a-4a28-7570-8572-4434e7911ed3 | €9.00 | €0.19 | matched |
| 119 | capture | 01a13b9a-4de5-7c4d-a729-29ba34a8141a | €49.00 | €0.67 | matched |
| 120 | capture | 01a13b9a-5367-7c73-879b-48244964ce56 | €9.00 | €0.19 | matched |
| 121 | capture | 01a13b9a-5b07-7fee-8c3a-277839f24d16 | €24.00 | €0.37 | matched |
| 122 | capture | 01a13b9a-5b29-7bc3-bb37-86e103d6aff2 | €15.00 | €0.26 | matched |
| 123 | capture | 01a13b9a-6c69-78f6-957d-d2bf6482da53 | €15.00 | €0.26 | matched |
| 124 | capture | 01a13b9a-887b-7303-a708-a53f1a9a75b0 | €24.00 | €0.37 | matched |
| 125 | capture | 01a13b9a-8a4d-7af3-bd3e-2b8d5d7b859c | €24.00 | €0.37 | matched |
| 126 | capture | 01a13b9a-a3d5-7125-943c-738ccb38b08b | €49.00 | €0.67 | matched |
| 127 | refund | 01a13b9a-a95a-7c80-ac61-3873336c0f64 | -€8.00 | €0.00 | matched |
| 128 | capture | 01a13b9a-baa3-7054-9d59-e28b5547ef2b | €9.00 | €0.19 | matched |
| 129 | capture | 01a13b9a-bd07-79f0-bde8-6f4383a01ab6 | €35.00 | €0.50 | matched |
| 130 | capture | 01a13b9a-c192-7eaf-9785-df1b5dc9e4fe | €49.00 | €0.67 | matched |
| 131 | capture | 01a13b9a-e930-7110-a2ec-1140ccdcb1f4 | €9.00 | €0.19 | matched |
| 132 | capture | 01a13b9a-f36c-7221-b050-8e141f5f4fce | €9.00 | €0.19 | matched |
| 133 | capture | 01a13b9a-f6cf-792c-8468-b49eecc6a5ac | €15.00 | €0.26 | matched |
| 134 | refund | 01a13b9a-f788-7cd8-8b8a-dbe66dcf2b2a | -€7.00 | €0.00 | matched |
| 135 | capture | 01a13b9b-0a03-74c8-b80c-e0166ffd5e28 | €15.00 | €0.26 | matched |
| 136 | capture | 01a13b9b-1533-76a5-9f7b-5693d797d216 | €9.00 | €0.19 | matched |
| 137 | capture | 01a13b9b-20de-7be9-acd8-f8eddbf770ab | €15.00 | €0.26 | matched |
| 138 | capture | 01a13b9b-41ba-750e-be0d-da37e2b0cee5 | €49.00 | €0.67 | matched |
| 139 | capture | 01a13b9b-462b-74e4-abdf-dc5374a54526 | €24.00 | €0.37 | matched |
| 140 | capture | 01a13b9b-47ff-74c8-9fda-5d2ef66e0aa6 | €24.00 | €0.37 | matched |