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

Gross

€3,222.00

PSP fee

€50.06

Net to the bank

€3,171.94

Settlement journal

#397332

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aba5-676b-742b-a3f6-bd9771106211 is already settled by stl_EUR_2989801 line 110
  • fee differencethe fee is not the contract feethe fee is 69, the contract says 67
LineKindReferenceGrossFeeStatus
1capture01a1ab9b-705b-7ea8-b5ff-0c39f8cabfbe€24.00€0.40fee difference
83capture01a1aba3-85ec-777c-af50-7273b850ec5b€49.00€0.69fee difference
111capture01a1aba5-6a03-72c0-9234-6ab81613f46f€35.00€0.50duplicate line
2capture01a1ab9c-bc82-7300-b26b-c7616ad8c79e€49.00€0.67matched
3capture01a1ab9d-f9ce-7066-ae6f-7a79120c4037€49.00€0.67matched
4capture01a1ab9e-0a41-763b-9e69-8d5f194f35b6€24.00€0.37matched
5capture01a1ab9e-1240-7bde-ba44-5151a244ddc3€24.00€0.37matched
6capture01a1ab9e-0465-7cb3-9da7-f4bcd1a31285€49.00€0.67matched
7capture01a1ab9e-21fd-75bb-939f-0e67ae8abe1f€15.00€0.26matched
8capture01a1ab9e-43d6-783f-924c-9fe864777c7a€49.00€0.67matched
9refund01a1ab9e-5195-762a-821e-3d6b17f4b574-€6.00€0.00matched
10capture01a1ab9e-5317-71ea-b82b-248e18fe58d2€49.00€0.67matched
11capture01a1ab9e-6038-7efb-8613-81c3f6c3a26a€15.00€0.26matched
12capture01a1ab9e-636c-79cc-8d78-e05f92de8b6a€9.00€0.19matched
13capture01a1ab9e-6d36-7601-ba61-4e3ee2938971€15.00€0.26matched
14capture01a1ab9e-8c38-7f38-af1b-f557053129f4€49.00€0.67matched
15capture01a1ab9e-9194-7454-837d-2f22b64dfc39€35.00€0.50matched
16capture01a1ab9e-9e92-75aa-b547-1b524a0224d6€35.00€0.50matched
17capture01a1ab9e-b4b3-7819-b11a-bd2009569047€15.00€0.26matched
18capture01a1ab9e-be15-7b5a-ae1e-41ca6147ef3d€24.00€0.37matched
19refund01a1ab9e-c5df-704b-9245-19c385a39b8e-€40.00€0.00matched
20capture01a1ab9e-cfa4-7751-a172-62e98a58557d€24.00€0.37matched
21capture01a1ab9e-e172-7c65-aa15-dc817666ef57€35.00€0.50matched
22capture01a1ab9e-fedb-7677-9147-dd9eb9428812€15.00€0.26matched
23capture01a1ab9f-1026-799a-9eab-086203117f35€35.00€0.50matched
24capture01a1ab9f-1077-799e-a773-0ac50e785781€49.00€0.67matched
25capture01a1ab9f-2ce7-76e4-9123-fee4d48817da€24.00€0.37matched
26capture01a1ab9f-2e24-71e4-aac1-9ed594f5c0d3€15.00€0.26matched
27capture01a1ab9f-4f32-7218-b368-a44bfa9b9bf3€15.00€0.26matched
28capture01a1ab9f-902b-7266-a68e-563b83c38a38€24.00€0.37matched
29capture01a1ab9f-afd7-7556-97c2-80ae9203ab2f€35.00€0.50matched
30capture01a1ab9f-b628-760d-b297-2cade556ad67€9.00€0.19matched
31capture01a1ab9f-c2b5-78eb-9264-739dbe59be7f€9.00€0.19matched
32capture01a1ab9f-d349-70ad-88ea-ab521ca3db6a€15.00€0.26matched
33capture01a1ab9f-d68b-795b-94a8-6213b421dbea€15.00€0.26matched
34capture01a1ab9f-e5df-77f8-b12e-3ff4096ac69d€9.00€0.19matched
35capture01a1aba0-0430-7179-a35f-23d69dd3e0f9€24.00€0.37matched
36capture01a1aba0-2816-7d41-b5e9-4b75d04dd3f5€15.00€0.26matched
37capture01a1aba0-2c10-7375-b453-de109d3ac714€35.00€0.50matched
38capture01a1aba0-625f-715c-9af2-b7a283125d7c€9.00€0.19matched
39capture01a1aba0-94d9-7a15-87cc-b73ca0c9658f€35.00€0.50matched
40capture01a1aba0-a053-7e7c-98f6-9493f3293035€24.00€0.37matched
41capture01a1aba0-b056-73be-b75f-12d68bc54766€15.00€0.26matched
42capture01a1aba0-c497-73b2-8150-bfe6ccb9a37b€35.00€0.50matched
43capture01a1aba0-dfd4-74f5-b147-4c14c650fa97€15.00€0.26matched
44capture01a1aba1-0bc6-70d6-a782-47845972a26b€15.00€0.26matched
45capture01a1aba1-4aa1-758a-a6c8-d623af746985€35.00€0.50matched
46capture01a1aba1-69f6-7ec3-b529-05220fb09184€15.00€0.26matched
47capture01a1aba1-72bf-72f9-b24a-72bcc1c94039€24.00€0.37matched
48capture01a1aba1-7309-7f33-a333-44b76cbe55be€24.00€0.37matched
49capture01a1aba1-8c96-7f9c-8eb2-e5095d217f1d€49.00€0.67matched
50capture01a1aba1-a2ae-7549-b559-4d540c494373€9.00€0.19matched
51refund01a1aba1-a39e-7cee-a013-3ab1fdc53935-€5.00€0.00matched
52capture01a1aba1-babe-7f3f-8c9f-6b565c34b372€49.00€0.67matched
53capture01a1aba1-ca66-7190-9feb-3c97c95bc3f8€49.00€0.67matched
54capture01a1aba1-d2be-77b4-8a98-c1f777670e33€15.00€0.26matched
55capture01a1aba1-d30d-77dc-aebe-4381cd5b96b4€49.00€0.67matched
56capture01a1aba1-d4dc-71cc-8c53-0a7872dddc73€35.00€0.50matched
57capture01a1aba1-d4f9-73e3-88af-6fade48a46fc€24.00€0.37matched
58refund01a1aba1-dfe2-7f15-976d-2b9343835efe-€14.00€0.00matched
59capture01a1aba1-f64d-7564-b808-992bda3a1cf1€15.00€0.26matched
60capture01a1aba2-1349-77f2-8db2-68beb7e2fdfb€15.00€0.26matched
61capture01a1aba2-1956-7797-946f-5e8e1c3759ee€24.00€0.37matched
62capture01a1aba2-29ff-727a-80c4-5ec813a73bb4€49.00€0.67matched
63capture01a1aba2-2785-762c-9044-902f5d58042c€15.00€0.26matched
64capture01a1aba2-2fb4-751d-94a7-61d37b2b02a6€49.00€0.67matched
65capture01a1aba2-3d00-7fed-86dc-faba3acd8abc€15.00€0.26matched
66capture01a1aba2-3d21-70e6-b3ad-52af46d84371€9.00€0.19matched
67capture01a1aba2-7441-7810-8648-31ce6f8dc671€15.00€0.26matched
68capture01a1aba2-7504-7fbb-b653-8a35bde86e5f€49.00€0.67matched
69capture01a1aba2-763f-716d-9b18-1d3c20623912€35.00€0.50matched
70capture01a1aba2-861d-7874-a3b5-0edd1c0c57c1€15.00€0.26matched
71capture01a1aba2-8ec0-71c0-b63d-08ddea8dbe6f€49.00€0.67matched
72capture01a1aba2-96e3-70b4-b9d8-c21e80e36c0f€35.00€0.50matched
73capture01a1aba2-b862-7f7a-82ff-d036adb968ec€49.00€0.67matched
74refund01a1aba2-d283-7994-bd23-be0c4708ea23-€9.00€0.00matched
75capture01a1aba3-28e9-79ca-89f7-2b0cbd3f66db€15.00€0.26matched
76capture01a1aba3-3285-77f6-ba40-670f77040f16€9.00€0.19matched
77capture01a1aba3-41c5-72e4-a31a-36dfed511a58€9.00€0.19matched
78capture01a1aba3-4b8a-7c65-ad74-f8330d2b2519€35.00€0.50matched
79capture01a1aba3-4db2-73ce-b6d5-fcef17f27c6d€15.00€0.26matched
80capture01a1aba3-671e-73c0-aa53-f593641ee315€24.00€0.37matched
81capture01a1aba3-6ea4-76fe-99f1-2bc755c34e28€35.00€0.50matched
82capture01a1aba3-7d1f-7fdc-81f7-9689ffa802e7€15.00€0.26matched
84capture01a1aba3-9e91-75fa-af31-d0973ec3675f€15.00€0.26matched
85capture01a1aba3-c1cc-770c-9b0c-7596ebfc5cd6€35.00€0.50matched
86capture01a1aba3-d68a-70e8-980f-221015d87ed1€9.00€0.19matched
87capture01a1aba3-dbf8-70ea-b371-f8fc90e0c24f€35.00€0.50matched
88capture01a1aba3-dc38-70a8-8e89-0594b1cc8a5e€49.00€0.67matched
89capture01a1aba3-e55f-7fc1-ae9e-2010a837660e€49.00€0.67matched
90capture01a1aba4-0692-72dd-8e7a-90148e45b829€49.00€0.67matched
91capture01a1aba4-3cc5-7728-8f8f-4a71f0a775fe€15.00€0.26matched
92capture01a1aba4-43bf-7064-a440-3611a1be9fb7€24.00€0.37matched
93capture01a1aba4-518d-7e97-9267-9f6aed883e83€9.00€0.19matched
94capture01a1aba4-568c-733a-b121-645661ab9f98€24.00€0.37matched
95capture01a1aba4-5f9c-793f-9ec7-5333b80aaff7€9.00€0.19matched
96capture01a1aba4-649f-75d4-aee5-f64e1cf906a1€9.00€0.19matched
97capture01a1aba4-7a8f-75a3-8986-a1bea8f050ae€49.00€0.67matched
98capture01a1aba4-8b20-75fa-9b3e-89084d5188f2€24.00€0.37matched
99capture01a1aba4-9551-78d3-b5c2-ff27ef468008€9.00€0.19matched
100refund01a1aba4-a551-779f-835f-2cc4063669d3-€20.00€0.00matched
101capture01a1aba4-b23b-7986-855a-da05ed93e9e0€24.00€0.37matched
102capture01a1aba4-cda8-7057-ad4f-7d70bc322964€49.00€0.67matched
103capture01a1aba4-cfd3-79e1-9908-bf5875a4a78e€49.00€0.67matched
104capture01a1aba5-061e-7e28-8951-e6f20b061e75€24.00€0.37matched
105capture01a1aba5-120f-773a-b5c4-7535cbfc02b7€15.00€0.26matched
106capture01a1aba5-2a73-78a0-ae16-ae1ba19fb9ee€15.00€0.26matched
107capture01a1aba5-4411-70b6-8668-360b65cdff94€15.00€0.26matched
108capture01a1aba5-53b3-78e0-9efd-aa74502b9a92€49.00€0.67matched
109capture01a1aba5-589b-7431-bde0-a1fc50cbf31d€15.00€0.26matched
110capture01a1aba5-6a03-72c0-9234-6ab81613f46f€35.00€0.50matched
112capture01a1aba5-8243-7e44-b527-218f66c0beb7€9.00€0.19matched
113capture01a1aba5-8865-775f-9f41-80f53aa4c604€15.00€0.26matched
114capture01a1aba5-8f55-70ae-b0b9-880faf7b50d9€35.00€0.50matched
115capture01a1aba5-9f9f-73cb-a7fb-1361b0b99376€24.00€0.37matched
116capture01a1aba5-a05f-7200-9285-bfd0bac2c514€49.00€0.67matched
117capture01a1aba5-ad34-7c68-8376-e8b3e544f03f€15.00€0.26matched
118capture01a1aba5-ae52-7d20-a68b-e5082b237260€24.00€0.37matched
119capture01a1aba5-b394-7464-abbe-46744d834c3c€9.00€0.19matched
120capture01a1aba5-b58d-7b71-9cd9-614f1b8d308a€15.00€0.26matched
121capture01a1aba5-cb1c-71e1-8c5a-6246684eb0ae€15.00€0.26matched
122capture01a1aba6-0d05-7a0b-ad4e-770c68d59138€35.00€0.50matched
123capture01a1aba6-2071-736a-a710-52490d392275€35.00€0.50matched
124capture01a1aba6-2a3c-737c-b49c-a2b1b017f150€49.00€0.67matched
125capture01a1aba6-5c78-74de-827a-d4af96372713€35.00€0.50matched
126capture01a1aba6-7ad5-7cb1-b605-2bab9d0cbec3€24.00€0.37matched
127capture01a1aba6-7d99-70e6-a169-8428d5ffbfda€9.00€0.19matched
128capture01a1aba6-8fd3-7a14-be55-7051b99d0473€9.00€0.19matched
129capture01a1aba6-9ca2-7bf3-b9c9-ed47e5a8b6da€24.00€0.37matched
130capture01a1aba6-9e81-7a26-86f1-4d27f1f43d19€15.00€0.26matched
131capture01a1aba6-ce06-79a1-b54d-88823386bb5f€9.00€0.19matched
132capture01a1aba6-cfa2-73ab-a4d3-ff380f659634€24.00€0.37matched