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

6 Nov, 04:40

Gross

€3,152.00

PSP fee

€50.28

Net to the bank

€3,101.72

Settlement journal

#409984

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1af29-08ca-751e-88e9-479b47ea6b6a is already settled by stl_EUR_2989900 line 23
  • duplicate linethe file lists it twicecapture:01a1af2a-477e-7a02-8918-f1d475136ad3 is already settled by stl_EUR_2989900 line 42
  • missing linein the books, not in the filecapture:01a1af2e-c235-7308-bcff-a7e83d8cd6dc is in no file
LineKindReferenceGrossFeeStatus
24capture01a1af29-0906-77d2-99f9-f45f8158ff6d€49.00€0.67duplicate line
43capture01a1af2a-4798-708e-a2d0-7fc9d6c88f69€15.00€0.26duplicate line
1capture01a1af20-dbb1-73e1-bf6a-786dd35b3bb8€15.00€0.26matched
2capture01a1af25-50d8-755f-a2f4-7c893307299d€35.00€0.50matched
3capture01a1af25-9002-7f51-a192-5c7c50285a57€35.00€0.50matched
4capture01a1af26-faaa-744d-b8f9-4d7d6405799c€9.00€0.19matched
5capture01a1af27-1f34-7889-a920-5a890d48ede2€35.00€0.50matched
6capture01a1af28-23f0-79bb-9550-94b60b4afd15€49.00€0.67matched
7refund01a1af28-3598-73de-9753-60bfb4e57d08-€4.00€0.00matched
8capture01a1af28-3ef7-74c0-ae37-5aed79340228€9.00€0.19matched
9capture01a1af28-47f9-7134-9880-a79f01a9c350€9.00€0.19matched
10capture01a1af28-4e64-77e2-b27a-d19e22900efd€49.00€0.67matched
11capture01a1af28-4e85-76e7-bbb9-4bee0f6a4f68€35.00€0.50matched
12capture01a1af28-5297-7820-8ca2-1e7635f36438€35.00€0.50matched
13capture01a1af28-6219-7e50-837b-efe0b265798c€9.00€0.19matched
14capture01a1af28-72b3-743a-975a-cf90daa618dc€35.00€0.50matched
15capture01a1af28-8c10-7d68-9c2f-1cd1ccb1ec33€15.00€0.26matched
16refund01a1af28-93cb-7b86-b3e4-3922f6cda675-€35.00€0.00matched
17capture01a1af28-a4a4-73e1-9641-7fdee51252ec€35.00€0.50matched
18capture01a1af28-bfdf-7350-a524-b014f335db6d€35.00€0.50matched
19capture01a1af28-c220-79a6-a615-407ba3f25c0c€35.00€0.50matched
20refund01a1af28-da5d-796e-9814-8115946b9d64-€14.00€0.00matched
21capture01a1af28-df61-7a43-af7b-e4aab576aaa3€35.00€0.50matched
22capture01a1af28-eb10-7fb5-a450-8531ae5b9b7b€24.00€0.37matched
23capture01a1af29-0906-77d2-99f9-f45f8158ff6d€49.00€0.67matched
25capture01a1af29-0dc7-72c1-81ac-47da39ccb6db€15.00€0.26matched
26capture01a1af29-1928-7be8-8c91-c30cdbf5b254€24.00€0.37matched
27capture01a1af29-2211-7e78-930e-3edc74417f61€9.00€0.19matched
28capture01a1af29-4401-7192-a1f1-0917a0a8884e€49.00€0.67matched
29capture01a1af29-6e8a-7b18-986c-50af3e3e66cf€15.00€0.26matched
30refund01a1af29-7108-7191-b9fa-032d5253bf71-€21.00€0.00matched
31capture01a1af29-7f0f-7160-a508-cf5a8fc9f6b8€24.00€0.37matched
32capture01a1af29-a1a7-7ed0-863c-5218a6c29925€35.00€0.50matched
33capture01a1af29-adfe-7e40-9596-0dffd4ecac52€49.00€0.67matched
34capture01a1af29-e2e7-7678-b927-893712b82ea3€9.00€0.19matched
35capture01a1af29-f207-7cd6-b8ca-973321177061€24.00€0.37matched
36capture01a1af29-f3b7-75ba-b1b4-d4df368bd78f€15.00€0.26matched
37capture01a1af2a-16b6-79ce-ac2f-babcf3f4cfb0€24.00€0.37matched
38capture01a1af2a-1d2b-7886-8fec-88a4c40d8e43€24.00€0.37matched
39capture01a1af2a-20b3-75b1-be4b-486d6645f8d4€15.00€0.26matched
40capture01a1af2a-2690-77ad-ae0a-5b6e436c7512€9.00€0.19matched
41capture01a1af2a-3290-701f-b64a-b7628611a8c7€24.00€0.37matched
42capture01a1af2a-4798-708e-a2d0-7fc9d6c88f69€15.00€0.26matched
44refund01a1af2a-7736-713f-916c-654c74baa684-€11.00€0.00matched
45capture01a1af2a-8535-74fe-87b0-f5dbce5b1933€49.00€0.67matched
46capture01a1af2a-9a26-7c46-9e05-71e5008d14aa€35.00€0.50matched
47capture01a1af2a-a07c-72ee-94e3-a7e2c976ea5f€24.00€0.37matched
48capture01a1af2a-a66f-772e-8134-3bbab63f0fc9€9.00€0.19matched
49capture01a1af2a-c347-7468-8e13-c28c418fb0ed€49.00€0.67matched
50capture01a1af2a-cbd0-7fd9-96b0-eaf83b696327€15.00€0.26matched
51refund01a1af2a-d26f-773c-8583-7ebe964f2616-€36.00€0.00matched
52capture01a1af2a-e5ff-72cf-85d7-8a8b473bf234€49.00€0.67matched
53capture01a1af2a-e6a9-733e-8a84-4e48f68d47e0€49.00€0.67matched
54capture01a1af2a-fc62-7646-94c6-b841c1dca76d€49.00€0.67matched
55capture01a1af2b-06ac-778e-973e-17c19f6efb03€24.00€0.37matched
56capture01a1af2b-0ca0-787b-9e37-24ca3ddd04e6€24.00€0.37matched
57capture01a1af2b-110e-799d-b9c0-e987c7beaa62€35.00€0.50matched
58refund01a1af2b-5b5a-7165-8e9c-8eab2c936913-€10.00€0.00matched
59capture01a1af2b-72d3-706f-9a37-c13d72217a1e€24.00€0.37matched
60capture01a1af2b-765d-700d-9686-be24fc5a2471€24.00€0.37matched
61capture01a1af2b-81aa-738a-98ae-1871bbf6b0a6€15.00€0.26matched
62capture01a1af2b-a713-708e-8705-3967e830c20f€49.00€0.67matched
63refund01a1af2b-d3a9-7c1b-9d9f-6b96871830c8-€13.00€0.00matched
64capture01a1af2b-d61a-7224-8f2d-f2414ee21596€35.00€0.50matched
65capture01a1af2c-0590-726e-b399-34328ce5f397€9.00€0.19matched
66capture01a1af2c-0a50-7c1b-bc64-a741817e6422€35.00€0.50matched
67capture01a1af2c-19cb-76ab-8bdc-f5c3b822f3c8€49.00€0.67matched
68refund01a1af2c-40a5-7064-93ca-5008b719709d-€25.00€0.00matched
69capture01a1af2c-4372-7900-81c7-76bd318a122f€35.00€0.50matched
70capture01a1af2c-4db2-7533-b368-cdd4fbf113c2€15.00€0.26matched
71capture01a1af2c-5f94-764b-ae08-4f0763590659€9.00€0.19matched
72capture01a1af2c-672b-7904-8c58-1f142fe3a85c€24.00€0.37matched
73capture01a1af2c-6e99-79f6-9e7f-d97e296916e4€49.00€0.67matched
74capture01a1af2c-acb2-7279-be8c-48e8cc2f93a6€24.00€0.37matched
75capture01a1af2c-afdf-78a9-a1a2-21114640675b€24.00€0.37matched
76capture01a1af2c-d622-7fce-be00-b103bf365730€35.00€0.50matched
77capture01a1af2c-f75f-716c-953f-8c95d829b238€9.00€0.19matched
78capture01a1af2c-fb77-770c-9ef8-d83fe1540459€24.00€0.37matched
79capture01a1af2d-0b39-784f-87d0-280e905d93fc€35.00€0.50matched
80capture01a1af2d-2242-76c4-b449-8d3b7ca7b4ce€24.00€0.37matched
81capture01a1af2d-2a28-7b08-bb3b-cd6363fb019d€24.00€0.37matched
82capture01a1af2d-3dc3-75e0-b7a1-1ed83f9973f6€49.00€0.67matched
83capture01a1af2d-58cd-76cd-83d4-7928d4fd3155€49.00€0.67matched
84capture01a1af2d-6fd4-7f47-82f4-ea958674682c€49.00€0.67matched
85capture01a1af2d-ba98-727d-9dcf-8408a4d2cb81€15.00€0.26matched
86capture01a1af2d-c74c-7a33-8ff2-ff8cc5edc1d2€9.00€0.19matched
87capture01a1af2d-cea2-7012-8e13-c5296d4bbe46€35.00€0.50matched
88capture01a1af2d-dfc1-7425-af90-f208ff7a6da5€35.00€0.50matched
89capture01a1af2d-e6f6-7556-b512-9a610456a0bb€15.00€0.26matched
90capture01a1af2d-ed94-7581-8b0d-5f718db52545€9.00€0.19matched
91capture01a1af2d-f299-7ebf-9240-d99d81eff3a0€49.00€0.67matched
92capture01a1af2e-0bd7-7bca-8ad1-ee51c54197ef€35.00€0.50matched
93capture01a1af2e-242c-75b0-b4f2-ac1d03e50c53€15.00€0.26matched
94capture01a1af2e-2a1b-7895-83db-37cd9cd70c36€9.00€0.19matched
95capture01a1af2e-3779-760e-8c65-f293e74f83c7€15.00€0.26matched
96capture01a1af2e-3dd5-759e-bc99-2b570ae9b442€15.00€0.26matched
97refund01a1af2e-53d2-7d68-b0a0-6b13d8c57c4f-€21.00€0.00matched
98capture01a1af2e-6460-75bb-ac78-58fb2c664880€49.00€0.67matched
99capture01a1af2e-525f-7cea-820c-0afa91d36b1f€24.00€0.37matched
100capture01a1af2e-ab3a-7926-84e0-3639066f883e€35.00€0.50matched
101capture01a1af2e-e6c4-701b-90b5-2199b428d25f€35.00€0.50matched
102capture01a1af2e-f344-79f1-8db9-ddd06c6683cb€49.00€0.67matched
103capture01a1af2e-f965-7603-8c03-d8fce7b1630a€49.00€0.67matched
104capture01a1af2f-1682-7de0-bc57-e19c20fc09fa€35.00€0.50matched
105refund01a1af2f-2b92-71b2-bf90-b5ab3070695d-€3.00€0.00matched
106capture01a1af2f-3125-759b-847b-c7ebf841a1cc€49.00€0.67matched
107refund01a1af2f-41fc-77f5-ab5f-6c35ee61f704-€8.00€0.00matched
108capture01a1af2f-6282-7968-89bf-16f7a1459742€24.00€0.37matched
109capture01a1af2f-6a0b-7a5a-8362-73767593d10d€24.00€0.37matched
110capture01a1af2f-7178-7ca5-bfa5-c541d8684591€24.00€0.37matched
111capture01a1af2f-85e5-721f-b9a8-abe7d050651c€35.00€0.50matched
112capture01a1af2f-a06c-7115-9708-b06f780cea6e€15.00€0.26matched
113capture01a1af2f-aacd-7185-af2b-587f4b02c379€15.00€0.26matched
114capture01a1af2f-b6a9-7fcf-9e95-6b385aa0d904€24.00€0.37matched
115refund01a1af2f-c29f-78d6-84d9-d79dce1bd71c-€12.00€0.00matched
116capture01a1af2f-e112-7279-b919-39e3da22f696€9.00€0.19matched
117capture01a1af2f-ee0a-782a-86ef-99d20b84abcf€15.00€0.26matched
118capture01a1af2f-f3bf-70e3-8e7b-d599fd6c988a€49.00€0.67matched
119capture01a1af2f-ff9f-7170-82f2-7d88bbebaecb€35.00€0.50matched
120capture01a1af30-0160-74bf-89f8-7dd13f88579d€15.00€0.26matched
121capture01a1af30-0777-7e1d-a5f3-e56539df6168€9.00€0.19matched
122refund01a1af30-0fa5-751b-966f-0807145d4dba-€7.00€0.00matched
123capture01a1af30-100f-7431-93c2-63ca0307dcb4€15.00€0.26matched
124capture01a1af30-1a9e-7a64-91d7-f1a5d3eb0ceb€15.00€0.26matched
125capture01a1af30-2a17-7350-bfa4-20e7481d513a€15.00€0.26matched
126capture01a1af30-4320-7f40-9756-e07afb7f4682€49.00€0.67matched
127capture01a1af30-6572-7367-87f9-c84ff8db827f€49.00€0.67matched
128capture01a1af30-6936-75b0-8134-6159dfc5a3b7€15.00€0.26matched
129capture01a1af30-6e2a-7268-ab2a-c4f4c4dffbc5€49.00€0.67matched
130capture01a1af30-bf39-7e9c-a5e9-15ed3d014eb5€9.00€0.19matched
131capture01a1af30-d843-70a0-ab09-f24ff01d5831€9.00€0.19matched
132capture01a1af30-e425-71ed-ae12-0ef39b9290e3€35.00€0.50matched
133capture01a1af31-27be-79d0-a06d-ad3662483770€15.00€0.26matched
134capture01a1af31-2868-72b9-b960-5fe6e0105b9b€15.00€0.26matched
135capture01a1af31-2ece-717c-8299-225a537d526b€49.00€0.67matched