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

3 Nov, 15:40

Gross

€2,616.00

PSP fee

€44.79

Net to the bank

€2,571.21

Settlement journal

#363516

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
LineKindReferenceGrossFeeStatus
11capture01a1a211-9dd1-76f9-b253-e29724562382€35.00€0.51fee difference
17capture01a1a212-0e9e-7329-a31f-a9d22bbd37ff€49.00€0.70fee difference
1capture01a1a209-1ae5-7422-b2e3-d4fa4e86588a€9.00€0.19matched
2refund01a1a20e-449a-7474-b774-156c3d2748b3-€18.00€0.00matched
3capture01a1a211-450e-76f1-b04f-a39c28db8f8a€15.00€0.26matched
4capture01a1a211-52d1-7602-bc2b-289f84887e9c€24.00€0.37matched
5capture01a1a211-53fb-7a8a-9bcb-8fa8a4462d87€9.00€0.19matched
6capture01a1a211-656a-7e9e-a707-644332014e1d€35.00€0.50matched
7refund01a1a211-6bfb-7908-bc55-9ed1d8424dca-€22.00€0.00matched
8capture01a1a211-6fca-7bc1-a2d2-84263ce37513€15.00€0.26matched
9capture01a1a211-6d3a-75f4-b3f1-f93a2dc2c9c5€9.00€0.19matched
10capture01a1a211-965e-785f-9a93-b50ccfbbbcc0€35.00€0.50matched
12capture01a1a211-a1b0-702f-8a20-76166d3cba87€9.00€0.19matched
13capture01a1a211-d9eb-7464-81dd-fd161c42a9ea€24.00€0.37matched
14capture01a1a211-ea38-71a8-bf45-bf4e42226a15€49.00€0.67matched
15capture01a1a211-ebe8-7ee5-a5a2-dc0a97939673€9.00€0.19matched
16capture01a1a211-fe9c-74c1-b70c-91dfb035e5c1€35.00€0.50matched
18capture01a1a212-1458-7014-acc1-f1d48a66b36f€35.00€0.50matched
19capture01a1a212-1964-7378-b9a0-eebd906ab28a€9.00€0.19matched
20capture01a1a212-27c1-7c7f-ae5b-5ecc9e024a15€15.00€0.26matched
21capture01a1a212-2915-7182-b953-a12330558993€9.00€0.19matched
22refund01a1a212-3137-7d8f-8d76-dee97667e4ef-€45.00€0.00matched
23capture01a1a212-3414-7c6f-8f9e-f8248703132a€24.00€0.37matched
24capture01a1a212-384c-7095-890c-2e1202f24ad6€9.00€0.19matched
25capture01a1a212-2de0-7190-a3d3-bae3670a84a0€9.00€0.19matched
26capture01a1a212-3ddc-72c8-87a9-9f77dace9775€15.00€0.26matched
27capture01a1a212-4a55-7498-b644-a6c4e8f29d2b€24.00€0.37matched
28capture01a1a212-4a66-77db-bafd-df0f5c12f9e9€49.00€0.67matched
29capture01a1a212-507b-7a3d-b766-0201497ed0f3€49.00€0.67matched
30refund01a1a212-6307-7fc1-bc0c-c14a36ed38be-€5.00€0.00matched
31capture01a1a212-6a90-7f62-bf2e-fcd40964a843€49.00€0.67matched
32refund01a1a212-a129-7068-bfc8-f151862be041-€6.00€0.00matched
33capture01a1a212-ab68-7f59-845a-dcc72cc25981€35.00€0.50matched
34capture01a1a212-ccb1-7377-a64e-6a66d90fe126€35.00€0.50matched
35capture01a1a212-d0f5-7ded-bf1a-a87072165cd4€15.00€0.26matched
36capture01a1a212-d543-74f7-a8fc-268b30ddb6dd€15.00€0.26matched
37capture01a1a212-e620-748e-a600-476c0dd7128c€15.00€0.26matched
38refund01a1a213-1faa-7db5-bbb6-7094fe2ed858-€18.00€0.00matched
39capture01a1a213-3055-7246-96c4-ce08de06dba6€49.00€0.67matched
40capture01a1a213-3bc9-7e8d-82cd-a40791938074€15.00€0.26matched
41capture01a1a213-40c4-78da-a8bf-df26218e7d6b€15.00€0.26matched
42capture01a1a213-4944-75ce-af89-3f98376f0746€15.00€0.26matched
43capture01a1a213-57a3-7743-a27e-824359d3bb94€9.00€0.19matched
44refund01a1a213-7234-721d-aec9-b2ec17d4e7b5-€10.00€0.00matched
45capture01a1a213-91f0-7bdd-b3f1-194c1b333190€24.00€0.37matched
46capture01a1a213-b847-7f58-8f18-7baee5fdda86€24.00€0.37matched
47capture01a1a213-bfb2-70f7-8ff9-8153939a941a€35.00€0.50matched
48capture01a1a213-dd42-7c00-9626-94826d7055f2€24.00€0.37matched
49capture01a1a213-e5ab-7cc0-a351-e7af10296618€9.00€0.19matched
50capture01a1a213-e9ed-7169-92a4-e53ac22871b2€49.00€0.67matched
51capture01a1a213-f477-71ee-84cd-9a7dc415d985€35.00€0.50matched
52capture01a1a214-0e27-73d9-8ead-c95e6958ca06€15.00€0.26matched
53capture01a1a214-35f3-7173-b1e4-3c826ece8b1d€9.00€0.19matched
54refund01a1a214-4ef8-74bd-8aa4-bd0ca993dd47-€14.00€0.00matched
55capture01a1a214-6846-755a-8b2c-366ac7128d1c€15.00€0.26matched
56capture01a1a214-7c27-7f2f-8ca6-8b2b95d36a9b€9.00€0.19matched
57capture01a1a214-b5eb-7ed0-bc75-38ee4225a2c4€49.00€0.67matched
58capture01a1a214-bf96-7d55-9e07-54a21d62f203€9.00€0.19matched
59capture01a1a214-c126-78b7-990b-e53f45a5c3ec€9.00€0.19matched
60capture01a1a214-cc41-733c-a8f3-cbb726f18e76€15.00€0.26matched
61capture01a1a214-f15b-7565-ae4e-852ceb531024€9.00€0.19matched
62refund01a1a214-ff8b-7c6a-9195-ca70bab26230-€35.00€0.00matched
63capture01a1a215-062f-70fc-ab65-b6c1cf34740d€15.00€0.26matched
64capture01a1a215-2acd-7743-8a13-44066cab81fc€35.00€0.50matched
65capture01a1a215-2dc1-7c87-b0d1-5f113e54d1ce€24.00€0.37matched
66capture01a1a215-2dfb-7c32-946d-aec8ff2bdbfa€9.00€0.19matched
67capture01a1a215-3060-7765-b545-ddd824e787b5€49.00€0.67matched
68capture01a1a215-4c80-7dfe-a39a-79351e743863€35.00€0.50matched
69refund01a1a215-5e0e-7d9f-b60c-e897bcedcf05-€23.00€0.00matched
70capture01a1a215-78db-730c-9a9c-bdf606578fa6€15.00€0.26matched
71capture01a1a215-857d-7540-a583-ce883de54cbc€35.00€0.50matched
72capture01a1a215-a6e0-70e6-bfca-4cfc62e92050€24.00€0.37matched
73capture01a1a215-cd63-748b-91b0-a2b3c135bbfe€49.00€0.67matched
74capture01a1a215-da29-7323-8a26-181d1d66f0a4€49.00€0.67matched
75capture01a1a215-f7aa-7ec2-837d-91bcd83bbfdf€15.00€0.26matched
76capture01a1a216-1bd3-72c3-bff6-1ad4ba9de515€9.00€0.19matched
77capture01a1a216-1e27-7935-b71c-ada93bf3fb51€24.00€0.37matched
78capture01a1a216-307f-7a2a-bc56-cdf888413b16€9.00€0.19matched
79capture01a1a216-3ec8-7d69-abdd-6fd36c3e913c€24.00€0.37matched
80capture01a1a216-4de7-7487-a32d-a370c4fc2d07€9.00€0.19matched
81capture01a1a216-520c-7629-a4a8-a56191807866€24.00€0.37matched
82refund01a1a216-5321-7efb-9b20-83f48da5b87c-€8.00€0.00matched
83capture01a1a216-61a1-7ee1-add5-887603e889f8€9.00€0.19matched
84capture01a1a216-7e75-74bc-9573-d728108c02bd€9.00€0.19matched
85capture01a1a216-8ef1-7301-b4ac-59b2e6eff44b€15.00€0.26matched
86refund01a1a216-93eb-7f64-a0d1-7afbf51a9ff4-€3.00€0.00matched
87refund01a1a216-9cbc-7b69-9069-7e6b6eaaef58-€13.00€0.00matched
88capture01a1a216-b6d9-7d37-91ee-d037f5eec4f4€9.00€0.19matched
89capture01a1a216-bf97-7b11-93db-8b64c453d321€9.00€0.19matched
90capture01a1a216-eb65-75df-9544-4dce51a503f5€15.00€0.26matched
91capture01a1a216-f189-7205-85d0-a32aad20fc34€24.00€0.37matched
92capture01a1a216-f6e4-7cbb-af28-6398fb0d2038€24.00€0.37matched
93capture01a1a217-07ca-7610-911d-2adc4436f89c€35.00€0.50matched
94capture01a1a217-0945-78fe-9910-b8e9408a8803€24.00€0.37matched
95capture01a1a217-09b8-7db4-97a2-f41234447e4a€15.00€0.26matched
96capture01a1a217-144d-7101-bf4d-3b1c3d573d6a€49.00€0.67matched
97capture01a1a217-14c8-7b5e-89b4-54b6a84071f0€24.00€0.37matched
98capture01a1a217-17df-7a49-871b-fb81c57bb789€15.00€0.26matched
99capture01a1a217-18e5-7ded-a0af-66fa97b6e9fa€24.00€0.37matched
100capture01a1a217-299a-74fd-ac82-97e39d359fc9€49.00€0.67matched
101capture01a1a217-3126-75d6-bf63-889ec8b46822€35.00€0.50matched
102capture01a1a217-335f-7572-ba58-0731376a4f8f€9.00€0.19matched
103capture01a1a217-37d2-7ccb-8b40-956129c68f9c€24.00€0.37matched
104refund01a1a217-38db-7e19-a40b-59b916927048-€8.00€0.00matched
105refund01a1a217-3a70-70ca-9013-438bd2a3f8e7-€7.00€0.00matched
106capture01a1a217-7678-7869-895a-adf5417c5e84€9.00€0.19matched
107capture01a1a217-7e40-7ecf-847d-d58149818e67€35.00€0.50matched
108refund01a1a217-8f5c-7b29-9664-9ea8be57408d-€5.00€0.00matched
109refund01a1a217-90f4-794d-9bb7-71e247648476-€19.00€0.00matched
110capture01a1a217-91a6-726c-a93d-8ac7763e302b€15.00€0.26matched
111capture01a1a217-bb60-7fde-a050-f23b4c3a0355€9.00€0.19matched
112capture01a1a217-ded9-7fae-8421-ef4b55ba6d34€49.00€0.67matched
113capture01a1a217-eec1-7439-bad7-6d5375cf5d78€15.00€0.26matched
114capture01a1a218-2cd8-7615-8a69-2919e324465d€35.00€0.50matched
115capture01a1a218-4593-7d60-9994-9f8416e7525c€49.00€0.67matched
116capture01a1a218-4cce-7b23-8803-a14a2423bcff€24.00€0.37matched
117capture01a1a218-54d9-7b7e-baa5-fbd601585376€15.00€0.26matched
118capture01a1a218-5679-7ea9-abd0-fb7d9a6dcd25€24.00€0.37matched
119capture01a1a218-60d8-728a-83e3-8d5b97d56290€15.00€0.26matched
120capture01a1a218-7608-7c6f-b2f0-1ebfcbb89232€49.00€0.67matched
121capture01a1a218-84f8-758e-8892-ba9cb00a09cf€49.00€0.67matched
122capture01a1a218-94e1-7e69-9c0c-68360bf7b6e6€15.00€0.26matched
123capture01a1a218-9cd6-7042-96ee-341c6f75c740€49.00€0.67matched
124capture01a1a218-a028-73fa-888c-a72a8cdaef09€9.00€0.19matched
125capture01a1a218-b93f-7d02-8ca2-0118aab9ce19€49.00€0.67matched
126capture01a1a218-dc0b-7ed1-9600-1593b2530665€15.00€0.26matched
127refund01a1a218-fbe3-7615-8dba-d7166e7a62fb-€6.00€0.00matched
128capture01a1a219-080c-7540-b344-8fc0e1f9239a€35.00€0.50matched
129capture01a1a219-0bb3-7aa4-a33c-b7587d1f35c7€24.00€0.37matched
130capture01a1a219-0517-7ff1-ae4a-b7d37db8eaca€9.00€0.19matched
131capture01a1a219-3aba-74b0-abaf-36b900c0b210€24.00€0.37matched
132capture01a1a219-458d-7e20-a67f-78a57ee1270b€49.00€0.67matched
133capture01a1a219-46a0-7ee9-a9f3-f60aa3bb5498€9.00€0.19matched
134capture01a1a219-5be4-7bcc-b001-ed2f28723652€15.00€0.26matched
135refund01a1a219-6d1a-7f5c-bc42-8c5b66b0e7b0-€29.00€0.00matched
136capture01a1a219-9758-7ea3-822e-d20fbcc7c33e€49.00€0.67matched
137capture01a1a219-a914-776a-a10b-4f2f8e830fb2€35.00€0.50matched
138capture01a1a219-b387-7fa5-9013-3b09967b3d8e€15.00€0.26matched
139capture01a1a21a-38ff-7dcc-bcd2-1e591feb5a64€24.00€0.37matched
140capture01a1a21a-48e1-7c86-9f86-f7bf1c53bf9a€9.00€0.19matched