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, 19:50

Gross

€2,296.00

PSP fee

€38.86

Net to the bank

€2,257.14

Settlement journal

#384942

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a81c-b5c1-71c7-b0ac-28426a11f990 is already settled by stl_EUR_2989703 line 6
  • duplicate linethe file lists it twicecapture:01a1a81f-8f89-7147-9688-928770cc1deb is already settled by stl_EUR_2989703 line 52
  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
  • missing linein the books, not in the filecapture:01a1a81f-cb5d-7459-9d1c-2a62b6798f37 is in no file
LineKindReferenceGrossFeeStatus
7capture01a1a81c-b632-7118-8313-f9cefa0ef5c7€49.00€0.67duplicate line
53capture01a1a81f-8fa5-7a97-9fe7-142ab8419b2b€15.00€0.26duplicate line
63capture01a1a820-88d7-7b5f-befc-311c746e42d5€49.00€0.71fee difference
1capture01a1a816-b293-788c-b2a6-6361932816e8€9.00€0.19matched
2capture01a1a817-43da-7a6e-afd8-776b111e3b6c€35.00€0.50matched
3capture01a1a81c-872d-7a94-b769-e8766e2c2880€15.00€0.26matched
4capture01a1a81c-8794-715f-82fe-166b50c1572d€24.00€0.37matched
5refund01a1a81c-b028-79ca-ab72-ebd38719fbaa-€27.00€0.00matched
6capture01a1a81c-b632-7118-8313-f9cefa0ef5c7€49.00€0.67matched
8capture01a1a81c-b7c0-78e9-ac9f-5b6a2ada9a97€35.00€0.50matched
9capture01a1a81c-da37-7825-8a79-744233c5e5d8€35.00€0.50matched
10capture01a1a81c-de59-7c33-859f-893cbd1e245a€9.00€0.19matched
11capture01a1a81d-01f5-77c3-b86e-5b79a688326a€49.00€0.67matched
12capture01a1a81d-0876-7740-a1ea-69b1d0b8566d€15.00€0.26matched
13capture01a1a81d-0c76-77d3-bbb6-0a97dd02cdd7€35.00€0.50matched
14capture01a1a81d-25e9-7345-a8d0-f96cdc27fe28€49.00€0.67matched
15capture01a1a81d-369a-7b4f-b417-9e874f80cac5€15.00€0.26matched
16capture01a1a81d-4e4b-7bcb-abbd-69583276209d€35.00€0.50matched
17capture01a1a81d-4f0a-7781-8915-c7175970e333€9.00€0.19matched
18capture01a1a81d-54c9-77c8-af7e-e6b875095395€15.00€0.26matched
19capture01a1a81d-65ee-76b5-b41d-95040897f3b4€15.00€0.26matched
20capture01a1a81d-7efb-7c74-b010-5122e12b8500€35.00€0.50matched
21capture01a1a81d-a29d-7c1d-bf39-bfc7227d4c07€24.00€0.37matched
22refund01a1a81d-a74b-7f7e-98eb-2161ca5c1e33-€9.00€0.00matched
23capture01a1a81d-a89a-73e8-9902-e5e53b3e42e8€15.00€0.26matched
24capture01a1a81d-ad93-7761-8bbf-0fa3bb22feaa€24.00€0.37matched
25capture01a1a81d-c113-7816-bec8-b9c3f7e4c0bd€15.00€0.26matched
26refund01a1a81d-c2da-7ceb-aef9-1d80d7b0ff3c-€5.00€0.00matched
27capture01a1a81d-d45c-7d92-87db-62c28df32d71€9.00€0.19matched
28capture01a1a81d-dcfb-76e3-9f5c-4e40536f9929€49.00€0.67matched
29capture01a1a81d-ee75-7e14-8d89-71853ee87ccd€15.00€0.26matched
30capture01a1a81d-ef9a-772f-8874-8909b1b4e6ba€9.00€0.19matched
31capture01a1a81e-0479-7872-9be3-697c1f4b23e4€49.00€0.67matched
32capture01a1a81e-1a97-7041-97ea-c1b128687f81€35.00€0.50matched
33capture01a1a81e-2a72-7a0b-88ff-ca1502fc1a9d€9.00€0.19matched
34refund01a1a81e-2b23-7eef-bf09-503bbb2962fd-€44.00€0.00matched
35capture01a1a81e-5763-7e77-94b1-f1f66524fe5a€24.00€0.37matched
36capture01a1a81e-792e-7df6-8254-f2beb83d32a0€24.00€0.37matched
37capture01a1a81e-7e5f-7fd2-aae0-f87d59e7ed85€9.00€0.19matched
38capture01a1a81e-933f-78bb-a27c-5c05bc66ebf5€35.00€0.50matched
39capture01a1a81e-a73e-7d2f-a569-42486f64fa0d€9.00€0.19matched
40capture01a1a81e-c3a3-7db3-a5df-668f5d9ca8da€35.00€0.50matched
41capture01a1a81e-d340-7498-b07e-4d8db4ddaccf€35.00€0.50matched
42capture01a1a81e-e4e1-76df-8cb7-66604b1728cc€9.00€0.19matched
43capture01a1a81f-2484-7f40-b60a-614956ee1053€15.00€0.26matched
44capture01a1a81f-3afd-79f6-8117-b239cc6636a5€49.00€0.67matched
45refund01a1a81f-4785-7576-98da-358e603124d9-€27.00€0.00matched
46capture01a1a81f-52a7-7bcd-82af-97521d2c4b73€9.00€0.19matched
47capture01a1a81f-6324-7ce5-b379-2b86c1f9c94c€24.00€0.37matched
48capture01a1a81f-6683-7743-be2f-a8d406fb7abe€49.00€0.67matched
49capture01a1a81f-737f-7e91-b21f-2593dd55c16d€15.00€0.26matched
50capture01a1a81f-80b8-7eee-9600-fc3d3c49d6ba€15.00€0.26matched
51capture01a1a81f-8dab-7e9e-956d-06bbe5f96215€9.00€0.19matched
52capture01a1a81f-8fa5-7a97-9fe7-142ab8419b2b€15.00€0.26matched
54refund01a1a81f-9213-7336-af6f-b3fbe12e1411-€21.00€0.00matched
55capture01a1a81f-bc79-76f9-a050-61654588cd89€24.00€0.37matched
56capture01a1a81f-da58-79bc-a139-05d6e88c16c7€49.00€0.67matched
57capture01a1a81f-e265-73e7-8890-a7ea80fa32f4€9.00€0.19matched
58capture01a1a81f-ef76-7b68-a90f-79aff3f6e073€24.00€0.37matched
59capture01a1a81f-f43c-7453-a9e0-56bdb3a564d0€9.00€0.19matched
60refund01a1a820-2d5a-7844-b3d0-dc0ce7c00152-€4.00€0.00matched
61capture01a1a820-6573-7c5c-b5f9-bc9d81f8b62d€49.00€0.67matched
62capture01a1a820-728e-7058-a761-9d8debca022d€35.00€0.50matched
64capture01a1a820-acdf-7ab9-a6ef-6ed531e596c9€15.00€0.26matched
65capture01a1a820-b400-765e-ae33-5c4a07db1628€35.00€0.50matched
66capture01a1a820-ce5e-72bb-9b30-d27656791d65€9.00€0.19matched
67capture01a1a820-e094-7644-8f0b-d11985b656cc€9.00€0.19matched
68capture01a1a821-0d08-736e-9f5e-dea844f89ade€9.00€0.19matched
69capture01a1a821-1092-7a57-9247-226abe81a3ef€9.00€0.19matched
70capture01a1a821-18a5-773d-981e-e412f1ede818€9.00€0.19matched
71capture01a1a821-3870-739b-9cd1-eb5ca7f39c7d€9.00€0.19matched
72refund01a1a821-41ea-7a2d-8332-a0d5a2f3ac8c-€8.00€0.00matched
73capture01a1a821-4ac8-7bee-9fba-135b47401e31€49.00€0.67matched
74capture01a1a821-4b01-75f6-83cb-e02b763822d6€35.00€0.50matched
75capture01a1a821-50d6-7d24-93ed-34a3313164a9€9.00€0.19matched
76capture01a1a821-726e-7429-a5e9-a516e4170993€24.00€0.37matched
77capture01a1a821-732f-7735-9eb4-adaa4b1bf914€15.00€0.26matched
78capture01a1a821-9cf2-71dd-b199-26e7e108d8a9€35.00€0.50matched
79capture01a1a821-c26a-7b83-a26e-50f2f25b8559€24.00€0.37matched
80capture01a1a821-c801-71c4-b666-0d5dedfdc1a0€9.00€0.19matched
81capture01a1a821-f6c7-7a44-9d99-b144b87d894f€9.00€0.19matched
82capture01a1a822-1c9e-7c81-951f-aade9f0d0ab2€9.00€0.19matched
83capture01a1a822-54ae-7375-9465-4057dd6b640c€15.00€0.26matched
84capture01a1a822-5875-7fc2-9bd7-3fe633d7475d€49.00€0.67matched
85capture01a1a822-5e9d-77d1-b1a4-a20059697438€9.00€0.19matched
86capture01a1a822-6164-7939-bc6e-77df9c058842€24.00€0.37matched
87capture01a1a822-9ee3-7d37-b00e-cc211162ae68€24.00€0.37matched
88capture01a1a822-a794-77ed-8710-f777ebc14d70€9.00€0.19matched
89capture01a1a822-abdd-7db9-a9c0-693d93246e19€24.00€0.37matched
90capture01a1a822-b50d-7d66-8fb6-acab37a40062€9.00€0.19matched
91capture01a1a822-bb77-79dd-9684-d570030b5e39€35.00€0.50matched
92capture01a1a822-cb25-764d-b0c8-937e5bb7c77e€15.00€0.26matched
93capture01a1a822-f96b-7d23-8f85-24fe94ad0ac5€9.00€0.19matched
94capture01a1a822-fe16-7695-bd13-09ddbee1acd2€35.00€0.50matched
95capture01a1a823-3389-7864-86d7-524d1f7d7563€49.00€0.67matched
96capture01a1a823-351a-78af-a6e6-e197e044571c€9.00€0.19matched
97capture01a1a823-3dd7-7fd9-a1a0-e20a2166680f€15.00€0.26matched
98capture01a1a823-99d3-7d7e-93e5-08c0800c0056€9.00€0.19matched
99refund01a1a823-a1a0-770d-a23f-38c210ce2d95-€31.00€0.00matched
100capture01a1a823-aefb-710a-a79f-2c4793c41635€9.00€0.19matched
101capture01a1a823-d9ae-7c49-a1f5-fc3e5546633c€9.00€0.19matched
102capture01a1a823-ffe0-7164-a2b7-2aafee619dca€9.00€0.19matched
103capture01a1a824-0846-70c3-9510-0509e76bb69c€49.00€0.67matched
104capture01a1a824-0f94-7368-8bdb-61eeb64de0ba€9.00€0.19matched
105capture01a1a824-2a0d-74e4-8a72-c45b5f4ac70d€35.00€0.50matched
106capture01a1a824-66d3-7522-96b4-a95003d1df9f€35.00€0.50matched
107capture01a1a824-66f0-7eb3-ae68-cdfa48bb07be€24.00€0.37matched
108capture01a1a824-73a5-7f40-a341-d1a9b23de7b5€9.00€0.19matched
109capture01a1a824-abec-74d7-bfb1-afa68f011f15€35.00€0.50matched
110capture01a1a824-d2d0-73b1-8ef1-e7fc52b9fb53€35.00€0.50matched
111capture01a1a825-064d-7c34-b547-0e98e8aa86e5€9.00€0.19matched
112refund01a1a825-0880-70d8-8f64-85e8536fca0c-€32.00€0.00matched
113capture01a1a825-2d27-7497-be02-877e24ae75c2€24.00€0.37matched
114capture01a1a825-386e-72bd-8faf-cac3f9ac5be9€35.00€0.50matched
115capture01a1a825-43b1-779e-b23e-0bad205ee599€15.00€0.26matched
116capture01a1a825-5574-7719-ba99-4cf2b4f654cb€35.00€0.50matched
117capture01a1a825-6fbf-7958-acd0-976ea6f58576€15.00€0.26matched
118capture01a1a825-8266-7d65-af13-500bd84892b1€24.00€0.37matched