System for financial management company budget - Excel + sql + power BI

Eat Fit
Eat Fit
Job category:
Other IT services
Expected budget:


Preferable skills:
data analysis
Valid until:

Job description

I will commission the preparation of a financial management system based on Microsoft Excel.

Project outline:

A spreadsheet for analyzing financial data - company budget statement of costs, revenues, margin calculations, production costs, controlling working hours, salaries, vacations, marketing data, roas, KPIs, forecasts, goals and their implementation.

Tasks to be performed and Functions:

Needs analysis, pricing and system design

Preparation of the backend of the system

Preparation of the display of reports in an accessible form

Preparation of data presentation in powerBI (not mandatory)

Integration with invoicing program after API

Integration with PostgreSQL sales and production system database

Integration with RCP system (work time recorder)

Due to the rather complex nature of the business - complex production, a large number of products and variables, marketing, sales. Experience in financial data analysis is welcome.

Required functions:

Postgresql integration, RCP, invoicing, downloading marketing data from google analytics,

Place or location:

remote work

Recent jobs from category Programming and IT

582 jobs in 9 categories Find a job

  • no avatar
    radomskinieruchomosci 3 deals
    Rental housing management software - CRM
    Proposed by freelancer
    I am looking for a company or freelancer to create a simple system for managing apartments for rent. Adding and cataloging properties (address, price, door code, availability, etc.). Contract management (tenant/owner data, contract period, attaching scans) Payment management (rent, electricity, tax, etc., with payment deadlines) Breakdowns (assignment to properties and description of breakdowns) Employees (income, number of properties, etc.) Two access categories: Employee/Administrator/Accounting. All solutions on the market are too complicated and inadequate for our needs.
  • no avatar
    Lingua Line 4 deals
    Streamlining corporate mailings
    Proposed by freelancer
    We are looking for support to get our mailings up and running. We are currently using SendBlaster mailing program and ovh server, but deliverability is poor. We have an email database of our own, but it is old.
  • no avatar
    Virtus Sun Polska 1 deal
    We are looking for a person who will be able to help us introduce Odoo for the company in terms of optimization and basic functionality (CRM, project management, field service). A service and trading company with about 40 users.
  • no avatar
    Jakub Kołaciński
    I am looking for a person who will hook up the author's code of the site to the API so that after placing an order, depending on what the customer has chosen, a delivery note is generated to the e-mail.
  • no avatar
    Hello. I need to create an automaton that will take data from google sheets and insert them on another page in forms, switch between pages and also press the same fields on the page. For the person who will help me I anticipate fair remuneration. I care about time! Thank you, best!
  • no avatar
    Parser + Prestashop/Magento optimization
    Proposed by freelancer
    I will commission the creation of a parser and connect it with the most efficient Presta/Magento store At the start there will be about 500 thousand products in the store with the possibility of expanding the store, These products will be loaded into the store by the parser. They will contain all the data that will be provided by the external API - name, description, price, parameters, etc. In addition, the panel should include currency converter functions (pounds, euros) with the ability to manually change the exchange rate + Margin level settings depending on the value of the product + adding an additional shipping fee. The parser should be adapted to the limited capabilities of the external API. The store itself should connect to a platform for management and navigation of the store like baselinker etc.
  • no avatar
    Byrdowski 1 deal
    3d graphic designer / 3d/2d animation CMS programmer including wp, joomla, shoper, magento, presta + putting up sites from scratch Separate post: Python programmers Fullstack Django highlights Javascript programmer (preferably react + vue.js) + (html + css advanced only :D) node.js + php Fullstack Marketing - performance marketing person, SEO, seo including fb-ads, google-ads, - social media ninja, - social media marketing, Separate post: - salesman here settlement on the basis of a fixed salary or % of sales
  • no avatar
    I am looking for someone to make: 1) Application - a graphical interface for a 50-inch touch screen 2) Interactive map for the touch screen to be placed on the website The touchscreen application would integrate and enable the inclusion of 4 other multimedia content, such as: 1. 4K nature videos, divided into categories. The videos would launch with visible controls and the ability to quickly return to the list/category of videos (videos are not part of the pricing). 2. movies-podcasts in 4K, visible as a list without categorization. The videos would launch with visible control controls and the ability to easily roll back to the list of videos (videos are not a valuation item). 3. interactive map 4. a virtual walkthrough made in html5, launched offline directly from the device, or launched through a web browser window (this is not part of the quote). The interface should be simple and easy to read, that is, the screen is divided into 4 parts with graphics representing the content, and each takes you to one of the 4 above productions. The requirements of the WCAG 2.1 standard must be met, i.e., among other things, the ability to change contrast, zoom in on interface elements, voice-read interface elements, and additional textual information. More to be discussed
  • no avatar
    DarekIT 1 deal
    I need a plugin to integrate WHMCS with inFakt after Api. Main assumptions: - creation of automatic invoice on inFakt after posting funds in whmcs. - assigning in WHMCS sequentially the numbering of the invoice from infakt - specifying on the invoice in infakt the type of payment - invoice adjustments - adding customers
  • no avatar
    Footer html - Outlook 365
    Proposed by freelancer
    We are looking for a person to implement html footer in Outlook 365.