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, 12:40

Gross

€2,862.00

PSP fee

€46.15

Net to the bank

€2,815.85

Settlement journal

#397751

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1abb9-c4e2-7ffb-ae85-0e930494faaf is already settled by stl_EUR_2989804 line 16
LineKindReferenceGrossFeeStatus
17capture01a1abb9-c517-7fb3-bc0d-4ae0dea7e9bc€15.00€0.26duplicate line
1capture01a1abb4-c620-7f67-aa1a-b5555f796674€49.00€0.67matched
2refund01a1abb9-2b32-7b4b-8ed8-6995fe6f3b73-€12.00€0.00matched
3capture01a1abb9-3eab-7b22-ba21-8f0a8489d155€9.00€0.19matched
4capture01a1abb9-5bbf-7110-86f9-a1199139ba32€9.00€0.19matched
5capture01a1abb9-5e74-779e-954d-ba53c8a72da9€49.00€0.67matched
6capture01a1abb9-6de4-791e-b7fb-94134cc5f720€9.00€0.19matched
7capture01a1abb9-796a-7109-b8da-710f2332c0f0€24.00€0.37matched
8capture01a1abb9-9419-78db-96a2-471f561acafa€15.00€0.26matched
9capture01a1abb9-97fa-70fd-bce3-f5870bdb46f0€24.00€0.37matched
10capture01a1abb9-9b77-74be-ae99-68447c55eed4€15.00€0.26matched
11capture01a1abb9-a3bc-7aa0-aed8-56ba84941932€35.00€0.50matched
12refund01a1abb9-a50e-7bf9-bb47-ed973f24f9ee-€8.00€0.00matched
13capture01a1abb9-aa47-714c-9241-a66ba2607705€15.00€0.26matched
14capture01a1abb9-b0e1-7fdd-8710-ef40d0d2d55b€24.00€0.37matched
15capture01a1abb9-be03-7436-9d4b-3ef793eb83a6€24.00€0.37matched
16capture01a1abb9-c517-7fb3-bc0d-4ae0dea7e9bc€15.00€0.26matched
18capture01a1abb9-cee9-75d1-8991-5b15438150ff€49.00€0.67matched
19capture01a1abb9-ddcc-775a-9d40-88f66c64c58e€35.00€0.50matched
20capture01a1abb9-dec7-71aa-8bfa-0372f5aacb78€49.00€0.67matched
21capture01a1abb9-f089-7c3a-8a11-d97a9f9168aa€24.00€0.37matched
22capture01a1abb9-fee4-7430-b69e-34429f36477f€49.00€0.67matched
23capture01a1abba-0891-78fc-9d42-25b9291fce23€9.00€0.19matched
24capture01a1abb9-f4ee-7c9b-8582-7a2146771240€9.00€0.19matched
25refund01a1abba-2467-7ef1-b699-768f2a558e71-€14.00€0.00matched
26capture01a1abba-2565-7944-a26e-daee8bbf4c06€15.00€0.26matched
27capture01a1abba-2695-7eaf-b05e-ca4cd5a7b04e€9.00€0.19matched
28capture01a1abba-3bf5-7fcf-9b78-54d81ef96d10€24.00€0.37matched
29capture01a1abba-3dee-7dc3-87ba-a083728e7404€35.00€0.50matched
30capture01a1abba-4c26-733d-a910-8643aa73c67a€15.00€0.26matched
31capture01a1abba-5669-7629-8155-f729be426386€15.00€0.26matched
32capture01a1abba-5e50-78b3-b800-4e5397e25fe6€49.00€0.67matched
33refund01a1abba-749d-7a05-b47c-ef84b47d587c-€7.00€0.00matched
34capture01a1abba-984a-76db-b26c-e4f22c2f91b6€9.00€0.19matched
35capture01a1abba-9da2-7c89-a612-b4a048c08a1c€9.00€0.19matched
36capture01a1abba-b13e-7b8f-84f9-13c864541744€24.00€0.37matched
37capture01a1abba-b31d-7a0c-a375-228f6377568e€9.00€0.19matched
38capture01a1abba-e1f5-74af-873a-cf3f6ffd9131€9.00€0.19matched
39capture01a1abba-f07c-7155-a192-f41933da967f€24.00€0.37matched
40capture01a1abba-f9dd-71ff-91cb-131cd998d03e€9.00€0.19matched
41capture01a1abbb-0709-7d5e-b067-f8afce123185€49.00€0.67matched
42capture01a1abbb-1240-701f-824e-4be8c6a39432€24.00€0.37matched
43capture01a1abbb-1303-742e-bfa1-382673644e4f€49.00€0.67matched
44capture01a1abbb-2343-732a-84a0-4704612a9942€35.00€0.50matched
45capture01a1abbb-2781-7150-afcd-51f79c1ad3f7€9.00€0.19matched
46capture01a1abbb-5204-74f1-96c1-89c93e3cbaf8€35.00€0.50matched
47capture01a1abbb-b2dd-7fb9-af8d-ce96fd86c6c6€49.00€0.67matched
48capture01a1abbc-08af-73b1-b6f4-24d978230d59€9.00€0.19matched
49capture01a1abbc-18ce-713d-a750-ebf9f8c8c8ae€9.00€0.19matched
50capture01a1abbc-1a55-72df-a8ef-f87ca15886ed€24.00€0.37matched
51capture01a1abbc-2bc5-726d-a95a-e0d98bd77271€35.00€0.50matched
52capture01a1abbc-2f56-7a9b-a0cd-21ff059b7016€24.00€0.37matched
53capture01a1abbc-5738-72a2-8a43-1a97a006b2b4€15.00€0.26matched
54capture01a1abbc-8081-7a52-b6d9-81bf0233203a€9.00€0.19matched
55capture01a1abbc-8fd6-7546-83cd-495135d15680€24.00€0.37matched
56capture01a1abbc-915b-7b97-8025-d0b7fc0b9b96€24.00€0.37matched
57capture01a1abbc-a08c-7a17-9754-02d3f23026ed€24.00€0.37matched
58capture01a1abbc-ac2a-77a9-a773-83402a559bbc€49.00€0.67matched
59capture01a1abbc-b774-7cdf-a5b4-2db25a1ab208€15.00€0.26matched
60capture01a1abbc-f1c2-7bab-bc21-5ec42dfecad0€24.00€0.37matched
61capture01a1abbc-f63d-7c3e-a68c-d2d82b41bc94€9.00€0.19matched
62capture01a1abbc-fabd-779f-9bfd-b07dfec23514€24.00€0.37matched
63capture01a1abbd-122f-7a96-96e6-4de169e3b94f€35.00€0.50matched
64refund01a1abbd-49fd-7602-9bea-83290e88db8d-€21.00€0.00matched
65capture01a1abbd-4a28-7c24-af0c-c08b514657bf€9.00€0.19matched
66capture01a1abbd-56fd-7836-8e56-6934cfaf13fc€35.00€0.50matched
67capture01a1abbd-8d45-7e68-b521-a798b9e1bae8€9.00€0.19matched
68capture01a1abbd-8e6f-7781-8a0a-dd7c46566215€9.00€0.19matched
69capture01a1abbd-9832-7643-82f4-405d46b6d790€35.00€0.50matched
70capture01a1abbd-a56b-7fbf-84e9-8c0a838daedd€9.00€0.19matched
71capture01a1abbd-bd39-7f90-91e7-ce4dd185c5f8€15.00€0.26matched
72capture01a1abbd-beee-7e59-bff7-ed602d7fb7db€49.00€0.67matched
73capture01a1abbe-22a4-7de0-aa25-ae254db0a86d€35.00€0.50matched
74capture01a1abbe-37a5-7c00-8486-f2794a7b4372€35.00€0.50matched
75capture01a1abbe-382c-7728-bc91-cd1fa5ad1a96€15.00€0.26matched
76capture01a1abbe-4b8a-73c4-81f0-1e901b9ee01e€49.00€0.67matched
77capture01a1abbe-56bf-755b-ae75-567333a9dd3f€15.00€0.26matched
78capture01a1abbe-5d59-7986-803e-1619429686ad€35.00€0.50matched
79capture01a1abbe-6114-7cf1-afe0-a4bef39afdd9€49.00€0.67matched
80capture01a1abbe-625a-7a5a-8762-5b8c9792046b€24.00€0.37matched
81capture01a1abbe-72fc-7941-b3ac-c0e4a9b59063€15.00€0.26matched
82capture01a1abbe-75ed-74a5-9e2a-b2397cba2825€9.00€0.19matched
83capture01a1abbe-866f-75aa-a36a-69f99a17ede8€24.00€0.37matched
84capture01a1abbe-874f-77f0-8c67-99118f4e9f23€15.00€0.26matched
85capture01a1abbe-8a92-771a-9b6e-e0f2a51d180c€49.00€0.67matched
86capture01a1abbe-8d8f-7a26-a572-4c12f5985c33€24.00€0.37matched
87capture01a1abbe-986f-72d5-89da-1d7187f1b9be€49.00€0.67matched
88capture01a1abbe-a03b-7a80-a1a6-e5451eff71a9€49.00€0.67matched
89refund01a1abbe-a7cd-7398-a553-5d9cb57d3717-€7.00€0.00matched
90capture01a1abbf-05fc-70be-8f71-4c9cb99d1a0c€24.00€0.37matched
91capture01a1abbf-2d61-75d5-8948-44e155b4c873€35.00€0.50matched
92capture01a1abbf-33e0-7629-a3a0-11dd23742611€9.00€0.19matched
93capture01a1abbf-648c-73ed-a6ea-a2e594ecce55€24.00€0.37matched
94capture01a1abbf-8011-7f94-8efb-1e29d237dcdd€9.00€0.19matched
95refund01a1abbf-9ff6-7943-8d77-c1cb17cac7da-€21.00€0.00matched
96capture01a1abbf-a449-70a3-ad87-5923f0081e01€24.00€0.37matched
97capture01a1abbf-a919-7802-9ed1-a1e8af585242€9.00€0.19matched
98capture01a1abbf-bca2-76a2-b864-1045286b536c€9.00€0.19matched
99capture01a1abbf-c47b-76c6-9e5f-f1524d8a7819€49.00€0.67matched
100capture01a1abbf-cee8-74a8-b62b-aa4338bbf985€9.00€0.19matched
101capture01a1abc0-0df5-7691-80cb-f978c4380d99€35.00€0.50matched
102capture01a1abc0-1957-74c5-8aa2-f98867e84424€24.00€0.37matched
103capture01a1abc0-2141-7701-b30a-c9c255b22432€15.00€0.26matched
104capture01a1abc0-2c66-7b78-85fb-4cb99777bf1a€49.00€0.67matched
105capture01a1abc0-2de9-7916-beca-1ef5302a75f7€15.00€0.26matched
106capture01a1abc0-5d59-7c90-8411-87b0bb501276€35.00€0.50matched
107capture01a1abc0-93c3-7179-b26c-e4f7b8e2a631€9.00€0.19matched
108capture01a1abc0-a448-7460-bff5-b4640de18f42€49.00€0.67matched
109capture01a1abc0-ae76-7553-9a58-37e7419bd35a€9.00€0.19matched
110capture01a1abc0-b271-7ed9-b3db-89ddeefb06fb€24.00€0.37matched
111capture01a1abc0-c72a-7570-b817-7ba6e7e94b2a€35.00€0.50matched
112capture01a1abc0-d486-7467-a291-450e90998a01€49.00€0.67matched
113capture01a1abc0-dffb-7d9a-a9ca-9a971151054b€35.00€0.50matched
114capture01a1abc1-1146-7390-9324-882dd4960f39€24.00€0.37matched
115capture01a1abc1-1200-7d3e-9016-64d443cf869c€15.00€0.26matched
116capture01a1abc1-1600-700f-b5c9-a630da4db001€24.00€0.37matched
117capture01a1abc1-1b0b-74fd-9bd5-c1b2062c0bd5€15.00€0.26matched
118capture01a1abc1-2d0c-75cd-922c-b987319f36e9€15.00€0.26matched
119refund01a1abc1-349b-7521-adf9-627f94b91a64-€32.00€0.00matched
120capture01a1abc1-5a98-7ed3-a6c1-312827263d22€15.00€0.26matched
121capture01a1abc1-8a8c-7e73-bb00-7c75ad7511ab€15.00€0.26matched
122capture01a1abc1-8f5e-7c95-b621-8bc77ab17ce7€15.00€0.26matched
123capture01a1abc1-9088-7da9-b895-09863e2f2eef€9.00€0.19matched
124capture01a1abc1-91ab-7d5e-9127-00ed03ccf139€35.00€0.50matched
125capture01a1abc1-944e-7e84-9fd8-878f2fd7f496€24.00€0.37matched
126capture01a1abc1-ba56-74b8-a001-ff81e4cc2c22€15.00€0.26matched
127capture01a1abc1-c5f5-7c62-9cd1-9fe49682a71a€24.00€0.37matched
128capture01a1abc1-cb84-711c-a83a-475cae8c4e7e€9.00€0.19matched
129capture01a1abc1-fc28-75b0-bf8d-c37691c2eb63€35.00€0.50matched
130refund01a1abc1-fe2f-79bf-873b-00e1214c4ef0-€22.00€0.00matched
131capture01a1abc2-2190-74d0-974e-9487cf8610a6€15.00€0.26matched
132capture01a1abc2-26d2-7492-98a1-209ea4ea6aea€9.00€0.19matched
133capture01a1abc2-2f36-7848-af7c-f473c07b2ebf€35.00€0.50matched