When you get a lot of payments from customers on checks, things tend to get messy and clutter leads to forgetfulness and loss everywhere. It is a check that was never cashed or another that was cashed before the agreed day. Who lives this knows…
So a simple and very efficient way to keep information up to date is to use an excel check control spreadsheet. It's an easy-to-use tool that perfectly solves this small-big headache of financial management.
Here at Luz, we developed a spreadsheet with this specific function and I will show below how it works and can help you:
1. Checking Checks:
Of course, the essential and most important function of a check control worksheet is to record all that have been received associated with all the data needed for analysis. In our spreadsheet, we decided that it would be important to have the following items:
a) Date of Entry
b) Bank (with code), Agency and Customer Account
c) Check Value
d) Maturity Date
e) Date of Compensation
f) Status Control (Open, Overdue or Compensated)
g) Check Number
h) Name of the Issuer
i) CPF / CNPJ of the Issuer
j) Contact Phone
k) Field for observations
With checks being tracked one by one it is also interesting to have a global view that helps identify bigger issues like many open checks at one time or decrease the volume of receipts. That's why we create consolidated charts with the view month by month.
If you think this spreadsheet will help you, check out our demo version on this link!