cancel
Showing results for 
Search instead for 
Did you mean: 
des5
Level 1

When i run a debtor statement as a transaction statement, open item, it only gives me the last 365 days. how do i do this for all periods?

 
1 Comment 1
KhimG
QuickBooks Team

When i run a debtor statement as a transaction statement, open item, it only gives me the last 365 days. how do i do this for all periods?

Good day, @des5.


The Open Item Statement in QuickBooks Online can only show unpaid invoices from the last 365 days. You can achieve your goal of generating the list of open sales transactions for all periods by running the Transaction Statement instead. 


Here's how:

  1. Click the + New button and choose Statement.
  2. Pick Transaction Statement in the Statement Type drop-down.
  3. Choose a Statement Date.
  4. In the Customer balance Status, select Open.
  5. Enter a Start Date and End Date.
  6. Hit Apply.

Statement 1.PNGStatement 2.PNG

 

I’m adding this article for the details: Create and view customer statements.


Another way to view the list of open transactions from customers is by running the Accounts Receivable Ageing Detail Report. Filter the Report period to show all the entries.


Follow these steps:

  1. From the Reports menu, scroll down to the Who owes you section and click Accounts receivable ageing detail.
  2. In the Report period drop-down, pick All Dates
  3. Choose an Ageing method and fill out the Days per ageing period, Number of periods, and Min. Days Past Due boxes. 
  4. Hit Run report.

AR 1.PNGAR 2.PNG

 

Check out this article about pulling up reports in QBO: Run reports.


If there’s anything else you need, let me know in the comment section. I’m here to help. Have a great day!