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

1 Nov, 23:10

Gross

€2,779.00

PSP fee

€44.29

Net to the bank

€2,734.71

Settlement journal

#332759

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19965-2d08-7f13-87fb-50fc18a835e6 is already settled by stl_EUR_2989291 line 62
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 23, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • missing linein the books, not in the filecapture:01a19966-844c-7ab8-920f-8bb83f0864fa is in no file
  • missing linein the books, not in the filerefund:01a19966-880c-7c77-b877-42a8d84b3483 is in no file
LineKindReferenceGrossFeeStatus
42capture01a19963-94c9-77fb-883a-cf2958bd84c1€35.00€0.54fee difference
61capture01a19965-2679-7c74-92ce-96a79ef30b50€9.00€0.23fee difference
63capture01a19965-2d5d-75f6-a194-312050bcbd3d€15.00€0.26duplicate line
73capture01a19965-ebe4-77b6-b7ed-0c5b09f03bea€24.00€0.40fee difference
1capture01a19959-d4ef-77a2-bb78-c6d259d3a8b3€15.00€0.26matched
2capture01a1995e-0109-72cc-840d-97dddad792e8€15.00€0.26matched
3capture01a19960-9e2c-742e-b22b-56990fcf1393€9.00€0.19matched
4capture01a19960-b36a-778c-84ab-c4c52514b26d€35.00€0.50matched
5capture01a19960-c70d-7049-955d-61cd21090545€35.00€0.50matched
6capture01a19961-0138-74e5-b824-ffa2c10bfef4€15.00€0.26matched
7capture01a19961-0884-779e-bc52-48d04ef85b0b€24.00€0.37matched
8capture01a19961-37ed-741e-b980-bc7f268829c2€24.00€0.37matched
9capture01a19961-5b24-74da-bbbe-dd54fec537b8€15.00€0.26matched
10capture01a19961-715d-71fc-8b66-fe358382f177€49.00€0.67matched
11capture01a19961-8f99-7043-893d-aa9f9691b44f€35.00€0.50matched
12capture01a19961-a2cd-7c7b-8c24-cafcdb7b465a€35.00€0.50matched
13capture01a19961-a85d-7e57-ae79-8bf6a2fd0b45€15.00€0.26matched
14capture01a19961-abb5-7c5c-ac98-cf743f2fa2f1€49.00€0.67matched
15capture01a19961-b1b8-7a8a-b1a6-fef3a91d4a7a€49.00€0.67matched
16capture01a19961-e425-7a5c-a9c2-869994f66938€15.00€0.26matched
17capture01a19961-ed42-7261-8561-ef568c1846cc€35.00€0.50matched
18capture01a19962-0f63-7239-b7a9-7d0fd7184c09€49.00€0.67matched
19capture01a19962-11e9-7b88-94d5-13ee81c084fa€35.00€0.50matched
20capture01a19962-2a80-7404-90d1-fd901443ccdc€35.00€0.50matched
21capture01a19962-2f98-79b9-b285-55c17cd8e4a8€9.00€0.19matched
22capture01a19962-39a3-7d44-9a41-a01a3af32601€35.00€0.50matched
23capture01a19962-4cd6-7e4a-b4ef-e380de07d490€15.00€0.26matched
24refund01a19962-5c68-77a1-a792-77582ed0b85c-€35.00€0.00matched
25capture01a19962-5ddb-7b93-8a8b-a63f650f9798€15.00€0.26matched
26refund01a19962-61c2-79a4-b1f2-6dd0c99f5dbd-€7.00€0.00matched
27capture01a19962-63b3-77ae-9f72-2e0e0a3a4bc0€49.00€0.67matched
28capture01a19962-6613-7fe6-97fe-6b1bb0aeb45d€24.00€0.37matched
29capture01a19962-7b46-712b-bf60-31552981abf8€15.00€0.26matched
30capture01a19962-825f-7bb4-8596-7aeefd2aa92e€49.00€0.67matched
31capture01a19962-86d3-750f-86c9-c5ea36faca6f€49.00€0.67matched
32capture01a19962-ac4f-7503-8d1c-625ebacdccd5€9.00€0.19matched
33capture01a19962-db3f-7365-994a-0bdbcb35346b€49.00€0.67matched
34capture01a19962-e7fb-7e61-9454-dda0d8a149a5€35.00€0.50matched
35capture01a19962-fcb3-79fa-8996-41c2eee534f9€24.00€0.37matched
36capture01a19962-ff18-7df7-b0a9-8212ec94ce69€9.00€0.19matched
37capture01a19963-5888-7bdf-a89a-94119182ec4e€9.00€0.19matched
38capture01a19963-68db-74bc-b2ec-4583e1dfd3e9€35.00€0.50matched
39capture01a19963-788a-7d55-a7fd-336381e3b3d6€35.00€0.50matched
40capture01a19963-87f7-7693-bd16-55da9ed80d49€24.00€0.37matched
41capture01a19963-8923-7b75-9788-1b1e7c056edf€49.00€0.67matched
43capture01a19963-a545-798a-9b07-cb952e0162bf€15.00€0.26matched
44capture01a19963-c0ee-7a85-82df-3c38db5e7374€49.00€0.67matched
45capture01a19963-d6d7-740d-ba0d-410b1ca24217€35.00€0.50matched
46capture01a19963-e4c1-7c90-bcf4-8ee050c54501€9.00€0.19matched
47capture01a19963-e7e6-7043-940f-52e347dd0f29€15.00€0.26matched
48capture01a19964-4139-71ce-98f2-1e72982a2e95€15.00€0.26matched
49capture01a19964-9ef6-7262-b608-d8a67d571ea2€9.00€0.19matched
50capture01a19964-a640-70f8-8ac9-d68432564385€49.00€0.67matched
51capture01a19964-c1f1-7ec0-abdb-c8e94d7ffbdb€49.00€0.67matched
52capture01a19964-cd42-7f4c-abea-8ce53a195c2a€24.00€0.37matched
53capture01a19964-d637-7776-9df8-3fe9cc60b97d€35.00€0.50matched
54capture01a19964-d9da-7fbc-8f46-d36f0049625b€15.00€0.26matched
55capture01a19964-f3aa-7884-a89a-a8c043ab2175€9.00€0.19matched
56capture01a19965-0009-7fb0-91ba-f75674f3aeeb€15.00€0.26matched
57capture01a19965-09f5-7436-9904-3bf4f8b78016€49.00€0.67matched
58capture01a19965-157d-7a54-b973-2010306d199b€35.00€0.50matched
59capture01a19965-1c79-7ffd-b598-e4933907b1e8€24.00€0.37matched
60capture01a19965-202a-7a36-9434-bbf1928c65aa€49.00€0.67matched
62capture01a19965-2d5d-75f6-a194-312050bcbd3d€15.00€0.26matched
64capture01a19965-3f22-70b4-8b53-0e1c4cb6edfb€9.00€0.19matched
65capture01a19965-4fcc-72bc-bbc1-b5431190d536€9.00€0.19matched
66capture01a19965-5475-7796-9aaa-df3a9590dbbe€35.00€0.50matched
67capture01a19965-5f2e-7d6e-901e-2bf5d52abfbb€35.00€0.50matched
68capture01a19965-6753-782c-9767-2f9246ed4b85€35.00€0.50matched
69capture01a19965-80bb-7502-a998-fff84c8ec2cc€9.00€0.19matched
70capture01a19965-b7a5-7267-b390-d3b1e2be165d€15.00€0.26matched
71capture01a19965-dbf1-7de1-9abe-a7d3f9978c84€15.00€0.26matched
72capture01a19965-debf-7eca-bdaa-b5f6438cff50€9.00€0.19matched
74capture01a19966-261b-7165-bc0b-5e4885c33d58€35.00€0.50matched
75capture01a19966-2c73-7181-8e2e-3e613198cb64€9.00€0.19matched
76capture01a19966-321f-73ea-aaa5-d62e7c48aadd€9.00€0.19matched
77capture01a19966-5ac4-706d-9616-bdb5fd01cf05€24.00€0.37matched
78capture01a19966-63fb-7b88-8b5f-9120aa382c8c€49.00€0.67matched
79capture01a19966-8341-7604-821a-5193a54a7c7b€24.00€0.37matched
80capture01a19966-aa09-7d76-8929-e138bcd787f3€15.00€0.26matched
81capture01a19966-e604-715b-8484-4c158f1093b8€24.00€0.37matched
82capture01a19966-eea7-78c0-8d8b-a6e17faf54f3€24.00€0.37matched
83capture01a19966-ff65-794b-85e1-9481488ee141€9.00€0.19matched
84capture01a19967-1fcd-7083-91e7-bd6aad4af2ea€24.00€0.37matched
85capture01a19967-25ae-74c3-90ea-512b638d53e3€15.00€0.26matched
86capture01a19967-2919-7f99-942d-2090f67faa63€35.00€0.50matched
87refund01a19967-35a6-79fb-be37-6bbcb79e9972-€25.00€0.00matched
88capture01a19967-5e4a-79c8-a8de-54145300742d€15.00€0.26matched
89capture01a19967-6130-77e0-a7db-d506a42a018e€15.00€0.26matched
90capture01a19967-65ef-7208-9ee2-7ebb17971642€15.00€0.26matched
91capture01a19967-a570-7f42-99f6-9426cc7b0ba2€15.00€0.26matched
92capture01a19967-a95c-7340-8ac3-0d7c58c4030d€35.00€0.50matched
93capture01a19967-f7e3-75c9-88a1-a5fbfbe2d219€49.00€0.67matched
94refund01a19968-1231-7c4a-9f8b-78fdc1a40825-€3.00€0.00matched
95capture01a19968-12b7-796d-a524-18361e687bb0€24.00€0.37matched
96capture01a19968-16a6-76fc-8719-49df8a296931€24.00€0.37matched
97refund01a19968-1e82-7f2c-b0ea-8e357521f595-€24.00€0.00matched
98capture01a19968-328c-738f-9276-b2660e3f2db4€49.00€0.67matched
99capture01a19968-5a7b-7f02-8e57-d69d5ed15771€15.00€0.26matched
100capture01a19968-6213-7c94-b2e1-1598bd718d60€35.00€0.50matched
101capture01a19968-9cd2-7d40-9610-14f2ae5d4e86€35.00€0.50matched
102capture01a19968-a29f-72a8-864b-d48147cbdb94€24.00€0.37matched
103capture01a19968-aa97-793a-b6ae-3d3d4af69f7f€9.00€0.19matched
104capture01a19968-aaf1-7a45-9d45-e4e644449cb5€9.00€0.19matched
105capture01a19968-b4db-7cfa-822f-4fbbd33f028d€24.00€0.37matched
106capture01a19968-bde7-7724-acbf-ef83ec2a6972€15.00€0.26matched
107capture01a19968-c1f4-7bac-b7b5-17e1c6dd190a€35.00€0.50matched
108capture01a19968-c92f-782d-b608-e277d6bdc958€9.00€0.19matched
109capture01a19968-ebb6-7615-99ba-4ae40f857084€24.00€0.37matched
110capture01a19969-108e-7f11-bf98-9b88b9656c48€49.00€0.67matched
111capture01a19969-28c2-7477-b138-0b169224ef86€9.00€0.19matched
112capture01a19969-2b87-70c6-a312-bf33d809402e€24.00€0.37matched
113capture01a19969-37c6-77bc-adfe-cc1c53125e32€9.00€0.19matched
114capture01a19969-3c48-7d42-a6d6-393ca77bb5dc€9.00€0.19matched
115refund01a19969-4299-7852-a15b-4c38fd341eab-€32.00€0.00matched
116capture01a19969-5547-7bee-96f6-693408990591€24.00€0.37matched
117capture01a19969-641a-79a9-af9c-0b19fe27fd99€15.00€0.26matched
118capture01a19969-6e89-7622-a30d-7e01c543daf8€35.00€0.50matched
119capture01a19969-768c-75dd-b50a-b96f9c37c92d€35.00€0.50matched
120capture01a19969-8122-7702-9266-99b3b1c5e68b€15.00€0.26matched
121capture01a19969-9a69-7d56-add9-f3e37f5e9181€15.00€0.26matched