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

2 Nov, 07:20

Gross

€3,294.00

PSP fee

€51.80

Net to the bank

€3,242.20

Settlement journal

#338877

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 69, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • missing linein the books, not in the filecapture:01a19b28-cf21-7242-a769-20333e9710c5 is in no file
  • missing linein the books, not in the filecapture:01a19b21-a196-74b9-9575-eef211f54296 is in no file
LineKindReferenceGrossFeeStatus
57capture01a19b24-741b-79f1-91cc-ef54b7842c3d€49.00€0.69fee difference
89capture01a19b26-a456-7236-98dc-e2d36346a986€9.00€0.23fee difference
97capture01a19b27-2af0-7832-82e7-90f3bdea01ed€15.00€0.29fee difference
1capture01a19b18-cef1-7871-85ed-fbe5911a296a€49.00€0.67matched
2capture01a19b1f-7d81-793c-947f-c62c3e7c3b39€49.00€0.67matched
3capture01a19b21-25ec-796c-8499-0599b47c99e5€9.00€0.19matched
4capture01a19b21-2e22-7e2d-9a16-04e04213e5fa€9.00€0.19matched
5capture01a19b21-31ae-7a0f-8832-d252b5f5188a€9.00€0.19matched
6capture01a19b21-3230-761b-a996-fafe4eaa8bd9€9.00€0.19matched
7capture01a19b21-34d8-7760-9868-c7f4ba21c9f4€35.00€0.50matched
8capture01a19b21-3ae2-725f-bd34-d2e9b1c83d28€49.00€0.67matched
9capture01a19b21-3bbd-7415-8758-a712cdb0e078€24.00€0.37matched
10capture01a19b21-4f38-7097-a014-a558cc9f7133€35.00€0.50matched
11refund01a19b21-89ec-70da-85f3-ff57e49f7cd5-€18.00€0.00matched
12capture01a19b21-ade6-77f5-a1d3-ad4dfc8dbbf9€35.00€0.50matched
13capture01a19b21-adec-7814-ab0a-acf5747e30b3€9.00€0.19matched
14capture01a19b21-aec0-7d22-a945-a1aa19e2f082€9.00€0.19matched
15capture01a19b21-d385-70d4-8191-0f44d5b4da96€15.00€0.26matched
16capture01a19b21-d49f-7016-a762-63a78b9f0b5d€35.00€0.50matched
17capture01a19b22-17b7-7735-89e4-d090cfd3f6bf€49.00€0.67matched
18capture01a19b22-23fe-7d69-99c1-166693c39206€9.00€0.19matched
19capture01a19b22-2ed4-74b9-96f0-5892a00751db€9.00€0.19matched
20capture01a19b22-5485-75de-8e9c-64ca4082fcac€49.00€0.67matched
21capture01a19b22-6a92-737e-92be-377e669b8ff9€35.00€0.50matched
22capture01a19b22-7ae3-7742-a3c7-1411a8926028€49.00€0.67matched
23capture01a19b22-84c4-7591-921a-fac836f1ea05€24.00€0.37matched
24capture01a19b22-a300-7fa4-9589-b889f6aaa0cf€49.00€0.67matched
25capture01a19b22-a428-73ec-ad33-1b4cc0b3b4fb€15.00€0.26matched
26capture01a19b22-a553-73de-8fe1-ee7de0035b56€9.00€0.19matched
27capture01a19b22-b71b-73c9-bdc6-35cc6920500e€15.00€0.26matched
28capture01a19b22-c07f-7d53-a378-676f2d105eab€24.00€0.37matched
29capture01a19b22-d437-7838-a3da-d81e5d36c7e1€49.00€0.67matched
30capture01a19b22-f26b-702e-93a5-eb14855022ce€35.00€0.50matched
31capture01a19b22-f83b-7370-bd52-9be11c29abe3€35.00€0.50matched
32capture01a19b23-12e4-72bd-bc00-ca407931464a€49.00€0.67matched
33capture01a19b23-231b-794a-9688-8d3146f99436€24.00€0.37matched
34refund01a19b23-2a8c-72e5-a08c-99d6b460602f-€31.00€0.00matched
35capture01a19b23-4573-7fb9-b882-c5e89996c1bc€15.00€0.26matched
36capture01a19b23-497d-7154-b231-6f4a3e2fb026€9.00€0.19matched
37capture01a19b23-5bb2-79a2-9b49-013178aa48e7€9.00€0.19matched
38capture01a19b23-6643-7191-9c3d-6d8988e0ace2€9.00€0.19matched
39capture01a19b23-70a8-7c4a-9a9f-5a18514edda7€24.00€0.37matched
40capture01a19b23-75a2-7bd7-9e63-496364446266€9.00€0.19matched
41refund01a19b23-86ed-7590-a8f1-7604ec952c27-€13.00€0.00matched
42capture01a19b23-881b-7085-b41c-b24d2c0fdba5€49.00€0.67matched
43capture01a19b23-926d-7a52-9a4b-0246b993075f€35.00€0.50matched
44capture01a19b23-c4d6-73e6-96d9-3f64e174e206€9.00€0.19matched
45capture01a19b23-d839-7452-bdf9-afc8585c53ef€49.00€0.67matched
46capture01a19b23-de37-7d20-a0ab-73188d789a20€9.00€0.19matched
47capture01a19b23-eab5-745c-898b-9285a1e7e4e9€24.00€0.37matched
48capture01a19b23-ef59-7203-92e2-aac062f251f3€24.00€0.37matched
49capture01a19b24-0808-7fda-bcc4-13224ac198f1€49.00€0.67matched
50capture01a19b24-28b6-79e4-a1eb-783e0c73562b€15.00€0.26matched
51capture01a19b24-3491-752c-ba40-de66b99e5ae2€15.00€0.26matched
52capture01a19b24-51d4-7b2b-b2ea-2f21722b6028€15.00€0.26matched
53capture01a19b24-5968-7a4b-a506-f54c588e5f52€49.00€0.67matched
54refund01a19b24-62ce-72a5-ae3c-7d14dcb70ee7-€24.00€0.00matched
55capture01a19b24-67d1-7e0f-bb85-70f0c2deb117€9.00€0.19matched
56capture01a19b24-7304-7d93-ad8a-25ac62ccfece€49.00€0.67matched
58capture01a19b24-7aec-701b-a910-b5b7ffff0d20€24.00€0.37matched
59capture01a19b24-8189-7c30-94ba-555e23380a02€9.00€0.19matched
60refund01a19b24-9590-7813-ae7d-892aab53d2df-€13.00€0.00matched
61capture01a19b24-b243-7875-8bb8-bb613f6bb4d2€49.00€0.67matched
62capture01a19b24-dd3a-7876-b49f-e29cc9bc4448€24.00€0.37matched
63capture01a19b25-2265-7964-9177-c711d16aba58€49.00€0.67matched
64capture01a19b25-2e88-7c49-86a6-17c0ab3e9d0a€49.00€0.67matched
65capture01a19b25-3375-7265-8707-dff082531b52€9.00€0.19matched
66capture01a19b25-3d02-7e5a-81f3-f7b96aff6803€49.00€0.67matched
67capture01a19b25-3f8c-754f-a251-106d97634720€35.00€0.50matched
68capture01a19b25-4567-767f-a6a5-8b3a2c0341cc€35.00€0.50matched
69capture01a19b25-542c-786d-83bf-bf473c93235a€15.00€0.26matched
70capture01a19b25-5945-7aad-943a-0e9829a0e2ef€49.00€0.67matched
71capture01a19b25-7f13-7482-a582-7ec2444bebe2€24.00€0.37matched
72capture01a19b25-826e-7456-a4d2-166472111331€49.00€0.67matched
73refund01a19b25-8356-7283-b83f-d0c871c45d90-€4.00€0.00matched
74refund01a19b25-9a3b-78c0-8697-14aca547f298-€17.00€0.00matched
75capture01a19b25-9d29-72de-941e-ec876297a131€49.00€0.67matched
76capture01a19b25-d081-7b7a-8c99-dfb1290d12cb€49.00€0.67matched
77refund01a19b25-dcfc-72ef-9fb9-c1fac38dfb57-€27.00€0.00matched
78capture01a19b25-e525-7ca4-b7a1-ca9e942382e8€49.00€0.67matched
79capture01a19b25-e9b6-7859-875e-8adc84c6a462€9.00€0.19matched
80capture01a19b26-0ef8-7922-a959-155bb6d02004€9.00€0.19matched
81capture01a19b26-1b27-731a-a7cf-b89a5bd3ea28€35.00€0.50matched
82capture01a19b26-4057-7933-a4d6-739680517d33€9.00€0.19matched
83capture01a19b26-5d8f-7149-9b78-20538915c721€49.00€0.67matched
84capture01a19b26-666c-73f9-9b00-d4ea4da25527€49.00€0.67matched
85capture01a19b26-6a0c-7201-9583-c4c3fec50764€24.00€0.37matched
86capture01a19b26-88cd-71e4-b8ca-60898ffe0b09€35.00€0.50matched
87capture01a19b26-8f3c-7da6-b10b-3896e4207512€35.00€0.50matched
88capture01a19b26-99f3-768b-8aea-d1b7a3a627d7€15.00€0.26matched
90capture01a19b26-acbf-76c6-806b-305c8b2bc3b5€49.00€0.67matched
91capture01a19b26-c40d-718d-81d4-a5baa6d77884€15.00€0.26matched
92refund01a19b26-c5f8-72a7-916d-3188d6da3a6e-€14.00€0.00matched
93capture01a19b26-d1e6-7fb3-9331-96de0c894e75€35.00€0.50matched
94capture01a19b26-d47f-72a9-b91e-c461405c58b0€35.00€0.50matched
95capture01a19b26-e615-78db-b817-a0d4571cd96c€49.00€0.67matched
96capture01a19b26-ef56-7f43-84e4-bc4b262a9a79€35.00€0.50matched
98capture01a19b27-2c5f-7da7-bc51-1b11dcfb3d8f€9.00€0.19matched
99capture01a19b27-3315-78d4-be2a-566011b21f71€24.00€0.37matched
100capture01a19b27-5083-74a5-9814-5b2d68b40dc1€9.00€0.19matched
101capture01a19b27-5aa4-7a7c-bf5f-6bd70c9cdce6€15.00€0.26matched
102capture01a19b27-92c9-7ce9-8adf-74485d204c7b€24.00€0.37matched
103capture01a19b27-d58e-79a1-9708-00f32d05456a€35.00€0.50matched
104capture01a19b28-04d3-7238-90cc-d7e90f038893€35.00€0.50matched
105capture01a19b28-3165-77b9-aa90-ab08fb7187f3€49.00€0.67matched
106capture01a19b28-560d-7edc-8ee1-5f8b88b2607a€15.00€0.26matched
107capture01a19b28-75f1-7849-887d-2135d2208d82€35.00€0.50matched
108capture01a19b28-7843-7058-823c-612734c76afd€9.00€0.19matched
109capture01a19b28-892b-7749-87a5-391e0fc65d44€49.00€0.67matched
110capture01a19b28-92f0-78a4-aa60-3a509a6e5366€24.00€0.37matched
111capture01a19b28-a9c1-7552-b76a-78950e78e028€49.00€0.67matched
112capture01a19b28-c2cc-7678-b3af-27ba5543830d€9.00€0.19matched
113capture01a19b28-d3c7-7e89-8787-47b4067d3ddf€24.00€0.37matched
114capture01a19b28-e846-7058-8874-44bb5287250b€24.00€0.37matched
115capture01a19b28-eb23-7ab4-bce6-f1ab6c69184c€15.00€0.26matched
116refund01a19b29-0e75-7029-bc32-306ca61f8a83-€27.00€0.00matched
117capture01a19b29-51bf-70a6-9cdb-f9c55eec8a04€35.00€0.50matched
118capture01a19b29-614f-7ef2-8bce-e832a6099d0e€9.00€0.19matched
119capture01a19b29-63f8-7336-8c9b-6a99508f816c€49.00€0.67matched
120capture01a19b29-675b-7ee9-b525-ebbcf9f0cf00€9.00€0.19matched
121capture01a19b29-79da-708a-b734-907ec4ad0faf€49.00€0.67matched
122capture01a19b29-8065-7a11-a2b2-488483b84e29€15.00€0.26matched
123capture01a19b29-893f-70d2-8355-69fd7d0801d4€24.00€0.37matched
124capture01a19b29-99e1-73ad-8ef4-988d41ba0c99€49.00€0.67matched
125capture01a19b29-9d5f-7fe4-b6dd-723b661edfb9€9.00€0.19matched
126capture01a19b29-aa78-773f-b335-40e5959207c2€35.00€0.50matched
127capture01a19b29-b800-714a-a51a-a200afbfb8b4€49.00€0.67matched
128capture01a19b29-c3e6-7911-bed4-bc9c8f6f4ba3€15.00€0.26matched
129capture01a19b2a-0475-73f0-9d72-4512714825cd€15.00€0.26matched
130capture01a19b2a-0bba-7d19-a3ff-8342ee17e38b€24.00€0.37matched
131capture01a19b2a-1be2-7f7d-a840-fecddef6641a€35.00€0.50matched
132capture01a19b2a-3e48-7829-b105-59764367829c€49.00€0.67matched