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

Gross

€2,797.00

PSP fee

€43.15

Net to the bank

€2,753.85

Settlement journal

#374422

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a52c-ebbe-739a-b519-41109378d0b0 is already settled by stl_EUR_2989620 line 104
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • missing linein the books, not in the filecapture:01a1a524-a053-76a6-8809-223414993741 is in no file
  • missing linein the books, not in the filecapture:01a1a525-fc41-7c3e-b0a4-37ec2b91c759 is in no file
LineKindReferenceGrossFeeStatus
75capture01a1a52b-33c5-7911-bd80-019b9019d5da€9.00€0.23fee difference
105capture01a1a52c-ebd6-77f0-893f-fee6dcdbf25b€35.00€0.50duplicate line
1capture01a1a524-a993-7ce1-b2e7-baa424e30818€24.00€0.37matched
2capture01a1a524-ae17-712a-9b33-470d94378c5c€24.00€0.37matched
3capture01a1a524-b16c-71b9-b6e5-4e96b20cd990€15.00€0.26matched
4capture01a1a524-bf3e-7669-9753-11c72d9105f8€24.00€0.37matched
5capture01a1a524-d72d-755c-8fee-38b3baca54c6€9.00€0.19matched
6capture01a1a524-ec0a-76fc-af29-d7945ba9b7f3€35.00€0.50matched
7capture01a1a524-ecc4-74b0-a26e-3fb0d10adb18€35.00€0.50matched
8capture01a1a524-f0bc-7e23-85c9-d5e138dd9545€15.00€0.26matched
9capture01a1a524-f35a-7071-bc1a-ce30101199de€24.00€0.37matched
10capture01a1a525-1d39-7d2e-910e-acad565101db€9.00€0.19matched
11capture01a1a525-52fc-71d8-97f6-edd52deb3ab8€9.00€0.19matched
12capture01a1a525-6542-73b8-9453-1bdbab54192d€9.00€0.19matched
13capture01a1a525-716d-78b0-a154-9056eb6962eb€24.00€0.37matched
14capture01a1a525-71f7-7445-ae8e-3f84606a8549€9.00€0.19matched
15capture01a1a525-94bc-7178-b2e5-872362767460€15.00€0.26matched
16capture01a1a525-9d28-7ee5-bf08-2c395fd2f690€24.00€0.37matched
17capture01a1a526-04b7-7e94-bf4a-f011527e42c3€24.00€0.37matched
18capture01a1a526-0ce1-7f47-bf4b-eb77e975353c€35.00€0.50matched
19capture01a1a526-1785-7391-9bac-bddcb53d4806€9.00€0.19matched
20capture01a1a526-24cc-7e41-a721-ef6e7b152eb0€24.00€0.37matched
21capture01a1a526-9952-745d-9d42-dcab2927f13e€15.00€0.26matched
22capture01a1a526-a81b-719b-ad6f-67e8b2ee4b0e€49.00€0.67matched
23capture01a1a526-ce3d-7dd5-aae6-49df3084ec16€24.00€0.37matched
24capture01a1a526-f0cc-7507-b13c-034f176852fb€9.00€0.19matched
25capture01a1a526-f467-7a71-bf67-48d929cb8b1a€49.00€0.67matched
26capture01a1a527-017b-7350-a94c-71d9a99b596e€9.00€0.19matched
27capture01a1a527-19fc-77c9-9faa-0aaa2a3a78e0€9.00€0.19matched
28capture01a1a527-51d6-72d7-bf2a-fb934c2995e0€9.00€0.19matched
29capture01a1a527-595e-78d5-9b63-3ed274a78dbe€24.00€0.37matched
30capture01a1a527-54e7-75eb-8ba8-68e6864452c9€49.00€0.67matched
31capture01a1a527-74d9-7cf1-977c-0fd6f50a6647€49.00€0.67matched
32capture01a1a527-ca85-7b47-9cef-901a7c0e05d0€15.00€0.26matched
33refund01a1a527-dbbb-7d44-b8bb-1c4476ea0148-€5.00€0.00matched
34capture01a1a528-0d66-7e03-873f-f85d37b744a0€24.00€0.37matched
35capture01a1a528-13b6-7635-963f-46c22d4a80c3€35.00€0.50matched
36capture01a1a528-2d9c-7741-99e1-6e9e39829a27€24.00€0.37matched
37capture01a1a528-48e7-7124-9852-ae27b9f5abca€9.00€0.19matched
38capture01a1a528-4cd2-71bc-a761-5ef51e91d715€24.00€0.37matched
39capture01a1a528-5370-7207-a988-9de8268ae518€24.00€0.37matched
40capture01a1a528-8329-75dc-85fb-ade6850c3434€49.00€0.67matched
41capture01a1a528-8370-78c5-9afb-2eff8714abb5€49.00€0.67matched
42capture01a1a528-97ff-79c4-b77f-9fa9317a5b55€35.00€0.50matched
43capture01a1a528-991c-7d74-bac1-54d63f0b8f88€24.00€0.37matched
44capture01a1a528-ad91-7010-898b-6637baba2ba7€9.00€0.19matched
45capture01a1a528-b486-73a4-bfd2-be7f0cf4da7c€49.00€0.67matched
46capture01a1a528-b839-758d-a26f-75651116b570€9.00€0.19matched
47capture01a1a528-bca5-7d0c-9e2b-17d5838e285a€24.00€0.37matched
48capture01a1a528-f16b-7b9c-9b83-a0ee296cc8dd€9.00€0.19matched
49capture01a1a528-f87c-7615-969f-c1a03456995e€24.00€0.37matched
50capture01a1a529-10ca-7452-af2a-c935064eecd3€9.00€0.19matched
51capture01a1a529-21da-7750-abe6-97e2f16be0bf€24.00€0.37matched
52refund01a1a529-311c-71a4-988d-0792948ecf78-€3.00€0.00matched
53capture01a1a529-7576-7ed4-ac3f-b11b7bce38db€35.00€0.50matched
54capture01a1a529-a14c-7e81-9592-2ced965d7a31€9.00€0.19matched
55capture01a1a529-d455-7a17-b652-ff6afa0547b6€49.00€0.67matched
56capture01a1a529-dbd5-715b-9c82-d8aaba43f438€24.00€0.37matched
57capture01a1a52a-0f2f-7d94-935f-6580c8768ceb€49.00€0.67matched
58capture01a1a52a-10ce-726a-aae4-cf9b121577c6€9.00€0.19matched
59capture01a1a52a-1fee-7f85-b711-8ae74624bbcd€35.00€0.50matched
60capture01a1a52a-34d9-791b-a21f-c24d4f6dfab9€35.00€0.50matched
61capture01a1a52a-31b4-7d3f-80e3-9804fb391c5c€24.00€0.37matched
62refund01a1a52a-3b9e-7016-9132-f3fa61519299-€19.00€0.00matched
63capture01a1a52a-4d1a-782f-b81f-092621a5aefc€49.00€0.67matched
64capture01a1a52a-56f9-77c4-9d2c-9395223d8026€24.00€0.37matched
65capture01a1a52a-6060-7eea-aab6-2f42405e3cf7€24.00€0.37matched
66capture01a1a52a-64f4-7357-b1df-9b7ee8df8f28€49.00€0.67matched
67capture01a1a52a-7c2a-71ab-9e3a-81512893f987€35.00€0.50matched
68capture01a1a52a-ade5-771b-81fc-a86d91ec1746€49.00€0.67matched
69capture01a1a52a-cc44-7647-992b-9b345f181945€49.00€0.67matched
70capture01a1a52a-d877-7cd2-89c0-f677eeafd35a€15.00€0.26matched
71capture01a1a52a-f892-761a-a9b6-bc239bdd0775€9.00€0.19matched
72capture01a1a52b-04ca-754f-89da-1e95fb261eb8€15.00€0.26matched
73capture01a1a52b-06c4-7a51-84ae-3024daaaa872€9.00€0.19matched
74capture01a1a52b-2d46-73b2-abde-40c742c68225€24.00€0.37matched
76capture01a1a52b-396a-7d07-8a95-a5185c6e28c2€24.00€0.37matched
77capture01a1a52b-3fc4-79d3-a294-1d2844ee7f3e€15.00€0.26matched
78capture01a1a52b-68aa-7500-80e4-e2aa7b018281€35.00€0.50matched
79capture01a1a52b-7e37-7ec4-b578-2667a854f41b€35.00€0.50matched
80capture01a1a52b-80c8-7142-90dd-ac23b57ea05a€9.00€0.19matched
81capture01a1a52b-8d94-79ff-906d-160be0c44770€35.00€0.50matched
82capture01a1a52b-91d4-70db-bcd4-6840751e2764€15.00€0.26matched
83capture01a1a52b-9253-7e5f-87e0-330bdcafdc0b€24.00€0.37matched
84capture01a1a52b-c8f6-7b8f-89a3-a5cb58ceedd7€49.00€0.67matched
85capture01a1a52b-f321-74bd-ae7d-e0c7049ec7b5€24.00€0.37matched
86capture01a1a52b-f6e3-737f-8ea3-6fcd3d9964f9€9.00€0.19matched
87capture01a1a52b-f8aa-71d3-9ef1-aeb1997af5e3€35.00€0.50matched
88capture01a1a52c-0977-7ab3-8842-c924364654fc€15.00€0.26matched
89capture01a1a52c-19a8-76bf-b616-ea8f97afa96a€24.00€0.37matched
90capture01a1a52c-1e7e-726f-99f8-edf8a194cb66€35.00€0.50matched
91capture01a1a52c-1e93-7dfd-80e8-f10c9b6a6674€24.00€0.37matched
92capture01a1a52c-3343-714a-a3af-b12d98892d45€15.00€0.26matched
93capture01a1a52c-44c9-7498-a036-1642c1231488€9.00€0.19matched
94capture01a1a52c-69b9-718e-91a2-e28ace323ddc€49.00€0.67matched
95capture01a1a52c-7626-7047-a367-94b85c7893d9€49.00€0.67matched
96capture01a1a52c-a29b-7d9a-beab-c0ef5f9e1ab9€24.00€0.37matched
97capture01a1a52c-b4b7-79dc-a314-9df8d1a85168€24.00€0.37matched
98capture01a1a52c-b924-726c-8ba6-a164ce32dc5f€15.00€0.26matched
99capture01a1a52c-b9dd-715d-8de7-76fd7c8cca10€9.00€0.19matched
100capture01a1a52c-c04a-7651-b110-52a4b1ac9fad€9.00€0.19matched
101capture01a1a52c-c8cf-7d51-87cf-7ee9ec6bb1a2€35.00€0.50matched
102capture01a1a52c-d4da-7c88-ac2a-dbb6a5541009€15.00€0.26matched
103refund01a1a52c-e9f9-78fa-91c6-58fb9f5ca9c0-€5.00€0.00matched
104capture01a1a52c-ebd6-77f0-893f-fee6dcdbf25b€35.00€0.50matched
106capture01a1a52c-fc20-7600-a872-b35eb79778f6€49.00€0.67matched
107capture01a1a52d-0535-70fc-a098-f73459f50b51€24.00€0.37matched
108capture01a1a52d-0cf2-7e77-bfed-16ecdd0d000b€49.00€0.67matched
109capture01a1a52d-1445-7636-b31c-5ab49658b30a€49.00€0.67matched
110refund01a1a52d-3b50-7d80-bad1-a0af36335ec0-€11.00€0.00matched
111capture01a1a52d-4568-792d-85f5-10898d7f5e37€15.00€0.26matched
112capture01a1a52d-50c9-7823-a486-f61c7b91c5f8€15.00€0.26matched
113capture01a1a52d-6604-7445-a781-63044cb2573f€35.00€0.50matched
114capture01a1a52d-8e1e-72e4-86f7-d49a43056c4b€35.00€0.50matched
115capture01a1a52d-917b-772a-93fe-c208a010b964€15.00€0.26matched
116capture01a1a52d-a4d1-7bda-8009-06f699743cd6€35.00€0.50matched