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

4 Nov, 15:40

Gross

€2,675.00

PSP fee

€43.92

Net to the bank

€2,631.08

Settlement journal

#381690

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

LineKindReferenceGrossFeeStatus
1capture01a1a72f-002e-7401-bc93-22fb2ea5aadc€24.00€0.37matched
2refund01a1a731-d833-7a26-bf83-0a1558c3756c-€11.00€0.00matched
3capture01a1a733-5580-7ce7-a6c5-c9cf7030ac97€15.00€0.26matched
4capture01a1a733-b3cf-7a23-a484-6408653140e6€49.00€0.67matched
5capture01a1a734-7a79-78ec-8f90-d874ee712a98€9.00€0.19matched
6capture01a1a735-5322-77de-b672-45eb35b414ef€24.00€0.37matched
7capture01a1a735-7d85-754a-8829-b8e75dd94bbe€9.00€0.19matched
8capture01a1a736-f0ca-768f-b3f1-7b1875180b67€49.00€0.67matched
9capture01a1a737-9781-7966-8b12-0f64d3dd568c€24.00€0.37matched
10capture01a1a737-ae75-797d-b698-c7ebb64fe817€35.00€0.50matched
11capture01a1a737-c6f9-72f0-9d75-9c27aa085a99€24.00€0.37matched
12capture01a1a737-e46f-7ede-ad62-c52531c8e076€15.00€0.26matched
13capture01a1a737-f1ae-7064-986a-01928a6fb1b1€15.00€0.26matched
14capture01a1a737-efcf-7b76-9ac7-17de2a628a45€9.00€0.19matched
15refund01a1a737-f3c6-7596-8df0-0b8b41906907-€25.00€0.00matched
16capture01a1a737-fc12-7e47-961d-c46e5ee8b310€24.00€0.37matched
17capture01a1a738-1bba-7eec-a221-29cd32a7c53f€9.00€0.19matched
18capture01a1a738-1ca0-7116-83b4-ab3f824d5f4a€9.00€0.19matched
19capture01a1a738-2c6d-7057-a634-a8596b9a47e3€9.00€0.19matched
20capture01a1a738-3732-759e-807e-9236de3db953€35.00€0.50matched
21capture01a1a738-5bbc-7961-9c94-cc3bc26e6fac€24.00€0.37matched
22capture01a1a738-6225-7888-a8d2-23e2d10e3120€24.00€0.37matched
23capture01a1a738-68b1-755d-9499-953b76e180a5€15.00€0.26matched
24capture01a1a738-6816-73c2-9a4d-ec1978cd2978€35.00€0.50matched
25capture01a1a738-6ee0-74f7-80d3-bda547b6d64e€15.00€0.26matched
26capture01a1a738-7696-793d-9149-74efd2e8fb17€35.00€0.50matched
27refund01a1a738-8bb1-7265-beca-7aa0e957d9b9-€9.00€0.00matched
28capture01a1a738-96d3-73c4-aa26-61cb59d7e46c€24.00€0.37matched
29capture01a1a738-9965-7c68-b50c-fffe29157ad0€35.00€0.50matched
30refund01a1a738-995e-7600-90b4-af208d712118-€6.00€0.00matched
31capture01a1a738-99a9-7943-991a-5947215f8b5d€24.00€0.37matched
32refund01a1a738-9f06-7d22-8c02-b662ee93fe1a-€8.00€0.00matched
33refund01a1a738-b970-757a-8ddf-d8136c9f6326-€27.00€0.00matched
34refund01a1a738-c64b-7297-8f05-98f1eebda522-€17.00€0.00matched
35capture01a1a738-c72b-7b2f-b4d8-8c04378dfd0d€15.00€0.26matched
36capture01a1a738-ded4-7fc8-acfa-733957a87c0f€35.00€0.50matched
37capture01a1a738-e8a0-786e-956c-b49da8d88056€24.00€0.37matched
38capture01a1a739-0854-7c70-8b03-02020221025c€24.00€0.37matched
39capture01a1a739-0af9-7a76-9252-425cc379d593€49.00€0.67matched
40capture01a1a739-124c-7ef4-ac37-443022b50e4d€35.00€0.50matched
41capture01a1a739-2cc8-7095-a6bc-b8d479df36f2€15.00€0.26matched
42capture01a1a739-4f5b-79cc-8ad3-8158aac9b106€9.00€0.19matched
43refund01a1a739-6247-7818-b6f1-aa09218b7102-€14.00€0.00matched
44capture01a1a739-7be2-723d-9741-2f0ab21b7965€9.00€0.19matched
45capture01a1a739-8e59-737a-b5ad-535f5a8d1413€9.00€0.19matched
46capture01a1a739-afae-74bb-9653-8adab0ca4249€9.00€0.19matched
47capture01a1a739-c399-7f96-b144-7f7c68927c00€49.00€0.67matched
48refund01a1a739-d2de-7ffb-8c17-34d8ca61ef72-€7.00€0.00matched
49capture01a1a739-e3c4-70d4-a1f7-591920a310a3€49.00€0.67matched
50capture01a1a73a-101e-7572-9137-c9c99a0799b6€24.00€0.37matched
51capture01a1a73a-13f8-7137-9df1-041681f5f128€24.00€0.37matched
52capture01a1a73a-0f91-7e04-a167-f277b3b700f5€15.00€0.26matched
53capture01a1a73a-1bde-79b1-8b9a-2fe1df72640c€9.00€0.19matched
54capture01a1a73a-1ccd-7cec-80d6-56607ddfe566€35.00€0.50matched
55capture01a1a73a-3411-7f3c-bafe-0777ebf1ebf7€15.00€0.26matched
56capture01a1a73a-39fe-7dd4-adbe-2085e8f288a2€24.00€0.37matched
57capture01a1a73a-52d2-7647-8f6d-21cf5fe65810€9.00€0.19matched
58capture01a1a73a-5d6e-73bc-990f-c1594b04e86e€9.00€0.19matched
59capture01a1a73a-74dc-74c8-a6f4-2c2003378daa€15.00€0.26matched
60capture01a1a73a-bbf6-72ef-8fe9-4303024ea6ca€24.00€0.37matched
61capture01a1a73a-d2d5-7797-9994-678b0aa8bb8b€15.00€0.26matched
62capture01a1a73b-1741-7f41-aada-8d81ef343f63€49.00€0.67matched
63capture01a1a73b-3520-7d9a-8699-d455304b080e€9.00€0.19matched
64capture01a1a73b-42c4-7355-b9c5-a22fa4049c1b€49.00€0.67matched
65capture01a1a73b-452b-70bc-b26c-cd891a7f43e3€24.00€0.37matched
66capture01a1a73b-5216-77a4-933b-b211acf14ab7€9.00€0.19matched
67capture01a1a73b-5891-7861-9745-0b37f081e5c6€9.00€0.19matched
68capture01a1a73b-760c-70ec-a37d-e8673917597d€9.00€0.19matched
69capture01a1a73b-9947-746c-9500-9ab655293ce5€49.00€0.67matched
70capture01a1a73b-9a0a-70c1-b0e7-1518204ebbb0€49.00€0.67matched
71capture01a1a73b-b80a-73a6-a563-aa1955d8531c€35.00€0.50matched
72capture01a1a73b-b80a-757a-b352-b28b8a3d752f€9.00€0.19matched
73capture01a1a73b-c928-778a-9903-42a6d131dd3e€35.00€0.50matched
74capture01a1a73b-f97c-73dc-9526-0095be9eafe4€49.00€0.67matched
75capture01a1a73c-273f-7ccd-ad54-20efdd354ac1€35.00€0.50matched
76capture01a1a73c-2a3f-77d8-966c-03c5cc46b141€24.00€0.37matched
77capture01a1a73c-527e-7baa-9189-cce63eccf566€9.00€0.19matched
78capture01a1a73c-5f3b-70fe-9b94-dc327645e2a6€15.00€0.26matched
79capture01a1a73c-64bf-7e40-85b0-cfa082c2e6c7€9.00€0.19matched
80capture01a1a73c-6ebb-7b6e-84c3-0e9b1f9a8e41€24.00€0.37matched
81capture01a1a73c-820b-7cd3-b2ae-e7e639625a3f€24.00€0.37matched
82capture01a1a73c-85d4-7631-9e12-efc3a71ccf6c€9.00€0.19matched
83capture01a1a73c-8bcd-7f10-a0b4-0192e31bccd0€24.00€0.37matched
84capture01a1a73c-8e75-7863-91c4-6fb1faa674ed€49.00€0.67matched
85capture01a1a73c-c0c3-7fef-b4ff-2d72be79c250€15.00€0.26matched
86capture01a1a73c-c595-7bbe-b822-a2a9ea91bd1f€35.00€0.50matched
87capture01a1a73c-cf89-7539-9d2a-8a2d7b8f65f7€49.00€0.67matched
88refund01a1a73c-eb57-7cd0-9f40-d5bbad61ecb2-€16.00€0.00matched
89capture01a1a73d-03b0-71a1-a949-0713c70687a3€24.00€0.37matched
90capture01a1a73d-0b7d-714e-a3b4-88aaa4d75b17€9.00€0.19matched
91capture01a1a73d-1a96-7273-a837-bfcf769a7334€35.00€0.50matched
92capture01a1a73d-41d0-7358-b963-63c651d444fd€35.00€0.50matched
93capture01a1a73d-53a9-7a13-a2db-8b8c5a10b7e4€9.00€0.19matched
94capture01a1a73d-6f6b-7621-83e0-34ea3e651b2b€49.00€0.67matched
95capture01a1a73d-85c8-7349-977d-11373962eb00€24.00€0.37matched
96capture01a1a73d-876d-71c2-87a8-e29ca09737b7€9.00€0.19matched
97capture01a1a73d-b36d-785f-a72f-47b14952ae19€24.00€0.37matched
98capture01a1a73d-c296-7231-8cbe-5e56510cbbdb€24.00€0.37matched
99capture01a1a73d-d8e7-752d-a171-47033555e45f€24.00€0.37matched
100capture01a1a73d-e995-7dc9-9304-2ae5b0b79378€9.00€0.19matched
101capture01a1a73e-17aa-7fae-a238-ba50595151d7€15.00€0.26matched
102capture01a1a73e-3e9a-762f-9ccd-dfb4d04e44e6€24.00€0.37matched
103capture01a1a73e-6294-7edd-b971-4c0e8b20b436€15.00€0.26matched
104refund01a1a73e-668e-7b72-95c2-0b2f9cccd0fe-€23.00€0.00matched
105capture01a1a73e-6cbc-76e7-8f51-fc085c1c3323€9.00€0.19matched
106capture01a1a73e-9ae3-7c77-8054-5ae72339f68f€35.00€0.50matched
107capture01a1a73e-a6c2-7209-841e-afac7db1b080€35.00€0.50matched
108capture01a1a73e-b59b-7a4e-88f1-61a07a9994b5€24.00€0.37matched
109capture01a1a73e-c824-7849-ba46-c6043e372a42€24.00€0.37matched
110capture01a1a73e-e205-7681-a207-3948879bee27€15.00€0.26matched
111capture01a1a73e-e5ec-7bb6-ba49-c53f1f5e63ab€24.00€0.37matched
112capture01a1a73e-f171-7b4c-a26f-e1231ba033b0€9.00€0.19matched
113capture01a1a73f-0711-75fd-b6ef-cf5d34a37d4b€49.00€0.67matched
114capture01a1a73f-249f-7e66-bd66-c47ff48a5f7d€15.00€0.26matched
115capture01a1a73f-52a6-74fe-aaf7-7ff4dbd255e1€49.00€0.67matched
116refund01a1a73f-6e1f-713c-a0b3-742ecf812a3c-€23.00€0.00matched
117capture01a1a73f-6f15-7b3b-a5fd-ef050150d9c5€15.00€0.26matched
118capture01a1a73f-a1c9-7ef3-b86b-4fabd7d4db0f€24.00€0.37matched
119capture01a1a73f-c1b4-7a5b-8307-3119fd0233ba€9.00€0.19matched
120capture01a1a73f-d175-777f-8bfd-7d5d9aa09993€35.00€0.50matched
121capture01a1a73f-d467-7aa2-8553-93a6ed0c7e3e€35.00€0.50matched
122capture01a1a73f-e363-7bb1-9e8a-ca3c2075c396€15.00€0.26matched
123capture01a1a73f-ea27-7a06-a84b-0c0a4004320e€49.00€0.67matched
124capture01a1a73f-ec37-736c-9f40-3831cec8dec2€49.00€0.67matched
125capture01a1a740-0e3b-7426-a0db-5ecc9a7bc0e9€49.00€0.67matched
126capture01a1a740-122a-7113-8bfc-52f58a07737d€24.00€0.37matched
127refund01a1a740-24b9-776d-a229-11091ee7cdc5-€6.00€0.00matched
128capture01a1a740-8294-70bd-b8d6-0ba1d7c90f1a€35.00€0.50matched
129capture01a1a740-9c44-7c38-a1f1-9aafd8936537€24.00€0.37matched
130capture01a1a740-a397-734c-9b67-5d67a221bab6€15.00€0.26matched