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

17 Oct, 16:10

Gross

€3,131.00

PSP fee

€51.12

Net to the bank

€3,079.88

Settlement journal

#53991

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 27, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
  • missing linein the books, not in the filecapture:01a14aa4-92c5-7d21-ba9b-cf7ddbf7cdbe is in no file
  • missing linein the books, not in the filecapture:01a14aa9-1b20-771e-9863-d4b48994240b is in no file
LineKindReferenceGrossFeeStatus
6capture01a14aa0-b6a3-725b-8950-0b25c68f825b€49.00€0.70fee difference
84capture01a14aa5-d80e-7caa-801c-06423be2b039€15.00€0.27fee difference
126capture01a14aa8-811c-77c2-af6a-896c35d9b7e0€49.00€0.71fee difference
1refund01a14a97-c65c-7b49-8aad-1d4e33c3dd33-€12.00€0.00matched
2capture01a14a9b-4219-7d43-841e-1ad1e979d5e7€35.00€0.50matched
3refund01a14a9d-1779-7b1f-9d55-d12ba56b45a3-€12.00€0.00matched
4capture01a14a9f-5a2c-7213-8e98-efa34cd8a5f0€49.00€0.67matched
5capture01a14aa0-b63a-7799-8590-e1b97f000ba7€49.00€0.67matched
7capture01a14aa0-bc1d-79b5-80a4-398ce2413489€9.00€0.19matched
8capture01a14aa0-d4e1-7ac9-87c0-49f5844e8bad€9.00€0.19matched
9capture01a14aa0-e647-7096-bb1d-1787f3461c88€24.00€0.37matched
10capture01a14aa0-ffc5-75cb-8033-94d5d8381c85€24.00€0.37matched
11capture01a14aa1-0fc9-75eb-ae6c-b34e2e8dddae€15.00€0.26matched
12capture01a14aa1-163d-71f5-8b21-9249dd1e9d54€9.00€0.19matched
13capture01a14aa1-167f-7406-86a8-ef3747d36b54€35.00€0.50matched
14capture01a14aa1-1a6e-761c-bbe5-ae741ab063d4€35.00€0.50matched
15capture01a14aa1-27ac-736b-9133-dcfca7b57924€35.00€0.50matched
16capture01a14aa1-29f9-7815-8948-f3c6fd015744€35.00€0.50matched
17capture01a14aa1-2b02-701a-96db-1b4a22e279f7€35.00€0.50matched
18capture01a14aa1-378d-7648-baf6-685115d8f319€15.00€0.26matched
19capture01a14aa1-3bd3-7e86-9103-cbaf3b5ca92f€49.00€0.67matched
20capture01a14aa1-4717-71e1-962b-6aea81590e97€15.00€0.26matched
21capture01a14aa1-5698-731d-ae46-f2009781b0cb€49.00€0.67matched
22capture01a14aa1-59be-7558-9164-a001577b708a€9.00€0.19matched
23refund01a14aa1-6a96-721a-98d9-3921c6d35bb0-€10.00€0.00matched
24capture01a14aa1-75c3-77a7-93e5-12e22043d627€9.00€0.19matched
25capture01a14aa1-8fb8-7f9a-9cec-123795a8a76b€15.00€0.26matched
26capture01a14aa1-9677-7b32-a802-f31270ba1769€35.00€0.50matched
27refund01a14aa1-c7df-75c4-84c8-2bb0eb2062d9-€6.00€0.00matched
28capture01a14aa1-d3e2-7214-a2b0-5ead788de354€15.00€0.26matched
29capture01a14aa1-e6ea-7c1b-99c3-cb80c61f832e€49.00€0.67matched
30capture01a14aa1-eedd-7351-863a-1008d9830fef€35.00€0.50matched
31capture01a14aa2-11ef-7db1-b329-9ce62e194cdd€35.00€0.50matched
32refund01a14aa2-1e56-7c68-b55f-80567a98c024-€44.00€0.00matched
33capture01a14aa2-20ce-7b58-b978-6730b7668807€35.00€0.50matched
34capture01a14aa2-28c3-73f5-aa1b-a4a561b850fd€35.00€0.50matched
35capture01a14aa2-2ec2-7b8e-ab1d-e3bb92d9b952€24.00€0.37matched
36capture01a14aa2-3d9d-7c16-a2b1-967cfc978f78€9.00€0.19matched
37capture01a14aa2-54cf-77bb-8c8e-bed5f8dcbde5€24.00€0.37matched
38capture01a14aa2-7995-741a-bf0b-871f92865450€15.00€0.26matched
39capture01a14aa2-8401-7c90-9518-a95b2ef26371€15.00€0.26matched
40capture01a14aa2-a0ee-77fa-8f72-568788f468ea€9.00€0.19matched
41capture01a14aa2-e163-72ff-8ab0-dd4fd42214cc€35.00€0.50matched
42capture01a14aa2-e4ec-7ef9-90ac-dcbca5237b61€15.00€0.26matched
43capture01a14aa2-e987-71e6-86b3-a01e1fe42ef8€9.00€0.19matched
44capture01a14aa3-0a94-7bcc-9027-1c5d5cf7ec47€35.00€0.50matched
45capture01a14aa3-30dc-7f6a-bdba-7efd4c506ff5€15.00€0.26matched
46capture01a14aa3-6224-7ffb-b3f6-62fb6dbecfee€35.00€0.50matched
47capture01a14aa3-654b-703f-8562-2473fc796703€24.00€0.37matched
48capture01a14aa3-659b-7d28-8bb4-b7553b4ab1df€35.00€0.50matched
49capture01a14aa3-66d4-7204-8acb-519a5f5ced43€49.00€0.67matched
50capture01a14aa3-6c0c-77fc-9fb8-81b2c0394106€35.00€0.50matched
51capture01a14aa3-6e04-7ed7-a66c-3e88aaa78c84€24.00€0.37matched
52capture01a14aa3-8609-723c-a8a3-83f62dc79f5b€9.00€0.19matched
53capture01a14aa3-a361-706e-872a-73a7ebd25f43€35.00€0.50matched
54capture01a14aa3-c33e-727e-8bc1-7f7019a7cff1€15.00€0.26matched
55capture01a14aa3-c86e-725a-b127-3925cf4b35dc€49.00€0.67matched
56capture01a14aa3-f22f-704d-9c53-bdc57329815e€9.00€0.19matched
57refund01a14aa3-f497-7e37-ab80-939b338a533c-€8.00€0.00matched
58capture01a14aa4-28dc-7c59-9257-cf2d918234a4€35.00€0.50matched
59capture01a14aa4-4a6b-7174-af95-2973332bdd15€15.00€0.26matched
60capture01a14aa4-4aae-75a2-a5cc-388154209a78€24.00€0.37matched
61capture01a14aa4-5480-7444-81d9-56856060ba9a€35.00€0.50matched
62capture01a14aa4-5dd1-7999-89f8-46a62c004b71€24.00€0.37matched
63capture01a14aa4-6e3a-7fbb-ac81-37b4f0e669e3€15.00€0.26matched
64capture01a14aa4-72d9-7b23-b094-1d18de0239bf€24.00€0.37matched
65capture01a14aa4-7934-7e12-87c7-ab21ad130966€9.00€0.19matched
66capture01a14aa4-8766-7766-b457-63d60b01c34b€35.00€0.50matched
67capture01a14aa4-876c-7306-b065-8d17b11e7512€24.00€0.37matched
68capture01a14aa4-bd6c-73e1-a853-2a1ac0d728ef€24.00€0.37matched
69capture01a14aa4-cf50-77d8-bc63-b6649172f8f3€9.00€0.19matched
70capture01a14aa4-dc8a-7a7f-adc2-a037e2b4c6ff€24.00€0.37matched
71capture01a14aa5-06f6-718a-b33f-1f897cbe4b31€9.00€0.19matched
72capture01a14aa5-07ba-7b12-98ba-3eb9eeb784a8€15.00€0.26matched
73capture01a14aa5-1212-7cfc-8bb8-4afe7b16e9c1€15.00€0.26matched
74capture01a14aa5-1490-727c-a550-a84e65a1f943€35.00€0.50matched
75capture01a14aa5-28d6-7d6b-a6b3-20a0354b90ea€15.00€0.26matched
76capture01a14aa5-2bc8-71e6-ac16-53353d8f522a€49.00€0.67matched
77capture01a14aa5-444c-7f12-89ca-b22825df86d4€9.00€0.19matched
78refund01a14aa5-607b-7c6a-b675-8437167d3822-€8.00€0.00matched
79capture01a14aa5-7af4-7497-a405-8d11db4a9d87€15.00€0.26matched
80capture01a14aa5-8df3-7d48-9b01-105b27e38600€9.00€0.19matched
81refund01a14aa5-a034-7df6-9e71-9b923a4a6c49-€44.00€0.00matched
82capture01a14aa5-b896-73b9-ad7f-916678662dbe€49.00€0.67matched
83capture01a14aa5-d076-7dcc-b185-ff1793af8a30€24.00€0.37matched
85capture01a14aa5-ebff-7100-8037-aaeb5314b7f0€49.00€0.67matched
86capture01a14aa5-f136-74a8-aeb7-cb42d6e2d13c€15.00€0.26matched
87capture01a14aa6-063a-7db0-9a0e-f58a9786d567€49.00€0.67matched
88capture01a14aa6-0da3-7b01-b161-62940a1ab0d7€9.00€0.19matched
89capture01a14aa6-0f73-71fa-9fc2-1b36a3ac74d0€9.00€0.19matched
90capture01a14aa6-2aea-7250-9c7b-c345bb28efc8€35.00€0.50matched
91capture01a14aa6-4ddd-761a-b2f1-dc8d7d316849€9.00€0.19matched
92capture01a14aa6-5f1f-757e-9e69-a686ee3ff76e€15.00€0.26matched
93refund01a14aa6-6976-74c6-8303-b8562a5da35c-€8.00€0.00matched
94capture01a14aa6-6c9f-7321-8bcd-28401e0b648c€49.00€0.67matched
95capture01a14aa6-7963-71a1-8128-5f276ac7a20f€49.00€0.67matched
96capture01a14aa6-8d08-795d-bec7-17789a6a7c4e€49.00€0.67matched
97capture01a14aa6-914c-7e1a-81a4-2a7ef19055b8€15.00€0.26matched
98capture01a14aa6-a977-7170-80a3-9b021db3bf86€35.00€0.50matched
99capture01a14aa6-ab39-77be-9733-02ac61ab1e07€9.00€0.19matched
100capture01a14aa6-b0a0-723c-be7b-80c13af095d3€9.00€0.19matched
101capture01a14aa6-eaaf-72cf-ae8b-61e84ef58d33€49.00€0.67matched
102capture01a14aa6-ee9d-7d32-ac9a-a6a4c0056420€15.00€0.26matched
103capture01a14aa6-f6a8-7fbf-9c8b-6692f7508d9a€9.00€0.19matched
104capture01a14aa6-f83d-7166-8533-443f069f5c83€9.00€0.19matched
105refund01a14aa7-1934-7e27-8075-ed16a7c5a6be-€5.00€0.00matched
106capture01a14aa7-1ae1-7c6b-a892-97410c2ee884€35.00€0.50matched
107capture01a14aa7-6427-7214-a197-f0a1daefbda9€24.00€0.37matched
108capture01a14aa7-887d-71f7-8c59-a057eaa5c44c€15.00€0.26matched
109capture01a14aa7-8c9a-7be4-a45b-6e4285e24aed€9.00€0.19matched
110capture01a14aa7-b78b-770f-b3ba-3b3459d2b8a3€49.00€0.67matched
111capture01a14aa7-c069-7eec-83f8-9df9ef002646€24.00€0.37matched
112capture01a14aa7-c5c2-7246-9da4-f575854bf7d4€24.00€0.37matched
113capture01a14aa7-d1a7-7b4f-8d43-f7242ead56ea€15.00€0.26matched
114capture01a14aa7-d849-7045-87d2-317ced8e2073€24.00€0.37matched
115refund01a14aa8-04b0-73ec-b3c8-d615b12565e0-€18.00€0.00matched
116capture01a14aa8-1699-776c-9ebe-8873b68de8d8€9.00€0.19matched
117capture01a14aa8-3321-7ac4-add5-20f9cbed10a3€49.00€0.67matched
118refund01a14aa8-368e-74c5-85d4-5c0b69a13685-€5.00€0.00matched
119capture01a14aa8-3906-78c6-854b-4ecf1ad087ac€35.00€0.50matched
120capture01a14aa8-3af1-7e06-98e2-22d20089ee17€49.00€0.67matched
121capture01a14aa8-3c44-737a-b8d3-b45a9f667d87€9.00€0.19matched
122capture01a14aa8-4fb4-747b-86f6-0d12e7f0d51e€9.00€0.19matched
123capture01a14aa8-67b0-7e24-bac9-2de27e6613e8€49.00€0.67matched
124capture01a14aa8-710d-7044-8e11-1d339c0528a9€15.00€0.26matched
125refund01a14aa8-7176-71c0-8bbe-e6d48a9fb4a8-€14.00€0.00matched
127capture01a14aa8-8957-79a8-b4be-2153942c0419€15.00€0.26matched
128capture01a14aa8-90c1-7ce4-b0aa-feae889ceea5€35.00€0.50matched
129refund01a14aa8-adcb-73ea-8442-d327e8574ae0-€17.00€0.00matched
130capture01a14aa8-e36f-7d0f-a056-13fcadfe0f9c€24.00€0.37matched
131capture01a14aa8-f003-7881-a6ef-7fa5c1e84969€35.00€0.50matched
132capture01a14aa8-f40a-7987-aca7-d0a23ea31574€35.00€0.50matched
133capture01a14aa8-f5ac-71b3-a0fc-8a39f66af113€15.00€0.26matched
134capture01a14aa9-03b4-7c70-957a-27e3f7f6e4f4€35.00€0.50matched
135capture01a14aa9-0ddc-7be0-be96-78a13070cc83€49.00€0.67matched
136capture01a14aa9-10d4-7d2d-b156-efe82677cf58€15.00€0.26matched
137capture01a14aa9-255a-7063-bd6c-20ead065fe1d€9.00€0.19matched
138capture01a14aa9-3a42-7662-be03-5e04276e582a€49.00€0.67matched
139refund01a14aa9-3f7c-70bc-b658-e87a350c4356-€11.00€0.00matched
140capture01a14aa9-4396-7b17-a52f-dbdd5f76b686€15.00€0.26matched
141refund01a14aa9-55df-725f-8eb1-d81330f45ea6-€22.00€0.00matched
142capture01a14aa9-6402-7c35-80e6-b14251432eb5€49.00€0.67matched
143capture01a14aa9-6658-73fa-b136-f195c421f23d€35.00€0.50matched
144capture01a14aa9-8b03-7d85-980e-3430ebf07234€15.00€0.26matched
145capture01a14aa9-9265-7a39-9754-cf62edf17525€15.00€0.26matched
146capture01a14aa9-9795-7f17-a83d-69767a3ff1d5€24.00€0.37matched