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

2 Nov, 03:10

Gross

€2,587.00

PSP fee

€40.61

Net to the bank

€2,546.39

Settlement journal

#335738

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19a42-a236-7192-86e8-b9be1a3fefa5 is already settled by stl_EUR_2989315 line 76
  • missing linein the books, not in the filecapture:01a19a41-7bbb-7cf3-a4ac-519215f1332d is in no file
LineKindReferenceGrossFeeStatus
77capture01a19a42-a2a6-7d8e-bb27-629107f26d9a€9.00€0.19duplicate line
1capture01a19a35-a825-7438-a79e-fa7d655d23eb€15.00€0.26matched
2capture01a19a3c-3ce7-7597-9c6a-ea68e7035ff4€9.00€0.19matched
3capture01a19a3c-4d02-739c-b016-d73475c350bf€35.00€0.50matched
4capture01a19a3c-63de-7fd9-8c3e-f49aecbca91d€35.00€0.50matched
5capture01a19a3c-7287-729f-95b5-d9944a0290c0€49.00€0.67matched
6capture01a19a3c-87d6-780c-b932-dd94eb7984d1€15.00€0.26matched
7capture01a19a3c-9bc3-736a-b327-aaf8063c1353€49.00€0.67matched
8capture01a19a3c-c311-70fc-9257-21261b2ad91c€24.00€0.37matched
9capture01a19a3c-c980-7f17-8259-2812c7b5408c€49.00€0.67matched
10capture01a19a3d-0d55-7092-bad1-258ac0d31127€15.00€0.26matched
11capture01a19a3d-676b-7052-abeb-40527e93e746€49.00€0.67matched
12capture01a19a3d-6f0d-7410-9bf1-4c98b2b15d9c€49.00€0.67matched
13capture01a19a3d-813e-74da-b4af-628d268030d0€24.00€0.37matched
14capture01a19a3d-893f-7e5f-90bd-83a9d74d7b39€15.00€0.26matched
15capture01a19a3d-9c55-7421-acac-58d13aa21b22€9.00€0.19matched
16capture01a19a3d-af44-7e7f-bdac-ca79ceeae3ed€35.00€0.50matched
17capture01a19a3d-c07a-7658-9e18-61b08779f1a2€15.00€0.26matched
18capture01a19a3d-cf4d-7694-8449-4e5c37db8a8e€24.00€0.37matched
19refund01a19a3d-d4d3-76b3-ab3a-7cac3631b409-€44.00€0.00matched
20capture01a19a3d-da86-7d2a-9fb6-9d5941e4e94a€35.00€0.50matched
21capture01a19a3e-14f2-7d5f-8d5a-d9959f3a7ec3€49.00€0.67matched
22capture01a19a3e-2d07-7337-ae60-e4f5b9e5a30e€35.00€0.50matched
23capture01a19a3e-31a8-7b78-8487-38a5744b6ce9€49.00€0.67matched
24capture01a19a3e-4a26-7c6a-b49f-125b163ed87a€35.00€0.50matched
25capture01a19a3e-645e-7326-9f6c-1748d7dad8c0€35.00€0.50matched
26capture01a19a3e-6a30-788f-a345-a7c5d555c2a2€35.00€0.50matched
27capture01a19a3e-706b-7ab0-bb91-2894bdf239c4€35.00€0.50matched
28capture01a19a3e-7221-7e87-9653-acab4e5bda30€15.00€0.26matched
29refund01a19a3e-84bd-7a3f-87b2-905e7950561f-€23.00€0.00matched
30capture01a19a3e-91c1-7ab3-82c5-c62e9254d817€9.00€0.19matched
31capture01a19a3e-9a2d-7457-9c09-e3139af58e66€9.00€0.19matched
32capture01a19a3e-8d56-752d-a83f-113957dcc3f9€9.00€0.19matched
33capture01a19a3e-ac36-7d84-916b-d37031a5fe53€24.00€0.37matched
34capture01a19a3e-b37a-70a8-9740-05ec96bc20fa€49.00€0.67matched
35capture01a19a3e-d483-73a5-b20f-f468cad4ee95€24.00€0.37matched
36capture01a19a3e-e0d5-7716-9bc4-a739792e81e8€9.00€0.19matched
37capture01a19a3e-ed66-712e-8fbb-c5200781e943€24.00€0.37matched
38capture01a19a3f-3e5c-7e89-b908-132245cefc47€24.00€0.37matched
39capture01a19a3f-4d04-7365-be71-679fb10ae4f8€9.00€0.19matched
40capture01a19a3f-5884-711d-8a9c-925e4e6ef493€49.00€0.67matched
41capture01a19a3f-5b59-7e6f-979c-122527c96181€24.00€0.37matched
42capture01a19a3f-5d42-7316-b073-5228661f2d52€24.00€0.37matched
43capture01a19a3f-77b5-7a20-9649-dd83c1827ac9€15.00€0.26matched
44capture01a19a3f-786f-7e47-b113-03748c5dbe56€15.00€0.26matched
45capture01a19a3f-8bbd-7a04-8849-6315fa2b80a1€24.00€0.37matched
46capture01a19a3f-b3d1-772b-bc3a-3b4c527b6f6f€24.00€0.37matched
47capture01a19a3f-b48d-7792-b42f-a3b00db811da€9.00€0.19matched
48capture01a19a3f-baf0-7c3d-beec-330c2aab0b09€15.00€0.26matched
49capture01a19a3f-c43f-705d-ada8-e848344f8b37€15.00€0.26matched
50capture01a19a3f-d529-70be-8c40-af734a0206f4€15.00€0.26matched
51capture01a19a3f-e9b0-708d-af9b-d1166dd8414d€49.00€0.67matched
52capture01a19a3f-f779-7081-b020-a6003678c698€15.00€0.26matched
53capture01a19a40-0d72-7710-a5f4-329950b69453€49.00€0.67matched
54refund01a19a40-2304-72e7-9691-8ca0152be881-€9.00€0.00matched
55capture01a19a40-239c-7840-bbb9-66c0bacb7a30€15.00€0.26matched
56capture01a19a40-3cff-7d27-b924-bb8fbad4e97a€49.00€0.67matched
57capture01a19a40-4078-7807-9400-c0d4721fe643€15.00€0.26matched
58capture01a19a40-4258-7c9c-827c-9a6070a7b2ba€9.00€0.19matched
59capture01a19a40-61b5-7286-b719-2d4b09c468ca€24.00€0.37matched
60capture01a19a40-6c52-783f-821c-a4e6cb0430ae€49.00€0.67matched
61capture01a19a40-845e-7f7f-b514-00df057d9d8d€15.00€0.26matched
62capture01a19a40-947e-7c76-b4a4-b74969df4ba4€35.00€0.50matched
63capture01a19a40-b90f-76e6-a25c-a2a0894bcf77€35.00€0.50matched
64capture01a19a40-c18a-7ed5-8908-fdf254a26b87€35.00€0.50matched
65capture01a19a40-d69f-7395-8d2d-2656752490e4€9.00€0.19matched
66capture01a19a40-fdef-7075-a0bd-1e22c14dae77€15.00€0.26matched
67capture01a19a41-301f-7d12-899a-e00c0db941de€49.00€0.67matched
68capture01a19a41-302f-7c77-8ff1-5f8762ce282c€49.00€0.67matched
69capture01a19a41-494c-7bde-9c25-2e7ee250a051€15.00€0.26matched
70capture01a19a41-4b3b-7949-b2de-2564c1e266af€24.00€0.37matched
71capture01a19a41-67be-7266-9bb7-41478e7447f1€35.00€0.50matched
72capture01a19a41-d239-793d-8785-53b74fcf1730€9.00€0.19matched
73capture01a19a41-e5f1-75f3-8551-797af41d6130€9.00€0.19matched
74capture01a19a42-6495-7f1b-ae74-57d0a88bb9bc€15.00€0.26matched
75capture01a19a42-67dd-7cc7-9f64-20f43def8603€9.00€0.19matched
76capture01a19a42-a2a6-7d8e-bb27-629107f26d9a€9.00€0.19matched
78capture01a19a42-e919-7ef9-8fad-1d4ac919b68f€15.00€0.26matched
79capture01a19a42-f40f-7fc4-9f07-4203b8e9dc96€24.00€0.37matched
80capture01a19a43-2ae4-733b-8aa7-637b03564857€24.00€0.37matched
81capture01a19a43-2b7a-7932-b4c8-141b2d0e57e2€35.00€0.50matched
82capture01a19a43-6ab7-7a04-a57c-31fd0bc37083€24.00€0.37matched
83capture01a19a43-7229-711a-865e-8c8e0bb7c7b8€9.00€0.19matched
84capture01a19a43-75b2-791c-b8ea-35d1048a4ac8€15.00€0.26matched
85capture01a19a43-87d1-7a00-884b-1554a26e7b33€49.00€0.67matched
86capture01a19a43-8b37-7691-bded-747a7bbb3eeb€24.00€0.37matched
87capture01a19a43-8c1f-7c9c-b820-e712c57aa3e4€9.00€0.19matched
88capture01a19a43-8ce4-75c2-a6ac-ea58eaacac66€9.00€0.19matched
89capture01a19a43-a11c-779a-bc1e-68b73c56cab1€35.00€0.50matched
90capture01a19a43-9ee7-7d1c-80e6-db5a514ace97€24.00€0.37matched
91capture01a19a43-abef-7010-8fcb-5116c2cd8f4d€24.00€0.37matched
92capture01a19a43-b4ed-727e-851a-845388cb89bd€24.00€0.37matched
93capture01a19a43-b9e7-7776-ad26-b448b906b4ac€24.00€0.37matched
94capture01a19a43-d35d-737e-951a-d7183ca6e760€15.00€0.26matched
95capture01a19a43-d374-7198-adfe-1e0ec27d48b1€49.00€0.67matched
96capture01a19a43-d8e0-7a42-b7e6-a7f2b4ad76ff€15.00€0.26matched
97capture01a19a44-09d4-7e21-b891-fb3373385189€24.00€0.37matched
98capture01a19a44-2924-786e-a91b-e0248e3c796b€24.00€0.37matched
99capture01a19a44-2b89-7739-9e38-a3f80be5cb63€49.00€0.67matched
100refund01a19a44-3153-7d07-9234-8db336f1a544-€4.00€0.00matched
101capture01a19a44-6859-76b7-a4b5-70235d93687b€24.00€0.37matched
102capture01a19a44-82c8-7ffd-9801-f610bd5aa5e1€15.00€0.26matched
103capture01a19a44-971d-7dc7-afc4-fe0d45c30426€9.00€0.19matched
104capture01a19a44-9e6c-7f51-b1ae-c081bcb80415€15.00€0.26matched
105capture01a19a44-c1dd-7d3d-aae9-3aadf47acbe9€9.00€0.19matched
106capture01a19a44-cfca-7f89-a041-b4a1f2a13d93€35.00€0.50matched
107capture01a19a44-e117-7239-b763-18be2934826b€24.00€0.37matched
108capture01a19a44-ef98-72f4-82a0-24d475447a3d€35.00€0.50matched
109capture01a19a45-03aa-71f9-8024-f7632b6ad95d€35.00€0.50matched
110capture01a19a45-4d63-730e-bf66-39ba52c64351€15.00€0.26matched