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

Gross

€3,216.00

PSP fee

€50.78

Net to the bank

€3,165.22

Settlement journal

#334000

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a199c4-b4ae-7da8-9fb6-e86c0dd68f27 is already settled by stl_EUR_2989301 line 125
  • fee differencethe fee is not the contract feethe fee is 3, the contract says 0
  • fee differencethe fee is not the contract feethe fee is 69, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 2, the contract says 0
  • missing linein the books, not in the filecapture:01a199bd-6f66-7aae-adce-9c4bb9dc2409 is in no file
  • missing linein the books, not in the filecapture:01a199c2-ea9e-70d1-bf42-43070a5a66ee is in no file
LineKindReferenceGrossFeeStatus
56refund01a199bf-a393-7362-b64a-3359b3623711-€19.00€0.03fee difference
73capture01a199c0-a895-7ab7-907a-c39ffe4f9ad1€49.00€0.69fee difference
106refund01a199c3-8283-7fb9-bee8-6dab59ca9af8-€30.00€0.02fee difference
126capture01a199c4-b4e5-77a8-a81a-5f30affe342a€24.00€0.37duplicate line
1capture01a199b8-62f3-7e09-8d28-d81a23a3ae32€15.00€0.26matched
2capture01a199b9-5f13-7fb1-b7f4-415b9dea81ba€49.00€0.67matched
3capture01a199bc-11f1-7e85-9c04-e28b29e68f7b€9.00€0.19matched
4capture01a199bc-2437-79aa-ab53-7521bbe73eb3€49.00€0.67matched
5capture01a199bc-3d69-704f-89d5-6395208932c3€9.00€0.19matched
6capture01a199bc-4d3b-7891-a65b-fb6fb9ca8102€35.00€0.50matched
7capture01a199bc-4a04-728f-8cfc-039ccc57d9ad€49.00€0.67matched
8capture01a199bc-619d-7953-9b4e-710337d80468€24.00€0.37matched
9capture01a199bc-912e-72b2-b17f-1c4e6bda20ab€35.00€0.50matched
10capture01a199bc-92ff-7410-914f-144e59b9d5f8€49.00€0.67matched
11refund01a199bc-a7f9-7ebe-8e68-cd747cdf3174-€8.00€0.00matched
12capture01a199bc-bdb9-7f9c-b3a1-5f87b9719706€49.00€0.67matched
13capture01a199bc-c0c9-7f2b-bbce-aea6738f601e€15.00€0.26matched
14capture01a199bc-f449-758a-a8f1-e384875a7ed7€35.00€0.50matched
15capture01a199bc-f55b-7639-afab-9367315fa90b€15.00€0.26matched
16capture01a199bd-0d57-7627-8a25-a1721001b5f0€9.00€0.19matched
17capture01a199bd-23ab-7e5f-bbd3-0a6d1329f313€15.00€0.26matched
18capture01a199bd-6100-7006-8efb-019958dc56f7€9.00€0.19matched
19capture01a199bd-a417-72f2-911b-87b1dec6f828€49.00€0.67matched
20capture01a199bd-becf-7f3e-b186-03f0e4b3ee89€24.00€0.37matched
21refund01a199bd-c0b8-7ab4-afaf-a919943c126d-€8.00€0.00matched
22capture01a199bd-d9ca-7fec-94cd-c487405b1f23€24.00€0.37matched
23capture01a199bd-e5dd-7085-85cb-87de68342571€15.00€0.26matched
24capture01a199be-06db-7fed-98b5-b17925306c3f€24.00€0.37matched
25capture01a199be-0afe-7156-96ba-249d563f5797€49.00€0.67matched
26capture01a199be-0d96-7a42-9b06-fef2980b4790€9.00€0.19matched
27capture01a199be-304a-7fb1-b6d2-063fe9d513f0€49.00€0.67matched
28capture01a199be-3353-7ab8-81d5-1f3f7787a1eb€9.00€0.19matched
29capture01a199be-341d-75ee-9bea-714ca7d04396€24.00€0.37matched
30capture01a199be-34c0-7518-91fa-76934992f048€49.00€0.67matched
31capture01a199be-3ffc-7309-ad87-26bcb6217ab7€24.00€0.37matched
32capture01a199be-6936-7271-9125-6a045aebff26€9.00€0.19matched
33capture01a199be-6fa7-79a2-8891-996cc5f30e1c€9.00€0.19matched
34capture01a199be-892d-75f5-aa48-eb4ced2e75be€35.00€0.50matched
35capture01a199be-89f2-79d9-87ee-a6d3430fde65€35.00€0.50matched
36capture01a199be-9d76-7c54-8265-41f6684ad200€49.00€0.67matched
37capture01a199be-ace4-7117-956a-ade6e846f0b8€24.00€0.37matched
38capture01a199be-d829-7787-88ac-3e5173b053ac€9.00€0.19matched
39capture01a199be-db46-7ff7-81f6-0cff61cab248€15.00€0.26matched
40capture01a199be-e1eb-7a49-a6f5-eeac49714379€15.00€0.26matched
41capture01a199be-f055-7d37-b24f-121934af6ddc€24.00€0.37matched
42capture01a199bf-096b-7480-b574-fdf397576e1d€24.00€0.37matched
43capture01a199bf-2d02-77f1-bb39-917fe88c1d30€24.00€0.37matched
44capture01a199bf-4358-7b8e-9eda-e2153c9f9da7€15.00€0.26matched
45capture01a199bf-45f3-7917-9d31-e8d55acdda23€15.00€0.26matched
46capture01a199bf-4f15-7b62-b4c1-e04c64fe7c7d€35.00€0.50matched
47capture01a199bf-53fd-7680-acb0-da44ca186471€35.00€0.50matched
48capture01a199bf-61b7-794b-9e3e-16cbfff8ab17€35.00€0.50matched
49capture01a199bf-67bd-7bb7-9aa8-1b0b997f38aa€24.00€0.37matched
50capture01a199bf-745b-7c16-b9f8-e56beb7ba19d€9.00€0.19matched
51capture01a199bf-77c2-75e4-be15-b191c801dfe7€24.00€0.37matched
52capture01a199bf-8bb8-74ea-be69-157dca10121d€15.00€0.26matched
53capture01a199bf-8edd-7414-9db3-6c5fa257cd20€15.00€0.26matched
54capture01a199bf-99e5-7a7a-a409-45b2f56189e3€35.00€0.50matched
55capture01a199bf-9c5d-725d-9098-4e6de02a8036€15.00€0.26matched
57capture01a199bf-a665-7d18-8b79-c1b99ebcc1e4€49.00€0.67matched
58capture01a199bf-d0d1-7a5c-8b9d-6722bea708cb€9.00€0.19matched
59capture01a199bf-d53b-7640-9b43-b892916d887b€35.00€0.50matched
60refund01a199bf-d627-70e3-9312-6482f6a5ddf7-€41.00€0.00matched
61capture01a199c0-4815-7440-80a5-91d1ce1c296b€15.00€0.26matched
62capture01a199c0-4898-749f-9421-0bf0134e6bbc€49.00€0.67matched
63capture01a199c0-4f5a-7ddc-b9c7-037b29360a4d€9.00€0.19matched
64capture01a199c0-5e9f-7c5f-beef-34c9a000d6da€49.00€0.67matched
65capture01a199c0-674f-7bc2-a421-c2535d58dd42€35.00€0.50matched
66capture01a199c0-6767-777c-856f-2b7a8399bc8c€24.00€0.37matched
67capture01a199c0-6d65-7eff-983e-a8cbff0409f5€35.00€0.50matched
68capture01a199c0-7005-78b3-b6e4-919174dcee04€24.00€0.37matched
69capture01a199c0-7006-778d-9e40-349c7889acc5€24.00€0.37matched
70capture01a199c0-803a-7aab-ac59-77bf63eebd62€9.00€0.19matched
71capture01a199c0-83e6-7252-8f56-85eec5d6c959€24.00€0.37matched
72capture01a199c0-9270-704e-a523-3f8344f220eb€15.00€0.26matched
74refund01a199c0-aee0-7297-86a1-e697783d549a-€14.00€0.00matched
75capture01a199c0-ba09-7336-9c93-1c739184f361€49.00€0.67matched
76capture01a199c0-bb2f-7c21-a17c-4cce4b4aa7a8€15.00€0.26matched
77capture01a199c0-e563-7125-a49a-196d16af78d9€24.00€0.37matched
78capture01a199c0-f588-760d-8575-e9d251c9ed6c€35.00€0.50matched
79capture01a199c1-0a9c-794b-8360-768b2404fb21€15.00€0.26matched
80capture01a199c1-1f99-783d-b92a-1a2fdd7c1ce3€24.00€0.37matched
81capture01a199c1-2414-7215-a44c-cfcabb21f6ad€24.00€0.37matched
82capture01a199c1-3f98-773d-9ca9-66ec4bb88844€9.00€0.19matched
83capture01a199c1-4e3e-7f87-80bb-0124c0650516€24.00€0.37matched
84capture01a199c1-a7ff-7555-ab2c-ec9e651e5cef€15.00€0.26matched
85capture01a199c1-ae50-7378-8458-da1edd6d5f56€49.00€0.67matched
86capture01a199c1-b34a-700e-bb44-50b90135aba4€9.00€0.19matched
87capture01a199c1-c5ad-7e7c-9661-8534c15ff512€49.00€0.67matched
88capture01a199c1-c9a5-726e-9959-11de5fc5b7d7€35.00€0.50matched
89capture01a199c1-cfef-75b2-8cc2-204f89aaa716€15.00€0.26matched
90capture01a199c1-dc5a-7e4d-9e03-efcaea5f3b91€35.00€0.50matched
91capture01a199c1-fd70-7340-95d3-b76b0f7624a3€49.00€0.67matched
92capture01a199c2-2b57-7e84-b793-935aa213bcb3€9.00€0.19matched
93refund01a199c2-2f72-72c0-bc6b-eacc5b7b97c8-€20.00€0.00matched
94capture01a199c2-50d1-725c-8510-216dcba72e75€35.00€0.50matched
95capture01a199c2-6173-7b94-af06-f718b5635450€35.00€0.50matched
96capture01a199c2-7abc-7277-b3d8-e13f2f4a312d€24.00€0.37matched
97capture01a199c2-8279-7947-b944-8e5608339a70€35.00€0.50matched
98capture01a199c2-877d-7fa3-a860-27ea1e143ba7€49.00€0.67matched
99capture01a199c2-8d96-73c5-8160-201bdd9b3afe€15.00€0.26matched
100capture01a199c2-8e1b-7026-957b-038bbb5a4193€49.00€0.67matched
101capture01a199c2-acb0-77db-9853-2329a9da8660€15.00€0.26matched
102capture01a199c3-1424-7773-af68-e48f12c52e64€35.00€0.50matched
103capture01a199c3-2c4d-79b5-bb85-f3cac13559f9€35.00€0.50matched
104capture01a199c3-4e4b-786c-ac1d-09ad60de42ee€24.00€0.37matched
105capture01a199c3-6fc4-7d84-9545-f52cd1478427€9.00€0.19matched
107capture01a199c3-894d-79f8-b708-a95ba4168f46€15.00€0.26matched
108capture01a199c3-8cf6-780b-8f7c-4eed0cd50ec3€15.00€0.26matched
109capture01a199c3-943d-7793-863e-6a3981623b90€24.00€0.37matched
110capture01a199c3-a7a4-778a-93d9-cdc43a05a8fd€24.00€0.37matched
111capture01a199c3-aad5-794f-b17a-50baa21a5e52€15.00€0.26matched
112refund01a199c3-b74e-75a4-81a3-d7744a7adae3-€4.00€0.00matched
113capture01a199c3-bae0-7e7d-971d-0329575da5bd€15.00€0.26matched
114capture01a199c3-d491-7334-9588-efeb88233661€49.00€0.67matched
115capture01a199c3-d97c-7ea3-8c9b-d6b442fe61c9€15.00€0.26matched
116capture01a199c4-03aa-76c1-a1dd-157246a103ef€9.00€0.19matched
117capture01a199c4-0ba4-7741-9113-d1f0f56331c6€9.00€0.19matched
118capture01a199c4-14a5-7c73-b443-7af295f9684a€24.00€0.37matched
119capture01a199c4-248d-764a-ba33-d4026bd95e9d€49.00€0.67matched
120capture01a199c4-52d0-7ec2-b4ad-e8783bc24e9d€35.00€0.50matched
121capture01a199c4-6631-70e8-be51-76ba3f4500dc€15.00€0.26matched
122capture01a199c4-6c38-7e81-98fb-f663e3e858a3€9.00€0.19matched
123capture01a199c4-7c1e-706c-bdae-fcdec0a1c5d1€15.00€0.26matched
124capture01a199c4-880c-7e83-b64a-d64bd50a24f9€35.00€0.50matched
125capture01a199c4-b4e5-77a8-a81a-5f30affe342a€24.00€0.37matched
127capture01a199c4-bef4-73f6-ac1f-994297404444€9.00€0.19matched
128capture01a199c4-c9cb-7918-a2ec-fa27aa7718aa€35.00€0.50matched
129capture01a199c4-ce2d-74c9-b0fa-4307a8095086€15.00€0.26matched
130capture01a199c4-e1c0-7f1e-b945-896a058a8367€24.00€0.37matched
131capture01a199c4-f027-78f1-bef6-1a88c1bd9986€49.00€0.67matched
132capture01a199c4-f6eb-7114-9227-8483b90a1117€24.00€0.37matched
133capture01a199c4-fecf-7f1c-8401-d6b184dcf066€35.00€0.50matched
134capture01a199c5-0acc-7945-a95f-dfbe8f0f150a€15.00€0.26matched
135capture01a199c5-0c02-7346-bdb9-2fd4aa9364e9€24.00€0.37matched
136capture01a199c5-0edc-7e08-bd6a-e948e51f8ef2€49.00€0.67matched