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

4 Nov, 02:40

Gross

€2,720.00

PSP fee

€43.42

Net to the bank

€2,676.58

Settlement journal

#371891

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a46f-4f25-7444-b0df-8b28d42ffd53 is already settled by stl_EUR_2989600 line 31
LineKindReferenceGrossFeeStatus
32capture01a1a46f-4fc6-72ca-9fa3-042d1cdf6d72€35.00€0.50duplicate line
1capture01a1a464-9dfb-7444-8e09-418d2ff9a9fb€15.00€0.26matched
2capture01a1a469-d7dc-7f84-aeb2-3de4e1c525db€15.00€0.26matched
3capture01a1a46c-b860-7cb7-b2dd-24be7569c157€35.00€0.50matched
4capture01a1a46d-4962-729f-a0fb-6a2ccb379aeb€49.00€0.67matched
5refund01a1a46d-9a42-7345-80b9-5dbbe7e8917c-€4.00€0.00matched
6capture01a1a46d-a57f-77a5-8b34-6efd04a6aa7f€15.00€0.26matched
7capture01a1a46d-f955-764c-938c-b56bb5e9aebf€35.00€0.50matched
8capture01a1a46d-fce9-7711-bb07-eafe7280bc76€35.00€0.50matched
9capture01a1a46e-1130-7345-be14-a00e807a672c€49.00€0.67matched
10capture01a1a46e-17eb-73b8-ad55-bbd149c8d9c1€35.00€0.50matched
11capture01a1a46e-2d13-715e-809f-dfa45b558b4f€35.00€0.50matched
12capture01a1a46e-516a-7a65-84ae-b4cb675ae503€24.00€0.37matched
13refund01a1a46e-6a1b-7870-9b89-cc0cc4434e94-€22.00€0.00matched
14capture01a1a46e-75f5-73de-acd8-d6454b8b8f2d€9.00€0.19matched
15capture01a1a46e-8961-783b-a1db-ec2948fdd656€15.00€0.26matched
16capture01a1a46e-8c9d-7d33-8412-ed09e1405258€9.00€0.19matched
17capture01a1a46e-8ec3-7d45-9d10-2dc0f400e07b€15.00€0.26matched
18capture01a1a46e-8f22-7515-850a-8e4ce8ea71e2€24.00€0.37matched
19capture01a1a46e-9f56-79f8-a5e4-66f8f1c72cad€9.00€0.19matched
20capture01a1a46e-a04f-741c-834b-3819f1d9f0be€9.00€0.19matched
21capture01a1a46e-a3b9-715d-9165-192cd69203d4€15.00€0.26matched
22capture01a1a46e-a9fe-72f8-b83f-f3a9a20a09b2€49.00€0.67matched
23capture01a1a46e-ad68-7320-96fd-2bdc80f6cdcb€35.00€0.50matched
24capture01a1a46e-bf9a-771e-b0d0-6d3b7531bd85€35.00€0.50matched
25capture01a1a46e-af7c-74d6-8243-18fc02f505b1€35.00€0.50matched
26capture01a1a46e-e9a4-7c3e-99d1-870c99406008€49.00€0.67matched
27refund01a1a46e-eef9-78f6-aa56-371799504e89-€8.00€0.00matched
28capture01a1a46e-fb0d-7c35-9b6b-f1b13b10b010€24.00€0.37matched
29capture01a1a46f-1058-7518-a359-b0a035c93987€24.00€0.37matched
30capture01a1a46f-46f3-725b-95e9-270e58275ad5€9.00€0.19matched
31capture01a1a46f-4fc6-72ca-9fa3-042d1cdf6d72€35.00€0.50matched
33capture01a1a46f-55bb-7763-bb19-ab5326c2f491€9.00€0.19matched
34capture01a1a46f-5fb9-79df-b0f2-f76672e7ae54€35.00€0.50matched
35refund01a1a46f-a59d-749d-8196-cca1461e7835-€22.00€0.00matched
36capture01a1a46f-ae28-73b3-ae74-b93f95f14354€9.00€0.19matched
37capture01a1a46f-bc19-7e39-929d-8c7761fc1818€49.00€0.67matched
38capture01a1a46f-c00b-7ca2-844f-2a17fd08e1b7€49.00€0.67matched
39capture01a1a46f-d608-71a4-bf51-999b7b482be8€9.00€0.19matched
40capture01a1a470-0eca-7cb8-8aac-f4785bac807e€9.00€0.19matched
41capture01a1a470-63c5-714a-a75b-4c68ca45c684€24.00€0.37matched
42capture01a1a470-7726-7da9-aba5-5c0f0c503e5b€35.00€0.50matched
43capture01a1a470-8711-7b9f-bf44-043bcf580fb3€15.00€0.26matched
44capture01a1a470-9e54-792a-bf0f-ef18ffe3c268€15.00€0.26matched
45capture01a1a470-a431-7a8b-a319-21e78d765d9e€15.00€0.26matched
46capture01a1a470-b4eb-7398-bc80-81dff81d2ba0€24.00€0.37matched
47capture01a1a470-bd4e-7bb1-b020-73468146d234€9.00€0.19matched
48capture01a1a470-be4f-7b58-817c-56437038869e€35.00€0.50matched
49capture01a1a470-c892-78c7-93b8-d9b1e2963f19€24.00€0.37matched
50capture01a1a470-d05e-7e49-9a6d-36aae904da71€35.00€0.50matched
51capture01a1a470-d49d-7e9f-add0-939b400200a9€9.00€0.19matched
52capture01a1a470-fe6d-7029-a7e7-eee935aabf11€35.00€0.50matched
53capture01a1a471-027a-713e-8db9-92ee02cea0bc€9.00€0.19matched
54capture01a1a471-0a98-7f91-8d04-0b9e40e75cf3€15.00€0.26matched
55capture01a1a471-13c3-7982-b66b-b1746905eebf€49.00€0.67matched
56capture01a1a471-186c-7a5e-b4ea-553c37e40ad9€35.00€0.50matched
57capture01a1a471-40fe-70e8-9e5f-e0225a95a5f0€35.00€0.50matched
58capture01a1a471-58e7-710d-966e-859679f1bd7f€24.00€0.37matched
59capture01a1a471-5b34-79a4-8d90-b4fbb5280b61€15.00€0.26matched
60capture01a1a471-6be8-76c8-9262-cfc656bf0dab€24.00€0.37matched
61capture01a1a471-a2ae-7ef1-bcaf-6e754aca674e€35.00€0.50matched
62capture01a1a471-a991-74e9-a9ef-1c70156f4b1d€9.00€0.19matched
63capture01a1a471-bfe0-7b14-a413-6d810dccf7be€49.00€0.67matched
64capture01a1a471-c88d-7044-85c3-30c2efcdf3f7€15.00€0.26matched
65capture01a1a471-ddfc-7e15-aba6-36dfb96775ac€49.00€0.67matched
66capture01a1a471-fbe7-799d-8145-b020b5ffbcdf€9.00€0.19matched
67capture01a1a472-218b-7f54-bdde-e2681440851d€9.00€0.19matched
68capture01a1a472-59df-7f69-8dfd-4d8933951fa9€9.00€0.19matched
69capture01a1a472-5ea7-7176-9862-1de8da3234e3€15.00€0.26matched
70capture01a1a472-5fd4-763c-80f8-4fdb731c8233€24.00€0.37matched
71capture01a1a472-9056-75b3-afa4-5facac5a6c29€35.00€0.50matched
72capture01a1a472-a9ba-78d6-85c2-573b23d4e35d€49.00€0.67matched
73capture01a1a472-c46f-7fb0-aed6-be1fb879510c€35.00€0.50matched
74capture01a1a472-cc1d-7f00-bd46-859ef42f6f21€15.00€0.26matched
75capture01a1a472-d43b-766d-bc1f-f8329ca92b79€9.00€0.19matched
76capture01a1a472-d82a-76ca-80ad-40eddb4d4978€24.00€0.37matched
77refund01a1a472-dfab-7ef6-9668-95719a0fc40f-€32.00€0.00matched
78capture01a1a472-f6b2-75eb-bb0c-792a134cdaa3€49.00€0.67matched
79capture01a1a472-f7fe-71ae-8c55-026374485141€24.00€0.37matched
80capture01a1a473-21b1-7a80-b076-43b7eaed39c0€35.00€0.50matched
81capture01a1a473-2647-7077-a0ea-ec217b87c628€15.00€0.26matched
82refund01a1a473-2700-76bb-998a-b6c557854218-€9.00€0.00matched
83capture01a1a473-5f2b-7f0b-b50f-5618743d67ef€49.00€0.67matched
84capture01a1a473-6a96-7978-ba8b-502314762b5a€35.00€0.50matched
85capture01a1a473-793d-7ef9-b2a5-3aeb41cc9355€24.00€0.37matched
86capture01a1a473-859b-78e9-8f8a-8e5b0a9ad0c6€49.00€0.67matched
87capture01a1a473-8634-71d7-9640-d09bbaa38411€15.00€0.26matched
88capture01a1a473-aad7-7007-a8f2-18f3450c21d0€35.00€0.50matched
89capture01a1a473-c961-702c-acb5-d44efa56c139€9.00€0.19matched
90capture01a1a473-d12f-7106-8bf6-2f202e617ab3€9.00€0.19matched
91capture01a1a473-da21-7691-9816-377cbe129063€15.00€0.26matched
92capture01a1a473-e60b-7436-99ea-2bf79162bd35€24.00€0.37matched
93capture01a1a474-1125-77c0-a029-edd180240e95€15.00€0.26matched
94capture01a1a474-1e72-70f1-9ea2-3fe0bab9350f€24.00€0.37matched
95capture01a1a474-47df-727f-8248-99531c964e13€15.00€0.26matched
96capture01a1a474-4eed-755a-bf91-da220eaa950a€24.00€0.37matched
97capture01a1a474-6d08-7153-8edf-b2ded8c5fd83€24.00€0.37matched
98capture01a1a474-7d4e-7185-b3cd-12aa044d7988€9.00€0.19matched
99capture01a1a474-7ed9-7b6c-a36b-ff6deba67ea0€24.00€0.37matched
100capture01a1a474-7b12-7695-b8cd-d051228c474c€9.00€0.19matched
101capture01a1a474-92b9-7d34-bfef-4903445934cd€9.00€0.19matched
102capture01a1a474-97cb-7686-af62-97297ae03573€49.00€0.67matched
103capture01a1a474-ab53-7b8b-a307-1e514cbf5fe9€24.00€0.37matched
104capture01a1a474-db09-7837-a91f-f8038fce96a8€49.00€0.67matched
105capture01a1a474-f316-7498-8296-bbe4312cc165€15.00€0.26matched
106capture01a1a474-fe81-7df1-b8d3-bac153145d9c€49.00€0.67matched
107capture01a1a475-06b6-77ef-9439-f3740e65ac5d€24.00€0.37matched
108capture01a1a475-0f84-7e2f-bed0-97bf0bef9043€15.00€0.26matched
109capture01a1a475-23ec-7ed2-915b-3d51511f64c6€49.00€0.67matched
110capture01a1a475-b2a6-7a7b-9845-04fd270a1788€9.00€0.19matched
111capture01a1a476-0430-7cd2-8666-dcb4cdb26330€35.00€0.50matched
112capture01a1a476-3012-7eaa-b5d6-beedd9884a1c€24.00€0.37matched
113capture01a1a476-4abd-7c1c-8240-471e39a9b4b3€9.00€0.19matched
114capture01a1a476-5917-748a-8ce3-ddbb2edde827€9.00€0.19matched
115capture01a1a476-5ebc-741c-ac4b-9bd92466be55€9.00€0.19matched
116refund01a1a476-73b1-7935-915b-8f6e1ce76bd5-€30.00€0.00matched
117capture01a1a476-8395-7ddf-b68b-b5001da4e8a8€24.00€0.37matched
118capture01a1a476-96d9-7bb4-8786-daff4b26fe96€49.00€0.67matched
119capture01a1a476-97eb-7561-b166-797773379c0b€9.00€0.19matched
120capture01a1a476-997b-77ac-8d6e-f3815294e33d€15.00€0.26matched
121capture01a1a476-9a6c-7426-aa2b-ed4fc9268f9d€24.00€0.37matched