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

6 Nov, 13:00

Gross

€2,391.00

PSP fee

€37.66

Net to the bank

€2,353.34

Settlement journal

#416448

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1b0f5-cad0-7e23-a459-015b892c9002 is already settled by stl_EUR_2989950 line 51
  • duplicate linethe file lists it twicecapture:01a1b0f8-cebe-7ee7-a98e-437e9c3a6f00 is already settled by stl_EUR_2989950 line 80
  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
LineKindReferenceGrossFeeStatus
52capture01a1b0f5-e0e5-78dc-807a-b7f47b29f4a5€24.00€0.37duplicate line
81capture01a1b0f8-cee2-7bde-b376-ac6dbf07faa7€24.00€0.37duplicate line
94capture01a1b0fa-3247-7041-b7da-de84e1d06f0e€9.00€0.24fee difference
1refund01a1b0e8-f0af-7fae-b7ec-6f0ca025f3aa-€25.00€0.00matched
2capture01a1b0ec-66a5-7ef0-8a69-e4dab37ed871€49.00€0.67matched
3capture01a1b0f0-086c-78c7-b9ac-11c75d33c79e€9.00€0.19matched
4capture01a1b0f0-f441-77f8-9d3f-df22922c38e6€35.00€0.50matched
5capture01a1b0f1-f5c5-7e0c-a80e-c424a37b280e€9.00€0.19matched
6capture01a1b0f2-24dc-71f9-b83d-6dbe8969e1c2€49.00€0.67matched
7capture01a1b0f2-2a5d-79bd-adf0-92c8354aca29€9.00€0.19matched
8capture01a1b0f2-2c2b-79f0-9a7f-7539fe6e9abf€9.00€0.19matched
9capture01a1b0f2-347f-785b-8f17-65ce3eb5bf69€24.00€0.37matched
10capture01a1b0f2-36dc-77ff-bf0f-bfecaa087c14€9.00€0.19matched
11capture01a1b0f2-454e-71a3-af24-1c41706eebc5€9.00€0.19matched
12capture01a1b0f2-5cdc-7e6d-b191-c93f967d487a€9.00€0.19matched
13capture01a1b0f2-5f13-76e5-9212-de41069d6c7c€24.00€0.37matched
14capture01a1b0f2-93f0-7dd7-8aea-f7aa68624530€35.00€0.50matched
15capture01a1b0f2-c50b-7ff7-873e-3cbcb7aae56e€35.00€0.50matched
16capture01a1b0f2-cf66-75a1-8406-ecdeea6d1dd4€49.00€0.67matched
17capture01a1b0f2-df79-7f61-b67f-088397f135f4€35.00€0.50matched
18capture01a1b0f2-e6c2-7cce-87c2-8655c6bfbe70€9.00€0.19matched
19capture01a1b0f3-11af-7aa4-b68b-0934a685f59d€35.00€0.50matched
20capture01a1b0f3-134c-7cd4-8cb5-8cf56b85cd20€35.00€0.50matched
21capture01a1b0f3-4cb6-724e-bf89-a8070f54835d€9.00€0.19matched
22capture01a1b0f3-6036-78af-ab1b-dc92fce48203€35.00€0.50matched
23capture01a1b0f3-6268-765a-80a3-6a7f33e7bc68€24.00€0.37matched
24capture01a1b0f3-6fd6-777f-8d36-1652fa925ca2€9.00€0.19matched
25capture01a1b0f3-aaaf-7a90-9bd9-9be2395e4564€49.00€0.67matched
26capture01a1b0f3-dd95-7ee6-ab28-a87a6023f583€35.00€0.50matched
27capture01a1b0f4-06b3-7701-b8de-ed3317fd1e79€24.00€0.37matched
28capture01a1b0f4-0d83-730b-924a-a6bb6978f162€24.00€0.37matched
29capture01a1b0f4-1344-795f-a5ff-438aab0f7166€35.00€0.50matched
30capture01a1b0f4-232e-7976-94cc-c97f3a79d48c€49.00€0.67matched
31capture01a1b0f4-220d-7690-8c41-0a2bdaa9e72a€24.00€0.37matched
32capture01a1b0f4-64cb-787a-b478-8c36d1e3f2c9€9.00€0.19matched
33capture01a1b0f4-73fd-7e08-a6d4-820b61e72210€49.00€0.67matched
34capture01a1b0f4-7767-7fa4-9451-77ced324f099€24.00€0.37matched
35capture01a1b0f4-8cd3-79f6-9c15-fb967e6ab0da€49.00€0.67matched
36refund01a1b0f4-a9fe-7c00-bfcc-e68b51756b83-€28.00€0.00matched
37capture01a1b0f4-c5e1-7b8e-ae43-fd0148ce6d15€24.00€0.37matched
38capture01a1b0f4-f204-7139-9cff-87644e0ba623€15.00€0.26matched
39capture01a1b0f5-01da-7374-acd6-3ac6cde6cc22€35.00€0.50matched
40capture01a1b0f5-4928-7467-babb-23aee759395d€49.00€0.67matched
41capture01a1b0f5-4c54-715f-9a8d-0aa186e2eb0d€24.00€0.37matched
42refund01a1b0f5-5afc-75e4-9dcf-1ae87d3824c7-€4.00€0.00matched
43capture01a1b0f5-594c-795a-9d7d-1431b0beb0de€9.00€0.19matched
44capture01a1b0f5-8c11-7cdc-bda1-962fd3f046b8€35.00€0.50matched
45capture01a1b0f5-9286-77a3-820e-6e2f730e859e€49.00€0.67matched
46capture01a1b0f5-b28d-7578-ac2a-8938b93795f5€15.00€0.26matched
47capture01a1b0f5-b608-7fe7-8f8c-9e458c85b33d€9.00€0.19matched
48capture01a1b0f5-c2e3-712f-96f1-e5f8abd6d8d1€35.00€0.50matched
49capture01a1b0f5-c6c4-770b-86f2-cdbe5b77e469€24.00€0.37matched
50capture01a1b0f5-ca7c-7c2c-853e-4658e81b6fc9€9.00€0.19matched
51capture01a1b0f5-e0e5-78dc-807a-b7f47b29f4a5€24.00€0.37matched
53capture01a1b0f6-20ad-79a5-a580-4b3cc4491820€9.00€0.19matched
54capture01a1b0f6-24da-7dff-b5f8-c7b469c3dc55€35.00€0.50matched
55capture01a1b0f6-2bee-71a7-85ef-b4540a1e3061€15.00€0.26matched
56capture01a1b0f6-535f-7909-8f7f-29978b35392b€9.00€0.19matched
57capture01a1b0f6-6830-7b71-a01d-43a03d75651d€15.00€0.26matched
58capture01a1b0f6-de8b-7723-8078-42459b994a68€9.00€0.19matched
59capture01a1b0f7-1187-71b9-a3b6-d40ce09c9440€35.00€0.50matched
60capture01a1b0f7-3064-797a-9b4c-335744267841€15.00€0.26matched
61capture01a1b0f7-3200-7d1b-8c3b-42099fbd34f3€9.00€0.19matched
62capture01a1b0f7-4cb1-7a5a-be22-98d3c12cdf0f€24.00€0.37matched
63capture01a1b0f7-4dfb-7368-b54b-d4d4c60ffa77€35.00€0.50matched
64capture01a1b0f7-5629-732e-bcbc-8f3acfe4a0fb€9.00€0.19matched
65capture01a1b0f7-809d-7345-ab6a-fb0532f3287a€49.00€0.67matched
66capture01a1b0f7-8dc7-7cf0-be4e-b156f6bf881c€9.00€0.19matched
67capture01a1b0f7-b568-7f9d-aff4-a8891f2baa12€49.00€0.67matched
68capture01a1b0f7-bde5-794b-9841-21f21e253ace€49.00€0.67matched
69capture01a1b0f7-c623-7ff5-bfb5-63086fd316ff€49.00€0.67matched
70capture01a1b0f7-c637-7513-b659-22598dc95edb€15.00€0.26matched
71refund01a1b0f8-0357-7e33-9a45-3dea1e0d81e6-€6.00€0.00matched
72capture01a1b0f8-0804-748d-8aec-3049fc4441c7€49.00€0.67matched
73capture01a1b0f8-13b1-78d8-aa93-bdc3cf188996€49.00€0.67matched
74capture01a1b0f8-3bd8-7153-945b-4375b41486fc€9.00€0.19matched
75capture01a1b0f8-408a-7cf8-8f1c-10ca41983ac0€15.00€0.26matched
76capture01a1b0f8-4505-78de-a89d-2b515cc501f7€9.00€0.19matched
77capture01a1b0f8-9d08-72f5-ba7e-d270de4b4600€35.00€0.50matched
78capture01a1b0f8-9d51-7cbd-a05a-84dbf30a9302€9.00€0.19matched
79refund01a1b0f8-b553-771d-ad7e-ac7434e0fb3a-€7.00€0.00matched
80capture01a1b0f8-cee2-7bde-b376-ac6dbf07faa7€24.00€0.37matched
82capture01a1b0f8-ee25-7dcc-8d62-3abc4ab07b9f€24.00€0.37matched
83capture01a1b0f8-f0a3-794c-af08-d5552d670e52€24.00€0.37matched
84capture01a1b0f9-05e7-7758-87d1-d578da929115€24.00€0.37matched
85capture01a1b0f9-0846-7635-beca-63c3980bd940€15.00€0.26matched
86capture01a1b0f9-0922-7e9e-bdfa-8906f08514a0€35.00€0.50matched
87capture01a1b0f9-7dd0-7284-856a-4032b2b6a2dc€15.00€0.26matched
88capture01a1b0f9-8150-7e1e-b514-7b4b8d00d7de€24.00€0.37matched
89capture01a1b0f9-96f2-7780-a2ff-81620d2792df€24.00€0.37matched
90capture01a1b0f9-a1ef-765f-844d-a98d9b5ca8c3€24.00€0.37matched
91capture01a1b0f9-aa00-7417-a43a-25a77c82adc2€9.00€0.19matched
92capture01a1b0f9-e679-70ec-8abe-e448bfe7a594€24.00€0.37matched
93capture01a1b0fa-2c6d-7526-8a83-ac45fd48dbb7€9.00€0.19matched
95refund01a1b0fa-4ed0-791c-b970-81b87b8b6ac7-€9.00€0.00matched
96capture01a1b0fa-6293-77ec-8c0d-b042e2d1f894€9.00€0.19matched
97capture01a1b0fa-8b78-7e88-a5ec-d7eb94052320€35.00€0.50matched
98capture01a1b0fa-b023-74cc-9173-159f4abf7ec8€35.00€0.50matched
99capture01a1b0fa-b03b-7527-97cc-2fa71b33564a€35.00€0.50matched
100capture01a1b0fa-bd55-774b-b211-88fb0fc3f86f€15.00€0.26matched
101capture01a1b0fa-cc28-7c1e-a511-dc628d6f4f2b€15.00€0.26matched
102capture01a1b0fa-ead9-70e1-bcef-4eccad21387a€49.00€0.67matched
103capture01a1b0fa-ed8a-70d0-bf2c-57c3c8b55dac€35.00€0.50matched
104capture01a1b0fa-f60a-79b6-8cde-034a080f3f16€15.00€0.26matched