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

1 Nov, 23:00

Gross

€2,560.00

PSP fee

€41.09

Net to the bank

€2,518.91

Settlement journal

#332635

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1995e-a652-736e-9585-86de422c1562 is already settled by stl_EUR_2989290 line 91
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • missing linein the books, not in the filecapture:01a19958-f6bc-7bdf-a745-81dd12f70416 is in no file
LineKindReferenceGrossFeeStatus
66capture01a1995d-2093-7e1a-bc53-be282e543f91€35.00€0.55fee difference
92capture01a1995e-a715-72a7-81e6-28ec40536fb6€15.00€0.26duplicate line
1capture01a1994e-5646-735a-b55c-044b51e46db4€49.00€0.67matched
2capture01a1994f-acf2-7166-92ed-38acccff5cb3€15.00€0.26matched
3capture01a19951-8f97-7743-b7ef-e0b92b4ac24c€15.00€0.26matched
4capture01a19952-40cc-7f71-b8b2-2831dbbf09c4€24.00€0.37matched
5capture01a19953-aa3a-73f8-956f-3922613db40b€49.00€0.67matched
6capture01a19954-9afa-79b2-803f-454b1c3b954a€35.00€0.50matched
7capture01a19957-568f-76dd-a7e9-289f7ecd6880€15.00€0.26matched
8capture01a19957-61bb-7a5b-a032-566db74830b4€35.00€0.50matched
9capture01a19957-6f3c-77ed-bc3d-4346b54dcfa7€15.00€0.26matched
10capture01a19957-8512-7262-855a-df494140590d€15.00€0.26matched
11capture01a19957-9e6d-7632-b9ac-2c060a153078€24.00€0.37matched
12capture01a19957-aa1e-796b-b64e-64f2a0589564€15.00€0.26matched
13capture01a19957-d89e-77d3-b5ee-d103218b55e8€49.00€0.67matched
14capture01a19957-e258-7857-a442-1cf8ff3eaf99€15.00€0.26matched
15capture01a19958-0ae0-743c-88c6-f560d20abb36€24.00€0.37matched
16capture01a19958-40aa-7bb1-9f47-8c47cc83e75f€49.00€0.67matched
17capture01a19958-427a-7566-a151-a21f268740df€15.00€0.26matched
18capture01a19958-4337-7da7-905c-23be18d745d8€15.00€0.26matched
19capture01a19958-71c8-77aa-9ba6-6feb17933299€49.00€0.67matched
20refund01a19958-95c8-75f3-8b1b-61c10516cfef-€11.00€0.00matched
21capture01a19958-972a-7a87-bf85-6c2741b88c93€15.00€0.26matched
22capture01a19958-9f65-7178-8e37-d0fa19b2e089€35.00€0.50matched
23capture01a19958-f2e9-73bd-bcd4-da310971ef72€24.00€0.37matched
24capture01a19959-14c7-7519-a7db-9b8254ea4b42€49.00€0.67matched
25capture01a19959-3df1-7a75-b471-3ee2dd605b18€15.00€0.26matched
26capture01a19959-464f-72cf-aaab-4b6aa6e6fd1c€24.00€0.37matched
27capture01a19959-74c2-7c8c-9d93-7486e078b405€24.00€0.37matched
28refund01a19959-8bb5-75fc-84a7-eb2f2e8ba0c2-€6.00€0.00matched
29capture01a19959-adf7-7c15-92a5-d75d43d49194€35.00€0.50matched
30capture01a19959-b97b-70fb-839a-83c227b14a8b€15.00€0.26matched
31capture01a19959-bce7-75e7-bdf4-3cd5441452e0€15.00€0.26matched
32capture01a19959-d1b0-7cf0-8bf4-3c148ba02870€15.00€0.26matched
33refund01a19959-dc8d-7b76-a4f9-ec79efeecb71-€10.00€0.00matched
34capture01a1995a-2229-7bcd-bec2-0a3729f11606€15.00€0.26matched
35capture01a1995a-257a-78b1-b889-07dbab209342€49.00€0.67matched
36capture01a1995a-27ac-7cd5-8da7-2dc7b3e33d57€49.00€0.67matched
37capture01a1995a-29d5-722d-be95-158e2c3957cb€15.00€0.26matched
38capture01a1995a-551b-7288-9328-33c8cdf5fe49€35.00€0.50matched
39refund01a1995a-663a-78b3-b39b-6267b40e53c0-€37.00€0.00matched
40capture01a1995a-7e6a-716d-864d-18fc2b6c1b45€35.00€0.50matched
41capture01a1995a-880e-7916-b770-7bb147868f32€15.00€0.26matched
42capture01a1995a-8b1c-7713-869f-a96c32b9e50f€35.00€0.50matched
43capture01a1995a-9c26-7d17-bbf9-54c2b9937ae7€24.00€0.37matched
44capture01a1995a-bcf9-749d-986e-0f6092b87ea6€24.00€0.37matched
45capture01a1995a-d2d0-7fb6-bab8-9b012ca4ea90€49.00€0.67matched
46capture01a1995b-1416-7200-9a6c-495a6b338ef2€15.00€0.26matched
47capture01a1995b-1ccd-7a05-85e7-56315eb4624d€9.00€0.19matched
48capture01a1995b-1daa-7a11-a692-06e067ddbad6€35.00€0.50matched
49capture01a1995b-21eb-7ed6-9648-795b946442f3€9.00€0.19matched
50capture01a1995b-240d-7d61-8f89-4431e169b5e2€24.00€0.37matched
51capture01a1995b-6bd6-72af-a2e8-7b5fbbd3c8e5€9.00€0.19matched
52refund01a1995b-74ca-73db-82d9-746d7c3cc39f-€4.00€0.00matched
53capture01a1995b-8771-7688-a2ac-92f81b7f271e€15.00€0.26matched
54capture01a1995b-8952-7282-be1f-aaa9b03c4f5a€24.00€0.37matched
55capture01a1995c-40fd-70df-bcd2-5ddecc765e03€9.00€0.19matched
56capture01a1995c-62c0-7686-b665-8bd04a5e2973€9.00€0.19matched
57capture01a1995c-8455-7a63-8e3f-6c9aafa37064€49.00€0.67matched
58capture01a1995c-a0aa-7c70-976d-83f72f6661d2€35.00€0.50matched
59capture01a1995c-bb14-7fea-8ce5-239294d5ca75€49.00€0.67matched
60capture01a1995c-cca0-7e84-9421-264ef3919e87€35.00€0.50matched
61capture01a1995c-efa1-72ef-9afc-f82bc45a9668€9.00€0.19matched
62refund01a1995c-f191-74a8-814f-bcd6a86ca386-€43.00€0.00matched
63capture01a1995d-002a-7da5-abf7-f24bba650321€49.00€0.67matched
64capture01a1995d-0403-7da0-967f-9105e40b6c34€49.00€0.67matched
65capture01a1995d-0482-7df7-acb1-563e58951ec9€49.00€0.67matched
67capture01a1995d-3049-7518-9797-08ae0290a055€49.00€0.67matched
68capture01a1995d-3fc2-7060-89a4-e030a00287d2€35.00€0.50matched
69capture01a1995d-482a-76f9-b902-80a3cb2595dd€24.00€0.37matched
70capture01a1995d-5770-7577-ae7f-6674812801c7€49.00€0.67matched
71capture01a1995d-5d69-713a-bef0-33c9936f9256€15.00€0.26matched
72capture01a1995d-a1c6-7298-8d04-946627f38c45€24.00€0.37matched
73capture01a1995d-a203-7bbc-88e0-8fc9bf6fb0e2€24.00€0.37matched
74capture01a1995d-a36f-72d5-845e-05baa7439618€9.00€0.19matched
75capture01a1995d-a6f3-7b6b-92ad-002ecb7bec9b€15.00€0.26matched
76refund01a1995d-b328-7668-8514-1fe188d079ac-€11.00€0.00matched
77capture01a1995d-b66c-7056-9aa9-067a182a043f€24.00€0.37matched
78capture01a1995d-e20b-7c7c-873a-db1b47f4ac88€9.00€0.19matched
79capture01a1995d-f92f-706f-86a1-62327604fbe1€24.00€0.37matched
80capture01a1995d-fd8c-79c9-952f-e1e8cb00b4f6€24.00€0.37matched
81capture01a1995e-0d22-7d00-98a4-9cfb0f47b6ed€24.00€0.37matched
82capture01a1995e-1360-7a3c-b294-5406c2bc7e4a€15.00€0.26matched
83capture01a1995e-15fe-7279-b6e5-b04fdaee3fd8€24.00€0.37matched
84capture01a1995e-1b1a-7292-a137-e0cb9bd02fcb€9.00€0.19matched
85capture01a1995e-273a-7930-ad04-b3e2efa3863c€49.00€0.67matched
86capture01a1995e-2ea5-7964-9ac5-3bef45171206€49.00€0.67matched
87capture01a1995e-6168-751c-8b44-a0bda3664c46€9.00€0.19matched
88capture01a1995e-75d1-7a91-a2ef-73aad82121cf€15.00€0.26matched
89capture01a1995e-8a70-72e1-b11e-061db740943a€49.00€0.67matched
90capture01a1995e-97f8-71e8-b233-6e0418895848€35.00€0.50matched
91capture01a1995e-a715-72a7-81e6-28ec40536fb6€15.00€0.26matched
93capture01a1995e-ad04-7a3e-8079-1ae9a0fbb837€15.00€0.26matched
94capture01a1995e-af67-77ee-b094-e54ecaa47bd8€9.00€0.19matched
95capture01a1995f-0e90-792f-9978-dc92d6246784€24.00€0.37matched
96capture01a1995f-1c4a-79f0-8a74-d9426d53372d€24.00€0.37matched
97capture01a1995f-4358-7b7d-aa86-15e594bb7a38€24.00€0.37matched
98capture01a1995f-4a88-7f52-9416-3be439d3cf8a€15.00€0.26matched
99capture01a1995f-4cda-767e-a9f9-7e369533d900€24.00€0.37matched
100capture01a1995f-5d21-72fb-92aa-d0054973da11€24.00€0.37matched
101capture01a1995f-65a8-7061-b42f-e42dc20c9819€49.00€0.67matched
102capture01a1995f-66ec-7836-9915-6aae5bc75cc2€24.00€0.37matched
103refund01a1995f-7f4f-7f47-898f-884acfab4d55-€18.00€0.00matched
104capture01a1995f-b657-7df0-b6b1-8077c9a9bac1€15.00€0.26matched
105capture01a1995f-ca6e-7426-b8e1-4a2d093d2569€9.00€0.19matched
106capture01a1995f-d87f-77ce-9078-f4eedf3291fa€35.00€0.50matched
107capture01a19960-01ba-74f7-a540-48d66611f1bd€15.00€0.26matched
108capture01a19960-067f-7457-b14d-abfb6e5a07a4€49.00€0.67matched
109capture01a19960-11bd-7a43-85da-88d5ce38c221€15.00€0.26matched
110capture01a19960-247a-7197-8b77-864d2a61c8c1€15.00€0.26matched
111capture01a19960-3e53-767c-a305-ffd1f8c5ea99€9.00€0.19matched
112capture01a19960-3eaf-764d-8b78-f05a5b7ebc2f€24.00€0.37matched
113refund01a19960-4455-7364-974f-841ba77b14c2-€4.00€0.00matched
114refund01a19960-48a4-76d2-ab1d-eddfc6a563a9-€6.00€0.00matched
115capture01a19960-6239-7b90-a475-5635ab844651€9.00€0.19matched