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

3 Nov, 10:20

Gross

€3,154.00

PSP fee

€49.68

Net to the bank

€3,104.32

Settlement journal

#359519

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a0ed-23e8-79bf-a19c-c809b8b77a97 is already settled by stl_EUR_2989502 line 9
  • duplicate linethe file lists it twicecapture:01a1a0f4-eabc-700d-9fd2-14c3213ed0bf is already settled by stl_EUR_2989502 line 124
LineKindReferenceGrossFeeStatus
10capture01a1a0ed-2407-7032-8bb8-4369ec372d28€49.00€0.67duplicate line
125capture01a1a0f4-eae6-7983-bd63-6f7d33febe6f€24.00€0.37duplicate line
1capture01a1a0ea-28e0-79b1-a7d3-f565df1bf43e€49.00€0.67matched
2refund01a1a0ec-5340-71f2-9bfd-30e1bb44ddf7-€18.00€0.00matched
3capture01a1a0ec-5b98-71b6-8d8f-19a67eeb7185€9.00€0.19matched
4capture01a1a0ec-905c-714c-887e-bc29c5d949b7€9.00€0.19matched
5capture01a1a0ec-91c0-74f3-97b9-c121a7f8f8f4€49.00€0.67matched
6capture01a1a0ec-b800-7d4a-8ce1-8fbd1c027027€35.00€0.50matched
7capture01a1a0ed-064a-79b6-80e6-90ff9b9324dd€35.00€0.50matched
8capture01a1a0ed-1382-74de-ae2a-f38caae0b860€49.00€0.67matched
9capture01a1a0ed-2407-7032-8bb8-4369ec372d28€49.00€0.67matched
11capture01a1a0ed-343b-7e51-a7ba-bbabaa0eeadc€9.00€0.19matched
12capture01a1a0ed-352d-76fc-8a4d-f17160a26821€35.00€0.50matched
13capture01a1a0ed-443c-7e99-bd71-a11b7044b6b8€24.00€0.37matched
14capture01a1a0ed-6bf0-7a66-a5fc-3ee4595c259e€9.00€0.19matched
15capture01a1a0ed-903f-7205-80c6-1930d4f36c24€9.00€0.19matched
16capture01a1a0ed-9c87-7cee-9b06-9c19197a9e34€49.00€0.67matched
17capture01a1a0ed-ad76-732b-87b4-d393ea266a6d€49.00€0.67matched
18capture01a1a0ed-ce50-79ce-a16d-0c09c1ffe238€9.00€0.19matched
19capture01a1a0ed-d0d7-7025-b535-f71abc14e6dc€9.00€0.19matched
20capture01a1a0ed-d3e8-7887-831c-73f3d4f5bed4€15.00€0.26matched
21capture01a1a0ed-dc50-7359-8fc0-f3b952d5ed75€49.00€0.67matched
22capture01a1a0ed-e924-7159-8c52-9d8bd4fbb973€9.00€0.19matched
23refund01a1a0ee-0f24-7680-9df0-27360ac22ec7-€48.00€0.00matched
24capture01a1a0ee-18e2-7359-bdc5-0e90a75ae3ac€9.00€0.19matched
25capture01a1a0ee-23dc-7562-8aa0-9307d2bf22e4€35.00€0.50matched
26capture01a1a0ee-48b3-7d63-96a1-d002cdd95a8b€9.00€0.19matched
27capture01a1a0ee-4e51-7c4e-a218-a1f11787c6d6€15.00€0.26matched
28capture01a1a0ee-4f24-7c89-b21c-282002cb220f€24.00€0.37matched
29capture01a1a0ee-7cb9-7c3e-b4a3-16d8cbc89500€9.00€0.19matched
30capture01a1a0ee-8051-7615-9120-83d974e4f8db€24.00€0.37matched
31capture01a1a0ee-9704-73ef-a781-a4108232e0bb€24.00€0.37matched
32capture01a1a0ee-a0a9-70e7-a586-5da5c812e536€35.00€0.50matched
33capture01a1a0ee-a52d-741d-9988-4b29b8377e3d€49.00€0.67matched
34capture01a1a0ee-ad4c-7d65-b0cb-6251944852c9€24.00€0.37matched
35capture01a1a0ee-bb3b-7bbb-9f24-a92a9b912b9e€15.00€0.26matched
36capture01a1a0ee-c260-73f0-a51d-683bb567bdde€49.00€0.67matched
37refund01a1a0ee-e952-7743-ad8a-80af7e041aaa-€8.00€0.00matched
38capture01a1a0ee-eaab-7895-b696-6ef452de627f€15.00€0.26matched
39capture01a1a0ee-ec4b-7e1f-8d56-5c3f31cfc85b€35.00€0.50matched
40capture01a1a0ee-fc60-7db0-8d75-62193a522536€15.00€0.26matched
41capture01a1a0ef-0fdd-7170-ad46-d2e503290efd€15.00€0.26matched
42capture01a1a0ef-134f-7990-acf6-7d709d4747e4€24.00€0.37matched
43capture01a1a0ef-1c9b-7d74-81bc-7cedacb12c9c€35.00€0.50matched
44capture01a1a0ef-2eba-774b-8f7b-be0e5f99f2d7€9.00€0.19matched
45capture01a1a0ef-59e7-79ff-8e91-41c4277d5639€49.00€0.67matched
46capture01a1a0ef-5f26-7944-8ec2-89f066511909€9.00€0.19matched
47capture01a1a0ef-6747-7586-ba1a-b3d668112748€24.00€0.37matched
48capture01a1a0ef-74cb-7428-9c65-cb70b1e2990c€9.00€0.19matched
49capture01a1a0ef-7752-775e-94ff-68eed83b7a41€35.00€0.50matched
50capture01a1a0ef-7e97-7a71-a710-37b8592e4a54€9.00€0.19matched
51capture01a1a0ef-a3e0-759b-9371-f59929da9dbc€35.00€0.50matched
52capture01a1a0ef-b4da-751e-a774-8afce0175d0f€35.00€0.50matched
53capture01a1a0ef-bf3b-71b5-bc96-78a5ef571b67€35.00€0.50matched
54capture01a1a0ef-e6c3-7aa4-a9ca-48d460e59bc4€24.00€0.37matched
55capture01a1a0ef-ff7b-7a3d-b867-b4373e17942a€35.00€0.50matched
56refund01a1a0f0-0d96-7e79-8f4a-018518002e33-€15.00€0.00matched
57capture01a1a0f0-0e7e-77d6-8b82-f1b0006f4adc€9.00€0.19matched
58capture01a1a0f0-2b7e-790d-bf6d-38a5419bab0e€15.00€0.26matched
59capture01a1a0f0-44eb-7fa4-8933-391680153c69€35.00€0.50matched
60capture01a1a0f0-6521-7756-bfa9-7e5305d5cde1€24.00€0.37matched
61capture01a1a0f0-65c0-7365-8df5-f1d31e328030€24.00€0.37matched
62capture01a1a0f0-7b24-7008-b450-bbc19ea23d20€9.00€0.19matched
63capture01a1a0f0-8242-7e6c-986f-8f05d3f0c7a5€35.00€0.50matched
64capture01a1a0f0-991e-7047-9476-fdd69b7a0b0e€24.00€0.37matched
65capture01a1a0f0-b787-7106-b022-4a60d698f9f3€24.00€0.37matched
66capture01a1a0f0-d6c6-7d66-a209-4fb37289e6f0€15.00€0.26matched
67capture01a1a0f0-e88b-7171-a330-6a3caf77acbe€35.00€0.50matched
68capture01a1a0f1-01c8-70c1-b68c-3da2ea74ea51€24.00€0.37matched
69capture01a1a0f1-0d3d-79dc-be97-da0aeb4e6c55€15.00€0.26matched
70capture01a1a0f1-298d-75c8-bd40-04d462ea4dba€35.00€0.50matched
71capture01a1a0f1-2b59-74a9-8ffa-f1201d68f41c€49.00€0.67matched
72capture01a1a0f1-2e85-75b4-b486-1450b61deb81€35.00€0.50matched
73capture01a1a0f1-3180-77a0-8389-628a3dd6bab6€15.00€0.26matched
74capture01a1a0f1-1ed0-781b-ad21-f4fc5d6dc35d€24.00€0.37matched
75capture01a1a0f1-45d6-72bc-aa48-ae384dc81667€49.00€0.67matched
76capture01a1a0f1-5979-7cd7-8a76-3e13a8983435€49.00€0.67matched
77capture01a1a0f1-71f2-7c82-9a9c-6612d7804aa7€15.00€0.26matched
78capture01a1a0f1-7421-7fc4-bca0-ddef68e95074€15.00€0.26matched
79capture01a1a0f1-ac91-7686-b149-14ec9433cd3c€49.00€0.67matched
80capture01a1a0f1-aef1-781e-9f49-a89afc6f6302€35.00€0.50matched
81capture01a1a0f1-bb37-7100-ba1f-bf0516888ca4€24.00€0.37matched
82capture01a1a0f1-ca0f-700c-b2a0-388a10732550€9.00€0.19matched
83capture01a1a0f1-de73-7ea1-854f-4abbd8d751b4€24.00€0.37matched
84capture01a1a0f1-e047-7515-a676-7f176bb99fe8€15.00€0.26matched
85capture01a1a0f1-efc2-73a3-b726-252c1093f739€35.00€0.50matched
86refund01a1a0f2-3868-7fdb-8a84-fd3001204565-€3.00€0.00matched
87capture01a1a0f2-5bd2-76a3-8211-05a184a0a2aa€35.00€0.50matched
88capture01a1a0f2-6673-7edf-98c0-893e541bc3f8€49.00€0.67matched
89capture01a1a0f2-70ff-7cfd-b511-c04a2b1547a7€15.00€0.26matched
90capture01a1a0f2-79cb-7547-905c-7a5554b96f98€15.00€0.26matched
91capture01a1a0f2-8591-7403-b875-b9fe354242cf€15.00€0.26matched
92capture01a1a0f2-a3af-7475-aadc-fe81e99cc7df€24.00€0.37matched
93capture01a1a0f2-ab03-7bb3-8ea3-1a3c8f7bc8f0€9.00€0.19matched
94refund01a1a0f2-c8be-7767-8a1c-2debd547875b-€27.00€0.00matched
95capture01a1a0f2-f3e2-7c63-b3aa-25080f23613c€9.00€0.19matched
96capture01a1a0f2-f639-7012-b5b2-0b59174957d9€49.00€0.67matched
97capture01a1a0f2-fb94-7b4c-b671-a7c073714f1e€35.00€0.50matched
98capture01a1a0f3-0ba3-721f-abe4-fefbad87b74d€24.00€0.37matched
99capture01a1a0f3-1103-7f88-9efe-30d10b34ba55€35.00€0.50matched
100capture01a1a0f3-4ceb-7cbe-9606-6a1d74008fb6€9.00€0.19matched
101capture01a1a0f3-4e2c-7545-b647-c4da688d8697€35.00€0.50matched
102capture01a1a0f3-5d54-7334-97fe-a0efd45f4d2f€24.00€0.37matched
103capture01a1a0f3-5fdd-723a-8f04-6f6a6a43af6d€49.00€0.67matched
104capture01a1a0f3-61d0-7177-b614-e4cf1623d9e2€9.00€0.19matched
105capture01a1a0f3-764e-73b4-b9d2-4dc450fbb395€49.00€0.67matched
106capture01a1a0f3-c256-71e3-a84f-4452ca8bfaa9€24.00€0.37matched
107capture01a1a0f3-eeb8-79f7-9b75-a6a94dc350a4€35.00€0.50matched
108capture01a1a0f4-16f2-723e-8409-e8ecae4a243c€15.00€0.26matched
109capture01a1a0f4-2043-725b-89d6-e8a7aa798d50€49.00€0.67matched
110capture01a1a0f4-27e2-72ec-8b76-cd6cc228831c€35.00€0.50matched
111capture01a1a0f4-48a8-7173-ada6-871c5f377f47€35.00€0.50matched
112capture01a1a0f4-5ab2-74a7-bb9e-d90374ae7dd2€9.00€0.19matched
113refund01a1a0f4-6fdc-7fa4-84dc-62f09ed7aef2-€14.00€0.00matched
114capture01a1a0f4-782e-77f7-a801-617d75dfd880€49.00€0.67matched
115capture01a1a0f4-7a42-72f2-b458-59a786450f69€24.00€0.37matched
116capture01a1a0f4-9bef-7ecc-b292-6f885ec98ab1€24.00€0.37matched
117capture01a1a0f4-9c72-7160-b684-bbeb3689f1a1€24.00€0.37matched
118capture01a1a0f4-bc30-7971-b01f-07164daa3918€9.00€0.19matched
119capture01a1a0f4-c46e-77e1-bb3b-b5d98077723f€35.00€0.50matched
120capture01a1a0f4-c5e7-7928-835d-3adbfd65aabc€15.00€0.26matched
121capture01a1a0f4-c668-758a-a8ca-384959b64c25€15.00€0.26matched
122capture01a1a0f4-d2b3-730e-82b6-badb7edd4c39€9.00€0.19matched
123capture01a1a0f4-da77-7de7-a00a-ddc67148c989€9.00€0.19matched
124capture01a1a0f4-eae6-7983-bd63-6f7d33febe6f€24.00€0.37matched
126capture01a1a0f4-eb8d-757c-91f4-f3094014103f€9.00€0.19matched
127capture01a1a0f5-1129-76f2-9dc7-77c1a8fa188d€49.00€0.67matched
128capture01a1a0f5-1bd1-7485-b942-9bd66b96cf26€49.00€0.67matched
129capture01a1a0f5-26bb-714c-ac3e-388f923c5638€9.00€0.19matched
130capture01a1a0f5-354e-781e-86d7-5c40fd438974€24.00€0.37matched
131capture01a1a0f5-367c-793c-b5df-c0b9642f953a€15.00€0.26matched
132capture01a1a0f5-3b6d-7e90-9781-18b8f668d12d€24.00€0.37matched
133capture01a1a0f5-5e4e-7197-b470-4336294396ca€15.00€0.26matched