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, 07:20

Gross

€2,681.00

PSP fee

€43.50

Net to the bank

€2,637.50

Settlement journal

#393662

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • missing linein the books, not in the filerefund:01a1aa98-6c54-7be1-9e65-8efebdeec9cd is in no file
  • missing linein the books, not in the filecapture:01a1aa9a-eb80-74a8-a312-4f95cee1dfe3 is in no file
  • missing linein the books, not in the filecapture:01a1aa9c-89c5-7edf-9538-62853121844b is in no file
LineKindReferenceGrossFeeStatus
59capture01a1aa98-1c42-74b3-8151-64fb351fe476€9.00€0.21fee difference
72capture01a1aa99-0a64-733c-a289-6311bfb6b99b€24.00€0.38fee difference
122capture01a1aa9c-e93c-7cec-ab3e-b16bff73a88b€15.00€0.31fee difference
1capture01a1aa8d-2d22-7160-b8b9-a3e7d53e1fd4€24.00€0.37matched
2capture01a1aa91-84a4-7a7b-8f44-d66270f878c5€9.00€0.19matched
3capture01a1aa91-d804-7abe-a3b5-bc72cada17c3€24.00€0.37matched
4capture01a1aa94-3e91-7503-9241-e155aa54bd49€24.00€0.37matched
5capture01a1aa94-46dd-7b0a-b172-5710ed05677f€24.00€0.37matched
6capture01a1aa94-55fe-7f88-a504-8f10cd2ba632€9.00€0.19matched
7capture01a1aa94-5e28-7568-b958-81a71ae5c661€24.00€0.37matched
8capture01a1aa94-6055-7702-87eb-5bdf987df64a€49.00€0.67matched
9capture01a1aa94-6c52-79ac-ae04-22f401d3b1a1€15.00€0.26matched
10capture01a1aa94-7721-7d37-899a-6f0331daa437€9.00€0.19matched
11refund01a1aa94-8c51-7892-92ce-d73540a09608-€14.00€0.00matched
12capture01a1aa94-b8f7-7c7d-9f86-5f14838f65e6€35.00€0.50matched
13capture01a1aa94-d6d2-761e-9dca-878a0df07a5b€15.00€0.26matched
14capture01a1aa94-e48f-7d47-b68c-36f8ef9e4cc7€49.00€0.67matched
15capture01a1aa94-e543-7106-9ac4-6c7b97ca3aa7€24.00€0.37matched
16capture01a1aa94-e76d-74d4-ad2c-f98dbdd1dbd2€49.00€0.67matched
17capture01a1aa94-e81a-7780-bbfe-1f0484253a42€24.00€0.37matched
18capture01a1aa94-f4db-7f9c-8487-252ac946eed0€35.00€0.50matched
19capture01a1aa95-0177-7aa9-abb1-44951bcbf763€9.00€0.19matched
20refund01a1aa95-12d9-78e1-b04f-0787ac6c100f-€13.00€0.00matched
21capture01a1aa95-130f-72af-9c3f-809e60a74f6d€9.00€0.19matched
22capture01a1aa95-1b80-73f6-9de3-c92f35b8ea77€15.00€0.26matched
23capture01a1aa95-25df-74b8-812f-e82b73ebcfdb€9.00€0.19matched
24capture01a1aa95-2b1a-7a3a-875c-37f1f6c3e602€15.00€0.26matched
25capture01a1aa95-2f5c-7286-9a9e-97574ee45da1€49.00€0.67matched
26capture01a1aa95-3f1b-7121-9cc9-2b84fa9534f4€24.00€0.37matched
27capture01a1aa95-78c2-761a-a469-53e40746bef4€9.00€0.19matched
28capture01a1aa95-7ec2-7229-81d4-5e5928c9c734€15.00€0.26matched
29capture01a1aa95-9b1d-795d-a9f7-0d34972c1826€24.00€0.37matched
30capture01a1aa95-b402-71df-837f-b259445dde85€24.00€0.37matched
31capture01a1aa95-ce19-7aa0-9a03-032aa4c261c1€15.00€0.26matched
32capture01a1aa95-db6e-7127-9987-ff0cf0bce427€9.00€0.19matched
33refund01a1aa96-0b30-78b1-9e28-037cef4dd3cb-€7.00€0.00matched
34capture01a1aa96-01b6-74f6-aff1-0e8ded5fbef0€15.00€0.26matched
35capture01a1aa96-4f42-7f7f-87f1-b56db57645b5€49.00€0.67matched
36capture01a1aa96-5fda-78ec-a115-3d386f6b16b7€15.00€0.26matched
37capture01a1aa96-9cdf-7143-94bb-7db2012fcefa€49.00€0.67matched
38capture01a1aa96-a328-72d1-8e77-72aad3c2be8c€24.00€0.37matched
39capture01a1aa96-d77e-777e-a111-6d3c879f35ac€35.00€0.50matched
40capture01a1aa96-e46a-7102-8e3d-c63cfebd3ff2€35.00€0.50matched
41capture01a1aa96-ebd1-7137-aba3-35cf623cce92€49.00€0.67matched
42capture01a1aa97-025b-753c-b6e9-8b29bc8bb739€15.00€0.26matched
43capture01a1aa97-165a-7e9c-958c-e8e6a1adc653€35.00€0.50matched
44capture01a1aa97-17f0-7e7f-a401-58580eeb0c0a€15.00€0.26matched
45capture01a1aa97-36df-7897-9ec1-88ad58135ee0€9.00€0.19matched
46capture01a1aa97-3904-7079-8345-eb85ba01dd07€9.00€0.19matched
47capture01a1aa97-7b78-70aa-a942-d6d00cc38bd1€24.00€0.37matched
48capture01a1aa97-6db3-738c-abc6-db8418a33e37€35.00€0.50matched
49capture01a1aa97-967c-7aa9-af3f-9a04d5fce8f9€49.00€0.67matched
50capture01a1aa97-9cbe-77da-b90a-de281fac348d€35.00€0.50matched
51capture01a1aa97-b3ed-72c6-ab23-de1a570762ad€24.00€0.37matched
52capture01a1aa97-c9ac-7f59-9e46-4bf9e469b8fc€9.00€0.19matched
53refund01a1aa97-dc08-746d-a7b9-37f89e7d89aa-€35.00€0.00matched
54capture01a1aa97-ef9f-7432-be63-84831c67b1bf€24.00€0.37matched
55capture01a1aa97-f585-7e0f-bba2-fe713d2f251f€24.00€0.37matched
56capture01a1aa97-f621-7202-a688-13a8d38292bd€15.00€0.26matched
57capture01a1aa98-0f09-7830-978e-069cef3cbce8€9.00€0.19matched
58capture01a1aa98-11d7-7fe2-b779-2ea3bf21ac68€9.00€0.19matched
60capture01a1aa98-4a5c-77d6-825c-e42c6668610d€24.00€0.37matched
61capture01a1aa98-526b-7bbc-bfa1-17b7b5c09a44€49.00€0.67matched
62capture01a1aa98-5643-76f9-aac6-c43c172a535d€24.00€0.37matched
63capture01a1aa98-7d3b-7890-ab24-a71135cd2168€35.00€0.50matched
64capture01a1aa98-998f-7641-9daa-ffacdc8f791e€49.00€0.67matched
65refund01a1aa98-b8f6-7d6c-9570-5aa8b0d2c20a-€20.00€0.00matched
66capture01a1aa98-bb81-7195-93d6-646633c2314c€35.00€0.50matched
67refund01a1aa98-ca4e-70cf-b6ba-402287b3be7e-€19.00€0.00matched
68capture01a1aa98-d454-7a40-93a4-f33f220b16b0€15.00€0.26matched
69capture01a1aa98-e1a9-70de-86e4-b262cab67e1f€9.00€0.19matched
70capture01a1aa98-fcfd-7e71-a6e3-28113eef9612€35.00€0.50matched
71capture01a1aa99-051a-7688-9dda-dd836ec30f80€49.00€0.67matched
73capture01a1aa99-0c0a-77de-b56a-00cb2794df9d€24.00€0.37matched
74capture01a1aa99-0cc3-7627-af44-dbd9d3eed588€24.00€0.37matched
75capture01a1aa99-1084-710b-9344-c01f3c065a3e€9.00€0.19matched
76capture01a1aa99-1f9f-7e43-8770-8fe16d07d149€15.00€0.26matched
77capture01a1aa99-47c5-7f25-9da2-bc865246f26f€24.00€0.37matched
78capture01a1aa99-714d-7621-b6d2-9c4fcd4e74e3€9.00€0.19matched
79capture01a1aa99-80ed-7382-a9f4-270dae167898€35.00€0.50matched
80capture01a1aa99-913f-7f44-9021-090e05d482c5€24.00€0.37matched
81capture01a1aa99-9f6a-7082-acf4-18ce45bc7812€49.00€0.67matched
82capture01a1aa99-a2a7-74ee-8ef6-1e483db37256€24.00€0.37matched
83capture01a1aa99-a379-729a-9177-cf9f684e44c1€9.00€0.19matched
84capture01a1aa99-d4e2-73af-9192-933d853944f1€35.00€0.50matched
85capture01a1aa99-df56-77ab-bd7b-7691b1c2d649€15.00€0.26matched
86refund01a1aa99-f04d-76b3-be34-c289fea3f931-€22.00€0.00matched
87capture01a1aa99-f603-7dfb-a45d-3dc0b97f230e€24.00€0.37matched
88capture01a1aa99-fbe8-70ed-badd-e4d0d0473b3c€24.00€0.37matched
89capture01a1aa99-ef95-71d2-ab2c-8a56d360e6c4€24.00€0.37matched
90capture01a1aa9a-49bf-7636-9ab5-9ad80663e2a2€9.00€0.19matched
91capture01a1aa9a-714c-726f-bccf-742c715b7a02€15.00€0.26matched
92capture01a1aa9a-86f2-7cca-ad26-c4e461d0d464€49.00€0.67matched
93capture01a1aa9a-a4f0-7907-80c6-7fc25b62d172€9.00€0.19matched
94capture01a1aa9a-ca27-7f34-b79d-139f9f940f59€24.00€0.37matched
95capture01a1aa9a-ecd4-7e15-953d-8a97ef961352€9.00€0.19matched
96capture01a1aa9b-2827-766f-912d-82a9b8537aaa€24.00€0.37matched
97capture01a1aa9b-2f55-7f94-981f-351996c88af6€24.00€0.37matched
98refund01a1aa9b-4ef5-7472-a2f7-2a33f8afcc8f-€2.00€0.00matched
99capture01a1aa9b-8caa-7b8d-861c-05b7653ba210€24.00€0.37matched
100capture01a1aa9b-9310-711d-aff8-4e7fd2cc8d34€9.00€0.19matched
101capture01a1aa9b-a141-7905-a61b-cea4d194430d€9.00€0.19matched
102capture01a1aa9b-a663-7742-960a-8a6fecbb9eec€49.00€0.67matched
103capture01a1aa9b-bb22-7d4f-944c-7584eb1a185b€9.00€0.19matched
104capture01a1aa9b-d6cd-7500-9c16-231decd1cb38€49.00€0.67matched
105capture01a1aa9b-ed47-7a58-965b-c26886df2a57€9.00€0.19matched
106capture01a1aa9b-ee13-7504-aae2-456ad6168e57€49.00€0.67matched
107capture01a1aa9b-f27c-7283-9166-73974843d133€24.00€0.37matched
108capture01a1aa9c-1136-7838-9571-4b8a960a8bc5€15.00€0.26matched
109capture01a1aa9c-1414-708c-9a52-445b075366e0€35.00€0.50matched
110refund01a1aa9c-186d-7f95-b440-b27599b8af33-€7.00€0.00matched
111refund01a1aa9c-18b8-7404-8130-a3a400a1af51-€25.00€0.00matched
112capture01a1aa9c-26ca-7c11-8a1a-558334e8fc29€49.00€0.67matched
113capture01a1aa9c-5407-71cb-bb33-d3ecb385c806€49.00€0.67matched
114capture01a1aa9c-5a66-7fd9-b9de-685559209f04€9.00€0.19matched
115capture01a1aa9c-65b1-7e50-bd93-b6091bcb6e9a€24.00€0.37matched
116capture01a1aa9c-6672-7907-85d0-9802493ac60f€35.00€0.50matched
117capture01a1aa9c-7e4b-741c-b14d-7870c4b3b26c€15.00€0.26matched
118capture01a1aa9c-a3b2-76b5-adb1-8171d1706fc1€49.00€0.67matched
119capture01a1aa9c-a44b-763b-8d25-350bfd4925ac€9.00€0.19matched
120capture01a1aa9c-a7ef-7481-853b-ca1742212afe€49.00€0.67matched
121capture01a1aa9c-c67a-7d01-a251-2f0689f4d2d2€24.00€0.37matched
123capture01a1aa9c-f5f2-708d-9f14-a0b84e2b19bc€35.00€0.50matched
124capture01a1aa9d-2bfc-73ee-b942-d2109801baa0€35.00€0.50matched