> WHAT IT DOES
An Excel VBA workbook that builds and manages a full accounts-receivable workflow from a single macro. Enter invoice data in the AR Report sheet and generate professional PDF and XLSX invoices in one click — including VAT calculation, gross amounts, and organised output folders per invoice.
Multiple issuing entities are supported out of the box. Each entity holds its own address, VAT registration, and bank details in the OurAffiliates config table. A Treasury sheet aggregates receipts by entity and currency for a real-time cash overview.
> WORKBOOK STRUCTURE
- OurAffiliates — config table; one row per issuing legal entity with address, VAT number and bank details
- Customers — customer directory; one row per customer with full address details
- AR Report — invoice data entry; VAT Amount and Gross Amount are formula-driven from the net figure
- Invoice — print template populated at generation time via named ranges
- Invoice Manager — user-facing control panel with action buttons and invoice list
- Treasury — aggregated receipts report by issuing entity and settlement currency
> KEY FEATURES
- One-click generation of PDF and XLSX invoice files, saved in subfolders named by invoice number inside a user-selected output folder
- Automatic VAT and gross amount calculation from net entry in the AR Report
- Entity lookup: matches the issuing entity on each AR row to its address and bank details in OurAffiliates
- Customer lookup: matches customer name in AR Report to full address in the Customers directory
- Invoice template driven entirely by named ranges — layout changes never require code edits
- All column positions defined as named constants — no hardcoded column numbers anywhere in the codebase
- Text-format columns for invoice numbers, VAT numbers and postcodes prevent leading zeros being silently dropped
- Treasury tab auto-aggregates by entity and currency with subtotals and a grand total
- Entire workbook built at runtime by
InitializeWorkbook— clean slate deployment, no residual data in the template
Projects on this website are free to download for charities and non-profit organisations — please get in touch via the contact page.