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, 06:10

Gross

€1,922.00

PSP fee

€31.50

Net to the bank

€1,890.50

Settlement journal

#374518

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a52f-834b-7758-aeba-84b3a5312159 is already settled by stl_EUR_2989621 line 21
  • missing linein the books, not in the filecapture:01a1a52f-aa73-70fa-9eac-b627508d2d7a is in no file
  • missing linein the books, not in the filecapture:01a1a534-e8ef-783f-a4ee-3f4395c1523f is in no file
  • missing linein the books, not in the filecapture:01a1a535-9e8a-7dfe-91fe-f236fb083327 is in no file
LineKindReferenceGrossFeeStatus
22capture01a1a52f-8371-72d8-90b9-e9d2f625e5f6€49.00€0.67duplicate line
1capture01a1a527-7de9-7dd0-ac2b-c427a3581985€9.00€0.19matched
2capture01a1a527-b4a6-7496-9217-ed778fb9e0ea€49.00€0.67matched
3capture01a1a52d-c93c-7f7d-9c29-28e11062b010€9.00€0.19matched
4capture01a1a52d-d1be-731d-b557-c8e4fe95c7a7€35.00€0.50matched
5capture01a1a52d-ed68-760f-bbb0-01c94eaa2534€15.00€0.26matched
6capture01a1a52e-11ad-7fcb-8e5d-f874072bc770€9.00€0.19matched
7capture01a1a52e-4142-7124-a7dc-43f60a2ecd56€24.00€0.37matched
8capture01a1a52e-4ff2-7b9e-8ef5-aab80236180c€15.00€0.26matched
9capture01a1a52e-5e33-7e2a-9d65-7df523f04ed9€15.00€0.26matched
10capture01a1a52e-b61d-7ee0-9728-1890f8412221€49.00€0.67matched
11capture01a1a52e-ba04-7589-9748-46313903b8a7€24.00€0.37matched
12capture01a1a52e-c4db-7855-be57-c7dfb80077b3€9.00€0.19matched
13capture01a1a52e-c624-7ec8-a98e-5a3444d9cac8€49.00€0.67matched
14capture01a1a52f-093f-7457-bcac-423286c825ad€35.00€0.50matched
15capture01a1a52f-1cef-7d5e-9b33-87d29eb91e72€9.00€0.19matched
16capture01a1a52f-1dac-709e-8299-e7ba43031286€24.00€0.37matched
17capture01a1a52f-37d6-7013-851d-64f533534da1€9.00€0.19matched
18capture01a1a52f-617b-7a4d-a6c0-9839a74c73d9€35.00€0.50matched
19capture01a1a52f-63da-767b-9b11-b09d5b22b124€15.00€0.26matched
20capture01a1a52f-7d86-7e16-8481-a3dcc272bf74€9.00€0.19matched
21capture01a1a52f-8371-72d8-90b9-e9d2f625e5f6€49.00€0.67matched
23refund01a1a52f-8c38-7c4e-9f15-ed8867c9d264-€24.00€0.00matched
24capture01a1a52f-947c-7e7a-b80e-e5cecfc2bbee€24.00€0.37matched
25capture01a1a52f-c10c-7a13-a225-35667a09a12a€9.00€0.19matched
26capture01a1a52f-dbb2-7fe6-9973-1fe49424e4ba€49.00€0.67matched
27capture01a1a530-06d9-7edb-8c65-daad96bbdd23€9.00€0.19matched
28capture01a1a530-0e9a-750a-a471-bc6cf14fdfab€35.00€0.50matched
29refund01a1a530-1645-70cd-b4fc-e88f0760023c-€48.00€0.00matched
30capture01a1a530-1306-745c-bcd9-bb11cb95c511€15.00€0.26matched
31capture01a1a530-25b9-76b9-96e2-bf0b4d707c0c€35.00€0.50matched
32capture01a1a530-291d-7a34-9dcf-1b9a0de8a7fc€35.00€0.50matched
33capture01a1a530-76a6-7aae-9187-61e9d6a4ca10€9.00€0.19matched
34refund01a1a530-8ac2-7d35-b685-21f22424254c-€8.00€0.00matched
35capture01a1a530-90d2-71ac-a857-8f22fa406920€35.00€0.50matched
36capture01a1a530-9100-7d2a-8238-bf38bac8bd70€35.00€0.50matched
37refund01a1a530-977a-7699-bb09-4aa84ec50f5a-€12.00€0.00matched
38capture01a1a530-97ab-7179-92a3-d48b3fc70678€35.00€0.50matched
39capture01a1a530-9806-7792-b6ae-3ccee69ff499€9.00€0.19matched
40capture01a1a530-a14d-7e88-a287-c09d4692eee0€49.00€0.67matched
41capture01a1a531-1f8e-77d8-b83c-a13e1e75eab0€15.00€0.26matched
42capture01a1a531-240c-7571-8117-a1175d6a0a00€15.00€0.26matched
43capture01a1a531-305f-7c18-8dff-58157195df1b€24.00€0.37matched
44capture01a1a531-44ab-7674-b164-8ac9578fb20a€15.00€0.26matched
45capture01a1a531-5f27-741c-ba17-40ac34c7bd71€15.00€0.26matched
46capture01a1a531-6022-782d-b0a8-54b775b350b8€9.00€0.19matched
47capture01a1a531-6bbb-7659-b2d7-2a3b9b692dad€24.00€0.37matched
48capture01a1a531-bd5d-753f-b9eb-f43e0aa91389€24.00€0.37matched
49capture01a1a531-c1d7-764a-b84e-41fd3df01250€15.00€0.26matched
50refund01a1a532-0ce2-7443-a8b5-65276783a444-€24.00€0.00matched
51capture01a1a532-2516-754c-85f7-0121f3e008e0€9.00€0.19matched
52capture01a1a532-2e58-7349-beff-558b0a2288f5€49.00€0.67matched
53capture01a1a532-3a79-7e30-a52f-16162436bf8a€9.00€0.19matched
54capture01a1a532-3b26-7e6c-913d-fa0ffdf04af3€9.00€0.19matched
55capture01a1a532-5056-761a-9314-5f59cac64206€49.00€0.67matched
56capture01a1a532-582d-7c5b-b8a4-429755455225€9.00€0.19matched
57capture01a1a532-8055-7f4d-a8f1-18db86cc671e€15.00€0.26matched
58capture01a1a532-85bb-7f4c-b511-66c49a00a33e€35.00€0.50matched
59capture01a1a532-ecb7-7a26-9b82-64796808b497€15.00€0.26matched
60capture01a1a533-00d3-7cae-88ef-e7b1111f7323€15.00€0.26matched
61capture01a1a533-197d-73cf-b649-58cfae58888a€24.00€0.37matched
62capture01a1a533-3563-7996-bf27-2b879df9ae23€49.00€0.67matched
63capture01a1a533-395e-7984-ab44-2b16f071b901€24.00€0.37matched
64capture01a1a533-5a5b-7f0e-834c-d3b8e0c7c8d6€9.00€0.19matched
65capture01a1a533-cc5c-7c63-b88b-f5658bb85258€9.00€0.19matched
66capture01a1a533-d131-711a-a198-738e350b65ba€49.00€0.67matched
67capture01a1a533-f041-7eaf-81ff-f3dfa5aa9dd9€24.00€0.37matched
68capture01a1a533-f4fb-727d-a135-57ff5ee39592€15.00€0.26matched
69capture01a1a533-f67a-7bbe-a9ff-d5453e4e8f9e€49.00€0.67matched
70capture01a1a534-0492-7581-820c-1c4dabd2c9d8€9.00€0.19matched
71capture01a1a534-4834-7508-b5a8-bdbdaa1f90d2€49.00€0.67matched
72capture01a1a534-564e-7efa-8725-b5bf32b8d4e1€9.00€0.19matched
73capture01a1a534-64cc-79b5-9773-68cf9c21c070€35.00€0.50matched
74capture01a1a534-716f-72ff-845e-ba5fe06ac8b6€35.00€0.50matched
75capture01a1a534-8eb5-7536-8be9-31b52151d23d€15.00€0.26matched
76capture01a1a534-aa74-794d-b8b7-79fc16ec4302€35.00€0.50matched
77capture01a1a534-e4bd-73a6-8cc4-edb851e0c542€15.00€0.26matched
78capture01a1a534-ea0d-7c2c-94e3-68bfee7fd5ac€15.00€0.26matched
79capture01a1a535-3868-7742-8c50-5be009f37a7b€9.00€0.19matched
80capture01a1a535-646b-7dbf-9717-c74a19aaebe0€9.00€0.19matched
81capture01a1a535-8c7d-7559-9a7e-1974e6807758€15.00€0.26matched
82capture01a1a535-d5d9-72ff-beb2-1e56d27a2c03€9.00€0.19matched
83capture01a1a535-eaa0-7754-82e2-a4c149cde2ae€49.00€0.67matched
84capture01a1a535-f455-7780-bc0a-759e340ff7fb€9.00€0.19matched
85capture01a1a535-fac5-7456-af0f-2da8602104cf€9.00€0.19matched
86refund01a1a536-1cfd-72dd-a72c-8f311abfdef8-€5.00€0.00matched
87capture01a1a536-2ecf-7b84-a700-da3f91309dd4€9.00€0.19matched
88capture01a1a536-5bc6-77a5-a8e6-193d282800f8€49.00€0.67matched
89capture01a1a536-7487-78be-8b4b-8fe7ee1a65ae€35.00€0.50matched
90capture01a1a536-763c-7829-b3e8-f74aefe4ae3e€15.00€0.26matched
91capture01a1a536-7f39-760b-8480-de3a2be10b22€35.00€0.50matched
92capture01a1a536-99ee-7478-a3e0-763c91ba8359€24.00€0.37matched