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

3 Nov, 06:10

Gross

€2,869.00

PSP fee

€47.10

Net to the bank

€2,821.90

Settlement journal

#356362

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a008-31e7-7f58-aff8-1b2f8abf70c6 is already settled by stl_EUR_2989477 line 27
  • fee differencethe fee is not the contract feethe fee is 3, the contract says 0
LineKindReferenceGrossFeeStatus
22refund01a1a007-fb2a-773c-9d45-e29a6d3c2ff5-€31.00€0.03fee difference
28capture01a1a008-3202-7884-9553-c6c23dc4dfe7€24.00€0.37duplicate line
1capture01a19fff-2f72-70d5-9616-f0a1c206a00f€24.00€0.37matched
2capture01a1a000-05f1-70f5-a843-c9c2bb64e080€24.00€0.37matched
3capture01a1a000-7ee5-7b6c-b03d-aa45aa6613d8€9.00€0.19matched
4refund01a1a006-080c-7917-9c6f-0b52945a147d-€46.00€0.00matched
5capture01a1a006-22bc-7999-9960-09730608db0e€9.00€0.19matched
6capture01a1a006-b051-7252-9313-e132fbf68d60€49.00€0.67matched
7refund01a1a007-6b8a-741c-9130-8612d05402c5-€21.00€0.00matched
8capture01a1a007-6d69-7ff3-bdda-bfc995f04b5c€9.00€0.19matched
9capture01a1a007-71bc-7178-a5fe-5132a6c49204€15.00€0.26matched
10capture01a1a007-8992-759f-9cb8-31eb6d19dd06€9.00€0.19matched
11capture01a1a007-9050-7b3c-89f2-3e1411742a6c€35.00€0.50matched
12refund01a1a007-948c-75b4-ae23-19b728ea4c51-€9.00€0.00matched
13capture01a1a007-a894-7031-8d4a-5b858b928593€9.00€0.19matched
14capture01a1a007-afa4-7044-8260-83c3d95afe44€35.00€0.50matched
15capture01a1a007-b57c-71df-8a0f-66d74d25cfbb€24.00€0.37matched
16capture01a1a007-bbb9-7a50-a782-6695eaa96274€24.00€0.37matched
17capture01a1a007-c59f-75d0-a696-1bca94255621€15.00€0.26matched
18capture01a1a007-d456-7f38-ab61-0a730591340d€24.00€0.37matched
19capture01a1a007-e5ad-7a86-b859-5813a11d994d€24.00€0.37matched
20capture01a1a007-f46a-774c-bcc9-500b2c06e47c€15.00€0.26matched
21capture01a1a007-f608-77fc-9257-a9355c4e8736€15.00€0.26matched
23capture01a1a008-151b-78f4-8a7d-a15bbf6d4683€15.00€0.26matched
24capture01a1a008-221b-7e63-9f6e-2f97d2e27836€49.00€0.67matched
25capture01a1a008-228d-7b9b-8772-8845caab6ccd€15.00€0.26matched
26capture01a1a008-2d8d-76fa-a102-8674f47be0f9€9.00€0.19matched
27capture01a1a008-3202-7884-9553-c6c23dc4dfe7€24.00€0.37matched
29capture01a1a008-60dc-7545-8d07-4b9dda2e8101€15.00€0.26matched
30capture01a1a008-6a11-7887-a6a2-2c9fc72bf7b7€49.00€0.67matched
31capture01a1a008-6f43-7f88-95f6-a70acb4b03d7€24.00€0.37matched
32refund01a1a008-7cb3-70b8-9cd7-2393fdb757ee-€23.00€0.00matched
33capture01a1a008-7a36-79de-aae7-7deb4cb15a07€9.00€0.19matched
34refund01a1a008-82cd-70cb-995c-99bb4b6ac987-€7.00€0.00matched
35capture01a1a008-87e2-786e-8cc7-cb8b525a97ee€49.00€0.67matched
36capture01a1a008-b7df-71cc-a9e0-40054a4aaa35€35.00€0.50matched
37refund01a1a008-c0d9-7b61-ab06-5d6132fb0026-€23.00€0.00matched
38capture01a1a008-ceb1-7631-b77b-32b0b47c8329€9.00€0.19matched
39capture01a1a008-d108-7db4-916e-2083909aa5f4€49.00€0.67matched
40capture01a1a008-dbf5-7e87-ac79-ea332ab33bd1€24.00€0.37matched
41capture01a1a008-e273-7052-bdbc-aebc6282950b€49.00€0.67matched
42capture01a1a008-eee8-700c-b259-901bb84c7b3f€9.00€0.19matched
43capture01a1a008-f6c8-77d4-8083-f12502119f84€15.00€0.26matched
44capture01a1a009-0a69-7fe1-adbb-f18c54fce09c€15.00€0.26matched
45refund01a1a009-137b-71b4-b638-49b579d77726-€20.00€0.00matched
46capture01a1a009-511d-7502-b52c-698ec641c7a3€15.00€0.26matched
47capture01a1a009-516d-7c0a-a96f-76c08c59ac9f€49.00€0.67matched
48capture01a1a009-65a5-7823-8173-718bd9a1fab1€24.00€0.37matched
49capture01a1a009-9180-7146-aa9a-568b9a1fffd0€15.00€0.26matched
50capture01a1a009-bb1c-7a0b-9cc9-2ad5f8aaf82d€24.00€0.37matched
51refund01a1a009-fc12-7c0b-952b-b4edc347267e-€5.00€0.00matched
52capture01a1a00a-037f-7470-b964-5400878021a5€9.00€0.19matched
53capture01a1a00a-177c-7d2c-bcf6-9f4722153798€24.00€0.37matched
54capture01a1a00a-5a16-7234-903e-f947afb192f8€35.00€0.50matched
55capture01a1a00a-6552-7cf0-8830-8fe49101ec4f€49.00€0.67matched
56capture01a1a00a-7772-7440-ab46-75fc0f552c90€24.00€0.37matched
57capture01a1a00a-8c1d-7bd3-a63e-921837b57464€9.00€0.19matched
58capture01a1a00a-8d95-7a6e-a9b1-d6265c589e71€15.00€0.26matched
59capture01a1a00a-9def-7b8b-a02e-bbeec828bc7b€35.00€0.50matched
60capture01a1a00a-9dfe-7525-8187-c70474ad6313€15.00€0.26matched
61capture01a1a00a-a201-7568-91d1-e5390a10621f€24.00€0.37matched
62capture01a1a00a-a7a6-79c0-abcd-792ae7cc2237€24.00€0.37matched
63capture01a1a00a-c156-7eb5-bfec-151f4bbdb058€9.00€0.19matched
64refund01a1a00a-c169-76cc-8b37-c2d2dcda82aa-€17.00€0.00matched
65capture01a1a00a-c23b-7a79-81de-55c208da7f9f€35.00€0.50matched
66capture01a1a00a-e41a-737f-b251-0e2e7206f8c4€49.00€0.67matched
67capture01a1a00a-ef2a-7e20-ad00-ba950e390b56€49.00€0.67matched
68capture01a1a00a-f93e-7c05-9769-f0c6cfba1892€15.00€0.26matched
69capture01a1a00a-fea1-7c3f-b432-c0fa27d4928d€49.00€0.67matched
70capture01a1a00b-0580-7ea3-8527-247a3958da01€35.00€0.50matched
71capture01a1a00b-0d1c-78a1-a8bb-e6c14550c6a0€15.00€0.26matched
72capture01a1a00b-22c9-776f-8453-0d7943703e92€35.00€0.50matched
73capture01a1a00b-3281-71ce-ad4f-1ecfe99de162€35.00€0.50matched
74capture01a1a00b-4485-7fbe-b7d0-325a549c3257€15.00€0.26matched
75capture01a1a00b-a6f9-723a-a93f-f970e0fd77b5€35.00€0.50matched
76capture01a1a00c-17c5-76bf-bcc2-9945a257cdc3€24.00€0.37matched
77capture01a1a00c-1a44-738e-b48a-f6e989bf2061€9.00€0.19matched
78capture01a1a00c-1b93-700b-9eec-b538caf16d39€15.00€0.26matched
79capture01a1a00c-2056-7a5c-8302-35c8bed55280€9.00€0.19matched
80capture01a1a00c-315f-72b2-bfa7-6f2d7bbc98f9€35.00€0.50matched
81capture01a1a00c-3cc7-74e0-9180-d963f3087946€9.00€0.19matched
82capture01a1a00c-527d-7c5f-ad1b-679cbd8982a9€35.00€0.50matched
83refund01a1a00c-86a1-7717-a870-d60596b0fb0a-€26.00€0.00matched
84capture01a1a00c-9036-7863-97ec-fd4a72e1f2af€35.00€0.50matched
85capture01a1a00c-e10e-7235-883c-61f4163c8c4a€49.00€0.67matched
86capture01a1a00c-e269-7ba6-b7c9-82c91e7e9d42€15.00€0.26matched
87refund01a1a00c-e756-75fe-9313-ea48c0f4d4ed-€16.00€0.00matched
88capture01a1a00c-e971-7c76-8ec9-523632e9ffb6€35.00€0.50matched
89capture01a1a00c-f4f4-72b8-bd78-947bfb2926ae€49.00€0.67matched
90capture01a1a00c-f58f-7d5a-be3b-fdde47931e9f€49.00€0.67matched
91capture01a1a00d-07b1-7b6d-b798-2306485d48c5€9.00€0.19matched
92capture01a1a00d-2c34-7a20-8e36-f7b1cdbdd132€35.00€0.50matched
93capture01a1a00d-3657-7b4d-b8cc-c934748992ac€49.00€0.67matched
94capture01a1a00d-41fd-7943-bf94-0d4616436694€35.00€0.50matched
95capture01a1a00d-4746-75a6-aa0a-74f4dd96c9e5€35.00€0.50matched
96capture01a1a00d-5137-7a32-ae50-794661346ab6€15.00€0.26matched
97refund01a1a00d-575c-7815-a824-9140b2b35859-€11.00€0.00matched
98capture01a1a00d-5fde-7a70-9ae6-7561107a05c9€24.00€0.37matched
99capture01a1a00d-b067-79ee-a2a9-618400763bc0€24.00€0.37matched
100capture01a1a00d-b6a2-7d75-a51f-d1acd3ff3608€35.00€0.50matched
101capture01a1a00d-e487-7dd7-93b7-049aaa5c3363€9.00€0.19matched
102capture01a1a00d-e4cd-7ef9-a749-657ce432820d€49.00€0.67matched
103capture01a1a00d-fb43-7363-9547-1c3a74934d44€9.00€0.19matched
104capture01a1a00e-03d7-7cf6-92fa-45799f233d80€49.00€0.67matched
105capture01a1a00e-3471-71f7-ae4f-f6a8910cab6a€15.00€0.26matched
106capture01a1a00e-34fc-7988-a736-95c68e5b8677€49.00€0.67matched
107capture01a1a00e-4f21-7b9e-a83c-7bc2d4eab322€49.00€0.67matched
108capture01a1a00e-5382-788d-8a85-00a992993698€9.00€0.19matched
109capture01a1a00e-58fe-753d-af34-040664340f2f€49.00€0.67matched
110capture01a1a00e-5cb0-7521-a037-e3ca184fe8f2€9.00€0.19matched
111capture01a1a00e-6f7a-7028-a24a-9edd96e87d93€24.00€0.37matched
112capture01a1a00e-7c3f-7ca9-946a-076cb558b4de€15.00€0.26matched
113capture01a1a00e-7f9f-74fa-a921-2db2bd72bcc9€49.00€0.67matched
114capture01a1a00e-ac8f-7f81-95f3-c0af6469c646€35.00€0.50matched
115capture01a1a00e-e336-7954-acef-e30bf3224e82€15.00€0.26matched
116capture01a1a00e-ef9f-7ca1-8175-139620fac223€49.00€0.67matched
117capture01a1a00e-fffb-7885-b9a6-605e1c98703c€9.00€0.19matched
118capture01a1a00f-067e-7b9c-b405-221f57f159d1€24.00€0.37matched
119capture01a1a00f-54ac-7aac-8dc0-f3bb8d5c2427€15.00€0.26matched
120capture01a1a00f-b664-7cf2-b851-08845cb142e9€35.00€0.50matched
121capture01a1a00f-ce25-7b08-a3cf-97674a9d91bb€24.00€0.37matched
122capture01a1a00f-e807-7dec-b9a0-4e02e35b21a3€49.00€0.67matched
123capture01a1a010-2c51-761d-974d-f4edefb8e8de€9.00€0.19matched
124capture01a1a010-4860-7b45-97dd-8aac43cb839c€24.00€0.37matched
125capture01a1a010-4d0c-76d7-b9b0-3a1af5e4323b€9.00€0.19matched
126capture01a1a010-5c2d-7f85-9ca7-839b35b5d0f1€15.00€0.26matched
127capture01a1a010-5d0b-791a-b11e-61f34f922a3d€49.00€0.67matched
128capture01a1a010-64d4-7ec9-a3ea-9c627718b2b2€35.00€0.50matched
129capture01a1a010-669d-7c4c-b1fc-81d81ef0c405€24.00€0.37matched
130capture01a1a010-72fe-7ed8-b20c-40a0d83cd9ba€35.00€0.50matched
131capture01a1a010-8164-781e-8b78-04595b162dae€35.00€0.50matched