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

3 Nov, 09:00

Gross

€3,134.00

PSP fee

€49.35

Net to the bank

€3,084.65

Settlement journal

#358490

Breaks for a person to look at

  • fee differencethe fee is not the contract feethe fee is 31, the contract says 26
  • fee differencethe fee is not the contract feethe fee is 39, the contract says 37
  • fee differencethe fee is not the contract feethe fee is 52, the contract says 50
  • missing linein the books, not in the filecapture:01a1a0a9-b612-7fd1-a9f7-a300f46afaf3 is in no file
  • missing linein the books, not in the filecapture:01a1a0aa-c5db-727a-8b7c-538c84c3f46d is in no file
LineKindReferenceGrossFeeStatus
27capture01a1a0a4-6fd0-7d85-bc3c-f38216eb96ad€15.00€0.31fee difference
35capture01a1a0a4-dfae-7777-90e3-ad9c31180e1d€24.00€0.39fee difference
49capture01a1a0a5-d2ad-7202-b1d1-ddd46b441221€35.00€0.52fee difference
1capture01a1a09c-41ab-7a19-bf17-15403905289e€15.00€0.26matched
2capture01a1a0a3-1184-7f25-a157-1956d2063acb€9.00€0.19matched
3capture01a1a0a3-1456-77ff-b661-69b9cfc1de89€24.00€0.37matched
4capture01a1a0a3-238c-7ea7-8dc4-d594527e2ebb€49.00€0.67matched
5capture01a1a0a3-32d6-7578-829d-7bf39df66286€15.00€0.26matched
6capture01a1a0a3-3858-710f-b0a1-2fb14d81f1fe€35.00€0.50matched
7capture01a1a0a3-3cc2-778f-aa02-150cead34174€35.00€0.50matched
8capture01a1a0a3-3ea1-7a43-ab5b-02ddedf960c1€24.00€0.37matched
9capture01a1a0a3-577a-7126-bf7c-5883cb736b06€24.00€0.37matched
10refund01a1a0a3-658a-7384-8e42-f10342afa9d9-€30.00€0.00matched
11capture01a1a0a3-6f6d-7228-8318-55e879322e30€35.00€0.50matched
12capture01a1a0a3-7218-7fbf-ac5a-aae63b265f20€15.00€0.26matched
13capture01a1a0a3-7824-720b-aeee-0c3684ca5a1d€9.00€0.19matched
14capture01a1a0a3-876a-71a1-8059-7bade5dbff7e€24.00€0.37matched
15capture01a1a0a3-9c18-70df-a6b3-95eb9f5b50cc€35.00€0.50matched
16capture01a1a0a3-ab33-7eea-bd18-8508dd4a59e5€15.00€0.26matched
17refund01a1a0a3-bc96-7b8d-a1ae-a9987111fcc5-€7.00€0.00matched
18capture01a1a0a4-02d1-7924-9afd-8fe49a750a66€35.00€0.50matched
19capture01a1a0a4-0361-7a11-82ee-9847cb679360€49.00€0.67matched
20capture01a1a0a4-1475-7802-9d7d-7c1cb1aa70f9€24.00€0.37matched
21capture01a1a0a4-173a-784b-ac4b-894894301f5a€24.00€0.37matched
22capture01a1a0a4-1f52-714d-ac98-de07f34849b4€15.00€0.26matched
23capture01a1a0a4-2809-7895-8b0b-bf092f5d8e50€9.00€0.19matched
24refund01a1a0a4-429a-7dd7-a183-4e2a8a17522c-€10.00€0.00matched
25refund01a1a0a4-5d76-756e-8ff8-57b0afe14b9c-€4.00€0.00matched
26capture01a1a0a4-69a7-792a-aba2-ae86f1d4d96a€49.00€0.67matched
28capture01a1a0a4-7816-71c7-8cf3-36f742b5f061€49.00€0.67matched
29capture01a1a0a4-86ad-7408-a2b2-0e6b3f1ea457€49.00€0.67matched
30capture01a1a0a4-8c47-7599-b510-d70c9dab58e3€35.00€0.50matched
31capture01a1a0a4-98bc-7603-98ab-977b78f8ac51€24.00€0.37matched
32capture01a1a0a4-cc6b-74e8-99a7-e383ab8cbca9€35.00€0.50matched
33capture01a1a0a4-d334-74c1-bd79-4359a2bdb5f4€9.00€0.19matched
34capture01a1a0a4-e1f1-7207-9426-ed418751b63c€15.00€0.26matched
36capture01a1a0a4-e18b-743c-b835-c9937b322c13€49.00€0.67matched
37capture01a1a0a4-ebb3-775d-9763-e8e025726923€15.00€0.26matched
38capture01a1a0a5-03b9-7ec8-8680-5da2938c513a€9.00€0.19matched
39capture01a1a0a5-07f9-777b-a841-b4bc931ca16b€49.00€0.67matched
40capture01a1a0a5-20c3-7d9c-b7de-24c906d67a5b€35.00€0.50matched
41capture01a1a0a5-3f75-715b-9312-2e02ee49023c€35.00€0.50matched
42capture01a1a0a5-4bbe-76f0-9d80-9c1868caa195€15.00€0.26matched
43capture01a1a0a5-70b8-796c-b2d6-61d6ed02a65d€24.00€0.37matched
44capture01a1a0a5-798a-7a05-85b5-5d1b7b9f0bae€49.00€0.67matched
45capture01a1a0a5-799a-7d68-a3aa-97a18940f900€9.00€0.19matched
46capture01a1a0a5-92a0-7197-b317-1b20af3dafa5€24.00€0.37matched
47capture01a1a0a5-9e85-7438-8fbc-ebe6a0e46e21€15.00€0.26matched
48capture01a1a0a5-a7d0-76af-9065-2557c95c679c€35.00€0.50matched
50capture01a1a0a5-e2cf-77d3-b43e-1f5afaaded46€15.00€0.26matched
51capture01a1a0a6-0223-7bab-8318-2be76d260f98€15.00€0.26matched
52capture01a1a0a6-1b20-7721-8d35-9c8556dc07c0€9.00€0.19matched
53capture01a1a0a6-5a11-7d05-9135-55151a356079€9.00€0.19matched
54capture01a1a0a6-65d9-7fec-9aa9-c0271cde3f62€15.00€0.26matched
55capture01a1a0a6-6d55-7a81-9511-d62d6502b89c€9.00€0.19matched
56capture01a1a0a6-72cc-7ec5-9f89-4e661e98ae5d€24.00€0.37matched
57capture01a1a0a6-8c64-71d4-8086-6e38fa563223€49.00€0.67matched
58capture01a1a0a6-8f5e-7ed3-9c65-6828b1869733€9.00€0.19matched
59capture01a1a0a6-90d0-7be5-a429-1d11dd195d0c€49.00€0.67matched
60capture01a1a0a6-bfd0-7127-949b-d89a428e1377€9.00€0.19matched
61capture01a1a0a6-cfa9-7bb5-a760-82ee18db8afb€49.00€0.67matched
62capture01a1a0a6-e00e-7dca-b2a1-94127b850db5€15.00€0.26matched
63capture01a1a0a6-dcf9-77df-bc01-52e08b55add1€15.00€0.26matched
64capture01a1a0a6-ec25-7f6f-bfab-31bbca9ed0d4€9.00€0.19matched
65capture01a1a0a6-fcd9-76d2-9c82-7528fcb24128€9.00€0.19matched
66capture01a1a0a7-0340-701e-9b15-6152ff662ccf€24.00€0.37matched
67capture01a1a0a7-13a4-7a92-8204-218cf2b1cf2e€49.00€0.67matched
68refund01a1a0a7-2459-72ed-8268-1db92bc6b0f0-€5.00€0.00matched
69capture01a1a0a7-37cc-7159-b61a-1d7422922adf€35.00€0.50matched
70capture01a1a0a7-38b8-7fd2-9baf-45b49e70a9b8€49.00€0.67matched
71capture01a1a0a7-3967-780e-b440-f57504367e06€35.00€0.50matched
72capture01a1a0a7-5ad1-7141-b02f-a74afe1b2c97€35.00€0.50matched
73capture01a1a0a7-6173-78cc-9c28-af998f9c50a5€15.00€0.26matched
74capture01a1a0a7-80ff-71d4-831b-f823305b8f45€35.00€0.50matched
75capture01a1a0a7-8ef5-7e54-b299-3d763e3e2d2e€9.00€0.19matched
76capture01a1a0a7-926c-7fa6-a152-c905ecdf595b€9.00€0.19matched
77capture01a1a0a7-a18b-76c7-85f1-6614e64f0112€9.00€0.19matched
78capture01a1a0a7-c4b7-7564-856a-8e26742e5908€24.00€0.37matched
79capture01a1a0a7-e01a-70b0-8fc5-837f2d357659€24.00€0.37matched
80capture01a1a0a7-f1ed-7004-92eb-45e1f2440330€24.00€0.37matched
81capture01a1a0a7-fd39-72d2-8411-8542b97804ed€15.00€0.26matched
82capture01a1a0a8-101e-7f46-83e0-0c2a72250307€35.00€0.50matched
83capture01a1a0a8-3137-7979-b336-a75058b319aa€9.00€0.19matched
84capture01a1a0a8-463b-7723-9c74-bc07aaed72d4€35.00€0.50matched
85capture01a1a0a8-5af8-7c7a-96aa-50326b21927f€35.00€0.50matched
86refund01a1a0a8-5b91-7a73-b197-43beb7147a5d-€26.00€0.00matched
87capture01a1a0a8-93bd-7241-8ff3-aa07fe0f1e53€24.00€0.37matched
88capture01a1a0a8-c203-7bd8-a269-3f0a05c13b87€9.00€0.19matched
89capture01a1a0a8-e312-737f-87cd-b2e66e62600c€35.00€0.50matched
90capture01a1a0a8-e35c-7394-a0e4-35c7c649ab92€15.00€0.26matched
91capture01a1a0a8-f97d-7f99-970c-9968f70b0b16€24.00€0.37matched
92capture01a1a0a9-063f-72dc-891a-1687beda9450€35.00€0.50matched
93capture01a1a0a9-0b96-7d9c-a2a0-a5446f501d88€49.00€0.67matched
94capture01a1a0a9-130a-7436-b288-1ea5bde2b21f€9.00€0.19matched
95capture01a1a0a9-38e9-7ab8-a3bb-454e44a12d55€49.00€0.67matched
96capture01a1a0a9-6347-786a-9a05-6d097985ae45€15.00€0.26matched
97capture01a1a0a9-6616-70c6-8c32-60b2b6a6faa3€24.00€0.37matched
98capture01a1a0a9-80da-756f-9ee7-42e8d661b8a8€9.00€0.19matched
99capture01a1a0a9-8868-7fc4-b8ed-0232b64a70c7€15.00€0.26matched
100capture01a1a0a9-9985-7a3e-810c-37670b070472€24.00€0.37matched
101capture01a1a0a9-cd44-73b4-a6b4-c343ba10ce1a€9.00€0.19matched
102capture01a1a0a9-e0d2-7d52-b8d4-49fe478b7b40€9.00€0.19matched
103capture01a1a0a9-fb3d-720b-80c6-a187e830248b€49.00€0.67matched
104capture01a1a0aa-0848-7570-877f-f681af0bc676€9.00€0.19matched
105capture01a1a0aa-1d5f-7f62-b6e1-b6ba6699de28€49.00€0.67matched
106capture01a1a0aa-2392-7582-a0f3-fa8713c694a3€9.00€0.19matched
107capture01a1a0aa-2a8f-7a6e-85aa-16fd727adfd9€9.00€0.19matched
108capture01a1a0aa-43be-79e9-9a68-570f16c66afe€9.00€0.19matched
109capture01a1a0aa-4870-7e82-9df3-852a902566dc€9.00€0.19matched
110capture01a1a0aa-6598-7165-a4fa-ea44a4ab0838€15.00€0.26matched
111capture01a1a0aa-83d4-738b-ba28-dde06e3948af€24.00€0.37matched
112capture01a1a0aa-9d3b-7be3-a49a-ceadfd9eeb1c€35.00€0.50matched
113capture01a1a0aa-b2f1-7b46-b895-442231a0c1fa€15.00€0.26matched
114capture01a1a0aa-b631-7531-9988-c87a5183a2fc€24.00€0.37matched
115refund01a1a0aa-b670-7a9d-af1e-51c9b0e75bad-€6.00€0.00matched
116capture01a1a0aa-bd7c-7274-95b6-7939be56abb8€49.00€0.67matched
117capture01a1a0aa-ccf2-7ecc-9276-18bef82a4238€35.00€0.50matched
118capture01a1a0aa-d080-7fe8-9884-75ac2f5f1c40€9.00€0.19matched
119refund01a1a0ab-0852-7778-a0c5-76d706931eb2-€10.00€0.00matched
120capture01a1a0ab-1e72-710b-a308-d96b51a4e15c€9.00€0.19matched
121capture01a1a0ab-2897-7382-896f-c8220a29e19b€24.00€0.37matched
122capture01a1a0ab-39ea-725f-93d5-da8ba1360e29€15.00€0.26matched
123capture01a1a0ab-4f4e-7501-a32c-2945bb168c53€35.00€0.50matched
124capture01a1a0ab-7a1a-7ec7-85e9-c2a5f468922e€49.00€0.67matched
125capture01a1a0ab-7b44-704b-a624-6b06045d4893€24.00€0.37matched
126capture01a1a0ab-8619-7a20-9ab8-8eeb1a9d3b35€9.00€0.19matched
127capture01a1a0ab-93b6-7a1e-a72e-be4dea58cfba€9.00€0.19matched
128capture01a1a0ab-9da5-70c1-8b58-d3f4b3237d6a€35.00€0.50matched
129capture01a1a0ab-a5bd-769b-87ff-4a1abfd2b316€35.00€0.50matched
130capture01a1a0ab-b11a-7e43-91ae-91a19556e017€49.00€0.67matched
131capture01a1a0ab-c297-700c-978a-829db837e609€49.00€0.67matched
132capture01a1a0ab-c41a-77be-a5e1-d687a65801f3€15.00€0.26matched
133capture01a1a0ab-cec7-7f5f-b7dc-bb2720097197€15.00€0.26matched
134capture01a1a0ab-fefa-745d-bf2b-7c055b76f6c1€15.00€0.26matched
135capture01a1a0ab-f7b0-76cc-8872-2a99907a9404€9.00€0.19matched
136capture01a1a0ac-0ec0-7f25-aae1-72e8fda994bc€49.00€0.67matched
137capture01a1a0ac-0fd5-7a3f-9374-e2211d2ff675€49.00€0.67matched