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, 18:50

Gross

€3,321.00

PSP fee

€53.06

Net to the bank

€3,267.94

Settlement journal

#402496

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1ad0c-d69a-773e-9a94-94a1eb3e8c62 is already settled by stl_EUR_2989841 line 22
  • fee differencethe fee is not the contract feethe fee is 4, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 5, the contract says 0
LineKindReferenceGrossFeeStatus
20refund01a1ad0c-c255-747b-baaf-264c6368abbf-€14.00€0.04fee difference
23capture01a1ad0c-d817-7d22-b742-4a849e434601€15.00€0.26duplicate line
59refund01a1ad0f-375c-7111-8d95-206d71878fd1-€41.00€0.05fee difference
1capture01a1ad04-4d08-794e-be21-5e84e536d428€15.00€0.26matched
2capture01a1ad04-feb4-73dc-9a91-6ee959ecdabb€35.00€0.50matched
3capture01a1ad06-1006-7fed-868f-2a117ae3bfd5€24.00€0.37matched
4capture01a1ad0c-0201-7c43-aa8f-fdd63dbb981e€24.00€0.37matched
5capture01a1ad0c-0e40-7f46-b31d-206a01e24ea9€9.00€0.19matched
6capture01a1ad0c-1113-7e71-991b-bc95e3ebe1cb€9.00€0.19matched
7capture01a1ad0c-1173-7f5f-b8cb-568be88a65c2€15.00€0.26matched
8capture01a1ad0c-11f9-7a83-be39-bc7b43d7a553€15.00€0.26matched
9capture01a1ad0c-1232-7de9-bde4-12a806ac93cc€24.00€0.37matched
10capture01a1ad0c-146f-7f57-975f-255f0b617bf1€9.00€0.19matched
11capture01a1ad0c-2cd9-79d5-a25e-df2412ea2792€9.00€0.19matched
12capture01a1ad0c-3ddb-7ea5-b501-575c47419fb9€35.00€0.50matched
13capture01a1ad0c-5136-7a81-a6ad-6ba3d47ddc27€15.00€0.26matched
14capture01a1ad0c-6bee-72ad-8b7b-803b007d5402€35.00€0.50matched
15capture01a1ad0c-6cbb-7785-a80f-1e78d098a383€24.00€0.37matched
16capture01a1ad0c-6d6d-7d1f-9fdb-a6cee3af0742€49.00€0.67matched
17capture01a1ad0c-7c34-772a-92e4-a6130b8314bf€49.00€0.67matched
18capture01a1ad0c-889c-760d-9302-2df582e1c7b4€35.00€0.50matched
19refund01a1ad0c-9205-772c-b535-9d698e1dcfa9-€7.00€0.00matched
21capture01a1ad0c-cc1b-7d96-94e2-73987caccaa0€35.00€0.50matched
22capture01a1ad0c-d817-7d22-b742-4a849e434601€15.00€0.26matched
24capture01a1ad0c-dd2d-75bd-844a-2f218302b816€35.00€0.50matched
25capture01a1ad0c-f898-768a-8e43-c2c24628cf52€9.00€0.19matched
26refund01a1ad0d-12b5-7802-8ace-c332bac890c6-€11.00€0.00matched
27capture01a1ad0d-140f-7c4a-86f6-66772a1c9621€35.00€0.50matched
28capture01a1ad0d-1993-79a4-a629-0a6cd366b1b0€15.00€0.26matched
29capture01a1ad0d-3022-74f3-8834-5e8e8dc19b1e€9.00€0.19matched
30capture01a1ad0d-32e4-7d7c-a018-508b4e52f057€24.00€0.37matched
31capture01a1ad0d-3eb6-7390-9397-faa4a5fff921€9.00€0.19matched
32capture01a1ad0d-4d24-7c5a-8f84-c25dc1faddb8€49.00€0.67matched
33capture01a1ad0d-764c-7aa7-b511-a5608ab03bf5€24.00€0.37matched
34capture01a1ad0d-7bf7-7640-b286-0006cbcf672d€9.00€0.19matched
35capture01a1ad0d-811b-7c90-9cca-bfd9818a57fd€24.00€0.37matched
36capture01a1ad0d-82d8-7632-8e7c-5f50b7d70843€15.00€0.26matched
37refund01a1ad0d-87dc-72c0-b7fa-9d6be38c6012-€4.00€0.00matched
38capture01a1ad0d-afb9-79cf-b1a6-1ea9e6562597€24.00€0.37matched
39capture01a1ad0d-d015-76bb-afed-da13107d6505€35.00€0.50matched
40capture01a1ad0d-e440-7783-af72-2f90ae8559d1€15.00€0.26matched
41capture01a1ad0d-e985-7d65-be0c-93d90ac972ae€24.00€0.37matched
42capture01a1ad0d-f15b-775c-99ed-cb928de6228d€24.00€0.37matched
43capture01a1ad0d-f4a9-79e7-a090-a1adfc292dab€24.00€0.37matched
44capture01a1ad0e-0771-7d06-bca9-072ecee471cf€15.00€0.26matched
45capture01a1ad0e-0d06-7f97-ae70-869644fe2d08€9.00€0.19matched
46refund01a1ad0e-1b83-727e-a49d-8ae99f593564-€18.00€0.00matched
47capture01a1ad0e-1c77-72dd-bbad-d3190e137ab1€35.00€0.50matched
48capture01a1ad0e-25aa-7091-9862-09ae5c5d06ae€35.00€0.50matched
49capture01a1ad0e-4027-7767-b87f-988c79335179€15.00€0.26matched
50capture01a1ad0e-4748-7fc7-8232-05287983364b€15.00€0.26matched
51capture01a1ad0e-764f-74b4-9737-27779dc3bef9€49.00€0.67matched
52capture01a1ad0e-af45-727f-98ab-f751c956ab80€9.00€0.19matched
53capture01a1ad0e-c614-7cd5-9bb4-2acb29b99307€49.00€0.67matched
54capture01a1ad0e-f054-7f87-932d-0ac9a5fcf91a€49.00€0.67matched
55capture01a1ad0e-fcd7-7aa1-bb1c-e9a25d9619e3€24.00€0.37matched
56capture01a1ad0f-0763-7691-8f68-c515e8b0e7ba€15.00€0.26matched
57capture01a1ad0f-16b7-7908-a5d3-3dddb7097693€35.00€0.50matched
58capture01a1ad0f-1dc8-7408-a469-434f94c3ac55€15.00€0.26matched
60capture01a1ad0f-4d16-72fc-8a21-dc5b80aad132€9.00€0.19matched
61capture01a1ad0f-6b6b-787b-84ed-10c67b04535e€49.00€0.67matched
62refund01a1ad0f-7552-7280-a3ec-7347f9a15cbd-€13.00€0.00matched
63capture01a1ad0f-761e-78b7-a36a-ea21a5c2abcc€49.00€0.67matched
64capture01a1ad0f-7865-76ee-bb00-7859662c695c€9.00€0.19matched
65capture01a1ad0f-afd7-70f0-8d10-560ba7dcd51f€24.00€0.37matched
66capture01a1ad0f-b28b-74f1-8b3d-4e1efe433180€49.00€0.67matched
67capture01a1ad0f-d31a-786f-b381-e7f94bd534de€9.00€0.19matched
68capture01a1ad0f-d365-7350-b363-5916560bfafe€35.00€0.50matched
69capture01a1ad0f-f679-7c2c-869b-8d0d7f006b85€24.00€0.37matched
70capture01a1ad0f-fc50-794f-b675-facd5885ccf3€49.00€0.67matched
71capture01a1ad10-0481-7c07-a221-93fbc31a4418€9.00€0.19matched
72capture01a1ad10-319b-753d-9241-9307cac8556e€24.00€0.37matched
73refund01a1ad10-3350-74e8-8b75-7f92d483ba0c-€11.00€0.00matched
74capture01a1ad10-3f1f-7c46-a820-23e297132efb€9.00€0.19matched
75capture01a1ad10-7458-7d06-821b-97763af9b9df€15.00€0.26matched
76capture01a1ad10-7956-7cde-874d-a72b9213e088€49.00€0.67matched
77capture01a1ad10-80a5-7c5b-9270-93da7470cf46€49.00€0.67matched
78capture01a1ad10-893f-7449-b907-647d30e07899€9.00€0.19matched
79capture01a1ad10-a1ee-7839-b575-572eb8812866€9.00€0.19matched
80capture01a1ad10-a963-74a0-95cc-c3f7262c8626€24.00€0.37matched
81capture01a1ad10-bc7a-79f3-a8a7-3094631488c0€9.00€0.19matched
82capture01a1ad10-c985-71d9-983d-6c5598a08468€24.00€0.37matched
83capture01a1ad10-cc7b-7f31-a0e7-7041a49f7f60€49.00€0.67matched
84capture01a1ad10-e09e-711e-b2c0-0a282c2b6e32€15.00€0.26matched
85capture01a1ad10-e26c-7ce0-9a1f-5ae4828adb6b€24.00€0.37matched
86refund01a1ad10-f64a-7c0e-ab1b-0376de17baf2-€4.00€0.00matched
87capture01a1ad10-f8b8-7f02-91ba-b7a255a0877b€9.00€0.19matched
88capture01a1ad11-03f1-7525-ae9e-19e9b9fa302a€15.00€0.26matched
89refund01a1ad11-085c-7a4b-9301-89c66030f47f-€7.00€0.00matched
90capture01a1ad11-0bd9-710b-8325-8ceba28cd4cb€15.00€0.26matched
91capture01a1ad11-0e54-76a4-8b36-be2bb0befb5a€49.00€0.67matched
92capture01a1ad11-0f9a-70a3-be21-2e06dacdec42€9.00€0.19matched
93refund01a1ad11-42bb-7760-9e12-b48e9717f961-€4.00€0.00matched
94capture01a1ad11-4fc4-7800-8e9f-1b4d9ac8d2a5€9.00€0.19matched
95capture01a1ad11-51c8-7bf6-a9ce-854cd37a0f52€35.00€0.50matched
96capture01a1ad11-5274-74e8-b138-ae1599c65e6d€9.00€0.19matched
97capture01a1ad11-a0e8-7fcb-acd3-bf1857b6cbc4€35.00€0.50matched
98capture01a1ad11-aef4-7354-b90d-042f7e21e616€15.00€0.26matched
99refund01a1ad11-b5ff-7f0e-a92b-175690be2675-€17.00€0.00matched
100capture01a1ad11-dd2b-72c4-90f6-87557e92f967€9.00€0.19matched
101capture01a1ad12-052d-7d3c-b07e-d5c1ffb00cf7€35.00€0.50matched
102capture01a1ad12-2a35-79d0-bb8d-2c0a6c519a64€49.00€0.67matched
103capture01a1ad12-390f-7d7d-b8cc-5b206aeb355f€9.00€0.19matched
104capture01a1ad12-470e-7dda-a9d7-b73aac8396de€15.00€0.26matched
105capture01a1ad12-4b8c-75d0-8755-f1a96166fe9a€49.00€0.67matched
106capture01a1ad12-586e-7132-bd9c-0f6dd83f1d94€24.00€0.37matched
107capture01a1ad12-5ebd-7214-b916-6d86fb206f88€35.00€0.50matched
108capture01a1ad12-6c2e-7f51-9ebe-302d1afcb999€49.00€0.67matched
109capture01a1ad12-7d85-770f-ab10-b6500c773808€35.00€0.50matched
110capture01a1ad12-857a-7f42-adb5-2d964d62f271€9.00€0.19matched
111capture01a1ad12-a050-7ee1-b207-ccc2aa0605d9€49.00€0.67matched
112capture01a1ad12-a28b-7f8e-876d-79a03b2f88c9€49.00€0.67matched
113capture01a1ad12-a65c-76ab-b486-a216d4ec1ae4€24.00€0.37matched
114capture01a1ad12-b019-71fe-bca9-d61b5c0d04c6€49.00€0.67matched
115capture01a1ad12-b52e-7317-8161-ebcd05cd4cb0€24.00€0.37matched
116capture01a1ad12-c5c2-7a1a-9bb5-101faa6417ca€24.00€0.37matched
117refund01a1ad12-ce56-73f1-b3ed-6941deceb120-€5.00€0.00matched
118capture01a1ad12-dc54-7a74-9c34-e7cbeee5631f€24.00€0.37matched
119capture01a1ad12-dd67-7bff-b2b7-cd3c6444d261€49.00€0.67matched
120capture01a1ad12-e161-7c7e-a660-107184d41cc1€15.00€0.26matched
121capture01a1ad13-02bd-7a30-9e24-eed3029fd223€35.00€0.50matched
122capture01a1ad13-08ee-701a-9139-7ea8b882b3d3€9.00€0.19matched
123capture01a1ad13-1cd4-7aa5-98c3-d431661c9e64€9.00€0.19matched
124capture01a1ad13-1870-7c57-a0f2-2c9b59530a6a€9.00€0.19matched
125refund01a1ad13-208a-76f8-a40d-bf81a3d033aa-€9.00€0.00matched
126capture01a1ad13-2697-7dd8-affb-bf4805cd64fb€15.00€0.26matched
127capture01a1ad13-3e3c-7de6-8a8f-d8fc1d6558fb€24.00€0.37matched
128capture01a1ad13-4850-7f6d-85f4-47b0fd96797b€35.00€0.50matched
129capture01a1ad13-54fe-728c-a919-667ee6e79c47€49.00€0.67matched
130capture01a1ad13-58e3-70db-adee-226c0f522ba1€9.00€0.19matched
131capture01a1ad13-7214-75eb-96d1-aefba8911ce1€24.00€0.37matched
132capture01a1ad13-7f7e-731b-8ff5-2d1323c5ec76€24.00€0.37matched
133capture01a1ad13-9364-7831-88f3-6f2564c1cb2d€9.00€0.19matched
134capture01a1ad13-b947-7e9e-be36-62d68f533ab3€15.00€0.26matched
135capture01a1ad13-c315-7152-88a4-95701f2ce3a3€49.00€0.67matched
136capture01a1ad13-c959-7265-95bd-c3b27d83c0a4€24.00€0.37matched
137capture01a1ad13-dffc-7bfc-97af-e0eaba0b701d€35.00€0.50matched
138capture01a1ad14-07b4-74a0-b7d6-63c906423884€49.00€0.67matched
139capture01a1ad14-0a25-75e0-8905-b5aa11f03e2e€35.00€0.50matched
140capture01a1ad14-39f6-7e0d-b127-27870a058953€9.00€0.19matched
141capture01a1ad14-686c-72f8-b3a1-89b260e9a8cc€35.00€0.50matched
142capture01a1ad14-6ad8-7b92-a418-37e62cf19bf3€49.00€0.67matched
143capture01a1ad14-8163-78c4-84bb-d4e1ddda2f61€15.00€0.26matched
144capture01a1ad14-aed6-742f-82d5-39d82d15e5d9€15.00€0.26matched
145capture01a1ad14-b6ed-7a0e-b626-b111718c0da7€24.00€0.37matched
146capture01a1ad14-b78d-76b2-8d3b-529824b3bd3c€49.00€0.67matched
147capture01a1ad14-c51b-73b4-ba46-9857da6bd983€24.00€0.37matched
148capture01a1ad14-debf-7303-b2ed-5a5a138e54d1€35.00€0.50matched
149capture01a1ad14-e60f-7ebe-b7d4-05a74574fda7€24.00€0.37matched
150capture01a1ad14-f87f-74f8-b667-dc437d25d4fd€9.00€0.19matched
151capture01a1ad14-fae4-7520-88bf-abdc3c85d1b9€24.00€0.37matched