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

Gross

€2,919.00

PSP fee

€46.46

Net to the bank

€2,872.54

Settlement journal

#402077

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1acf6-5a97-7e65-b9b1-d6ca86cc5091 is already settled by stl_EUR_2989838 line 78
  • duplicate linethe file lists it twicecapture:01a1acf9-0e7c-7068-b68f-9a0c1ae609c5 is already settled by stl_EUR_2989838 line 116
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 2, the contract says 0
  • missing linein the books, not in the filecapture:01a1acf6-4067-7f24-96e9-cf0ebad585e3 is in no file
LineKindReferenceGrossFeeStatus
19capture01a1acf1-c456-7d9d-b423-b74dbccf8dec€49.00€0.68fee difference
79capture01a1acf6-5ab3-7709-92a8-0cb903f70560€15.00€0.26duplicate line
91refund01a1acf7-0895-7eda-9295-767dbff93d2a-€36.00€0.02fee difference
117capture01a1acf9-0eb4-7ff6-88e6-812d89f0b09f€49.00€0.67duplicate line
1capture01a1ace9-36c3-7a62-8a5d-fc3a8aecd72e€24.00€0.37matched
2capture01a1acea-00f4-7e92-a259-a184da2ce337€24.00€0.37matched
3capture01a1aceb-1996-7903-9649-e65b3cb4975a€49.00€0.67matched
4capture01a1aceb-2ffd-7849-8297-27900a478e47€15.00€0.26matched
5capture01a1aceb-6c06-7364-9b33-e0d34dfcfb2e€15.00€0.26matched
6capture01a1acf0-7883-7d32-882d-c23882f8788c€15.00€0.26matched
7capture01a1acf0-837c-7856-8140-d5eaf127e141€9.00€0.19matched
8capture01a1acf0-9493-73b4-bb3a-9b7168193e3d€9.00€0.19matched
9refund01a1acf0-db66-7567-858e-8d3c95e8d8f0-€7.00€0.00matched
10capture01a1acf0-e48a-78dd-9652-0e84aab9fffb€15.00€0.26matched
11capture01a1acf1-18d4-763e-a13f-b64e6dedd4bf€9.00€0.19matched
12capture01a1acf1-3e5c-73fe-ad96-5ac9cc950b4a€9.00€0.19matched
13capture01a1acf1-44ba-7760-9549-8dce0dd5e024€9.00€0.19matched
14capture01a1acf1-5708-7d0a-a377-26cd2d96febd€9.00€0.19matched
15capture01a1acf1-633c-7f15-8d9e-92a47fe86e4c€49.00€0.67matched
16capture01a1acf1-a47a-75a2-8124-74407401b4f2€49.00€0.67matched
17capture01a1acf1-b197-73df-972a-95acb9446906€35.00€0.50matched
18capture01a1acf1-a78b-7991-9b87-21c27a932be5€24.00€0.37matched
20capture01a1acf1-e133-79ec-8872-45903e9b64fd€15.00€0.26matched
21capture01a1acf1-fade-7a9b-aa0f-5d08436d83f8€49.00€0.67matched
22capture01a1acf1-fb20-744a-8caf-1c3e74856150€15.00€0.26matched
23capture01a1acf1-fcd6-752b-bb6a-b8f1832f313f€24.00€0.37matched
24capture01a1acf2-1af4-71f2-a1a9-dcdeaf41b635€49.00€0.67matched
25capture01a1acf2-39ed-7d78-bfb1-2cbbcda489f9€49.00€0.67matched
26capture01a1acf2-5705-76b4-93ac-7439b07c7de2€9.00€0.19matched
27capture01a1acf2-6a0e-7e81-afd6-2b55fdec9276€35.00€0.50matched
28capture01a1acf2-762b-7c45-ad54-aa1fab2d27e9€24.00€0.37matched
29capture01a1acf2-791b-7e13-a742-f877cfef9244€35.00€0.50matched
30capture01a1acf2-7bf0-724a-9947-8db043b2cf7b€49.00€0.67matched
31capture01a1acf2-9169-73ba-817a-6b2daf13d5c2€9.00€0.19matched
32capture01a1acf2-9766-7c51-8a0c-b64eece02e6d€35.00€0.50matched
33capture01a1acf2-994d-7059-b2ee-7c9f6cd9c709€35.00€0.50matched
34capture01a1acf2-ca92-7fcb-a637-2fcc317f5164€9.00€0.19matched
35capture01a1acf2-d19e-706c-a2da-be495bbe29a2€35.00€0.50matched
36refund01a1acf2-daed-7061-b075-b30d10a0cdad-€13.00€0.00matched
37capture01a1acf2-e1e6-76e9-ab38-9095daa25d2a€24.00€0.37matched
38capture01a1acf2-e802-7673-bce7-e4c3ac060a7f€24.00€0.37matched
39capture01a1acf2-ec63-7867-bf9b-6699ed2b21be€15.00€0.26matched
40capture01a1acf2-fa94-74e3-9b9a-08d9bcf2c642€49.00€0.67matched
41refund01a1acf2-fbcd-7087-a737-f9a2093cc03e-€7.00€0.00matched
42capture01a1acf2-ffeb-7743-9c40-357981da283c€24.00€0.37matched
43capture01a1acf3-1642-7e1a-b1b2-b9636b7bede3€49.00€0.67matched
44capture01a1acf3-1ac8-7198-8f08-101fd80709bb€35.00€0.50matched
45capture01a1acf3-2967-7480-a825-d197aa00e155€15.00€0.26matched
46capture01a1acf3-3bf0-7967-9530-3ccd31227b40€15.00€0.26matched
47capture01a1acf3-820e-7dfe-bd4f-629445d8ab87€9.00€0.19matched
48capture01a1acf3-d5bb-757c-bb1b-707819fd26e3€35.00€0.50matched
49capture01a1acf3-d86c-7554-bc03-0cfd2db48630€9.00€0.19matched
50capture01a1acf4-4469-7407-8553-5d6505820740€15.00€0.26matched
51refund01a1acf4-49d5-7df1-965f-8c482fa127f3-€3.00€0.00matched
52capture01a1acf4-53fb-7f9d-8637-3412633f5d0d€35.00€0.50matched
53capture01a1acf4-6e18-7f09-a73d-6f76282a8463€49.00€0.67matched
54capture01a1acf4-7af1-7a21-8970-355073a0d6ac€9.00€0.19matched
55capture01a1acf4-9a32-7d71-a2a8-6c424f467fe6€35.00€0.50matched
56capture01a1acf4-c69b-7685-8a63-0e6c9525fc5c€9.00€0.19matched
57capture01a1acf4-c99f-7cac-85f7-28c147bdb7bd€49.00€0.67matched
58capture01a1acf4-eaab-734a-8b42-dc6263af5d20€49.00€0.67matched
59capture01a1acf4-ecff-790a-916b-643d9a960dcb€9.00€0.19matched
60capture01a1acf4-ec97-702b-a910-4df24042d94a€9.00€0.19matched
61capture01a1acf5-2460-7de9-bfdc-e62b11b33fe9€35.00€0.50matched
62refund01a1acf5-43bd-7743-8446-9148345b44ff-€37.00€0.00matched
63capture01a1acf5-68cb-7450-84f0-67f7f1c2b385€9.00€0.19matched
64capture01a1acf5-6aac-74eb-96d8-b0fde106223a€49.00€0.67matched
65capture01a1acf5-6f35-716d-ab1f-589f1a51a5e6€49.00€0.67matched
66capture01a1acf5-7160-7e6e-af3d-d6b85b6c019a€35.00€0.50matched
67capture01a1acf5-7789-77d9-b7d2-c2d01cf76315€49.00€0.67matched
68capture01a1acf5-a9c1-79ea-865a-e358ca7ec34c€9.00€0.19matched
69capture01a1acf5-acf4-7386-bf77-9ae52039fe79€24.00€0.37matched
70capture01a1acf5-f8c6-7187-8cc4-2dd986fff011€35.00€0.50matched
71capture01a1acf5-fecb-7e63-8d7b-0370bb695077€24.00€0.37matched
72capture01a1acf5-ff9a-7231-b52d-00a6a89c263d€24.00€0.37matched
73capture01a1acf6-14e0-77ad-ac10-db2e6991c219€24.00€0.37matched
74capture01a1acf6-301c-76ba-b7bf-97bb244abc95€49.00€0.67matched
75capture01a1acf6-4399-7592-835c-e07ad63177be€15.00€0.26matched
76refund01a1acf6-4484-7ec9-a0a1-3cf0879ab96e-€18.00€0.00matched
77capture01a1acf6-4ef8-7827-a6f1-12dba4c650da€49.00€0.67matched
78capture01a1acf6-5ab3-7709-92a8-0cb903f70560€15.00€0.26matched
80capture01a1acf6-60dc-73c1-b952-f3cc428ca72b€35.00€0.50matched
81refund01a1acf6-6693-7426-a240-ce1322c1746c-€7.00€0.00matched
82capture01a1acf6-6e27-77ad-a47d-398780b47cda€15.00€0.26matched
83capture01a1acf6-77bb-7709-b878-3a7da2977dda€24.00€0.37matched
84capture01a1acf6-787e-784b-a576-a8755ec9e914€24.00€0.37matched
85refund01a1acf6-ba5c-7e18-9ba6-4b9916ae9746-€9.00€0.00matched
86capture01a1acf6-c0b5-7813-835c-15accb833b83€49.00€0.67matched
87capture01a1acf6-cad5-7958-8257-e259b309eb69€24.00€0.37matched
88capture01a1acf6-e6c9-7d09-b5f0-f7c39afaacbc€24.00€0.37matched
89capture01a1acf6-eb3a-7937-a5d1-d33940ad5fa9€15.00€0.26matched
90capture01a1acf6-fe0c-7c6b-b401-6a96eaf6f182€9.00€0.19matched
92capture01a1acf7-08f0-7bdb-bb8c-8982944f6138€15.00€0.26matched
93capture01a1acf7-1bfb-7bf1-9260-c9d22367f1e4€35.00€0.50matched
94capture01a1acf7-4c68-77c7-9c7e-24f85a060a72€15.00€0.26matched
95capture01a1acf7-4e3c-782d-952e-09ff8b08a361€15.00€0.26matched
96capture01a1acf7-4eb3-7106-893b-30e496ca31d1€49.00€0.67matched
97capture01a1acf7-4f58-7a04-acac-d6542f22e42a€15.00€0.26matched
98capture01a1acf7-5d23-71b7-b70e-742831422cf2€9.00€0.19matched
99capture01a1acf7-64c0-7f92-9328-889de4a3c00d€15.00€0.26matched
100capture01a1acf7-7642-7130-bd13-6fae5b053494€35.00€0.50matched
101capture01a1acf7-a1fd-75a2-8ffa-f0e12b8fb9d0€35.00€0.50matched
102capture01a1acf7-bf09-72d0-8722-f09e39c0a6b4€35.00€0.50matched
103capture01a1acf7-c79d-77fa-8cb8-42d2a3dc27f7€9.00€0.19matched
104capture01a1acf7-dc86-7cfc-8d5b-57e0636c6ac9€35.00€0.50matched
105capture01a1acf7-df4a-7a51-82ba-185f1d20cf57€49.00€0.67matched
106capture01a1acf7-f06d-72aa-9760-5c77087bac9f€24.00€0.37matched
107capture01a1acf8-532d-75ce-a024-7247ed0927d8€15.00€0.26matched
108capture01a1acf8-7fb0-77be-89f0-4c7fe2ad2f11€24.00€0.37matched
109capture01a1acf8-847c-7fe1-9e20-03735f704fe4€35.00€0.50matched
110capture01a1acf8-9280-7d4d-a2ce-33c035205339€49.00€0.67matched
111capture01a1acf8-b645-7743-b83b-357e51a857f2€35.00€0.50matched
112capture01a1acf8-ba13-7ffd-9e22-c4df6e1f761a€24.00€0.37matched
113capture01a1acf8-e83b-7df4-b5a2-ca5d9efff41e€15.00€0.26matched
114capture01a1acf8-f066-72d3-8922-db3969375929€49.00€0.67matched
115refund01a1acf9-0d7b-7fdf-afa9-e838bb855fce-€12.00€0.00matched
116capture01a1acf9-0eb4-7ff6-88e6-812d89f0b09f€49.00€0.67matched
118capture01a1acf9-0f3c-78c8-828f-c1823153c938€35.00€0.50matched
119refund01a1acf9-2dac-7836-998c-426c008654a2-€37.00€0.00matched
120capture01a1acf9-3bec-7357-aa67-966c5c68d2f9€15.00€0.26matched
121capture01a1acf9-43f4-772b-b71c-dc0f322c3389€24.00€0.37matched
122capture01a1acf9-48b3-7815-b1bc-375340c671b2€35.00€0.50matched
123capture01a1acf9-4fc2-7e75-92f4-a8e62d13f701€35.00€0.50matched
124capture01a1acf9-627a-7982-86e3-25e7220fd277€35.00€0.50matched