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

Gross

€3,096.00

PSP fee

€49.69

Net to the bank

€3,046.31

Settlement journal

#398281

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • missing linein the books, not in the filecapture:01a1abe4-5713-7832-b5c9-ff45659f66d3 is in no file
LineKindReferenceGrossFeeStatus
22capture01a1abdf-6fa5-7d0f-9a9e-b0a59d1e6d28€49.00€0.68fee difference
123capture01a1abe5-e108-7de3-8027-ac7cff13906f€15.00€0.29fee difference
1capture01a1abd9-677c-785f-b2bc-6a67aa384e41€15.00€0.26matched
2capture01a1abdc-5a72-7387-873d-e752352ae575€49.00€0.67matched
3refund01a1abdd-a583-7e20-a2c0-d814b515e5f9-€35.00€0.00matched
4capture01a1abdd-f94b-74ba-b067-b4c6276c88fb€9.00€0.19matched
5capture01a1abde-0a95-7fdb-aa3d-edd7f4a1db00€35.00€0.50matched
6capture01a1abde-2197-75be-bf20-c78f515a234a€35.00€0.50matched
7capture01a1abde-409e-7c3f-a036-65b4ec888ca8€24.00€0.37matched
8capture01a1abde-4ff5-784d-b141-394e2fe80559€49.00€0.67matched
9capture01a1abde-62fd-73bb-8a49-d959fc5c8acb€35.00€0.50matched
10capture01a1abde-770d-70af-a0e4-10d81859a314€35.00€0.50matched
11capture01a1abde-a57b-7103-98eb-5931e165c3f4€49.00€0.67matched
12capture01a1abde-a659-7e39-b55b-b4474a158501€24.00€0.37matched
13capture01a1abde-bcaa-7c3f-b5c9-09673dfb9cd6€24.00€0.37matched
14capture01a1abde-c304-779c-b10c-1f26f24b0695€35.00€0.50matched
15capture01a1abde-d0aa-7f47-8b16-c21bea10445e€35.00€0.50matched
16capture01a1abde-d393-78ce-aba0-6cf0766f4bcf€15.00€0.26matched
17capture01a1abde-eae2-7a4c-9f58-d68517c5c080€49.00€0.67matched
18capture01a1abde-f846-7bf6-b133-85673e7e55d1€15.00€0.26matched
19refund01a1abde-fdea-7c46-8576-5e1c9ccd473a-€29.00€0.00matched
20capture01a1abdf-2530-7585-99b6-c648b1650b13€49.00€0.67matched
21capture01a1abdf-3606-74a4-b652-da0e464d2a17€15.00€0.26matched
23capture01a1abdf-82ad-7a6e-bc88-b17e548986db€49.00€0.67matched
24capture01a1abdf-a532-70f5-9411-b39476fda5f1€9.00€0.19matched
25capture01a1abdf-a8ea-7c7f-853b-5482bc8ae968€49.00€0.67matched
26capture01a1abdf-a95b-76ce-8da3-2bc22d69575c€9.00€0.19matched
27capture01a1abdf-b2b5-7684-90b0-fd10b712dd91€35.00€0.50matched
28capture01a1abdf-c25e-72a8-8292-bd9bbd2a2376€49.00€0.67matched
29capture01a1abdf-c3ad-717a-b7d2-49793be974b9€15.00€0.26matched
30capture01a1abdf-dbab-74b4-b00a-396db43b73e6€35.00€0.50matched
31capture01a1abdf-dd42-7145-9df3-7f2cae19eeb0€49.00€0.67matched
32capture01a1abdf-ef2c-7158-9dfe-7b4a3f7faa52€35.00€0.50matched
33capture01a1abe0-09e3-7bc8-8dbf-25ba4fe18a10€24.00€0.37matched
34capture01a1abe0-1ef9-7125-988a-8304328544f4€35.00€0.50matched
35capture01a1abe0-2160-7d10-81e9-80c76aeaba7d€9.00€0.19matched
36refund01a1abe0-236a-7ed5-a0b5-6398972fa479-€24.00€0.00matched
37capture01a1abe0-3ffe-7f8e-9a82-c3caf3f51646€9.00€0.19matched
38capture01a1abe0-4fe3-715b-b199-d769515dc285€49.00€0.67matched
39capture01a1abe0-6019-722b-9dad-aaf83cff6062€15.00€0.26matched
40capture01a1abe0-625c-71c7-9358-5cbcaa736e72€9.00€0.19matched
41capture01a1abe0-670d-7605-9718-e9c40d617322€49.00€0.67matched
42capture01a1abe0-70af-73c6-bf62-01d351e8dbc3€35.00€0.50matched
43capture01a1abe0-733b-7cb6-b392-8b99386f3f0a€15.00€0.26matched
44capture01a1abe0-9195-7c0c-bab5-3a3511d93cf5€15.00€0.26matched
45capture01a1abe0-928c-76e1-a2d1-4160b9a222dd€24.00€0.37matched
46capture01a1abe0-a860-7de4-b4b0-d36659ef0286€35.00€0.50matched
47capture01a1abe0-c012-7774-832f-65d5ccf995b6€24.00€0.37matched
48capture01a1abe0-c4e6-754e-9f2f-59d29fc92ab9€49.00€0.67matched
49refund01a1abe0-d482-73c2-92c1-bfc8a540ba07-€13.00€0.00matched
50capture01a1abe0-d607-71cc-af81-41e64124d453€15.00€0.26matched
51refund01a1abe0-deb9-7298-8291-5333d88975e5-€26.00€0.00matched
52capture01a1abe1-0c1b-7490-8415-b71d33d156ba€24.00€0.37matched
53capture01a1abe1-1591-71bd-b831-0ed64dd112b1€35.00€0.50matched
54capture01a1abe1-1a46-7c29-a6b3-b89ca0fbbeec€15.00€0.26matched
55capture01a1abe1-1b94-778b-902f-6d5675dbe288€24.00€0.37matched
56capture01a1abe1-2252-7f3d-946b-4edd011c37c7€35.00€0.50matched
57capture01a1abe1-229c-7383-9833-539fec22d51c€35.00€0.50matched
58refund01a1abe1-24a0-7d3e-9c1d-ffbfa3c27a29-€17.00€0.00matched
59capture01a1abe1-4b33-7829-b305-6ff2a41c236f€24.00€0.37matched
60capture01a1abe1-4fe4-7e72-ac60-f18023f3f007€35.00€0.50matched
61capture01a1abe1-5ab7-7402-b433-66915edd57c4€9.00€0.19matched
62capture01a1abe1-5c09-704d-bf63-a70962b10ed2€35.00€0.50matched
63capture01a1abe1-7082-7037-90af-6d39921c1a80€24.00€0.37matched
64capture01a1abe1-71ff-7199-ac8e-85fd89941837€24.00€0.37matched
65capture01a1abe1-77cd-7305-a883-294528e99299€24.00€0.37matched
66capture01a1abe1-873d-7819-a9ea-5f9ff20088e4€24.00€0.37matched
67capture01a1abe1-88f8-755d-9da8-b07685636c9f€35.00€0.50matched
68capture01a1abe1-8bc2-7d69-8d1f-ec545629de51€35.00€0.50matched
69capture01a1abe1-aaaa-7205-987e-5e8dfb7ecaca€35.00€0.50matched
70capture01a1abe1-ab1d-7686-8a26-78e2f897dd71€15.00€0.26matched
71capture01a1abe1-c660-72c8-aa00-c6b3eaf458ad€9.00€0.19matched
72capture01a1abe1-c6aa-71e2-ac51-c10295e69d7f€15.00€0.26matched
73capture01a1abe1-dd64-7cfc-9d0b-01b2fc074d8a€15.00€0.26matched
74capture01a1abe1-eb93-718c-906f-af063edfbfa2€24.00€0.37matched
75capture01a1abe1-f396-7168-a837-02f719d4219a€49.00€0.67matched
76capture01a1abe2-34d2-77b2-8762-924acc43f22f€24.00€0.37matched
77capture01a1abe2-47bf-7d3b-a1f4-557c0932c6be€35.00€0.50matched
78capture01a1abe2-5920-7f77-8488-f862655ba540€9.00€0.19matched
79capture01a1abe2-6b81-7f13-90d7-b355c888821a€49.00€0.67matched
80capture01a1abe2-735a-7fa8-a723-316d9a16ca7c€9.00€0.19matched
81capture01a1abe2-8353-7215-b387-2aabbeca3f59€49.00€0.67matched
82capture01a1abe2-ad95-79ae-b492-4c42ebac9e29€35.00€0.50matched
83capture01a1abe2-b02c-7326-ab79-ec426b1e5f82€15.00€0.26matched
84capture01a1abe2-c23e-7141-beec-9454f07259ec€49.00€0.67matched
85capture01a1abe2-c9e0-77cf-ba60-0b2cee79afcd€24.00€0.37matched
86capture01a1abe2-f85d-7364-9773-bb03d819cfb1€24.00€0.37matched
87capture01a1abe2-fe5e-7582-b08d-b73aca8cd769€24.00€0.37matched
88capture01a1abe3-0252-7d7f-9310-b94580ee2cf9€15.00€0.26matched
89refund01a1abe3-1a9b-7e34-807c-134529c88b4e-€11.00€0.00matched
90capture01a1abe3-4ca3-7712-bcbd-6af4aa3b0e34€15.00€0.26matched
91capture01a1abe3-91af-7453-bdbf-e8f7d27584f3€15.00€0.26matched
92capture01a1abe3-90d7-779b-8f11-082c3c278d9a€9.00€0.19matched
93refund01a1abe3-b5d9-722b-a64b-314d4ef5edfb-€6.00€0.00matched
94capture01a1abe3-b6bb-7fd1-99d7-34f5d4653d80€35.00€0.50matched
95capture01a1abe3-cd7c-70eb-8225-79500e37e3b0€49.00€0.67matched
96refund01a1abe3-e58f-7091-a401-62204a53d8b1-€13.00€0.00matched
97refund01a1abe3-f8d8-73f6-bf48-830efef91a6a-€5.00€0.00matched
98capture01a1abe4-1518-7b48-86fb-95706899a466€9.00€0.19matched
99capture01a1abe4-208b-7fdb-8608-2f0456fa92ef€9.00€0.19matched
100capture01a1abe4-2e32-747b-a636-221a35ef946c€15.00€0.26matched
101capture01a1abe4-597a-7668-b39e-723a93f672a9€9.00€0.19matched
102capture01a1abe4-62c0-7357-840d-8c331a120176€15.00€0.26matched
103capture01a1abe4-6dd8-7443-8a86-3b5a0f6da095€49.00€0.67matched
104capture01a1abe4-845a-7aba-a829-fa879b42b1e3€49.00€0.67matched
105capture01a1abe4-b0d3-7194-8c81-92a06af19692€9.00€0.19matched
106capture01a1abe4-b2a4-7e81-9c9c-0918ae72304f€49.00€0.67matched
107capture01a1abe4-c4a8-7117-adbd-da7f1df1f567€9.00€0.19matched
108capture01a1abe4-dc13-76d1-a7fa-b7ca530837be€49.00€0.67matched
109capture01a1abe4-ede2-74fe-96c5-13c4d958e277€9.00€0.19matched
110capture01a1abe4-f2d2-7f40-90ff-64e1952187b3€49.00€0.67matched
111capture01a1abe4-f2d4-7b91-ad6e-3a66f88f4da6€24.00€0.37matched
112capture01a1abe4-faba-70b7-865e-b0fed9deb83f€9.00€0.19matched
113capture01a1abe5-22ef-75ab-932c-f41d82c02686€15.00€0.26matched
114capture01a1abe5-26b0-7df8-ad3c-781da433a4d0€35.00€0.50matched
115capture01a1abe5-460e-760e-bac5-7a9b7935cbda€49.00€0.67matched
116capture01a1abe5-49b3-7452-b69b-a85d53e78b71€49.00€0.67matched
117capture01a1abe5-4b97-7c74-9b20-c03e113070c6€35.00€0.50matched
118capture01a1abe5-5b22-7fcd-b0c1-aab50612d009€9.00€0.19matched
119refund01a1abe5-61ab-77b5-b4f2-ff5578887ca0-€20.00€0.00matched
120capture01a1abe5-62de-7a80-9090-8f6e197a4cf0€15.00€0.26matched
121refund01a1abe5-b23e-78df-8b68-24c12f4c9581-€8.00€0.00matched
122capture01a1abe5-dd7d-71b5-a8e4-fc7bb1fad525€24.00€0.37matched
124capture01a1abe6-28f7-7a11-abbb-f49e6f900040€9.00€0.19matched
125capture01a1abe6-34bd-7747-8c54-512048aa0975€35.00€0.50matched
126capture01a1abe6-3e68-777c-809c-aafe5dd92c94€9.00€0.19matched
127capture01a1abe6-4343-76d4-a38f-000f748977ee€24.00€0.37matched
128capture01a1abe6-5106-7583-9c8c-e868273bdd83€49.00€0.67matched
129capture01a1abe6-53fb-72c7-be4b-3dce9d7d1fe5€35.00€0.50matched
130capture01a1abe6-59c9-7934-9a2d-7464fb7ca509€35.00€0.50matched
131refund01a1abe6-767a-7121-b94d-1acb1862c493-€16.00€0.00matched
132capture01a1abe6-bec5-7155-8b67-328b9007dc64€9.00€0.19matched
133capture01a1abe6-c6d6-7702-b5f5-9d7f31457147€24.00€0.37matched
134capture01a1abe6-d447-72f1-b447-d786fa769f89€9.00€0.19matched