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, 01:20

Gross

€2,748.00

PSP fee

€44.73

Net to the bank

€2,703.27

Settlement journal

#389177

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a94e-1a3b-73f6-982e-5c41e3ce9e13 is already settled by stl_EUR_2989736 line 44
  • fee differencethe fee is not the contract feethe fee is 42, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
LineKindReferenceGrossFeeStatus
13capture01a1a94b-491b-7f6d-99e8-085bff520da2€24.00€0.42fee difference
45capture01a1a94e-1a61-7f40-9093-30d0c9a762ee€49.00€0.67duplicate line
68capture01a1a94f-8c62-77c0-ab4d-b2a195d26408€9.00€0.21fee difference
1capture01a1a944-447e-7a86-bdba-0ee1480c5fb3€49.00€0.67matched
2capture01a1a948-f5e6-7a77-a0a2-702f98d77924€49.00€0.67matched
3capture01a1a94a-af8c-72bd-aca9-8ee9cd99bde4€35.00€0.50matched
4capture01a1a94a-c315-7240-a679-1b58bb11552c€24.00€0.37matched
5capture01a1a94a-c354-756e-97fe-c65d715cdd43€35.00€0.50matched
6capture01a1a94a-cf77-7483-945b-1a4626ccac55€35.00€0.50matched
7capture01a1a94a-de03-727d-a970-5a34d3bffd23€9.00€0.19matched
8refund01a1a94a-e083-7fc6-bca4-2bf54f41cfd8-€9.00€0.00matched
9capture01a1a94a-ea0b-766c-8a03-fb2639d263f3€15.00€0.26matched
10capture01a1a94a-ea37-757a-a43b-cd62409eef6a€49.00€0.67matched
11capture01a1a94a-f7ef-7db0-966d-062031c7e91f€24.00€0.37matched
12capture01a1a94b-3688-7984-ba52-8ac9d2507041€35.00€0.50matched
14capture01a1a94b-5f5c-798c-9d95-f5f86c5ea029€35.00€0.50matched
15capture01a1a94b-8d3c-770f-969e-f29873ff92ee€35.00€0.50matched
16capture01a1a94b-8da0-71af-a3da-df42d6a03095€35.00€0.50matched
17capture01a1a94b-9eda-7761-b3c3-9f4a8f17d422€35.00€0.50matched
18capture01a1a94b-a401-782e-85df-3c3c36718feb€24.00€0.37matched
19capture01a1a94b-a818-7a05-b66c-7c8c7a4a984f€15.00€0.26matched
20capture01a1a94b-dcb7-7b39-aa1a-cb2d31e7dcf1€24.00€0.37matched
21capture01a1a94b-f2d9-7971-a83a-e01199366e35€9.00€0.19matched
22refund01a1a94c-1579-7032-9592-81c4c2e77cdd-€17.00€0.00matched
23refund01a1a94c-1790-7fc5-8749-f6ecd89db4c1-€10.00€0.00matched
24refund01a1a94c-4fab-7edb-9f9d-ed194fd60e88-€9.00€0.00matched
25capture01a1a94c-5039-7aae-b0d7-040824a5c22f€49.00€0.67matched
26capture01a1a94c-65bb-7a3c-b075-08307b19c1cb€9.00€0.19matched
27capture01a1a94c-a994-759f-a0c5-ad1a9c549642€24.00€0.37matched
28capture01a1a94c-e6ca-7f7d-8cd8-2b989077ee81€9.00€0.19matched
29capture01a1a94d-0b7f-7f77-941b-92755d29fe3a€9.00€0.19matched
30capture01a1a94d-1cb9-7600-8ed1-8dac2c720254€15.00€0.26matched
31capture01a1a94d-2950-73b1-950e-612869b37b20€9.00€0.19matched
32capture01a1a94d-35d4-7104-a1fb-cea98ea7647b€15.00€0.26matched
33capture01a1a94d-3c57-7a91-aa8d-9ee388473374€24.00€0.37matched
34capture01a1a94d-4d9c-70cb-91f6-6d758b62cc03€35.00€0.50matched
35capture01a1a94d-4fdd-78bf-a9b8-946cf74c142c€49.00€0.67matched
36capture01a1a94d-686b-7aa5-bd30-07168ee43ea5€35.00€0.50matched
37capture01a1a94d-8509-7036-acec-9374c150690e€49.00€0.67matched
38capture01a1a94d-9312-71df-a7fe-39909e7347b8€9.00€0.19matched
39capture01a1a94d-9983-7252-b0c2-ec91a6c53694€9.00€0.19matched
40capture01a1a94d-be73-767b-a1fa-47e5a957b3c5€15.00€0.26matched
41capture01a1a94d-f80d-790c-b89a-fe651f45b4c3€35.00€0.50matched
42capture01a1a94d-f904-70c4-bb74-6e27ab3905e9€35.00€0.50matched
43capture01a1a94d-fccc-7431-98ed-68b393988a82€9.00€0.19matched
44capture01a1a94e-1a61-7f40-9093-30d0c9a762ee€49.00€0.67matched
46refund01a1a94e-213f-70d4-8c10-793c8b6842cd-€34.00€0.00matched
47capture01a1a94e-35d4-795d-905c-e536fec4a925€35.00€0.50matched
48capture01a1a94e-4999-7713-a64a-39b004bf6ce3€49.00€0.67matched
49capture01a1a94e-52be-7822-b81e-e285ed449b73€35.00€0.50matched
50capture01a1a94e-5877-77b4-be31-192d5806e3ba€49.00€0.67matched
51capture01a1a94e-5ce4-7858-bf5e-8491fb8ba1b5€49.00€0.67matched
52capture01a1a94e-6033-7858-a345-3a636f34ad4e€49.00€0.67matched
53capture01a1a94e-6360-77d4-86e9-3f0a2dbf03b8€15.00€0.26matched
54capture01a1a94e-68fe-7581-868d-46b5253fa481€49.00€0.67matched
55capture01a1a94e-73eb-7505-a2f8-f5d24645fb82€49.00€0.67matched
56capture01a1a94e-7510-7edd-a3b8-750053466f06€24.00€0.37matched
57capture01a1a94e-7c85-727f-a0f2-4b62ae0d1040€9.00€0.19matched
58refund01a1a94e-8732-711e-ba80-83673dd1616c-€12.00€0.00matched
59capture01a1a94e-8ba4-7d37-bbb4-b1cd6d0927d7€15.00€0.26matched
60refund01a1a94e-9bb3-7900-a128-5599f8c9da1d-€35.00€0.00matched
61capture01a1a94e-aee8-75d9-800e-aea3b6d18102€9.00€0.19matched
62capture01a1a94e-c9e6-7a11-814f-11490cf8086a€15.00€0.26matched
63capture01a1a94e-f6e2-7b6a-a44a-a373cb2fc9e5€15.00€0.26matched
64capture01a1a94f-27a7-75ba-9e62-37f21dccb580€9.00€0.19matched
65capture01a1a94f-4272-7f4f-a882-cc2f2d788d59€9.00€0.19matched
66capture01a1a94f-774b-77db-9625-5433288da999€35.00€0.50matched
67capture01a1a94f-88b8-708d-bc11-b1bd973ebb32€15.00€0.26matched
69refund01a1a94f-89ea-7ea8-ac7d-afabb0b6a6fd-€3.00€0.00matched
70capture01a1a94f-a4e7-722d-bcf4-a9b30c8cd123€9.00€0.19matched
71capture01a1a94f-bc92-7641-9b72-63a23515cae1€35.00€0.50matched
72capture01a1a94f-c828-7db9-a5f1-9e2da3ce4f2a€24.00€0.37matched
73capture01a1a94f-e35c-7f06-a506-1495b505cda3€24.00€0.37matched
74capture01a1a94f-f86e-7860-9a8c-103fb317dbde€9.00€0.19matched
75capture01a1a950-0e59-7079-bcd7-b97975613335€24.00€0.37matched
76capture01a1a950-110e-7dbb-8cb8-c351fec2ccfa€15.00€0.26matched
77capture01a1a950-215d-7446-92fb-4ccacadcb8fe€35.00€0.50matched
78capture01a1a950-27e8-7d3e-a317-fd0851cc4512€35.00€0.50matched
79refund01a1a950-2cba-737f-b97b-5d007caa3bbf-€8.00€0.00matched
80capture01a1a950-3f78-74ee-a5e9-4444157fbfd2€24.00€0.37matched
81refund01a1a950-4081-7cfb-b1dc-4973904861ec-€11.00€0.00matched
82capture01a1a950-6b8d-7f6b-ac1a-f804ee05ceed€49.00€0.67matched
83refund01a1a950-7372-7ceb-a173-ffe3ae9a50f7-€18.00€0.00matched
84capture01a1a950-951a-7aae-b07c-f04900a6858f€35.00€0.50matched
85capture01a1a950-99ec-737b-b494-69a37b2f0b98€15.00€0.26matched
86capture01a1a950-bcb6-76ae-913e-b7c60a91e307€15.00€0.26matched
87capture01a1a950-c87d-7485-9bb8-05890cc010e2€24.00€0.37matched
88capture01a1a950-e9c1-773a-b098-df54d86cfb4a€49.00€0.67matched
89capture01a1a950-eb3f-79b8-9a40-979e805290ed€24.00€0.37matched
90capture01a1a951-0655-7948-9902-93ead71a9186€24.00€0.37matched
91capture01a1a951-08ed-7c9f-adec-9040b13fb952€15.00€0.26matched
92capture01a1a951-1297-75bd-ad02-85b59cde9ad6€35.00€0.50matched
93capture01a1a951-26fc-7ddb-8506-49855698862f€9.00€0.19matched
94capture01a1a951-2c51-73d3-a5f3-9f2afc745401€9.00€0.19matched
95capture01a1a951-32a1-7ceb-be93-6cd040887db8€49.00€0.67matched
96capture01a1a951-32cc-722f-8d86-c225a5bf8939€24.00€0.37matched
97capture01a1a951-3f3f-7f15-b43f-c1862b5a279f€15.00€0.26matched
98capture01a1a951-4325-704e-b208-a2bfff039ff7€35.00€0.50matched
99capture01a1a951-7ebc-7d34-b92e-4a50633a2f9e€24.00€0.37matched
100capture01a1a951-86b0-7dfd-9102-8051540cb7b4€9.00€0.19matched
101capture01a1a951-8d08-75f5-95fc-b21ae88672f0€35.00€0.50matched
102capture01a1a951-9bdf-7c06-8894-ac65739d43a2€24.00€0.37matched
103capture01a1a951-a2a4-7460-9001-d88b015a2771€49.00€0.67matched
104capture01a1a951-cf61-7233-b918-39144e0743a5€49.00€0.67matched
105capture01a1a951-f985-7e69-ad04-2afcc6229ea3€15.00€0.26matched
106capture01a1a952-1f47-7eb5-8861-163a361d124e€15.00€0.26matched
107capture01a1a952-2e91-7353-b888-d561689aa2f6€9.00€0.19matched
108capture01a1a952-4473-7f44-9638-2ace2bfc5b18€9.00€0.19matched
109capture01a1a952-4de9-7702-b21b-8c237a2dfd18€24.00€0.37matched
110capture01a1a952-573f-776c-ab5c-d3e62bb78466€9.00€0.19matched
111capture01a1a952-a2a6-7685-a40d-b3696707d8bf€15.00€0.26matched
112capture01a1a952-a3f4-77c9-8016-ce37a792bff1€35.00€0.50matched
113capture01a1a952-a60d-7fb2-88ad-0e3e6f546949€49.00€0.67matched
114refund01a1a952-bd10-7529-b204-a5948653b2a5-€4.00€0.00matched
115capture01a1a952-bd9e-79ea-a70a-cd8ffb033771€9.00€0.19matched
116capture01a1a952-c4de-708d-9850-e9b574ad69a0€15.00€0.26matched
117capture01a1a952-e7c4-72af-925e-1dbde9d75e4e€35.00€0.50matched
118capture01a1a952-f2c0-7cf2-b8bf-cb3f75de6403€15.00€0.26matched
119capture01a1a952-fb78-7bfa-b8bf-108d412eea21€35.00€0.50matched
120capture01a1a953-09eb-74c7-94fe-9e2acd413b78€49.00€0.67matched
121capture01a1a953-33d2-7b4e-a428-c97faea87ce0€15.00€0.26matched
122capture01a1a953-50c5-78a7-bbb6-955e1347234d€24.00€0.37matched
123refund01a1a953-605b-7f1e-904e-a15248238e23-€46.00€0.00matched
124capture01a1a953-a166-788e-b445-02f9580de95e€49.00€0.67matched
125capture01a1a953-ae92-7b78-b28f-f08bdc709ac5€9.00€0.19matched