Preparation of P&L and Balance Sheet for the year

I need a financial expert who can compile everything into a dashboard where I can see daily and monthly net profit broken down by each individual sales channel. I am the owner of an e-commerce project. We work with various traffic sources and marketplaces, and we also have a network of suppliers. Currently, there is a need to systematize financial accounting. What needs to be implemented: Create an automated or semi-automated spreadsheet in Google Sheets. The operations manager will enter basic input data daily, and the spreadsheet should automatically compile financial results. I have attached a photo of how the final result should look. Instead of product categories, there should be the traffic source. Input data: Sources: Rozetka, Prom, Epicentr, Google Ads, Hotline. Basic metrics: number of leads, statuses, purchase cost, margin. Advertising expenses (from accounts) and marketplace commissions. What needs to be implemented (columns for each source separately): Number of received and confirmed orders. Cost per acquisition (CPA). Advertising expenses and marketplace commission. Margin. ROAS / ROI. Net profit per day (Margin - [Advertising + Commissions]). Consolidated net profit for the month by each channel. Additional block (Finance): Cash Flow: recording actual income and expenses (to see the real cash flow). Balance: summarizing current balances in the company's accounts for each day. Final result: A fully prepared and configured Google Sheet. The areas for manual input by the manager should be protected from accidental deletion of formulas. Additionally, a short video instruction on daily filling of this spreadsheet or a call with the operations manager is required.

Hello. I am a sole proprietor, engaged in the trade of goods from China through my own website. I purchase goods through cargo companies or in Ukraine (less often). I received a request from the bank for financial monitoring. I provided some information myself, but after that, the request increased further) I need help preparing all the documents they are requesting. The freelancer needs to have prior experience with similar issues.

We need to connect a cash register system (PRRO) to an online store on the OpenCart 2.3.x platform. The specific one is not critical, but there is an account in Checkbox with a registered Trading Point, cash register, etc. We are using a simple CRM https://api.net.ua/. There are instructions for integration with Checkbox: https://api.net.ua/%d0%bf%d1%80%d0%be%d0%b3%d1%80%d0%b0%d0%bc%d0%bc%d0%bd%d1%8b%d0%b9-%d1%80%d1%80%d0%be-%d1%81heckbox-ua/ We use 3 types of payments: 1) online via LiqPay 2) transfer to the FOP account (as far as I understand, it does not require fiscalization) 3) cash on delivery via Nova Poshta Please write which PRRO you suggest for integration and the cost.

from 1-7-26 on VAT newly created 5 operations for 06-2026 prepare reports and submit and correctly prepare everything for VAT accounting (3-5 operations per month) without hired employees, only the director

Hello, I need to liquidate an LLC. It was created for grant funding, which was not received, with one founder. There are no hired employees, turnover is 0, and reports have not been submitted. Opened: November 2025, Kharkiv. In your proposals, please write about your experience and estimated time. The price can be discussed in private messages. Thank you.