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

16 Oct, 17:00

Gross

€2,846.00

PSP fee

€46.41

Net to the bank

€2,799.59

Settlement journal

#36575

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a145aa-7105-7b06-bde3-7c655291a805 is already settled by stl_EUR_2986950 line 47
LineKindReferenceGrossFeeStatus
48capture01a145aa-7200-7964-96ed-b8a4b37576b3€49.00€0.67duplicate line
1capture01a1459f-9769-7fa7-ab7c-4f8aa96d42fa€24.00€0.37matched
2capture01a145a6-53a1-710b-b4ad-3b99daa6efec€49.00€0.67matched
3capture01a145a7-e0e0-799b-9cef-01b8e41e3fed€35.00€0.50matched
4capture01a145a8-00b2-775e-aab0-d42d1a130188€49.00€0.67matched
5capture01a145a8-0bff-7c51-8dd2-7fb446ce7117€9.00€0.19matched
6capture01a145a8-13b0-72f8-a950-93417f5f751d€49.00€0.67matched
7capture01a145a8-1708-7edf-b70c-b52ea3221255€49.00€0.67matched
8capture01a145a8-1923-7336-ab12-0663655b0b4f€9.00€0.19matched
9refund01a145a8-2ee1-7326-8df6-0ec80850b133-€23.00€0.00matched
10capture01a145a8-35e1-77ef-a838-119d4877970e€15.00€0.26matched
11capture01a145a8-387f-731a-b8a1-ae2d7d07eefa€49.00€0.67matched
12refund01a145a8-4f3a-7909-8fd0-7bd5f711a84a-€4.00€0.00matched
13capture01a145a8-5640-70ce-947c-b958bcef814b€49.00€0.67matched
14capture01a145a8-61cc-7eaa-a8c7-b855e8d8ccba€15.00€0.26matched
15capture01a145a8-8786-7d52-9500-2e0ad04b2838€49.00€0.67matched
16capture01a145a8-8ca0-7023-871c-a656962d5bdc€35.00€0.50matched
17capture01a145a8-91c2-72fc-9946-4eb1c394261e€35.00€0.50matched
18capture01a145a8-9fde-7fa0-897b-65aa3dc4cb84€9.00€0.19matched
19capture01a145a8-a58c-73df-b932-a57511121247€15.00€0.26matched
20capture01a145a8-b0e8-7f4d-b438-4e4d9135f092€9.00€0.19matched
21capture01a145a8-b9fc-773d-81ee-d745478ac2a1€24.00€0.37matched
22capture01a145a8-e0eb-7353-8354-2256adc2e85a€24.00€0.37matched
23refund01a145a8-e574-7473-922c-6742f372f687-€44.00€0.00matched
24capture01a145a8-e87a-79b5-a414-3eba62f9689b€9.00€0.19matched
25capture01a145a8-ed9a-794a-b1d6-d232897cbdac€49.00€0.67matched
26capture01a145a8-f5a6-71de-9e64-4e2c360fc92f€24.00€0.37matched
27capture01a145a9-07a2-7431-bfae-4ac9fffc9f9d€15.00€0.26matched
28capture01a145a9-191a-78bb-8e65-bbcfd0a17cb5€35.00€0.50matched
29capture01a145a9-25a3-7cf4-b231-b54659670408€24.00€0.37matched
30capture01a145a9-2910-720b-ad25-c8a5c6818380€35.00€0.50matched
31capture01a145a9-4f8c-7df2-8f66-7334f80081bc€35.00€0.50matched
32capture01a145a9-5b60-7584-bf38-5ff172781206€49.00€0.67matched
33refund01a145a9-5e40-7099-b8ad-c1f78dea576a-€9.00€0.00matched
34capture01a145a9-930d-7144-86c7-a4d8189d6368€35.00€0.50matched
35capture01a145a9-9389-70c0-9a58-535a4f8b272a€49.00€0.67matched
36capture01a145a9-a601-7eff-9446-4f68d925d148€15.00€0.26matched
37capture01a145a9-c9eb-7d11-9135-1c99b650e43c€24.00€0.37matched
38capture01a145a9-d562-7332-b165-d73ab9c49873€24.00€0.37matched
39capture01a145a9-da01-7869-96af-3770ec6b805a€9.00€0.19matched
40capture01a145aa-0263-7803-b213-83a693362d63€35.00€0.50matched
41capture01a145aa-0764-7714-a29c-2c1cbff3e3d9€35.00€0.50matched
42capture01a145aa-10bb-72af-905a-92a863e5f427€15.00€0.26matched
43capture01a145aa-2868-7e28-9c8d-d0072c588e2b€24.00€0.37matched
44capture01a145aa-4293-7db6-89c5-dca903c6878e€49.00€0.67matched
45capture01a145aa-67f1-7675-863a-96e0358cf719€49.00€0.67matched
46capture01a145aa-6ffd-7025-a9a7-d8cb5e69eccb€9.00€0.19matched
47capture01a145aa-7200-7964-96ed-b8a4b37576b3€49.00€0.67matched
49capture01a145aa-8bc9-7f74-a37e-46422570206a€24.00€0.37matched
50capture01a145aa-90f1-7136-85b3-a21dbd66d69b€15.00€0.26matched
51capture01a145aa-f15a-79ce-8029-02ce0de8ee0e€9.00€0.19matched
52refund01a145aa-f258-71d0-b727-7a8d06f3a0c9-€20.00€0.00matched
53capture01a145ab-05b7-7175-85e6-8a6fb216a9b0€9.00€0.19matched
54capture01a145ab-19b2-7d10-b6a9-3fc521573c0c€9.00€0.19matched
55capture01a145ab-4029-7815-bd44-be400da75530€49.00€0.67matched
56capture01a145ab-6912-765c-9080-70e943d76d6f€49.00€0.67matched
57capture01a145ab-6b9d-7f9f-aa4b-798163859e30€24.00€0.37matched
58capture01a145ab-8517-7287-959b-82dd7e222f4f€49.00€0.67matched
59capture01a145ab-995d-749e-bdc0-3d3fc23ad118€24.00€0.37matched
60capture01a145ab-afa3-7e2b-bc24-a18caa1fbc75€49.00€0.67matched
61capture01a145ab-b094-781d-ae67-402bc5d4575e€24.00€0.37matched
62capture01a145ab-c37a-77dc-8dc5-a7d2d4b1ed57€9.00€0.19matched
63capture01a145ab-e45e-73e3-81fd-35392b60424b€15.00€0.26matched
64capture01a145ab-f9b5-737f-9131-0504e6023211€15.00€0.26matched
65refund01a145ac-4627-7de2-85a0-14085f29b2fc-€6.00€0.00matched
66capture01a145ac-4814-7cc2-95b8-342b4e202442€35.00€0.50matched
67capture01a145ac-5923-7eec-880f-8c26a10c675f€35.00€0.50matched
68capture01a145ac-5fba-7a60-aeb5-fcdc8c9a3d2e€9.00€0.19matched
69capture01a145ac-6083-7363-ba50-fc5849e4c55a€35.00€0.50matched
70capture01a145ac-9b69-7849-bd41-00510226513f€15.00€0.26matched
71capture01a145ac-aa7b-7961-ace2-b0227ed4799e€15.00€0.26matched
72capture01a145ac-ad1e-792b-bf3e-61c9a1a0d8d8€9.00€0.19matched
73capture01a145ac-c579-76c1-a2d3-81880e50dadd€9.00€0.19matched
74capture01a145ac-dd2b-70de-ace0-cabf5db79ea9€15.00€0.26matched
75capture01a145ac-e556-73d4-a7f6-46b10d553727€35.00€0.50matched
76capture01a145ac-fa9b-7816-8ea9-e859eea39e02€9.00€0.19matched
77capture01a145ad-140d-7c4e-a9d5-865cc5628103€15.00€0.26matched
78capture01a145ad-19e7-725d-ad7a-5662a06b4ebc€9.00€0.19matched
79capture01a145ad-136c-782d-9842-b260a42739a8€24.00€0.37matched
80capture01a145ad-21e4-7fb1-9a98-2670241fb347€24.00€0.37matched
81capture01a145ad-22c4-78be-8688-860e8d4cbd13€15.00€0.26matched
82capture01a145ad-3739-74ef-9bfd-1cd0de9a0be0€49.00€0.67matched
83refund01a145ad-38fb-7869-a433-7931ac1779d1-€8.00€0.00matched
84capture01a145ad-47b5-7446-836e-3b96d415c14d€15.00€0.26matched
85capture01a145ad-50e1-7996-a963-59d07c554451€49.00€0.67matched
86capture01a145ad-6377-769a-98b3-f42c573e3b4b€15.00€0.26matched
87capture01a145ad-6b48-77e1-8db2-7904de5f61ef€15.00€0.26matched
88capture01a145ad-a650-7d3e-9ef7-14cf9e649a4c€35.00€0.50matched
89capture01a145ad-b300-7297-ad0a-8879001f31d1€24.00€0.37matched
90capture01a145ad-b908-78a2-8493-7d4ef0e72e7f€49.00€0.67matched
91capture01a145ad-c377-7f6e-ac00-9fea91e095b5€15.00€0.26matched
92capture01a145ad-c701-7cd2-bc75-ec02f1505346€24.00€0.37matched
93capture01a145ad-d0b6-7c01-adfb-be9da8ac29fb€15.00€0.26matched
94capture01a145ad-e6c8-7f91-99df-0ff40c949190€35.00€0.50matched
95capture01a145ae-0ebb-7483-91bb-32ae8075c12b€9.00€0.19matched
96capture01a145ae-226c-7a62-9644-d9e441b02b06€15.00€0.26matched
97capture01a145ae-32db-768f-ad6b-e17451535f27€15.00€0.26matched
98refund01a145ae-3654-7568-b76e-e64cbffb1857-€28.00€0.00matched
99capture01a145ae-38ba-7754-b213-92b0c76558b7€15.00€0.26matched
100capture01a145ae-3af5-76ea-b293-39d3732909b3€9.00€0.19matched
101capture01a145ae-8c96-7335-9af2-183d79a3e061€24.00€0.37matched
102capture01a145ae-bc3b-71c7-a686-96076033cbe0€15.00€0.26matched
103capture01a145ae-d409-79b2-afa6-4b3ece72431c€24.00€0.37matched
104capture01a145ae-f258-76d4-92c4-249b7b5d6142€9.00€0.19matched
105capture01a145af-028c-71bb-ba59-7d645368af15€9.00€0.19matched
106capture01a145af-183e-74ef-b50f-684dad22de0d€15.00€0.26matched
107capture01a145af-1b04-7c01-b2f9-af81be4a4155€15.00€0.26matched
108capture01a145af-2a80-7344-a4ce-d2609e9aec5e€15.00€0.26matched
109capture01a145af-2ff8-75ac-97f4-443b6b8c61ca€49.00€0.67matched
110refund01a145af-46a1-7ca5-a4a6-c552de48822e-€8.00€0.00matched
111capture01a145af-6148-7238-a947-80424498f553€35.00€0.50matched
112capture01a145af-6fc1-7222-92b0-600d39873f33€15.00€0.26matched
113capture01a145af-c41e-752f-b731-ed194fb24270€9.00€0.19matched
114capture01a145af-cdc5-7831-87a6-855c00f42b8c€24.00€0.37matched
115capture01a145af-d743-7599-8d33-c97b25054383€15.00€0.26matched
116capture01a145b0-29a4-77fb-8554-06eeddd5f57b€15.00€0.26matched
117capture01a145b0-57ed-7a80-89af-f83d9dfb1046€24.00€0.37matched
118capture01a145b0-6001-77d1-827d-32f2d924f733€35.00€0.50matched
119capture01a145b0-6237-7768-a1b6-800ef3a46213€24.00€0.37matched
120capture01a145b0-8173-7161-9a6f-cf164e662dfc€9.00€0.19matched
121capture01a145b0-8302-748c-9c4e-2d29ab653a53€15.00€0.26matched
122capture01a145b0-9e8c-7cf9-bea1-e808c045b121€49.00€0.67matched
123refund01a145b0-bfe2-74ec-8452-f57f63c309dc-€13.00€0.00matched
124capture01a145b0-c2eb-7280-bce9-27bd04ae3d8e€49.00€0.67matched
125capture01a145b0-d697-7441-ae3c-09d15439554f€9.00€0.19matched
126capture01a145b0-dda1-7439-917f-bd83b4209b37€24.00€0.37matched
127capture01a145b0-e2e5-70f2-806f-48fa56bc1e2b€35.00€0.50matched
128capture01a145b0-f569-767b-af18-9331c9d8f44b€15.00€0.26matched
129refund01a145b0-fcd6-7826-87b1-85f54ebffaa9-€47.00€0.00matched
130capture01a145b1-12ce-707e-bc13-b007ca36799b€35.00€0.50matched
131capture01a145b1-1ea5-752f-bdcb-0bc4d8df4362€15.00€0.26matched