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, 09:30

Gross

€3,079.00

PSP fee

€49.99

Net to the bank

€3,029.01

Settlement journal

#413763

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b036-ede6-7267-bc75-e357d2dda7ce is already settled by stl_EUR_2989929 line 79
  • duplicate linethe file lists it twicecapture:01a1b037-9d62-755f-aea4-16de302b50f7 is already settled by stl_EUR_2989929 line 93
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 41, the contract says 37
LineKindReferenceGrossFeeStatus
52capture01a1b034-e4cd-7f4a-b048-9158beac5e63€9.00€0.24fee difference
80capture01a1b036-edfe-7873-b824-3fc13d4e3d77€35.00€0.50duplicate line
94capture01a1b037-b5e7-79c2-b241-fa567d037779€35.00€0.50duplicate line
119capture01a1b039-9efd-7193-88b9-d0315e16edfb€24.00€0.41fee difference
1capture01a1b028-db8a-7e84-b353-2b0821249b7f€49.00€0.67matched
2capture01a1b029-d017-798c-90c4-c65b13eea997€49.00€0.67matched
3capture01a1b031-0c4c-7ba4-8700-6926c60a73ad€35.00€0.50matched
4capture01a1b031-b561-71db-9783-6be0f391663c€35.00€0.50matched
5capture01a1b031-d380-7eae-834d-6db0d09671f6€49.00€0.67matched
6capture01a1b031-da71-77ce-b34f-5698048be053€24.00€0.37matched
7capture01a1b031-def0-765a-a6b7-593200ede1e6€24.00€0.37matched
8capture01a1b031-e4f6-70c1-b5b3-b3c4b6d4adc6€24.00€0.37matched
9capture01a1b031-f324-7a70-9fe9-8ade8f406b93€9.00€0.19matched
10capture01a1b031-f38e-73c5-9be8-9331c66a4d01€35.00€0.50matched
11capture01a1b032-0bb7-7186-9b59-649e916565dd€24.00€0.37matched
12refund01a1b032-213c-7d8a-af32-1b4e1a53573d-€17.00€0.00matched
13refund01a1b032-2340-7419-a49a-b06e7f77bbeb-€49.00€0.00matched
14capture01a1b032-2a90-767b-a474-5b58e1444bfc€24.00€0.37matched
15refund01a1b032-375e-740e-bcb8-b104a71d049a-€4.00€0.00matched
16capture01a1b032-3ff0-7225-86c3-b3e8df599c6b€49.00€0.67matched
17capture01a1b032-4798-7599-9b0b-2a30e6577ce2€35.00€0.50matched
18refund01a1b032-51c5-77e4-8526-83a343c04a7b-€21.00€0.00matched
19capture01a1b032-71a8-7654-b436-b210b4e46387€24.00€0.37matched
20capture01a1b032-99c6-72dd-a71e-759eb1f31d0d€49.00€0.67matched
21capture01a1b032-9c5f-7817-97a9-3d5ac3694195€35.00€0.50matched
22capture01a1b032-a084-7eba-98bc-b2933090bb01€49.00€0.67matched
23capture01a1b032-a4e4-7fbd-9b7a-2cee87c10f3a€9.00€0.19matched
24capture01a1b032-b2b5-7a3d-ab56-ef672bd8558b€9.00€0.19matched
25capture01a1b032-b3c1-78c5-bd7e-29f840973c98€49.00€0.67matched
26refund01a1b032-c9b0-7a9e-941f-e4b7f7d734cb-€40.00€0.00matched
27capture01a1b032-e865-702e-b7b4-15835c6d5898€9.00€0.19matched
28capture01a1b032-ef04-7b5a-ab24-34548325eea0€9.00€0.19matched
29capture01a1b032-f1c1-7263-9b3f-703a2d8f937d€9.00€0.19matched
30capture01a1b033-0a70-7f5c-aa68-637a28c58499€15.00€0.26matched
31capture01a1b033-1b13-7080-8863-9272cf827b39€15.00€0.26matched
32capture01a1b033-3620-700d-a397-06d880a669e0€35.00€0.50matched
33capture01a1b033-47f6-75b5-8cfb-4797563fa45f€24.00€0.37matched
34capture01a1b033-7963-715f-975f-f4f42a95ea98€9.00€0.19matched
35capture01a1b033-82ab-73b9-8c77-1033a3f95084€9.00€0.19matched
36capture01a1b033-82b5-7433-8df0-1f576a6af46c€15.00€0.26matched
37capture01a1b033-874b-740f-87a5-5bb98489cebe€24.00€0.37matched
38capture01a1b033-8c39-7c09-81d3-e6446547657b€24.00€0.37matched
39refund01a1b033-a092-7303-b42e-6d34c081f7b0-€19.00€0.00matched
40capture01a1b033-bb8a-7ffd-99f3-c236b7dc8f0c€35.00€0.50matched
41refund01a1b033-bc6d-74e8-8112-5f3522c5ce96-€4.00€0.00matched
42capture01a1b033-c02a-7de3-9b00-35f23b021cdb€35.00€0.50matched
43capture01a1b033-e147-70d0-b286-9a4800a8eed2€15.00€0.26matched
44capture01a1b033-fe0f-7c05-96b6-7523b2da172d€9.00€0.19matched
45capture01a1b034-152d-74cd-9cdc-ecc10408a86f€24.00€0.37matched
46capture01a1b034-538f-79c6-9d4b-92ba34824d3b€49.00€0.67matched
47capture01a1b034-660d-7bd8-a068-92ce71f10a32€9.00€0.19matched
48capture01a1b034-7795-7c25-92d8-6bd1d61b6340€15.00€0.26matched
49capture01a1b034-a5e0-7f1c-af7b-4c1cdca6e940€35.00€0.50matched
50capture01a1b034-a6c0-7f56-9dca-3bd0254b7f64€49.00€0.67matched
51capture01a1b034-b30d-7f2e-90a8-c5d3c52d216d€49.00€0.67matched
53capture01a1b035-0409-7ea4-88b1-4eb773d1a00a€24.00€0.37matched
54capture01a1b035-0522-7a76-9b28-b1505c22a87e€35.00€0.50matched
55capture01a1b035-0d6c-72ea-be52-08cfe742003d€24.00€0.37matched
56capture01a1b035-145f-7661-b12f-4e0d68287e77€15.00€0.26matched
57capture01a1b035-1464-7530-8860-ccb888658578€35.00€0.50matched
58capture01a1b035-198f-76b6-beaf-ba1e085ff0fe€9.00€0.19matched
59capture01a1b035-1d02-7864-933c-5ad09b0ec415€35.00€0.50matched
60capture01a1b035-28ec-7281-ba9b-3f745ca33d10€24.00€0.37matched
61refund01a1b035-46f1-7176-9c8c-8abe6de37292-€30.00€0.00matched
62capture01a1b035-62e4-79bd-99a5-9c5a5d630356€15.00€0.26matched
63capture01a1b035-781f-7943-9387-c05fbfeb6dd3€15.00€0.26matched
64capture01a1b035-8955-7f83-9c73-6a595263dafc€9.00€0.19matched
65capture01a1b035-acc9-75ac-854a-221142ec4235€35.00€0.50matched
66capture01a1b035-af9a-768b-81f4-d73a66f9ee59€9.00€0.19matched
67capture01a1b035-c4c1-7cae-a89c-fbfb4c5bd865€15.00€0.26matched
68capture01a1b035-f7b9-7eb2-8154-5fa106931f50€49.00€0.67matched
69capture01a1b035-fce1-7417-9e59-770ce4b754ba€24.00€0.37matched
70capture01a1b036-0625-79c2-aeb2-1b33ab3e4fce€9.00€0.19matched
71capture01a1b036-101f-7238-8917-774aed800c8c€9.00€0.19matched
72capture01a1b036-1f83-72be-91d2-c263015cac1d€24.00€0.37matched
73capture01a1b036-2ed3-7f0d-bc06-c6a725a4e4da€24.00€0.37matched
74capture01a1b036-3c71-7bc2-adb4-999886e6e916€35.00€0.50matched
75capture01a1b036-402a-7007-a9cb-0fbb83e2985f€49.00€0.67matched
76refund01a1b036-aba8-76ec-a7f2-1dc17efd92b9-€25.00€0.00matched
77capture01a1b036-accd-7fb6-9f57-4efea1efe34d€15.00€0.26matched
78refund01a1b036-e5e6-7f18-8c89-682ac959d2fb-€6.00€0.00matched
79capture01a1b036-edfe-7873-b824-3fc13d4e3d77€35.00€0.50matched
81capture01a1b036-eeac-71e4-b9dd-c9991f2f00a3€35.00€0.50matched
82capture01a1b037-0d41-7ddd-b0e3-42b230440201€49.00€0.67matched
83capture01a1b037-4644-7e35-bcae-6a27b9de9840€49.00€0.67matched
84capture01a1b037-6aa7-7f50-ac5a-6adf44555c31€15.00€0.26matched
85capture01a1b037-6ab5-74f1-861f-47344b2b4477€15.00€0.26matched
86capture01a1b037-6b23-79d8-98ec-1d84beaeb712€35.00€0.50matched
87capture01a1b037-7c79-72c9-b0f3-cee6b99c186c€35.00€0.50matched
88capture01a1b037-7ecc-767a-b4d3-6328407a1c3c€15.00€0.26matched
89capture01a1b037-81fb-7f87-a785-afb2528cd972€9.00€0.19matched
90capture01a1b037-98c7-7663-b4d6-5d7f13d28e6b€35.00€0.50matched
91capture01a1b037-a854-7ab6-819d-ccb205285979€49.00€0.67matched
92refund01a1b037-b2d9-7234-9c1f-b29bd31c7ffb-€5.00€0.00matched
93capture01a1b037-b5e7-79c2-b241-fa567d037779€35.00€0.50matched
95capture01a1b037-c97d-7fd3-997b-e6f66613cdd8€15.00€0.26matched
96capture01a1b037-ca3a-7897-9231-5c222094a268€49.00€0.67matched
97capture01a1b037-d825-73bd-a0c2-9e0678484bb6€15.00€0.26matched
98refund01a1b037-da5a-76e6-a568-1f030d0ac878-€15.00€0.00matched
99capture01a1b037-e785-7845-9ba0-c4cd9d0977a7€49.00€0.67matched
100capture01a1b037-f270-7a8d-a37a-eb3a95d08115€49.00€0.67matched
101capture01a1b037-fdba-7171-a38d-4af9e3b8d22d€49.00€0.67matched
102capture01a1b038-3a1a-7450-930d-ceeb9d52d349€49.00€0.67matched
103capture01a1b038-40d6-7393-819b-737e91dacd75€24.00€0.37matched
104capture01a1b038-597d-71e2-8bf7-c1ade6fc2662€24.00€0.37matched
105capture01a1b038-5ad3-7f99-945b-bcb8c32d31c4€24.00€0.37matched
106capture01a1b038-721d-796f-9d79-dc9d4e2e23ea€9.00€0.19matched
107capture01a1b038-7233-710c-b8e3-9663c10e4b4a€24.00€0.37matched
108capture01a1b038-738b-73e0-bf17-b62f9e338181€9.00€0.19matched
109capture01a1b038-7511-7bee-96c9-02d453fe2b4d€49.00€0.67matched
110capture01a1b038-92c8-7d28-a3e8-090023fd436c€49.00€0.67matched
111capture01a1b038-b5ec-716a-ba5e-2786e6ecbff1€15.00€0.26matched
112capture01a1b038-cfe9-79ee-9fc7-5910137290f6€15.00€0.26matched
113capture01a1b038-e42e-7148-97aa-5e9c25495f82€24.00€0.37matched
114capture01a1b039-0490-745b-94d1-f0932f8e524e€9.00€0.19matched
115capture01a1b039-19b3-7be5-8f68-40e4ba44cb4a€9.00€0.19matched
116capture01a1b039-22b4-759c-8cc6-45d9203d53aa€35.00€0.50matched
117capture01a1b039-4cd4-7325-9e46-59bcec0555ab€49.00€0.67matched
118capture01a1b039-691b-7661-bc00-9cf5e79a1054€24.00€0.37matched
120capture01a1b039-c749-778f-a29d-16b97b5b0b49€9.00€0.19matched
121capture01a1b039-df33-7a1b-bff7-51e599842f2c€49.00€0.67matched
122capture01a1b039-d6df-78f4-a5b5-541167ce8550€9.00€0.19matched
123capture01a1b039-fd5d-763e-be2e-f9aac8f18e37€24.00€0.37matched
124capture01a1b039-fe11-7260-8984-5c4c0a4762d3€49.00€0.67matched
125capture01a1b03a-2450-74db-a2db-2ae9d04a7f1d€9.00€0.19matched
126refund01a1b03a-30fd-78b8-8d63-a4572c49b288-€3.00€0.00matched
127capture01a1b03a-3f19-773c-a57a-e225dfa2f87d€49.00€0.67matched
128capture01a1b03a-53f6-780c-aed4-e66b370978e1€24.00€0.37matched
129capture01a1b03a-6c92-7a03-8a04-93c99b356dc7€24.00€0.37matched
130capture01a1b03a-8277-7f5a-b837-c1da823a7a5a€35.00€0.50matched
131refund01a1b03a-8754-7444-93d1-ac2ff1ce39c5-€8.00€0.00matched
132capture01a1b03a-8a33-78e0-8fa0-930ad7067348€24.00€0.37matched
133capture01a1b03a-976d-76a9-81d7-8a68fec8661e€24.00€0.37matched
134capture01a1b03a-a7a2-7422-b66e-1f16c337a2ab€9.00€0.19matched
135capture01a1b03a-b005-729c-830e-12dcb45cccfa€15.00€0.26matched
136capture01a1b03a-b069-71b2-a2a9-7764aa18e6a4€9.00€0.19matched
137capture01a1b03a-b4b6-77f5-a9dd-3599d3b69e61€35.00€0.50matched