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

5 Nov, 01:50

Gross

€3,077.00

PSP fee

€49.12

Net to the bank

€3,027.88

Settlement journal

#389558

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a96c-414d-7685-b47d-c3891c6655c4 is already settled by stl_EUR_2989739 line 95
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 69, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • missing linein the books, not in the filecapture:01a1a969-d695-7e03-850a-3a3adcf66203 is in no file
LineKindReferenceGrossFeeStatus
81capture01a1a96b-0a9d-774b-8932-d8beb0ab9fbf€9.00€0.23fee difference
88capture01a1a96b-a59b-788b-b21a-3702ab06ad42€49.00€0.69fee difference
91capture01a1a96b-dfde-778f-a71a-74b237d84e00€9.00€0.24fee difference
96capture01a1a96c-417a-714e-a444-49b88a7db75f€24.00€0.37duplicate line
127capture01a1a96e-a30e-77f4-a3d1-74281ab1ee38€9.00€0.24fee difference
1capture01a1a962-6d0e-7738-b1d2-a9b361b3669f€35.00€0.50matched
2capture01a1a963-f44f-71de-a826-e9bd4652487d€9.00€0.19matched
3capture01a1a966-39cb-7ef4-9844-2dcc79dc6a1f€15.00€0.26matched
4capture01a1a966-42ff-7ee6-b9b7-9dee5a00441c€9.00€0.19matched
5capture01a1a966-47f0-7f11-b35a-ffe11ac85ca1€15.00€0.26matched
6capture01a1a966-4c0c-77bd-bfc5-efd8ca622ac7€49.00€0.67matched
7capture01a1a966-52a0-7330-8485-0f8d6ecaa337€49.00€0.67matched
8capture01a1a966-5845-7425-b437-623dca30ef60€35.00€0.50matched
9capture01a1a966-5910-7e62-a9a1-81d0fda39f2f€49.00€0.67matched
10capture01a1a966-69ef-779b-a9c5-009f4e184d7a€15.00€0.26matched
11capture01a1a966-7051-7902-bcd1-fb63cf6787f4€24.00€0.37matched
12capture01a1a966-7077-7763-a3b7-fd172e562bab€15.00€0.26matched
13capture01a1a966-7415-7648-9bbf-520cc76888bf€9.00€0.19matched
14capture01a1a966-9486-74a4-a75b-ca01267d619f€15.00€0.26matched
15capture01a1a966-aaa4-7047-b9c7-b1ce4830676c€49.00€0.67matched
16capture01a1a966-c2fa-7157-b361-2736df1ae6a3€15.00€0.26matched
17capture01a1a966-d150-778e-b686-887e2798f7d4€24.00€0.37matched
18capture01a1a966-ef2a-7b14-a1ef-4d0457ec9477€49.00€0.67matched
19capture01a1a967-0b3f-743d-9e78-e9f91e6abe68€24.00€0.37matched
20capture01a1a967-0dc5-7288-a9ec-e63fd18d31a4€15.00€0.26matched
21capture01a1a967-17e5-7d98-8a61-5bacdc0fbf74€15.00€0.26matched
22capture01a1a967-1c26-7412-b36a-cd5f8ba665d6€9.00€0.19matched
23capture01a1a967-1f36-78df-ae60-4e94a4b2d2e2€35.00€0.50matched
24capture01a1a967-3912-7428-8e1d-5901b1f7052e€35.00€0.50matched
25capture01a1a967-513c-7f06-9089-79b6b208b1a9€49.00€0.67matched
26capture01a1a967-58f1-78b9-ba28-a60ad893fda4€15.00€0.26matched
27capture01a1a967-6035-732f-a765-ba4f5dceb360€49.00€0.67matched
28capture01a1a967-6631-7cad-b440-ad9b6c6d02fa€24.00€0.37matched
29refund01a1a967-774a-7a72-a515-2cf66e21ef91-€23.00€0.00matched
30capture01a1a967-7e3a-759d-ae82-e3a5574a4725€15.00€0.26matched
31capture01a1a967-9456-769f-9eed-5678ca43af10€15.00€0.26matched
32capture01a1a967-968c-74a2-88a2-ebdf26e6ac2e€15.00€0.26matched
33capture01a1a967-b3f9-786c-a8df-a8c838c3736b€24.00€0.37matched
34capture01a1a967-c526-78fd-adfc-c4b0302d6835€9.00€0.19matched
35capture01a1a967-ce86-7c38-9e4c-086990ad32d3€24.00€0.37matched
36refund01a1a967-fb25-75ff-bc8d-f8630be3029b-€10.00€0.00matched
37capture01a1a967-fbd9-7bf3-aa83-19aa029838c4€9.00€0.19matched
38capture01a1a968-0a2b-71f9-a7a0-bdbd234fd533€35.00€0.50matched
39capture01a1a968-223c-770a-b0cc-fe63e3c68cec€35.00€0.50matched
40capture01a1a968-25d6-78e4-8dfc-b74298922650€9.00€0.19matched
41capture01a1a968-2950-7c5c-853d-b8dee74465e2€35.00€0.50matched
42capture01a1a968-2bc9-74f8-889c-2c5a9be77b2c€49.00€0.67matched
43capture01a1a968-657f-7e45-aac6-b36a8870a315€49.00€0.67matched
44capture01a1a968-8303-73a6-8b89-2397cd002143€24.00€0.37matched
45refund01a1a968-8a6a-70ce-8728-ff02d3ef679e-€3.00€0.00matched
46capture01a1a968-8f3a-7404-a54a-f699fbad9e2a€9.00€0.19matched
47capture01a1a968-9758-7119-866c-30e9cc253814€49.00€0.67matched
48capture01a1a968-98af-7d0b-b81f-e5ba0f892ffc€15.00€0.26matched
49capture01a1a968-a988-756c-8f46-0779ba4606e9€24.00€0.37matched
50capture01a1a968-db39-7b39-aa93-2ff0985f3e0a€49.00€0.67matched
51refund01a1a968-eb49-71cb-a5d0-69767ac3a7ec-€14.00€0.00matched
52capture01a1a968-f950-7473-8a46-9afcb500d1a6€49.00€0.67matched
53capture01a1a969-03e0-71b5-b2d7-68e602d16354€49.00€0.67matched
54capture01a1a969-0cfd-7b45-9f9d-e1938d8a2eb5€24.00€0.37matched
55capture01a1a969-2d83-718d-9052-9d9376c19827€15.00€0.26matched
56capture01a1a969-30b7-7938-9120-4334fa2c518a€49.00€0.67matched
57capture01a1a969-3134-79fe-b099-3b23f385d215€15.00€0.26matched
58capture01a1a969-56b2-7c99-be8f-b4fe5d22f187€15.00€0.26matched
59capture01a1a969-6c78-7733-a3f3-14a104befb6c€35.00€0.50matched
60refund01a1a969-8eb0-70b8-9ba5-a18a59f48457-€9.00€0.00matched
61capture01a1a969-ad4d-78b7-8c60-52ee394eec43€49.00€0.67matched
62capture01a1a969-e700-71d4-b747-6b0b0a0e5887€9.00€0.19matched
63capture01a1a969-edd2-78d9-91c4-47ea16d35a53€15.00€0.26matched
64capture01a1a96a-04e9-74f7-b700-160b45948fbf€35.00€0.50matched
65capture01a1a96a-1e04-7a23-88d0-101703c977c8€15.00€0.26matched
66capture01a1a96a-4fc2-7e44-bc38-d7241c94a419€15.00€0.26matched
67capture01a1a96a-5a0d-743a-a13d-8be38a5a1ab1€9.00€0.19matched
68capture01a1a96a-5f18-746e-acf5-cc494d23a69d€9.00€0.19matched
69capture01a1a96a-7b70-7041-b7dd-f4c3824e5eae€49.00€0.67matched
70capture01a1a96a-87b1-7ca4-a3f2-dfa4e614d3d0€15.00€0.26matched
71capture01a1a96a-8960-79b4-8097-d97f2aaa548e€9.00€0.19matched
72capture01a1a96a-adfd-771a-bb34-869620e4780b€49.00€0.67matched
73capture01a1a96a-bcef-7668-8e44-da675b0ddd1c€49.00€0.67matched
74capture01a1a96a-ccee-7bd6-a90a-3029a24914d4€49.00€0.67matched
75capture01a1a96a-db0a-784c-baa5-4cb959b9cf42€9.00€0.19matched
76capture01a1a96a-e573-7b3f-8e0a-a6db6e745b41€24.00€0.37matched
77refund01a1a96a-f18a-72a5-b811-801e673650aa-€38.00€0.00matched
78capture01a1a96a-f996-7b57-b831-2445b55e670d€9.00€0.19matched
79capture01a1a96a-fcba-7bb8-85fa-4ef79df7e14f€15.00€0.26matched
80capture01a1a96b-01d6-7c2b-8836-15a5d702595b€35.00€0.50matched
82capture01a1a96b-317c-7960-9d5d-d9e9acfd4b8d€15.00€0.26matched
83refund01a1a96b-3b2b-74b9-b51e-a0b08a0b2918-€7.00€0.00matched
84capture01a1a96b-495d-721f-8a1d-a43bc3182c04€24.00€0.37matched
85capture01a1a96b-7734-7123-a513-9c8e1e925599€35.00€0.50matched
86capture01a1a96b-7a0c-7059-9d96-df3118232785€49.00€0.67matched
87capture01a1a96b-99ed-7569-80db-3514d557c9b2€49.00€0.67matched
89capture01a1a96b-b12a-7493-970e-67e04ad5794e€24.00€0.37matched
90refund01a1a96b-cbb7-79ba-bf54-4fec0d04d57e-€17.00€0.00matched
92capture01a1a96b-e324-73e5-8597-89ee3e35daae€15.00€0.26matched
93capture01a1a96b-e98f-79c4-aea6-724141e316c3€24.00€0.37matched
94capture01a1a96c-014a-7212-8b6c-8630737f4581€49.00€0.67matched
95capture01a1a96c-417a-714e-a444-49b88a7db75f€24.00€0.37matched
97capture01a1a96c-577d-770e-9fe6-225725834696€49.00€0.67matched
98capture01a1a96c-6d3a-75dd-a296-29eea09da8bb€15.00€0.26matched
99refund01a1a96c-7163-76ad-b0ae-d00c4759abdb-€20.00€0.00matched
100capture01a1a96c-8cde-7998-924d-57658896212f€49.00€0.67matched
101capture01a1a96c-963a-7c1a-8bb3-d42b463e16d1€49.00€0.67matched
102capture01a1a96c-afbf-7264-ab2c-05d50e595729€24.00€0.37matched
103capture01a1a96c-c28e-727c-a4df-02716e9a0797€49.00€0.67matched
104capture01a1a96c-b025-72a3-b75f-b978cfe3872b€15.00€0.26matched
105capture01a1a96c-f397-7549-bec3-f15d13a4d904€24.00€0.37matched
106capture01a1a96d-0ab8-7e47-b760-cbb82aab0502€35.00€0.50matched
107capture01a1a96d-0e8a-70ce-b341-cc8c59ec0a27€15.00€0.26matched
108capture01a1a96d-0fd2-719d-be19-8e92474951df€35.00€0.50matched
109capture01a1a96d-177a-7029-9610-c7d4922c8a9f€9.00€0.19matched
110capture01a1a96d-1ebd-7a54-b66d-3ff3619af869€15.00€0.26matched
111capture01a1a96d-25a5-7be3-bf95-63d4ef6e78f4€49.00€0.67matched
112capture01a1a96d-28ca-701a-afbf-39950b3c2be1€35.00€0.50matched
113capture01a1a96d-5621-7e2a-8287-1af709ead69a€49.00€0.67matched
114capture01a1a96d-764a-7807-a5fa-e1b13c0bd50f€35.00€0.50matched
115capture01a1a96d-b9ca-73f6-9b84-671509061057€9.00€0.19matched
116capture01a1a96d-bb63-736a-80e6-3a9b9b69f39e€15.00€0.26matched
117refund01a1a96d-c98d-76f3-95ae-96621bd6e952-€36.00€0.00matched
118capture01a1a96d-db84-7859-9bcd-1508f42a8b0a€24.00€0.37matched
119capture01a1a96d-e84d-7f1f-b700-9154c1cde0dc€9.00€0.19matched
120capture01a1a96d-faaf-72bb-8e99-7884e36dd6d5€9.00€0.19matched
121capture01a1a96e-0e4d-7128-ab86-7f2dd759c9ac€15.00€0.26matched
122capture01a1a96e-10b2-78e9-9b90-c69d168daa01€24.00€0.37matched
123capture01a1a96e-4825-7a84-b922-7e39bdae24b6€24.00€0.37matched
124capture01a1a96e-7655-7a90-bd65-2618952a21df€9.00€0.19matched
125capture01a1a96e-8e2a-75ca-89b4-b49327eb7f38€9.00€0.19matched
126capture01a1a96e-9605-727d-a529-2c68c711bbd5€15.00€0.26matched
128capture01a1a96e-d177-7dd8-991d-61ca6e5231bf€9.00€0.19matched
129capture01a1a96e-e2af-7602-8cad-2c0a552a05c1€15.00€0.26matched
130capture01a1a96f-19e9-7206-8e2d-fb8a016f4e12€49.00€0.67matched
131capture01a1a96f-0677-7747-9789-1cd62f669a08€49.00€0.67matched
132capture01a1a96f-3231-719e-85d3-5189fb4a3812€49.00€0.67matched