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

4 Nov, 23:40

Gross

€2,887.00

PSP fee

€45.55

Net to the bank

€2,841.45

Settlement journal

#387873

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a8f6-c183-7645-a743-f8652aa61ad8 is already settled by stl_EUR_2989726 line 102
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 2, the contract says 0
  • missing linein the books, not in the filecapture:01a1a8f2-a40b-7942-b079-c0940e793aef is in no file
LineKindReferenceGrossFeeStatus
25capture01a1a8f0-7407-7140-85c4-7fba9b79c99f€9.00€0.24fee difference
103capture01a1a8f6-c19e-7c19-9975-38c68b8b2a00€9.00€0.19duplicate line
109capture01a1a8f6-f4ed-7f5c-b919-d7334b7a3886€35.00€0.52fee difference
110refund01a1a8f7-1145-74cf-b2c9-04071c9e1a96-€21.00€0.02fee difference
1capture01a1a8eb-d7a8-73f7-8eea-7442ddbc38ec€15.00€0.26matched
2capture01a1a8ee-23b6-7655-8391-f62001d6198b€24.00€0.37matched
3capture01a1a8ef-3811-7813-9ce0-1f8122f3fdb4€35.00€0.50matched
4capture01a1a8ef-4163-7f02-a0d0-10e42c792638€24.00€0.37matched
5capture01a1a8ef-54ad-7626-bc92-8de7d65af88d€35.00€0.50matched
6capture01a1a8ef-6ca1-7cac-86ba-d319799f8731€49.00€0.67matched
7capture01a1a8ef-6e9e-71d1-b51e-3c1c0baeaa59€24.00€0.37matched
8capture01a1a8ef-76ce-7bab-9dc7-fe4d36708e3d€49.00€0.67matched
9capture01a1a8ef-789b-7800-a635-fb21cadb9918€24.00€0.37matched
10capture01a1a8ef-799e-77dd-8a1d-ccc164da9f4b€15.00€0.26matched
11refund01a1a8ef-9c21-70f3-b5c8-2d0c68e6166b-€49.00€0.00matched
12refund01a1a8ef-b62b-7798-b329-cf6c154b3ed2-€12.00€0.00matched
13capture01a1a8ef-c5d2-72a1-809c-2b83b3751f49€15.00€0.26matched
14refund01a1a8ef-cbd6-7f7c-a510-93ac2f028f2f-€4.00€0.00matched
15capture01a1a8ef-d4e9-75cc-80ab-bb309637ba6e€24.00€0.37matched
16capture01a1a8ef-ea93-75d5-8b05-4ef1b5f2e7ee€49.00€0.67matched
17capture01a1a8ef-ee9f-71d9-83e1-1041d84f76cf€35.00€0.50matched
18capture01a1a8f0-221b-739f-988a-dcf498462dd7€9.00€0.19matched
19capture01a1a8f0-34d1-721e-94d8-aa843dcea312€24.00€0.37matched
20capture01a1a8f0-445b-7a82-8b6c-013b925e62c7€35.00€0.50matched
21capture01a1a8f0-465d-79ad-a525-2a2deebe1e5b€9.00€0.19matched
22capture01a1a8f0-58b5-7f0b-bf05-1ccc1a48e220€9.00€0.19matched
23capture01a1a8f0-6255-7106-9acf-4cff0d8b5c95€24.00€0.37matched
24capture01a1a8f0-6cd2-757a-9d0d-57c88941ff12€35.00€0.50matched
26capture01a1a8f0-8753-7741-88f3-d7a7515dc578€35.00€0.50matched
27capture01a1a8f0-a382-7083-a43b-eec59ad50779€35.00€0.50matched
28capture01a1a8f0-bc05-7abb-a12e-fe62711c849b€9.00€0.19matched
29capture01a1a8f0-df23-7548-96a7-5107763c2ac9€9.00€0.19matched
30capture01a1a8f0-e3f5-7e37-8793-d6256d325503€49.00€0.67matched
31capture01a1a8f0-fa64-72b2-9232-fa92a72b74ea€49.00€0.67matched
32capture01a1a8f1-068b-776d-b8bb-11cb2d010a96€15.00€0.26matched
33capture01a1a8f1-7d97-79c1-a7b9-f00ba39c0e9e€24.00€0.37matched
34capture01a1a8f1-8433-7a0c-9527-f19e551c1082€35.00€0.50matched
35capture01a1a8f1-8b1b-7473-aef0-c7ed53fe631f€49.00€0.67matched
36capture01a1a8f1-9a9b-7034-a0d6-6baccb88d072€9.00€0.19matched
37capture01a1a8f1-9d42-7c13-b117-a344b73fb8ea€9.00€0.19matched
38capture01a1a8f1-aac9-787a-b784-487980298ade€15.00€0.26matched
39capture01a1a8f1-c120-7865-90ec-f2bab9b2290a€49.00€0.67matched
40capture01a1a8f1-db00-7cbc-bcec-d586a96d8e85€49.00€0.67matched
41capture01a1a8f1-ec0b-7f78-b87a-4bfd98f3aa45€24.00€0.37matched
42capture01a1a8f1-ff2f-7fd6-888f-29d504b506b5€9.00€0.19matched
43refund01a1a8f2-1ace-702f-adcc-4960bc13b56c-€13.00€0.00matched
44capture01a1a8f2-1b7a-7c42-9b7f-d008ab81f3b4€15.00€0.26matched
45capture01a1a8f2-1fcb-757b-a137-f7f58d251831€15.00€0.26matched
46capture01a1a8f2-4215-75be-bdc6-b47206f4ceca€24.00€0.37matched
47capture01a1a8f2-46d3-7659-944f-7ef4e099d1d8€49.00€0.67matched
48capture01a1a8f2-58ab-7681-a135-743791cd90a6€24.00€0.37matched
49capture01a1a8f2-68bc-78d5-973d-17d5d91c7a10€49.00€0.67matched
50capture01a1a8f2-7b60-736c-9d01-abe892a7cfa5€9.00€0.19matched
51capture01a1a8f2-83d8-7fe3-9438-e18c0415bdff€15.00€0.26matched
52capture01a1a8f2-c6b9-70fa-9d04-7fd758f93828€15.00€0.26matched
53capture01a1a8f2-d297-75c4-8fbd-721e4c4e05d1€49.00€0.67matched
54capture01a1a8f2-eee8-7802-a177-620e8d45be17€24.00€0.37matched
55capture01a1a8f2-f00d-7f4d-91a0-be06a1f600ef€35.00€0.50matched
56capture01a1a8f3-0fbd-7175-b124-91abca1bad44€35.00€0.50matched
57capture01a1a8f3-2d89-75c1-ae0b-3bcd57c8b5c7€15.00€0.26matched
58capture01a1a8f3-3702-70fa-ab58-7c8a33243864€49.00€0.67matched
59capture01a1a8f3-5c5f-73cb-9522-7b3a282c89a6€49.00€0.67matched
60capture01a1a8f3-686c-7547-92b8-4d411963a8b1€9.00€0.19matched
61capture01a1a8f3-6947-781a-a81c-af1d80d54af9€9.00€0.19matched
62capture01a1a8f3-6c67-7a12-88a3-092679b4a816€49.00€0.67matched
63capture01a1a8f3-733b-799b-b084-0e5b507a1e2d€15.00€0.26matched
64capture01a1a8f3-786d-759e-8a22-bab74ab7ab1b€15.00€0.26matched
65capture01a1a8f3-7fd6-77c8-8526-76abc8e7e800€49.00€0.67matched
66capture01a1a8f3-8691-78e5-91c3-d883ac9e8a84€35.00€0.50matched
67capture01a1a8f3-9717-7742-b27c-cf6ee16919d7€9.00€0.19matched
68capture01a1a8f3-acfe-7592-868a-63923af4e524€49.00€0.67matched
69capture01a1a8f3-b5e2-731f-a964-8f9c6f19bc0f€24.00€0.37matched
70capture01a1a8f3-bf3d-72bd-833c-28014750ad52€15.00€0.26matched
71capture01a1a8f4-151d-767a-9181-0e305539e22e€24.00€0.37matched
72capture01a1a8f4-1c49-7fe9-815c-427c93b1bdf0€9.00€0.19matched
73capture01a1a8f4-3499-7eb7-b50b-d39c57c64762€9.00€0.19matched
74capture01a1a8f4-5bad-7c45-ae5e-0b29b36c73a4€15.00€0.26matched
75capture01a1a8f4-5d95-7e46-b9dc-bfbee8e91e1d€15.00€0.26matched
76capture01a1a8f4-6b79-705b-8244-16c8cd6096a3€15.00€0.26matched
77capture01a1a8f4-7215-76f9-a340-2414d0369875€35.00€0.50matched
78capture01a1a8f4-7223-72fc-882f-905a2a1b7824€15.00€0.26matched
79capture01a1a8f4-76dd-7772-80ca-ede07c125166€49.00€0.67matched
80capture01a1a8f4-81c5-754f-a1cd-4dfb46c5811d€24.00€0.37matched
81capture01a1a8f4-8ef5-71b6-bab9-a774587b296c€9.00€0.19matched
82capture01a1a8f4-b5bc-7304-8dde-eb31d6633988€15.00€0.26matched
83refund01a1a8f4-c0d6-7136-b72f-109f91c96309-€14.00€0.00matched
84refund01a1a8f4-c31e-7662-8569-37f7ecf15f4c-€5.00€0.00matched
85capture01a1a8f5-147c-7425-9892-77d0bbc9f568€49.00€0.67matched
86capture01a1a8f5-2f9d-7dd9-913a-5d6d8150d4ba€15.00€0.26matched
87capture01a1a8f5-343a-71f8-a0df-030c0792e487€35.00€0.50matched
88capture01a1a8f5-41f8-7c15-ad3d-187dc81d46c7€49.00€0.67matched
89capture01a1a8f5-51a2-758a-af4f-54494705f2bd€35.00€0.50matched
90capture01a1a8f5-925a-776e-8ddc-f71363a760aa€15.00€0.26matched
91capture01a1a8f5-946d-7ee2-b73c-4a06722e730e€35.00€0.50matched
92capture01a1a8f5-a402-7ec7-97db-d05bc7b40583€15.00€0.26matched
93capture01a1a8f5-b573-7a63-bf69-6bab6a076982€24.00€0.37matched
94capture01a1a8f5-c819-7abf-9eab-e82369b80549€35.00€0.50matched
95capture01a1a8f5-f670-7e5d-b03e-9e0942d55cdc€24.00€0.37matched
96capture01a1a8f6-2a73-7a80-a985-d166d6c34356€24.00€0.37matched
97capture01a1a8f6-855b-7b54-8f43-62ac323cd7c2€15.00€0.26matched
98capture01a1a8f6-a0d8-7975-8596-0d6b4eea0871€9.00€0.19matched
99capture01a1a8f6-a634-7874-a206-29af3df7980b€49.00€0.67matched
100capture01a1a8f6-b2ef-799b-8475-67c40bc93200€35.00€0.50matched
101capture01a1a8f6-b54d-7328-9e63-b7122be1eeda€49.00€0.67matched
102capture01a1a8f6-c19e-7c19-9975-38c68b8b2a00€9.00€0.19matched
104capture01a1a8f6-caa1-7246-bb75-4b398ff3f594€35.00€0.50matched
105capture01a1a8f6-d2d3-74ac-84c7-11256c8fd50a€24.00€0.37matched
106capture01a1a8f6-d3bc-7e77-baa9-c57152aa2125€24.00€0.37matched
107capture01a1a8f6-d3cf-71cd-b5c8-bb993612fd4b€24.00€0.37matched
108capture01a1a8f6-f4b0-7574-9298-85cc0a28cc1c€35.00€0.50matched
111capture01a1a8f7-1cc3-7d3f-8ee1-9809f953baea€9.00€0.19matched
112refund01a1a8f7-2e6b-79bf-b57e-9b6a68435de3-€7.00€0.00matched
113capture01a1a8f7-32e5-7956-a253-d81a8838f44a€15.00€0.26matched
114capture01a1a8f7-43c4-7fd0-adba-11a51fbdcbd1€15.00€0.26matched
115capture01a1a8f7-4dde-7ab5-b408-dd13093a9bdc€24.00€0.37matched
116capture01a1a8f7-8508-70e6-8beb-0a4e30b28ded€24.00€0.37matched
117capture01a1a8f7-9fba-760e-9312-0badea92ebe6€49.00€0.67matched
118refund01a1a8f7-a31a-7e96-9d8b-843cccf3da91-€5.00€0.00matched
119capture01a1a8f7-a3ad-7fed-8c4f-61a74c724a06€35.00€0.50matched
120capture01a1a8f7-c1d7-7bde-8a89-9cc5756bc24d€24.00€0.37matched
121capture01a1a8f7-c96f-7eaf-9dbd-e99d8f2c77f5€24.00€0.37matched
122capture01a1a8f7-edd8-7959-b895-45ce5c3b3be3€15.00€0.26matched
123capture01a1a8f8-0ae3-7649-99c3-8bd1e76f83c6€49.00€0.67matched