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

Gross

€2,615.00

PSP fee

€40.89

Net to the bank

€2,574.11

Settlement journal

#374899

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a1a551-c5ea-72da-80f3-4c66ddc039ae is already settled by stl_EUR_2989624 line 100
  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
  • missing linein the books, not in the filecapture:01a1a552-03bd-7f41-bed7-b747b846cc2b is in no file
LineKindReferenceGrossFeeStatus
42capture01a1a54c-c3e0-7a33-b2bf-80d55c2b488b€15.00€0.31fee difference
101refund01a1a551-c5ec-7a13-98da-9b0bccdd45d2-€9.00€0.00duplicate line
1capture01a1a542-ec31-767c-a234-734237c36419€24.00€0.37matched
2capture01a1a548-ea1f-743e-81d9-2f0861523ace€49.00€0.67matched
3capture01a1a549-4075-7369-b2d7-b0f92005c403€9.00€0.19matched
4capture01a1a549-46b2-7b0b-a400-03f8164ad156€24.00€0.37matched
5capture01a1a549-4924-763a-adf3-6a679ad7968f€9.00€0.19matched
6capture01a1a549-7450-745f-8f3f-335ac28f56e2€15.00€0.26matched
7capture01a1a549-8afb-7dc0-8df5-4178deef21fa€35.00€0.50matched
8capture01a1a549-8afb-7626-8e55-137b70a054cc€35.00€0.50matched
9capture01a1a549-8e66-76a7-b0a2-c500687f2139€35.00€0.50matched
10refund01a1a549-a5f8-7612-9e7b-8dfca9757327-€13.00€0.00matched
11capture01a1a549-a6e6-734d-88bf-d6efacbf8007€24.00€0.37matched
12capture01a1a549-d460-7335-b06e-6ef5294a84bf€35.00€0.50matched
13capture01a1a549-d92a-74f6-87f3-9d5aeb09fdb7€15.00€0.26matched
14refund01a1a54a-02b4-72bf-8b0e-5d9cd1253e7a-€9.00€0.00matched
15refund01a1a54a-0590-7f87-97cb-b33b21cb6186-€8.00€0.00matched
16capture01a1a54a-1f5a-7c4b-829b-565ab2851659€35.00€0.50matched
17capture01a1a54a-23d6-7dc0-960c-75c0224f9017€49.00€0.67matched
18capture01a1a54a-532e-72c1-aee4-20f5ae2a49a9€49.00€0.67matched
19capture01a1a54a-894c-731a-8d47-e2c1eadea3ef€24.00€0.37matched
20capture01a1a54a-9570-7e6d-a3e0-bd5e822271f4€49.00€0.67matched
21capture01a1a54a-a077-75e8-9256-75f50b7e17c7€49.00€0.67matched
22capture01a1a54a-b9d8-7cf9-857d-877db344501a€35.00€0.50matched
23capture01a1a54a-cd26-72d3-9414-2d01dd29f6e9€15.00€0.26matched
24capture01a1a54a-f927-713b-b2d4-da802b1b80ae€9.00€0.19matched
25capture01a1a54b-137f-7865-8d23-f4083796e5de€15.00€0.26matched
26capture01a1a54b-15b2-7889-8e26-695c32c3618e€35.00€0.50matched
27capture01a1a54b-25f1-76e5-b889-63c10a9bc21a€49.00€0.67matched
28capture01a1a54b-631b-76fa-ae71-4314ceb8782d€35.00€0.50matched
29capture01a1a54b-6f94-794e-affa-8b66fe5e8884€15.00€0.26matched
30capture01a1a54b-8284-7993-b8fd-25d07fe6452c€9.00€0.19matched
31capture01a1a54b-98e5-70d0-a541-fabec5ec60ba€35.00€0.50matched
32capture01a1a54b-ad44-7143-b985-83f77a6ebbac€49.00€0.67matched
33capture01a1a54b-adde-72ac-86e2-18148b34c2cd€35.00€0.50matched
34capture01a1a54b-e1ad-724d-a410-77ab537b1eeb€49.00€0.67matched
35capture01a1a54b-f89d-773a-81dd-f5a428443735€24.00€0.37matched
36capture01a1a54c-1861-7b0c-942f-45eeeb1dd681€24.00€0.37matched
37capture01a1a54c-3591-78ba-b626-2186afc910ec€35.00€0.50matched
38capture01a1a54c-36ca-7d8b-b0a9-3bda2824f705€9.00€0.19matched
39capture01a1a54c-3e39-748d-8b3a-500d8b6cbd48€35.00€0.50matched
40capture01a1a54c-7291-727a-a2d8-b37ec9525f21€24.00€0.37matched
41capture01a1a54c-94ca-7d4a-bd20-d98bcb0f4a61€24.00€0.37matched
43refund01a1a54c-ca7c-7736-b643-b802cde3da52-€19.00€0.00matched
44capture01a1a54c-efda-70ff-8ccd-aa1b5071fe95€9.00€0.19matched
45capture01a1a54c-f129-731c-8af5-fad7dada36b8€35.00€0.50matched
46capture01a1a54c-f93c-745b-9231-c7d6eebf3741€35.00€0.50matched
47capture01a1a54d-0510-7650-b29f-7c121b902d05€35.00€0.50matched
48capture01a1a54d-3d75-7147-b428-cbfc612ad5b4€15.00€0.26matched
49capture01a1a54d-445b-7709-8523-d97b44b45724€35.00€0.50matched
50refund01a1a54d-4e8e-700d-a90b-1fe431c09fc9-€33.00€0.00matched
51capture01a1a54d-5a3b-7ede-9867-9effa9e2a723€9.00€0.19matched
52refund01a1a54d-6ba1-70ca-a2f9-831f5145484b-€8.00€0.00matched
53capture01a1a54d-7632-7eff-adb0-bcaee567a3ea€49.00€0.67matched
54capture01a1a54d-78a7-782c-ab3e-15ff54f1f03f€35.00€0.50matched
55capture01a1a54d-7c57-7eb5-bdf2-3be6adb2da60€24.00€0.37matched
56capture01a1a54d-899a-79c1-a19f-161dd2be2f99€9.00€0.19matched
57capture01a1a54d-8fb2-7007-a1f3-4209ad3d516d€24.00€0.37matched
58capture01a1a54d-9013-7399-8aa5-4d82d84f75c1€24.00€0.37matched
59capture01a1a54d-905e-73bf-bef9-9c4b74dcc3b1€35.00€0.50matched
60capture01a1a54d-a658-7e89-a478-2422f7d6841b€15.00€0.26matched
61capture01a1a54d-b9fd-7303-8b13-a9cbc3b2e4f1€24.00€0.37matched
62capture01a1a54d-c32e-7273-b8c7-2817adb2dbf5€15.00€0.26matched
63capture01a1a54d-cae7-7348-9746-14d4abcd9fb1€35.00€0.50matched
64capture01a1a54d-cd5d-7588-b9eb-c3019cd5f3e3€24.00€0.37matched
65capture01a1a54d-e3d6-7390-95d4-8c92843da56e€9.00€0.19matched
66capture01a1a54d-e53b-7b74-800e-cc59b22fabc3€49.00€0.67matched
67capture01a1a54d-ed72-72dc-a9df-cee881eb20ce€35.00€0.50matched
68capture01a1a54d-f1d3-70a3-8c8d-bf7778d4bdd9€15.00€0.26matched
69capture01a1a54d-f35d-766e-8bbb-31f8180a9dbd€24.00€0.37matched
70capture01a1a54e-08b0-7935-9484-852f446432b5€9.00€0.19matched
71capture01a1a54e-1799-7260-8cd9-59eecac049b1€35.00€0.50matched
72capture01a1a54e-3924-75b5-92d6-fe16b0ba99ae€35.00€0.50matched
73capture01a1a54e-5c84-7757-925f-da264d5bb2c5€9.00€0.19matched
74capture01a1a54e-7eb6-7489-9d95-5409b74e88c7€35.00€0.50matched
75capture01a1a54e-8a56-7a1c-bd7f-f8241a77087b€15.00€0.26matched
76capture01a1a54e-ad28-722b-9b7b-dbc361717a0b€9.00€0.19matched
77refund01a1a54e-dc46-71ce-9324-638cc2635184-€4.00€0.00matched
78capture01a1a54f-26e6-70d1-897a-bffc64eda643€35.00€0.50matched
79capture01a1a54f-70ec-71a5-a503-2b3cfc955c80€49.00€0.67matched
80capture01a1a54f-b7ba-7ff7-b86b-4c89f09cc864€24.00€0.37matched
81capture01a1a54f-bab5-7e4b-aab7-74e8ba6066fc€9.00€0.19matched
82capture01a1a54f-c964-7a3d-8492-895b0d101401€9.00€0.19matched
83capture01a1a54f-dc97-7a71-9323-0cda3502bac0€35.00€0.50matched
84capture01a1a54f-eb4e-718b-9999-a3a19a3b04f6€15.00€0.26matched
85capture01a1a550-189d-7d6b-a595-cb5f6d3f08d8€49.00€0.67matched
86capture01a1a550-346a-7e8d-89dd-a03d0e85233a€35.00€0.50matched
87capture01a1a550-6e8e-72d9-afe5-0e7dca82797c€35.00€0.50matched
88capture01a1a550-7c25-7c05-b3f9-0684a13f2273€9.00€0.19matched
89capture01a1a550-8d53-7644-9f43-49b7933b2f36€49.00€0.67matched
90capture01a1a550-c58f-7547-b503-0bbe95f0200a€15.00€0.26matched
91refund01a1a550-e0af-706a-b2fc-9145f0215ec9-€14.00€0.00matched
92capture01a1a551-0b8b-7087-ab25-03c0a25e9aa7€49.00€0.67matched
93capture01a1a551-240e-7c52-b92f-33688a0b2140€9.00€0.19matched
94capture01a1a551-28ca-7067-bdb0-c2e1df88088c€9.00€0.19matched
95capture01a1a551-5fe4-79cf-b078-04c5dca2dea3€49.00€0.67matched
96capture01a1a551-6e0d-75f4-8d6f-b5930a603852€49.00€0.67matched
97capture01a1a551-989c-770d-a38e-4556f0647c30€9.00€0.19matched
98capture01a1a551-9fc2-73b9-ba58-9608d29ba6cc€49.00€0.67matched
99capture01a1a551-adea-7f58-b9f7-0bf3ee1a5989€49.00€0.67matched
100refund01a1a551-c5ec-7a13-98da-9b0bccdd45d2-€9.00€0.00matched
102capture01a1a551-d315-7287-bbfb-41a5d48682fc€15.00€0.26matched
103capture01a1a551-dc2d-75e8-8de4-6c8f952f95f3€49.00€0.67matched
104capture01a1a551-e019-7289-9ee6-af566e1b1744€15.00€0.26matched
105capture01a1a552-1dca-7d40-82d1-be06057ac85b€35.00€0.50matched
106capture01a1a552-21a1-7f27-9804-a50a8bd6c7fb€35.00€0.50matched
107capture01a1a552-3be2-7f5a-a6f8-fdbc743129b4€24.00€0.37matched
108capture01a1a552-443d-78c9-9c85-a0c8b77242ff€24.00€0.37matched