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, 19:00

Gross

€3,225.00

PSP fee

€49.41

Net to the bank

€3,175.59

Settlement journal

#384301

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a7ef-ee9c-7334-b4ad-c58185dfb81c is already settled by stl_EUR_2989698 line 20
  • 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 29, the contract says 26
LineKindReferenceGrossFeeStatus
21capture01a1a7ef-eeb8-7414-b76b-cd4489f6c0b4€24.00€0.37duplicate line
31capture01a1a7f1-1d76-7379-9160-25f8368e2ceb€9.00€0.23fee difference
97capture01a1a7f6-58f4-709c-accb-c6aa010a5cf5€15.00€0.29fee difference
1capture01a1a7e6-c74e-7b30-93d2-822eae6562d1€49.00€0.67matched
2capture01a1a7ee-c14e-73df-b1ae-f770b3d9a8df€49.00€0.67matched
3capture01a1a7ee-c341-7222-ab29-65a0576cbf67€49.00€0.67matched
4capture01a1a7ee-c61b-7a81-a0c9-15214434fc57€24.00€0.37matched
5refund01a1a7ee-d111-7f67-a14f-111227024bd4-€10.00€0.00matched
6capture01a1a7ee-d1bf-7844-a042-87d8d547e9c8€15.00€0.26matched
7capture01a1a7ee-d789-71ef-9f58-1ddc1b7c2939€49.00€0.67matched
8capture01a1a7ef-0e7f-7383-a5d9-3bf056793545€49.00€0.67matched
9capture01a1a7ef-1efc-78a6-84eb-2ed1cff3b5b0€24.00€0.37matched
10capture01a1a7ef-2c4c-7150-b5e4-38a29fef5f80€24.00€0.37matched
11capture01a1a7ef-392c-7153-a894-7bf0b2438614€15.00€0.26matched
12capture01a1a7ef-3e31-7341-bdc3-4dac0d4c611b€49.00€0.67matched
13capture01a1a7ef-591a-779b-bb4d-1e72f30fa794€49.00€0.67matched
14refund01a1a7ef-7e51-7bf1-9515-ef47b24648d6-€44.00€0.00matched
15capture01a1a7ef-aa5c-70da-aa74-e8093823fcbc€15.00€0.26matched
16capture01a1a7ef-ad39-7184-906f-7f022f25bdd0€35.00€0.50matched
17capture01a1a7ef-cd92-7165-b96d-e7d4416ac176€35.00€0.50matched
18capture01a1a7ef-d5e5-795b-8dfd-ac36d477b542€49.00€0.67matched
19capture01a1a7ef-e457-7a7d-832c-b5463107ce76€24.00€0.37matched
20capture01a1a7ef-eeb8-7414-b76b-cd4489f6c0b4€24.00€0.37matched
22capture01a1a7f0-0f8c-76af-9d0e-e7c88bddb686€49.00€0.67matched
23capture01a1a7f0-18f9-717d-b0d8-f7084b9b41d7€24.00€0.37matched
24capture01a1a7f0-3d4b-7490-81ae-d42faa75f742€49.00€0.67matched
25capture01a1a7f0-4baf-72f1-90dc-d12b67dd87da€9.00€0.19matched
26capture01a1a7f0-8395-7dbe-bda3-b230d5b22a09€24.00€0.37matched
27capture01a1a7f0-9393-790c-b4ed-85ea4bdc3170€24.00€0.37matched
28capture01a1a7f0-be44-70e4-b693-d15c3bbb7e7e€9.00€0.19matched
29capture01a1a7f0-d53d-7eac-a504-ba85ad9afc51€24.00€0.37matched
30capture01a1a7f0-dd8b-783b-9ade-999873f95f00€9.00€0.19matched
32capture01a1a7f1-1ec1-7e76-aa60-3511ccd5fd8f€49.00€0.67matched
33capture01a1a7f1-32ed-7d0e-8f45-caa3713a6cb7€24.00€0.37matched
34capture01a1a7f1-41b3-71d1-935d-70d1586e1b68€24.00€0.37matched
35capture01a1a7f1-4540-7e8b-9108-4c161c3fe185€15.00€0.26matched
36capture01a1a7f1-54f0-77a4-8624-0d9883d0c964€49.00€0.67matched
37capture01a1a7f1-7320-7a84-96e2-6029e298cf55€15.00€0.26matched
38capture01a1a7f1-7d3b-78fe-b72f-3abdc77791a0€35.00€0.50matched
39capture01a1a7f1-832a-727b-aa32-84c0fb934965€9.00€0.19matched
40refund01a1a7f1-8599-7689-8526-679309a6939d-€3.00€0.00matched
41capture01a1a7f1-8619-7258-97aa-970399e6ce83€35.00€0.50matched
42capture01a1a7f1-89c1-7ead-9bbc-742c190aafdd€15.00€0.26matched
43capture01a1a7f1-8ded-7df5-909e-3f246c98f411€35.00€0.50matched
44capture01a1a7f1-950d-7a5e-94d6-2bb845b61ddc€24.00€0.37matched
45capture01a1a7f1-abc7-72b0-a5c7-205b2310933e€49.00€0.67matched
46capture01a1a7f1-b32c-766d-95a7-15b73cb2ad32€24.00€0.37matched
47capture01a1a7f1-cc9d-7a60-8425-91bf51d2923d€49.00€0.67matched
48capture01a1a7f1-d0bf-7e93-9db9-c8b5ba4bf2b4€49.00€0.67matched
49capture01a1a7f1-f99f-7574-b95e-7d415c46ab9b€24.00€0.37matched
50capture01a1a7f2-020e-7553-83b8-e40265de4064€49.00€0.67matched
51capture01a1a7f2-2c41-78d0-b518-1edcc7862464€49.00€0.67matched
52capture01a1a7f2-438f-723a-8d9d-e2178e50a665€9.00€0.19matched
53capture01a1a7f2-5163-769b-9a26-187aa6463b67€24.00€0.37matched
54capture01a1a7f2-5e56-7a7e-b9bd-dc15f7175cf8€24.00€0.37matched
55capture01a1a7f2-5fc6-7abe-a1b0-56f66a29335d€49.00€0.67matched
56capture01a1a7f2-732f-7ed9-a122-76602f54c2b7€15.00€0.26matched
57capture01a1a7f2-9865-7775-90ee-975511c8f2c6€49.00€0.67matched
58capture01a1a7f2-ad2f-7f38-b910-2e00c1d0e368€35.00€0.50matched
59capture01a1a7f2-b858-73a7-90d0-f9448cf40432€24.00€0.37matched
60capture01a1a7f2-bcac-716d-a303-e045870b59ce€35.00€0.50matched
61capture01a1a7f2-f6ed-72b5-ade2-1c3cc65ff989€9.00€0.19matched
62capture01a1a7f3-0990-7ccc-b642-0eb662beb360€9.00€0.19matched
63capture01a1a7f3-1023-7323-94a4-4c66cf325106€9.00€0.19matched
64refund01a1a7f3-25bd-7ee1-a4cc-6938862f25d7-€16.00€0.00matched
65capture01a1a7f3-3a3e-77ed-ad06-71b0db79d3b2€9.00€0.19matched
66capture01a1a7f3-451b-7906-a282-b0f38a0c7826€15.00€0.26matched
67capture01a1a7f3-4e19-7b2f-b0bb-949f6f7dd25a€35.00€0.50matched
68capture01a1a7f3-5c6a-71db-ae27-a966e095b553€9.00€0.19matched
69capture01a1a7f3-5d03-7553-af2f-0e029655c1f5€35.00€0.50matched
70capture01a1a7f3-815e-7e17-8a11-b3d22b4b66ad€9.00€0.19matched
71capture01a1a7f3-829e-7674-9192-cd0933bb6986€24.00€0.37matched
72capture01a1a7f3-8ecd-7f03-93dd-0cab1221b21c€15.00€0.26matched
73capture01a1a7f3-974e-7014-843c-24dc5fe17eb7€15.00€0.26matched
74capture01a1a7f4-151f-704a-a86f-c2e93debab83€15.00€0.26matched
75capture01a1a7f4-1fdb-7d67-9c70-d9e3d85f2a30€15.00€0.26matched
76capture01a1a7f4-2ca5-77f0-bedb-e77091ac324a€9.00€0.19matched
77capture01a1a7f4-3785-7356-9996-8a930a4f8bd7€35.00€0.50matched
78capture01a1a7f4-5dab-76cd-8e9e-2f5570de9b67€24.00€0.37matched
79capture01a1a7f4-7fee-740c-b79c-a03461d04223€49.00€0.67matched
80capture01a1a7f4-8109-7e23-bef5-a427e9b7e7b2€24.00€0.37matched
81capture01a1a7f4-9bd7-76b5-aeb1-0737f7ef5d21€35.00€0.50matched
82capture01a1a7f4-aad1-7eb4-a973-e5184132169b€35.00€0.50matched
83capture01a1a7f4-c56c-7e2f-92c8-102167db5282€35.00€0.50matched
84capture01a1a7f4-d566-7f10-ab2d-e1b37ddb2a05€49.00€0.67matched
85capture01a1a7f4-dcf0-76a2-8bfd-0c2859440883€49.00€0.67matched
86capture01a1a7f4-e41e-7639-815f-f805f917e40c€24.00€0.37matched
87capture01a1a7f5-20a6-780f-9d1d-51306010ca2f€49.00€0.67matched
88capture01a1a7f5-6e72-7f2b-b36a-ba7b983158e5€24.00€0.37matched
89capture01a1a7f5-c8bf-7e85-923d-5d16b24772b2€35.00€0.50matched
90capture01a1a7f5-f357-7a69-bb73-261c36334077€15.00€0.26matched
91capture01a1a7f5-f494-79d5-a5c8-9a7164f863af€24.00€0.37matched
92capture01a1a7f6-010a-7239-bdc7-1b041f38f9b2€24.00€0.37matched
93capture01a1a7f6-14bd-7c62-a578-f068323c3d46€35.00€0.50matched
94capture01a1a7f6-3f46-7ef8-b64d-b1024156461d€15.00€0.26matched
95capture01a1a7f6-4e32-74ba-9c27-b70632877dba€15.00€0.26matched
96capture01a1a7f6-55ae-7c08-95b9-1a32c6a1325f€35.00€0.50matched
98capture01a1a7f6-5ba1-7db5-871d-125d3a83709f€15.00€0.26matched
99capture01a1a7f6-64a5-73f5-b520-e7631db84f10€15.00€0.26matched
100capture01a1a7f6-7448-7202-82ef-e36da4077598€24.00€0.37matched
101capture01a1a7f6-8f22-75de-b004-3cd968398d18€49.00€0.67matched
102capture01a1a7f6-982f-7cf0-ad85-86fb8f7980df€35.00€0.50matched
103capture01a1a7f6-a4ec-7609-987e-196e186fa9ec€24.00€0.37matched
104capture01a1a7f6-ab80-7e47-ad6a-474d968442d9€49.00€0.67matched
105capture01a1a7f6-bb52-7f64-8e1a-6ba0eb6526fc€24.00€0.37matched
106capture01a1a7f6-c193-73e4-91a3-54d4eb88ccd6€49.00€0.67matched
107refund01a1a7f6-e19c-7f5d-828e-be9122c0b133-€19.00€0.00matched
108capture01a1a7f6-ec0f-7caf-bea1-fb4146d034e5€24.00€0.37matched
109capture01a1a7f6-ee17-7e79-9cf4-b2cada769e31€9.00€0.19matched
110capture01a1a7f6-f77d-7453-adac-9f304bf5c150€35.00€0.50matched
111capture01a1a7f6-f039-71a3-ace6-5eba9478597f€24.00€0.37matched
112refund01a1a7f7-288e-73b5-90b7-9cc89dfe1207-€15.00€0.00matched
113capture01a1a7f7-74d7-79d5-9c90-d5c7dc17bed4€9.00€0.19matched
114capture01a1a7f7-7734-7cf6-8e2e-d32b29376e85€49.00€0.67matched
115capture01a1a7f7-7ed0-7db5-aeef-48aab3f082be€24.00€0.37matched
116capture01a1a7f7-9418-77e0-b2a7-eb742da85b64€49.00€0.67matched
117capture01a1a7f7-98ef-78cf-a4b4-28a41f2a8c9b€49.00€0.67matched
118capture01a1a7f7-a1dc-7efa-be45-58fca1df2b16€49.00€0.67matched
119capture01a1a7f7-a848-7948-8371-95d31401923a€24.00€0.37matched
120capture01a1a7f7-b635-785b-8481-1c2a2ae01c16€24.00€0.37matched
121capture01a1a7f7-c201-733b-9463-3c4aebfa3c71€35.00€0.50matched