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

Gross

€3,295.00

PSP fee

€51.38

Net to the bank

€3,243.62

Settlement journal

#393931

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aaab-1c5d-7519-a2dd-fbfd24a095c2 is already settled by stl_EUR_2989774 line 70
  • duplicate linethe file lists it twicecapture:01a1aaab-5316-77f9-95c2-350121dee2dd is already settled by stl_EUR_2989774 line 74
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
LineKindReferenceGrossFeeStatus
71capture01a1aaab-1ccf-718b-8175-63d1cbf340ae€9.00€0.19duplicate line
75capture01a1aaab-5352-7868-a61d-9db04c329fbe€9.00€0.19duplicate line
113capture01a1aaae-54d3-7e7d-95ba-7c4d1163b65c€15.00€0.29fee difference
1capture01a1aa9e-3636-7e11-b4ac-5b24af1ee456€49.00€0.67matched
2capture01a1aa9f-53bd-73a2-88bc-2c9436931e9c€9.00€0.19matched
3capture01a1aaa0-68e1-78a7-ad99-b9816e03975d€15.00€0.26matched
4capture01a1aaa6-7e4a-7f91-9b5a-a9cadec97fea€49.00€0.67matched
5capture01a1aaa6-8524-7d2e-af31-58f0a6271581€35.00€0.50matched
6capture01a1aaa6-890e-7f2a-b72d-2c065e04e52c€24.00€0.37matched
7capture01a1aaa6-9aff-7151-b960-f75e67947a59€15.00€0.26matched
8capture01a1aaa6-a8d1-7145-a3be-63dc4215f8a2€15.00€0.26matched
9capture01a1aaa6-a92e-7ac0-ad36-322207a41edc€9.00€0.19matched
10refund01a1aaa6-bac8-7381-954c-fa16587582c4-€10.00€0.00matched
11refund01a1aaa6-c840-77b7-8255-1f43625da309-€4.00€0.00matched
12capture01a1aaa6-cba6-70b8-b5e3-cacf5065c994€9.00€0.19matched
13capture01a1aaa6-d208-741a-b1af-e5deccd7c84f€24.00€0.37matched
14capture01a1aaa6-d626-7d7b-bfb2-cd4674b395af€49.00€0.67matched
15capture01a1aaa7-0399-7159-a3b6-7749c2212e59€24.00€0.37matched
16capture01a1aaa7-1fe7-77fe-913c-a2e39063b711€15.00€0.26matched
17capture01a1aaa7-2389-7f90-bcdc-c3aa1edbc9c7€49.00€0.67matched
18capture01a1aaa7-3c55-71bc-b0ca-0cdd68e7cceb€9.00€0.19matched
19refund01a1aaa7-43e0-71bd-b161-6709e0514067-€21.00€0.00matched
20capture01a1aaa7-658d-7a6f-94a1-3da009eee047€9.00€0.19matched
21capture01a1aaa7-6ca3-754a-bc47-c2e11fa8c3d3€35.00€0.50matched
22capture01a1aaa7-860c-75fb-8c78-789596722e60€35.00€0.50matched
23refund01a1aaa7-a1c6-73a7-974b-3079526c3a78-€3.00€0.00matched
24capture01a1aaa7-aa1d-74e9-afef-4d0db6b72742€35.00€0.50matched
25capture01a1aaa7-c2b1-7dea-9b78-3ca686b76064€35.00€0.50matched
26capture01a1aaa7-ce10-73d6-9fe6-1709014201e2€24.00€0.37matched
27capture01a1aaa7-ff46-7d08-89ff-bc87cdd735d5€9.00€0.19matched
28capture01a1aaa8-0540-7a72-bb4a-b6220309eaa2€15.00€0.26matched
29capture01a1aaa8-154b-772f-a0a2-7b1578f06e02€15.00€0.26matched
30capture01a1aaa8-1630-7e1c-a5d1-d0cdb5c353f7€35.00€0.50matched
31capture01a1aaa8-232b-7b72-bb7b-202d95edf767€49.00€0.67matched
32capture01a1aaa8-3033-71bc-a43c-ba477c8dfc09€35.00€0.50matched
33capture01a1aaa8-65bd-7ed8-a0ec-287c14baa55c€49.00€0.67matched
34capture01a1aaa8-75e6-7768-88f4-d774574e57a2€24.00€0.37matched
35capture01a1aaa8-7f19-7f74-8d25-4f0ae7e4eede€24.00€0.37matched
36capture01a1aaa8-ab05-7dff-9eb2-3a668e3de080€49.00€0.67matched
37capture01a1aaa8-b1b3-7719-a83b-b6c8007b2e12€35.00€0.50matched
38capture01a1aaa8-b81e-77d8-be4b-f7639b61fefa€35.00€0.50matched
39refund01a1aaa8-ba43-7684-8ce0-f10394c211ab-€24.00€0.00matched
40capture01a1aaa8-d614-7e39-a195-e92ff694c532€35.00€0.50matched
41capture01a1aaa8-e0b8-7fe5-9fb7-2df00f7fa28c€15.00€0.26matched
42capture01a1aaa8-e57c-7fa4-9db8-d6a068fc146f€24.00€0.37matched
43capture01a1aaa9-0999-758e-83bd-c7585b0cac27€9.00€0.19matched
44capture01a1aaa9-1122-7aa9-9602-b7bad764c4df€35.00€0.50matched
45capture01a1aaa9-1f78-71a6-abb3-724f2bb22500€35.00€0.50matched
46capture01a1aaa9-2534-78d9-9dcd-0b0d2d585996€24.00€0.37matched
47capture01a1aaa9-2937-71cd-95de-99ee1fe7767a€9.00€0.19matched
48capture01a1aaa9-4897-7783-ab37-ed7c81e6316b€9.00€0.19matched
49capture01a1aaa9-6063-7fd1-bd06-e011a57cc3b3€35.00€0.50matched
50capture01a1aaa9-8cf2-7ca4-b7a8-3d4dbc05326c€35.00€0.50matched
51capture01a1aaa9-948e-79fe-9c30-8a2688e15b79€35.00€0.50matched
52capture01a1aaa9-b442-7f49-955c-552c3c83830a€35.00€0.50matched
53capture01a1aaa9-c26d-7d36-9b75-376af5511f8c€24.00€0.37matched
54capture01a1aaa9-c2aa-7d2c-989b-b6d6a72b7607€15.00€0.26matched
55capture01a1aaa9-cd89-7d7f-88a3-a234fbfd0e99€35.00€0.50matched
56capture01a1aaa9-ceba-7a47-b092-be3cabc0c7b2€15.00€0.26matched
57capture01a1aaa9-e136-71cd-afcb-b3d64f42733d€24.00€0.37matched
58capture01a1aaa9-f359-79d6-9b07-21121332b628€24.00€0.37matched
59capture01a1aaaa-0053-76df-aae6-601a42bbe2ea€49.00€0.67matched
60capture01a1aaaa-6c92-74fb-a462-6efc85b43524€49.00€0.67matched
61capture01a1aaaa-7294-78e1-8ff9-b57fe93b3036€35.00€0.50matched
62capture01a1aaaa-91cb-7345-b41d-efefa51b699c€35.00€0.50matched
63capture01a1aaaa-ab9f-7a78-b0a6-cafa5777aead€49.00€0.67matched
64capture01a1aaaa-c2a8-7c9d-9d3d-fb5edc685f1e€24.00€0.37matched
65capture01a1aaaa-d440-702e-8c2f-4d4dd300c8fe€24.00€0.37matched
66capture01a1aaaa-db15-767a-aa15-2dd4ca075aff€9.00€0.19matched
67capture01a1aaaa-e03c-7aa8-aa06-7c30209d2f0e€35.00€0.50matched
68capture01a1aaaa-e923-73dd-bedf-a47fd2a51c11€9.00€0.19matched
69capture01a1aaaa-f225-70c3-986e-6ec4c651c396€49.00€0.67matched
70capture01a1aaab-1ccf-718b-8175-63d1cbf340ae€9.00€0.19matched
72capture01a1aaab-391f-71dc-a3e8-ee2d772b1bff€15.00€0.26matched
73capture01a1aaab-4eef-7476-a059-cba8f9e5b5b1€24.00€0.37matched
74capture01a1aaab-5352-7868-a61d-9db04c329fbe€9.00€0.19matched
76capture01a1aaab-97a1-76aa-a756-a2a120fcdaf8€49.00€0.67matched
77capture01a1aaab-9da1-7327-8c47-d3dbd59b29ab€49.00€0.67matched
78capture01a1aaab-a917-71e0-9f2d-1a82810d10a8€49.00€0.67matched
79capture01a1aaab-a923-7c59-adb9-506b6f998972€15.00€0.26matched
80capture01a1aaab-c956-70dd-8ba2-0942b247b450€24.00€0.37matched
81capture01a1aaab-d405-7df9-b5ae-0da87ba6a4a9€35.00€0.50matched
82capture01a1aaab-eb17-747a-a600-23fdbccc9028€49.00€0.67matched
83capture01a1aaab-facb-7e3e-a6ad-4f52d8ad0918€9.00€0.19matched
84capture01a1aaab-fc6b-7dc6-b937-da24a742e86e€24.00€0.37matched
85capture01a1aaac-24b0-74f5-ac8e-952b40020890€15.00€0.26matched
86capture01a1aaac-2552-7867-beb2-fae8f5ab5760€49.00€0.67matched
87capture01a1aaac-3068-7754-acc7-6b989664d29d€15.00€0.26matched
88capture01a1aaac-48f6-78c2-9c8c-9abb49722335€24.00€0.37matched
89capture01a1aaac-9317-7ff2-b740-1030f4caf995€9.00€0.19matched
90refund01a1aaac-9368-753e-ab1f-c6f3d5eb96d0-€10.00€0.00matched
91capture01a1aaac-9e08-76f0-9df0-3e367a1ecca4€24.00€0.37matched
92capture01a1aaac-c1f9-7601-a788-323ad1151b60€15.00€0.26matched
93capture01a1aaac-cb86-768f-b23f-0bdf8ed0b26d€49.00€0.67matched
94capture01a1aaac-d445-7205-8991-e812485ac7a9€49.00€0.67matched
95capture01a1aaac-dc57-7e4f-bed1-995abf1e751a€15.00€0.26matched
96capture01a1aaac-e6dd-76cc-8093-a60b8233dc2f€49.00€0.67matched
97capture01a1aaad-0eb4-7db3-8708-f8bac019df94€35.00€0.50matched
98capture01a1aaad-17df-708b-8641-8d48633132f1€24.00€0.37matched
99refund01a1aaad-24ec-700e-9797-21e12a99da0c-€8.00€0.00matched
100refund01a1aaad-300f-747a-a30f-b63c972bd6e5-€6.00€0.00matched
101capture01a1aaad-39fe-71b1-9b1b-bab64a2a19e4€24.00€0.37matched
102capture01a1aaad-5f8e-7e28-92b2-d02d1d617e2f€49.00€0.67matched
103capture01a1aaad-7d26-79b7-a9f0-ae58245981c4€49.00€0.67matched
104capture01a1aaad-ce08-7697-83c5-bf9359f89f77€15.00€0.26matched
105capture01a1aaad-d0cc-76f9-b845-cc03458112d2€49.00€0.67matched
106capture01a1aaad-e208-75bc-80b2-40b6464443f8€24.00€0.37matched
107capture01a1aaad-e4d2-76d0-b040-2e4dbd0d0867€49.00€0.67matched
108capture01a1aaad-f051-774d-9edf-39a4f0dc4cd2€9.00€0.19matched
109capture01a1aaad-f3f9-728c-be0b-42a5595bdfab€15.00€0.26matched
110capture01a1aaae-12f6-7318-bdf6-b9130623e883€15.00€0.26matched
111capture01a1aaae-312b-781c-9cf3-e3b934d46462€24.00€0.37matched
112capture01a1aaae-51b8-7c1c-b6de-90db7b1b8b7e€35.00€0.50matched
114capture01a1aaae-5f17-7713-aa24-3dc53ea391aa€15.00€0.26matched
115capture01a1aaae-625f-7256-9044-0b10def7c9fd€24.00€0.37matched
116capture01a1aaae-6a68-7aac-9cf8-7662cac99440€49.00€0.67matched
117capture01a1aaae-6d6d-79c2-802d-65c461a33593€9.00€0.19matched
118capture01a1aaae-9129-7fa7-961e-e594fdfb53ba€24.00€0.37matched
119capture01a1aaae-a351-770f-b6f8-dc83407e4129€15.00€0.26matched
120capture01a1aaae-a377-7e97-8a59-b4dd67c79516€9.00€0.19matched
121refund01a1aaae-a7b2-70c9-913b-4183c2b306f6-€24.00€0.00matched
122capture01a1aaae-ad2e-72eb-8b4a-7c3e95bdbeb9€15.00€0.26matched
123capture01a1aaae-b378-71d1-a771-536e9c474d7d€15.00€0.26matched
124capture01a1aaae-b48a-7645-aae2-489959a1b89d€15.00€0.26matched
125capture01a1aaae-bdef-7e38-a015-501758c3acb5€49.00€0.67matched
126capture01a1aaae-c70a-7b3a-9322-175f09379901€35.00€0.50matched
127capture01a1aaae-c8fd-77e1-85ce-03573e451e33€24.00€0.37matched
128capture01a1aaae-e820-708e-9062-113749342e56€24.00€0.37matched
129capture01a1aaaf-02c9-7449-9e0d-06f914c1c3b4€15.00€0.26matched
130refund01a1aaaf-07c9-7650-baf9-fab0798d6b0b-€15.00€0.00matched
131capture01a1aaaf-1d3d-7cfa-8841-c512e5d86270€49.00€0.67matched
132capture01a1aaaf-3731-748d-b594-2983d1961a05€9.00€0.19matched
133capture01a1aaaf-4da6-7820-a9db-8efbaf251675€24.00€0.37matched
134capture01a1aaaf-53a8-787e-9ffc-72c68ff0a5cc€35.00€0.50matched
135capture01a1aaaf-637e-72e4-9a83-54aabb973c1a€15.00€0.26matched
136capture01a1aaaf-9761-7f64-ab7a-ce0b06c6f942€35.00€0.50matched
137capture01a1aaaf-9fbb-7717-872d-eb2c2d9a59da€9.00€0.19matched