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:00

Gross

€3,049.00

PSP fee

€47.73

Net to the bank

€3,001.27

Settlement journal

#381964

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a74c-bc92-7591-a906-887c793b1649 is already settled by stl_EUR_2989680 line 46
  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
  • missing linein the books, not in the filecapture:01a1a74f-5cb8-763b-819e-38635e08c71c is in no file
  • missing linein the books, not in the filecapture:01a1a752-a749-7793-b8bd-a8e59cc28a8c is in no file
LineKindReferenceGrossFeeStatus
35capture01a1a74b-f701-793f-a6a1-a8dcb98cba53€35.00€0.53fee difference
47capture01a1a74c-bcab-7cac-81c6-f5818c5e386a€49.00€0.67duplicate line
78capture01a1a74e-448d-70de-9b08-6fe154754889€35.00€0.54fee difference
1capture01a1a747-dfcb-7f8a-bb79-472e088503e2€35.00€0.50matched
2capture01a1a749-e8d7-7a06-a668-b20784c15d13€9.00€0.19matched
3capture01a1a74a-006f-7827-b015-95f7683ba609€24.00€0.37matched
4capture01a1a74a-020e-79e3-91b9-65dde87e2acb€15.00€0.26matched
5capture01a1a74a-04d2-7f22-86a9-bc654a83b89a€15.00€0.26matched
6capture01a1a74a-067d-76c8-bb2f-33ed368c5b42€35.00€0.50matched
7capture01a1a74a-0ba3-78b4-a85b-12cf17710e2b€15.00€0.26matched
8capture01a1a74a-0bb4-70cd-acba-4535586f8551€24.00€0.37matched
9capture01a1a74a-1187-7f1f-8ad9-bddb2aca2983€35.00€0.50matched
10capture01a1a74a-39f7-72fd-a6bf-7a191a52503d€24.00€0.37matched
11capture01a1a74a-5c5a-7139-8811-c04e61672f0c€9.00€0.19matched
12refund01a1a74a-6c14-7d99-96ea-896196d6f7bf-€10.00€0.00matched
13capture01a1a74a-c4c2-7ed4-a9cd-b9602f1f2900€9.00€0.19matched
14capture01a1a74a-d7b0-7ea2-8a36-1c8dec271f93€49.00€0.67matched
15capture01a1a74a-e240-7a8f-ae08-5836c7ee5987€35.00€0.50matched
16capture01a1a74a-f6a7-7ead-8270-d2f093742b45€9.00€0.19matched
17capture01a1a74a-f915-7610-93b2-137e96f0b75a€49.00€0.67matched
18capture01a1a74b-06ab-79d2-9539-c501ced4ce97€49.00€0.67matched
19capture01a1a74b-0706-7dcc-80e8-a13119ef7a85€9.00€0.19matched
20capture01a1a74b-18bf-789c-a05b-09ce9cc25c7f€49.00€0.67matched
21capture01a1a74b-2411-7672-85ee-54fe05094555€24.00€0.37matched
22capture01a1a74b-2646-7798-9617-c8fc9f4ae051€35.00€0.50matched
23capture01a1a74b-2ed4-753e-8af2-fc72ef0f63d7€35.00€0.50matched
24capture01a1a74b-5486-7c99-b025-5b21806f493b€9.00€0.19matched
25capture01a1a74b-694d-7074-94bf-f80eed4f6428€9.00€0.19matched
26capture01a1a74b-7903-7cf6-af36-5d31bead124b€49.00€0.67matched
27capture01a1a74b-81cf-76e7-9d60-1bb191a23bf1€9.00€0.19matched
28refund01a1a74b-90e1-7e3f-a190-95f52c1f29d4-€29.00€0.00matched
29capture01a1a74b-9a72-7f27-8295-0dea24932516€24.00€0.37matched
30capture01a1a74b-cd9f-729d-aacd-822fb3a74494€24.00€0.37matched
31capture01a1a74b-d5f7-782f-9790-95e6b76a493c€24.00€0.37matched
32refund01a1a74b-d8cc-71d0-96f8-5c145d4e22c0-€11.00€0.00matched
33capture01a1a74b-f028-7a8b-b40b-8bba630aa9bd€9.00€0.19matched
34capture01a1a74b-f448-75e5-ad96-9fd7c0395b67€35.00€0.50matched
36capture01a1a74b-fac0-7554-8c52-c17254f6862b€9.00€0.19matched
37capture01a1a74c-04a0-788e-9a02-6b7174938572€35.00€0.50matched
38capture01a1a74c-1148-7e25-84cb-f68f680ea4f4€35.00€0.50matched
39capture01a1a74c-34d3-768d-9030-2a0a2ec3708b€9.00€0.19matched
40capture01a1a74c-3b62-7777-8e83-a3a04c0494e6€15.00€0.26matched
41capture01a1a74c-54ac-7267-a5b1-3c38f01a7a3b€49.00€0.67matched
42capture01a1a74c-7634-7f15-a7a1-f90ac6fd6a70€49.00€0.67matched
43capture01a1a74c-8765-73c9-9e96-9c484959fd2b€35.00€0.50matched
44capture01a1a74c-8d5b-7873-a498-60aa37a20210€15.00€0.26matched
45capture01a1a74c-94f3-705e-9b19-07903d42a0bb€15.00€0.26matched
46capture01a1a74c-bcab-7cac-81c6-f5818c5e386a€49.00€0.67matched
48capture01a1a74c-be24-7f86-9827-4df092ba07fc€15.00€0.26matched
49capture01a1a74c-d02c-7a22-ad93-b84881e98b5d€24.00€0.37matched
50capture01a1a74c-d3a6-75f5-999d-60403164abb1€24.00€0.37matched
51capture01a1a74c-e492-72e2-bb38-4797e0c458ee€9.00€0.19matched
52capture01a1a74c-f526-7f1c-882f-e05dab9a1687€35.00€0.50matched
53capture01a1a74c-fea3-7c7a-a8a8-0eeabddfbb74€35.00€0.50matched
54capture01a1a74d-08d8-70be-a235-54f834551dda€9.00€0.19matched
55refund01a1a74d-0dff-7a06-96f5-ac3f9b49edfd-€17.00€0.00matched
56capture01a1a74d-21f4-7246-a440-732d7929895b€15.00€0.26matched
57capture01a1a74d-31cb-7104-abae-c82a9485e066€24.00€0.37matched
58capture01a1a74d-3a19-7505-a93c-0b7e13ea4ce9€9.00€0.19matched
59capture01a1a74d-469a-7698-923e-75298da1cca1€35.00€0.50matched
60refund01a1a74d-4a29-77af-92bb-a3e9118ec987-€15.00€0.00matched
61capture01a1a74d-504c-783b-b2ab-0c3077283a9a€49.00€0.67matched
62capture01a1a74d-5365-77f6-b59e-e4753f3935ee€24.00€0.37matched
63capture01a1a74d-619f-76b6-90e6-a8e28652b18b€15.00€0.26matched
64capture01a1a74d-677d-7910-b507-8e0fd19234b4€9.00€0.19matched
65capture01a1a74d-6940-7c5d-bd17-7a6a35d38a72€15.00€0.26matched
66refund01a1a74d-6e88-788c-a423-cce2dad729fd-€2.00€0.00matched
67capture01a1a74d-8ca5-7cbd-9993-aa1d3bc9cb23€15.00€0.26matched
68capture01a1a74d-ae46-704b-96b3-bdd3fa25cfcb€9.00€0.19matched
69capture01a1a74d-b5a9-72cc-b53c-545ef9a6c4a6€15.00€0.26matched
70capture01a1a74d-c657-77e1-89c2-f959baca4b52€15.00€0.26matched
71capture01a1a74d-c877-7700-bd41-3331b1a23b08€9.00€0.19matched
72capture01a1a74d-e7f1-73ac-b15b-221aecc2a206€9.00€0.19matched
73capture01a1a74d-f6c4-79f5-a42c-cae9aac157d0€24.00€0.37matched
74capture01a1a74e-12a5-77ec-9550-8336be7c262e€49.00€0.67matched
75capture01a1a74e-19f9-74ed-b0dc-93620b334edb€49.00€0.67matched
76capture01a1a74e-2537-7b8a-8187-91788761d3ca€49.00€0.67matched
77capture01a1a74e-2982-7703-831f-bb2404a5a96e€9.00€0.19matched
79capture01a1a74e-85a8-7c3d-b7ef-61db1569cd38€9.00€0.19matched
80capture01a1a74e-8af9-7c65-ba45-77b487af50d5€15.00€0.26matched
81refund01a1a74e-9b10-7d64-acae-a1102509afb9-€18.00€0.00matched
82capture01a1a74e-a52b-7eaa-bfab-3f88c1a9f056€9.00€0.19matched
83capture01a1a74e-ea76-7128-b123-85957aa94615€49.00€0.67matched
84capture01a1a74f-58fc-764d-898d-82e2a73fd4bf€15.00€0.26matched
85capture01a1a74f-78b3-75a7-8492-95d4295abe8d€35.00€0.50matched
86capture01a1a74f-a693-753e-a3ae-fc915e5f8eec€35.00€0.50matched
87capture01a1a74f-a7cd-74dd-bc64-fa47c438daa4€9.00€0.19matched
88capture01a1a74f-b1b9-7767-9d35-198352cdd6ac€15.00€0.26matched
89capture01a1a74f-b835-76f1-ac48-eaab78fc75fc€49.00€0.67matched
90capture01a1a74f-ba6a-77e8-aa4f-e187ef166b5c€15.00€0.26matched
91capture01a1a74f-c624-7cb2-8302-013332826a10€49.00€0.67matched
92capture01a1a74f-cacc-7e35-a60e-8884d5ee0be4€49.00€0.67matched
93capture01a1a74f-dee3-730b-83f8-51a682642230€24.00€0.37matched
94capture01a1a74f-ee43-7cc1-b8b7-42bfaaed43ec€49.00€0.67matched
95capture01a1a750-06ac-7538-aa4b-3670a55099ac€9.00€0.19matched
96capture01a1a750-2fcd-757c-b69b-563dfa3ecf49€49.00€0.67matched
97capture01a1a750-4a42-7d14-be4b-368abcbc8ae1€49.00€0.67matched
98capture01a1a750-5bb5-768e-bac0-da18ca9fc29e€24.00€0.37matched
99capture01a1a750-5f0b-781a-9ff6-710866c8913e€49.00€0.67matched
100capture01a1a750-6cc4-7454-92e0-cdaa6178bbe9€15.00€0.26matched
101capture01a1a750-7068-776a-b18e-e06f545993f1€15.00€0.26matched
102capture01a1a750-8e14-7fe8-ac0e-53252b4f9a88€49.00€0.67matched
103capture01a1a750-9eb4-74b8-b006-541f88ba7879€15.00€0.26matched
104capture01a1a750-a9f7-79a4-bfce-9a6e698f0ea0€49.00€0.67matched
105capture01a1a750-be6b-7ddf-b002-27ea52545869€24.00€0.37matched
106capture01a1a750-c335-7297-b3e4-d036f91ad8ec€15.00€0.26matched
107capture01a1a750-c4b2-7d3b-867e-28a78c82ccce€9.00€0.19matched
108capture01a1a750-e8ff-7c51-a6a5-e813378916ce€15.00€0.26matched
109capture01a1a750-ed40-7326-8c5a-732c42d4a5bf€15.00€0.26matched
110capture01a1a751-0723-7d8d-9378-9f1b34ddc3c1€15.00€0.26matched
111capture01a1a751-4f85-78e4-8de6-e2b47da24c52€49.00€0.67matched
112capture01a1a751-59ce-726b-9750-efa7fe30916e€49.00€0.67matched
113capture01a1a751-5dd4-7509-9520-d51689690b73€15.00€0.26matched
114capture01a1a751-62f1-712c-a5b5-93dc9c6f9781€9.00€0.19matched
115capture01a1a751-98d9-759c-97f4-06d0d2111401€9.00€0.19matched
116capture01a1a751-a5fb-7e7e-a9d2-493007182be2€9.00€0.19matched
117capture01a1a751-b826-783b-b0e7-48609a3d304b€24.00€0.37matched
118refund01a1a751-bb95-70c6-8841-245b5817f873-€2.00€0.00matched
119capture01a1a751-d84b-7ff1-b787-ce4af9d42dc0€15.00€0.26matched
120capture01a1a751-ddd8-70f9-9a5d-4d0efbd7c22c€35.00€0.50matched
121capture01a1a751-e0c6-7446-8630-367bed82a386€49.00€0.67matched
122capture01a1a751-e1c6-7ef3-bfe2-ceb39b71c2ea€35.00€0.50matched
123capture01a1a752-0084-76c7-803c-a0a756df988c€15.00€0.26matched
124capture01a1a752-31ec-74f3-ac94-ba022f31f518€35.00€0.50matched
125capture01a1a752-388d-728c-a540-9b652efc1595€15.00€0.26matched
126capture01a1a752-5340-7284-9e6e-02b7432c49c7€49.00€0.67matched
127capture01a1a752-7beb-7c75-9d2b-81334f15eb6e€24.00€0.37matched
128capture01a1a752-8ef5-7233-82ed-f0021c013d73€24.00€0.37matched
129capture01a1a752-c7fe-7482-8258-4453903bef13€35.00€0.50matched