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

Gross

€2,598.00

PSP fee

€41.42

Net to the bank

€2,556.58

Settlement journal

#352661

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a19efe-fde7-71b0-a6c6-85a638a7b30a is already settled by stl_EUR_2989448 line 24
  • missing linein the books, not in the filecapture:01a19f00-c6d0-70c3-9ef8-c1a90cf658c6 is in no file
  • missing linein the books, not in the filecapture:01a19f06-2248-7871-be41-8d6b2e072562 is in no file
LineKindReferenceGrossFeeStatus
25capture01a19efe-fdff-7549-87c5-6f8a53749e67€35.00€0.50duplicate line
1capture01a19ef6-a0bc-778f-b93e-50c1567b2531€49.00€0.67matched
2capture01a19ef9-9206-7f4b-adef-3739b43538f1€49.00€0.67matched
3capture01a19ef9-d9da-77e0-827c-4c6d94e51bd3€15.00€0.26matched
4capture01a19efa-287d-7a34-b36a-c017f694ca24€35.00€0.50matched
5capture01a19efe-0dd0-7245-a651-bd4a78067aec€24.00€0.37matched
6capture01a19efe-2c3b-7e98-9a97-063647c3cc86€9.00€0.19matched
7capture01a19efe-3127-7bc9-8dfc-a801218ee224€15.00€0.26matched
8capture01a19efe-475f-73e4-a589-1b4fb581eef8€49.00€0.67matched
9capture01a19efe-4ad1-7001-80e5-1f4f057baf49€9.00€0.19matched
10capture01a19efe-5340-72bb-8b8b-e69a202ffd57€35.00€0.50matched
11capture01a19efe-56fa-7bf9-a49e-a9552efec553€24.00€0.37matched
12capture01a19efe-6616-71f4-9e9f-ec65a9eac524€35.00€0.50matched
13capture01a19efe-6d24-7c09-bf76-e938dbed6f1f€35.00€0.50matched
14capture01a19efe-7ee3-7d50-ac80-39d0005b1da8€24.00€0.37matched
15capture01a19efe-8d3c-7457-9495-26e5533fadb5€24.00€0.37matched
16refund01a19efe-8e41-7a25-acd3-016e6af23dab-€11.00€0.00matched
17capture01a19efe-ae63-704f-9bcc-b45cea5ca0fd€15.00€0.26matched
18capture01a19efe-c362-7a37-a0c0-555b6816e29c€49.00€0.67matched
19capture01a19efe-cdc0-75a0-9aa5-76229407bbc5€9.00€0.19matched
20capture01a19efe-d8f9-77fc-bb9b-9deeb78efdb3€49.00€0.67matched
21capture01a19efe-e3ec-7254-af7a-78cd01f31b9f€35.00€0.50matched
22capture01a19efe-e7ab-7e94-a379-9cbc60a7f8d3€35.00€0.50matched
23capture01a19efe-fbc5-794c-8778-65becfb0b167€9.00€0.19matched
24capture01a19efe-fdff-7549-87c5-6f8a53749e67€35.00€0.50matched
26refund01a19eff-1ab3-7306-8216-58ddcdc94e07-€18.00€0.00matched
27capture01a19eff-1bdd-709b-8a71-00d4e13cad09€15.00€0.26matched
28capture01a19eff-1c48-7ede-b552-2b8552a75073€9.00€0.19matched
29capture01a19eff-2f2d-7344-be69-190da89e92d9€35.00€0.50matched
30capture01a19eff-31c2-727a-891d-72cefc7ce5a5€24.00€0.37matched
31capture01a19eff-5239-7a8f-ae40-6a773c25f836€49.00€0.67matched
32capture01a19eff-634d-75c3-b103-44a44a09a1d0€35.00€0.50matched
33capture01a19eff-a0fb-7d08-b966-9bbabbbe6be9€35.00€0.50matched
34capture01a19eff-a5f4-7120-b72f-65539874dfc0€15.00€0.26matched
35capture01a19eff-b148-7c51-ad5d-83b75bcb2356€49.00€0.67matched
36capture01a19eff-c51a-77b2-9f9a-2723d51850b4€15.00€0.26matched
37capture01a19eff-cb7f-7763-a805-d7cba5ec4e49€15.00€0.26matched
38capture01a19eff-d0e5-7593-aa20-d4d437d6b0b9€49.00€0.67matched
39capture01a19eff-f3ad-7ec5-bc44-5113d7b7b1cb€35.00€0.50matched
40capture01a19eff-fc1e-7457-a6d4-fe178bc1c185€35.00€0.50matched
41refund01a19f00-050c-7ffd-9420-1dbf02edf18e-€13.00€0.00matched
42capture01a19f00-1040-77b7-a0b0-e3773b9467f2€15.00€0.26matched
43capture01a19f00-2505-7522-aa40-ad11125a12d2€15.00€0.26matched
44capture01a19f00-3517-7fb7-85ee-2635190bf0e1€15.00€0.26matched
45capture01a19f00-35ae-7d9d-8209-a44d4b31bbb6€9.00€0.19matched
46capture01a19f00-441e-76ce-b704-8a9a7349c65e€24.00€0.37matched
47refund01a19f00-4a89-762b-aea8-a8c81cafff16-€8.00€0.00matched
48capture01a19f00-6324-7604-9ee9-01386bf26e0b€49.00€0.67matched
49capture01a19f00-86dc-7b74-928c-318a2747e37c€35.00€0.50matched
50capture01a19f00-a2af-7dc6-867c-e98f3da51fa9€9.00€0.19matched
51capture01a19f00-a8b1-75eb-8db5-7a4184aa6d44€49.00€0.67matched
52capture01a19f00-fa6a-7e36-ad7f-5b35ace6c04f€24.00€0.37matched
53capture01a19f01-1161-766a-b36e-9e46754bf8ee€15.00€0.26matched
54capture01a19f01-1a06-7bc5-bd5a-0b4139ae5b53€15.00€0.26matched
55capture01a19f01-5064-793c-ac7c-593360245c19€15.00€0.26matched
56capture01a19f01-530f-7505-ade2-b828db84f7d1€49.00€0.67matched
57capture01a19f01-76e8-79be-8090-0e620064ec3f€24.00€0.37matched
58capture01a19f01-7c0c-7448-a8f3-55ffa790186d€9.00€0.19matched
59capture01a19f01-9ef6-725b-ae40-86aa0638da67€35.00€0.50matched
60capture01a19f02-0754-75e9-a716-de3f78f4d75e€9.00€0.19matched
61capture01a19f02-36e1-7f47-9cd9-1cca96f7540c€15.00€0.26matched
62capture01a19f02-9d5c-7a0d-a92a-bc1d6b935bc6€9.00€0.19matched
63capture01a19f02-9901-75b1-8f92-8fa1850c7560€15.00€0.26matched
64capture01a19f02-c7d3-7a5f-978c-c1c7152e4d54€15.00€0.26matched
65capture01a19f02-e42e-719c-8600-e35c4e1cee02€9.00€0.19matched
66capture01a19f02-e924-77d6-a1f3-cb102feb4403€15.00€0.26matched
67capture01a19f03-1d84-736d-a2fe-aa4ed167d32c€49.00€0.67matched
68capture01a19f03-81d7-72c8-8f96-d34f59c21db9€49.00€0.67matched
69capture01a19f03-99cf-777f-a491-9421fccad127€49.00€0.67matched
70capture01a19f03-b323-7521-876d-6975e4231f47€49.00€0.67matched
71capture01a19f03-c0fc-7ea2-9194-54348ffcca7f€9.00€0.19matched
72refund01a19f03-cb0e-7de1-af7f-2f5202e4493b-€22.00€0.00matched
73capture01a19f03-de58-737b-897d-a047ccf908bd€35.00€0.50matched
74capture01a19f04-06c8-7c1f-8fdd-0c7dc6722efb€49.00€0.67matched
75capture01a19f04-0fbd-7bae-81fd-eaf8e2c3c602€35.00€0.50matched
76capture01a19f04-1552-75cf-b224-96de5a72a073€49.00€0.67matched
77capture01a19f04-1671-75d4-be3d-ee72d823fe15€15.00€0.26matched
78capture01a19f04-293b-779b-b728-a4b618cf562b€15.00€0.26matched
79capture01a19f04-2a47-70d6-b94e-d96ab735f7ea€15.00€0.26matched
80capture01a19f04-39b8-74f6-8ca3-5e4c63779a49€9.00€0.19matched
81refund01a19f04-4b81-7a97-acc2-540d38ca3b6e-€6.00€0.00matched
82refund01a19f04-59cb-726d-b2e3-85a0c4e1a9f2-€15.00€0.00matched
83capture01a19f04-5d2e-776c-a861-376a6e26c77d€24.00€0.37matched
84capture01a19f04-6367-7512-9eb0-f57b0ded653e€9.00€0.19matched
85capture01a19f04-69b6-72bd-90f1-44060806c867€24.00€0.37matched
86capture01a19f04-72b3-7e06-be87-37c44cf94ba2€24.00€0.37matched
87capture01a19f04-7e54-76e9-b970-ec0b3bfb9c0c€49.00€0.67matched
88capture01a19f04-889f-79d1-9841-ce20f6ccb625€24.00€0.37matched
89capture01a19f04-8b5a-78ae-813e-bb88ef8434c6€24.00€0.37matched
90capture01a19f04-b09d-7cb6-99c6-3bd3a1fe5dc0€49.00€0.67matched
91capture01a19f04-ca6e-7591-bfd0-5dbed76dbb02€15.00€0.26matched
92capture01a19f04-d48a-7f3c-a9e4-189f869925b8€24.00€0.37matched
93refund01a19f04-e1ac-755e-a410-942cb2bab08f-€40.00€0.00matched
94refund01a19f05-11b3-7a07-9bfd-15b3cd26e6bd-€4.00€0.00matched
95capture01a19f05-27a7-728e-a031-f359c4f0726e€9.00€0.19matched
96capture01a19f05-2d9d-7c35-93df-315e5b103c95€24.00€0.37matched
97capture01a19f05-a23d-718b-a1be-52581acf9046€35.00€0.50matched
98capture01a19f05-cfa5-7db4-aa5e-6e1d3d225277€15.00€0.26matched
99capture01a19f05-d28d-73c3-9f1d-1ba874f7389e€9.00€0.19matched
100capture01a19f05-dd43-7cbc-b20f-f70f29b4d6a9€35.00€0.50matched
101capture01a19f06-0644-7eed-95ce-dda9623382d5€15.00€0.26matched
102capture01a19f06-1d2a-7933-a33e-a4fb72e8cd25€24.00€0.37matched
103capture01a19f06-2239-70b0-a15d-2ac1af1aa612€35.00€0.50matched
104capture01a19f06-23a8-7d76-9d43-0f11fe71c92d€49.00€0.67matched
105capture01a19f06-43f3-7f05-bdb0-ed610e847dd9€15.00€0.26matched
106capture01a19f06-4dc4-7e48-a3c6-8e0113589ab6€9.00€0.19matched
107capture01a19f06-5d7c-794b-b780-11cb4e71bdc0€49.00€0.67matched
108capture01a19f06-7c51-7da9-9bac-17ee0c3cc8cc€15.00€0.26matched
109capture01a19f06-8d04-7f34-9243-ef0685f32f61€35.00€0.50matched
110refund01a19f06-a553-7ec1-9c84-ffc9a1dacc41-€7.00€0.00matched
111capture01a19f06-c450-7b2a-a455-93a848454208€9.00€0.19matched
112capture01a19f06-d5ec-76f3-aae8-849ed61b8243€24.00€0.37matched
113capture01a19f06-e0d1-77ae-a440-e3f204f3d4d0€9.00€0.19matched
114capture01a19f06-ece8-7673-af9f-f0738dca52d7€9.00€0.19matched
115capture01a19f06-ffff-715f-88dc-06d4a98d6e42€15.00€0.26matched