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

1 Nov, 23:20

Gross

€2,649.00

PSP fee

€41.05

Net to the bank

€2,607.95

Settlement journal

#332869

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1996f-215c-78f7-9966-6200ed1d3bf6 is already settled by stl_EUR_2989292 line 63
  • 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 40, the contract says 37
  • missing linein the books, not in the filecapture:01a19971-8389-796f-89ac-124a1e7b3889 is in no file
LineKindReferenceGrossFeeStatus
2capture01a19969-ac33-7ba9-9a86-164307bc3dce€49.00€0.68fee difference
52capture01a1996d-7497-77be-8b9d-55c47074d7bc€24.00€0.40fee difference
64capture01a1996f-2182-7eae-9502-3d93c1dccbe7€35.00€0.50duplicate line
1capture01a19966-f03c-7100-ae03-feccd3cc34a0€49.00€0.67matched
3capture01a19969-c046-7665-a80a-2005715bd963€35.00€0.50matched
4capture01a1996a-04e9-74ea-b199-717308cc471c€35.00€0.50matched
5refund01a1996a-202d-73c8-a3b6-63012644ee90-€13.00€0.00matched
6capture01a1996a-23cb-7f84-85ec-e440f6b93b37€49.00€0.67matched
7capture01a1996a-4674-7499-9e3a-7c8e5e88660e€35.00€0.50matched
8capture01a1996a-495a-7cc7-ac82-35343aaab4bc€15.00€0.26matched
9capture01a1996a-58a4-7b7f-9b25-4bda56379f7e€15.00€0.26matched
10capture01a1996a-7164-79d6-a1ac-00693a025912€15.00€0.26matched
11capture01a1996a-787e-78b2-ab9f-ba7d4eb1e835€24.00€0.37matched
12capture01a1996a-79bc-7f21-a69f-8fd11f67bdfd€35.00€0.50matched
13capture01a1996a-a22f-761d-bb4a-0fcc49a2d320€49.00€0.67matched
14capture01a1996a-bef8-75ef-8acb-608084945b43€15.00€0.26matched
15capture01a1996a-cd7e-7898-b07a-86059614042f€35.00€0.50matched
16capture01a1996a-d44c-7f86-ada5-98edf579e91b€15.00€0.26matched
17capture01a1996a-dbd2-791a-8670-64522ba1a53b€9.00€0.19matched
18capture01a1996a-fffd-7ff7-b3bb-749d0da823e4€49.00€0.67matched
19refund01a1996b-01b7-7aa9-b999-ddb70227c7d6-€32.00€0.00matched
20capture01a1996b-1156-79d4-b527-6b8c5102aa07€9.00€0.19matched
21capture01a1996b-1213-74f2-b9b0-8012e917fa2d€35.00€0.50matched
22capture01a1996b-1dfa-7247-a302-9d327c933229€24.00€0.37matched
23capture01a1996b-23bc-7852-ab41-afc1d48559e5€35.00€0.50matched
24refund01a1996b-514f-7779-8996-a1061cd371c4-€24.00€0.00matched
25capture01a1996b-9231-774c-9ea9-afde7f8c716c€49.00€0.67matched
26capture01a1996b-9fde-720f-a06e-fd98fcafad79€24.00€0.37matched
27capture01a1996b-c474-76ff-95eb-a536fc38c2bc€49.00€0.67matched
28capture01a1996b-d755-7f8a-aeb6-53bfe7187bdf€9.00€0.19matched
29capture01a1996b-ee3e-7c40-89c6-4bf8f8ce910c€9.00€0.19matched
30capture01a1996b-f501-75f4-acbf-c512e5e20461€24.00€0.37matched
31capture01a1996b-f9f5-753d-9ad3-a9b0009eaf0a€15.00€0.26matched
32capture01a1996b-fc76-763b-b682-3ca433071579€24.00€0.37matched
33capture01a1996c-0aca-7489-aa02-5ba43b8690f9€35.00€0.50matched
34capture01a1996c-10d3-72ed-8d43-0e396a46ae04€15.00€0.26matched
35capture01a1996c-18e7-7d37-a0c7-3a8c37db926c€15.00€0.26matched
36capture01a1996c-1f91-7deb-86d3-66df41587456€9.00€0.19matched
37capture01a1996c-4f94-7bad-94dd-3f0486464263€49.00€0.67matched
38capture01a1996c-8b69-7500-b3be-c6b9340563ae€15.00€0.26matched
39capture01a1996c-b7c3-78d8-b655-9dbf5471c395€9.00€0.19matched
40capture01a1996c-c0c2-78c7-afd3-fc293f7a27a9€15.00€0.26matched
41capture01a1996c-c1e8-729e-81dd-cebe459f26a4€24.00€0.37matched
42capture01a1996c-cc96-75ec-9631-006bed646a78€35.00€0.50matched
43capture01a1996c-ce9a-753c-bd20-562b99cc36bf€49.00€0.67matched
44capture01a1996c-cfff-7e33-a5d8-e607cc305399€49.00€0.67matched
45capture01a1996c-de7c-7a32-ada2-58a31b39573f€35.00€0.50matched
46capture01a1996d-05da-7354-94fe-03dce729cfcb€9.00€0.19matched
47capture01a1996d-09de-7c64-a437-6b3e8c41f5fa€24.00€0.37matched
48capture01a1996d-1388-7d1d-8680-fbb8105f6948€9.00€0.19matched
49capture01a1996d-314d-7eeb-a81d-1b9f43c60b0b€35.00€0.50matched
50capture01a1996d-36ce-7fea-89c5-4aa34984eb88€24.00€0.37matched
51capture01a1996d-3ad8-7a2a-a284-cd2f2c587d34€35.00€0.50matched
53capture01a1996d-78de-7802-9aa6-fcc8f0afa19e€15.00€0.26matched
54capture01a1996d-80ba-7e66-a04e-03657a4a1ec4€15.00€0.26matched
55capture01a1996e-110c-70b2-891b-6e86f1c275b5€49.00€0.67matched
56capture01a1996e-8631-79fc-96af-1749a9a8745c€9.00€0.19matched
57capture01a1996e-93ab-79d0-98c4-9b3dba016c46€35.00€0.50matched
58capture01a1996e-ab38-7ba9-b344-81d77ab89a00€15.00€0.26matched
59capture01a1996e-b36b-7933-b33c-4b5e83741f2d€9.00€0.19matched
60capture01a1996e-b60a-76e0-a2df-e43799b6f767€35.00€0.50matched
61capture01a1996e-e7b3-7247-9c7f-649fe427910e€35.00€0.50matched
62capture01a1996e-e8f9-7880-88d2-c383739a17ff€35.00€0.50matched
63capture01a1996f-2182-7eae-9502-3d93c1dccbe7€35.00€0.50matched
65capture01a1996f-2ed5-7763-8703-04c0dcd323c2€15.00€0.26matched
66capture01a1996f-3281-72fb-8186-e9b29b50efcf€9.00€0.19matched
67capture01a1996f-33dd-78b1-8d47-11b59dc43a89€35.00€0.50matched
68capture01a1996f-476b-7845-8d6a-d5d95e8e521e€24.00€0.37matched
69capture01a1996f-5604-7898-877e-f4dd26291ef1€15.00€0.26matched
70capture01a1996f-7687-798c-8b44-77b3badb10ca€35.00€0.50matched
71capture01a1996f-a673-729a-b959-1a0b81f4e219€35.00€0.50matched
72capture01a1996f-baeb-7d4e-95f1-233027b5e682€49.00€0.67matched
73capture01a1996f-d329-7f2d-8870-8d8dff534bea€49.00€0.67matched
74capture01a1996f-fe41-7979-9118-4715b15d5564€24.00€0.37matched
75capture01a19970-23a8-7efb-8f16-cb5d54f6daf8€24.00€0.37matched
76capture01a19970-3f76-7761-93aa-b0f21c74f930€15.00€0.26matched
77capture01a19970-5971-7c4a-8824-0b08c5acc47d€35.00€0.50matched
78capture01a19970-6ef0-7c67-83d9-6acfba71e0a7€9.00€0.19matched
79capture01a19970-7492-741e-a776-4d6819e8530f€24.00€0.37matched
80capture01a19970-9449-70ca-b0d4-83d522c3b652€49.00€0.67matched
81capture01a19970-a27d-7a0f-a3d8-95c51312632f€49.00€0.67matched
82capture01a19970-a32e-73e8-b285-ba783c5ff33e€15.00€0.26matched
83capture01a19970-b7e6-7911-a1c1-9364a6b68ad3€49.00€0.67matched
84refund01a19970-c086-7d8d-a459-e1ab4c9f281f-€31.00€0.00matched
85capture01a19971-320f-7aa1-85bd-5d20fd615679€15.00€0.26matched
86capture01a19971-42b9-769b-bdd7-256100f8809d€35.00€0.50matched
87capture01a19971-522f-7ef5-ba9c-31bdd8d7e16c€35.00€0.50matched
88capture01a19971-6fb4-7791-b5b0-44b37ced0862€15.00€0.26matched
89capture01a19971-6fc7-72f5-b2b2-9ed339e8338a€49.00€0.67matched
90capture01a19971-84b2-763f-9f98-777cb1ed45da€24.00€0.37matched
91capture01a19971-b506-7470-9e4f-0f30e7f9523b€35.00€0.50matched
92capture01a19971-cee9-785e-9941-39f7751de1bf€9.00€0.19matched
93capture01a19971-cf6c-7935-a340-6f2ba867d12d€15.00€0.26matched
94capture01a19971-dfc5-7aa2-9bc1-7ba10e35c620€49.00€0.67matched
95capture01a19972-1669-7519-9c19-ccc7e7cf11d4€35.00€0.50matched
96refund01a19972-2ef5-72d2-b9c6-eb8163c74b5c-€7.00€0.00matched
97capture01a19972-2f0f-7a82-a05e-83592f53d2d6€15.00€0.26matched
98capture01a19972-5ca2-7fc7-b80e-bb97e5bf5ba0€49.00€0.67matched
99capture01a19972-6586-7170-baa9-376bd63e6dcc€15.00€0.26matched
100capture01a19972-74f2-7f5d-b15b-0faa5e50ee9c€49.00€0.67matched
101capture01a19972-77eb-7e8f-9259-d1f7c9681cf1€24.00€0.37matched
102capture01a19972-8580-78cd-a8b9-a283d4f11862€35.00€0.50matched
103capture01a19972-a0e2-7710-951a-1d9ca2678f9e€24.00€0.37matched