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

Gross

€3,128.00

PSP fee

€49.20

Net to the bank

€3,078.80

Settlement journal

#382232

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
  • missing linein the books, not in the filecapture:01a1a75c-a70f-731f-88d6-f057a371aeb5 is in no file
LineKindReferenceGrossFeeStatus
100capture01a1a762-bfa2-765f-b3ff-dacc0ee1d03a€24.00€0.38fee difference
1capture01a1a75a-b123-7363-a1f3-a1ade21cb00e€35.00€0.50matched
2capture01a1a75c-4511-7522-959a-f271c86014e8€35.00€0.50matched
3capture01a1a75c-533e-7611-9236-dd032b5c9768€49.00€0.67matched
4capture01a1a75c-6476-7ce7-a167-aeef5458a73a€24.00€0.37matched
5capture01a1a75c-6cf4-7888-bd47-d98e686bb1da€49.00€0.67matched
6capture01a1a75c-8314-77b7-bf24-425dffbb1b07€15.00€0.26matched
7capture01a1a75c-91c2-73b7-b768-d9b9bc5f3356€35.00€0.50matched
8capture01a1a75c-d93d-74c5-b920-183e6f3f0e53€49.00€0.67matched
9capture01a1a75c-dd1a-766a-90fa-33f1c42ca3bd€35.00€0.50matched
10refund01a1a75c-e286-773d-862b-a95fc31aaea3-€13.00€0.00matched
11capture01a1a75d-118e-72c4-89b5-54aa00d74926€9.00€0.19matched
12capture01a1a75d-0e87-76a0-8565-bf73ab43c4bf€35.00€0.50matched
13capture01a1a75d-35d8-7a44-b5b2-bec323cab5e1€24.00€0.37matched
14capture01a1a75d-35fe-7c3c-a305-9885063f4d11€49.00€0.67matched
15capture01a1a75d-368f-7c0b-8a50-89c27611845e€49.00€0.67matched
16capture01a1a75d-3735-7c31-a638-6ef1a2a2067e€9.00€0.19matched
17capture01a1a75d-3961-748f-85e1-fd99155751a3€24.00€0.37matched
18capture01a1a75d-6e7d-78a4-8603-2daa68bf7663€24.00€0.37matched
19capture01a1a75d-90e2-7c06-95aa-aa799b0f8df9€9.00€0.19matched
20capture01a1a75d-a224-75d9-97ed-40c1d252a395€15.00€0.26matched
21capture01a1a75d-a434-741b-a3ab-577241fcfe71€24.00€0.37matched
22capture01a1a75d-aa34-7a04-af44-e39091b4f9bb€15.00€0.26matched
23capture01a1a75d-aedb-7a01-9b91-9181bd748cdc€15.00€0.26matched
24capture01a1a75d-b7f6-7df6-b395-4f0cfcfdd7d8€24.00€0.37matched
25capture01a1a75d-b827-7a1e-9213-7218a4a29577€35.00€0.50matched
26capture01a1a75d-d977-740c-bcd2-ac743d86b0a2€35.00€0.50matched
27capture01a1a75d-f47d-7129-9d9e-e00cf8ed603b€35.00€0.50matched
28capture01a1a75d-ffcd-75b4-b3e3-b083f6aceda4€15.00€0.26matched
29capture01a1a75e-12c8-7855-93b7-2347e0cb2999€15.00€0.26matched
30capture01a1a75e-2772-798b-9ff3-00e960e8d912€35.00€0.50matched
31capture01a1a75e-3406-79fc-ab06-09d075069db6€15.00€0.26matched
32capture01a1a75e-349b-7bf1-b677-2a9fb65a5bf6€15.00€0.26matched
33capture01a1a75e-39d0-7dd1-b1d6-9f0c8c711d9a€35.00€0.50matched
34capture01a1a75e-532b-7da8-9128-07e2c0b6799c€49.00€0.67matched
35capture01a1a75e-81cf-780c-8070-d44faa918977€15.00€0.26matched
36capture01a1a75e-9eaa-7573-b83d-0c3d549c569b€15.00€0.26matched
37capture01a1a75e-abe2-7f94-842e-08726a6c5917€35.00€0.50matched
38capture01a1a75e-b0ea-7207-8f85-10f1ecaf6416€9.00€0.19matched
39capture01a1a75e-b31e-77cf-9397-4d24ba88322b€9.00€0.19matched
40capture01a1a75e-bfbe-7d56-b23b-92ed47d679a9€9.00€0.19matched
41capture01a1a75e-cfa0-735a-96c3-caee94bd2f4c€49.00€0.67matched
42capture01a1a75e-d4a1-7a5d-807f-87aa3af0a74d€49.00€0.67matched
43capture01a1a75e-df63-7f54-b0a7-c609f4c61e63€9.00€0.19matched
44capture01a1a75e-eedd-72bf-a585-d0a0d6b1b56a€15.00€0.26matched
45capture01a1a75e-f077-743f-b12a-d7683a50388d€49.00€0.67matched
46capture01a1a75e-f6fe-759a-a891-a9651c22d724€24.00€0.37matched
47refund01a1a75f-068d-7e4b-baa0-ec93b9d70aa2-€25.00€0.00matched
48refund01a1a75f-0cba-7cc7-a162-6f245b4d6999-€7.00€0.00matched
49capture01a1a75f-0cec-73dd-9869-456deb066d87€15.00€0.26matched
50capture01a1a75f-110d-7718-9bc2-a8b150488eb8€49.00€0.67matched
51capture01a1a75f-2f80-71dc-ae2c-55d613e0c449€15.00€0.26matched
52capture01a1a75f-3f5d-7b50-ad94-1df101a05f24€24.00€0.37matched
53capture01a1a75f-40b0-7a8e-a721-5f2b4059ead0€35.00€0.50matched
54capture01a1a75f-422e-78d0-9c80-6734bac4dac6€35.00€0.50matched
55capture01a1a75f-428e-7215-aae4-1aab81f6b72b€49.00€0.67matched
56capture01a1a75f-4a4a-7ea4-908f-20ac8b4b17f9€35.00€0.50matched
57capture01a1a75f-66fe-7a7e-94ad-1731b30ad617€15.00€0.26matched
58capture01a1a75f-6b15-7b7c-99b7-b5a46b4ad66f€35.00€0.50matched
59capture01a1a75f-7909-7f7b-a5ff-469dcee099d7€24.00€0.37matched
60capture01a1a75f-89d6-702c-a402-c99358c3c864€35.00€0.50matched
61refund01a1a75f-95df-76d0-8947-f62294e9d31d-€45.00€0.00matched
62capture01a1a75f-c382-7f38-90d2-6f1831d766f4€49.00€0.67matched
63capture01a1a75f-c5b3-7328-9085-a3a7c7282b81€35.00€0.50matched
64capture01a1a75f-cce6-7ca5-846d-c7d40949886f€9.00€0.19matched
65capture01a1a75f-df0b-7443-89ca-7f0d03b86a6c€49.00€0.67matched
66capture01a1a75f-ec0c-77e8-81ba-fa68b8aee8e2€9.00€0.19matched
67capture01a1a75f-ff29-7d9e-8193-2f6b047f844b€49.00€0.67matched
68capture01a1a760-0555-7431-b9ee-85e605d9d934€15.00€0.26matched
69capture01a1a760-2077-7a62-9cb1-b36d80e07b18€15.00€0.26matched
70capture01a1a760-2213-74fc-9b3a-eeaf9b8af5f2€24.00€0.37matched
71capture01a1a760-644e-788d-95e7-0e2a4b875ea2€24.00€0.37matched
72capture01a1a760-61df-7d03-9fb1-d2f05e51f072€49.00€0.67matched
73capture01a1a760-865b-7fd7-b52e-f5b827220878€15.00€0.26matched
74capture01a1a760-9297-76b7-b4a8-de01c5fec02e€24.00€0.37matched
75capture01a1a760-9777-77c7-8603-4f19464825e3€15.00€0.26matched
76capture01a1a760-d750-7201-8a9c-20fc5f6561e2€15.00€0.26matched
77capture01a1a760-da65-73b4-b324-2b83ada6198c€35.00€0.50matched
78capture01a1a760-edec-71d4-88d5-eb5ebcd24a1d€9.00€0.19matched
79capture01a1a760-f94c-70b2-919f-d4a710ae0cc7€24.00€0.37matched
80capture01a1a760-fc3b-7ed3-bb69-997b1efcc230€35.00€0.50matched
81capture01a1a760-feb7-7d2e-84a8-a2116c60e8eb€15.00€0.26matched
82refund01a1a761-107c-73f2-be19-88d2f9139d3a-€8.00€0.00matched
83capture01a1a761-13b5-7a80-af8a-e176c93a1624€35.00€0.50matched
84capture01a1a761-2376-70ef-b9ee-be26ac1545f5€9.00€0.19matched
85capture01a1a761-47d4-74c4-b38a-aa8f02952408€15.00€0.26matched
86capture01a1a761-5d93-71aa-a4e4-ffc45bc96963€49.00€0.67matched
87capture01a1a761-5364-7828-8a95-8134492bc250€35.00€0.50matched
88capture01a1a761-7a2d-7284-a2ca-fdcba4a14ac1€9.00€0.19matched
89capture01a1a761-9a44-7782-b79a-27ab6ba789e5€24.00€0.37matched
90capture01a1a761-b4c9-76bf-a2da-57d7a99c01fd€9.00€0.19matched
91capture01a1a761-be19-784a-ad6a-94fbe47ef05a€24.00€0.37matched
92capture01a1a761-c374-7b25-b675-be59081eead0€15.00€0.26matched
93capture01a1a761-c52c-7413-8390-bce93a11a608€15.00€0.26matched
94refund01a1a761-c994-73d6-ac7f-0885b3b8918b-€13.00€0.00matched
95capture01a1a761-d415-739d-9fc4-3e369e8549ed€35.00€0.50matched
96capture01a1a762-0442-77ad-a176-5964d2aab61b€9.00€0.19matched
97capture01a1a762-0c90-7861-9c19-ae66a21c745d€35.00€0.50matched
98capture01a1a762-45d7-7113-ae21-ff3dbaa5eacc€35.00€0.50matched
99capture01a1a762-6760-7a9f-a35d-2ed5007b0eac€35.00€0.50matched
101capture01a1a762-cdea-73f3-89c8-a4d0879152d3€24.00€0.37matched
102capture01a1a762-d887-76fe-ac3d-de3a236f7e4b€35.00€0.50matched
103capture01a1a762-e9bd-7467-9520-cdfdbde3b11a€35.00€0.50matched
104capture01a1a762-ebc1-7248-b8c9-85a68aa9db2c€35.00€0.50matched
105capture01a1a762-f8bf-7095-b69e-c51551b1f9c6€15.00€0.26matched
106capture01a1a763-003d-71ce-857b-5a3d37588974€35.00€0.50matched
107capture01a1a763-21fd-7aa2-aca6-7330796b3686€49.00€0.67matched
108capture01a1a763-30fb-7c1f-9010-0f19aff4e6f9€49.00€0.67matched
109capture01a1a763-2fbc-7d24-8ea1-eaf5abc6dec1€15.00€0.26matched
110refund01a1a763-55d8-7d7d-b8f7-d7b68c47da86-€11.00€0.00matched
111capture01a1a763-705d-7071-83ed-2118ba0e8161€15.00€0.26matched
112capture01a1a763-774d-7f37-8e93-ad54828de0f4€15.00€0.26matched
113capture01a1a763-8366-7a06-93c2-7657f38cf398€9.00€0.19matched
114capture01a1a763-947f-7692-aa89-c74944be983d€24.00€0.37matched
115capture01a1a763-9c58-726c-a4fa-755feb3dc2b2€15.00€0.26matched
116refund01a1a763-a231-7157-9747-38862728e46d-€12.00€0.00matched
117capture01a1a763-b513-7a62-af96-55a0f04062af€24.00€0.37matched
118capture01a1a763-dde2-7f4e-8a24-1c3b37981abb€24.00€0.37matched
119capture01a1a763-df1c-7119-9ad1-88b9dde5567b€24.00€0.37matched
120capture01a1a763-f8d1-71ea-8330-57cbcba0be0e€9.00€0.19matched
121capture01a1a764-6760-734a-b644-f480887ba493€49.00€0.67matched
122capture01a1a764-7c45-74f3-96e8-cbd44124662e€15.00€0.26matched
123capture01a1a764-87c0-755f-a1a7-3450e8881c6f€9.00€0.19matched
124capture01a1a764-8f0a-7258-b3f9-a30baf3cf7c3€35.00€0.50matched
125capture01a1a764-dcf2-7a65-92d7-c72d2f37cfed€15.00€0.26matched
126capture01a1a764-e756-75ed-a958-0f22aac71e6a€24.00€0.37matched
127capture01a1a765-145c-71e8-9a4d-6bfc36956f43€35.00€0.50matched
128capture01a1a765-1092-79b8-9b69-fc7790144f67€9.00€0.19matched
129capture01a1a765-17cc-7684-b440-4140a641f570€24.00€0.37matched
130capture01a1a765-2329-7430-b6d0-3e72fb21254d€49.00€0.67matched
131capture01a1a765-449f-7ff0-b2c8-84cf3b739325€24.00€0.37matched
132capture01a1a765-563e-7e09-81c6-4c90bdf5d1b8€9.00€0.19matched