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, 09:20

Gross

€3,154.00

PSP fee

€49.72

Net to the bank

€3,104.28

Settlement journal

#340422

Breaks for a person to look at

  • missing linein the books, not in the filecapture:01a19b93-0036-7879-ae74-05c17f04be2a is in no file
LineKindReferenceGrossFeeStatus
1capture01a19b87-7760-74a9-a21c-89e8a6e2b84f€9.00€0.19matched
2capture01a19b89-68de-7fb2-a3c0-8d83f19d6f6e€15.00€0.26matched
3capture01a19b8b-e8ef-7f1c-969f-8347eab78dd4€9.00€0.19matched
4refund01a19b8d-3d9f-7711-af11-fe6509f53207-€8.00€0.00matched
5capture01a19b8f-1130-701e-9a4e-8289d7b994f1€15.00€0.26matched
6capture01a19b8f-1e6a-7625-a366-989ef0fa4442€24.00€0.37matched
7capture01a19b8f-2670-7b37-8ed9-6e85b43de405€49.00€0.67matched
8refund01a19b8f-29f3-718e-80b0-5237cd76ca09-€8.00€0.00matched
9capture01a19b8f-33bd-787a-b970-0b12b789c98f€35.00€0.50matched
10capture01a19b8f-49a2-7fac-8cdc-e72ac6cf6bfe€15.00€0.26matched
11refund01a19b8f-4f8f-75b7-bd1c-65d69892c8f0-€4.00€0.00matched
12capture01a19b8f-6a4d-7143-bc97-45ec45ee5cba€49.00€0.67matched
13capture01a19b8f-7fc2-75db-aaba-733cb449647c€35.00€0.50matched
14capture01a19b8f-87f6-7471-a7ff-85c13555a9ae€49.00€0.67matched
15capture01a19b8f-91b1-765e-9ddf-d5f9da48d147€35.00€0.50matched
16capture01a19b8f-a0ab-7a31-871f-4d9cbe7ad6bd€24.00€0.37matched
17capture01a19b8f-a0f8-7199-bde9-3de3dd2d05a7€24.00€0.37matched
18capture01a19b8f-a4eb-793a-8895-fddd6de74c47€24.00€0.37matched
19refund01a19b8f-c943-752b-904e-00e1a46325e3-€14.00€0.00matched
20capture01a19b8f-cccd-7bbe-a5bf-72b60e6859d9€24.00€0.37matched
21capture01a19b8f-d2d7-766d-a860-8fcc2763070e€24.00€0.37matched
22capture01a19b8f-f0ed-7e10-b9a7-5cd8493b7f1e€15.00€0.26matched
23capture01a19b8f-fbbb-772e-b600-6a305a82dd76€49.00€0.67matched
24capture01a19b8f-ff56-780a-a62f-c19815692760€49.00€0.67matched
25capture01a19b90-0a5c-76d9-8156-5130f014de12€15.00€0.26matched
26capture01a19b90-1ed8-70e1-87ff-86c6b37c7793€35.00€0.50matched
27capture01a19b90-24a7-7547-b045-95f0b8f9c22e€35.00€0.50matched
28capture01a19b90-6598-7010-ba21-32da269a3f84€9.00€0.19matched
29capture01a19b90-adfd-7972-a07c-39f485e65dd2€15.00€0.26matched
30capture01a19b90-bc33-7d93-90ab-8f75fd9b631e€49.00€0.67matched
31capture01a19b90-fa77-74e9-9824-4a39b196e20b€35.00€0.50matched
32capture01a19b91-0fab-777d-8344-19b8190c0eef€9.00€0.19matched
33capture01a19b91-1506-77d5-bdc2-80822f5ad948€35.00€0.50matched
34capture01a19b91-1ef2-7d80-bd71-0d8ae83e6dc3€9.00€0.19matched
35capture01a19b91-22bb-7986-9e07-5e0da31d5ccc€15.00€0.26matched
36capture01a19b91-2d8a-7ca3-8215-b25fa4dd910e€24.00€0.37matched
37capture01a19b91-52a1-7005-98e2-8156aef039f1€15.00€0.26matched
38capture01a19b91-5407-74aa-9a62-48562b7a7bd7€35.00€0.50matched
39capture01a19b91-5732-76fa-a758-5bd111f9a83a€15.00€0.26matched
40capture01a19b91-6023-7aa3-9e85-b0a2efa767b3€49.00€0.67matched
41capture01a19b91-7229-72dc-aafb-16e14709f893€49.00€0.67matched
42capture01a19b91-801c-743e-a252-be4cba77c973€15.00€0.26matched
43capture01a19b91-8e2c-7c5f-91d3-1e0a75704f7e€24.00€0.37matched
44capture01a19b91-8f87-7625-9a0d-94716e9e1010€9.00€0.19matched
45refund01a19b91-91c0-7dbb-a307-faf604c8e614-€11.00€0.00matched
46capture01a19b91-9996-7c9b-86a3-f11390046581€24.00€0.37matched
47capture01a19b91-ad88-7ef8-b2f5-b58787661e1e€35.00€0.50matched
48refund01a19b91-c482-700f-9276-04827c1babf0-€13.00€0.00matched
49capture01a19b91-cc1b-7477-817a-af25322f394d€35.00€0.50matched
50capture01a19b91-da09-7407-aeec-da6335c092e7€15.00€0.26matched
51capture01a19b91-dbdc-73ad-a539-69e6c8e64ac0€15.00€0.26matched
52capture01a19b91-ecc4-7468-a7bf-e0ec19b5fdac€15.00€0.26matched
53capture01a19b92-0852-7c14-a128-8ae4ea01f1d1€15.00€0.26matched
54capture01a19b92-2cd0-7db1-b165-f2f424e9ce41€9.00€0.19matched
55capture01a19b92-6095-73cc-92df-81ed9eebb713€15.00€0.26matched
56capture01a19b92-60cf-7d9c-b055-d29ac04c1c05€15.00€0.26matched
57capture01a19b92-63c0-7dd4-91cc-560f7f44e9b1€35.00€0.50matched
58capture01a19b92-6950-71ac-8a56-7af8a7140fb0€35.00€0.50matched
59capture01a19b92-7619-702f-b730-df2678130f5a€9.00€0.19matched
60capture01a19b92-84b9-7884-a9e9-eb71639549df€35.00€0.50matched
61capture01a19b92-8583-763c-a62c-446d516c8f36€9.00€0.19matched
62capture01a19b92-8852-7e98-8b55-d7eed11b7eeb€24.00€0.37matched
63capture01a19b92-8879-7e71-8fc0-57b79c5a8ad5€9.00€0.19matched
64capture01a19b92-8d40-7d9c-94c4-46ad4c14004d€49.00€0.67matched
65refund01a19b92-d33b-78bc-a758-ccbad33da047-€15.00€0.00matched
66capture01a19b92-de10-75e9-9b5b-25d42003e91a€49.00€0.67matched
67capture01a19b92-f80e-7986-bd41-d48c16d8f2e1€9.00€0.19matched
68capture01a19b93-09e1-7347-9196-5533407def0b€15.00€0.26matched
69capture01a19b93-13b1-766c-a471-a866e84ce414€49.00€0.67matched
70capture01a19b93-4e67-74df-8699-8972572020e3€24.00€0.37matched
71capture01a19b93-586c-750f-9d45-2931e11f5f4a€49.00€0.67matched
72capture01a19b93-5d9b-7e55-90e0-f2b0f8626f4c€24.00€0.37matched
73refund01a19b93-6429-7f55-85f2-c847322c982e-€5.00€0.00matched
74capture01a19b93-6b24-71c9-943b-3dbd49dec428€24.00€0.37matched
75capture01a19b93-6b22-727f-8431-a5bd3467a5cf€9.00€0.19matched
76capture01a19b93-9e0e-7101-84e2-852227cdacb0€24.00€0.37matched
77capture01a19b93-9fd7-759b-b3d7-38c177e8c44c€24.00€0.37matched
78capture01a19b93-a601-7a07-92dd-aa58371d8c2c€49.00€0.67matched
79capture01a19b93-a989-7537-bd1e-74157582a49d€24.00€0.37matched
80capture01a19b93-d514-7a4c-840f-357e0336e4fa€15.00€0.26matched
81capture01a19b93-dc84-7887-afd2-8c6804690426€49.00€0.67matched
82capture01a19b93-e071-76b1-8d28-9f7b6ea8e03e€9.00€0.19matched
83capture01a19b93-e0a0-7577-aba2-ebc8b292026e€24.00€0.37matched
84capture01a19b93-f90f-7ea7-a792-3b077d255c98€35.00€0.50matched
85capture01a19b94-125d-7092-83ee-956701746e96€24.00€0.37matched
86refund01a19b94-15f3-7969-8cd7-e864fc45a6bc-€10.00€0.00matched
87capture01a19b94-17c7-7e67-89cb-798444996803€24.00€0.37matched
88capture01a19b94-2547-7766-b178-0b2e2d81c9d3€15.00€0.26matched
89capture01a19b94-3da3-7170-8530-c30495b3e9e3€9.00€0.19matched
90capture01a19b94-6c3c-7a04-839b-df2a3f5de27a€9.00€0.19matched
91capture01a19b94-72ab-72ed-a2ac-fd45dc2d2e46€9.00€0.19matched
92capture01a19b94-9c82-7c8d-982e-650b81a2166c€9.00€0.19matched
93capture01a19b94-9e39-7b50-b0ff-22dd9240e614€35.00€0.50matched
94capture01a19b94-aa74-75c4-958a-e75036efc6b4€35.00€0.50matched
95capture01a19b94-c627-720c-9259-3ed6fe20377b€9.00€0.19matched
96capture01a19b94-c783-709f-b7be-e1e7f09bac9e€49.00€0.67matched
97capture01a19b94-cba7-7a9d-aa6f-8ab7ea8ce3b9€49.00€0.67matched
98capture01a19b94-ce08-76ab-9185-a6a55684a675€35.00€0.50matched
99capture01a19b94-d5d3-7a1c-b521-1966b5042989€35.00€0.50matched
100capture01a19b94-edb7-70c5-9248-22af24b5069c€9.00€0.19matched
101capture01a19b95-0af4-71f9-b72c-449bbb71d23c€49.00€0.67matched
102capture01a19b95-302c-7f59-a7b8-2b0f800b876d€35.00€0.50matched
103capture01a19b95-41f4-7482-a5c7-a2d2440fe129€15.00€0.26matched
104capture01a19b95-4964-704a-8de3-249e281d0d6a€9.00€0.19matched
105capture01a19b95-4bea-799f-a46d-72679590d760€15.00€0.26matched
106capture01a19b95-5280-725f-b70c-e7410a913b7d€15.00€0.26matched
107capture01a19b95-63f8-74cd-a4f2-519bedcd066e€49.00€0.67matched
108capture01a19b95-68e2-77dc-ac3a-e73887619d2b€24.00€0.37matched
109capture01a19b95-a9b6-7bd4-adf8-2ac59c32ca0e€15.00€0.26matched
110capture01a19b95-c3a9-705f-b025-148b75460ef2€24.00€0.37matched
111capture01a19b95-dc29-75ad-9cd6-811efac24bac€15.00€0.26matched
112capture01a19b95-e072-7f54-ace5-aaeeb459e311€9.00€0.19matched
113capture01a19b95-faeb-71ee-9b07-86347349d1be€9.00€0.19matched
114refund01a19b96-0397-7f7b-a5a2-8a563d6ef2be-€4.00€0.00matched
115capture01a19b96-5631-74b3-bc80-b2d7e03ea7af€35.00€0.50matched
116capture01a19b96-60d2-70f6-ba84-c8299e746a07€35.00€0.50matched
117capture01a19b96-61a1-7fe6-b460-d455d113f39b€9.00€0.19matched
118capture01a19b96-6270-732a-82b5-b4b473f361c1€9.00€0.19matched
119capture01a19b96-6721-71d6-a5ed-d0a5c0c0ed8f€24.00€0.37matched
120capture01a19b96-82b1-78e2-856f-55e87efed84d€35.00€0.50matched
121capture01a19b96-83e2-7276-9dee-ed30cf2b70cb€35.00€0.50matched
122capture01a19b96-994c-733c-b189-924fbc156de7€24.00€0.37matched
123capture01a19b96-a0c8-7144-a22b-d7dc707dc511€49.00€0.67matched
124capture01a19b96-c2e4-7819-bf23-32f4d2fade43€24.00€0.37matched
125capture01a19b96-e67a-7799-a1ea-2f573b787b64€9.00€0.19matched
126refund01a19b96-f76c-7428-a6bb-542e352cbbc5-€18.00€0.00matched
127capture01a19b96-ffab-7941-ab02-1e9641cea0db€24.00€0.37matched
128capture01a19b97-0899-7d0e-b4d6-cd4b761becf4€9.00€0.19matched
129capture01a19b97-091c-70e8-b8a7-6d5aa6218f5c€49.00€0.67matched
130capture01a19b97-1011-7f66-b439-f3d17cb37d4e€9.00€0.19matched
131capture01a19b97-12a0-708e-bb23-cdf84b59264f€15.00€0.26matched
132capture01a19b97-14ce-761f-9a5e-09e678a40740€15.00€0.26matched
133capture01a19b97-2489-7ee9-9466-4d742ec9bc2c€35.00€0.50matched
134capture01a19b97-6d93-7215-bf9d-fbfc5b27abe2€15.00€0.26matched
135capture01a19b97-786a-78d9-991a-fcdc69991ae5€15.00€0.26matched
136capture01a19b97-c540-7881-9d91-a310dc85f65e€24.00€0.37matched
137capture01a19b97-fc6a-7cad-a6e5-bcb55968c91f€15.00€0.26matched
138capture01a19b98-1085-7c1d-a36f-67ff1d1820fa€35.00€0.50matched
139capture01a19b98-125b-7be9-8a62-87b5792b0f64€9.00€0.19matched
140capture01a19b98-1671-756f-bd86-2c119ed10c79€49.00€0.67matched
141capture01a19b98-1998-7214-b5c9-d7f37cd4c3a8€49.00€0.67matched