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

7 Nov, 14:00

Gross

€2,611.00

PSP fee

€42.35

Net to the bank

€2,568.65

Settlement journal

#435651

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b655-f03e-7861-9372-2766b35d27c6 is already settled by stl_EUR_2990100 line 86
  • duplicate linethe file lists it twicecapture:01a1b657-dda1-73c6-ac29-b3494209438e is already settled by stl_EUR_2990100 line 117
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
LineKindReferenceGrossFeeStatus
76capture01a1b654-af5d-7029-b429-f0ab07e88d70€49.00€0.70fee difference
87capture01a1b655-f068-7338-aa7a-2ce1116ca2b9€9.00€0.19duplicate line
118capture01a1b657-ee6f-7582-baa3-e9d6b643a849€35.00€0.50duplicate line
1capture01a1b64a-6b1f-75d9-9575-c4dd834f98d4€24.00€0.37matched
2capture01a1b64f-1c8c-70ef-b56e-81fcee96feb7€15.00€0.26matched
3capture01a1b64f-28fa-79d6-bbac-a1c13ba018fc€24.00€0.37matched
4capture01a1b64f-32e0-7a9e-b60f-ca3537155594€49.00€0.67matched
5capture01a1b64f-6ec8-770b-92dd-ff937450cdd0€49.00€0.67matched
6capture01a1b64f-779b-733d-ba07-d76dedeb6627€9.00€0.19matched
7capture01a1b64f-a0dd-7d70-b0f1-d19ab1c78664€24.00€0.37matched
8capture01a1b64f-f7a3-7cba-84cb-3b6b903f216a€35.00€0.50matched
9capture01a1b64f-f917-7eaf-a1cc-8a360b837673€24.00€0.37matched
10capture01a1b64f-fa45-71ee-8abf-97029f450ed8€9.00€0.19matched
11capture01a1b64f-fe03-74bc-aa2c-c9e86c752f4d€9.00€0.19matched
12capture01a1b650-26f8-7ee9-b871-e71c54f4bd98€24.00€0.37matched
13capture01a1b650-410c-7538-9f38-cbc99bc3ba63€35.00€0.50matched
14capture01a1b650-706e-794c-a167-e4dc0fcc573d€15.00€0.26matched
15refund01a1b650-db0c-78f0-a712-170f608e9cbb-€13.00€0.00matched
16capture01a1b650-ebe0-7a74-b5ce-dc1efee5c037€35.00€0.50matched
17capture01a1b650-f7c6-75a7-b65b-bfc726bf30ee€24.00€0.37matched
18capture01a1b650-fb4f-7294-8a1a-d29397737ded€49.00€0.67matched
19capture01a1b650-fdf5-73f6-93d1-017519d95738€49.00€0.67matched
20capture01a1b651-0966-79bc-b2e7-b78bf19df11b€35.00€0.50matched
21capture01a1b651-1c63-790e-8485-1805c6dfc7df€35.00€0.50matched
22capture01a1b651-1c7c-7e21-82c6-2046cd818479€15.00€0.26matched
23capture01a1b651-1e1c-7081-87e8-5c61f80ef638€15.00€0.26matched
24capture01a1b651-274f-73d6-b4f7-4b64bb7b73d4€49.00€0.67matched
25capture01a1b651-30a2-78db-afef-dc20558cfdf8€15.00€0.26matched
26capture01a1b651-3bef-7762-a4ec-f1d6b4be65e5€35.00€0.50matched
27capture01a1b651-40ab-7b49-818f-66256486725a€35.00€0.50matched
28capture01a1b651-4550-708a-9eca-0741d66c80f7€15.00€0.26matched
29capture01a1b651-47a8-7f0a-81c5-c1da8e4ba0b0€9.00€0.19matched
30capture01a1b651-71e9-7e00-a539-2d6e5f4d7e7e€24.00€0.37matched
31refund01a1b651-76e1-70ea-9be3-1138865efb9f-€5.00€0.00matched
32capture01a1b651-8313-70b3-aa3a-2b596a587259€24.00€0.37matched
33capture01a1b651-8b68-7716-a725-62e9ee3ce158€15.00€0.26matched
34capture01a1b651-8ef6-7a31-af73-736cdafbdf6d€9.00€0.19matched
35capture01a1b651-a1c6-7ff7-aae3-b27219f0317c€15.00€0.26matched
36capture01a1b651-bb43-7074-be7d-908a23c62b61€24.00€0.37matched
37refund01a1b651-c2a6-7178-b3d0-2529e052e776-€5.00€0.00matched
38capture01a1b651-d513-7a47-a58e-0a3cd2c07a34€9.00€0.19matched
39capture01a1b651-d898-7604-a9cb-fbd2b2463325€49.00€0.67matched
40capture01a1b651-eed2-7812-9abc-71567b848428€9.00€0.19matched
41capture01a1b652-3ee1-7057-b8dd-6120f81ba0d9€15.00€0.26matched
42capture01a1b652-5f10-72c3-8c3b-9062f2795701€15.00€0.26matched
43capture01a1b652-d146-74dc-ab19-9f6c65d97247€35.00€0.50matched
44capture01a1b652-d69a-7082-a51d-fe57f108bd0b€24.00€0.37matched
45capture01a1b652-db77-7fa2-8d09-e48c5eac3cac€24.00€0.37matched
46capture01a1b652-e46b-7c56-ab5a-e469e640e23e€15.00€0.26matched
47capture01a1b652-f8d7-7f91-8938-f60ff95e5923€35.00€0.50matched
48refund01a1b652-f9c4-7989-8e86-eda4ed1f5226-€23.00€0.00matched
49capture01a1b653-2f1f-74ad-a8cb-1108d9e7da4b€9.00€0.19matched
50capture01a1b653-3f15-7b8a-968a-a9a12245ff54€24.00€0.37matched
51capture01a1b653-45d1-7922-af28-ae893c2a01ac€49.00€0.67matched
52capture01a1b653-5ae8-7895-ada3-9034078c57f8€15.00€0.26matched
53capture01a1b653-71e1-7f55-b0ad-4e3016308174€9.00€0.19matched
54capture01a1b653-83cc-7ff6-9dae-56f64fc71d0f€9.00€0.19matched
55capture01a1b653-9c8b-7a6d-b4b6-6a8e0417ee92€35.00€0.50matched
56capture01a1b653-bf2b-790a-989e-0488e2bba008€49.00€0.67matched
57capture01a1b653-df96-7d52-8d49-c21d03165169€49.00€0.67matched
58capture01a1b653-e3a7-75ac-a36d-c1c9aaf2c34e€24.00€0.37matched
59capture01a1b653-ec5d-7fd9-b3c4-3f2abe4a8744€9.00€0.19matched
60capture01a1b653-fd59-72e5-82e3-cc0017f6dd0c€35.00€0.50matched
61capture01a1b654-059f-7bf3-a328-78ea4b858e4e€49.00€0.67matched
62capture01a1b654-07b0-7c6a-bad2-0f81e3d8a458€24.00€0.37matched
63capture01a1b654-1cc6-7239-9f62-5e540909ae72€49.00€0.67matched
64capture01a1b654-2844-7bf6-a271-5221fb22f71d€24.00€0.37matched
65capture01a1b654-3229-721d-9f6d-c14f62ad78ad€15.00€0.26matched
66capture01a1b654-42f2-7c48-96f5-bcb2882d7af9€9.00€0.19matched
67capture01a1b654-5548-7c12-ba9c-c9cad0ca02c7€15.00€0.26matched
68refund01a1b654-5811-79bb-b71a-fa141294bcb5-€38.00€0.00matched
69capture01a1b654-6714-79dd-9a30-054ebed70bb6€9.00€0.19matched
70capture01a1b654-787b-78e2-af4c-340081acab98€9.00€0.19matched
71capture01a1b654-7b62-7eb8-a977-611a502fba78€24.00€0.37matched
72capture01a1b654-80d3-77c3-a299-ca06ee2425a1€35.00€0.50matched
73capture01a1b654-95d2-7e22-a979-b8532d99ad55€9.00€0.19matched
74capture01a1b654-a189-761e-82be-86ee45841b9d€9.00€0.19matched
75capture01a1b654-a513-77f0-a945-f6a6660287ea€49.00€0.67matched
77capture01a1b655-1e3b-7dba-b503-ee114e281182€35.00€0.50matched
78capture01a1b655-64d0-7566-8f88-9457642214ce€15.00€0.26matched
79capture01a1b655-715a-771f-bc91-dbe366ca16e4€49.00€0.67matched
80capture01a1b655-7585-79a6-a70e-80f59476b00a€9.00€0.19matched
81capture01a1b655-7d5b-7c64-8bfa-fb767e5abe17€24.00€0.37matched
82capture01a1b655-8ac3-73e1-96a9-4689a287a60f€49.00€0.67matched
83refund01a1b655-9f79-748b-9129-4e086f9ace87-€29.00€0.00matched
84capture01a1b655-b1bd-7a87-b340-ebdf46be38c2€15.00€0.26matched
85refund01a1b655-df84-7230-bafa-8c0425cf5240-€10.00€0.00matched
86capture01a1b655-f068-7338-aa7a-2ce1116ca2b9€9.00€0.19matched
88capture01a1b655-ff6a-72c8-80ab-fe609d3e1c1c€35.00€0.50matched
89capture01a1b656-0464-778e-bf18-bb212a073962€49.00€0.67matched
90refund01a1b656-3bda-78ba-8a71-72a31f0d4a9d-€25.00€0.00matched
91refund01a1b656-5ac2-7984-b4c8-35975ca40c80-€20.00€0.00matched
92capture01a1b656-5b42-7a24-aa21-74ec1e678f7f€35.00€0.50matched
93capture01a1b656-775c-714f-8406-a40f26995cd8€49.00€0.67matched
94capture01a1b656-7c39-759e-b89f-916e39a1af77€35.00€0.50matched
95capture01a1b656-ea8c-7e5b-80cf-69ac2cc14a0f€15.00€0.26matched
96capture01a1b656-f06f-735a-9454-3fecbc76b051€35.00€0.50matched
97capture01a1b656-f82a-7958-86e7-d447c418c6d8€24.00€0.37matched
98capture01a1b656-fbc6-768f-8a60-61282eef3fa8€9.00€0.19matched
99capture01a1b657-042e-71c8-98c9-50c8fdeba9c4€9.00€0.19matched
100capture01a1b657-0ea4-71a6-bf52-23f46934f851€24.00€0.37matched
101capture01a1b657-1e34-74a9-8cdf-5e8d4c55f2e5€49.00€0.67matched
102capture01a1b657-26a6-71c0-aa59-abe441058811€24.00€0.37matched
103refund01a1b657-380b-732b-9de3-fead56e0f0ae-€7.00€0.00matched
104capture01a1b657-4665-7260-b0c2-a23bd94676ef€24.00€0.37matched
105capture01a1b657-5208-7495-bf2a-c3ab43d75844€9.00€0.19matched
106capture01a1b657-6460-79e1-b0d1-d6a484c6d32a€35.00€0.50matched
107refund01a1b657-6dc9-72f0-8bae-4496888c461b-€3.00€0.00matched
108capture01a1b657-7775-7d82-95de-918f47eca90d€9.00€0.19matched
109capture01a1b657-8897-7df5-86a1-5d01fb2406f5€15.00€0.26matched
110capture01a1b657-891f-71d2-824a-b14ed44f7c93€35.00€0.50matched
111capture01a1b657-897b-7361-993a-37a575bba623€9.00€0.19matched
112capture01a1b657-8a68-74ce-a904-882c8c2c8228€9.00€0.19matched
113capture01a1b657-9420-7099-95a5-e322f2d53b0b€15.00€0.26matched
114capture01a1b657-9b8f-72c6-9679-37f54a65889a€35.00€0.50matched
115capture01a1b657-a70f-73b5-9d77-c2031519b1ae€15.00€0.26matched
116capture01a1b657-b2ef-72a6-91bf-5d8d23c286a9€24.00€0.37matched
117capture01a1b657-ee6f-7582-baa3-e9d6b643a849€35.00€0.50matched
119capture01a1b657-f39f-7541-807a-3cd07696e43d€49.00€0.67matched
120capture01a1b658-2db1-7be3-8878-0d0310299e9f€35.00€0.50matched