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

Gross

€3,214.00

PSP fee

€50.65

Net to the bank

€3,163.35

Settlement journal

#387743

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
LineKindReferenceGrossFeeStatus
40capture01a1a8e8-2585-79cd-b050-b1df588a5871€9.00€0.22fee difference
46capture01a1a8e8-8d79-7d53-85e8-ea6c4e6fd44a€35.00€0.55fee difference
73capture01a1a8ea-80af-721c-b88f-8fbbc775f874€35.00€0.51fee difference
1capture01a1a8dd-e763-7320-b126-e0aff7eb47d5€49.00€0.67matched
2capture01a1a8dd-ea6a-77f8-a9aa-8f7c653faf5e€15.00€0.26matched
3capture01a1a8de-aec1-7968-80a6-54ffff670f70€49.00€0.67matched
4capture01a1a8e2-2d73-7320-9d08-a357d4ce4a26€49.00€0.67matched
5capture01a1a8e3-3799-7505-a0a9-7b8211134075€24.00€0.37matched
6capture01a1a8e6-08bd-7c55-96fd-5a7e7ccb30d9€15.00€0.26matched
7capture01a1a8e6-1985-7f3f-94a9-b2e0bacda760€49.00€0.67matched
8capture01a1a8e6-327a-729f-bf38-cc6ff6df11a9€9.00€0.19matched
9capture01a1a8e6-4f37-791e-8038-e5b682733a8b€9.00€0.19matched
10capture01a1a8e6-4fc7-7f81-bc22-417dbf0f81a8€15.00€0.26matched
11capture01a1a8e6-6957-7c8c-9281-90350e07e24c€9.00€0.19matched
12capture01a1a8e6-720f-7246-adc3-1c6fa608cede€15.00€0.26matched
13capture01a1a8e6-824b-7c38-9089-4132538d7fe3€15.00€0.26matched
14capture01a1a8e6-9b9f-7b88-8873-53aadb6f260a€35.00€0.50matched
15capture01a1a8e6-a82f-73d3-98a9-bf3f39f24f70€35.00€0.50matched
16capture01a1a8e6-ab2c-718d-9d89-960ded35dc33€24.00€0.37matched
17capture01a1a8e6-b97f-7ff4-81ff-32fbf845954e€49.00€0.67matched
18capture01a1a8e6-bc17-7eb8-ac85-380038980089€9.00€0.19matched
19capture01a1a8e6-da91-79cd-ae9d-8b8cd59eb869€35.00€0.50matched
20capture01a1a8e6-dba7-7384-9e7c-c3359b6061f3€49.00€0.67matched
21capture01a1a8e6-dcf2-7545-a3b2-6c06340762d0€35.00€0.50matched
22capture01a1a8e6-ed3d-7ee6-8f11-b3976c1f9573€15.00€0.26matched
23refund01a1a8e6-ef39-762e-8c42-696f7445f3ee-€21.00€0.00matched
24capture01a1a8e7-18df-7f4d-9a8d-b70af8b15380€49.00€0.67matched
25capture01a1a8e7-570f-78e4-b41a-0790bc95a82a€35.00€0.50matched
26capture01a1a8e7-5c62-701b-830d-329d358fc9c5€24.00€0.37matched
27capture01a1a8e7-66fe-7e5c-a9d9-770a1cc6ebbd€49.00€0.67matched
28capture01a1a8e7-695a-78f5-8fdd-ecbad4d10d22€15.00€0.26matched
29capture01a1a8e7-69c8-7757-9e12-5a83c8358e8c€49.00€0.67matched
30capture01a1a8e7-6b65-73e8-beca-78e0637f2219€49.00€0.67matched
31capture01a1a8e7-8886-7772-9154-f535bc73d628€49.00€0.67matched
32capture01a1a8e7-931c-73aa-b466-6bbe7368195d€24.00€0.37matched
33capture01a1a8e7-99e5-7357-8003-fa283fc6620d€35.00€0.50matched
34refund01a1a8e7-a30c-7985-b6a6-11cae5a1ecbd-€5.00€0.00matched
35capture01a1a8e7-afe2-7916-b783-73c859e1110e€49.00€0.67matched
36capture01a1a8e7-f30a-70b5-99ad-710bb2e866d4€9.00€0.19matched
37capture01a1a8e8-03b0-7c9b-aa7a-31454326460d€24.00€0.37matched
38capture01a1a8e8-0580-753b-beea-f9fc7cd38784€9.00€0.19matched
39capture01a1a8e8-0623-7abb-b93e-317cc2fdc619€35.00€0.50matched
41capture01a1a8e8-2856-77d1-babb-135eaf3de1d6€24.00€0.37matched
42capture01a1a8e8-2a0c-7fdc-817f-a20b1e746cfe€24.00€0.37matched
43capture01a1a8e8-4d95-73d3-8e09-ea42ecb54ed1€9.00€0.19matched
44refund01a1a8e8-6add-70c2-a1d5-d85ee198a8d7-€16.00€0.00matched
45capture01a1a8e8-8610-797d-a288-055dcb6d440f€24.00€0.37matched
47capture01a1a8e8-8f89-730b-86a9-72df5a746084€49.00€0.67matched
48capture01a1a8e8-b3f7-7dfd-b49c-25ceaf3ee9f7€49.00€0.67matched
49capture01a1a8e8-b5cd-754a-bb41-519091b8c5b3€24.00€0.37matched
50capture01a1a8e8-b9cf-7bf1-88e9-263c1d90a419€49.00€0.67matched
51capture01a1a8e8-c571-746b-bba0-1cd3e2c78ac7€24.00€0.37matched
52capture01a1a8e9-0b30-75f9-b994-1c6285c97a2f€24.00€0.37matched
53capture01a1a8e9-0efc-77ea-bb2b-51bda5107794€9.00€0.19matched
54capture01a1a8e9-2318-72e2-88ce-4f55b1cd01c7€15.00€0.26matched
55capture01a1a8e9-27dd-776f-b527-e8099182bc95€49.00€0.67matched
56capture01a1a8e9-2ac8-77ca-b53b-809fe12d5380€15.00€0.26matched
57capture01a1a8e9-5b94-76c6-b417-47e2c7a5d590€9.00€0.19matched
58capture01a1a8e9-659c-7d9b-8825-1b6a26e90b1e€9.00€0.19matched
59capture01a1a8e9-724e-77b8-9218-4eb82a980d4e€24.00€0.37matched
60capture01a1a8e9-8432-7090-9b39-ddeec6af8758€35.00€0.50matched
61capture01a1a8e9-b2d5-73b5-ad38-8c788b100de0€35.00€0.50matched
62capture01a1a8e9-b3bd-7aa6-8979-9ce3823c2607€15.00€0.26matched
63capture01a1a8e9-c72e-7c86-9cd8-7fb2af88b1ed€35.00€0.50matched
64refund01a1a8e9-d3ee-7723-b1f1-84127d566e01-€5.00€0.00matched
65capture01a1a8ea-0edc-79df-b798-d841283a17f7€35.00€0.50matched
66capture01a1a8ea-1e70-7bf7-926f-d967188da71d€9.00€0.19matched
67refund01a1a8ea-1fb6-7306-b01b-6eb510fd7927-€31.00€0.00matched
68capture01a1a8ea-25f1-778d-a4ce-3f3f406b5211€15.00€0.26matched
69capture01a1a8ea-2831-7e28-a9f2-2d24d1b45614€49.00€0.67matched
70capture01a1a8ea-5362-78e9-a546-c56507269945€15.00€0.26matched
71capture01a1a8ea-5929-78fb-9169-15204812d172€35.00€0.50matched
72refund01a1a8ea-65b4-796c-bcfa-ac13c5968448-€24.00€0.00matched
74capture01a1a8ea-809d-7936-bcf3-b9a2a45c9748€9.00€0.19matched
75capture01a1a8ea-8c8d-75b1-bcb4-bbc8a0b8de6a€49.00€0.67matched
76capture01a1a8ea-9940-7ec9-bd73-f070fd791145€15.00€0.26matched
77capture01a1a8ea-a101-7935-958f-3e6eeeadbcfe€49.00€0.67matched
78capture01a1a8ea-c942-7253-a781-59b34a761b6b€49.00€0.67matched
79capture01a1a8ea-ce9b-789b-82fb-edb971900408€9.00€0.19matched
80capture01a1a8ea-e813-74f4-a3dc-4b1543af85cf€15.00€0.26matched
81capture01a1a8ea-f805-7e8b-ae33-6b7f6010f2c5€9.00€0.19matched
82refund01a1a8ea-ff56-7073-8d46-57e2fd268992-€7.00€0.00matched
83capture01a1a8ea-ff6d-71f1-8e54-df75b2c4cf80€24.00€0.37matched
84capture01a1a8eb-1fe7-7ab6-8502-9dd00f83d2fc€49.00€0.67matched
85capture01a1a8eb-23fb-7c74-b8ed-c24f14f23e8d€9.00€0.19matched
86capture01a1a8eb-1d40-7cb1-92f2-dfe77bfc4b10€9.00€0.19matched
87capture01a1a8eb-28d6-7394-84cf-930977f9022c€35.00€0.50matched
88capture01a1a8eb-4450-76fb-adf5-92e5bf126be7€15.00€0.26matched
89capture01a1a8eb-6f3a-74a1-aa4f-1fc0ae972736€9.00€0.19matched
90capture01a1a8eb-a21b-798c-bf64-3fb320c3197a€49.00€0.67matched
91capture01a1a8eb-a48a-77b0-846e-86d854a54264€15.00€0.26matched
92capture01a1a8eb-b851-7596-85bf-ee137b26d096€9.00€0.19matched
93capture01a1a8eb-cda9-7f58-a6f8-884cf15379b6€49.00€0.67matched
94refund01a1a8eb-ce7c-71e4-8e94-e6d8c262703e-€4.00€0.00matched
95capture01a1a8eb-dc18-7871-a1c4-c907777f7ab6€35.00€0.50matched
96capture01a1a8eb-dcc8-746a-b4c3-c8198095177f€35.00€0.50matched
97capture01a1a8eb-dc78-77bb-a0e6-7d4c34138249€49.00€0.67matched
98capture01a1a8eb-e403-7d74-9903-134acc8c66e1€49.00€0.67matched
99capture01a1a8ec-1a2d-77cd-9cbc-ec81fdbeba1b€24.00€0.37matched
100refund01a1a8ec-413e-7333-b254-ee20294300a8-€29.00€0.00matched
101capture01a1a8ec-4a4d-707f-a2a2-2f1cd0289f5c€24.00€0.37matched
102capture01a1a8ec-5617-7d6f-ae94-7b49c5d2d764€49.00€0.67matched
103capture01a1a8ec-60e7-76f8-87d1-04367525e520€24.00€0.37matched
104capture01a1a8ec-83e0-7fdc-a031-dcf391c079ed€15.00€0.26matched
105capture01a1a8ec-86fd-73d6-809a-7c6db9ec492e€49.00€0.67matched
106capture01a1a8ec-95b7-70b3-9013-1c85f479b214€15.00€0.26matched
107capture01a1a8ec-aab5-7559-ac7e-2bd57a4bbeb2€49.00€0.67matched
108capture01a1a8ec-c071-75ec-85ce-16e6e6386cd0€9.00€0.19matched
109capture01a1a8ec-c78a-7be7-8707-2772370fb58a€15.00€0.26matched
110capture01a1a8ec-cc63-7571-9447-17aabf9a19af€15.00€0.26matched
111refund01a1a8ec-dae2-724a-b5d8-268ad8f737c1-€14.00€0.00matched
112capture01a1a8ec-ee00-7de5-8344-06b858b54ffb€15.00€0.26matched
113capture01a1a8ec-f1a9-7a29-88cb-12748f41506d€24.00€0.37matched
114refund01a1a8ed-02a5-71c9-baff-c98526e50e68-€15.00€0.00matched
115capture01a1a8ed-244e-7590-9f7a-8aaa7fe473e7€9.00€0.19matched
116capture01a1a8ed-3db2-726c-80bf-2ee18a52a43f€15.00€0.26matched
117capture01a1a8ed-4ca3-7889-b3a0-0c033b0a7337€24.00€0.37matched
118refund01a1a8ed-9e6e-7637-be5f-8ae2104bcfe4-€9.00€0.00matched
119capture01a1a8ed-becf-76a4-be08-4cc3535d58b6€24.00€0.37matched
120capture01a1a8ed-c536-7de4-867b-71dc00b492f4€49.00€0.67matched
121capture01a1a8ee-1551-768e-b03b-8b44e92af40a€24.00€0.37matched
122capture01a1a8ee-1a57-7f9e-b864-607e215be33a€15.00€0.26matched
123capture01a1a8ee-33ee-7232-9e7a-901e55884077€49.00€0.67matched
124capture01a1a8ee-60fe-7754-a402-014c2187f7f9€35.00€0.50matched
125capture01a1a8ee-71b4-7a8d-9092-18a26224bcd9€24.00€0.37matched
126capture01a1a8ee-73ee-7497-b381-25b72e5b55cf€35.00€0.50matched
127capture01a1a8ee-9a11-76e3-a9d2-6e10415b02ad€49.00€0.67matched
128capture01a1a8ee-a9e9-788b-9ddb-d8853d29fde5€35.00€0.50matched
129capture01a1a8ee-a7d3-740d-9325-de1a77f8eacf€35.00€0.50matched
130capture01a1a8ee-c14d-7942-bf39-f7659bc5dd0f€35.00€0.50matched
131capture01a1a8ee-cc8d-78b2-9f03-81b7dc81238a€9.00€0.19matched
132capture01a1a8ee-d166-7f7d-afa2-bb70690eae2b€9.00€0.19matched
133capture01a1a8ef-0689-7c50-8377-e0649981bb5e€49.00€0.67matched