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:50

Gross

€2,913.00

PSP fee

€44.25

Net to the bank

€2,868.75

Settlement journal

#400949

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aca1-7d88-75ac-965a-ba9a7e43c095 is already settled by stl_EUR_2989829 line 43
  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
LineKindReferenceGrossFeeStatus
44capture01a1aca1-7da3-71c8-ad50-58b7efcb64fb€35.00€0.50duplicate line
57capture01a1aca2-4ef5-7b9f-8320-3371e87a5255€35.00€0.53fee difference
1capture01a1ac9a-ad8a-7538-a439-fee36d9beba7€9.00€0.19matched
2capture01a1ac9a-ea7b-701b-8e27-b442499bf7d1€9.00€0.19matched
3refund01a1ac9d-4cb0-736c-aefe-f960d6f0b7ec-€22.00€0.00matched
4capture01a1ac9e-0c4e-7ed8-9749-e3e34f7a4930€35.00€0.50matched
5capture01a1ac9e-19d6-73bd-9fc7-1388122cdabd€9.00€0.19matched
6capture01a1ac9e-21c4-7630-b5e9-b329f1541ede€49.00€0.67matched
7capture01a1ac9e-28f6-7dd2-8919-397194d790ed€35.00€0.50matched
8capture01a1ac9e-44ad-7562-92a4-102404a9bf31€35.00€0.50matched
9capture01a1ac9e-462c-780f-a556-b34aa370ce7a€49.00€0.67matched
10capture01a1ac9e-4db2-7545-86d7-a2fdd87e0a59€49.00€0.67matched
11capture01a1ac9e-5bb2-73fd-a8d2-755e06bb1f7d€9.00€0.19matched
12capture01a1ac9e-8c18-7f55-b6a3-4417d11acaee€24.00€0.37matched
13capture01a1ac9e-a252-7c09-be86-9153d4afe69d€24.00€0.37matched
14capture01a1ac9e-ac99-77ac-87ef-ea5102399517€15.00€0.26matched
15capture01a1ac9e-b659-73de-ae59-0dd39f5cc8d5€24.00€0.37matched
16capture01a1ac9e-bee2-7f9d-a689-0d920b3c7361€15.00€0.26matched
17capture01a1ac9e-e2aa-7d27-98fa-c7a67dfd07e9€15.00€0.26matched
18capture01a1ac9e-e9f2-7e40-9123-eed0549cad79€35.00€0.50matched
19capture01a1ac9f-3160-72d5-9048-478fedfa928a€15.00€0.26matched
20capture01a1ac9f-3a39-7949-9bd6-17a4506c0632€49.00€0.67matched
21capture01a1ac9f-3d3f-720a-b303-5d58ca5acf43€24.00€0.37matched
22capture01a1ac9f-4fc8-7525-9a69-85427e15c7bd€15.00€0.26matched
23capture01a1ac9f-53e6-7403-b568-532994d8e8db€49.00€0.67matched
24capture01a1ac9f-6eba-7616-bb63-99a9b9dfc3a5€24.00€0.37matched
25capture01a1ac9f-71fd-70f6-a665-8cec91488d11€9.00€0.19matched
26capture01a1ac9f-744d-7dcd-a95a-b488c5fd9e4f€9.00€0.19matched
27capture01a1ac9f-96ab-719d-b243-7a84b80af7a5€49.00€0.67matched
28capture01a1ac9f-beb7-7782-a0eb-edcd6566ea72€24.00€0.37matched
29capture01a1ac9f-d788-778a-a077-b656c75fd085€35.00€0.50matched
30capture01a1ac9f-e99a-7241-b0f9-d4dd72d82517€15.00€0.26matched
31capture01a1ac9f-f2b3-7aab-903c-11fb064ee77b€9.00€0.19matched
32capture01a1aca0-220d-7e56-a07d-d0f573df360b€9.00€0.19matched
33capture01a1aca0-249a-7f4e-b3f3-a62a4618a377€35.00€0.50matched
34capture01a1aca0-4c3f-7815-b51f-07551ba32d49€49.00€0.67matched
35refund01a1aca0-6724-7301-a85f-254d02ed74a8-€6.00€0.00matched
36capture01a1aca0-8856-7a0e-ab05-198fdd5d746a€49.00€0.67matched
37capture01a1aca0-a9dd-711e-9992-879eec1c4d0d€49.00€0.67matched
38capture01a1aca0-bd60-7c28-ba11-819f72d8cc8f€24.00€0.37matched
39capture01a1aca0-ebeb-762e-94f9-e18871521e14€24.00€0.37matched
40capture01a1aca1-25bd-70dc-a7d2-a9865eb2c2a3€24.00€0.37matched
41capture01a1aca1-3a74-7c50-add3-1dea35788db7€49.00€0.67matched
42capture01a1aca1-4c9a-7a0d-a818-0c7c306ba3b4€35.00€0.50matched
43capture01a1aca1-7da3-71c8-ad50-58b7efcb64fb€35.00€0.50matched
45capture01a1aca1-975b-7d34-8e1a-e10f9a401d6e€49.00€0.67matched
46capture01a1aca1-a5e8-74f5-98bb-fb29c9c7376f€15.00€0.26matched
47capture01a1aca1-a715-7e34-a94d-f41a58169799€49.00€0.67matched
48capture01a1aca1-b4dd-72c0-b783-bdf95cef0dd9€15.00€0.26matched
49capture01a1aca1-b895-76b5-9f5d-527ce72a4bb1€24.00€0.37matched
50capture01a1aca1-da83-77e3-bac7-997aac56fcad€24.00€0.37matched
51capture01a1aca1-ea93-7b95-801e-e2c06a8de1d4€35.00€0.50matched
52capture01a1aca1-f27c-7668-a3b7-3e98b3420fc5€9.00€0.19matched
53capture01a1aca2-200a-7884-8590-48e899861584€49.00€0.67matched
54capture01a1aca2-3317-72b2-b9f6-c9a60cc0a377€35.00€0.50matched
55capture01a1aca2-4742-7d4b-adf3-53a0776ec1c6€9.00€0.19matched
56capture01a1aca2-48ad-7ea7-ad8b-4bc423002159€9.00€0.19matched
58capture01a1aca2-5278-7bf3-a273-3d99543a20e0€9.00€0.19matched
59capture01a1aca2-5587-7500-880c-ef6e2f79b5bd€35.00€0.50matched
60capture01a1aca2-5e71-724d-8968-6bfd3f515bd5€24.00€0.37matched
61capture01a1aca2-6564-752c-8de9-b8c6f1e90b86€9.00€0.19matched
62capture01a1aca2-6ef2-7413-8894-1489a338ec47€24.00€0.37matched
63capture01a1aca2-721d-79a5-ba10-05abe726852f€49.00€0.67matched
64refund01a1aca2-87c9-7185-8aef-d5a0f3a1a00d-€7.00€0.00matched
65capture01a1aca2-8dd0-7a1d-be09-ceb89cbc5662€49.00€0.67matched
66capture01a1aca2-9de5-727e-95cb-a5b0825c0323€35.00€0.50matched
67capture01a1aca2-c298-77df-ace1-96c71287e216€24.00€0.37matched
68capture01a1aca2-d286-71fe-bf8b-67e9a3b96fcd€49.00€0.67matched
69capture01a1aca3-10c8-76fb-a417-1cea9f2ebf0d€9.00€0.19matched
70capture01a1aca3-14bb-73ce-91b8-f36530468fff€35.00€0.50matched
71capture01a1aca3-344a-7978-8e58-8c3898cc7be2€24.00€0.37matched
72capture01a1aca3-59be-7917-8b4b-60c4e668921f€9.00€0.19matched
73capture01a1aca3-5f02-70ca-907f-be9a29427994€15.00€0.26matched
74capture01a1aca3-6033-7a9c-965f-cca0dbd11ab4€15.00€0.26matched
75capture01a1aca3-613a-7cc8-97f9-6b5f94d39acf€35.00€0.50matched
76capture01a1aca3-a228-7a44-99de-5db57cacba33€9.00€0.19matched
77capture01a1aca3-af02-7e5e-962b-c48cbc52bbae€9.00€0.19matched
78capture01a1aca3-bb49-7df5-831c-d77a933b6310€15.00€0.26matched
79capture01a1aca3-bec8-7488-8b71-e4fcd5d7cd00€35.00€0.50matched
80capture01a1aca3-ca1a-7cb1-9484-cfae6721b587€9.00€0.19matched
81capture01a1aca3-dccc-7c06-be28-a0efc759d4c3€35.00€0.50matched
82capture01a1aca3-e85b-78fb-906d-0aacdbeeb212€24.00€0.37matched
83capture01a1aca3-ed58-7665-83dc-6afe6cdf0f4e€49.00€0.67matched
84capture01a1aca3-fcf1-794b-adb4-a11ee36ecb16€49.00€0.67matched
85refund01a1aca4-0143-7253-ad73-37730fd2d5ea-€6.00€0.00matched
86capture01a1aca4-20ce-7d73-87f8-14ceb90ce455€49.00€0.67matched
87capture01a1aca4-381f-7fcf-b18f-69d72ff5d67a€15.00€0.26matched
88capture01a1aca4-420e-7be8-9ef3-f2d3a2fb6969€9.00€0.19matched
89capture01a1aca4-7ab7-7284-968f-c95d4e05bc04€15.00€0.26matched
90capture01a1aca4-ad36-7fcf-9700-0ac454c5a8db€15.00€0.26matched
91capture01a1aca4-ba5f-7089-9c60-d2793309fab8€15.00€0.26matched
92capture01a1aca4-c382-7f7d-9053-6ccf528d4bdc€15.00€0.26matched
93capture01a1aca4-f147-7f41-b06b-7b8fecc7c12e€35.00€0.50matched
94capture01a1aca4-f5e2-7d2b-b6dd-151297d66332€24.00€0.37matched
95capture01a1aca5-134a-7829-902a-9e714cbb19e7€9.00€0.19matched
96capture01a1aca5-256e-7a8c-baf6-52dd064e9ac5€35.00€0.50matched
97capture01a1aca5-4f22-7bf7-8517-4bf4d60f945c€24.00€0.37matched
98capture01a1aca5-5854-7668-9f07-c7d0d6bed1f8€15.00€0.26matched
99capture01a1aca5-8ee4-7e16-aa25-618e6b80c629€49.00€0.67matched
100capture01a1aca5-9f72-790f-b483-ae1758f534f5€49.00€0.67matched
101capture01a1aca6-1879-7f07-9551-bc27b5cfbfe4€15.00€0.26matched
102capture01a1aca6-2bfe-777a-8804-401792e0d872€24.00€0.37matched
103capture01a1aca6-3768-7cc3-97b7-042dfc3a8268€35.00€0.50matched
104capture01a1aca6-3a16-730a-bd4a-15bef77f76fa€24.00€0.37matched
105capture01a1aca6-449e-79e1-8169-c213c1ac3c86€24.00€0.37matched
106capture01a1aca6-690c-7c24-80b8-18e66e227179€49.00€0.67matched
107capture01a1aca6-92cb-7336-9807-2fcd04e2901b€9.00€0.19matched
108capture01a1aca6-bc19-7db3-b584-3b89a23e217b€24.00€0.37matched
109capture01a1aca6-e9f5-71dc-89eb-4d72ee2c557f€49.00€0.67matched
110capture01a1aca6-fa54-7626-b43a-f9ed673660b5€35.00€0.50matched
111capture01a1aca7-199a-7449-9497-9966597819bf€35.00€0.50matched
112capture01a1aca7-26f0-7aae-aabc-0d1cee8f9ff0€35.00€0.50matched