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, 14:40

Gross

€2,542.00

PSP fee

€40.19

Net to the bank

€2,501.81

Settlement journal

#344499

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19cba-a5f2-77db-b5dc-e088621d088c is already settled by stl_EUR_2989384 line 84
  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 70, the contract says 67
LineKindReferenceGrossFeeStatus
21capture01a19cb5-a4ae-7f9c-827b-d36f4a85f4ed€24.00€0.39fee difference
85capture01a19cba-a625-736f-b889-eede487cb95e€35.00€0.50duplicate line
89capture01a19cbb-3d34-74f7-986f-9a14e685f9a8€49.00€0.70fee difference
1capture01a19cac-77bf-72ce-a222-529a625b3e7f€9.00€0.19matched
2capture01a19cad-b33a-7b57-bf65-1658adf9078d€15.00€0.26matched
3capture01a19cb3-fafb-7a0e-b5c4-c3a7a32a2c0b€9.00€0.19matched
4capture01a19cb4-06ed-7864-b66e-550eb7f19472€9.00€0.19matched
5refund01a19cb4-0ad1-778b-8a13-31e55c6a3f79-€14.00€0.00matched
6capture01a19cb4-0d85-743e-b9d9-e975e8e21d07€24.00€0.37matched
7capture01a19cb4-1df7-7015-986f-718fad20f37d€49.00€0.67matched
8capture01a19cb4-3503-7847-b205-21dd98565f04€24.00€0.37matched
9capture01a19cb4-39d0-7914-b830-8856ccf60f9b€15.00€0.26matched
10capture01a19cb4-49fd-7f63-8c49-e1815c94ff54€24.00€0.37matched
11refund01a19cb4-51ae-798e-8c73-9dd1fcbfa95c-€9.00€0.00matched
12capture01a19cb4-4ea6-7403-b293-2cd32f59429d€9.00€0.19matched
13capture01a19cb4-691f-7872-80f2-ddd9a03d094d€35.00€0.50matched
14capture01a19cb4-8c45-7a3b-94be-f3cabb7b25af€49.00€0.67matched
15capture01a19cb4-eeb9-703e-9a57-cd77de725eeb€15.00€0.26matched
16capture01a19cb5-1a2f-79b9-99ab-404498c61dda€49.00€0.67matched
17capture01a19cb5-2d35-7984-a258-5d11e3ad9946€9.00€0.19matched
18capture01a19cb5-36d7-75d7-8210-c823fb14fe7b€15.00€0.26matched
19capture01a19cb5-8013-7cfd-8860-586e03ebea68€49.00€0.67matched
20capture01a19cb5-9a2a-79ef-b255-a65495045a4e€35.00€0.50matched
22capture01a19cb5-b685-75b7-b0d9-fa4fc33d8bf5€24.00€0.37matched
23capture01a19cb5-cbd5-7601-92a3-652a672ee119€35.00€0.50matched
24capture01a19cb5-e1be-7427-99b3-363702d7ef65€24.00€0.37matched
25capture01a19cb5-ed4b-7f17-af94-cd76779d7b59€24.00€0.37matched
26capture01a19cb6-298a-7d5b-aada-a533d233ead2€35.00€0.50matched
27capture01a19cb6-4bd1-70bc-8b85-b153f3af5451€35.00€0.50matched
28capture01a19cb6-5700-7ce3-ba4f-2f9529ff6bf6€35.00€0.50matched
29capture01a19cb6-5e90-7424-bc5e-ffe7fecc4c59€49.00€0.67matched
30capture01a19cb6-69a6-73c8-a385-c9379446dc84€49.00€0.67matched
31capture01a19cb6-6aa4-7612-b008-dab0646b1fc2€9.00€0.19matched
32capture01a19cb6-7311-705e-9573-d82316fe3d1f€49.00€0.67matched
33capture01a19cb6-73b2-7a6a-baab-a455e930d7ea€15.00€0.26matched
34capture01a19cb6-8e2a-70ac-8ae7-5113f0f4427d€35.00€0.50matched
35capture01a19cb6-9d67-7b69-a66c-03afeecbc552€35.00€0.50matched
36refund01a19cb6-a05a-70b5-bd2d-9678e44b9cea-€13.00€0.00matched
37capture01a19cb6-be22-785d-a2f9-61d919ca5cf8€49.00€0.67matched
38capture01a19cb6-de0b-769d-bbd2-78159ecca2a3€15.00€0.26matched
39capture01a19cb6-e17c-7172-9bec-98b8c84b8180€15.00€0.26matched
40capture01a19cb6-e4bd-7b19-8cba-cc9b5f89ed0a€24.00€0.37matched
41capture01a19cb7-05e8-7cc2-bb83-bd0fc830a899€35.00€0.50matched
42capture01a19cb7-1fea-72c6-bcee-ba3716c99575€24.00€0.37matched
43capture01a19cb7-26d6-72b1-b7f5-fb14a6bfb3b7€24.00€0.37matched
44capture01a19cb7-2936-76e9-8902-982801c945dc€35.00€0.50matched
45capture01a19cb7-2c6f-7aa7-99b0-4af329aa58ed€49.00€0.67matched
46capture01a19cb7-3dae-7973-8031-53f6a216f93e€24.00€0.37matched
47capture01a19cb7-46aa-70a1-b3ba-b43568c7b9e4€9.00€0.19matched
48capture01a19cb7-4c38-787f-ae43-515b0ab17b95€24.00€0.37matched
49capture01a19cb7-6526-7a33-aefa-55bbad925bd6€49.00€0.67matched
50capture01a19cb7-68b8-7233-a48c-d28113417d40€35.00€0.50matched
51capture01a19cb7-78ec-7c00-9324-ceccedfbdc92€24.00€0.37matched
52capture01a19cb7-88df-74c1-baa6-70f73046ed08€9.00€0.19matched
53capture01a19cb7-9aff-747d-9af6-e1d8bfb9ee3a€49.00€0.67matched
54capture01a19cb7-9bf3-7360-b089-a57b58fd7f6f€9.00€0.19matched
55refund01a19cb7-b840-73fa-84f9-4a82f96d4990-€29.00€0.00matched
56refund01a19cb7-cb09-7d9a-a7b0-f18962a0c6a8-€27.00€0.00matched
57capture01a19cb8-07c9-753a-9160-b2e89cd3f599€9.00€0.19matched
58capture01a19cb8-0f20-7053-8826-f7bd96fe4dc4€35.00€0.50matched
59capture01a19cb8-3b59-7341-9515-a55491e916ce€49.00€0.67matched
60capture01a19cb8-4598-74ca-a164-eb7f2f83c44c€9.00€0.19matched
61capture01a19cb8-6dce-7fcc-9f82-a4b2080e6681€35.00€0.50matched
62refund01a19cb8-7f3e-7d62-b7e5-79135bb75e73-€4.00€0.00matched
63capture01a19cb8-8232-7475-84b1-fb5dd661ebc7€35.00€0.50matched
64capture01a19cb8-8b1b-7818-b2ca-ebb711c67e46€49.00€0.67matched
65capture01a19cb8-96b9-7968-8812-86b01b7b0d5b€35.00€0.50matched
66capture01a19cb8-ab92-747a-836f-a6cb66702078€9.00€0.19matched
67capture01a19cb8-b370-7943-80ee-b216bb83168c€35.00€0.50matched
68capture01a19cb8-cc53-7fc9-857b-2224b84cb38e€49.00€0.67matched
69capture01a19cb8-ce28-73e2-b848-64991dec0ff4€15.00€0.26matched
70capture01a19cb9-0c12-7de9-8e03-cffab43fe60b€9.00€0.19matched
71capture01a19cb9-1c71-7a48-b8a0-bc8e594ff6f9€24.00€0.37matched
72capture01a19cb9-21ec-7841-b380-4e9560f9d80f€15.00€0.26matched
73capture01a19cb9-3059-76bc-bdbe-3a2abae31c79€9.00€0.19matched
74capture01a19cb9-6901-7418-8678-a6f13847bf06€9.00€0.19matched
75capture01a19cb9-98e9-7cb5-8572-66425c4cc244€35.00€0.50matched
76capture01a19cb9-d191-7beb-becb-a8a9fe7e4ef9€35.00€0.50matched
77capture01a19cb9-d852-799f-8dd9-0de4dff28ae6€9.00€0.19matched
78capture01a19cb9-fb5a-702f-a915-3e5c6ff2d558€35.00€0.50matched
79capture01a19cba-197d-74d4-a746-26430d7f4a92€15.00€0.26matched
80capture01a19cba-246a-70e6-9796-61c96c51c416€9.00€0.19matched
81capture01a19cba-3998-73a3-8e56-ef85dfd9a745€24.00€0.37matched
82capture01a19cba-84a3-7e2b-8677-dbdccb976dce€15.00€0.26matched
83capture01a19cba-9dc6-7a6f-b3e9-54ab0b357323€15.00€0.26matched
84capture01a19cba-a625-736f-b889-eede487cb95e€35.00€0.50matched
86capture01a19cba-f868-772f-9216-371fb3dc519a€24.00€0.37matched
87capture01a19cbb-0a52-738a-8f13-dcb26687312d€9.00€0.19matched
88capture01a19cbb-1fec-79ba-a2a9-bceabbdcae8b€49.00€0.67matched
90refund01a19cbb-4413-74bb-9728-b4b3330b1d19-€18.00€0.00matched
91capture01a19cbb-44a8-7324-8c6c-06fc81088ff3€15.00€0.26matched
92capture01a19cbb-7998-7369-8382-9c25c35f2438€24.00€0.37matched
93capture01a19cbb-888d-7a26-9785-fdbaf0cb125a€49.00€0.67matched
94capture01a19cbb-95f2-7cce-894d-df97a21e5814€35.00€0.50matched
95capture01a19cbb-a9e8-73cd-ae18-78df24778c30€35.00€0.50matched
96capture01a19cbb-c47a-74b9-b188-82e1776b5c00€24.00€0.37matched
97refund01a19cbb-d288-79c7-b926-1b32d3f903de-€19.00€0.00matched
98capture01a19cbb-f4fb-799d-a961-2a307a2c5948€24.00€0.37matched
99capture01a19cbb-f9f3-79f6-98e6-d0dbb258f9fa€9.00€0.19matched
100capture01a19cbc-2635-7a45-b995-4c52130e0961€24.00€0.37matched
101capture01a19cbc-54e1-7066-b779-dd376770b55f€24.00€0.37matched
102capture01a19cbc-6a9d-7167-b4ff-35fa22ad3ce3€49.00€0.67matched
103capture01a19cbc-77d2-766e-9ddb-f992348c2062€15.00€0.26matched
104capture01a19cbc-963a-7e4e-a4d7-bf18d92eca16€9.00€0.19matched
105capture01a19cbc-c64b-7c80-900e-cd74f0526473€35.00€0.50matched
106capture01a19cbc-dc54-71cf-bd24-204d2d7aef8a€24.00€0.37matched
107capture01a19cbc-ddf7-78f8-82ce-73472c9e4806€35.00€0.50matched