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

2 Nov, 13:00

Gross

€3,385.00

PSP fee

€54.65

Net to the bank

€3,330.35

Settlement journal

#343244

Breaks for a person to look at

  • missing linein the books, not in the filerefund:01a19c5e-3a3b-7ba9-a470-b411c2379c00 is in no file
LineKindReferenceGrossFeeStatus
1capture01a19c4f-d4fa-7558-9473-e14d32152d32€24.00€0.37matched
2capture01a19c53-ff77-7879-bcf3-7dbfcc346525€15.00€0.26matched
3refund01a19c58-63d5-71da-8c37-81ef8726ce14-€9.00€0.00matched
4refund01a19c58-69b9-79ef-b393-8995893783ea-€30.00€0.00matched
5capture01a19c58-9461-79a6-910e-f357a2cc7ff1€35.00€0.50matched
6capture01a19c58-c2ce-7fbf-a7d7-aec9fad9a1a2€49.00€0.67matched
7capture01a19c58-dba5-7f9f-80d8-16bc38472c05€35.00€0.50matched
8capture01a19c58-f9eb-7e88-8074-3fe37ddeb198€15.00€0.26matched
9capture01a19c59-0f5d-7861-b74c-71c581f28b61€49.00€0.67matched
10capture01a19c59-14d2-79ef-b140-16d0fcdd2438€49.00€0.67matched
11capture01a19c59-219b-780a-8a6d-2944861e4081€24.00€0.37matched
12capture01a19c59-2834-7ba6-ad35-8c7b7b83080c€24.00€0.37matched
13capture01a19c59-56d0-7989-85bc-343f06eac1d7€15.00€0.26matched
14capture01a19c59-6105-7493-8f02-2d46e5e10504€15.00€0.26matched
15capture01a19c59-6912-793a-bf52-2e112df90470€49.00€0.67matched
16capture01a19c59-7f2b-7245-8a28-61940beced61€24.00€0.37matched
17refund01a19c59-8713-7b0d-8bf8-7827345de456-€26.00€0.00matched
18capture01a19c59-a20e-7822-9513-0c5584ba1490€9.00€0.19matched
19capture01a19c59-a52e-795a-8303-b3394690d436€15.00€0.26matched
20capture01a19c59-aab2-765d-a4d7-8e8b0237208f€49.00€0.67matched
21capture01a19c59-cc58-7465-8ac3-e4e715dd0318€49.00€0.67matched
22capture01a19c59-d588-7300-854f-a528fe5a8165€9.00€0.19matched
23refund01a19c59-d66c-7a93-8072-7f9a3da56e42-€23.00€0.00matched
24refund01a19c59-d7e4-78cc-893c-4a1a04ea6673-€27.00€0.00matched
25capture01a19c59-ec2f-7957-b3e3-9ea1b5536619€24.00€0.37matched
26capture01a19c59-f677-7c07-b75b-f32f35af7695€15.00€0.26matched
27capture01a19c59-fd7b-7761-957a-79fca98ecec3€35.00€0.50matched
28capture01a19c5a-02f2-75da-892c-92cdd6bb38eb€35.00€0.50matched
29capture01a19c5a-190e-7594-b277-dc901cb67f1c€15.00€0.26matched
30capture01a19c5a-1e41-71d0-bb1e-5a9d79ac616f€49.00€0.67matched
31capture01a19c5a-27f3-788d-bbd1-545a3612379c€35.00€0.50matched
32capture01a19c5a-2a67-791d-8237-c4b1c5f8842f€9.00€0.19matched
33capture01a19c5a-3351-770c-a11c-af562e835720€24.00€0.37matched
34capture01a19c5a-4abb-77b6-a7a3-6b8c797a8cc6€15.00€0.26matched
35capture01a19c5a-57ac-7bb9-8d8c-58137c9a36de€49.00€0.67matched
36capture01a19c5a-6d69-7c8c-ad0b-d532da547760€35.00€0.50matched
37capture01a19c5a-82dc-7d2c-b2cf-e1bf8bcc1406€35.00€0.50matched
38capture01a19c5a-9906-7f45-a7bb-912cd2530ed0€35.00€0.50matched
39capture01a19c5a-a453-77a2-a8a4-7afb8d15030e€15.00€0.26matched
40capture01a19c5a-a9be-790c-ab0e-c73088214b4b€24.00€0.37matched
41capture01a19c5a-af50-78ca-bb99-cc69e7b2d01d€49.00€0.67matched
42capture01a19c5a-ba2a-7aa9-9155-67852791d931€35.00€0.50matched
43capture01a19c5a-c777-7881-a9e4-d20a2916dfef€15.00€0.26matched
44capture01a19c5a-d4ed-7187-ab96-061db4f808bd€24.00€0.37matched
45capture01a19c5a-fb82-7799-a796-2bf21fbaf1b0€49.00€0.67matched
46capture01a19c5b-11a9-7c89-ac15-bb264cb055c9€35.00€0.50matched
47capture01a19c5b-1b61-718c-bb61-7edb6165b47d€35.00€0.50matched
48capture01a19c5b-20a2-7c62-b68f-f3d6fec6f37c€24.00€0.37matched
49capture01a19c5b-2f7d-750c-8814-861a087b7025€35.00€0.50matched
50capture01a19c5b-4be7-7e95-aa33-4bd688d3c04b€9.00€0.19matched
51capture01a19c5b-5670-7cd4-af8e-a4f759089eaa€24.00€0.37matched
52capture01a19c5b-5733-73b9-8a9e-b6ac7528e340€9.00€0.19matched
53refund01a19c5b-5c6c-7b0f-b1ea-ea6c3e0aa0b7-€35.00€0.00matched
54capture01a19c5b-6800-742d-84ca-d4d7ede16a3a€49.00€0.67matched
55capture01a19c5b-681d-7bb7-bdc0-04a7fd8e1360€24.00€0.37matched
56capture01a19c5b-6882-7fcf-8f37-f8b7c0b6a184€49.00€0.67matched
57capture01a19c5b-6e07-7644-9097-fdb40ba991cf€49.00€0.67matched
58refund01a19c5b-710c-711a-b638-2d4cac0d1f17-€14.00€0.00matched
59capture01a19c5b-97b6-7eb4-a1c0-eb756c84c817€35.00€0.50matched
60capture01a19c5b-a18a-76f8-a152-9fddab9e9d39€24.00€0.37matched
61capture01a19c5b-aa32-7108-aabc-80ab8ab7c703€24.00€0.37matched
62capture01a19c5b-b9e4-704f-a6f5-f69dbed087fe€24.00€0.37matched
63capture01a19c5b-bcf4-7fad-b4e1-785ec947a07d€9.00€0.19matched
64refund01a19c5b-d6eb-79cd-b005-326e8454941b-€12.00€0.00matched
65capture01a19c5b-e2b5-76b2-9856-d41103766fff€9.00€0.19matched
66capture01a19c5b-ed34-74d9-826d-ac87a8b2b065€35.00€0.50matched
67capture01a19c5c-0051-7cf2-85a9-62d1bd6dc18f€49.00€0.67matched
68capture01a19c5c-00da-7b82-91a7-96b4fad77c72€49.00€0.67matched
69capture01a19c5c-0109-7bb8-916e-78f3c36ddde9€35.00€0.50matched
70capture01a19c5c-0b19-7982-80fc-d6dabcf7c392€35.00€0.50matched
71capture01a19c5c-0e7f-74f2-828e-ebc64d9f4927€35.00€0.50matched
72capture01a19c5c-1a8e-76f7-8e06-f13a036182bf€9.00€0.19matched
73capture01a19c5c-3862-7984-a18c-5818ba331e83€24.00€0.37matched
74capture01a19c5c-4e1c-7de4-8861-10ef00aaee50€15.00€0.26matched
75capture01a19c5c-50ef-7916-865d-ef566235c5d2€15.00€0.26matched
76refund01a19c5c-551b-7f47-9f4e-52518b847b9b-€8.00€0.00matched
77capture01a19c5c-571d-78c3-b6a5-765e099ed882€24.00€0.37matched
78refund01a19c5c-5ffc-7409-823f-5b0d1c84c58e-€32.00€0.00matched
79capture01a19c5c-63e2-74e6-8b4d-1d3b20a5aca5€24.00€0.37matched
80capture01a19c5c-790c-7e02-98c0-1984623e6095€35.00€0.50matched
81capture01a19c5c-7a5b-7d54-9e7a-c2c09f78db46€24.00€0.37matched
82capture01a19c5c-c9e9-78b8-9792-57445be4046f€35.00€0.50matched
83capture01a19c5c-e604-7387-9952-cec8bb10b13e€9.00€0.19matched
84capture01a19c5c-ee36-7c93-be9d-bbd77ce445d9€35.00€0.50matched
85capture01a19c5d-0c02-7a6a-b09e-50e4ea761833€9.00€0.19matched
86capture01a19c5d-3347-768b-a1de-8abf2a560aaf€15.00€0.26matched
87capture01a19c5d-4b6e-7292-8865-667f10c39c11€9.00€0.19matched
88capture01a19c5d-4c81-7345-82c8-9163b12fbda8€24.00€0.37matched
89refund01a19c5d-7aa6-7a8b-bd71-681bf7e46122-€7.00€0.00matched
90capture01a19c5d-7d49-7d6c-acb7-763383e4ce78€24.00€0.37matched
91capture01a19c5d-ab4c-7331-8768-b35a29dec177€24.00€0.37matched
92capture01a19c5d-acb1-7e65-9c6e-246880f72bff€9.00€0.19matched
93capture01a19c5d-b473-7110-86a6-1033fd2ef938€15.00€0.26matched
94capture01a19c5d-deb2-7d7c-a6f2-78f725fb2ee1€35.00€0.50matched
95capture01a19c5d-df42-7a1e-bd36-db3ea047c3e8€9.00€0.19matched
96capture01a19c5d-e5b4-720c-b6b8-e1729d889f9f€9.00€0.19matched
97capture01a19c5e-0f52-7e42-9a8d-cd22cccc3e09€9.00€0.19matched
98capture01a19c5e-1ebd-760c-a16f-a6d998aa9b53€24.00€0.37matched
99capture01a19c5e-2726-712b-93f8-d057accf8333€9.00€0.19matched
100capture01a19c5e-31fc-7271-acc6-a5e6e297a130€9.00€0.19matched
101capture01a19c5e-3b84-7c8c-83a7-a34cf9558e45€49.00€0.67matched
102capture01a19c5e-7314-7d71-aa31-d92c4ee8c67c€49.00€0.67matched
103capture01a19c5e-7942-76d1-a66d-680d9626fbba€35.00€0.50matched
104capture01a19c5e-b4a7-750c-a889-a08f37d7748f€9.00€0.19matched
105capture01a19c5e-c4ab-7978-8001-7eb176c4ff75€49.00€0.67matched
106capture01a19c5e-ebcc-7f13-9bd8-63d15fe2c910€35.00€0.50matched
107capture01a19c5f-0058-79df-bfd7-37ce17f0eeb2€35.00€0.50matched
108capture01a19c5f-11b9-73f0-ac14-dd3ad3452575€24.00€0.37matched
109capture01a19c5f-14ec-73a2-a9fd-6b233bb101fc€15.00€0.26matched
110capture01a19c5f-1b02-7a4f-ba63-a780b987c842€9.00€0.19matched
111capture01a19c5f-274f-7fee-b890-09f7728b3552€49.00€0.67matched
112capture01a19c5f-2aac-7719-a7c7-339ab7a347e3€15.00€0.26matched
113capture01a19c5f-2f00-7816-8784-9d19a891476f€49.00€0.67matched
114refund01a19c5f-33cb-77b8-8c78-0b8726021082-€24.00€0.00matched
115capture01a19c5f-36f7-728b-90ca-cf1418a3a1d8€35.00€0.50matched
116capture01a19c5f-3975-756d-b62f-640e00a52f6b€49.00€0.67matched
117capture01a19c5f-4e23-7468-bbbc-f3e883b96ba0€35.00€0.50matched
118capture01a19c5f-5e0f-7372-82ec-ee10a5c50809€24.00€0.37matched
119capture01a19c5f-7201-7c50-ba28-ee4a0f099122€15.00€0.26matched
120refund01a19c5f-7859-74c2-be36-bcef2cd1317e-€22.00€0.00matched
121capture01a19c5f-7f79-784c-9b6d-3ed5e992dce9€49.00€0.67matched
122capture01a19c5f-aef2-7e20-b8d7-9f04ec5a0e24€9.00€0.19matched
123capture01a19c5f-d499-7f89-a557-5bb8225506a6€9.00€0.19matched
124capture01a19c5f-d659-7804-8a04-a090cee0c8d2€35.00€0.50matched
125capture01a19c60-17f9-7fae-9c38-5f67f4afce96€49.00€0.67matched
126capture01a19c60-18d4-75e1-a4d8-3d25771a615f€9.00€0.19matched
127capture01a19c60-2434-7474-806b-75201a77452c€49.00€0.67matched
128capture01a19c60-3209-7da4-ae0d-4093da966c15€15.00€0.26matched
129capture01a19c60-8b1d-71b5-b6e9-9b5058f21ce6€35.00€0.50matched
130capture01a19c60-9b7f-7f07-a6a3-1c52b8eab403€24.00€0.37matched
131capture01a19c60-c6f0-77a3-b58b-d7b51d4274a0€35.00€0.50matched
132capture01a19c60-d1e5-7929-b8ea-e95be8ded32d€9.00€0.19matched
133capture01a19c60-d2f4-7f57-b6ee-729c591af526€9.00€0.19matched
134capture01a19c60-f8d1-7a1c-b606-7450a8597cbf€15.00€0.26matched
135capture01a19c61-0175-7443-a3c6-96fb50b8eb1a€15.00€0.26matched
136capture01a19c61-0734-793a-a995-1b7ceb2095e4€49.00€0.67matched
137capture01a19c61-0b4b-79f1-82c9-e48f2c355f50€15.00€0.26matched
138capture01a19c61-1c45-70d4-995a-9b4694ba2129€24.00€0.37matched
139capture01a19c61-1c54-7f8a-8d5d-286ea64c53af€9.00€0.19matched
140capture01a19c61-1e7b-72e2-8287-820558083d17€9.00€0.19matched
141capture01a19c61-2554-7f3a-9949-c80edd0bbf93€49.00€0.67matched
142capture01a19c61-470a-75ab-9ac5-270e114e7ff9€49.00€0.67matched
143capture01a19c61-5611-76bb-8eed-0e1c9e998469€24.00€0.37matched
144capture01a19c61-5bdc-7989-8fe4-3084a348c74c€49.00€0.67matched
145capture01a19c61-7eba-7994-a889-ee8af3dd9e4f€35.00€0.50matched
146capture01a19c61-857b-79cd-ae1c-dfad441ed76f€35.00€0.50matched