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

4 Nov, 09:30

Gross

€2,575.00

PSP fee

€40.67

Net to the bank

€2,534.33

Settlement journal

#377008

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a5e5-7776-73d2-bc32-dc1178a49686 is already settled by stl_EUR_2989641 line 7
LineKindReferenceGrossFeeStatus
8capture01a1a5e5-779f-7949-9797-2a51c3bce3cb€15.00€0.26duplicate line
1capture01a1a5e4-d856-7031-aeaf-9c3af181dea3€15.00€0.26matched
2capture01a1a5e4-f242-70d0-858b-ca9b34ac9c4c€24.00€0.37matched
3capture01a1a5e5-229b-7b46-a2b1-df18ae15cb9e€24.00€0.37matched
4capture01a1a5e5-3158-762a-9157-8a5c09c1f360€24.00€0.37matched
5capture01a1a5e5-35ed-75d2-a5fb-35ca917e89f5€9.00€0.19matched
6refund01a1a5e5-48cc-7db4-99c5-d0b7726cd70c-€11.00€0.00matched
7capture01a1a5e5-779f-7949-9797-2a51c3bce3cb€15.00€0.26matched
9capture01a1a5e5-7d75-76f6-981f-370454fa91c6€15.00€0.26matched
10capture01a1a5e5-ad89-74eb-958d-7b8a5bfdc147€35.00€0.50matched
11refund01a1a5e5-b1ca-79fb-a1ec-cc257fa2a348-€8.00€0.00matched
12capture01a1a5e5-cfd0-7cf1-86c8-ec87c6608296€24.00€0.37matched
13capture01a1a5e5-dfb9-7295-a481-3ed189be54ff€15.00€0.26matched
14capture01a1a5e5-f4f3-77d5-b007-0d63b73eebf1€15.00€0.26matched
15capture01a1a5e5-f6dc-7743-b59e-bf5e3b601623€15.00€0.26matched
16capture01a1a5e5-f7d1-7dea-82b7-33fcb0815296€24.00€0.37matched
17capture01a1a5e5-fda7-7d1a-b2b6-94e894e1c2e6€49.00€0.67matched
18refund01a1a5e6-2be8-70a9-8a6a-ba23eb70f92f-€6.00€0.00matched
19capture01a1a5e6-32e1-79d7-9878-5b52ad8dc215€9.00€0.19matched
20capture01a1a5e6-3d3f-72d5-b4f9-6141a170c535€9.00€0.19matched
21capture01a1a5e6-50de-7c11-9a72-52002f5d9e9c€24.00€0.37matched
22capture01a1a5e6-7681-73ce-92cc-0ee0d8b444cf€35.00€0.50matched
23capture01a1a5e6-8442-7072-8cb6-b6076c5a0220€9.00€0.19matched
24capture01a1a5e6-9893-7c5b-bac1-6fdbf0687f70€9.00€0.19matched
25capture01a1a5e6-c381-7be4-8ca9-ca1dfa119ad6€35.00€0.50matched
26capture01a1a5e6-d44f-78b6-aba6-f6e235854ff1€24.00€0.37matched
27capture01a1a5e6-fb80-75bf-9a18-fba9d1cf0e68€24.00€0.37matched
28capture01a1a5e6-fcbb-7e48-aad9-e9c5da69639a€9.00€0.19matched
29refund01a1a5e7-012f-7a81-b441-4905c2a14220-€7.00€0.00matched
30capture01a1a5e7-0d61-74bf-adc7-e0c32db7d944€35.00€0.50matched
31capture01a1a5e7-17c4-7e56-b3d5-87d142ad44fe€24.00€0.37matched
32capture01a1a5e7-2f65-73d1-87c1-f731e38235ae€35.00€0.50matched
33capture01a1a5e7-7295-7abf-882c-d0ea2132bfc1€24.00€0.37matched
34capture01a1a5e7-767c-77f0-8889-7719e468f1df€35.00€0.50matched
35capture01a1a5e7-803f-75a0-a63f-67c979fb950c€35.00€0.50matched
36capture01a1a5e7-8150-7f4e-b372-1f23e58061b7€15.00€0.26matched
37capture01a1a5e7-899c-7867-afc4-a1b9025c5044€9.00€0.19matched
38capture01a1a5e7-8af2-7f2c-9221-267846266c4d€9.00€0.19matched
39capture01a1a5e7-9ac2-7ca3-88d2-1618f6f46139€35.00€0.50matched
40capture01a1a5e7-a2eb-71b0-b711-c13f5afe5ea7€15.00€0.26matched
41capture01a1a5e7-a379-7a94-82d8-6678e63ff17f€9.00€0.19matched
42capture01a1a5e7-bcca-7e58-825d-95366bcfbf31€24.00€0.37matched
43capture01a1a5e7-c76e-7390-a6da-6372b886850f€49.00€0.67matched
44capture01a1a5e7-d2bf-7cc3-89e2-eece0d6947a3€49.00€0.67matched
45capture01a1a5e7-d5f1-7ee4-a0d8-ce5da6ead875€49.00€0.67matched
46capture01a1a5e7-de91-7e70-bdda-525c3b488a9a€15.00€0.26matched
47capture01a1a5e7-ec97-7608-96d2-848f745c976b€15.00€0.26matched
48capture01a1a5e7-ecaf-72a5-b6b6-db2cde10416f€15.00€0.26matched
49capture01a1a5e7-edc7-70bb-9859-4b7907af60dd€24.00€0.37matched
50capture01a1a5e7-f0d2-767c-8a49-03029a649a57€24.00€0.37matched
51capture01a1a5e8-1511-7ec8-90f5-01ed13390565€24.00€0.37matched
52capture01a1a5e8-1513-71e2-b2a7-555410c5ed3b€49.00€0.67matched
53capture01a1a5e8-2d8f-7533-a06f-f717d8afd5a0€9.00€0.19matched
54capture01a1a5e8-3777-77f6-bd41-7d46f1a2e6ab€49.00€0.67matched
55refund01a1a5e8-419e-7696-8fad-06935bd4b879-€20.00€0.00matched
56capture01a1a5e8-627c-783e-950b-2459f49e6ebc€24.00€0.37matched
57refund01a1a5e8-7043-72e3-9826-3dcc2112514a-€11.00€0.00matched
58capture01a1a5e8-7237-7035-ab24-ee804fbb6af4€15.00€0.26matched
59capture01a1a5e8-b7a1-76ad-949c-34af92217f75€35.00€0.50matched
60capture01a1a5e9-22ae-7169-b9dd-1fa713d9618a€15.00€0.26matched
61capture01a1a5e9-3854-7ea4-b176-523bb69271c9€9.00€0.19matched
62capture01a1a5e9-3a76-7dbd-bddf-cddea7108897€24.00€0.37matched
63capture01a1a5e9-45e7-7752-8a51-3c714e260b7e€15.00€0.26matched
64capture01a1a5e9-488d-7ef6-a78e-e2e6006608c9€9.00€0.19matched
65capture01a1a5e9-5484-7755-ad17-a8aa67161046€24.00€0.37matched
66capture01a1a5e9-64ea-7c87-8dc0-09307020d96d€35.00€0.50matched
67capture01a1a5e9-6d51-7aa5-9ad4-c37498624b29€15.00€0.26matched
68capture01a1a5e9-7ffd-77db-b1bd-03c9d9de82ef€35.00€0.50matched
69capture01a1a5e9-d84e-7eaa-91ce-11a94dfd26b8€15.00€0.26matched
70capture01a1a5e9-e3a2-724c-a1e7-ea3bc7d6e9c2€9.00€0.19matched
71capture01a1a5e9-e806-77f8-997c-227e0623e53d€15.00€0.26matched
72capture01a1a5e9-ec66-7098-8f65-a9b6cb5de05d€49.00€0.67matched
73capture01a1a5e9-f518-733f-88be-d6449d950625€24.00€0.37matched
74capture01a1a5e9-f80d-7b41-afda-0e1d2d13d76d€24.00€0.37matched
75capture01a1a5ea-1c59-73b2-89ff-19b836c91fb2€9.00€0.19matched
76capture01a1a5ea-354e-7996-87fe-7ec2e1cf8531€9.00€0.19matched
77refund01a1a5ea-5def-736b-9ea2-668000519c4b-€2.00€0.00matched
78capture01a1a5ea-7154-7714-8ffa-738fd9c9cf96€49.00€0.67matched
79capture01a1a5ea-7fb3-7991-93ab-4837b2c5ee54€35.00€0.50matched
80capture01a1a5ea-8c13-76d5-878f-aa39f562adc3€24.00€0.37matched
81capture01a1a5ea-b43c-78cd-97db-74f63724c98d€35.00€0.50matched
82capture01a1a5ea-b7e4-7b22-b6d2-a46c47ed1cf7€49.00€0.67matched
83capture01a1a5ea-bed6-7a89-a0cd-7094ffcb4fac€49.00€0.67matched
84capture01a1a5ea-d982-77c9-b9b3-3b97cb5cbe1c€24.00€0.37matched
85capture01a1a5eb-09fc-74b1-8103-9323d8ba92f4€15.00€0.26matched
86capture01a1a5eb-0ef6-744b-ab50-03e86b284adf€15.00€0.26matched
87capture01a1a5eb-211e-7e7a-9f2e-75bf21f5801d€35.00€0.50matched
88capture01a1a5eb-2c22-7847-b03e-672c821f3390€15.00€0.26matched
89capture01a1a5eb-655a-7cd1-8638-1ddcd1953844€9.00€0.19matched
90capture01a1a5eb-c3b5-72d1-afac-f291eb04b351€35.00€0.50matched
91capture01a1a5eb-f1f8-7dd7-96f0-e018d832c70f€24.00€0.37matched
92capture01a1a5eb-f5d0-780e-950c-8c42a877dcf6€35.00€0.50matched
93capture01a1a5eb-fb49-7e3e-bb2d-52fa911f4373€49.00€0.67matched
94capture01a1a5ec-063d-7e33-8d89-37517830351a€35.00€0.50matched
95capture01a1a5ec-2110-7790-b25b-fd4d3d83c56f€15.00€0.26matched
96capture01a1a5ec-23e4-75a2-a92a-1b1cbd88ba7f€49.00€0.67matched
97capture01a1a5ec-26f4-70ad-94f0-f6ad3233a9b3€15.00€0.26matched
98capture01a1a5ec-26f6-793e-a00a-3ae27fcf73f2€9.00€0.19matched
99capture01a1a5ec-3f2b-7dc5-a234-3ccb4f033fa4€9.00€0.19matched
100capture01a1a5ec-60bc-706d-88ce-cfd2fec0a2a9€49.00€0.67matched
101capture01a1a5ec-94a7-70d2-8e44-ae44ff4d7593€49.00€0.67matched
102capture01a1a5ec-a917-7d42-b653-8561ff3538a3€24.00€0.37matched
103capture01a1a5ec-b250-7c54-ae13-e5b9943acf27€9.00€0.19matched
104capture01a1a5ec-e793-79a6-a58f-138c840e20ba€9.00€0.19matched
105capture01a1a5ec-fa56-74dc-955e-cedc52d67d6b€24.00€0.37matched
106capture01a1a5ed-2658-733d-8630-75616144614e€15.00€0.26matched
107capture01a1a5ed-3e07-79ce-9237-5da79d085154€9.00€0.19matched
108capture01a1a5ed-56bf-75f7-897a-cef10da6b1c4€24.00€0.37matched
109capture01a1a5ed-5752-7baf-9961-dcb9d5d3c439€15.00€0.26matched
110capture01a1a5ed-6471-739b-8db7-05e919d5ea6c€9.00€0.19matched
111capture01a1a5ed-64c5-756f-981a-18bc6b48fb07€35.00€0.50matched
112capture01a1a5ed-6c1f-7578-8537-68e1806bb99a€35.00€0.50matched
113capture01a1a5ed-8be8-7fe6-ac49-9f43a5b76a66€49.00€0.67matched
114capture01a1a5ed-9089-7bad-a163-e4ec516ec790€15.00€0.26matched
115capture01a1a5ed-d146-7906-8fbb-114b87affa5a€9.00€0.19matched
116capture01a1a5ed-e34d-74ec-a8eb-8d3a3710e306€24.00€0.37matched
117capture01a1a5ed-ee60-74a6-863d-a7b96b12490d€24.00€0.37matched
118refund01a1a5ed-f913-7f42-94d0-046a0c686fdb-€5.00€0.00matched