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

4 Nov, 17:10

Gross

€2,858.00

PSP fee

€45.56

Net to the bank

€2,812.44

Settlement journal

#382899

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
  • missing linein the books, not in the filecapture:01a1a793-07d2-7f99-85d1-a726bbd9422e is in no file
LineKindReferenceGrossFeeStatus
103capture01a1a791-8e60-71c8-b143-278196bd906f€49.00€0.71fee difference
1capture01a1a781-5ed6-7fb4-b795-33bbf0be618b€35.00€0.50matched
2capture01a1a783-c8a4-76a6-b31d-e2844fe65c53€24.00€0.37matched
3capture01a1a78a-7a46-716f-919d-4b2f17916c67€24.00€0.37matched
4capture01a1a78a-86f2-7f21-8fd9-ed879335f9ff€24.00€0.37matched
5capture01a1a78a-89f9-74f1-b22c-6fb7a17956fd€24.00€0.37matched
6capture01a1a78a-973e-7d07-b227-739faa39144a€15.00€0.26matched
7capture01a1a78a-a084-7924-9bed-dde90b7c6870€35.00€0.50matched
8capture01a1a78a-a369-70d0-a470-64008061c48d€24.00€0.37matched
9capture01a1a78a-cc69-72a0-84eb-2599f5cdd405€15.00€0.26matched
10capture01a1a78a-cf40-77e6-bb71-22bec88d09c0€49.00€0.67matched
11capture01a1a78a-f8ac-75b1-a450-dce7929c59e7€9.00€0.19matched
12capture01a1a78b-043d-7bf4-9777-98261a53eb67€35.00€0.50matched
13capture01a1a78b-05db-7964-8b17-93332c2fa0a6€24.00€0.37matched
14refund01a1a78b-3481-78ed-bb62-77b109bbfc93-€4.00€0.00matched
15capture01a1a78b-391e-7d6f-b590-46ef03b4c7be€9.00€0.19matched
16capture01a1a78b-39c3-7c0d-9aa5-2a690022c8fc€15.00€0.26matched
17capture01a1a78b-3a62-72fd-ab1f-6c84e976e2bf€35.00€0.50matched
18capture01a1a78b-64c0-732b-b6e6-71d92bd8470e€49.00€0.67matched
19capture01a1a78b-89d4-71c9-afff-2aeced6f2e1f€24.00€0.37matched
20capture01a1a78b-8b12-755f-a7a5-b95719f0c340€9.00€0.19matched
21capture01a1a78b-a686-72c4-bbcd-abe3cda4759e€9.00€0.19matched
22refund01a1a78b-b671-7a21-86e4-7dd3656da80e-€9.00€0.00matched
23capture01a1a78b-be18-790e-b129-b85380020ac5€49.00€0.67matched
24capture01a1a78b-c4fd-7cd2-a373-f0b90808b7d1€35.00€0.50matched
25capture01a1a78b-c88a-776b-aa26-f0c213cb0cee€24.00€0.37matched
26capture01a1a78b-ef32-7275-8eac-32186b710e91€35.00€0.50matched
27capture01a1a78b-f953-7069-be5d-6ad6a7f7781c€49.00€0.67matched
28capture01a1a78c-071a-7d33-926a-40475cc9f2f7€24.00€0.37matched
29capture01a1a78c-40e7-7fef-b883-38c2ebe76397€15.00€0.26matched
30capture01a1a78c-41ae-75c9-9740-1ffcb8392f81€35.00€0.50matched
31capture01a1a78c-49c4-782e-ba5e-9807a0f1c67c€24.00€0.37matched
32capture01a1a78c-52b5-7479-a7c0-a5e7f9f58602€49.00€0.67matched
33capture01a1a78c-5e2c-7f6f-80e0-135dd4336162€15.00€0.26matched
34capture01a1a78c-69b9-7dff-9a34-14ffcdb1bddc€35.00€0.50matched
35capture01a1a78c-6e48-720a-918b-807d734f290a€35.00€0.50matched
36capture01a1a78c-b0d0-7e8e-a4ea-f8e8cb3e5075€9.00€0.19matched
37capture01a1a78c-d2db-70d2-a5e0-9d9b0eafdeca€24.00€0.37matched
38capture01a1a78c-d906-7df0-a824-5fd929f7fc85€9.00€0.19matched
39capture01a1a78c-dde6-71a5-9dd9-6175a8b6c1d5€9.00€0.19matched
40capture01a1a78c-e5a3-7358-9432-e9e1d3093ea3€9.00€0.19matched
41capture01a1a78d-0fb5-7536-ad82-3433b6d2f2d1€49.00€0.67matched
42capture01a1a78d-2e92-7e07-8677-02293ef9876a€9.00€0.19matched
43capture01a1a78d-2f52-79ff-ab28-2de0e791f8c1€49.00€0.67matched
44capture01a1a78d-4b30-7434-8a50-a1c2729c7d34€9.00€0.19matched
45capture01a1a78d-5175-725b-a354-776801214583€15.00€0.26matched
46refund01a1a78d-5efa-7138-9b33-839ff295b700-€18.00€0.00matched
47capture01a1a78d-65e7-7206-8a70-2c5ba2ac6c95€9.00€0.19matched
48capture01a1a78d-71b2-7d17-90fa-1fef716e6ccf€15.00€0.26matched
49capture01a1a78d-a6ac-7ff5-8a5b-60cb23e8b452€15.00€0.26matched
50capture01a1a78d-b894-739c-967c-75b34ea4e0b5€9.00€0.19matched
51capture01a1a78d-d057-7166-ba1e-4cd6f82abcef€49.00€0.67matched
52refund01a1a78d-d670-76ae-a641-9dd0c48078a3-€8.00€0.00matched
53capture01a1a78e-452d-7cc3-9f97-bd22ccc1f66f€15.00€0.26matched
54capture01a1a78e-4fde-74f5-9bef-c029e8752f98€35.00€0.50matched
55capture01a1a78e-6ef9-78d8-adce-a8808236d6fb€15.00€0.26matched
56capture01a1a78e-811d-7340-972b-84154a0008fd€35.00€0.50matched
57capture01a1a78e-88ca-7ab9-9e8e-a95d5344f604€49.00€0.67matched
58capture01a1a78e-9b6b-7bb7-91eb-317c16cee121€24.00€0.37matched
59capture01a1a78e-b713-7986-a50f-b2dfef76a705€35.00€0.50matched
60capture01a1a78e-c8f0-7500-85a4-12ae74d7fa15€15.00€0.26matched
61refund01a1a78e-e0e3-78a5-bd9e-c8c4174c956f-€10.00€0.00matched
62capture01a1a78e-f3ce-7d35-9c57-eb7de60b06c1€24.00€0.37matched
63capture01a1a78f-084c-78ab-a57a-62ad40ff9a77€9.00€0.19matched
64capture01a1a78f-10f9-7dec-9028-15bfd8e7c7e1€49.00€0.67matched
65capture01a1a78f-11dc-74f9-bb38-b745fcf3d276€35.00€0.50matched
66capture01a1a78f-2577-746f-9ec5-ba33947b99c5€15.00€0.26matched
67capture01a1a78f-3a83-74bb-aa9f-fc6131d3b342€49.00€0.67matched
68capture01a1a78f-5023-78e5-89ef-1b210c653115€9.00€0.19matched
69capture01a1a78f-58c4-78a9-8555-9094ff599985€49.00€0.67matched
70capture01a1a78f-69bf-7b81-b879-51ea7ad71f56€35.00€0.50matched
71capture01a1a78f-98e7-77c4-88f9-c849c5eca93b€35.00€0.50matched
72capture01a1a78f-af38-74bb-8ef0-26da77ca20b8€24.00€0.37matched
73capture01a1a78f-c35e-738b-ab2e-74d693372857€9.00€0.19matched
74refund01a1a78f-c5cc-7c30-950d-56913574a1cd-€27.00€0.00matched
75capture01a1a78f-dc4c-7293-aedd-c0c7f12d0ea5€9.00€0.19matched
76refund01a1a78f-f0e0-7e45-89a8-820be662f3e7-€8.00€0.00matched
77capture01a1a78f-fb77-7c40-b170-321bb14b0271€15.00€0.26matched
78capture01a1a790-09cf-78b1-815a-301e593e2a45€24.00€0.37matched
79capture01a1a790-8200-7b42-ac46-cc4876e2905e€35.00€0.50matched
80capture01a1a790-851f-7346-aab7-67faa14bd9cc€9.00€0.19matched
81capture01a1a790-9579-70a5-995e-14ab28762fe9€24.00€0.37matched
82capture01a1a790-a94c-7df0-b6e9-38280dadabaf€35.00€0.50matched
83capture01a1a790-bf8b-7fb5-b7c2-aeca13a98b73€35.00€0.50matched
84capture01a1a790-c81d-7c9c-8a7f-6d390d8ea179€35.00€0.50matched
85capture01a1a790-cf46-7909-a9c5-1d07bb1fe33f€35.00€0.50matched
86capture01a1a790-d754-7465-98c2-8d1b06762b67€15.00€0.26matched
87capture01a1a790-d761-7b84-864f-99aa51238a50€24.00€0.37matched
88capture01a1a790-d80a-7482-b634-75a9c5d33eb4€35.00€0.50matched
89capture01a1a790-df38-7714-878c-b6f008ae78e3€15.00€0.26matched
90capture01a1a790-e22d-780c-b193-0d6fa0638b0f€15.00€0.26matched
91refund01a1a791-114d-737c-b009-479cf0277338-€24.00€0.00matched
92capture01a1a791-17d9-7775-95be-61bf8a270819€9.00€0.19matched
93capture01a1a791-1d71-7d6a-aa7b-6b78f4f93dbd€15.00€0.26matched
94capture01a1a791-1ffe-7509-973f-85bd49df3464€49.00€0.67matched
95capture01a1a791-2687-75ca-b912-b3d3ae00d24d€35.00€0.50matched
96capture01a1a791-2753-712a-992d-69d68139433e€9.00€0.19matched
97refund01a1a791-356f-7a5f-a908-5b81057ac7ee-€14.00€0.00matched
98capture01a1a791-3e86-73ea-b9c5-9fe814109f95€15.00€0.26matched
99capture01a1a791-5b00-7e6c-a224-466f514cd71d€24.00€0.37matched
100capture01a1a791-68ab-7745-9e52-649ca42766f0€35.00€0.50matched
101capture01a1a791-7937-7a96-9fd4-ae4c71c74c4b€35.00€0.50matched
102capture01a1a791-7f53-7abb-b9e8-c367d5c42770€35.00€0.50matched
104capture01a1a791-b3fb-76ba-a90d-5f0051ee5352€35.00€0.50matched
105refund01a1a791-c135-7e9c-b417-3164388961f1-€7.00€0.00matched
106capture01a1a791-d682-7b8c-ae0c-3bcd97341d6d€35.00€0.50matched
107capture01a1a791-f9a8-7894-ad3b-760b897975fb€15.00€0.26matched
108capture01a1a792-0255-7305-87e2-3ff3b5532c62€9.00€0.19matched
109refund01a1a792-038d-7326-b32e-f3f65e061b7d-€10.00€0.00matched
110capture01a1a792-0a67-7391-8700-1d0ece55ad70€15.00€0.26matched
111capture01a1a792-13ed-71f6-8cff-5e087f572fbe€35.00€0.50matched
112capture01a1a792-167a-7789-8567-25536a4cee91€35.00€0.50matched
113capture01a1a792-2a73-7622-ac40-70861bbc0d17€9.00€0.19matched
114capture01a1a792-72be-73cf-a622-0e279a47c079€15.00€0.26matched
115capture01a1a792-7ea9-7440-ae2c-afa0db09ca2c€9.00€0.19matched
116capture01a1a792-8b3d-791d-8022-7143db098d48€24.00€0.37matched
117capture01a1a792-aa5e-7da2-86cf-9175151a215c€15.00€0.26matched
118capture01a1a792-c90a-756a-af87-27ca6f6ac0c5€15.00€0.26matched
119capture01a1a792-cf6d-7eda-904a-feaf731ae0b7€15.00€0.26matched
120capture01a1a792-e73a-7e01-bfaf-fb5ad37970a2€35.00€0.50matched
121capture01a1a792-eb67-7684-ae0e-bb84433619a7€49.00€0.67matched
122capture01a1a792-f3db-7e35-8124-93e6c2f048b5€24.00€0.37matched
123capture01a1a792-ff3b-779e-a8ce-9c3da785e084€15.00€0.26matched
124capture01a1a793-01ad-71a5-b6ce-f7856df2c5ae€35.00€0.50matched
125capture01a1a793-027b-7ce2-82e5-246c1f3cf491€15.00€0.26matched
126capture01a1a793-02ad-7a2f-9a3e-8be99fdce2cf€35.00€0.50matched
127capture01a1a793-09ab-7117-b72e-fa7f5b6b6f95€15.00€0.26matched
128capture01a1a793-1d02-7b64-8ab4-4e5e332fd6b1€24.00€0.37matched
129capture01a1a793-21ec-7aa0-9c33-0ba392a789fb€35.00€0.50matched