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, 02:00

Gross

€2,953.00

PSP fee

€46.05

Net to the bank

€2,906.95

Settlement journal

#389693

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a977-511d-706a-999c-35576565af6e is already settled by stl_EUR_2989740 line 98
  • fee differencethe fee is not the contract feethe fee is 69, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 1, the contract says 0
  • missing linein the books, not in the filecapture:01a1a975-2117-7a58-a0f3-ecd7508ef0cb is in no file
LineKindReferenceGrossFeeStatus
65capture01a1a975-3da5-7164-930b-001cc0186915€49.00€0.69fee difference
69capture01a1a975-92b2-7750-9d74-f118d4fd5a54€24.00€0.39fee difference
98capture01a1a977-5134-778e-a318-ba9333fcdbb0€9.00€0.21fee difference
99capture01a1a977-5134-778e-a318-ba9333fcdbb0€9.00€0.21duplicate line
116refund01a1a977-f257-7373-8df9-3229a0d5e61b-€9.00€0.01fee difference
1capture01a1a96f-596d-7ccb-b0bd-46d9b62b09f6€15.00€0.26matched
2capture01a1a96f-8c35-7f52-836d-b1e9c1f14c9f€24.00€0.37matched
3capture01a1a96f-a338-77d2-a0d3-b7888b91e0ae€35.00€0.50matched
4capture01a1a970-281c-730f-935f-3ce07f9727a4€49.00€0.67matched
5capture01a1a970-293d-7732-8453-6df04ccd6159€49.00€0.67matched
6capture01a1a970-30ca-728f-b618-df29123dc451€15.00€0.26matched
7capture01a1a970-5e93-7851-81ad-4c811346b7e3€24.00€0.37matched
8capture01a1a970-680e-7105-b220-92eee5687c86€49.00€0.67matched
9capture01a1a970-83b3-760a-a177-7adf97d010d6€15.00€0.26matched
10capture01a1a970-9b3d-7bf9-8a20-8cb3a795f515€9.00€0.19matched
11capture01a1a970-aef5-797f-baea-ba34ab12458d€49.00€0.67matched
12capture01a1a970-c089-7072-aee0-736b76b0f065€15.00€0.26matched
13capture01a1a970-eb81-72de-abef-0e1b94ff0d1b€9.00€0.19matched
14capture01a1a970-f7cb-7d49-b21b-9326bc75edd6€35.00€0.50matched
15capture01a1a971-20d0-79c4-875a-a703ad836ec3€15.00€0.26matched
16capture01a1a971-4be7-726d-8a19-5414df484930€9.00€0.19matched
17capture01a1a971-55b3-7b84-8c0d-961718a8c629€15.00€0.26matched
18capture01a1a971-592a-794d-aada-dd36f2c76c5d€49.00€0.67matched
19capture01a1a971-bfff-734c-aab9-519db6b1025b€35.00€0.50matched
20capture01a1a971-d403-7f7b-835c-268a88b04f58€49.00€0.67matched
21capture01a1a972-08b3-754f-8eaf-25e13fc91185€15.00€0.26matched
22capture01a1a972-118b-76b3-bda4-36c605ae5034€15.00€0.26matched
23capture01a1a972-1d5e-7175-b41c-65fca049de17€15.00€0.26matched
24capture01a1a972-3974-781d-a853-81601f40fa3d€24.00€0.37matched
25capture01a1a972-8902-7d2d-a215-a399ab8feb4c€35.00€0.50matched
26capture01a1a972-8e8e-73ca-9989-7e469325f84a€35.00€0.50matched
27capture01a1a972-b20c-7c73-9f9b-cfa1d3d6d614€9.00€0.19matched
28capture01a1a972-b523-70ce-a4a9-704abd21a585€24.00€0.37matched
29capture01a1a972-c4df-7df4-8894-238c2f24092a€49.00€0.67matched
30capture01a1a972-e704-784f-b904-0bcc3920c301€9.00€0.19matched
31capture01a1a973-1f93-7b4c-aa8b-030ab04302fe€15.00€0.26matched
32capture01a1a973-30f3-7a82-9aae-dcb6aa5b2ef0€15.00€0.26matched
33capture01a1a973-38ec-7f0e-a9cf-2ebe9b93d0ec€9.00€0.19matched
34capture01a1a973-3f31-7fdf-b8dd-e5e5c071b0a8€24.00€0.37matched
35capture01a1a973-5540-7957-b10d-0f4d4e6f8b69€49.00€0.67matched
36capture01a1a973-6410-7532-9360-8225def07546€24.00€0.37matched
37capture01a1a973-7b67-7eaa-881d-61d097e52133€24.00€0.37matched
38capture01a1a973-8f91-72a0-92b0-216fdff28509€49.00€0.67matched
39capture01a1a973-9125-7761-abb9-f668324a718e€24.00€0.37matched
40capture01a1a973-9629-725b-80cf-75b3aa2ffd1a€49.00€0.67matched
41capture01a1a973-9a83-7d17-a82d-8938d0f9d0a6€9.00€0.19matched
42refund01a1a973-b072-773e-810e-758f7f6e424a-€18.00€0.00matched
43capture01a1a973-f647-7dff-83f9-b3ee559b5e63€15.00€0.26matched
44capture01a1a974-135a-7518-8dc0-93d72c45102a€9.00€0.19matched
45capture01a1a974-25fa-7eb5-8070-46596147ac6d€35.00€0.50matched
46capture01a1a974-2922-7a1b-9a9b-f741f7ef52fd€49.00€0.67matched
47capture01a1a974-445d-7d86-8435-d44c7fb39c3f€9.00€0.19matched
48capture01a1a974-63be-787c-82c0-c66c7aa846c8€9.00€0.19matched
49capture01a1a974-6ef6-7d47-a58d-6018a795ea10€15.00€0.26matched
50capture01a1a974-729e-7826-bf07-9e4ea60c1403€9.00€0.19matched
51capture01a1a974-801e-7f8f-83be-c9f143f32b07€49.00€0.67matched
52capture01a1a974-97a1-7486-b64c-b5958aa6aa23€15.00€0.26matched
53capture01a1a974-a244-7267-891b-6d485f57355c€24.00€0.37matched
54capture01a1a974-ab6b-7d61-9408-842426e18947€15.00€0.26matched
55capture01a1a974-ac93-7d43-9d58-b8c6d6dad3ab€24.00€0.37matched
56capture01a1a974-c531-7056-9934-cb7aa7321774€24.00€0.37matched
57capture01a1a974-ec7a-7924-aa95-5897cedd84f8€9.00€0.19matched
58capture01a1a974-f396-7447-bf8e-f8ed86f60331€35.00€0.50matched
59capture01a1a974-f3cf-7765-81ed-8d04874e5a99€35.00€0.50matched
60capture01a1a974-f58b-7ab9-8d71-61b2df566897€49.00€0.67matched
61capture01a1a975-203e-7f62-bc87-9a0c6775ca99€15.00€0.26matched
62capture01a1a975-2214-719e-8ece-942c31c33ba5€9.00€0.19matched
63refund01a1a975-2d2e-7105-8d42-ea59a9bde7dc-€15.00€0.00matched
64capture01a1a975-3da4-7d41-9a9e-7dfd633d6231€49.00€0.67matched
66capture01a1a975-438f-7678-b3e1-5a80d2712e3a€15.00€0.26matched
67capture01a1a975-681c-7563-bfa7-4cd5356cdcd2€9.00€0.19matched
68capture01a1a975-6f42-7391-9188-5d9acbe68083€49.00€0.67matched
70capture01a1a975-a1e3-7a05-9058-3787f6bac2c1€35.00€0.50matched
71capture01a1a975-ce93-7888-b6d3-89175c0a834d€24.00€0.37matched
72capture01a1a976-031f-7ff1-825c-37fdff61ff88€24.00€0.37matched
73capture01a1a976-07ce-7d38-a2c2-ba1a24898656€24.00€0.37matched
74capture01a1a976-12be-7efa-9ea3-eec3e00f193b€35.00€0.50matched
75capture01a1a976-1d88-7fbf-87c0-35304c067b2a€9.00€0.19matched
76capture01a1a976-2d9e-7eeb-8dcd-1cf32e39f2d6€15.00€0.26matched
77capture01a1a976-3b1d-72ce-84cc-854de39da9f8€49.00€0.67matched
78capture01a1a976-5002-7911-8c4a-f858eb77aee2€9.00€0.19matched
79capture01a1a976-68f2-73aa-bf25-588082ef8d0a€15.00€0.26matched
80capture01a1a976-77eb-7f55-9fbb-9ade419ec10b€15.00€0.26matched
81refund01a1a976-8433-7e60-9d2b-dc428391492d-€10.00€0.00matched
82capture01a1a976-859e-7973-9c29-afb74e915e56€35.00€0.50matched
83capture01a1a976-9124-7f3f-a334-b0427f3e314c€24.00€0.37matched
84capture01a1a976-9932-7687-920e-b42e28612381€35.00€0.50matched
85capture01a1a976-a16a-7fc2-9b25-530716757a86€24.00€0.37matched
86capture01a1a976-a4c8-7702-a5ad-d5b270353c8d€35.00€0.50matched
87capture01a1a976-a7cd-754a-b46e-b3980ada681f€49.00€0.67matched
88capture01a1a976-b3d1-78b8-89d3-ca2a665f41e1€15.00€0.26matched
89capture01a1a976-ba79-7cb5-9e25-c5744c323f56€35.00€0.50matched
90capture01a1a976-cb99-7168-a034-d05de06c8ac0€49.00€0.67matched
91capture01a1a976-e882-7465-a5f0-39be925a3af8€24.00€0.37matched
92capture01a1a976-f448-722d-b0cf-f7f7139d8ecb€35.00€0.50matched
93capture01a1a977-1013-7306-9bb8-eab1ad041a2b€9.00€0.19matched
94capture01a1a977-11f9-7eb5-808f-d8b6674cb5b8€49.00€0.67matched
95capture01a1a977-1c2b-7089-b75f-25d857d2b24d€9.00€0.19matched
96capture01a1a977-261c-726d-8e28-931fcb79bf3f€24.00€0.37matched
97capture01a1a977-2893-70e5-8bbd-f6bba6d87f4d€15.00€0.26matched
100capture01a1a977-4f0c-779a-bbe9-14990d583a8c€15.00€0.26matched
101capture01a1a977-5246-7939-a89c-26123dec989c€49.00€0.67matched
102capture01a1a977-5d5e-74ef-adfe-b7ca8072c6f2€15.00€0.26matched
103capture01a1a977-6ed7-79f2-88b8-62becedb1225€35.00€0.50matched
104capture01a1a977-81d1-73d9-b6f5-a9aa69739e6e€15.00€0.26matched
105capture01a1a977-82cb-7d63-b699-a73b2fd89934€9.00€0.19matched
106refund01a1a977-87d4-77bf-8df6-f05df7ad233c-€3.00€0.00matched
107capture01a1a977-98cf-711d-9982-6090da6cd922€15.00€0.26matched
108capture01a1a977-a53d-7f7a-8782-1612aa46ca5f€35.00€0.50matched
109capture01a1a977-ab09-789a-aba6-e7d222eb6f4f€35.00€0.50matched
110capture01a1a977-b3f4-7d2a-a9ca-d383163d42dd€15.00€0.26matched
111capture01a1a977-b6f7-7f9c-af02-32964286ba7e€49.00€0.67matched
112capture01a1a977-b8b9-765c-b4d9-237880cb2fc0€24.00€0.37matched
113refund01a1a977-b9a9-746e-9e04-337d13cadbb3-€2.00€0.00matched
114refund01a1a977-dfe8-7428-ac85-5c48d1162bc2-€9.00€0.00matched
115capture01a1a977-f1a7-7278-9f94-31438dddb8a4€15.00€0.26matched
117capture01a1a977-f424-76b0-a4c4-81d45ff5bc47€35.00€0.50matched
118capture01a1a978-0eb3-79cc-9e50-a1c1efbd41ed€24.00€0.37matched
119capture01a1a978-20bb-73a8-8e67-20c94d5c629f€9.00€0.19matched
120capture01a1a978-20c7-7a27-911d-5fb4d492750e€15.00€0.26matched
121capture01a1a978-25d7-7fd1-876d-d6f978df7666€15.00€0.26matched
122capture01a1a978-2923-7f43-ade0-f00671db25e9€15.00€0.26matched
123capture01a1a978-2fd6-7463-95de-4b8a285da346€9.00€0.19matched
124capture01a1a978-3f79-737b-861c-2b3d91534408€15.00€0.26matched
125capture01a1a978-47a3-7de6-a158-3fbf1ae9b5db€35.00€0.50matched
126capture01a1a978-4a1a-766b-971f-fced09386806€35.00€0.50matched
127capture01a1a978-4ecb-7e30-84db-04b2d520eeec€15.00€0.26matched