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, 16:40

Gross

€3,054.00

PSP fee

€46.97

Net to the bank

€3,007.03

Settlement journal

#400841

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ac9a-36c0-710e-be0d-111655bda34d is already settled by stl_EUR_2989828 line 79
  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
LineKindReferenceGrossFeeStatus
80capture01a1ac9a-36f8-779d-b2e5-e0fcff7662ee€24.00€0.37duplicate line
123capture01a1ac9d-c94c-7e58-9923-320920a1701d€24.00€0.39fee difference
1capture01a1ac8e-72f6-745e-a885-1efe1a1b0686€15.00€0.26matched
2capture01a1ac92-f3bf-7f92-b34a-118228e61174€24.00€0.37matched
3capture01a1ac94-b1cc-747d-8cf3-deb9f9740ab4€9.00€0.19matched
4capture01a1ac94-eae1-7635-87bc-949a060dccc8€15.00€0.26matched
5capture01a1ac94-f222-778a-80d9-57a50f08320a€35.00€0.50matched
6capture01a1ac95-12be-78fc-a822-2677654888f9€49.00€0.67matched
7capture01a1ac95-1330-750d-bd92-72dc88706df5€24.00€0.37matched
8refund01a1ac95-54bd-758c-9994-bf49a16fed6b-€9.00€0.00matched
9capture01a1ac95-7019-7ec9-a019-95d34dba4e24€24.00€0.37matched
10capture01a1ac95-7a8c-7f30-9658-662b6ec01627€24.00€0.37matched
11capture01a1ac95-8933-70c1-bf35-af80b92fe6d3€24.00€0.37matched
12capture01a1ac95-b4c5-7ccb-ab41-5b1949cae88f€9.00€0.19matched
13capture01a1ac95-b976-707c-b8e2-4a0a3ecf0f39€24.00€0.37matched
14capture01a1ac95-c722-7750-8d85-69ef2158bd29€9.00€0.19matched
15capture01a1ac95-dade-7bf5-88fa-9d42528dcba1€49.00€0.67matched
16capture01a1ac95-f22a-7444-ae3d-8cb93d86a0a9€49.00€0.67matched
17capture01a1ac96-038e-774b-ac2a-624d78194abb€49.00€0.67matched
18capture01a1ac96-2b3a-7198-8dcb-1babe9fc5371€35.00€0.50matched
19capture01a1ac96-6212-73cb-9273-58290a879d21€9.00€0.19matched
20capture01a1ac96-7580-7bed-bc04-1b0639183a56€24.00€0.37matched
21capture01a1ac96-7b6e-76de-b2d7-593ff6a7df2d€35.00€0.50matched
22refund01a1ac96-9186-7773-8a69-0d307b4fb4d0-€23.00€0.00matched
23capture01a1ac96-a829-7e88-b097-7681cf0b308b€49.00€0.67matched
24capture01a1ac96-b659-7195-8eb2-6d48ea78c314€35.00€0.50matched
25capture01a1ac97-15cb-7ec8-b824-f2886aea0f5a€35.00€0.50matched
26capture01a1ac97-1f78-7652-a673-68011b0dcdc3€24.00€0.37matched
27capture01a1ac97-3210-736d-93da-464d199c8fe3€49.00€0.67matched
28capture01a1ac97-326f-74ee-917e-9c209adaad78€35.00€0.50matched
29capture01a1ac97-3c7b-71c4-8c61-285e283b1536€15.00€0.26matched
30capture01a1ac97-4245-7fe7-918e-443973881c5a€15.00€0.26matched
31capture01a1ac97-43f2-70c5-839a-9c29cab817b4€35.00€0.50matched
32capture01a1ac97-507a-785f-bae3-7596b09be88e€24.00€0.37matched
33capture01a1ac97-7214-7be1-9640-f4f158b2aea4€15.00€0.26matched
34capture01a1ac97-779a-7636-a5e9-064d40b6b5a6€15.00€0.26matched
35capture01a1ac97-7d85-7c89-acf3-e20c8fa20654€35.00€0.50matched
36capture01a1ac97-952f-705e-bf54-de7242894e79€15.00€0.26matched
37capture01a1ac97-a160-70c2-9690-b8604097c9e3€9.00€0.19matched
38capture01a1ac97-aeca-7115-8db9-a4200fed655f€9.00€0.19matched
39capture01a1ac97-d101-7eb7-87ad-79e173a07a76€49.00€0.67matched
40capture01a1ac97-d721-754c-aa75-322a2497a636€9.00€0.19matched
41capture01a1ac97-ea0c-7ffb-a395-36e7bb3f84cd€24.00€0.37matched
42capture01a1ac97-f7b1-7659-a9ef-b08d2af17d21€35.00€0.50matched
43capture01a1ac98-12ce-756a-adf0-036e20b55108€49.00€0.67matched
44capture01a1ac98-1f2a-79ff-b52f-c65ea7dea351€49.00€0.67matched
45capture01a1ac98-390a-717b-9955-78398d38a008€15.00€0.26matched
46capture01a1ac98-3d7d-783e-93da-bd7b7dedcdb9€24.00€0.37matched
47capture01a1ac98-40a7-740a-811c-7fcaead06761€24.00€0.37matched
48capture01a1ac98-4a7c-7809-9e8c-4b3f17a2e304€15.00€0.26matched
49capture01a1ac98-56f5-7a78-b650-5417a18796eb€15.00€0.26matched
50capture01a1ac98-5c54-7d1e-bcc2-ff12148a75a2€24.00€0.37matched
51capture01a1ac98-674a-76aa-b5ad-c33af385b738€15.00€0.26matched
52capture01a1ac98-69bc-7790-a05c-d361e0e2042c€15.00€0.26matched
53capture01a1ac98-73a1-74ac-a4dd-824ead5d83e3€24.00€0.37matched
54capture01a1ac98-7888-7d24-8e86-45b8c1e473f7€15.00€0.26matched
55capture01a1ac98-7e7a-7dc8-b9f0-cbfe93655b4c€49.00€0.67matched
56capture01a1ac98-ae86-7675-8fdb-5b81d7c7740b€35.00€0.50matched
57capture01a1ac98-b082-7332-8cb3-f2d241f7ea56€49.00€0.67matched
58capture01a1ac98-b9e4-7251-829c-97c4a1245b7e€9.00€0.19matched
59capture01a1ac98-bd2c-7841-9b52-871dabf3a293€15.00€0.26matched
60capture01a1ac98-e609-7777-8468-08a407ac872d€49.00€0.67matched
61capture01a1ac98-f9e6-7b61-8587-3b3d85439272€24.00€0.37matched
62capture01a1ac99-080a-718d-9bf4-c804df348a1d€15.00€0.26matched
63capture01a1ac99-3bda-76d2-a6be-508dfb0f9260€15.00€0.26matched
64capture01a1ac99-3d46-77d7-a784-3b07aa792336€49.00€0.67matched
65capture01a1ac99-3e0c-7e6f-b150-6011fde76640€24.00€0.37matched
66capture01a1ac99-5a18-7cbc-9626-68c57df226c4€9.00€0.19matched
67capture01a1ac99-698d-7982-8640-77ae5b8cc950€24.00€0.37matched
68capture01a1ac99-73e0-79b7-856a-d3b4a4a43109€9.00€0.19matched
69capture01a1ac99-81d4-78a8-8870-ab88a5d2e662€35.00€0.50matched
70capture01a1ac99-84ac-7e84-9d82-207caa213c34€49.00€0.67matched
71capture01a1ac99-8a70-72d1-9305-11e685362e46€49.00€0.67matched
72capture01a1ac99-a014-7018-9791-c4759d07a1ce€24.00€0.37matched
73capture01a1ac99-a935-74c9-86ed-b90604fa19ee€49.00€0.67matched
74capture01a1ac99-c511-70c5-a2c7-30f793f29d33€49.00€0.67matched
75capture01a1ac99-cd1c-7ca3-a94a-e16881992f97€35.00€0.50matched
76capture01a1ac9a-0b6e-7ef1-9d2b-9f1cccb5c3fe€24.00€0.37matched
77capture01a1ac9a-210a-77f8-82cb-dac8a0a1c59c€15.00€0.26matched
78capture01a1ac9a-289a-77b9-9410-2ea68eabb204€35.00€0.50matched
79capture01a1ac9a-36f8-779d-b2e5-e0fcff7662ee€24.00€0.37matched
81capture01a1ac9a-3ed6-7b96-91a9-4cfd78408e81€15.00€0.26matched
82capture01a1ac9a-4b0b-702a-8c36-71a6905bc3a5€49.00€0.67matched
83capture01a1ac9a-4a39-78b2-84ad-db4a4e099bde€15.00€0.26matched
84capture01a1ac9a-4f42-7847-9751-02bc56dca211€24.00€0.37matched
85capture01a1ac9a-899c-7de2-8470-c1cbb712d8ba€35.00€0.50matched
86capture01a1ac9a-8d81-7e5a-855d-a552c1e35dbf€15.00€0.26matched
87capture01a1ac9a-a2e3-7de7-97a5-e1af08ab7f4f€9.00€0.19matched
88refund01a1ac9a-b150-7785-9282-5eb99ba71555-€9.00€0.00matched
89capture01a1ac9a-ba69-78c5-b4e7-e74a689edcbf€15.00€0.26matched
90capture01a1ac9a-d4a8-78e3-a017-7aee9a0da942€24.00€0.37matched
91capture01a1ac9a-f1e2-76d6-9a36-38980f00743b€9.00€0.19matched
92capture01a1ac9a-fbed-78b3-88a6-02b1e4ef0492€35.00€0.50matched
93capture01a1ac9b-4585-7c9e-a3fd-c461fb7ff697€9.00€0.19matched
94capture01a1ac9b-58a7-72c1-a930-ceb49995ee31€24.00€0.37matched
95capture01a1ac9b-5c82-74da-9ed4-ff53f95228fc€15.00€0.26matched
96capture01a1ac9b-724f-7bd9-b610-565a24d848f9€9.00€0.19matched
97refund01a1ac9b-7846-75e0-b1e7-d1b576c142f5-€5.00€0.00matched
98capture01a1ac9b-b98e-7d6c-9472-6aec0916cd20€9.00€0.19matched
99capture01a1ac9c-31c7-7f18-a6e3-9e717a8cc4d0€15.00€0.26matched
100capture01a1ac9c-31a8-7f94-8a5f-94aba990234b€24.00€0.37matched
101capture01a1ac9c-37ac-79cd-961a-b9a502adbcaf€24.00€0.37matched
102capture01a1ac9c-431e-78b0-87d3-8ece0da6ab51€9.00€0.19matched
103capture01a1ac9c-64fe-7c79-94fe-6bf756de9000€49.00€0.67matched
104capture01a1ac9c-6fba-7371-9836-b7a337d800ce€49.00€0.67matched
105capture01a1ac9c-a39c-7ef1-881f-fcd67cf722bd€9.00€0.19matched
106capture01a1ac9c-c810-77ea-8f3a-90193746bb5d€9.00€0.19matched
107capture01a1ac9c-dad9-719d-a07e-ece02f9a2106€49.00€0.67matched
108capture01a1ac9c-e5c1-7244-8c5c-8d1c3a639720€15.00€0.26matched
109capture01a1ac9c-fc60-71e0-ba15-988f2637dcc9€9.00€0.19matched
110capture01a1ac9d-01b2-7be5-a587-804d046a05e6€24.00€0.37matched
111capture01a1ac9d-18f2-725f-a9ab-80bd3258b405€15.00€0.26matched
112capture01a1ac9d-1b81-7cf5-9d00-2b334684593e€49.00€0.67matched
113capture01a1ac9d-2766-743a-91c1-8630ff9da7ab€15.00€0.26matched
114capture01a1ac9d-27d3-78e2-a3f4-0e855d78630e€35.00€0.50matched
115capture01a1ac9d-2a83-7fa4-a91c-0de7674262d3€35.00€0.50matched
116capture01a1ac9d-2b74-7509-8c2a-eafb73cf612e€24.00€0.37matched
117capture01a1ac9d-5260-79dc-affe-bddb2202352a€49.00€0.67matched
118capture01a1ac9d-5b76-720b-b646-e1bb5911be09€49.00€0.67matched
119capture01a1ac9d-770b-7694-b551-47e435c6547e€9.00€0.19matched
120capture01a1ac9d-afc6-733a-9242-4aa0356755a6€24.00€0.37matched
121capture01a1ac9d-b58f-7317-91b7-27617a40f083€15.00€0.26matched
122capture01a1ac9d-bde5-772b-b794-fd1caede43db€15.00€0.26matched
124capture01a1ac9e-025e-7661-976e-a0109895acf4€9.00€0.19matched