Standard Accounting Reports

Outline

Company and Accounts

1. General Ledger

Accounting Statements

1. Accounts Receivable and Accounts Payable
2. Trial Balance
3. Balance Sheet
4. Cash Flow Statement
5. Profit and Loss Statement (P&L Statement)
6. Consolidated Financial Statements

Taxes

1. Sales and Purchase Register

Budget and Cost Center

1. Budget Variance

Analytics

1. Item-Wise Sales and Purchase Register
2. Sales or Purchase Invoice Trends

To Bill

1. Received Items to be Billed
2. Delivered Items to be Billed

Other Reports

1. Trial Balance for Party
2. Customer Credit Balance

IMPORTANT NOTE: Many of these reports can also be accessed and viewed in the Accounting Dashboard

Company and Accounts 

1. General Ledger 

1. Select Accounting, then choose General Ledger from shortcut section 
2. Detailed report of every transaction posted to each Account 
3. For every transaction there is a Credit and Debit Account 
4. Based on the table GL Entry 
5. You can filter based on pre-defined filters 
6. i.e. Account, Party, and Period 
7. The result can be grouped by Account, Transaction, and Party 
8. This will include opening and closing balances for each group 

Accounting Statements 

1. Accounts Receivable (AR) and Accounts Payable (AP) 

1. Choose Accounting from home screen and each report will be under its respective heading 
2. These reports help track the outstanding balances of Customers and Suppliers 
3. Also provides and Ageing Analysis 
4. This is a breakup of the outstanding amount based on the period for which it is outstanding 
5. You can select Based on Payment Terms 
6. This will show you the outstanding amount against each payment term 
7. Invoiced Amount shows each payment term amount 
8. Payment Amount shows payment amount for each term 

2. Trial Balance 

1.  Choose Accounting from the home screen and then Trial Balance from the shortcuts 
2. Accounting report which lists account balances for all your Accounts (“Ledger” and “Group”) for any given reporting period 
3. Purpose is to make sure the bookkeeping is correct 
4. The totals of the Debit and Credit columns must be the same for any given period 
5. Options: 
6. Include or exclude Period Closing entries 
7. Show/Hide accounts with zero balances 
8. Show unclosed previous fiscal year’s P&L (Income and Expenses) balances 

3. Balance Sheet  

1. Choose Accounting from home screen and select Balance Sheet from under Financial Statements 
2. Financial statement of the company stating Assets, Liabilities and Equity at a specific point in time 
3. You can run the report across multiple years to compare amounts 

4. Cash Flow Statement  

1. Choose Accounting from home screen and select Cash Flow from under Financial Statements 
2. Shows the incoming and outgoing of cash 
3. Used to analyze the liquidity of a company 

5. Profit and Loss Statement (P&L Statement) 

1. Choose Accounting from home screen and select Profit and Loss Statement from under Financial Statements 
2. Summarizes all the revenues and expenses in a given period 
3. You can run the report across multiple years/periods and compare the amounts 
4. If you are running the report to see quarterly/monthly balances, you can decide to show accumulated balances or just for the period. 

6. Consolidated Financial Statements  

1. Choose Accounting from home screen and select Consolidated Financial Statements from under Financial Statements 
2. This shows a combined view of Balance Sheet, Profit and Loss Statement, and Cash Flow 

Taxes 

1. Sales and Purchase Register  

1. Choose Accounting from home screen and select Sales Register from under Accounts Receivable, or Purchase Register from under Accounts Payable  
2. This report shows the sales and purchase transactions made in a given time period with invoice amounts and tax details 
3. The benefit is that each tax is in a separate column so you can easily get the totals 

Budget and Cost Center 

1. Budget Variance  

1. Choose Accounting from home screen and select Budget Variance Report from under Cost Center and Budgeting 
2. This report gives a comparison between the budgeted amount and the actual expenses and the variance (difference between the two) 

Analytics 

1. Item-Wise Sales and Purchase Register  

1. Choose Accounting from home screen and select Item-Wise Sales Register from under Accounts Receivable, or Item-Wise Purchase Register from under Accounts Payable  
2. This shows all the sales and purchase transactions for a given period and includes item rate, quantity, amount, and tax details. 
3. You can see which items you have sold or purchased the most 
4. You can use the Group feature to get more specific information 
5. Get specific sales data for a particular Customer, Supplier, Territory, etc. 
6. Find out which items or popular in which regions, or which Customer is buying which item more 

2. Sales or Purchase Invoice Trends  

1. Choose Accounting from home screen and select Sales Invoice Trends or Purchase Invoice Trends from under Profitability  
2. You can see the most popular items on monthly, quarterly, half-yearly or yearly basis 
3. Shows Sales and Purchase in both quantity and dollar amount 

To Bill 

1. Received Items to be Billed  

1. Choose Accounting from home screen and select Received Items To Be Billed from under Accounts Payable  
2. Items that have been received from the supplier, but no Purchase Invoice has been created, or was only partially created. 

2. Delivered Items to be Billed  

1. Choose Accounting from home screen and select Delivered Items To Be Billed from under Accounts Receivable 
2. Items that have been delivered to customers, but no Sales Invoice has been created, or was only partially created. 

Other Reports 

1. Trial Balance for Party  

1. Choose Accounting from home screen and select Trial Balance for Party from under Reports 
2. For bookkeeping purposes, you can check the Debit and Credit amounts for all customers or suppliers, or for individuals 

2. Customer Credit Balance  

1. Choose Accounting from home screen and select Customer Credit Balance from under Reports 
2. Shows the credit limit, outstanding balance, and credit balance for each customer