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:10

Gross

€2,761.00

PSP fee

€46.21

Net to the bank

€2,714.79

Settlement journal

#401955

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

LineKindReferenceGrossFeeStatus
1capture01a1acdf-9a62-7c40-971c-ebbd192fd01f€15.00€0.26matched
2capture01a1ace4-8d79-7abb-995a-fbc16ff668be€49.00€0.67matched
3capture01a1ace7-4ac8-76e9-b129-84910a04ec3f€15.00€0.26matched
4capture01a1ace7-5421-7a27-8cce-48a58280d20e€9.00€0.19matched
5capture01a1ace7-7631-73b0-9982-d2243541d20e€9.00€0.19matched
6capture01a1ace7-8a2d-7e6f-bac3-0274f5ac3e5a€24.00€0.37matched
7capture01a1ace7-a0d1-738f-a893-6ec4017e6456€49.00€0.67matched
8refund01a1ace7-ad88-72d2-b818-107324be640b-€4.00€0.00matched
9capture01a1ace7-af6b-79d1-a234-9e87cc9c5031€49.00€0.67matched
10capture01a1ace7-cf27-7a87-beb6-a5bb1a08d73f€9.00€0.19matched
11capture01a1ace7-d0c3-7d22-9460-16e2ab1d6450€15.00€0.26matched
12capture01a1ace7-d0ca-7b3a-832b-a217dc302d2f€24.00€0.37matched
13refund01a1ace7-dbc3-794d-ab91-d8d6f178967e-€32.00€0.00matched
14capture01a1ace7-dc1e-7d64-b35e-fb62f6fca4cd€15.00€0.26matched
15capture01a1ace7-fb61-740c-b7a7-99fa47cbdc42€9.00€0.19matched
16capture01a1ace7-feec-73e1-88de-5c2722eb3205€24.00€0.37matched
17capture01a1ace8-02c9-7325-a587-aa14645036ab€15.00€0.26matched
18refund01a1ace8-0782-7744-a81f-e7c736e60f56-€27.00€0.00matched
19capture01a1ace8-0e1f-703a-a03a-84f21312305d€35.00€0.50matched
20refund01a1ace8-2eed-70b2-87a9-36d5e86d946b-€3.00€0.00matched
21capture01a1ace8-54c7-7623-b33c-52a8607cbbbe€49.00€0.67matched
22capture01a1ace8-a40d-738b-acef-5fd6fe7a7249€15.00€0.26matched
23capture01a1ace8-a975-7d21-879c-f6e141550db0€9.00€0.19matched
24capture01a1ace8-b147-7098-9f5f-c748cac1865f€49.00€0.67matched
25capture01a1ace8-b3f4-7a00-a059-0424ac73c948€9.00€0.19matched
26capture01a1ace8-c986-7c9f-8539-239b0af7c190€24.00€0.37matched
27capture01a1ace8-ce0f-7786-88c5-597ed1a1ba7a€24.00€0.37matched
28capture01a1ace8-da88-7255-a9a5-2eb6ede1dad9€15.00€0.26matched
29capture01a1ace8-e209-70b4-bbd8-4e2ac3cf51c9€9.00€0.19matched
30capture01a1ace8-f52d-7f34-a2db-606a509336a2€35.00€0.50matched
31refund01a1ace8-ff1c-7a86-ad20-85acbccb46ee-€23.00€0.00matched
32capture01a1ace9-0050-772b-932b-f04ff63fe0d0€35.00€0.50matched
33capture01a1ace9-0c19-7a16-86eb-3f0586e4d2d5€15.00€0.26matched
34capture01a1ace9-1e53-7fcb-809b-b2c9e513f518€9.00€0.19matched
35capture01a1ace9-2c98-75cc-81df-0c3f9713c1f5€24.00€0.37matched
36refund01a1ace9-606a-7db9-9d88-37a372df1f06-€8.00€0.00matched
37capture01a1ace9-6c79-7029-a2ca-d3542f891b8f€9.00€0.19matched
38capture01a1ace9-6de3-7d45-81bd-8e0482e35c72€9.00€0.19matched
39capture01a1ace9-6e44-7bf4-aa34-09a9ed5853c6€49.00€0.67matched
40capture01a1ace9-7721-7f29-b5c4-f968588c8fce€35.00€0.50matched
41capture01a1ace9-7d09-752e-894f-c32e3beb74c4€24.00€0.37matched
42capture01a1ace9-9f99-7627-b869-958c1bacd2a0€49.00€0.67matched
43capture01a1ace9-acae-74e6-a2e7-bab1185778c4€35.00€0.50matched
44capture01a1ace9-c8f1-7809-98ee-d7bd495732be€15.00€0.26matched
45capture01a1ace9-dd59-745e-9bab-f4f4ce3e7dcd€24.00€0.37matched
46refund01a1acea-05bf-7d3a-8e05-fc9df6705c8d-€19.00€0.00matched
47capture01a1acea-1cac-78a8-b3bf-423cd3f39426€24.00€0.37matched
48capture01a1acea-4df0-70a5-9cba-f878b8cd2554€15.00€0.26matched
49capture01a1acea-5938-74ca-aaa1-270ce4258216€35.00€0.50matched
50capture01a1acea-5b06-78c6-958a-ce31288a6c20€9.00€0.19matched
51capture01a1acea-67c1-77f5-87c2-231201787376€9.00€0.19matched
52capture01a1acea-80ec-784c-bae5-5f17c541858d€49.00€0.67matched
53capture01a1acea-88a9-70ed-950a-aaf1134e9780€24.00€0.37matched
54capture01a1acea-91d6-7f05-a386-b954f81bc051€49.00€0.67matched
55capture01a1acea-97b9-7681-a863-c2811b53cd60€49.00€0.67matched
56refund01a1acea-bd65-78a2-92ab-061f98fa0ce3-€31.00€0.00matched
57capture01a1acea-c1cd-76fe-a086-eff277b764f4€9.00€0.19matched
58capture01a1acea-c919-7636-80e2-107d75ee1b94€15.00€0.26matched
59capture01a1acea-cc53-78df-a212-f8f047fab7a1€15.00€0.26matched
60capture01a1acea-d0a1-76a3-ae71-c7051fae467a€15.00€0.26matched
61capture01a1acea-d262-76bf-afd3-0738a9551d00€9.00€0.19matched
62capture01a1acea-ffcc-7b90-94c4-d7863b54dd6c€49.00€0.67matched
63capture01a1aceb-0e62-7e42-afd2-083c95fd17f7€24.00€0.37matched
64capture01a1aceb-23f0-73c3-af17-39b27c59f2dd€24.00€0.37matched
65capture01a1aceb-33c9-796f-884f-167224f0f4be€24.00€0.37matched
66capture01a1aceb-3884-74e5-94de-bb07866ae582€49.00€0.67matched
67capture01a1aceb-419e-7027-af69-113295f27b7d€9.00€0.19matched
68refund01a1aceb-9834-7ac0-a3ed-0d5c4133b4e3-€13.00€0.00matched
69capture01a1aceb-9cda-7320-b149-d9ea04374c9d€9.00€0.19matched
70capture01a1aceb-b976-7b81-978f-8fdcd978cc01€35.00€0.50matched
71capture01a1aceb-c395-7720-ba93-5eb21060c917€9.00€0.19matched
72capture01a1aceb-e541-72d5-99d4-81f60c54fe1c€15.00€0.26matched
73capture01a1aceb-fdc6-7361-bd09-8414b557a708€35.00€0.50matched
74capture01a1acec-030e-7e43-b853-6905193c7712€49.00€0.67matched
75capture01a1acec-179f-7915-9359-d5573b685605€15.00€0.26matched
76capture01a1acec-36a6-768a-ab35-bcc93081f249€49.00€0.67matched
77capture01a1acec-38c2-7cfe-9408-ba4af6d09217€24.00€0.37matched
78capture01a1acec-4953-71c3-abd6-a9931c12c363€24.00€0.37matched
79capture01a1acec-5b13-7f4b-ac5f-5833e2f7a7e2€35.00€0.50matched
80capture01a1acec-5d3b-7c5b-837c-660737c4fb7f€24.00€0.37matched
81capture01a1acec-5fa9-7907-8674-480d1ab49d54€49.00€0.67matched
82capture01a1acec-6666-701e-a0a3-884192c6534b€35.00€0.50matched
83capture01a1acec-6dcb-72fb-a727-0f5b454d8636€24.00€0.37matched
84capture01a1acec-6f6a-7270-bb52-723840ce5b93€15.00€0.26matched
85capture01a1acec-7177-73e9-ac47-649cb0d2d9d5€35.00€0.50matched
86capture01a1acec-7348-77ac-a2d1-710b9688278e€9.00€0.19matched
87capture01a1acec-8796-7f94-8eef-b94bdd4aa507€9.00€0.19matched
88refund01a1acec-bcaa-75f2-8945-f883b994c5d0-€10.00€0.00matched
89capture01a1acec-baba-7cbb-8ace-81c3583aae1c€24.00€0.37matched
90capture01a1acec-ea34-7115-874e-8d3c9bd6d119€24.00€0.37matched
91refund01a1acec-ed59-7202-a7cb-631a965f74a6-€4.00€0.00matched
92capture01a1acec-ed9e-7412-85b1-9a4f41c13dd8€49.00€0.67matched
93capture01a1aced-1d6b-74c6-8041-251aded43794€24.00€0.37matched
94capture01a1aced-28b1-7e18-84e9-a47bd8934299€9.00€0.19matched
95capture01a1aced-3c93-702d-a8f7-be1fab55e8f0€49.00€0.67matched
96capture01a1aced-4ea9-727e-bec3-2493827c1bd7€24.00€0.37matched
97capture01a1aced-87a9-7cab-9e1d-7360b0886d4b€24.00€0.37matched
98capture01a1aced-d597-7648-9914-8364de49aeba€49.00€0.67matched
99capture01a1aced-f709-7f69-aee6-40dcfb9e5c36€35.00€0.50matched
100capture01a1aced-fa0d-7317-969a-8e65b2d6bc8a€35.00€0.50matched
101capture01a1acee-02b9-7f7e-aac4-c7e011f3f699€15.00€0.26matched
102refund01a1acee-1046-73b5-a6a2-e0a13f5f1ff8-€31.00€0.00matched
103capture01a1acee-2def-7734-a7e2-35e759caaf7e€9.00€0.19matched
104capture01a1acee-30b8-74db-b3d1-849315dcc783€24.00€0.37matched
105capture01a1acee-4b22-7319-b6d6-6fdffcdfd1e0€24.00€0.37matched
106capture01a1acee-5d91-74cc-a7ae-32ed7059e353€24.00€0.37matched
107capture01a1acee-7161-78a3-8c93-7a9e69f09100€15.00€0.26matched
108capture01a1acee-b7fa-7c9f-9036-343285fd78bc€9.00€0.19matched
109capture01a1acee-c7b5-7a80-a1c1-0bed7cfdf3b9€15.00€0.26matched
110capture01a1acee-cc82-7730-875e-dff8761d6a56€9.00€0.19matched
111capture01a1acee-d2aa-7fd1-b0dc-cd9ba1276ef9€49.00€0.67matched
112capture01a1acee-ed70-73e6-b3d7-952a39292419€24.00€0.37matched
113capture01a1acee-f318-774d-9063-cf7f4fc91eb7€15.00€0.26matched
114capture01a1acee-f869-788d-80a0-17ed4ddc0047€35.00€0.50matched
115capture01a1acee-fca2-7b8a-8588-e9d40623f717€35.00€0.50matched
116capture01a1acef-09d7-765e-b5ef-40fc1e0873de€49.00€0.67matched
117capture01a1acef-0b56-7cc7-a56d-30f9410e5f9e€9.00€0.19matched
118capture01a1acef-12da-74a9-8033-993d2fd4f361€15.00€0.26matched
119capture01a1acef-1ffc-7d51-a0ff-3cee0cb7c9a9€24.00€0.37matched
120capture01a1acef-2a59-7def-82ff-3a2e8cf33cb8€24.00€0.37matched
121capture01a1acef-36ee-73d7-9597-e452d387f566€9.00€0.19matched
122refund01a1acef-4372-748d-911c-e0df8e81f5c8-€11.00€0.00matched
123capture01a1acef-4cc2-7e07-8821-0b2c8e147cec€35.00€0.50matched
124capture01a1acef-70c7-7b38-a270-8afcadec9e35€15.00€0.26matched
125refund01a1acef-734d-741d-9c0c-d714676dfa33-€19.00€0.00matched
126capture01a1acef-8789-7ee6-a9a1-4afc2ec999b7€9.00€0.19matched
127capture01a1acef-9683-70ab-9599-376f3fdd43dd€9.00€0.19matched
128capture01a1acef-9fa3-74ef-b277-0c7e92abc045€9.00€0.19matched
129capture01a1acef-a096-7347-865a-7847484f29b0€9.00€0.19matched
130capture01a1acef-b51b-789f-b974-b8ab19655f1d€15.00€0.26matched
131capture01a1acef-be80-7161-b1d2-70b072cb6f9c€35.00€0.50matched
132capture01a1acef-c433-7d32-8181-d87e14e5b609€35.00€0.50matched
133capture01a1acef-d02e-7208-8ca8-316c769bc6b6€35.00€0.50matched
134capture01a1acef-d782-7015-a85b-61c7291fba01€24.00€0.37matched
135refund01a1acef-de73-7556-bac8-a082b52d008a-€8.00€0.00matched
136capture01a1acef-f762-7b9b-985e-e3060e48c815€9.00€0.19matched
137capture01a1acef-feba-72b0-b440-08a3376d2eda€9.00€0.19matched
138capture01a1acf0-024a-7a6e-85ba-d677c895467a€15.00€0.26matched
139capture01a1acf0-0298-7c1d-b0dc-09ab1a9fe562€15.00€0.26matched
140capture01a1acf0-4449-70d9-a725-197abbbd26c9€9.00€0.19matched