DRKDS Accounting

Complete User Manual & Training Guide

Professional Accounting Reports for Odoo 19 Community Edition

📚 Version 19.1.1.0.0 📅 Last Updated: January 2026 📄 Comprehensive Training Documentation

📑 Table of Contents

Chapter 1: Introduction

Understanding DRKDS Accounting and its capabilities

1.1 What is DRKDS Accounting?

A comprehensive overview of the module and its purpose

DRKDS Accounting is a professional-grade accounting reports module designed specifically for Odoo 19 Community Edition. It fills the gap between basic Odoo accounting and enterprise-level reporting needs, providing small and medium businesses with powerful financial reporting tools previously only available in expensive enterprise solutions.

Why DRKDS Accounting?

Odoo Community Edition provides excellent core accounting functionality, but lacks comprehensive reporting features. DRKDS Accounting bridges this gap by providing:

📊 Professional PDF Reports

Generate beautiful, professionally formatted PDF reports for:

  • Financial statements (Balance Sheet, P&L)
  • Ledger reports (General, Partner)
  • Analysis reports (Aged Balance, Tax)
  • Audit reports (Journal Audit)

📅 Daily Transaction Reports

Monitor daily business activities with:

  • Day Book - All daily transactions
  • Cash Book - Cash movement tracking
  • Bank Book - Bank transaction monitoring

📧 Customer Follow-up System

Automate collections with:

  • Multi-level reminder system
  • Automated email reminders
  • Printable follow-up letters
  • Manual action assignments

🔍 Complete Audit Trail

Track every change with:

  • Before/after value tracking
  • User activity monitoring
  • IP address logging
  • Severity classification

Target Users

User Type How They Benefit
Accountants Generate accurate financial reports quickly, track all transactions, maintain complete audit trails
Finance Managers Monitor financial health, analyze trends, compare periods, make informed decisions
Business Owners Understand profitability, track cash flow, review customer payments
Auditors Access complete transaction history, verify changes, review audit logs
Credit Controllers Manage customer collections, send reminders, track overdue accounts

1.2 Key Features Overview

Detailed breakdown of all module capabilities

Financial Reports (PDF)

Report Purpose Key Features When to Use
Trial Balance Verify that debits equal credits • All accounts with balances
• Filter by date range
• Filter by journals
• Analytic account filter
Month-end closing, audit preparation, balance verification
General Ledger Detailed transaction listing by account • Transaction-by-transaction view
• Initial balance option
• Sort by date or journal
• Running balance
Account analysis, transaction review, audit evidence
Partner Ledger Customer/vendor transaction history • Receivable/Payable filter
• Multi-currency support
• Reconciliation status
• Partner-wise totals
Customer statements, vendor reconciliation, aging analysis
Aged Partner Balance Analyze overdue amounts by age • Configurable period length
• 5 aging buckets
• Receivable/Payable views
• Partner-wise breakdown
Credit management, collection prioritization, risk assessment
Balance Sheet Financial position at a point in time • Assets/Liabilities/Equity
• Period comparison
• Hierarchical structure
• Debit/Credit columns
Financial reporting, stakeholder reports, loan applications
Profit & Loss Income and expenses for a period • Revenue/Expense breakdown
• Period comparison
• Net profit calculation
• Category grouping
Performance analysis, budgeting, management reporting
Tax Report Tax summary for filing • Net amounts
• Tax amounts
• By tax type
• Period-based
Tax filing, GST/VAT returns, compliance
Journal Audit Journal entry listing • All journal entries
• Sort options
• Journal filter
• Entry details
Audit preparation, transaction verification

Daily Reports

Report Purpose Contents Best Used For
Day Book All transactions for selected days Date, Entry, Account, Partner, Debit, Credit Daily reconciliation, transaction review
Cash Book Cash journal transactions Opening balance, Receipts, Payments, Closing balance Cash reconciliation, petty cash management
Bank Book Bank journal transactions Opening balance, Deposits, Withdrawals, Closing balance Bank reconciliation, payment tracking

Follow-up Management

📋 Multi-Level Follow-ups

  • Configure unlimited follow-up levels
  • Set days after due date for each level
  • Customize message for each level
  • Automatic level progression

📧 Communication Options

  • Automated email sending
  • Printable follow-up letters
  • Manual action assignments
  • Customizable email templates

👥 Partner Management

  • View partner follow-up status
  • Track follow-up history
  • Assign payment responsible
  • Schedule next actions

📊 Reporting & Analysis

  • Follow-up statistics
  • Overdue invoice tables
  • Action summaries
  • Process results tracking

Audit Logging

Complete Audit Trail

Every create, update, and delete operation is logged with full details including user, timestamp, old values, new values, and IP address. This provides complete traceability for compliance and audit purposes.

Audit Feature Description Benefit
Action Tracking Records create, update, delete operations Know what happened to any record
Value Changes Captures before and after values See exactly what changed
User Attribution Records which user made changes Accountability for all changes
Timestamp Logging Precise date/time of each action Timeline reconstruction
IP Address Records user's IP address Security and access tracking
Category Classification Groups logs by functional area Easy filtering and analysis
Severity Levels Info, Warning, Critical ratings Focus on important changes

1.3 System Requirements

Technical prerequisites for installation

Software Requirements

Component Requirement Notes
Odoo Version 19.0 Community Edition Not compatible with Enterprise Edition features
Python 3.10 or higher As required by Odoo 19
PostgreSQL 14.0 or higher As required by Odoo 19
Dependencies account module Must be installed before DRKDS Accounting
Additional Dependencies mail module Required for follow-up email functionality

Browser Support

Browser Minimum Version Status
Google Chrome 90+ Recommended
Mozilla Firefox 88+ Recommended
Microsoft Edge 90+ Supported
Safari 14+ Supported
Internet Explorer Any Not Supported
Important Note

PDF report generation requires wkhtmltopdf to be properly installed and configured on your Odoo server. Most Odoo installations include this by default, but if reports are not generating, verify wkhtmltopdf installation.

1.4 Who Should Use This Module?

Understanding your role and how DRKDS Accounting helps you

👤 For Accountants & Bookkeepers

Your daily challenges:

  • Need to generate accurate financial reports quickly
  • Must track all transactions for audit purposes
  • Have to reconcile accounts regularly
  • Need to maintain complete documentation

How DRKDS Accounting helps:

  • Generate Trial Balance to verify books are balanced
  • Create General Ledger for detailed transaction review
  • Use Daily Reports for quick reconciliation
  • Access Audit Logs to track all changes

Reports you'll use most:

  • Trial Balance (daily/weekly)
  • General Ledger (weekly/monthly)
  • Day Book, Cash Book, Bank Book (daily)
  • Partner Ledger (as needed)

👔 For Finance Managers

Your daily challenges:

  • Need visibility into company's financial health
  • Must report to management and stakeholders
  • Have to manage cash flow and collections
  • Need to compare performance across periods

How DRKDS Accounting helps:

  • Generate Balance Sheet and P&L for financial health assessment
  • Use period comparison for trend analysis
  • Monitor Aged Receivables for collection management
  • Review Audit Logs for team activity monitoring

Reports you'll use most:

  • Balance Sheet (monthly/quarterly)
  • Profit & Loss (monthly/quarterly)
  • Aged Partner Balance (weekly)
  • Follow-up Reports (weekly)

💼 For Business Owners

Your concerns:

  • Is my business profitable?
  • How much do customers owe me?
  • What's my cash position?
  • Are my finances being managed properly?

How DRKDS Accounting helps:

  • Profit & Loss shows exactly how much you're earning
  • Aged Receivables shows who owes you money and for how long
  • Cash Book gives instant visibility into cash position
  • Audit Logs ensure accountability for all financial actions

Reports you'll want to see:

  • Profit & Loss summary (weekly/monthly)
  • Aged Receivables summary (weekly)
  • Cash position (daily)

🔍 For Auditors

Your requirements:

  • Complete transaction history
  • Ability to verify any transaction
  • Change tracking and user attribution
  • Reliable, consistent reporting

How DRKDS Accounting helps:

  • General Ledger provides complete transaction detail
  • Journal Audit shows all journal entries
  • Audit Logs track every change with before/after values
  • Reports are consistent and professionally formatted

Reports you'll need:

  • Trial Balance (year-end)
  • General Ledger (full year)
  • Journal Audit (full year)
  • Audit Logs (full year)

📞 For Credit Controllers

Your daily tasks:

  • Identify overdue customers
  • Send payment reminders
  • Track collection progress
  • Escalate problematic accounts

How DRKDS Accounting helps:

  • Aged Receivables instantly shows who's overdue and by how much
  • Follow-up system automates reminder emails
  • Partner Ledger provides complete customer history
  • Manual actions help track escalations

Features you'll use daily:

  • Aged Receivable Report
  • Follow-up Processing
  • Partner Follow-up Status
  • Email Templates

Chapter 2: Getting Started

Installation, setup, and your first steps with DRKDS Accounting

2.1 Installation Guide

Complete step-by-step installation instructions

Admin Only This section requires administrator access

Pre-Installation Checklist

Requirement How to Verify
Odoo 19 Community installed Check Settings > General Settings > Version
Accounting (Invoicing) module installed Check Apps > Installed > Search "Invoicing"
Administrator access Can access Settings menu
Developer Mode enabled Settings > Activate Developer Mode
Module files in addons directory Check server addons path

Installation Methods

Method 1: Web Interface Installation (Recommended)

1
Enable Developer Mode

Why: Developer mode is required to update the apps list and see all available modules.

How:

  1. Go to Settings (gear icon in top menu)
  2. Scroll to the bottom of the page
  3. Click "Activate the developer mode"
  4. The page will reload with additional options visible
Screenshot: Activating Developer Mode
Settings page showing the "Activate developer mode" link at the bottom
Tip

You can also activate developer mode by adding ?debug=1 to the URL, e.g., https://yourserver.com/web?debug=1

2
Update Apps List

Why: Odoo needs to scan the addons directories to find newly added modules.

How:

  1. Go to Apps menu
  2. Click the "Update Apps List" menu item (only visible in developer mode)
  3. In the popup, click "Update"
  4. Wait for the process to complete (may take a few seconds)
Screenshot: Update Apps List
Apps menu showing the Update Apps List option
3
Search for DRKDS Accounting

How:

  1. In the Apps page, clear any existing filters by clicking "x" on the "Apps" filter
  2. In the search box, type "DRKDS Accounting"
  3. Press Enter or click the search icon
  4. You should see the DRKDS Accounting module in the results
Screenshot: Finding DRKDS Accounting
Apps search results showing DRKDS Accounting module
Can't find the module?
  • Make sure the module folder is in your Odoo addons path
  • Verify the folder name is exactly drkds_accounting
  • Try restarting the Odoo service
  • Check server logs for any errors
4
Install the Module

How:

  1. Click on the DRKDS Accounting module card
  2. Click the "Install" button
  3. Wait for installation to complete (progress bar will show)
  4. The page will automatically redirect when done
Screenshot: Installing DRKDS Accounting
Module detail page with Install button highlighted

What happens during installation:

  • Database tables are created for audit logs and follow-ups
  • Menu items are added to the Accounting menu
  • Report templates are registered
  • Security groups are configured
  • Email templates are created
5
Verify Installation

How to verify:

  1. Go to the Accounting menu
  2. Check for new menu items under Reporting:
    • Financial Reports
    • Partner Reports
    • Audit Reports
    • Daily Reports
  3. Check under Configuration:
    • Follow-up Levels
    • Audit Logs
Success!

If you can see all these menu items, DRKDS Accounting is installed correctly and ready to use.

Method 2: Command Line Installation

For server administrators who prefer command-line installation:

Step 1: Copy module to addons directory
# Navigate to your addons directory
cd /home/odoo/addons

# Copy or clone the module
cp -r /path/to/drkds_accounting ./

# Verify the folder structure
ls -la drkds_accounting/
Step 2: Update Odoo configuration (if needed)
# Edit odoo.conf to include addons path
sudo nano /etc/odoo/odoo.conf

# Ensure addons_path includes your directory:
# addons_path = /home/odoo/odoo/addons,/home/odoo/addons
Step 3: Install via command line
# Stop Odoo service
sudo systemctl stop odoo

# Install the module
/home/odoo/odoo-venv/bin/python3 /home/odoo/odoo/odoo-bin \
    -c /etc/odoo/odoo.conf \
    -d your_database_name \
    -i drkds_accounting \
    --stop-after-init

# Start Odoo service
sudo systemctl start odoo
Step 4: Check installation log
# View recent logs
sudo tail -100 /var/log/odoo/odoo.log | grep -i drkds

# Should see:
# Loading module drkds_accounting
# Module drkds_accounting loaded successfully

Post-Installation Configuration

After installation, complete these configuration steps:

Task Location Priority
Assign user permissions Settings > Users > Select user > Access Rights Required
Configure follow-up levels Accounting > Configuration > Follow-up Levels Recommended
Review financial report structure Accounting > Configuration > Financial Reports Optional
Customize email templates Settings > Technical > Email > Templates Optional

2.2 First Login & Initial Setup

What to do after installation

Accessing DRKDS Accounting Features

After installation, DRKDS Accounting features are integrated into the standard Accounting menu. Here's how to access each area:

Access Trial Balance, Balance Sheet, Profit & Loss reports

Access Partner Ledger, Aged Receivable, Aged Payable reports

Access General Ledger, Journal Audit, Tax Report

Access Day Book, Cash Book, Bank Book

View customers requiring follow-up

Process and send follow-up reminders

View and analyze audit trail

Initial Setup Checklist

✅ Verify Accounting Data

Before generating reports, ensure your accounting data is properly set up:

  • Chart of Accounts: Verify accounts are correctly categorized (asset, liability, equity, income, expense)
  • Journals: Ensure journal types are correct (sales, purchase, cash, bank, general)
  • Partners: Customers and vendors have correct information
  • Posted Entries: Confirm journal entries are posted (not in draft)

Quick Verification

Generate a Trial Balance report. If it shows your expected accounts with balances, your basic setup is correct.

✅ Configure Follow-up Levels

Set up your payment reminder schedule:

  1. Go to Accounting → Configuration → Follow-up Levels
  2. If no configuration exists, create one for your company
  3. Add follow-up lines with different delay days and actions

Suggested initial configuration:

Level Name Days After Due Email Letter
Polite Reminder 7 -
First Notice 15
Second Notice 30
Final Notice 45

✅ Assign User Permissions

Grant appropriate access to your team members:

  1. Go to Settings → Users & Companies → Users
  2. Select each user
  3. In the Access Rights tab, set Accounting permissions:
    • Show Accounting: Basic read access
    • Accountant: Full operational access
    • Advisor: Administrative access
  4. Save changes

✅ Generate First Report

Test your installation by generating a Trial Balance:

  1. Go to Accounting → Reporting → Financial Reports → Trial Balance
  2. Select your company
  3. Leave date fields empty (for all time) or set a date range
  4. Select "All Posted Entries" for Target Moves
  5. Click "Print"
  6. A PDF should download with your Trial Balance
Congratulations!

If the PDF generated successfully with your accounting data, DRKDS Accounting is fully operational.

2.4 Quick Start Guide

Get productive in 10 minutes

5 Reports Every User Should Know

Trial Balance
General Ledger
Aged Receivable
P&L
Balance Sheet

Quick Report Guide

📊 Trial Balance - Verify Books Balance

When to use: Daily/weekly to verify accounting accuracy

Quick steps:

  1. Go to Reporting → Financial Reports → Trial Balance
  2. Set End Date to today
  3. Select "All Posted Entries"
  4. Click Print

What to check: Total Debits should equal Total Credits

📒 General Ledger - Transaction Details

When to use: When you need to see all transactions for an account

Quick steps:

  1. Go to Reporting → Audit Reports → General Ledger
  2. Set date range
  3. Check "Include Initial Balances" if needed
  4. Select "With movements" for Display Account
  5. Click Print
⏰ Aged Receivable - Overdue Amounts

When to use: Weekly to manage collections

Quick steps:

  1. Go to Reporting → Partner Reports → Aged Receivable
  2. Set Start Date to today
  3. Period Length: 30 days (default)
  4. Select "Receivable Accounts"
  5. Click Print

What to focus on: 60+ days columns need immediate attention

💰 Profit & Loss - Financial Performance

When to use: Monthly to review profitability

Quick steps:

  1. Go to Reporting → Financial Reports → Profit and Loss
  2. Set date range (e.g., this month)
  3. Enable Comparison to see vs. previous period
  4. Click Print
🏦 Balance Sheet - Financial Position

When to use: Monthly/quarterly for financial position snapshot

Quick steps:

  1. Go to Reporting → Financial Reports → Balance Sheet
  2. Set End Date (point in time)
  3. Click Print

What to verify: Assets = Liabilities + Equity

Your First Day Workflow

Morning Routine - Daily Reconciliation

  1. Check Cash Position
    Generate Cash Book for yesterday. Compare closing balance with physical cash count.
  2. Review Bank Position
    Generate Bank Book for yesterday. Note any unreconciled items.
  3. Check Day Book
    Review all transactions from yesterday. Look for any unusual items.
  4. Quick Trial Balance
    Verify debits equal credits for yesterday's entries.

Weekly Routine - Collections Review

  1. Aged Receivables Report
    Run Aged Receivable to identify overdue customers.
  2. Process Follow-ups
    Go to Send Follow-ups and process payment reminders.
  3. Review Follow-up Results
    Check how many emails sent, letters queued, actions assigned.
  4. Print Letters
    Print the follow-up letter batch for mailing.

Month-End Routine - Financial Close

  1. Trial Balance
    Generate for the full month. Verify balance.
  2. Bank Reconciliation
    Match Bank Book with bank statement. Investigate differences.
  3. Profit & Loss
    Review monthly performance. Compare with budget and previous month.
  4. Balance Sheet
    Generate as of month-end. Verify equation balances.
  5. Audit Log Review
    Check for any critical or unusual changes during the month.

Chapter 3: Financial Reports

Complete guide to generating and understanding financial reports

3.1 Trial Balance Report

Verify your books are balanced

What is a Trial Balance?

A Trial Balance is a bookkeeping worksheet that lists the balances of all ledger accounts at a specific point in time. It serves as a check that the total of all debits equals the total of all credits, which is the fundamental principle of double-entry bookkeeping.

Key Concept

The Accounting Equation: For every transaction, Debits must equal Credits. A Trial Balance that balances confirms this rule has been followed for all recorded transactions.

When to Use Trial Balance

Situation Frequency Purpose
Daily verification End of each business day Ensure day's entries are balanced
Period closing Monthly/Quarterly Verify accuracy before closing books
Before financial statements Before P&L and Balance Sheet Confirm source data is accurate
Audit preparation As needed Provide auditors with account summary
Error investigation When issues found Identify which accounts are affected

Step-by-Step: Generate Trial Balance

1
Open the Trial Balance Wizard

Navigate to Accounting → Reporting → Financial Reports → Trial Balance

A wizard form will open with various filter options.

Trial Balance Wizard Form
Shows company selection, date range, journals, and display options
2
Configure Report Parameters
Field-by-Field Explanation:
Company
Type: Selection Required Default: Current company

What it does: Selects which company's data to include in the report.

When to change: In multi-company environments, select the specific company you want to report on.

Example: If you manage accounts for both "An IT Solutions Co." and "A Trading Company", select "An IT Solutions Co." to see only An IT Solutions Co.'s trial balance.

Journals
Type: Multi-select Required Default: All company journals

What it does: Filters which journals' entries are included in the calculation.

When to change:

  • Select only Sales journal to see sales-related accounts
  • Select only Bank journals to reconcile bank accounts
  • Keep all journals for complete trial balance

Tip: For a complete Trial Balance, include all journals. Filtering journals is useful for specific analysis.

Start Date
Type: Date Optional Default: Empty (all time)

What it does: Only includes transactions on or after this date.

When to use:

  • Set to first day of fiscal year for YTD trial balance
  • Set to first day of month for monthly trial balance
  • Leave empty for all-time cumulative balance

Example scenarios:

ScenarioStart DateEnd Date
January 2026 only01/01/202631/01/2026
Q1 202601/01/202631/03/2026
All time up to today(empty)Today
Fiscal Year 2025-2601/04/202531/03/2026
End Date
Type: Date Optional Default: Empty (all time)

What it does: Only includes transactions on or before this date.

Important: The Trial Balance shows the balance AS OF this date. All transactions up to and including this date are included.

Target Moves
Type: Selection Required Default: All Posted Entries

Options:

Option Includes When to Use
All Posted Entries Only confirmed, posted journal entries Final reports, official documents, audit
All Entries Both posted AND draft entries Reviewing work in progress, finding draft entries
Recommendation

Always use "All Posted Entries" for official reports. Draft entries are unconfirmed and may change.

Display Account
Type: Selection Required Default: All

Options:

Option Shows Best For
All Every account in chart of accounts Complete view, seeing unused accounts
With movements Only accounts with transactions in period Period-specific analysis, cleaner reports
With balance not equal to 0 Only accounts with non-zero balance Most common choice, removes zero-balance clutter
Analytic Accounts
Type: Multi-select Optional Default: All (no filter)

What it does: Filters to only include transactions tagged with specific analytic accounts.

When to use:

  • Generate Trial Balance for specific department
  • View project-specific financial position
  • Cost center analysis

Example: Select "Marketing Department" analytic account to see Trial Balance for marketing-related transactions only.

3
Generate the Report

Click the "Print" button to generate the PDF report.

The report will download automatically or open in a new tab depending on your browser settings.

4
Read and Interpret the Report
Report Structure:
Column Description How to Read
Code Account number from chart of accounts Use to identify specific accounts
Account Account name/description Describes what the account tracks
Debit Total debit balance Assets, expenses typically show debits
Credit Total credit balance Liabilities, equity, income show credits
Balance Net balance (Debit - Credit) Positive = net debit, Negative = net credit
What the Totals Mean:
If Total Debits = Total Credits

Your books are balanced! This confirms all journal entries followed double-entry rules.

If Total Debits ≠ Total Credits

There's an error somewhere. This should NOT happen in Odoo as it enforces balanced entries. Check for:

  • System issues or bugs
  • Data import problems
  • Database corruption

Trial Balance Scenarios

Scenario 1: Monthly Trial Balance for January 2026

Difficulty: Beginner | Time: 2 minutes
Objective: Generate Trial Balance showing only January 2026 transactions to verify month-end closing.
Configuration:
FieldValueReason
CompanyYour CompanyDefault
JournalsAllComplete picture
Start Date01/01/2026First day of January
End Date31/01/2026Last day of January
Target MovesAll Posted EntriesOnly confirmed entries
Display AccountWith movementsOnly accounts with Jan transactions
Sample Output:
CodeAccountDebitCredit
101000Cash15,000.00-
110000Accounts Receivable45,000.00-
200000Accounts Payable-22,000.00
400000Sales Revenue-50,000.00
500000Cost of Goods Sold12,000.00-
TOTAL72,000.0072,000.00
Result: Totals match (72,000 = 72,000). January books are balanced and ready for closing.

Scenario 2: Year-to-Date Trial Balance with Zero Balances

Difficulty: Intermediate | Time: 2 minutes
Objective: Generate cumulative Trial Balance from fiscal year start showing ALL accounts including zero balances.
Configuration:
FieldValueReason
Start Date01/04/2025Fiscal year start (Apr-Mar)
End DateTodayCurrent date
Target MovesAll Posted EntriesOfficial figures
Display AccountAllSee every account

Use case: Identifying unused accounts, verifying chart of accounts setup, audit requirements.

Scenario 3: Sales Department Trial Balance

Difficulty: Advanced | Time: 3 minutes
Objective: Generate Trial Balance only for transactions tagged with "Sales Department" analytic account.
Configuration:
FieldValue
Start Date01/01/2026
End Date31/03/2026
Target MovesAll Posted Entries
Display AccountWith balance not equal to 0
Analytic AccountsSales Department

Use case: Departmental reporting, cost center analysis, budget vs actual comparison.

Common Issues and Solutions

Trial Balance shows no data
  • Check date range - might be too restrictive
  • Verify "Target Moves" - try "All Entries" to include drafts
  • Confirm journals are selected
  • Ensure transactions exist and are posted
Totals don't match (shouldn't happen in Odoo)
  • This indicates a system issue
  • Check for direct database modifications
  • Review recent data imports
  • Contact system administrator
Missing accounts in report
  • Change "Display Account" to "All" to see zero-balance accounts
  • Expand date range
  • Remove analytic account filter
  • Verify account belongs to selected company

Best Practices for Trial Balance

  • Generate regularly: Create Trial Balance at least weekly during active periods
  • Save copies: Keep PDF copies of month-end Trial Balances for records
  • Compare periods: Compare current Trial Balance with previous period to spot unusual changes
  • Use for reconciliation: Use account balances as starting point for detailed account reconciliation
  • Run before closing: Always verify Trial Balance before generating P&L and Balance Sheet

3.2 General Ledger Report

Transaction-level detail for every account

What is a General Ledger?

The General Ledger is the complete record of all financial transactions over the life of a company. Unlike the Trial Balance which shows only totals, the General Ledger shows every individual transaction that makes up those totals.

Trial Balance vs General Ledger
AspectTrial BalanceGeneral Ledger
Detail levelAccount totals onlyEvery transaction
PurposeVerify balanceDetailed analysis
Length1-2 pages typicallyCan be hundreds of pages
UseOverview, closingAudit, investigation

When to Use General Ledger

SituationExample
Account reconciliationVerify all transactions in bank account match bank statement
Audit evidenceProvide auditors complete transaction history
Error investigationFind specific transaction causing balance issue
Customer/vendor inquiryReview all transactions with specific party
Period analysisUnderstand what drove account balance changes

Step-by-Step: Generate General Ledger

Field-by-Field Configuration:

Include Initial Balances
Type: Checkbox Optional Default: Unchecked

What it does: Adds a row at the beginning of each account showing the balance BEFORE the selected start date.

When to enable:

  • Mid-year reports where you need to see opening balance
  • Account reconciliation where you need running balance to make sense
  • Audit reports requiring complete context

Example:

Without Initial BalanceWith Initial Balance
Feb 01 - Invoice 001 - $500
Feb 15 - Payment - $200
Balance: $300
Initial Balance: $1,000
Feb 01 - Invoice 001 - $500
Feb 15 - Payment - $200
Balance: $1,300
Requirement

If "Include Initial Balances" is checked, you MUST set a Start Date. Otherwise you'll get an error.

Sort By
Type: Selection Required Default: Date

Options:

Option Sorts Transactions By Best For
Date Transaction date (chronological) Time-based analysis, reconciliation
Journal & Partner Journal first, then partner within journal Journal-focused review, partner grouping

Reading the General Ledger Report

Sample General Ledger Output

Account: 110000 - Accounts Receivable

Date Entry Partner Label Debit Credit Balance
Initial Balance - - 10,000.00
01/01/2026 INV/2026/0001 Customer A January Invoice 5,000.00 - 15,000.00
05/01/2026 INV/2026/0002 Customer B Product Sale 3,500.00 - 18,500.00
10/01/2026 BNK/2026/0001 Customer A Payment Received - 5,000.00 13,500.00
Period Total / Closing Balance 8,500.00 5,000.00 13,500.00
How to Read Each Column:
  • Date: Transaction posting date
  • Entry: Journal entry reference number - click to see full entry details
  • Partner: Customer or vendor involved
  • Label: Description of transaction
  • Debit: Amount debited (increases asset/expense accounts)
  • Credit: Amount credited (increases liability/income accounts)
  • Balance: Running balance after each transaction

General Ledger Scenarios

Scenario: Bank Account Reconciliation

Difficulty: Intermediate | Time: 5-10 minutes
Objective: Reconcile bank account in Odoo with bank statement for January 2026.
Step 1: Generate General Ledger
FieldValue
Start Date01/01/2026
End Date31/01/2026
Include Initial Balances✓ Checked
Sort ByDate
Display AccountWith movements
JournalsBank (only)
Step 2: Compare with Bank Statement
ItemOdoo GLBank StatementDifference
Opening Balance$25,000$25,000$0
Total Deposits$45,000$47,000$2,000
Total Withdrawals$38,000$38,500$500
Closing Balance$32,000$33,500$1,500
Step 3: Investigate Differences
  • $2,000 deposit on bank not in Odoo - Check for unrecorded customer payment
  • $500 withdrawal on bank not in Odoo - Check for bank charges, unrecorded checks
Action: Record missing transactions in Odoo and regenerate report until balances match.

Best Practices for General Ledger

  • Use Initial Balances: Always include initial balances for period reports to maintain context
  • Sort by Date: For most reconciliation tasks, date sorting is most useful
  • Filter accounts: For large reports, use "Display Account = With movements" to reduce size
  • Save regularly: Keep PDF copies of General Ledger at key dates (month-end, year-end)
  • Cross-reference: Use entry numbers to drill down to original transactions

3.3 Partner Ledger

Purpose: Partner Ledger provides a detailed view of all transactions with each customer and vendor, showing the complete history of invoices, payments, and outstanding balances per partner.

Navigation

All Available Fields Explained

Field Name Type Required Description Impact on Report
Date From Date Yes Starting date for partner transactions Only transactions on or after this date are shown
Date To Date Yes Ending date for partner transactions Only transactions up to this date are shown
Partner Type Selection Yes Receivable (Customers) or Payable (Vendors) Filters to show only customer or vendor accounts
With Currency Checkbox No Include foreign currency column Shows original currency amounts for multi-currency transactions
Reconciled Entries Checkbox No Include fully reconciled transactions When unchecked, shows only open/unreconciled items
Target Moves Selection Yes Posted Entries or All Entries Include draft entries for preview or posted only for official reports
Partners Many2many No Filter to specific partners Leave empty for all partners, or select specific ones

Step-by-Step: Generate Customer Statement

1
Open Partner Ledger Wizard

Navigate to Accounting → PDF Reports → Partner Ledger

2
Configure for Customer Statement
  • Date From: First day of statement period
  • Date To: Last day of statement period
  • Partner Type: Select "Receivable Accounts" (for customers)
  • Reconciled Entries: Uncheck to show only open items
3
Select Specific Customer (Optional)

In the Partners field, select the customer(s) you need. Leave blank for all customers.

4
Generate Report

Click "Print" to generate PDF with customer statement.

Sample Report Output

Partner: A Client Company Ltd
Date Entry Due Date Description Debit Credit Balance
15/12/2025 INV/2025/0099 14/01/2026 Product Sales - December 25,000.00 - 25,000.00
05/01/2026 BNK/2026/0012 - Payment Received - 15,000.00 10,000.00
20/01/2026 INV/2026/0015 19/02/2026 January Services 8,500.00 - 18,500.00
Total for A Client Company Ltd 33,500.00 15,000.00 18,500.00

Use Case Scenarios

Scenario 1: Customer Account Confirmation

Difficulty: Easy | Time: 3 minutes
Objective: Send customer their account statement for year-end confirmation.
Configuration:
FieldValueReason
Date From01/01/2025Full year statement
Date To31/12/2025Year-end cutoff
Partner TypeReceivableCustomer transactions
With Currency✓ CheckedShow foreign currency if applicable
Reconciled Entries✓ CheckedShow complete history
Target MovesPosted EntriesOnly confirmed transactions
PartnersA Client CompanySpecific customer

Scenario 2: Vendor Payment Planning

Difficulty: Easy | Time: 3 minutes
Objective: Review all outstanding vendor bills for payment planning.
Configuration:
FieldValueReason
Date From01/01/2020Capture all historical items
Date ToToday's dateCurrent outstanding
Partner TypePayableVendor transactions
Reconciled Entries☐ UncheckedOnly unpaid bills
Target MovesPosted EntriesConfirmed bills only
PartnersLeave emptyAll vendors

Partner Ledger FAQ

Q: Why is a customer showing zero balance but I know they owe money?
A: Check if "Reconciled Entries" is unchecked. Also verify the date range includes all relevant invoices. The customer may have payments applied that reconciled the invoices.
Q: Can I get a single partner's complete history?
A: Yes. Select the partner in the Partners field, use a very old Date From (like 01/01/2000), check "Reconciled Entries", and generate the report for complete transaction history.
Q: How do I reconcile partner balances with GL?
A: Run Partner Ledger and General Ledger for the same period. The sum of all partner balances in Partner Ledger should match the Receivable/Payable account balance in General Ledger.

3.4 Aged Partner Balance

Purpose: Aged Partner Balance categorizes receivables and payables by age (how long they've been outstanding), helping with credit control and cash flow management.

Navigation

All Available Fields Explained

Field Name Type Required Default Description
Start Date Date Yes Today The reference date from which aging is calculated. Typically use today's date.
Period Length (days) Integer Yes 30 Number of days in each aging bucket. Common values: 30, 15, 7
Partner Type Selection Yes - Receivable (for customers) or Payable (for vendors)
Journals Many2many Yes All Select journals to include in the aging analysis
Target Moves Selection Yes Posted Include only posted entries or all entries

Understanding Aging Buckets

How Aging Buckets Work:

With Period Length = 30 days and Start Date = January 31, 2026:

Bucket Label Date Range Meaning
Not Due Current Due after Jan 31 Invoices not yet due
0-30 1-30 Days Jan 1 - Jan 31 Overdue up to 30 days
31-60 31-60 Days Dec 2 - Dec 31 Overdue 31-60 days
61-90 61-90 Days Nov 2 - Dec 1 Overdue 61-90 days
91-120 91-120 Days Oct 3 - Nov 1 Overdue 91-120 days
120+ +120 Days Before Oct 3 Overdue more than 120 days

Sample Report Output

Aged Receivable Report - As of January 31, 2026

Partner Not Due 0-30 31-60 61-90 91-120 120+ Total
A Client Company 5,000 8,500 3,200 - - - 16,700
A Manufacturing Firm 12,000 - 4,500 2,800 - - 19,300
Problem Customer Ltd - - - 1,500 3,200 8,900 13,600
TOTAL 17,000 8,500 7,700 4,300 3,200 8,900 49,600

Use Case Scenarios

Scenario 1: Weekly Credit Control Review

Difficulty: Easy | Time: 2 minutes
Objective: Identify customers requiring immediate follow-up for overdue payments.
FieldValueReason
Start DateTodayCurrent aging snapshot
Period Length30Standard monthly buckets
Partner TypeReceivableCustomer receivables
Target MovesPosted EntriesConfirmed invoices only
Action: Focus on partners with amounts in 60+ days columns for immediate collection follow-up.

Scenario 2: Cash Flow Forecasting

Difficulty: Intermediate | Time: 5 minutes
Objective: Plan cash outflows by analyzing when vendor bills are due.
FieldValueReason
Start DateTodayCurrent position
Period Length7Weekly payment planning
Partner TypePayableVendor bills
Target MovesPosted EntriesConfirmed bills only
Analysis: Use "Not Due" and "0-7" columns to estimate next week's payment requirements.

Scenario 3: Bad Debt Provision Calculation

Difficulty: Advanced | Time: 10 minutes
Objective: Calculate bad debt provision based on aging analysis.
Step 1: Generate Aged Receivable
FieldValue
Start Date31/12/2025 (Year-end)
Period Length30
Partner TypeReceivable
Step 2: Apply Provision Rates
Aging BucketBalanceProvision %Provision Amount
Current/Not Due$50,0000%$0
0-30 Days$25,0001%$250
31-60 Days$15,0005%$750
61-90 Days$8,00010%$800
91-120 Days$5,00025%$1,250
120+ Days$10,00050%$5,000
TOTAL$113,000-$8,050
Action: Journal entry for bad debt provision: Debit Bad Debt Expense $8,050, Credit Allowance for Doubtful Accounts $8,050

Best Practices for Aged Partner Reports

  • Run Weekly: Generate aged receivable weekly to catch overdue accounts early
  • Compare Trends: Archive reports monthly to track aging trends over time
  • Set Thresholds: Establish policies (e.g., >60 days = collection call, >90 days = credit hold)
  • Use for KPIs: Calculate DSO (Days Sales Outstanding) using the report data
  • Match to GL: Total should match Receivable/Payable account in General Ledger

Aged Partner FAQ

Q: What date is used for aging - invoice date or due date?
A: The aging is based on the due date (date_maturity) of each invoice. If no due date is set, the invoice date is used.
Q: Why does the total not match my receivable account balance?
A: Possible reasons: (1) Reconciled items are filtered out (2) Date filters exclude some transactions (3) Journal selection doesn't include all receivable journals (4) There are draft invoices not included

3.5 Balance Sheet

Purpose: The Balance Sheet (Statement of Financial Position) shows the company's assets, liabilities, and equity at a specific point in time. It follows the fundamental accounting equation: Assets = Liabilities + Equity.

Navigation

All Available Fields Explained

Field Name Type Required Description
Date From Date Yes Start of fiscal year (for retained earnings calculation)
Date To Date Yes The "as of" date for the balance sheet position
Target Moves Selection Yes Posted Entries (final) or All Entries (including drafts)
Display Debit/Credit Checkbox No Show separate debit and credit columns instead of net balance
Enable Comparison Checkbox No Enable comparison with another period
Comparison Date From/To Dates If comparison enabled The comparison period dates
Column Label Text If comparison enabled Label for the comparison column (e.g., "Prior Year")

Standard Balance Sheet Structure

COMPANY NAME

Balance Sheet as of December 31, 2025

ASSETS
Current Assets
Cash and Bank $125,000
Accounts Receivable $85,000
Inventory $45,000
Total Current Assets $255,000
Non-Current Assets
Property, Plant & Equipment $180,000
Less: Accumulated Depreciation ($45,000)
Total Non-Current Assets $135,000
TOTAL ASSETS $390,000
LIABILITIES
Accounts Payable $42,000
Accrued Expenses $18,000
Long-term Debt $100,000
Total Liabilities $160,000
EQUITY
Share Capital $100,000
Retained Earnings $130,000
Total Equity $230,000
TOTAL LIABILITIES + EQUITY $390,000

Use Case Scenarios

Scenario 1: Year-End Financial Statements

Difficulty: Easy | Time: 3 minutes
Objective: Generate official year-end balance sheet for annual report.
FieldValueReason
Date From01/01/2025Fiscal year start
Date To31/12/2025Fiscal year end
Target MovesPosted EntriesOnly final entries
Display Debit/Credit☐ UncheckedShow net balances only
Important: Ensure all year-end adjustments are posted before generating final balance sheet.

Scenario 2: Year-over-Year Comparison

Difficulty: Intermediate | Time: 5 minutes
Objective: Compare current year balance sheet with prior year.
FieldValue
Date From01/01/2025
Date To31/12/2025
Enable Comparison✓ Checked
Comparison Date From01/01/2024
Comparison Date To31/12/2024
Column LabelPrior Year 2024
Output: Report shows both years side-by-side for easy comparison of financial position changes.

Balance Sheet Best Practices

  • Check Balance: Total Assets must equal Total Liabilities + Equity. If not, investigate account type assignments.
  • Review Account Types: Ensure all accounts have correct account types for proper classification on the balance sheet.
  • Year-End Close: Run the balance sheet before and after year-end closing to verify P&L is properly closed to retained earnings.
  • Reconcile Key Accounts: Bank, receivable, and payable balances should match supporting reports.

3.6 Profit & Loss Statement

Purpose: The Profit & Loss Statement (Income Statement) shows the company's revenues, expenses, and resulting profit or loss over a period of time.

Navigation

All Available Fields Explained

Field Name Type Required Description
Date From Date Yes First day of the reporting period
Date To Date Yes Last day of the reporting period
Target Moves Selection Yes Posted Entries or All Entries
Display Debit/Credit Checkbox No Show detailed debit/credit instead of net
Enable Comparison Checkbox No Compare with another period

Standard P&L Structure

COMPANY NAME

Profit & Loss - January 1 to December 31, 2025

REVENUE
Sales Revenue $850,000
Service Revenue $125,000
Other Income $15,000
Total Revenue $990,000
EXPENSES
Cost of Goods Sold $425,000
Gross Profit $565,000
Salaries & Wages $280,000
Rent Expense $48,000
Utilities $12,000
Depreciation $35,000
Other Expenses $45,000
Total Operating Expenses $420,000
NET PROFIT $145,000

Use Case Scenarios

Scenario 1: Monthly Performance Review

Difficulty: Easy | Time: 2 minutes
Objective: Generate monthly P&L for management review meeting.
FieldValue
Date From01/01/2026
Date To31/01/2026
Target MovesPosted Entries
Enable Comparison✓ (Compare to Dec 2025)

Scenario 2: Quarter vs Quarter Analysis

Difficulty: Intermediate | Time: 5 minutes
Objective: Compare Q4 2025 performance with Q3 2025.
FieldValue
Date From01/10/2025
Date To31/12/2025
Enable Comparison✓ Checked
Comparison Date From01/07/2025
Comparison Date To30/09/2025
Column LabelQ3 2025

Profit & Loss FAQ

Q: Why does my P&L show negative revenue?
A: Revenue accounts normally have credit balances. If displayed as negative, it may be a display setting. Check if "Display Debit/Credit" is enabled, or review account type configuration.
Q: How do I get P&L by department or cost center?
A: This requires analytic accounting. Set up analytic accounts for each department and filter the P&L by analytic account.

3.7 Tax Report

Purpose: The Tax Report summarizes all tax transactions for a period, showing tax collected (Output Tax/Sales Tax) and tax paid (Input Tax/Purchase Tax), essential for VAT/GST returns.

Navigation

All Available Fields Explained

Field Name Type Required Default Description
Date From Date Yes 1st of current month First day of tax reporting period
Date To Date Yes Today Last day of tax reporting period
Target Moves Selection Yes Posted Posted Entries (final return) or All Entries (preview)
Company Many2one Yes Current company Company for which to generate tax report

Sample Tax Report Output

Tax Report - January 2026

Tax Name Tax Base Amount Tax Amount
Sales Taxes (Output)
GST 18% (Sales) $125,000.00 $22,500.00
GST 12% (Services) $45,000.00 $5,400.00
Total Sales Tax $170,000.00 $27,900.00
Purchase Taxes (Input)
GST 18% (Purchases) $85,000.00 $15,300.00
GST 5% (Supplies) $12,000.00 $600.00
Total Purchase Tax $97,000.00 $15,900.00
NET TAX PAYABLE $12,000.00

Use Case Scenarios

Scenario 1: Monthly GST/VAT Return

Difficulty: Easy | Time: 3 minutes
Objective: Generate tax report for monthly GST return filing.
FieldValueReason
Date From01/01/2026First day of tax month
Date To31/01/2026Last day of tax month
Target MovesPosted EntriesOnly confirmed transactions
Usage: Use the totals to fill GST/VAT return forms. Output Tax goes to "Tax Collected on Sales" field, Input Tax goes to "Tax Paid on Purchases" field.

Scenario 2: Quarterly Tax Planning

Difficulty: Intermediate | Time: 5 minutes
Objective: Estimate quarterly tax liability before quarter end.
FieldValueReason
Date From01/10/2025Quarter start
Date ToTodayCurrent date for YTD
Target MovesAll EntriesInclude pending invoices

Tax Report Best Practices

  • Reconcile with GL: Tax amounts should match tax liability accounts in General Ledger
  • Review Tax Configuration: Ensure all taxes are properly configured with correct rates and accounts
  • Archive Reports: Save PDF copies of each tax return period for audit purposes
  • Check All Invoices Posted: Run report with "All Entries" first to identify unpaid invoices that should be included

3.8 Journal Audit Report

Purpose: The Journal Audit Report provides a detailed listing of all journal entries for selected journals, useful for auditing purposes and verifying transaction integrity.

Navigation

All Available Fields Explained

Field Name Type Required Default Description
Date From Date Yes - Start date for audit period
Date To Date Yes - End date for audit period
Journals Many2many Yes Sales & Purchase Select journals to audit
Entries Sorted by Selection Yes Journal Entry Number Date or Journal Entry Number
Target Moves Selection Yes Posted Posted Entries or All Entries

Sample Report Output

Journal Audit - Sales Journal - January 2026

Journal Entry: INV/2026/0001 - Date: 05/01/2026
Account Partner Label Debit Credit
1100 - Accounts Receivable A Client Company Product Sales 11,800.00
4000 - Sales Revenue Product Sales 10,000.00
2200 - GST Output GST 18% 1,800.00
Entry Total 11,800.00 11,800.00

Use Case Scenarios

Scenario 1: External Audit Support

Difficulty: Easy | Time: 5 minutes
Objective: Provide complete journal listing to external auditors.
FieldValueReason
Date From01/01/2025Fiscal year start
Date To31/12/2025Fiscal year end
JournalsAll journalsComplete audit trail
Sorted byJournal Entry NumberSequential ordering
Target MovesPosted EntriesFinal entries only

Scenario 2: Purchase Journal Review

Difficulty: Easy | Time: 3 minutes
Objective: Review all purchase transactions for expense verification.
FieldValue
Date From01/01/2026
Date To31/01/2026
JournalsPurchase Journal only
Sorted byDate

Chapter 4: Daily Reports

Day Book, Cash Book, and Bank Book for daily transaction tracking

4.1 Day Book

Purpose: The Day Book provides a chronological listing of all transactions for a day or period, similar to a daily journal of business activities.

Navigation

All Available Fields Explained

Field Name Type Required Default Description
Start Date Date Yes Today First day of report period
End Date Date Yes Today Last day of report period
Target Moves Selection Yes Posted Posted Entries or All Entries
Journals Many2many Yes All journals Filter by specific journals
Accounts Many2many No Empty (All) Filter to specific accounts

Sample Day Book Output

Day Book - January 15, 2026

Time Journal Entry Account Partner Debit Credit
09:15 Sales INV/2026/0025 Accounts Receivable Customer A 5,900.00
09:15 Sales INV/2026/0025 Sales Revenue 5,000.00
09:15 Sales INV/2026/0025 GST Output 900.00
11:30 Bank BNK/2026/0018 Bank Account Customer B 12,000.00
11:30 Bank BNK/2026/0018 Accounts Receivable Customer B 12,000.00
14:45 Purchase BILL/2026/0012 Office Supplies Vendor X 850.00
14:45 Purchase BILL/2026/0012 GST Input 153.00
14:45 Purchase BILL/2026/0012 Accounts Payable Vendor X 1,003.00
Day Total 18,903.00 18,903.00

Use Case Scenarios

Scenario 1: Daily Closing Verification

Difficulty: Easy | Time: 2 minutes
Objective: Verify all transactions entered today before end of day.
FieldValue
Start DateToday
End DateToday
Target MovesAll Entries
JournalsAll
Review: Check that all transactions are correctly entered and debits equal credits for each entry.

4.2 Cash Book

Purpose: The Cash Book records all cash receipts and payments, helping track physical cash movements in and out of the business.

Navigation

All Available Fields Explained

Field Name Type Required Description
Start Date Date Yes First day of cash book period
End Date Date Yes Last day of cash book period
Target Moves Selection Yes Posted Entries or All Entries
Cash Journals Many2many Yes Select cash type journals only

Sample Cash Book Output

Cash Book - January 2026

Opening Balance (01/01/2026): $5,000.00
Date Entry Description Receipts Payments
05/01 CSH/2026/0001 Cash sale - Customer walk-in 2,500.00
08/01 CSH/2026/0002 Office supplies purchase 350.00
12/01 CSH/2026/0003 Petty cash replenishment 1,000.00
15/01 CSH/2026/0004 Cash received from debtor 1,800.00
20/01 CSH/2026/0005 Transport expenses 450.00
Period Totals 4,300.00 1,800.00
Closing Balance (31/01/2026): $7,500.00

Calculation: $5,000 + $4,300 - $1,800 = $7,500

Use Case Scenarios

Scenario 1: Daily Cash Reconciliation

Difficulty: Easy | Time: 5 minutes
Objective: Reconcile physical cash with Cash Book at end of day.
StepAction
1Generate Cash Book for today
2Note closing balance from report
3Count physical cash in drawer
4Compare and investigate any differences
Important: Any discrepancy between physical cash and Cash Book closing balance must be investigated and documented.

Scenario 2: Monthly Cash Analysis

Difficulty: Intermediate | Time: 10 minutes
Objective: Analyze cash movements for the month and identify patterns.
FieldValue
Start Date01/01/2026
End Date31/01/2026
Target MovesPosted Entries
Analysis Points:
  • Total cash receipts vs payments ratio
  • Days with highest cash movements
  • Categories of cash expenses

4.3 Bank Book

Purpose: The Bank Book records all transactions through bank accounts, including deposits, withdrawals, transfers, and bank charges.

Navigation

All Available Fields Explained

Field Name Type Required Description
Start Date Date Yes First day of bank book period
End Date Date Yes Last day of bank book period
Target Moves Selection Yes Posted Entries or All Entries
Bank Journals Many2many Yes Select bank type journals

Sample Bank Book Output

Bank Book - Main Bank Account - January 2026

Opening Balance (01/01/2026): $125,000.00
Date Entry Partner Description Deposits Withdrawals
03/01 BNK/2026/0001 Customer A Payment received - INV/2025/0095 15,000.00
05/01 BNK/2026/0002 Vendor B Bill payment - BILL/2025/0088 8,500.00
10/01 BNK/2026/0003 Customer C Payment received - INV/2025/0098 22,000.00
15/01 BNK/2026/0004 Salaries Monthly salary transfer 45,000.00
20/01 BNK/2026/0005 Bank Bank charges - January 250.00
25/01 BNK/2026/0006 Customer D Payment received - INV/2026/0005 18,500.00
Period Totals 55,500.00 53,750.00
Closing Balance (31/01/2026): $126,750.00

Use Case Scenarios

Scenario 1: Bank Statement Reconciliation

Difficulty: Intermediate | Time: 15 minutes
Objective: Reconcile Odoo Bank Book with bank statement received.
Step-by-Step Process:
StepAction
1Generate Bank Book for the statement period
2Compare opening balance with bank statement opening
3Tick off each transaction that appears on both
4List unmatched items (outstanding checks, deposits in transit)
5Prepare bank reconciliation statement
Bank Reconciliation Template:
Balance per Bank Statement$128,250.00
Add: Deposits in Transit$5,000.00
Less: Outstanding Checks($6,500.00)
Adjusted Bank Balance $126,750.00
Balance per Odoo Bank Book$126,750.00
Difference $0.00

Daily Report Best Practices

  • Daily Review: Run Day Book daily to verify all transactions are correctly entered
  • Weekly Reconciliation: Reconcile Cash Book weekly with physical cash count
  • Monthly Bank Rec: Complete bank reconciliation within 5 days of receiving bank statement
  • Archive Reports: Save daily/weekly reports for audit trail
  • Investigate Promptly: Any discrepancies should be investigated immediately

Chapter 5: Follow-up Management

Automated customer follow-up for overdue payments

5.1 Follow-up Overview

Purpose: Follow-up Management automates the process of sending payment reminders to customers with overdue invoices. Configure multiple levels of reminders with different delays and actions.

Navigation

5.2 Configuring Follow-up Levels

Administrator Access Required: Only users with Accounting Manager rights can configure follow-up levels.

Follow-up Level Fields

Field Name Type Required Description
Follow-Up Action Text Yes Name/title of this follow-up level (e.g., "First Reminder")
Due Days Integer Yes Days after invoice due date to trigger this level. Can be negative for advance reminders.
Send an Email Checkbox No Automatically send email when this level is triggered
Send a Letter Checkbox No Generate printable letter for mailing
Manual Action Checkbox No Create manual task for follow-up (e.g., phone call)
Action To Do Text If Manual Description of manual action required
Assign a Responsible User If Manual User responsible for manual follow-up
Email Template Template If Email Email template to use for this level
Printed Message Text If Letter Message content for printed letter

Sample Follow-up Configuration

Recommended Follow-up Level Structure

Level Name Days Email Letter Manual Action
1 Polite Reminder -3 Gentle reminder 3 days before due
2 First Reminder 7 Email reminder 7 days overdue
3 Second Reminder 21 Email + Letter at 21 days
4 Phone Call 35 Assign to credit controller for phone call
5 Final Notice 60 Legal warning letter + manager review

5.3 Running Follow-up Process

1
Navigate to Follow-up Reports

Accounting → Customers → Follow-up Reports

2
Review Partners Due for Follow-up

System shows all partners with invoices that have reached the next follow-up level.

3
Select Partners and Set Date

Choose which partners to process. Set the follow-up sending date.

4
Process Follow-ups

Click "Send Letters & Emails" to execute. System will:

  • Send configured emails
  • Generate PDF letters for printing
  • Create manual action tasks
  • Update follow-up level on invoice lines
5
Review Results

System displays summary: X emails sent, Y letters generated, Z manual actions created.

Follow-up Scenarios

Scenario 1: Weekly Follow-up Run

Difficulty: Easy | Time: 10 minutes
Objective: Process weekly follow-up reminders every Monday.
Process:
  1. Open Follow-up Reports on Monday morning
  2. Review the list of partners requiring follow-up
  3. Verify email addresses are correct for email recipients
  4. Click "Send Letters & Emails"
  5. Print generated letters for mailing
  6. Review manual actions assigned to team members

Scenario 2: Single Customer Follow-up

Difficulty: Easy | Time: 3 minutes
Objective: Send follow-up to a specific customer outside regular schedule.
  1. Open the partner's record
  2. Go to Accounting tab → View overdue invoices
  3. Click "Send Follow-up" button
  4. Select follow-up level to send
  5. Customize message if needed
  6. Send

5.4 Sample Follow-up Letter Template

%(company_name)s
[Company Address]
Date: %(date)s

To:
%(partner_name)s
[Partner Address]

Subject: Payment Reminder - Overdue Invoices

Dear %(partner_name)s,

We would like to bring to your attention that the following invoices remain unpaid beyond their due dates:

Invoice No. Invoice Date Due Date Amount Due
[Invoice list populated automatically]

We kindly request that you arrange payment within the next 8 days to avoid any further action.

If payment has already been made, please disregard this notice and accept our thanks.

For any queries regarding this matter, please contact our accounts department.

Thank you for your prompt attention.

Best Regards,
%(user_signature)s
Accounts Department

Follow-up Best Practices

  • Start Politely: First level should be a gentle reminder, not aggressive
  • Escalate Gradually: Each level should be firmer than the previous
  • Multiple Channels: Use email first, add letters and calls for later levels
  • Document Everything: All follow-ups are logged on the partner record
  • Review Before Sending: Always preview emails before batch sending
  • Handle Disputes: Pause follow-up for customers with legitimate disputes

Chapter 6: Audit Logs

Complete audit trail for all accounting changes

6.1 Audit Log Overview

Purpose: Audit Logs provide a complete trail of all changes made to accounting records, including who made changes, when, and what was changed (before and after values).

Navigation

6.2 Understanding Audit Log Fields

Field Name Description Example
Date/Time Exact timestamp when action occurred 2026-01-15 14:32:45
User User who performed the action John Smith
Action Type Type of action: Create, Write, Delete Write
Model The type of record affected account.move (Journal Entry)
Record Name Name/reference of the specific record INV/2026/0015
Field Name Which field was changed Amount Total
Old Value Value before the change $5,000.00
New Value Value after the change $5,500.00
Category Classification: Accounting, Follow-up, Asset, Budget, Configuration Accounting
Severity Importance level: Info, Warning, Critical Warning
IP Address IP address of the user's computer 192.168.1.100

6.3 Using Audit Log Filters

Pre-defined Filters

Filter Name Shows Use Case
Created New record creations Track new entries added to system
Updated Record modifications Find changes to existing records
Deleted Record deletions Track what has been removed
Accounting Journal entries, invoices Financial transaction changes
Follow-up Follow-up related changes Customer reminder activities
Critical High-severity changes Review important modifications
Warning Medium-severity changes Potential issues
Today Today's activity Daily review
Last 7 Days Past week's activity Weekly review
My Activity Current user's changes Personal activity log

6.4 Audit Log Use Cases

Scenario 1: Investigate Invoice Modification

Difficulty: Intermediate | Time: 5 minutes
Objective: A customer claims an invoice amount was changed. Investigate what happened.
Steps:
  1. Go to Audit Logs → All Audit Logs
  2. Search for the invoice number (e.g., "INV/2026/0015")
  3. Filter by Action Type = "Updated"
  4. Review the log entries showing:
    • Who made the change
    • When it was changed
    • What the old and new values were
Finding Example: "User Jane modified Amount Total from $5,000 to $5,500 on Jan 15, 2026 at 2:32 PM. Reason noted: Customer requested additional services."

Scenario 2: Monthly Audit Review

Difficulty: Advanced | Time: 30 minutes
Objective: Review all critical and warning-level changes for the past month.
Process:
  1. Go to Audit Logs → Critical Logs
  2. Apply filter "Last 30 Days"
  3. Group by "User" to see who made changes
  4. Review each critical change for authorization
  5. Document findings in audit workpaper
Items to Look For:
  • Large value changes (above threshold)
  • Changes outside business hours
  • Unusual patterns of activity
  • Deleted records
  • Configuration changes

Scenario 3: User Activity Report for HR

Difficulty: Easy | Time: 5 minutes
Objective: Generate report of a specific user's activity.
  1. Go to Audit Logs → All Audit Logs
  2. Filter by User = [Select specific user]
  3. Set date range as needed
  4. Export to PDF or Excel for HR review

6.5 Audit Log Views

List View

Default view showing logs in a table format. Ideal for quick scanning and filtering.

Pivot View

Analyze audit logs by dimensions. Example analysis:

  • Actions per user per day
  • Changes by model type
  • Activity patterns by hour

Graph View

Visual representation of audit activity. Useful for identifying trends and spikes.

Calendar View

See audit activities on a calendar. Helpful for correlating with business events.

Audit Log Best Practices

  • Regular Review: Management should review critical logs weekly
  • Establish Baselines: Know normal activity patterns to identify anomalies
  • Retention Policy: Define how long to keep audit logs (legal requirements may apply)
  • Access Control: Limit who can view audit logs (sensitive information)
  • Export Periodically: Archive audit logs externally for long-term storage
  • Investigate Promptly: Address critical/warning items within 24-48 hours

Chapter 7: Configuration Guide

Complete setup and configuration instructions

7.1 Initial Module Setup

Pre-Installation Checklist

Requirement Description Status
Odoo Version Odoo 19 Community Edition [ ] Verified
Base Accounting account module installed and configured [ ] Verified
Chart of Accounts CoA installed for your country [ ] Verified
User Access Administrator access for installation [ ] Verified

Installation Steps

1
Access Apps Menu

Navigate to Apps menu from the main menu bar.

2
Search for Module

In the search box, type "DRKDS Accounting" and press Enter.

3
Install Module

Click the "Install" button on the DRKDS Accounting module card.

4
Wait for Installation

System will install the module and all dependencies. This may take 1-2 minutes.

5
Verify Installation

Navigate to Accounting menu and verify new menu items appear (PDF Reports, Daily Reports, etc.).

7.2 Account Type Configuration

Important: Proper account type configuration is essential for accurate financial reports. Each account must have the correct type for Balance Sheet and P&L reports to work correctly.

Account Type Mapping

Account Type Financial Statement Example Accounts
Asset Receivable Balance Sheet - Current Assets Accounts Receivable
Asset Cash Balance Sheet - Current Assets Cash, Petty Cash
Asset Current Balance Sheet - Current Assets Inventory, Prepaid Expenses
Asset Non-Current Balance Sheet - Fixed Assets Property, Equipment
Liability Payable Balance Sheet - Current Liabilities Accounts Payable
Liability Current Balance Sheet - Current Liabilities Accrued Expenses, Tax Payable
Liability Non-Current Balance Sheet - Long-term Liabilities Long-term Loans
Equity Balance Sheet - Equity Share Capital, Retained Earnings
Income P&L - Revenue Sales, Service Revenue
Expense P&L - Expenses Salaries, Rent, Utilities

7.3 Journal Configuration

Required Journals for Daily Reports

Journal Name Type Used By
Cash Cash Cash Book report
Bank Bank Bank Book report
Sales Sale Journal Audit, Day Book
Purchase Purchase Journal Audit, Day Book

7.4 Follow-up Configuration

1
Access Follow-up Configuration

Accounting → Configuration → Follow-up Levels

2
Create Follow-up Record

If no follow-up exists for your company, create one. Only one follow-up configuration is allowed per company.

3
Add Follow-up Levels

Add levels with increasing delays (e.g., -3, 7, 21, 35, 60 days)

4
Configure Email Templates

For each level with email enabled, select or create appropriate email template.

5
Test Follow-up

Create a test customer with overdue invoice and run follow-up to verify configuration.

Chapter 8: User Roles & Permissions

Understanding access levels and security groups

8.1 Access Level Overview

Security Model: DRKDS Accounting uses Odoo's built-in security groups to control access. Users are assigned to groups that determine what they can see and do.

Available Security Groups

Group Name Technical Name Description
Invoicing account.group_account_invoice Basic invoice creation and viewing
Show Full Accounting Features account.group_account_user Access to accounting reports and journal entries
Billing Administrator account.group_account_manager Full accounting access including configuration

8.2 Permission Matrix

Feature Invoicing Accountant Manager
View PDF Reports -
Generate PDF Reports -
View Daily Reports -
Run Follow-up -
Configure Follow-up Levels - -
View Audit Logs -
Delete Audit Logs - - -
Period Lock - -

8.3 Assigning User Roles

1
Access User Settings

Settings → Users & Companies → Users

2
Select User

Click on the user you want to configure.

3
Set Accounting Rights

In the "Accounting" section, select the appropriate level: Invoicing, Show Full Accounting Features, or Billing Administrator.

4
Save Changes

Click Save. User will have new permissions on next login.

8.4 Role Recommendations by Job Function

Job Title Recommended Group Reason
Accounts Payable Clerk Invoicing Enter vendor bills, basic operations
Accounts Receivable Clerk Invoicing Create customer invoices, record payments
Staff Accountant Show Full Accounting Features Full access to reports and journal entries
Senior Accountant Show Full Accounting Features Prepare reports, reconciliations
Finance Manager Billing Administrator Configure settings, manage periods, full access
CFO / Controller Billing Administrator Complete oversight and configuration
External Auditor Show Full Accounting Features (Read-only) Review reports without making changes

Chapter 9: FAQ & Troubleshooting

Common questions and problem solutions

9.1 Frequently Asked Questions

Q: The Balance Sheet doesn't balance - Assets don't equal Liabilities + Equity. What's wrong?
A: This usually indicates account type configuration issues:
  1. Go to Accounting → Configuration → Chart of Accounts
  2. Check each account has the correct "Type" assigned
  3. Ensure all accounts used in entries have proper types
  4. Check for accounts with "Off Balance Sheet" type used for on-balance transactions
Q: Why do some accounts show zero balance in Trial Balance but have transactions?
A: Check the "Display Account" filter setting. If set to "With movements", accounts with zero net balance may be hidden. Change to "All" to see all accounts including those with zero balance.
Q: Follow-up emails are not being sent. What should I check?
A: Troubleshoot in this order:
  1. Verify email server (outgoing mail server) is configured in Settings
  2. Check the follow-up level has "Send an Email" checked
  3. Verify an email template is assigned to the level
  4. Confirm the partner has a valid email address
  5. Check the email queue (Settings → Technical → Email → Emails) for errors
Q: How can I see which taxes are applied to an invoice in the Tax Report?
A: The Tax Report shows totals by tax type. To see specific invoices:
  1. Note the tax name from the report
  2. Go to Accounting → Journal Entries
  3. Filter by the tax account
  4. This shows all entries affecting that tax
Q: Can I export reports to Excel instead of PDF?
A: The built-in reports generate PDF. For Excel export:
  1. Use the List view of the underlying data
  2. Apply your filters
  3. Click the "Export" button
  4. Select XLSX format
Q: Audit logs show changes I didn't make. Is this a security issue?
A: Check these possibilities:
  • Automated processes (scheduled actions) may modify records
  • System administrator may have made changes
  • Multi-user scenarios - check if account is shared
  • Review the IP address field to identify the source
  • If suspicious, change your password immediately and report to IT

9.2 Common Error Messages

Error Message Cause Solution
"You must set a period length greater than 0" Aged Partner report - Period Length is 0 or negative Enter a positive number (e.g., 30) for Period Length
"You must set a start date" Date From field is empty Enter a valid start date
"Only one follow-up per company is allowed" Trying to create second follow-up config Edit existing follow-up instead of creating new one
"Your description is invalid" Follow-up letter template has formatting errors Check template placeholders: use %(name)s format, escape % with %%
"No journal found" or empty report Journals not selected in wizard Select at least one journal before generating report

9.3 Troubleshooting Steps

Problem: Report Shows Incorrect Data

Diagnostic Steps:
  1. Verify date range: Double-check From and To dates are correct
  2. Check target moves: "All Entries" includes drafts; "Posted" shows only confirmed
  3. Review journal selection: Ensure all relevant journals are included
  4. Check company: Multi-company users - verify correct company is selected
  5. Cross-reference: Compare with journal entries list for the same period

Problem: PDF Report Won't Generate

Diagnostic Steps:
  1. Check wkhtmltopdf: This tool must be installed on the server for PDF generation
  2. Browser popup blocker: Ensure popups are allowed for Odoo
  3. Empty data: Report may fail if no data matches filters - try broader date range
  4. Server resources: Large reports may timeout - try smaller date range
  5. Check server logs: Administrator can review logs for specific errors

Chapter 10: Glossary of Terms

Definitions of key accounting and Odoo terms

Accounting Terms

Term Definition
Accounts Receivable (AR) Money owed to the company by customers for goods/services sold on credit
Accounts Payable (AP) Money the company owes to vendors for purchases made on credit
Aging Classification of receivables/payables by how long they've been outstanding
Balance Sheet Financial statement showing assets, liabilities, and equity at a point in time
Chart of Accounts (CoA) The complete list of accounts used to record financial transactions
Credit Right side of journal entry; increases liability/equity/revenue; decreases assets/expenses
Debit Left side of journal entry; increases assets/expenses; decreases liability/equity/revenue
DSO (Days Sales Outstanding) Average number of days to collect payment after a sale
Fiscal Year 12-month period used for financial reporting (may differ from calendar year)
General Ledger (GL) Complete record of all financial transactions organized by account
Journal Entry Record of a financial transaction with balanced debits and credits
Profit & Loss (P&L) Financial statement showing revenues, expenses, and net profit for a period
Reconciliation Process of matching and verifying two sets of records (e.g., bank statement vs. book)
Trial Balance List of all accounts with their balances to verify debits equal credits

Odoo Terms

Term Definition
Journal Category for grouping similar transactions (Sales, Purchase, Bank, Cash)
Posted Entry Confirmed journal entry that affects account balances
Draft Entry Unconfirmed entry that can still be modified
Partner Customer, vendor, or other business contact
Wizard Dialog box for entering parameters before running a report or process
Many2one Field type linking to another record (e.g., Partner on Invoice)
Many2many Field type allowing multiple selections (e.g., selecting multiple journals)

Appendix

Additional reference materials

A. Keyboard Shortcuts

Shortcut Action
Alt + QSearch (global search)
Alt + SSave
Alt + JDiscard changes
Alt + ACreate new record
Alt + KPrevious record
Alt + LNext record

B. Date Format Reference

Format Example
DD/MM/YYYY31/12/2025
MM/DD/YYYY12/31/2025
YYYY-MM-DD2025-12-31

Note: Date format depends on user's language settings in Odoo.

C. Support & Resources

Resource Link/Contact
DRKDS Website https://drkdsinfo.com
Email Support jyotin@drkdsinfo.com
Mobile Support +91-92276-02362
Odoo Documentation https://www.odoo.com/documentation
Odoo Community Forum https://www.odoo.com/forum