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

2 Nov, 11:50

Gross

€3,173.00

PSP fee

€49.16

Net to the bank

€3,123.84

Settlement journal

#342338

Every line paired with the books, and every capture and refund of the day is in the file.

LineKindReferenceGrossFeeStatus
1capture01a19c0f-8ad0-744d-b413-755d207b5bb8€15.00€0.26matched
2capture01a19c10-e07f-7b97-96e0-4700400496a5€35.00€0.50matched
3capture01a19c12-5b01-7941-9d57-ace3de74c6c7€15.00€0.26matched
4capture01a19c18-6035-7489-9a4e-9be9ef0bd63c€24.00€0.37matched
5capture01a19c18-66a5-7b35-9a74-bfa859c3682d€24.00€0.37matched
6capture01a19c18-6778-73a7-b5fb-abeda64761e3€35.00€0.50matched
7capture01a19c18-8149-7095-9704-c47dc238bdde€9.00€0.19matched
8capture01a19c18-9a10-7b83-90ba-d906cb5cd906€49.00€0.67matched
9capture01a19c18-8355-723b-b036-e3133e249850€9.00€0.19matched
10capture01a19c18-a9b4-7bbd-82d3-75750fd6732e€35.00€0.50matched
11capture01a19c19-199e-7cc3-82e8-c4e22cedd409€9.00€0.19matched
12capture01a19c19-2537-778d-b919-9a5b03e72a5a€49.00€0.67matched
13capture01a19c19-26d8-70dc-ace4-2bb382e6646f€49.00€0.67matched
14capture01a19c19-2bb3-7960-adda-2a8e681c6932€35.00€0.50matched
15capture01a19c19-3f15-7a95-96a5-1f687ac46be3€49.00€0.67matched
16capture01a19c19-4ac7-7e9f-8af9-70bc18d40f59€35.00€0.50matched
17capture01a19c19-5eff-7529-a41b-5331579039ac€15.00€0.26matched
18capture01a19c19-66d4-7a2e-b437-6e94a52dc353€35.00€0.50matched
19capture01a19c19-790c-73d0-9e4a-03b64a257c4f€35.00€0.50matched
20capture01a19c19-8dbe-7851-940a-897df2cf78b3€24.00€0.37matched
21capture01a19c19-99ea-7a7c-8dfd-57581bffa212€15.00€0.26matched
22refund01a19c19-9e0e-723a-8d3f-23c9a927563a-€19.00€0.00matched
23capture01a19c19-e971-7205-8152-58108ae412eb€15.00€0.26matched
24capture01a19c1a-2bd4-7cfa-a399-f39266ec06c0€24.00€0.37matched
25capture01a19c1a-3b7c-7b8e-9b3e-96de16b8c0df€24.00€0.37matched
26capture01a19c1a-4c9d-7fff-ae1c-9913bdc1fc29€9.00€0.19matched
27capture01a19c1a-50da-7908-927a-b511ea6e7130€15.00€0.26matched
28capture01a19c1a-6ac8-7d14-9468-e1bb9fd49bf5€49.00€0.67matched
29capture01a19c1a-8330-7c5e-8512-2b1bea1c323e€49.00€0.67matched
30capture01a19c1a-9275-70b6-a012-2c538d6c909f€49.00€0.67matched
31capture01a19c1a-9cb8-773c-9bf6-55c5c2c478ef€35.00€0.50matched
32capture01a19c1a-b737-72f3-ae06-508abbe3f48d€24.00€0.37matched
33capture01a19c1a-bc3b-7018-b1cc-c5c94deaa75f€35.00€0.50matched
34capture01a19c1a-c3d3-77c1-bc19-bf6a43e69b79€15.00€0.26matched
35refund01a19c1a-cbd7-7a85-9cf5-b3295bff0b08-€35.00€0.00matched
36capture01a19c1a-d7d6-7485-bac5-243d7b835900€15.00€0.26matched
37capture01a19c1a-cfbf-71c4-87ff-ca391c5f5747€9.00€0.19matched
38capture01a19c1a-e290-7740-98a6-d5564c8d0437€49.00€0.67matched
39capture01a19c1a-f82c-7834-84d3-9a0b6ef2fd19€35.00€0.50matched
40capture01a19c1b-225b-702b-b0af-fcfe2d75042f€9.00€0.19matched
41refund01a19c1b-355e-765d-8fd1-facbe30247f0-€19.00€0.00matched
42capture01a19c1b-6a82-72ae-b436-0e44421f2e76€49.00€0.67matched
43capture01a19c1b-7ec0-7dde-9801-049a86168a2a€35.00€0.50matched
44capture01a19c1b-8b4d-7620-b918-9c6c5bb74533€9.00€0.19matched
45capture01a19c1b-a0b8-7751-8c98-8bd29cdf70c5€24.00€0.37matched
46capture01a19c1b-acd1-7ce7-baeb-d140e3138c18€35.00€0.50matched
47capture01a19c1b-c203-7c57-84f7-663d71037514€15.00€0.26matched
48capture01a19c1b-c6fa-763b-96a4-f5a52c970196€24.00€0.37matched
49capture01a19c1b-d535-7d3b-b8b0-24390938db27€15.00€0.26matched
50capture01a19c1b-ec3a-76cb-a928-ad9144634fc8€24.00€0.37matched
51capture01a19c1c-100d-7fe3-bf7e-951b3bd83d9f€9.00€0.19matched
52capture01a19c1c-3335-762d-b7d2-859c205db8f6€49.00€0.67matched
53capture01a19c1c-427a-7331-9a9e-09690bdf8763€49.00€0.67matched
54capture01a19c1c-6a20-7a7d-b9b8-eac9218bc583€49.00€0.67matched
55capture01a19c1c-6d22-7da4-a125-749b9e866919€9.00€0.19matched
56capture01a19c1c-7dad-76fa-b3bf-5f522fb8ebfa€49.00€0.67matched
57capture01a19c1c-8535-7c47-8b4a-2def24459079€24.00€0.37matched
58capture01a19c1c-8662-7e6d-aba0-dd7130b9e79b€15.00€0.26matched
59capture01a19c1c-cbe4-77d7-b95a-58e197ea2cad€49.00€0.67matched
60capture01a19c1c-f60f-7049-86f5-a0a1521a6f6a€24.00€0.37matched
61capture01a19c1c-f844-7fb3-871b-cca452d7aedd€24.00€0.37matched
62capture01a19c1c-f9b5-7fe4-9657-f344b643bd1c€15.00€0.26matched
63capture01a19c1d-0342-7e14-9de6-125fd601f715€49.00€0.67matched
64capture01a19c1d-0dfe-79aa-b798-035b4da7f1be€35.00€0.50matched
65capture01a19c1d-145f-70e6-858d-4ede369621d9€35.00€0.50matched
66capture01a19c1d-154d-7f51-b9b4-89935999685e€35.00€0.50matched
67capture01a19c1d-1da2-70bf-bcb8-ed1b24410bf2€24.00€0.37matched
68capture01a19c1d-556d-79c4-9a5a-be2bf3a9418d€35.00€0.50matched
69capture01a19c1d-74d0-73a4-b247-633f6f2251df€15.00€0.26matched
70capture01a19c1d-a00e-7f25-8cfb-243db48f38e9€15.00€0.26matched
71capture01a19c1d-aada-7946-bce0-6d663c7d4567€9.00€0.19matched
72capture01a19c1d-b968-7835-aa57-6d8a01688242€9.00€0.19matched
73capture01a19c1d-dd73-70ef-bd3e-7a89772e15ee€24.00€0.37matched
74capture01a19c1e-1a52-7fae-a715-8e0002bd419a€49.00€0.67matched
75capture01a19c1e-2ae1-7834-8ff2-f1d7f04ff3d9€35.00€0.50matched
76capture01a19c1e-8603-72a1-b150-a54ee3d05637€35.00€0.50matched
77capture01a19c1e-861e-7084-b8b8-57e795df6cde€24.00€0.37matched
78capture01a19c1e-8dc7-7bfa-96d7-355a10ab9949€15.00€0.26matched
79capture01a19c1e-b156-71d7-b3b3-6050ee696d8b€24.00€0.37matched
80capture01a19c1e-b3d8-7577-8ab1-457b0deb8908€35.00€0.50matched
81capture01a19c1e-c22e-77e1-a53a-6ef4d2f71c44€9.00€0.19matched
82capture01a19c1e-cae4-7dc4-8106-d96ab1b14906€24.00€0.37matched
83capture01a19c1e-d574-7da7-91c2-cd3880ed4da7€15.00€0.26matched
84capture01a19c1e-e1ea-7dc7-984f-2a34977c3582€9.00€0.19matched
85capture01a19c1e-e6fd-79fe-b53e-1123aa40c0e4€24.00€0.37matched
86refund01a19c1e-ebfd-7c07-aa3d-2db684b87d20-€20.00€0.00matched
87capture01a19c1f-1124-795c-aa25-5ce869d4b63d€15.00€0.26matched
88capture01a19c1f-2cc8-75f8-99b6-918ee2a60594€49.00€0.67matched
89capture01a19c1f-5674-7e35-a12c-e32d53137345€15.00€0.26matched
90capture01a19c1f-5933-7ed8-b3ff-c1096260af9a€49.00€0.67matched
91capture01a19c1f-6390-7336-9e24-a956724212aa€15.00€0.26matched
92capture01a19c1f-63b9-735a-a231-e510130837d3€15.00€0.26matched
93capture01a19c1f-7845-7fd5-a0b1-ecf7fbf7d20c€9.00€0.19matched
94capture01a19c1f-bc3c-70f5-8ec8-a280b68e07b6€49.00€0.67matched
95capture01a19c1f-e340-7176-9c53-ff8f43bc3d82€35.00€0.50matched
96capture01a19c1f-e514-7df5-a2cf-69e982246bfe€15.00€0.26matched
97capture01a19c1f-e859-74df-8816-569858f2d1b4€49.00€0.67matched
98capture01a19c1f-f22c-7e10-bd71-c9074cbf94bf€35.00€0.50matched
99capture01a19c20-0bf6-7f64-acb8-11fad59a7930€9.00€0.19matched
100capture01a19c20-1a0b-768e-bae0-04173e0ace6f€35.00€0.50matched
101capture01a19c20-1f5e-77ea-b6ad-d884e71b90e5€49.00€0.67matched
102capture01a19c20-2031-7601-aef7-2399ed3f49a7€9.00€0.19matched
103refund01a19c20-5ccc-7ecb-aa5f-25de4b5385c1-€9.00€0.00matched
104capture01a19c20-5dee-7561-b43f-ba334cdfbd03€49.00€0.67matched
105capture01a19c20-66b3-7956-a4b5-e22993662dbf€15.00€0.26matched
106capture01a19c20-67e8-7f1b-bb5d-34871cf0803c€49.00€0.67matched
107capture01a19c20-7386-79c4-86af-2eec86a455f6€24.00€0.37matched
108capture01a19c20-8834-7fd7-88de-a4ee8e7e83ce€35.00€0.50matched
109capture01a19c20-9e76-78ce-90a4-62b54bc4ac55€24.00€0.37matched
110capture01a19c20-b3af-727f-b195-9a6bf7919d52€35.00€0.50matched
111refund01a19c20-c052-7650-aa51-0eb4565712ab-€17.00€0.00matched
112capture01a19c20-c152-7e4c-888f-83d17cc510af€15.00€0.26matched
113capture01a19c20-c8f2-7bfb-a5dc-e9821c77c0c6€15.00€0.26matched
114capture01a19c20-cb74-7cc7-b2bf-e6627e323557€49.00€0.67matched
115capture01a19c20-e272-74ca-8f0b-0f5837b9cf5d€49.00€0.67matched
116capture01a19c20-ffe9-7c78-afe2-33b638f0cfbb€35.00€0.50matched
117capture01a19c21-0081-75cc-a712-18f5e792f8a0€15.00€0.26matched
118capture01a19c21-00c4-73a9-b0dd-325d6ef5e0fd€9.00€0.19matched
119capture01a19c21-15cf-7bd3-91ff-8f607502f076€49.00€0.67matched
120capture01a19c21-1993-7feb-8185-530c24f79b90€35.00€0.50matched
121capture01a19c21-1d0e-7c90-96b7-0d6a2f2b3b35€9.00€0.19matched
122capture01a19c21-216d-77e7-a613-c2fc129317d1€9.00€0.19matched
123capture01a19c21-4a1f-7aa3-8558-1f432a7679fc€9.00€0.19matched
124capture01a19c21-57f2-71ab-a8f5-b153fb6b8d68€24.00€0.37matched
125capture01a19c21-6b25-7c4a-94c9-c601f2973eb3€49.00€0.67matched