cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
rv15
Level 1

Banks want Quarterly Ageing Statement of 0-30/31-60/61-90 Days Ageing Statement from Date of Invoice. I can't find that Report in Quick Books. Can anyone help?

 
2 Comments 2
ChristieAnn
QuickBooks Team

Banks want Quarterly Ageing Statement of 0-30/31-60/61-90 Days Ageing Statement from Date of Invoice. I can't find that Report in Quick Books. Can anyone help?

Hi there, rv15.

 

I'll provide different reports in QuickBooks to show the aging statement. You can pull up the Account Receivable ageing detail or Account Receivable ageing summary report. Then, customize the report to show the Quarterly statement.

 

Here's how:

 

  1. Click Reports on the left menu.
  2. Type Account Receivable ageing detail or Account Receivable ageing summary report in the search bar.
  3. Click the Customise button. Then, select Rows/columns drop-down arrow and checkmark the Date box.
  4. Customize the other options.
  5. Hit the Run report button.
  6. Go to the Report period drop-down arrow. Then, choose This Quarter/This Quarter to date.
  7. Click Run report.

 

 

 

For additional information on how you can customise the report to focus on the details that you want to view, you can click this article: Customise reports in QuickBooks Online.

You can also refer to this article to see steps on how you can memorise a report to save it with its current customisation settings: Memorise reports in QuickBooks Online.

 

I'll be right here to help if you need anything else. Take care and stay safe!

rv15
Level 1

Banks want Quarterly Ageing Statement of 0-30/31-60/61-90 Days Ageing Statement from Date of Invoice. I can't find that Report in Quick Books. Can anyone help?

I know where to look for Reports... I'm talking about the WRONG Data and Logic that your Code uses for generating Report.

 

This is not the first time, I'm requesting for this report. I have talked with your tele-help people many a times but they have not been able to resolve this and now you have removed call facility.

 

Please give following details to someone who understands Indian Accounting and ask them to explain this to your coding team....

 

Form Working Capital Limits calculations, Banks consider age of Invoice from the Date of Invoice. Whereas your Reports calculate Age of Invoice "After Due Date". So if my term with customer is 45 Days, you show all Bills that are not due under "Current Column" and all Invoices over Due date between "0-15 Column"  However, as per Bank format, I need to give them Total of Invoices between 0-30 days and 31-60  from the date of Invoice.

 

I'm surprised, you have Chartered Accountants on your Penal and none of them have explained to you what Ageing Definition is in context of Indian Banking regulations.