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, 21:50

Gross

€2,411.00

PSP fee

€37.62

Net to the bank

€2,373.38

Settlement journal

#368176

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a36c-7248-7401-9e27-e48d1d53719e is already settled by stl_EUR_2989571 line 89
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
LineKindReferenceGrossFeeStatus
63capture01a1a369-6904-7744-83d0-54cd9b1ddf45€35.00€0.54fee difference
90capture01a1a36c-7267-787d-9beb-3c16eb28277b€24.00€0.37duplicate line
1capture01a1a35d-e321-7ed7-aa04-519f6d909e41€35.00€0.50matched
2capture01a1a35e-c255-73c9-a0bd-b3f6452edbe5€49.00€0.67matched
3capture01a1a360-a52a-7d47-9d5c-75f39cb7a0a0€35.00€0.50matched
4refund01a1a360-fd3a-749a-8c6c-44d186273cb7-€11.00€0.00matched
5capture01a1a364-069e-7d15-9f2d-d9e4921d054a€9.00€0.19matched
6capture01a1a364-294d-77af-8b65-2d9445774f9b€9.00€0.19matched
7capture01a1a364-75d7-7d36-87fe-6b94f7a7128b€15.00€0.26matched
8capture01a1a364-7f20-7480-bc60-fac56867a39d€15.00€0.26matched
9capture01a1a364-bade-7b54-8223-882abaef7421€35.00€0.50matched
10refund01a1a364-cb92-72fa-be7c-947154f0b66c-€3.00€0.00matched
11capture01a1a364-dde1-7017-93ca-30d083f45e54€35.00€0.50matched
12capture01a1a364-e60f-7fc7-88fe-ff704b2855b2€24.00€0.37matched
13capture01a1a364-f2d7-7d61-b520-78e3342ad7e2€15.00€0.26matched
14capture01a1a364-f588-73aa-8469-40f8746b9d14€35.00€0.50matched
15capture01a1a365-1281-7e29-93e0-2adab1983a2b€9.00€0.19matched
16capture01a1a365-29c9-7782-9b5a-d3e976a213b3€35.00€0.50matched
17capture01a1a365-2afe-7e26-b775-1d4805cdbc66€15.00€0.26matched
18capture01a1a365-43fc-7888-b4f4-a2d0fc5ae1e4€9.00€0.19matched
19capture01a1a365-51ed-7336-a741-2ba8e4f375fb€24.00€0.37matched
20capture01a1a365-5d0e-73a8-beab-dcf60b959d22€24.00€0.37matched
21capture01a1a365-67bb-702f-b4bf-8978366976b5€9.00€0.19matched
22capture01a1a365-774b-74a0-aab9-82652c8504ac€35.00€0.50matched
23capture01a1a365-79d4-715c-a9bb-1d41a16da296€49.00€0.67matched
24refund01a1a365-9135-75e3-94ce-7223817647d8-€16.00€0.00matched
25capture01a1a365-95d4-7967-9837-267a2006cebe€15.00€0.26matched
26refund01a1a365-c77e-7318-a6ad-c7754367a4b5-€31.00€0.00matched
27capture01a1a365-dd81-76fe-a6c2-2ea528f9172e€35.00€0.50matched
28capture01a1a365-ea85-72cc-8f65-3f55f2228587€35.00€0.50matched
29capture01a1a366-097d-743f-9d31-34efa66717ad€24.00€0.37matched
30capture01a1a366-0dd0-76b3-b96c-d665ed541785€35.00€0.50matched
31refund01a1a366-2383-7571-8af5-9c05949f74f7-€12.00€0.00matched
32capture01a1a366-3bca-792d-ab10-0a01fd7965c8€35.00€0.50matched
33capture01a1a366-4fab-7f53-a3f4-93b4317c04fb€9.00€0.19matched
34capture01a1a366-518f-700c-88c8-96cb93c958d9€24.00€0.37matched
35capture01a1a366-5b54-744a-9f37-9b6b68262609€9.00€0.19matched
36capture01a1a366-943e-7015-ac78-1d9cfffa6df4€49.00€0.67matched
37capture01a1a366-b053-7fdf-a683-6541ce3d5ef5€35.00€0.50matched
38capture01a1a366-b879-76ce-9750-aa3aab91a11c€24.00€0.37matched
39capture01a1a366-df49-715e-9fcd-3dc210776e37€9.00€0.19matched
40capture01a1a366-f1cb-728b-af1e-2558c9e99595€15.00€0.26matched
41capture01a1a367-15d0-7301-a6b3-6ccf436ae4e3€24.00€0.37matched
42capture01a1a367-596b-7db1-b5ee-f2c5894d47d9€49.00€0.67matched
43capture01a1a367-6873-72a3-bb95-bc4f52821a93€35.00€0.50matched
44capture01a1a367-7a9f-7254-a13e-25be62c58f10€35.00€0.50matched
45capture01a1a367-81ee-77f8-a053-bba67d23175f€9.00€0.19matched
46capture01a1a367-8c97-7378-b6af-98c9cdc2e2e3€9.00€0.19matched
47capture01a1a367-a73e-774c-b94c-2d656c1deb70€24.00€0.37matched
48capture01a1a368-1378-788d-82a8-33d910d55fe9€49.00€0.67matched
49capture01a1a368-247c-753a-aabe-2887a44d6fee€15.00€0.26matched
50capture01a1a368-67ad-7e69-b517-a2358ae7b58e€24.00€0.37matched
51capture01a1a368-8186-7b9b-a0be-91b94403e052€49.00€0.67matched
52capture01a1a368-96ce-7ced-a033-017dac20ae45€24.00€0.37matched
53capture01a1a368-d8e3-7f8b-9663-9b4b01e4d75b€49.00€0.67matched
54capture01a1a368-e222-7c01-ae30-c4f79afd242b€24.00€0.37matched
55capture01a1a369-0c62-7c5e-af18-c475462d839d€24.00€0.37matched
56capture01a1a369-31b0-7675-ba7d-958c3743ba1a€49.00€0.67matched
57capture01a1a369-322e-7f50-9be1-a85cbda142a7€49.00€0.67matched
58capture01a1a369-3904-7359-94f3-4d8ccf01f646€35.00€0.50matched
59capture01a1a369-451d-725c-9312-be7d3fa8ef69€24.00€0.37matched
60capture01a1a369-481e-7823-af76-fddca5fdcacf€15.00€0.26matched
61capture01a1a369-5280-756d-bf81-5d07f92d49fa€49.00€0.67matched
62capture01a1a369-5e02-73ac-b29a-e352650d971d€49.00€0.67matched
64capture01a1a369-92c7-7552-8143-ebc64f2c8d0c€9.00€0.19matched
65refund01a1a369-9b1a-7f10-baa9-01396224e03b-€32.00€0.00matched
66capture01a1a369-b10a-7f7d-aa05-b114ea849cc0€15.00€0.26matched
67capture01a1a369-be17-7444-94d0-8d841ff29b38€9.00€0.19matched
68capture01a1a369-b463-733f-ab3d-65e63fa5f367€15.00€0.26matched
69capture01a1a369-e772-7361-9ca1-7e538a1b73d1€35.00€0.50matched
70capture01a1a369-ed81-7f66-b35e-f74a68b773d4€49.00€0.67matched
71capture01a1a369-f6ac-758b-b7b1-9d2892acc981€35.00€0.50matched
72capture01a1a369-fe75-7636-a220-d498fc17fc04€15.00€0.26matched
73capture01a1a36a-2311-717d-a8f5-d723b8b48835€24.00€0.37matched
74capture01a1a36a-4d20-7611-9e52-bc91d94a29fa€9.00€0.19matched
75capture01a1a36a-8a33-77c0-9709-b48230c59ad7€49.00€0.67matched
76capture01a1a36a-8c91-723a-aa8f-7d63cb2f3355€15.00€0.26matched
77capture01a1a36a-ea50-77aa-bda0-e998f787c53f€49.00€0.67matched
78capture01a1a36b-01f0-7703-9917-f2367d4ba142€24.00€0.37matched
79capture01a1a36b-46c4-7a8a-a31a-374eef26535c€15.00€0.26matched
80capture01a1a36b-67a5-7377-b32a-b3a78e312d10€35.00€0.50matched
81capture01a1a36b-a275-764e-ba2d-cdb5d74419be€15.00€0.26matched
82capture01a1a36b-c7e3-7d48-ac1b-8da652aec38c€24.00€0.37matched
83capture01a1a36b-ef69-73b3-be20-6802ef851a57€49.00€0.67matched
84capture01a1a36b-ff1f-74bb-89e1-7180cd6a2f31€24.00€0.37matched
85capture01a1a36c-108a-7012-84ed-a6043ed3d6e6€49.00€0.67matched
86capture01a1a36c-2172-7e07-a334-6174a7e04d88€35.00€0.50matched
87capture01a1a36c-2bcd-7392-8a9b-f0c5f24c147a€24.00€0.37matched
88capture01a1a36c-4763-70be-9078-9cb9722ad299€49.00€0.67matched
89capture01a1a36c-7267-787d-9beb-3c16eb28277b€24.00€0.37matched
91capture01a1a36c-7b0a-7334-a2f8-c0475206a924€49.00€0.67matched
92capture01a1a36c-81dc-70a8-b594-88cc71b9ce72€15.00€0.26matched
93capture01a1a36c-d6b0-751d-99bd-3fa94fe0668e€24.00€0.37matched
94capture01a1a36c-ded3-761b-9d86-2dc36e338fbf€15.00€0.26matched
95capture01a1a36c-f259-7978-a5d9-d8f6aa276db8€15.00€0.26matched
96capture01a1a36d-00d6-75f2-af9e-fefc77a81169€49.00€0.67matched
97capture01a1a36d-1ad6-74c6-b58b-bc74ccf45740€9.00€0.19matched