# Accounting Reports

Some of the major accounting reports are:

### 1. Company and Accounts[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#1-company-and-accounts) <a href="#id-1-company-and-accounts" id="id-1-company-and-accounts"></a>

#### General Ledger[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#general-ledger) <a href="#general-ledger" id="general-ledger"></a>

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.
* &#x20;This helps you to get a full update for all entries posted in a period against any account.&#x20;
* The result can be grouped by Account, Voucher/Transaction and Party with opening and closing balances for each group.&#x20;
* 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](https://docs.erpnext.com/files/general-ledger.png)

### 2. Accounting Statements[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#2-accounting-statements) <a href="#id-2-accounting-statements" id="id-2-accounting-statements"></a>

#### 2.1 Accounts Receivable and Accounts Payable (AR / AP)[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#21-accounts-receivable-and-accounts-payable-ar-ap) <a href="#id-21-accounts-receivable-and-accounts-payable-ar-ap" id="id-21-accounts-receivable-and-accounts-payable-ar-ap"></a>

Go to: **Accounting > Accounts Receivable**.

* These reports help you to track the outstanding amount of Customers and Suppliers.&#x20;
* It also provides ageing analysis i.e. a break-up of outstanding amount based on the period for which the amount is outstanding.

![Accounts Receivable](https://docs.erpnext.com/files/accounts-receivable.png)

**2.1.1 Accounts Receivables based on Payment terms**&#x20;

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.

![Accounts Receivable Based on Payment Terms](https://docs.erpnext.com/files/accounts-receivable-based-on-payment-terms.png)

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.

![Accounts Receivable](https://docs.erpnext.com/files/accounts-receivable-2.png)

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

#### 2.2 Trial Balance[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#22-trial-balance) <a href="#id-22-trial-balance" id="id-22-trial-balance"></a>

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.

![Trial Balance](https://docs.erpnext.com/files/trial-balance.png)

#### 2.3 Balance Sheet[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#23-balance-sheet) <a href="#id-23-balance-sheet" id="id-23-balance-sheet"></a>

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.&#x20;
* You can run the report across multiple year to compare values.&#x20;
* You can check values for a specific Finance Book or Cost Center.&#x20;
* You can also choose any other currency to display the balances.

![Balance Sheet](https://docs.erpnext.com/files/balance-sheet-report.png)

#### 2.4 Cash Flow Statement[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#24-cash-flow-statement) <a href="#id-24-cash-flow-statement" id="id-24-cash-flow-statement"></a>

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.&#x20;
* It is used to analyse the liquidity position of the company.

![Cash Flow](https://docs.erpnext.com/files/cash-flow-report.png)

#### 2.5 Profit and Loss Statement[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#25-profit-and-loss-statement) <a href="#id-25-profit-and-loss-statement" id="id-25-profit-and-loss-statement"></a>

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.&#x20;
* The report is also known as P\&L Statement.
* In ActiveBooks, you can run the report across multiple year / period to compare the values.&#x20;
* You can also check values for a specific Finance Book, Project or Cost Center.&#x20;
* You can also choose any other currency to display the balances.&#x20;
* 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.

![Profit and Loss Report](https://docs.erpnext.com/files/profit-and-loss-report.png)

#### 2.6 Consolidated Financial Statements[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#26-consolidated-financial-statements) <a href="#id-26-consolidated-financial-statements" id="id-26-consolidated-financial-statements"></a>

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.&#x20;
* It shows balances for all individual company and as well as accumulated balances for a group company.

![Consolidated Financial Statements](https://docs.erpnext.com/files/consolidated-financial-statement.png)

### 3. Taxes[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#3-taxes) <a href="#id-3-taxes" id="id-3-taxes"></a>

#### 3.1 Sales and Purchase Register[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#31-sales-and-purchase-register) <a href="#id-31-sales-and-purchase-register" id="id-31-sales-and-purchase-register"></a>

Go to: **Accounting > Accounts Receivable/Accounts Payable> Sales Register&#x20;*****or*****&#x20;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.
* &#x20;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.

![Sales Register](https://docs.erpnext.com/files/sales-register.png)

### 4. Budget and Cost Center[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#4-budget-and-cost-center) <a href="#id-4-budget-and-cost-center" id="id-4-budget-and-cost-center"></a>

#### 4.1 Budget Variance[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#41-budget-variance) <a href="#id-41-budget-variance" id="id-41-budget-variance"></a>

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.&#x20;
* This report gives a comparison between budgeted and actual expenses and the variance (the difference between the two) in monthly / quarterly / yearly view.

![Budget Variance](https://docs.erpnext.com/files/budget-variance-report.png)

### 6. Analytics[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#6-analytics) <a href="#id-6-analytics" id="id-6-analytics"></a>

#### 6.1 Item wise Sales and Purchase Register[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#61-item-wise-sales-and-purchase-register) <a href="#id-61-item-wise-sales-and-purchase-register" id="id-61-item-wise-sales-and-purchase-register"></a>

Go to: **Accounts > Accounts Receivable / Accounts Receivable > Item-wise Sales Register&#x20;*****or*****&#x20;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.&#x20;
* 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.

![Item Wise Sales Register](https://docs.erpnext.com/files/item-wise-sales-report.png)

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.

![Group By Sales Register](https://docs.erpnext.com/files/group-by-sales-register.png)

#### 6.2 Sales or Purchase Invoice Trends[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#62-sales-or-purchase-invoice-trends) <a href="#id-62-sales-or-purchase-invoice-trends" id="id-62-sales-or-purchase-invoice-trends"></a>

Go to: **Accounts > Profitability > Sales Invoice Trends&#x20;*****or*****&#x20;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.&#x20;
* You will get the idea of sales and purchase both in quantity and amount.

![Sales Invoice Trends](https://docs.erpnext.com/files/sales-invoice-trends.png)

### 7. To Bill[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#7-to-bill) <a href="#id-7-to-bill" id="id-7-to-bill"></a>

* **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.

### 8. Other Reports[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#8-other-reports) <a href="#id-8-other-reports" id="id-8-other-reports"></a>

#### 8.1 Party Wise Trial Balance[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#81-party-wise-trial-balance) <a href="#id-81-party-wise-trial-balance" id="id-81-party-wise-trial-balance"></a>

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.

![Trial Balance for Party](https://docs.erpnext.com/files/party-wise-trail-balance.png)

#### 8.2 Customer Credit Balance[ ](https://docs.erpnext.com/docs/v13/user/manual/en/accounts/accounting-reports#82-customer-credit-balance) <a href="#id-82-customer-credit-balance" id="id-82-customer-credit-balance"></a>

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

![Customer Credit Balance](https://docs.erpnext.com/files/customer-credit-balance.png)
