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, 02:10

Gross

€3,463.00

PSP fee

€54.27

Net to the bank

€3,408.73

Settlement journal

#408092

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

LineKindReferenceGrossFeeStatus
1capture01a1ae9b-5b3a-702a-8f7a-54b23ff40aa5€24.00€0.37matched
2capture01a1ae9b-9960-73f0-8c07-b1db211da977€24.00€0.37matched
3capture01a1ae9b-a244-7641-ad48-dbb9819ed857€49.00€0.67matched
4capture01a1ae9e-928c-7d91-bec0-a9c17b9d351b€24.00€0.37matched
5capture01a1ae9e-c2f2-7782-819f-0726d36d8876€9.00€0.19matched
6capture01a1ae9e-c50e-789f-bac8-38fd9c913abe€35.00€0.50matched
7capture01a1ae9e-d803-72d7-8a4b-24560ad90a08€49.00€0.67matched
8capture01a1ae9e-e1c9-772d-94b9-7c28a3cfcb85€49.00€0.67matched
9capture01a1ae9e-e2db-74d6-9a2f-7b046ff74e8d€24.00€0.37matched
10capture01a1ae9e-fa97-7377-bb1c-0190deceb6dd€15.00€0.26matched
11capture01a1ae9f-364f-78ad-9c0b-7ad803f38602€24.00€0.37matched
12capture01a1ae9f-3c92-7dee-9bf9-8f61bac66ded€24.00€0.37matched
13capture01a1ae9f-525b-70bd-a512-0be561526ea9€24.00€0.37matched
14capture01a1ae9f-5b68-7497-8888-63c50f71d035€24.00€0.37matched
15capture01a1ae9f-7c26-7bdf-9148-d1a48c773a2c€49.00€0.67matched
16capture01a1ae9f-7e4d-75d5-8278-6820af4ea6e8€15.00€0.26matched
17capture01a1ae9f-8bc4-70ce-9d58-a487876e4baf€24.00€0.37matched
18capture01a1ae9f-ba4f-74e9-a1c2-d385477098a9€35.00€0.50matched
19refund01a1ae9f-d11c-7dd0-974c-0c418316018f-€22.00€0.00matched
20capture01a1ae9f-d3c9-76ff-8960-6dcc2ec6e46a€35.00€0.50matched
21capture01a1ae9f-d4f4-7f7f-ab4d-498bf52c0483€24.00€0.37matched
22capture01a1ae9f-d523-7d8a-9425-00c108b621d9€49.00€0.67matched
23capture01a1ae9f-d60a-796f-8e1b-fb2996169377€24.00€0.37matched
24capture01a1aea0-094f-7e27-8725-200aefdb67a1€49.00€0.67matched
25capture01a1aea0-0b99-7147-8909-174f334ebf30€49.00€0.67matched
26capture01a1aea0-11f3-7cd9-97aa-e930a1bcd160€35.00€0.50matched
27capture01a1aea0-18d3-720e-9b69-59e9fe628eb9€24.00€0.37matched
28capture01a1aea0-2221-713e-a1a6-70e7f5ac0163€24.00€0.37matched
29capture01a1aea0-2c5c-7d2d-901b-ff3d6b1c20db€35.00€0.50matched
30capture01a1aea0-3a7a-7da2-bb77-e839d5cbfe81€49.00€0.67matched
31capture01a1aea0-43a1-70ce-905b-bd820a1416de€15.00€0.26matched
32refund01a1aea0-4529-714d-8885-eed1a3cce793-€14.00€0.00matched
33capture01a1aea0-50b7-7604-a6af-f56779a1fab7€24.00€0.37matched
34capture01a1aea0-5ba8-70f4-9861-98c6f51cf482€9.00€0.19matched
35capture01a1aea0-7ba7-79a4-b191-67241be30977€49.00€0.67matched
36capture01a1aea0-8076-7979-8271-4b8d22d2facb€24.00€0.37matched
37capture01a1aea0-ad8c-72e2-baee-8d1888dbb052€49.00€0.67matched
38refund01a1aea0-b5d0-750e-8555-4686d9d9dc63-€3.00€0.00matched
39capture01a1aea0-bb58-77a5-8d9d-6ccfa37069a5€49.00€0.67matched
40capture01a1aea0-cd40-7d34-8c53-e50bd040f6fb€15.00€0.26matched
41capture01a1aea0-cda2-7897-acff-edba848895d7€49.00€0.67matched
42capture01a1aea0-f10d-735b-a121-ed23180d561c€35.00€0.50matched
43refund01a1aea0-fbe8-7965-87a1-aaff9a13cfd8-€44.00€0.00matched
44capture01a1aea1-1409-74c7-87b8-e0e2e5b7834a€15.00€0.26matched
45capture01a1aea1-2aed-75c6-abbe-fbe55b60cfd3€15.00€0.26matched
46capture01a1aea1-42dd-7335-be0a-770cd4ebec46€35.00€0.50matched
47capture01a1aea1-42f2-72a8-b11c-e1e6cb90eba3€9.00€0.19matched
48capture01a1aea1-57c6-7cd0-9206-877f14ea6bbe€9.00€0.19matched
49capture01a1aea1-591f-79c3-a2b1-290bcda6db5b€9.00€0.19matched
50capture01a1aea1-7e39-77ea-bf4f-47223506da09€49.00€0.67matched
51capture01a1aea1-8485-7ed7-a5c4-3e5b9d8087c6€24.00€0.37matched
52capture01a1aea1-8641-74e2-add4-0a6c263a1bf0€15.00€0.26matched
53refund01a1aea1-b4e5-7f6d-959a-59637517b58f-€11.00€0.00matched
54capture01a1aea1-c757-7e2d-b27b-3ff4698e99c0€49.00€0.67matched
55capture01a1aea1-de43-7f4e-bf59-9b30979838fb€35.00€0.50matched
56capture01a1aea1-e844-7fe1-ae1a-512d69df3b98€35.00€0.50matched
57capture01a1aea1-e98b-7440-9c0c-cd09baebfb3f€35.00€0.50matched
58capture01a1aea2-0dd1-796b-9c21-0089ff544d2d€15.00€0.26matched
59capture01a1aea2-16e9-7a13-b46d-e18dc3c5c040€49.00€0.67matched
60capture01a1aea2-17f0-7172-960b-7b84c7aafc66€35.00€0.50matched
61capture01a1aea2-1fc0-7837-961e-bbc0348539dd€15.00€0.26matched
62capture01a1aea2-29a1-78b0-b5d4-e5f814332e99€24.00€0.37matched
63capture01a1aea2-4921-74c8-85c4-c1667db99a5d€24.00€0.37matched
64capture01a1aea2-51a8-767a-b124-8de00fd86a40€9.00€0.19matched
65capture01a1aea2-5216-7185-9978-ba21b8af081b€15.00€0.26matched
66capture01a1aea2-822c-79a0-a47e-25be89890173€35.00€0.50matched
67capture01a1aea2-98aa-75d1-a889-8d521a337d99€35.00€0.50matched
68capture01a1aea2-9fda-7bd7-95b8-892af0daf4bb€35.00€0.50matched
69capture01a1aea2-b952-7bce-84bc-2cb506cc2946€35.00€0.50matched
70capture01a1aea2-bc91-7905-9ec4-11b3c5e552c8€49.00€0.67matched
71capture01a1aea2-e284-7769-84de-1cef6c2a3b22€49.00€0.67matched
72capture01a1aea2-f43c-7f4a-b8fc-c489502f8bcb€15.00€0.26matched
73capture01a1aea2-fc65-751c-9284-071cb82dded2€15.00€0.26matched
74capture01a1aea3-084d-7d02-a80d-261789eb346a€24.00€0.37matched
75capture01a1aea3-2102-7df7-a091-72d963cc0f56€9.00€0.19matched
76capture01a1aea3-2eb7-7c30-be2c-c7265dbd9761€24.00€0.37matched
77capture01a1aea3-4aa4-75c3-8739-724d85ff36f7€24.00€0.37matched
78capture01a1aea3-58c6-7182-af42-d3400b665c68€49.00€0.67matched
79capture01a1aea3-5d18-78b2-8365-80293bf388d0€35.00€0.50matched
80capture01a1aea3-6d65-7dc3-bb96-bfb450e554cc€9.00€0.19matched
81capture01a1aea3-70a5-70e4-a6f3-2990ad08598a€49.00€0.67matched
82capture01a1aea3-72cd-755c-adca-8d442ec880bd€35.00€0.50matched
83capture01a1aea3-738d-71d0-aeaa-68bca41d32e3€35.00€0.50matched
84capture01a1aea3-747a-7594-b039-5e6caa6c5977€49.00€0.67matched
85capture01a1aea3-77a3-7338-b053-0954f8b96264€24.00€0.37matched
86capture01a1aea3-89dd-79c8-b120-3ff35c7b1697€49.00€0.67matched
87capture01a1aea3-a58a-7c65-bd92-fc44d5649b15€24.00€0.37matched
88capture01a1aea3-ae99-7223-b62a-2898c2a5830e€15.00€0.26matched
89capture01a1aea3-d14f-7791-a7e7-678bf3168e58€9.00€0.19matched
90capture01a1aea3-fc9b-7c30-9b0e-4a6f1f5b7bb1€24.00€0.37matched
91capture01a1aea4-1ea7-778b-bf79-63660883c801€9.00€0.19matched
92capture01a1aea4-385e-7369-824e-4a2c6ec04160€9.00€0.19matched
93capture01a1aea4-3edc-780f-9a57-d315d9da9843€9.00€0.19matched
94capture01a1aea4-49db-7800-8b06-01617671679b€35.00€0.50matched
95capture01a1aea4-57cf-773f-8681-8c9efe49519b€49.00€0.67matched
96capture01a1aea4-6adb-7eb3-bb47-a950def820cc€15.00€0.26matched
97capture01a1aea4-7711-7d00-897e-2be54ae78cc4€35.00€0.50matched
98capture01a1aea4-7fbc-7f4a-ac3f-9cc103c57943€35.00€0.50matched
99refund01a1aea4-8bbc-7d1f-b1ee-395125091956-€25.00€0.00matched
100capture01a1aea4-baf2-7352-88e8-8086f603b1f3€15.00€0.26matched
101capture01a1aea4-bb2a-7197-8b80-7150e9c05316€9.00€0.19matched
102capture01a1aea4-c1af-7699-aa09-cb73a217f6d4€24.00€0.37matched
103capture01a1aea4-c4b6-7b84-aaee-f98349ef29d5€15.00€0.26matched
104capture01a1aea4-d13d-773d-bd85-72601933b2ff€49.00€0.67matched
105capture01a1aea4-dc4c-7f30-b4c1-40dea626a595€49.00€0.67matched
106capture01a1aea4-e45f-76cd-b1f6-b48e3a52c3e1€49.00€0.67matched
107capture01a1aea5-10af-744d-b265-c55b88d75bce€9.00€0.19matched
108capture01a1aea5-2154-76b7-a24a-379ad51a6503€35.00€0.50matched
109capture01a1aea5-2cec-74e5-b5a2-6c016a8370ea€9.00€0.19matched
110capture01a1aea5-5f09-79d8-b634-38407b5717fd€15.00€0.26matched
111capture01a1aea5-7d08-7dc8-b0c3-ecd98cc21bfb€9.00€0.19matched
112capture01a1aea5-ac56-7f2e-a98e-50da6ee6d1a1€9.00€0.19matched
113capture01a1aea5-c7b3-7b39-84e2-1b96102c14cc€15.00€0.26matched
114capture01a1aea5-cf51-7838-9176-a57ebdf86818€15.00€0.26matched
115capture01a1aea5-e6f3-702c-b128-a49b49f3cb1c€15.00€0.26matched
116capture01a1aea5-e980-7d30-8de4-cc12d35935e5€9.00€0.19matched
117capture01a1aea5-ef3c-7db7-b3a5-101bd1191aec€15.00€0.26matched
118capture01a1aea5-ef6e-7788-b3ba-9c88423d15d4€9.00€0.19matched
119capture01a1aea5-fa95-7589-ad58-1293050cadf2€15.00€0.26matched
120capture01a1aea6-0267-7c9f-aab3-b1447e0bb97a€35.00€0.50matched
121capture01a1aea6-0df3-72d6-838f-f7b309a23529€15.00€0.26matched
122capture01a1aea6-3704-796e-9431-5c77de61fca4€24.00€0.37matched
123refund01a1aea6-3922-7906-bb28-c43dc18d5e27-€8.00€0.00matched
124capture01a1aea6-3a75-7d26-8c8b-7adffa9bef07€15.00€0.26matched
125capture01a1aea6-4493-7f1c-9f25-3218a3dc32ed€9.00€0.19matched
126capture01a1aea6-455f-7ffc-882a-84d397173228€15.00€0.26matched
127capture01a1aea6-64d6-7792-8a8f-13b9d4691a27€35.00€0.50matched
128capture01a1aea6-69ce-7366-9c0e-d7f3024ef89c€35.00€0.50matched
129capture01a1aea6-8594-7762-89c4-d64a76561b3f€35.00€0.50matched
130capture01a1aea6-8caa-75c8-b5e5-74077ea53af7€9.00€0.19matched
131capture01a1aea6-9bde-7f27-8d16-69ad5a8f07be€9.00€0.19matched
132capture01a1aea6-a20b-7171-9b4b-160d18959818€24.00€0.37matched
133refund01a1aea6-a801-71b7-afd8-ab647647a34f-€19.00€0.00matched
134capture01a1aea6-c32f-70aa-a3c7-afd8644008d9€9.00€0.19matched
135capture01a1aea7-53d8-710f-9736-1f53715e1ffa€49.00€0.67matched
136capture01a1aea7-6f83-72fd-80bd-b8f3f7d987be€24.00€0.37matched
137capture01a1aea7-7762-71ba-afd8-6a91a2531cda€15.00€0.26matched
138capture01a1aea7-8868-74b1-b7fd-d2fec2bc0214€49.00€0.67matched
139capture01a1aea7-9a19-7350-ada7-50b6b1a49402€24.00€0.37matched
140capture01a1aea7-a21c-7fde-8608-62c011d892e7€24.00€0.37matched
141capture01a1aea7-a832-7e22-8d9a-721e67073ed5€35.00€0.50matched
142capture01a1aea7-b711-78fc-adeb-353cc1524605€9.00€0.19matched
143capture01a1aea7-d729-79e3-8f5a-624fba29907d€15.00€0.26matched