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

Gross

€2,977.00

PSP fee

€49.02

Net to the bank

€2,927.98

Settlement journal

#402884

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a1ad27-c49e-7b2c-92d8-a202580c61b8 is already settled by stl_EUR_2989844 line 9
  • duplicate linethe file lists it twicecapture:01a1ad2e-be0a-7430-bca9-fae4ffb77740 is already settled by stl_EUR_2989844 line 112
LineKindReferenceGrossFeeStatus
10refund01a1ad27-c4a2-7500-bba6-052328db489e-€8.00€0.00duplicate line
113capture01a1ad2e-bf43-7713-971d-45b71a336ffb€15.00€0.26duplicate line
1capture01a1ad1e-4671-77cf-8436-52c5fad87f68€24.00€0.37matched
2capture01a1ad22-fb79-7f1d-bffb-a2ce9580fd82€35.00€0.50matched
3refund01a1ad27-5cac-7734-9d0a-ca06698318bf-€22.00€0.00matched
4capture01a1ad27-6181-72e1-aa93-80b2d444292f€9.00€0.19matched
5refund01a1ad27-70f2-7feb-bcc7-ee5cef3645bc-€6.00€0.00matched
6capture01a1ad27-98ae-7e5c-be5d-082230e61642€24.00€0.37matched
7capture01a1ad27-9ba7-72b0-a7c6-cdaace768c1d€24.00€0.37matched
8capture01a1ad27-c1ff-7e1f-a738-166d95319fcc€24.00€0.37matched
9refund01a1ad27-c4a2-7500-bba6-052328db489e-€8.00€0.00matched
11capture01a1ad27-cb56-716c-b3a5-c606b56b1385€15.00€0.26matched
12capture01a1ad27-d3c4-7b5e-ad65-0416fe02631c€24.00€0.37matched
13capture01a1ad27-dffe-7620-823c-decaa05d38ce€24.00€0.37matched
14capture01a1ad27-f96b-7a58-9374-18424d2cec07€24.00€0.37matched
15capture01a1ad28-13ee-7610-90df-251a4a9d37f5€15.00€0.26matched
16capture01a1ad28-23bf-75e8-95d7-da621f34648e€24.00€0.37matched
17capture01a1ad28-33d3-7ded-9388-93432fc8ab98€9.00€0.19matched
18refund01a1ad28-35c9-77f6-a0f6-99404c6012de-€17.00€0.00matched
19capture01a1ad28-3aa6-746c-ad13-bba0e1367003€24.00€0.37matched
20refund01a1ad28-52ad-7224-98a9-13a8b5288970-€18.00€0.00matched
21capture01a1ad28-5e2d-7cb2-82d5-fbbcfd2adac1€15.00€0.26matched
22capture01a1ad28-6cad-71cd-a872-e213a2d49fbe€24.00€0.37matched
23capture01a1ad28-caa1-7c61-b925-cc6e6d429bed€35.00€0.50matched
24capture01a1ad28-d324-74bb-bdf7-995b915f65ec€9.00€0.19matched
25refund01a1ad28-d352-7df5-aee2-c7917208f3ab-€14.00€0.00matched
26capture01a1ad28-d8d0-7389-85b7-b310aa8b86ad€24.00€0.37matched
27capture01a1ad28-e2dd-7510-b4a2-b190ae90ab43€35.00€0.50matched
28capture01a1ad28-f474-78a8-b943-01e76b7d0e7c€49.00€0.67matched
29capture01a1ad28-fffd-7177-a9f4-49bc9fad004f€15.00€0.26matched
30capture01a1ad29-01df-7363-9e02-19cd2aa77d7f€15.00€0.26matched
31capture01a1ad29-082a-7d8e-85a7-6220c2720b5f€35.00€0.50matched
32refund01a1ad29-322d-78ae-9e11-e11fbe0b979e-€6.00€0.00matched
33capture01a1ad29-4164-72d1-8a0a-2d8dd62b8930€35.00€0.50matched
34capture01a1ad29-47ad-7709-9729-58a3b2dd9301€15.00€0.26matched
35capture01a1ad29-505d-708f-b27a-5ac5e7baf142€9.00€0.19matched
36capture01a1ad29-7e79-7bf7-859e-a837aba4134e€9.00€0.19matched
37capture01a1ad29-8c70-7f91-9f72-33fe08ad626c€49.00€0.67matched
38capture01a1ad29-9d88-718a-8394-12ac120f0e04€15.00€0.26matched
39capture01a1ad29-9f3b-7203-b5e9-e30643c2f336€35.00€0.50matched
40refund01a1ad29-a306-7ee3-8b4c-4d2dc4cd4316-€8.00€0.00matched
41capture01a1ad29-aa59-7d92-8b01-9160e196502f€15.00€0.26matched
42capture01a1ad29-ed4e-7758-b974-b0335bae062e€49.00€0.67matched
43capture01a1ad2a-032e-7783-b71d-f302c859bb93€15.00€0.26matched
44capture01a1ad2a-05b2-79fc-a7c4-ba9053771226€24.00€0.37matched
45capture01a1ad2a-059c-7543-96e3-05c9908e0e02€15.00€0.26matched
46capture01a1ad2a-071f-73db-b162-13048b4174ed€35.00€0.50matched
47capture01a1ad2a-33ae-7425-93ce-3c8c83c9e021€15.00€0.26matched
48capture01a1ad2a-3631-7984-a707-bcfd0ebf2a83€49.00€0.67matched
49refund01a1ad2a-3abf-700f-9a01-1a47d360ceb9-€25.00€0.00matched
50refund01a1ad2a-5211-7168-9ac3-8872aec3f413-€3.00€0.00matched
51capture01a1ad2a-6e71-7f06-b2b1-647a744e8744€9.00€0.19matched
52capture01a1ad2a-8404-75fd-afac-c24d57a7caa7€49.00€0.67matched
53capture01a1ad2a-85e4-7887-9480-335fa119a6eb€24.00€0.37matched
54capture01a1ad2a-9872-73f4-9526-851495e78d52€49.00€0.67matched
55capture01a1ad2a-a2f2-7e5e-b00b-51f96bcfc35f€35.00€0.50matched
56capture01a1ad2a-aa11-7e99-b5a9-4c60d2555d93€9.00€0.19matched
57capture01a1ad2a-b553-739c-997c-4fc41036d008€15.00€0.26matched
58capture01a1ad2a-bcbc-7294-801b-9f42fd75654f€35.00€0.50matched
59capture01a1ad2a-d6a5-75d4-963e-89b9a237fbba€24.00€0.37matched
60capture01a1ad2a-e68b-758c-98a0-aaf736f4d236€9.00€0.19matched
61capture01a1ad2a-ef98-778c-8faa-e5cf7fcf24d0€35.00€0.50matched
62capture01a1ad2b-199d-7007-bb8c-7f488523453e€15.00€0.26matched
63capture01a1ad2b-2a6f-7d49-92c6-81181ce38434€24.00€0.37matched
64capture01a1ad2b-3441-71db-9a75-e37f3de2f55a€35.00€0.50matched
65capture01a1ad2b-48f9-73e4-ad32-a65bdb4f83ec€49.00€0.67matched
66capture01a1ad2b-6554-7515-9a88-a77bc5d54f5b€49.00€0.67matched
67capture01a1ad2b-6d96-718d-9905-42e94c0ceaa6€9.00€0.19matched
68capture01a1ad2b-6e39-77cc-bfca-791f6a9f393c€24.00€0.37matched
69capture01a1ad2b-9077-77f9-9206-0bcc60dfa2bf€49.00€0.67matched
70capture01a1ad2b-95dd-729e-b906-31f87be02fc5€9.00€0.19matched
71refund01a1ad2b-a167-714f-b7d1-4a15f8bbd52b-€30.00€0.00matched
72capture01a1ad2b-a45c-72dc-a284-c80e7fa4f9bc€49.00€0.67matched
73capture01a1ad2b-a59e-7784-8d1f-39e919e0674d€24.00€0.37matched
74capture01a1ad2b-a98f-7489-9fac-f62725a008bc€15.00€0.26matched
75capture01a1ad2b-c0f0-78fa-907b-63eb05d67928€15.00€0.26matched
76capture01a1ad2b-cb86-7216-8c39-2317987ef7fe€9.00€0.19matched
77capture01a1ad2b-cc40-78fe-860c-8681a7165251€9.00€0.19matched
78capture01a1ad2b-ff2b-7066-9e28-160cd77fab6e€24.00€0.37matched
79capture01a1ad2c-02e1-7dd7-8c74-dd4dd933f51b€24.00€0.37matched
80capture01a1ad2c-0629-7f37-bf21-88d723413522€9.00€0.19matched
81capture01a1ad2c-0714-7302-ba56-c486e51c8fd2€15.00€0.26matched
82capture01a1ad2c-3bc8-71bc-8c40-3cb1639ea03b€9.00€0.19matched
83capture01a1ad2c-43ac-71c4-a49d-54dc316fac31€35.00€0.50matched
84refund01a1ad2c-5434-750b-8cc9-65a726e5166d-€20.00€0.00matched
85capture01a1ad2c-8c6e-7847-b7b7-1851f473622e€49.00€0.67matched
86capture01a1ad2c-8d6d-7ec4-9ca2-68d8b40a238a€49.00€0.67matched
87refund01a1ad2c-934a-7b99-8916-fd919d8c7d54-€5.00€0.00matched
88capture01a1ad2c-b63f-73ba-ada1-3e0602d45b36€9.00€0.19matched
89refund01a1ad2c-b6cd-7418-b4ad-5a2f2be7fbc3-€39.00€0.00matched
90capture01a1ad2c-c1fa-7753-820a-f24512157f4d€24.00€0.37matched
91capture01a1ad2c-c322-733c-9026-704fb6c0d0ae€15.00€0.26matched
92capture01a1ad2c-d24a-7d85-a7f0-3a42edd506e0€9.00€0.19matched
93capture01a1ad2c-f90d-7648-8c54-3e1312ea6906€15.00€0.26matched
94capture01a1ad2c-faf2-79ac-8291-3dcbdec1c24c€35.00€0.50matched
95capture01a1ad2d-1d32-74a8-bc89-8e103f7eb573€35.00€0.50matched
96capture01a1ad2d-332f-796c-80e2-445dc2e045de€24.00€0.37matched
97capture01a1ad2d-72e4-7775-99d2-123456f77b97€15.00€0.26matched
98capture01a1ad2d-7dca-753e-b01b-6fd094c1e958€35.00€0.50matched
99capture01a1ad2d-88cb-784e-bb1d-aa073da0994f€9.00€0.19matched
100capture01a1ad2d-9218-7bc5-a859-055abb286e89€24.00€0.37matched
101capture01a1ad2d-d3c6-7339-9f85-193b2f53d2ba€24.00€0.37matched
102capture01a1ad2d-db5f-7188-bdb9-8b881366652d€15.00€0.26matched
103capture01a1ad2d-de7b-719a-b2e5-2a9d3e18e3e1€35.00€0.50matched
104capture01a1ad2d-db39-723b-bd09-de29639df02a€24.00€0.37matched
105capture01a1ad2e-12af-7256-9b49-b8e08b121b59€15.00€0.26matched
106refund01a1ad2e-4e8c-7272-9dd4-35af8cb51583-€6.00€0.00matched
107capture01a1ad2e-52f1-7d23-a1f5-cd13fdf22658€24.00€0.37matched
108capture01a1ad2e-5403-7866-b081-b58ef01af5c4€15.00€0.26matched
109capture01a1ad2e-5699-7857-99eb-425d0b195c55€35.00€0.50matched
110capture01a1ad2e-59cd-7fe8-90e3-3a679a3256c4€35.00€0.50matched
111capture01a1ad2e-be9a-715a-a4c1-a4f794fe73f5€9.00€0.19matched
112capture01a1ad2e-bf43-7713-971d-45b71a336ffb€15.00€0.26matched
114capture01a1ad2e-eebb-73a9-b005-5fe2fcaa7b91€35.00€0.50matched
115capture01a1ad2e-fca8-7eb6-9665-d93c01eeedbb€49.00€0.67matched
116capture01a1ad2f-0750-75bd-a4b0-f12eac76c601€15.00€0.26matched
117capture01a1ad2f-0d88-7e4f-8b96-f8c0fc795c7b€49.00€0.67matched
118capture01a1ad2f-1be1-742d-bc25-aaeaa4c4d2aa€9.00€0.19matched
119capture01a1ad2f-1f25-7bad-beae-55bf02341a08€9.00€0.19matched
120capture01a1ad2f-302e-7aa6-b665-38b4c460c8df€35.00€0.50matched
121capture01a1ad2f-3885-7431-9da8-a611343c50a1€49.00€0.67matched
122capture01a1ad2f-3989-755f-8a59-22bd4ae21388€24.00€0.37matched
123capture01a1ad2f-39d8-73a4-82ee-34727d08457b€24.00€0.37matched
124capture01a1ad2f-3be2-7b8b-a5fe-50cec6716ffc€24.00€0.37matched
125capture01a1ad2f-5935-74dc-a3a7-6a199188b4af€24.00€0.37matched
126capture01a1ad2f-5c9b-7a73-95df-d4122db19cd8€15.00€0.26matched
127capture01a1ad2f-6047-777e-a03d-322810c5a7b4€9.00€0.19matched
128capture01a1ad2f-6368-7f5f-a682-bf818fa81c67€49.00€0.67matched
129refund01a1ad2f-6bf9-7a27-b30d-0a2ba4f9fc91-€27.00€0.00matched
130capture01a1ad2f-8bce-79a3-9548-bd3a4d70b2ab€15.00€0.26matched
131capture01a1ad2f-a2ea-7168-b4d0-8600f34118d8€49.00€0.67matched
132capture01a1ad2f-cc0d-7f40-9265-e3f3a34dbdfb€49.00€0.67matched
133capture01a1ad2f-d2d5-71bd-9db4-3ad3bf677b9c€49.00€0.67matched
134capture01a1ad2f-e4da-7d68-af2d-b30246285f7e€49.00€0.67matched
135capture01a1ad30-2009-725a-864a-00239b739361€35.00€0.50matched
136capture01a1ad30-2b86-7646-aca8-328a41be5569€49.00€0.67matched
137capture01a1ad30-4af1-7ddf-9ffe-8df76c33fb29€24.00€0.37matched
138capture01a1ad30-52a0-7067-9273-fea30a73e96f€24.00€0.37matched
139capture01a1ad30-652d-7485-8a31-82aa30b173f4€49.00€0.67matched
140capture01a1ad30-671f-77eb-9d8f-ae03ddc4bad5€49.00€0.67matched
141capture01a1ad30-7291-713b-b548-2a6e828fb21c€15.00€0.26matched
142capture01a1ad30-80ed-7864-96f9-a718aac80cf0€24.00€0.37matched