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

Gross

€2,704.00

PSP fee

€42.32

Net to the bank

€2,661.68

Settlement journal

#401330

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1acc0-56ef-7926-8788-dc443d7b8ba6 is already settled by stl_EUR_2989832 line 85
  • duplicate linethe file lists it twicecapture:01a1acc0-eba5-76da-bae1-d38e5806d809 is already settled by stl_EUR_2989832 line 91
LineKindReferenceGrossFeeStatus
86capture01a1acc0-5714-7c03-954f-d23e3301863d€35.00€0.50duplicate line
92capture01a1acc0-ebc1-7d2f-b5b7-08cbd7b43b2e€15.00€0.26duplicate line
1capture01a1acb5-1108-7645-afa9-9b1fcbffc787€9.00€0.19matched
2capture01a1acb9-7fd3-7355-b092-7eae068d43c9€24.00€0.37matched
3capture01a1acb9-8253-77fe-a30f-790174ed00cf€49.00€0.67matched
4capture01a1acb9-8cc8-7a70-a919-6f242a8430cb€35.00€0.50matched
5capture01a1acb9-a4bc-7a2b-ad85-8c334954c00b€49.00€0.67matched
6capture01a1acb9-e74b-7800-a7df-ce2c08d7bb41€9.00€0.19matched
7capture01a1acb9-eb03-7dc1-a637-73b72e3024eb€49.00€0.67matched
8capture01a1acb9-fbfe-7fc2-9991-e5e5a0850932€15.00€0.26matched
9capture01a1acba-0ad8-7f23-ae75-41208c22d54b€24.00€0.37matched
10capture01a1acba-1772-7db6-bd0b-fce7b2b2067b€24.00€0.37matched
11capture01a1acba-17c7-76ed-b6a6-1f51aedce22f€9.00€0.19matched
12capture01a1acba-279b-7465-bc76-371c09962c92€24.00€0.37matched
13capture01a1acba-4a17-72ac-b637-02bf7bc5a0b0€9.00€0.19matched
14capture01a1acba-75bf-7d65-a51e-97b5b81d2193€35.00€0.50matched
15capture01a1acba-88c9-76bb-94ba-5c69989d9cfe€9.00€0.19matched
16capture01a1acba-ab68-789e-8d83-a95a28313654€9.00€0.19matched
17capture01a1acba-c6aa-78da-89c0-cc13f6f5ac62€24.00€0.37matched
18capture01a1acba-d877-7bb4-b0b9-0ca7378a4653€9.00€0.19matched
19capture01a1acbb-0a1a-7247-b130-f8e8d6362299€49.00€0.67matched
20capture01a1acbb-2961-78f2-a9fe-5385bcac9f68€9.00€0.19matched
21capture01a1acbb-3450-78e0-a2de-d1af6b626fad€49.00€0.67matched
22capture01a1acbb-670c-758f-844a-054d59af6f2e€49.00€0.67matched
23capture01a1acbb-8716-7592-9703-fbb967f93f2e€49.00€0.67matched
24capture01a1acbb-99a6-7047-9de9-54b1b82d2c25€35.00€0.50matched
25capture01a1acbb-9a24-7a1a-bc4a-505161e90896€35.00€0.50matched
26capture01a1acbb-a7e9-76b0-8780-05fea8fd4572€9.00€0.19matched
27capture01a1acbb-c8ab-7ed3-8b85-f3db7206a721€15.00€0.26matched
28capture01a1acbb-fbe7-75ba-af68-2271a9f9dea6€24.00€0.37matched
29refund01a1acbc-0c4e-75c0-9e49-bd7e39e7e677-€4.00€0.00matched
30capture01a1acbc-466c-74d6-9216-114c06ee0d75€24.00€0.37matched
31capture01a1acbc-6be1-7d89-8a1e-95bbfb49bdc6€9.00€0.19matched
32capture01a1acbc-765a-7f95-b35a-75abf9a42d92€49.00€0.67matched
33capture01a1acbc-92d6-7a19-8338-00598b8bc01c€24.00€0.37matched
34capture01a1acbc-9e12-7456-837c-b129a375ecf4€35.00€0.50matched
35capture01a1acbc-bb7d-7430-92a3-b5a2f184f531€24.00€0.37matched
36capture01a1acbc-c6b6-7373-8f18-5743a1b31199€49.00€0.67matched
37capture01a1acbc-dba8-76bb-be46-c42ab388fc90€24.00€0.37matched
38capture01a1acbc-e775-7754-8713-1a248b2be310€35.00€0.50matched
39capture01a1acbc-e986-7bf9-a751-ede6e6e0d324€24.00€0.37matched
40capture01a1acbc-f553-7f8b-8aef-7b750641ff0e€35.00€0.50matched
41capture01a1acbc-f66e-7010-b1b4-23d51158b9da€24.00€0.37matched
42capture01a1acbd-0e8a-7e6d-b3ce-ac16b5910600€35.00€0.50matched
43capture01a1acbd-3927-79c8-9e71-551d048868e1€35.00€0.50matched
44capture01a1acbd-551c-7f09-bdb8-8ac9c96fb036€15.00€0.26matched
45capture01a1acbd-5a1d-736d-8423-0590fabf8bb0€15.00€0.26matched
46capture01a1acbd-6511-7f4f-9911-9e971060a8c0€49.00€0.67matched
47capture01a1acbd-6ac1-7055-990e-8d4db9010d9c€15.00€0.26matched
48capture01a1acbd-6050-7ede-bb45-2af4ba8ef0c5€35.00€0.50matched
49capture01a1acbd-774b-78cc-a298-983951b2ad8b€35.00€0.50matched
50capture01a1acbd-86a3-740a-b143-20f766477a27€24.00€0.37matched
51capture01a1acbd-8a9e-7df7-a960-f61ffd17fa2d€24.00€0.37matched
52capture01a1acbd-8e7b-7e3f-8a14-cdeca1e551a8€9.00€0.19matched
53capture01a1acbd-9fd5-7fd7-af71-ca7ccddb5dd0€24.00€0.37matched
54capture01a1acbd-a946-7774-933b-097f46650a42€49.00€0.67matched
55refund01a1acbd-ba6d-7b8a-b06c-ce2dad502f59-€3.00€0.00matched
56capture01a1acbd-bed0-7c24-aa5a-f3f185d8fdfc€24.00€0.37matched
57capture01a1acbd-d565-7be6-b10c-7b92743b164d€15.00€0.26matched
58refund01a1acbd-ebf1-7a2a-839e-172c3924ff44-€32.00€0.00matched
59capture01a1acbd-ee05-73f5-a106-13ac07804d2a€15.00€0.26matched
60capture01a1acbe-44d4-7a4d-b647-dee4b2e268f3€9.00€0.19matched
61capture01a1acbe-549d-7fe4-a3f1-55ac80147960€9.00€0.19matched
62capture01a1acbe-781a-7969-ab61-1838a876b5c3€35.00€0.50matched
63capture01a1acbe-a456-773a-8323-7801e9953876€24.00€0.37matched
64capture01a1acbe-ba88-734d-8063-bfc3e1409cf5€15.00€0.26matched
65capture01a1acbe-bde1-73cf-ad34-4d3664e06e35€9.00€0.19matched
66capture01a1acbe-c016-77aa-a640-d7dd60e2461c€49.00€0.67matched
67capture01a1acbe-e1a2-7f56-be98-fed0fc64398e€15.00€0.26matched
68capture01a1acbf-171c-7f20-ac89-09fe59440912€24.00€0.37matched
69capture01a1acbf-1943-7847-b287-fb6a7792bffc€15.00€0.26matched
70capture01a1acbf-34a1-7138-b956-3e6d35082dc1€24.00€0.37matched
71capture01a1acbf-409e-77e4-8417-b72b474b578c€35.00€0.50matched
72capture01a1acbf-410c-79ff-b021-1e2f6a012d72€9.00€0.19matched
73capture01a1acbf-4b34-76b6-8bef-a498e93de4b8€49.00€0.67matched
74capture01a1acbf-85a8-7c30-8aae-bbcef41037fd€15.00€0.26matched
75capture01a1acbf-916a-7bed-b9cc-b7bcdca39521€9.00€0.19matched
76capture01a1acbf-a25b-7046-b11c-4417c22d645b€35.00€0.50matched
77capture01a1acbf-b8aa-7958-9556-cb00a731b232€35.00€0.50matched
78refund01a1acbf-d621-79f3-bd2b-fccde97ab430-€28.00€0.00matched
79capture01a1acbf-e473-7ef5-9cb2-9cf66f093cf5€15.00€0.26matched
80capture01a1acbf-ed59-7e01-ac54-6b1fdc7152d9€24.00€0.37matched
81capture01a1acbf-f888-722e-b7f7-70ee4601e469€49.00€0.67matched
82capture01a1acc0-1dc1-74dc-9a87-890385e123fc€15.00€0.26matched
83capture01a1acc0-1f4f-7d9a-a88b-8d0e29783fd6€24.00€0.37matched
84capture01a1acc0-301a-741c-97d5-13b17111880c€24.00€0.37matched
85capture01a1acc0-5714-7c03-954f-d23e3301863d€35.00€0.50matched
87capture01a1acc0-82d3-7077-9bc5-fa1eb50cde39€15.00€0.26matched
88capture01a1acc0-a3b1-7ce6-ae2c-38ed3b9c7ce8€15.00€0.26matched
89capture01a1acc0-a7b5-7f3c-ab2a-7a56f2cf46ad€49.00€0.67matched
90capture01a1acc0-be3b-7060-8ba1-cc5bed84e9c5€15.00€0.26matched
91capture01a1acc0-ebc1-7d2f-b5b7-08cbd7b43b2e€15.00€0.26matched
93capture01a1acc0-fd9b-705e-bd9f-5cc872f0bd6e€15.00€0.26matched
94capture01a1acc1-2319-73f7-9583-3944c547244e€49.00€0.67matched
95capture01a1acc1-2de3-751b-8667-9e6a1acddae8€24.00€0.37matched
96capture01a1acc1-3838-7fde-8951-f93ffed8faed€9.00€0.19matched
97capture01a1acc1-51e5-7dc3-b317-086e2aac1c1f€24.00€0.37matched
98capture01a1acc1-5497-7b19-8ad0-de33fd589d10€24.00€0.37matched
99capture01a1acc1-78c3-78b6-8b8f-6fc174c15e5a€9.00€0.19matched
100capture01a1acc1-880b-7e5b-a704-3bf9c012b2d3€24.00€0.37matched
101capture01a1acc1-97eb-7cc9-819e-77251d4285d5€49.00€0.67matched
102capture01a1acc1-e0a9-734d-ba03-b61c3ddf2881€35.00€0.50matched
103capture01a1acc1-f100-758c-8a49-b981f4f1d1ff€35.00€0.50matched
104capture01a1acc2-031b-7fd0-8013-60cdb183b78a€24.00€0.37matched
105capture01a1acc2-0e4d-7e33-b580-57f87a3418d5€15.00€0.26matched
106capture01a1acc2-3b18-7a74-8165-e039a3afe23f€35.00€0.50matched
107capture01a1acc2-4487-752b-b26a-07fb7e597c35€15.00€0.26matched
108refund01a1acc2-55d8-72ac-8a49-64542be5e4f2-€14.00€0.00matched
109capture01a1acc2-5fa6-75ce-8ab1-de1dd128a690€15.00€0.26matched
110capture01a1acc2-629e-7979-8470-0e1da2fa39f6€35.00€0.50matched
111capture01a1acc2-701f-783d-b384-9864ec78e60c€15.00€0.26matched
112capture01a1acc2-7caa-79b5-831b-801b4498585a€24.00€0.37matched
113capture01a1acc2-98e3-7ede-837f-fab904c04397€49.00€0.67matched
114refund01a1acc2-a48d-759c-9e68-2fd504fb5c4b-€11.00€0.00matched