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, 18:00

Gross

€3,068.00

PSP fee

€46.14

Net to the bank

€3,021.86

Settlement journal

#401808

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ace3-69f7-7c1c-970b-b06a7bb0dd58 is already settled by stl_EUR_2989836 line 64
  • duplicate linethe file lists it twicecapture:01a1ace5-0663-74d1-a032-cda03e264e45 is already settled by stl_EUR_2989836 line 84
  • missing linein the books, not in the filecapture:01a1ace1-3a6d-70c1-8407-fb1e90cac8b4 is in no file
LineKindReferenceGrossFeeStatus
65capture01a1ace3-6a43-7e48-9aed-5b525b22943e€49.00€0.67duplicate line
85capture01a1ace5-0690-769e-bf29-9e00ab7e9d94€35.00€0.50duplicate line
1capture01a1acd8-62e3-77d2-9ac0-3e44990074b5€9.00€0.19matched
2capture01a1acd9-8754-7a8d-9c3b-3432899e3d0a€35.00€0.50matched
3capture01a1acd9-9f48-7c2b-a5f3-e3ba4b96170d€9.00€0.19matched
4capture01a1acda-6d02-7535-936a-2109379d0b03€15.00€0.26matched
5capture01a1acda-ec1d-7d51-ac83-591c9a5df725€49.00€0.67matched
6capture01a1acde-28b8-7cec-9641-18703ec91d04€15.00€0.26matched
7capture01a1acde-4dfe-72cd-afa2-7430d6b2bab1€15.00€0.26matched
8capture01a1acde-55e3-792a-bd64-bc9d0be3bcf8€49.00€0.67matched
9capture01a1acde-56a6-7124-abc6-03a273084792€24.00€0.37matched
10refund01a1acde-56b2-7a76-bcbe-f6f633ca401a-€15.00€0.00matched
11capture01a1acde-5965-7674-8470-fb90a90c210c€35.00€0.50matched
12capture01a1acde-634c-72a1-9dc4-175d4e6dd4c5€9.00€0.19matched
13capture01a1acde-6421-7ca1-81bc-44af8d29031c€49.00€0.67matched
14capture01a1acde-6eb5-7b8d-b5fe-35cc34b295e8€24.00€0.37matched
15capture01a1acde-7559-7189-a0af-bc5c48d4deee€15.00€0.26matched
16capture01a1acde-7a73-7552-a58b-33eb2f638543€9.00€0.19matched
17capture01a1acde-ca03-7255-9985-b36cc90568a7€49.00€0.67matched
18capture01a1acde-e60a-785e-9e01-44b9dee8d26c€24.00€0.37matched
19capture01a1acdf-1014-71b5-ab67-2ea5a6cd2617€35.00€0.50matched
20capture01a1acdf-46c2-731d-a629-29dd40d30751€35.00€0.50matched
21capture01a1acdf-587c-722e-893e-56b82f79cfb9€49.00€0.67matched
22capture01a1acdf-633d-7585-bc17-fc21d6537254€9.00€0.19matched
23capture01a1acdf-9f6f-70d4-b29e-d2684f2c344d€49.00€0.67matched
24capture01a1acdf-a978-79a6-9f47-abf35c0ec811€15.00€0.26matched
25capture01a1acdf-bc05-78a1-8670-f4d20b3ecc4f€49.00€0.67matched
26capture01a1acdf-be80-7dfc-a58b-8ff6a7d69341€49.00€0.67matched
27capture01a1acdf-e88e-7932-9c03-c5ef3bff3f10€35.00€0.50matched
28capture01a1acdf-ed49-7f0b-9f3c-3a5d394d7edf€49.00€0.67matched
29refund01a1acdf-f52f-772d-b818-95dafa746987-€15.00€0.00matched
30capture01a1ace0-253a-71c8-bb23-6450690c4a19€9.00€0.19matched
31capture01a1ace0-2697-75ff-b800-286a1c67b66e€9.00€0.19matched
32capture01a1ace0-282a-7719-a453-b5fb3c770d83€35.00€0.50matched
33capture01a1ace0-475c-793b-92b8-90de8d0a4d9e€9.00€0.19matched
34capture01a1ace0-5681-73d1-99d4-4dd71c8391d6€35.00€0.50matched
35capture01a1ace0-b54d-7f3b-ace7-306f058a1922€24.00€0.37matched
36capture01a1ace0-b8d8-7bb1-ad05-02ee57d22a67€35.00€0.50matched
37capture01a1ace0-bb5c-72b2-a038-dd899e8cf501€49.00€0.67matched
38capture01a1ace0-d108-7e3e-8bd6-8cccbf8184e6€9.00€0.19matched
39capture01a1ace0-ef5d-711b-914f-296594c7e1b8€35.00€0.50matched
40capture01a1ace0-fff7-71b3-8c35-376484330922€9.00€0.19matched
41capture01a1ace1-05e1-7ee6-bf80-19c91c4645c8€49.00€0.67matched
42capture01a1ace1-2305-7220-a875-787eeab2a66f€9.00€0.19matched
43capture01a1ace1-26b6-74fa-92b5-d110595b388f€9.00€0.19matched
44capture01a1ace1-3be8-710c-99c7-7b799868f54f€49.00€0.67matched
45capture01a1ace1-3ff4-7156-a603-fe4c4ccc782d€15.00€0.26matched
46capture01a1ace1-5e54-7de7-8aa6-b1a09e1468fa€35.00€0.50matched
47capture01a1ace1-6069-73c0-b817-8e062f144f1f€35.00€0.50matched
48capture01a1ace1-6799-7670-b40a-c6a8cda41e2b€24.00€0.37matched
49capture01a1ace1-a762-7d73-98f7-6184c504ffb3€24.00€0.37matched
50capture01a1ace1-b210-7f3b-9eb3-12d59f3f6c38€49.00€0.67matched
51capture01a1ace1-e0de-7037-af14-b754f9d732f0€9.00€0.19matched
52capture01a1ace2-2c69-7837-a939-18763d04a1d7€24.00€0.37matched
53capture01a1ace2-6a73-7472-8347-02db669aa8c2€24.00€0.37matched
54capture01a1ace2-85bc-7ddb-b9d8-a988ef5d9151€15.00€0.26matched
55capture01a1ace2-995d-7586-a838-fd221ea0bd6f€49.00€0.67matched
56capture01a1ace2-e5c0-7bb5-8fca-9bbf9ffa4308€9.00€0.19matched
57capture01a1ace2-ef88-7ca2-89f1-43c72658439d€35.00€0.50matched
58capture01a1ace2-f67c-72ec-bf48-d114ca8a5f73€9.00€0.19matched
59capture01a1ace2-f988-7c25-b58d-b7a4be41f828€49.00€0.67matched
60capture01a1ace3-0d46-75bc-a5d1-b8db3947e9cc€9.00€0.19matched
61capture01a1ace3-34a4-7c41-9969-a108cad59408€9.00€0.19matched
62capture01a1ace3-3ed2-7a70-b8c9-531ff7097946€35.00€0.50matched
63capture01a1ace3-634e-7c51-b11a-08c7cccde376€49.00€0.67matched
64capture01a1ace3-6a43-7e48-9aed-5b525b22943e€49.00€0.67matched
66refund01a1ace3-6c2d-7989-8a69-b95c85c0fc6b-€7.00€0.00matched
67capture01a1ace3-7769-7521-9fae-1a581b347e4f€15.00€0.26matched
68capture01a1ace3-a107-7413-b707-50eaee290dee€24.00€0.37matched
69capture01a1ace3-ac88-78b2-93d0-f8a04cce4a38€35.00€0.50matched
70capture01a1ace3-ae36-75e3-b90a-2ae638b84ddc€24.00€0.37matched
71capture01a1ace3-c094-7800-8c50-3d8d4c8a1665€24.00€0.37matched
72capture01a1ace4-0040-797d-bf53-7c53217d368e€49.00€0.67matched
73capture01a1ace4-0662-7863-a363-2e186ed0cd77€24.00€0.37matched
74capture01a1ace4-12fe-7d83-9238-7b68ec8032da€49.00€0.67matched
75capture01a1ace4-4304-7e3c-8738-fbca1c3a36f2€9.00€0.19matched
76capture01a1ace4-74ef-76cf-bd26-80ffc6ac8cb6€15.00€0.26matched
77capture01a1ace4-7f52-7ab8-b546-fa2281ad2bbf€15.00€0.26matched
78capture01a1ace4-8072-7d3b-86bf-831fda663282€49.00€0.67matched
79capture01a1ace4-ab40-74d1-aa77-e69321675955€15.00€0.26matched
80capture01a1ace4-b22b-7269-a449-2add9408c23d€35.00€0.50matched
81capture01a1ace4-d4be-7836-99e1-b7ad61aafb45€24.00€0.37matched
82capture01a1ace5-01a1-7325-9ebf-da02a71f4f6b€49.00€0.67matched
83capture01a1ace5-03bd-7c6e-bd8c-d624fc2e7d92€49.00€0.67matched
84capture01a1ace5-0690-769e-bf29-9e00ab7e9d94€35.00€0.50matched
86capture01a1ace5-4b14-7d54-b240-e5b7a736befa€15.00€0.26matched
87capture01a1ace5-7f0d-7ce4-a2a5-e285b8be423a€35.00€0.50matched
88capture01a1ace5-98cc-76cf-b2e0-0e5446e54e0b€24.00€0.37matched
89capture01a1ace5-9aec-7e51-a28e-3d76d8c4a866€49.00€0.67matched
90capture01a1ace5-a6ab-76db-9f94-1845f49fcd3f€49.00€0.67matched
91capture01a1ace5-c982-7cbc-90ec-f4c74d70d9d3€15.00€0.26matched
92capture01a1ace5-d736-741a-90c4-fdbf742895d4€15.00€0.26matched
93capture01a1ace5-e402-709d-a41a-2b45a0a9dcdb€35.00€0.50matched
94capture01a1ace5-e7a6-7c05-9e84-382a0f0bbac6€15.00€0.26matched
95capture01a1ace5-ed8b-72dc-9cde-86847bf2752c€35.00€0.50matched
96capture01a1ace5-fcba-733d-8fae-c6a9deb126ba€49.00€0.67matched
97capture01a1ace6-021b-7f75-a9a3-c8c10ce48d3e€9.00€0.19matched
98capture01a1ace6-1334-79f9-b19f-af572b1efeec€15.00€0.26matched
99capture01a1ace6-18a8-7efe-b3f6-ec0b456a62eb€35.00€0.50matched
100refund01a1ace6-1d74-7a74-b0b2-5b32a5dca19b-€9.00€0.00matched
101capture01a1ace6-592c-7fa4-b94a-1d10a7b69faa€24.00€0.37matched
102capture01a1ace6-5ceb-722d-9a37-6c0de460d3aa€49.00€0.67matched
103capture01a1ace6-6935-7395-a446-ff3c6535e5cf€49.00€0.67matched
104capture01a1ace6-7bbb-7851-8e27-65aaeba384e8€35.00€0.50matched
105capture01a1ace6-91d8-7db5-9d17-f7d0c19f3616€24.00€0.37matched
106capture01a1ace6-94a9-7611-bb7d-66ec27cf440c€9.00€0.19matched
107capture01a1ace6-e3e3-7a8a-a3fc-4a183c74e123€35.00€0.50matched
108capture01a1ace7-06cf-780c-b613-f070c2ebaac0€15.00€0.26matched
109capture01a1ace7-081e-7ce9-b85e-9d1a476545a1€35.00€0.50matched
110capture01a1ace7-21db-72a5-9def-ab445695afaf€35.00€0.50matched
111capture01a1ace7-35ea-78c0-86e2-66e1c672108f€24.00€0.37matched
112capture01a1ace7-421a-7fe6-82d7-4006fd799913€24.00€0.37matched