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, 22:00

Gross

€2,900.00

PSP fee

€45.16

Net to the bank

€2,854.84

Settlement journal

#404876

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1adbd-448d-7600-988e-94ccf82b77a4 is already settled by stl_EUR_2989860 line 46
  • missing linein the books, not in the filecapture:01a1adbc-1ec7-76cc-851a-af4cfe69b03f is in no file
  • missing linein the books, not in the filecapture:01a1adc1-7254-712d-8c75-99d9132068f5 is in no file
LineKindReferenceGrossFeeStatus
47capture01a1adbd-44c2-7f34-8c55-5bcd1e492ee6€15.00€0.26duplicate line
1capture01a1adb6-ea13-7860-8fb5-6f2745479a01€24.00€0.37matched
2capture01a1adb9-eef5-7115-95d9-85e545a5b0f4€9.00€0.19matched
3capture01a1adb9-f97f-7cd4-8b4c-5aa5e349cb10€15.00€0.26matched
4capture01a1adb9-fe3b-7190-a004-e357bf71efe7€15.00€0.26matched
5capture01a1adba-2e9d-7dbc-943f-ee75c204badd€35.00€0.50matched
6capture01a1adba-35f8-77ee-a798-e4bb9b004a62€9.00€0.19matched
7capture01a1adba-3bcc-75eb-9741-80fe4695d999€49.00€0.67matched
8capture01a1adba-3e07-7bb5-b5a9-77d5be952d8f€15.00€0.26matched
9capture01a1adba-4d1a-785a-b075-90ae42f8e9d1€35.00€0.50matched
10capture01a1adba-4f90-7719-a1af-88cf212240f9€49.00€0.67matched
11refund01a1adba-5a41-78fd-b3f2-ac9f2c7e5988-€5.00€0.00matched
12capture01a1adba-63a6-7496-8716-07342c5029c0€49.00€0.67matched
13capture01a1adba-7799-72f2-ab95-a961cea5c4f3€35.00€0.50matched
14capture01a1adba-9a70-784a-a87e-47d7adecae64€24.00€0.37matched
15capture01a1adba-9eed-7415-bc36-a45fe0f182d5€15.00€0.26matched
16capture01a1adba-d059-7184-b2bb-5d140b48c093€15.00€0.26matched
17capture01a1adba-e44c-7313-8587-7e35536b32fe€49.00€0.67matched
18capture01a1adba-e8c5-7409-bddf-f0f5659f173c€49.00€0.67matched
19capture01a1adba-eaa8-75b6-9c5a-3535753a0b80€9.00€0.19matched
20capture01a1adbb-0e1e-7dba-b57d-b567a1a05006€15.00€0.26matched
21capture01a1adbb-175a-7b7b-9237-161560f3213f€24.00€0.37matched
22capture01a1adbb-9eec-7fca-b9c4-9a7d8efbe453€15.00€0.26matched
23capture01a1adbb-a42b-70e5-8cb8-7fd9e7afe91b€15.00€0.26matched
24capture01a1adbb-a7cb-7840-bba5-3ffdbaf0ba0f€49.00€0.67matched
25capture01a1adbb-d848-7a5a-9ade-29c911daf30d€15.00€0.26matched
26capture01a1adbc-001b-7e64-9150-b84178e698c2€9.00€0.19matched
27capture01a1adbc-0446-7594-a813-34a11bbce3b4€35.00€0.50matched
28capture01a1adbc-1f98-72b3-a3a6-b2d92b463ccf€9.00€0.19matched
29capture01a1adbc-36ec-7201-8387-e247fb850a5b€35.00€0.50matched
30capture01a1adbc-388a-7ebb-8a6f-6649d11e90d2€24.00€0.37matched
31capture01a1adbc-4402-7113-9ac7-81233527f7f7€9.00€0.19matched
32capture01a1adbc-4528-7f4f-b802-b2582e71e2cb€24.00€0.37matched
33capture01a1adbc-5071-756f-af5a-b33e788aae77€15.00€0.26matched
34capture01a1adbc-540d-7397-80c9-c19afccaeb6d€9.00€0.19matched
35capture01a1adbc-604f-7739-a94c-35a912b27c83€24.00€0.37matched
36capture01a1adbc-61e5-7446-a14c-8b570f4f9460€24.00€0.37matched
37capture01a1adbc-7a46-7a97-b235-1a57826526b8€49.00€0.67matched
38capture01a1adbc-91bb-7446-85c1-cfc2df15d32e€24.00€0.37matched
39capture01a1adbc-b19c-76d5-919f-6e84478c3700€35.00€0.50matched
40capture01a1adbc-b22f-78de-9874-3ad5b53d8417€24.00€0.37matched
41capture01a1adbc-b919-72e6-bd7a-705247a3370c€49.00€0.67matched
42capture01a1adbc-d239-7899-9d50-d936547f07bb€15.00€0.26matched
43capture01a1adbc-e4b4-7745-8ad5-4342d43db4d9€15.00€0.26matched
44capture01a1adbd-119e-713c-bf77-92f436388e6e€49.00€0.67matched
45capture01a1adbd-435e-7d55-b5db-28a990f9440a€15.00€0.26matched
46capture01a1adbd-44c2-7f34-8c55-5bcd1e492ee6€15.00€0.26matched
48capture01a1adbd-6a63-7fa9-bc56-7f760fcb2aa7€24.00€0.37matched
49capture01a1adbd-84e9-75ff-aac3-caf2f215edb5€49.00€0.67matched
50capture01a1adbd-a898-72d8-9155-16c480b9aa2c€24.00€0.37matched
51capture01a1adbd-b35d-720d-a878-b5f3da531403€9.00€0.19matched
52capture01a1adbd-d885-7045-9a16-5301adff31e9€35.00€0.50matched
53capture01a1adbd-ec9d-795b-8446-f66616e72338€9.00€0.19matched
54refund01a1adbd-f767-7185-9428-5cb5dfaa9e4e-€5.00€0.00matched
55capture01a1adbe-1712-71f4-962e-77e6510fc9be€49.00€0.67matched
56capture01a1adbe-1e99-770e-811e-cd9f867a1cc9€49.00€0.67matched
57capture01a1adbe-318f-7fa6-bd9f-d58f05992281€24.00€0.37matched
58capture01a1adbe-469e-70f3-b19a-dcae60942de4€24.00€0.37matched
59capture01a1adbe-8e94-78f6-9830-88b53c8b7ecd€35.00€0.50matched
60capture01a1adbe-8fec-74c3-bcf3-ff93afd62278€35.00€0.50matched
61capture01a1adbe-a9b6-7a5c-8d45-d3bbb71a6c49€35.00€0.50matched
62capture01a1adbe-c160-739a-b116-d8b2ce51a2fa€15.00€0.26matched
63capture01a1adbe-d524-7ff8-9929-dcdb5a5ba09a€35.00€0.50matched
64capture01a1adbe-e57c-793d-8735-90d6c089f162€35.00€0.50matched
65capture01a1adbe-e659-7392-a80c-26d6fae74530€24.00€0.37matched
66capture01a1adbe-f89b-7f74-8c2a-29be9496e309€35.00€0.50matched
67capture01a1adbe-fcb8-712b-85d1-afd622bf195f€49.00€0.67matched
68refund01a1adbe-fe12-71ae-81bc-4942cbb71650-€23.00€0.00matched
69capture01a1adbf-0314-765c-abb5-d15495ad9a64€35.00€0.50matched
70capture01a1adbf-0a5d-7761-b19d-7a84f275cbe8€15.00€0.26matched
71capture01a1adbf-4605-7f80-9685-f1892226c852€24.00€0.37matched
72capture01a1adbf-4a7c-725f-8a01-9b8fd1733b6f€24.00€0.37matched
73refund01a1adbf-5c55-7ee1-a832-d4bc0e90f163-€34.00€0.00matched
74capture01a1adbf-5ee3-7820-bacb-11c88607d0c2€9.00€0.19matched
75capture01a1adbf-6098-793b-9c25-53563675c437€15.00€0.26matched
76capture01a1adbf-823b-76c4-9c45-3b34e74b692e€35.00€0.50matched
77refund01a1adbf-8718-77d5-9a61-73f24a5f3e6e-€8.00€0.00matched
78capture01a1adbf-877c-7577-9060-ad94ec2787fe€49.00€0.67matched
79capture01a1adbf-898f-72e9-9104-d5a0fcd5ce1f€15.00€0.26matched
80capture01a1adbf-8e47-723f-bf04-54211b8f919b€49.00€0.67matched
81capture01a1adbf-9986-722b-807b-9b71f030d0fc€35.00€0.50matched
82capture01a1adc0-250c-73c2-a6f6-201d1a1edc03€24.00€0.37matched
83capture01a1adc0-27b9-7435-8a75-98c8a962ea64€24.00€0.37matched
84capture01a1adc0-3af1-7a15-96d7-4bd825f97190€9.00€0.19matched
85capture01a1adc0-3ba5-7246-8b57-fc0a1dbf5ee9€15.00€0.26matched
86capture01a1adc0-4d93-7767-93f2-8f944ec46208€15.00€0.26matched
87capture01a1adc0-610b-7241-8dbf-83b876cdb13a€24.00€0.37matched
88capture01a1adc0-6e73-70a2-9f85-94a25e5cbd75€15.00€0.26matched
89capture01a1adc0-75a8-7be4-a6bd-cf2987adbc48€35.00€0.50matched
90capture01a1adc0-7a3f-7f9e-87ed-bd3c0251b0fb€35.00€0.50matched
91capture01a1adc0-879f-7eca-8eb3-ee842519bec5€9.00€0.19matched
92capture01a1adc0-a2ab-7b7c-b499-fd9542e94d6a€35.00€0.50matched
93capture01a1adc0-aa11-7009-9662-694982e2ff2a€35.00€0.50matched
94capture01a1adc0-d93c-73c6-857c-c163bb667e65€49.00€0.67matched
95capture01a1adc1-030e-7e2d-9d89-1424e109f475€35.00€0.50matched
96capture01a1adc1-2502-7c20-9858-ce63ddf8634c€24.00€0.37matched
97capture01a1adc1-2808-7731-909d-ba7e548c451f€15.00€0.26matched
98capture01a1adc1-3678-70fb-bf87-702ea0ce1761€35.00€0.50matched
99capture01a1adc1-50db-7bfc-a568-78d369769dfa€9.00€0.19matched
100capture01a1adc1-5391-7051-9f94-7494c6c4e4e3€35.00€0.50matched
101capture01a1adc1-61a1-7844-a527-d0f834e4ddf2€9.00€0.19matched
102capture01a1adc1-7d09-7914-8811-cb09a7f137fb€49.00€0.67matched
103capture01a1adc1-8b09-703a-8a9a-242c1a2c46e5€49.00€0.67matched
104capture01a1adc1-a4ba-7a47-bc2a-def1dc98e6c5€24.00€0.37matched
105refund01a1adc1-a55f-798a-848d-538bb4bab30c-€15.00€0.00matched
106capture01a1adc1-dd5c-73ee-9c19-13f5ba48888a€35.00€0.50matched
107capture01a1adc1-ea3e-7316-a4fe-76a94801c89f€49.00€0.67matched
108capture01a1adc2-0a2a-7bf6-bf07-94b2466f0ebb€15.00€0.26matched
109capture01a1adc2-0c3a-7fc5-896d-a6c61fe30fcc€49.00€0.67matched
110capture01a1adc2-3bb4-7f85-9c16-c16d01bb2caa€9.00€0.19matched
111capture01a1adc2-4901-73c8-b4e8-56a6fa1043c2€15.00€0.26matched
112capture01a1adc2-5df4-7e70-9a9a-106f41ec2121€15.00€0.26matched
113capture01a1adc2-5e65-7a26-b5f6-c1553deb3316€24.00€0.37matched
114refund01a1adc2-a766-7aa3-ab96-87728f15ee22-€10.00€0.00matched
115capture01a1adc2-b54b-7fd3-9c24-124dd4fe2b8e€24.00€0.37matched
116capture01a1adc2-b6fe-7eeb-8f86-8b357cfa757e€15.00€0.26matched
117capture01a1adc2-cda7-7895-a398-8c3f9eaa0478€35.00€0.50matched
118capture01a1adc2-e277-7e67-8b50-4e5f2b8cf558€35.00€0.50matched
119capture01a1adc2-ecfe-70e6-a9ad-584124177279€9.00€0.19matched
120capture01a1adc2-fe07-74c1-8f43-4110e3b1b46a€9.00€0.19matched