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

7 Nov, 13:00

Gross

€3,191.00

PSP fee

€50.06

Net to the bank

€3,140.94

Settlement journal

#434895

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b61b-986d-710b-a416-2497a2f5d116 is already settled by stl_EUR_2990094 line 57
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
LineKindReferenceGrossFeeStatus
58capture01a1b61b-989c-7a21-a90c-eb3c9878f9ae€24.00€0.37duplicate line
72capture01a1b61c-9df3-7000-8299-fafe4d63fee5€15.00€0.29fee difference
99capture01a1b61e-6a66-7e30-b3d8-9b1f38df575f€35.00€0.54fee difference
1capture01a1b611-7057-7ed0-8b3a-abaebfa17c7e€35.00€0.50matched
2capture01a1b616-d035-7073-ac95-fceda68d185e€49.00€0.67matched
3capture01a1b618-3131-7857-afbb-c2aed2871840€35.00€0.50matched
4capture01a1b618-3cec-7e69-8e10-dc7db31a6333€15.00€0.26matched
5capture01a1b618-45ba-75c1-a75f-73c2c8fa2b09€9.00€0.19matched
6capture01a1b618-4e22-7188-b104-59559641073e€15.00€0.26matched
7capture01a1b618-679f-7880-b495-8472684ecdb2€24.00€0.37matched
8capture01a1b618-962f-77bf-b354-e72e5756f462€15.00€0.26matched
9capture01a1b618-be62-7143-98e6-78207b25717f€49.00€0.67matched
10capture01a1b618-e62f-7452-9974-301b6fe8ea9e€35.00€0.50matched
11capture01a1b618-f491-7244-a8e1-82f4a8d78645€35.00€0.50matched
12capture01a1b618-facb-7071-8f9e-4a35f5814306€49.00€0.67matched
13capture01a1b619-1502-79b0-8bc6-45d355059925€35.00€0.50matched
14capture01a1b619-1990-73a7-8281-5b4fda86357f€24.00€0.37matched
15capture01a1b619-4a3b-7234-8e5a-4da4ab4363bd€15.00€0.26matched
16capture01a1b619-538f-7729-a414-899e5bb46b30€49.00€0.67matched
17capture01a1b619-5e94-7e15-8385-a7e8da4d1df7€24.00€0.37matched
18capture01a1b619-6c23-76b1-a6a3-7e7067e57aa2€24.00€0.37matched
19capture01a1b619-7643-74e7-8cb4-c58bc0295887€24.00€0.37matched
20capture01a1b619-8671-7eb7-bca4-68ddf4fc1327€24.00€0.37matched
21capture01a1b619-a490-77c2-8604-154af6720c7e€49.00€0.67matched
22capture01a1b619-bbdd-7579-af8d-c5813b20bb12€24.00€0.37matched
23capture01a1b619-d571-7a60-b842-184ccce9cb43€15.00€0.26matched
24capture01a1b619-d9ad-74db-af0c-0d64260639d9€35.00€0.50matched
25capture01a1b619-e264-70bf-9c40-a8e6af649194€15.00€0.26matched
26refund01a1b619-e3f5-7983-999f-6558d47060b0-€20.00€0.00matched
27capture01a1b619-e6e8-7b8a-b471-c11c7b2f12bb€9.00€0.19matched
28capture01a1b619-edf5-7f11-8e2f-26608ed662b5€49.00€0.67matched
29capture01a1b619-eb36-796a-bb6e-e3b25d4e7306€35.00€0.50matched
30capture01a1b619-f9b2-70ac-990a-5d36e842c156€9.00€0.19matched
31capture01a1b61a-004a-73ee-a4e2-eb254871fa3e€15.00€0.26matched
32refund01a1b61a-0b31-7ab6-99bb-2b15486eae43-€28.00€0.00matched
33capture01a1b61a-1606-718a-9a4f-b4af9550c0d1€24.00€0.37matched
34capture01a1b61a-22aa-7709-bbf2-4b6a0cd45774€35.00€0.50matched
35capture01a1b61a-2800-7a20-bfc5-f28d173d7b48€49.00€0.67matched
36capture01a1b61a-4185-75aa-935b-3265f7df9e3a€15.00€0.26matched
37capture01a1b61a-4fd8-7cb4-8d36-b46d101a729a€24.00€0.37matched
38capture01a1b61a-5688-7f81-acb5-cece4ef1d366€49.00€0.67matched
39capture01a1b61a-5b39-7db4-b2ce-aa861ba5e2b6€24.00€0.37matched
40capture01a1b61a-63a6-763b-b10c-e3869ac379d8€9.00€0.19matched
41capture01a1b61a-a7d8-7504-a94f-589876df2576€24.00€0.37matched
42refund01a1b61a-bb36-7f67-837b-0d0c69443e90-€6.00€0.00matched
43capture01a1b61b-0188-7950-87fc-b95d45010644€15.00€0.26matched
44capture01a1b61b-01b6-7d4e-8e1f-bd8501ecfe6c€15.00€0.26matched
45capture01a1b61b-0a06-7865-94a4-efc76335d023€15.00€0.26matched
46capture01a1b61b-21e5-7234-9e10-3e9399cd772a€24.00€0.37matched
47capture01a1b61b-354a-7440-9047-def975a5690c€35.00€0.50matched
48capture01a1b61b-4572-757b-8b24-86ac7106423d€35.00€0.50matched
49refund01a1b61b-50a9-7403-bbec-0d0bf204832b-€8.00€0.00matched
50capture01a1b61b-553f-7125-be9b-7c8a4e7b1eeb€49.00€0.67matched
51capture01a1b61b-5c6b-7b8f-b7ed-6d6f8e6d8f1f€9.00€0.19matched
52capture01a1b61b-70ab-77fe-b25f-2fc83e3dcc7a€49.00€0.67matched
53capture01a1b61b-8aaa-7403-9399-c8ec17da666a€35.00€0.50matched
54refund01a1b61b-8fa0-7c30-88f5-393ecff6bb64-€19.00€0.00matched
55capture01a1b61b-90d3-7377-a786-6a708219bcc8€9.00€0.19matched
56capture01a1b61b-9607-71ac-91df-7ee9b295e15c€35.00€0.50matched
57capture01a1b61b-989c-7a21-a90c-eb3c9878f9ae€24.00€0.37matched
59capture01a1b61b-9e3d-732b-834d-695e294aa696€15.00€0.26matched
60capture01a1b61b-b27e-7000-9e39-2d727be66850€35.00€0.50matched
61capture01a1b61b-dbed-7f64-b362-fe69e5ba4c61€9.00€0.19matched
62capture01a1b61b-e372-76d3-a90a-9a5a2f43914d€35.00€0.50matched
63capture01a1b61b-e458-704c-887d-d995c8c40ed5€15.00€0.26matched
64capture01a1b61c-043a-70f0-8a9c-05a8c5b7e462€9.00€0.19matched
65capture01a1b61c-27a3-79c3-9ab6-7d1cf443786c€15.00€0.26matched
66capture01a1b61c-280f-7fa3-9d7c-05f2beaf05f0€24.00€0.37matched
67capture01a1b61c-4f10-7cb5-ab49-f60ee5920d91€49.00€0.67matched
68capture01a1b61c-520e-7a62-8064-258f346815d2€24.00€0.37matched
69capture01a1b61c-6744-71c2-a562-c3b0effff4bf€15.00€0.26matched
70capture01a1b61c-682d-73f1-adf8-4b5b8568853a€49.00€0.67matched
71capture01a1b61c-7bfa-7898-a770-f41eeef08492€24.00€0.37matched
73capture01a1b61c-b649-7014-b594-d4d11ae6c40b€49.00€0.67matched
74capture01a1b61c-cb28-724f-a15c-b516754f8020€24.00€0.37matched
75capture01a1b61c-d09e-7121-bf98-0afdaf7f6299€24.00€0.37matched
76refund01a1b61c-e600-7c6f-a09d-5eeb0911b0fc-€11.00€0.00matched
77capture01a1b61d-010c-7df4-b25b-ba8c3da9aea5€24.00€0.37matched
78capture01a1b61d-1026-700a-a907-ab34508aa18f€9.00€0.19matched
79capture01a1b61d-1b03-7a09-a388-b4efd26a6b33€49.00€0.67matched
80capture01a1b61d-3632-7834-ac6b-cb7169d90c20€15.00€0.26matched
81refund01a1b61d-3724-7d2f-9d61-510aa5f2146a-€6.00€0.00matched
82capture01a1b61d-378a-7a5e-bb07-e6b4419a5867€35.00€0.50matched
83capture01a1b61d-42ba-7873-bada-30459511e9a8€35.00€0.50matched
84capture01a1b61d-590d-7a57-94ba-f0250cb2af8f€35.00€0.50matched
85capture01a1b61d-6806-7ddb-8fb2-68ea906980c5€9.00€0.19matched
86refund01a1b61d-9672-7f8e-a5b6-4faf1c26dcc3-€10.00€0.00matched
87capture01a1b61d-9cfc-7c3e-9d8d-c501dee6ccd4€49.00€0.67matched
88capture01a1b61d-c70b-7605-a510-e564dda99646€24.00€0.37matched
89capture01a1b61d-cb07-72fa-aabb-e38cbd9e2a58€24.00€0.37matched
90capture01a1b61d-e4e6-7ddf-a2c2-7644ea99cbe6€49.00€0.67matched
91capture01a1b61d-e577-79a9-a477-3fddd13b4208€24.00€0.37matched
92capture01a1b61d-f589-7852-8ca9-818879bc5de0€24.00€0.37matched
93capture01a1b61d-f765-7a6b-a95a-439d0a430858€24.00€0.37matched
94capture01a1b61e-0f6f-7179-a3c1-d349a58be213€24.00€0.37matched
95refund01a1b61e-3a47-7f8c-80dc-56be4f8470b0-€19.00€0.00matched
96refund01a1b61e-45c1-717c-a409-965c83025713-€13.00€0.00matched
97capture01a1b61e-6087-741a-8de0-3b9c4ab8b28f€49.00€0.67matched
98capture01a1b61e-65ed-7640-84fb-42ed51327e26€24.00€0.37matched
100capture01a1b61e-8785-7fd7-aab1-5f6ae0eeb54f€9.00€0.19matched
101capture01a1b61e-b4cb-7983-b749-0b286d950c55€24.00€0.37matched
102capture01a1b61e-c84c-7019-a185-02dcc239cb28€15.00€0.26matched
103capture01a1b61e-c917-7407-a435-7b4e9d8d82d7€35.00€0.50matched
104capture01a1b61e-e67c-7c49-bdf7-b9c046005e20€9.00€0.19matched
105capture01a1b61f-0e2c-7367-b55e-83147d1ddb7a€49.00€0.67matched
106capture01a1b61f-26ec-7d1d-9d8d-88be96c41f04€15.00€0.26matched
107capture01a1b61f-2dff-7b68-af62-5015605c4753€35.00€0.50matched
108capture01a1b61f-330f-70fb-82da-6794cb882bad€35.00€0.50matched
109capture01a1b61f-4a7b-7e3f-8a7b-466a2cd993ec€35.00€0.50matched
110capture01a1b61f-564b-73d6-92e1-6892be3addac€9.00€0.19matched
111capture01a1b61f-63f9-7c50-825d-5b2c6e96fa3d€15.00€0.26matched
112capture01a1b61f-98a0-7697-a227-0b9f5902c3ea€49.00€0.67matched
113capture01a1b61f-b43e-7d60-b9ed-1c9c5f6a698e€49.00€0.67matched
114capture01a1b61f-cd76-72ca-83ef-50843319ffb4€15.00€0.26matched
115capture01a1b61f-f28b-7165-83af-39a7e96e6b1b€49.00€0.67matched
116capture01a1b61f-f71c-7df7-abef-89fd914fa766€9.00€0.19matched
117capture01a1b61f-f9fb-7d17-8eeb-4ba5c5304218€15.00€0.26matched
118refund01a1b61f-fbc8-7bde-bb05-deba0dd5e16c-€7.00€0.00matched
119capture01a1b61f-fed2-7fc1-9d01-b61801bdb80e€15.00€0.26matched
120capture01a1b620-0066-7d07-b194-e8fae193d3e2€49.00€0.67matched
121capture01a1b620-14f0-7672-8ce2-a2cde711abf7€15.00€0.26matched
122capture01a1b620-2799-7f16-b3ff-b64865967077€35.00€0.50matched
123capture01a1b620-44f3-74d6-87cb-6a81bbe528ad€35.00€0.50matched
124capture01a1b620-6502-7590-b59e-d6924e662d39€9.00€0.19matched
125capture01a1b620-aa49-74a5-aa09-85d9a5fa7abc€35.00€0.50matched
126capture01a1b620-e614-7452-8644-2991503bee11€35.00€0.50matched
127capture01a1b621-015b-7a75-a8c3-fc2060126f7a€24.00€0.37matched
128capture01a1b621-022c-7369-9eb3-42954767ae12€35.00€0.50matched
129capture01a1b621-039e-7722-a7c6-3b69b29b243d€49.00€0.67matched
130capture01a1b621-0ce5-76e1-82c9-3f91581287c8€35.00€0.50matched
131refund01a1b621-29d7-78fd-a99e-48034c10b52f-€10.00€0.00matched
132capture01a1b621-2dba-7242-be4d-06582fe44b43€15.00€0.26matched
133capture01a1b621-3ef0-7686-b29a-872eecae053d€35.00€0.50matched