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, 07:30

Gross

€2,863.00

PSP fee

€45.55

Net to the bank

€2,817.45

Settlement journal

#375515

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a1a577-f186-7590-a6cf-700c51a15aaa is already settled by stl_EUR_2989629 line 22
LineKindReferenceGrossFeeStatus
23refund01a1a577-f187-790a-8e43-242a7c944d91-€2.00€0.00duplicate line
1capture01a1a56d-f0c6-7989-a578-14e62e7b79d4€15.00€0.26matched
2capture01a1a571-8651-7b61-9d1a-4eb0404d58da€35.00€0.50matched
3capture01a1a577-0b92-7ab8-bb04-6d76d8140680€9.00€0.19matched
4capture01a1a577-1198-7fd4-9d43-08d7e56e9198€9.00€0.19matched
5capture01a1a577-3474-7ac0-8ef1-470390f7c406€15.00€0.26matched
6capture01a1a577-3bf0-7f96-b73d-c485008b066a€15.00€0.26matched
7capture01a1a577-7853-787b-95eb-7d239823ae6f€9.00€0.19matched
8capture01a1a577-8631-773a-952a-72f4069416b4€49.00€0.67matched
9capture01a1a577-8789-70c0-be06-2a9da60cff1d€49.00€0.67matched
10capture01a1a577-8b4b-70a2-87ac-6359f566e795€35.00€0.50matched
11capture01a1a577-8dc3-7002-a370-98dde4e35df6€15.00€0.26matched
12capture01a1a577-8f8f-71a4-9e36-aceebebcbc53€9.00€0.19matched
13capture01a1a577-9451-7c80-a658-87fe175c0127€35.00€0.50matched
14capture01a1a577-9ef5-7441-bf51-755f58bed4cf€49.00€0.67matched
15capture01a1a577-ad41-7040-a89f-8cb3c1c4801f€49.00€0.67matched
16capture01a1a577-ae19-75a3-9976-730e0d44ae02€15.00€0.26matched
17capture01a1a577-b35e-7db6-987a-53f6baf56923€9.00€0.19matched
18capture01a1a577-cbe2-74de-b110-2a8e4f1cda7b€35.00€0.50matched
19capture01a1a577-d9d1-7867-8dc4-603c855ca57a€9.00€0.19matched
20capture01a1a577-ddf4-7386-96da-d2ac77ff3d55€9.00€0.19matched
21capture01a1a577-e80c-7830-a6ff-75337cc9ff63€24.00€0.37matched
22refund01a1a577-f187-790a-8e43-242a7c944d91-€2.00€0.00matched
24capture01a1a577-f82f-76a2-8842-3afaccb37197€49.00€0.67matched
25capture01a1a578-12f1-7c2d-bba3-70b7818262e8€35.00€0.50matched
26capture01a1a578-23b2-7c36-ad19-4d9047465602€49.00€0.67matched
27capture01a1a578-46cc-72bf-a8ed-c7cae629a99e€49.00€0.67matched
28capture01a1a578-5b71-769a-ba93-a299013d15cb€49.00€0.67matched
29capture01a1a578-7f80-75c9-838c-67392cf6e47e€35.00€0.50matched
30capture01a1a578-8231-702e-86a9-836caf0c9371€24.00€0.37matched
31refund01a1a578-91df-721d-b26e-e225b0c129cd-€15.00€0.00matched
32capture01a1a578-8ffd-7cf6-b20b-81e9edd9ac3b€24.00€0.37matched
33capture01a1a578-9489-71fc-941c-a0c0ec357d7a€15.00€0.26matched
34capture01a1a578-b087-74ba-afb4-852cde121499€9.00€0.19matched
35capture01a1a578-b232-72d7-b6a6-b9715a89df49€9.00€0.19matched
36capture01a1a578-bf87-7c8d-8f94-bb041756918c€15.00€0.26matched
37capture01a1a578-d441-73ac-b9e7-d994e3c62484€49.00€0.67matched
38capture01a1a578-e59d-7f43-9636-6073ea8a390c€9.00€0.19matched
39capture01a1a578-ec2d-74d1-b8cf-18e67411567e€9.00€0.19matched
40capture01a1a578-f41b-755a-af02-63cfbe7ffc6a€49.00€0.67matched
41capture01a1a579-17d9-755e-bccd-1a3ed83d9f85€9.00€0.19matched
42capture01a1a579-1ed4-7fda-8ba8-0f3e02967db3€35.00€0.50matched
43capture01a1a579-2016-74ad-89d8-b1543e29fdac€9.00€0.19matched
44capture01a1a579-208f-74ae-9251-80cd70ea14ae€9.00€0.19matched
45capture01a1a579-4760-7796-8352-6c48a4839198€9.00€0.19matched
46capture01a1a579-531e-756c-bc21-8f172c7319e6€15.00€0.26matched
47capture01a1a579-5810-7f02-aa01-673ae31b3362€35.00€0.50matched
48refund01a1a579-5d07-713f-a6b9-c612759a1bc8-€21.00€0.00matched
49capture01a1a579-5fa5-76d3-806c-619e1948e0ed€35.00€0.50matched
50capture01a1a579-94b2-7ea8-be91-a224bf45381f€15.00€0.26matched
51capture01a1a57a-2f84-7eea-851f-f2444681bd9b€24.00€0.37matched
52capture01a1a57a-378a-737e-9d8b-37b90ad6fcca€24.00€0.37matched
53capture01a1a57a-85d8-74dd-a59d-e2389690a2ca€15.00€0.26matched
54capture01a1a57a-995a-7668-9e4d-db88252fe457€15.00€0.26matched
55capture01a1a57a-9d83-7565-985f-147305bdcd23€9.00€0.19matched
56capture01a1a57a-a508-7655-a433-c734dda49c68€9.00€0.19matched
57capture01a1a57a-a802-7fc9-b1f4-e8cd8b28c705€9.00€0.19matched
58capture01a1a57a-b078-7503-a755-237ac074caa4€15.00€0.26matched
59capture01a1a57a-b889-7075-b6fd-044201ce1d07€15.00€0.26matched
60capture01a1a57b-02c4-70df-885a-d7d9f7ba77fc€15.00€0.26matched
61capture01a1a57b-05e4-7cb5-9bb5-933ea9d64d63€35.00€0.50matched
62capture01a1a57b-2320-719f-adcd-f1f102888259€49.00€0.67matched
63capture01a1a57b-3c68-73a4-a9fa-b47d7d1b65bd€24.00€0.37matched
64capture01a1a57b-4ac8-7531-9705-f61cb4ae822e€49.00€0.67matched
65capture01a1a57b-69f2-7db1-9b8c-36357c30043f€35.00€0.50matched
66capture01a1a57b-6ac6-7aa4-bac6-465334b5d789€24.00€0.37matched
67capture01a1a57b-a5ef-71af-a117-c058068841ac€49.00€0.67matched
68capture01a1a57b-a76b-7ed0-b74e-22c356677f3b€35.00€0.50matched
69capture01a1a57b-bfb3-7866-9308-22dafb1bb312€24.00€0.37matched
70capture01a1a57b-f9a8-76ac-8992-f5432f676efa€15.00€0.26matched
71capture01a1a57b-fa9d-7dbf-9206-cc29b7bd762a€15.00€0.26matched
72capture01a1a57c-2e00-7e02-812c-a532acfa644e€9.00€0.19matched
73capture01a1a57c-4a64-7915-a8b7-e0128f39db9e€49.00€0.67matched
74refund01a1a57c-5f4f-7002-89d0-7288bd41bc2b-€13.00€0.00matched
75capture01a1a57c-66d5-742c-ab33-56e8feacbb4d€49.00€0.67matched
76capture01a1a57c-a3c8-7f77-adae-4c72f5ed86f9€35.00€0.50matched
77capture01a1a57c-b228-7821-9a82-52fa785b8a90€49.00€0.67matched
78capture01a1a57c-dd0c-774d-956b-5d9c9213d45e€15.00€0.26matched
79capture01a1a57c-dfb8-7918-b8c5-2b6692a010a4€15.00€0.26matched
80capture01a1a57c-e797-7357-985a-f8277a95e2a5€35.00€0.50matched
81capture01a1a57d-088a-772d-bf9a-82ee2e81a82c€49.00€0.67matched
82capture01a1a57d-2b8b-7eeb-a9c6-b50ce8211b6d€35.00€0.50matched
83capture01a1a57d-2a83-76ce-b186-753d7c721943€24.00€0.37matched
84refund01a1a57d-5662-7944-ac31-f30d640a5b1e-€48.00€0.00matched
85capture01a1a57d-56d5-7775-9c12-bee072695662€49.00€0.67matched
86capture01a1a57d-6bc2-7409-931f-b35c8b164b33€9.00€0.19matched
87capture01a1a57d-6c7b-7a75-9129-f3e890fe6ca6€9.00€0.19matched
88refund01a1a57d-6c0d-7355-97e8-4eeb61054b3d-€6.00€0.00matched
89capture01a1a57d-8bc1-724a-8c26-87c14edefd07€9.00€0.19matched
90capture01a1a57d-a70a-7b88-9f92-63fda555fb08€15.00€0.26matched
91capture01a1a57d-a83d-7bc9-9d33-dfe21a38aa9c€49.00€0.67matched
92capture01a1a57d-c6b7-7f0e-bc2e-129ad68e53a2€49.00€0.67matched
93capture01a1a57d-e063-75c5-9f3f-085bac36a809€24.00€0.37matched
94capture01a1a57d-e20a-7cd1-b0eb-3b2c5c879b84€9.00€0.19matched
95capture01a1a57d-ea33-7d06-a3b8-e2160d1dfb9b€49.00€0.67matched
96capture01a1a57d-f903-78e9-aa8e-2182462978aa€49.00€0.67matched
97capture01a1a57e-0ef5-7791-89a0-658ec8ee28c9€24.00€0.37matched
98capture01a1a57e-210e-7f73-b7de-f9ef8d125af1€9.00€0.19matched
99capture01a1a57e-27b9-701a-8b78-3e3f7070ff9c€15.00€0.26matched
100capture01a1a57e-3818-72ea-a738-bff5d70b0978€15.00€0.26matched
101capture01a1a57e-3b30-7377-b72c-f651db4d3359€24.00€0.37matched
102capture01a1a57e-3c18-7389-a2b7-f6687b7aa4d7€24.00€0.37matched
103capture01a1a57e-49e1-7f75-b97c-9f9a1998b85e€9.00€0.19matched
104capture01a1a57e-4b7b-7a63-a059-da97e3a835bf€15.00€0.26matched
105capture01a1a57e-5f52-72bc-a640-86b8b60fcbb4€35.00€0.50matched
106refund01a1a57e-9011-7b37-b93e-2c1915067233-€13.00€0.00matched
107capture01a1a57e-ae49-77bd-b3f4-9628f8c15fd3€24.00€0.37matched
108capture01a1a57e-b784-7ed2-ae8a-37556c5d74bc€35.00€0.50matched
109capture01a1a57e-e769-7384-a1e2-73f8ff643dc2€9.00€0.19matched
110capture01a1a57e-f335-7196-a200-25ee563690f0€15.00€0.26matched
111capture01a1a57f-01c2-7c80-86d9-310cf8047789€9.00€0.19matched
112capture01a1a57f-0efa-7384-96b4-bed50d65b3ad€24.00€0.37matched
113capture01a1a57f-251f-7da9-81d9-45c5c3473417€49.00€0.67matched
114capture01a1a57f-2900-76da-bd9a-f3caf2cba5f5€49.00€0.67matched
115capture01a1a57f-2fba-7374-a22b-65ada8c8b776€9.00€0.19matched
116capture01a1a57f-342e-7cc0-aa14-15d8706c8671€15.00€0.26matched
117capture01a1a57f-34e5-72e0-90d4-250ce7be3846€9.00€0.19matched
118capture01a1a57f-3a7d-7ee3-8360-927deb52a39f€24.00€0.37matched
119capture01a1a57f-4e04-749c-ab2b-04633788cb31€35.00€0.50matched
120capture01a1a57f-5746-7c5a-918c-79e02d3e086c€24.00€0.37matched
121capture01a1a57f-57e6-7b66-a28e-240bd755c165€15.00€0.26matched
122capture01a1a57f-8748-7941-a601-8bdd2138ae04€9.00€0.19matched
123capture01a1a57f-89e7-70f8-aed7-8c0f96c84296€9.00€0.19matched
124capture01a1a57f-a408-7a38-b45e-e6e7ec3c5ddf€24.00€0.37matched
125capture01a1a57f-a688-7168-8875-135dc19e4b7f€9.00€0.19matched
126capture01a1a57f-ee8d-7ec9-8660-e4950f0929bc€9.00€0.19matched
127capture01a1a57f-f159-7fa3-aa16-c9c1fe598500€49.00€0.67matched
128capture01a1a580-0c1b-7686-9b28-02b2db70bd60€24.00€0.37matched