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

4 Nov, 14:40

Gross

€3,192.00

PSP fee

€49.95

Net to the bank

€3,142.05

Settlement journal

#380958

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 40, the contract says 37
  • missing linein the books, not in the filecapture:01a1a701-4862-79ee-87ad-e25a5d0aff20 is in no file
LineKindReferenceGrossFeeStatus
5capture01a1a700-d5de-7e43-9d30-7d1dc345d8e6€24.00€0.40fee difference
1capture01a1a6fd-065c-77f9-81f9-e17d400ffba8€35.00€0.50matched
2capture01a1a700-a76a-7123-a8ca-d108872c448c€9.00€0.19matched
3capture01a1a700-c055-7669-bb6a-8b14e600a688€24.00€0.37matched
4capture01a1a700-ce30-797a-aac6-4d03e21b08d4€35.00€0.50matched
6capture01a1a700-dd68-7d31-a361-46a57ac20602€24.00€0.37matched
7capture01a1a700-f26c-7a65-8966-5ea59fd3fba4€35.00€0.50matched
8capture01a1a700-fd2f-70fd-8f43-2b10706edce4€49.00€0.67matched
9capture01a1a701-0a7e-7b8a-af3b-46b6f9716c1d€49.00€0.67matched
10capture01a1a701-0f55-71ac-8db9-c2fd53f2eadd€35.00€0.50matched
11capture01a1a701-232b-7243-bef4-a3e60ffbc4ca€35.00€0.50matched
12capture01a1a701-23e6-71bb-9831-ef6541a48c43€35.00€0.50matched
13capture01a1a701-3627-7791-95df-877938d33644€24.00€0.37matched
14capture01a1a701-3a65-75f4-be9b-e1cd70edcde9€49.00€0.67matched
15capture01a1a701-3d5d-7a65-bf70-dcd893021c17€24.00€0.37matched
16capture01a1a701-4e79-7dd8-bae6-42d256d36050€9.00€0.19matched
17capture01a1a701-6fca-7316-8df0-6893bf5d1665€49.00€0.67matched
18refund01a1a701-9874-73ad-9da8-dc07e4ba64ab-€27.00€0.00matched
19capture01a1a701-b606-75ad-a26d-2b737029a080€35.00€0.50matched
20capture01a1a701-c0f9-7b30-857d-88ddc06f8421€35.00€0.50matched
21capture01a1a701-d6c0-7150-a0fe-ead7a45dc907€15.00€0.26matched
22capture01a1a702-0627-7980-a8cb-a6db9a37763b€49.00€0.67matched
23capture01a1a702-0e20-7b66-ad53-8dee27beb5a3€24.00€0.37matched
24capture01a1a702-220c-7c10-92a6-fcff18c94a62€24.00€0.37matched
25capture01a1a702-2304-77dd-9646-58252bd7d96b€9.00€0.19matched
26capture01a1a702-33ac-7351-9e90-8dd0c0d37b5a€35.00€0.50matched
27capture01a1a702-405c-71b3-a672-a711e209d6b3€49.00€0.67matched
28capture01a1a702-4de7-7272-8547-f70f1bcdeef2€49.00€0.67matched
29capture01a1a702-5ce1-70d3-9523-aab9488365ce€15.00€0.26matched
30capture01a1a702-70c6-769b-84bf-172e38fc8b40€49.00€0.67matched
31capture01a1a702-92ae-7d63-b610-b8617c19c47e€49.00€0.67matched
32capture01a1a702-9806-7334-a5c0-36afdd543521€35.00€0.50matched
33refund01a1a702-b08e-7e6a-880a-fe6b215dafff-€45.00€0.00matched
34capture01a1a702-bdc6-7fd1-b608-a487ede989dd€49.00€0.67matched
35capture01a1a702-c929-73f2-8f95-5adf56f223fd€15.00€0.26matched
36capture01a1a702-d2c4-7bf3-8a42-278a2f09c228€9.00€0.19matched
37capture01a1a702-e219-7db3-aba1-61518631a00e€49.00€0.67matched
38capture01a1a703-0541-7d6b-afa4-60a54d47bbd4€49.00€0.67matched
39capture01a1a703-120c-776a-b2a5-480598787335€24.00€0.37matched
40capture01a1a703-2528-7dac-b9ba-679e613cbdfb€49.00€0.67matched
41capture01a1a703-2b64-7302-b9cf-c2209440e154€15.00€0.26matched
42capture01a1a703-2b7d-7703-abe6-ed82a180e757€49.00€0.67matched
43capture01a1a703-3300-7245-bfc1-7de55d4e67fe€49.00€0.67matched
44capture01a1a703-36ff-7a8a-a66c-a9f1e4abadad€35.00€0.50matched
45capture01a1a703-5060-713b-9ad6-67887d683f4c€24.00€0.37matched
46capture01a1a703-5f40-7bc5-9131-d5f26d1a9778€9.00€0.19matched
47capture01a1a703-acc8-7797-b877-a6d127b5b06f€24.00€0.37matched
48capture01a1a703-bc9f-7072-a3e3-564e7c9b1009€24.00€0.37matched
49capture01a1a703-c635-71b2-b0bb-7e5512658bf7€35.00€0.50matched
50capture01a1a703-ec3e-7367-a624-db813ec6e604€15.00€0.26matched
51capture01a1a703-f67b-7101-97b3-03abcb023c86€49.00€0.67matched
52capture01a1a704-183e-799c-abb6-f33694558f03€9.00€0.19matched
53capture01a1a704-2560-7993-871a-ec0763049ac7€9.00€0.19matched
54capture01a1a704-2955-787b-896f-1e32b2a3eee5€35.00€0.50matched
55capture01a1a704-81b9-73f4-9bbd-ea0661b98823€49.00€0.67matched
56capture01a1a704-ab3b-7832-911c-b4ea1a50fdc7€15.00€0.26matched
57capture01a1a704-affd-7d0a-aeff-c93571299a5e€9.00€0.19matched
58capture01a1a704-b11e-727b-b0a0-e6b62bd5de9f€15.00€0.26matched
59capture01a1a704-e98c-74a0-aaa2-e5962b40e493€49.00€0.67matched
60capture01a1a705-06bf-7b5e-abd5-dd73ef0aa6bc€35.00€0.50matched
61capture01a1a705-0769-727b-8f9d-429a78b728d5€35.00€0.50matched
62capture01a1a705-158b-7371-a353-a641e1f34604€49.00€0.67matched
63capture01a1a705-1c0c-7d5b-964a-349714ffdceb€9.00€0.19matched
64capture01a1a705-1eb2-75fc-92ad-6d1fed0137bc€49.00€0.67matched
65capture01a1a705-49f7-73d2-bb5f-b687fc16e561€9.00€0.19matched
66capture01a1a705-503e-7ba9-9468-e5e73b46e8ae€49.00€0.67matched
67capture01a1a705-54ca-782e-aaa9-e3943706bb8e€49.00€0.67matched
68refund01a1a705-609e-7a05-831e-5d5ec05f66bb-€7.00€0.00matched
69capture01a1a705-65ff-7e50-a462-dbe0379e3764€24.00€0.37matched
70capture01a1a705-69dd-76df-8907-83c24b4bf21a€24.00€0.37matched
71capture01a1a705-8a3d-701f-af61-501a319ce66e€49.00€0.67matched
72capture01a1a705-93a7-7b56-9ed8-173d26ee2905€15.00€0.26matched
73refund01a1a705-ab21-7113-898a-87770b462467-€10.00€0.00matched
74capture01a1a705-b308-7681-93a0-f73742034123€24.00€0.37matched
75capture01a1a705-b47a-7969-b0bc-558cfa730bef€15.00€0.26matched
76capture01a1a705-bb70-76b4-b532-4ddf61c9b410€15.00€0.26matched
77capture01a1a705-fdc2-7516-8840-e3e444a455cd€15.00€0.26matched
78capture01a1a706-071f-7fbf-807a-71b712d4184f€49.00€0.67matched
79capture01a1a706-096c-7109-a0e8-5fc4ef6b57d2€15.00€0.26matched
80capture01a1a706-1b50-75fd-9fc3-bb849fc264c7€49.00€0.67matched
81capture01a1a706-21d7-798e-b1be-64936211f4a8€49.00€0.67matched
82capture01a1a706-2d15-7562-8129-2e2ebba5b2a1€35.00€0.50matched
83capture01a1a706-3418-7ba2-81e1-4c2ed694901a€9.00€0.19matched
84capture01a1a706-50c1-77fe-9d17-f1792929357b€9.00€0.19matched
85capture01a1a706-6511-7fc4-a6b4-9fa6f46360dc€49.00€0.67matched
86refund01a1a706-6a5d-74a1-b644-9809d637e855-€11.00€0.00matched
87capture01a1a706-6fc2-726f-be6e-00dd93f7fcfe€9.00€0.19matched
88refund01a1a706-7a10-7994-8d9a-ac8499f27f9b-€6.00€0.00matched
89capture01a1a706-a0f1-785d-bf50-b74e8b918444€24.00€0.37matched
90capture01a1a706-b20e-75db-b319-9174cc281455€49.00€0.67matched
91capture01a1a706-f27f-7744-8d1c-84f4dc8e1a6e€24.00€0.37matched
92capture01a1a707-3b7a-7001-9387-0c5b13970a7f€35.00€0.50matched
93capture01a1a707-3e29-772e-8570-bf1e32240ba2€49.00€0.67matched
94capture01a1a707-59ff-7e8c-b030-b92f64ad09b6€35.00€0.50matched
95refund01a1a707-61b6-7f71-b414-a4ca09dec94e-€14.00€0.00matched
96capture01a1a707-6e42-72ea-b716-d9c04a8dbf81€9.00€0.19matched
97capture01a1a707-7156-7beb-b042-b991f917c2b9€9.00€0.19matched
98refund01a1a707-97aa-727b-b30d-33dd74d88dbc-€15.00€0.00matched
99capture01a1a707-abba-7045-b48c-37629650619c€24.00€0.37matched
100capture01a1a707-c1f6-7d5c-b0fa-0f4a9062a7a3€49.00€0.67matched
101refund01a1a707-ca85-75fa-aa02-7f93d99ea455-€24.00€0.00matched
102refund01a1a707-cdfa-7eed-a095-15070b453f4e-€3.00€0.00matched
103capture01a1a707-ddf5-7efe-8602-73a5eebcad6e€9.00€0.19matched
104capture01a1a707-e013-7bd7-8707-0b4ae2486b9b€24.00€0.37matched
105capture01a1a708-06b3-794e-9ed7-4892404ad8c8€35.00€0.50matched
106capture01a1a708-13d0-7c06-bec4-33ff50490f0d€15.00€0.26matched
107capture01a1a708-19c8-7859-b59d-81d955619cf4€35.00€0.50matched
108capture01a1a708-1ffb-7ce8-8b2e-a7a019e03140€24.00€0.37matched
109capture01a1a708-4b0b-7358-a4f2-74b206684f05€24.00€0.37matched
110refund01a1a708-75a8-7a0c-9909-8007d5fe45c0-€20.00€0.00matched
111capture01a1a708-983a-7161-be9b-00d49b9d80de€24.00€0.37matched
112capture01a1a708-99a6-7f23-b9aa-8a3235568cb2€24.00€0.37matched
113capture01a1a708-a755-7e22-be01-11f6ce98e24b€49.00€0.67matched
114capture01a1a708-cd04-7362-be62-d9d3c9d3d203€24.00€0.37matched
115capture01a1a708-ddcc-704c-94fe-9ce164add2f3€9.00€0.19matched
116capture01a1a708-ff15-7c62-ad0d-caed9c494c10€49.00€0.67matched
117capture01a1a709-28c6-7d07-9c53-d5fffc091eb6€24.00€0.37matched
118capture01a1a709-2c69-73f9-9d68-e32a04b3ab44€49.00€0.67matched
119capture01a1a709-50a2-763c-9fa1-1d77a9b96797€9.00€0.19matched
120capture01a1a709-535d-7aa1-a2e9-f1ec0aa181ee€15.00€0.26matched
121capture01a1a709-69ee-7ede-a189-bd81a04bf93a€24.00€0.37matched
122capture01a1a709-6e34-78cd-b703-7b08e6edbc2a€35.00€0.50matched
123capture01a1a709-72a0-7bc2-ad19-fdeac5685328€24.00€0.37matched
124capture01a1a709-8437-797a-b714-53cfb4fbe7ab€15.00€0.26matched
125refund01a1a709-a158-7f05-8d2d-f3e107f51e66-€13.00€0.00matched
126capture01a1a709-c985-77ef-b6f5-b500e6efc849€24.00€0.37matched