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

7 Nov, 14:10

Gross

€2,702.00

PSP fee

€43.70

Net to the bank

€2,658.30

Settlement journal

#435776

Every line paired with the books, and every capture and refund of the day is in the file.

LineKindReferenceGrossFeeStatus
1capture01a1b64f-1c1d-71c8-809b-fa9cac1bf6ab€24.00€0.37matched
2capture01a1b650-7418-7841-be3a-295300234caf€9.00€0.19matched
3capture01a1b655-c190-76ab-8927-47eb7ec01de5€9.00€0.19matched
4capture01a1b657-5392-719a-98cc-27f0d53a4e4b€15.00€0.26matched
5capture01a1b658-5f85-7d3b-a493-e9bbb36736be€49.00€0.67matched
6capture01a1b658-5ff8-7aa6-b997-07b14b2d9afa€49.00€0.67matched
7capture01a1b658-6852-76c0-958b-748b4c100fbe€35.00€0.50matched
8capture01a1b658-785b-7446-974e-3ba454b16f4c€15.00€0.26matched
9capture01a1b658-79a7-7c96-9bd9-46dd683e4aed€9.00€0.19matched
10capture01a1b658-8324-72d5-a761-1e5872698ac0€15.00€0.26matched
11capture01a1b658-8986-7370-b8b1-54d764949b3d€49.00€0.67matched
12capture01a1b658-c77e-7882-8240-19b6b5f2d073€24.00€0.37matched
13capture01a1b658-cbdd-77f5-9546-e66ffdf19e28€49.00€0.67matched
14capture01a1b658-e044-7fa8-8cbf-9436ea82c639€15.00€0.26matched
15capture01a1b658-e3c3-78a7-aca4-61ebfd58aad4€49.00€0.67matched
16capture01a1b658-eab8-73b7-b731-e68940894621€24.00€0.37matched
17capture01a1b658-f6d1-71ec-af3b-58845f657b80€15.00€0.26matched
18capture01a1b658-f6e9-7eed-85ff-2eb89f53cf16€49.00€0.67matched
19capture01a1b659-1e92-7c79-b7d7-56bfb7b94a02€9.00€0.19matched
20refund01a1b659-2b87-7687-89e3-76859de41e92-€22.00€0.00matched
21capture01a1b659-6446-74d7-9e7e-c1f22b581491€49.00€0.67matched
22refund01a1b659-6541-76ca-85dd-8fb0e05e9703-€9.00€0.00matched
23capture01a1b659-724e-78a0-9536-0fca03014fa0€9.00€0.19matched
24capture01a1b659-7ba3-7f8e-b557-2d7467003847€9.00€0.19matched
25capture01a1b659-88bf-76be-9c37-c03c8292e2ce€24.00€0.37matched
26capture01a1b659-af64-7d2f-a6fd-62fabada0db7€49.00€0.67matched
27capture01a1b659-b047-7158-bb1c-d23e591af875€35.00€0.50matched
28capture01a1b659-bf6a-7da8-8a4f-82a0a1d982b8€15.00€0.26matched
29capture01a1b659-c082-78e5-8aba-600ae1d4185a€15.00€0.26matched
30capture01a1b659-d28c-76f6-bdb6-d4c815ac877a€9.00€0.19matched
31refund01a1b659-e4d5-77d6-9714-5ba9f6ce39b7-€4.00€0.00matched
32capture01a1b659-f414-7309-ba19-c124007d4b01€24.00€0.37matched
33capture01a1b659-f97b-7c9d-aa9d-e9679d59a795€15.00€0.26matched
34capture01a1b659-fb06-7e99-990e-1056413e4600€24.00€0.37matched
35capture01a1b65a-09bf-7a14-a807-1bf3906d6080€35.00€0.50matched
36capture01a1b65a-1b48-77f9-85dc-43b8c829dec8€49.00€0.67matched
37capture01a1b65a-244f-7a5c-97aa-ede5e61d0d7a€49.00€0.67matched
38capture01a1b65a-2450-7cb4-bdc8-77fc56ac5442€15.00€0.26matched
39capture01a1b65a-284c-7b46-a11d-370e7f2f8f9b€24.00€0.37matched
40capture01a1b65a-3abf-76e8-bed9-0512d98c7266€9.00€0.19matched
41capture01a1b65a-4eae-7583-b1a1-0138e5f31d6a€9.00€0.19matched
42capture01a1b65a-5662-7073-8940-517a304ba570€15.00€0.26matched
43capture01a1b65a-59bc-782f-a8ff-2f08e2e19263€24.00€0.37matched
44capture01a1b65a-6511-7aaa-9b16-19c9cc30c007€49.00€0.67matched
45capture01a1b65a-79df-72c7-ac4f-95beb2ea7aca€15.00€0.26matched
46capture01a1b65a-a55c-73a3-a901-083b1ee6d3a0€9.00€0.19matched
47capture01a1b65a-bb5e-7352-ae94-07af7b0d62cb€24.00€0.37matched
48capture01a1b65a-f6bb-73c6-9f66-dc9ba7332558€24.00€0.37matched
49capture01a1b65b-10fd-76ee-8f09-312387756ec2€15.00€0.26matched
50capture01a1b65b-1307-7181-beb7-f9d6dc06826d€35.00€0.50matched
51capture01a1b65b-2852-70da-92bc-aaaa996a0d4c€49.00€0.67matched
52capture01a1b65b-5a39-7c8c-b141-3ff699048967€24.00€0.37matched
53capture01a1b65b-8b04-733d-8a73-d6ec98a92410€49.00€0.67matched
54capture01a1b65b-9d03-78c9-9c9d-8d6a05539cda€9.00€0.19matched
55capture01a1b65b-c229-70e8-b708-a8744bdfd9fd€24.00€0.37matched
56capture01a1b65b-c4d2-792c-8f72-0967de121805€35.00€0.50matched
57capture01a1b65b-d2eb-75c1-a6b6-cf236ba58b59€9.00€0.19matched
58capture01a1b65c-0836-78d7-8daa-d3a23d66b307€35.00€0.50matched
59capture01a1b65c-0e3a-70a6-ad64-3f88ec34b6b2€35.00€0.50matched
60capture01a1b65c-22ad-7dfb-b2e4-09a422aadd08€9.00€0.19matched
61capture01a1b65c-40b6-78f2-854e-95b194237a87€9.00€0.19matched
62capture01a1b65c-4a34-74f5-bd62-71602bca5678€35.00€0.50matched
63refund01a1b65c-7455-7aa8-8a0e-bd95f8591baf-€7.00€0.00matched
64capture01a1b65c-8df2-7bbb-83c9-2b4357442a81€49.00€0.67matched
65capture01a1b65c-99be-7169-bc78-43829136c404€49.00€0.67matched
66capture01a1b65c-b493-7d5b-a989-e21006d457d8€9.00€0.19matched
67capture01a1b65c-bf21-7fdc-aafd-14ab25625a28€24.00€0.37matched
68capture01a1b65c-e1df-7412-814a-d2bee9d7e5c6€15.00€0.26matched
69capture01a1b65c-e3ee-748a-864c-1faf0ff722a9€15.00€0.26matched
70capture01a1b65c-eb2d-73e3-8706-90af403f2d78€24.00€0.37matched
71capture01a1b65c-f140-71f1-b989-c0cdc07b4bcd€15.00€0.26matched
72capture01a1b65c-f53e-7da9-9d26-9b34257891d6€15.00€0.26matched
73capture01a1b65d-0f2f-7950-beff-a53ee83a1ac7€15.00€0.26matched
74capture01a1b65c-fe3f-7a38-a5e1-7fd33912ddc9€15.00€0.26matched
75capture01a1b65d-1f1e-78cb-b5ab-879d4d3f8f4a€15.00€0.26matched
76capture01a1b65d-2272-7d8c-80cf-c7340382fe80€49.00€0.67matched
77capture01a1b65d-36c4-7a1d-9870-a67e83db8523€24.00€0.37matched
78refund01a1b65d-64ff-7d1e-ba12-86e18965ca84-€4.00€0.00matched
79capture01a1b65d-a1d6-78c4-a7d7-1d62f7289825€9.00€0.19matched
80capture01a1b65d-adf1-7713-874e-05d96f21805c€24.00€0.37matched
81capture01a1b65d-ca4b-7925-a5c6-08c069229d0e€15.00€0.26matched
82capture01a1b65d-df25-7140-8e45-7ad2d975843f€49.00€0.67matched
83capture01a1b65d-e094-76e9-b211-ba268620d40a€15.00€0.26matched
84capture01a1b65d-fd67-7c39-b41e-71da0842b51e€15.00€0.26matched
85capture01a1b65e-09ce-775a-b3e8-a297252cae8e€35.00€0.50matched
86capture01a1b65e-641b-728e-809c-6141ac25151f€24.00€0.37matched
87capture01a1b65e-7fc3-79cb-8681-8043eb0c8e7f€35.00€0.50matched
88capture01a1b65e-6ea7-7dd0-9cc3-568713632b57€9.00€0.19matched
89capture01a1b65e-9089-7839-9955-f79e4ff77310€24.00€0.37matched
90capture01a1b65e-90d7-73cd-aeea-bc2d95d03a72€15.00€0.26matched
91capture01a1b65e-9ef3-7261-bba5-8f742548a288€9.00€0.19matched
92capture01a1b65e-a0cc-7f59-bdbf-121c5341341f€24.00€0.37matched
93capture01a1b65e-bf54-750d-afde-49e3eabb6a81€24.00€0.37matched
94capture01a1b65e-d98f-7989-a5a8-e89b900bd6e2€49.00€0.67matched
95capture01a1b65e-f734-754c-8fd7-a3ae990ee312€15.00€0.26matched
96capture01a1b65e-f8dc-77b6-b73f-4ec9f2622f84€24.00€0.37matched
97capture01a1b65e-f8fd-74cc-b0ed-dd34f455e6aa€35.00€0.50matched
98capture01a1b65f-1f3b-7337-9f08-d310d356931f€49.00€0.67matched
99capture01a1b65f-2fb9-7241-a049-43621b42d6c9€35.00€0.50matched
100capture01a1b65f-47ab-7f0c-bc34-cdbba98be604€49.00€0.67matched
101capture01a1b65f-5205-7fba-84dd-ff5650003396€9.00€0.19matched
102refund01a1b65f-5d06-7daf-b5ab-b637d04435d4-€47.00€0.00matched
103refund01a1b65f-5dea-7b4a-ad6e-332227d9d22d-€27.00€0.00matched
104capture01a1b65f-6807-7158-834f-c072d4f2e1d4€9.00€0.19matched
105capture01a1b65f-846e-7147-aedf-bc8c2d5afede€35.00€0.50matched
106capture01a1b65f-a848-750c-8159-b3f8c91a6c75€15.00€0.26matched
107capture01a1b65f-a9bb-75d3-a293-d7c658f81aa9€24.00€0.37matched
108capture01a1b65f-afcf-7892-9fb7-06f5ffdc11a6€9.00€0.19matched
109capture01a1b65f-cfde-77c3-b73b-010506d47924€9.00€0.19matched
110capture01a1b65f-bec9-75f0-a86b-0047e004dfce€24.00€0.37matched
111capture01a1b65f-eb7c-7e88-bd78-fc0931ebd833€24.00€0.37matched
112refund01a1b65f-ee5a-7017-a45c-b64b8f73dbdb-€34.00€0.00matched
113capture01a1b660-17fc-776a-bba8-ae4a404fd17f€35.00€0.50matched
114capture01a1b660-28ee-7dd2-9962-6415d7265fe1€24.00€0.37matched
115capture01a1b660-2b66-7325-bac8-8294cb214fb6€9.00€0.19matched
116capture01a1b660-5f1b-7912-a7f1-48a3e5f28ffb€15.00€0.26matched
117capture01a1b660-6ba1-78ec-b85b-ed1604e36a13€24.00€0.37matched
118capture01a1b660-7ec6-72fd-a2c4-750285a35f74€9.00€0.19matched
119capture01a1b660-c2f8-7164-be10-79b6ace796be€35.00€0.50matched
120capture01a1b660-c6aa-7031-9f77-635555535a30€24.00€0.37matched
121capture01a1b660-ce80-7ba9-be0d-0eea599a49b8€9.00€0.19matched
122capture01a1b660-f359-7188-ac8c-cd3529557bc0€24.00€0.37matched
123capture01a1b661-0bfc-7d8a-a1d2-f04705138107€49.00€0.67matched
124capture01a1b661-4616-70b7-857d-16e6fdec96fe€15.00€0.26matched