Car Wash Ledger

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

3 Nov, 16:30

Gross

€2,503.00

PSP fee

€39.39

Net to the bank

€2,463.61

Settlement journal

#364149

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a244-833e-76b4-a727-6b4e342b10e7 is already settled by stl_EUR_2989539 line 78
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
LineKindReferenceGrossFeeStatus
79capture01a1a244-9a98-74fe-b41d-5e31a09dd43b€49.00€0.67duplicate line
84capture01a1a245-28a2-75dd-b7f6-dde6e73e6a60€9.00€0.24fee difference
1capture01a1a237-8f0e-76f9-a107-1c4d471ba788€9.00€0.19matched
2capture01a1a239-f9db-7abb-959f-f39f65fd1280€15.00€0.26matched
3capture01a1a23a-893a-7a85-9b59-3f45509d12e2€24.00€0.37matched
4capture01a1a23b-966c-736d-9bc9-daf373245337€24.00€0.37matched
5capture01a1a23f-107c-72e1-880e-445746cdbbd5€15.00€0.26matched
6capture01a1a23f-37a4-7ecd-acfe-ae16897674ac€35.00€0.50matched
7capture01a1a23f-41a6-75e9-92ff-0139ad0cc033€15.00€0.26matched
8capture01a1a23f-4e5e-7fb1-b6dd-1f08b5de8b39€49.00€0.67matched
9capture01a1a23f-7d7d-70e2-8a43-ae7b281a131a€15.00€0.26matched
10capture01a1a23f-b326-770d-8626-932fa535aae1€49.00€0.67matched
11capture01a1a23f-c08a-785c-b0ca-79b30b9ce9d4€24.00€0.37matched
12capture01a1a23f-c5b2-7cfe-aa02-89de442155a4€9.00€0.19matched
13capture01a1a23f-d829-7dfa-af45-9e6003d38e2c€24.00€0.37matched
14capture01a1a23f-db32-754b-8795-d0ac7a373bc6€49.00€0.67matched
15capture01a1a23f-f46a-735b-afe5-96e720e322a8€9.00€0.19matched
16capture01a1a240-0c7f-7c66-8173-8b7c6328e05f€24.00€0.37matched
17capture01a1a240-1051-748e-b669-4b5c62bd9ebc€49.00€0.67matched
18capture01a1a240-120a-7a13-9eda-05379fd6eae0€15.00€0.26matched
19capture01a1a240-1f9e-7c62-8345-cde21a50a7d3€35.00€0.50matched
20capture01a1a240-2457-77a9-bf62-ee2a3aaad2b1€35.00€0.50matched
21capture01a1a240-3259-754b-9129-a1ff85f6a0ac€24.00€0.37matched
22capture01a1a240-367e-7c4f-b01f-e976ae0667e2€15.00€0.26matched
23capture01a1a240-4a88-7732-8c63-712254ca4a44€35.00€0.50matched
24capture01a1a240-6367-7198-94b7-a4cdffecdef6€49.00€0.67matched
25capture01a1a240-6862-73cd-8cff-1100ca4fee1d€9.00€0.19matched
26capture01a1a240-6d36-7e64-96fd-fe1d5b840aeb€9.00€0.19matched
27refund01a1a240-76d4-7850-b216-208f8c909574-€9.00€0.00matched
28capture01a1a241-104f-7342-83f8-d264912070da€24.00€0.37matched
29capture01a1a241-1db2-71ed-acff-cc1e78e58fa9€9.00€0.19matched
30capture01a1a241-39a4-75ea-b20c-e5c4ef20afb4€49.00€0.67matched
31capture01a1a241-54d7-74bb-b7d5-82a4f6d0d0f7€15.00€0.26matched
32capture01a1a241-6260-76e0-980b-362034236c2f€35.00€0.50matched
33capture01a1a241-72e9-7979-a110-23fac81cdf59€35.00€0.50matched
34capture01a1a241-786b-7abb-b68b-d469ecf2c288€35.00€0.50matched
35capture01a1a241-7e14-7bd6-8171-c22b86144280€49.00€0.67matched
36capture01a1a241-9321-79e8-a3f7-f5fb59830d3b€9.00€0.19matched
37refund01a1a241-bd0f-7860-9b78-557ee658a81c-€33.00€0.00matched
38capture01a1a241-e994-7b2d-82b0-cad693acd8a1€24.00€0.37matched
39capture01a1a242-020e-756c-bc00-a5e5c9e58a96€15.00€0.26matched
40capture01a1a242-14f0-7ff0-817e-8e763fe8f111€24.00€0.37matched
41capture01a1a242-16b4-7823-98d0-d20999ed85e8€15.00€0.26matched
42capture01a1a242-21d4-7b42-b19c-f29d9e5cd989€35.00€0.50matched
43capture01a1a242-447b-7e4f-b183-f5127779731d€9.00€0.19matched
44capture01a1a242-50bc-7c06-b25b-19e156a0ba5d€35.00€0.50matched
45capture01a1a242-53b9-7759-a879-60487f7e0bb1€9.00€0.19matched
46capture01a1a242-5cf5-74c6-a479-6ffe0c2ac315€9.00€0.19matched
47capture01a1a242-6176-7f72-9335-e9bc765e9dd5€24.00€0.37matched
48refund01a1a242-76f9-701f-94d5-9f9e45e2052c-€5.00€0.00matched
49capture01a1a242-82e8-7560-b89d-4f95aff279c8€35.00€0.50matched
50capture01a1a242-892e-733c-a3cc-7257220766bf€9.00€0.19matched
51capture01a1a242-8df1-7067-ada7-33fd14fbca34€49.00€0.67matched
52capture01a1a242-b81b-7198-bc2c-ff2e9ac8f900€24.00€0.37matched
53refund01a1a242-b90f-734a-8f6a-11eb53657642-€6.00€0.00matched
54capture01a1a242-c471-75d1-96da-7dceba4c6863€35.00€0.50matched
55capture01a1a243-2844-7942-9128-27e70b6a2abb€35.00€0.50matched
56capture01a1a243-2d19-71c7-8aad-443c5d3bf383€15.00€0.26matched
57capture01a1a243-8282-7c40-a58c-09d33c54db7c€9.00€0.19matched
58capture01a1a243-8ab4-78bb-b15e-99e6d26186d1€9.00€0.19matched
59capture01a1a243-9924-717b-b5d6-2e0156ba4131€49.00€0.67matched
60capture01a1a243-9ee2-75a5-a211-49b935a28b30€49.00€0.67matched
61capture01a1a243-bbb8-70f3-b88e-8b1a8fa1135c€35.00€0.50matched
62capture01a1a243-bc20-72ca-b87f-27ad55db1182€35.00€0.50matched
63capture01a1a243-c5f8-759d-934c-1f93771f48ae€49.00€0.67matched
64capture01a1a244-0597-74c7-bb0d-de431d6c342b€35.00€0.50matched
65capture01a1a244-076d-7196-b107-04fe0683fed4€35.00€0.50matched
66capture01a1a244-07ac-71fa-9db3-9e565379ffee€15.00€0.26matched
67capture01a1a244-1071-7a74-8458-13712933b038€9.00€0.19matched
68capture01a1a244-1574-713b-a48d-41e2df991263€15.00€0.26matched
69capture01a1a244-2abb-70a0-b3b4-4c084ac6eab3€24.00€0.37matched
70capture01a1a244-3108-75a8-b7af-59590480aa43€24.00€0.37matched
71refund01a1a244-41da-7dad-ab16-ee382d22e1d5-€11.00€0.00matched
72capture01a1a244-51f3-70d6-bedc-334343181242€49.00€0.67matched
73refund01a1a244-6211-71c8-828f-4c2c80bb6f89-€20.00€0.00matched
74capture01a1a244-7873-7749-bf57-921adacb94e6€35.00€0.50matched
75capture01a1a244-828f-7bdd-aaff-380813782e9d€9.00€0.19matched
76capture01a1a244-930c-7820-bae1-6c873332819e€15.00€0.26matched
77capture01a1a244-9587-7a8b-8644-e2cfb98a00c9€35.00€0.50matched
78capture01a1a244-9a98-74fe-b41d-5e31a09dd43b€49.00€0.67matched
80capture01a1a244-b79e-7f42-8a5c-3db17637c20c€15.00€0.26matched
81refund01a1a244-d18e-78eb-9107-9a4011995a26-€8.00€0.00matched
82capture01a1a244-ed57-7ce2-9598-6ca6d9155406€49.00€0.67matched
83capture01a1a245-1bc9-75db-a37b-2eba47118ae3€15.00€0.26matched
85capture01a1a245-488a-7f2c-8a5b-635402815603€15.00€0.26matched
86capture01a1a245-6bae-7717-9fd6-b07804290d53€15.00€0.26matched
87capture01a1a245-8569-753b-b56c-72ae75f21290€35.00€0.50matched
88capture01a1a245-a825-7406-b1a0-1750ad3a30d3€9.00€0.19matched
89capture01a1a245-ca7e-7079-b1c8-84f865468c18€9.00€0.19matched
90capture01a1a245-cf8d-728b-97ba-b22ed120de82€9.00€0.19matched
91capture01a1a246-2712-73da-8ae1-b0a8811f5e07€9.00€0.19matched
92capture01a1a246-3772-7897-a6cf-485d588af791€24.00€0.37matched
93capture01a1a246-6bd1-7b0b-bf30-48733bd9b42e€24.00€0.37matched
94capture01a1a246-a95e-736d-9576-c33fd5179897€49.00€0.67matched
95capture01a1a246-b453-72a3-a073-2107c888d776€24.00€0.37matched
96capture01a1a246-baa9-74a9-9d58-e0c8c03fd086€9.00€0.19matched
97capture01a1a246-cf21-70a4-a757-3323693fe2ee€35.00€0.50matched
98capture01a1a246-fd0b-7188-a039-fd66dde5a2f4€9.00€0.19matched
99capture01a1a247-115d-7739-a2e1-dcbdd05a7596€24.00€0.37matched
100capture01a1a247-16b2-7f07-8a1a-292002d0d10d€35.00€0.50matched
101capture01a1a247-41d4-7650-add3-0178b053cb79€35.00€0.50matched
102capture01a1a247-9ff5-7ffb-a179-c244df288af7€35.00€0.50matched
103capture01a1a247-b19d-7d38-97f8-63db1a05b2e9€49.00€0.67matched
104capture01a1a247-b1b3-71b4-a011-5f21ed027509€24.00€0.37matched
105capture01a1a247-c4de-796a-85fc-bc12308bc74c€24.00€0.37matched
106capture01a1a247-e121-767d-adfb-99dde4019527€9.00€0.19matched
107capture01a1a247-f98d-7109-af24-7336a58df42a€24.00€0.37matched
108capture01a1a248-1838-7c50-9e11-619651de1c32€15.00€0.26matched