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, 16:10

Gross

€2,612.00

PSP fee

€40.64

Net to the bank

€2,571.36

Settlement journal

#345601

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19d0c-122c-7ee4-a741-a70e0130e707 is already settled by stl_EUR_2989393 line 68
  • missing linein the books, not in the filecapture:01a19d0e-db29-77b9-aa81-d65f1b7e8c05 is in no file
LineKindReferenceGrossFeeStatus
69capture01a19d0c-1352-74fa-9547-49705c80749b€24.00€0.37duplicate line
1capture01a19cfe-281e-7ff9-a85c-e805013e7d72€49.00€0.67matched
2capture01a19d03-0ee1-7864-b467-7f8ae4d80b79€24.00€0.37matched
3capture01a19d05-765b-723d-8ae9-23d8cb190d57€24.00€0.37matched
4capture01a19d06-5fb9-7783-841d-6f9c4d04494a€24.00€0.37matched
5capture01a19d06-6e0d-70d7-bf7f-f688b0e5ee84€35.00€0.50matched
6capture01a19d06-7700-7091-a5e0-b76cc576d519€35.00€0.50matched
7capture01a19d06-91d4-7174-a0bb-17e02a09f2f6€49.00€0.67matched
8capture01a19d06-b06e-74ec-abee-62dee67eb53f€9.00€0.19matched
9capture01a19d06-b7fc-7a7c-8fb6-f345216b4316€24.00€0.37matched
10refund01a19d06-b88a-7f63-91bb-b4db981988c6-€24.00€0.00matched
11capture01a19d06-e3e4-7523-8228-816fdecdbcdf€24.00€0.37matched
12capture01a19d06-e66d-7069-ba99-343594eae8a7€15.00€0.26matched
13capture01a19d06-f28d-73c6-8bbc-9c8c0d1526ac€9.00€0.19matched
14capture01a19d06-f651-7ee9-8089-763003a69964€49.00€0.67matched
15capture01a19d07-03fc-73b3-954d-a689d57374d2€35.00€0.50matched
16capture01a19d07-2458-7528-81f5-90d74e19a9cf€15.00€0.26matched
17capture01a19d07-42f5-7bcc-8e57-beb7fd1427d5€49.00€0.67matched
18refund01a19d07-54e0-77ea-a6ef-668efef816c0-€6.00€0.00matched
19capture01a19d07-67bd-7cc7-9940-1b0ad13b2a85€15.00€0.26matched
20capture01a19d07-c69a-76e2-adad-bea527caf4b9€49.00€0.67matched
21capture01a19d07-d384-7651-b8a6-e419b7eb80f5€35.00€0.50matched
22capture01a19d07-d9af-7dc9-a178-4a76179bc65c€49.00€0.67matched
23capture01a19d07-fe5c-721f-a91d-8233d7dacde2€35.00€0.50matched
24capture01a19d08-6aaa-701a-a363-b1cb02c8c206€9.00€0.19matched
25capture01a19d08-7be0-76d6-a31f-c214d4df41fa€9.00€0.19matched
26capture01a19d08-8687-71e3-90a6-a50b73bd82ac€24.00€0.37matched
27capture01a19d08-93df-714e-9b37-ddd0f8908547€35.00€0.50matched
28capture01a19d08-c527-70a4-b1f0-5f44c9983322€24.00€0.37matched
29capture01a19d08-d5ae-7824-b40f-0980d5d536ca€49.00€0.67matched
30capture01a19d08-de00-74b4-9a78-77e5a7501231€35.00€0.50matched
31capture01a19d08-e2aa-7135-aa3b-620899e701ae€35.00€0.50matched
32capture01a19d08-ed15-71d4-ab8b-bd5d30e643b8€9.00€0.19matched
33capture01a19d08-fd87-7206-ab69-34db6b74ae78€24.00€0.37matched
34capture01a19d09-2ba6-7968-8bac-e3469210f3ac€15.00€0.26matched
35capture01a19d09-2fa5-745c-b5a7-3d0d2b1df5fb€9.00€0.19matched
36capture01a19d09-3427-7916-a9c8-39a3b2cee861€9.00€0.19matched
37capture01a19d09-4b9d-7c80-842a-5559a76da2bb€49.00€0.67matched
38capture01a19d09-5879-7935-8531-c5db3b676dcb€24.00€0.37matched
39capture01a19d09-671a-7a79-ae4c-588468fca302€24.00€0.37matched
40capture01a19d09-b96d-711e-9b27-e95d0729dbc9€49.00€0.67matched
41capture01a19d09-cc90-768a-a4ad-93fc9ee0f2f0€9.00€0.19matched
42capture01a19d09-dc11-7db0-872e-09609c5af99b€9.00€0.19matched
43capture01a19d09-e396-7aa8-8c4e-29984f044837€9.00€0.19matched
44capture01a19d09-e363-7e37-a23b-61c2efa7bb25€9.00€0.19matched
45capture01a19d09-f4b3-7651-896e-0c87eb94a42a€49.00€0.67matched
46capture01a19d0a-3e92-7190-9994-4d3729e8454b€15.00€0.26matched
47capture01a19d0a-431d-7ca7-a48d-933af2aec4fc€24.00€0.37matched
48capture01a19d0a-8fa2-78b8-88d5-3f3cf4cc603c€15.00€0.26matched
49capture01a19d0a-98a1-75a8-8fc2-4a5132abf18e€9.00€0.19matched
50capture01a19d0a-b78b-7d20-9d4a-abeb56262309€15.00€0.26matched
51capture01a19d0a-dfdb-71e9-8e49-d65109ad0fc0€24.00€0.37matched
52capture01a19d0a-fbad-72b2-8144-58c40162e7bb€35.00€0.50matched
53capture01a19d0a-fc1e-74ae-a792-10620fbb463c€35.00€0.50matched
54capture01a19d0b-08a8-72f8-8fc2-6c777c8684fb€49.00€0.67matched
55capture01a19d0b-2048-754a-a1c0-709193f3526c€15.00€0.26matched
56capture01a19d0b-305f-77c6-b500-fc32209754af€24.00€0.37matched
57capture01a19d0b-3a69-70b7-b7ed-276d1eead67f€9.00€0.19matched
58capture01a19d0b-3fa9-796c-870c-15608239f27a€24.00€0.37matched
59capture01a19d0b-42e3-7608-9791-be68d04a66b4€9.00€0.19matched
60capture01a19d0b-6061-78db-b871-3652327b72fb€15.00€0.26matched
61refund01a19d0b-6bb8-75bb-b441-823ba755b943-€5.00€0.00matched
62capture01a19d0b-aee4-7677-b560-420bff61c601€35.00€0.50matched
63capture01a19d0b-b102-79be-9807-50d4849050db€24.00€0.37matched
64capture01a19d0b-b48d-7e94-a044-ba43dc8fbd5f€15.00€0.26matched
65capture01a19d0b-be3a-7cbc-a2c0-d9daebdd91d5€15.00€0.26matched
66capture01a19d0b-dd81-785f-94b3-eebf7f4da628€9.00€0.19matched
67capture01a19d0b-e9f5-7955-af4e-b37b27e22a1a€24.00€0.37matched
68capture01a19d0c-1352-74fa-9547-49705c80749b€24.00€0.37matched
70capture01a19d0c-24b2-75d1-a66f-a199deb7f546€9.00€0.19matched
71capture01a19d0c-4820-7282-ac75-d4ec41c422ad€9.00€0.19matched
72capture01a19d0c-632c-77ad-b494-97167ae0752b€49.00€0.67matched
73capture01a19d0c-76fd-79b4-b80d-be9fa3a20016€35.00€0.50matched
74capture01a19d0c-8155-734f-b341-f2bac96a0bd2€24.00€0.37matched
75capture01a19d0c-88d7-7881-a0e2-b29c143894f2€49.00€0.67matched
76capture01a19d0c-8ef9-78d9-a107-e2d018fe898b€49.00€0.67matched
77capture01a19d0c-ab94-7ffd-a267-638776e0822b€49.00€0.67matched
78refund01a19d0c-abb9-7460-89eb-3588d5820b37-€6.00€0.00matched
79capture01a19d0c-af8a-70eb-8ad4-39ce513e71f9€9.00€0.19matched
80capture01a19d0c-baca-7f0b-995a-584386230be6€15.00€0.26matched
81capture01a19d0c-cba2-71da-acb8-0d0a4813aaf6€24.00€0.37matched
82capture01a19d0c-d7e6-76fe-b5fd-fd69843e5821€35.00€0.50matched
83capture01a19d0c-dd4f-76bd-9dbb-60c196a9920b€24.00€0.37matched
84capture01a19d0c-f007-74ce-ac0f-794e95aa0c17€35.00€0.50matched
85capture01a19d0d-3309-7d09-80c7-36d1a5f9181f€49.00€0.67matched
86capture01a19d0d-3c14-784b-8795-5f20ce27ef53€49.00€0.67matched
87capture01a19d0d-442a-7df6-8f68-d4ee38e3f824€35.00€0.50matched
88capture01a19d0d-5c83-77d0-90a0-12de5ef897b0€24.00€0.37matched
89refund01a19d0d-9449-7422-a678-4a9f46f9b62e-€35.00€0.00matched
90capture01a19d0d-9d15-73c4-af24-c2c7d01f1328€24.00€0.37matched
91capture01a19d0d-ba65-72f7-a7f2-eb931defccf7€24.00€0.37matched
92capture01a19d0d-bb76-70e6-9b7e-b2fa0a99e5dd€15.00€0.26matched
93capture01a19d0d-dbdd-7d32-9078-8ab6b3ee02dd€9.00€0.19matched
94capture01a19d0d-e451-781b-95b1-3604fabeefc6€15.00€0.26matched
95refund01a19d0d-f8ee-7208-9aa1-1818ad525535-€21.00€0.00matched
96capture01a19d0d-faae-73ae-a428-c67b25457475€24.00€0.37matched
97capture01a19d0d-fbe9-7c2d-ae82-9c5fa3bde09e€35.00€0.50matched
98capture01a19d0d-fc76-7213-82ba-1f370ee37a07€35.00€0.50matched
99capture01a19d0e-1b5b-7e3e-8b96-5e91786bc246€24.00€0.37matched
100capture01a19d0e-3adc-74a2-a8ce-ac37c257bafe€49.00€0.67matched
101capture01a19d0e-4061-77c1-b752-5475912e55fe€49.00€0.67matched
102capture01a19d0e-e7ba-70a8-8edd-b1a87852471d€35.00€0.50matched
103capture01a19d0e-fbf7-752d-ad3c-52332684fd8a€35.00€0.50matched
104capture01a19d0f-238c-76b3-9c4e-80bb49f9dbdf€49.00€0.67matched
105capture01a19d0f-42dc-788e-9b06-1768f74a70ea€24.00€0.37matched
106capture01a19d0f-4661-7d34-a66b-6a2ce7dd50fe€35.00€0.50matched