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

Gross

€2,516.00

PSP fee

€39.44

Net to the bank

€2,476.56

Settlement journal

#386465

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a88a-de80-75a9-ac2e-b41b6a3f12f4 is already settled by stl_EUR_2989715 line 10
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
LineKindReferenceGrossFeeStatus
9capture01a1a88a-d926-7179-b143-f8359cb37ede€35.00€0.54fee difference
11capture01a1a88a-deaa-7b95-a2f0-8b7ed85c150a€24.00€0.37duplicate line
1capture01a1a882-598d-7284-b034-94552de78b74€9.00€0.19matched
2capture01a1a888-8cbe-75c3-a00f-aede45907cd4€9.00€0.19matched
3capture01a1a88a-77d8-7bde-b5ba-3f7198fd8881€24.00€0.37matched
4capture01a1a88a-8b94-7a69-96f1-74dd13d13851€9.00€0.19matched
5capture01a1a88a-9fb5-70b3-8987-0292fa9e4ec3€49.00€0.67matched
6capture01a1a88a-ab02-7702-825b-9c0022196a01€15.00€0.26matched
7capture01a1a88a-b6c0-7b77-b78c-51f7cd1fe331€15.00€0.26matched
8capture01a1a88a-bb70-71e8-a6ac-f34112c4f411€49.00€0.67matched
10capture01a1a88a-deaa-7b95-a2f0-8b7ed85c150a€24.00€0.37matched
12capture01a1a88b-35c4-7e6a-a024-b6d57bf06500€9.00€0.19matched
13capture01a1a88b-37ec-7171-b4d9-6c5951639ccb€24.00€0.37matched
14capture01a1a88b-3d20-7a1a-aae8-697f0ae7e965€9.00€0.19matched
15capture01a1a88b-6891-740b-808b-744d4944954b€9.00€0.19matched
16capture01a1a88b-68f8-7777-bf35-4911d9dd41e2€9.00€0.19matched
17capture01a1a88b-6920-7d79-bb44-0fef9b87e14f€15.00€0.26matched
18capture01a1a88b-9225-7379-8993-818a06e12e85€9.00€0.19matched
19capture01a1a88b-9a56-7aa4-9ff4-e5e577c24318€9.00€0.19matched
20refund01a1a88b-aa3d-7277-b299-1678b1427396-€13.00€0.00matched
21capture01a1a88b-c96b-72b9-8f8a-317291777554€35.00€0.50matched
22refund01a1a88b-ce99-728c-8228-90baeabce820-€2.00€0.00matched
23capture01a1a88c-1961-79c1-8cd6-ff01a2681fa0€15.00€0.26matched
24capture01a1a88c-281e-73dd-aa76-2d53f043f102€15.00€0.26matched
25capture01a1a88c-3bbe-705b-b975-eb569d1df309€35.00€0.50matched
26capture01a1a88c-526b-781b-a4e2-299bd9f6a281€15.00€0.26matched
27capture01a1a88c-7d71-7821-a68f-7296752f62a6€24.00€0.37matched
28capture01a1a88c-86d8-781a-b346-df149524bbfd€49.00€0.67matched
29capture01a1a88c-894b-77e7-b5b6-526037ba1bc5€35.00€0.50matched
30capture01a1a88c-b25a-7beb-a332-20ac3e47c509€24.00€0.37matched
31capture01a1a88c-bf42-7c95-a62e-d2f38eb36def€49.00€0.67matched
32capture01a1a88c-d6da-757f-a56d-ab8774558cd9€35.00€0.50matched
33refund01a1a88c-e1ae-792d-ab98-98ba54621014-€16.00€0.00matched
34capture01a1a88c-e58c-7eb0-956f-bc3685b655e5€9.00€0.19matched
35capture01a1a88c-e83e-7fb6-bd01-b754544ed162€49.00€0.67matched
36capture01a1a88c-f016-7d5e-9941-5ae2733848fd€35.00€0.50matched
37capture01a1a88c-f1da-7b15-a279-1201108b4188€9.00€0.19matched
38capture01a1a88c-f792-77d4-875d-48041672c40d€9.00€0.19matched
39capture01a1a88d-11a0-78ba-b5da-7b01af1e9d44€24.00€0.37matched
40refund01a1a88d-123a-7cf5-90e0-967ca2280ad8-€7.00€0.00matched
41capture01a1a88d-1cff-7701-aaab-13b21832381a€15.00€0.26matched
42capture01a1a88d-3506-7a80-8566-e8c7426016f5€15.00€0.26matched
43refund01a1a88d-4528-7809-98bf-90bfac794271-€9.00€0.00matched
44capture01a1a88d-4f78-7186-b7b8-e1ca6ec230f7€15.00€0.26matched
45capture01a1a88d-83ea-73bc-9819-fe51970c41ab€9.00€0.19matched
46capture01a1a88d-8fac-7615-b532-4066af65a10b€49.00€0.67matched
47capture01a1a88d-9839-7d75-a45f-0679ac80bdbd€35.00€0.50matched
48capture01a1a88d-b5c6-7d85-bf73-8861df56cbbe€49.00€0.67matched
49capture01a1a88d-b824-7fbd-a4f3-015f6230f94d€49.00€0.67matched
50capture01a1a88d-cfe4-7dd6-a963-397bcca9ac5c€49.00€0.67matched
51capture01a1a88d-e70e-7457-ae23-0408cf89c7eb€15.00€0.26matched
52capture01a1a88d-f2d5-7f35-868e-fbc54a059b43€24.00€0.37matched
53capture01a1a88e-050e-72a1-9c4d-f1fd84aa9ded€9.00€0.19matched
54capture01a1a88e-14de-7c18-8441-0bd43c632f29€35.00€0.50matched
55capture01a1a88e-1f53-7300-a5f0-671e8800d11f€15.00€0.26matched
56capture01a1a88e-43bd-7600-883e-2edf24046af8€35.00€0.50matched
57capture01a1a88e-7298-78f4-9b14-17ea1b0d464c€15.00€0.26matched
58capture01a1a88e-76c8-7a36-bbd1-1b307e47c012€35.00€0.50matched
59capture01a1a88e-920a-72a2-a483-d79678ff37fc€9.00€0.19matched
60capture01a1a88e-b8bb-7f8d-bbf0-ec5498662695€9.00€0.19matched
61capture01a1a88e-b93f-7294-92d2-f771ee7926e4€35.00€0.50matched
62capture01a1a88e-dead-7312-b74c-655e09b7b865€15.00€0.26matched
63capture01a1a88e-e026-707b-bec2-c8c4687939b5€9.00€0.19matched
64capture01a1a88e-ff4a-77f8-961b-07e9af7907dc€9.00€0.19matched
65capture01a1a88f-18ef-79df-baa5-2f733ca0960a€49.00€0.67matched
66capture01a1a88f-31eb-714e-b84b-32b0b4397520€24.00€0.37matched
67capture01a1a88f-497e-7f8f-8fcb-9591ef80b1d2€24.00€0.37matched
68capture01a1a88f-4c16-70c8-baf5-9044f724a370€49.00€0.67matched
69capture01a1a88f-587a-731e-b415-660ad537c398€24.00€0.37matched
70capture01a1a88f-637e-7811-a2e1-4dcab9877961€49.00€0.67matched
71capture01a1a88f-6fdc-7876-97b6-034d5c46b5c1€35.00€0.50matched
72capture01a1a88f-aa85-7a0f-b96c-e75511f4291b€15.00€0.26matched
73refund01a1a88f-c370-7479-996c-b633209261a0-€11.00€0.00matched
74capture01a1a88f-cbf3-71fb-9bfd-a69494207660€24.00€0.37matched
75capture01a1a88f-f757-7ce3-b6d4-d4389739321c€24.00€0.37matched
76capture01a1a88f-f247-7e19-aa3c-6e9944d99dc9€35.00€0.50matched
77capture01a1a88f-fbdb-746a-902f-c9559f0c3c17€24.00€0.37matched
78capture01a1a88f-ff0f-7fa4-8490-6e787ff9e651€49.00€0.67matched
79capture01a1a890-2241-7295-8f4f-4cbec76a58a7€35.00€0.50matched
80capture01a1a890-27f5-76da-a0a8-42b0516b420f€24.00€0.37matched
81capture01a1a890-299e-77d0-8204-9b10da8cd771€35.00€0.50matched
82capture01a1a890-48be-76dc-a4a6-533dedc37ea6€15.00€0.26matched
83capture01a1a890-5728-783b-8f45-8285672d78cd€24.00€0.37matched
84capture01a1a890-5afd-793a-8042-a910ef14fe28€24.00€0.37matched
85capture01a1a890-83a0-7640-a317-4c68e6c0d415€15.00€0.26matched
86capture01a1a890-85c7-711b-b924-fa830c357bc8€49.00€0.67matched
87refund01a1a890-9390-76d6-8df5-dfa83191aeea-€5.00€0.00matched
88capture01a1a890-efde-720b-93fa-a5516ca5b6a3€9.00€0.19matched
89capture01a1a891-0613-71bf-805a-30fb26914cab€24.00€0.37matched
90capture01a1a891-1c6a-7056-bb20-281f886e67df€9.00€0.19matched
91capture01a1a891-1e6a-7268-9e55-bf274c3afac2€15.00€0.26matched
92capture01a1a891-4eb6-7226-85d5-a7abb0df6a55€35.00€0.50matched
93capture01a1a891-541b-70f2-8f01-e82e3a32132e€49.00€0.67matched
94capture01a1a891-666b-7cec-8421-97e1bbe33160€9.00€0.19matched
95capture01a1a891-849f-70f5-9f88-c74617104a7a€15.00€0.26matched
96capture01a1a891-8604-7e47-aac8-31361ba44238€15.00€0.26matched
97capture01a1a891-8eab-718d-b932-9ced3c428a6e€24.00€0.37matched
98capture01a1a891-9160-76b1-a823-25551a428bd2€49.00€0.67matched
99capture01a1a891-a4d5-736e-be3a-128f24bbf1a4€15.00€0.26matched
100capture01a1a891-b0ab-7a68-9276-bef6ec6ee480€9.00€0.19matched
101capture01a1a891-df10-7fdb-aaf2-537924331d0f€35.00€0.50matched
102capture01a1a891-df63-7910-b4c8-65299d3ac3ab€49.00€0.67matched
103capture01a1a891-dfc4-7ff3-aa6e-916e3fedfe31€9.00€0.19matched
104capture01a1a892-02a1-726d-a905-8b5d07058a4e€49.00€0.67matched
105capture01a1a892-2ea7-755a-94b0-72d484c09890€24.00€0.37matched
106capture01a1a892-3694-7d3c-b6db-237998ea2a1c€9.00€0.19matched
107capture01a1a892-582d-7f2b-83bf-fc3b4d651780€9.00€0.19matched
108capture01a1a892-b14e-7979-873e-5d6dae81d640€9.00€0.19matched
109capture01a1a892-c523-73d0-b514-0c5633a17bf3€15.00€0.26matched
110capture01a1a892-efa6-76cf-afaf-ffbcd9d33789€49.00€0.67matched
111capture01a1a893-5729-7654-8fa2-204c9d11218e€24.00€0.37matched