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, 21:30

Gross

€2,954.00

PSP fee

€47.66

Net to the bank

€2,906.34

Settlement journal

#349766

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 27, the contract says 26
  • missing linein the books, not in the filecapture:01a19e2d-53bd-7d0d-86c2-cb718102fedb is in no file
LineKindReferenceGrossFeeStatus
12capture01a19e2c-1f3b-7820-a7a8-147cabc93e42€15.00€0.27fee difference
1capture01a19e22-4fb9-7fee-8018-4f6ef72094f7€24.00€0.37matched
2capture01a19e26-4cc4-7d2e-8a3d-3b03ebc052cd€49.00€0.67matched
3capture01a19e2b-56a4-74c3-8541-184e81502fc4€9.00€0.19matched
4capture01a19e2b-6012-76dd-94e1-be8d3fc65429€9.00€0.19matched
5capture01a19e2b-60b5-77ef-9b48-dfcdb67fcc33€35.00€0.50matched
6capture01a19e2b-6a24-76c8-97a0-aa375233f90f€49.00€0.67matched
7refund01a19e2b-6dd2-71f9-8460-1abf2640cc0a-€24.00€0.00matched
8capture01a19e2b-92d3-7dd7-8de4-3ad351dad79b€24.00€0.37matched
9capture01a19e2b-963a-7619-aaba-094737db1c57€9.00€0.19matched
10refund01a19e2b-bb1f-7527-ab29-a0a3714980bf-€6.00€0.00matched
11capture01a19e2c-0b3d-7da8-9303-ecea0570d844€49.00€0.67matched
13capture01a19e2c-2256-76a2-8e0f-f7c02fc3ce68€24.00€0.37matched
14capture01a19e2c-3825-7c8c-b9b8-5fb6663b9d46€24.00€0.37matched
15capture01a19e2c-4121-7e0a-b026-2a4d918acb7f€15.00€0.26matched
16capture01a19e2c-42b0-7619-9591-aaa8ce0162cc€24.00€0.37matched
17capture01a19e2c-4d20-7c4d-b0e7-90a62a75197a€24.00€0.37matched
18capture01a19e2c-5054-77e3-a2e0-d92304998b6d€49.00€0.67matched
19capture01a19e2c-63fc-7f47-8a7a-590b024455d4€35.00€0.50matched
20refund01a19e2c-6acc-7495-bc64-d851cd0c30fc-€9.00€0.00matched
21capture01a19e2c-6c10-7f16-a231-677b8d47a269€9.00€0.19matched
22capture01a19e2c-77d2-76e6-bdee-366d8003096a€9.00€0.19matched
23capture01a19e2c-7a29-751c-94d5-58252161fd3c€24.00€0.37matched
24capture01a19e2c-7bd5-738e-ac45-3bf5283b1e1f€49.00€0.67matched
25capture01a19e2c-8781-7f5d-9599-51b385976de6€9.00€0.19matched
26capture01a19e2c-96b6-75b9-a7da-464d7180a670€9.00€0.19matched
27capture01a19e2c-b04d-7f19-b08a-b3b11fff1a40€15.00€0.26matched
28capture01a19e2c-ef92-7813-a80d-ba0313fb2388€9.00€0.19matched
29capture01a19e2c-ff7b-72c4-9a83-4547655a6ca0€9.00€0.19matched
30capture01a19e2d-1c90-7d66-aeea-ff71e4801bf4€9.00€0.19matched
31capture01a19e2d-2d2c-7054-8c8a-3940180569b1€24.00€0.37matched
32capture01a19e2d-6179-76e8-b1e7-4b07cacd8afc€9.00€0.19matched
33capture01a19e2d-6363-79ac-a306-3b3061424224€35.00€0.50matched
34capture01a19e2d-8b1e-725c-a02e-7e69c1ff7162€35.00€0.50matched
35capture01a19e2d-8c10-7e2b-a07e-e4b36f6fe9ca€9.00€0.19matched
36capture01a19e2d-8d53-71c1-8f23-1b80c146caa5€15.00€0.26matched
37capture01a19e2d-9ff7-7975-bdf1-bbf7e381e599€9.00€0.19matched
38capture01a19e2d-aadb-75e7-8d24-086f200ec86f€49.00€0.67matched
39capture01a19e2d-c0fb-7726-98d9-fdc8bf43e50a€24.00€0.37matched
40capture01a19e2d-dc90-7fbb-9035-da5220eab742€49.00€0.67matched
41capture01a19e2d-eb61-7a30-92aa-77378ce2a7c1€49.00€0.67matched
42capture01a19e2e-4095-78e0-8c06-c6836875a7e6€9.00€0.19matched
43capture01a19e2e-4c38-7e9e-b8e7-2aad2947187c€35.00€0.50matched
44refund01a19e2e-9791-7814-8272-b05b08118ef5-€8.00€0.00matched
45capture01a19e2e-94b5-7dce-928f-9d271e801b49€49.00€0.67matched
46capture01a19e2e-aa85-72b2-ad4e-de00ac592831€24.00€0.37matched
47capture01a19e2e-b083-7a31-9843-0e24fd4232c6€9.00€0.19matched
48capture01a19e2e-d3af-7ca8-8963-6d9ded74ce94€49.00€0.67matched
49capture01a19e2e-dfd0-7963-a8e5-bed1d3f12f39€15.00€0.26matched
50capture01a19e2e-e75d-7556-a1c2-3b559ae47b2e€35.00€0.50matched
51capture01a19e2e-ff51-7463-bf3d-8dff2ea1af27€35.00€0.50matched
52capture01a19e2f-2270-7be4-a8d5-75937516ca0a€24.00€0.37matched
53capture01a19e2f-29bf-7e04-b639-8ed6fb3318fc€24.00€0.37matched
54capture01a19e2f-546f-7c21-88be-a905f3d4fb32€49.00€0.67matched
55capture01a19e2f-66e7-7da5-9501-9e360dee1ca2€49.00€0.67matched
56capture01a19e2f-7dab-725f-a315-b9d2a6531468€49.00€0.67matched
57capture01a19e2f-8440-7f5e-a8d3-884f443d859d€35.00€0.50matched
58capture01a19e2f-8b61-75db-b24a-7fafef7ac904€15.00€0.26matched
59capture01a19e2f-8de0-7692-99d4-24c7321b31c2€35.00€0.50matched
60capture01a19e2f-9151-75ab-bce7-9f57b0c12efc€35.00€0.50matched
61capture01a19e2f-9b10-7fd1-8554-b15fb8dcd41d€24.00€0.37matched
62refund01a19e2f-9f6e-7a0a-a62b-42732eb6a429-€47.00€0.00matched
63capture01a19e2f-c9f3-741c-9721-2fb15bea7a55€24.00€0.37matched
64capture01a19e2f-d150-7925-92d0-1b2d943787ec€35.00€0.50matched
65refund01a19e2f-d436-7aad-b768-85f46ed97156-€41.00€0.00matched
66capture01a19e2f-d460-7999-8063-957e55fe0c81€35.00€0.50matched
67capture01a19e2f-edb8-795a-b765-602cf5585678€15.00€0.26matched
68capture01a19e2f-f16f-7a6f-a651-c3c288dafd68€35.00€0.50matched
69capture01a19e2f-fe34-7176-b339-9d3584e7863b€49.00€0.67matched
70capture01a19e30-0211-725a-8439-ef75b6668b41€24.00€0.37matched
71capture01a19e30-0601-779b-9d46-f3373d6a7c32€24.00€0.37matched
72capture01a19e30-0b67-7de4-a0a0-1139e44e0b42€15.00€0.26matched
73capture01a19e30-0c37-7844-9f25-b32dd7bea336€35.00€0.50matched
74capture01a19e30-1e36-72a0-a5e9-d9e5a1cbc5a3€35.00€0.50matched
75capture01a19e30-4141-77a1-89e2-60efacd7df6d€15.00€0.26matched
76capture01a19e30-754b-7e47-b7a7-5fc0cdeda129€35.00€0.50matched
77capture01a19e30-8176-7096-8fe2-38f48b331085€9.00€0.19matched
78capture01a19e30-9567-78b3-9a3f-38da9b9e93c4€9.00€0.19matched
79capture01a19e30-a753-768c-8e4e-8a183f4e37fe€49.00€0.67matched
80capture01a19e30-b65b-7253-ab71-22a5d5ea484e€9.00€0.19matched
81capture01a19e30-c491-751e-bbaa-223a32169466€15.00€0.26matched
82capture01a19e30-cbea-7e69-85e1-93fc1b565858€15.00€0.26matched
83capture01a19e30-fcfa-7e7e-8415-5ee6da27c3ab€35.00€0.50matched
84capture01a19e31-024f-7773-bf27-ac2fea0a891a€9.00€0.19matched
85capture01a19e31-0d46-7882-a139-0a67aff643b5€24.00€0.37matched
86capture01a19e31-1287-74ee-b207-3c5c42e79e28€15.00€0.26matched
87capture01a19e31-1de4-7d03-be8f-91bad83a14fa€35.00€0.50matched
88capture01a19e31-3616-7374-a022-559f4595b561€49.00€0.67matched
89capture01a19e31-53a4-7a12-916c-8ddbc7e558fe€35.00€0.50matched
90refund01a19e31-6e4c-7641-8a32-304966ae365f-€10.00€0.00matched
91capture01a19e31-763c-786d-a8f6-6047f35c9a8d€15.00€0.26matched
92capture01a19e31-7e60-7de0-97d2-9d4ca34a7de8€24.00€0.37matched
93capture01a19e31-89c5-7d3f-b10f-da34e93bdc66€35.00€0.50matched
94capture01a19e31-89da-718b-a15c-0173aad9f476€9.00€0.19matched
95capture01a19e31-8e10-7128-9f1d-8429284c4aac€49.00€0.67matched
96capture01a19e31-9243-7ab2-9226-3ff3e06abf85€15.00€0.26matched
97capture01a19e31-9744-752f-98c7-0ef152ce3cb8€15.00€0.26matched
98capture01a19e31-a10a-78cc-a954-34c324961c60€9.00€0.19matched
99capture01a19e31-a4d8-7d80-9c04-349031cfd71f€35.00€0.50matched
100capture01a19e31-a795-77cf-b820-b0a7f681de5b€9.00€0.19matched
101capture01a19e31-aa0b-7827-803c-99f88ee78def€24.00€0.37matched
102capture01a19e31-b346-721c-8c5b-ce5600266c89€49.00€0.67matched
103capture01a19e31-bccc-7cb1-a0e8-9215fc461c3a€15.00€0.26matched
104capture01a19e31-c599-7101-b02c-ffd2fbfb97d1€24.00€0.37matched
105capture01a19e31-c5f1-75ad-a82b-5c582f346d07€24.00€0.37matched
106capture01a19e31-f3cb-7db9-969c-162073d59ab1€9.00€0.19matched
107capture01a19e32-023d-77cf-a236-29c9ae9f664c€9.00€0.19matched
108capture01a19e32-28cd-7c3d-84aa-1f7f691d7266€9.00€0.19matched
109capture01a19e32-41d8-72e0-9719-a7275d01bae0€49.00€0.67matched
110capture01a19e32-4538-7cab-8d09-e6217d8b2db7€24.00€0.37matched
111capture01a19e32-49b3-78a6-b671-adaa77ef6502€49.00€0.67matched
112refund01a19e32-8f5e-7de5-9758-e7c379efa2e2-€39.00€0.00matched
113capture01a19e32-b93f-700e-8158-af8de57c9e0b€15.00€0.26matched
114capture01a19e32-c09c-732b-ba98-c205bbcb22c4€35.00€0.50matched
115capture01a19e32-c81a-7187-a097-a9e0ba8090ca€15.00€0.26matched
116capture01a19e33-17a4-728d-93bd-699a34a1f0bb€49.00€0.67matched
117capture01a19e33-4666-78c3-836d-f8e5c2f8d283€24.00€0.37matched
118capture01a19e33-535d-7886-b771-75d27559f2db€24.00€0.37matched
119capture01a19e33-623c-7bdd-ba88-00c4f5945881€15.00€0.26matched
120capture01a19e33-67a5-7ee4-bb46-18c695abb4f6€9.00€0.19matched
121capture01a19e33-6c9b-72d0-aa00-6165c3787aee€15.00€0.26matched
122capture01a19e33-b1f8-7a05-8f24-e0ef3ce4459f€9.00€0.19matched
123capture01a19e33-b682-7cb8-9297-d211922f58ce€9.00€0.19matched
124capture01a19e33-b958-7645-a5c0-03d78a522461€15.00€0.26matched
125capture01a19e33-be9c-78d3-93b6-bb7d259dbaa0€49.00€0.67matched
126capture01a19e34-02b4-7c35-ab31-1200961b6302€15.00€0.26matched
127capture01a19e34-0a30-7ee3-bd5b-a2100744b270€15.00€0.26matched
128capture01a19e34-0ce8-7cfb-9277-3474980bb8b3€24.00€0.37matched
129capture01a19e34-27c7-799c-91b2-4b4df28cec59€35.00€0.50matched
130capture01a19e34-54a4-70b4-bfa8-845371ba2d57€49.00€0.67matched
131capture01a19e34-5d23-739a-8061-4407efae61af€9.00€0.19matched