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, 04:00

Gross

€2,706.00

PSP fee

€43.87

Net to the bank

€2,662.13

Settlement journal

#372894

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a4b7-2d52-7d3a-886a-b7dfdb105daa is already settled by stl_EUR_2989608 line 9
  • 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 20, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 29, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 20, the contract says 19
  • missing linein the books, not in the filecapture:01a1a4b6-ff0b-781a-a850-f912dab6b12e is in no file
  • missing linein the books, not in the filecapture:01a1a4bd-1700-733e-ae16-559d8e53ff3a is in no file
LineKindReferenceGrossFeeStatus
4capture01a1a4b6-d7d3-7cf4-880a-a740ec22ca53€9.00€0.20fee difference
10capture01a1a4b7-2d6c-798c-add7-932ba5f611e7€9.00€0.19duplicate line
26capture01a1a4b8-abe0-7613-853e-dadfe857c4a9€9.00€0.20fee difference
35capture01a1a4b9-7802-7ef1-9adc-82dfc7beccc5€15.00€0.29fee difference
115capture01a1a4be-fa0a-7469-a79a-e3fc7132997c€9.00€0.20fee difference
1capture01a1a4ad-fb3d-71fa-b87d-96db0b689950€49.00€0.67matched
2capture01a1a4ae-00cf-7567-a8ba-f0201238aafd€9.00€0.19matched
3capture01a1a4b6-cc0d-78bb-b3ba-059c7ac0a150€49.00€0.67matched
5capture01a1a4b6-d886-7596-a9f3-f1b9b25a39cf€49.00€0.67matched
6capture01a1a4b6-f948-7596-b6f8-c65e5cea441b€49.00€0.67matched
7capture01a1a4b7-03e7-7443-ad2e-ab714a3d6aea€15.00€0.26matched
8refund01a1a4b7-1475-75d4-a0cf-2bf4687880c9-€10.00€0.00matched
9capture01a1a4b7-2d6c-798c-add7-932ba5f611e7€9.00€0.19matched
11capture01a1a4b7-2f02-7e59-b6fc-fb6170439d7b€15.00€0.26matched
12capture01a1a4b7-4baf-74ec-bb78-9350870afb4d€15.00€0.26matched
13capture01a1a4b7-7ac0-76fc-9958-a3416f05ed04€15.00€0.26matched
14capture01a1a4b7-a4de-72b4-946e-59771b34c365€24.00€0.37matched
15capture01a1a4b7-a660-73cd-a6df-a2a114581a13€35.00€0.50matched
16capture01a1a4b7-cd40-759c-b34b-6f209b82137e€24.00€0.37matched
17capture01a1a4b7-e262-7aab-aefe-9075c09d29c2€24.00€0.37matched
18capture01a1a4b7-f7b5-7d6b-9933-cb078fc30383€9.00€0.19matched
19capture01a1a4b8-011c-795d-a27b-32c2af111b55€9.00€0.19matched
20capture01a1a4b8-111f-7e21-a299-bb43e41a898a€15.00€0.26matched
21capture01a1a4b8-1d1d-70e1-bb29-c6fa89a07949€24.00€0.37matched
22capture01a1a4b8-4ac0-7fd2-894b-990c9a3755b0€15.00€0.26matched
23capture01a1a4b8-4d01-7f7c-ae90-ac2b3123467f€15.00€0.26matched
24capture01a1a4b8-5484-799e-bcfa-277327e10263€35.00€0.50matched
25capture01a1a4b8-a40d-7857-8535-60d26d75140f€35.00€0.50matched
27capture01a1a4b8-afdb-7e02-be90-57ff37484c16€9.00€0.19matched
28capture01a1a4b8-dfe5-72df-b81b-82f9f5be4717€49.00€0.67matched
29refund01a1a4b8-f2d4-7eca-b262-a8c9a5c6180f-€5.00€0.00matched
30capture01a1a4b8-f784-7f09-ace1-e87da3bc021e€15.00€0.26matched
31capture01a1a4b8-fc78-74b7-8c08-b4e7c4c79462€15.00€0.26matched
32capture01a1a4b9-11a7-7978-a305-2bbe99b36a83€9.00€0.19matched
33capture01a1a4b9-16b1-7332-a801-70722d670409€49.00€0.67matched
34capture01a1a4b9-54d2-7c2c-ada0-b00ebb10caa8€9.00€0.19matched
36capture01a1a4b9-830c-79ff-8ffd-b7d1601faa02€49.00€0.67matched
37capture01a1a4b9-87d5-7ca3-819c-2155ec9eb6c4€35.00€0.50matched
38capture01a1a4b9-93aa-7cda-85f2-09ddc89b03a6€9.00€0.19matched
39capture01a1a4b9-9492-7bcc-90bf-65eb7f3c5701€15.00€0.26matched
40capture01a1a4b9-9562-7178-9c6e-d32637c777ad€24.00€0.37matched
41capture01a1a4b9-9c0c-758e-9aad-63e6eadfafae€24.00€0.37matched
42capture01a1a4b9-a724-7f12-aae9-a9103872684d€24.00€0.37matched
43capture01a1a4b9-c19f-7c7a-913d-f4c77e922024€15.00€0.26matched
44capture01a1a4ba-1191-78ec-9cb7-af5bdff5d7b5€35.00€0.50matched
45capture01a1a4ba-2c99-7337-b03a-d5181cbfbeec€15.00€0.26matched
46capture01a1a4ba-459e-7850-a45e-e5c3600f7d7e€9.00€0.19matched
47capture01a1a4ba-7cd0-74e8-9dd0-7d176ca0821e€35.00€0.50matched
48capture01a1a4ba-894f-741f-8d2c-dce902e3a92f€24.00€0.37matched
49refund01a1a4ba-8afa-72ab-837a-45a0194be2c5-€14.00€0.00matched
50capture01a1a4ba-89b7-7978-8279-6c2ce820c330€9.00€0.19matched
51capture01a1a4ba-8ea3-7043-bac4-70dd7e9faaf3€15.00€0.26matched
52capture01a1a4ba-9bd0-726a-b959-6a4c354bd8e3€9.00€0.19matched
53capture01a1a4ba-9d39-72f7-ba61-0200a850f59c€24.00€0.37matched
54capture01a1a4ba-b247-77cc-b959-8c53d1992066€35.00€0.50matched
55capture01a1a4ba-b630-7d8c-81c5-e8e182f07357€24.00€0.37matched
56capture01a1a4ba-bc5f-7690-8af5-732334f3c1e9€15.00€0.26matched
57capture01a1a4ba-d573-7400-902c-937771892e77€9.00€0.19matched
58capture01a1a4ba-fb01-7cf9-8597-a331de9f595d€24.00€0.37matched
59capture01a1a4bb-17c8-771a-b38d-bf4749d7adb5€35.00€0.50matched
60capture01a1a4bb-1945-7274-8ab0-192ff23bfd55€24.00€0.37matched
61capture01a1a4bb-398d-7747-ad76-98a85d7f9744€35.00€0.50matched
62capture01a1a4bb-5da9-763d-80ac-cd5969271bd0€9.00€0.19matched
63capture01a1a4bb-6af7-7cf1-8a80-a86bb9b474bb€49.00€0.67matched
64capture01a1a4bb-8114-7132-9555-58c10e69b569€35.00€0.50matched
65capture01a1a4bb-8a09-711c-abcc-ed779b8e1444€15.00€0.26matched
66capture01a1a4bb-8d45-7a5c-87ef-2d2d8dfeb9ac€15.00€0.26matched
67capture01a1a4bb-abb0-79d2-ac9d-e5b9f2ae97a6€49.00€0.67matched
68capture01a1a4bb-b1fc-7608-a3dd-659d9c2b2817€24.00€0.37matched
69capture01a1a4bb-c0d7-7b4d-ae21-3c4e49c0fcf5€9.00€0.19matched
70capture01a1a4bb-c75a-7700-9b85-b20c4960c425€24.00€0.37matched
71capture01a1a4bb-c93c-7685-98fc-941b1cba63e8€24.00€0.37matched
72capture01a1a4bb-ce12-7657-854b-9f22661ef58e€15.00€0.26matched
73capture01a1a4bb-d484-7a80-85b0-f77b49c9e6b7€9.00€0.19matched
74capture01a1a4bb-e028-7187-bbc5-d95a9d61d692€9.00€0.19matched
75refund01a1a4bb-ebe2-7556-afa4-efeb574e39eb-€13.00€0.00matched
76capture01a1a4bc-0046-7445-8a93-bddf42d80dc9€9.00€0.19matched
77capture01a1a4bc-1516-7805-8168-29e383944070€49.00€0.67matched
78capture01a1a4bc-37cb-78ea-b35e-1bce81d9dec6€24.00€0.37matched
79capture01a1a4bc-37e2-748c-bb8d-e96f225931b2€49.00€0.67matched
80capture01a1a4bc-50db-739b-b19d-1263b75a0aa4€15.00€0.26matched
81capture01a1a4bc-603a-711b-9ca1-8056063f2008€15.00€0.26matched
82refund01a1a4bc-775b-7c5c-8867-6ea2b82a858e-€13.00€0.00matched
83capture01a1a4bc-8cff-7507-a2f5-3e8d84c86e8e€49.00€0.67matched
84capture01a1a4bc-b243-7906-811e-49d54eb44590€15.00€0.26matched
85capture01a1a4bc-b3ff-7eeb-b200-87de8e7593b8€24.00€0.37matched
86capture01a1a4bc-d7dd-7fb0-9851-c758270002f4€9.00€0.19matched
87capture01a1a4bd-1ae7-7cb3-840a-ee663325e41b€24.00€0.37matched
88capture01a1a4bd-29f5-7a24-8a62-c55c6f169d6f€15.00€0.26matched
89capture01a1a4bd-4fe1-77c4-9dd5-cc40dd32b579€24.00€0.37matched
90capture01a1a4bd-501f-7c2f-9953-5c6ff84afb77€15.00€0.26matched
91refund01a1a4bd-51e7-7271-9097-63431fccbea9-€16.00€0.00matched
92capture01a1a4bd-6128-7def-8e46-4f04fe83de20€15.00€0.26matched
93capture01a1a4bd-6b01-7053-8591-fb6e2fc990df€9.00€0.19matched
94capture01a1a4bd-8d41-7bff-b02a-f3aa8d8b0f95€9.00€0.19matched
95capture01a1a4bd-93e9-7c14-b906-c9b292dc12e4€35.00€0.50matched
96capture01a1a4bd-a5a6-7ece-bb1d-0225e0966a91€49.00€0.67matched
97capture01a1a4bd-b39b-7d3a-9f89-c4250fa70711€15.00€0.26matched
98capture01a1a4bd-b908-7d77-bc7c-194a404b829d€35.00€0.50matched
99capture01a1a4bd-bf97-7525-a670-e0ffbcaf55fa€15.00€0.26matched
100capture01a1a4bd-c53d-7fb8-a126-87426ed5baa3€49.00€0.67matched
101refund01a1a4bd-d689-70b4-9964-19c96fc18ee3-€9.00€0.00matched
102capture01a1a4bd-fdc6-7876-913f-0acb36e3ad5c€24.00€0.37matched
103capture01a1a4be-15f3-70cd-9a92-ac97f689c13a€9.00€0.19matched
104capture01a1a4be-3109-778f-8696-3573d1207cfd€9.00€0.19matched
105capture01a1a4be-3e91-789b-b2c7-8af18c404e6f€9.00€0.19matched
106capture01a1a4be-3f71-7930-aa4f-a72d455f7189€15.00€0.26matched
107capture01a1a4be-7c3a-7984-8de6-55fd0c0f6228€9.00€0.19matched
108capture01a1a4be-9c70-7634-b1d1-4fb0689661f6€35.00€0.50matched
109capture01a1a4be-9d50-7cef-a726-26476aa7fcb8€35.00€0.50matched
110capture01a1a4be-9e0f-76d5-97ef-62ca3d58bdbf€15.00€0.26matched
111capture01a1a4be-afd9-7f61-9416-0907b447e570€9.00€0.19matched
112capture01a1a4be-b048-7ffd-a907-95bea7e7e86a€35.00€0.50matched
113capture01a1a4be-b680-7bac-86ef-a9097c4ae627€35.00€0.50matched
114capture01a1a4be-e69f-74e9-9a8c-b3aa1bb2886e€15.00€0.26matched
116capture01a1a4bf-132d-7394-b453-c36bef3cbff9€35.00€0.50matched
117capture01a1a4bf-4122-7dc1-81bf-c58818c2ee26€9.00€0.19matched
118capture01a1a4bf-4388-7433-9f00-1f787b6a60ae€24.00€0.37matched
119capture01a1a4bf-473f-7220-bf5b-793fa78b143f€9.00€0.19matched
120capture01a1a4bf-48c6-7522-98d8-ed853c1a5612€35.00€0.50matched
121capture01a1a4bf-5420-73ea-b52a-403832ff840f€24.00€0.37matched
122capture01a1a4bf-5ae4-78cb-abb4-0408ef3d6a58€35.00€0.50matched
123capture01a1a4bf-5eb6-7bca-b145-e5ff4e55f502€15.00€0.26matched
124refund01a1a4bf-5eb8-748a-b88c-bbb25fb69232-€9.00€0.00matched
125capture01a1a4bf-72cb-7a07-81d1-09666bb121a3€35.00€0.50matched
126capture01a1a4bf-7645-73bf-971f-da15a20bc114€49.00€0.67matched
127capture01a1a4bf-a094-7180-a8c6-af9c500ad0b5€49.00€0.67matched
128capture01a1a4bf-acab-7f5b-ae66-c09bf2112f9f€15.00€0.26matched
129capture01a1a4bf-b6ea-723c-b226-803eb659f2aa€35.00€0.50matched
130capture01a1a4bf-bcb5-7d8e-b9ab-38924de462e7€35.00€0.50matched
131refund01a1a4bf-c98d-7cce-8a41-968212c6f7cf-€31.00€0.00matched