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

4 Nov, 19:10

Gross

€2,854.00

PSP fee

€44.69

Net to the bank

€2,809.31

Settlement journal

#384424

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a7fa-977e-739d-ac99-82caf96cf169 is already settled by stl_EUR_2989699 line 37
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 21, the contract says 19
LineKindReferenceGrossFeeStatus
20capture01a1a7f9-31a2-7e73-a406-c35e5aa35bf8€9.00€0.21fee difference
38capture01a1a7fa-97d2-75ea-b3de-6ac0f9cbbe45€49.00€0.67duplicate line
70capture01a1a7fc-c53e-771b-abb3-004bda2eb883€9.00€0.21fee difference
1capture01a1a7f3-0933-7e46-9440-56e4355b338c€15.00€0.26matched
2capture01a1a7f5-0f4f-77e3-a4b2-591d7dea18cb€9.00€0.19matched
3capture01a1a7f6-b361-7754-bb1e-e915c60bd556€35.00€0.50matched
4refund01a1a7f8-131d-7f6c-8fb6-df31c33a494f-€5.00€0.00matched
5capture01a1a7f8-1d7a-7534-ba1d-e2f8507e1852€35.00€0.50matched
6capture01a1a7f8-2632-722b-9336-f51227ca79b0€24.00€0.37matched
7capture01a1a7f8-394b-742a-b2d2-756dd756a272€35.00€0.50matched
8capture01a1a7f8-5cef-74ed-ab8d-81e43954adec€15.00€0.26matched
9capture01a1a7f8-605e-7838-ae52-ff1d42d399bf€15.00€0.26matched
10capture01a1a7f8-65db-766d-9b29-9e5d0c370593€9.00€0.19matched
11capture01a1a7f8-6aac-7d8e-bdad-3689637dfc63€49.00€0.67matched
12capture01a1a7f8-6c9c-7804-9ee4-c59c3dff29eb€49.00€0.67matched
13capture01a1a7f8-b70d-7149-98a9-fed16f7d74d4€9.00€0.19matched
14capture01a1a7f8-c519-7878-8eb9-fb586571026a€15.00€0.26matched
15capture01a1a7f8-cf6b-73f9-b67b-5526cd6a48da€35.00€0.50matched
16capture01a1a7f8-e37b-7c1e-bfd1-8ad917314c1f€49.00€0.67matched
17capture01a1a7f8-ec70-7c45-837b-276d35f0ead8€49.00€0.67matched
18capture01a1a7f9-1099-7416-8c04-3b43bb445d21€15.00€0.26matched
19capture01a1a7f9-11ce-7012-917b-95f60061d05a€35.00€0.50matched
21capture01a1a7f9-3cd5-72d8-b0fa-52e0fd52ee9e€9.00€0.19matched
22capture01a1a7f9-6ba2-7594-9469-d5cf09e03e17€35.00€0.50matched
23capture01a1a7f9-7da6-7ba1-a70a-0828a99bc73e€49.00€0.67matched
24capture01a1a7f9-7e0a-735a-9eb6-e99e2aaf48e6€49.00€0.67matched
25refund01a1a7f9-8104-73ed-9713-5480a23ba872-€32.00€0.00matched
26capture01a1a7f9-8949-7ecd-af82-dd92e0e397ec€9.00€0.19matched
27capture01a1a7f9-bb6a-7d36-b5b0-b030792c1445€35.00€0.50matched
28capture01a1a7f9-d68c-7193-9eb0-4b10085181cd€35.00€0.50matched
29capture01a1a7f9-e4c7-73be-a3cf-39e90b04e23c€9.00€0.19matched
30capture01a1a7f9-e250-753f-bbb7-8c4676304a0a€9.00€0.19matched
31capture01a1a7fa-0363-7baf-9743-ad6b8e01383f€9.00€0.19matched
32capture01a1a7fa-2036-7998-8dae-14c80c4655c5€9.00€0.19matched
33capture01a1a7fa-20ae-7c73-9c76-72580475d730€9.00€0.19matched
34capture01a1a7fa-4c52-7677-bd28-892bf5c2f74c€49.00€0.67matched
35capture01a1a7fa-5b54-7b73-9bfe-4e1b310278e3€35.00€0.50matched
36capture01a1a7fa-6876-72d7-a183-63f9d3edd4aa€49.00€0.67matched
37capture01a1a7fa-97d2-75ea-b3de-6ac0f9cbbe45€49.00€0.67matched
39capture01a1a7fa-999d-7fb8-85f9-8c3185b251e8€15.00€0.26matched
40capture01a1a7fa-a461-7762-b1c6-36e5263a09a8€24.00€0.37matched
41capture01a1a7fa-ac15-7727-a810-ad3a6f1d26fe€9.00€0.19matched
42capture01a1a7fa-b287-77ba-a857-f27e51f42ce7€24.00€0.37matched
43capture01a1a7fb-1d80-7472-b186-f35fbe45ff07€15.00€0.26matched
44capture01a1a7fb-21d7-7d01-bb15-03c1c35f78f2€49.00€0.67matched
45capture01a1a7fb-2f48-7a9c-9191-aa56d5b99902€9.00€0.19matched
46capture01a1a7fb-305a-7bd1-a746-1f2ea41ef278€9.00€0.19matched
47capture01a1a7fb-3644-7298-af2c-4b8993d83411€9.00€0.19matched
48capture01a1a7fb-39dd-7960-8608-8c9bd71f72b1€9.00€0.19matched
49capture01a1a7fb-3c82-7d3c-ae49-60482d6e6b03€9.00€0.19matched
50capture01a1a7fb-4158-7966-999a-4cac6430d500€35.00€0.50matched
51capture01a1a7fb-4dff-72cd-ba42-cea4380bc324€24.00€0.37matched
52capture01a1a7fb-5ec4-7314-8977-36f178159e9a€49.00€0.67matched
53capture01a1a7fb-72bb-7008-8a39-29c01370239f€15.00€0.26matched
54capture01a1a7fb-9aa4-7843-8000-e5ae0c4b6831€9.00€0.19matched
55capture01a1a7fb-9bc3-7b97-a629-20c1778682a8€15.00€0.26matched
56capture01a1a7fb-aa21-719f-8b95-ea53171f6ea9€35.00€0.50matched
57capture01a1a7fb-ab65-79b7-9637-894ab2db7463€15.00€0.26matched
58capture01a1a7fb-be06-7e2d-9cb5-72c38ac3f43e€15.00€0.26matched
59capture01a1a7fb-d00f-7dcf-8868-ae9c60344987€15.00€0.26matched
60capture01a1a7fb-df73-7113-b0a0-831adbd5832c€24.00€0.37matched
61capture01a1a7fc-086b-7d44-8200-5346fda63beb€49.00€0.67matched
62capture01a1a7fc-2525-78b4-888c-9a18fa9aece0€15.00€0.26matched
63capture01a1a7fc-2d83-7ea9-b833-974729ef79fa€9.00€0.19matched
64capture01a1a7fc-2fcf-737f-bf7b-61a409a4a2b6€35.00€0.50matched
65capture01a1a7fc-5814-709b-96a6-522b3f1d63bb€15.00€0.26matched
66capture01a1a7fc-7c55-7a00-90bb-a36fd3bc4210€35.00€0.50matched
67capture01a1a7fc-868a-797b-9a92-72ea47e03848€24.00€0.37matched
68capture01a1a7fc-b3e3-7a15-9b9f-aa1dbf577f11€24.00€0.37matched
69capture01a1a7fc-b70e-7279-9470-33b6ac8369f4€35.00€0.50matched
71capture01a1a7fd-0f9a-7275-9131-235d5ea56568€24.00€0.37matched
72capture01a1a7fd-3804-7821-96c5-c5145423890d€35.00€0.50matched
73capture01a1a7fd-3abd-7f97-ae2f-2994fcfa7a75€35.00€0.50matched
74capture01a1a7fd-7705-78ca-88d1-2f8e032a9acf€9.00€0.19matched
75capture01a1a7fd-b3b6-7fdc-938c-ab366e620425€15.00€0.26matched
76capture01a1a7fd-d93a-78e1-8337-7e23a5260dd4€15.00€0.26matched
77capture01a1a7fd-df22-7bc3-b39a-8bdcb2986176€24.00€0.37matched
78capture01a1a7fd-eca0-7173-a570-202314338be2€35.00€0.50matched
79capture01a1a7fd-eee2-76a9-befb-ffb7c66a94d9€35.00€0.50matched
80capture01a1a7fd-ffac-77fd-8f96-e239d69e0231€35.00€0.50matched
81capture01a1a7fe-09d8-7072-9662-d3a6a90ebab6€15.00€0.26matched
82capture01a1a7fe-13e3-71d6-b38a-fc24adc8d860€9.00€0.19matched
83capture01a1a7fe-3f18-77f8-8ee7-57723c04cd2b€35.00€0.50matched
84capture01a1a7fe-72db-7760-9e00-b0c51cfbb88e€35.00€0.50matched
85capture01a1a7fe-752c-74f0-8b87-2cdbb612d276€35.00€0.50matched
86capture01a1a7fe-79bb-7309-8ce5-cd4dc9072188€9.00€0.19matched
87capture01a1a7fe-8965-7426-9ebe-e88a1da1878c€15.00€0.26matched
88capture01a1a7fe-8aca-74a6-a740-871c9d41803a€15.00€0.26matched
89capture01a1a7fe-8f03-7746-b40a-b5ae8e595956€24.00€0.37matched
90capture01a1a7fe-a710-71ad-acb8-d377d7ca3f36€35.00€0.50matched
91capture01a1a7fe-b94b-7f9c-bfe6-26d84ffbd525€9.00€0.19matched
92capture01a1a7fe-efe9-7f11-b6eb-5eeef3fe3690€35.00€0.50matched
93capture01a1a7fe-f416-7b75-ac9a-fc04c2a0b357€49.00€0.67matched
94capture01a1a7ff-15c5-7c2a-b34c-2b2e36f7736a€9.00€0.19matched
95capture01a1a7ff-19b2-751f-860b-b4c71deca9bd€24.00€0.37matched
96capture01a1a7ff-465e-7eaf-9a3c-06a508d3dfeb€15.00€0.26matched
97capture01a1a7ff-673a-7cd7-bfd1-313427c63b6e€9.00€0.19matched
98refund01a1a7ff-6a5f-727d-90d5-883fea33cf00-€10.00€0.00matched
99capture01a1a7ff-7bb3-7846-ad65-02b9877be950€49.00€0.67matched
100capture01a1a7ff-a2d5-775d-b8c8-a246a2e34aca€49.00€0.67matched
101capture01a1a7ff-a4eb-74bf-bb52-9d2e8379cd48€49.00€0.67matched
102capture01a1a7ff-a8ea-74e1-acad-6e287bb0cc1d€15.00€0.26matched
103capture01a1a7ff-d7c3-78e4-b7b7-60ab8e883b74€49.00€0.67matched
104refund01a1a7ff-df25-72f6-a451-40761b1ebc2c-€16.00€0.00matched
105capture01a1a7ff-efb0-76ef-b819-4afffbcde963€24.00€0.37matched
106capture01a1a800-0032-778b-ab2a-dd9e33cf684b€24.00€0.37matched
107capture01a1a800-0446-7e28-98c2-144c7b80a6b0€15.00€0.26matched
108capture01a1a800-055f-7804-9360-a3366c29de13€35.00€0.50matched
109capture01a1a800-203f-78cc-bfee-033f901e54c6€49.00€0.67matched
110capture01a1a800-2ec2-72bd-81e3-f9cf751416c5€15.00€0.26matched
111refund01a1a800-74cf-77d6-81ee-a7e2097f8400-€26.00€0.00matched
112capture01a1a800-77fe-7622-8386-76ddb13bbd5e€24.00€0.37matched
113capture01a1a800-918c-77c1-aec2-fe747b804ca6€9.00€0.19matched
114capture01a1a800-973d-7544-b03c-a3878606e586€9.00€0.19matched
115capture01a1a800-c61f-74bb-8d6a-0a9ee926cf90€49.00€0.67matched
116capture01a1a800-cc4f-7463-b2c2-48ba60714e21€24.00€0.37matched
117capture01a1a800-d68d-7c0f-83ee-ae24755937a8€49.00€0.67matched
118capture01a1a800-ed1b-7d32-8056-393739a5cbb9€24.00€0.37matched
119capture01a1a800-ef79-7bfe-a7e7-b4d3f7f8357a€9.00€0.19matched
120capture01a1a800-f8d7-705b-a273-a9eacecf35b1€49.00€0.67matched