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

3 Nov, 18:30

Gross

€3,019.00

PSP fee

€47.20

Net to the bank

€2,971.80

Settlement journal

#365700

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1a2b5-8df3-74c0-b956-1356fb08ffaf is already settled by stl_EUR_2989551 line 111
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • missing linein the books, not in the filecapture:01a1a2b3-7c1a-790a-8493-1acc5b102834 is in no file
  • missing linein the books, not in the filecapture:01a1a2b4-76a2-7fb9-9ecf-a68a1e7087a1 is in no file
LineKindReferenceGrossFeeStatus
52capture01a1a2b1-092c-77d0-95ba-46f22b942a09€35.00€0.52fee difference
73capture01a1a2b2-fc09-7a1a-9ec4-bdbceaec4fe1€24.00€0.39fee difference
112capture01a1a2b5-8e25-73d2-85b3-9061365c3af4€35.00€0.50duplicate line
1capture01a1a2a5-105a-7334-bf2c-cdbbdf15ee1f€49.00€0.67matched
2capture01a1a2a9-ba6f-797f-a629-48d030796038€15.00€0.26matched
3capture01a1a2aa-3e77-779c-955c-10129d5228a9€9.00€0.19matched
4capture01a1a2ac-ee36-7a51-8579-f78dfd275cae€24.00€0.37matched
5capture01a1a2ad-220c-71fa-9c11-2c692aeda4f9€49.00€0.67matched
6capture01a1a2ad-31fb-7173-9672-1806a5fb142d€15.00€0.26matched
7capture01a1a2ad-37a0-7f17-bcb3-425fb8553d9c€15.00€0.26matched
8capture01a1a2ad-576e-789c-99e2-19728cac31a1€24.00€0.37matched
9capture01a1a2ad-6a4d-7036-9633-15c40bfbaa6e€35.00€0.50matched
10capture01a1a2ad-7dc2-7242-b53b-26dcd9272d0f€49.00€0.67matched
11capture01a1a2ad-9289-72ab-b14d-a3178f62a2b0€24.00€0.37matched
12capture01a1a2ad-9ccc-78c3-821c-2e5f50939671€15.00€0.26matched
13capture01a1a2ad-a890-7a95-99b7-2907b8faa434€35.00€0.50matched
14capture01a1a2ad-b678-7f01-821a-d923f69312c6€15.00€0.26matched
15refund01a1a2ad-bdba-7688-b067-07953fd56346-€17.00€0.00matched
16capture01a1a2ad-d7ae-78d8-a04c-61f8b861c6ae€35.00€0.50matched
17capture01a1a2ad-fc2f-7ea9-a1cb-e24c4afc7222€35.00€0.50matched
18refund01a1a2ae-19ef-75ef-aea9-45aad36a3768-€9.00€0.00matched
19capture01a1a2ae-2283-797b-aa0f-7d5a483dd0a5€24.00€0.37matched
20capture01a1a2ae-3139-7eb1-b712-0fddb0bd9fd1€49.00€0.67matched
21capture01a1a2ae-52ad-7045-8c5e-f630071e9ff7€49.00€0.67matched
22capture01a1a2ae-f8e1-79a0-ad5c-ebc488db8615€35.00€0.50matched
23capture01a1a2af-0557-7117-84a3-9b8180ccb640€9.00€0.19matched
24capture01a1a2af-069f-73bb-bf64-80a07f6d109d€15.00€0.26matched
25capture01a1a2af-1458-750b-94bc-755e46083fec€24.00€0.37matched
26capture01a1a2af-303c-7620-9dc9-be840b75382b€15.00€0.26matched
27capture01a1a2af-40c5-7937-b995-4e318448c930€15.00€0.26matched
28capture01a1a2af-4377-7297-8e67-47a269a3e0eb€15.00€0.26matched
29capture01a1a2af-629d-7eb3-8b7b-fe9e9cb7be18€49.00€0.67matched
30capture01a1a2af-6805-7fc4-a2d7-0ae320b443f1€49.00€0.67matched
31refund01a1a2af-922d-761b-950a-08d2b33ed592-€14.00€0.00matched
32capture01a1a2af-a420-7098-b892-eb3ae025d471€24.00€0.37matched
33capture01a1a2af-b2b0-738a-bd2c-c90d445511fc€49.00€0.67matched
34capture01a1a2af-b736-7879-bf89-7c22c0a6fb0f€35.00€0.50matched
35capture01a1a2af-deef-794c-b835-8d81d7dd4291€49.00€0.67matched
36capture01a1a2af-ed93-7dff-b526-461f0e984a47€35.00€0.50matched
37capture01a1a2af-fcc7-7b91-a30e-b09c98bfa565€49.00€0.67matched
38capture01a1a2b0-055b-7a77-9384-28f362dae4af€24.00€0.37matched
39capture01a1a2b0-1c2b-75f9-bf4b-f1d99539e041€35.00€0.50matched
40capture01a1a2b0-5215-7144-b43e-87e1f5a97e8c€24.00€0.37matched
41capture01a1a2b0-866a-7479-a38f-16b067c7d4f2€49.00€0.67matched
42capture01a1a2b0-92a0-754d-a8d7-cad2abc99bf6€49.00€0.67matched
43capture01a1a2b0-a033-7a53-9fed-4d0612bb530b€24.00€0.37matched
44capture01a1a2b0-ad60-7e6d-8f89-756d8a9e3a29€24.00€0.37matched
45capture01a1a2b0-be81-7346-b938-8f7f8b78d0c2€9.00€0.19matched
46capture01a1a2b0-e26f-71da-b028-ea1992a9b316€49.00€0.67matched
47capture01a1a2b0-ec81-76ed-8d2f-68d6736c724f€9.00€0.19matched
48capture01a1a2b0-edda-7c4a-ac4c-a0a3dfe1e033€49.00€0.67matched
49capture01a1a2b0-f9ef-7d02-a083-7b6db251fed1€35.00€0.50matched
50capture01a1a2b0-fc15-7c13-9924-c9f941919f7e€9.00€0.19matched
51capture01a1a2b1-04f9-77d1-91e1-0583d09809a1€24.00€0.37matched
53capture01a1a2b1-0b76-7163-8cee-eee3c46d8cca€49.00€0.67matched
54capture01a1a2b1-2d65-726a-b77b-45b0a5af1bf1€15.00€0.26matched
55capture01a1a2b1-45d5-7c74-8c23-abbb8e401c0a€35.00€0.50matched
56capture01a1a2b1-877a-7cb7-8f21-55206ff495cf€24.00€0.37matched
57capture01a1a2b1-b09d-750a-89d3-ff80c034f9ac€9.00€0.19matched
58capture01a1a2b1-bb3c-7e92-8e04-ccca904f1c6e€35.00€0.50matched
59capture01a1a2b1-c12b-7195-80b3-4c8b56792632€35.00€0.50matched
60capture01a1a2b1-cd22-7926-87e5-40d83fef6491€35.00€0.50matched
61capture01a1a2b1-cd3a-7374-a98a-91a813fa9a11€15.00€0.26matched
62capture01a1a2b1-e763-7a57-85f2-0b99ba667914€15.00€0.26matched
63capture01a1a2b2-38aa-72cd-a980-6d32b3bcc5c0€9.00€0.19matched
64capture01a1a2b2-4ba1-75ae-b4a2-3bf48df016dc€24.00€0.37matched
65capture01a1a2b2-68db-7f99-bda0-643b0412875b€15.00€0.26matched
66capture01a1a2b2-8768-75ee-b0c8-074bd10ee177€9.00€0.19matched
67capture01a1a2b2-8c67-79a8-b378-b654ab566712€35.00€0.50matched
68capture01a1a2b2-a1c3-7556-8eae-520bdc5deb1d€9.00€0.19matched
69capture01a1a2b2-a61e-724c-89df-534a417fba21€24.00€0.37matched
70capture01a1a2b2-aef2-7ddf-b9e4-897251dc61b9€24.00€0.37matched
71capture01a1a2b2-bc66-7c8b-bdcf-da38595099ed€24.00€0.37matched
72capture01a1a2b2-f306-718c-9c59-712165f8f96a€35.00€0.50matched
74capture01a1a2b3-0778-7a1e-ac86-ca2786048d5a€9.00€0.19matched
75refund01a1a2b3-3931-7fa7-83c3-05037eabad85-€3.00€0.00matched
76capture01a1a2b3-5bd6-70f4-a7e8-0ae5f813cd35€24.00€0.37matched
77capture01a1a2b3-6a6a-73df-adf5-e97c895a1b77€35.00€0.50matched
78capture01a1a2b3-77dd-746e-a163-e61f1ffe1ae1€24.00€0.37matched
79capture01a1a2b3-7bb0-73bd-b4d2-5367922877c4€35.00€0.50matched
80capture01a1a2b3-8bfd-767e-984c-7dc6826257ef€9.00€0.19matched
81capture01a1a2b3-901e-74ba-b27a-1a2eb58e75d5€35.00€0.50matched
82capture01a1a2b3-9bd9-7c11-9e93-6c7ad67df133€24.00€0.37matched
83capture01a1a2b3-9f8f-764c-b935-e1f728ef8974€35.00€0.50matched
84refund01a1a2b3-a2a1-7c85-b9fc-de6921afcc1c-€28.00€0.00matched
85capture01a1a2b3-a5d9-78a2-b817-b9545a068d19€24.00€0.37matched
86capture01a1a2b3-b3b9-709e-b4aa-5b1b0a63cb89€15.00€0.26matched
87refund01a1a2b3-f5e1-790e-8fed-12faf682d60d-€12.00€0.00matched
88capture01a1a2b4-0c5b-71d0-ae97-033bad5e75ad€49.00€0.67matched
89capture01a1a2b4-25da-7809-bc66-35536aec3f39€9.00€0.19matched
90capture01a1a2b4-441a-796d-b50e-f7ae9ee1060e€35.00€0.50matched
91capture01a1a2b4-47ea-7d31-bae6-4e1891742579€35.00€0.50matched
92capture01a1a2b4-5ab9-7d49-84ca-bb92c50eb134€35.00€0.50matched
93capture01a1a2b4-6f98-7056-9235-6b0d1bf81cf9€24.00€0.37matched
94capture01a1a2b4-8505-7ba7-9aff-3cf3193305ba€9.00€0.19matched
95capture01a1a2b4-99c8-70af-8491-f8295d509bbc€15.00€0.26matched
96capture01a1a2b4-a7a5-70df-ab11-1571980097f8€15.00€0.26matched
97capture01a1a2b4-a901-7d8f-8e9e-613908ae3349€35.00€0.50matched
98refund01a1a2b4-b2e2-735a-a12d-f659b62a4b19-€6.00€0.00matched
99capture01a1a2b4-c953-7ff2-8c2a-b66dea1e725e€49.00€0.67matched
100capture01a1a2b4-d5ca-713b-aebe-243b6acee7c3€49.00€0.67matched
101capture01a1a2b4-d76e-7813-877b-df5e6c6fae69€9.00€0.19matched
102capture01a1a2b4-e54f-745e-b12a-603723cda7c7€15.00€0.26matched
103capture01a1a2b4-fd90-7938-a150-29cb6db853b8€15.00€0.26matched
104capture01a1a2b5-0f59-70cd-922c-5dba608f221c€9.00€0.19matched
105capture01a1a2b5-1a87-7c55-a591-92c5408ea16c€49.00€0.67matched
106refund01a1a2b5-20cb-70ac-bb2f-0636a9053403-€32.00€0.00matched
107capture01a1a2b5-403a-77ff-8fad-e041f8c26707€35.00€0.50matched
108refund01a1a2b5-57ed-793f-81ac-b5b242ed7457-€33.00€0.00matched
109capture01a1a2b5-6b6b-72ca-9dba-ef5cc13189db€49.00€0.67matched
110capture01a1a2b5-7b45-71c5-8f4e-0c08a06831c4€35.00€0.50matched
111capture01a1a2b5-8e25-73d2-85b3-9061365c3af4€35.00€0.50matched
113capture01a1a2b5-9dc5-77e1-b1ad-d4a0cdd16f68€35.00€0.50matched
114capture01a1a2b5-acc8-7f1d-bcec-3cef3f662aed€24.00€0.37matched
115capture01a1a2b5-c10e-7143-bfa5-0f71e10066dc€49.00€0.67matched
116capture01a1a2b5-d552-7efc-8022-1d9895298780€15.00€0.26matched
117capture01a1a2b5-d68e-738a-9e6d-c8bfe1e033e8€49.00€0.67matched
118capture01a1a2b5-d703-794a-a2cb-13d6f224d0f8€35.00€0.50matched
119capture01a1a2b5-df99-720e-ab1e-6bcdfd34cd93€49.00€0.67matched
120capture01a1a2b5-e1e0-7d54-9bf9-aac10286a843€9.00€0.19matched
121capture01a1a2b6-0094-7674-863d-52807214b7b8€15.00€0.26matched