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

6 Nov, 07:20

Gross

€2,749.00

PSP fee

€43.08

Net to the bank

€2,705.92

Settlement journal

#412060

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:01a1afc0-a305-7111-85ba-367b6f996d2a is in no file
  • missing linein the books, not in the filecapture:01a1afbb-b25e-7e35-9aa0-a1ac29ed9e0e is in no file
LineKindReferenceGrossFeeStatus
107capture01a1afc2-b779-7513-94e7-bef8dc464169€49.00€0.71fee difference
1capture01a1afb1-7561-75ee-8dcb-29595b164a3c€15.00€0.26matched
2capture01a1afb7-12f7-77ce-a195-55537637fc40€24.00€0.37matched
3capture01a1afba-8968-72ee-a064-b488d749bdab€9.00€0.19matched
4capture01a1afba-90d4-71d8-b907-1d4dc2acb86d€49.00€0.67matched
5capture01a1afba-aa72-799d-a9eb-62ea1c55bf2a€35.00€0.50matched
6capture01a1afba-b86d-7e5d-9cad-4079a98127e8€15.00€0.26matched
7refund01a1afba-b99a-7755-be66-c759d54cb99d-€33.00€0.00matched
8capture01a1afba-c45e-7612-a952-f38439298937€49.00€0.67matched
9refund01a1afba-e2c1-7e16-998d-e309a8e78c3d-€7.00€0.00matched
10capture01a1afba-e916-7994-a304-bbfe0df2cee9€15.00€0.26matched
11capture01a1afbb-05e3-7d95-af98-3940c0333333€24.00€0.37matched
12capture01a1afbb-1f39-7d60-ab67-d6f90ce25336€15.00€0.26matched
13capture01a1afbb-51b0-71e3-8625-0c9295a2b708€49.00€0.67matched
14capture01a1afbb-6433-7342-afe8-53ab9d389e04€49.00€0.67matched
15capture01a1afbb-66ac-7852-be2c-42a4dad82dc6€24.00€0.37matched
16capture01a1afbb-6cbf-727e-b018-9a01e42e3e9f€49.00€0.67matched
17capture01a1afbb-770b-773a-802e-8c3c70dbc96c€24.00€0.37matched
18capture01a1afbb-8f4b-7d39-930d-4994a6dc1bf7€15.00€0.26matched
19capture01a1afbb-b6bd-7d54-8086-cf5054dc7ed2€35.00€0.50matched
20capture01a1afbb-cd65-75d9-b1b0-614b63923acc€15.00€0.26matched
21capture01a1afbb-d827-7a79-bfab-4821aec69b4a€24.00€0.37matched
22capture01a1afbb-df9d-7159-bf33-26af616178bb€9.00€0.19matched
23capture01a1afbb-eda6-793f-aa68-f8aaecc46afc€15.00€0.26matched
24capture01a1afbb-f320-769a-9295-672ab3510e64€9.00€0.19matched
25capture01a1afbc-0dc7-7e97-b21a-0908b9f50f74€35.00€0.50matched
26refund01a1afbc-23fb-7199-9ea6-e91f114570ae-€6.00€0.00matched
27capture01a1afbc-2409-77cb-97e4-c25a6d23ad57€49.00€0.67matched
28capture01a1afbc-2eb8-7f0d-a25e-79dfcd8b9503€15.00€0.26matched
29refund01a1afbc-4783-7bfe-abfd-213135b44c20-€20.00€0.00matched
30capture01a1afbc-6b62-7f51-acc4-9fd97c3925a9€15.00€0.26matched
31capture01a1afbc-8625-723d-b489-e8338498cfad€35.00€0.50matched
32capture01a1afbc-8933-71e8-a762-5697fd5858f5€35.00€0.50matched
33capture01a1afbc-8a4c-703c-979e-fb07e670c9c9€49.00€0.67matched
34capture01a1afbc-8c9f-7669-90cb-c7edd86f271b€15.00€0.26matched
35capture01a1afbc-9685-73dd-8a15-34004bc9140c€9.00€0.19matched
36capture01a1afbc-b5c4-7280-9b7b-215615527b51€9.00€0.19matched
37capture01a1afbc-c0ac-7667-9c87-9e0b39e555ef€15.00€0.26matched
38refund01a1afbc-c913-72d4-be1c-5579d73e404c-€8.00€0.00matched
39refund01a1afbc-f534-7110-9b4f-5e0ece882221-€9.00€0.00matched
40capture01a1afbd-1b1e-7434-96f6-73b666bf406b€24.00€0.37matched
41capture01a1afbd-2438-799f-b5a2-abd81bcb485c€24.00€0.37matched
42capture01a1afbd-2a1f-7e07-9aaf-3567133a6346€9.00€0.19matched
43capture01a1afbd-3828-7edd-8975-b37d34694e2d€49.00€0.67matched
44capture01a1afbd-4c61-72a7-b099-f8f1c4224119€9.00€0.19matched
45capture01a1afbd-503e-7b08-81c6-5d9646600ee2€49.00€0.67matched
46capture01a1afbd-54e9-7ab0-a7ad-bf40ef632744€24.00€0.37matched
47capture01a1afbd-5839-7a7d-adb7-2fd5bebe9386€15.00€0.26matched
48capture01a1afbd-5964-7472-9295-4e3060fc0c8f€24.00€0.37matched
49capture01a1afbd-6f42-7a88-a697-40dbd24399c1€24.00€0.37matched
50refund01a1afbd-7905-7a0f-8299-77ceca28ff32-€5.00€0.00matched
51capture01a1afbd-7915-7f26-9076-4d107f7a092c€35.00€0.50matched
52capture01a1afbd-9449-769f-966e-56bc1feb8527€49.00€0.67matched
53capture01a1afbd-a95b-7540-b7e4-16e7269bffff€15.00€0.26matched
54capture01a1afbd-b1c1-7810-9753-9b9c1f57b12b€15.00€0.26matched
55capture01a1afbd-b741-7a52-9460-b1f0a6e36dc6€9.00€0.19matched
56capture01a1afbd-cbb3-7eee-b409-a0c0a257359f€15.00€0.26matched
57capture01a1afbd-cf3a-7576-bf77-886f41e70269€9.00€0.19matched
58capture01a1afbd-d7e6-7983-a62d-1302c6fa2c08€9.00€0.19matched
59capture01a1afbd-dfa1-70f5-80c0-01e770e25133€15.00€0.26matched
60capture01a1afbd-e479-7e8a-a3af-f146a5254d7c€15.00€0.26matched
61capture01a1afbd-eff0-7a45-8ed8-662dea84406a€49.00€0.67matched
62capture01a1afbd-fd6d-7006-96f4-40bb1539e5e4€24.00€0.37matched
63capture01a1afbd-ff8d-75fb-9fb1-eb16d128495e€49.00€0.67matched
64capture01a1afbe-0d17-7571-b6e2-fa3a15179c10€49.00€0.67matched
65capture01a1afbe-45e7-7aa2-92ed-a7d4d9cfb67d€24.00€0.37matched
66capture01a1afbe-8512-7920-bcff-a3377ccb2c1f€24.00€0.37matched
67capture01a1afbe-8bc4-7408-a88d-f7ad5d77cd56€49.00€0.67matched
68capture01a1afbe-d33a-761d-a14b-83f9e2306ab8€9.00€0.19matched
69capture01a1afbf-1061-74c6-9a2c-c49f4c85e461€35.00€0.50matched
70capture01a1afbf-1374-79ad-a443-1b79231ebe6f€9.00€0.19matched
71capture01a1afbf-1a19-7fc8-8c7b-06f06edb5d6b€35.00€0.50matched
72capture01a1afbf-6cb1-7ed2-b800-7ff24b02027d€9.00€0.19matched
73capture01a1afbf-6db4-7085-b790-fe1949b2165c€49.00€0.67matched
74capture01a1afbf-7590-74ce-9fc6-06bdbd5f349f€9.00€0.19matched
75capture01a1afbf-8c5e-75e9-9d83-aab9d6e6d62f€15.00€0.26matched
76capture01a1afbf-8eb6-779c-93de-a60c1bd541b8€24.00€0.37matched
77capture01a1afbf-90d7-74a2-a23c-d02676eae29d€49.00€0.67matched
78capture01a1afbf-bade-7b27-be63-f8ff131b7088€49.00€0.67matched
79refund01a1afbf-e237-71f2-bd56-121e7b60b0b5-€10.00€0.00matched
80capture01a1afbf-e95f-73bb-b251-8f550740577c€15.00€0.26matched
81capture01a1afbf-ec40-7f0b-bf9b-2c4eb71d4f68€49.00€0.67matched
82capture01a1afbf-eec7-7edc-b6f5-2ea7c2dc9691€24.00€0.37matched
83capture01a1afc0-0897-76e4-9115-c61fa34317cc€9.00€0.19matched
84capture01a1afc0-1179-7ea0-9679-13033a7b26bb€24.00€0.37matched
85capture01a1afc0-261a-7e4d-9c77-85e8dd572aa0€9.00€0.19matched
86capture01a1afc0-3f32-7289-8aff-d08b0b50a212€9.00€0.19matched
87capture01a1afc0-520d-7488-ac2e-98e51f0fbfb4€24.00€0.37matched
88capture01a1afc0-56d3-7d8c-afa5-57bc28eb287d€15.00€0.26matched
89refund01a1afc0-5edb-7602-989e-95f6a0783be9-€11.00€0.00matched
90capture01a1afc0-777e-703a-953e-92b10e8abbc1€24.00€0.37matched
91capture01a1afc0-98fb-7e0d-9210-9465933467bc€15.00€0.26matched
92refund01a1afc0-d538-70a9-a5b0-4088164f4c78-€4.00€0.00matched
93capture01a1afc0-eaee-78c4-8c07-1fbfa004f06d€15.00€0.26matched
94capture01a1afc1-25c1-7915-9d9c-9213184c1e45€49.00€0.67matched
95capture01a1afc1-379c-70fa-8b58-61d1cc0e6150€49.00€0.67matched
96capture01a1afc1-393c-7029-a17b-96eae97128f7€15.00€0.26matched
97capture01a1afc1-4b43-7510-be57-85b4f913576f€9.00€0.19matched
98capture01a1afc1-61a7-7866-add7-1273f49a4fb1€49.00€0.67matched
99capture01a1afc1-9031-7247-ac7b-41607f443c08€24.00€0.37matched
100capture01a1afc1-fd67-7f59-9953-1aa5659629c8€49.00€0.67matched
101capture01a1afc2-0c9b-718e-ae26-7969fd66db22€9.00€0.19matched
102capture01a1afc2-1028-7340-bdfb-3527ee887884€15.00€0.26matched
103capture01a1afc2-2765-7ede-a88d-2ed976ca5a5d€15.00€0.26matched
104capture01a1afc2-641c-71a4-80a0-9944deeba80e€49.00€0.67matched
105capture01a1afc2-6e32-7195-bc47-0b3da3221f5c€9.00€0.19matched
106capture01a1afc2-7b20-7086-a9df-7eff89a1cf58€35.00€0.50matched
108capture01a1afc2-a2ed-717c-ac99-2a6b2f80a0e8€35.00€0.50matched
109capture01a1afc2-c8e3-7948-815f-23cca44e516b€15.00€0.26matched
110capture01a1afc2-e705-7631-b45e-28212fb7048f€35.00€0.50matched
111capture01a1afc3-25a5-7722-a40b-2983233d03f4€49.00€0.67matched
112capture01a1afc3-305f-772e-9a67-96cd4d7e1aea€49.00€0.67matched
113capture01a1afc3-716f-73b5-a122-6e34daca174f€49.00€0.67matched
114capture01a1afc3-735c-76d8-8338-614563f716a6€35.00€0.50matched
115capture01a1afc3-762f-71b9-9c72-88ad0d689ce7€9.00€0.19matched
116capture01a1afc3-99c4-7daa-b1ce-8cd6c14b3792€35.00€0.50matched
117capture01a1afc3-ac37-79de-9fad-1439cfdca6e8€49.00€0.67matched