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

Gross

€2,363.00

PSP fee

€37.48

Net to the bank

€2,325.52

Settlement journal

#338600

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19b14-3785-7cd1-8002-3a0ee207beec is already settled by stl_EUR_2989338 line 60
  • fee differencethe fee is not the contract feethe fee is 71, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 53, the contract says 50
  • missing linein the books, not in the filecapture:01a19b16-582c-7c01-82ad-daf59c8886df is in no file
LineKindReferenceGrossFeeStatus
37capture01a19b12-1dd3-780b-adc0-1c62fee710b0€49.00€0.71fee difference
61capture01a19b14-54ac-7f65-bfbb-79bafc7ee049€35.00€0.50duplicate line
94capture01a19b16-e8dc-718b-a028-0a377ff9a286€35.00€0.53fee difference
1capture01a19b09-544f-7e27-909f-5336bb9f2c8a€24.00€0.37matched
2capture01a19b09-84cb-7e36-bb74-48fed7824a23€24.00€0.37matched
3capture01a19b0e-d0e1-7a1e-8033-5d0aba342a52€35.00€0.50matched
4capture01a19b0e-d81c-753c-86c7-734b9eaaef38€35.00€0.50matched
5capture01a19b0e-f72a-7714-b483-e11d4840a603€49.00€0.67matched
6capture01a19b0f-1e63-79f8-bcc5-f94e02a6c832€24.00€0.37matched
7capture01a19b0f-1ed0-78c4-9385-ca7c8fcef62e€24.00€0.37matched
8refund01a19b0f-20af-7e3d-bf82-a4edd63054aa-€29.00€0.00matched
9capture01a19b0f-3977-7422-8720-71b934dbbfd1€15.00€0.26matched
10capture01a19b0f-b5a2-72d6-9033-6523ce9b42bd€15.00€0.26matched
11capture01a19b0f-c170-702c-b502-52e23c8d998b€24.00€0.37matched
12capture01a19b0f-c786-7e3d-98a8-4113309927dd€24.00€0.37matched
13capture01a19b0f-cf99-7ffe-90f5-5304e37ae120€15.00€0.26matched
14capture01a19b10-1d01-7430-b28e-c2eea33d9ad5€24.00€0.37matched
15capture01a19b10-2a7c-7e07-9795-e39bd17a52bd€9.00€0.19matched
16capture01a19b10-2bfd-7edb-94e5-15178f202799€9.00€0.19matched
17capture01a19b10-5b3e-75c4-85f0-cd72b8ff79d5€9.00€0.19matched
18capture01a19b10-5cc7-7186-9cac-afe895557dfa€9.00€0.19matched
19capture01a19b10-77e0-702a-aace-8e8ebf8e6070€24.00€0.37matched
20capture01a19b10-b451-71a2-bee1-90fd44a8a898€24.00€0.37matched
21capture01a19b10-bf70-7b8c-ab57-87ddaefe4b3e€35.00€0.50matched
22capture01a19b10-c764-763c-a559-056727497740€9.00€0.19matched
23capture01a19b10-e2a3-7037-b8a7-d05b31482e0b€15.00€0.26matched
24refund01a19b10-eb04-77ca-99ff-038f7a1a66ca-€8.00€0.00matched
25capture01a19b11-0126-70b8-aadb-d2aa5a87eeed€15.00€0.26matched
26capture01a19b11-1b76-7911-a22e-3db72d933882€49.00€0.67matched
27capture01a19b11-1ba4-76f4-aa10-bd05b66b78ab€24.00€0.37matched
28capture01a19b11-3d7a-7499-a759-36db15278f9e€24.00€0.37matched
29capture01a19b11-6ab7-7f9c-b557-eacc112441d0€15.00€0.26matched
30capture01a19b11-8244-7285-8396-5fec1a389445€49.00€0.67matched
31capture01a19b11-91f3-7d2e-9478-c70dd464a597€9.00€0.19matched
32capture01a19b11-91fd-72e4-b5e1-95440cb4b924€24.00€0.37matched
33capture01a19b11-92ad-7929-8e80-d10831ef57eb€24.00€0.37matched
34capture01a19b11-a9e7-7b9a-98f3-5a87cbf2de96€15.00€0.26matched
35capture01a19b11-d4ed-7f70-983d-0d1a92ac6921€15.00€0.26matched
36capture01a19b11-ff86-7429-b81e-c6418b146b21€15.00€0.26matched
38capture01a19b12-4f50-7860-9b90-d8e432d71ff3€24.00€0.37matched
39capture01a19b12-6739-7ccf-9f5b-b09caa26e195€24.00€0.37matched
40capture01a19b12-9742-7d97-aecd-4a43ff1ba5c8€9.00€0.19matched
41capture01a19b12-a0c5-7333-aee3-cff553c28b79€49.00€0.67matched
42capture01a19b12-a142-7b8c-9c0c-e46201287c3b€35.00€0.50matched
43capture01a19b12-a5e1-7a3f-97d1-7335aa405588€9.00€0.19matched
44capture01a19b12-b12c-77f4-8c15-edc1ddcc8a33€24.00€0.37matched
45capture01a19b12-ba8c-7187-a8ca-4647eb4e6139€9.00€0.19matched
46capture01a19b12-d17b-777d-9095-413d2f127a94€9.00€0.19matched
47capture01a19b12-ee2a-78ef-993e-10787cf0f346€9.00€0.19matched
48refund01a19b13-09b4-795d-8b1e-2d90b20b56d7-€10.00€0.00matched
49capture01a19b13-0de9-7dcd-890e-01aec05e077e€9.00€0.19matched
50capture01a19b13-7101-7760-a60d-902404cfbe96€15.00€0.26matched
51capture01a19b13-8708-7e14-be1f-22ebf6b90466€49.00€0.67matched
52capture01a19b13-8e68-7e0c-950e-906429448a36€9.00€0.19matched
53capture01a19b13-cdd6-7780-b893-95be95aad076€35.00€0.50matched
54capture01a19b13-dcd3-7290-b79a-34122262a8b0€15.00€0.26matched
55capture01a19b13-ff30-7591-a80e-838cbec9bb83€9.00€0.19matched
56capture01a19b14-1058-793e-90b0-07be00ce5477€35.00€0.50matched
57capture01a19b14-1f6b-76e4-b0f7-19e1784c8b7e€15.00€0.26matched
58capture01a19b14-40f5-7fe3-a096-a37b10679ca7€15.00€0.26matched
59capture01a19b14-4ab1-7ca9-881d-7106436bef90€49.00€0.67matched
60capture01a19b14-54ac-7f65-bfbb-79bafc7ee049€35.00€0.50matched
62capture01a19b14-8328-783a-9616-659bac966824€15.00€0.26matched
63capture01a19b14-839c-7966-8e9a-140d7ad4061c€15.00€0.26matched
64capture01a19b14-8be5-74f6-9ade-d9efed9d2f81€15.00€0.26matched
65capture01a19b14-97cf-792e-b1cd-74e89423b8df€9.00€0.19matched
66capture01a19b14-a694-70c9-816c-9d70cb226be3€15.00€0.26matched
67capture01a19b14-db8e-7cb8-b7c8-59bffaaad050€15.00€0.26matched
68refund01a19b14-f7df-718a-b723-2d77f7d98ee0-€4.00€0.00matched
69capture01a19b14-f7e0-7f94-b82d-d288e161566e€35.00€0.50matched
70capture01a19b15-1bac-702c-8f11-50e0d8ea5a75€9.00€0.19matched
71capture01a19b15-1d19-7429-bcb2-fc1c0e769f62€35.00€0.50matched
72capture01a19b15-5da6-7fd1-b13e-e6d7a5204a8b€9.00€0.19matched
73capture01a19b15-71dc-7a11-a03e-56518fa8b873€9.00€0.19matched
74capture01a19b15-828b-731b-b8b4-cb5f57a47d41€15.00€0.26matched
75capture01a19b15-8d5e-746a-ae76-252aa74816f5€9.00€0.19matched
76capture01a19b15-a002-74d2-a0f9-26974f841416€15.00€0.26matched
77capture01a19b15-a68e-7a36-a238-4a1d7b772bee€24.00€0.37matched
78capture01a19b15-acb5-788a-88ca-b66098ea049d€9.00€0.19matched
79capture01a19b15-dbc2-731a-9c7b-f287b8d3f2af€9.00€0.19matched
80capture01a19b15-feae-7ff3-aa06-9f921bb76514€9.00€0.19matched
81capture01a19b16-097f-798c-8d4a-545f77589b80€35.00€0.50matched
82capture01a19b16-0be6-70d6-b1ba-0652f61aeb27€9.00€0.19matched
83capture01a19b16-173e-713e-a43a-dc0f8c3ff4f4€24.00€0.37matched
84capture01a19b16-1c10-7891-9ad2-ba9f52ad468e€15.00€0.26matched
85capture01a19b16-3341-7455-8fea-780acc2a9bf3€49.00€0.67matched
86capture01a19b16-562d-70a7-ac8d-e35532391a0c€15.00€0.26matched
87capture01a19b16-568c-7098-b84f-5a38bd542971€24.00€0.37matched
88capture01a19b16-6405-7a90-9d36-71546a9b505f€9.00€0.19matched
89capture01a19b16-be47-7bc7-875c-4d96b8a2e55b€15.00€0.26matched
90capture01a19b16-c94f-76ed-abee-944bb0b11572€9.00€0.19matched
91capture01a19b16-d6c5-7568-aab3-82a16f93a580€15.00€0.26matched
92capture01a19b16-d9fe-77b4-a33f-bd7dd89430bd€35.00€0.50matched
93capture01a19b16-e246-75e8-8d64-f50b15ba7d58€35.00€0.50matched
95capture01a19b16-ff7f-74a1-8905-181209953622€49.00€0.67matched
96capture01a19b17-0edc-76f6-a758-f890ef36e181€35.00€0.50matched
97capture01a19b17-302f-7db4-b18b-a03101294463€35.00€0.50matched
98capture01a19b17-3100-7109-9e7e-c04936a7f0fc€24.00€0.37matched
99capture01a19b17-42a3-7c14-b922-5ac2a870d1b3€24.00€0.37matched
100capture01a19b17-5e2b-783a-8782-ab8eefe5064b€49.00€0.67matched
101capture01a19b17-6bb8-7c88-bf70-9445b65d8454€24.00€0.37matched
102capture01a19b17-8848-7600-bcbb-4aac002a8dcc€49.00€0.67matched
103capture01a19b17-97a5-7fa4-994a-d23ecee98864€35.00€0.50matched
104capture01a19b17-9f1e-7bd4-8fb3-5b6f9811e527€49.00€0.67matched
105capture01a19b17-ab7a-74d9-b977-83dcf2170c7e€24.00€0.37matched
106capture01a19b17-b5b4-75ae-b9ee-a9bc02f1fe8a€35.00€0.50matched
107capture01a19b17-c73b-7f88-8f1d-8316a927896a€35.00€0.50matched
108capture01a19b17-ddff-7a4a-92b2-90d63033b88d€24.00€0.37matched