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, 06:40

Gross

€2,787.00

PSP fee

€44.21

Net to the bank

€2,742.79

Settlement journal

#338370

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 51, the contract says 50
  • missing linein the books, not in the filecapture:01a19b02-ded6-7054-8cd4-812909dfdc8b is in no file
  • missing linein the books, not in the filecapture:01a19b02-2ced-720f-ba31-6cc5261d4865 is in no file
LineKindReferenceGrossFeeStatus
13capture01a19afd-15ac-7132-8082-894b576d38ed€35.00€0.51fee difference
1capture01a19af6-fed8-72da-a964-f110b46d545a€24.00€0.37matched
2capture01a19afc-8f65-74b7-9cd0-a3dfc4fb9af9€35.00€0.50matched
3capture01a19afc-ad46-78d6-9a00-4b75f24fadcb€15.00€0.26matched
4capture01a19afc-b569-7f6a-b421-9df43307f87d€15.00€0.26matched
5capture01a19afc-c8ac-75af-a56f-dc86ab873e68€49.00€0.67matched
6capture01a19afc-ca9e-7989-bd8a-ba17d3e2f723€15.00€0.26matched
7capture01a19afc-d058-711a-ba26-efef91c90eac€35.00€0.50matched
8refund01a19afc-d334-7a4d-a7e7-0624350ffb0c-€26.00€0.00matched
9capture01a19afc-d7a0-718b-8d5a-c99eed6889a3€15.00€0.26matched
10capture01a19afc-e553-780c-ac25-23d2055c5e2d€49.00€0.67matched
11capture01a19afc-f1bc-746b-8d80-e2f04c39c4ce€15.00€0.26matched
12capture01a19afd-079f-7479-b249-76cb1e82317f€35.00€0.50matched
14capture01a19afd-18c5-722d-be26-8ad5eeb34265€49.00€0.67matched
15capture01a19afd-2504-7356-9e50-571926068904€9.00€0.19matched
16capture01a19afd-39e6-7328-bf41-28d8e4e92e4c€15.00€0.26matched
17capture01a19afd-3c3b-7406-beaf-27efdfd85381€49.00€0.67matched
18capture01a19afd-5b96-7cba-bd11-3c5936f58954€49.00€0.67matched
19capture01a19afd-668e-7ee1-bc57-514a425a2de6€9.00€0.19matched
20capture01a19afd-8aec-7f03-a9b2-b786e65d7349€15.00€0.26matched
21capture01a19afd-a0eb-7ec2-9ba5-ccdc7c0321c2€15.00€0.26matched
22capture01a19afd-af0c-7985-8480-fa51ca6f0564€35.00€0.50matched
23capture01a19afd-c77f-7745-9a02-73fca5477b70€35.00€0.50matched
24capture01a19afd-d245-7948-8489-b6c6f48ecc3f€9.00€0.19matched
25capture01a19afd-e49b-7e6a-9549-63ceb8b56d31€35.00€0.50matched
26capture01a19afd-ef73-7e05-b9db-a0c15187108d€35.00€0.50matched
27capture01a19afe-08cb-7701-99fd-c5fce43ca185€15.00€0.26matched
28capture01a19afe-1a2e-7681-8a0c-c577feafb282€24.00€0.37matched
29capture01a19afe-1c95-72ef-a65e-3870e9cf9af3€24.00€0.37matched
30capture01a19afe-1f90-7cb3-9618-37d266527ec0€24.00€0.37matched
31capture01a19afe-2e81-7696-a088-bdf248d96168€15.00€0.26matched
32capture01a19afe-31c1-71c6-9ac9-1fe983ad202f€9.00€0.19matched
33capture01a19afe-3448-77aa-a2e0-a7e3b5586a85€15.00€0.26matched
34capture01a19afe-3676-71a5-970b-ba2c6b89da13€15.00€0.26matched
35capture01a19afe-3961-7cf0-98e7-85a860372e26€15.00€0.26matched
36capture01a19afe-5704-79e6-ad09-97332823029c€9.00€0.19matched
37capture01a19afe-5d7b-77b4-b10e-ccdfcd1d91c3€24.00€0.37matched
38refund01a19afe-5d50-710d-ab8b-c47eafe25ef5-€21.00€0.00matched
39capture01a19afe-639f-70a7-b9e8-173f3ef71213€15.00€0.26matched
40capture01a19afe-6e1d-7e41-8536-7d2fbaffa48e€9.00€0.19matched
41capture01a19afe-9fff-750d-bd44-ccd85f2c86ea€35.00€0.50matched
42capture01a19afe-c8bb-7636-8b94-bfcb63989de2€15.00€0.26matched
43capture01a19afe-cecc-737f-ba5f-7d5f38e5e40c€24.00€0.37matched
44capture01a19aff-4c22-79e6-a0fb-d191e6d7dc4a€9.00€0.19matched
45capture01a19aff-4cd4-7411-8262-cfd05283bf42€15.00€0.26matched
46capture01a19aff-4cb7-7780-8e82-0c18644e409c€49.00€0.67matched
47capture01a19aff-54eb-7f53-a1e8-99bfdc6a1cb4€49.00€0.67matched
48refund01a19aff-8b57-7dc0-8e4a-5ef07cfe1379-€16.00€0.00matched
49capture01a19aff-a6c1-72c3-9739-6478f9cef09f€49.00€0.67matched
50capture01a19aff-e6b9-7291-8f8e-2b402ded6213€24.00€0.37matched
51capture01a19aff-f3f8-7f40-aaed-f21138b64258€15.00€0.26matched
52capture01a19aff-fd08-78c3-850c-067c0600e6bb€35.00€0.50matched
53capture01a19b00-05c6-778e-858a-fc084077657c€15.00€0.26matched
54refund01a19b00-1734-72dd-8416-a28d843b9a07-€10.00€0.00matched
55capture01a19b00-44af-730c-8c3e-f5c939fa9b45€24.00€0.37matched
56capture01a19b00-540c-701b-b04f-f61aff96b7ec€9.00€0.19matched
57capture01a19b00-5786-7d80-8c09-0d6e0f08a230€49.00€0.67matched
58capture01a19b00-aa1a-7eaa-975c-e02ce6f98333€9.00€0.19matched
59capture01a19b00-bdd9-7338-b70a-5c8c25507709€49.00€0.67matched
60capture01a19b00-bdce-7010-9d4d-543b599750e4€49.00€0.67matched
61capture01a19b00-e69a-7680-9008-329419f73c4c€24.00€0.37matched
62capture01a19b00-fc00-709c-b04b-208522f0e23c€49.00€0.67matched
63capture01a19b01-2d29-7df0-9801-d47104d2ca94€24.00€0.37matched
64capture01a19b01-3923-7d8a-9bcc-d42616e56362€24.00€0.37matched
65capture01a19b01-496b-75b6-8a8c-a836af16f333€15.00€0.26matched
66capture01a19b01-4a50-7c4e-8a19-93a7c8996cbc€9.00€0.19matched
67capture01a19b01-550e-7440-b26e-3a8c94e689cf€49.00€0.67matched
68capture01a19b01-75ab-7273-99b3-54b811c02961€15.00€0.26matched
69capture01a19b01-b6df-70a7-b3e1-6e72d090867c€49.00€0.67matched
70capture01a19b01-b6f3-717b-a59a-31ff6f8489cd€24.00€0.37matched
71capture01a19b01-c4f3-7454-b0ae-295c1fc34fd9€49.00€0.67matched
72capture01a19b01-e820-7ec2-a6c8-a0b3e9ef28ea€9.00€0.19matched
73capture01a19b02-0fe2-7337-a0cb-ba16e7bacb6d€35.00€0.50matched
74capture01a19b02-170d-7995-b715-d25ccc5a75f1€35.00€0.50matched
75capture01a19b02-1df4-71ea-bb0b-a70957d81a21€24.00€0.37matched
76capture01a19b02-69fd-7ce0-a431-071958ed3a28€35.00€0.50matched
77capture01a19b02-7a9d-7a1c-b70c-fb65832988fe€35.00€0.50matched
78capture01a19b02-91a2-72d7-9cba-ff23930bbc1a€9.00€0.19matched
79capture01a19b02-b5a2-7ede-8e93-acd6e88c0656€35.00€0.50matched
80capture01a19b02-c9be-75b8-9f89-347277a2a9c3€24.00€0.37matched
81capture01a19b02-d32d-7090-96a4-65b0a0c85965€49.00€0.67matched
82capture01a19b02-e845-78d9-8d98-c76d7b24faee€9.00€0.19matched
83capture01a19b02-f03a-72c0-a66b-a8bd9e091400€49.00€0.67matched
84capture01a19b02-fc35-7ea2-8d5f-321adf337654€24.00€0.37matched
85capture01a19b03-0af4-7649-9930-c520973578b4€35.00€0.50matched
86capture01a19b03-10f6-78ad-8669-06c77debd890€24.00€0.37matched
87capture01a19b03-18e3-7f42-807c-949d2062a52a€49.00€0.67matched
88capture01a19b03-25e4-78fb-821b-0abaf71b02f8€9.00€0.19matched
89capture01a19b03-3cf0-7822-98af-78386f1a8fcf€24.00€0.37matched
90refund01a19b03-4d69-77ea-a27f-613f44a3b5ee-€32.00€0.00matched
91capture01a19b03-5093-7447-a0a8-ec17285de338€35.00€0.50matched
92capture01a19b03-59db-7cba-ad1d-108a5ad9f23e€24.00€0.37matched
93capture01a19b03-8cd5-7d98-bcfb-5c8e89c3fd55€24.00€0.37matched
94capture01a19b03-a27d-74a4-9063-dd08378b18ce€49.00€0.67matched
95capture01a19b03-acc0-7808-a446-88ccd79723fc€49.00€0.67matched
96capture01a19b03-d2f9-7f4c-8c3b-802ee7b255b8€9.00€0.19matched
97capture01a19b03-eb37-73b9-93fb-b1cacb05f358€15.00€0.26matched
98capture01a19b03-fbbc-7e72-81e0-855bfb833916€35.00€0.50matched
99capture01a19b03-ffb4-7d31-b548-5240f4aad9e2€15.00€0.26matched
100capture01a19b04-3e5d-7739-91c2-6f916ea94da3€35.00€0.50matched
101capture01a19b04-4345-7b0d-8056-2fb99e672c52€49.00€0.67matched
102capture01a19b04-6c9b-7688-99c4-8593f60d9daa€49.00€0.67matched
103capture01a19b04-73af-75d6-8f23-b43970a8ea77€24.00€0.37matched
104capture01a19b04-7450-70a2-8e4a-1cddab148b4b€15.00€0.26matched
105capture01a19b04-7aef-7588-bf64-7aebc196adf4€35.00€0.50matched
106refund01a19b04-9415-72b8-9f3c-0b5e000a1ebe-€32.00€0.00matched
107capture01a19b04-9871-7c06-978f-768fade03cbd€24.00€0.37matched
108capture01a19b04-a3a5-7d5a-b2e8-5547eefa1d2b€24.00€0.37matched
109refund01a19b04-d864-7bf9-a560-fa7216897fe3-€29.00€0.00matched
110capture01a19b05-1c1d-7a44-8485-01a045fd0a45€35.00€0.50matched
111capture01a19b05-19a8-7560-a8c8-d4bc3ac2f301€15.00€0.26matched
112capture01a19b05-28f4-77dd-9257-e5e53ebb4941€9.00€0.19matched
113capture01a19b05-4d2b-774d-ae9b-2eba1a6285c8€49.00€0.67matched
114capture01a19b05-7590-70c3-9b7b-df52283bef6f€35.00€0.50matched
115capture01a19b05-9583-72cd-8c93-0007827cf240€24.00€0.37matched