New Detailed Aged Supplier Balance Report

The Aged Supplier Report will generate reports regarding the amount payable to your Supplier. The account payable arises when goods or service are purchased on credit. Surf Accounts provide a dynamic feature where you can generate the Aged Supplier Report on a periodical structure. The aging balance report will list each Supplier’s outstanding balance and will then sort the total amount into columns such as Current, 30 days past due, 60 days past due, 90 days past due 120 days past due and so on. The objective of the Report allows the user or the account manager to have a quick look on the entire outstanding invoices of the Suppliers.

We have enhanced the Aged Creditors Report by introducing a new feature “Show Detailed Breakdown”. Under the ‘Advance’ option, a new tick box has been introduced under Features “Show Detailed Breakdown”. 

  • Generating the Aged Supplier Balances Report

To generate the Aged Supplier Balances Report select Reports> Supplier> Aged Supplier Balances the following screen will appear.

NEW_DETAILED_AGED_CREDITORS_REPORT_IMAGE_1.jpg
 
  • Generating the Aged Supplier Balances Report: 
  • To Date: To generate the aged Supplier report you can select the Date column to specify the period. For e.g. if you wish to generate the report on a particular date, select the date by using the calendar. By keeping the date range blank it will generate the report till date. In the report the current date will appear as “Date Range”. 
  • Supplier: To generate the aged Supplier report Supplier wise select the name of the Supplier by using the Supplier lookup button. You can select multiple Suppliers in this report. To generate the Report of Aged Supplier of all the Suppliers leave the “Supplier” column blank.   
  • Advanced: Select the ‘Advanced’ button to include or exclude columns in the Aged Supplier Balances Report. 
  • Currency: If your business consists of multi currency transaction, you can sort the report currency wise. 
NEW_DETAILED_AGED_CREDITORS_REPORT_IMAGE_2.jpg
 
  • Customisation of the Aged Supplier Balances Report:

From the ‘Advance’ setting, you can include or exclude different columns to customise the report as per your business requirement. This includes the “Currency Code”, “Currency Balance”, “Currency Adjustment”,  ‘Unallocated’, “ Code”, “ Name”, “ Balance” and the columns for the outstanding period (for e.g. 30 days, 60 days, 90 days, 120 days, 150 days and 180 days). Select the column as per your business requirement so that the Suppler Aged Balances can display the relevant information.

 
  • Sorting of Report: 

You can sort the report by the ‘Code’, ‘Name’ ‘Balance’ and ‘Currency’ of the report.

 
  • Features:

If the invoices are already paid and not appear under the outstanding column, then by selecting “Suppress Zero Balances” the invoices will not appear in the “Aged Supplier Balances Report” as it is already allocated with a Payment.

 
  • Show Detailed Breakdown: 

We have introduced this new option to show the detailed breakdown of invoices and payments. A tick box has been introduced under the sort option as “Show Detailed Breakdown”. By default, this tick box will be un-ticked.   

NEW_DETAILED_AGED_CREDITORS_REPORT_IMAGE_3.jpg

If “Show Detailed Breakdown” is ticked from the ‘Advance’ option the report will show a breakdown of the invoice amount, Net, VAT, Gross and the Outstanding along with the periodical aging.

  • The Balance amount derived as Total Aging- Unallocated Amount.
  • Balance will be calculated as (Total Aging- Unallocated Amount). As unallocated is in general in negative the calculation methodology becomes Total Aging + (-Unallocated) = Total Aging-Unallocated.
  • The VAT on payment will be 0.00.
  • Code: This determines the Supplier Code. 
  • Name: The name of the Supplier is shown under this column. 
  • Current: The Gross Amount of Invoice of the transaction of a particular supplier will be shown under Current Column.  
  • Balance: The Balance Amount will be equal to the Outstanding Amount. The balance amount includes the amount of Purchase Invoice, Credit note, Payment, Negative Payment, Opening Supplier Invoice. It does not include the amount of non- supplier payment and opening balance journal. 
  • Aging: The gross amount of the Invoice is shown under the Aging column depending upon the number of days of Aging i.e. 30 days, 60 days, 90 days and so on. 
  • VAT: The VAT amount is calculated as (Invoice Gross Amount- Credit Note Gross Amount i.e. the unallocated amount). When a discount is allowed in a transaction the VAT will be calculated as VAT= (Invoice VAT)/ (Invoice Gross) * (Invoice Gross) – (allocated amount+ discount amount).  
  • Currency Adjustment: The calculation methodology of the currency adjustment will be as follows:
    (Allocated Amount  of Invoice * conversion rate of transaction date)+[ -(Allocated amount of credit note or payment * conversion rate of transaction date)]
See below: 
NEW_DETAILED_AGED_CREDITORS_REPORT_IMAGE_4.jpg
 

Toolbar functionality of the Aged Supplier Balances Report: 

To Print, Save, Email the “Aged Supplier Balances Report”, select the option from the Toolbar of the “Aged Supplier Balances Report”.

The “Aged Supplier Balances Report” can be saved as a PDF file to the local machine. You can also download the report in .xls file by selecting MS-Excel option.

By using the Toolbar of the “Aged Supplier Balances Report” browse can print, download in MS-Excel format, Save to your local machine as PDF and Email the report.

NEW_DETAILED_AGED_CREDITORS_REPORT_IMAGE_5.jpg

Print the Aged Supplier Balances Report:

To print the “Aged Supplier Balances Report”, select the Print icon from the toolbar of the reporting browse. A preview will be generated along with a ‘Print’ icon the following screen will appear.

NEW_DETAILED_AGED_CREDITORS_REPORT_IMAGE_6.jpg

Excel:

To download the “Aged Supplier Balances Report” in MS Excel format, select the ‘Excel’ option and the report will be downloaded in the local machine in Excel (Spreadsheet) format.

NEW_DETAILED_AGED_CREDITORS_REPORT_IMAGE_7.jpg
Save:

To save the Aged Supplier Balances Report choose the ‘Save’ option from the toolbar and the report will be downloaded to your local machine in PDF format.

NEW_DETAILED_AGED_CREDITORS_REPORT_IMAGE_8.jpg

Email:

To send the Aged Supplier Balances Reports through email select the ‘Email’ option of the toolbar. A pop up will be generated.

  • To: Enter the email address of the recipient.
  • CC/ BCC: Enter the email address if you wish to send a copy of the report.
  • Subject: Enter the subject line in the mail dialogue box.
NEW_DETAILED_AGED_CREDITORS_REPORT_IMAGE_9.jpg

Open the attached PDF to view the Aged Supplier Balances Report.  

 
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk