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

Gross

€2,858.00

PSP fee

€46.76

Net to the bank

€2,811.24

Settlement journal

#399434

Breaks for a person to look at

  • duplicate linethe file lists it twicerefund:01a1ac31-caef-7a77-80b6-9a699525a669 is already settled by stl_EUR_2989817 line 27
  • duplicate linethe file lists it twicecapture:01a1ac38-14ef-784d-83fc-3d6aad524078 is already settled by stl_EUR_2989817 line 119
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 4, the contract says 0
  • missing linein the books, not in the filecapture:01a1ac35-8aef-7824-b91c-cb8ed41ab246 is in no file
  • missing linein the books, not in the filecapture:01a1ac36-3b75-734c-9f2b-8bc494f15f90 is in no file
  • missing linein the books, not in the filecapture:01a1ac37-cfdc-7e54-9591-c4c407c1087b is in no file
LineKindReferenceGrossFeeStatus
28refund01a1ac31-caf1-7d40-adff-8264ecd16a57-€11.00€0.00duplicate line
40capture01a1ac32-4c59-7361-95c1-56e1aa91e54f€24.00€0.40fee difference
103refund01a1ac37-2771-7a98-abb8-a9640b2caeeb-€6.00€0.04fee difference
120capture01a1ac38-236a-7738-84f3-fa193f87005d€15.00€0.26duplicate line
1capture01a1ac2a-0e9b-7bc3-88f6-ac0dadc78b03€35.00€0.50matched
2capture01a1ac2a-66cd-714d-81e6-16270086daad€24.00€0.37matched
3capture01a1ac2b-cf42-7e19-987a-cab8d7e81fae€9.00€0.19matched
4capture01a1ac2e-1711-737d-ae20-178e11608bba€15.00€0.26matched
5capture01a1ac30-4b19-7c2f-8ce3-2d423fcbe1b6€24.00€0.37matched
6capture01a1ac30-60be-7819-8cc9-1a37b29f7590€35.00€0.50matched
7capture01a1ac30-610d-759e-b17e-2f52c87c0598€9.00€0.19matched
8capture01a1ac30-7ea8-73dd-a9ef-791d6f05f1b3€49.00€0.67matched
9capture01a1ac30-806c-70c5-87ae-5e4342153b69€49.00€0.67matched
10capture01a1ac30-a011-7361-840d-6533c4378cb8€9.00€0.19matched
11capture01a1ac30-a456-7e91-9f09-3d7d3d708515€24.00€0.37matched
12capture01a1ac30-b1d5-7dba-bf94-a89c1125f761€49.00€0.67matched
13capture01a1ac30-c630-7434-bd22-afcf10e607fa€15.00€0.26matched
14capture01a1ac30-cfa9-71a5-82ad-fa5a9372ac96€49.00€0.67matched
15refund01a1ac30-d530-789b-ac67-01d2522ed0e8-€31.00€0.00matched
16capture01a1ac31-2b44-79f5-9dda-c8983169294e€35.00€0.50matched
17capture01a1ac31-2ee0-7616-b40f-b2f5c45cd81c€9.00€0.19matched
18capture01a1ac31-32f1-7147-b842-cc3da6b755e0€24.00€0.37matched
19capture01a1ac31-4af6-7eb8-bf95-bc9fb6864e47€35.00€0.50matched
20capture01a1ac31-55d5-7a67-8c92-90be95c70799€15.00€0.26matched
21capture01a1ac31-5c45-75f6-bc5a-e6609f21e65e€49.00€0.67matched
22capture01a1ac31-6ef7-79ce-854a-5cb4a30895dc€15.00€0.26matched
23capture01a1ac31-73eb-74cb-8d9c-151a2e21dda9€24.00€0.37matched
24capture01a1ac31-84e6-7659-a754-e4ada70b1652€15.00€0.26matched
25capture01a1ac31-a789-7676-8afb-6ca43e8f1936€24.00€0.37matched
26capture01a1ac31-bbb4-70e0-9b5e-638cadd23305€24.00€0.37matched
27refund01a1ac31-caf1-7d40-adff-8264ecd16a57-€11.00€0.00matched
29refund01a1ac31-e11e-7bbe-9dd7-b0628fa40880-€20.00€0.00matched
30capture01a1ac31-e141-7e98-a251-26c650d134b4€24.00€0.37matched
31capture01a1ac31-f7b6-7012-8cce-ee015962477b€24.00€0.37matched
32capture01a1ac31-fd7b-7351-a221-91fd216eb911€15.00€0.26matched
33capture01a1ac32-0a27-7dec-b26a-c7369ec407a9€35.00€0.50matched
34capture01a1ac32-0c26-7180-994a-b411a44974f7€9.00€0.19matched
35capture01a1ac32-196a-7abc-bc38-b95e44572dcd€24.00€0.37matched
36capture01a1ac32-2cf9-7925-aa80-cf320e1c2d1e€9.00€0.19matched
37refund01a1ac32-3785-7095-ba56-3b69da229741-€6.00€0.00matched
38capture01a1ac32-41d8-7088-9964-975e4950b7bd€49.00€0.67matched
39capture01a1ac32-488c-7d35-87d9-f30d98a74515€49.00€0.67matched
41capture01a1ac32-4fd7-780b-ae1b-85854193c205€49.00€0.67matched
42refund01a1ac32-568a-7a45-b937-a5039390ff7b-€7.00€0.00matched
43capture01a1ac32-6d93-7eb6-971f-97e0b9c6e150€49.00€0.67matched
44capture01a1ac32-82b9-76e4-8226-7b35fc7bc20f€24.00€0.37matched
45capture01a1ac32-8dbb-7842-b941-20efbc960207€15.00€0.26matched
46refund01a1ac32-954e-7535-9b0f-034694816f6c-€7.00€0.00matched
47capture01a1ac32-c756-729a-a579-a0dbbf8da246€35.00€0.50matched
48capture01a1ac32-db7e-768f-b9c2-e7b5c0525ab0€9.00€0.19matched
49capture01a1ac32-e29b-7d90-98ab-7752f2f17e6f€15.00€0.26matched
50capture01a1ac32-e81a-7ebc-a41a-ccc431296914€24.00€0.37matched
51capture01a1ac32-f335-7301-8d27-2efc5607f903€35.00€0.50matched
52capture01a1ac32-faf4-7be3-ae79-4b87cd2dd75e€49.00€0.67matched
53capture01a1ac33-17e6-7b27-8f1c-40300cf64298€15.00€0.26matched
54capture01a1ac33-1ba6-7c00-9af2-e5a2d590a1ab€15.00€0.26matched
55capture01a1ac33-3915-7483-8f99-efaa7967ab0d€15.00€0.26matched
56capture01a1ac33-441d-7ef1-a937-9aade094967a€24.00€0.37matched
57refund01a1ac33-4d4b-7d6d-9845-dd2ce41e8b52-€9.00€0.00matched
58capture01a1ac33-5f6b-78b4-b48d-67aced75347d€35.00€0.50matched
59capture01a1ac33-67c2-7a2a-bc8d-7c8fe3dd13e4€15.00€0.26matched
60capture01a1ac33-6fb5-73d4-a31f-313e2ceddbd5€24.00€0.37matched
61capture01a1ac33-85b0-7848-b884-1750a0bd21d8€49.00€0.67matched
62capture01a1ac33-9bf8-7de0-a4b5-d4268b9ddeed€9.00€0.19matched
63capture01a1ac33-a302-76ae-9fc5-425136030bd7€35.00€0.50matched
64refund01a1ac33-d2fc-7302-9808-a28a0d4b8d7f-€32.00€0.00matched
65capture01a1ac33-d7e2-74f6-aa18-52b24d8a5e8a€49.00€0.67matched
66refund01a1ac33-df7f-7609-8eff-beb236e42972-€7.00€0.00matched
67capture01a1ac33-ea60-73b5-afec-b8454292585e€15.00€0.26matched
68capture01a1ac33-f302-7bff-8d58-8bdd2ec5e558€9.00€0.19matched
69capture01a1ac34-163a-7258-bb38-f56f1af16881€49.00€0.67matched
70refund01a1ac34-3d9b-7a35-a53b-c1cff262b8c9-€8.00€0.00matched
71capture01a1ac34-4fd1-7db3-9522-131be7e41edf€35.00€0.50matched
72capture01a1ac34-999e-785e-b011-babdb8914676€24.00€0.37matched
73refund01a1ac34-ae09-7548-970d-e20fa69b239a-€13.00€0.00matched
74capture01a1ac34-ba09-78c9-a853-eda81346853b€49.00€0.67matched
75capture01a1ac34-c98f-7cc7-98a4-19fcff9cb92c€49.00€0.67matched
76refund01a1ac34-df7d-7627-be53-ce848372b107-€10.00€0.00matched
77capture01a1ac34-e84f-7dbc-9906-dc60a3d4e102€35.00€0.50matched
78capture01a1ac34-ecbf-740f-80c9-e6ef1ead6779€9.00€0.19matched
79refund01a1ac35-2e89-722f-a723-5f15a09fc7d9-€22.00€0.00matched
80capture01a1ac35-49b3-7df6-892c-318a76e6a001€24.00€0.37matched
81capture01a1ac35-4ab4-7851-ac80-13daf9d8070c€49.00€0.67matched
82refund01a1ac35-5051-740b-8757-0d38f455f69c-€22.00€0.00matched
83capture01a1ac35-5288-701f-91e3-b914ce78ac66€35.00€0.50matched
84capture01a1ac35-59eb-7543-8fac-926750b11ed5€35.00€0.50matched
85capture01a1ac35-62b3-7702-9221-c7799e5cf2c7€49.00€0.67matched
86capture01a1ac35-7900-759e-84f4-b9110893c0c4€49.00€0.67matched
87capture01a1ac35-d277-75f0-b32c-452831aed904€15.00€0.26matched
88capture01a1ac35-dfff-7a71-b094-34a998430f14€9.00€0.19matched
89capture01a1ac35-e0cb-779e-a3dd-254659da6f98€35.00€0.50matched
90capture01a1ac36-3130-75d8-9059-fd2b4b5382d9€24.00€0.37matched
91capture01a1ac36-3293-7591-b89e-90e40c76c90b€35.00€0.50matched
92capture01a1ac36-396b-7dce-b1c6-a52af0c11952€15.00€0.26matched
93capture01a1ac36-4e5b-7e5f-a10a-a565fa7ae3bd€24.00€0.37matched
94capture01a1ac36-5caa-7c93-a8c8-3f43e876d11c€35.00€0.50matched
95capture01a1ac36-78ef-7318-b161-6c8eb8270da0€24.00€0.37matched
96capture01a1ac36-80aa-7147-80af-1ac444a2c797€35.00€0.50matched
97capture01a1ac36-8a0c-77a8-ae58-4aecb35513ce€15.00€0.26matched
98capture01a1ac36-a4aa-7b77-bd8c-488bcedf7e77€35.00€0.50matched
99capture01a1ac36-ab1f-7e2c-94e4-1fb518ac690d€9.00€0.19matched
100capture01a1ac36-c611-7871-a514-d527924afbeb€15.00€0.26matched
101capture01a1ac36-f202-7335-9602-87c4d4c550b2€24.00€0.37matched
102capture01a1ac36-f12f-7754-b1e0-338accb5f7e1€49.00€0.67matched
104capture01a1ac37-3e5f-716f-b37a-063ebcda5511€49.00€0.67matched
105capture01a1ac37-422e-7e83-97b0-7522dc867b4c€35.00€0.50matched
106capture01a1ac37-434a-7e6a-9933-f5542a959b67€49.00€0.67matched
107capture01a1ac37-4360-7cf7-b206-71df17a3f4c8€9.00€0.19matched
108capture01a1ac37-6918-71e4-8436-a94ee727f967€49.00€0.67matched
109capture01a1ac37-9a40-76b8-b3cd-b7fb1b6f9ca0€24.00€0.37matched
110capture01a1ac37-a688-7047-add6-ac7be13058ba€9.00€0.19matched
111capture01a1ac37-b145-7deb-8a68-9ed856355650€9.00€0.19matched
112capture01a1ac37-b6fb-7270-99a0-074386ff8ba8€24.00€0.37matched
113capture01a1ac37-b934-735c-860c-2e84fbcaf12f€24.00€0.37matched
114capture01a1ac37-bec9-7b88-9347-54dab4fa1f76€15.00€0.26matched
115capture01a1ac38-010e-77df-afc9-47018b291152€15.00€0.26matched
116capture01a1ac38-0299-78a6-8ad0-4a35ca8afb74€24.00€0.37matched
117capture01a1ac38-17ab-7734-98f4-64e80f2fdadc€9.00€0.19matched
118capture01a1ac38-1f91-7766-bc75-2899183d32a9€35.00€0.50matched
119capture01a1ac38-236a-7738-84f3-fa193f87005d€15.00€0.26matched
121capture01a1ac38-38bb-745a-943d-2edbb37b170c€9.00€0.19matched
122capture01a1ac38-60b2-7d7e-a8ce-86445f17484e€15.00€0.26matched
123refund01a1ac38-7239-777a-bee3-1b7064ddf64a-€17.00€0.00matched
124capture01a1ac38-782a-7a44-aca4-eb0c4f3dbedd€24.00€0.37matched
125capture01a1ac38-7d26-795f-a60f-6102ec09ef02€35.00€0.50matched
126capture01a1ac38-8558-7de9-b75f-f585e43aa1a9€15.00€0.26matched
127capture01a1ac38-ae3a-734a-a5c4-f09c65a096f1€24.00€0.37matched
128capture01a1ac38-b54d-7207-9c9b-84e8fbce803c€9.00€0.19matched
129capture01a1ac38-c03b-72a2-8e41-6d621d31c7b1€24.00€0.37matched
130refund01a1ac38-eb35-7b76-a1c3-d69d32ee38e1-€9.00€0.00matched
131capture01a1ac38-eebb-758c-9f10-4d4c9d5fcbe2€35.00€0.50matched
132capture01a1ac39-1854-7b68-9924-9ddc4cd97c12€15.00€0.26matched
133capture01a1ac39-19ea-7192-b0c2-91c8c9ab42b3€15.00€0.26matched
134capture01a1ac39-4f70-7ca8-a468-813bd6bd3475€49.00€0.67matched