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

Gross

€3,152.00

PSP fee

€49.83

Net to the bank

€3,102.17

Settlement journal

#411142

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1af82-9336-78f7-879c-019f12819478 is already settled by stl_EUR_2989909 line 120
  • missing linein the books, not in the filecapture:01a1af7e-32e7-7a1a-af7f-776f923e8006 is in no file
LineKindReferenceGrossFeeStatus
121capture01a1af82-93a2-7465-8c4e-2ce3bec258ee€9.00€0.19duplicate line
1capture01a1af73-1986-7532-aef9-7f033715ea3a€9.00€0.19matched
2capture01a1af73-46d5-7ea3-bd12-317e57360615€9.00€0.19matched
3refund01a1af73-c44a-729d-9ae2-65653d311c82-€32.00€0.00matched
4capture01a1af7a-7780-75e8-b7e0-30be9bfdf84e€9.00€0.19matched
5capture01a1af7a-7991-7c7b-8cf9-01e2d435dbb0€9.00€0.19matched
6capture01a1af7a-7fe6-75aa-8bad-8d1022bfe320€35.00€0.50matched
7capture01a1af7a-930b-78ed-a947-e6c395713964€24.00€0.37matched
8refund01a1af7a-a7c3-78ad-b532-28d5aedb9c57-€6.00€0.00matched
9capture01a1af7a-b042-78f5-a594-769ed8ca9ecc€15.00€0.26matched
10capture01a1af7a-b974-7e0a-99ef-d1702a760d61€49.00€0.67matched
11capture01a1af7a-e72e-7c83-adfb-5d8cd4646345€35.00€0.50matched
12capture01a1af7a-f096-735d-9414-91faef558203€49.00€0.67matched
13capture01a1af7a-f229-715a-90bc-d35a90442d00€49.00€0.67matched
14capture01a1af7b-2250-72a9-b24b-91ba7a7d67d4€15.00€0.26matched
15capture01a1af7b-3341-7d64-9184-3990ded7282b€35.00€0.50matched
16capture01a1af7b-3725-76a4-bf07-b56864ddbc4e€35.00€0.50matched
17capture01a1af7b-40b1-79d8-8a84-809bc55bb8b8€24.00€0.37matched
18capture01a1af7b-5b05-7632-8663-f76749f9596b€9.00€0.19matched
19capture01a1af7b-9989-7c6b-a494-e1e5aad687e5€15.00€0.26matched
20capture01a1af7b-bb1e-7f02-a9bf-4554b50d4b3d€15.00€0.26matched
21capture01a1af7b-bb8e-7f9d-9ace-7c2e68730483€15.00€0.26matched
22capture01a1af7b-d7cb-77d5-9be3-1ee050aa5e6c€49.00€0.67matched
23capture01a1af7b-db79-7a9a-9587-1b499fe9a70f€9.00€0.19matched
24capture01a1af7b-efaa-7678-90f1-3a9287714b40€35.00€0.50matched
25capture01a1af7c-0007-7bcf-8d95-0dc27b1382d6€9.00€0.19matched
26refund01a1af7c-0de4-7447-a269-b1778fb69b45-€4.00€0.00matched
27capture01a1af7c-22c7-7d4f-8518-6ceee4e12c7c€9.00€0.19matched
28capture01a1af7c-25cf-755f-af4c-95f07977fee3€24.00€0.37matched
29capture01a1af7c-2ed2-7d11-bde8-7229468d7840€35.00€0.50matched
30capture01a1af7c-36e4-7409-8966-f8b08882d563€24.00€0.37matched
31capture01a1af7c-542d-771c-a017-7c3d8e2cc446€24.00€0.37matched
32capture01a1af7c-8d2f-7f39-afd4-cd92021f8e8a€49.00€0.67matched
33capture01a1af7c-a0e7-7d9d-8328-0ba41703e1ab€9.00€0.19matched
34capture01a1af7c-cbb2-70c7-9229-2a08d3aa8919€15.00€0.26matched
35capture01a1af7c-cd44-78be-9639-47f7cffdd56f€49.00€0.67matched
36capture01a1af7c-e965-7e43-9454-0fa64719d7fd€35.00€0.50matched
37capture01a1af7d-16a4-730b-b635-117c65915f47€24.00€0.37matched
38capture01a1af7d-4b19-7a29-9852-66fb4c6f142c€35.00€0.50matched
39capture01a1af7d-5c5b-7263-90ef-45c7cd317ba5€9.00€0.19matched
40capture01a1af7d-68f4-79b9-b390-aa972e6e42c1€24.00€0.37matched
41capture01a1af7d-6a1d-7b27-b8fb-7ca1ad214073€15.00€0.26matched
42capture01a1af7d-b72b-7349-a57b-bacdfde9aac5€15.00€0.26matched
43capture01a1af7d-baba-7202-b08f-ceb1ed8c8fbb€15.00€0.26matched
44capture01a1af7d-d872-77c7-a905-516d8899e0c5€49.00€0.67matched
45capture01a1af7d-db1e-7a1f-9765-85fb40eaae88€35.00€0.50matched
46capture01a1af7d-eca1-7296-ad23-42f86276a787€49.00€0.67matched
47capture01a1af7e-0f29-71c1-8a1d-713525589161€49.00€0.67matched
48capture01a1af7e-11f7-7cda-aed0-0a20574b8410€24.00€0.37matched
49capture01a1af7e-2ace-7f89-926b-b5ca35c30717€49.00€0.67matched
50refund01a1af7e-2fac-7127-9435-266cfcda506f-€32.00€0.00matched
51capture01a1af7e-2fef-7533-abbe-021629bbbaac€9.00€0.19matched
52capture01a1af7e-40a2-7a80-91d6-a1703784f05a€35.00€0.50matched
53capture01a1af7e-8c21-721e-b329-20291885726e€24.00€0.37matched
54capture01a1af7e-8e6d-7285-afff-cc8c8af45bd2€15.00€0.26matched
55capture01a1af7e-a777-795f-a9e5-eec456e437bd€35.00€0.50matched
56capture01a1af7e-b107-701e-bb6c-2b4c738a94e6€9.00€0.19matched
57capture01a1af7e-b481-77e8-8e14-0c7015a9075d€49.00€0.67matched
58capture01a1af7e-b886-7c0f-bafc-c8cb920e7988€49.00€0.67matched
59capture01a1af7e-ced6-7bc9-8793-1ca7db88a595€24.00€0.37matched
60capture01a1af7e-eb5e-7b90-8b84-9df1b45f8f4a€15.00€0.26matched
61capture01a1af7f-05a1-7908-93ac-9db4391abe9d€15.00€0.26matched
62capture01a1af7f-0395-7709-84a9-7699db229405€49.00€0.67matched
63capture01a1af7f-105f-7ca8-acc5-4ad02aba8617€9.00€0.19matched
64capture01a1af7f-2187-74cd-908f-d8ddf867eb23€49.00€0.67matched
65capture01a1af7f-2f57-77b7-83d2-2121d8c91707€24.00€0.37matched
66capture01a1af7f-3609-729d-980d-f5735b969454€9.00€0.19matched
67capture01a1af7f-4f3a-7d54-8cf7-bdf2563348d9€49.00€0.67matched
68capture01a1af7f-513b-7ea7-8d5f-e741bb52a04b€15.00€0.26matched
69capture01a1af7f-5b7f-7bb3-9d0f-93921c7bcaf5€24.00€0.37matched
70capture01a1af7f-5eb7-7a87-9ee3-3920bab2b372€35.00€0.50matched
71capture01a1af7f-76eb-794e-af46-4aff99c02de3€9.00€0.19matched
72capture01a1af7f-88c8-7d95-bf2a-4d28587cf024€9.00€0.19matched
73capture01a1af7f-908a-7ca8-ab40-0420e7a8d059€15.00€0.26matched
74capture01a1af7f-9fe9-7e5d-92f5-9ae857095cc4€15.00€0.26matched
75capture01a1af7f-b525-7231-b9f8-8a48533db8c1€9.00€0.19matched
76capture01a1af7f-ba3e-70e8-bd84-a536029fe01e€24.00€0.37matched
77capture01a1af7f-ba94-77f6-9e80-05977bb1a635€15.00€0.26matched
78capture01a1af7f-bb45-7648-8e57-4b665a139042€35.00€0.50matched
79capture01a1af7f-c23e-7b4a-bafe-b88fd2dd2e2d€24.00€0.37matched
80capture01a1af7f-f549-752b-84f6-2132464df460€35.00€0.50matched
81capture01a1af80-032b-7d4a-9313-325dd7dc5132€49.00€0.67matched
82capture01a1af80-04d9-7329-a0cb-67eaa3657ad0€49.00€0.67matched
83capture01a1af80-07c3-7474-b06d-3f48d970c379€49.00€0.67matched
84capture01a1af80-088a-7eee-9cc1-5935f0921935€35.00€0.50matched
85refund01a1af80-0d0c-7176-8c3e-09569231e74b-€14.00€0.00matched
86capture01a1af80-0edd-7d98-8276-ddbbebf5d21e€15.00€0.26matched
87capture01a1af80-18ed-7719-962e-6f141a93347f€9.00€0.19matched
88capture01a1af80-2677-70d3-ae21-cecabde65ac0€9.00€0.19matched
89refund01a1af80-2e7d-709f-b52d-91ee74c45aef-€11.00€0.00matched
90capture01a1af80-795d-7cc1-9457-13732ccb70b1€35.00€0.50matched
91capture01a1af80-818d-75c1-b08f-c95973dbf1c1€49.00€0.67matched
92capture01a1af80-880f-7795-8875-576f4156cba7€9.00€0.19matched
93capture01a1af80-8c8c-7c61-b214-76159b2f967d€24.00€0.37matched
94capture01a1af80-9999-7f8b-a09d-2080a8bce7e5€15.00€0.26matched
95capture01a1af80-b916-79f1-9705-8b58f760aefd€15.00€0.26matched
96refund01a1af80-c729-7d68-ab38-ffd446ee37f3-€22.00€0.00matched
97capture01a1af80-de5e-76f4-8bbc-5b600228ff06€9.00€0.19matched
98capture01a1af80-e9db-742e-be7a-d5689db3e925€49.00€0.67matched
99refund01a1af80-fbd2-7e76-b6a9-e175008372c8-€7.00€0.00matched
100capture01a1af81-0176-7b6e-87c7-5b4fecbc5cdf€35.00€0.50matched
101capture01a1af81-10a3-70b7-8cdc-f1e06575e735€35.00€0.50matched
102capture01a1af81-6345-7166-8712-96d09529b1a3€15.00€0.26matched
103capture01a1af81-772f-7d14-8f45-68f137d17415€24.00€0.37matched
104capture01a1af81-7879-7de6-a7d6-1816a2f4b088€35.00€0.50matched
105capture01a1af81-97da-71fd-998d-3ab527f029d2€9.00€0.19matched
106capture01a1af81-9a5c-7656-9a3e-68496b78f906€15.00€0.26matched
107capture01a1af81-a31b-7529-a839-871c00a44850€24.00€0.37matched
108capture01a1af81-f090-7615-a89a-48353f0377d2€49.00€0.67matched
109capture01a1af82-07d8-78c0-ad98-783d8fe77378€24.00€0.37matched
110capture01a1af82-14a2-729c-a36c-a2bc6034224c€49.00€0.67matched
111capture01a1af82-14f2-7870-9480-055ced4a8708€35.00€0.50matched
112capture01a1af82-1b96-7a4a-b0a4-16fb4bbb8469€35.00€0.50matched
113capture01a1af82-1fcf-7e13-823e-bd80b7e4ea1b€9.00€0.19matched
114capture01a1af82-2c41-7caa-8265-9ace742bfc03€35.00€0.50matched
115capture01a1af82-3fbc-7863-a15f-0206d782f32e€9.00€0.19matched
116capture01a1af82-5296-7fe7-b290-3a2064ea3cf9€9.00€0.19matched
117capture01a1af82-55f7-7577-b66f-baf4ef632f7a€9.00€0.19matched
118capture01a1af82-58d4-7686-8028-044a62e91e05€9.00€0.19matched
119capture01a1af82-7206-7cbc-8132-b5478ad9978b€35.00€0.50matched
120capture01a1af82-93a2-7465-8c4e-2ce3bec258ee€9.00€0.19matched
122capture01a1af82-a9bb-76da-93d0-9a27b0e5ff7a€9.00€0.19matched
123capture01a1af82-aff9-7a7c-ac3b-a766ecf5542c€35.00€0.50matched
124capture01a1af82-b935-720f-afac-eca435152d18€24.00€0.37matched
125capture01a1af82-c3d6-7637-8dca-23ea76fb204c€49.00€0.67matched
126refund01a1af82-f455-76e2-ac75-b7d9e1090f9a-€13.00€0.00matched
127capture01a1af83-0e7e-7a37-9511-b70efdf8f3fd€9.00€0.19matched
128capture01a1af83-1f28-70ef-8f88-ae7c523fb865€24.00€0.37matched
129capture01a1af83-1fbe-7899-9d64-1feb61917e48€24.00€0.37matched
130capture01a1af83-3c63-7478-b89e-cd7fce486353€24.00€0.37matched
131capture01a1af83-4a8f-7a02-b08d-0500f27383d4€15.00€0.26matched
132capture01a1af83-4b49-74cc-8378-d1829fc85c82€35.00€0.50matched
133capture01a1af83-6057-798c-b17c-f4a10990ac6b€49.00€0.67matched
134capture01a1af83-8283-7fe1-b9df-d9c05cd0f86e€35.00€0.50matched
135capture01a1af83-8f37-77ac-85e6-da01ae224ba2€35.00€0.50matched
136capture01a1af83-9605-77f0-8dba-e15f90e608e6€35.00€0.50matched