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

6 Nov, 10:40

Gross

€3,586.00

PSP fee

€54.97

Net to the bank

€3,531.03

Settlement journal

#414673

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

LineKindReferenceGrossFeeStatus
1capture01a1b06e-32c0-731c-b727-af35c0762730€24.00€0.37matched
2capture01a1b071-da13-76d0-bcad-d2cba631748e€9.00€0.19matched
3capture01a1b071-dbec-7f5c-bc66-6fa49be32cef€49.00€0.67matched
4capture01a1b071-f487-7fb2-ba1b-cb3bb8e2186c€24.00€0.37matched
5capture01a1b071-f70e-7089-b6dd-62c851f6e823€49.00€0.67matched
6capture01a1b072-0a4c-76e2-8961-ac1932d4b8df€15.00€0.26matched
7capture01a1b072-0c1b-7d75-a864-51979c1ef2e6€15.00€0.26matched
8capture01a1b072-1885-727c-9f94-6c2e7c1599fc€35.00€0.50matched
9capture01a1b072-2e16-787c-8233-fac34c15ac3d€9.00€0.19matched
10capture01a1b072-3157-7e71-8a6b-ce4fcbd62834€35.00€0.50matched
11capture01a1b072-466d-7e42-9145-6508e4a8e482€35.00€0.50matched
12capture01a1b072-5b7d-7879-b275-67d4648ee0da€9.00€0.19matched
13capture01a1b072-653f-7771-8b09-6e288365c910€49.00€0.67matched
14capture01a1b072-7259-7b7a-baaf-28e47ce91810€15.00€0.26matched
15capture01a1b072-8277-7f48-b960-6e04bdeeff13€49.00€0.67matched
16capture01a1b072-9da6-7a45-aa20-f0d43afed758€9.00€0.19matched
17capture01a1b072-a0f5-7ec9-ae4d-2e7738d805a8€49.00€0.67matched
18capture01a1b072-ae02-76ef-9bb4-884dba3db00b€35.00€0.50matched
19capture01a1b072-b672-737b-b398-1a78c53f1502€9.00€0.19matched
20capture01a1b072-c8ad-77d3-88bc-22a0b2ae4646€49.00€0.67matched
21capture01a1b072-e0dd-72bd-957d-f9e0e1d242ba€35.00€0.50matched
22capture01a1b072-f211-79c4-bc04-7da5707f101e€49.00€0.67matched
23capture01a1b072-f52c-72db-9aec-b5ed33dd454f€9.00€0.19matched
24capture01a1b072-ea13-7900-b1e8-696c4ef8c1b3€35.00€0.50matched
25refund01a1b073-13a7-7d0a-a77d-62005fe4643a-€26.00€0.00matched
26capture01a1b073-1aa4-7466-b3da-7aec7d34a301€24.00€0.37matched
27capture01a1b073-2b1f-7422-8f2d-043a2ec5435e€49.00€0.67matched
28capture01a1b073-3694-7f6f-831a-88ff7e1189a8€49.00€0.67matched
29capture01a1b073-40d3-7da5-a12e-802764a62bf3€9.00€0.19matched
30capture01a1b073-5b5b-7fd5-9e5a-4e0bad1ffd42€35.00€0.50matched
31capture01a1b073-5cba-7324-9304-0fc5504cb820€35.00€0.50matched
32capture01a1b073-621a-76da-b276-e6ba51874995€15.00€0.26matched
33capture01a1b073-9ed8-76ed-aace-07f8d3d7a12b€49.00€0.67matched
34capture01a1b073-a390-7362-97b1-bc1d0ee6db3b€15.00€0.26matched
35capture01a1b073-cfa3-76da-8c5b-8447fc8fa57d€35.00€0.50matched
36capture01a1b073-d0b8-7240-9102-6ad0f3f3af25€15.00€0.26matched
37capture01a1b074-1eb3-756b-908b-3c7b8b5b75cf€49.00€0.67matched
38capture01a1b074-27d5-7a13-892b-f42f5542d008€24.00€0.37matched
39capture01a1b074-3858-7285-80f7-966eaf6a67c8€9.00€0.19matched
40refund01a1b074-609c-7746-a83c-5f0d79436a53-€33.00€0.00matched
41capture01a1b074-6563-75f9-b997-827848f7f5ed€49.00€0.67matched
42capture01a1b074-95f7-721c-a7a5-454f8226da91€24.00€0.37matched
43capture01a1b074-a5c5-7268-8213-12480ab38685€24.00€0.37matched
44capture01a1b074-a828-7534-b6ac-735de797881b€49.00€0.67matched
45capture01a1b074-aa9d-7e46-88fe-54b2c1ac52af€9.00€0.19matched
46capture01a1b074-bcc2-7d1d-b19a-069bc628e773€35.00€0.50matched
47capture01a1b074-cbf0-77e7-9999-37eb4e89c503€24.00€0.37matched
48capture01a1b074-d66f-7310-abc5-ddf20a2c98ee€15.00€0.26matched
49capture01a1b074-ed0f-73a5-a72a-6ee3fd83394c€35.00€0.50matched
50capture01a1b074-ed8e-7c52-84aa-2038ff2ad08b€15.00€0.26matched
51capture01a1b074-f100-7bde-b968-924153837e4f€15.00€0.26matched
52capture01a1b075-09e8-7989-8e76-d806bc45c41f€49.00€0.67matched
53refund01a1b075-09f4-74d0-b072-7308d3297d71-€18.00€0.00matched
54refund01a1b075-14ac-787d-bfec-c2f8f59f34f4-€8.00€0.00matched
55capture01a1b075-1ad1-77e3-839c-cc06d0aa91c4€15.00€0.26matched
56capture01a1b075-315c-7967-ac7c-1aaa8302eb58€24.00€0.37matched
57capture01a1b075-3a02-7ea5-a97b-aecd2dc02739€49.00€0.67matched
58capture01a1b075-3c64-76da-b3cf-25936e59ee85€35.00€0.50matched
59capture01a1b075-835d-7562-897f-7e4e4e92c279€35.00€0.50matched
60capture01a1b075-8e10-79bc-8c18-743f2f86c01d€49.00€0.67matched
61capture01a1b075-8e60-7ffc-be6b-040f4c049199€24.00€0.37matched
62capture01a1b075-a00b-7c5a-8325-68bd27067ef0€49.00€0.67matched
63capture01a1b075-a97b-7b1b-8ffc-c3bcb6b883ee€24.00€0.37matched
64capture01a1b075-b118-7c19-b2f8-3808ca4d33ab€24.00€0.37matched
65capture01a1b075-b15c-70af-85ee-93de9ad0e134€9.00€0.19matched
66capture01a1b075-b3ed-771f-8c94-fe0244029fd7€35.00€0.50matched
67capture01a1b075-bd89-7f4c-9fc4-903bfb50c0fe€35.00€0.50matched
68capture01a1b075-bf56-7294-a975-010ef98cb53b€24.00€0.37matched
69capture01a1b075-c1ff-7334-8fef-ee3a573e6a1b€15.00€0.26matched
70capture01a1b076-07f9-773d-a1b6-221c350a27dc€9.00€0.19matched
71capture01a1b076-10f9-7da4-84e8-a279c06903e3€24.00€0.37matched
72capture01a1b076-1b2e-7a07-a8d3-7e8d00d154a9€49.00€0.67matched
73capture01a1b076-1b69-7f41-952d-90edb3d61704€24.00€0.37matched
74capture01a1b076-47b0-7a86-ba7e-4bc7a503158a€15.00€0.26matched
75capture01a1b076-4829-70d7-a5ae-26367fcf78b3€49.00€0.67matched
76capture01a1b076-6cde-703c-bc17-c33dd1224cc7€49.00€0.67matched
77capture01a1b076-af36-7f07-9417-8b307a8e2506€24.00€0.37matched
78capture01a1b076-b0b1-7022-8b30-64b6135f1777€24.00€0.37matched
79capture01a1b076-b604-723e-a1e0-735d7879a8b8€15.00€0.26matched
80capture01a1b076-d669-730e-9e76-ca730196a645€49.00€0.67matched
81capture01a1b076-e05f-7de7-976b-cb02e3854786€24.00€0.37matched
82capture01a1b076-f5b2-7f5e-b821-52e1116606f6€15.00€0.26matched
83capture01a1b076-f80a-7cd1-bff6-e37ef209d5d3€49.00€0.67matched
84capture01a1b077-200e-78b2-b938-ef88af436e39€15.00€0.26matched
85capture01a1b077-2ed7-7780-a6f5-2507b9bbae54€24.00€0.37matched
86capture01a1b077-3078-779e-b30d-0245f59617b0€15.00€0.26matched
87capture01a1b077-56ec-72e0-a854-783aca95aefc€15.00€0.26matched
88capture01a1b077-6b23-7c0a-b945-b6db0e0c4c31€49.00€0.67matched
89capture01a1b077-79c6-7b69-9104-e2ce933434dd€9.00€0.19matched
90capture01a1b077-a990-7dfc-a856-d82e13c2cc8a€35.00€0.50matched
91refund01a1b077-b3d8-7c18-8452-35ec9cbfe45f-€5.00€0.00matched
92capture01a1b077-c1f9-72df-902c-6b396cd96ae0€49.00€0.67matched
93capture01a1b077-d0bb-7867-a85d-1af94ec48ff9€15.00€0.26matched
94capture01a1b077-d5aa-7848-b0cf-e08ba5275f03€15.00€0.26matched
95capture01a1b077-ef30-7a3b-a590-8e13a4dc3fb6€35.00€0.50matched
96capture01a1b077-f2a6-7096-ae30-b2803c3e018e€24.00€0.37matched
97capture01a1b077-facb-7143-97a3-7cdf6ddd04d9€15.00€0.26matched
98capture01a1b077-fbc6-7dd6-bcca-ed932e3d12b6€49.00€0.67matched
99capture01a1b077-fef2-7a0b-ba7a-16b58bc4ba04€49.00€0.67matched
100capture01a1b078-1e90-7d9a-ae7e-3e36ee0bb785€35.00€0.50matched
101capture01a1b078-319b-768a-963b-09567fb40878€49.00€0.67matched
102capture01a1b078-33b2-7dee-8aed-3bbc3a9ec6f9€49.00€0.67matched
103capture01a1b078-3433-7986-bd58-11ac9f440870€15.00€0.26matched
104capture01a1b078-554b-7cc7-bbdd-c875065515eb€15.00€0.26matched
105capture01a1b078-65f6-7a89-8f26-013ee8231477€15.00€0.26matched
106capture01a1b078-7387-7589-85f8-c173f1f5e320€35.00€0.50matched
107capture01a1b078-d74d-7135-9a1e-07e61f162965€49.00€0.67matched
108capture01a1b078-e2d5-7ed3-a58f-fe52aa5d7245€15.00€0.26matched
109capture01a1b078-e82f-7ca7-9295-73eda26d2590€49.00€0.67matched
110capture01a1b079-0335-72e1-8ad9-c74c07102928€15.00€0.26matched
111capture01a1b079-1fe3-7dd4-9c98-10ed74a24ddf€15.00€0.26matched
112capture01a1b079-4782-7a80-b7bf-2aef6c55fcd2€49.00€0.67matched
113capture01a1b079-4c19-7c58-bb1f-d779f409188a€9.00€0.19matched
114capture01a1b079-54f1-7027-8749-3fe6d50f010b€9.00€0.19matched
115capture01a1b079-550a-743c-800e-7eeb61c960b6€35.00€0.50matched
116capture01a1b079-6dfd-71eb-b564-3d2c32ac2f53€15.00€0.26matched
117capture01a1b079-a376-760f-a86d-15f4e2956ff5€15.00€0.26matched
118capture01a1b079-accb-723c-bd20-aade679fb1e3€35.00€0.50matched
119capture01a1b079-ba96-759c-812e-82e2e57dcf94€24.00€0.37matched
120capture01a1b079-d63f-77f0-bb62-2276b533b564€24.00€0.37matched
121capture01a1b079-e598-7c9f-8dc7-ef9b47f96670€9.00€0.19matched
122capture01a1b07a-0970-79e7-8b69-ee37dcd9d693€15.00€0.26matched
123capture01a1b07a-23cf-7819-9bb8-cfcb23f3e95b€15.00€0.26matched
124capture01a1b07a-295b-7cc2-ae46-db311e288d72€9.00€0.19matched
125refund01a1b07a-3082-7ea1-8283-3b7e626925be-€19.00€0.00matched
126capture01a1b07a-3b6e-7b1c-b313-5f2a9ad07d23€15.00€0.26matched
127capture01a1b07a-3f77-7d06-8f86-7e19e327b245€49.00€0.67matched
128capture01a1b07a-439f-7b68-8708-6c593853ae40€15.00€0.26matched
129capture01a1b07a-4468-7004-b535-0896d63d45b9€35.00€0.50matched
130capture01a1b07a-5973-7462-ad85-a680582d7f1b€24.00€0.37matched
131capture01a1b07a-67e9-7de3-bd03-e44c40d91058€9.00€0.19matched
132capture01a1b07a-69c4-7e22-9671-1dbdfb40ad0f€15.00€0.26matched
133capture01a1b07a-6b1d-7580-9aba-66cae5f27251€35.00€0.50matched
134capture01a1b07a-7355-714a-b12b-d87c5705dcb1€24.00€0.37matched
135capture01a1b07a-92b8-7ebc-84f9-9a214dfcc1ed€49.00€0.67matched
136capture01a1b07a-b451-7496-a84a-36b2a1371e34€49.00€0.67matched
137capture01a1b07a-ca77-719c-a9ce-e115a0b9fadd€24.00€0.37matched