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

15 Oct, 20:30

Gross

€3,287.00

PSP fee

€51.86

Net to the bank

€3,235.14

Settlement journal

#20864

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a14143-2344-776a-8d83-501bee63e50b is already settled by stl_EUR_2986827 line 19
LineKindReferenceGrossFeeStatus
20capture01a14143-2382-7873-9104-e833ede84b22€35.00€0.50duplicate line
1capture01a1413d-1cca-787e-8688-1f20655d323d€24.00€0.37matched
2capture01a1413d-42c7-7c8e-91dc-029031fcb941€15.00€0.26matched
3capture01a1413f-a3b8-783c-a8b8-5314ce65abe9€24.00€0.37matched
4capture01a14140-5e67-73d4-86a5-c08f729d762c€49.00€0.67matched
5capture01a14141-eec4-7680-b29f-5f64bd32244f€35.00€0.50matched
6capture01a14141-f7a1-725d-b3f1-12db758f991a€49.00€0.67matched
7capture01a14142-0af0-7d73-991f-1082375709fc€24.00€0.37matched
8capture01a14142-2f7d-7f5d-b3c6-faef038e7276€9.00€0.19matched
9capture01a14142-3089-77ec-ae25-afbaca771541€15.00€0.26matched
10capture01a14142-436e-7157-8722-c0754d8bd1bd€49.00€0.67matched
11refund01a14142-5a3b-7d8b-9f5b-6ed829721988-€34.00€0.00matched
12capture01a14142-6fab-71dd-b96a-1c4d2c383b5a€15.00€0.26matched
13capture01a14142-9a13-77eb-95ce-ba434c2fa7c2€9.00€0.19matched
14capture01a14142-9dac-70fa-8bb8-d2ad4ee0956d€15.00€0.26matched
15capture01a14142-daa1-7488-9106-72b1cc2f7b0e€15.00€0.26matched
16capture01a14142-fbb4-7a49-b6b6-f6d5244f6105€35.00€0.50matched
17capture01a14143-1526-70d4-ab6c-7c8320322494€9.00€0.19matched
18capture01a14143-193c-7195-ae6c-6a51de37459f€15.00€0.26matched
19capture01a14143-2382-7873-9104-e833ede84b22€35.00€0.50matched
21capture01a14143-2854-74f4-90f9-8029f21c1766€24.00€0.37matched
22refund01a14143-2e41-7517-8e10-eab5936d6a65-€10.00€0.00matched
23capture01a14143-328e-7e09-b717-d380a2ad7a3d€35.00€0.50matched
24capture01a14143-4350-7223-b035-2d41f4bca622€24.00€0.37matched
25capture01a14143-4411-7af9-8b9e-0f5ad30f5178€15.00€0.26matched
26capture01a14143-450e-71fd-8d77-e576c19bcda0€49.00€0.67matched
27capture01a14143-4a02-716f-8a5b-199683a7f26d€15.00€0.26matched
28capture01a14143-832d-7158-8768-3fce87adbd5e€15.00€0.26matched
29capture01a14143-9338-7d53-b22e-41425be6ff45€15.00€0.26matched
30capture01a14143-9058-7c7e-93e8-f46f40c43372€15.00€0.26matched
31capture01a14143-9683-716c-a7df-75a5297348e7€9.00€0.19matched
32capture01a14143-99e8-7269-a2b7-449218ffb3ec€49.00€0.67matched
33capture01a14143-9afd-72c2-8e1d-ed4c9d7934f7€49.00€0.67matched
34capture01a14143-9e48-7fe2-84b1-4c3f4b180481€49.00€0.67matched
35capture01a14143-a01c-7902-8fc1-7c409c7edc2a€49.00€0.67matched
36capture01a14143-c55c-7b30-a38d-28b3bfa897ff€49.00€0.67matched
37capture01a14143-c67a-7271-ae44-7466088eee9b€24.00€0.37matched
38refund01a14143-c8e3-770f-8361-f2d5d0700095-€10.00€0.00matched
39capture01a14143-ce14-7d9f-9e9f-2f5be68133e2€35.00€0.50matched
40capture01a14143-dfce-7365-8e5b-c994738ed4c8€9.00€0.19matched
41capture01a14143-fdbd-78f0-8651-6aafc4395ac5€24.00€0.37matched
42capture01a14143-fdba-7461-8005-1d47d904f47e€9.00€0.19matched
43capture01a14144-09aa-730b-878d-6404dff2df39€9.00€0.19matched
44capture01a14144-13c6-75b3-b494-90ce1016352c€9.00€0.19matched
45capture01a14144-222c-7d9f-9f0e-300619ac4341€9.00€0.19matched
46capture01a14144-2598-7867-9ea7-132f750e6561€24.00€0.37matched
47capture01a14144-318b-792d-adf2-c536370ee060€15.00€0.26matched
48capture01a14144-3227-73a1-b716-5b44c6c24427€15.00€0.26matched
49capture01a14144-3b3e-79e6-8d7e-925ac8560452€49.00€0.67matched
50capture01a14144-3e93-74ed-b233-07563b75d905€49.00€0.67matched
51capture01a14144-4f09-73da-9b63-ad3bc25c7be6€15.00€0.26matched
52capture01a14144-6fba-7d1e-a751-35be919425fe€9.00€0.19matched
53refund01a14144-7bdf-7a8d-beec-13fb3191ad8b-€14.00€0.00matched
54capture01a14144-7cb1-7785-ad0f-cb8c58847297€9.00€0.19matched
55capture01a14144-9482-767a-9532-e6ec5d97bee7€24.00€0.37matched
56capture01a14144-a74a-7f2c-b7d0-2e0dd1c12865€49.00€0.67matched
57capture01a14144-ab4b-73b0-a767-21db5c19f14a€35.00€0.50matched
58capture01a14144-ad88-7114-ac8f-d79cd35fd890€35.00€0.50matched
59capture01a14144-bf10-7d16-8335-9b997505c47d€9.00€0.19matched
60capture01a14144-bf28-729c-9141-b0f4af568c4a€15.00€0.26matched
61capture01a14144-de91-79f0-aa2c-7958b656c56a€15.00€0.26matched
62capture01a14144-e136-7ed7-93f9-29ccdcef8bab€49.00€0.67matched
63capture01a14145-07a1-7304-a798-614b544604e3€15.00€0.26matched
64capture01a14145-1d2d-725c-8211-1b6ba8017ff2€49.00€0.67matched
65capture01a14145-26f8-7077-bbca-a99134b22529€9.00€0.19matched
66capture01a14145-3501-7648-b085-0c1c083fcd24€15.00€0.26matched
67capture01a14145-384d-78e6-8609-d5cedc8e046d€24.00€0.37matched
68capture01a14145-48fd-79df-ba4b-79a9d2c8980c€9.00€0.19matched
69capture01a14145-56d3-72bf-b4de-a8c585b70217€35.00€0.50matched
70refund01a14145-6a56-7e16-8cf0-c55b5e7f0ebe-€9.00€0.00matched
71refund01a14145-99d0-73d0-9557-b0b6459901ac-€32.00€0.00matched
72capture01a14145-d201-7425-8a74-3bdbb8248452€35.00€0.50matched
73capture01a14145-e12e-7d63-80d4-e4bb861b6f2b€9.00€0.19matched
74capture01a14145-ff4b-73c6-801f-e0e3fc1c8327€35.00€0.50matched
75capture01a14146-2f2a-7be6-b2bb-ffd5012058de€49.00€0.67matched
76capture01a14146-3cf9-775e-8e12-8d7384f88337€24.00€0.37matched
77capture01a14146-3f5a-7ae7-8033-1ce4e43c6cd8€15.00€0.26matched
78capture01a14146-4bcb-746d-984e-daaaa4f1757d€35.00€0.50matched
79capture01a14146-8ba8-79a2-b74c-1dfb2530da7c€35.00€0.50matched
80capture01a14146-c059-7188-9c18-30d2ac1004c9€24.00€0.37matched
81capture01a14146-caa3-7cd2-b89c-c39ab8699826€9.00€0.19matched
82capture01a14146-d507-7606-9927-89c5cbe0a3a6€24.00€0.37matched
83capture01a14147-0ca5-763a-8c88-4a6db10d20c3€24.00€0.37matched
84capture01a14147-22ee-75eb-8504-37c5d08b1eb9€35.00€0.50matched
85capture01a14147-3df4-7482-91f5-d4435790eadf€35.00€0.50matched
86capture01a14147-4c48-716a-b676-a4bfb2b02ed9€15.00€0.26matched
87capture01a14147-4d26-728e-871f-06268af49fd0€35.00€0.50matched
88capture01a14147-5513-7737-9230-4896782885df€9.00€0.19matched
89capture01a14147-5669-71ea-ada7-4049a8e407e0€35.00€0.50matched
90capture01a14147-6031-7f1f-93ac-b0051c238325€49.00€0.67matched
91capture01a14147-7074-7bf8-9cd3-a103023f1bda€49.00€0.67matched
92capture01a14147-8d2c-73fe-a562-59e252bc2255€35.00€0.50matched
93capture01a14147-c8b5-7d4c-878b-0d9dc25a0e4c€15.00€0.26matched
94capture01a14147-c8fd-7cd1-a1c4-cb38ef0c338e€24.00€0.37matched
95capture01a14147-d30c-7829-b8b7-bae3221bb722€49.00€0.67matched
96capture01a14147-f04d-73af-a99f-29d7de5bb883€9.00€0.19matched
97capture01a14148-0e00-7093-9562-8f6b83018a9e€49.00€0.67matched
98capture01a14148-17c4-7203-a46c-2839b86061c8€15.00€0.26matched
99capture01a14148-263d-7985-b752-05ecc943803b€35.00€0.50matched
100refund01a14148-309c-7515-b6fe-6206a32cb394-€5.00€0.00matched
101capture01a14148-3fd6-7db7-b539-a296cf5604b6€15.00€0.26matched
102capture01a14148-4b16-72f4-91d5-055c42d9c28b€35.00€0.50matched
103capture01a14148-5ede-7d53-b465-674cb80f1736€9.00€0.19matched
104refund01a14148-9d9c-75c5-b0a4-8404694b7f31-€7.00€0.00matched
105capture01a14148-ac9b-787f-8050-b5f294138504€15.00€0.26matched
106capture01a14148-c124-72e2-86c5-b275153a769e€15.00€0.26matched
107capture01a14148-c202-7171-9dda-ec314ace8dbb€15.00€0.26matched
108capture01a14148-c8ce-702c-b3d4-82b89c80431f€24.00€0.37matched
109capture01a14148-d00b-7751-8987-0d8129cbd18c€49.00€0.67matched
110capture01a14148-f5a1-7948-82d9-96d9a4ff8bba€49.00€0.67matched
111capture01a14148-f92c-7629-9e0d-0e7d21a22ccd€15.00€0.26matched
112capture01a14149-072a-704a-be39-b293cd6b7763€35.00€0.50matched
113capture01a14149-09bd-7f64-8ad2-74c948d7df4c€49.00€0.67matched
114capture01a14149-1a9a-767b-bd8f-82c1aa4069ee€24.00€0.37matched
115capture01a14149-270d-740f-ac55-051a00f14a67€35.00€0.50matched
116capture01a14149-5723-7a83-b047-481cfdeb78e2€35.00€0.50matched
117capture01a14149-5c08-73bd-88ef-5546ca0c3607€35.00€0.50matched
118capture01a14149-60e4-7036-a2d1-2bb38a795789€35.00€0.50matched
119capture01a14149-6255-75de-9c83-b1a6f5efb5f0€9.00€0.19matched
120capture01a14149-65cd-77f0-b5a9-64c96725c2c3€9.00€0.19matched
121capture01a14149-67e3-7bc4-a4c1-f7762d6afdd8€35.00€0.50matched
122capture01a14149-8993-7fa8-ba5e-172408794ad9€9.00€0.19matched
123capture01a14149-971a-7744-954a-170b4771115d€49.00€0.67matched
124capture01a14149-a427-74cb-b9b8-223289e27295€15.00€0.26matched
125capture01a14149-ab25-7121-851c-ef91b3cd9004€35.00€0.50matched
126capture01a14149-b01e-7824-8904-47532dd73bf6€24.00€0.37matched
127capture01a14149-eed5-7e2e-bb87-41eb01229fcb€15.00€0.26matched
128capture01a14149-fd44-724b-894e-9f3356802447€15.00€0.26matched
129capture01a1414a-098e-7ed5-a6f3-34278c200fc6€24.00€0.37matched
130capture01a1414a-1090-7764-8ed3-963008cea3ac€24.00€0.37matched
131capture01a1414a-3c74-7bd8-b825-647ea66dc84e€9.00€0.19matched
132capture01a1414a-5644-72ff-90b3-fcdb6717cb01€15.00€0.26matched
133refund01a1414a-6872-72b0-b793-cc978b137eee-€11.00€0.00matched
134capture01a1414a-6bad-7495-809c-db438168b22b€9.00€0.19matched
135capture01a1414a-71dd-760a-8094-ed6dbfb99e70€15.00€0.26matched
136capture01a1414a-8f81-7b44-aff7-682f38305dee€49.00€0.67matched
137capture01a1414a-966b-7d81-b2f3-e3b74f5d3169€35.00€0.50matched
138capture01a1414a-a54b-74d3-9e54-457dc5cafa24€35.00€0.50matched
139capture01a1414a-d0e6-7188-ba51-f966b3af0108€24.00€0.37matched
140capture01a1414a-e135-704f-939d-6033694799d1€15.00€0.26matched
141refund01a1414a-e607-7a60-8578-a9266b731011-€11.00€0.00matched
142capture01a1414b-00fa-7dfa-b945-ffbb0aced876€24.00€0.37matched