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

Gross

€2,177.00

PSP fee

€37.12

Net to the bank

€2,139.88

Settlement journal

#361248

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a174-1047-7fb9-aed8-a6d035c6aa74 is already settled by stl_EUR_2989516 line 87
  • 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 68, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
LineKindReferenceGrossFeeStatus
32capture01a1a16f-6213-76eb-833e-9fef59759bbc€15.00€0.29fee difference
55capture01a1a171-602d-766a-a76b-fd46cbbf4aba€49.00€0.68fee difference
65capture01a1a172-8dbc-70d2-a98f-69f78544e77b€35.00€0.54fee difference
75capture01a1a173-44a8-7c76-b26f-ce9321e292b6€35.00€0.54fee difference
88capture01a1a174-1070-727c-8e9f-5d139ff88a9f€24.00€0.37duplicate line
1capture01a1a164-658f-7903-bb9c-a108c6b0711e€49.00€0.67matched
2capture01a1a166-5d0c-70e2-b98f-e39156d19936€35.00€0.50matched
3capture01a1a167-8419-7c52-b8d6-a5ae29a82f63€35.00€0.50matched
4capture01a1a16c-9128-7c78-a0b7-3cefcd5f51f8€24.00€0.37matched
5capture01a1a16c-a8ea-73d4-97a0-84dbbe6e1f10€24.00€0.37matched
6capture01a1a16c-c71d-7da5-8564-b989d48a5b82€49.00€0.67matched
7capture01a1a16c-cab3-7cd2-86e4-202486f20176€35.00€0.50matched
8refund01a1a16c-cc33-7fa0-b17d-c17bde32b3c5-€18.00€0.00matched
9capture01a1a16d-07ce-785f-8ed1-c08c718e8a14€49.00€0.67matched
10capture01a1a16d-10ee-7d52-9864-fdacf6f6ba50€35.00€0.50matched
11capture01a1a16d-326a-75d8-a3dc-f0cdbaab2fc8€24.00€0.37matched
12capture01a1a16d-44f2-7159-a495-de509f501912€9.00€0.19matched
13capture01a1a16d-741c-7948-ad5b-dfdf4b74a281€35.00€0.50matched
14capture01a1a16d-abd1-7e7f-8b30-9999aabb6cc0€49.00€0.67matched
15capture01a1a16d-bf29-7780-be0a-7f3bf5caf6fb€49.00€0.67matched
16capture01a1a16d-d313-75c9-9637-19e2c8197243€35.00€0.50matched
17capture01a1a16d-e992-7061-b994-bc614d7d61c6€35.00€0.50matched
18capture01a1a16e-102f-7031-8f7d-abb7044dd95d€15.00€0.26matched
19capture01a1a16e-1f4f-7ffc-a5e6-1f23c2be6ba2€15.00€0.26matched
20capture01a1a16e-2325-7920-b9b5-171e513749f6€9.00€0.19matched
21capture01a1a16e-2e63-7694-a08d-8a79f9c74077€49.00€0.67matched
22capture01a1a16e-48b3-78ee-9b4a-43c5f90827f2€35.00€0.50matched
23capture01a1a16e-5697-765c-8b40-78eae9724df2€9.00€0.19matched
24capture01a1a16e-7536-78cd-960f-f687220524d2€15.00€0.26matched
25refund01a1a16e-905e-7e37-b86b-0c2e8132f6ef-€43.00€0.00matched
26capture01a1a16e-9944-76e9-a23b-a841fc9408d1€9.00€0.19matched
27capture01a1a16f-0091-7e98-9d2f-0f1221e7a48c€49.00€0.67matched
28refund01a1a16f-0e3d-7807-925c-fff2637bfae2-€6.00€0.00matched
29capture01a1a16f-4dc1-77e4-96cf-66614cba9930€15.00€0.26matched
30capture01a1a16f-53f8-79f3-a59b-ff6c8f7072bd€35.00€0.50matched
31capture01a1a16f-5da8-756a-a3a5-559563567437€24.00€0.37matched
33capture01a1a16f-a3da-760e-9be4-31d53830256a€15.00€0.26matched
34refund01a1a16f-b385-748c-b62c-4d86ce7e24cc-€19.00€0.00matched
35capture01a1a16f-c38a-7242-8d96-158b7d0fb5b5€24.00€0.37matched
36refund01a1a16f-cd51-7b71-93fb-7d2f80227fc6-€6.00€0.00matched
37capture01a1a16f-e8cd-7fed-b312-cde6c407e289€24.00€0.37matched
38capture01a1a16f-fc9e-7c07-90a2-a33877bc40b0€49.00€0.67matched
39capture01a1a170-0473-7b98-9109-25a5e68d0b18€15.00€0.26matched
40capture01a1a170-2c8c-768e-b2db-fba646adbc25€15.00€0.26matched
41capture01a1a170-52e3-7f60-ba50-63e938a8ac1b€35.00€0.50matched
42capture01a1a170-661f-7fd8-979f-1fa1fd6430e4€35.00€0.50matched
43capture01a1a170-6990-7d42-809b-871cbc5645ba€9.00€0.19matched
44refund01a1a170-6be3-70a5-b192-8384eb009279-€46.00€0.00matched
45refund01a1a170-9be2-72cf-8afa-2d06345d3064-€10.00€0.00matched
46capture01a1a170-9c88-7429-a026-1aac03b9a0c3€15.00€0.26matched
47capture01a1a170-a094-70ef-99b2-a2fcdc2ce08b€15.00€0.26matched
48capture01a1a170-c7a1-71af-bc14-8d5bf183148a€49.00€0.67matched
49capture01a1a170-dede-7656-bace-64395d3a3ec0€24.00€0.37matched
50capture01a1a170-fde3-7559-b8fa-9227c6dbfaf7€35.00€0.50matched
51capture01a1a171-22a3-7386-9e49-2eae7fafdcea€15.00€0.26matched
52capture01a1a171-3bec-7db0-9a12-6ecf716b4469€35.00€0.50matched
53capture01a1a171-40c8-74f8-b4bc-c8b2eacbf4b3€9.00€0.19matched
54capture01a1a171-54f9-7a0e-8d67-6cd06d0a2ca6€9.00€0.19matched
56capture01a1a171-676e-7cd0-a4d7-e28d3b2c5dbf€9.00€0.19matched
57capture01a1a171-8e70-7231-8ceb-a4900838e300€24.00€0.37matched
58capture01a1a171-93ca-72bb-9311-8fbd302bc281€15.00€0.26matched
59capture01a1a171-9a76-7e29-b7a5-82aa4a55e582€15.00€0.26matched
60capture01a1a171-a154-759f-b2d9-2fbf955d437b€15.00€0.26matched
61capture01a1a171-b6d6-7533-8db2-7de49401e590€35.00€0.50matched
62capture01a1a172-01ef-77e4-b3cf-b68ec104fdea€24.00€0.37matched
63capture01a1a172-0a76-78b5-bc9f-cbcb5e8b3427€9.00€0.19matched
64refund01a1a172-6232-7efa-be5b-a2ddaa1a6eba-€2.00€0.00matched
66capture01a1a172-a2d0-7e65-a1b0-442947e6d6a9€24.00€0.37matched
67capture01a1a172-ba79-7e15-87d8-cb2a78dac9ce€49.00€0.67matched
68capture01a1a172-bda0-74a7-8760-98e273284f31€15.00€0.26matched
69capture01a1a172-d34d-7665-81d0-c78d9b670cad€49.00€0.67matched
70refund01a1a172-f2e0-7590-9c7f-92ed967ee1e5-€16.00€0.00matched
71capture01a1a172-fb95-7edc-acdc-d9db7929357b€15.00€0.26matched
72capture01a1a173-0037-7f49-93a0-061461c8834c€35.00€0.50matched
73capture01a1a173-1e13-724b-a435-92eda756c3be€9.00€0.19matched
74capture01a1a173-2400-74f0-9c50-97a9a00cd5ba€49.00€0.67matched
76refund01a1a173-47a4-75ba-ace3-99e38cc214b9-€27.00€0.00matched
77capture01a1a173-489a-7a64-91ab-6c57daa5fe23€35.00€0.50matched
78capture01a1a173-54a0-7604-a0e5-6b731ced607e€15.00€0.26matched
79capture01a1a173-996b-7b81-a2fa-9677f7dd0eab€15.00€0.26matched
80capture01a1a173-b056-7a57-92fa-d1436efa642a€9.00€0.19matched
81capture01a1a173-c3c3-75c6-8fa0-0fca1324aa06€49.00€0.67matched
82capture01a1a173-e9e5-7ed4-9299-7ae1ac142989€35.00€0.50matched
83refund01a1a173-ed5b-7cba-a26d-14b1eff7a462-€10.00€0.00matched
84refund01a1a173-ee4c-7232-b852-cd319c418574-€12.00€0.00matched
85capture01a1a173-ee4b-7aa6-9c4d-c698cf568f4c€9.00€0.19matched
86capture01a1a174-04b4-73a2-8da9-37bd93d00d4a€49.00€0.67matched
87capture01a1a174-1070-727c-8e9f-5d139ff88a9f€24.00€0.37matched
89capture01a1a174-215f-712f-a78e-699039a2dd2f€9.00€0.19matched
90capture01a1a174-3810-74fd-93bc-09f1a897653e€24.00€0.37matched
91capture01a1a174-4a46-7887-bad7-a82f550e203d€15.00€0.26matched
92capture01a1a174-60f4-77c5-b403-1c6491029345€35.00€0.50matched
93refund01a1a174-83df-70cb-8eb9-e7628ae1993f-€7.00€0.00matched
94capture01a1a174-9511-7372-9160-40d88d86691d€9.00€0.19matched
95refund01a1a174-98da-706c-a162-87f06ec7b3ae-€4.00€0.00matched
96capture01a1a174-afdd-7157-8524-8f7021d19b9f€24.00€0.37matched
97capture01a1a174-bd3e-7ce2-a874-30e3570ed6d9€15.00€0.26matched
98capture01a1a174-c923-7c94-82fc-5613c98a9fe0€9.00€0.19matched
99capture01a1a174-e7a2-76e6-9229-88cf024a61ab€24.00€0.37matched
100capture01a1a174-ec58-77ea-85b9-0717a3aeeb25€35.00€0.50matched
101capture01a1a174-f3eb-71a2-be17-24ea2f9ffdb0€9.00€0.19matched
102capture01a1a175-1564-72ca-8d1d-36d4a0bcf158€35.00€0.50matched
103capture01a1a175-2348-7f05-a610-18bd84aecfa4€9.00€0.19matched
104refund01a1a175-2a71-7831-9787-17b94baab1b4-€9.00€0.00matched
105capture01a1a175-3021-703f-b2a4-329234d0e7a1€24.00€0.37matched
106capture01a1a175-459d-7a2c-a75a-4ef2d427a3f8€9.00€0.19matched
107capture01a1a175-4c6c-75a7-8207-80d234d907f0€49.00€0.67matched
108capture01a1a175-76f1-78b0-bd2c-c62c250075ee€24.00€0.37matched
109refund01a1a175-816d-7321-949c-c161a43b7c3a-€36.00€0.00matched
110capture01a1a175-8414-72bc-9101-96199a264284€24.00€0.37matched