Virtual Company Series // Chapter #1 - Finance

Apr 26 • n8n

The Virtual Company Project: Finance Department

The first block of the Virtual Company project will be the Finance Department. I've broken it down into four distinct functions to start, but there will be more—such as Financial Analyst and Payroll Specialist—in the future. Currently, I don't have enough data to simulate these additional roles.

The four roles:

Victor (Controller):This workflow will receive bank transactions in the form of bank statements and transfer this information into the accounting books for future reconciliation with Accounts Payable (AP) and Accounts Receivable (AR).

Donna (Accountant #1):This workflow will process invoices dropped into a specific Google Drive folder as PDFs. The flow will be triggered, run OCR to extract all data into a structured JSON format, and then add the information into a simulated ERP using Google Sheets.

Mark (Accountant #2):Similar to the invoice process, but focused on expenses. I also aim to implement a more dynamic method for inputting expenses, such as taking pictures and sending them via email, WhatsApp, or Telegram to the workflow, which will process them and add them to the books.

Andrew (CFO):This AI agent will manage and extract all information related to financial data. It will be capable of pulling data from all books and responding to financial data requests made by the AI Orchestrator agent (CEO). This agent will interact with human users indirectly via the orchestrator.

The workflows are currently at version 1. There are many improvements and additions that can be incorporated into the entire Virtual Company project for financial operations, but for now, I'm satisfied with the progress of this first block.

This is just a concept, but with a few adjustments tailored to the specific software and frameworks each company uses, it can be easily adapted for real-world application—which is the ultimate goal of this project.

Stay tuned for next chapter!

7 comments