Advanced Excel VBA Accounting System

Project Title

Excel Accounts Receivable System with VBA Automation

Project Description

We are a small startup looking for an experienced Excel developer with strong financial accounting knowledge, advanced Excel skills, and VBA (Visual Basic for Applications) expertise to build a custom Accounts Receivable Excel workbook.

We have a reference video showing the type of Excel application we want (a complete Accounts Receivable management solution built in Excel). The ideal developer must be able to replicate similar functionality and expand it based on our business needs.


Objectives

You will build a systematic, automated, and user-friendly Accounts Receivable workbook that:

Core Features

• Accepts customer and invoice data entry
• Tracks invoices, due dates, and payment statuses
• Calculates aging of receivables (e.g., 0-30, 31-60, 61-90, 90+ days)
• Organizes data in tables and dashboards
• Records partial and full customer payments
• Automatically updates outstanding balances
• Includes printable reports (summary, aging report, customer balances)

Automation (VBA)

• Auto-generate unique invoice IDs
• Buttons or menu options to:

Add new invoice records

Enter payments

Refresh reports

Recalculate aging and totals
• Error handling and input validation
• Optional alerts for overdue accounts

Usability

• Clean interface with navigation buttons
• Clear instructions and tooltips
• Colored conditional formatting (current/overdue/etc.)
• Well-documented code (comments) and separate code modules

Documentation

• A short user guide (PDF or text)
• Developer comments in VBA

Skills Required

The ideal applicant should have:

Strong Excel experience: advanced formulas, pivot tables, data tables
VBA expertise: creating forms/buttons, automation, data validation
Financial accounting background: familiarity with accounts receivable concepts
Good communication skills: to clarify requirements and deliver regular updates

Deliverables

Excel Workbook (.xlsm)

Fully functional AR system with VBA features

User Guide

Clear instructions for using the file

VBA Code Documentation

Commented code for future maintenance

Timeline

Please include an estimated delivery time with your proposal.

Budget: 40 €

Include your proposed price and payment terms.

Proposal Requirements

When submitting your bid, include:

A short summary of relevant experience
Examples of previous Excel/VBA/Accounting projects
Confirmation you can build a similar system
Any questions you have before starting

Example Reference

This is the kind of Excel Accounts Receivable application we want to emulate: How To Create An Accounts Receivable Application And Manage Payments In Excel (https://www.youtube.com/watch?v=AQF300aevfY).