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

3 Nov, 16:40

Gross

€3,085.00

PSP fee

€49.11

Net to the bank

€3,035.89

Settlement journal

#364289

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a24e-dbc1-784d-8053-599c1b48e392 is already settled by stl_EUR_2989540 line 109
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
LineKindReferenceGrossFeeStatus
90capture01a1a24d-c578-7e6a-9f48-f7541cd0bc89€9.00€0.22fee difference
110capture01a1a24e-dbeb-77e0-9b9b-feb8ad0d63ce€9.00€0.19duplicate line
1capture01a1a241-bdaf-72d0-9d87-e39f3f294577€9.00€0.19matched
2capture01a1a246-999a-7008-8655-02b4746bbbe5€9.00€0.19matched
3capture01a1a248-2a8b-72e9-9642-847b7ea958b2€24.00€0.37matched
4capture01a1a248-358f-7552-a40b-7b82e83e498b€35.00€0.50matched
5capture01a1a248-4de0-79e5-8ef7-62fd932dc6ab€9.00€0.19matched
6capture01a1a248-5e1c-7ced-8bff-a64ea70f71d5€49.00€0.67matched
7capture01a1a248-60c7-7485-a1f3-5530866d06ad€24.00€0.37matched
8capture01a1a248-75ed-78d4-b6fa-1ffb3a323662€15.00€0.26matched
9capture01a1a248-78f0-7ccf-bdb7-495b420e2ce8€49.00€0.67matched
10capture01a1a248-91d9-7235-b797-3d5fa4b204a9€35.00€0.50matched
11capture01a1a248-9dc0-79c0-bd90-62f74eae6309€24.00€0.37matched
12capture01a1a248-b4d8-73e5-99c5-fbbfe78ebd61€24.00€0.37matched
13capture01a1a248-b8de-7808-8ede-5bfc55612425€49.00€0.67matched
14capture01a1a248-b9cc-7386-953e-0f3baeab9071€9.00€0.19matched
15capture01a1a248-ce00-701a-9a41-983fff2cc9f9€9.00€0.19matched
16capture01a1a248-dd8a-70c9-bc9b-4a9fe9edd365€49.00€0.67matched
17capture01a1a248-e2e3-7d8b-bae9-402d7bfdc679€35.00€0.50matched
18capture01a1a248-f12f-729d-9950-7c109c71bc28€49.00€0.67matched
19capture01a1a249-00bc-7bf9-b92f-717a5100f395€15.00€0.26matched
20capture01a1a249-02e0-7833-9923-620fbc821a1a€35.00€0.50matched
21capture01a1a249-1470-7bed-8b6e-47b3e43d3e82€9.00€0.19matched
22capture01a1a249-1a86-7365-a8db-886595d8e6fa€9.00€0.19matched
23capture01a1a249-2012-77fd-bfb2-10d985dda2fa€15.00€0.26matched
24capture01a1a249-2253-77ee-b5b5-3e6c2a46ff9f€24.00€0.37matched
25capture01a1a249-2c98-7bc6-8609-6ba770538f67€9.00€0.19matched
26capture01a1a249-3374-7c45-bde4-f73da06e7925€24.00€0.37matched
27capture01a1a249-42d0-7619-9e57-d114d6e1bbb6€15.00€0.26matched
28capture01a1a249-5574-7206-a768-4cc15561c9ed€49.00€0.67matched
29refund01a1a249-717c-75c4-973f-f409a9923ae5-€2.00€0.00matched
30capture01a1a249-7b74-741b-b7e8-bc5fcf42b6b8€15.00€0.26matched
31capture01a1a249-87c4-7661-9ae4-1e1b0f9846e5€9.00€0.19matched
32capture01a1a249-b1dd-7d12-ae2a-30577537579a€9.00€0.19matched
33capture01a1a249-c4a0-7ef1-95c0-0c8796eb18ea€49.00€0.67matched
34refund01a1a249-cf2a-73da-b4df-76475dce3e54-€4.00€0.00matched
35capture01a1a249-dcbe-754d-a78e-d2de97b87e58€35.00€0.50matched
36capture01a1a249-e203-7719-acbc-1098b2b70968€24.00€0.37matched
37capture01a1a249-e484-7e66-a4e8-661273c0f5a9€24.00€0.37matched
38capture01a1a249-e96f-71cf-90ff-a873a85afcf9€35.00€0.50matched
39capture01a1a249-f823-7d04-9417-7c33cbb2aefe€15.00€0.26matched
40capture01a1a24a-476f-7a80-a6b4-cd9e1135c345€35.00€0.50matched
41capture01a1a24a-5043-76e6-99d5-eefc3058be8a€15.00€0.26matched
42capture01a1a24a-60e3-7566-8a73-8ef4f6311411€9.00€0.19matched
43capture01a1a24a-648c-7106-a307-b23b295ffd4e€35.00€0.50matched
44capture01a1a24a-729a-7c8b-89d4-c1d5f62fc229€24.00€0.37matched
45capture01a1a24a-72b7-7fa0-900b-b5cf0cca0a85€15.00€0.26matched
46capture01a1a24a-85b4-775c-90e0-065b39bd5690€9.00€0.19matched
47capture01a1a24a-8bb4-7fbd-b3d2-d89a55759b03€35.00€0.50matched
48capture01a1a24a-950d-7b78-9372-f557318e4267€15.00€0.26matched
49capture01a1a24a-a05f-709d-bca3-e1fc8cb07979€49.00€0.67matched
50capture01a1a24a-c7d8-764f-a548-822d4c5bd221€24.00€0.37matched
51capture01a1a24a-ccf8-7398-b61e-7eb5bdfced3d€15.00€0.26matched
52refund01a1a24a-da5b-716a-8135-138881edbc3a-€32.00€0.00matched
53capture01a1a24a-dcef-7bdb-b022-380c1d32e55b€24.00€0.37matched
54capture01a1a24a-e00e-721e-a7ad-43658d2316d9€35.00€0.50matched
55capture01a1a24a-f6b3-7ab2-9b4a-7ec657e4c0ff€49.00€0.67matched
56capture01a1a24b-3972-7dad-b486-df4231c01ccd€35.00€0.50matched
57capture01a1a24b-40eb-7d21-9f9c-60e6754b2e06€15.00€0.26matched
58capture01a1a24b-43a7-7380-b245-508df6977e9e€35.00€0.50matched
59capture01a1a24b-4422-7c9e-b7e5-f9834a0fd68d€24.00€0.37matched
60capture01a1a24b-868a-78a4-a44c-4ddea25d683a€35.00€0.50matched
61capture01a1a24b-8b0e-743a-8100-a0b5c7bc3c8f€9.00€0.19matched
62capture01a1a24b-9087-7c83-8b64-52abd6f85caf€35.00€0.50matched
63capture01a1a24b-ba8f-7234-bdd5-06bbeb0b5b7b€9.00€0.19matched
64capture01a1a24b-cc34-77b4-b42c-8f9ec97d5512€24.00€0.37matched
65capture01a1a24b-ffa3-72cd-9ca0-781a13694741€24.00€0.37matched
66capture01a1a24c-2348-786d-90fb-cc62a9eeedb2€15.00€0.26matched
67capture01a1a24c-4288-7156-b496-1602ccdffa30€24.00€0.37matched
68capture01a1a24c-6b12-7d92-bb48-e71e1b5b5928€49.00€0.67matched
69capture01a1a24c-6ce5-7c5f-96fb-6e7f3299d9d3€15.00€0.26matched
70capture01a1a24c-6eeb-7dbc-8c9b-455758e7290a€15.00€0.26matched
71capture01a1a24c-79b3-7259-82a0-0bd18adb3162€15.00€0.26matched
72capture01a1a24c-85e6-7a05-92c4-4f3edcedc039€49.00€0.67matched
73capture01a1a24c-975e-70ec-9d2d-afc38fcc1bbf€9.00€0.19matched
74capture01a1a24c-97af-7f83-9bfb-67bdf4bb0092€9.00€0.19matched
75capture01a1a24c-abfa-7f15-aff2-2eea12284e67€49.00€0.67matched
76capture01a1a24c-c9d3-7fdb-97b4-0042de214694€9.00€0.19matched
77refund01a1a24c-cf71-7d31-9978-62fb03314a99-€42.00€0.00matched
78capture01a1a24c-e118-7c18-828a-75b5fc562940€49.00€0.67matched
79capture01a1a24c-f33a-7454-9c0d-a075e8286d64€9.00€0.19matched
80capture01a1a24c-f94e-71ca-a3b2-ab2373839403€15.00€0.26matched
81capture01a1a24c-f9ed-7b7d-9da1-50ed4a549543€49.00€0.67matched
82capture01a1a24c-fb02-7c96-ab7c-51422ed55b38€24.00€0.37matched
83capture01a1a24d-41a1-7e88-9ab6-19a3b1d4548c€24.00€0.37matched
84capture01a1a24d-5992-7d31-b0d2-d17cfc1e3c7a€24.00€0.37matched
85capture01a1a24d-8b20-76a1-abbc-fd4499543154€9.00€0.19matched
86capture01a1a24d-9a12-7ab3-b4bd-ba94c0a3125d€15.00€0.26matched
87capture01a1a24d-9a50-7bfd-8150-73e64d8c60d7€9.00€0.19matched
88capture01a1a24d-a124-7479-bc12-c086f7b81396€9.00€0.19matched
89capture01a1a24d-af87-7777-ba98-e4a0a987f56c€49.00€0.67matched
91capture01a1a24d-cce7-7787-9ed2-37fafd7fc9f5€24.00€0.37matched
92refund01a1a24d-d289-710c-9e3f-90382415816a-€7.00€0.00matched
93capture01a1a24d-dbba-78c7-b1fc-022093fc4014€35.00€0.50matched
94capture01a1a24d-f920-7c59-a1a9-611de332a116€9.00€0.19matched
95capture01a1a24d-fda9-731d-95ee-6ef7a0d4f1da€49.00€0.67matched
96capture01a1a24e-17a9-770b-9477-ab1735c6fb6c€15.00€0.26matched
97capture01a1a24e-5065-7756-9893-e60368f33b35€15.00€0.26matched
98capture01a1a24e-517c-784e-880f-a6aa71317412€9.00€0.19matched
99capture01a1a24e-777b-70e5-a607-9af0ea689732€9.00€0.19matched
100capture01a1a24e-8c39-79f3-891b-6d2e56a49ae7€24.00€0.37matched
101capture01a1a24e-99bd-716e-b052-949a1fd6f81a€24.00€0.37matched
102capture01a1a24e-a59f-724f-ba02-1c35a18d698a€15.00€0.26matched
103capture01a1a24e-accc-7914-859c-64f6f8604497€24.00€0.37matched
104capture01a1a24e-bb6f-7720-ab06-7b3062714771€9.00€0.19matched
105capture01a1a24e-bdd7-7c92-86da-ef44dde0eb2c€24.00€0.37matched
106capture01a1a24e-d02f-7e59-9b15-d629065bbbd3€24.00€0.37matched
107capture01a1a24e-d380-7e09-bcab-a6c25a136db2€15.00€0.26matched
108capture01a1a24e-d569-7964-b3b1-2388527ce1f7€35.00€0.50matched
109capture01a1a24e-dbeb-77e0-9b9b-feb8ad0d63ce€9.00€0.19matched
111capture01a1a24e-fb02-7412-a8f5-9ef2176f7d9b€24.00€0.37matched
112capture01a1a24f-0456-75f0-bb81-d8752a6b31db€15.00€0.26matched
113capture01a1a24f-0b5d-7ff1-9f74-f807726784ac€9.00€0.19matched
114capture01a1a24f-1c16-7590-9055-229d00ff9976€49.00€0.67matched
115capture01a1a24f-24f6-7289-bebd-542d5be27c87€49.00€0.67matched
116capture01a1a24f-2d8f-7f18-862e-8c1bc356c05b€35.00€0.50matched
117capture01a1a24f-58d8-7293-b522-4c76217ecb17€9.00€0.19matched
118capture01a1a24f-634c-7a78-931e-09328e509d01€49.00€0.67matched
119capture01a1a24f-7b34-7fb0-ac18-3de5a32c5b0d€9.00€0.19matched
120refund01a1a24f-aecf-79ce-a4b0-4b7029c8a8ec-€16.00€0.00matched
121capture01a1a24f-f540-79c8-bcc8-0edf30ab90f9€35.00€0.50matched
122capture01a1a250-1516-7dd5-b932-3d5315205369€24.00€0.37matched
123capture01a1a250-1622-79d4-a8c8-7cc250c40fab€49.00€0.67matched
124capture01a1a250-21fa-7f34-9ce5-c5538ee5b793€9.00€0.19matched
125capture01a1a250-37ad-7970-96db-cbf4b927cdf8€35.00€0.50matched
126capture01a1a250-7070-7c45-ae68-96393b1a990d€35.00€0.50matched
127capture01a1a250-7a61-7c4d-8acd-e600cbc1297b€35.00€0.50matched
128capture01a1a250-8167-732a-823d-be7b33f729d3€9.00€0.19matched
129refund01a1a250-847c-7131-b08d-4e92ae790403-€3.00€0.00matched
130capture01a1a250-8576-702e-ab9f-fcc9adb59682€15.00€0.26matched
131capture01a1a250-a111-79d9-bdd1-a21d902b0f5f€15.00€0.26matched
132refund01a1a250-bf70-7f30-8d0d-7508df407aad-€5.00€0.00matched
133capture01a1a250-c00c-7e53-8090-520662f85843€49.00€0.67matched
134capture01a1a250-d709-78dc-a685-e29b24be3a5f€9.00€0.19matched
135capture01a1a250-dc3b-7c13-a951-cca5e25f938e€24.00€0.37matched
136capture01a1a250-f6f0-705b-bb66-9db6bed858d3€15.00€0.26matched
137capture01a1a251-0ba7-73a1-890d-33bd0c9ddd71€49.00€0.67matched
138capture01a1a251-1bd6-7c3c-89a6-f93d7fff63b6€15.00€0.26matched
139capture01a1a251-33dd-754c-8a47-9775a21ae8d1€15.00€0.26matched
140capture01a1a251-4221-747e-92a4-f03eab1acf70€24.00€0.37matched