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

Gross

€3,162.00

PSP fee

€50.50

Net to the bank

€3,111.50

Settlement journal

#412849

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aff3-337e-73e6-986f-05f266e3b853 is already settled by stl_EUR_2989922 line 33
  • duplicate linethe file lists it twicecapture:01a1aff3-4efe-7e56-bd18-e7221bff8b95 is already settled by stl_EUR_2989922 line 36
LineKindReferenceGrossFeeStatus
34capture01a1aff3-3396-7d00-82f6-3b8cf41d360b€9.00€0.19duplicate line
37capture01a1aff3-4f4a-7d8b-ba83-f67c71dab1e6€9.00€0.19duplicate line
1capture01a1afe9-467b-7a68-8055-997999696b3b€24.00€0.37matched
2capture01a1afe9-7d2d-7b8f-a76d-a77eafb93629€9.00€0.19matched
3capture01a1afeb-afd2-7c23-b1a6-2e57608b79df€24.00€0.37matched
4capture01a1aff1-8b56-7a94-bbbc-a0c4f3c142bb€24.00€0.37matched
5capture01a1aff1-a348-7604-a7eb-d8416e86eb5f€35.00€0.50matched
6capture01a1aff1-a7ec-75fd-8d70-8014715304fb€35.00€0.50matched
7capture01a1aff1-a89e-7e32-9ab2-7b04aeff9d9f€35.00€0.50matched
8capture01a1aff1-d914-73ac-bf79-2b8934f050b4€15.00€0.26matched
9capture01a1aff1-da30-7e18-b754-8b94e9936304€24.00€0.37matched
10capture01a1aff1-dcd3-7192-b93f-17fa409e4542€24.00€0.37matched
11capture01a1aff1-e8f0-73bd-83aa-74716826a790€24.00€0.37matched
12capture01a1aff2-133e-76d9-94f7-4ae443139ccd€15.00€0.26matched
13capture01a1aff2-1950-773c-a587-d1f26a534aea€49.00€0.67matched
14capture01a1aff2-2c2a-72a5-b976-83c7acbb6ddc€9.00€0.19matched
15capture01a1aff2-3698-7d4b-a0cc-19ea99ca6d4b€15.00€0.26matched
16refund01a1aff2-3d6b-7d71-b089-243e3defbeb7-€6.00€0.00matched
17capture01a1aff2-4b53-7418-a8f0-a5d4dde0bd53€9.00€0.19matched
18capture01a1aff2-5f0e-7318-ae0b-25a17b82bb21€24.00€0.37matched
19capture01a1aff2-684c-77bb-b12a-2704aff110da€35.00€0.50matched
20capture01a1aff2-704b-7538-aee7-3000d5732d45€15.00€0.26matched
21capture01a1aff2-8f8b-7ff2-8b51-024def84606e€24.00€0.37matched
22capture01a1aff2-aed5-7832-a786-f77d7f1102f9€35.00€0.50matched
23refund01a1aff2-ba55-77b1-a9dd-5c0a2555e4c3-€8.00€0.00matched
24capture01a1aff2-ceb1-7ed8-8ae6-354388a431a0€24.00€0.37matched
25capture01a1aff2-d254-7bdc-ae89-a0d55cc4f625€9.00€0.19matched
26capture01a1aff2-d83c-7776-8878-2283fa1a519e€35.00€0.50matched
27capture01a1aff2-e41b-79d0-88ad-2368f22b6005€15.00€0.26matched
28capture01a1aff2-f1a8-7154-9ec7-dbd23dadd15f€35.00€0.50matched
29capture01a1aff3-056c-702d-b36f-a32b35edbfba€15.00€0.26matched
30capture01a1aff3-1049-7480-a436-a3243352e8c8€49.00€0.67matched
31capture01a1aff3-15c0-7a31-a722-2176003fbc1b€49.00€0.67matched
32capture01a1aff3-202f-75db-9c10-dd137b44fd61€49.00€0.67matched
33capture01a1aff3-3396-7d00-82f6-3b8cf41d360b€9.00€0.19matched
35capture01a1aff3-3ac3-7c9a-9cf6-ba24183c42cc€49.00€0.67matched
36capture01a1aff3-4f4a-7d8b-ba83-f67c71dab1e6€9.00€0.19matched
38capture01a1aff3-78d8-7e8f-a8e4-0e9dc003b881€49.00€0.67matched
39capture01a1aff3-7e07-792a-bffa-7ec2e583447f€15.00€0.26matched
40capture01a1aff3-8409-7a10-bc1e-ac5a3cc99ec0€15.00€0.26matched
41capture01a1aff3-96b6-77b7-a5df-64dd9cc55a33€9.00€0.19matched
42capture01a1aff3-b5ec-7841-9f17-f73105bb598d€35.00€0.50matched
43capture01a1aff3-de7f-7d6d-acfb-efa8c39efefd€49.00€0.67matched
44capture01a1aff3-e52a-76cd-8990-b67f5b8e7f64€35.00€0.50matched
45capture01a1aff3-f35b-7498-b07f-254afcaab279€35.00€0.50matched
46capture01a1aff3-eef2-78a7-a5f2-5e122ad5cbdc€9.00€0.19matched
47capture01a1aff4-1635-77f8-945b-e52e174a6b3a€9.00€0.19matched
48capture01a1aff4-30f9-7ec4-bf6b-2f4dc7d8ddcc€24.00€0.37matched
49capture01a1aff4-327b-746f-bcad-0f51ef548102€49.00€0.67matched
50capture01a1aff4-4316-7583-af86-cfd8082a9f31€35.00€0.50matched
51capture01a1aff4-4aa6-7888-9dee-292c126df478€35.00€0.50matched
52capture01a1aff4-5469-7003-9fdf-1e0d2c2b39cf€24.00€0.37matched
53capture01a1aff4-5b25-7cf2-9782-16041b49ccdd€24.00€0.37matched
54capture01a1aff4-8c29-74fc-a7a2-20a4ccadc26e€35.00€0.50matched
55capture01a1aff4-aa42-79f2-b91b-9bc0a23aea6f€15.00€0.26matched
56capture01a1aff4-b1e2-75db-aeb1-6965de315fc5€24.00€0.37matched
57capture01a1aff4-b47e-768a-8232-b86a9de4ba4e€49.00€0.67matched
58capture01a1aff4-d9e8-746d-8ef3-dbb67cbc5654€9.00€0.19matched
59capture01a1aff4-ea5c-78bd-af2f-9959c95715c4€35.00€0.50matched
60capture01a1aff4-f285-739b-96b5-0d5081f17943€15.00€0.26matched
61capture01a1aff5-1075-7044-9fd7-7d58bccfd079€9.00€0.19matched
62capture01a1aff5-1380-7061-97d9-80839fddbe49€49.00€0.67matched
63capture01a1aff5-2760-7ed6-a3bf-ca81f400e4f3€49.00€0.67matched
64capture01a1aff5-2fa0-72f8-bd91-87ed0558b91d€49.00€0.67matched
65capture01a1aff5-4cb1-7283-bda4-daf80fb7a53d€49.00€0.67matched
66refund01a1aff5-562a-72f7-95df-c161869c774a-€46.00€0.00matched
67capture01a1aff5-934e-77ba-9f58-5e7eb5b8f689€35.00€0.50matched
68capture01a1aff5-a06e-77ec-8d83-735ce5b2a2f9€15.00€0.26matched
69capture01a1aff5-a3b2-772d-9afd-d8ed72e5e024€24.00€0.37matched
70capture01a1aff5-a439-7a99-b5b2-e5c2a8608137€9.00€0.19matched
71capture01a1aff5-a5a8-7436-b3eb-a9861c1663ab€9.00€0.19matched
72capture01a1aff5-aba3-7596-a80b-6f06497d9be6€49.00€0.67matched
73capture01a1aff5-da09-71d1-996f-958bc3d82c46€35.00€0.50matched
74capture01a1aff5-db33-75cd-b7ce-821c28fca77e€9.00€0.19matched
75capture01a1aff5-df8e-75be-8a6a-ee2360f7e986€49.00€0.67matched
76capture01a1aff5-f39d-7760-aece-55d73ab89f98€15.00€0.26matched
77capture01a1aff5-f5d4-738e-9f4f-291f52d83332€49.00€0.67matched
78capture01a1aff5-fba9-756a-88c9-91d4f66d89a2€49.00€0.67matched
79capture01a1aff5-fc48-7604-af2e-d7855937754f€15.00€0.26matched
80refund01a1aff6-20e1-727e-a189-c23c5741270e-€21.00€0.00matched
81capture01a1aff6-29a9-789a-9444-3ec7578d89ca€35.00€0.50matched
82refund01a1aff6-3e49-7400-b937-5b277108af6e-€20.00€0.00matched
83refund01a1aff6-596b-792d-939a-0d0bed0039df-€11.00€0.00matched
84capture01a1aff6-63fa-74c0-a518-eab132a2a4b1€35.00€0.50matched
85refund01a1aff6-6715-7943-8225-0133f15c2d62-€11.00€0.00matched
86capture01a1aff6-71d8-7503-9bfb-eacd64c92a3b€35.00€0.50matched
87capture01a1aff6-aa6a-7c1f-ae82-92170ff1747f€49.00€0.67matched
88capture01a1aff6-c5f4-776f-aa3c-e5f2b72f280f€35.00€0.50matched
89capture01a1aff6-c62d-7b3e-9a96-bc81d5263884€24.00€0.37matched
90capture01a1aff6-e0fc-7799-ab32-653c4295043e€24.00€0.37matched
91capture01a1aff6-ead6-70ea-9a00-a6b6c28f85c3€15.00€0.26matched
92refund01a1aff6-eff2-772b-9cce-1c955927a044-€27.00€0.00matched
93capture01a1aff7-00e1-7900-a756-b73613f9b0f1€24.00€0.37matched
94capture01a1aff7-2a76-7dc4-a306-d9cc697f70a4€35.00€0.50matched
95capture01a1aff7-6dd2-7c7e-a57a-7b57ba8b6c71€9.00€0.19matched
96capture01a1aff7-90b3-77c7-8dd1-58eb70f6c95e€15.00€0.26matched
97capture01a1aff7-9b10-7f40-ab35-dfd77d609474€49.00€0.67matched
98capture01a1aff8-1b40-7d7b-b6a4-feebbfe1ce72€35.00€0.50matched
99capture01a1aff8-47ad-7dc9-9a5f-7e58f69593e1€24.00€0.37matched
100capture01a1aff8-5e78-7628-bb63-2ab0bbc969c2€35.00€0.50matched
101capture01a1aff8-8994-70a7-bd88-9af2b22bfe38€15.00€0.26matched
102capture01a1aff8-8adc-7475-a27d-7642f06fe6ea€24.00€0.37matched
103refund01a1aff8-8eb1-73fb-9c12-0bbe7373e82f-€32.00€0.00matched
104capture01a1aff8-96f8-7337-a839-7ec0efb45263€9.00€0.19matched
105capture01a1aff8-9de5-71a8-8b5c-ca26e3375920€9.00€0.19matched
106capture01a1aff8-9f13-703d-9956-4e386e52a0de€24.00€0.37matched
107capture01a1aff8-b3f4-7d56-bd61-257cecc48fbc€15.00€0.26matched
108capture01a1aff8-b45b-78f4-a31c-755b48a5a985€24.00€0.37matched
109capture01a1aff8-d46b-79c8-92a5-3426fadaae31€15.00€0.26matched
110capture01a1aff8-d531-7fc9-8ab7-e2e2b111bfe6€24.00€0.37matched
111capture01a1aff8-e1cc-7ec6-a1fa-39a6a705ecbe€9.00€0.19matched
112capture01a1aff8-ebc7-7e1a-aabe-985a8bed3742€24.00€0.37matched
113refund01a1aff9-06e9-742c-868f-07d8564da6b0-€4.00€0.00matched
114capture01a1aff9-13e7-75d7-8da5-d7ed5d6ae6af€35.00€0.50matched
115capture01a1aff9-1c26-78f6-a0f8-9a350c2078ea€35.00€0.50matched
116capture01a1aff9-2558-734f-ae5d-ddbc8ab63e5c€49.00€0.67matched
117capture01a1aff9-3b56-7b86-b540-401627c88f92€9.00€0.19matched
118capture01a1aff9-3ded-7a32-9b36-476c2e7a044c€15.00€0.26matched
119capture01a1aff9-5a67-7922-8af5-ae7328c71f93€15.00€0.26matched
120capture01a1aff9-5dc0-7a28-adde-cb623e7e64d1€24.00€0.37matched
121capture01a1aff9-8086-7edd-b168-487a27068c62€24.00€0.37matched
122capture01a1aff9-8686-7838-a16a-26b0449ba208€35.00€0.50matched
123capture01a1aff9-8775-7f01-aad5-015b060912ea€49.00€0.67matched
124capture01a1aff9-b7ca-7e3f-984f-7dfd51dc850b€35.00€0.50matched
125capture01a1aff9-bedd-7226-b1a8-6634e51980f5€9.00€0.19matched
126capture01a1aff9-c707-763e-98ce-29b1b6925b9a€49.00€0.67matched
127capture01a1aff9-d8de-7d7c-a302-97a0db1d6ce3€35.00€0.50matched
128capture01a1aff9-e9e2-766c-a8f1-e05f0622ced9€15.00€0.26matched
129capture01a1aff9-f54e-724c-8d03-2e4a5b8c30a2€24.00€0.37matched
130capture01a1affa-0925-7ee3-9f06-1483c268ef17€15.00€0.26matched
131capture01a1affa-2448-7cc9-8414-ace464944e75€9.00€0.19matched
132refund01a1affa-521f-7735-a514-a85acab5c043-€8.00€0.00matched
133capture01a1affa-81a8-7468-b4fa-35ed69d8ed0f€15.00€0.26matched
134capture01a1affa-8f1e-7481-8d9a-85ed58c8db91€15.00€0.26matched
135capture01a1affa-97fb-73bc-aad3-f9962a9a3437€49.00€0.67matched
136capture01a1affa-97fb-72a8-84e6-257dcc2b2d5d€9.00€0.19matched
137capture01a1affa-9e2f-7c0f-8327-0d1ebfe1c010€49.00€0.67matched