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

Gross

€3,257.00

PSP fee

€50.82

Net to the bank

€3,206.18

Settlement journal

#415470

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 38, the contract says 37
  • missing linein the books, not in the filecapture:01a1b0ae-7340-7819-89b6-f875d5615942 is in no file
LineKindReferenceGrossFeeStatus
17capture01a1b0a9-9ced-76f7-9f93-35d1dcff2167€24.00€0.38fee difference
1capture01a1b0a1-0ab4-7510-a86b-107bf21d8601€35.00€0.50matched
2capture01a1b0a1-59d6-7aa1-b677-e89a9b71281d€9.00€0.19matched
3capture01a1b0a8-9df3-797d-8256-c38af5c886cd€15.00€0.26matched
4capture01a1b0a8-b871-75eb-a06c-94149981bffe€9.00€0.19matched
5capture01a1b0a8-e74f-75ef-ade1-a178ef1cd7d6€35.00€0.50matched
6capture01a1b0a8-e8c1-72c8-a371-8d72067603e3€49.00€0.67matched
7capture01a1b0a9-03f8-7888-b1ea-267e6e4f215c€15.00€0.26matched
8capture01a1b0a9-18dc-7d64-93f2-e5e658c937e9€9.00€0.19matched
9capture01a1b0a9-3755-7a27-b34f-08fadc81b1ab€9.00€0.19matched
10capture01a1b0a9-4876-7e5b-b2a6-65a49487d3d9€15.00€0.26matched
11capture01a1b0a9-4a5f-7092-b0f3-b69a0b872dc5€9.00€0.19matched
12capture01a1b0a9-4f44-7b91-a723-cc235b6c39ee€49.00€0.67matched
13capture01a1b0a9-68bc-7150-aabf-39761e5a8489€24.00€0.37matched
14capture01a1b0a9-6aed-70bd-bca2-068d8ade334d€9.00€0.19matched
15capture01a1b0a9-6d33-7dd3-9525-ff2ca44ca3fc€24.00€0.37matched
16capture01a1b0a9-73f4-701c-b21c-ac2344727836€24.00€0.37matched
18capture01a1b0a9-9f46-76b8-b753-f16e52568c97€15.00€0.26matched
19capture01a1b0a9-c5df-7756-b2a2-2d4693d443d0€24.00€0.37matched
20capture01a1b0a9-d057-784b-b46f-f998d18d3b38€35.00€0.50matched
21capture01a1b0a9-dacf-7004-9936-7bf89940af6e€24.00€0.37matched
22capture01a1b0a9-f5a9-7d1f-9d07-4279863526c0€24.00€0.37matched
23capture01a1b0aa-46ee-7120-bb96-df7f5eeeffee€24.00€0.37matched
24capture01a1b0aa-5eff-7143-a7ae-05b537b0abe0€15.00€0.26matched
25capture01a1b0aa-79ba-721c-877c-1097ed0b2182€24.00€0.37matched
26capture01a1b0aa-970e-73ae-87b6-cdcb53453b57€9.00€0.19matched
27capture01a1b0aa-a192-714c-a520-b27cb59f6133€35.00€0.50matched
28capture01a1b0aa-acc4-7237-8f90-1d142c2e10c3€49.00€0.67matched
29capture01a1b0aa-ada4-7470-b0f4-2e9fc1bcc83c€24.00€0.37matched
30capture01a1b0aa-c268-7881-a959-34e935fa6c07€15.00€0.26matched
31capture01a1b0aa-d685-755f-8282-7195ea4a5c3b€49.00€0.67matched
32capture01a1b0ab-075f-7f9c-a198-0f8a85512d57€49.00€0.67matched
33capture01a1b0ab-0a39-74b7-b871-8c6a8acc437f€9.00€0.19matched
34capture01a1b0ab-0c83-754b-ade5-b3ee0c8e19ac€9.00€0.19matched
35capture01a1b0ab-0fd9-7dc8-9183-b25f9abd77b7€9.00€0.19matched
36capture01a1b0ab-150e-70c2-b3c0-4c07d4b41395€24.00€0.37matched
37capture01a1b0ab-23c8-7406-b7ca-f76f67d5e7ca€9.00€0.19matched
38capture01a1b0ab-53e1-7c52-938b-422878a4a4a9€15.00€0.26matched
39capture01a1b0ab-5586-78ec-8269-7092170e8e95€24.00€0.37matched
40capture01a1b0ab-6a2c-731b-a814-2447a8426ccb€35.00€0.50matched
41capture01a1b0ab-70f1-7c6b-b3e1-14d6544d842b€24.00€0.37matched
42refund01a1b0ab-81bf-7914-8789-ffcb9299cedb-€8.00€0.00matched
43capture01a1b0ab-9039-7bfd-8ac2-01a34689013f€35.00€0.50matched
44capture01a1b0ab-9355-72e5-a502-5a6181683a85€35.00€0.50matched
45capture01a1b0ab-a7ce-7e95-bf5e-5452f9bc8914€35.00€0.50matched
46capture01a1b0ab-b876-7878-9bda-dd0bb3496c3e€35.00€0.50matched
47capture01a1b0ab-e0f9-7305-a857-30c771441ae1€49.00€0.67matched
48capture01a1b0ac-0ea4-723d-9c20-0a2ee18b1b4d€15.00€0.26matched
49capture01a1b0ac-0f9e-7a6e-a132-2319eea938fe€35.00€0.50matched
50capture01a1b0ac-12cc-7be4-b7db-5c93f9b0c240€49.00€0.67matched
51capture01a1b0ac-1680-75d2-9828-4f87e8e74b12€35.00€0.50matched
52capture01a1b0ac-237a-72fa-a8fe-36977d289261€9.00€0.19matched
53capture01a1b0ac-2185-7298-865f-5720a45fa9ee€49.00€0.67matched
54capture01a1b0ac-473f-7729-9b79-7ddbf24d60d6€24.00€0.37matched
55capture01a1b0ac-4c25-74b3-8820-ef273e565235€15.00€0.26matched
56capture01a1b0ac-84d5-7f6c-844a-5ee29a3be07e€49.00€0.67matched
57capture01a1b0ac-9438-7a6d-b73d-b200ec3ed3c6€9.00€0.19matched
58capture01a1b0ac-9bc3-7e22-a75d-a57b0bba4621€35.00€0.50matched
59capture01a1b0ac-ab9e-756d-bc70-4446124c990c€15.00€0.26matched
60capture01a1b0ac-b261-7100-8675-9d4059fcc2bd€15.00€0.26matched
61capture01a1b0ac-c91b-7168-9bcb-262a91212d47€24.00€0.37matched
62refund01a1b0ac-d52a-7f51-ae58-f8adc0fb7a3d-€10.00€0.00matched
63capture01a1b0ac-e9f7-7495-921b-c2f0e36f7148€15.00€0.26matched
64capture01a1b0ac-fc12-7450-841e-a3aa10150e94€35.00€0.50matched
65refund01a1b0ac-ffab-72c4-8cc5-9eb99f519ecc-€5.00€0.00matched
66capture01a1b0ad-1ea8-7b5b-bf81-93a92115d6a9€49.00€0.67matched
67capture01a1b0ad-36e3-77f2-a0eb-94c3e7735cb9€49.00€0.67matched
68capture01a1b0ad-4c1a-77dc-9278-1efafdf16075€35.00€0.50matched
69refund01a1b0ad-5e96-7bd9-81df-54c3ddfbe7dd-€48.00€0.00matched
70capture01a1b0ad-8108-765e-ac08-f549049930c2€24.00€0.37matched
71capture01a1b0ad-8637-72fd-b053-1e814de780ea€24.00€0.37matched
72capture01a1b0ad-9794-75e4-962a-9f9af669f47f€9.00€0.19matched
73capture01a1b0ad-a6f0-7009-8788-9c80bf9dbe3a€9.00€0.19matched
74capture01a1b0ad-ad21-7024-9118-4a714636b699€9.00€0.19matched
75capture01a1b0ad-ae35-78ed-9053-34943a29eeb7€15.00€0.26matched
76capture01a1b0ad-b6c5-762f-b2ba-93abcf1b3bec€24.00€0.37matched
77capture01a1b0ad-b730-75d4-92c3-d4db6d5ea475€35.00€0.50matched
78capture01a1b0ad-d083-7557-8ce3-4b0008cf6090€15.00€0.26matched
79capture01a1b0ad-e8cc-736f-a575-153f14d340cd€49.00€0.67matched
80capture01a1b0ad-ed12-70e2-b1c7-e68ae1d2579b€24.00€0.37matched
81capture01a1b0ad-ef39-7f8d-867d-473e8868356c€24.00€0.37matched
82capture01a1b0ad-f7f4-7629-a7db-82c05063515e€49.00€0.67matched
83refund01a1b0ae-175d-7b62-a396-71b35093b323-€11.00€0.00matched
84capture01a1b0ae-3825-7e6c-a6a9-d46b128377fd€35.00€0.50matched
85capture01a1b0ae-6e2e-7c7e-a705-8a3035ba24fd€49.00€0.67matched
86capture01a1b0ae-7ae2-71bd-a4a6-4d6d8e8d15b9€9.00€0.19matched
87capture01a1b0ae-aeb5-705a-9379-642cd75e00f6€49.00€0.67matched
88capture01a1b0ae-b02a-7c06-8e75-4b94e0adc212€35.00€0.50matched
89capture01a1b0ae-e290-7a1f-85f5-4c8bdd0ea0f8€49.00€0.67matched
90capture01a1b0ae-f77e-7d82-85b6-942494d4a2f0€15.00€0.26matched
91capture01a1b0af-0032-7196-b384-316ec486f5ff€9.00€0.19matched
92capture01a1b0af-003c-747e-af18-d89dd3211c57€35.00€0.50matched
93capture01a1b0af-0dab-7e46-ab02-5db3803f1599€9.00€0.19matched
94capture01a1b0af-10f8-7672-9239-8c202034c3f6€49.00€0.67matched
95capture01a1b0af-14fa-7c6a-9d0e-a983a621932c€24.00€0.37matched
96capture01a1b0af-1fb2-7bd4-b7e3-561315fa0a46€15.00€0.26matched
97capture01a1b0af-28e6-71bb-b12d-880475c341e1€24.00€0.37matched
98capture01a1b0af-42de-7095-bb6b-7c94b446a04d€15.00€0.26matched
99capture01a1b0af-442d-757a-be1e-3252164b3b56€49.00€0.67matched
100capture01a1b0af-61f1-732c-b111-0d4a27d673f1€49.00€0.67matched
101capture01a1b0af-6745-7f97-8125-1ecf935becad€24.00€0.37matched
102capture01a1b0af-6788-71c4-bfb1-3643bf08a536€49.00€0.67matched
103capture01a1b0af-7b45-7359-8c83-4674d541cdef€35.00€0.50matched
104capture01a1b0af-822b-781e-b68b-0d7b7b0f59a3€49.00€0.67matched
105capture01a1b0af-8617-7a3f-8525-a232ab4e9659€24.00€0.37matched
106refund01a1b0af-ae5a-7f97-a636-673c23af7ac8-€40.00€0.00matched
107capture01a1b0af-b6bc-770e-94f9-d055abc7ef28€49.00€0.67matched
108capture01a1b0af-dffd-73f2-876c-6c3647eb3453€9.00€0.19matched
109capture01a1b0af-ed83-725b-b602-d2a2fc2cefff€15.00€0.26matched
110capture01a1b0af-fb48-753f-9670-4e27867dcaf5€9.00€0.19matched
111capture01a1b0b0-02b0-7890-86a4-ff76900b8c4e€9.00€0.19matched
112capture01a1b0b0-267c-78bf-ad5f-599927679748€24.00€0.37matched
113capture01a1b0b0-83d1-7622-ae4f-7ef3b1c723f7€24.00€0.37matched
114capture01a1b0b0-8d32-79c8-89ec-c9e8584e19b8€9.00€0.19matched
115capture01a1b0b0-8fce-7edc-852e-6c4891eff7d7€15.00€0.26matched
116capture01a1b0b0-9ced-740c-8241-3ad72a9ce658€9.00€0.19matched
117capture01a1b0b0-a6ca-77b1-acfd-8b9ca5b9fd85€24.00€0.37matched
118capture01a1b0b0-a883-7963-b528-35d2488e8881€49.00€0.67matched
119capture01a1b0b0-be71-7000-b1f9-1dc3d88e8fd0€15.00€0.26matched
120capture01a1b0b0-f0de-7b9f-8225-446f6009e918€24.00€0.37matched
121capture01a1b0b0-ff7c-739b-8283-4b66ee1fc55e€24.00€0.37matched
122capture01a1b0b1-0995-71fe-a12a-91a7c8710dbe€35.00€0.50matched
123capture01a1b0b1-37d8-74c9-a3fc-f538791da0a3€49.00€0.67matched
124capture01a1b0b1-49a8-721e-b5c7-ea1f15d104dd€15.00€0.26matched
125capture01a1b0b1-357a-704b-999e-2c96809f6f2b€49.00€0.67matched
126capture01a1b0b1-5326-78aa-9d47-020ef4c6a640€49.00€0.67matched
127refund01a1b0b1-5e16-7eb2-8977-2bc9c126d543-€8.00€0.00matched
128capture01a1b0b1-7577-7c13-9d91-1970652cf7bc€24.00€0.37matched
129capture01a1b0b1-7fac-7b9b-b528-445fbaf34647€49.00€0.67matched
130capture01a1b0b1-8ca3-7a8c-b3e8-c00cd30433d3€15.00€0.26matched
131capture01a1b0b1-99f2-7c0b-8328-f9549cac989a€49.00€0.67matched
132capture01a1b0b1-b45d-79d2-aa5e-ea3a838ba2e6€49.00€0.67matched