Generate Accounting Reports

Generate Accounting Reports

Access financial reports, manage fiscal years, and configure accounting settings.

Time: 5–15 minutes per report Module: Account Accountant Permissions: Accountant, Advisor, or Auditor

---

Prerequisites

• Chart of accounts configured
• Fiscal year defined
• Transactions recorded
• Access to Accounting menu

---

Overview

The Account Accountant module enables:

• Financial reporting
• Fiscal year management
• Lock date controls
• Anglo-Saxon accounting option
• Balance sheet generation
• Profit & loss statements
• Trial balance reports

---

Key Concepts

Concept	Description
Fiscal Year	Accounting period (usually 12 months)
Lock Date	Prevents changes before date
Anglo-Saxon	Inventory valuation method
Chart of Accounts	Account structure

---

Steps

1. Configure Fiscal Year

1. Navigate to Accounting → Configuration → Fiscal Years
2. Click New
3. Define fiscal year:

Field	Action
Name	Fiscal year name (e.g., “FY 2024”)
Start Date	First day of year
End Date	Last day of year
Company	Select company

4. Click Save

2. Set Lock Dates

Prevent modifications to past periods:

1. Navigate to Accounting → Configuration → Settings
2. Configure lock dates:

Field	Description
Tax Lock Date	Lock tax entries before
Sales Lock Date	Lock sales entries before
Purchase Lock Date	Lock purchase entries before
Hard Lock Date	Absolute lock for all
Fiscal Year Lock	Lock entire fiscal year

3. Click Save

3. Generate Balance Sheet

1. Navigate to Accounting → Reporting → Balance Sheet
2. Set parameters:

Field	Action
Date	Report date
Comparison	Previous period (optional)
Company	Select company

3. Click Generate
4. View or export report

4. Generate Profit & Loss

1. Navigate to Accounting → Reporting → Profit and Loss
2. Set parameters:

Field	Action
Date From	Period start
Date To	Period end
Comparison	Compare periods

3. Click Generate
4. Analyze income vs expenses

5. Generate Trial Balance

1. Navigate to Accounting → Reporting → Trial Balance
2. Configure:

Field	Action
Date Range	Reporting period
Target Moves	All/Posted entries
Account Type	Filter by type

3. Click Generate
4. Verify debits = credits

6. Generate General Ledger

1. Navigate to Accounting → Reporting → General Ledger
2. Set filters:

Field	Action
Date Range	Period
Accounts	Specific or all
Partners	Filter by partner

3. Click Generate
4. View account-wise transactions

7. Configure Anglo-Saxon Accounting

If using Anglo-Saxon method:

1. Navigate to Accounting → Settings

2. Enable Use Anglo-Saxon Accounting

3. Configure:

   • Input accounts for goods
   • Output accounts for goods
   • Stock valuation accounts

4. Click Save

---

Field Reference

Fiscal Year (account.fiscal.year)

Field	Technical Name	Type	Required	Description
Name	name	Char	Yes	Year name
Start Date	date_from	Date	Yes	Period start
End Date	date_to	Date	Yes	Period end
Company	company_id	Many2one	Yes	Company

Settings (res.config.settings)

Field	Technical Name	Type	Description
Anglo-Saxon	anglo_saxon_accounting	Boolean	Enable method
Fiscal Year Day	fiscalyear_last_day	Integer	Year end day
Fiscal Year Month	fiscalyear_last_month	Selection	Year end month
Tax Lock Date	tax_lock_date	Date	Tax lock
Sales Lock Date	sale_lock_date	Date	Sales lock
Purchase Lock Date	purchase_lock_date	Date	Purchase lock
Hard Lock Date	hard_lock_date	Date	Absolute lock
Fiscal Year Lock	fiscalyear_lock_date	Date	FY lock
Enable Fiscal Years	group_fiscal_year	Boolean	Custom FY

---

Standard Reports

Report	Description
Balance Sheet	Assets, liabilities, equity
Profit & Loss	Income and expenses
Trial Balance	Account balances verification
General Ledger	Detailed transactions
Partner Ledger	Customer/vendor balances
Aged Receivable	Outstanding receivables
Aged Payable	Outstanding payables
Cash Flow	Cash movement statement

---

Views Available

View	Features
List	Financial records
Form	Entry details
Pivot	Analysis table
Graph	Visual charts

Accounting Dashboard

Shows:

• Bank balances
• Outstanding invoices
• Bills to pay
• Key metrics

---

Educational Institution Reports

Fee Collection Summary

Report: Fee Collection
Period: Academic Year 2024
Grouping: By Course, By Month

Shows:
- Fees invoiced
- Fees collected
- Outstanding fees
- Collection rate

Department-wise Expenses

Report: Department Expenses
Period: FY 2024
Grouping: By Department

Shows:
- Salary costs
- Operational costs
- Capital expenses
- Budget variance

---

Troubleshooting

Issue	Cause	Solution
Cannot post entry	Lock date	Check lock settings
Unbalanced entry	Debit ≠ Credit	Fix entry amounts
Missing accounts	Not configured	Add to chart
Report empty	No transactions	Verify date range
Wrong figures	Filter issue	Check report filters

---

Best Practices

1. Regular closing: Close periods monthly
2. Lock dates: Set after reconciliation
3. Backup before close: Save data
4. Verify totals: Check trial balance
5. Document adjustments: Note changes
6. Audit trail: Maintain records

---

Security Notes

Role	Capabilities
Accountant	Day-to-day accounting
Advisor	Review and advise
Auditor	Audit access
Manager	Full control

---

Related Tasks

• Manage Fee Collection
• Configure Budget
• Manage Assets