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

Gross

€3,121.00

PSP fee

€49.74

Net to the bank

€3,071.26

Settlement journal

#341203

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19bcc-0d6c-760a-9e8c-e1de86e7f982 is already settled by stl_EUR_2989358 line 79
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 30, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
  • missing linein the books, not in the filecapture:01a19bc7-726d-7cf8-a650-6018a15e8af9 is in no file
LineKindReferenceGrossFeeStatus
32capture01a19bc8-7477-7db3-9507-0a06898a3340€35.00€0.52fee difference
53capture01a19bc9-be00-73d2-88ea-bef6de7dae4f€15.00€0.30fee difference
58capture01a19bca-0544-7c1c-9432-16ad92fea10a€49.00€0.68fee difference
80capture01a19bcc-0de8-74c5-8138-05d3f3086be8€35.00€0.50duplicate line
1capture01a19bc2-c4df-7361-9844-a3091d3c0c03€15.00€0.26matched
2capture01a19bc2-dda5-7703-a2f3-28c235d62fcf€35.00€0.50matched
3capture01a19bc5-f392-74d1-a99b-def64d0dfa27€15.00€0.26matched
4capture01a19bc5-fcac-768d-9344-25efa9ca34aa€35.00€0.50matched
5capture01a19bc6-1534-7ca9-957e-e2ef2f6dba82€9.00€0.19matched
6capture01a19bc6-2de7-778b-84c6-af5ccf85faab€9.00€0.19matched
7refund01a19bc6-65ca-74c0-b4e4-380bc31a4792-€11.00€0.00matched
8capture01a19bc6-c6fc-7841-a660-02d12585581a€9.00€0.19matched
9capture01a19bc6-c949-7b87-bacb-df2ecc4cc30f€24.00€0.37matched
10capture01a19bc6-cb14-7d57-bde3-c14aae111dff€15.00€0.26matched
11capture01a19bc6-d03a-74f9-a6b4-ca9fc03d02fb€24.00€0.37matched
12capture01a19bc6-dba7-7e2b-8995-2c958948cf43€35.00€0.50matched
13capture01a19bc6-e09b-7f98-9b46-fe246e2ee4ae€15.00€0.26matched
14capture01a19bc6-e0ca-7299-8bbf-6166198a5925€24.00€0.37matched
15capture01a19bc7-127a-7448-bf2b-09afd26f2d9a€9.00€0.19matched
16capture01a19bc7-1942-7615-b1a0-8dbe11b6449f€35.00€0.50matched
17capture01a19bc7-1c37-7102-8d9f-b2b23b65022d€49.00€0.67matched
18capture01a19bc7-263b-76d3-b884-fc27d4d92a32€49.00€0.67matched
19refund01a19bc7-2902-771c-8cb4-7297ff89a106-€13.00€0.00matched
20capture01a19bc7-2aa3-7d9f-9ef8-5b208d89cc46€9.00€0.19matched
21capture01a19bc7-4b33-7cda-9a3c-c5c3a2d68a0a€35.00€0.50matched
22capture01a19bc7-65ac-75d7-9351-f4952c4c8b78€49.00€0.67matched
23capture01a19bc7-6c64-7fae-b79f-c91e9175fe80€9.00€0.19matched
24capture01a19bc7-cbb5-7a6d-90a8-7a1036806a38€49.00€0.67matched
25capture01a19bc7-e6cb-741d-b28d-8115d8e49403€15.00€0.26matched
26capture01a19bc7-ed2b-7c31-9890-5bb669880857€9.00€0.19matched
27capture01a19bc7-f8a3-7425-aaa9-6986c766dd46€24.00€0.37matched
28capture01a19bc7-fd63-79b5-8096-69eec6af27a7€35.00€0.50matched
29capture01a19bc7-f512-7591-a518-c65e9b9b15ab€15.00€0.26matched
30capture01a19bc8-38b9-7bda-9a67-2dbfffecb195€15.00€0.26matched
31capture01a19bc8-38f4-77ad-baf5-fc0d712d3b4e€9.00€0.19matched
33capture01a19bc8-ccc6-7472-93ad-fca8656fd0a7€35.00€0.50matched
34capture01a19bc8-d692-77f6-a031-7ddba5957cc9€49.00€0.67matched
35capture01a19bc8-e1a4-7e19-89a7-67433d11f687€24.00€0.37matched
36capture01a19bc8-e211-7d80-9baa-329a2e77b0b1€35.00€0.50matched
37capture01a19bc8-f37e-7fc1-87e9-a5431b70452f€49.00€0.67matched
38capture01a19bc8-f791-711a-b372-c53ae5d5be31€49.00€0.67matched
39capture01a19bc9-146a-7ccc-9cc0-f48ff9adb22f€9.00€0.19matched
40capture01a19bc9-3883-774a-a825-72b6170a6da4€9.00€0.19matched
41capture01a19bc9-3f48-7db4-a6c2-4ed30500569d€49.00€0.67matched
42refund01a19bc9-402f-7c1e-a999-6b3167436a39-€48.00€0.00matched
43capture01a19bc9-47e5-70c2-b8ca-a1b3467f2f59€49.00€0.67matched
44capture01a19bc9-494c-7903-b7df-13ba2b17cd89€9.00€0.19matched
45capture01a19bc9-4ae4-7460-bedf-de13d9ff2509€9.00€0.19matched
46capture01a19bc9-4eb8-7136-b85d-4e1b3c2f9ab4€15.00€0.26matched
47capture01a19bc9-5c54-7f65-9b8f-a8eeb4a6129b€9.00€0.19matched
48capture01a19bc9-7890-7ded-a310-445a97a83722€15.00€0.26matched
49capture01a19bc9-7f2a-734f-bb6b-7f3cf31f038f€35.00€0.50matched
50capture01a19bc9-9508-70f5-bfde-bf1d8f5fbb8f€24.00€0.37matched
51capture01a19bc9-a205-7658-8f95-8848552a5f86€35.00€0.50matched
52capture01a19bc9-a83b-7079-a6fc-ef1fd52b9406€15.00€0.26matched
54capture01a19bc9-bf4a-7baa-a730-31811794c898€49.00€0.67matched
55capture01a19bc9-e6fd-7960-b83b-2f223d7a5a71€35.00€0.50matched
56capture01a19bc9-efe5-77d7-84d1-4cbae092aae8€15.00€0.26matched
57capture01a19bc9-fa5e-76a9-ac83-788835626fb8€49.00€0.67matched
59capture01a19bca-5c95-77df-a9ef-d331bb4f6e23€49.00€0.67matched
60capture01a19bca-5ed9-7edb-af63-1c1901e8a2a9€24.00€0.37matched
61capture01a19bca-691b-70a4-81e5-c50a0142c99b€15.00€0.26matched
62capture01a19bca-797d-7861-9df4-cdf25379b913€24.00€0.37matched
63capture01a19bca-9a22-77a0-8cac-94cbc6b4fe61€9.00€0.19matched
64capture01a19bca-b62b-758d-9832-9dfb13c67501€9.00€0.19matched
65capture01a19bca-d68e-7bb0-beaf-e4343fa4ef70€24.00€0.37matched
66capture01a19bca-ea9e-7fed-9eb8-113d1f4df149€24.00€0.37matched
67capture01a19bca-ee85-704d-a773-4aadc005325e€15.00€0.26matched
68capture01a19bcb-0a31-76ff-bb96-59d13140d7c6€49.00€0.67matched
69capture01a19bcb-43c7-7915-852a-2de2c4e0e3d4€24.00€0.37matched
70capture01a19bcb-61ac-7b5b-a686-3fe836e7d4ba€35.00€0.50matched
71capture01a19bcb-76e8-70c1-84b5-f2d98d0bcb1f€49.00€0.67matched
72capture01a19bcb-791d-710d-a58e-2c7454c805df€49.00€0.67matched
73capture01a19bcb-8bee-7d71-9d87-7e17bf9cd020€9.00€0.19matched
74capture01a19bcb-9fc3-756b-8047-dbb5efaa9e43€35.00€0.50matched
75capture01a19bcb-c5f6-740a-ae80-dcda829d404e€15.00€0.26matched
76capture01a19bcb-c6c3-7ea9-a707-3e2da627fca0€24.00€0.37matched
77capture01a19bcb-ed1c-7604-b09e-9b17a038780e€9.00€0.19matched
78capture01a19bcc-0031-7317-8e7e-bd5f76d9444d€9.00€0.19matched
79capture01a19bcc-0de8-74c5-8138-05d3f3086be8€35.00€0.50matched
81capture01a19bcc-22e1-729b-87b4-0307cace1d71€15.00€0.26matched
82capture01a19bcc-4d52-7f87-a2fe-bcadd7250e4a€35.00€0.50matched
83capture01a19bcc-5c2a-7564-beb9-83a2f1582b3b€15.00€0.26matched
84capture01a19bcc-68af-7a42-8e29-b2dd69713571€24.00€0.37matched
85capture01a19bcc-75e5-749f-a327-0345ddedd706€35.00€0.50matched
86capture01a19bcc-7e7c-72a9-9b8a-f9955e13adea€35.00€0.50matched
87capture01a19bcc-85e8-7a7c-926b-29e7546bce10€24.00€0.37matched
88capture01a19bcc-8da6-7618-a41b-0b362213a72e€24.00€0.37matched
89capture01a19bcc-9a96-70b6-a59c-db7279b02cd9€15.00€0.26matched
90capture01a19bcc-c1c9-7005-ba99-c41ee09c7bb9€49.00€0.67matched
91capture01a19bcc-c746-7ca9-9f4f-cd7aa98e6207€15.00€0.26matched
92capture01a19bcc-ce28-7f2d-a00f-a026d7b24a88€49.00€0.67matched
93capture01a19bcc-d357-7175-b38a-ea3608535f35€15.00€0.26matched
94refund01a19bcc-d587-73da-b88a-8de75559eaef-€26.00€0.00matched
95capture01a19bcc-e2f1-78d9-be2e-2061bb1ad91c€15.00€0.26matched
96capture01a19bcc-e344-7d9f-9f8c-4469653d8f43€35.00€0.50matched
97capture01a19bcd-05a0-7e3a-9043-ecf572617438€35.00€0.50matched
98refund01a19bcd-1e41-7c65-a82f-99bb9d605b72-€46.00€0.00matched
99capture01a19bcd-3fc9-74c4-8b93-d354f640ea76€24.00€0.37matched
100capture01a19bcd-4db3-7939-8da2-492c37f53c90€49.00€0.67matched
101capture01a19bcd-636f-70fe-9450-0c918e76fe89€24.00€0.37matched
102capture01a19bcd-6d15-7602-a43d-1a50b49efef0€9.00€0.19matched
103capture01a19bcd-7146-7e7b-848d-a89ad8d0df32€35.00€0.50matched
104capture01a19bcd-7752-7461-84c8-9b804af574c6€9.00€0.19matched
105capture01a19bcd-7c44-72d7-a4be-634108555095€49.00€0.67matched
106capture01a19bcd-83e1-7165-9f06-39c58e5a073d€24.00€0.37matched
107capture01a19bcd-9ae2-71e2-95b8-8707a89275c6€35.00€0.50matched
108capture01a19bcd-a1fd-76c1-ba99-d9277cdfea04€9.00€0.19matched
109refund01a19bcd-ad5c-756f-82f8-cdda97859525-€35.00€0.00matched
110capture01a19bcd-c04c-7674-8066-fbbecda5a9a4€49.00€0.67matched
111capture01a19bcd-d758-73a5-8493-3b114e55dee4€49.00€0.67matched
112capture01a19bcd-fab6-7535-adc6-09490a6a4e1d€9.00€0.19matched
113capture01a19bce-07ff-7b58-9257-1978a961fdad€15.00€0.26matched
114capture01a19bce-0ae3-7425-b083-5bb11467c7d8€24.00€0.37matched
115capture01a19bce-0edd-746e-9026-cfcfc2b0d436€49.00€0.67matched
116capture01a19bce-253f-7a26-a139-c9faf93cd426€24.00€0.37matched
117capture01a19bce-3551-72d6-84fd-7c8f06f73a83€9.00€0.19matched
118capture01a19bce-5959-742e-8c0e-40825da38951€49.00€0.67matched
119capture01a19bce-5b05-75ad-b659-b83f3f8e06c8€15.00€0.26matched
120capture01a19bce-62e2-70ae-8666-0f1be1cef2cd€9.00€0.19matched
121capture01a19bce-7bf3-79d6-a911-be21e5a03d00€49.00€0.67matched
122capture01a19bce-8828-7a1d-906b-dafe069b468b€15.00€0.26matched
123capture01a19bce-966d-7d01-aeeb-c93b2756d647€35.00€0.50matched
124capture01a19bce-a11c-7f48-88b8-1c6bb5394fc9€24.00€0.37matched
125capture01a19bce-b6f6-7771-9185-843b9d59cbe7€9.00€0.19matched
126capture01a19bce-c127-73c7-bee4-fb6bb8eb55cd€9.00€0.19matched
127capture01a19bce-ca1a-76b8-aef7-11b72033a8d2€15.00€0.26matched
128capture01a19bce-def8-77dc-9646-01fd2e0daf2f€49.00€0.67matched
129capture01a19bce-f080-796e-8274-2cb032e36d18€24.00€0.37matched
130capture01a19bce-f33f-7962-bfb4-dcc7571f699e€49.00€0.67matched