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, 09:30

Gross

€3,216.00

PSP fee

€52.26

Net to the bank

€3,163.74

Settlement journal

#340581

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19b9b-5af4-7a58-a2ac-462085307ca6 is already settled by stl_EUR_2989353 line 63
  • duplicate linethe file lists it twicecapture:01a19b9c-af53-7e04-9ab4-a1bbbfc13eb7 is already settled by stl_EUR_2989353 line 88
  • duplicate linethe file lists it twicecapture:01a19b9d-b438-744d-a488-0de6aea786d9 is already settled by stl_EUR_2989353 line 102
LineKindReferenceGrossFeeStatus
64capture01a19b9b-5b5e-7a2e-bf7b-f0b0b6983ff3€24.00€0.37duplicate line
89capture01a19b9c-af7a-786f-961e-d1739ace8236€9.00€0.19duplicate line
103capture01a19b9d-d1d9-702a-9b90-504a4787e840€49.00€0.67duplicate line
1capture01a19b93-5b57-795b-b46b-8541abc7bdf2€35.00€0.50matched
2capture01a19b95-ef41-7623-8a2f-8338bd3dd073€15.00€0.26matched
3capture01a19b98-232e-7fc3-b8ad-364c46e0980b€9.00€0.19matched
4capture01a19b98-23eb-7eae-a65f-501fd6d9788f€15.00€0.26matched
5capture01a19b98-2ef2-7455-b951-85e79e7fd270€35.00€0.50matched
6capture01a19b98-44db-7655-9445-c3a050d63a53€9.00€0.19matched
7capture01a19b98-6bcc-7c98-a337-ddd15d24a168€24.00€0.37matched
8capture01a19b98-7b47-7d0b-ba6d-9849d8fa8c66€24.00€0.37matched
9capture01a19b98-7ccf-7f9a-829a-f750ac287ee4€9.00€0.19matched
10refund01a19b98-85df-7c52-b308-d03ab5ecc4b8-€5.00€0.00matched
11capture01a19b98-87fa-7de5-8db3-d67045cb2270€49.00€0.67matched
12capture01a19b98-9422-749b-a7d8-b3358e34c6a6€15.00€0.26matched
13capture01a19b98-9f04-77d1-806c-138ecad67918€24.00€0.37matched
14capture01a19b98-aa22-7cf3-91a9-b2ee60efbfa3€35.00€0.50matched
15capture01a19b98-bb4f-74b0-8ae1-2a5d0b59a1e6€35.00€0.50matched
16capture01a19b98-ddb7-79fc-977e-7456b364b928€35.00€0.50matched
17capture01a19b99-0214-72a5-aae0-87f446bf4e73€35.00€0.50matched
18capture01a19b99-08dd-75d6-9e3f-2f2e61aab492€9.00€0.19matched
19capture01a19b99-13aa-793f-bc91-d149afc04dc1€15.00€0.26matched
20capture01a19b99-15ef-7e91-8db1-99793554918a€9.00€0.19matched
21capture01a19b99-19e2-7ec4-92d6-5b09037ed6cd€35.00€0.50matched
22capture01a19b99-2d27-7258-abb5-5683bddb9fef€35.00€0.50matched
23capture01a19b99-3749-7146-911b-9da4f8656885€15.00€0.26matched
24capture01a19b99-3c26-799f-8aab-b559af3caa32€24.00€0.37matched
25capture01a19b99-5c25-7429-a4bf-c4e94c0c0b89€15.00€0.26matched
26capture01a19b99-5f3a-7a96-b70a-0a9f89b553e4€35.00€0.50matched
27capture01a19b99-702c-76a0-b190-06e5c09a14ca€15.00€0.26matched
28capture01a19b99-7203-7874-b63d-9985a7f13c31€24.00€0.37matched
29refund01a19b99-7ad2-7170-ba39-16be8841b7f5-€9.00€0.00matched
30capture01a19b99-8b2f-765c-8dae-810e838f269d€35.00€0.50matched
31capture01a19b99-91d4-71d7-8935-72f8ddbdebeb€15.00€0.26matched
32capture01a19b99-9f98-7fe3-a93c-9fafd353e68e€15.00€0.26matched
33capture01a19b99-a7c4-7f78-8323-d8705226ddca€9.00€0.19matched
34capture01a19b99-b2e7-7c88-93c4-14081142941d€24.00€0.37matched
35capture01a19b99-b46a-77b5-bbfb-244f2e1d7462€35.00€0.50matched
36refund01a19b99-be7c-7515-903d-159a462a7556-€12.00€0.00matched
37capture01a19b99-c5ca-7ddb-9300-26036f9379df€49.00€0.67matched
38capture01a19b99-c9e0-7c5e-ab4b-1598f5a9bc34€24.00€0.37matched
39capture01a19b99-cde2-7a1a-8df6-8cb1c6b84784€24.00€0.37matched
40refund01a19b99-dad0-73f7-87a2-5f16ac377428-€22.00€0.00matched
41refund01a19b99-f6e7-7ce1-99cd-87e352cb1764-€6.00€0.00matched
42capture01a19b99-f7cc-727f-b9c9-3ee3b32fff44€49.00€0.67matched
43capture01a19b99-fbdb-73d3-9986-fc5078ccc222€49.00€0.67matched
44capture01a19b9a-0349-7c1d-9404-9b9c9365deab€9.00€0.19matched
45capture01a19b9a-0bb5-754b-b236-e7880a1fa3a3€24.00€0.37matched
46refund01a19b9a-0f98-7574-b4bb-e7b17f8fe7c8-€14.00€0.00matched
47refund01a19b9a-48d9-7fed-a9cd-f8db7a0329ba-€10.00€0.00matched
48capture01a19b9a-591b-77f8-9809-25657a40de95€9.00€0.19matched
49capture01a19b9a-6fb5-79a0-8233-33e559f43e3b€24.00€0.37matched
50capture01a19b9a-7325-7669-b5e2-26f46bfe7a34€15.00€0.26matched
51refund01a19b9a-84c9-719e-8a69-851515b61855-€7.00€0.00matched
52capture01a19b9a-b4df-7885-84f8-e7d3b9be4791€15.00€0.26matched
53capture01a19b9a-c5f5-7101-a70d-e0140211036d€35.00€0.50matched
54capture01a19b9a-c893-761f-9f78-fa9946e5a932€35.00€0.50matched
55capture01a19b9a-c89a-77b6-9d43-3a7a19f9a87f€24.00€0.37matched
56capture01a19b9b-0788-7c4c-a920-512a2531dff1€15.00€0.26matched
57capture01a19b9b-0e20-7c9c-8781-0ae2a61ad3ab€15.00€0.26matched
58capture01a19b9b-2ff6-7da1-9db5-c5ab76c1f37a€49.00€0.67matched
59capture01a19b9b-327a-74a6-a0a3-956494404417€24.00€0.37matched
60capture01a19b9b-4ad1-7004-aa50-3c2a3f89eb34€9.00€0.19matched
61capture01a19b9b-49d5-7a10-bcf5-74ecbb29a2b2€24.00€0.37matched
62capture01a19b9b-528a-7e0a-af32-854c77721b11€15.00€0.26matched
63capture01a19b9b-5b5e-7a2e-bf7b-f0b0b6983ff3€24.00€0.37matched
65capture01a19b9b-5d1d-7944-b6d2-c572dc24cf0b€24.00€0.37matched
66capture01a19b9b-7e19-710c-9a37-a094dbb6c4bc€15.00€0.26matched
67refund01a19b9b-85e6-76af-bf67-396a2f11ba48-€8.00€0.00matched
68capture01a19b9b-89e3-78ab-8ba3-a651b827dec9€24.00€0.37matched
69capture01a19b9b-9bb4-7a8e-8787-12c570ec16f6€15.00€0.26matched
70capture01a19b9b-a0e1-7f50-a666-31b105a158a8€35.00€0.50matched
71capture01a19b9b-b069-76ca-a50a-147547dec443€9.00€0.19matched
72capture01a19b9b-bff3-78fc-b036-f3397c2f7b90€49.00€0.67matched
73capture01a19b9b-c222-7d66-a2ee-d3104bf1fe9f€35.00€0.50matched
74capture01a19b9b-c2da-76c8-9419-20b8643ff971€15.00€0.26matched
75capture01a19b9b-cafe-70dc-91b1-86830ba61b5d€24.00€0.37matched
76capture01a19b9b-d46c-7d9b-a3d1-d0ef49220461€15.00€0.26matched
77refund01a19b9b-d703-7643-ba7f-0519cb569ae1-€9.00€0.00matched
78capture01a19b9c-0567-7fa6-b961-e9e2c5da589d€24.00€0.37matched
79capture01a19b9c-200b-7b74-9fe9-02ca65c1c63d€35.00€0.50matched
80capture01a19b9c-3461-745e-8128-c508ecd47c07€15.00€0.26matched
81capture01a19b9c-3a69-7e83-9b17-88f7f14cdcc8€9.00€0.19matched
82capture01a19b9c-4a73-782e-9eb2-92fc40b12555€9.00€0.19matched
83capture01a19b9c-4c9a-74c0-af16-fec440f6b38b€15.00€0.26matched
84capture01a19b9c-5d92-79bf-b8d5-5fd2482ab5c4€24.00€0.37matched
85capture01a19b9c-902b-7e5e-a269-aa685eca9bf3€24.00€0.37matched
86capture01a19b9c-98aa-7084-91c3-fff05ecf577f€24.00€0.37matched
87capture01a19b9c-a84a-7818-b7f0-b68bea47cda8€24.00€0.37matched
88capture01a19b9c-af7a-786f-961e-d1739ace8236€9.00€0.19matched
90capture01a19b9c-b088-7f9a-88c9-92ddbc11c161€9.00€0.19matched
91capture01a19b9c-bd86-7753-b8d8-0c3a36f65306€15.00€0.26matched
92capture01a19b9c-ef6c-7814-af48-c9083397dafc€49.00€0.67matched
93capture01a19b9d-10da-7f4b-bbe1-d8cce8d359e4€15.00€0.26matched
94capture01a19b9d-13da-7415-a84c-24c9b8dbef0a€9.00€0.19matched
95capture01a19b9d-15c5-7645-b28a-811f7ee7b956€35.00€0.50matched
96capture01a19b9d-4e6e-7881-a3f2-17b79497fe34€15.00€0.26matched
97capture01a19b9d-6615-7d10-a3d6-d94fd88a1e1c€49.00€0.67matched
98capture01a19b9d-7402-7b68-96e9-4c33e25cf197€49.00€0.67matched
99capture01a19b9d-88bf-7d98-8793-87ab41772459€9.00€0.19matched
100capture01a19b9d-9a1c-728d-84c5-928aab660e53€35.00€0.50matched
101capture01a19b9d-a0c0-73ad-8f63-285f8ad4f1e8€35.00€0.50matched
102capture01a19b9d-d1d9-702a-9b90-504a4787e840€49.00€0.67matched
104capture01a19b9d-db96-743a-8292-c53f62d7594c€35.00€0.50matched
105capture01a19b9d-f1a4-7421-99b4-8c4224cb5234€24.00€0.37matched
106capture01a19b9e-1c80-79c6-a581-e5e6b7e38fe5€24.00€0.37matched
107capture01a19b9e-1ec0-7280-b885-d3f27019c09f€49.00€0.67matched
108refund01a19b9e-2ae4-73d8-8041-d95c581d19de-€46.00€0.00matched
109capture01a19b9e-2219-7f26-a738-3b91533f7ec4€9.00€0.19matched
110capture01a19b9e-3b97-7ecc-a81c-05a3b1eaf8bd€24.00€0.37matched
111capture01a19b9e-83ec-7877-89da-c04e623c1561€24.00€0.37matched
112capture01a19b9e-9a77-77fb-93e0-84289cc1b46f€49.00€0.67matched
113capture01a19b9e-9b9f-780d-865c-75f3459490ce€9.00€0.19matched
114capture01a19b9e-b30f-7b8a-9655-042f08de6bcc€24.00€0.37matched
115capture01a19b9e-cde1-7633-8891-aad71cc0609c€24.00€0.37matched
116capture01a19b9e-e0b5-7929-92ff-5bc22e8f29d4€9.00€0.19matched
117capture01a19b9e-e62d-73e2-8137-099dfe2a00c3€24.00€0.37matched
118capture01a19b9e-ec31-751a-99a0-79cd53fcac61€35.00€0.50matched
119capture01a19b9e-f247-7645-8b7e-2b25cff24587€24.00€0.37matched
120capture01a19b9f-06d8-7bd4-8907-6607124ebb7b€15.00€0.26matched
121capture01a19b9f-2460-72aa-b5b3-313f6e732dae€35.00€0.50matched
122capture01a19b9f-2474-791c-88bc-19e2dc9b2531€24.00€0.37matched
123capture01a19b9f-26c9-73ca-831c-ce9d63788b66€15.00€0.26matched
124capture01a19b9f-376e-7a96-8e5f-e380df679de7€9.00€0.19matched
125capture01a19b9f-38e3-73bd-a8fa-a4762095c69c€9.00€0.19matched
126capture01a19b9f-550a-77fe-aca5-4bf954fdd9a4€49.00€0.67matched
127refund01a19b9f-6566-7158-8bf9-daf170281bd0-€22.00€0.00matched
128capture01a19b9f-6aa5-7092-81c3-9179b0c63df1€35.00€0.50matched
129capture01a19b9f-7584-7875-8bcb-b757c3252d58€35.00€0.50matched
130capture01a19b9f-7aac-76ec-96de-cc7e3eda6756€35.00€0.50matched
131capture01a19b9f-a590-792f-aaa8-a89b0ef06116€9.00€0.19matched
132capture01a19b9f-aa8a-78eb-8294-8b33f1012ff6€9.00€0.19matched
133capture01a19b9f-be99-7b41-8d5f-b3b0707018ed€15.00€0.26matched
134capture01a19b9f-d0c5-75bf-b56f-ca187c54a374€15.00€0.26matched
135capture01a19b9f-d3c1-72db-9978-4f6804a7fdac€35.00€0.50matched
136capture01a19ba0-012a-748a-81e6-2758d8e0621e€35.00€0.50matched
137capture01a19ba0-0c8f-7a29-98c0-c475664c339e€35.00€0.50matched
138capture01a19ba0-3dde-7a8e-92e5-cf361353048b€24.00€0.37matched
139capture01a19ba0-52e1-78cc-b17b-46aae2b46ddb€49.00€0.67matched
140capture01a19ba0-5ed7-78e8-8cb0-b27bebe760e9€9.00€0.19matched
141capture01a19ba0-6cf4-71d7-aa98-354a9171cf0b€15.00€0.26matched
142capture01a19ba0-704c-7752-b36f-abe31da93e38€49.00€0.67matched
143capture01a19ba0-7635-7787-a300-e6c8067be0b7€15.00€0.26matched
144capture01a19ba0-7755-7878-920f-e3ec2e4fd17a€9.00€0.19matched
145capture01a19ba0-7ade-7982-bd7b-94ee958fc2ec€15.00€0.26matched
146capture01a19ba0-7fe6-7624-80e0-ec40946e570d€9.00€0.19matched
147capture01a19ba0-864f-74d7-94a4-ca0a24c5a86e€35.00€0.50matched
148capture01a19ba0-96ef-7f42-9786-a853eca4f7be€15.00€0.26matched
149capture01a19ba0-bfb2-7e11-aada-44fe90e57f3d€15.00€0.26matched
150capture01a19ba0-caee-7eb2-905f-9cbb5caed13f€24.00€0.37matched
151capture01a19ba0-d91b-73bd-8d9e-0450176d3efd€9.00€0.19matched
152refund01a19ba0-e093-7f64-a714-ed142f03793e-€4.00€0.00matched
153capture01a19ba0-f711-793a-80a7-158831e7b080€24.00€0.37matched
154capture01a19ba0-f8ac-76d9-b55c-9bf5b767f3e6€15.00€0.26matched
155capture01a19ba1-2794-79c1-8f54-7cdd8dbc4cf0€9.00€0.19matched
156refund01a19ba1-3015-7872-a02a-9cf4ee6fbc37-€5.00€0.00matched