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, 06:20

Gross

€2,830.00

PSP fee

€44.40

Net to the bank

€2,785.60

Settlement journal

#374640

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a53e-5589-74e5-9850-ff5c4e46e228 is already settled by stl_EUR_2989622 line 105
LineKindReferenceGrossFeeStatus
106capture01a1a53e-7250-78bd-baf1-9f46ef94c385€24.00€0.37duplicate line
1capture01a1a52e-7d6d-76f2-b8bb-00543cc911b2€24.00€0.37matched
2capture01a1a52f-b4ba-7849-a0df-e52b77693dfa€9.00€0.19matched
3capture01a1a52f-b4c0-70d4-b61f-2227c46c46e0€49.00€0.67matched
4capture01a1a533-a373-71d9-b3fc-4c4ac58b7ad1€35.00€0.50matched
5capture01a1a536-f060-701b-89e1-a541ac38bd46€24.00€0.37matched
6capture01a1a537-0db4-7464-ac49-241283e48765€49.00€0.67matched
7capture01a1a537-3ec9-704e-ad9f-179d54e043d7€9.00€0.19matched
8capture01a1a537-4165-74f5-8735-35af3df5b1f3€9.00€0.19matched
9capture01a1a537-46b8-7cd7-a5d7-539fd5d889ac€35.00€0.50matched
10capture01a1a537-4ee9-7d52-b792-85e8f15246e0€15.00€0.26matched
11capture01a1a537-6060-756a-9e7c-321beac6b969€24.00€0.37matched
12refund01a1a537-96ce-7513-b6ef-5abd099f658d-€22.00€0.00matched
13capture01a1a537-dff1-7085-b3ec-010c77ef7c88€35.00€0.50matched
14capture01a1a537-f2c3-71af-9695-672e5a4706c3€15.00€0.26matched
15capture01a1a537-f394-7997-b5d0-bc5e485c69a7€35.00€0.50matched
16capture01a1a537-f87f-74d5-822e-acea86115ce1€49.00€0.67matched
17capture01a1a538-004e-7de9-9e32-cb8fc600e1bc€49.00€0.67matched
18capture01a1a538-03d5-78eb-8eb8-3d951e96aa74€24.00€0.37matched
19capture01a1a538-19a1-7d01-843e-d8904e7d4df7€9.00€0.19matched
20capture01a1a538-19c0-7774-873b-0a81c61eb892€9.00€0.19matched
21capture01a1a538-2d16-7a2b-ade3-b11891aa0760€35.00€0.50matched
22refund01a1a538-5410-7665-8349-d2e5e3044a67-€18.00€0.00matched
23capture01a1a538-554c-7e5d-b3e1-19a9f0ed9c05€9.00€0.19matched
24refund01a1a538-5ac9-765a-83ec-169ee161d9f2-€8.00€0.00matched
25capture01a1a538-822d-7fbb-9fdb-e142615f1e0c€49.00€0.67matched
26capture01a1a538-8302-7a68-8dfe-be7d704ab635€35.00€0.50matched
27capture01a1a538-9728-762e-b6e0-a30ef8f4a136€9.00€0.19matched
28capture01a1a538-a435-79f8-9e70-1eb858afdf38€15.00€0.26matched
29capture01a1a538-a513-7f8c-a1a2-882146bb0933€24.00€0.37matched
30capture01a1a538-a765-755a-b708-e6775fe606f4€9.00€0.19matched
31capture01a1a538-bd87-750c-b040-8597356bf1f4€15.00€0.26matched
32capture01a1a538-cafc-7cb8-ba1f-03d4c6039fee€49.00€0.67matched
33capture01a1a538-cba2-7f7c-9d98-70d1ebff5414€24.00€0.37matched
34refund01a1a538-f502-7d6e-b1ff-064bc3a9828d-€10.00€0.00matched
35capture01a1a538-feb6-7914-86a8-91aac7f56d53€24.00€0.37matched
36capture01a1a539-1b8e-7c3f-bcce-f316baa2346e€15.00€0.26matched
37capture01a1a539-5731-71e8-a942-ec5dd6073da4€15.00€0.26matched
38capture01a1a539-65ef-740c-a4c4-43312910a178€35.00€0.50matched
39capture01a1a539-6628-7f83-abad-49a851016e9c€15.00€0.26matched
40capture01a1a539-8255-7e25-ba98-a0977e1ebddf€49.00€0.67matched
41capture01a1a539-d0a8-76fb-acb8-acd1b2b5f427€35.00€0.50matched
42capture01a1a539-d2e9-7f73-9332-62979eb02ee5€9.00€0.19matched
43capture01a1a539-d53a-713e-8b27-b49af31156c0€9.00€0.19matched
44capture01a1a53a-04c4-75b2-ad4c-950637b9f9df€49.00€0.67matched
45capture01a1a53a-22ec-7f82-9ed5-7d82eeb98d4d€49.00€0.67matched
46capture01a1a53a-5e33-7b9a-9f9b-6040e92178df€24.00€0.37matched
47capture01a1a53a-70cf-7384-b472-7edc8805e961€35.00€0.50matched
48capture01a1a53a-7ce1-713e-80ba-156b0a34ac4c€9.00€0.19matched
49capture01a1a53a-7d0c-7eff-bb49-faa0ef8f3ab2€9.00€0.19matched
50capture01a1a53a-7dba-73ae-8315-5edb36ce2398€24.00€0.37matched
51capture01a1a53a-8e7d-705b-b8b8-562a7307cff0€15.00€0.26matched
52capture01a1a53a-9429-7112-9936-217ebcc1e253€9.00€0.19matched
53capture01a1a53a-b515-75b6-91c5-b11322c38e11€15.00€0.26matched
54capture01a1a53a-bd37-7814-8176-e72963c9426a€24.00€0.37matched
55refund01a1a53a-bd96-7e76-acbe-08410d787ce0-€5.00€0.00matched
56capture01a1a53a-dfd3-737a-aec6-02a0e4ba44d0€49.00€0.67matched
57capture01a1a53a-e1c4-7b67-aac3-55998c487406€9.00€0.19matched
58capture01a1a53a-ebc8-7850-864a-de1c569989a2€35.00€0.50matched
59capture01a1a53a-f534-76ee-b0a3-45f0929309fe€24.00€0.37matched
60capture01a1a53b-0542-757a-bc54-d5f10b33fdbe€35.00€0.50matched
61capture01a1a53b-1195-7fe8-a7c1-ed02b4316e79€35.00€0.50matched
62capture01a1a53b-534d-7913-867b-26674ebe52f2€49.00€0.67matched
63capture01a1a53b-82b5-7cde-afdf-3f71cf706a9b€49.00€0.67matched
64capture01a1a53b-8888-70ef-a17c-b50dd10657a6€9.00€0.19matched
65capture01a1a53b-9ed6-700b-af51-fbec78b52e60€9.00€0.19matched
66capture01a1a53b-a2e9-71a1-9714-c5f80e04e35f€24.00€0.37matched
67refund01a1a53b-edc9-71cf-8b6a-399d5b125aa0-€3.00€0.00matched
68capture01a1a53b-f55c-79cf-9416-e7795d2b75d8€15.00€0.26matched
69capture01a1a53b-fc37-712a-af2b-655180baeb61€24.00€0.37matched
70capture01a1a53c-02b5-7ee4-9050-365e31fe5c2e€49.00€0.67matched
71capture01a1a53c-0381-7c56-9210-a6fad748e9ac€49.00€0.67matched
72capture01a1a53c-0394-7698-bcea-5c9ff7d8fe1d€15.00€0.26matched
73capture01a1a53c-072e-7a40-a792-445b84b7d649€15.00€0.26matched
74capture01a1a53c-0dd3-7ccc-92b2-756c2c83f0e1€9.00€0.19matched
75capture01a1a53c-2856-7ce7-94f1-3095cf9f6a55€35.00€0.50matched
76capture01a1a53c-295e-7eea-987e-4394f2346bb9€9.00€0.19matched
77refund01a1a53c-35c1-71ca-8a14-962a08696a44-€8.00€0.00matched
78capture01a1a53c-4158-7dd0-9d01-6f7d16af051f€24.00€0.37matched
79capture01a1a53c-42e5-7e73-9c41-4f3b95452a44€24.00€0.37matched
80capture01a1a53c-49e0-738b-ad94-0ea00a06c420€35.00€0.50matched
81refund01a1a53c-5af7-7872-b563-1119fa4a8244-€5.00€0.00matched
82capture01a1a53c-6e32-7f91-a4ed-3b7cad3363a0€49.00€0.67matched
83capture01a1a53c-a68b-7c32-ab2f-cfa33d51f5f6€24.00€0.37matched
84capture01a1a53c-c65d-7065-9aa9-657fd7a35afb€35.00€0.50matched
85capture01a1a53c-c48b-7313-aad5-aabc1be1779c€9.00€0.19matched
86capture01a1a53c-d6a8-7a88-b01f-9da61266f5cb€15.00€0.26matched
87capture01a1a53c-ec6b-7595-af53-3c52ee4ca6a6€15.00€0.26matched
88capture01a1a53d-028f-7477-b665-dbc47e2acaa1€35.00€0.50matched
89capture01a1a53d-2eab-73ea-a47f-9ce8c2d0fdab€49.00€0.67matched
90capture01a1a53d-45a9-70a4-adef-827a18fd9152€49.00€0.67matched
91capture01a1a53d-5f10-7110-b676-1113e5bb24b7€35.00€0.50matched
92capture01a1a53d-60f8-7023-bc33-f91f66286e61€35.00€0.50matched
93capture01a1a53d-748d-720c-b41d-a5b7723dd5ac€49.00€0.67matched
94capture01a1a53d-8b19-7495-9639-4706a5b9584f€15.00€0.26matched
95capture01a1a53d-9adc-792f-bcb1-191b084649c0€24.00€0.37matched
96capture01a1a53d-9d8d-7b6c-b1c2-d9daa9bc67de€35.00€0.50matched
97refund01a1a53d-be58-7817-922b-887232598027-€33.00€0.00matched
98capture01a1a53d-c4bf-7882-800a-f5e56760d727€35.00€0.50matched
99capture01a1a53d-caca-7448-8524-3bf0c6fc59a7€35.00€0.50matched
100capture01a1a53d-d09d-7c9c-a955-df75c50ab173€15.00€0.26matched
101capture01a1a53e-486c-7193-bae8-ddae8f0138d9€49.00€0.67matched
102capture01a1a53e-504f-747e-9ea6-5ff80e4d9b5c€49.00€0.67matched
103capture01a1a53e-5207-7209-b19d-6ce7c28d8cf0€24.00€0.37matched
104capture01a1a53e-54d6-7996-8699-33d5629e9d51€24.00€0.37matched
105capture01a1a53e-7250-78bd-baf1-9f46ef94c385€24.00€0.37matched
107capture01a1a53e-7738-7cc3-b8fd-d538d6393ce4€15.00€0.26matched
108capture01a1a53e-84e2-73b8-b49c-0ba53e423edf€24.00€0.37matched
109capture01a1a53e-c735-7a52-956e-cb656d06dc71€24.00€0.37matched
110capture01a1a53e-d166-7109-9dfa-7055ec0c7519€24.00€0.37matched
111capture01a1a53e-da1e-7c81-8676-1f551c140945€24.00€0.37matched
112capture01a1a53e-e9b4-764e-93e6-ccad9144e36e€9.00€0.19matched
113capture01a1a53e-fea8-7efb-a805-f4145f4caeca€15.00€0.26matched
114capture01a1a53f-a5e7-7e42-89fa-812afb20a58e€15.00€0.26matched
115capture01a1a53f-c4b0-7bba-9ef0-46954df4519f€9.00€0.19matched
116capture01a1a53f-c565-797e-8942-73d1425ceffe€9.00€0.19matched
117capture01a1a53f-e584-72f5-8489-de98a0907e2d€15.00€0.26matched
118capture01a1a53f-f38e-73c6-b4a4-7735be720000€24.00€0.37matched
119capture01a1a53f-fa7b-79a3-8a66-826fdf7d41c4€35.00€0.50matched
120capture01a1a53f-fb65-7ed2-b922-a85930f68edf€35.00€0.50matched
121capture01a1a53f-fc2a-70e6-a3f6-0842e492610b€35.00€0.50matched