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

5 Nov, 05:20

Gross

€2,638.00

PSP fee

€40.44

Net to the bank

€2,597.56

Settlement journal

#392219

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aa2a-4570-755e-b53c-ef498782f87c is already settled by stl_EUR_2989760 line 38
LineKindReferenceGrossFeeStatus
39capture01a1aa2a-4d5f-7a3c-8538-6888272f36c1€9.00€0.19duplicate line
1refund01a1aa1e-5c42-7ee5-bcea-6b2e0c292620-€32.00€0.00matched
2capture01a1aa1e-72d8-7e5e-8116-8065f22831d3€49.00€0.67matched
3capture01a1aa1f-6970-778d-9919-a0a5e880fb10€15.00€0.26matched
4refund01a1aa20-734e-78c3-8d4c-77ad66e9747c-€13.00€0.00matched
5capture01a1aa23-9e9d-7c59-b663-4ae9ca5ec53d€35.00€0.50matched
6capture01a1aa26-1e77-7bc1-9de8-a1aa1e15508b€49.00€0.67matched
7capture01a1aa26-6b20-753f-9a7f-dce589f08994€9.00€0.19matched
8capture01a1aa26-88ca-736f-8161-6f42d5adade2€15.00€0.26matched
9capture01a1aa26-d42a-7bf2-8001-6096041253de€9.00€0.19matched
10capture01a1aa27-0aef-7086-8a14-4acfd9c13a2a€49.00€0.67matched
11capture01a1aa27-89ba-79ac-ad27-6616377195df€9.00€0.19matched
12capture01a1aa27-c639-71be-a738-a15d0e2acda6€24.00€0.37matched
13capture01a1aa27-f1b0-7ca6-ba08-79298958d756€24.00€0.37matched
14capture01a1aa28-0d8c-729e-b0ce-9a17631fc92b€15.00€0.26matched
15capture01a1aa28-1a19-74c3-adad-89431cf4c375€35.00€0.50matched
16capture01a1aa28-1c48-7142-af4c-d1e87377d176€9.00€0.19matched
17capture01a1aa28-3870-7554-a63c-e88104e3fe0d€15.00€0.26matched
18capture01a1aa28-3fad-7415-a834-580c96ac9dab€35.00€0.50matched
19capture01a1aa28-4144-7de8-b532-9d632ce629b7€49.00€0.67matched
20capture01a1aa28-8ac6-7f29-8a4f-1dc102a4a797€35.00€0.50matched
21capture01a1aa28-9118-7d9b-b999-a6c9ae56247e€35.00€0.50matched
22capture01a1aa28-bf8e-725f-b8e9-95ced3ee1966€9.00€0.19matched
23capture01a1aa28-c777-79a8-9123-e2d37ee66695€9.00€0.19matched
24capture01a1aa28-ffaa-7595-b1d7-d539e678df6a€49.00€0.67matched
25capture01a1aa29-161b-75c2-9414-b70eddba2b13€49.00€0.67matched
26capture01a1aa29-409d-7b52-b7c2-d09e43a7c7f4€49.00€0.67matched
27capture01a1aa29-6a91-7e46-8666-672e1818bdca€49.00€0.67matched
28capture01a1aa29-6ce9-7bcb-bada-f7f08e2eeabe€9.00€0.19matched
29capture01a1aa29-7f1b-7818-af32-ec546bd55556€15.00€0.26matched
30capture01a1aa29-9616-7726-93fb-8bc85fe46cc1€15.00€0.26matched
31capture01a1aa29-d8c2-7b24-9241-e1a15822c20c€15.00€0.26matched
32capture01a1aa29-f1ac-7315-b1fe-917fd3851c22€49.00€0.67matched
33refund01a1aa2a-0950-751e-92ce-40146fdb6e9f-€4.00€0.00matched
34capture01a1aa2a-0e1c-742e-952d-7785143e44d2€35.00€0.50matched
35capture01a1aa2a-15cb-7bc8-9342-4d620b599d44€35.00€0.50matched
36capture01a1aa2a-4245-752e-b6b1-b119c2cab640€49.00€0.67matched
37capture01a1aa2a-45ba-72bf-9bb9-72a618778e6f€15.00€0.26matched
38capture01a1aa2a-4d5f-7a3c-8538-6888272f36c1€9.00€0.19matched
40capture01a1aa2a-5cc0-7ea4-b126-36707d42d1db€24.00€0.37matched
41refund01a1aa2a-7a72-72c9-95be-875d7e823218-€6.00€0.00matched
42capture01a1aa2a-8905-7d4d-ba5b-8462a6567c26€35.00€0.50matched
43capture01a1aa2a-8ac2-700a-be15-90d87d566920€9.00€0.19matched
44capture01a1aa2a-9e3f-7a47-b9ef-25be7ffd3502€49.00€0.67matched
45capture01a1aa2a-b040-79c5-9678-0a71b6a03dd5€15.00€0.26matched
46capture01a1aa2a-bf12-7cbf-82f6-778c28b5c311€9.00€0.19matched
47capture01a1aa2a-bf4d-7286-b99a-bbd206bf6c69€49.00€0.67matched
48capture01a1aa2a-c6c1-742f-a975-3b2f119f9b08€15.00€0.26matched
49capture01a1aa2a-cb37-77a9-b675-f3c8615fb10d€15.00€0.26matched
50capture01a1aa2a-f149-7b87-b63c-d128fc7e3258€35.00€0.50matched
51capture01a1aa2b-40cf-7cc4-9c0b-4cd2e1066fe8€49.00€0.67matched
52capture01a1aa2b-4b16-7985-a7a2-a1288cfba318€49.00€0.67matched
53capture01a1aa2b-525a-7a17-ab90-9a2c5540be78€49.00€0.67matched
54capture01a1aa2b-5dab-7e5d-9833-83f74793ba68€15.00€0.26matched
55capture01a1aa2b-5db9-7fcb-8faf-97e2e67b6350€49.00€0.67matched
56capture01a1aa2b-5de5-74ef-81f3-4f050a2d5b82€49.00€0.67matched
57capture01a1aa2b-9808-7818-95b4-41c73868f9d8€35.00€0.50matched
58capture01a1aa2b-9b68-72aa-ac9a-248a10fc40ba€15.00€0.26matched
59capture01a1aa2b-b9c3-7d66-ab85-72d4c78975ac€35.00€0.50matched
60capture01a1aa2b-e3d1-7c2c-857c-d68436ac220c€49.00€0.67matched
61capture01a1aa2b-f4fa-7f86-a3bb-fc34f542da0a€15.00€0.26matched
62capture01a1aa2c-06ff-7613-a91a-98fb0207bb3d€49.00€0.67matched
63capture01a1aa2c-1258-70e1-899c-ebb5b444ff6e€15.00€0.26matched
64capture01a1aa2c-2058-782f-8cb4-154f59929ae4€49.00€0.67matched
65capture01a1aa2c-2546-7957-8a13-e68796f164a9€9.00€0.19matched
66capture01a1aa2c-2ece-79fc-a3a5-cc22f0da3acf€15.00€0.26matched
67capture01a1aa2c-30ab-768f-8ff8-acad00c4befb€15.00€0.26matched
68capture01a1aa2c-7157-72e6-8cbd-e86fa0312be6€35.00€0.50matched
69capture01a1aa2c-82a4-710d-82d1-f6e09d07baac€24.00€0.37matched
70capture01a1aa2c-b0d9-767a-8adf-e93a5699f558€35.00€0.50matched
71capture01a1aa2c-b7d7-703b-96dc-d601e28ef74c€24.00€0.37matched
72capture01a1aa2c-c302-71c6-98c6-d62ab85e966a€24.00€0.37matched
73capture01a1aa2c-e725-7c3d-ad2d-27a610fd18fa€9.00€0.19matched
74capture01a1aa2d-12d2-7ef8-8477-eab041255629€15.00€0.26matched
75capture01a1aa2d-34a9-7a9e-ae77-13917d80d407€24.00€0.37matched
76capture01a1aa2d-5a3e-7dc9-b898-1b1c9b6898af€9.00€0.19matched
77capture01a1aa2d-82e1-7193-9141-0bded5bb69d4€9.00€0.19matched
78capture01a1aa2d-9cae-78ac-afb6-8ce1563048d7€24.00€0.37matched
79capture01a1aa2d-9d7b-77e2-ac43-19b86f18b2b4€9.00€0.19matched
80capture01a1aa2d-b904-706a-8c97-21b2bd026cf9€49.00€0.67matched
81capture01a1aa2d-de00-704d-87bb-884fff833ec7€49.00€0.67matched
82capture01a1aa2d-ee79-76f5-9249-4745fa0c0103€35.00€0.50matched
83capture01a1aa2e-1074-7842-8928-494919089ec6€35.00€0.50matched
84capture01a1aa2e-30be-74b9-9cc8-1db275bac589€24.00€0.37matched
85capture01a1aa2e-474b-7089-8b3e-cc01b63eb163€35.00€0.50matched
86capture01a1aa2e-6155-7c63-b09f-8b63ea6bbeb3€35.00€0.50matched
87capture01a1aa2e-7b69-7469-aa2e-c4b346d5b775€9.00€0.19matched
88capture01a1aa2e-856d-70e6-864c-918a936296e7€49.00€0.67matched
89capture01a1aa2e-95ba-7cbd-875b-a7f795203eca€49.00€0.67matched
90capture01a1aa2e-95e9-7ece-8c3c-caa4cb371ffa€35.00€0.50matched
91capture01a1aa2e-a7ac-79c9-98d2-5af963b1faaa€9.00€0.19matched
92capture01a1aa2e-b5ca-7fda-92db-8fbab2fa816c€49.00€0.67matched
93capture01a1aa2e-b818-7ee9-8ee9-59f1f702b058€35.00€0.50matched
94capture01a1aa2e-b849-72f0-ba77-ee5b07127b1c€24.00€0.37matched
95capture01a1aa2e-cc32-7b42-a8fc-d82ca915da01€15.00€0.26matched
96capture01a1aa2e-ff8b-7528-93c1-27f34a711f61€35.00€0.50matched
97capture01a1aa2f-1280-73c9-bc0e-d9578adeb766€35.00€0.50matched
98capture01a1aa2f-138c-701b-a8de-e5cfc4889b58€24.00€0.37matched
99refund01a1aa2f-2b4e-74c3-a94f-13506b33bf65-€9.00€0.00matched
100capture01a1aa2f-4627-7890-93a5-8adf377b5353€35.00€0.50matched
101capture01a1aa2f-4f2b-7213-ac9d-1ede99444aee€15.00€0.26matched
102refund01a1aa2f-6ef0-7c7b-9551-f4cefc34e514-€19.00€0.00matched