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

5 Nov, 14:00

Gross

€3,022.00

PSP fee

€48.49

Net to the bank

€2,973.51

Settlement journal

#398807

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ac0a-6598-747e-92fa-491448b291ae is already settled by stl_EUR_2989812 line 118
  • missing linein the books, not in the filecapture:01a1ac0a-5a66-7ffc-8ee6-ad192bcb3c29 is in no file
LineKindReferenceGrossFeeStatus
119capture01a1ac0a-65cf-7fe0-8273-67915689b494€24.00€0.37duplicate line
1capture01a1abfb-ff8a-7049-b5df-bb052c19e559€49.00€0.67matched
2capture01a1ac02-abc6-7f78-84ee-7ed2cbab3b30€49.00€0.67matched
3capture01a1ac02-ac1f-7e5b-bbb5-3961cb63dc2c€35.00€0.50matched
4capture01a1ac02-c880-762b-8896-0f3e084ee641€49.00€0.67matched
5capture01a1ac02-e7f4-74b6-b025-ee04990be997€24.00€0.37matched
6capture01a1ac02-eca8-7845-af45-98e96043b716€9.00€0.19matched
7capture01a1ac02-eb84-7148-9675-e703445e9967€15.00€0.26matched
8capture01a1ac02-f9da-78b7-b160-979cc3d78c4c€35.00€0.50matched
9capture01a1ac03-0a7f-77a6-92c7-b92e6238f7be€35.00€0.50matched
10refund01a1ac03-3e3f-7e89-8489-26e227e0a3cf-€14.00€0.00matched
11capture01a1ac03-6618-78d8-a0cf-4cbda9811b23€9.00€0.19matched
12capture01a1ac03-6efd-7fe4-9550-3eaea0ba9a38€49.00€0.67matched
13capture01a1ac03-7707-7530-8c74-edcc23f6eb76€35.00€0.50matched
14capture01a1ac03-7b25-76bf-b3cb-e821e954bdfc€9.00€0.19matched
15capture01a1ac03-afc4-7d84-8473-6c49e1d8c57a€49.00€0.67matched
16capture01a1ac03-b589-762d-9d8d-19e58218dda4€15.00€0.26matched
17capture01a1ac03-d153-7c8c-8fb9-053f0179c862€15.00€0.26matched
18capture01a1ac03-dc13-7f20-b184-f8a7395cbd85€9.00€0.19matched
19capture01a1ac03-f5d2-7e11-8372-234281230151€49.00€0.67matched
20refund01a1ac03-f8e8-7852-981f-a2471c7fa0a7-€43.00€0.00matched
21capture01a1ac04-0333-7389-9db9-b788ffe9be69€9.00€0.19matched
22refund01a1ac04-05a1-76dd-87c1-fac54de3aa9f-€5.00€0.00matched
23capture01a1ac04-08ca-72a3-a092-522c183b42ce€49.00€0.67matched
24capture01a1ac04-1966-7de5-9268-97324adb083e€24.00€0.37matched
25capture01a1ac04-3301-7b9d-97d8-6da8bb8402ae€9.00€0.19matched
26capture01a1ac04-44dc-70c8-b1f9-7a835bfec872€24.00€0.37matched
27capture01a1ac04-7351-75ec-84cd-3c523dfb912b€9.00€0.19matched
28capture01a1ac04-833f-7cda-9e5d-c3ee5a336896€24.00€0.37matched
29capture01a1ac04-8c35-7def-9ee7-e72e66d5df53€35.00€0.50matched
30capture01a1ac04-9902-7dc7-8f72-7808d6eb4643€15.00€0.26matched
31capture01a1ac04-be8a-7f84-a41f-3104bc59b1e1€49.00€0.67matched
32capture01a1ac04-cd50-76ad-8822-b081528d7799€15.00€0.26matched
33capture01a1ac04-cf55-7d55-b76a-798779b28a94€15.00€0.26matched
34refund01a1ac05-00dd-7f9a-82fc-16ab0c9b14fe-€35.00€0.00matched
35refund01a1ac05-2096-7774-ab26-b26b6bb9579b-€9.00€0.00matched
36capture01a1ac05-3000-78a5-8927-b5ffccae46d5€9.00€0.19matched
37capture01a1ac05-45c0-78de-9d4d-171f5e2c3f01€24.00€0.37matched
38capture01a1ac05-5419-7ccc-a705-8b86a288db6e€24.00€0.37matched
39capture01a1ac05-592d-79ee-b162-1f71e0ce6931€15.00€0.26matched
40capture01a1ac05-84d2-77d7-9181-0de35e5473e6€35.00€0.50matched
41capture01a1ac05-a9ee-774c-abe0-a9f751db60af€15.00€0.26matched
42capture01a1ac05-b0e2-75ea-a6c7-ba80d9cc755c€24.00€0.37matched
43capture01a1ac05-b2ab-78f0-befd-51219af8fdf3€9.00€0.19matched
44capture01a1ac05-c06f-78d0-8da6-64380fb80484€15.00€0.26matched
45capture01a1ac05-d2a7-7ccf-8c8d-61ba940db9ee€9.00€0.19matched
46capture01a1ac05-db5a-7711-a0bc-4c5aa557d01a€9.00€0.19matched
47capture01a1ac05-e1cc-7338-883e-fd5f7190b654€35.00€0.50matched
48capture01a1ac05-e8b1-79f8-98be-3072405f0b7d€9.00€0.19matched
49capture01a1ac05-f087-7c9a-940b-d7e4182c9605€49.00€0.67matched
50capture01a1ac05-f2d3-7a00-b389-2f814597988b€24.00€0.37matched
51refund01a1ac06-2049-7362-acb4-4576b110d774-€5.00€0.00matched
52capture01a1ac06-35e8-79f4-b73a-0520c50874ee€49.00€0.67matched
53refund01a1ac06-45c0-766c-bf5e-d03af78b4814-€6.00€0.00matched
54capture01a1ac06-5283-7d5d-962a-62ccb0c5bf78€9.00€0.19matched
55capture01a1ac06-5dfb-7363-be19-31f48535d409€35.00€0.50matched
56capture01a1ac06-72f8-70b1-bf15-eb4eee689559€15.00€0.26matched
57capture01a1ac06-790e-7e83-a26f-8a8ff64d5f27€35.00€0.50matched
58capture01a1ac06-8a33-77f7-b0e6-0dad5a620f58€9.00€0.19matched
59capture01a1ac06-8ddc-72d2-9b8e-88e052094406€24.00€0.37matched
60capture01a1ac06-9cd3-7fda-a031-5b99755a07b5€9.00€0.19matched
61capture01a1ac06-aab6-75bc-87f9-110c5ebf862e€24.00€0.37matched
62capture01a1ac06-ea81-7669-a676-1b3edac3e2e7€9.00€0.19matched
63capture01a1ac06-f6a0-7d29-ab64-54c2f3d6a43e€35.00€0.50matched
64capture01a1ac07-2ec1-7713-91eb-3df86fb91de4€49.00€0.67matched
65capture01a1ac07-3fa7-7f36-80a7-6d4a2ff8b276€15.00€0.26matched
66capture01a1ac07-42fb-78cc-a3b1-8012b5948d40€35.00€0.50matched
67capture01a1ac07-7909-7d33-8b49-cc01d1767c1d€24.00€0.37matched
68capture01a1ac07-8720-7e92-a44a-40896e82b9aa€35.00€0.50matched
69capture01a1ac07-a11b-72ed-927e-61d07c928835€35.00€0.50matched
70capture01a1ac07-ba77-7769-b0e5-6b810f46b481€15.00€0.26matched
71capture01a1ac07-d823-7277-87b1-e3155cc71320€35.00€0.50matched
72capture01a1ac07-ee9a-7e97-b8f6-f812fe1da780€9.00€0.19matched
73refund01a1ac07-ee9d-76fa-b749-5ab860dde563-€11.00€0.00matched
74capture01a1ac08-189f-738b-8e3e-622b0ee18660€9.00€0.19matched
75capture01a1ac08-24eb-710d-b7bf-82d15bfcbbc4€9.00€0.19matched
76capture01a1ac08-25e8-7886-9f93-de5e67cd37fa€15.00€0.26matched
77capture01a1ac08-32a0-73c7-bc26-78b0c9230569€49.00€0.67matched
78capture01a1ac08-3587-7c7c-b516-24a84f8631de€15.00€0.26matched
79capture01a1ac08-461a-7675-b968-489459116376€9.00€0.19matched
80capture01a1ac08-47fe-7104-b056-cb10f5a3d29e€15.00€0.26matched
81refund01a1ac08-48c2-769d-95df-787b0799b74b-€3.00€0.00matched
82capture01a1ac08-5d83-7821-8c93-5935db1d8a2b€35.00€0.50matched
83capture01a1ac08-6816-762c-9ed8-f0015ffd14e0€9.00€0.19matched
84capture01a1ac08-7084-7dfd-9b17-24bf3120de1d€15.00€0.26matched
85capture01a1ac08-7c52-7351-83d0-f3d8aa5e78c1€49.00€0.67matched
86capture01a1ac08-7cb9-73c3-b8f4-ee9beaeb892a€15.00€0.26matched
87capture01a1ac08-94bf-7a94-8c31-2cdcb6a611de€24.00€0.37matched
88capture01a1ac08-a7ac-749c-a18b-f059d408780f€24.00€0.37matched
89capture01a1ac08-af5b-7085-a8b8-ce99287059e0€49.00€0.67matched
90capture01a1ac08-d6a1-7296-a13e-74f619c94802€9.00€0.19matched
91capture01a1ac08-e6e0-7a2d-88da-b2a1c4d83a01€35.00€0.50matched
92capture01a1ac08-ea3e-7a00-9a8a-92b8d0a80d1f€24.00€0.37matched
93capture01a1ac09-07f7-7e15-b219-f004dc9bf23d€24.00€0.37matched
94capture01a1ac09-1833-7e58-b363-a5f486bd7a1c€9.00€0.19matched
95capture01a1ac09-296a-79d6-a024-8c55da864f90€49.00€0.67matched
96capture01a1ac09-2ea4-75e7-9531-931b03ae21bb€35.00€0.50matched
97capture01a1ac09-34e7-7ed0-976c-899ae7573645€35.00€0.50matched
98capture01a1ac09-3c8f-735b-9acd-2c050ce78cb0€35.00€0.50matched
99capture01a1ac09-48c0-7cc7-9799-a18bb88dadee€35.00€0.50matched
100capture01a1ac09-5c06-790a-8d77-bdc5c2f89ba4€49.00€0.67matched
101capture01a1ac09-784e-7f45-8db6-6c8613c6da48€15.00€0.26matched
102capture01a1ac09-7c6d-7e89-86c5-c267c591c4ff€49.00€0.67matched
103refund01a1ac09-7d50-7da0-add4-2ac9b22f06c2-€17.00€0.00matched
104capture01a1ac09-805e-7e01-bec2-6ea4db3de8f2€24.00€0.37matched
105capture01a1ac09-8750-7b7b-8fa5-acbcde84bb00€9.00€0.19matched
106capture01a1ac09-926c-7dc1-9da8-5de8e6c186d8€49.00€0.67matched
107capture01a1ac09-ae4f-72c8-9875-96c0b7ea3e88€9.00€0.19matched
108capture01a1ac09-c0a9-71e6-9bf4-4ebef19d08a2€9.00€0.19matched
109capture01a1ac09-eea4-7986-b433-93e26b2e258c€9.00€0.19matched
110capture01a1ac09-f0f5-7904-a46d-4eb88da5eb21€15.00€0.26matched
111capture01a1ac09-f8e9-7329-a931-664165e77b6e€9.00€0.19matched
112capture01a1ac0a-03d3-7454-ae50-bcf0627b513a€49.00€0.67matched
113capture01a1ac0a-1020-73cd-a820-692e44a54522€24.00€0.37matched
114capture01a1ac0a-11e3-7bfc-9b5d-edb2efd8c0e6€35.00€0.50matched
115capture01a1ac0a-393b-7c3f-997c-212f8f5ff7df€15.00€0.26matched
116refund01a1ac0a-59a0-7760-8d11-b34905c7fe75-€5.00€0.00matched
117capture01a1ac0a-5f6c-7951-be34-0075ac7bab43€15.00€0.26matched
118capture01a1ac0a-65cf-7fe0-8273-67915689b494€24.00€0.37matched
120capture01a1ac0a-6a6b-703e-9e7e-270bc6210172€49.00€0.67matched
121capture01a1ac0a-8b09-7722-9539-cfb8f01dc0cb€9.00€0.19matched
122capture01a1ac0a-8bba-7f31-9a9e-729320df3469€15.00€0.26matched
123capture01a1ac0a-9e04-7f07-8dd9-dfa0b9e161eb€24.00€0.37matched
124capture01a1ac0a-a03c-72c0-b4d3-f17f7e7d1c9a€49.00€0.67matched
125capture01a1ac0a-b591-7f40-ac59-6ea86dc0b96d€35.00€0.50matched
126capture01a1ac0a-c030-71fc-97cb-41729742f7dc€35.00€0.50matched
127capture01a1ac0a-cafb-79d4-a795-7db3213dac2a€24.00€0.37matched
128capture01a1ac0a-de7e-7a78-aed4-f0ddc60e9223€49.00€0.67matched
129capture01a1ac0a-e274-7e7b-86e6-b65cf548bd2a€15.00€0.26matched
130capture01a1ac0a-e48d-725a-ac48-0c2627cf0025€24.00€0.37matched
131refund01a1ac0b-0816-788f-afda-b181983c0408-€13.00€0.00matched
132capture01a1ac0b-1718-7f70-874e-6909f806034b€24.00€0.37matched
133capture01a1ac0b-1c55-73fb-a389-92b6931a7617€24.00€0.37matched
134capture01a1ac0b-502f-7421-9550-5f83ac305a3a€35.00€0.50matched
135capture01a1ac0b-6a9d-71c6-8644-cb389ba0c7ef€15.00€0.26matched
136capture01a1ac0b-6bf6-7ee8-a2c4-2da60f97252c€15.00€0.26matched
137capture01a1ac0b-7b95-76b4-88fd-ff3f8ba3d9f6€9.00€0.19matched
138capture01a1ac0b-8692-71e3-a547-c33b5ad27b53€49.00€0.67matched