Controlling Checks with a Spreadsheet

Excel Spreadsheets

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

How to Handle Checks with an 1 Spreadsheet

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.

How to Handle Checks with an 2 Spreadsheet

If you think this spreadsheet will help you, check out our demo version on this link!

Excel Spreadsheets


Please, write your comment
Please enter your name