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

5 Nov, 08:30

Gross

€2,735.00

PSP fee

€43.76

Net to the bank

€2,691.24

Settlement journal

#394571

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aada-266f-7a4b-94c3-aa51c8bd8b1a is already settled by stl_EUR_2989779 line 70
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 22, the contract says 19
LineKindReferenceGrossFeeStatus
62capture01a1aad9-756a-7569-80c0-62450fe95f53€9.00€0.20fee difference
71capture01a1aada-2698-71fd-ba39-30e025810601€49.00€0.67duplicate line
107capture01a1aadc-b6b5-7aad-9428-97db5d6032f6€9.00€0.22fee difference
1capture01a1aace-56a0-7916-b7f6-c4c53d6b4921€24.00€0.37matched
2capture01a1aad1-2368-7524-ba72-70411c85ee3b€35.00€0.50matched
3capture01a1aad4-463e-7b90-96d9-277d73634df4€15.00€0.26matched
4capture01a1aad4-4a75-71aa-b380-236ca6184a93€24.00€0.37matched
5capture01a1aad4-5f42-7feb-af79-a5cc8c67d65f€49.00€0.67matched
6capture01a1aad4-6106-7e22-a5e4-618984ae17b9€24.00€0.37matched
7capture01a1aad4-7301-7f68-8672-8b9793a1b434€35.00€0.50matched
8capture01a1aad4-73ae-7d5e-bc9e-489149c9dc44€15.00€0.26matched
9capture01a1aad4-7e22-7ffc-a4a7-c4ebd86b5524€49.00€0.67matched
10capture01a1aad4-7f7f-7bb5-b0f4-df6d18059cf5€9.00€0.19matched
11capture01a1aad4-98cd-73d1-90b5-cdeaa6c01184€9.00€0.19matched
12capture01a1aad4-9bdf-7a54-b8c4-423848341a0a€35.00€0.50matched
13capture01a1aad4-a0a9-73a3-93aa-40c637e135ac€9.00€0.19matched
14capture01a1aad4-ab2c-70c4-b7f4-a21ed2d08927€24.00€0.37matched
15capture01a1aad4-adba-7283-a73e-62a1bf4bf278€15.00€0.26matched
16refund01a1aad4-d0bf-7671-bf9b-e101e3f02248-€5.00€0.00matched
17capture01a1aad4-d34f-752a-9762-6e4e94650792€24.00€0.37matched
18capture01a1aad5-1b09-7398-ad9b-2fd3acd6e1f0€49.00€0.67matched
19capture01a1aad5-3788-7026-b252-e752d77b331c€35.00€0.50matched
20capture01a1aad5-4462-76bd-99f2-72440daee2dd€24.00€0.37matched
21refund01a1aad5-4624-77c1-8897-4763accb3329-€47.00€0.00matched
22capture01a1aad5-698d-7d4e-b35c-86c766750fc8€35.00€0.50matched
23capture01a1aad5-7f55-7419-86f1-969aae76f1a8€35.00€0.50matched
24capture01a1aad5-b6af-7490-9022-172931217fd3€35.00€0.50matched
25capture01a1aad5-d5a8-7bdd-9f93-ca3b68515ce0€35.00€0.50matched
26capture01a1aad5-fc10-78ea-9c08-e3ef536803a4€24.00€0.37matched
27capture01a1aad5-fc15-71e4-97a8-18781ee9ce55€15.00€0.26matched
28capture01a1aad6-194d-7807-a070-dc40fd8be680€24.00€0.37matched
29capture01a1aad6-1d2b-77cb-82c9-4b2fcd68888b€35.00€0.50matched
30capture01a1aad6-3eab-7e6b-83ab-34eb9b1c8844€24.00€0.37matched
31capture01a1aad6-513c-71bf-9c1b-f0e546a19d2e€49.00€0.67matched
32capture01a1aad6-6cef-77a8-9542-0e51cda78bcd€9.00€0.19matched
33capture01a1aad6-665a-7ca5-afda-be6648fa8f2d€49.00€0.67matched
34capture01a1aad6-8deb-7c27-a107-4da08a19ad6e€9.00€0.19matched
35capture01a1aad6-9ce5-7320-a4ec-1896b4656c0e€35.00€0.50matched
36capture01a1aad6-aaa1-7528-a18a-178a6dca2d76€24.00€0.37matched
37capture01a1aad6-c9f0-7800-b7e0-605e20e3bddc€9.00€0.19matched
38capture01a1aad6-cdd5-795d-b4b9-f5a99b03ba24€9.00€0.19matched
39capture01a1aad6-dba5-7f11-abe4-6a2b07819325€9.00€0.19matched
40capture01a1aad7-7576-7d75-8633-52be2f313a27€49.00€0.67matched
41capture01a1aad7-7a55-7908-b694-9b4a9ae167bd€24.00€0.37matched
42capture01a1aad7-7ef5-74ce-8bae-897d68d05f90€35.00€0.50matched
43capture01a1aad7-8d79-7f93-8b81-411597407d1a€35.00€0.50matched
44capture01a1aad7-b14d-7872-a3d1-ff2346d36715€35.00€0.50matched
45capture01a1aad7-e327-7cd4-8a39-558fcb968da7€24.00€0.37matched
46capture01a1aad8-0bb8-7c8a-8e9f-c9e4319bf680€15.00€0.26matched
47capture01a1aad8-147e-764c-afa9-2a28f00f9303€24.00€0.37matched
48capture01a1aad8-27ce-73ef-a48a-b188cdcdedb9€35.00€0.50matched
49capture01a1aad8-2a1a-739d-be45-998cdf08a276€15.00€0.26matched
50capture01a1aad8-38ea-7821-b153-4cec1094eca1€35.00€0.50matched
51refund01a1aad8-3dca-7efe-8533-2d99899d903c-€15.00€0.00matched
52capture01a1aad8-3e05-710c-b3f3-c7155afae514€9.00€0.19matched
53capture01a1aad8-5335-794e-882b-d69e69371cb5€35.00€0.50matched
54refund01a1aad8-7830-78bb-99ce-e0281f57a04f-€26.00€0.00matched
55capture01a1aad8-bddf-7c55-9815-431310de2085€15.00€0.26matched
56capture01a1aad8-c070-7c7b-9166-8d825f3cc78c€24.00€0.37matched
57capture01a1aad8-eddd-7536-bef7-fa2855f8d776€35.00€0.50matched
58capture01a1aad8-fdfd-7ed3-9bda-c946e29a5fde€24.00€0.37matched
59capture01a1aad9-5579-7dd1-94bc-5e4333b7cad0€35.00€0.50matched
60capture01a1aad9-57c6-782b-8a34-818cc29a4efa€35.00€0.50matched
61capture01a1aad9-5ed6-7038-bad7-e1e8eb2e15d9€15.00€0.26matched
63capture01a1aad9-7ae9-7ec0-b9ac-bf8baa026d75€49.00€0.67matched
64capture01a1aad9-99f9-7f9d-9a56-e6444f141fd7€49.00€0.67matched
65capture01a1aad9-a4a4-785f-8224-78fd81f2dd8c€49.00€0.67matched
66capture01a1aad9-aa66-76e0-954a-2ae36359dbe9€24.00€0.37matched
67capture01a1aad9-bddc-7c8f-9e1a-ffdc7f0e3703€24.00€0.37matched
68capture01a1aad9-da16-7885-8e2b-783237397e2f€15.00€0.26matched
69refund01a1aada-1393-75f2-83fc-f39f517a1f7e-€23.00€0.00matched
70capture01a1aada-2698-71fd-ba39-30e025810601€49.00€0.67matched
72capture01a1aada-3e89-7b75-b6bb-62add1676422€35.00€0.50matched
73capture01a1aada-572d-783a-8f38-aba983a66946€9.00€0.19matched
74capture01a1aada-57f3-7712-b370-90e9b45091a3€9.00€0.19matched
75capture01a1aada-64f3-71ff-819e-3f814d3b2336€35.00€0.50matched
76capture01a1aada-6fb6-7bdf-a718-e1a9267e4fc6€35.00€0.50matched
77capture01a1aada-a03f-7de2-8d37-efd54560c83d€15.00€0.26matched
78capture01a1aada-c41b-7e62-a377-ddda5c85d029€24.00€0.37matched
79capture01a1aada-c9f6-7158-adca-fcc2fd4c8bca€35.00€0.50matched
80capture01a1aada-ee0c-71cf-8963-048c701e37b9€9.00€0.19matched
81capture01a1aada-f85f-7fd9-945a-2d5c442934bc€35.00€0.50matched
82capture01a1aadb-090d-79c7-ad5c-672c4e001525€15.00€0.26matched
83capture01a1aadb-0f6d-7fd0-a10c-98a7d65b5565€15.00€0.26matched
84capture01a1aadb-4b2e-7c8e-86c7-647455f91db7€15.00€0.26matched
85capture01a1aadb-5f45-7c7e-aebb-6b5f798bb59e€49.00€0.67matched
86capture01a1aadb-802a-7588-9ad8-8b2683b41859€9.00€0.19matched
87capture01a1aadb-9353-7a02-a73c-a92503f6f106€24.00€0.37matched
88capture01a1aadb-948a-71c1-9690-870e8e177662€24.00€0.37matched
89capture01a1aadb-9e19-79ef-af0b-1725ba97859a€35.00€0.50matched
90capture01a1aadb-a526-7c51-90ca-3e252e63e932€15.00€0.26matched
91capture01a1aadb-c7f2-7d8c-b570-b0f4e442d997€15.00€0.26matched
92capture01a1aadc-09f8-7a05-bd11-cc6d577c187d€9.00€0.19matched
93capture01a1aadc-1304-7bee-b3e0-dd620a478cc8€15.00€0.26matched
94capture01a1aadc-1ec2-741a-b598-351f501c7da5€9.00€0.19matched
95capture01a1aadc-31a2-78f2-a12c-5428d19729c2€49.00€0.67matched
96capture01a1aadc-42bf-794f-bbe1-7a21091ec307€15.00€0.26matched
97capture01a1aadc-4317-703a-9e43-1652a5aedd37€9.00€0.19matched
98capture01a1aadc-53e0-7be8-aa6d-2f80becf2d3a€15.00€0.26matched
99capture01a1aadc-5cc0-7896-a0c4-0d4dc474406e€15.00€0.26matched
100capture01a1aadc-5cfc-7595-9a79-78a6d34e01f8€49.00€0.67matched
101refund01a1aadc-6bb0-7364-96d5-68761afebf3f-€44.00€0.00matched
102capture01a1aadc-76ab-7f2a-9139-297c1ecd75a2€49.00€0.67matched
103capture01a1aadc-84a4-78c7-8cbe-41160a20673b€15.00€0.26matched
104capture01a1aadc-90d0-73ec-b469-db559f45380b€49.00€0.67matched
105refund01a1aadc-99c0-7ec7-b409-fd39001004c1-€12.00€0.00matched
106capture01a1aadc-9ec8-7f04-a1ac-c046a7d9ee8e€9.00€0.19matched
108capture01a1aadc-be44-76b3-904e-c4ce366f66a9€49.00€0.67matched
109capture01a1aadc-c134-73a2-ba64-75ba80a1dcd1€35.00€0.50matched
110capture01a1aadc-d837-7c33-87f4-16061bea3111€15.00€0.26matched
111capture01a1aadc-d198-7428-a056-6b3961d12d7b€49.00€0.67matched
112capture01a1aadd-20c7-7520-b694-c43c28eb4043€15.00€0.26matched
113capture01a1aadd-5025-7875-bb83-d0ea538c39d4€49.00€0.67matched
114capture01a1aadd-50f4-7e50-a30d-4321de3e5d4a€35.00€0.50matched
115capture01a1aadd-671f-7e63-9a00-dde034ea4fdc€15.00€0.26matched
116capture01a1aadd-679b-75ae-b758-d0099ad49516€35.00€0.50matched