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

6 Nov, 08:30

Gross

€2,713.00

PSP fee

€42.87

Net to the bank

€2,670.13

Settlement journal

#412966

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b000-ce1d-7e62-8ce3-172f32a4938d is already settled by stl_EUR_2989923 line 78
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
LineKindReferenceGrossFeeStatus
79capture01a1b000-d311-7fd5-a022-5dfd445e4015€49.00€0.67duplicate line
93capture01a1b002-361a-7d62-a8d1-4e081e92aadf€24.00€0.41fee difference
1capture01a1aff1-bcaf-79ad-8a18-6ff31f11b39a€35.00€0.50matched
2capture01a1aff4-e6ca-797d-87f0-2af17cb873b0€24.00€0.37matched
3capture01a1aff7-55ce-7518-a31b-1542cc0c6522€15.00€0.26matched
4refund01a1aff7-ac48-70ad-a5aa-dd90bed3a049-€4.00€0.00matched
5capture01a1affa-aff4-7d89-a060-6e416f0f60c4€49.00€0.67matched
6capture01a1affa-bb9d-7335-9f19-b65d954d9dbe€35.00€0.50matched
7refund01a1affa-c7bc-7434-9a00-6551fd179d23-€8.00€0.00matched
8capture01a1affa-d1d7-76ed-8b07-d9b033b9cd56€15.00€0.26matched
9capture01a1affa-e984-73f1-9e3a-156fa74e30da€35.00€0.50matched
10capture01a1affa-f3a5-7020-b41d-b559b4328a93€35.00€0.50matched
11capture01a1affa-f68d-7c1a-9dac-0eb9ecc3e782€9.00€0.19matched
12capture01a1affa-fc51-71a6-bf87-18f30121b08c€9.00€0.19matched
13capture01a1affb-0025-7d96-9e41-b58acc2a3f29€49.00€0.67matched
14capture01a1affb-0848-7d9c-b7ae-c928e85074f1€24.00€0.37matched
15capture01a1affb-2fc0-796c-8d51-8a51e4a0535f€9.00€0.19matched
16capture01a1affb-5c6e-78bd-9ff6-aa4ac0b603a9€15.00€0.26matched
17capture01a1affb-5d6e-7716-ba85-1390920454e5€35.00€0.50matched
18capture01a1affb-5d98-7fc0-88de-8793a05edef9€9.00€0.19matched
19capture01a1affb-7741-7155-b096-ac652c5cc342€15.00€0.26matched
20capture01a1affb-88e2-72a5-81a4-f8c9c1b88dd4€15.00€0.26matched
21capture01a1affb-88e5-7060-941a-ea92196df403€9.00€0.19matched
22capture01a1affb-a59e-7bde-9ac7-5bc0e5b04ae0€49.00€0.67matched
23capture01a1affb-ad7b-74b6-ae01-49d96c49a503€15.00€0.26matched
24capture01a1affb-b5ca-7929-b298-7a58406e7e9e€24.00€0.37matched
25capture01a1affb-c727-7327-a6a8-6f16f31e281f€35.00€0.50matched
26capture01a1affb-d1c3-79b5-a110-5486bb85e0cf€24.00€0.37matched
27capture01a1affb-d54a-7077-acf9-a81aeba3eb10€15.00€0.26matched
28capture01a1affb-e135-7fb8-85cc-f37e4f50db2a€24.00€0.37matched
29capture01a1affb-f156-7344-a666-b73487a193b1€9.00€0.19matched
30capture01a1affc-0e9c-7182-b304-92eacc1b14af€35.00€0.50matched
31capture01a1affc-2034-7626-a249-d46a76a086cb€24.00€0.37matched
32capture01a1affc-2946-7f8d-b57f-1fc14e5e0b3c€15.00€0.26matched
33capture01a1affc-635b-7d4d-b6dd-d3aa0d1f120a€35.00€0.50matched
34capture01a1affc-65c4-7efd-9829-045d61a0710e€9.00€0.19matched
35capture01a1affc-8078-7a83-b535-fa15ebeadd2c€49.00€0.67matched
36capture01a1affc-9c67-7e9b-b6f2-9d51d4a0ca84€9.00€0.19matched
37capture01a1affc-9f79-73aa-a66a-39300c2a0e67€49.00€0.67matched
38capture01a1affc-e339-7ec2-aa05-ebf081c3bcd7€9.00€0.19matched
39capture01a1affc-f598-7362-a47c-320ee8ed2522€35.00€0.50matched
40capture01a1affd-7c9d-763d-aaa4-b5a7ba7ec6b8€9.00€0.19matched
41capture01a1affd-a648-7b9a-9437-59cbc1fa57d7€9.00€0.19matched
42capture01a1affd-cba7-720d-b115-c2ed66297a6d€9.00€0.19matched
43capture01a1affd-e86e-76a1-983d-7cd6c72275e4€9.00€0.19matched
44capture01a1affe-226d-72df-bd03-0306c2c88e00€15.00€0.26matched
45capture01a1affe-331e-74c1-9643-95a2c3ea065f€15.00€0.26matched
46capture01a1affe-38b8-79db-9cdd-598356d25709€9.00€0.19matched
47capture01a1affe-4f09-7099-8305-8b19f9c17a44€9.00€0.19matched
48capture01a1affe-4fe5-71a4-8920-638484a99533€35.00€0.50matched
49capture01a1affe-6bad-7646-9ed3-e6d2aa3b9327€24.00€0.37matched
50capture01a1affe-990d-7e11-a0a0-2e578df80a0e€24.00€0.37matched
51capture01a1affe-b6c3-7d61-a292-74bbc8978400€15.00€0.26matched
52refund01a1affe-d055-79ef-a276-837f57ac16af-€13.00€0.00matched
53capture01a1affe-d08f-7bba-870f-45691c6cabb1€24.00€0.37matched
54capture01a1affe-e0ec-7000-8764-699cccedad9b€9.00€0.19matched
55capture01a1affe-e362-79e5-b941-5c291c24df34€49.00€0.67matched
56capture01a1afff-36a3-709b-a51a-462c7b513c1e€35.00€0.50matched
57capture01a1afff-3d4f-762a-9597-a502ea34e555€9.00€0.19matched
58capture01a1afff-4e7a-7509-b94f-38ccaa501fcb€49.00€0.67matched
59capture01a1afff-5854-784a-b80b-f09eebd966c4€24.00€0.37matched
60capture01a1afff-7151-7462-a29f-33aac2358ca8€49.00€0.67matched
61capture01a1afff-836e-7c60-bd3b-f5eeb718e0da€15.00€0.26matched
62capture01a1afff-8852-7e65-b8f0-945f3e42a194€49.00€0.67matched
63capture01a1afff-926a-7930-84da-22a125945f70€15.00€0.26matched
64capture01a1afff-be34-77ec-87ad-c454371113be€24.00€0.37matched
65capture01a1afff-d9e6-7ea0-8188-256d682014f1€35.00€0.50matched
66capture01a1afff-f00a-7bd0-9b06-8383fdbf226c€24.00€0.37matched
67capture01a1b000-0966-72f3-bfb5-921dd0502f2f€15.00€0.26matched
68capture01a1b000-0eb6-7409-90d2-4a9f017df6ad€15.00€0.26matched
69capture01a1b000-13c8-77b7-bd98-365c00457dc8€15.00€0.26matched
70capture01a1b000-2123-77e1-ae1c-72284616f655€15.00€0.26matched
71capture01a1b000-4128-7983-896a-f29a47650ef2€15.00€0.26matched
72capture01a1b000-49d7-7562-b126-48b0765b7b48€49.00€0.67matched
73capture01a1b000-4ae3-7076-9594-3a01e2253b4b€49.00€0.67matched
74capture01a1b000-55d3-7def-b431-ee1339eb7176€9.00€0.19matched
75refund01a1b000-6a76-78e4-b23b-3dff5684318c-€10.00€0.00matched
76capture01a1b000-97c8-7c73-be43-c8a1004561fb€35.00€0.50matched
77capture01a1b000-d044-78a5-af6c-69f2b9a92c67€15.00€0.26matched
78capture01a1b000-d311-7fd5-a022-5dfd445e4015€49.00€0.67matched
80capture01a1b000-ef8d-7000-8f7b-fb4e8951442b€9.00€0.19matched
81capture01a1b000-faeb-7418-9659-38ab51af85c5€35.00€0.50matched
82capture01a1b001-0bb7-758f-b506-0d4a2cdb53c8€49.00€0.67matched
83capture01a1b001-3d3f-71d9-9a2d-6f9116713ee2€35.00€0.50matched
84capture01a1b001-4072-7b50-a988-3909bc4197c0€35.00€0.50matched
85capture01a1b001-4b44-7ab1-8dc0-857c3433c5d5€49.00€0.67matched
86capture01a1b001-5ccd-7edf-bdd4-4b7a9d03ba48€24.00€0.37matched
87capture01a1b001-c819-70f6-a958-5302477389f0€49.00€0.67matched
88capture01a1b001-cd65-7190-9d98-fc9a297e0926€35.00€0.50matched
89capture01a1b001-e8f3-7058-8417-0cb6f836b107€9.00€0.19matched
90capture01a1b001-f0af-7512-90b8-6e9e19625c1a€15.00€0.26matched
91capture01a1b002-078b-7076-b785-63ff8a82a638€49.00€0.67matched
92capture01a1b002-1417-7184-b70a-8c1121d2b0f8€9.00€0.19matched
94refund01a1b002-3aa7-768b-9ae6-abeba9ccf99c-€47.00€0.00matched
95capture01a1b002-4fab-730a-859b-6d2458676f98€24.00€0.37matched
96capture01a1b002-7396-7e29-a41d-cfd62cc917ea€9.00€0.19matched
97capture01a1b002-73b0-7df8-8e6f-33c953a4110a€9.00€0.19matched
98capture01a1b002-8cb6-7277-b630-915b932648d4€49.00€0.67matched
99capture01a1b002-8e45-778d-9dc8-5a0cb3886f57€35.00€0.50matched
100capture01a1b002-cabd-7703-9ed5-726657c0a8be€9.00€0.19matched
101capture01a1b002-d6a0-772f-a8c2-e024a1330b43€35.00€0.50matched
102capture01a1b002-d8d1-73d5-8e7d-bcc78be54369€49.00€0.67matched
103refund01a1b002-ecb2-7aa2-84e8-e0b2c5147260-€13.00€0.00matched
104capture01a1b002-f700-71ce-8fa3-944c7cc480a2€49.00€0.67matched
105capture01a1b003-0383-7317-9699-8129b26d8a13€35.00€0.50matched
106capture01a1b003-3728-7766-8f05-d8a246341f7c€49.00€0.67matched
107capture01a1b003-3bb5-7cf7-9e3b-2b6009e42175€35.00€0.50matched
108capture01a1b003-3c78-754e-9f90-10dc51afec30€24.00€0.37matched
109capture01a1b003-3cb6-71f7-a941-e600164c3e3d€35.00€0.50matched
110capture01a1b003-690b-7fb9-8d96-20a8ddfbf45c€24.00€0.37matched
111capture01a1b003-6c0b-760f-a6bf-3a6e6ba5a9ae€15.00€0.26matched
112capture01a1b003-6cf2-7607-861a-7e0cb457e03e€15.00€0.26matched
113capture01a1b003-8a79-7bb3-be05-887ede8be823€24.00€0.37matched
114capture01a1b003-9094-7978-b76c-65124a8b1fbe€9.00€0.19matched
115refund01a1b003-9be3-7178-aa2e-85195c6e33cc-€17.00€0.00matched
116capture01a1b003-a1ab-720c-82b1-d712e8947c18€24.00€0.37matched
117capture01a1b003-c181-713a-8955-0d324a58ba63€15.00€0.26matched