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

2 Nov, 05:40

Gross

€2,814.00

PSP fee

€45.72

Net to the bank

€2,768.28

Settlement journal

#337627

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19ac9-f89b-71cb-86ac-9749a9a8e9a7 is already settled by stl_EUR_2989330 line 62
  • duplicate linethe file lists it twicecapture:01a19acb-a173-7168-a926-a893f6ddebf6 is already settled by stl_EUR_2989330 line 85
  • duplicate linethe file lists it twicecapture:01a19ace-7f2d-76b3-8fce-6c981a5acfd7 is already settled by stl_EUR_2989330 line 128
  • missing linein the books, not in the filecapture:01a19acc-ac2d-7bd6-a890-1642aa6a0702 is in no file
LineKindReferenceGrossFeeStatus
63capture01a19ac9-fa74-735a-8f68-9e5fabc78ff0€24.00€0.37duplicate line
86capture01a19acb-a1da-7dd8-8632-fb26d41b0f0a€35.00€0.50duplicate line
129capture01a19ace-7f66-7763-9c69-0bcb53987df6€24.00€0.37duplicate line
1capture01a19ac0-5abf-7611-9b3c-82c243d04ebd€15.00€0.26matched
2capture01a19ac5-ad53-729c-888f-74af01d46561€35.00€0.50matched
3capture01a19ac5-ba8f-732c-9aa8-6413b758ebab€15.00€0.26matched
4capture01a19ac5-c879-72f7-a12a-675bb31fcc1c€15.00€0.26matched
5capture01a19ac5-d45b-720f-8a25-6f093f7acddb€35.00€0.50matched
6capture01a19ac5-dabe-7046-9c56-a5bdb67c1362€15.00€0.26matched
7capture01a19ac5-dd0c-775c-a36b-c51da0c9999b€35.00€0.50matched
8capture01a19ac5-f930-748f-a88d-a1f9d93e2646€35.00€0.50matched
9capture01a19ac5-fabb-7d16-b6bc-c3739878d8bb€9.00€0.19matched
10capture01a19ac6-0baf-76fc-a9db-4d221816968f€49.00€0.67matched
11capture01a19ac6-1704-733d-bb4e-ac80e9abdd57€24.00€0.37matched
12capture01a19ac6-2bde-73f2-ac11-d0ff14599380€9.00€0.19matched
13capture01a19ac6-6d2d-76cb-9f7f-66850defc131€15.00€0.26matched
14capture01a19ac6-7d8d-73fd-a53f-acd0086e0193€35.00€0.50matched
15capture01a19ac6-8248-7706-847a-dd15dfff13dc€9.00€0.19matched
16capture01a19ac6-8508-7398-96a1-01848f47ffbd€15.00€0.26matched
17capture01a19ac6-bee7-7372-a942-3f7f1887248c€49.00€0.67matched
18capture01a19ac6-c943-7ef2-8545-9832e9a02dbc€15.00€0.26matched
19capture01a19ac6-e4e5-7739-9bca-18b2f8915be7€9.00€0.19matched
20capture01a19ac6-f17a-7ca4-98b1-7a86748fab95€35.00€0.50matched
21capture01a19ac7-02e6-7308-a391-4606688d93b8€15.00€0.26matched
22capture01a19ac7-275f-7f9d-80a6-04140c0796b5€9.00€0.19matched
23capture01a19ac7-5216-7572-9926-68a83a67d50d€9.00€0.19matched
24capture01a19ac7-637c-792d-9da1-01395a7ab6b9€9.00€0.19matched
25refund01a19ac7-8b10-73f4-8ca0-791285c76a70-€4.00€0.00matched
26capture01a19ac7-97d6-70de-af56-93a3efbc1a7b€24.00€0.37matched
27capture01a19ac7-a57e-7846-9660-3daec593397c€24.00€0.37matched
28capture01a19ac7-b76e-7d32-97d3-ab6d3130e25d€49.00€0.67matched
29capture01a19ac7-cf09-73a8-a33d-45e3172ecdae€15.00€0.26matched
30capture01a19ac7-e6dd-7f69-ae07-426e7b57afed€35.00€0.50matched
31capture01a19ac7-ee20-7bf1-8a34-1bd37d9c86ef€15.00€0.26matched
32capture01a19ac7-f43f-7a01-92c1-79d38dd78559€9.00€0.19matched
33capture01a19ac8-0422-72e8-b04a-a769ffaad553€9.00€0.19matched
34refund01a19ac8-15d6-7e7e-9f12-24285baf5285-€40.00€0.00matched
35capture01a19ac8-17e2-73f9-9952-d85c5d3bdbce€24.00€0.37matched
36capture01a19ac8-1966-7884-9129-ec3b34bde16f€49.00€0.67matched
37refund01a19ac8-49d3-760a-9065-f466b5e16fb9-€29.00€0.00matched
38capture01a19ac8-718d-7ee7-8f23-e775ed7c5dab€49.00€0.67matched
39capture01a19ac8-70d9-7191-a2ee-ad80cdc9d039€35.00€0.50matched
40capture01a19ac8-893c-7bd9-8b82-3ab0b1178791€35.00€0.50matched
41capture01a19ac8-949b-72db-bb70-7ab572abdc98€15.00€0.26matched
42capture01a19ac8-f536-7447-9cff-bf1df1265934€49.00€0.67matched
43capture01a19ac9-04ad-7db1-a396-330cb56b192e€24.00€0.37matched
44capture01a19ac9-0b70-79ba-89ca-bb6f99689626€15.00€0.26matched
45capture01a19ac9-14c6-7978-afd0-e539bca0dbf3€49.00€0.67matched
46capture01a19ac9-2c14-7a27-bc5f-84ff07140d33€9.00€0.19matched
47capture01a19ac9-3b82-76a4-94ba-01300a6d80b7€9.00€0.19matched
48capture01a19ac9-499e-7ebd-a9da-fdb9f6b01921€9.00€0.19matched
49capture01a19ac9-61b0-754c-b90d-30780c42c9be€15.00€0.26matched
50capture01a19ac9-720f-7557-8d1d-a63e2896fd86€24.00€0.37matched
51capture01a19ac9-7e73-73eb-96ed-2215ef36a161€24.00€0.37matched
52capture01a19ac9-8796-7d26-acac-39bd29731ff7€24.00€0.37matched
53capture01a19ac9-8dc7-7c6f-a721-5f141521b99f€24.00€0.37matched
54capture01a19ac9-8dcd-7e21-be30-6f4b34005ff4€49.00€0.67matched
55capture01a19ac9-94ea-778b-8432-0ffd105e57da€15.00€0.26matched
56capture01a19ac9-a4f1-7cdb-96a8-19c97aa5d024€24.00€0.37matched
57capture01a19ac9-bc0e-7415-b990-0e418c4b10eb€35.00€0.50matched
58capture01a19ac9-cfbc-7612-89af-4289c3e691cc€15.00€0.26matched
59capture01a19ac9-caa9-754d-a56b-7d52664ee52f€24.00€0.37matched
60capture01a19ac9-e896-756c-bf0a-d302c463903d€24.00€0.37matched
61capture01a19ac9-fa7b-7cf7-832c-f7cebf05286f€15.00€0.26matched
62capture01a19ac9-fa74-735a-8f68-9e5fabc78ff0€24.00€0.37matched
64capture01a19aca-2bd5-7851-9b16-b06977e1f1aa€24.00€0.37matched
65capture01a19aca-4996-7dc6-a1a7-0bfdeaa44198€9.00€0.19matched
66capture01a19aca-552c-77db-80d1-bea03255d52e€15.00€0.26matched
67capture01a19aca-6c98-73e8-b270-54dcb66e27f1€15.00€0.26matched
68capture01a19aca-813d-7ab0-9dee-5b6d5055deb8€24.00€0.37matched
69capture01a19aca-a040-751e-9428-541a4bfb4e1f€15.00€0.26matched
70capture01a19aca-a93d-715d-a500-438b0b518327€9.00€0.19matched
71capture01a19aca-c7e2-78df-a6fc-7e0eafc10922€35.00€0.50matched
72capture01a19aca-d09c-7968-9ab7-60eff09b4f54€24.00€0.37matched
73capture01a19aca-d606-7e74-9a21-122ec52a2c10€15.00€0.26matched
74capture01a19acb-0bd0-733e-8f63-b3852de8c7cf€15.00€0.26matched
75capture01a19acb-0d24-733e-9c5b-6abb16fb5c69€24.00€0.37matched
76capture01a19acb-227f-7a5f-bce7-b6f644611f03€49.00€0.67matched
77capture01a19acb-244b-78b0-8a0a-76195e295152€15.00€0.26matched
78capture01a19acb-3499-7f25-bca9-38f5292057fa€15.00€0.26matched
79capture01a19acb-35f4-7a5a-bbfa-936fd649079a€49.00€0.67matched
80capture01a19acb-4092-7530-81f7-a3b4e4e921ed€35.00€0.50matched
81capture01a19acb-4243-7f1b-ba47-67306d4021d4€9.00€0.19matched
82capture01a19acb-6b01-7d49-9e83-f844de5222d1€49.00€0.67matched
83capture01a19acb-7675-7e21-85ad-a0e694a3ed9d€9.00€0.19matched
84capture01a19acb-9ee1-7cc4-a926-a57829d37eea€49.00€0.67matched
85capture01a19acb-a1da-7dd8-8632-fb26d41b0f0a€35.00€0.50matched
87capture01a19acb-b130-7d35-8f6b-b77c2556de37€35.00€0.50matched
88capture01a19acb-b14a-7902-89cd-456883d234d3€49.00€0.67matched
89capture01a19acb-b3c4-7ea1-ba3b-54625a403749€15.00€0.26matched
90capture01a19acb-d612-7d71-85ce-83324b5cc841€49.00€0.67matched
91capture01a19acb-dd56-7ca3-9f8a-31563a0f740f€49.00€0.67matched
92capture01a19acb-ea6a-7164-9c35-88fa77ded08e€15.00€0.26matched
93capture01a19acc-007c-724a-9d45-b80157edea0c€9.00€0.19matched
94capture01a19acc-299c-782a-9716-d2e88b35311d€35.00€0.50matched
95capture01a19acc-5149-76d5-92f4-fb73841a4fcd€35.00€0.50matched
96capture01a19acc-5575-7e13-8b75-96717428284c€24.00€0.37matched
97capture01a19acc-5ed8-7339-9171-6d6303c1f610€15.00€0.26matched
98capture01a19acc-6ee7-7299-9280-2da26392ad00€9.00€0.19matched
99capture01a19acc-7071-7ec8-89d3-def64976ca86€9.00€0.19matched
100capture01a19acc-70a5-7897-9140-d67d96326d37€15.00€0.26matched
101capture01a19acc-94ca-73a8-b68a-a977e863e0a9€49.00€0.67matched
102refund01a19acc-962a-704e-93ad-59323ad85380-€34.00€0.00matched
103capture01a19acc-aaad-70fb-9fc5-6de46af5c40f€49.00€0.67matched
104capture01a19acc-ae53-7e24-91ed-eeccbcd3e4ed€35.00€0.50matched
105capture01a19acc-bb67-7221-a30c-6c6eae63ca3d€35.00€0.50matched
106capture01a19acc-bb54-74fe-9cb2-52c25a5ae8ab€35.00€0.50matched
107capture01a19acc-d055-7455-a5f8-e9e965485a50€9.00€0.19matched
108capture01a19acd-018f-7d99-9d90-c38079e08d7d€24.00€0.37matched
109capture01a19acd-194a-7152-9297-f88b10fc2be9€9.00€0.19matched
110capture01a19acd-2dba-79d7-b813-9ad797e15a82€24.00€0.37matched
111capture01a19acd-36aa-7f5d-b401-b3ece2943811€35.00€0.50matched
112capture01a19acd-a0b9-7a09-9c02-cf5b1dc8ddb2€49.00€0.67matched
113capture01a19acd-a265-76cc-9ebc-798ddc687fd8€9.00€0.19matched
114capture01a19acd-a898-7f62-959c-e56b6e419507€35.00€0.50matched
115capture01a19acd-cacf-7eca-9648-00018c31a0f6€24.00€0.37matched
116capture01a19acd-d9e8-792f-9985-1c9a9dec178a€9.00€0.19matched
117capture01a19acd-f067-73be-9088-50b0021ff200€9.00€0.19matched
118capture01a19acd-f6c0-7219-9e22-09f60727d85e€15.00€0.26matched
119refund01a19ace-0134-71f7-8c63-569d9e563de6-€16.00€0.00matched
120capture01a19ace-0262-7db7-9190-6a57fda235fe€9.00€0.19matched
121refund01a19ace-1341-7a02-bb79-6c0e5035e33a-€16.00€0.00matched
122capture01a19ace-142b-7666-901e-8bfd8935e6ff€24.00€0.37matched
123refund01a19ace-40e9-7f28-8923-8ed7cb77eaa5-€20.00€0.00matched
124capture01a19ace-45ff-78a7-8240-6d4f1144e561€9.00€0.19matched
125capture01a19ace-55f5-7b79-b1a8-3e94e50d9e26€15.00€0.26matched
126capture01a19ace-68eb-7258-acd7-646ddec41857€15.00€0.26matched
127capture01a19ace-6a5f-7a6c-9d4b-bdb5393dd296€49.00€0.67matched
128capture01a19ace-7f66-7763-9c69-0bcb53987df6€24.00€0.37matched
130refund01a19ace-8bef-7427-9044-00f1f11a11d0-€12.00€0.00matched