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

1 Nov, 00:40

Gross

€3,158.00

PSP fee

€48.12

Net to the bank

€3,109.88

Settlement journal

#315630

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1948d-7f40-718a-a2dc-a8b0586acd99 is already settled by stl_EUR_2989156 line 21
LineKindReferenceGrossFeeStatus
22capture01a1948d-9080-786f-adf9-1852dc83ece8€35.00€0.50duplicate line
1capture01a19487-f816-746a-9860-2848285bfb0c€49.00€0.67matched
2capture01a19489-3978-7626-a1c8-62bf6729c9c7€35.00€0.50matched
3capture01a1948c-94da-76ed-a482-fde0245bb552€35.00€0.50matched
4capture01a1948c-9787-73f3-be19-8db9b446a1c9€24.00€0.37matched
5capture01a1948c-a601-7bf1-8b1b-cb77721ae256€35.00€0.50matched
6capture01a1948c-d608-76d7-983c-e6285a7b8c03€49.00€0.67matched
7capture01a1948c-dc57-7c16-a899-96143fb42d8c€15.00€0.26matched
8capture01a1948c-e44b-75a1-a296-2e9eeffc903a€35.00€0.50matched
9capture01a1948c-f5c5-76c5-aec0-bc2318aee8a5€35.00€0.50matched
10capture01a1948d-1b5e-73af-95fa-980e507da0d5€49.00€0.67matched
11capture01a1948d-1e53-7c7c-8bf2-40489ef475a9€49.00€0.67matched
12refund01a1948d-2213-771b-9f15-c7dd6215d4aa-€22.00€0.00matched
13capture01a1948d-2d86-7080-bce8-c40a442ad33f€35.00€0.50matched
14capture01a1948d-3040-7cb7-940b-9519ac607206€15.00€0.26matched
15capture01a1948d-3b47-75aa-abc5-67ddecab7cbf€9.00€0.19matched
16refund01a1948d-61fc-700c-92e8-3e56fcc11b70-€26.00€0.00matched
17capture01a1948d-65c6-7210-8f00-4083f98a8657€9.00€0.19matched
18capture01a1948d-6a7d-7374-92a0-2a3176547872€49.00€0.67matched
19capture01a1948d-744d-7a17-8ad1-86bd2bc14e83€24.00€0.37matched
20capture01a1948d-8760-781e-91a0-c7c366105fc7€35.00€0.50matched
21capture01a1948d-9080-786f-adf9-1852dc83ece8€35.00€0.50matched
23capture01a1948d-985e-75f1-b9a2-06a700b756b1€35.00€0.50matched
24capture01a1948d-a859-788f-8452-45ab8c4a8dc4€24.00€0.37matched
25capture01a1948d-bd81-77c6-aa63-13e4fb45e2a7€35.00€0.50matched
26capture01a1948d-cc51-781b-adb5-2683fe895e3f€24.00€0.37matched
27capture01a1948e-0857-70f0-908b-64d5f4919a32€15.00€0.26matched
28capture01a1948e-0d01-713d-9f60-2c180f1ab62a€15.00€0.26matched
29refund01a1948e-2613-777e-8f4e-ddfeeeb2b3e5-€8.00€0.00matched
30capture01a1948e-7981-7fa3-bbc3-984ca1e8097a€24.00€0.37matched
31capture01a1948e-8e9f-7743-a964-98b98435d372€15.00€0.26matched
32capture01a1948e-aa82-7271-9f9d-69c448ab7a2f€49.00€0.67matched
33capture01a1948e-bacb-777d-8693-c23b00ebb4bf€49.00€0.67matched
34capture01a1948e-c3c8-7ced-87bb-799bfc8e8a47€49.00€0.67matched
35capture01a1948e-c915-7707-8a10-d6c82e778f08€9.00€0.19matched
36capture01a1948e-d60b-7525-b964-93b4c21c7675€49.00€0.67matched
37capture01a1948e-da81-7a62-933e-96bdcbf37ce5€9.00€0.19matched
38capture01a1948e-e839-74f9-901e-1daef3056ddc€15.00€0.26matched
39capture01a1948e-f0fd-7f26-ab5c-68c3af035419€15.00€0.26matched
40capture01a1948e-f8f3-72b7-a051-99f4913c8c81€49.00€0.67matched
41capture01a1948f-3a28-7c63-a0a8-8fd91db51f2e€9.00€0.19matched
42capture01a1948f-3b5c-7745-af41-220105e40551€15.00€0.26matched
43capture01a1948f-4a23-734b-910e-c8f45f9bcb86€49.00€0.67matched
44capture01a1948f-665b-703e-8d2a-a17636aed630€49.00€0.67matched
45capture01a1948f-6cb9-79fb-b679-e23fb38760f9€35.00€0.50matched
46capture01a1948f-7c54-77a2-b4a4-0557efc531db€35.00€0.50matched
47capture01a1948f-87cb-700a-a809-c798f47de60b€35.00€0.50matched
48refund01a1948f-96cc-7be5-aef7-0b9ca14abeee-€4.00€0.00matched
49capture01a1948f-c28e-7f71-bbe7-447c25fb3146€15.00€0.26matched
50capture01a1948f-caf5-7d81-b829-760f42eef024€49.00€0.67matched
51capture01a1948f-cd5d-7c8f-808c-320eec17a3de€24.00€0.37matched
52capture01a1948f-d3f1-7c9b-86cb-5518d9e97a82€15.00€0.26matched
53capture01a1948f-d962-72f8-addf-82f92b3a4144€15.00€0.26matched
54capture01a1948f-ed58-737d-a808-8938efe6b334€49.00€0.67matched
55capture01a19490-23f6-760a-af07-bd6ae50835a6€49.00€0.67matched
56capture01a19490-4e41-7fda-9b18-4c571e0ee2eb€15.00€0.26matched
57capture01a19490-53e6-763b-adf6-2e60993903a1€15.00€0.26matched
58capture01a19490-7e26-7e54-835f-9b57b37fd3d2€15.00€0.26matched
59capture01a19490-8fad-7711-aaf1-91f4f246c021€9.00€0.19matched
60capture01a19490-b639-7440-9139-f8ea8162b1b5€9.00€0.19matched
61capture01a19490-c4a0-79df-9fa4-15acb9578df1€24.00€0.37matched
62capture01a19490-c6dc-76d1-87c0-33afa8a2805a€24.00€0.37matched
63capture01a19490-c742-7354-afe2-93f2db96d326€15.00€0.26matched
64capture01a19490-c8cf-7dfc-a7c7-c94935748405€15.00€0.26matched
65capture01a19490-cc16-7da3-ae40-acc45a954fe2€15.00€0.26matched
66capture01a19490-d90d-7bcc-951b-ce646d2f8dca€49.00€0.67matched
67capture01a19490-f5ee-736e-a8b2-e5643a532f0a€49.00€0.67matched
68capture01a19491-06ee-7f4e-b5e2-5b2e3a4b1f18€9.00€0.19matched
69capture01a19491-1640-7cb9-9abb-a6e91bb041e8€9.00€0.19matched
70refund01a19491-1b7d-7905-8b75-ad25444f9154-€6.00€0.00matched
71capture01a19491-22fb-7ede-92ca-5426d465c9ac€35.00€0.50matched
72refund01a19491-262c-7e62-b515-ad0207c4b634-€9.00€0.00matched
73capture01a19491-2639-7115-aa42-fcdfc93212d3€49.00€0.67matched
74capture01a19491-436e-7cbd-a52a-1ebece7f7b65€9.00€0.19matched
75capture01a19491-7028-74fd-89ce-740896125c3d€15.00€0.26matched
76capture01a19491-ce8d-7746-8fbf-5a5e1d8b3a98€15.00€0.26matched
77capture01a19491-f187-7740-88e6-32cbbdbd1a7f€15.00€0.26matched
78capture01a19492-08be-736b-ac89-c91e1871babd€15.00€0.26matched
79capture01a19492-1a59-70de-88ae-6caef2e0f92b€24.00€0.37matched
80capture01a19492-6280-7d74-baed-234f3b2df76c€49.00€0.67matched
81capture01a19492-6fa2-7fa6-a5ce-f455e2a02b5d€49.00€0.67matched
82capture01a19492-7226-787b-8337-522fbd580119€35.00€0.50matched
83capture01a19492-80d8-7448-9c1a-284e14e30547€49.00€0.67matched
84capture01a19492-85c6-7f59-a08a-f81dae022a3a€15.00€0.26matched
85capture01a19492-87ae-72e4-a986-381dd39e88cc€9.00€0.19matched
86capture01a19492-d201-714d-8051-f1844e2e0f83€15.00€0.26matched
87refund01a19492-de32-74e9-8c32-c900de07c347-€7.00€0.00matched
88capture01a19492-e3d5-7813-88ac-6cf0ef6376af€49.00€0.67matched
89capture01a19492-fad6-7ee9-bc8a-dfa4c7756ab2€49.00€0.67matched
90capture01a19492-fa9f-7cab-aa11-6dbd863b8c81€9.00€0.19matched
91refund01a19492-fbaa-7024-8b17-0f171d5fa4f0-€3.00€0.00matched
92capture01a19493-026f-73e6-8caf-154f4172aaca€15.00€0.26matched
93capture01a19493-4e5f-7999-a321-7fff72bdfaaa€24.00€0.37matched
94capture01a19493-54fd-73ca-97f7-9843e1db58fa€49.00€0.67matched
95capture01a19493-73b6-7d0c-8340-f38bc80f4202€35.00€0.50matched
96capture01a19493-7755-7f8c-bbfd-4d0ef0607e6c€49.00€0.67matched
97capture01a19493-796a-77aa-a8a5-104a4956b3fd€35.00€0.50matched
98capture01a19493-997f-7312-b3a5-6e5fe93139b7€49.00€0.67matched
99capture01a19493-9d0c-7797-9cfc-67b37505e7f5€49.00€0.67matched
100capture01a19493-c712-797f-a0d4-455dd6182e13€15.00€0.26matched
101capture01a19493-c8c0-77d5-81dd-d4ec0125bea2€9.00€0.19matched
102refund01a19493-cdbc-7620-9407-7649d488de0f-€23.00€0.00matched
103capture01a19493-d522-7383-85c0-4759125d6c12€49.00€0.67matched
104capture01a19493-dc98-7623-bd92-b62127cc45c7€35.00€0.50matched
105capture01a19493-fc6e-7e22-96b2-6b78983a9a3f€49.00€0.67matched
106capture01a19494-2117-72d3-a9f7-1b79b4fb0886€9.00€0.19matched
107capture01a19494-54f8-75ee-a1ee-6dcf6824463e€24.00€0.37matched
108capture01a19494-607c-72ba-bd17-4b8546995a56€49.00€0.67matched
109capture01a19494-89c2-77f3-ac3d-3eef675390b8€24.00€0.37matched
110capture01a19494-a802-707b-8fe0-b02b2a7ade2b€49.00€0.67matched
111capture01a19494-bcb0-7671-b511-63d450c87cbe€49.00€0.67matched
112capture01a19494-ce35-73db-9109-9703d93c674e€24.00€0.37matched
113capture01a19494-e289-7b7b-b585-9995d4d62f13€24.00€0.37matched
114capture01a19495-050f-7883-975b-1ce18ba151db€49.00€0.67matched
115capture01a19495-074a-7e8b-8049-f48307d9735d€24.00€0.37matched
116capture01a19495-0a8a-75be-87d0-5bcd0e7acfdb€49.00€0.67matched
117capture01a19495-162a-72b8-80c5-5b282caa5e5e€24.00€0.37matched
118capture01a19495-6989-7a55-b4d0-96d484572905€35.00€0.50matched
119capture01a19495-7a18-79fd-87e6-4327fe47a14a€15.00€0.26matched