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, 04:20

Gross

€2,988.00

PSP fee

€47.74

Net to the bank

€2,940.26

Settlement journal

#391464

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a9f4-2266-7bfd-9029-c49dbe20d862 is already settled by stl_EUR_2989754 line 71
  • missing linein the books, not in the filecapture:01a1a9f7-ca87-7bc2-8b15-aa2c8c0a22a0 is in no file
LineKindReferenceGrossFeeStatus
72capture01a1a9f4-2294-7c8b-b956-1f0ab33c6107€9.00€0.19duplicate line
1capture01a1a9e7-d85b-7fa5-acf3-d997eb7ee72a€24.00€0.37matched
2capture01a1a9ee-2d80-73f6-8c61-e792e2de5c0a€49.00€0.67matched
3capture01a1a9ef-7a9c-7796-997a-948a8ca50234€9.00€0.19matched
4capture01a1a9ef-8884-7201-b330-05cec4c8f3ff€49.00€0.67matched
5capture01a1a9ef-a065-75e4-8809-0aa9c9d142a9€9.00€0.19matched
6capture01a1a9ef-b3a2-7de7-8936-dc049d665772€49.00€0.67matched
7capture01a1a9ef-eef1-70f7-89fb-f38a97f5ef02€9.00€0.19matched
8capture01a1a9f0-0df1-7a15-a497-d1e1128f462a€24.00€0.37matched
9capture01a1a9f0-2313-7401-a310-d5fbd872f2c1€49.00€0.67matched
10capture01a1a9f0-4478-7d4b-8ac6-9acce77e1b4f€49.00€0.67matched
11capture01a1a9f0-53aa-75c0-aa2e-20d2ae7536b7€15.00€0.26matched
12capture01a1a9f0-5bb7-7054-87f5-cae8e071aa7c€49.00€0.67matched
13capture01a1a9f0-b4c8-7241-b2d9-343e7311e7a8€9.00€0.19matched
14capture01a1a9f0-d373-7526-8c21-c434bf1260f9€35.00€0.50matched
15capture01a1a9f0-f8d7-7dda-b57e-4804e0743c46€9.00€0.19matched
16capture01a1a9f1-10d5-7bea-8d7a-e5a4301849ff€49.00€0.67matched
17capture01a1a9f1-1a47-7867-853f-d3a5bda3580f€24.00€0.37matched
18capture01a1a9f1-21a8-71cd-8259-446dbaa1a2ac€49.00€0.67matched
19refund01a1a9f1-26e6-705b-bb26-d15da4a2de38-€6.00€0.00matched
20capture01a1a9f1-3983-7180-a975-87bf2ab77b84€49.00€0.67matched
21capture01a1a9f1-4d2a-7fda-9cee-6757018af2f7€9.00€0.19matched
22capture01a1a9f1-59bb-7246-9396-f9b83edd8458€35.00€0.50matched
23refund01a1a9f1-6482-79f3-819d-a30ca226b350-€9.00€0.00matched
24capture01a1a9f1-6dfd-7e64-90b1-e1d6a1285935€35.00€0.50matched
25capture01a1a9f1-7b4b-7696-a32d-68cad670ddc6€35.00€0.50matched
26refund01a1a9f1-8637-77c2-b22f-8920785f6f8e-€35.00€0.00matched
27capture01a1a9f1-b685-7d71-b9ef-2b639de7bf5c€35.00€0.50matched
28capture01a1a9f1-c244-7f97-8261-0d81081b6a41€24.00€0.37matched
29capture01a1a9f1-c422-74a4-9508-1d46c2d86f98€35.00€0.50matched
30capture01a1a9f1-c42f-7204-be3b-10e31abfd2ab€15.00€0.26matched
31capture01a1a9f1-cfbb-7a35-9b51-f75119776b37€9.00€0.19matched
32capture01a1a9f1-dd96-7fbd-a7dc-589412a92595€35.00€0.50matched
33capture01a1a9f1-fa8e-7508-ab98-667c2ea6daed€24.00€0.37matched
34capture01a1a9f2-37ce-7d76-98ee-253bd6fbc69c€9.00€0.19matched
35capture01a1a9f2-3ee5-7f58-bc95-dca045e55378€9.00€0.19matched
36capture01a1a9f2-5cff-7e3e-82e7-a3cbb8886537€49.00€0.67matched
37capture01a1a9f2-5da7-7e60-9419-20a0205129ed€35.00€0.50matched
38refund01a1a9f2-5f0a-7bdc-8eca-b7427045ba5a-€3.00€0.00matched
39capture01a1a9f2-6ab2-7d5c-9a87-1373208c85f4€49.00€0.67matched
40capture01a1a9f2-7d6b-72ec-a9a1-7e65e40e659d€15.00€0.26matched
41capture01a1a9f2-ad53-7a7b-aa8f-e08adde88ee1€24.00€0.37matched
42capture01a1a9f2-b159-7580-ab24-eef6a70e2b50€24.00€0.37matched
43capture01a1a9f2-bf02-78d2-b7d7-8d6daddc4c1a€49.00€0.67matched
44capture01a1a9f2-c9ab-72c2-b79c-f22ebf1a53ac€35.00€0.50matched
45capture01a1a9f2-e23b-792e-97de-94457a6bdcd8€9.00€0.19matched
46capture01a1a9f2-f089-7e15-aad1-1f0f541e4a48€35.00€0.50matched
47capture01a1a9f2-e6d9-7273-90f5-d46ca468c0aa€35.00€0.50matched
48capture01a1a9f3-0609-72f8-9b96-fb6cd2200b06€49.00€0.67matched
49capture01a1a9f3-290d-750d-bf6f-bfa58aeb2af7€35.00€0.50matched
50capture01a1a9f3-2e4c-7da0-b227-6f07199aad34€15.00€0.26matched
51refund01a1a9f3-3557-787f-bad0-f63d6093055b-€19.00€0.00matched
52capture01a1a9f3-3132-74e9-8b02-57a8e1bab660€15.00€0.26matched
53capture01a1a9f3-5719-7a01-8c8f-a2030e41d314€15.00€0.26matched
54capture01a1a9f3-57eb-7ce0-a06f-c55d306e3f53€9.00€0.19matched
55capture01a1a9f3-5b6a-7e23-8b16-129113489746€49.00€0.67matched
56capture01a1a9f3-5d46-77a2-bec4-e407fcfc4eba€15.00€0.26matched
57capture01a1a9f3-69fd-7988-aeb3-e66adefa20c5€49.00€0.67matched
58capture01a1a9f3-7606-7123-be0f-44e540a0ee7a€24.00€0.37matched
59capture01a1a9f3-8e8a-7eed-8a57-c75541be68e3€35.00€0.50matched
60capture01a1a9f3-96ec-7d96-b2b5-6b7bbeec3a1d€15.00€0.26matched
61capture01a1a9f3-a011-75e6-be35-3be07cbe32bc€35.00€0.50matched
62capture01a1a9f3-ac0f-7636-93e4-fc857eb99cc1€35.00€0.50matched
63capture01a1a9f3-d2da-7bc9-b3d3-9e0237abba82€35.00€0.50matched
64refund01a1a9f3-d4ce-767b-867e-04dbb9c9aece-€16.00€0.00matched
65capture01a1a9f3-d631-7611-8310-99a0186b960e€24.00€0.37matched
66capture01a1a9f3-ecfe-756e-851a-d6ff46d61d4c€24.00€0.37matched
67capture01a1a9f4-0158-7ddc-baca-26a6902f05dd€9.00€0.19matched
68capture01a1a9f4-0ec9-75a2-8843-f52c3f90534a€49.00€0.67matched
69capture01a1a9f4-2080-7ed6-a2ca-252cb4aaa6d4€9.00€0.19matched
70capture01a1a9f4-2089-72b9-a20c-b26ad271e636€9.00€0.19matched
71capture01a1a9f4-2294-7c8b-b956-1f0ab33c6107€9.00€0.19matched
73capture01a1a9f4-5230-73cb-a607-bba7a75b1d3a€49.00€0.67matched
74capture01a1a9f4-6084-7000-b7e2-d13d57a06e83€15.00€0.26matched
75capture01a1a9f4-8b88-72b4-9dff-6f0c2576ed14€15.00€0.26matched
76refund01a1a9f4-9893-7278-b25d-1eaba44170c7-€6.00€0.00matched
77capture01a1a9f4-afeb-75de-84dc-8d80e1dc774b€15.00€0.26matched
78capture01a1a9f4-d78d-7794-ae31-2105d999007a€24.00€0.37matched
79capture01a1a9f5-0050-743d-966a-6afaf0697408€49.00€0.67matched
80capture01a1a9f5-293f-70c0-9bfa-068d4b839a7f€35.00€0.50matched
81capture01a1a9f5-2a96-7d03-8144-0138d1d2e317€24.00€0.37matched
82capture01a1a9f5-2e11-75f9-b8e5-e267c56d4836€24.00€0.37matched
83capture01a1a9f5-2ebd-7c61-b234-cdf178cd6861€15.00€0.26matched
84capture01a1a9f5-4968-7fa2-8234-6a081af5132d€9.00€0.19matched
85capture01a1a9f5-91a7-7761-9bc9-80e592232d35€35.00€0.50matched
86capture01a1a9f5-9a82-761a-b39f-61a776f369d6€9.00€0.19matched
87capture01a1a9f5-cb7d-7452-a04a-2feb993b4a9c€9.00€0.19matched
88capture01a1a9f6-02f0-72fb-a498-a0de5c36e003€9.00€0.19matched
89capture01a1a9f6-0dd3-75f2-bc19-39d0071c9fe0€9.00€0.19matched
90capture01a1a9f6-11e1-7cd4-a6c6-86f134d10c2c€24.00€0.37matched
91capture01a1a9f6-19a8-7434-8ef5-b42f968f2fed€49.00€0.67matched
92capture01a1a9f6-1d63-7aaa-8594-2f8e386b86b2€15.00€0.26matched
93capture01a1a9f6-1dce-7c78-822b-7109f6b47637€49.00€0.67matched
94capture01a1a9f6-1e4c-7c97-b346-2b78e5e67a95€15.00€0.26matched
95capture01a1a9f6-29f1-7f1c-a8ad-01a19179422f€24.00€0.37matched
96capture01a1a9f6-3df9-77bc-8d0d-35672fabafd9€9.00€0.19matched
97capture01a1a9f6-5634-7781-8ea4-ef8b2d468d4c€9.00€0.19matched
98capture01a1a9f6-889a-7b30-847d-03927722cba4€9.00€0.19matched
99capture01a1a9f6-8876-77f3-8d8b-45440320b6d8€35.00€0.50matched
100capture01a1a9f6-9193-7b94-9ae9-21034eaf38d3€35.00€0.50matched
101capture01a1a9f6-cf3b-7113-8273-16a0f4ed8c7c€49.00€0.67matched
102capture01a1a9f6-e875-76e7-9b61-a94cccc0fdc0€24.00€0.37matched
103capture01a1a9f6-fe64-7d40-88bc-3575e2a06aea€49.00€0.67matched
104capture01a1a9f7-1c56-75ec-ad92-3a12fafa5a14€15.00€0.26matched
105capture01a1a9f7-43b7-7d01-aad8-b2964a8bb6ac€15.00€0.26matched
106capture01a1a9f7-5afb-75c1-8c65-742c142fcce4€15.00€0.26matched
107capture01a1a9f7-6c60-75fa-b712-964a25c1ba5f€24.00€0.37matched
108capture01a1a9f7-880e-7dbc-ae1e-41db1a5780c4€24.00€0.37matched
109capture01a1a9f7-8adc-7fca-8d37-7b91ab5dbecf€24.00€0.37matched
110capture01a1a9f7-8f8c-7ce9-87a9-cf174e172c9b€9.00€0.19matched
111capture01a1a9f7-9a5e-7e45-998a-8312eb1ca7ba€49.00€0.67matched
112refund01a1a9f7-9fff-7f00-9e3f-2a64468c838d-€12.00€0.00matched
113capture01a1a9f7-cb43-7a0f-8066-1ff262889d69€9.00€0.19matched
114capture01a1a9f7-d755-7511-b67e-b8f44f421d9f€24.00€0.37matched
115capture01a1a9f7-d83e-7fa9-bd64-af3ffe2a8918€35.00€0.50matched
116capture01a1a9f7-d89a-71b2-978f-9d473ced32ca€35.00€0.50matched
117capture01a1a9f7-de46-7ea0-9d2d-54198482cee2€24.00€0.37matched
118capture01a1a9f7-e425-7e73-bf6e-f7c0eab2f22c€49.00€0.67matched
119capture01a1a9f7-efb9-774b-9fd5-3c9b021d8cb0€24.00€0.37matched
120refund01a1a9f8-0940-7fa5-ac6a-ac51844e7149-€29.00€0.00matched
121capture01a1a9f8-142c-73a3-ba2b-a0768978a695€9.00€0.19matched
122refund01a1a9f8-280c-7d2e-bac2-819b2b144ca2-€11.00€0.00matched
123refund01a1a9f8-3cbf-7521-a0dc-29f52285823a-€38.00€0.00matched
124capture01a1a9f8-3fb4-769a-b1e1-0298b307e788€49.00€0.67matched
125capture01a1a9f8-4492-75f1-8363-6cf2eea8851a€24.00€0.37matched
126capture01a1a9f8-492d-72df-b318-dd2b9e43666e€24.00€0.37matched
127capture01a1a9f8-4caa-79ff-823a-d6140880d992€9.00€0.19matched
128capture01a1a9f8-50cd-705d-ac66-a13e9526d0c6€24.00€0.37matched
129capture01a1a9f8-5c36-7948-a7de-ab06fc886a54€35.00€0.50matched
130capture01a1a9f8-68a8-76bd-a148-7fb5154e323b€35.00€0.50matched