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

Gross

€2,785.00

PSP fee

€43.00

Net to the bank

€2,742.00

Settlement journal

#400564

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • missing linein the books, not in the filecapture:01a1ac83-7837-7489-b8b4-17f5ea55fdd3 is in no file
LineKindReferenceGrossFeeStatus
42capture01a1ac85-acce-7ba7-8129-d5a2bb405c39€35.00€0.55fee difference
1capture01a1ac7b-c6e6-7e06-8523-d652119f03c8€35.00€0.50matched
2capture01a1ac7e-bfe0-75b7-94f5-1d6ebd8522a7€49.00€0.67matched
3capture01a1ac7e-e890-7368-a7e1-64295ba23d81€15.00€0.26matched
4capture01a1ac81-8470-7c65-a59e-455fd198d4cb€9.00€0.19matched
5capture01a1ac82-9ba6-7e71-8df6-7cf7fd0e7e8a€9.00€0.19matched
6capture01a1ac82-acbc-77cd-a630-c48da0164cb7€9.00€0.19matched
7capture01a1ac82-d20f-7ed0-9e61-91bb6c6d4569€35.00€0.50matched
8capture01a1ac82-d7c2-7e98-86b3-c49f9d1101ee€49.00€0.67matched
9capture01a1ac82-d85c-75b9-9fd3-b153d640d278€24.00€0.37matched
10capture01a1ac82-d914-7c03-b89a-9c55b3a2a971€35.00€0.50matched
11capture01a1ac82-e344-7d49-937e-b4db69318823€35.00€0.50matched
12capture01a1ac82-f278-7df5-8dfe-971b7f2d64d4€15.00€0.26matched
13capture01a1ac83-146c-7168-a31d-bc06b21173e4€35.00€0.50matched
14capture01a1ac83-1710-7e89-8c95-14bf872742ce€15.00€0.26matched
15capture01a1ac83-3163-721c-885b-6a55a512dc65€9.00€0.19matched
16capture01a1ac83-53cb-7598-b3c4-48c574462df6€24.00€0.37matched
17capture01a1ac83-6187-7e8e-8aa9-8a2c6273d558€49.00€0.67matched
18capture01a1ac83-69f0-796c-9549-5ccaed31ae71€35.00€0.50matched
19capture01a1ac83-8b8d-71c0-a8f5-7fa5a958f129€24.00€0.37matched
20capture01a1ac83-8bbd-793a-8710-b644c9c2c5e6€24.00€0.37matched
21capture01a1ac83-a945-78b7-8f17-0279ad3dad9c€49.00€0.67matched
22capture01a1ac83-b66b-7762-9792-5f0fb500583d€49.00€0.67matched
23capture01a1ac83-f232-7590-894a-9f9adf817447€49.00€0.67matched
24capture01a1ac84-1aaa-7fe4-a0a4-fe8b065eb643€15.00€0.26matched
25capture01a1ac84-5194-7973-a613-84143539d75e€9.00€0.19matched
26capture01a1ac84-66ae-76a0-84c5-028dd0685087€35.00€0.50matched
27capture01a1ac84-71cd-7927-9580-66260892fc47€49.00€0.67matched
28capture01a1ac84-7dbf-75fe-9fb5-54af3c451a03€35.00€0.50matched
29capture01a1ac84-8dd8-734f-b363-4ae608f53c80€15.00€0.26matched
30capture01a1ac84-9f8e-7d9f-95e3-fab539c52b56€35.00€0.50matched
31capture01a1ac84-b0ea-7aba-a51d-9ad5b4bbe5cc€24.00€0.37matched
32capture01a1ac84-e437-7e26-831b-a00d7a2170cf€49.00€0.67matched
33capture01a1ac84-fbc8-746a-a42f-3e7e05491694€15.00€0.26matched
34capture01a1ac84-fc3b-7352-808b-f28836fc7588€15.00€0.26matched
35capture01a1ac85-08f1-73b7-84e7-bd5ebc2b5b21€15.00€0.26matched
36capture01a1ac85-1912-7d47-bb5d-97671fa1c5d9€9.00€0.19matched
37capture01a1ac85-2134-7917-8978-d0b30a4b617f€49.00€0.67matched
38capture01a1ac85-62cb-7204-b975-6a9d8e31b36c€9.00€0.19matched
39capture01a1ac85-634d-78fb-a622-1d277fc359f1€24.00€0.37matched
40capture01a1ac85-9293-7f31-bd94-13de17e3e691€24.00€0.37matched
41capture01a1ac85-aa24-7f9d-9048-2ad0b2425d5d€49.00€0.67matched
43capture01a1ac85-c3f0-7eed-b7c4-8d435167b225€35.00€0.50matched
44capture01a1ac85-ce70-72d4-95b4-bae6c32ab7c6€15.00€0.26matched
45capture01a1ac85-eabf-7ff7-9da3-4cde7990d964€35.00€0.50matched
46capture01a1ac85-f449-7c6d-8ae8-c35ef3c793d3€9.00€0.19matched
47capture01a1ac85-f7f2-705a-81f9-eef0ddad8df1€49.00€0.67matched
48capture01a1ac86-1365-7728-9f8f-771a95bbfb3e€24.00€0.37matched
49capture01a1ac86-1f33-7df0-89d1-aef294218a9f€24.00€0.37matched
50capture01a1ac86-51b2-7c05-9473-a8e7f61465b5€15.00€0.26matched
51capture01a1ac86-842d-7929-9f55-3649998d9fcd€49.00€0.67matched
52capture01a1ac86-8fc8-715d-a0c9-14b74638f601€35.00€0.50matched
53capture01a1ac86-c763-7571-bb81-db8dfbd7e44e€15.00€0.26matched
54capture01a1ac86-c7dd-7708-a570-f8674de70bdc€9.00€0.19matched
55capture01a1ac86-cb4c-7d47-ac13-d35a589abfef€35.00€0.50matched
56capture01a1ac86-d154-7a1b-9701-ad73054359cc€9.00€0.19matched
57capture01a1ac86-dcef-757b-ab84-d689ae71919b€9.00€0.19matched
58capture01a1ac86-e7e5-71bf-b184-a8163c333c9d€9.00€0.19matched
59capture01a1ac86-eadd-722e-a9cf-80c4dd2de1e9€9.00€0.19matched
60capture01a1ac86-f29e-7993-a9f6-770f55ec81bb€24.00€0.37matched
61capture01a1ac86-f632-7a3b-9211-e27887bc3061€24.00€0.37matched
62refund01a1ac87-04c0-700e-874d-d52a4510843d-€3.00€0.00matched
63capture01a1ac87-345e-72f8-a50e-3b9f6686ed35€15.00€0.26matched
64capture01a1ac87-3f88-7299-8b8e-7c738b824996€15.00€0.26matched
65capture01a1ac87-507a-7948-8b4b-d1e5a33f2d77€35.00€0.50matched
66capture01a1ac87-5fd9-784f-8e5f-78fe20ba1aa4€49.00€0.67matched
67capture01a1ac87-6475-7817-bf46-23766ced80ec€9.00€0.19matched
68capture01a1ac87-ba3f-78ce-afe6-2e604535fdce€24.00€0.37matched
69capture01a1ac87-f7fb-79fc-b016-35bd9ea2b938€9.00€0.19matched
70capture01a1ac87-fbe7-7eff-90d5-4b6364eaff28€24.00€0.37matched
71capture01a1ac87-fd86-7568-a250-c010598fed41€24.00€0.37matched
72capture01a1ac88-04b8-7723-b3fd-f8f581a5bb1d€35.00€0.50matched
73capture01a1ac88-0778-767b-a70f-a2fa9ef8dc95€15.00€0.26matched
74capture01a1ac88-19b1-7ab1-96d8-9277ba75875e€15.00€0.26matched
75capture01a1ac88-1a3a-7f9e-888f-d607a2617e98€24.00€0.37matched
76refund01a1ac88-2633-77ef-bd28-c96508f1ef5b-€7.00€0.00matched
77capture01a1ac88-3c3d-7569-a624-d92916c268d5€9.00€0.19matched
78capture01a1ac88-3ea5-790c-a427-0bee97390ca4€49.00€0.67matched
79capture01a1ac88-4252-7e22-a80c-08e4f7c926cd€24.00€0.37matched
80refund01a1ac88-4532-7bae-8fad-67973172d76b-€5.00€0.00matched
81capture01a1ac88-476c-7421-a45e-3a4b4e56e613€49.00€0.67matched
82capture01a1ac88-69c0-7f13-8f51-87a4e1d4b9b6€35.00€0.50matched
83capture01a1ac88-6365-731c-b99c-41555e6f0c0e€9.00€0.19matched
84capture01a1ac88-77ec-7127-bdd9-557ad3e11a60€9.00€0.19matched
85capture01a1ac88-a952-7752-98cf-9139bc80fad8€35.00€0.50matched
86capture01a1ac88-e510-7f94-8f1c-dfea682a97da€35.00€0.50matched
87capture01a1ac88-e681-74e4-8685-fe8bb90a5441€35.00€0.50matched
88capture01a1ac88-fc8c-7b7c-aedd-6d09b4af5780€15.00€0.26matched
89capture01a1ac89-4d33-78f5-b6c4-edcb6b86592d€35.00€0.50matched
90capture01a1ac89-5a69-7cc5-8876-d2d1c8845d9d€49.00€0.67matched
91capture01a1ac89-6148-78f1-a1b5-03642eb52303€9.00€0.19matched
92capture01a1ac89-70a8-7076-b575-f1a90d09af7f€49.00€0.67matched
93capture01a1ac89-9321-7a63-8f36-220fbac90823€35.00€0.50matched
94capture01a1ac89-b388-7931-9888-b1348af37450€15.00€0.26matched
95capture01a1ac89-c06c-702e-bdfe-2bff5ad5b21b€9.00€0.19matched
96capture01a1ac89-f418-7211-87eb-184db3b7a45a€9.00€0.19matched
97capture01a1ac8a-4af9-7297-8b31-e74ff2a1d884€35.00€0.50matched
98capture01a1ac8a-69a2-7123-b1a4-c97d5c378c0c€49.00€0.67matched
99capture01a1ac8a-99c2-70e1-b1c3-7749a3dbf266€35.00€0.50matched
100capture01a1ac8a-a591-7935-9a3c-f2e41cb448e2€15.00€0.26matched
101capture01a1ac8a-a7b1-792d-9b14-85e43d838768€15.00€0.26matched
102capture01a1ac8a-c646-7188-a38b-35aa8e8d3cdd€49.00€0.67matched
103refund01a1ac8a-cff0-7032-93f9-881429a1a3d1-€9.00€0.00matched
104capture01a1ac8a-d635-75ac-8d79-7c13bb90259e€35.00€0.50matched
105capture01a1ac8a-ebd0-7a49-98be-475fbd91c573€35.00€0.50matched
106capture01a1ac8a-ecc5-79b8-91e8-ba6b3556d608€24.00€0.37matched
107capture01a1ac8a-f923-7a8e-a6cf-4a20e8fe2576€15.00€0.26matched
108capture01a1ac8a-fed9-717c-8f94-ef91818043bd€35.00€0.50matched
109capture01a1ac8b-2855-7744-b391-71c6496c773f€9.00€0.19matched
110refund01a1ac8b-2c41-7f9d-a36d-c879fd5346bd-€23.00€0.00matched
111capture01a1ac8b-3519-7119-9d40-50aca9a8f6df€9.00€0.19matched
112refund01a1ac8b-4fd0-74b5-9d78-bc1c7f02d1ee-€17.00€0.00matched
113capture01a1ac8b-9d36-70f2-9adc-2f6435849593€49.00€0.67matched
114capture01a1ac8b-9f6c-7d45-ad4d-bbbcc3089261€9.00€0.19matched