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

4 Nov, 18:40

Gross

€2,941.00

PSP fee

€46.41

Net to the bank

€2,894.59

Settlement journal

#384062

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • missing linein the books, not in the filerefund:01a1a7e4-067a-78ef-b3f4-c70c4d6b8344 is in no file
  • missing linein the books, not in the filecapture:01a1a7e0-e848-75cd-836b-4506e3fe4688 is in no file
LineKindReferenceGrossFeeStatus
40capture01a1a7df-935f-7cb3-ba4e-e741f1c9ef62€49.00€0.71fee difference
41capture01a1a7df-a985-7377-9814-dd6eaeebcd43€35.00€0.52fee difference
63capture01a1a7e1-8667-70fb-a0eb-63530c7ef6e8€49.00€0.72fee difference
1capture01a1a7dc-643e-7c93-9bab-da6b95bcd8e7€49.00€0.67matched
2capture01a1a7dc-69da-7a8d-b0b7-f7b1715c7898€24.00€0.37matched
3capture01a1a7dc-ec49-7562-9745-160428fe9512€9.00€0.19matched
4capture01a1a7dc-f6bc-7412-bcae-8e636e1de379€9.00€0.19matched
5capture01a1a7dd-0204-79b5-91ac-1eed66d280aa€24.00€0.37matched
6capture01a1a7dd-0d2c-7f12-894a-62d68fab7e6b€35.00€0.50matched
7capture01a1a7dd-12b2-7878-b901-04fbfc574c99€15.00€0.26matched
8capture01a1a7dd-13db-79c6-a187-1e012ea5d907€24.00€0.37matched
9capture01a1a7dd-3dc1-7214-b24e-3f387b86b667€49.00€0.67matched
10refund01a1a7dd-4776-7045-a599-191c30d05132-€7.00€0.00matched
11capture01a1a7dd-5afe-7f56-b8b4-a4f29eaf5ba3€49.00€0.67matched
12capture01a1a7dd-5c54-7854-97b1-71cd34cc7059€49.00€0.67matched
13capture01a1a7dd-6280-7cda-b6fa-72a4ec175f84€24.00€0.37matched
14capture01a1a7dd-a804-7f4a-aa8d-504387823a30€9.00€0.19matched
15capture01a1a7dd-b4d9-7a96-8e35-63d1af95cbd9€49.00€0.67matched
16capture01a1a7dd-c0e7-751b-be10-6727a8de5e9d€15.00€0.26matched
17refund01a1a7dd-d097-7a00-b4ad-3b3c94c49002-€9.00€0.00matched
18capture01a1a7dd-d29a-73f9-a240-a53df0f3b894€49.00€0.67matched
19capture01a1a7dd-dbbe-702d-be11-ca19df9b2848€15.00€0.26matched
20capture01a1a7dd-f47d-7e36-b691-caf95757f892€9.00€0.19matched
21capture01a1a7de-18a9-7fdf-9563-bf7f0e3e5e20€15.00€0.26matched
22capture01a1a7de-1df3-7fea-ac78-c41082bcf1e7€9.00€0.19matched
23refund01a1a7de-28b4-739c-bdc5-9ee0c9e3c1f3-€18.00€0.00matched
24capture01a1a7de-2d3c-7ce9-b80a-d8c6afc3d179€24.00€0.37matched
25capture01a1a7de-3c53-7a73-bfec-9f0f365d681f€49.00€0.67matched
26capture01a1a7de-5717-7183-9c24-a69b74d1b6b0€9.00€0.19matched
27capture01a1a7de-8bf3-7bca-98b1-6e230e12fea8€49.00€0.67matched
28capture01a1a7de-acc9-79e9-8a56-c1fe4eac7d8e€15.00€0.26matched
29capture01a1a7de-b965-76b7-8470-d957dbd1d4ae€35.00€0.50matched
30capture01a1a7de-ba1d-777d-9d0d-69dfdeff4357€35.00€0.50matched
31capture01a1a7de-c3ca-7aa5-acee-335024d86ca9€9.00€0.19matched
32capture01a1a7de-e17a-7be9-ae8e-321f201ba06b€49.00€0.67matched
33capture01a1a7de-ebdc-7930-ad00-4808f1571960€49.00€0.67matched
34capture01a1a7df-0bcc-797f-8d2e-1dfbb075861c€15.00€0.26matched
35capture01a1a7df-0e94-7ba0-a844-137403cc157e€35.00€0.50matched
36refund01a1a7df-1d45-799e-a8df-b89cc8b12853-€14.00€0.00matched
37capture01a1a7df-46a6-7898-9b4e-123471bed95b€24.00€0.37matched
38capture01a1a7df-4a95-7537-8b39-20161b92b239€35.00€0.50matched
39capture01a1a7df-6d34-78a8-9369-55a255abf36d€24.00€0.37matched
42capture01a1a7df-cfa5-702b-b18e-b63e5e7510ed€15.00€0.26matched
43capture01a1a7df-e3ad-7a43-a45d-814e63f9f709€35.00€0.50matched
44capture01a1a7e0-2d14-7fa3-aff0-065e02d6dccc€9.00€0.19matched
45capture01a1a7e0-3f94-700b-a2d3-182208e2e385€9.00€0.19matched
46capture01a1a7e0-46e8-74f5-a82c-bc189b744a14€15.00€0.26matched
47capture01a1a7e0-4a8e-7cf5-8945-21cfbd124a6d€15.00€0.26matched
48capture01a1a7e0-4c0c-7ef2-a8f5-49103c4266be€35.00€0.50matched
49capture01a1a7e0-5b7a-7678-a952-20d47450f28f€24.00€0.37matched
50capture01a1a7e0-6385-79a6-9efe-96f815301c57€15.00€0.26matched
51capture01a1a7e0-9444-715c-a154-d188ca88cf33€49.00€0.67matched
52capture01a1a7e0-9c74-71b5-a8b5-6f75fad76cef€24.00€0.37matched
53capture01a1a7e0-a349-74f2-8125-a3c2e49bfe33€24.00€0.37matched
54capture01a1a7e0-b70a-7f3e-a429-53d1ea0d51e7€24.00€0.37matched
55capture01a1a7e0-c8a2-7d78-856a-03ca637191ec€49.00€0.67matched
56capture01a1a7e0-d275-7354-bcc7-ed1010998859€9.00€0.19matched
57capture01a1a7e0-e325-7395-ab20-92d2712da913€24.00€0.37matched
58refund01a1a7e1-07b4-7f82-a907-36df4ef20ffd-€23.00€0.00matched
59capture01a1a7e1-0822-7572-ac19-6e005587444d€9.00€0.19matched
60capture01a1a7e1-0fd7-7f9d-ac99-d7e8e4b0e66d€15.00€0.26matched
61capture01a1a7e1-1c67-776f-b10b-adeaadc3c2ca€49.00€0.67matched
62capture01a1a7e1-3029-7871-8828-88e35d202399€49.00€0.67matched
64capture01a1a7e1-8864-7606-8e71-b3ba3fc8a5ad€35.00€0.50matched
65refund01a1a7e1-95c3-754e-af0a-4a8aeb0be34b-€47.00€0.00matched
66capture01a1a7e1-9e63-7a37-8dc1-eaae8a4fd4ed€35.00€0.50matched
67capture01a1a7e1-ab79-7173-80ee-068af85c8595€15.00€0.26matched
68capture01a1a7e1-bedb-7d64-9033-836578993cd9€15.00€0.26matched
69capture01a1a7e1-c00e-7efa-9c80-b8193ba69d0e€24.00€0.37matched
70capture01a1a7e1-c527-77a3-9f28-1f49c20623d4€49.00€0.67matched
71capture01a1a7e1-c5f7-7212-82e5-aa147a12829d€9.00€0.19matched
72capture01a1a7e1-de09-791f-894d-3a611a62ec8b€15.00€0.26matched
73capture01a1a7e1-de3c-7f51-a28e-6639a64fe5ef€15.00€0.26matched
74capture01a1a7e1-f000-71f7-8ad4-034b7d4e63da€24.00€0.37matched
75refund01a1a7e2-067e-7e33-aaa6-cdfce7be03f8-€13.00€0.00matched
76capture01a1a7e1-f912-712f-afde-f639829b8eb2€35.00€0.50matched
77capture01a1a7e2-1684-7e5a-a58c-658ecd457f83€15.00€0.26matched
78capture01a1a7e2-44f2-774b-b2a2-73bfe16fbbcf€35.00€0.50matched
79refund01a1a7e2-4a0f-760c-9de7-e24e36637e34-€11.00€0.00matched
80capture01a1a7e2-51a0-7284-857f-57de88f9c054€9.00€0.19matched
81capture01a1a7e2-76b1-7f26-b955-8949cb3fe095€9.00€0.19matched
82capture01a1a7e2-623b-7e20-9c1f-2d7fb40dd2f5€9.00€0.19matched
83capture01a1a7e2-7b91-79be-bc25-fef1159a42fc€35.00€0.50matched
84capture01a1a7e2-a44a-7a59-865f-621ec96f9d0d€35.00€0.50matched
85capture01a1a7e2-a896-7988-adf8-9bce676186e2€15.00€0.26matched
86capture01a1a7e2-bc7d-70b5-bfaf-9cc81658a3c2€24.00€0.37matched
87capture01a1a7e2-c867-71d5-85dd-1ba2160bb0a7€49.00€0.67matched
88refund01a1a7e2-ed7a-78dd-b133-5fc102d4439e-€14.00€0.00matched
89capture01a1a7e3-15ce-781c-8bab-d06898749345€49.00€0.67matched
90capture01a1a7e3-3196-7b90-b637-8d16145ca23d€49.00€0.67matched
91capture01a1a7e3-3954-74d1-a6a5-89b5a7bc39e2€15.00€0.26matched
92capture01a1a7e3-4baa-7899-ac1c-18c2bc70da37€9.00€0.19matched
93capture01a1a7e3-52e4-72ca-b48c-d4ea0706a205€24.00€0.37matched
94capture01a1a7e3-5e2a-734f-8f8b-f5fdfe9b192e€24.00€0.37matched
95capture01a1a7e3-6add-7188-8c4b-455375773532€9.00€0.19matched
96capture01a1a7e3-6e2d-7507-b4b8-654d090dc47d€49.00€0.67matched
97capture01a1a7e3-89b4-724b-965f-d2866102378d€15.00€0.26matched
98capture01a1a7e3-8f3a-7b46-be0e-6e453bfae9a4€24.00€0.37matched
99capture01a1a7e3-be3c-78ad-ad6c-07002b4fb824€35.00€0.50matched
100capture01a1a7e3-c362-76f1-b43e-3038d6fbe096€49.00€0.67matched
101capture01a1a7e3-e3d9-78fd-97d8-6ddc3c8fc7bd€24.00€0.37matched
102capture01a1a7e3-f271-7a9d-baa2-d848f8327124€35.00€0.50matched
103capture01a1a7e3-f769-7ba0-b2a2-abbf8d3affdf€49.00€0.67matched
104capture01a1a7e4-080f-7b99-8648-0be3272b133a€49.00€0.67matched
105capture01a1a7e4-0f0c-7775-969b-aa1ae94f0424€24.00€0.37matched
106capture01a1a7e4-49e7-7740-b577-b83e9729104b€49.00€0.67matched
107capture01a1a7e4-4cfa-757b-ba1f-9ea69f868c4d€9.00€0.19matched
108capture01a1a7e4-57ea-7269-8a68-5ffc031e6c78€49.00€0.67matched
109capture01a1a7e4-90e1-776b-bc2d-943e72acf1a8€35.00€0.50matched
110capture01a1a7e4-9d3d-7010-89bf-e032edc1abb9€35.00€0.50matched
111refund01a1a7e4-bb6f-716f-8508-91405f36bca6-€10.00€0.00matched
112capture01a1a7e4-ded8-71d3-a983-ff16642ecd73€24.00€0.37matched
113capture01a1a7e4-e78a-7c26-a352-c9f4fa61c91d€15.00€0.26matched
114capture01a1a7e5-03a8-7d9d-a0a8-4ce655c5fa8b€35.00€0.50matched
115capture01a1a7e5-074d-7794-a711-0e1fbbf7ff0c€15.00€0.26matched
116capture01a1a7e5-1915-7a1e-a59d-1f6a9f74d3d7€35.00€0.50matched
117capture01a1a7e5-1ec7-7c1e-b86d-2c85b6cec7b0€9.00€0.19matched
118capture01a1a7e5-34a4-7081-859c-c3d3faf141e4€24.00€0.37matched
119capture01a1a7e5-36d0-77be-904b-c7ad3796038d€35.00€0.50matched
120capture01a1a7e5-4cfe-71ed-8380-09f3f465a8ad€49.00€0.67matched
121capture01a1a7e5-6368-7c1b-aea3-ff20f5b5fb13€35.00€0.50matched