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

2 Nov, 21:20

Gross

€3,132.00

PSP fee

€49.15

Net to the bank

€3,082.85

Settlement journal

#349632

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19e24-123d-7c21-b527-defe27d60656 is already settled by stl_EUR_2989424 line 33
LineKindReferenceGrossFeeStatus
34capture01a19e24-2961-75bf-a6f8-5cabc3337b2d€24.00€0.37duplicate line
1capture01a19e19-2c46-74ca-8561-64c28ef89fdf€35.00€0.50matched
2refund01a19e1b-8751-7d85-b9be-76a2ead9b469-€16.00€0.00matched
3capture01a19e1c-a97d-730a-85d8-c62f892da7f1€9.00€0.19matched
4capture01a19e1d-c1ba-7e1e-89a8-4967395c3c34€9.00€0.19matched
5capture01a19e21-ade2-78b0-912b-504d520b0478€15.00€0.26matched
6capture01a19e22-2578-734a-95db-4bc4040b264a€15.00€0.26matched
7capture01a19e22-25a4-75de-bdc1-da35d62c239f€35.00€0.50matched
8capture01a19e22-4144-71e8-b703-017472282269€9.00€0.19matched
9refund01a19e22-4e03-7017-aa29-8f5ed42ea63a-€4.00€0.00matched
10capture01a19e22-5a4f-715f-b0ab-cf54d724c294€24.00€0.37matched
11capture01a19e22-7da4-72c3-bb47-2b78ab5aaaf6€9.00€0.19matched
12capture01a19e22-7e1c-7856-88e6-f25a5e8dd99b€15.00€0.26matched
13capture01a19e22-9281-767c-9170-7415d796c4a1€9.00€0.19matched
14capture01a19e22-bcb1-7763-8882-9c436fb01fd8€49.00€0.67matched
15capture01a19e22-be12-7b74-91be-b1274d5d6fe1€15.00€0.26matched
16capture01a19e22-dfa9-7012-8719-d4fab9e55c8e€35.00€0.50matched
17capture01a19e22-eca8-781f-95e4-4131c2c101ba€35.00€0.50matched
18capture01a19e22-f545-7754-88c2-dd10e6652ed9€9.00€0.19matched
19capture01a19e23-0287-7445-a967-ee246674259f€49.00€0.67matched
20capture01a19e23-1608-72a1-a6bb-4bfaee7bbacf€9.00€0.19matched
21capture01a19e23-3059-7dc0-a4d3-16146e61a439€9.00€0.19matched
22capture01a19e23-4b5c-7436-8162-d0f66faded07€9.00€0.19matched
23capture01a19e23-546c-7745-bbfe-1196719be7f8€24.00€0.37matched
24capture01a19e23-5ab9-7c9e-ad90-3860c519d864€9.00€0.19matched
25capture01a19e23-5c6a-7b03-b305-bec567a5db01€15.00€0.26matched
26capture01a19e23-5f82-7951-8dd0-b58c8975f101€35.00€0.50matched
27capture01a19e23-634f-7c67-b71e-8adad2fc7422€24.00€0.37matched
28capture01a19e23-8467-7441-a658-a9ca8ebf689f€9.00€0.19matched
29capture01a19e23-dff6-7d53-949e-1dea85a8dd93€49.00€0.67matched
30capture01a19e23-e7ca-7d6e-a63e-4b7c870868b3€15.00€0.26matched
31capture01a19e23-f9c7-74d6-b88b-0605fe18ac8d€35.00€0.50matched
32capture01a19e24-08ce-7901-8b2e-41b4813e7af6€49.00€0.67matched
33capture01a19e24-2961-75bf-a6f8-5cabc3337b2d€24.00€0.37matched
35capture01a19e24-32c4-75c8-b7f8-11f96a36cdb8€35.00€0.50matched
36capture01a19e24-4a45-7e95-84f7-03a9dad49c58€15.00€0.26matched
37refund01a19e24-6375-7948-846b-3a7e01d09556-€29.00€0.00matched
38capture01a19e24-7653-7d0f-90a1-c1f21222516e€35.00€0.50matched
39capture01a19e24-9f91-7d34-b2b8-3bc25b71fe6a€24.00€0.37matched
40capture01a19e24-a7b0-74c0-bc32-6b11cf65aa9d€24.00€0.37matched
41capture01a19e24-cb04-774c-91f6-c7d7b5796371€24.00€0.37matched
42capture01a19e24-cb61-76ba-9bb4-5d3d92e8544d€15.00€0.26matched
43capture01a19e24-d599-7617-bfa8-7530818cd545€9.00€0.19matched
44capture01a19e24-d904-76a0-8a71-2dbece31dc96€35.00€0.50matched
45capture01a19e24-f11a-7d27-821f-ca23e1eb21d4€9.00€0.19matched
46refund01a19e24-fd19-7271-bb2a-ad67ba908fda-€12.00€0.00matched
47capture01a19e24-ff54-7207-9363-54106a769cb6€35.00€0.50matched
48capture01a19e25-0d82-7f58-8d29-bd2f09eab3ce€15.00€0.26matched
49capture01a19e25-14eb-77bc-8c80-2b7d9dcc11b2€35.00€0.50matched
50capture01a19e25-3bf1-796c-a3de-7a73527df9e2€49.00€0.67matched
51capture01a19e25-546f-74b1-9166-7ddb66b7bca0€35.00€0.50matched
52refund01a19e25-6359-7909-b605-b800596edd6c-€29.00€0.00matched
53capture01a19e25-8af7-75c5-b978-2b07726b9085€15.00€0.26matched
54capture01a19e25-aae1-7817-bc78-addc5514171b€35.00€0.50matched
55capture01a19e25-b275-752d-a473-5a7d30f611e9€49.00€0.67matched
56capture01a19e25-b914-7ff9-b96a-029b51d79197€35.00€0.50matched
57capture01a19e25-c49b-7665-ba66-4a0ac100807b€49.00€0.67matched
58capture01a19e25-ec48-753d-a37d-7e2cf6896576€15.00€0.26matched
59capture01a19e25-f1bf-77d2-bb01-0adbfa5ceffc€24.00€0.37matched
60capture01a19e26-0d8d-76a8-8875-59738d49d409€24.00€0.37matched
61capture01a19e26-19bf-78e0-bd21-4ce042610b8a€9.00€0.19matched
62capture01a19e26-308b-7f16-93cc-719dc9cf2176€35.00€0.50matched
63capture01a19e26-3d08-727e-87f7-b258a93d7c6d€35.00€0.50matched
64capture01a19e26-3f27-7e96-bb35-8d4dd99d2bea€24.00€0.37matched
65capture01a19e26-3f3a-771f-a513-3f0e7b2b49d6€49.00€0.67matched
66capture01a19e26-4bc7-7fc0-9e85-dcad3e1f2fbe€15.00€0.26matched
67capture01a19e26-584d-7c78-864c-4e9a7dbce008€15.00€0.26matched
68capture01a19e26-5f2b-765a-98e2-363c9ac00eb1€35.00€0.50matched
69capture01a19e26-954c-7801-a048-c46843731d3d€15.00€0.26matched
70capture01a19e26-9935-7008-90cd-f744a3150d05€49.00€0.67matched
71capture01a19e26-b03e-7a66-867e-9c2247ae5990€24.00€0.37matched
72capture01a19e26-bc25-7a49-b971-0277e1c78ffd€24.00€0.37matched
73capture01a19e26-c5df-7c90-83e7-1edc565d3429€35.00€0.50matched
74capture01a19e26-ef12-7aba-b71c-b60a9f73b5a5€9.00€0.19matched
75capture01a19e27-016d-7274-ac40-a921b1d044d3€24.00€0.37matched
76capture01a19e27-0fbb-734d-bb81-4daa0852bf61€24.00€0.37matched
77capture01a19e27-136d-7c64-9320-e091bdd5e786€24.00€0.37matched
78refund01a19e27-13dc-7218-a68f-91e90a018af3-€10.00€0.00matched
79capture01a19e27-213f-70d9-b456-6c7e8e2fc6b0€49.00€0.67matched
80capture01a19e27-3310-7c23-a5bd-6964f4f0f218€9.00€0.19matched
81capture01a19e27-3b99-76e9-a92c-711853300fb3€49.00€0.67matched
82refund01a19e27-4908-72c1-94bf-de3e51ce3114-€16.00€0.00matched
83capture01a19e27-4ea2-78ee-a01c-c9ac22f1b6a8€35.00€0.50matched
84capture01a19e27-5273-7426-aaaf-4927b001e171€15.00€0.26matched
85capture01a19e27-b50b-7c07-8e9f-6748e4ce0c0a€49.00€0.67matched
86capture01a19e27-b751-7182-82df-68b788df753d€49.00€0.67matched
87capture01a19e27-b9f3-78fa-be74-888433c3e2bc€49.00€0.67matched
88capture01a19e27-c4b2-73ac-aeaa-5690f9264f73€35.00€0.50matched
89capture01a19e27-d4a6-7737-add0-784a1c0ff24f€35.00€0.50matched
90capture01a19e28-0c83-78eb-9247-cdd34868f317€9.00€0.19matched
91capture01a19e28-15a3-7d48-975d-03c916258b8a€15.00€0.26matched
92capture01a19e28-51f7-7a98-8617-2fa0dd0669fa€49.00€0.67matched
93capture01a19e28-5579-7f11-9ab7-2e98cc4c0eb3€9.00€0.19matched
94capture01a19e28-5bcb-7c4d-a76e-2d3eadd227c2€9.00€0.19matched
95capture01a19e28-5c01-79ec-ac35-16c670294b01€49.00€0.67matched
96capture01a19e28-6b3c-7422-8cc8-be5afe3b48cf€24.00€0.37matched
97capture01a19e28-ac4b-720b-b540-8c45a65430b7€24.00€0.37matched
98capture01a19e28-b764-7c0b-9741-d274b21cb648€49.00€0.67matched
99capture01a19e28-bff5-78e7-b572-a337d0a10fc1€35.00€0.50matched
100refund01a19e28-c2c5-7f3b-94ea-6fa631037108-€15.00€0.00matched
101capture01a19e28-d042-72c5-b7f9-7ca45606f7a4€49.00€0.67matched
102capture01a19e28-ec40-7d65-ac5f-ba93ac33fd5a€24.00€0.37matched
103capture01a19e28-fe3b-7529-920c-5ceec7669b2e€24.00€0.37matched
104capture01a19e29-0b9a-7304-b14e-796e1b7c6d30€35.00€0.50matched
105capture01a19e29-1b60-787b-824e-434ccb8b14d7€35.00€0.50matched
106capture01a19e29-3f66-7121-9a74-78cec181bb38€49.00€0.67matched
107capture01a19e29-84b1-72d7-a52b-61e3a9fb5900€24.00€0.37matched
108capture01a19e29-99f3-754b-860e-0b4dfb21b72e€35.00€0.50matched
109capture01a19e29-9c41-73ba-88c9-0adaaf3e7024€24.00€0.37matched
110capture01a19e29-cdd8-71ef-9c27-7b209dfd35f6€9.00€0.19matched
111capture01a19e29-f9fb-77cd-bb89-159024e3d9e1€35.00€0.50matched
112capture01a19e2a-0662-7b81-8fa3-3c3582d37ff9€24.00€0.37matched
113capture01a19e2a-2dc6-76af-84b2-baaf5c58fc0c€24.00€0.37matched
114capture01a19e2a-2e1d-7dde-826d-c051c686758a€49.00€0.67matched
115refund01a19e2a-3c67-78f6-a21e-1cc738b35e36-€6.00€0.00matched
116capture01a19e2a-3e50-705a-a7ca-29e957449b41€49.00€0.67matched
117capture01a19e2a-5de3-7ca1-8024-bfc660aaf0bd€9.00€0.19matched
118capture01a19e2a-67b9-76e8-97cb-0f70a78931bf€15.00€0.26matched
119capture01a19e2a-743b-75f0-89b9-995fe59a4597€24.00€0.37matched
120capture01a19e2a-8b4c-730b-9233-19d6fcec0980€15.00€0.26matched
121capture01a19e2a-a2de-7276-bace-a14800fe341b€15.00€0.26matched
122capture01a19e2a-a313-7ba2-bf28-f582c4c5c35b€49.00€0.67matched
123capture01a19e2a-c02a-74ec-baf5-0b8df7a71016€24.00€0.37matched
124refund01a19e2a-c3f2-7510-a9ac-70111fa8e033-€8.00€0.00matched
125capture01a19e2a-cabb-71b5-8f15-026df9bd184d€24.00€0.37matched
126capture01a19e2a-cd9b-701f-abdc-ab22a304ec4b€35.00€0.50matched
127capture01a19e2a-d501-71fd-80c4-f18e4239eccb€9.00€0.19matched
128capture01a19e2a-f454-7062-93df-7ee16bf9f755€24.00€0.37matched
129capture01a19e2b-0260-70d0-af07-bb4082052d14€35.00€0.50matched
130capture01a19e2b-0851-7d4c-b356-f4fd38196882€49.00€0.67matched
131capture01a19e2b-0f3a-7dc1-80a5-52da4cf8651b€15.00€0.26matched