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, 02:20

Gross

€3,186.00

PSP fee

€49.81

Net to the bank

€3,136.19

Settlement journal

#353467

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19f3b-1ca7-7bc4-8ca8-ffea5d802547 is already settled by stl_EUR_2989454 line 86
  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
LineKindReferenceGrossFeeStatus
87capture01a19f3b-1cba-78bc-879a-b56881d5a0fd€35.00€0.50duplicate line
103capture01a19f3c-0b86-7707-af4b-2710baa2ff35€15.00€0.31fee difference
1capture01a19f2d-1f2a-7eaa-a826-b40dcde98caf€9.00€0.19matched
2capture01a19f31-2fb8-7fc9-8744-bcfaa64e6e85€15.00€0.26matched
3capture01a19f34-ed1c-7d20-bd87-5725111c0c65€35.00€0.50matched
4capture01a19f34-f8b6-7276-8417-bac93f5e60cc€24.00€0.37matched
5capture01a19f35-1eaf-7797-a911-35ca6bccb523€15.00€0.26matched
6capture01a19f35-2309-73d0-b51a-7aa410b55d13€49.00€0.67matched
7capture01a19f35-2dcf-758c-9b81-e32e66286e0d€35.00€0.50matched
8refund01a19f35-6654-7f5c-8ec4-46c340d823b7-€18.00€0.00matched
9capture01a19f35-a756-73fd-b1ce-4058c19f0a47€24.00€0.37matched
10capture01a19f35-a918-7a0b-9999-121b6a8e1faf€35.00€0.50matched
11capture01a19f35-ce9b-71a6-8c3e-ad95ca664658€49.00€0.67matched
12capture01a19f35-ecf1-70cb-b63d-74c1c6959391€24.00€0.37matched
13capture01a19f35-fd50-7ce3-82f9-2054a9ee8103€24.00€0.37matched
14capture01a19f36-1090-71f2-9fa9-955923712cf8€35.00€0.50matched
15capture01a19f36-18b1-7c1a-b02e-957264f5bca6€24.00€0.37matched
16capture01a19f36-2aaa-754f-b1fc-de32a2286635€24.00€0.37matched
17capture01a19f36-35a5-7ce9-8448-e358d2bd7fad€35.00€0.50matched
18capture01a19f36-5122-744d-9a2d-bc6f53f2f0ed€9.00€0.19matched
19capture01a19f36-5204-7436-b68e-321ad2099ca4€49.00€0.67matched
20capture01a19f36-690a-7de4-a61e-c6d5bee91a58€35.00€0.50matched
21capture01a19f36-6a26-7725-9b89-24d530c8b69f€49.00€0.67matched
22capture01a19f36-8186-7a9f-a22a-b765b68ae62a€9.00€0.19matched
23capture01a19f36-9a5c-7d67-8352-c6c51b795a20€49.00€0.67matched
24capture01a19f36-b622-7bdc-97e3-6c4c53a48134€15.00€0.26matched
25capture01a19f36-bd81-7464-bf61-0e64a4d8c9d3€35.00€0.50matched
26capture01a19f36-cac5-7583-a8da-be6afaf4de9a€35.00€0.50matched
27capture01a19f36-d182-72ab-aef3-eb12c087a55d€35.00€0.50matched
28capture01a19f37-08ad-7da3-a6a8-82bc0bf2de36€49.00€0.67matched
29capture01a19f37-09d5-7055-aef3-f9fd4a7d7029€15.00€0.26matched
30capture01a19f37-2050-7558-9d10-efeb1bcf7a95€15.00€0.26matched
31capture01a19f37-2812-712a-8292-6b2610fcb8e9€15.00€0.26matched
32capture01a19f37-3123-73b2-96df-98aa18bb4b1d€49.00€0.67matched
33capture01a19f37-938e-784c-8ad7-68f54ac3ff9b€35.00€0.50matched
34capture01a19f37-96ff-7cb7-81b9-a6a581931a9b€35.00€0.50matched
35capture01a19f37-9e34-7e1b-b857-bdfc6184e9e3€15.00€0.26matched
36capture01a19f37-a429-7627-8c99-e083a07c911a€15.00€0.26matched
37capture01a19f37-abed-7374-bb15-9e3136c8cbab€24.00€0.37matched
38capture01a19f37-bbeb-72bb-a7d6-1d8fbe8e3453€9.00€0.19matched
39capture01a19f37-dea0-7640-8419-d769ee5da7db€9.00€0.19matched
40capture01a19f37-dfb9-77bb-81a3-f9a81420ec1b€15.00€0.26matched
41capture01a19f37-e459-7e05-ab23-d2c791da44c1€9.00€0.19matched
42capture01a19f37-ec96-75fb-82be-e3c19b2f00ce€15.00€0.26matched
43capture01a19f37-f832-79c8-972a-7bd7a5d4a09e€49.00€0.67matched
44capture01a19f38-04d3-7e48-a378-181c83e56f2d€24.00€0.37matched
45capture01a19f38-8543-7ced-921b-4b86e980f9bd€35.00€0.50matched
46capture01a19f38-8dd5-787d-890a-55d8f77c56d3€49.00€0.67matched
47capture01a19f38-8a36-7e44-b423-945d7dd2be59€49.00€0.67matched
48capture01a19f38-aae4-765c-a046-8255f7c15878€9.00€0.19matched
49capture01a19f38-af5c-7e9c-b301-0dce490bb27e€49.00€0.67matched
50capture01a19f38-ba27-7742-aa7a-445d46a769cf€15.00€0.26matched
51capture01a19f38-c2b2-7a0c-a5b7-8a2a0149c6b0€49.00€0.67matched
52capture01a19f38-b2cc-7ea8-bf5a-7f300f37afd4€15.00€0.26matched
53capture01a19f38-cfe2-73dc-95e6-b65d611c7288€35.00€0.50matched
54capture01a19f38-d1b3-7623-bf66-106386d295c4€15.00€0.26matched
55capture01a19f38-e619-78e7-8817-4d86969a5b33€15.00€0.26matched
56refund01a19f38-eda1-7039-94a2-2815b72ab8f2-€5.00€0.00matched
57capture01a19f39-1941-7842-a7be-9db50332c33e€24.00€0.37matched
58capture01a19f39-28a0-78c8-9430-aa96ce14d57c€9.00€0.19matched
59capture01a19f39-2a33-756c-8e21-44a5a5d98e56€35.00€0.50matched
60capture01a19f39-33c7-73c7-ae0a-3e394932f6a2€15.00€0.26matched
61capture01a19f39-41e4-7d34-8395-dd2f385cab34€9.00€0.19matched
62capture01a19f39-5678-7fb7-af5f-e59f80fb89db€49.00€0.67matched
63capture01a19f39-9c1c-70b7-adae-9c63c864b743€49.00€0.67matched
64capture01a19f39-ef89-75dc-ba8c-374cae69c55e€15.00€0.26matched
65capture01a19f3a-1792-73e3-8104-c5925e77db58€49.00€0.67matched
66capture01a19f3a-050f-73ac-adc2-06167bdfb853€15.00€0.26matched
67capture01a19f3a-2b66-74dd-9dbf-9941cddf972a€35.00€0.50matched
68capture01a19f3a-33cc-700f-9b5d-d2a96022d8be€9.00€0.19matched
69capture01a19f3a-4d28-76ce-8765-06518299cad3€15.00€0.26matched
70capture01a19f3a-5ac0-7886-b465-79311b8019f2€15.00€0.26matched
71capture01a19f3a-66a3-7f34-860d-8182d03af3d3€49.00€0.67matched
72refund01a19f3a-6bc2-781e-bd77-c740adc84034-€29.00€0.00matched
73capture01a19f3a-7922-773e-9929-b70f75cbdedf€49.00€0.67matched
74capture01a19f3a-800b-7519-bec9-85ac102ba116€9.00€0.19matched
75capture01a19f3a-950f-7aa5-944e-3d62549303bb€15.00€0.26matched
76capture01a19f3a-ac6b-71cf-9ec1-a7d8cae36246€24.00€0.37matched
77capture01a19f3a-adb8-7d0d-a0e7-46fc37d68088€24.00€0.37matched
78capture01a19f3a-bd3b-7db6-9ae8-6fd131326fb0€9.00€0.19matched
79capture01a19f3a-cf94-70a2-a62a-83ffaaa536d1€24.00€0.37matched
80refund01a19f3a-db21-7669-a2e5-ec2c210bcd73-€34.00€0.00matched
81capture01a19f3a-dc10-747f-9b29-47f5689a86c3€9.00€0.19matched
82capture01a19f3a-e240-7283-a429-1cb2a18920c4€9.00€0.19matched
83capture01a19f3a-f92a-780f-9b8d-8f7841b90d65€24.00€0.37matched
84capture01a19f3b-0b7c-7de6-82ee-aa6249b5578b€49.00€0.67matched
85capture01a19f3b-11df-7b80-a586-1a12e6caa108€35.00€0.50matched
86capture01a19f3b-1cba-78bc-879a-b56881d5a0fd€35.00€0.50matched
88capture01a19f3b-2599-7deb-a356-ddeb8addd359€49.00€0.67matched
89capture01a19f3b-2a79-7bbd-af55-726db46b18f9€35.00€0.50matched
90capture01a19f3b-45a6-7184-8952-afd9807a48a4€24.00€0.37matched
91capture01a19f3b-4e69-7d78-ae04-b235a0c072fa€9.00€0.19matched
92capture01a19f3b-532d-7371-b2a0-b330582afde2€15.00€0.26matched
93capture01a19f3b-7ba0-770d-ace1-930e6b94d6be€49.00€0.67matched
94capture01a19f3b-8031-7768-b6f5-93a7ab53d0fa€49.00€0.67matched
95capture01a19f3b-8995-7141-ae50-7b64106304da€15.00€0.26matched
96capture01a19f3b-8ec8-7e98-9455-5d42ae352b60€24.00€0.37matched
97capture01a19f3b-901e-7705-8cd3-5e2d740defdf€49.00€0.67matched
98capture01a19f3b-95cb-757a-b718-2c93eb614259€9.00€0.19matched
99capture01a19f3b-9689-7d4b-9a13-3e32c397bc20€24.00€0.37matched
100capture01a19f3b-bc7f-7922-a6f6-bc7100a89441€15.00€0.26matched
101refund01a19f3b-be0b-741c-83fb-7a8780ee7644-€35.00€0.00matched
102capture01a19f3c-077f-7a80-a309-70eab5c854d3€9.00€0.19matched
104capture01a19f3c-11c3-76f9-a773-26cbf6eb278b€15.00€0.26matched
105capture01a19f3c-26a1-7ca8-a55a-896fc0d1161e€9.00€0.19matched
106capture01a19f3c-30d6-7f31-bddc-47aa8af0aae4€24.00€0.37matched
107capture01a19f3c-3917-780f-8b09-2d1d1ba71e24€35.00€0.50matched
108capture01a19f3c-54b1-7063-b3fa-f5ed75443066€49.00€0.67matched
109capture01a19f3c-70cd-7b29-85a7-051e32b63343€15.00€0.26matched
110capture01a19f3c-8164-7c27-99fd-2c0290ab69f2€35.00€0.50matched
111capture01a19f3c-9786-7321-a911-c30fa9ae2528€24.00€0.37matched
112capture01a19f3c-9f29-7701-8361-1747380e446d€9.00€0.19matched
113capture01a19f3c-a35c-7fb2-a25c-47be21b6dc5a€35.00€0.50matched
114capture01a19f3c-b0c9-7ccd-b22d-96899a27af00€24.00€0.37matched
115refund01a19f3c-cab0-7b50-bdd1-0562262b8cbe-€15.00€0.00matched
116capture01a19f3c-cc64-7a1c-9a72-0958e433147f€49.00€0.67matched
117capture01a19f3c-ef4e-7523-9ca5-bac0cedc1e89€9.00€0.19matched
118capture01a19f3c-ef70-7476-8c97-990c8e9c52e4€35.00€0.50matched
119capture01a19f3c-fcec-7666-b1aa-e99041643075€35.00€0.50matched
120capture01a19f3d-04d6-72f3-9c7d-6cc51e2ccc11€35.00€0.50matched
121capture01a19f3d-4ca1-740e-98c4-25b0e54490db€49.00€0.67matched
122capture01a19f3d-5074-778e-a383-ec80dbf44f12€49.00€0.67matched
123capture01a19f3d-5470-7542-88c0-975e451693a8€24.00€0.37matched
124capture01a19f3d-86ba-7c87-a59f-4b69fab688bc€15.00€0.26matched
125capture01a19f3d-a531-7328-8ae8-2ac61c2a1481€35.00€0.50matched
126capture01a19f3d-d3e6-71e6-b1c8-833a541f5b0b€9.00€0.19matched
127capture01a19f3d-f032-7feb-bdb1-388e8ac44f89€15.00€0.26matched
128capture01a19f3d-f041-73a8-a6ae-c867ab5e1064€49.00€0.67matched