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, 22:50

Gross

€2,863.00

PSP fee

€44.84

Net to the bank

€2,818.16

Settlement journal

#405512

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ade9-b3b5-7280-843e-cef932f4e612 is already settled by stl_EUR_2989865 line 30
  • duplicate linethe file lists it twicerefund:01a1adee-1148-70f8-ab08-3c5bb548eecb is already settled by stl_EUR_2989865 line 82
  • duplicate linethe file lists it twicecapture:01a1adef-0d24-7042-b62b-737c6a57846b is already settled by stl_EUR_2989865 line 98
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • missing linein the books, not in the filecapture:01a1adea-1393-7ee0-bdb3-60fe951f6f0c is in no file
  • missing linein the books, not in the filerefund:01a1adee-03ed-7fd2-8544-4dde5bdad4a8 is in no file
LineKindReferenceGrossFeeStatus
2capture01a1ade1-57a6-7189-8c1b-f32e77bcf708€24.00€0.37duplicate line
6capture01a1ade7-03a0-7262-b724-74da14e26a4d€24.00€0.37duplicate line
23capture01a1ade8-92f6-760f-a0cd-d4f5c2cea54e€35.00€0.55fee difference
31capture01a1ade9-b3d9-749a-abbc-f071447e0386€24.00€0.37duplicate line
83refund01a1adee-1152-784e-a64b-1bdc7fc06cb3-€13.00€0.00duplicate line
99capture01a1adef-0d37-78bf-b011-b7f3c35d894b€49.00€0.67duplicate line
1capture01a1ade1-57a6-7189-8c1b-f32e77bcf708€24.00€0.37matched
3capture01a1ade4-bcbe-749a-bd29-737f11d18367€9.00€0.19matched
4capture01a1ade5-7b23-7f54-bb80-dcf3f6edd94d€35.00€0.50matched
5capture01a1ade7-03a0-7262-b724-74da14e26a4d€24.00€0.37matched
7capture01a1ade7-bf37-7f63-b39c-bf0de90c0fe3€15.00€0.26matched
8capture01a1ade7-cb68-7024-a2fc-f7b12462c331€24.00€0.37matched
9capture01a1ade7-cf39-73a5-bfaa-c12a5e0194af€35.00€0.50matched
10capture01a1ade7-dbb6-7be7-a7b1-7884dc9735b8€9.00€0.19matched
11capture01a1ade7-e8d5-73ff-bf78-a20b4d28a1c0€15.00€0.26matched
12capture01a1ade7-ea01-79d7-b348-6688ecf152f6€24.00€0.37matched
13capture01a1ade8-075b-75c8-88dc-f39492fdcab2€49.00€0.67matched
14capture01a1ade8-08db-75ac-8951-93060ca9020c€9.00€0.19matched
15capture01a1ade8-1e08-7b7e-968d-e4b418c412f2€24.00€0.37matched
16capture01a1ade8-21ec-72cf-a084-6bd36c180e93€9.00€0.19matched
17capture01a1ade8-2475-7cab-8ee5-d351559f60e5€15.00€0.26matched
18capture01a1ade8-2f86-785b-bf00-82249ffbfa1a€24.00€0.37matched
19capture01a1ade8-3939-734d-9f3d-4c90ce7d1124€35.00€0.50matched
20refund01a1ade8-6788-7c91-ba8c-15dc8008f8a7-€9.00€0.00matched
21capture01a1ade8-7392-7f15-8e45-49fbe32c6e29€24.00€0.37matched
22capture01a1ade8-797b-730c-ae9d-cf67c7fc820b€24.00€0.37matched
24capture01a1ade8-9394-7850-a34a-e4fc6cd4767a€9.00€0.19matched
25capture01a1ade9-0b0e-7564-b619-47c5dc0e359e€49.00€0.67matched
26capture01a1ade9-2a05-7d1a-8aa1-81c2a27b880e€35.00€0.50matched
27capture01a1ade9-393a-7fc6-a82e-ca644bb77439€9.00€0.19matched
28capture01a1ade9-5c72-70a2-9aaf-a962bcfd91db€15.00€0.26matched
29capture01a1ade9-a106-70e2-b9ee-c3a859f49d8f€9.00€0.19matched
30capture01a1ade9-b3d9-749a-abbc-f071447e0386€24.00€0.37matched
32capture01a1ade9-c183-7063-8a65-bc534c3e2291€35.00€0.50matched
33capture01a1ade9-cc3d-7254-a70c-44088eec19a6€24.00€0.37matched
34capture01a1ade9-d958-76b6-8e27-c2d3e0465210€15.00€0.26matched
35capture01a1ade9-e9e2-7792-8a93-b7f5e72da0f9€15.00€0.26matched
36capture01a1ade9-ea0f-7da2-a27f-472e707eb47a€49.00€0.67matched
37capture01a1adea-0d65-7705-9d4c-ebdda455391b€9.00€0.19matched
38capture01a1adea-5475-7cdc-9594-19c393be8355€49.00€0.67matched
39capture01a1adea-7328-7c91-a880-2ff55705b857€35.00€0.50matched
40capture01a1adea-a1cb-750e-9c16-2edddd821aea€24.00€0.37matched
41capture01a1adea-b17d-725a-811b-31b640b3ddc1€35.00€0.50matched
42capture01a1adea-c489-79eb-84b5-cb95299c336f€49.00€0.67matched
43capture01a1adea-c9d1-7794-a6ad-5a226eb96eb7€15.00€0.26matched
44capture01a1adea-d1c3-7f7a-8d35-7e006974b8b5€35.00€0.50matched
45capture01a1adea-ea23-79d8-b81e-ec2ab5520669€9.00€0.19matched
46capture01a1adeb-0171-7e10-8e3a-d22b3471a2bb€15.00€0.26matched
47capture01a1adeb-01fe-70aa-95ee-057fd0dc1bea€35.00€0.50matched
48refund01a1adeb-10a5-77ee-bdd7-44815a490cff-€7.00€0.00matched
49capture01a1adeb-695a-7c85-8977-64c44cd9e2ef€49.00€0.67matched
50capture01a1adeb-78c0-7f3e-b6a3-e4391a7d283d€9.00€0.19matched
51capture01a1adeb-7e43-7ab2-a34f-4b504ef82d49€35.00€0.50matched
52capture01a1adeb-8932-70df-bcb4-a4c2da30ea83€9.00€0.19matched
53capture01a1adeb-95ca-7547-abb6-c75622a735aa€35.00€0.50matched
54capture01a1adeb-e298-7fa2-927c-4771f64264d8€15.00€0.26matched
55capture01a1adeb-f41a-7ddb-80ee-33b88961f9c6€49.00€0.67matched
56capture01a1adeb-fa6f-7c0b-826f-1488f0d19055€24.00€0.37matched
57capture01a1adec-0c55-7d0b-bcff-0d3ab4203a09€15.00€0.26matched
58refund01a1adec-3c8e-7e46-9faf-28e3ff4a8a94-€27.00€0.00matched
59capture01a1adec-4d1b-7c86-8fdf-593f84050dcf€9.00€0.19matched
60capture01a1adec-7c19-7a70-b84d-d90a0b8fcaf9€9.00€0.19matched
61capture01a1adec-7f6e-795e-87c6-8b302696b400€24.00€0.37matched
62capture01a1adec-885b-75aa-a23b-719c74b9191c€24.00€0.37matched
63capture01a1adec-94d2-7508-acd1-25972e394c3a€35.00€0.50matched
64capture01a1adec-a498-70f9-abde-63c49fdb3ae9€9.00€0.19matched
65capture01a1adec-c634-7b96-bfbe-11fe6bb9ea65€49.00€0.67matched
66capture01a1adec-c6c4-71e7-afad-5738ed1769a4€35.00€0.50matched
67capture01a1adec-d0d8-73cf-9cd6-1cfa1a8621e4€24.00€0.37matched
68refund01a1adec-da06-7e5b-a0e6-cd91c97b0b23-€7.00€0.00matched
69capture01a1adec-d83f-7917-9bd2-1d10e18e7db3€24.00€0.37matched
70capture01a1adec-f15f-7153-a2d4-6de537c00f1b€9.00€0.19matched
71refund01a1adec-f3f0-7043-a2b6-b41877bf5042-€14.00€0.00matched
72capture01a1aded-3d37-7584-94bb-b72ecf26926d€24.00€0.37matched
73capture01a1aded-4539-7208-8068-5843147cd6f6€35.00€0.50matched
74capture01a1aded-5851-74a8-adcd-12376ef1feeb€9.00€0.19matched
75capture01a1aded-7870-7ff1-87d2-1c5b034ff95b€35.00€0.50matched
76capture01a1aded-9a21-74c3-9352-2f36268c936c€15.00€0.26matched
77refund01a1aded-a5bd-7fc2-ba9d-10d44cf994bd-€8.00€0.00matched
78capture01a1aded-c9b1-7f4b-aabc-574ac672e315€24.00€0.37matched
79capture01a1aded-d9ee-794e-b6a1-8d3bd0a52979€9.00€0.19matched
80refund01a1aded-de3d-7a24-be67-9c6ebe03839e-€10.00€0.00matched
81capture01a1aded-f180-7141-b6b1-223edbe8708b€15.00€0.26matched
82refund01a1adee-1152-784e-a64b-1bdc7fc06cb3-€13.00€0.00matched
84capture01a1adee-5833-7203-8b95-b2d8692b3563€35.00€0.50matched
85capture01a1adee-5eed-7c62-a54f-828603f5585a€9.00€0.19matched
86capture01a1adee-6a7c-792c-b562-29ba4a49a658€49.00€0.67matched
87capture01a1adee-722e-7808-981c-472bd6be0dfa€15.00€0.26matched
88capture01a1adee-837f-77df-80b7-07f4cc6674d7€49.00€0.67matched
89capture01a1adee-906d-7921-8f5d-ffdb6e3e124d€24.00€0.37matched
90capture01a1adee-919c-7443-a02d-6070239f5006€49.00€0.67matched
91capture01a1adee-a2c6-7819-9a3f-2f8a3d108b8e€9.00€0.19matched
92capture01a1adee-bd83-7a20-8f20-fb4b046fabf8€35.00€0.50matched
93capture01a1adee-cc97-7ec6-bed7-d9c88b24f005€24.00€0.37matched
94capture01a1adee-f942-7d56-9469-0e9b2b964899€24.00€0.37matched
95capture01a1adee-ff41-7c58-95ef-5c31ec6945f9€49.00€0.67matched
96capture01a1adef-0042-7741-9cf0-a15b932b8ac2€9.00€0.19matched
97capture01a1adef-026a-761e-bff3-79b1a573e6d5€24.00€0.37matched
98capture01a1adef-0d37-78bf-b011-b7f3c35d894b€49.00€0.67matched
100capture01a1adef-0f64-78e8-a425-552ccb80b7e8€9.00€0.19matched
101capture01a1adef-1633-790f-b23f-73c121a9a62e€49.00€0.67matched
102refund01a1adef-56fe-78f0-86de-fabbaeebd778-€3.00€0.00matched
103capture01a1adef-9173-71e5-8fc6-360b708452a0€49.00€0.67matched
104capture01a1adef-929a-70b8-87ee-c186d3743d3b€15.00€0.26matched
105capture01a1adef-a92d-7469-b01c-74531acedd80€15.00€0.26matched
106capture01a1adef-b1fd-7ff8-9ea7-690e304fd2ad€35.00€0.50matched
107capture01a1adef-b2db-7558-bd82-222d1157e0d9€35.00€0.50matched
108capture01a1adef-b43c-7eba-9bb1-8bd037a7c1e9€35.00€0.50matched
109capture01a1adef-b97b-7f13-85c2-ba8f32e0e0a3€24.00€0.37matched
110capture01a1adef-d212-78af-a5d1-f916be7aae17€49.00€0.67matched
111capture01a1adf0-2f65-70b8-af80-687d3c61c1f7€15.00€0.26matched
112capture01a1adf0-44a2-7ee2-9b8d-c27dc7fe8330€15.00€0.26matched
113capture01a1adf0-524b-7b18-8a74-724b000d998a€35.00€0.50matched
114capture01a1adf0-5979-76b3-aee0-3155ed7b7351€49.00€0.67matched
115capture01a1adf0-5f77-7c45-854f-5c69f6989c44€35.00€0.50matched
116capture01a1adf0-7a89-74ee-bfd4-43ee95d0c531€24.00€0.37matched
117capture01a1adf0-910d-7296-95e0-e675bec92cd2€9.00€0.19matched
118capture01a1adf0-99f6-7466-9522-0f8ab4964ec0€24.00€0.37matched
119capture01a1adf0-a995-7da3-bd66-75a7f6341516€49.00€0.67matched
120capture01a1adf0-acec-7511-9138-38cf390afdfe€49.00€0.67matched
121capture01a1adf0-b0eb-7114-b383-481b98801335€49.00€0.67matched
122capture01a1adf0-b433-7932-9410-7750a273d3f5€15.00€0.26matched