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

4 Nov, 03:20

Gross

€2,716.00

PSP fee

€43.92

Net to the bank

€2,672.08

Settlement journal

#372387

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a495-0184-739c-b27e-e18904ce4fb7 is already settled by stl_EUR_2989604 line 31
LineKindReferenceGrossFeeStatus
32capture01a1a495-019d-77a8-8761-65d87bb99ac5€24.00€0.37duplicate line
1capture01a1a489-254d-7061-9f87-81205c1a767c€35.00€0.50matched
2capture01a1a48c-21af-700b-ab21-2529b487c060€35.00€0.50matched
3refund01a1a48e-1b79-70f9-b935-935aaa3e16eb-€12.00€0.00matched
4capture01a1a490-2d36-7695-b4fb-bbddec9fbbd3€49.00€0.67matched
5capture01a1a492-2687-7068-8bc2-f3fd4b7d1586€15.00€0.26matched
6capture01a1a492-4f65-75f9-af9b-04c59d456362€15.00€0.26matched
7capture01a1a492-58ff-7d84-bc71-96f13885a65b€15.00€0.26matched
8refund01a1a492-7050-761d-bbba-c5f2b66e1bb5-€29.00€0.00matched
9capture01a1a492-71c9-7122-acc8-8593b9c73867€15.00€0.26matched
10capture01a1a492-7de0-7305-9005-ea5bf77543a2€49.00€0.67matched
11capture01a1a492-86ff-72e5-bfb7-46f1054b5a6b€49.00€0.67matched
12capture01a1a492-8b8c-7379-a08f-48d2ccb06f61€15.00€0.26matched
13capture01a1a492-fc8a-71c1-a635-b915135ffb60€9.00€0.19matched
14capture01a1a493-1ac4-7e9a-bdb2-f8f76f9c3e76€15.00€0.26matched
15capture01a1a493-2caa-7e3a-887d-a0e3fa514699€15.00€0.26matched
16capture01a1a493-2f3f-7f5a-bf18-305d31c5c374€24.00€0.37matched
17capture01a1a493-48c4-730d-ad5d-21b1fe950040€9.00€0.19matched
18capture01a1a493-5ac8-7223-acf6-e45c36b83d4c€49.00€0.67matched
19capture01a1a493-7ba1-7ca2-86c5-fcbb7083ff98€15.00€0.26matched
20capture01a1a493-9cd6-7c68-bb0e-f968799e6a60€35.00€0.50matched
21capture01a1a493-9efa-7b73-a3bb-72f1683e220e€9.00€0.19matched
22capture01a1a493-cd2b-707e-bc0f-91a76e47317f€49.00€0.67matched
23capture01a1a493-dd22-7591-a893-e125ee39d3b7€35.00€0.50matched
24refund01a1a493-e0b0-75e6-9129-0335ccd74a90-€26.00€0.00matched
25capture01a1a493-fba9-737b-964d-74fe7cf03fbc€49.00€0.67matched
26capture01a1a494-324c-7949-9b3c-4e2d0cb6fda3€15.00€0.26matched
27capture01a1a494-aa16-772b-82ee-acef5b49ab99€9.00€0.19matched
28capture01a1a494-ab03-7d1f-96d1-313a4ec1ef10€35.00€0.50matched
29capture01a1a494-ba7f-7216-ad43-119e83166298€15.00€0.26matched
30capture01a1a494-f71d-798b-9d45-f7460705a29d€24.00€0.37matched
31capture01a1a495-019d-77a8-8761-65d87bb99ac5€24.00€0.37matched
33capture01a1a495-13d7-7bf0-80eb-65becd44b017€35.00€0.50matched
34capture01a1a495-1c1d-7851-8766-043d84990a09€15.00€0.26matched
35capture01a1a495-27cf-798f-9752-f3d9235ec087€49.00€0.67matched
36capture01a1a495-4a94-7aba-9a5c-8ce8c861a770€24.00€0.37matched
37refund01a1a495-b3f0-7f64-bd80-093b785bccf1-€11.00€0.00matched
38capture01a1a495-bccf-7e7b-9104-f229899a9ccc€24.00€0.37matched
39capture01a1a495-f6d1-7d33-a82a-68d1ef3f727a€49.00€0.67matched
40capture01a1a495-fe6e-703f-94bf-223ccd105998€49.00€0.67matched
41capture01a1a495-ff7c-720c-958f-99730669c2ed€15.00€0.26matched
42capture01a1a496-142f-7f67-b2c9-a156803454c3€35.00€0.50matched
43capture01a1a496-1b14-7fcd-a94a-792d2f569306€9.00€0.19matched
44capture01a1a496-48ad-703d-afe2-d6e755292e79€15.00€0.26matched
45capture01a1a496-5775-7a53-86bc-d3741f0f9624€49.00€0.67matched
46capture01a1a496-66cd-7fba-a171-e10858dd2abf€49.00€0.67matched
47refund01a1a496-6da0-7c1c-a077-bb9a554a1a49-€19.00€0.00matched
48capture01a1a496-7180-7dc8-9be5-68d53438d668€9.00€0.19matched
49capture01a1a496-a104-7ce9-ae36-47aa21d2296b€35.00€0.50matched
50capture01a1a496-c2be-7510-b57e-17e14566dd40€49.00€0.67matched
51capture01a1a496-daaa-7e34-a8bf-29be0479d227€9.00€0.19matched
52capture01a1a496-dc0f-764c-ae76-a42c6ee6a865€15.00€0.26matched
53capture01a1a496-ee94-7969-979e-764c3638440e€15.00€0.26matched
54capture01a1a496-fee7-778f-9ed4-56c69eac4de0€9.00€0.19matched
55capture01a1a497-413b-72d0-8ab1-06823bbc6c18€24.00€0.37matched
56capture01a1a497-484a-7eab-b653-ff8518f3d9c8€15.00€0.26matched
57capture01a1a497-4be9-7d6e-8dfc-3c11fa9228e0€49.00€0.67matched
58capture01a1a497-4d14-75a1-91df-0f8491e8bb5d€35.00€0.50matched
59capture01a1a497-7acc-7f6c-9fce-20af7869e0ee€35.00€0.50matched
60capture01a1a497-91ee-7587-a67d-573f30db122b€49.00€0.67matched
61capture01a1a497-a93e-7272-ae98-8aa0d797fe6f€49.00€0.67matched
62capture01a1a497-cb37-7700-acc8-f87d03965456€9.00€0.19matched
63capture01a1a497-e43a-7dcc-9c8e-a6c9891de6d5€9.00€0.19matched
64refund01a1a498-056d-79fe-8334-67446deca4df-€28.00€0.00matched
65capture01a1a498-2866-7673-95a5-b76a25d0f46f€24.00€0.37matched
66capture01a1a498-2b22-7747-8df6-e8e64ae28efd€9.00€0.19matched
67capture01a1a498-321d-7443-ae39-6c77b01c74ba€35.00€0.50matched
68capture01a1a498-6f89-7690-8ed8-8e917717d7bf€24.00€0.37matched
69capture01a1a498-7525-7fdc-be8b-f51ad356ed08€24.00€0.37matched
70capture01a1a498-8157-7b95-8b09-3dbfd4d678c8€9.00€0.19matched
71refund01a1a498-83c0-7f93-93d9-821c688e4ae2-€10.00€0.00matched
72capture01a1a498-894e-7569-b244-6a2070a0c6f9€49.00€0.67matched
73capture01a1a498-8ab7-731b-98dc-ef88ffa5bc04€49.00€0.67matched
74capture01a1a498-92da-77bb-b0c1-89250e0e7047€15.00€0.26matched
75capture01a1a498-a5df-71e9-bd93-86d5095e4cb4€9.00€0.19matched
76capture01a1a498-b8cc-70a2-8fe8-655aeba5fcef€24.00€0.37matched
77capture01a1a498-bea3-7861-bc40-edac862d0786€35.00€0.50matched
78capture01a1a498-cca1-7111-b463-bffbadf5f1a2€15.00€0.26matched
79capture01a1a498-cce9-7204-9488-22a5dec394ea€49.00€0.67matched
80capture01a1a498-e678-7892-8360-563f2dae440d€9.00€0.19matched
81capture01a1a499-20bb-78bd-9fe8-a38477fa7ead€9.00€0.19matched
82capture01a1a499-23ff-7239-bd75-d60026cfb728€15.00€0.26matched
83capture01a1a499-24a5-7e3b-941e-66bf47f4e37d€35.00€0.50matched
84capture01a1a499-33ce-7312-b3f2-a012ae553daf€35.00€0.50matched
85capture01a1a499-3dcb-7643-8193-43b62dced0f9€35.00€0.50matched
86capture01a1a499-538a-72e8-990f-dc3b53095910€49.00€0.67matched
87refund01a1a499-6042-7f9c-b56d-5d88838c18da-€5.00€0.00matched
88refund01a1a499-64fb-75f7-b1a7-c80f779baa81-€21.00€0.00matched
89capture01a1a499-861d-736e-9298-8c7e9e51c288€35.00€0.50matched
90capture01a1a499-8846-7803-920c-d8407b65d298€35.00€0.50matched
91capture01a1a499-8d4d-79b7-81a6-26af5d2db8ef€49.00€0.67matched
92capture01a1a499-a294-7a02-b537-0783a42f7e07€9.00€0.19matched
93capture01a1a499-abba-79a5-8e91-8bf0db7c18c3€49.00€0.67matched
94capture01a1a499-b855-7d25-a54e-42c7332cafd5€35.00€0.50matched
95capture01a1a499-ce16-7ef3-ba18-4ddeaa1db142€24.00€0.37matched
96capture01a1a499-e22f-79c1-bca3-4c2cfeac1adc€24.00€0.37matched
97capture01a1a49a-094c-7a86-9c79-cd561792cab7€49.00€0.67matched
98capture01a1a49a-0995-7bd4-b6cf-72efb99c9838€49.00€0.67matched
99capture01a1a49a-2176-7ee3-8a06-19ffd9ae51e9€9.00€0.19matched
100capture01a1a49a-295b-7c7f-b03c-4476a04a5638€24.00€0.37matched
101capture01a1a49a-3476-7e2f-9ded-84a43786a04e€15.00€0.26matched
102capture01a1a49a-5666-72e1-91ec-958364676440€49.00€0.67matched
103capture01a1a49a-5857-76c8-99c1-ba0ff7b12a23€24.00€0.37matched
104capture01a1a49a-5fb1-7bb7-b0e0-b007b8c66a41€9.00€0.19matched
105capture01a1a49a-6959-79cd-8389-cf2a7160548a€35.00€0.50matched
106refund01a1a49a-7228-7871-8649-afdcded97bf6-€40.00€0.00matched
107capture01a1a49a-7314-74dc-a1b6-ee23b64e3db8€35.00€0.50matched
108capture01a1a49a-7f28-795f-b66c-e6a793306cda€24.00€0.37matched
109refund01a1a49a-8929-7253-9b10-511ddad4e2bc-€26.00€0.00matched
110capture01a1a49a-9702-7fbc-a9d1-75a9874c3d85€24.00€0.37matched
111capture01a1a49a-e494-712e-812f-b94152649fce€24.00€0.37matched
112capture01a1a49a-f1e8-7ca7-a2fc-f794f6310c53€24.00€0.37matched
113capture01a1a49b-1ff7-7372-b627-a0952e6b2a61€15.00€0.26matched
114capture01a1a49b-29a8-7a85-ac1d-2380878ab5c7€15.00€0.26matched
115capture01a1a49b-2dc4-7a4a-833a-ef1e944eda97€35.00€0.50matched
116capture01a1a49b-33b9-76f6-a903-e866a3ebd892€49.00€0.67matched
117capture01a1a49b-35b6-791f-b243-efea19a5a457€35.00€0.50matched