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

Gross

€2,920.00

PSP fee

€46.14

Net to the bank

€2,873.86

Settlement journal

#370130

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a3f0-61f6-7eb1-bc35-e5df698374a0 is already settled by stl_EUR_2989586 line 41
  • fee differencethe fee is not the contract feethe fee is 54, the contract says 50
LineKindReferenceGrossFeeStatus
42capture01a1a3f0-6212-7d06-af4b-f36acd972ce1€9.00€0.19duplicate line
87capture01a1a3f3-b589-78ee-a68c-568581eacc7c€35.00€0.54fee difference
1capture01a1a3ed-6f37-7161-b1b9-1a7106d31b7e€9.00€0.19matched
2refund01a1a3ed-80a1-76f1-ac46-99170fe1c82c-€21.00€0.00matched
3capture01a1a3ed-95c7-7125-b061-14b0eb50f7b6€35.00€0.50matched
4capture01a1a3ed-b179-76ae-85cf-eb0e9d724451€49.00€0.67matched
5capture01a1a3ed-be39-7651-be76-66d191e95a29€49.00€0.67matched
6refund01a1a3ed-c113-7c24-a1b1-4a2cb382a68b-€4.00€0.00matched
7capture01a1a3ed-e96c-73ba-bbf4-3c3bc637e488€49.00€0.67matched
8capture01a1a3ed-f6f1-7616-aadd-6a0531a5a333€49.00€0.67matched
9capture01a1a3ee-21df-7715-ba64-b999fafa3e4a€9.00€0.19matched
10capture01a1a3ee-2e79-7024-a712-df866c34186d€35.00€0.50matched
11capture01a1a3ee-39e1-765d-bdc7-4461a5956641€9.00€0.19matched
12capture01a1a3ee-86ed-7695-b7a4-b1a653c893dd€49.00€0.67matched
13capture01a1a3ee-8d3b-7de7-9548-1c83ce7741a9€9.00€0.19matched
14capture01a1a3ee-9320-79ce-ac73-994902fabeda€24.00€0.37matched
15capture01a1a3ee-9e57-703a-be2f-3c0fe8d9a4fd€49.00€0.67matched
16capture01a1a3ee-a257-7492-b041-569b473a3222€15.00€0.26matched
17capture01a1a3ee-a939-7276-8ec4-7f015f5ee03b€35.00€0.50matched
18capture01a1a3ee-b1ea-7a23-99c4-2842675b1e53€49.00€0.67matched
19refund01a1a3ee-bcac-7006-b854-cab91c8b3849-€13.00€0.00matched
20capture01a1a3ee-c109-7229-8713-c1d3e7a59c20€15.00€0.26matched
21capture01a1a3ee-cc52-773b-a94a-72fbc8ad7655€9.00€0.19matched
22capture01a1a3ee-d1e1-7a5e-907a-5e29a335d1a1€35.00€0.50matched
23capture01a1a3ee-dd35-79b7-9c66-6c0de627935c€49.00€0.67matched
24capture01a1a3ee-f36b-77c6-9f3a-fd9bebcc4094€9.00€0.19matched
25capture01a1a3ee-f8dd-775f-929b-f530526c2327€9.00€0.19matched
26capture01a1a3ef-0533-78e5-95e3-660ed3a0a1f5€35.00€0.50matched
27refund01a1a3ef-0bae-760c-ac92-13297533bd45-€37.00€0.00matched
28capture01a1a3ef-157d-7699-b8fb-aacb0592b9d0€15.00€0.26matched
29capture01a1a3ef-4a51-7120-8a33-e2783e375b87€15.00€0.26matched
30refund01a1a3ef-4fd4-75ca-a53d-b24f29ebaf9c-€3.00€0.00matched
31capture01a1a3ef-554b-7ff6-adf0-ca4a1c29a87b€9.00€0.19matched
32capture01a1a3ef-88af-706c-abcd-9c4267cf592d€15.00€0.26matched
33capture01a1a3ef-8fec-7f84-abf4-f1f4b5680085€9.00€0.19matched
34capture01a1a3ef-a0cf-7801-97a6-f59d3fabd2c9€24.00€0.37matched
35capture01a1a3ef-d01f-7a9e-89bb-c976eae856ed€35.00€0.50matched
36capture01a1a3ef-dac3-708c-b612-7d26ff247009€35.00€0.50matched
37capture01a1a3ef-e49c-79f5-bf4c-d9fd6b03b520€35.00€0.50matched
38capture01a1a3ef-e6bd-7763-936a-1b65cf9da9c2€9.00€0.19matched
39capture01a1a3f0-0ce1-72df-8c9e-f18fa7c626cc€35.00€0.50matched
40capture01a1a3f0-0452-7c71-9848-8255de0f84e5€49.00€0.67matched
41capture01a1a3f0-6212-7d06-af4b-f36acd972ce1€9.00€0.19matched
43capture01a1a3f0-634e-7e84-8217-90396523061f€35.00€0.50matched
44capture01a1a3f0-8798-7462-85cd-d794798c4e49€49.00€0.67matched
45capture01a1a3f0-8bcf-78a7-b405-f8eab77957b4€15.00€0.26matched
46capture01a1a3f0-9427-7240-9056-cbe8eb0e3358€49.00€0.67matched
47capture01a1a3f0-d73d-7e5c-89b0-4ddfc79e0fb4€24.00€0.37matched
48capture01a1a3f0-db12-7d16-8547-4858c1e399a2€35.00€0.50matched
49capture01a1a3f0-e198-70ad-9735-4622359d3b50€49.00€0.67matched
50capture01a1a3f0-f719-7eae-975a-33d9ad6473b7€24.00€0.37matched
51capture01a1a3f1-1e0c-7a7c-9652-dee8695e2b20€24.00€0.37matched
52capture01a1a3f1-50f7-7d5b-9fb1-bca4156c6517€9.00€0.19matched
53capture01a1a3f1-5201-79fa-bd00-0bec96804246€9.00€0.19matched
54capture01a1a3f1-4c8b-79c6-9445-8bc81c92407e€35.00€0.50matched
55capture01a1a3f1-7091-7ba6-b94c-969a9430586d€24.00€0.37matched
56capture01a1a3f1-827c-73bd-b380-30d56df85e19€15.00€0.26matched
57refund01a1a3f1-8978-7f74-982c-a3b2a6839faf-€19.00€0.00matched
58capture01a1a3f1-8dda-7b6c-b708-ea03e0c9b604€9.00€0.19matched
59refund01a1a3f1-d0d6-707a-9c54-3c0e45a43375-€12.00€0.00matched
60capture01a1a3f1-d2a4-7c30-b8e4-f33c06456116€35.00€0.50matched
61capture01a1a3f1-f0d7-7dd0-8519-e4ea79db7da3€24.00€0.37matched
62capture01a1a3f2-06f1-7f16-b335-71d31c04db8d€24.00€0.37matched
63capture01a1a3f2-0779-7699-9640-c986c711050a€15.00€0.26matched
64capture01a1a3f2-0f41-7f67-b46a-4cdc71c35e73€49.00€0.67matched
65capture01a1a3f2-21ad-7037-a39d-83035a7d3373€49.00€0.67matched
66capture01a1a3f2-2fb6-7ff8-b358-fa60db78501b€15.00€0.26matched
67capture01a1a3f2-4bc4-7fae-a9c8-ae9439955de8€24.00€0.37matched
68capture01a1a3f2-53a2-75b5-8140-9341d70fa20f€35.00€0.50matched
69refund01a1a3f2-543b-7f68-93cb-4b910235c236-€35.00€0.00matched
70capture01a1a3f2-6acb-7067-b3f8-169dfad89c8c€9.00€0.19matched
71capture01a1a3f2-6d2d-7534-b59b-66d9227245d9€49.00€0.67matched
72capture01a1a3f2-944f-7c17-90ca-aab5c38f001e€15.00€0.26matched
73capture01a1a3f2-e237-7d41-bc90-ffd4414d05fc€49.00€0.67matched
74capture01a1a3f2-eafd-7ffa-91e7-2f6b4ba017c4€49.00€0.67matched
75capture01a1a3f2-f475-7054-84c8-3419600170c1€15.00€0.26matched
76capture01a1a3f3-0d4a-7185-8abe-6cac4b8ee044€15.00€0.26matched
77capture01a1a3f3-0fdd-7e87-a39b-a0b562cc3d25€49.00€0.67matched
78capture01a1a3f3-40e4-758c-b5ad-992bb9331f22€35.00€0.50matched
79capture01a1a3f3-567e-72bc-a3a0-4f47c215d12e€9.00€0.19matched
80capture01a1a3f3-5c67-7008-b9df-abf732b3a311€35.00€0.50matched
81capture01a1a3f3-68c9-7e61-8e54-011aab9db82f€15.00€0.26matched
82capture01a1a3f3-6fde-7b9f-a84b-863f52217ae7€9.00€0.19matched
83capture01a1a3f3-7256-727b-a84c-08e1a5b242e0€35.00€0.50matched
84capture01a1a3f3-9d36-7a78-a322-fe7bd047bde4€49.00€0.67matched
85capture01a1a3f3-a381-75e8-a342-e1f780b9241d€24.00€0.37matched
86capture01a1a3f3-b4c7-7fa9-a4f8-06402d716bda€15.00€0.26matched
88capture01a1a3f3-c95e-7806-89be-ea38f1b46a48€24.00€0.37matched
89capture01a1a3f3-c9b1-7189-a88d-c28af5f5a22c€15.00€0.26matched
90capture01a1a3f3-d305-765d-903d-2d85aee66ab7€9.00€0.19matched
91capture01a1a3f3-dd07-74f0-a762-f5d838c6a3ed€24.00€0.37matched
92capture01a1a3f3-eb3c-7e91-bf68-bc578da7e722€49.00€0.67matched
93capture01a1a3f3-fbaa-7754-ab5d-d6744f093329€35.00€0.50matched
94capture01a1a3f4-0a4b-76c7-9ee4-8ccf867df3c3€24.00€0.37matched
95capture01a1a3f4-1498-7dfa-a3b4-e94a0e0a5477€24.00€0.37matched
96capture01a1a3f4-1c37-74da-9d5e-f9e28481ae58€9.00€0.19matched
97capture01a1a3f4-3999-7c6b-8809-4354fdff85f7€15.00€0.26matched
98capture01a1a3f4-3e4e-7bfb-b967-d54e5e393b85€35.00€0.50matched
99capture01a1a3f4-6c24-793f-a941-f8deefafecc8€24.00€0.37matched
100capture01a1a3f4-717a-73cb-aba3-f879b7c40d17€35.00€0.50matched
101capture01a1a3f4-addb-79d2-bc4c-9bcd66084fdc€24.00€0.37matched
102capture01a1a3f5-0199-7980-9677-ded3fd4a39fd€24.00€0.37matched
103capture01a1a3f5-2b6e-7ee7-b65b-805c56992d17€35.00€0.50matched
104capture01a1a3f5-3094-7681-ba45-83c15f40c45a€24.00€0.37matched
105capture01a1a3f5-448f-7536-9c2f-9b06b76b17b0€35.00€0.50matched
106capture01a1a3f5-4bd8-73d4-bcc4-89b4affeea56€15.00€0.26matched
107capture01a1a3f5-53d5-764f-88ce-bc0be2686a8d€49.00€0.67matched
108capture01a1a3f5-6222-72e2-879d-471cebb0b921€49.00€0.67matched
109capture01a1a3f5-692d-78f8-acd4-f419bd038da8€15.00€0.26matched
110capture01a1a3f5-6a3a-75bf-a249-3fd82cd9e1c4€35.00€0.50matched
111capture01a1a3f5-7ee9-784c-87c2-bdced2d0a87f€9.00€0.19matched
112capture01a1a3f5-9a91-792e-94ee-209cf93db0e4€24.00€0.37matched
113capture01a1a3f5-afa4-7bf6-bc69-36ffbe929abf€15.00€0.26matched
114capture01a1a3f5-bdc4-7e18-9043-54038edd97f5€15.00€0.26matched
115capture01a1a3f5-e436-77c1-b438-c2adaddad090€15.00€0.26matched
116capture01a1a3f5-e70a-78e8-8517-9883eca99252€24.00€0.37matched
117capture01a1a3f5-ead9-72c7-881f-154420a4355f€15.00€0.26matched
118capture01a1a3f5-fecc-7413-9a08-9c3dfa961371€15.00€0.26matched
119capture01a1a3f6-1cca-753c-9771-6963a403d483€35.00€0.50matched
120capture01a1a3f6-2b1e-75f9-8496-cda58fcc82ef€49.00€0.67matched
121capture01a1a3f6-36ff-7d75-80e7-181b60636b77€9.00€0.19matched
122capture01a1a3f6-4f5c-73b1-9f21-49bc0df7414c€15.00€0.26matched
123capture01a1a3f6-5478-730d-91a2-7d9928b616c0€24.00€0.37matched