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

Gross

€3,169.00

PSP fee

€48.92

Net to the bank

€3,120.08

Settlement journal

#415975

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b0ce-b6f6-7dd5-aabc-d9e9fe4904fb is already settled by stl_EUR_2989946 line 24
  • duplicate linethe file lists it twicecapture:01a1b0d4-a601-7d4b-a28e-e732eb1e03d2 is already settled by stl_EUR_2989946 line 103
  • duplicate linethe file lists it twicecapture:01a1b0d5-ade5-79c9-ba8f-428f8d3374c1 is already settled by stl_EUR_2989946 line 123
  • missing linein the books, not in the filerefund:01a1b0ce-250c-7ce9-803d-e732699a5eec is in no file
  • missing linein the books, not in the filecapture:01a1b0d5-2f57-7110-a841-b24892a0357c is in no file
LineKindReferenceGrossFeeStatus
25capture01a1b0ce-b718-7746-8e3a-dff9dea5960d€24.00€0.37duplicate line
104capture01a1b0d4-a620-71c2-a25f-afb03908de43€49.00€0.67duplicate line
124capture01a1b0d5-cee3-779e-88d7-0cc07eb151ea€49.00€0.67duplicate line
1capture01a1b0c4-7a50-7eb1-b984-cbc186748d47€24.00€0.37matched
2capture01a1b0c8-5920-7195-9aab-9145e2826b5f€9.00€0.19matched
3capture01a1b0ca-0453-73ce-882d-792038b01fdc€35.00€0.50matched
4capture01a1b0cb-83e0-7d4a-86d6-fd77dbcc23df€15.00€0.26matched
5refund01a1b0cb-b8a2-7ce9-8117-bf835bc124fe-€20.00€0.00matched
6capture01a1b0cd-43d5-7fff-9119-e3594ccb1dd6€15.00€0.26matched
7capture01a1b0cd-58e1-7601-a35d-7e8f64273b9a€9.00€0.19matched
8capture01a1b0cd-7f61-7f81-b492-d7c5a537cdd1€35.00€0.50matched
9capture01a1b0cd-814b-713e-8773-4e53c62e5c70€35.00€0.50matched
10capture01a1b0cd-9ba7-71e8-b85d-96926023e5ba€15.00€0.26matched
11refund01a1b0cd-b0cd-7dd1-a7ac-ffc211cda0ec-€5.00€0.00matched
12capture01a1b0cd-b895-7ca1-bff4-619848c17222€24.00€0.37matched
13capture01a1b0cd-c8a3-791f-ba63-c17d79084e5e€24.00€0.37matched
14capture01a1b0cd-ca5b-7461-bfcc-83c9dd423bfa€49.00€0.67matched
15capture01a1b0cd-d47c-7e1f-b6b5-6273de1a57cb€35.00€0.50matched
16capture01a1b0cd-f633-78e9-8748-c28695611b26€35.00€0.50matched
17capture01a1b0ce-22f3-7148-a31e-23058b502680€24.00€0.37matched
18capture01a1b0ce-2cd1-7459-8e8e-e2c895461542€49.00€0.67matched
19capture01a1b0ce-3952-7fd3-9352-3f835caf9e4c€15.00€0.26matched
20capture01a1b0ce-7b06-79c8-b1c2-732544c4541f€24.00€0.37matched
21capture01a1b0ce-8b98-792a-acc6-e37a728b703c€24.00€0.37matched
22capture01a1b0ce-93e1-7998-b73e-52eb260ed1cb€35.00€0.50matched
23capture01a1b0ce-abe9-71d1-a031-d4327c0b6c6b€24.00€0.37matched
24capture01a1b0ce-b718-7746-8e3a-dff9dea5960d€24.00€0.37matched
26capture01a1b0ce-c807-7a98-9128-f706915b8bc4€35.00€0.50matched
27capture01a1b0ce-c88f-7272-b5db-a4bf2692d08c€15.00€0.26matched
28capture01a1b0ce-e806-7b77-824f-333b469b0782€35.00€0.50matched
29capture01a1b0ce-f3ff-747e-a73a-2cd152aa5a44€24.00€0.37matched
30capture01a1b0cf-08fd-758a-8415-975e275d3348€15.00€0.26matched
31capture01a1b0cf-1c22-7d1b-b7b9-fcc96a464785€35.00€0.50matched
32capture01a1b0cf-3572-7519-a2c8-4506d703c7b2€35.00€0.50matched
33capture01a1b0cf-46a2-7fa1-81bf-14cbaba22c70€49.00€0.67matched
34capture01a1b0cf-5a6d-7eac-85c2-c33179cb1fcc€24.00€0.37matched
35capture01a1b0cf-5a73-71c5-b577-4b943720cfb7€49.00€0.67matched
36capture01a1b0cf-68d1-75f0-a463-290a65b94538€9.00€0.19matched
37capture01a1b0cf-8c13-7840-bcec-7166ae12658c€35.00€0.50matched
38capture01a1b0cf-dd42-7932-bfc6-77b4e383a216€15.00€0.26matched
39capture01a1b0cf-e092-74a8-bedb-45b4fa56a77d€49.00€0.67matched
40capture01a1b0d0-04f0-709e-a69b-f20f428d6f1e€35.00€0.50matched
41capture01a1b0d0-1bbc-7b28-9e2c-51952eafc9e1€9.00€0.19matched
42capture01a1b0d0-1cf9-7e23-82ce-c94cf6583a02€15.00€0.26matched
43capture01a1b0d0-2577-73f1-81e7-044ff32e3522€9.00€0.19matched
44capture01a1b0d0-2f40-7710-bed1-c6692194f193€15.00€0.26matched
45capture01a1b0d0-3569-79e9-97ef-0c54c8385610€49.00€0.67matched
46capture01a1b0d0-415f-71e2-8ee1-a6dd2c516197€15.00€0.26matched
47capture01a1b0d0-41bd-7a04-9ab7-127fe37f9a53€49.00€0.67matched
48capture01a1b0d0-59a7-745b-959c-58aa12e78c5e€49.00€0.67matched
49capture01a1b0d0-7b58-796a-9bbf-99f990860079€35.00€0.50matched
50capture01a1b0d0-7dc1-7260-b2a3-44ced00db7a0€49.00€0.67matched
51capture01a1b0d0-8be9-7412-a1b0-1a7fc6e9fbac€49.00€0.67matched
52capture01a1b0d0-8e4c-7be6-a454-737b70c39071€24.00€0.37matched
53refund01a1b0d0-92f0-7cda-9be3-01d185d777ad-€3.00€0.00matched
54capture01a1b0d0-9742-7721-8f0a-140548db5693€24.00€0.37matched
55capture01a1b0d0-a2a2-7802-87af-42811d933d70€35.00€0.50matched
56capture01a1b0d0-cee8-7b74-a560-e476b338531b€15.00€0.26matched
57capture01a1b0d0-de76-7168-87b7-08a5bcc46031€15.00€0.26matched
58capture01a1b0d0-f209-770b-976a-7392556cee87€49.00€0.67matched
59capture01a1b0d1-1774-7a72-96cf-237227f8d02b€9.00€0.19matched
60capture01a1b0d1-1d7c-7004-9392-7b74d3259079€15.00€0.26matched
61capture01a1b0d1-1a42-7a8c-ab2e-8c673ad13e47€24.00€0.37matched
62capture01a1b0d1-2e0b-7f78-b328-d0c924ac3bc4€24.00€0.37matched
63capture01a1b0d1-3c1d-7a88-805a-c75ab412bece€24.00€0.37matched
64capture01a1b0d1-54e4-77b3-8bcc-a33ea43a09d0€49.00€0.67matched
65capture01a1b0d1-5a59-7c67-b909-2be2d8f620dc€49.00€0.67matched
66capture01a1b0d1-7d27-752a-b81a-64250b118d6c€49.00€0.67matched
67capture01a1b0d1-7fe9-7158-923a-f317ebe69b9b€15.00€0.26matched
68capture01a1b0d1-917b-7ef4-8ab6-4b9ca6748a99€49.00€0.67matched
69capture01a1b0d1-9acf-7825-a80c-f12697eae3c1€49.00€0.67matched
70capture01a1b0d1-9ed5-7b87-b98b-3d3856b36f2b€24.00€0.37matched
71capture01a1b0d1-b7d0-705c-87c5-9501fcb089e4€9.00€0.19matched
72capture01a1b0d1-e53c-7daa-8ffa-54a3bdc34034€35.00€0.50matched
73capture01a1b0d1-f611-71d3-bc91-160ed6736faf€9.00€0.19matched
74capture01a1b0d2-0d27-7fe9-b850-c1c275bf7070€24.00€0.37matched
75capture01a1b0d2-1201-7f02-aa98-b6d2bea9f59f€49.00€0.67matched
76capture01a1b0d2-2057-7db9-a619-f1ae44fb0b61€15.00€0.26matched
77capture01a1b0d2-617f-74af-975c-9aa82b5a51f1€24.00€0.37matched
78refund01a1b0d2-8578-7968-a30d-3056638d6f1c-€13.00€0.00matched
79capture01a1b0d2-8fa0-737d-a5eb-35e4ff56b3b0€15.00€0.26matched
80capture01a1b0d2-a3e6-71cb-a6b6-d0953558bccf€35.00€0.50matched
81capture01a1b0d2-bb23-7b46-9bee-70f741957b93€24.00€0.37matched
82capture01a1b0d3-48ac-7837-ab19-c57aab2fd82a€35.00€0.50matched
83capture01a1b0d3-6cdb-7e9f-8c52-59ccf1cb6704€35.00€0.50matched
84capture01a1b0d3-6d36-7802-bfed-d9ab3ed56a4b€9.00€0.19matched
85capture01a1b0d3-7e15-781f-8989-07407f91b598€49.00€0.67matched
86capture01a1b0d3-9565-70e9-9934-e13e2f8aca5d€24.00€0.37matched
87capture01a1b0d3-9ed3-743f-b07a-b5c9855e26ea€35.00€0.50matched
88capture01a1b0d3-9f2f-769f-8d81-68bdd1333b93€35.00€0.50matched
89refund01a1b0d3-becf-70a1-bc25-7a86bc2ff6ad-€13.00€0.00matched
90refund01a1b0d3-d411-714f-8f0a-4d6efe99f9a9-€11.00€0.00matched
91capture01a1b0d3-ec3b-7f1c-a842-04428025f6f6€9.00€0.19matched
92capture01a1b0d3-fb66-76ef-aac7-fa2db01120ee€15.00€0.26matched
93capture01a1b0d4-0b95-7287-b4c3-d60ec8cd4368€24.00€0.37matched
94capture01a1b0d4-0ce2-765b-957e-ce38c4bb7641€9.00€0.19matched
95refund01a1b0d4-3e8b-7ccf-8413-5e65f52c9234-€21.00€0.00matched
96capture01a1b0d4-4fd7-7490-ad15-3f4fc85ed1ea€15.00€0.26matched
97capture01a1b0d4-5585-7721-9e37-1fd0645aee87€24.00€0.37matched
98capture01a1b0d4-7618-74ff-b577-e9287a15da3c€35.00€0.50matched
99capture01a1b0d4-777c-74d8-871c-b6ad8bfc9b83€24.00€0.37matched
100capture01a1b0d4-9543-7113-aa9a-a0d68144b03b€9.00€0.19matched
101capture01a1b0d4-9bf0-7833-bac6-363d6be64d05€15.00€0.26matched
102capture01a1b0d4-a558-745a-a326-23c97fc8f45e€15.00€0.26matched
103capture01a1b0d4-a620-71c2-a25f-afb03908de43€49.00€0.67matched
105capture01a1b0d4-c03a-7057-afef-34b53481f6e7€24.00€0.37matched
106refund01a1b0d4-c926-7220-bbf1-2d5f1ade458f-€13.00€0.00matched
107capture01a1b0d4-d96c-7c1f-baa3-e38d1a9d973e€24.00€0.37matched
108capture01a1b0d4-db55-7c22-b162-b08139e72b53€9.00€0.19matched
109capture01a1b0d4-ea81-7080-a7c1-050903191b31€15.00€0.26matched
110capture01a1b0d4-f3d7-74d1-9382-2860b42d7e03€9.00€0.19matched
111capture01a1b0d4-ff27-7768-be0c-5dac88fd0949€15.00€0.26matched
112capture01a1b0d5-22af-750b-b924-b1be7ba7cd5c€49.00€0.67matched
113capture01a1b0d5-3704-7f98-b59b-8fbf82e447e3€35.00€0.50matched
114capture01a1b0d5-452a-7762-99dd-8d587d357dd0€49.00€0.67matched
115capture01a1b0d5-7aef-77cd-8de7-1180d605a26d€15.00€0.26matched
116capture01a1b0d5-7bfe-7799-9b55-deb60264e966€15.00€0.26matched
117capture01a1b0d5-7fbf-7512-8ade-05b160095ef8€9.00€0.19matched
118capture01a1b0d5-8f0b-7e5d-abea-b1c7fd83248e€35.00€0.50matched
119capture01a1b0d5-9be3-7f2e-a623-3db14e6626b7€15.00€0.26matched
120capture01a1b0d5-c5ad-70c5-a848-3b507160287e€35.00€0.50matched
121refund01a1b0d5-c70c-7039-ab79-1e404fd2b851-€11.00€0.00matched
122capture01a1b0d5-ca16-72c1-90b4-7db3786701fb€24.00€0.37matched
123capture01a1b0d5-cee3-779e-88d7-0cc07eb151ea€49.00€0.67matched
125capture01a1b0d5-d97c-7326-96b0-f0a40e1acefc€35.00€0.50matched
126capture01a1b0d5-d7db-7da1-9870-f800c70d09fb€35.00€0.50matched
127capture01a1b0d6-1ded-7999-ac10-f621c7aba580€35.00€0.50matched