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

Gross

€2,675.00

PSP fee

€43.52

Net to the bank

€2,631.48

Settlement journal

#349214

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19e0c-1ba5-7308-b509-a80e79d81bc8 is already settled by stl_EUR_2989421 line 80
  • fee differencethe fee is not the contract feethe fee is 68, the contract says 67
  • fee differencethe fee is not the contract feethe fee is 72, the contract says 67
  • missing linein the books, not in the filecapture:01a19e09-a806-7299-bb0d-58d4eff07b54 is in no file
  • missing linein the books, not in the filecapture:01a19e0c-f746-786e-9414-6ada65a526c0 is in no file
LineKindReferenceGrossFeeStatus
76capture01a19e0b-e07b-78be-b281-9c4057c06ac9€49.00€0.68fee difference
79capture01a19e0c-1006-7c4d-828e-129405ba3805€49.00€0.72fee difference
81capture01a19e0c-1bd9-7543-88b4-0aa559193a8a€15.00€0.26duplicate line
1capture01a19e06-af3f-7f84-9092-29665b63ad82€9.00€0.19matched
2capture01a19e06-bd09-7fdf-b1df-f93ce6c03ab9€49.00€0.67matched
3capture01a19e06-f6b6-7f2e-b435-b57f51b0b93a€24.00€0.37matched
4capture01a19e07-06bb-7874-ad95-1ecf53cb0c4d€15.00€0.26matched
5capture01a19e07-1b73-7682-b891-9f8fb4c4559c€15.00€0.26matched
6capture01a19e07-263a-782e-8abf-2d26b121c275€9.00€0.19matched
7refund01a19e07-322c-7faa-a5da-5b2ef7505f58-€7.00€0.00matched
8capture01a19e07-4155-7e09-8828-f2fb4edbe7a5€24.00€0.37matched
9capture01a19e07-5476-74e6-93d5-af0873c07291€9.00€0.19matched
10capture01a19e07-6f0d-7e9c-82d5-8bd48775ff32€49.00€0.67matched
11capture01a19e07-7678-776c-8b93-759b21a5a5ea€9.00€0.19matched
12capture01a19e07-7ea9-705d-a831-f4cf43a35027€24.00€0.37matched
13capture01a19e07-81eb-71c0-ad3d-974c58d60a40€9.00€0.19matched
14capture01a19e07-b5a1-7d50-81eb-5909d96f3823€35.00€0.50matched
15capture01a19e07-c184-7719-a2b4-16887e0c7150€15.00€0.26matched
16capture01a19e07-ce34-7cd5-aa95-cd94dfdc74b2€24.00€0.37matched
17capture01a19e07-d26b-77c7-9056-99943238e131€24.00€0.37matched
18capture01a19e07-da4e-7132-baa0-1fc42c1dadd4€49.00€0.67matched
19capture01a19e07-e43f-7769-a919-b9b7a003e099€24.00€0.37matched
20refund01a19e07-fc42-7be1-8a0d-c3085baae4fb-€19.00€0.00matched
21capture01a19e08-0c85-758c-9bf9-ef1caee0c6e3€24.00€0.37matched
22capture01a19e08-29d1-7c93-9c8f-401eeb429a7f€15.00€0.26matched
23capture01a19e08-2d4e-7751-8808-86e07c64cb88€15.00€0.26matched
24capture01a19e08-3889-7373-8b9e-c0bce6aaecd6€9.00€0.19matched
25capture01a19e08-73c3-7c0f-bbd5-2e3ad04f51eb€35.00€0.50matched
26capture01a19e08-742c-753e-85e2-c7780bd8aa75€35.00€0.50matched
27capture01a19e08-9491-7f3f-93dc-a1d71b107255€35.00€0.50matched
28capture01a19e08-c870-7c22-bc8a-30de9a134c5a€35.00€0.50matched
29capture01a19e08-f6c9-7949-a3f2-9822d0b53562€15.00€0.26matched
30capture01a19e08-fc3a-7892-856a-ad098c9427c8€9.00€0.19matched
31capture01a19e09-05be-7bb7-9ae4-989c02b70383€49.00€0.67matched
32refund01a19e09-0668-7501-b5ff-dbbe0ffeeb52-€30.00€0.00matched
33capture01a19e09-0f56-7974-b5a5-0cfe59971938€35.00€0.50matched
34capture01a19e09-4a44-7ce4-9f66-530faa9103c6€24.00€0.37matched
35capture01a19e09-541d-75da-a06c-f0a311deed1c€24.00€0.37matched
36refund01a19e09-5935-7897-aa4c-295a303b56cf-€31.00€0.00matched
37capture01a19e09-5bd7-79f2-8e0c-2203c3022c22€24.00€0.37matched
38capture01a19e09-5fbe-759b-8b0c-2a0b6e85f91c€9.00€0.19matched
39capture01a19e09-6dbe-7270-9200-8d8191839ff8€24.00€0.37matched
40capture01a19e09-725b-73c2-b6d3-1811b5fbc185€15.00€0.26matched
41capture01a19e09-7a47-7333-ac9d-6e9e63535015€49.00€0.67matched
42capture01a19e09-96b4-77b6-85ad-aff52b23a560€49.00€0.67matched
43refund01a19e09-9dce-79e8-9913-4e5441bdb262-€23.00€0.00matched
44capture01a19e09-a2c7-73f0-b79f-d2cee872ac13€49.00€0.67matched
45capture01a19e09-b45b-74b9-bc4c-72306e8e1f21€24.00€0.37matched
46capture01a19e09-c3c0-71fa-a7d9-6f52eedc452c€9.00€0.19matched
47capture01a19e09-f04b-713b-a6a1-180e0b9c583a€49.00€0.67matched
48capture01a19e09-f223-71fd-8863-fd870efb6e8b€15.00€0.26matched
49capture01a19e09-f571-71a9-bbbc-c0dba56749d3€24.00€0.37matched
50capture01a19e09-f8fe-72a1-ab0c-6ffee929aa1f€24.00€0.37matched
51refund01a19e0a-1ecd-77ed-bc1c-ebb0d032af46-€18.00€0.00matched
52capture01a19e0a-5659-72d8-959f-69c111a725c9€49.00€0.67matched
53capture01a19e0a-57ba-7328-a0cf-b201dfc05908€9.00€0.19matched
54capture01a19e0a-60d2-7a9a-9e7b-ece4eb659b04€24.00€0.37matched
55capture01a19e0a-660f-7648-8954-146883380da5€24.00€0.37matched
56capture01a19e0a-82c0-76f2-bfb4-9d1aabd69b9b€9.00€0.19matched
57capture01a19e0a-9cfe-7085-805b-0b67f3bda079€9.00€0.19matched
58capture01a19e0a-aa40-7932-8461-11ea65d0aa1f€24.00€0.37matched
59capture01a19e0a-c17f-72a1-9571-71ef5d6477b4€24.00€0.37matched
60capture01a19e0a-d542-7874-a966-840c978626f3€24.00€0.37matched
61capture01a19e0a-e1ac-7fe4-8a32-6773658451ad€24.00€0.37matched
62capture01a19e0a-e233-7a75-a99c-0dd2c0aad758€35.00€0.50matched
63capture01a19e0a-efc3-73e8-a313-84019346288c€49.00€0.67matched
64capture01a19e0b-0b51-7437-b1f0-eae96d72e4ea€9.00€0.19matched
65capture01a19e0b-1004-79e4-b5fa-2fb4adcb9233€24.00€0.37matched
66capture01a19e0b-130b-7692-90e5-f750532ddf34€15.00€0.26matched
67capture01a19e0b-3826-7c6e-99cb-abc1dcb70b8f€9.00€0.19matched
68capture01a19e0b-4f1a-7d04-ba00-d938343d81ca€15.00€0.26matched
69capture01a19e0b-5d07-7569-94f9-6926c0b3edee€35.00€0.50matched
70capture01a19e0b-6901-7009-be57-165eecf67413€24.00€0.37matched
71capture01a19e0b-6a5e-79ca-8544-f6d9d55c6dd0€49.00€0.67matched
72capture01a19e0b-6b8c-71b1-9012-e65051dbc7d4€15.00€0.26matched
73capture01a19e0b-7db0-7417-b019-4ca470506436€9.00€0.19matched
74capture01a19e0b-b5ca-77f4-8385-05a230d53db6€24.00€0.37matched
75capture01a19e0b-bcee-7048-93e0-9f7992affd0b€9.00€0.19matched
77refund01a19e0b-e154-70dd-931c-af8e418d465c-€2.00€0.00matched
78capture01a19e0b-fbb7-7ecd-ae2e-fc53c094b751€49.00€0.67matched
80capture01a19e0c-1bd9-7543-88b4-0aa559193a8a€15.00€0.26matched
82capture01a19e0c-6f2c-7ec8-a85a-c8f89debcf4b€35.00€0.50matched
83capture01a19e0c-9ec2-74f9-a818-315abfef56f6€49.00€0.67matched
84capture01a19e0c-b6e5-727b-9b5a-ce11dd494c28€15.00€0.26matched
85capture01a19e0c-be01-7d96-a1b8-451d44bd76b8€15.00€0.26matched
86refund01a19e0c-e0ae-7c4a-a770-d23327c818b1-€11.00€0.00matched
87capture01a19e0c-f95b-7347-83b0-795623d73ea2€24.00€0.37matched
88capture01a19e0d-3242-7284-b1da-cb2adaa658ed€24.00€0.37matched
89refund01a19e0d-5c0f-7402-8517-0f614272afcc-€18.00€0.00matched
90capture01a19e0d-666c-7552-8edc-1fde1d641092€9.00€0.19matched
91capture01a19e0d-6f79-7951-9e6c-70d53dd7fe11€15.00€0.26matched
92capture01a19e0d-a905-74e9-b46f-ff8728fca5c7€49.00€0.67matched
93capture01a19e0d-e0cf-7ebc-bfe9-b7bec10817db€49.00€0.67matched
94capture01a19e0d-fc5d-792d-ad94-ce6b29291db8€35.00€0.50matched
95capture01a19e0e-0bc8-7873-9632-798eab5ae843€35.00€0.50matched
96capture01a19e0e-0bd2-7088-aed4-ea1ac05ad3bf€24.00€0.37matched
97capture01a19e0e-1095-7f6a-b50f-36c3b03d11c5€15.00€0.26matched
98capture01a19e0e-3687-7b5b-97ac-9d99f44df680€35.00€0.50matched
99capture01a19e0e-3720-76e3-b697-b061bcb08759€35.00€0.50matched
100capture01a19e0e-5215-7d72-8199-66324a7ffb88€15.00€0.26matched
101capture01a19e0e-6aee-7d77-8af7-e7a69fb9d7a0€9.00€0.19matched
102capture01a19e0e-748d-72b6-b034-a6c85ec8c5b4€15.00€0.26matched
103capture01a19e0e-9145-77c1-b4c8-da14c6ded96d€15.00€0.26matched
104capture01a19e0e-a0d0-7b70-8dea-0bb651d640c6€9.00€0.19matched
105capture01a19e0e-a801-744d-9263-757899296736€15.00€0.26matched
106capture01a19e0e-d787-7715-a3bc-90d8601e83a3€24.00€0.37matched
107capture01a19e0e-dc9d-7cfd-bcde-d38b9cfc6d49€24.00€0.37matched
108capture01a19e0f-0392-7ffa-9c57-0a1ca12c5d54€15.00€0.26matched
109capture01a19e0f-046a-713f-9bd1-bbce57df1e55€24.00€0.37matched
110capture01a19e0f-06dd-7592-b394-d6c9fcd365cb€9.00€0.19matched
111capture01a19e0f-0820-741d-b583-d36ea68ed8c7€49.00€0.67matched
112capture01a19e0f-0f0c-771c-9718-a63abb4e0b9d€49.00€0.67matched
113refund01a19e0f-2878-7632-8f4c-d2c7eb79c0f5-€22.00€0.00matched
114capture01a19e0f-365c-7814-9f03-c8190ded57ed€35.00€0.50matched
115capture01a19e0f-4b5d-7a4b-a030-53db4c8e6fd7€35.00€0.50matched
116capture01a19e0f-5625-753a-b3ef-09e7b5265e3d€35.00€0.50matched
117capture01a19e0f-59f1-77fd-b8b7-156a914e6b27€49.00€0.67matched
118capture01a19e0f-669c-726e-8471-171f638214e2€9.00€0.19matched
119capture01a19e0f-8a64-70ce-9b83-d36f0d4df815€9.00€0.19matched
120capture01a19e0f-964c-7245-bb58-5a70a1d6ab66€24.00€0.37matched
121capture01a19e0f-9e01-767c-b994-d931c02a5616€24.00€0.37matched
122capture01a19e0f-a864-74cb-a96b-b7670618adf7€9.00€0.19matched
123capture01a19e0f-cf3f-76da-a33f-d14afe985134€35.00€0.50matched