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

Gross

€3,128.00

PSP fee

€49.70

Net to the bank

€3,078.30

Settlement journal

#372276

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a48b-ae9f-7258-858e-1b0ab631f236 is already settled by stl_EUR_2989603 line 40
  • duplicate linethe file lists it twicecapture:01a1a48d-c84b-73b0-8666-7886868128d0 is already settled by stl_EUR_2989603 line 76
  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
LineKindReferenceGrossFeeStatus
16capture01a1a48a-098d-7ba7-9053-1a5ee1586f1b€15.00€0.31fee difference
41capture01a1a48b-aef8-7da9-b4ff-c869f1e72dbc€9.00€0.19duplicate line
50capture01a1a48b-fdbe-78ab-bdcd-39e3935fc1a3€49.00€0.68fee difference
72capture01a1a48d-53ce-7d50-a030-98292d7b1e75€35.00€0.51fee difference
77capture01a1a48d-c872-7380-90bf-69c16d37ef15€24.00€0.37duplicate line
1capture01a1a480-f62b-74be-8043-fca05f2494ce€24.00€0.37matched
2capture01a1a482-4180-7bc4-9631-e59f4438ca24€9.00€0.19matched
3refund01a1a483-4529-7843-96df-fab024bda6cc-€7.00€0.00matched
4capture01a1a489-34c8-7156-981f-fcadb9b7871a€35.00€0.50matched
5capture01a1a489-3ade-768f-8c96-f490a65185a1€24.00€0.37matched
6capture01a1a489-5fef-7f74-93c2-e6bccbd01914€49.00€0.67matched
7capture01a1a489-88cb-7377-ba03-2b91247c92d7€9.00€0.19matched
8capture01a1a489-8a3e-7d2d-b7cd-c6c6a4b72001€49.00€0.67matched
9capture01a1a489-8e8d-7572-82e7-9785be36d48c€24.00€0.37matched
10capture01a1a489-9991-7915-a43c-1783f6bd9ed3€24.00€0.37matched
11capture01a1a489-9b64-75af-91d0-7c65fe13c8b3€15.00€0.26matched
12capture01a1a489-e038-79fe-94d9-bf3c90158fb2€49.00€0.67matched
13capture01a1a489-e6bf-78e2-99f0-ddbc5100ee06€24.00€0.37matched
14capture01a1a489-eb59-7bc0-9f05-df37c5892124€15.00€0.26matched
15capture01a1a48a-0842-7377-bd7c-fd102124e818€15.00€0.26matched
17capture01a1a48a-10a0-7331-89bc-3c493a0241e6€35.00€0.50matched
18capture01a1a48a-292a-7f4c-bf8f-6557eb06e200€15.00€0.26matched
19capture01a1a48a-4157-7e6d-a57f-f42735cc1b42€49.00€0.67matched
20capture01a1a48a-5652-7a43-a952-6a9a34f20998€15.00€0.26matched
21capture01a1a48a-5c11-7a80-baf2-cee57c960845€49.00€0.67matched
22capture01a1a48a-5d97-7225-a029-3fafa77b571e€9.00€0.19matched
23capture01a1a48a-6f15-7f75-af70-1863b4fb1542€15.00€0.26matched
24capture01a1a48a-7412-7e21-8197-fbab57599336€15.00€0.26matched
25capture01a1a48a-8142-771c-993e-34a0bb0dd29d€24.00€0.37matched
26capture01a1a48a-90ca-75d3-b945-75bea69936e5€15.00€0.26matched
27capture01a1a48a-bb72-7b9c-a864-f61f9c841ce3€49.00€0.67matched
28capture01a1a48a-c265-7356-a8bf-f423d3dd1ea9€24.00€0.37matched
29capture01a1a48a-c5a6-7820-81cb-b91dcc906959€9.00€0.19matched
30capture01a1a48a-c7f7-7325-a1d5-3ef957a37160€15.00€0.26matched
31capture01a1a48a-d120-7030-bf0a-78e29dac7376€15.00€0.26matched
32capture01a1a48a-d859-7fb3-ace0-248234377e04€9.00€0.19matched
33capture01a1a48a-de88-7d88-9aff-49070512c06d€35.00€0.50matched
34capture01a1a48a-e7fa-70a8-bb5c-6fc46446763f€24.00€0.37matched
35capture01a1a48b-16b3-7c3d-83c0-f65c6ea7fb4d€49.00€0.67matched
36capture01a1a48b-3573-7c21-ac8d-0b2790fb9279€15.00€0.26matched
37capture01a1a48b-3e38-780f-b453-7b75f9b7db2b€49.00€0.67matched
38capture01a1a48b-60ad-7e3c-8a9b-49c1a150fc61€35.00€0.50matched
39capture01a1a48b-9c68-72da-91d2-9cbc4a2c4e86€35.00€0.50matched
40capture01a1a48b-aef8-7da9-b4ff-c869f1e72dbc€9.00€0.19matched
42capture01a1a48b-ba59-74ac-b4be-e5b0984aa8eb€24.00€0.37matched
43capture01a1a48b-cf7c-7fe9-9731-e3bf22c26bf3€15.00€0.26matched
44capture01a1a48b-d662-7d19-a206-7db6eef226bf€9.00€0.19matched
45capture01a1a48b-e77c-78ce-bf7a-fe75b239653e€49.00€0.67matched
46capture01a1a48b-ed1a-7123-bb59-337885ed82a2€24.00€0.37matched
47capture01a1a48b-f35e-725f-8193-c65f2667f34b€9.00€0.19matched
48capture01a1a48b-f489-7468-ac68-f1357b5559e5€35.00€0.50matched
49capture01a1a48b-f7e2-7294-a24c-1789aacbd9d4€15.00€0.26matched
51capture01a1a48c-14e5-7f95-8713-c2e7ea4c2b84€9.00€0.19matched
52refund01a1a48c-1670-781c-ad49-72d745536f5e-€2.00€0.00matched
53capture01a1a48c-1db5-707f-bada-3b32829f8a3d€9.00€0.19matched
54refund01a1a48c-2b31-7a74-997b-f8609db6f215-€7.00€0.00matched
55capture01a1a48c-45b3-75ae-bb76-ef6a6885926e€49.00€0.67matched
56refund01a1a48c-604d-77ce-85d9-0b5575c2f5cc-€35.00€0.00matched
57capture01a1a48c-66cc-76a6-beb2-8b1c70f0dfc3€35.00€0.50matched
58capture01a1a48c-6c3b-7a52-bbbd-e2f9751a3aff€24.00€0.37matched
59capture01a1a48c-75ea-7b3f-b497-7fe79d557870€49.00€0.67matched
60capture01a1a48c-82cc-7cd1-bb20-f68c1b3348a8€9.00€0.19matched
61capture01a1a48c-8fbf-7317-b2c3-64724a63f72c€35.00€0.50matched
62capture01a1a48c-b4e8-7f37-9f14-c5e5f215b5c0€24.00€0.37matched
63refund01a1a48c-b687-75ea-961a-9acc0f6c2244-€5.00€0.00matched
64refund01a1a48c-c158-7744-8a80-c983edd2d905-€8.00€0.00matched
65capture01a1a48c-fcb1-70d8-aee7-ede934a12dc9€35.00€0.50matched
66capture01a1a48d-1443-7e6a-b1fc-8edcc88a26c5€15.00€0.26matched
67capture01a1a48d-14f4-77ca-95ad-ea4aaba08feb€49.00€0.67matched
68capture01a1a48d-1ef2-7edb-b3ae-e0dc063464c3€49.00€0.67matched
69capture01a1a48d-1f8b-79f2-915b-aa32fb915711€9.00€0.19matched
70capture01a1a48d-267b-762f-a053-868e77d1958b€24.00€0.37matched
71capture01a1a48d-443d-719b-9dc1-0ff91ecb08e9€15.00€0.26matched
73capture01a1a48d-7a98-7716-9e14-cc9ffb4b3b9d€24.00€0.37matched
74capture01a1a48d-98eb-74d2-b979-fac7beba56d1€15.00€0.26matched
75capture01a1a48d-a44c-7f79-94f4-c7d8fac174a8€24.00€0.37matched
76capture01a1a48d-c872-7380-90bf-69c16d37ef15€24.00€0.37matched
78capture01a1a48d-ccfe-7094-a6bb-a4880a6cc51c€9.00€0.19matched
79capture01a1a48d-d952-706a-bbc6-7380f7ac8267€15.00€0.26matched
80capture01a1a48d-e932-782f-bd3a-d10b8f3f79cc€49.00€0.67matched
81capture01a1a48d-f090-7250-b12d-761c77777c59€49.00€0.67matched
82capture01a1a48d-f278-77d1-9b4a-e9f16e929443€15.00€0.26matched
83capture01a1a48e-2eee-7832-b0c3-b862585807dc€15.00€0.26matched
84capture01a1a48e-33e3-74ea-94c4-7310f636904b€24.00€0.37matched
85capture01a1a48e-4a52-76de-b17e-04637a6637ae€15.00€0.26matched
86capture01a1a48e-4b3f-7ef3-a15b-a008a0f9668e€9.00€0.19matched
87capture01a1a48e-52b3-78a1-a592-40c69074a593€35.00€0.50matched
88capture01a1a48e-5743-7e57-9e2a-9afa2114ee8e€9.00€0.19matched
89capture01a1a48e-6f8a-7328-a83c-1b9587671d9e€24.00€0.37matched
90capture01a1a48e-8016-72f1-b3f4-2b80f78ce279€35.00€0.50matched
91capture01a1a48e-ac89-7f22-a0c4-b5804099e1c4€9.00€0.19matched
92capture01a1a48e-c24c-74e2-9ce6-396bf9778493€15.00€0.26matched
93capture01a1a48e-c343-73f9-8aa9-a70f1d94a28a€49.00€0.67matched
94capture01a1a48e-c484-72a9-a097-9512ab2f7a6d€49.00€0.67matched
95capture01a1a48e-ce2c-7fd8-a0f6-0e90dd6b297f€9.00€0.19matched
96capture01a1a48e-e323-76dc-bab5-ddb46b0f2d2d€49.00€0.67matched
97capture01a1a48e-e41a-7bd9-96ad-a877171c1a3d€9.00€0.19matched
98capture01a1a48f-0a03-73df-8385-3417db1a60c0€35.00€0.50matched
99capture01a1a48f-2b8e-7916-a2ab-19491669c94e€24.00€0.37matched
100capture01a1a48f-40ca-7a8b-98db-5aaa7498f642€15.00€0.26matched
101refund01a1a48f-54aa-77d6-9586-005c4fd23c51-€34.00€0.00matched
102capture01a1a48f-657b-72df-8bc4-b5b78e4aff25€9.00€0.19matched
103capture01a1a48f-7a49-72d5-bfc6-6c82a01c977d€15.00€0.26matched
104capture01a1a48f-8afa-7062-93cf-ddfabd54a20d€49.00€0.67matched
105capture01a1a48f-8f8e-71b7-9015-a92b6e77f8a0€15.00€0.26matched
106capture01a1a48f-9851-77e6-b18a-07882e346fe7€49.00€0.67matched
107capture01a1a48f-cd8e-7ed6-b137-ef6aaa9c8db6€15.00€0.26matched
108capture01a1a48f-d273-7ed0-b25e-b242f12010f6€9.00€0.19matched
109capture01a1a48f-d2dd-795d-b465-c600f53e050e€35.00€0.50matched
110refund01a1a48f-dbba-729d-80e5-7156a920723d-€32.00€0.00matched
111capture01a1a48f-ddeb-7ea0-9b6e-69af5585b39a€49.00€0.67matched
112refund01a1a48f-f03a-7d18-95f6-5a33a4c3e688-€4.00€0.00matched
113capture01a1a48f-f241-7697-8431-dbfd7a71594c€24.00€0.37matched
114capture01a1a490-0bad-7bd7-bb10-6e2733a577be€49.00€0.67matched
115capture01a1a490-1cc9-78b0-a258-210c8d54a9f7€49.00€0.67matched
116capture01a1a490-3bc5-72fc-b67a-310b536dec98€15.00€0.26matched
117capture01a1a490-5c92-726e-919a-ec67ace2a31d€15.00€0.26matched
118capture01a1a490-6066-7c65-a06b-b54c0a882209€35.00€0.50matched
119capture01a1a490-63f1-7938-b995-669ce3bafc2d€24.00€0.37matched
120capture01a1a490-8098-7589-9bee-db5e39b7379e€15.00€0.26matched
121capture01a1a490-8f08-74fb-ad8c-2c3cd6d528c9€49.00€0.67matched
122refund01a1a490-9231-7c99-9d01-01acc5868090-€21.00€0.00matched
123capture01a1a490-d92c-7634-8b0c-2bd1d15b9ae7€24.00€0.37matched
124capture01a1a490-ea6b-763a-aa17-c5475985c642€35.00€0.50matched
125capture01a1a490-ebeb-7971-8736-8675991343c9€35.00€0.50matched
126capture01a1a491-0582-7d9e-a015-0f592965ee64€15.00€0.26matched
127capture01a1a491-2277-7f54-a889-4319edd55ca8€49.00€0.67matched
128capture01a1a491-24af-75cb-927f-0614e930f25d€24.00€0.37matched
129capture01a1a491-4b42-74e2-a8bc-81841d178d3c€9.00€0.19matched
130capture01a1a491-4c64-7318-ad12-e662e9d37a0d€24.00€0.37matched
131capture01a1a491-79e8-7081-9630-d2cd397ebd60€24.00€0.37matched
132capture01a1a491-84fa-7f64-b343-5180c317d69c€35.00€0.50matched
133capture01a1a491-9cbc-7c94-9a52-eec1ef3c4efa€24.00€0.37matched
134capture01a1a491-c38a-7969-8483-8250e154765b€24.00€0.37matched
135capture01a1a491-eeef-7529-bb56-b3b91864b66c€35.00€0.50matched
136capture01a1a491-f726-7b41-8898-c9dfaeb2316d€24.00€0.37matched