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

Gross

€3,126.00

PSP fee

€50.55

Net to the bank

€3,075.45

Settlement journal

#350026

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19e42-c384-797e-9720-44be74bcbfcd is already settled by stl_EUR_2989427 line 83
  • 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 29, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
LineKindReferenceGrossFeeStatus
66capture01a19e41-f154-7016-87cb-84ec24cc6bba€49.00€0.72fee difference
84capture01a19e42-c3b4-7d5f-99e9-f16114587d6a€15.00€0.26duplicate line
97capture01a19e43-4b89-7f67-a952-843ba34714a7€15.00€0.29fee difference
140capture01a19e46-58a1-7ce3-87a1-4d91a5d45535€35.00€0.51fee difference
1capture01a19e34-a0f6-7ead-b24b-c64e640dbc5c€49.00€0.67matched
2capture01a19e35-f197-7993-8705-a09a57be56fe€35.00€0.50matched
3capture01a19e36-987f-7412-a8e2-66d49c8f305c€9.00€0.19matched
4capture01a19e3d-a2fe-798a-8fd5-d12b8674edc4€24.00€0.37matched
5capture01a19e3d-d0dd-73a9-ae6e-8adb7ed41a4a€15.00€0.26matched
6capture01a19e3d-d491-7cf4-8c19-25df0f08807f€24.00€0.37matched
7capture01a19e3d-e42b-7786-a513-26d8de0a2983€49.00€0.67matched
8capture01a19e3e-0e20-7c91-ac8f-9fea6cebccd3€35.00€0.50matched
9capture01a19e3e-2588-7d03-a742-1416fc053953€35.00€0.50matched
10capture01a19e3e-28a9-71a1-a0d1-27cce1910a4b€15.00€0.26matched
11capture01a19e3e-39ff-7ce5-b0b6-d1882658298a€24.00€0.37matched
12capture01a19e3e-42e5-7c96-b56e-4c3242f4afd7€49.00€0.67matched
13refund01a19e3e-776f-7f89-bce1-308188934070-€27.00€0.00matched
14capture01a19e3e-9e54-7bb6-9788-bc52da7efee4€35.00€0.50matched
15capture01a19e3e-a801-77a2-ab19-380d5552b14f€9.00€0.19matched
16capture01a19e3e-baca-7c6d-ab73-29fff6a41053€49.00€0.67matched
17capture01a19e3e-c731-73d9-ad12-b58dd2943648€49.00€0.67matched
18capture01a19e3e-e511-7dad-9a61-7435d3539ba1€49.00€0.67matched
19capture01a19e3f-3b76-7a2f-9795-5d62c39a497d€35.00€0.50matched
20capture01a19e3f-3ec8-735f-a43c-d79e4ad625ec€15.00€0.26matched
21capture01a19e3f-40cc-703b-9c62-07126c40a4be€15.00€0.26matched
22capture01a19e3f-4357-75f2-9356-c2599d400a86€24.00€0.37matched
23refund01a19e3f-4381-7fbe-acd5-d3e77adb9fd1-€29.00€0.00matched
24capture01a19e3f-6830-7c4d-8ed6-f074dbca314d€24.00€0.37matched
25capture01a19e3f-6ca8-7a90-9fd8-325dba6b03cc€35.00€0.50matched
26capture01a19e3f-a99f-7eba-bbb3-c58967908861€15.00€0.26matched
27capture01a19e3f-b556-79d4-8743-469366f46cbf€9.00€0.19matched
28refund01a19e3f-b6e3-73f8-80fc-ba9db6f429b0-€20.00€0.00matched
29capture01a19e3f-c3e0-7179-adee-818a291c5ab7€15.00€0.26matched
30capture01a19e3f-ce2e-7d30-8d78-cecce354af9a€15.00€0.26matched
31capture01a19e3f-d6bd-714d-ab3d-30418a0a5462€49.00€0.67matched
32refund01a19e3f-d9f5-7ec1-9403-6dccc8890737-€9.00€0.00matched
33capture01a19e3f-e9d2-7c93-8b4d-c795cfe12cd5€9.00€0.19matched
34capture01a19e3f-ffe6-7272-bf24-f3759f8284b8€35.00€0.50matched
35capture01a19e40-05b5-7724-b761-a16a4453968a€15.00€0.26matched
36capture01a19e40-0f3a-7e28-8cb3-24193b1648e4€49.00€0.67matched
37capture01a19e40-1427-7906-8d05-5140a60e0cd6€15.00€0.26matched
38capture01a19e40-1797-7aaf-bbfd-cc99d6aa176e€35.00€0.50matched
39capture01a19e40-1b8a-788e-b169-d02c96b5c6e6€15.00€0.26matched
40capture01a19e40-1d55-7022-b1e6-cff2b3c0c20d€9.00€0.19matched
41capture01a19e40-1e29-770c-80bc-a29149575c52€35.00€0.50matched
42capture01a19e40-2076-7816-b3d2-9c4cc48b48e0€9.00€0.19matched
43capture01a19e40-20d8-7bb6-9d99-6b0c8233eec7€24.00€0.37matched
44capture01a19e40-33c2-767d-9891-fb7564bb386b€24.00€0.37matched
45capture01a19e40-720d-7097-b770-76c8798f4ba0€35.00€0.50matched
46capture01a19e40-c4d9-703a-9480-93c3132f598a€9.00€0.19matched
47capture01a19e40-cc2d-7771-8820-4f2f8e2b2261€24.00€0.37matched
48capture01a19e40-ce7b-7bb6-af2e-9a6f20097143€35.00€0.50matched
49capture01a19e40-d73c-748b-9718-a18b4dd4689f€49.00€0.67matched
50capture01a19e40-eed1-787b-a03b-a7feed83c4f9€49.00€0.67matched
51capture01a19e41-082f-7c65-917f-38007b96bd08€49.00€0.67matched
52capture01a19e41-25a5-7341-b79a-e1e1986d6669€35.00€0.50matched
53capture01a19e41-44f3-701c-8cf9-c76c18c427e3€35.00€0.50matched
54capture01a19e41-4d2a-7e5b-a345-c7f002b3ff7a€24.00€0.37matched
55capture01a19e41-69a3-7d1d-a10e-e46662113465€49.00€0.67matched
56capture01a19e41-71f6-74de-80af-47188fa80db1€9.00€0.19matched
57capture01a19e41-83c0-751f-9d2f-20d641f565ad€49.00€0.67matched
58capture01a19e41-919d-71ac-81c1-502eddde3379€15.00€0.26matched
59capture01a19e41-a86f-7ce0-825c-e61be03a916c€24.00€0.37matched
60capture01a19e41-aa0c-7e90-b170-4293354a2421€24.00€0.37matched
61capture01a19e41-b6f5-7495-9af9-f28f17dceb5a€9.00€0.19matched
62capture01a19e41-c621-7de6-adfb-5129374b83c1€9.00€0.19matched
63capture01a19e41-d128-7c64-9f89-c03c0ef25ae3€49.00€0.67matched
64capture01a19e41-e863-70dd-92b3-22ac7da23c6f€15.00€0.26matched
65capture01a19e41-eb7d-7abf-81ba-c577be791ffa€49.00€0.67matched
67capture01a19e41-fe65-7829-a1a2-92760b207729€49.00€0.67matched
68capture01a19e42-0313-796a-b897-eb4309060d56€49.00€0.67matched
69capture01a19e42-03ba-7712-b86a-e0b1ec27c3b5€35.00€0.50matched
70capture01a19e42-04d6-73a0-9180-8374f72442e4€35.00€0.50matched
71capture01a19e42-149c-7879-9563-3e9960b7468b€35.00€0.50matched
72capture01a19e42-2168-717a-9166-82be9da5a8b9€49.00€0.67matched
73capture01a19e42-2dcc-74d2-86e3-15d9f5826693€9.00€0.19matched
74capture01a19e42-2e04-7dea-a907-b375a5599c62€9.00€0.19matched
75capture01a19e42-415e-7e41-9eba-21f44cfd56a7€15.00€0.26matched
76capture01a19e42-44b3-7a55-be8b-69ca67de4d80€35.00€0.50matched
77capture01a19e42-53d4-767f-b505-f7e56391f195€15.00€0.26matched
78refund01a19e42-5373-7955-9e3f-3122c1c18914-€14.00€0.00matched
79refund01a19e42-777b-7f7c-b360-fd25eb1ec906-€7.00€0.00matched
80refund01a19e42-851a-7d7a-98e7-be5558f572fe-€7.00€0.00matched
81capture01a19e42-94a6-7075-8ec4-6c2e01531beb€49.00€0.67matched
82capture01a19e42-a8bd-7333-bcb0-e009e6f7d8d2€24.00€0.37matched
83capture01a19e42-c3b4-7d5f-99e9-f16114587d6a€15.00€0.26matched
85capture01a19e42-c8e4-7ff2-a360-262b49e8cc3a€15.00€0.26matched
86capture01a19e42-cbea-726e-bac2-3cbd86d23236€9.00€0.19matched
87capture01a19e42-d827-7f8b-bded-658c79efbad6€9.00€0.19matched
88capture01a19e42-db36-7ed4-9030-95029e8d3534€24.00€0.37matched
89capture01a19e42-e601-74de-9431-6b74e9a5ab75€15.00€0.26matched
90capture01a19e42-fd1c-7f4c-85b4-dc45171d9830€24.00€0.37matched
91capture01a19e43-1472-73c8-8614-ebe7a667ece5€15.00€0.26matched
92capture01a19e43-2254-7f64-a828-192a84a8eff0€9.00€0.19matched
93refund01a19e43-2a38-79c6-ab16-b596fbdc5da8-€7.00€0.00matched
94capture01a19e43-2e1d-7ca6-91d3-664bfcaabef5€9.00€0.19matched
95capture01a19e43-3d1f-7b65-b754-83d6da18d3b0€49.00€0.67matched
96refund01a19e43-40f6-7439-9d2c-95f7daf4c2c3-€13.00€0.00matched
98capture01a19e43-5ba1-7d1b-bae2-3b0b08b3f57e€24.00€0.37matched
99capture01a19e43-5ecc-74b7-b2b0-37c6ad735ebd€15.00€0.26matched
100capture01a19e43-628e-7903-a8af-13cfeacc093e€9.00€0.19matched
101capture01a19e43-90f7-78a3-b4a9-6843ff2fa479€9.00€0.19matched
102capture01a19e43-c67d-7bda-bdac-85176c7c0aca€15.00€0.26matched
103capture01a19e43-c6ac-7a64-b58a-68b9ffde4bec€9.00€0.19matched
104capture01a19e43-df96-7cb6-84c7-842240b4fcad€49.00€0.67matched
105capture01a19e43-fd27-7667-a6c7-a3bfee37ddd7€49.00€0.67matched
106refund01a19e43-ffc5-7eae-8b8f-f7b7b7fc589d-€12.00€0.00matched
107capture01a19e44-0411-7352-84ef-13a3e94d5865€15.00€0.26matched
108capture01a19e44-1596-7d1b-861c-8d2b28a903c1€15.00€0.26matched
109capture01a19e44-23a2-7f78-a28e-3413587af7c7€9.00€0.19matched
110capture01a19e44-3e6f-71dc-b8f1-4f71a9aebc68€9.00€0.19matched
111capture01a19e44-40b1-78cc-970f-e999f344f181€49.00€0.67matched
112capture01a19e44-490f-74e1-a2ec-480ae6dc39ee€24.00€0.37matched
113capture01a19e44-4bd7-76a5-9624-5c19dec4dfcf€15.00€0.26matched
114refund01a19e44-4cd8-7289-81c9-b1d82c61a5c4-€25.00€0.00matched
115refund01a19e44-8a53-7e39-83f9-b7bad48effd1-€23.00€0.00matched
116refund01a19e44-9351-7ca7-8a43-d48026f4ac5b-€6.00€0.00matched
117capture01a19e44-c8fb-750e-a2aa-ac46adb30c86€24.00€0.37matched
118capture01a19e44-ccca-7a2c-9562-f1fb62731b72€9.00€0.19matched
119capture01a19e44-d399-723e-9f4e-f1964ff667fe€15.00€0.26matched
120capture01a19e44-d9b5-7373-a705-4744ab3e016e€15.00€0.26matched
121capture01a19e45-27f2-7f29-a70f-948b8b8ddb65€24.00€0.37matched
122capture01a19e45-2f3b-744a-b1d7-30e2cb97157b€24.00€0.37matched
123refund01a19e45-345d-7e56-832e-4a15076772a3-€7.00€0.00matched
124capture01a19e45-49f4-7306-aebf-145f522c5e42€24.00€0.37matched
125capture01a19e45-50cc-7aac-95a2-02b00bee54b9€9.00€0.19matched
126capture01a19e45-5d68-76ca-a11f-710cc2008e2e€24.00€0.37matched
127capture01a19e45-5e76-7fb1-8613-568f381b792c€9.00€0.19matched
128capture01a19e45-9077-71aa-99ea-c570e94e3475€24.00€0.37matched
129capture01a19e45-9b8e-7f5f-8097-0151643b454b€9.00€0.19matched
130capture01a19e45-accb-7c7e-b763-109daa2391ff€35.00€0.50matched
131capture01a19e45-c7db-7a6a-bf77-a5ae3dc02280€15.00€0.26matched
132capture01a19e45-cdaa-78d6-b66d-8008adf665b0€49.00€0.67matched
133capture01a19e45-ce6c-7511-b8ab-6ce8a1e03482€15.00€0.26matched
134capture01a19e45-ed13-7a73-9e03-5b90d76437e6€24.00€0.37matched
135capture01a19e46-222c-7557-a203-f4b68890a1e6€9.00€0.19matched
136capture01a19e46-32d4-70c1-9eaf-8937824520f9€9.00€0.19matched
137capture01a19e46-383b-7abc-af72-32624baeb97d€35.00€0.50matched
138capture01a19e46-42e1-72c0-9681-c2d5d7b1db1b€49.00€0.67matched
139capture01a19e46-4a5f-71e0-90a9-2efa7847576b€49.00€0.67matched
141capture01a19e46-65c9-7462-9385-c09b366eaddd€9.00€0.19matched
142capture01a19e46-a810-7657-897d-f21ec5efc06a€35.00€0.50matched
143capture01a19e46-c2b2-7023-a966-f6c9b920b592€35.00€0.50matched