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

29 Oct, 10:10

Gross

€3,235.00

PSP fee

€50.73

Net to the bank

€3,184.27

Settlement journal

#268020

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a18727-38f8-743e-b4ae-1b721541ea9a is already settled by stl_EUR_2988781 line 62
  • duplicate linethe file lists it twicecapture:01a18728-4280-7c80-a344-41cf6f9845e5 is already settled by stl_EUR_2988781 line 74
  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
LineKindReferenceGrossFeeStatus
58capture01a18727-215d-7505-93ff-5495a5ec4ad1€15.00€0.31fee difference
63capture01a18727-5526-766e-9117-a5f8a5d00389€15.00€0.26duplicate line
75capture01a18728-4316-7738-bc8d-2cd43d0ff058€35.00€0.50duplicate line
1capture01a1871c-4e71-77be-a0f8-6be897bd077f€35.00€0.50matched
2capture01a1871e-4b0b-704c-a66e-efd1768a4641€49.00€0.67matched
3capture01a18721-67e9-7db3-87db-afdbfd88aba5€35.00€0.50matched
4refund01a18723-5af8-7bec-a72d-cc24e03389cc-€20.00€0.00matched
5capture01a18723-9645-7e98-a63f-f870e60cfed0€9.00€0.19matched
6capture01a18723-9edc-7bcf-8a60-cec1c8e6a48e€24.00€0.37matched
7capture01a18723-ae99-7c83-bddd-ca0fc3b5572c€49.00€0.67matched
8capture01a18723-c973-71d4-8e62-d9e86a93898b€49.00€0.67matched
9capture01a18723-f159-7530-b0f5-46bd4290b4b5€35.00€0.50matched
10capture01a18724-0f89-7d9e-9543-6386c3d1b85f€49.00€0.67matched
11capture01a18724-1309-7f25-8700-369f8abe7cf3€24.00€0.37matched
12capture01a18724-251e-7bf2-9c40-276946fb1468€35.00€0.50matched
13capture01a18724-3538-765b-a8c1-9be78fc69918€9.00€0.19matched
14capture01a18724-35b5-7d03-83cd-82a0ee1bf065€9.00€0.19matched
15capture01a18724-4c61-7d92-8be1-bc2409a6367d€35.00€0.50matched
16capture01a18724-6274-716a-8b53-fa6ceb86ac41€15.00€0.26matched
17refund01a18724-67ca-70a1-afbd-6328458a373c-€14.00€0.00matched
18capture01a18724-6a10-7b87-a4fe-23a9733036ad€35.00€0.50matched
19capture01a18724-893f-70eb-b79a-b2917c038d8d€49.00€0.67matched
20capture01a18724-aed1-7d2f-b6a8-e24ca0de3a96€49.00€0.67matched
21capture01a18724-b4eb-77ac-ac0f-c04d197831a3€24.00€0.37matched
22capture01a18724-b90b-7273-81a3-33b9951ce132€35.00€0.50matched
23capture01a18724-c5db-7d1d-bab2-e219fe0b45af€49.00€0.67matched
24capture01a18724-e1e0-7a58-8dfb-09960ab064c8€24.00€0.37matched
25capture01a18724-e463-73dc-9ec6-b94bbed72c37€49.00€0.67matched
26capture01a18725-10d4-775c-94cd-4ae90cd8fcf4€35.00€0.50matched
27capture01a18725-12eb-7496-8448-88ecb1a459cd€9.00€0.19matched
28capture01a18725-3f98-75ff-aba4-85c7254ccb51€15.00€0.26matched
29capture01a18725-555d-784e-89bf-3dece091f6fe€15.00€0.26matched
30capture01a18725-5c4f-7535-9206-59a1f56dbc62€35.00€0.50matched
31capture01a18725-6363-7a44-86ce-ea82f06245f5€35.00€0.50matched
32capture01a18725-6bcd-7aa0-b8f8-85de82a2fff6€9.00€0.19matched
33capture01a18725-8959-7c14-bfe0-1f4bc35a1217€49.00€0.67matched
34capture01a18725-9081-72c8-a58c-2a252fe4cdf1€15.00€0.26matched
35capture01a18725-94f5-7541-890b-4c71e7b48069€49.00€0.67matched
36capture01a18725-abbd-725f-84c0-414d8275a5bd€9.00€0.19matched
37capture01a18725-bbde-7bb8-a6e4-2ccf76da5c21€49.00€0.67matched
38capture01a18725-c62c-7613-aeae-83277d95f670€24.00€0.37matched
39refund01a18725-c64f-77ec-abe0-8903d7e73564-€21.00€0.00matched
40capture01a18725-d0cc-77d7-b2e2-5e03f7bc818b€15.00€0.26matched
41capture01a18725-e339-72c1-bd9e-40f6f0830466€15.00€0.26matched
42capture01a18725-f0ea-7b9f-9ef3-0bcb1ccea655€49.00€0.67matched
43refund01a18726-216c-7ea2-ba60-2f5dc91c7130-€10.00€0.00matched
44capture01a18726-22ce-77ac-9c0a-bb3c860265fb€24.00€0.37matched
45capture01a18726-37d5-705d-a367-9041539cf637€35.00€0.50matched
46capture01a18726-55d5-721b-9e48-f31a4e8b54ce€15.00€0.26matched
47capture01a18726-583d-733b-8f2d-831579a3948b€49.00€0.67matched
48capture01a18726-5d61-77ce-a823-4c0f310181e5€15.00€0.26matched
49capture01a18726-6bd0-74b8-a165-ff9a308697a1€24.00€0.37matched
50capture01a18726-74a8-7459-80df-7510842d5a00€9.00€0.19matched
51capture01a18726-8080-7747-a501-e13afa5c0cf4€49.00€0.67matched
52refund01a18726-8408-761f-b377-a74298c651dd-€8.00€0.00matched
53capture01a18726-b7cb-7d8e-b1c7-113bb48ca78e€35.00€0.50matched
54capture01a18726-c1b4-7a11-bfff-5d937756c184€24.00€0.37matched
55capture01a18726-d91d-7b83-bc5d-7a8ea90b5c5f€49.00€0.67matched
56capture01a18726-e888-7130-b270-1d7494747a7d€24.00€0.37matched
57capture01a18727-0c0f-7fc6-bace-12005454e651€15.00€0.26matched
59capture01a18727-25fe-7576-9ae4-86567b54aee4€35.00€0.50matched
60capture01a18727-4416-7ea4-8a46-e7ceeb9e6666€49.00€0.67matched
61capture01a18727-4a9d-73a9-9e89-7973c36d5217€15.00€0.26matched
62capture01a18727-5526-766e-9117-a5f8a5d00389€15.00€0.26matched
64refund01a18727-7186-7768-bac1-ee94c5d239b6-€33.00€0.00matched
65capture01a18727-8a71-7ca9-89d3-7aa38f792de7€15.00€0.26matched
66capture01a18727-a3c8-7e8c-9208-c0923d9f7fb6€9.00€0.19matched
67capture01a18727-acf7-7579-94cc-3e9c036658ff€35.00€0.50matched
68capture01a18727-b691-7d6d-a813-3eab3833ad4c€9.00€0.19matched
69refund01a18727-b9e6-7396-abe5-1910db126260-€5.00€0.00matched
70capture01a18727-ce94-7bdb-872b-6b93a61d01ae€24.00€0.37matched
71capture01a18727-e521-7f03-bc28-b4bc9cfb311a€35.00€0.50matched
72capture01a18727-fdcd-784d-99fc-2123de725257€24.00€0.37matched
73capture01a18728-1bd5-76c0-9ed9-8b1e1b7136c9€35.00€0.50matched
74capture01a18728-4316-7738-bc8d-2cd43d0ff058€35.00€0.50matched
76capture01a18728-4d56-7c09-8f1b-6b6994622cf3€49.00€0.67matched
77refund01a18728-4ff2-7c3e-a6a2-3b7ffe062e25-€33.00€0.00matched
78capture01a18728-595b-7d06-9728-2ca1809106cb€35.00€0.50matched
79capture01a18728-7ee8-7191-a494-4b781db924c7€9.00€0.19matched
80capture01a18728-9a6f-7621-8334-01bc494e81ee€35.00€0.50matched
81capture01a18728-9b3b-7425-9767-ddf6b0daeafc€24.00€0.37matched
82capture01a18728-d4e9-719a-8188-32a76d018256€9.00€0.19matched
83refund01a18728-f574-71a1-919c-15e06b790814-€9.00€0.00matched
84capture01a18728-f7aa-7f0b-aeef-c2c684c938e0€49.00€0.67matched
85capture01a18728-f9cf-7c9d-910a-3d0bf45b3419€24.00€0.37matched
86capture01a18729-100c-7c80-9f86-ba14a8dc85bd€24.00€0.37matched
87capture01a18729-2b02-7476-80ef-0cc1d06d93ce€49.00€0.67matched
88capture01a18729-2bb7-7c9f-87e6-2b74afd1d23f€9.00€0.19matched
89capture01a18729-359c-778b-ac11-b1fb35265b4c€49.00€0.67matched
90capture01a18729-38b6-7f6e-a678-4815c7db7130€15.00€0.26matched
91refund01a18729-39be-7c47-bfbb-4eb40a89819c-€13.00€0.00matched
92capture01a18729-49a4-7a86-ab24-a834357a8fef€49.00€0.67matched
93capture01a18729-4b75-71df-abfb-f71a6da155d9€35.00€0.50matched
94capture01a18729-55d2-71a5-bff0-f6f1be881e5b€24.00€0.37matched
95capture01a18729-693c-76b3-b1c7-caee51b341ab€49.00€0.67matched
96refund01a18729-82cf-7c8a-8200-cdbc92544628-€18.00€0.00matched
97capture01a18729-85c6-74ee-a848-6ae57583dc45€15.00€0.26matched
98capture01a18729-8359-7962-b2f2-61e454783dc4€15.00€0.26matched
99capture01a18729-a352-7cf9-9357-7dc3c84fad79€49.00€0.67matched
100capture01a18729-a4d0-7693-a327-7692e1591589€49.00€0.67matched
101capture01a18729-c256-76cf-b3dc-f35d8203faff€15.00€0.26matched
102capture01a18729-caa6-7a38-b53d-babcab96a4fa€15.00€0.26matched
103capture01a18729-d5b0-766a-b6e3-833b3622723f€24.00€0.37matched
104capture01a18729-e7a4-728f-846d-25386f2f3982€9.00€0.19matched
105capture01a18729-e8ba-7c03-9765-c97fde73e666€49.00€0.67matched
106capture01a18729-f64d-7b61-86c8-ef2b48947220€15.00€0.26matched
107capture01a1872a-0aa2-7fe8-b00a-da9096547d51€35.00€0.50matched
108capture01a1872a-228b-787d-930c-724dba19ad34€49.00€0.67matched
109capture01a1872a-24bf-7dbc-bb84-f86e7cecfe1e€35.00€0.50matched
110capture01a1872a-aa55-7aa8-8f1d-544a43c21c32€49.00€0.67matched
111capture01a1872a-ada4-77fe-8fbc-bef0f0b9064f€35.00€0.50matched
112capture01a1872a-e5e3-7eb0-bb57-b41988c7533d€15.00€0.26matched
113capture01a1872a-fb1f-792b-a234-2c206c3e6516€9.00€0.19matched
114capture01a1872b-00c7-7892-9528-03caf3784c5f€35.00€0.50matched
115capture01a1872b-12f1-77ed-a55b-3aac89e7a24a€15.00€0.26matched
116capture01a1872b-21f9-77e4-8d3a-954b78dd7e0d€15.00€0.26matched
117capture01a1872b-2551-78d5-af12-cc3dd9ec7c9f€35.00€0.50matched
118capture01a1872b-3262-750c-bbe8-84714332a08e€9.00€0.19matched
119capture01a1872b-4507-7000-a502-fe522f98122a€49.00€0.67matched
120capture01a1872b-64c6-7931-9114-b8be796d8115€49.00€0.67matched
121capture01a1872b-78ed-7826-bcc9-2cefec0d7105€35.00€0.50matched
122capture01a1872b-c11e-735d-b5ff-a5558117870d€49.00€0.67matched
123capture01a1872b-d400-709a-b46d-09130d0ac970€9.00€0.19matched
124capture01a1872b-e41d-71c4-9946-11dd01c8a113€35.00€0.50matched
125capture01a1872b-e6dc-7eba-ba79-377e93ab74c7€24.00€0.37matched
126capture01a1872b-ef8c-7c60-8e65-f5ddb9c6fbf0€24.00€0.37matched
127capture01a1872c-07c9-7fbe-82f9-6a1875c62dd0€15.00€0.26matched
128capture01a1872c-4e8a-7dff-ab72-166dbb0a1d5a€15.00€0.26matched
129capture01a1872c-54d8-702b-9950-f10d4ea7d3b8€9.00€0.19matched
130capture01a1872c-5f25-7104-ad90-1706d5ffb118€9.00€0.19matched