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, 01:40

Gross

€2,854.00

PSP fee

€45.42

Net to the bank

€2,808.58

Settlement journal

#371098

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a43d-42fa-7bb4-858c-2f5bc2aa68db is already settled by stl_EUR_2989594 line 96
  • missing linein the books, not in the filecapture:01a1a43d-84c8-76be-8139-8b2e76854c93 is in no file
LineKindReferenceGrossFeeStatus
97capture01a1a43d-4323-7ccf-ada0-0840940fa316€24.00€0.37duplicate line
1capture01a1a436-9b4b-7e90-8166-a5132ac137b9€35.00€0.50matched
2capture01a1a436-e2a4-70ff-bb4b-01c4112b1d9d€35.00€0.50matched
3capture01a1a436-f037-7a7a-985b-060ebad857e8€15.00€0.26matched
4capture01a1a436-f5e2-755e-a84e-1932f56e12c1€35.00€0.50matched
5capture01a1a437-07f1-7991-a571-f26c4d99e918€24.00€0.37matched
6capture01a1a437-1490-7c20-b7aa-8b978c1411ca€24.00€0.37matched
7capture01a1a437-215a-7636-beed-7c14bc79ea01€35.00€0.50matched
8capture01a1a437-25cf-7e9c-8ead-c188f0697c9b€9.00€0.19matched
9refund01a1a437-4bc3-7e9c-8b2d-87abbdda5b79-€14.00€0.00matched
10capture01a1a437-568d-73e9-bc6a-af31c0c4e7fe€24.00€0.37matched
11capture01a1a437-6b96-726b-acfb-151639ef6549€15.00€0.26matched
12capture01a1a437-6de3-7e48-8bdf-45c6fea43883€49.00€0.67matched
13capture01a1a437-7fae-7fcc-a21e-6f4d9a1d879f€15.00€0.26matched
14capture01a1a437-b020-70d5-aed7-631b8143c803€15.00€0.26matched
15capture01a1a437-b802-7f2f-aab1-fa1962b5c499€49.00€0.67matched
16capture01a1a437-f3b2-787d-ac50-15090f80d4d7€24.00€0.37matched
17capture01a1a438-057b-7ebe-b966-92265d12a6de€49.00€0.67matched
18capture01a1a438-3094-7fb6-8156-b03147036813€9.00€0.19matched
19capture01a1a438-3731-7132-b0ae-54462855216f€49.00€0.67matched
20capture01a1a438-47cb-7eb5-91c8-dc39ab0f105b€35.00€0.50matched
21capture01a1a438-6427-786b-baea-f606bd839ff8€35.00€0.50matched
22capture01a1a438-7775-71a9-940e-43dfb5a0d016€24.00€0.37matched
23capture01a1a438-7a7a-73f1-8f8d-7adf1e61a460€49.00€0.67matched
24capture01a1a438-8a1e-7d74-93e0-b6f91287f381€35.00€0.50matched
25capture01a1a438-be74-7320-84b2-ebd29b382ac1€15.00€0.26matched
26capture01a1a438-c6ad-7629-9ebb-b2595bcb5511€35.00€0.50matched
27capture01a1a438-cff1-7967-ab87-ce567f7821d9€15.00€0.26matched
28capture01a1a438-d513-7827-83bd-9be3c48c3124€35.00€0.50matched
29capture01a1a438-dfe3-7628-9e2e-1fadd359871e€35.00€0.50matched
30capture01a1a438-f2c8-7ffe-91bb-12e58fd2c9af€9.00€0.19matched
31capture01a1a439-1eaf-7159-a88e-f69487da0ef5€15.00€0.26matched
32capture01a1a439-345d-722e-b7c3-0775890e5988€9.00€0.19matched
33capture01a1a439-5295-7e68-97a0-4d67b58e62fe€15.00€0.26matched
34capture01a1a439-5545-7beb-b24c-1b3e488714f7€9.00€0.19matched
35capture01a1a439-5703-76c1-a7e1-c943b651d8c7€49.00€0.67matched
36capture01a1a439-67c3-7bf7-9cec-169ee6fdda7d€9.00€0.19matched
37capture01a1a439-789c-7056-be55-48251a26ae66€15.00€0.26matched
38capture01a1a439-78ba-7475-951c-5fc52acf6d0d€15.00€0.26matched
39capture01a1a439-7fc4-7502-8ea6-6a5661884b9b€9.00€0.19matched
40capture01a1a439-8457-7fad-9910-c8851ae2a5ce€24.00€0.37matched
41capture01a1a439-9add-7e6c-a472-aa9e6bd8d5cd€9.00€0.19matched
42capture01a1a439-9cec-7e4a-bdbe-e6f3edc9504b€35.00€0.50matched
43capture01a1a439-a0b1-79c7-9881-48ddbe24abe1€35.00€0.50matched
44capture01a1a439-c779-7f10-8a4d-3ae7f8901de2€35.00€0.50matched
45capture01a1a439-d49b-730c-b133-8d8050bb9661€35.00€0.50matched
46capture01a1a439-ebb4-7f3f-a75a-6206e9957dff€35.00€0.50matched
47capture01a1a439-f3ec-7cb2-a2ae-863fcd8e0a4a€9.00€0.19matched
48capture01a1a43a-27d0-7db4-a263-ce04b3bc0206€24.00€0.37matched
49capture01a1a43a-43ec-7b67-85c5-08a59adff980€15.00€0.26matched
50capture01a1a43a-5114-747d-bddf-f3838e8b7a6e€49.00€0.67matched
51capture01a1a43a-5282-7447-97b3-4c0b3a87870d€15.00€0.26matched
52capture01a1a43a-5fba-7daa-a40c-5b25adf265e0€9.00€0.19matched
53capture01a1a43a-6287-770f-b917-e12a753cb9be€35.00€0.50matched
54capture01a1a43a-7d6c-765d-838c-60ecd49401fc€24.00€0.37matched
55refund01a1a43a-7fd5-7973-8f1f-85e4b0157761-€12.00€0.00matched
56capture01a1a43a-814e-7bbf-ad34-30c3b9dc3857€9.00€0.19matched
57capture01a1a43a-8869-7d44-b4fc-5c59a7d2c7c6€15.00€0.26matched
58capture01a1a43a-8cba-7819-a7a5-37a5fb4648bb€49.00€0.67matched
59capture01a1a43a-940a-720e-98ce-368ba501162b€49.00€0.67matched
60capture01a1a43a-b868-7ffd-8620-0b05a556ba0d€49.00€0.67matched
61capture01a1a43a-c348-7348-a069-cf67b4e0073a€35.00€0.50matched
62capture01a1a43a-c7a3-7145-92b6-fec9d5d36714€49.00€0.67matched
63capture01a1a43a-e61e-7d55-95ee-a12846036ac7€24.00€0.37matched
64capture01a1a43a-eb40-7652-b6ee-7414c860cc67€49.00€0.67matched
65capture01a1a43a-f04f-7f7a-a5ce-81d81a14f7e3€15.00€0.26matched
66capture01a1a43a-f700-7a61-a11e-6f09019f3700€24.00€0.37matched
67capture01a1a43b-0ec0-7a72-a8e4-42530ccd3b48€49.00€0.67matched
68refund01a1a43b-2123-7625-9337-ce67fea2e010-€15.00€0.00matched
69capture01a1a43b-7040-72d4-835a-b993ef88288e€49.00€0.67matched
70capture01a1a43b-734b-7e3b-85ba-4209436765f2€15.00€0.26matched
71capture01a1a43b-793e-7204-bd8c-406ad705563c€49.00€0.67matched
72capture01a1a43b-d33b-7ff2-8bec-aa32c99e7ecb€35.00€0.50matched
73capture01a1a43b-d4c8-744b-8101-6439a8ff15c1€49.00€0.67matched
74capture01a1a43b-e2d5-776b-9dd8-c9363551f4c5€24.00€0.37matched
75capture01a1a43b-e93a-7851-a16c-25523d2e1eb3€15.00€0.26matched
76capture01a1a43b-eb8d-7cf4-bbf9-d4d96d63c1b1€9.00€0.19matched
77capture01a1a43b-f5cc-79b5-bdbb-16d37d8eb52c€24.00€0.37matched
78capture01a1a43b-f877-7868-8f95-b605e40f12fd€15.00€0.26matched
79capture01a1a43b-f8ba-792b-a55b-3a4942b36e39€35.00€0.50matched
80capture01a1a43c-157b-7b0c-bc89-206f59044df2€35.00€0.50matched
81capture01a1a43c-1bab-72e6-bd4a-fd875779d2ef€15.00€0.26matched
82capture01a1a43c-20b9-729f-972e-11bb9941a1a1€9.00€0.19matched
83capture01a1a43c-2820-705b-b72a-6638015bc069€15.00€0.26matched
84capture01a1a43c-2868-7fec-904e-de59c411e09f€49.00€0.67matched
85refund01a1a43c-2a6d-79ec-9b30-93d5a62289c4-€7.00€0.00matched
86refund01a1a43c-4133-7637-9c84-f41dc3b9c0fe-€9.00€0.00matched
87capture01a1a43c-4925-78ac-84da-819f775741eb€49.00€0.67matched
88refund01a1a43c-554b-7226-97f5-237204d20773-€15.00€0.00matched
89capture01a1a43c-6510-7d54-9c84-1b03e484aba0€9.00€0.19matched
90capture01a1a43c-cecc-7340-9a93-c4dc3ec3ab5d€15.00€0.26matched
91capture01a1a43c-e7f3-78c8-a822-5181166bdeeb€49.00€0.67matched
92capture01a1a43d-0ee2-7ce0-84f9-14104d012d42€9.00€0.19matched
93capture01a1a43d-31b2-7df4-93af-aa2917a9c00b€9.00€0.19matched
94capture01a1a43d-420c-7d57-b0dd-f77c01eae7f3€24.00€0.37matched
95refund01a1a43d-42be-704d-8cdf-494e15dbbbaf-€5.00€0.00matched
96capture01a1a43d-4323-7ccf-ada0-0840940fa316€24.00€0.37matched
98capture01a1a43d-550d-7778-af2e-15a614b6cdb4€24.00€0.37matched
99capture01a1a43d-5800-7f6f-a6c8-2128f5a52d7a€9.00€0.19matched
100capture01a1a43d-6a99-7e80-8651-70afc8d48bff€24.00€0.37matched
101refund01a1a43d-839a-72a8-be1f-12953f927f8d-€14.00€0.00matched
102capture01a1a43d-9a82-79bf-9627-a4544519b67c€35.00€0.50matched
103capture01a1a43d-bfc3-7729-b5ed-1cafa6c6d303€15.00€0.26matched
104capture01a1a43d-e1aa-7ed6-b072-a8f77a9e7c6c€35.00€0.50matched
105capture01a1a43e-0c4b-72ee-9e72-6336ea09f570€35.00€0.50matched
106capture01a1a43e-461e-7402-8c72-b04fdce7d21e€15.00€0.26matched
107refund01a1a43e-4622-7d42-bb0e-35e29474f754-€40.00€0.00matched
108capture01a1a43e-4a23-7d56-a131-5b381b70f1c2€9.00€0.19matched
109capture01a1a43e-4c5d-743d-8435-0be3e91dea4c€49.00€0.67matched
110capture01a1a43e-4e50-7190-b43f-0a5bc14f9576€9.00€0.19matched
111capture01a1a43e-6711-74f8-904e-173101517a09€9.00€0.19matched
112capture01a1a43e-68c7-7717-ae7a-2f38bb48f7a4€49.00€0.67matched
113capture01a1a43e-8cb7-7cb5-a978-f99c2a5f7583€24.00€0.37matched
114capture01a1a43e-9264-7071-803f-a7c171df6b8b€24.00€0.37matched
115capture01a1a43e-9aea-7413-8c9d-868cb1d48034€35.00€0.50matched
116refund01a1a43e-9dc9-7555-82c1-a1603aaf7901-€12.00€0.00matched
117refund01a1a43f-0ef8-7019-aaec-e292636e2afe-€31.00€0.00matched
118capture01a1a43f-24c1-7633-8196-1b65a2096c8c€35.00€0.50matched
119capture01a1a43f-456f-774f-9192-926acee5dfb0€35.00€0.50matched
120capture01a1a43f-51f6-7d9e-b427-fedc4754e682€24.00€0.37matched
121capture01a1a43f-77d8-7baf-bfce-751d105d3164€49.00€0.67matched
122capture01a1a43f-8033-7356-91c5-cc666d5a26e2€35.00€0.50matched
123capture01a1a43f-964c-7d89-af4f-d68e3354c7cb€15.00€0.26matched