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

Gross

€3,295.00

PSP fee

€51.96

Net to the bank

€3,243.04

Settlement journal

#341691

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19beb-d8bc-77f8-95bd-03ac5c1af501 is already settled by stl_EUR_2989362 line 22
  • fee differencethe fee is not the contract feethe fee is 5, the contract says 0
LineKindReferenceGrossFeeStatus
9refund01a19bea-e170-79c4-a582-bb24200d8696-€23.00€0.05fee difference
23capture01a19beb-d98d-78cd-9b6e-bc299b03956e€24.00€0.37duplicate line
1capture01a19be3-049e-7607-9309-9b68a6060462€15.00€0.26matched
2capture01a19be4-a264-79d7-a49e-c1fbc02975af€9.00€0.19matched
3capture01a19be4-f7fc-7a1a-937c-3fb928b5e64e€15.00€0.26matched
4capture01a19bea-8b29-7879-8d37-92edd5f94ade€9.00€0.19matched
5capture01a19bea-b059-76a6-822c-408a1e89cd4e€24.00€0.37matched
6capture01a19bea-c477-77dd-9ee4-28466d8b8fde€9.00€0.19matched
7capture01a19bea-d2da-72d6-9537-bbed07fedf6a€9.00€0.19matched
8capture01a19bea-df95-7a92-860b-bcc299cc99f8€49.00€0.67matched
10capture01a19bea-efa7-7bd8-8501-119fc3b281a9€35.00€0.50matched
11capture01a19bea-f4e4-7a6b-8bd1-a91a4f7f82b6€15.00€0.26matched
12capture01a19beb-186f-70ed-a32b-dd45a71425e4€9.00€0.19matched
13capture01a19beb-18e1-7c25-b45e-08374ef21885€9.00€0.19matched
14capture01a19beb-2241-7a16-b3f7-6c1bc42e4955€49.00€0.67matched
15capture01a19beb-3513-70c2-8ce0-40bcb91aefdf€35.00€0.50matched
16capture01a19beb-3ec6-776c-9b87-19386ca81a9b€15.00€0.26matched
17capture01a19beb-8244-7ecc-a2fd-d6c7732bd2ef€9.00€0.19matched
18capture01a19beb-87ea-7ca7-a3f0-9977c2d39286€9.00€0.19matched
19capture01a19beb-9d34-7327-a108-947da3b5ad43€24.00€0.37matched
20capture01a19beb-ac52-736d-8dd2-e1e335939def€15.00€0.26matched
21capture01a19beb-d6bc-7882-b243-d89db27bebfd€15.00€0.26matched
22capture01a19beb-d98d-78cd-9b6e-bc299b03956e€24.00€0.37matched
24capture01a19beb-d770-7ec0-92d4-7f1dd6a26238€9.00€0.19matched
25refund01a19beb-fcbe-752b-8d6d-e120c7e0ead2-€5.00€0.00matched
26refund01a19bec-35ef-7620-bd7f-be5fb94f83ff-€20.00€0.00matched
27capture01a19bec-3837-7c72-8e66-12cbc5bd7cae€24.00€0.37matched
28capture01a19bec-408e-76ef-a3d6-6bd26a12a667€35.00€0.50matched
29capture01a19bec-4de3-7bae-99e7-5336264a6259€9.00€0.19matched
30capture01a19bec-689e-78f3-9974-c0f82b95528f€24.00€0.37matched
31capture01a19bec-7365-7a26-b745-65b2238c5eef€49.00€0.67matched
32capture01a19bec-a144-7230-9561-31ced857e801€9.00€0.19matched
33capture01a19bec-bcbf-714d-a23b-2f2de495b7b2€49.00€0.67matched
34capture01a19bec-d66c-7cdc-b23c-53e59b683a4a€49.00€0.67matched
35capture01a19bec-dc89-7dc1-8c56-6399e6adcd1b€15.00€0.26matched
36capture01a19bec-ea67-7630-8004-29aee37563ce€15.00€0.26matched
37capture01a19bec-f09f-7d9c-abce-b5ccd4d59826€15.00€0.26matched
38capture01a19bed-0c06-7b2f-86dc-e4adb5a9f7f4€35.00€0.50matched
39capture01a19bed-3241-7ec4-8406-b41378dee87d€9.00€0.19matched
40capture01a19bed-3e5a-721c-926e-cc06762546c4€9.00€0.19matched
41capture01a19bed-506e-7f61-9066-45363adb942d€9.00€0.19matched
42capture01a19bed-6298-7ed2-ac1d-7ad23f797d18€35.00€0.50matched
43capture01a19bed-7338-7b7a-b60e-3648c5d34d0a€15.00€0.26matched
44capture01a19bed-7d45-764a-8479-c91342b7aa71€49.00€0.67matched
45capture01a19bed-8343-718c-814f-ce1a8a134d4b€24.00€0.37matched
46capture01a19bed-9657-7616-9964-1ac6e6df20ee€24.00€0.37matched
47capture01a19bed-b4a4-7950-8029-2d1ce31d34ec€9.00€0.19matched
48capture01a19bed-b5bc-719d-891d-e838e8474039€9.00€0.19matched
49capture01a19bed-f570-7406-b72a-153dc6d9d536€49.00€0.67matched
50capture01a19bed-fc75-7035-b721-76f75eb68ab6€49.00€0.67matched
51capture01a19bed-ff19-73ba-a846-5d2f358a1015€15.00€0.26matched
52capture01a19bee-1632-79b5-8ad0-3ebdf18f9971€9.00€0.19matched
53capture01a19bee-2562-72d1-a837-decde50acf9d€24.00€0.37matched
54capture01a19bee-3200-7721-b139-961fb7bf5319€35.00€0.50matched
55capture01a19bee-477d-7fc8-b00c-325c11225b4c€15.00€0.26matched
56capture01a19bee-5657-7d6a-965c-cc8e68209105€24.00€0.37matched
57capture01a19bee-72db-7ede-ae74-48976c924ba5€15.00€0.26matched
58capture01a19bee-7344-7797-9a04-0e76b1abf6bd€24.00€0.37matched
59capture01a19bee-835f-7b2f-97dc-680185a686f7€35.00€0.50matched
60capture01a19bee-8b8b-7fb2-8337-36df5ea6bdc4€9.00€0.19matched
61capture01a19bee-8ca3-7576-8dd6-a896b959eec6€49.00€0.67matched
62capture01a19bee-9408-7424-9fbe-4a7adac07ec4€9.00€0.19matched
63capture01a19bee-c144-7b69-889c-fe541b760bfa€49.00€0.67matched
64capture01a19bee-d0be-7e9d-aead-9884fdeaf518€9.00€0.19matched
65capture01a19bee-e7e1-7a04-b1c0-c816425d73d7€35.00€0.50matched
66capture01a19bee-eb14-7182-a22b-d5c35e90f2e5€9.00€0.19matched
67capture01a19bee-ee9e-7448-9e04-636b0e5f9d21€15.00€0.26matched
68capture01a19bee-eeb6-7df0-9291-38060f1bf751€35.00€0.50matched
69capture01a19bee-f695-72bf-bd4a-688ff5b7d1d6€9.00€0.19matched
70capture01a19bef-01b6-7305-825c-b3a967e5eee4€49.00€0.67matched
71capture01a19bef-0d4c-765b-bf78-5caf51f72f5d€49.00€0.67matched
72capture01a19bef-29e5-79b7-9049-6d93039c04ee€15.00€0.26matched
73capture01a19bef-2a52-751a-a7d2-97b0347d51c8€9.00€0.19matched
74capture01a19bef-4291-72a7-9b9d-986c5b987889€49.00€0.67matched
75capture01a19bef-4293-758e-bd91-4cad54d5e53a€35.00€0.50matched
76capture01a19bef-4292-7482-b3c4-d82a0933ee26€24.00€0.37matched
77capture01a19bef-4415-7a34-980b-ea7104c95bff€49.00€0.67matched
78refund01a19bef-47bf-7358-a942-35d290c97434-€13.00€0.00matched
79capture01a19bef-580f-7010-887a-7767c2dcb62c€15.00€0.26matched
80refund01a19bef-6e3c-73c4-9172-26606a7c62af-€9.00€0.00matched
81capture01a19bef-726a-7694-908e-f17ff941da03€35.00€0.50matched
82capture01a19bef-879d-79db-8abb-1e5513136cb5€24.00€0.37matched
83capture01a19bef-95be-7cb9-b45f-519dea3b19fe€49.00€0.67matched
84capture01a19bef-add0-73b5-b287-352ae60d6d65€49.00€0.67matched
85capture01a19bef-c8cb-7bd7-9dd2-74c884601163€35.00€0.50matched
86refund01a19bef-cc78-7dbd-9d35-98aecc853168-€18.00€0.00matched
87refund01a19bef-cdd1-7a98-8478-1b1e6e10659a-€7.00€0.00matched
88capture01a19bef-e8f1-72ed-9ab1-0f4fc2140d5a€24.00€0.37matched
89capture01a19bf0-2904-7fcf-92d9-2d09740b9ede€9.00€0.19matched
90capture01a19bf0-340f-72e0-b56c-7e9f3b08f7a1€49.00€0.67matched
91capture01a19bf0-7bac-7d08-95f0-c1fefc45a4cc€24.00€0.37matched
92capture01a19bf0-7e50-796f-a915-b38a26a03d28€15.00€0.26matched
93capture01a19bf0-81ab-7fc1-9e61-1db854300316€49.00€0.67matched
94capture01a19bf0-c942-7749-aa74-3c64a785419f€35.00€0.50matched
95capture01a19bf0-d52f-7109-849b-6f3c1817066f€49.00€0.67matched
96capture01a19bf1-0836-7823-a8d8-62108b0c32c0€35.00€0.50matched
97capture01a19bf1-0f2b-739a-b7be-89126fd4c1f0€35.00€0.50matched
98capture01a19bf1-27b5-7f9c-bfd5-90cee8fce159€24.00€0.37matched
99capture01a19bf1-32b5-7834-b27c-e2c103218c3c€15.00€0.26matched
100capture01a19bf1-35dc-70b0-83d8-0fe2795076ad€35.00€0.50matched
101capture01a19bf1-4d74-7e93-9ad6-6c1811480c09€35.00€0.50matched
102capture01a19bf1-5295-74c2-a081-2823ad1afb96€35.00€0.50matched
103capture01a19bf1-6759-766b-969d-8be4af827fc3€9.00€0.19matched
104capture01a19bf1-74a9-7223-829a-b30e979447ec€49.00€0.67matched
105capture01a19bf1-7dff-7def-a576-b62fab219386€9.00€0.19matched
106refund01a19bf1-9f13-7e6d-b6c0-654bb23bba81-€31.00€0.00matched
107refund01a19bf1-b2c2-730a-a9af-5e3d4636691a-€29.00€0.00matched
108capture01a19bf1-b546-7563-b56d-4e4f81ce0e6d€35.00€0.50matched
109capture01a19bf1-bdf1-7ee5-8b62-c0a61b5ea418€24.00€0.37matched
110capture01a19bf1-d89e-72ce-bf73-7e79c5a44bba€35.00€0.50matched
111capture01a19bf1-e6c5-7b5a-b61f-302d2e6eec0d€35.00€0.50matched
112capture01a19bf1-e6e0-7aa3-9ffa-a56f56692ad6€24.00€0.37matched
113capture01a19bf1-e8b7-7381-818a-cf5f92ad987b€35.00€0.50matched
114capture01a19bf2-0baa-7882-aaaf-7f11461923a8€49.00€0.67matched
115capture01a19bf2-19cd-7223-84f9-2acf66d32aad€35.00€0.50matched
116capture01a19bf2-1cf6-74c5-99fd-ee83e980f21e€49.00€0.67matched
117capture01a19bf2-4799-7681-a153-7c4fd7e09a67€9.00€0.19matched
118capture01a19bf2-4c29-760c-bd89-ad2734945214€24.00€0.37matched
119refund01a19bf2-51ca-7a94-a403-da9bff360bdd-€9.00€0.00matched
120capture01a19bf2-5b56-7a7f-af1e-7d30720e9d82€24.00€0.37matched
121capture01a19bf2-6ca6-7422-89e3-ca296527fddd€49.00€0.67matched
122capture01a19bf2-6fdd-78ba-8c47-99e82fe2c09c€49.00€0.67matched
123capture01a19bf2-7cf9-785f-bacc-ee484a51bf5f€9.00€0.19matched
124capture01a19bf2-85fc-7826-8263-7b2848b453e5€24.00€0.37matched
125capture01a19bf2-9203-70ad-8231-e71599026911€49.00€0.67matched
126capture01a19bf2-a440-7c57-9a6d-1276f311b560€35.00€0.50matched
127capture01a19bf2-ac7e-7fd6-8942-31e17db50d2d€9.00€0.19matched
128capture01a19bf2-be3c-71d0-baef-960f4583ee44€15.00€0.26matched
129capture01a19bf2-f350-71a5-b5d9-df92d603d3b0€49.00€0.67matched
130capture01a19bf2-ff15-7920-b7b4-a090778b35d5€9.00€0.19matched
131capture01a19bf3-20c2-731f-adfb-0a265f9996ad€35.00€0.50matched
132capture01a19bf3-20be-78ce-80a7-0e9f431b034b€24.00€0.37matched
133capture01a19bf3-4da6-7c12-9874-4f977983240e€35.00€0.50matched
134capture01a19bf3-54cf-7e78-a281-44f77558023a€49.00€0.67matched
135capture01a19bf3-727a-79e8-ad88-d1412fd53228€49.00€0.67matched
136capture01a19bf3-7a15-73a5-b64f-ce24a091af8b€24.00€0.37matched
137capture01a19bf3-845a-7cde-80cd-71a0bc14c8bc€35.00€0.50matched
138capture01a19bf3-9275-79ec-a30e-c8cb32f7983c€35.00€0.50matched