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, 09:50

Gross

€2,963.00

PSP fee

€49.14

Net to the bank

€2,913.86

Settlement journal

#359158

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 30, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 3, the contract says 0
  • missing linein the books, not in the filerefund:01a1a0d3-7ebd-7cea-85c3-bf88a8ab9d18 is in no file
  • missing linein the books, not in the filecapture:01a1a0d6-be39-7952-b61f-99ac7971cdb5 is in no file
  • missing linein the books, not in the filecapture:01a1a0d8-f8d0-7298-bd37-7db6949c3693 is in no file
LineKindReferenceGrossFeeStatus
8capture01a1a0d1-0f7d-7a59-a25b-785b1339bd02€15.00€0.31fee difference
36capture01a1a0d2-721f-76f4-832f-016932773b79€15.00€0.30fee difference
75refund01a1a0d4-e4cf-74c0-b35b-74283e1c22c8-€20.00€0.03fee difference
1capture01a1a0c7-fe6b-7338-9a96-1570c8b9034e€15.00€0.26matched
2capture01a1a0ca-55ac-7982-bd5c-96f4d6ee0453€49.00€0.67matched
3capture01a1a0cc-0239-7c8d-9352-a9fad57d5be5€15.00€0.26matched
4capture01a1a0cd-779d-7eae-a0c3-aad1d1ee12cd€9.00€0.19matched
5capture01a1a0cd-c7c8-79f7-ac15-20487a1437b7€9.00€0.19matched
6capture01a1a0d0-dc53-72f6-9d23-ce2c99cd4c21€49.00€0.67matched
7capture01a1a0d1-03ff-79b4-8290-164f2141e41b€24.00€0.37matched
9capture01a1a0d1-1dd7-7529-9562-b6c67438068e€24.00€0.37matched
10capture01a1a0d1-2343-71fe-8a2c-eea7013a610f€9.00€0.19matched
11refund01a1a0d1-238f-75ff-b472-071343845e74-€42.00€0.00matched
12capture01a1a0d1-24f4-71f2-ad2e-88e2c58e3e2d€9.00€0.19matched
13capture01a1a0d1-2f01-77fb-b134-5e1fe85250f1€15.00€0.26matched
14capture01a1a0d1-38b5-7efd-a489-293064a9f098€35.00€0.50matched
15capture01a1a0d1-3ebe-70df-8a7d-acb51d1d1023€9.00€0.19matched
16capture01a1a0d1-523e-7ee9-a76f-564d3e36a861€24.00€0.37matched
17capture01a1a0d1-5e75-7bc8-90ff-7519c6bc5376€24.00€0.37matched
18capture01a1a0d1-60f4-798b-abe0-b014454b27c8€15.00€0.26matched
19capture01a1a0d1-6766-7933-b6da-8bb8d5ac54ce€49.00€0.67matched
20capture01a1a0d1-8eb1-72a5-b46c-a8e2643ed992€35.00€0.50matched
21capture01a1a0d1-8f3f-718c-964e-3eb2a805a3a3€15.00€0.26matched
22capture01a1a0d1-9fff-730e-9f17-270659aa333c€15.00€0.26matched
23capture01a1a0d1-9b24-7580-9a27-360fdf09c166€35.00€0.50matched
24capture01a1a0d1-ab35-79aa-a0f5-0a66844a4cf4€9.00€0.19matched
25capture01a1a0d1-ae5c-7540-88e3-5ebdefb9fe4c€15.00€0.26matched
26capture01a1a0d1-aea1-7506-9809-db5d2927dc41€15.00€0.26matched
27capture01a1a0d1-baf5-7735-b4a4-150f213d4509€9.00€0.19matched
28capture01a1a0d1-c816-765c-9bb1-b80bd93ab6a3€24.00€0.37matched
29capture01a1a0d1-e0d5-70ce-b128-801a321c0939€9.00€0.19matched
30refund01a1a0d2-1681-7e00-8d98-2675ea6dfdbd-€3.00€0.00matched
31capture01a1a0d2-1f8a-7b1b-9e86-e5341427748b€49.00€0.67matched
32capture01a1a0d2-34d7-72d1-bd2e-8bd6fd86c39c€49.00€0.67matched
33capture01a1a0d2-3aca-7b66-b44b-481fe5c89684€24.00€0.37matched
34capture01a1a0d2-4ef8-7532-ad57-59b6b4fc293d€15.00€0.26matched
35capture01a1a0d2-551c-7a9e-b8a1-21faf206e017€9.00€0.19matched
37capture01a1a0d2-b9ad-73e2-8f7c-4faa88eed188€35.00€0.50matched
38capture01a1a0d2-d171-7ce8-bd3e-4b5c0868391e€49.00€0.67matched
39capture01a1a0d2-def0-7a34-bc7a-73cd25b3cf45€15.00€0.26matched
40capture01a1a0d3-021e-7882-96a9-fed23b764292€35.00€0.50matched
41capture01a1a0d3-02cd-70e4-8811-e08d295d76ea€35.00€0.50matched
42capture01a1a0d3-0943-7488-a2e5-748e961ff934€15.00€0.26matched
43refund01a1a0d3-1de8-7bea-8960-0f0bdfc8cfb3-€34.00€0.00matched
44capture01a1a0d3-287b-7de1-a889-87a729b418f4€15.00€0.26matched
45capture01a1a0d3-38a2-7a7b-b9d8-93ca09ebbaa8€35.00€0.50matched
46capture01a1a0d3-4673-7783-a42e-9e45bf1cdfc8€35.00€0.50matched
47capture01a1a0d3-4985-771a-b233-fe2d2d122247€49.00€0.67matched
48capture01a1a0d3-49c0-795f-9767-bfbf8124f104€24.00€0.37matched
49capture01a1a0d3-7326-7f69-8dc3-dd3b14ffc719€15.00€0.26matched
50capture01a1a0d3-6f2b-70dc-b896-33658cb8d392€15.00€0.26matched
51capture01a1a0d3-90c3-7ab1-9c58-a33d3d7d43b9€35.00€0.50matched
52capture01a1a0d3-9e49-7a7d-9831-dc3a0cff6286€49.00€0.67matched
53capture01a1a0d3-9f5c-7550-b463-30eb3e5db264€15.00€0.26matched
54capture01a1a0d3-a687-7edb-b37f-9325239acdca€15.00€0.26matched
55capture01a1a0d3-c43e-7a59-97a9-173cc5478706€9.00€0.19matched
56capture01a1a0d3-c973-7bf0-94fd-d4f229fcdfab€9.00€0.19matched
57refund01a1a0d3-cf6f-75c7-bb8b-3249a4cb78d7-€11.00€0.00matched
58capture01a1a0d3-d219-7e36-8e0f-f025d2ece3cf€49.00€0.67matched
59capture01a1a0d3-e540-7055-88f5-9703ea30479a€9.00€0.19matched
60capture01a1a0d3-e6fd-79b5-b671-4fc3ee25e122€15.00€0.26matched
61capture01a1a0d4-0871-7876-9b29-71f9c13b8ac5€49.00€0.67matched
62capture01a1a0d4-43ca-7884-81fb-935ca5916acf€24.00€0.37matched
63capture01a1a0d4-5906-7993-913a-b5998a191513€49.00€0.67matched
64capture01a1a0d4-681d-754f-b79a-43bb87e9fa5b€9.00€0.19matched
65capture01a1a0d4-886d-7b99-9def-0cd9447e62c2€15.00€0.26matched
66refund01a1a0d4-8979-7abf-b181-a6bff8f7dc73-€16.00€0.00matched
67capture01a1a0d4-8adb-76b3-9899-b55d35079c17€9.00€0.19matched
68capture01a1a0d4-9323-72cd-a181-97d404d24100€15.00€0.26matched
69capture01a1a0d4-b326-7eaf-9eab-c70a5e74d43c€35.00€0.50matched
70capture01a1a0d4-c7cb-7bbd-ae71-97a1d9f46ba8€15.00€0.26matched
71capture01a1a0d4-d00e-7176-b2fe-3619014fda4a€49.00€0.67matched
72capture01a1a0d4-d556-7ea5-afb6-cc9a82d353a9€9.00€0.19matched
73capture01a1a0d4-dd01-7cf2-ad03-c0efea3dd504€35.00€0.50matched
74capture01a1a0d4-dfa6-70e3-b91c-fdf93520f005€24.00€0.37matched
76capture01a1a0d4-e7b3-75a7-9795-5410e2120414€49.00€0.67matched
77capture01a1a0d4-ec24-7469-b81b-bf3c74f3f283€15.00€0.26matched
78refund01a1a0d4-efdb-74fe-8e55-34cac506c1cd-€5.00€0.00matched
79capture01a1a0d4-fe26-75d3-a9f8-51be197aecf7€15.00€0.26matched
80capture01a1a0d5-28a8-7802-b9d4-46e71dd3dff8€15.00€0.26matched
81refund01a1a0d5-373a-7b10-a242-90f69adc9dfc-€26.00€0.00matched
82capture01a1a0d5-479d-79c9-9646-e922bc743760€49.00€0.67matched
83capture01a1a0d5-48bc-74df-9d00-4d3443b0d39c€15.00€0.26matched
84capture01a1a0d5-5b35-7875-95c2-1683d9392dad€35.00€0.50matched
85refund01a1a0d5-7953-796f-ab82-d41655b23bec-€7.00€0.00matched
86capture01a1a0d5-7f9e-797c-a2b5-82822f2ed19a€24.00€0.37matched
87capture01a1a0d5-8827-7657-9f97-905423f18bd7€9.00€0.19matched
88capture01a1a0d5-8d1d-78c9-954d-50971fac367c€24.00€0.37matched
89capture01a1a0d5-a45c-7335-a293-da16b5194795€35.00€0.50matched
90refund01a1a0d5-abb8-7dae-ac58-06c4c9017bae-€19.00€0.00matched
91capture01a1a0d5-adfb-7e2d-aeb7-971130781285€15.00€0.26matched
92capture01a1a0d5-b504-74c0-97c3-c3f6c3eeb91c€9.00€0.19matched
93capture01a1a0d5-c37c-7945-b36a-497aff30a275€35.00€0.50matched
94capture01a1a0d5-cf81-743e-a832-b057a918c0e8€15.00€0.26matched
95capture01a1a0d5-d5a9-7321-96fc-247a3d5b0591€35.00€0.50matched
96capture01a1a0d6-08e3-71af-b8ab-bc6e860e6ef0€15.00€0.26matched
97capture01a1a0d6-16d4-78d9-9087-195ef2414f8c€35.00€0.50matched
98capture01a1a0d6-2345-7ebf-a72e-913cf0485561€9.00€0.19matched
99refund01a1a0d6-4484-7a85-9e07-0fca3211f596-€10.00€0.00matched
100capture01a1a0d6-765e-7449-b01f-f9f5c726774e€15.00€0.26matched
101refund01a1a0d6-7676-71f7-8e80-722b423aa7d1-€25.00€0.00matched
102capture01a1a0d6-a3fa-77c5-8cc3-15eee3157e60€49.00€0.67matched
103capture01a1a0d6-b592-77a8-b8e1-0ad04afbaf46€15.00€0.26matched
104capture01a1a0d6-d8c8-7f61-8d99-7f7bedeaa6c7€49.00€0.67matched
105capture01a1a0d6-fc2d-760d-a360-76f22721e7c2€24.00€0.37matched
106capture01a1a0d7-39c3-78d9-91f8-089dfd03f954€49.00€0.67matched
107capture01a1a0d7-3eb8-71ec-8070-8ba51f5fd4fd€15.00€0.26matched
108capture01a1a0d7-427b-7cc1-af95-99d23133e0a6€49.00€0.67matched
109capture01a1a0d7-68af-7a30-bde0-833cf65635d7€49.00€0.67matched
110capture01a1a0d7-7e9c-7d49-975e-15943ddaf6b9€15.00€0.26matched
111capture01a1a0d7-9352-7154-a028-6d2d38c80757€49.00€0.67matched
112capture01a1a0d7-ad8b-709e-a436-ebb5ce7a6f72€15.00€0.26matched
113refund01a1a0d7-b1eb-7513-bfb2-2a4dbf38dbe4-€13.00€0.00matched
114refund01a1a0d7-b88c-76cb-828e-ce4f0172a9fe-€3.00€0.00matched
115capture01a1a0d7-e4d6-7517-a0a2-a39d62846bdd€35.00€0.50matched
116capture01a1a0d7-e7e2-74c3-8ead-13f486dc37bf€15.00€0.26matched
117capture01a1a0d8-133e-7040-a5c0-ca41582bee06€15.00€0.26matched
118capture01a1a0d8-39fb-74bc-8a8b-2af542c6e5f4€15.00€0.26matched
119capture01a1a0d8-3fd6-7269-8b34-517814585060€24.00€0.37matched
120capture01a1a0d8-54da-7193-9613-dc5c879d3083€49.00€0.67matched
121capture01a1a0d8-75bc-7148-9a2a-b3d3dd481e88€49.00€0.67matched
122refund01a1a0d8-7ad1-7939-a2e4-56b6824a9a1d-€10.00€0.00matched
123capture01a1a0d8-7dab-733d-b14f-20ba15b9a22b€15.00€0.26matched
124capture01a1a0d8-834c-760a-9b40-9fc1eb2cc556€35.00€0.50matched
125capture01a1a0d8-961a-7d37-abb4-ed477dec3ff9€49.00€0.67matched
126capture01a1a0d8-9f46-71db-baa0-8722b003976d€35.00€0.50matched
127refund01a1a0d8-a327-7a8d-a5d9-b6600e2b66a3-€15.00€0.00matched
128capture01a1a0d8-aa66-7e0d-bdb1-3e6bd15a11e1€35.00€0.50matched
129capture01a1a0d8-dfc1-7317-8fd9-bae256a4101c€35.00€0.50matched
130capture01a1a0d8-fb84-7a01-9031-cb68f937a4e5€15.00€0.26matched
131capture01a1a0d9-3720-7bfc-9e33-1e5be86d20d9€35.00€0.50matched
132capture01a1a0d9-495f-71b7-882e-db8ae3a7d5b1€49.00€0.67matched
133capture01a1a0d9-531f-7380-9e57-4e43e23e0d52€49.00€0.67matched
134refund01a1a0d9-8874-7c46-b249-ec32a653d96e-€33.00€0.00matched
135capture01a1a0d9-8c36-786f-9df8-6fe13f43de31€24.00€0.37matched
136capture01a1a0d9-a3f3-7e94-84b4-d41d71b2f943€49.00€0.67matched
137capture01a1a0d9-a6c6-76c5-9d8e-7a5d7b23cc02€35.00€0.50matched
138capture01a1a0d9-b8fd-703c-88e6-91c69fb20af4€49.00€0.67matched
139capture01a1a0d9-dbd9-7146-8da0-931afe70f02c€9.00€0.19matched
140capture01a1a0d9-ea86-7fc5-a6eb-901f3166dce6€35.00€0.50matched