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

Gross

€2,850.00

PSP fee

€46.69

Net to the bank

€2,803.31

Settlement journal

#406200

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ae26-bcd6-74a4-b18a-38f5df2197ff is already settled by stl_EUR_2989871 line 113
  • missing linein the books, not in the filecapture:01a1ae1f-255c-7082-97d7-451abe9a9fed is in no file
  • missing linein the books, not in the filecapture:01a1ae23-120c-75ee-bd31-067efd258f4e is in no file
  • missing linein the books, not in the filecapture:01a1ae23-ef06-7060-8677-62fa927767d6 is in no file
LineKindReferenceGrossFeeStatus
114capture01a1ae26-cd81-73eb-8df9-78ccff412657€9.00€0.19duplicate line
1capture01a1ae1b-bfab-7756-8725-6ff33193f007€9.00€0.19matched
2capture01a1ae1c-4b72-758e-af48-7afde6e6d0ee€49.00€0.67matched
3capture01a1ae1d-2bd6-72b1-bcf9-908430ff9d8b€24.00€0.37matched
4capture01a1ae1e-9939-7f3a-89a5-ae950558a6d9€24.00€0.37matched
5capture01a1ae1e-be89-7021-b628-844a663cbc7c€35.00€0.50matched
6capture01a1ae1e-c491-756d-9717-576ba9baefab€24.00€0.37matched
7capture01a1ae1e-c969-721d-8008-6a6d2e9c6102€35.00€0.50matched
8capture01a1ae1e-cc1a-7695-b3fa-1076d7bffa36€9.00€0.19matched
9capture01a1ae1e-d788-7d8e-a8e5-ca3efa949716€9.00€0.19matched
10capture01a1ae1e-ed14-74bf-bd30-a9bbc03c9c0a€24.00€0.37matched
11capture01a1ae1e-f6e6-7844-acff-8ab5c59be867€24.00€0.37matched
12capture01a1ae1f-0bfe-7192-bbb2-2ba08fcc3038€24.00€0.37matched
13capture01a1ae1f-4e79-77a6-8eb6-1fa4ae73be5e€15.00€0.26matched
14capture01a1ae1f-7a2f-7b5c-8c39-ed5c0d7be45c€49.00€0.67matched
15capture01a1ae1f-7c1a-70bd-b781-a7c33a6ba878€49.00€0.67matched
16capture01a1ae1f-8c68-73dc-be47-d56567bf65c8€49.00€0.67matched
17capture01a1ae1f-9c77-7f0e-9542-83eeec81a0dd€24.00€0.37matched
18capture01a1ae1f-a13d-7d75-8cb3-333b0c2ca4eb€9.00€0.19matched
19capture01a1ae1f-a890-7854-8167-79e86c40ed00€9.00€0.19matched
20refund01a1ae1f-b5ce-77d0-abbc-deb3b2b3b291-€28.00€0.00matched
21capture01a1ae1f-c309-7030-aa88-2d01afd49b30€24.00€0.37matched
22capture01a1ae1f-d69b-7806-ba97-3ce00fe29870€9.00€0.19matched
23capture01a1ae1f-e352-7cf9-a264-a2b6541e414a€15.00€0.26matched
24capture01a1ae20-0b9f-7da8-add4-8749a72b6b4b€49.00€0.67matched
25capture01a1ae20-38c9-7dc5-824c-0b2234d8df4d€49.00€0.67matched
26capture01a1ae20-5464-7d93-9da6-d1646145ee81€24.00€0.37matched
27capture01a1ae20-5647-74e5-83ee-0fa2ed3257e3€9.00€0.19matched
28capture01a1ae20-5f74-70ae-b844-c15ffbacf5d9€35.00€0.50matched
29capture01a1ae20-6dad-7fcb-9794-3e5941f6c6bf€35.00€0.50matched
30capture01a1ae20-7654-7140-bfea-3ac31a68bce1€15.00€0.26matched
31capture01a1ae20-812e-73f6-a1e2-e88b9c514aed€35.00€0.50matched
32capture01a1ae20-9a39-74b3-837d-5805345cdc1c€35.00€0.50matched
33capture01a1ae20-a528-7a0d-bbd6-33003299fe99€15.00€0.26matched
34capture01a1ae20-b7f5-73ac-ad87-4ab1deb180d9€35.00€0.50matched
35capture01a1ae20-bd3f-762f-af2e-e77c899b6989€35.00€0.50matched
36refund01a1ae20-ce95-7c7e-8283-b6da0f1fe6d1-€33.00€0.00matched
37capture01a1ae20-e099-702b-abb8-492049d313ea€15.00€0.26matched
38capture01a1ae20-f37a-7e09-b170-f390c891b220€24.00€0.37matched
39capture01a1ae21-27a7-7835-86ca-db064f8c68e8€49.00€0.67matched
40capture01a1ae21-4058-7eb6-bb1d-132db8f40f08€49.00€0.67matched
41capture01a1ae21-4998-7741-a30f-310be1ddcf3b€49.00€0.67matched
42capture01a1ae21-6888-77a9-afd8-f2d467ad420e€24.00€0.37matched
43capture01a1ae21-7239-771d-96df-311aff7738ca€15.00€0.26matched
44refund01a1ae21-8956-7483-b0df-592cae9a8fe0-€43.00€0.00matched
45capture01a1ae21-9db0-7541-a5ff-e6756c72b9ff€35.00€0.50matched
46capture01a1ae21-a98c-7cb3-b654-9cb24098e56f€15.00€0.26matched
47capture01a1ae21-b86f-71df-8ade-040bac382917€49.00€0.67matched
48capture01a1ae21-ba2a-787e-8d2a-cb70907169b5€15.00€0.26matched
49capture01a1ae21-f129-7090-b384-3b9b848be2bc€15.00€0.26matched
50capture01a1ae21-fbfc-719d-ab25-3d069cb25eb4€49.00€0.67matched
51capture01a1ae22-05c4-7169-8df0-640a8fc1e7d8€49.00€0.67matched
52capture01a1ae22-1e8b-7dec-8b4e-d63de19cad49€9.00€0.19matched
53capture01a1ae22-2f9e-765a-81ff-02cdf36628ae€49.00€0.67matched
54capture01a1ae22-3176-7221-83da-dad864f1ee03€24.00€0.37matched
55capture01a1ae22-4432-72a0-a6af-2ea991d24d55€35.00€0.50matched
56capture01a1ae22-46ba-759a-8a59-a08c0260d58f€9.00€0.19matched
57refund01a1ae22-755b-78ca-bf33-bf1220d196c7-€34.00€0.00matched
58refund01a1ae22-77fa-73c6-beec-1778d2de3ce2-€7.00€0.00matched
59capture01a1ae22-7942-7d47-8b64-1bb236e82c0a€24.00€0.37matched
60capture01a1ae22-9d0d-7169-9131-eed13215ab2e€24.00€0.37matched
61capture01a1ae22-a4d6-7fad-b368-75573c7745c7€9.00€0.19matched
62capture01a1ae22-ae92-700e-b56f-66e1f79fbec1€24.00€0.37matched
63capture01a1ae22-b6e9-795d-aa67-03b9452d999a€9.00€0.19matched
64capture01a1ae22-c600-7d11-bf49-f165b0b0f6c2€9.00€0.19matched
65capture01a1ae22-da05-71b6-a9a6-4ac1ddcfe7fa€35.00€0.50matched
66refund01a1ae22-dde8-72c4-b9b6-10d58195b233-€22.00€0.00matched
67capture01a1ae22-e930-72a7-9647-3ab9ffa1bc13€35.00€0.50matched
68capture01a1ae23-0c4a-7a76-94b6-13f42ccb3e52€15.00€0.26matched
69capture01a1ae23-17a3-7381-a3e3-5f86924290b3€15.00€0.26matched
70refund01a1ae23-1d8d-77d3-b592-680100891644-€30.00€0.00matched
71capture01a1ae23-3c6c-78b6-bbbd-f6fdd9037bba€15.00€0.26matched
72capture01a1ae23-56c9-7913-88c2-fc4736686276€24.00€0.37matched
73capture01a1ae23-6d8a-7a3c-9632-acbfb69dfa81€49.00€0.67matched
74capture01a1ae23-921c-72f6-ab70-46ea8d76e854€9.00€0.19matched
75capture01a1ae23-acc8-721d-ba43-3f7c39f4dcf8€9.00€0.19matched
76capture01a1ae23-b0dd-79ab-89a7-dab15b365ae8€35.00€0.50matched
77capture01a1ae23-b17c-7296-8dfe-66d80220f889€35.00€0.50matched
78capture01a1ae24-126c-71c2-b635-a806f3584a4e€49.00€0.67matched
79capture01a1ae24-1e5c-7010-a4b3-d47af7eb2839€15.00€0.26matched
80capture01a1ae24-3849-76a0-8dcc-c16b732af832€49.00€0.67matched
81capture01a1ae24-4060-7298-a0f8-4a9065af20ee€9.00€0.19matched
82capture01a1ae24-8732-72a9-af1b-4efc0b94ad68€9.00€0.19matched
83capture01a1ae24-d9b9-7578-a94b-ed1dabf293c9€24.00€0.37matched
84capture01a1ae24-ffd8-7c57-aef4-07dde9291024€15.00€0.26matched
85capture01a1ae25-1d91-7969-a3cc-41d878788950€24.00€0.37matched
86capture01a1ae25-2b5f-734c-8a6b-0d75c5ea74b6€49.00€0.67matched
87capture01a1ae25-6fe2-7fa8-b8c2-c05759d9bd94€35.00€0.50matched
88capture01a1ae25-a3de-7fd7-b939-df4a3465a609€49.00€0.67matched
89capture01a1ae25-aaab-7785-97b5-5b31087c2968€15.00€0.26matched
90capture01a1ae25-b46d-7944-ac15-ec3da1d14072€15.00€0.26matched
91capture01a1ae25-bcf3-70b0-af00-b1b913af4c66€15.00€0.26matched
92capture01a1ae25-d6b6-7e8d-baf5-35f43514645e€15.00€0.26matched
93capture01a1ae25-dace-7631-8ef1-17a6869fbb39€24.00€0.37matched
94capture01a1ae25-dbf3-707d-bf4b-8de1439893fc€35.00€0.50matched
95refund01a1ae25-e076-73d2-845f-72df9f78eaf6-€45.00€0.00matched
96capture01a1ae25-e808-79eb-954b-224c743a2108€49.00€0.67matched
97capture01a1ae25-f1bc-75f6-8e03-7b3f4c3972b7€49.00€0.67matched
98capture01a1ae25-f654-7009-ac9b-60ef6dd26ffd€35.00€0.50matched
99capture01a1ae25-ff5c-7065-9d2d-c31d1714ba85€15.00€0.26matched
100capture01a1ae26-150e-756b-97f9-e0450ae15123€24.00€0.37matched
101capture01a1ae26-19f5-715b-a9dd-e29fa1f52e86€9.00€0.19matched
102capture01a1ae26-1b61-727f-98d9-d974b4299adf€24.00€0.37matched
103capture01a1ae26-3835-7cad-bb96-33c600a1c78f€35.00€0.50matched
104capture01a1ae26-3b81-7658-9b6b-bd5d7afe31af€15.00€0.26matched
105capture01a1ae26-3fb0-723f-9f45-3c064cb086f9€9.00€0.19matched
106capture01a1ae26-626d-77ac-a9cf-73e1cea64c84€49.00€0.67matched
107capture01a1ae26-73d5-75f0-8d39-79aa8071ffb2€9.00€0.19matched
108capture01a1ae26-8eca-7ff2-bac3-55c880ac06ab€24.00€0.37matched
109capture01a1ae26-91be-7208-bbfc-c9e8bd068e19€15.00€0.26matched
110capture01a1ae26-9269-7297-be89-06cdff65743e€35.00€0.50matched
111capture01a1ae26-95c2-72ab-9c50-3e21bc3633ff€15.00€0.26matched
112capture01a1ae26-cc5e-72e4-afe8-4ece0b65d7aa€24.00€0.37matched
113capture01a1ae26-cd81-73eb-8df9-78ccff412657€9.00€0.19matched
115capture01a1ae26-d0dc-7a66-8bab-5235849d4b81€9.00€0.19matched
116capture01a1ae26-edb3-70a7-926d-301d78080326€24.00€0.37matched
117capture01a1ae27-0a1f-7f8e-9ecc-b413708a2d45€15.00€0.26matched
118capture01a1ae27-2fc3-70b4-a0f9-00b9d25dc324€49.00€0.67matched
119capture01a1ae27-5a3e-7ede-9431-69329a1215f7€9.00€0.19matched
120capture01a1ae27-5de6-7005-9425-124e77327de2€9.00€0.19matched
121capture01a1ae27-5e32-7bd1-9814-f46dcd30a2cd€35.00€0.50matched
122capture01a1ae27-6964-7825-96cf-aaa33d18aa1f€49.00€0.67matched
123capture01a1ae27-8289-7ffc-86c0-94edc6ccf696€9.00€0.19matched
124capture01a1ae27-903c-7bd5-8328-c3b15356d470€35.00€0.50matched
125capture01a1ae27-9b21-7a3b-b5ac-d5fd320498b0€49.00€0.67matched
126capture01a1ae27-9cdf-7ec1-a8b2-63291262a96b€35.00€0.50matched