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

2 Nov, 15:30

Gross

€2,837.00

PSP fee

€44.46

Net to the bank

€2,792.54

Settlement journal

#345100

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19ce5-f8ed-7330-a89e-99a0bd02afee is already settled by stl_EUR_2989389 line 58
  • fee differencethe fee is not the contract feethe fee is 30, the contract says 26
  • missing linein the books, not in the filecapture:01a19ce8-01c6-7967-826a-ac93f28d4c46 is in no file
LineKindReferenceGrossFeeStatus
3capture01a19ce1-bef3-77f6-84b9-435ea4d1ff3d€15.00€0.30fee difference
59capture01a19ce5-f938-7e41-8ef4-263d3d880e55€15.00€0.26duplicate line
1refund01a19cdc-89b7-75e8-9f7f-315a31842861-€3.00€0.00matched
2refund01a19cdc-aeca-784f-be79-3a0ae1e546f5-€14.00€0.00matched
4capture01a19ce1-cfcb-749d-9d6b-267028e50d03€49.00€0.67matched
5capture01a19ce1-d09a-7c14-b9ef-4313626879df€35.00€0.50matched
6capture01a19ce2-04ba-7f2c-bd67-36957177a002€15.00€0.26matched
7capture01a19ce2-1658-7a4a-8c86-bce7a6535e1f€35.00€0.50matched
8capture01a19ce2-1d8e-7dc8-a497-abd3b11a8c58€9.00€0.19matched
9capture01a19ce2-23b0-752d-b72d-9f76e25c4986€35.00€0.50matched
10capture01a19ce2-50d2-76fd-ac5a-de58aa4ad17a€15.00€0.26matched
11capture01a19ce2-5a3d-76ca-8d9f-d2e3a59c362a€15.00€0.26matched
12refund01a19ce2-5adf-7906-b781-f0ba376a610a-€9.00€0.00matched
13capture01a19ce2-7643-767b-8628-69af924e54d7€35.00€0.50matched
14capture01a19ce2-7eb1-7c17-841c-71e08674da47€49.00€0.67matched
15capture01a19ce2-d117-7330-99f8-1cf520e488ed€35.00€0.50matched
16capture01a19ce2-ddec-7986-beb0-757a246978fe€49.00€0.67matched
17capture01a19ce2-f266-771c-ad26-3eab505b6452€24.00€0.37matched
18capture01a19ce3-03d6-7d06-b665-2111a7a39dbf€24.00€0.37matched
19capture01a19ce3-2a3c-7d9b-a6ac-d483e5098037€15.00€0.26matched
20capture01a19ce3-41c3-7aa3-aff3-04ccaa4e34ea€9.00€0.19matched
21capture01a19ce3-6c64-7819-a37b-8891d144d738€24.00€0.37matched
22capture01a19ce3-7150-7a76-953d-7b2658821a0e€24.00€0.37matched
23capture01a19ce3-72d1-7ca7-9716-9e24a4cddc2d€15.00€0.26matched
24capture01a19ce3-a23e-744c-a2d8-ec910e9e6f37€24.00€0.37matched
25capture01a19ce3-b474-7b9d-bea3-b55f92fbfb5c€35.00€0.50matched
26capture01a19ce3-cd5f-768b-bee1-dcf110fc1d11€35.00€0.50matched
27capture01a19ce3-d63d-72dc-9aa0-8a6014d0caee€24.00€0.37matched
28capture01a19ce4-07d2-740a-9ae1-22877afb0b8a€9.00€0.19matched
29capture01a19ce4-1f56-70d3-b7da-0eb5b38540c5€24.00€0.37matched
30capture01a19ce4-2d5c-759f-8dd6-b72ba208f853€35.00€0.50matched
31capture01a19ce4-4f68-72e7-83aa-071c10e2d145€49.00€0.67matched
32capture01a19ce4-5a10-78e1-a6db-30cde6794d4a€15.00€0.26matched
33capture01a19ce4-5d15-773d-8ba1-412c452c218a€9.00€0.19matched
34capture01a19ce4-63b8-7401-905c-c58de450606b€9.00€0.19matched
35capture01a19ce4-6650-786c-9cf9-262dc841bd7a€24.00€0.37matched
36capture01a19ce4-78e9-79f1-ac11-215d5f67c9da€9.00€0.19matched
37capture01a19ce4-7cc4-744f-bf97-01c3a92f0ef2€15.00€0.26matched
38capture01a19ce4-811a-7856-9e2f-a1e6aae885ea€24.00€0.37matched
39capture01a19ce4-9185-78ed-b76a-1a502af9db11€15.00€0.26matched
40refund01a19ce4-9891-75c5-ae80-26e219b38443-€2.00€0.00matched
41capture01a19ce4-9971-7c76-991d-538cc2120d5b€24.00€0.37matched
42capture01a19ce4-a37a-7e3f-a263-7583e0da765c€15.00€0.26matched
43capture01a19ce4-b584-74b4-9089-1dd4fb6705c7€35.00€0.50matched
44capture01a19ce4-b78e-7fc6-bd77-a57a48632493€24.00€0.37matched
45refund01a19ce4-bc2e-7381-9a4c-7e7add60caf5-€10.00€0.00matched
46capture01a19ce5-27a7-750f-be3a-3f6c2e9dbf22€24.00€0.37matched
47capture01a19ce5-281b-75fd-84f3-62ff63a2467b€15.00€0.26matched
48capture01a19ce5-36fb-711b-8ca7-82cc8acde842€9.00€0.19matched
49capture01a19ce5-5b23-7fc0-9c38-443ac213f5a2€24.00€0.37matched
50capture01a19ce5-7adf-75c7-8dda-237cabdba362€35.00€0.50matched
51capture01a19ce5-8e50-7d72-a621-2c64b4afa428€15.00€0.26matched
52capture01a19ce5-9048-7d49-b3fc-dae4deb8ae65€15.00€0.26matched
53capture01a19ce5-ae35-7830-a253-6e6301433783€24.00€0.37matched
54capture01a19ce5-c277-72dc-ae6e-a105c760c7bc€24.00€0.37matched
55capture01a19ce5-d1f6-7140-acc5-093e9ac9c585€49.00€0.67matched
56capture01a19ce5-dff5-7890-9c22-3419416d8004€9.00€0.19matched
57capture01a19ce5-ef32-762f-919c-b1f0f97f318a€24.00€0.37matched
58capture01a19ce5-f938-7e41-8ef4-263d3d880e55€15.00€0.26matched
60capture01a19ce5-fc36-7ef1-86d9-fc7e21292b3e€24.00€0.37matched
61capture01a19ce6-06ca-763b-b3f9-66d7547f4e1c€9.00€0.19matched
62capture01a19ce6-20c8-7876-a3a1-205d075b3806€49.00€0.67matched
63capture01a19ce6-4276-7a45-a504-80de9cbeca67€24.00€0.37matched
64refund01a19ce6-4da7-7114-ae06-e1b7d46bf075-€3.00€0.00matched
65capture01a19ce6-503d-7182-aa89-2660182e2c4c€24.00€0.37matched
66capture01a19ce6-69b8-79c6-ae7f-940e62d13b02€49.00€0.67matched
67capture01a19ce6-6a63-70e6-bb30-214f518c7e42€35.00€0.50matched
68capture01a19ce6-72eb-7fa6-ad11-d177b486d42a€35.00€0.50matched
69capture01a19ce6-831c-71cc-955a-a71a1c226ceb€35.00€0.50matched
70capture01a19ce6-a942-78f2-89e8-9a1a06bfd43a€24.00€0.37matched
71capture01a19ce6-afaf-7ffe-91af-02d4ea266347€9.00€0.19matched
72capture01a19ce6-b10a-7ccc-802d-15cbb5609ecb€24.00€0.37matched
73capture01a19ce6-c68b-7f24-aa8c-6060d1c243d2€35.00€0.50matched
74capture01a19ce6-c958-7a32-a221-bbeef1fd05d6€35.00€0.50matched
75capture01a19ce6-cc58-79c4-ae63-57c1c667c962€35.00€0.50matched
76refund01a19ce6-db7a-750d-a499-5dffaf5d566b-€25.00€0.00matched
77capture01a19ce6-f16e-793c-8d65-8c54fd5cf60b€35.00€0.50matched
78capture01a19ce6-f38e-716b-a063-43062dd96dbe€35.00€0.50matched
79capture01a19ce7-1d20-70f1-8dfd-210806db54c8€24.00€0.37matched
80capture01a19ce7-3251-7474-9efa-3dc0c155157e€9.00€0.19matched
81capture01a19ce7-42c1-78e1-a868-62480d276dc9€35.00€0.50matched
82capture01a19ce7-52a6-7fcb-b850-c9553f785787€24.00€0.37matched
83capture01a19ce7-6179-7832-bbd3-81b8a226cfa4€15.00€0.26matched
84capture01a19ce7-62e0-76b1-a8c1-5c36bcfa13f3€24.00€0.37matched
85capture01a19ce7-71d7-7298-b6a9-d67f86efa8ae€24.00€0.37matched
86capture01a19ce7-828f-74e8-9eb5-5353aa9c0cf5€9.00€0.19matched
87capture01a19ce7-cdf7-7f9f-967a-caa485b413a9€9.00€0.19matched
88capture01a19ce8-07e8-7ca8-bac3-b4f1663213d6€24.00€0.37matched
89capture01a19ce8-2aec-7c81-a1b5-5ea94fc2e5bb€9.00€0.19matched
90capture01a19ce8-3315-75d3-acd3-e990b5c76229€15.00€0.26matched
91capture01a19ce8-5a42-75c9-88a5-1ec93bb8722a€49.00€0.67matched
92capture01a19ce8-7014-73b4-9214-ef95a932b923€9.00€0.19matched
93capture01a19ce8-70b7-78f5-8a7f-6c0e469d9409€24.00€0.37matched
94capture01a19ce8-9cbc-7fce-9b7a-b9a495378612€24.00€0.37matched
95capture01a19ce8-b124-756e-bdd8-b42bec98bfa1€24.00€0.37matched
96capture01a19ce8-b630-79ec-ab14-5d962aef2080€35.00€0.50matched
97capture01a19ce8-bac7-7995-b75a-4f477ba63151€35.00€0.50matched
98capture01a19ce8-c387-75b6-98c4-2d3137459e4b€15.00€0.26matched
99capture01a19ce8-cd9e-71de-899f-2ce1ef579d74€24.00€0.37matched
100capture01a19ce8-f308-7781-8690-485bf40e88a8€49.00€0.67matched
101capture01a19ce8-f805-7c04-8ff8-8692903c6fd3€9.00€0.19matched
102capture01a19ce9-2916-71f3-82aa-9686e9187039€49.00€0.67matched
103capture01a19ce9-38aa-7645-b19b-0f8ff69c5daf€9.00€0.19matched
104capture01a19ce9-4203-70af-9ba9-066b1bebb866€24.00€0.37matched
105capture01a19ce9-4bf8-704c-9d7a-504f6604e82f€9.00€0.19matched
106capture01a19ce9-5934-75d0-b86d-10e172d64cea€9.00€0.19matched
107capture01a19ce9-84e5-7688-80ab-3aa90f2967df€35.00€0.50matched
108capture01a19ce9-99ab-721d-ab59-5ffb4b71ac06€35.00€0.50matched
109capture01a19ce9-a469-79d0-96e8-e904612393a3€15.00€0.26matched
110capture01a19ce9-d5db-7036-81ae-08f3a19de97b€15.00€0.26matched
111capture01a19ce9-e7ca-7725-a017-38c498b300af€9.00€0.19matched
112capture01a19ce9-f545-792a-966f-6814c670d2a5€49.00€0.67matched
113capture01a19ce9-ed22-760e-910c-db5fbf64a5a0€9.00€0.19matched
114capture01a19cea-0da8-725a-98a2-7339ef7d8a55€9.00€0.19matched
115capture01a19cea-11da-799b-aed7-f8a6ada94529€35.00€0.50matched
116capture01a19cea-1a82-7eb8-89a3-d10fbeb1cdc9€24.00€0.37matched
117capture01a19cea-1c23-7913-807a-458282eaba56€15.00€0.26matched
118capture01a19cea-23a6-70fe-b2f7-2ad8d8359827€24.00€0.37matched
119capture01a19cea-3a2e-7e69-b821-3ae65fe8be04€9.00€0.19matched
120capture01a19cea-3b0c-7cf1-bd96-2ef51450ba88€24.00€0.37matched
121capture01a19cea-5958-78b4-a832-bc53fffb9e63€49.00€0.67matched
122capture01a19cea-a46a-7800-9a50-a372e79cbb10€49.00€0.67matched
123capture01a19cea-abab-7994-b07c-fc77fa8cf7ff€24.00€0.37matched
124capture01a19cea-c29e-7367-9f1c-b3bc2ff10056€49.00€0.67matched
125capture01a19cea-cec5-7bff-80ba-ba1fd5564f5a€15.00€0.26matched