Skip to main content
R
rv15
October 3, 2020
Question

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?

  • October 3, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

C
ChristieAnn 11
October 3, 2020

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!

R
rv15Author
October 3, 2020

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.

 

Terms & ConditionsAccessibility statement