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, 01:00

Gross

€3,393.00

PSP fee

€55.31

Net to the bank

€3,337.69

Settlement journal

#407154

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ae62-1009-7535-af45-20a18dfb7245 is already settled by stl_EUR_2989878 line 61
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 2, the contract says 0
LineKindReferenceGrossFeeStatus
35capture01a1ae60-2f9f-7c7d-b074-4328be7b3971€24.00€0.40fee difference
43refund01a1ae60-b09e-7570-b93e-a8da37228b8b-€40.00€0.02fee difference
62capture01a1ae62-1027-7867-80a8-18c962b2b0a1€9.00€0.19duplicate line
1capture01a1ae57-4a72-7b61-ab32-c2fa2cd6299b€24.00€0.37matched
2capture01a1ae58-6c34-7729-aaa6-040f5e3b12cf€9.00€0.19matched
3refund01a1ae58-8080-7cd7-a323-8283c4b48fc3-€34.00€0.00matched
4capture01a1ae5e-c2ca-7f15-99f8-2f096c1f1bde€24.00€0.37matched
5capture01a1ae5e-c6da-7488-a03a-9b7d3f00bf7e€49.00€0.67matched
6capture01a1ae5e-ca77-7341-8da0-18e26ad8fec6€35.00€0.50matched
7capture01a1ae5e-d10d-7280-b671-ea749ae294cc€9.00€0.19matched
8capture01a1ae5e-d169-7469-b11e-b77269b185fa€15.00€0.26matched
9capture01a1ae5e-dc04-7c07-8ab4-1f008ea89586€9.00€0.19matched
10refund01a1ae5e-e1fc-71cb-9907-9ebb17510b6d-€31.00€0.00matched
11capture01a1ae5e-ec97-7941-813e-27a7813d2dec€24.00€0.37matched
12capture01a1ae5e-ee13-71f5-8e5b-58cf15beeddc€49.00€0.67matched
13capture01a1ae5e-f0ef-774e-9cb3-9f981cd61115€24.00€0.37matched
14capture01a1ae5e-f4b9-74f3-aae1-c1cbb3f90415€49.00€0.67matched
15capture01a1ae5f-02ba-7da6-bba2-2c9b951827c0€9.00€0.19matched
16capture01a1ae5f-0c92-795d-ad20-15cf1722f163€9.00€0.19matched
17capture01a1ae5f-2136-7984-a08a-dd6d86f0f1fe€49.00€0.67matched
18capture01a1ae5f-3e3c-7966-890b-23b10fe1c70c€49.00€0.67matched
19refund01a1ae5f-5176-7ba4-92b9-561a14dd59ed-€9.00€0.00matched
20refund01a1ae5f-546d-764a-8ae7-91ed5b80e877-€8.00€0.00matched
21capture01a1ae5f-568e-71db-9289-277d3641dc78€49.00€0.67matched
22capture01a1ae5f-702f-72f4-9825-05c0f3efb73f€15.00€0.26matched
23capture01a1ae5f-78fe-7a4a-9b66-ce3baca372f5€49.00€0.67matched
24capture01a1ae5f-83b2-7125-bf3a-5719b8cb52e5€15.00€0.26matched
25capture01a1ae5f-ae27-79b5-a089-605cb48b30c4€24.00€0.37matched
26refund01a1ae5f-bf12-7d48-adc3-4d88029fda0b-€23.00€0.00matched
27capture01a1ae5f-d1dc-7a54-a345-15113d861ed0€15.00€0.26matched
28capture01a1ae5f-f9f5-7f43-b510-cd5a25be0ba2€9.00€0.19matched
29capture01a1ae5f-ff16-7197-9508-f1465655982e€15.00€0.26matched
30refund01a1ae60-18cb-7668-90d9-e76082d8d300-€11.00€0.00matched
31capture01a1ae60-1bad-7dbb-b2aa-b2c783e0421a€24.00€0.37matched
32capture01a1ae60-2207-7036-815e-584a47cd4f40€24.00€0.37matched
33capture01a1ae60-26bf-7072-b6b9-ca061923b745€15.00€0.26matched
34capture01a1ae60-29f4-7ca6-8998-b09b336b256d€49.00€0.67matched
36capture01a1ae60-30d9-7e4b-95db-a83536e46faa€15.00€0.26matched
37capture01a1ae60-30f6-7115-a689-78f1f487a06f€9.00€0.19matched
38capture01a1ae60-35ed-70d8-a514-7571efb251b5€35.00€0.50matched
39capture01a1ae60-419a-71dd-85bd-367888961465€49.00€0.67matched
40capture01a1ae60-595a-7057-9fc1-c07b839f155b€49.00€0.67matched
41refund01a1ae60-847d-75e2-a527-0bb7c9ce1b86-€4.00€0.00matched
42capture01a1ae60-86a8-7b25-9faf-d58fd105c213€35.00€0.50matched
44capture01a1ae60-c361-78d1-8249-2756d2c155bb€24.00€0.37matched
45capture01a1ae60-c9dd-760a-b4c3-89180b99650a€24.00€0.37matched
46capture01a1ae60-cc34-71fc-9387-45636ee8bf9e€24.00€0.37matched
47capture01a1ae60-ec33-7e3a-ad35-3e080883cf20€15.00€0.26matched
48capture01a1ae60-fa88-7724-8a51-064dba2b23a9€49.00€0.67matched
49capture01a1ae61-1cdb-70a9-b0ca-1089bab5190d€35.00€0.50matched
50capture01a1ae61-51ad-7190-b151-0bacb9c3e860€24.00€0.37matched
51capture01a1ae61-7011-7ba6-8323-23b5af6b1d99€9.00€0.19matched
52capture01a1ae61-7750-7c3b-9bcd-50247c5890aa€49.00€0.67matched
53capture01a1ae61-78d6-71d9-88ba-4814bd87d3c6€24.00€0.37matched
54capture01a1ae61-accd-7fbd-9513-f96d0cae2faa€35.00€0.50matched
55capture01a1ae61-c827-7452-87a4-71fb740797de€35.00€0.50matched
56capture01a1ae61-e11e-7907-9df0-8cc7c564486b€24.00€0.37matched
57refund01a1ae61-e2d0-7a7b-9a1e-a43ea6024b32-€12.00€0.00matched
58capture01a1ae61-fc92-736f-823f-18bbd1e1b2d0€35.00€0.50matched
59capture01a1ae61-ff21-7583-9f13-a70bb2238406€35.00€0.50matched
60capture01a1ae62-0e5e-7fc7-88a8-97c08f14bbe1€15.00€0.26matched
61capture01a1ae62-1027-7867-80a8-18c962b2b0a1€9.00€0.19matched
63capture01a1ae62-17ec-7854-bcfb-35b94c77be49€49.00€0.67matched
64capture01a1ae62-1a54-7340-8230-8742e6e47778€35.00€0.50matched
65refund01a1ae62-61db-774c-a13f-1198cda13b16-€19.00€0.00matched
66refund01a1ae62-6e70-7ef0-9f2b-64773d98749d-€4.00€0.00matched
67capture01a1ae62-731b-7200-9488-84acf8d764e9€49.00€0.67matched
68capture01a1ae62-9587-7758-b7ac-8a98a50f3688€35.00€0.50matched
69refund01a1ae62-9d5e-7dea-a7ca-44ae46769e0e-€16.00€0.00matched
70capture01a1ae62-b8c2-7f60-954c-7bff462c42d1€49.00€0.67matched
71capture01a1ae62-dbbf-78d9-bf0c-8aa86ff092b0€9.00€0.19matched
72capture01a1ae62-f0ce-7d50-bfe8-7e760d74a6e0€24.00€0.37matched
73capture01a1ae62-f91c-745e-acc4-4ed9f1875664€24.00€0.37matched
74capture01a1ae63-0a06-78ba-96f0-6fe27c3dc1ad€15.00€0.26matched
75capture01a1ae63-15e4-7f81-91f8-8d69ba79e434€49.00€0.67matched
76capture01a1ae63-3c41-7676-80d8-f96a946bb63b€9.00€0.19matched
77capture01a1ae63-488a-7d22-80ae-10f6851b5918€9.00€0.19matched
78capture01a1ae63-529c-76a1-9ac6-7269d5714218€35.00€0.50matched
79capture01a1ae63-5af7-7019-9e24-68b2c1639565€9.00€0.19matched
80capture01a1ae63-5d6f-7630-9e2a-c7af9ba02c11€9.00€0.19matched
81capture01a1ae63-6671-79a9-bf1a-47229f275d58€49.00€0.67matched
82capture01a1ae63-72c1-76e4-bd9d-48243f3c6716€49.00€0.67matched
83capture01a1ae63-c529-74e6-831a-d038730b965a€24.00€0.37matched
84capture01a1ae63-da44-7213-a14e-c6aace956032€35.00€0.50matched
85capture01a1ae63-d76f-7a6a-a133-d9aa66eef95a€24.00€0.37matched
86capture01a1ae63-f02a-7328-add3-ca44365648fb€24.00€0.37matched
87capture01a1ae63-f909-742b-a3f8-4a6c115dd382€49.00€0.67matched
88capture01a1ae64-06e0-754f-b485-11edb43e6fe1€15.00€0.26matched
89capture01a1ae64-3e16-7cc5-b150-a8568126ce6f€35.00€0.50matched
90refund01a1ae64-4e41-76c1-b657-46adea041c31-€16.00€0.00matched
91capture01a1ae64-612d-7cb3-9b72-9031661e4abb€49.00€0.67matched
92capture01a1ae64-5f0a-7fb4-bd12-5c9c634567a0€24.00€0.37matched
93capture01a1ae64-78cf-7db7-a7b9-ada03cf5cba9€49.00€0.67matched
94capture01a1ae64-7917-7dcb-a0e4-2388ebde6f64€24.00€0.37matched
95capture01a1ae64-9717-763b-84e2-d5043746dcb8€49.00€0.67matched
96capture01a1ae64-aa99-77db-818a-974d53162377€35.00€0.50matched
97capture01a1ae64-baa3-7762-9b94-4426a8645774€24.00€0.37matched
98capture01a1ae64-c088-7f13-a2d8-575751d09ac8€15.00€0.26matched
99capture01a1ae64-c129-7677-b9c7-f77bc10832a3€35.00€0.50matched
100capture01a1ae64-ab0a-7aa0-8ea1-43e1f470e863€15.00€0.26matched
101capture01a1ae64-cc5f-7202-8818-569991a2f8df€15.00€0.26matched
102capture01a1ae64-dc68-7877-80e6-bdd8bc5a96fa€15.00€0.26matched
103capture01a1ae64-dd77-7309-a777-108f6c94dd21€24.00€0.37matched
104refund01a1ae65-0a68-77ed-8930-077a96f004cd-€35.00€0.00matched
105capture01a1ae65-2adb-747d-ad24-da940444c1a9€24.00€0.37matched
106capture01a1ae65-3a70-7ea7-a5d1-b3b2a20c5cd8€15.00€0.26matched
107capture01a1ae65-44e7-73ec-89f6-b261d61236bd€49.00€0.67matched
108capture01a1ae65-4602-7cf4-a6fd-f45f3b5a36af€24.00€0.37matched
109capture01a1ae65-6d31-7e0e-9de0-7bb362e6fa0f€15.00€0.26matched
110capture01a1ae65-7178-72e1-8f6f-0d9d1abbf4bd€49.00€0.67matched
111capture01a1ae65-7843-7eac-b7b6-a6fb06eb02af€15.00€0.26matched
112capture01a1ae65-81da-7f50-92fd-d4aee8f56a8a€9.00€0.19matched
113refund01a1ae65-8c31-76f5-a056-f118224f6afc-€17.00€0.00matched
114capture01a1ae65-8e28-7562-9446-2603ac3da1fe€35.00€0.50matched
115capture01a1ae65-b0b2-76ef-9472-0d7d911df46f€9.00€0.19matched
116capture01a1ae65-dc32-7d05-9bfe-3e6be316d55e€35.00€0.50matched
117capture01a1ae65-e116-732c-978f-eca417dd4281€15.00€0.26matched
118capture01a1ae66-05b2-7543-8e56-003fd82ce28a€49.00€0.67matched
119capture01a1ae66-0e9e-7daf-b0b5-db4875638391€49.00€0.67matched
120capture01a1ae66-268d-7de7-81bc-7fc18594abca€9.00€0.19matched
121capture01a1ae66-2d07-706c-b2c4-7042fc7d3904€35.00€0.50matched
122capture01a1ae66-3a18-7b78-8c80-154083fe5a67€15.00€0.26matched
123capture01a1ae66-51db-7183-93fa-be53fcdbc030€9.00€0.19matched
124capture01a1ae66-53bb-740d-bc02-ebf02cac96a2€15.00€0.26matched
125capture01a1ae66-5b4c-7746-a4dc-82e7d8ff4a18€24.00€0.37matched
126capture01a1ae66-6849-7df7-9f52-157132fece9f€15.00€0.26matched
127capture01a1ae66-771b-7f72-9f7d-ced4adc1d729€49.00€0.67matched
128capture01a1ae66-7d69-7ca9-8cab-6264153e455d€15.00€0.26matched
129capture01a1ae66-8f87-7f99-9535-92ab8bd35db4€49.00€0.67matched
130capture01a1ae66-912c-75c6-a813-ea99e007448d€49.00€0.67matched
131capture01a1ae66-9b95-7e39-a8bd-8081e4583262€24.00€0.37matched
132refund01a1ae66-b469-7255-9ef2-15c87c3c7537-€6.00€0.00matched
133capture01a1ae66-becd-7011-8319-e0321273334e€49.00€0.67matched
134capture01a1ae66-c854-7ee5-b432-403639f26b1b€35.00€0.50matched
135refund01a1ae66-d1cb-7301-b989-01c23313bd88-€20.00€0.00matched
136capture01a1ae66-d65a-7156-9d64-f57e98fe08d1€24.00€0.37matched
137capture01a1ae66-dc5f-7ec6-acb3-908557efd912€35.00€0.50matched
138capture01a1ae66-e6d6-76cc-8092-5de52cf02a9f€35.00€0.50matched
139capture01a1ae66-f62e-7531-aaaa-a08af0578837€24.00€0.37matched
140capture01a1ae67-03af-714b-bd6d-78f621d0ed00€35.00€0.50matched
141capture01a1ae67-0c2c-7935-92ee-bd1417ed4b8d€9.00€0.19matched
142capture01a1ae67-0eaa-716b-be4d-dcef7b060f97€15.00€0.26matched
143capture01a1ae67-4930-7552-8dd9-ac3a3aa2ab1a€15.00€0.26matched
144capture01a1ae67-4c3e-783a-a11a-5ee4bd967743€35.00€0.50matched
145capture01a1ae67-475a-73f6-a656-42f1dc9a067d€35.00€0.50matched
146capture01a1ae67-5c66-7910-af78-0e80c735bcad€15.00€0.26matched
147capture01a1ae67-7c3c-7949-8815-862579fd014e€24.00€0.37matched
148capture01a1ae67-8d16-7762-adbb-1865d7c50632€24.00€0.37matched
149capture01a1ae67-a5f7-7000-8a83-1b72430f9189€15.00€0.26matched
150capture01a1ae67-a73e-7e6c-9d6f-f22d556faf09€35.00€0.50matched
151capture01a1ae67-b831-7fc8-a9d6-33f0c996b147€24.00€0.37matched