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, 06:30

Gross

€2,688.00

PSP fee

€42.56

Net to the bank

€2,645.44

Settlement journal

#356617

Breaks for a person to look at

  • missing linein the books, not in the filecapture:01a1a01b-08ff-7c0c-98bc-37a15b6a5070 is in no file
LineKindReferenceGrossFeeStatus
1refund01a1a017-59b0-7d5f-af57-f4a91fe41f76-€6.00€0.00matched
2refund01a1a019-c666-7fd3-a965-168fe1738876-€6.00€0.00matched
3capture01a1a019-f8a3-733e-8741-6f0243db8908€15.00€0.26matched
4capture01a1a019-fbec-7c03-b91d-9a79e2aa857c€24.00€0.37matched
5capture01a1a01a-1350-7660-acc9-ad151b7818c4€24.00€0.37matched
6capture01a1a01a-48f2-75b2-8b7b-e55f99b67d42€15.00€0.26matched
7capture01a1a01a-4a42-7f8c-8189-595393c8a36e€35.00€0.50matched
8capture01a1a01a-54a6-7e1e-8a62-de210a2f6c5d€35.00€0.50matched
9capture01a1a01a-57c5-721f-bdbb-3f08b57be227€9.00€0.19matched
10capture01a1a01a-60ce-75c8-a2df-6a8fa017ca8c€9.00€0.19matched
11capture01a1a01a-739c-717b-a537-cbdeb06d8008€35.00€0.50matched
12capture01a1a01a-83fc-7be8-af44-516d2bf04c7b€9.00€0.19matched
13refund01a1a01a-917e-7508-bbce-4210091ed99e-€9.00€0.00matched
14capture01a1a01a-9e37-7a4e-85bf-8c93b633effa€49.00€0.67matched
15capture01a1a01a-a9f3-7ed1-91b8-5cfffa4d910d€35.00€0.50matched
16refund01a1a01a-d7c9-700b-a5cd-b004740ed9f6-€2.00€0.00matched
17capture01a1a01a-eb56-7eb0-bb08-51f34d8cd74a€24.00€0.37matched
18capture01a1a01a-f266-7755-a91a-7c02f8f598ef€24.00€0.37matched
19capture01a1a01a-fca3-7a6d-91d9-58e9d688bc95€49.00€0.67matched
20capture01a1a01b-480f-7a3f-bf53-de361922c927€9.00€0.19matched
21refund01a1a01b-49be-7575-8b1c-8c820a35a6e3-€17.00€0.00matched
22capture01a1a01b-5ff3-782c-b316-c60a5233da88€35.00€0.50matched
23capture01a1a01b-76a5-73cd-9824-714c0a8c5b71€9.00€0.19matched
24capture01a1a01b-be3a-744f-9bda-8e4e9d462fa5€49.00€0.67matched
25capture01a1a01b-e959-7188-b5f2-a83109653e6f€9.00€0.19matched
26capture01a1a01c-0750-77c5-aa0b-2ffecffdeeeb€15.00€0.26matched
27capture01a1a01c-1ab5-72a0-8e81-7b8cd04b5c1a€9.00€0.19matched
28capture01a1a01c-1ec2-7c53-8517-3f858f41c11d€9.00€0.19matched
29capture01a1a01c-3f90-7308-bdbf-aec8f40ec443€15.00€0.26matched
30capture01a1a01c-6189-7205-9813-c31c95dc79af€49.00€0.67matched
31capture01a1a01c-731d-7cfc-a798-12a4e035735f€35.00€0.50matched
32capture01a1a01c-b388-7763-8a94-9479eec4c86d€49.00€0.67matched
33capture01a1a01c-b9c0-74f5-8cbb-6a08e434d697€15.00€0.26matched
34capture01a1a01c-de0c-7506-a230-6e12ec77a38d€15.00€0.26matched
35capture01a1a01d-0a54-71cb-8a2b-a3d45342f030€15.00€0.26matched
36capture01a1a01d-2713-73cb-9a4a-ba7ad83898b4€15.00€0.26matched
37capture01a1a01d-56f4-70ce-9128-893566da6c35€49.00€0.67matched
38capture01a1a01d-60b1-7911-8542-592a70ece003€35.00€0.50matched
39capture01a1a01d-7174-7e65-a43f-a228b4da6e59€49.00€0.67matched
40capture01a1a01d-7444-7374-8a35-02bd8c9c11ea€24.00€0.37matched
41capture01a1a01d-7885-7cba-ba01-29b4e91a2856€35.00€0.50matched
42capture01a1a01d-875e-731e-9c2c-e1856174c1eb€24.00€0.37matched
43capture01a1a01d-989c-7b43-b1c8-9382ab7fd42a€24.00€0.37matched
44refund01a1a01d-9fd7-7089-8779-0aaaccacc7dc-€28.00€0.00matched
45capture01a1a01d-b206-772f-9c8d-805dac01cebf€24.00€0.37matched
46capture01a1a01d-c2e8-7ee2-9cc1-693fd81b3998€24.00€0.37matched
47capture01a1a01d-c24e-76af-9b4c-3bd926227104€35.00€0.50matched
48capture01a1a01d-d9d6-7c3a-9ffa-61837853bed7€15.00€0.26matched
49capture01a1a01e-05db-721a-9f0b-f597b5884a8e€15.00€0.26matched
50refund01a1a01e-05f2-71f6-bb46-961d51147a69-€9.00€0.00matched
51capture01a1a01e-5bca-7e10-8dd5-dda717b7cd87€35.00€0.50matched
52capture01a1a01e-59d4-74da-92dd-d245d26c61bb€9.00€0.19matched
53capture01a1a01e-5fdf-785f-bac8-7c4171879f90€9.00€0.19matched
54capture01a1a01e-7c4e-7881-9c1a-420998cd7ecc€24.00€0.37matched
55capture01a1a01e-7db9-7565-bda3-b1a504918899€35.00€0.50matched
56capture01a1a01e-80c7-7f84-b3df-b96193422f99€49.00€0.67matched
57capture01a1a01e-95ca-7429-9e56-b77c9f2471af€49.00€0.67matched
58capture01a1a01e-9bba-7eab-8427-de6e1b47bba6€9.00€0.19matched
59capture01a1a01e-b29c-7841-be99-1805fa47a2b5€24.00€0.37matched
60capture01a1a01e-c04f-74b1-bae6-480874b3086d€35.00€0.50matched
61capture01a1a01e-ce0d-7c02-ae27-6a086aca30de€15.00€0.26matched
62capture01a1a01e-d399-7a89-b641-d8c2ef32f0bb€49.00€0.67matched
63capture01a1a01e-d3d5-7229-b760-230237d4067c€35.00€0.50matched
64capture01a1a01e-d76e-7aa1-8775-4021e5e7ad35€9.00€0.19matched
65capture01a1a01f-003a-7169-b7da-76ed29361b9e€35.00€0.50matched
66capture01a1a01f-08ef-7628-a47e-e84ad88d33ea€49.00€0.67matched
67capture01a1a01f-1540-7262-a510-0b3428928540€15.00€0.26matched
68capture01a1a01f-33af-76f5-84dd-e36e50f10313€35.00€0.50matched
69capture01a1a01f-3415-7514-a82f-c3465c7a3824€9.00€0.19matched
70capture01a1a01f-3b50-72f7-9485-e03cb4d9832a€24.00€0.37matched
71capture01a1a01f-429c-738c-b1f5-06107077da4a€24.00€0.37matched
72capture01a1a01f-4fb0-7d3f-99d1-d2c7322e761d€15.00€0.26matched
73capture01a1a01f-7f49-77dd-addf-d440f166678a€24.00€0.37matched
74capture01a1a01f-ad98-7f19-971d-2f726b528e87€9.00€0.19matched
75capture01a1a01f-cf62-7bf9-95cf-4c498f0ddfc5€35.00€0.50matched
76capture01a1a01f-d520-7d7e-a384-8acc545d74c6€24.00€0.37matched
77capture01a1a01f-ec6d-7a6e-959e-d923765f1bb5€9.00€0.19matched
78capture01a1a01f-f5d4-70e2-9186-5124a4f40fde€49.00€0.67matched
79capture01a1a01f-fa43-7ec8-a742-464cfe082461€24.00€0.37matched
80capture01a1a01f-fbe7-7bf1-906a-65aaffa62b83€24.00€0.37matched
81capture01a1a020-07db-79a5-92aa-0b5fbf1dc038€24.00€0.37matched
82capture01a1a020-79b7-722d-8d14-9d7570f6553e€24.00€0.37matched
83capture01a1a020-7bd4-73fc-bc51-b614c8c4addd€24.00€0.37matched
84capture01a1a020-80df-7492-9937-0707bd2f7472€24.00€0.37matched
85capture01a1a020-81d3-79c3-87a6-a38a1ed55e84€9.00€0.19matched
86capture01a1a020-8a84-7a0d-ad51-3b8b4166a967€15.00€0.26matched
87capture01a1a020-9c9d-77c2-9402-a6cbb191478c€15.00€0.26matched
88capture01a1a020-b28f-7c22-996f-499495baee8a€9.00€0.19matched
89capture01a1a020-b676-755a-bdf5-131a65a5cf81€24.00€0.37matched
90capture01a1a020-bc17-710c-b9be-2583efe0c810€9.00€0.19matched
91capture01a1a020-cd07-7238-ab55-862351972bba€35.00€0.50matched
92capture01a1a020-f7f2-781e-8ebc-7d1e078ede76€49.00€0.67matched
93capture01a1a020-f96f-7fe3-8b9a-7268a6f2ee85€49.00€0.67matched
94capture01a1a021-11d1-7c21-b33f-6d9c9f787b2a€9.00€0.19matched
95capture01a1a021-2b32-73f0-ae4e-ea1a34dc988e€24.00€0.37matched
96refund01a1a021-2f48-704e-98f5-cfef9c987389-€26.00€0.00matched
97capture01a1a021-31fc-76a8-9398-1e3dcc9f5773€9.00€0.19matched
98capture01a1a021-34d6-7c8a-b8d4-f7aa6617506f€9.00€0.19matched
99capture01a1a021-53bd-71cb-8730-7120c4cfaad5€15.00€0.26matched
100capture01a1a021-56b0-7e49-881e-149ef52f016c€49.00€0.67matched
101capture01a1a021-59df-7450-a0b1-a08170edd40b€24.00€0.37matched
102capture01a1a021-6507-74ee-bfba-38d4de1940ed€24.00€0.37matched
103capture01a1a021-686b-7558-9e24-46e5ad2f64e7€24.00€0.37matched
104capture01a1a021-6b40-77f4-83d9-3bb2640e6a51€15.00€0.26matched
105capture01a1a021-6e1b-775b-8873-265aac65c5ef€15.00€0.26matched
106capture01a1a021-a11a-72da-8a8c-bafce28bed4c€15.00€0.26matched
107capture01a1a021-c4c9-7f85-8ac7-680cd7528b58€49.00€0.67matched
108capture01a1a021-fbd8-7480-8b42-c24c8844cd2b€35.00€0.50matched
109capture01a1a022-0991-70f4-ab0e-ad2c84e6a49b€15.00€0.26matched
110capture01a1a022-0e69-75e0-8fe1-481f483abaf3€35.00€0.50matched
111capture01a1a022-13ad-72eb-9775-9f02c1bb6f9d€9.00€0.19matched
112capture01a1a022-2cc6-7738-a900-f68eb687828e€24.00€0.37matched
113capture01a1a022-2ff3-7f0d-af73-5113899a449a€9.00€0.19matched
114capture01a1a022-4924-70ca-9a2d-86e729bcc436€24.00€0.37matched
115capture01a1a022-4b12-7793-a631-b40dbea458d3€49.00€0.67matched
116capture01a1a022-56c4-7ccf-b712-9b7cfdb1e151€35.00€0.50matched
117refund01a1a022-5a2e-7fb3-9645-b4894c2cd5b3-€4.00€0.00matched
118capture01a1a022-6906-7ff0-8b8e-e81f62a1f037€24.00€0.37matched
119capture01a1a022-a719-78cb-9d7a-f48b21486696€24.00€0.37matched
120capture01a1a022-b04e-7cf4-ac0a-56dc150a2aea€35.00€0.50matched