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

3 Nov, 13:50

Gross

€2,795.00

PSP fee

€43.08

Net to the bank

€2,751.92

Settlement journal

#362110

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a1ae-0059-7697-a550-0bd9cdc8954f is already settled by stl_EUR_2989523 line 23
  • duplicate linethe file lists it twicecapture:01a1a1b2-8052-7d78-ab00-75fdef5db154 is already settled by stl_EUR_2989523 line 73
  • missing linein the books, not in the filecapture:01a1a1af-f206-72f6-a38b-d6775735b0c0 is in no file
  • missing linein the books, not in the filecapture:01a1a1b0-f8a3-75c1-aca9-afdff3263b3d is in no file
LineKindReferenceGrossFeeStatus
24capture01a1a1ae-008c-766d-a802-978534ce83ca€24.00€0.37duplicate line
74capture01a1a1b2-80a0-7493-839c-1258833a17da€35.00€0.50duplicate line
1capture01a1a1a6-c658-7de6-af90-1a627aa75886€15.00€0.26matched
2capture01a1a1ac-c7de-7fc8-80ce-df5e6015b8f4€24.00€0.37matched
3capture01a1a1ac-d45c-797f-8d70-9a4780bf6d77€15.00€0.26matched
4capture01a1a1ac-eb7f-79fb-9a0a-dbc1911fd05c€35.00€0.50matched
5capture01a1a1ad-0af2-7db6-98a9-144a9c796eac€15.00€0.26matched
6capture01a1a1ad-221d-70e4-93ce-b2f82caa6598€49.00€0.67matched
7capture01a1a1ad-2509-7d71-82ff-60214a5be8b3€9.00€0.19matched
8capture01a1a1ad-2557-7f2f-b0cd-cdd7bc03dd3c€35.00€0.50matched
9capture01a1a1ad-3131-744b-9139-3432908a238b€15.00€0.26matched
10capture01a1a1ad-40d9-7444-a9ca-10cb743bbbf6€49.00€0.67matched
11capture01a1a1ad-4118-79e7-83d0-98ee845a77a6€49.00€0.67matched
12capture01a1a1ad-4c92-7c9c-ba25-8433dc292206€9.00€0.19matched
13capture01a1a1ad-6224-76a7-a0cd-73d93a525fe4€49.00€0.67matched
14capture01a1a1ad-643e-733a-bf33-1d33a8e2abb6€49.00€0.67matched
15capture01a1a1ad-9450-7847-9c2d-e91162fbd6b7€35.00€0.50matched
16capture01a1a1ad-a401-7686-a4bf-5fc4a07f3191€35.00€0.50matched
17capture01a1a1ad-a59c-72ba-a8bf-271cacd8eb9c€9.00€0.19matched
18capture01a1a1ad-af58-7193-94c0-ef4db2ddfdd6€49.00€0.67matched
19capture01a1a1ad-af8d-7793-9d05-1f05547bcf2e€15.00€0.26matched
20capture01a1a1ad-c716-71bf-bf73-3e769ace120f€9.00€0.19matched
21capture01a1a1ad-d19d-741a-8ff8-30ecdf609d20€49.00€0.67matched
22capture01a1a1ad-eef1-7f35-9733-be1f5d40fba8€15.00€0.26matched
23capture01a1a1ae-008c-766d-a802-978534ce83ca€24.00€0.37matched
25capture01a1a1ae-03b6-72dd-8574-f239a6ff5983€35.00€0.50matched
26capture01a1a1ae-0853-701a-b4f4-2a566c51dab9€49.00€0.67matched
27capture01a1a1ae-263a-7dd7-a26e-db6a69c75619€35.00€0.50matched
28capture01a1a1ae-29c0-70de-94a5-e157c230607d€35.00€0.50matched
29capture01a1a1ae-2a5b-7b60-8922-f028575a70a1€15.00€0.26matched
30capture01a1a1ae-40d3-7ec6-8208-2e79a4cd5ec3€15.00€0.26matched
31capture01a1a1ae-4b0b-72b0-b55f-48d73f5497a9€35.00€0.50matched
32capture01a1a1ae-6ec2-73ef-985e-b1227805a29b€15.00€0.26matched
33capture01a1a1ae-97b4-7324-a272-e0c2889b131b€9.00€0.19matched
34capture01a1a1ae-a9a2-7eee-9b5c-2baad43eb3c2€24.00€0.37matched
35capture01a1a1ae-ad02-79f3-ac0a-3c246944aa76€24.00€0.37matched
36capture01a1a1ae-b231-76e7-8d46-f57d155573b4€9.00€0.19matched
37capture01a1a1ae-ee48-734c-a6b0-fcd475f07aef€9.00€0.19matched
38capture01a1a1af-1728-75e8-9e70-eacf0618612a€35.00€0.50matched
39capture01a1a1af-41d1-77e6-98a2-38e800fec274€15.00€0.26matched
40capture01a1a1af-5ff3-7d5f-97c9-1bf642efcc60€35.00€0.50matched
41capture01a1a1af-a243-7c53-b6d3-eb68e435dcbc€9.00€0.19matched
42refund01a1a1af-ce68-789a-b38b-9b8f9814fa5c-€7.00€0.00matched
43capture01a1a1af-dc0a-7c3b-aec6-16ebf8a7740b€35.00€0.50matched
44capture01a1a1af-f38e-7f3b-b5de-2b843b9f6162€35.00€0.50matched
45capture01a1a1b0-008b-7264-b897-72ca95b0eb3d€9.00€0.19matched
46capture01a1a1b0-023b-7a82-81fa-dded75d2e695€15.00€0.26matched
47capture01a1a1b0-0575-7e4d-b14f-b807f3936bf8€49.00€0.67matched
48capture01a1a1b0-0626-7457-8c25-6d095ffb6b52€35.00€0.50matched
49capture01a1a1b0-201c-7008-862c-974f56e3a6e3€9.00€0.19matched
50capture01a1a1b0-2298-7a7c-be42-d950a27ad16a€15.00€0.26matched
51capture01a1a1b0-256c-7a9b-b2dc-c09d17a33187€15.00€0.26matched
52refund01a1a1b0-36ca-7c16-81ce-71349e103b0a-€15.00€0.00matched
53capture01a1a1b0-5d18-71f9-8848-657f6af2998e€9.00€0.19matched
54capture01a1a1b0-92cb-7f46-8810-a5ba062ac6a5€35.00€0.50matched
55capture01a1a1b0-a118-7cf8-a561-7209e8809e0d€49.00€0.67matched
56capture01a1a1b0-d2de-7587-b232-b84da54d0ac9€24.00€0.37matched
57capture01a1a1b0-e41e-7321-9ef0-886bb2ab3122€9.00€0.19matched
58capture01a1a1b1-1017-795f-b152-0e5230eccc56€35.00€0.50matched
59capture01a1a1b1-293a-73be-a64c-2e801bee3d81€35.00€0.50matched
60capture01a1a1b1-4dda-74c7-9134-912751acd6a6€9.00€0.19matched
61capture01a1a1b1-50c5-7163-9239-ce067c172130€49.00€0.67matched
62capture01a1a1b1-5df0-7a39-ac4f-347699b0b85e€24.00€0.37matched
63capture01a1a1b1-6ddc-7f07-abec-532a809ac118€15.00€0.26matched
64capture01a1a1b1-72ec-765d-812b-b50d316290fe€35.00€0.50matched
65capture01a1a1b1-b50b-79b3-8e44-81756bbcd0aa€15.00€0.26matched
66capture01a1a1b1-c527-713a-9c54-61d21e0e5098€24.00€0.37matched
67refund01a1a1b1-e464-7e66-9d70-fa5aab36225d-€9.00€0.00matched
68refund01a1a1b1-f88a-7ab8-86ac-8180ed5ec431-€4.00€0.00matched
69capture01a1a1b1-fe7d-75c7-bea4-bc961e6d2c53€35.00€0.50matched
70capture01a1a1b2-0035-74d6-873c-e4f898fccd5d€49.00€0.67matched
71capture01a1a1b2-0eb9-74c6-83e0-4eef3e80ecbb€49.00€0.67matched
72capture01a1a1b2-1521-7563-a6ea-cea07c459882€15.00€0.26matched
73capture01a1a1b2-80a0-7493-839c-1258833a17da€35.00€0.50matched
75capture01a1a1b2-8eca-702e-a105-744c5759361d€24.00€0.37matched
76capture01a1a1b2-e043-78fe-a5f5-ff91d0b0b7e6€15.00€0.26matched
77capture01a1a1b2-f474-77e6-b210-58e760a7c353€9.00€0.19matched
78capture01a1a1b3-1cdd-78f7-b5a7-ad9043c020ac€35.00€0.50matched
79capture01a1a1b3-2adb-713e-9d46-7718708ff465€15.00€0.26matched
80capture01a1a1b3-44e9-720d-a61d-2b212d20c98c€9.00€0.19matched
81capture01a1a1b3-72f1-7b48-b030-416909555583€24.00€0.37matched
82capture01a1a1b3-7d19-7369-847f-92287aba39ba€24.00€0.37matched
83capture01a1a1b3-7f84-78fa-9778-3ea5d50922e9€24.00€0.37matched
84capture01a1a1b3-9328-7896-8b06-ed9f7fe6848b€15.00€0.26matched
85capture01a1a1b3-b0f0-7c63-aea1-766676310924€15.00€0.26matched
86capture01a1a1b3-b81a-72f6-8b2e-350d97e7df84€24.00€0.37matched
87capture01a1a1b3-bfe8-745b-bc83-fce3d20657aa€24.00€0.37matched
88capture01a1a1b3-c5bd-7a95-9399-648d093293c5€15.00€0.26matched
89capture01a1a1b3-ccb0-70af-a96e-4db6d01b7d72€24.00€0.37matched
90refund01a1a1b3-cde6-7995-af77-b1d3d1e5f3fe-€6.00€0.00matched
91capture01a1a1b3-d661-72af-a48d-33969101d836€49.00€0.67matched
92capture01a1a1b3-ddce-78f0-93a0-37f675dfe206€49.00€0.67matched
93capture01a1a1b3-e14a-7713-be98-3376da66f42f€15.00€0.26matched
94capture01a1a1b3-fd09-7387-bf25-1b8519dd813d€35.00€0.50matched
95capture01a1a1b4-072f-7330-b528-5c41c8ca8998€15.00€0.26matched
96capture01a1a1b4-0d61-7f85-93e0-2a06260f3de0€15.00€0.26matched
97capture01a1a1b4-0e8c-7932-ba71-eb78d84a8efb€9.00€0.19matched
98capture01a1a1b4-35af-7675-a36c-ada63eaa41a1€35.00€0.50matched
99capture01a1a1b4-3cc7-747b-b9e8-143166ad4fed€15.00€0.26matched
100capture01a1a1b4-6913-730d-88bb-7db83ea098c1€35.00€0.50matched
101capture01a1a1b4-75ba-7589-a23a-417d126f10de€15.00€0.26matched
102capture01a1a1b4-91cd-73e0-8e33-429cb727d4fc€15.00€0.26matched
103capture01a1a1b4-9bc8-7fc6-bea8-f6ba3b9f32bb€35.00€0.50matched
104capture01a1a1b4-b040-7e93-a7de-c13cf15b0360€24.00€0.37matched
105refund01a1a1b4-d57b-79c0-8d54-818f324dbc97-€5.00€0.00matched
106capture01a1a1b4-d901-778c-b648-ce5037bd9e62€15.00€0.26matched
107capture01a1a1b4-fac2-77bc-af8a-a320de4a403d€15.00€0.26matched
108capture01a1a1b5-01c6-762a-9e64-5b0e9712c4ce€24.00€0.37matched
109capture01a1a1b5-22d0-7a2e-9cea-8589533d6bd4€24.00€0.37matched
110capture01a1a1b5-45be-71c2-b1c7-3a1220a46bc3€35.00€0.50matched
111capture01a1a1b5-4d09-755a-bd29-2fe6ddbd2215€49.00€0.67matched
112capture01a1a1b5-550b-7939-8085-b2c0473202c6€24.00€0.37matched
113capture01a1a1b5-6016-7403-b526-f2a8cd525c75€24.00€0.37matched
114capture01a1a1b5-7e7a-775c-bfb5-b22ab212e775€9.00€0.19matched
115capture01a1a1b5-8fcb-7596-af9c-0ddf2b921924€15.00€0.26matched
116capture01a1a1b5-9096-717a-b187-9c7ed46299a3€49.00€0.67matched
117capture01a1a1b5-a782-7fbc-a908-5e0505d05282€15.00€0.26matched