Budget: 700 UAH Deadline: 1 day
Hello. I will easily and quickly complete your task. I am proficient in using both Excel and Google Sheets.
Main table accounting for cash and non-cash.
Columns:
| Date | Amount entered for the day | Withdrawn | Cash balance |
|---|
Details for the column “Amount entered for the day”:
Inside this column, visually divide it into two halves:
cash (green shade)
non-cash (blue shade)
This can be implemented through 2 merged cells or formatting with colored background/text.
Clearly label in the header:
💵 Cash (green) and 💳 Non-cash (blue)
— so that the administrator understands immediately.
Design:
Pleasant color palette, in a clear style.
Cash balance at the very bottom of the table, highlighted prominently, with conditional formatting:
positive balance — Red
negative — Gray, dull.
At the bottom of the table, the following is also automatically calculated:
💵 Total cash income for the month (in green),
💳 Total non-cash income (in blue),
🧾 Total earnings cash/non-cash
Additionally:
It may be possible to hide the information by default for total earnings, cash, non-cash and expand it when necessary, leaving only the Cash balance visible.
Important: the balance value must be calculated automatically:
Balance = (previous balance + cash - withdrawn)
There should be an “initial balance” at the beginning of the month, so it does not need to be entered manually.
Remains as is, only needs:
to be formatted in a unified style with the main sheet;
to add automatic calculation of total expenses for the month at the bottom;
expenses are not deducted from the cash register — they are simply recorded for information.
The number of rows (days) should automatically correspond to the number of days in the month.
When transitioning to a new month:
the old month automatically collapses or hides;
a new tab opens with the new month, the old one collapses (so it can be expanded and viewed at any time if necessary), if this is not possible, then just leave the month collapsing tabs as in the old sheet
All calculations are automatic (balance, amounts, totals).
The administrator only enters:
the amount entered (cash, non-cash),
the amount withdrawn.
The balance is calculated automatically.
Budget: 700 UAH Deadline: 1 day
Hello. I will easily and quickly complete your task. I am proficient in using both Excel and Google Sheets.
Budget: 1300 UAH Deadline: 1 day
Good day, I have extensive experience working with spreadsheets, ready to implement your project as quickly and efficiently as possible.
Budget: 2000 UAH Deadline: 2 days
Hello. I have extensive experience in developing and automating various financial spreadsheets and reports in Excel and Google Sheets. I am ready to complete the task, feel free to reach out.
Budget: 2000 UAH Deadline: 2 days
Good day! I have a lot of experience working with Excel!!! Feel free to contact me, I will complete it quickly, and most importantly - with quality!!!!!
Budget: 700 UAH Deadline: 2 days
Good day! I have experience in creating and working with such a table, I will do it quickly, efficiently, and in full compliance with the technical specifications. I am ready to start working right away. Feel free to reach out!
Budget: 1000 UAH Deadline: 3 days
Good day.
I will be happy to collaborate.
I will do it quickly and efficiently, write to me, we will discuss.
--------------------------
Budget: 1000 UAH Deadline: 1 day
Hello, I am ready to quickly and efficiently complete the task. I suggest discussing the details in private messages.
Budget: 4500 UAH Deadline: 7 days
I will do it, feel free to contact me.
================================================
Budget: 2000 UAH Deadline: 2 days
I work as a financial analyst in a large international company. I have experience creating such tables. I will help.
Budget: 3500 UAH Deadline: 3 days
Good evening!
I am ready to help with the implementation of your project.
I execute strictly according to the specifications, and if I see options for improvement, I will coordinate with you.
Budget: 1100 UAH Deadline: 2 days
Good evening
I am ready to help with the implementation of your project
I will execute everything clearly according to the specifications
After completion - I will be available for the implementation of new functionalities or projects
Budget: 2000 UAH Deadline: 2 days
Hello.
I have extensive experience working with Google Sheets and Excel.
I also create scripts for the aforementioned programs.
Check out my portfolio and reviews. Freelancehunt
I have reviewed the project. I am ready to help with the implementation.
Write to me - we will discuss the details.
Budget: 4000 UAH Deadline: 3 days
Good day. I have the necessary experience and skills. I will be happy to help. I will complete everything quickly and efficiently.
Budget: 1000 UAH Deadline: 5 days
Hello.
I have experience writing Google Apps Script.
I look forward to collaborating.
Budget: 1500 UAH Deadline: 5 days
Hello. I can help solve the task. I have extensive experience in building accounting systems and financial logic in spreadsheets. I will propose an optimal solution. Feel free to reach out.
Information Gathering 6 proposals 4 August
AI & Machine Learning 19 proposals 4 August
Online Stores & E-commerce 22 proposals 4 August
Information Gathering 6 proposals 4 August
Information Gathering 16 proposals 2 August