MS Access Accounting

Microsoft Access Database for accounting for multiple oil & gas wells:



General Requirements

Data Tables must LOCK prior year data to prevent edit of old data.
System must know what accounting year is active (only 1 year can be active at a time).
Inception to date reporting.


Input Forms needed:

Property Data Entry
Property Data Edit
Revenue Data Entry
Revenue Data Import (from Excel)
Expense Data Entry
Revenue Data Import (from Excel)
General Ledger Entry
Output Reports needed:

1 line report (export to excel)
Monthly P&L by property (for all props, or just a single property)
With Year end totals and ITD
Monthly P&L summary (for all props, or just a single property)
With Year end totals and ITD
Annual P&L by property (with or without prior year comparison)
Annual P&L by summary (with or without prior year comparison)
Tables:

Property List
Division Orders
Revenue
Expense