How to Prepare Ageing Analysis Report in Gridlex Sky?

Published | Aug. 22, 2023, 12:50 p.m.


Ageing reports are financial reports that show the outstanding balances of a company's accounts receivable/payables. Gridlex Sky offers different Ageing reports such as Accounts Receivable Ageing, Accounts Payable Ageing and Inventory Ageing. With the help of these reports, you can view the total outstanding due from the customer and due to the vendor. In addition, this report can be used to follow up with customers who have outstanding receivables. The report is typically broken down into 15-Days, 30-Days, 45-days, and >45-Days categories. This will allow you to view the customers who are delinquent on their payments and by how much. Furthermore, users can view inventory ageing reports.



If you need any help with any feature, data migration of your old accounting data, questions on Chart of Accounts (COA) or anything at all, just email apps@gridlex.com, and our team of expert accountants will be here to help you. Remember, that one of Gridlex’s core values is Customer Success. We want you to be successful.
 

Inventory Reports in Gridlex Sky


Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select the “Inventory Summary” option mentioned in Inventory Reports module. 



Step 2: Here, users can view a list of inventory items and details like the opening quantity, stock on (+ve) or (-ve), current quantity etc. 



Step 3: To view the details of the item, click on the item name. Users will be redirected to the Inventory List where they can view the batch added date, batch ID, available stock value, etc. 



Step 4: Gridlex Sky allows you to view Inventory Valuation Summary as well. To view it, go to Reports section >> Inventory Reports >> select Inventory Valuation Summary from the module. 



Step 5: To know more details on the item, click on the Item Name. Once you click, you can view the complete details of that particular item like batch added date, batch ID, available stock value, etc.



Ageing Reports in Gridlex Sky


Ageing reports are financial reports that show how long an asset or liability has been outstanding. These reports can be useful for tracking the age of accounts receivable (customer invoices that have not yet been paid) and accounts payable (bills that have not yet been paid), as well as other assets and liabilities.


Accounts Receivable Ageing 


Accounts Receivable Ageing Report is a financial report that shows how long customer invoices have been outstanding. This report is used to track the age of accounts receivable, which are amounts that customers owe to a business for goods or services that have been delivered but not yet paid for. Users can use this feature in Gridlex Sky to identify which customer invoices are overdue and may need follow-up action. It can also be useful for identifying any trends or patterns in payment times, which can help you better manage your cash flow.


Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select “Accounts Receivable Ageing” option mentioned in Ageing Reports module. 



Step 2: Specify filters or criteria for the report (if required), such as a specific date range. Click on “Go” to view the updated accounts receivable ageing report. Once done, download the file in PDF or Excel spreadsheet format for further analysis.



Accounts Payable Ageing


An accounts payable ageing report is a financial report that shows how long bills or other payments owed to vendors or suppliers have been outstanding. This report is used to track the age of accounts payable, which are amounts that a business owes to vendors or suppliers for goods or services that have been received but not yet paid for. Users can use this feature in Gridlex Sky to identify which bills or payments are overdue and may need follow-up action. It can also be useful for identifying any trends or patterns in payment times, which can help you better manage your cash flow and relationships with vendors and suppliers.


Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select “Accounts Payable Ageing” option mentioned in Ageing Reports module. 



Step 2: Specify filters or criteria for the report (if required), such as a specific date range. Click on “Go” to view the updated accounts payable ageing report. Once done, download the file in PDF or Excel spreadsheet format for further analysis.



Inventory Ageing 


Inventory ageing reports are financial reports that show how long inventory has been held by a business. These reports can be useful for tracking the age of inventory items, which can help businesses identify slow-moving or obsolete items that may need to be sold or discarded.


Step 1: Login into your Gridlex App Suite Account and choose the entity of your choice. Go to the “Reports” tab and select “Inventory Ageing” option mentioned in Ageing Reports module. 



Step 2: Specify filters or criteria for the report (if required), such as a specific date range. Click on “Go” to view the updated inventory ageing report. Once done, download the file in PDF or Excel spreadsheet format for further analysis.



How to View Duplicate Transactions in Gridlex Sky? 


Step 1: Choose the entity of your choice. Go to Reports >> Banking Reports Module and click on Duplicate Statement Lines. 



Step 2: Here, users can view Duplicate Transactions in the statement. They can also select the account of their choice. 



Number Format Settings in Gridlex Sky


By default, the Gridlex Sky will use the number format that is set in the system preferences of the computer. However, users can usually change the number format in the software to suit their preferences or the requirements of their business.

Step 1: Choose the entity of your choice. Go to Reports >> Reports Settings and click on Number Format. 



Step 2: Here, you can view two options i.e. US Number Format and Indian Number Format. Change whatever is convenient and meets your business requirements. Once done, click on the “Save” button to submit the changes. 



Quick Tip

Gridlex Sky offers a list of shortcuts for common tasks. With the help of these quick shortcuts, users can easily navigate to account receivable and account payable page without having to scroll through other sections.

Click on “Review your Accounts Receivables” to directly view the data. 

Click on “Review your Accounts Payable” to directly view the data.