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

4 Nov, 20:20

Gross

€3,434.00

PSP fee

€53.33

Net to the bank

€3,380.67

Settlement journal

#385342

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 27, the contract says 26
  • missing linein the books, not in the filecapture:01a1a83f-e083-7c5e-8959-6d553f4e9c9b is in no file
LineKindReferenceGrossFeeStatus
26capture01a1a839-6fed-79d8-a1a1-f0e92fdd342a€49.00€0.70fee difference
51capture01a1a83b-693d-7c79-ade0-97fa31cf339c€15.00€0.27fee difference
1capture01a1a832-c670-7ee6-a10b-4f75dff54d41€24.00€0.37matched
2capture01a1a833-ee78-76e0-b0d7-d0705c49249c€24.00€0.37matched
3capture01a1a837-e0be-7948-9c13-53bc4cad1cf9€9.00€0.19matched
4capture01a1a838-0d07-746a-87dd-02146dad134e€24.00€0.37matched
5capture01a1a838-1efb-72b0-8196-a8913dfef48a€24.00€0.37matched
6refund01a1a838-2a33-77e4-af1e-21af9b0bda59-€4.00€0.00matched
7capture01a1a838-2b0e-74c6-8bad-0b6750825fcb€35.00€0.50matched
8capture01a1a838-41c4-7eb5-88da-20beaf147d15€49.00€0.67matched
9capture01a1a838-4f19-7560-bfa7-96a62a932564€49.00€0.67matched
10capture01a1a838-534a-7552-a610-0d359492a198€9.00€0.19matched
11capture01a1a838-6627-73d5-9888-af68dd3bd726€15.00€0.26matched
12capture01a1a838-673d-79f5-af9d-f3fae58a89f2€15.00€0.26matched
13capture01a1a838-8474-7ec0-8cb6-c74468ad5d3b€15.00€0.26matched
14capture01a1a838-8e5a-7fe8-99f8-d243f248606a€35.00€0.50matched
15capture01a1a838-926e-7909-80af-ba07ebb01da9€35.00€0.50matched
16capture01a1a838-ab99-7550-b70c-4c32d02cc16b€49.00€0.67matched
17refund01a1a838-b727-74a3-9d7f-9f493c13931b-€14.00€0.00matched
18capture01a1a838-b9fc-7300-aaac-918c9df9fccb€49.00€0.67matched
19capture01a1a838-bb29-7405-a131-ebc2fbd80d3e€49.00€0.67matched
20capture01a1a838-d599-799c-9a58-89f2bab85ddd€15.00€0.26matched
21capture01a1a838-d7bf-7d61-98cc-efab2db7986c€15.00€0.26matched
22capture01a1a838-f78f-7443-bd31-e82f1a1b7017€24.00€0.37matched
23capture01a1a839-4a4f-739e-9279-09226b87b50d€9.00€0.19matched
24capture01a1a839-4b14-7d00-af93-a87d879b4f42€35.00€0.50matched
25capture01a1a839-520c-7fa1-b438-671561a354ee€35.00€0.50matched
27capture01a1a839-80e9-7c7f-9aa5-50f0ab4feff5€49.00€0.67matched
28capture01a1a839-8ba5-71b6-8c79-1f51e19a45f0€15.00€0.26matched
29capture01a1a839-955c-7dcb-97e1-361734a6a658€49.00€0.67matched
30capture01a1a839-aa92-74b6-abe7-75fb6aae0fd7€49.00€0.67matched
31capture01a1a839-acd2-752a-9760-d8cf6edec066€49.00€0.67matched
32capture01a1a839-e6a9-75a3-92c9-b8e5d17f9863€15.00€0.26matched
33capture01a1a839-ee0c-755a-8dc7-1bcaf3d4b007€9.00€0.19matched
34capture01a1a83a-11c7-739a-9692-2ded79775e20€9.00€0.19matched
35capture01a1a83a-19b0-7d62-b326-22e6af656d3e€9.00€0.19matched
36capture01a1a83a-2095-7db7-8eb2-3447b75e5b86€24.00€0.37matched
37capture01a1a83a-2780-756d-9b9a-9ec22e0cc37b€49.00€0.67matched
38capture01a1a83a-4525-7a75-b678-7afb2667cd65€9.00€0.19matched
39refund01a1a83a-51a9-7fe1-83a7-eac477e2242c-€6.00€0.00matched
40capture01a1a83a-58e3-754f-8aa4-98d314b58bf2€9.00€0.19matched
41capture01a1a83a-6faa-7cda-81f0-ac0b79619b47€24.00€0.37matched
42capture01a1a83a-9e79-7328-95d1-72977f3f5f15€35.00€0.50matched
43capture01a1a83a-c285-719c-8c76-aaaebb0f5828€49.00€0.67matched
44capture01a1a83a-f1d8-796b-a261-bba121e1dce5€35.00€0.50matched
45capture01a1a83a-fdaf-706d-b69e-298051a37390€24.00€0.37matched
46capture01a1a83b-18dd-7c62-9a9a-3d911f7ba6a8€49.00€0.67matched
47capture01a1a83b-199c-703d-94a6-b11e69c50aa5€24.00€0.37matched
48capture01a1a83b-3423-78e9-bd44-a6c159717fb6€9.00€0.19matched
49capture01a1a83b-5092-7865-a470-4fdc91739c4c€35.00€0.50matched
50capture01a1a83b-5e97-727c-9bf7-bf26150718f9€49.00€0.67matched
52capture01a1a83b-7194-794e-8223-869812bc77ed€24.00€0.37matched
53capture01a1a83b-7adf-7318-aaf3-9abcc418203b€9.00€0.19matched
54capture01a1a83b-889e-7530-b6ea-cb861e9f81d9€49.00€0.67matched
55capture01a1a83b-8d1c-7e4c-9a6e-32dabb42f5e4€49.00€0.67matched
56capture01a1a83b-96b7-7b5e-a928-aac662b32ba6€15.00€0.26matched
57capture01a1a83b-a98c-7cf4-af42-67053dcf50a2€24.00€0.37matched
58capture01a1a83b-afb8-712b-adda-230cddffeb06€15.00€0.26matched
59capture01a1a83b-b379-7f02-84a8-ed717b12cd4c€35.00€0.50matched
60capture01a1a83b-b66c-7609-a43e-db808e2fcfea€9.00€0.19matched
61capture01a1a83b-c174-7e74-a98e-66afaadbfaba€15.00€0.26matched
62capture01a1a83b-de80-7d1e-af2f-77f53dc1059f€15.00€0.26matched
63capture01a1a83b-e7ec-761d-91fd-f08c8cbb0519€24.00€0.37matched
64capture01a1a83b-f569-7b3d-9184-00e81502ed4b€49.00€0.67matched
65capture01a1a83b-fd0e-7145-b53e-01e784289f01€15.00€0.26matched
66refund01a1a83c-17e7-7215-9e9e-98221e5b74f8-€31.00€0.00matched
67refund01a1a83c-2386-7ea5-9809-ed49d3fb1b56-€10.00€0.00matched
68capture01a1a83c-367f-78e2-9a5f-be706ce03f9f€9.00€0.19matched
69capture01a1a83c-3b4b-7949-8a02-bfcfc5cd0873€49.00€0.67matched
70capture01a1a83c-4d19-79a5-8d94-3225c89e1f6a€35.00€0.50matched
71capture01a1a83c-4eb4-7ed7-bfb6-5d371d0742dc€49.00€0.67matched
72capture01a1a83c-69be-7317-9abd-7ecda0abe949€15.00€0.26matched
73capture01a1a83c-6db3-783f-a1d7-e82ea0f10785€15.00€0.26matched
74capture01a1a83c-7be0-7147-b479-626ba0bcac31€9.00€0.19matched
75capture01a1a83c-859f-77e4-ba0a-a2d32ba23b50€9.00€0.19matched
76capture01a1a83c-8da5-7085-a188-b6a26fbbf508€24.00€0.37matched
77capture01a1a83c-9135-7b8e-ab4a-0ac6831b5a9c€49.00€0.67matched
78capture01a1a83c-a1d5-7d81-a33b-59ab07757b61€49.00€0.67matched
79refund01a1a83c-a0c4-76a8-a8f0-9c5ef9985f0c-€7.00€0.00matched
80capture01a1a83c-e252-72ea-8987-e2f14114156f€24.00€0.37matched
81capture01a1a83c-e667-7f11-9211-b72210fd48c7€24.00€0.37matched
82capture01a1a83d-3203-7067-b4ed-aad0d132fcfc€15.00€0.26matched
83refund01a1a83d-5a5c-79f5-9d35-1e2eee0dd94c-€10.00€0.00matched
84capture01a1a83d-6dd4-711b-8231-7de852d34178€49.00€0.67matched
85capture01a1a83d-847c-7064-820b-59b51a54b36f€49.00€0.67matched
86capture01a1a83d-9a50-738e-8073-7be342f5be96€49.00€0.67matched
87capture01a1a83d-9ca9-732d-9cd0-a847ca19d56a€24.00€0.37matched
88capture01a1a83d-a256-7069-92e9-51442c5b0621€35.00€0.50matched
89capture01a1a83d-a980-780c-ab41-ed92f422326a€49.00€0.67matched
90capture01a1a83d-aa83-7210-bed6-fbad4d4a59c2€24.00€0.37matched
91capture01a1a83d-b30e-7d79-a9d3-1c10fbc9c331€9.00€0.19matched
92capture01a1a83d-b3fc-7db8-932f-955097ecfa6a€9.00€0.19matched
93capture01a1a83d-bd2e-74ed-8f69-053298317daa€35.00€0.50matched
94capture01a1a83d-c4aa-7894-a62d-fa7289ddae21€49.00€0.67matched
95capture01a1a83d-c69b-7355-8036-4b6291c8bd1f€24.00€0.37matched
96refund01a1a83d-cec6-756f-af3e-79614543acac-€10.00€0.00matched
97refund01a1a83d-dd83-7f89-be13-806b2b5ee91e-€29.00€0.00matched
98capture01a1a83e-06f6-771e-9ee2-846f687fc71e€9.00€0.19matched
99capture01a1a83e-226a-782f-8f69-08b5ebff9092€24.00€0.37matched
100capture01a1a83e-2301-7a71-bccd-6312aa00dac0€24.00€0.37matched
101capture01a1a83e-412d-7159-9060-63d091565f05€24.00€0.37matched
102capture01a1a83e-53b7-78fd-83f8-cf4f72340296€49.00€0.67matched
103capture01a1a83e-58ca-7e7b-92bb-4032ba3a024c€49.00€0.67matched
104capture01a1a83e-609f-76c9-9aca-79d477756c35€35.00€0.50matched
105refund01a1a83e-6a53-7bca-b719-457225ed37c4-€20.00€0.00matched
106capture01a1a83e-74b2-7be7-9717-579a1e000efc€49.00€0.67matched
107capture01a1a83e-769f-7735-81b6-43d4eeca2610€49.00€0.67matched
108capture01a1a83e-7cd0-7f3f-ad96-4453164ea274€24.00€0.37matched
109capture01a1a83e-8206-7739-b85a-05953d692dc8€15.00€0.26matched
110capture01a1a83e-8a91-79e1-80ea-2ffb454ba724€15.00€0.26matched
111refund01a1a83e-c7f7-7322-b978-a27f3b364c28-€9.00€0.00matched
112capture01a1a83e-d43e-7289-914f-07463c598285€35.00€0.50matched
113capture01a1a83e-e78c-7757-9afc-564e7d75b913€49.00€0.67matched
114capture01a1a83e-f557-7d82-83b0-df3b617c906e€9.00€0.19matched
115capture01a1a83f-17ba-7683-9beb-d1bde0b49692€24.00€0.37matched
116capture01a1a83f-3bad-7dfe-b1a8-238d736e1de1€49.00€0.67matched
117capture01a1a83f-55cd-7bc7-a874-0696351e13df€35.00€0.50matched
118capture01a1a83f-5bb1-7dce-96c1-ea48e6c788e5€49.00€0.67matched
119capture01a1a83f-5e7e-76cb-a8a5-9666dfe012ed€24.00€0.37matched
120capture01a1a83f-76b6-79cb-9837-8ac64bb6fc46€35.00€0.50matched
121capture01a1a83f-8047-746e-b1b3-f87b9a8779ef€15.00€0.26matched
122capture01a1a83f-80e5-796b-a9a0-1264821f6e74€49.00€0.67matched
123capture01a1a83f-81c1-7480-9521-7d01db62fa42€15.00€0.26matched
124capture01a1a83f-9824-734d-929c-c7d8596bb990€24.00€0.37matched
125capture01a1a83f-e689-79b9-accd-dbf07ec667c3€24.00€0.37matched
126capture01a1a83f-ecf4-74ae-8be5-889a534fad38€35.00€0.50matched
127capture01a1a840-0346-74c6-a494-401eb5290f02€15.00€0.26matched
128capture01a1a840-2d65-7dba-8fc1-9e135183f424€24.00€0.37matched
129refund01a1a840-721b-7526-a73c-808b8f646186-€10.00€0.00matched
130capture01a1a840-7e31-72c9-9d3c-c3626ebf0756€35.00€0.50matched
131capture01a1a840-8615-7755-9c67-7b8a31ffc5bc€35.00€0.50matched
132capture01a1a840-8961-7e32-851b-d2fc69cd97ec€15.00€0.26matched
133capture01a1a840-ba48-746a-bd52-35710304acb6€15.00€0.26matched
134capture01a1a840-bd20-78e5-8d59-a595d3c1cd80€49.00€0.67matched
135capture01a1a840-c78c-740c-9d0d-475c1a54eede€35.00€0.50matched
136capture01a1a841-05ae-7fb4-9f72-9b13c06f0c69€9.00€0.19matched
137capture01a1a841-0772-7799-be5e-0322ce25e26e€15.00€0.26matched