How to Analyse Payables Report in SwilERP

Analyzing the Payables Report: Step-by-Step Guide

Process to Analyse Payables Report in SwilERP Enterprise


Effectively tracking and recording payments is important for accurate financial data. SwilERP's Payable Report offers a overview, including due balances, net amounts, and PDC amounts. Tailor your analysis by choosing specific date ranges and filtering options. The system’s flexibility allows you to dig deep into detailed records, offering insights akin to a pivot table. Below are the steps to conduct this insightful and customizable analysis.

Start with Login in SwilERP Dashboard to Initiate the Process

  1. Go to Menu> Analysis> Payables option.
Reference image:
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 Debit Note
    2. Exclude Debit Note
    3. Show Debit Note
  1. Choose Report Type "As On" and "Consider Bill upto"
  2. Select Refer By as Area Allocation, Vendor or Invoice.
  3. You can also apply filters on Account, Vendor or Refer By.
  4. Tick mark on the Auto Adjustment or Consider PDC as Paid.
  5. Click on the View button.
  6. After that, you'll see the information on the screen below. Create your custom payables report by selecting the relevant field, marked with checkboxes.
  7. You can easily customize the report by rearranging fields according to your requirements using simple drag-and-drop actions.
Reference image:
Payables Window

How to Make Customizable Report

Once you've chosen all the parameters, you can tailor the report to meet your specific requirements. Follow the steps below for more detailed information on customization.
  1. In the given drag fields areas, go to any field and click on the right tab of mouse. (For example, you selected Net Amt)
  2. There you will see some options. Click on the field settings option.
Reference image:
Analysis Setting Window
  1. Next, a new window of Field Setting: Net Amt will appear.
  2. You will find various options to personalize your 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 Last amount of Net Amount.
  2. Go to Subtotals and click on the Last option.
  3. Click on OK button.
Reference image:
Subtotals Window
  1. After that, you'll see Last Net amount in the column.
Reference image:
Last Net Amount

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.
    Reference image:
    Chart Window
    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.
    Reference image:
    Raw Data Window

    How to Save Customized Report

    To save your customized report, follow the steps below.
    1. Provide the desired name for saving this report.
    2. Click on the Save button.
    Reference image
    Save Window
    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 Payables report.
      2. Select the Date as you selected before.
      3. Select the Report name and click on the Open button.
    Reference image:
    Saved Window



        • Related Articles

        • Payables Ageing Report

          How to View Payables Ageing Report in SwilERP (RetailGraph) Meaning of Payable Ageing The payable ageing report is an important document that summarizes invoices owed by a business and the due date of vendor payments. It shows columns with amounts ...
        • Reconcile Payables

          How to reconcile payables in SwilERP (RetailGraph) What is a Reconcile Payables? The payables reconciliation process is used to clear your due amount of vendors. This report will show the list of due payments, or you can select a particular vendor or ...
        • Payable Details

          How to View Payable Details in SwilERP (RetailGraph) What is the meaning of payables? A payable report is an ongoing process of tracking and recording all payments by a business, big or small, to ensure accurate financial data. Payable reports cover ...
        • Setup Guide of SwilERP (RetailGraph)

          How to Setup SwilERP (RetailGraph) Software in your System Introduction of RetailGraph Introduce the RetailGraph as an all-in-one solution for the Retail and Distribution business. With RetailGraph, It is significantly easier to operate sales, ...
        • View Adjustment Report

          How to view Adjustment Report In SwilERP (RetailGraph) The Inventory Adjustment report provides information about the adjustments you make to on-hand quantities of products and quantities, including the amount of the adjustment, and the remarks for ...