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, 00:50

Gross

€2,870.00

PSP fee

€46.70

Net to the bank

€2,823.30

Settlement journal

#388807

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a931-e684-770c-b195-c17087f7cd64 is already settled by stl_EUR_2989733 line 39
  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 27, the contract says 26
LineKindReferenceGrossFeeStatus
30capture01a1a931-6100-770e-8aa0-749617d22aa5€15.00€0.28fee difference
40capture01a1a931-e847-7c7d-9e93-231bd0495f50€9.00€0.19duplicate line
57capture01a1a933-19af-786d-acfa-e8e4d0b2565e€49.00€0.72fee difference
90capture01a1a935-61bc-7e16-926a-bbd5ed0feddd€9.00€0.22fee difference
128capture01a1a937-ff4f-76fb-ace5-ba9672de1759€15.00€0.27fee difference
1capture01a1a92b-1565-7dc4-a980-7b0a43c27126€9.00€0.19matched
2capture01a1a92f-2b86-71a9-b163-6cb612c67c1e€24.00€0.37matched
3capture01a1a92f-2f02-73b1-8fd1-aaf610386689€15.00€0.26matched
4capture01a1a92f-485e-7194-b08c-2cbfbeb63315€49.00€0.67matched
5capture01a1a92f-49dc-7f5f-a517-a605d5cbd570€24.00€0.37matched
6refund01a1a92f-7644-7097-84a0-af9d0018eaba-€14.00€0.00matched
7capture01a1a92f-7ad1-78c5-abd2-3f8fc50e8838€35.00€0.50matched
8capture01a1a92f-8dad-78b3-95fb-b62ac215dabf€49.00€0.67matched
9capture01a1a92f-83d8-7ec5-a48f-a6eb0647f435€49.00€0.67matched
10capture01a1a92f-b125-750e-8134-e73cae143277€49.00€0.67matched
11capture01a1a92f-b70e-765a-ab82-20f25bc6c6be€35.00€0.50matched
12capture01a1a92f-f32c-7efc-8839-b63ca42959ac€15.00€0.26matched
13refund01a1a930-040f-7c24-84a9-6b6a0a20c400-€28.00€0.00matched
14capture01a1a92f-f931-78a6-921a-4e703e0469d1€9.00€0.19matched
15capture01a1a930-17c5-7896-8996-8ba3e769b7ad€9.00€0.19matched
16capture01a1a930-45c7-7cb3-9a6a-601533c1e61d€35.00€0.50matched
17capture01a1a930-5ef3-7786-aecb-9d13e656449b€15.00€0.26matched
18capture01a1a930-7ad7-7613-b239-820c9fc65704€49.00€0.67matched
19capture01a1a930-8c53-7bcc-81d1-b5e8e7d67984€9.00€0.19matched
20capture01a1a930-8e6a-7cbf-b47d-a8b51584e2c4€35.00€0.50matched
21capture01a1a930-8e6c-7df9-8e33-138ebc4e0f36€35.00€0.50matched
22capture01a1a930-ae1f-74ad-92cf-f0ffff046fef€49.00€0.67matched
23capture01a1a930-c35d-73a5-8c89-47bbadc4d515€24.00€0.37matched
24capture01a1a930-c67c-7b29-a1f1-d71386e7433b€9.00€0.19matched
25capture01a1a930-d2bc-7213-b97f-4eeb8b61785c€49.00€0.67matched
26capture01a1a930-da05-704a-9d4a-3c00e11b85a9€35.00€0.50matched
27refund01a1a930-e8c4-7f24-b2ba-f4bc94291d9e-€34.00€0.00matched
28capture01a1a931-0a43-7a86-8b53-c129748cbdb8€15.00€0.26matched
29capture01a1a931-44e6-76b8-bba7-4e83e5abe604€15.00€0.26matched
31capture01a1a931-8803-715f-8c9b-b6c0e612de46€49.00€0.67matched
32capture01a1a931-8dc8-7e0f-a872-2a9e74a25b9f€49.00€0.67matched
33capture01a1a931-9291-72da-a67d-bce47e636664€15.00€0.26matched
34capture01a1a931-9989-754d-99f1-89c84f8a3491€49.00€0.67matched
35capture01a1a931-b870-7c0a-a8bf-af0c478a61c5€15.00€0.26matched
36capture01a1a931-c597-73df-80d6-6bfcd05cf6ed€24.00€0.37matched
37refund01a1a931-d7b0-7750-b727-9cd72de9a9b8-€35.00€0.00matched
38capture01a1a931-dd74-7fc0-9488-403e9628f931€15.00€0.26matched
39capture01a1a931-e847-7c7d-9e93-231bd0495f50€9.00€0.19matched
41capture01a1a931-eb44-78e1-887a-7645a7ac32ed€49.00€0.67matched
42capture01a1a932-03f1-7fb9-8d9c-d0c32b528d52€24.00€0.37matched
43capture01a1a932-2504-79e3-a4d8-619ecd989002€15.00€0.26matched
44capture01a1a932-248b-7ba4-9ae5-4473a044c473€15.00€0.26matched
45capture01a1a932-419d-719e-a3ab-88aab3f73d7e€35.00€0.50matched
46capture01a1a932-56f3-7c06-a314-f0d033ee31cb€35.00€0.50matched
47capture01a1a932-578d-7ab8-aa66-529e8f3a66b1€35.00€0.50matched
48capture01a1a932-6c8d-7f53-bbaf-de40796a3b84€35.00€0.50matched
49capture01a1a932-77af-7f7f-9a90-cff183f5a5a2€49.00€0.67matched
50capture01a1a932-8093-7163-bd5b-350414263609€35.00€0.50matched
51capture01a1a932-c3a2-74a4-930b-dc76889b3829€35.00€0.50matched
52capture01a1a932-d812-7eed-9a31-3ba0a0812993€24.00€0.37matched
53capture01a1a932-dc17-7cdf-8cdb-3d734e096656€24.00€0.37matched
54capture01a1a932-dfed-7cd0-9811-30c273cd03b5€35.00€0.50matched
55refund01a1a932-fad7-74b8-adb5-02ecad156772-€14.00€0.00matched
56capture01a1a933-0450-7ce4-9485-280a241583bd€24.00€0.37matched
58capture01a1a933-4458-7db9-a207-c16d74284c60€15.00€0.26matched
59capture01a1a933-529c-71fd-b791-c95e4ff12254€9.00€0.19matched
60capture01a1a933-55a3-7d2c-961d-a9ac16f11677€24.00€0.37matched
61capture01a1a933-5837-7900-9f6d-28d0a9423b07€24.00€0.37matched
62capture01a1a933-5b06-7732-9f46-a847d1fc4c64€24.00€0.37matched
63capture01a1a933-869c-7628-9339-f33ab7f8ceec€49.00€0.67matched
64capture01a1a933-96b3-7fbe-9228-9cdd0b57d555€35.00€0.50matched
65capture01a1a933-af0b-719f-af27-cdcb4a08b174€15.00€0.26matched
66capture01a1a933-af49-73b5-998f-8ceee3effa60€9.00€0.19matched
67refund01a1a933-b20d-703c-8d89-eb83bb6c4c2f-€21.00€0.00matched
68capture01a1a933-ca98-73ea-bc57-d819dfdfdae0€9.00€0.19matched
69capture01a1a933-d075-7faf-ac25-823621948c61€24.00€0.37matched
70refund01a1a933-d5d1-7474-a7fb-eacbf68f81f4-€27.00€0.00matched
71capture01a1a933-decc-72c7-b496-007727ab8800€35.00€0.50matched
72capture01a1a933-e863-7c06-8790-6edcce93b880€15.00€0.26matched
73capture01a1a933-f7c9-7530-b33a-03ee15c26d1f€15.00€0.26matched
74capture01a1a934-03ca-7df1-aee3-f1cfb6d16228€9.00€0.19matched
75capture01a1a934-10ec-7c5f-b665-89bc06c48722€24.00€0.37matched
76capture01a1a934-199f-7dba-acae-cface6d754e2€35.00€0.50matched
77capture01a1a934-5a33-79ae-81bf-8045fa357cbb€49.00€0.67matched
78capture01a1a934-6365-7920-be28-06db9464b1d9€24.00€0.37matched
79capture01a1a934-6731-78d4-84e5-53693a00ab70€15.00€0.26matched
80capture01a1a934-b1d3-7c5e-a2af-f69e99df31c4€35.00€0.50matched
81capture01a1a934-b512-7d8d-996b-19c0e14e5f7f€35.00€0.50matched
82capture01a1a934-e73b-7e0e-89de-085e956a8533€49.00€0.67matched
83capture01a1a934-ed22-74ae-b620-7b39357fb1b7€9.00€0.19matched
84capture01a1a934-f495-7ba2-a8ab-953973086f2a€24.00€0.37matched
85capture01a1a934-fb89-796f-99b9-6772e1d06e4d€9.00€0.19matched
86capture01a1a934-ff43-773c-8275-cf21c6e4cd8f€15.00€0.26matched
87capture01a1a935-08e0-74c2-93e8-df3d9111c187€9.00€0.19matched
88capture01a1a935-4451-7100-8840-65345c3e53e3€24.00€0.37matched
89capture01a1a935-5ff7-790e-8035-77d34b98e6e4€9.00€0.19matched
91capture01a1a935-6813-7737-9cda-9dc2a300e0aa€9.00€0.19matched
92capture01a1a935-70c8-78db-ab28-1f342bc6516a€24.00€0.37matched
93capture01a1a935-839a-7076-9143-7d5e55a2bd62€49.00€0.67matched
94capture01a1a935-aa99-70a6-8128-1f4580f9c53b€49.00€0.67matched
95capture01a1a935-aef6-7173-85fd-f79e257c232e€9.00€0.19matched
96capture01a1a935-b7b9-76ce-8673-1fd2e3512115€35.00€0.50matched
97capture01a1a935-d5ec-75ca-9097-4e7c61bc8d75€15.00€0.26matched
98capture01a1a935-dbd1-7a70-8b0a-7f03d6f1b14c€9.00€0.19matched
99capture01a1a935-f812-70f9-a9f3-2af3b20b6051€24.00€0.37matched
100capture01a1a936-0c27-7979-8296-6a36ff01593e€24.00€0.37matched
101refund01a1a936-23ff-757f-ade4-2adc51cbbcaf-€4.00€0.00matched
102capture01a1a936-2826-72ef-8fde-5d3d5429aea6€15.00€0.26matched
103capture01a1a936-834c-733f-b9c1-22a7a99fe11c€49.00€0.67matched
104capture01a1a936-8ada-7a7a-ba0f-ad2303673292€35.00€0.50matched
105capture01a1a936-911e-74e8-bf42-85fcd31554a1€35.00€0.50matched
106capture01a1a936-95c2-783a-a419-1abb74e6656d€24.00€0.37matched
107capture01a1a936-c387-78a2-8bff-7b7e84ef29cc€15.00€0.26matched
108capture01a1a936-cea6-76fd-8959-8a0ca78f0261€15.00€0.26matched
109capture01a1a936-dea0-78f6-b55b-e632f5b02ecf€9.00€0.19matched
110capture01a1a936-e4c7-7b3a-8f06-fb1b3369d613€9.00€0.19matched
111capture01a1a937-0d97-7eeb-bd93-2e4737627fe3€24.00€0.37matched
112capture01a1a937-1004-7836-a60d-633aebf59548€9.00€0.19matched
113capture01a1a937-3afc-7960-b8b1-20d0d7fa3a6c€15.00€0.26matched
114capture01a1a937-421c-7a47-aae8-78a4ff8195be€9.00€0.19matched
115capture01a1a937-4fc5-7de8-8597-c71108d7a30d€35.00€0.50matched
116capture01a1a937-6a4f-73b1-9727-d3ce2685dbba€35.00€0.50matched
117capture01a1a937-6c4a-75cc-b9a5-109226c81da1€24.00€0.37matched
118capture01a1a937-784c-78d8-acef-a81b93e9bdf8€49.00€0.67matched
119capture01a1a937-8644-71e1-a8f1-f4416c2e26b1€15.00€0.26matched
120capture01a1a937-8cff-7fd5-a58c-a3b79a52b6e2€9.00€0.19matched
121capture01a1a937-953e-77c7-9308-07b9aa60af0d€24.00€0.37matched
122capture01a1a937-a2c6-7354-ad87-58e81ec87a49€15.00€0.26matched
123capture01a1a937-b2ee-7991-a628-97fbbe568098€24.00€0.37matched
124capture01a1a937-bd84-75ac-a022-6a33d0cb2f92€24.00€0.37matched
125capture01a1a937-cca7-7b7b-8e96-70f3c8d55596€9.00€0.19matched
126capture01a1a937-ccfe-76e9-9b6a-6916f8ca8cca€9.00€0.19matched
127refund01a1a937-eb23-7a08-83e6-5632ce845ab9-€10.00€0.00matched
129capture01a1a938-045d-719d-9e26-bc5949483490€15.00€0.26matched
130capture01a1a938-2cb9-7b75-a54f-b8cb4ae8a366€24.00€0.37matched
131capture01a1a938-2d22-7142-a9c6-e02a6f2e898f€24.00€0.37matched