📁
ActiveBooks
  • ActiveBooks Documentation
  • Importing Data in ActiveBooks
    • Downloading Backups
    • Chart of Accounts Importer
    • Data Export
    • Data Import Tools
  • Printing
    • Printing and Branding
    • Print Settings
    • Print Format
    • Print Format Builder
    • Print Style
    • Print Headings
    • Address Template
    • Terms And Conditions
    • Cheque Print Template
    • Custom Translations
    • Raw Printing
  • Workflows
    • Workflows
    • Workflow Actions
    • Workflow State
    • Assignment Rule
    • Email
      • Email
      • Email Domain
      • Email Account
      • Untitled
      • Untitled
      • Untitled
      • Untitled
      • Untitled
      • Untitled
      • Untitled
      • Untitled
      • Untitled
      • Email
  • Email
    • Users and Permissions
      • Basic setup of ActiveBooks
        • Setting up Company in ActiveBooks
        • Setting up Taxes in ActiveBooks
        • Setting up Company's Sales Goals
        • Global Defaults in ActiveBooks
        • System Settings in ActiveBooks
        • Letter Head
      • Adding Users
      • Users and Permissions
      • Role and Role Profile
      • Role Based Permissions
      • User Permissions
      • Role Permission for Page and Report
      • Sharing
      • Limited User
      • Administrator
    • Email
    • Email Domain
    • Email Account
    • Email Inbox
    • Email Template
    • Sending Email from any Document
    • Linking Emails to Documents
    • Email Digest
    • Auto Email Reports
    • SMS Settings
    • Notification
    • Document Follow
    • Email Dropbox
  • System Configuration
    • Settings
    • Show or Hide Modules
    • Naming Series
    • Session Defaults
    • Bulk Renaming of Records
    • Bulk Update
    • Milestone Tracking
    • Auto Repeat
    • Domain settings
    • Energy Point System
  • Data Privacy
    • Personal Data Download
    • Personal Data Deletion
  • Articles
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
    • Untitled
  • Using ActiveBooks
    • Articles
      • Checking Link Between Documents
      • Access Log
      • Duplicate Records
      • To-Do Auto Creation
      • Document Versioning
      • Deleting and Restoring Documents
      • Bulk Rename
      • Renaming Documents
      • Tree Master Renaming
      • Letter Head in the Report
      • Copy Pasting Multiple Records From Excel
      • Adding Attachments to Outgoing Messages
    • Collaboration Tools
      • Assignment
      • Tags
      • Kanban Board
      • Filter by
      • Save Filter
      • Search Filter
      • Collaborating Around Forms
      • Delete Company Transactions
    • Introduction
      • Tools
        • To Do
        • Notes
        • Video
        • Calendar
        • Chat
        • Dashboard
        • Global Search
        • Desktop
  • Automation
    • Automation
    • Assignment Rule
    • Milestone Tracking
    • Auto Repeat
    • Event Streaming
  • Accounts
    • Introduction
      • Setup and Opening
        • Accounting Entries
        • Accounts Settings
        • Company Setup
        • Chart of Accounts
        • Opening Balance in Accounts
        • Cost Center
        • Distributed Cost Center
        • Fiscal Year
        • Accounting Period
        • Finance Book
        • Accounting Dimensions
        • Accounting Dimensions Filters
        • Bank
        • Bank Account
      • Billing
        • Sales Invoice
        • Purchase Invoice
        • Inter Company Invoices
        • Credit Note
        • Debit Note
        • Credit Limit
      • Taxes
        • Item Tax Template
        • Tax Withholding Category
        • Tax Rule
        • Tax Category
      • Pricing
        • Pricing Rule
        • Promotional Scheme
        • Exchange Rate Revaluation
        • Currency Exchange
        • Currency
      • Retail Operations
        • Point of Sale Profile
        • Point of Sale
        • Cashier Closing
      • Tools
        • Bank Reconciliation
        • Payment Reconciliation
        • Period Closing Voucher
        • Payment Order
        • ActiveBooks to QuickBooks Migrator
        • Process Statement of Accounts
      • Accounting Reports
        • Accounting Reports
      • Advanced
        • Multi Currency Accounting
        • Deferred Revenue
        • Deferred Expense
        • Process Deferred Accounting
        • Bank Guarantee
          • Budgeting
        • Loyalty Program
        • Auto Repeat
        • Invoice Discounting
      • Subscription
        • Subscription
        • Subscription Plan
        • Subscription Settings
      • Shareholder Management
        • Share Holder
        • Share Transfer
        • Share Reports
      • Articles
        • Articles
        • Freeze Accounting Entries
        • Post Dated Cheque Entry
        • Adjust Withhold Amount in the Payment Entry
        • Bulk Payment Entry
        • Difference Entry
        • Changing Parent Account
        • Withdrawing Salary from Owner's Equity Account
        • Common Receivable Account
        • Freeze an Account
        • Round of Account Validation Message
        • Purchase Tax or Charges Categories
        • Types in Sales and Purchase Tax Template
        • Manage Foreign Exchange Difference
        • Recurring Orders and Invoices
        • Delivery from Sales Invoice
        • Exchange Rate Field Frozen
        • Fiscal Year Creation
        • How To Customize Cash Flow Report
        • Immutable Ledger In ActiveBooks
        • Purchase Invoice - Account Type Error
        • Fixing Fiscal Year Error
        • Stock and Accounting Module Integration
        • Merging Accounts
  • Stock
    • Basics
      • Introduction
      • Warehouse
      • Item
      • Opening Stock
      • Accounting Of Inventory Stock
      • Price Lists
      • Stock Settings
    • Item Variants
      • Item Variants
      • Item Attribute
    • Setup
      • Item Price
      • Item Group
      • Unit of Measure (UoM)
      • Manufacturer
    • Stock Transactions
      • Material Request
      • Purchase Receipt
      • Delivery Note
      • Stock Entry
      • Packing Slip
      • Shipment
      • Retaining Sample Stock
      • Landed Cost Voucher
      • Pick List
      • Putaway Rule
    • Serial and Batch Number
      • Serial Number
      • Batch
      • Installation Note
    • Tools
      • Quality Inspection
      • Stock Reconciliation
      • Quick Stock Balance
    • Return
      • Sales Return
      • Purchase Return
    • Advanced
      • Delivery Trip
      • Projected Quantity
      • Perpetual Inventory
    • Stock Reports
      • Stock Ledger Report
      • Stock Level Report
      • BOM Explorer
      • Stock Value and Account Value Comparison Report
      • Articles
        • Allow Over Delivery/Billing
        • Auto Creation of Material Request
        • Delivery Note Negative Stock Error
        • Stock Entry Purpose
        • Purpose of Stock Received but not Billed
        • Item Valuation Methods and Transactions
        • Maintain Stock field Frozen in the Item master
        • Managing Rejected Finished Goods Items
        • Return Rejected Items
        • Track Items Using Barcode
        • Item Valuation Fifo And Moving Average
        • Item Codification
        • Serial No. Naming
        • Opening Stock Balance Entry for Serialized and Batch Item
        • Managing Batch wise Inventory
        • Sales Return Management
        • Managing Fractions in UOM
        • Repack Entry
        • Material Transfer from Delivery Note and Purchase Receipt
        • Mode of Payment
        • Migrate To Perpetual Inventory
        • Depreciation Entry
  • CRM
    • Introduction to CRM
    • Sales
      • Lead
      • Opportunity
      • Customer
      • Contact
      • Address
      • Appointment
    • Reports
      • CRM Reports
    • Setup
      • Lead Source
      • Opportunity Type
      • Sales Stage
      • Sales Person
      • Customer Group
      • Email Group
      • Contract
      • Appointment Booking Settings
    • Marketing
      • Campaign
      • Email Campaign
      • Newsletter
      • LinkedIn Settings
      • Twitter Settings
      • Social Media Post
    • Articles
      • Automate Lead Creation
      • CRM Analytics
      • Difference between Lead, Contact and Customer
  • Selling
    • Selling
    • Quotation
    • Sales Order
    • Sales Partner
    • Brand
    • Blanket Order
    • Territory
    • Setup
      • Selling Settings
      • Product Bundle
      • Sales Person Target Allocation
      • Sales Taxes and Charges Template
      • Shipping Rule
      • Party Specific Item
    • Articles
      • Sales Persons in the Sales Transactions
      • Request for Raw Material from Sales Order
      • Applying a Discount
      • Selling in Different Unit (UoM)
      • Adding Margin
      • Amending Sales Order after Submit
      • Drop Ship
      • Calculate Incentive for Sales Team
      • Shipping Rule
      • Close Sales Order
      • Taxes and Charges
      • Print Settings
      • Payment Terms
    • Selling Reports
      • Sales Reports
  • Buying
    • Buying
      • Request for Quotation
      • Purchase Order
      • Purchase Taxes and Charges Template
      • Supplier
      • Supplier Quotation
      • Supplier Scorecard
    • Setup
      • Buying Settings
      • Supplier Groups
    • Articles
      • Maintaining Supplier's Item Code in the Item Master
      • Purchasing in Different Unit (UoM)
      • Amending Purchase Order after Submit
      • Procurement Tracker Report
  • HR
    • Employee
      • Employee
      • Employment Type
      • Branch
      • Department
      • Designation
      • Employee Grade
      • Employee Group
      • Employee Health Insurance
    • Attendance
      • Attendance
      • Employee Attendance Tool
      • Attendance Request
      • Upload Attendance
      • Auto Attendance
    • Leave Management
      • Leaves
      • Holiday List
      • Leave Type
      • Leave Period
      • Leave Policy
      • Leave Policy Assignment
      • Leave Allocation
      • Leave Application
      • Compensatory Leave Request
      • Leave Encashment
      • Leave Block List
      • Leave Ledger Entry
    • Recruitment
      • Recruitment
      • Employee Referal
      • Staffing Plan
      • Job Opening
      • Job Applicant
      • Job Offer
      • Appointment Letter
    • Training
      • Training Program
      • Training Event
      • Training Result
      • Training Feedback
    • Employee Life Cycle
      • Employee Life Cycle Management
      • Employee Onboarding
      • Employee Promotion
      • Employee Seperation
      • Employee Transfer
      • Employee Skill Map
    • Payroll
      • Payroll Setup
      • Payroll Management
      • Payroll Period
      • Income Tax Slab
      • Salary Component
      • Salary Structure
      • Salary Structure Assignment
      • Salary Slip
      • Payroll Entry
      • Additional Salary
      • Retention Bonus
      • Employee Incentive
    • Employee Tax and Benefits
      • Setting Up Income tax Deduction
      • Employee Tax Exemption Declaration
      • Employee Tax Exemption Proof Submission
      • Employee Other Income
      • Employee Benefit Application
      • Employee Benefit Claim
    • Travel and Expense Claim
      • Travel Request
      • Employee Advance
      • Expense Claim
    • Gratuity
      • Gratuity
      • Gratuity Rule
    • Loans
      • Loan Type
      • Loan Application
      • Loan
    • Shift Management
      • Shift Management
    • Fleet Management
      • Fleet Management
      • Vehicle
      • Vehicle Log
    • Setup
      • Human Resource Setup
      • HR Settings
      • Daily Work Summary Group
    • Reports
      • Human Resources Reports
    • Articles
      • Articles
      • Leave Calculation in Salary Slip
      • Workdays Calculation in the Salary Slip
    • Performance
      • Appraisal
  • Projects
    • Project
      • Project and Managing Expenses
      • Salary Slip from Timesheet
      • Activity Type
      • Project Template
      • Timesheet
      • Projects
      • Introduction to the Project Module
      • Project Profitability
      • Project Reports
      • Project Type
      • Project Update
      • Project from Customer Portal
      • Activity Cost
      • Project Costing
      • Project
      • Tasks
      • Project Views
      • Sales Invoice from Timesheet
      • Delayed Tasks Summary
      • Project Profitability Report
    • Articles
      • Make A Colorful Gantt Chart
Powered by GitBook
On this page
  • 1. Company and Accounts
  • 2. Accounting Statements
  • 3. Taxes
  • 4. Budget and Cost Center
  • 6. Analytics
  • 7. To Bill
  • 8. Other Reports

Was this helpful?

  1. Accounts
  2. Introduction
  3. Accounting Reports

Accounting Reports

PreviousAccounting ReportsNextAdvanced

Last updated 3 years ago

Was this helpful?

Some of the major accounting reports are:

1. Company and Accounts

General Ledger

Go to: Accounts > Company and Accounts > General Ledger.

  • The General Ledger is a detailed report for all transactions posted to each account and for every transaction there is a Credit and Debit account so it lists them all up.

  • The report is based on the table GL Entry and can be filtered by many pre-defined filters like Account, Cost Centers, Party, Project and Period etc.

  • This helps you to get a full update for all entries posted in a period against any account.

  • The result can be grouped by Account, Voucher/Transaction and Party with opening and closing balances for each group.

  • In case of multi-currency accounting, there is also an option to check the amounts in any other currency than company's base currency.

General Ledger

Go to: Accounting > Accounts Receivable.

  • These reports help you to track the outstanding amount of Customers and Suppliers.

  • It also provides ageing analysis i.e. a break-up of outstanding amount based on the period for which the amount is outstanding.

2.1.1 Accounts Receivables based on Payment terms

You can also see Accounts Receivables based on Payment Terms.

Accounts Receivable report based on payment terms can be seen by clicking the checkbox 'Based On Payment Terms' as shown in the following screenshot.

Outstanding amount against each payment term can be seen. Invoiced Amount shows each payment term amount and Paid Amount shows paid amount against each payment term. Payment against each term is allocated in FIFO order.

![](/docs/v13/assets/img/accounts/)

Go to: Accounts > Accounting Statements > Trial Balance.

A Trial Balance is an accounting report which lists account balances for all your Accounts (“Ledger” and “Group”) for any given reporting period. A company prepares a trial balance periodically, usually at the end of every reporting period. The general purpose of producing a trial balance is to ensure the entries in a company's bookkeeping system are mathematically correct. The totals of Debit and Credit columns must be same for any given period, to ensure the entries are correct. In ERPNext, the report shows following columns:

  • Opening (Dr): Opening debit balance as on From Date

  • Opening (Cr): Opening credit balance as on From Date

  • Debit: Total Debited amount against the account between the selected period

  • Credit: Total Credited amount against the account between the selected period

  • Closing (Dr): Closing debit balance as on To Date

  • Closing (Cr): Closing credit balance as on To Date

There are some other options as well to include or exclude Period Closing Entries, show / hide accounts with zero balance and to show unclosed previous fiscal year's P&L (Income & Expenses) balances. All the figures in the report are shown in company's base currency.

Go to: Accounting > Financial Statements > Balance Sheet.

  • A Balance Sheet is the financial statement of a company which states assets, liabilities and equity at a particular point in time.

  • The Balance Sheet in ActiveBooks gives you more flexibility to analyse your financial position.

  • You can run the report across multiple year to compare values.

  • You can check values for a specific Finance Book or Cost Center.

  • You can also choose any other currency to display the balances.

Go to: Accounting> Financial Statements > Cash Flow.

  • A Cash Flow is a financial statement which shows the incoming and outgoing of cash or cash-equivalents for a company.

  • It is used to analyse the liquidity position of the company.

Go to: Accounting > Financial Statements > Profit and Loss Statement.

  • A Profit and Loss Statement is a financial statement which summarizes all the revenues and expenses in a given period.

  • The report is also known as P&L Statement.

  • In ActiveBooks, you can run the report across multiple year / period to compare the values.

  • You can also check values for a specific Finance Book, Project or Cost Center.

  • You can also choose any other currency to display the balances.

  • If you are running the report to see quarterly / monthly balances, you can choose whether you want to show accumulated balances or only for each period.

Go to: Accounting > Financial Statements > Consolidated Financial Statement.

  • The report shows a consolidated view of Balance Sheet, Profit and Loss Statement and Cash Flow for a group company, by merging financial statements of all the subsidary companies.

  • It shows balances for all individual company and as well as accumulated balances for a group company.

Go to: Accounting > Accounts Receivable/Accounts Payable> Sales Register or Purchase Register.

  • The Sales and Purchase Register report shows all the Sales and Purchase transactions for a given period with invoiced amount and tax details.

  • In this report, each taxes has a separate column, so you can easily get total taxes collected / paid for a period for each individual tax type, which helps to pay the taxes to government.

Go to: Accounting > Cost Center and Budgeting > Budget Variance Report.

  • In ActiveBooks,you can assign expense budget for an expense account against any specific cost center.

  • This report gives a comparison between budgeted and actual expenses and the variance (the difference between the two) in monthly / quarterly / yearly view.

Go to: Accounts > Accounts Receivable / Accounts Receivable > Item-wise Sales Register or Item-wise Purchase Register.

  • The Item Wise Sales and Purchase Register report shows all the Sales and Purchase transactions for a given period with item rate, quantity, amount and tax details.

  • In this report, taxes has a separate column, so you can easily get individual taxes for each individual item.

  • From this report you can have a look of which items are sold or purchase most.

More detailed analysis can also be done by using the 'Group By' filter which gives sales data for a specific Customer, Supplier, Territory, etc. You can find out which Item is more popular in which region or which Customer is buying which Item more.

Go to: Accounts > Profitability > Sales Invoice Trends or Purchase Invoice Trends.

  • Another very useful report is invoice trends, From this report you can easily get the trending items on monthly, quaterly, half yearly or yearly basis.

  • You will get the idea of sales and purchase both in quantity and amount.

  • Ordered Items To Be Billed: The report shows the items which has been ordered by customers, against which Sales Invoice has not been created / partially been created.

  • Delivered Items To Be Billed: The items which has been delivered to the customers, but Sales Invoice has not been created / partially been created.

  • Purchase Order Items To Be Billed: The report shows the items which has been ordered from the suppliers, but Purchase Invoice has not been created / partially been created.

  • Received Items To Be Billed: The items which has been received from the suppliers, but Purchase Invoice has not been created / partially been created.

Go to: Accounting > Reports > Trial Balance for Party. Usually you might need to see the trial balance for your customesrs and suppliers. You can easily get for all of your customers or suppliers and also for individual.

The report shows the credit limit, outstanding and credit balance for each customer.

2. Accounting Statements

2.1 Accounts Receivable and Accounts Payable (AR / AP)

Accounts Receivable
Accounts Receivable Based on Payment Terms
Accounts Receivable

2.2 Trial Balance

Trial Balance

2.3 Balance Sheet

Balance Sheet

2.4 Cash Flow Statement

Cash Flow

2.5 Profit and Loss Statement

Profit and Loss Report

2.6 Consolidated Financial Statements

Consolidated Financial Statements

3. Taxes

3.1 Sales and Purchase Register

Sales Register

4. Budget and Cost Center

4.1 Budget Variance

Budget Variance

6. Analytics

6.1 Item wise Sales and Purchase Register

Item Wise Sales Register
Group By Sales Register

6.2 Sales or Purchase Invoice Trends

Sales Invoice Trends

7. To Bill

8. Other Reports

8.1 Party Wise Trial Balance

Trial Balance for Party

8.2 Customer Credit Balance

Customer Credit Balance