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

2 Nov, 12:00

Gross

€2,867.00

PSP fee

€45.85

Net to the bank

€2,821.15

Settlement journal

#342474

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
  • missing linein the books, not in the filecapture:01a19c2a-80c3-7251-adb6-2fe79eba3ebc is in no file
  • missing linein the books, not in the filecapture:01a19c24-79cb-7029-8b34-0b090f7e1254 is in no file
LineKindReferenceGrossFeeStatus
52capture01a19c24-f2ef-7e47-b671-37a2a75b26d6€24.00€0.38fee difference
1capture01a19c18-89c7-7ce5-9742-ed8e12c820cb€9.00€0.19matched
2capture01a19c19-0690-7d67-a66a-513985dd5a61€49.00€0.67matched
3capture01a19c1b-0f09-7aa1-a749-2dc866afbd8d€49.00€0.67matched
4capture01a19c1c-f8c7-7e15-a0af-560f1f1f1175€15.00€0.26matched
5capture01a19c21-7ce6-7e2c-b439-432597a9f641€35.00€0.50matched
6capture01a19c21-83a5-70ab-8a72-eaf4abf91b59€9.00€0.19matched
7refund01a19c21-8e6f-7b1d-92cd-486a133ff237-€6.00€0.00matched
8capture01a19c21-9d02-733e-87de-8b83f77f3323€15.00€0.26matched
9capture01a19c21-a701-75ee-b576-dadbfa068a3e€49.00€0.67matched
10capture01a19c21-ca06-7f84-a0a5-1bfdf02bf2e4€15.00€0.26matched
11capture01a19c21-fca5-73be-834d-897eefc09e6f€15.00€0.26matched
12capture01a19c22-0245-7999-b234-a4fc7e967e8b€24.00€0.37matched
13capture01a19c22-05f5-7451-8a82-121f4e642bf2€24.00€0.37matched
14capture01a19c22-33fb-7a79-81f0-99e24de791af€35.00€0.50matched
15capture01a19c22-414d-7ee9-811e-4bfc681ce8e0€24.00€0.37matched
16capture01a19c22-49ac-70c6-8e5c-43e9eff5752c€24.00€0.37matched
17capture01a19c22-6038-7313-937c-759c96749c9a€24.00€0.37matched
18capture01a19c22-ce25-72f1-b1e3-21039399a417€15.00€0.26matched
19capture01a19c22-ed4a-7bb0-998c-2e22e698b761€35.00€0.50matched
20capture01a19c22-ffa3-75f2-b1e2-db0b77b81868€24.00€0.37matched
21capture01a19c23-0b50-7fe2-8517-9c593512df59€15.00€0.26matched
22capture01a19c23-0f07-7847-b5b1-51d9137e410b€24.00€0.37matched
23capture01a19c23-16cf-799d-903b-2677084e2f23€9.00€0.19matched
24capture01a19c23-1d93-7324-b5e2-95bc2b72fdc6€9.00€0.19matched
25capture01a19c23-213d-7555-8bcf-fb346f52a79c€35.00€0.50matched
26capture01a19c23-33aa-70ff-a8c9-51d93ec19677€15.00€0.26matched
27capture01a19c23-456a-770b-af41-36bd6b10509c€35.00€0.50matched
28capture01a19c23-48d9-7fdf-8196-c74418a162c7€24.00€0.37matched
29capture01a19c23-5fee-7900-9a0b-be3f1f258a13€15.00€0.26matched
30capture01a19c23-697f-7859-ac30-be2a5fa876bf€9.00€0.19matched
31capture01a19c23-883c-7fd9-96ce-500dce915768€9.00€0.19matched
32refund01a19c23-8b6e-7798-adf1-77f3322e443a-€2.00€0.00matched
33capture01a19c23-90ff-7630-b140-274d4685853b€49.00€0.67matched
34capture01a19c23-a112-78f0-86a2-2b378e2857f1€35.00€0.50matched
35capture01a19c23-a1b4-7e7a-ab81-147e2b52e967€35.00€0.50matched
36capture01a19c23-d335-7ff9-81fc-1e6b0b35d9a6€49.00€0.67matched
37capture01a19c23-ddce-71ee-9fa2-f763b7153737€35.00€0.50matched
38capture01a19c23-e146-7c0a-ab98-9849cef09869€9.00€0.19matched
39capture01a19c23-f718-7ee4-988f-268a8acad6d8€9.00€0.19matched
40capture01a19c24-0481-779e-ab6b-7b2469483967€9.00€0.19matched
41capture01a19c24-0533-7fe0-b0e2-1ab10cb7eb50€49.00€0.67matched
42capture01a19c24-0fd2-71dd-a34c-3045176ef882€9.00€0.19matched
43capture01a19c24-1775-765b-8a82-fb4f34e3c37e€35.00€0.50matched
44capture01a19c24-1ee5-7fbd-a899-f780beff3d10€24.00€0.37matched
45capture01a19c24-3b28-7947-aa91-7df457353621€49.00€0.67matched
46refund01a19c24-4d7f-791a-8d6b-157e5a2407bb-€9.00€0.00matched
47capture01a19c24-7e3a-7eff-94bf-b7a92db03482€49.00€0.67matched
48capture01a19c24-8800-740e-ab46-7b444fe24ba6€9.00€0.19matched
49refund01a19c24-b5b6-7326-a81c-3709ca8553f5-€39.00€0.00matched
50capture01a19c24-bad7-7b60-9f63-6f791e059b3e€24.00€0.37matched
51capture01a19c24-ee9a-7f34-8372-2599ee779743€24.00€0.37matched
53capture01a19c25-0021-7143-b041-7d79d8fd239b€9.00€0.19matched
54capture01a19c25-15ee-7d9b-b3e4-e45f344e52ec€24.00€0.37matched
55capture01a19c25-176c-7670-b0bc-4b125281294d€15.00€0.26matched
56capture01a19c25-4a97-7e91-827b-299f5ec57021€24.00€0.37matched
57capture01a19c25-4d17-78fd-89d9-328f263dc03c€9.00€0.19matched
58capture01a19c25-4d9a-72bb-bcc2-ccbbb8f828dd€9.00€0.19matched
59capture01a19c25-583e-76ac-a713-123234ba10b5€15.00€0.26matched
60capture01a19c25-6ce2-7389-bad5-f4747fea07d4€49.00€0.67matched
61capture01a19c25-7fa6-7f2d-86e1-f19d5b01d847€24.00€0.37matched
62capture01a19c25-b10c-7ea7-b6a8-8fea9145fb06€24.00€0.37matched
63capture01a19c25-dc97-7d92-9c9f-95906dd5837d€15.00€0.26matched
64capture01a19c25-dd86-78c8-9442-6a8c860b38b4€35.00€0.50matched
65refund01a19c25-e6be-7eb8-816a-a2786f37e489-€6.00€0.00matched
66capture01a19c25-ed51-70ed-8674-1a286904a37d€15.00€0.26matched
67capture01a19c25-e015-7cf0-b65d-ae0d70387678€9.00€0.19matched
68capture01a19c25-fba0-7183-8b8c-52176519cc60€15.00€0.26matched
69capture01a19c26-23e4-7a31-99f3-707fdb63f15b€49.00€0.67matched
70capture01a19c26-3f42-7174-8991-4bc0691ce733€24.00€0.37matched
71capture01a19c26-4f61-75c1-8c8e-c9c0f8d29bfc€35.00€0.50matched
72capture01a19c26-5217-768f-84a8-00c85283c12d€49.00€0.67matched
73capture01a19c26-574f-798e-8bd2-b98ac12819e3€35.00€0.50matched
74capture01a19c26-6c56-7839-8110-fee6e38868fb€49.00€0.67matched
75capture01a19c26-7737-742c-89aa-adc485a039e5€35.00€0.50matched
76capture01a19c26-7b36-7d33-b209-9ab8cf35faac€49.00€0.67matched
77capture01a19c26-90b8-72e6-b740-03687a324b94€9.00€0.19matched
78capture01a19c26-91b5-7702-81c1-d60548e8c951€35.00€0.50matched
79capture01a19c26-a056-72aa-a27e-d33dc0fdc804€49.00€0.67matched
80refund01a19c26-bd36-7e48-8b36-8f57cc52e6bf-€30.00€0.00matched
81capture01a19c26-cb83-754f-888d-68bfa5c5e533€35.00€0.50matched
82refund01a19c26-cea1-785a-9fc5-2a2c0c9ff240-€10.00€0.00matched
83capture01a19c26-cf11-797d-b76e-076d5051b1c1€35.00€0.50matched
84capture01a19c27-11a4-7644-bae8-db6e14ed5e13€9.00€0.19matched
85capture01a19c27-1868-7d89-9bab-8b919187436c€9.00€0.19matched
86capture01a19c27-2e52-7904-bce1-aedd7f5e707f€49.00€0.67matched
87capture01a19c27-341c-7d0f-8bb7-a0e5629e43d6€24.00€0.37matched
88capture01a19c27-6487-775f-9c5a-3feae14158c7€49.00€0.67matched
89refund01a19c27-6ebf-7b73-980a-955e1b2d281e-€6.00€0.00matched
90capture01a19c27-8a3e-782a-82c1-ae383ec194b7€9.00€0.19matched
91capture01a19c27-8ac9-7e82-9df9-c63df008dd76€24.00€0.37matched
92capture01a19c27-af5f-79af-94e9-c70a9d22b5e9€15.00€0.26matched
93capture01a19c27-cdc1-7d26-a9a5-037bd2a3dab3€9.00€0.19matched
94capture01a19c27-d2cf-7445-abc4-35f6a566e5fb€15.00€0.26matched
95refund01a19c27-e6f8-76ce-b387-d9ac47256487-€10.00€0.00matched
96capture01a19c27-ec73-774d-bfcc-804bbd892eee€24.00€0.37matched
97capture01a19c27-ff48-78df-87e8-dc20f5f8edef€15.00€0.26matched
98capture01a19c28-163c-7c0c-bbe2-a66f416a45a6€35.00€0.50matched
99capture01a19c28-21a8-78d1-9522-0273bcc783a1€49.00€0.67matched
100capture01a19c28-33d5-7f23-b49c-86fe8b04a4b1€9.00€0.19matched
101refund01a19c28-42e2-78e8-8fe2-f973d3db5325-€7.00€0.00matched
102capture01a19c28-7ba5-78c0-b5df-a788ea626a41€35.00€0.50matched
103capture01a19c28-7fd4-7977-9a59-739c643f5294€15.00€0.26matched
104capture01a19c28-8c78-76de-9606-616b5a722dac€24.00€0.37matched
105capture01a19c28-8f42-748f-83f0-75094243b2d1€15.00€0.26matched
106capture01a19c28-a3dd-7539-8f52-6b1a9f7832c0€24.00€0.37matched
107capture01a19c28-af4e-726d-a504-2c9267a2bce2€15.00€0.26matched
108capture01a19c28-b8bd-71cc-9c3f-b03dddb62b3d€15.00€0.26matched
109capture01a19c28-c473-7187-8d47-481e2f825386€35.00€0.50matched
110capture01a19c28-e83a-79e3-9059-762a5a47e434€24.00€0.37matched
111capture01a19c28-fac4-72b4-bfee-a90bc54f7753€15.00€0.26matched
112capture01a19c29-1676-745f-b40b-2aed001f797e€9.00€0.19matched
113capture01a19c29-18c3-74f6-8b2f-86f8c01a7063€49.00€0.67matched
114capture01a19c29-1973-725b-88e8-72ac50cdfabd€15.00€0.26matched
115capture01a19c29-6509-748e-84a6-4d6dd129ed28€15.00€0.26matched
116capture01a19c29-76a8-79a1-b123-0c8c72dc44bd€49.00€0.67matched
117capture01a19c29-9333-7f11-a38e-9a5e80b973dc€49.00€0.67matched
118capture01a19c29-9636-7b3b-af6a-b9e12836a3d6€24.00€0.37matched
119capture01a19c29-a6c9-7130-b05b-2fb6769830d0€49.00€0.67matched
120capture01a19c29-c0c7-7e6f-a916-e1e4843fb783€24.00€0.37matched
121capture01a19c29-c548-7a14-83d1-f0d472b82026€35.00€0.50matched
122refund01a19c29-d735-7976-b94f-badb0603d17a-€36.00€0.00matched
123capture01a19c29-ece2-7b5c-b844-f1f9d78a673c€49.00€0.67matched
124capture01a19c2a-21ae-7fd6-a780-c66efbe7f259€24.00€0.37matched
125capture01a19c2a-444d-773b-bd2b-246b9f06cd0d€9.00€0.19matched
126capture01a19c2a-4cf9-7da8-ada4-82cf3af4cdda€35.00€0.50matched
127capture01a19c2a-6546-7b25-adc1-723dff29d31b€15.00€0.26matched
128capture01a19c2a-915f-7a0e-ade0-fb5b1facbdee€24.00€0.37matched