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

Gross

€2,826.00

PSP fee

€45.40

Net to the bank

€2,780.60

Settlement journal

#336759

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19a85-986c-7825-8ed6-15bd51ca1224 is already settled by stl_EUR_2989323 line 8
  • duplicate linethe file lists it twicecapture:01a19a86-bb08-77cb-8ce8-5d98cf7624d7 is already settled by stl_EUR_2989323 line 23
LineKindReferenceGrossFeeStatus
9capture01a19a85-98e7-7a72-971f-7b40d9c99479€9.00€0.19duplicate line
24capture01a19a86-bb64-7902-8a3c-a34d7b0bd07d€49.00€0.67duplicate line
1capture01a19a7f-49d7-7916-92b3-70031c4431c7€15.00€0.26matched
2capture01a19a7f-c7db-760f-bd5d-1295624c827c€15.00€0.26matched
3refund01a19a80-96fe-71dc-9061-89d525b0e126-€19.00€0.00matched
4capture01a19a84-5c4a-79fb-8a80-19da75aabfe1€9.00€0.19matched
5capture01a19a84-ab21-7953-8179-17a7f1788a7b€49.00€0.67matched
6capture01a19a85-7d83-75e0-87ff-4781f582d0d7€24.00€0.37matched
7capture01a19a85-93ff-7177-9202-2fcb1d902429€24.00€0.37matched
8capture01a19a85-98e7-7a72-971f-7b40d9c99479€9.00€0.19matched
10capture01a19a85-c451-7f76-971c-e637a3e5b231€49.00€0.67matched
11capture01a19a85-c45c-725e-aae8-306d2973b7fc€9.00€0.19matched
12capture01a19a85-ded1-7e8d-84e7-5588260fc658€35.00€0.50matched
13capture01a19a85-f26f-7762-b647-5d3d3ef9e3f8€49.00€0.67matched
14capture01a19a86-0270-7436-aaf6-1fa91039b7c0€24.00€0.37matched
15capture01a19a86-19c3-724e-a6fb-ab782674eb66€49.00€0.67matched
16capture01a19a86-43e5-7762-b98f-effe58c24264€15.00€0.26matched
17capture01a19a86-493c-71f6-85a9-29fade8c8305€15.00€0.26matched
18capture01a19a86-6356-7098-abfb-e323a1224f7a€35.00€0.50matched
19capture01a19a86-8237-75cf-98b4-2eb0ff523ea3€49.00€0.67matched
20capture01a19a86-87ba-720a-bae3-918024277199€9.00€0.19matched
21capture01a19a86-b522-7fa5-9a95-521fd5b98b97€9.00€0.19matched
22capture01a19a86-baa2-7d29-beff-157d40ba8563€9.00€0.19matched
23capture01a19a86-bb64-7902-8a3c-a34d7b0bd07d€49.00€0.67matched
25capture01a19a86-be42-7631-80f2-1fada89727a0€9.00€0.19matched
26capture01a19a86-c257-7edc-85dd-486b647201d3€9.00€0.19matched
27capture01a19a86-ca9b-7fce-924b-627b53595125€35.00€0.50matched
28capture01a19a86-e044-71d0-9f19-2a90f2ca9f79€9.00€0.19matched
29capture01a19a86-e969-783c-993a-d4275ae29e87€35.00€0.50matched
30capture01a19a87-0831-72a9-9875-bcc95cd3b594€24.00€0.37matched
31capture01a19a87-1e50-7425-843f-468e9f343c85€9.00€0.19matched
32capture01a19a87-1f88-70cf-b0bc-3ce22564cc38€49.00€0.67matched
33capture01a19a87-3b2a-7114-93ec-fbe2087907cc€49.00€0.67matched
34capture01a19a87-665e-7e1c-bb12-fd393b72f2fd€15.00€0.26matched
35capture01a19a87-6731-77fc-843f-d73e84ed6704€49.00€0.67matched
36capture01a19a87-6b3d-7215-b74f-2cab0016ce6f€35.00€0.50matched
37capture01a19a87-8c4e-7fe5-9f37-d9ce0325f1a8€15.00€0.26matched
38capture01a19a87-9f2d-7277-a482-35db04c01832€35.00€0.50matched
39capture01a19a87-c089-7a5f-8f30-252f917b2631€24.00€0.37matched
40capture01a19a87-c82d-7fab-92e2-f394c4b3f0e3€15.00€0.26matched
41capture01a19a87-c93e-77ae-b9e6-e85a01cce3f0€49.00€0.67matched
42capture01a19a87-d3de-72ff-8007-4f55535415ee€35.00€0.50matched
43capture01a19a88-1a62-70d2-917b-6bcc3b5bc35a€15.00€0.26matched
44capture01a19a88-78b9-745a-8915-b0f3608c9198€49.00€0.67matched
45capture01a19a88-8bb4-7554-bf1b-a5cd433776aa€49.00€0.67matched
46capture01a19a88-8c1d-7c07-bb61-74e0c88b0b87€24.00€0.37matched
47capture01a19a88-9191-7c97-ac93-8f9d9f9694ca€9.00€0.19matched
48capture01a19a88-b9e2-70c1-98d6-56c55ce4d94e€9.00€0.19matched
49capture01a19a88-bb46-7462-9c21-cef96c6d8ffc€9.00€0.19matched
50refund01a19a88-fc5b-771b-a779-02c10298925d-€3.00€0.00matched
51capture01a19a89-1a9d-7e44-8069-0d9ff95e99bd€24.00€0.37matched
52capture01a19a89-1c21-734b-8932-d4d004ce7e4b€9.00€0.19matched
53capture01a19a89-1e4e-7dc7-b8fc-6d83a037b4a7€15.00€0.26matched
54capture01a19a89-3486-766f-a040-f17d5fe91d61€9.00€0.19matched
55capture01a19a89-3aed-7047-b73f-2da540c65683€35.00€0.50matched
56capture01a19a89-3bb2-74dd-bdb7-53884b37bba2€24.00€0.37matched
57capture01a19a89-476c-7a0f-a407-7aa4cb532bf2€49.00€0.67matched
58capture01a19a89-508f-7937-adae-726d42cbb703€24.00€0.37matched
59capture01a19a89-54c7-72b4-a08a-305d564ca5ba€35.00€0.50matched
60capture01a19a89-7870-71cb-921b-e7c5767d7c42€49.00€0.67matched
61capture01a19a89-7cd3-7eb7-b501-ba6ea4b56698€24.00€0.37matched
62capture01a19a89-7dc5-76c4-86d8-87555f2a2066€15.00€0.26matched
63capture01a19a89-91d2-79ab-bbbc-78ae3903eb38€24.00€0.37matched
64capture01a19a89-9627-7eb1-aa30-97e8f8db6ded€49.00€0.67matched
65capture01a19a89-a07d-7b60-81a3-fdbe7f1ed0ba€9.00€0.19matched
66capture01a19a89-b6df-7667-ac94-5aff3fbde7d2€15.00€0.26matched
67capture01a19a89-b6e5-7ff8-ac85-415c65e8088f€24.00€0.37matched
68refund01a19a89-d0b1-7326-a117-c8be05a6833b-€18.00€0.00matched
69capture01a19a8a-08d3-7bb7-8189-473965a68152€35.00€0.50matched
70capture01a19a8a-2c2c-768a-8b6a-c04e7735431c€15.00€0.26matched
71capture01a19a8a-31d0-71ae-97af-cc923f2fc24f€9.00€0.19matched
72capture01a19a8a-39f0-71af-be2b-9502e7293f9e€9.00€0.19matched
73capture01a19a8a-3c87-7791-bf0c-bb714abdc930€15.00€0.26matched
74capture01a19a8a-452e-774b-9b7f-431195811491€9.00€0.19matched
75capture01a19a8a-5089-7f91-b811-0afd29a01bf0€15.00€0.26matched
76capture01a19a8a-61ff-7eb8-ba72-f26bd817ccd7€9.00€0.19matched
77capture01a19a8a-7c15-75ca-82d5-80edd3af33fd€9.00€0.19matched
78capture01a19a8a-a4d3-74dc-ac6d-3cbada3aa5a7€15.00€0.26matched
79capture01a19a8a-b8bf-75d0-a128-db334a241d3d€24.00€0.37matched
80capture01a19a8a-c973-751b-8f12-9fd9787a6cbe€9.00€0.19matched
81capture01a19a8a-d591-74a7-bfc2-4d042b225d1a€9.00€0.19matched
82capture01a19a8a-de67-7360-a3fd-1d793bfe4388€35.00€0.50matched
83refund01a19a8a-f4eb-76ee-bb92-cac0fc0e7697-€22.00€0.00matched
84capture01a19a8b-2327-77f5-b2ec-dcacf704657c€49.00€0.67matched
85capture01a19a8b-41bc-7b22-a7eb-42ea4945a11d€24.00€0.37matched
86capture01a19a8b-46e2-751f-8b56-143eb245acbd€15.00€0.26matched
87capture01a19a8b-5560-7aa3-b782-af134394a4b5€9.00€0.19matched
88capture01a19a8b-6216-7929-8f23-4f4ff8f5a376€35.00€0.50matched
89capture01a19a8b-6929-7a1d-942a-f1df85e609aa€24.00€0.37matched
90capture01a19a8b-7e90-7693-8b22-433ad367a30c€35.00€0.50matched
91refund01a19a8b-8b28-7de2-9c30-df92a282bef6-€45.00€0.00matched
92capture01a19a8b-8dc0-7edb-8509-004490dad604€35.00€0.50matched
93capture01a19a8b-8fe4-708a-863f-1061c1f61ae1€35.00€0.50matched
94capture01a19a8b-a2ec-7e0b-8463-b240a687f8d2€35.00€0.50matched
95capture01a19a8b-ad2b-701a-a48f-18c6c71d96e5€35.00€0.50matched
96capture01a19a8b-b4a7-756c-87d3-5a947783566a€15.00€0.26matched
97capture01a19a8b-b9cc-75fd-a4dd-1c8ace7104d6€15.00€0.26matched
98capture01a19a8b-d37c-76d3-8da2-48dc2e8860a9€49.00€0.67matched
99capture01a19a8b-ec31-7365-9cb5-751524e64d1f€35.00€0.50matched
100refund01a19a8c-13a9-75f2-b9a8-f8bd7ea9bbf4-€14.00€0.00matched
101capture01a19a8c-29ee-79a3-bacd-d86e8770fda8€35.00€0.50matched
102capture01a19a8c-2f75-7289-9948-2b02cba7f10b€35.00€0.50matched
103capture01a19a8c-42ce-735a-aef2-bd6babcc82b1€9.00€0.19matched
104capture01a19a8c-632d-77b4-947e-00a7ff2583f0€15.00€0.26matched
105refund01a19a8c-8313-7a36-ab6e-f2d465c9816b-€13.00€0.00matched
106capture01a19a8c-b981-71fc-95d6-0d84c72bd85c€24.00€0.37matched
107capture01a19a8c-c39d-7d8d-a869-c36cc48aa384€49.00€0.67matched
108capture01a19a8c-d2cf-786a-9e36-8e8cb11c16af€15.00€0.26matched
109capture01a19a8c-d959-7348-9bcd-7c5d20217122€24.00€0.37matched
110capture01a19a8c-e07a-7d00-a31d-c5cbbf9bb5f0€9.00€0.19matched
111capture01a19a8c-ef92-7ed1-ad9a-4ba1eade4223€24.00€0.37matched
112capture01a19a8c-f61e-7f50-bdd3-ed05565ff92d€24.00€0.37matched
113capture01a19a8d-03ee-7532-9df9-acda81bf4fd9€15.00€0.26matched
114capture01a19a8d-1a20-7f36-b449-9a3a82b62f0f€15.00€0.26matched
115capture01a19a8d-3b8c-7c79-91a3-fdd1187b20f1€9.00€0.19matched
116capture01a19a8d-5b99-720e-a2e4-f0b5f62c564e€49.00€0.67matched
117refund01a19a8d-82cf-791f-bee1-cdc27a1f2ca3-€4.00€0.00matched
118capture01a19a8d-c08c-7777-8a2a-75138672bcfe€35.00€0.50matched
119capture01a19a8d-d4c1-7c2b-b8db-65005ee18b02€9.00€0.19matched
120capture01a19a8d-dc1a-7c25-867d-33c65f4c99c7€9.00€0.19matched
121capture01a19a8e-0f9b-7938-b024-531d019deb2a€49.00€0.67matched
122capture01a19a8e-1e8a-7d66-8169-d85e3d689262€15.00€0.26matched
123capture01a19a8e-26e1-742b-bf93-03410bccb12e€35.00€0.50matched
124capture01a19a8e-3935-7362-bcd0-c0a457ac554a€9.00€0.19matched
125capture01a19a8e-3d2b-7740-912e-b2118aefdaeb€35.00€0.50matched
126capture01a19a8e-452d-7529-b8c8-ca6898d9fd70€15.00€0.26matched
127refund01a19a8e-780a-7deb-bf3e-7b0e60889f49-€7.00€0.00matched
128refund01a19a8e-7b1b-7243-adee-344f7881a7a3-€7.00€0.00matched
129capture01a19a8e-83ac-778a-b133-28b8d8dbf1cc€49.00€0.67matched