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, 21:00

Gross

€2,925.00

PSP fee

€48.15

Net to the bank

€2,876.85

Settlement journal

#385852

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a85e-0830-7048-b63a-78f4bec4c9a9 is already settled by stl_EUR_2989710 line 31
LineKindReferenceGrossFeeStatus
32capture01a1a85e-084d-7985-885b-a0307f71ca00€24.00€0.37duplicate line
1capture01a1a854-0d37-70bb-a2d8-5acb2b9caf05€24.00€0.37matched
2capture01a1a854-3ba4-7ff4-9c81-f4fc3e2ac34a€9.00€0.19matched
3capture01a1a85c-a1bb-73da-8ec2-44dfa9b96838€15.00€0.26matched
4capture01a1a85c-af95-7f9f-bdf9-19befb8cf10e€24.00€0.37matched
5capture01a1a85c-a755-7327-8941-f785027a509a€35.00€0.50matched
6capture01a1a85c-e7f0-7e71-9914-fd4e526977e6€9.00€0.19matched
7capture01a1a85c-f196-7f3e-a95c-f5cebeb2d01e€49.00€0.67matched
8capture01a1a85c-f6cd-76e1-9ae0-e3078705e031€35.00€0.50matched
9refund01a1a85c-fb5c-7473-a805-e812ad9ac3f5-€15.00€0.00matched
10capture01a1a85d-0491-78e4-be63-3a005dac252f€35.00€0.50matched
11capture01a1a85d-072a-7c5a-892b-d7f613575eac€9.00€0.19matched
12capture01a1a85d-0d12-792b-9fdc-519d8979b4e2€49.00€0.67matched
13capture01a1a85d-1013-7e05-ba0e-bcd78f3bc345€9.00€0.19matched
14capture01a1a85d-22d2-7180-9ef8-0c463c9dd034€15.00€0.26matched
15capture01a1a85d-3192-777d-95f3-04b58c8aec1b€9.00€0.19matched
16capture01a1a85d-3420-7ec5-a95d-58d4d1e57e52€49.00€0.67matched
17capture01a1a85d-39bc-774f-a5a4-f4832ba57a77€24.00€0.37matched
18capture01a1a85d-47e6-7ceb-9a83-d1ab1af635eb€15.00€0.26matched
19capture01a1a85d-64f7-701a-87bd-f5cbdea8be5c€15.00€0.26matched
20capture01a1a85d-6ad4-704d-ba4e-e281d71b90e5€24.00€0.37matched
21refund01a1a85d-6fde-7c3b-8876-e3f61ad8a7f0-€3.00€0.00matched
22capture01a1a85d-88b3-7471-8f72-e52608c16f4e€9.00€0.19matched
23refund01a1a85d-88b4-7e82-a10a-509d8776d026-€10.00€0.00matched
24capture01a1a85d-8e03-7416-834e-22eddb7a40e2€9.00€0.19matched
25capture01a1a85d-96b7-7d92-b042-6e26bb4946bd€15.00€0.26matched
26capture01a1a85d-9adc-73fc-8a73-65593b48ad89€9.00€0.19matched
27capture01a1a85d-c347-71b8-ba04-296dad0d4e77€15.00€0.26matched
28capture01a1a85d-c48e-708d-bca7-40304652dfab€49.00€0.67matched
29capture01a1a85e-02db-7cc1-999e-3a57d62f48c5€15.00€0.26matched
30capture01a1a85e-069d-7eb0-92d3-73435ef3bdfe€15.00€0.26matched
31capture01a1a85e-084d-7985-885b-a0307f71ca00€24.00€0.37matched
33capture01a1a85e-0cdb-713b-9c0e-a8dccc0ddafa€15.00€0.26matched
34capture01a1a85e-488c-7e5f-ac0f-6f07030a750c€49.00€0.67matched
35refund01a1a85e-566b-7425-8f88-1d5d482fa553-€20.00€0.00matched
36capture01a1a85e-5d0d-769e-a793-dc4da6f0ec63€15.00€0.26matched
37capture01a1a85e-60d3-73bc-a8f8-ca0857ea7ba4€35.00€0.50matched
38capture01a1a85e-6497-7be6-a6e0-360f64bc3267€15.00€0.26matched
39capture01a1a85e-6d01-778a-90d0-2189d0a87176€49.00€0.67matched
40capture01a1a85e-7c1f-7e6a-9e02-b0df812154c9€15.00€0.26matched
41capture01a1a85e-7dd6-7bba-a648-0ab398dd18cd€9.00€0.19matched
42capture01a1a85e-8b4f-7058-8533-a83ef58f3131€24.00€0.37matched
43capture01a1a85e-9a91-7de6-8f79-535a813ed88c€49.00€0.67matched
44refund01a1a85e-ac2b-7d55-a984-38127a1098ae-€21.00€0.00matched
45capture01a1a85e-d195-7a9b-8b7a-b549ca97982b€49.00€0.67matched
46capture01a1a85e-ddf0-75e3-85ad-182db62d4684€24.00€0.37matched
47capture01a1a85f-16b7-7ed4-8949-3ed039041859€24.00€0.37matched
48capture01a1a85f-1898-7168-b401-3969e9ec34f8€9.00€0.19matched
49capture01a1a85f-5756-7631-af40-eb60b27fb113€24.00€0.37matched
50capture01a1a85f-5b15-7c65-91fb-ed968aac9b06€9.00€0.19matched
51capture01a1a85f-642d-7c44-95fd-e0e27945dc6d€49.00€0.67matched
52capture01a1a85f-75df-79dc-a16e-6239c6d8fb2f€35.00€0.50matched
53capture01a1a85f-7a37-776d-a1af-0891a293dc72€24.00€0.37matched
54capture01a1a85f-7fc2-798c-b3b5-c1bbb6cf26f3€49.00€0.67matched
55capture01a1a85f-ad0e-79a6-9bd5-228fec98899a€9.00€0.19matched
56capture01a1a85f-bf90-7e59-b3c1-1ba0c26e1896€49.00€0.67matched
57capture01a1a85f-c025-7c0a-a7e8-abc9c03bc86d€9.00€0.19matched
58capture01a1a85f-c3c7-7e9f-b883-8483a9d626df€49.00€0.67matched
59refund01a1a85f-c5c0-729a-8d75-3fda23720790-€19.00€0.00matched
60capture01a1a85f-c7b8-7cab-9b98-00beee7adb75€24.00€0.37matched
61capture01a1a85f-f793-763e-8340-f0bcebefd2a8€35.00€0.50matched
62capture01a1a860-0908-7135-9a26-7c1299c607f4€9.00€0.19matched
63capture01a1a860-1916-7df8-94b0-e3465a7272f3€15.00€0.26matched
64capture01a1a860-2226-7b8e-8ecb-9685c1c7f1e0€9.00€0.19matched
65capture01a1a860-4813-7b2c-9b84-7b6248d6c00b€15.00€0.26matched
66capture01a1a860-5a8c-7118-8f8e-f06bc1163cf0€49.00€0.67matched
67refund01a1a860-7e60-7352-bb6c-fa98273a7fe0-€4.00€0.00matched
68capture01a1a860-92c6-74c6-8cba-2ee380421b25€49.00€0.67matched
69capture01a1a860-984f-7922-9526-7fe1dfd9fa1d€9.00€0.19matched
70capture01a1a860-a1cc-7763-9f51-2d3711141255€24.00€0.37matched
71capture01a1a860-a3d8-713c-9667-6aa729929f82€15.00€0.26matched
72refund01a1a860-be79-7edc-9bd1-8f9192b732a6-€39.00€0.00matched
73capture01a1a860-bf6e-7534-9cfb-d152e0aa2027€15.00€0.26matched
74capture01a1a860-c88c-770a-9a52-12f7961ddcc9€24.00€0.37matched
75capture01a1a860-cc26-7b65-9496-1e298977fad4€35.00€0.50matched
76capture01a1a860-cda0-704e-a597-c27caf3bae0c€35.00€0.50matched
77capture01a1a860-f39a-702b-8c7d-d4182e55a9bb€15.00€0.26matched
78capture01a1a861-068a-7f29-99aa-5b6e6d3a743b€49.00€0.67matched
79capture01a1a861-267b-7d77-843a-8d5d0c5baeb6€9.00€0.19matched
80capture01a1a861-2d8d-77d7-a512-eebd0ebf4c95€9.00€0.19matched
81capture01a1a861-3e17-7cc8-af6d-29c13e30804f€15.00€0.26matched
82refund01a1a861-3e93-7274-9486-fa01f01b4593-€23.00€0.00matched
83capture01a1a861-4905-7e12-8cf7-29e1491d08aa€49.00€0.67matched
84capture01a1a861-622d-7c27-b016-20411a7b3406€49.00€0.67matched
85capture01a1a861-7505-7ea0-bbbd-83bd3faa499f€9.00€0.19matched
86capture01a1a861-8271-7f48-82d0-a1eee1ac1f52€9.00€0.19matched
87capture01a1a861-b6e2-7cf3-9bb8-2b67e2d0a977€9.00€0.19matched
88capture01a1a861-bd95-75d5-aade-5cafc4c05eb1€15.00€0.26matched
89capture01a1a861-bdb2-7d21-b651-9de22c7e989e€35.00€0.50matched
90capture01a1a861-c07a-7ab5-8f14-2f8b91d7e4ee€24.00€0.37matched
91capture01a1a861-cad0-72fe-8ef8-a80cefa49dc5€24.00€0.37matched
92capture01a1a861-d520-79ac-906f-d7eca42d55ea€49.00€0.67matched
93capture01a1a861-eecf-7f33-a773-ca4d585d0f6f€15.00€0.26matched
94capture01a1a861-faff-717e-9ba3-9a3dbf809c47€9.00€0.19matched
95capture01a1a862-28e7-7c3b-a6c3-a123bac529c2€35.00€0.50matched
96capture01a1a862-2b07-7284-adbf-a82b4f48e7c9€15.00€0.26matched
97capture01a1a862-6aed-70fd-95cb-662a8ce7367c€9.00€0.19matched
98capture01a1a862-7e2c-7e1e-8aef-ad2276ee0c66€49.00€0.67matched
99capture01a1a862-a731-734d-b428-132e2bb03b56€24.00€0.37matched
100capture01a1a862-d649-7f38-9d55-f8736a881011€24.00€0.37matched
101capture01a1a862-e0ed-7119-bdd2-4200cc0eb54b€15.00€0.26matched
102capture01a1a862-fe16-7420-8085-cc2123038cbd€15.00€0.26matched
103refund01a1a863-0422-7880-9481-1181104fd870-€24.00€0.00matched
104capture01a1a863-093f-760f-9d47-88c7913183cb€35.00€0.50matched
105capture01a1a863-1d0f-721a-ba5c-e8ee239f01a2€9.00€0.19matched
106capture01a1a863-2048-71aa-b0b1-e1cb71ddea68€24.00€0.37matched
107capture01a1a863-2137-7d5a-95df-e7f9cc7f475a€24.00€0.37matched
108capture01a1a863-221c-7a3d-ae85-d83c4a7880d7€49.00€0.67matched
109capture01a1a863-2e2e-7f95-93ab-8297010eb7a2€9.00€0.19matched
110capture01a1a863-3b82-7d68-8602-fc52f83947d5€35.00€0.50matched
111capture01a1a863-476c-7340-a452-b78343baa861€15.00€0.26matched
112capture01a1a863-4a23-7703-b3dc-26da51bc98d9€35.00€0.50matched
113capture01a1a863-5d6f-7500-a8a9-5681f61a209b€49.00€0.67matched
114capture01a1a863-68d5-7f7e-a95b-0e810ee78ac6€35.00€0.50matched
115capture01a1a863-7da8-7749-a307-a3bacbef3e56€15.00€0.26matched
116refund01a1a863-9fbf-7133-93ee-10e7d1279899-€39.00€0.00matched
117capture01a1a863-d9d1-7e2f-8658-26f7200e7895€15.00€0.26matched
118capture01a1a864-084f-7b49-b808-d85abcb24cef€35.00€0.50matched
119capture01a1a864-239f-77cd-af19-8465f460979d€9.00€0.19matched
120capture01a1a864-2974-758e-8a8e-689ce283319f€24.00€0.37matched
121capture01a1a864-2d16-79e1-bc00-58317d976095€49.00€0.67matched
122capture01a1a864-464c-74c8-af0d-1cdd0e9f3568€24.00€0.37matched
123capture01a1a864-4b58-7ccd-bf4f-5c469b84fdee€24.00€0.37matched
124capture01a1a864-4cdb-7146-89f2-4aa6e2dc1ad4€9.00€0.19matched
125capture01a1a864-507f-7e0a-bab6-3053ae23c622€9.00€0.19matched
126capture01a1a864-512c-7963-b03b-bda5eb8789d8€15.00€0.26matched
127capture01a1a864-6b8c-702e-8f1f-8b6eda9ff00b€35.00€0.50matched
128refund01a1a864-72a4-7b98-911d-049c978826c0-€4.00€0.00matched
129capture01a1a864-79ff-7aa2-9913-ce2ccc5fcb80€9.00€0.19matched
130capture01a1a864-7b7b-76b5-b457-65297bb0dba3€9.00€0.19matched
131capture01a1a864-8f16-7f7e-8a96-667e78e01288€15.00€0.26matched
132capture01a1a864-b5c4-770a-90a8-78437331a669€24.00€0.37matched
133capture01a1a864-c9bd-7b7e-ac3d-57146324675f€49.00€0.67matched
134capture01a1a865-0c1d-75c9-b982-f806e70f8550€35.00€0.50matched
135capture01a1a865-5162-75b3-91e2-82022914201f€49.00€0.67matched
136capture01a1a865-5d63-729e-93fd-49ecea51b577€15.00€0.26matched
137capture01a1a865-795b-7368-b2ce-6594d35bbaff€49.00€0.67matched
138capture01a1a865-814d-7042-baf6-6c7169a85ba2€15.00€0.26matched
139capture01a1a865-88b0-758a-ba62-47d663ac26da€15.00€0.26matched
140capture01a1a865-a84c-75f1-afe4-78533569deae€15.00€0.26matched