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

Gross

€3,012.00

PSP fee

€50.12

Net to the bank

€2,961.88

Settlement journal

#380708

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a6f2-1eab-7207-85b3-97851c6610ad is already settled by stl_EUR_2989670 line 56
  • fee differencethe fee is not the contract feethe fee is 69, the contract says 67
  • missing linein the books, not in the filecapture:01a1a6f0-9394-70d3-ace1-fab84abedc33 is in no file
LineKindReferenceGrossFeeStatus
3capture01a1a6e8-89f0-7405-9814-02d6b4edf150€24.00€0.37duplicate line
6capture01a1a6ee-8613-70c3-bae4-24e91d2e9d1c€49.00€0.69fee difference
57capture01a1a6f2-1edc-770c-89ab-5a81d4f0e55b€35.00€0.50duplicate line
1capture01a1a6e8-5276-7dfc-825a-adb55bd0e5e3€35.00€0.50matched
2capture01a1a6e8-89f0-7405-9814-02d6b4edf150€24.00€0.37matched
4capture01a1a6e9-64d9-74aa-a749-219a54e5dda0€35.00€0.50matched
5refund01a1a6ee-5884-78b0-b876-7abaaa49c82b-€18.00€0.00matched
7capture01a1a6ee-87e5-7dee-8bd2-62e60854b97d€35.00€0.50matched
8capture01a1a6ee-887a-7666-adb5-e87be14e1974€49.00€0.67matched
9capture01a1a6ee-9fa0-7812-a687-962577f222bd€35.00€0.50matched
10capture01a1a6ee-a621-7d58-9d80-49ad58ec7802€15.00€0.26matched
11capture01a1a6ee-a973-749c-ac26-e19222fcd293€24.00€0.37matched
12capture01a1a6ee-b0de-71ff-a551-2a3292cd62a9€35.00€0.50matched
13capture01a1a6ee-b1d7-7e0c-ac43-915483f87018€9.00€0.19matched
14capture01a1a6ee-ba09-783f-9762-ca48d00c8002€49.00€0.67matched
15capture01a1a6ee-ea13-78ee-b266-0e06b0f2b8d9€49.00€0.67matched
16capture01a1a6ef-08ee-7812-9c51-3f1cf6a6c785€24.00€0.37matched
17capture01a1a6ef-0c3b-75c9-b332-17c601c4949e€9.00€0.19matched
18capture01a1a6ef-1d3b-7216-a83b-b0c360c28fc2€15.00€0.26matched
19capture01a1a6ef-1e6a-7a08-8eca-d37e4f82825a€35.00€0.50matched
20capture01a1a6ef-27dd-7672-9561-d8ddfc64db96€35.00€0.50matched
21capture01a1a6ef-29a9-77d6-9690-715f1fd7c9e5€15.00€0.26matched
22capture01a1a6ef-393e-7372-ba50-01c61dc7db3a€35.00€0.50matched
23capture01a1a6ef-4481-72c7-8caf-2c1a70afe21b€9.00€0.19matched
24capture01a1a6ef-5162-7f35-9da9-fe486c1e391e€15.00€0.26matched
25refund01a1a6ef-5d65-7528-9899-f369e63aebaf-€31.00€0.00matched
26capture01a1a6ef-625f-7648-8f88-c5fae04b2943€9.00€0.19matched
27refund01a1a6ef-8871-71d8-8b11-dd536738252f-€7.00€0.00matched
28capture01a1a6ef-8f0d-7293-837d-e9d1ab088d94€15.00€0.26matched
29capture01a1a6ef-be7c-75f5-99fa-55775f303900€15.00€0.26matched
30capture01a1a6ef-d28d-76b7-ab3d-49d2448a03fb€15.00€0.26matched
31capture01a1a6ef-d5f3-7324-bf34-42f43ca20d17€24.00€0.37matched
32capture01a1a6ef-d729-7982-a114-80fd0a7d2e7e€35.00€0.50matched
33capture01a1a6f0-1066-7d61-937b-342f6d305ca1€9.00€0.19matched
34capture01a1a6f0-3e32-7c67-a1a3-ff34fed99a6d€15.00€0.26matched
35capture01a1a6f0-3f95-75d2-8b9e-070d890230cb€24.00€0.37matched
36capture01a1a6f0-445e-7624-b47c-34c17a6c4711€35.00€0.50matched
37capture01a1a6f0-40f9-7c26-90b5-55fe923698c8€15.00€0.26matched
38capture01a1a6f0-7229-715e-a147-1403771f6253€24.00€0.37matched
39capture01a1a6f0-84ee-7553-9dd7-896645851151€9.00€0.19matched
40capture01a1a6f0-a9e1-722a-8f49-ff464f9e86cb€15.00€0.26matched
41capture01a1a6f0-b1ee-7265-bd0f-f9f1d752fcf4€24.00€0.37matched
42capture01a1a6f0-b46e-75ef-a0c9-6ec8128db680€9.00€0.19matched
43capture01a1a6f0-cb07-78f8-942a-60b9cd6c3d32€24.00€0.37matched
44capture01a1a6f0-cca4-787e-8188-0edd2644483c€35.00€0.50matched
45capture01a1a6f1-09ba-7131-9669-f56a6ea416c6€49.00€0.67matched
46capture01a1a6f1-1f22-70a3-9006-20ae45d8cb95€15.00€0.26matched
47capture01a1a6f1-545c-743d-b560-a8f38e41034b€15.00€0.26matched
48capture01a1a6f1-5d19-7fe2-9ec8-a78bfb51d366€35.00€0.50matched
49capture01a1a6f1-c237-78b4-b3cf-26a44c696ac3€49.00€0.67matched
50capture01a1a6f1-d2bf-75a4-8664-19a28eb9c496€49.00€0.67matched
51capture01a1a6f1-fa44-7631-80ea-e0079e548f5b€15.00€0.26matched
52capture01a1a6f2-04a2-7161-90dd-5e824e158546€24.00€0.37matched
53capture01a1a6f2-1127-7c85-a278-db9982630fc1€15.00€0.26matched
54capture01a1a6f2-0cae-790d-ac4f-a687323877c5€49.00€0.67matched
55refund01a1a6f2-1b49-75fd-bbf1-d28024372fdf-€10.00€0.00matched
56capture01a1a6f2-1edc-770c-89ab-5a81d4f0e55b€35.00€0.50matched
58capture01a1a6f2-20dc-7615-a98b-5b1658ae47d5€9.00€0.19matched
59capture01a1a6f2-22f3-7197-87d8-a7328cc04612€35.00€0.50matched
60capture01a1a6f2-29ae-7fe5-8107-61552e00aeb4€9.00€0.19matched
61capture01a1a6f2-3035-71f1-9841-8f5b8abe3181€24.00€0.37matched
62refund01a1a6f2-54cf-70fd-961a-0cadef9ff167-€10.00€0.00matched
63refund01a1a6f2-6fbd-768e-a9ee-ed67ce29f519-€32.00€0.00matched
64capture01a1a6f2-7328-7916-b251-7508c1047704€15.00€0.26matched
65capture01a1a6f2-89ec-7ea7-b173-71242a4101ca€9.00€0.19matched
66capture01a1a6f2-8f78-7370-96a7-4b876e9d3eac€35.00€0.50matched
67capture01a1a6f2-9963-7bc4-8360-2a4470472ae7€15.00€0.26matched
68capture01a1a6f2-9a80-7e70-9694-72d2276dd8ca€24.00€0.37matched
69capture01a1a6f2-a811-7040-afc0-a623f7fc7554€15.00€0.26matched
70capture01a1a6f2-c3a8-7550-8bfd-61897e371636€9.00€0.19matched
71capture01a1a6f2-d3d0-7363-9d95-59a427b6f57b€9.00€0.19matched
72capture01a1a6f2-fac4-78dc-a14d-e566eca178e7€15.00€0.26matched
73capture01a1a6f3-037a-7591-af14-cb09de13abcc€24.00€0.37matched
74capture01a1a6f3-0584-7f12-a06c-581a957cfdf9€49.00€0.67matched
75capture01a1a6f3-156e-778d-bf70-d20aefb18a81€35.00€0.50matched
76capture01a1a6f3-25f3-7c9c-80fc-f67f29eda550€35.00€0.50matched
77refund01a1a6f3-31f9-7855-bf3c-56792a52ce16-€12.00€0.00matched
78capture01a1a6f3-3dd1-7fee-8248-81f34e37a267€24.00€0.37matched
79capture01a1a6f3-54b7-7823-900c-2e82aff1bfe7€35.00€0.50matched
80capture01a1a6f3-58c1-7fc3-b2c3-1ef1662de8e2€9.00€0.19matched
81capture01a1a6f3-5db8-7ebf-bc13-aa4fb6ebcd53€35.00€0.50matched
82capture01a1a6f3-7657-712b-8cd3-fea6773cac3c€35.00€0.50matched
83capture01a1a6f3-7c7c-7095-be19-9dd50ee90f39€9.00€0.19matched
84capture01a1a6f3-7d0d-7081-bbf0-9ec0153e9fd0€15.00€0.26matched
85capture01a1a6f3-7f0b-74f3-8750-761e06dfc02c€9.00€0.19matched
86capture01a1a6f3-aff4-7c06-9243-f59128cc63f6€9.00€0.19matched
87capture01a1a6f3-bb1c-71d6-bf96-0bd39ddeb95d€24.00€0.37matched
88capture01a1a6f3-e434-7080-9d0f-cfd27e860497€49.00€0.67matched
89capture01a1a6f4-19f0-7a50-9064-39a7e414e622€35.00€0.50matched
90capture01a1a6f4-2206-7fb0-9db0-7b059322fdbf€49.00€0.67matched
91capture01a1a6f4-4e16-78c1-ade4-3cd9c0d71354€15.00€0.26matched
92capture01a1a6f4-67bf-7fdb-8bbc-f2da5ffb92e1€24.00€0.37matched
93refund01a1a6f4-6b35-742a-8fee-d5ac1564ee1a-€31.00€0.00matched
94capture01a1a6f4-826b-704b-90c0-2820777bf631€9.00€0.19matched
95capture01a1a6f4-a248-7eff-97d3-36a1c6edb82c€49.00€0.67matched
96capture01a1a6f4-d948-73da-9360-e7c4d04810d5€35.00€0.50matched
97capture01a1a6f4-e0c6-779f-8cb9-76603c923a98€35.00€0.50matched
98capture01a1a6f4-ea1f-715a-9f97-fcac98ba59e9€15.00€0.26matched
99capture01a1a6f4-f5d8-7770-9855-328bb7c7c032€24.00€0.37matched
100capture01a1a6f5-0728-7b6d-8717-bbb3899cbb8f€24.00€0.37matched
101capture01a1a6f5-082f-719b-b630-beac8c08f124€49.00€0.67matched
102capture01a1a6f5-0841-70d1-aa8c-9fb98cd3c5ca€49.00€0.67matched
103capture01a1a6f5-0da4-71aa-9015-ea856612702a€9.00€0.19matched
104capture01a1a6f5-152a-76aa-96bc-e762db1f2f60€9.00€0.19matched
105capture01a1a6f5-1a2a-7204-b5a4-54c11248aad7€35.00€0.50matched
106refund01a1a6f5-23d8-7aa7-bb8c-19f60202f7e7-€9.00€0.00matched
107capture01a1a6f5-243a-7a3e-be5d-6b4e54b6c1c6€9.00€0.19matched
108capture01a1a6f5-26c9-79f1-91af-7fc57a5581e6€15.00€0.26matched
109capture01a1a6f5-29ec-745a-a88f-bf18b3d6b9e2€15.00€0.26matched
110refund01a1a6f5-40b5-76df-928c-762bd117abc0-€25.00€0.00matched
111capture01a1a6f5-50dc-7a95-b36b-0a8faa30e3ef€9.00€0.19matched
112capture01a1a6f5-5aff-718f-b4b6-6b8b9bbdab3d€15.00€0.26matched
113capture01a1a6f5-62c0-74a3-a228-7eb21e5f829d€35.00€0.50matched
114capture01a1a6f5-721b-73df-9171-9509474ec754€49.00€0.67matched
115capture01a1a6f5-78e3-728b-864f-abb047d871d6€24.00€0.37matched
116refund01a1a6f5-7627-7718-92b4-ba2c1a7e04cc-€39.00€0.00matched
117capture01a1a6f5-88db-7ed4-ae30-ebcb392d2cd3€15.00€0.26matched
118capture01a1a6f5-898c-7cd9-85e2-94f74b36abc0€24.00€0.37matched
119refund01a1a6f5-8e19-7dfa-91e4-0341ac6c6f75-€7.00€0.00matched
120capture01a1a6f5-bb2a-73c5-aab6-80e7ee32726b€35.00€0.50matched
121capture01a1a6f5-c46e-7196-9737-c4ca3ae1447a€15.00€0.26matched
122capture01a1a6f5-fbf9-75a5-8e7b-6ee9fc044d28€35.00€0.50matched
123capture01a1a6f5-fc96-768e-80fb-07ce579bf4b3€24.00€0.37matched
124capture01a1a6f6-00ad-76d6-96ce-3cbf39e40f3b€24.00€0.37matched
125capture01a1a6f6-3b27-79ee-b0e2-fa9aaf88b31d€15.00€0.26matched
126capture01a1a6f6-44d3-7c17-b760-5b5c3ba93b5d€9.00€0.19matched
127capture01a1a6f6-4a93-7e6e-95dc-30470a7eddda€35.00€0.50matched
128capture01a1a6f6-6c43-7779-bcd9-4a8edddbabeb€35.00€0.50matched
129capture01a1a6f6-7251-7d5d-90b9-afb11390777d€49.00€0.67matched
130capture01a1a6f6-7ea4-7c13-b7f7-3d5000f6d7a7€49.00€0.67matched
131refund01a1a6f6-9aa5-7049-8dc3-cc8b7bc2aa9f-€24.00€0.00matched
132capture01a1a6f6-a7fc-739a-b13e-612dff73fa43€24.00€0.37matched
133capture01a1a6f6-a996-7f90-a0f8-d9afda50bc3f€15.00€0.26matched
134capture01a1a6f6-b2ff-7352-a186-b0a077883234€9.00€0.19matched
135capture01a1a6f6-b6be-7635-9eb4-4c4bcfd83b27€49.00€0.67matched
136capture01a1a6f6-d6d3-7f43-82b7-d31d1ec42110€9.00€0.19matched
137capture01a1a6f6-ea03-7586-a633-cca2cadf211f€9.00€0.19matched
138refund01a1a6f7-056d-7595-9a7e-72c50c5dc7a8-€5.00€0.00matched
139capture01a1a6f7-0596-7125-858b-50873f7ffc78€49.00€0.67matched
140capture01a1a6f7-240b-7c60-af66-edcd8540e0a4€15.00€0.26matched
141capture01a1a6f7-30b3-72fd-a151-30b4e5f0d411€24.00€0.37matched
142capture01a1a6f7-44fb-715d-b4de-597f8d599bea€9.00€0.19matched
143capture01a1a6f7-532c-7fcb-bdd0-a4442dec735c€9.00€0.19matched
144capture01a1a6f7-5843-7533-853c-d9354fd89f20€9.00€0.19matched
145refund01a1a6f7-58b7-7727-bc5e-2c900bbe9c62-€11.00€0.00matched
146capture01a1a6f7-62c7-7648-8c60-164d1a9e4d51€15.00€0.26matched
147capture01a1a6f7-78d2-7e3c-9c83-22c201767f74€24.00€0.37matched