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

6 Nov, 11:50

Gross

€3,108.00

PSP fee

€48.51

Net to the bank

€3,059.49

Settlement journal

#415600

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a1b0b4-b025-798b-8673-d37e580bb764 is already settled by stl_EUR_2989943 line 41
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
LineKindReferenceGrossFeeStatus
42refund01a1b0b4-b027-72ff-bd17-ec851d41ddb8-€14.00€0.00duplicate line
49capture01a1b0b5-0fe3-7ebc-96c5-76226120661b€9.00€0.24fee difference
1capture01a1b0ae-8ad5-7433-86c3-d21cfad32a85€15.00€0.26matched
2capture01a1b0b0-a311-74f1-bac1-915547d42d49€49.00€0.67matched
3capture01a1b0b1-cd64-79b0-b465-c0871cad7eb1€35.00€0.50matched
4capture01a1b0b1-e05c-778e-b3f7-ca4b3334f6dc€35.00€0.50matched
5capture01a1b0b1-ee78-7a34-ae05-7c93aac24696€49.00€0.67matched
6refund01a1b0b2-0ffc-7e5b-bb18-9e0e46e88087-€12.00€0.00matched
7capture01a1b0b2-2401-7a76-ada2-006892393b65€35.00€0.50matched
8capture01a1b0b2-4344-70be-ad20-1fc4bc13ea06€9.00€0.19matched
9capture01a1b0b2-69eb-71b3-bda2-075e5ef8691a€9.00€0.19matched
10capture01a1b0b2-71b3-7b04-b412-d460bafdbf4e€35.00€0.50matched
11capture01a1b0b2-9251-732a-8e27-3fc32a5ce709€9.00€0.19matched
12capture01a1b0b2-9ce7-7f5e-a269-1f647e923dfb€35.00€0.50matched
13refund01a1b0b2-aa97-70ea-897d-b234e0717a6f-€3.00€0.00matched
14capture01a1b0b2-b836-76e6-8f90-3b7abc3d2b43€49.00€0.67matched
15capture01a1b0b2-d809-7a09-9deb-78dc1dcb39ce€49.00€0.67matched
16capture01a1b0b2-d8a6-76f9-ac3b-864b11d73745€35.00€0.50matched
17capture01a1b0b3-04d9-7d33-92d6-aa69fdaed7fb€15.00€0.26matched
18capture01a1b0b3-0b5d-7637-8b33-2e1e16ceda67€24.00€0.37matched
19capture01a1b0b3-1b86-714d-a97b-e103c6ce797e€9.00€0.19matched
20capture01a1b0b3-4f72-73e9-b3cf-581d80583ec5€15.00€0.26matched
21capture01a1b0b3-5cb0-7320-9734-f75c2ef5fabb€49.00€0.67matched
22capture01a1b0b3-76ec-75bc-944a-f1e292b078c7€35.00€0.50matched
23capture01a1b0b3-9cdc-74c4-9239-79126b99ff7b€24.00€0.37matched
24capture01a1b0b3-b9c5-7db7-90f2-735e7d1bea9f€35.00€0.50matched
25capture01a1b0b3-ce9a-7271-874d-3629e4ebb411€24.00€0.37matched
26capture01a1b0b3-d88b-7d6a-a42b-fb9379546d0c€24.00€0.37matched
27capture01a1b0b3-c2e6-7e2d-83f7-f8de417e90aa€49.00€0.67matched
28capture01a1b0b3-f4c8-7841-b0f0-da31d2c77744€35.00€0.50matched
29capture01a1b0b4-0969-7bb4-8c19-b462f2b69f57€49.00€0.67matched
30capture01a1b0b4-15fd-7ef0-91e9-f7b00e94a418€35.00€0.50matched
31capture01a1b0b4-1815-756b-87e6-236c8f34db18€49.00€0.67matched
32capture01a1b0b4-1857-73af-9c9d-eb9d8cae0c61€49.00€0.67matched
33capture01a1b0b4-19a8-700f-b58d-ab5fb004411a€9.00€0.19matched
34capture01a1b0b4-21b5-7f15-8bb6-f0f8ba90ab6a€49.00€0.67matched
35capture01a1b0b4-2c7f-7721-9073-0c25b9c82c6e€15.00€0.26matched
36capture01a1b0b4-3232-76e6-8c1a-02d9c828bffa€24.00€0.37matched
37capture01a1b0b4-6358-7015-9787-dd211d82f45b€49.00€0.67matched
38capture01a1b0b4-778d-7955-a2c1-1d2a9ccaa6a0€9.00€0.19matched
39capture01a1b0b4-866d-779f-aced-a08542d541ec€24.00€0.37matched
40capture01a1b0b4-9c64-7e9d-b942-7c2a28f22b91€9.00€0.19matched
41refund01a1b0b4-b027-72ff-bd17-ec851d41ddb8-€14.00€0.00matched
43capture01a1b0b4-c4e7-734e-921b-6ae1e652fe62€35.00€0.50matched
44capture01a1b0b4-d099-7ca4-a697-de111c62ab60€9.00€0.19matched
45capture01a1b0b4-d342-7333-804b-b17c536849fa€9.00€0.19matched
46capture01a1b0b4-d4e5-7928-9b18-ff2009383631€49.00€0.67matched
47capture01a1b0b4-d53b-7d07-adf0-a52ac4c4e7b3€9.00€0.19matched
48capture01a1b0b4-df2c-72d2-ba09-dc5c21d0f29c€15.00€0.26matched
50capture01a1b0b5-1ef2-7e60-98ba-a57a27042293€35.00€0.50matched
51capture01a1b0b5-293b-7d87-9054-aa6e5b28c424€49.00€0.67matched
52capture01a1b0b5-4585-75fb-8c11-54e3551662b6€15.00€0.26matched
53capture01a1b0b5-482c-7891-bc8a-9e88d524b05e€35.00€0.50matched
54capture01a1b0b5-563c-7844-ac02-3a029f576bcb€24.00€0.37matched
55capture01a1b0b5-76c6-7aa9-880d-03ed894c8f9f€24.00€0.37matched
56capture01a1b0b5-bdb5-768d-b318-a7e5cb52af63€35.00€0.50matched
57capture01a1b0b5-c950-7d9a-acaa-4afa3c8cdfd7€49.00€0.67matched
58capture01a1b0b5-ea46-7f83-be55-7fc2bd61d429€49.00€0.67matched
59capture01a1b0b6-0388-78dd-84e9-9faf24412b4b€35.00€0.50matched
60capture01a1b0b6-0e27-77e1-8046-eb1ef57c0d9c€9.00€0.19matched
61capture01a1b0b6-2248-768a-8d95-97b847b81641€35.00€0.50matched
62capture01a1b0b6-36d4-7993-8eca-0486a47faf12€49.00€0.67matched
63capture01a1b0b6-3731-76c4-aa28-6a515daa8daa€15.00€0.26matched
64capture01a1b0b6-5aaa-7117-9f54-62ecbefb4c9d€35.00€0.50matched
65capture01a1b0b6-6433-718a-8ae7-dfb172b6b10a€35.00€0.50matched
66capture01a1b0b6-78d7-7fab-b9eb-9408ac3310dd€35.00€0.50matched
67capture01a1b0b6-7a89-7ab3-99fa-2a2754372f55€35.00€0.50matched
68capture01a1b0b6-a998-72c7-b04d-6793c14375d8€35.00€0.50matched
69capture01a1b0b6-aa41-7763-8cbf-216da0c821f5€15.00€0.26matched
70capture01a1b0b6-c7b5-70e5-8ee2-84ab8f3856cd€24.00€0.37matched
71capture01a1b0b6-d4a2-7d1e-8d1f-350eedbc15d0€24.00€0.37matched
72capture01a1b0b6-e48f-7d4d-b02f-34f93ef493a9€24.00€0.37matched
73capture01a1b0b6-e993-75a7-9c98-8d641e03d19b€24.00€0.37matched
74capture01a1b0b6-ea90-770e-a4df-f5352a866d55€9.00€0.19matched
75capture01a1b0b6-f449-7a59-816c-61a6800bd3a2€24.00€0.37matched
76capture01a1b0b6-f628-745d-9142-f3321cd49fe1€9.00€0.19matched
77capture01a1b0b6-fa9d-7938-85e8-d740bfe2d1d6€24.00€0.37matched
78capture01a1b0b7-02da-7e4b-a53e-f562c00193a0€9.00€0.19matched
79refund01a1b0b7-147d-7355-bd15-abdc618788cf-€6.00€0.00matched
80refund01a1b0b7-1522-7420-a29e-d783337957ad-€6.00€0.00matched
81capture01a1b0b7-3873-7d87-8c3b-3ac5698d1d34€49.00€0.67matched
82capture01a1b0b7-41ca-72d2-9c24-12ebd8be2d44€49.00€0.67matched
83capture01a1b0b7-565f-7e7d-a721-e4dcd39a8c8e€49.00€0.67matched
84capture01a1b0b7-57ef-72af-9571-7a94cbcd543b€15.00€0.26matched
85capture01a1b0b7-5e9f-7e16-862b-d2993193cfeb€49.00€0.67matched
86capture01a1b0b7-64fd-7055-bd1f-c7f2a9c11f5e€9.00€0.19matched
87capture01a1b0b7-698b-7f78-8f74-e4c65ebd50ff€9.00€0.19matched
88capture01a1b0b7-7a03-73b4-9c8f-aee249ed4918€15.00€0.26matched
89refund01a1b0b7-babe-7b73-8699-83a435ffe1e0-€39.00€0.00matched
90capture01a1b0b7-cd4b-7c4a-b76f-1bfbcca78d44€35.00€0.50matched
91capture01a1b0b7-e491-7cfe-b810-d238a9df2a52€49.00€0.67matched
92refund01a1b0b7-f942-72aa-be7e-d646aa39d914-€25.00€0.00matched
93capture01a1b0b8-81e1-7819-9521-82b09ae8ac55€15.00€0.26matched
94capture01a1b0b8-b361-7993-97da-6ff5ecd6c8a0€15.00€0.26matched
95capture01a1b0b9-0c15-74d8-885b-a7fcf15ab686€9.00€0.19matched
96capture01a1b0b9-0e65-7a0e-bb6d-882545bdd824€35.00€0.50matched
97capture01a1b0b9-1575-7c02-92e7-f6ce3a279cf5€24.00€0.37matched
98capture01a1b0b9-2d77-72d9-99c3-d3c656a653c4€9.00€0.19matched
99capture01a1b0b9-36ed-7900-b71b-2e7705307ed9€49.00€0.67matched
100capture01a1b0b9-36f2-7f3d-a5e5-eb67f30f0e31€9.00€0.19matched
101capture01a1b0b9-4c38-7ec2-a0de-d30735fec49a€35.00€0.50matched
102capture01a1b0b9-4c98-7ced-9e4d-662ff83dc16b€24.00€0.37matched
103capture01a1b0b9-5d32-7676-bd95-b0f6a347c453€9.00€0.19matched
104capture01a1b0b9-6c3e-7935-a03a-b2e8d36fbee1€35.00€0.50matched
105capture01a1b0b9-7862-7520-ac9a-ee0ceaad5264€49.00€0.67matched
106capture01a1b0b9-904f-73db-b011-98860d3c515a€35.00€0.50matched
107capture01a1b0b9-93f7-748d-a626-263c9f6a35d8€15.00€0.26matched
108capture01a1b0b9-a986-7944-862c-a591f5fdec38€35.00€0.50matched
109capture01a1b0b9-c2b0-7f34-a478-f7257af4019f€9.00€0.19matched
110capture01a1b0b9-ceba-76e5-8671-c58421b05dbc€24.00€0.37matched
111capture01a1b0b9-cfd8-7d43-97aa-c9b3724369a1€15.00€0.26matched
112capture01a1b0b9-dd45-7233-b080-fbd7466ec0ae€9.00€0.19matched
113capture01a1b0b9-e55e-760a-b155-76a798bc9e08€35.00€0.50matched
114capture01a1b0b9-ed1b-7fa1-85a0-7f0a1a15e387€15.00€0.26matched
115capture01a1b0ba-1c1a-7ff4-8487-ed95b3b00aac€15.00€0.26matched
116capture01a1b0ba-2c68-74e5-a8f9-915f0a2a5c38€9.00€0.19matched
117capture01a1b0ba-36bf-7480-9f09-cee60a07ab35€49.00€0.67matched
118capture01a1b0ba-38f5-74b7-aca6-4e1efc92d7fe€9.00€0.19matched
119capture01a1b0ba-7b7e-745d-9901-835426309891€24.00€0.37matched
120capture01a1b0ba-863a-73d6-8a9a-54a3ad4ba672€15.00€0.26matched
121capture01a1b0ba-90a0-79d7-9c0c-a69ef62ec9de€24.00€0.37matched
122capture01a1b0ba-98b7-7a89-bfe4-bfb596ec6c1a€9.00€0.19matched
123capture01a1b0ba-9a76-7682-ae84-9a78ad726a17€35.00€0.50matched
124capture01a1b0ba-b233-76b9-bacb-63717698d9b6€15.00€0.26matched
125refund01a1b0ba-b977-7ffe-bc5a-287e4c69954a-€6.00€0.00matched
126capture01a1b0ba-d21c-7614-b12d-9254b3b91ed1€49.00€0.67matched
127capture01a1b0ba-d754-7eaa-80e7-bf321a578f9a€24.00€0.37matched
128capture01a1b0ba-dfa5-7eca-a89a-feaf7aa8992d€9.00€0.19matched