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, 07:50

Gross

€2,641.00

PSP fee

€42.32

Net to the bank

€2,598.68

Settlement journal

#412428

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1afd7-9e11-78b2-9232-491121c35d05 is already settled by stl_EUR_2989919 line 18
  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
LineKindReferenceGrossFeeStatus
19capture01a1afd7-ab2c-7e6f-b7c3-030abdd29446€9.00€0.19duplicate line
87capture01a1afdc-89b0-7351-a6f5-628b9234e0e4€35.00€0.53fee difference
1capture01a1afd1-ac38-7eb9-a4ef-8567ee47eda7€35.00€0.50matched
2capture01a1afd4-7c8c-7e80-b8e9-8b5de278fcf7€35.00€0.50matched
3capture01a1afd4-bdba-7231-a9cc-0279e757aa7d€9.00€0.19matched
4capture01a1afd6-12cb-74bb-b495-92aae1d19a50€24.00€0.37matched
5capture01a1afd6-1cd5-7781-afdd-bc4f4b6a9ee9€9.00€0.19matched
6capture01a1afd6-3f33-7648-a1f7-33cfe94bb0e1€49.00€0.67matched
7capture01a1afd6-5014-7f9b-a5fa-5fca1832b618€49.00€0.67matched
8capture01a1afd6-55ee-7a8f-99e9-c68252062b50€9.00€0.19matched
9capture01a1afd6-7240-7aa2-807d-f1b8a1296aae€24.00€0.37matched
10capture01a1afd6-7f55-71b2-a16b-6684e802f539€49.00€0.67matched
11capture01a1afd6-9c42-7b40-ac43-8ed3eaf74f24€24.00€0.37matched
12capture01a1afd6-c413-7351-ad00-11a16fd2cbb2€49.00€0.67matched
13capture01a1afd6-d18d-7218-9908-3ff0613f9cd1€9.00€0.19matched
14capture01a1afd7-0cb2-792e-90f9-351d597658b5€9.00€0.19matched
15capture01a1afd7-2115-7c5e-a295-79e9c7bbcd07€35.00€0.50matched
16capture01a1afd7-65bd-7a1e-85ad-21570e428733€9.00€0.19matched
17capture01a1afd7-9c05-74d7-95ad-106c3d3db607€15.00€0.26matched
18capture01a1afd7-ab2c-7e6f-b7c3-030abdd29446€9.00€0.19matched
20capture01a1afd7-be1e-76c3-b5e4-00c61e661ae1€49.00€0.67matched
21capture01a1afd7-bee8-7986-9f12-41a36da26cf5€35.00€0.50matched
22capture01a1afd7-c12a-766a-bffb-9d1229f16ae0€49.00€0.67matched
23capture01a1afd7-c80f-7e87-83d1-e7a2570a05f6€49.00€0.67matched
24capture01a1afd7-e8a1-76f0-8f46-126438094652€35.00€0.50matched
25capture01a1afd8-153d-7a6d-b1c0-b64eea7e8dce€35.00€0.50matched
26refund01a1afd8-1e83-7435-99f4-8799d554080f-€18.00€0.00matched
27capture01a1afd8-1fad-7dc5-acce-c2462090cf83€35.00€0.50matched
28capture01a1afd8-21ea-73fe-a9cc-f6a47e26bff9€15.00€0.26matched
29capture01a1afd8-25c1-70ed-87d1-11b174ab1848€49.00€0.67matched
30capture01a1afd8-3bbb-77ed-99ba-9bdff162e424€35.00€0.50matched
31capture01a1afd8-5bed-714e-a7e3-2a7b17668b49€15.00€0.26matched
32capture01a1afd8-6ad1-7c2a-96ab-5db5d58de815€49.00€0.67matched
33capture01a1afd8-89f3-7922-af5d-abcd38282344€35.00€0.50matched
34capture01a1afd8-a367-75da-8038-52cb38b96498€35.00€0.50matched
35capture01a1afd8-ac10-703d-911c-a0628567d746€24.00€0.37matched
36capture01a1afd8-ae72-7261-af37-001335ec711d€9.00€0.19matched
37capture01a1afd8-af13-7da0-ae0d-df16f2e70645€49.00€0.67matched
38refund01a1afd8-bbc0-721d-8a37-30c9ee4fbc63-€32.00€0.00matched
39refund01a1afd8-ec11-73c6-a2c7-3403407e8d9e-€25.00€0.00matched
40capture01a1afd8-eec2-73ff-9a6b-3eaa5ff42c07€35.00€0.50matched
41capture01a1afd9-0449-7475-ba8c-8e99a9f54374€35.00€0.50matched
42capture01a1afd9-0812-73cf-b7b7-56814c229675€9.00€0.19matched
43capture01a1afd9-0882-7fe9-93e5-d94820eba09f€49.00€0.67matched
44refund01a1afd9-08e7-7665-a042-1efd8f3ecb0b-€3.00€0.00matched
45capture01a1afd9-0a19-7cf6-896d-fb11a6a1b8a4€24.00€0.37matched
46capture01a1afd9-22b1-75ff-981e-d0cf5326f8c0€24.00€0.37matched
47capture01a1afd9-2796-7a2a-b6f7-b9801a7fd7f4€15.00€0.26matched
48capture01a1afd9-2d5b-76d1-83ab-7160888da473€9.00€0.19matched
49capture01a1afd9-311d-7f91-9b30-f0e46a09cafe€49.00€0.67matched
50capture01a1afd9-613b-7a34-a2eb-605804f9845f€15.00€0.26matched
51capture01a1afd9-6186-77ac-9400-45f41c2998c4€15.00€0.26matched
52capture01a1afd9-89bf-746c-825d-eed24ef761dd€49.00€0.67matched
53capture01a1afd9-8fab-7f88-bd8f-be26dff5e530€35.00€0.50matched
54capture01a1afd9-bb25-7662-937a-c9148a4f2de4€35.00€0.50matched
55capture01a1afd9-bbec-788b-a845-d984371c3f85€24.00€0.37matched
56capture01a1afd9-ed34-7fb1-810f-ef3c8b35b9a0€15.00€0.26matched
57capture01a1afd9-f53e-7c6d-97a3-a3cabb71b8b3€49.00€0.67matched
58capture01a1afda-2410-7a55-a945-ccd80df7da4c€24.00€0.37matched
59capture01a1afda-68f1-7300-980b-a9c59cd03530€35.00€0.50matched
60capture01a1afda-732a-716e-930e-4801bf66666b€15.00€0.26matched
61capture01a1afda-75c0-7676-ae07-b9b207e2a386€24.00€0.37matched
62capture01a1afda-76d1-7485-b913-28c7244b4896€9.00€0.19matched
63capture01a1afda-9240-792b-a6b0-0e5a7d2f3a3f€15.00€0.26matched
64capture01a1afda-b621-7014-ba58-5ea259edbc4b€24.00€0.37matched
65capture01a1afda-b828-7f28-95a7-f5944b918ff4€49.00€0.67matched
66capture01a1afda-ceee-70ed-a564-045ca1d5b9a9€9.00€0.19matched
67capture01a1afda-e7d4-7801-a3a1-7024aae31f43€49.00€0.67matched
68capture01a1afda-f53d-7886-a3d9-c266f77a6d11€9.00€0.19matched
69capture01a1afdb-0441-72b1-a0b3-c47fac71db23€9.00€0.19matched
70capture01a1afdb-3616-75c6-969e-9f2372955150€35.00€0.50matched
71capture01a1afdb-724a-71e6-ab99-70452521b24a€24.00€0.37matched
72capture01a1afdb-86c4-78aa-9173-a0ed5e13f259€24.00€0.37matched
73capture01a1afdb-af54-77fa-8f7c-7193395df6e6€24.00€0.37matched
74capture01a1afdb-ba54-74d6-8904-c4f54841af36€15.00€0.26matched
75capture01a1afdb-c2c6-7440-83d1-d0a0cdd192c9€9.00€0.19matched
76capture01a1afdb-c6d4-78b8-9cf3-f2187ce4b6dd€49.00€0.67matched
77capture01a1afdb-d797-788a-8e45-67f4a7989df9€9.00€0.19matched
78capture01a1afdb-efe0-732a-a692-57086a7fc974€35.00€0.50matched
79refund01a1afdb-f8e8-7ce8-8747-04df32082018-€36.00€0.00matched
80capture01a1afdb-fbe2-7bbe-8dbb-242adcb749bc€15.00€0.26matched
81capture01a1afdc-0116-7bde-9aca-0ac5b42c0908€24.00€0.37matched
82capture01a1afdc-3159-7179-aa24-4221a5c86ac4€24.00€0.37matched
83capture01a1afdc-54ff-75dc-8cae-96d545755e59€35.00€0.50matched
84capture01a1afdc-6748-73f9-afc9-8ae3f18c164f€35.00€0.50matched
85capture01a1afdc-682a-7a34-bce3-3a2926a7eedc€15.00€0.26matched
86capture01a1afdc-774c-7845-ac5c-a5b19e60c076€9.00€0.19matched
88capture01a1afdc-98e2-7b15-8d5b-de7568041d21€9.00€0.19matched
89capture01a1afdc-9a3f-785c-96de-0e1475a25c0c€35.00€0.50matched
90capture01a1afdc-c2a4-713a-a7e3-9b880c352069€15.00€0.26matched
91capture01a1afdc-c8b2-7017-b35f-933854018934€35.00€0.50matched
92refund01a1afdc-d893-7a64-b97d-c01ac3127506-€31.00€0.00matched
93capture01a1afdc-da1a-7b6a-87f1-95420b7c9958€9.00€0.19matched
94capture01a1afdc-ed16-71e4-be67-9963e4252261€24.00€0.37matched
95capture01a1afdc-f7a9-746d-9f91-cc6d2a7bd75c€49.00€0.67matched
96refund01a1afdd-22ec-78fa-8dbf-a851463e2be8-€5.00€0.00matched
97capture01a1afdd-4622-7ba2-9bab-9c6c09cfcb36€49.00€0.67matched
98capture01a1afdd-4ef1-78e8-b5bd-edc256f9179d€49.00€0.67matched
99capture01a1afdd-5f98-7777-81f4-6a148c7fa7c8€15.00€0.26matched
100capture01a1afdd-66c2-7d96-92a0-079b3396c86a€9.00€0.19matched
101capture01a1afdd-6f6e-7f97-9220-bbdca1b01f8a€35.00€0.50matched
102capture01a1afdd-733c-7664-af53-179207b198de€24.00€0.37matched
103refund01a1afdd-7b39-70d2-8341-36e539686060-€43.00€0.00matched
104capture01a1afdd-7e2a-7794-9902-6a05fe3607e7€49.00€0.67matched
105capture01a1afdd-e70b-7477-8037-17731a616feb€49.00€0.67matched
106capture01a1afdd-fc78-70e5-9f67-c798d26fef77€35.00€0.50matched
107capture01a1afde-12f3-7da4-9684-b02f47bfb723€24.00€0.37matched
108capture01a1afde-4ed3-721a-973d-4df9df0a4a37€15.00€0.26matched
109capture01a1afde-7de7-71b4-96d1-66d7bc5adc69€35.00€0.50matched
110capture01a1afde-93f2-720d-bcca-5d86f6779b3d€35.00€0.50matched