Improve / enhance the accounting system in Google Sheets

Budget: 1000 UAH Deadline: 1 day

Good afternoon! 👋

I am ready to help with the optimization of your accounting system in Google Sheets and the automation of processes. I specialize in Google Sheets, App Script, and building dashboards.

🔹 What I offer

Analysis of the current structure – we will conduct a Zoom/Meet, look at how the tables are currently arranged, what the main difficulties are, and where errors most often occur.

Optimization and automation – based on the analysis, I will propose 2 options for modernization:

✅ Option 1. Automation within Google Sheets

Unification of structure: a single directory of currencies, banks, and counterparties.

Formulas + App Script: automatic loading of exchange rates, calculation of commissions, reconciliation of totals.

Consolidation in one pivot table or dashboard (for example, Google Data Studio/Looker Studio).

Reduction of the number of tabs, simplification of error searching.

✅ Option 2. Integrations and external automation

Connection to external sources (bank APIs, import from email, synchronization with Telegram).

Automatic sending of notifications about mismatched data or exceeding limits.

Export of results to Google Data Studio for convenient analytics and charts.

Ability to generate reports in PDF and send them via email.

🔹 Example of my work on automation (legal field)

For a law firm, I created a solution for working with documents:

lawyers uploaded files (Word/PDF) to Google Drive;

through App Script, the system automatically extracted key data (case number, counterparty, hearing date);

the data was entered into Google Sheets in a structured format;

then the table automatically generated a calendar of cases for each lawyer and notifications in Telegram about upcoming deadlines;

final reports were built in a dashboard, where the team's workload and progress on each case could be seen.

This approach allowed for a reduction of manual operations by 60–70% and eliminated the human factor in data transfer. Expand

Budget: 5000 UAH Deadline: 3 days

Good day. I will be happy to help. The necessary experience and skills are available. There are reviews in the profile. Write to me.

Budget: 5000 UAH Deadline: 5 days

Good day!
I confidently work with Google Sheets and their automation. I would like to understand the task in a bit more detail. I am indicating the price "off the top of my head," as I have not seen the spreadsheet.

Budget: 3000 UAH Deadline: 5 days

I have over 15 years of experience working as an analyst in the field of financial market research for tobacco products. During this time, my main task has been to collect, process, and analyze large datasets, as well as to create structured, readable reports for strategic decision-making. I have worked with multi-level tables, complex financial models, and ensured the accuracy and consistency of data in reports for management and partners.

Budget: 1500 UAH Deadline: 2 days

Good afternoon.

I have experience in data consolidation and analytics for cryptocurrency arbitrage business. In general, quite a few bots (which is my specialization) require processing information in Google Sheets using scripts.

I suggest we start by drafting a detailed technical specification.

Budget: 12000 UAH Deadline: 12 days

Hello. I can help with this issue, I have the listed experience and can implement AI if needed.

I would like to discuss the technical specifications in more detail.

Write to me. We can help.

Budget: 4500 UAH Deadline: 7 days

Hello, I have the necessary experience in designing and implementing accounting systems of varying complexity. I am well-versed in financial logic. My technical skills match the task description. Project details are important. Feel free to reach out.