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, 16:10

Gross

€3,131.00

PSP fee

€49.51

Net to the bank

€3,081.49

Settlement journal

#400445

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 72, 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:01a1ac79-f75d-72d2-b192-0f763b9f5936 is in no file
LineKindReferenceGrossFeeStatus
39capture01a1ac7c-1703-7b9c-86e2-74fb8218f86f€24.00€0.38fee difference
82capture01a1ac7e-5fd0-779e-af67-4391ffc5571e€49.00€0.72fee difference
94capture01a1ac7f-249d-78fc-ba28-365a32092cc5€15.00€0.29fee difference
1capture01a1ac73-e5e8-777c-9910-32ea0a6bba81€24.00€0.37matched
2capture01a1ac73-ec8e-7158-b771-0fcb4846b12d€15.00€0.26matched
3capture01a1ac79-7da2-76ae-96e1-cb703c8f7324€35.00€0.50matched
4capture01a1ac79-9946-74a7-9c03-33acf1cde976€15.00€0.26matched
5capture01a1ac79-afdb-7ddf-a57a-a1cfc92c39e6€9.00€0.19matched
6capture01a1ac79-b1d4-76e8-93c1-d32d8c406f52€24.00€0.37matched
7capture01a1ac7a-1fdf-7fe0-b56a-4e59d2dc2880€15.00€0.26matched
8capture01a1ac7a-2d8f-742f-874d-f5177b54949d€49.00€0.67matched
9capture01a1ac7a-2eca-755d-bbb1-c08d4738803a€24.00€0.37matched
10capture01a1ac7a-349c-7dd0-94f8-20471473272d€24.00€0.37matched
11capture01a1ac7a-5daa-76cb-a6d5-211c7257da38€49.00€0.67matched
12capture01a1ac7a-5e0a-7ba5-9a3e-0cf9be2af026€9.00€0.19matched
13capture01a1ac7a-6064-723c-810a-6f52f197e860€35.00€0.50matched
14capture01a1ac7a-66ee-7288-9d5b-3db340e78691€49.00€0.67matched
15capture01a1ac7a-6fdd-7bcd-bcdb-44ad721bd632€15.00€0.26matched
16capture01a1ac7a-ac5c-753e-ae74-2bc8cb8deb9b€15.00€0.26matched
17capture01a1ac7a-ada1-71ac-8591-d36ee7d7e938€9.00€0.19matched
18refund01a1ac7a-bb56-77c7-9201-272ea772eb35-€27.00€0.00matched
19capture01a1ac7a-caa5-7f97-91fd-d8b6330c664d€24.00€0.37matched
20capture01a1ac7a-caaf-7a00-bcfe-a19d8f1a94d0€49.00€0.67matched
21capture01a1ac7a-ef6b-72e8-bb06-d17e546a06ed€9.00€0.19matched
22capture01a1ac7a-f84c-7ff6-8028-a9d6b20f448d€49.00€0.67matched
23capture01a1ac7b-04ad-75ea-bd6c-5fe417c91d63€35.00€0.50matched
24capture01a1ac7b-0fa6-7019-8dfd-9ba43ecafbf1€24.00€0.37matched
25capture01a1ac7b-23c6-76cb-b7f6-89baaa712226€49.00€0.67matched
26capture01a1ac7b-3153-7f40-9a4c-f9b567ea330f€15.00€0.26matched
27capture01a1ac7b-32c2-7822-b1bd-c4d17d34be8e€35.00€0.50matched
28capture01a1ac7b-6abe-7988-a66b-7b530a7c0aac€9.00€0.19matched
29capture01a1ac7b-81a0-7750-9602-7f5bec8c5a72€15.00€0.26matched
30capture01a1ac7b-af7f-7380-8757-994c30c9ae7c€49.00€0.67matched
31capture01a1ac7b-b0b5-74c5-a3d6-3c1eaea70230€15.00€0.26matched
32capture01a1ac7b-b603-767a-be73-7087bb0e0a9b€24.00€0.37matched
33capture01a1ac7b-cef7-7ea5-a788-205c540b361f€15.00€0.26matched
34capture01a1ac7b-db3c-7f6a-b8c3-34101281f807€35.00€0.50matched
35capture01a1ac7b-dbb9-708f-98be-bb93e42ce2f5€35.00€0.50matched
36capture01a1ac7b-e62b-7164-98d4-4bd7519d6a4f€15.00€0.26matched
37capture01a1ac7b-e8df-71d6-87a5-24faab0a728d€24.00€0.37matched
38capture01a1ac7c-0abd-787e-8fe9-25a6eca5afe0€24.00€0.37matched
40refund01a1ac7c-2d5f-7101-ad2c-07e7128b1103-€10.00€0.00matched
41capture01a1ac7c-3dd5-7719-863b-d9e9c0fdc212€24.00€0.37matched
42capture01a1ac7c-3e35-707e-a567-c5861f70fac2€35.00€0.50matched
43capture01a1ac7c-4100-76b4-a5b8-d44d1b0423ee€24.00€0.37matched
44capture01a1ac7c-5194-77cc-b1e7-31b81d5d0d10€24.00€0.37matched
45capture01a1ac7c-5631-75b8-ab9e-9978561b8945€35.00€0.50matched
46capture01a1ac7c-5710-79ac-9dca-e7e60a6ad0de€24.00€0.37matched
47capture01a1ac7c-6a05-78fa-850b-b828ff546ea4€15.00€0.26matched
48capture01a1ac7c-75ce-7ffe-a6db-7bc8f4a64731€24.00€0.37matched
49capture01a1ac7c-c1fe-7392-8f49-3762769cb762€15.00€0.26matched
50capture01a1ac7c-c607-7a82-b781-36943e7b3bbe€9.00€0.19matched
51capture01a1ac7c-c99c-7202-bd73-0166a77b3358€9.00€0.19matched
52capture01a1ac7c-cda5-7430-8eae-c67d44e5b59f€24.00€0.37matched
53capture01a1ac7c-cfe7-7c82-b0d0-2aabf0a5be74€49.00€0.67matched
54capture01a1ac7c-f2e1-7455-baa9-10441d58e54a€15.00€0.26matched
55capture01a1ac7d-1877-7eb1-9508-bf939d56b856€35.00€0.50matched
56capture01a1ac7d-1c28-7485-8842-a1910ba5d353€9.00€0.19matched
57refund01a1ac7d-1f31-79e8-8a0a-1850b58f5678-€6.00€0.00matched
58refund01a1ac7d-1fdc-72fd-8cdf-9a886daa257d-€8.00€0.00matched
59capture01a1ac7d-2883-7950-9c1b-e07434d50386€9.00€0.19matched
60refund01a1ac7d-2c2f-7a6b-a26f-30a0929a9d79-€24.00€0.00matched
61capture01a1ac7d-3083-7cee-abbf-e3c2b78e3f8d€49.00€0.67matched
62capture01a1ac7d-342c-7cfc-b103-6b7a991233b6€35.00€0.50matched
63capture01a1ac7d-3c8f-7969-97ad-a44191a8c636€15.00€0.26matched
64capture01a1ac7d-3d74-7a5f-9ae3-dd2673b070d5€15.00€0.26matched
65capture01a1ac7d-3f53-742e-967a-e1a85b437bda€24.00€0.37matched
66capture01a1ac7d-634a-7751-8fd0-3fbc797de59c€49.00€0.67matched
67capture01a1ac7d-6ff1-7161-916d-4303d24c7512€15.00€0.26matched
68capture01a1ac7d-82d0-7ff9-ba9e-ca3ab843f179€35.00€0.50matched
69capture01a1ac7d-8400-7994-8b6a-c9207e30a5fc€35.00€0.50matched
70capture01a1ac7d-987c-7d71-b1d9-b6cbfed39afe€49.00€0.67matched
71capture01a1ac7d-9d38-7f83-ab8c-4dfafb0fc28c€24.00€0.37matched
72capture01a1ac7d-cfcd-7e4b-9def-cf0fc2603c67€15.00€0.26matched
73capture01a1ac7d-d8ac-7917-9d64-80c50c73a3dc€35.00€0.50matched
74capture01a1ac7d-db03-7044-bc80-afe1eb632bf7€24.00€0.37matched
75capture01a1ac7d-e1c9-795c-b582-7178562a9ea7€9.00€0.19matched
76capture01a1ac7d-f4f0-7c24-9a32-084966af2452€15.00€0.26matched
77capture01a1ac7e-0525-72b3-b7f0-b5359af13055€15.00€0.26matched
78capture01a1ac7e-19a3-7dca-81fd-f726ea6744a5€15.00€0.26matched
79capture01a1ac7e-1e8e-73a5-a546-905526effa23€24.00€0.37matched
80capture01a1ac7e-3d86-72cc-a3c1-76661d124077€9.00€0.19matched
81capture01a1ac7e-533a-77f6-813b-d81c670ac726€15.00€0.26matched
83capture01a1ac7e-6c22-7bdc-864b-0f1d5998403a€35.00€0.50matched
84capture01a1ac7e-a936-7a15-b75f-ac9d26798a43€24.00€0.37matched
85capture01a1ac7e-b259-75e8-bc43-aec19acf49c2€15.00€0.26matched
86refund01a1ac7e-c99e-749b-93ac-32fd1bdc6651-€12.00€0.00matched
87capture01a1ac7e-cdfb-792f-af58-1a0202dbbae4€35.00€0.50matched
88capture01a1ac7e-d876-777d-aca4-a53bb76b04ba€49.00€0.67matched
89capture01a1ac7e-f050-7272-8454-59771d29b74f€15.00€0.26matched
90capture01a1ac7f-068d-787c-afb3-ce30f4c9e39a€24.00€0.37matched
91capture01a1ac7f-0c92-75d5-b4b0-d1949ab2a743€9.00€0.19matched
92capture01a1ac7f-0ec0-7447-88e8-2f05ded74297€35.00€0.50matched
93capture01a1ac7f-1bcb-798c-a5b0-2434a9bced61€24.00€0.37matched
95capture01a1ac7f-2969-728c-9667-1454255d7480€35.00€0.50matched
96capture01a1ac7f-2d1f-7e6a-a9f9-cacf5a0397d1€9.00€0.19matched
97capture01a1ac7f-2fb6-7ea5-ba68-e5e8095f21da€15.00€0.26matched
98capture01a1ac7f-3adf-7661-a907-c2667143d2dd€15.00€0.26matched
99capture01a1ac7f-43a5-7d06-8a97-86965677f250€49.00€0.67matched
100capture01a1ac7f-5f95-70a8-92ba-d9b9413dc867€49.00€0.67matched
101capture01a1ac7f-6247-7fc4-a38a-08bba055e62a€9.00€0.19matched
102capture01a1ac7f-8d1c-7a0b-9155-66da59084af1€9.00€0.19matched
103capture01a1ac7f-8e08-7baa-8c1c-b50820950043€35.00€0.50matched
104capture01a1ac7f-913f-7d96-8d93-f4cf43a90eeb€35.00€0.50matched
105capture01a1ac7f-a005-7bb1-9d68-8e3f987d7203€49.00€0.67matched
106capture01a1ac7f-a46b-73eb-a1f9-4ed1da226c5e€24.00€0.37matched
107capture01a1ac7f-d285-7f1a-9759-cbba0274e105€24.00€0.37matched
108capture01a1ac7f-f417-7e49-bb57-59f7c66c352a€15.00€0.26matched
109capture01a1ac7f-fbdc-7ea7-8a4f-aa6da152e14d€9.00€0.19matched
110capture01a1ac7f-ffc6-744a-96e3-b88674ea498a€15.00€0.26matched
111capture01a1ac80-040f-7a98-a7c8-f03ca82c6c5c€15.00€0.26matched
112capture01a1ac80-131a-72d6-82ec-28eb186a1ddc€15.00€0.26matched
113capture01a1ac80-1cea-72db-ae3f-a790bc2a1878€9.00€0.19matched
114capture01a1ac80-20c6-7869-bfc8-976241577a02€24.00€0.37matched
115capture01a1ac80-2301-7f91-92a7-d61221ec5601€9.00€0.19matched
116capture01a1ac80-3c5c-70dc-ac28-83928bfcac6e€9.00€0.19matched
117capture01a1ac80-6fe8-78e7-a15f-7646d7f7121b€9.00€0.19matched
118capture01a1ac80-96a4-7c1d-9e95-4d2ddd0ded38€24.00€0.37matched
119capture01a1ac80-b30f-758c-aff5-7a2e891e07da€49.00€0.67matched
120capture01a1ac80-dc47-722e-bce8-618cbfc34bdb€49.00€0.67matched
121capture01a1ac81-098d-7e19-8ae3-b7dd7d40d4f2€24.00€0.37matched
122capture01a1ac81-1a4b-73a1-a0bc-508179ebc5e6€35.00€0.50matched
123capture01a1ac81-2f20-71bc-95ef-cb7a1540f6fb€24.00€0.37matched
124capture01a1ac81-3a24-7c3d-a4fe-ea8f500747b9€49.00€0.67matched
125capture01a1ac81-5005-79ae-9ce3-975e9a714c2b€9.00€0.19matched
126capture01a1ac81-56ab-7dbf-a435-315f4eca2801€49.00€0.67matched
127capture01a1ac81-8dd2-781a-abb0-8ee1b60c09b9€15.00€0.26matched
128capture01a1ac81-b080-7ea2-b295-c91097dab302€15.00€0.26matched
129capture01a1ac81-be29-7ab4-9c08-6599f84c8b9e€35.00€0.50matched
130capture01a1ac81-ce35-7383-8dc6-73e632d8134e€24.00€0.37matched
131capture01a1ac81-f6b4-7884-9ef2-28423e5b642a€24.00€0.37matched
132capture01a1ac81-fac2-7b97-98c7-32490b2d852c€35.00€0.50matched
133capture01a1ac82-1ea2-7f90-8003-8e8b8e7f53e0€9.00€0.19matched
134capture01a1ac82-32c9-7d37-b685-62f8aa877b14€49.00€0.67matched
135refund01a1ac82-3c44-75c7-9af7-eb27e7e0c317-€21.00€0.00matched
136capture01a1ac82-4116-712e-8af4-38db6c157fa7€9.00€0.19matched
137capture01a1ac82-4f95-7a83-8cb1-7799bf2c0a69€9.00€0.19matched