Report Designer





The Report Designer provides a guided flow for customized report creation and generation in ERP2ALL. Selection of the data source, selection of the report type, configuration, and styling of the report are presented in the successive tabs this module. 



Go to Account & Finance (AF) & click on Reports

Select Report designer from the drop-down menu



The landing page will be displayed that has two sections as displayed below:

 


Profit and Loss Format

Major groups in this section are given as Sales, Purchase, Direct Expenses and Indirect Expenses. Select any one you want to modify. Follow the extreme right table where you can add /edit /delete ledger account. To add from the nominal ledger account drop-down list with the order you want. Click on save. Any omission will be automatically reported on the top.

Balance Sheet Format

This Section deals with configuring the information to be displayed in the Balance Sheet Report. The major group is given as Fixed Assets, Current Assets Account, Current Liabilities Account, Long-term Liabilities Account, and Capital Account. Select any one you want to modify. Follow the extreme right table where you can add /edit /delete ledger account. To add selected from the nominal ledger account drop-down list with the order you want. Click on save. Any omission will be automatically reported on the top. So, you can't go away without correcting it. Edit or delete function is straightforward and is only needed if there is any error or omission.

Profit and Loss Format



A Sales account contains the record of all sales transactions. This includes both cash and credit sales. The account total is then paired with the sales returns and allowances account to derive the net sales figure that is listed in the income statement. The sales account can also refer to a current customer. Once sales are made to a customer, it is known as a sales account. 
A Purchase account represents the purchase of goods i.e. in case of a trading concern, those which are traded and in case of a manufacturing concern, the raw material. Purchase account is of revenue nature, meaning that it isn't a capital item. It is something that happens every year. This can help one to conclude that it is Profit and Loss item and not a Balance Sheet item. 
Direct expense Accounts are accounts which contains the expenses that are incurred which vary directly with changes in the volume of a cost object. A cost object is any item for which you are measuring expenses, such as products, product lines, services, sales regions, employees,
Indirect expenses Accounts are accounts that contain expenses that are incurred to operate a business as a whole or a segment of a business, and so cannot be directly associated with a cost object, such as a product, service, or customer. A cost object is any item for which you are separately measuring costs. 


New Sales Account Creation


Go to the Profit & Loss Format

And Click on Sales Accounts

First, select and Save the Parent account from the drop-down menu



Then, Click on Add New

 


The Sales Account details will be displayed:


Sales Account Details:

Account: Select the Account name.

Click on Save to insert the Sales account details.


To Edit


Select an existing Sales Account from the list & click on the Edit Button to display the details for modification purposes.

 

 

Deletion


Select a Sales Account from the list and then, click on Delete. Click "OK" to confirm the deletion.




To Export


Select an existing Sales Account from the list & click on Export 



The file export options will be displayed in the drop-down menu :

Export Details:

Print/pdf option: Select print or download as PDF as required.

Click on To Excel to download an excel spreadsheet to the desktop.

Click on To CSV to download a comma-separated values spreadsheet to the desktop.



New Purchase Account Creation


Click on Purchase Accounts

First, select and Save the Parent account from the Drop-down menu.

Finally, Click on Add New



The Purchase Account form details will be displayed

Purchase Account Details:

 

Account: Select the Account name.

Click on Save to insert the Purchase account details.


To Edit


Select an existing Purchase Account & click on the Edit Button to display the details for modification purposes.



Deletion


Select a Purchase Account & click on t Delete. Click "OK" to confirm the final deletion.




To Export


Select a Purchase Account & Click on the Export Button.

 


The file export options will be displayed in the drop-down menu.

Export Details:

Print/pdf option: Select print or download as PDF as required.

Click on To Excel to download an excel spreadsheet to the desktop.

Click on To CSV to download a comma-separated values spreadsheet to the desktop.


New Direct Expense Account Creation


Click on Direct Expense Accounts

First, Set & Save the Parent account from the Drop-down menu




The Direct Expense Account form details will be displayed

Direct Expense Details:

 

Account: Select the Account name.

Click on Save to insert the Direct Expense account details.


To Edit 


Select an existing Direct Expense Account & click on the Edit Button to display the details for modification purposes.




Deletion


Select a Direct Expense Account & click on t Delete. Click "OK" to confirm the final deletion.




To Export


Select an existing Direct Expense Account  & click on the Export Button

 


The file export options will be displayed in the drop-down menu.

Export Details:

Print/pdf option: Select print or download as PDF as required.

Click on To Excel to download an excel spreadsheet to the desktop.

Click on To CSV to download a comma-separated values spreadsheet to the desktop.


Indirect expense Account creation


Click on Indirect Expense Accounts

First, select and Save the Parent account from the Drop-down menu




The Indirect Expense Account form details will be displayed

 

Indirect Expense Details:

 

Account: Select the Account name.

Save: Click to insert Indirect Expense account details.


To Edit

 

Select an existing Indirect Expense Account & click on the Edit Button to display the details for modification purposes.



Deletion


Select an Indirect  Expense Account & click on t Delete. Click "OK" to confirm the final deletion.

Deletion:




To Export


Select an existing Indirect Expense Account from the list & click on the Export Button

 


The file export options will be displayed in the drop-down menu.

Export Details:

Print/pdf option: Select print or download as PDF as required.

Click on To Excel to download an excel spreadsheet to the desktop.

Click on To CSV to download a comma-separated values spreadsheet to the desktop.







Balance Sheet Format



Fixed Asset Accounts 

Fixed assets include equipment, vehicles, machinery, and even computers. These assets generally have a useful life of more than one year and are usually more expensive business purchases. Assets accounts generally have a debit balance. This means that entries created on the left side (debit entries) of an asset T-account increase the asset account balance while journal entries created on the right side (credit entries) decrease the account balance.

Current Assets Accounts

 Current Assets are a balance sheet account that represents the value of all assets that can reasonably expect to be converted into cash within one year. Current Asset Accounts that are considered current assets include cash and cash equivalents, marketable securities, accounts receivable, inventory, prepaid expenses, and other liquid assets.

Current Liability Accounts 

A current liability is an obligation that must be repaid within the current period or the next year whatever is longer. In other words, it’s a short-term loan or long-term debt that will become due in the next 12 months and require payment of current assets.

Capital Accounts

These are a business's capital accounts contain the value of how much it owes to its owners. A debit to a capital account means the business doesn't owe so much to its owners (i.e. reduces the business's capital), and a credit to a capital account means the business owes more to its owners (i.e. increases the business's capital).





To create a new Fixed Assets Account entry:




The Fixed Assets Accounts form details will be displayed.



Fixed Assets Details:

 

Account: Select the Account name.

Click on Save to insert the Fixed Assets account details.


To Edit 



Deletion: 



To Export


The export options will be displayed in the drop-down menu.




Export Details:

Print/pdf option: Select print or download as PDF as required.

Click on To Excel to download an excel spreadsheet to the desktop.

Click on To CSV to download a comma-separated values spreadsheet to the desktop.


To create a new Current Assets Account




The Current Assets Accounts form details will be displayed.

 


Current Assets Details:

 

Account: Select the Account name.

Click on Save to insert the Current Assets account details.




To Edit 



Deletion: 

 


To Export


The export options will be displayed in the drop-down menu.


Export Details:

Print/pdf option: Select print or download as PDF as required.

Click on To Excel to download an excel spreadsheet to the desktop.

Click on To CSV to download a comma-separated values spreadsheet to the desktop.

 



To create a new Liability Account entry:





The Current Liability Accounts entry details will be displayed.

 

Current Liability Accounts Details:

Account: Select the Account name.

Click on Save to insert the Current Liabilities account details.


To Edit



Deletion 

 


To Export

The export options will be displayed in the drop-down menu.


Export Details:

Print/pdf option: Select print or download as PDF as required.

Click on To Excel to download an excel spreadsheet to the desktop.

Click on To CSV to download a comma-separated values spreadsheet to the desktop.

 

 

To create a new long-term  Liability Account entry: 






Long-term Liability Accounts Details:

 

Account: Select the Account name.

Click on Save to insert the Long-term Liabilities account details.




To Edit



Deletion:



To Export

The export options will be displayed in the drop-down menu.


Export Details:

Print/pdf option: Select print or download as PDF as required.

Click on To Excel to download an excel spreadsheet to the desktop.

Click on To CSV to download a comma-separated values spreadsheet to the desktop.

 


 New Capital Account entry: 



The Capital Accounts details will be displayed.


The Capital Accounts Details:

 

Account: Select the Account name.

Click on Save to insert the Capital account details.




 

To Edit 



Deletion: 



To Export

The export options will be displayed in the drop-down menu.


Export Details:

Print/pdf option: Select print or download as PDF as required.

Click on To Excel to download an excel spreadsheet to the desktop.

Click on To CSV to download a comma-separated values spreadsheet to the desktop.