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

6 Nov, 13:10

Gross

€3,143.00

PSP fee

€52.16

Net to the bank

€3,090.84

Settlement journal

#416593

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b0fc-3614-799e-92e9-131ba95bed54 is already settled by stl_EUR_2989951 line 16
  • duplicate linethe file lists it twicerefund:01a1b0fd-aab1-7eb3-9bc2-1f76a39cabef is already settled by stl_EUR_2989951 line 39
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
LineKindReferenceGrossFeeStatus
17capture01a1b0fc-363a-75c4-b9be-1f03fdc5ec37€9.00€0.19duplicate line
40refund01a1b0fd-aab3-714b-9a39-a81c47a5ff30-€41.00€0.00duplicate line
110capture01a1b101-f25b-757c-ba93-8fa09553f184€9.00€0.21fee difference
1capture01a1b0f4-5db5-707a-8558-5f337dd42534€15.00€0.26matched
2capture01a1b0f5-e44d-7cd2-901b-c8adefa8290f€49.00€0.67matched
3capture01a1b0f5-ed80-72d7-94d4-8e4b6c5ad6bf€49.00€0.67matched
4capture01a1b0f6-1816-7054-81a3-9ffa8e4e5ded€15.00€0.26matched
5capture01a1b0fa-feec-75e5-a400-dec937a927e7€9.00€0.19matched
6capture01a1b0fb-062b-7c58-a000-bd3c2c70cd09€24.00€0.37matched
7capture01a1b0fb-0ae1-766d-aa7e-fad35210f1ce€49.00€0.67matched
8capture01a1b0fb-2ba6-77f3-873f-7b53d9b0f364€35.00€0.50matched
9capture01a1b0fb-4362-78e9-884a-4b0254d04a38€15.00€0.26matched
10capture01a1b0fb-492a-7dd6-81ea-3462c91009f0€35.00€0.50matched
11capture01a1b0fb-67d7-776e-b963-c1e45673fc40€35.00€0.50matched
12capture01a1b0fb-7598-785f-b618-40f256b53d5a€9.00€0.19matched
13capture01a1b0fb-81ac-7ff3-aae8-707b5ec4e6da€24.00€0.37matched
14refund01a1b0fb-b69f-7a00-9e91-e68d44083f5c-€4.00€0.00matched
15capture01a1b0fc-05f0-70f1-b7bb-1af8cffcb55e€24.00€0.37matched
16capture01a1b0fc-363a-75c4-b9be-1f03fdc5ec37€9.00€0.19matched
18capture01a1b0fc-4867-7b3a-8b65-345b0cba5e56€49.00€0.67matched
19refund01a1b0fc-7e72-73ba-b7ff-f9d501291ec9-€33.00€0.00matched
20capture01a1b0fc-8ccc-7d3a-af87-ca6e9837510d€35.00€0.50matched
21capture01a1b0fc-9900-7133-8877-480f27d090a5€49.00€0.67matched
22capture01a1b0fc-9be3-750d-8a62-b76d6d4d08d4€24.00€0.37matched
23capture01a1b0fc-9f85-734a-a889-6a1ef0a86426€35.00€0.50matched
24capture01a1b0fc-a1b3-7a5a-9a52-6c1af28807bb€15.00€0.26matched
25capture01a1b0fc-c30c-737f-8a91-806c066ffb3d€24.00€0.37matched
26capture01a1b0fc-d926-7dbf-b4fb-edaa36cecdd1€49.00€0.67matched
27capture01a1b0fc-da38-7ff4-a808-0d8726665702€24.00€0.37matched
28capture01a1b0fc-db74-7575-95c6-6c1fbcc63cae€9.00€0.19matched
29capture01a1b0fc-e8cf-72c4-bdaf-85f9e1d38368€35.00€0.50matched
30capture01a1b0fd-05e4-792e-a71e-c5be266d9e00€15.00€0.26matched
31capture01a1b0fd-122d-72d6-a3ad-9c6a689491f4€9.00€0.19matched
32refund01a1b0fd-2696-7de0-b947-70890eecde83-€24.00€0.00matched
33refund01a1b0fd-3393-7ba4-bb90-b19215f29aa5-€9.00€0.00matched
34capture01a1b0fd-5141-7688-abe9-77edcbbb2fa6€15.00€0.26matched
35capture01a1b0fd-64b6-7773-bc7b-f5af8cfd5745€15.00€0.26matched
36capture01a1b0fd-737f-7866-97ba-419269b876cd€49.00€0.67matched
37capture01a1b0fd-9f81-7cee-be87-b50bf84c96cc€35.00€0.50matched
38capture01a1b0fd-a54b-74ee-ae06-b2b53ff1db44€15.00€0.26matched
39refund01a1b0fd-aab3-714b-9a39-a81c47a5ff30-€41.00€0.00matched
41capture01a1b0fd-e175-77b3-a9f7-e3e89ee3330c€9.00€0.19matched
42capture01a1b0fd-fc97-71c9-a542-25e402e0f90b€15.00€0.26matched
43capture01a1b0fe-1731-7e9a-9d09-ac33a851c2fc€24.00€0.37matched
44capture01a1b0fe-3477-79aa-9a02-c67147e00138€15.00€0.26matched
45capture01a1b0fe-3e09-7fc0-8324-1c554d9c56e5€15.00€0.26matched
46capture01a1b0fe-4416-7142-b794-f38444d347df€49.00€0.67matched
47capture01a1b0fe-4674-739c-84e4-9491d1ab69cb€24.00€0.37matched
48capture01a1b0fe-6705-7380-89b1-82092a79bd08€15.00€0.26matched
49capture01a1b0fe-69e2-7582-a9f5-ffecaff0500b€24.00€0.37matched
50capture01a1b0fe-6e94-78e9-9944-7430645f085a€9.00€0.19matched
51capture01a1b0fe-86d0-7e0b-a4d9-1e162632a907€9.00€0.19matched
52capture01a1b0fe-8988-7679-a9e4-f9fbb37d9229€24.00€0.37matched
53refund01a1b0fe-8cc4-767d-88d0-c9af8f3302bc-€42.00€0.00matched
54capture01a1b0fe-9b19-79d8-89d8-3cdfcbb6df4f€15.00€0.26matched
55capture01a1b0fe-add2-7658-8ec2-65b4e1f7eafc€35.00€0.50matched
56capture01a1b0fe-af9e-74e4-8a9a-5be42b6ef93b€49.00€0.67matched
57capture01a1b0fe-cf22-77aa-a469-c33b167ccaef€15.00€0.26matched
58capture01a1b0fe-d0ed-76fc-951e-b70aa790684f€35.00€0.50matched
59capture01a1b0fe-d66a-7fda-966b-24c4ce8cdca1€49.00€0.67matched
60capture01a1b0fe-f014-7c23-857c-0680b1655ede€15.00€0.26matched
61capture01a1b0ff-1277-7899-a086-f4ad625d81fe€49.00€0.67matched
62capture01a1b0ff-141b-7cde-8242-9f78580044f8€24.00€0.37matched
63capture01a1b0ff-1a80-7353-b6b3-405cef477571€15.00€0.26matched
64refund01a1b0ff-2e83-7d2f-bb67-3c5f97c720f3-€11.00€0.00matched
65capture01a1b0ff-2767-770d-89f9-570ebc1eb694€24.00€0.37matched
66capture01a1b0ff-36ab-7ffd-a452-bbf954dcde9c€49.00€0.67matched
67capture01a1b0ff-41df-70ab-a869-1796e17f4175€15.00€0.26matched
68capture01a1b0ff-486b-778a-8d6e-df407ae93496€9.00€0.19matched
69capture01a1b0ff-7905-77ef-9fc6-6dfe89feede1€49.00€0.67matched
70capture01a1b0ff-7b3e-7496-ba3e-3ede2160fb6b€24.00€0.37matched
71refund01a1b0ff-8185-7232-bd93-4200dcd4be16-€14.00€0.00matched
72refund01a1b0ff-8505-7653-84ee-9758f6dbdda2-€39.00€0.00matched
73capture01a1b0ff-9497-716b-aa7c-f3eff52b599d€15.00€0.26matched
74capture01a1b0ff-bd81-7150-9c8e-6a0a7435671b€15.00€0.26matched
75capture01a1b0ff-bf2d-7cbc-bc42-bc3036fc0722€24.00€0.37matched
76capture01a1b0ff-c214-7f43-9dd1-c47390318f53€35.00€0.50matched
77capture01a1b0ff-f0f8-7f4b-b355-58db2954a1be€49.00€0.67matched
78refund01a1b100-0246-78c8-ba2d-faa549757b59-€17.00€0.00matched
79capture01a1b100-1fa1-75b2-9ac3-7194ea501e5c€49.00€0.67matched
80capture01a1b100-21cf-7e67-b1e4-c38160983425€9.00€0.19matched
81capture01a1b100-243e-7fc7-8ca4-8947ec817e72€35.00€0.50matched
82capture01a1b100-41c7-7db9-900d-0564999047ff€49.00€0.67matched
83capture01a1b100-4856-7fab-80b8-016e22636679€9.00€0.19matched
84capture01a1b100-4d86-7f93-8567-bb68100fdd41€35.00€0.50matched
85capture01a1b100-534d-77cc-aafa-aa1329db5c99€24.00€0.37matched
86capture01a1b100-55ac-755b-b07f-6859c7e4f38c€15.00€0.26matched
87refund01a1b100-66ba-734c-966e-1d15a6342c2a-€9.00€0.00matched
88capture01a1b100-6a91-7d53-98a6-a22d0270d68e€35.00€0.50matched
89capture01a1b100-80b1-7913-a6d6-4eb9a3ae88a7€24.00€0.37matched
90refund01a1b100-825b-7c24-827f-91f3f2a85ea9-€6.00€0.00matched
91capture01a1b100-8c2a-793e-9d87-918d635ddd99€15.00€0.26matched
92capture01a1b100-9b23-731f-b37e-e1fe0b47fb0b€49.00€0.67matched
93capture01a1b100-a1d5-7590-b724-c0d0ecaaf58c€15.00€0.26matched
94capture01a1b100-ae4c-760f-967c-7e3791780b7e€15.00€0.26matched
95capture01a1b100-b69b-7835-8bf8-f41fb95b4489€24.00€0.37matched
96capture01a1b101-0a44-75a3-9405-0f92358b9e65€15.00€0.26matched
97capture01a1b101-0dfe-7c56-8c69-ae9e7e1417bc€35.00€0.50matched
98capture01a1b101-13e6-7c62-9162-87b5842c2800€15.00€0.26matched
99capture01a1b101-1aa2-7d2b-bed9-7ee6ef3753dc€9.00€0.19matched
100capture01a1b101-5a07-7855-9b71-e7b7b1e19c7e€9.00€0.19matched
101capture01a1b101-72ca-7da8-ad7f-75c5dbb55c04€35.00€0.50matched
102capture01a1b101-77c4-7ede-90b4-89bb31797af3€9.00€0.19matched
103capture01a1b101-94c8-79b6-9dde-357be6000207€49.00€0.67matched
104capture01a1b101-a7b3-7511-8a70-ba5e2101eac4€24.00€0.37matched
105capture01a1b101-aeef-7ab7-acc7-22696eb122ea€15.00€0.26matched
106capture01a1b101-c46a-771c-bebf-c695e3bacd56€24.00€0.37matched
107capture01a1b101-c60d-7e66-932c-cd7bf39e94bc€35.00€0.50matched
108capture01a1b101-cd68-72a1-a5dd-990a60ffd343€9.00€0.19matched
109capture01a1b101-ea60-7daf-b103-13069d6b50e2€9.00€0.19matched
111capture01a1b101-f5cd-791d-abea-b9df685a83fb€49.00€0.67matched
112capture01a1b102-06d9-735a-8397-7276397e6543€49.00€0.67matched
113capture01a1b102-10e0-781f-a086-eb7f1112854c€9.00€0.19matched
114capture01a1b102-31a1-7390-a3b9-469562e850cb€24.00€0.37matched
115capture01a1b102-4e82-799c-8d20-baed3a1fde01€9.00€0.19matched
116capture01a1b102-592a-762b-b92f-381f82183d8a€49.00€0.67matched
117refund01a1b102-5fd1-7596-81fc-1e8c301f99b4-€24.00€0.00matched
118capture01a1b102-6547-786b-90ee-8321dbe89711€35.00€0.50matched
119capture01a1b102-6dc0-7f25-98d3-220e3b060e2f€24.00€0.37matched
120capture01a1b102-93af-701a-932a-42439f2c8ada€49.00€0.67matched
121capture01a1b102-98d8-77c8-bdaa-031ac88c7de2€9.00€0.19matched
122capture01a1b102-a794-7285-a6b4-6ffc82d40b2f€49.00€0.67matched
123capture01a1b102-b218-703f-aebb-1f18f317787d€15.00€0.26matched
124capture01a1b102-c340-7ca3-a811-55368fc86bde€24.00€0.37matched
125capture01a1b102-c55b-7298-91f4-270f4977822c€9.00€0.19matched
126capture01a1b102-dc8d-7ebe-8abf-a657ce9ad0d6€24.00€0.37matched
127capture01a1b102-dd13-775a-9eb4-cfec42713dea€35.00€0.50matched
128capture01a1b102-ec2a-76b9-a382-9484eba1b979€49.00€0.67matched
129capture01a1b102-ef6b-78f1-b7fe-2afcb5b5ce9e€35.00€0.50matched
130capture01a1b102-f1ac-7b5b-9879-b2433428f595€24.00€0.37matched
131capture01a1b102-f766-7864-a641-24156fb2e14f€35.00€0.50matched
132capture01a1b102-fbc4-71e9-98a8-b35afffd9043€35.00€0.50matched
133capture01a1b102-fcdf-70b2-98af-d4423ff34a4c€49.00€0.67matched
134capture01a1b103-01b4-78d7-9436-6d5d2567ffda€49.00€0.67matched
135capture01a1b103-2c89-7336-8785-a2ada2a699b6€9.00€0.19matched
136refund01a1b103-40a9-7367-b9d5-40124349b650-€15.00€0.00matched
137capture01a1b103-4865-75c4-ac95-bd643e878a4a€35.00€0.50matched
138capture01a1b103-588e-79c9-ad58-5f4d66513f02€49.00€0.67matched
139capture01a1b103-675f-7719-883d-ce62d46adb06€24.00€0.37matched
140capture01a1b103-6d82-76d4-b581-432b74a102fd€35.00€0.50matched
141capture01a1b103-74fd-7cbf-a07c-95205102c62c€49.00€0.67matched
142capture01a1b103-857f-7473-8c5e-1beaf8e696fc€35.00€0.50matched
143capture01a1b103-a7d0-708d-b5cd-64071ef85c8f€24.00€0.37matched
144capture01a1b103-fd09-7e22-b3dd-d8b0a48728aa€24.00€0.37matched