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

6 Nov, 02:40

Gross

€2,630.00

PSP fee

€41.09

Net to the bank

€2,588.91

Settlement journal

#408453

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aeba-c2da-7641-b73c-b29571f3e03e is already settled by stl_EUR_2989888 line 9
  • duplicate linethe file lists it twicecapture:01a1aebb-8860-7cd1-befe-d1c9936ee005 is already settled by stl_EUR_2989888 line 18
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • missing linein the books, not in the filecapture:01a1aebe-a537-7443-809c-c65ca92c5d61 is in no file
LineKindReferenceGrossFeeStatus
10capture01a1aeba-c2f4-790f-bdd4-ace290dbf0ce€15.00€0.26duplicate line
19capture01a1aebb-8876-7e08-ac46-ca4089c1e6c6€24.00€0.37duplicate line
62capture01a1aebf-1476-7f5f-a435-b7a8a6510c86€49.00€0.72fee difference
1capture01a1aeb5-2eeb-779e-a809-297e6c5b1446€49.00€0.67matched
2capture01a1aeba-5a40-7749-8b44-e359c2006150€9.00€0.19matched
3capture01a1aeba-6b25-7484-9038-e18bda91d76c€15.00€0.26matched
4capture01a1aeba-7093-7e14-96bf-ca522d5d0cc9€35.00€0.50matched
5capture01a1aeba-9346-766f-9a1a-e52ec429323f€35.00€0.50matched
6capture01a1aeba-99fc-7565-a790-20b1ecdf1231€24.00€0.37matched
7capture01a1aeba-aedd-7888-a4cb-9bcc9d6e0684€15.00€0.26matched
8capture01a1aeba-b6cc-7588-8546-0915fde6d53d€15.00€0.26matched
9capture01a1aeba-c2f4-790f-bdd4-ace290dbf0ce€15.00€0.26matched
11capture01a1aeba-c41c-74d4-ac3b-d4c718004c2a€15.00€0.26matched
12capture01a1aeba-cd1e-74bb-a0d9-b78315f7becd€24.00€0.37matched
13capture01a1aeba-e4b8-7d7f-9b82-1e6d75e2c6cb€9.00€0.19matched
14capture01a1aebb-0c0b-700a-9346-da67a27ca579€24.00€0.37matched
15capture01a1aebb-2631-74b1-bee2-c23c64e68fd3€24.00€0.37matched
16refund01a1aebb-32f9-74a4-a307-5a8fc38a9abc-€7.00€0.00matched
17capture01a1aebb-7c98-71dd-98ab-07a8e4fc43a6€9.00€0.19matched
18capture01a1aebb-8876-7e08-ac46-ca4089c1e6c6€24.00€0.37matched
20capture01a1aebb-8c44-7200-bb6c-41cb348f45f9€15.00€0.26matched
21capture01a1aebb-ab8b-7905-9922-8c6cdad181e8€15.00€0.26matched
22capture01a1aebb-aba9-7511-bdaf-bb4c4043b5b2€15.00€0.26matched
23capture01a1aebb-d88f-79d8-bf05-439a8588f052€24.00€0.37matched
24capture01a1aebb-dab6-7f4c-90ab-a5ca8a8f3c04€49.00€0.67matched
25capture01a1aebb-e1bd-757d-8229-3cd9f858d3ac€15.00€0.26matched
26capture01a1aebb-e32d-74b1-8f1b-f3ad245b3c4d€15.00€0.26matched
27capture01a1aebc-2091-7db3-9b29-edfcb8b50412€35.00€0.50matched
28capture01a1aebc-2806-7e03-919d-1808850142c9€9.00€0.19matched
29capture01a1aebc-3183-793e-b7c8-4161ef6d05db€24.00€0.37matched
30capture01a1aebc-43b8-79cd-9b70-b8b826f71bf9€15.00€0.26matched
31capture01a1aebc-4f19-7229-9726-eadf63bcb456€49.00€0.67matched
32capture01a1aebc-505a-78c1-9d41-6fa792820d1a€24.00€0.37matched
33capture01a1aebc-69bb-72e0-807c-18e39932623f€24.00€0.37matched
34capture01a1aebc-6fa9-710e-bef4-c20b55ef0d1c€15.00€0.26matched
35refund01a1aebc-8458-7bd5-8931-2946ff3b874f-€6.00€0.00matched
36capture01a1aebc-9d37-731c-85a2-f11b5c509958€15.00€0.26matched
37capture01a1aebc-a229-7be4-96a4-bc832805d12b€9.00€0.19matched
38capture01a1aebc-ced2-7576-9e5f-3955b088a561€15.00€0.26matched
39capture01a1aebc-d218-7e3a-8df2-4c7b178fb1ed€9.00€0.19matched
40capture01a1aebc-ed18-7112-b6e0-33c37ec65c0d€9.00€0.19matched
41refund01a1aebd-02c7-7d08-9350-4edde740205f-€9.00€0.00matched
42capture01a1aebd-2e20-725d-b55c-66273a6408f0€9.00€0.19matched
43capture01a1aebd-4b90-78f9-bbc7-188766b22e21€9.00€0.19matched
44capture01a1aebd-5cd6-7bd2-ac2e-3106c08201c1€35.00€0.50matched
45capture01a1aebd-92f2-7bc8-8ccf-034a8bea7f2a€24.00€0.37matched
46capture01a1aebd-ac4e-7c44-aee1-2a9dcbcf9ab9€24.00€0.37matched
47capture01a1aebd-cb70-72d1-b3aa-83de317b52ca€24.00€0.37matched
48capture01a1aebd-cd06-7edd-bd45-0a6897ff56a1€9.00€0.19matched
49capture01a1aebe-0462-784a-bf94-6f8fcd41b553€9.00€0.19matched
50capture01a1aebe-1bc6-7341-b959-dc4921ab1544€24.00€0.37matched
51capture01a1aebe-4fbf-7f80-88c9-f25f0a5808d0€35.00€0.50matched
52capture01a1aebe-77ca-7332-a485-3ec1fa928448€35.00€0.50matched
53capture01a1aebe-822e-7425-9cd7-83cba054d5e2€15.00€0.26matched
54capture01a1aebe-83e5-76bc-b23e-8012a8a31f17€15.00€0.26matched
55capture01a1aebe-9ffd-7978-9a3f-5848128b7838€35.00€0.50matched
56capture01a1aebe-a8cb-7f8d-a904-df0df1a6d4eb€24.00€0.37matched
57capture01a1aebe-bfe4-7ed3-86ae-2aad855393bc€15.00€0.26matched
58capture01a1aebe-ef11-780d-841f-35aa8ce8611e€35.00€0.50matched
59capture01a1aebe-f84b-783c-a8a5-954050794f3b€15.00€0.26matched
60capture01a1aebf-0daa-7fa0-88d5-0901ce1c585b€15.00€0.26matched
61capture01a1aebf-113d-7efc-b70d-5f6744d8f361€15.00€0.26matched
63capture01a1aebf-16ad-7474-b135-f87f757cce65€35.00€0.50matched
64capture01a1aebf-30fa-7166-9a62-ca26e62115b7€49.00€0.67matched
65capture01a1aebf-6278-7333-b6c0-5b449999aa19€15.00€0.26matched
66capture01a1aebf-80cc-75c3-b20f-08f74dbaf457€9.00€0.19matched
67capture01a1aebf-899c-76dd-9e74-05e5eed984d5€49.00€0.67matched
68refund01a1aebf-d1ee-7aa2-9c96-2ec8837e0a61-€8.00€0.00matched
69capture01a1aebf-d2c1-7015-8bb5-00da68d83cfb€24.00€0.37matched
70capture01a1aebf-e08c-71d3-8da5-0e4e1ae12d02€24.00€0.37matched
71capture01a1aebf-eb06-703c-ba9d-13bcbcfb2b37€9.00€0.19matched
72capture01a1aebf-ec24-73c8-980d-c93ed9319455€24.00€0.37matched
73capture01a1aec0-2534-70b7-843b-bcc14fcd78a2€49.00€0.67matched
74capture01a1aec0-29c8-7f3e-8ce2-0b5df2cbf47d€9.00€0.19matched
75capture01a1aec0-37e7-77d4-aa13-f077188393e8€15.00€0.26matched
76capture01a1aec0-369c-7334-a564-8d2494ddec46€35.00€0.50matched
77capture01a1aec0-5796-72f7-8cfe-efe767d68af2€15.00€0.26matched
78capture01a1aec0-a8d4-7726-ba60-efd8f8c44b7c€9.00€0.19matched
79capture01a1aec0-c491-7b59-b238-f047ec6f89ef€49.00€0.67matched
80capture01a1aec0-d15d-7fdb-ae07-5b76f05751d7€24.00€0.37matched
81capture01a1aec0-dfd5-7704-9990-0466b49c372d€9.00€0.19matched
82capture01a1aec0-ef36-709c-aeed-4df6a7147e49€35.00€0.50matched
83capture01a1aec0-fdfb-71dd-b6b2-8b56b812479a€9.00€0.19matched
84capture01a1aec1-20c3-71aa-8aba-bd1ce5b9ac53€24.00€0.37matched
85capture01a1aec1-2caf-7cd4-8be0-57114eeb63db€15.00€0.26matched
86capture01a1aec1-3246-7cd2-96bf-cab8fd1141bd€24.00€0.37matched
87refund01a1aec1-67d3-726c-9b43-78588ac96ac4-€13.00€0.00matched
88capture01a1aec1-74b9-7396-b8e2-f14a26a15b29€49.00€0.67matched
89capture01a1aec1-79d6-7420-865b-36f2023ddba4€9.00€0.19matched
90capture01a1aec1-7c93-71bb-a307-c8d8e2484b7c€24.00€0.37matched
91capture01a1aec1-8546-7a8c-91dc-a5a861f42293€24.00€0.37matched
92capture01a1aec1-ae9c-7bfa-8ef1-0555efe3fddb€24.00€0.37matched
93capture01a1aec1-b2dd-784d-9de1-2126e2317ba1€15.00€0.26matched
94capture01a1aec1-b5dd-714f-b68d-6decadcc9fe5€24.00€0.37matched
95capture01a1aec1-c0e9-70b6-b3fa-e6087861f0a1€49.00€0.67matched
96capture01a1aec1-c3fd-74c9-b485-889cdc93da5b€24.00€0.37matched
97capture01a1aec1-da6b-7c2d-a109-eb8537a9c44f€49.00€0.67matched
98capture01a1aec1-e395-7013-9772-7fc31320cac3€24.00€0.37matched
99capture01a1aec1-e3fe-712e-ad03-9832d95a3022€15.00€0.26matched
100capture01a1aec1-e8fb-787d-b219-31f578bd593b€49.00€0.67matched
101refund01a1aec2-1f2e-7a53-b447-47701e33f971-€6.00€0.00matched
102capture01a1aec2-203d-7066-a3ab-4fd586772631€24.00€0.37matched
103capture01a1aec2-24df-713b-9319-3f28ca5d37bb€35.00€0.50matched
104capture01a1aec2-58aa-768a-952f-2515dde6f6ae€49.00€0.67matched
105capture01a1aec2-6208-7214-8213-92f487c1b6de€49.00€0.67matched
106capture01a1aec2-75b1-787a-a4b0-c9ea4b8c8562€15.00€0.26matched
107capture01a1aec2-7ae5-7468-ae2a-ed53a204a42b€49.00€0.67matched
108capture01a1aec2-af4e-722e-8ed5-caebf5a85b46€49.00€0.67matched
109capture01a1aec2-b451-7bf3-b10a-1e893bb54440€9.00€0.19matched
110capture01a1aec2-b5c8-76e9-9b73-67560c555ea2€9.00€0.19matched
111refund01a1aec2-d8c4-74be-91f2-47cf2a3c484e-€3.00€0.00matched
112capture01a1aec2-e213-7ed9-80a4-c397ee879853€35.00€0.50matched
113capture01a1aec2-e8fb-757f-a6da-259c6089cadf€49.00€0.67matched
114capture01a1aec3-3bac-789f-baf8-a64fc67e3066€49.00€0.67matched
115capture01a1aec3-4ce9-7c3e-8ff7-944c8c2d8a73€49.00€0.67matched
116capture01a1aec3-5124-73ff-bd3c-e892db655a02€24.00€0.37matched