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, 16:30

Gross

€2,707.00

PSP fee

€43.35

Net to the bank

€2,663.65

Settlement journal

#345869

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • missing linein the books, not in the filecapture:01a19d1a-4a2f-7f63-82d7-4f98df6cecbc is in no file
  • missing linein the books, not in the filecapture:01a19d20-3a20-7ea0-8fc5-b852667af116 is in no file
LineKindReferenceGrossFeeStatus
123capture01a19d21-c075-73ac-bbd4-f7fa5925b087€49.00€0.72fee difference
1capture01a19d0f-b441-7d63-b2a0-d44b1986c60d€15.00€0.26matched
2capture01a19d12-42f6-708d-a603-fc266357d8f8€35.00€0.50matched
3capture01a19d12-a035-7044-8b96-933c1d2eccfa€9.00€0.19matched
4capture01a19d12-c168-7447-9cdc-151f86146d53€9.00€0.19matched
5capture01a19d18-a9a7-7d4a-ad37-cd11ea04fa71€15.00€0.26matched
6capture01a19d18-acb3-7e72-a87a-cb77dca059fc€9.00€0.19matched
7capture01a19d18-af17-7755-93e0-e5c715a7c162€49.00€0.67matched
8capture01a19d18-b273-7348-88ce-444c3d0af874€15.00€0.26matched
9capture01a19d18-c16d-747f-a3e2-bd3075f96a8c€49.00€0.67matched
10capture01a19d18-c74c-716d-b796-031f56bf97fa€49.00€0.67matched
11capture01a19d18-c8d7-71f8-84e6-6f6d79387999€24.00€0.37matched
12capture01a19d18-cc9a-7e8f-8f50-7c2ff756bcce€15.00€0.26matched
13capture01a19d18-cda0-766a-9b55-accd0ef3b29c€49.00€0.67matched
14capture01a19d18-f300-79ee-9131-d9ea906eeea0€9.00€0.19matched
15capture01a19d19-071b-73ef-90f0-ed3a5cc31325€9.00€0.19matched
16refund01a19d19-143a-76f5-89bd-5fe9f6d9bfa9-€14.00€0.00matched
17capture01a19d19-1fea-7ff2-853f-4ba996f8e33f€35.00€0.50matched
18capture01a19d19-2e76-7f69-b658-d59fb26effcb€35.00€0.50matched
19refund01a19d19-3d9e-7355-8fb7-c16bc62b6449-€3.00€0.00matched
20capture01a19d19-56b9-75bd-99c3-b6250678eb0e€9.00€0.19matched
21refund01a19d19-5c73-787f-b080-790931261043-€6.00€0.00matched
22capture01a19d19-6239-7b4d-8128-b7e175b16297€49.00€0.67matched
23capture01a19d19-7521-7ca9-866f-c53408809495€24.00€0.37matched
24refund01a19d19-88b4-771b-992a-6a561d020610-€18.00€0.00matched
25capture01a19d19-99ac-797f-80cb-f6c9bfaf75f7€49.00€0.67matched
26capture01a19d19-9b96-714c-b046-d70406863a8a€9.00€0.19matched
27capture01a19d19-ab2b-7680-932c-4a65ef21a90a€35.00€0.50matched
28capture01a19d19-cbb8-707e-80de-6783d288eb02€9.00€0.19matched
29capture01a19d19-cc75-7750-9ee8-d567132001a9€9.00€0.19matched
30capture01a19d19-d28a-70a8-a147-48f9f7713463€15.00€0.26matched
31capture01a19d19-e642-75e5-b384-fd2017808e43€9.00€0.19matched
32capture01a19d19-ecd0-7730-a843-22d226fc3fbd€49.00€0.67matched
33capture01a19d19-f171-70e3-9a6c-a5830f83b577€35.00€0.50matched
34capture01a19d19-f984-7e12-8d36-e3ef1b84fbc4€15.00€0.26matched
35capture01a19d1a-1486-722e-80fa-214545d13009€9.00€0.19matched
36capture01a19d1a-198f-7798-8c40-40086b41b331€9.00€0.19matched
37capture01a19d1a-2242-74db-a11b-51b9da6aeecb€49.00€0.67matched
38capture01a19d1a-2878-77d0-995f-c719ac7d00b8€49.00€0.67matched
39refund01a19d1a-3f6f-7727-975d-83b5c96b8caf-€2.00€0.00matched
40capture01a19d1a-4f59-70bc-b375-c7a8c1a0b398€24.00€0.37matched
41capture01a19d1a-593d-720c-a996-57c894a14523€9.00€0.19matched
42capture01a19d1a-742d-7cd8-8aa3-23d48bc90fa3€49.00€0.67matched
43capture01a19d1a-7b4b-7387-a9cf-fa2bd3f56511€9.00€0.19matched
44capture01a19d1a-7e38-75c2-b735-c41909147f6b€15.00€0.26matched
45capture01a19d1a-8dce-7f02-9744-5dbd7e468694€15.00€0.26matched
46refund01a19d1a-97d0-73ff-a2db-9cc95e0fb0f7-€7.00€0.00matched
47capture01a19d1a-a158-770a-a89d-b3eca79d0992€35.00€0.50matched
48capture01a19d1a-a458-7b5d-b51b-43595564412b€24.00€0.37matched
49capture01a19d1a-a484-76db-bcf7-d69730d3d368€9.00€0.19matched
50capture01a19d1a-a7b7-71c2-a3e2-177a4b73b972€15.00€0.26matched
51capture01a19d1a-b10a-7e1e-8d6b-e8935a6c39ac€15.00€0.26matched
52capture01a19d1a-baeb-7df7-bfc9-b188370cba1c€49.00€0.67matched
53capture01a19d1a-c9bc-79ef-8713-0c931308ecd0€9.00€0.19matched
54refund01a19d1a-d5a4-7e5d-b7a2-91e287c8a4b0-€13.00€0.00matched
55capture01a19d1b-1692-77d1-8f8d-43a9561983fd€24.00€0.37matched
56capture01a19d1b-2f56-7f25-85ac-0aeb4c49da15€49.00€0.67matched
57capture01a19d1b-2f71-7322-a8b2-567f9748a7ff€35.00€0.50matched
58capture01a19d1b-80dc-761e-9217-cf4b5a7ec6a4€9.00€0.19matched
59capture01a19d1b-9a10-7c82-a0b1-91605824f39f€15.00€0.26matched
60capture01a19d1b-b1d4-71c8-888c-0603f4d37cfd€9.00€0.19matched
61capture01a19d1b-cd24-7e68-ad32-880b6d643d46€9.00€0.19matched
62capture01a19d1b-d7f3-7344-977f-d68e8b9302b8€24.00€0.37matched
63capture01a19d1b-fc68-7cbf-b5ea-f75fc2c1eaf8€35.00€0.50matched
64capture01a19d1c-0dbc-71c5-91a6-0903b097467e€9.00€0.19matched
65capture01a19d1c-3a3e-762b-bd5d-21da39655114€24.00€0.37matched
66capture01a19d1c-3e93-7937-87ff-0879b797aa49€35.00€0.50matched
67capture01a19d1c-735c-7a3d-9c74-f408ab29aa7c€15.00€0.26matched
68capture01a19d1c-91e7-71aa-9f5a-2f32d3329d8a€35.00€0.50matched
69capture01a19d1c-a0a7-7102-99fa-2b8d9fb37297€9.00€0.19matched
70capture01a19d1c-d6dc-7ec8-a3d5-cd824f18284d€24.00€0.37matched
71capture01a19d1c-f2ca-7efb-9752-5f8af87b8ac4€49.00€0.67matched
72capture01a19d1d-0063-7ec9-bd53-d8bbabd40622€9.00€0.19matched
73capture01a19d1d-0f2b-7a57-89e1-62d199087bae€24.00€0.37matched
74capture01a19d1d-47a4-7026-82d3-d01ac86fc838€35.00€0.50matched
75capture01a19d1d-50df-7d8f-855c-215b5783525b€15.00€0.26matched
76capture01a19d1d-6531-7699-bbb8-1e78d58a5ddd€35.00€0.50matched
77capture01a19d1d-7436-762c-aaba-0cb45827b0e4€35.00€0.50matched
78capture01a19d1d-7c25-72c5-b146-d5ab7e057024€49.00€0.67matched
79capture01a19d1d-a2ad-7289-ad72-608a683c8f02€9.00€0.19matched
80capture01a19d1d-b3a5-7048-bea4-7b9b03cba0fa€15.00€0.26matched
81capture01a19d1d-b63d-72fe-ba65-ed228a1f39ee€49.00€0.67matched
82capture01a19d1d-bb48-7800-84f1-0aba7ea26498€9.00€0.19matched
83capture01a19d1d-ce1c-74b8-a9b7-78183896e40d€9.00€0.19matched
84capture01a19d1d-d4a6-7560-9d46-3f8d4762fc97€24.00€0.37matched
85refund01a19d1d-dee4-71b2-af82-e1b8a0466bfd-€10.00€0.00matched
86capture01a19d1d-fde0-70ab-9022-4ea2b20d4814€9.00€0.19matched
87capture01a19d1e-368f-75ce-918c-ae86e38bbba6€9.00€0.19matched
88capture01a19d1e-3cb9-7ab3-b227-3427809346f3€49.00€0.67matched
89capture01a19d1e-69df-7d3d-9adc-6fc612ec6aaf€35.00€0.50matched
90refund01a19d1e-7742-7c98-b01e-52dad5e60bb6-€3.00€0.00matched
91capture01a19d1e-775f-7614-8f1a-9bb0fe8ce474€35.00€0.50matched
92capture01a19d1e-8202-7e4d-870e-7f6237f79b9c€24.00€0.37matched
93capture01a19d1e-8273-79f7-bb0f-3fd504bcaf2d€35.00€0.50matched
94capture01a19d1e-879f-7808-b54c-5d597d13bfff€49.00€0.67matched
95capture01a19d1f-18e6-7bad-b51e-f4efa4a6c7b9€35.00€0.50matched
96capture01a19d1f-6144-773c-bf23-ddd09803987c€24.00€0.37matched
97capture01a19d1f-6467-7fa7-b4b5-897b824852b1€24.00€0.37matched
98refund01a19d1f-773c-7f8d-97f3-b0f678793139-€31.00€0.00matched
99capture01a19d1f-8578-7725-9a8a-f15c274fb347€49.00€0.67matched
100capture01a19d1f-a5ed-7595-9b56-58b8f2e56afb€49.00€0.67matched
101capture01a19d1f-a73e-7f20-a79d-663242a9da38€35.00€0.50matched
102capture01a19d1f-b080-79be-b6f2-409814603dba€49.00€0.67matched
103refund01a19d20-1010-7f8e-ba2b-0c01d39d20d2-€27.00€0.00matched
104capture01a19d20-2122-7707-930c-b80431533f48€9.00€0.19matched
105capture01a19d20-3563-7925-946e-e540d4e6216b€9.00€0.19matched
106capture01a19d20-7540-71c3-9860-8b36ca5a3860€15.00€0.26matched
107capture01a19d20-7b7b-7876-8777-90dea45c903f€24.00€0.37matched
108capture01a19d20-8b6f-7e72-bbc2-a98b6eb8cf68€49.00€0.67matched
109capture01a19d20-87f9-7cd2-8050-7fc516180fef€24.00€0.37matched
110capture01a19d20-8cea-7e28-89bb-351c71f68387€9.00€0.19matched
111capture01a19d20-a3de-73c0-8956-77bb2ecb91dc€15.00€0.26matched
112capture01a19d20-b971-7029-a02a-a80aeb28f6ab€49.00€0.67matched
113capture01a19d20-e30b-7e04-ac5f-15b5c2d57278€24.00€0.37matched
114refund01a19d20-fca1-749c-ba54-4645f9333151-€15.00€0.00matched
115capture01a19d21-04a5-7bc7-b473-1097cefe3cec€35.00€0.50matched
116capture01a19d21-14e2-7943-bebf-3006df2f61a2€35.00€0.50matched
117capture01a19d21-40d7-7e3f-99c8-781d4e29cffd€24.00€0.37matched
118capture01a19d21-4401-748f-a1b3-acfc84b045ee€35.00€0.50matched
119capture01a19d21-45a3-7701-804e-eb9254a1e238€24.00€0.37matched
120capture01a19d21-561a-7e2a-9ca4-e605a300771e€24.00€0.37matched
121capture01a19d21-6773-79ff-b670-bd455fc98dda€35.00€0.50matched
122refund01a19d21-8766-7dac-80f3-f6e607416b68-€7.00€0.00matched