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, 03:40

Gross

€2,946.00

PSP fee

€47.62

Net to the bank

€2,898.38

Settlement journal

#336109

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19a59-e80d-724f-9ba4-183d11b4afbc is already settled by stl_EUR_2989318 line 28
LineKindReferenceGrossFeeStatus
29capture01a19a59-e847-74bd-a9b7-c4f1d6ec986d€35.00€0.50duplicate line
1capture01a19a4f-1246-75c5-abf9-3d2a93ae4437€35.00€0.50matched
2capture01a19a50-431a-775c-8f8a-7b46127520be€49.00€0.67matched
3capture01a19a54-fafa-7770-a48b-a36d92c87341€24.00€0.37matched
4capture01a19a57-e49a-7e2a-8f82-b72b88ea8570€24.00€0.37matched
5capture01a19a57-ee37-7e8b-8f5b-0c583b41f5cd€35.00€0.50matched
6capture01a19a58-0525-739a-add9-efc4d69b44ba€9.00€0.19matched
7capture01a19a58-1332-75f3-bd2e-da092e174a2b€15.00€0.26matched
8capture01a19a58-3127-74e9-9db4-6be58eba4227€49.00€0.67matched
9capture01a19a58-3dcb-724b-8e15-ea56586ee85f€49.00€0.67matched
10capture01a19a58-4057-7ce1-9474-2e9a5dfec245€49.00€0.67matched
11capture01a19a58-4be4-739b-a2a4-17285c064fc9€35.00€0.50matched
12capture01a19a58-630a-7202-b8e9-dc08c736ca93€24.00€0.37matched
13capture01a19a58-68a1-79c9-a32e-e5ec70b39476€15.00€0.26matched
14capture01a19a58-847d-7d46-9ac1-fdf5b5d35ab9€49.00€0.67matched
15capture01a19a58-9268-7843-8346-a7b2f800609e€15.00€0.26matched
16capture01a19a58-aa3b-70ac-98db-06001d89727c€49.00€0.67matched
17capture01a19a58-c6a7-7e5e-bb7b-f1c66e10431a€49.00€0.67matched
18capture01a19a58-e4c5-71bb-a64f-e5e4fc6f702e€15.00€0.26matched
19capture01a19a59-1e44-7cdd-ba3f-00b1ee1792c5€49.00€0.67matched
20capture01a19a59-2a67-7a7d-a0b3-d17b39354d81€49.00€0.67matched
21capture01a19a59-38c3-74c3-b942-d59bd1fa6ad7€35.00€0.50matched
22capture01a19a59-5e0c-7c96-a80e-78f137191ebe€9.00€0.19matched
23capture01a19a59-6191-7d5d-8466-50774bb0ae18€24.00€0.37matched
24refund01a19a59-903d-78ec-b4d6-c0b877070929-€41.00€0.00matched
25capture01a19a59-9b23-7c05-8606-c4fde826b9e0€24.00€0.37matched
26capture01a19a59-b725-7c34-8d22-ae4498ad2901€9.00€0.19matched
27capture01a19a59-d8d3-707a-8f3b-5f16b4480ef1€24.00€0.37matched
28capture01a19a59-e847-74bd-a9b7-c4f1d6ec986d€35.00€0.50matched
30capture01a19a5a-092f-7dff-aa67-f922b8aec2b0€24.00€0.37matched
31capture01a19a5a-1d21-75a5-9b39-90f611beac8a€49.00€0.67matched
32capture01a19a5a-1e66-7c7c-88d6-19be0dd58a99€15.00€0.26matched
33capture01a19a5a-231f-7ff7-b8ee-f5738ed546a8€9.00€0.19matched
34capture01a19a5a-239e-7cd5-ab3f-bd3c6936fbf3€49.00€0.67matched
35capture01a19a5a-44e1-7421-85ed-40a463e39542€24.00€0.37matched
36refund01a19a5a-4f2d-7972-bcc5-000434553d1a-€35.00€0.00matched
37refund01a19a5a-5379-7cf8-b90f-40068ad040a9-€14.00€0.00matched
38capture01a19a5a-729f-7455-bea6-812bc10efbb2€15.00€0.26matched
39capture01a19a5a-7cba-7f61-acd1-533cf31bee4c€9.00€0.19matched
40capture01a19a5a-9eaa-7de6-828c-0441b60019b7€49.00€0.67matched
41capture01a19a5a-a10b-7691-9ce6-78fd8da818b5€24.00€0.37matched
42capture01a19a5a-bdcb-78b5-9220-9d661923ca90€49.00€0.67matched
43capture01a19a5a-cb02-702a-8f2f-026bf085af34€24.00€0.37matched
44capture01a19a5a-d6fe-769c-aab7-077c99cd2eee€15.00€0.26matched
45capture01a19a5a-e3d1-773f-b448-07c29ce80379€35.00€0.50matched
46capture01a19a5a-fd53-7789-a7c5-558d7f5fb3b2€24.00€0.37matched
47refund01a19a5b-03ac-7555-8ce9-cd3c994d83d2-€30.00€0.00matched
48capture01a19a5b-0dcb-78e7-a9bc-75bbc2d99d42€24.00€0.37matched
49capture01a19a5b-1561-791a-a0b5-ba9741b82681€15.00€0.26matched
50capture01a19a5b-1ac0-7340-8fdf-b2a2417ba378€15.00€0.26matched
51capture01a19a5b-57bb-785b-88e9-d10468837f10€49.00€0.67matched
52refund01a19a5b-638b-76df-9d77-bb7d301df9ca-€15.00€0.00matched
53capture01a19a5b-7eac-7bc8-a2fd-1844f5d2c80b€35.00€0.50matched
54capture01a19a5b-a814-75f5-b8bf-9f9f563dd1a6€15.00€0.26matched
55capture01a19a5b-c6ad-7f6d-bc94-849dfc2cf53f€24.00€0.37matched
56capture01a19a5b-d4ce-7557-91c0-8c3c1d7a447a€24.00€0.37matched
57capture01a19a5c-0773-7ea2-95b8-29ee5a409ef5€35.00€0.50matched
58capture01a19a5c-1447-7332-b1f4-45feaf1e5c9e€9.00€0.19matched
59refund01a19a5c-22da-7860-856f-be6bccbd460b-€11.00€0.00matched
60capture01a19a5c-268c-7d5b-a7b5-4ead6db806bf€35.00€0.50matched
61capture01a19a5c-2d73-79ee-b8ca-969ee7540d77€15.00€0.26matched
62capture01a19a5c-479a-7e58-9734-3cf9cb26424b€49.00€0.67matched
63capture01a19a5c-4d4c-7fc5-8585-88f9b91dd7c4€15.00€0.26matched
64capture01a19a5c-635b-77a1-bfeb-07b6e334c33a€24.00€0.37matched
65capture01a19a5c-668a-788f-8f55-76baca76d768€15.00€0.26matched
66capture01a19a5c-8059-7d3d-9a9f-20d7ad411a36€35.00€0.50matched
67refund01a19a5c-9288-7e9d-ac5b-8f3b9d370c51-€9.00€0.00matched
68capture01a19a5c-93d2-7b9a-83a4-59d34188f6bb€24.00€0.37matched
69capture01a19a5c-96e5-78fc-9d1a-d628043ae5fb€24.00€0.37matched
70capture01a19a5c-b0d2-7f06-8ef3-99d06cdaf399€24.00€0.37matched
71capture01a19a5c-cdc2-739e-ae0b-a731a027f2a2€9.00€0.19matched
72capture01a19a5c-e2c5-77e7-9809-814e869081cc€35.00€0.50matched
73capture01a19a5c-e834-7917-b84a-b54920622ac9€35.00€0.50matched
74capture01a19a5c-eaf2-7d6c-8b85-e016d70a5c33€35.00€0.50matched
75capture01a19a5c-eebe-7a86-b8ad-3028eb3859bd€24.00€0.37matched
76capture01a19a5c-fd97-7a05-89a5-88a36f92fb7b€35.00€0.50matched
77capture01a19a5d-0c22-7386-96c6-75a4a756131c€9.00€0.19matched
78capture01a19a5d-0db8-75a5-8ddb-6ec7bf9c0ae9€24.00€0.37matched
79capture01a19a5d-36c2-7175-8e84-4f7c2adbb591€49.00€0.67matched
80capture01a19a5d-3ea3-7b93-9694-f9e3bfcfe9ad€24.00€0.37matched
81capture01a19a5d-42d6-7d82-89aa-1253a31f5418€35.00€0.50matched
82capture01a19a5d-45a4-7071-8b9b-6dc1772c7b7d€24.00€0.37matched
83capture01a19a5d-60a5-7648-b37a-d91813aa1992€24.00€0.37matched
84capture01a19a5d-80f1-7e44-b196-8f728e3499f9€15.00€0.26matched
85capture01a19a5d-8db4-7544-8336-881ac812ee27€15.00€0.26matched
86capture01a19a5d-ad49-7ea3-93b6-23540283e750€9.00€0.19matched
87capture01a19a5d-d232-7c74-a23d-ca649016400c€24.00€0.37matched
88capture01a19a5d-d268-7d61-ac88-ed64165a44b6€49.00€0.67matched
89capture01a19a5d-cdc1-73c1-ad14-991d330f5d81€24.00€0.37matched
90capture01a19a5d-da33-7dc7-a03f-9045508139cb€24.00€0.37matched
91capture01a19a5d-ea95-7e73-a004-83a2c3927943€24.00€0.37matched
92capture01a19a5d-ebfc-7d29-8b0d-c9a02ea06774€24.00€0.37matched
93capture01a19a5e-0421-73ca-acd8-b91d90f06f2e€24.00€0.37matched
94refund01a19a5e-26ec-7271-a23c-8344180c9dfc-€20.00€0.00matched
95capture01a19a5e-3401-7225-955d-2f88f427d65e€49.00€0.67matched
96capture01a19a5e-3a16-79dd-94c2-0f86ae368d87€9.00€0.19matched
97capture01a19a5e-4c59-7d18-b88c-771ed93bca07€49.00€0.67matched
98capture01a19a5e-5b21-7dc4-a246-c0c41f2975d0€35.00€0.50matched
99capture01a19a5e-7da9-7e5e-9965-15b51f8ebf7e€9.00€0.19matched
100capture01a19a5e-942d-779d-b307-28cff8dd113a€49.00€0.67matched
101capture01a19a5e-d992-74f0-9520-c85f88438b8b€9.00€0.19matched
102capture01a19a5e-e207-7a78-9498-d17b1164407b€24.00€0.37matched
103capture01a19a5e-f275-7865-8194-36f9e22af516€49.00€0.67matched
104capture01a19a5f-22e4-7d07-bb31-c514d8427b34€49.00€0.67matched
105capture01a19a5f-2bd8-769e-87e2-e1173d454ad8€24.00€0.37matched
106capture01a19a5f-33d6-74fe-957c-ec45c411f805€15.00€0.26matched
107capture01a19a5f-49aa-7f03-9480-6331007aebf4€15.00€0.26matched
108capture01a19a5f-6498-7fdf-a4a7-ff9013e01ff4€49.00€0.67matched
109refund01a19a5f-6c0a-7453-b8ad-09616c0b7aab-€42.00€0.00matched
110capture01a19a5f-7eaf-7a8e-8e74-56f721cc49eb€15.00€0.26matched
111capture01a19a5f-980e-7096-a19e-2139866c6cfe€15.00€0.26matched
112capture01a19a5f-a44f-715a-95e4-1b4d40f15109€9.00€0.19matched
113capture01a19a5f-a884-7816-8335-02a51f03efca€24.00€0.37matched
114capture01a19a5f-af72-7aa6-abbd-516c6e3b60ae€15.00€0.26matched
115refund01a19a5f-b64b-76e8-b3f5-403ebbc41a13-€4.00€0.00matched
116capture01a19a5f-dfe1-7062-a35a-342b63598745€9.00€0.19matched
117capture01a19a5f-eed1-75c9-9a31-3c57d33cf5ce€24.00€0.37matched
118refund01a19a60-077b-7f2d-a7e5-24ed620a645a-€9.00€0.00matched
119capture01a19a60-1841-782b-9bdb-2c03d1e8bbeb€15.00€0.26matched
120capture01a19a60-1e43-7404-b736-140f0d883895€15.00€0.26matched
121capture01a19a60-135f-762d-92f3-942ca09c163c€35.00€0.50matched
122capture01a19a60-32ab-7eaa-8a4c-605ea39befeb€49.00€0.67matched
123capture01a19a60-3c97-774a-9ca5-6eb27d336f1e€15.00€0.26matched
124capture01a19a60-3e66-7cbd-bccb-410ad9343eba€9.00€0.19matched
125capture01a19a60-4963-7046-b1f2-70351ca2773a€24.00€0.37matched
126capture01a19a60-9675-77d0-a12c-9ffca47fb986€35.00€0.50matched
127capture01a19a60-a1d5-7723-a8f0-18cbc6a3fe10€15.00€0.26matched
128capture01a19a60-cf28-7a70-8f18-c7f330da0df3€24.00€0.37matched