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

3 Nov, 17:10

Gross

€2,879.00

PSP fee

€45.04

Net to the bank

€2,833.96

Settlement journal

#364687

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a269-3e2b-77c2-b682-1e935be36717 is already settled by stl_EUR_2989543 line 73
  • duplicate linethe file lists it twicecapture:01a1a269-79ff-709e-840e-c5a98d9cb475 is already settled by stl_EUR_2989543 line 79
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • missing linein the books, not in the filecapture:01a1a265-8d8f-7805-9502-d9f1413c64ba is in no file
  • missing linein the books, not in the filecapture:01a1a266-7009-7648-bb54-3845e710befc is in no file
  • missing linein the books, not in the filecapture:01a1a267-9bff-7cba-b376-55db7b3347e9 is in no file
LineKindReferenceGrossFeeStatus
48capture01a1a266-cc4f-75a8-8a3c-c060a324e05a€35.00€0.52fee difference
74capture01a1a269-3e5b-7e4f-92fe-c73914c8dc5c€35.00€0.50duplicate line
80capture01a1a269-7a38-710c-8e92-6723f0e73331€24.00€0.37duplicate line
1capture01a1a25d-2f21-7312-af79-5ed562d8bed6€24.00€0.37matched
2capture01a1a263-7b70-703a-b0c6-a1a2466253bd€15.00€0.26matched
3capture01a1a263-a331-7242-8367-ba0d239d8923€35.00€0.50matched
4capture01a1a263-b894-7538-bd25-b51d3e9786fe€9.00€0.19matched
5capture01a1a263-cfc1-73f3-9ee7-0d1c26da27b1€24.00€0.37matched
6capture01a1a264-0fcb-7862-be30-166363d48bb5€35.00€0.50matched
7capture01a1a264-3697-7502-8bd4-e4e5f00427b2€15.00€0.26matched
8capture01a1a264-3ce9-70f6-9038-2c91135bb8a6€15.00€0.26matched
9capture01a1a264-53ed-7a10-9aad-a69798320138€35.00€0.50matched
10capture01a1a264-559e-7db2-bbc7-9f588ec1c5e9€24.00€0.37matched
11capture01a1a264-622e-709f-a1de-3966998dc645€49.00€0.67matched
12capture01a1a264-6c46-7ecd-9781-cb00f13d0895€24.00€0.37matched
13capture01a1a264-90ab-7285-a6fa-c7032d574072€15.00€0.26matched
14capture01a1a264-9d49-7681-8a6d-a266926f8c79€24.00€0.37matched
15capture01a1a264-ad85-7d3f-bfe0-7eb4212a244f€35.00€0.50matched
16capture01a1a264-d62a-7a8c-8de1-88b36e82d2f9€24.00€0.37matched
17capture01a1a264-db1e-7d0a-acd7-0d13dd1a8344€24.00€0.37matched
18capture01a1a265-0b6a-7359-8fb1-e840ec18b20d€49.00€0.67matched
19capture01a1a265-0c5b-70e5-9569-644b63c4aa53€24.00€0.37matched
20capture01a1a265-0cf3-71e2-bda6-673dfb39d555€15.00€0.26matched
21capture01a1a265-122b-707b-9a43-bc8248baa870€15.00€0.26matched
22capture01a1a265-5d05-756e-a316-7b48cee72c66€24.00€0.37matched
23capture01a1a265-712a-733a-9e39-938f8b1ed1fd€35.00€0.50matched
24capture01a1a265-77a3-7d48-9506-8c7fe62acb11€35.00€0.50matched
25capture01a1a265-80ab-71c5-b57d-2c246e9cdd94€9.00€0.19matched
26capture01a1a265-876e-7d7b-bf00-4a4b980c7499€24.00€0.37matched
27capture01a1a265-c545-794e-8861-dc9995c603a3€15.00€0.26matched
28capture01a1a265-ca31-7e1d-9820-e55b765c2e20€15.00€0.26matched
29capture01a1a265-d089-777f-8b02-a9a34c1ab857€35.00€0.50matched
30refund01a1a265-d8bf-776e-a50d-54a6dc017bf8-€27.00€0.00matched
31capture01a1a265-f562-7ec0-8541-12ce95b34d09€49.00€0.67matched
32capture01a1a266-0f9b-7865-9dd6-0dd38c1fa7f5€24.00€0.37matched
33refund01a1a266-3687-7143-bda6-a105d063132f-€12.00€0.00matched
34capture01a1a266-484b-71a4-a938-8f02e28a90db€35.00€0.50matched
35capture01a1a266-56ba-731a-bd4d-6924a39cd826€49.00€0.67matched
36capture01a1a266-6705-7487-a8c7-5d99b98444d8€49.00€0.67matched
37capture01a1a266-6c82-7cb9-ae54-953d61fb317e€9.00€0.19matched
38capture01a1a266-8946-70b4-95c1-00b7c9c95126€9.00€0.19matched
39capture01a1a266-8b34-7258-a2cf-9cb1f9352436€35.00€0.50matched
40capture01a1a266-9559-7f61-be22-5e0f379e05b0€15.00€0.26matched
41capture01a1a266-9ca7-70d4-bf59-2ccb4bb3e0e3€15.00€0.26matched
42capture01a1a266-9d38-7734-bfca-141e9aa01890€24.00€0.37matched
43capture01a1a266-9e8f-7016-9940-fca158742a78€49.00€0.67matched
44capture01a1a266-a1f5-7537-9c27-66e1cf314ecc€24.00€0.37matched
45capture01a1a266-a6cd-712e-a23f-f28073c48db1€24.00€0.37matched
46capture01a1a266-b594-7313-be49-a5bdb902ed0f€24.00€0.37matched
47refund01a1a266-bd0b-7e52-a5d3-e02577aa6206-€31.00€0.00matched
49capture01a1a267-033b-7f26-9052-b50a406944c1€15.00€0.26matched
50capture01a1a267-05dc-7abb-9586-883337bf7874€24.00€0.37matched
51capture01a1a267-0c03-7568-a908-5df1b648d1f1€24.00€0.37matched
52refund01a1a267-4041-7d1d-b571-d144ef4c54eb-€26.00€0.00matched
53capture01a1a267-61c7-767f-a2c9-4877e6ee37c9€49.00€0.67matched
54capture01a1a267-9961-7259-952f-87c402b66f5a€49.00€0.67matched
55capture01a1a267-9d39-7c8b-9ea1-dc244aae34b7€49.00€0.67matched
56capture01a1a267-ae31-7150-9539-d5a404def04a€9.00€0.19matched
57capture01a1a267-c4d8-7970-af44-8fd7bfd42717€35.00€0.50matched
58capture01a1a267-c936-722f-bac7-4a4f93c8a490€9.00€0.19matched
59capture01a1a267-d45e-777e-984d-49b2dde52502€49.00€0.67matched
60capture01a1a267-db3a-7bbe-99d8-6e3e99a112b4€15.00€0.26matched
61capture01a1a267-e12c-75c3-ac84-279dbc657cdd€35.00€0.50matched
62capture01a1a268-036a-7a9a-a591-c596b2990ff2€9.00€0.19matched
63capture01a1a268-22b5-731f-86f6-32ade7eba3e4€24.00€0.37matched
64capture01a1a268-2585-78af-a3e0-759fd9ff5da2€24.00€0.37matched
65capture01a1a268-30d4-74d8-af57-c9301e6f100f€24.00€0.37matched
66capture01a1a268-71fc-7218-98f3-0457bcea59ed€9.00€0.19matched
67capture01a1a268-9253-79df-b935-4753fab60a3e€24.00€0.37matched
68capture01a1a268-bdae-7c71-a8a6-d25219562e90€35.00€0.50matched
69capture01a1a268-e13e-754d-b404-1a3cd8943474€24.00€0.37matched
70capture01a1a269-14b5-7995-927d-5c3f0946fc96€9.00€0.19matched
71capture01a1a269-1c9f-778f-b19d-a0d88d5346dd€15.00€0.26matched
72capture01a1a269-34dd-7446-bb17-8933f4ec2140€24.00€0.37matched
73capture01a1a269-3e5b-7e4f-92fe-c73914c8dc5c€35.00€0.50matched
75capture01a1a269-5ef6-7409-86b5-7c1d36f170d1€49.00€0.67matched
76capture01a1a269-631c-7e60-b801-3d31315c595e€49.00€0.67matched
77capture01a1a269-74f2-7392-ae7b-f9e14a8db9c4€24.00€0.37matched
78capture01a1a269-75b3-78bd-8485-a995b365a013€9.00€0.19matched
79capture01a1a269-7a38-710c-8e92-6723f0e73331€24.00€0.37matched
81capture01a1a269-b70e-73fa-a258-223204ef0abd€35.00€0.50matched
82capture01a1a269-bd5f-7912-88d0-0cd8fe58ecfa€15.00€0.26matched
83capture01a1a269-c64e-743c-90c4-1c594f4f2315€9.00€0.19matched
84capture01a1a269-cc1e-70f5-9f9c-d09040b47e2d€9.00€0.19matched
85capture01a1a269-e751-724a-9bd1-4fa3b17620ba€9.00€0.19matched
86capture01a1a269-ef76-7e6d-9acb-5a2b235c76e2€49.00€0.67matched
87refund01a1a269-f7ec-7c68-a320-2ea0b90a29c5-€2.00€0.00matched
88capture01a1a26a-00c1-75c2-ae59-f6293238ac3c€24.00€0.37matched
89capture01a1a26a-092a-70ff-ae06-857c7e1e15be€35.00€0.50matched
90capture01a1a26a-0c74-755f-ab02-011ce00aab79€15.00€0.26matched
91capture01a1a26a-1229-75a7-969e-6e34166f00d1€9.00€0.19matched
92capture01a1a26a-3ce1-71d6-bfd3-2a2446c6c848€35.00€0.50matched
93capture01a1a26a-5303-7fab-9a59-a0940ac45824€35.00€0.50matched
94refund01a1a26a-70a2-7fc2-b360-8e6797f0af01-€8.00€0.00matched
95capture01a1a26a-7ddd-755e-abfe-64ecdb17a1ed€15.00€0.26matched
96capture01a1a26a-8b4b-7b3a-ab40-fbb7edff0fc4€9.00€0.19matched
97capture01a1a26a-b361-72f9-97e6-4af12a66c5cd€35.00€0.50matched
98capture01a1a26a-bb08-7e62-86e9-2c6083b4337c€49.00€0.67matched
99capture01a1a26a-f3d8-7e42-9ac4-1d23c5c8ddc7€49.00€0.67matched
100capture01a1a26a-ff5e-7dea-a0c1-932b93454c3e€15.00€0.26matched
101capture01a1a26b-3d0f-7c96-a97b-236bb872fea5€15.00€0.26matched
102capture01a1a26b-4a89-7319-b76a-08a341b104e3€15.00€0.26matched
103capture01a1a26b-7932-7670-9d9a-1def82c4c978€49.00€0.67matched
104capture01a1a26b-a32d-7644-b701-9d01813045a0€35.00€0.50matched
105capture01a1a26b-a646-74a3-939f-a564bb6ad626€49.00€0.67matched
106capture01a1a26b-bd33-7d0b-8780-49a9bf1d84d8€49.00€0.67matched
107capture01a1a26b-e858-7c2b-9ba5-55fdd0cd5f40€15.00€0.26matched
108capture01a1a26c-1e99-7ec3-ae07-18c54ca2ffab€24.00€0.37matched
109capture01a1a26c-22aa-79da-b2bf-3330c999c583€24.00€0.37matched
110capture01a1a26c-2365-7265-a5c1-be2d70a9ef9f€35.00€0.50matched
111capture01a1a26c-2667-7502-9e27-4d08c5c752fe€15.00€0.26matched
112capture01a1a26c-3dbe-7de7-bd3d-244e89bf57c4€35.00€0.50matched
113capture01a1a26c-54e6-7bc5-9a91-0786f3ce3600€9.00€0.19matched
114capture01a1a26c-58ad-71d5-bfa0-18b142460975€24.00€0.37matched
115refund01a1a26c-651d-7084-b025-d3cf5051fd04-€9.00€0.00matched
116capture01a1a26c-6da2-7a3d-b8b2-0eae532ae425€49.00€0.67matched
117capture01a1a26c-7d74-795e-8e1b-0c8fc607974d€15.00€0.26matched
118capture01a1a26c-7f83-78d3-8efb-de5dfe9687a9€49.00€0.67matched
119capture01a1a26c-8d4b-72de-9ab8-3520f0a61093€15.00€0.26matched