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

5 Nov, 23:10

Gross

€2,657.00

PSP fee

€43.75

Net to the bank

€2,613.25

Settlement journal

#405742

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 42, the contract says 37
  • missing linein the books, not in the filecapture:01a1adfc-9a0d-74f3-b218-10597c9462ec is in no file
  • missing linein the books, not in the filecapture:01a1ae00-4f58-7ca6-a9e0-cefa2185acc1 is in no file
LineKindReferenceGrossFeeStatus
5capture01a1adfa-1757-70b3-9e90-6e4f01ddc7b3€9.00€0.24fee difference
27capture01a1adfc-329b-76ed-90f2-cd514be8f087€24.00€0.42fee difference
1capture01a1adf3-0bb0-7644-afcc-dc5f28be91d6€9.00€0.19matched
2capture01a1adf4-ec3c-7990-872f-239c0fe3dfa5€24.00€0.37matched
3capture01a1adf9-f81e-7b1e-8062-f4c1ebe2865a€24.00€0.37matched
4capture01a1adf9-fa15-731c-9af8-74d18a4b2c92€9.00€0.19matched
6capture01a1adfa-201c-71b0-9c85-80be4382edc9€9.00€0.19matched
7capture01a1adfa-3d67-7a0c-b83d-ca2233fbb7ec€49.00€0.67matched
8capture01a1adfa-51a5-7df2-9c9e-8fc9087d8902€35.00€0.50matched
9capture01a1adfa-6dc7-7366-acb6-3edc1b9ff491€15.00€0.26matched
10refund01a1adfa-84c1-758a-b8b3-cd1a313fa3a3-€17.00€0.00matched
11capture01a1adfa-9168-7d78-9480-f26273301d86€15.00€0.26matched
12capture01a1adfa-8961-7b86-9333-bfe1c302c0e9€24.00€0.37matched
13capture01a1adfa-a776-7b45-8706-616f86f44c94€35.00€0.50matched
14capture01a1adfa-be2a-7d69-b554-fc8b973c6c7a€35.00€0.50matched
15capture01a1adfa-c6a7-7272-a1ff-c2b7381e0030€35.00€0.50matched
16refund01a1adfa-d88c-7d44-ac32-827f4c098b5f-€9.00€0.00matched
17capture01a1adfa-db35-7e61-9c16-b3a3b8e652b9€49.00€0.67matched
18capture01a1adfb-001d-7557-adaa-2b5c559ff544€15.00€0.26matched
19capture01a1adfb-35b9-709d-be28-86b7b23f0607€9.00€0.19matched
20capture01a1adfb-3d63-702c-ae36-5124fdfc6a86€9.00€0.19matched
21refund01a1adfb-459f-7127-831c-a2edda5b769e-€47.00€0.00matched
22capture01a1adfb-51b2-758a-8acc-58ab3077f49b€24.00€0.37matched
23capture01a1adfb-6c86-726e-943e-dea340a78e81€9.00€0.19matched
24capture01a1adfb-7c93-74eb-8307-6d38c7af3ae1€49.00€0.67matched
25capture01a1adfb-c8f2-79a1-8fc4-ec9a8bef4474€15.00€0.26matched
26capture01a1adfb-eb94-73fe-972a-a808644897c9€15.00€0.26matched
28capture01a1adfc-359a-7918-aefb-ecca5a1b3993€35.00€0.50matched
29capture01a1adfc-423b-70a7-a7d4-8b6512ed2d43€9.00€0.19matched
30capture01a1adfc-444f-7146-97c5-330e4d625604€49.00€0.67matched
31capture01a1adfc-4e5f-7927-af39-8f63eca7502e€9.00€0.19matched
32capture01a1adfc-4fda-7925-9692-d3d5cd3976c7€9.00€0.19matched
33capture01a1adfc-58cf-757f-a5c9-62e4d99a6610€9.00€0.19matched
34capture01a1adfc-6f24-7fe4-87e8-1591cd207527€49.00€0.67matched
35capture01a1adfc-8f75-7f52-aef1-194777d144f7€49.00€0.67matched
36capture01a1adfc-9431-7e6e-863c-a438fa583cf5€35.00€0.50matched
37capture01a1adfc-9996-751e-b012-22fa41dae700€15.00€0.26matched
38capture01a1adfc-ca05-799b-bb9a-0a0cf62d3044€15.00€0.26matched
39capture01a1adfc-e1e1-707d-8e00-839bcb1edea7€49.00€0.67matched
40capture01a1adfc-e473-77de-8ca7-2d0811a5752e€9.00€0.19matched
41capture01a1adfc-ebd2-771f-b0de-63aa90247044€15.00€0.26matched
42capture01a1adfc-f393-79d9-a28d-68b680b521df€24.00€0.37matched
43capture01a1adfc-f589-71f9-b732-473e2bac43cb€24.00€0.37matched
44capture01a1adfd-1d51-7cf7-a7f5-33ef77c80833€35.00€0.50matched
45refund01a1adfd-1f55-7727-b01f-870cf0d9c0de-€15.00€0.00matched
46capture01a1adfd-21cd-7bd0-95e3-cdbd86a213c9€15.00€0.26matched
47capture01a1adfd-3948-7a44-b664-c113b4e4404c€35.00€0.50matched
48capture01a1adfd-4460-7602-9bdf-07b71a60575b€15.00€0.26matched
49refund01a1adfd-44b7-7472-8dd6-5ca0807fb63f-€17.00€0.00matched
50capture01a1adfd-6d38-7267-8554-a0616929e21a€15.00€0.26matched
51capture01a1adfd-703e-7719-851a-ac6542c1c270€9.00€0.19matched
52capture01a1adfd-ba4e-710b-982f-77814a1d3ade€9.00€0.19matched
53capture01a1adfd-c0d6-7430-b028-779ee72e6c85€24.00€0.37matched
54capture01a1adfd-d49c-772a-b835-44d3f8d0836d€24.00€0.37matched
55capture01a1adfd-e1d6-705e-a141-3a2de40f490b€9.00€0.19matched
56capture01a1adfe-2ba0-76d3-adb5-569ff2841a3e€15.00€0.26matched
57capture01a1adfe-3395-7b27-89fe-cb77c3242fb0€9.00€0.19matched
58capture01a1adfe-473c-757d-96d3-059d4be45888€49.00€0.67matched
59capture01a1adfe-5430-7e93-b229-6ea1128a05a6€15.00€0.26matched
60capture01a1adfe-6087-7c0b-be0c-2694aa762917€49.00€0.67matched
61capture01a1adfe-9d96-7105-9d2e-da39d51b693d€35.00€0.50matched
62refund01a1adfe-b835-7ba3-a8c4-7e880732a824-€25.00€0.00matched
63capture01a1adfe-bab9-7ca1-8462-8764b549dadd€24.00€0.37matched
64capture01a1adfe-e3ce-7f43-beb3-3223955f130d€49.00€0.67matched
65capture01a1adfe-e92b-72fd-9d8f-8afc300d3c3a€15.00€0.26matched
66capture01a1adfe-edb5-7c5e-816d-800b390ec34f€35.00€0.50matched
67capture01a1adfe-f971-70d6-bafd-14fe4dde15b7€49.00€0.67matched
68capture01a1adfe-fdaa-722e-a08b-309391f1a2a7€35.00€0.50matched
69capture01a1adff-0258-77d4-b6bb-068cbb5d0ab0€35.00€0.50matched
70capture01a1adff-3367-7d67-b9a2-26a9265de16e€49.00€0.67matched
71capture01a1adff-364b-7350-9bb4-48c75a449126€49.00€0.67matched
72capture01a1adff-3747-7b65-94ce-669a3866702a€35.00€0.50matched
73capture01a1adff-4805-7c8c-b613-881ffa5cdfbb€49.00€0.67matched
74capture01a1adff-4f14-7f53-abad-10e527ee66d0€24.00€0.37matched
75capture01a1adff-6ff2-7810-95c0-b3a37914fed2€15.00€0.26matched
76capture01a1adff-8009-7234-a1d6-9ec54e1fdcdf€9.00€0.19matched
77capture01a1adff-9790-7887-bccc-ea9f37e20117€15.00€0.26matched
78capture01a1adff-9dcf-7b9c-8624-a01222788e9c€15.00€0.26matched
79capture01a1adff-aaf3-745e-813f-64c6524ff259€24.00€0.37matched
80capture01a1adff-d3bb-7800-9a91-54886fab1b20€49.00€0.67matched
81capture01a1adff-f8cc-7e47-af2b-7996ad07f101€9.00€0.19matched
82capture01a1ae00-0b05-7911-9a0e-7419e3e9ad96€9.00€0.19matched
83refund01a1ae00-0c95-72dd-a589-8bbaa4131d3a-€20.00€0.00matched
84capture01a1ae00-1fda-7a1b-8273-aa4ea8b1d6c8€15.00€0.26matched
85capture01a1ae00-327c-7457-acd6-2867a9e47b02€49.00€0.67matched
86capture01a1ae00-3cbc-796f-8754-f9739767033b€49.00€0.67matched
87capture01a1ae00-3ce1-7db0-b890-93bb601052c3€49.00€0.67matched
88capture01a1ae00-3d76-797a-889d-419133c0d4c3€49.00€0.67matched
89capture01a1ae00-5f69-7950-a342-139523055b44€15.00€0.26matched
90capture01a1ae00-8534-7485-814a-48c186a21136€15.00€0.26matched
91refund01a1ae00-93dc-7859-bb0b-dc1dea722744-€9.00€0.00matched
92refund01a1ae00-a796-7d67-a22a-2af2d65d1d69-€15.00€0.00matched
93capture01a1ae00-ce80-73ba-b017-4a4e669dd1a8€9.00€0.19matched
94capture01a1ae00-e317-7ec8-a5ad-8862db872c67€49.00€0.67matched
95capture01a1ae00-e5c0-7859-9638-fde31e75d92b€49.00€0.67matched
96refund01a1ae01-0b52-731a-b8bc-7b4c99934cf6-€43.00€0.00matched
97capture01a1ae01-0eb0-7e7c-80bc-b6e5458b203c€15.00€0.26matched
98capture01a1ae01-188a-7312-9612-097032546c42€35.00€0.50matched
99capture01a1ae01-2dfd-7405-9f19-997b5860674b€49.00€0.67matched
100capture01a1ae01-4838-7166-af7d-af2238d92062€49.00€0.67matched
101capture01a1ae01-4b93-7e89-99e7-6e425e84b51c€9.00€0.19matched
102capture01a1ae01-58d8-7305-829d-57072068af21€15.00€0.26matched
103capture01a1ae01-62c9-7dd4-aae9-29ea68db232d€9.00€0.19matched
104refund01a1ae01-6b39-7833-ba60-ea57ffaaa0a6-€12.00€0.00matched
105capture01a1ae01-8809-742e-ba0c-0387c951b5b1€9.00€0.19matched
106capture01a1ae01-b886-7d08-b26d-bade14c52397€49.00€0.67matched
107capture01a1ae01-b996-7731-8d6c-50eacf427a7b€35.00€0.50matched
108capture01a1ae01-ceb5-7ebe-8f8f-2a56bf4c1c1c€9.00€0.19matched
109capture01a1ae01-f463-721b-9d2c-5020dd3afd1f€9.00€0.19matched
110capture01a1ae01-f7c1-7b6c-82a9-b9e4a5675cbf€24.00€0.37matched
111capture01a1ae02-21b3-7332-9e5a-c4ec0fea99c2€9.00€0.19matched
112capture01a1ae02-47d4-70dd-b0ca-6d365985c2fc€15.00€0.26matched
113capture01a1ae02-6496-79c6-a06d-2d3666e64721€49.00€0.67matched
114capture01a1ae02-76a7-7435-93c1-957a34b304c6€49.00€0.67matched
115capture01a1ae02-9918-706a-a14e-6074a53b563c€49.00€0.67matched
116capture01a1ae02-ab1a-7ba7-af28-b9697213df7a€9.00€0.19matched
117capture01a1ae02-abfe-7164-9de7-857e71ee8879€9.00€0.19matched
118capture01a1ae02-bc78-7d79-9a0b-5c3009d0a15a€35.00€0.50matched
119capture01a1ae02-c134-7d52-9776-c4445515f60b€35.00€0.50matched
120capture01a1ae02-c67a-7082-97f7-71fdc1f5265f€15.00€0.26matched
121capture01a1ae02-d9c2-7e42-8b26-9a022d03f4a0€9.00€0.19matched
122capture01a1ae02-dec1-70e3-aa02-bc731794b91d€35.00€0.50matched