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

6 Nov, 09:10

Gross

€3,036.00

PSP fee

€48.01

Net to the bank

€2,987.99

Settlement journal

#413495

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
  • 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 21, the contract says 19
  • missing linein the books, not in the filecapture:01a1b01f-7947-7894-8a3d-497b36c7bdcb is in no file
  • missing linein the books, not in the filecapture:01a1b028-5c1e-7349-8311-e6d8e6201fc1 is in no file
LineKindReferenceGrossFeeStatus
48capture01a1b022-02f5-7538-a95f-91417a5c882f€35.00€0.51fee difference
87capture01a1b025-be9f-745e-aaa8-fa83cdf40e77€35.00€0.52fee difference
112capture01a1b027-3d90-735d-ba39-36a7b6288291€9.00€0.21fee difference
1capture01a1b01f-4d0f-77c1-80dd-a692d839322a€35.00€0.50matched
2capture01a1b01f-4f6b-715a-9e76-e65aba2ef96a€15.00€0.26matched
3capture01a1b01f-54bd-7774-a97f-15c730a79058€49.00€0.67matched
4capture01a1b01f-5aeb-7ff6-b372-ca8e5d1cb118€24.00€0.37matched
5capture01a1b01f-5c81-7fda-89cf-d3366fab494e€15.00€0.26matched
6capture01a1b01f-6276-72ae-bff8-3d6135d919dc€24.00€0.37matched
7refund01a1b01f-8747-76e6-bf6d-c30d4ffb56fa-€11.00€0.00matched
8capture01a1b01f-8fab-7931-a6bc-ceef5ee6a366€24.00€0.37matched
9capture01a1b01f-9368-767e-86db-9ea920a8f67f€49.00€0.67matched
10capture01a1b01f-a203-71a5-8c8c-a22edbc68002€9.00€0.19matched
11capture01a1b01f-a3a5-7c31-ba61-0d80e768ca96€15.00€0.26matched
12capture01a1b01f-b1e6-7d70-806d-005adf7f3459€15.00€0.26matched
13capture01a1b01f-dc31-7ed1-a38b-ee7cbc3dfbe2€9.00€0.19matched
14capture01a1b01f-df17-714c-a6f5-58bb14036507€15.00€0.26matched
15capture01a1b01f-fc88-7625-b0e9-721e6fd8ad73€49.00€0.67matched
16capture01a1b020-1c00-762c-9e37-377ce86e38eb€49.00€0.67matched
17capture01a1b020-2945-7e5c-9e30-b3dd1fbf0968€24.00€0.37matched
18capture01a1b020-5163-78d8-ac4a-af902a1c13de€15.00€0.26matched
19capture01a1b020-4bc3-709f-bef3-a52f22f730e6€49.00€0.67matched
20capture01a1b020-73bc-7f0b-bc8c-c173fd886abe€15.00€0.26matched
21refund01a1b020-8cf7-7146-a373-3b2ed31604ef-€9.00€0.00matched
22capture01a1b020-8e56-7dd5-a892-a2dcfffb4c2a€49.00€0.67matched
23capture01a1b020-becd-72bc-a7d2-1a509077ab3d€15.00€0.26matched
24capture01a1b020-c88e-733f-99ff-58c5562077f9€24.00€0.37matched
25capture01a1b020-cd8f-7f40-bc0d-cad66caf0d98€35.00€0.50matched
26capture01a1b020-d4b1-751c-9484-c1bb61cf8ded€49.00€0.67matched
27capture01a1b020-d6bc-775f-b66f-740fb85c15d1€49.00€0.67matched
28capture01a1b020-da07-796d-b6f0-cc4d40664732€15.00€0.26matched
29capture01a1b020-def7-7565-a6c4-e60850ef447b€35.00€0.50matched
30capture01a1b020-f0f8-7423-aa16-33497c7ba258€24.00€0.37matched
31capture01a1b020-f629-7500-9cea-0ffce6b9d656€15.00€0.26matched
32capture01a1b021-0952-7cc9-a593-7ffc0e2ba42c€35.00€0.50matched
33capture01a1b021-1573-7701-b939-6d3a8e4905e8€15.00€0.26matched
34refund01a1b021-232f-79ec-a9e2-02a1138a4059-€20.00€0.00matched
35refund01a1b021-3139-79dd-a6ae-951634f23e12-€7.00€0.00matched
36capture01a1b021-3173-7eec-85f0-adfc4b606699€15.00€0.26matched
37capture01a1b021-40b9-7c32-a326-f79cb10efe5b€24.00€0.37matched
38capture01a1b021-54d0-79fb-aa50-7e3bbc515a87€15.00€0.26matched
39capture01a1b021-6dfc-7c44-bf70-596a2605ba7a€35.00€0.50matched
40capture01a1b021-83bb-726e-a608-a6c016b07bba€35.00€0.50matched
41capture01a1b021-8431-7dbe-ae85-bef7e9327afc€9.00€0.19matched
42capture01a1b021-ab94-77eb-8970-671281bd2b7f€35.00€0.50matched
43refund01a1b021-b6bb-7802-9060-a427c227dc7a-€32.00€0.00matched
44capture01a1b021-dc89-7c57-b1b8-1c3c2493244b€35.00€0.50matched
45capture01a1b021-e5ca-7ec1-ac49-b37142fd7403€24.00€0.37matched
46capture01a1b021-ecc1-7f43-89fa-9a8f8d398fa3€49.00€0.67matched
47capture01a1b021-f804-7fb6-a538-d0d64998269b€35.00€0.50matched
49capture01a1b022-185d-7021-825b-77780fff6ad6€9.00€0.19matched
50capture01a1b022-2293-71a9-98cc-5f161c039d8c€24.00€0.37matched
51capture01a1b022-2ae4-7289-96c9-c4e1256b924d€24.00€0.37matched
52capture01a1b022-62d4-7bf0-9727-d4f614c1ed9c€49.00€0.67matched
53refund01a1b022-8ba2-7120-8bc9-a4f3551bed91-€6.00€0.00matched
54capture01a1b022-964d-79dd-a1cd-e5108333c5d1€35.00€0.50matched
55capture01a1b022-ad1a-76a9-8d9e-95d8224cbab1€24.00€0.37matched
56capture01a1b022-bbfc-71b6-bc4f-8675f8d9ae08€24.00€0.37matched
57capture01a1b022-d71c-7854-8798-731ab0011a56€24.00€0.37matched
58capture01a1b022-df46-7186-b595-20debd777afc€9.00€0.19matched
59capture01a1b023-07e0-7716-92d1-bf63b18cacec€15.00€0.26matched
60capture01a1b023-2a23-7e6e-8fb7-674e48311606€49.00€0.67matched
61capture01a1b023-31dc-7bba-bd62-7be8af7129c6€15.00€0.26matched
62capture01a1b023-68f5-7b43-8f9c-ee5449acf709€15.00€0.26matched
63capture01a1b023-70ad-7bb9-bd09-d9ee70fb4758€35.00€0.50matched
64capture01a1b023-718d-732b-b3af-2614dc659be5€49.00€0.67matched
65refund01a1b023-77e7-7d07-a71c-d2d18265ddfb-€24.00€0.00matched
66capture01a1b023-7bb9-71c4-8cdc-a99c2a94f42a€35.00€0.50matched
67capture01a1b023-9195-720d-90e9-94de9292837b€35.00€0.50matched
68capture01a1b023-97bf-7d42-9972-f802893dd133€15.00€0.26matched
69capture01a1b023-bdb7-7c35-9606-c6a1528f081a€24.00€0.37matched
70capture01a1b023-be0b-7671-8d5d-1322ae27e882€9.00€0.19matched
71capture01a1b024-0d42-7671-bebe-02f3d329a0d8€49.00€0.67matched
72capture01a1b024-2308-73e5-bb9c-6cde2754b632€49.00€0.67matched
73capture01a1b024-35ff-7931-ac1b-c9147b7ad2d9€35.00€0.50matched
74capture01a1b024-3838-743a-b31b-25e9c40ef8b8€49.00€0.67matched
75capture01a1b024-7141-7e8a-8562-1a2b3a5942e1€15.00€0.26matched
76capture01a1b024-9ff2-7696-a18c-943dcce5738b€15.00€0.26matched
77capture01a1b024-a1d0-73fe-bd3d-046cc41e8487€9.00€0.19matched
78capture01a1b024-bc56-766f-91cb-4f79173aef07€35.00€0.50matched
79capture01a1b024-d2ca-764f-8fdf-50b6c49332ce€24.00€0.37matched
80capture01a1b024-e4a1-769d-a022-34ea981b4d34€9.00€0.19matched
81capture01a1b025-0a5f-7306-be6c-49058f4d35b9€9.00€0.19matched
82capture01a1b025-1c4d-7a5d-b33f-d37ebbfc4e01€35.00€0.50matched
83capture01a1b025-29ef-7f84-8f31-8cda753d48fe€15.00€0.26matched
84capture01a1b025-58c4-7556-995c-cbd276de456a€24.00€0.37matched
85capture01a1b025-5bd4-75da-bbef-fb3489f14b04€49.00€0.67matched
86capture01a1b025-a6c2-7492-8807-c1fa0143c34f€35.00€0.50matched
88capture01a1b025-cf4a-7a96-87dc-3df67515e348€9.00€0.19matched
89capture01a1b026-0eb2-7341-b921-18268bef82c3€24.00€0.37matched
90capture01a1b026-1147-7c39-a122-5ac456ac95db€9.00€0.19matched
91refund01a1b026-1519-730b-aebd-3bd2a916ffc3-€4.00€0.00matched
92capture01a1b026-1627-7c6c-8495-80a9a68ec9bd€15.00€0.26matched
93capture01a1b026-1ee6-74b4-a744-b64b15540481€24.00€0.37matched
94capture01a1b026-21b4-7f77-b6dc-3dad5dc9faf2€9.00€0.19matched
95capture01a1b026-304a-705f-876c-94ca43262a28€49.00€0.67matched
96capture01a1b026-3401-7a71-8263-be58b2395e80€24.00€0.37matched
97capture01a1b026-4124-79af-a603-71ea1b5df336€9.00€0.19matched
98capture01a1b026-5389-7cd5-a9d1-2606b848fd5d€49.00€0.67matched
99capture01a1b026-568b-7f7d-a652-3136bb841858€35.00€0.50matched
100refund01a1b026-71ff-70a9-b55a-e24fbf107fc9-€6.00€0.00matched
101capture01a1b026-723f-7e59-8bd7-ae49d5083e11€49.00€0.67matched
102capture01a1b026-731a-73f3-bedf-7cea11e3c222€9.00€0.19matched
103capture01a1b026-8709-7819-9893-9fdf1f645829€35.00€0.50matched
104capture01a1b026-9588-7d9b-be12-3af59c387313€35.00€0.50matched
105capture01a1b026-be6f-702b-93a5-ceb9904560fa€35.00€0.50matched
106capture01a1b026-d008-7143-b0bf-6d17ff9b1141€24.00€0.37matched
107refund01a1b026-de03-738f-9a9e-9de11465af4e-€37.00€0.00matched
108capture01a1b026-ee2e-7370-a461-6e3e203989ed€9.00€0.19matched
109capture01a1b026-f628-712f-bcb2-f39d6d780d39€49.00€0.67matched
110capture01a1b027-23fb-76e3-968f-c323d6684870€35.00€0.50matched
111capture01a1b027-2f4f-7117-a772-0dc9bcd1a29e€49.00€0.67matched
113capture01a1b027-4636-7527-9df2-5ac103941e63€9.00€0.19matched
114capture01a1b027-4746-7cc8-8d92-5ec0f15dc855€15.00€0.26matched
115capture01a1b027-4a75-7093-80f3-5f1bbd242bbc€49.00€0.67matched
116capture01a1b027-5866-7727-8fd1-5a2e210a9b22€15.00€0.26matched
117capture01a1b027-6bdc-7845-be23-dca70311cbd4€15.00€0.26matched
118capture01a1b027-9be2-7478-95c4-be0ea73a5d19€24.00€0.37matched
119capture01a1b027-c2a0-7c0a-b397-b10d33887a65€9.00€0.19matched
120capture01a1b027-c395-77d7-bb2c-63c61c0cf0ac€24.00€0.37matched
121refund01a1b027-c565-7e1d-a245-b86be90626fa-€7.00€0.00matched
122capture01a1b027-cf23-70fd-9625-ab3bcb165ad8€35.00€0.50matched
123capture01a1b027-d144-7c60-b483-880c4f0d2b89€9.00€0.19matched
124capture01a1b027-da4b-7dbb-ac82-fa88e65409af€9.00€0.19matched
125capture01a1b027-e0e8-75d3-bc03-bacc3e258c49€49.00€0.67matched
126capture01a1b027-f569-7d5f-8b05-fddfc46d4930€24.00€0.37matched
127capture01a1b028-2cf6-7fc8-a88b-61b832059bfb€35.00€0.50matched
128capture01a1b028-3b35-7c05-b42f-9d8b3707d213€35.00€0.50matched
129capture01a1b028-6110-7916-8a9b-cf14c1d64370€35.00€0.50matched