New Detailed Aged Customer Balance Report

The Aged Customer Balances Report will generate reports regarding the amount receivable from your customer. The account receivable arises when goods or services are provided on credit. Surf Accounts provides a dynamic feature where you can generate the Aged Customer Report on a periodical structure. The aging balance report will list each customer’s outstanding balance and then will 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 look on the entire outstanding invoices to the customer. 

We have enhanced the Details Aged Debtors 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 Customer Balances Report

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

Generating the Aged Customer Balances Report: 

• To Date:To generate the aged customer report you can select the Date column to specify the period. For e.g. if you wish to generate the report on a particular day 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”. 

• Customer :To generate the aged customer report customer wise select the name of the customer by using the Customer lookup button. You can select multiple customers in this report. To generate the report of Aged Customer Report of all the customers leave the ‘Customer’ column as blank.  

• Account Manager : To generate the report “Account Manager” wise select the name of the “Account Manager” if there is multiple account managers from the drop down. By keeping the account manager column blank, the complete report will be generated irrespective of the Account Manager.  

• Advanced: Select the ‘Advanced’ button to include or exclude columns in the Aged Customer Balances Report. 

• Currency: If your business consists of multi currency transaction, you can sort the report currency wise. 

• Customisation of the Aged Customer 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 “Account Manager”, ‘Unallocated’, “Customer Code”, “Customer Name” Current 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 Customer Aged Balance can display the relevant information.

• Sorting of Report: 

You can sort the report by the “Customer Code”, “Account Manager”, “Customer’s Name”/ and the ‘Balance’ 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 “Customer Aged Report” as it is already allocated with a Receipt.

• Show Detailed Breakdown: 

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

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 receipt will be 0.00.

• Code: This determines the Customer Code. 

• Name: The name of the Customer is displayed under this column. 

• Current: The Gross Amount of Invoice of the transaction of a particular customer will be shown under Current Column.  

• Balance: The Balance Amount will be equal to the Outstanding Amount. The balance amount includes the amount of Sales Invoice, Credit note, Receipt, Negative Receipt, Opening Customer Invoice and Recurring Sales Invoice. It does not include the amount of non- customer receipt/ 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 receipt * conversion rate of transaction date)]

• Toolbar functionality of the Aged Customer Balances Report: 

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

The “Aged Customer 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 Customer Balances Report” browse can print, download in MS-Excel format, Save to your local machine as PDF and Email the report.

• Print the Aged Customer Balances Report:

To print the “Aged Customer 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.

• Excel:

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

• Email:

To send the Aged Customer 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.

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

• Click here for New Detailed Aged Supplier Balance Report