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

Gross

€2,610.00

PSP fee

€40.11

Net to the bank

€2,569.89

Settlement journal

#403910

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
  • missing linein the books, not in the filecapture:01a1ad75-d4a6-7fac-9f0f-c25819c0f84e is in no file
LineKindReferenceGrossFeeStatus
62capture01a1ad75-8029-7b89-a899-e7eb1a044638€35.00€0.51fee difference
1capture01a1ad6b-c2cc-7c93-8a4d-87acdb501f3d€49.00€0.67matched
2refund01a1ad6e-2723-7f2e-8fc1-08bdcff13d13-€7.00€0.00matched
3refund01a1ad70-a618-7168-9dee-bd5ba35fd8fa-€6.00€0.00matched
4capture01a1ad70-eeaa-7c44-84d4-154bcf23946a€15.00€0.26matched
5capture01a1ad70-fa82-7bca-a752-d42d7a27d327€35.00€0.50matched
6capture01a1ad71-2812-7830-9265-6156117f2a4e€9.00€0.19matched
7capture01a1ad71-45b0-7336-b3b7-d9578106e235€35.00€0.50matched
8capture01a1ad71-4f3d-7886-8a21-233203611b06€24.00€0.37matched
9capture01a1ad71-5aaa-7fc2-9a54-956696db9cc9€9.00€0.19matched
10capture01a1ad71-6d69-73ff-8a0f-8ed46e174a51€9.00€0.19matched
11capture01a1ad71-6e80-72ac-a332-150c802d0656€49.00€0.67matched
12capture01a1ad71-bf70-70cf-9e28-5f7c9744e999€24.00€0.37matched
13capture01a1ad71-cafc-7065-ad88-5fcd4844e7ea€24.00€0.37matched
14capture01a1ad71-cf53-7fb7-9dd7-a001d7e89885€35.00€0.50matched
15capture01a1ad71-e9da-7e04-a71a-b172fca7131b€35.00€0.50matched
16capture01a1ad71-fe9b-7481-bb03-511d312d57c6€9.00€0.19matched
17refund01a1ad72-0859-78a9-83fb-9f11d0913ab0-€9.00€0.00matched
18capture01a1ad72-17dc-7817-b711-b2b940e2e000€24.00€0.37matched
19capture01a1ad72-2ca4-727a-aa23-125f96da419a€49.00€0.67matched
20capture01a1ad72-50b8-7a15-a72b-7af511ee3b2f€9.00€0.19matched
21capture01a1ad72-6b7f-7123-afa2-454778a26e19€24.00€0.37matched
22capture01a1ad72-7903-7b9f-9bb9-cddd6d7cea26€49.00€0.67matched
23capture01a1ad72-7dc0-7f35-a3b7-232db5f6491a€9.00€0.19matched
24capture01a1ad72-ddbc-74f9-863b-d5f87a5fc950€9.00€0.19matched
25capture01a1ad72-e1e5-7161-8282-fc100432bf82€35.00€0.50matched
26capture01a1ad72-e5ad-7b7d-92bc-e240dd452056€9.00€0.19matched
27capture01a1ad72-ea69-7284-b0dc-3f6d9b904565€35.00€0.50matched
28capture01a1ad72-eb04-7074-a7e9-0849f25e9897€35.00€0.50matched
29capture01a1ad73-04a9-7eef-bf1d-1ba43e02a536€35.00€0.50matched
30capture01a1ad73-1652-79d9-b95b-cd5aa676ad99€35.00€0.50matched
31capture01a1ad73-204a-735a-a0ed-ba428c8beb74€9.00€0.19matched
32capture01a1ad73-3945-7a99-acba-99897e6b5564€35.00€0.50matched
33capture01a1ad73-5b80-7cfb-bfb8-8ef03aedaff1€15.00€0.26matched
34capture01a1ad73-8b9b-7190-b6f4-c3bd87266399€24.00€0.37matched
35capture01a1ad73-9401-7029-8cff-192b57bc39dd€24.00€0.37matched
36capture01a1ad73-9c99-7147-b324-a5a69940ad8e€49.00€0.67matched
37capture01a1ad73-9e40-73a1-a968-239e0fb43ddf€24.00€0.37matched
38capture01a1ad73-bef2-7389-a0c9-ac73eaab71bb€35.00€0.50matched
39refund01a1ad73-ce2a-7d1a-9615-07103c439d01-€7.00€0.00matched
40capture01a1ad73-f9ad-73c7-a5f8-1e07a52d2150€35.00€0.50matched
41capture01a1ad74-06b5-78c5-a927-ef813392cf2b€24.00€0.37matched
42capture01a1ad74-0560-7267-9e13-a07fff8eefb9€9.00€0.19matched
43capture01a1ad74-0e99-7edd-b112-8df868bece92€35.00€0.50matched
44capture01a1ad74-2aa0-7ca3-85ca-7fd4daeced0d€15.00€0.26matched
45capture01a1ad74-62ca-73a1-b2da-e5fc7f498c13€35.00€0.50matched
46refund01a1ad74-6e0d-75e9-b622-8d8e022c279f-€9.00€0.00matched
47capture01a1ad74-8929-7422-b39a-405626e04534€24.00€0.37matched
48capture01a1ad74-8f8f-7954-9169-54717162e664€35.00€0.50matched
49capture01a1ad74-d370-75be-aa8d-61a38f4e0f24€35.00€0.50matched
50capture01a1ad74-ef53-765e-b38c-b596782d062c€15.00€0.26matched
51capture01a1ad74-fbbe-7594-818d-9584867c2fe8€49.00€0.67matched
52capture01a1ad75-05db-7084-a729-109b34bcaea4€49.00€0.67matched
53capture01a1ad75-0a34-7c28-aea3-d5beb2c8f39d€15.00€0.26matched
54capture01a1ad75-30a4-7047-a7d3-96199b87238f€35.00€0.50matched
55refund01a1ad75-551b-7a63-b2be-8ae5fd26179a-€10.00€0.00matched
56capture01a1ad75-5e7a-7316-b95e-a2563d9c4225€9.00€0.19matched
57capture01a1ad75-667c-750c-8dd3-e6f047f4c4db€35.00€0.50matched
58capture01a1ad75-68b9-7754-8821-870a5052a850€24.00€0.37matched
59capture01a1ad75-6f9a-7802-abd5-4b1ed60d07d6€35.00€0.50matched
60capture01a1ad75-75da-739a-8703-28b844d46e13€49.00€0.67matched
61capture01a1ad75-7e77-7209-ace3-fcc1acad6829€24.00€0.37matched
63capture01a1ad75-bad1-7790-8181-d00cc49f60eb€49.00€0.67matched
64capture01a1ad75-d53d-7ffb-942c-cc3bb230374d€24.00€0.37matched
65capture01a1ad75-f9f9-7077-8aa8-42b25b29f49a€9.00€0.19matched
66capture01a1ad76-01ab-7c81-961d-8978a68f33e8€49.00€0.67matched
67capture01a1ad76-3cdc-759d-bb46-90908b7c7960€9.00€0.19matched
68capture01a1ad76-6346-77cc-872a-f49a057c3ce3€15.00€0.26matched
69capture01a1ad76-8705-7f57-8d4c-e405f8630f3e€24.00€0.37matched
70capture01a1ad76-c230-7d86-8574-cfaa273b0a12€9.00€0.19matched
71capture01a1ad76-ef13-7697-bdcb-3583d1427cc8€49.00€0.67matched
72capture01a1ad76-ffa9-7f10-81b3-d2319c48b351€24.00€0.37matched
73capture01a1ad77-0ae7-785d-a9a4-381fe9f41cb8€9.00€0.19matched
74capture01a1ad77-193b-7cc5-967b-8bdb8ae938b5€9.00€0.19matched
75capture01a1ad77-1f32-7320-9d97-68c837b192c1€9.00€0.19matched
76capture01a1ad77-31c3-7667-b2af-11d193bb698f€35.00€0.50matched
77capture01a1ad77-5c5e-7360-a25e-d6db73a70bbc€9.00€0.19matched
78capture01a1ad77-65cb-7df7-addc-b3d8c25237b8€35.00€0.50matched
79capture01a1ad77-8560-797f-bc6b-3cd669a503c3€9.00€0.19matched
80capture01a1ad77-9c83-7604-b838-bc74c08ba512€9.00€0.19matched
81capture01a1ad77-bb9f-77c6-b88b-6fe9a7288edd€49.00€0.67matched
82capture01a1ad77-e588-781a-9dec-d33ecdc8b3de€9.00€0.19matched
83capture01a1ad77-efd1-7dfd-847b-e05227ccba44€24.00€0.37matched
84capture01a1ad77-f017-7e8c-914c-81d8232288e7€35.00€0.50matched
85capture01a1ad78-01ab-7c64-8509-7b4049d0e723€15.00€0.26matched
86capture01a1ad78-03f5-7e4b-831b-7b1a47026d4a€35.00€0.50matched
87capture01a1ad78-3bbf-7eb8-8703-46636f1306e4€24.00€0.37matched
88capture01a1ad78-4d1c-7fcd-b7d7-4fea91c97d94€9.00€0.19matched
89capture01a1ad78-65bf-7fee-ad48-650065f9bb9c€35.00€0.50matched
90capture01a1ad78-6626-70e8-9f1a-33864ca774e1€35.00€0.50matched
91capture01a1ad78-7320-7559-a2a0-0215a3b04e5a€9.00€0.19matched
92capture01a1ad78-7be8-7e02-91d5-b03e741fec57€35.00€0.50matched
93capture01a1ad78-8284-720a-8eb9-07051fbd8bce€24.00€0.37matched
94capture01a1ad78-c438-7b9c-bbaa-0b7f8ef9cbd8€15.00€0.26matched
95capture01a1ad78-ca5b-7171-a914-103993c8e102€9.00€0.19matched
96capture01a1ad78-eba6-7a3f-8c29-ebad7cbc8e63€35.00€0.50matched
97capture01a1ad78-f03f-707e-b74d-9ab9e60d9da9€35.00€0.50matched
98capture01a1ad78-fef0-7403-bb2e-670581559e4f€24.00€0.37matched
99capture01a1ad79-0690-74ea-b1ab-596efc848e7f€49.00€0.67matched
100capture01a1ad79-1439-706b-8d74-516a9e06e55d€35.00€0.50matched
101capture01a1ad79-18c7-7434-858d-a186dd815088€24.00€0.37matched
102capture01a1ad79-19fd-71b8-83d1-40fc386bb477€15.00€0.26matched
103capture01a1ad79-398b-7758-8b18-bcc81b3d32d9€9.00€0.19matched
104capture01a1ad79-439c-7be7-a8e9-be55689b8452€49.00€0.67matched
105capture01a1ad79-4b56-754e-b46a-a5ea87fc3209€9.00€0.19matched
106capture01a1ad79-5628-7214-8711-88deaf268122€49.00€0.67matched
107capture01a1ad79-b9db-72a1-90e2-9ab065f34b93€24.00€0.37matched