How to Analyse Receivables Reports in SwilERP Enterprise

Start with Login in SwilERP Dashboard to Initiate the Process

1. Go to Menu> Analysis> Receivables.
   

SwilERP Dashboard Window

1. Select the As on Date, till which you want to view details.
2. You can select Report Type as per your requirement:

1. Summary
   
2. Detail
   
3. Month Wise
   
4. Day Wise

1. Select the type of transaction which you want to view in your report:

1. Include Credit Note
   
2. Exclude Credit Note
   
3. Show Credit Note

1. Choose Report Type "As On" and "Consider Bill upto"
   
2. Select Refer By as Area Allocation, Customer, Sales Invoice.
   
3. You can also apply filters on Account, Customer, Refer By.
   
4. Tick mark on the Auto Adjustment or Consider PDC as Paid.
   
5. Click on the View button.
   
6. Next, the details will be displayed on the screen below. Select the relevant fields by ticking the checkboxes to create a customized receivables report.
7. You have the flexibility to rearrange fields as per your needs through simple drag-and-drop actions.
   

Analysis Window

How to Make Customizable Report

1. In the given drag fields areas, go to any field and click on the right tab of mouse. (For example, you selected PDC Amt)
   
2. There you will see some options. Click on the field settings option.
   

Select Fields Window

1. Next, a new window of Field Setting: PDC Amt will appear.
   
2. Here you'll see multiple options to customize report:

1. Filter
   
2. Subtotals
   
3. Show As
   
4. Format
   
5. Display
   
6. High Values
   
7. Low Values

1. For example, you want to see average amount of PDC transaction.
   
2. Go to Subtotals and click on the Average option.
   
3. Click on OK button.

Field Setting Window

1. After that, you'll see average PDC amount average in the column.
   

Average Amount Window

Report View in Graphical Format

1. Select the Chart tab to visualize the report in a graphical format.
2. In this section, you will find a visual representation of the report, displaying every detail graphically.
   

Chart View

1. You can also view the report in Raw Data, where you can find every detail.
2. Click on the raw data and there you will see receivables report.

Raw Data Window

How to Save Customized Report

1. Provide the desired name for saving this report.
   
2. Click on the Save button.
   

Save Report

1. You can export the report by choosing the saved report name from the column above.
2. Choose the report name and click on Export. Similarly, you can import the exported report using the Import option.
   
3. To reopen the report in the future, follow these steps:

1. Open the Receivables report.
   
2. Select the Date as you selected before.
   
3. Select the Report name and click on the Open button.

Saved Report