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

2 Nov, 02:50

Gross

€2,696.00

PSP fee

€41.99

Net to the bank

€2,654.01

Settlement journal

#335512

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19a2e-aa95-743d-be0a-22807cbcd32a is already settled by stl_EUR_2989313 line 67
  • duplicate linethe file lists it twicecapture:01a19a31-766b-78d0-8e0e-191742d38e49 is already settled by stl_EUR_2989314 line 2
  • missing linein the books, not in the filecapture:01a19a2d-2da1-7e4e-83ad-d570a6ba524f is in no file
LineKindReferenceGrossFeeStatus
68capture01a19a2e-c0bc-78b2-ae02-64846bb01978€9.00€0.19duplicate line
1capture01a19a22-a224-73c7-a986-3409fb2a61fc€9.00€0.19matched
2capture01a19a24-ac2c-738a-babb-65f82e0a0b5a€15.00€0.26matched
3capture01a19a25-4232-7226-8944-48d58c3824c8€49.00€0.67matched
4capture01a19a27-3201-78be-9d20-bf8251bd45b1€9.00€0.19matched
5capture01a19a29-f5dd-79e6-9ddf-aa50eb73aca0€15.00€0.26matched
6capture01a19a29-f818-71e0-991d-2eb3824d466d€9.00€0.19matched
7capture01a19a2a-2e4e-7683-8363-4572f1ffa677€9.00€0.19matched
8capture01a19a2a-3442-7f8c-8043-00762672967a€24.00€0.37matched
9capture01a19a2a-3a33-701a-8cb6-7bee96308274€15.00€0.26matched
10capture01a19a2a-4a80-79b7-928f-bafada78abc7€24.00€0.37matched
11capture01a19a2a-568b-757d-b2f9-772b83f4ec4c€35.00€0.50matched
12capture01a19a2a-5d65-70a2-9bc2-f7e9d5e7bfe9€49.00€0.67matched
13capture01a19a2a-6153-79af-b851-872d6bc460f8€24.00€0.37matched
14capture01a19a2a-5f23-75a0-808d-bc77b4c14b8e€15.00€0.26matched
15capture01a19a2a-76cd-745c-8c03-08b830644b3e€49.00€0.67matched
16capture01a19a2a-8e7b-7d8a-a902-2960582c3586€15.00€0.26matched
17capture01a19a2a-8eee-77d7-b3d2-61014de80a4c€9.00€0.19matched
18capture01a19a2a-98c8-7479-a420-cb3567e80531€15.00€0.26matched
19capture01a19a2a-c963-7077-a771-a080ce858895€24.00€0.37matched
20capture01a19a2a-cecf-73e7-b4cb-b96e6611ddb2€35.00€0.50matched
21capture01a19a2a-d302-7398-acce-62f239b77f58€35.00€0.50matched
22capture01a19a2b-164e-7675-97d0-7ef9a5430554€24.00€0.37matched
23capture01a19a2b-174c-7971-8f6b-f1225daf23a8€9.00€0.19matched
24capture01a19a2b-1891-79ca-b144-757acd704a26€15.00€0.26matched
25capture01a19a2b-64cd-7333-9bda-bd299d14f9e2€24.00€0.37matched
26capture01a19a2b-7512-7e81-9d24-8ff72ec32fc4€15.00€0.26matched
27capture01a19a2b-7a93-7848-87f4-3ae0fe6aa9f2€35.00€0.50matched
28capture01a19a2b-8072-7fb7-99c9-5a41c6f727f9€9.00€0.19matched
29capture01a19a2b-83cb-7763-9d4e-606b59e4fde9€49.00€0.67matched
30capture01a19a2b-ab06-79c2-9cb3-e80fb7488598€9.00€0.19matched
31capture01a19a2b-b061-7e7c-9bfa-e11f9e19b303€24.00€0.37matched
32refund01a19a2b-d18f-72d9-9682-1541cbf9a2fc-€9.00€0.00matched
33capture01a19a2b-de52-7eeb-a031-2ec8ecb15b6d€35.00€0.50matched
34capture01a19a2b-e798-783a-9422-e296d416b17d€24.00€0.37matched
35capture01a19a2b-ee5a-7edc-af93-2ced6258ac26€35.00€0.50matched
36capture01a19a2c-31ff-7a0e-a2e9-4731f2c55130€15.00€0.26matched
37capture01a19a2c-324b-70ef-b5a7-59e4dc9bdb4e€49.00€0.67matched
38capture01a19a2c-35ab-71a3-a22a-3416ffd846bf€15.00€0.26matched
39capture01a19a2c-450c-79db-b1d0-a9ee80271b11€9.00€0.19matched
40capture01a19a2c-5865-7efd-a210-7d5bd0b63a2d€9.00€0.19matched
41capture01a19a2c-a566-7a5c-9f79-550a2110c4a7€49.00€0.67matched
42capture01a19a2c-b76d-77f6-8f19-25cc3e3cd2aa€15.00€0.26matched
43capture01a19a2c-bf56-783f-9474-67851cb67077€24.00€0.37matched
44capture01a19a2c-d29d-7545-b9e0-22e36bc06d95€24.00€0.37matched
45capture01a19a2c-e1ac-7492-a1dd-772155e21f1c€35.00€0.50matched
46capture01a19a2d-0658-72a3-9617-ad86a0c689c5€49.00€0.67matched
47capture01a19a2d-22b6-77e6-81df-678f80129ece€35.00€0.50matched
48capture01a19a2d-2444-744b-b0b4-021ca9a06fdd€24.00€0.37matched
49capture01a19a2d-30da-7a29-986a-32049957bf0d€49.00€0.67matched
50capture01a19a2d-4a77-7a11-8b1e-c7195388122f€49.00€0.67matched
51refund01a19a2d-5801-7a7d-a65a-a099193d196a-€37.00€0.00matched
52capture01a19a2d-69fb-7b71-9d61-a530cdc10ea4€15.00€0.26matched
53capture01a19a2d-b27f-71f4-8f35-ec56896c3902€24.00€0.37matched
54capture01a19a2d-bd21-71c4-b4d4-8428c4bad7a2€9.00€0.19matched
55capture01a19a2d-cc7c-789a-b54d-331517cb3ca3€49.00€0.67matched
56capture01a19a2d-dfee-776e-b91e-6bbad33124c2€15.00€0.26matched
57capture01a19a2e-05db-723d-b1cc-c35756c1134f€9.00€0.19matched
58capture01a19a2e-4e76-7a6c-92dd-8298b0ece3f7€24.00€0.37matched
59capture01a19a2e-559c-74c1-aa9f-67463e3e1ff4€15.00€0.26matched
60capture01a19a2e-6188-7069-bc85-237b88edea7e€35.00€0.50matched
61capture01a19a2e-747d-7f0b-acd5-0efcf51d4336€24.00€0.37matched
62capture01a19a2e-7e0b-76a0-8b3f-e9f724bdcfe0€49.00€0.67matched
63capture01a19a2e-8d2d-731d-9412-1607896036c7€15.00€0.26matched
64refund01a19a2e-9955-71b2-b0d7-41c6a9353d32-€22.00€0.00matched
65capture01a19a2e-b230-7f9f-b7f4-e21d5217574d€24.00€0.37matched
66capture01a19a2e-bc93-79a1-8300-44b9ccd1d6bd€49.00€0.67matched
67capture01a19a2e-c0bc-78b2-ae02-64846bb01978€9.00€0.19matched
69capture01a19a2e-c347-7f15-99e2-044d38e1abaf€24.00€0.37matched
70capture01a19a2e-cf35-7113-874b-9d64527ba67e€9.00€0.19matched
71capture01a19a2e-d13c-7a12-a4e2-60bb0117c24e€35.00€0.50matched
72capture01a19a2e-e851-749a-ae68-b2b384cbb134€35.00€0.50matched
73capture01a19a2e-eab8-7514-8474-d9faf075ad66€24.00€0.37matched
74capture01a19a2f-11b5-701a-8a94-96f8b2b04061€49.00€0.67matched
75capture01a19a2f-3556-79a4-a469-d132805a74af€9.00€0.19matched
76capture01a19a2f-6eef-72d6-9829-630d4df95be6€35.00€0.50matched
77capture01a19a2f-f5de-74bf-ad16-f232f230e664€24.00€0.37matched
78capture01a19a30-1400-76bb-85c9-7f2d89dfebd4€15.00€0.26matched
79capture01a19a30-1459-7789-9958-2125af83afe6€49.00€0.67matched
80capture01a19a30-1d55-71ff-8904-62fed4f682c7€9.00€0.19matched
81capture01a19a30-224e-77af-8ae6-9d0811635279€15.00€0.26matched
82capture01a19a30-2304-7b3c-afbb-4f7c038aa9fd€9.00€0.19matched
83capture01a19a30-3bc4-788a-84fb-cc2ff168d073€15.00€0.26matched
84capture01a19a30-42db-7998-9433-53d03d8ba889€35.00€0.50matched
85capture01a19a30-4ce9-7821-9c37-01382f2e8609€49.00€0.67matched
86capture01a19a30-59f2-7c7c-949e-c50e322ea7a6€49.00€0.67matched
87capture01a19a30-6930-71f2-835e-21a9e94bdd4e€15.00€0.26matched
88capture01a19a30-7b0a-7fd5-841f-0cb1eac60237€24.00€0.37matched
89capture01a19a30-aada-7c20-a06f-9ad96ffd9a9f€24.00€0.37matched
90capture01a19a30-b1fe-7b32-88ba-5d8ad76ebbf9€24.00€0.37matched
91capture01a19a30-c8b3-775f-98cc-73682b2d0595€35.00€0.50matched
92capture01a19a30-c8d3-703e-8324-0827ce619239€49.00€0.67matched
93capture01a19a30-e496-72bb-9052-84ea87db1771€49.00€0.67matched
94capture01a19a31-0c9b-731f-ba10-26764a093a6e€35.00€0.50matched
95capture01a19a31-8c43-707a-ba1b-e4592fe7cfe3€24.00€0.37matched
96capture01a19a31-9e75-7f48-a8af-6b6a5b59c873€15.00€0.26matched
97capture01a19a31-ba78-7a31-b544-a19f75f17a20€15.00€0.26matched
98capture01a19a31-de5d-7696-a8dd-85fcfde72afb€35.00€0.50matched
99capture01a19a31-dbef-7ecc-b9d7-c427d2c4e1d2€9.00€0.19matched
100capture01a19a32-0155-7412-9c6c-23a23919777f€9.00€0.19matched
101capture01a19a32-1c0d-7de7-a6d5-5c09d2f1258e€35.00€0.50matched
102capture01a19a32-1c9a-7649-9556-caad28a8f28e€49.00€0.67matched
103capture01a19a32-2487-77b8-b003-2fa60d7d3d34€35.00€0.50matched
104capture01a19a32-829c-7123-8174-c897010716a8€49.00€0.67matched
105capture01a19a32-aa1e-7c41-b630-2f8ae6bb73e2€49.00€0.67matched
106capture01a19a32-b5de-79d6-8a1c-309d8981b2b8€9.00€0.19matched
107capture01a19a32-d4bd-7d15-94b0-76a1212ea585€35.00€0.50matched
108capture01a19a32-da18-7050-ba7b-4a6f9ab46caf€15.00€0.26matched
109capture01a19a32-e40e-7664-975f-1da67d277e23€9.00€0.19matched
110capture01a19a33-0ace-7841-abc3-061453817797€9.00€0.19matched
111capture01a19a33-0b6d-7f71-9df2-f975689ddf28€9.00€0.19matched
112refund01a19a33-0edf-7eda-adf9-63150a3ba495-€4.00€0.00matched