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, 12:50

Gross

€2,992.00

PSP fee

€48.71

Net to the bank

€2,943.29

Settlement journal

#434759

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 42, the contract says 37
  • missing linein the books, not in the filecapture:01a1b610-fc55-7232-962c-4eeeefa2e51a is in no file
LineKindReferenceGrossFeeStatus
34capture01a1b611-03c6-786b-8ae1-d6d1529f2f08€24.00€0.42fee difference
1capture01a1b608-47e2-7ce6-9b9a-39a09adf3a8f€35.00€0.50matched
2capture01a1b60a-9e57-7593-a22a-b53d395692bb€9.00€0.19matched
3capture01a1b60f-260a-7f2b-8582-570c9261ced5€35.00€0.50matched
4capture01a1b60f-2bd6-786f-aa06-9fc1c26a9de6€49.00€0.67matched
5capture01a1b60f-2c43-7356-abb7-39b866ddcc8f€15.00€0.26matched
6capture01a1b60f-2f2c-75ae-8d7f-25a7ea37d877€24.00€0.37matched
7capture01a1b60f-3eaa-72bb-8072-6a4f938bc715€49.00€0.67matched
8capture01a1b60f-53dd-7dac-af7c-f33b7a6d2cb4€15.00€0.26matched
9capture01a1b60f-586e-7ea8-89ed-2b86b283e451€24.00€0.37matched
10refund01a1b60f-5ff3-78e1-ba2b-fb4dda42f76b-€33.00€0.00matched
11capture01a1b60f-786a-7d75-90d4-c48d903bb289€9.00€0.19matched
12capture01a1b60f-80b3-739f-87da-114f7635eb90€15.00€0.26matched
13capture01a1b60f-89ea-731a-909e-7d7ee087e059€15.00€0.26matched
14capture01a1b60f-9bb5-79dc-bc0f-9800d3dcee82€9.00€0.19matched
15capture01a1b60f-aa6b-70e4-ab65-a8a4767f81a5€24.00€0.37matched
16capture01a1b60f-af8d-7f02-818d-5d09a397456b€9.00€0.19matched
17capture01a1b60f-b913-790d-9dc8-b6b883a0792b€49.00€0.67matched
18refund01a1b60f-fcbf-76ba-b8bb-35a7b840106b-€15.00€0.00matched
19refund01a1b60f-fe01-7a94-97f1-6b073ff7e799-€9.00€0.00matched
20capture01a1b610-162f-7275-bfed-7076add2fe3a€15.00€0.26matched
21capture01a1b610-142a-78e6-9673-bda8b792b948€49.00€0.67matched
22capture01a1b610-556d-7948-abad-c23911815d02€15.00€0.26matched
23capture01a1b610-691a-7306-8248-2366c9825fa2€35.00€0.50matched
24capture01a1b610-6bcb-778b-b4ef-08f6d4dd5a61€24.00€0.37matched
25capture01a1b610-8cb8-7059-9037-0546d0ae64d6€24.00€0.37matched
26refund01a1b610-8f36-7d68-984e-4edbb630c41e-€29.00€0.00matched
27capture01a1b610-96d4-795b-ab49-e049b4b4a2a6€9.00€0.19matched
28capture01a1b610-992c-7104-9ca3-09c6e0fca4b3€49.00€0.67matched
29capture01a1b610-9b8a-7ec8-adff-a094c9fc68c1€24.00€0.37matched
30capture01a1b610-c6d1-7d20-8ef2-e89004a4326a€9.00€0.19matched
31capture01a1b610-c8c5-7e6c-9a02-da6835193942€24.00€0.37matched
32capture01a1b610-eefc-7167-87be-1c9ab33c5d6e€9.00€0.19matched
33capture01a1b610-f632-7794-acb4-1ba8d93671f8€15.00€0.26matched
35capture01a1b611-0687-70b6-8472-228ee4752f24€35.00€0.50matched
36capture01a1b611-1ed5-7c23-8987-4ece414d7aa2€35.00€0.50matched
37refund01a1b611-1f64-73de-b3ec-36e5197e5456-€12.00€0.00matched
38capture01a1b611-2b7f-789f-a880-6d77dfd50870€24.00€0.37matched
39refund01a1b611-37a9-7a58-8349-09ff644c6759-€32.00€0.00matched
40capture01a1b611-6e5b-7f84-b43d-c17075713871€9.00€0.19matched
41capture01a1b611-6f8e-7428-946b-bb7194b2c8b9€35.00€0.50matched
42capture01a1b611-7456-7f57-a512-ef136c91b89a€24.00€0.37matched
43capture01a1b611-74f1-73e1-9b54-efa1ce780d6f€15.00€0.26matched
44capture01a1b611-8831-7d7d-8a77-b685315c33ca€15.00€0.26matched
45capture01a1b611-9c9a-7d7c-8874-574bf1841a84€35.00€0.50matched
46capture01a1b611-b628-7011-af48-87c0cdd9af7d€49.00€0.67matched
47capture01a1b611-c4ac-7f0f-a84e-c7120cd2be74€15.00€0.26matched
48capture01a1b611-cc7c-79b9-a251-76a174be70d0€49.00€0.67matched
49capture01a1b611-d522-720b-9096-df21aef0fdc8€9.00€0.19matched
50capture01a1b611-ddc8-7a50-b7fd-8e9352eae4c6€15.00€0.26matched
51capture01a1b611-ec7a-77ac-b05d-e532b89e6948€24.00€0.37matched
52capture01a1b611-f79d-7efc-9df2-5dcd83995b52€9.00€0.19matched
53capture01a1b612-1057-73f6-bf0f-3e2da0d94039€49.00€0.67matched
54capture01a1b612-3d0b-7907-b258-25c27f14d814€49.00€0.67matched
55capture01a1b612-3dd0-76c1-9124-be0a705db27b€35.00€0.50matched
56capture01a1b612-4933-7cd8-9d51-e84a132fd553€49.00€0.67matched
57capture01a1b612-5356-7422-8a79-79bd373afd56€9.00€0.19matched
58capture01a1b612-7554-78d7-b0fb-cdc4b62033e7€35.00€0.50matched
59capture01a1b612-7882-7bec-870a-ad9aa5fb9e5e€35.00€0.50matched
60capture01a1b612-8641-783e-9ed1-910b7f3186c9€15.00€0.26matched
61refund01a1b612-aa7d-7c66-b685-7c3f5b72cdf0-€41.00€0.00matched
62refund01a1b612-aaf9-7239-a904-e96fe348ca4e-€2.00€0.00matched
63capture01a1b612-f26b-7e84-9f03-16719075998a€24.00€0.37matched
64capture01a1b613-113c-728e-9efd-108b8f436300€9.00€0.19matched
65capture01a1b613-3d24-7471-a924-852394cba740€49.00€0.67matched
66capture01a1b613-477a-7fc9-b577-f3860ce6d96e€49.00€0.67matched
67capture01a1b613-4ee6-7584-a887-96097c51c86b€49.00€0.67matched
68capture01a1b613-50b0-7ebf-a896-ded2b647b648€15.00€0.26matched
69capture01a1b613-53a4-7a06-9a34-725013bf257a€15.00€0.26matched
70capture01a1b613-5558-77dd-b6ea-21ad0b60564e€15.00€0.26matched
71capture01a1b613-40f1-7f0c-8be7-48d92b07d064€35.00€0.50matched
72capture01a1b613-67c5-7fca-a75d-3c121f10709f€9.00€0.19matched
73capture01a1b613-79d3-737d-ba29-3f5621a3b912€9.00€0.19matched
74capture01a1b613-841c-7352-bd72-fc04013d78ca€15.00€0.26matched
75refund01a1b613-8be6-7ed1-9f7a-80a68ab0ce7e-€10.00€0.00matched
76capture01a1b613-b832-753a-a2da-3ef6d3f5cafa€15.00€0.26matched
77capture01a1b613-c00e-7757-b71f-5adc8974cde9€24.00€0.37matched
78capture01a1b613-fa86-7736-9c6d-c5a607682a31€15.00€0.26matched
79capture01a1b613-fc98-76b9-a79d-0e7d555d4c11€49.00€0.67matched
80capture01a1b614-102d-7fe8-8c2d-21ee014f2fe7€15.00€0.26matched
81capture01a1b614-349d-7314-ae6e-1fe67d93a74c€9.00€0.19matched
82capture01a1b614-64aa-7fc1-bb3c-786378770461€49.00€0.67matched
83capture01a1b614-6504-74d2-b083-62daf7ab4ef6€24.00€0.37matched
84capture01a1b614-66d8-7cde-81a0-56d699560559€49.00€0.67matched
85refund01a1b614-72c8-7c19-929d-59f832af4f35-€13.00€0.00matched
86capture01a1b614-b3b0-7886-9f51-c4ef7a32df6a€24.00€0.37matched
87capture01a1b614-b6ec-72bc-8190-f63efea2bb69€35.00€0.50matched
88capture01a1b614-c755-7675-b985-d36883574d88€9.00€0.19matched
89capture01a1b614-e499-7f99-afe4-2cb08bc28de0€15.00€0.26matched
90capture01a1b614-ecf7-753e-af21-4b0a5770cb78€24.00€0.37matched
91capture01a1b614-f80d-7bf7-9667-f73e7332ecda€35.00€0.50matched
92capture01a1b614-fcb0-7730-bda1-d71de431683d€9.00€0.19matched
93capture01a1b615-04aa-7c66-ae20-e50e58acd790€24.00€0.37matched
94capture01a1b615-094b-71a1-a45a-6c1063f8821b€24.00€0.37matched
95capture01a1b615-3fed-751a-a7dc-69aa94fad85a€9.00€0.19matched
96capture01a1b615-5fd3-7cbe-9ec9-746d2f71e5ff€35.00€0.50matched
97capture01a1b615-9b7e-720b-b68a-beec1726d5b1€15.00€0.26matched
98capture01a1b615-a1d1-7d6d-9bea-aeb16a62fc3a€9.00€0.19matched
99capture01a1b615-a74a-7258-8cfb-d06d11223e4f€35.00€0.50matched
100capture01a1b615-c8e8-7c36-a520-36b3ff594cba€35.00€0.50matched
101capture01a1b615-cb18-78a8-a341-3a53f2f6efbd€35.00€0.50matched
102capture01a1b615-cbf7-73aa-9424-41bf61bc2063€49.00€0.67matched
103capture01a1b615-d153-78fc-88b3-45e171b78971€9.00€0.19matched
104capture01a1b615-d77a-7e1e-8980-c894996f0963€35.00€0.50matched
105capture01a1b615-e984-75f7-8f00-23d2339d5f5c€9.00€0.19matched
106capture01a1b615-e9c5-7f33-a4bf-63014791963e€35.00€0.50matched
107capture01a1b615-ecc2-7b40-87ae-ef75e66b4117€35.00€0.50matched
108refund01a1b616-08ed-7018-a846-4d798f5fd9ce-€21.00€0.00matched
109capture01a1b616-1f0e-777d-a08b-afe388a52525€49.00€0.67matched
110capture01a1b616-2434-7fc4-a0b6-343ceda89065€9.00€0.19matched
111capture01a1b616-381b-7b23-829e-d0ab959f56f9€15.00€0.26matched
112capture01a1b616-3abe-7cd8-9a9b-de741bf7999e€15.00€0.26matched
113capture01a1b616-4074-783d-9498-cac6a5b1b3ab€35.00€0.50matched
114capture01a1b616-57cc-7a44-820c-d3a732ff6ec9€24.00€0.37matched
115capture01a1b616-60ed-7950-8506-33499488ab87€9.00€0.19matched
116capture01a1b616-6746-7bba-acb2-cd32d68c1571€24.00€0.37matched
117capture01a1b616-7225-7749-ae98-ca7c1fdce8a9€24.00€0.37matched
118capture01a1b616-7937-7c7e-b640-90ba8a794d83€24.00€0.37matched
119capture01a1b616-a393-7e19-9be1-2793df003329€9.00€0.19matched
120capture01a1b616-acc7-7077-9f4a-a3848b6fd5fa€49.00€0.67matched
121capture01a1b616-c998-7886-b57e-b39fd655f49c€9.00€0.19matched
122capture01a1b616-ea99-79d0-8285-b5323767ab52€49.00€0.67matched
123capture01a1b616-fd5f-7968-9970-dff27df79a41€15.00€0.26matched
124capture01a1b617-0b8f-7ef0-81a3-ceecf3fae972€24.00€0.37matched
125capture01a1b617-4145-79d1-b42a-ef37925bf3aa€9.00€0.19matched
126capture01a1b617-46aa-79dd-8beb-1f0c1b6faebc€15.00€0.26matched
127capture01a1b617-4d11-7f56-89c3-eb5f841b40f1€49.00€0.67matched
128capture01a1b617-7ecf-72b4-a6ff-a66f41961cc7€35.00€0.50matched
129capture01a1b617-96ac-7cd7-a774-f6a7feeafd58€35.00€0.50matched
130capture01a1b617-c954-7d31-9610-e7aa042b95d3€35.00€0.50matched
131capture01a1b617-e951-74a4-a2c4-0378750a37e6€49.00€0.67matched
132capture01a1b617-f1f8-703c-af6e-8cb54d398034€24.00€0.37matched
133capture01a1b617-fad7-7f66-80cb-2c6118274fcc€9.00€0.19matched
134capture01a1b618-0c12-7a96-ac3f-e35dc3b24032€24.00€0.37matched
135capture01a1b618-10b6-70cb-9171-290e5ae379ed€24.00€0.37matched
136capture01a1b618-1a98-7e9e-8de9-c5d1ca982af7€49.00€0.67matched