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

3 Nov, 13:00

Gross

€2,615.00

PSP fee

€41.91

Net to the bank

€2,573.09

Settlement journal

#361511

Every line paired with the books, and every capture and refund of the day is in the file.

LineKindReferenceGrossFeeStatus
1capture01a1a17b-413d-771f-bf05-2c418199cc47€15.00€0.26matched
2capture01a1a17e-e08f-7cd1-becd-6ef70fa968de€15.00€0.26matched
3capture01a1a17e-e22b-7d7d-9a3e-e361445be5e3€9.00€0.19matched
4capture01a1a17e-ea4d-73ba-ba40-2c78abf55f2e€49.00€0.67matched
5capture01a1a17e-f580-728f-85f0-d6640aa28ad8€49.00€0.67matched
6capture01a1a17f-005f-75f4-b5c7-572f34861968€15.00€0.26matched
7capture01a1a17f-0995-74a6-acc4-3301e60f44ae€15.00€0.26matched
8capture01a1a17f-15d4-7199-90a3-de80bb6673fa€35.00€0.50matched
9refund01a1a17f-3873-7b00-b022-027baff18572-€9.00€0.00matched
10capture01a1a17f-3b64-729f-8d39-55c6432d2141€35.00€0.50matched
11capture01a1a17f-460b-72a0-93e7-9dee14ef7c9f€24.00€0.37matched
12capture01a1a17f-66bd-74a7-8a14-8a85cb54f568€49.00€0.67matched
13capture01a1a17f-7267-78f5-a0d0-10e06373f7f3€35.00€0.50matched
14capture01a1a17f-7872-72ba-a59e-9e5e30afecee€24.00€0.37matched
15capture01a1a17f-794f-7dfc-999d-4956fdce5c3e€24.00€0.37matched
16refund01a1a17f-b3b1-7367-9ce5-fc120d30d2c1-€14.00€0.00matched
17capture01a1a17f-cfc2-747a-a3ef-80b697b69f9b€35.00€0.50matched
18capture01a1a17f-d088-7c09-a8f4-4fb9cc60ce99€15.00€0.26matched
19capture01a1a17f-e663-7eef-869f-ddc570934094€49.00€0.67matched
20refund01a1a17f-fbd8-76e8-befc-77ab2e532118-€32.00€0.00matched
21capture01a1a180-010b-7bff-82e0-ebaa4dfb66e6€49.00€0.67matched
22capture01a1a180-41a6-722e-a022-f60aba3acd09€9.00€0.19matched
23capture01a1a180-45f7-7280-9de5-2261cbbcd792€24.00€0.37matched
24capture01a1a180-5288-76d5-be1e-b0823b108991€24.00€0.37matched
25capture01a1a180-77de-74c8-bb1f-71f73f5b0759€35.00€0.50matched
26capture01a1a180-88b6-7f0f-ad70-342141908012€9.00€0.19matched
27capture01a1a180-db35-74da-b0b9-9241c63ec0de€24.00€0.37matched
28capture01a1a180-dd44-7d41-8e63-e174ef737ca4€15.00€0.26matched
29capture01a1a180-e9ea-74e6-8cb6-7617d689111e€49.00€0.67matched
30capture01a1a180-f0f8-7834-9792-341feef16605€49.00€0.67matched
31capture01a1a180-fcd9-7030-994b-ca52cb5f6460€9.00€0.19matched
32capture01a1a181-0adf-769c-a2a3-a4400cc1c5bb€49.00€0.67matched
33refund01a1a181-13e7-7d4b-a08f-f500ea99bda0-€12.00€0.00matched
34capture01a1a181-23db-7283-aabe-05021176858f€49.00€0.67matched
35refund01a1a181-3aba-79b1-a1f7-1c274c05a799-€25.00€0.00matched
36capture01a1a181-3cf9-7cea-a8d1-cc96096c0205€9.00€0.19matched
37capture01a1a181-3653-7812-93b6-5241571227a3€24.00€0.37matched
38capture01a1a181-4489-7536-a48b-bd60d46e9458€49.00€0.67matched
39capture01a1a181-5629-7e4c-bdde-70a228bea0f4€35.00€0.50matched
40capture01a1a181-5901-7761-98ec-0ea5017669b6€24.00€0.37matched
41capture01a1a181-5903-79be-9e81-dd261f14ad3e€15.00€0.26matched
42capture01a1a181-7111-78b9-8aff-2e592f8fe412€35.00€0.50matched
43capture01a1a181-72e2-704a-9c47-9e4c952bc128€15.00€0.26matched
44capture01a1a181-8142-7ed1-a74d-ba6a93d4c477€9.00€0.19matched
45capture01a1a181-ace0-772c-84e0-ad8398d8fd4e€9.00€0.19matched
46capture01a1a181-cf1d-703d-9c09-d74553f92f95€49.00€0.67matched
47capture01a1a181-d9e8-708e-92dc-b9089dae7ac2€15.00€0.26matched
48capture01a1a181-f63d-7300-9cd2-cdb621d82b42€49.00€0.67matched
49capture01a1a181-fd7e-7eda-bcfa-da8812f0d465€49.00€0.67matched
50capture01a1a182-0327-7bfb-bbf5-c6e2ffbbdec5€35.00€0.50matched
51capture01a1a182-38e0-789c-81f7-3ed424381b76€49.00€0.67matched
52capture01a1a182-5024-792b-8e2e-f1fc93f297d3€24.00€0.37matched
53capture01a1a182-6c2b-76bf-8937-98de9848de8f€24.00€0.37matched
54capture01a1a182-6fd0-78e3-87a1-8b6055870b51€15.00€0.26matched
55capture01a1a182-7741-7d87-9587-b56a419905a3€24.00€0.37matched
56refund01a1a182-9bd9-7752-b358-eb22069340d6-€27.00€0.00matched
57capture01a1a182-a08e-7691-90f9-84d91a9c7031€15.00€0.26matched
58capture01a1a182-a150-7ef0-8666-f08ffba37f76€15.00€0.26matched
59capture01a1a182-d332-74b8-bb8c-d761f2b43e65€15.00€0.26matched
60capture01a1a183-1495-77c2-ac6a-47a7477d6e2a€24.00€0.37matched
61capture01a1a183-4acc-77f5-99c7-de32453c3a43€15.00€0.26matched
62capture01a1a183-4e0c-70c2-bafa-be7fb78958fb€49.00€0.67matched
63capture01a1a183-53ce-7b61-93a4-e877b39b341f€24.00€0.37matched
64capture01a1a183-5987-7fc2-8ebe-1b353f02672d€35.00€0.50matched
65capture01a1a183-63a5-76c5-90e1-8019c26571f3€9.00€0.19matched
66capture01a1a183-8a5a-7d1b-82a5-764e6a6bf381€49.00€0.67matched
67refund01a1a183-94eb-7ea8-99c4-524306562c5d-€37.00€0.00matched
68refund01a1a183-bf50-7d23-867a-7e252861e3f6-€15.00€0.00matched
69refund01a1a183-d5b6-7e98-acb7-46751d75cfe9-€2.00€0.00matched
70capture01a1a183-fcb1-7625-9e7b-e223281e7318€24.00€0.37matched
71capture01a1a184-2384-7e39-9eea-491e96e6dbe8€24.00€0.37matched
72capture01a1a184-3f1a-7c2a-a52a-5afe29843f46€49.00€0.67matched
73capture01a1a184-4805-77d0-9ec3-04f35d4a68e6€24.00€0.37matched
74capture01a1a184-6dc2-7474-8f6b-bfea886d5b89€49.00€0.67matched
75capture01a1a184-80b1-7081-84bf-da96dff95470€15.00€0.26matched
76capture01a1a184-a692-712d-bb4c-3914b7e3a415€24.00€0.37matched
77refund01a1a184-a691-7a29-a5af-45a96dbbe4d5-€5.00€0.00matched
78capture01a1a184-b2ac-7710-b8e8-3c52ee348816€49.00€0.67matched
79capture01a1a184-c310-7f20-a5d8-93a8e1087704€9.00€0.19matched
80capture01a1a184-c5a9-7999-ad92-7e2f0e88a4f6€24.00€0.37matched
81capture01a1a184-f90f-736b-81af-abb07c1028ce€9.00€0.19matched
82capture01a1a185-251f-7043-825e-1ad3d72be395€9.00€0.19matched
83capture01a1a185-675a-77f3-a312-1c7d1a885368€15.00€0.26matched
84capture01a1a185-6f9f-747b-a9be-c66334a47a56€35.00€0.50matched
85capture01a1a185-8033-7b61-987c-50cdb13d1713€49.00€0.67matched
86capture01a1a185-aeaf-74e4-9660-580c6188f9f6€24.00€0.37matched
87capture01a1a185-b735-7a05-a168-8ba67c91b76b€49.00€0.67matched
88capture01a1a185-bb16-762a-a7fd-e7f10341dcca€9.00€0.19matched
89capture01a1a185-ca78-7bd9-8a8a-99cabc6aa4ec€49.00€0.67matched
90capture01a1a185-edaf-79bf-886c-73fbc8f707ca€9.00€0.19matched
91capture01a1a185-fa1f-79c2-8617-4ed7a5ecd6f5€24.00€0.37matched
92capture01a1a186-22f5-77b1-bbcb-5ce264d77226€9.00€0.19matched
93capture01a1a186-2e04-7588-a31e-2b8598ba197b€24.00€0.37matched
94capture01a1a186-36c3-7c25-b246-aafeef4ffbe4€35.00€0.50matched
95capture01a1a186-6004-7b93-a88d-7c71d1dc8bb4€35.00€0.50matched
96capture01a1a186-6f3f-7230-a756-beea5630497f€15.00€0.26matched
97capture01a1a186-758e-7646-abd9-66f415b82e0a€9.00€0.19matched
98refund01a1a186-87d8-7416-a6fd-af6674f7573b-€15.00€0.00matched
99capture01a1a186-8b77-76da-88c1-11e5a2c354ff€24.00€0.37matched
100capture01a1a186-b472-75c0-91df-75b4aee941f4€49.00€0.67matched
101capture01a1a186-c481-7225-aef2-7bd3815f032d€15.00€0.26matched
102capture01a1a186-e077-7a70-a576-df2979a844f9€24.00€0.37matched
103capture01a1a186-eba0-7176-8334-61aea5901857€15.00€0.26matched
104capture01a1a186-f8ad-7df2-a8f4-a375af4bd6dd€9.00€0.19matched
105capture01a1a187-6eea-7845-99d1-f1f1354f1aaa€49.00€0.67matched
106capture01a1a187-8f02-7aa0-bb38-7917e1c6a2c6€15.00€0.26matched
107capture01a1a187-98f4-7e4d-942a-d361f3598cef€49.00€0.67matched
108capture01a1a187-b21e-7832-be6c-7cff2451f02f€24.00€0.37matched
109capture01a1a187-b55a-76e2-972f-f32c3c3bcd47€49.00€0.67matched
110capture01a1a187-b5c3-75f9-9d59-cd75beb941b8€35.00€0.50matched
111capture01a1a187-ad1c-7702-a3f2-2f9bcae05021€35.00€0.50matched
112capture01a1a187-dced-77d1-9de8-f6887b7fb6ae€24.00€0.37matched