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
- 16 Oct, 12:10124 linesclean
- 16 Oct, 12:00118 lines2 breaks
- 16 Oct, 11:50107 lines2 breaks
- 16 Oct, 11:40115 lines3 breaks
- 16 Oct, 11:30129 lines1 break
- 16 Oct, 11:20132 lines2 breaks
- 16 Oct, 11:10107 lines1 break
- 16 Oct, 11:00126 lines3 breaks
- 16 Oct, 10:50142 lines2 breaks
- 16 Oct, 10:40118 lines3 breaks
- 16 Oct, 10:30124 lines2 breaks
- 16 Oct, 10:20122 lines4 breaks
- 16 Oct, 10:10128 lines4 breaks
- 16 Oct, 10:00128 lines5 breaks
16 Oct, 11:00
Gross
€2,737.00
PSP fee
€44.84
Net to the bank
€2,692.16
Settlement journal
#32185
Breaks for a person to look at
- duplicate linethe file lists it twicecapture:01a14461-22f1-76de-b681-7d10e62eb7ef is already settled by stl_EUR_2986914 line 39
- fee differencethe fee is not the contract feethe fee is 30, the contract says 26
- missing linein the books, not in the filecapture:01a1445f-a10b-7523-b7a1-1a780ff2e430 is in no file
| Line | Kind | Reference | Gross | Fee | Status |
|---|---|---|---|---|---|
| 40 | capture | 01a14461-2405-7399-8aeb-4b183ef365ad | €15.00 | €0.26 | duplicate line |
| 121 | capture | 01a14467-6467-7c82-8144-f7d81a9ba476 | €15.00 | €0.30 | fee difference |
| 1 | capture | 01a14459-1a32-7aa7-be23-344265983334 | €24.00 | €0.37 | matched |
| 2 | capture | 01a1445c-2a43-7d2f-9bb5-d9d2ce208dd1 | €9.00 | €0.19 | matched |
| 3 | capture | 01a1445d-d19b-79c9-a51b-137c5c45ea38 | €15.00 | €0.26 | matched |
| 4 | capture | 01a1445e-57d4-78a3-ac6e-4a65df0c7e5f | €15.00 | €0.26 | matched |
| 5 | capture | 01a1445e-717d-7fd1-83da-91f7a2719d66 | €35.00 | €0.50 | matched |
| 6 | refund | 01a1445e-a1c7-7de5-b413-cde92813a191 | -€14.00 | €0.00 | matched |
| 7 | capture | 01a1445e-a158-78a0-8bda-32c64b687813 | €9.00 | €0.19 | matched |
| 8 | capture | 01a1445e-b675-7f23-b36a-6ab544408058 | €49.00 | €0.67 | matched |
| 9 | capture | 01a1445e-c4b0-7289-9aea-121f5225bf3b | €15.00 | €0.26 | matched |
| 10 | capture | 01a1445e-c9b7-7f57-8541-72307ed14692 | €9.00 | €0.19 | matched |
| 11 | refund | 01a1445e-f11c-7ca2-89ae-b625536d4d21 | -€11.00 | €0.00 | matched |
| 12 | capture | 01a1445f-14e7-7ddb-b37f-20353c3f3988 | €35.00 | €0.50 | matched |
| 13 | capture | 01a1445f-1b80-76ca-85a0-5044c99b2325 | €49.00 | €0.67 | matched |
| 14 | capture | 01a1445f-2152-71b6-b13a-5bdae67b1f0d | €24.00 | €0.37 | matched |
| 15 | refund | 01a1445f-5018-7a6b-8514-2e0d80177c79 | -€21.00 | €0.00 | matched |
| 16 | capture | 01a1445f-6bae-7f01-8e9f-e65da8b69608 | €49.00 | €0.67 | matched |
| 17 | refund | 01a1445f-6c89-7df8-b54b-aa0c58c12e41 | -€42.00 | €0.00 | matched |
| 18 | capture | 01a1445f-70cd-7473-8798-e934a05b2fc9 | €15.00 | €0.26 | matched |
| 19 | capture | 01a1445f-7778-79ab-b75d-bfaeea1b5dd6 | €24.00 | €0.37 | matched |
| 20 | capture | 01a1445f-9357-7824-82a1-ab925a6db8b2 | €24.00 | €0.37 | matched |
| 21 | capture | 01a1445f-b5ae-7731-8840-c8f8fca47bb8 | €35.00 | €0.50 | matched |
| 22 | capture | 01a1445f-d3bc-711f-86a9-5d543e55e4d5 | €35.00 | €0.50 | matched |
| 23 | capture | 01a1445f-e1d8-766a-bc84-f053931c22ae | €35.00 | €0.50 | matched |
| 24 | capture | 01a1445f-f260-75b4-a4ab-660a76d132be | €35.00 | €0.50 | matched |
| 25 | capture | 01a1445f-fcc9-7cff-a173-5f636f2e0833 | €49.00 | €0.67 | matched |
| 26 | capture | 01a14460-0607-73b4-9170-c6adab762d57 | €24.00 | €0.37 | matched |
| 27 | refund | 01a14460-3ac2-7cb8-a841-e7b5f9b10472 | -€32.00 | €0.00 | matched |
| 28 | capture | 01a14460-4727-705f-a604-bbb0cb65ffc4 | €9.00 | €0.19 | matched |
| 29 | capture | 01a14460-55f2-743d-84ff-d50b9e1e8766 | €49.00 | €0.67 | matched |
| 30 | capture | 01a14460-780a-7bdf-944c-4014010eecaa | €35.00 | €0.50 | matched |
| 31 | capture | 01a14460-837d-7dd0-8207-15223362891f | €24.00 | €0.37 | matched |
| 32 | capture | 01a14460-a77d-71e7-97ba-a35ed93a6c2f | €49.00 | €0.67 | matched |
| 33 | capture | 01a14460-a963-7722-b3dc-cb203a09e486 | €9.00 | €0.19 | matched |
| 34 | capture | 01a14460-aaa9-7dfc-82c7-4a4d52b80df5 | €35.00 | €0.50 | matched |
| 35 | capture | 01a14460-b622-7e57-aacd-e1213dcbb61c | €35.00 | €0.50 | matched |
| 36 | refund | 01a14460-e57e-7ba2-934b-37025b9df324 | -€21.00 | €0.00 | matched |
| 37 | capture | 01a14460-e77b-7969-a4c3-612dcc756fca | €35.00 | €0.50 | matched |
| 38 | capture | 01a14460-f7c4-701a-98c9-dd2f3c06bac6 | €35.00 | €0.50 | matched |
| 39 | capture | 01a14461-2405-7399-8aeb-4b183ef365ad | €15.00 | €0.26 | matched |
| 41 | capture | 01a14461-3a95-7edb-b40a-879f4d7d98a8 | €24.00 | €0.37 | matched |
| 42 | capture | 01a14461-3c5f-71c0-b0b8-d40fd73161ef | €9.00 | €0.19 | matched |
| 43 | capture | 01a14461-4d6f-776b-a278-c93b7a82b42d | €35.00 | €0.50 | matched |
| 44 | capture | 01a14461-60bd-7aa5-b7da-8168837d8bc3 | €15.00 | €0.26 | matched |
| 45 | capture | 01a14461-7674-7353-bcc9-54c3c8abda0b | €24.00 | €0.37 | matched |
| 46 | capture | 01a14461-7e15-730f-a617-531c8d4351e6 | €35.00 | €0.50 | matched |
| 47 | capture | 01a14461-8037-7d0f-9c72-cc60a33bd6ec | €49.00 | €0.67 | matched |
| 48 | capture | 01a14461-ac9a-74e8-af19-b6c34d9aa54e | €9.00 | €0.19 | matched |
| 49 | capture | 01a14461-bfe2-772d-ac47-fa37cb002eba | €15.00 | €0.26 | matched |
| 50 | capture | 01a14461-dd83-777f-bad6-d5b56c828854 | €24.00 | €0.37 | matched |
| 51 | capture | 01a14461-f940-760e-ba09-d4bc42197d63 | €49.00 | €0.67 | matched |
| 52 | capture | 01a14461-f9da-7770-b873-56bcb194bdc6 | €15.00 | €0.26 | matched |
| 53 | capture | 01a14461-ffdd-7067-baf7-b5672cbd5f34 | €9.00 | €0.19 | matched |
| 54 | capture | 01a14462-074e-7f29-84c0-d57adfccfc67 | €24.00 | €0.37 | matched |
| 55 | capture | 01a14462-129b-79df-893d-a717ebd566c8 | €24.00 | €0.37 | matched |
| 56 | capture | 01a14462-14b2-7640-b609-4f356c2575ce | €24.00 | €0.37 | matched |
| 57 | capture | 01a14462-3f7f-7658-afd8-4a6e5a16dd01 | €15.00 | €0.26 | matched |
| 58 | capture | 01a14462-73ef-7fe4-bf4f-d0112ee58c61 | €49.00 | €0.67 | matched |
| 59 | capture | 01a14462-9421-78d5-87a4-2d6e05a7ee69 | €9.00 | €0.19 | matched |
| 60 | refund | 01a14462-9697-7973-bb15-43ce976bc76c | -€4.00 | €0.00 | matched |
| 61 | capture | 01a14462-9985-7c0d-8e0e-3ee5bf7c0bdf | €24.00 | €0.37 | matched |
| 62 | capture | 01a14462-a9dd-70e2-806e-a90a06121611 | €24.00 | €0.37 | matched |
| 63 | capture | 01a14462-b957-723d-b60a-8a4bbe5162d3 | €35.00 | €0.50 | matched |
| 64 | capture | 01a14462-c332-7fd0-a543-f1c72a3f185f | €49.00 | €0.67 | matched |
| 65 | capture | 01a14462-cee3-7c51-8929-d34e99e427e3 | €9.00 | €0.19 | matched |
| 66 | capture | 01a14462-d06e-7d10-ab94-626fbb4e089d | €35.00 | €0.50 | matched |
| 67 | capture | 01a14462-d9ae-76f7-aea5-44b8aad41adc | €15.00 | €0.26 | matched |
| 68 | capture | 01a14463-063c-761d-a3a6-f3c0ff54a0a1 | €49.00 | €0.67 | matched |
| 69 | capture | 01a14463-13e1-7de9-93f4-da66a4bc4bf0 | €9.00 | €0.19 | matched |
| 70 | capture | 01a14463-2bff-7943-8ab7-1d9cfce02e0a | €9.00 | €0.19 | matched |
| 71 | capture | 01a14463-3d37-787c-a660-21d95d265417 | €35.00 | €0.50 | matched |
| 72 | capture | 01a14463-6762-744a-9245-845981d0b2db | €15.00 | €0.26 | matched |
| 73 | capture | 01a14463-76a4-7192-8544-0c5c5408b129 | €9.00 | €0.19 | matched |
| 74 | capture | 01a14463-7d34-7068-a86c-aac39b06e643 | €15.00 | €0.26 | matched |
| 75 | capture | 01a14463-7f69-7db9-a7cb-4670834d471b | €9.00 | €0.19 | matched |
| 76 | refund | 01a14463-9c87-7013-a78c-4903a8c78353 | -€7.00 | €0.00 | matched |
| 77 | refund | 01a14463-aadb-76d4-80ce-51c2732e7759 | -€9.00 | €0.00 | matched |
| 78 | capture | 01a14463-b4a7-7c3d-980c-381661444923 | €9.00 | €0.19 | matched |
| 79 | capture | 01a14463-b998-7dba-aab3-c322a3b516b8 | €35.00 | €0.50 | matched |
| 80 | capture | 01a14463-f028-785b-a19d-9696f82bcaa1 | €15.00 | €0.26 | matched |
| 81 | capture | 01a14463-f821-79e5-8b79-4dc58939b3f3 | €9.00 | €0.19 | matched |
| 82 | capture | 01a14464-0c66-7c25-a1cc-98b13ecdd1db | €49.00 | €0.67 | matched |
| 83 | capture | 01a14464-17f0-75aa-8649-f9185077e013 | €49.00 | €0.67 | matched |
| 84 | capture | 01a14464-313c-74b3-aad0-3335e38ba036 | €49.00 | €0.67 | matched |
| 85 | capture | 01a14464-36e2-7dd6-aa4d-ff9bd637ab9f | €15.00 | €0.26 | matched |
| 86 | capture | 01a14464-490c-720c-bc89-ae266585ab85 | €49.00 | €0.67 | matched |
| 87 | capture | 01a14464-4f2c-704a-91bf-a7d5d3e18c2d | €15.00 | €0.26 | matched |
| 88 | capture | 01a14464-6a6e-700f-b925-20b18c55a977 | €49.00 | €0.67 | matched |
| 89 | capture | 01a14464-8b23-7c32-a489-d42f84b8a93c | €9.00 | €0.19 | matched |
| 90 | refund | 01a14464-9f52-7f93-a3fc-5010d64864ea | -€12.00 | €0.00 | matched |
| 91 | capture | 01a14464-a9bc-7368-95ca-977418e3d8e6 | €9.00 | €0.19 | matched |
| 92 | capture | 01a14464-bf1b-7919-933d-f1b72d66bd47 | €15.00 | €0.26 | matched |
| 93 | capture | 01a14464-e231-731b-8606-bbab6c3b31a5 | €15.00 | €0.26 | matched |
| 94 | capture | 01a14465-168f-7083-bdab-25d3e9d4a4d1 | €24.00 | €0.37 | matched |
| 95 | capture | 01a14465-2cd9-7d6b-9984-e621b8645722 | €35.00 | €0.50 | matched |
| 96 | capture | 01a14465-35d6-7157-bf12-9ca6e0bc6bc7 | €24.00 | €0.37 | matched |
| 97 | capture | 01a14465-3bb7-746d-940d-dbc0c5db7910 | €24.00 | €0.37 | matched |
| 98 | capture | 01a14465-5050-71bd-b925-3078f6ff9553 | €49.00 | €0.67 | matched |
| 99 | capture | 01a14465-529e-7cdd-95e5-debfb29f24a1 | €15.00 | €0.26 | matched |
| 100 | capture | 01a14465-5ab2-7ca7-9d30-6aa642c4f538 | €49.00 | €0.67 | matched |
| 101 | capture | 01a14465-7209-7e65-8594-d6d297b37e7d | €15.00 | €0.26 | matched |
| 102 | capture | 01a14465-8982-7b30-a547-65774903c156 | €9.00 | €0.19 | matched |
| 103 | refund | 01a14465-947c-707f-a9e4-5c116ed2d4d4 | -€42.00 | €0.00 | matched |
| 104 | capture | 01a14465-bd1c-7863-aaa5-e2987d3582ac | €9.00 | €0.19 | matched |
| 105 | capture | 01a14465-f830-7711-8001-d9e2ba29722b | €24.00 | €0.37 | matched |
| 106 | capture | 01a14466-3a79-7c7f-a5c9-5f17ddb0030e | €24.00 | €0.37 | matched |
| 107 | capture | 01a14466-3cfa-7b53-8eaa-360c2ab69801 | €49.00 | €0.67 | matched |
| 108 | capture | 01a14466-505c-779e-ae52-b707546abf83 | €24.00 | €0.37 | matched |
| 109 | capture | 01a14466-59f4-746e-bff9-39beb4fdcf5e | €35.00 | €0.50 | matched |
| 110 | capture | 01a14466-6abd-76c8-9d3c-b7f2d4df74c4 | €15.00 | €0.26 | matched |
| 111 | capture | 01a14466-94a0-7339-871f-92157a1fa369 | €15.00 | €0.26 | matched |
| 112 | capture | 01a14466-a5b9-7e25-ae0d-98491e91ceb0 | €24.00 | €0.37 | matched |
| 113 | capture | 01a14466-b252-79d8-b19b-4e0e1fda23d4 | €15.00 | €0.26 | matched |
| 114 | capture | 01a14466-b8a9-7cdf-9e0e-29f8469ee3df | €49.00 | €0.67 | matched |
| 115 | capture | 01a14466-bdf4-780e-b3db-0edf1a9c917c | €35.00 | €0.50 | matched |
| 116 | capture | 01a14466-c764-701f-a351-9120ae1329d5 | €35.00 | €0.50 | matched |
| 117 | capture | 01a14466-cc4e-7ed3-bde9-c3e4b8a2c282 | €9.00 | €0.19 | matched |
| 118 | capture | 01a14466-fbdc-7829-9eeb-069eb2524d49 | €49.00 | €0.67 | matched |
| 119 | capture | 01a14467-0116-7f5d-b76d-a6be320a67ba | €24.00 | €0.37 | matched |
| 120 | capture | 01a14467-2269-744f-81e5-cd6049e8d3ef | €15.00 | €0.26 | matched |
| 122 | capture | 01a14467-6566-79cd-b587-e7c3f966fae8 | €49.00 | €0.67 | matched |
| 123 | capture | 01a14467-67e9-7649-bb88-66a2e8b599d1 | €24.00 | €0.37 | matched |
| 124 | refund | 01a14467-70fc-7fec-ba7f-e9f9523cfeac | -€10.00 | €0.00 | matched |
| 125 | capture | 01a14467-7b74-75b5-b1e8-e49a6b85e579 | €24.00 | €0.37 | matched |
| 126 | capture | 01a14467-8e60-7029-aceb-40eae7962a9a | €9.00 | €0.19 | matched |