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

Gross

€3,060.00

PSP fee

€47.70

Net to the bank

€3,012.30

Settlement journal

#399297

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ac29-fb55-7dc4-bfa5-d045cd504c0e is already settled by stl_EUR_2989816 line 49
  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
LineKindReferenceGrossFeeStatus
20capture01a1ac28-46b6-76e3-b13d-fc4c6f9e4c6b€35.00€0.53fee difference
50capture01a1ac29-fb7f-7527-b2e2-8400ec87bbe9€49.00€0.67duplicate line
1capture01a1ac22-8d79-7144-85fc-f848e39f7328€49.00€0.67matched
2capture01a1ac27-437f-7037-878c-1d2569da000b€24.00€0.37matched
3capture01a1ac27-6473-70ab-8956-ce2f9341a7f7€49.00€0.67matched
4capture01a1ac27-7e85-7678-af78-4e37797453ed€24.00€0.37matched
5capture01a1ac27-81bd-7aae-a998-2ef51547f15f€49.00€0.67matched
6capture01a1ac27-a4cd-74c1-a3a6-0793fbd96910€24.00€0.37matched
7capture01a1ac27-c3f5-752f-8323-bcd09d110c5b€24.00€0.37matched
8capture01a1ac27-e548-7a6a-99ae-b567d2e29472€24.00€0.37matched
9capture01a1ac27-e5cf-77e7-ba64-ed4a2e15bdbc€35.00€0.50matched
10capture01a1ac27-eeea-709f-813b-2842c7c25021€49.00€0.67matched
11refund01a1ac27-f6a4-7916-bbb0-95c8afab2560-€12.00€0.00matched
12capture01a1ac27-f88a-753d-a54e-419ef0d4fc45€35.00€0.50matched
13capture01a1ac27-ff6a-7e31-82a2-7f1be155100c€15.00€0.26matched
14capture01a1ac28-092d-770a-a753-fd95ff6d2b80€49.00€0.67matched
15capture01a1ac28-201d-73ca-bdbd-461aafd7d7bf€15.00€0.26matched
16capture01a1ac28-2c38-7048-819e-fbcc84bc357b€35.00€0.50matched
17capture01a1ac28-2f99-7049-a478-0fc884dabaea€24.00€0.37matched
18capture01a1ac28-4055-71cc-a08b-87a155e30c77€49.00€0.67matched
19capture01a1ac28-45e6-73c0-b3e0-856826521562€9.00€0.19matched
21capture01a1ac28-47bd-7d9e-9328-a7cdf3d2027c€15.00€0.26matched
22capture01a1ac28-5981-7564-9bac-8af459c2de20€24.00€0.37matched
23capture01a1ac28-698f-713a-a5cc-c3d4d5daf90e€15.00€0.26matched
24capture01a1ac28-7c7e-7d7b-bd7b-628ad5c04b16€24.00€0.37matched
25capture01a1ac28-9405-7094-b15c-bff8d860e7a3€15.00€0.26matched
26capture01a1ac28-9b99-7395-aa96-dcd69e3100af€35.00€0.50matched
27capture01a1ac28-acd6-7ff4-9656-63ce176e62fd€24.00€0.37matched
28refund01a1ac28-c176-7c27-991b-02e8173fc66f-€17.00€0.00matched
29capture01a1ac28-ce33-7fa6-aa9f-14d8f20f17a2€9.00€0.19matched
30capture01a1ac28-d393-70ec-b191-11c081541d93€49.00€0.67matched
31capture01a1ac28-d9c0-7dfe-89ee-ede64d673a64€49.00€0.67matched
32refund01a1ac28-f3e5-71b7-a969-9b544f94d5b7-€17.00€0.00matched
33capture01a1ac29-0531-70d1-b3eb-19f82b29a678€24.00€0.37matched
34capture01a1ac29-2638-7069-8f66-807447d88cc2€9.00€0.19matched
35capture01a1ac29-6b32-7691-a50d-4bbbb5380807€24.00€0.37matched
36capture01a1ac29-8036-72c9-97d6-c24f5b143fb1€35.00€0.50matched
37capture01a1ac29-8494-78bb-a756-fa4fd3dde59c€35.00€0.50matched
38capture01a1ac29-895f-725a-9cf5-357091268670€24.00€0.37matched
39capture01a1ac29-9314-7bd2-99b5-0037c8b49b04€35.00€0.50matched
40capture01a1ac29-a9bc-7f77-9bf9-7fd2d4cecd72€35.00€0.50matched
41capture01a1ac29-b6e1-7efd-b50b-a694879cd403€49.00€0.67matched
42capture01a1ac29-b920-77ec-8260-e1618decd0a2€35.00€0.50matched
43capture01a1ac29-bb43-71c4-a88d-4b90c4cc660b€35.00€0.50matched
44capture01a1ac29-bd64-7be1-a2d0-322668e45439€24.00€0.37matched
45capture01a1ac29-c6c7-787e-be19-69ed3c88925f€9.00€0.19matched
46refund01a1ac29-e951-7324-8603-8230dbd5a946-€18.00€0.00matched
47capture01a1ac29-f763-7de2-af13-377df6494bed€9.00€0.19matched
48capture01a1ac29-fa1c-7ea8-994e-60b204c18bab€49.00€0.67matched
49capture01a1ac29-fb7f-7527-b2e2-8400ec87bbe9€49.00€0.67matched
51capture01a1ac2a-078b-7355-93e3-35f5c74fc7a1€35.00€0.50matched
52capture01a1ac2a-0bfc-7449-afdb-07235030e366€49.00€0.67matched
53capture01a1ac2a-3876-78b4-becc-7346bf6815cd€24.00€0.37matched
54capture01a1ac2a-3fef-74da-9684-4e9b8e53deb9€9.00€0.19matched
55capture01a1ac2a-4c3f-7cfe-b456-4146e995ab7c€24.00€0.37matched
56capture01a1ac2a-700f-737d-8582-e6f39bf3c7a8€15.00€0.26matched
57refund01a1ac2a-8894-7b0a-92bb-13e3b5f762eb-€20.00€0.00matched
58capture01a1ac2a-9042-7837-a541-dcb86e9f40eb€35.00€0.50matched
59capture01a1ac2a-903f-7c39-86d5-fa8e27822011€24.00€0.37matched
60capture01a1ac2a-a5fe-7eb6-ba69-c56598e0a3ac€35.00€0.50matched
61capture01a1ac2a-ab3d-7780-bb33-993f3a0436ad€9.00€0.19matched
62capture01a1ac2a-be74-7d69-98ac-4e0469867bf5€9.00€0.19matched
63capture01a1ac2a-c00f-75ca-90d3-e0ac0514856d€24.00€0.37matched
64capture01a1ac2a-c830-729b-a4d5-06ff57aa8f87€15.00€0.26matched
65capture01a1ac2a-d1df-784f-86b7-185bc2feb96d€49.00€0.67matched
66capture01a1ac2a-e116-7307-a378-a733dca19b61€9.00€0.19matched
67capture01a1ac2b-000f-7ed3-90f5-4df617ae8a0e€35.00€0.50matched
68refund01a1ac2b-0cfe-782a-9b77-a33891e2a2af-€4.00€0.00matched
69capture01a1ac2b-0e4e-7def-820b-ac344abd7677€9.00€0.19matched
70capture01a1ac2b-1b70-71cb-b3d9-314091f6ca2f€24.00€0.37matched
71capture01a1ac2b-5b05-7d80-8de2-34527fd38c6c€9.00€0.19matched
72capture01a1ac2b-5b3b-7739-8b74-f00a53af3a0e€24.00€0.37matched
73refund01a1ac2b-62a4-76f2-b06b-3bcef61733db-€30.00€0.00matched
74capture01a1ac2b-8328-7106-93c3-d67febcfe738€15.00€0.26matched
75capture01a1ac2b-8db5-7333-acd2-0e0d0a3ff0de€49.00€0.67matched
76capture01a1ac2b-a4ee-712a-a1c1-556e58b90ed5€24.00€0.37matched
77capture01a1ac2b-ab07-79ff-91cd-3ce236c156f6€9.00€0.19matched
78capture01a1ac2b-cbb8-7815-b4c4-19da2f3224e3€9.00€0.19matched
79capture01a1ac2c-1ccb-70f8-b864-c0b2f13310c2€9.00€0.19matched
80capture01a1ac2c-2a51-7dc1-aa43-f9e1518810b5€15.00€0.26matched
81capture01a1ac2c-37c9-7953-9ffa-6be6405faef8€49.00€0.67matched
82capture01a1ac2c-4ecf-7263-8f55-85d556dc5fb4€35.00€0.50matched
83capture01a1ac2c-749c-78ca-8046-3d145c14136f€35.00€0.50matched
84capture01a1ac2c-83c0-7e76-98a9-7da2c3c21ae1€24.00€0.37matched
85capture01a1ac2c-8c0b-7740-9c22-9612345e7bfd€15.00€0.26matched
86capture01a1ac2c-ad28-71c3-8c21-3fa42c4ac811€24.00€0.37matched
87capture01a1ac2c-bdac-7964-9dc8-72a133e64c51€9.00€0.19matched
88capture01a1ac2c-fe8f-7d0b-adb6-b8a16a47cecc€24.00€0.37matched
89capture01a1ac2d-1276-73cb-aaa3-4909cf64d8a3€35.00€0.50matched
90capture01a1ac2d-2b10-7861-8a13-2b9ccaec2cc9€35.00€0.50matched
91capture01a1ac2d-32f9-77a0-92f4-b55c5ab51305€15.00€0.26matched
92capture01a1ac2d-34a7-7183-9446-98d8f1fcda28€24.00€0.37matched
93capture01a1ac2d-5b52-7efb-b7d2-c373958e2454€49.00€0.67matched
94capture01a1ac2d-61e5-75f9-93da-9551a482597d€35.00€0.50matched
95capture01a1ac2d-6425-7f3b-a88e-5021159e3955€15.00€0.26matched
96capture01a1ac2d-a568-75b9-ba29-9d42209de681€9.00€0.19matched
97capture01a1ac2d-c108-790c-88ee-a9db25cf2287€49.00€0.67matched
98capture01a1ac2d-df04-7ffd-a89c-d7e48719d0af€49.00€0.67matched
99refund01a1ac2d-ebe2-774c-91ac-c3d9b065f41e-€9.00€0.00matched
100capture01a1ac2e-5c1c-77b0-8be8-982cd8ca97bc€49.00€0.67matched
101capture01a1ac2e-60e5-7602-8211-793d1db179bb€15.00€0.26matched
102capture01a1ac2e-7805-7fb3-8608-b28799a6040f€9.00€0.19matched
103refund01a1ac2e-7c64-7fb6-a410-9bbf4ea93291-€4.00€0.00matched
104capture01a1ac2e-adef-7142-b618-39dca2b025f8€49.00€0.67matched
105capture01a1ac2e-b42a-7df6-b1fd-8c69ced780cc€35.00€0.50matched
106capture01a1ac2e-cc49-7211-b1dd-a42b23505ee7€24.00€0.37matched
107capture01a1ac2e-d10a-726f-ab42-162ea83d976b€15.00€0.26matched
108refund01a1ac2e-d49f-7562-bea5-0046cbf3d862-€3.00€0.00matched
109capture01a1ac2e-d536-7c11-aae4-833aa34a9e50€15.00€0.26matched
110capture01a1ac2e-d791-708e-b9cb-c8ada041e22f€24.00€0.37matched
111capture01a1ac2e-df22-7dda-b4a6-c38a72187861€49.00€0.67matched
112capture01a1ac2e-e01f-7801-bbc9-c8d17b1e32ca€24.00€0.37matched
113capture01a1ac2e-e906-7025-aae4-005a92d0e368€35.00€0.50matched
114capture01a1ac2f-1427-76c5-b128-20f7dc6bafc6€15.00€0.26matched
115capture01a1ac2f-1a4e-7360-a95c-bf83927ff984€49.00€0.67matched
116capture01a1ac2f-2faa-75e1-83aa-01e3c5a715cc€15.00€0.26matched
117capture01a1ac2f-5158-7bea-9435-5edc90f74def€49.00€0.67matched
118capture01a1ac2f-5ecb-7d00-8f9a-5c13e7ea99e9€15.00€0.26matched
119capture01a1ac2f-9fbc-7920-bf23-e73cdbcb73b1€35.00€0.50matched
120capture01a1ac2f-a585-73d3-abde-2bde48901048€24.00€0.37matched
121capture01a1ac2f-c323-7a32-94b6-6bb1285f7b8b€9.00€0.19matched
122capture01a1ac2f-cee8-7db4-9547-de82ad408b2a€15.00€0.26matched
123capture01a1ac2f-eb25-71e3-a674-9037edb7896e€35.00€0.50matched
124capture01a1ac30-04b9-7eac-8394-eafbb744a62a€35.00€0.50matched
125capture01a1ac30-2348-7a42-ad8f-f0e2ad839fd3€24.00€0.37matched