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, 16:30

Gross

€3,279.00

PSP fee

€51.62

Net to the bank

€3,227.38

Settlement journal

#400711

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 24, the contract says 19
  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
LineKindReferenceGrossFeeStatus
81capture01a1ac90-d324-710a-985d-f73970394482€9.00€0.24fee difference
83capture01a1ac91-0227-7e7d-a5ec-9906d96ebf6f€24.00€0.39fee difference
1capture01a1ac85-b274-79d3-8736-f919122cd25c€35.00€0.50matched
2capture01a1ac8a-54fd-7fa9-bf0b-bbb84dc5915b€24.00€0.37matched
3capture01a1ac8b-b000-77e7-8a1e-34b5c63e47e0€24.00€0.37matched
4capture01a1ac8b-d5bf-7a7c-b1d1-b3252ce5c220€49.00€0.67matched
5capture01a1ac8b-da74-7244-9057-c3882bd23915€49.00€0.67matched
6capture01a1ac8b-ef85-71e8-8155-7b41aa2c837f€15.00€0.26matched
7capture01a1ac8b-f14d-7832-9b0c-ddb8fe7efe99€9.00€0.19matched
8capture01a1ac8c-0b5a-70a5-adb8-32349b34d065€15.00€0.26matched
9capture01a1ac8c-0ee0-7d07-a4c2-60bdf386064e€9.00€0.19matched
10capture01a1ac8c-131d-75df-a72d-180e2ab7d73a€9.00€0.19matched
11capture01a1ac8c-1536-71c5-aa16-4706b8c4a7be€49.00€0.67matched
12capture01a1ac8c-3468-738f-b4c5-fb865645408e€24.00€0.37matched
13capture01a1ac8c-60bf-766f-82b7-5fc06c4384db€49.00€0.67matched
14capture01a1ac8c-70e7-710a-a6bb-e25171197f85€24.00€0.37matched
15capture01a1ac8c-8532-7794-94ac-278af24615d9€35.00€0.50matched
16capture01a1ac8c-8f6e-7609-b2b5-7585d91afc68€24.00€0.37matched
17capture01a1ac8c-9549-7ecb-911a-63db61a94822€24.00€0.37matched
18capture01a1ac8c-9c8f-74e9-90ee-f6e68cfd8b87€49.00€0.67matched
19capture01a1ac8c-b19d-7293-b399-1e14665dba6e€49.00€0.67matched
20refund01a1ac8c-c01a-742c-abbb-b4f3c1a57ffc-€7.00€0.00matched
21capture01a1ac8c-d87c-7d76-bdc8-94bc16a14274€35.00€0.50matched
22capture01a1ac8c-e21f-7fbc-8aa1-8bfc30c33fdf€15.00€0.26matched
23capture01a1ac8d-0b47-7a8e-ba14-98abacf7a905€15.00€0.26matched
24capture01a1ac8d-1517-77ee-a8ae-c017b3c031a6€9.00€0.19matched
25capture01a1ac8d-179a-75bd-8249-d171db1b0e8f€9.00€0.19matched
26capture01a1ac8d-27fa-7ddc-b399-64778c859d73€9.00€0.19matched
27capture01a1ac8d-33cb-73b4-9445-ce9b3f15b8b9€24.00€0.37matched
28capture01a1ac8d-3b21-7314-9a8c-fd2ffae67538€15.00€0.26matched
29capture01a1ac8d-4810-72e8-be01-a40622993010€24.00€0.37matched
30capture01a1ac8d-4d3f-7e0b-a50b-e5a732406166€24.00€0.37matched
31capture01a1ac8d-58c0-7901-a00b-0fc5f8262a45€9.00€0.19matched
32refund01a1ac8d-5f97-77d6-bf29-ee5797617df4-€6.00€0.00matched
33capture01a1ac8d-7adc-7a98-ab31-bd5e6b348fea€49.00€0.67matched
34refund01a1ac8d-873e-734a-97d3-ba6242cafeba-€6.00€0.00matched
35refund01a1ac8d-96e7-75ea-8df8-ccdaffae814a-€9.00€0.00matched
36capture01a1ac8d-9c7a-74a2-b4c8-6d32c14f8ba8€35.00€0.50matched
37capture01a1ac8d-a69d-75c1-9608-784c01827820€9.00€0.19matched
38refund01a1ac8d-a726-7a77-bbfa-07db1f1dad5a-€3.00€0.00matched
39capture01a1ac8d-b4c2-73ef-bce8-4cf0f5351d35€9.00€0.19matched
40capture01a1ac8d-c1da-7fe3-975e-a1a3d0bbb67a€35.00€0.50matched
41capture01a1ac8d-ddc0-7770-a092-16a48d4bd31f€35.00€0.50matched
42capture01a1ac8e-2405-74a9-aeda-98a6c9405cb6€35.00€0.50matched
43capture01a1ac8e-2b79-778d-8d85-ee5957911e65€24.00€0.37matched
44capture01a1ac8e-3e31-79c5-b78a-4267b4e6ddcf€15.00€0.26matched
45capture01a1ac8e-4c4e-7bb8-9aa0-7a9afe7321a8€9.00€0.19matched
46capture01a1ac8e-4cb0-74c8-8a74-f54835a8f31d€49.00€0.67matched
47capture01a1ac8e-5e3d-7504-a8eb-7e9eb94cad64€35.00€0.50matched
48capture01a1ac8e-65cc-747b-a864-e1ee9368edbc€15.00€0.26matched
49capture01a1ac8e-69da-76b3-b325-47ff6fe434b5€15.00€0.26matched
50refund01a1ac8e-6fd8-72ae-bda0-2b1a37772d8e-€7.00€0.00matched
51capture01a1ac8e-8d9c-74ed-8749-dd942c43d7e7€24.00€0.37matched
52refund01a1ac8e-b374-712c-ab47-ef67e64651fb-€8.00€0.00matched
53capture01a1ac8e-b9df-7e28-82f7-4872601f07a2€9.00€0.19matched
54capture01a1ac8e-c575-765c-b43c-9cf1e67322cc€49.00€0.67matched
55capture01a1ac8e-d195-7159-b958-c7071524499c€9.00€0.19matched
56capture01a1ac8e-e153-7a3d-8a1a-c404d6423f5d€9.00€0.19matched
57capture01a1ac8e-e1e9-77a9-91f7-27e3056de1c4€49.00€0.67matched
58capture01a1ac8e-e581-76b7-93c4-5afc73c927a8€9.00€0.19matched
59capture01a1ac8f-095b-7284-b4ba-8afb17397a3b€49.00€0.67matched
60capture01a1ac8f-464a-7418-8b63-ba8d23470328€15.00€0.26matched
61capture01a1ac8f-9d56-769c-bc9b-b3185ab59289€24.00€0.37matched
62capture01a1ac8f-9ff9-729c-ae31-7901caf7bdc2€15.00€0.26matched
63capture01a1ac8f-a345-76ee-9e50-bab7e96aa866€15.00€0.26matched
64capture01a1ac8f-ac38-71fd-87a5-b13ae7cc70f2€24.00€0.37matched
65capture01a1ac8f-bd7f-7c59-871f-c3dd7cfbc647€35.00€0.50matched
66capture01a1ac8f-c373-73c7-8df1-99e5360c84bc€9.00€0.19matched
67capture01a1ac8f-ecc0-74df-929d-72a482bdfbff€15.00€0.26matched
68capture01a1ac90-0035-79f9-a094-df22ac37fc1e€35.00€0.50matched
69capture01a1ac90-16c6-7d2f-ab44-8e51a6e6c912€35.00€0.50matched
70capture01a1ac90-1b97-7e3c-bfb8-09cd1446f71d€35.00€0.50matched
71capture01a1ac90-2292-7d4d-8aaf-67d54935b8e4€15.00€0.26matched
72capture01a1ac90-385b-7456-ba66-bf15e7363261€24.00€0.37matched
73refund01a1ac90-4a6d-7b58-88a4-2c0238593723-€4.00€0.00matched
74capture01a1ac90-4a89-7250-977f-0cc3f0d0dd74€49.00€0.67matched
75capture01a1ac90-6822-7337-bdaf-dec1747d1bf3€35.00€0.50matched
76capture01a1ac90-7dfb-796e-93b0-1067f7984161€15.00€0.26matched
77capture01a1ac90-7fa3-7803-9f84-ab9cec5528ad€35.00€0.50matched
78capture01a1ac90-a708-72da-947f-ae399e638ce4€24.00€0.37matched
79capture01a1ac90-c2ad-73a2-a4ee-b39fcd7d7220€9.00€0.19matched
80capture01a1ac90-d304-75c6-ba58-9c0b82afa989€15.00€0.26matched
82capture01a1ac90-fcf1-72c9-b249-884d0fb2c87c€49.00€0.67matched
84capture01a1ac91-17a3-7664-8f98-91a5ea648d4f€35.00€0.50matched
85capture01a1ac91-333b-7a76-a673-7c545e9b882e€9.00€0.19matched
86capture01a1ac91-3a3f-7b9f-946d-1ee064cc79a1€35.00€0.50matched
87capture01a1ac91-3bbf-7281-8163-99be1e1d116e€15.00€0.26matched
88capture01a1ac91-7890-74bc-a4ce-b28723431a00€49.00€0.67matched
89capture01a1ac91-8383-7164-b2c2-b00b56ec0b05€15.00€0.26matched
90capture01a1ac91-8b93-7141-8b70-582fcaf6f271€9.00€0.19matched
91capture01a1ac91-8d18-7500-92a6-ebc74a1d6a3c€49.00€0.67matched
92capture01a1ac91-a6f3-706a-a989-3f7836e26ee2€49.00€0.67matched
93capture01a1ac91-aef7-7a92-81f6-7e21980d5297€35.00€0.50matched
94refund01a1ac91-d80f-70e2-84d6-f3677bd214f3-€28.00€0.00matched
95capture01a1ac91-f168-7f6e-b163-b477f40de96f€15.00€0.26matched
96refund01a1ac91-f532-740d-b126-24f951ba6533-€20.00€0.00matched
97capture01a1ac91-f3db-74a9-a5f9-d9a433297ded€24.00€0.37matched
98capture01a1ac92-0587-7514-b6e8-6b59d2a2d2f4€49.00€0.67matched
99capture01a1ac92-0fe9-7e27-a667-ab0c3c428e36€9.00€0.19matched
100capture01a1ac92-1522-73e7-8cfd-2239ad40229d€49.00€0.67matched
101capture01a1ac92-1858-7dd2-a3a1-afb07f85ed9c€9.00€0.19matched
102capture01a1ac92-2d4a-703b-944d-9a48ced6c159€49.00€0.67matched
103capture01a1ac92-3199-7328-8a52-2f99fb27c136€15.00€0.26matched
104capture01a1ac92-4146-790f-9cdd-424d57b701a2€35.00€0.50matched
105capture01a1ac92-689d-7ce0-84cb-7e5e56111f38€49.00€0.67matched
106capture01a1ac92-7694-7870-a312-22dec38b3375€35.00€0.50matched
107capture01a1ac92-9753-7577-ad1f-f7969240d0e5€24.00€0.37matched
108capture01a1ac92-bcae-7c7f-ba0e-c4c541cc0c93€49.00€0.67matched
109capture01a1ac92-c376-7d6b-bb72-47e5ec57bb3e€35.00€0.50matched
110capture01a1ac92-c88d-7dab-a02c-5bed1fc9ab96€9.00€0.19matched
111capture01a1ac92-d660-766d-b1f8-19ff50048f21€9.00€0.19matched
112capture01a1ac92-e1f0-7fcc-8f65-f9b82e4d554b€9.00€0.19matched
113refund01a1ac92-e762-7638-ad5e-9e911bf1e341-€22.00€0.00matched
114capture01a1ac92-e854-7c15-887b-6efa53f8941b€35.00€0.50matched
115capture01a1ac92-ec13-7c7b-a41c-fea12dcd0e9b€49.00€0.67matched
116capture01a1ac92-fd30-752a-894e-2cde29f2d327€24.00€0.37matched
117capture01a1ac93-01c8-7100-b7c2-cd3e7753e516€24.00€0.37matched
118capture01a1ac93-06e0-79e0-98e5-b7318bc49a3d€9.00€0.19matched
119capture01a1ac93-084b-7c16-b910-0a0a3383b69e€15.00€0.26matched
120capture01a1ac93-0a48-792a-9270-cd852c2f028c€9.00€0.19matched
121capture01a1ac93-0c40-7f54-947b-4bb8ab30e0cb€35.00€0.50matched
122capture01a1ac93-0fb0-71ab-872a-bfafc9c79e16€24.00€0.37matched
123refund01a1ac93-1224-7136-8cbb-5e42e24a3787-€3.00€0.00matched
124capture01a1ac93-3df7-7274-8368-6d356df637e7€9.00€0.19matched
125capture01a1ac93-650c-771f-9edd-ead687d03eb1€35.00€0.50matched
126capture01a1ac93-755e-7762-8203-2dc673356002€35.00€0.50matched
127capture01a1ac93-82c6-74e6-8925-5db3775d13ef€49.00€0.67matched
128capture01a1ac93-837f-76c3-b2e8-ce98627da4fe€49.00€0.67matched
129capture01a1ac93-87fe-747a-b9cf-feb0952377ae€15.00€0.26matched
130capture01a1ac93-93f5-7fbd-8de9-2e67063b164e€9.00€0.19matched
131capture01a1ac93-b363-77cd-b433-42d63c653500€9.00€0.19matched
132capture01a1ac93-daf6-7aa3-ae89-00c8ee18f2c4€9.00€0.19matched
133capture01a1ac93-f016-70b6-a0d5-c21884ed4707€24.00€0.37matched
134capture01a1ac94-0392-7a4f-9a8c-6f9bfe754e25€9.00€0.19matched
135capture01a1ac94-369e-7e77-894c-f824cb464b35€24.00€0.37matched
136capture01a1ac94-442f-76bf-bcef-ec239d2361a6€9.00€0.19matched
137capture01a1ac94-583d-7984-8b20-eacf48f3f2d7€35.00€0.50matched
138capture01a1ac94-5cf9-7778-8b8d-c1591963e083€49.00€0.67matched
139capture01a1ac94-654f-72d7-8fe3-94d14adece27€15.00€0.26matched
140capture01a1ac94-9f10-76dd-a48a-9113f2405874€49.00€0.67matched
141capture01a1ac94-a4e4-7ec6-bdd8-5f26281c6f6f€9.00€0.19matched
142capture01a1ac94-aad2-7959-9b5a-cd624afeab1b€24.00€0.37matched
143capture01a1ac94-d228-7a1b-b264-7be0fdeb9aa1€35.00€0.50matched
144capture01a1ac94-d4d8-7444-b5f6-aa3a982e0f8b€15.00€0.26matched