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

5 Nov, 17:50

Gross

€2,797.00

PSP fee

€45.10

Net to the bank

€2,751.90

Settlement journal

#401706

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 28, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 55, the contract says 50
  • missing linein the books, not in the filecapture:01a1acd6-2fc7-7ce6-88e5-066470a2d6ee is in no file
LineKindReferenceGrossFeeStatus
82capture01a1acdb-3e6e-739b-b208-82afd770ed83€15.00€0.28fee difference
98capture01a1acdc-35d1-7360-8eac-773e7e0f5223€35.00€0.55fee difference
1capture01a1acd4-f38e-7b11-ba38-a0406b5e80f4€9.00€0.19matched
2capture01a1acd5-0fd8-7279-a5df-3446b8b49040€49.00€0.67matched
3capture01a1acd5-208b-7183-9f64-f67e4476c5aa€9.00€0.19matched
4capture01a1acd5-35df-778d-be41-423c7fc30ed3€9.00€0.19matched
5capture01a1acd5-4b9f-72fb-a8ae-acdf4e8dd061€49.00€0.67matched
6capture01a1acd5-50f1-71f7-92c5-ee8d818a7451€49.00€0.67matched
7capture01a1acd5-527d-7641-8195-9ec250936bf4€15.00€0.26matched
8capture01a1acd5-8b0b-7436-b93e-b58cf67026d4€9.00€0.19matched
9refund01a1acd5-9397-7fcb-a41b-ca6dc4b93711-€4.00€0.00matched
10capture01a1acd5-a410-7475-8848-4ea0b65b9915€49.00€0.67matched
11refund01a1acd5-b2d4-7ca2-9a4e-65b41fdb9946-€2.00€0.00matched
12capture01a1acd5-c142-77a7-97a6-ae94fcccdb72€15.00€0.26matched
13capture01a1acd5-c1b2-7fa4-9ad8-11cd830eebf2€35.00€0.50matched
14capture01a1acd5-ee4d-71f4-876d-3b63af305264€15.00€0.26matched
15refund01a1acd5-f117-7725-b6bf-d0bbad132c3b-€10.00€0.00matched
16capture01a1acd5-fcf2-75e2-a85f-104a450f5d73€49.00€0.67matched
17capture01a1acd6-05b2-7977-81eb-e7f08d0d1ab7€49.00€0.67matched
18refund01a1acd6-1413-7f22-843b-998a638d52e3-€11.00€0.00matched
19capture01a1acd6-37f7-75f8-ab06-86454930deb4€35.00€0.50matched
20capture01a1acd6-61da-7a0c-8ccc-07cfd3942ec5€15.00€0.26matched
21capture01a1acd6-8606-76d1-8648-e617d86ffbb0€9.00€0.19matched
22capture01a1acd6-a8da-766f-91da-379d85f7b009€24.00€0.37matched
23capture01a1acd6-aef3-752e-9017-930fe8086964€49.00€0.67matched
24capture01a1acd6-b5e7-7ecb-9d5e-8455c577dd7b€15.00€0.26matched
25capture01a1acd6-c0f6-78cd-b7da-312563aa123e€15.00€0.26matched
26capture01a1acd6-c19e-7e7f-8bed-b89d17501c46€49.00€0.67matched
27capture01a1acd6-e0a8-7ff6-8e12-781055f6b4a6€24.00€0.37matched
28capture01a1acd6-e3d9-73f4-ad17-ea4ffae9494e€15.00€0.26matched
29capture01a1acd6-f179-75aa-ba2a-69843eb5cd61€24.00€0.37matched
30refund01a1acd6-fa8f-7822-bbed-aeba9ca216e1-€44.00€0.00matched
31capture01a1acd6-fc48-7c34-ae55-580f539a088d€9.00€0.19matched
32capture01a1acd7-0792-73f8-8b62-8f246ebb2248€35.00€0.50matched
33capture01a1acd7-0803-7670-bd8a-79c2fd9d7f94€15.00€0.26matched
34capture01a1acd7-0905-7b65-8e4e-9410e5321302€9.00€0.19matched
35capture01a1acd7-11e5-7a8f-b590-850906a86128€24.00€0.37matched
36capture01a1acd7-292b-76fb-8d02-a049b5c17eb3€15.00€0.26matched
37capture01a1acd7-396f-7fe1-a424-149c43147376€9.00€0.19matched
38capture01a1acd7-3faf-7bc2-a774-4329bd9aec9f€9.00€0.19matched
39capture01a1acd7-46c2-7606-8794-6e870f94100b€15.00€0.26matched
40capture01a1acd7-52dc-73f6-918b-bf08d2c66de0€49.00€0.67matched
41capture01a1acd7-6470-7a6e-81c6-78ee57a556b3€15.00€0.26matched
42capture01a1acd7-65f6-70ed-ba23-4431e5ccfe87€49.00€0.67matched
43capture01a1acd7-6c4b-72b5-92e8-c5621f0de0a4€35.00€0.50matched
44capture01a1acd7-7cb0-759b-b648-502766fe5c9d€24.00€0.37matched
45capture01a1acd7-b001-7841-9f5f-01ef66b83ea3€15.00€0.26matched
46capture01a1acd7-f67c-7c11-9d33-660bf5e552f5€24.00€0.37matched
47capture01a1acd8-0bb6-74a6-a5cc-bcc9c6ee360f€49.00€0.67matched
48capture01a1acd8-37b6-7a20-9b13-3b1b8baade90€49.00€0.67matched
49capture01a1acd8-4211-7ab8-9223-fcbcf0ae6a3f€49.00€0.67matched
50capture01a1acd8-8ba6-7009-9aaf-f51e5b4e5fd2€24.00€0.37matched
51capture01a1acd8-d361-759b-9b7a-1244078b0eed€49.00€0.67matched
52capture01a1acd8-e080-7721-9e22-e091c87bfef9€15.00€0.26matched
53capture01a1acd9-08d6-76c7-9cb2-22138cc35337€15.00€0.26matched
54capture01a1acd9-15ea-70d3-89ad-c4afeaee8565€49.00€0.67matched
55refund01a1acd9-3f40-71b0-966c-33c4c0668cc4-€12.00€0.00matched
56capture01a1acd9-4604-7ee8-8a7c-91fbbe246940€15.00€0.26matched
57capture01a1acd9-690f-746f-a212-53edb807cad0€9.00€0.19matched
58refund01a1acd9-6a2c-7c6a-bf13-1edba3660484-€35.00€0.00matched
59capture01a1acd9-6e0a-73dd-adb7-e0261ab79fc7€9.00€0.19matched
60capture01a1acd9-6632-72fb-94d7-9d973533efe8€35.00€0.50matched
61capture01a1acd9-72a8-7dc8-a7cf-53ed32923360€9.00€0.19matched
62capture01a1acd9-a043-7897-9be1-08ea384d28ed€15.00€0.26matched
63capture01a1acd9-c1d0-78a1-ac68-b063dcd3b9bb€24.00€0.37matched
64capture01a1acd9-c8d4-7828-a77a-e0daebfffdbc€24.00€0.37matched
65capture01a1acd9-caf1-7dd3-87b7-2e085354a562€35.00€0.50matched
66capture01a1acd9-d810-7c31-9221-481d2a6bc8ec€49.00€0.67matched
67capture01a1acda-0408-7bd1-ab71-e8a2bae0f883€35.00€0.50matched
68capture01a1acda-08a4-76e1-8cf2-0b285978ba57€9.00€0.19matched
69capture01a1acda-24b6-70ac-af0c-3cd58d4070bb€35.00€0.50matched
70capture01a1acda-398b-7c58-8246-3c7b6297180b€15.00€0.26matched
71capture01a1acda-5ec3-7294-8518-58fac55ee433€24.00€0.37matched
72capture01a1acda-5eff-769b-a7b2-411a48215ebe€49.00€0.67matched
73capture01a1acda-749e-76cf-95aa-bff04c1eee42€15.00€0.26matched
74capture01a1acda-80a1-7290-a2d2-82137f16f8c8€35.00€0.50matched
75capture01a1acda-8ad1-7fc3-a65c-b0675a96a213€35.00€0.50matched
76capture01a1acda-c0ff-73d9-9af5-3f13e45ab4c6€9.00€0.19matched
77capture01a1acda-c6ea-7d7b-bbc1-2f173b6335e3€24.00€0.37matched
78capture01a1acda-db95-7e6e-bbec-cdc3b9328ab7€15.00€0.26matched
79capture01a1acda-f35d-7fea-b172-399e23489fbe€9.00€0.19matched
80capture01a1acdb-193b-7eef-9f32-7a6261ce1940€9.00€0.19matched
81capture01a1acdb-342d-7156-a337-2f48b5e65f9b€49.00€0.67matched
83capture01a1acdb-54f6-7a5b-8f35-bc371e5aef80€9.00€0.19matched
84capture01a1acdb-5b9c-794e-95a7-d08de1fac3d3€35.00€0.50matched
85capture01a1acdb-5c5f-777b-9b09-3e7d27d1c9bf€49.00€0.67matched
86refund01a1acdb-726a-7236-afbb-60dad66c9e2f-€22.00€0.00matched
87capture01a1acdb-7960-7bed-943c-be760c24c388€35.00€0.50matched
88capture01a1acdb-8017-7238-98dc-d900d5dca3e0€35.00€0.50matched
89capture01a1acdb-8230-7d28-b380-503c5a521bd4€9.00€0.19matched
90capture01a1acdb-bd7a-7eb7-91a5-5d8fa6544ccf€24.00€0.37matched
91capture01a1acdb-c02b-7d4e-8f0e-dfe458b37dec€35.00€0.50matched
92capture01a1acdc-067d-7a73-b550-7cda8eaf3099€35.00€0.50matched
93capture01a1acdc-094a-7990-839d-04af6a4115ff€49.00€0.67matched
94capture01a1acdc-0ee6-7eb1-a94f-2acbc0ad6e03€15.00€0.26matched
95capture01a1acdc-292f-792e-aec6-5787f9f61fbe€24.00€0.37matched
96refund01a1acdc-3303-7442-8df0-756edf186cb7-€21.00€0.00matched
97capture01a1acdc-3650-7dc1-8124-8b0f4d567782€24.00€0.37matched
99capture01a1acdc-3e94-7ee1-9b36-9f69cfd976ce€49.00€0.67matched
100capture01a1acdc-4361-7c20-927e-2f693b3bf4ae€9.00€0.19matched
101capture01a1acdc-4bec-7118-b344-804ce8f272f1€9.00€0.19matched
102capture01a1acdc-445b-7b9f-82db-9502ce9089e0€24.00€0.37matched
103refund01a1acdc-6413-7272-b4bb-348a48717f87-€15.00€0.00matched
104capture01a1acdc-6caf-79cc-9ad4-0ca94fa44b7b€15.00€0.26matched
105refund01a1acdc-7462-75d7-9eb9-bad9b599c5d9-€8.00€0.00matched
106capture01a1acdc-9794-7680-9c71-30b14474530f€15.00€0.26matched
107capture01a1acdc-9886-74ed-af7c-24952c48df69€9.00€0.19matched
108capture01a1acdc-a9d0-7239-8464-d67f5e485906€24.00€0.37matched
109capture01a1acdc-c52a-725a-a785-f53f106ea4a5€35.00€0.50matched
110capture01a1acdc-d507-71f3-a1a2-ea705ca59a9d€24.00€0.37matched
111capture01a1acdc-e6ac-7e38-ba8a-64646370c08f€49.00€0.67matched
112capture01a1acdd-0480-75c5-8494-4d7b1ad51578€9.00€0.19matched
113capture01a1acdd-2cf3-709e-afec-9bfacc0e303d€9.00€0.19matched
114capture01a1acdd-51e0-7267-973a-778a1852448c€9.00€0.19matched
115capture01a1acdd-6fac-783f-b325-3c1db6f8b824€35.00€0.50matched
116capture01a1acdd-7d43-7dba-8afd-aeeaaa21c19c€15.00€0.26matched
117capture01a1acdd-a1f3-76e9-a2e2-3ff5816977f7€9.00€0.19matched
118capture01a1acdd-aa55-7f18-91e7-1c3f2c08a455€35.00€0.50matched
119capture01a1acdd-bfb8-7960-a0ef-fcbb2d208422€15.00€0.26matched
120capture01a1acdd-f67b-711c-842d-85e31dbe9c77€24.00€0.37matched
121capture01a1acdd-ff66-76d2-9e8a-ff29b7336b7e€35.00€0.50matched
122capture01a1acde-0058-7109-91a5-3280d88d3b66€49.00€0.67matched
123capture01a1acde-00bc-7c33-9b3d-b721c1ba9303€49.00€0.67matched
124capture01a1acde-0a78-7915-b01c-2df0be9dcaa7€49.00€0.67matched
125capture01a1acde-122e-7130-aeb4-b01772685ee7€24.00€0.37matched