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

Gross

€2,774.00

PSP fee

€43.40

Net to the bank

€2,730.60

Settlement journal

#370614

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a413-1260-70c1-b740-2f21b494523b is already settled by stl_EUR_2989590 line 17
  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • missing linein the books, not in the filecapture:01a1a412-8aab-799a-954b-f0f7e1638350 is in no file
LineKindReferenceGrossFeeStatus
18capture01a1a413-128d-782d-b0a0-d716eb56b9e8€24.00€0.37duplicate line
104capture01a1a419-863b-7ee8-879e-db5af2d8c5df€24.00€0.40fee difference
1capture01a1a409-710f-7161-94b5-26a1151bd389€24.00€0.37matched
2capture01a1a40e-4220-70f1-a6f6-c9feed7e47e6€24.00€0.37matched
3capture01a1a411-fa67-7fdf-a33c-33dae0ae5018€49.00€0.67matched
4capture01a1a412-13b0-7104-ad43-082b284ad0ff€9.00€0.19matched
5capture01a1a412-1b00-73b6-beea-0939652e6d0b€24.00€0.37matched
6capture01a1a412-308e-7a28-a765-40eee12fc528€15.00€0.26matched
7capture01a1a412-3a3c-7613-b12f-5528f3f4bb9e€24.00€0.37matched
8capture01a1a412-4894-7012-843b-95e3e947af2e€15.00€0.26matched
9capture01a1a412-5f39-7fc2-a984-19e5969c7feb€35.00€0.50matched
10capture01a1a412-7fcc-7a04-a9c4-dd1aff5f306e€49.00€0.67matched
11capture01a1a412-8112-79c4-8c4f-6ffa23b9242a€9.00€0.19matched
12capture01a1a412-8348-7df6-bc88-68e9c1d6462c€24.00€0.37matched
13capture01a1a412-c9ac-7792-92d4-57eaf3693642€9.00€0.19matched
14capture01a1a412-dadf-717e-9f7a-59c2ee9f7ca8€35.00€0.50matched
15capture01a1a413-11c9-7a47-9c29-628f3fcfec14€9.00€0.19matched
16capture01a1a413-1579-7175-896b-677110440ce0€15.00€0.26matched
17capture01a1a413-128d-782d-b0a0-d716eb56b9e8€24.00€0.37matched
19capture01a1a413-23ba-738d-bf57-14b1afd02040€24.00€0.37matched
20capture01a1a413-3188-70b9-ba25-b005139b17db€49.00€0.67matched
21capture01a1a413-337a-772d-b346-61f6da0a61f8€24.00€0.37matched
22capture01a1a413-35bc-75f1-ba89-46dd36ac12d0€24.00€0.37matched
23capture01a1a413-402d-7505-a4d7-4a79a572d35d€15.00€0.26matched
24capture01a1a413-7e67-7f2b-a040-84e42d7557bb€49.00€0.67matched
25capture01a1a413-9736-7aa3-b350-61698dc82b9e€9.00€0.19matched
26capture01a1a413-9799-7d5c-a0fc-4ad6bb32650a€9.00€0.19matched
27capture01a1a413-9bd2-701a-8bcd-e130a5035ce1€35.00€0.50matched
28capture01a1a413-a2e1-72fc-b30c-26d02b89ac5b€24.00€0.37matched
29capture01a1a413-a851-7f60-b3ec-fbe697338fb5€9.00€0.19matched
30capture01a1a413-b549-73ef-80e1-1f0399ec355a€9.00€0.19matched
31capture01a1a413-cadf-7c1c-acf3-aa33e690b016€24.00€0.37matched
32capture01a1a413-cac8-786b-8195-84f9e172a139€24.00€0.37matched
33capture01a1a413-cd92-7ca8-8c06-550866118557€9.00€0.19matched
34capture01a1a413-e468-7156-b143-11332d6f487a€9.00€0.19matched
35capture01a1a413-ec62-7492-a9c7-533605253c71€35.00€0.50matched
36capture01a1a413-f0c9-7937-80a7-0feea42ac712€35.00€0.50matched
37capture01a1a413-f35c-70a4-b6b4-5801cc6109f8€24.00€0.37matched
38capture01a1a414-06c4-76e3-ab8b-50c46d2c9f57€35.00€0.50matched
39capture01a1a414-162a-7b22-91b8-6f5f13009dd3€15.00€0.26matched
40capture01a1a414-1872-7116-aa99-e57dc3584acf€24.00€0.37matched
41capture01a1a414-2709-74a0-a538-a4e9298859d8€35.00€0.50matched
42capture01a1a414-2d80-7397-bcb4-fff47bb0edbd€49.00€0.67matched
43capture01a1a414-6202-7e65-8273-25ecff394684€24.00€0.37matched
44capture01a1a414-67f4-7fd0-b893-c488eba81879€49.00€0.67matched
45capture01a1a414-6f36-7c36-b693-9c307ae52623€24.00€0.37matched
46capture01a1a414-9277-7fea-b0db-b61c5f94d315€15.00€0.26matched
47capture01a1a414-ade6-7716-a9cd-1f371c765d20€15.00€0.26matched
48capture01a1a414-bff1-7d08-94da-a172381f0f4c€9.00€0.19matched
49refund01a1a414-d605-79ab-8585-3d98eaedde02-€15.00€0.00matched
50capture01a1a414-f0a4-7cac-8112-14f439249ae6€49.00€0.67matched
51capture01a1a415-1e95-7fe0-b0f7-6f115f1ea44e€49.00€0.67matched
52capture01a1a415-2a9c-7218-a306-6f4de07190b3€49.00€0.67matched
53capture01a1a415-2e44-7b64-9915-daca9232d1b6€9.00€0.19matched
54capture01a1a415-3581-7d2d-b4a7-50d35df010cb€9.00€0.19matched
55capture01a1a415-469b-710c-b6ce-67087845461b€15.00€0.26matched
56capture01a1a415-5bea-7a46-a04c-b1d36b94105a€9.00€0.19matched
57capture01a1a415-5fef-7c8b-ac93-9a1b99184fb9€15.00€0.26matched
58capture01a1a415-5ac6-79a1-8cd4-ec54ca35d779€35.00€0.50matched
59capture01a1a415-6acf-7dfb-81e0-747656e46b52€15.00€0.26matched
60capture01a1a415-7f4e-7340-ad34-d31430d3a617€24.00€0.37matched
61capture01a1a415-9520-7ffe-9bdd-fa0c8afe5dbb€49.00€0.67matched
62refund01a1a415-aa64-7b75-a51c-3954009cf72b-€7.00€0.00matched
63capture01a1a415-b5c8-7518-a53d-ded4fe019d75€15.00€0.26matched
64capture01a1a415-c6f0-7cd0-b3ce-1541b7aaf010€49.00€0.67matched
65capture01a1a415-d5ef-7dfd-a4d1-718d1ea81e87€9.00€0.19matched
66capture01a1a415-dbb6-7050-bb29-e300bd9ddf94€49.00€0.67matched
67capture01a1a415-dbfe-742c-bd24-ba1c800fc48b€9.00€0.19matched
68capture01a1a416-16e0-74e9-b0d4-b71f80eea3b2€49.00€0.67matched
69capture01a1a416-1c18-7d87-8417-f21fc59b104c€35.00€0.50matched
70capture01a1a416-3caa-7de5-ad1e-a867e2021ead€9.00€0.19matched
71refund01a1a416-4817-72d3-918a-071c2f9eaa6c-€11.00€0.00matched
72capture01a1a416-4dab-7340-87bf-b4be7067b7c4€9.00€0.19matched
73capture01a1a416-52a3-77c9-947d-334953bc61b4€15.00€0.26matched
74capture01a1a416-5fbf-7488-8c0c-1707d179fca6€15.00€0.26matched
75refund01a1a416-8be9-76c2-8f1c-b9e92401b136-€6.00€0.00matched
76capture01a1a416-ad75-7a7a-a56f-22ea3977ed88€35.00€0.50matched
77capture01a1a416-b742-7baf-a6e8-20a4d38c58e3€49.00€0.67matched
78refund01a1a416-bdce-70cf-a556-7590b0704f3a-€15.00€0.00matched
79capture01a1a416-cfb7-7727-a190-a9b764625823€35.00€0.50matched
80capture01a1a416-dbaa-77de-9bda-45df18ee9cef€24.00€0.37matched
81capture01a1a417-14fb-7132-9940-f7baccee06e3€35.00€0.50matched
82capture01a1a417-4629-7f1b-9d77-9fd016d5eb9c€24.00€0.37matched
83capture01a1a417-5e70-77e6-a6fa-cb058a41f87a€9.00€0.19matched
84capture01a1a417-648e-76f9-82b6-a069907ed6e8€49.00€0.67matched
85capture01a1a417-741d-7046-80b9-000632bca8c6€15.00€0.26matched
86capture01a1a417-89f4-7f57-8f5d-4a8b0f7961ea€15.00€0.26matched
87capture01a1a417-a68a-790b-8ee9-45ea82636355€35.00€0.50matched
88capture01a1a417-aba0-7834-aeac-ca2f352e7b3a€35.00€0.50matched
89capture01a1a417-e4b4-7e07-992d-0fa378d251ea€35.00€0.50matched
90capture01a1a417-ecf1-706a-9632-a21e4dccd46c€24.00€0.37matched
91capture01a1a417-ee75-7c7d-a1d2-be5005a1eb93€24.00€0.37matched
92capture01a1a417-f837-700c-8c49-a6afeb708e98€15.00€0.26matched
93capture01a1a418-062c-702d-a0c0-57595daea9e2€15.00€0.26matched
94capture01a1a418-1677-7ffe-bfd4-77d8a164cf91€15.00€0.26matched
95capture01a1a418-21f1-7213-85ec-352c6a20bb30€35.00€0.50matched
96capture01a1a418-48b9-7db3-ba93-7c4fed9f7d4a€9.00€0.19matched
97capture01a1a418-860f-72bd-ad88-b3aa7e04c544€15.00€0.26matched
98capture01a1a418-c801-7c54-a175-7fd67f6b2636€49.00€0.67matched
99capture01a1a419-14c2-7ba7-9358-606bffe04290€9.00€0.19matched
100capture01a1a419-33e1-7fdd-964d-22b2ac8452e0€9.00€0.19matched
101capture01a1a419-4afb-7da1-8160-50b849a120ea€49.00€0.67matched
102refund01a1a419-7499-7e4a-a92e-909398413b88-€4.00€0.00matched
103capture01a1a419-7a56-7e89-a26f-3d9f9eeb7a57€35.00€0.50matched
105capture01a1a419-9897-700b-a57b-88c78604db55€35.00€0.50matched
106capture01a1a419-9ad1-7965-b679-b25ed625a80b€15.00€0.26matched
107capture01a1a41a-1440-7ffb-aee4-5918eb64e894€15.00€0.26matched
108capture01a1a41a-68d6-7348-864b-21edecd446ac€24.00€0.37matched
109capture01a1a41a-9a73-73aa-8b48-e120ed5f3b6f€35.00€0.50matched
110capture01a1a41a-9add-7a40-af8c-e12197bc2bef€49.00€0.67matched
111capture01a1a41a-b303-7fd3-8e5d-6213a7b6711c€9.00€0.19matched
112capture01a1a41a-c7df-73f5-a89c-142a98fbadba€24.00€0.37matched
113capture01a1a41a-cbd6-7163-a76b-292ef0f5e1a3€49.00€0.67matched
114capture01a1a41a-ceff-7890-82c5-73627f9d1d99€24.00€0.37matched
115capture01a1a41a-ef84-7d84-acdd-f2928630bf5d€9.00€0.19matched
116capture01a1a41a-f26a-77fc-92ac-6cc82f19f806€35.00€0.50matched
117refund01a1a41a-f3e3-77e5-b06e-87fa72e167e2-€24.00€0.00matched
118capture01a1a41a-fbb8-75da-8f8b-6bf1802e08f8€35.00€0.50matched
119capture01a1a41b-1089-7938-9c3a-d3e67c808da0€35.00€0.50matched