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

Gross

€2,949.00

PSP fee

€46.05

Net to the bank

€2,902.95

Settlement journal

#333727

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a199a9-f1c7-76fd-b2a4-e8a7cfe2ef54 is already settled by stl_EUR_2989299 line 5
  • duplicate linethe file lists it twicecapture:01a199ac-e70c-7558-8101-b5eed8d245f4 is already settled by stl_EUR_2989299 line 48
  • duplicate linethe file lists it twicecapture:01a199b2-4ca8-72a4-a6f5-ae3e9349b6f1 is already settled by stl_EUR_2989299 line 117
  • fee differencethe fee is not the contract feethe fee is 27, the contract says 26
  • missing linein the books, not in the filecapture:01a199aa-4b17-7ce7-ba09-f438fc3b0aae is in no file
LineKindReferenceGrossFeeStatus
6capture01a199aa-0fd8-78d5-9d7c-59b193b271c0€24.00€0.37duplicate line
30capture01a199ab-cdd2-7c21-a0b4-585e90c13271€15.00€0.27fee difference
49capture01a199ac-e74e-7425-a046-06a88095aeee€24.00€0.37duplicate line
118capture01a199b2-6447-74cc-8857-f9361b22b0ab€9.00€0.19duplicate line
1capture01a199a4-5a93-7203-b72c-f4766aeea1c3€15.00€0.26matched
2capture01a199a7-0f51-74e5-bc3d-6a7006ef8b07€49.00€0.67matched
3refund01a199aa-0179-7767-9dcd-f0b39a8be489-€5.00€0.00matched
4capture01a199aa-0c2b-7e79-9297-84d84d2a9846€35.00€0.50matched
5capture01a199aa-0fd8-78d5-9d7c-59b193b271c0€24.00€0.37matched
7capture01a199aa-1f1d-715d-9540-923c51a7ade8€24.00€0.37matched
8capture01a199aa-2c87-74f3-b95e-ffb711806f9a€35.00€0.50matched
9capture01a199aa-31c1-715f-a54a-1be1c75f991b€15.00€0.26matched
10capture01a199aa-44cc-749b-80c6-143ae8559fc1€49.00€0.67matched
11capture01a199aa-4ac4-7d84-8e02-aeeaa42292b2€9.00€0.19matched
12capture01a199aa-653e-7da1-9e2b-d659c5b32696€35.00€0.50matched
13refund01a199aa-9563-755d-8deb-38899eaab83b-€10.00€0.00matched
14capture01a199aa-9689-7a4b-8750-4d2228a6f72b€49.00€0.67matched
15capture01a199aa-a024-77b8-86b9-0d043601c285€24.00€0.37matched
16capture01a199aa-a823-793a-81f6-e285a8e72106€15.00€0.26matched
17capture01a199aa-a9ac-7b4c-bcaf-d86a9d348a2d€15.00€0.26matched
18capture01a199aa-b487-71f0-84f6-a4d4a3a23933€35.00€0.50matched
19capture01a199aa-b8e4-7705-908d-a5dba70890d0€24.00€0.37matched
20capture01a199aa-ce86-7e29-adbf-cacba99d8bc4€49.00€0.67matched
21capture01a199aa-dca7-71dd-b2eb-4463136ac1b9€15.00€0.26matched
22capture01a199aa-f1e6-7b5a-b0b0-f462f80fac95€9.00€0.19matched
23capture01a199aa-fcd4-7eaa-b5c0-dd567d614cbd€24.00€0.37matched
24capture01a199ab-2de7-7011-b0c6-501d611d9ba7€49.00€0.67matched
25capture01a199ab-44dd-7c6b-942f-59b9fb289337€49.00€0.67matched
26capture01a199ab-8f91-771f-be9c-d014b14179b0€49.00€0.67matched
27capture01a199ab-90a9-77fe-9914-7d1e2efc3541€49.00€0.67matched
28capture01a199ab-94f0-701f-8323-b01650053124€24.00€0.37matched
29capture01a199ab-c14b-759d-bece-e370d5e1221d€9.00€0.19matched
31capture01a199ab-e013-74be-8c83-b1235990c723€49.00€0.67matched
32capture01a199ab-e852-767c-85d6-eb16e2e49ee7€15.00€0.26matched
33capture01a199ab-f947-73fa-bc98-34459bd389bc€9.00€0.19matched
34capture01a199ab-fafd-72bb-84e2-093ec0eac8e2€24.00€0.37matched
35capture01a199ac-135e-7456-99c9-c3de5211b05d€35.00€0.50matched
36refund01a199ac-2ba6-7c16-b620-2e9f6eaae4f9-€13.00€0.00matched
37capture01a199ac-3293-7f07-bbec-f8f21ac10b0f€35.00€0.50matched
38capture01a199ac-33df-7f6b-b81a-d6e751119c6e€49.00€0.67matched
39capture01a199ac-6026-76d2-9d2e-71dc3734669f€15.00€0.26matched
40capture01a199ac-7346-7a1f-8b42-2ee59c2e55f5€15.00€0.26matched
41capture01a199ac-787c-776c-b129-4930dea0ab5a€35.00€0.50matched
42capture01a199ac-7c90-79ab-9feb-a17c7a3178df€24.00€0.37matched
43capture01a199ac-812a-7931-97ba-a0a04e4b746d€15.00€0.26matched
44capture01a199ac-83e3-79e7-89f6-168914692b5b€49.00€0.67matched
45refund01a199ac-9eb4-7aa7-ab56-ab15df50ee6f-€30.00€0.00matched
46capture01a199ac-a73b-72e1-b4f2-f08736d618b1€35.00€0.50matched
47capture01a199ac-d6e8-7653-ab68-0f52dfdb37ca€49.00€0.67matched
48capture01a199ac-e74e-7425-a046-06a88095aeee€24.00€0.37matched
50capture01a199ac-f90f-75bf-b47f-58f6885a33da€15.00€0.26matched
51capture01a199ad-0adf-7e19-9a15-b8ffd4957fa8€24.00€0.37matched
52capture01a199ad-1526-75e9-9722-5042ca7959c9€24.00€0.37matched
53capture01a199ad-234a-7e9f-b917-e70ff2c5cd84€9.00€0.19matched
54capture01a199ad-249c-7678-99b7-6158b425b0bf€35.00€0.50matched
55capture01a199ad-31d2-7e26-8166-5be64fb8b795€9.00€0.19matched
56capture01a199ad-3b0a-74ad-b60a-b00d4968fabd€15.00€0.26matched
57capture01a199ad-46cf-7a32-9433-ea4346895300€15.00€0.26matched
58capture01a199ad-49f9-78fe-ad96-ffeaf5c0c3ae€35.00€0.50matched
59capture01a199ad-5777-7453-bca6-00c6b103fdf1€9.00€0.19matched
60refund01a199ad-7651-7f9b-b882-f79a9e8f7ba6-€19.00€0.00matched
61refund01a199ad-916b-7a1f-ac8b-a56b7c702e15-€6.00€0.00matched
62capture01a199ad-ae2d-79c5-960c-001da8778b83€15.00€0.26matched
63capture01a199ad-ce15-7a9a-b3a0-ce263b2a7931€49.00€0.67matched
64capture01a199ad-d364-7720-8376-a33b2cda1b37€49.00€0.67matched
65capture01a199ad-d88d-7efe-82c6-35d983b758c7€24.00€0.37matched
66capture01a199ad-f12f-726c-baae-bfe0a5b27ab1€9.00€0.19matched
67capture01a199ad-fc33-7fdc-93e7-c0e5237befc4€24.00€0.37matched
68capture01a199ad-fd92-72a8-944c-38841afecbf7€15.00€0.26matched
69capture01a199ae-6e9c-752f-b1d3-0e077b050e6d€49.00€0.67matched
70capture01a199ae-7af7-73e6-b3bd-d15bb1fa02f5€9.00€0.19matched
71capture01a199ae-9708-7a03-ab99-ec77702f6089€24.00€0.37matched
72capture01a199ae-abec-744f-988d-0f8eee8b6021€49.00€0.67matched
73capture01a199ae-afa4-7947-b82f-90eae4f476a0€15.00€0.26matched
74capture01a199ae-dcff-7314-9cb0-b53c85914f9a€15.00€0.26matched
75capture01a199ae-ea5a-7bb5-94ed-d234e5fd8d25€35.00€0.50matched
76refund01a199af-11b8-7ebe-b8f4-88a2ae0943b8-€10.00€0.00matched
77refund01a199af-1d6b-7df3-be47-9ac74e5457f1-€4.00€0.00matched
78capture01a199af-4f76-794c-a9fc-84e0abc8002c€15.00€0.26matched
79capture01a199af-65c0-72a3-9c36-719affc317a5€49.00€0.67matched
80capture01a199af-6fd7-776b-9cdd-276fcdf706fd€35.00€0.50matched
81capture01a199af-76ae-7e89-bfd1-bf6321013ab9€35.00€0.50matched
82capture01a199af-952d-7b35-8855-099f9b01ba55€49.00€0.67matched
83capture01a199af-9d78-765d-a79d-1c1abf10dac8€24.00€0.37matched
84capture01a199af-b2b6-7527-91b0-c535d10cf2b8€35.00€0.50matched
85capture01a199af-ec74-721f-ab36-a7638dc79c34€24.00€0.37matched
86capture01a199b0-0394-7971-8f7e-d6e503594489€35.00€0.50matched
87capture01a199b0-1425-77d5-aceb-4b86d7cb7363€49.00€0.67matched
88capture01a199b0-168b-7df1-979c-e8ae708e0001€9.00€0.19matched
89capture01a199b0-2551-79fd-afdc-374b303b65a6€49.00€0.67matched
90capture01a199b0-31ab-7f7d-af8b-f23734483d41€24.00€0.37matched
91capture01a199b0-3fd2-7f43-bee9-6e2e77e03643€35.00€0.50matched
92capture01a199b0-4662-7114-9065-95f7e1bf14bc€15.00€0.26matched
93capture01a199b0-4c29-7c39-b85a-7e7a925766a9€35.00€0.50matched
94refund01a199b0-566b-7abb-88e8-fabc3b683e54-€5.00€0.00matched
95capture01a199b0-5b30-766f-b5e1-ad53379c746c€9.00€0.19matched
96capture01a199b0-c345-730c-822c-72eedf9e4b7d€24.00€0.37matched
97capture01a199b0-d481-7508-b5e2-8b44d73c9d0a€15.00€0.26matched
98capture01a199b0-da25-7b72-8558-4bc8fe55eec3€15.00€0.26matched
99capture01a199b0-dfd2-74cc-a9ef-3a6e2cf9d752€49.00€0.67matched
100capture01a199b0-e297-70ce-93a0-f45ee5660c78€24.00€0.37matched
101refund01a199b1-18e2-7a13-88b6-96b9537ff352-€16.00€0.00matched
102capture01a199b1-1cc2-7812-bafc-3112eec4f85c€35.00€0.50matched
103capture01a199b1-33cf-7663-a3ff-8d7e441c8879€35.00€0.50matched
104capture01a199b1-7b0d-7fd1-9939-d6ea753dcb86€9.00€0.19matched
105capture01a199b1-7be3-76b4-8d25-3160740cbc78€24.00€0.37matched
106capture01a199b1-996d-7ca4-8662-139fb3b9c8e4€15.00€0.26matched
107capture01a199b1-d56b-711b-bfc0-b09ee04d0c84€35.00€0.50matched
108capture01a199b1-dd09-738d-9773-495e5ec8d56d€9.00€0.19matched
109capture01a199b1-e74b-7617-a9de-ed93968c7f78€24.00€0.37matched
110capture01a199b1-fa63-7460-8d86-12781e86eea1€9.00€0.19matched
111capture01a199b2-1418-7473-9b2a-c5b58df7fc77€24.00€0.37matched
112capture01a199b2-2202-757d-a888-828b9771430d€24.00€0.37matched
113capture01a199b2-267d-791f-9f05-4037023b62eb€15.00€0.26matched
114capture01a199b2-3a0d-74cb-a0a9-cf2a7967301e€24.00€0.37matched
115capture01a199b2-424d-72c1-82e3-aa072b9fcc87€49.00€0.67matched
116refund01a199b2-6070-7fea-9b8a-fbe3fde79851-€5.00€0.00matched
117capture01a199b2-6447-74cc-8857-f9361b22b0ab€9.00€0.19matched
119capture01a199b2-983f-7024-a452-c3680ca2fe27€49.00€0.67matched
120capture01a199b2-a07e-7f14-9255-923e3f1d3986€15.00€0.26matched
121capture01a199b2-aa52-7870-b5c8-7d7201d662af€9.00€0.19matched
122capture01a199b2-abed-7f10-bfca-a8d799768c26€35.00€0.50matched
123capture01a199b2-af21-71e6-8bdd-f98d3d016cae€49.00€0.67matched
124capture01a199b2-c5ec-7707-8455-a74c70f8a2e6€24.00€0.37matched