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

5 Nov, 08:00

Gross

€3,165.00

PSP fee

€48.91

Net to the bank

€3,116.09

Settlement journal

#394182

Breaks for a person to look at

  • duplicate linethe file lists it twicecapture:01a1aaba-8326-7280-a9fd-933957392068 is already settled by stl_EUR_2989777 line 1
LineKindReferenceGrossFeeStatus
1capture01a1aaaf-b8ff-7139-aa7a-7e1d30353e6e€24.00€0.37matched
2capture01a1aab1-4d45-7417-8543-2c76b4e8564f€35.00€0.50matched
3capture01a1aab3-e309-76af-a27c-c2db401b4997€9.00€0.19matched
4capture01a1aab7-c601-7db6-9f7d-a25cc14d013a€9.00€0.19matched
5capture01a1aab8-4da4-7ff3-a5b3-a3ea5613e599€15.00€0.26matched
6capture01a1aab8-cf73-7ecd-897e-a02724633aad€9.00€0.19matched
7capture01a1aab8-e21b-7fc3-be55-be2c817f235c€9.00€0.19matched
8capture01a1aab8-e300-75e0-ab2b-da329d0c3fee€24.00€0.37matched
9capture01a1aab8-ea82-7de5-abb2-23bfbcab9854€15.00€0.26matched
10capture01a1aab9-25ee-7423-8c35-9237f06989be€24.00€0.37matched
11capture01a1aab9-52eb-793b-b3cd-9487aefceb52€49.00€0.67matched
12capture01a1aab9-53fd-70cf-9ff1-5d2a298d4124€49.00€0.67matched
13capture01a1aab9-5d32-77da-b43e-d16c1ee42340€15.00€0.26matched
14capture01a1aab9-5d8d-7cf7-bfad-54f7aae9a752€24.00€0.37matched
15capture01a1aab9-49dc-7e1e-9ec0-b3ed536d1799€24.00€0.37matched
16capture01a1aab9-7280-7900-9e1d-ad90e069b3af€9.00€0.19matched
17capture01a1aab9-7b5c-75da-b3c0-b90cdbd2b08f€24.00€0.37matched
18capture01a1aab9-df2c-743c-9c13-1aeec47714cb€49.00€0.67matched
19capture01a1aab9-fc70-76ec-bc4c-39b8ea2ce245€49.00€0.67matched
20capture01a1aaba-1d9a-7768-8494-6e1bab8f54cc€49.00€0.67matched
21capture01a1aaba-1e59-731d-b83a-b27c583cb503€49.00€0.67matched
22capture01a1aaba-1df7-7a12-a408-eac3aea8471a€15.00€0.26matched
23capture01a1aaba-262b-72d9-a286-b2380b30ad03€35.00€0.50matched
24capture01a1aaba-2e08-78b5-bba7-80f532ee94d0€24.00€0.37matched
25capture01a1aaba-3832-7a80-a085-74c5098ed9ca€49.00€0.67matched
26capture01a1aaba-4069-727e-922a-bb8d538cb6c1€49.00€0.67matched
27capture01a1aaba-5406-7537-861b-71c35d4f958d€35.00€0.50matched
28capture01a1aaba-70a2-7c10-ac2f-d7258b9f51ab€24.00€0.37matched
29capture01a1aaba-7b5b-79cf-b83c-7bec9c9a13a9€49.00€0.67matched
30capture01a1aaba-7f91-7d1a-9e5d-f24de0732e7b€9.00€0.19matched
31capture01a1aaba-831b-73cf-a978-00b9a2c217fc€35.00€0.50matched
32capture01a1aaba-8f47-7f1e-a99c-a9764bef254a€15.00€0.26matched
33capture01a1aaba-9326-764d-928e-c78370ab258b€24.00€0.37matched
34capture01a1aaba-a66d-7dc2-a7ea-c5a57141d612€9.00€0.19matched
35capture01a1aaba-c5e9-7352-ad7a-0de7552c5247€24.00€0.37matched
36capture01a1aaba-d055-7a72-a735-74a397bc2d02€49.00€0.67matched
37capture01a1aaba-d05f-714c-9183-4a5a7de0e75f€24.00€0.37matched
38capture01a1aaba-ded4-719b-bbba-5b51272b274d€9.00€0.19matched
39capture01a1aaba-e9ad-7b4d-a79b-8f869f069eed€35.00€0.50matched
40capture01a1aaba-ee27-76ae-81be-c6de409dfb45€24.00€0.37matched
41capture01a1aabb-19ed-7cc6-af4f-356c526d2526€49.00€0.67matched
42capture01a1aabb-44eb-76b1-b1ea-22fd85715daf€9.00€0.19matched
43capture01a1aabb-502a-72e2-8f82-042d0b5d787c€35.00€0.50matched
44capture01a1aabb-5044-707f-b320-4a751f01a44c€24.00€0.37matched
45capture01a1aabb-50a8-7a5b-9b1c-453bd1b4bede€9.00€0.19matched
46capture01a1aabb-710f-7506-9e20-687579283aaf€9.00€0.19matched
47capture01a1aabb-7652-7597-8f3c-0e553ff7ce02€35.00€0.50matched
48capture01a1aabb-9baa-78e3-b314-826d16894667€35.00€0.50matched
49capture01a1aabb-a50c-75ec-b6da-d22d2443f56f€24.00€0.37matched
50capture01a1aabb-bfdc-70b3-a4b6-00912107f076€9.00€0.19matched
51capture01a1aabb-c43c-7f46-aeb7-11abb3819b79€15.00€0.26matched
52capture01a1aabb-d9d2-734d-a40a-c2359752e7ee€15.00€0.26matched
53capture01a1aabc-217c-7d14-b7c5-5c5cfced5a1d€49.00€0.67matched
54capture01a1aabc-27d0-7d80-baca-7b78a6915e6f€35.00€0.50matched
55capture01a1aabc-3b2c-75f8-b634-95b7d1fd6ff1€49.00€0.67matched
56capture01a1aabc-63bc-7184-a494-b5607ffaba21€24.00€0.37matched
57capture01a1aabc-76ab-7583-bd1b-b764ad81e6b5€35.00€0.50matched
58capture01a1aabc-7aba-7f1c-94e1-e3b0cc2b4082€15.00€0.26matched
59refund01a1aabc-9789-7688-b12b-dd5d73d493ce-€20.00€0.00matched
60capture01a1aabc-a3da-7369-b659-c7d345efbd47€9.00€0.19matched
61capture01a1aabc-b45b-7a67-b6b9-27871db8d846€24.00€0.37matched
62capture01a1aabc-bb7a-74f7-ae81-14c3b2260682€15.00€0.26matched
63capture01a1aabc-c1fa-7738-9e6e-8c9af23267c8€15.00€0.26matched
64capture01a1aabc-d4e7-7f66-8b5f-c7e11db36dfe€9.00€0.19matched
65refund01a1aabc-e901-7699-9c30-30761a9a25ff-€7.00€0.00matched
66capture01a1aabd-0309-7379-b6da-9ea4dcbb79ed€49.00€0.67matched
67capture01a1aabd-1959-786e-82d8-46ae35cae790€49.00€0.67matched
68capture01a1aabd-2c5c-7875-962b-d7320c14b89d€35.00€0.50matched
69capture01a1aabd-2f23-7363-98fa-756913796cb7€24.00€0.37matched
70capture01a1aabd-596a-7060-b37c-193118457db8€9.00€0.19matched
71capture01a1aabd-777f-75a5-97d6-aad910af1e87€9.00€0.19matched
72refund01a1aabd-8378-723e-8a6f-b876bbe0d617-€33.00€0.00matched
73refund01a1aabd-8d52-7edd-8e49-a17cdf45cd72-€6.00€0.00matched
74refund01a1aabd-b210-7fa2-8b66-0222d122a181-€5.00€0.00matched
75capture01a1aabd-bb11-7393-8712-d8adc94e6331€35.00€0.50matched
76capture01a1aabd-c6ad-76e9-8c52-f984e8ca28a0€49.00€0.67matched
77capture01a1aabd-c7a5-70f3-bfa7-c37ffabd510a€49.00€0.67matched
78capture01a1aabd-ecb3-7c78-88c4-417d9561c2ec€24.00€0.37matched
79capture01a1aabd-eefa-7cc3-a0d4-a073e476afd3€35.00€0.50matched
80capture01a1aabe-0099-7996-af17-55610bc65d06€9.00€0.19matched
81refund01a1aabe-090b-7c82-b7ca-3605c1cf235a-€11.00€0.00matched
82capture01a1aabe-0a54-7299-bf36-c9e6832d09d5€35.00€0.50matched
83capture01a1aabe-1352-793f-9a83-78fc7846d3a6€15.00€0.26matched
84capture01a1aabe-1675-771b-bb3f-1027618bd46b€49.00€0.67matched
85capture01a1aabe-4188-77cc-86ed-eb2fed211f41€35.00€0.50matched
86capture01a1aabe-99b8-7c9c-8843-7d38acba8bcd€24.00€0.37matched
87capture01a1aabe-b944-7b66-bbe8-8a8a45d4c81d€24.00€0.37matched
88capture01a1aabe-bf30-7d68-9c10-a7ac356be737€35.00€0.50matched
89capture01a1aabe-ceaa-7c6e-9b80-7f7b85c26423€15.00€0.26matched
90capture01a1aabe-d01f-7dc7-b250-0950d3186456€35.00€0.50matched
91capture01a1aabe-d820-747e-b884-ddf07302a2cf€35.00€0.50matched
92capture01a1aabf-2ec3-7a40-b6fe-a3c42f3b3424€24.00€0.37matched
93capture01a1aabf-4870-729a-b02c-fc55b6ac54c8€49.00€0.67matched
94capture01a1aabf-57d1-7a82-bcb9-ae8085b769e4€24.00€0.37matched
95capture01a1aabf-727a-7110-8353-d02fa302eb71€35.00€0.50matched
96refund01a1aabf-b784-7768-8aa9-afbc1a885e0e-€23.00€0.00matched
97capture01a1aabf-c6d4-78bb-9bcc-fbdca8182288€9.00€0.19matched
98capture01a1aabf-f7ba-7042-adad-b4b2479ed3fc€24.00€0.37matched
99capture01a1aac0-0e47-75ff-82d9-f9c7534b999f€49.00€0.67matched
100capture01a1aac0-2305-737f-9bc9-cdec6948499b€35.00€0.50matched
101capture01a1aac0-3726-73b7-bef2-6f485620c677€9.00€0.19matched
102capture01a1aac0-3f2e-7922-a2d0-f7aefd09f9be€24.00€0.37matched
103capture01a1aac0-3fb2-7137-971c-68d76771c3d9€15.00€0.26matched
104capture01a1aac0-5efc-7f1f-ae0a-67cd91feef4c€15.00€0.26matched
105capture01a1aac0-62fe-7695-9160-5bdf3c0827d7€35.00€0.50matched
106capture01a1aac0-6cfa-700f-af8f-f66d180e5281€24.00€0.37matched
107capture01a1aac0-a115-7863-bbc8-09fcb8886f39€35.00€0.50matched
108capture01a1aac0-c5db-7cc6-b7b8-bba717e6925d€49.00€0.67matched
109capture01a1aac0-c6c3-738a-8ded-23bf1ed0c5c5€24.00€0.37matched
110capture01a1aac0-c772-7db9-8535-078048595990€9.00€0.19matched
111capture01a1aac0-d829-7009-91e6-ed19867f5b26€35.00€0.50matched
112capture01a1aac1-089a-7619-9c21-e8b58f916285€49.00€0.67matched
113capture01a1aac1-29c1-70c8-bbde-9686e988b765€24.00€0.37matched
114capture01a1aac1-41db-7b48-83ba-3edca9f606f4€15.00€0.26matched
115capture01a1aac1-51fa-75cd-86f0-f96a8300598d€24.00€0.37matched
116capture01a1aac1-68b2-74f8-85d0-332f7a4c29be€24.00€0.37matched
117capture01a1aac1-704f-75e0-a237-7dfaab7e707e€24.00€0.37matched
118capture01a1aac1-7dcc-775e-93a2-62a69bd642ea€35.00€0.50matched
119capture01a1aac1-9571-7230-bb80-dfc01186e252€15.00€0.26matched
120capture01a1aac1-a3a4-7a3b-bd6b-83ce5a1cdb9f€35.00€0.50matched
121capture01a1aac1-a556-741e-bab6-dae24d5b6b7a€24.00€0.37matched
122capture01a1aac1-b629-7c29-be15-6f6288f4bad4€24.00€0.37matched
123capture01a1aac1-c06a-7188-9d99-99c2fb212089€35.00€0.50matched
124capture01a1aac1-c460-7cae-9933-aca9d3b99d4a€35.00€0.50matched
125capture01a1aac1-c527-7190-a05a-43f4be17ccdd€24.00€0.37matched
126capture01a1aac1-ebfd-7ed0-ad36-ba2db430ac69€35.00€0.50matched